diff options
author | Jochen Topf <jochen@topf.org> | 2010-11-09 15:54:06 +0100 |
---|---|---|
committer | Jochen Topf <jochen@topf.org> | 2010-11-09 15:54:06 +0100 |
commit | 6382e7aa94c08df95b1429be3aae0393af642253 (patch) | |
tree | e4548ca13eb5a187c160649c51a2f4fd2eb75f16 /sources/master/master.sql | |
parent | f3a58367ddca7282b91ca8c2ce9546f35f0d272d (diff) | |
download | taginfo-6382e7aa94c08df95b1429be3aae0393af642253.tar taginfo-6382e7aa94c08df95b1429be3aae0393af642253.tar.gz |
Numerous report improvments
Diffstat (limited to 'sources/master/master.sql')
-rw-r--r-- | sources/master/master.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sources/master/master.sql b/sources/master/master.sql index 331a464..fc0ccef 100644 --- a/sources/master/master.sql +++ b/sources/master/master.sql @@ -111,5 +111,9 @@ UPDATE popular_keys SET scale_name = 0 WHERE key LIKE '%:%'; UPDATE popular_keys SET scale1 = 10 * scale_count + 8 * scale_users + 2 * scale_wiki + 1 * scale_josm + 2 * scale_name; +INSERT INTO languages (code) SELECT distinct(lang) FROM wiki.wikipages WHERE lang NOT IN (SELECT code FROM languages); +UPDATE languages SET wiki_key_pages=(SELECT count(distinct key) FROM wiki.wikipages WHERE lang=code AND value IS NULL); +UPDATE languages SET wiki_tag_pages=(SELECT count(distinct key) FROM wiki.wikipages WHERE lang=code AND value IS NOT NULL); + ANALYZE; |