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) )  
成功

(mysql): ALTER TABLE mdl_question_calculated COMMENT='Options for questions of type calculated'  
成功

(mysql): CREATE INDEX mdl_quescalc_ans_ix ON mdl_question_calculated (answer)  
成功

(mysql): CREATE INDEX mdl_quescalc_que_ix ON mdl_question_calculated (question)  
成功
calculated 資料表已經正確設定了

question/type/essay plugin needs upgrading

essay 資料表已經正確設定了

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) )  
成功

(mysql): ALTER TABLE mdl_question_match COMMENT='Defines fixed matching questions'  
成功

(mysql): CREATE INDEX mdl_quesmatc_que_ix ON mdl_question_match (question)  
成功

(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) )  
成功

(mysql): ALTER TABLE mdl_question_match_sub COMMENT='Defines the subquestions that make up a matching question'  
成功

(mysql): CREATE INDEX mdl_quesmatcsub_que_ix ON mdl_question_match_sub (question)  
成功
match 資料表已經正確設定了

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) )  
成功

(mysql): ALTER TABLE mdl_question_multianswer COMMENT='Options for multianswer questions'  
成功

(mysql): CREATE INDEX mdl_quesmult_que_ix ON mdl_question_multianswer (question)  
成功
multianswer 資料表已經正確設定了

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) )  
成功

(mysql): ALTER TABLE mdl_question_multichoice COMMENT='Options for multiple choice questions'  
成功

(mysql): CREATE INDEX mdl_quesmult_que2_ix ON mdl_question_multichoice (question)  
成功
multichoice 資料表已經正確設定了

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) )  
成功

(mysql): ALTER TABLE mdl_question_numerical COMMENT='Options for numerical questions'  
成功

(mysql): CREATE INDEX mdl_quesnume_ans_ix ON mdl_question_numerical (answer)  
成功

(mysql): CREATE INDEX mdl_quesnume_que_ix ON mdl_question_numerical (question)  
成功
numerical 資料表已經正確設定了

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) )  
成功

(mysql): ALTER TABLE mdl_question_randomsamatch COMMENT='Info about a random short-answer matching question'  
成功

(mysql): CREATE INDEX mdl_quesrand_que_ix ON mdl_question_randomsamatch (question)  
成功
randomsamatch 資料表已經正確設定了

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) )  
成功

(mysql): ALTER TABLE mdl_question_shortanswer COMMENT='Options for short answer questions'  
成功

(mysql): CREATE INDEX mdl_quesshor_que_ix ON mdl_question_shortanswer (question)  
成功
shortanswer 資料表已經正確設定了

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) )  
成功

(mysql): ALTER TABLE mdl_question_truefalse COMMENT='Options for True-False questions'  
成功

(mysql): CREATE INDEX mdl_questrue_que_ix ON mdl_question_truefalse (question)  
成功
truefalse 資料表已經正確設定了

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) )  
成功

(mysql): ALTER TABLE mdl_backup_files COMMENT='To store and recode ids to user and course files'  
成功

(mysql): CREATE UNIQUE INDEX mdl_backfile_bacfilpat_uix ON mdl_backup_files (backup_code, file_type, path)  
成功

(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) )  
成功

(mysql): ALTER TABLE mdl_backup_ids COMMENT='To store and convert ids in backup/restore'  
成功

(mysql): CREATE UNIQUE INDEX mdl_backids_bactabold_uix ON mdl_backup_ids (backup_code, table_name, old_id)  
成功

(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) )  
成功

(mysql): ALTER TABLE mdl_backup_config COMMENT='To store backup configuration variables'  
成功

(mysql): CREATE UNIQUE INDEX mdl_backconf_nam_uix ON mdl_backup_config (name)  
成功

(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) )  
成功

(mysql): ALTER TABLE mdl_backup_courses COMMENT='To store every course backup status'  
成功

(mysql): CREATE UNIQUE INDEX mdl_backcour_cou_uix ON mdl_backup_courses (courseid)  
成功

(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) )  
成功

(mysql): ALTER TABLE mdl_backup_log COMMENT='To store every course backup log info'  
成功

(mysql): CREATE INDEX mdl_backlog_cou_ix ON mdl_backup_log (courseid)  
成功
資料庫升級成功
目前的備份版本為 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) )  
成功

(mysql): ALTER TABLE mdl_block COMMENT='to store installed blocks'  
成功

(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) )  
成功

(mysql): ALTER TABLE mdl_block_instance COMMENT='to store block instances in pages'  
成功

(mysql): CREATE INDEX mdl_blocinst_pag_ix ON mdl_block_instance (pageid)  
成功

(mysql): CREATE INDEX mdl_blocinst_pag2_ix ON mdl_block_instance (pagetype)  
成功

(mysql): CREATE INDEX mdl_blocinst_blo_ix ON mdl_block_instance (blockid)  
成功

(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) )  
成功

(mysql): ALTER TABLE mdl_block_pinned COMMENT='to pin blocks'  
成功

(mysql): CREATE INDEX mdl_blocpinn_pag_ix ON mdl_block_pinned (pagetype)  
成功

(mysql): CREATE INDEX mdl_blocpinn_blo_ix ON mdl_block_pinned (blockid)  
成功
資料庫升級成功
區塊模組目前版本為 2007081300

activity_modules

活動表單被正確建立

admin

系統管理表單被正確建立

admin_bookmarks

網站管理員書籤表單被正確建立

admin_tree

網站管理表單被正確建立

blog_menu

部落格選單表單被正確建立

blog_tags

部落格標籤表單被正確建立

calendar_month

行事曆表單被正確建立

calendar_upcoming

即將來臨的事件表單被正確建立

course_list

課程表單被正確建立

course_summary

課程/網站描述表單被正確建立

glossary_random

智慧小語表單被正確建立

html

HTML表單被正確建立

loancalc

貸款計算者表單被正確建立

login

登入表單被正確建立

mentees

Mentees表單被正確建立

messages

簡訊表單被正確建立

mnet_hosts

網路伺服主機表單被正確建立

news_items

最新訊息表單被正確建立

online_users

線上使用者表單被正確建立

participants

使用者表單被正確建立

quiz_results

測驗成績表單被正確建立

recent_activity

最近活動紀錄表單被正確建立

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) )  
成功

(mysql): ALTER TABLE mdl_block_rss_client COMMENT='Remote news feed information. Contains the news feed id, the'  
成功
遠端的RSS彙集表單被正確建立

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) )  
成功

(mysql): ALTER TABLE mdl_block_search_documents COMMENT='table to store search index backups'  
成功

(mysql): CREATE INDEX mdl_blocseardocu_doc_ix ON mdl_block_search_documents (docid)  
成功

(mysql): CREATE INDEX mdl_blocseardocu_doc2_ix ON mdl_block_search_documents (doctype)  
成功

(mysql): CREATE INDEX mdl_blocseardocu_ite_ix ON mdl_block_search_documents (itemtype)  
成功
全站搜尋表單被正確建立

search_forums

搜尋討論區表單被正確建立

section_links

文章連結表單被正確建立

site_main_menu

主選單表單被正確建立

social_activities

社交活動表單被正確建立

tag_flickr

Flickr表單被正確建立

tag_youtube

Youtube表單被正確建立

tags

標籤表單被正確建立

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) )  
成功

(mysql): ALTER TABLE mdl_enrol_authorize COMMENT='Holds all known information about authorize.net transactions'  
成功

(mysql): CREATE INDEX mdl_enroauth_cou_ix ON mdl_enrol_authorize (courseid)  
成功

(mysql): CREATE INDEX mdl_enroauth_use_ix ON mdl_enrol_authorize (userid)  
成功

(mysql): CREATE INDEX mdl_enroauth_sta_ix ON mdl_enrol_authorize (status)  
成功

(mysql): CREATE INDEX mdl_enroauth_tra_ix ON mdl_enrol_authorize (transid)  
成功

(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) )  
成功

(mysql): ALTER TABLE mdl_enrol_authorize_refunds COMMENT='Authorize.net refunds'  
成功

(mysql): CREATE INDEX mdl_enroauthrefu_tra_ix ON mdl_enrol_authorize_refunds (transid)  
成功

(mysql): CREATE INDEX mdl_enroauthrefu_ord_ix ON mdl_enrol_authorize_refunds (orderid)  
成功
authorize 資料表已經正確設定了

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) )  
成功

(mysql): ALTER TABLE mdl_enrol_paypal COMMENT='Holds all known information about PayPal transactions'  
成功
paypal 資料表已經正確設定了

grade/export/ods plugin needs upgrading

ods 資料表已經正確設定了

grade/export/txt plugin needs upgrading

txt 資料表已經正確設定了

grade/export/xls plugin needs upgrading

xls 資料表已經正確設定了

grade/export/xml plugin needs upgrading

xml 資料表已經正確設定了

grade/import/csv plugin needs upgrading

csv 資料表已經正確設定了

grade/import/xml plugin needs upgrading

xml 資料表已經正確設定了

grade/report/grader plugin needs upgrading

grader 資料表已經正確設定了

grade/report/outcomes plugin needs upgrading

outcomes 資料表已經正確設定了

grade/report/overview plugin needs upgrading

overview 資料表已經正確設定了

grade/report/user plugin needs upgrading

user 資料表已經正確設定了

course/report/log plugin needs upgrading

log 資料表已經正確設定了

course/report/outline plugin needs upgrading

outline 資料表已經正確設定了

course/report/participation plugin needs upgrading

participation 資料表已經正確設定了

course/report/stats plugin needs upgrading

stats 資料表已經正確設定了

admin/report/courseoverview plugin needs upgrading

courseoverview 資料表已經正確設定了

admin/report/security plugin needs upgrading

security 資料表已經正確設定了

admin/report/unittest plugin needs upgrading

unittest 資料表已經正確設定了