delete from SystemRightDetail where rightid =2696
GO
delete from SystemRightsLanguage where id =2696
GO
delete from SystemRights where id =2696
GO
delete from SystemRightToGroup where rightid =2696
GO
delete from SystemRightType where id =37
GO
delete from SystemRightGroups where id =-23
GO
insert into SystemRights (id,rightdesc,righttype,detachable) values (2696,'组织管理权限','37',0)
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2696,8,'Organization management permission','Organization management permission')
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2696,9,'組織管理權限','組織管理權限')
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2696,7,'组织管理权限','组织管理权限')
GO

insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43972,'等级方案权限','Scheme:All',2696)
GO
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43975,'岗位序列权限','Sequence:All',2696)
GO
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43979,'分部管理权限','Company:All',2696)
GO
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43983,'编制表权限','Staff:All',2696)
GO
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43977,'职务信息权限','PostInfo:All',2696)
GO
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43982,'编制方案权限','StaffPlan:All',2696)
GO
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43973,'职等权限','Level:All',2696)
GO
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43976,'职务分类权限','Post:All',2696)
GO
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43980,'部门管理权限','Department:All',2696)
GO
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43981,'岗位管理权限','Job:All',2696)
GO
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43974,'职级权限','Grade:All',2696)
GO
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43978,'集团管理权限','Group:All',2696)
GO

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