création de 3 tables MySQL

par **Fab** Mar 9 Sep - 7:53

Code:: CREATE TABLE IF NOT EXISTS students ( id_student INT(10) NOT NULL AUTO_INCREMENT, natnumber CHAR, nameStudent VARCHAR (30), mail VARCHAR (80), PRIMARY KEY (id_student) )ENGINE=INNODB; CREATE TABLE IF NOT EXISTS courses ( id_course INT(10) NOT NULL AUTO_INCREMENT, refCourse INT(10), label CHAR, nb_hours INT(3) PRIMARY KEY (id_course) )ENGINE=INNODB; CREATE TABLE IF NOT EXISTS stu_courses ( id_student INT(10) NOT NULL, id_course INT (10) NOT NULL, dayOfWeek INT (1), PRIMARY KEY (id_student,id_course), FOREIGN KEY (id_student) REFERENCES students(id_student), FOREIGN KEY (id_course) REFERENCES courses(id_course) )ENGINE=INNODB;