From e16f90eb328e6ef2ca432b47fde3ff42a9b85e17 Mon Sep 17 00:00:00 2001 From: peavey Date: Sun, 16 Mar 2008 22:48:51 +0000 Subject: Add MsSQL schema for sql log. git-svn-id: http://svn.inspircd.org/repository/trunk/inspircd@9114 e03df62e-2008-0410-955e-edbf42e46eb7 --- extras/m_sqllog.mssql.sql | 42 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 extras/m_sqllog.mssql.sql (limited to 'extras/m_sqllog.mssql.sql') diff --git a/extras/m_sqllog.mssql.sql b/extras/m_sqllog.mssql.sql new file mode 100644 index 000000000..25882dc2e --- /dev/null +++ b/extras/m_sqllog.mssql.sql @@ -0,0 +1,42 @@ +CREATE TABLE [dbo].[ircd_log] ( + [id] int IDENTITY(1, 1) NOT NULL, + [category_id] int DEFAULT 0 NOT NULL, + [nick] int NULL, + [host] int NULL, + [source] int NULL, + [dtime] int DEFAULT 0 NOT NULL, + PRIMARY KEY CLUSTERED ([id]) +) + + +CREATE TABLE [dbo].[ircd_log_categories] ( + [category_id] int DEFAULT 0 NOT NULL, + [category] varchar(255) NOT NULL, + PRIMARY KEY CLUSTERED ([category_id]) +) + + +/* Data for the `dbo.ircd_log_categories` table (Records 1 - 8) */ +INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (1, N'Oper') +INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (2, N'Kill') +INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (3, N'Server Link') +INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (4, N'G/Z/K/E Line') +INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (5, N'Connect') +INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (6, N'Disconnect') +INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (7, N'Flooding') +INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (8, N'Load Module') + + +CREATE TABLE [dbo].[ircd_log_actors] ( + [id] int IDENTITY(1, 1) NOT NULL, + [actor] varchar(255) NULL, + PRIMARY KEY CLUSTERED ([id]) +) + + +CREATE TABLE [dbo].[ircd_log_hosts] ( + [id] int IDENTITY(1, 1) NOT NULL, + [hostname] varchar(255) NULL, + PRIMARY KEY CLUSTERED ([id]) +) + -- cgit v1.2.3