analytics/configuration/schemas/mobile/db2zOS/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.

--
--  Modifications:
--
--  1) Change COGMOBDB  to the desired database name.
--  2) Change DB0AUSR   to the desired storage group name.
--  3) Note: CCSID is an estimated value, your requirements may differ.

ALTER TABLE MOB_RESOURCES ADD DOWNLOAD_URL varchar (200)
/

ALTER TABLE MOB_RENDERS ADD OUTPUT_TYPE_MASK int
/

ALTER TABLE MOB_RENDERS ADD HAS_MORE_PAGES smallint
/

CREATE TABLE MOB_RENDER_TYPES (
	TYPE int NOT NULL,
	DESCRIPTION varchar (100) 
)IN COGMOBDB.COGMOBTS CCSID UNICODE
/

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