[CalendarServer-changes] [13923] CalendarServer/branches/release/CalendarServer-5.3-dev/txdav/common /datastore/sql_schema

source_changes at macosforge.org source_changes at macosforge.org
Wed Aug 27 18:53:20 PDT 2014


Revision: 13923
          http://trac.calendarserver.org//changeset/13923
Author:   cdaboo at apple.com
Date:     2014-08-27 18:53:20 -0700 (Wed, 27 Aug 2014)
Log Message:
-----------
Add some indexes - manually applied sql update.

Added Paths:
-----------
    CalendarServer/branches/release/CalendarServer-5.3-dev/txdav/common/datastore/sql_schema/manual_upgrades/
    CalendarServer/branches/release/CalendarServer-5.3-dev/txdav/common/datastore/sql_schema/manual_upgrades/manual_upgrade_1.sql

Added: CalendarServer/branches/release/CalendarServer-5.3-dev/txdav/common/datastore/sql_schema/manual_upgrades/manual_upgrade_1.sql
===================================================================
--- CalendarServer/branches/release/CalendarServer-5.3-dev/txdav/common/datastore/sql_schema/manual_upgrades/manual_upgrade_1.sql	                        (rev 0)
+++ CalendarServer/branches/release/CalendarServer-5.3-dev/txdav/common/datastore/sql_schema/manual_upgrades/manual_upgrade_1.sql	2014-08-28 01:53:20 UTC (rev 13923)
@@ -0,0 +1,33 @@
+----
+-- Copyright (c) 2012-2014 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 from VERSION 47 to 48 trunk --
+---------------------------------------------------------
+
+
+
+-- Add pkey to PERUSER and remove old index
+alter table TRANSPARENCY add primary key (TIME_RANGE_INSTANCE_ID, USER_ID);
+drop index TRANSPARENCY_TIME_RAN_5f34467f;
+
+-- 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;
+
+-- 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);
+drop index ADDRESSBOOK_OBJECT_RE_2bfcf757;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20140827/c9031d70/attachment.html>


More information about the calendarserver-changes mailing list