-- ===============================================================================
--
-- 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: sqlserver-update-db-2.9-to-2.9.7.1.sql,v 1.1 2006/10/24 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 ALTER COLUMN value VARCHAR(4096);

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].cmFormEntryAsset') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE cmFormEntryAsset;
 
CREATE TABLE cmFormEntryAsset (
  id [int] IDENTITY (1, 1),
  formEntryId int NOT NULL,
  fileName VARCHAR(255) NOT NULL,
  fileSize int NOT NULL,
  assetKey VARCHAR(255) NOT NULL,
  contentType VARCHAR(50) NOT NULL,
  assetBlob BLOB NOT NULL,
  PRIMARY KEY  (id)
)

alter table cmCategory add displayName varchar(4096);