Calculation/sql/update.sql

ALTER TABLE `zh_ledger_cooperation` ADD `company` VARCHAR(100) NULL DEFAULT '' COMMENT '单位或备注名，筛选用' AFTER `sign_path`;

--
-- 表的结构 `zh_cooperation_confirm`
--

CREATE TABLE `zh_cooperation_confirm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) NOT NULL COMMENT '标段id',
  `sid` int(11) NOT NULL COMMENT '期id',
  `times` tinyint(11) NOT NULL COMMENT '次数',
  `ledger_id` int(11) NOT NULL COMMENT '台账id',
  `uid` int(11) NOT NULL COMMENT '审批人id',
  `create_time` datetime DEFAULT NULL COMMENT '确认时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='多人协同确认表';

--
-- 表的结构 `zh_cooperation_pwd`
--

CREATE TABLE `zh_cooperation_pwd` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) NOT NULL COMMENT '标段id',
  `ledger_id` int(11) NOT NULL COMMENT '台账id',
  `uid` int(11) NOT NULL COMMENT '审批人id',
  `pwd` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '密码',
  `create_time` datetime DEFAULT NULL COMMENT '解锁时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='多人协同密码解锁表';


ALTER TABLE `zh_advance_audit`
CHANGE COLUMN `type` `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '预付款类型，0为开工预付款，1为材料预付款，2为安全生产费预付款' ;

ALTER TABLE `zh_advance_pay`
CHANGE COLUMN `type` `type` INT(1) NOT NULL DEFAULT '0' COMMENT '预付款类型，0为开工预付款，1为材料预付款，2位安全生产费预付款' ;

-- 接口相关
ALTER TABLE `zh_tender`
ADD COLUMN `s2b_gxby_check`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '工序报验-检查计量' AFTER `copy_id`,
ADD COLUMN `s2b_gxby_limit`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '限制上报' AFTER `s2b_gxby_check`,
ADD COLUMN `s2b_dagl_check`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '档案管理-检查计量' AFTER `s2b_gxby_limit`,
ADD COLUMN `s2b_dagl_limit`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '档案管理-限制上报' AFTER `s2b_dagl_check`;