Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

177 lines (152 sloc) 6.601 kB
#
# Table structure for table workshop
#
BEGIN;
CREATE TABLE prefix_workshop (
id SERIAL PRIMARY KEY,
course INT8 NOT NULL default '0',
name varchar(255) NOT NULL default '',
description text NOT NULL default '',
wtype INT NOT NULL DEFAULT '0',
nelements INT NOT NULL default '10',
nattachments INT NOT NULL DEFAULT '0',
phase INT2 NOT NULL default '0',
format INT2 NOT NULL default '0',
gradingstrategy INT2 NOT NULL default '1',
resubmit INT2 NOT NULL default '0',
agreeassessments INT2 NOT NULL default '0',
hidegrades INT2 NOT NULL default '0',
anonymous INT2 NOT NULL default '0',
includeself INT2 NOT NULL default '0',
maxbytes INT8 NOT NULL default '100000',
submissionstart INT8 NOT NULL default '0',
assessmentstart INT8 NOT NULL default '0',
submissionend INT8 NOT NULL default '0',
assessmentend INT8 NOT NULL default '0',
releasegrades INT8 NOT NULL default'0',
grade INT8 NOT NULL default '0',
gradinggrade INT4 NOT NULL default '0',
ntassessments INT NOT NULL default '0',
assessmentcomps int4 NOT NULL default '2',
nsassessments INT NOT NULL default '0',
overallocation INT NOT NULL default '0',
timemodified INT8 NOT NULL default '0',
teacherweight INT NOT NULL default '1',
showleaguetable INT4 NOT NULL default '0',
usepassword INT NOT NULL DEFAULT '0',
password VARCHAR(32) NOT NULL DEFAULT ''
);
CREATE INDEX prefix_workshop_course_idx ON prefix_workshop (course);
# --------------------------------------------------------
#
# Table structure for table workshop_submissions
#
CREATE TABLE prefix_workshop_submissions (
id SERIAL PRIMARY KEY,
workshopid INT8 NOT NULL default '0',
userid INT8 NOT NULL default '0',
title varchar(100) NOT NULL default '',
timecreated INT8 NOT NULL default '0',
mailed INT2 NOT NULL default '0',
description TEXT,
gradinggrade INT NOT NULL default '0',
late INT NOT NULL DEFAULT '0',
inalgrade INT NOT NULL default '0',
nassessments INT8 NOT NULL default 0
);
CREATE INDEX prefix_workshop_submissions_title_idx on prefix_workshop_submissions (title);
CREATE INDEX prefix_workshop_submissions_userid_idx ON prefix_workshop_submissions (userid);
CREATE INDEX prefix_workshop_submissions_workshopid_idx ON prefix_workshop_submissions (workshopid);
CREATE INDEX prefix_workshop_submissions_mailed_idx ON prefix_workshop_submissions (mailed);
# --------------------------------------------------------
#
# Table structure for table workshop_assessments
#
CREATE TABLE prefix_workshop_assessments (
id SERIAL PRIMARY KEY,
workshopid INT8 NOT NULL default '0',
submissionid INT8 NOT NULL default '0',
userid INT8 NOT NULL default '0',
timecreated INT8 NOT NULL default '0',
timegraded INT8 NOT NULL default '0',
timeagreed INT8 NOT NULL default '0',
grade float NOT NULL default '0',
gradinggrade INT NOT NULL default '0',
mailed INT2 NOT NULL default '0',
resubmission INT2 NOT NULL default '0',
donotuse int4 NOT NULL default '0',
generalcomment text NOT NULL default '',
teachercomment text NOT NULL default ''
);
CREATE INDEX prefix_workshop_assessments_workshopid_idx ON prefix_workshop_assessments (workshopid);
CREATE INDEX prefix_workshop_assessments_submissionid_idx ON prefix_workshop_assessments (submissionid);
CREATE INDEX prefix_workshop_assessments_userid_idx ON prefix_workshop_assessments (userid);
CREATE INDEX prefix_workshop_assessments_mailed_idx ON prefix_workshop_assessments (mailed);
# --------------------------------------------------------
#
# Table structure for table workshop_elements
#
CREATE TABLE prefix_workshop_elements (
id SERIAL PRIMARY KEY,
workshopid INT8 NOT NULL default '0',
elementno INT NOT NULL default '0',
description text NOT NULL default '',
scale INT NOT NULL default '0',
maxscore INT NOT NULL default '1',
weight INT4 NOT NULL default '11',
stddev FLOAT NOT NULL default '0',
totalrassesments INT8 NOT NULL DEFAULT '0'
);
CREATE INDEX prefix_workshop_elements_workshopid_idx ON prefix_workshop_elements (workshopid);
# --------------------------------------------------------
CREATE TABLE prefix_workshop_rubrics (
id SERIAL PRIMARY KEY,
workshopid int8 NOT NULL default '0',
elementno int8 NOT NULL default '0',
rubricno int4 NOT NULL default '0',
description text NOT NULL
) ;
# --------------------------------------------------------
#
# Table structure for table workshop_grades
#
CREATE TABLE prefix_workshop_grades (
id SERIAL PRIMARY KEY,
workshopid INT8 NOT NULL default '0',
assessmentid INT8 NOT NULL default '0',
elementno INT8 NOT NULL default '0',
feedback text NOT NULL default '',
grade INT NOT NULL default '0'
);
CREATE INDEX prefix_workshop_grades_workshopid_idx ON prefix_workshop_grades (workshopid);
CREATE INDEX prefix_workshop_grades_assessmentid_idx ON prefix_workshop_grades (assessmentid);
# --------------------------------------------------------
CREATE TABLE prefix_workshop_comments (
id SERIAL PRIMARY KEY,
workshopid int8 NOT NULL default '0',
assessmentid int8 NOT NULL default '0',
userid int8 NOT NULL default '0',
timecreated int8 NOT NULL default '0',
mailed int2 NOT NULL default '0',
comments text NOT NULL default ''
);
CREATE INDEX prefix_workshop_comments_workshopid_idx ON prefix_workshop_comments (workshopid);
CREATE INDEX prefix_workshop_comments_assessmentid_idx ON prefix_workshop_comments (assessmentid);
CREATE INDEX prefix_workshop_comments_userid_idx ON prefix_workshop_comments (userid);
CREATE INDEX prefix_workshop_comments_mailed_idx ON prefix_workshop_comments (mailed);
#---------------------------------------------------------
CREATE TABLE prefix_workshop_stockcomments (
id SERIAL PRIMARY KEY,
workshopid INT8 NOT NULL default '0',
elementno INT8 NOT NULL default '0',
comments text NOT NULL
);
INSERT INTO prefix_log_display VALUES ('workshop', 'assessments', 'workshop', 'name');
INSERT INTO prefix_log_display VALUES ('workshop', 'close', 'workshop', 'name');
INSERT INTO prefix_log_display VALUES ('workshop', 'display', 'workshop', 'name');
INSERT INTO prefix_log_display VALUES ('workshop', 'resubmit', 'workshop', 'name');
INSERT INTO prefix_log_display VALUES ('workshop', 'set up', 'workshop', 'name');
INSERT INTO prefix_log_display VALUES ('workshop', 'submissions', 'workshop', 'name');
INSERT INTO prefix_log_display VALUES ('workshop', 'view', 'workshop', 'name');
INSERT INTO prefix_log_display VALUES ('workshop', 'update', 'workshop', 'name');
COMMIT;
Jump to Line
Something went wrong with that request. Please try again.