Simple SQL script to load os locator data into MySQL

load_oslocator.sql

delimiter $$

DROP TABLE IF EXISTS OSDATA.locator;

CREATE TABLE OSDATA.locator (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `classification` varchar(45) NOT NULL,
  `centx` int(11) NOT NULL DEFAULT '0',
  `centy` int(11) NOT NULL DEFAULT '0',
  `minx` int(11) NOT NULL DEFAULT '0',
  `maxx` int(11) NOT NULL DEFAULT '0',
  `miny` int(11) NOT NULL DEFAULT '0',
  `maxy` int(11) NOT NULL DEFAULT '0',
  `settlement` varchar(255) NOT NULL,
  `locality` varchar(255) NOT NULL,
  `cou_unit` varchar(255) NOT NULL,
  `local_auth` varchar(255) NOT NULL,
  `tile_10k` varchar(45) DEFAULT NULL,
  `tile_25k` varchar(45) DEFAULT NULL,
  `source` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `road_name_classification_indx` (`name`,`classification`),
  FULLTEXT KEY `road_name_fulltext` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8$$

LOAD DATA LOCAL INFILE "/tmp/os_locator.txt" 
INTO TABLE OSDATA.locator FIELDS TERMINATED BY ':'  
ESCAPED BY '"' 
LINES TERMINATED BY '\r\n' 
(name,classification,centx,centy,minx,maxx,miny,maxy,settlement,locality,cou_unit,local_auth,tile_10k,tile_25k,source);