upgrade-02-029-to-03-000.sql 705 B

1234567891011121314
  1. -- Licensed Materials - Property of IBM
  2. -- BI and PM: Mobile
  3. -- (C) Copyright IBM Corp. 2013
  4. -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  5. --
  6. -- Generated by: com.cognos.mobile.internal.server.database.schemagenerator.SchemaGenerator
  7. --
  8. -- Modify column [MOB_PORTALITEMS].[LABEL] to hold 100 UTF-8 characters; up to four bytes each.
  9. ALTER TABLE [MOB_PORTALITEMS] ALTER COLUMN [LABEL] nvarchar (200) NULL;
  10. CREATE TABLE [MOB_RENDERS_BY_GROUP] (
  11. [RENDER_ID] [int] NOT NULL,
  12. [GROUP_ID] [nvarchar] (1024) NOT NULL,
  13. CONSTRAINT [FK_MOB_RBG_RID] FOREIGN KEY(RENDER_ID) REFERENCES MOB_RENDERS(RENDER_ID) ON DELETE CASCADE
  14. )