Real-Time-Messenging-for-SQL-Server/RTM.ProcedureConfiguration.Table.sql at master · DataView-llc/Real-Time-Messenging-for-SQL-Server · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
/****************************************************************************************************

Developed by DataView, LLC. All rights reserved.

Licensed under GNU LESSER GENERAL PUBLIC LICENSE Version 3

Real Time Messenging Software for SQL Server


***************************************************************************************************/

CREATE TABLE [RTM].[ProcedureConfiguration]
(
	[id] [int] IDENTITY(1,1) NOT NULL,
	[SchemaName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[ProcedureName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[varName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[varValueInt] [int] NULL,
	[varValueString] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[description] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Modify_TS] [datetime2](7) NOT NULL,
	[Modify_ID] [varchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

 PRIMARY KEY NONCLUSTERED HASH
(
	[SchemaName],
	[ProcedureName],
	[varName]
)WITH ( BUCKET_COUNT = 8192)
)WITH ( MEMORY_OPTIMIZED = ON , DURABILITY = SCHEMA_AND_DATA )
GO