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

[source_changes at macosforge.org]

Revision: 9915
          http://trac.calendarserver.org//changeset/9915
Author:   gaya at apple.com
Date:     2012-10-09 16:50:54 -0700 (Tue, 09 Oct 2012)
Log Message:
-----------
minor cleanup

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

Modified: CalendarServer/branches/users/gaya/sharedgroups/txdav/common/datastore/sql_schema/current.sql
===================================================================
--- CalendarServer/branches/users/gaya/sharedgroups/txdav/common/datastore/sql_schema/current.sql	2012-10-09 21:33:10 UTC (rev 9914)
+++ CalendarServer/branches/users/gaya/sharedgroups/txdav/common/datastore/sql_schema/current.sql	2012-10-09 23:50:54 UTC (rev 9915)
@@ -362,7 +362,7 @@
 
   create table ADDRESSBOOK_OBJECT (
   RESOURCE_ID             integer      primary key default nextval('RESOURCE_ID_SEQ'),    -- implicit index
-  ADDRESSBOOK_RESOURCE_ID integer      not null references ADDRESSBOOK on delete cascade,
+  ADDRESSBOOK_RESOURCE_ID integer      not null references ADDRESSBOOK on delete cascade, -- #### TODO: change to reference ADDRESSBOOK_OBJECT ####
   RESOURCE_NAME           varchar(255) not null,
   VCARD_TEXT              text         not null,
   VCARD_UID               varchar(255) not null,
@@ -394,8 +394,8 @@
 -------------
 
 create table MEMBERS (
-    GROUP_ID              integer      references ADDRESSBOOK_OBJECT,	-- AddressBook Object's (kind=='group') RESOURCE_ID
-    MEMBER_ID             integer      references ADDRESSBOOK_OBJECT,	-- member AddressBook Object's RESOURCE_ID
+    GROUP_ID              integer      references ADDRESSBOOK_OBJECT,			-- AddressBook Object's (kind=='group') RESOURCE_ID
+    MEMBER_ID             integer      not null references ADDRESSBOOK_OBJECT,	-- member AddressBook Object's RESOURCE_ID
     primary key(GROUP_ID, MEMBER_ID) -- implicit index
 );
 
@@ -405,7 +405,7 @@
 
 create table FOREIGN_MEMBERS (
     GROUP_ID              integer      references ADDRESSBOOK_OBJECT,	-- AddressBook Object's (kind=='group') RESOURCE_ID
-    MEMBER_ADDRESS  	  varchar(255) not null, 						-- member AddressBook Object's calendar address
+    MEMBER_ADDRESS  	  varchar(255) not null, 						-- member AddressBook Object's address
     primary key(GROUP_ID, MEMBER_ADDRESS) -- implicit index
 );
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20121009/fce083c3/attachment.html>