-- 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')