aihub-web/sql/menu-3.1.9.0.sql

/**3.1.9增量sql开始 (注：所有菜单增量后都需要在所需要的角色上配置菜单权限方可显示)**/
DELETE FROM ai_module WHERE MODULE_ID = 'TENANTS';
INSERT INTO ai_module
  (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)
VALUES
  ('TENANTS', '租户管理', '租户管理', '/sysmgr/tenants', 'SYSMGR', '{"iframeUrl":"","openType":"1"}', null, 501, 'USER_CENTER:USER', 1, 'admin', '2019-07-22 09:38:38', 'admin', null, -1);

DELETE FROM ai_module WHERE MODULE_ID = 'DISPATCH_MANAGER';
INSERT INTO ai_module
  (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)
VALUES
  ('DISPATCH_MANAGER', '调度管理', '调度管理', '', 'AI_DEVELOP', '{"icon":"dispatch","iframeUrl":"","openType":"1"}', null, 700, 'MODEL_APPLY', 1, 'admin', '2019-09-20 09:38:38', 'admin', null, -1);

DELETE FROM ai_module WHERE MODULE_ID = 'DISPATCH_TASK';
INSERT INTO ai_module
  (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)
VALUES
  ('DISPATCH_TASK', '调度任务', '调度任务', '/sysmgr/dispatchTaskList', 'DISPATCH_MANAGER', '{"iframeUrl":"","openType":"1"}', null, 904, 'SYSMGR:DB_SETTING', 1, 'admin', '2019-07-22 09:38:38', 'admin', null, -1);

/**修改调度监控 [调度监控菜单根据现场的路径自行修改iframeUrl 里面的值]**/
DELETE FROM ai_module WHERE MODULE_ID = 'DISPATCH_MONITORING';
INSERT INTO ai_module
  (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)
VALUES
  ('DISPATCH_MONITORING', '调度监控', '调度监控', '/iframe_load/dispatchMonitoring', 'DISPATCH_MANAGER', '{"openType":"1","iframeUrl":"https://www.baidu.com/?tn=78000241_30_hao_pg"}', null, 905, 'SYSMGR:DB_SETTING', 1, 'admin', '2019-07-22 09:38:38', 'admin', null, -1);

/**修改调度监控菜单结束**/

DELETE FROM ai_module WHERE MODULE_ID = 'TRAIN_TASK';
INSERT INTO ai_module
  (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)
VALUES
  ('TRAIN_TASK', '向导式建模', '向导式建模', '/trainTask', 'MODEL_TRAIN', '{"iframeUrl":"","openType":"1"}', null, 3, 'MODEL_TRAIN:MODEL_DEVELOPMENT', 1, 'admin', '2019-07-22 09:38:38', 'admin', null, -1);

DELETE FROM ai_module WHERE MODULE_ID = 'TRAIN_TEMPLATE';
INSERT INTO ai_module
  (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)
VALUES
  ('TRAIN_TEMPLATE', '向导式训练模板', '向导式训练模板', '/trainTemplate', 'MODEL_TRAIN', '{"iframeUrl":"","openType":"1"}', null, 2, 'MODEL_TRAIN:MODEL_DEVELOPMENT', 1, 'admin', '2019-07-22 09:38:38', 'admin', null, -1);

UPDATE ai_module SET VALID_FLAG = -1  WHERE MODULE_ID = 'SERVICE_CODE'

/**修改专区菜单开始 [专区菜单根据现场的路径自行修改iframeUrl 里面的值]**/
UPDATE ai_module SET ADDITION='{"icon":"specialArea","menuType":"tabs","iframeUrl":"","openType":"1","sonMenuLayout":"top"}'  WHERE MODULE_ID = 'SPECIAL_AREA'

DELETE FROM ai_module WHERE MODULE_ID = 'NLP';
INSERT INTO ai_module
  (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)
VALUES
  ('NLP', 'NLP专区', 'NLP专区', '/home/nlp', 'SPECIAL_AREA', '{"iframeUrl":"http://20.26.85.34:30016/#/home","openType":"1","iFrameOpenType":"new"}', null, 1800, 'FOOT', 1, 'admin', '2019-07-22 22:38:38', 'admin', null, 1);

DELETE FROM ai_module WHERE MODULE_ID = 'RPA';
INSERT INTO ai_module
  (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)
VALUES
  ('RPA', 'RPA专区', 'RPA专区', '/home/rpa', 'SPECIAL_AREA', '{"iframeUrl":"http://20.26.85.34:30016/#/home","openType":"1","iFrameOpenType":"new"}', null, 1800, 'FOOT', 1, 'admin', '2019-07-22 22:38:38', 'admin', null, 1);
/**修改专区菜单结束**/

/** 更新右侧帮助链接**/
UPDATE ai_config_options
SET option_name='帮助', option_desc='帮助', module_id='root.app', config_type=2, config_desc='帮助', option_source=NULL, default_value='[{"title":"帮助手册","type":"btn","items":[{"title":"1. 本文档帮助用户开展一个动态的高亮图标，便于了解系统的操作。","action":{"type":"btn-dialog","text":"动态指示","target":"_blank","path":"/preview/README.html#101"}},{"title":"2. 本文档帮助用户进行操作类的文档说明。","action":{"type":"link","text":"操作指南","target":"_blank","path":"/preview/README.html#102"}},{"title":"3. 本文档帮助用户查看开发类的案例。","action":{"type":"link","text":"示例","target":"_blank","path":"/preview/README.html#103"}},{"title":"4. 本文档帮助用户查看一些常见运行问题。","action":{"type":"link","text":"常见问题","target":"_blank","path":"/preview/README.html#104"}}]},{"title":"常用名称解释","type":"desc","items":[{"title":"平台说明：","desc":"数据智能平台融合数据-模型-服务为一体，实现资源逻辑隔离的一站式开发。"},{"title":"项目：","desc":"资源逻辑隔离实体。"},{"title":"项目成员：","desc":"项目下的团队成员。"},{"title":"项目资源：","desc":"项目下开发、测试、生产的物理资源。"},{"title":"数据集：","desc":"能用于模型开发和推理的数据。"},{"title":"结构化数据集：","desc":"以表为主的数据。"},{"title":"非结构化数据集：","desc":"以图片、文本为主的数据。"},{"title":"数据开发任务：","desc":"结构化/非结构化数据的开发和标注任务。"},{"title":"编码训练：","desc":"编码为核心的模型训练，适合程序员。"},{"title":"向导式训练：","desc":"封装模型，提供可视化向导流程的模型训练，适合业务人员。"},{"title":"在线推理服务：","desc":"模型发布成在线API服务。"},{"title":"离线推理任务：","desc":"模型发布成离线API任务。"},{"title":"基础镜像：","desc":"提供环境和算法包的镜像，不具备业务能力。"},{"title":"训练镜像：","desc":"提供环境和算法包的镜像，具备编码建模训练能力。"},{"title":"推理镜像：","desc":"提供环境和算法包的镜像，具备启动API服务。"}]}]', valid_flag=1, sort_index=53
WHERE option_id='root.app.drawer:help';


/**3.1.9增量sql结束**/