7yAPy7km

1IF db_name()<>'master' AND
2   NOT EXISTS (SELECT * FROM information_schema.tables
3		WHERE table_name = 'IRSystemSettings' AND table_type = 'BASE TABLE')
4BEGIN
5	PRINT 'Create table IRSystemSettings';
6	CREATE TABLE [dbo].[IRSystemSettings](
7	
8			[ID]                        bigint				IDENTITY(1, 1) NOT NULL  , 	-- primary key
9			[Setting]                   nvarchar(max)		NOT NULL  , 				-- setting value
10			[Description]				nvarchar(max)		NOT NULL  , 				-- description on setting
11			[Type]						tinyint				NOT NULL  , 				-- configuration identifier
12			[IsDeleted]					bit					NOT NULL  , 				-- #####
13
14			CONSTRAINT PK_IRSystemSettings PRIMARY KEY CLUSTERED ([ID])
15  	);
16END;
17GO
18--- end IRSystemSettings