[CalendarServer-changes] [10262] CalendarServer/branches/users/glyph/queue-locking-and-timing

[source_changes at macosforge.org]

Revision: 10262
          http://trac.calendarserver.org//changeset/10262
Author:   glyph at apple.com
Date:     2013-01-04 16:39:25 -0800 (Fri, 04 Jan 2013)
Log Message:
-----------
Upgrader for oracle & postgres to add that table.

Added Paths:
-----------
    CalendarServer/branches/users/glyph/queue-locking-and-timing/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_14_to_15.sql
    CalendarServer/branches/users/glyph/queue-locking-and-timing/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_14_to_15.sql

Property Changed:
----------------
    CalendarServer/branches/users/glyph/queue-locking-and-timing/

Added: CalendarServer/branches/users/glyph/queue-locking-and-timing/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_14_to_15.sql
===================================================================
--- CalendarServer/branches/users/glyph/queue-locking-and-timing/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_14_to_15.sql	                        (rev 0)
+++ CalendarServer/branches/users/glyph/queue-locking-and-timing/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_14_to_15.sql	2013-01-05 00:39:25 UTC (rev 10262)
@@ -0,0 +1,27 @@
+----
+-- Copyright (c) 2011 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 14 to 15 --
+-------------------------------------------------
+
+
+create table NAMED_LOCK (
+    "LOCK_NAME" nvarchar2(255) primary key
+);
+-- Now update the version
+update CALENDARSERVER set VALUE = '' where NAME = 'VERSION';
+

Added: CalendarServer/branches/users/glyph/queue-locking-and-timing/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_14_to_15.sql
===================================================================
--- CalendarServer/branches/users/glyph/queue-locking-and-timing/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_14_to_15.sql	                        (rev 0)
+++ CalendarServer/branches/users/glyph/queue-locking-and-timing/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_14_to_15.sql	2013-01-05 00:39:25 UTC (rev 10262)
@@ -0,0 +1,27 @@
+----
+-- Copyright (c) 2011 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 14 to 15 --
+-------------------------------------------------
+
+
+create table NAMED_LOCK (
+    LOCK_NAME varchar(255) primary key
+);
+-- Now update the version
+update CALENDARSERVER set VALUE = '' where NAME = 'VERSION';
+
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20130104/a9828f1a/attachment-0001.html>