diff options
author | Ivan Kohler <ivan@freeside.biz> | 2012-07-02 14:24:21 -0700 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2012-07-02 14:24:21 -0700 |
commit | 85e677b86fc37c54e6de2b06340351a28f5a5916 (patch) | |
tree | 11148e2c292bd1a43b7cf6c2f5212a6ca8b03e75 /rt/docs/design_docs/groups_notes | |
parent | e5ab051ccdb7637d8dd2f0ed9b4fe9aaaf1d1100 (diff) | |
parent | 92aedddd3684167abb60cd3f1d77bbc156c592e6 (diff) |
Merge branch 'master' of git.freeside.biz:/home/git/freeside
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 - - |