| 1234567891011121314151617181920 |
- -- 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.
- CREATE TABLE [MOB_DRILLS] (
- [SOURCE_RENDER_ID] [int] NOT NULL,
- [TARGET_RENDER_ID] [int] NOT NULL,
- [DRILL_CONTEXT] [nvarchar] (1000) NOT NULL,
- [DRILL_TYPE] [tinyint] NOT NULL,
- CONSTRAINT [FK_MOB_D_SRID] FOREIGN KEY(SOURCE_RENDER_ID) REFERENCES MOB_RENDERS(RENDER_ID) ON DELETE CASCADE
- )
- -- MOB_DRILL_TYPES
- CREATE TABLE [MOB_DRILL_TYPES] (
- [TYPE] [tinyint] NOT NULL,
- [DESCRIPTION] [varchar] (100) NULL
- )
- INSERT INTO [MOB_DRILL_TYPES] VALUES (0, 'REGULAR')
- INSERT INTO [MOB_DRILL_TYPES] VALUES (1, 'ASTRO')
|
