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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
--
-- Taginfo source: Wiki
--
-- pre.sql
--
.bail ON
INSERT INTO source (id, name, update_start, data_until) SELECT 'wiki', 'Wiki', datetime('now'), datetime('now');
DROP TABLE IF EXISTS wikipages;
CREATE TABLE wikipages (
lang TEXT,
tag TEXT,
key TEXT,
value TEXT,
title TEXT,
body TEXT,
tgroup TEXT,
type TEXT,
has_templ INTEGER,
parsed INTEGER,
description TEXT,
image TEXT,
on_node INTEGER,
on_way INTEGER,
on_area INTEGER,
on_relation INTEGER,
tags_implies TEXT,
tags_combination TEXT,
tags_linked TEXT,
status TEXT
);
DROP TABLE IF EXISTS relation_pages;
CREATE TABLE relation_pages (
lang TEXT,
rtype TEXT,
title TEXT,
body TEXT,
tgroup TEXT,
type TEXT,
has_templ INTEGER,
parsed INTEGER,
description TEXT,
image TEXT,
tags_linked TEXT,
status TEXT
);
DROP TABLE IF EXISTS wiki_images;
CREATE TABLE wiki_images (
image TEXT,
width INTEGER,
height INTEGER,
size INTEGER,
mime TEXT,
image_url TEXT,
thumb_url_prefix TEXT,
thumb_url_suffix TEXT
);
DROP TABLE IF EXISTS wikipages_keys;
CREATE TABLE wikipages_keys (
key TEXT,
langs TEXT,
lang_count INTEGER
);
DROP TABLE IF EXISTS wikipages_tags;
CREATE TABLE wikipages_tags (
key TEXT,
value TEXT,
langs TEXT,
lang_count INTEGER
);
DROP TABLE IF EXISTS wiki_languages;
CREATE TABLE wiki_languages (
language TEXT,
count_pages INTEGER
);
DROP TABLE IF EXISTS wiki_links;
CREATE TABLE wiki_links (
link_class TEXT,
from_title TEXT,
from_lang TEXT,
from_type TEXT,
from_name TEXT,
to_title TEXT,
to_lang TEXT,
to_type TEXT,
to_name TEXT
);
DROP TABLE IF EXISTS invalid_page_title;
CREATE TABLE invalid_page_titles (
reason TEXT,
title TEXT
);
DROP TABLE IF EXISTS invalid_image_titles;
CREATE TABLE invalid_image_titles (
reason TEXT,
page_title TEXT,
image_title TEXT
);
DROP TABLE IF EXISTS words;
CREATE TABLE words (
key TEXT,
value TEXT,
words TEXT
);
DROP TABLE IF EXISTS stats;
CREATE TABLE stats (
key TEXT,
value INT64
);
|