update.sql 1.1 KB

12345678910111213141516
  1. ALTER TABLE `zh_tender`
  2. ADD COLUMN `settle_order` tinyint(4) NULL DEFAULT 0 COMMENT '结算期数(用于结算变更数据更新判断)' AFTER `material_col_show`;
  3. CREATE TABLE `zh_change_settle_list` (
  4. `id` int NOT NULL AUTO_INCREMENT,
  5. `tid` int NULL COMMENT '标段id',
  6. `cid` varchar(50) NULL COMMENT '变更id',
  7. `gcl_id` varchar(255) NULL DEFAULT NULL COMMENT '项目节id',
  8. `mx_id` varchar(255) NULL DEFAULT NULL COMMENT '计量单元id',
  9. `amount` decimal(30, 8) NULL DEFAULT NULL COMMENT '终审数量',
  10. PRIMARY KEY (`id`)
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT = '变更已结算清单表(用于修订和重审时生成,防止已结算变更清单被删除)';
  12. ALTER TABLE `zh_rpt_archive_encryption`
  13. ADD COLUMN `business_id` VARCHAR(45) NULL COMMENT '有其他业务情况,统一在这里标识(类uuid),要结合stage_id来看,如stage_id > 0,则是标段和期,< 0则是其他业务,如 -300 -> 变更令;-301 - 变更方案;-302 - 变更立项 -303 - 变更申请' AFTER `stage_id`,
  14. ADD COLUMN `tender_id` INT(11) NULL AFTER `business_id`;