aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/Mssql-logs.sql
blob: 3b747d8a0d6abaf895c2065081c6e6e7d2a27d33 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [logs] (
  [logID] [int] NOT NULL,
  [target] [varchar](36) default NULL,
  [server] [varchar](64) default NULL,
  [method] [varchar](64) default NULL,
  [arguments] [varchar](255) default NULL,
  [priority] [int] default NULL,
  [message] [ntext],
  PRIMARY KEY CLUSTERED
(
	[logID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]