Author: jtravis
Date: 2007-03-12 13:29:48 -0800 (Mon, 12 Mar 2007)
New Revision: 3715
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3715
Modified:
trunk/installer/data/db-upgrade.xml
Log:
Also add id sequences to migration for update status
Modified: trunk/installer/data/db-upgrade.xml
===================================================================
--- trunk/installer/data/db-upgrade.xml 2007-03-12 21:24:33 UTC (rev 3714)
+++ trunk/installer/data/db-upgrade.xml 2007-03-12 21:29:48 UTC (rev 3715)
@@ -4905,6 +4905,22 @@
ignored NUMBER(1) NOT NULL
)
</statement>
+ <statement targetDB="postgresql">
+ CREATE SEQUENCE eam_update_status_id_seq
+ START WITH 10001
+ INCREMENT BY 1
+ NO MAXVALUE
+ NO MINVALUE
+ CACHE 1
+ </statement>
+ <statement targetDB="oracle">
+ CREATE SEQUENCE eam_update_status_id_seq
+ START WITH 10001
+ INCREMENT BY 1
+ NOMAXVALUE
+ NOCYCLE
+ CACHE 10
+ </statement>
</schema-directSQL>
</schemaSpec>
|
