From fa742660190a7d3b7b6f068565ce543d413edbab Mon Sep 17 00:00:00 2001
From: dev
Date: Thu, 25 Jun 2026 20:07:08 +0200
Subject: 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)
---
 schema/schema.sql | 1 -
 1 file changed, 1 deletion(-)

(limited to 'schema/schema.sql')

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;
 
 
-- 
cgit v1.2.3

