qimall/sql/update.sql

ALTER TABLE `qimall_user_level`
ADD COLUMN `is_open_expired`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启会员期限',
ADD COLUMN `expired_day`  int(11) NOT NULL DEFAULT 0 COMMENT '会员有效期';

ALTER TABLE `qimall_order_marketing`
ADD COLUMN `user_card_id`  varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户会员卡id map';

INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('MembersCard', '亲友卡', 'IncomeMap', '1', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('MembersCard', '亲友卡', 'FromTypeMap', '1', '1', '1654569888', '1654569888');

INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('会员等级过期', 'user-level/level-expired', '2', '0 */30 * * * *', '0', '1', '1672645798', '1672645798');

-- 蕾伊生
ALTER TABLE `qimall_addons_cloud_stock_agent_order`
ADD COLUMN `remark`  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户订单备注';

--华后美业
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('manage', '管理奖励', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');

--酒多多
ALTER TABLE `qimall_user_level`
ADD COLUMN `member_price_is_show`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否展示下级会员价格 0 否 1 是';

--独立平级奖
ALTER TABLE `qimall_addons_agent_commission_level_setting`
ADD COLUMN `is_alone_agent_equal_prize`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启独立平级奖励 0 否 1 是',
ADD COLUMN `alone_agent_equal_prize_info`  varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '独立平级奖设置';

ALTER TABLE `qimall_addons_agent_commission_item_setting`
ADD COLUMN `is_alone_agent_equal_prize`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启独立平级奖励 0 否 1 是',
ADD COLUMN `alone_agent_equal_prize_type`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '独立平级奖励类型';

ALTER TABLE `qimall_addons_agent_commission_item_setting_detail`
ADD COLUMN `alone_agent_equal_prize_info`  varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '独立平级奖设置';


--门店独立结算金额
ALTER TABLE `qimall_addons_store_goods_extra`
ADD COLUMN `is_alone_settle`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启独立结算金额 [1是 0 否]',
ADD COLUMN `alone_settle_price`  decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '独立结算金额';
--亲友卡新增
ALTER TABLE `qimall_addons_members_card`
ADD COLUMN `is_enable_virtual`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '虚拟商品是否可用 0 否 1 是 ';

--加权分红
ALTER TABLE `qimall_addons_boss_weight`
ADD COLUMN `fixed_weight`  int(11) NOT NULL DEFAULT 0 COMMENT '固定权重';

--积分抵扣
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('goods_deduct', '购物抵扣', 'FromTypeMap', '0', '1', '1654569888', '1654569888');

--核销员
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('write_off_prize', '核销奖励', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('manage_prize', '管理奖励', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('promote_prize', '促销奖励', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('achievement_promote_prize', '业绩促销奖励', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('WriteOff', '核销员', 'IncomeMap', '1', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('WriteOff', '核销员', 'FromTypeMap', '1', '1', '1654569888', '1654569888');

INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('核销员促销业绩奖励结算', 'write-off/write-off-crontab/settle', '2', '0 */60 * * * *', '0', '1', '1691749140', '1693563705');

--云库存
INSERT INTO `qimall_global_var_map` ( `name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('buy_price_difference', '会员买货差价', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888);
INSERT INTO `qimall_global_var_map` ( `name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('price_difference_equal', '云库存差价平级奖', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888);
ALTER TABLE `qimall_user_bank_card`
ADD COLUMN `bank_address`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '开户行地址';
--服务商分红
ALTER TABLE `qimall_addons_servebonus_level_setting`
ADD COLUMN `is_cloud_stock_open`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '云库存加权分红 0关闭 1 开启',
ADD COLUMN `cloud_stock_achievement_percent`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '云库存业绩分红类型 0百分比 1 固定金额',
ADD COLUMN `cloud_stock_achievement_prize`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '云库存业绩分红奖励';

ALTER TABLE `qimall_addons_servebonus_reward_log`
ADD COLUMN `is_cloud_stock`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否云库存结算[0否; 1是]';

ALTER TABLE `qimall_addons_servebonus_commission_log`
ADD COLUMN `achievement_commission`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '业绩分红，单位：元';
ALTER TABLE `qimall_addons_servebonus`
ADD COLUMN `achievement_commission`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '累计业绩分红，单位：元';
ALTER TABLE `qimall_addons_servebonus_commission_item_setting`
ADD COLUMN `cloud_stock_achievement_percent`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '云库存业绩分红类型 0百分比 1 固定金额';
ALTER TABLE `qimall_addons_servebonus_commission_item_setting_detail`
ADD COLUMN `cloud_stock_achievement_prize`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '云库存业绩分红奖励';
ALTER TABLE `qimall_addons_servebonus_period`
ADD COLUMN `achievement_commission`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '业绩分红，单位：元';








--大古
INSERT INTO `qimall_global_var_map` ( `name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('fill_achievement', '个人团队补货奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888);
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('WholeBonus', '全民分红', 'IncomeMap', '1', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('WholeBonus', '全民分红', 'FromTypeMap', '1', '1', '1654569888', '1654569888');

--新建表 qimall_addons_cloud_stock_increase_by_platform_log
ALTER TABLE `qimall_addons_cloud_stock_fill_statistics`
ADD COLUMN `award_proportion_calculate_type`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '计算方式';

ALTER TABLE `qimall_addons_cloud_stock_fill_statistics`
MODIFY COLUMN `self_num`  decimal(12,2) NOT NULL COMMENT '自身补货数量',
MODIFY COLUMN `direct_num`  decimal(12,2) NOT NULL COMMENT '直推们的数量，等级一致',
MODIFY COLUMN `indirect_num`  decimal(12,2) NOT NULL COMMENT '间推们数量，等级一致';

INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('全民分红-分红池分红', 'whole-bonus/index/team-reward', '2', '0 */30 0-2 * * *', '0', '1', '1709287854', '1709287880');

--余额充值
INSERT INTO `qimall_menu` (`title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES ('充值审核', 'backend', '2', '', '0', '35', 'mall/finance/recharge-audit', '', '2', '1', '999', NULL, 'tr_0 tr_35', '1', '1694766835', '1694766835');

--开票
ALTER TABLE `qimall_order`
ADD COLUMN `is_bill`  tinyint(1) NULL DEFAULT 0 COMMENT '是否已开票 0 否 1 是',
ADD COLUMN `bill_time`  int(11) NULL DEFAULT 0 COMMENT '开票时间';

INSERT INTO `qimall_menu` (`title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES ('开票记录', 'backend', '2', '', '0', '33', 'mall/order/invoice', '', '2', '1', '999', NULL, ' tr_33', '1', '1695117641', '1695117641');




--核销员
ALTER TABLE `qimall_addons_write_off_member_log`
ADD COLUMN `code`  int(8) NOT NULL DEFAULT 0 COMMENT '核销码';

ALTER TABLE `qimall_addons_write_off_level`
ADD COLUMN `is_enable_promote_limit`  tinyint(4) NULL DEFAULT 0 COMMENT '核销限制[0:关闭;1启用]',
ADD COLUMN `promote_time`  int(10) NULL DEFAULT 0 COMMENT '每日核销次数';

--最高奖励
ALTER TABLE `qimall_addons_double_copy_user`
ADD COLUMN `is_height_commission`  tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否设置最高佣金奖励【0 否 1 是】',
ADD COLUMN `height_commission`  decimal(10,2) NOT NULL DEFAULT 0 COMMENT '最高奖励';

ALTER TABLE `qimall_addons_distribution`
ADD COLUMN `is_height_commission`  tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否设置最高佣金奖励【0 否 1 是】',
ADD COLUMN `height_commission`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '最高奖励';


--业绩平级奖励
ALTER TABLE `qimall_addons_achievement_commission_item_setting`
ADD COLUMN `is_alone_equal`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否独立平级奖励 【 0 否 1是】',
ADD COLUMN `is_alone_equal_percent`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '平级奖励类型 0百分比 1 固定金额',
ADD COLUMN `alone_equal_first`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一级平级奖励/比例',
ADD COLUMN `alone_equal_second`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二级平级奖励/比例';

ALTER TABLE `qimall_addons_achievement_order_log`
ADD COLUMN `is_alone_equal`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否独立平级奖励 【 0 否 1是】',
ADD COLUMN `equal_first`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一级平级奖励/比例',
ADD COLUMN `equal_second`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二级平级奖励/比例';
--乔迪安
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('boss_weight', '加权分红', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('BossWeightBonus', '股东加权分红', 'IncomeMap', '1', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('BossWeightBonus', '股东加权分红', 'FromTypeMap', '1', '1', '1654569888', '1654569888');

INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('股东加权分红', 'boss-weight-bonus/boss-weight-bonus-crontab/send-commission', '2', '0 30 0 * * *', '0', '1', '1699344672', '1699344672');
INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('股东加权分红积分自动转入', 'boss-weight-bonus/boss-weight-bonus-crontab/auto-change-score', '2', '*/30 * * * * *', '0', '1', '1699344787', '1699344787');
INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('股东加权分红自动转入股指', 'boss-weight-bonus/boss-weight-bonus-crontab/auto-change', '2', '0 0 1 1 * *', '0', '1', '1699344846', '1699344846');
ALTER TABLE `qimall_addons_achievement_grant_log`
ADD COLUMN `is_equal`  tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否开启平级奖励：0：否 1：是',
ADD COLUMN `equal_percent`  tinyint(4) NOT NULL DEFAULT 0 COMMENT '平级奖励计算方式：0：百分比 1：固定金额',
ADD COLUMN `equal_price_first`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一层平级奖励',
ADD COLUMN `equal_price_second`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二层平级奖励';

ALTER TABLE `qimall_addons_achievement_award_log`
ADD COLUMN `equal_first`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一层平级奖励',
ADD COLUMN `equal_second`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二层平级奖励';

ALTER TABLE `qimall_addons_achievement_award_log`
ADD COLUMN `equal_info`  varchar(255) NOT NULL COMMENT '首次平级奖励内容';

ALTER TABLE `qimall_addons_achievement_award_log`
ADD COLUMN `equal_money`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '平级奖励金额';

ALTER TABLE `qimall_addons_achievement_grant_log`
ADD COLUMN `equal_money`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '平级奖励金额';

--新
ALTER TABLE `qimall_addons_achievement_award_log`
ADD COLUMN `team_equal_first`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '团队一层平级奖励',
ADD COLUMN `team_equal_second`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '团队二层平级奖励';
--卡券
INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('卡券状态修改', 'card-coupons/card-coupon-crontab/auto-change', '2', '0 */5 * * * *', '0', '1', '1697105153', '1697105153');
CREATE TABLE `qimall_payment_trade_group_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trade_id` int(11) NOT NULL DEFAULT '0' COMMENT '流水表ID',
  `order_no` varchar(32) NOT NULL DEFAULT '' COMMENT '订单号',
  `order_type` varchar(32) NOT NULL DEFAULT '' COMMENT '订单类型',
  `pay_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单支付金额',
  `total_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单总金额，pay_fee+rand_fee',
  `rand_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单随机减金额',
  `is_pay` int(1) NOT NULL DEFAULT '0' COMMENT '支付状态：0=未支付，1=已支付',
  `pay_type` int(1) NOT NULL DEFAULT '0' COMMENT '支付方式：1=微信支付，2=货到付款，3=余额支付，4=支付宝支付，5=银联支付，6=汇聚聚合支付，7=汇聚快捷支付',
  `title` varchar(128) NOT NULL DEFAULT '' COMMENT '标题',
  `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  `notify_class` varchar(512) NOT NULL DEFAULT '',
  `refund_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退款金额',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `union_id` (`trade_id`) USING BTREE,
  KEY `order_no` (`order_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='订单组合支付记录表';

ALTER TABLE `qimall_payment_trade`
ADD COLUMN `is_pay_group`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否组合支付订单 0 否 1 是',
ADD COLUMN `parent_trade_id`  int(11) NOT NULL DEFAULT 0 COMMENT '关联上级支付流水id（组合支付子订单不为空）';


--云库存业绩奖励
ALTER TABLE `qimall_addons_cloud_stock_achievement_grant_log`
ADD COLUMN `wait_settlement_time`  int(11) NOT NULL DEFAULT 0 COMMENT '等待结算时间';

--门店股东2
INSERT INTO `qimall_addons_store_menu` (`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`, `addons_name`, `is_addon`) VALUES ('113', '股东-团队', '0', '0', 'store/store-boss-agent/index/index', '', '2', '0', '999', NULL, '', '1', '0', '0', 'StoreBossAgent', '1');
INSERT INTO `qimall_addons_store_menu` (`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`, `addons_name`, `is_addon`) VALUES ('114', '股东列表', '0', '113', 'store/store-boss-agent/index/index', '', '2', '0', '999', NULL, '', '1', '0', '0', 'StoreBossAgent', '1');
INSERT INTO `qimall_addons_store_menu` (`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`, `addons_name`, `is_addon`) VALUES ('115', '股东等级', '0', '113', 'store/store-boss-agent/index/level', '', '2', '0', '999', NULL, '', '1', '0', '0', 'StoreBossAgent', '1');
INSERT INTO `qimall_addons_store_menu` (`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`, `addons_name`, `is_addon`) VALUES ('116', '提成明细', '0', '113', 'store/store-boss-agent/index/settlement-list', '', '2', '0', '999', NULL, '', '1', '0', '0', 'StoreBossAgent', '1');
INSERT INTO `qimall_addons_store_menu` (`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`, `addons_name`, `is_addon`) VALUES ('117', '基础设置', '0', '113', 'store/store-boss-agent/index/setting', '', '2', '0', '999', NULL, '', '1', '0', '0', 'StoreBossAgent', '1');

ALTER TABLE `qimall_addons_store_commission`
ADD COLUMN `store_agent_send_commission`  decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT '门店股东-团队直接发放佣金，不包含平台设置的插件佣金';

INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('StoreBossAgent', '门店股东', 'IncomeMap', '1', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('StoreBossAgent', '门店股东', 'FromTypeMap', '1', '1', '1654569888', '1654569888');

INSERT INTO `qimall_addons_store_addons` (`title`, `name`, `cover`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ('股东-团队', 'StoreBossAgent', '', '单门店营销工具', '1', '1702975895', '1702975895');

INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('diff_parent', '极差平均分红(上级代理)', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('diff_area_commission', '极差平均分红(区域代理)', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('diff_user', '极差平均分红(指定用户)', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('equal_upgrade', '平级代理分红', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');

ALTER TABLE `qimall_addons_agent_commission_item_setting`
ADD COLUMN `is_equal_by_upgrade`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启代理平级奖励 0 否 1 是',
ADD COLUMN `is_self_buy_alone`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启经销内购独立设置 0 否 1 是',
ADD COLUMN `is_self_buy`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启经销内购 0 否 1 是',
ADD COLUMN `enable_goods_deduct`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启商品抵扣 0 否 1 是';
--公排
ALTER TABLE `qimall_addons_public_line_level_change_log`
ADD COLUMN `order_id`  int(10) NOT NULL DEFAULT 0 COMMENT '订单id';
ALTER TABLE `qimall_addons_public_line_order`
ADD COLUMN `reward_num`  int(10) NOT NULL DEFAULT 0 COMMENT '可获得奖励次数';

CREATE TABLE `qimall_addons_public_line_reward_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) NOT NULL DEFAULT '0' COMMENT '商城ID',
  `from_order_no` varchar(100) NOT NULL DEFAULT '' COMMENT '来源订单编号',
  `reward_order_no` varchar(100) NOT NULL DEFAULT '' COMMENT '奖励订单编号',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(10) NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mall_id` (`mall_id`) USING BTREE,
  KEY `mall_id+user_id` (`mall_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='公排奖励记录表';

--门店核销券
INSERT INTO `qimall_addons_store_addons` (`title`, `name`, `cover`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ('核销券', 'VerificationCoupon', '', '单门店核销工具', '1', '1702975895', '1702975895');
--组合支付
CREATE TABLE `qimall_payment_trade_group_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trade_id` int(11) NOT NULL DEFAULT '0' COMMENT '流水表ID',
  `order_no` varchar(32) NOT NULL DEFAULT '' COMMENT '订单号',
  `order_type` varchar(32) NOT NULL DEFAULT '' COMMENT '订单类型',
  `pay_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单支付金额',
  `total_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单总金额，pay_fee+rand_fee',
  `rand_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单随机减金额',
  `is_pay` int(1) NOT NULL DEFAULT '0' COMMENT '支付状态：0=未支付，1=已支付',
  `pay_type` int(1) NOT NULL DEFAULT '0' COMMENT '支付方式：1=微信支付，2=货到付款，3=余额支付，4=支付宝支付，5=银联支付，6=汇聚聚合支付，7=汇聚快捷支付',
  `title` varchar(128) NOT NULL DEFAULT '' COMMENT '标题',
  `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  `notify_class` varchar(512) NOT NULL DEFAULT '',
  `refund_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退款金额',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `union_id` (`trade_id`) USING BTREE,
  KEY `order_no` (`order_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='订单组合支付记录表';
--蔚你而莱
 --表 qimall_addons_cloud_stock_rand_fee_order

ALTER TABLE `qimall_payment_trade`
ADD COLUMN `is_pay_group`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否组合支付订单 0 否 1 是',
ADD COLUMN `parent_trade_id`  int(11) NOT NULL DEFAULT 0 COMMENT '关联上级支付流水id（组合支付子订单不为空）';
ALTER TABLE `qimall_addons_cloud_stock_agent_order`
ADD COLUMN `trade_id`  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '支付流水记录id',
ADD COLUMN `pay_money`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '支付金额',
ADD COLUMN `order_no`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '自提订单编号',
ADD COLUMN `trade_no`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付流水号';

ALTER TABLE `qimall_addons_cloud_stock_goods`
ADD COLUMN `is_find_equal`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启紧缩层级平级奖';


--门店核销券
INSERT INTO `qimall_addons_store_addons` (`title`, `name`, `cover`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ('核销券', 'Verification', '', '单门店核销工具', '1', '1702975895', '1702975895');

INSERT INTO `qimall_addons_store_menu` (`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`, `addons_name`, `is_addon`) VALUES ('108', '核销券', '0', '0', 'store/verification/index/index', '', '2', '0', '999', NULL, '', '1', '0', '0', 'Verification', '1');
INSERT INTO `qimall_addons_store_menu` (`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`, `addons_name`, `is_addon`) VALUES ('109', '核销券', '0', '108', 'store/verification/index/index', '', '2', '0', '999', NULL, '', '1', '0', '0', 'Verification', '1');
INSERT INTO `qimall_addons_store_menu` (`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`, `addons_name`, `is_addon`) VALUES ('110', '会员核销券', '0', '108', 'store/verification/index/user', '', '2', '0', '999', NULL, '', '1', '0', '0', 'Verification', '1');
INSERT INTO `qimall_addons_store_menu` (`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`, `addons_name`, `is_addon`) VALUES ('111', '使用记录', '0', '108', 'store/verification/index/log', '', '2', '0', '999', NULL, '', '1', '0', '0', 'Verification', '1');
INSERT INTO `qimall_addons_store_menu` (`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`, `addons_name`, `is_addon`) VALUES ('112', '基础设置', '0', '108', 'store/verification/index/setting', '', '2', '0', '999', NULL, '', '1', '0', '0', 'Verification', '1');

CREATE TABLE `qimall_addons_store_verification_coupons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) NOT NULL DEFAULT '0' COMMENT '商城ID',
  `store_id` int(10) NOT NULL DEFAULT '0' COMMENT '门店ID',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '核销券名称',
  `num` int(10) NOT NULL DEFAULT '0' COMMENT '发行数量',
  `start_at` int(10) NOT NULL DEFAULT '0' COMMENT '使用时间',
  `end_at` int(10) NOT NULL DEFAULT '0' COMMENT '使用时间',
  `style_pic_url` varchar(255) NOT NULL DEFAULT '' COMMENT '核销券海报',
  `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `issued_num` int(10) NOT NULL DEFAULT '0' COMMENT '已发放数量',
  `used_num` int(10) NOT NULL DEFAULT '0' COMMENT '已核销数量',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(10) NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

CREATE TABLE `qimall_addons_store_verification_coupons_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) NOT NULL DEFAULT '0' COMMENT '商城ID',
  `store_id` int(10) NOT NULL DEFAULT '0' COMMENT '门店ID',
  `user_id` int(10) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `coupon_id` int(10) NOT NULL DEFAULT '0' COMMENT '核销券ID',
  `num` int(10) NOT NULL DEFAULT '0' COMMENT '发行数量',
  `used_num` int(10) NOT NULL DEFAULT '0' COMMENT '已核销数量',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(10) NOT NULL DEFAULT '0' COMMENT '修改时间',
  `is_transfer` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否他人转赠',
  `from_user_id` int(10) NOT NULL DEFAULT '0' COMMENT '来源用户ID',
  `from_coupon_user_id` int(10) NOT NULL DEFAULT '0' COMMENT '来源券ID',
  PRIMARY KEY (`id`),
  KEY `store_id` (`store_id`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE,
  KEY `coupon_id` (`coupon_id`) USING BTREE,
  KEY `from_coupon_user_id` (`from_coupon_user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

CREATE TABLE `qimall_addons_store_verification_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL DEFAULT '0',
  `key` varchar(255) NOT NULL,
  `value` longtext NOT NULL,
  `status` tinyint(4) DEFAULT '1' 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,
  KEY `mall_id` (`mall_id`) USING BTREE,
  KEY `key` (`key`(191)) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

CREATE TABLE `qimall_store_verification_coupons_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',
  `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 '修改时间',
  `coupon_id` int(10) NOT NULL DEFAULT '0' COMMENT '核销券ID',
  `from_coupon_user_id` int(10) NOT NULL DEFAULT '0' COMMENT '来源券ID',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `store_id` (`store_id`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE,
  KEY `coupon_id` (`coupon_id`) USING BTREE,
  KEY `from_coupon_user_id` (`from_coupon_user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='门店核销券明细';

--二二复制平级奖
ALTER TABLE `qimall_addons_double_copy_level_setting`
ADD COLUMN `equal_level_prize_type`  tinyint(4) NOT NULL DEFAULT 0 COMMENT '平级奖类型 0百分比 1 固定金额',
ADD COLUMN `equal_level_prize`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '平级奖';

ALTER TABLE `qimall_addons_double_copy_commission_item_setting_detail`
ADD COLUMN `equal_level_prize`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '平级奖';

--二二复制门店商品升级
ALTER TABLE `qimall_addons_double_copy_level`
ADD COLUMN `upgrade_type_store_goods`  smallint(6) NOT NULL DEFAULT 0 COMMENT '购买门店商品升级  0关闭 1 开启',
ADD COLUMN `buy_store_goods_type`  tinyint(4) NOT NULL DEFAULT 0 COMMENT '0订单完成 1下单 完成',
ADD COLUMN `store_goods_type`  smallint(6) NOT NULL DEFAULT 0 COMMENT '门店商品升级类型',
ADD COLUMN `store_goods_ids`  text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '门店商品仓库的ID',
ADD COLUMN `store_goods_list`  longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '门店商品列表';

--代理分红
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('agent_bonus_first', '直推奖励', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('agent_bonus_team', '代理商分红', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('agent_bonus_order', '报单奖励', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('AgentBonus', '代理分红', 'IncomeMap', '1', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('AgentBonus', '代理分红', 'FromTypeMap', '1', '1', '1654569888', '1654569888');

INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('代理分红：佣金解冻', 'agent-bonus/agent-bonus/frozen-to-active', '2', '0 1 0 * * *', '0', '1', '1710054237', '1710054237');

--消费券拓客
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('ConsumerCoupons', '消费券拓客', 'IncomeMap', '1', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('ConsumerCoupons', '消费券拓客', 'FromTypeMap', '1', '1', '1654569888', '1654569888');
INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('consumer_coupons_transfer', '消费券转入', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');

INSERT INTO `qimall_crontab_task` (`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('消费券拓客：冻结消费券自动转激活消费券', 'consumer-coupons/consumer-coupons/frozen-to-active', '2', '0 1 0 * * *', '0', '1', '1710054166', '1710054166');

--推三返一
ALTER TABLE `qimall_addons_rebate`
ADD COLUMN `repeat_setting`  tinyint(2) NULL DEFAULT 0 COMMENT '是否开启触发奖励设置[0=否，1=是]',
ADD COLUMN `agent_limit_num`  int(11) NULL DEFAULT 0 COMMENT '渠道分红订单限制';

--order_settlement_status-- qimall_addons_rebate_buy表没有这个字段

CREATE TABLE `qimall_addons_agent_cancel_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) unsigned NOT NULL DEFAULT '0',
  `source_table` varchar(255) NOT NULL DEFAULT '' COMMENT '来源表',
  `source_table_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作来源业务id',
  `from_type` varchar(50) NOT NULL DEFAULT '' COMMENT '来源类型',
  `order_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '记录时订单状态[0:支付;1:完成]',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态，-1：失效，1：正常，2：冻结',
  `created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间戳',
  `updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间戳',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_mall_user` (`mall_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='代理分红记录表';

--二二复制复购奖励
ALTER TABLE `qimall_addons_double_copy_level_setting` 
ADD COLUMN `repurchase_prize_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '复购奖励类型 0百分比 1 固定金额',
ADD COLUMN `repurchase_prize` decimal(10, 2) NOT NULL COMMENT '复购奖励';

ALTER TABLE `qimall_addons_double_copy_commission_item_setting_detail` 
ADD COLUMN `repurchase_prize` decimal(10, 2) NOT NULL COMMENT '复购奖励';