20210412 签到活动后台

xiaoyong931011

2021-04-12 067302e7ddd0bc605ee5664d11eb90f7ec06895f

 zq-erp/src/main/resources/config/db/increment/签到活动.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`;