CREATE TABLE Users (
    user_id INT AUTO_INCREMENT NOT NULL,
    nom VARCHAR(100) NOT NULL,
    user_role VARCHAR(20) NOT NULL,
    PRIMARY KEY (user_id)
    CHECK (user_role IN ("DEMANDEUR", "BENEVOLE", "VALIDATEUR")) /*pour eviter que le role soit n'importe quoi*/
);

INSERT INTO user (nom, user_role) VALUES ("Tom Cruise", "DEMANDEUR");
INSERT INTO user (nom, user_role) VALUES ("Omar Sy", "DEMANDEUR");
INSERT INTO user (nom, user_role) VALUES ("Emma Stone", "DEMANDEUR");
INSERT INTO user (nom, user_role) VALUES ("Margot Robbie", "BENEVOLE");
INSERT INTO user (nom, user_role) VALUES ("Vincent Cassel", "BENEVOLE");
INSERT INTO user (nom, user_role) VALUES ("Michael Jackson", "BENEVOLE");
INSERT INTO user (nom, user_role) VALUES ("Staff_Purpan", "VALIDATEUR");