Calculation/sql/update.sql

-- ----------------------------
-- Table structure for zh_external_data
-- ----------------------------

CREATE TABLE `zh_external_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) NOT NULL COMMENT '标段id',
  `sid` int(11) NOT NULL DEFAULT '-1' COMMENT '所属期id，-1表示整个标段共用',
  `ex_type` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '额外数据 - 类型(''fl'': 富龙接口数据)',
  `ex_field` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '额外数据 - 名称(具体细分由ex_type决定)',
  `ex_value` text CHARACTER SET utf8 COMMENT '额外数据 - 值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='外部所需数据\r\n非计量支付内部运行所需数据，当接入外部系统时，这些系统可能要求我们提供某些额外的数据，例如：富龙接口，wbs_code\r\n类似数据，均存储在这里';

-- ----------------------------
-- zh_stage_bonus add column 发文单位
-- ----------------------------
ALTER TABLE `zh_stage_bonus`
ADD COLUMN `doc_co`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '发文单位' AFTER `code`;

-- ----------------------------
-- zh_stage_bonus add column 依据材料 - 文件列表
-- ----------------------------
ALTER TABLE `zh_stage_bonus`
ADD COLUMN `proof_file`  text CHARACTER SET utf8 NULL COMMENT '依据材料 - 文件列表(json)' AFTER `proof`;


-- 更改 zh_role_rpt_rel 结构，增加stage id
ALTER TABLE `zh_role_rpt_rel`
ADD COLUMN `sid` INT NULL AFTER `rpt_id`,
DROP INDEX `tender_idx` ,
ADD INDEX `tender_idx` (`tender_id` ASC, `rpt_id` ASC);


-- ----------------------------
-- Table structure for zh_maintain
-- ----------------------------
CREATE TABLE `zh_maintain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `maintain_time` varchar(15) COLLATE utf8_unicode_ci NOT NULL COMMENT '维护时间',
  `duration` tinyint(4) NOT NULL DEFAULT '2' COMMENT '维护时长',
  `msg` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '维护内容',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '维护状态，0：未设置，1：未开始，2：进行中',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='系统维护信息表';


INSERT INTO `zh_maintain` (`id`, `maintain_time`, `duration`, `msg`, `status`) VALUES
(1, '', 2, '', 0);

-- ----------------------------
-- zh_message add column 创建者id
-- ----------------------------
ALTER TABLE `zh_message`
ADD COLUMN `create_uid` int(11) DEFAULT NULL COMMENT '创建者id' AFTER `create_time`;

-- ----------------------------
-- zh_message add column 项目id
-- ----------------------------
ALTER TABLE `zh_message`
ADD COLUMN `project_id` int(11) DEFAULT NULL COMMENT '项目id，针对项目通知' AFTER `create_uid`;

-- ----------------------------
-- zh_message add column 是否置顶
-- ----------------------------
ALTER TABLE `zh_message`
ADD COLUMN `istop` varchar(15) NOT NULL DEFAULT '0' COMMENT '是否置顶，0为非置顶，时间戳为置顶时间' AFTER `release_time`;

-- ----------------------------
-- zh_message change column content
-- ----------------------------
ALTER TABLE `zh_message`
CHANGE `content` `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '消息内容';

-- ----------------------------
-- zh_message change column create_time
-- ----------------------------
ALTER TABLE `zh_message`
CHANGE `create_time` `create_time` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '创建时间';

-- ----------------------------
-- zh_message change column creator
-- ----------------------------
ALTER TABLE `zh_message`
CHANGE `creator` `creator` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建者';

-- ----------------------------
-- zh_message change column type
-- ----------------------------
ALTER TABLE `zh_message`
CHANGE `type` `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '消息类型 1为项目 2为系统';

-- ----------------------------
-- zh_message change column status
-- ----------------------------
ALTER TABLE `zh_message`
CHANGE `status` `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '消息状态，1：已发布，2：未发布';

-- ----------------------------
-- zh_message change column release_time
-- ----------------------------
ALTER TABLE `zh_message`
CHANGE `release_time` `release_time` int(10) NOT NULL DEFAULT '0' COMMENT '发布时间';

-- ----------------------------
-- zh_project add column 是否定制项目
-- ----------------------------
ALTER TABLE `zh_project`
ADD COLUMN `custom` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是定制项目' AFTER `dealpay_json`;

-- ----------------------------
-- zh_project add column 定制项目接口是否可用
-- ----------------------------
ALTER TABLE `zh_project`
ADD COLUMN `can_api` tinyint(1) NOT NULL DEFAULT '1' COMMENT '定制项目接口是否可用';

-- ----------------------------
-- zh_project add column 定制项目私钥
-- ----------------------------
ALTER TABLE `zh_project`
ADD COLUMN `secret` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '定制项目私钥';

-- ----------------------------
-- zh_project_account add column 是否已绑定定制项目
-- ----------------------------
ALTER TABLE `zh_project_account`
ADD COLUMN `bind` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已绑定定制项目' AFTER `sms_type`;

-- ----------------------------
-- 权限控制表，新增部分权限
-- ----------------------------
INSERT INTO `calculation`.`zh_permission` (`id`, `name`, `controller`, `action`, `pid`, `icon_class`, `create_time`, `isshow`) VALUES ('67', '系统维护', 'maintain', '', '11', '', NULL, '1');
INSERT INTO `calculation`.`zh_permission` (`id`, `name`, `controller`, `action`, `pid`, `icon_class`, `create_time`, `isshow`) VALUES ('68', '第三方接口', 'project', 'api2other', '38', 'api2other', NULL, '1');
INSERT INTO `calculation`.`zh_permission` (`id`, `name`, `controller`, `action`, `pid`, `icon_class`, `create_time`, `isshow`) VALUES ('69', '第三方接口设置', 'project', 'api2otherSave', '38', '', NULL, '1');

update `calculation`.`zh_permission` set `name` = '消息管理', `isshow` = 1 where `id` = 31;
update `calculation`.`zh_permission` set `name` = '消息通知', `isshow` = 1 where `id` = 32;
update `calculation`.`zh_permission` set `create_time` = '1' where `id` = 62;