From 53d085f513d5e29af160991739e7ad1b515090a7 Mon Sep 17 00:00:00 2001 From: marcus Date: Tue, 25 Nov 2008 20:09:14 +0000 Subject: Hook for future geocoding library added. git-svn-id: https://code.elgg.org/elgg/trunk@2488 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'engine/schema/mysql.sql') diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index bf2833ee4..59f11357b 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -274,6 +274,18 @@ CREATE TABLE `prefix_hmac_cache` ( KEY `ts` (`ts`) ) ENGINE=MEMORY; +-- Geocode engine cache +CREATE TABLE `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; + -- PHP Session storage CREATE TABLE `prefix_users_sessions` ( `session` varchar(255) NOT NULL, -- cgit v1.2.3