diff options
Diffstat (limited to 'sources/wiki')
-rwxr-xr-x | sources/wiki/get_wiki_data.rb | 3 | ||||
-rw-r--r-- | sources/wiki/pre.sql | 43 |
2 files changed, 24 insertions, 22 deletions
diff --git a/sources/wiki/get_wiki_data.rb b/sources/wiki/get_wiki_data.rb index 742e520..f4632ca 100755 --- a/sources/wiki/get_wiki_data.rb +++ b/sources/wiki/get_wiki_data.rb @@ -117,12 +117,13 @@ class WikiPage def insert(db) db.execute( - "INSERT INTO wikipages (lang, tag, key, value, title, tgroup, type, has_templ, parsed, description, image, on_node, on_way, on_area, on_relation, tags_implies, tags_combination, tags_linked) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", + "INSERT INTO wikipages (lang, tag, key, value, title, body, tgroup, type, has_templ, parsed, description, image, on_node, on_way, on_area, on_relation, tags_implies, tags_combination, tags_linked) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", lang, tag, key, value, title, + content, group, type, has_templ, diff --git a/sources/wiki/pre.sql b/sources/wiki/pre.sql index 2cb3bfd..04071eb 100644 --- a/sources/wiki/pre.sql +++ b/sources/wiki/pre.sql @@ -28,53 +28,54 @@ CREATE TABLE stats ( DROP TABLE IF EXISTS wikipages; CREATE TABLE wikipages ( - lang VARCHAR, - tag VARCHAR, - key VARCHAR, - value VARCHAR, - title VARCHAR, - tgroup VARCHAR, - type VARCHAR, + lang TEXT, + tag TEXT, + key TEXT, + value TEXT, + title TEXT, + body TEXT, + tgroup TEXT, + type TEXT, has_templ INTEGER, parsed INTEGER, - description VARCHAR, - image VARCHAR, + description TEXT, + image TEXT, on_node INTEGER, on_way INTEGER, on_area INTEGER, on_relation INTEGER, - tags_implies VARCHAR, - tags_combination VARCHAR, - tags_linked VARCHAR, - status VARCHAR + tags_implies TEXT, + tags_combination TEXT, + tags_linked TEXT, + status TEXT ); DROP TABLE IF EXISTS wikipages_keys; CREATE TABLE wikipages_keys ( - key VARCHAR, - langs VARCHAR + key TEXT, + langs TEXT ); DROP TABLE IF EXISTS wikipages_tags; CREATE TABLE wikipages_tags ( - key VARCHAR, - value VARCHAR, - langs VARCHAR + key TEXT, + value TEXT, + langs TEXT ); DROP TABLE IF EXISTS wiki_languages; CREATE TABLE wiki_languages ( - language VARCHAR, - count_pages INT + language TEXT, + count_pages INTEGER ); DROP TABLE IF EXISTS stats; CREATE TABLE stats ( - key VARCHAR, + key TEXT, value INT64 ); |