-- 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
/

CREATE TABLE MOB_RENDER_TYPES (
	TYPE int NOT NULL,
	DESCRIPTION varchar (100) 
)
/

INSERT INTO MOB_RENDER_TYPES (TYPE, DESCRIPTION) VALUES (1, 'VMDB')
/
INSERT INTO MOB_RENDER_TYPES (TYPE, DESCRIPTION) VALUES (2, 'CCSHTML')
/
INSERT INTO MOB_RENDER_TYPES (TYPE, DESCRIPTION) VALUES (4, 'CCSHTMLI')
/
INSERT INTO MOB_RENDER_TYPES (TYPE, DESCRIPTION) VALUES (8, 'VIEWERHTML')
/

ALTER TABLE MOB_RESOURCES ADD DOWNLOAD_URL varchar (200)
/
ALTER TABLE MOB_RENDERS ADD HAS_MORE_PAGES smallint
/