CREATE TABLE `geo_block` (

  `startIpNum` INT(10) UNSIGNED DEFAULT NULL COMMENT '시작IP숫자',

  `endIpNum` INT(10) UNSIGNED DEFAULT NULL COMMENT '종료IP숫자',

  `locId` INT(10) UNSIGNED DEFAULT NULL COMMENT '지역ID',

  KEY `idx_startIpNum` (`startIpNum`)

) ENGINE=MYISAM DEFAULT CHARSET=utf8

CREATE TABLE `geo_location` (

  `locId` INT(11) NOT NULL COMMENT '지역ID',

  `country` CHAR(2) DEFAULT NULL COMMENT '국가코드',

  `region` CHAR(2) DEFAULT NULL COMMENT '지역코드',

  `city` VARCHAR(255) DEFAULT NULL COMMENT '도시명',

  `postalCode` VARBINARY(6) DEFAULT NULL COMMENT 'For US, Zipcodes, for Canada, postal codes.',

  `latitude` FLOAT DEFAULT NULL COMMENT '위도 : Latitude of city where IP is located',

  `longitude` FLOAT DEFAULT NULL COMMENT '경도 : Longitude of city where IP is located',

  `metroCode` INT(10) UNSIGNED DEFAULT NULL COMMENT 'Metropolitan Area (US Only).',

  `areaCode` INT(10) UNSIGNED DEFAULT NULL COMMENT 'Three digit telephone prefix (US Only).',

  PRIMARY KEY  (`locId`)

) ENGINE=MYISAM DEFAULT CHARSET=utf8

LOAD DATA LOCAL INFILE 'D:/work/homepage/html/web_work/geolitecity/file/data/GeoLiteCity-Location.csv' INTO TABLE geo_location 

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\n' 

IGNORE 2 LINES

LOAD DATA LOCAL INFILE 'D:/work/homepage/html/web_work/geolitecity/file/data/GeoLiteCity-Blocks.csv' INTO TABLE geo_block

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\n' 

IGNORE 2 LINES