DELETE FROM salle;

DELETE FROM agent;

DELETE FROM niveau;

DELETE FROM batiment;

INSERT INTO batiment
    VALUES ('F', 1986, 'Nouville'), ('Sigma', 2018, 'Nouville, plus loin'), ('Principal', 2018, 'Baco');

INSERT INTO niveau
    VALUES ('F', 0, 100, TRUE), ('F', 1, 60, FALSE);

INSERT INTO niveau
    VALUES ('Sigma', 1, 2000, TRUE), ('Sigma', 2, 3000, TRUE);

INSERT INTO agent
    VALUES (1001, 'DE SERVICE', 'Agent 1'), (1002, 'DE SERVICE', 'Agent 2'), (1003, 'DE SERVICE', 'Agent 3');

INSERT INTO salle
    VALUES ('F', 0, 1, 40, 'TD', NULL), ('F', 0, 2, 50, 'TP', 1001), ('F', 0, 3, 50, 'TP', 1001), ('F', 1, 1, 40, 'Bureau', 1002), ('Sigma', 1, 1, 200, 'Fablab', 1002);

