question/type/calculated plugin needs upgrading
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_question_calculated (
id BIGINT(10) unsigned NOT NULL auto_increment,
question BIGINT(10) unsigned NOT NULL DEFAULT 0,
answer BIGINT(10) unsigned NOT NULL DEFAULT 0,
tolerance VARCHAR(20) NOT NULL DEFAULT '0.0',
tolerancetype BIGINT(10) NOT NULL DEFAULT 1,
correctanswerlength BIGINT(10) NOT NULL DEFAULT 2,
correctanswerformat BIGINT(10) NOT NULL DEFAULT 2,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_calculated COMMENT='Options for questions of type calculated'
Success
(mysql): CREATE INDEX mdl_quescalc_ans_ix ON mdl_question_calculated (answer)
Success
(mysql): CREATE INDEX mdl_quescalc_que_ix ON mdl_question_calculated (question)
Success
calculated tables have been set up correctly
question/type/essay plugin needs upgrading
essay tables have been set up correctly
question/type/match plugin needs upgrading
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_question_match (
id BIGINT(10) unsigned NOT NULL auto_increment,
question BIGINT(10) unsigned NOT NULL DEFAULT 0,
subquestions VARCHAR(255) NOT NULL DEFAULT '',
shuffleanswers SMALLINT(4) NOT NULL DEFAULT 1,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_match COMMENT='Defines fixed matching questions'
Success
(mysql): CREATE INDEX mdl_quesmatc_que_ix ON mdl_question_match (question)
Success
(mysql): CREATE TABLE mdl_question_match_sub (
id BIGINT(10) unsigned NOT NULL auto_increment,
code BIGINT(10) unsigned NOT NULL DEFAULT 0,
question BIGINT(10) unsigned NOT NULL DEFAULT 0,
questiontext TEXT NOT NULL,
answertext VARCHAR(255) NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_match_sub COMMENT='Defines the subquestions that make up a matching question'
Success
(mysql): CREATE INDEX mdl_quesmatcsub_que_ix ON mdl_question_match_sub (question)
Success
match tables have been set up correctly
question/type/multianswer plugin needs upgrading
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_question_multianswer (
id BIGINT(10) unsigned NOT NULL auto_increment,
question BIGINT(10) unsigned NOT NULL DEFAULT 0,
sequence TEXT NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_multianswer COMMENT='Options for multianswer questions'
Success
(mysql): CREATE INDEX mdl_quesmult_que_ix ON mdl_question_multianswer (question)
Success
multianswer tables have been set up correctly
question/type/multichoice plugin needs upgrading
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_question_multichoice (
id BIGINT(10) unsigned NOT NULL auto_increment,
question BIGINT(10) unsigned NOT NULL DEFAULT 0,
layout SMALLINT(4) NOT NULL DEFAULT 0,
answers VARCHAR(255) NOT NULL DEFAULT '',
single SMALLINT(4) NOT NULL DEFAULT 0,
shuffleanswers SMALLINT(4) NOT NULL DEFAULT 1,
correctfeedback TEXT NOT NULL,
partiallycorrectfeedback TEXT NOT NULL,
incorrectfeedback TEXT NOT NULL,
answernumbering VARCHAR(10) NOT NULL DEFAULT 'abc',
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_multichoice COMMENT='Options for multiple choice questions'
Success
(mysql): CREATE INDEX mdl_quesmult_que2_ix ON mdl_question_multichoice (question)
Success
multichoice tables have been set up correctly
question/type/numerical plugin needs upgrading
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_question_numerical (
id BIGINT(10) unsigned NOT NULL auto_increment,
question BIGINT(10) unsigned NOT NULL DEFAULT 0,
answer BIGINT(10) unsigned NOT NULL DEFAULT 0,
tolerance VARCHAR(255) NOT NULL DEFAULT '0.0',
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_numerical COMMENT='Options for numerical questions'
Success
(mysql): CREATE INDEX mdl_quesnume_ans_ix ON mdl_question_numerical (answer)
Success
(mysql): CREATE INDEX mdl_quesnume_que_ix ON mdl_question_numerical (question)
Success
numerical tables have been set up correctly
question/type/randomsamatch plugin needs upgrading
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_question_randomsamatch (
id BIGINT(10) unsigned NOT NULL auto_increment,
question BIGINT(10) unsigned NOT NULL DEFAULT 0,
choose BIGINT(10) unsigned NOT NULL DEFAULT 4,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_randomsamatch COMMENT='Info about a random short-answer matching question'
Success
(mysql): CREATE INDEX mdl_quesrand_que_ix ON mdl_question_randomsamatch (question)
Success
randomsamatch tables have been set up correctly
question/type/shortanswer plugin needs upgrading
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_question_shortanswer (
id BIGINT(10) unsigned NOT NULL auto_increment,
question BIGINT(10) unsigned NOT NULL DEFAULT 0,
answers VARCHAR(255) NOT NULL DEFAULT '',
usecase TINYINT(2) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_shortanswer COMMENT='Options for short answer questions'
Success
(mysql): CREATE INDEX mdl_quesshor_que_ix ON mdl_question_shortanswer (question)
Success
shortanswer tables have been set up correctly
question/type/truefalse plugin needs upgrading
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_question_truefalse (
id BIGINT(10) unsigned NOT NULL auto_increment,
question BIGINT(10) unsigned NOT NULL DEFAULT 0,
trueanswer BIGINT(10) unsigned NOT NULL DEFAULT 0,
falseanswer BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_truefalse COMMENT='Options for True-False questions'
Success
(mysql): CREATE INDEX mdl_questrue_que_ix ON mdl_question_truefalse (question)
Success
truefalse tables have been set up correctly
backup
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_backup_files (
id BIGINT(10) unsigned NOT NULL auto_increment,
backup_code BIGINT(10) unsigned NOT NULL DEFAULT 0,
file_type VARCHAR(10) NOT NULL DEFAULT '',
path VARCHAR(255) NOT NULL DEFAULT '',
old_id BIGINT(10) unsigned NOT NULL DEFAULT 0,
new_id BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_backup_files COMMENT='To store and recode ids to user and course files'
Success
(mysql): CREATE UNIQUE INDEX mdl_backfile_bacfilpat_uix ON mdl_backup_files (backup_code, file_type, path)
Success
(mysql): CREATE TABLE mdl_backup_ids (
id BIGINT(10) unsigned NOT NULL auto_increment,
backup_code BIGINT(12) unsigned NOT NULL DEFAULT 0,
table_name VARCHAR(30) NOT NULL DEFAULT '',
old_id BIGINT(10) unsigned NOT NULL DEFAULT 0,
new_id BIGINT(10) unsigned NOT NULL DEFAULT 0,
info MEDIUMTEXT NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_backup_ids COMMENT='To store and convert ids in backup/restore'
Success
(mysql): CREATE UNIQUE INDEX mdl_backids_bactabold_uix ON mdl_backup_ids (backup_code, table_name, old_id)
Success
(mysql): CREATE TABLE mdl_backup_config (
id BIGINT(10) unsigned NOT NULL auto_increment,
name VARCHAR(255) NOT NULL DEFAULT '',
value VARCHAR(255) NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_backup_config COMMENT='To store backup configuration variables'
Success
(mysql): CREATE UNIQUE INDEX mdl_backconf_nam_uix ON mdl_backup_config (name)
Success
(mysql): CREATE TABLE mdl_backup_courses (
id BIGINT(10) unsigned NOT NULL auto_increment,
courseid BIGINT(10) unsigned NOT NULL DEFAULT 0,
laststarttime BIGINT(10) unsigned NOT NULL DEFAULT 0,
lastendtime BIGINT(10) unsigned NOT NULL DEFAULT 0,
laststatus VARCHAR(1) NOT NULL DEFAULT '0',
nextstarttime BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_backup_courses COMMENT='To store every course backup status'
Success
(mysql): CREATE UNIQUE INDEX mdl_backcour_cou_uix ON mdl_backup_courses (courseid)
Success
(mysql): CREATE TABLE mdl_backup_log (
id BIGINT(10) unsigned NOT NULL auto_increment,
courseid BIGINT(10) unsigned NOT NULL DEFAULT 0,
time BIGINT(10) unsigned NOT NULL DEFAULT 0,
laststarttime BIGINT(10) unsigned NOT NULL DEFAULT 0,
info VARCHAR(255) NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_backup_log COMMENT='To store every course backup log info'
Success
(mysql): CREATE INDEX mdl_backlog_cou_ix ON mdl_backup_log (courseid)
Success
Database was successfully upgraded
Backup version is now 2009111300
blocks
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_block (
id BIGINT(10) unsigned NOT NULL auto_increment,
name VARCHAR(40) NOT NULL DEFAULT '',
version BIGINT(10) unsigned NOT NULL DEFAULT 0,
cron BIGINT(10) unsigned NOT NULL DEFAULT 0,
lastcron BIGINT(10) unsigned NOT NULL DEFAULT 0,
visible TINYINT(1) NOT NULL DEFAULT 1,
multiple TINYINT(1) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_block COMMENT='to store installed blocks'
Success
(mysql): CREATE TABLE mdl_block_instance (
id BIGINT(10) unsigned NOT NULL auto_increment,
blockid BIGINT(10) unsigned NOT NULL DEFAULT 0,
pageid BIGINT(10) unsigned NOT NULL DEFAULT 0,
pagetype VARCHAR(20) NOT NULL DEFAULT '',
position VARCHAR(10) NOT NULL DEFAULT '',
weight SMALLINT(3) NOT NULL DEFAULT 0,
visible TINYINT(1) NOT NULL DEFAULT 0,
configdata TEXT,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_block_instance COMMENT='to store block instances in pages'
Success
(mysql): CREATE INDEX mdl_blocinst_pag_ix ON mdl_block_instance (pageid)
Success
(mysql): CREATE INDEX mdl_blocinst_pag2_ix ON mdl_block_instance (pagetype)
Success
(mysql): CREATE INDEX mdl_blocinst_blo_ix ON mdl_block_instance (blockid)
Success
(mysql): CREATE TABLE mdl_block_pinned (
id BIGINT(10) unsigned NOT NULL auto_increment,
blockid BIGINT(10) unsigned NOT NULL DEFAULT 0,
pagetype VARCHAR(20) NOT NULL DEFAULT '',
position VARCHAR(10) NOT NULL DEFAULT '',
weight SMALLINT(3) NOT NULL DEFAULT 0,
visible TINYINT(1) NOT NULL DEFAULT 0,
configdata TEXT NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_block_pinned COMMENT='to pin blocks'
Success
(mysql): CREATE INDEX mdl_blocpinn_pag_ix ON mdl_block_pinned (pagetype)
Success
(mysql): CREATE INDEX mdl_blocpinn_blo_ix ON mdl_block_pinned (blockid)
Success
Database was successfully upgraded
Blocks version is now 2007081300