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