diff options
| author | Jochen Topf <jochen@topf.org> | 2011-10-14 10:13:46 +0200 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2011-10-14 10:13:46 +0200 |
| commit | b0c8aca29aad6ac0adfb8fd78cb52734ff86f3b8 (patch) | |
| tree | 333f831446b204198f35d558cc50877932c9c82d | |
| parent | 37ca149ae63128c6adabfc428a8d9b713bab7d69 (diff) | |
| download | taginfo-b0c8aca29aad6ac0adfb8fd78cb52734ff86f3b8.tar taginfo-b0c8aca29aad6ac0adfb8fd78cb52734ff86f3b8.tar.gz | |
fix db index
| -rw-r--r-- | sources/db/post.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sources/db/post.sql b/sources/db/post.sql index 819dfbd..c3486bb 100644 --- a/sources/db/post.sql +++ b/sources/db/post.sql @@ -21,7 +21,7 @@ CREATE INDEX tags_key_idx ON tags (key); -- CREATE UNIQUE INDEX tags_key_value_idx ON tags (key, value); CREATE INDEX keypairs_key1_idx ON keypairs (key1); CREATE INDEX keypairs_key2_idx ON keypairs (key2); -CREATE UNIQUE INDEX key_distributions_key_idx ON key_distributions (key); +CREATE UNIQUE INDEX key_distributions_key_idx ON key_distributions (key, object_type); INSERT INTO stats (key, value) SELECT 'num_keys', count(*) FROM keys; INSERT INTO stats (key, value) SELECT 'num_keys_on_nodes', count(*) FROM keys WHERE count_nodes > 0; |