[Hyperic-hq-discuss] hq r5748 - in trunk: installer/data sql/control

[<rm...@hy...>]

Author: rmorgan
Date: 2007-08-30 10:00:17 -0700 (Thu, 30 Aug 2007)
New Revision: 5748
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=5748

Modified:
   trunk/installer/data/db-upgrade.xml
   trunk/sql/control/ControlHistory.hbm.xml
Log:
Add version column to ControlHistory. [HQ-876]



Modified: trunk/installer/data/db-upgrade.xml
===================================================================
--- trunk/installer/data/db-upgrade.xml	2007-08-30 13:17:30 UTC (rev 5747)
+++ trunk/installer/data/db-upgrade.xml	2007-08-30 17:00:17 UTC (rev 5748)
@@ -6594,6 +6594,15 @@
     <schemaSpec version="3.49">
       <metricDataUpgrade/>
     </schemaSpec>
+
+    <schemaSpec version="3.50">
+        <schema-addColumn table="EAM_CONTROL_HISTORY"
+                          column="VERSION_COL" columnType="LONG">
+           <initializer>
+             UPDATE EAM_CONTROL_HISTORY SET VERSION_COL=0
+           </initializer>
+         </schema-addColumn>
+    </schemaSpec>
 </dbupgrade>
 </target>
 

Modified: trunk/sql/control/ControlHistory.hbm.xml
===================================================================
--- trunk/sql/control/ControlHistory.hbm.xml	2007-08-30 13:17:30 UTC (rev 5747)
+++ trunk/sql/control/ControlHistory.hbm.xml	2007-08-30 17:00:17 UTC (rev 5748)
@@ -9,6 +9,10 @@
       </generator>
     </id>
 
+    <version name="_version_" type="long">
+      <column name="VERSION_COL" default="0"/>
+    </version>
+
     <property name="groupId" type="integer">
       <column name="GROUP_ID"/>
     </property>
@@ -71,4 +75,4 @@
 
   </class>
 
-</hibernate-mapping>
\ No newline at end of file
+</hibernate-mapping>