· 7 years ago · Oct 13, 2018, 08:12 AM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8 */;
8
9
10CREATE TABLE IF NOT EXISTS `account_extras` (
11 `id` int(11) NOT NULL AUTO_INCREMENT,
12 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
13 `field0` int(5) DEFAULT NULL,
14 `field1` int(5) DEFAULT NULL,
15 `field2` int(5) DEFAULT NULL,
16 `field3` int(5) DEFAULT NULL,
17 `field4` int(5) DEFAULT NULL,
18 `field5` int(5) DEFAULT NULL,
19 `field6` int(5) DEFAULT NULL,
20 `field7` int(5) DEFAULT NULL,
21 `field8` int(5) DEFAULT NULL,
22 `field9` int(5) DEFAULT NULL,
23 `field10` int(5) DEFAULT NULL,
24 `field11` int(5) DEFAULT NULL,
25 `field12` int(5) DEFAULT NULL,
26 `field13` int(5) DEFAULT NULL,
27 `field14` int(5) DEFAULT NULL,
28 `field15` int(5) DEFAULT NULL,
29 `field16` int(5) DEFAULT NULL,
30 `field17` int(5) DEFAULT NULL,
31 `field18` int(5) DEFAULT NULL,
32 `field19` int(5) DEFAULT NULL,
33 `field20` int(5) DEFAULT NULL,
34 `field21` int(5) DEFAULT NULL,
35 `field22` int(5) DEFAULT NULL,
36 `field23` int(5) DEFAULT NULL,
37 `field24` int(5) DEFAULT NULL,
38 `field25` int(5) DEFAULT NULL,
39 `field26` int(5) DEFAULT NULL,
40 `field27` int(5) DEFAULT NULL,
41 `field28` int(5) DEFAULT NULL,
42 `field29` int(5) DEFAULT NULL,
43 PRIMARY KEY (`id`),
44 KEY `index Username` (`username`)
45) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1285604 ;
46
47CREATE TABLE IF NOT EXISTS `bank` (
48 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
49 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
50 `slot` int(3) DEFAULT NULL,
51 `item` int(5) DEFAULT NULL,
52 `amount` int(5) DEFAULT NULL,
53 PRIMARY KEY (`id`),
54 UNIQUE KEY `username_and_slot` (`username`,`slot`),
55 KEY `username` (`username`),
56 KEY `slot` (`slot`)
57) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=74183859 ;
58
59CREATE TABLE IF NOT EXISTS `bans` (
60 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
61 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
62 `bannedBy` varchar(13) CHARACTER SET ucs2 DEFAULT NULL,
63 `unbanDate` int(8) DEFAULT NULL,
64 `reason` varchar(255) CHARACTER SET ucs2 DEFAULT NULL,
65 PRIMARY KEY (`id`),
66 KEY `username` (`username`)
67) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=26459 ;
68
69CREATE TABLE IF NOT EXISTS `character` (
70 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
71 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
72 `password` varchar(64) CHARACTER SET ucs2 NOT NULL DEFAULT '',
73 `email` varchar(70) CHARACTER SET ucs2 DEFAULT NULL,
74 `firstconnect` varchar(70) CHARACTER SET ucs2 DEFAULT NULL,
75 `height` int(1) DEFAULT NULL,
76 `X` int(5) DEFAULT NULL,
77 `Y` int(5) DEFAULT NULL,
78 `rights` int(1) DEFAULT NULL,
79 `member` int(1) DEFAULT NULL,
80 `lastconnect` varchar(70) CHARACTER SET ucs2 DEFAULT NULL,
81 `lastlogin` int(8) DEFAULT NULL,
82 `energy` int(3) DEFAULT NULL,
83 `ancients` int(1) DEFAULT NULL,
84 `TBT` int(1) DEFAULT NULL,
85 `BT` int(2) DEFAULT NULL,
86 `D` int(1) DEFAULT NULL,
87 `G` int(1) DEFAULT NULL,
88 `V` int(1) DEFAULT NULL,
89 `T` int(1) DEFAULT NULL,
90 `K` int(1) DEFAULT NULL,
91 `A` int(1) DEFAULT NULL,
92 `music` int(1) DEFAULT NULL,
93 `sound` int(1) DEFAULT NULL,
94 `brightness` int(1) DEFAULT NULL,
95 `blackmarks` int(3) DEFAULT NULL,
96 `mutedate` int(8) DEFAULT NULL,
97 `tutorial` int(2) DEFAULT NULL,
98 `lasths` int(8) DEFAULT NULL,
99 `specbar` int(3) DEFAULT NULL,
100 `specupd` int(6) DEFAULT NULL,
101 `look0` int(2) DEFAULT NULL,
102 `look1` int(2) DEFAULT NULL,
103 `look2` int(2) DEFAULT NULL,
104 `look3` int(2) DEFAULT NULL,
105 `look4` int(2) DEFAULT NULL,
106 `look5` int(2) DEFAULT NULL,
107 `head` int(2) DEFAULT NULL,
108 `torso` int(2) DEFAULT NULL,
109 `arms` int(2) DEFAULT NULL,
110 `hands` int(2) DEFAULT NULL,
111 `legs` int(2) DEFAULT NULL,
112 `feet` int(2) DEFAULT NULL,
113 `beard` int(2) DEFAULT NULL,
114 PRIMARY KEY (`id`),
115 KEY `username` (`username`)
116) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1086109 ;
117
118CREATE TABLE IF NOT EXISTS `clanChannel` (
119 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
120 `owner` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
121 `name` varchar(20) CHARACTER SET ucs2 NOT NULL DEFAULT '',
122 `locked` tinyint(1) NOT NULL DEFAULT '0',
123 PRIMARY KEY (`id`),
124 KEY `name` (`name`)
125) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9074 ;
126
127CREATE TABLE IF NOT EXISTS `donation` (
128 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
129 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
130 `time` int(10) unsigned NOT NULL,
131 `completed` tinyint(1) unsigned NOT NULL,
132 PRIMARY KEY (`id`),
133 KEY `Index_2` (`username`),
134 KEY `index_3` (`completed`)
135) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=570 ;
136
137CREATE TABLE IF NOT EXISTS `donationLog` (
138 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
139 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
140 `first_name` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
141 `last_name` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
142 `email` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
143 `transaction_id` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
144 `amount` varchar(8) CHARACTER SET latin1 DEFAULT NULL,
145 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
146 PRIMARY KEY (`id`),
147 KEY `username` (`username`),
148 KEY `transaction_id` (`transaction_id`)
149) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3026 ;
150
151CREATE TABLE IF NOT EXISTS `equipment` (
152 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
153 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
154 `slot` int(3) DEFAULT NULL,
155 `item` int(5) DEFAULT NULL,
156 `amount` int(5) DEFAULT NULL,
157 PRIMARY KEY (`id`),
158 UNIQUE KEY `username_and_slot` (`username`,`slot`),
159 KEY `username` (`username`),
160 KEY `slot` (`slot`)
161) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=18286420 ;
162
163CREATE TABLE IF NOT EXISTS `friend` (
164 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
165 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
166 `slot` int(3) DEFAULT NULL,
167 `person` bigint(50) DEFAULT NULL,
168 PRIMARY KEY (`id`),
169 UNIQUE KEY `username_and_slot` (`username`,`slot`),
170 KEY `username` (`username`),
171 KEY `slot` (`slot`)
172) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4295299 ;
173
174CREATE TABLE IF NOT EXISTS `highscores` (
175 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
176 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
177 `skill` int(10) unsigned NOT NULL,
178 `level` int(10) unsigned NOT NULL,
179 `exp` bigint(16) unsigned NOT NULL,
180 PRIMARY KEY (`id`),
181 UNIQUE KEY `username_and_slot` (`username`,`skill`),
182 KEY `idxUsername` (`username`),
183 KEY `idxSkill` (`skill`),
184 KEY `idxSkillExp` (`skill`,`exp`)
185) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=28614526 ;
186
187CREATE TABLE IF NOT EXISTS `ignore` (
188 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
189 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
190 `slot` int(3) DEFAULT NULL,
191 `person` bigint(50) DEFAULT NULL,
192 PRIMARY KEY (`id`),
193 UNIQUE KEY `username_and_slot` (`username`,`slot`),
194 KEY `username` (`username`),
195 KEY `slot` (`slot`)
196) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=62094 ;
197
198CREATE TABLE IF NOT EXISTS `inventory` (
199 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
200 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
201 `slot` int(3) DEFAULT NULL,
202 `item` int(5) DEFAULT NULL,
203 `amount` int(5) DEFAULT NULL,
204 PRIMARY KEY (`id`),
205 UNIQUE KEY `username_and_slot` (`username`,`slot`),
206 KEY `username` (`username`),
207 KEY `slot` (`slot`)
208) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=101965344 ;
209
210CREATE TABLE IF NOT EXISTS `ip_logs` (
211 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
212 `ip` varchar(19) CHARACTER SET latin1 NOT NULL DEFAULT '',
213 UNIQUE KEY `username_ip` (`username`,`ip`),
214 KEY `username` (`username`),
215 KEY `ip` (`ip`)
216) ENGINE=InnoDB DEFAULT CHARSET=utf8;
217
218CREATE TABLE IF NOT EXISTS `itemHealth` (
219 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
220 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
221 `item` int(5) DEFAULT NULL,
222 `health` int(3) DEFAULT NULL,
223 PRIMARY KEY (`id`),
224 KEY `username` (`username`),
225 KEY `item` (`item`)
226) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=766415 ;
227
228CREATE TABLE IF NOT EXISTS `item_info` (
229 `pid` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
230 `name` varchar(50) CHARACTER SET ucs2 NOT NULL DEFAULT '',
231 `id` int(5) DEFAULT NULL,
232 PRIMARY KEY (`pid`),
233 KEY `id` (`id`)
234) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7759 ;
235
236CREATE TABLE IF NOT EXISTS `logs_chat` (
237 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
238 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
239 `data` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
240 `x` smallint(5) DEFAULT NULL,
241 `y` smallint(5) DEFAULT NULL,
242 `height` tinyint(1) DEFAULT NULL,
243 `date` int(10) DEFAULT NULL,
244 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
245 PRIMARY KEY (`id`),
246 KEY `username` (`username`),
247 KEY `date` (`date`)
248) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=304061475 ;
249
250CREATE TABLE IF NOT EXISTS `logs_c_chat` (
251 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
252 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
253 `clan` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
254 `data` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
255 `x` smallint(5) DEFAULT NULL,
256 `y` smallint(5) DEFAULT NULL,
257 `height` tinyint(1) DEFAULT NULL,
258 `date` int(10) DEFAULT NULL,
259 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
260 PRIMARY KEY (`id`),
261 KEY `username` (`username`),
262 KEY `clan` (`clan`),
263 KEY `date` (`date`)
264) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1248497 ;
265
266CREATE TABLE IF NOT EXISTS `logs_pickup_drop` (
267 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
268 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
269 `item` smallint(5) DEFAULT NULL,
270 `amount` int(10) DEFAULT NULL,
271 `x` smallint(5) DEFAULT NULL,
272 `y` smallint(5) DEFAULT NULL,
273 `height` tinyint(1) DEFAULT NULL,
274 `isDrop` tinyint(1) DEFAULT NULL,
275 `date` int(10) DEFAULT NULL,
276 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
277 PRIMARY KEY (`id`),
278 KEY `username` (`username`),
279 KEY `date` (`date`),
280 KEY `position` (`x`,`y`,`height`)
281) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=72029040 ;
282
283CREATE TABLE IF NOT EXISTS `logs_p_chat` (
284 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
285 `from` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
286 `to` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
287 `data` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
288 `x` smallint(5) DEFAULT NULL,
289 `y` smallint(5) DEFAULT NULL,
290 `height` tinyint(1) DEFAULT NULL,
291 `date` int(10) DEFAULT NULL,
292 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
293 PRIMARY KEY (`id`),
294 KEY `from` (`from`),
295 KEY `to` (`to`),
296 KEY `date` (`date`)
297) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17041020 ;
298
299CREATE TABLE IF NOT EXISTS `logs_stake` (
300 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
301 `from` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
302 `to` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
303 `item` smallint(5) DEFAULT NULL,
304 `amount` int(10) DEFAULT NULL,
305 `date` int(10) DEFAULT NULL,
306 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
307 PRIMARY KEY (`id`),
308 KEY `from` (`from`),
309 KEY `to` (`to`),
310 KEY `date` (`date`)
311) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=914398 ;
312
313CREATE TABLE IF NOT EXISTS `logs_trade` (
314 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
315 `from` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
316 `to` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
317 `item` smallint(5) DEFAULT NULL,
318 `amount` int(10) DEFAULT NULL,
319 `x` smallint(5) DEFAULT NULL,
320 `y` smallint(5) DEFAULT NULL,
321 `height` tinyint(1) DEFAULT NULL,
322 `date` int(10) DEFAULT NULL,
323 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
324 PRIMARY KEY (`id`),
325 KEY `from` (`from`),
326 KEY `to` (`to`),
327 KEY `date` (`date`)
328) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12395218 ;
329
330CREATE TABLE IF NOT EXISTS `mail_keys` (
331 `confirm_code` varchar(65) CHARACTER SET latin1 NOT NULL DEFAULT '',
332 `name` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
333 `email` varchar(65) CHARACTER SET latin1 NOT NULL DEFAULT '',
334 UNIQUE KEY `name unique` (`name`),
335 KEY `confirm_code` (`confirm_code`)
336) ENGINE=InnoDB DEFAULT CHARSET=utf8;
337
338CREATE TABLE IF NOT EXISTS `mail_reset_keys` (
339 `confirm_code` varchar(65) CHARACTER SET latin1 NOT NULL DEFAULT '',
340 `name` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
341 UNIQUE KEY `name unique` (`name`),
342 KEY `confirm_code` (`confirm_code`)
343) ENGINE=InnoDB DEFAULT CHARSET=utf8;
344
345CREATE TABLE IF NOT EXISTS `news` (
346 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
347 `author` varchar(12) CHARACTER SET latin1 NOT NULL,
348 `timestamp` int(10) unsigned NOT NULL,
349 `title` varchar(255) CHARACTER SET latin1 NOT NULL,
350 `text` text CHARACTER SET latin1 NOT NULL,
351 PRIMARY KEY (`id`)
352) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
353
354CREATE TABLE IF NOT EXISTS `patches` (
355 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
356 `username` varchar(13) CHARACTER SET ucs2 NOT NULL,
357 `patch` int(11) NOT NULL,
358 `type` int(11) NOT NULL,
359 `age` int(11) NOT NULL,
360 `timelastupdated` bigint(20) NOT NULL,
361 `needs` tinyint(4) NOT NULL,
362 PRIMARY KEY (`id`),
363 UNIQUE KEY `idx_username_patch` (`username`,`patch`)
364) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=976380 ;
365
366CREATE TABLE IF NOT EXISTS `posts` (
367 `id` int(11) NOT NULL AUTO_INCREMENT,
368 `player_id` int(11) DEFAULT NULL,
369 `title` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
370 `excerpt` text CHARACTER SET latin1,
371 `text` text CHARACTER SET latin1,
372 `created_at` datetime NOT NULL,
373 `updated_at` datetime NOT NULL,
374 PRIMARY KEY (`id`)
375) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
376
377CREATE TABLE IF NOT EXISTS `punishment` (
378 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
379 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
380 `date` int(8) DEFAULT NULL,
381 `note` varchar(255) CHARACTER SET ucs2 DEFAULT NULL,
382 PRIMARY KEY (`id`),
383 KEY `username` (`username`)
384) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12628 ;
385
386CREATE TABLE IF NOT EXISTS `reset_requests` (
387 `id` int(11) NOT NULL AUTO_INCREMENT,
388 `user` varchar(13) CHARACTER SET latin1 NOT NULL,
389 `mod` varchar(13) CHARACTER SET latin1 NOT NULL,
390 `request_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
391 `s0` int(9) NOT NULL,
392 `s1` int(9) NOT NULL,
393 `s2` int(9) NOT NULL,
394 `s3` int(9) NOT NULL,
395 `s4` int(9) NOT NULL,
396 `s5` int(9) NOT NULL,
397 `s6` int(9) NOT NULL,
398 `s7` int(9) NOT NULL,
399 `s8` int(9) NOT NULL,
400 `s9` int(9) NOT NULL,
401 `s10` int(9) NOT NULL,
402 `s11` int(9) NOT NULL,
403 `s12` int(9) NOT NULL,
404 `s13` int(9) NOT NULL,
405 `s14` int(9) NOT NULL,
406 `s15` int(9) NOT NULL,
407 `s16` int(9) NOT NULL,
408 `s17` int(9) NOT NULL,
409 `s18` int(9) NOT NULL,
410 `s19` int(9) NOT NULL,
411 `s20` int(9) NOT NULL,
412 `approved` int(11) NOT NULL,
413 `verified` varchar(13) CHARACTER SET latin1 NOT NULL,
414 PRIMARY KEY (`id`)
415) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=349 ;
416
417CREATE TABLE IF NOT EXISTS `schema_migrations` (
418 `version` varchar(255) CHARACTER SET latin1 NOT NULL
419) ENGINE=InnoDB DEFAULT CHARSET=utf8;
420
421CREATE TABLE IF NOT EXISTS `skill` (
422 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
423 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
424 `skill` int(2) DEFAULT NULL,
425 `lvl` int(3) DEFAULT NULL,
426 `xp` int(9) DEFAULT NULL,
427 PRIMARY KEY (`id`),
428 UNIQUE KEY `username_and_skill` (`username`,`skill`),
429 KEY `username` (`username`),
430 KEY `skill` (`skill`)
431) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=146125928 ;
432
433CREATE TABLE IF NOT EXISTS `unbans` (
434 `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
435 `bannedBy` varchar(13) CHARACTER SET latin1 NOT NULL COMMENT 'person who banned the user',
436 `bannedUser` varchar(13) CHARACTER SET latin1 NOT NULL COMMENT 'banee''s name',
437 `unbannedBy` varchar(13) CHARACTER SET latin1 NOT NULL COMMENT 'person who unbanned the user',
438 `banReason` varchar(255) CHARACTER SET latin1 NOT NULL COMMENT 'the original ban reason',
439 `unbanDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'time and date of the unban',
440 PRIMARY KEY (`id`)
441) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3118 ;
442
443CREATE TABLE IF NOT EXISTS `uuid_bans` (
444 `id` int(11) NOT NULL AUTO_INCREMENT,
445 `uuid` varchar(36) CHARACTER SET latin1 NOT NULL,
446 `banned_by` varchar(13) CHARACTER SET latin1 NOT NULL,
447 `reason` varchar(256) CHARACTER SET latin1 NOT NULL,
448 PRIMARY KEY (`id`),
449 UNIQUE KEY `uuid` (`uuid`),
450 KEY `banned_by` (`banned_by`)
451) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;
452
453CREATE TABLE IF NOT EXISTS `uuid_log` (
454 `id` int(11) NOT NULL AUTO_INCREMENT,
455 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
456 `uuid` varchar(36) CHARACTER SET latin1 NOT NULL,
457 `ip` varchar(16) CHARACTER SET latin1 NOT NULL,
458 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
459 PRIMARY KEY (`id`),
460 KEY `username` (`username`),
461 KEY `uuid` (`uuid`),
462 KEY `ip` (`ip`),
463 KEY `timestamp` (`timestamp`)
464) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3456356 ;
465
466CREATE TABLE IF NOT EXISTS `emps`.`hwid_log` (
467 `id` int(11) NOT NULL AUTO_INCREMENT,
468 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
469 `hwid` varchar(32) CHARACTER SET latin1 NOT NULL,
470 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
471 PRIMARY KEY (`id`)
472) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=96372 ;
473
474CREATE TABLE IF NOT EXISTS `emps`.`hwid_bans` (
475 `id` int(11) NOT NULL AUTO_INCREMENT,
476 `hwid` varchar(32) NOT NULL,
477 `banned_by` varchar(13) NOT NULL,
478 `reason` varchar(128) NOT NULL,
479 PRIMARY KEY (`id`)
480) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
481
482/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
483/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
484/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;