diff options
Diffstat (limited to 'sources/wiki/pre.sql')
-rw-r--r-- | sources/wiki/pre.sql | 21 |
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 ( |