-- Ajouter une colonne poster_url à la table Movie
ALTER TABLE Movie ADD COLUMN poster_url VARCHAR(500) DEFAULT NULL;

-- Mettre à jour les films avec des URLs d'affiches publiques
UPDATE Movie SET poster_url = 'https://image.tmdb.org/t/p/w300/rAiY959f3Z1g1oNnk8MsAeb5Epo.jpg' WHERE id = 7;  -- Interstellar
UPDATE Movie SET poster_url = 'https://image.tmdb.org/t/p/w300/8kV8KKJZ3Yow0rEHn7gKncmO6An.jpg' WHERE id = 12; -- La Liste de Schindler
UPDATE Movie SET poster_url = 'https://image.tmdb.org/t/p/w300/qblIWe5cjL1rIwv2MtD7K3V8bEv.jpg' WHERE id = 17; -- Your Name
UPDATE Movie SET poster_url = 'https://image.tmdb.org/t/p/w300/bX8qWy3gHGdjB3u9yQ50Uw6aFz5.jpg' WHERE id = 27; -- Le Bon, la Brute et le Truand
