[riftsaw-commits] riftsaw SVN: r1355 - in trunk/distribution/src/main/release/conf: migration and 1 other directory.

Author: jeff.yuchang Date: 2011-04-15 02:02:02 -0400 (Fri, 15 Apr 2011) New Revision: 1355 Added: trunk/distribution/src/main/release/conf/migration/db2220-230upgrade.sql trunk/distribution/src/main/release/conf/migration/hsql220-230upgrade.sql trunk/distribution/src/main/release/conf/migration/mysql220-230upgrade.sql trunk/distribution/src/main/release/conf/migration/oracle220-230upgrade.sql trunk/distribution/src/main/release/conf/migration/postgres220-230upgrade.sql trunk/distribution/src/main/release/conf/migration/sqlserver220-230upgrade.sql Modified: trunk/distribution/src/main/release/conf/build.xml Log: *RIFTSAW-374, added db migrations cript. Modified: trunk/distribution/src/main/release/conf/build.xml =================================================================== --- trunk/distribution/src/main/release/conf/build.xml 2011-04-14 15:09:26 UTC (rev 1354) +++ trunk/distribution/src/main/release/conf/build.xml 2011-04-15 06:02:02 UTC (rev 1355) @@ -72,7 +72,7 @@ </target> <!-- ### Upgrade RiftSaw SCHEMA ############################################### --> - <target name="upgrade.riftsaw.schema" + <target name="upgrade.riftsaw.schema.220-230" depends="log.properties" description="upgrade riftsaw schema"> <sql driver="${driver}" @@ -80,6 +80,23 @@ userid="${username}" password="${password}" onerror="continue" + src="migration/${database}220-230upgrade.sql"> + <classpath> + <fileset dir="drivers"> + <include name="*.jar"/> + </fileset> + </classpath> + </sql> + </target> + + <target name="upgrade.riftsaw.schema.210-220" + depends="log.properties" + description="upgrade riftsaw schema"> + <sql driver="${driver}" + url="${connection.url}" + userid="${username}" + password="${password}" + onerror="continue" src="migration/${database}210-220upgrade.sql"> <classpath> <fileset dir="drivers"> @@ -89,6 +106,7 @@ </sql> </target> + <!-- ### Show tables in the database ############################### --> <target name="db.show.tables" depends="log.properties" Added: trunk/distribution/src/main/release/conf/migration/db2220-230upgrade.sql =================================================================== --- trunk/distribution/src/main/release/conf/migration/db2220-230upgrade.sql (rev 0) +++ trunk/distribution/src/main/release/conf/migration/db2220-230upgrade.sql 2011-04-15 06:02:02 UTC (rev 1355) @@ -0,0 +1,4 @@ +UPDATE ODE_SCHEMA_VERSION SET VERSION = 230; + +ALTER TABLE BPAF_EVENT_DATA + ALTER COLUMN VALUE clob(4000); \ No newline at end of file Added: trunk/distribution/src/main/release/conf/migration/hsql220-230upgrade.sql =================================================================== --- trunk/distribution/src/main/release/conf/migration/hsql220-230upgrade.sql (rev 0) +++ trunk/distribution/src/main/release/conf/migration/hsql220-230upgrade.sql 2011-04-15 06:02:02 UTC (rev 1355) @@ -0,0 +1,4 @@ +UPDATE ODE_SCHEMA_VERSION SET VERSION = 230; + +ALTER TABLE BPAF_EVENT_DATA + ALTER COLUMN VALUE clob; \ No newline at end of file Added: trunk/distribution/src/main/release/conf/migration/mysql220-230upgrade.sql =================================================================== --- trunk/distribution/src/main/release/conf/migration/mysql220-230upgrade.sql (rev 0) +++ trunk/distribution/src/main/release/conf/migration/mysql220-230upgrade.sql 2011-04-15 06:02:02 UTC (rev 1355) @@ -0,0 +1,4 @@ +UPDATE ODE_SCHEMA_VERSION SET VERSION = 230; + +ALTER TABLE BPAF_EVENT_DATA + ALTER COLUMN VALUE longtext; \ No newline at end of file Added: trunk/distribution/src/main/release/conf/migration/oracle220-230upgrade.sql =================================================================== --- trunk/distribution/src/main/release/conf/migration/oracle220-230upgrade.sql (rev 0) +++ trunk/distribution/src/main/release/conf/migration/oracle220-230upgrade.sql 2011-04-15 06:02:02 UTC (rev 1355) @@ -0,0 +1,4 @@ +UPDATE ODE_SCHEMA_VERSION SET VERSION = 230; + +ALTER TABLE BPAF_EVENT_DATA + ALTER COLUMN VALUE clob; \ No newline at end of file Added: trunk/distribution/src/main/release/conf/migration/postgres220-230upgrade.sql =================================================================== --- trunk/distribution/src/main/release/conf/migration/postgres220-230upgrade.sql (rev 0) +++ trunk/distribution/src/main/release/conf/migration/postgres220-230upgrade.sql 2011-04-15 06:02:02 UTC (rev 1355) @@ -0,0 +1,4 @@ +UPDATE ODE_SCHEMA_VERSION SET VERSION = 230; + +ALTER TABLE BPAF_EVENT_DATA + ALTER COLUMN VALUE text; \ No newline at end of file Added: trunk/distribution/src/main/release/conf/migration/sqlserver220-230upgrade.sql =================================================================== --- trunk/distribution/src/main/release/conf/migration/sqlserver220-230upgrade.sql (rev 0) +++ trunk/distribution/src/main/release/conf/migration/sqlserver220-230upgrade.sql 2011-04-15 06:02:02 UTC (rev 1355) @@ -0,0 +1,4 @@ +UPDATE ODE_SCHEMA_VERSION SET VERSION = 230; + +ALTER TABLE BPAF_EVENT_DATA + ALTER COLUMN VALUE text null; \ No newline at end of file