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

[source_changes at macosforge.org]

Revision: 15376
          http://trac.calendarserver.org//changeset/15376
Author:   cdaboo at apple.com
Date:     2015-12-10 13:47:23 -0800 (Thu, 10 Dec 2015)
Log Message:
-----------
Changes for IS&T upgrade.

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

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_47_to_48.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_47_to_48.sql	2015-12-10 20:21:36 UTC (rev 15375)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_47_to_48.sql	2015-12-10 21:47:23 UTC (rev 15376)
@@ -26,11 +26,11 @@
 drop index PERUSER_TIME_RANGE_IN_5468a226;
 
 -- Add unique to CALENDAR_OBJECT_REVISIONS and remove old index
-alter table CALENDAR_OBJECT_REVISIONS add unique (CALENDAR_HOME_RESOURCE_ID, CALENDAR_RESOURCE_ID, CALENDAR_NAME, RESOURCE_NAME);
-drop index CALENDAR_OBJECT_REVIS_3a3956c4;
+--Not for IS&T: alter table CALENDAR_OBJECT_REVISIONS add unique (CALENDAR_HOME_RESOURCE_ID, CALENDAR_RESOURCE_ID, CALENDAR_NAME, RESOURCE_NAME);
+--Not for IS&T: drop index CALENDAR_OBJECT_REVIS_3a3956c4;
 
 -- Add unique to ADDRESSBOOK_OBJECT_REVISIONS and remove old index
-alter table ADDRESSBOOK_OBJECT_REVISIONS add unique (ADDRESSBOOK_HOME_RESOURCE_ID, OWNER_HOME_RESOURCE_ID, ADDRESSBOOK_NAME, RESOURCE_NAME);
+--Not for IS&T: alter table ADDRESSBOOK_OBJECT_REVISIONS add unique (ADDRESSBOOK_HOME_RESOURCE_ID, OWNER_HOME_RESOURCE_ID, ADDRESSBOOK_NAME, RESOURCE_NAME);
 drop index ADDRESSBOOK_OBJECT_RE_2bfcf757;
 
 

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_48_to_49.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_48_to_49.sql	2015-12-10 20:21:36 UTC (rev 15375)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_48_to_49.sql	2015-12-10 21:47:23 UTC (rev 15376)
@@ -20,19 +20,19 @@
 
 
 -- Update index
-drop index CALENDAR_OBJECT_CALEN_96e83b73;
-create index CALENDAR_OBJECT_CALEN_c4dc619c on CALENDAR_OBJECT (
-    CALENDAR_RESOURCE_ID,
-    RECURRANCE_MAX,
-    RECURRANCE_MIN
-);
+--Not for IS&T: drop index CALENDAR_OBJECT_CALEN_96e83b73;
+--Not for IS&T: create index CALENDAR_OBJECT_CALEN_c4dc619c on CALENDAR_OBJECT (
+--Not for IS&T:     CALENDAR_RESOURCE_ID,
+--Not for IS&T:     RECURRANCE_MAX,
+--Not for IS&T:     RECURRANCE_MIN
+--Not for IS&T: );
 
 -- New indexes
 
-create index CALENDAR_OBJECT_REVIS_550b1c56 on CALENDAR_OBJECT_REVISIONS (
-    CALENDAR_HOME_RESOURCE_ID,
-    REVISION
-);
+--Not for IS&T: create index CALENDAR_OBJECT_REVIS_550b1c56 on CALENDAR_OBJECT_REVISIONS (
+--Not for IS&T:     CALENDAR_HOME_RESOURCE_ID,
+--Not for IS&T:     REVISION
+--Not for IS&T: );
 
 create index PUSH_NOTIFICATION_WOR_3a3ee588 on PUSH_NOTIFICATION_WORK (
     PUSH_ID
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20151210/d04d19de/attachment.html>