--
-- Copyright (c) 1998-2009 Luna Imaging, Inc.  All Rights Reserved.
--
-- This software is confidential and proprietary information of
-- Luna Imaging, Inc.  ("Confidential Information").  You shall not
-- disclose such Confidential Information and shall use it only in
-- accordance with the terms of the license agreement you entered into
-- with Luna Imaging, Inc.
--
-- The software may not be copied, reproduced, translated or reduced to
-- any electronic medium or machine-readable form without
-- the prior written consent of Luna Imaging.
--
-- You are not allowed to distribute the binary and source code
-- (if released) to third parties, without the prior written consent from
-- Luna Imaging.
--
-- You are not allowed to reverse engineer, disassemble or decompile
-- code, or make any modifications of the binary or source code, remove
-- or alter any trademark, logo, copyright or other proprietary notices,
-- legends, symbols, or labels in the Software.
--
-- You are not allowed to sub-license the Software or any derivative
-- work based on or derived from the Software.
--
-- LUNA IMAGING MAKES NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY
-- OF THE SOFTWARE, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED
-- TO THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR
-- PURPOSE, OR NON-INFRINGEMENT, LUNA IMAGING SHALL NOT BE LIABLE FOR ANY
-- DAMAGES SUFFERED BY LICENSEE AS A RESULT OF USING, MODIFYING OR
-- DISTRIBUTING THIS SOFTWARE OR ITS DERIVATIVES.
--


--
-- Alter Table CREDENTIALCOLLECTIONMAP
-- 

ALTER TABLE CREDENTIALCOLLECTIONMAP ADD MAXEXPORTRESOLUTION INTEGER NULL;

UPDATE CREDENTIALCOLLECTIONMAP SET MAXEXPORTRESOLUTION = 4;

--
-- Alter Table EXTERNALMEDIA
-- 

ALTER TABLE EXTERNALMEDIA ADD FORMAT VARCHAR(25) NULL;

--
-- Alter Table MEDIACOLLECTIONS
-- 

ALTER TABLE MEDIACOLLECTIONS ADD COLLECTIONTYPE VARCHAR(25) NULL;
UPDATE MEDIACOLLECTIONS SET COLLECTIONTYPE = 'legacy';

ALTER TABLE SHAREDMEDIACOLLECTIONS ADD COLLECTIONTYPE VARCHAR(25) NULL;
UPDATE SHAREDMEDIACOLLECTIONS SET COLLECTIONTYPE = 'legacy';

INSERT INTO EXTENDEDCOLLECTIONPROPERTIES(COLLECTIONID,INTRODUCTIONTEXT,HEADERGRAPHICURL,THEME,USEASDEFAULT)VALUES('All Collections','','/luna/images/luna-default-header.jpg','default',0);