CREATE TABLE principals (
      id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
      uri VARCHAR(200) NOT NULL,
      email VARCHAR(80),
      displayname VARCHAR(80),
      vcardurl VARCHAR(255),
      UNIQUE(uri)
  );
  
  CREATE TABLE groupmembers (
      id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
      principal_id INTEGER UNSIGNED NOT NULL,
      member_id INTEGER UNSIGNED NOT NULL,
      UNIQUE(principal_id, member_id)
  );
  
  
  INSERT INTO principals (uri,email,displayname) VALUES
  ('principals/admin', 'admin@example.org','Administrator'),
  ('principals/admin/calendar-proxy-read', null, null),
  ('principals/admin/calendar-proxy-write', null, null);