/*
 change.sql 说明
 1.数据库相关修改添加到对应的 change.sql 文件，无需调整其他 sql  文件
 2.sql 语句验证正确后再提交
*/
-- 增加系统属性配置：服务地址
INSERT INTO `portal_sys_properties`(`ID`, `NAME`, `ALIAS`, `GROUP_`, `VALUE`, `ENCRYPT`, `DESCRIPTION`, `UPDATE_TIME_`, `CREATE_BY_`, `CREATE_TIME_`, `CREATE_ORG_ID_`, `UPDATE_BY_`, `TENANT_ID_`) VALUES ('1446797732888117248', '服务地址', 'service.address', NULL, '[{\"code\":\"uc\",\"name\":\"uc\",\"value\":\"http://127.0.0.1:8088\"},{\"code\":\"portal\",\"name\":\"portal\",\"value\":\"http://127.0.0.1:8088\"},{\"code\":\"form\",\"name\":\"form\",\"value\":\"http://127.0.0.1:8088\"},{\"code\":\"bpmModel\",\"name\":\"bpmModel\",\"value\":\"http://127.0.0.1:8088\"},{\"code\":\"bpmRunTime\",\"name\":\"bpmRunTime\",\"value\":\"http://127.0.0.1:8088\"}]', 0, '服务地址', '2021-10-09 19:32:53', '1', '2021-10-09 19:20:34', '', '1', NULL);

-- zhangjun 2021-10-11 修改接口调用日志返回结果字段为大文本类型
ALTER TABLE `bpm_call_log` MODIFY COLUMN `RESPONSE_` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '调用结果' AFTER `IS_SUCCESS_`;
-- zhangjun 2021-10-12 修改菜单的请求方式别名的唯一索引：更改为别名与租户联合索引，不同租户的别名可重复
ALTER TABLE `portal_sys_method` DROP INDEX `IDX_SYSMETHOD_ALIAS_`, ADD UNIQUE INDEX `IDX_SYSMETHOD_ALIAS_`(`ALIAS_`, `TENANT_ID_`) USING BTREE;
-- zhangjun 2021-10-13 流程标签字段及标签分类
ALTER TABLE `bpm_definition` ADD COLUMN `TAGS_` varchar(400) NULL COMMENT '流程标签';
INSERT INTO `portal_sys_type`(`ID_`, `TYPE_GROUP_KEY_`, `NAME_`, `TYPE_KEY_`, `STRU_TYPE_`, `PARENT_ID_`, `DEPTH_`, `PATH_`, `IS_LEAF_`, `OWNER_ID_`, `SN_`, `CREATE_BY_`, `CREATE_TIME_`, `CREATE_ORG_ID_`, `UPDATE_BY_`, `UPDATE_TIME_`, `ICON_`, `TENANT_ID_`) VALUES ('1448213586020302848', 'TAG', '流程标签', 'flow', '1', '31120', 1, '11.31120.1448213586020302848.', 'Y', '0', 0, '1', '2021-09-20 13:25:41', '', NULL, NULL, '{}', '-1');

-- chenzm  2021-10-14 前台菜单流程中心添加传阅事项
INSERT INTO `portal_sys_menu` (`ID_`, `PARENT_ID_`, `NAME_`, `ALIAS_`, `ACTIVE_TAB_`, `MENU_ICON_`, `OPENED_`, `SN_`, `TABS_STYLE_`, `PATH_`, `HREF_`, `TENANT_ID_`, `ROUTE_EXTEND_`) VALUES ('1443153816786980864', '1441339605377536000', '传阅事项', 'circulateMatter', '', '', NULL, 5, '', '-1.3.1441339605377536000.1443153816786980864.', '', '-1', '{"path":"circulateMatter","component":"@/views/matter/circulateMatter","redirect":"","alwaysShow":false,"caseSensitive":false,"meta":{"title":"传阅事项","isChildren":true}}');