jyy
2021-04-14 2fdc11a7f356bec787a7c7f6301af0b94ef87a4c
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`;