Categories

Maxmind GeoIPCity

Create Table for mysql with:

CREATE TABLE geo_ip (
start int(10) unsigned NOT NULL,
end int(10) unsigned NOT NULL,
ci tinyint(3) unsigned NOT NULL
);

CREATE TABLE geo_ipcity (
LOCID       unsigned NOT NULL,
COUNTRY      varchar(2) NOT NULL,
REGION           varchar(2) ,
CITY              varchar(255) ,
POSTALCODE     varchar(6) ,
LATITUDE         DECIMAL(10,6),
LONGITUDE      DECIMAL(10,6),
DMACODE           varchar(3) ,
AREACODE     varchar(3)
);

mysql

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

nc_addfooter

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close