CREATE TABLE IF NOT EXISTS `CourseSession` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`DateStart` DATE  NOT NULL,
`HourStart` TEXT  NOT NULL,
`HourEnd` TEXT  NOT NULL,
`Price` INT  NOT NULL,
`NumberPlaces` INT  NOT NULL,
`CourId` INT  NOT NULL,
`Hebdomadaire` INT  NOT NULL,
PRIMARY KEY (`Id`),
CONSTRAINT `CourseCour_CourseSession` FOREIGN KEY (`CourId`) REFERENCES `CourseCour`(`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 