ALTER TABLE `zh_material_audit` ADD COLUMN `tp_data` json DEFAULT NULL COMMENT '金额数据(报表用)' AFTER `opinion`; ALTER TABLE `zh_material` ADD COLUMN `tp_data` json DEFAULT NULL COMMENT '上报人上报时的金额数据(报表用)' AFTER `is_stage_self`; ALTER TABLE `zh_tender` ADD COLUMN `material_col_show` json DEFAULT NULL COMMENT '调差列表展示合计控制'; ALTER TABLE `zh_change_audit_list` ADD COLUMN `camount_expr` varchar(500) DEFAULT '' COMMENT '变更数量计算式' AFTER `camount`; ALTER TABLE `zh_change_audit_list` ADD COLUMN `is_valuation` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否计价' AFTER `spamount`; ALTER TABLE `zh_change_audit_list` ADD COLUMN `delimit` int(4) NOT NULL DEFAULT 100 COMMENT '计量上限值'; ALTER TABLE `zh_change` ADD COLUMN `state` tinyint(1) NOT NULL DEFAULT 3 COMMENT '变更令状态(计量上限设置使用)'; ALTER TABLE `zh_change` ADD COLUMN `delimit` int(4) NOT NULL DEFAULT 100 COMMENT '计量上限值(用于对比项目及更新清单上限值)' AFTER `state`;