[Hyperic-hq-discuss] hq r3713 - in trunk: installer/data sql/bizapp

[<jt...@hy...>]

Author: jtravis
Date: 2007-03-12 13:24:01 -0800 (Mon, 12 Mar 2007)
New Revision: 3713
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3713

Modified:
   trunk/installer/data/db-upgrade.xml
   trunk/sql/bizapp/UpdateStatus.hq-xml
Log:
Add migration and not-null constraints for update status

Modified: trunk/installer/data/db-upgrade.xml
===================================================================
--- trunk/installer/data/db-upgrade.xml	2007-03-12 21:03:15 UTC (rev 3712)
+++ trunk/installer/data/db-upgrade.xml	2007-03-12 21:24:01 UTC (rev 3713)
@@ -4884,7 +4884,30 @@
                      dupFail="false"
                      insertCmd="(ID, PROPKEY, PROPVALUE, DEFAULT_PROPVALUE, FREAD_ONLY) VALUES (55, 'HQ-GUID', '', '', '0')"/>
     </schemaSpec>
-    
+
+    <schemaSpec version="3.19">
+      <schema-directSQL>
+        <statement targetDB="postgresql">
+           CREATE TABLE eam_update_status (
+               id integer NOT NULL,
+               version_col bigint DEFAULT 0 NOT NULL,
+               report character varying(4000),
+               upmode integer NOT NULL,
+               ignored boolean NOT NULL
+           )
+        </statement>
+        <statement targetDB="oracle">
+           CREATE TABLE eam_mescalation_state (
+               id integer NOT NULL,
+               version_col NUMBER(19,0) DEFAULT 0 NOT NULL,
+               report VARCHAR2(4000) NOT NULL,
+               upmode integer NOT NULL,
+               ignored NUMBER(1) NOT NULL
+           )
+        </statement>
+      </schema-directSQL>
+    </schemaSpec>
+
 </dbupgrade>
 
 </target>

Modified: trunk/sql/bizapp/UpdateStatus.hq-xml
===================================================================
--- trunk/sql/bizapp/UpdateStatus.hq-xml	2007-03-12 21:03:15 UTC (rev 3712)
+++ trunk/sql/bizapp/UpdateStatus.hq-xml	2007-03-12 21:24:01 UTC (rev 3713)
@@ -25,11 +25,11 @@
     </property>
 
     <property name="updateModeEnum">
-      <column name="UPMODE" />
+      <column name="UPMODE" not-null="true"/>
     </property>
 
     <property name="ignored">
-      <column name="IGNORED" />
+      <column name="IGNORED" not-null="true"/>
     </property>
   </class>