3.1.10.sql 1.7 KB

12345678910111213141516171819202122232425262728
  1. /**3.1.10增量sql开始 (注:所有菜单增量后都需要在所需要的角色上配置菜单权限方可显示)**/
  2. DELETE FROM ai_module WHERE MODULE_ID = 'PROJECT_GROUP';
  3. INSERT INTO ai_module
  4. (MODULE_ID, MODULE_NAME, MODULE_DESC, ENDPOINT, MODULE_PID, ADDITION, MODULE_SOURCE, SORT_IDX, FULL_PATH, VALID_FLAG, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, ANONYMOUS_FLAG)
  5. VALUES
  6. ('PROJECT_GROUP', '项目组管理', '项目组管理', '/operation-manage/items-group', 'PROJECT_MANAGER', '{"iframeUrl":"","openType":"1"}', null, 501, 'USER_CENTER:ROLE', 1, 'admin', '2019-07-22 09:38:38', 'admin', null, -1);
  7. DELETE FROM ai_module WHERE MODULE_ID = 'TRAIN_TEMPLATE';
  8. INSERT INTO ai_module
  9. (MODULE_ID, MODULE_NAME, MODULE_DESC, SORT_IDX, ENDPOINT, MODULE_PID, ADDITION, MODULE_SOURCE, FULL_PATH, VALID_FLAG, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, ANONYMOUS_FLAG)
  10. VALUES
  11. ('TRAIN_TEMPLATE', '训练模板', '训练模板', 3, '/trainTemplate', 'MODEL_TRAIN', '{"iframeUrl":"","openType":"1"}', null, 'MODEL_TRAIN:MODEL_DEVELOPMENT', 1, 'admin', '2019-07-22 09:38:38', 'admin', null, -1);
  12. <<<<<<< HEAD
  13. UPDATE ai_module SET SORT_IDX = 5 WHERE MODULE_ID = 'NINTH_HEAVEN';
  14. =======
  15. UPDATE ai_module SET SORT_IDX = 4 WHERE MODULE_ID = 'NINTH_HEAVEN';
  16. /**3.1.10此sql为浙江用户特殊菜单排序需求可以不列入升级3.1.10版本里面去**/
  17. UPDATE ai_module SET SORT_IDX = 1 WHERE MODULE_ID = 'MODEL_CODE_SERVICE';
  18. UPDATE ai_module SET SORT_IDX = 2 WHERE MODULE_ID = 'TRAIN_TASK';
  19. UPDATE ai_module SET SORT_IDX = 3 WHERE MODULE_ID = 'NINTH_HEAVEN';
  20. UPDATE ai_module SET SORT_IDX = 4 WHERE MODULE_ID = 'TRAIN_TEMPLATE';
  21. UPDATE ai_module SET SORT_IDX = 5 WHERE MODULE_ID = 'MODEL_LIBRARY';
  22. /**结束**/
  23. >>>>>>> 3.1.10_dev
  24. /**3.1.10增量sql结束**/