From 464c3c709102954e502a5d3868bac615c73c64b4 Mon Sep 17 00:00:00 2001 From: Justin Clarke Casey Date: Mon, 29 Sep 2008 20:26:34 +0000 Subject: * Add missing mssql migration files from http://opensimulator.org/mantis/view.php?id=2295 * Sorry about that --- OpenSim/Data/MSSQL/Resources/001_LogStore.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 OpenSim/Data/MSSQL/Resources/001_LogStore.sql (limited to 'OpenSim/Data/MSSQL/Resources/001_LogStore.sql') diff --git a/OpenSim/Data/MSSQL/Resources/001_LogStore.sql b/OpenSim/Data/MSSQL/Resources/001_LogStore.sql new file mode 100644 index 0000000..9ece627 --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/001_LogStore.sql @@ -0,0 +1,17 @@ +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