schema-updates/update02.sql

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;