jyy
2021-04-21 4dfe83675fc23f4514b6c3cf44fcc84c7e0b52a8
zq-erp/src/main/resources/config/db/increment/签到活动.sql
@@ -172,6 +172,27 @@
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`;
ALTER TABLE `activity_sign_award_set`
    ADD COLUMN `customer_phone`  varchar(100) NULL COMMENT '客服电话' AFTER `company_id`;