geoip Table¶
IP range to country mapping cache used by the login server. Only used when geolocking is enabled.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
network_start_integer |
int(11) | MUL | YES | ||
network_last_integer |
int(11) | MUL | YES | ||
geoname_id |
text | YES | |||
registered_country_geoname_id |
text | YES | |||
represented_country_geoname_id |
text | YES | |||
is_anonymous_proxy |
int(11) | YES | |||
is_satellite_provider |
int(11) | YES | |||
postal_code |
text | YES | |||
latitude |
double | YES | |||
longitude |
double | YES | |||
accuracy_radius |
int(11) | YES |
Field Breakdown¶
network_start_integer- Numeric IP range boundaries for the network block.network_last_integer- Numeric IP range boundaries for the network block.geoname_id- Most specific (city-level) GeoName id; compared whenGEO_CITYlocking is used.registered_country_geoname_id- Registered (as opposed to routed) country.represented_country_geoname_id- Military/embassy representative country if any.is_anonymous_proxy- Classification flags from the GeoIP dataset.is_satellite_provider- Classification flags from the GeoIP dataset.postal_code- Postal code when known.latitude- Approximate location and radius (km).longitude- Approximate location and radius (km).accuracy_radius- Approximate location and radius (km).