[CalendarServer-changes] [5927] CalendarServer/trunk/txcaldav/calendarstore/postgres_schema_v1.sql
source_changes at macosforge.org
source_changes at macosforge.org
Fri Jul 23 10:20:26 PDT 2010
Revision: 5927
http://trac.macosforge.org/projects/calendarserver/changeset/5927
Author: glyph at apple.com
Date: 2010-07-23 10:20:24 -0700 (Fri, 23 Jul 2010)
Log Message:
-----------
correct SQL syntax
Modified Paths:
--------------
CalendarServer/trunk/txcaldav/calendarstore/postgres_schema_v1.sql
Modified: CalendarServer/trunk/txcaldav/calendarstore/postgres_schema_v1.sql
===================================================================
--- CalendarServer/trunk/txcaldav/calendarstore/postgres_schema_v1.sql 2010-07-23 17:06:51 UTC (rev 5926)
+++ CalendarServer/trunk/txcaldav/calendarstore/postgres_schema_v1.sql 2010-07-23 17:20:24 UTC (rev 5927)
@@ -5,75 +5,75 @@
create sequence RESOURCE_ID_SEQ;
------------------
-- Calendar Home -
------------------
+-------------------
+-- Calendar Home --
+-------------------
create table CALENDAR_HOME (
- RESOURCE_ID varchar(255) primary key default nextval(’RESOURCE_ID_SEQ’),
- OWNER_UID varchar(255) not null unique,
+ RESOURCE_ID varchar(255) primary key default nextval('RESOURCE_ID_SEQ'),
+ OWNER_UID varchar(255) not null unique
);
------------------
-- Calendar Bind -
------------------
-
--- Joins CALENDAR_HOME and CALENDAR
-
-create table CALENDAR_BIND (
- CALENDAR_HOME_RESOURCE_ID varchar(255) not null references CALENDAR_HOME,
- CALENDAR_RESOURCE_ID varchar(255) not null references CALENDAR,
- CALENDAR_RESOURCE_NAME varchar(255) not null,
- CALENDAR_MODE int not null,
- SEEN_BY_OWNER bool not null,
- SEEN_BY_SHAREE bool not null,
- STATUS integer not null,
- MESSAGE text, -- FIXME: xml?
-
- primary key(CALENDAR_HOME_RESOURCE_ID, CALENDAR_RESOURCE_ID),
- unique(CALENDAR_HOME_RESOURCE_ID, CALENDAR_RESOURCE_NAME),
-);
-
-- Enumeration of calendar bind modes
create table CALENDAR_BIND_MODE (
ID int primary key,
- DESCRIPTION varchar(16) not null unique,
+ DESCRIPTION varchar(16) not null unique
);
-insert into CALENDAR_MODE values (0, "own" );
-insert into CALENDAR_MODE values (1, "read" );
-insert into CALENDAR_MODE values (2, "write");
+insert into CALENDAR_BIND_MODE values (0, 'own' );
+insert into CALENDAR_BIND_MODE values (1, 'read' );
+insert into CALENDAR_BIND_MODE values (2, 'write');
-- Enumeration of statuses
create table CALENDAR_BIND_STATUS (
ID int primary key,
- DESCRIPTION varchar(16) not null unique,
+ DESCRIPTION varchar(16) not null unique
);
-insert into CALENDAR_BIND_STATUS values (0, "invited" );
-insert into CALENDAR_BIND_STATUS values (1, "accepted");
-insert into CALENDAR_BIND_STATUS values (2, "declined");
+insert into CALENDAR_BIND_STATUS values (0, 'invited' );
+insert into CALENDAR_BIND_STATUS values (1, 'accepted');
+insert into CALENDAR_BIND_STATUS values (2, 'declined');
-------------
-- Calendar -
-------------
+--------------
+-- Calendar --
+--------------
create table CALENDAR (
- RESOURCE_ID varchar(255) primary key default nextval(’RESOURCE_ID_SEQ’),
- SYNC_TOKEN varchar(255),
+ RESOURCE_ID varchar(255) primary key default nextval('RESOURCE_ID_SEQ'),
+ SYNC_TOKEN varchar(255)
);
-------------------
-- Calendar Object -
+-- Calendar Bind --
-------------------
+-- Joins CALENDAR_HOME and CALENDAR
+
+create table CALENDAR_BIND (
+ CALENDAR_HOME_RESOURCE_ID varchar(255) not null references CALENDAR_HOME,
+ CALENDAR_RESOURCE_ID varchar(255) not null references CALENDAR,
+ CALENDAR_RESOURCE_NAME varchar(255) not null,
+ CALENDAR_MODE int not null,
+ SEEN_BY_OWNER bool not null,
+ SEEN_BY_SHAREE bool not null,
+ STATUS integer not null,
+ MESSAGE text, -- FIXME: xml?
+
+ primary key(CALENDAR_HOME_RESOURCE_ID, CALENDAR_RESOURCE_ID),
+ unique(CALENDAR_HOME_RESOURCE_ID, CALENDAR_RESOURCE_NAME)
+);
+
+---------------------
+-- Calendar Object --
+---------------------
+
create table CALENDAR_OBJECT (
- RESOURCE_ID varchar(255) primary key default nextval(’RESOURCE_ID_SEQ’),
+ RESOURCE_ID varchar(255) primary key default nextval('RESOURCE_ID_SEQ'),
CALENDAR_RESOURCE_ID varchar(255) not null references CALENDAR,
RESOURCE_NAME varchar(255) not null,
ICALENDAR_TEXT text not null,
@@ -84,48 +84,48 @@
ORGANIZER_OBJECT varchar(255) references CALENDAR_OBJECT,
unique(CALENDAR_RESOURCE_ID, RESOURCE_NAME),
- unique(CALENDAR_RESOURCE_ID, ICALENDAR_UID),
+ unique(CALENDAR_RESOURCE_ID, ICALENDAR_UID)
);
-- Enumeration of attachment modes
create table CALENDAR_OBJECT_ATTACHMENTS_MODE (
ID int primary key,
- DESCRIPTION varchar(16) not null unique,
+ DESCRIPTION varchar(16) not null unique
);
-insert into CALENDAR_MODE values (0, "read" );
-insert into CALENDAR_MODE values (1, "write");
+insert into CALENDAR_OBJECT_ATTACHMENTS_MODE values (0, 'read' );
+insert into CALENDAR_OBJECT_ATTACHMENTS_MODE values (1, 'write');
---------------
-- Attachment -
---------------
+----------------
+-- Attachment --
+----------------
create table ATTACHMENT (
CALENDAR_OBJECT varchar(255) not null references CALENDAR_OBJECT,
CONTENT_TYPE varchar(255) not null,
SIZE int not null,
MD5 char(32) not null,
- PATH varchar(255) not null unique,
+ PATH varchar(255) not null unique
);
-----------------
-- iTIP Message -
-----------------
+------------------
+-- iTIP Message --
+------------------
create table ITIP_MESSAGE (
CALENDAR_RESOURCE_ID varchar(255) not null references CALENDAR,
ICALENDAR_TEXT text not null,
ICALENDAR_UID varchar(255) not null,
MD5 char(32) not null,
- CHANGES text not null,
+ CHANGES text not null
);
----------------------
-- Resource Property -
----------------------
+-----------------------
+-- Resource Property --
+-----------------------
create table RESOURCE_PROPERTY (
RESOURCE_ID varchar(255) not null, -- foreign key: *.RESOURCE_ID
@@ -133,5 +133,5 @@
VALUE text not null, -- FIXME: xml?
VIEWER_UID varchar(255),
- primary key(RESOURCE_ID, NAME, VIEWER_UID),
+ primary key(RESOURCE_ID, NAME, VIEWER_UID)
);
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20100723/3e541161/attachment.html>
More information about the calendarserver-changes
mailing list