| | |
|---|
| | | 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`; |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
