-- Licensed Materials - Property of IBM
-- BI and PM: Mobile
-- (C) Copyright IBM Corp. 2013
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

ALTER TABLE [MOB_RENDERS] ADD [OUTPUT_TYPE_MASK] [int]  NULL

CREATE TABLE [MOB_RENDER_TYPES] (
	[TYPE] [tinyint] NOT NULL,
	[DESCRIPTION] [varchar] (100) NULL 
)

INSERT INTO [MOB_RENDER_TYPES] VALUES (1, 'VMDB')
INSERT INTO [MOB_RENDER_TYPES] VALUES (2, 'CCSHTML')
INSERT INTO [MOB_RENDER_TYPES] VALUES (4, 'CCSHTMLI')
INSERT INTO [MOB_RENDER_TYPES] VALUES (8, 'VIEWERHTML')

ALTER TABLE [MOB_RESOURCES] add [DOWNLOAD_URL] nvarchar (200) NULL

ALTER TABLE [MOB_RENDERS] ADD [HAS_MORE_PAGES] [tinyint] NULL