[Hyperic-hq-discuss] hq r14040 - branches/HQ_4_2_0_PATCH/installer/data

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

Author: scottmf
Date: 2009-12-07 13:13:50 -0800 (Mon, 07 Dec 2009)
New Revision: 14040
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=14040

Modified:
   branches/HQ_4_2_0_PATCH/installer/data/db-upgrade.xml
Log:
[HHQ-3592] added cleanup in sql before adding constraints

Modified: branches/HQ_4_2_0_PATCH/installer/data/db-upgrade.xml
===================================================================
--- branches/HQ_4_2_0_PATCH/installer/data/db-upgrade.xml	2009-12-07 17:54:14 UTC (rev 14039)
+++ branches/HQ_4_2_0_PATCH/installer/data/db-upgrade.xml	2009-12-07 21:13:50 UTC (rev 14040)
@@ -10104,6 +10104,12 @@
        entry points of deployments-->
   <schemaSpec version="3.158">
     <schema-directSQL>
+      <statement>
+        delete from EAM_ALERT_ACTION_LOG where alert_id not in (select id from EAM_ALERT)
+      </statement>
+      <statement>
+        delete from EAM_ALERT_ACTION_LOG where action_id not in (select id from EAM_ACTION)
+      </statement>
       <statement targetDB="mysql" fail="false">
          ALTER TABLE EAM_ALERT_ACTION_LOG ADD CONSTRAINT FK423FA3CC1AA4E259
          FOREIGN KEY (ALERT_ID) REFERENCES EAM_ALERT (ID) ON DELETE CASCADE