delete from HtmlLabelIndex where id = 539805 and ( trim(indexdesc) is null );
/

insert into HtmlLabelIndex(id,indexdesc) select 539805,'模块管理分权' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 539805 and ( trim(indexdesc) is not null )) and rownum = 1;
/

delete from HtmlLabelInfo where indexid = 539805 and languageid=7 and ( trim(labelname) is null );
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539805 as indexid ,'模块管理分权' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539805 and languageid=7 and ( trim(labelname) is not null )) and rownum = 1;
/

delete from HtmlLabelInfo where indexid = 539805 and languageid=8 and ( trim(labelname) is null or length(labelname)!=lengthb(labelname) );
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539805 as indexid ,'Decentralization of module management' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539805 and languageid=8 and ( trim(labelname) is not null and length(labelname)=lengthb(labelname) )) and rownum = 1;
/

delete from HtmlLabelInfo where indexid = 539805 and languageid=9 and ( trim(labelname) is null );
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539805 as indexid ,'模塊管理分權' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539805 and languageid=9 and ( trim(labelname) is not null )) and rownum = 1;
/

delete from HtmlLabelIndex where id = 539804 and ( trim(indexdesc) is null );
/

insert into HtmlLabelIndex(id,indexdesc) select 539804,'分权管理中心' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 539804 and ( trim(indexdesc) is not null )) and rownum = 1;
/

delete from HtmlLabelInfo where indexid = 539804 and languageid=7 and ( trim(labelname) is null );
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539804 as indexid ,'分权管理中心' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539804 and languageid=7 and ( trim(labelname) is not null )) and rownum = 1;
/

delete from HtmlLabelInfo where indexid = 539804 and languageid=8 and ( trim(labelname) is null or length(labelname)!=lengthb(labelname) );
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539804 as indexid ,'Decentralized management center' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539804 and languageid=8 and ( trim(labelname) is not null and length(labelname)=lengthb(labelname) )) and rownum = 1;
/

delete from HtmlLabelInfo where indexid = 539804 and languageid=9 and ( trim(labelname) is null );
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539804 as indexid ,'分權管理中心' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539804 and languageid=9 and ( trim(labelname) is not null )) and rownum = 1;
/

Delete from LeftMenuInfo where id=100178;
/

Delete from LeftMenuConfig where infoid=100178;
/

call LMConfig_U_ByInfoInsert (2,100139,5);
/

call LMInfo_Insert (100178,539804,'','',2,100139,5,2);
/

update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='' where id = 100178;
/

Delete from LeftMenuInfo where id=100179;
/

Delete from LeftMenuConfig where infoid=100179;
/

call LMConfig_U_ByInfoInsert (2,100178,-1);
/

call LMInfo_Insert (100179,539805,'','',2,100178,-1,2);
/

update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/organization/static/index.html#/main/organization/managerDetach' where id = 100179;
/

delete from SystemRightDetail where rightid =2727;
/

delete from SystemRightsLanguage where id =2727;
/

delete from SystemRights where id =2727;
/

delete from SystemRightToGroup where rightid =2727;
/

delete from SystemRightType where id =37;
/

delete from SystemRightGroups where id =-23;
/

insert into SystemRights (id,rightdesc,righttype,detachable) values (2727,'模块管理分权','37',0);
/

insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2727,8,'Decentralization of module management','Decentralization of module management');
/

insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2727,9,'模塊管理分權','模塊管理分權');
/

insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2727,7,'模块管理分权','模块管理分权');
/

insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (44005,'模块管理分权权限','MangerDeatch:All',2727);
/

insert into SystemRightToGroup(rightid,groupid) values (2727,-23);
/

insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
/

insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
/

CREATE TABLE JCL_ORG_DETACH (
  ID NUMBER NOT NULL,
  MANAGER_TYPE NUMBER NULL,
  EC_MANAGER NUMBER NOT NULL,
  JCL_MANAGER NUMBER NOT NULL,
  EC_ROLELEVEL VARCHAR(4000) NOT NULL,
  JCL_ROLELEVEL VARCHAR(4000) NOT NULL,
  MANAGE_MODULE VARCHAR(4000) NOT NULL,
  CREATOR NUMBER NULL,
  DELETE_TYPE NUMBER NULL,
  CREATE_TIME DATE NULL,
  UPDATE_TIME DATE NULL,
  CONSTRAINT JCL_ORG_DETACH_PK PRIMARY KEY (ID)
);
/

CREATE SEQUENCE JCL_ORG_DETACH_ID INCREMENT BY 1 START WITH 1 nomaxvalue minvalue 1 NOCYCLE;
/

CREATE
OR REPLACE TRIGGER JCL_ORG_DETACH_ID_TIGGER BEFORE INSERT ON JCL_ORG_DETACH FOR EACH ROW
BEGIN
SELECT
    JCL_ORG_DETACH_ID.nextval INTO:new.ID
FROM
    dual;
END;
/