Working on the moderation schedule iterator

1 files changed, 16 insertions, 0 deletions

diff --git a/design/database.sql b/design/database.sql
index 2dbd90c..b908bc0 100644
--- a/design/database.sql
+++ b/design/database.sql
@@ -94,6 +94,22 @@ CREATE TABLE page (
     UNIQUE  KEY(url)
 );
 
+CREATE TABLE moderator_schedule (
+    position    TINYINT UNSIGNED NOT NULL,
+    user_id     INTEGER UNSIGNED NOT NULL,
+
+    PRIMARY KEY(position, user_id)
+);
+
+CREATE TABLE moderator_exceptions ( 
+    year        INTEGER UNSIGNED NOT NULL,
+    week        TINYINT UNSIGNED NOT NULL,
+    user_id     INTEGER UNSIGNED NOT NULL,
+
+    PRIMARY KEY(year, week)
+);
+
+
 -- The following creates some sample data
 INSERT INTO `category` (`shortname`, `name`, `description`, `options`)
 VALUES