[Hyperic-hq-discuss] hq r3917 - in trunk: installer/data sql/common

[<cl...@hy...>]

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">