[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