From 48240be189cb6453465103ff535c3f22aed48f8e Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Fri, 6 Mar 2015 20:55:31 +0100 Subject: Move creation of index forward... --- sources/db/post_indexes.sql | 1 - sources/db/post_similar_keys.sql | 5 +++++ 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/sources/db/post_indexes.sql b/sources/db/post_indexes.sql index 3f53ea5..8125e79 100644 --- a/sources/db/post_indexes.sql +++ b/sources/db/post_indexes.sql @@ -13,7 +13,6 @@ PRAGMA cache_size = 5000000; -- ============================================================================ -CREATE UNIQUE INDEX keys_key_idx ON keys (key); CREATE INDEX tags_key_idx ON tags (key); -- CREATE UNIQUE INDEX tags_key_value_idx ON tags (key, value); CREATE INDEX key_combinations_key1_idx ON key_combinations (key1); diff --git a/sources/db/post_similar_keys.sql b/sources/db/post_similar_keys.sql index 03b000b..f28d8b2 100644 --- a/sources/db/post_similar_keys.sql +++ b/sources/db/post_similar_keys.sql @@ -13,6 +13,11 @@ PRAGMA cache_size = 5000000; -- ============================================================================ +-- need this index now... +CREATE UNIQUE INDEX keys_key_idx ON keys (key); + +-- ============================================================================ + -- For all keys found to be similar earlier, we get the counts how often they -- appear in the OSM database and store this data in the same table for easy -- access. -- cgit v1.2.3