Elgg-Lorea-Hydra/engine/schema/upgrades/2008112501.sql

CREATE TABLE IF NOT EXISTS `prefix_geocode_cache` (
	id     int(11)     auto_increment,
	location varchar(128),
	`lat`    varchar(20),
	`long`   varchar(20),
	
	PRIMARY KEY (`id`),
    KEY `location` (`location`)
	
) ENGINE=MEMORY;