summaryrefslogtreecommitdiff
path: root/schema/schema.sql
AgeCommit message (Collapse)AuthorFilesLines
14 hourschore: sync schema.sql with live databasedev1-1/+9
- 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)
32 hoursfeat: fetch Wikipedia article titles via Wikidata SPARQLdev1-1/+0
- 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)
3 daysfeat: adapt genre code for n:m relation via imdb_genredev1-6/+44
- 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
3 daysInitial commitdev1-0/+113