zq-erp/src/main/resources/config/db/increment/推广员.sql
@@ -209,3 +209,15 @@ ALTER TABLE `shop_order` DROP COLUMN `score_pay`, ADD COLUMN `score_pay` int(20) NULL COMMENT '支付积分' AFTER `company_id`; ALTER TABLE `shop_advertis` ADD COLUMN `page_id` bigint(0) NULL COMMENT '连接页面' AFTER `company_id`; ALTER TABLE `shop_sku` DROP COLUMN `self_price`, ADD COLUMN `self_price` decimal(20,2) NULL AFTER `score_count`; ALTER TABLE `shop_salesman_grade` DROP COLUMN `self_commission`, ADD COLUMN `self_commission` double(20,2) NULL COMMENT '自购返佣比例%' AFTER `company_id`;