ode-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sath...@apache.org
Subject ode git commit: ODE-1051: final migration script
Date Fri, 04 Nov 2016 05:31:34 GMT
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 <sathwik@apache.org>
Authored: Fri Nov 4 10:59:11 2016 +0530
Committer: sathwik <sathwik@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


Mime
View raw message