-- 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.
ALTER TABLE [MOB_PORTALITEMS] ALTER COLUMN [LABEL] nvarchar (200)  NULL;
CREATE TABLE [MOB_RENDERS_BY_GROUP] (
	[RENDER_ID] [int] NOT NULL,
	[GROUP_ID] [nvarchar] (1024) NOT NULL,
	CONSTRAINT [FK_MOB_RBG_RID] FOREIGN KEY(RENDER_ID) REFERENCES MOB_RENDERS(RENDER_ID) ON DELETE CASCADE
)