From e121bbebe3ccd990b66a7b04289adf481a4aa2af Mon Sep 17 00:00:00 2001 From: Jesse Morgan 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') 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