· 7 years ago · Oct 13, 2018, 08:18 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Erstellungszeit: 25. Okt 2015 um 20:23
7-- Server Version: 5.5.41-0ubuntu0.14.04.1
8-- PHP-Version: 5.5.9-1ubuntu4.7
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Datenbank: `emps`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabellenstruktur für Tabelle `bans`
27--
28
29CREATE TABLE IF NOT EXISTS `bans` (
30 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
31 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
32 `bannedBy` varchar(13) CHARACTER SET ucs2 DEFAULT NULL,
33 `unbanDate` int(8) DEFAULT NULL,
34 `reason` varchar(255) CHARACTER SET ucs2 DEFAULT NULL,
35 PRIMARY KEY (`id`),
36 KEY `username` (`username`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3194 ;
38
39-- --------------------------------------------------------
40
41--
42-- Tabellenstruktur für Tabelle `clanchannel`
43--
44
45CREATE TABLE IF NOT EXISTS `clanchannel` (
46 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
47 `owner` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
48 `name` varchar(20) CHARACTER SET ucs2 NOT NULL DEFAULT '',
49 `locked` tinyint(1) NOT NULL DEFAULT '0',
50 PRIMARY KEY (`id`),
51 KEY `name` (`name`)
52) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1996 ;
53
54-- --------------------------------------------------------
55
56--
57-- Tabellenstruktur für Tabelle `donation`
58--
59
60CREATE TABLE IF NOT EXISTS `donation` (
61 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
62 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
63 `time` int(10) unsigned NOT NULL DEFAULT '0',
64 `item` int(11) NOT NULL DEFAULT '7478',
65 `completed` int(10) unsigned NOT NULL,
66 `payment_type` tinyint(4) NOT NULL DEFAULT '0',
67 `payment_id` varchar(64) DEFAULT NULL,
68 PRIMARY KEY (`id`),
69 KEY `username_idx` (`username`)
70) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2855 ;
71
72-- --------------------------------------------------------
73
74--
75-- Tabellenstruktur für Tabelle `donationlog`
76--
77
78CREATE TABLE IF NOT EXISTS `donationlog` (
79 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
80 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
81 `first_name` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
82 `last_name` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
83 `email` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
84 `transaction_id` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
85 `amount` varchar(8) CHARACTER SET latin1 DEFAULT NULL,
86 `status` varchar(16) NOT NULL DEFAULT 'Completed',
87 `received` tinyint(2) NOT NULL DEFAULT '0',
88 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
89 PRIMARY KEY (`id`),
90 KEY `username` (`username`),
91 KEY `transaction_id` (`transaction_id`)
92) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7798 ;
93
94-- --------------------------------------------------------
95
96--
97-- Tabellenstruktur für Tabelle `ge_offer`
98--
99
100CREATE TABLE IF NOT EXISTS `ge_offer` (
101 `player_id` bigint(20) NOT NULL,
102 `slot` tinyint(4) NOT NULL,
103 `item` int(11) NOT NULL,
104 `amount_total` int(11) NOT NULL,
105 `amount_available` int(11) NOT NULL,
106 `amount_transferred` int(11) NOT NULL,
107 `price_total` int(11) NOT NULL,
108 `price_available` int(11) NOT NULL,
109 `price_transferred` int(11) NOT NULL,
110 `type` tinyint(4) NOT NULL,
111 `modifications` int(11) NOT NULL,
112 `creation` datetime NOT NULL,
113 PRIMARY KEY (`player_id`,`slot`)
114) ENGINE=InnoDB DEFAULT CHARSET=utf8;
115
116-- --------------------------------------------------------
117
118--
119-- Tabellenstruktur für Tabelle `highscores`
120--
121
122CREATE TABLE IF NOT EXISTS `highscores` (
123 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
124 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
125 `skill` int(3) unsigned NOT NULL,
126 `level` int(3) unsigned NOT NULL,
127 `exp` bigint(20) NOT NULL,
128 PRIMARY KEY (`id`),
129 UNIQUE KEY `UNIQUE_UserAndSkill` (`username`,`skill`),
130 KEY `idxSkill` (`skill`),
131 KEY `idxSkillExp` (`skill`,`exp`)
132) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9552576 ;
133
134-- --------------------------------------------------------
135
136--
137-- Tabellenstruktur für Tabelle `hwid_bans`
138--
139
140CREATE TABLE IF NOT EXISTS `hwid_bans` (
141 `id` int(11) NOT NULL AUTO_INCREMENT,
142 `hwid` varchar(32) NOT NULL,
143 `banned_by` varchar(13) NOT NULL,
144 `reason` varchar(128) NOT NULL,
145 PRIMARY KEY (`id`)
146) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
147
148-- --------------------------------------------------------
149
150--
151-- Tabellenstruktur für Tabelle `hwid_log`
152--
153
154CREATE TABLE IF NOT EXISTS `hwid_log` (
155 `id` int(11) NOT NULL AUTO_INCREMENT,
156 `player_id` int(10) unsigned NOT NULL,
157 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
158 `hwid` varchar(32) CHARACTER SET latin1 NOT NULL,
159 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
160 PRIMARY KEY (`id`),
161 KEY `pid` (`player_id`)
162) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1075980 ;
163
164-- --------------------------------------------------------
165
166--
167-- Tabellenstruktur für Tabelle `ip_logs`
168--
169
170CREATE TABLE IF NOT EXISTS `ip_logs` (
171 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
172 `ip` varchar(19) CHARACTER SET latin1 NOT NULL DEFAULT '',
173 UNIQUE KEY `username_ip` (`username`,`ip`),
174 KEY `username` (`username`),
175 KEY `ip` (`ip`)
176) ENGINE=InnoDB DEFAULT CHARSET=utf8;
177
178-- --------------------------------------------------------
179
180--
181-- Tabellenstruktur für Tabelle `item_names`
182--
183
184CREATE TABLE IF NOT EXISTS `item_names` (
185 `id` int(6) NOT NULL,
186 `name` varchar(32) NOT NULL,
187 PRIMARY KEY (`id`)
188) ENGINE=InnoDB DEFAULT CHARSET=latin1;
189
190-- --------------------------------------------------------
191
192--
193-- Tabellenstruktur für Tabelle `logs_chat`
194--
195
196CREATE TABLE IF NOT EXISTS `logs_chat` (
197 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
198 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
199 `data` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
200 `x` smallint(5) DEFAULT NULL,
201 `y` smallint(5) DEFAULT NULL,
202 `height` tinyint(1) DEFAULT NULL,
203 `date` int(10) DEFAULT NULL,
204 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
205 PRIMARY KEY (`id`),
206 KEY `username` (`username`),
207 KEY `date` (`date`),
208 KEY `exact_time` (`exactTime`)
209) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=200936798 ;
210
211-- --------------------------------------------------------
212
213--
214-- Tabellenstruktur für Tabelle `logs_c_chat`
215--
216
217CREATE TABLE IF NOT EXISTS `logs_c_chat` (
218 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
219 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
220 `clan` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
221 `data` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
222 `x` smallint(5) DEFAULT NULL,
223 `y` smallint(5) DEFAULT NULL,
224 `height` tinyint(1) DEFAULT NULL,
225 `date` int(10) DEFAULT NULL,
226 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
227 PRIMARY KEY (`id`),
228 KEY `username` (`username`),
229 KEY `clan` (`clan`),
230 KEY `date` (`date`),
231 KEY `exact_time` (`exactTime`)
232) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3492541 ;
233
234-- --------------------------------------------------------
235
236--
237-- Tabellenstruktur für Tabelle `logs_ge`
238--
239
240CREATE TABLE IF NOT EXISTS `logs_ge` (
241 `id` bigint(20) NOT NULL AUTO_INCREMENT,
242 `from` varchar(13) NOT NULL,
243 `to` varchar(13) NOT NULL,
244 `item` int(11) NOT NULL,
245 `amount` int(11) NOT NULL,
246 `price` int(11) NOT NULL,
247 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
248 PRIMARY KEY (`id`),
249 KEY `user_to` (`to`),
250 KEY `user_from` (`from`)
251) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
252
253-- --------------------------------------------------------
254
255--
256-- Tabellenstruktur für Tabelle `logs_pickup_drop`
257--
258
259CREATE TABLE IF NOT EXISTS `logs_pickup_drop` (
260 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
261 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
262 `item` smallint(5) DEFAULT NULL,
263 `amount` int(10) DEFAULT NULL,
264 `x` smallint(5) DEFAULT NULL,
265 `y` smallint(5) DEFAULT NULL,
266 `height` tinyint(1) DEFAULT NULL,
267 `isDrop` tinyint(1) DEFAULT NULL,
268 `date` int(10) DEFAULT NULL,
269 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
270 PRIMARY KEY (`id`),
271 KEY `username` (`username`),
272 KEY `date` (`date`),
273 KEY `position` (`x`,`y`,`height`),
274 KEY `exact_time` (`exactTime`)
275) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=66747953 ;
276
277-- --------------------------------------------------------
278
279--
280-- Tabellenstruktur für Tabelle `logs_p_chat`
281--
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 KEY `exact_time` (`exactTime`)
298) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14338347 ;
299
300-- --------------------------------------------------------
301
302--
303-- Tabellenstruktur für Tabelle `logs_stake`
304--
305
306CREATE TABLE IF NOT EXISTS `logs_stake` (
307 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
308 `from` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
309 `to` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
310 `item` smallint(5) DEFAULT NULL,
311 `amount` int(10) DEFAULT NULL,
312 `date` int(10) DEFAULT NULL,
313 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
314 PRIMARY KEY (`id`),
315 KEY `from` (`from`),
316 KEY `to` (`to`),
317 KEY `date` (`date`),
318 KEY `exact_time` (`exactTime`)
319) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2192509 ;
320
321-- --------------------------------------------------------
322
323--
324-- Tabellenstruktur für Tabelle `logs_trade`
325--
326
327CREATE TABLE IF NOT EXISTS `logs_trade` (
328 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
329 `from` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
330 `to` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
331 `item` smallint(5) DEFAULT NULL,
332 `amount` int(10) DEFAULT NULL,
333 `x` smallint(5) DEFAULT NULL,
334 `y` smallint(5) DEFAULT NULL,
335 `height` tinyint(1) DEFAULT NULL,
336 `date` int(10) DEFAULT NULL,
337 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
338 PRIMARY KEY (`id`),
339 KEY `from` (`from`),
340 KEY `to` (`to`),
341 KEY `date` (`date`),
342 KEY `exact_time` (`exactTime`)
343) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6874586 ;
344
345-- --------------------------------------------------------
346
347--
348-- Tabellenstruktur für Tabelle `mail_keys`
349--
350
351CREATE TABLE IF NOT EXISTS `mail_keys` (
352 `id` int(11) NOT NULL AUTO_INCREMENT,
353 `code` varchar(65) CHARACTER SET latin1 NOT NULL DEFAULT '',
354 `data` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
355 `email` varchar(65) CHARACTER SET latin1 NOT NULL DEFAULT '',
356 `type` tinyint(1) NOT NULL,
357 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
358 PRIMARY KEY (`id`),
359 UNIQUE KEY `unique` (`type`,`data`)
360) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=80516 ;
361
362-- --------------------------------------------------------
363
364--
365-- Tabellenstruktur für Tabelle `news`
366--
367
368CREATE TABLE IF NOT EXISTS `news` (
369 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
370 `author` varchar(12) CHARACTER SET latin1 NOT NULL,
371 `timestamp` int(10) unsigned NOT NULL,
372 `title` varchar(255) CHARACTER SET latin1 NOT NULL,
373 `text` text CHARACTER SET latin1 NOT NULL,
374 PRIMARY KEY (`id`)
375) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
376
377-- --------------------------------------------------------
378
379--
380-- Tabellenstruktur für Tabelle `players`
381--
382
383CREATE TABLE IF NOT EXISTS `players` (
384 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
385 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
386 `password` varchar(255) CHARACTER SET ucs2 NOT NULL DEFAULT '',
387 `password_salt` varchar(64) DEFAULT NULL,
388 `hash_func` varchar(8) NOT NULL,
389 `email` varchar(70) CHARACTER SET ucs2 DEFAULT NULL,
390 `height` smallint(6) DEFAULT NULL,
391 `X` int(5) DEFAULT NULL,
392 `Y` int(5) DEFAULT NULL,
393 `rights` tinyint(1) DEFAULT NULL,
394 `member` tinyint(3) DEFAULT NULL,
395 `lastconnect` varchar(70) CHARACTER SET ucs2 DEFAULT NULL,
396 `lastlogin` int(8) DEFAULT NULL,
397 `energy` smallint(6) DEFAULT NULL,
398 `ancients` tinyint(1) DEFAULT NULL,
399 `TBT` int(10) DEFAULT NULL,
400 `BT` int(20) DEFAULT NULL,
401 `D` tinyint(1) DEFAULT NULL,
402 `G` tinyint(1) DEFAULT NULL,
403 `V` tinyint(1) DEFAULT NULL,
404 `T` tinyint(1) DEFAULT NULL,
405 `K` tinyint(1) DEFAULT NULL,
406 `A` tinyint(1) DEFAULT NULL,
407 `music` tinyint(1) DEFAULT NULL,
408 `sound` tinyint(1) DEFAULT NULL,
409 `brightness` tinyint(1) DEFAULT NULL,
410 `blackmarks` tinyint(3) DEFAULT NULL,
411 `mutedate` int(8) DEFAULT NULL,
412 `tutorial` tinyint(3) DEFAULT NULL,
413 `lasths` int(8) DEFAULT NULL,
414 `specbar` smallint(5) DEFAULT NULL,
415 `specupd` int(6) DEFAULT NULL,
416 `look0` int(9) DEFAULT NULL,
417 `look1` int(9) DEFAULT NULL,
418 `look2` int(9) DEFAULT NULL,
419 `look3` int(9) DEFAULT NULL,
420 `look4` int(9) DEFAULT NULL,
421 `look5` int(9) DEFAULT NULL,
422 `head` int(9) DEFAULT NULL,
423 `torso` int(9) DEFAULT NULL,
424 `arms` int(9) DEFAULT NULL,
425 `hands` int(9) DEFAULT NULL,
426 `legs` int(9) DEFAULT NULL,
427 `feet` int(9) DEFAULT NULL,
428 `beard` int(9) DEFAULT NULL,
429 `eventManager` tinyint(1) NOT NULL DEFAULT '0',
430 `lastlogin_dt` datetime NOT NULL,
431 `online_time_ms` bigint(20) NOT NULL DEFAULT '0',
432 `is_online` tinyint(4) NOT NULL DEFAULT '0',
433 `creationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
434 `donation_points` int(11) NOT NULL DEFAULT '0',
435 `donation_points_total` int(11) NOT NULL DEFAULT '0',
436 PRIMARY KEY (`id`),
437 KEY `username` (`username`)
438) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1266446 ;
439
440-- --------------------------------------------------------
441
442--
443-- Tabellenstruktur für Tabelle `players_config`
444--
445
446CREATE TABLE IF NOT EXISTS `players_config` (
447 `id` int(11) NOT NULL AUTO_INCREMENT,
448 `player_id` int(10) unsigned DEFAULT NULL,
449 `field0` int(5) DEFAULT '100',
450 `field1` int(5) DEFAULT NULL,
451 `field2` int(5) DEFAULT NULL,
452 `field3` int(5) DEFAULT NULL,
453 `field4` int(5) DEFAULT NULL,
454 `field5` int(5) DEFAULT NULL,
455 `field6` int(5) DEFAULT NULL,
456 `field7` int(5) DEFAULT NULL,
457 `field8` int(5) DEFAULT NULL,
458 `field9` int(5) DEFAULT NULL,
459 `field10` int(5) DEFAULT NULL,
460 `field11` int(5) DEFAULT NULL,
461 `field12` int(5) DEFAULT NULL,
462 `field13` int(5) DEFAULT NULL,
463 `field14` int(5) DEFAULT NULL,
464 `field15` int(5) DEFAULT NULL,
465 `field16` int(5) DEFAULT NULL,
466 `field17` int(5) DEFAULT NULL,
467 `field18` int(5) DEFAULT NULL,
468 `field19` int(5) DEFAULT NULL,
469 `field20` int(5) DEFAULT NULL,
470 `field21` int(5) DEFAULT NULL,
471 `field22` int(5) DEFAULT NULL,
472 `field23` int(5) DEFAULT NULL,
473 `field24` int(5) DEFAULT NULL,
474 `field25` int(5) DEFAULT NULL,
475 `field26` int(5) DEFAULT NULL,
476 `field27` int(5) DEFAULT NULL,
477 `field28` int(5) DEFAULT NULL,
478 `field29` int(5) DEFAULT NULL,
479 `slayerPoints` int(11) NOT NULL DEFAULT '0',
480 `prayers` int(10) NOT NULL DEFAULT '0',
481 `last_cc` varchar(13) NOT NULL DEFAULT '',
482 `guardian_angel` tinyint(3) NOT NULL DEFAULT '0',
483 `dfs_charges` tinyint(2) NOT NULL DEFAULT '0',
484 `antifire` int(11) NOT NULL DEFAULT '0',
485 PRIMARY KEY (`id`),
486 KEY `pid` (`player_id`)
487) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1269215 ;
488
489-- --------------------------------------------------------
490
491--
492-- Tabellenstruktur für Tabelle `players_construction_objects`
493--
494
495CREATE TABLE IF NOT EXISTS `players_construction_objects` (
496 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
497 `player_id` int(10) NOT NULL,
498 `hotspotid` int(10) unsigned NOT NULL DEFAULT '0',
499 `objectid` int(10) unsigned NOT NULL DEFAULT '0',
500 `username` varchar(45) NOT NULL DEFAULT '',
501 `roomid` int(10) unsigned NOT NULL DEFAULT '0',
502 PRIMARY KEY (`id`),
503 KEY `pid` (`player_id`)
504) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=49165 ;
505
506-- --------------------------------------------------------
507
508--
509-- Tabellenstruktur für Tabelle `players_construction_rooms`
510--
511
512CREATE TABLE IF NOT EXISTS `players_construction_rooms` (
513 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
514 `player_id` int(10) unsigned NOT NULL,
515 `username` varchar(45) NOT NULL DEFAULT '',
516 `roomid` tinyint(8) unsigned NOT NULL DEFAULT '0',
517 `roomrot` tinyint(8) unsigned NOT NULL DEFAULT '0',
518 `x` tinyint(8) unsigned NOT NULL DEFAULT '0',
519 `y` tinyint(8) unsigned NOT NULL DEFAULT '0',
520 `z` tinyint(8) unsigned NOT NULL DEFAULT '0',
521 PRIMARY KEY (`id`),
522 KEY `pid` (`player_id`)
523) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=49145 ;
524
525-- --------------------------------------------------------
526
527--
528-- Tabellenstruktur für Tabelle `players_construction_type`
529--
530
531CREATE TABLE IF NOT EXISTS `players_construction_type` (
532 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
533 `username` varchar(45) NOT NULL DEFAULT '',
534 `type` tinyint(8) unsigned NOT NULL DEFAULT '0',
535 `player_id` int(10) unsigned NOT NULL,
536 PRIMARY KEY (`id`),
537 KEY `pid` (`player_id`)
538) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=49138 ;
539
540-- --------------------------------------------------------
541
542--
543-- Tabellenstruktur für Tabelle `players_friends`
544--
545
546CREATE TABLE IF NOT EXISTS `players_friends` (
547 `primary` int(10) unsigned NOT NULL AUTO_INCREMENT,
548 `player_id` int(10) unsigned NOT NULL,
549 `person_id` bigint(40) NOT NULL,
550 `type` tinyint(5) unsigned NOT NULL,
551 `slot` int(11) NOT NULL,
552 PRIMARY KEY (`primary`),
553 UNIQUE KEY `pid_and_slot` (`slot`,`player_id`,`type`),
554 KEY `pid` (`player_id`),
555 KEY `person_key` (`person_id`)
556) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6846199 ;
557
558-- --------------------------------------------------------
559
560--
561-- Tabellenstruktur für Tabelle `players_items`
562--
563
564CREATE TABLE IF NOT EXISTS `players_items` (
565 `primary` int(10) unsigned NOT NULL AUTO_INCREMENT,
566 `player_id` int(10) unsigned NOT NULL,
567 `item` int(6) NOT NULL,
568 `amount` int(5) unsigned NOT NULL,
569 `slot` int(5) unsigned NOT NULL,
570 `type` tinyint(5) unsigned NOT NULL,
571 PRIMARY KEY (`primary`),
572 UNIQUE KEY `pid_and_slot` (`player_id`,`slot`,`type`),
573 KEY `pid` (`player_id`),
574 KEY `slot` (`slot`),
575 KEY `item` (`item`)
576) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=56482727 ;
577
578-- --------------------------------------------------------
579
580--
581-- Tabellenstruktur für Tabelle `players_item_health`
582--
583
584CREATE TABLE IF NOT EXISTS `players_item_health` (
585 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
586 `player_id` int(10) unsigned DEFAULT NULL,
587 `item` int(5) DEFAULT NULL,
588 `health` int(3) DEFAULT '0',
589 PRIMARY KEY (`id`),
590 UNIQUE KEY `player_id` (`player_id`,`item`),
591 KEY `item` (`item`),
592 KEY `pid` (`player_id`)
593) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12263685 ;
594
595-- --------------------------------------------------------
596
597--
598-- Tabellenstruktur für Tabelle `players_kill_log`
599--
600
601CREATE TABLE IF NOT EXISTS `players_kill_log` (
602 `id` int(11) NOT NULL AUTO_INCREMENT,
603 `player_id` int(11) NOT NULL,
604 `type` tinyint(4) NOT NULL,
605 `monster_hash` bigint(11) NOT NULL,
606 `kills` int(11) NOT NULL,
607 PRIMARY KEY (`id`),
608 UNIQUE KEY `unique_player` (`player_id`,`type`,`monster_hash`),
609 KEY `player_id` (`player_id`)
610) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=413406 ;
611
612-- --------------------------------------------------------
613
614--
615-- Tabellenstruktur für Tabelle `players_patch`
616--
617
618CREATE TABLE IF NOT EXISTS `players_patch` (
619 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
620 `player_id` int(10) NOT NULL,
621 `patch` int(11) NOT NULL,
622 `type` int(11) NOT NULL,
623 `original_type` int(11) DEFAULT '0',
624 `age` int(11) NOT NULL,
625 `timelastupdated` bigint(20) NOT NULL,
626 `needs` tinyint(4) NOT NULL,
627 PRIMARY KEY (`id`),
628 UNIQUE KEY `pid_and_patch` (`patch`,`player_id`) USING BTREE
629) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11590835 ;
630
631-- --------------------------------------------------------
632
633--
634-- Tabellenstruktur für Tabelle `players_skill`
635--
636
637CREATE TABLE IF NOT EXISTS `players_skill` (
638 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
639 `player_id` int(10) unsigned DEFAULT NULL,
640 `skill` tinyint(2) unsigned DEFAULT NULL,
641 `lvl` int(3) DEFAULT NULL,
642 `lvl_cur` int(3) unsigned NOT NULL,
643 `xp` bigint(20) DEFAULT NULL,
644 PRIMARY KEY (`id`),
645 UNIQUE KEY `pid_and_skill` (`player_id`,`skill`),
646 KEY `skill` (`skill`),
647 KEY `pid` (`player_id`)
648) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=166564088 ;
649
650-- --------------------------------------------------------
651
652--
653-- Tabellenstruktur für Tabelle `posts`
654--
655
656CREATE TABLE IF NOT EXISTS `posts` (
657 `id` int(11) NOT NULL AUTO_INCREMENT,
658 `player_id` int(11) DEFAULT NULL,
659 `title` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
660 `excerpt` text CHARACTER SET latin1,
661 `text` text CHARACTER SET latin1,
662 `created_at` datetime NOT NULL,
663 `updated_at` datetime NOT NULL,
664 PRIMARY KEY (`id`)
665) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
666
667-- --------------------------------------------------------
668
669--
670-- Tabellenstruktur für Tabelle `punishment`
671--
672
673CREATE TABLE IF NOT EXISTS `punishment` (
674 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
675 `username` varchar(13) NOT NULL DEFAULT '',
676 `bannedBy` varchar(13) NOT NULL,
677 `date` datetime NOT NULL,
678 `days` int(10) NOT NULL,
679 `reason` varchar(256) NOT NULL,
680 `type` tinyint(1) NOT NULL,
681 PRIMARY KEY (`id`),
682 KEY `username` (`username`)
683) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4344 ;
684
685-- --------------------------------------------------------
686
687--
688-- Tabellenstruktur für Tabelle `ranked_highscores`
689--
690
691CREATE TABLE IF NOT EXISTS `ranked_highscores` (
692 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
693 `player_id` int(10) unsigned NOT NULL,
694 `skill` tinyint(3) unsigned NOT NULL,
695 `rank` int(10) unsigned NOT NULL,
696 `level` smallint(5) unsigned NOT NULL,
697 `exp` bigint(20) DEFAULT NULL,
698 PRIMARY KEY (`id`),
699 UNIQUE KEY `player_id_and_skill` (`player_id`,`skill`),
700 KEY `skill_and_rank` (`skill`,`rank`)
701) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
702
703-- --------------------------------------------------------
704
705--
706-- Tabellenstruktur für Tabelle `ranked_highscores1`
707--
708
709CREATE TABLE IF NOT EXISTS `ranked_highscores1` (
710 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
711 `player_id` int(10) unsigned NOT NULL,
712 `skill` tinyint(3) unsigned NOT NULL,
713 `rank` int(10) unsigned NOT NULL,
714 `level` smallint(5) unsigned NOT NULL,
715 `exp` bigint(20) DEFAULT NULL,
716 PRIMARY KEY (`id`),
717 UNIQUE KEY `player_id_and_skill` (`player_id`,`skill`),
718 KEY `skill_and_rank` (`skill`,`rank`)
719) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
720
721-- --------------------------------------------------------
722
723--
724-- Tabellenstruktur für Tabelle `referral_registration`
725--
726
727CREATE TABLE IF NOT EXISTS `referral_registration` (
728 `id` bigint(20) NOT NULL,
729 `user` int(11) NOT NULL,
730 `referral` int(11) NOT NULL,
731 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
732 `confirmed` tinyint(1) NOT NULL DEFAULT '0',
733 PRIMARY KEY (`id`),
734 KEY `user` (`user`),
735 KEY `referral` (`referral`)
736) ENGINE=InnoDB DEFAULT CHARSET=latin1;
737
738-- --------------------------------------------------------
739
740--
741-- Tabellenstruktur für Tabelle `referral_site`
742--
743
744CREATE TABLE IF NOT EXISTS `referral_site` (
745 `id` int(11) NOT NULL AUTO_INCREMENT,
746 `site` varchar(256) NOT NULL,
747 PRIMARY KEY (`id`)
748) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
749
750-- --------------------------------------------------------
751
752--
753-- Tabellenstruktur für Tabelle `referral_visitor`
754--
755
756CREATE TABLE IF NOT EXISTS `referral_visitor` (
757 `id` int(11) NOT NULL AUTO_INCREMENT,
758 `site_id` int(11) NOT NULL,
759 `ip` varchar(256) NOT NULL,
760 `visit_time` datetime NOT NULL,
761 PRIMARY KEY (`id`),
762 KEY `site_id` (`site_id`),
763 KEY `ip_key` (`ip`)
764) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25099 ;
765
766-- --------------------------------------------------------
767
768--
769-- Tabellenstruktur für Tabelle `reports`
770--
771
772CREATE TABLE IF NOT EXISTS `reports` (
773 `id` int(11) NOT NULL AUTO_INCREMENT,
774 `abuser_id` int(11) NOT NULL,
775 `status` enum('UNRESOLVED','PUNISH','IGNORE','FALSE') COLLATE utf8_bin NOT NULL DEFAULT 'UNRESOLVED',
776 `data` text COLLATE utf8_bin NOT NULL,
777 PRIMARY KEY (`id`)
778) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2428 ;
779
780-- --------------------------------------------------------
781
782--
783-- Tabellenstruktur für Tabelle `reset_requests`
784--
785
786CREATE TABLE IF NOT EXISTS `reset_requests` (
787 `id` int(11) NOT NULL AUTO_INCREMENT,
788 `user` varchar(13) CHARACTER SET latin1 NOT NULL,
789 `mod` varchar(13) CHARACTER SET latin1 NOT NULL,
790 `request_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
791 `s0` int(9) NOT NULL,
792 `s1` int(9) NOT NULL,
793 `s2` int(9) NOT NULL,
794 `s3` int(9) NOT NULL,
795 `s4` int(9) NOT NULL,
796 `s5` int(9) NOT NULL,
797 `s6` int(9) NOT NULL,
798 `s7` int(9) NOT NULL,
799 `s8` int(9) NOT NULL,
800 `s9` int(9) NOT NULL,
801 `s10` int(9) NOT NULL,
802 `s11` int(9) NOT NULL,
803 `s12` int(9) NOT NULL,
804 `s13` int(9) NOT NULL,
805 `s14` int(9) NOT NULL,
806 `s15` int(9) NOT NULL,
807 `s16` int(9) NOT NULL,
808 `s17` int(9) NOT NULL,
809 `s18` int(9) NOT NULL,
810 `s19` int(9) NOT NULL,
811 `s20` int(9) NOT NULL,
812 `approved` int(11) NOT NULL,
813 `verified` varchar(13) CHARACTER SET latin1 NOT NULL,
814 PRIMARY KEY (`id`)
815) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
816
817-- --------------------------------------------------------
818
819--
820-- Tabellenstruktur für Tabelle `schema_migrations`
821--
822
823CREATE TABLE IF NOT EXISTS `schema_migrations` (
824 `version` varchar(255) CHARACTER SET latin1 NOT NULL
825) ENGINE=InnoDB DEFAULT CHARSET=utf8;
826
827-- --------------------------------------------------------
828
829--
830-- Tabellenstruktur für Tabelle `unbans`
831--
832
833CREATE TABLE IF NOT EXISTS `unbans` (
834 `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
835 `bannedBy` varchar(13) CHARACTER SET latin1 NOT NULL COMMENT 'person who banned the user',
836 `bannedUser` varchar(13) CHARACTER SET latin1 NOT NULL COMMENT 'banee''s name',
837 `unbannedBy` varchar(13) CHARACTER SET latin1 NOT NULL COMMENT 'person who unbanned the user',
838 `banReason` varchar(255) CHARACTER SET latin1 NOT NULL COMMENT 'the original ban reason',
839 `unbanDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'time and date of the unban',
840 PRIMARY KEY (`id`)
841) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
842
843-- --------------------------------------------------------
844
845--
846-- Tabellenstruktur für Tabelle `uuid_bans`
847--
848
849CREATE TABLE IF NOT EXISTS `uuid_bans` (
850 `id` int(11) NOT NULL AUTO_INCREMENT,
851 `uuid` varchar(36) CHARACTER SET latin1 NOT NULL,
852 `banned_by` varchar(13) CHARACTER SET latin1 NOT NULL,
853 `reason` varchar(2048) CHARACTER SET latin1 NOT NULL,
854 `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
855 PRIMARY KEY (`id`),
856 UNIQUE KEY `uuid` (`uuid`),
857 KEY `banned_by` (`banned_by`)
858) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=133 ;
859
860-- --------------------------------------------------------
861
862--
863-- Tabellenstruktur für Tabelle `uuid_log`
864--
865
866CREATE TABLE IF NOT EXISTS `uuid_log` (
867 `id` int(11) NOT NULL AUTO_INCREMENT,
868 `player_id` int(10) unsigned NOT NULL,
869 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
870 `uuid` varchar(36) CHARACTER SET latin1 NOT NULL,
871 `ip` varchar(16) CHARACTER SET latin1 NOT NULL,
872 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
873 PRIMARY KEY (`id`),
874 KEY `username` (`username`),
875 KEY `uuid` (`uuid`),
876 KEY `ip` (`ip`),
877 KEY `timestamp` (`timestamp`),
878 KEY `pid` (`player_id`)
879) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6164393 ;
880
881-- --------------------------------------------------------
882
883--
884-- Tabellenstruktur für Tabelle `vote_log`
885--
886
887CREATE TABLE IF NOT EXISTS `vote_log` (
888 `id` int(11) NOT NULL AUTO_INCREMENT,
889 `voter_ip` varchar(32) DEFAULT NULL,
890 `server_ip` varchar(32) NOT NULL,
891 `site_id` tinyint(3) NOT NULL,
892 `time` datetime NOT NULL,
893 PRIMARY KEY (`id`),
894 UNIQUE KEY `ip_site_idx` (`id`,`site_id`),
895 UNIQUE KEY `ip_site_time_idx` (`voter_ip`,`site_id`,`time`),
896 KEY `ip_idx` (`voter_ip`),
897 KEY `ip_time_idx` (`voter_ip`,`time`)
898) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=45234 ;
899
900-- --------------------------------------------------------
901
902--
903-- Tabellenstruktur für Tabelle `vote_reward`
904--
905
906CREATE TABLE IF NOT EXISTS `vote_reward` (
907 `ip` varchar(64) NOT NULL,
908 `points` int(11) NOT NULL DEFAULT '0',
909 `total_points` int(11) NOT NULL DEFAULT '0',
910 PRIMARY KEY (`ip`)
911) ENGINE=InnoDB DEFAULT CHARSET=latin1;
912
913-- --------------------------------------------------------
914
915--
916-- Tabellenstruktur für Tabelle `vote_site`
917--
918
919CREATE TABLE IF NOT EXISTS `vote_site` (
920 `id` int(11) NOT NULL,
921 `name` varchar(64) NOT NULL,
922 `url` varchar(256) NOT NULL,
923 `cycle` tinyint(4) NOT NULL DEFAULT '24',
924 PRIMARY KEY (`id`)
925) ENGINE=InnoDB DEFAULT CHARSET=latin1;
926
927/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
928/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
929/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
930-- phpMyAdmin SQL Dump
931-- version 4.0.10deb1
932-- http://www.phpmyadmin.net
933--
934-- Host: localhost
935-- Erstellungszeit: 25. Okt 2015 um 20:23
936-- Server Version: 5.5.41-0ubuntu0.14.04.1
937-- PHP-Version: 5.5.9-1ubuntu4.7
938
939SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
940SET time_zone = "+00:00";
941
942
943/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
944/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
945/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
946/*!40101 SET NAMES utf8 */;
947
948--
949-- Datenbank: `emps`
950--
951
952-- --------------------------------------------------------
953
954--
955-- Tabellenstruktur für Tabelle `bans`
956--
957
958CREATE TABLE IF NOT EXISTS `bans` (
959 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
960 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
961 `bannedBy` varchar(13) CHARACTER SET ucs2 DEFAULT NULL,
962 `unbanDate` int(8) DEFAULT NULL,
963 `reason` varchar(255) CHARACTER SET ucs2 DEFAULT NULL,
964 PRIMARY KEY (`id`),
965 KEY `username` (`username`)
966) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3194 ;
967
968-- --------------------------------------------------------
969
970--
971-- Tabellenstruktur für Tabelle `clanchannel`
972--
973
974CREATE TABLE IF NOT EXISTS `clanchannel` (
975 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
976 `owner` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
977 `name` varchar(20) CHARACTER SET ucs2 NOT NULL DEFAULT '',
978 `locked` tinyint(1) NOT NULL DEFAULT '0',
979 PRIMARY KEY (`id`),
980 KEY `name` (`name`)
981) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1996 ;
982
983-- --------------------------------------------------------
984
985--
986-- Tabellenstruktur für Tabelle `donation`
987--
988
989CREATE TABLE IF NOT EXISTS `donation` (
990 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
991 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
992 `time` int(10) unsigned NOT NULL DEFAULT '0',
993 `item` int(11) NOT NULL DEFAULT '7478',
994 `completed` int(10) unsigned NOT NULL,
995 `payment_type` tinyint(4) NOT NULL DEFAULT '0',
996 `payment_id` varchar(64) DEFAULT NULL,
997 PRIMARY KEY (`id`),
998 KEY `username_idx` (`username`)
999) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2855 ;
1000
1001-- --------------------------------------------------------
1002
1003--
1004-- Tabellenstruktur für Tabelle `donationlog`
1005--
1006
1007CREATE TABLE IF NOT EXISTS `donationlog` (
1008 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
1009 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
1010 `first_name` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
1011 `last_name` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
1012 `email` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
1013 `transaction_id` varchar(64) CHARACTER SET ucs2 DEFAULT NULL,
1014 `amount` varchar(8) CHARACTER SET latin1 DEFAULT NULL,
1015 `status` varchar(16) NOT NULL DEFAULT 'Completed',
1016 `received` tinyint(2) NOT NULL DEFAULT '0',
1017 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1018 PRIMARY KEY (`id`),
1019 KEY `username` (`username`),
1020 KEY `transaction_id` (`transaction_id`)
1021) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7798 ;
1022
1023-- --------------------------------------------------------
1024
1025--
1026-- Tabellenstruktur für Tabelle `ge_offer`
1027--
1028
1029CREATE TABLE IF NOT EXISTS `ge_offer` (
1030 `player_id` bigint(20) NOT NULL,
1031 `slot` tinyint(4) NOT NULL,
1032 `item` int(11) NOT NULL,
1033 `amount_total` int(11) NOT NULL,
1034 `amount_available` int(11) NOT NULL,
1035 `amount_transferred` int(11) NOT NULL,
1036 `price_total` int(11) NOT NULL,
1037 `price_available` int(11) NOT NULL,
1038 `price_transferred` int(11) NOT NULL,
1039 `type` tinyint(4) NOT NULL,
1040 `modifications` int(11) NOT NULL,
1041 `creation` datetime NOT NULL,
1042 PRIMARY KEY (`player_id`,`slot`)
1043) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1044
1045-- --------------------------------------------------------
1046
1047--
1048-- Tabellenstruktur für Tabelle `highscores`
1049--
1050
1051CREATE TABLE IF NOT EXISTS `highscores` (
1052 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1053 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
1054 `skill` int(3) unsigned NOT NULL,
1055 `level` int(3) unsigned NOT NULL,
1056 `exp` bigint(20) NOT NULL,
1057 PRIMARY KEY (`id`),
1058 UNIQUE KEY `UNIQUE_UserAndSkill` (`username`,`skill`),
1059 KEY `idxSkill` (`skill`),
1060 KEY `idxSkillExp` (`skill`,`exp`)
1061) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9552576 ;
1062
1063-- --------------------------------------------------------
1064
1065--
1066-- Tabellenstruktur für Tabelle `hwid_bans`
1067--
1068
1069CREATE TABLE IF NOT EXISTS `hwid_bans` (
1070 `id` int(11) NOT NULL AUTO_INCREMENT,
1071 `hwid` varchar(32) NOT NULL,
1072 `banned_by` varchar(13) NOT NULL,
1073 `reason` varchar(128) NOT NULL,
1074 PRIMARY KEY (`id`)
1075) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
1076
1077-- --------------------------------------------------------
1078
1079--
1080-- Tabellenstruktur für Tabelle `hwid_log`
1081--
1082
1083CREATE TABLE IF NOT EXISTS `hwid_log` (
1084 `id` int(11) NOT NULL AUTO_INCREMENT,
1085 `player_id` int(10) unsigned NOT NULL,
1086 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
1087 `hwid` varchar(32) CHARACTER SET latin1 NOT NULL,
1088 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1089 PRIMARY KEY (`id`),
1090 KEY `pid` (`player_id`)
1091) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1075980 ;
1092
1093-- --------------------------------------------------------
1094
1095--
1096-- Tabellenstruktur für Tabelle `ip_logs`
1097--
1098
1099CREATE TABLE IF NOT EXISTS `ip_logs` (
1100 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1101 `ip` varchar(19) CHARACTER SET latin1 NOT NULL DEFAULT '',
1102 UNIQUE KEY `username_ip` (`username`,`ip`),
1103 KEY `username` (`username`),
1104 KEY `ip` (`ip`)
1105) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1106
1107-- --------------------------------------------------------
1108
1109--
1110-- Tabellenstruktur für Tabelle `item_names`
1111--
1112
1113CREATE TABLE IF NOT EXISTS `item_names` (
1114 `id` int(6) NOT NULL,
1115 `name` varchar(32) NOT NULL,
1116 PRIMARY KEY (`id`)
1117) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1118
1119-- --------------------------------------------------------
1120
1121--
1122-- Tabellenstruktur für Tabelle `logs_chat`
1123--
1124
1125CREATE TABLE IF NOT EXISTS `logs_chat` (
1126 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
1127 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1128 `data` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
1129 `x` smallint(5) DEFAULT NULL,
1130 `y` smallint(5) DEFAULT NULL,
1131 `height` tinyint(1) DEFAULT NULL,
1132 `date` int(10) DEFAULT NULL,
1133 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1134 PRIMARY KEY (`id`),
1135 KEY `username` (`username`),
1136 KEY `date` (`date`),
1137 KEY `exact_time` (`exactTime`)
1138) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=200936798 ;
1139
1140-- --------------------------------------------------------
1141
1142--
1143-- Tabellenstruktur für Tabelle `logs_c_chat`
1144--
1145
1146CREATE TABLE IF NOT EXISTS `logs_c_chat` (
1147 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
1148 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1149 `clan` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1150 `data` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
1151 `x` smallint(5) DEFAULT NULL,
1152 `y` smallint(5) DEFAULT NULL,
1153 `height` tinyint(1) DEFAULT NULL,
1154 `date` int(10) DEFAULT NULL,
1155 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1156 PRIMARY KEY (`id`),
1157 KEY `username` (`username`),
1158 KEY `clan` (`clan`),
1159 KEY `date` (`date`),
1160 KEY `exact_time` (`exactTime`)
1161) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3492541 ;
1162
1163-- --------------------------------------------------------
1164
1165--
1166-- Tabellenstruktur für Tabelle `logs_ge`
1167--
1168
1169CREATE TABLE IF NOT EXISTS `logs_ge` (
1170 `id` bigint(20) NOT NULL AUTO_INCREMENT,
1171 `from` varchar(13) NOT NULL,
1172 `to` varchar(13) NOT NULL,
1173 `item` int(11) NOT NULL,
1174 `amount` int(11) NOT NULL,
1175 `price` int(11) NOT NULL,
1176 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1177 PRIMARY KEY (`id`),
1178 KEY `user_to` (`to`),
1179 KEY `user_from` (`from`)
1180) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
1181
1182-- --------------------------------------------------------
1183
1184--
1185-- Tabellenstruktur für Tabelle `logs_pickup_drop`
1186--
1187
1188CREATE TABLE IF NOT EXISTS `logs_pickup_drop` (
1189 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
1190 `username` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1191 `item` smallint(5) DEFAULT NULL,
1192 `amount` int(10) DEFAULT NULL,
1193 `x` smallint(5) DEFAULT NULL,
1194 `y` smallint(5) DEFAULT NULL,
1195 `height` tinyint(1) DEFAULT NULL,
1196 `isDrop` tinyint(1) DEFAULT NULL,
1197 `date` int(10) DEFAULT NULL,
1198 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1199 PRIMARY KEY (`id`),
1200 KEY `username` (`username`),
1201 KEY `date` (`date`),
1202 KEY `position` (`x`,`y`,`height`),
1203 KEY `exact_time` (`exactTime`)
1204) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=66747953 ;
1205
1206-- --------------------------------------------------------
1207
1208--
1209-- Tabellenstruktur für Tabelle `logs_p_chat`
1210--
1211
1212CREATE TABLE IF NOT EXISTS `logs_p_chat` (
1213 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
1214 `from` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1215 `to` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1216 `data` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
1217 `x` smallint(5) DEFAULT NULL,
1218 `y` smallint(5) DEFAULT NULL,
1219 `height` tinyint(1) DEFAULT NULL,
1220 `date` int(10) DEFAULT NULL,
1221 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1222 PRIMARY KEY (`id`),
1223 KEY `from` (`from`),
1224 KEY `to` (`to`),
1225 KEY `date` (`date`),
1226 KEY `exact_time` (`exactTime`)
1227) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14338347 ;
1228
1229-- --------------------------------------------------------
1230
1231--
1232-- Tabellenstruktur für Tabelle `logs_stake`
1233--
1234
1235CREATE TABLE IF NOT EXISTS `logs_stake` (
1236 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
1237 `from` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1238 `to` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1239 `item` smallint(5) DEFAULT NULL,
1240 `amount` int(10) DEFAULT NULL,
1241 `date` int(10) DEFAULT NULL,
1242 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1243 PRIMARY KEY (`id`),
1244 KEY `from` (`from`),
1245 KEY `to` (`to`),
1246 KEY `date` (`date`),
1247 KEY `exact_time` (`exactTime`)
1248) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2192509 ;
1249
1250-- --------------------------------------------------------
1251
1252--
1253-- Tabellenstruktur für Tabelle `logs_trade`
1254--
1255
1256CREATE TABLE IF NOT EXISTS `logs_trade` (
1257 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
1258 `from` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1259 `to` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1260 `item` smallint(5) DEFAULT NULL,
1261 `amount` int(10) DEFAULT NULL,
1262 `x` smallint(5) DEFAULT NULL,
1263 `y` smallint(5) DEFAULT NULL,
1264 `height` tinyint(1) DEFAULT NULL,
1265 `date` int(10) DEFAULT NULL,
1266 `exactTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1267 PRIMARY KEY (`id`),
1268 KEY `from` (`from`),
1269 KEY `to` (`to`),
1270 KEY `date` (`date`),
1271 KEY `exact_time` (`exactTime`)
1272) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6874586 ;
1273
1274-- --------------------------------------------------------
1275
1276--
1277-- Tabellenstruktur für Tabelle `mail_keys`
1278--
1279
1280CREATE TABLE IF NOT EXISTS `mail_keys` (
1281 `id` int(11) NOT NULL AUTO_INCREMENT,
1282 `code` varchar(65) CHARACTER SET latin1 NOT NULL DEFAULT '',
1283 `data` varchar(13) CHARACTER SET latin1 NOT NULL DEFAULT '',
1284 `email` varchar(65) CHARACTER SET latin1 NOT NULL DEFAULT '',
1285 `type` tinyint(1) NOT NULL,
1286 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1287 PRIMARY KEY (`id`),
1288 UNIQUE KEY `unique` (`type`,`data`)
1289) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=80516 ;
1290
1291-- --------------------------------------------------------
1292
1293--
1294-- Tabellenstruktur für Tabelle `news`
1295--
1296
1297CREATE TABLE IF NOT EXISTS `news` (
1298 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1299 `author` varchar(12) CHARACTER SET latin1 NOT NULL,
1300 `timestamp` int(10) unsigned NOT NULL,
1301 `title` varchar(255) CHARACTER SET latin1 NOT NULL,
1302 `text` text CHARACTER SET latin1 NOT NULL,
1303 PRIMARY KEY (`id`)
1304) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1305
1306-- --------------------------------------------------------
1307
1308--
1309-- Tabellenstruktur für Tabelle `players`
1310--
1311
1312CREATE TABLE IF NOT EXISTS `players` (
1313 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1314 `username` varchar(13) CHARACTER SET ucs2 NOT NULL DEFAULT '',
1315 `password` varchar(255) CHARACTER SET ucs2 NOT NULL DEFAULT '',
1316 `password_salt` varchar(64) DEFAULT NULL,
1317 `hash_func` varchar(8) NOT NULL,
1318 `email` varchar(70) CHARACTER SET ucs2 DEFAULT NULL,
1319 `height` smallint(6) DEFAULT NULL,
1320 `X` int(5) DEFAULT NULL,
1321 `Y` int(5) DEFAULT NULL,
1322 `rights` tinyint(1) DEFAULT NULL,
1323 `member` tinyint(3) DEFAULT NULL,
1324 `lastconnect` varchar(70) CHARACTER SET ucs2 DEFAULT NULL,
1325 `lastlogin` int(8) DEFAULT NULL,
1326 `energy` smallint(6) DEFAULT NULL,
1327 `ancients` tinyint(1) DEFAULT NULL,
1328 `TBT` int(10) DEFAULT NULL,
1329 `BT` int(20) DEFAULT NULL,
1330 `D` tinyint(1) DEFAULT NULL,
1331 `G` tinyint(1) DEFAULT NULL,
1332 `V` tinyint(1) DEFAULT NULL,
1333 `T` tinyint(1) DEFAULT NULL,
1334 `K` tinyint(1) DEFAULT NULL,
1335 `A` tinyint(1) DEFAULT NULL,
1336 `music` tinyint(1) DEFAULT NULL,
1337 `sound` tinyint(1) DEFAULT NULL,
1338 `brightness` tinyint(1) DEFAULT NULL,
1339 `blackmarks` tinyint(3) DEFAULT NULL,
1340 `mutedate` int(8) DEFAULT NULL,
1341 `tutorial` tinyint(3) DEFAULT NULL,
1342 `lasths` int(8) DEFAULT NULL,
1343 `specbar` smallint(5) DEFAULT NULL,
1344 `specupd` int(6) DEFAULT NULL,
1345 `look0` int(9) DEFAULT NULL,
1346 `look1` int(9) DEFAULT NULL,
1347 `look2` int(9) DEFAULT NULL,
1348 `look3` int(9) DEFAULT NULL,
1349 `look4` int(9) DEFAULT NULL,
1350 `look5` int(9) DEFAULT NULL,
1351 `head` int(9) DEFAULT NULL,
1352 `torso` int(9) DEFAULT NULL,
1353 `arms` int(9) DEFAULT NULL,
1354 `hands` int(9) DEFAULT NULL,
1355 `legs` int(9) DEFAULT NULL,
1356 `feet` int(9) DEFAULT NULL,
1357 `beard` int(9) DEFAULT NULL,
1358 `eventManager` tinyint(1) NOT NULL DEFAULT '0',
1359 `lastlogin_dt` datetime NOT NULL,
1360 `online_time_ms` bigint(20) NOT NULL DEFAULT '0',
1361 `is_online` tinyint(4) NOT NULL DEFAULT '0',
1362 `creationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1363 `donation_points` int(11) NOT NULL DEFAULT '0',
1364 `donation_points_total` int(11) NOT NULL DEFAULT '0',
1365 PRIMARY KEY (`id`),
1366 KEY `username` (`username`)
1367) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1266446 ;
1368
1369-- --------------------------------------------------------
1370
1371--
1372-- Tabellenstruktur für Tabelle `players_config`
1373--
1374
1375CREATE TABLE IF NOT EXISTS `players_config` (
1376 `id` int(11) NOT NULL AUTO_INCREMENT,
1377 `player_id` int(10) unsigned DEFAULT NULL,
1378 `field0` int(5) DEFAULT '100',
1379 `field1` int(5) DEFAULT NULL,
1380 `field2` int(5) DEFAULT NULL,
1381 `field3` int(5) DEFAULT NULL,
1382 `field4` int(5) DEFAULT NULL,
1383 `field5` int(5) DEFAULT NULL,
1384 `field6` int(5) DEFAULT NULL,
1385 `field7` int(5) DEFAULT NULL,
1386 `field8` int(5) DEFAULT NULL,
1387 `field9` int(5) DEFAULT NULL,
1388 `field10` int(5) DEFAULT NULL,
1389 `field11` int(5) DEFAULT NULL,
1390 `field12` int(5) DEFAULT NULL,
1391 `field13` int(5) DEFAULT NULL,
1392 `field14` int(5) DEFAULT NULL,
1393 `field15` int(5) DEFAULT NULL,
1394 `field16` int(5) DEFAULT NULL,
1395 `field17` int(5) DEFAULT NULL,
1396 `field18` int(5) DEFAULT NULL,
1397 `field19` int(5) DEFAULT NULL,
1398 `field20` int(5) DEFAULT NULL,
1399 `field21` int(5) DEFAULT NULL,
1400 `field22` int(5) DEFAULT NULL,
1401 `field23` int(5) DEFAULT NULL,
1402 `field24` int(5) DEFAULT NULL,
1403 `field25` int(5) DEFAULT NULL,
1404 `field26` int(5) DEFAULT NULL,
1405 `field27` int(5) DEFAULT NULL,
1406 `field28` int(5) DEFAULT NULL,
1407 `field29` int(5) DEFAULT NULL,
1408 `slayerPoints` int(11) NOT NULL DEFAULT '0',
1409 `prayers` int(10) NOT NULL DEFAULT '0',
1410 `last_cc` varchar(13) NOT NULL DEFAULT '',
1411 `guardian_angel` tinyint(3) NOT NULL DEFAULT '0',
1412 `dfs_charges` tinyint(2) NOT NULL DEFAULT '0',
1413 `antifire` int(11) NOT NULL DEFAULT '0',
1414 PRIMARY KEY (`id`),
1415 KEY `pid` (`player_id`)
1416) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1269215 ;
1417
1418-- --------------------------------------------------------
1419
1420--
1421-- Tabellenstruktur für Tabelle `players_construction_objects`
1422--
1423
1424CREATE TABLE IF NOT EXISTS `players_construction_objects` (
1425 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1426 `player_id` int(10) NOT NULL,
1427 `hotspotid` int(10) unsigned NOT NULL DEFAULT '0',
1428 `objectid` int(10) unsigned NOT NULL DEFAULT '0',
1429 `username` varchar(45) NOT NULL DEFAULT '',
1430 `roomid` int(10) unsigned NOT NULL DEFAULT '0',
1431 PRIMARY KEY (`id`),
1432 KEY `pid` (`player_id`)
1433) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=49165 ;
1434
1435-- --------------------------------------------------------
1436
1437--
1438-- Tabellenstruktur für Tabelle `players_construction_rooms`
1439--
1440
1441CREATE TABLE IF NOT EXISTS `players_construction_rooms` (
1442 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1443 `player_id` int(10) unsigned NOT NULL,
1444 `username` varchar(45) NOT NULL DEFAULT '',
1445 `roomid` tinyint(8) unsigned NOT NULL DEFAULT '0',
1446 `roomrot` tinyint(8) unsigned NOT NULL DEFAULT '0',
1447 `x` tinyint(8) unsigned NOT NULL DEFAULT '0',
1448 `y` tinyint(8) unsigned NOT NULL DEFAULT '0',
1449 `z` tinyint(8) unsigned NOT NULL DEFAULT '0',
1450 PRIMARY KEY (`id`),
1451 KEY `pid` (`player_id`)
1452) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=49145 ;
1453
1454-- --------------------------------------------------------
1455
1456--
1457-- Tabellenstruktur für Tabelle `players_construction_type`
1458--
1459
1460CREATE TABLE IF NOT EXISTS `players_construction_type` (
1461 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1462 `username` varchar(45) NOT NULL DEFAULT '',
1463 `type` tinyint(8) unsigned NOT NULL DEFAULT '0',
1464 `player_id` int(10) unsigned NOT NULL,
1465 PRIMARY KEY (`id`),
1466 KEY `pid` (`player_id`)
1467) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=49138 ;
1468
1469-- --------------------------------------------------------
1470
1471--
1472-- Tabellenstruktur für Tabelle `players_friends`
1473--
1474
1475CREATE TABLE IF NOT EXISTS `players_friends` (
1476 `primary` int(10) unsigned NOT NULL AUTO_INCREMENT,
1477 `player_id` int(10) unsigned NOT NULL,
1478 `person_id` bigint(40) NOT NULL,
1479 `type` tinyint(5) unsigned NOT NULL,
1480 `slot` int(11) NOT NULL,
1481 PRIMARY KEY (`primary`),
1482 UNIQUE KEY `pid_and_slot` (`slot`,`player_id`,`type`),
1483 KEY `pid` (`player_id`),
1484 KEY `person_key` (`person_id`)
1485) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6846199 ;
1486
1487-- --------------------------------------------------------
1488
1489--
1490-- Tabellenstruktur für Tabelle `players_items`
1491--
1492
1493CREATE TABLE IF NOT EXISTS `players_items` (
1494 `primary` int(10) unsigned NOT NULL AUTO_INCREMENT,
1495 `player_id` int(10) unsigned NOT NULL,
1496 `item` int(6) NOT NULL,
1497 `amount` int(5) unsigned NOT NULL,
1498 `slot` int(5) unsigned NOT NULL,
1499 `type` tinyint(5) unsigned NOT NULL,
1500 PRIMARY KEY (`primary`),
1501 UNIQUE KEY `pid_and_slot` (`player_id`,`slot`,`type`),
1502 KEY `pid` (`player_id`),
1503 KEY `slot` (`slot`),
1504 KEY `item` (`item`)
1505) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=56482727 ;
1506
1507-- --------------------------------------------------------
1508
1509--
1510-- Tabellenstruktur für Tabelle `players_item_health`
1511--
1512
1513CREATE TABLE IF NOT EXISTS `players_item_health` (
1514 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
1515 `player_id` int(10) unsigned DEFAULT NULL,
1516 `item` int(5) DEFAULT NULL,
1517 `health` int(3) DEFAULT '0',
1518 PRIMARY KEY (`id`),
1519 UNIQUE KEY `player_id` (`player_id`,`item`),
1520 KEY `item` (`item`),
1521 KEY `pid` (`player_id`)
1522) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12263685 ;
1523
1524-- --------------------------------------------------------
1525
1526--
1527-- Tabellenstruktur für Tabelle `players_kill_log`
1528--
1529
1530CREATE TABLE IF NOT EXISTS `players_kill_log` (
1531 `id` int(11) NOT NULL AUTO_INCREMENT,
1532 `player_id` int(11) NOT NULL,
1533 `type` tinyint(4) NOT NULL,
1534 `monster_hash` bigint(11) NOT NULL,
1535 `kills` int(11) NOT NULL,
1536 PRIMARY KEY (`id`),
1537 UNIQUE KEY `unique_player` (`player_id`,`type`,`monster_hash`),
1538 KEY `player_id` (`player_id`)
1539) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=413406 ;
1540
1541-- --------------------------------------------------------
1542
1543--
1544-- Tabellenstruktur für Tabelle `players_patch`
1545--
1546
1547CREATE TABLE IF NOT EXISTS `players_patch` (
1548 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
1549 `player_id` int(10) NOT NULL,
1550 `patch` int(11) NOT NULL,
1551 `type` int(11) NOT NULL,
1552 `original_type` int(11) DEFAULT '0',
1553 `age` int(11) NOT NULL,
1554 `timelastupdated` bigint(20) NOT NULL,
1555 `needs` tinyint(4) NOT NULL,
1556 PRIMARY KEY (`id`),
1557 UNIQUE KEY `pid_and_patch` (`patch`,`player_id`) USING BTREE
1558) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11590835 ;
1559
1560-- --------------------------------------------------------
1561
1562--
1563-- Tabellenstruktur für Tabelle `players_skill`
1564--
1565
1566CREATE TABLE IF NOT EXISTS `players_skill` (
1567 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
1568 `player_id` int(10) unsigned DEFAULT NULL,
1569 `skill` tinyint(2) unsigned DEFAULT NULL,
1570 `lvl` int(3) DEFAULT NULL,
1571 `lvl_cur` int(3) unsigned NOT NULL,
1572 `xp` bigint(20) DEFAULT NULL,
1573 PRIMARY KEY (`id`),
1574 UNIQUE KEY `pid_and_skill` (`player_id`,`skill`),
1575 KEY `skill` (`skill`),
1576 KEY `pid` (`player_id`)
1577) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=166564088 ;
1578
1579-- --------------------------------------------------------
1580
1581--
1582-- Tabellenstruktur für Tabelle `posts`
1583--
1584
1585CREATE TABLE IF NOT EXISTS `posts` (
1586 `id` int(11) NOT NULL AUTO_INCREMENT,
1587 `player_id` int(11) DEFAULT NULL,
1588 `title` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
1589 `excerpt` text CHARACTER SET latin1,
1590 `text` text CHARACTER SET latin1,
1591 `created_at` datetime NOT NULL,
1592 `updated_at` datetime NOT NULL,
1593 PRIMARY KEY (`id`)
1594) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1595
1596-- --------------------------------------------------------
1597
1598--
1599-- Tabellenstruktur für Tabelle `punishment`
1600--
1601
1602CREATE TABLE IF NOT EXISTS `punishment` (
1603 `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
1604 `username` varchar(13) NOT NULL DEFAULT '',
1605 `bannedBy` varchar(13) NOT NULL,
1606 `date` datetime NOT NULL,
1607 `days` int(10) NOT NULL,
1608 `reason` varchar(256) NOT NULL,
1609 `type` tinyint(1) NOT NULL,
1610 PRIMARY KEY (`id`),
1611 KEY `username` (`username`)
1612) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4344 ;
1613
1614-- --------------------------------------------------------
1615
1616--
1617-- Tabellenstruktur für Tabelle `ranked_highscores`
1618--
1619
1620CREATE TABLE IF NOT EXISTS `ranked_highscores` (
1621 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1622 `player_id` int(10) unsigned NOT NULL,
1623 `skill` tinyint(3) unsigned NOT NULL,
1624 `rank` int(10) unsigned NOT NULL,
1625 `level` smallint(5) unsigned NOT NULL,
1626 `exp` bigint(20) DEFAULT NULL,
1627 PRIMARY KEY (`id`),
1628 UNIQUE KEY `player_id_and_skill` (`player_id`,`skill`),
1629 KEY `skill_and_rank` (`skill`,`rank`)
1630) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1631
1632-- --------------------------------------------------------
1633
1634--
1635-- Tabellenstruktur für Tabelle `ranked_highscores1`
1636--
1637
1638CREATE TABLE IF NOT EXISTS `ranked_highscores1` (
1639 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1640 `player_id` int(10) unsigned NOT NULL,
1641 `skill` tinyint(3) unsigned NOT NULL,
1642 `rank` int(10) unsigned NOT NULL,
1643 `level` smallint(5) unsigned NOT NULL,
1644 `exp` bigint(20) DEFAULT NULL,
1645 PRIMARY KEY (`id`),
1646 UNIQUE KEY `player_id_and_skill` (`player_id`,`skill`),
1647 KEY `skill_and_rank` (`skill`,`rank`)
1648) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1649
1650-- --------------------------------------------------------
1651
1652--
1653-- Tabellenstruktur für Tabelle `referral_registration`
1654--
1655
1656CREATE TABLE IF NOT EXISTS `referral_registration` (
1657 `id` bigint(20) NOT NULL,
1658 `user` int(11) NOT NULL,
1659 `referral` int(11) NOT NULL,
1660 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1661 `confirmed` tinyint(1) NOT NULL DEFAULT '0',
1662 PRIMARY KEY (`id`),
1663 KEY `user` (`user`),
1664 KEY `referral` (`referral`)
1665) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1666
1667-- --------------------------------------------------------
1668
1669--
1670-- Tabellenstruktur für Tabelle `referral_site`
1671--
1672
1673CREATE TABLE IF NOT EXISTS `referral_site` (
1674 `id` int(11) NOT NULL AUTO_INCREMENT,
1675 `site` varchar(256) NOT NULL,
1676 PRIMARY KEY (`id`)
1677) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
1678
1679-- --------------------------------------------------------
1680
1681--
1682-- Tabellenstruktur für Tabelle `referral_visitor`
1683--
1684
1685CREATE TABLE IF NOT EXISTS `referral_visitor` (
1686 `id` int(11) NOT NULL AUTO_INCREMENT,
1687 `site_id` int(11) NOT NULL,
1688 `ip` varchar(256) NOT NULL,
1689 `visit_time` datetime NOT NULL,
1690 PRIMARY KEY (`id`),
1691 KEY `site_id` (`site_id`),
1692 KEY `ip_key` (`ip`)
1693) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25099 ;
1694
1695-- --------------------------------------------------------
1696
1697--
1698-- Tabellenstruktur für Tabelle `reports`
1699--
1700
1701CREATE TABLE IF NOT EXISTS `reports` (
1702 `id` int(11) NOT NULL AUTO_INCREMENT,
1703 `abuser_id` int(11) NOT NULL,
1704 `status` enum('UNRESOLVED','PUNISH','IGNORE','FALSE') COLLATE utf8_bin NOT NULL DEFAULT 'UNRESOLVED',
1705 `data` text COLLATE utf8_bin NOT NULL,
1706 PRIMARY KEY (`id`)
1707) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2428 ;
1708
1709-- --------------------------------------------------------
1710
1711--
1712-- Tabellenstruktur für Tabelle `reset_requests`
1713--
1714
1715CREATE TABLE IF NOT EXISTS `reset_requests` (
1716 `id` int(11) NOT NULL AUTO_INCREMENT,
1717 `user` varchar(13) CHARACTER SET latin1 NOT NULL,
1718 `mod` varchar(13) CHARACTER SET latin1 NOT NULL,
1719 `request_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1720 `s0` int(9) NOT NULL,
1721 `s1` int(9) NOT NULL,
1722 `s2` int(9) NOT NULL,
1723 `s3` int(9) NOT NULL,
1724 `s4` int(9) NOT NULL,
1725 `s5` int(9) NOT NULL,
1726 `s6` int(9) NOT NULL,
1727 `s7` int(9) NOT NULL,
1728 `s8` int(9) NOT NULL,
1729 `s9` int(9) NOT NULL,
1730 `s10` int(9) NOT NULL,
1731 `s11` int(9) NOT NULL,
1732 `s12` int(9) NOT NULL,
1733 `s13` int(9) NOT NULL,
1734 `s14` int(9) NOT NULL,
1735 `s15` int(9) NOT NULL,
1736 `s16` int(9) NOT NULL,
1737 `s17` int(9) NOT NULL,
1738 `s18` int(9) NOT NULL,
1739 `s19` int(9) NOT NULL,
1740 `s20` int(9) NOT NULL,
1741 `approved` int(11) NOT NULL,
1742 `verified` varchar(13) CHARACTER SET latin1 NOT NULL,
1743 PRIMARY KEY (`id`)
1744) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1745
1746-- --------------------------------------------------------
1747
1748--
1749-- Tabellenstruktur für Tabelle `schema_migrations`
1750--
1751
1752CREATE TABLE IF NOT EXISTS `schema_migrations` (
1753 `version` varchar(255) CHARACTER SET latin1 NOT NULL
1754) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1755
1756-- --------------------------------------------------------
1757
1758--
1759-- Tabellenstruktur für Tabelle `unbans`
1760--
1761
1762CREATE TABLE IF NOT EXISTS `unbans` (
1763 `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
1764 `bannedBy` varchar(13) CHARACTER SET latin1 NOT NULL COMMENT 'person who banned the user',
1765 `bannedUser` varchar(13) CHARACTER SET latin1 NOT NULL COMMENT 'banee''s name',
1766 `unbannedBy` varchar(13) CHARACTER SET latin1 NOT NULL COMMENT 'person who unbanned the user',
1767 `banReason` varchar(255) CHARACTER SET latin1 NOT NULL COMMENT 'the original ban reason',
1768 `unbanDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'time and date of the unban',
1769 PRIMARY KEY (`id`)
1770) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1771
1772-- --------------------------------------------------------
1773
1774--
1775-- Tabellenstruktur für Tabelle `uuid_bans`
1776--
1777
1778CREATE TABLE IF NOT EXISTS `uuid_bans` (
1779 `id` int(11) NOT NULL AUTO_INCREMENT,
1780 `uuid` varchar(36) CHARACTER SET latin1 NOT NULL,
1781 `banned_by` varchar(13) CHARACTER SET latin1 NOT NULL,
1782 `reason` varchar(2048) CHARACTER SET latin1 NOT NULL,
1783 `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1784 PRIMARY KEY (`id`),
1785 UNIQUE KEY `uuid` (`uuid`),
1786 KEY `banned_by` (`banned_by`)
1787) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=133 ;
1788
1789-- --------------------------------------------------------
1790
1791--
1792-- Tabellenstruktur für Tabelle `uuid_log`
1793--
1794
1795CREATE TABLE IF NOT EXISTS `uuid_log` (
1796 `id` int(11) NOT NULL AUTO_INCREMENT,
1797 `player_id` int(10) unsigned NOT NULL,
1798 `username` varchar(13) CHARACTER SET latin1 NOT NULL,
1799 `uuid` varchar(36) CHARACTER SET latin1 NOT NULL,
1800 `ip` varchar(16) CHARACTER SET latin1 NOT NULL,
1801 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1802 PRIMARY KEY (`id`),
1803 KEY `username` (`username`),
1804 KEY `uuid` (`uuid`),
1805 KEY `ip` (`ip`),
1806 KEY `timestamp` (`timestamp`),
1807 KEY `pid` (`player_id`)
1808) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6164393 ;
1809
1810-- --------------------------------------------------------
1811
1812--
1813-- Tabellenstruktur für Tabelle `vote_log`
1814--
1815
1816CREATE TABLE IF NOT EXISTS `vote_log` (
1817 `id` int(11) NOT NULL AUTO_INCREMENT,
1818 `voter_ip` varchar(32) DEFAULT NULL,
1819 `server_ip` varchar(32) NOT NULL,
1820 `site_id` tinyint(3) NOT NULL,
1821 `time` datetime NOT NULL,
1822 PRIMARY KEY (`id`),
1823 UNIQUE KEY `ip_site_idx` (`id`,`site_id`),
1824 UNIQUE KEY `ip_site_time_idx` (`voter_ip`,`site_id`,`time`),
1825 KEY `ip_idx` (`voter_ip`),
1826 KEY `ip_time_idx` (`voter_ip`,`time`)
1827) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=45234 ;
1828
1829-- --------------------------------------------------------
1830
1831--
1832-- Tabellenstruktur für Tabelle `vote_reward`
1833--
1834
1835CREATE TABLE IF NOT EXISTS `vote_reward` (
1836 `ip` varchar(64) NOT NULL,
1837 `points` int(11) NOT NULL DEFAULT '0',
1838 `total_points` int(11) NOT NULL DEFAULT '0',
1839 PRIMARY KEY (`ip`)
1840) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1841
1842-- --------------------------------------------------------
1843
1844--
1845-- Tabellenstruktur für Tabelle `vote_site`
1846--
1847
1848CREATE TABLE IF NOT EXISTS `vote_site` (
1849 `id` int(11) NOT NULL,
1850 `name` varchar(64) NOT NULL,
1851 `url` varchar(256) NOT NULL,
1852 `cycle` tinyint(4) NOT NULL DEFAULT '24',
1853 PRIMARY KEY (`id`)
1854) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1855
1856/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1857/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1858/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1859
1860
1861CREATE TABLE IF NOT EXISTS `players_quest` (
1862 `id` int(11) NOT NULL,
1863 `player_id` int(11) NOT NULL,
1864 `quest_id` int(11) NOT NULL,
1865 `progress` int(11) NOT NULL,
1866 PRIMARY KEY (`id`),
1867 UNIQUE KEY `unique_pid_qid` (`player_id`,`quest_id`)
1868) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1869
1870--
1871-- Indizes für die Tabelle `players_quest`
1872--
1873ALTER TABLE `players_quest`
1874 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_pid_qid` (`player_id`,`quest_id`);