-
Notifications
You must be signed in to change notification settings - Fork 18
/
Copy pathschema.sql
82 lines (75 loc) · 2.66 KB
/
schema.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
create table geoip_asn_blocks_ipv4
(
prefix String,
autonomous_system_number UInt32,
autonomous_system_organization String
) ENGINE = Dictionary('geoip_asn_blocks_ipv4');
create table geoip_asn_blocks_ipv6
(
prefix String,
autonomous_system_number UInt32,
autonomous_system_organization String
) ENGINE = Dictionary('geoip_asn_blocks_ipv6');
create table geoip_city_locations_en
(
geoname_id UInt64,
locale_code String,
continent_code String,
continent_name String,
country_iso_code String,
country_name String,
subdivision_1_iso_code String,
subdivision_1_name String,
subdivision_2_iso_code String,
subdivision_2_name String,
city_name String,
metro_code UInt32,
time_zone String,
is_in_european_union UInt8
) ENGINE = Dictionary('geoip_city_locations_en');
create table geoip_city_blocks_ipv4
(
prefix String,
geoname_id UInt32,
registered_country_geoname_id UInt32,
represented_country_geoname_id UInt32,
postal_code String,
latitude Float32,
longitude Float32,
accuracy_radius UInt32
) ENGINE = Dictionary('geoip_city_blocks_ipv4');
create table geoip_city_blocks_ipv6
(
prefix String,
geoname_id UInt32,
registered_country_geoname_id UInt32,
represented_country_geoname_id UInt32,
postal_code String,
latitude Float32,
longitude Float32,
accuracy_radius UInt32
) ENGINE = Dictionary('geoip_city_blocks_ipv6');
create table geoip_country_locations_en
(
geoname_id UInt64,
locale_code String,
continent_code String,
continent_name String,
country_iso_code String,
country_name String,
is_in_european_union UInt8
) ENGINE = Dictionary('geoip_country_locations_en');
create table geoip_country_blocks_ipv4
(
prefix String,
geoname_id UInt32,
registered_country_geoname_id UInt32,
represented_country_geoname_id UInt32
) ENGINE = Dictionary('geoip_country_blocks_ipv4');
create table geoip_country_blocks_ipv6
(
prefix String,
geoname_id UInt32,
registered_country_geoname_id UInt32,
represented_country_geoname_id UInt32
) ENGINE = Dictionary('geoip_country_blocks_ipv6');