# create score table for grade-keeping project

DROP TABLE IF EXISTS score;
CREATE TABLE score
(
	student_id INT UNSIGNED NOT NULL,
	event_id INT UNSIGNED NOT NULL,
	score INT NOT NULL,
	PRIMARY KEY (event_id, student_id)	/* don't want duplicates on these! */
);