b5NcY7bE

1--------------------------------------------------------------------------------------------
2--- LBPro SOFTWARE SCRIPT SQL
3--- TABLE DEFINITION
4--- dbo.IRDomainTemplate - ##### DESCRIPTION #####
5--- CREATED BY: #####
6--- drop table [IRDomainTemplate]
7--------------------------------------------------------------------------------------------
8
9IF db_name()<>'master' AND
10   NOT EXISTS (SELECT * FROM information_schema.tables
11		WHERE table_name = 'IRDomainTemplate' AND table_type = 'BASE TABLE')
12BEGIN
13	PRINT 'Create table IRDomainTemplate';
14	CREATE TABLE [dbo].[IRDomainTemplate](
15	
16			[ID]                          bigint          IDENTITY(1, 1) NOT NULL  , 	-- primary key
17			[Name]                        nvarchar(200)    NOT NULL  , 	-- #####
18			[IRClientID]                  bigint           NULL  , 	-- #####
19			[IsDeleted]                   bit              NOT NULL  , 	-- #####
20			[DeleteDateUTC]               datetime         NULL  , 	-- #####
21
22			CONSTRAINT PK_IRDomainTemplate PRIMARY KEY CLUSTERED ([ID])
23  	);
24END;
25GO
26--- end IRDomainTemplate
27
28
29--------------------------------------------------------------------------------------------
30--- LBPro SOFTWARE SCRIPT SQL
31--- TABLE DEFINITION
32--- dbo.IRDomainTemplatePermission - ##### DESCRIPTION #####
33--- CREATED BY: #####
34--- drop table [IRDomainTemplatePermission]
35--------------------------------------------------------------------------------------------
36
37IF db_name()<>'master' AND
38   NOT EXISTS (SELECT * FROM information_schema.tables
39		WHERE table_name = 'IRDomainTemplatePermission' AND table_type = 'BASE TABLE')
40BEGIN
41	PRINT 'Create table IRDomainTemplatePermission';
42	CREATE TABLE [dbo].[IRDomainTemplatePermission](
43	
44			[ID]                          bigint          IDENTITY(1, 1) NOT NULL  , 	-- primary key
45			[IRDomainTemplateID]          bigint           NOT NULL  , 	-- #####
46			[Name]                        nvarchar(200)    NOT NULL  , 	-- #####
47			[Description]                 nvarchar(MAX)    NULL	   ,	-- #####
48			[Number]                      bigint           NOT NULL  , 	-- #####
49			[Order]                       bigint           NOT NULL  , 	-- #####
50			[Type]                        bigint           NOT NULL  , 	-- #####
51			[IsDeleted]                   bit              NOT NULL  , 	-- #####
52			[DeleteDateUTC]               datetime         NULL		, 	-- #####
53			
54			CONSTRAINT PK_IRDomainTemplatePermission PRIMARY KEY CLUSTERED ([ID])
55  	);
56END;
57GO
58--- end IRDomainTemplatePermission