diff options
Diffstat (limited to 'rt/docs/design_docs/groups_notes')
-rw-r--r-- | rt/docs/design_docs/groups_notes | 88 |
1 files changed, 0 insertions, 88 deletions
diff --git a/rt/docs/design_docs/groups_notes b/rt/docs/design_docs/groups_notes deleted file mode 100644 index 234fd37fe..000000000 --- a/rt/docs/design_docs/groups_notes +++ /dev/null @@ -1,88 +0,0 @@ -CREATE TABLE Prinicpals ( - id int auto_increment - PrincipalType VARCHAR(16) not_null, - PrincipalId int # foreign key to Users or Groups, depending -) - -CREATE TABLE Groups ( - id int auto_increment, - Domain varchar(255), - Instance varchar(16), - Name varchar(255), - Description varchar(255), -); -CREATE TABLE ACL ( - id INTEGER NOT NULL AUTO_INCREMENT, - Principal integer NULL , #Foreign key to principals - RightName varchar(25) NULL , - RightDomain varchar(25) NULL , - RightInstance integer NULL , - PRIMARY KEY (id) -); - -CREATE TABLE GroupMembers ( - id int auto_increment, - Group int, # foreign key to Principals - Member int # foreign key to Principals -) - -create table GroupMembersCache ( - id int auto_increment, - Group int, # foreign key to Principals - Member int, # foreign key to Principals - Via int, #foreign key to g_m_u -) - -insert into principals values ('bubbles); -insert into principals values ('fubar'); -insert into principals values ('sheeri'); -insert into principals values ('sgw'); - -insert into principals values ('staff'); -insert into principals values ('sysadmin'); -insert into principals values ('senior admin'); - - -insert into group_members values(1, 'staff', 'bubbles'); -insert into group_members values(2, 'sysadmin', 'sheeri'); -insert into group_members values(3,'senior admin', 'sgw'); -insert into group_members values(4,'senior admin', 'fubar'); -insert into group_members values(5, 'sysadmin', 'senior admin') - -Groups - - - -Domain Queues -Instance <queueid#> -Name AdminCc, Cc - -/Queues/1/AdminCc -/Queues/3/Cc - -Domain Tickets -Instance <#n> -Name Owner, Requestor, Cc, AdminCc - -/Tickets/1/Owner -/Tickets/1/Requestor -/Tickets/1/Cc - Has members: /Queues/whatever queue the ticket has/Cc -/Tickets/1/AdminCc - Has members: /Queues/whatever queue the ticket has/AdminCc - - -Domain Users -Instance <userid> - -/Users/1/MyDelegates -/Users/1/MyOtherDelegates - - -Domain System -Name Admins, AdminManagers - -/System/Administrators -/System/Blah - - |