From: <cl...@hy...> - 2009-01-12 23:02:45
|
Author: clee Date: 2009-01-12 13:38:33 -0800 (Mon, 12 Jan 2009) New Revision: 12240 URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=12240 Modified: trunk/installer/data/db-upgrade.xml Log: [HHQ-2768] Need to drop unique constraint before dropping name columns Modified: trunk/installer/data/db-upgrade.xml =================================================================== --- trunk/installer/data/db-upgrade.xml 2009-01-12 20:50:34 UTC (rev 12239) +++ trunk/installer/data/db-upgrade.xml 2009-01-12 21:38:33 UTC (rev 12240) @@ -9540,6 +9540,20 @@ <schemaSpec version="3.133"> <schema-directSQL> + <statement targetDB="oracle"> + drop index EAM_SERVICE_SERVER_IDX + </statement> + <statement targetDB="postgresql"> + drop index EAM_SERVICE_SERVER_IDX + </statement> + <statement targetDB="mysql"> + drop index EAM_SERVICE_SERVER_IDX on EAM_SERVICE + </statement> + </schema-directSQL> + </schemaSpec> + + <schemaSpec version="3.134"> + <schema-directSQL> <statement desc="Drop EAM_SERVER column NAME." fail="false"> ALTER TABLE EAM_SERVER DROP COLUMN NAME </statement> @@ -9555,20 +9569,6 @@ </schema-directSQL> </schemaSpec> - <schemaSpec version="3.134"> - <schema-directSQL> - <statement targetDB="oracle"> - drop index EAM_SERVICE_SERVER_IDX - </statement> - <statement targetDB="postgresql"> - drop index EAM_SERVICE_SERVER_IDX - </statement> - <statement targetDB="mysql"> - drop index EAM_SERVICE_SERVER_IDX on EAM_SERVICE - </statement> - </schema-directSQL> - </schemaSpec> - </dbupgrade> </target> </project> |