· 8 years ago · Apr 07, 2018, 05:50 PM
1CREATE TABLE IF NOT EXISTS user_course (
2 userid INT NOT NULL,
3 courseid INT NOT NULL,
4 PRIMARY KEY (userid, courseid),
5 FOREIGN KEY (userid) REFERENCES users(id),
6 FOREIGN KEY (courseid) REFERENCES courses(id)
7);