7t1SbD5e

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 IROrderDocumentCustomModel
27
28
29--------------------------------------------------------------------------------------------
30--- LBPro SOFTWARE SCRIPT SQL
31--- CONSTRAINT DEFINITION
32--- dbo.IROrderDocumentCustomModel - ##### DESCRIPTION #####
33--- CREATED BY: #####
34--------------------------------------------------------------------------------------------
35
36			
37IF db_name()<>'master' AND
38   NOT EXISTS (SELECT * FROM information_schema.TABLE_CONSTRAINTS
39		WHERE CONSTRAINT_NAME ='FK_IROrderDocumentCustomModel_IROrderDocument')
40BEGIN
41	PRINT 'Create contraintFK_IROrderDocumentCustomModel_IROrderDocument';
42	ALTER TABLE IROrderDocumentCustomModel
43	ADD  CONSTRAINT [FK_IROrderDocumentCustomModel_IROrderDocument] FOREIGN KEY([IROrderDocumentID]) REFERENCES [dbo].[IROrderDocument] ([ID]) 
44END
45GO