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