From 067302e7ddd0bc605ee5664d11eb90f7ec06895f Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Mon, 12 Apr 2021 14:44:00 +0800 Subject: [PATCH] 20210412 签到活动后台 --- zq-erp/src/main/resources/config/db/increment/签到活动.sql | 16 ++++++++++++++++ 1 files changed, 16 insertions(+), 0 deletions(-) diff --git "a/zq-erp/src/main/resources/config/db/increment/\347\255\276\345\210\260\346\264\273\345\212\250.sql" "b/zq-erp/src/main/resources/config/db/increment/\347\255\276\345\210\260\346\264\273\345\212\250.sql" index 6380d46..966c947 100644 --- "a/zq-erp/src/main/resources/config/db/increment/\347\255\276\345\210\260\346\264\273\345\212\250.sql" +++ "b/zq-erp/src/main/resources/config/db/increment/\347\255\276\345\210\260\346\264\273\345\212\250.sql" @@ -172,6 +172,22 @@ PRIMARY KEY(id) )ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='核销记录'; +ALTER TABLE `activity_sign_receive_record` +ADD COLUMN `consignee` varchar(200) NULL COMMENT '收货人' AFTER `user_id`; + +ALTER TABLE `activity_sign_receive_record` +ADD COLUMN `consignee_phone` varchar(50) NULL COMMENT '联系电话' AFTER `user_id`; + +ALTER TABLE `activity_sign_receive_record` +ADD COLUMN `consignee_address` varchar(300) NULL COMMENT '收货地址' AFTER `consignee_phone`; + +ALTER TABLE `shop_delivery_info` +ADD COLUMN `receive_id` bigint(20) NULL COMMENT '奖品领取ID' AFTER `company_id`; + + + + + -- Gitblit v1.9.1