|
From: <cl...@hy...> - 2007-03-27 04:26:14
|
Author: clee Date: 2007-03-26 20:26:09 -0800 (Mon, 26 Mar 2007) New Revision: 3917 URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3917 Modified: trunk/installer/data/db-upgrade.xml trunk/sql/common/CrispoOption.hq-xml Log: Rename Crispo Option key column to propkey in order to avoid MySQL keyword Modified: trunk/installer/data/db-upgrade.xml =================================================================== --- trunk/installer/data/db-upgrade.xml 2007-03-27 02:41:31 UTC (rev 3916) +++ trunk/installer/data/db-upgrade.xml 2007-03-27 04:26:09 UTC (rev 3917) @@ -5001,7 +5001,15 @@ </schema-directSQL> </schemaSpec> + <schemaSpec version="3.33"> + <schema-directSQL> + <statement> + ALTER TABLE EAM_CRISPO_OPT RENAME COLUMN KEY TO PROPKEY + </statement> + </schema-directSQL> + </schemaSpec> + </dbupgrade> </target> Modified: trunk/sql/common/CrispoOption.hq-xml =================================================================== --- trunk/sql/common/CrispoOption.hq-xml 2007-03-27 02:41:31 UTC (rev 3916) +++ trunk/sql/common/CrispoOption.hq-xml 2007-03-27 04:26:09 UTC (rev 3917) @@ -19,7 +19,7 @@ </version> <property name="key"> - <column name="KEY" not-null="true"/> + <column name="PROPKEY" not-null="true"/> </property> <property name="value"> |