mirrored from git://git.moodle.org/moodle.git
-
Notifications
You must be signed in to change notification settings - Fork 6.6k
/
postgres7.sql
494 lines (388 loc) · 14.6 KB
/
postgres7.sql
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
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
# phpMyAdmin MySQL-Dump
# version 2.3.2-dev
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Oct 16, 2002 at 01:12 AM
# Server version: 3.23.49
# PHP Version: 4.2.3
# Database : moodle
# --------------------------------------------------------
#
# Table structure for table prefix_quiz
#
CREATE TABLE prefix_quiz (
id SERIAL PRIMARY KEY,
course integer NOT NULL default '0',
name varchar(255) NOT NULL default '',
intro text NOT NULL default '',
timeopen integer NOT NULL default '0',
timeclose integer NOT NULL default '0',
optionflags integer NOT NULL default '0',
penaltyscheme integer NOT NULL default '0',
attempts integer NOT NULL default '0',
attemptonlast integer NOT NULL default '0',
grademethod integer NOT NULL default '1',
decimalpoints integer NOT NULL default '2',
review integer NOT NULL default '0',
questionsperpage integer NOT NULL default '0',
shufflequestions integer NOT NULL default '0',
shuffleanswers integer NOT NULL default '0',
questions text NOT NULL default '',
sumgrades integer NOT NULL default '0',
grade integer NOT NULL default '0',
timecreated integer NOT NULL default '0',
timemodified integer NOT NULL default '0',
timelimit integer NOT NULL default '0',
password varchar(255) NOT NULL default '',
subnet varchar(255) NOT NULL default '',
popup integer NOT NULL default '0',
delay1 integer NOT NULL default '0',
delay2 integer NOT NULL default '0'
);
CREATE INDEX prefix_quiz_course_idx ON prefix_quiz (course);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_answers
#
CREATE TABLE prefix_quiz_answers (
id SERIAL PRIMARY KEY,
question integer NOT NULL default '0',
answer text NOT NULL default '',
fraction varchar(10) NOT NULL default '0.0',
feedback text NOT NULL default ''
);
CREATE INDEX prefix_quiz_answers_question_idx ON prefix_quiz_answers (question);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_attemptonlast_datasets
#
CREATE TABLE prefix_quiz_attemptonlast_datasets (
id SERIAL8 PRIMARY KEY,
category INT8 NOT NULL default '0',
userid INT8 NOT NULL default '0',
datasetnumber INT8 NOT NULL default '0',
CONSTRAINT prefix_quiz_attemptonlast_datasets_category_userid UNIQUE (category,userid)
);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_attempts
#
CREATE TABLE prefix_quiz_attempts (
id SERIAL PRIMARY KEY,
uniqueid integer NOT NULL default '0',
quiz integer NOT NULL default '0',
userid integer NOT NULL default '0',
attempt integer NOT NULL default '0',
sumgrades varchar(10) NOT NULL default '0.0',
timestart integer NOT NULL default '0',
timefinish integer NOT NULL default '0',
timemodified integer NOT NULL default '0',
layout text NOT NULL default '',
preview integer NOT NULL default '0'
);
CREATE INDEX prefix_quiz_attempts_quiz_idx ON prefix_quiz_attempts (quiz);
CREATE INDEX prefix_quiz_attempts_userid_idx ON prefix_quiz_attempts (userid);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_calculated
#
CREATE TABLE prefix_quiz_calculated (
id SERIAL8 PRIMARY KEY,
question INT8 NOT NULL default '0',
answer INT8 NOT NULL default '0',
tolerance varchar(20) NOT NULL default '0.0',
tolerancetype INT8 NOT NULL default '1',
correctanswerlength INT8 NOT NULL default '2',
correctanswerformat INT8 NOT NULL default '2'
);
CREATE INDEX prefix_quiz_calculated_question_idx ON prefix_quiz_calculated (question);
CREATE INDEX prefix_quiz_calculated_answer_idx ON prefix_quiz_calculated (answer);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_categories
#
CREATE TABLE prefix_quiz_categories (
id SERIAL PRIMARY KEY,
course integer NOT NULL default '0',
name varchar(255) NOT NULL default '',
info text NOT NULL default '',
publish integer NOT NULL default '0',
stamp varchar(255) NOT NULL default '',
parent integer NOT NULL default '0',
sortorder integer NOT NULL default '999'
);
CREATE INDEX prefix_quiz_categories_course_idx ON prefix_quiz_categories (course);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_dataset_definitions
#
CREATE TABLE prefix_quiz_dataset_definitions (
id SERIAL8 PRIMARY KEY,
category INT8 NOT NULL default '0',
name varchar(255) NOT NULL default '',
type INT8 NOT NULL default '0',
options varchar(255) NOT NULL default '',
itemcount INT8 NOT NULL default '0'
);
CREATE INDEX prefix_quiz_dataset_definitions_category_idx ON prefix_quiz_dataset_definitions (category);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_dataset_items
#
CREATE TABLE prefix_quiz_dataset_items (
id SERIAL8 PRIMARY KEY,
definition INT8 NOT NULL default '0',
number INT8 NOT NULL default '0',
value varchar(255) NOT NULL default ''
);
CREATE INDEX prefix_quiz_dataset_items_definition_idx ON prefix_quiz_dataset_items (definition);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_grades
#
CREATE TABLE prefix_quiz_grades (
id SERIAL PRIMARY KEY,
quiz integer NOT NULL default '0',
userid integer NOT NULL default '0',
grade real NOT NULL default '0',
timemodified integer NOT NULL default '0'
);
CREATE INDEX prefix_quiz_grades_quiz_idx ON prefix_quiz_grades (quiz);
CREATE INDEX prefix_quiz_grades_userid_idx ON prefix_quiz_grades (userid);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_match
#
CREATE TABLE prefix_quiz_match (
id SERIAL PRIMARY KEY,
question integer NOT NULL default '0',
subquestions varchar(255) NOT NULL default '',
shuffleanswers integer NOT NULL default '1'
);
CREATE INDEX prefix_quiz_match_question_idx ON prefix_quiz_match (question);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_match_sub
#
CREATE TABLE prefix_quiz_match_sub (
id SERIAL PRIMARY KEY,
question integer NOT NULL default '0',
questiontext text NOT NULL default '',
answertext varchar(255) NOT NULL default ''
);
CREATE INDEX prefix_quiz_match_sub_question_idx ON prefix_quiz_match_sub (question);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_multianswers
#
CREATE TABLE prefix_quiz_multianswers (
id SERIAL PRIMARY KEY,
question integer NOT NULL default '0',
sequence varchar(255) NOT NULL default ''
);
CREATE INDEX prefix_quiz_multianswers_question_idx ON prefix_quiz_multianswers (question);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_multichoice
#
CREATE TABLE prefix_quiz_multichoice (
id SERIAL PRIMARY KEY,
question integer NOT NULL default '0',
layout integer NOT NULL default '0',
answers varchar(255) NOT NULL default '',
single integer NOT NULL default '0',
shuffleanswers integer NOT NULL default '1'
);
CREATE INDEX prefix_quiz_multichoice_question_idx ON prefix_quiz_multichoice (question);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_newest_states
#
CREATE TABLE prefix_quiz_newest_states (
id SERIAL PRIMARY KEY,
attemptid integer NOT NULL default '0',
questionid integer NOT NULL default '0',
newest integer NOT NULL default '0',
newgraded integer NOT NULL default '0',
sumpenalty varchar(10) NOT NULL default '0.0'
);
CREATE UNIQUE INDEX prefix_quiz_newest_states_attempt_idx ON prefix_quiz_newest_states (attemptid,questionid);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_numerical
#
CREATE TABLE prefix_quiz_numerical (
id SERIAL PRIMARY KEY,
question integer NOT NULL default '0',
answer integer NOT NULL default '0',
tolerance varchar(255) NOT NULL default '0.0'
);
CREATE INDEX prefix_quiz_numerical_answer_idx ON prefix_quiz_numerical (answer);
CREATE INDEX prefix_quiz_numerical_question_idx ON prefix_quiz_numerical (question);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_numerical_units
#
CREATE TABLE prefix_quiz_numerical_units (
id SERIAL8 PRIMARY KEY,
question INT8 NOT NULL default '0',
multiplier decimal(40,20) NOT NULL default '1.00000000000000000000',
unit varchar(50) NOT NULL default ''
);
CREATE INDEX prefix_quiz_numerical_units_question_idx ON prefix_quiz_numerical_units (question);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_question_datasets
#
CREATE TABLE prefix_quiz_question_datasets (
id SERIAL8 PRIMARY KEY,
question INT8 NOT NULL default '0',
datasetdefinition INT8 NOT NULL default '0'
);
CREATE INDEX prefix_quiz_question_datasets_question_datasetdefinition_idx ON prefix_quiz_question_datasets (question,datasetdefinition);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_question_instances
#
CREATE TABLE prefix_quiz_question_instances (
id SERIAL PRIMARY KEY,
quiz integer NOT NULL default '0',
question integer NOT NULL default '0',
grade integer NOT NULL default '0'
);
CREATE INDEX prefix_quiz_question_instances_quiz_idx ON prefix_quiz_question_instances (quiz);
CREATE INDEX prefix_quiz_question_instances_question_idx ON prefix_quiz_question_instances (question);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_question_versions
#
CREATE TABLE prefix_quiz_question_versions (
id SERIAL PRIMARY KEY,
quiz integer NOT NULL default '0',
oldquestion integer NOT NULL default '0',
newquestion integer NOT NULL default '0',
userid integer NOT NULL default '0',
timestamp integer NOT NULL default '0'
);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_questions
#
CREATE TABLE prefix_quiz_questions (
id SERIAL PRIMARY KEY,
category integer NOT NULL default '0',
parent integer NOT NULL default '0',
name varchar(255) NOT NULL default '',
questiontext text NOT NULL default '',
questiontextformat integer NOT NULL default '0',
image varchar(255) NOT NULL default '',
defaultgrade integer NOT NULL default '1',
penalty real NOT NULL default '0.1',
qtype integer NOT NULL default '0',
length integer NOT NULL DEFAULT '1',
stamp varchar(255) NOT NULL default '',
version integer NOT NULL default '1',
hidden integer NOT NULL default '0'
);
CREATE INDEX prefix_quiz_questions_category_idx ON prefix_quiz_questions (category);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_randomsamatch
#
CREATE TABLE prefix_quiz_randomsamatch (
id SERIAL PRIMARY KEY,
question integer NOT NULL default '0',
choose integer NOT NULL default '4',
shuffleanswers integer NOT NULL default '1'
);
CREATE INDEX prefix_quiz_randomsamatch_question_idx ON prefix_quiz_randomsamatch (question);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_rqp
#
CREATE TABLE prefix_quiz_rqp (
id SERIAL PRIMARY KEY,
question integer NOT NULL default '0',
type integer NOT NULL default '0',
source text NOT NULL,
format varchar(255) NOT NULL default '',
flags integer NOT NULL default '0',
maxscore integer NOT NULL default '1'
);
CREATE INDEX prefix_quiz_rqp_question_idx ON prefix_quiz_rqp (question);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_rqp_states
#
CREATE TABLE prefix_quiz_rqp_states (
id SERIAL PRIMARY KEY,
stateid integer NOT NULL default '0',
responses text NOT NULL,
persistent_data text NOT NULL,
template_vars text NOT NULL
);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_rqp_type
#
CREATE TABLE prefix_quiz_rqp_types (
id SERIAL PRIMARY KEY,
name varchar(255) NOT NULL default '',
rendering_server varchar(255) NOT NULL default '',
cloning_server varchar(255) NOT NULL default '',
flags integer NOT NULL default '0'
);
CREATE UNIQUE INDEX prefix_quiz_rqp_types_name_uk ON prefix_quiz_rqp_types (name);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_shortanswer
#
CREATE TABLE prefix_quiz_shortanswer (
id SERIAL PRIMARY KEY,
question integer NOT NULL default '0',
answers varchar(255) NOT NULL default '',
usecase integer NOT NULL default '0'
);
CREATE INDEX prefix_quiz_shortanswer_question_idx ON prefix_quiz_shortanswer (question);
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_states
#
CREATE TABLE prefix_quiz_states (
id SERIAL PRIMARY KEY,
attempt integer NOT NULL default '0',
question integer NOT NULL default '0',
originalquestion integer NOT NULL default '0',
seq_number integer NOT NULL default '0',
answer text NOT NULL default '',
timestamp integer NOT NULL default '0',
event integer NOT NULL default '0',
grade varchar(10) NOT NULL default '0.0',
raw_grade varchar(10) NOT NULL default '',
penalty varchar(10) NOT NULL default '0.0'
);
CREATE INDEX prefix_quiz_states_attempt_idx ON prefix_quiz_states (attempt);
CREATE INDEX prefix_quiz_states_question_idx ON prefix_quiz_states (question);;
# --------------------------------------------------------
#
# Table structure for table prefix_quiz_truefalse
#
CREATE TABLE prefix_quiz_truefalse (
id SERIAL PRIMARY KEY,
question integer NOT NULL default '0',
trueanswer integer NOT NULL default '0',
falseanswer integer NOT NULL default '0'
);
CREATE INDEX prefix_quiz_truefalse_question_idx ON prefix_quiz_truefalse (question);
INSERT INTO prefix_log_display VALUES ('quiz', 'add', 'quiz', 'name');
INSERT INTO prefix_log_display VALUES ('quiz', 'update', 'quiz', 'name');
INSERT INTO prefix_log_display VALUES ('quiz', 'view', 'quiz', 'name');
INSERT INTO prefix_log_display VALUES ('quiz', 'report', 'quiz', 'name');
INSERT INTO prefix_log_display VALUES ('quiz', 'attempt', 'quiz', 'name');
INSERT INTO prefix_log_display VALUES ('quiz', 'submit', 'quiz', 'name');
INSERT INTO prefix_log_display VALUES ('quiz', 'review', 'quiz', 'name');
INSERT INTO prefix_log_display VALUES ('quiz', 'editquestions', 'quiz', 'name');
INSERT INTO prefix_log_display VALUES ('quiz', 'preview', 'quiz', 'name');
INSERT INTO prefix_log_display VALUES ('quiz', 'start attempt', 'quiz', 'name');
INSERT INTO prefix_log_display VALUES ('quiz', 'close attempt', 'quiz', 'name');