aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql/mssql-logs.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--share/sql/mssql-logs.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/share/sql/mssql-logs.sql b/share/sql/mssql-logs.sql
new file mode 100644
index 0000000..3b747d8
--- /dev/null
+++ b/share/sql/mssql-logs.sql
@@ -0,0 +1,20 @@
1SET ANSI_NULLS ON
2
3SET QUOTED_IDENTIFIER ON
4
5SET ANSI_PADDING ON
6
7CREATE TABLE [logs] (
8 [logID] [int] NOT NULL,
9 [target] [varchar](36) default NULL,
10 [server] [varchar](64) default NULL,
11 [method] [varchar](64) default NULL,
12 [arguments] [varchar](255) default NULL,
13 [priority] [int] default NULL,
14 [message] [ntext],
15 PRIMARY KEY CLUSTERED
16(
17 [logID] ASC
18)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
19) ON [PRIMARY]
20