analytics/configuration/schemas/mobile/informix/upgrade-02-027-to-02-028.sql

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