· 9 years ago · Dec 13, 2016, 02:02 PM
1-- phpMyAdmin SQL Dump
2-- version 3.5.5
3-- http://www.phpmyadmin.net
4--
5-- Host: 63.251.20.163
6-- Generato il: Ago 21, 2016 alle 12:09
7-- Versione del server: 5.5.50-0ubuntu0.14.04.1-log
8-- Versione PHP: 5.3.28
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-- Database: `devinity`
21--
22
23DELIMITER $$
24--
25-- Procedure
26--
27$$
28
29$$
30
31$$
32
33$$
34
35$$
36
37$$
38
39$$
40
41$$
42
43$$
44
45$$
46
47$$
48
49$$
50
51$$
52
53--
54-- Funzioni
55--
56$$
57
58DELIMITER ;
59
60-- --------------------------------------------------------
61
62--
63-- Struttura della tabella `achievements_new`
64--
65
66CREATE TABLE IF NOT EXISTS `achievements_new` (
67 `id` int(10) unsigned NOT NULL,
68 `achkey` enum('burn0','pirate2','destroy2','halloween_plymdl','teamcreator','lonewolf0','destroymetal','damage0','frankensteincreation','extinguish0','protectpaper','damage2','christmas_participate','destroymisc','vending','destroyshelfwbow','damage1','time1','cash0','time2','burn2','destroybeer','cash2','destroyhousehold','cash4tokens','christmas_candycane','killzombie0','halloween_pumpkins','rounddamage1','destroysnowmen','lonewolf2','protectbeer','toiletpaper','halloween_spoopy','halloween_participate','killaszombie1','lonewolf1','wardinghy','halloween_zombieevent','destroythin','pirate1','killaszombie0','deathinsurance','winner','christmas_snow','christmas_merry','destroy0','teamkicker','destroypaper','rounddamage0','halfwayraft','cash1','extinguish1','destroy1','destroypallets','killzombie1','yeoldpirateship','destroyplastic','time0','extinguish2','drinker','unweldprops','destroyplastbarrels','destroywood','burn1','floatingfortress','rounddamage2','pirate0') NOT NULL,
69 `value` mediumint(8) NOT NULL DEFAULT '0',
70 UNIQUE KEY `id` (`id`,`achkey`),
71 KEY `id_2` (`id`),
72 KEY `achkey` (`achkey`)
73) ENGINE=InnoDB DEFAULT CHARSET=latin1;
74
75-- --------------------------------------------------------
76
77--
78-- Struttura della tabella `achievements_new_bkp`
79--
80
81CREATE TABLE IF NOT EXISTS `achievements_new_bkp` (
82 `id` int(10) unsigned NOT NULL,
83 `achkey2` varchar(32) CHARACTER SET ascii NOT NULL,
84 `value` mediumint(8) NOT NULL DEFAULT '0',
85 UNIQUE KEY `id` (`id`,`achkey2`),
86 KEY `id_2` (`id`),
87 KEY `achkey2` (`achkey2`)
88) ENGINE=InnoDB DEFAULT CHARSET=latin1;
89
90-- --------------------------------------------------------
91
92--
93-- Struttura della tabella `alldays`
94--
95
96CREATE TABLE IF NOT EXISTS `alldays` (
97 `date` date NOT NULL,
98 PRIMARY KEY (`date`)
99) ENGINE=InnoDB DEFAULT CHARSET=ascii COMMENT='Contains all days from 2016 to 2026';
100
101-- --------------------------------------------------------
102
103--
104-- Struttura della tabella `bans`
105--
106
107CREATE TABLE IF NOT EXISTS `bans` (
108 `steamid` varchar(19) CHARACTER SET ascii NOT NULL DEFAULT '',
109 `reason` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
110 `admin` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
111 `unban` int(11) unsigned NOT NULL,
112 `time` int(11) unsigned NOT NULL,
113 `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
114 `modified_time` tinytext CHARACTER SET ascii NOT NULL,
115 `modified_admin` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
116 PRIMARY KEY (`steamid`)
117) ENGINE=InnoDB DEFAULT CHARSET=latin1;
118
119-- --------------------------------------------------------
120
121--
122-- Struttura della tabella `config_props`
123--
124
125CREATE TABLE IF NOT EXISTS `config_props` (
126 `model` varchar(128) NOT NULL,
127 `price` smallint(5) unsigned NOT NULL,
128 `health` smallint(5) unsigned NOT NULL DEFAULT '0',
129 `floatability` enum('-3','-2','-1','0','1') NOT NULL COMMENT 'How well it floats',
130 `pplimit` tinyint(3) unsigned NOT NULL DEFAULT '0',
131 `buoyancy` double DEFAULT NULL,
132 `mass` smallint(5) unsigned DEFAULT NULL,
133 `physmat` varchar(50) DEFAULT NULL,
134 `cat` enum('Wooden','Plastic','Metal','Other') NOT NULL,
135 `order` int(11) NOT NULL,
136 PRIMARY KEY (`model`),
137 UNIQUE KEY `model` (`model`)
138) ENGINE=InnoDB DEFAULT CHARSET=ascii;
139
140-- --------------------------------------------------------
141
142--
143-- Struttura della tabella `config_weapons`
144--
145
146CREATE TABLE IF NOT EXISTS `config_weapons` (
147 `class` varchar(64) NOT NULL,
148 `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
149 `iconmdl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
150 `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
151 `price` mediumint(9) NOT NULL,
152 `viprank` tinyint(3) unsigned DEFAULT NULL,
153 `secammotype` varchar(32) DEFAULT NULL,
154 `secammo` mediumint(8) unsigned DEFAULT NULL,
155 `cat` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
156 `order` smallint(6) NOT NULL DEFAULT '0',
157 `slotx` tinyint(3) unsigned DEFAULT NULL,
158 `sloty` tinyint(3) unsigned DEFAULT NULL,
159 `damage` smallint(6) DEFAULT NULL,
160 `recoil` double NOT NULL DEFAULT '0',
161 `numshots` tinyint(3) unsigned NOT NULL DEFAULT '1',
162 `spread` double NOT NULL DEFAULT '0',
163 `ammo` mediumint(8) unsigned DEFAULT NULL,
164 `clipsize` smallint(5) unsigned NOT NULL DEFAULT '1',
165 `delay` double NOT NULL DEFAULT '0',
166 PRIMARY KEY (`class`)
167) ENGINE=InnoDB DEFAULT CHARSET=ascii;
168
169-- --------------------------------------------------------
170
171--
172-- Struttura della tabella `config_weapons_bkp`
173--
174
175CREATE TABLE IF NOT EXISTS `config_weapons_bkp` (
176 `class` varchar(64) NOT NULL,
177 `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
178 `iconmdl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
179 `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
180 `price` mediumint(9) NOT NULL,
181 `viprank` tinyint(3) unsigned DEFAULT NULL,
182 `secammotype` varchar(32) DEFAULT NULL,
183 `secammo` mediumint(8) unsigned DEFAULT NULL,
184 `cat` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
185 `order` smallint(6) NOT NULL DEFAULT '0',
186 `slotx` tinyint(3) unsigned DEFAULT NULL,
187 `sloty` tinyint(3) unsigned DEFAULT NULL,
188 `damage` smallint(6) DEFAULT NULL,
189 `recoil` double NOT NULL DEFAULT '0',
190 `numshots` tinyint(3) unsigned NOT NULL DEFAULT '1',
191 `spread` double NOT NULL DEFAULT '0',
192 `ammo` mediumint(8) unsigned DEFAULT NULL,
193 `clipsize` smallint(5) unsigned NOT NULL DEFAULT '1',
194 `delay` double NOT NULL DEFAULT '0',
195 PRIMARY KEY (`class`)
196) ENGINE=InnoDB DEFAULT CHARSET=ascii;
197
198-- --------------------------------------------------------
199
200--
201-- Struttura della tabella `gametracker`
202--
203
204CREATE TABLE IF NOT EXISTS `gametracker` (
205 `ip` varchar(21) NOT NULL,
206 `hostname` varbinary(128) NOT NULL,
207 `rank` smallint(5) unsigned NOT NULL,
208 `date` date NOT NULL,
209 PRIMARY KEY (`ip`,`date`)
210) ENGINE=InnoDB DEFAULT CHARSET=ascii;
211
212-- --------------------------------------------------------
213
214--
215-- Struttura della tabella `gametracker_dates`
216--
217
218CREATE TABLE IF NOT EXISTS `gametracker_dates` (
219 `date` date NOT NULL,
220 PRIMARY KEY (`date`)
221) ENGINE=InnoDB DEFAULT CHARSET=ascii;
222
223-- --------------------------------------------------------
224
225--
226-- Struttura della tabella `innodb_lock_monitor`
227--
228
229CREATE TABLE IF NOT EXISTS `innodb_lock_monitor` (
230 `a` int(11) DEFAULT NULL
231) ENGINE=InnoDB DEFAULT CHARSET=ascii;
232
233-- --------------------------------------------------------
234
235--
236-- Struttura della tabella `ips`
237--
238
239CREATE TABLE IF NOT EXISTS `ips` (
240 `steamid` varchar(19) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
241 `ip` varchar(21) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
242 PRIMARY KEY (`steamid`)
243) ENGINE=MyISAM DEFAULT CHARSET=latin1;
244
245-- --------------------------------------------------------
246
247--
248-- Struttura della tabella `items_map`
249--
250
251CREATE TABLE IF NOT EXISTS `items_map` (
252 `old` varchar(64) NOT NULL,
253 `new` varchar(64) NOT NULL,
254 PRIMARY KEY (`old`)
255) ENGINE=InnoDB DEFAULT CHARSET=ascii;
256
257-- --------------------------------------------------------
258
259--
260-- Struttura della tabella `leaderboards`
261--
262
263CREATE TABLE IF NOT EXISTS `leaderboards` (
264 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
265 `steamid64` char(17) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
266 `nick` varchar(32) NOT NULL DEFAULT '',
267 `cash` int(32) unsigned NOT NULL DEFAULT '0',
268 `playtime` int(32) unsigned NOT NULL DEFAULT '0',
269 `nationality` char(2) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
270 `damage` int(32) unsigned NOT NULL DEFAULT '0',
271 `destroyed` int(32) unsigned NOT NULL DEFAULT '0',
272 `lastplayed` datetime NOT NULL,
273 `plvl` int(10) unsigned NOT NULL DEFAULT '0',
274 `wepvalue` int(10) unsigned NOT NULL DEFAULT '0',
275 `achcount` int(10) unsigned NOT NULL DEFAULT '0',
276 PRIMARY KEY (`id`),
277 KEY `plvl` (`plvl`),
278 KEY `wepvalue` (`wepvalue`),
279 KEY `achcount` (`achcount`)
280) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contains general info about players' AUTO_INCREMENT=173468 ;
281
282-- --------------------------------------------------------
283
284--
285-- Struttura della tabella `logs`
286--
287
288CREATE TABLE IF NOT EXISTS `logs` (
289 `date` datetime NOT NULL,
290 `type` enum('game','chat','admin','mysql','team','player','prop') CHARACTER SET ascii NOT NULL DEFAULT 'game',
291 `phase` enum('build','prepare','flood','fight','reflect') CHARACTER SET ascii NOT NULL DEFAULT 'build',
292 `event` varchar(10) CHARACTER SET ascii NOT NULL,
293 `server` enum('EU1','EU2','TEST','US1','US2','US3') CHARACTER SET ascii DEFAULT 'US1',
294 `ply1` int(10) unsigned DEFAULT NULL,
295 `ply2` int(10) unsigned DEFAULT NULL,
296 `msg` text NOT NULL,
297 KEY `date` (`date`),
298 KEY `ply1` (`ply1`),
299 KEY `ply2` (`ply2`)
300) ENGINE=InnoDB DEFAULT CHARSET=utf8;
301
302-- --------------------------------------------------------
303
304--
305-- Struttura della tabella `luaerrors`
306--
307
308CREATE TABLE IF NOT EXISTS `luaerrors` (
309 `errorid` varchar(10) NOT NULL,
310 `error` tinytext NOT NULL,
311 `stack` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
312 `realm` enum('server','client') NOT NULL,
313 `steamid` varchar(19) NOT NULL,
314 `count` int(10) unsigned NOT NULL DEFAULT '1',
315 `lastseen` datetime NOT NULL,
316 `version_hash` varchar(12) NOT NULL,
317 `version_date` datetime NOT NULL,
318 PRIMARY KEY (`errorid`,`realm`)
319) ENGINE=InnoDB DEFAULT CHARSET=ascii;
320
321-- --------------------------------------------------------
322
323--
324-- Struttura della tabella `paypaltransactions`
325--
326
327CREATE TABLE IF NOT EXISTS `paypaltransactions` (
328 `transid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Devinity Transaction ID',
329 `paypaltxnid` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT 'Paypal Transaction ID',
330 `steamid` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT 'User SteamID',
331 `email` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT 'User''s payment email',
332 `datetime` varchar(40) CHARACTER SET utf8 NOT NULL COMMENT 'Time of payment',
333 `regdatetime` datetime NOT NULL COMMENT 'Time when it was registered here.',
334 `statusgame` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0 = Completed, 1 = Claimed',
335 `amount` decimal(10,2) NOT NULL,
336 `itemname` varchar(20) CHARACTER SET utf8 NOT NULL,
337 `itemid` int(4) NOT NULL COMMENT 'ID for packs, tokenamount for tokens',
338 `currency` varchar(4) CHARACTER SET utf8 NOT NULL,
339 PRIMARY KEY (`transid`),
340 KEY `steamid` (`steamid`),
341 KEY `statusgame` (`statusgame`)
342) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1267 ;
343
344-- --------------------------------------------------------
345
346--
347-- Struttura della tabella `paypaltransactions_errors`
348--
349
350CREATE TABLE IF NOT EXISTS `paypaltransactions_errors` (
351 `errorid` int(4) NOT NULL AUTO_INCREMENT,
352 `paypaltxnid` varchar(50) DEFAULT NULL,
353 `steamid` varchar(30) DEFAULT NULL,
354 `email` varchar(255) DEFAULT NULL,
355 `datetime` varchar(40) NOT NULL,
356 `amount` decimal(10,2) DEFAULT NULL,
357 `itemname` varchar(20) DEFAULT NULL,
358 `itemid` int(4) NOT NULL,
359 `currency` varchar(4) DEFAULT NULL,
360 `errorcode` int(2) NOT NULL,
361 `errornote` tinytext,
362 `payment_status` varchar(100) CHARACTER SET ascii NOT NULL,
363 PRIMARY KEY (`errorid`)
364) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1408 ;
365
366-- --------------------------------------------------------
367
368--
369-- Struttura della tabella `paypaltransactions_refunds`
370--
371
372CREATE TABLE IF NOT EXISTS `paypaltransactions_refunds` (
373 `paypaltxnid` varchar(50) CHARACTER SET ascii NOT NULL DEFAULT '',
374 `steamid` varchar(30) CHARACTER SET ascii DEFAULT NULL,
375 `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
376 `datetime` varchar(40) CHARACTER SET ascii NOT NULL,
377 `amount` decimal(10,2) DEFAULT NULL,
378 `itemname` varchar(20) CHARACTER SET ascii DEFAULT NULL,
379 `itemid` int(4) NOT NULL,
380 `currency` varchar(4) CHARACTER SET ascii DEFAULT NULL,
381 `payment_status` varchar(100) CHARACTER SET ascii NOT NULL,
382 PRIMARY KEY (`paypaltxnid`)
383) ENGINE=MyISAM DEFAULT CHARSET=utf8;
384
385-- --------------------------------------------------------
386
387--
388-- Struttura della tabella `playeractivity`
389--
390
391CREATE TABLE IF NOT EXISTS `playeractivity` (
392 `i` int(10) unsigned NOT NULL AUTO_INCREMENT,
393 `id` int(10) unsigned NOT NULL,
394 `start` datetime DEFAULT NULL,
395 `end` datetime DEFAULT NULL,
396 `server` varchar(4) DEFAULT NULL,
397 `endreason` tinyint(3) unsigned NOT NULL,
398 PRIMARY KEY (`i`),
399 KEY `id` (`id`),
400 KEY `server` (`server`)
401) ENGINE=InnoDB DEFAULT CHARSET=ascii AUTO_INCREMENT=264984 ;
402
403-- --------------------------------------------------------
404
405--
406-- Struttura della tabella `playerdata`
407--
408
409CREATE TABLE IF NOT EXISTS `playerdata` (
410 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
411 `steamid` char(19) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
412 `steamid64` char(1) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
413 `nick` varchar(32) NOT NULL DEFAULT '',
414 `cash` int(32) unsigned NOT NULL DEFAULT '0',
415 `tokens` smallint(4) unsigned NOT NULL DEFAULT '1',
416 `playtime` int(32) unsigned NOT NULL DEFAULT '0',
417 `nationality` char(2) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
418 `viprank` tinyint(1) unsigned NOT NULL DEFAULT '0',
419 `damage` int(32) unsigned NOT NULL DEFAULT '0',
420 `destroyed` int(32) unsigned NOT NULL DEFAULT '0',
421 `cashearned` int(10) unsigned NOT NULL,
422 `roundswon` smallint(5) unsigned NOT NULL,
423 `roundswon_old` smallint(5) unsigned NOT NULL DEFAULT '0',
424 `rounds` int(10) unsigned NOT NULL,
425 `lastplayed` datetime NOT NULL,
426 `joined` datetime DEFAULT NULL,
427 `plvl` smallint(5) unsigned NOT NULL,
428 `wepvalue` mediumint(8) unsigned NOT NULL,
429 `achcount` tinyint(3) unsigned NOT NULL,
430 `forumreward` tinyint(1) NOT NULL DEFAULT '0',
431 `groupreward` tinyint(1) NOT NULL DEFAULT '0',
432 `postreward` smallint(5) unsigned NOT NULL DEFAULT '0',
433 PRIMARY KEY (`id`),
434 UNIQUE KEY `steamid` (`steamid`),
435 KEY `forumreward` (`forumreward`),
436 KEY `cash` (`cash`),
437 KEY `damage` (`damage`),
438 KEY `destroyed` (`destroyed`),
439 KEY `steamid64` (`steamid64`),
440 KEY `nationality` (`nationality`)
441) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contains general info about players' AUTO_INCREMENT=303236 ;
442
443-- --------------------------------------------------------
444
445--
446-- Struttura della tabella `playerdata_bkp`
447--
448
449CREATE TABLE IF NOT EXISTS `playerdata_bkp` (
450 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
451 `steamid` varchar(19) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
452 `steamid64` char(17) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
453 `nick` varchar(32) NOT NULL DEFAULT '',
454 `cash` int(32) unsigned NOT NULL DEFAULT '0',
455 `tokens` smallint(4) unsigned NOT NULL DEFAULT '1',
456 `playtime` int(32) unsigned NOT NULL DEFAULT '0',
457 `nationality` char(2) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
458 `viprank` tinyint(1) unsigned NOT NULL DEFAULT '0',
459 `damage` int(32) unsigned NOT NULL DEFAULT '0',
460 `destroyed` int(32) unsigned NOT NULL DEFAULT '0',
461 `cashearned` int(10) unsigned NOT NULL,
462 `roundswon` smallint(5) unsigned NOT NULL,
463 `lastplayed` datetime NOT NULL,
464 `forumreward` tinyint(1) NOT NULL DEFAULT '0',
465 `groupreward` tinyint(1) NOT NULL DEFAULT '0',
466 `plvl` int(10) unsigned NOT NULL DEFAULT '0',
467 `wepvalue` int(10) unsigned NOT NULL DEFAULT '0',
468 `achcount` int(10) unsigned NOT NULL DEFAULT '0',
469 PRIMARY KEY (`id`),
470 UNIQUE KEY `steamid` (`steamid`),
471 KEY `forumreward` (`forumreward`),
472 KEY `plvl` (`plvl`),
473 KEY `wepvalue` (`wepvalue`),
474 KEY `achcount` (`achcount`),
475 KEY `cash` (`cash`),
476 KEY `damage` (`damage`),
477 KEY `destroyed` (`destroyed`),
478 KEY `steamid64` (`steamid64`),
479 KEY `nationality` (`nationality`)
480) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contains general info about players' AUTO_INCREMENT=1 ;
481
482-- --------------------------------------------------------
483
484--
485-- Struttura della tabella `playerdata_bkp2`
486--
487
488CREATE TABLE IF NOT EXISTS `playerdata_bkp2` (
489 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
490 `steamid` varchar(19) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
491 `steamid64` char(17) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
492 `nick` varchar(32) NOT NULL DEFAULT '',
493 `cash` int(32) unsigned NOT NULL DEFAULT '0',
494 `tokens` smallint(4) unsigned NOT NULL DEFAULT '1',
495 `playtime` int(32) unsigned NOT NULL DEFAULT '0',
496 `nationality` char(2) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
497 `viprank` tinyint(1) unsigned NOT NULL DEFAULT '0',
498 `damage` int(32) unsigned NOT NULL DEFAULT '0',
499 `destroyed` int(32) unsigned NOT NULL DEFAULT '0',
500 `cashearned` int(10) unsigned NOT NULL,
501 `roundswon` smallint(5) unsigned NOT NULL,
502 `lastplayed` datetime NOT NULL,
503 `joined` datetime DEFAULT NULL,
504 `achcount` smallint(5) unsigned NOT NULL,
505 `wepvalue` int(10) unsigned NOT NULL,
506 `forumreward` tinyint(1) NOT NULL DEFAULT '0',
507 `groupreward` tinyint(1) NOT NULL DEFAULT '0',
508 PRIMARY KEY (`id`),
509 UNIQUE KEY `steamid` (`steamid`),
510 KEY `forumreward` (`forumreward`),
511 KEY `cash` (`cash`),
512 KEY `damage` (`damage`),
513 KEY `destroyed` (`destroyed`),
514 KEY `steamid64` (`steamid64`),
515 KEY `nationality` (`nationality`)
516) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contains general info about players' AUTO_INCREMENT=172172 ;
517
518-- --------------------------------------------------------
519
520--
521-- Struttura della tabella `playerdata_bkp3`
522--
523
524CREATE TABLE IF NOT EXISTS `playerdata_bkp3` (
525 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
526 `steamid` varchar(19) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
527 `steamid64` char(17) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
528 `nick` varchar(32) NOT NULL DEFAULT '',
529 `cash` int(32) unsigned NOT NULL DEFAULT '0',
530 `tokens` smallint(4) unsigned NOT NULL DEFAULT '1',
531 `playtime` int(32) unsigned NOT NULL DEFAULT '0',
532 `nationality` char(2) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
533 `viprank` tinyint(1) unsigned NOT NULL DEFAULT '0',
534 `damage` int(32) unsigned NOT NULL DEFAULT '0',
535 `destroyed` int(32) unsigned NOT NULL DEFAULT '0',
536 `cashearned` int(10) unsigned NOT NULL,
537 `roundswon` smallint(5) unsigned NOT NULL,
538 `roundswon_old` smallint(5) unsigned NOT NULL DEFAULT '0',
539 `rounds` int(10) unsigned NOT NULL,
540 `lastplayed` datetime NOT NULL,
541 `joined` datetime DEFAULT NULL,
542 `plvl` smallint(5) unsigned NOT NULL,
543 `wepvalue` mediumint(8) unsigned NOT NULL,
544 `achcount` tinyint(3) unsigned NOT NULL,
545 `forumreward` tinyint(1) NOT NULL DEFAULT '0',
546 `groupreward` tinyint(1) NOT NULL DEFAULT '0',
547 PRIMARY KEY (`id`),
548 UNIQUE KEY `steamid` (`steamid`),
549 KEY `forumreward` (`forumreward`),
550 KEY `cash` (`cash`),
551 KEY `damage` (`damage`),
552 KEY `destroyed` (`destroyed`),
553 KEY `steamid64` (`steamid64`),
554 KEY `nationality` (`nationality`)
555) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contains general info about players' AUTO_INCREMENT=289240 ;
556
557-- --------------------------------------------------------
558
559--
560-- Struttura della tabella `playerdata_bkp4`
561--
562
563CREATE TABLE IF NOT EXISTS `playerdata_bkp4` (
564 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
565 `steamid` char(19) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
566 `steamid64` char(1) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
567 `nick` varchar(32) NOT NULL DEFAULT '',
568 `cash` int(32) unsigned NOT NULL DEFAULT '0',
569 `tokens` smallint(4) unsigned NOT NULL DEFAULT '1',
570 `playtime` int(32) unsigned NOT NULL DEFAULT '0',
571 `nationality` char(2) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
572 `viprank` tinyint(1) unsigned NOT NULL DEFAULT '0',
573 `damage` int(32) unsigned NOT NULL DEFAULT '0',
574 `destroyed` int(32) unsigned NOT NULL DEFAULT '0',
575 `cashearned` int(10) unsigned NOT NULL,
576 `roundswon` smallint(5) unsigned NOT NULL,
577 `roundswon_old` smallint(5) unsigned NOT NULL DEFAULT '0',
578 `rounds` int(10) unsigned NOT NULL,
579 `lastplayed` datetime NOT NULL,
580 `joined` datetime DEFAULT NULL,
581 `plvl` smallint(5) unsigned NOT NULL,
582 `wepvalue` mediumint(8) unsigned NOT NULL,
583 `achcount` tinyint(3) unsigned NOT NULL,
584 `forumreward` tinyint(1) NOT NULL DEFAULT '0',
585 `groupreward` tinyint(1) NOT NULL DEFAULT '0',
586 `postreward` smallint(5) unsigned NOT NULL DEFAULT '0',
587 PRIMARY KEY (`id`),
588 UNIQUE KEY `steamid` (`steamid`),
589 KEY `forumreward` (`forumreward`),
590 KEY `cash` (`cash`),
591 KEY `damage` (`damage`),
592 KEY `destroyed` (`destroyed`),
593 KEY `steamid64` (`steamid64`),
594 KEY `nationality` (`nationality`)
595) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contains general info about players' AUTO_INCREMENT=303079 ;
596
597-- --------------------------------------------------------
598
599--
600-- Struttura della tabella `playerextras`
601--
602
603CREATE TABLE IF NOT EXISTS `playerextras` (
604 `id` int(10) unsigned NOT NULL,
605 `lastgift` datetime DEFAULT NULL,
606 `lastwelfare` datetime DEFAULT NULL,
607 PRIMARY KEY (`id`)
608) ENGINE=InnoDB DEFAULT CHARSET=ascii;
609
610-- --------------------------------------------------------
611
612--
613-- Struttura della tabella `playerhistory`
614--
615
616CREATE TABLE IF NOT EXISTS `playerhistory` (
617 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
618 `amount` smallint(5) unsigned NOT NULL DEFAULT '0',
619 `recorded` date NOT NULL,
620 PRIMARY KEY (`id`)
621) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=896 ;
622
623-- --------------------------------------------------------
624
625--
626-- Struttura della tabella `playerhistory_hourly_new`
627--
628
629CREATE TABLE IF NOT EXISTS `playerhistory_hourly_new` (
630 `hour` datetime NOT NULL,
631 `value` smallint(5) unsigned NOT NULL DEFAULT '0',
632 PRIMARY KEY (`hour`),
633 KEY `hour` (`hour`)
634) ENGINE=InnoDB DEFAULT CHARSET=ascii;
635
636-- --------------------------------------------------------
637
638--
639-- Struttura della tabella `playerhistory_joined`
640--
641
642CREATE TABLE IF NOT EXISTS `playerhistory_joined` (
643 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
644 `amount` smallint(5) unsigned NOT NULL DEFAULT '0',
645 `recorded` date NOT NULL,
646 PRIMARY KEY (`id`)
647) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=521 ;
648
649-- --------------------------------------------------------
650
651--
652-- Struttura della tabella `playeritems_2`
653--
654
655CREATE TABLE IF NOT EXISTS `playeritems_2` (
656 `id` int(10) unsigned NOT NULL,
657 `item` varchar(30) CHARACTER SET ascii NOT NULL,
658 `equipped` tinyint(1) NOT NULL DEFAULT '0',
659 `modifiers` text CHARACTER SET ascii NOT NULL,
660 UNIQUE KEY `unique` (`id`,`item`),
661 KEY `fk_id_items` (`id`)
662) ENGINE=InnoDB DEFAULT CHARSET=utf8;
663
664-- --------------------------------------------------------
665
666--
667-- Struttura della tabella `playeritems_new`
668--
669
670CREATE TABLE IF NOT EXISTS `playeritems_new` (
671 `id` int(10) unsigned NOT NULL,
672 `item` varchar(30) NOT NULL,
673 UNIQUE KEY `unique` (`id`,`item`),
674 KEY `fk_id_items` (`id`)
675) ENGINE=InnoDB DEFAULT CHARSET=utf8;
676
677-- --------------------------------------------------------
678
679--
680-- Struttura della tabella `playertransactions`
681--
682
683CREATE TABLE IF NOT EXISTS `playertransactions` (
684 `transid` int(11) NOT NULL AUTO_INCREMENT,
685 `pid` int(11) unsigned NOT NULL,
686 `time` datetime NOT NULL,
687 `type` enum('tokens') NOT NULL,
688 `amount` int(11) NOT NULL,
689 `sum` int(10) unsigned NOT NULL,
690 `comment` tinytext NOT NULL,
691 PRIMARY KEY (`transid`),
692 KEY `id` (`pid`)
693) ENGINE=InnoDB DEFAULT CHARSET=ascii AUTO_INCREMENT=120547 ;
694
695-- --------------------------------------------------------
696
697--
698-- Struttura della tabella `playerweapons`
699--
700
701CREATE TABLE IF NOT EXISTS `playerweapons` (
702 `id` int(10) unsigned NOT NULL,
703 `class` varchar(30) CHARACTER SET ascii NOT NULL,
704 `holstered` tinyint(1) NOT NULL DEFAULT '0',
705 UNIQUE KEY `id` (`id`,`class`),
706 KEY `fk_id_items` (`id`)
707) ENGINE=InnoDB DEFAULT CHARSET=utf8;
708
709-- --------------------------------------------------------
710
711--
712-- Struttura della tabella `playerweapons_bkp`
713--
714
715CREATE TABLE IF NOT EXISTS `playerweapons_bkp` (
716 `id` int(10) unsigned NOT NULL,
717 `class` varchar(30) CHARACTER SET ascii NOT NULL,
718 UNIQUE KEY `id` (`id`,`class`),
719 KEY `fk_id_items` (`id`)
720) ENGINE=InnoDB DEFAULT CHARSET=utf8;
721
722-- --------------------------------------------------------
723
724--
725-- Struttura della tabella `playerweapons_bkp2`
726--
727
728CREATE TABLE IF NOT EXISTS `playerweapons_bkp2` (
729 `id` int(10) unsigned NOT NULL,
730 `class` varchar(30) CHARACTER SET ascii NOT NULL,
731 `holstered` tinyint(1) NOT NULL DEFAULT '0',
732 UNIQUE KEY `id` (`id`,`class`),
733 KEY `fk_id_items` (`id`)
734) ENGINE=InnoDB DEFAULT CHARSET=utf8;
735
736-- --------------------------------------------------------
737
738--
739-- Struttura della tabella `propstatistics`
740--
741
742CREATE TABLE IF NOT EXISTS `propstatistics` (
743 `model` varchar(255) NOT NULL,
744 `spawns` int(10) unsigned NOT NULL DEFAULT '1',
745 PRIMARY KEY (`model`),
746 KEY `model` (`model`)
747) ENGINE=InnoDB DEFAULT CHARSET=ascii;
748
749-- --------------------------------------------------------
750
751--
752-- Struttura della tabella `servers`
753--
754
755CREATE TABLE IF NOT EXISTS `servers` (
756 `ipport` varchar(21) NOT NULL
757) ENGINE=InnoDB DEFAULT CHARSET=ascii;
758
759-- --------------------------------------------------------
760
761--
762-- Struttura della tabella `songs`
763--
764
765CREATE TABLE IF NOT EXISTS `songs` (
766 `urlid` varchar(20) NOT NULL,
767 `title` varchar(100) NOT NULL,
768 `length` smallint(5) unsigned NOT NULL DEFAULT '0',
769 `type` enum('fast','slow','custom') NOT NULL DEFAULT 'custom',
770 `added` datetime NOT NULL DEFAULT '2014-12-31 00:00:00',
771 `uploader` varchar(19) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
772 `removed` tinyint(1) NOT NULL DEFAULT '0',
773 PRIMARY KEY (`urlid`),
774 KEY `title` (`title`)
775) ENGINE=InnoDB DEFAULT CHARSET=ascii;
776
777-- --------------------------------------------------------
778
779--
780-- Struttura della tabella `songs_new`
781--
782
783CREATE TABLE IF NOT EXISTS `songs_new` (
784 `urlid` varchar(20) NOT NULL,
785 `title` varchar(100) NOT NULL,
786 `length` smallint(5) unsigned NOT NULL DEFAULT '0',
787 `autoplay` tinyint(1) NOT NULL DEFAULT '0',
788 `autoplay_phases` smallint(6) unsigned NOT NULL DEFAULT '0',
789 `autoplay_events` text,
790 `added` datetime NOT NULL DEFAULT '2014-12-31 00:00:00',
791 `uploader` varchar(19) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
792 `removed` tinyint(1) NOT NULL DEFAULT '0',
793 PRIMARY KEY (`urlid`),
794 KEY `title` (`title`)
795) ENGINE=InnoDB DEFAULT CHARSET=ascii;
796
797-- --------------------------------------------------------
798
799--
800-- Struttura della tabella `teamspeak`
801--
802
803CREATE TABLE IF NOT EXISTS `teamspeak` (
804 `uid` varchar(64) NOT NULL,
805 `steamid` varchar(19) NOT NULL,
806 PRIMARY KEY (`uid`),
807 KEY `steamid` (`steamid`)
808) ENGINE=InnoDB DEFAULT CHARSET=ascii;
809
810-- --------------------------------------------------------
811
812--
813-- Struttura della tabella `u_globalbans`
814--
815
816CREATE TABLE IF NOT EXISTS `u_globalbans` (
817 `banid` int(10) unsigned NOT NULL AUTO_INCREMENT,
818 `steamid` varchar(19) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
819 `name` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
820 `unban` int(10) unsigned NOT NULL,
821 `bannedat` int(10) unsigned NOT NULL,
822 `admin` varchar(32) CHARACTER SET utf8 NOT NULL,
823 `adminsteamid` varchar(19) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
824 `modifieddate` int(11) NOT NULL,
825 `modifiedsteamid` varchar(19) NOT NULL,
826 `reason` tinytext NOT NULL,
827 `cluster` set('flood','jailbreak') NOT NULL,
828 `removed` tinyint(1) NOT NULL DEFAULT '0',
829 PRIMARY KEY (`banid`),
830 KEY `bannedat` (`bannedat`)
831) ENGINE=InnoDB DEFAULT CHARSET=ascii AUTO_INCREMENT=2527 ;
832
833-- --------------------------------------------------------
834
835--
836-- Struttura della tabella `weaponprices`
837--
838
839CREATE TABLE IF NOT EXISTS `weaponprices` (
840 `weapon` varchar(30) NOT NULL,
841 `price` int(10) unsigned NOT NULL,
842 PRIMARY KEY (`weapon`)
843) ENGINE=InnoDB DEFAULT CHARSET=ascii;
844
845-- --------------------------------------------------------
846
847--
848-- Struttura della tabella `wepusagestatistics`
849--
850
851CREATE TABLE IF NOT EXISTS `wepusagestatistics` (
852 `id` int(10) unsigned NOT NULL,
853 `class` varchar(30) NOT NULL,
854 `usages` mediumint(8) unsigned NOT NULL DEFAULT '1',
855 UNIQUE KEY `id` (`id`,`class`)
856) ENGINE=InnoDB DEFAULT CHARSET=ascii;
857
858-- --------------------------------------------------------
859
860--
861-- Struttura della tabella `wordfilter_translations`
862--
863
864CREATE TABLE IF NOT EXISTS `wordfilter_translations` (
865 `source` varchar(10) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
866 `translation` varchar(10) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
867 PRIMARY KEY (`source`,`translation`)
868) ENGINE=InnoDB DEFAULT CHARSET=ascii;
869
870-- --------------------------------------------------------
871
872--
873-- Struttura della tabella `wordfilter_words`
874--
875
876CREATE TABLE IF NOT EXISTS `wordfilter_words` (
877 `word` varchar(20) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
878 PRIMARY KEY (`word`)
879) ENGINE=InnoDB DEFAULT CHARSET=ascii;
880
881--
882-- Limiti per le tabelle scaricate
883--
884
885--
886-- Limiti per la tabella `achievements_new`
887--
888ALTER TABLE `achievements_new`
889 ADD CONSTRAINT `fk_id` FOREIGN KEY (`id`) REFERENCES `playerdata` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
890
891--
892-- Limiti per la tabella `playeractivity`
893--
894ALTER TABLE `playeractivity`
895 ADD CONSTRAINT `playeractivity_ibfk_1` FOREIGN KEY (`id`) REFERENCES `playerdata` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
896
897--
898-- Limiti per la tabella `playerextras`
899--
900ALTER TABLE `playerextras`
901 ADD CONSTRAINT `playerextras_ibfk_1` FOREIGN KEY (`id`) REFERENCES `playerdata` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
902
903--
904-- Limiti per la tabella `playeritems_new`
905--
906ALTER TABLE `playeritems_new`
907 ADD CONSTRAINT `fk_id_items` FOREIGN KEY (`id`) REFERENCES `playerdata` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
908
909--
910-- Limiti per la tabella `playertransactions`
911--
912ALTER TABLE `playertransactions`
913 ADD CONSTRAINT `fk_transaction_pid` FOREIGN KEY (`pid`) REFERENCES `playerdata` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
914
915--
916-- Limiti per la tabella `playerweapons`
917--
918ALTER TABLE `playerweapons`
919 ADD CONSTRAINT `fk_weapons_id` FOREIGN KEY (`id`) REFERENCES `playerdata` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
920
921--
922-- Limiti per la tabella `wepusagestatistics`
923--
924ALTER TABLE `wepusagestatistics`
925 ADD CONSTRAINT `wepusagestatistics_ibfk_1` FOREIGN KEY (`id`) REFERENCES `playerdata` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
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 */;