46usjNfs

1DROP TABLE IF EXISTS `topic`;
2
3CREATE TABLE `topic` (
4  `id` int(11) NOT NULL AUTO_INCREMENT,
5  `name` varchar(45) DEFAULT NULL,
6  `description` varchar(128) DEFAULT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
9
10
11DROP TABLE IF EXISTS `course`;
12
13CREATE TABLE `course` (
14  `id` int(11) NOT NULL AUTO_INCREMENT,
15  `name` varchar(128) DEFAULT NULL,
16  `description` varchar(128) DEFAULT NULL,
17  `topic_id` int(11) DEFAULT NULL,
18  PRIMARY KEY (`id`),
19  KEY `FK_DETAIL_idx` (`topic_id`),
20  CONSTRAINT `FK_DETAIL` FOREIGN KEY (`topic_id`) 
21  REFERENCES `topic` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
22) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
23
24DROP TABLE IF EXISTS `course`;
25
26CREATE TABLE `lesson` (
27  `id` int(11) NOT NULL AUTO_INCREMENT,
28  `title` varchar(128) DEFAULT NULL,
29  `course_id` int(11) DEFAULT NULL,
30  
31  PRIMARY KEY (`id`),
32  
33  UNIQUE KEY `TITLE_UNIQUE` (`title`),
34  
35  KEY `FK_COURSE_idx` (`course_id`),
36  
37  CONSTRAINT `FK_COURSE` 
38  FOREIGN KEY (`course_id`) 
39  REFERENCES `course` (`id`) 
40  
41  ON DELETE NO ACTION ON UPDATE NO ACTION
42) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
43
44
45SET FOREIGN_KEY_CHECKS = 1;