1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
|
#
# 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',
finalgrade 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',
totalassessments 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 (module, action, mtable, field) VALUES ('workshop', 'assessments', 'workshop', 'name');
INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'close', 'workshop', 'name');
INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'display', 'workshop', 'name');
INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'resubmit', 'workshop', 'name');
INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'set up', 'workshop', 'name');
INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'submissions', 'workshop', 'name');
INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'view', 'workshop', 'name');
INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'update', 'workshop', 'name');
COMMIT;
|
