question/type/formulas plugin needs upgrading
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_question_formulas (
id BIGINT(10) unsigned NOT NULL auto_increment,
questionid BIGINT(10) unsigned NOT NULL DEFAULT 0,
answerids TEXT NOT NULL,
varsrandom TEXT,
varsglobal TEXT,
peranswersubmit SMALLINT(4) NOT NULL DEFAULT 1,
showperanswermark SMALLINT(4) NOT NULL DEFAULT 1,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_formulas COMMENT='Options for formulas question type'
Success
(mysql): CREATE INDEX mdl_quesform_que_ix ON mdl_question_formulas (questionid)
Success
(mysql): CREATE TABLE mdl_question_formulas_answers (
id BIGINT(10) unsigned NOT NULL auto_increment,
questionid BIGINT(10) unsigned NOT NULL DEFAULT 0,
placeholder VARCHAR(40) DEFAULT NULL,
answermark DOUBLE NOT NULL,
answertype BIGINT(10) NOT NULL DEFAULT 0,
numbox BIGINT(10) NOT NULL,
vars1 TEXT,
answer TEXT NOT NULL,
vars2 TEXT,
correctness TEXT NOT NULL,
unitpenalty DOUBLE DEFAULT NULL,
postunit TEXT,
ruleid BIGINT(10) unsigned NOT NULL,
otherrule TEXT,
trialmarkseq TEXT NOT NULL,
subqtext TEXT,
feedback TEXT,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_formulas_answers COMMENT='Answers for formulas question type'
Success
(mysql): CREATE INDEX mdl_quesformansw_que_ix ON mdl_question_formulas_answers (questionid)
Success
formulas tables have been set up correctly