[CalendarServer-changes] [9238] CalendarServer/branches/users/gaya/sharedabgroups/txdav/common/ datastore/sql_schema/current.sql

[source_changes at macosforge.org]

Revision: 9238
          http://trac.macosforge.org/projects/calendarserver/changeset/9238
Author:   gaya at apple.com
Date:     2012-05-09 14:27:15 -0700 (Wed, 09 May 2012)
Log Message:
-----------
add ADDRESSBOOK_GROUP_MEMBER table, add shared group column to ADDRESSBOOK_METADATA table

Modified Paths:
--------------
    CalendarServer/branches/users/gaya/sharedabgroups/txdav/common/datastore/sql_schema/current.sql

Modified: CalendarServer/branches/users/gaya/sharedabgroups/txdav/common/datastore/sql_schema/current.sql
===================================================================
--- CalendarServer/branches/users/gaya/sharedabgroups/txdav/common/datastore/sql_schema/current.sql	2012-05-09 21:22:11 UTC (rev 9237)
+++ CalendarServer/branches/users/gaya/sharedabgroups/txdav/common/datastore/sql_schema/current.sql	2012-05-09 21:27:15 UTC (rev 9238)
@@ -349,17 +349,6 @@
 );
 
 
---------------------------
--- AddressBook Metadata --
---------------------------
-
-create table ADDRESSBOOK_METADATA (
-  RESOURCE_ID integer   primary key references ADDRESSBOOK on delete cascade, -- implicit index
-  CREATED     timestamp default timezone('UTC', CURRENT_TIMESTAMP),
-  MODIFIED    timestamp default timezone('UTC', CURRENT_TIMESTAMP)
-);
-
-
 ----------------------
 -- AddressBook Bind --
 ----------------------
@@ -401,6 +390,28 @@
   unique(ADDRESSBOOK_RESOURCE_ID, VCARD_UID)      -- implicit index
 );
 
+--------------------------
+-- Shared Group --
+--------------------------
+
+create table ADDRESSBOOK_GROUP_MEMBER (
+    GROUPID               integer      references ADDRESSBOOK_OBJECT, 
+    MEMBER                integer      references ADDRESSBOOK_OBJECT,
+    primary key(GROUPID, MEMBER) -- implicit index
+);
+
+--------------------------
+-- AddressBook Metadata --
+--------------------------
+
+create table ADDRESSBOOK_METADATA (
+  RESOURCE_ID integer   primary key references ADDRESSBOOK on delete cascade, -- implicit index
+  GROUPID               integer      references ADDRESSBOOK_OBJECT, -- shared group
+  CREATED     timestamp default timezone('UTC', CURRENT_TIMESTAMP),
+  MODIFIED    timestamp default timezone('UTC', CURRENT_TIMESTAMP)
+);
+
+
 ---------------
 -- Revisions --
 ---------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20120509/93e8382c/attachment.html>