NgXZ4iLb

1CREATE TABLE IF NOT EXISTS `bets` (
2  `id` int(10) NOT NULL AUTO_INCREMENT,
3  `user_id` int(10) NOT NULL,
4  `opening_time` DATETIME NOT NULL,
5  `closing_time` DATETIME NOT NULL,
6  `balance` decimal(10,2) NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
9
10-- --------------------------------------------------------
11
12--
13-- Структура таблицы `blocked_ips`
14--
15
16CREATE TABLE IF NOT EXISTS `blocked_ips` (
17  `id` int(11) NOT NULL AUTO_INCREMENT,
18  `ip` varchar(64) DEFAULT NULL,
19  `blocked_time` datetime DEFAULT NULL,
20  PRIMARY KEY (`id`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
22
23
24-- --------------------------------------------------------
25
26--
27-- Структура таблицы `log`
28--
29
30CREATE TABLE IF NOT EXISTS `log` (
31  `id` int(10) NOT NULL AUTO_INCREMENT,
32  `user_name` varchar(32) DEFAULT NULL,
33  `ip` varchar(64) NOT NULL,
34  `date` datetime NOT NULL,
35  `is_logged` int(11) DEFAULT NULL,
36  `os` varchar(32) DEFAULT NULL,
37  `device` varchar(32) DEFAULT NULL,
38  `browser` varchar(32) DEFAULT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=124 ;
41
42--
43-- Структура таблицы `users`
44--
45
46CREATE TABLE IF NOT EXISTS `users` (
47  `id` int(10) NOT NULL AUTO_INCREMENT,
48  `name` varchar(32) DEFAULT NULL,
49  `email` varchar(64) DEFAULT NULL,
50  `password` varchar(32) DEFAULT NULL,
51  `ip` varchar(32) DEFAULT NULL,
52  `balance` decimal(10,2) DEFAULT '0.00',
53  `status` int(11) DEFAULT '1',
54  `hash` varchar(32) DEFAULT NULL,
55  `reg_date` datetime DEFAULT NULL,
56  `active` int(11) DEFAULT '1',
57  `restore` varchar(32) DEFAULT NULL,
58  `email_active` int(1) NOT NULL,
59  PRIMARY KEY (`id`)
60) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
61
62/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
63/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
64/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;