From 9bf8a7a6c5b743d66bc59eb2c4f6703ca2767187 Mon Sep 17 00:00:00 2001 From: "Michael J. Rubinsky" Date: Mon, 28 Dec 2009 10:49:37 -0500 Subject: [PATCH] Move spatial schema into kronolith.*.sql scripts --- kronolith/scripts/sql/kronolith.mysql.sql | 8 ++++++++ kronolith/scripts/sql/kronolith.sql | 8 ++++++++ kronolith/scripts/sql/kronolith_geo.mysql.sql | 10 ---------- kronolith/scripts/sql/kronolth_add_geo.sql | 9 --------- 4 files changed, 16 insertions(+), 19 deletions(-) delete mode 100644 kronolith/scripts/sql/kronolith_geo.mysql.sql delete mode 100644 kronolith/scripts/sql/kronolth_add_geo.sql diff --git a/kronolith/scripts/sql/kronolith.mysql.sql b/kronolith/scripts/sql/kronolith.mysql.sql index 9570ac7b8..c75a8fb9b 100644 --- a/kronolith/scripts/sql/kronolith.mysql.sql +++ b/kronolith/scripts/sql/kronolith.mysql.sql @@ -95,3 +95,11 @@ CREATE TABLE kronolith_resources ( CREATE INDEX kronolith_resources_type_idx ON kronolith_resources (resource_type); CREATE INDEX kronolith_resources_calendar_idx ON kronolith_resources (resource_calendar); + +CREATE TABLE kronolith_events_geo ( + event_id VARCHAR(32) NOT NULL, + event_coordinates POINT NOT NULL, + SPATIAL INDEX (event_coordinates) +); + +CREATE INDEX kronolith_events_geo_idx ON kronolith_events_geo (event_id); diff --git a/kronolith/scripts/sql/kronolith.sql b/kronolith/scripts/sql/kronolith.sql index d96bc792f..a99c841f8 100644 --- a/kronolith/scripts/sql/kronolith.sql +++ b/kronolith/scripts/sql/kronolith.sql @@ -95,3 +95,11 @@ CREATE TABLE kronolith_resources ( CREATE INDEX kronolith_resources_type_idx ON kronolith_resources (resource_type); CREATE INDEX kronolith_resources_calendar_idx ON kronolith_resources (resource_calendar); + +CREATE TABLE kronolith_events_geo ( + event_id VARCHAR(32) NOT NULL, + event_lat VARCHAR(32) NOT NULL, + event_lon VARCHAR(32) NOT NULL +); + +CREATE INDEX kronolith_events_geo_idx ON kronolith_events_geo (event_id); diff --git a/kronolith/scripts/sql/kronolith_geo.mysql.sql b/kronolith/scripts/sql/kronolith_geo.mysql.sql deleted file mode 100644 index 4b10c5575..000000000 --- a/kronolith/scripts/sql/kronolith_geo.mysql.sql +++ /dev/null @@ -1,10 +0,0 @@ --- This script creates the table and indexs necessary to use kronolith's geo --- location features with a gis extension enabled mySQL database. - -CREATE TABLE kronolith_events_geo ( - event_id VARCHAR(32) NOT NULL, - event_coordinates POINT NOT NULL, - SPATIAL INDEX (event_coordinates) -); - -CREATE INDEX kronolith_events_geo_idx ON kronolith_events_geo (event_id); \ No newline at end of file diff --git a/kronolith/scripts/sql/kronolth_add_geo.sql b/kronolith/scripts/sql/kronolth_add_geo.sql deleted file mode 100644 index bfeaf78fe..000000000 --- a/kronolith/scripts/sql/kronolth_add_geo.sql +++ /dev/null @@ -1,9 +0,0 @@ --- Use this script to create the table and index necessary for geo location --- support without mysql spatial extension support. -CREATE TABLE kronolith_events_geo ( - event_id VARCHAR(32) NOT NULL, - event_lat VARCHAR(32) NOT NULL, - event_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