[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