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 2015/08/06 13:46:40 UTC
ode git commit: ODE-1035: Migration script added
Repository: ode
Updated Branches:
refs/heads/ode-1.3.x d156f9689 -> cee7bd194
ODE-1035: Migration script added
Project: http://git-wip-us.apache.org/repos/asf/ode/repo
Commit: http://git-wip-us.apache.org/repos/asf/ode/commit/cee7bd19
Tree: http://git-wip-us.apache.org/repos/asf/ode/tree/cee7bd19
Diff: http://git-wip-us.apache.org/repos/asf/ode/diff/cee7bd19
Branch: refs/heads/ode-1.3.x
Commit: cee7bd194dd45b670dae70ee720210d44cdd479b
Parents: d156f96
Author: sathwik <sa...@apache.org>
Authored: Thu Aug 6 17:16:12 2015 +0530
Committer: sathwik <sa...@apache.org>
Committed: Thu Aug 6 17:16:12 2015 +0530
----------------------------------------------------------------------
schema-updates/ODE-1035.sql | 26 ++++++++++++++++++++++++++
1 file changed, 26 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/ode/blob/cee7bd19/schema-updates/ODE-1035.sql
----------------------------------------------------------------------
diff --git a/schema-updates/ODE-1035.sql b/schema-updates/ODE-1035.sql
new file mode 100644
index 0000000..800ed2e
--- /dev/null
+++ b/schema-updates/ODE-1035.sql
@@ -0,0 +1,26 @@
+# USE COLUMN TYPE FOR COLUMN "DATA" FOR THE RELEVANT DATABASE
+#Mysql TEXT
+#SQLServer TEXT
+#Postgres TEXT
+#Oracle CLOB
+#H2 CLOB
+#Derby CLOB
+#HSQL LONGVARCHAR
+
+
+
+#Hibernate MYSQL Script
+ALTER TABLE STORE_PROCESS_PROP ADD COLUMN DATA TEXT;
+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 TEXT;
+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;
+