Better support for wiki images.

Key and tag wiki pages can contain images. Until now we only got the titles of
those images. Now we also get the URL to the image, URL to thumbnails, width,
height, and mime type. This information is now exposed in the API and it is
used to show the images in the Overview tab of the key and tag pages.

While we are changing the update process anyway, I changed the program that
gets the list of all pages to also output the time those pages changed last.
This information is currently not used, but it could be used to cache those
pages locally making the update much faster and adding less strain to the
wiki server.

1 files changed, 21 insertions, 0 deletions

diff --git a/sources/wiki/pre.sql b/sources/wiki/pre.sql
index ebb80d3..8a515e7 100644
--- a/sources/wiki/pre.sql
+++ b/sources/wiki/pre.sql
@@ -33,6 +33,19 @@ CREATE TABLE wikipages (
     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 (
@@ -64,6 +77,14 @@ CREATE TABLE invalid_page_titles (
     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 (