-- Exemples (optionnel). Importez après schema.sql.
-- Cette version utilise les IDs (class_id, subject_id).

INSERT INTO questions (class_id, subject_id, question, option_a, option_b, option_c, option_d, correct_option, explanation, created_at)
VALUES
((SELECT id FROM classes WHERE name='6ème' LIMIT 1),(SELECT id FROM subjects WHERE name='SVT' LIMIT 1),
  "Quel organe permet principalement la respiration ?","Le cœur","Les poumons","Le foie","Les reins",'B',"Les poumons permettent les échanges gazeux.",NOW()),

((SELECT id FROM classes WHERE name='6ème' LIMIT 1),(SELECT id FROM subjects WHERE name='Géographie' LIMIT 1),
  "Quel est le plus grand océan ?","Atlantique","Indien","Arctique","Pacifique",'D',"Le Pacifique est le plus grand.",NOW()),

((SELECT id FROM classes WHERE name='CM2' LIMIT 1),(SELECT id FROM subjects WHERE name='Français' LIMIT 1),
  "Dans la phrase « Il mange », quel est le verbe ?","Il","mange","la phrase","aucun",'B',"Le verbe exprime l'action: « mange ».",NOW());
