ALTER TABLE cmFormEntryValue MODIFY
(
   value VARCHAR2(4000) NULL
);

DROP SEQUENCE cmFormEntryAsset_seq;

CREATE SEQUENCE cmFormEntryAsset_seq START WITH 100 INCREMENT BY 1;

DROP TABLE cmFormEntryAsset;

CREATE TABLE cmFormEntryAsset
(
	id					number NOT NULL,
	formEntryId			number NOT NULL,
	fileName			VARCHAR2(255) NOT NULL,
	fileSize			number NOT NULL,
	assetKey			VARCHAR2(255) NOT NULL,
	contentType			VARCHAR2(50) NOT NULL,
	assetBlob 			blob NOT NULL,
	PRIMARY KEY (id)
);


alter table cmCategory add displayName VARCHAR2(4000) default NULL;