diff options
| author | Jochen Topf <jochen@topf.org> | 2010-11-14 15:50:56 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2010-11-14 15:50:56 +0100 |
| commit | fb39187ad8f7f78b4b27af5b3992e103d2d8638b (patch) | |
| tree | 2c4b7802e7b0af7f2938e08f752a1aef9d22ce54 /sources/db | |
| parent | 626e8a38ec2610197ff96252cd1110389021d698 (diff) | |
| download | taginfo-fb39187ad8f7f78b4b27af5b3992e103d2d8638b.tar taginfo-fb39187ad8f7f78b4b27af5b3992e103d2d8638b.tar.gz | |
Prevalent values improvements, some things moved around, reports active
Diffstat (limited to 'sources/db')
| -rw-r--r-- | sources/db/post.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sources/db/post.sql b/sources/db/post.sql index ca6095b..819dfbd 100644 --- a/sources/db/post.sql +++ b/sources/db/post.sql @@ -48,6 +48,7 @@ INSERT INTO stats (key, value) SELECT 'characters_in_keys_rest', count(*) FRO INSERT INTO stats (key, value) VALUES ('objects', (SELECT sum(value) FROM stats WHERE key IN ('nodes', 'ways', 'relations'))); INSERT INTO stats (key, value) VALUES ('object_tags', (SELECT sum(value) FROM stats WHERE key IN ('node_tags', 'way_tags', 'relation_tags'))); +-- XXX this can probably be removed UPDATE keys SET prevalent_values=( SELECT group_concat(value, '|') FROM ( SELECT value FROM tags t |