bX5Mr9Zw

1--------------------------------------------------------------------------------------------
2--- LBPro SOFTWARE SCRIPT SQL
3--- TABLE DEFINITION
4--- dbo.IRUserStatistic - ##### DESCRIPTION #####
5--- CREATED BY: #####
6--- drop table [IRUserStatistic]
7--------------------------------------------------------------------------------------------
8
9IF db_name()<>'master' AND
10   NOT EXISTS (SELECT * FROM information_schema.tables
11		WHERE table_name = 'IRUserStatistic' AND table_type = 'BASE TABLE')
12BEGIN
13	PRINT 'Create table IRUserStatistic';
14	CREATE TABLE [dbo].[IRUserStatistic](
15	
16			[ID]                          bigint			IDENTITY(1, 1) NOT NULL  , 	-- primary key
17			[IRUserID]                    bigint			NOT NULL  , 	-- #####
18			[IsDeleted]                   bit				NOT NULL  , 	-- #####
19			[DeletedUtcDate]              datetime			NULL  , 	-- ##### ?
20			[DeletedUserID]               bigint			NULL  , 	-- ##### ?
21			[IRClientID]                  bigint			NULL  , 	-- ##### ?
22
23			[DownloadApparatusCount]               bigint			NULL  , 	-- #####
24			[DownloadManualCount]               bigint			NULL  , 	-- #####
25			[CreateQuoteTaskCount]               bigint			NULL  , 	-- #####
26			[CreateSupportTaskCount]               bigint			NULL  , 	-- #####
27
28			[CreateUtcDate]               datetime			NOT NULL DEFAULT (getutcdate()) , 	-- #####
29			
30			
31
32			CONSTRAINT PK_IRUserStatistic PRIMARY KEY CLUSTERED ([ID])
33  	);
34END;
35GO
36--- end IRUserStatistic