delete from HtmlLabelIndex where id = 539805 and ( indexdesc is null or indexdesc = '' )
GO
insert into HtmlLabelIndex(id,indexdesc) select top 1 539805,'模块管理分权' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 539805 and ( indexdesc is not null and indexdesc <> '' ))
GO
delete from HtmlLabelInfo where indexid = 539805 and languageid=7 and ( labelname is null or labelname = '' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' ))
GO
delete from HtmlLabelInfo where indexid = 539805 and languageid=8 and ( labelname is null or labelname = '' or labelname like '%[吖-座]%' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' and labelname not like '%[吖-座]%' ))
GO
delete from HtmlLabelInfo where indexid = 539805 and languageid=9 and ( labelname is null or labelname = '' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' ))
GO


delete from HtmlLabelIndex where id = 539804 and ( indexdesc is null or indexdesc = '' )
GO
insert into HtmlLabelIndex(id,indexdesc) select top 1 539804,'分权管理中心' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 539804 and ( indexdesc is not null and indexdesc <> '' ))
GO
delete from HtmlLabelInfo where indexid = 539804 and languageid=7 and ( labelname is null or labelname = '' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' ))
GO
delete from HtmlLabelInfo where indexid = 539804 and languageid=8 and ( labelname is null or labelname = '' or labelname like '%[吖-座]%' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' and labelname not like '%[吖-座]%' ))
GO
delete from HtmlLabelInfo where indexid = 539804 and languageid=9 and ( labelname is null or labelname = '' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' ))
GO



Delete from LeftMenuInfo where id=100178
GO
Delete from LeftMenuConfig where infoid=100178
GO
EXECUTE LMConfig_U_ByInfoInsert 2,100139,5
GO
EXECUTE LMInfo_Insert 100178,539804,'','',2,100139,5,2
GO
update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='' where id = 100178
GO

Delete from LeftMenuInfo where id=100179
GO
Delete from LeftMenuConfig where infoid=100179
GO
EXECUTE LMConfig_U_ByInfoInsert 2,100178,-1
GO
EXECUTE LMInfo_Insert 100179,539805,'','',2,100178,-1,2
GO
update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/organization/static/index.html#/main/organization/managerDetach' where id = 100179
GO


delete from SystemRightDetail where rightid =2727
GO
delete from SystemRightsLanguage where id =2727
GO
delete from SystemRights where id =2727
GO
delete from SystemRightToGroup where rightid =2727
GO
delete from SystemRightType where id =37
GO
delete from SystemRightGroups where id =-23
GO
insert into SystemRights (id,rightdesc,righttype,detachable) values (2727,'模块管理分权','37',0)
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2727,8,'Decentralization of module management','Decentralization of module management')
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2727,9,'模塊管理分權','模塊管理分權')
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2727,7,'模块管理分权','模块管理分权')
GO

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

insert into SystemRightToGroup(rightid,groupid) values (2727,-23)
GO
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理')
GO
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理')
GO

CREATE TABLE [JCL_ORG_DETACH] (
    [id] int  IDENTITY(1,1) NOT NULL,
    [manager_type] int  NULL,
    [ec_manager] int  NOT NULL,
    [jcl_manager] int  NOT NULL,
    [ec_rolelevel] varchar(4000) COLLATE Chinese_PRC_CI_AS  NOT NULL,
    [jcl_rolelevel] varchar(4000) COLLATE Chinese_PRC_CI_AS  NOT NULL,
    [manage_module] varchar(4000) COLLATE Chinese_PRC_CI_AS  NOT NULL,
    [creator] int  NULL,
    [delete_type] int  NULL,
    [create_time] date  NULL,
    [update_time] date  NULL
)
GO

ALTER TABLE [JCL_ORG_DETACH] SET (LOCK_ESCALATION = TABLE)
GO

ALTER TABLE [JCL_ORG_DETACH] ADD CONSTRAINT [JCL_ORG_DETACH_PK] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
    ON [PRIMARY]
GO