vMRWPcPG

1--------------------------------------------------------------------------------------------
2--- LBPro SOFTWARE SCRIPT SQL
3--- TABLE DEFINITION
4--- dbo.IRApparatusUserStatistics - ##### DESCRIPTION #####
5--- CREATED BY: #####
6--- drop table [IRApparatusUserStatistics]
7--------------------------------------------------------------------------------------------
8
9IF db_name()<>'master' AND
10   NOT EXISTS (SELECT * FROM information_schema.tables
11		WHERE table_name = 'IRApparatusUserStatistics' AND table_type = 'BASE TABLE')
12BEGIN
13	PRINT 'Create table IRApparatusUserStatistics';
14	CREATE TABLE [dbo].[IRApparatusUserStatistics](
15
16			[ID]                          bigint          IDENTITY(1, 1) NOT NULL  , 	-- primary key
17			[IRUserID]					  bigint           NOT NULL  , 	-- #####
18			[IRModelGroupID]              bigint           NULL  , 	-- ##### 
19			[IRApparatusCategoryID]       bigint           NULL  , 	-- #####
20			[ModificationDateUTC]         datetime         NOT NULL  , 	-- ##### --czy jest potrzebne?
21			[DeletedUtcDate]			  datetime         NULL  , 	-- ##### --czy jest potrzebne?
22			[Type]						  bit              NOT NULL  , 	-- #####
23			[Count]						  bigint           NULL  , 	-- #####
24			[IsDeleted]					  bit              NOT NULL  , 	-- ##### --czy jest potrzebne?
25
26			CONSTRAINT PK_IRApparatusUserStatistics PRIMARY KEY CLUSTERED ([ID])
27  	);
28END;
29GO
30--- end IRApparatusUserStatistics