qimall/addons/CloudStock/install.sql

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_agent
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_agent`;
CREATE TABLE `qimall_addons_cloud_stock_agent`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0 COMMENT '商城id',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `remarks` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `total_childs` int(11) NOT NULL DEFAULT 0 COMMENT '所有下级数量',
  `total_order` int(11) NOT NULL DEFAULT 0 COMMENT '订单数量',
  `total_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '累计收益',
  `price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '已结算收益',
  `frozen_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '未结算收益',
  `upgrade_status` tinyint(6) NOT NULL DEFAULT 3 COMMENT '升级类型;1条件升级;2升级礼包;3平台添加;4上级添加',
  `level` tinyint(4) NOT NULL DEFAULT 0 COMMENT '代理商等级权重',
  `before_level` int(11) NULL DEFAULT 0 COMMENT '升级前等级;null为无',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  `upgrade_at` int(11) NOT NULL DEFAULT 0 COMMENT '等级升级时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '云库存代理商' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_agent_goods
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_agent_goods`;
CREATE TABLE `qimall_addons_cloud_stock_agent_goods`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_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 COMMENT '商品id',
  `num` int(11) NOT NULL DEFAULT 0 COMMENT '库存数量',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mId_uId_gId`(`mall_id`, `user_id`, `goods_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代理商的库存商品' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_agent_order
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_agent_order`;
CREATE TABLE `qimall_addons_cloud_stock_agent_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_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 COMMENT '商品ID',
  `num` int(11) NOT NULL DEFAULT 0 COMMENT '商品数量',
  `address` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人地址',
  `express_no` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发货单号',
  `express_code` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流公司编号',
  `send_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0待发货;1已发货;2已完成;',
  `mobile` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人手机号码',
  `name` varchar(125) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收货人名称',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mId_uId`(`mall_id`, `user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代理商自提订单' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_agent_quota
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_agent_quota`;
CREATE TABLE `qimall_addons_cloud_stock_agent_quota`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城id',
  `user_id` int(11) NOT NULL COMMENT '代理商用户id',
  `level` int(11) NOT NULL COMMENT '等级权重',
  `num` int(11) UNSIGNED NOT NULL COMMENT '名额数量',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mId_uId`(`mall_id`, `user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理商名额' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_buying_order
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_buying_order`;
CREATE TABLE `qimall_addons_cloud_stock_buying_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `mall_id` int(11) NOT NULL COMMENT '商城id',
  `user_id` int(11) NOT NULL COMMENT '买货用户id',
  `after_distribution_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品的实际支付金额扣除其他分润后的金额;未扣奖励前货款;',
  `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '订单id;order表',
  `order_detail_id` int(11) NOT NULL DEFAULT 0 COMMENT '订单详情id;order_detail表',
  `goods_id` int(11) NOT NULL COMMENT '商品id',
  `num` int(11) NOT NULL COMMENT '商品数量',
  `is_return` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否有退库存',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_id`(`user_id`) USING BTREE,
  INDEX `idx_order_id`(`order_id`) USING BTREE,
  INDEX `idx_goods_id`(`goods_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '云库存会员买货订单表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_deduction_detail
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_deduction_detail`;
CREATE TABLE `qimall_addons_cloud_stock_deduction_detail`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `mall_id` int(11) NOT NULL DEFAULT 0 COMMENT '商城id',
  `goods_id` int(11) NOT NULL COMMENT '商品id',
  `changes_type` int(11) NOT NULL COMMENT '库存变动类型;200会员买货;201给下级配货;202下级向自己补货;203自提货到线下;204系统扣减;',
  `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '订单id',
  `order_type` tinyint(5) NOT NULL DEFAULT 1 COMMENT 'order类型,1:会员购买订单，2：补货订单;',
  `not_yet_num` int(11) NOT NULL DEFAULT 0 COMMENT '剩余未扣库存数',
  `num` int(11) NOT NULL DEFAULT 0 COMMENT '扣库存数',
  `stock_log_id` int(11) NOT NULL COMMENT 'qimall_addons_cloud_stock_goods_stock_log表的id',
  `user_id` int(11) NOT NULL COMMENT '扣减代理商用户user_id;0为平台',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '云库存扣库存明细表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_fill_order
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_fill_order`;
CREATE TABLE `qimall_addons_cloud_stock_fill_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城id',
  `user_id` int(11) NOT NULL COMMENT '补货代理商用户id',
  `trade_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '支付流水记录id',
  `pay_money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '支付金额',
  `order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '补货订单编号',
  `trade_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付流水号',
  `is_pay` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否支付',
  `goods_id` int(11) NOT NULL COMMENT '商品id',
  `num` int(11) NOT NULL DEFAULT 0 COMMENT '补货商品数量',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '补货订单表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_goods
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_goods`;
CREATE TABLE `qimall_addons_cloud_stock_goods`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0 COMMENT '商城id',
  `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id',
  `agent_price` varchar(5120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '代理商进货价设置',
  `goods_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '商品类型;0 商城商品',
  `equal_level_list` varchar(5120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '平级奖设置',
  `fill_level_list` varchar(5120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '补货奖设置',
  `over_level_list` varchar(5120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '越级奖设置',
  `is_allow_fill` tinyint(4) NOT NULL DEFAULT 1 COMMENT '是否允许向平台补货',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = ' 云库存商品表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_goods_stock_log
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_goods_stock_log`;
CREATE TABLE `qimall_addons_cloud_stock_goods_stock_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `mall_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 '商品id',
  `changes_dir` tinyint(4) NOT NULL COMMENT '库存变动方向;1增加;2减少',
  `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '相关的订单id',
  `order_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'order类型,1:会员购买订单，2：补货订单;',
  `changes_type` int(11) NOT NULL COMMENT '库存变动类型;100向上级补货;101上级给自己配货;102退货退库存;103系统添加;104平台补货赠送;105购买礼包赠送;200会员买货;201给下级配货;202下级向自己补货;203自提货到线下;204系统扣减;',
  `num` int(11) NOT NULL COMMENT '数量',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_goods_id`(`goods_id`) USING BTREE,
  INDEX `idx_order_id`(`order_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '云库存商品库存明细变动记录表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_increase_detail
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_increase_detail`;
CREATE TABLE `qimall_addons_cloud_stock_increase_detail`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `mall_id` int(11) NOT NULL COMMENT '商城id',
  `goods_id` int(11) NOT NULL COMMENT '商品id',
  `changes_type` int(11) NOT NULL COMMENT '库存变动类型;100向上级补货;101上级给自己配货;102退货退库存;103系统添加;104平台补货赠送;105购买礼包赠送;',
  `stock_log_id` int(11) NOT NULL COMMENT '库存变动表qimall_addons_cloud_stock_goods_stock_log的id',
  `user_id` int(11) NOT NULL COMMENT '增加库存代理商用户id',
  `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '订单id',
  `order_type` tinyint(5) NOT NULL DEFAULT 1 COMMENT 'order类型,1:会员购买订单，2：补货订单;',
  `num` int(11) NOT NULL COMMENT '增加数量',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '云库存库存增加明细表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_level
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_level`;
CREATE TABLE `qimall_addons_cloud_stock_level`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城id',
  `level` int(11) NOT NULL DEFAULT 0 COMMENT '等级权重id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '等级名称',
  `checked_condition_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '升级条件',
  `checked_condition_keys` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '升级条件选中的key集合',
  `condition_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 未选择、1满足其一  2、满足所有',
  `upgrade_type_condition` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否开启条件升级',
  `is_over` tinyint(4) NOT NULL DEFAULT 0 COMMENT '超越奖励',
  `is_equal` tinyint(4) NOT NULL DEFAULT 0 COMMENT '平级',
  `is_fill` tinyint(4) NOT NULL DEFAULT 0 COMMENT '补货',
  `give_quota` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'json;赠送等级配置',
  `explain` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '等级说明',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '云库存代理商等级表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_set_agent_log
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_set_agent_log`;
CREATE TABLE `qimall_addons_cloud_stock_set_agent_log`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL COMMENT '会员id',
  `child_id` int(10) UNSIGNED NOT NULL COMMENT '下级会员id',
  `agent_id` int(10) UNSIGNED NOT NULL COMMENT '代理商id',
  `child_agent_id` int(10) UNSIGNED NOT NULL COMMENT '下级代理商id',
  `set_level` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '代理商给下级设定的等级',
  `status` tinyint(4) 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`) USING BTREE,
  INDEX `idl_mac_id`(`mall_id`, `agent_id`, `child_agent_id`) USING BTREE,
  INDEX `idl_level`(`set_level`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代理商设置下级代理商记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_sms
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_sms`;
CREATE TABLE `qimall_addons_cloud_stock_sms`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `temp_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板id',
  `temp_content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板内容',
  `mall_id` int(11) NOT NULL DEFAULT 0 COMMENT '商城id',
  `sms_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '键值',
  `temp_name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板名称',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '云库存短信通知' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_upgrade_bag
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_upgrade_bag`;
CREATE TABLE `qimall_addons_cloud_stock_upgrade_bag`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '升级礼包名称',
  `level` int(11) NOT NULL COMMENT '升级等级权重',
  `goods_id` int(11) NOT NULL COMMENT '升级商品id',
  `give_goods_num` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '赠送商品数量',
  `give_goods_id` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '赠送商品id',
  `is_enable` tinyint(4) NOT NULL DEFAULT 1 COMMENT '是否启用',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '升级礼包' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for qimall_addons_cloud_stock_upgrade_bag_log
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_cloud_stock_upgrade_bag_log`;
CREATE TABLE `qimall_addons_cloud_stock_upgrade_bag_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0 COMMENT '商城id',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单编号',
  `goods_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称',
  `money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
  `goods_cover_pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品缩略图',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '礼包购买记录' ROW_FORMAT = COMPACT;


ALTER TABLE qimall_addons_cloud_stock_agent_order add province_id int(10) not null default 0 comment '省';
ALTER TABLE qimall_addons_cloud_stock_agent_order add city_id int(10) not null default 0 comment '市';
ALTER TABLE qimall_addons_cloud_stock_agent_order add district_id int(10) not null default 0 comment '区';
ALTER TABLE qimall_addons_cloud_stock_agent_order add town_id int(10) not null default 0 comment '镇';