qimall/addons/Distribution/install.sql

-- ----------------------------
-- Table structure for qimall_addons_distribution
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_distribution`;
CREATE TABLE `qimall_addons_distribution`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `remarks` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '修改时间',
  `level` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分销商等级',
  `upgrade_level_at` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分销商等级升级时间',
  `total_commission` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '累计佣金',
  `total_score` int(11) NOT NULL DEFAULT 0 COMMENT '累计积分',
  `upgrade_status` smallint(6) NOT NULL DEFAULT 0 COMMENT '1条件升级 2 购买指定商品升级 3手动升级',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `mall_id`(`mall_id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分销商信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_distribution_apply
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_distribution_apply`;
CREATE TABLE `qimall_addons_distribution_apply`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `mobile` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '申请备注',
  `check_remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '审核备注',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `check_status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '0待审核1审核通过2不通过',
  `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 = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_distribution_commission_basis_log
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_distribution_commission_basis_log`;
CREATE TABLE `qimall_addons_distribution_commission_basis_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0 COMMENT '商城ID',
  `source_table` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '来源表',
  `source_table_id` int(11) NOT NULL DEFAULT 0 COMMENT '来源表id',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '积分：score；佣金：commission',
  `from_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '来源类型',
  `basic_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '基础配置',
  `level_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '等级配置',
  `goods_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '商品独立配置',
  `relation_ship` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关系链等级',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态[-1:删除;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,
  INDEX `mall_id`(`mall_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分销商奖励计算依据' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_distribution_commission_item_setting
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_distribution_commission_item_setting`;
CREATE TABLE `qimall_addons_distribution_commission_item_setting`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城ID',
  `is_enable` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否独立设置：0:否;1是',
  `item_id` int(11) NOT NULL DEFAULT 0 COMMENT '项目id',
  `item_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '项目类型：商品goods',
  `settings` tinyint(3) NOT NULL DEFAULT 0 COMMENT '分销佣金设置:0:按商品设置;1:按规格设置',
  `commission_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '分佣类型：积分score;佣金：commission',
  `is_percent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '类型 0百分比 1 固定金额',
  `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 `mall_id`(`mall_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分销商项目分佣设置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_distribution_commission_item_setting_detail
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_distribution_commission_item_setting_detail`;
CREATE TABLE `qimall_addons_distribution_commission_item_setting_detail`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城ID',
  `distribution_commission_item_setting_id` int(11) NOT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `first_prize` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '一级奖励',
  `second_prize` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '二级奖励',
  `third_prize` decimal(10, 2) NOT NULL DEFAULT 0.00 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 `mall_id`(`mall_id`) USING BTREE,
  INDEX `distribution_commission_item_setting_id`(`distribution_commission_item_setting_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分销商项目分佣设置详情' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_distribution_commission_level_setting
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_distribution_commission_level_setting`;
CREATE TABLE `qimall_addons_distribution_commission_level_setting`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城ID',
  `level` int(11) NOT NULL DEFAULT 0,
  `commission_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '分佣类型：积分score;佣金：commission',
  `from_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '分佣类型：经销Agent;幸运平团：Lucky_group',
  `is_percent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '佣金类型 0百分比 1 固定金额',
  `first_prize` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '一级',
  `second_prize` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '二级',
  `third_prize` decimal(11, 2) NOT NULL DEFAULT 0.00 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 `mall_id`(`mall_id`) USING BTREE,
  INDEX `level`(`level`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分销商分佣设置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_distribution_goods_setting
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_distribution_goods_setting`;
CREATE TABLE `qimall_addons_distribution_goods_setting`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) NOT NULL DEFAULT 0 COMMENT '商城ID',
  `goods_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL 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 `mall_id+goods_id`(`mall_id`, `goods_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分销管理-商品单独设置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_distribution_level
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_distribution_level`;
CREATE TABLE `qimall_addons_distribution_level`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城ID',
  `level` int(11) NOT NULL DEFAULT 0,
  `name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '等级名称',
  `is_auto_upgrade` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否开启自动升级',
  `upgrade_type_condition` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启条件升级',
  `checked_condition_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '升级条件',
  `checked_condition_keys` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '升级条件选中的key集合',
  `condition_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 未选择、1满足其一  2、满足所有',
  `upgrade_type_goods` tinyint(1) NOT NULL DEFAULT 0 COMMENT '购买升级商品,0关闭，1开启',
  `buy_goods_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '购买升级商品触发升级:0订单完成 1下单完成',
  `goods_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '商品升级类型，1- 任意商品 2- 指定商品',
  `goods_ids` varchar(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品id集合',
  `goods_list` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' 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,
  INDEX `mall_id`(`mall_id`) USING BTREE,
  INDEX `level`(`level`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分销商等级' ROW_FORMAT = Dynamic;