1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
--
-- Taginfo source: Wiki
--
-- post.sql
--
.bail ON
UPDATE wikipages SET status='r' WHERE type='redirect';
UPDATE wikipages SET status='p' WHERE type='page' AND has_templ=0;
UPDATE wikipages SET status='t' WHERE type='page' AND has_templ=1 AND parsed=1;
UPDATE wikipages SET status='e' WHERE type='page' AND has_templ=1 AND parsed=0;
CREATE INDEX wikipages_key_value_idx ON wikipages(key, value);
UPDATE relation_pages SET status='r' WHERE type='redirect';
UPDATE relation_pages SET status='p' WHERE type='page' AND has_templ=0;
UPDATE relation_pages SET status='t' WHERE type='page' AND has_templ=1 AND parsed=1;
UPDATE relation_pages SET status='e' WHERE type='page' AND has_templ=1 AND parsed=0;
CREATE INDEX relation_pages_rtype_idx ON relation_pages(rtype);
CREATE INDEX wiki_images_image_idx ON wiki_images(image);
INSERT INTO wikipages_keys (key, langs, lang_count) SELECT key, group_concat(lang || ' ' || status), count(*) FROM wikipages WHERE value IS NULL GROUP BY key;
INSERT INTO wikipages_tags (key, value, langs, lang_count) SELECT key, value, group_concat(lang || ' ' || status), count(*) FROM wikipages WHERE value IS NOT NULL AND value != '*' GROUP BY key, value;
INSERT INTO wiki_languages (language, count_pages) SELECT lang, count(*) FROM wikipages GROUP BY lang;
INSERT INTO stats (key, value) SELECT 'wiki_images', count(*) FROM wiki_images;
INSERT INTO stats (key, value) SELECT 'wiki_keys_described', count(*) FROM wikipages_keys;
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_keys', count(*) FROM wikipages WHERE value IS NULL;
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_keys_redirect', count(*) FROM wikipages WHERE value IS NULL AND status='r';
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_keys_without_template', count(*) FROM wikipages WHERE value IS NULL AND status='p';
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_keys_with_template', count(*) FROM wikipages WHERE value IS NULL AND status='t';
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_keys_with_error', count(*) FROM wikipages WHERE value IS NULL AND status='e';
INSERT INTO stats (key, value) SELECT 'wiki_tags_described', count(*) FROM wikipages_tags;
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_tags', count(*) FROM wikipages WHERE value IS NOT NULL;
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_tags_redirect', count(*) FROM wikipages WHERE value IS NOT NULL AND status='r';
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_tags_without_template', count(*) FROM wikipages WHERE value IS NOT NULL AND status='p';
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_tags_with_template', count(*) FROM wikipages WHERE value IS NOT NULL AND status='t';
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_tags_with_error', count(*) FROM wikipages WHERE value IS NOT NULL AND status='e';
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_relation_types', count(*) FROM relation_pages;
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_relation_types_redirect', count(*) FROM relation_pages WHERE status='r';
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_relation_types_without_template', count(*) FROM relation_pages WHERE status='p';
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_relation_types_with_template', count(*) FROM relation_pages WHERE status='t';
INSERT INTO stats (key, value) SELECT 'wiki_pages_for_relation_types_with_error', count(*) FROM relation_pages WHERE status='e';
INSERT INTO stats (key, value) SELECT 'wiki_languages', count(*) FROM wiki_languages;
ANALYZE;
UPDATE source SET update_end=datetime('now');
|