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
activity_modules
Activities tables have been set up correctly
admin
Administration tables have been set up correctly
admin_bookmarks
Admin bookmarks tables have been set up correctly
admin_tree
Site Administration tables have been set up correctly
blog_menu
Blog Menu tables have been set up correctly
blog_tags
Blog Tags tables have been set up correctly
calendar_month
Calendar tables have been set up correctly
calendar_upcoming
Upcoming Events tables have been set up correctly
course_list
Courses tables have been set up correctly
course_summary
Course/Site Description tables have been set up correctly
glossary_random
Random Glossary Entry tables have been set up correctly
html
HTML tables have been set up correctly
loancalc
Loan calculator tables have been set up correctly
login
Login tables have been set up correctly
mentees
Mentees tables have been set up correctly
messages
Messages tables have been set up correctly
mnet_hosts
Network Servers tables have been set up correctly
news_items
Latest News tables have been set up correctly
online_users
Online Users tables have been set up correctly
participants
People tables have been set up correctly
quiz_results
Quiz Results tables have been set up correctly
recent_activity
Recent Activity tables have been set up correctly
rss_client
(mysql): CREATE TABLE mdl_block_rss_client (
id BIGINT(10) unsigned NOT NULL auto_increment,
userid BIGINT(10) unsigned NOT NULL DEFAULT 0,
title TEXT NOT NULL,
preferredtitle VARCHAR(64) NOT NULL DEFAULT '',
description TEXT NOT NULL,
shared TINYINT(2) unsigned NOT NULL DEFAULT 0,
url VARCHAR(255) NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_block_rss_client COMMENT='Remote news feed information. Contains the news feed id, the'
Success
Remote RSS Feeds tables have been set up correctly
search
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_block_search_documents (
id BIGINT(10) unsigned NOT NULL auto_increment,
docid VARCHAR(32) NOT NULL DEFAULT '',
doctype VARCHAR(32) NOT NULL DEFAULT 'none',
itemtype VARCHAR(32) NOT NULL DEFAULT 'standard',
title VARCHAR(255) NOT NULL DEFAULT '',
url VARCHAR(255) NOT NULL DEFAULT '',
docdate BIGINT(10) unsigned NOT NULL DEFAULT 0,
updated BIGINT(10) unsigned NOT NULL DEFAULT 0,
courseid BIGINT(10) unsigned NOT NULL DEFAULT 0,
groupid BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_block_search_documents COMMENT='table to store search index backups'
Success
(mysql): CREATE INDEX mdl_blocseardocu_doc_ix ON mdl_block_search_documents (docid)
Success
(mysql): CREATE INDEX mdl_blocseardocu_doc2_ix ON mdl_block_search_documents (doctype)
Success
(mysql): CREATE INDEX mdl_blocseardocu_ite_ix ON mdl_block_search_documents (itemtype)
Success
Global Search tables have been set up correctly
search_forums
Search Forums tables have been set up correctly
section_links
Section Links tables have been set up correctly
site_main_menu
Main Menu tables have been set up correctly
social_activities
Social Activities tables have been set up correctly
tag_flickr
Flickr tables have been set up correctly
tag_youtube
Youtube tables have been set up correctly
tags
Tags tables have been set up correctly
enrol/authorize plugin needs upgrading
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_enrol_authorize (
id BIGINT(10) unsigned NOT NULL auto_increment,
paymentmethod enum('cc', 'echeck') NOT NULL DEFAULT 'cc',
refundinfo SMALLINT(4) unsigned NOT NULL DEFAULT 0,
ccname VARCHAR(255) NOT NULL DEFAULT '',
courseid BIGINT(10) unsigned NOT NULL DEFAULT 0,
userid BIGINT(10) unsigned NOT NULL DEFAULT 0,
transid BIGINT(20) unsigned NOT NULL DEFAULT 0,
status BIGINT(10) unsigned NOT NULL DEFAULT 0,
timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0,
settletime BIGINT(10) unsigned NOT NULL DEFAULT 0,
amount VARCHAR(10) NOT NULL DEFAULT '',
currency VARCHAR(3) NOT NULL DEFAULT 'USD',
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_enrol_authorize COMMENT='Holds all known information about authorize.net transactions'
Success
(mysql): CREATE INDEX mdl_enroauth_cou_ix ON mdl_enrol_authorize (courseid)
Success
(mysql): CREATE INDEX mdl_enroauth_use_ix ON mdl_enrol_authorize (userid)
Success
(mysql): CREATE INDEX mdl_enroauth_sta_ix ON mdl_enrol_authorize (status)
Success
(mysql): CREATE INDEX mdl_enroauth_tra_ix ON mdl_enrol_authorize (transid)
Success
(mysql): CREATE TABLE mdl_enrol_authorize_refunds (
id BIGINT(10) unsigned NOT NULL auto_increment,
orderid BIGINT(10) unsigned NOT NULL DEFAULT 0,
status TINYINT(1) unsigned NOT NULL DEFAULT 0,
amount VARCHAR(10) NOT NULL DEFAULT '',
transid BIGINT(20) unsigned DEFAULT 0,
settletime BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_enrol_authorize_refunds COMMENT='Authorize.net refunds'
Success
(mysql): CREATE INDEX mdl_enroauthrefu_tra_ix ON mdl_enrol_authorize_refunds (transid)
Success
(mysql): CREATE INDEX mdl_enroauthrefu_ord_ix ON mdl_enrol_authorize_refunds (orderid)
Success
authorize tables have been set up correctly
enrol/paypal plugin needs upgrading
(mysql): CREATE TABLE mdl_enrol_paypal (
id BIGINT(10) unsigned NOT NULL auto_increment,
business VARCHAR(255) NOT NULL DEFAULT '',
receiver_email VARCHAR(255) NOT NULL DEFAULT '',
receiver_id VARCHAR(255) NOT NULL DEFAULT '',
item_name VARCHAR(255) NOT NULL DEFAULT '',
courseid BIGINT(10) unsigned NOT NULL DEFAULT 0,
userid BIGINT(10) unsigned NOT NULL DEFAULT 0,
memo VARCHAR(255) NOT NULL DEFAULT '',
tax VARCHAR(255) NOT NULL DEFAULT '',
option_name1 VARCHAR(255) NOT NULL DEFAULT '',
option_selection1_x VARCHAR(255) NOT NULL DEFAULT '',
option_name2 VARCHAR(255) NOT NULL DEFAULT '',
option_selection2_x VARCHAR(255) NOT NULL DEFAULT '',
payment_status VARCHAR(255) NOT NULL DEFAULT '',
pending_reason VARCHAR(255) NOT NULL DEFAULT '',
reason_code VARCHAR(30) NOT NULL DEFAULT '',
txn_id VARCHAR(255) NOT NULL DEFAULT '',
parent_txn_id VARCHAR(255) NOT NULL DEFAULT '',
payment_type VARCHAR(30) NOT NULL DEFAULT '',
timeupdated BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_enrol_paypal COMMENT='Holds all known information about PayPal transactions'
Success
paypal tables have been set up correctly
grade/export/ods plugin needs upgrading
ods tables have been set up correctly
grade/export/txt plugin needs upgrading
txt tables have been set up correctly
grade/export/xls plugin needs upgrading
xls tables have been set up correctly
grade/export/xml plugin needs upgrading
xml tables have been set up correctly
grade/import/csv plugin needs upgrading
csv tables have been set up correctly
grade/import/xml plugin needs upgrading
xml tables have been set up correctly
grade/report/grader plugin needs upgrading
grader tables have been set up correctly
grade/report/outcomes plugin needs upgrading
outcomes tables have been set up correctly
grade/report/overview plugin needs upgrading
overview tables have been set up correctly
grade/report/user plugin needs upgrading
user tables have been set up correctly
course/report/log plugin needs upgrading
log tables have been set up correctly
course/report/outline plugin needs upgrading
outline tables have been set up correctly
course/report/participation plugin needs upgrading
participation tables have been set up correctly
course/report/stats plugin needs upgrading
stats tables have been set up correctly
admin/report/courseoverview plugin needs upgrading
courseoverview tables have been set up correctly
admin/report/security plugin needs upgrading
security tables have been set up correctly
admin/report/unittest plugin needs upgrading
unittest tables have been set up correctly