diff options
| author | peavey <peavey@e03df62e-2008-0410-955e-edbf42e46eb7> | 2008-03-16 22:48:51 +0000 |
|---|---|---|
| committer | peavey <peavey@e03df62e-2008-0410-955e-edbf42e46eb7> | 2008-03-16 22:48:51 +0000 |
| commit | e16f90eb328e6ef2ca432b47fde3ff42a9b85e17 (patch) | |
| tree | da5b9ee8430ca7ed5713259a4fdd2ab05cff9c2d /extras/m_sqllog.mssql.sql | |
| parent | b40bd0f7ab7ed92d898f3e48eea1abc737b4f2a9 (diff) | |
Add MsSQL schema for sql log.
git-svn-id: http://svn.inspircd.org/repository/trunk/inspircd@9114 e03df62e-2008-0410-955e-edbf42e46eb7
Diffstat (limited to 'extras/m_sqllog.mssql.sql')
| -rw-r--r-- | extras/m_sqllog.mssql.sql | 42 |
1 files changed, 42 insertions, 0 deletions
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])
+)
+
|