| 1234567891011121314 |
- -- 商城顾客售后并入零售退款主表 xhHdRefund
- -- 用途：顾客申请落待审核记录（status=0），商家审核通过后再走资金/库存
- -- 执行前请确认 xhHdRefund 尚无 userId/hdId/product/rejectReason 字段
- ALTER TABLE `xhHdRefund`
- MODIFY COLUMN `status` tinyint(2) unsigned NOT NULL DEFAULT 0 COMMENT '0待审核 1已通过 2已驳回 3已取消',
- ADD COLUMN `userId` int(11) NOT NULL DEFAULT 0 COMMENT '商城用户id，商家发起为0' AFTER `customId`,
- ADD COLUMN `hdId` int(11) NOT NULL DEFAULT 0 COMMENT '花店客户id(xhHd)' AFTER `userId`,
- ADD COLUMN `product` varchar(2000) NOT NULL DEFAULT '' COMMENT '待审核阶段勾选商品/花材JSON快照，通过后转 xhHdRefundItem/Goods' AFTER `refundType`,
- ADD COLUMN `rejectReason` varchar(255) NOT NULL DEFAULT '' COMMENT '驳回原因' AFTER `remark`,
- ADD KEY `idx_userId_status` (`userId`,`status`),
- ADD KEY `idx_shop_status` (`shopId`,`status`);
- DROP TABLE IF EXISTS `xhMallRefundApply`;
|
