hnimdbbot/schema, branch main Pure Cinema! chore: sync schema.sql with live database 2026-06-26T11:54:23+00:00 dev 2026-06-26T11:54:23+00:00 13992fedaa0beaf93f6214993c95e685d249638f - Add missing columns to imdb: has_no_wiki_article, description, license, license_url, num_accolades, wiki_status_code, has_people - Fix links table: update to match actual DDL with story_id FK - Fix orphaned links_imdb definition (was missing CREATE TABLE header) 
- Add missing columns to imdb: has_no_wiki_article, description,
  license, license_url, num_accolades, wiki_status_code, has_people
- Fix links table: update to match actual DDL with story_id FK
- Fix orphaned links_imdb definition (was missing CREATE TABLE header)
feat: fetch Wikipedia article titles via Wikidata SPARQL 2026-06-25T18:07:08+00:00 dev 2026-06-25T18:07:08+00:00 fa742660190a7d3b7b6f068565ce543d413edbab - 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) 
- 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)
feat: adapt genre code for n:m relation via imdb_genre 2026-06-24T02:40:22+00:00 dev 2026-06-24T02:40:22+00:00 1d20ca594c4246a3fcd63c52911b6d56c0aa503e - genre table: (id, name) with unique name constraint - imdb_genre table: (id, imdb_id, genre_id) junction table - Upsert genres via INSERT ... ON DUPLICATE KEY UPDATE - Link via imdb_genre using LAST_INSERT_ID - Check missing genres via LEFT JOIN imdb_genre 
- genre table: (id, name) with unique name constraint
- imdb_genre table: (id, imdb_id, genre_id) junction table
- Upsert genres via INSERT ... ON DUPLICATE KEY UPDATE
- Link via imdb_genre using LAST_INSERT_ID
- Check missing genres via LEFT JOIN imdb_genre
Initial commit 2026-06-23T23:41:31+00:00 dev 2026-06-23T23:41:31+00:00 2e3e5b3efc6a8d9471a73c5553f88fa94e28bd3a