You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ode.apache.org by sa...@apache.org on 2016/11/04 05:31:34 UTC
ode git commit: ODE-1051: final migration script
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 <sa...@apache.org>
Authored: Fri Nov 4 10:59:11 2016 +0530
Committer: sathwik <sa...@apache.org>
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