Student grading

db.ddl

@@ -22,7 +22,8 @@ CREATE TABLE owl_courses (
 	cid		serial		PRIMARY KEY,
 	ident		varchar(255)	UNIQUE NOT NULL,
 	name		varchar(255)	NOT NULL,
-	enroll_token	varchar(255)	UNIQUE NOT NULL
+	enroll_token	varchar(255)	UNIQUE NOT NULL,
+	student_grading	boolean		NOT NULL DEFAULT FALSE
 );
 
 CREATE TABLE owl_enroll (
@@ -50,6 +51,12 @@ CREATE TABLE owl_topics (
 	UNIQUE(cid, ident)
 );
 
+CREATE TABLE owl_student_graders (
+	tid		int		NOT NULL REFERENCES owl_topics(tid) ON DELETE CASCADE,
+	uid		int		NOT NULL REFERENCES owl_users(uid) ON DELETE CASCADE,
+	UNIQUE(tid, uid)
+);
+
 CREATE TABLE owl_posts (
 	pid		serial		PRIMARY KEY,
 	tid		int		NOT NULL REFERENCES owl_topics(tid) ON DELETE CASCADE,