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

[source_changes at macosforge.org]

Revision: 12147
          http://trac.calendarserver.org//changeset/12147
Author:   gaya at apple.com
Date:     2013-12-19 11:22:43 -0800 (Thu, 19 Dec 2013)
Log Message:
-----------
fix constraint drops - 2nd try

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

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_29_to_30.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_29_to_30.sql	2013-12-19 19:16:40 UTC (rev 12146)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_29_to_30.sql	2013-12-19 19:22:43 UTC (rev 12147)
@@ -23,9 +23,9 @@
 ----------------------------------------
 
 begin
-for i in (select constraint_name from abo_members where column_name = 'MEMBER_ID' or column_name = 'GROUP_ID')
+for i in (select constraint_name from user_cons_columns where column_name = 'MEMBER_ID' or column_name = 'GROUP_ID')
 loop
-execute immediate 'alter table abo_members constraint' || i.constraint_name;
+execute immediate 'alter table abo_members drop constraint' || i.constraint_name;
 end loop;
 end;
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20140312/3400679a/attachment.html>