JMF8YEP2

1CREATE TABLE IF NOT EXISTS entries(
2entry_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
3exam_date DATETIME NOT NULL,
4student_id INT UNSIGNED NOT NULL,
5subject_id INT UNSIGNED NOT NULL,
6PRIMARY KEY (entry_id),
7FOREIGN KEY (student_id) REFERENCES exams.students(student_id),
8FOREIGN KEY (subject_id) REFERENCES exams.subjects(subject_id));