1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253 |
- CREATE TABLE CmUserGroup
- (
- SiteId int NOT NULL ,
- UserGroupId int identity(1,1) NOT NULL ,
- Name nvarchar(32) NOT NULL ,
- PRIMARY KEY (SiteId ASC , UserGroupId ASC)
- );
- DBCC CHECKIDENT( CmUserGroup, RESEED, 1 )
- CREATE TABLE CmUserGroupPermission
- (
- SiteId int NOT NULL ,
- UserGroupId int NOT NULL ,
- MenuId int NOT NULL ,
- MenuPermission smallint NULL ,
- PRIMARY KEY (SiteId ASC , UserGroupId ASC , MenuId ASC)
- );
- ALTER TABLE CmUser
- ADD CONSTRAINT FK__CmUser__CmUserGroup
- FOREIGN KEY (SiteId , UserGroupId)
- REFERENCES CmUserGroup(SiteId , UserGroupId)
- ;
- ALTER TABLE CmUserGroup
- ADD FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)
- ;
- ALTER TABLE CmUserGroupPermission
- ADD CONSTRAINT FK__CmUserGroupPermission__CmUserGroup
- FOREIGN KEY (SiteId , UserGroupId)
- REFERENCES CmUserGroup(SiteId , UserGroupId)
- ON DELETE CASCADE
- ;
|