-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathdbase-structure
102 lines (90 loc) · 4.69 KB
/
dbase-structure
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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
# Exiled.Net IRC Services.
# mySQL database initialisation file.
# ($Id: dbase-structure,v 1.3 2003/02/25 23:48:37 mr Exp $)
USE services;
CREATE TABLE nickdata
(
nick VARCHAR(255) NOT NULL DEFAULT "" UNIQUE PRIMARY KEY, INDEX idx_nick (nick(5)),
email VARCHAR(255) NOT NULL DEFAULT "" UNIQUE, INDEX idx_email (email(5)),
password VARCHAR(255) NOT NULL DEFAULT "",
userhost VARCHAR(255) NOT NULL DEFAULT "",
lastlogin INT(8) UNSIGNED DEFAULT 0,
regdate INT(8) UNSIGNED DEFAULT 0,
info TEXT NOT NULL DEFAULT "",
flags INT(8) UNSIGNED DEFAULT 0,
console INT(8) UNSIGNED DEFAULT 0
);
CREATE TABLE chandata
(
name VARCHAR(255) NOT NULL DEFAULT "" UNIQUE, PRIMARY KEY(name), INDEX idx_chan (name(5)),
owner VARCHAR(255) NOT NULL DEFAULT "",
topic VARCHAR(255) NOT NULL DEFAULT "",
keepmode VARCHAR(255) NOT NULL DEFAULT "",
flags INT(8) UNSIGNED DEFAULT 0,
lastlogin INT(8) UNSIGNED DEFAULT 0
);
CREATE TABLE access
(
channel VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_acc_channel (channel(5)),
nick VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_acc_nick (nick(5)),
level INT(8) UNSIGNED DEFAULT 0
);
CREATE TABLE comment
(
subject VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_com_subject (subject(5)),
nick VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_com_nick (nick(5)),
comment TEXT NOT NULL DEFAULT "",
com_date INT(8) UNSIGNED DEFAULT 0
);
CREATE TABLE notice
(
nick VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_noti_nick (nick(5)),
sender VARCHAR(255) NOT NULL DEFAULT "",
notice VARCHAR(255) NOT NULL DEFAULT "",
com_date INT(8) UNSIGNED DEFAULT 0
);
CREATE TABLE log_nickserv
(
cmd_date INT(8) UNSIGNED DEFAULT 0,
nick VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_log_nick_nick (nick(5)),
userhost VARCHAR(255) NOT NULL DEFAULT "",
command VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_log_nick_cmd (command(5)),
params TEXT NOT NULL DEFAULT ""
);
CREATE TABLE log_chanserv
(
cmd_date INT(8) UNSIGNED DEFAULT 0,
nick VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_log_chan_nick (nick(5)),
userhost VARCHAR(255) NOT NULL DEFAULT "",
command VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_log_chan_cmd (command(5)),
params TEXT NOT NULL DEFAULT ""
);
CREATE TABLE log_operserv
(
cmd_date INT(8) UNSIGNED DEFAULT 0,
nick VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_log_oper_nick (nick(5)),
userhost VARCHAR(255) NOT NULL DEFAULT "",
command VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_log_oper_cmd (command(5)),
params TEXT NOT NULL DEFAULT ""
);
CREATE TABLE log_multiserv
(
cmd_date INT(8) UNSIGNED DEFAULT 0,
nick VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_log_multi_nick (nick(5)),
userhost VARCHAR(255) NOT NULL DEFAULT "",
command VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_log_multi_cmd (command(5)),
params TEXT NOT NULL DEFAULT ""
);
CREATE TABLE log_wallops
(
wa_date INT(8) UNSIGNED DEFAULT 0,
nick VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_log_wallops_from (nick(5)),
msg TEXT NOT NULL DEFAULT ""
);
CREATE TABLE bans
(
chan VARCHAR(255) NOT NULL DEFAULT "", INDEX idx_bans_chan (chan(5)),
mask VARCHAR(255) NOT NULL DEFAULT "",
expire INT(8) UNSIGNED DEFAULT 0,
nick VARCHAR(255) NOT NULL DEFAULT ""
);