diff options
| -rw-r--r-- | sources/db/post_indexes.sql | 1 | ||||
| -rw-r--r-- | sources/db/post_similar_keys.sql | 5 |
2 files changed, 5 insertions, 1 deletions
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. |