1234567891011121314151617181920212223242526272829 |
- ALTER TABLE `zh_s2b_proj`
- ADD COLUMN `common_option` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '通用配置' AFTER `dagl_option`;
- ALTER TABLE `zh_tender_info` ADD `shenpi` VARCHAR(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批流程设置' AFTER `pay_account`;
- ALTER TABLE `zh_material_file`
- ADD COLUMN `extra_upload` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否是审核完成后上传的,0:否、1:是' AFTER `fileext`;
- ALTER TABLE `zh_pos`
- MODIFY COLUMN `gxby_status` int(4) NULL DEFAULT -1 COMMENT '工序报验-状态' AFTER `real_qty`,
- MODIFY COLUMN `dagl_status` int(4) NULL DEFAULT -1 COMMENT '档案管理-状态' AFTER `gxby_status`;
- ALTER TABLE `zh_stage_attachment`
- CHANGE COLUMN `re_upload` `extra_upload` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否为审核通过后再次上传的文件,0为否' ;
- ALTER TABLE `zh_change_attachment`
- ADD COLUMN `extra_upload` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否为审核通过后再次上传的文件,0为否' AFTER `in_time`;
- CREATE TABLE `zh_shenpi_audit` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `tid` int(11) NOT NULL COMMENT '标段id',
- `sp_type` tinyint(4) NOT NULL COMMENT '审批流程类型',
- `sp_status` tinyint(4) NOT NULL COMMENT '所选审批流程状态',
- `audit_id` int(11) NOT NULL COMMENT '审批人id',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='审批流程人设置表';
- -- 2020/11/4 更新到uat
- -- 2020/11/5 更新到prod
|