[CalendarServer-changes] [11775] CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/ oracle-dialect/upgrade_from_19_to_20.sql

[source_changes at macosforge.org]

Revision: 11775
          http://trac.calendarserver.org//changeset/11775
Author:   dre at apple.com
Date:     2013-10-01 14:45:16 -0700 (Tue, 01 Oct 2013)
Log Message:
-----------
Fix unique constraint syntax on ADDRESSBOOK_OBJECT.ADDRESSBOOK_HOME_RESOURCE_ID in 19 to 20 oracle schema upgrade

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

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_19_to_20.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_19_to_20.sql	2013-10-01 21:20:36 UTC (rev 11774)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_19_to_20.sql	2013-10-01 21:45:16 UTC (rev 11775)
@@ -184,7 +184,7 @@
 
 alter table ADDRESSBOOK_OBJECT
 	add unique ("ADDRESSBOOK_HOME_RESOURCE_ID", "RESOURCE_NAME")
-	    unique ("ADDRESSBOOK_HOME_RESOURCE_ID", "VCARD_UID");
+	add unique ("ADDRESSBOOK_HOME_RESOURCE_ID", "VCARD_UID");
 
 ------------------------------------------
 -- change  ADDRESSBOOK_OBJECT_REVISIONS --
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20131001/431d5c9c/attachment.html>