znUVhjMX

1CREATE TABLE IF NOT EXISTS `tennis_h2h` (
2  `h2h_id` int(11) NOT NULL,
3  `event_name` varchar(255) NOT NULL,
4  `date` date NOT NULL,
5  `date_h2h` date NOT NULL,
6  `lvl` varchar(10) NOT NULL,
7  `event` varchar(50) NOT NULL,
8  `round` varchar(50) NOT NULL,
9  `surface` varchar(25) NOT NULL,
10  `betting_1` float(10,2) unsigned NOT NULL,
11  `betting_2` float(10,2) unsigned NOT NULL,
12  `advantage_1` tinyint(3) unsigned NOT NULL,
13  `advantage_2` tinyint(3) unsigned NOT NULL,
14  `rank_1` smallint(5) unsigned NOT NULL,
15  `rank_2` smallint(5) unsigned NOT NULL,
16  `games_balance_1` smallint(6) NOT NULL,
17  `games_balance_2` smallint(6) NOT NULL,
18  `sex` varchar(3) NOT NULL,
19  `full_json` varchar(2048) NOT NULL,
20  PRIMARY KEY (`h2h_id`),
21  KEY `event_name` (`event_name`,`date`)
22) ENGINE=MyISAM DEFAULT CHARSET=utf8;
23
24
25JSON -> SQL
26G_balance -> games_balance
27rnd -> round
28dt -> date_h2h
29
30
31(SQL) date - дата, которая в запросе к апи
32(SQL) full_json - полный ответ от апи
33
34
35обязательно проверить "checked":"3" - это значит присутствует полный ответ