Repository: ode Updated Branches: refs/heads/master 88eadd935 -> 350d07bdd
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/350d07bd Tree: http://git-wip-us.apache.org/repos/asf/ode/tree/350d07bd Diff: http://git-wip-us.apache.org/repos/asf/ode/diff/350d07bd Branch: refs/heads/master Commit: 350d07bdd0bbdc294471864dad9e522601329607 Parents: 88eadd9 Author: sathwik <[email protected]> Authored: Thu Aug 6 17:18:48 2015 +0530 Committer: sathwik <[email protected]> Committed: Thu Aug 6 17:18:48 2015 +0530 ---------------------------------------------------------------------- schema-updates/ODE-1035.sql | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ode/blob/350d07bd/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; +
