[CalendarServer-changes] [6992] CalendarServer/branches/users/glyph/dalify/txdav/common/datastore/ sql_schema_v1.sql

source_changes at macosforge.org source_changes at macosforge.org
Wed Feb 16 06:37:30 PST 2011


Revision: 6992
          http://trac.macosforge.org/projects/calendarserver/changeset/6992
Author:   glyph at apple.com
Date:     2011-02-16 06:37:30 -0800 (Wed, 16 Feb 2011)
Log Message:
-----------
default to sequence on all revision ID columns

Modified Paths:
--------------
    CalendarServer/branches/users/glyph/dalify/txdav/common/datastore/sql_schema_v1.sql

Modified: CalendarServer/branches/users/glyph/dalify/txdav/common/datastore/sql_schema_v1.sql
===================================================================
--- CalendarServer/branches/users/glyph/dalify/txdav/common/datastore/sql_schema_v1.sql	2011-02-16 14:37:19 UTC (rev 6991)
+++ CalendarServer/branches/users/glyph/dalify/txdav/common/datastore/sql_schema_v1.sql	2011-02-16 14:37:30 UTC (rev 6992)
@@ -416,7 +416,7 @@
   CALENDAR_RESOURCE_ID      integer      references CALENDAR,
   CALENDAR_NAME             varchar(255) default null,
   RESOURCE_NAME             varchar(255),
-  REVISION                  integer      not null default nextval('REVISION_SEQ'),
+  REVISION                  integer      default nextval('REVISION_SEQ') not null,
   DELETED                   boolean      not null,
 
   unique(CALENDAR_RESOURCE_ID, RESOURCE_NAME)
@@ -439,7 +439,7 @@
   ADDRESSBOOK_RESOURCE_ID      integer      references ADDRESSBOOK,
   ADDRESSBOOK_NAME             varchar(255) default null,
   RESOURCE_NAME                varchar(255),
-  REVISION                     integer      not null,
+  REVISION                     integer      default nextval('REVISION_SEQ') not null,
   DELETED                      boolean      not null,
 
   unique(ADDRESSBOOK_RESOURCE_ID, RESOURCE_NAME)
@@ -458,7 +458,7 @@
 create table NOTIFICATION_OBJECT_REVISIONS (
   NOTIFICATION_HOME_RESOURCE_ID integer      not null references NOTIFICATION_HOME on delete cascade,
   RESOURCE_NAME                 varchar(255),
-  REVISION                      integer      not null,
+  REVISION                      integer      default nextval('REVISION_SEQ') not null,
   DELETED                       boolean      not null,
 
   unique(NOTIFICATION_HOME_RESOURCE_ID, RESOURCE_NAME)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20110216/f14d2c3b/attachment-0001.html>


More information about the calendarserver-changes mailing list