qimall/addons/Store/install.sql

CREATE TABLE `qimall_addons_store` (
       `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `mall_id` int(11) NOT NULL DEFAULT '0',
       `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '绑定会员id',
       `shop_owner` varchar(255) NOT NULL DEFAULT '' COMMENT '店长姓名',
      `shop_mobile` varchar(11) NOT NULL DEFAULT '' COMMENT '店长手机号',
       `store_name` varchar(255) NOT NULL DEFAULT '' COMMENT '门店名称',
       `c_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店分类',
       `store_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '门店简介',
       `logo_img` varchar(255) NOT NULL DEFAULT '' COMMENT '门店logo',
       `license_img` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照',
       `province_id` int(11) DEFAULT '0' COMMENT '省',
       `city_id` int(11) DEFAULT '0' COMMENT '市',
       `district_id` int(11) DEFAULT '0' COMMENT '区',
       `address` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
       `expire_time` bigint(20) NOT NULL DEFAULT '0' COMMENT '失效时间，0代表无限期',
       `total_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '累计收入',
       `balance` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '当前余额',
       `total_expenses` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '累计支出',
       `user_nums` int(11) DEFAULT '0' COMMENT '会员总数',
       `longitude` varchar(255) NOT NULL DEFAULT '' COMMENT '经度',
       `latitude` varchar(255) NOT NULL DEFAULT '' COMMENT '维度',
       `check_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '审核状态：0：待审核；1：已通过；2：未通过',
       `check_remark` varchar(255) NOT NULL DEFAULT '' COMMENT '审核备注',
       `business_time_start` varchar(255) NOT NULL DEFAULT '' COMMENT '营业时间开始',
       `business_time_end` varchar(255) NOT NULL DEFAULT '' COMMENT '营业时间结束',
       `store_style` tinyint(1) NOT NULL DEFAULT '1' COMMENT '门店样式 1：样式1；2：样式2',
       `store_background` varchar(255) NOT NULL DEFAULT '' COMMENT '门店背景',
       `commission_authority` varchar(255) NOT NULL DEFAULT '' COMMENT '分佣/营销权限',
       `share_title` varchar(255) NOT NULL DEFAULT '' COMMENT '分享标题',
       `share_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '分享描述',
       `share_pic` varchar(255) NOT NULL DEFAULT '' COMMENT '分享图片',
       `freight_type` varchar(255) NOT NULL DEFAULT '' COMMENT '配送设置',
       `intra_city_distribution` varchar(500) NOT NULL DEFAULT '' COMMENT '同城配送',
       `total_order_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '订单总金额',
       `total_num` int(11) NOT NULL DEFAULT '0' COMMENT '总数',
       `total_settled_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '已结算总金额',
      `unsettled_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '未结算金额',
       `sales_volume` int(11) NOT NULL DEFAULT '0' COMMENT '销量',
       `praise` decimal(3,1) NOT NULL DEFAULT '5.0' COMMENT '评分',
       `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
       `shop_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '门店营业状态，1：正在营业；0：休息中',
       `scan_code_bind` tinyint(1) NOT NULL DEFAULT '0' COMMENT '门店收款码-扫码绑定开关：0：否；1：是',
       `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
       `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
       PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店';

CREATE TABLE `qimall_addons_store_admin` (
   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
   `username` varchar(50) NOT NULL DEFAULT '' COMMENT '登录账号',
   `account` varchar(50) NOT NULL DEFAULT '' COMMENT '账号名称',
   `password` varchar(255) NOT NULL DEFAULT '' COMMENT '密码',
   `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
   `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
   `auth_key` varchar(128) NOT NULL DEFAULT '',
   `access_token` varchar(128) NOT NULL DEFAULT '',
   `admin_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '管理员类型1超级管理员2管理员3操作员',
   `created_at` int(11) NOT NULL DEFAULT '0',
   `updated_at` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
   PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店后台管理员表';

CREATE TABLE `qimall_addons_store_bank` (
   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
   `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
   `username` varchar(50) NOT NULL DEFAULT '' COMMENT '开户名',
   `bank` varchar(255) NOT NULL DEFAULT '' COMMENT '开户银行',
   `card_no` varchar(255) NOT NULL DEFAULT '' COMMENT '银行卡号',
   `created_at` int(11) NOT NULL DEFAULT '0',
   `updated_at` int(11) NOT NULL DEFAULT '0',
   `status` tinyint(1) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
   PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店提现银行卡';

CREATE TABLE `qimall_addons_store_cashier_order` (
     `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
     `mall_id` int(11) NOT NULL DEFAULT '0',
     `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
     `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '会员id',
     `order_no` varchar(100) NOT NULL DEFAULT '' COMMENT '订单编号',
     `pay_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '支付状态：0：否；1：是',
     `pay_time` int(11) NOT NULL DEFAULT '0' COMMENT '付款时间',
     `money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '应付金额',
     `pay_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '实付金额',
     `payment_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '支付类型',
     `amount_received` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '实收金额',
     `service_money` decimal(12,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '服务费',
     `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
     `extra` varchar(255) NOT NULL DEFAULT '' COMMENT '额外信息：例如优惠信息，渠道分红，经销分红',
     `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
     `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
     `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
     PRIMARY KEY (`id`) USING BTREE,
     KEY `idx_order_no` (`order_no`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店收银订单';

CREATE TABLE `qimall_addons_store_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `parent_id` int(11) NOT NULL DEFAULT 0 COMMENT '父级ID',
  `name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `big_pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `advert_pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '广告图片',
  `advert_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '广告链接',
  `advert_open_type` varchar(65) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '打开方式',
  `advert_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '导航参数',
  `is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[0禁用 1启用 -1删除]',
  `sort` int(11) NOT NULL DEFAULT 999 COMMENT '排序',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB  CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门店分类' ROW_FORMAT = COMPACT;

CREATE TABLE `qimall_addons_store_census` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT '0',
  `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `add_user_nums` int(11) NOT NULL DEFAULT '0' COMMENT '新增会员',
  `order_nums` int(11) NOT NULL DEFAULT '0' COMMENT '订单数',
  `settlement_commission` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '结算佣金',
  `sales_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '门店销售额',
  `cashier_sales_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '收银台销售额',
  `date_time` varchar(50) NOT NULL DEFAULT '' COMMENT '日期时间',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
  `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店每日统计';

CREATE TABLE `qimall_addons_store_clerk`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `store_id` int(11) NOT NULL DEFAULT 0 COMMENT '门店id',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '会员id',
  `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT 'o2o商品id',
  `nums` int(11) NOT NULL DEFAULT 0 COMMENT '累计核销订单数',
  `total_money` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '累计核销金额',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[0禁用 1启用 -1删除]',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB  CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门店核销员' ROW_FORMAT = COMPACT;

CREATE TABLE `qimall_addons_store_clerk_log`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `store_id` int(11) NOT NULL DEFAULT 0 COMMENT '门店id',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '会员id',
  `clerk_id` int(11) NOT NULL DEFAULT 0 COMMENT '核销员id',
  `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '电话',
  `order_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单编号',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[0禁用 1启用 -1删除]',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB  CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门店核销明细' ROW_FORMAT = COMPACT;

CREATE TABLE `qimall_addons_store_commission` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
    `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
    `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '会员id',
    `order_no` varchar(100) NOT NULL DEFAULT '' COMMENT '订单编号',
    `order_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '订单金额',
    `pay_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '支付金额',
    `discount_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '优惠金额',
    `addons_bonus` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '插件分红',
    `service_charge` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '服务费',
    `amount_received` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '到账金额',
    `is_settlement` tinyint(1) NOT NULL DEFAULT '0' COMMENT '结算状态 0：待结算；1：已结算',
    `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型：1：o2o订单；2：o2o收银台订单',
    `created_at` int(11) NOT NULL DEFAULT '0',
   `updated_at` int(11) NOT NULL DEFAULT '0',
    `status` tinyint(1) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `idx_order_no` (`order_no`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店提成明细';

CREATE TABLE `qimall_addons_store_freight_rules` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城ID',
    `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
    `name` varchar(65) NOT NULL DEFAULT '' COMMENT '规则名称',
    `rule` longtext NOT NULL COMMENT '规则详情',
    `is_default` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否默认',
    `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态【1启用 0禁用 -1删除】',
    `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '计费方式【1=>按重计费、2=>按件计费】',
    `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
    `updated_at` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店运费规则';

CREATE TABLE `qimall_addons_store_goods` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
    `mall_goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '主商城goods_id',
    `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
    `goods_name` varchar(120) NOT NULL DEFAULT '' COMMENT '商品名称',
    `subtitle` varchar(150) NOT NULL DEFAULT '' COMMENT '商品副标题',
   `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '售价',
    `original_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '原价（划线价仅展示）',
    `cost_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '成本价',
    `unit` varchar(255) NOT NULL DEFAULT '件' COMMENT '单位',
    `cover_pic` varchar(255) NOT NULL DEFAULT '' COMMENT '商品缩略图',
    `bannar_pic` varchar(1500) NOT NULL DEFAULT '' COMMENT '商品展示bannar图',    `video_url` varchar(255) NOT NULL DEFAULT '' COMMENT '商品视频',
    `video_cover_pic` varchar(500) NOT NULL DEFAULT '' COMMENT '商品视频封面',
    `is_on_sale` smallint(1) NOT NULL DEFAULT '0' COMMENT '上架状态【1是 0否】',
    `is_attr` smallint(1) NOT NULL DEFAULT '0' COMMENT '是否有规格【1是 0否】',
    `attr_groups` text COMMENT '规格组',
    `attr_groups_format` longtext COMMENT '格式化规格组',
    `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[1正常 -1删除]',
    `stock` int(11) NOT NULL DEFAULT '0' COMMENT '商品库存',
    `stock_warning` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品库存预警',
    `is_show_stock` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否显示库存',
    `is_show_sales` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否显示销量【1是 0否】',
    `virtual_sales` int(11) NOT NULL DEFAULT '0' COMMENT '虚拟销量',
    `sales_num` int(11) NOT NULL DEFAULT '0' COMMENT '累计销量',
    `buy_num_limit` int(11) NOT NULL DEFAULT '-1' COMMENT '购买数量限制',
    `freight_type` varchar(255) NOT NULL DEFAULT '' COMMENT '物流方式【1快递发货 2上门自提 3商家配送】逗号分隔',
    `freight_rules_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '运费规则 【1运费模板 2自定义运费】',
    `freight_id` int(11) NOT NULL DEFAULT '0' COMMENT '运费模板ID',
    `shipping_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '自定义运费金额',
    `free_shipping_num` int(11) NOT NULL DEFAULT '0' COMMENT '商品满件包邮',
    `free_shipping_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品满额包邮',
    `goods_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '商品类型',
    `detail` longtext COMMENT '商品详情，图文',
    `is_area_limit` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否开启限购区域',
    `area_limit` longtext COMMENT '限购区域',
    `services` varchar(500) NOT NULL DEFAULT '' COMMENT '商品服务',
    `labels` varchar(500) NOT NULL DEFAULT '' COMMENT '商品标签',
    `goods_source` varchar(32) DEFAULT NULL COMMENT '商品来源',
    `supplier_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '供应者类型：0:自身；1：商城；2：o2o；3：多商户',
    `supplier_id` int(11) NOT NULL DEFAULT '0' COMMENT '供应者id',
    `supplier_goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '供应品id',
    `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
    `check_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '审核状态 0：待审核；1；：已通过；2：未通过',
    `check_remark` varchar(255) NOT NULL DEFAULT '' COMMENT '审核备注',
    `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
    `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `mall_id_store_id_goods_name_index` (`mall_id`,`store_id`,`goods_name`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品表';

CREATE TABLE `qimall_addons_store_goods_attr`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID',
  `name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '规格名称',
  `sign_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '规格ID标识',
  `stock` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '库存',
  `price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '价格',
  `original_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '原价',
  `cost_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '成本价',
  `goods_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '货号',
  `weight` int(11) NOT NULL DEFAULT 0 COMMENT '重量（克）',
  `pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '规格图片',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[1正常 -1删除]',
  `version` bigint(11) NOT NULL DEFAULT 0 COMMENT '版本',
  `sort` int(11) NOT NULL DEFAULT 999 COMMENT '排序',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `goods_id`(`goods_id`) USING BTREE,
  INDEX `attr_name_goods_id_index`(`goods_id`) USING BTREE
) ENGINE = InnoDB  CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品规格表' ROW_FORMAT = COMPACT;

CREATE TABLE `qimall_addons_store_goods_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `store_id` int(11) NOT NULL DEFAULT 0,
  `cate_id` int(11) NOT NULL DEFAULT 0 COMMENT '主商城分类id',
  `parent_id` int(11) NOT NULL DEFAULT 0 COMMENT '父级ID',
  `name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `big_pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `advert_pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '广告图片',
  `advert_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '广告链接',
  `advert_open_type` varchar(65) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '打开方式',
  `advert_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '导航参数',
  `is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[0禁用 1启用 -1删除]',
  `sort` int(11) NOT NULL DEFAULT 999 COMMENT '排序',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `mall_id_mch_id_index`(`mall_id`) USING BTREE,
  INDEX `parent_id`(`parent_id`) USING BTREE
) ENGINE = InnoDB  CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品分类表' ROW_FORMAT = COMPACT;

CREATE TABLE `qimall_addons_store_goods_cate_relate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cate_id` int(10) NULL DEFAULT 0 COMMENT '分类id',
  `goods_id` int(10) NULL DEFAULT 0 COMMENT '产品id',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `tag_id`(`cate_id`) USING BTREE,
  INDEX `article_id`(`goods_id`) USING BTREE
) ENGINE = InnoDB  CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品分类关联表' ROW_FORMAT = DYNAMIC;

CREATE TABLE `qimall_addons_store_goods_extra` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
    `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
    `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品ID',
    `full_reduce_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '单品满额减免金额',
    `full_reduce_price_limit` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '单品满额金额阈值',
    `score_give_setting` longtext COMMENT '积分赠送设置',
    `score_deduct_setting` longtext COMMENT '积分抵扣设置',
    `currency_deduct_setting` longtext COMMENT '货币营销设置',
    `is_member_price` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否参与会员价 [1是 0 否]',
    `member_price_setting` longtext COMMENT '会员价格设置',
    `member_buy_limit_setting` longtext COMMENT '会员限购设置',
    `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[1正常 -1删除]',
    `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
    `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `goods_id` (`goods_id`) USING BTREE,
    KEY `mall_id_goods_id` (`mall_id`,`goods_id`) USING BTREE,
    KEY `mall_id_store_id_goods_id` (`mall_id`,`store_id`,`goods_id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品额外信息表';

CREATE TABLE `qimall_addons_store_goods_model`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `store_id` int(11) NOT NULL DEFAULT 0,
  `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[0禁用 1启用 -1删除]',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB  CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '模式' ROW_FORMAT = COMPACT;

CREATE TABLE `qimall_addons_store_goods_ranking` (
   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
   `mall_id` int(11) NOT NULL DEFAULT '0',
   `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
   `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品id',
   `sales_money` int(11) NOT NULL DEFAULT '0' COMMENT '销售额',
   `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
   `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
   `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
   PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店商品排行榜';

CREATE TABLE `qimall_addons_store_menu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题',
  `app_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '应用id',
  `pid` int(50) UNSIGNED NULL DEFAULT 0 COMMENT '上级id',
  `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '路由',
  `icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '样式',
  `level` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '级别',
  `dev` tinyint(4) UNSIGNED NULL DEFAULT 0 COMMENT '开发者[0:都可见;开发模式可见]',
  `sort` int(5) NULL DEFAULT 999 COMMENT '排序',
  `params` json NULL COMMENT '参数',
  `tree` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '树',
  `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '添加时间',
  `updated_at` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `url`(`url`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'o2o菜单' ROW_FORMAT = DYNAMIC;

CREATE TABLE `qimall_addons_store_model` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `mall_id` int(11) NOT NULL DEFAULT '0',
      `store_id` int(11) NOT NULL DEFAULT '0',
      `content` longtext COMMENT '内容',
      `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
      `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
      `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
      PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店分佣模式';


CREATE TABLE `qimall_addons_store_notice`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `store_id` int(11) NOT NULL DEFAULT 0 COMMENT '门店id',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '内容',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[0禁用 1启用 -1删除]',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB  CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '店铺公告' ROW_FORMAT = COMPACT;

CREATE TABLE `qimall_addons_store_order` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单id',
      `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '多商户id，0表示商城订单',
      `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id，0表示商城订单',
      `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城ID',
      `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
      `order_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单编号',
      `out_trade_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '系统支付流水号',
      `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '收货人的手机号码',
      `province` int(11) DEFAULT '0' COMMENT '收货人所在省',
      `city` int(11) DEFAULT '0' COMMENT '收货人所在城市',
      `area` int(11) DEFAULT '0' COMMENT '收货人所在街道',
      `town` int(11) NOT NULL DEFAULT '0' COMMENT '镇id',
      `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '详细地址',
      `region_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '地区名称（省市区[乡/镇]）',
      `zip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '收货人邮编',
      `receiver_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '收货人姓名',
      `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '用户订单备注',
      `seller_remark` varchar(255) NOT NULL DEFAULT '' COMMENT '商家订单备注',
      `shipping_type` tinyint(4) DEFAULT '1' COMMENT '订单配送方式【1物流配送 2买家自提 3商家配送】',
      `shipping_money` decimal(10,2) DEFAULT '0.00' COMMENT '订单运费',
      `refund_money` decimal(10,2) DEFAULT '0.00' COMMENT '订单退款金额',
      `pay_money` decimal(10,2) DEFAULT '0.00' COMMENT '订单实付金额',
      `goods_price` decimal(19,2) DEFAULT '0.00' COMMENT '商品优惠后总价',
      `original_goods_price` decimal(10,2) DEFAULT '0.00' COMMENT '商品原本总价',
      `ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '买家ip',
      `coupon_id` int(11) DEFAULT '0' COMMENT '优惠券券id',
      `coupon_money` decimal(10,2) DEFAULT '0.00' COMMENT '优惠券券支付金额',
      `score` decimal(10,2) DEFAULT '0.00' COMMENT '订单消耗积分',
      `score_money` decimal(10,2) DEFAULT '0.00' COMMENT '订单消耗积分抵多少钱',
      `order_status` int(6) DEFAULT '0' COMMENT '订单状态',
      `pay_status` tinyint(4) DEFAULT '0' COMMENT '订单付款状态',
     `shipping_status` tinyint(4) DEFAULT '0' COMMENT '订单配送状态',
      `review_status` tinyint(4) DEFAULT '0' COMMENT '订单评价状态',
      `is_feedback` tinyint(4) DEFAULT '0' COMMENT '订单售后状态:0:未售后；1：售后中；2：售后完成',
      `payment_type` tinyint(4) DEFAULT '0' COMMENT '支付类型',
      `marketing_id` int(11) NOT NULL DEFAULT '0' COMMENT '营销活动id',
      `marketing_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '营销活动类型',
      `invoice_id` int(11) DEFAULT NULL COMMENT '发票id',
      `status` tinyint(4) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
      `is_comment` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否评价 0为未评价 1为已评价 2为已追评',
      `is_recycle` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否加入回收站【1是 0否】',
      `is_virtual` tinyint(1) DEFAULT '0' COMMENT '是否包含虚拟商品【1是 0否】',
      `is_new_user` tinyint(4) DEFAULT '0' COMMENT '是否新顾客',
      `pay_time` int(11) DEFAULT '0' COMMENT '订单付款时间',
      `shipping_time` int(11) DEFAULT '0' COMMENT '买家要求配送时间',
      `sign_time` int(11) DEFAULT '0' COMMENT '买家签收时间',
      `consign_time` int(11) DEFAULT '0' COMMENT '卖家发货时间',
      `finish_time` int(11) DEFAULT '0' COMMENT '订单完成时间',
      `close_time` int(11) DEFAULT '0' COMMENT '关闭的时间',
      `extra_info` text COMMENT '额外信息',
      `created_at` int(10) DEFAULT '0' COMMENT '创建时间',
      `updated_at` int(10) unsigned DEFAULT '0' COMMENT '更新时间',
      `order_source` varchar(255) DEFAULT '' COMMENT '订单来源：juhe_shop=>聚合供应链',
      `supplier_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '供应者类型：0:自身；1：商城；2：o2o；3：多商户',
      PRIMARY KEY (`id`) USING BTREE,
      KEY `order_user_id` (`user_id`) USING BTREE,
      KEY `order_order_no` (`order_no`) USING BTREE,
      KEY `order_pay_status` (`pay_status`) USING BTREE,
      KEY `order_status` (`order_status`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店订单表';

CREATE TABLE `qimall_addons_store_order_detail` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单项ID',
      `order_id` int(11) NOT NULL DEFAULT '0' COMMENT '订单ID',
      `main_order_detail_id` int(11) NOT NULL DEFAULT '0' COMMENT '主商城订单id',
      `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
      `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城ID',
      `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '多商户id',
      `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品ID',
      `goods_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '商品名称',
      `goods_attr_id` int(11) NOT NULL DEFAULT '0' COMMENT '规格ID',
      `goods_attr_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规格名称',
      `sign_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规格ID标识',
      `attr_groups_format` longtext COLLATE utf8mb4_unicode_ci COMMENT '格式化规格组',
      `price` decimal(19,2) NOT NULL DEFAULT '0.00' COMMENT '商品价格',
      `cost_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品成本价',
      `original_goods_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品原本总价',
      `goods_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品优惠后总价',
      `num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '购买数量',
      `adjust_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '调整金额',
      `pic_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '商品图片',
      `marketing_id` int(11) NOT NULL DEFAULT '0' COMMENT '促销ID',
      `marketing_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '促销类型',
      `order_type` int(11) NOT NULL DEFAULT '1' COMMENT '订单类型',
      `give_score` int(11) NOT NULL DEFAULT '0' COMMENT '赠送积分数量',
      `order_status` int(11) NOT NULL DEFAULT '0' COMMENT '订单状态【0待付款 1待发货 2 已发货 3已收货 4已完成 -1申请售后 -2售后中 -3售后完成 -4 已关闭 -5撤销售后】',
      `shipping_status` int(11) NOT NULL DEFAULT '0' COMMENT '物流状态【1已发货 0待发货】',
      `is_feedback` int(1) NOT NULL DEFAULT '0' COMMENT '订单售后状态【0未售后 1售后中 2售后完成】',
      `remark` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
      `is_evaluate` smallint(6) NOT NULL DEFAULT '0' COMMENT '是否评价 【0未评价 1已评价 2已追评】',
      `refund_balance_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单退款余额',
      `is_virtual` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否包含 虚拟商品   0 不包含  1  包含',
      `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
      `extra_info` text CHARACTER SET utf8mb4 COMMENT '额外信息',
      `created_at` int(10) NOT NULL DEFAULT '0',
      `updated_at` int(10) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`) USING BTREE,
      KEY `order_detail_goods_buyer_id` (`user_id`) USING BTREE,
      KEY `order_detail_goods_goods_id` (`goods_id`) USING BTREE,
      KEY `order_detail_goods_order_id` (`order_id`) USING BTREE,
      KEY `order_detail_goods_marketing_id` (`marketing_id`) USING BTREE,
      KEY `order_detail_goods_attr_id` (`goods_attr_id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='门店订单商品详情表';

CREATE TABLE `qimall_addons_store_order_marketing` (
   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
   `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT 'mall_id',
   `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
   `order_detail_id` int(11) NOT NULL DEFAULT '0' COMMENT '订单详情id',
   `give_score` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '赠送积分',
   `give_balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '赠送余额',
   `give_currency` text COMMENT '赠送货币(json字符串保存)',
   `deduct_score` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '减扣积分',
   `deduct_currency` text COMMENT '减扣货币(json字符串保存)',
   `pay_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品实际付款金额，单位：元',
   `full_reduce_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '满减金额，单位：元',
   `coupon_discount_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '优惠券优惠金额，单位：元',
   `member_price_deduct` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '会员价优惠',
   `user_coupon_id` varchar(1000) NOT NULL DEFAULT '' COMMENT '用户优惠券id map',
   `agent_deduct` decimal(10,2) NOT NULL DEFAULT '0.00',
   `agent_extra` varchar(255) NOT NULL DEFAULT '' COMMENT '经销商内购商品抵扣额外信息',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
   `created_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
   `updated_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
   PRIMARY KEY (`id`) USING BTREE,
   KEY `order_detail_id` (`order_detail_id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='订单营销赠扣表';

CREATE TABLE `qimall_addons_store_refund_address`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `store_id` int(11) NOT NULL DEFAULT 0 COMMENT '门店id',
  `refund_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '退货名称',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联系人',
  `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '退换货手机号',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '退换货地址',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[0禁用 1启用 -1删除]',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB  CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门店退货地址' ROW_FORMAT = COMPACT;

CREATE TABLE `qimall_addons_store_settings` (
       `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
       `mall_id` int(10) unsigned NOT NULL,
       `store_id` int(10) unsigned NOT NULL,
      `store_service_fee` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否收取服务费，1：收取；0：不收取',
       `store_service_ratio` decimal(5,3) NOT NULL DEFAULT '0.000' COMMENT '门店服务费比例',
       `store_settle_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '服务费计算方式，1：门店商品售价（分佣平台承担）；2：订单实际支付金额（分佣平台承担）；3：商品成本+运费（不包含服务费）；4：订单实际支付减去（分销商提成、经销商提成、区域代理、股东分红）',
       `store_settle_scene` tinyint(4) NOT NULL DEFAULT '1' COMMENT '服务费计算触发场景，1：订单支付；2：订单完成',
       `store_commission_authority` text COMMENT '分销/营销权限，存 json，key 区别各个不同应用',
       `cachier_service_ratio` decimal(5,3) NOT NULL DEFAULT '0.000' COMMENT '收银台服务费比例',
       `cashier_member_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否启用会员价，1：启用；0：不启用',
       `cashier_member_settings` text COMMENT '会员各个等级比例设置，存 json',
       `cashier_distribution_is_enable` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否开启分销设置，1：是；0：否',
       `cashier_distribution_settings` text COMMENT '分销各个等级佣金比例设置，存 json',
        `cashier_agent_is_enable` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否开启经销设置，1：是；0：否',
       `cashier_agent_settings` text COMMENT '经销各个等级佣金比例设置，存 json',
       `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态，-1：已删除；0：禁用；1：正常',
       `created_at` int(10) unsigned NOT NULL DEFAULT '0',
        `updated_at` int(10) unsigned NOT NULL DEFAULT '0',
       PRIMARY KEY (`id`),
       KEY `idx_mall_store` (`mall_id`,`store_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='门店配置记录表';

CREATE TABLE `qimall_addons_store_statistics` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
  `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `date_time` varchar(50) NOT NULL DEFAULT '' COMMENT '月份',
  `income_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '收入',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店月份统计';

CREATE TABLE `qimall_addons_store_user`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `store_id` int(11) NOT NULL DEFAULT 0 COMMENT '门店id',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '会员id',
  `last_time` int(11) NOT NULL DEFAULT 0 COMMENT '最近下单时间',
  `order_nums` int(11) NOT NULL DEFAULT 0 COMMENT '店内下单数',
  `pay_nums` int(11) NOT NULL DEFAULT 0 COMMENT '店内消费订单数',
  `pay_money` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '店内消费金额',
  `refund_nums` int(11) NOT NULL DEFAULT 0 COMMENT '累计退款订单数',
  `refund_money` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '累计退款金额',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[0禁用 1启用 -1删除]',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB  CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门店会员' ROW_FORMAT = COMPACT;

CREATE TABLE `qimall_addons_store_user_buy`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `store_id` int(11) NOT NULL DEFAULT 0 COMMENT '门店id',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '会员id',
  `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT 'o2o商品id',
  `nums` int(11) NOT NULL DEFAULT 0 COMMENT '付款件数',
  `pay_money` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '付款金额',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[0禁用 1启用 -1删除]',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB  CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门店会员购买记录' ROW_FORMAT = COMPACT;


CREATE TABLE `qimall_addons_store_user_enter_qualification` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `mall_id` int(10) unsigned NOT NULL,
      `user_id` int(10) unsigned NOT NULL,
      `enter_mode` tinyint(4) NOT NULL DEFAULT '1' COMMENT '入驻模式，1：免费入驻，2：购买指定商品入驻',
      `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '已经购买的商品 id',
      `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态，-1：已删除；0：禁用；1：正常',
      `created_at` int(10) unsigned NOT NULL DEFAULT '0',
      `updated_at` int(10) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `idx_mu_id` (`mall_id`,`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='会员入驻资格记录（监听支付事件写入数据）';

CREATE TABLE `qimall_addons_store_withdraw_log` (
   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
   `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
   `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
   `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '会员id',
   `order_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '提现订单号',
   `num` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '提现金额',
   `actual_num` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '实际到账金额',
   `poundage_num` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '手续费扣除金额',
   `poundage_ratio` float NOT NULL DEFAULT '0' COMMENT '手续费比例',
   `type` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '提现方式 bank--银行转账 balance--打款到余额',
   `extra` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '额外信息',
   `withdraw_status` int(11) NOT NULL DEFAULT '0' COMMENT '提现状态 0--待打款 --已打款 2--驳回 ',
   `status` int(11) NOT NULL DEFAULT '0' COMMENT '状态[0禁用 1启用 -1删除]',
   `remark` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '备注',
   `created_at` int(11) DEFAULT '0' COMMENT '添加时间戳',
   `updated_at` int(11) DEFAULT '0' COMMENT '更新时间戳',
   PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='门店提现记录表';


CREATE TABLE `qimall_addons_store_cashier_extra` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
  `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `full_reduce_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '单品满额减免金额',
  `full_reduce_price_limit` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '单品满额金额阈值',
  `score_give_setting` longtext COMMENT '积分赠送设置',
  `score_deduct_setting` longtext COMMENT '积分抵扣设置',
  `currency_deduct_setting` longtext COMMENT '货币营销设置',
  `is_member_price` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否参与会员价 [1是 0 否]',
  `member_price_setting` longtext COMMENT '会员价格设置',
 `member_buy_limit_setting` longtext COMMENT '会员限购设置',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[1正常 -1删除]',
  `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='收银额外信息表';

INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (1, '概况', '0', 0, 'store/client/index/index', 'el-icon-s-platform', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (2, '商品', '0', 0, 'store/client/goods/index', 'el-icon-s-goods', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (3, '订单', '0', 0, 'store/client/order/index', 'el-icon-s-order', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (4, '会员', '0', 0, 'store/client/user/index', 'el-icon-user', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (5, '核销', '0', 0, 'store/client/clerk/index', 'el-icon-s-ticket', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (6, '收银', '0', 0, 'store/client/cash/index', 'el-icon-money', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (7, '资产', '0', 0, 'store/client/finance/index', 'el-icon-coin', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (8, '设置', '0', 0, 'store/client/setting/index', 'el-icon-setting', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (9, '商品管理', '0', 2, 'store/client/goods/index', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (10, '商品分类', '0', 2, 'store/client/cate/index', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (11, '选品中心', '0', 2, 'store/client/goods/supply', '', 2, 0, 999, NULL, '', -1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (12, '订单管理', '0', 3, 'store/client/order/index', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (13, '售后订单', '0', 3, 'store/client/order/refund', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (14, '外部订单', '0', 3, 'store/client/order/platform-order', '', 2, 0, 999, NULL, '', -1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (15, '资产概况', '0', 7, 'store/client/finance/index', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (16, '收入明细', '0', 7, 'store/client/finance/income-log', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (17, '资金提现', '0', 7, 'store/client/finance/withdrawal', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (18, '运费模板', '0', 2, 'store/client/setting/freight-rules', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (19, '店铺信息', '0', 8, 'store/client/setting/index', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (20, '退货地址', '0', 8, 'store/client/refund-address/index', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (21, '店铺公告', '0', 8, 'store/client/notice/index', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (22, '模式设置', '0', 8, 'store/client/setting/goods-model', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (23, '运费模板', '0', 8, 'store/client/setting/freight-rules', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (24, '核销员', '0', 5, 'store/client/clerk/index', '', 3, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_store_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (25, '核销明细', '0', 5, 'store/client/clerk/clerk-log', '', 3, 0, 999, NULL, '', 1, 0, 0);



ALTER table qimall_addons_store_cashier_extra add `preferential_deduction` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '优惠抵扣开关按钮';
ALTER table qimall_addons_store_cashier_extra add `preferential_gift` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '优惠赠送开关按钮';


ALTER table qimall_addons_store_order_detail add `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id';

INSERT INTO `qimall_addons_store_menu`(`id`,`title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES ('29','预约订单', '0', 3, 'store/client/subscribe/index', '', 2, 0, 999, NULL, '', 1, 0, 0);


ALTER TABLE qimall_addons_store_settings add   `cashier_distribution_settings_score` text COMMENT '分销各个等级积分比例设置，存 json';
ALTER TABLE qimall_addons_store_settings add     `cashier_distribution_is_enable_score` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否开启分销设置，1：是；0：否';


CREATE TABLE `qimall_addons_store_order_give` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT 'mall_id',
    `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
    `order_id` int(11) NOT NULL DEFAULT '0' COMMENT '订单id',
    `give_score` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '赠送积分',
    `give_coupon` text COMMENT '赠送优惠券(json字符串保存)',
    `give_currency` text COMMENT '赠送货币(json字符串保存)',
    `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
    `created_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
    `updated_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `order_id` (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='订单赠送表';


ALTER TABLE qimall_addons_store add   `store_img` varchar(255) NOT NULL DEFAULT '' COMMENT '门店图片';