diff options
| author | Jochen Topf <jochen@topf.org> | 2010-11-12 10:38:28 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2010-11-12 10:38:28 +0100 |
| commit | 731bb61b96c58ed3db09105a2db0aac7e94c71d8 (patch) | |
| tree | 75cc85c101c7ca71922a2c9b3510ff1441e96c08 /sources/db/post.sql | |
| parent | 8659836de44428298bf214b9d556f64791731760 (diff) | |
| download | taginfo-731bb61b96c58ed3db09105a2db0aac7e94c71d8.tar taginfo-731bb61b96c58ed3db09105a2db0aac7e94c71d8.tar.gz | |
fixed two typos
Diffstat (limited to 'sources/db/post.sql')
| -rw-r--r-- | sources/db/post.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sources/db/post.sql b/sources/db/post.sql index 22f05af..e182a28 100644 --- a/sources/db/post.sql +++ b/sources/db/post.sql @@ -45,8 +45,8 @@ INSERT INTO stats (key, value) SELECT 'characters_in_keys_space', count(*) FRO INSERT INTO stats (key, value) SELECT 'characters_in_keys_problem', count(*) FROM keys WHERE characters='problem'; INSERT INTO stats (key, value) SELECT 'characters_in_keys_rest', count(*) FROM keys WHERE characters='rest'; -INSERT INTO stats (key, value) VALUES ('objects', (SELECT sum(value) FROM stats WHERE key IN ('nodes', 'ways', 'relations'))); -INSERT INTO stats (key, value) VALUES ('objects_tags', (SELECT sum(value) FROM stats WHERE key IN ('node_tags', 'way_tags', 'relation_tags'))); +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'))); UPDATE keys SET prevalent_values=( SELECT group_concat(value, '|') FROM ( |