[CalendarServer-changes] [8799] CalendarServer/branches/users/glyph/case-insensitive-uid

source_changes at macosforge.org source_changes at macosforge.org
Wed Feb 29 10:16:26 PST 2012


Revision: 8799
          http://trac.macosforge.org/projects/calendarserver/changeset/8799
Author:   glyph at apple.com
Date:     2012-02-29 10:16:26 -0800 (Wed, 29 Feb 2012)
Log Message:
-----------
postgres 8 -> 9 upgrader

Added Paths:
-----------
    CalendarServer/branches/users/glyph/case-insensitive-uid/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_8_to_9.sql

Property Changed:
----------------
    CalendarServer/branches/users/glyph/case-insensitive-uid/

Added: CalendarServer/branches/users/glyph/case-insensitive-uid/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_8_to_9.sql
===================================================================
--- CalendarServer/branches/users/glyph/case-insensitive-uid/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_8_to_9.sql	                        (rev 0)
+++ CalendarServer/branches/users/glyph/case-insensitive-uid/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_8_to_9.sql	2012-02-29 18:16:26 UTC (rev 8799)
@@ -0,0 +1,29 @@
+----
+-- Copyright (c) 2012 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 8 to 9 --
+-------------------------------------------------
+
+update CALENDAR_HOME set OWNER_UID = lower(OWNER_UID);
+
+alter table CALENDAR_HOME
+add constraint CALENDAR_HOME_CASE check(OWNER_UID = lower(OWNER_UID));
+
+update ADDRESSBOOK_HOME set OWNER_UID = lower(OWNER_UID);
+
+alter table ADDRESSBOOK_HOME
+add constraint ADDRESSBOOK_HOME_CASE check(OWNER_UID = lower(OWNER_UID));
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20120229/153fdf04/attachment-0001.html>


More information about the calendarserver-changes mailing list