schema-updates/ODE-1035.sql

# 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;