- ALTER TABLE `zh_tender`
- ADD COLUMN `copy_id` INT(10) NULL COMMENT '被拷贝标段id' AFTER `uuid`;
- ALTER TABLE `zh_change_audit_list` ADD `gcl_id` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '台账对应id(非准确)' AFTER `xmj_jldy`;
- UPDATE `zh_change_audit_list` SET `gcl_id`=`lid` WHERE `lid` != '0';
|