diff options
| author | Jochen Topf <jochen@topf.org> | 2015-03-06 20:55:31 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2015-03-06 20:55:31 +0100 |
| commit | 48240be189cb6453465103ff535c3f22aed48f8e (patch) | |
| tree | 95486f3736a452ccbbf7473cac12ac692bc67552 | |
| parent | 0e97f9b3773585d8fb76659dc710726a888c4851 (diff) | |
| download | taginfo-48240be189cb6453465103ff535c3f22aed48f8e.tar taginfo-48240be189cb6453465103ff535c3f22aed48f8e.tar.gz | |
Move creation of index forward...
| -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. |