From e121bbebe3ccd990b66a7b04289adf481a4aa2af Mon Sep 17 00:00:00 2001
From: Jesse Morgan <jesse@jesterpm.net>
Date: Tue, 30 Aug 2011 12:29:19 -0700
Subject: Working on the moderation schedule iterator

---
 design/database.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'design/database.sql')

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
-- 
cgit v1.2.3

