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

ALTER TABLE [MOB_BLOBS] DROP COLUMN [FORMAT]
ALTER TABLE [MOB_RESOURCES] ADD [FORMAT] [tinyint] NULL
ALTER TABLE [MOB_RESOURCES] ADD [HEIGHT] [int] NULL
ALTER TABLE [MOB_RESOURCES] ADD [WIDTH] [int] NULL
ALTER TABLE [MOB_RESOURCES] ADD [BLOB_ID] [int] NULL
ALTER TABLE [MOB_RESOURCES] ADD [OBJECT_INDEX] [int] NULL
ALTER TABLE [MOB_RESOURCES] ADD [PAGE_INDEX] [int] NULL

DROP TABLE [MOB_BLOB_FORMATS]
CREATE TABLE [MOB_RESOURCE_FORMATS] (
	[FORMAT] [tinyint] NOT NULL,
	[DESCRIPTION] [varchar] (100) NULL 
)

INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (0, 'USER COOKIE')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (1, 'REPORT INFO')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (2, 'REPORT OUTPUT')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (3, 'DB')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (4, 'HTML')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (5, 'IMAGE')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (6, 'RENDER THUMBNAIL SMALL')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (7, 'RENDER THUMBNAIL LARGE')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (8, 'iOS THUMBNAIL SMALL')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (9, 'iOS THUMBNAIL LARGE')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (10, 'SVG')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (11, 'TABLE HTML')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (12, 'ATTCH IMAGE')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (13, 'CONVERSATION STATE')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (14, 'DASHBOARD')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (15, 'BUX CONVERSATION STATE')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (16, 'GENERAL RESOURCE')
INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (17, 'PAGE HTMLI')