[CalendarServer-changes] [6003] CalendarServer/branches/users/glyph/sql-store/txcaldav/calendarstore /postgres_schema_v1.sql

[source_changes at macosforge.org]

Revision: 6003
          http://trac.macosforge.org/projects/calendarserver/changeset/6003
Author:   glyph at apple.com
Date:     2010-08-06 15:41:47 -0700 (Fri, 06 Aug 2010)
Log Message:
-----------
addressbook schema, rough cut

Modified Paths:
--------------
    CalendarServer/branches/users/glyph/sql-store/txcaldav/calendarstore/postgres_schema_v1.sql

Modified: CalendarServer/branches/users/glyph/sql-store/txcaldav/calendarstore/postgres_schema_v1.sql
===================================================================
--- CalendarServer/branches/users/glyph/sql-store/txcaldav/calendarstore/postgres_schema_v1.sql	2010-08-06 19:44:20 UTC (rev 6002)
+++ CalendarServer/branches/users/glyph/sql-store/txcaldav/calendarstore/postgres_schema_v1.sql	2010-08-06 22:41:47 UTC (rev 6003)
@@ -163,3 +163,57 @@
 
   primary key(RESOURCE_ID, NAME, VIEWER_UID)
 );
+
+
+----------------------
+-- AddressBook Home --
+----------------------
+
+create table ADDRESSBOOK_HOME (
+  RESOURCE_ID varchar(255) primary key default nextval('RESOURCE_ID_SEQ'),
+  OWNER_UID   varchar(255) not null unique
+);
+
+
+-----------------
+-- AddressBook --
+-----------------
+
+create table ADDRESSBOOK (
+  RESOURCE_ID varchar(255) primary key default nextval('RESOURCE_ID_SEQ'),
+  SYNC_TOKEN  varchar(255)
+);
+
+
+----------------------
+-- AddressBook Bind --
+----------------------
+
+-- Joins ADDRESSBOOK_HOME and ADDRESSBOOK
+
+create table ADDRESSBOOK_BIND (
+  ADDRESSBOOK_HOME_RESOURCE_ID varchar(255) not null references ADDRESSBOOK_HOME,
+  ADDRESSBOOK_RESOURCE_ID      varchar(255) not null references ADDRESSBOOK,
+  ADDRESSBOOK_RESOURCE_NAME    varchar(255) not null,
+  BIND_MODE                 integer      not null, -- enum CALENDAR_BIND_MODE
+  BIND_STATUS               integer      not null, -- enum CALENDAR_BIND_STATUS
+  SEEN_BY_OWNER             bool         not null,
+  SEEN_BY_SHAREE            bool         not null,
+  MESSAGE                   text,                  -- FIXME: xml?
+
+  primary key(ADDRESSBOOK_HOME_RESOURCE_ID, ADDRESSBOOK_RESOURCE_ID),
+  unique(ADDRESSBOOK_HOME_RESOURCE_ID, ADDRESSBOOK_RESOURCE_NAME)
+);
+
+
+create table ADDRESSBOOK_OBJECT (
+  RESOURCE_ID          varchar(255) primary key default nextval('RESOURCE_ID_SEQ'),
+  ADDRESSBOOK_RESOURCE_ID varchar(255) not null references ADDRESSBOOK,
+  RESOURCE_NAME        varchar(255) not null,
+  VCARD_TEXT           text         not null,
+  VCARD_UID            varchar(255) not null,
+  VCARD_TYPE           varchar(255) not null,
+
+  unique(ADDRESSBOOK_RESOURCE_ID, RESOURCE_NAME),
+  unique(ADDRESSBOOK_RESOURCE_ID, VCARD_UID)
+);
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20100806/ca0b06c2/attachment.html>