diff options
| author | Jochen Topf <jochen@topf.org> | 2014-09-18 12:30:54 +0200 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2014-09-18 12:30:54 +0200 |
| commit | 0ce037322548f6b2d3112c0d8ef89dc946777177 (patch) | |
| tree | 8d38521cc952c359b35707e0d4d9504415c5ebd2 | |
| parent | e274cf715745b56c8ff7a413b2e1574f59396299 (diff) | |
| download | taginfo-0ce037322548f6b2d3112c0d8ef89dc946777177.tar taginfo-0ce037322548f6b2d3112c0d8ef89dc946777177.tar.gz | |
More JOSM cleanup.
| -rw-r--r-- | sources/master/master.sql | 3 |
1 files changed, 1 insertions, 2 deletions
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, |