[CalendarServer-changes] [15494] CalendarServer/trunk/txdav/common/datastore/sql_schema/ manual_upgrades

[source_changes at macosforge.org]

Revision: 15494
          http://trac.calendarserver.org//changeset/15494
Author:   cdaboo at apple.com
Date:     2016-03-31 13:23:09 -0700 (Thu, 31 Mar 2016)
Log Message:
-----------
Additional Oracle manual schema upgrade files.

Added Paths:
-----------
    CalendarServer/trunk/txdav/common/datastore/sql_schema/manual_upgrades/oracle_ssical_final.sql
    CalendarServer/trunk/txdav/common/datastore/sql_schema/manual_upgrades/oracle_ssical_to_28.sql

Added: CalendarServer/trunk/txdav/common/datastore/sql_schema/manual_upgrades/oracle_ssical_final.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/manual_upgrades/oracle_ssical_final.sql	                        (rev 0)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/manual_upgrades/oracle_ssical_final.sql	2016-03-31 20:23:09 UTC (rev 15494)
@@ -0,0 +1,30 @@
+----
+-- Copyright (c) 2015-2016 Apple Inc. All rights reserved.
+--
+-- Licensed under the Apache License, Version 2.0 (the "License");
+-- you may not use this file except in compliance with the License.
+-- You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+----
+
+-------------------------------------------
+-- Upgrade database schema at VERSION 60 --
+-------------------------------------------
+
+-- These are items we removed from the upgrade files for calendar.apple.com, but are still
+-- needed for ssical.apple.com
+
+-- Upgrade 47 to 48
+alter table CALENDAR_OBJECT_REVISIONS add unique (CALENDAR_HOME_RESOURCE_ID, CALENDAR_RESOURCE_ID, CALENDAR_NAME, RESOURCE_NAME);
+drop index CALENDAR_OBJECT_REVIS_3a3956c4;
+alter table ADDRESSBOOK_OBJECT_REVISIONS add unique (ADDRESSBOOK_HOME_RESOURCE_ID, OWNER_HOME_RESOURCE_ID, ADDRESSBOOK_NAME, RESOURCE_NAME);
+
+-- Remove a constraint
+alter table APN_SUBSCRIPTIONS modify ("SUBSCRIBER_GUID" null);

Added: CalendarServer/trunk/txdav/common/datastore/sql_schema/manual_upgrades/oracle_ssical_to_28.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/manual_upgrades/oracle_ssical_to_28.sql	                        (rev 0)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/manual_upgrades/oracle_ssical_to_28.sql	2016-03-31 20:23:09 UTC (rev 15494)
@@ -0,0 +1,22 @@
+----
+-- Copyright (c) 2015-2016 Apple Inc. All rights reserved.
+--
+-- Licensed under the Apache License, Version 2.0 (the "License");
+-- you may not use this file except in compliance with the License.
+-- You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+----
+
+--------------------------------------------------------
+-- Supplemental upgrade database schema at VERSION 28 --
+--------------------------------------------------------
+
+-- Extra index
+drop index PUSH_NOTIFICATION_WOR_2eb72b33;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20160331/5bcfb444/attachment.html>