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.

1 files changed, 3 insertions, 1 deletions

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)
 );