deploy-manifests/k8s-rancher/6.admin-platform/10.1.init-portal.sql - institute/deploy-authx-service - Gitiles

 -- 10.1.init.sql

 /*
 将 paas.example.com 替换为 paas.学校域名.edu.cn
 */

 -- 以下脚本为可选操作

 /*
  * 若部署了流程平台、门户的产品
  * 可初始化云平台下的相关菜单数据
  */

 use admin_center;

 -- portal
 -- 如果部署，门户V5，请处理

 insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
 values ('60', 0, 'portal-api', '管理门户 - 门户接口', '1', '/api/v1/portal', 'http://ecampus.paas.example.com/', 1);

 commit;


 update TB_MGT_ROUTE
 set
   URL='http://ecampus.paas.example.com'
 where ID='60';  -- todo, modify

 commit;
 /*
 http://portal-web.portal.svc.cluster.local:8080/portal-web/api
 */


 insert into TB_MGT_ROLE (ID, DELETED, CODE, NAME, MEMO, STATUS)
 values ('60', 0, 'portal-admin', '门户管理员', '', '1');

 commit;


 /*
 update TB_MGT_PERMISSION
   set LFT = LFT+10
 where LFT>=89
 ;

 update TB_MGT_PERMISSION
   set RGT = RGT+10
 where RGT>=89
 ;
 */


 /*
 门户管理
   web端管理
     系统管理
     组件模板
     主题管理
     主题方案
   授权管理
     角色管理
   服务管理
     服务管理
     服务评价管理
     标签分类管理
   CMS管理
     幻灯片管理
     栏目管理
     内容管理
     流程管理
     模板管理
     滚动公告管理
   消息管理
     第三方消息发送设置
     消息类型管理
     消息发送详情
 */

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('60', 0, 'portal-manage', '门户管理', '1', '1', 'el-icon-s-help', '/',
   '60', '0', 60, 1, 93, 136);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6010000', 0, 'web', 'web端管理',
   '1', '2', null, null,
   '60', '60', 6010000, 1, 94, 105);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6010001', 0, 'web-systemManager', '系统管理',
   '1', '2', 'su-icon-xitongguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#web/systemManager/view.html',
   '60', '6010000', 6010001, 2, 95, 96);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6010002', 0, 'web-widgetTemplate', '组件模板',
   '1', '2', 'su-icon-zujianmoban', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#web/widgetTemplate/view.html',
   '60', '6010000', 6010002, 2, 97, 98);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6010003', 0, 'web-themeManager', '主题管理',
   '1', '2', 'su-icon-hutiguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#web/themeManager/view.html',
   '60', '6010000', 6010003, 2, 99, 100);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6010004', 0, 'web-themeScheme', '主题方案',
   '1', '2', 'su-icon-zhutifangan', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#web/themeScheme/view.html',
   '60', '6010000', 6010004, 2, 101, 102);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6010005', 0, 'web-oauthManager', 'oauth管理',
   '1', '2', 'su-icon-authguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#web/oauthManager/view.html',
   '60', '6010000', 6010005, 2, 103, 104);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6020000', 0, 'auth', '授权管理',
   '1', '2', null, null,
   '60', '60', 6020000, 1, 106, 109);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6020003', 0, 'auth-roleManager', '角色管理',
   '1', '2', 'su-icon-jiaoseguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#auth/roleManager/view.html',
   '60', '6020000', 6020003, 2, 107, 108);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6030000', 0, 'service', '服务管理',
   '1', '2', null, null,
   '60', '60', 6030000, 1, 110, 117);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6030001', 0, 'service-appservice', '服务管理',
   '1', '2', 'su-icon-fuwuguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#service/appservice/tabs.html',
   '60', '6030000', 6030001, 2, 111, 112);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6030002', 0, 'service-evaluate', '服务评价管理',
   '1', '2', 'su-icon-fuwupingjiaguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#service/evaluate/form.html',
   '60', '6030000', 6030002, 2, 113, 114);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6030003', 0, 'service-tagging', '标签分类管理',
   '1', '2', 'su-icon-biaoqianfenleiguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#service/tagging/form.html',
   '60', '6030000', 6030003, 2, 115, 116);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6040000', 0, 'cms', 'CMS管理',
   '1', '2', null, null,
   '60', '60', 6040000, 1, 118, 131);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6040001', 0, 'cms-slide', '幻灯片管理',
   '1', '2', 'su-icon-huandengpianguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/slide/list.html',
   '60', '6040000', 6040001, 2, 119, 120);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6040002', 0, 'cms-column', '栏目管理',
   '1', '2', 'su-icon-lanmuguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/column/list.html',
   '60', '6040000', 6040002, 2, 121, 122);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6040003', 0, 'cms-content', '内容管理',
   '1', '2', 'su-icon-neirongguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/content/list-manage.html',
   '60', '6040000', 6040003, 2, 123, 124);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6040004', 0, 'cms-flow', '流程管理',
   '1', '2', 'su-icon-liuchengguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/flow/list.html',
   '60', '6040000', 6040004, 2, 125, 126);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6040005', 0, 'cms-template', '模板管理',
   '1', '2', 'su-icon-mobanguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/template/list.html',
   '60', '6040000', 6040005, 2, 127, 128);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6040006', 0, 'cms-notice', '滚动公告管理',
   '1', '2', 'su-icon-gundonggonggaoguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/notice/list.html',
   '60', '6040000', 6040006, 2, 129, 130);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6050000', 0, 'message', '消息管理',
   '1', '2', null, null,
   '60', '60', 6050000, 1, 132, 139);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6050001', 0, 'message-sendsetting', '第三方消息发送设置',
   '1', '2', 'su-icon-disanfangxiaoxifasongshezhi', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#message/sendsetting/tabs.html',
   '60', '6050000', 6050001, 2, 133, 134);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6050002', 0, 'message-type', '消息类型管理',
   '1', '2', 'su-icon-xiaoxileixingguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#message/type/form.html',
   '60', '6050000', 6050002, 2, 135, 136);

 insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
   STATUS, TYPE_, ICON, URL,
   APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
 values ('6050003', 0, 'message-log', '消息发送详情',
   '1', '2', 'su-icon-xiaoxifasongxiangqing', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#message/sendlog/list.html',
   '60', '6050000', 6050003, 2, 137, 138);


 commit;


 insert into TB_MGT_ROLE_PERMISSION (ID, DELETED, ROLE_ID, PERMISSION_ID)

 select CONCAT('1_', ID) as ID, 0 as DELETED, '1' as ROLE_ID, ID as PERMISSION_ID
 from TB_MGT_PERMISSION
 where ID like '60_____' or ID='60'
 ;


 insert into TB_MGT_ROLE_PERMISSION (ID, DELETED, ROLE_ID, PERMISSION_ID)

 select CONCAT('60_', ID) as ID, 0 as DELETED, '60' as ROLE_ID, ID as PERMISSION_ID
 from TB_MGT_PERMISSION
 where ID like '60_____' or ID='60' or ID='1'
 ;

 commit;


 /* 更新 TB_MGT_PERMISSION 的 ORIGIN */
 /*
 select *
 from TB_MGT_PERMISSION
 where LFT >= (select LFT from TB_MGT_PERMISSION where ID='1')
   and RGT <= (select RGT from TB_MGT_PERMISSION where ID='1')
 ;
 */

 update TB_MGT_PERMISSION
 set
   ORIGIN='http://ecampus.paas.example.com'
 where APPLICATION_ID = '60'
 ;

 commit;
	-- 10.1.init.sql

	/*
	将 paas.example.com 替换为 paas.学校域名.edu.cn
	*/

	-- 以下脚本为可选操作

	/*
	* 若部署了流程平台、门户的产品
	* 可初始化云平台下的相关菜单数据
	*/

	use admin_center;

	-- portal
	-- 如果部署，门户V5，请处理

	insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
	values ('60', 0, 'portal-api', '管理门户 - 门户接口', '1', '/api/v1/portal', 'http://ecampus.paas.example.com/', 1);

	commit;


	update TB_MGT_ROUTE
	set
	URL='http://ecampus.paas.example.com'
	where ID='60'; -- todo, modify

	commit;
	/*
	http://portal-web.portal.svc.cluster.local:8080/portal-web/api
	*/


	insert into TB_MGT_ROLE (ID, DELETED, CODE, NAME, MEMO, STATUS)
	values ('60', 0, 'portal-admin', '门户管理员', '', '1');

	commit;


	/*
	update TB_MGT_PERMISSION
	set LFT = LFT+10
	where LFT>=89
	;

	update TB_MGT_PERMISSION
	set RGT = RGT+10
	where RGT>=89
	;
	*/


	/*
	门户管理
	web端管理
	系统管理
	组件模板
	主题管理
	主题方案
	授权管理
	角色管理
	服务管理
	服务管理
	服务评价管理
	标签分类管理
	CMS管理
	幻灯片管理
	栏目管理
	内容管理
	流程管理
	模板管理
	滚动公告管理
	消息管理
	第三方消息发送设置
	消息类型管理
	消息发送详情
	*/

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('60', 0, 'portal-manage', '门户管理', '1', '1', 'el-icon-s-help', '/',
	'60', '0', 60, 1, 93, 136);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6010000', 0, 'web', 'web端管理',
	'1', '2', null, null,
	'60', '60', 6010000, 1, 94, 105);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6010001', 0, 'web-systemManager', '系统管理',
	'1', '2', 'su-icon-xitongguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#web/systemManager/view.html',
	'60', '6010000', 6010001, 2, 95, 96);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6010002', 0, 'web-widgetTemplate', '组件模板',
	'1', '2', 'su-icon-zujianmoban', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#web/widgetTemplate/view.html',
	'60', '6010000', 6010002, 2, 97, 98);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6010003', 0, 'web-themeManager', '主题管理',
	'1', '2', 'su-icon-hutiguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#web/themeManager/view.html',
	'60', '6010000', 6010003, 2, 99, 100);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6010004', 0, 'web-themeScheme', '主题方案',
	'1', '2', 'su-icon-zhutifangan', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#web/themeScheme/view.html',
	'60', '6010000', 6010004, 2, 101, 102);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6010005', 0, 'web-oauthManager', 'oauth管理',
	'1', '2', 'su-icon-authguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#web/oauthManager/view.html',
	'60', '6010000', 6010005, 2, 103, 104);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6020000', 0, 'auth', '授权管理',
	'1', '2', null, null,
	'60', '60', 6020000, 1, 106, 109);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6020003', 0, 'auth-roleManager', '角色管理',
	'1', '2', 'su-icon-jiaoseguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#auth/roleManager/view.html',
	'60', '6020000', 6020003, 2, 107, 108);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6030000', 0, 'service', '服务管理',
	'1', '2', null, null,
	'60', '60', 6030000, 1, 110, 117);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6030001', 0, 'service-appservice', '服务管理',
	'1', '2', 'su-icon-fuwuguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#service/appservice/tabs.html',
	'60', '6030000', 6030001, 2, 111, 112);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6030002', 0, 'service-evaluate', '服务评价管理',
	'1', '2', 'su-icon-fuwupingjiaguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#service/evaluate/form.html',
	'60', '6030000', 6030002, 2, 113, 114);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6030003', 0, 'service-tagging', '标签分类管理',
	'1', '2', 'su-icon-biaoqianfenleiguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#service/tagging/form.html',
	'60', '6030000', 6030003, 2, 115, 116);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6040000', 0, 'cms', 'CMS管理',
	'1', '2', null, null,
	'60', '60', 6040000, 1, 118, 131);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6040001', 0, 'cms-slide', '幻灯片管理',
	'1', '2', 'su-icon-huandengpianguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/slide/list.html',
	'60', '6040000', 6040001, 2, 119, 120);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6040002', 0, 'cms-column', '栏目管理',
	'1', '2', 'su-icon-lanmuguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/column/list.html',
	'60', '6040000', 6040002, 2, 121, 122);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6040003', 0, 'cms-content', '内容管理',
	'1', '2', 'su-icon-neirongguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/content/list-manage.html',
	'60', '6040000', 6040003, 2, 123, 124);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6040004', 0, 'cms-flow', '流程管理',
	'1', '2', 'su-icon-liuchengguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/flow/list.html',
	'60', '6040000', 6040004, 2, 125, 126);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6040005', 0, 'cms-template', '模板管理',
	'1', '2', 'su-icon-mobanguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/template/list.html',
	'60', '6040000', 6040005, 2, 127, 128);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6040006', 0, 'cms-notice', '滚动公告管理',
	'1', '2', 'su-icon-gundonggonggaoguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#cms/notice/list.html',
	'60', '6040000', 6040006, 2, 129, 130);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6050000', 0, 'message', '消息管理',
	'1', '2', null, null,
	'60', '60', 6050000, 1, 132, 139);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6050001', 0, 'message-sendsetting', '第三方消息发送设置',
	'1', '2', 'su-icon-disanfangxiaoxifasongshezhi', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#message/sendsetting/tabs.html',
	'60', '6050000', 6050001, 2, 133, 134);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6050002', 0, 'message-type', '消息类型管理',
	'1', '2', 'su-icon-xiaoxileixingguanli', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#message/type/form.html',
	'60', '6050000', 6050002, 2, 135, 136);

	insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME,
	STATUS, TYPE_, ICON, URL,
	APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
	values ('6050003', 0, 'message-log', '消息发送详情',
	'1', '2', 'su-icon-xiaoxifasongxiangqing', 'http://ecampus.paas.example.com/portal-web/html/admin/index.html#message/sendlog/list.html',
	'60', '6050000', 6050003, 2, 137, 138);


	commit;



	insert into TB_MGT_ROLE_PERMISSION (ID, DELETED, ROLE_ID, PERMISSION_ID)

	select CONCAT('1_', ID) as ID, 0 as DELETED, '1' as ROLE_ID, ID as PERMISSION_ID
	from TB_MGT_PERMISSION
	where ID like '60_____' or ID='60'
	;



	insert into TB_MGT_ROLE_PERMISSION (ID, DELETED, ROLE_ID, PERMISSION_ID)

	select CONCAT('60_', ID) as ID, 0 as DELETED, '60' as ROLE_ID, ID as PERMISSION_ID
	from TB_MGT_PERMISSION
	where ID like '60_____' or ID='60' or ID='1'
	;

	commit;


	/* 更新 TB_MGT_PERMISSION 的 ORIGIN */
	/*
	select *
	from TB_MGT_PERMISSION
	where LFT >= (select LFT from TB_MGT_PERMISSION where ID='1')
	and RGT <= (select RGT from TB_MGT_PERMISSION where ID='1')
	;
	*/

	update TB_MGT_PERMISSION
	set
	ORIGIN='http://ecampus.paas.example.com'
	where APPLICATION_ID = '60'
	;

	commit;