diff options
Diffstat (limited to 'sources')
-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 ( |