Repository: ode Updated Branches: refs/heads/ode-1.3.x 9b85b2022 -> c4e742c28
ODE-1051: final migration script Project: http://git-wip-us.apache.org/repos/asf/ode/repo Commit: http://git-wip-us.apache.org/repos/asf/ode/commit/c4e742c2 Tree: http://git-wip-us.apache.org/repos/asf/ode/tree/c4e742c2 Diff: http://git-wip-us.apache.org/repos/asf/ode/diff/c4e742c2 Branch: refs/heads/ode-1.3.x Commit: c4e742c28507cef9dfc4281aaac5e377bfdce1c9 Parents: 9b85b20 Author: sathwik <[email protected]> Authored: Fri Nov 4 10:59:11 2016 +0530 Committer: sathwik <[email protected]> Committed: Fri Nov 4 10:59:11 2016 +0530 ---------------------------------------------------------------------- schema-updates/migrate-ode-1.3.6-to-1.3.7.sql | 55 ++++++++++++++++++++++ 1 file changed, 55 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ode/blob/c4e742c2/schema-updates/migrate-ode-1.3.6-to-1.3.7.sql ---------------------------------------------------------------------- diff --git a/schema-updates/migrate-ode-1.3.6-to-1.3.7.sql b/schema-updates/migrate-ode-1.3.6-to-1.3.7.sql new file mode 100644 index 0000000..b07ad17 --- /dev/null +++ b/schema-updates/migrate-ode-1.3.6-to-1.3.7.sql @@ -0,0 +1,55 @@ +# Migration Section 1: +# ============================================================================================================================ + +# All databases need to be migrated and the column type to be used is given below. +# MYSQL migration is provided here, users are requested to check appropriate database syntax for other databases. + + +# USE COLUMN TYPE FOR COLUMN "DATA" FOR THE RELEVANT DATABASE +# Mysql LONGTEXT +# SQLServer TEXT +# Postgres TEXT +# Oracle CLOB +# H2 CLOB +# Derby CLOB +# HSQL LONGVARCHAR + + +# Hibernate MYSQL Script +ALTER TABLE STORE_PROCESS_PROP ADD COLUMN DATA LONGTEXT; +CREATE TABLE STORE_PROCESS_PROP_TEST SELECT * FROM STORE_PROCESS_PROP; +UPDATE STORE_PROCESS_PROP A SET A.DATA=(SELECT VALUE FROM STORE_PROCESS_PROP_TEST WHERE PROPID=A.PROPID AND NAME=A.NAME); +DROP TABLE STORE_PROCESS_PROP_TEST; +ALTER TABLE STORE_PROCESS_PROP DROP COLUMN VALUE; + + +# OpenJPA MYSQL Script +ALTER TABLE STORE_PROCESS_PROP ADD COLUMN DATA LONGTEXT; +CREATE TABLE STORE_PROCESS_PROP_TEST SELECT * FROM STORE_PROCESS_PROP; +UPDATE STORE_PROCESS_PROP A SET A.DATA=(SELECT PROP_VAL FROM STORE_PROCESS_PROP_TEST WHERE ID=A.ID); +DROP TABLE STORE_PROCESS_PROP_TEST; +ALTER TABLE STORE_PROCESS_PROP DROP COLUMN PROP_VAL; + +# ========================================================================================================================== + + + + +# Migration Section 2: +# ====================================================================================================== + +# Additional Migration for MySQL for Hibernate. No other databases need the below changes. + +ALTER TABLE BPEL_ACTIVITY_RECOVERY MODIFY DETAILS longblob; +ALTER TABLE BPEL_EVENT MODIFY DETAIL longtext; +ALTER TABLE BPEL_EVENT MODIFY DATA longblob; +ALTER TABLE BPEL_FAULT MODIFY DATA longblob; +ALTER TABLE BPEL_INSTANCE MODIFY JACOB_STATE_DATA longblob; +ALTER TABLE BPEL_MESSAGE MODIFY MESSAGE_DATA longblob; +ALTER TABLE BPEL_MESSAGE MODIFY MESSAGE_HEADER longblob; +ALTER TABLE BPEL_MESSAGE_EXCHANGE MODIFY ENDPOINT longblob; +ALTER TABLE BPEL_MESSAGE_EXCHANGE MODIFY CALLBACK_ENDPOINT longblob; +ALTER TABLE BPEL_PLINK_VAL MODIFY MYROLE_EPR_DATA longblob; +ALTER TABLE BPEL_PLINK_VAL MODIFY PARTNERROLE_EPR_DATA longblob; +ALTER TABLE BPEL_XML_DATA MODIFY DATA longblob; +# ======================================================================================================= \ No newline at end of file
