diff options
| author | Jochen Topf <jochen@topf.org> | 2015-03-24 18:00:41 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2015-04-28 21:55:12 +0200 |
| commit | 47cb7bf89567ecf603e23068fc5ac07aa801d487 (patch) | |
| tree | 57cbe52fa8c49d7eb1f068f3ef394d36a49bd807 /sources/wiki/pre.sql | |
| parent | c8a334b10512a708d19ed5fd42aa60424290a371 (diff) | |
| download | taginfo-47cb7bf89567ecf603e23068fc5ac07aa801d487.tar taginfo-47cb7bf89567ecf603e23068fc5ac07aa801d487.tar.gz | |
Get and classify all links in wiki to Key/Tag/Relation pages.
This adds two scripts, the first (get_links.rb) uses the Mediawiki API to get
all pages that link to any Key/Tag/Relation pages. The second
(classify_links.rb) puts those links into different categories. The update
script is prepared to call those scripts, but the code is disabled at the
moment.
Diffstat (limited to 'sources/wiki/pre.sql')
| -rw-r--r-- | sources/wiki/pre.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sources/wiki/pre.sql b/sources/wiki/pre.sql index 280949a..742d8f0 100644 --- a/sources/wiki/pre.sql +++ b/sources/wiki/pre.sql @@ -87,6 +87,20 @@ CREATE TABLE wiki_languages ( 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 ( |