# create absence table for grade-keeping project

DROP TABLE IF EXISTS absence;
CREATE TABLE absence
(
	student_id INT UNSIGNED NOT NULL,
	date DATE NOT NULL,
	PRIMARY KEY (student_id, date)
);