Calculation/sql/update20201229.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`;

CREATE TABLE `zh_ledger_tag` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL COMMENT '项目id',
  `tid` int(11) NOT NULL COMMENT '标段id',
  `sid` int(11) NOT NULL DEFAULT '-1' COMMENT '期id(台账为-1)',
  `sorder` tinyint(4) NOT NULL DEFAULT '-1' COMMENT '第几期(台账为-1)',
  `uid` int(11) NOT NULL DEFAULT '-1' COMMENT '添加用户id',
  `lid` varchar(36) CHARACTER SET ascii NOT NULL DEFAULT '-1' COMMENT '关联台账id(zh_ledger表中的id)',
  `share` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否共享给其他参与人',
  `color` varchar(7) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT '书签颜色',
  `comment` text COLLATE utf8_unicode_ci COMMENT '批注',
  `create_time` datetime DEFAULT NULL,
  `modify_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;