ALTER TABLE `tz_order`
|
ADD COLUMN `write_off_multiple_count` int NULL COMMENT '核销次数 -1.无限次' AFTER `write_off_num`;
|
ALTER TABLE `tz_prod`
|
ADD COLUMN `write_off_multiple_count` int NULL COMMENT '核销次数 -1.无限次' AFTER `write_off_num`;
|
ALTER TABLE `tz_order_virtual_info`
|
ADD COLUMN `write_off_multiple_count` int NULL COMMENT '剩余核销次数 -1.无限次' AFTER `write_off_time`;
|
# 更新商品数据
|
UPDATE `tz_prod` SET write_off_multiple_count = -1 WHERE write_off_num = -1 AND write_off_multiple_count IS NULL
|
