Les ny

CREATE TABLE REUNION (
  id INT(3) NOT NULL,
  libelleReunion VARCHAR(250) NOT NULL,
  dateReunion DATE NOT NULL,
  heureReunion TIME NOT NULL,
  dureeReunion TIME NOT NULL,
  numeroSalle VARCHAR(4) NOT NULL,
  CONSTRAINT pk_Reunion PRIMARY KEY (id)
)
ENGINE=InnoDB;

CREATE TABLE FONCTION (
  id VARCHAR(1) NOT NULL,
  nomFonction VARCHAR(50) NOT NULL,
  CONSTRAINT pk_idFonction PRIMARY KEY (id)
)
ENGINE=InnoDB;

CREATE TABLE PERSONNE (
  id INT(2) NOT NULL,
  nom VARCHAR(50) NOT NULL,
  prenom VARCHAR(50) NOT NULL,
  idFonction VARCHAR(1) NOT NULL,
  CONSTRAINT pk_idPersonne PRIMARY KEY (id),
  CONSTRAINT fk_idFonction FOREIGN KEY (idFonction) REFERENCES FONCTION(id)
)
ENGINE=InnoDB;

CREATE TABLE PARTICIPER (
  idReunion INT(3) NOT NULL,
  idPersonne INT(2) NOT NULL,
  CONSTRAINT pk_Participer PRIMARY KEY (idReunion,idPersonne),
  CONSTRAINT fk_idReunion FOREIGN KEY (idReunion) REFERENCES REUNION(id),
  CONSTRAINT fk_idPersonne FOREIGN KEY (idPersonne) REFERENCES PERSONNE(id)
)
ENGINE=InnoDB;