beauty-erp.git - Gitblit

summary
reflog
commits
tree
docs
forks
compare

Helius

2021-11-08 9d1fa7183a25cbef2c6de82fd1f75da4f2353173

 zq-erp/src/main/resources/config/db/increment/签到活动.sql

@@ -187,6 +187,12 @@
ALTER TABLE `activity_sign_award_set`
    ADD COLUMN `customer_phone`  varchar(100) NULL COMMENT '客服电话' AFTER `company_id`;

ALTER TABLE `shop_delivery_info`
    MODIFY COLUMN `order_id`  int(11) NULL AFTER `logistics_company`;

ALTER TABLE `shop_delivery_info`
    MODIFY COLUMN `order_no`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `user_id`;

			@@ -187,6 +187,12 @@
			ALTER TABLE `activity_sign_award_set`
			ADD COLUMN `customer_phone` varchar(100) NULL COMMENT '客服电话' AFTER `company_id`;

			ALTER TABLE `shop_delivery_info`
			MODIFY COLUMN `order_id` int(11) NULL AFTER `logistics_company`;

			ALTER TABLE `shop_delivery_info`
			MODIFY COLUMN `order_no` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `user_id`;