From 0ce037322548f6b2d3112c0d8ef89dc946777177 Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Thu, 18 Sep 2014 12:30:54 +0200 Subject: More JOSM cleanup. --- sources/master/master.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'sources') diff --git a/sources/master/master.sql b/sources/master/master.sql index d1b62dd..b271593 100644 --- a/sources/master/master.sql +++ b/sources/master/master.sql @@ -49,7 +49,7 @@ INSERT INTO master_stats SELECT * FROM db.stats -- ============================================================================ -INSERT INTO db.keys (key) SELECT DISTINCT key FROM wiki.wikipages WHERE key NOT IN (SELECT key FROM db.keys); +INSERT INTO db.keys (key) SELECT DISTINCT key FROM wiki.wikipages WHERE key NOT IN (SELECT key FROM db.keys); UPDATE db.keys SET in_wiki=1 WHERE key IN (SELECT distinct key FROM wiki.wikipages WHERE value IS NULL); UPDATE db.keys SET in_wiki_en=1 WHERE key IN (SELECT distinct key FROM wiki.wikipages WHERE value IS NULL AND lang='en'); @@ -75,7 +75,6 @@ CREATE TABLE popular_keys ( wikipages INTEGER DEFAULT 0, in_wiki INTEGER DEFAULT 0, in_wiki_en INTEGER DEFAULT 0, - in_josm INTEGER DEFAULT 0, in_potlatch INTEGER DEFAULT 0, scale_count REAL, scale_users REAL, -- cgit v1.2.3