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