summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authordev2026-06-25 20:07:08 +0200
committerdev2026-06-25 20:07:08 +0200
commitfa742660190a7d3b7b6f068565ce543d413edbab (patch)
tree3515262a4bd47aac3e998ecf134451257b0181a0 /schema
parentd41b60d08fdd5a6589cdb4e33ac1931fa16aef4c (diff)
downloadhnimdbbot-fa742660190a7d3b7b6f068565ce543d413edbab.tar.gz
feat: fetch Wikipedia article titles via Wikidata SPARQL
- Query Wikidata SPARQL in batches of 30 for entries missing wiki_article - Store wiki_article title in imdb table - Respect rate limits with configurable delay and retry on 5xx/429 - Skip entries that have no Wikipedia article - Removed unique constraint on wiki_article (multiple entries can share one)
Diffstat (limited to 'schema')
-rw-r--r--schema/schema.sql1
1 files changed, 0 insertions, 1 deletions
diff --git a/schema/schema.sql b/schema/schema.sql
index 9b1e5ab..f957079 100644
--- a/schema/schema.sql
+++ b/schema/schema.sql
@@ -34,7 +34,6 @@ CREATE TABLE `imdb` (
`num_votes` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `imdb_id` (`imdb_id`),
- UNIQUE KEY `wiki_article` (`wiki_article`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;