CREATE TABLE IF NOT EXISTS `CourseLesson` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`CourId` INT  NOT NULL,
`Name` TEXT  NOT NULL,
`Code` TEXT  NOT NULL,
`Description` TEXT  NOT NULL,
`Content` TEXT  NOT NULL,
PRIMARY KEY (`Id`),
CONSTRAINT `CourseCour_CourseLesson` FOREIGN KEY (`CourId`) REFERENCES `CourseCour`(`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 