PBf24yB5

1DROP TABLE IF EXISTS location;
2
3CREATE TABLE `location` (
4  `geoname_id` bigint(20) NOT NULL,
5  `locale_code` varchar(5) DEFAULT NULL,
6  `continent_code` varchar(5) DEFAULT NULL,
7  `continent_name` varchar(50) DEFAULT NULL,
8  `country_iso_code` varchar(5) DEFAULT NULL,
9  `country_name` varchar(50) DEFAULT NULL,
10  `subdivision_1_iso_code` varchar(5) DEFAULT NULL,
11  `subdivision_1_name` varchar(50) DEFAULT NULL,
12  `subdivision_2_iso_code` varchar(5) DEFAULT NULL,
13  `subdivision_2_name` varchar(50) DEFAULT NULL,
14  `city_name` varchar(100) DEFAULT NULL,
15  `metro_code` varchar(50) DEFAULT NULL,
16  `time_zone` varchar(100) DEFAULT NULL,
17  `is_in_european_union` tinyint(1) DEFAULT NULL,
18  PRIMARY KEY (`geoname_id`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8;
20
21DROP TABLE IF EXISTS blocks;
22
23CREATE TABLE `blocks` (
24  `network` varchar(25) NOT NULL,
25  `geoname_id` bigint(20) DEFAULT NULL,
26  `registered_country_geoname_id` bigint(20) DEFAULT NULL,
27  `represented_country_geoname_id,` bigint(20) DEFAULT NULL,
28  `is_anonymous_proxy` tinyint(1) DEFAULT NULL,
29  `is_satellite_provider` tinyint(1) DEFAULT NULL,
30  `postal_code` varchar(30) DEFAULT NULL,
31  `latitude` varchar(30) DEFAULT NULL,
32  `longitude` varchar(30) DEFAULT NULL,
33  `accuracy_radius` bigint(20) DEFAULT NULL,
34  PRIMARY KEY (`network`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;