question/type/calculated plugin needs upgrading

(mysql): SHOW TABLES  
(mysql): SHOW TABLES  
(mysql): CREATE TABLE ss_dbprefixquestion_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 ss_dbprefixquestion_calculated COMMENT='Options for questions of type calculated'  
Success
(mysql): CREATE INDEX ss_dbprefixquescalc_ans_ix ON ss_dbprefixquestion_calculated (answer)  
Success
(mysql): CREATE INDEX ss_dbprefixquescalc_que_ix ON ss_dbprefixquestion_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 ss_dbprefixquestion_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 ss_dbprefixquestion_match COMMENT='Defines fixed matching questions'  
Success
(mysql): CREATE INDEX ss_dbprefixquesmatc_que_ix ON ss_dbprefixquestion_match (question)  
Success
(mysql): CREATE TABLE ss_dbprefixquestion_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 ss_dbprefixquestion_match_sub COMMENT='Defines the subquestions that make up a matching question'  
Success
(mysql): CREATE INDEX ss_dbprefixquesmatcsub_que_ix ON ss_dbprefixquestion_match_sub (question)  
Success
match tables have been set up correctly

question/type/multianswer plugin needs upgrading

(mysql): SHOW TABLES  
(mysql): CREATE TABLE ss_dbprefixquestion_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 ss_dbprefixquestion_multianswer COMMENT='Options for multianswer questions'  
Success
(mysql): CREATE INDEX ss_dbprefixquesmult_que_ix ON ss_dbprefixquestion_multianswer (question)  
Success
multianswer tables have been set up correctly

question/type/multichoice plugin needs upgrading

(mysql): SHOW TABLES  
(mysql): CREATE TABLE ss_dbprefixquestion_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 ss_dbprefixquestion_multichoice COMMENT='Options for multiple choice questions'  
Success
(mysql): CREATE INDEX ss_dbprefixquesmult_que2_ix ON ss_dbprefixquestion_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 ss_dbprefixquestion_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 ss_dbprefixquestion_numerical COMMENT='Options for numerical questions'  
Success
(mysql): CREATE INDEX ss_dbprefixquesnume_ans_ix ON ss_dbprefixquestion_numerical (answer)  
Success
(mysql): CREATE INDEX ss_dbprefixquesnume_que_ix ON ss_dbprefixquestion_numerical (question)  
Success
numerical tables have been set up correctly

question/type/randomsamatch plugin needs upgrading

(mysql): SHOW TABLES  
(mysql): CREATE TABLE ss_dbprefixquestion_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 ss_dbprefixquestion_randomsamatch COMMENT='Info about a random short-answer matching question'  
Success
(mysql): CREATE INDEX ss_dbprefixquesrand_que_ix ON ss_dbprefixquestion_randomsamatch (question)  
Success
randomsamatch tables have been set up correctly

question/type/shortanswer plugin needs upgrading

(mysql): SHOW TABLES  
(mysql): CREATE TABLE ss_dbprefixquestion_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 ss_dbprefixquestion_shortanswer COMMENT='Options for short answer questions'  
Success
(mysql): CREATE INDEX ss_dbprefixquesshor_que_ix ON ss_dbprefixquestion_shortanswer (question)  
Success
shortanswer tables have been set up correctly

question/type/truefalse plugin needs upgrading

(mysql): SHOW TABLES  
(mysql): CREATE TABLE ss_dbprefixquestion_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 ss_dbprefixquestion_truefalse COMMENT='Options for True-False questions'  
Success
(mysql): CREATE INDEX ss_dbprefixquestrue_que_ix ON ss_dbprefixquestion_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 ss_dbprefixbackup_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 ss_dbprefixbackup_files COMMENT='To store and recode ids to user and course files'  
Success
(mysql): CREATE UNIQUE INDEX ss_dbprefixbackfile_bacfil_uix ON ss_dbprefixbackup_files (backup_code, file_type, path)  
Success
(mysql): CREATE TABLE ss_dbprefixbackup_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 ss_dbprefixbackup_ids COMMENT='To store and convert ids in backup/restore'  
Success
(mysql): CREATE UNIQUE INDEX ss_dbprefixbackids_bactabo_uix ON ss_dbprefixbackup_ids (backup_code, table_name, old_id)  
Success
(mysql): CREATE TABLE ss_dbprefixbackup_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 ss_dbprefixbackup_config COMMENT='To store backup configuration variables'  
Success
(mysql): CREATE UNIQUE INDEX ss_dbprefixbackconf_nam_uix ON ss_dbprefixbackup_config (name)  
Success
(mysql): CREATE TABLE ss_dbprefixbackup_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 ss_dbprefixbackup_courses COMMENT='To store every course backup status'  
Success
(mysql): CREATE UNIQUE INDEX ss_dbprefixbackcour_cou_uix ON ss_dbprefixbackup_courses (courseid)  
Success
(mysql): CREATE TABLE ss_dbprefixbackup_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 ss_dbprefixbackup_log COMMENT='To store every course backup log info'  
Success
(mysql): CREATE INDEX ss_dbprefixbacklog_cou_ix ON ss_dbprefixbackup_log (courseid)  
Success
Database was successfully upgraded
Backup version is now 2008030301

blocks

(mysql): SHOW TABLES  
(mysql): SHOW TABLES  
(mysql): SHOW TABLES  
(mysql): SHOW TABLES  
(mysql): SHOW TABLES  
(mysql): CREATE TABLE ss_dbprefixblock ( 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 ss_dbprefixblock COMMENT='to store installed blocks'  
Success
(mysql): CREATE TABLE ss_dbprefixblock_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 ss_dbprefixblock_instance COMMENT='to store block instances in pages'  
Success
(mysql): CREATE INDEX ss_dbprefixblocinst_pag_ix ON ss_dbprefixblock_instance (pageid)  
Success
(mysql): CREATE INDEX ss_dbprefixblocinst_pag2_ix ON ss_dbprefixblock_instance (pagetype)  
Success
(mysql): CREATE INDEX ss_dbprefixblocinst_blo_ix ON ss_dbprefixblock_instance (blockid)  
Success
(mysql): CREATE TABLE ss_dbprefixblock_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 ss_dbprefixblock_pinned COMMENT='to pin blocks'  
Success
(mysql): CREATE INDEX ss_dbprefixblocpinn_pag_ix ON ss_dbprefixblock_pinned (pagetype)  
Success
(mysql): CREATE INDEX ss_dbprefixblocpinn_blo_ix ON ss_dbprefixblock_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 ss_dbprefixblock_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 ss_dbprefixblock_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 ss_dbprefixblock_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 ss_dbprefixblock_search_documents COMMENT='table to store search index backups'  
Success
(mysql): CREATE INDEX ss_dbprefixblocseardocu_doc_ix ON ss_dbprefixblock_search_documents (docid)  
Success
(mysql): CREATE INDEX ss_dbprefixblocseardocu_do2_ix ON ss_dbprefixblock_search_documents (doctype)  
Success
(mysql): CREATE INDEX ss_dbprefixblocseardocu_ite_ix ON ss_dbprefixblock_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 ss_dbprefixenrol_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 ss_dbprefixenrol_authorize COMMENT='Holds all known information about authorize.net transactions'  
Success
(mysql): CREATE INDEX ss_dbprefixenroauth_cou_ix ON ss_dbprefixenrol_authorize (courseid)  
Success
(mysql): CREATE INDEX ss_dbprefixenroauth_use_ix ON ss_dbprefixenrol_authorize (userid)  
Success
(mysql): CREATE INDEX ss_dbprefixenroauth_sta_ix ON ss_dbprefixenrol_authorize (status)  
Success
(mysql): CREATE INDEX ss_dbprefixenroauth_tra_ix ON ss_dbprefixenrol_authorize (transid)  
Success
(mysql): CREATE TABLE ss_dbprefixenrol_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 ss_dbprefixenrol_authorize_refunds COMMENT='Authorize.net refunds'  
Success
(mysql): CREATE INDEX ss_dbprefixenroauthrefu_tra_ix ON ss_dbprefixenrol_authorize_refunds (transid)  
Success
(mysql): CREATE INDEX ss_dbprefixenroauthrefu_ord_ix ON ss_dbprefixenrol_authorize_refunds (orderid)  
Success
authorize tables have been set up correctly

enrol/paypal plugin needs upgrading

(mysql): CREATE TABLE ss_dbprefixenrol_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 ss_dbprefixenrol_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