1 CREATE TABLE Prinicpals (
3 PrincipalType VARCHAR(16) not_null,
4 PrincipalId int # foreign key to Users or Groups, depending
12 Description varchar(255),
15 id INTEGER NOT NULL AUTO_INCREMENT,
16 Principal integer NULL , #Foreign key to principals
17 RightName varchar(25) NULL ,
18 RightDomain varchar(25) NULL ,
19 RightInstance integer NULL ,
23 CREATE TABLE GroupMembers (
24 id int auto_increment,
25 Group int, # foreign key to Principals
26 Member int # foreign key to Principals
29 create table GroupMembersCache (
30 id int auto_increment,
31 Group int, # foreign key to Principals
32 Member int, # foreign key to Principals
33 Via int, #foreign key to g_m_u
36 insert into principals values ('bubbles);
37 insert into principals values ('fubar');
38 insert into principals values ('sheeri');
39 insert into principals values ('sgw');
41 insert into principals values ('staff');
42 insert into principals values ('sysadmin');
43 insert into principals values ('senior admin');
46 insert into group_members values(1, 'staff', 'bubbles');
47 insert into group_members values(2, 'sysadmin', 'sheeri');
48 insert into group_members values(3,'senior admin', 'sgw');
49 insert into group_members values(4,'senior admin', 'fubar');
50 insert into group_members values(5, 'sysadmin', 'senior admin')
65 Name Owner, Requestor, Cc, AdminCc
70 Has members: /Queues/whatever queue the ticket has/Cc
72 Has members: /Queues/whatever queue the ticket has/AdminCc
79 /Users/1/MyOtherDelegates
83 Name Admins, AdminManagers
85 /System/Administrators