[CalendarServer-changes] [8585] CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/ oracle-dialect

source_changes at macosforge.org source_changes at macosforge.org
Tue Jan 24 08:48:36 PST 2012


Revision: 8585
          http://trac.macosforge.org/projects/calendarserver/changeset/8585
Author:   cdaboo at apple.com
Date:     2012-01-24 08:48:36 -0800 (Tue, 24 Jan 2012)
Log Message:
-----------
Oracle upgrade files need to be manually adjusted for Oracle dialect.

Modified Paths:
--------------
    CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_5_to_6.sql
    CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_7_to_8.sql

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_5_to_6.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_5_to_6.sql	2012-01-24 09:11:15 UTC (rev 8584)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_5_to_6.sql	2012-01-24 16:48:36 UTC (rev 8585)
@@ -23,10 +23,10 @@
 ---------------------------------------------------------
 
 create table APN_SUBSCRIPTIONS (
-  TOKEN                         varchar(255) not null,
-  RESOURCE_KEY                  varchar(255) not null,
-  MODIFIED                      integer not null,
-  SUBSCRIBER_GUID               varchar(255) not null,
+  "TOKEN"                       nvarchar2(255),
+  "RESOURCE_KEY"                nvarchar2(255),
+  "MODIFIED"                    integer not null,
+  "SUBSCRIBER_GUID"             nvarchar2(255), 
   unique(TOKEN, RESOURCE_KEY) -- implicit index
 );
 

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_7_to_8.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_7_to_8.sql	2012-01-24 09:11:15 UTC (rev 8584)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_7_to_8.sql	2012-01-24 16:48:36 UTC (rev 8585)
@@ -20,10 +20,10 @@
 
 -- Add new table populated from existing one
 create table CALENDAR_METADATA (
-  RESOURCE_ID integer   primary key references CALENDAR on delete cascade, -- implicit index
-  SUPPORTED_COMPONENTS  varchar(255) default null,
-  CREATED               timestamp default timezone('UTC', CURRENT_TIMESTAMP),
-  MODIFIED              timestamp default timezone('UTC', CURRENT_TIMESTAMP)
+  "RESOURCE_ID"          integer primary key references CALENDAR on delete cascade, -- implicit index
+  "SUPPORTED_COMPONENTS" nvarchar2(255) default null,
+  "CREATED"              timestamp default CURRENT_TIMESTAMP at time zone 'UTC',
+  "MODIFIED"             timestamp default CURRENT_TIMESTAMP at time zone 'UTC'
 );
 insert into CALENDAR_METADATA
  select RESOURCE_ID, SUPPORTED_COMPONENTS, CREATED, MODIFIED from CALENDAR;
@@ -34,9 +34,9 @@
 
 -- Add new table populated from existing one
 create table ADDRESSBOOK_METADATA (
-  RESOURCE_ID integer   primary key references ADDRESSBOOK on delete cascade, -- implicit index
-  CREATED     timestamp default timezone('UTC', CURRENT_TIMESTAMP),
-  MODIFIED    timestamp default timezone('UTC', CURRENT_TIMESTAMP)
+  "RESOURCE_ID" integer primary key references ADDRESSBOOK on delete cascade, -- implicit index
+  "CREATED" timestamp default CURRENT_TIMESTAMP at time zone 'UTC',
+  "MODIFIED" timestamp default CURRENT_TIMESTAMP at time zone 'UTC'
 );
 insert into ADDRESSBOOK_METADATA
  select RESOURCE_ID, CREATED, MODIFIED from ADDRESSBOOK;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20120124/0f7d2b4f/attachment.html>


More information about the calendarserver-changes mailing list