1 CREATE TABLE principals (
2 id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
3 uri VARCHAR(200) NOT NULL,
5 displayname VARCHAR(80),
10 CREATE TABLE groupmembers (
11 id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
12 principal_id INTEGER UNSIGNED NOT NULL,
13 member_id INTEGER UNSIGNED NOT NULL,
14 UNIQUE(principal_id, member_id)
18 INSERT INTO principals (uri,email,displayname) VALUES
19 ('principals/admin', 'admin@example.org','Administrator'),
20 ('principals/admin/calendar-proxy-read', null, null),
21 ('principals/admin/calendar-proxy-write', null, null);