ODE-1035: Text to LongText
Project: http://git-wip-us.apache.org/repos/asf/ode/repo Commit: http://git-wip-us.apache.org/repos/asf/ode/commit/a28cabec Tree: http://git-wip-us.apache.org/repos/asf/ode/tree/a28cabec Diff: http://git-wip-us.apache.org/repos/asf/ode/diff/a28cabec Branch: refs/heads/master Commit: a28cabeccc3f11600f0f2748d180958dde11fea1 Parents: 4f88cda Author: sathwik <[email protected]> Authored: Wed Jun 28 16:18:36 2017 +0530 Committer: sathwik <[email protected]> Committed: Wed Jun 28 16:18:47 2017 +0530 ---------------------------------------------------------------------- schema-updates/ODE-1035.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ode/blob/a28cabec/schema-updates/ODE-1035.sql ---------------------------------------------------------------------- diff --git a/schema-updates/ODE-1035.sql b/schema-updates/ODE-1035.sql index 800ed2e..8997a20 100644 --- a/schema-updates/ODE-1035.sql +++ b/schema-updates/ODE-1035.sql @@ -1,5 +1,5 @@ # USE COLUMN TYPE FOR COLUMN "DATA" FOR THE RELEVANT DATABASE -#Mysql TEXT +#Mysql LONGTEXT #SQLServer TEXT #Postgres TEXT #Oracle CLOB @@ -10,7 +10,7 @@ #Hibernate MYSQL Script -ALTER TABLE STORE_PROCESS_PROP ADD COLUMN DATA TEXT; +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; @@ -18,7 +18,7 @@ ALTER TABLE STORE_PROCESS_PROP DROP COLUMN VALUE; #OpenJPA MYSQL Script -ALTER TABLE STORE_PROCESS_PROP ADD COLUMN DATA TEXT; +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;
