From e3827f1b7efc3d07809b1138ed8582b81bda8867 Mon Sep 17 00:00:00 2001 From: "Michael J. Rubinsky" Date: Fri, 4 Dec 2009 11:34:49 -0500 Subject: [PATCH] Add creation scripts for geo table --- kronolith/scripts/upgrades/2009-12-03_add_geo.mysql.sql | 5 +++++ kronolith/scripts/upgrades/2009-12-03_add_geo.sql | 7 +++++++ 2 files changed, 12 insertions(+) create mode 100644 kronolith/scripts/upgrades/2009-12-03_add_geo.mysql.sql create mode 100644 kronolith/scripts/upgrades/2009-12-03_add_geo.sql diff --git a/kronolith/scripts/upgrades/2009-12-03_add_geo.mysql.sql b/kronolith/scripts/upgrades/2009-12-03_add_geo.mysql.sql new file mode 100644 index 000000000..bce36040d --- /dev/null +++ b/kronolith/scripts/upgrades/2009-12-03_add_geo.mysql.sql @@ -0,0 +1,5 @@ +CREATE TABLE kronolith_events_geo ( + event_id VARCHAR(32) NOT NULL, + coordinates POINT NOT NULL, + SPATIAL INDEX (coordinates) +); diff --git a/kronolith/scripts/upgrades/2009-12-03_add_geo.sql b/kronolith/scripts/upgrades/2009-12-03_add_geo.sql new file mode 100644 index 000000000..3c24f9895 --- /dev/null +++ b/kronolith/scripts/upgrades/2009-12-03_add_geo.sql @@ -0,0 +1,7 @@ +CREATE TABLE kronolith_events_geo ( + event_id VARCHAR(32) NOT NULL, + lat VARCHAR(32) NOT NULL, + lon VARCHAR(32) NOT NULL +); + +CREATE INDEX kronolith_events_geo_idx ON kronolith_events_geo (event_id); \ No newline at end of file -- 2.11.0