[CalendarServer-changes] [13960] CalendarServer/branches/release/CalendarServer-5.3-dev/txdav/common /datastore/sql_schema/manual_upgrades/manual_upgrade_2.sql

source_changes at macosforge.org source_changes at macosforge.org
Fri Sep 12 13:40:56 PDT 2014


Revision: 13960
          http://trac.calendarserver.org//changeset/13960
Author:   cdaboo at apple.com
Date:     2014-09-12 13:40:56 -0700 (Fri, 12 Sep 2014)
Log Message:
-----------
Change index to improve performance.

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

Added: CalendarServer/branches/release/CalendarServer-5.3-dev/txdav/common/datastore/sql_schema/manual_upgrades/manual_upgrade_2.sql
===================================================================
--- CalendarServer/branches/release/CalendarServer-5.3-dev/txdav/common/datastore/sql_schema/manual_upgrades/manual_upgrade_2.sql	                        (rev 0)
+++ CalendarServer/branches/release/CalendarServer-5.3-dev/txdav/common/datastore/sql_schema/manual_upgrades/manual_upgrade_2.sql	2014-09-12 20:40:56 UTC (rev 13960)
@@ -0,0 +1,28 @@
+----
+-- 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 48 to 49 --
+---------------------------------------------------
+
+
+-- Update index
+drop index CALENDAR_OBJECT_CALEN_96e83b73;
+create index CALENDAR_OBJECT_CALEN_c4dc619c on CALENDAR_OBJECT (
+    CALENDAR_RESOURCE_ID,
+    RECURRANCE_MAX,
+    RECURRANCE_MIN
+);
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20140912/9c5bac0b/attachment.html>


More information about the calendarserver-changes mailing list