Author: scottmf
Date: 2009-12-07 13:14:44 -0800 (Mon, 07 Dec 2009)
New Revision: 14041
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=14041
Modified:
trunk/installer/data/db-upgrade.xml
Log:
[HHQ-3592] added cleanup in sql before adding constraints
Modified: trunk/installer/data/db-upgrade.xml
===================================================================
--- trunk/installer/data/db-upgrade.xml 2009-12-07 21:13:50 UTC (rev 14040)
+++ trunk/installer/data/db-upgrade.xml 2009-12-07 21:14:44 UTC (rev 14041)
@@ -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
|
