1 CREATE TABLE [dbo].[ircd_log] (
\r
2 [id] int IDENTITY(1, 1) NOT NULL,
\r
3 [category_id] int DEFAULT 0 NOT NULL,
\r
7 [dtime] int DEFAULT 0 NOT NULL,
\r
8 PRIMARY KEY CLUSTERED ([id])
\r
12 CREATE TABLE [dbo].[ircd_log_categories] (
\r
13 [category_id] int DEFAULT 0 NOT NULL,
\r
14 [category] varchar(255) NOT NULL,
\r
15 PRIMARY KEY CLUSTERED ([category_id])
\r
19 /* Data for the `dbo.ircd_log_categories` table (Records 1 - 8) */
\r
20 INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (1, N'Oper')
\r
21 INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (2, N'Kill')
\r
22 INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (3, N'Server Link')
\r
23 INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (4, N'G/Z/K/E Line')
\r
24 INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (5, N'Connect')
\r
25 INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (6, N'Disconnect')
\r
26 INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (7, N'Flooding')
\r
27 INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (8, N'Load Module')
\r
30 CREATE TABLE [dbo].[ircd_log_actors] (
\r
31 [id] int IDENTITY(1, 1) NOT NULL,
\r
32 [actor] varchar(255) NULL,
\r
33 PRIMARY KEY CLUSTERED ([id])
\r
37 CREATE TABLE [dbo].[ircd_log_hosts] (
\r
38 [id] int IDENTITY(1, 1) NOT NULL,
\r
39 [hostname] varchar(255) NULL,
\r
40 PRIMARY KEY CLUSTERED ([id])
\r