Repository: ode Updated Branches: refs/heads/ode-1.3.x 97c797240 -> 42aff2dc8
ODE-1035: Text or LonText Project: http://git-wip-us.apache.org/repos/asf/ode/repo Commit: http://git-wip-us.apache.org/repos/asf/ode/commit/f7b4c615 Tree: http://git-wip-us.apache.org/repos/asf/ode/tree/f7b4c615 Diff: http://git-wip-us.apache.org/repos/asf/ode/diff/f7b4c615 Branch: refs/heads/ode-1.3.x Commit: f7b4c6157337666fd45913ef474403d2c69f40b4 Parents: 97c7972 Author: sathwik <[email protected]> Authored: Fri Jul 8 16:17:27 2016 +0530 Committer: sathwik <[email protected]> Committed: Fri Jul 8 16:17:27 2016 +0530 ---------------------------------------------------------------------- schema-updates/ODE-1035.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ode/blob/f7b4c615/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;
