[CalendarServer-changes] [8652] CalendarServer/branches/users/glyph/table-alias
source_changes at macosforge.org
source_changes at macosforge.org
Mon Feb 13 10:03:28 PST 2012
Revision: 8652
http://trac.macosforge.org/projects/calendarserver/changeset/8652
Author: glyph at apple.com
Date: 2012-02-13 10:03:28 -0800 (Mon, 13 Feb 2012)
Log Message:
-----------
trim trailing whitespace in the schema
Modified Paths:
--------------
CalendarServer/branches/users/glyph/table-alias/txdav/common/datastore/sql_schema/current.sql
Property Changed:
----------------
CalendarServer/branches/users/glyph/table-alias/
Modified: CalendarServer/branches/users/glyph/table-alias/txdav/common/datastore/sql_schema/current.sql
===================================================================
--- CalendarServer/branches/users/glyph/table-alias/txdav/common/datastore/sql_schema/current.sql 2012-02-13 18:01:43 UTC (rev 8651)
+++ CalendarServer/branches/users/glyph/table-alias/txdav/common/datastore/sql_schema/current.sql 2012-02-13 18:03:28 UTC (rev 8652)
@@ -75,7 +75,7 @@
RECIPIENT_ADDRESS varchar(255) not null,
HOME_RESOURCE_ID integer not null,
RESOURCE_ID integer not null
-
+
-- Need primary key on (INVITE_UID, NAME, RECIPIENT_ADDRESS)?
);
@@ -117,10 +117,10 @@
create table CALENDAR_BIND (
CALENDAR_HOME_RESOURCE_ID integer not null references CALENDAR_HOME,
CALENDAR_RESOURCE_ID integer not null references CALENDAR on delete cascade,
-
+
-- An invitation which hasn't been accepted yet will not yet have a resource
-- name, so this field may be null.
-
+
CALENDAR_RESOURCE_NAME varchar(255),
BIND_MODE integer not null, -- enum CALENDAR_BIND_MODE
BIND_STATUS integer not null, -- enum CALENDAR_BIND_STATUS
@@ -195,7 +195,7 @@
create index CALENDAR_OBJECT_CALENDAR_RESOURCE_ID_AND_ICALENDAR_UID on
CALENDAR_OBJECT(CALENDAR_RESOURCE_ID, ICALENDAR_UID);
-
+
create index CALENDAR_OBJECT_CALENDAR_RESOURCE_ID_RECURRANCE_MAX on
CALENDAR_OBJECT(CALENDAR_RESOURCE_ID, RECURRANCE_MAX);
@@ -281,7 +281,7 @@
USER_ID varchar(255) not null,
TRANSPARENT boolean not null
);
-
+
create index TRANSPARENCY_TIME_RANGE_INSTANCE_ID on
TRANSPARENCY(TIME_RANGE_INSTANCE_ID);
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20120213/542c2d2c/attachment-0001.html>
More information about the calendarserver-changes
mailing list