· 9 years ago · Nov 12, 2016, 03:04 AM
1-- --------------------------------------------------------
2-- Host: localhost:3306
3-- Server version: 5.5.48-cll - MySQL Community Server (GPL)
4-- Server OS: Linux
5-- HeidiSQL Version: 9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping database structure for eternalg_gtao
14CREATE DATABASE IF NOT EXISTS `eternal_gtao` /*!40100 DEFAULT CHARACTER SET latin1 */;
15USE `eternal_gtao`;
16
17
18-- Dumping structure for table eternalg_gtao.actions
19CREATE TABLE IF NOT EXISTS `actions` (
20 `id` int(11) NOT NULL AUTO_INCREMENT,
21 `transaction` int(11) NOT NULL,
22 `uid` bigint(20) DEFAULT NULL,
23 `buyer_name` varchar(50) DEFAULT NULL,
24 `actions` text,
25 `forum_claimed` int(11) DEFAULT '0',
26 `package` int(11) DEFAULT NULL,
27 `server` text,
28 `runonce` int(11) NOT NULL DEFAULT '1',
29 `updateable` int(11) NOT NULL DEFAULT '0',
30 `delivered` int(11) DEFAULT '0',
31 `active` int(11) DEFAULT '1',
32 `expiretime` date DEFAULT '0000-00-00',
33 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
34 PRIMARY KEY (`id`)
35) ENGINE=MyISAM DEFAULT CHARSET=utf8;
36
37-- Data exporting was unselected.
38
39
40-- Dumping structure for table eternalg_gtao.advent_calendar
41CREATE TABLE IF NOT EXISTS `advent_calendar` (
42 `day` int(11) NOT NULL,
43 `img` text,
44 `package` text,
45 PRIMARY KEY (`day`)
46) ENGINE=MyISAM DEFAULT CHARSET=utf8;
47
48-- Data exporting was unselected.
49
50
51-- Dumping structure for table eternalg_gtao.advent_claims
52CREATE TABLE IF NOT EXISTS `advent_claims` (
53 `id` int(11) NOT NULL AUTO_INCREMENT,
54 `adv_id` int(11) DEFAULT NULL,
55 `uid` bigint(20) DEFAULT NULL,
56 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
57 PRIMARY KEY (`id`)
58) ENGINE=MyISAM DEFAULT CHARSET=utf8;
59
60-- Data exporting was unselected.
61
62
63-- Dumping structure for table eternalg_gtao.blacklist
64CREATE TABLE IF NOT EXISTS `blacklist` (
65 `id` int(11) NOT NULL AUTO_INCREMENT,
66 `name` text NOT NULL,
67 `steam64` bigint(20) NOT NULL,
68 `steamid` varchar(64) NOT NULL,
69 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
70 PRIMARY KEY (`id`)
71) ENGINE=MyISAM DEFAULT CHARSET=utf8;
72
73-- Data exporting was unselected.
74
75
76-- Dumping structure for table eternalg_gtao.categories
77CREATE TABLE IF NOT EXISTS `categories` (
78 `id` int(11) NOT NULL AUTO_INCREMENT,
79 `order_id` int(11) DEFAULT NULL,
80 `name` varchar(50) DEFAULT NULL,
81 PRIMARY KEY (`id`)
82) ENGINE=MyISAM DEFAULT CHARSET=utf8;
83
84-- Data exporting was unselected.
85
86
87-- Dumping structure for table eternalg_gtao.coupons
88CREATE TABLE IF NOT EXISTS `coupons` (
89 `id` int(11) NOT NULL AUTO_INCREMENT,
90 `coupon` text NOT NULL,
91 `description` text,
92 `packages` text NOT NULL,
93 `percent` int(11) NOT NULL,
94 `uses` int(11) NOT NULL DEFAULT '0',
95 `max_uses` int(11) NOT NULL DEFAULT '0',
96 `expires` timestamp NULL DEFAULT NULL,
97 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
98 PRIMARY KEY (`id`)
99) ENGINE=MyISAM DEFAULT CHARSET=utf8;
100
101-- Data exporting was unselected.
102
103
104-- Dumping structure for table eternalg_gtao.credit_packages
105CREATE TABLE IF NOT EXISTS `credit_packages` (
106 `id` int(11) NOT NULL AUTO_INCREMENT,
107 `title` varchar(50) NOT NULL,
108 `descr` text NOT NULL,
109 `amount` int(11) NOT NULL,
110 `price` double NOT NULL,
111 `currency` int(11) NOT NULL,
112 PRIMARY KEY (`id`)
113) ENGINE=MyISAM DEFAULT CHARSET=utf8;
114
115-- Data exporting was unselected.
116
117
118-- Dumping structure for table eternalg_gtao.currencies
119CREATE TABLE IF NOT EXISTS `currencies` (
120 `id` int(11) NOT NULL AUTO_INCREMENT,
121 `cc` varchar(3) NOT NULL,
122 PRIMARY KEY (`id`)
123) ENGINE=MyISAM DEFAULT CHARSET=utf8;
124
125-- Data exporting was unselected.
126
127
128-- Dumping structure for table eternalg_gtao.customize_car
129CREATE TABLE IF NOT EXISTS `customize_car` (
130 `steamid` text NOT NULL,
131 `carid` text,
132 `red` text,
133 `green` text,
134 `blue` text
135) ENGINE=InnoDB DEFAULT CHARSET=latin1;
136
137-- Data exporting was unselected.
138
139
140-- Dumping structure for table eternalg_gtao.evolve_bans
141CREATE TABLE IF NOT EXISTS `evolve_bans` (
142 `uid` bigint(255) NOT NULL,
143 `steamid` varchar(255) NOT NULL,
144 `ip` varchar(255) DEFAULT NULL,
145 `lenght` bigint(255) DEFAULT NULL,
146 `banend` bigint(255) DEFAULT NULL,
147 `reason` varchar(255) NOT NULL,
148 `admin` bigint(255) NOT NULL,
149 `nick` varchar(255) NOT NULL
150) ENGINE=InnoDB DEFAULT CHARSET=latin1;
151
152-- Data exporting was unselected.
153
154
155-- Dumping structure for table eternalg_gtao.gta_admins
156CREATE TABLE IF NOT EXISTS `gta_admins` (
157 `steamid` varchar(255) NOT NULL,
158 `name` varchar(255) DEFAULT NULL,
159 `assigned` varchar(255) DEFAULT NULL,
160 `closed` varchar(255) DEFAULT NULL,
161 PRIMARY KEY (`steamid`)
162) ENGINE=MyISAM DEFAULT CHARSET=latin1;
163
164-- Data exporting was unselected.
165
166
167-- Dumping structure for table eternalg_gtao.gta_bname
168CREATE TABLE IF NOT EXISTS `gta_bname` (
169 `name` text NOT NULL
170) ENGINE=MyISAM DEFAULT CHARSET=latin1;
171
172-- Data exporting was unselected.
173
174
175-- Dumping structure for table eternalg_gtao.gta_cars
176CREATE TABLE IF NOT EXISTS `gta_cars` (
177 `id` int(16) NOT NULL,
178 `owner` varchar(16) NOT NULL,
179 `color` varchar(16) NOT NULL,
180 `underglow` varchar(16) NOT NULL,
181 `headlights` varchar(16) NOT NULL,
182 `hydraulics` int(16) NOT NULL
183) ENGINE=MyISAM DEFAULT CHARSET=utf8;
184
185-- Data exporting was unselected.
186
187
188-- Dumping structure for table eternalg_gtao.gta_event
189CREATE TABLE IF NOT EXISTS `gta_event` (
190 `steamid` varchar(255) NOT NULL DEFAULT 'STEAM_ID',
191 `rpname` varchar(255) DEFAULT NULL,
192 `event_1` varchar(255) DEFAULT NULL,
193 `event_2` varchar(255) DEFAULT NULL,
194 `event_3` varchar(255) DEFAULT NULL,
195 `event_4` varchar(255) DEFAULT NULL,
196 `event_5` varchar(255) DEFAULT NULL,
197 PRIMARY KEY (`steamid`)
198) ENGINE=MyISAM DEFAULT CHARSET=latin1;
199
200-- Data exporting was unselected.
201
202
203-- Dumping structure for table eternalg_gtao.gta_flags
204CREATE TABLE IF NOT EXISTS `gta_flags` (
205 `steamid` varchar(255) NOT NULL DEFAULT '0',
206 `time` varchar(255) DEFAULT NULL,
207 `flag` int(255) DEFAULT '0',
208 PRIMARY KEY (`steamid`)
209) ENGINE=MyISAM DEFAULT CHARSET=latin1;
210
211-- Data exporting was unselected.
212
213
214-- Dumping structure for table eternalg_gtao.gta_fuel
215CREATE TABLE IF NOT EXISTS `gta_fuel` (
216 `uid` int(11) NOT NULL,
217 `1` int(11) NOT NULL DEFAULT '10000',
218 `2` int(11) NOT NULL DEFAULT '10000',
219 `3` int(11) NOT NULL DEFAULT '10000',
220 `4` int(11) NOT NULL DEFAULT '10000',
221 `5` int(11) NOT NULL DEFAULT '10000',
222 `6` int(11) NOT NULL DEFAULT '10000',
223 `7` int(11) NOT NULL DEFAULT '10000',
224 `8` int(11) NOT NULL DEFAULT '10000',
225 `9` int(11) NOT NULL DEFAULT '10000',
226 `10` int(11) NOT NULL DEFAULT '10000',
227 `11` int(11) NOT NULL DEFAULT '10000',
228 `12` int(11) NOT NULL DEFAULT '10000',
229 `13` int(11) NOT NULL DEFAULT '10000',
230 `14` int(11) NOT NULL DEFAULT '10000',
231 `15` int(11) NOT NULL DEFAULT '10000',
232 `16` int(11) NOT NULL DEFAULT '10000',
233 `17` int(11) NOT NULL DEFAULT '10000',
234 `18` int(11) NOT NULL DEFAULT '10000',
235 `19` int(11) NOT NULL DEFAULT '10000',
236 `20` int(11) NOT NULL DEFAULT '10000',
237 `21` int(11) NOT NULL DEFAULT '10000',
238 `22` int(11) NOT NULL DEFAULT '10000',
239 `23` int(11) NOT NULL DEFAULT '10000',
240 `24` int(11) NOT NULL DEFAULT '10000',
241 `25` int(11) NOT NULL DEFAULT '10000',
242 `26` int(11) NOT NULL DEFAULT '10000',
243 `27` int(11) NOT NULL DEFAULT '10000',
244 `28` int(11) NOT NULL DEFAULT '10000',
245 `29` int(11) NOT NULL DEFAULT '10000',
246 `30` int(11) NOT NULL DEFAULT '10000',
247 `31` int(11) NOT NULL DEFAULT '10000',
248 `32` int(11) NOT NULL DEFAULT '10000',
249 `33` int(11) NOT NULL DEFAULT '10000',
250 `34` int(11) NOT NULL DEFAULT '10000',
251 `35` int(11) NOT NULL DEFAULT '10000',
252 `36` int(11) NOT NULL DEFAULT '10000',
253 `37` int(11) NOT NULL DEFAULT '10000',
254 `38` int(11) NOT NULL DEFAULT '10000',
255 `39` int(11) NOT NULL DEFAULT '10000',
256 `40` int(11) NOT NULL DEFAULT '10000',
257 `41` int(11) NOT NULL DEFAULT '10000',
258 `42` int(11) NOT NULL DEFAULT '10000',
259 `43` int(11) NOT NULL DEFAULT '10000',
260 `44` int(11) NOT NULL DEFAULT '10000',
261 `45` int(11) NOT NULL DEFAULT '10000',
262 `46` int(11) NOT NULL DEFAULT '10000',
263 `47` int(11) NOT NULL DEFAULT '10000',
264 `48` int(11) NOT NULL DEFAULT '10000',
265 `49` int(11) NOT NULL DEFAULT '10000',
266 `50` int(11) NOT NULL DEFAULT '10000',
267 `51` int(11) NOT NULL DEFAULT '10000',
268 `52` int(11) NOT NULL DEFAULT '10000',
269 `53` int(11) NOT NULL DEFAULT '10000',
270 `54` int(11) NOT NULL DEFAULT '10000',
271 `55` int(11) NOT NULL DEFAULT '10000',
272 PRIMARY KEY (`uid`)
273) ENGINE=MyISAM DEFAULT CHARSET=latin1;
274
275-- Data exporting was unselected.
276
277
278-- Dumping structure for table eternalg_gtao.gta_genes
279CREATE TABLE IF NOT EXISTS `gta_genes` (
280 `uid` int(255) DEFAULT NULL,
281 `steamid` varchar(255) NOT NULL,
282 `strength` varchar(255) DEFAULT NULL,
283 `intelligence` varchar(255) DEFAULT NULL,
284 `dexterity` varchar(255) DEFAULT NULL,
285 `influence` varchar(255) DEFAULT NULL,
286 `perception` varchar(255) DEFAULT NULL,
287 `regeneration` varchar(255) DEFAULT NULL,
288 `available` varchar(255) DEFAULT NULL,
289 PRIMARY KEY (`steamid`),
290 UNIQUE KEY `steamid` (`steamid`)
291) ENGINE=MyISAM DEFAULT CHARSET=latin1;
292
293-- Data exporting was unselected.
294
295
296-- Dumping structure for table eternalg_gtao.gta_ip
297CREATE TABLE IF NOT EXISTS `gta_ip` (
298 `uid` int(255) DEFAULT NULL,
299 `steamid` varchar(255) DEFAULT NULL,
300 `first_ip` varchar(255) DEFAULT NULL,
301 `last_ip` varchar(255) DEFAULT NULL,
302 `connections` int(11) DEFAULT NULL,
303 `first_join` varchar(255) DEFAULT NULL,
304 `time` varchar(255) DEFAULT NULL
305) ENGINE=MyISAM DEFAULT CHARSET=latin1;
306
307-- Data exporting was unselected.
308
309
310-- Dumping structure for table eternalg_gtao.gta_organization
311CREATE TABLE IF NOT EXISTS `gta_organization` (
312 `name` text NOT NULL,
313 `motd` text NOT NULL,
314 `owner` text NOT NULL,
315 `id` int(11) NOT NULL AUTO_INCREMENT,
316 PRIMARY KEY (`id`)
317) ENGINE=MyISAM DEFAULT CHARSET=latin1;
318
319-- Data exporting was unselected.
320
321
322-- Dumping structure for table eternalg_gtao.gta_reports
323CREATE TABLE IF NOT EXISTS `gta_reports` (
324 `report_id` int(11) NOT NULL AUTO_INCREMENT,
325 `caller_steamid` varchar(255) DEFAULT NULL,
326 `caller_name` varchar(255) DEFAULT NULL,
327 `report_text` varchar(255) DEFAULT NULL,
328 `time` varchar(255) DEFAULT NULL,
329 `admin` varchar(255) DEFAULT NULL,
330 `reason` varchar(255) DEFAULT NULL,
331 PRIMARY KEY (`report_id`)
332) ENGINE=MyISAM DEFAULT CHARSET=latin1;
333
334-- Data exporting was unselected.
335
336
337-- Dumping structure for table eternalg_gtao.gta_system
338CREATE TABLE IF NOT EXISTS `gta_system` (
339 `key` text NOT NULL,
340 `value` text NOT NULL,
341 PRIMARY KEY (`key`(15))
342) ENGINE=MyISAM DEFAULT CHARSET=latin1;
343
344-- Data exporting was unselected.
345
346
347-- Dumping structure for table eternalg_gtao.gta_users
348CREATE TABLE IF NOT EXISTS `gta_users` (
349 `uid` bigint(11) NOT NULL,
350 `id` text NOT NULL,
351 `steamid` text NOT NULL,
352 `blacklists` text NOT NULL,
353 `rp_name_first` text NOT NULL,
354 `rp_name_last` text NOT NULL,
355 `time_played` bigint(20) NOT NULL,
356 `cash` bigint(20) NOT NULL,
357 `model` text NOT NULL,
358 `items` text NOT NULL,
359 `skills` text NOT NULL,
360 `genes` text NOT NULL,
361 `formulas` text NOT NULL,
362 `organization` int(11) NOT NULL DEFAULT '0',
363 `bank` bigint(20) NOT NULL,
364 `vehicles` text NOT NULL,
365 `ringtones` text NOT NULL,
366 `ringtone` int(11) NOT NULL DEFAULT '1',
367 `last_played` text NOT NULL,
368 `physgun` text NOT NULL,
369 `fuelleft` int(11) NOT NULL DEFAULT '10000',
370 `lastcar` text,
371 `ticket` int(11) DEFAULT NULL,
372 `ammo_pistol` bigint(20) NOT NULL,
373 `ammo_rifle` bigint(20) NOT NULL,
374 `ammo_shotgun` bigint(20) NOT NULL,
375 `storage` text NOT NULL,
376 `phase_points` int(11) NOT NULL DEFAULT '0',
377 `ammo_sniper` bigint(20) NOT NULL,
378 `blacklist_custom` text NOT NULL,
379 PRIMARY KEY (`uid`,`id`(15),`steamid`(15))
380) ENGINE=MyISAM DEFAULT CHARSET=latin1;
381
382-- Data exporting was unselected.
383
384
385-- Dumping structure for table eternalg_gtao.gta_warnings
386CREATE TABLE IF NOT EXISTS `gta_warnings` (
387 `steamid` varchar(255) DEFAULT NULL,
388 `rp_name` varchar(255) DEFAULT NULL,
389 `steam_name` varchar(255) DEFAULT NULL,
390 `admin_sid` varchar(255) DEFAULT NULL,
391 `admin_name` varchar(255) DEFAULT NULL,
392 `reason` varchar(255) DEFAULT NULL,
393 `time` varchar(255) DEFAULT NULL,
394 `time_` int(255) DEFAULT NULL,
395 UNIQUE KEY `time_` (`time_`)
396) ENGINE=MyISAM DEFAULT CHARSET=latin1;
397
398-- Data exporting was unselected.
399
400
401-- Dumping structure for table eternalg_gtao.ip_intel
402CREATE TABLE IF NOT EXISTS `ip_intel` (
403 `steamid` text NOT NULL,
404 `ip` text,
405 `name` text,
406 `first_seen` bigint(20) DEFAULT '0',
407 `last_seen` bigint(20) DEFAULT '0',
408 `num_seen` int(11) DEFAULT '0',
409 `unique_id` text,
410 `rp_name` text,
411 `play_time` bigint(20) DEFAULT '0',
412 `strikes` int(11) DEFAULT '0',
413 PRIMARY KEY (`steamid`(20))
414) ENGINE=InnoDB DEFAULT CHARSET=latin1;
415
416-- Data exporting was unselected.
417
418
419-- Dumping structure for table eternalg_gtao.logs
420CREATE TABLE IF NOT EXISTS `logs` (
421 `id` int(11) NOT NULL AUTO_INCREMENT,
422 `uid` bigint(20) NOT NULL DEFAULT '0',
423 `action` text NOT NULL,
424 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
425 PRIMARY KEY (`id`)
426) ENGINE=MyISAM DEFAULT CHARSET=utf8;
427
428-- Data exporting was unselected.
429
430
431-- Dumping structure for table eternalg_gtao.news
432CREATE TABLE IF NOT EXISTS `news` (
433 `id` int(11) NOT NULL AUTO_INCREMENT,
434 `content` text NOT NULL,
435 `date` varchar(50) NOT NULL,
436 `uid` bigint(20) DEFAULT NULL,
437 PRIMARY KEY (`id`)
438) ENGINE=MyISAM DEFAULT CHARSET=utf8;
439
440-- Data exporting was unselected.
441
442
443-- Dumping structure for table eternalg_gtao.packages
444CREATE TABLE IF NOT EXISTS `packages` (
445 `id` int(11) NOT NULL AUTO_INCREMENT,
446 `order_id` int(11) DEFAULT NULL,
447 `title` varchar(50) DEFAULT NULL,
448 `servers` text,
449 `labels` text,
450 `lower_text` text,
451 `actions` text,
452 `currency` int(11) DEFAULT '1',
453 `price` double DEFAULT '0',
454 `credits` double DEFAULT '0',
455 `img` varchar(1024) DEFAULT NULL,
456 `permanent` int(11) DEFAULT NULL,
457 `rebuyable` int(11) DEFAULT '0',
458 `days` int(11) DEFAULT '0',
459 `custom_price` double DEFAULT '0',
460 `custom_price_min` double DEFAULT NULL,
461 `non_compatible` varchar(1024) DEFAULT '[]',
462 `upgradeable` varchar(1024) DEFAULT '[]',
463 `hide` varchar(1024) DEFAULT '[]',
464 `no_owned` int(11) DEFAULT '0',
465 `bought_disable` varchar(1024) DEFAULT '[]',
466 `subscription` int(11) NOT NULL DEFAULT '0',
467 `once` int(11) NOT NULL DEFAULT '0',
468 `category` int(11) NOT NULL DEFAULT '1',
469 `alternative_paypal` varchar(50) DEFAULT NULL,
470 `enabled` int(11) DEFAULT '1',
471 PRIMARY KEY (`id`)
472) ENGINE=MyISAM DEFAULT CHARSET=utf8;
473
474-- Data exporting was unselected.
475
476
477-- Dumping structure for table eternalg_gtao.pages
478CREATE TABLE IF NOT EXISTS `pages` (
479 `page` varchar(50) DEFAULT NULL,
480 `content` text
481) ENGINE=MyISAM DEFAULT CHARSET=utf8;
482
483-- Data exporting was unselected.
484
485
486-- Dumping structure for table eternalg_gtao.permission_groups
487CREATE TABLE IF NOT EXISTS `permission_groups` (
488 `id` int(11) NOT NULL AUTO_INCREMENT,
489 `title` varchar(128) NOT NULL,
490 `json` text NOT NULL,
491 PRIMARY KEY (`id`)
492) ENGINE=MyISAM DEFAULT CHARSET=utf8;
493
494-- Data exporting was unselected.
495
496
497-- Dumping structure for table eternalg_gtao.players
498CREATE TABLE IF NOT EXISTS `players` (
499 `id` int(11) NOT NULL AUTO_INCREMENT,
500 `uid` bigint(20) DEFAULT NULL,
501 `name` varchar(50) DEFAULT NULL,
502 `credits` double NOT NULL DEFAULT '0',
503 `admin` int(11) NOT NULL DEFAULT '0',
504 `perm_group` int(11) DEFAULT '0',
505 `session_token` varchar(128) DEFAULT NULL,
506 `tos_lastread` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
507 `ip` varchar(45) DEFAULT NULL,
508 PRIMARY KEY (`id`)
509) ENGINE=MyISAM DEFAULT CHARSET=utf8;
510
511-- Data exporting was unselected.
512
513
514-- Dumping structure for table eternalg_gtao.postlogs
515CREATE TABLE IF NOT EXISTS `postlogs` (
516 `log` text,
517 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP
518) ENGINE=MyISAM DEFAULT CHARSET=utf8;
519
520-- Data exporting was unselected.
521
522
523-- Dumping structure for table eternalg_gtao.prepurchase
524CREATE TABLE IF NOT EXISTS `prepurchase` (
525 `id` int(11) NOT NULL AUTO_INCREMENT,
526 `type` varchar(50) NOT NULL,
527 `uid` bigint(20) NOT NULL,
528 `json` text NOT NULL,
529 `delivered` tinyint(4) NOT NULL DEFAULT '0',
530 `extra` text,
531 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
532 PRIMARY KEY (`id`)
533) ENGINE=MyISAM DEFAULT CHARSET=utf8;
534
535-- Data exporting was unselected.
536
537
538-- Dumping structure for table eternalg_gtao.raffles
539CREATE TABLE IF NOT EXISTS `raffles` (
540 `id` int(11) NOT NULL AUTO_INCREMENT,
541 `title` varchar(50) NOT NULL,
542 `descr` text NOT NULL,
543 `price` double NOT NULL,
544 `credits` int(11) NOT NULL,
545 `currency` int(11) NOT NULL DEFAULT '1',
546 `package` int(11) NOT NULL,
547 `img` text NOT NULL,
548 `max_per_person` int(11) NOT NULL DEFAULT '1',
549 `end_amount` int(11) NOT NULL DEFAULT '10',
550 `ended` int(11) NOT NULL DEFAULT '0',
551 `winner` bigint(20) DEFAULT NULL,
552 `enabled` int(11) NOT NULL DEFAULT '1',
553 PRIMARY KEY (`id`)
554) ENGINE=MyISAM DEFAULT CHARSET=utf8;
555
556-- Data exporting was unselected.
557
558
559-- Dumping structure for table eternalg_gtao.raffle_tickets
560CREATE TABLE IF NOT EXISTS `raffle_tickets` (
561 `id` int(11) NOT NULL AUTO_INCREMENT,
562 `raffle_id` int(11) DEFAULT NULL,
563 `uid` bigint(20) DEFAULT NULL,
564 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
565 PRIMARY KEY (`id`)
566) ENGINE=MyISAM DEFAULT CHARSET=utf8;
567
568-- Data exporting was unselected.
569
570
571-- Dumping structure for table eternalg_gtao.requests
572CREATE TABLE IF NOT EXISTS `requests` (
573 `id` int(11) NOT NULL AUTO_INCREMENT,
574 `error` int(11) NOT NULL,
575 `msg` text,
576 `debug` text,
577 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
578 PRIMARY KEY (`id`)
579) ENGINE=MyISAM DEFAULT CHARSET=utf8;
580
581-- Data exporting was unselected.
582
583
584-- Dumping structure for table eternalg_gtao.sb_actions
585CREATE TABLE IF NOT EXISTS `sb_actions` (
586 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
587 `name` varchar(64) DEFAULT NULL,
588 `steam` varchar(32) DEFAULT NULL,
589 `ip` varchar(15) DEFAULT NULL,
590 `message` varchar(255) NOT NULL,
591 `server_id` smallint(5) unsigned NOT NULL,
592 `admin_id` smallint(5) unsigned DEFAULT NULL,
593 `admin_ip` varchar(32) NOT NULL,
594 `create_time` int(10) unsigned NOT NULL,
595 PRIMARY KEY (`id`),
596 KEY `admin_id` (`admin_id`),
597 KEY `server_id` (`server_id`),
598 CONSTRAINT `action_admin` FOREIGN KEY (`admin_id`) REFERENCES `sb_admins` (`id`) ON DELETE SET NULL,
599 CONSTRAINT `action_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE CASCADE
600) ENGINE=InnoDB DEFAULT CHARSET=utf8;
601
602-- Data exporting was unselected.
603
604
605-- Dumping structure for table eternalg_gtao.sb_admins
606CREATE TABLE IF NOT EXISTS `sb_admins` (
607 `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
608 `name` varchar(64) NOT NULL,
609 `auth` enum('steam','name','ip') NOT NULL,
610 `identity` varchar(64) NOT NULL,
611 `password` varchar(64) DEFAULT NULL,
612 `group_id` tinyint(3) unsigned DEFAULT NULL,
613 `email` varchar(128) DEFAULT NULL,
614 `language` varchar(2) DEFAULT NULL,
615 `theme` varchar(32) DEFAULT NULL,
616 `timezone` varchar(32) DEFAULT NULL,
617 `server_password` varchar(64) DEFAULT NULL,
618 `validation_key` varchar(64) DEFAULT NULL,
619 `login_time` int(10) unsigned DEFAULT NULL,
620 `create_time` int(10) unsigned NOT NULL,
621 PRIMARY KEY (`id`),
622 UNIQUE KEY `name` (`name`),
623 UNIQUE KEY `auth` (`auth`,`identity`),
624 KEY `group_id` (`group_id`),
625 CONSTRAINT `admin_group` FOREIGN KEY (`group_id`) REFERENCES `sb_groups` (`id`) ON DELETE SET NULL
626) ENGINE=InnoDB DEFAULT CHARSET=utf8;
627
628-- Data exporting was unselected.
629
630
631-- Dumping structure for table eternalg_gtao.sb_admins_server_groups
632CREATE TABLE IF NOT EXISTS `sb_admins_server_groups` (
633 `admin_id` smallint(5) unsigned NOT NULL,
634 `group_id` smallint(5) unsigned NOT NULL,
635 `inherit_order` int(10) NOT NULL,
636 PRIMARY KEY (`admin_id`,`group_id`),
637 KEY `admin_id` (`admin_id`),
638 KEY `group_id` (`group_id`),
639 CONSTRAINT `admin_server_group` FOREIGN KEY (`group_id`) REFERENCES `sb_server_groups` (`id`) ON DELETE CASCADE,
640 CONSTRAINT `server_group_admin` FOREIGN KEY (`admin_id`) REFERENCES `sb_admins` (`id`) ON DELETE CASCADE
641) ENGINE=InnoDB DEFAULT CHARSET=utf8;
642
643-- Data exporting was unselected.
644
645
646-- Dumping structure for table eternalg_gtao.sb_appeals
647CREATE TABLE IF NOT EXISTS `sb_appeals` (
648 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
649 `ban_id` mediumint(8) unsigned NOT NULL,
650 `reason` varchar(255) NOT NULL,
651 `user_email` varchar(128) NOT NULL,
652 `user_ip` varchar(15) NOT NULL,
653 `archived` tinyint(1) unsigned NOT NULL DEFAULT '0',
654 `create_time` int(10) unsigned NOT NULL,
655 PRIMARY KEY (`id`),
656 KEY `ban_id` (`ban_id`),
657 CONSTRAINT `appeal_ban` FOREIGN KEY (`ban_id`) REFERENCES `sb_bans` (`id`) ON DELETE CASCADE
658) ENGINE=InnoDB DEFAULT CHARSET=utf8;
659
660-- Data exporting was unselected.
661
662
663-- Dumping structure for table eternalg_gtao.sb_bans
664CREATE TABLE IF NOT EXISTS `sb_bans` (
665 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
666 `type` tinyint(1) NOT NULL DEFAULT '0',
667 `steam` varchar(32) DEFAULT NULL,
668 `ip` varchar(15) DEFAULT NULL,
669 `name` varchar(64) DEFAULT NULL,
670 `reason` varchar(255) NOT NULL,
671 `length` mediumint(8) unsigned NOT NULL,
672 `server_id` smallint(5) unsigned DEFAULT NULL,
673 `admin_id` smallint(5) unsigned DEFAULT NULL,
674 `admin_ip` varchar(15) NOT NULL,
675 `unban_admin_id` smallint(5) unsigned DEFAULT NULL,
676 `unban_reason` varchar(255) DEFAULT NULL,
677 `unban_time` int(10) unsigned DEFAULT NULL,
678 `create_time` int(10) unsigned NOT NULL,
679 PRIMARY KEY (`id`),
680 KEY `server_id` (`server_id`),
681 KEY `admin_id` (`admin_id`),
682 KEY `unban_admin_id` (`unban_admin_id`),
683 CONSTRAINT `ban_admin` FOREIGN KEY (`admin_id`) REFERENCES `sb_admins` (`id`) ON DELETE SET NULL,
684 CONSTRAINT `ban_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE SET NULL,
685 CONSTRAINT `ban_unban_admin` FOREIGN KEY (`unban_admin_id`) REFERENCES `sb_admins` (`id`) ON DELETE SET NULL
686) ENGINE=InnoDB DEFAULT CHARSET=utf8;
687
688-- Data exporting was unselected.
689
690
691-- Dumping structure for table eternalg_gtao.sb_blocks
692CREATE TABLE IF NOT EXISTS `sb_blocks` (
693 `ban_id` mediumint(8) unsigned NOT NULL,
694 `name` varchar(64) NOT NULL,
695 `server_id` smallint(5) unsigned NOT NULL,
696 `create_time` int(10) unsigned NOT NULL,
697 KEY `ban_id` (`ban_id`),
698 KEY `server_id` (`server_id`),
699 CONSTRAINT `block_ban` FOREIGN KEY (`ban_id`) REFERENCES `sb_bans` (`id`) ON DELETE CASCADE,
700 CONSTRAINT `block_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE CASCADE
701) ENGINE=InnoDB DEFAULT CHARSET=utf8;
702
703-- Data exporting was unselected.
704
705
706-- Dumping structure for table eternalg_gtao.sb_comments
707CREATE TABLE IF NOT EXISTS `sb_comments` (
708 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
709 `object_type` varchar(1) NOT NULL,
710 `object_id` mediumint(8) unsigned NOT NULL,
711 `admin_id` smallint(5) unsigned DEFAULT NULL,
712 `message` text NOT NULL,
713 `update_admin_id` smallint(5) unsigned DEFAULT NULL,
714 `update_time` int(10) unsigned DEFAULT NULL,
715 `create_time` int(10) unsigned NOT NULL,
716 PRIMARY KEY (`id`),
717 KEY `admin_id` (`admin_id`),
718 KEY `object` (`object_type`,`object_id`),
719 KEY `update_admin_id` (`update_admin_id`),
720 CONSTRAINT `comment_admin` FOREIGN KEY (`admin_id`) REFERENCES `sb_admins` (`id`) ON DELETE SET NULL,
721 CONSTRAINT `comment_update_admin` FOREIGN KEY (`update_admin_id`) REFERENCES `sb_admins` (`id`) ON DELETE SET NULL
722) ENGINE=InnoDB DEFAULT CHARSET=utf8;
723
724-- Data exporting was unselected.
725
726
727-- Dumping structure for table eternalg_gtao.sb_demos
728CREATE TABLE IF NOT EXISTS `sb_demos` (
729 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
730 `object_type` varchar(1) NOT NULL,
731 `object_id` mediumint(8) unsigned NOT NULL,
732 `filename` varchar(255) NOT NULL,
733 PRIMARY KEY (`id`),
734 KEY `object` (`object_type`,`object_id`)
735) ENGINE=InnoDB DEFAULT CHARSET=utf8;
736
737-- Data exporting was unselected.
738
739
740-- Dumping structure for table eternalg_gtao.sb_games
741CREATE TABLE IF NOT EXISTS `sb_games` (
742 `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
743 `name` varchar(32) NOT NULL,
744 `folder` varchar(32) NOT NULL,
745 `icon` varchar(32) NOT NULL,
746 PRIMARY KEY (`id`),
747 UNIQUE KEY `folder` (`folder`)
748) ENGINE=InnoDB DEFAULT CHARSET=utf8;
749
750-- Data exporting was unselected.
751
752
753-- Dumping structure for table eternalg_gtao.sb_groups
754CREATE TABLE IF NOT EXISTS `sb_groups` (
755 `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
756 `name` varchar(32) NOT NULL,
757 PRIMARY KEY (`id`),
758 UNIQUE KEY `name` (`name`)
759) ENGINE=InnoDB DEFAULT CHARSET=utf8;
760
761-- Data exporting was unselected.
762
763
764-- Dumping structure for table eternalg_gtao.sb_group_permissions
765CREATE TABLE IF NOT EXISTS `sb_group_permissions` (
766 `group_id` tinyint(3) unsigned NOT NULL,
767 `name` varchar(32) NOT NULL,
768 PRIMARY KEY (`group_id`,`name`),
769 KEY `group_id` (`group_id`),
770 CONSTRAINT `permission_group` FOREIGN KEY (`group_id`) REFERENCES `sb_groups` (`id`) ON DELETE CASCADE
771) ENGINE=InnoDB DEFAULT CHARSET=utf8;
772
773-- Data exporting was unselected.
774
775
776-- Dumping structure for table eternalg_gtao.sb_logs
777CREATE TABLE IF NOT EXISTS `sb_logs` (
778 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
779 `type` enum('m','w','e') NOT NULL,
780 `title` varchar(64) NOT NULL,
781 `message` varchar(255) NOT NULL,
782 `function` text NOT NULL,
783 `query` varchar(255) NOT NULL,
784 `admin_id` smallint(5) unsigned DEFAULT NULL,
785 `admin_ip` varchar(15) NOT NULL,
786 `create_time` int(10) unsigned NOT NULL,
787 PRIMARY KEY (`id`),
788 KEY `admin_id` (`admin_id`),
789 CONSTRAINT `log_admin` FOREIGN KEY (`admin_id`) REFERENCES `sb_admins` (`id`) ON DELETE SET NULL
790) ENGINE=InnoDB DEFAULT CHARSET=utf8;
791
792-- Data exporting was unselected.
793
794
795-- Dumping structure for table eternalg_gtao.sb_overrides
796CREATE TABLE IF NOT EXISTS `sb_overrides` (
797 `type` enum('command','group') NOT NULL,
798 `name` varchar(32) NOT NULL,
799 `flags` varchar(30) NOT NULL,
800 PRIMARY KEY (`type`,`name`)
801) ENGINE=InnoDB DEFAULT CHARSET=utf8;
802
803-- Data exporting was unselected.
804
805
806-- Dumping structure for table eternalg_gtao.sb_plugins
807CREATE TABLE IF NOT EXISTS `sb_plugins` (
808 `class` varchar(255) NOT NULL,
809 `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
810 PRIMARY KEY (`class`)
811) ENGINE=InnoDB DEFAULT CHARSET=utf8;
812
813-- Data exporting was unselected.
814
815
816-- Dumping structure for table eternalg_gtao.sb_reports
817CREATE TABLE IF NOT EXISTS `sb_reports` (
818 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
819 `name` varchar(64) NOT NULL,
820 `steam` varchar(32) DEFAULT NULL,
821 `ip` varchar(15) DEFAULT NULL,
822 `reason` varchar(255) NOT NULL,
823 `server_id` smallint(5) unsigned DEFAULT NULL,
824 `user_name` varchar(64) NOT NULL,
825 `user_email` varchar(128) NOT NULL,
826 `user_ip` varchar(15) NOT NULL,
827 `archived` tinyint(1) unsigned NOT NULL DEFAULT '0',
828 `create_time` int(10) unsigned NOT NULL,
829 PRIMARY KEY (`id`),
830 KEY `server_id` (`server_id`),
831 CONSTRAINT `report_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE SET NULL
832) ENGINE=InnoDB DEFAULT CHARSET=utf8;
833
834-- Data exporting was unselected.
835
836
837-- Dumping structure for table eternalg_gtao.sb_servers
838CREATE TABLE IF NOT EXISTS `sb_servers` (
839 `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
840 `host` varchar(255) NOT NULL,
841 `port` smallint(5) unsigned NOT NULL DEFAULT '27015',
842 `rcon` varchar(32) DEFAULT NULL,
843 `game_id` tinyint(3) unsigned DEFAULT NULL,
844 `enabled` tinyint(1) NOT NULL DEFAULT '1',
845 PRIMARY KEY (`id`),
846 KEY `game_id` (`game_id`),
847 CONSTRAINT `server_game` FOREIGN KEY (`game_id`) REFERENCES `sb_games` (`id`) ON DELETE SET NULL
848) ENGINE=InnoDB DEFAULT CHARSET=utf8;
849
850-- Data exporting was unselected.
851
852
853-- Dumping structure for table eternalg_gtao.sb_servers_server_groups
854CREATE TABLE IF NOT EXISTS `sb_servers_server_groups` (
855 `server_id` smallint(5) unsigned NOT NULL,
856 `group_id` smallint(5) unsigned NOT NULL,
857 PRIMARY KEY (`server_id`,`group_id`),
858 KEY `server_id` (`server_id`),
859 KEY `group_id` (`group_id`),
860 CONSTRAINT `server_group_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE CASCADE,
861 CONSTRAINT `server_server_group` FOREIGN KEY (`group_id`) REFERENCES `sb_server_groups` (`id`) ON DELETE CASCADE
862) ENGINE=InnoDB DEFAULT CHARSET=utf8;
863
864-- Data exporting was unselected.
865
866
867-- Dumping structure for table eternalg_gtao.sb_server_groups
868CREATE TABLE IF NOT EXISTS `sb_server_groups` (
869 `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
870 `name` varchar(32) NOT NULL,
871 `flags` varchar(32) NOT NULL,
872 `immunity` smallint(5) unsigned NOT NULL DEFAULT '0',
873 PRIMARY KEY (`id`),
874 UNIQUE KEY `name` (`name`)
875) ENGINE=InnoDB DEFAULT CHARSET=utf8;
876
877-- Data exporting was unselected.
878
879
880-- Dumping structure for table eternalg_gtao.sb_server_groups_immunity
881CREATE TABLE IF NOT EXISTS `sb_server_groups_immunity` (
882 `group_id` smallint(5) unsigned NOT NULL,
883 `other_id` smallint(5) unsigned NOT NULL,
884 PRIMARY KEY (`group_id`,`other_id`),
885 KEY `group_id` (`group_id`),
886 KEY `other_id` (`other_id`),
887 CONSTRAINT `server_group_immunity_group` FOREIGN KEY (`group_id`) REFERENCES `sb_server_groups` (`id`) ON DELETE CASCADE,
888 CONSTRAINT `server_group_immunity_other` FOREIGN KEY (`other_id`) REFERENCES `sb_server_groups` (`id`) ON DELETE CASCADE
889) ENGINE=InnoDB DEFAULT CHARSET=utf8;
890
891-- Data exporting was unselected.
892
893
894-- Dumping structure for table eternalg_gtao.sb_server_group_overrides
895CREATE TABLE IF NOT EXISTS `sb_server_group_overrides` (
896 `group_id` smallint(5) unsigned NOT NULL,
897 `type` enum('command','group') NOT NULL,
898 `name` varchar(32) NOT NULL,
899 `access` enum('allow','deny') NOT NULL,
900 PRIMARY KEY (`group_id`,`type`,`name`),
901 KEY `group_id` (`group_id`),
902 CONSTRAINT `override_server_group` FOREIGN KEY (`group_id`) REFERENCES `sb_server_groups` (`id`) ON DELETE CASCADE
903) ENGINE=InnoDB DEFAULT CHARSET=utf8;
904
905-- Data exporting was unselected.
906
907
908-- Dumping structure for table eternalg_gtao.sb_settings
909CREATE TABLE IF NOT EXISTS `sb_settings` (
910 `name` varchar(32) NOT NULL,
911 `value` text NOT NULL,
912 PRIMARY KEY (`name`)
913) ENGINE=InnoDB DEFAULT CHARSET=utf8;
914
915-- Data exporting was unselected.
916
917
918-- Dumping structure for table eternalg_gtao.serverguard_analytics
919CREATE TABLE IF NOT EXISTS `serverguard_analytics` (
920 `id` int(11) NOT NULL AUTO_INCREMENT,
921 `date` varchar(10) NOT NULL,
922 `data` text NOT NULL,
923 PRIMARY KEY (`id`)
924) ENGINE=MyISAM DEFAULT CHARSET=latin1;
925
926-- Data exporting was unselected.
927
928
929-- Dumping structure for table eternalg_gtao.serverguard_bans
930CREATE TABLE IF NOT EXISTS `serverguard_bans` (
931 `id` int(11) NOT NULL AUTO_INCREMENT,
932 `steam_id` varchar(25) NOT NULL,
933 `community_id` text NOT NULL,
934 `player` varchar(255) NOT NULL,
935 `reason` text NOT NULL,
936 `start_time` int(11) NOT NULL,
937 `end_time` int(11) NOT NULL,
938 `admin` varchar(255) NOT NULL,
939 `ip_address` varchar(15) NOT NULL,
940 PRIMARY KEY (`id`)
941) ENGINE=MyISAM DEFAULT CHARSET=latin1;
942
943-- Data exporting was unselected.
944
945
946-- Dumping structure for table eternalg_gtao.serverguard_ranks
947CREATE TABLE IF NOT EXISTS `serverguard_ranks` (
948 `id` int(11) NOT NULL AUTO_INCREMENT,
949 `unique_id` varchar(255) NOT NULL,
950 `name` varchar(255) NOT NULL,
951 `color` varchar(40) NOT NULL,
952 `immunity` int(11) NOT NULL,
953 `texture` varchar(255) NOT NULL,
954 `data` text,
955 PRIMARY KEY (`id`)
956) ENGINE=MyISAM DEFAULT CHARSET=latin1;
957
958-- Data exporting was unselected.
959
960
961-- Dumping structure for table eternalg_gtao.serverguard_reports
962CREATE TABLE IF NOT EXISTS `serverguard_reports` (
963 `id` int(11) NOT NULL AUTO_INCREMENT,
964 `name` varchar(255) NOT NULL,
965 `steamID` varchar(255) NOT NULL DEFAULT 'Unknown',
966 `text` text NOT NULL,
967 `status` text NOT NULL,
968 `time` int(11) NOT NULL,
969 PRIMARY KEY (`id`)
970) ENGINE=MyISAM DEFAULT CHARSET=latin1;
971
972-- Data exporting was unselected.
973
974
975-- Dumping structure for table eternalg_gtao.serverguard_users
976CREATE TABLE IF NOT EXISTS `serverguard_users` (
977 `id` int(11) NOT NULL AUTO_INCREMENT,
978 `steam_id` varchar(25) NOT NULL,
979 `rank` varchar(255) NOT NULL DEFAULT '',
980 `name` varchar(255) NOT NULL,
981 `last_played` int(11) NOT NULL,
982 `data` text,
983 PRIMARY KEY (`id`)
984) ENGINE=MyISAM DEFAULT CHARSET=latin1;
985
986-- Data exporting was unselected.
987
988
989-- Dumping structure for table eternalg_gtao.servers
990CREATE TABLE IF NOT EXISTS `servers` (
991 `id` int(11) NOT NULL AUTO_INCREMENT,
992 `order_id` int(11) DEFAULT NULL,
993 `game` varchar(50) DEFAULT NULL,
994 `ip` varchar(50) DEFAULT NULL,
995 `port` varchar(50) DEFAULT NULL,
996 `rcon` text,
997 `name` varchar(128) NOT NULL,
998 `featured_package` int(11) NOT NULL DEFAULT '0',
999 `image_link` text,
1000 PRIMARY KEY (`id`)
1001) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1002
1003-- Data exporting was unselected.
1004
1005
1006-- Dumping structure for table eternalg_gtao.settings
1007CREATE TABLE IF NOT EXISTS `settings` (
1008 `name` varchar(50) NOT NULL,
1009 `value` text,
1010 `value2` int(11) NOT NULL DEFAULT '0',
1011 `value3` timestamp NULL DEFAULT NULL,
1012 PRIMARY KEY (`name`)
1013) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1014
1015-- Data exporting was unselected.
1016
1017
1018-- Dumping structure for table eternalg_gtao.test
1019CREATE TABLE IF NOT EXISTS `test` (
1020 `test1` varchar(50) NOT NULL,
1021 `test2` varchar(50) DEFAULT NULL,
1022 `test3` varchar(50) DEFAULT NULL,
1023 PRIMARY KEY (`test1`)
1024) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1025
1026-- Data exporting was unselected.
1027
1028
1029-- Dumping structure for table eternalg_gtao.tickets
1030CREATE TABLE IF NOT EXISTS `tickets` (
1031 `id` int(11) NOT NULL AUTO_INCREMENT,
1032 `uid` varchar(50) NOT NULL,
1033 `descr` text NOT NULL,
1034 `text` text NOT NULL,
1035 `active` int(11) NOT NULL DEFAULT '1',
1036 `seen` int(11) NOT NULL DEFAULT '0',
1037 `client_seen` int(11) NOT NULL DEFAULT '1',
1038 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1039 PRIMARY KEY (`id`)
1040) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1041
1042-- Data exporting was unselected.
1043
1044
1045-- Dumping structure for table eternalg_gtao.ticket_replies
1046CREATE TABLE IF NOT EXISTS `ticket_replies` (
1047 `id` int(11) NOT NULL AUTO_INCREMENT,
1048 `ticket_id` int(11) DEFAULT NULL,
1049 `uid` bigint(20) DEFAULT NULL,
1050 `text` text,
1051 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
1052 PRIMARY KEY (`id`)
1053) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1054
1055-- Data exporting was unselected.
1056
1057
1058-- Dumping structure for table eternalg_gtao.transactions
1059CREATE TABLE IF NOT EXISTS `transactions` (
1060 `id` int(11) NOT NULL AUTO_INCREMENT,
1061 `name` varchar(50) DEFAULT NULL,
1062 `buyer` varchar(50) DEFAULT NULL,
1063 `email` varchar(50) DEFAULT NULL,
1064 `uid` bigint(20) DEFAULT NULL,
1065 `buyer_uid` bigint(20) DEFAULT NULL,
1066 `package` int(11) DEFAULT NULL,
1067 `credit_package` int(11) DEFAULT NULL,
1068 `raffle_package` int(11) DEFAULT NULL,
1069 `currency` varchar(50) DEFAULT NULL,
1070 `price` double DEFAULT NULL,
1071 `credits` double DEFAULT '0',
1072 `txn_id` varchar(50) DEFAULT NULL,
1073 `gateway` varchar(50) DEFAULT NULL,
1074 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
1075 PRIMARY KEY (`id`)
1076) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1077
1078-- Data exporting was unselected.
1079/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
1080/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
1081/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;