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 資料表已經正確設定了