Author: rr
Date: Thu May 13 17:33:04 2010
New Revision: 943948
URL: http://svn.apache.org/viewvc?rev=943948&view=rev
Log:
Adding schema updates from previous ODE version
Added:
ode/branches/APACHE_ODE_1.X/schema-updates/
ode/branches/APACHE_ODE_1.X/schema-updates/update01.sql (with props)
ode/branches/APACHE_ODE_1.X/schema-updates/update02.sql (with props)
Added: ode/branches/APACHE_ODE_1.X/schema-updates/update01.sql
URL:
http://svn.apache.org/viewvc/ode/branches/APACHE_ODE_1.X/schema-updates/update01.sql?rev=943948&view=auto
==============================================================================
--- ode/branches/APACHE_ODE_1.X/schema-updates/update01.sql (added)
+++ ode/branches/APACHE_ODE_1.X/schema-updates/update01.sql Thu May 13 17:33:04
2010
@@ -0,0 +1,7 @@
+alter table BPEL_XML_DATA add DATA blob;
+
+update BPEL_XML_DATA bxd set DATA=(select BIN_DATA from LARGE_DATA where id =
bxd.ldata_id);
+delete from LARGE_DATA ld where ld.id in (select ldata_id from BPEL_XML_DATA);
+alter table BPEL_XML_DATA drop column ldata_id;
+
+alter table BPEL_XML_DATA add SIMPLE_VALUE varchar2(255);
Propchange: ode/branches/APACHE_ODE_1.X/schema-updates/update01.sql
------------------------------------------------------------------------------
svn:eol-style = native
Added: ode/branches/APACHE_ODE_1.X/schema-updates/update02.sql
URL:
http://svn.apache.org/viewvc/ode/branches/APACHE_ODE_1.X/schema-updates/update02.sql?rev=943948&view=auto
==============================================================================
--- ode/branches/APACHE_ODE_1.X/schema-updates/update02.sql (added)
+++ ode/branches/APACHE_ODE_1.X/schema-updates/update02.sql Thu May 13 17:33:04
2010
@@ -0,0 +1,14 @@
+create table ODE_JOB_BAK as select * from ODE_JOB;
+alter table ODE_JOB add instanceId number(37);
+alter table ODE_JOB add mexId varchar(255);
+alter table ODE_JOB add processId varchar(255);
+alter table ODE_JOB add type varchar(255);
+alter table ODE_JOB add channel varchar(255);
+alter table ODE_JOB add correlatorId varchar(255);
+alter table ODE_JOB add correlationKeySet varchar(255);
+alter table ODE_JOB add retryCount int;
+alter table ODE_JOB add inMem int;
+alter table ODE_JOB add priority int;
+alter table ODE_JOB add detailsExt blob;
+update ODE_JOB oj set detailsExt = (select details from ODE_JOB where jobid =
oj.jobid);
+alter table ODE_JOB drop column details;
Propchange: ode/branches/APACHE_ODE_1.X/schema-updates/update02.sql
------------------------------------------------------------------------------
svn:eol-style = native
