|
From: <jt...@hy...> - 2007-03-12 21:24:18
|
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> |