| 12345678910111213141516171819202122232425262728293031323334353637 |
- -- Licensed Materials - Property of IBM
- -- BI and PM: Mobile
- -- (C) Copyright IBM Corp. 2007, 2012
- -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
- ALTER TABLE [MOB_BLOBS] DROP COLUMN [FORMAT]
- ALTER TABLE [MOB_RESOURCES] ADD [FORMAT] [tinyint] NULL
- ALTER TABLE [MOB_RESOURCES] ADD [HEIGHT] [int] NULL
- ALTER TABLE [MOB_RESOURCES] ADD [WIDTH] [int] NULL
- ALTER TABLE [MOB_RESOURCES] ADD [BLOB_ID] [int] NULL
- ALTER TABLE [MOB_RESOURCES] ADD [OBJECT_INDEX] [int] NULL
- ALTER TABLE [MOB_RESOURCES] ADD [PAGE_INDEX] [int] NULL
- DROP TABLE [MOB_BLOB_FORMATS]
- CREATE TABLE [MOB_RESOURCE_FORMATS] (
- [FORMAT] [tinyint] NOT NULL,
- [DESCRIPTION] [varchar] (100) NULL
- )
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (0, 'USER COOKIE')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (1, 'REPORT INFO')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (2, 'REPORT OUTPUT')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (3, 'DB')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (4, 'HTML')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (5, 'IMAGE')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (6, 'RENDER THUMBNAIL SMALL')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (7, 'RENDER THUMBNAIL LARGE')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (8, 'iOS THUMBNAIL SMALL')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (9, 'iOS THUMBNAIL LARGE')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (10, 'SVG')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (11, 'TABLE HTML')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (12, 'ATTCH IMAGE')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (13, 'CONVERSATION STATE')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (14, 'DASHBOARD')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (15, 'BUX CONVERSATION STATE')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (16, 'GENERAL RESOURCE')
- INSERT INTO [MOB_RESOURCE_FORMATS] VALUES (17, 'PAGE HTMLI')
|
