From 020f38774fbe8e0f53b0cb28ab49b378b9dcd325 Mon Sep 17 00:00:00 2001 From: AlexRa Date: Thu, 6 May 2010 23:16:36 +0300 Subject: MS SQL migrations converted to the new format --- OpenSim/Data/MSSQL/Resources/LogStore.migrations | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 OpenSim/Data/MSSQL/Resources/LogStore.migrations (limited to 'OpenSim/Data/MSSQL/Resources/LogStore.migrations') diff --git a/OpenSim/Data/MSSQL/Resources/LogStore.migrations b/OpenSim/Data/MSSQL/Resources/LogStore.migrations new file mode 100644 index 0000000..1430d8d --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/LogStore.migrations @@ -0,0 +1,19 @@ +:VERSION 1 + +BEGIN TRANSACTION + +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] + +COMMIT -- cgit v1.1