Calculation/sql/update.sql

ALTER TABLE `zh_change` ADD `tp_decimal` TINYINT(3) NULL DEFAULT NULL COMMENT '金额位数' AFTER `sin_time`;

ALTER TABLE `zh_tender_info`
ADD COLUMN `bid_info`  varchar(200) NULL AFTER `tech_param`;

--
-- 表的结构 `zh_ledger_cooperation`
--

CREATE TABLE `zh_ledger_cooperation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) NOT NULL COMMENT '标段id',
  `ledger_id` int(11) NOT NULL COMMENT '台账id',
  `user_id` int(11) NOT NULL COMMENT '审批人id',
  `pwd` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '密码',
  `sign_path` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '电子签名地址',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否调用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='台账多人协同表';


CREATE UNIQUE INDEX `idx_tid_sid_rid`  ON `zh_rpt_custom_define` (tid, sid, rid) COMMENT '电子签名数据索引' ALGORITHM DEFAULT LOCK DEFAULT;

ALTER TABLE `zh_change_audit_list` ADD `xmj_dwgc` varchar(255) NULL DEFAULT NULL COMMENT '单位工程' AFTER `xmj_jldy`;
ALTER TABLE `zh_change_audit_list` ADD `xmj_fbgc` varchar(255) NULL DEFAULT NULL COMMENT '分部工程' AFTER `xmj_dwgc`;
ALTER TABLE `zh_change_audit_list` ADD `xmj_fxgc` varchar(255) NULL DEFAULT NULL COMMENT '分项工程' AFTER `xmj_fbgc`;