1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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])
)
|
