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 `botclass` int(10) NOT NULL,
37 `textbot` tinyint(1) NOT NULL,
38 `defaulttrigger` varchar(10) NOT NULL,
39 `max_channels` int(5) NOT NULL,
40 `register_priority` int(2) NOT NULL,
42 UNIQUE KEY `nick` (`nick`)
43 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
45 -- --------------------------------------------------------
48 -- Tabellenstruktur für Tabelle `bot_binds`
51 CREATE TABLE IF NOT EXISTS `bot_binds` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `botclass` int(11) NOT NULL,
54 `command` varchar(60) NOT NULL,
55 `function` varchar(60) NOT NULL,
56 `parameters` varchar(100) NOT NULL,
57 `chan_access` varchar(256) DEFAULT NULL,
58 `global_access` int(3) DEFAULT NULL,
59 `flags` tinyint(4) NOT NULL,
61 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
63 -- --------------------------------------------------------
66 -- Tabellenstruktur für Tabelle `bot_channels`
69 CREATE TABLE IF NOT EXISTS `bot_channels` (
70 `id` int(11) NOT NULL AUTO_INCREMENT,
71 `botid` int(11) NOT NULL,
72 `chanid` int(11) NOT NULL,
73 `trigger` varchar(50) NOT NULL DEFAULT '+',
74 `suspended` tinyint(1) NOT NULL,
76 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
78 -- --------------------------------------------------------
81 -- Tabellenstruktur für Tabelle `channels`
84 CREATE TABLE IF NOT EXISTS `channels` (
85 `channel_id` int(11) NOT NULL AUTO_INCREMENT,
86 `channel_name` varchar(250) NOT NULL,
87 `channel_key` varchar(50) NOT NULL,
88 `channel_maxusers` int(5) NOT NULL,
89 `channel_lastvisit` int(11) NOT NULL,
90 `channel_lastgiveowner` int(15) NOT NULL,
91 `channel_pubcmd` smallint(3) DEFAULT NULL,
92 `channel_nodelete` tinyint(1) NOT NULL,
93 `channel_nogaccess` tinyint(1) DEFAULT NULL,
94 `channel_canadd` smallint(3) DEFAULT NULL,
95 `channel_candel` smallint(3) DEFAULT NULL,
96 `channel_canclvl` smallint(3) DEFAULT NULL,
97 `channel_cankick` smallint(3) DEFAULT NULL,
98 `channel_canban` smallint(3) DEFAULT NULL,
99 `channel_staticban` smallint(3) DEFAULT NULL,
100 `channel_protect` tinyint(1) DEFAULT NULL,
101 `channel_canop` smallint(3) DEFAULT NULL,
102 `channel_canvoice` smallint(3) DEFAULT NULL,
103 `channel_getop` smallint(3) DEFAULT NULL,
104 `channel_getvoice` smallint(3) DEFAULT NULL,
105 `channel_greeting` varchar(512) NOT NULL,
106 `channel_usergreeting` varchar(512) NOT NULL,
107 `channel_userinfo` smallint(3) DEFAULT NULL,
108 `channel_scanstate` int(11) DEFAULT NULL,
109 `channel_scanexcept` smallint(3) DEFAULT NULL,
110 `channel_maxrepeat` smallint(5) DEFAULT NULL,
111 `channel_repeatreaction` tinyint(1) DEFAULT NULL,
112 `channel_maxflood` smallint(5) DEFAULT NULL,
113 `channel_floodtime` smallint(5) DEFAULT NULL,
114 `channel_floodreaction` tinyint(1) DEFAULT NULL,
115 `channel_maxjoin` smallint(5) DEFAULT NULL,
116 `channel_jointime` smallint(5) DEFAULT NULL,
117 `channel_joinreaction` tinyint(1) DEFAULT NULL,
118 `channel_dynlimit` smallint(5) DEFAULT NULL,
119 `channel_getinvite` smallint(3) DEFAULT NULL,
120 `channel_topicmask` varchar(512) NOT NULL,
121 `channel_exttopic` tinyint(1) NOT NULL,
122 `channel_exttopic_topic` varchar(512) NOT NULL,
123 `channel_defaulttopic` varchar(512) NOT NULL,
124 `channel_wipeinfo` smallint(3) DEFAULT NULL,
125 `channel_modes` varchar(500) DEFAULT NULL,
126 `channel_enfmodes` smallint(3) DEFAULT NULL,
127 `channel_enftopic` smallint(3) DEFAULT NULL,
128 `channel_topicsnarf` smallint(3) DEFAULT NULL,
129 `channel_changetopic` smallint(3) DEFAULT NULL,
130 `channel_setters` smallint(3) DEFAULT NULL,
131 `channel_canresync` smallint(3) DEFAULT NULL,
132 `channel_cansuspend` smallint(3) DEFAULT NULL,
133 `channel_notice` smallint(3) DEFAULT NULL,
134 `channel_noticereaction` tinyint(1) DEFAULT NULL,
135 `channel_ctcp` smallint(3) DEFAULT NULL,
136 `channel_ctcpreaction` tinyint(1) DEFAULT NULL,
137 `channel_registered` int(11) NOT NULL,
138 `channel_registrator` int(11) NOT NULL,
139 `channel_toys` tinyint(1) NOT NULL,
140 PRIMARY KEY (`channel_id`),
141 UNIQUE KEY `channel_name` (`channel_name`)
142 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
144 -- --------------------------------------------------------
147 -- Tabellenstruktur für Tabelle `chanusers`
150 CREATE TABLE IF NOT EXISTS `chanusers` (
151 `chanuser_id` int(11) NOT NULL AUTO_INCREMENT,
152 `chanuser_cid` int(11) NOT NULL,
153 `chanuser_uid` int(11) NOT NULL,
154 `chanuser_access` int(3) NOT NULL,
155 `chanuser_flags` int(11) NOT NULL,
156 `chanuser_seen` int(11) NOT NULL,
157 `chanuser_infoline` varchar(512) NOT NULL,
158 PRIMARY KEY (`chanuser_id`),
159 KEY `chanuser_cid` (`chanuser_cid`),
160 KEY `chanuser_uid` (`chanuser_uid`)
161 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
163 -- --------------------------------------------------------
166 -- Tabellenstruktur für Tabelle `events`
169 CREATE TABLE IF NOT EXISTS `events` (
170 `id` int(11) NOT NULL AUTO_INCREMENT,
171 `cid` int(11) NOT NULL,
172 `nick` varchar(50) NOT NULL,
173 `auth` varchar(50) NOT NULL,
174 `time` int(11) NOT NULL,
175 `command` varchar(512) NOT NULL,
179 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
181 -- --------------------------------------------------------
184 -- Tabellenstruktur für Tabelle `funcmd`
187 CREATE TABLE IF NOT EXISTS `funcmd` (
188 `id` int(11) NOT NULL AUTO_INCREMENT,
189 `lang` int(11) NOT NULL,
190 `cmd` varchar(50) NOT NULL,
191 `text` text NOT NULL,
193 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='neonserv v3';
195 -- --------------------------------------------------------
198 -- Tabellenstruktur für Tabelle `fundata`
201 CREATE TABLE IF NOT EXISTS `fundata` (
202 `id` int(11) NOT NULL AUTO_INCREMENT,
203 `cid` int(11) NOT NULL,
204 `uid` int(11) NOT NULL,
205 `name` varchar(50) NOT NULL,
206 `value` text NOT NULL,
208 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='neonserv v3';
210 -- --------------------------------------------------------
213 -- Tabellenstruktur für Tabelle `godlog`
216 CREATE TABLE IF NOT EXISTS `godlog` (
217 `godlog_id` int(11) NOT NULL AUTO_INCREMENT,
218 `godlog_uid` int(11) NOT NULL,
219 `godlog_cid` int(15) NOT NULL,
220 `godlog_time` int(15) NOT NULL,
221 `godlog_cmd` varchar(512) NOT NULL,
222 PRIMARY KEY (`godlog_id`)
223 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
225 -- --------------------------------------------------------
228 -- Tabellenstruktur für Tabelle `help`
231 CREATE TABLE IF NOT EXISTS `help` (
232 `id` int(11) NOT NULL AUTO_INCREMENT,
233 `lang` varchar(6) NOT NULL,
234 `ident` varchar(64) NOT NULL,
235 `text` text NOT NULL,
237 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
239 -- --------------------------------------------------------
242 -- Tabellenstruktur für Tabelle `language`
245 CREATE TABLE IF NOT EXISTS `language` (
246 `id` int(11) NOT NULL AUTO_INCREMENT,
247 `lang` varchar(5) NOT NULL,
248 `ident` varchar(64) NOT NULL,
249 `text` varchar(256) NOT NULL,
251 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
253 -- --------------------------------------------------------
256 -- Tabellenstruktur für Tabelle `noinvite`
259 CREATE TABLE IF NOT EXISTS `noinvite` (
260 `id` int(11) NOT NULL AUTO_INCREMENT,
261 `cid` int(11) NOT NULL,
262 `uid` int(11) NOT NULL,
264 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
266 -- --------------------------------------------------------
269 -- Tabellenstruktur für Tabelle `owner_history`
272 CREATE TABLE IF NOT EXISTS `owner_history` (
273 `owner_history_id` int(11) NOT NULL AUTO_INCREMENT,
274 `owner_history_cid` int(11) NOT NULL,
275 `owner_history_uid` int(11) NOT NULL,
276 `owner_history_time` int(11) NOT NULL,
277 PRIMARY KEY (`owner_history_id`),
278 KEY `owner_history_cid` (`owner_history_cid`)
279 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
281 -- --------------------------------------------------------
284 -- Tabellenstruktur für Tabelle `users`
287 CREATE TABLE IF NOT EXISTS `users` (
288 `user_id` int(11) NOT NULL AUTO_INCREMENT,
289 `user_user` varchar(250) NOT NULL,
290 `user_access` int(4) NOT NULL,
291 `user_rank` int(11) NOT NULL,
292 `user_god` tinyint(1) NOT NULL,
293 `user_lang` varchar(6) NOT NULL,
294 `user_reply_privmsg` tinyint(1) NOT NULL,
295 PRIMARY KEY (`user_id`),
296 UNIQUE KEY `user_user` (`user_user`)
297 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
299 -- --------------------------------------------------------
302 -- Tabellenstruktur für Tabelle `support_ranks`
305 CREATE TABLE `support_ranks` (
306 `rank_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
307 `rank_name` VARCHAR( 256 ) NOT NULL ,
308 `rank_access` INT( 4 ) NOT NULL ,
309 `rank_info` VARCHAR( 512 ) NOT NULL ,
310 `rank_order` SMALLINT( 4 ) NOT NULL
313 -- --------------------------------------------------------
316 -- Tabellenstruktur für Tabelle `version`
319 CREATE TABLE IF NOT EXISTS `version` (
320 `database_version` int(5) NOT NULL,
321 PRIMARY KEY (`database_version`)
322 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;