-- ===============================================================================
--
-- Part of the InfoGlue Content Management Platform (www.infoglue.org)
--
-- ===============================================================================
--
--  Copyright (C)
--
-- This program is free software; you can redistribute it and/or modify it under
-- the terms of the GNU General Public License version 2, as published by the
-- Free Software Foundation. See the file LICENSE.html for more information.
--
-- This program is distributed in the hope that it will be useful, but WITHOUT
-- ANY WARRANTY, including the implied warranty of MERCHANTABILITY or FITNESS
-- FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License along with
-- this program; if not, write to the Free Software Foundation, Inc. / 59 Temple
-- Place, Suite 330 / Boston, MA 02111-1307 / USA.
--
-- ===============================================================================
--
-- $Id: update-db-2.9-to-2.9.7.1.sql,v 1.1 2008/07/03 15:35:20 mattias Exp $
--
-- This script contains the database updates required to go from 2.9 to 2.9.7.1.

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;