gZZK9FUR

1CREATE TABLE IF NOT EXISTS `modx_poker_rooms` (
2  `id` int(11) NOT NULL,
3  `name` varchar(255) NOT NULL,
4  `short_name` varchar(50) NOT NULL,
5  `poket_network` int(11) NOT NULL,
6  `type` varchar(20) NOT NULL,
7  `rakeback` float NOT NULL,
8  `type_prefix` tinyint(1) NOT NULL,
9  `start_dep` double NOT NULL,
10  `currency_dep` varchar(20) NOT NULL,
11  `prize` float NOT NULL,
12  `currency_prize` varchar(20) NOT NULL,
13  `extra_bonus` float NOT NULL,
14  `currency_bonus` varchar(20) NOT NULL,
15  `name_points` varchar(30) NOT NULL,
16  `rake_course_curr` varchar(20) NOT NULL,
17  `required_rake` float NOT NULL,
18  `currency_rake` varchar(20) NOT NULL,
19  `cashback` float NOT NULL,
20  `bonus_first_dep` float NOT NULL COMMENT 'Размер бонуса на первый депозит',
21  `bonus_max_first_dep` float NOT NULL COMMENT 'Максимальный размер первого депозита',
22  `currency_first_dep` varchar(20) NOT NULL,
23  `type_pay` varchar(20) NOT NULL,
24  `subuff` float NOT NULL,
25  `vip_program` int(11) NOT NULL,
26  `rating` float NOT NULL,
27  `field_verific` varchar(30) NOT NULL,
28  `additional_register` varchar(200) NOT NULL,
29  `referal_link` varchar(255) NOT NULL,
30  `tags` varchar(40) NOT NULL,
31  `visible` tinyint(4) NOT NULL,
32  `active` tinyint(1) NOT NULL,
33  `sort` int(11) NOT NULL,
34  `priority` tinyint(1) NOT NULL,
35  `platforms` varchar(200) NOT NULL,
36  `game_disciplin` varchar(200) NOT NULL,
37  `country` varchar(255) NOT NULL,
38  `text` text NOT NULL,
39  `image` text NOT NULL,
40  `screen_shots` text NOT NULL,
41  `compare` text NOT NULL
42) ENGINE=InnoDB DEFAULT CHARSET=utf8;