forked from mortenbpost/eservices
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdbase-structure
125 lines (113 loc) · 4.93 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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
# Exiled.Net IRC Services.
# mySQL database initialisation file.
# ($Id: dbase-structure,v 1.5 2004/03/19 21:53:46 mr Exp $)
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(11) UNSIGNED DEFAULT 0,
regdate INT(11) UNSIGNED DEFAULT 0,
info TEXT NOT NULL DEFAULT "",
flags INT(11) UNSIGNED DEFAULT 0,
console INT(11) 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(11) UNSIGNED DEFAULT 0,
lastlogin INT(11) 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(11) 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(11) 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(11) UNSIGNED DEFAULT 0
);
CREATE TABLE log_nickserv
(
cmd_date INT(11) 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(11) 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(11) 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(11) 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(11) 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(11) UNSIGNED DEFAULT 0,
nick VARCHAR(255) NOT NULL DEFAULT ""
);
INSERT INTO nickdata
(
nick,
email,
password,
lastlogin,
userhost,
info,
flags,
regdate,
console
)
VALUES
(
'Staaland',
encrypt(''),
unix_timestamp(),
'Staaland!*[email protected]',
'',
0x80000000+0,
unix_timestamp(),
0
);