dEcCcKnr

1--------------------------------------------------------------------------------------------
2--- LBPro SOFTWARE SCRIPT SQL
3--- TABLE DEFINITION
4--- dbo.IROrderDocumentCustomModel - ##### DESCRIPTION #####
5--- CREATED BY: #####
6--- drop table [IROrderDocumentCustomModel]
7--------------------------------------------------------------------------------------------
8
9IF db_name()<>'master' AND
10   NOT EXISTS (SELECT * FROM information_schema.tables
11		WHERE table_name = 'IROrderDocumentCustomModel' AND table_type = 'BASE TABLE')
12BEGIN
13	PRINT 'Create table IROrderDocumentCustomModel';
14	CREATE TABLE [dbo].[IROrderDocumentCustomModel](
15	
16			[ID]                          bigint          IDENTITY(1, 1) NOT NULL  , 	-- primary key
17			[IROrderDocumentID]           bigint           NOT NULL  , 	-- #####
18			[Description]                 nvarchar(MAX)    NULL  , 	-- #####
19			[IsDeleted]                   bit              NOT NULL  , 	-- #####
20			[DeleteDateUTC]               datetime         NULL  , 	-- #####
21
22			CONSTRAINT PK_IROrderDocumentCustomModel PRIMARY KEY CLUSTERED ([ID])
23  	);
24END;
25GO
26--- end IRModelTag