1 -- NeonServ Database v5.1
4 -- Tabellenstruktur für Tabelle `bans`
7 CREATE TABLE IF NOT EXISTS `bans` (
8 `ban_id` int(11) NOT NULL AUTO_INCREMENT,
9 `ban_channel` int(11) NOT NULL,
10 `ban_mask` varchar(250) NOT NULL,
11 `ban_triggered` int(15) NOT NULL,
12 `ban_timeout` int(15) NOT NULL,
13 `ban_owner` int(11) NOT NULL,
14 `ban_reason` varchar(512) NOT NULL,
15 PRIMARY KEY (`ban_id`)
16 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
18 -- --------------------------------------------------------
21 -- Tabellenstruktur für Tabelle `bots`
24 CREATE TABLE IF NOT EXISTS `bots` (
25 `id` int(11) NOT NULL AUTO_INCREMENT,
26 `active` tinyint(1) NOT NULL,
27 `nick` varchar(255) NOT NULL,
28 `server` varchar(255) NOT NULL,
29 `port` int(5) NOT NULL,
30 `pass` varchar(255) NOT NULL,
31 `ssl` tinyint(1) NOT NULL,
32 `bind` varchar(255) DEFAULT NULL,
33 `ident` varchar(12) NOT NULL,
34 `realname` varchar(255) NOT NULL,
35 `automodes` varchar(20) NOT NULL,
36 `oper_user` varchar(50) DEFAULT NULL,
37 `oper_pass` varchar(50) DEFAULT NULL,
38 `botclass` int(10) NOT NULL,
39 `textbot` tinyint(1) NOT NULL,
40 `queue` tinyint(1) NOT NULL,
41 `secret` tinyint(1) NOT NULL,
42 `defaulttrigger` varchar(10) NOT NULL,
43 `max_channels` int(5) NOT NULL,
44 `register_priority` int(2) NOT NULL,
46 UNIQUE KEY `nick` (`nick`)
47 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
49 -- --------------------------------------------------------
52 -- Tabellenstruktur für Tabelle `bot_binds`
55 CREATE TABLE IF NOT EXISTS `bot_binds` (
56 `id` int(11) NOT NULL AUTO_INCREMENT,
57 `botclass` int(11) NOT NULL,
58 `botid` int(11) NOT NULL,
59 `command` varchar(60) NOT NULL,
60 `function` varchar(60) NOT NULL,
61 `parameters` varchar(100) NOT NULL,
62 `chan_access` varchar(256) DEFAULT NULL,
63 `global_access` int(3) DEFAULT NULL,
64 `flags` int(10) NOT NULL,
67 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
69 -- --------------------------------------------------------
72 -- Tabellenstruktur für Tabelle `bot_channels`
75 CREATE TABLE IF NOT EXISTS `bot_channels` (
76 `id` int(11) NOT NULL AUTO_INCREMENT,
77 `botid` int(11) NOT NULL,
78 `chanid` int(11) NOT NULL,
79 `trigger` varchar(50) NULL DEFAULT '+',
80 `suspended` tinyint(1) NOT NULL,
82 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
84 -- --------------------------------------------------------
87 -- Tabellenstruktur für Tabelle `channels`
90 CREATE TABLE IF NOT EXISTS `channels` (
91 `channel_id` int(11) NOT NULL AUTO_INCREMENT,
92 `channel_name` varchar(250) NOT NULL,
93 `channel_key` varchar(50) NOT NULL,
94 `channel_maxusers` int(5) NOT NULL,
95 `channel_lastvisit` int(11) NOT NULL,
96 `channel_lastgiveowner` int(15) NOT NULL,
97 `channel_pubcmd` smallint(3) DEFAULT NULL,
98 `channel_nodelete` tinyint(1) NOT NULL,
99 `channel_nogaccess` tinyint(1) DEFAULT NULL,
100 `channel_canadd` smallint(3) DEFAULT NULL,
101 `channel_candel` smallint(3) DEFAULT NULL,
102 `channel_canclvl` smallint(3) DEFAULT NULL,
103 `channel_cankick` smallint(3) DEFAULT NULL,
104 `channel_canban` smallint(3) DEFAULT NULL,
105 `channel_staticban` smallint(3) DEFAULT NULL,
106 `channel_protect` tinyint(1) DEFAULT NULL,
107 `channel_canop` smallint(3) DEFAULT NULL,
108 `channel_canhalfop` smallint(3) DEFAULT NULL,
109 `channel_canvoice` smallint(3) DEFAULT NULL,
110 `channel_getop` smallint(3) DEFAULT NULL,
111 `channel_gethalfop` smallint(3) DEFAULT NULL,
112 `channel_getvoice` smallint(3) DEFAULT NULL,
113 `channel_greeting` varchar(512) NOT NULL,
114 `channel_usergreeting` varchar(512) NOT NULL,
115 `channel_userinfo` smallint(3) DEFAULT NULL,
116 `channel_dynlimit` smallint(5) DEFAULT NULL,
117 `channel_getinvite` smallint(3) DEFAULT NULL,
118 `channel_topicmask` varchar(512) NOT NULL,
119 `channel_exttopic` tinyint(1) NOT NULL,
120 `channel_exttopic_topic` varchar(512) NOT NULL,
121 `channel_defaulttopic` varchar(512) NOT NULL,
122 `channel_wipeinfo` smallint(3) DEFAULT NULL,
123 `channel_modes` varchar(500) DEFAULT NULL,
124 `channel_enfmodes` smallint(3) DEFAULT NULL,
125 `channel_enftopic` smallint(3) DEFAULT NULL,
126 `channel_topicsnarf` smallint(3) DEFAULT NULL,
127 `channel_changetopic` smallint(3) DEFAULT NULL,
128 `channel_setters` smallint(3) DEFAULT NULL,
129 `channel_canresync` smallint(3) DEFAULT NULL,
130 `channel_cansuspend` smallint(3) DEFAULT NULL,
131 `channel_notice` smallint(3) DEFAULT NULL,
132 `channel_noticereaction` tinyint(1) DEFAULT NULL,
133 `channel_ctcp` smallint(3) DEFAULT NULL,
134 `channel_ctcpreaction` tinyint(1) DEFAULT NULL,
135 `channel_registered` int(11) NOT NULL,
136 `channel_registrator` int(11) NOT NULL,
137 `channel_toys` tinyint(1) NOT NULL,
138 `channel_scanner` varchar(50) DEFAULT NULL,
139 `channel_spam_limit` smallint(3) DEFAULT NULL,
140 `channel_spam_reaction` tinyint(1) DEFAULT NULL,
141 `channel_spam_reaction_duration` mediumint(7) DEFAULT NULL,
142 `channel_spam_except` smallint(3) DEFAULT NULL,
143 `channel_flood_limit` smallint(3) DEFAULT NULL,
144 `channel_flood_time` smallint(3) DEFAULT NULL,
145 `channel_flood_reaction` tinyint(1) DEFAULT NULL,
146 `channel_flood_reaction_duration` mediumint(7) DEFAULT NULL,
147 `channel_flood_except` smallint(3) DEFAULT NULL,
148 `channel_join_limit` smallint(3) DEFAULT NULL,
149 `channel_join_time` smallint(3) DEFAULT NULL,
150 `channel_join_reaction` tinyint(1) DEFAULT NULL,
151 `channel_join_reaction_duration` mediumint(7) DEFAULT NULL,
152 `channel_join_except` smallint(3) DEFAULT NULL,
153 `channel_botnet_bantime` mediumint(7) DEFAULT NULL,
154 `channel_botnet_except` smallint(3) DEFAULT NULL,
155 `channel_caps_percent` tinyint(3) DEFAULT NULL,
156 `channel_caps_reaction` tinyint(1) DEFAULT NULL,
157 `channel_caps_reaction_duration` mediumint(7) DEFAULT NULL,
158 `channel_caps_except` smallint(3) DEFAULT NULL,
159 `channel_digit_percent` tinyint(3) DEFAULT NULL,
160 `channel_digit_reaction` tinyint(1) DEFAULT NULL,
161 `channel_digit_reaction_duration` mediumint(7) DEFAULT NULL,
162 `channel_digit_except` smallint(3) DEFAULT NULL,
163 `channel_badword_reaction` tinyint(1) DEFAULT NULL,
164 `channel_badword_reaction_duration` mediumint(7) DEFAULT NULL,
165 `channel_badword_except` smallint(3) DEFAULT NULL,
166 PRIMARY KEY (`channel_id`),
167 UNIQUE KEY `channel_name` (`channel_name`)
168 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
170 -- --------------------------------------------------------
173 -- Tabellenstruktur für Tabelle `chanusers`
176 CREATE TABLE IF NOT EXISTS `chanusers` (
177 `chanuser_id` int(11) NOT NULL AUTO_INCREMENT,
178 `chanuser_cid` int(11) NOT NULL,
179 `chanuser_uid` int(11) NOT NULL,
180 `chanuser_access` int(3) NOT NULL,
181 `chanuser_flags` int(11) NOT NULL,
182 `chanuser_seen` int(11) NOT NULL,
183 `chanuser_infoline` varchar(512) NOT NULL,
184 PRIMARY KEY (`chanuser_id`),
185 KEY `chanuser_cid` (`chanuser_cid`),
186 KEY `chanuser_uid` (`chanuser_uid`)
187 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
189 -- --------------------------------------------------------
192 -- Tabellenstruktur für Tabelle `events`
195 CREATE TABLE IF NOT EXISTS `events` (
196 `id` int(11) NOT NULL AUTO_INCREMENT,
197 `cid` int(11) NOT NULL,
198 `nick` varchar(50) NOT NULL,
199 `auth` varchar(50) NOT NULL,
200 `time` int(11) NOT NULL,
201 `command` varchar(512) NOT NULL,
205 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
207 -- --------------------------------------------------------
210 -- Tabellenstruktur für Tabelle `funcmd`
213 CREATE TABLE IF NOT EXISTS `funcmd` (
214 `id` int(11) NOT NULL AUTO_INCREMENT,
215 `lang` int(11) NOT NULL,
216 `cmd` varchar(50) NOT NULL,
217 `text` text NOT NULL,
219 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='neonserv v3';
221 -- --------------------------------------------------------
224 -- Tabellenstruktur für Tabelle `fundata`
227 CREATE TABLE IF NOT EXISTS `fundata` (
228 `id` int(11) NOT NULL AUTO_INCREMENT,
229 `cid` int(11) NOT NULL,
230 `user` varchar(50) NOT NULL,
231 `name` varchar(50) NOT NULL,
232 `value` text NOT NULL,
237 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='neonserv v3' AUTO_INCREMENT=1 ;
239 -- --------------------------------------------------------
242 -- Tabellenstruktur für Tabelle `godlog`
245 CREATE TABLE IF NOT EXISTS `godlog` (
246 `godlog_id` int(11) NOT NULL AUTO_INCREMENT,
247 `godlog_uid` int(11) NOT NULL,
248 `godlog_cid` int(15) NOT NULL,
249 `godlog_time` int(15) NOT NULL,
250 `godlog_cmd` varchar(512) NOT NULL,
251 PRIMARY KEY (`godlog_id`)
252 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
254 -- --------------------------------------------------------
257 -- Tabellenstruktur für Tabelle `help`
260 CREATE TABLE IF NOT EXISTS `help` (
261 `id` int(11) NOT NULL AUTO_INCREMENT,
262 `lang` varchar(6) NOT NULL,
263 `ident` varchar(64) NOT NULL,
264 `text` text NOT NULL,
266 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
268 -- --------------------------------------------------------
271 -- Tabellenstruktur für Tabelle `language`
274 CREATE TABLE IF NOT EXISTS `language` (
275 `id` int(11) NOT NULL AUTO_INCREMENT,
276 `lang` varchar(5) NOT NULL,
277 `ident` varchar(64) NOT NULL,
278 `text` varchar(256) NOT NULL,
280 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
282 -- --------------------------------------------------------
285 -- Tabellenstruktur für Tabelle `noinvite`
288 CREATE TABLE IF NOT EXISTS `noinvite` (
289 `id` int(11) NOT NULL AUTO_INCREMENT,
290 `cid` int(11) NOT NULL,
291 `uid` int(11) NOT NULL,
293 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
295 -- --------------------------------------------------------
298 -- Tabellenstruktur für Tabelle `owner_history`
302 CREATE TABLE IF NOT EXISTS `owner_history` (
303 `owner_history_id` int(11) NOT NULL AUTO_INCREMENT,
304 `owner_history_cid` int(11) NOT NULL,
305 `owner_history_to_uid` int(11) NOT NULL,
306 `owner_history_from_uid` int(11) NOT NULL,
307 `owner_history_time` int(11) NOT NULL,
308 PRIMARY KEY (`owner_history_id`),
309 KEY `owner_history_cid` (`owner_history_cid`)
310 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
312 -- --------------------------------------------------------
315 -- Tabellenstruktur für Tabelle `users`
318 CREATE TABLE IF NOT EXISTS `users` (
319 `user_id` int(11) NOT NULL AUTO_INCREMENT,
320 `user_user` varchar(250) NOT NULL,
321 `user_access` int(4) NOT NULL,
322 `user_rank` int(11) NOT NULL,
323 `user_god` tinyint(1) NOT NULL,
324 `user_lang` varchar(6) NOT NULL,
325 `user_reply_privmsg` tinyint(1) NOT NULL,
326 `user_block_invites` tinyint(1) NOT NULL,
327 `user_registered` INT(20) NOT NULL,
328 `user_lastcheck` INT(20) NOT NULL,
329 PRIMARY KEY (`user_id`),
330 UNIQUE KEY `user_user` (`user_user`)
331 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
333 -- --------------------------------------------------------
336 -- Tabellenstruktur für Tabelle `support_ranks`
339 CREATE TABLE `support_ranks` (
340 `rank_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
341 `rank_name` VARCHAR( 256 ) NOT NULL ,
342 `rank_access` INT( 4 ) NOT NULL ,
343 `rank_info` VARCHAR( 512 ) NOT NULL ,
344 `rank_order` SMALLINT( 4 ) NOT NULL
347 -- --------------------------------------------------------
350 -- Tabellenstruktur für Tabelle `version`
353 CREATE TABLE IF NOT EXISTS `version` (
354 `database_version` int(5) NOT NULL,
355 PRIMARY KEY (`database_version`)
356 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
358 -- --------------------------------------------------------
361 -- Tabellenstruktur für Tabelle `donotregister`
364 CREATE TABLE `donotregister` (
365 `dnr_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
366 `dnr_target` VARCHAR( 256 ) NOT NULL ,
367 `dnr_user` INT( 11 ) NOT NULL ,
368 `dnr_timeout` INT( 20 ) NOT NULL ,
369 `dnr_reason` TEXT NOT NULL ,
375 -- --------------------------------------------------------
378 -- Tabellenstruktur für Tabelle `helpserv_requests`
381 CREATE TABLE IF NOT EXISTS `helpserv_requests` (
382 `id` int(11) NOT NULL AUTO_INCREMENT,
383 `botid` INT(11) NOT NULL,
384 `host` varchar(200) NOT NULL,
385 `hand` varchar(50) NOT NULL,
386 `nick` varchar(50) NOT NULL,
387 `status` int(1) NOT NULL,
388 `supporter` int(11) NOT NULL,
389 `time` int(20) NOT NULL,
390 `delay` int(20) NOT NULL,
391 `text` text NOT NULL,
394 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
396 -- --------------------------------------------------------
399 -- Tabellenstruktur für Tabelle `helpserv_settings`
402 CREATE TABLE IF NOT EXISTS `helpserv_settings` (
403 `helpserv_botid` int(11) NOT NULL,
404 `helpserv_support` varchar(256) NOT NULL,
405 `helpserv_public` varchar(256) DEFAULT NULL,
406 `helpserv_intern` varchar(256) DEFAULT NULL,
407 `helpserv_intern_announce` TINYINT(1) NOT NULL,
408 PRIMARY KEY (`helpserv_botid`)
409 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
411 -- --------------------------------------------------------
414 -- Tabellenstruktur für Tabelle `settings`
417 CREATE TABLE IF NOT EXISTS `settings` (
418 `name` varchar(100) NOT NULL,
419 `value` text NOT NULL,
421 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
423 -- --------------------------------------------------------
426 -- Tabellenstruktur für Tabelle `spamserv_badwords`
429 CREATE TABLE IF NOT EXISTS `spamserv_badwords` (
430 `badword_id` int(11) NOT NULL AUTO_INCREMENT,
431 `badword_cid` int(11) NOT NULL,
432 `badword_match` varchar(128) NOT NULL,
433 `badword_uid` int(11) NOT NULL,
434 `badword_use_default` tinyint(1) NOT NULL,
435 `badword_exceptlevel` smallint(3) NOT NULL,
436 `badword_scan_ops` tinyint(1) NOT NULL,
437 `badword_scan_voice` tinyint(1) NOT NULL,
438 `badword_use_default_reaction` tinyint(1) NOT NULL,
439 `badword_reaction` tinyint(1) NOT NULL,
440 `badword_reaction_time` int(20) NOT NULL,
441 PRIMARY KEY (`badword_id`),
442 KEY `badword_cid` (`badword_cid`)
443 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;