-- # Teacher
INSERT INTO teacher (name) VALUES("beatrice"), ("thomas"), ("dominique"), ("virginie");

-- #Grade
INSERT INTO grade (name) VALUES("cp"), ("ce1"), ("ce2"), ("cm1"), ("cm2");

-- # Teacher - Grade
INSERT INTO teacher_has_grade(teacher_id, grade_id) VALUES
    (1,1)
    (2,2)
    (3,3)
    (3,5)
    (4,4);

-- # Pupil
INSERT INTO pupil (name, grade_id) VALUES
    ("david", 1),
    ("stephane", 1),
    ("kevin", 1),
    ("guillaume", 1),
    ("aurel", 1),
    ("antoine", 1),

    ("alexandre", 2),
    ("benoit", 2),
    ("ludivine", 2),
    ("sophie", 2),
    ("maxime", 2),
    ("camille", 2),

    ("bernard", 3),
    ("leonard", 3),
    ("pascal", 3),
    ("germaine", 3),
    ("lucette", 3),
    ("lucien", 3),

    ("adeline", 4),
    ("olivier", 4),
    ("christine", 4),

    ("marjorie", 5),
    ("florence", 5),
    ("leopold", 5);

-- Game
INSERT INTO game(name) VALUES("animal"), ("capitale"), ("fille-garçon");

-- Game content
INSERT INTO game_content (question, answer, grade_id, game_id) VALUES
    -- animal
    ("hennissement", "cheval", 4, 1),
    ("barrissement", "elephant", 4, 1),
    ("aboiement", "chien", 4, 1),
    ("miaulement", "chat", 4, 1),
    ("meuglement", "vache", 4, 1),
    -- capitale
    ("france", "paris", 5, 2),
    ("angleterre", "londres", 5, 2),
    ("espagne", "madrid", 5, 2),
    ("replublique tchèque", "prague", 5, 2),
    ("suisse", "genève", 5, 2),
    ("australie", "canberra", 5, 2),
    ("mali", "bamako", 5, 2),
    -- fille-garçon
    ("amelie", "fille", 5, 3),
    ("corine", "fille", 5, 3),
    ("marguerite", "fille", 5, 3),
    ("mathieu", "garçon", 5, 3);