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

[<pn...@hy...>]

Author: pnguyen
Date: 2009-10-28 11:23:45 -0700 (Wed, 28 Oct 2009)
New Revision: 13911
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=13911

Modified:
   trunk/installer/data/db-upgrade.xml
Log:
[HHQ-3503] revert schemaSpec version="3.193" due to syntax issue with mysql 5.1

Modified: trunk/installer/data/db-upgrade.xml
===================================================================
--- trunk/installer/data/db-upgrade.xml	2009-10-28 01:02:42 UTC (rev 13910)
+++ trunk/installer/data/db-upgrade.xml	2009-10-28 18:23:45 UTC (rev 13911)
@@ -10868,17 +10868,6 @@
 	    </schema-directSQL>  
    </schemaSpec>
 
-  <schemaSpec version="3.193">
-    <schema-directSQL>  
-      <statement desc="Cleanup deleted alert definitions">
-		UPDATE EAM_ALERT_DEFINITION
-		SET ACTIVE = '0', ENABLED = '0'
-		WHERE DELETED = '1'
-		AND (ACTIVE = '1' OR ENABLED = '1')
-      </statement>
-    </schema-directSQL>  
-  </schemaSpec>
-   
 </dbupgrade>
 </target>
 </project>