(mysql): SHOW TABLES

(mysql): SHOW VARIABLES LIKE 'character_set_database'

(mysql): SET NAMES 'utf8'

(mysql): SHOW VARIABLES LIKE 'character_set_database'

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_config ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', value TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_config COMMENT='Moodle configuration variables'

Success

(mysql): CREATE UNIQUE INDEX mdl_conf_nam_uix ON mdl_config (name)

Success

(mysql): CREATE TABLE mdl_config_plugins ( id BIGINT(10) unsigned NOT NULL auto_increment, plugin VARCHAR(100) NOT NULL DEFAULT 'core', name VARCHAR(100) NOT NULL DEFAULT '', value TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_config_plugins COMMENT='Moodle modules and plugins configuration variables'

Success

(mysql): CREATE UNIQUE INDEX mdl_confplug_plunam_uix ON mdl_config_plugins (plugin, name)

Success

(mysql): CREATE TABLE mdl_course ( id BIGINT(10) unsigned NOT NULL auto_increment, category BIGINT(10) unsigned NOT NULL DEFAULT 0, sortorder BIGINT(10) unsigned NOT NULL DEFAULT 0, password VARCHAR(50) NOT NULL DEFAULT '', fullname VARCHAR(254) NOT NULL DEFAULT '', shortname VARCHAR(100) NOT NULL DEFAULT '', idnumber VARCHAR(100) NOT NULL DEFAULT '', summary TEXT NOT NULL, format VARCHAR(10) NOT NULL DEFAULT 'topics', showgrades TINYINT(2) unsigned NOT NULL DEFAULT 1, modinfo LONGTEXT, newsitems MEDIUMINT(5) unsigned NOT NULL DEFAULT 1, teacher VARCHAR(100) NOT NULL DEFAULT 'Teacher', teachers VARCHAR(100) NOT NULL DEFAULT 'Teachers', student VARCHAR(100) NOT NULL DEFAULT 'Student', students VARCHAR(100) NOT NULL DEFAULT 'Students', guest TINYINT(2) unsigned NOT NULL DEFAULT 0, startdate BIGINT(10) unsigned NOT NULL DEFAULT 0, enrolperiod BIGINT(10) unsigned NOT NULL DEFAULT 0, numsections MEDIUMINT(5) unsigned NOT NULL DEFAULT 1, marker BIGINT(10) unsigned NOT NULL DEFAULT 0, maxbytes BIGINT(10) unsigned NOT NULL DEFAULT 0, showreports SMALLINT(4) unsigned NOT NULL DEFAULT 0, visible TINYINT(1) unsigned NOT NULL DEFAULT 1, hiddensections TINYINT(2) unsigned NOT NULL DEFAULT 0, groupmode SMALLINT(4) unsigned NOT NULL DEFAULT 0, groupmodeforce SMALLINT(4) unsigned NOT NULL DEFAULT 0, lang VARCHAR(30) NOT NULL DEFAULT '', theme VARCHAR(50) NOT NULL DEFAULT '', cost VARCHAR(10) NOT NULL DEFAULT '', currency VARCHAR(3) NOT NULL DEFAULT 'USD', timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, metacourse TINYINT(1) unsigned NOT NULL DEFAULT 0, requested TINYINT(1) unsigned NOT NULL DEFAULT 0, restrictmodules TINYINT(1) unsigned NOT NULL DEFAULT 0, expirynotify TINYINT(1) unsigned NOT NULL DEFAULT 0, expirythreshold BIGINT(10) unsigned NOT NULL DEFAULT 0, notifystudents TINYINT(1) unsigned NOT NULL DEFAULT 0, enrollable TINYINT(1) unsigned NOT NULL DEFAULT 1, enrolstartdate BIGINT(10) unsigned NOT NULL DEFAULT 0, enrolenddate BIGINT(10) unsigned NOT NULL DEFAULT 0, enrol VARCHAR(20) NOT NULL DEFAULT '', defaultrole BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_course COMMENT='Central course table'

Success

(mysql): CREATE INDEX mdl_cour_cat_ix ON mdl_course (category)

Success

(mysql): CREATE INDEX mdl_cour_idn_ix ON mdl_course (idnumber)

Success

(mysql): CREATE INDEX mdl_cour_sho_ix ON mdl_course (shortname)

Success

(mysql): CREATE TABLE mdl_course_categories ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT, parent BIGINT(10) unsigned NOT NULL DEFAULT 0, sortorder BIGINT(10) unsigned NOT NULL DEFAULT 0, coursecount BIGINT(10) unsigned NOT NULL DEFAULT 0, visible TINYINT(1) NOT NULL DEFAULT 1, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, depth BIGINT(10) unsigned NOT NULL DEFAULT 0, path VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_course_categories COMMENT='Course categories'

Success

(mysql): CREATE INDEX mdl_courcate_par_ix ON mdl_course_categories (parent)

Success

(mysql): CREATE TABLE mdl_course_display ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, display BIGINT(10) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_course_display COMMENT='Stores info about how to display the course'

Success

(mysql): CREATE INDEX mdl_courdisp_couuse_ix ON mdl_course_display (course, userid)

Success

(mysql): CREATE TABLE mdl_course_meta ( id BIGINT(10) unsigned NOT NULL auto_increment, parent_course BIGINT(10) unsigned NOT NULL DEFAULT 0, child_course BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_course_meta COMMENT='to store meta-courses relations'

Success

(mysql): CREATE INDEX mdl_courmeta_par_ix ON mdl_course_meta (parent_course)

Success

(mysql): CREATE INDEX mdl_courmeta_chi_ix ON mdl_course_meta (child_course)

Success

(mysql): CREATE TABLE mdl_course_modules ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, module BIGINT(10) unsigned NOT NULL DEFAULT 0, instance BIGINT(10) unsigned NOT NULL DEFAULT 0, section BIGINT(10) unsigned NOT NULL DEFAULT 0, added BIGINT(10) unsigned NOT NULL DEFAULT 0, score SMALLINT(4) NOT NULL DEFAULT 0, indent MEDIUMINT(5) unsigned NOT NULL DEFAULT 0, visible TINYINT(1) NOT NULL DEFAULT 1, visibleold TINYINT(1) NOT NULL DEFAULT 1, groupmode SMALLINT(4) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_course_modules COMMENT='course_modules table retrofitted from MySQL'

Success

(mysql): CREATE INDEX mdl_courmodu_vis_ix ON mdl_course_modules (visible)

Success

(mysql): CREATE INDEX mdl_courmodu_cou_ix ON mdl_course_modules (course)

Success

(mysql): CREATE INDEX mdl_courmodu_mod_ix ON mdl_course_modules (module)

Success

(mysql): CREATE INDEX mdl_courmodu_ins_ix ON mdl_course_modules (instance)

Success

(mysql): CREATE TABLE mdl_course_sections ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, section BIGINT(10) unsigned NOT NULL DEFAULT 0, summary TEXT, sequence TEXT, visible TINYINT(1) NOT NULL DEFAULT 1, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_course_sections COMMENT='to define the sections for each course'

Success

(mysql): CREATE INDEX mdl_coursect_cousec_ix ON mdl_course_sections (course, section)

Success

(mysql): CREATE TABLE mdl_course_request ( id BIGINT(10) unsigned NOT NULL auto_increment, fullname VARCHAR(254) NOT NULL DEFAULT '', shortname VARCHAR(15) NOT NULL DEFAULT '', summary TEXT NOT NULL, reason TEXT NOT NULL, requester BIGINT(10) NOT NULL DEFAULT 0, password VARCHAR(50) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_course_request COMMENT='course requests'

Success

(mysql): CREATE INDEX mdl_courrequ_sho_ix ON mdl_course_request (shortname)

Success

(mysql): CREATE TABLE mdl_course_allowed_modules ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, module BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_course_allowed_modules COMMENT='allowed modules foreach course'

Success

(mysql): CREATE INDEX mdl_courallomodu_cou_ix ON mdl_course_allowed_modules (course)

Success

(mysql): CREATE INDEX mdl_courallomodu_mod_ix ON mdl_course_allowed_modules (module)

Success

(mysql): CREATE TABLE mdl_event ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NOT NULL, format SMALLINT(4) unsigned NOT NULL DEFAULT 0, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, repeatid BIGINT(10) unsigned NOT NULL DEFAULT 0, modulename VARCHAR(20) NOT NULL DEFAULT '', instance BIGINT(10) unsigned NOT NULL DEFAULT 0, eventtype VARCHAR(20) NOT NULL DEFAULT '', timestart BIGINT(10) unsigned NOT NULL DEFAULT 0, timeduration BIGINT(10) unsigned NOT NULL DEFAULT 0, visible SMALLINT(4) NOT NULL DEFAULT 1, uuid VARCHAR(36) NOT NULL DEFAULT '', sequence BIGINT(10) unsigned NOT NULL DEFAULT 1, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_event COMMENT='For everything with a time associated to it'

Success

(mysql): CREATE INDEX mdl_even_cou_ix ON mdl_event (courseid)

Success

(mysql): CREATE INDEX mdl_even_use_ix ON mdl_event (userid)

Success

(mysql): CREATE INDEX mdl_even_tim_ix ON mdl_event (timestart)

Success

(mysql): CREATE INDEX mdl_even_tim2_ix ON mdl_event (timeduration)

Success

(mysql): CREATE TABLE mdl_cache_filters ( id BIGINT(10) unsigned NOT NULL auto_increment, filter VARCHAR(32) NOT NULL DEFAULT '', version BIGINT(10) unsigned NOT NULL DEFAULT 0, md5key VARCHAR(32) NOT NULL DEFAULT '', rawtext TEXT NOT NULL, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_cache_filters COMMENT='For keeping information about cached data'

Success

(mysql): CREATE INDEX mdl_cachfilt_filmd5_ix ON mdl_cache_filters (filter, md5key)

Success

(mysql): CREATE TABLE mdl_cache_text ( id BIGINT(10) unsigned NOT NULL auto_increment, md5key VARCHAR(32) NOT NULL DEFAULT '', formattedtext LONGTEXT NOT NULL, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_cache_text COMMENT='For storing temporary copies of processed texts'

Success

(mysql): CREATE INDEX mdl_cachtext_md5_ix ON mdl_cache_text (md5key)

Success

(mysql): CREATE TABLE mdl_grade_category ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(64) NOT NULL DEFAULT '', courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, drop_x_lowest BIGINT(10) unsigned NOT NULL DEFAULT 0, bonus_points BIGINT(10) unsigned NOT NULL DEFAULT 0, hidden BIGINT(10) unsigned NOT NULL DEFAULT 0, weight NUMERIC(5,2) NOT NULL DEFAULT 0.00, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_grade_category COMMENT='to define categories to group activity grades'

Success

(mysql): CREATE INDEX mdl_gradcate_cou_ix ON mdl_grade_category (courseid)

Success

(mysql): CREATE TABLE mdl_grade_exceptions ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, grade_itemid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_grade_exceptions COMMENT='individual grades to be skipped for certain students'

Success

(mysql): CREATE INDEX mdl_gradexce_cou_ix ON mdl_grade_exceptions (courseid)

Success

(mysql): CREATE TABLE mdl_grade_item ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, category BIGINT(10) unsigned NOT NULL DEFAULT 0, modid BIGINT(10) unsigned NOT NULL DEFAULT 0, cminstance BIGINT(10) unsigned NOT NULL DEFAULT 0, scale_grade DOUBLE(11,10) NOT NULL DEFAULT 1.0000000000, extra_credit BIGINT(10) unsigned NOT NULL DEFAULT 0, sort_order BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_grade_item COMMENT='items to be graded'

Success

(mysql): CREATE INDEX mdl_graditem_cou_ix ON mdl_grade_item (courseid)

Success

(mysql): CREATE TABLE mdl_grade_letter ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, letter VARCHAR(8) NOT NULL DEFAULT 'NA', grade_high NUMERIC(5,2) NOT NULL DEFAULT 100.00, grade_low NUMERIC(5,2) NOT NULL DEFAULT 0.00, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_grade_letter COMMENT='to convert numerical grades to letter grades'

Success

(mysql): CREATE INDEX mdl_gradlett_cou_ix ON mdl_grade_letter (courseid)

Success

(mysql): CREATE TABLE mdl_grade_preferences ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, preference BIGINT(10) NOT NULL DEFAULT 0, value BIGINT(10) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_grade_preferences COMMENT='Preferences of the gradebook for each course'

Success

(mysql): CREATE UNIQUE INDEX mdl_gradpref_coupre_uix ON mdl_grade_preferences (courseid, preference)

Success

(mysql): CREATE TABLE mdl_log ( id BIGINT(10) unsigned NOT NULL auto_increment, time BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, ip VARCHAR(15) NOT NULL DEFAULT '', course BIGINT(10) unsigned NOT NULL DEFAULT 0, module VARCHAR(20) NOT NULL DEFAULT '', cmid BIGINT(10) unsigned NOT NULL DEFAULT 0, action VARCHAR(40) NOT NULL DEFAULT '', url VARCHAR(100) NOT NULL DEFAULT '', info VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_log COMMENT='Every action is logged as far as possible'

Success

(mysql): CREATE INDEX mdl_log_timcoumodact_ix ON mdl_log (time, course, module, action)

Success

(mysql): CREATE INDEX mdl_log_coumodact_ix ON mdl_log (course, module, action)

Success

(mysql): CREATE INDEX mdl_log_couuse_ix ON mdl_log (course, userid)

Success

(mysql): CREATE INDEX mdl_log_use_ix ON mdl_log (userid)

Success

(mysql): CREATE INDEX mdl_log_inf_ix ON mdl_log (info)

Success

(mysql): CREATE TABLE mdl_log_display ( id BIGINT(10) unsigned NOT NULL auto_increment, module VARCHAR(20) NOT NULL DEFAULT '', action VARCHAR(40) NOT NULL DEFAULT '', mtable VARCHAR(30) NOT NULL DEFAULT '', field VARCHAR(200) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_log_display COMMENT='For a particular module/action, specifies a moodle table/fie'

Success

(mysql): CREATE UNIQUE INDEX mdl_logdisp_modact_uix ON mdl_log_display (module, action)

Success

(mysql): CREATE TABLE mdl_message ( id BIGINT(10) unsigned NOT NULL auto_increment, useridfrom BIGINT(10) NOT NULL DEFAULT 0, useridto BIGINT(10) NOT NULL DEFAULT 0, message TEXT NOT NULL, format SMALLINT(4) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) NOT NULL DEFAULT 0, messagetype VARCHAR(50) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_message COMMENT='Stores all unread messages'

Success

(mysql): CREATE INDEX mdl_mess_use_ix ON mdl_message (useridfrom)

Success

(mysql): CREATE INDEX mdl_mess_use2_ix ON mdl_message (useridto)

Success

(mysql): CREATE TABLE mdl_message_read ( id BIGINT(10) unsigned NOT NULL auto_increment, useridfrom BIGINT(10) NOT NULL DEFAULT 0, useridto BIGINT(10) NOT NULL DEFAULT 0, message TEXT NOT NULL, format SMALLINT(4) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) NOT NULL DEFAULT 0, timeread BIGINT(10) NOT NULL DEFAULT 0, messagetype VARCHAR(50) NOT NULL DEFAULT '', mailed TINYINT(1) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_message_read COMMENT='Stores all messages that have been read'

Success

(mysql): CREATE INDEX mdl_messread_use_ix ON mdl_message_read (useridfrom)

Success

(mysql): CREATE INDEX mdl_messread_use2_ix ON mdl_message_read (useridto)

Success

(mysql): CREATE TABLE mdl_message_contacts ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, contactid BIGINT(10) unsigned NOT NULL DEFAULT 0, blocked TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_message_contacts COMMENT='Maintains lists of relationships between users'

Success

(mysql): CREATE UNIQUE INDEX mdl_messcont_usecon_uix ON mdl_message_contacts (userid, contactid)

Success

(mysql): CREATE TABLE mdl_modules ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(20) NOT NULL DEFAULT '', version BIGINT(10) NOT NULL DEFAULT 0, cron BIGINT(10) unsigned NOT NULL DEFAULT 0, lastcron BIGINT(10) unsigned NOT NULL DEFAULT 0, search VARCHAR(255) NOT NULL DEFAULT '', visible TINYINT(1) NOT NULL DEFAULT 1, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_modules COMMENT='modules available in the site'

Success

(mysql): CREATE INDEX mdl_modu_nam_ix ON mdl_modules (name)

Success

(mysql): CREATE TABLE mdl_scale ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', scale TEXT NOT NULL, description TEXT NOT NULL, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_scale COMMENT='Defines grading scales'

Success

(mysql): CREATE INDEX mdl_scal_cou_ix ON mdl_scale (courseid)

Success

(mysql): CREATE TABLE mdl_sessions2 ( sesskey VARCHAR(64) NOT NULL DEFAULT '', expiry DATETIME NOT NULL, expireref VARCHAR(250) DEFAULT '', created DATETIME NOT NULL, modified DATETIME NOT NULL, sessdata LONGTEXT, CONSTRAINT PRIMARY KEY (sesskey) )

Success

(mysql): ALTER TABLE mdl_sessions2 COMMENT='Optional database session storage in new format, not used by'

Success

(mysql): CREATE INDEX mdl_sess_exp_ix ON mdl_sessions2 (expiry)

Success

(mysql): CREATE INDEX mdl_sess_exp2_ix ON mdl_sessions2 (expireref)

Success

(mysql): CREATE TABLE adodb_logsql ( id BIGINT(10) unsigned NOT NULL auto_increment, created DATETIME NOT NULL, sql0 VARCHAR(250) NOT NULL DEFAULT '', sql1 TEXT, params TEXT, tracer TEXT, timer NUMERIC(16,6) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE adodb_logsql COMMENT='to save some logs from ADOdb'

Success

(mysql): CREATE TABLE mdl_timezone ( id BIGINT(10) NOT NULL auto_increment, name VARCHAR(100) NOT NULL DEFAULT '', year BIGINT(11) NOT NULL DEFAULT 0, tzrule VARCHAR(20) NOT NULL DEFAULT '', gmtoff BIGINT(11) NOT NULL DEFAULT 0, dstoff BIGINT(11) NOT NULL DEFAULT 0, dst_month TINYINT(2) NOT NULL DEFAULT 0, dst_startday SMALLINT(3) NOT NULL DEFAULT 0, dst_weekday SMALLINT(3) NOT NULL DEFAULT 0, dst_skipweeks SMALLINT(3) NOT NULL DEFAULT 0, dst_time VARCHAR(5) NOT NULL DEFAULT '00:00', std_month TINYINT(2) NOT NULL DEFAULT 0, std_startday SMALLINT(3) NOT NULL DEFAULT 0, std_weekday SMALLINT(3) NOT NULL DEFAULT 0, std_skipweeks SMALLINT(3) NOT NULL DEFAULT 0, std_time VARCHAR(5) NOT NULL DEFAULT '00:00', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_timezone COMMENT='Rules for calculating local wall clock time for users'

Success

(mysql): CREATE TABLE mdl_user ( id BIGINT(10) unsigned NOT NULL auto_increment, auth VARCHAR(20) NOT NULL DEFAULT 'manual', confirmed TINYINT(1) NOT NULL DEFAULT 0, policyagreed TINYINT(1) NOT NULL DEFAULT 0, deleted TINYINT(1) NOT NULL DEFAULT 0, mnethostid BIGINT(10) NOT NULL DEFAULT 0, username VARCHAR(100) NOT NULL DEFAULT '', password VARCHAR(32) NOT NULL DEFAULT '', idnumber VARCHAR(64) NOT NULL DEFAULT '', firstname VARCHAR(100) NOT NULL DEFAULT '', lastname VARCHAR(100) NOT NULL DEFAULT '', email VARCHAR(100) NOT NULL DEFAULT '', emailstop TINYINT(1) unsigned NOT NULL DEFAULT 0, icq VARCHAR(15) NOT NULL DEFAULT '', skype VARCHAR(50) NOT NULL DEFAULT '', yahoo VARCHAR(50) NOT NULL DEFAULT '', aim VARCHAR(50) NOT NULL DEFAULT '', msn VARCHAR(50) NOT NULL DEFAULT '', phone1 VARCHAR(20) NOT NULL DEFAULT '', phone2 VARCHAR(20) NOT NULL DEFAULT '', institution VARCHAR(40) NOT NULL DEFAULT '', department VARCHAR(30) NOT NULL DEFAULT '', address VARCHAR(70) NOT NULL DEFAULT '', city VARCHAR(20) NOT NULL DEFAULT '', country VARCHAR(2) NOT NULL DEFAULT '', lang VARCHAR(30) NOT NULL DEFAULT 'en', theme VARCHAR(50) NOT NULL DEFAULT '', timezone VARCHAR(100) NOT NULL DEFAULT '99', firstaccess BIGINT(10) unsigned NOT NULL DEFAULT 0, lastaccess BIGINT(10) unsigned NOT NULL DEFAULT 0, lastlogin BIGINT(10) unsigned NOT NULL DEFAULT 0, currentlogin BIGINT(10) unsigned NOT NULL DEFAULT 0, lastip VARCHAR(15) NOT NULL DEFAULT '', secret VARCHAR(15) NOT NULL DEFAULT '', picture TINYINT(1) NOT NULL DEFAULT 0, url VARCHAR(255) NOT NULL DEFAULT '', description TEXT, mailformat TINYINT(1) unsigned NOT NULL DEFAULT 1, maildigest TINYINT(1) unsigned NOT NULL DEFAULT 0, maildisplay TINYINT(2) unsigned NOT NULL DEFAULT 2, htmleditor TINYINT(1) unsigned NOT NULL DEFAULT 1, ajax TINYINT(1) unsigned NOT NULL DEFAULT 1, autosubscribe TINYINT(1) unsigned NOT NULL DEFAULT 1, trackforums TINYINT(1) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, trustbitmask BIGINT(10) unsigned NOT NULL DEFAULT 0, imagealt VARCHAR(255) DEFAULT NULL, screenreader TINYINT(1) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_user COMMENT='One record for each person'

Success

(mysql): CREATE UNIQUE INDEX mdl_user_mneuse_uix ON mdl_user (mnethostid, username)

Success

(mysql): CREATE INDEX mdl_user_del_ix ON mdl_user (deleted)

Success

(mysql): CREATE INDEX mdl_user_con_ix ON mdl_user (confirmed)

Success

(mysql): CREATE INDEX mdl_user_fir_ix ON mdl_user (firstname)

Success

(mysql): CREATE INDEX mdl_user_las_ix ON mdl_user (lastname)

Success

(mysql): CREATE INDEX mdl_user_cit_ix ON mdl_user (city)

Success

(mysql): CREATE INDEX mdl_user_cou_ix ON mdl_user (country)

Success

(mysql): CREATE INDEX mdl_user_las2_ix ON mdl_user (lastaccess)

Success

(mysql): CREATE INDEX mdl_user_ema_ix ON mdl_user (email)

Success

(mysql): CREATE INDEX mdl_user_aut_ix ON mdl_user (auth)

Success

(mysql): CREATE INDEX mdl_user_idn_ix ON mdl_user (idnumber)

Success

(mysql): CREATE TABLE mdl_user_preferences ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(50) NOT NULL DEFAULT '', value VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_user_preferences COMMENT='Allows modules to store arbitrary user preferences'

Success

(mysql): CREATE UNIQUE INDEX mdl_userpref_usenam_uix ON mdl_user_preferences (userid, name)

Success

(mysql): CREATE TABLE mdl_user_lastaccess ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, timeaccess BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_user_lastaccess COMMENT='To keep track of course page access times, used in online pa'

Success

(mysql): CREATE UNIQUE INDEX mdl_userlast_usecou_uix ON mdl_user_lastaccess (userid, courseid)

Success

(mysql): CREATE INDEX mdl_userlast_use_ix ON mdl_user_lastaccess (userid)

Success

(mysql): CREATE INDEX mdl_userlast_cou_ix ON mdl_user_lastaccess (courseid)

Success

(mysql): CREATE TABLE mdl_stats_daily ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, timeend BIGINT(10) unsigned NOT NULL DEFAULT 0, roleid BIGINT(10) unsigned NOT NULL DEFAULT 0, stattype enum('enrolments', 'activity', 'logins') NOT NULL DEFAULT 'activity', stat1 BIGINT(10) unsigned NOT NULL DEFAULT 0, stat2 BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_stats_daily COMMENT='to accumulate daily stats'

Success

(mysql): CREATE INDEX mdl_statdail_cou_ix ON mdl_stats_daily (courseid)

Success

(mysql): CREATE INDEX mdl_statdail_tim_ix ON mdl_stats_daily (timeend)

Success

(mysql): CREATE INDEX mdl_statdail_rol_ix ON mdl_stats_daily (roleid)

Success

(mysql): CREATE TABLE mdl_stats_weekly ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, timeend BIGINT(10) unsigned NOT NULL DEFAULT 0, roleid BIGINT(10) unsigned NOT NULL DEFAULT 0, stattype enum('enrolments', 'activity', 'logins') NOT NULL DEFAULT 'activity', stat1 BIGINT(10) unsigned NOT NULL DEFAULT 0, stat2 BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_stats_weekly COMMENT='To accumulate weekly stats'

Success

(mysql): CREATE INDEX mdl_statweek_cou_ix ON mdl_stats_weekly (courseid)

Success

(mysql): CREATE INDEX mdl_statweek_tim_ix ON mdl_stats_weekly (timeend)

Success

(mysql): CREATE INDEX mdl_statweek_rol_ix ON mdl_stats_weekly (roleid)

Success

(mysql): CREATE TABLE mdl_stats_monthly ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, timeend BIGINT(10) unsigned NOT NULL DEFAULT 0, roleid BIGINT(10) unsigned NOT NULL DEFAULT 0, stattype enum('enrolments', 'activity', 'logins') NOT NULL DEFAULT 'activity', stat1 BIGINT(10) unsigned NOT NULL DEFAULT 0, stat2 BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_stats_monthly COMMENT='To accumulate monthly stats'

Success

(mysql): CREATE INDEX mdl_statmont_cou_ix ON mdl_stats_monthly (courseid)

Success

(mysql): CREATE INDEX mdl_statmont_tim_ix ON mdl_stats_monthly (timeend)

Success

(mysql): CREATE INDEX mdl_statmont_rol_ix ON mdl_stats_monthly (roleid)

Success

(mysql): CREATE TABLE mdl_stats_user_daily ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, roleid BIGINT(10) unsigned NOT NULL DEFAULT 0, timeend BIGINT(10) unsigned NOT NULL DEFAULT 0, statsreads BIGINT(10) unsigned NOT NULL DEFAULT 0, statswrites BIGINT(10) unsigned NOT NULL DEFAULT 0, stattype VARCHAR(30) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_stats_user_daily COMMENT='To accumulate daily stats per course/user'

Success

(mysql): CREATE INDEX mdl_statuserdail_cou_ix ON mdl_stats_user_daily (courseid)

Success

(mysql): CREATE INDEX mdl_statuserdail_use_ix ON mdl_stats_user_daily (userid)

Success

(mysql): CREATE INDEX mdl_statuserdail_rol_ix ON mdl_stats_user_daily (roleid)

Success

(mysql): CREATE INDEX mdl_statuserdail_tim_ix ON mdl_stats_user_daily (timeend)

Success

(mysql): CREATE TABLE mdl_stats_user_weekly ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, roleid BIGINT(10) unsigned NOT NULL DEFAULT 0, timeend BIGINT(10) unsigned NOT NULL DEFAULT 0, statsreads BIGINT(10) unsigned NOT NULL DEFAULT 0, statswrites BIGINT(10) unsigned NOT NULL DEFAULT 0, stattype VARCHAR(30) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_stats_user_weekly COMMENT='To accumulate weekly stats per course/user'

Success

(mysql): CREATE INDEX mdl_statuserweek_cou_ix ON mdl_stats_user_weekly (courseid)

Success

(mysql): CREATE INDEX mdl_statuserweek_use_ix ON mdl_stats_user_weekly (userid)

Success

(mysql): CREATE INDEX mdl_statuserweek_rol_ix ON mdl_stats_user_weekly (roleid)

Success

(mysql): CREATE INDEX mdl_statuserweek_tim_ix ON mdl_stats_user_weekly (timeend)

Success

(mysql): CREATE TABLE mdl_stats_user_monthly ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, roleid BIGINT(10) unsigned NOT NULL DEFAULT 0, timeend BIGINT(10) unsigned NOT NULL DEFAULT 0, statsreads BIGINT(10) unsigned NOT NULL DEFAULT 0, statswrites BIGINT(10) unsigned NOT NULL DEFAULT 0, stattype VARCHAR(30) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_stats_user_monthly COMMENT='To accumulate monthly stats per course/user'

Success

(mysql): CREATE INDEX mdl_statusermont_cou_ix ON mdl_stats_user_monthly (courseid)

Success

(mysql): CREATE INDEX mdl_statusermont_use_ix ON mdl_stats_user_monthly (userid)

Success

(mysql): CREATE INDEX mdl_statusermont_rol_ix ON mdl_stats_user_monthly (roleid)

Success

(mysql): CREATE INDEX mdl_statusermont_tim_ix ON mdl_stats_user_monthly (timeend)

Success

(mysql): CREATE TABLE mdl_post ( id BIGINT(10) NOT NULL auto_increment, module VARCHAR(20) NOT NULL DEFAULT '', userid BIGINT(10) unsigned NOT NULL DEFAULT 0, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupid BIGINT(10) unsigned NOT NULL DEFAULT 0, moduleid BIGINT(10) unsigned NOT NULL DEFAULT 0, coursemoduleid BIGINT(10) unsigned NOT NULL DEFAULT 0, subject VARCHAR(128) NOT NULL DEFAULT '', summary LONGTEXT, content LONGTEXT, uniquehash VARCHAR(128) NOT NULL DEFAULT '', rating BIGINT(10) unsigned NOT NULL DEFAULT 0, format BIGINT(10) unsigned NOT NULL DEFAULT 0, attachment VARCHAR(100) DEFAULT NULL, publishstate enum('draft', 'site', 'public') NOT NULL DEFAULT 'draft', lastmodified BIGINT(10) unsigned NOT NULL DEFAULT 0, created BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_post COMMENT='Generic post table to hold data blog entries etc in differen'

Success

(mysql): CREATE UNIQUE INDEX mdl_post_iduse_uix ON mdl_post (id, userid)

Success

(mysql): CREATE INDEX mdl_post_las_ix ON mdl_post (lastmodified)

Success

(mysql): CREATE INDEX mdl_post_mod_ix ON mdl_post (module)

Success

(mysql): CREATE INDEX mdl_post_sub_ix ON mdl_post (subject)

Success

(mysql): CREATE TABLE mdl_tags ( id BIGINT(10) unsigned NOT NULL auto_increment, type VARCHAR(255) NOT NULL DEFAULT 'official', userid BIGINT(10) unsigned NOT NULL DEFAULT 0, text VARCHAR(20) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_tags COMMENT='tags structure for moodle'

Success

(mysql): CREATE INDEX mdl_tags_typuse_ix ON mdl_tags (type, userid)

Success

(mysql): CREATE INDEX mdl_tags_tex_ix ON mdl_tags (text)

Success

(mysql): CREATE TABLE mdl_blog_tag_instance ( id BIGINT(10) unsigned NOT NULL auto_increment, entryid BIGINT(10) unsigned NOT NULL DEFAULT 0, tagid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupid BIGINT(10) unsigned NOT NULL DEFAULT 0, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_blog_tag_instance COMMENT='tag instance for blogs'

Success

(mysql): CREATE INDEX mdl_blogtaginst_ent_ix ON mdl_blog_tag_instance (entryid)

Success

(mysql): CREATE INDEX mdl_blogtaginst_tag_ix ON mdl_blog_tag_instance (tagid)

Success

(mysql): CREATE TABLE mdl_role ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', shortname VARCHAR(100) NOT NULL DEFAULT '', description TEXT NOT NULL, sortorder BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_role COMMENT='moodle roles'

Success

(mysql): CREATE UNIQUE INDEX mdl_role_sor_uix ON mdl_role (sortorder)

Success

(mysql): CREATE TABLE mdl_context ( id BIGINT(10) unsigned NOT NULL auto_increment, contextlevel BIGINT(10) unsigned NOT NULL DEFAULT 0, instanceid BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_context COMMENT='one of these must be set'

Success

(mysql): CREATE UNIQUE INDEX mdl_cont_conins_uix ON mdl_context (contextlevel, instanceid)

Success

(mysql): CREATE INDEX mdl_cont_ins_ix ON mdl_context (instanceid)

Success

(mysql): CREATE TABLE mdl_context_rel ( id BIGINT(10) NOT NULL auto_increment, c1 BIGINT(10) DEFAULT NULL, c2 BIGINT(10) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_context_rel COMMENT='context relations, c2 is a parent (or higher) of c1'

Success

(mysql): CREATE INDEX mdl_contrel_c1_ix ON mdl_context_rel (c1)

Success

(mysql): CREATE INDEX mdl_contrel_c2_ix ON mdl_context_rel (c2)

Success

(mysql): CREATE UNIQUE INDEX mdl_contrel_c1c2_uix ON mdl_context_rel (c1, c2)

Success

(mysql): CREATE TABLE mdl_capabilities ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', captype VARCHAR(50) NOT NULL DEFAULT '', contextlevel BIGINT(10) unsigned NOT NULL DEFAULT 0, component VARCHAR(100) NOT NULL DEFAULT '', riskbitmask BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_capabilities COMMENT='this defines all capabilities'

Success

(mysql): CREATE UNIQUE INDEX mdl_capa_nam_uix ON mdl_capabilities (name)

Success

(mysql): CREATE TABLE mdl_role_allow_assign ( id BIGINT(10) unsigned NOT NULL auto_increment, roleid BIGINT(10) unsigned NOT NULL DEFAULT 0, allowassign BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_role_allow_assign COMMENT='this defines what role can assign what role'

Success

(mysql): CREATE UNIQUE INDEX mdl_rolealloassi_rolall_uix ON mdl_role_allow_assign (roleid, allowassign)

Success

(mysql): CREATE INDEX mdl_rolealloassi_rol_ix ON mdl_role_allow_assign (roleid)

Success

(mysql): CREATE INDEX mdl_rolealloassi_all_ix ON mdl_role_allow_assign (allowassign)

Success

(mysql): CREATE TABLE mdl_role_allow_override ( id BIGINT(10) unsigned NOT NULL auto_increment, roleid BIGINT(10) unsigned NOT NULL DEFAULT 0, allowoverride BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_role_allow_override COMMENT='this defines what role can override what role'

Success

(mysql): CREATE UNIQUE INDEX mdl_rolealloover_rolall_uix ON mdl_role_allow_override (roleid, allowoverride)

Success

(mysql): CREATE INDEX mdl_rolealloover_rol_ix ON mdl_role_allow_override (roleid)

Success

(mysql): CREATE INDEX mdl_rolealloover_all_ix ON mdl_role_allow_override (allowoverride)

Success

(mysql): CREATE TABLE mdl_role_assignments ( id BIGINT(10) unsigned NOT NULL auto_increment, roleid BIGINT(10) unsigned NOT NULL DEFAULT 0, contextid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, hidden TINYINT(1) unsigned NOT NULL DEFAULT 0, timestart BIGINT(10) unsigned NOT NULL DEFAULT 0, timeend BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, modifierid BIGINT(10) unsigned NOT NULL DEFAULT 0, enrol VARCHAR(20) NOT NULL DEFAULT '', sortorder BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_role_assignments COMMENT='assigning roles to different context'

Success

(mysql): CREATE UNIQUE INDEX mdl_roleassi_conroluse_uix ON mdl_role_assignments (contextid, roleid, userid)

Success

(mysql): CREATE INDEX mdl_roleassi_sor_ix ON mdl_role_assignments (sortorder)

Success

(mysql): CREATE INDEX mdl_roleassi_rol_ix ON mdl_role_assignments (roleid)

Success

(mysql): CREATE INDEX mdl_roleassi_con_ix ON mdl_role_assignments (contextid)

Success

(mysql): CREATE INDEX mdl_roleassi_use_ix ON mdl_role_assignments (userid)

Success

(mysql): CREATE TABLE mdl_role_capabilities ( id BIGINT(10) unsigned NOT NULL auto_increment, contextid BIGINT(10) unsigned NOT NULL DEFAULT 0, roleid BIGINT(10) unsigned NOT NULL DEFAULT 0, capability VARCHAR(255) NOT NULL DEFAULT '', permission BIGINT(10) NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, modifierid BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_role_capabilities COMMENT='permission has to be signed, overriding a capability for a p'

Success

(mysql): CREATE UNIQUE INDEX mdl_rolecapa_rolconcap_uix ON mdl_role_capabilities (roleid, contextid, capability)

Success

(mysql): CREATE INDEX mdl_rolecapa_rol_ix ON mdl_role_capabilities (roleid)

Success

(mysql): CREATE INDEX mdl_rolecapa_con_ix ON mdl_role_capabilities (contextid)

Success

(mysql): CREATE INDEX mdl_rolecapa_mod_ix ON mdl_role_capabilities (modifierid)

Success

(mysql): CREATE INDEX mdl_rolecapa_cap_ix ON mdl_role_capabilities (capability)

Success

(mysql): CREATE TABLE mdl_role_names ( id BIGINT(10) unsigned NOT NULL auto_increment, roleid BIGINT(10) unsigned NOT NULL DEFAULT 0, contextid BIGINT(10) unsigned NOT NULL DEFAULT 0, text TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_role_names COMMENT='role names in native strings'

Success

(mysql): CREATE UNIQUE INDEX mdl_rolename_rolcon_uix ON mdl_role_names (roleid, contextid)

Success

(mysql): CREATE INDEX mdl_rolename_rol_ix ON mdl_role_names (roleid)

Success

(mysql): CREATE INDEX mdl_rolename_con_ix ON mdl_role_names (contextid)

Success

(mysql): CREATE TABLE mdl_user_info_field ( id BIGINT(10) NOT NULL auto_increment, shortname VARCHAR(255) NOT NULL DEFAULT 'shortname', name LONGTEXT NOT NULL, datatype VARCHAR(255) NOT NULL DEFAULT '', description LONGTEXT, categoryid BIGINT(10) unsigned NOT NULL DEFAULT 0, sortorder BIGINT(10) unsigned NOT NULL DEFAULT 0, required TINYINT(2) unsigned NOT NULL DEFAULT 0, locked TINYINT(2) unsigned NOT NULL DEFAULT 0, visible SMALLINT(4) unsigned NOT NULL DEFAULT 0, defaultdata LONGTEXT, param1 LONGTEXT, param2 LONGTEXT, param3 LONGTEXT, param4 LONGTEXT, param5 LONGTEXT, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_user_info_field COMMENT='Customisable user profile fields'

Success

(mysql): CREATE TABLE mdl_user_info_category ( id BIGINT(10) NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', sortorder BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_user_info_category COMMENT='Customisable fields categories'

Success

(mysql): CREATE TABLE mdl_user_info_data ( id BIGINT(10) NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, fieldid BIGINT(10) unsigned NOT NULL DEFAULT 0, data LONGTEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_user_info_data COMMENT='Data for the customisable user fields'

Success

(mysql): CREATE TABLE mdl_mnet_enrol_course ( id BIGINT(10) NOT NULL auto_increment, hostid BIGINT(10) unsigned NOT NULL DEFAULT 0, remoteid BIGINT(10) unsigned NOT NULL DEFAULT 0, cat_id BIGINT(10) unsigned NOT NULL DEFAULT 0, cat_name VARCHAR(255) NOT NULL DEFAULT '', cat_description MEDIUMTEXT NOT NULL, sortorder SMALLINT(4) unsigned NOT NULL DEFAULT 0, fullname VARCHAR(254) NOT NULL DEFAULT '', shortname VARCHAR(15) NOT NULL DEFAULT '', idnumber VARCHAR(100) NOT NULL DEFAULT '', summary MEDIUMTEXT NOT NULL, startdate BIGINT(10) unsigned NOT NULL DEFAULT 0, cost VARCHAR(10) NOT NULL DEFAULT '', currency VARCHAR(3) NOT NULL DEFAULT '', defaultroleid SMALLINT(4) unsigned NOT NULL DEFAULT 0, defaultrolename VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_mnet_enrol_course COMMENT='Information about courses on remote hosts'

Success

(mysql): CREATE UNIQUE INDEX mdl_mnetenrocour_hosrem_uix ON mdl_mnet_enrol_course (hostid, remoteid)

Success

(mysql): CREATE TABLE mdl_mnet_enrol_assignments ( id BIGINT(10) NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, hostid BIGINT(10) unsigned NOT NULL DEFAULT 0, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, rolename VARCHAR(255) NOT NULL DEFAULT '', enroltime BIGINT(10) unsigned NOT NULL DEFAULT 0, enroltype VARCHAR(20) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_mnet_enrol_assignments COMMENT='Information about enrolments on courses on remote hosts'

Success

(mysql): CREATE INDEX mdl_mnetenroassi_hoscou_ix ON mdl_mnet_enrol_assignments (hostid, courseid)

Success

(mysql): CREATE INDEX mdl_mnetenroassi_use_ix ON mdl_mnet_enrol_assignments (userid)

Success

(mysql): CREATE TABLE mdl_mnet_host ( id BIGINT(10) NOT NULL auto_increment, deleted TINYINT(1) unsigned NOT NULL DEFAULT 0, wwwroot VARCHAR(255) NOT NULL DEFAULT '', ip_address VARCHAR(39) NOT NULL DEFAULT '', name VARCHAR(80) NOT NULL DEFAULT '', public_key MEDIUMTEXT NOT NULL, public_key_expires BIGINT(10) unsigned NOT NULL DEFAULT 0, transport TINYINT(2) unsigned NOT NULL DEFAULT 0, portno TINYINT(2) unsigned NOT NULL DEFAULT 0, last_connect_time BIGINT(10) unsigned NOT NULL DEFAULT 0, last_log_id BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_mnet_host COMMENT='Information about the local and remote hosts for RPC'

Success

(mysql): CREATE TABLE mdl_mnet_host2service ( id BIGINT(10) NOT NULL auto_increment, hostid BIGINT(10) unsigned NOT NULL DEFAULT 0, serviceid BIGINT(10) unsigned NOT NULL DEFAULT 0, publish TINYINT(1) unsigned NOT NULL DEFAULT 0, subscribe TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_mnet_host2service COMMENT='Information about the services for a given host'

Success

(mysql): CREATE UNIQUE INDEX mdl_mnethost_hosser_uix ON mdl_mnet_host2service (hostid, serviceid)

Success

(mysql): CREATE TABLE mdl_mnet_log ( id BIGINT(10) NOT NULL auto_increment, hostid BIGINT(10) unsigned NOT NULL DEFAULT 0, remoteid BIGINT(10) unsigned NOT NULL DEFAULT 0, time BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, ip VARCHAR(15) NOT NULL DEFAULT '', course BIGINT(10) unsigned NOT NULL DEFAULT 0, coursename VARCHAR(40) NOT NULL DEFAULT '', module VARCHAR(20) NOT NULL DEFAULT '', cmid BIGINT(10) unsigned NOT NULL DEFAULT 0, action VARCHAR(40) NOT NULL DEFAULT '', url VARCHAR(100) NOT NULL DEFAULT '', info VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_mnet_log COMMENT='Store session data from users migrating to other sites'

Success

(mysql): CREATE INDEX mdl_mnetlog_hosusecou_ix ON mdl_mnet_log (hostid, userid, course)

Success

(mysql): CREATE TABLE mdl_mnet_rpc ( id BIGINT(10) NOT NULL auto_increment, function_name VARCHAR(40) NOT NULL DEFAULT '', xmlrpc_path VARCHAR(80) NOT NULL DEFAULT '', parent_type VARCHAR(6) NOT NULL DEFAULT '', parent VARCHAR(20) NOT NULL DEFAULT '', enabled TINYINT(1) unsigned NOT NULL DEFAULT 0, help MEDIUMTEXT NOT NULL, profile MEDIUMTEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_mnet_rpc COMMENT='Functions or methods that we may publish or subscribe to'

Success

(mysql): CREATE INDEX mdl_mnetrpc_enaxml_ix ON mdl_mnet_rpc (enabled, xmlrpc_path)

Success

(mysql): CREATE TABLE mdl_mnet_service ( id BIGINT(10) NOT NULL auto_increment, name VARCHAR(40) NOT NULL DEFAULT '', description VARCHAR(40) NOT NULL DEFAULT '', apiversion VARCHAR(10) NOT NULL DEFAULT '', offer TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_mnet_service COMMENT='A service is a group of functions'

Success

(mysql): CREATE TABLE mdl_mnet_service2rpc ( id BIGINT(10) NOT NULL auto_increment, serviceid BIGINT(10) unsigned NOT NULL DEFAULT 0, rpcid BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_mnet_service2rpc COMMENT='Group functions or methods under a service'

Success

(mysql): CREATE UNIQUE INDEX mdl_mnetserv_rpcser_uix ON mdl_mnet_service2rpc (rpcid, serviceid)

Success

(mysql): CREATE TABLE mdl_mnet_session ( id BIGINT(10) NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, username VARCHAR(100) NOT NULL DEFAULT '', token VARCHAR(40) NOT NULL DEFAULT '', mnethostid BIGINT(10) unsigned NOT NULL DEFAULT 0, useragent VARCHAR(40) NOT NULL DEFAULT '', confirm_timeout BIGINT(10) unsigned NOT NULL DEFAULT 0, session_id VARCHAR(40) NOT NULL DEFAULT '', expires BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_mnet_session COMMENT='Store session data from users migrating to other sites'

Success

(mysql): CREATE UNIQUE INDEX mdl_mnetsess_tok_uix ON mdl_mnet_session (token)

Success

(mysql): CREATE TABLE mdl_mnet_sso_access_control ( id BIGINT(10) NOT NULL auto_increment, username VARCHAR(100) NOT NULL DEFAULT '', mnet_host_id BIGINT(10) unsigned NOT NULL DEFAULT 0, accessctrl VARCHAR(20) NOT NULL DEFAULT 'allow', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_mnet_sso_access_control COMMENT='Users by host permitted (or not) to login from a remote prov'

Success

(mysql): CREATE UNIQUE INDEX mdl_mnetssoaccecont_mneuse_uix ON mdl_mnet_sso_access_control (mnet_host_id, username)

Success

(mysql): CREATE TABLE mdl_groups ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(254) NOT NULL DEFAULT '', description TEXT, enrolmentkey VARCHAR(50) NOT NULL DEFAULT '', lang VARCHAR(30) NOT NULL DEFAULT 'en', theme VARCHAR(50) NOT NULL DEFAULT '', picture BIGINT(10) unsigned NOT NULL DEFAULT 0, hidepicture TINYINT(1) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_groups COMMENT='Each record represents a group.'

Success

(mysql): CREATE TABLE mdl_groups_members ( id BIGINT(10) unsigned NOT NULL auto_increment, groupid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timeadded BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_groups_members COMMENT='Link a user to a group.'

Success

(mysql): CREATE UNIQUE INDEX mdl_groumemb_grouse_uix ON mdl_groups_members (groupid, userid)

Success

(mysql): CREATE INDEX mdl_groumemb_gro_ix ON mdl_groups_members (groupid)

Success

(mysql): CREATE INDEX mdl_groumemb_use_ix ON mdl_groups_members (userid)

Success

(mysql): CREATE TABLE mdl_groups_groupings ( id BIGINT(10) NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, viewowngroup TINYINT(1) unsigned NOT NULL DEFAULT 1, viewallgroupsmembers TINYINT(1) unsigned NOT NULL DEFAULT 0, viewallgroupsactivities TINYINT(1) unsigned NOT NULL DEFAULT 0, teachersgroupmark TINYINT(1) unsigned NOT NULL DEFAULT 0, teachersgroupview TINYINT(1) unsigned NOT NULL DEFAULT 0, teachersoverride TINYINT(1) unsigned NOT NULL DEFAULT 0, teacherdeletable TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_groups_groupings COMMENT='A grouping is a collection of groups.'

Success

(mysql): CREATE TABLE mdl_groups_courses_groups ( id BIGINT(10) NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupid BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_groups_courses_groups COMMENT='Link a group to a course (or the site).'

Success

(mysql): CREATE UNIQUE INDEX mdl_groucourgrou_cougro_uix ON mdl_groups_courses_groups (courseid, groupid)

Success

(mysql): CREATE INDEX mdl_groucourgrou_cou_ix ON mdl_groups_courses_groups (courseid)

Success

(mysql): CREATE INDEX mdl_groucourgrou_gro_ix ON mdl_groups_courses_groups (groupid)

Success

(mysql): CREATE TABLE mdl_groups_courses_groupings ( id BIGINT(10) NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupingid BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_groups_courses_groupings COMMENT='Link a grouping to a course (or the site).'

Success

(mysql): CREATE UNIQUE INDEX mdl_groucourgrou_cougro2_uix ON mdl_groups_courses_groupings (courseid, groupingid)

Success

(mysql): CREATE INDEX mdl_groucourgrou_cou2_ix ON mdl_groups_courses_groupings (courseid)

Success

(mysql): CREATE INDEX mdl_groucourgrou_gro2_ix ON mdl_groups_courses_groupings (groupingid)

Success

(mysql): CREATE TABLE mdl_groups_groupings_groups ( id BIGINT(10) NOT NULL auto_increment, groupingid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupid BIGINT(10) unsigned NOT NULL, timeadded BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_groups_groupings_groups COMMENT='Link a group to a grouping.'

Success

(mysql): CREATE UNIQUE INDEX mdl_grougrougrou_grogro_uix ON mdl_groups_groupings_groups (groupingid, groupid)

Success

(mysql): CREATE INDEX mdl_grougrougrou_gro_ix ON mdl_groups_groupings_groups (groupingid)

Success

(mysql): CREATE INDEX mdl_grougrougrou_gro2_ix ON mdl_groups_groupings_groups (groupid)

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('user', 'view', 'user', 'CONCAT(firstname,\' \',lastname)')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('course', 'user report', 'user', 'CONCAT(firstname,\' \',lastname)')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('course', 'view', 'course', 'fullname')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('course', 'update', 'course', 'fullname')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('course', 'enrol', 'course', 'fullname')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('course', 'report log', 'course', 'fullname')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('course', 'report live', 'course', 'fullname')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('course', 'report outline', 'course', 'fullname')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('course', 'report participation', 'course', 'fullname')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('course', 'report stats', 'course', 'fullname')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('message', 'write', 'user', 'CONCAT(firstname,\' \',lastname)')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('message', 'read', 'user', 'CONCAT(firstname,\' \',lastname)')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('message', 'add contact', 'user', 'CONCAT(firstname,\' \',lastname)')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('message', 'remove contact', 'user', 'CONCAT(firstname,\' \',lastname)')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('message', 'block contact', 'user', 'CONCAT(firstname,\' \',lastname)')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('message', 'unblock contact', 'user', 'CONCAT(firstname,\' \',lastname)')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('group', 'view', 'groups', 'name')

Success

(mysql): SELECT name FROM mdl_config WHERE name = 'unicodedb' LIMIT 1

(mysql): SELECT * FROM mdl_config WHERE id = '-1'

(mysql): INSERT INTO mdl_config ( NAME, VALUE ) VALUES ( 'unicodedb', '1' )

(mysql): SELECT LAST_INSERT_ID()

Database was successfully upgraded