summaryrefslogtreecommitdiff
path: root/schema/schema.sql
AgeCommit message (Collapse)AuthorFilesLines
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