CREATE TABLE `zh_construction_attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) NOT NULL COMMENT '标段id',
  `log_id` int(11) NOT NULL COMMENT '日志id',
  `uid` int(11) NOT NULL COMMENT '上传者id',
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
  `fileext` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
  `filesize` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
  `filepath` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
  `upload_time` datetime NOT NULL COMMENT '上传时间',
  `extra_upload` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为审核通过后再次上传的文件，0为否',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT='施工日志附件表';

CREATE TABLE `zh_construction_audit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) NOT NULL COMMENT '标段id',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `is_report` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否上报人',
  `in_time` datetime NOT NULL COMMENT '新增时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT='施工日志管理人员表';

CREATE TABLE `zh_construction_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) NOT NULL COMMENT '标段id',
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '编号',
  `date_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '日期，用于code的编号生成',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '日志类型',
  `period` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '时间/周期',
  `report_uid` int(11) NOT NULL COMMENT '上报人id',
  `shenpi_uid` int(11) DEFAULT NULL COMMENT '签审人id',
  `log_json` json DEFAULT NULL COMMENT '日志内容',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `start_time` datetime DEFAULT NULL COMMENT '提交时间',
  `checked_time` datetime DEFAULT NULL COMMENT '审签时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT='施工日志内容表';

ALTER TABLE `zh_tender`
ADD COLUMN `build_status`  tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '建设状态(1在建，2完工)' AFTER `rpt_show_level`;

-- 会签或签 暂不更新 --
ALTER TABLE `zh_tender_cache`
MODIFY COLUMN `stage_flow_cur_uid`  varchar(1000) NOT NULL DEFAULT 0 COMMENT '期-当前流程人id(,间隔)' AFTER `stage_complete_count`,
MODIFY COLUMN `stage_flow_pre_uid`  varchar(1000) NOT NULL DEFAULT 0 COMMENT '期-上一流程人id(,间隔)' AFTER `stage_flow_cur_tp`;

ALTER TABLE `zh_shenpi_audit`
ADD COLUMN `audit_type`  tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '审批类型(1个人，2会签，3或签)' AFTER `audit_id`,
ADD COLUMN `audit_order`  tinyint(4) UNSIGNED ZEROFILL NOT NULL DEFAULT 0 COMMENT '审批顺序' AFTER `audit_type`;

ALTER TABLE `zh_stage_audit`
ADD COLUMN `audit_type`  tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '审批类型(1个人，2会签，3或签)' AFTER `is_old`;