From 731bb61b96c58ed3db09105a2db0aac7e94c71d8 Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Fri, 12 Nov 2010 10:38:28 +0100 Subject: fixed two typos --- sources/db/post.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sources') 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 ( -- cgit v1.2.3