Calculation/sql/update.sql

ALTER TABLE `zh_tender`
ADD COLUMN `settle_order` tinyint(4) NULL DEFAULT 0 COMMENT '结算期数（用于结算变更数据更新判断）' AFTER `material_col_show`;

CREATE TABLE `zh_change_settle_list`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `tid` int NULL COMMENT '标段id',
  `cid` varchar(50) NULL COMMENT '变更id',
  `gcl_id` varchar(255) NULL DEFAULT NULL COMMENT '项目节id',
  `mx_id` varchar(255) NULL DEFAULT NULL COMMENT '计量单元id',
  `amount` decimal(30, 8) NULL DEFAULT NULL COMMENT '终审数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT = '变更已结算清单表（用于修订和重审时生成，防止已结算变更清单被删除）';