zE05yEZq

1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4CREATE TABLE IF NOT EXISTS `aff_requests` (
5  `id` int(10) NOT NULL AUTO_INCREMENT,
6  `steamid` varchar(20) NOT NULL,
7  `offerid` varchar(20) NOT NULL,
8  `cost` int(8) NOT NULL,
9  `status` varchar(32) NOT NULL,
10  `time` datetime NOT NULL,
11  PRIMARY KEY (`id`)
12) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=46810 ;
13
14CREATE TABLE IF NOT EXISTS `aff_userdata` (
15  `id` int(20) NOT NULL AUTO_INCREMENT,
16  `steamid` varchar(20) NOT NULL,
17  `refferals` varchar(10) NOT NULL DEFAULT '0',
18  `balance` int(50) NOT NULL DEFAULT '0',
19  `refcode` varchar(12) NOT NULL,
20  `reffered_by` varchar(20) NOT NULL,
21  `reservation` int(11) NOT NULL,
22  `ip` varchar(20) CHARACTER SET latin1 NOT NULL,
23  `date` datetime NOT NULL,
24  PRIMARY KEY (`id`)
25) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=140423 ;
26
27CREATE TABLE IF NOT EXISTS `banned` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `steamid` varchar(22) NOT NULL,
30  PRIMARY KEY (`id`)
31) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
32
33CREATE TABLE IF NOT EXISTS `unsent_offers` (
34  `id` int(30) NOT NULL AUTO_INCREMENT,
35  `game_id` varchar(50) NOT NULL,
36  `user_id` varchar(50) NOT NULL,
37  `items` varchar(700) NOT NULL,
38  `date` datetime NOT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
41
42CREATE TABLE IF NOT EXISTS `users` (
43  `id` int(11) NOT NULL AUTO_INCREMENT,
44  `email` varchar(128) NOT NULL,
45  `hash` varchar(64) NOT NULL,
46  `salt` varchar(64) NOT NULL,
47  `activated` int(2) NOT NULL,
48  `steamid` varchar(20) NOT NULL,
49  `nick` varchar(45) NOT NULL,
50  `token` varchar(16) NOT NULL,
51  `tradelink` varchar(100) NOT NULL,
52  `avatar` varchar(140) NOT NULL,
53  `totalwin` float NOT NULL,
54  `count` int(11) NOT NULL,
55  `wincount` int(11) NOT NULL,
56  `ip` varchar(32) NOT NULL,
57  `ssid` varchar(40) NOT NULL,
58  `unixtime` int(11) NOT NULL,
59  `password` varchar(64) NOT NULL,
60  PRIMARY KEY (`id`)
61) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=143709 ;