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='台账多人协同表';