From 149dc178c491d8e447a05ff3705fdc6ceddf129e Mon Sep 17 00:00:00 2001 From: Terry Truong Date: Sun, 2 Oct 2022 14:43:02 +1100 Subject: Add title column to img_data.db --- backend/hist_data/enwiki/README.md | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'backend/hist_data/enwiki/README.md') diff --git a/backend/hist_data/enwiki/README.md b/backend/hist_data/enwiki/README.md index 95795f3..29fc2ff 100644 --- a/backend/hist_data/enwiki/README.md +++ b/backend/hist_data/enwiki/README.md @@ -40,7 +40,7 @@ This directory holds files obtained/derived from [English Wikipedia](https://en. Used to hold metadata about infobox images for a set of page IDs. Generated using `get_enwiki_img_data.py` and `download_img_license_info.py`.
Tables:
- - `page_imgs`: `page_id INT PRIMAY KEY, img_name TEXT`
+ - `page_imgs`: `page_id INT PRIMARY KEY, title TEXT UNIQUE, img_name TEXT`
`img_name` may be NULL, which means 'none found', and is used to avoid re-processing page IDs. - `imgs`: `id INT PRIMARY KEY, name TEXT UNIQUE, license TEXT, artist TEXT, credit TEXT, restrictions TEXT, url TEXT` -- cgit v1.2.3