analytics/configuration/schemas/mobile/oracle/upgrade-02-029-to-03-000.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.
-- 
-- Generated by: com.cognos.mobile.internal.server.database.schemagenerator.SchemaGenerator
-- 
-- Modify column [MOB_PORTALITEMS].[LABEL]  to hold 100 UTF-8 characters; up to four bytes each.
DECLARE
	TABLE_DOES_NOT_EXIST_EXCEPTION EXCEPTION;
	PRAGMA EXCEPTION_INIT(TABLE_DOES_NOT_EXIST_EXCEPTION, -942);
BEGIN
	EXECUTE IMMEDIATE 'ALTER TABLE MOB_PORTALITEMS MODIFY ( LABEL NVARCHAR2(200) )';
EXCEPTION
	WHEN TABLE_DOES_NOT_EXIST_EXCEPTION THEN
		NULL;
END;
/

DECLARE
	TABLE_EXISTS_EXCEPTION EXCEPTION;
	PRAGMA EXCEPTION_INIT (TABLE_EXISTS_EXCEPTION, -955);
BEGIN
	EXECUTE IMMEDIATE 'CREATE TABLE MOB_RENDERS_BY_GROUP (
		RENDER_ID int NOT NULL,
		GROUP_ID varchar (1024) NOT NULL,
		CONSTRAINT FK_MOB_RBG_RID FOREIGN KEY(RENDER_ID) REFERENCES MOB_RENDERS(RENDER_ID)
	)';
EXCEPTION
	WHEN TABLE_EXISTS_EXCEPTION THEN
		NULL;
END;
/