-- JRA-14701: Modify the column propertytext.propertyvalue from VARCHAR2 to CLOB
ALTER TABLE PROPERTYTEXT ADD TEMPVALUE CLOB;
UPDATE PROPERTYTEXT SET TEMPVALUE = PROPERTYVALUE;
ALTER TABLE PROPERTYTEXT DROP COLUMN PROPERTYVALUE;
ALTER TABLE PROPERTYTEXT RENAME COLUMN TEMPVALUE TO PROPERTYVALUE;


-- JRA-8293: Modify the column SEARCHREQUEST.REQCONTENT from VARCHAR2 to CLOB
ALTER TABLE SEARCHREQUEST ADD TEMPVALUE CLOB;
UPDATE SEARCHREQUEST SET TEMPVALUE = REQCONTENT;
ALTER TABLE SEARCHREQUEST DROP COLUMN REQCONTENT;
ALTER TABLE SEARCHREQUEST RENAME COLUMN TEMPVALUE TO REQCONTENT;
