From 0fdfaca9dfad26abe8f6e25ef12ca1824d2e0c10 Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Mon, 29 Sep 2014 15:44:45 +0200 Subject: Use new top_tags table instead of old selected_tags table. --- sources/db/post.sql | 5 +++++ sources/db/pre.sql | 2 +- sources/master/master.sql | 5 ----- 3 files changed, 6 insertions(+), 6 deletions(-) (limited to 'sources') diff --git a/sources/db/post.sql b/sources/db/post.sql index 35c0a43..08f33b0 100644 --- a/sources/db/post.sql +++ b/sources/db/post.sql @@ -27,6 +27,9 @@ CREATE INDEX tag_combinations_key2_value2_idx ON tag_combinations (key2, CREATE UNIQUE INDEX relation_types_rtype_idx ON relation_types (rtype); CREATE INDEX relation_roles_rtype_idx ON relation_roles (rtype); +-- ============================================================================ +-- deprecated: can be removed soon + INSERT INTO selected_tags (skey, svalue) SELECT key1, value1 FROM tag_combinations WHERE value1 != '' UNION @@ -42,6 +45,8 @@ ANALYZE selected_tags; CREATE UNIQUE INDEX selected_tags_key_value_idx ON selected_tags (skey, svalue); +-- ============================================================================ + 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; INSERT INTO stats (key, value) SELECT 'num_keys_on_ways', count(*) FROM keys WHERE count_ways > 0; diff --git a/sources/db/pre.sql b/sources/db/pre.sql index 9d349a3..e0320ea 100644 --- a/sources/db/pre.sql +++ b/sources/db/pre.sql @@ -134,8 +134,8 @@ CREATE TABLE prevalent_roles ( fraction REAL ); +-- deprecated: can be removed soon DROP TABLE IF EXISTS selected_tags; - CREATE TABLE selected_tags ( skey VARCHAR, svalue VARCHAR, diff --git a/sources/master/master.sql b/sources/master/master.sql index 5397a4c..8433ec5 100644 --- a/sources/master/master.sql +++ b/sources/master/master.sql @@ -62,13 +62,8 @@ UPDATE db.keys SET in_wiki_en=1 WHERE key IN (SELECT distinct key FROM wiki.wiki UPDATE db.tags SET in_wiki=1 WHERE key IN (SELECT distinct key FROM wiki.wikipages WHERE value IS NOT NULL AND value != '*') AND key || '=' || value IN (SELECT distinct tag FROM wiki.wikipages WHERE value IS NOT NULL AND value != '*'); UPDATE db.tags SET in_wiki_en=1 WHERE key IN (SELECT distinct key FROM wiki.wikipages WHERE value IS NOT NULL AND value != '*' AND lang='en') AND key || '=' || value IN (SELECT distinct tag FROM wiki.wikipages WHERE value IS NOT NULL AND value != '*' AND lang='en'); -UPDATE db.selected_tags SET in_wiki=1 WHERE skey || '=' || svalue IN (SELECT distinct tag FROM wiki.wikipages WHERE value IS NOT NULL AND value != '*'); -UPDATE db.selected_tags SET in_wiki_en=1 WHERE skey || '=' || svalue IN (SELECT distinct tag FROM wiki.wikipages WHERE value IS NOT NULL AND value != '*' AND lang='en'); - -- ============================================================================ --- currently unused future replacement for db.selected_tags - DROP TABLE IF EXISTS top_tags; CREATE TABLE top_tags ( skey VARCHAR, -- cgit v1.2.3