· 8 years ago · Apr 27, 2018, 02:56 PM
1CREATE TABLE IF NOT EXISTS `agenda` (
2 `idagenda` INT NOT NULL ,
3 `date` DATE NULL ,
4 `heure_debut` INT NULL ,
5 `minute_debut` INT NULL ,
6 `heure_fin` INT NULL ,
7 `minute_fin` INT NULL ,
8 `client_id` INT NULL ,
9 `formateur_id` INT NULL ,
10 `commentaire` VARCHAR(500) NULL ,
11 PRIMARY KEY (`idagenda`) )
12ENGINE = InnoDB
13
14INSERT INTO agenda (idagenda,date,heure_debut,minute_debut,heure_fin,minute_fin,client_id,formateur_id,commentaire)
15VALUES
16 (1,'2011-12-12',8,00,10,00,6,1,"coucou"),
17 (2,'2011-12-13',9,30,11,45,5,2,"coucou2");