· 7 years ago · Nov 18, 2018, 01:18 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : Windows Server
5Source Server Version : 50151
6Source Host : st0rm.net:3306
7Source Database : st0rmserv
8
9Target Server Type : MYSQL
10Target Server Version : 50151
11File Encoding : 65001
12
13Date: 2012-09-10 21:38:22
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `achievements`
20-- ----------------------------
21DROP TABLE IF EXISTS `achievements`;
22CREATE TABLE `achievements` (
23 `achievement_id` varchar(20) NOT NULL DEFAULT '',
24 `level` int(1) NOT NULL DEFAULT '0',
25 `points` int(5) DEFAULT NULL,
26 `image` varchar(50) DEFAULT NULL,
27 `achievement_name` text NOT NULL,
28 `max_points` int(3) DEFAULT NULL,
29 `desc` text NOT NULL,
30 `req` int(4) DEFAULT NULL,
31 PRIMARY KEY (`achievement_id`,`level`)
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33
34-- ----------------------------
35-- Table structure for `adminmodules`
36-- ----------------------------
37DROP TABLE IF EXISTS `adminmodules`;
38CREATE TABLE `adminmodules` (
39 `name` varchar(100) NOT NULL,
40 `enabled` int(1) DEFAULT '1',
41 PRIMARY KEY (`name`)
42) ENGINE=MyISAM DEFAULT CHARSET=latin1;
43
44-- ----------------------------
45-- Table structure for `aliases`
46-- ----------------------------
47DROP TABLE IF EXISTS `aliases`;
48CREATE TABLE `aliases` (
49 `alias` text NOT NULL,
50 `definition` text NOT NULL
51) ENGINE=MyISAM DEFAULT CHARSET=latin1;
52
53-- ----------------------------
54-- Table structure for `bans`
55-- ----------------------------
56DROP TABLE IF EXISTS `bans`;
57CREATE TABLE `bans` (
58 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
59 `name` varchar(50) DEFAULT NULL,
60 `ip` varchar(15) DEFAULT NULL,
61 `serial` varchar(64) DEFAULT '0',
62 `time_placed` varchar(30) DEFAULT '0',
63 `time_expires` varchar(30) DEFAULT '0',
64 `reason` text,
65 PRIMARY KEY (`id`)
66) ENGINE=MyISAM AUTO_INCREMENT=5346 DEFAULT CHARSET=latin1;
67
68-- ----------------------------
69-- Table structure for `bans_copy-2008-sep12`
70-- ----------------------------
71DROP TABLE IF EXISTS `bans_copy-2008-sep12`;
72CREATE TABLE `bans_copy-2008-sep12` (
73 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
74 `name` varchar(50) DEFAULT NULL,
75 `ip` varchar(15) DEFAULT NULL,
76 `serial` varchar(64) DEFAULT NULL,
77 `time_placed` varchar(30) DEFAULT '0',
78 `time_expires` varchar(30) DEFAULT '0',
79 `reason` text,
80 PRIMARY KEY (`id`)
81) ENGINE=MyISAM AUTO_INCREMENT=1296 DEFAULT CHARSET=latin1;
82
83-- ----------------------------
84-- Table structure for `bans_copy-2009-nov11`
85-- ----------------------------
86DROP TABLE IF EXISTS `bans_copy-2009-nov11`;
87CREATE TABLE `bans_copy-2009-nov11` (
88 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
89 `name` varchar(50) DEFAULT NULL,
90 `ip` varchar(15) DEFAULT NULL,
91 `serial` varchar(64) DEFAULT NULL,
92 `time_placed` varchar(30) DEFAULT '0',
93 `time_expires` varchar(30) DEFAULT '0',
94 `reason` text,
95 PRIMARY KEY (`id`)
96) ENGINE=MyISAM AUTO_INCREMENT=3324 DEFAULT CHARSET=latin1;
97
98-- ----------------------------
99-- Table structure for `bans_copy-2009-nov12`
100-- ----------------------------
101DROP TABLE IF EXISTS `bans_copy-2009-nov12`;
102CREATE TABLE `bans_copy-2009-nov12` (
103 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
104 `name` varchar(50) DEFAULT NULL,
105 `ip` varchar(15) DEFAULT NULL,
106 `serial` varchar(64) DEFAULT NULL,
107 `time_placed` varchar(30) DEFAULT '0',
108 `time_expires` varchar(30) DEFAULT '0',
109 `reason` text,
110 PRIMARY KEY (`id`)
111) ENGINE=MyISAM AUTO_INCREMENT=3326 DEFAULT CHARSET=latin1;
112
113-- ----------------------------
114-- Table structure for `fame`
115-- ----------------------------
116DROP TABLE IF EXISTS `fame`;
117CREATE TABLE `fame` (
118 `name` varchar(50) NOT NULL,
119 `fame` int(11) DEFAULT '0',
120 `last_famed` varchar(15) DEFAULT '0',
121 PRIMARY KEY (`name`)
122) ENGINE=MyISAM DEFAULT CHARSET=latin1;
123
124-- ----------------------------
125-- Table structure for `items`
126-- ----------------------------
127DROP TABLE IF EXISTS `items`;
128CREATE TABLE `items` (
129 `item` varchar(255) NOT NULL,
130 `gdicin` text NOT NULL,
131 `neucin` text NOT NULL,
132 `nodcin` text NOT NULL,
133 `cost` int(5) DEFAULT NULL,
134 `rank` int(6) DEFAULT NULL,
135 `itemname` text NOT NULL,
136 `maps` varchar(500) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
137 `servers` varchar(500) NOT NULL,
138 `type` int(1) DEFAULT NULL COMMENT '1 = Weapon, 2 = Powerup, 3 = Vehicle, 4 = Misc',
139 `alliescin` text NOT NULL,
140 `sovietscin` text NOT NULL,
141 PRIMARY KEY (`item`(20))
142) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 27648 kB';
143
144-- ----------------------------
145-- Table structure for `join_messages`
146-- ----------------------------
147DROP TABLE IF EXISTS `join_messages`;
148CREATE TABLE `join_messages` (
149 `name` varchar(50) NOT NULL,
150 `message` text,
151 PRIMARY KEY (`name`)
152) ENGINE=MyISAM DEFAULT CHARSET=latin1;
153
154-- ----------------------------
155-- Table structure for `ladder`
156-- ----------------------------
157DROP TABLE IF EXISTS `ladder`;
158CREATE TABLE `ladder` (
159 `rank` int(11) NOT NULL AUTO_INCREMENT,
160 `name` varchar(50) NOT NULL,
161 `score` int(11) DEFAULT NULL,
162 `kills` int(11) DEFAULT NULL,
163 `deaths` int(11) DEFAULT NULL,
164 `games` int(11) DEFAULT NULL,
165 `mvps` int(11) DEFAULT NULL,
166 PRIMARY KEY (`rank`)
167) ENGINE=MyISAM AUTO_INCREMENT=1707 DEFAULT CHARSET=latin1;
168
169-- ----------------------------
170-- Table structure for `mods`
171-- ----------------------------
172DROP TABLE IF EXISTS `mods`;
173CREATE TABLE `mods` (
174 `name` varchar(50) NOT NULL,
175 `flags` varchar(30) NOT NULL,
176 `ip` varchar(15) DEFAULT NULL,
177 `last_login` int(30) DEFAULT '0',
178 `suspended` int(1) DEFAULT '0',
179 `password` text,
180 PRIMARY KEY (`name`)
181) ENGINE=MyISAM DEFAULT CHARSET=latin1;
182
183-- ----------------------------
184-- Table structure for `mods_copy`
185-- ----------------------------
186DROP TABLE IF EXISTS `mods_copy`;
187CREATE TABLE `mods_copy` (
188 `name` varchar(50) NOT NULL,
189 `flags` varchar(30) NOT NULL,
190 `ip` varchar(15) DEFAULT NULL,
191 `last_login` int(30) DEFAULT '0',
192 `suspended` int(1) DEFAULT '0',
193 `password` text,
194 PRIMARY KEY (`name`)
195) ENGINE=MyISAM DEFAULT CHARSET=latin1;
196
197-- ----------------------------
198-- Table structure for `mods_copy1`
199-- ----------------------------
200DROP TABLE IF EXISTS `mods_copy1`;
201CREATE TABLE `mods_copy1` (
202 `name` varchar(50) NOT NULL,
203 `flags` varchar(30) NOT NULL,
204 `ip` varchar(15) DEFAULT NULL,
205 `last_login` int(30) DEFAULT '0',
206 `suspended` int(1) DEFAULT '0',
207 `password` text,
208 PRIMARY KEY (`name`)
209) ENGINE=MyISAM DEFAULT CHARSET=latin1;
210
211-- ----------------------------
212-- Table structure for `modules`
213-- ----------------------------
214DROP TABLE IF EXISTS `modules`;
215CREATE TABLE `modules` (
216 `name` varchar(100) NOT NULL,
217 `enabled` int(1) DEFAULT '1',
218 PRIMARY KEY (`name`)
219) ENGINE=MyISAM DEFAULT CHARSET=latin1;
220
221-- ----------------------------
222-- Table structure for `music`
223-- ----------------------------
224DROP TABLE IF EXISTS `music`;
225CREATE TABLE `music` (
226 `song` text NOT NULL,
227 `file` varchar(50) NOT NULL,
228 `length` decimal(10,0) NOT NULL,
229 PRIMARY KEY (`file`)
230) ENGINE=MyISAM DEFAULT CHARSET=latin1;
231
232-- ----------------------------
233-- Table structure for `music_copy`
234-- ----------------------------
235DROP TABLE IF EXISTS `music_copy`;
236CREATE TABLE `music_copy` (
237 `song` text NOT NULL,
238 `file` varchar(50) NOT NULL,
239 `length` decimal(10,0) NOT NULL,
240 PRIMARY KEY (`file`)
241) ENGINE=MyISAM DEFAULT CHARSET=latin1;
242
243-- ----------------------------
244-- Table structure for `music2`
245-- ----------------------------
246DROP TABLE IF EXISTS `music2`;
247CREATE TABLE `music2` (
248 `song` text NOT NULL,
249 `file` varchar(50) NOT NULL,
250 `length` decimal(10,0) NOT NULL,
251 PRIMARY KEY (`file`)
252) ENGINE=MyISAM DEFAULT CHARSET=latin1;
253
254-- ----------------------------
255-- Table structure for `musicnew`
256-- ----------------------------
257DROP TABLE IF EXISTS `musicnew`;
258CREATE TABLE `musicnew` (
259 `song` text NOT NULL,
260 `file` varchar(50) NOT NULL,
261 `length` decimal(10,0) NOT NULL,
262 PRIMARY KEY (`file`)
263) ENGINE=MyISAM DEFAULT CHARSET=latin1;
264
265-- ----------------------------
266-- Table structure for `offenses`
267-- ----------------------------
268DROP TABLE IF EXISTS `offenses`;
269CREATE TABLE `offenses` (
270 `case` int(11) NOT NULL AUTO_INCREMENT,
271 `name` varchar(50) NOT NULL,
272 `time` varchar(30) DEFAULT '0',
273 `ip` varchar(15) DEFAULT '255.255.255.255',
274 `data` text,
275 PRIMARY KEY (`case`)
276) ENGINE=MyISAM AUTO_INCREMENT=25919 DEFAULT CHARSET=latin1;
277
278-- ----------------------------
279-- Table structure for `oldladder`
280-- ----------------------------
281DROP TABLE IF EXISTS `oldladder`;
282CREATE TABLE `oldladder` (
283 `rank` int(11) NOT NULL AUTO_INCREMENT,
284 `name` varchar(50) NOT NULL,
285 `score` int(11) DEFAULT NULL,
286 `kills` int(11) DEFAULT NULL,
287 `deaths` int(11) DEFAULT NULL,
288 `games` int(11) DEFAULT NULL,
289 `mvps` int(11) DEFAULT NULL,
290 PRIMARY KEY (`rank`)
291) ENGINE=MyISAM AUTO_INCREMENT=2440 DEFAULT CHARSET=latin1;
292
293-- ----------------------------
294-- Table structure for `oldladder2`
295-- ----------------------------
296DROP TABLE IF EXISTS `oldladder2`;
297CREATE TABLE `oldladder2` (
298 `rank` int(11) NOT NULL AUTO_INCREMENT,
299 `name` varchar(50) NOT NULL,
300 `score` int(11) DEFAULT NULL,
301 `kills` int(11) DEFAULT NULL,
302 `deaths` int(11) DEFAULT NULL,
303 `games` int(11) DEFAULT NULL,
304 `mvps` int(11) DEFAULT NULL,
305 PRIMARY KEY (`rank`)
306) ENGINE=MyISAM AUTO_INCREMENT=889 DEFAULT CHARSET=latin1;
307
308-- ----------------------------
309-- Table structure for `rank_table`
310-- ----------------------------
311DROP TABLE IF EXISTS `rank_table`;
312CREATE TABLE `rank_table` (
313 `name` text NOT NULL,
314 `min_points` int(11) NOT NULL DEFAULT '0',
315 `max_points` int(11) NOT NULL DEFAULT '0',
316 `credits` int(5) DEFAULT NULL
317) ENGINE=MyISAM DEFAULT CHARSET=latin1;
318
319-- ----------------------------
320-- Table structure for `rank_table_new`
321-- ----------------------------
322DROP TABLE IF EXISTS `rank_table_new`;
323CREATE TABLE `rank_table_new` (
324 `name` text NOT NULL,
325 `min_points` int(11) NOT NULL DEFAULT '0',
326 `max_points` int(11) NOT NULL DEFAULT '0',
327 `credits` int(5) DEFAULT NULL
328) ENGINE=MyISAM DEFAULT CHARSET=latin1;
329
330-- ----------------------------
331-- Table structure for `ranks`
332-- ----------------------------
333DROP TABLE IF EXISTS `ranks`;
334CREATE TABLE `ranks` (
335 `name` varchar(50) NOT NULL,
336 `rank` int(11) DEFAULT '0',
337 `banned` int(1) DEFAULT '0',
338 `bkills` int(5) DEFAULT '0',
339 `pkills` int(5) DEFAULT '0',
340 `vkills` int(5) DEFAULT '0',
341 `NBP` int(5) DEFAULT '0',
342 `IBP` int(5) DEFAULT '0',
343 `NBH` int(5) DEFAULT '0',
344 `IBH` int(5) DEFAULT '0',
345 `NBD` int(5) DEFAULT '0',
346 `IBD` int(5) DEFAULT '0',
347 `ProxyP` int(5) DEFAULT '0',
348 `ProxyD` int(5) DEFAULT '0',
349 `ProxyK` int(5) DEFAULT '0',
350 `cRank` text,
351 `a_marksman` int(1) DEFAULT '0',
352 `a_oneshotonekill` int(1) DEFAULT '0',
353 `a_doublekill` int(1) DEFAULT '0',
354 `a_triplekill` int(1) DEFAULT '0',
355 `a_megakill` int(1) DEFAULT '0',
356 `a_proxyking` int(1) DEFAULT '0',
357 `a_tankbuster` int(1) DEFAULT '0',
358 `a_tankdestroyer` int(1) DEFAULT '0',
359 `a_igapfy` int(1) DEFAULT '0',
360 `a_orbitalprecision` int(1) DEFAULT '0',
361 `a_tacticalnuke` int(1) DEFAULT '0',
362 `a_superweapon` int(1) DEFAULT '0',
363 `a_minesweeper` int(1) DEFAULT '0',
364 `a_rocketsniper` int(1) DEFAULT '0',
365 `a_gotahelmet` int(1) DEFAULT '0',
366 `a_pistolwhipped` int(1) DEFAULT '0',
367 `a_wbc` int(1) DEFAULT '0',
368 `a_mvp` int(1) DEFAULT '0',
369 `a_runningrampage` int(1) DEFAULT '0',
370 `a_serialkiller` int(1) DEFAULT '0',
371 `a_wthatre` int(1) DEFAULT '0',
372 `a_bobbuild` int(1) DEFAULT '0',
373 `a_roadkill` int(1) DEFAULT '0',
374 `a_ftbh` int(1) DEFAULT '0',
375 `a_medic` int(1) DEFAULT '0',
376 `a_mechanic` int(1) DEFAULT '0',
377 `a_recentlybandaged` int(1) DEFAULT '0',
378 `a_heavyhitter` int(1) DEFAULT '0',
379 `a_teaminvest` int(1) DEFAULT '0',
380 `a_philanthropist` int(1) DEFAULT '0',
381 `a_investbank` int(1) DEFAULT '0',
382 `a_classmaster` int(1) DEFAULT '0',
383 `a_knowyourenemy` int(1) DEFAULT '0',
384 `a_ihavenofriends` int(1) DEFAULT '0',
385 `a_famous` int(1) DEFAULT '0',
386 `a_bountyhunter` int(1) DEFAULT '0',
387 `a_ctf` int(1) DEFAULT '0',
388 `a_flagmaster` int(1) DEFAULT '0',
389 `a_greet` int(1) DEFAULT '0',
390 `a_spiderstomp` int(1) DEFAULT '0',
391 `a_overlord` int(1) DEFAULT '0',
392 `a_arac` int(1) DEFAULT '0',
393 `a_death` int(1) DEFAULT '0',
394 `a_escape` int(1) DEFAULT '0',
395 `a_raid` int(1) DEFAULT '0',
396 `a_deathfromabove` int(1) DEFAULT '0',
397 `a_nolife` int(1) DEFAULT '0',
398 `a_nfhavoc` int(1) DEFAULT '0',
399 `a_beaconsniffer` int(1) DEFAULT '0',
400 `a_beaconspecial` int(1) DEFAULT '0',
401 `a_ninja` int(1) DEFAULT '0',
402 `a_tibspecial` int(1) DEFAULT '0',
403 `a_demospecial` int(1) DEFAULT '0',
404 `a_nod` int(1) DEFAULT '0',
405 `a_gdi` int(1) DEFAULT '0',
406 `a_epicfail` int(1) DEFAULT '0',
407 `airkills` int(5) DEFAULT '0',
408 `a_ttp` int(1) DEFAULT '0',
409 `sbhkills` int(5) DEFAULT '0',
410 `tibkills` int(5) DEFAULT '0',
411 PRIMARY KEY (`name`)
412) ENGINE=MyISAM DEFAULT CHARSET=latin1;
413
414-- ----------------------------
415-- Table structure for `ranks_copy`
416-- ----------------------------
417DROP TABLE IF EXISTS `ranks_copy`;
418CREATE TABLE `ranks_copy` (
419 `name` varchar(50) NOT NULL,
420 `rank` int(11) DEFAULT '0',
421 `banned` int(1) DEFAULT '0',
422 `bkills` int(5) DEFAULT '0',
423 `pkills` int(5) DEFAULT '0',
424 `vkills` int(5) DEFAULT '0',
425 `NBP` int(5) DEFAULT '0',
426 `IBP` int(5) DEFAULT '0',
427 `NBH` int(5) DEFAULT '0',
428 `IBH` int(5) DEFAULT '0',
429 `NBD` int(5) DEFAULT '0',
430 `IBD` int(5) DEFAULT '0',
431 `ProxyP` int(5) DEFAULT '0',
432 `ProxyD` int(5) DEFAULT '0',
433 `ProxyK` int(5) DEFAULT '0',
434 `cRank` text,
435 `a_marksman` int(1) DEFAULT '0',
436 `a_oneshotonekill` int(1) DEFAULT '0',
437 `a_doublekill` int(1) DEFAULT '0',
438 `a_triplekill` int(1) DEFAULT '0',
439 `a_megakill` int(1) DEFAULT '0',
440 `a_proxyking` int(1) DEFAULT '0',
441 `a_tankbuster` int(1) DEFAULT '0',
442 `a_tankdestroyer` int(1) DEFAULT '0',
443 `a_igapfy` int(1) DEFAULT '0',
444 `a_orbitalprecision` int(1) DEFAULT '0',
445 `a_tacticalnuke` int(1) DEFAULT '0',
446 `a_superweapon` int(1) DEFAULT '0',
447 `a_minesweeper` int(1) DEFAULT '0',
448 `a_rocketsniper` int(1) DEFAULT '0',
449 `a_gotahelmet` int(1) DEFAULT '0',
450 `a_pistolwhipped` int(1) DEFAULT '0',
451 `a_wbc` int(1) DEFAULT '0',
452 `a_mvp` int(1) DEFAULT '0',
453 `a_runningrampage` int(1) DEFAULT '0',
454 `a_serialkiller` int(1) DEFAULT '0',
455 `a_wthatre` int(1) DEFAULT '0',
456 `a_bobbuild` int(1) DEFAULT '0',
457 `a_roadkill` int(1) DEFAULT '0',
458 `a_ftbh` int(1) DEFAULT '0',
459 `a_medic` int(1) DEFAULT '0',
460 `a_mechanic` int(1) DEFAULT '0',
461 `a_recentlybandaged` int(1) DEFAULT '0',
462 `a_heavyhitter` int(1) DEFAULT '0',
463 `a_teaminvest` int(1) DEFAULT '0',
464 `a_philanthropist` int(1) DEFAULT '0',
465 `a_investbank` int(1) DEFAULT '0',
466 `a_classmaster` int(1) DEFAULT '0',
467 `a_knowyourenemy` int(1) DEFAULT '0',
468 `a_ihavenofriends` int(1) DEFAULT '0',
469 `a_famous` int(1) DEFAULT '0',
470 `a_bountyhunter` int(1) DEFAULT '0',
471 `a_ctf` int(1) DEFAULT '0',
472 `a_flagmaster` int(1) DEFAULT '0',
473 `a_greet` int(1) DEFAULT '0',
474 `a_spiderstomp` int(1) DEFAULT '0',
475 `a_overlord` int(1) DEFAULT '0',
476 `a_arac` int(1) DEFAULT '0',
477 `a_death` int(1) DEFAULT '0',
478 `a_escape` int(1) DEFAULT '0',
479 `a_raid` int(1) DEFAULT '0',
480 `a_deathfromabove` int(1) DEFAULT '0',
481 `a_nolife` int(1) DEFAULT '0',
482 `a_nfhavoc` int(1) DEFAULT '0',
483 `a_beaconsniffer` int(1) DEFAULT '0',
484 `a_beaconspecial` int(1) DEFAULT '0',
485 `a_ninja` int(1) DEFAULT '0',
486 `a_tibspecial` int(1) DEFAULT '0',
487 `a_demospecial` int(1) DEFAULT '0',
488 `a_nod` int(1) DEFAULT '0',
489 `a_gdi` int(1) DEFAULT '0',
490 `a_epicfail` int(1) DEFAULT '0',
491 `airkills` int(5) DEFAULT '0',
492 `a_ttp` int(1) DEFAULT '0',
493 `sbhkills` int(5) DEFAULT '0',
494 `tibkills` int(5) DEFAULT '0',
495 PRIMARY KEY (`name`)
496) ENGINE=MyISAM DEFAULT CHARSET=latin1;
497
498-- ----------------------------
499-- Table structure for `ranks_new`
500-- ----------------------------
501DROP TABLE IF EXISTS `ranks_new`;
502CREATE TABLE `ranks_new` (
503 `name` varchar(50) NOT NULL,
504 `rank` int(11) DEFAULT '0',
505 `banned` int(1) DEFAULT '0',
506 `bkills` int(5) DEFAULT '0',
507 `pkills` int(5) DEFAULT '0',
508 `vkills` int(5) DEFAULT '0',
509 `NBP` int(5) DEFAULT '0',
510 `IBP` int(5) DEFAULT '0',
511 `NBH` int(5) DEFAULT '0',
512 `IBH` int(5) DEFAULT '0',
513 `NBD` int(5) DEFAULT '0',
514 `IBD` int(5) DEFAULT '0',
515 `ProxyP` int(5) DEFAULT '0',
516 `ProxyD` int(5) DEFAULT '0',
517 `ProxyK` int(5) DEFAULT '0',
518 `cRank` text,
519 `a_marksman` int(1) DEFAULT '0',
520 `a_oneshotonekill` int(1) DEFAULT '0',
521 `a_doublekill` int(1) DEFAULT '0',
522 `a_triplekill` int(1) DEFAULT '0',
523 `a_megakill` int(1) DEFAULT '0',
524 `a_proxyking` int(1) DEFAULT '0',
525 `a_tankbuster` int(1) DEFAULT '0',
526 `a_tankdestroyer` int(1) DEFAULT '0',
527 `a_igapfy` int(1) DEFAULT '0',
528 `a_orbitalprecision` int(1) DEFAULT '0',
529 `a_tacticalnuke` int(1) DEFAULT '0',
530 `a_superweapon` int(1) DEFAULT '0',
531 `a_minesweeper` int(1) DEFAULT '0',
532 `a_rocketsniper` int(1) DEFAULT '0',
533 `a_gotahelmet` int(1) DEFAULT '0',
534 `a_pistolwhipped` int(1) DEFAULT '0',
535 `a_wbc` int(1) DEFAULT '0',
536 `a_mvp` int(1) DEFAULT '0',
537 `a_runningrampage` int(1) DEFAULT '0',
538 `a_serialkiller` int(1) DEFAULT '0',
539 `a_wthatre` int(1) DEFAULT '0',
540 `a_bobbuild` int(1) DEFAULT '0',
541 `a_roadkill` int(1) DEFAULT '0',
542 `a_ftbh` int(1) DEFAULT '0',
543 `a_medic` int(1) DEFAULT '0',
544 `a_mechanic` int(1) DEFAULT '0',
545 `a_recentlybandaged` int(1) DEFAULT '0',
546 `a_heavyhitter` int(1) DEFAULT '0',
547 `a_teaminvest` int(1) DEFAULT '0',
548 `a_philanthropist` int(1) DEFAULT '0',
549 `a_investbank` int(1) DEFAULT '0',
550 `a_classmaster` int(1) DEFAULT '0',
551 `a_knowyourenemy` int(1) DEFAULT '0',
552 `a_ihavenofriends` int(1) DEFAULT '0',
553 `a_famous` int(1) DEFAULT '0',
554 `a_bountyhunter` int(1) DEFAULT '0',
555 `a_ctf` int(1) DEFAULT '0',
556 `a_flagmaster` int(1) DEFAULT '0',
557 `a_greet` int(1) DEFAULT '0',
558 `a_spiderstomp` int(1) DEFAULT '0',
559 `a_overlord` int(1) DEFAULT '0',
560 `a_arac` int(1) DEFAULT '0',
561 `a_death` int(1) DEFAULT '0',
562 `a_escape` int(1) DEFAULT '0',
563 `a_raid` int(1) DEFAULT '0',
564 `a_deathfromabove` int(1) DEFAULT '0',
565 `a_nolife` int(1) DEFAULT '0',
566 `a_nfhavoc` int(1) DEFAULT '0',
567 `a_beaconsniffer` int(1) DEFAULT '0',
568 `a_beaconspecial` int(1) DEFAULT '0',
569 `a_ninja` int(1) DEFAULT '0',
570 `a_tibspecial` int(1) DEFAULT '0',
571 `a_demospecial` int(1) DEFAULT '0',
572 `a_nod` int(1) DEFAULT '0',
573 `a_gdi` int(1) DEFAULT '0',
574 `a_epicfail` int(1) DEFAULT '0',
575 `airkills` int(5) DEFAULT '0',
576 `a_ttp` int(1) DEFAULT '0',
577 `sbhkills` int(5) DEFAULT '0',
578 `tibkills` int(5) DEFAULT '0',
579 PRIMARY KEY (`name`)
580) ENGINE=MyISAM DEFAULT CHARSET=latin1;
581
582-- ----------------------------
583-- Table structure for `ranks2`
584-- ----------------------------
585DROP TABLE IF EXISTS `ranks2`;
586CREATE TABLE `ranks2` (
587 `name` varchar(50) NOT NULL,
588 `rank` int(11) DEFAULT '0',
589 `banned` int(1) DEFAULT '0',
590 `bkills` int(5) DEFAULT '0',
591 `pkills` int(5) DEFAULT '0',
592 `vkills` int(5) DEFAULT '0',
593 `NBP` int(5) DEFAULT '0',
594 `IBP` int(5) DEFAULT '0',
595 `NBH` int(5) DEFAULT '0',
596 `IBH` int(5) DEFAULT '0',
597 `NBD` int(5) DEFAULT '0',
598 `IBD` int(5) DEFAULT '0',
599 `ProxyP` int(5) DEFAULT '0',
600 `ProxyD` int(5) DEFAULT '0',
601 `ProxyK` int(5) DEFAULT '0',
602 `cRank` text,
603 `a_marksman` int(1) DEFAULT '0',
604 `a_oneshotonekill` int(1) DEFAULT '0',
605 `a_doublekill` int(1) DEFAULT '0',
606 `a_triplekill` int(1) DEFAULT '0',
607 `a_megakill` int(1) DEFAULT '0',
608 `a_proxyking` int(1) DEFAULT '0',
609 `a_tankbuster` int(1) DEFAULT '0',
610 `a_tankdestroyer` int(1) DEFAULT '0',
611 `a_igapfy` int(1) DEFAULT '0',
612 `a_orbitalprecision` int(1) DEFAULT '0',
613 `a_tacticalnuke` int(1) DEFAULT '0',
614 `a_superweapon` int(1) DEFAULT '0',
615 `a_minesweeper` int(1) DEFAULT '0',
616 `a_rocketsniper` int(1) DEFAULT '0',
617 `a_gotahelmet` int(1) DEFAULT '0',
618 `a_pistolwhipped` int(1) DEFAULT '0',
619 `a_wbc` int(1) DEFAULT '0',
620 `a_mvp` int(1) DEFAULT '0',
621 `a_runningrampage` int(1) DEFAULT '0',
622 `a_serialkiller` int(1) DEFAULT '0',
623 `a_wthatre` int(1) DEFAULT '0',
624 `a_bobbuild` int(1) DEFAULT '0',
625 `a_roadkill` int(1) DEFAULT '0',
626 `a_ftbh` int(1) DEFAULT '0',
627 `a_medic` int(1) DEFAULT '0',
628 `a_mechanic` int(1) DEFAULT '0',
629 `a_recentlybandaged` int(1) DEFAULT '0',
630 `a_heavyhitter` int(1) DEFAULT '0',
631 `a_teaminvest` int(1) DEFAULT '0',
632 `a_philanthropist` int(1) DEFAULT '0',
633 `a_investbank` int(1) DEFAULT '0',
634 `a_classmaster` int(1) DEFAULT '0',
635 `a_knowyourenemy` int(1) DEFAULT '0',
636 `a_ihavenofriends` int(1) DEFAULT '0',
637 `a_famous` int(1) DEFAULT '0',
638 `a_bountyhunter` int(1) DEFAULT '0',
639 `a_ctf` int(1) DEFAULT '0',
640 `a_flagmaster` int(1) DEFAULT '0',
641 `a_greet` int(1) DEFAULT '0',
642 `a_spiderstomp` int(1) DEFAULT '0',
643 `a_overlord` int(1) DEFAULT '0',
644 `a_arac` int(1) DEFAULT '0',
645 `a_death` int(1) DEFAULT '0',
646 `a_escape` int(1) DEFAULT '0',
647 `a_raid` int(1) DEFAULT '0',
648 `a_deathfromabove` int(1) DEFAULT '0',
649 `a_nolife` int(1) DEFAULT '0',
650 `a_nfhavoc` int(1) DEFAULT '0',
651 `a_beaconsniffer` int(1) DEFAULT '0',
652 `a_beaconspecial` int(1) DEFAULT '0',
653 `a_ninja` int(1) DEFAULT '0',
654 `a_tibspecial` int(1) DEFAULT '0',
655 `a_demospecial` int(1) DEFAULT '0',
656 `a_nod` int(1) DEFAULT '0',
657 `a_gdi` int(1) DEFAULT '0',
658 `a_epicfail` int(1) DEFAULT '0',
659 `airkills` int(5) DEFAULT '0',
660 `a_ttp` int(1) DEFAULT '0',
661 `sbhkills` int(5) DEFAULT '0',
662 `tibkills` int(5) DEFAULT '0',
663 `Ramjet` int(5) DEFAULT '0',
664 `AutoRifle` int(5) DEFAULT '0',
665 `Chaingun` int(5) DEFAULT '0',
666 `ChemSprayer` int(5) DEFAULT '0',
667 `FlameThrower` int(5) DEFAULT '0',
668 `GrenadeLauncher` int(5) DEFAULT '0',
669 `IonCannon` int(5) DEFAULT '0',
670 `LaserChaingun` int(5) DEFAULT '0',
671 `LaserRifle` int(5) DEFAULT '0',
672 `ProxyC4` int(5) DEFAULT '0',
673 `RemoteC4` int(5) DEFAULT '0',
674 `TimedC4` int(5) DEFAULT '0',
675 `Nuke` int(5) DEFAULT '0',
676 `PersonalIonCannon` int(5) DEFAULT '0',
677 `Pistol` int(5) DEFAULT '0',
678 `Railgun` int(5) DEFAULT NULL COMMENT '0',
679 `Repairgun` int(20) DEFAULT '0',
680 `RocketLauncher_1` int(5) DEFAULT '0',
681 `RocketLauncher_2` int(5) DEFAULT '0',
682 `Shotgun` int(5) DEFAULT '0',
683 `SniperRifle` int(5) DEFAULT '0',
684 `TiberiumAutoRifle` int(5) DEFAULT '0',
685 `TiberiumFlechette` int(5) DEFAULT '0',
686 `VoltAutoRifle` int(5) DEFAULT '0',
687 `Buggy` int(5) DEFAULT '0',
688 `Hummvee` int(5) DEFAULT '0',
689 `APC` int(5) DEFAULT '0',
690 `Arty` int(5) DEFAULT '0',
691 `MediumTank` int(5) DEFAULT '0',
692 `LightTank` int(5) DEFAULT '0',
693 `FlameTank` int(5) DEFAULT '0',
694 `StealthTank` int(5) DEFAULT '0',
695 `MammothTank` int(5) DEFAULT '0',
696 `MRLS` int(5) DEFAULT '0',
697 `Orca` int(5) DEFAULT '0',
698 `Apache` int(5) DEFAULT '0',
699 `LifeRepairs` int(15) DEFAULT '0',
700 `LifeDamage` int(15) DEFAULT '0',
701 PRIMARY KEY (`name`)
702) ENGINE=MyISAM DEFAULT CHARSET=latin1;
703
704-- ----------------------------
705-- Table structure for `seenlog`
706-- ----------------------------
707DROP TABLE IF EXISTS `seenlog`;
708CREATE TABLE `seenlog` (
709 `user` varchar(30) NOT NULL,
710 `last_ip` varchar(15) NOT NULL DEFAULT '',
711 `serial` varchar(35) DEFAULT NULL,
712 `last_seen` varchar(20) NOT NULL,
713 PRIMARY KEY (`user`)
714) ENGINE=InnoDB DEFAULT CHARSET=latin1;
715
716-- ----------------------------
717-- Table structure for `sounds`
718-- ----------------------------
719DROP TABLE IF EXISTS `sounds`;
720CREATE TABLE `sounds` (
721 `keywords` text NOT NULL,
722 `soundfile` varchar(500) NOT NULL
723) ENGINE=MyISAM DEFAULT CHARSET=latin1;
724
725-- ----------------------------
726-- Table structure for `teamfunds`
727-- ----------------------------
728DROP TABLE IF EXISTS `teamfunds`;
729CREATE TABLE `teamfunds` (
730 `team` int(1) NOT NULL DEFAULT '0',
731 `credits` int(10) DEFAULT NULL,
732 PRIMARY KEY (`team`)
733) ENGINE=InnoDB DEFAULT CHARSET=latin1;
734
735-- ----------------------------
736-- Table structure for `xp_table`
737-- ----------------------------
738DROP TABLE IF EXISTS `xp_table`;
739CREATE TABLE `xp_table` (
740 `Preset` text NOT NULL,
741 `Experience` tinyint(5) DEFAULT NULL
742) ENGINE=InnoDB DEFAULT CHARSET=latin1;
743
744-- ----------------------------
745-- Table structure for `zachievements`
746-- ----------------------------
747DROP TABLE IF EXISTS `zachievements`;
748CREATE TABLE `zachievements` (
749 `achievement_id` int(11) NOT NULL,
750 `achievement_name` varchar(50) NOT NULL,
751 `reqkills` int(11) NOT NULL,
752 PRIMARY KEY (`achievement_id`)
753) ENGINE=InnoDB DEFAULT CHARSET=latin1;