summaryrefslogtreecommitdiff
path: root/extras/m_sqllog.mssql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'extras/m_sqllog.mssql.sql')
-rw-r--r--extras/m_sqllog.mssql.sql42
1 files changed, 0 insertions, 42 deletions
diff --git a/extras/m_sqllog.mssql.sql b/extras/m_sqllog.mssql.sql
deleted file mode 100644
index 25882dc2e..000000000
--- a/extras/m_sqllog.mssql.sql
+++ /dev/null
@@ -1,42 +0,0 @@
-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])
-)
-