QJyUbzDK

1
2# LE SQL WOOOOOOOOHOOOOOOOO
3
4DROP TABLE IF EXISTS `CHAPTER`;
5CREATE TABLE `CHAPTER` (
6  `id` int(11) NOT NULL AUTO_INCREMENT,
7  `title` varchar(255) NOT NULL,
8  `order` int(11) NOT NULL,
9  PRIMARY KEY (`id`)
10)CHARACTER SET utf8;
11
12DROP TABLE IF EXISTS `COURSE`;
13CREATE TABLE `COURSE` (
14  `id` int(11) NOT NULL AUTO_INCREMENT,
15  `idChap` int(11) NOT NULL,
16  `title` varchar(255) NOT NULL,
17  `content` varchar(255) NOT NULL,
18  `order` int(11) DEFAULT 1,
19  PRIMARY KEY (`id`),
20  CONSTRAINT `courseFk` FOREIGN KEY (`idChap`) REFERENCES `CHAPTER` (`id`) ON DELETE CASCADE
21)CHARACTER SET utf8;
22
23DROP TABLE IF EXISTS `EXERCICE`;
24CREATE TABLE `EXERCICE` (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `idChap` int(11) NOT NULL,
27  `title` varchar(255) NOT NULL,
28  `instruction` text DEFAULT NULL,
29  `correction` text DEFAULT NULL,
30  `dependency` text DEFAULT NULL,
31  `main` text DEFAULT NULL,
32  `order` int(11) DEFAULT 1,
33  PRIMARY KEY (`id`),
34  CONSTRAINT `exerciceFk` FOREIGN KEY (`idChap`) REFERENCES `CHAPTER` (`id`) ON DELETE CASCADE
35)CHARACTER SET utf8;
36
37DROP TABLE IF EXISTS `TESTSET`;
38CREATE TABLE `TESTSET` (
39  `id` int(11) NOT NULL AUTO_INCREMENT,
40  `idExercice` int(11) NOT NULL,
41  `input` varchar(255) DEFAULT NULL,
42  `output` varchar(255) DEFAULT NULL,
43  PRIMARY KEY (`id`),
44  CONSTRAINT `testSetFk` FOREIGN KEY (`idExercice`) REFERENCES `EXERCICE` (`id`) ON DELETE CASCADE
45)CHARACTER SET utf8;
46
47DROP TABLE IF EXISTS `USER`;
48CREATE TABLE `USER` (
49  `id` int(11) NOT NULL,
50  `name` varchar(255) NOT NULL,
51  `type` int(11) DEFAULT '1',
52  `promo` int(11) DEFAULT NULL,
53  PRIMARY KEY (`id`)
54)CHARACTER SET utf8;
55
56DROP TABLE IF EXISTS `DO`;
57CREATE TABLE `DO` (
58  `idUser` int(11) NOT NULL,
59  `idExercice` int(11) NOT NULL,
60  `startTime` datetime DEFAULT NULL,
61  `completionTime` datetime DEFAULT NULL,
62  `try` int(11) DEFAULT '0',
63  `done` int(1) DEFAULT '0',
64  `code` text DEFAULT NULL,
65  PRIMARY KEY (`idUser`, `idExercice`),
66  CONSTRAINT `doFk1` FOREIGN KEY (`idUser`) REFERENCES `USER` (`id`) ON DELETE CASCADE,
67  CONSTRAINT `doFk2` FOREIGN KEY (`idExercice`) REFERENCES `EXERCICE` (`id`) ON DELETE CASCADE
68)CHARACTER SET utf8;