diff options
| author | Jochen Topf <jochen@topf.org> | 2014-09-29 15:44:45 +0200 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2014-09-29 15:48:21 +0200 |
| commit | 0fdfaca9dfad26abe8f6e25ef12ca1824d2e0c10 (patch) | |
| tree | 04bb19587e8eb085aeabe6464719805c1f9c95fa /sources/master | |
| parent | 99cfae85fd8af0a7d8954b343dc53c4c9ba5b687 (diff) | |
| download | taginfo-0fdfaca9dfad26abe8f6e25ef12ca1824d2e0c10.tar taginfo-0fdfaca9dfad26abe8f6e25ef12ca1824d2e0c10.tar.gz | |
Use new top_tags table instead of old selected_tags table.
Diffstat (limited to 'sources/master')
| -rw-r--r-- | sources/master/master.sql | 5 |
1 files changed, 0 insertions, 5 deletions
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, |