/*
 change.sql 说明
 1.数据库相关修改添加到对应的 change.sql 文件，无需调整其他 sql  文件
 2.sql 语句验证正确后再提交
*/

-- chenzm 2021-10-22 应用端获取待办列表字段显示配置时候固定的系统属性
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 ('1448569683989442560', '待办列表字段显示配置', 'taskListFiledConf', NULL, 'bHfSv3x1fi+lJABUhmU8OeY08mPnTHxMWR1WRuHJKS+YRaSDGCyf8BgNKnk/fKbQ6GB5pHWcTo+Pv7lHddu4nR0yd0ZumquJU67O2r7qQsRL1iat2BjwCcvWIvV9R9fD7wB1PAmt1cZJVyEcqqR9MNjH1+rLhv0r/XXVUTo8DLRgFO3zWkBGqJVpKU2LKa6RKdIxeR7A5MkP3NcLLIjxF8Q4FgCrt+ocxpIvkSv9vGUagCMJdv+DO/5w3IHLiGBuOx9OzWcXxklfhuxxfPLRFBqnbSBjHl43GzCH4AAWNgoXvGWkdvJSqkb2sgme/tKrP6YXNuVGj5hluovbLbMRT8e4Ta8uqn9OB51DypxPdukgSkLw3QBa12S3TSQVXrx9GeM8skAX42N32OKxLj7R7fTtyyHuc9CHt50BMcV8TAdI8iSTmm78T/LmjcDT0H4hF7xlpHbyUqpG9rIJnv7Sqxl20VdLRQ8aM8QwNIdsOhJCa7ol0YM+plxudRs3v+EvbUpuU1ePW3KNbmprxbg1wC+kD+SwF+UcjNcjIj6/7nVMRp5f3d8yyR0pQRSz5l3SkTgstjiLwzfngj73eizXn6WRZuGdSbqdMLHsVKVViJRClggscn8OTNdmwbVFdsEFlOpXb2v/2yaBGiWdmSfM282c37fPM7mFxGFz7nHh992DvDITRvzwC4pl2TcgaO0QJ6K9cnwlMuSOkGT0ovfGdUQOnPoVwNwniZ/Mf04694p1GqR5RjWQ2rEDtMCfWygZg7wyE0b88AuKZdk3IGjtEHLApmqwDQbhbxVAFM0ww1HlybaTqIbqfSiUnJ3VKs1PbUpuU1ePW3KNbmprxbg1wBOtalPwYWjNBu6+Z7ISw1sEgsBSJvRwvBDd7TSVkGYFmoCBpC+qEK/RS9taMUB1ks4W8RU9PjyENMhwuFuIxeyX/9nyXAdUdMwA61xqpUv9+sKkmJOg9t63DzSmbU4PG7DDxg0kfk5mvFtFiezJBbzdOqF1UpiAO/YY4TyU2uR6YQkCZlC5adaDe2xePIjxo86bglQid98MXskEnk5+jhwk1aDDztDfYxDcdnZzSib0aS/flNo7z+gapOaVNzA1/TGyHy7ts0MortNHigKEVUSetBhFCxdZ60Dbkwmd12OBryb0F/G+hiG0cZKCBgF4EpqAgaQvqhCv0UvbWjFAdZLY6GafWiUlgkBTmejqa9zY', 1, '应用端待办列表字段显示配置', NULL, '1', '2021-10-14 16:41:40', '', NULL, NULL);

-- yujl 2021-10-23 日志表新增外部系统来源
alter table portal_sys_logs add column SYSTEM_TYPE_ VARCHAR(255) default null COMMENT '外部系统来源';

-- yujl 2021-10-23 将外部接口授权管理功能集成到【集成管理】下
INSERT INTO portal_sys_menu ( id_, parent_id_, name_, alias_, menu_icon_, sn_, active_tab_, tabs_style_, path_, href_, ROUTE_EXTEND_, tenant_id_ )
VALUES ('1451456425861406720','1437975457390284800','外部接口管理','apiManager','',4,'','', '- 1.1.1437982148582154240.1437975457390284800.1451456425861406720.','', '{ "path" : "","component" : "","redirect" : "","alwaysShow" : false,"caseSensitive" : false, "meta" :{ "title" : "" }}','-1');


-- yujl 2021-10-23 将外部接口调用日志功能集成到【系统管理】->【系统日志】下
INSERT INTO portal_sys_menu ( id_, parent_id_, name_, alias_, menu_icon_, sn_, active_tab_, tabs_style_, path_, href_, ROUTE_EXTEND_, tenant_id_ )
VALUES('1451818951124017152','5403008','外部接口调用日志','externalSystemLog','',6,'','','- 1.1.3421053.5403008.1451818951124017152.','', '{ "path" : "", "component" : "","redirect" : "","alwaysShow" : false,"caseSensitive" : false,"meta" :{ "title" : "" }}', '-1' );

-- yujl 将【流程标签】与【表单标签】、【应用标签】平级
UPDATE portal_sys_type set PARENT_ID_='11' where id_='1448213586020302848';