Информация об отладке: Table 'mdl_quiz' already exists
CREATE TABLE mdl_quiz (
id BIGINT(10) NOT NULL auto_increment,
course BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
intro LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,
introformat SMALLINT(4) NOT NULL DEFAULT 0,
timeopen BIGINT(10) NOT NULL DEFAULT 0,
timeclose BIGINT(10) NOT NULL DEFAULT 0,
timelimit BIGINT(10) NOT NULL DEFAULT 0,
overduehandling VARCHAR(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'autoabandon',
graceperiod BIGINT(10) NOT NULL DEFAULT 0,
preferredbehaviour VARCHAR(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
canredoquestions SMALLINT(4) NOT NULL DEFAULT 0,
attempts MEDIUMINT(6) NOT NULL DEFAULT 0,
attemptonlast SMALLINT(4) NOT NULL DEFAULT 0,
grademethod SMALLINT(4) NOT NULL DEFAULT 1,
decimalpoints SMALLINT(4) NOT NULL DEFAULT 2,
questiondecimalpoints SMALLINT(4) NOT NULL DEFAULT -1,
reviewattempt MEDIUMINT(6) NOT NULL DEFAULT 0,
reviewcorrectness MEDIUMINT(6) NOT NULL DEFAULT 0,
reviewmarks MEDIUMINT(6) NOT NULL DEFAULT 0,
reviewspecificfeedback MEDIUMINT(6) NOT NULL DEFAULT 0,
reviewgeneralfeedback MEDIUMINT(6) NOT NULL DEFAULT 0,
reviewrightanswer MEDIUMINT(6) NOT NULL DEFAULT 0,
reviewoverallfeedback MEDIUMINT(6) NOT NULL DEFAULT 0,
questionsperpage BIGINT(10) NOT NULL DEFAULT 0,
navmethod VARCHAR(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'free',
shuffleanswers SMALLINT(4) NOT NULL DEFAULT 0,
sumgrades NUMERIC(10,5) NOT NULL DEFAULT 0,
grade NUMERIC(10,5) NOT NULL DEFAULT 0,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
password VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
subnet VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
browsersecurity VARCHAR(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
delay1 BIGINT(10) NOT NULL DEFAULT 0,
delay2 BIGINT(10) NOT NULL DEFAULT 0,
showuserpicture SMALLINT(4) NOT NULL DEFAULT 0,
showblocks SMALLINT(4) NOT NULL DEFAULT 0,
completionattemptsexhausted TINYINT(1) DEFAULT 0,
completionpass TINYINT(1) DEFAULT 0,
completionminattempts BIGINT(10) NOT NULL DEFAULT 0,
allowofflineattempts TINYINT(1) DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quiz_cou2_ix (course)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='The settings for each quiz.'
;
CREATE TABLE mdl_quiz_slots (
id BIGINT(10) NOT NULL auto_increment,
slot BIGINT(10) NOT NULL,
quizid BIGINT(10) NOT NULL DEFAULT 0,
page BIGINT(10) NOT NULL,
requireprevious SMALLINT(4) NOT NULL DEFAULT 0,
questionid BIGINT(10) NOT NULL DEFAULT 0,
questioncategoryid BIGINT(10),
includingsubcategories SMALLINT(4),
maxmark NUMERIC(12,7) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_quizslot_quislo2_uix (quizid, slot)
, KEY mdl_quizslot_qui2_ix (quizid)
, KEY mdl_quizslot_que3_ix (questionid)
, KEY mdl_quizslot_que4_ix (questioncategoryid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Stores the question used in a quiz, with the order, and for '
;
CREATE TABLE mdl_quiz_sections (
id BIGINT(10) NOT NULL auto_increment,
quizid BIGINT(10) NOT NULL,
firstslot BIGINT(10) NOT NULL,
heading VARCHAR(1333) COLLATE utf8mb4_unicode_ci,
shufflequestions SMALLINT(4) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_quizsect_quifir2_uix (quizid, firstslot)
, KEY mdl_quizsect_qui2_ix (quizid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Stores sections of a quiz with section name (heading), from '
;
CREATE TABLE mdl_quiz_feedback (
id BIGINT(10) NOT NULL auto_increment,
quizid BIGINT(10) NOT NULL DEFAULT 0,
feedbacktext LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,
feedbacktextformat TINYINT(2) NOT NULL DEFAULT 0,
mingrade NUMERIC(10,5) NOT NULL DEFAULT 0,
maxgrade NUMERIC(10,5) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quizfeed_qui2_ix (quizid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Feedback given to students based on which grade band their o'
;
CREATE TABLE mdl_quiz_overrides (
id BIGINT(10) NOT NULL auto_increment,
quiz BIGINT(10) NOT NULL DEFAULT 0,
groupid BIGINT(10),
userid BIGINT(10),
timeopen BIGINT(10),
timeclose BIGINT(10),
timelimit BIGINT(10),
attempts MEDIUMINT(6),
password VARCHAR(255) COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quizover_qui2_ix (quiz)
, KEY mdl_quizover_gro2_ix (groupid)
, KEY mdl_quizover_use2_ix (userid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='The overrides to quiz settings on a per-user and per-group b'
;
CREATE TABLE mdl_quiz_attempts (
id BIGINT(10) NOT NULL auto_increment,
quiz BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
attempt MEDIUMINT(6) NOT NULL DEFAULT 0,
uniqueid BIGINT(10) NOT NULL DEFAULT 0,
layout LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,
currentpage BIGINT(10) NOT NULL DEFAULT 0,
preview SMALLINT(3) NOT NULL DEFAULT 0,
state VARCHAR(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inprogress',
timestart BIGINT(10) NOT NULL DEFAULT 0,
timefinish BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
timemodifiedoffline BIGINT(10) NOT NULL DEFAULT 0,
timecheckstate BIGINT(10) DEFAULT 0,
sumgrades NUMERIC(10,5),
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_quizatte_quiuseatt2_uix (quiz, userid, attempt)
, KEY mdl_quizatte_statim2_ix (state, timecheckstate)
, KEY mdl_quizatte_qui2_ix (quiz)
, KEY mdl_quizatte_use2_ix (userid)
, UNIQUE KEY mdl_quizatte_uni2_uix (uniqueid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Stores users attempts at quizzes.'
;
CREATE TABLE mdl_quiz_grades (
id BIGINT(10) NOT NULL auto_increment,
quiz BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
grade NUMERIC(10,5) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quizgrad_use2_ix (userid)
, KEY mdl_quizgrad_qui2_ix (quiz)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Stores the overall grade for each user on the quiz, based on'
;
CREATE TABLE mdl_quiz_reports (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(255) COLLATE utf8mb4_unicode_ci,
displayorder BIGINT(10) NOT NULL,
capability VARCHAR(255) COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_quizrepo_nam2_uix (name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Lists all the installed quiz reports and their display order'
;
CREATE TABLE mdl_quiz_slot_tags (
id BIGINT(10) NOT NULL auto_increment,
slotid BIGINT(10),
tagid BIGINT(10),
tagname VARCHAR(255) COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quizslottags_slo2_ix (slotid)
, KEY mdl_quizslottags_tag2_ix (tagid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Stores data about the tags that a question must have so that'
Error code: ddlexecuteerror