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