From fa9a4f7eb160fc435dc34c493e6822d2fbb7e484 Mon Sep 17 00:00:00 2001 From: Jesse Morgan Date: Thu, 6 Oct 2011 14:55:18 -0700 Subject: Completed schedule iterator and almost completed exception iterator. Still need to add the 'Add Exception' page and make use of the schedule in the moderator email code. --- design/database.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'design') diff --git a/design/database.sql b/design/database.sql index b908bc0..60b7006 100644 --- a/design/database.sql +++ b/design/database.sql @@ -105,8 +105,10 @@ CREATE TABLE moderator_exceptions ( year INTEGER UNSIGNED NOT NULL, week TINYINT UNSIGNED NOT NULL, user_id INTEGER UNSIGNED NOT NULL, + substitute INTEGER UNSIGNED NOT NULL, - PRIMARY KEY(year, week) + + PRIMARY KEY(year, week, user_id) ); -- cgit v1.2.3