[Hyperic-hq-discuss] hq r13730 - trunk/installer/data

[<sc...@hy...>]

Author: scottmf
Date: 2009-09-11 16:14:43 -0700 (Fri, 11 Sep 2009)
New Revision: 13730
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=13730

Modified:
   trunk/installer/data/db-upgrade.xml
Log:
[HHQ-3357] clear out redundant index EAM_RESOURCE_ibfk_1

Modified: trunk/installer/data/db-upgrade.xml
===================================================================
--- trunk/installer/data/db-upgrade.xml	2009-09-11 22:46:08 UTC (rev 13729)
+++ trunk/installer/data/db-upgrade.xml	2009-09-11 23:14:43 UTC (rev 13730)
@@ -10015,7 +10015,11 @@
        entry points of deployments-->
   <schemaSpec version="3.155">
     <schema-directSQL>  
+      <!-- the next two stmts are due to case sensitivity issues on EAM_RESOURCE_EDGE_ibfk_1 -->
       <statement targetDB="mysql" fail="false">
+        ALTER TABLE EAM_RESOURCE DROP FOREIGN KEY EAM_RESOURCE_ibfk_1
+      </statement>
+      <statement targetDB="mysql" fail="false">
         ALTER TABLE EAM_RESOURCE DROP FOREIGN KEY eam_resource_ibfk_1
       </statement>
       <statement targetDB="mysql" fail="false">