(mysql): SHOW TABLES

(mysql): SHOW LOCAL VARIABLES LIKE 'character_set_database'

(mysql): SET NAMES 'utf8'

(mysql): SHOW LOCAL VARIABLES LIKE 'character_set_database'

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixconfig ( 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 ss_dbprefixconfig COMMENT='Moodle configuration variables'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixconf_nam_uix ON ss_dbprefixconfig (name)

Success

(mysql): CREATE TABLE ss_dbprefixconfig_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 ss_dbprefixconfig_plugins COMMENT='Moodle modules and plugins configuration variables'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixconfplug_plunam_uix ON ss_dbprefixconfig_plugins (plugin, name)

Success

(mysql): CREATE TABLE ss_dbprefixcourse ( 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, 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, defaultgroupingid BIGINT(10) 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 ss_dbprefixcourse COMMENT='Central course table'

Success

(mysql): CREATE INDEX ss_dbprefixcour_cat_ix ON ss_dbprefixcourse (category)

Success

(mysql): CREATE INDEX ss_dbprefixcour_idn_ix ON ss_dbprefixcourse (idnumber)

Success

(mysql): CREATE INDEX ss_dbprefixcour_sho_ix ON ss_dbprefixcourse (shortname)

Success

(mysql): CREATE TABLE ss_dbprefixcourse_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 '', theme VARCHAR(50) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

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

Success

(mysql): CREATE INDEX ss_dbprefixcourcate_par_ix ON ss_dbprefixcourse_categories (parent)

Success

(mysql): CREATE TABLE ss_dbprefixcourse_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 ss_dbprefixcourse_display COMMENT='Stores info about how to display the course'

Success

(mysql): CREATE INDEX ss_dbprefixcourdisp_couuse_ix ON ss_dbprefixcourse_display (course, userid)

Success

(mysql): CREATE TABLE ss_dbprefixcourse_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 ss_dbprefixcourse_meta COMMENT='to store meta-courses relations'

Success

(mysql): CREATE INDEX ss_dbprefixcourmeta_par_ix ON ss_dbprefixcourse_meta (parent_course)

Success

(mysql): CREATE INDEX ss_dbprefixcourmeta_chi_ix ON ss_dbprefixcourse_meta (child_course)

Success

(mysql): CREATE TABLE ss_dbprefixcourse_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, idnumber VARCHAR(100) DEFAULT NULL, 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, groupingid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupmembersonly SMALLINT(4) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

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

Success

(mysql): CREATE INDEX ss_dbprefixcourmodu_vis_ix ON ss_dbprefixcourse_modules (visible)

Success

(mysql): CREATE INDEX ss_dbprefixcourmodu_cou_ix ON ss_dbprefixcourse_modules (course)

Success

(mysql): CREATE INDEX ss_dbprefixcourmodu_mod_ix ON ss_dbprefixcourse_modules (module)

Success

(mysql): CREATE INDEX ss_dbprefixcourmodu_ins_ix ON ss_dbprefixcourse_modules (instance)

Success

(mysql): CREATE INDEX ss_dbprefixcourmodu_idncou_ix ON ss_dbprefixcourse_modules (idnumber, course)

Success

(mysql): CREATE INDEX ss_dbprefixcourmodu_gro_ix ON ss_dbprefixcourse_modules (groupingid)

Success

(mysql): CREATE TABLE ss_dbprefixcourse_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 ss_dbprefixcourse_sections COMMENT='to define the sections for each course'

Success

(mysql): CREATE INDEX ss_dbprefixcoursect_cousec_ix ON ss_dbprefixcourse_sections (course, section)

Success

(mysql): CREATE TABLE ss_dbprefixcourse_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) unsigned NOT NULL DEFAULT 0, password VARCHAR(50) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

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

Success

(mysql): CREATE INDEX ss_dbprefixcourrequ_sho_ix ON ss_dbprefixcourse_request (shortname)

Success

(mysql): CREATE TABLE ss_dbprefixcourse_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 ss_dbprefixcourse_allowed_modules COMMENT='allowed modules foreach course'

Success

(mysql): CREATE INDEX ss_dbprefixcourallomodu_cou_ix ON ss_dbprefixcourse_allowed_modules (course)

Success

(mysql): CREATE INDEX ss_dbprefixcourallomodu_mod_ix ON ss_dbprefixcourse_allowed_modules (module)

Success

(mysql): CREATE TABLE ss_dbprefixevent ( 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 ss_dbprefixevent COMMENT='For everything with a time associated to it'

Success

(mysql): CREATE INDEX ss_dbprefixeven_cou_ix ON ss_dbprefixevent (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixeven_use_ix ON ss_dbprefixevent (userid)

Success

(mysql): CREATE INDEX ss_dbprefixeven_tim_ix ON ss_dbprefixevent (timestart)

Success

(mysql): CREATE INDEX ss_dbprefixeven_tim2_ix ON ss_dbprefixevent (timeduration)

Success

(mysql): CREATE INDEX ss_dbprefixeven_grocouvisus_ix ON ss_dbprefixevent (groupid, courseid, visible, userid)

Success

(mysql): CREATE TABLE ss_dbprefixcache_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 ss_dbprefixcache_filters COMMENT='For keeping information about cached data'

Success

(mysql): CREATE INDEX ss_dbprefixcachfilt_filmd5_ix ON ss_dbprefixcache_filters (filter, md5key)

Success

(mysql): CREATE TABLE ss_dbprefixcache_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 ss_dbprefixcache_text COMMENT='For storing temporary copies of processed texts'

Success

(mysql): CREATE INDEX ss_dbprefixcachtext_md5_ix ON ss_dbprefixcache_text (md5key)

Success

(mysql): CREATE INDEX ss_dbprefixcachtext_tim_ix ON ss_dbprefixcache_text (timemodified)

Success

(mysql): CREATE TABLE ss_dbprefixlog ( 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 ss_dbprefixlog COMMENT='Every action is logged as far as possible'

Success

(mysql): CREATE INDEX ss_dbprefixlog_coumodact_ix ON ss_dbprefixlog (course, module, action)

Success

(mysql): CREATE INDEX ss_dbprefixlog_tim_ix ON ss_dbprefixlog (time)

Success

(mysql): CREATE INDEX ss_dbprefixlog_act_ix ON ss_dbprefixlog (action)

Success

(mysql): CREATE INDEX ss_dbprefixlog_usecou_ix ON ss_dbprefixlog (userid, course)

Success

(mysql): CREATE INDEX ss_dbprefixlog_cmi_ix ON ss_dbprefixlog (cmid)

Success

(mysql): CREATE TABLE ss_dbprefixlog_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 ss_dbprefixlog_display COMMENT='For a particular module/action, specifies a moodle table/fie'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixlogdisp_modact_uix ON ss_dbprefixlog_display (module, action)

Success

(mysql): CREATE TABLE ss_dbprefixmessage ( id BIGINT(10) unsigned NOT NULL auto_increment, useridfrom BIGINT(10) unsigned NOT NULL DEFAULT 0, useridto BIGINT(10) unsigned 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 ss_dbprefixmessage COMMENT='Stores all unread messages'

Success

(mysql): CREATE INDEX ss_dbprefixmess_use_ix ON ss_dbprefixmessage (useridfrom)

Success

(mysql): CREATE INDEX ss_dbprefixmess_use2_ix ON ss_dbprefixmessage (useridto)

Success

(mysql): CREATE TABLE ss_dbprefixmessage_read ( id BIGINT(10) unsigned NOT NULL auto_increment, useridfrom BIGINT(10) unsigned NOT NULL DEFAULT 0, useridto BIGINT(10) unsigned 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 ss_dbprefixmessage_read COMMENT='Stores all messages that have been read'

Success

(mysql): CREATE INDEX ss_dbprefixmessread_use_ix ON ss_dbprefixmessage_read (useridfrom)

Success

(mysql): CREATE INDEX ss_dbprefixmessread_use2_ix ON ss_dbprefixmessage_read (useridto)

Success

(mysql): CREATE TABLE ss_dbprefixmessage_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 ss_dbprefixmessage_contacts COMMENT='Maintains lists of relationships between users'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixmesscont_usecon_uix ON ss_dbprefixmessage_contacts (userid, contactid)

Success

(mysql): CREATE TABLE ss_dbprefixmodules ( 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 ss_dbprefixmodules COMMENT='modules available in the site'

Success

(mysql): CREATE INDEX ss_dbprefixmodu_nam_ix ON ss_dbprefixmodules (name)

Success

(mysql): CREATE TABLE ss_dbprefixsessions2 ( 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 ss_dbprefixsessions2 COMMENT='Optional database session storage in new format, not used by'

Success

(mysql): CREATE INDEX ss_dbprefixsess_exp_ix ON ss_dbprefixsessions2 (expiry)

Success

(mysql): CREATE INDEX ss_dbprefixsess_exp2_ix ON ss_dbprefixsessions2 (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 ss_dbprefixtimezone ( id BIGINT(10) unsigned 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(6) 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(6) NOT NULL DEFAULT '00:00', CONSTRAINT PRIMARY KEY (id) )

Success

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

Success

(mysql): CREATE TABLE ss_dbprefixuser ( 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) unsigned NOT NULL DEFAULT 0, username VARCHAR(100) NOT NULL DEFAULT '', password VARCHAR(32) NOT NULL DEFAULT '', idnumber VARCHAR(255) 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_utf8', 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 ss_dbprefixuser COMMENT='One record for each person'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixuser_mneuse_uix ON ss_dbprefixuser (mnethostid, username)

Success

(mysql): CREATE INDEX ss_dbprefixuser_del_ix ON ss_dbprefixuser (deleted)

Success

(mysql): CREATE INDEX ss_dbprefixuser_con_ix ON ss_dbprefixuser (confirmed)

Success

(mysql): CREATE INDEX ss_dbprefixuser_fir_ix ON ss_dbprefixuser (firstname)

Success

(mysql): CREATE INDEX ss_dbprefixuser_las_ix ON ss_dbprefixuser (lastname)

Success

(mysql): CREATE INDEX ss_dbprefixuser_cit_ix ON ss_dbprefixuser (city)

Success

(mysql): CREATE INDEX ss_dbprefixuser_cou_ix ON ss_dbprefixuser (country)

Success

(mysql): CREATE INDEX ss_dbprefixuser_las2_ix ON ss_dbprefixuser (lastaccess)

Success

(mysql): CREATE INDEX ss_dbprefixuser_ema_ix ON ss_dbprefixuser (email)

Success

(mysql): CREATE INDEX ss_dbprefixuser_aut_ix ON ss_dbprefixuser (auth)

Success

(mysql): CREATE INDEX ss_dbprefixuser_idn_ix ON ss_dbprefixuser (idnumber)

Success

(mysql): CREATE TABLE ss_dbprefixuser_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 ss_dbprefixuser_preferences COMMENT='Allows modules to store arbitrary user preferences'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixuserpref_usenam_uix ON ss_dbprefixuser_preferences (userid, name)

Success

(mysql): CREATE TABLE ss_dbprefixuser_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 ss_dbprefixuser_lastaccess COMMENT='To keep track of course page access times, used in online pa'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixuserlast_usecou_uix ON ss_dbprefixuser_lastaccess (userid, courseid)

Success

(mysql): CREATE INDEX ss_dbprefixuserlast_use_ix ON ss_dbprefixuser_lastaccess (userid)

Success

(mysql): CREATE INDEX ss_dbprefixuserlast_cou_ix ON ss_dbprefixuser_lastaccess (courseid)

Success

(mysql): CREATE TABLE ss_dbprefixscale ( 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 ss_dbprefixscale COMMENT='Defines grading scales'

Success

(mysql): CREATE INDEX ss_dbprefixscal_cou_ix ON ss_dbprefixscale (courseid)

Success

(mysql): CREATE TABLE ss_dbprefixscale_history ( id BIGINT(10) unsigned NOT NULL auto_increment, action BIGINT(10) unsigned NOT NULL DEFAULT 0, oldid BIGINT(10) unsigned NOT NULL, source VARCHAR(255) DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, loggeduser BIGINT(10) unsigned DEFAULT NULL, 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, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixscale_history COMMENT='History table'

Success

(mysql): CREATE INDEX ss_dbprefixscalhist_act_ix ON ss_dbprefixscale_history (action)

Success

(mysql): CREATE INDEX ss_dbprefixscalhist_old_ix ON ss_dbprefixscale_history (oldid)

Success

(mysql): CREATE INDEX ss_dbprefixscalhist_cou_ix ON ss_dbprefixscale_history (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixscalhist_log_ix ON ss_dbprefixscale_history (loggeduser)

Success

(mysql): CREATE TABLE ss_dbprefixstats_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 ss_dbprefixstats_daily COMMENT='to accumulate daily stats'

Success

(mysql): CREATE INDEX ss_dbprefixstatdail_cou_ix ON ss_dbprefixstats_daily (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixstatdail_tim_ix ON ss_dbprefixstats_daily (timeend)

Success

(mysql): CREATE INDEX ss_dbprefixstatdail_rol_ix ON ss_dbprefixstats_daily (roleid)

Success

(mysql): CREATE TABLE ss_dbprefixstats_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 ss_dbprefixstats_weekly COMMENT='To accumulate weekly stats'

Success

(mysql): CREATE INDEX ss_dbprefixstatweek_cou_ix ON ss_dbprefixstats_weekly (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixstatweek_tim_ix ON ss_dbprefixstats_weekly (timeend)

Success

(mysql): CREATE INDEX ss_dbprefixstatweek_rol_ix ON ss_dbprefixstats_weekly (roleid)

Success

(mysql): CREATE TABLE ss_dbprefixstats_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 ss_dbprefixstats_monthly COMMENT='To accumulate monthly stats'

Success

(mysql): CREATE INDEX ss_dbprefixstatmont_cou_ix ON ss_dbprefixstats_monthly (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixstatmont_tim_ix ON ss_dbprefixstats_monthly (timeend)

Success

(mysql): CREATE INDEX ss_dbprefixstatmont_rol_ix ON ss_dbprefixstats_monthly (roleid)

Success

(mysql): CREATE TABLE ss_dbprefixstats_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 ss_dbprefixstats_user_daily COMMENT='To accumulate daily stats per course/user'

Success

(mysql): CREATE INDEX ss_dbprefixstatuserdail_cou_ix ON ss_dbprefixstats_user_daily (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixstatuserdail_use_ix ON ss_dbprefixstats_user_daily (userid)

Success

(mysql): CREATE INDEX ss_dbprefixstatuserdail_rol_ix ON ss_dbprefixstats_user_daily (roleid)

Success

(mysql): CREATE INDEX ss_dbprefixstatuserdail_tim_ix ON ss_dbprefixstats_user_daily (timeend)

Success

(mysql): CREATE TABLE ss_dbprefixstats_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 ss_dbprefixstats_user_weekly COMMENT='To accumulate weekly stats per course/user'

Success

(mysql): CREATE INDEX ss_dbprefixstatuserweek_cou_ix ON ss_dbprefixstats_user_weekly (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixstatuserweek_use_ix ON ss_dbprefixstats_user_weekly (userid)

Success

(mysql): CREATE INDEX ss_dbprefixstatuserweek_rol_ix ON ss_dbprefixstats_user_weekly (roleid)

Success

(mysql): CREATE INDEX ss_dbprefixstatuserweek_tim_ix ON ss_dbprefixstats_user_weekly (timeend)

Success

(mysql): CREATE TABLE ss_dbprefixstats_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 ss_dbprefixstats_user_monthly COMMENT='To accumulate monthly stats per course/user'

Success

(mysql): CREATE INDEX ss_dbprefixstatusermont_cou_ix ON ss_dbprefixstats_user_monthly (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixstatusermont_use_ix ON ss_dbprefixstats_user_monthly (userid)

Success

(mysql): CREATE INDEX ss_dbprefixstatusermont_rol_ix ON ss_dbprefixstats_user_monthly (roleid)

Success

(mysql): CREATE INDEX ss_dbprefixstatusermont_tim_ix ON ss_dbprefixstats_user_monthly (timeend)

Success

(mysql): CREATE TABLE ss_dbprefixpost ( id BIGINT(10) unsigned 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, usermodified BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

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

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixpost_iduse_uix ON ss_dbprefixpost (id, userid)

Success

(mysql): CREATE INDEX ss_dbprefixpost_las_ix ON ss_dbprefixpost (lastmodified)

Success

(mysql): CREATE INDEX ss_dbprefixpost_mod_ix ON ss_dbprefixpost (module)

Success

(mysql): CREATE INDEX ss_dbprefixpost_sub_ix ON ss_dbprefixpost (subject)

Success

(mysql): CREATE INDEX ss_dbprefixpost_use_ix ON ss_dbprefixpost (usermodified)

Success

(mysql): CREATE TABLE ss_dbprefixrole ( 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 ss_dbprefixrole COMMENT='moodle roles'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixrole_sor_uix ON ss_dbprefixrole (sortorder)

Success

(mysql): CREATE TABLE ss_dbprefixcontext ( id BIGINT(10) unsigned NOT NULL auto_increment, contextlevel BIGINT(10) unsigned NOT NULL DEFAULT 0, instanceid BIGINT(10) unsigned NOT NULL DEFAULT 0, path VARCHAR(255) DEFAULT NULL, depth TINYINT(2) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

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

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixcont_conins_uix ON ss_dbprefixcontext (contextlevel, instanceid)

Success

(mysql): CREATE INDEX ss_dbprefixcont_ins_ix ON ss_dbprefixcontext (instanceid)

Success

(mysql): CREATE INDEX ss_dbprefixcont_pat_ix ON ss_dbprefixcontext (path)

Success

(mysql): CREATE TABLE ss_dbprefixcontext_temp ( id BIGINT(10) unsigned NOT NULL, path VARCHAR(255) NOT NULL DEFAULT '', depth TINYINT(2) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixcontext_temp COMMENT='Used by build_context_path() in upgrade and cron to keep con'

Success

(mysql): CREATE TABLE ss_dbprefixcapabilities ( 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 ss_dbprefixcapabilities COMMENT='this defines all capabilities'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixcapa_nam_uix ON ss_dbprefixcapabilities (name)

Success

(mysql): CREATE TABLE ss_dbprefixrole_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 ss_dbprefixrole_allow_assign COMMENT='this defines what role can assign what role'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixrolealloassi_ro_uix ON ss_dbprefixrole_allow_assign (roleid, allowassign)

Success

(mysql): CREATE INDEX ss_dbprefixrolealloassi_rol_ix ON ss_dbprefixrole_allow_assign (roleid)

Success

(mysql): CREATE INDEX ss_dbprefixrolealloassi_all_ix ON ss_dbprefixrole_allow_assign (allowassign)

Success

(mysql): CREATE TABLE ss_dbprefixrole_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 ss_dbprefixrole_allow_override COMMENT='this defines what role can override what role'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixrolealloover_ro_uix ON ss_dbprefixrole_allow_override (roleid, allowoverride)

Success

(mysql): CREATE INDEX ss_dbprefixrolealloover_rol_ix ON ss_dbprefixrole_allow_override (roleid)

Success

(mysql): CREATE INDEX ss_dbprefixrolealloover_all_ix ON ss_dbprefixrole_allow_override (allowoverride)

Success

(mysql): CREATE TABLE ss_dbprefixrole_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 ss_dbprefixrole_assignments COMMENT='assigning roles to different context'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixroleassi_conrol_uix ON ss_dbprefixrole_assignments (contextid, roleid, userid)

Success

(mysql): CREATE INDEX ss_dbprefixroleassi_sor_ix ON ss_dbprefixrole_assignments (sortorder)

Success

(mysql): CREATE INDEX ss_dbprefixroleassi_rol_ix ON ss_dbprefixrole_assignments (roleid)

Success

(mysql): CREATE INDEX ss_dbprefixroleassi_con_ix ON ss_dbprefixrole_assignments (contextid)

Success

(mysql): CREATE INDEX ss_dbprefixroleassi_use_ix ON ss_dbprefixrole_assignments (userid)

Success

(mysql): CREATE TABLE ss_dbprefixrole_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 ss_dbprefixrole_capabilities COMMENT='permission has to be signed, overriding a capability for a p'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixrolecapa_rolcon_uix ON ss_dbprefixrole_capabilities (roleid, contextid, capability)

Success

(mysql): CREATE INDEX ss_dbprefixrolecapa_rol_ix ON ss_dbprefixrole_capabilities (roleid)

Success

(mysql): CREATE INDEX ss_dbprefixrolecapa_con_ix ON ss_dbprefixrole_capabilities (contextid)

Success

(mysql): CREATE INDEX ss_dbprefixrolecapa_mod_ix ON ss_dbprefixrole_capabilities (modifierid)

Success

(mysql): CREATE INDEX ss_dbprefixrolecapa_cap_ix ON ss_dbprefixrole_capabilities (capability)

Success

(mysql): CREATE TABLE ss_dbprefixrole_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, name VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

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

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixrolename_rolcon_uix ON ss_dbprefixrole_names (roleid, contextid)

Success

(mysql): CREATE INDEX ss_dbprefixrolename_rol_ix ON ss_dbprefixrole_names (roleid)

Success

(mysql): CREATE INDEX ss_dbprefixrolename_con_ix ON ss_dbprefixrole_names (contextid)

Success

(mysql): CREATE TABLE ss_dbprefixrole_sortorder ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL, roleid BIGINT(10) unsigned NOT NULL, contextid BIGINT(10) unsigned NOT NULL, sortoder BIGINT(10) NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixrole_sortorder COMMENT='sort order of course managers in a course'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixrolesort_userol_uix ON ss_dbprefixrole_sortorder (userid, roleid, contextid)

Success

(mysql): CREATE INDEX ss_dbprefixrolesort_use_ix ON ss_dbprefixrole_sortorder (userid)

Success

(mysql): CREATE INDEX ss_dbprefixrolesort_rol_ix ON ss_dbprefixrole_sortorder (roleid)

Success

(mysql): CREATE INDEX ss_dbprefixrolesort_con_ix ON ss_dbprefixrole_sortorder (contextid)

Success

(mysql): CREATE TABLE ss_dbprefixuser_info_field ( id BIGINT(10) unsigned 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, forceunique TINYINT(2) unsigned NOT NULL DEFAULT 0, signup TINYINT(2) 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 ss_dbprefixuser_info_field COMMENT='Customisable user profile fields'

Success

(mysql): CREATE TABLE ss_dbprefixuser_info_category ( id BIGINT(10) unsigned 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 ss_dbprefixuser_info_category COMMENT='Customisable fields categories'

Success

(mysql): CREATE TABLE ss_dbprefixuser_info_data ( id BIGINT(10) unsigned 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 ss_dbprefixuser_info_data COMMENT='Data for the customisable user fields'

Success

(mysql): CREATE TABLE ss_dbprefixmnet_enrol_course ( id BIGINT(10) unsigned 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 BIGINT(10) 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 ss_dbprefixmnet_enrol_course COMMENT='Information about courses on remote hosts'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixmnetenrocour_ho_uix ON ss_dbprefixmnet_enrol_course (hostid, remoteid)

Success

(mysql): CREATE TABLE ss_dbprefixmnet_enrol_assignments ( id BIGINT(10) unsigned 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 ss_dbprefixmnet_enrol_assignments COMMENT='Information about enrolments on courses on remote hosts'

Success

(mysql): CREATE INDEX ss_dbprefixmnetenroassi_hos_ix ON ss_dbprefixmnet_enrol_assignments (hostid, courseid)

Success

(mysql): CREATE INDEX ss_dbprefixmnetenroassi_use_ix ON ss_dbprefixmnet_enrol_assignments (userid)

Success

(mysql): CREATE TABLE ss_dbprefixmnet_application ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(50) NOT NULL DEFAULT '', display_name VARCHAR(50) NOT NULL DEFAULT '', xmlrpc_server_url VARCHAR(255) NOT NULL DEFAULT '', sso_land_url VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixmnet_application COMMENT='Information about applications on remote hosts'

Success

(mysql): CREATE TABLE ss_dbprefixmnet_host ( id BIGINT(10) unsigned 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, force_theme TINYINT(1) unsigned NOT NULL DEFAULT 0, theme VARCHAR(100) DEFAULT NULL, applicationid BIGINT(10) unsigned NOT NULL DEFAULT 1, CONSTRAINT PRIMARY KEY (id) )

Success

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

Success

(mysql): CREATE INDEX ss_dbprefixmnethost_app_ix ON ss_dbprefixmnet_host (applicationid)

Success

(mysql): CREATE TABLE ss_dbprefixmnet_host2service ( id BIGINT(10) unsigned 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 ss_dbprefixmnet_host2service COMMENT='Information about the services for a given host'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixmnethost_hosser_uix ON ss_dbprefixmnet_host2service (hostid, serviceid)

Success

(mysql): CREATE TABLE ss_dbprefixmnet_log ( id BIGINT(10) unsigned 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 ss_dbprefixmnet_log COMMENT='Store session data from users migrating to other sites'

Success

(mysql): CREATE INDEX ss_dbprefixmnetlog_hosuseco_ix ON ss_dbprefixmnet_log (hostid, userid, course)

Success

(mysql): CREATE TABLE ss_dbprefixmnet_rpc ( id BIGINT(10) unsigned 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 ss_dbprefixmnet_rpc COMMENT='Functions or methods that we may publish or subscribe to'

Success

(mysql): CREATE INDEX ss_dbprefixmnetrpc_enaxml_ix ON ss_dbprefixmnet_rpc (enabled, xmlrpc_path)

Success

(mysql): CREATE TABLE ss_dbprefixmnet_service ( id BIGINT(10) unsigned 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 ss_dbprefixmnet_service COMMENT='A service is a group of functions'

Success

(mysql): CREATE TABLE ss_dbprefixmnet_service2rpc ( id BIGINT(10) unsigned 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 ss_dbprefixmnet_service2rpc COMMENT='Group functions or methods under a service'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixmnetserv_rpcser_uix ON ss_dbprefixmnet_service2rpc (rpcid, serviceid)

Success

(mysql): CREATE TABLE ss_dbprefixmnet_session ( id BIGINT(10) unsigned 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 ss_dbprefixmnet_session COMMENT='Store session data from users migrating to other sites'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixmnetsess_tok_uix ON ss_dbprefixmnet_session (token)

Success

(mysql): CREATE TABLE ss_dbprefixmnet_sso_access_control ( id BIGINT(10) unsigned 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 ss_dbprefixmnet_sso_access_control COMMENT='Users by host permitted (or not) to login from a remote prov'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixmnetssoaccecont_uix ON ss_dbprefixmnet_sso_access_control (mnet_host_id, username)

Success

(mysql): CREATE TABLE ss_dbprefixevents_queue ( id BIGINT(10) unsigned NOT NULL auto_increment, eventdata LONGTEXT NOT NULL, stackdump MEDIUMTEXT, userid BIGINT(10) unsigned DEFAULT NULL, timecreated BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixevents_queue COMMENT='This table is for storing queued events. It stores only one '

Success

(mysql): CREATE INDEX ss_dbprefixevenqueu_use_ix ON ss_dbprefixevents_queue (userid)

Success

(mysql): CREATE TABLE ss_dbprefixevents_handlers ( id BIGINT(10) unsigned NOT NULL auto_increment, eventname VARCHAR(166) NOT NULL DEFAULT '', handlermodule VARCHAR(166) NOT NULL DEFAULT '', handlerfile VARCHAR(255) NOT NULL DEFAULT '', handlerfunction MEDIUMTEXT, schedule VARCHAR(255) DEFAULT NULL, status BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixevents_handlers COMMENT='This table is for storing which components requests what typ'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixevenhand_evehan_uix ON ss_dbprefixevents_handlers (eventname, handlermodule)

Success

(mysql): CREATE TABLE ss_dbprefixevents_queue_handlers ( id BIGINT(10) unsigned NOT NULL auto_increment, queuedeventid BIGINT(10) unsigned NOT NULL, handlerid BIGINT(10) unsigned NOT NULL, status BIGINT(10) DEFAULT NULL, errormessage MEDIUMTEXT, timemodified BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixevents_queue_handlers COMMENT='This is the list of queued handlers for processing. The even'

Success

(mysql): CREATE INDEX ss_dbprefixevenqueuhand_que_ix ON ss_dbprefixevents_queue_handlers (queuedeventid)

Success

(mysql): CREATE INDEX ss_dbprefixevenqueuhand_han_ix ON ss_dbprefixevents_queue_handlers (handlerid)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_outcomes ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned DEFAULT NULL, shortname VARCHAR(255) NOT NULL DEFAULT '', fullname TEXT NOT NULL, scaleid BIGINT(10) unsigned DEFAULT NULL, description TEXT, timecreated BIGINT(10) unsigned DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, usermodified BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_outcomes COMMENT='This table describes the outcomes used in the system. An out'

Success

(mysql): CREATE INDEX ss_dbprefixgradoutc_cou_ix ON ss_dbprefixgrade_outcomes (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixgradoutc_sca_ix ON ss_dbprefixgrade_outcomes (scaleid)

Success

(mysql): CREATE INDEX ss_dbprefixgradoutc_use_ix ON ss_dbprefixgrade_outcomes (usermodified)

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixgradoutc_cousho_uix ON ss_dbprefixgrade_outcomes (courseid, shortname)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_outcomes_courses ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL, outcomeid BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_outcomes_courses COMMENT='stores what outcomes are used in what courses.'

Success

(mysql): CREATE INDEX ss_dbprefixgradoutccour_cou_ix ON ss_dbprefixgrade_outcomes_courses (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixgradoutccour_out_ix ON ss_dbprefixgrade_outcomes_courses (outcomeid)

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixgradoutccour_co_uix ON ss_dbprefixgrade_outcomes_courses (courseid, outcomeid)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_categories ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL, parent BIGINT(10) unsigned DEFAULT NULL, depth BIGINT(10) unsigned NOT NULL DEFAULT 0, path VARCHAR(255) DEFAULT NULL, fullname VARCHAR(255) NOT NULL DEFAULT '', aggregation BIGINT(10) NOT NULL DEFAULT 0, keephigh BIGINT(10) NOT NULL DEFAULT 0, droplow BIGINT(10) NOT NULL DEFAULT 0, aggregateonlygraded TINYINT(1) unsigned NOT NULL DEFAULT 0, aggregateoutcomes TINYINT(1) unsigned NOT NULL DEFAULT 0, aggregatesubcats TINYINT(1) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL, timemodified BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_categories COMMENT='This table keeps information about categories, used for grou'

Success

(mysql): CREATE INDEX ss_dbprefixgradcate_cou_ix ON ss_dbprefixgrade_categories (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixgradcate_par_ix ON ss_dbprefixgrade_categories (parent)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_items ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned DEFAULT NULL, categoryid BIGINT(10) unsigned DEFAULT NULL, itemname VARCHAR(255) DEFAULT NULL, itemtype VARCHAR(30) NOT NULL DEFAULT '', itemmodule VARCHAR(30) DEFAULT NULL, iteminstance BIGINT(10) unsigned DEFAULT NULL, itemnumber BIGINT(10) unsigned DEFAULT NULL, iteminfo MEDIUMTEXT, idnumber VARCHAR(255) DEFAULT NULL, calculation MEDIUMTEXT, gradetype SMALLINT(4) NOT NULL DEFAULT 1, grademax NUMERIC(10,5) NOT NULL DEFAULT 100, grademin NUMERIC(10,5) NOT NULL DEFAULT 0, scaleid BIGINT(10) unsigned DEFAULT NULL, outcomeid BIGINT(10) unsigned DEFAULT NULL, gradepass NUMERIC(10,5) NOT NULL DEFAULT 0, multfactor NUMERIC(10,5) NOT NULL DEFAULT 1.0, plusfactor NUMERIC(10,5) NOT NULL DEFAULT 0, aggregationcoef NUMERIC(10,5) NOT NULL DEFAULT 0, sortorder BIGINT(10) NOT NULL DEFAULT 0, display BIGINT(10) NOT NULL DEFAULT 0, decimals TINYINT(1) unsigned DEFAULT NULL, hidden BIGINT(10) NOT NULL DEFAULT 0, locked BIGINT(10) NOT NULL DEFAULT 0, locktime BIGINT(10) unsigned NOT NULL DEFAULT 0, needsupdate BIGINT(10) NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_items COMMENT='This table keeps information about gradeable items (ie colum'

Success

(mysql): CREATE INDEX ss_dbprefixgraditem_locloc_ix ON ss_dbprefixgrade_items (locked, locktime)

Success

(mysql): CREATE INDEX ss_dbprefixgraditem_itenee_ix ON ss_dbprefixgrade_items (itemtype, needsupdate)

Success

(mysql): CREATE INDEX ss_dbprefixgraditem_gra_ix ON ss_dbprefixgrade_items (gradetype)

Success

(mysql): CREATE INDEX ss_dbprefixgraditem_idncou_ix ON ss_dbprefixgrade_items (idnumber, courseid)

Success

(mysql): CREATE INDEX ss_dbprefixgraditem_cou_ix ON ss_dbprefixgrade_items (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixgraditem_cat_ix ON ss_dbprefixgrade_items (categoryid)

Success

(mysql): CREATE INDEX ss_dbprefixgraditem_sca_ix ON ss_dbprefixgrade_items (scaleid)

Success

(mysql): CREATE INDEX ss_dbprefixgraditem_out_ix ON ss_dbprefixgrade_items (outcomeid)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_grades ( id BIGINT(10) unsigned NOT NULL auto_increment, itemid BIGINT(10) unsigned NOT NULL, userid BIGINT(10) unsigned NOT NULL, rawgrade NUMERIC(10,5) DEFAULT NULL, rawgrademax NUMERIC(10,5) NOT NULL DEFAULT 100, rawgrademin NUMERIC(10,5) NOT NULL DEFAULT 0, rawscaleid BIGINT(10) unsigned DEFAULT NULL, usermodified BIGINT(10) unsigned DEFAULT NULL, finalgrade NUMERIC(10,5) DEFAULT NULL, hidden BIGINT(10) unsigned NOT NULL DEFAULT 0, locked BIGINT(10) unsigned NOT NULL DEFAULT 0, locktime BIGINT(10) unsigned NOT NULL DEFAULT 0, exported BIGINT(10) unsigned NOT NULL DEFAULT 0, overridden BIGINT(10) unsigned NOT NULL DEFAULT 0, excluded BIGINT(10) unsigned NOT NULL DEFAULT 0, feedback MEDIUMTEXT, feedbackformat BIGINT(10) unsigned NOT NULL DEFAULT 0, information MEDIUMTEXT, informationformat BIGINT(10) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_grades COMMENT='grade_grades This table keeps individual grades for each us'

Success

(mysql): CREATE INDEX ss_dbprefixgradgrad_locloc_ix ON ss_dbprefixgrade_grades (locked, locktime)

Success

(mysql): CREATE INDEX ss_dbprefixgradgrad_ite_ix ON ss_dbprefixgrade_grades (itemid)

Success

(mysql): CREATE INDEX ss_dbprefixgradgrad_use_ix ON ss_dbprefixgrade_grades (userid)

Success

(mysql): CREATE INDEX ss_dbprefixgradgrad_raw_ix ON ss_dbprefixgrade_grades (rawscaleid)

Success

(mysql): CREATE INDEX ss_dbprefixgradgrad_use2_ix ON ss_dbprefixgrade_grades (usermodified)

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixgradgrad_useite_uix ON ss_dbprefixgrade_grades (userid, itemid)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_outcomes_history ( id BIGINT(10) unsigned NOT NULL auto_increment, action BIGINT(10) unsigned NOT NULL DEFAULT 0, oldid BIGINT(10) unsigned NOT NULL, source VARCHAR(255) DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, loggeduser BIGINT(10) unsigned DEFAULT NULL, courseid BIGINT(10) unsigned DEFAULT NULL, shortname VARCHAR(255) NOT NULL DEFAULT '', fullname TEXT NOT NULL, scaleid BIGINT(10) unsigned DEFAULT NULL, description TEXT, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_outcomes_history COMMENT='History table'

Success

(mysql): CREATE INDEX ss_dbprefixgradoutchist_act_ix ON ss_dbprefixgrade_outcomes_history (action)

Success

(mysql): CREATE INDEX ss_dbprefixgradoutchist_old_ix ON ss_dbprefixgrade_outcomes_history (oldid)

Success

(mysql): CREATE INDEX ss_dbprefixgradoutchist_cou_ix ON ss_dbprefixgrade_outcomes_history (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixgradoutchist_sca_ix ON ss_dbprefixgrade_outcomes_history (scaleid)

Success

(mysql): CREATE INDEX ss_dbprefixgradoutchist_log_ix ON ss_dbprefixgrade_outcomes_history (loggeduser)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_categories_history ( id BIGINT(10) unsigned NOT NULL auto_increment, action BIGINT(10) unsigned NOT NULL DEFAULT 0, oldid BIGINT(10) unsigned NOT NULL, source VARCHAR(255) DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, loggeduser BIGINT(10) unsigned DEFAULT NULL, courseid BIGINT(10) unsigned NOT NULL, parent BIGINT(10) unsigned DEFAULT NULL, depth BIGINT(10) unsigned NOT NULL DEFAULT 0, path VARCHAR(255) DEFAULT NULL, fullname VARCHAR(255) NOT NULL DEFAULT '', aggregation BIGINT(10) NOT NULL DEFAULT 0, keephigh BIGINT(10) NOT NULL DEFAULT 0, droplow BIGINT(10) NOT NULL DEFAULT 0, aggregateonlygraded TINYINT(1) unsigned NOT NULL DEFAULT 0, aggregateoutcomes TINYINT(1) unsigned NOT NULL DEFAULT 0, aggregatesubcats TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_categories_history COMMENT='History of grade_categories'

Success

(mysql): CREATE INDEX ss_dbprefixgradcatehist_act_ix ON ss_dbprefixgrade_categories_history (action)

Success

(mysql): CREATE INDEX ss_dbprefixgradcatehist_old_ix ON ss_dbprefixgrade_categories_history (oldid)

Success

(mysql): CREATE INDEX ss_dbprefixgradcatehist_cou_ix ON ss_dbprefixgrade_categories_history (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixgradcatehist_par_ix ON ss_dbprefixgrade_categories_history (parent)

Success

(mysql): CREATE INDEX ss_dbprefixgradcatehist_log_ix ON ss_dbprefixgrade_categories_history (loggeduser)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_items_history ( id BIGINT(10) unsigned NOT NULL auto_increment, action BIGINT(10) unsigned NOT NULL DEFAULT 0, oldid BIGINT(10) unsigned NOT NULL, source VARCHAR(255) DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, loggeduser BIGINT(10) unsigned DEFAULT NULL, courseid BIGINT(10) unsigned DEFAULT NULL, categoryid BIGINT(10) unsigned DEFAULT NULL, itemname VARCHAR(255) DEFAULT NULL, itemtype VARCHAR(30) NOT NULL DEFAULT '', itemmodule VARCHAR(30) DEFAULT NULL, iteminstance BIGINT(10) unsigned DEFAULT NULL, itemnumber BIGINT(10) unsigned DEFAULT NULL, iteminfo MEDIUMTEXT, idnumber VARCHAR(255) DEFAULT NULL, calculation MEDIUMTEXT, gradetype SMALLINT(4) NOT NULL DEFAULT 1, grademax NUMERIC(10,5) NOT NULL DEFAULT 100, grademin NUMERIC(10,5) NOT NULL DEFAULT 0, scaleid BIGINT(10) unsigned DEFAULT NULL, outcomeid BIGINT(10) unsigned DEFAULT NULL, gradepass NUMERIC(10,5) NOT NULL DEFAULT 0, multfactor NUMERIC(10,5) NOT NULL DEFAULT 1.0, plusfactor NUMERIC(10,5) NOT NULL DEFAULT 0, aggregationcoef NUMERIC(10,5) NOT NULL DEFAULT 0, sortorder BIGINT(10) NOT NULL DEFAULT 0, hidden BIGINT(10) NOT NULL DEFAULT 0, locked BIGINT(10) NOT NULL DEFAULT 0, locktime BIGINT(10) unsigned NOT NULL DEFAULT 0, needsupdate BIGINT(10) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_items_history COMMENT='History of grade_items'

Success

(mysql): CREATE INDEX ss_dbprefixgraditemhist_act_ix ON ss_dbprefixgrade_items_history (action)

Success

(mysql): CREATE INDEX ss_dbprefixgraditemhist_old_ix ON ss_dbprefixgrade_items_history (oldid)

Success

(mysql): CREATE INDEX ss_dbprefixgraditemhist_cou_ix ON ss_dbprefixgrade_items_history (courseid)

Success

(mysql): CREATE INDEX ss_dbprefixgraditemhist_cat_ix ON ss_dbprefixgrade_items_history (categoryid)

Success

(mysql): CREATE INDEX ss_dbprefixgraditemhist_sca_ix ON ss_dbprefixgrade_items_history (scaleid)

Success

(mysql): CREATE INDEX ss_dbprefixgraditemhist_out_ix ON ss_dbprefixgrade_items_history (outcomeid)

Success

(mysql): CREATE INDEX ss_dbprefixgraditemhist_log_ix ON ss_dbprefixgrade_items_history (loggeduser)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_grades_history ( id BIGINT(10) unsigned NOT NULL auto_increment, action BIGINT(10) unsigned NOT NULL DEFAULT 0, oldid BIGINT(10) unsigned NOT NULL, source VARCHAR(255) DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, loggeduser BIGINT(10) unsigned DEFAULT NULL, itemid BIGINT(10) unsigned NOT NULL, userid BIGINT(10) unsigned NOT NULL, rawgrade NUMERIC(10,5) DEFAULT NULL, rawgrademax NUMERIC(10,5) NOT NULL DEFAULT 100, rawgrademin NUMERIC(10,5) NOT NULL DEFAULT 0, rawscaleid BIGINT(10) unsigned DEFAULT NULL, usermodified BIGINT(10) unsigned DEFAULT NULL, finalgrade NUMERIC(10,5) DEFAULT NULL, hidden BIGINT(10) unsigned NOT NULL DEFAULT 0, locked BIGINT(10) unsigned NOT NULL DEFAULT 0, locktime BIGINT(10) unsigned NOT NULL DEFAULT 0, exported BIGINT(10) unsigned NOT NULL DEFAULT 0, overridden BIGINT(10) unsigned NOT NULL DEFAULT 0, excluded BIGINT(10) unsigned NOT NULL DEFAULT 0, feedback MEDIUMTEXT, feedbackformat BIGINT(10) unsigned NOT NULL DEFAULT 0, information MEDIUMTEXT, informationformat BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_grades_history COMMENT='History table'

Success

(mysql): CREATE INDEX ss_dbprefixgradgradhist_act_ix ON ss_dbprefixgrade_grades_history (action)

Success

(mysql): CREATE INDEX ss_dbprefixgradgradhist_old_ix ON ss_dbprefixgrade_grades_history (oldid)

Success

(mysql): CREATE INDEX ss_dbprefixgradgradhist_ite_ix ON ss_dbprefixgrade_grades_history (itemid)

Success

(mysql): CREATE INDEX ss_dbprefixgradgradhist_use_ix ON ss_dbprefixgrade_grades_history (userid)

Success

(mysql): CREATE INDEX ss_dbprefixgradgradhist_raw_ix ON ss_dbprefixgrade_grades_history (rawscaleid)

Success

(mysql): CREATE INDEX ss_dbprefixgradgradhist_us2_ix ON ss_dbprefixgrade_grades_history (usermodified)

Success

(mysql): CREATE INDEX ss_dbprefixgradgradhist_log_ix ON ss_dbprefixgrade_grades_history (loggeduser)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_import_newitem ( id BIGINT(10) unsigned NOT NULL auto_increment, itemname VARCHAR(255) NOT NULL DEFAULT '', importcode BIGINT(10) unsigned NOT NULL, importer BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_import_newitem COMMENT='temporary table for storing new grade_item names from grade '

Success

(mysql): CREATE INDEX ss_dbprefixgradimponewi_imp_ix ON ss_dbprefixgrade_import_newitem (importer)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_import_values ( id BIGINT(10) unsigned NOT NULL auto_increment, itemid BIGINT(10) unsigned DEFAULT NULL, newgradeitem BIGINT(10) unsigned DEFAULT NULL, userid BIGINT(10) unsigned NOT NULL, finalgrade NUMERIC(10,5) DEFAULT NULL, feedback MEDIUMTEXT, importcode BIGINT(10) unsigned NOT NULL, importer BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_import_values COMMENT='Temporary table for importing grades'

Success

(mysql): CREATE INDEX ss_dbprefixgradimpovalu_ite_ix ON ss_dbprefixgrade_import_values (itemid)

Success

(mysql): CREATE INDEX ss_dbprefixgradimpovalu_new_ix ON ss_dbprefixgrade_import_values (newgradeitem)

Success

(mysql): CREATE INDEX ss_dbprefixgradimpovalu_imp_ix ON ss_dbprefixgrade_import_values (importer)

Success

(mysql): CREATE TABLE ss_dbprefixtag ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL, name VARCHAR(255) NOT NULL DEFAULT '', rawname VARCHAR(255) NOT NULL DEFAULT '', tagtype VARCHAR(255) DEFAULT NULL, description TEXT, descriptionformat TINYINT(2) unsigned NOT NULL DEFAULT 0, flag SMALLINT(4) unsigned DEFAULT 0, timemodified BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixtag COMMENT='Tag table - this generic table will replace the old \"tags\" t'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixtag_nam_uix ON ss_dbprefixtag (name)

Success

(mysql): CREATE INDEX ss_dbprefixtag_use_ix ON ss_dbprefixtag (userid)

Success

(mysql): CREATE TABLE ss_dbprefixtag_correlation ( id BIGINT(10) unsigned NOT NULL auto_increment, tagid BIGINT(10) unsigned NOT NULL, correlatedtags TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixtag_correlation COMMENT='The rationale for the \'tag_correlation\' table is performance'

Success

(mysql): CREATE INDEX ss_dbprefixtagcorr_tag_ix ON ss_dbprefixtag_correlation (tagid)

Success

(mysql): CREATE TABLE ss_dbprefixtag_instance ( id BIGINT(10) unsigned NOT NULL auto_increment, tagid BIGINT(10) unsigned NOT NULL, itemtype VARCHAR(255) NOT NULL DEFAULT '', itemid BIGINT(10) unsigned NOT NULL, ordering BIGINT(10) unsigned DEFAULT NULL, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixtag_instance COMMENT='tag_instance table holds the information of associations bet'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixtaginst_iteitet_uix ON ss_dbprefixtag_instance (itemtype, itemid, tagid)

Success

(mysql): CREATE INDEX ss_dbprefixtaginst_tag_ix ON ss_dbprefixtag_instance (tagid)

Success

(mysql): CREATE TABLE ss_dbprefixgroups ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL, name VARCHAR(254) NOT NULL DEFAULT '', description TEXT, enrolmentkey VARCHAR(50) DEFAULT NULL, 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 ss_dbprefixgroups COMMENT='Each record represents a group.'

Success

(mysql): CREATE INDEX ss_dbprefixgrou_cou_ix ON ss_dbprefixgroups (courseid)

Success

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

Success

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

Success

(mysql): CREATE INDEX ss_dbprefixgrou_cou2_ix ON ss_dbprefixgroupings (courseid)

Success

(mysql): CREATE TABLE ss_dbprefixgroups_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 ss_dbprefixgroups_members COMMENT='Link a user to a group.'

Success

(mysql): CREATE INDEX ss_dbprefixgroumemb_gro_ix ON ss_dbprefixgroups_members (groupid)

Success

(mysql): CREATE INDEX ss_dbprefixgroumemb_use_ix ON ss_dbprefixgroups_members (userid)

Success

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

Success

(mysql): ALTER TABLE ss_dbprefixgroupings_groups COMMENT='Link a grouping to a group (note, groups can be in multiple '

Success

(mysql): CREATE INDEX ss_dbprefixgrougrou_gro_ix ON ss_dbprefixgroupings_groups (groupingid)

Success

(mysql): CREATE INDEX ss_dbprefixgrougrou_gro2_ix ON ss_dbprefixgroupings_groups (groupid)

Success

(mysql): CREATE TABLE ss_dbprefixuser_private_key ( id BIGINT(10) unsigned NOT NULL auto_increment, script VARCHAR(128) NOT NULL DEFAULT '', value VARCHAR(128) NOT NULL DEFAULT '', userid BIGINT(10) unsigned NOT NULL, instance BIGINT(10) unsigned DEFAULT NULL, iprestriction VARCHAR(255) DEFAULT NULL, validuntil BIGINT(10) unsigned DEFAULT NULL, timecreated BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixuser_private_key COMMENT='access keys used in cookieless scripts - rss, etc.'

Success

(mysql): CREATE INDEX ss_dbprefixuserprivkey_scrv_ix ON ss_dbprefixuser_private_key (script, value)

Success

(mysql): CREATE INDEX ss_dbprefixuserprivkey_use_ix ON ss_dbprefixuser_private_key (userid)

Success

(mysql): CREATE TABLE ss_dbprefixgrade_letters ( id BIGINT(10) unsigned NOT NULL auto_increment, contextid BIGINT(10) unsigned NOT NULL, lowerboundary NUMERIC(10,5) NOT NULL, letter VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixgrade_letters COMMENT='Repository for grade letters, for courses and other moodle e'

Success

(mysql): CREATE INDEX ss_dbprefixgradlett_conlow_ix ON ss_dbprefixgrade_letters (contextid, lowerboundary)

Success

(mysql): CREATE TABLE ss_dbprefixcache_flags ( id BIGINT(10) unsigned NOT NULL auto_increment, flagtype VARCHAR(255) NOT NULL DEFAULT '', name VARCHAR(255) NOT NULL DEFAULT '', timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, value MEDIUMTEXT NOT NULL, expiry BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixcache_flags COMMENT='Cache of time-sensitive flags'

Success

(mysql): CREATE INDEX ss_dbprefixcachflag_fla_ix ON ss_dbprefixcache_flags (flagtype)

Success

(mysql): CREATE INDEX ss_dbprefixcachflag_nam_ix ON ss_dbprefixcache_flags (name)

Success

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

Success

(mysql): ALTER TABLE ss_dbprefixgrade_settings COMMENT='gradebook settings'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixgradsett_counam_uix ON ss_dbprefixgrade_settings (courseid, name)

Success

(mysql): CREATE INDEX ss_dbprefixgradsett_cou_ix ON ss_dbprefixgrade_settings (courseid)

Success

(mysql): CREATE TABLE ss_dbprefixwebdav_locks ( id BIGINT(10) unsigned NOT NULL auto_increment, token VARCHAR(255) NOT NULL DEFAULT '', path VARCHAR(255) NOT NULL DEFAULT '', expiry BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, recursive TINYINT(1) unsigned NOT NULL DEFAULT 0, exclusivelock TINYINT(1) unsigned NOT NULL DEFAULT 0, created BIGINT(10) unsigned NOT NULL DEFAULT 0, modified BIGINT(10) unsigned NOT NULL DEFAULT 0, owner VARCHAR(255) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixwebdav_locks COMMENT='Resource locks for WebDAV users'

Success

(mysql): CREATE INDEX ss_dbprefixwebdlock_pat_ix ON ss_dbprefixwebdav_locks (path)

Success

(mysql): CREATE INDEX ss_dbprefixwebdlock_exp_ix ON ss_dbprefixwebdav_locks (expiry)

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixwebdlock_tok_uix ON ss_dbprefixwebdav_locks (token)

Success

(mysql): INSERT INTO ss_dbprefixmnet_application(name, display_name, xmlrpc_server_url, sso_land_url) VALUES ('moodle', 'Moodle', '/mnet/xmlrpc/server.php', '/auth/mnet/land.php')

Success

(mysql): INSERT INTO ss_dbprefixmnet_application(name, display_name, xmlrpc_server_url, sso_land_url) VALUES ('mahara', 'Mahara', '/api/xmlrpc/server.php', '/auth/xmlrpc/land.php')

Success

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

Success

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

Success

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

Success

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

Success

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

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('course', 'unenrol', 'course', 'fullname')

Success

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

Success

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

Success

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

Success

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

Success

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

Success

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

Success

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

Success

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

Success

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

Success

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

Success

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

Success

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

Success

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

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

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

(mysql): SELECT LAST_INSERT_ID()

Database was successfully upgraded

assignment

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixassignment ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NOT NULL, format SMALLINT(4) unsigned NOT NULL DEFAULT 0, assignmenttype VARCHAR(50) NOT NULL DEFAULT '', resubmit TINYINT(2) unsigned NOT NULL DEFAULT 0, preventlate TINYINT(2) unsigned NOT NULL DEFAULT 0, emailteachers TINYINT(2) unsigned NOT NULL DEFAULT 0, var1 BIGINT(10) DEFAULT 0, var2 BIGINT(10) DEFAULT 0, var3 BIGINT(10) DEFAULT 0, var4 BIGINT(10) DEFAULT 0, var5 BIGINT(10) DEFAULT 0, maxbytes BIGINT(10) unsigned NOT NULL DEFAULT 100000, timedue BIGINT(10) unsigned NOT NULL DEFAULT 0, timeavailable BIGINT(10) unsigned NOT NULL DEFAULT 0, grade BIGINT(10) NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixassignment COMMENT='Defines assignments'

Success

(mysql): CREATE INDEX ss_dbprefixassi_cou_ix ON ss_dbprefixassignment (course)

Success

(mysql): CREATE TABLE ss_dbprefixassignment_submissions ( id BIGINT(10) unsigned NOT NULL auto_increment, assignment BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, numfiles BIGINT(10) unsigned NOT NULL DEFAULT 0, data1 TEXT, data2 TEXT, grade BIGINT(11) NOT NULL DEFAULT 0, submissioncomment TEXT NOT NULL, format SMALLINT(4) unsigned NOT NULL DEFAULT 0, teacher BIGINT(10) unsigned NOT NULL DEFAULT 0, timemarked BIGINT(10) unsigned NOT NULL DEFAULT 0, mailed TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixassignment_submissions COMMENT='Info about submitted assignments'

Success

(mysql): CREATE INDEX ss_dbprefixassisubm_use_ix ON ss_dbprefixassignment_submissions (userid)

Success

(mysql): CREATE INDEX ss_dbprefixassisubm_mai_ix ON ss_dbprefixassignment_submissions (mailed)

Success

(mysql): CREATE INDEX ss_dbprefixassisubm_tim_ix ON ss_dbprefixassignment_submissions (timemarked)

Success

(mysql): CREATE INDEX ss_dbprefixassisubm_ass_ix ON ss_dbprefixassignment_submissions (assignment)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('assignment', 'view submission', 'assignment', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name')

Success

assignment tables have been set up correctly

mod/assignment/type/online plugin needs upgrading

online tables have been set up correctly

chat

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixchat ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', intro TEXT NOT NULL, keepdays BIGINT(11) NOT NULL DEFAULT 0, studentlogs SMALLINT(4) NOT NULL DEFAULT 0, chattime BIGINT(10) unsigned NOT NULL DEFAULT 0, schedule SMALLINT(4) NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixchat COMMENT='Each of these is a chat room'

Success

(mysql): CREATE INDEX ss_dbprefixchat_cou_ix ON ss_dbprefixchat (course)

Success

(mysql): CREATE TABLE ss_dbprefixchat_messages ( id BIGINT(10) unsigned NOT NULL auto_increment, chatid BIGINT(10) NOT NULL DEFAULT 0, userid BIGINT(10) NOT NULL DEFAULT 0, groupid BIGINT(10) NOT NULL DEFAULT 0, system TINYINT(1) unsigned NOT NULL DEFAULT 0, message TEXT NOT NULL, timestamp BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixchat_messages COMMENT='Stores all the actual chat messages'

Success

(mysql): CREATE INDEX ss_dbprefixchatmess_use_ix ON ss_dbprefixchat_messages (userid)

Success

(mysql): CREATE INDEX ss_dbprefixchatmess_gro_ix ON ss_dbprefixchat_messages (groupid)

Success

(mysql): CREATE INDEX ss_dbprefixchatmess_timcha_ix ON ss_dbprefixchat_messages (timestamp, chatid)

Success

(mysql): CREATE INDEX ss_dbprefixchatmess_cha_ix ON ss_dbprefixchat_messages (chatid)

Success

(mysql): CREATE TABLE ss_dbprefixchat_users ( id BIGINT(10) unsigned NOT NULL auto_increment, chatid BIGINT(11) NOT NULL DEFAULT 0, userid BIGINT(11) NOT NULL DEFAULT 0, groupid BIGINT(11) NOT NULL DEFAULT 0, version VARCHAR(16) NOT NULL DEFAULT '', ip VARCHAR(15) NOT NULL DEFAULT '', firstping BIGINT(10) unsigned NOT NULL DEFAULT 0, lastping BIGINT(10) unsigned NOT NULL DEFAULT 0, lastmessageping BIGINT(10) unsigned NOT NULL DEFAULT 0, sid VARCHAR(32) NOT NULL DEFAULT '', course BIGINT(10) unsigned NOT NULL DEFAULT 0, lang VARCHAR(30) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixchat_users COMMENT='Keeps track of which users are in which chat rooms'

Success

(mysql): CREATE INDEX ss_dbprefixchatuser_use_ix ON ss_dbprefixchat_users (userid)

Success

(mysql): CREATE INDEX ss_dbprefixchatuser_las_ix ON ss_dbprefixchat_users (lastping)

Success

(mysql): CREATE INDEX ss_dbprefixchatuser_gro_ix ON ss_dbprefixchat_users (groupid)

Success

(mysql): CREATE INDEX ss_dbprefixchatuser_cha_ix ON ss_dbprefixchat_users (chatid)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('chat', 'view', 'chat', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('chat', 'add', 'chat', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('chat', 'update', 'chat', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('chat', 'report', 'chat', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('chat', 'talk', 'chat', 'name')

Success

chat tables have been set up correctly

choice

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixchoice ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', text TEXT NOT NULL, format TINYINT(2) unsigned NOT NULL DEFAULT 0, publish TINYINT(2) unsigned NOT NULL DEFAULT 0, showresults TINYINT(2) unsigned NOT NULL DEFAULT 0, display SMALLINT(4) unsigned NOT NULL DEFAULT 0, allowupdate TINYINT(2) unsigned NOT NULL DEFAULT 0, showunanswered TINYINT(2) unsigned NOT NULL DEFAULT 0, limitanswers TINYINT(2) unsigned NOT NULL DEFAULT 0, timeopen BIGINT(10) unsigned NOT NULL DEFAULT 0, timeclose BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixchoice COMMENT='Available choices are stored here'

Success

(mysql): CREATE INDEX ss_dbprefixchoi_cou_ix ON ss_dbprefixchoice (course)

Success

(mysql): CREATE TABLE ss_dbprefixchoice_options ( id BIGINT(10) unsigned NOT NULL auto_increment, choiceid BIGINT(10) unsigned NOT NULL DEFAULT 0, text TEXT, maxanswers BIGINT(10) unsigned DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixchoice_options COMMENT='available options to choice'

Success

(mysql): CREATE INDEX ss_dbprefixchoiopti_cho_ix ON ss_dbprefixchoice_options (choiceid)

Success

(mysql): CREATE TABLE ss_dbprefixchoice_answers ( id BIGINT(10) unsigned NOT NULL auto_increment, choiceid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, optionid BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixchoice_answers COMMENT='choices performed by users'

Success

(mysql): CREATE INDEX ss_dbprefixchoiansw_use_ix ON ss_dbprefixchoice_answers (userid)

Success

(mysql): CREATE INDEX ss_dbprefixchoiansw_cho_ix ON ss_dbprefixchoice_answers (choiceid)

Success

(mysql): CREATE INDEX ss_dbprefixchoiansw_opt_ix ON ss_dbprefixchoice_answers (optionid)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('choice', 'view', 'choice', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('choice', 'update', 'choice', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('choice', 'add', 'choice', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('choice', 'report', 'choice', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('choice', 'choose', 'choice', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('choice', 'choose again', 'choice', 'name')

Success

choice tables have been set up correctly

data

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixdata ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', intro TEXT NOT NULL, comments SMALLINT(4) unsigned NOT NULL DEFAULT 0, timeavailablefrom BIGINT(10) unsigned NOT NULL DEFAULT 0, timeavailableto BIGINT(10) unsigned NOT NULL DEFAULT 0, timeviewfrom BIGINT(10) unsigned NOT NULL DEFAULT 0, timeviewto BIGINT(10) unsigned NOT NULL DEFAULT 0, requiredentries INT(8) unsigned NOT NULL DEFAULT 0, requiredentriestoview INT(8) unsigned NOT NULL DEFAULT 0, maxentries INT(8) unsigned NOT NULL DEFAULT 0, rssarticles SMALLINT(4) unsigned NOT NULL DEFAULT 0, singletemplate TEXT, listtemplate TEXT, listtemplateheader TEXT, listtemplatefooter TEXT, addtemplate TEXT, rsstemplate TEXT, rsstitletemplate TEXT, csstemplate TEXT, jstemplate TEXT, asearchtemplate TEXT, approval SMALLINT(4) unsigned NOT NULL DEFAULT 0, scale BIGINT(10) NOT NULL DEFAULT 0, assessed BIGINT(10) unsigned NOT NULL DEFAULT 0, defaultsort BIGINT(10) unsigned NOT NULL DEFAULT 0, defaultsortdir SMALLINT(4) unsigned NOT NULL DEFAULT 0, editany SMALLINT(4) unsigned NOT NULL DEFAULT 0, notification BIGINT(10) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixdata COMMENT='Removed ratings column'

Success

(mysql): CREATE INDEX ss_dbprefixdata_cou_ix ON ss_dbprefixdata (course)

Success

(mysql): CREATE TABLE ss_dbprefixdata_fields ( id BIGINT(10) unsigned NOT NULL auto_increment, dataid BIGINT(10) unsigned NOT NULL DEFAULT 0, type VARCHAR(255) NOT NULL DEFAULT '', name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NOT NULL, param1 TEXT, param2 TEXT, param3 TEXT, param4 TEXT, param5 TEXT, param6 TEXT, param7 TEXT, param8 TEXT, param9 TEXT, param10 TEXT, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixdata_fields COMMENT='every field available'

Success

(mysql): CREATE INDEX ss_dbprefixdatafiel_typdat_ix ON ss_dbprefixdata_fields (type, dataid)

Success

(mysql): CREATE INDEX ss_dbprefixdatafiel_dat_ix ON ss_dbprefixdata_fields (dataid)

Success

(mysql): CREATE TABLE ss_dbprefixdata_records ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupid BIGINT(10) unsigned NOT NULL DEFAULT 0, dataid BIGINT(10) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, approved SMALLINT(4) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixdata_records COMMENT='every record introduced'

Success

(mysql): CREATE INDEX ss_dbprefixdatareco_dat_ix ON ss_dbprefixdata_records (dataid)

Success

(mysql): CREATE TABLE ss_dbprefixdata_content ( id BIGINT(10) unsigned NOT NULL auto_increment, fieldid BIGINT(10) unsigned NOT NULL DEFAULT 0, recordid BIGINT(10) unsigned NOT NULL DEFAULT 0, content LONGTEXT, content1 LONGTEXT, content2 LONGTEXT, content3 LONGTEXT, content4 LONGTEXT, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixdata_content COMMENT='the content introduced in each record/fields'

Success

(mysql): CREATE INDEX ss_dbprefixdatacont_rec_ix ON ss_dbprefixdata_content (recordid)

Success

(mysql): CREATE INDEX ss_dbprefixdatacont_fie_ix ON ss_dbprefixdata_content (fieldid)

Success

(mysql): CREATE TABLE ss_dbprefixdata_comments ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, recordid BIGINT(10) unsigned NOT NULL DEFAULT 0, content TEXT NOT NULL, format TINYINT(2) unsigned NOT NULL DEFAULT 0, created BIGINT(10) unsigned NOT NULL DEFAULT 0, modified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixdata_comments COMMENT='to comment data records'

Success

(mysql): CREATE INDEX ss_dbprefixdatacomm_rec_ix ON ss_dbprefixdata_comments (recordid)

Success

(mysql): CREATE TABLE ss_dbprefixdata_ratings ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, recordid BIGINT(10) unsigned NOT NULL DEFAULT 0, rating BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixdata_ratings COMMENT='to rate data records'

Success

(mysql): CREATE INDEX ss_dbprefixdatarati_rec_ix ON ss_dbprefixdata_ratings (recordid)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('data', 'view', 'data', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('data', 'add', 'data', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('data', 'update', 'data', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('data', 'record delete', 'data', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('data', 'fields add', 'data_fields', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('data', 'fields update', 'data_fields', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('data', 'templates saved', 'data', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('data', 'templates def', 'data', 'name')

Success

data tables have been set up correctly

forum

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixforum ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, type enum('single', 'news', 'general', 'social', 'eachuser', 'teacher', 'qanda') NOT NULL DEFAULT 'general', name VARCHAR(255) NOT NULL DEFAULT '', intro TEXT NOT NULL, assessed BIGINT(10) unsigned NOT NULL DEFAULT 0, assesstimestart BIGINT(10) unsigned NOT NULL DEFAULT 0, assesstimefinish BIGINT(10) unsigned NOT NULL DEFAULT 0, scale BIGINT(10) NOT NULL DEFAULT 0, maxbytes BIGINT(10) unsigned NOT NULL DEFAULT 0, forcesubscribe TINYINT(1) unsigned NOT NULL DEFAULT 0, trackingtype TINYINT(2) unsigned NOT NULL DEFAULT 1, rsstype TINYINT(2) unsigned NOT NULL DEFAULT 0, rssarticles TINYINT(2) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, warnafter BIGINT(10) unsigned NOT NULL DEFAULT 0, blockafter BIGINT(10) unsigned NOT NULL DEFAULT 0, blockperiod BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixforum COMMENT='Forums contain and structure discussion'

Success

(mysql): CREATE INDEX ss_dbprefixforu_cou_ix ON ss_dbprefixforum (course)

Success

(mysql): CREATE TABLE ss_dbprefixforum_discussions ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, forum BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', firstpost BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupid BIGINT(10) NOT NULL DEFAULT -1, assessed TINYINT(1) NOT NULL DEFAULT 1, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, usermodified BIGINT(10) unsigned NOT NULL DEFAULT 0, timestart BIGINT(10) unsigned NOT NULL DEFAULT 0, timeend BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixforum_discussions COMMENT='Forums are composed of discussions'

Success

(mysql): CREATE INDEX ss_dbprefixforudisc_use_ix ON ss_dbprefixforum_discussions (userid)

Success

(mysql): CREATE INDEX ss_dbprefixforudisc_for_ix ON ss_dbprefixforum_discussions (forum)

Success

(mysql): CREATE TABLE ss_dbprefixforum_posts ( id BIGINT(10) unsigned NOT NULL auto_increment, discussion BIGINT(10) unsigned NOT NULL DEFAULT 0, parent BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, created BIGINT(10) unsigned NOT NULL DEFAULT 0, modified BIGINT(10) unsigned NOT NULL DEFAULT 0, mailed TINYINT(2) unsigned NOT NULL DEFAULT 0, subject VARCHAR(255) NOT NULL DEFAULT '', message TEXT NOT NULL, format TINYINT(2) NOT NULL DEFAULT 0, attachment VARCHAR(100) NOT NULL DEFAULT '', totalscore SMALLINT(4) NOT NULL DEFAULT 0, mailnow BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixforum_posts COMMENT='All posts are stored in this table'

Success

(mysql): CREATE INDEX ss_dbprefixforupost_use_ix ON ss_dbprefixforum_posts (userid)

Success

(mysql): CREATE INDEX ss_dbprefixforupost_cre_ix ON ss_dbprefixforum_posts (created)

Success

(mysql): CREATE INDEX ss_dbprefixforupost_mai_ix ON ss_dbprefixforum_posts (mailed)

Success

(mysql): CREATE INDEX ss_dbprefixforupost_dis_ix ON ss_dbprefixforum_posts (discussion)

Success

(mysql): CREATE INDEX ss_dbprefixforupost_par_ix ON ss_dbprefixforum_posts (parent)

Success

(mysql): CREATE TABLE ss_dbprefixforum_queue ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, discussionid BIGINT(10) unsigned NOT NULL DEFAULT 0, postid BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixforum_queue COMMENT='For keeping track of posts that will be mailed in digest for'

Success

(mysql): CREATE INDEX ss_dbprefixforuqueu_use_ix ON ss_dbprefixforum_queue (userid)

Success

(mysql): CREATE INDEX ss_dbprefixforuqueu_dis_ix ON ss_dbprefixforum_queue (discussionid)

Success

(mysql): CREATE INDEX ss_dbprefixforuqueu_pos_ix ON ss_dbprefixforum_queue (postid)

Success

(mysql): CREATE TABLE ss_dbprefixforum_ratings ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, post BIGINT(10) unsigned NOT NULL DEFAULT 0, time BIGINT(10) unsigned NOT NULL DEFAULT 0, rating SMALLINT(4) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixforum_ratings COMMENT='forum_ratings table retrofitted from MySQL'

Success

(mysql): CREATE INDEX ss_dbprefixforurati_use_ix ON ss_dbprefixforum_ratings (userid)

Success

(mysql): CREATE INDEX ss_dbprefixforurati_pos_ix ON ss_dbprefixforum_ratings (post)

Success

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

Success

(mysql): ALTER TABLE ss_dbprefixforum_subscriptions COMMENT='Keeps track of who is subscribed to what forum'

Success

(mysql): CREATE INDEX ss_dbprefixforusubs_use_ix ON ss_dbprefixforum_subscriptions (userid)

Success

(mysql): CREATE INDEX ss_dbprefixforusubs_for_ix ON ss_dbprefixforum_subscriptions (forum)

Success

(mysql): CREATE TABLE ss_dbprefixforum_read ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, forumid BIGINT(10) unsigned NOT NULL DEFAULT 0, discussionid BIGINT(10) unsigned NOT NULL DEFAULT 0, postid BIGINT(10) unsigned NOT NULL DEFAULT 0, firstread BIGINT(10) unsigned NOT NULL DEFAULT 0, lastread BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixforum_read COMMENT='Tracks each users read posts'

Success

(mysql): CREATE INDEX ss_dbprefixforuread_usefor_ix ON ss_dbprefixforum_read (userid, forumid)

Success

(mysql): CREATE INDEX ss_dbprefixforuread_usedis_ix ON ss_dbprefixforum_read (userid, discussionid)

Success

(mysql): CREATE INDEX ss_dbprefixforuread_usepos_ix ON ss_dbprefixforum_read (userid, postid)

Success

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

Success

(mysql): ALTER TABLE ss_dbprefixforum_track_prefs COMMENT='Tracks each users untracked forums'

Success

(mysql): CREATE INDEX ss_dbprefixforutracpref_use_ix ON ss_dbprefixforum_track_prefs (userid, forumid)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('forum', 'add', 'forum', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('forum', 'update', 'forum', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('forum', 'add discussion', 'forum_discussions', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('forum', 'add post', 'forum_posts', 'subject')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('forum', 'update post', 'forum_posts', 'subject')

Success

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

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('forum', 'move discussion', 'forum_discussions', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('forum', 'view subscribers', 'forum', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('forum', 'view discussion', 'forum_discussions', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('forum', 'view forum', 'forum', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('forum', 'subscribe', 'forum', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('forum', 'unsubscribe', 'forum', 'name')

Success

forum tables have been set up correctly

glossary

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixglossary ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', intro TEXT NOT NULL, allowduplicatedentries TINYINT(2) unsigned NOT NULL DEFAULT 0, displayformat VARCHAR(50) NOT NULL DEFAULT 'dictionary', mainglossary TINYINT(2) unsigned NOT NULL DEFAULT 0, showspecial TINYINT(2) unsigned NOT NULL DEFAULT 1, showalphabet TINYINT(2) unsigned NOT NULL DEFAULT 1, showall TINYINT(2) unsigned NOT NULL DEFAULT 1, allowcomments TINYINT(2) unsigned NOT NULL DEFAULT 0, allowprintview TINYINT(2) unsigned NOT NULL DEFAULT 1, usedynalink TINYINT(2) unsigned NOT NULL DEFAULT 1, defaultapproval TINYINT(2) unsigned NOT NULL DEFAULT 1, globalglossary TINYINT(2) unsigned NOT NULL DEFAULT 0, entbypage SMALLINT(3) unsigned NOT NULL DEFAULT 10, editalways TINYINT(2) unsigned NOT NULL DEFAULT 0, rsstype TINYINT(2) unsigned NOT NULL DEFAULT 0, rssarticles TINYINT(2) unsigned NOT NULL DEFAULT 0, assessed BIGINT(10) unsigned NOT NULL DEFAULT 0, assesstimestart BIGINT(10) unsigned NOT NULL DEFAULT 0, assesstimefinish BIGINT(10) unsigned NOT NULL DEFAULT 0, scale BIGINT(10) 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 ss_dbprefixglossary COMMENT='all glossaries'

Success

(mysql): CREATE INDEX ss_dbprefixglos_cou_ix ON ss_dbprefixglossary (course)

Success

(mysql): CREATE TABLE ss_dbprefixglossary_entries ( id BIGINT(10) unsigned NOT NULL auto_increment, glossaryid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, concept VARCHAR(255) NOT NULL DEFAULT '', definition TEXT NOT NULL, format TINYINT(2) unsigned NOT NULL DEFAULT 0, attachment VARCHAR(100) NOT NULL DEFAULT '', timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, teacherentry TINYINT(2) unsigned NOT NULL DEFAULT 0, sourceglossaryid BIGINT(10) unsigned NOT NULL DEFAULT 0, usedynalink TINYINT(2) unsigned NOT NULL DEFAULT 1, casesensitive TINYINT(2) unsigned NOT NULL DEFAULT 0, fullmatch TINYINT(2) unsigned NOT NULL DEFAULT 1, approved TINYINT(2) unsigned NOT NULL DEFAULT 1, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixglossary_entries COMMENT='all glossary entries'

Success

(mysql): CREATE INDEX ss_dbprefixglosentr_use_ix ON ss_dbprefixglossary_entries (userid)

Success

(mysql): CREATE INDEX ss_dbprefixglosentr_con_ix ON ss_dbprefixglossary_entries (concept)

Success

(mysql): CREATE INDEX ss_dbprefixglosentr_glo_ix ON ss_dbprefixglossary_entries (glossaryid)

Success

(mysql): CREATE TABLE ss_dbprefixglossary_alias ( id BIGINT(10) unsigned NOT NULL auto_increment, entryid BIGINT(10) unsigned NOT NULL DEFAULT 0, alias VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixglossary_alias COMMENT='entries alias'

Success

(mysql): CREATE INDEX ss_dbprefixglosalia_ent_ix ON ss_dbprefixglossary_alias (entryid)

Success

(mysql): CREATE TABLE ss_dbprefixglossary_categories ( id BIGINT(10) unsigned NOT NULL auto_increment, glossaryid BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', usedynalink TINYINT(2) unsigned NOT NULL DEFAULT 1, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixglossary_categories COMMENT='all categories for glossary entries'

Success

(mysql): CREATE INDEX ss_dbprefixgloscate_glo_ix ON ss_dbprefixglossary_categories (glossaryid)

Success

(mysql): CREATE TABLE ss_dbprefixglossary_entries_categories ( id BIGINT(10) unsigned NOT NULL auto_increment, categoryid BIGINT(10) unsigned NOT NULL DEFAULT 0, entryid BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixglossary_entries_categories COMMENT='categories of each glossary entry'

Success

(mysql): CREATE INDEX ss_dbprefixglosentrcate_cat_ix ON ss_dbprefixglossary_entries_categories (categoryid)

Success

(mysql): CREATE INDEX ss_dbprefixglosentrcate_ent_ix ON ss_dbprefixglossary_entries_categories (entryid)

Success

(mysql): CREATE TABLE ss_dbprefixglossary_comments ( id BIGINT(10) unsigned NOT NULL auto_increment, entryid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, entrycomment TEXT NOT NULL, format TINYINT(2) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixglossary_comments COMMENT='comments on glossary entries'

Success

(mysql): CREATE INDEX ss_dbprefixgloscomm_use_ix ON ss_dbprefixglossary_comments (userid)

Success

(mysql): CREATE INDEX ss_dbprefixgloscomm_ent_ix ON ss_dbprefixglossary_comments (entryid)

Success

(mysql): CREATE TABLE ss_dbprefixglossary_formats ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(50) NOT NULL DEFAULT '', popupformatname VARCHAR(50) NOT NULL DEFAULT '', visible TINYINT(2) unsigned NOT NULL DEFAULT 1, showgroup TINYINT(2) unsigned NOT NULL DEFAULT 1, defaultmode VARCHAR(50) NOT NULL DEFAULT '', defaulthook VARCHAR(50) NOT NULL DEFAULT '', sortkey VARCHAR(50) NOT NULL DEFAULT '', sortorder VARCHAR(50) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixglossary_formats COMMENT='Setting of the display formats'

Success

(mysql): CREATE TABLE ss_dbprefixglossary_ratings ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, entryid BIGINT(10) unsigned NOT NULL DEFAULT 0, time BIGINT(10) unsigned NOT NULL DEFAULT 0, rating SMALLINT(4) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixglossary_ratings COMMENT='Contains user ratings for entries'

Success

(mysql): CREATE INDEX ss_dbprefixglosrati_use_ix ON ss_dbprefixglossary_ratings (userid)

Success

(mysql): CREATE INDEX ss_dbprefixglosrati_ent_ix ON ss_dbprefixglossary_ratings (entryid)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'add', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'update', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'view', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'view all', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'add entry', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'update entry', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'add category', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'update category', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'delete category', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'add comment', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'update comment', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'delete comment', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'approve entry', 'glossary', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('glossary', 'view entry', 'glossary_entries', 'concept')

Success

glossary tables have been set up correctly

hotpot

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixhotpot ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', summary TEXT NOT NULL, timeopen BIGINT(10) unsigned NOT NULL DEFAULT 0, timeclose BIGINT(10) unsigned NOT NULL DEFAULT 0, location SMALLINT(4) unsigned NOT NULL DEFAULT 0, reference VARCHAR(255) NOT NULL DEFAULT '', outputformat SMALLINT(4) unsigned NOT NULL DEFAULT 1, navigation SMALLINT(4) unsigned NOT NULL DEFAULT 1, studentfeedback SMALLINT(4) unsigned NOT NULL DEFAULT 0, studentfeedbackurl VARCHAR(255) NOT NULL DEFAULT '', forceplugins SMALLINT(4) unsigned NOT NULL DEFAULT 0, shownextquiz SMALLINT(4) unsigned NOT NULL DEFAULT 0, review SMALLINT(4) NOT NULL DEFAULT 0, grade BIGINT(10) NOT NULL DEFAULT 0, grademethod SMALLINT(4) NOT NULL DEFAULT 1, attempts MEDIUMINT(6) NOT NULL DEFAULT 0, password VARCHAR(255) NOT NULL DEFAULT '', subnet VARCHAR(255) NOT NULL DEFAULT '', clickreporting SMALLINT(4) 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 ss_dbprefixhotpot COMMENT='details about Hot Potatoes quizzes'

Success

(mysql): CREATE TABLE ss_dbprefixhotpot_attempts ( id BIGINT(10) unsigned NOT NULL auto_increment, hotpot BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, starttime BIGINT(10) unsigned NOT NULL DEFAULT 0, endtime BIGINT(10) unsigned NOT NULL DEFAULT 0, score MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, penalties MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, attempt MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, timestart BIGINT(10) unsigned NOT NULL DEFAULT 0, timefinish BIGINT(10) unsigned NOT NULL DEFAULT 0, status SMALLINT(4) unsigned NOT NULL DEFAULT 1, clickreportid BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixhotpot_attempts COMMENT='details about Hot Potatoes quiz attempts'

Success

(mysql): CREATE INDEX ss_dbprefixhotpatte_use_ix ON ss_dbprefixhotpot_attempts (userid)

Success

(mysql): CREATE INDEX ss_dbprefixhotpatte_hot_ix ON ss_dbprefixhotpot_attempts (hotpot)

Success

(mysql): CREATE TABLE ss_dbprefixhotpot_details ( id BIGINT(10) unsigned NOT NULL auto_increment, attempt BIGINT(10) unsigned NOT NULL DEFAULT 0, details TEXT, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixhotpot_details COMMENT='raw details (as XML) of Hot Potatoes quiz attempts'

Success

(mysql): CREATE INDEX ss_dbprefixhotpdeta_att_ix ON ss_dbprefixhotpot_details (attempt)

Success

(mysql): CREATE TABLE ss_dbprefixhotpot_questions ( id BIGINT(10) unsigned NOT NULL auto_increment, name TEXT NOT NULL, type SMALLINT(4) unsigned NOT NULL DEFAULT 0, text BIGINT(10) unsigned NOT NULL DEFAULT 0, hotpot BIGINT(10) unsigned NOT NULL DEFAULT 0, md5key VARCHAR(32) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixhotpot_questions COMMENT='details about questions in Hot Potatoes quiz attempts'

Success

(mysql): CREATE INDEX ss_dbprefixhotpques_md5_ix ON ss_dbprefixhotpot_questions (md5key)

Success

(mysql): CREATE INDEX ss_dbprefixhotpques_hot_ix ON ss_dbprefixhotpot_questions (hotpot)

Success

(mysql): CREATE TABLE ss_dbprefixhotpot_responses ( id BIGINT(10) unsigned NOT NULL auto_increment, attempt BIGINT(10) unsigned NOT NULL DEFAULT 0, question BIGINT(10) unsigned NOT NULL DEFAULT 0, score MEDIUMINT(6) NOT NULL DEFAULT 0, weighting MEDIUMINT(6) NOT NULL DEFAULT 0, correct VARCHAR(255) NOT NULL DEFAULT '', wrong VARCHAR(255) NOT NULL DEFAULT '', ignored VARCHAR(255) NOT NULL DEFAULT '', hints MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, clues MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, checks MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixhotpot_responses COMMENT='details about responses in Hot Potatoes quiz attempts'

Success

(mysql): CREATE INDEX ss_dbprefixhotpresp_att_ix ON ss_dbprefixhotpot_responses (attempt)

Success

(mysql): CREATE INDEX ss_dbprefixhotpresp_que_ix ON ss_dbprefixhotpot_responses (question)

Success

(mysql): CREATE TABLE ss_dbprefixhotpot_strings ( id BIGINT(10) unsigned NOT NULL auto_increment, string TEXT NOT NULL, md5key VARCHAR(32) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixhotpot_strings COMMENT='strings used in Hot Potatoes questions and responses'

Success

(mysql): CREATE INDEX ss_dbprefixhotpstri_md5_ix ON ss_dbprefixhotpot_strings (md5key)

Success

hotpot tables have been set up correctly

journal

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixjournal ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', intro TEXT NOT NULL, introformat TINYINT(2) NOT NULL DEFAULT 0, days MEDIUMINT(5) unsigned NOT NULL DEFAULT 7, assessed BIGINT(10) NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixjournal COMMENT='data for each journal'

Success

(mysql): CREATE INDEX ss_dbprefixjour_cou_ix ON ss_dbprefixjournal (course)

Success

(mysql): CREATE TABLE ss_dbprefixjournal_entries ( id BIGINT(10) unsigned NOT NULL auto_increment, journal BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, modified BIGINT(10) unsigned NOT NULL DEFAULT 0, text TEXT NOT NULL, format TINYINT(2) NOT NULL DEFAULT 0, rating BIGINT(10) DEFAULT 0, entrycomment TEXT, teacher BIGINT(10) unsigned NOT NULL DEFAULT 0, timemarked BIGINT(10) unsigned NOT NULL DEFAULT 0, mailed TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixjournal_entries COMMENT='All the journal entries of all people'

Success

(mysql): CREATE INDEX ss_dbprefixjourentr_use_ix ON ss_dbprefixjournal_entries (userid)

Success

(mysql): CREATE INDEX ss_dbprefixjourentr_jou_ix ON ss_dbprefixjournal_entries (journal)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('journal', 'view', 'journal', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('journal', 'add entry', 'journal', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('journal', 'update entry', 'journal', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('journal', 'view responses', 'journal', 'name')

Success

journal tables have been set up correctly

label

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixlabel ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', content TEXT NOT NULL, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixlabel COMMENT='Defines labels'

Success

(mysql): CREATE INDEX ss_dbprefixlabe_cou_ix ON ss_dbprefixlabel (course)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('label', 'add', 'label', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('label', 'update', 'label', 'name')

Success

label tables have been set up correctly

lams

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixlams ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', introduction TEXT NOT NULL, learning_session_id BIGINT(20) DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixlams COMMENT='LAMS activity'

Success

(mysql): CREATE INDEX ss_dbprefixlams_cou_ix ON ss_dbprefixlams (course)

Success

lams tables have been set up correctly

lesson

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixlesson ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', practice SMALLINT(3) unsigned NOT NULL DEFAULT 0, modattempts SMALLINT(3) unsigned NOT NULL DEFAULT 0, usepassword SMALLINT(3) unsigned NOT NULL DEFAULT 0, password VARCHAR(32) NOT NULL DEFAULT '', dependency BIGINT(10) unsigned NOT NULL DEFAULT 0, conditions TEXT NOT NULL, grade SMALLINT(3) NOT NULL DEFAULT 0, custom SMALLINT(3) unsigned NOT NULL DEFAULT 0, ongoing SMALLINT(3) unsigned NOT NULL DEFAULT 0, usemaxgrade SMALLINT(3) NOT NULL DEFAULT 0, maxanswers SMALLINT(3) unsigned NOT NULL DEFAULT 4, maxattempts SMALLINT(3) unsigned NOT NULL DEFAULT 5, review SMALLINT(3) unsigned NOT NULL DEFAULT 0, nextpagedefault SMALLINT(3) unsigned NOT NULL DEFAULT 0, feedback SMALLINT(3) unsigned NOT NULL DEFAULT 1, minquestions SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxpages SMALLINT(3) unsigned NOT NULL DEFAULT 0, timed SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxtime BIGINT(10) unsigned NOT NULL DEFAULT 0, retake SMALLINT(3) unsigned NOT NULL DEFAULT 1, activitylink BIGINT(10) unsigned NOT NULL DEFAULT 0, mediafile VARCHAR(255) NOT NULL DEFAULT '', mediaheight BIGINT(10) unsigned NOT NULL DEFAULT 100, mediawidth BIGINT(10) unsigned NOT NULL DEFAULT 650, mediaclose SMALLINT(3) unsigned NOT NULL DEFAULT 0, slideshow SMALLINT(3) unsigned NOT NULL DEFAULT 0, width BIGINT(10) unsigned NOT NULL DEFAULT 640, height BIGINT(10) unsigned NOT NULL DEFAULT 480, bgcolor VARCHAR(7) NOT NULL DEFAULT '#FFFFFF', displayleft SMALLINT(3) unsigned NOT NULL DEFAULT 0, displayleftif SMALLINT(3) unsigned NOT NULL DEFAULT 0, progressbar SMALLINT(3) unsigned NOT NULL DEFAULT 0, highscores SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxhighscores BIGINT(10) unsigned NOT NULL DEFAULT 0, available BIGINT(10) unsigned NOT NULL DEFAULT 0, deadline BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixlesson COMMENT='Defines lesson'

Success

(mysql): CREATE INDEX ss_dbprefixless_cou_ix ON ss_dbprefixlesson (course)

Success

(mysql): CREATE TABLE ss_dbprefixlesson_pages ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, prevpageid BIGINT(10) unsigned NOT NULL DEFAULT 0, nextpageid BIGINT(10) unsigned NOT NULL DEFAULT 0, qtype SMALLINT(3) unsigned NOT NULL DEFAULT 0, qoption SMALLINT(3) unsigned NOT NULL DEFAULT 0, layout SMALLINT(3) unsigned NOT NULL DEFAULT 1, display SMALLINT(3) unsigned NOT NULL DEFAULT 1, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, title VARCHAR(255) NOT NULL DEFAULT '', contents TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixlesson_pages COMMENT='Defines lesson_pages'

Success

(mysql): CREATE INDEX ss_dbprefixlesspage_les_ix ON ss_dbprefixlesson_pages (lessonid)

Success

(mysql): CREATE TABLE ss_dbprefixlesson_answers ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, pageid BIGINT(10) unsigned NOT NULL DEFAULT 0, jumpto BIGINT(11) NOT NULL DEFAULT 0, grade SMALLINT(3) unsigned NOT NULL DEFAULT 0, score BIGINT(10) NOT NULL DEFAULT 0, flags SMALLINT(3) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, answer TEXT, response TEXT, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixlesson_answers COMMENT='Defines lesson_answers'

Success

(mysql): CREATE INDEX ss_dbprefixlessansw_les_ix ON ss_dbprefixlesson_answers (lessonid)

Success

(mysql): CREATE INDEX ss_dbprefixlessansw_pag_ix ON ss_dbprefixlesson_answers (pageid)

Success

(mysql): CREATE TABLE ss_dbprefixlesson_attempts ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, pageid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, answerid BIGINT(10) unsigned NOT NULL DEFAULT 0, retry SMALLINT(3) unsigned NOT NULL DEFAULT 0, correct BIGINT(10) unsigned NOT NULL DEFAULT 0, useranswer TEXT, timeseen BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixlesson_attempts COMMENT='Defines lesson_attempts'

Success

(mysql): CREATE INDEX ss_dbprefixlessatte_use_ix ON ss_dbprefixlesson_attempts (userid)

Success

(mysql): CREATE INDEX ss_dbprefixlessatte_les_ix ON ss_dbprefixlesson_attempts (lessonid)

Success

(mysql): CREATE INDEX ss_dbprefixlessatte_pag_ix ON ss_dbprefixlesson_attempts (pageid)

Success

(mysql): CREATE INDEX ss_dbprefixlessatte_ans_ix ON ss_dbprefixlesson_attempts (answerid)

Success

(mysql): CREATE TABLE ss_dbprefixlesson_grades ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, grade DOUBLE unsigned NOT NULL DEFAULT 0, late SMALLINT(3) unsigned NOT NULL DEFAULT 0, completed BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixlesson_grades COMMENT='Defines lesson_grades'

Success

(mysql): CREATE INDEX ss_dbprefixlessgrad_use_ix ON ss_dbprefixlesson_grades (userid)

Success

(mysql): CREATE INDEX ss_dbprefixlessgrad_les_ix ON ss_dbprefixlesson_grades (lessonid)

Success

(mysql): CREATE TABLE ss_dbprefixlesson_default ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, practice SMALLINT(3) unsigned NOT NULL DEFAULT 0, modattempts SMALLINT(3) unsigned NOT NULL DEFAULT 0, usepassword SMALLINT(3) unsigned NOT NULL DEFAULT 0, password VARCHAR(32) NOT NULL DEFAULT '', conditions TEXT NOT NULL, grade SMALLINT(3) NOT NULL DEFAULT 0, custom SMALLINT(3) unsigned NOT NULL DEFAULT 0, ongoing SMALLINT(3) unsigned NOT NULL DEFAULT 0, usemaxgrade SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxanswers SMALLINT(3) unsigned NOT NULL DEFAULT 4, maxattempts SMALLINT(3) unsigned NOT NULL DEFAULT 5, review SMALLINT(3) unsigned NOT NULL DEFAULT 0, nextpagedefault SMALLINT(3) unsigned NOT NULL DEFAULT 0, feedback SMALLINT(3) unsigned NOT NULL DEFAULT 1, minquestions SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxpages SMALLINT(3) unsigned NOT NULL DEFAULT 0, timed SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxtime BIGINT(10) unsigned NOT NULL DEFAULT 0, retake SMALLINT(3) unsigned NOT NULL DEFAULT 1, mediaheight BIGINT(10) unsigned NOT NULL DEFAULT 100, mediawidth BIGINT(10) unsigned NOT NULL DEFAULT 650, mediaclose SMALLINT(3) unsigned NOT NULL DEFAULT 0, slideshow SMALLINT(3) unsigned NOT NULL DEFAULT 0, width BIGINT(10) unsigned NOT NULL DEFAULT 640, height BIGINT(10) unsigned NOT NULL DEFAULT 480, bgcolor VARCHAR(7) DEFAULT '#FFFFFF', displayleft SMALLINT(3) unsigned NOT NULL DEFAULT 0, displayleftif SMALLINT(3) unsigned NOT NULL DEFAULT 0, progressbar SMALLINT(3) unsigned NOT NULL DEFAULT 0, highscores SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxhighscores BIGINT(10) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixlesson_default COMMENT='Defines lesson_default'

Success

(mysql): CREATE TABLE ss_dbprefixlesson_timer ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, starttime BIGINT(10) unsigned NOT NULL DEFAULT 0, lessontime BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixlesson_timer COMMENT='lesson timer for each lesson'

Success

(mysql): CREATE INDEX ss_dbprefixlesstime_use_ix ON ss_dbprefixlesson_timer (userid)

Success

(mysql): CREATE INDEX ss_dbprefixlesstime_les_ix ON ss_dbprefixlesson_timer (lessonid)

Success

(mysql): CREATE TABLE ss_dbprefixlesson_branch ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, pageid BIGINT(10) unsigned NOT NULL DEFAULT 0, retry BIGINT(10) unsigned NOT NULL DEFAULT 0, flag SMALLINT(3) unsigned NOT NULL DEFAULT 0, timeseen BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixlesson_branch COMMENT='branches for each lesson/user'

Success

(mysql): CREATE INDEX ss_dbprefixlessbran_use_ix ON ss_dbprefixlesson_branch (userid)

Success

(mysql): CREATE INDEX ss_dbprefixlessbran_les_ix ON ss_dbprefixlesson_branch (lessonid)

Success

(mysql): CREATE INDEX ss_dbprefixlessbran_pag_ix ON ss_dbprefixlesson_branch (pageid)

Success

(mysql): CREATE TABLE ss_dbprefixlesson_high_scores ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, gradeid BIGINT(10) unsigned NOT NULL DEFAULT 0, nickname VARCHAR(5) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixlesson_high_scores COMMENT='high scores for each lesson'

Success

(mysql): CREATE INDEX ss_dbprefixlesshighscor_use_ix ON ss_dbprefixlesson_high_scores (userid)

Success

(mysql): CREATE INDEX ss_dbprefixlesshighscor_les_ix ON ss_dbprefixlesson_high_scores (lessonid)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('lesson', 'start', 'lesson', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('lesson', 'end', 'lesson', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('lesson', 'view', 'lesson_pages', 'title')

Success

lesson tables have been set up correctly

quiz

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixquestion_categories ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', contextid BIGINT(10) unsigned NOT NULL DEFAULT 0, info TEXT NOT NULL, stamp VARCHAR(255) NOT NULL DEFAULT '', parent BIGINT(10) unsigned NOT NULL DEFAULT 0, sortorder BIGINT(10) unsigned NOT NULL DEFAULT 999, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquestion_categories COMMENT='Categories are for grouping questions'

Success

(mysql): CREATE INDEX ss_dbprefixquescate_con_ix ON ss_dbprefixquestion_categories (contextid)

Success

(mysql): CREATE INDEX ss_dbprefixquescate_par_ix ON ss_dbprefixquestion_categories (parent)

Success

(mysql): CREATE TABLE ss_dbprefixquestion ( id BIGINT(10) unsigned NOT NULL auto_increment, category BIGINT(10) NOT NULL DEFAULT 0, parent BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', questiontext TEXT NOT NULL, questiontextformat TINYINT(2) NOT NULL DEFAULT 0, image VARCHAR(255) NOT NULL DEFAULT '', generalfeedback TEXT NOT NULL, defaultgrade BIGINT(10) unsigned NOT NULL DEFAULT 1, penalty DOUBLE NOT NULL DEFAULT 0.1, qtype VARCHAR(20) NOT NULL DEFAULT '', length BIGINT(10) unsigned NOT NULL DEFAULT 1, stamp VARCHAR(255) NOT NULL DEFAULT '', version VARCHAR(255) NOT NULL DEFAULT '', hidden TINYINT(1) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, createdby BIGINT(10) unsigned DEFAULT NULL, modifiedby BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquestion COMMENT='The questions themselves'

Success

(mysql): CREATE INDEX ss_dbprefixques_cat_ix ON ss_dbprefixquestion (category)

Success

(mysql): CREATE INDEX ss_dbprefixques_par_ix ON ss_dbprefixquestion (parent)

Success

(mysql): CREATE INDEX ss_dbprefixques_cre_ix ON ss_dbprefixquestion (createdby)

Success

(mysql): CREATE INDEX ss_dbprefixques_mod_ix ON ss_dbprefixquestion (modifiedby)

Success

(mysql): CREATE TABLE ss_dbprefixquestion_answers ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL DEFAULT 0, answer TEXT NOT NULL, fraction DOUBLE NOT NULL DEFAULT 0, feedback TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquestion_answers COMMENT='Answers, with a fractional grade (0-1) and feedback'

Success

(mysql): CREATE INDEX ss_dbprefixquesansw_que_ix ON ss_dbprefixquestion_answers (question)

Success

(mysql): CREATE TABLE ss_dbprefixquestion_dataset_definitions ( id BIGINT(10) unsigned NOT NULL auto_increment, category BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', type BIGINT(10) NOT NULL DEFAULT 0, options VARCHAR(255) NOT NULL DEFAULT '', itemcount BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquestion_dataset_definitions COMMENT='Organises and stores properties for dataset items'

Success

(mysql): CREATE INDEX ss_dbprefixquesdatadefi_cat_ix ON ss_dbprefixquestion_dataset_definitions (category)

Success

(mysql): CREATE TABLE ss_dbprefixquestion_dataset_items ( id BIGINT(10) unsigned NOT NULL auto_increment, definition BIGINT(10) unsigned NOT NULL DEFAULT 0, itemnumber BIGINT(10) unsigned NOT NULL DEFAULT 0, value VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquestion_dataset_items COMMENT='Individual dataset items'

Success

(mysql): CREATE INDEX ss_dbprefixquesdataitem_def_ix ON ss_dbprefixquestion_dataset_items (definition)

Success

(mysql): CREATE TABLE ss_dbprefixquestion_datasets ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL DEFAULT 0, datasetdefinition BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquestion_datasets COMMENT='Many-many relation between questions and dataset definitions'

Success

(mysql): CREATE INDEX ss_dbprefixquesdata_quedat_ix ON ss_dbprefixquestion_datasets (question, datasetdefinition)

Success

(mysql): CREATE INDEX ss_dbprefixquesdata_que_ix ON ss_dbprefixquestion_datasets (question)

Success

(mysql): CREATE INDEX ss_dbprefixquesdata_dat_ix ON ss_dbprefixquestion_datasets (datasetdefinition)

Success

(mysql): CREATE TABLE ss_dbprefixquestion_numerical_units ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL DEFAULT 0, multiplier NUMERIC(40,20) NOT NULL DEFAULT 1.00000000000000000000, unit VARCHAR(50) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquestion_numerical_units COMMENT='Optional unit options for numerical questions'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixquesnumeunit_qu_uix ON ss_dbprefixquestion_numerical_units (question, unit)

Success

(mysql): CREATE INDEX ss_dbprefixquesnumeunit_que_ix ON ss_dbprefixquestion_numerical_units (question)

Success

(mysql): CREATE TABLE ss_dbprefixquestion_attempts ( id BIGINT(10) unsigned NOT NULL auto_increment, modulename VARCHAR(20) NOT NULL DEFAULT 'quiz', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquestion_attempts COMMENT='Student attempts. This table gets extended by the modules'

Success

(mysql): CREATE TABLE ss_dbprefixquestion_states ( id BIGINT(10) unsigned NOT NULL auto_increment, attempt BIGINT(10) unsigned NOT NULL DEFAULT 0, question BIGINT(10) unsigned NOT NULL DEFAULT 0, originalquestion BIGINT(10) unsigned NOT NULL DEFAULT 0, seq_number MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, answer TEXT NOT NULL, timestamp BIGINT(10) unsigned NOT NULL DEFAULT 0, event SMALLINT(4) unsigned NOT NULL DEFAULT 0, grade DOUBLE NOT NULL DEFAULT 0, raw_grade DOUBLE NOT NULL DEFAULT 0, penalty DOUBLE NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquestion_states COMMENT='Stores user responses to an attempt, and percentage grades'

Success

(mysql): CREATE INDEX ss_dbprefixquesstat_att_ix ON ss_dbprefixquestion_states (attempt)

Success

(mysql): CREATE INDEX ss_dbprefixquesstat_que_ix ON ss_dbprefixquestion_states (question)

Success

(mysql): CREATE TABLE ss_dbprefixquestion_sessions ( id BIGINT(10) unsigned NOT NULL auto_increment, attemptid BIGINT(10) unsigned NOT NULL DEFAULT 0, questionid BIGINT(10) unsigned NOT NULL DEFAULT 0, newest BIGINT(10) unsigned NOT NULL DEFAULT 0, newgraded BIGINT(10) unsigned NOT NULL DEFAULT 0, sumpenalty DOUBLE NOT NULL DEFAULT 0, manualcomment TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquestion_sessions COMMENT='Gives ids of the newest open and newest graded states'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixquessess_attque_uix ON ss_dbprefixquestion_sessions (attemptid, questionid)

Success

(mysql): CREATE INDEX ss_dbprefixquessess_att_ix ON ss_dbprefixquestion_sessions (attemptid)

Success

(mysql): CREATE INDEX ss_dbprefixquessess_que_ix ON ss_dbprefixquestion_sessions (questionid)

Success

(mysql): CREATE INDEX ss_dbprefixquessess_new_ix ON ss_dbprefixquestion_sessions (newest)

Success

(mysql): CREATE INDEX ss_dbprefixquessess_new2_ix ON ss_dbprefixquestion_sessions (newgraded)

Success

(mysql): CREATE TABLE ss_dbprefixquiz ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', intro TEXT NOT NULL, timeopen BIGINT(10) unsigned NOT NULL DEFAULT 0, timeclose BIGINT(10) unsigned NOT NULL DEFAULT 0, optionflags BIGINT(10) unsigned NOT NULL DEFAULT 0, penaltyscheme SMALLINT(4) unsigned NOT NULL DEFAULT 0, attempts MEDIUMINT(6) NOT NULL DEFAULT 0, attemptonlast SMALLINT(4) NOT NULL DEFAULT 0, grademethod SMALLINT(4) NOT NULL DEFAULT 1, decimalpoints SMALLINT(4) NOT NULL DEFAULT 2, review BIGINT(10) unsigned NOT NULL DEFAULT 0, questionsperpage BIGINT(10) NOT NULL DEFAULT 0, shufflequestions SMALLINT(4) NOT NULL DEFAULT 0, shuffleanswers SMALLINT(4) NOT NULL DEFAULT 0, questions TEXT NOT NULL, sumgrades BIGINT(10) NOT NULL DEFAULT 0, grade BIGINT(10) NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, timelimit BIGINT(10) unsigned NOT NULL DEFAULT 0, password VARCHAR(255) NOT NULL DEFAULT '', subnet VARCHAR(255) NOT NULL DEFAULT '', popup SMALLINT(4) NOT NULL DEFAULT 0, delay1 BIGINT(10) NOT NULL DEFAULT 0, delay2 BIGINT(10) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquiz COMMENT='Main information about each quiz'

Success

(mysql): CREATE INDEX ss_dbprefixquiz_cou_ix ON ss_dbprefixquiz (course)

Success

(mysql): CREATE TABLE ss_dbprefixquiz_attempts ( id BIGINT(10) unsigned NOT NULL auto_increment, uniqueid BIGINT(10) unsigned NOT NULL DEFAULT 0, quiz BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, attempt MEDIUMINT(6) NOT NULL DEFAULT 0, sumgrades DOUBLE NOT NULL DEFAULT 0, timestart BIGINT(10) unsigned NOT NULL DEFAULT 0, timefinish BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, layout TEXT NOT NULL, preview SMALLINT(3) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquiz_attempts COMMENT='Stores various attempts on a quiz'

Success

(mysql): CREATE INDEX ss_dbprefixquizatte_use_ix ON ss_dbprefixquiz_attempts (userid)

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixquizatte_uni_uix ON ss_dbprefixquiz_attempts (uniqueid)

Success

(mysql): CREATE INDEX ss_dbprefixquizatte_qui_ix ON ss_dbprefixquiz_attempts (quiz)

Success

(mysql): CREATE TABLE ss_dbprefixquiz_grades ( id BIGINT(10) unsigned NOT NULL auto_increment, quiz BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, grade DOUBLE NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquiz_grades COMMENT='Final quiz grade (may be best of several attempts)'

Success

(mysql): CREATE INDEX ss_dbprefixquizgrad_use_ix ON ss_dbprefixquiz_grades (userid)

Success

(mysql): CREATE INDEX ss_dbprefixquizgrad_qui_ix ON ss_dbprefixquiz_grades (quiz)

Success

(mysql): CREATE TABLE ss_dbprefixquiz_question_instances ( id BIGINT(10) unsigned NOT NULL auto_increment, quiz BIGINT(10) unsigned NOT NULL DEFAULT 0, question BIGINT(10) unsigned NOT NULL DEFAULT 0, grade MEDIUMINT(6) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquiz_question_instances COMMENT='The grade for a question in a quiz'

Success

(mysql): CREATE INDEX ss_dbprefixquizquesinst_qui_ix ON ss_dbprefixquiz_question_instances (quiz)

Success

(mysql): CREATE INDEX ss_dbprefixquizquesinst_que_ix ON ss_dbprefixquiz_question_instances (question)

Success

(mysql): CREATE TABLE ss_dbprefixquiz_question_versions ( id BIGINT(10) unsigned NOT NULL auto_increment, quiz BIGINT(10) unsigned NOT NULL DEFAULT 0, oldquestion BIGINT(10) unsigned NOT NULL DEFAULT 0, newquestion BIGINT(10) unsigned NOT NULL DEFAULT 0, originalquestion BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timestamp BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquiz_question_versions COMMENT='quiz_question_versions table retrofitted from MySQL'

Success

(mysql): CREATE INDEX ss_dbprefixquizquesvers_qui_ix ON ss_dbprefixquiz_question_versions (quiz)

Success

(mysql): CREATE INDEX ss_dbprefixquizquesvers_old_ix ON ss_dbprefixquiz_question_versions (oldquestion)

Success

(mysql): CREATE INDEX ss_dbprefixquizquesvers_new_ix ON ss_dbprefixquiz_question_versions (newquestion)

Success

(mysql): CREATE INDEX ss_dbprefixquizquesvers_ori_ix ON ss_dbprefixquiz_question_versions (originalquestion)

Success

(mysql): CREATE TABLE ss_dbprefixquiz_feedback ( id BIGINT(10) unsigned NOT NULL auto_increment, quizid BIGINT(10) unsigned NOT NULL DEFAULT 0, feedbacktext TEXT NOT NULL, mingrade DOUBLE NOT NULL DEFAULT 0, maxgrade DOUBLE NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixquiz_feedback COMMENT='Feedback given to students based on their overall score on t'

Success

(mysql): CREATE INDEX ss_dbprefixquizfeed_qui_ix ON ss_dbprefixquiz_feedback (quizid)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'add', 'quiz', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'update', 'quiz', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'view', 'quiz', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'report', 'quiz', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'attempt', 'quiz', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'submit', 'quiz', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'review', 'quiz', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'editquestions', 'quiz', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'preview', 'quiz', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'start attempt', 'quiz', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'close attempt', 'quiz', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('quiz', 'continue attempt', 'quiz', 'name')

Success

quiz tables have been set up correctly

resource

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixresource ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', type VARCHAR(30) NOT NULL DEFAULT '', reference VARCHAR(255) NOT NULL DEFAULT '', summary TEXT, alltext MEDIUMTEXT NOT NULL, popup TEXT NOT NULL, options VARCHAR(255) NOT NULL DEFAULT '', timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixresource COMMENT='each record is one resource and its config data'

Success

(mysql): CREATE INDEX ss_dbprefixreso_cou_ix ON ss_dbprefixresource (course)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('resource', 'view', 'resource', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('resource', 'update', 'resource', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('resource', 'add', 'resource', 'name')

Success

resource tables have been set up correctly

scorm

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixscorm ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', reference VARCHAR(255) NOT NULL DEFAULT '', summary TEXT NOT NULL, version VARCHAR(9) NOT NULL DEFAULT '', maxgrade DOUBLE NOT NULL DEFAULT 0, grademethod TINYINT(2) NOT NULL DEFAULT 0, whatgrade BIGINT(10) NOT NULL DEFAULT 0, maxattempt BIGINT(10) NOT NULL DEFAULT 1, updatefreq TINYINT(1) unsigned NOT NULL DEFAULT 0, md5hash VARCHAR(32) NOT NULL DEFAULT '', launch BIGINT(10) unsigned NOT NULL DEFAULT 0, skipview TINYINT(1) unsigned NOT NULL DEFAULT 1, hidebrowse TINYINT(1) NOT NULL DEFAULT 0, hidetoc TINYINT(1) NOT NULL DEFAULT 0, hidenav TINYINT(1) NOT NULL DEFAULT 0, auto TINYINT(1) unsigned NOT NULL DEFAULT 0, popup TINYINT(1) unsigned NOT NULL DEFAULT 0, options VARCHAR(255) NOT NULL DEFAULT '', width BIGINT(10) unsigned NOT NULL DEFAULT 100, height BIGINT(10) unsigned NOT NULL DEFAULT 600, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixscorm COMMENT='each table is one SCORM module and its configuration'

Success

(mysql): CREATE INDEX ss_dbprefixscor_cou_ix ON ss_dbprefixscorm (course)

Success

(mysql): CREATE TABLE ss_dbprefixscorm_scoes ( id BIGINT(10) unsigned NOT NULL auto_increment, scorm BIGINT(10) unsigned NOT NULL DEFAULT 0, manifest VARCHAR(255) NOT NULL DEFAULT '', organization VARCHAR(255) NOT NULL DEFAULT '', parent VARCHAR(255) NOT NULL DEFAULT '', identifier VARCHAR(255) NOT NULL DEFAULT '', launch VARCHAR(255) NOT NULL DEFAULT '', scormtype VARCHAR(5) NOT NULL DEFAULT '', title VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixscorm_scoes COMMENT='each SCO part of the SCORM module'

Success

(mysql): CREATE INDEX ss_dbprefixscorscoe_sco_ix ON ss_dbprefixscorm_scoes (scorm)

Success

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

Success

(mysql): ALTER TABLE ss_dbprefixscorm_scoes_data COMMENT='Contains variable data get from packages'

Success

(mysql): CREATE INDEX ss_dbprefixscorscoedata_sco_ix ON ss_dbprefixscorm_scoes_data (scoid)

Success

(mysql): CREATE TABLE ss_dbprefixscorm_scoes_track ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, scormid BIGINT(10) NOT NULL DEFAULT 0, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, attempt BIGINT(10) unsigned NOT NULL DEFAULT 1, element VARCHAR(255) NOT NULL DEFAULT '', value LONGTEXT NOT NULL, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixscorm_scoes_track COMMENT='to track SCOes'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixscorscoetrac_us_uix ON ss_dbprefixscorm_scoes_track (userid, scormid, scoid, attempt, element)

Success

(mysql): CREATE INDEX ss_dbprefixscorscoetrac_use_ix ON ss_dbprefixscorm_scoes_track (userid)

Success

(mysql): CREATE INDEX ss_dbprefixscorscoetrac_ele_ix ON ss_dbprefixscorm_scoes_track (element)

Success

(mysql): CREATE INDEX ss_dbprefixscorscoetrac_sco_ix ON ss_dbprefixscorm_scoes_track (scormid)

Success

(mysql): CREATE INDEX ss_dbprefixscorscoetrac_sc2_ix ON ss_dbprefixscorm_scoes_track (scoid)

Success

(mysql): CREATE TABLE ss_dbprefixscorm_seq_objective ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, primaryobj TINYINT(1) NOT NULL DEFAULT 0, objectiveid BIGINT(10) unsigned NOT NULL DEFAULT 0, satisfiedbymeasure TINYINT(1) NOT NULL DEFAULT 1, minnormalizedmeasure FLOAT(11,4) unsigned NOT NULL DEFAULT 0.0000, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixscorm_seq_objective COMMENT='SCORM2004 objective description'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixscorseqobje_sco_uix ON ss_dbprefixscorm_seq_objective (scoid, id)

Success

(mysql): CREATE INDEX ss_dbprefixscorseqobje_sco_ix ON ss_dbprefixscorm_seq_objective (scoid)

Success

(mysql): CREATE TABLE ss_dbprefixscorm_seq_mapinfo ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, objectiveid BIGINT(10) unsigned NOT NULL DEFAULT 0, targetobjectiveid BIGINT(10) unsigned NOT NULL DEFAULT 0, readsatisfiedstatus TINYINT(1) NOT NULL DEFAULT 1, readnormalizedmeasure TINYINT(1) NOT NULL DEFAULT 1, writesatisfiedstatus TINYINT(1) NOT NULL DEFAULT 0, writenormalizedmeasure TINYINT(1) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixscorm_seq_mapinfo COMMENT='SCORM2004 objective mapinfo description'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixscorseqmapi_sco_uix ON ss_dbprefixscorm_seq_mapinfo (scoid, id, objectiveid)

Success

(mysql): CREATE INDEX ss_dbprefixscorseqmapi_sco_ix ON ss_dbprefixscorm_seq_mapinfo (scoid)

Success

(mysql): CREATE INDEX ss_dbprefixscorseqmapi_obj_ix ON ss_dbprefixscorm_seq_mapinfo (objectiveid)

Success

(mysql): CREATE TABLE ss_dbprefixscorm_seq_ruleconds ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, conditioncombination VARCHAR(3) NOT NULL DEFAULT 'all', ruletype TINYINT(2) unsigned NOT NULL DEFAULT 0, action VARCHAR(25) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixscorm_seq_ruleconds COMMENT='SCORM2004 rule conditions'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixscorseqrule_sco_uix ON ss_dbprefixscorm_seq_ruleconds (scoid, id)

Success

(mysql): CREATE INDEX ss_dbprefixscorseqrule_sco_ix ON ss_dbprefixscorm_seq_ruleconds (scoid)

Success

(mysql): CREATE TABLE ss_dbprefixscorm_seq_rulecond ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, ruleconditionsid BIGINT(10) unsigned NOT NULL DEFAULT 0, refrencedobjective VARCHAR(255) NOT NULL DEFAULT '', measurethreshold FLOAT(11,4) NOT NULL DEFAULT 0.0000, operator VARCHAR(5) NOT NULL DEFAULT 'noOp', cond VARCHAR(30) NOT NULL DEFAULT 'always', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixscorm_seq_rulecond COMMENT='SCORM2004 rule condition'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixscorseqrule_ids_uix ON ss_dbprefixscorm_seq_rulecond (id, scoid, ruleconditionsid)

Success

(mysql): CREATE INDEX ss_dbprefixscorseqrule_sco2_ix ON ss_dbprefixscorm_seq_rulecond (scoid)

Success

(mysql): CREATE INDEX ss_dbprefixscorseqrule_rul_ix ON ss_dbprefixscorm_seq_rulecond (ruleconditionsid)

Success

(mysql): CREATE TABLE ss_dbprefixscorm_seq_rolluprule ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, childactivityset VARCHAR(15) NOT NULL DEFAULT '', minimumcount BIGINT(10) unsigned NOT NULL DEFAULT 0, minimumpercent FLOAT(11,4) unsigned NOT NULL DEFAULT 0.0000, conditioncombination VARCHAR(3) NOT NULL DEFAULT 'all', action VARCHAR(15) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixscorm_seq_rolluprule COMMENT='SCORM2004 sequencing rule'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixscorseqroll_sco_uix ON ss_dbprefixscorm_seq_rolluprule (scoid, id)

Success

(mysql): CREATE INDEX ss_dbprefixscorseqroll_sco_ix ON ss_dbprefixscorm_seq_rolluprule (scoid)

Success

(mysql): CREATE TABLE ss_dbprefixscorm_seq_rolluprulecond ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, rollupruleid BIGINT(10) unsigned NOT NULL DEFAULT 0, operator VARCHAR(5) NOT NULL DEFAULT 'noOp', cond VARCHAR(25) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixscorm_seq_rolluprulecond COMMENT='SCORM2004 sequencing rule'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixscorseqroll_sc2_uix ON ss_dbprefixscorm_seq_rolluprulecond (scoid, rollupruleid, id)

Success

(mysql): CREATE INDEX ss_dbprefixscorseqroll_sco2_ix ON ss_dbprefixscorm_seq_rolluprulecond (scoid)

Success

(mysql): CREATE INDEX ss_dbprefixscorseqroll_rol_ix ON ss_dbprefixscorm_seq_rolluprulecond (rollupruleid)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('scorm', 'view', 'scorm', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('scorm', 'review', 'scorm', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('scorm', 'update', 'scorm', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('scorm', 'add', 'scorm', 'name')

Success

scorm tables have been set up correctly

survey

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixsurvey ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, template BIGINT(10) unsigned NOT NULL DEFAULT 0, days MEDIUMINT(6) NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', intro TEXT NOT NULL, questions VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixsurvey COMMENT='Each record is one SURVEY module with its configuration'

Success

(mysql): CREATE INDEX ss_dbprefixsurv_cou_ix ON ss_dbprefixsurvey (course)

Success

(mysql): CREATE TABLE ss_dbprefixsurvey_questions ( id BIGINT(10) unsigned NOT NULL auto_increment, text VARCHAR(255) NOT NULL DEFAULT '', shorttext VARCHAR(30) NOT NULL DEFAULT '', multi VARCHAR(100) NOT NULL DEFAULT '', intro VARCHAR(50) NOT NULL DEFAULT '', type SMALLINT(3) NOT NULL DEFAULT 0, options TEXT, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixsurvey_questions COMMENT='the questions conforming one survey'

Success

(mysql): CREATE TABLE ss_dbprefixsurvey_answers ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, survey BIGINT(10) unsigned NOT NULL DEFAULT 0, question BIGINT(10) unsigned NOT NULL DEFAULT 0, time BIGINT(10) unsigned NOT NULL DEFAULT 0, answer1 TEXT NOT NULL, answer2 TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixsurvey_answers COMMENT='the answers to each questions filled by the users'

Success

(mysql): CREATE INDEX ss_dbprefixsurvansw_use_ix ON ss_dbprefixsurvey_answers (userid)

Success

(mysql): CREATE INDEX ss_dbprefixsurvansw_sur_ix ON ss_dbprefixsurvey_answers (survey)

Success

(mysql): CREATE INDEX ss_dbprefixsurvansw_que_ix ON ss_dbprefixsurvey_answers (question)

Success

(mysql): CREATE TABLE ss_dbprefixsurvey_analysis ( id BIGINT(10) unsigned NOT NULL auto_increment, survey BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, notes TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixsurvey_analysis COMMENT='text about each survey submission'

Success

(mysql): CREATE INDEX ss_dbprefixsurvanal_use_ix ON ss_dbprefixsurvey_analysis (userid)

Success

(mysql): CREATE INDEX ss_dbprefixsurvanal_sur_ix ON ss_dbprefixsurvey_analysis (survey)

Success

(mysql): INSERT INTO ss_dbprefixsurvey(course, template, days, timecreated, timemodified, name, intro, questions) VALUES ('0', '0', '0', '985017600', '985017600', 'collesaname', 'collesaintro', '25,26,27,28,29,30,43,44')

Success

(mysql): INSERT INTO ss_dbprefixsurvey(course, template, days, timecreated, timemodified, name, intro, questions) VALUES ('0', '0', '0', '985017600', '985017600', 'attlsname', 'attlsintro', '65,67,68')

Success

(mysql): INSERT INTO ss_dbprefixsurvey(course, template, days, timecreated, timemodified, name, intro, questions) VALUES ('0', '0', '0', '985017600', '985017600', 'ciqname', 'ciqintro', '69,70,71,72,73')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles1', 'colles1short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles2', 'colles2short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles3', 'colles3short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles4', 'colles4short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles5', 'colles5short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles6', 'colles6short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles7', 'colles7short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles8', 'colles8short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles9', 'colles9short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles10', 'colles10short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles11', 'colles11short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles12', 'colles12short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles13', 'colles13short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles14', 'colles14short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles15', 'colles15short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles16', 'colles16short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles17', 'colles17short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles18', 'colles18short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles19', 'colles19short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles20', 'colles20short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles21', 'colles21short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles22', 'colles22short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles23', 'colles23short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('colles24', 'colles24short', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm1', 'collesm1short', '1,2,3,4', 'collesmintro', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm2', 'collesm2short', '5,6,7,8', 'collesmintro', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm3', 'collesm3short', '9,10,11,12', 'collesmintro', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm4', 'collesm4short', '13,14,15,16', 'collesmintro', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm5', 'collesm5short', '17,18,19,20', 'collesmintro', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm6', 'collesm6short', '21,22,23,24', 'collesmintro', '1', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm1', 'collesm1short', '1,2,3,4', 'collesmintro', '2', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm2', 'collesm2short', '5,6,7,8', 'collesmintro', '2', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm3', 'collesm3short', '9,10,11,12', 'collesmintro', '2', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm4', 'collesm4short', '13,14,15,16', 'collesmintro', '2', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm5', 'collesm5short', '17,18,19,20', 'collesmintro', '2', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm6', 'collesm6short', '21,22,23,24', 'collesmintro', '2', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm1', 'collesm1short', '1,2,3,4', 'collesmintro', '3', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm2', 'collesm2short', '5,6,7,8', 'collesmintro', '3', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm3', 'collesm3short', '9,10,11,12', 'collesmintro', '3', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm4', 'collesm4short', '13,14,15,16', 'collesmintro', '3', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm5', 'collesm5short', '17,18,19,20', 'collesmintro', '3', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm6', 'collesm6short', '21,22,23,24', 'collesmintro', '3', 'scaletimes5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, type, options) VALUES ('howlong', '1', 'howlongoptions')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, type) VALUES ('othercomments', '0')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls1', 'attls1short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls2', 'attls2short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls3', 'attls3short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls4', 'attls4short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls5', 'attls5short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls6', 'attls6short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls7', 'attls7short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls8', 'attls8short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls9', 'attls9short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls10', 'attls10short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls11', 'attls11short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls12', 'attls12short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls13', 'attls13short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls14', 'attls14short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls15', 'attls15short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls16', 'attls16short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls17', 'attls17short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls18', 'attls18short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls19', 'attls19short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type, options) VALUES ('attls20', 'attls20short', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('attlsm1', 'attlsm1', '45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64', 'attlsmintro', '1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('-', '-', '-', '-', '0', '-')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('attlsm2', 'attlsm2', '63,62,59,57,55,49,52,50,48,47', 'attlsmintro', '-1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, multi, intro, type, options) VALUES ('attlsm3', 'attlsm3', '46,54,45,51,60,53,56,58,61,64', 'attlsmintro', '-1', 'scaleagree5')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type) VALUES ('ciq1', 'ciq1short', '0')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type) VALUES ('ciq2', 'ciq2short', '0')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type) VALUES ('ciq3', 'ciq3short', '0')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type) VALUES ('ciq4', 'ciq4short', '0')

Success

(mysql): INSERT INTO ss_dbprefixsurvey_questions(text, shorttext, type) VALUES ('ciq5', 'ciq5short', '0')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('survey', 'add', 'survey', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('survey', 'update', 'survey', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('survey', 'download', 'survey', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('survey', 'view form', 'survey', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('survey', 'view graph', 'survey', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('survey', 'view report', 'survey', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('survey', 'submit', 'survey', 'name')

Success

survey tables have been set up correctly

wiki

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixwiki ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', summary TEXT NOT NULL, pagename VARCHAR(255) NOT NULL DEFAULT '', wtype enum('teacher', 'group', 'student') NOT NULL DEFAULT 'group', ewikiprinttitle SMALLINT(4) unsigned NOT NULL DEFAULT 1, htmlmode SMALLINT(4) unsigned NOT NULL DEFAULT 0, ewikiacceptbinary SMALLINT(4) unsigned NOT NULL DEFAULT 0, disablecamelcase SMALLINT(4) unsigned NOT NULL DEFAULT 0, setpageflags SMALLINT(4) unsigned NOT NULL DEFAULT 1, strippages SMALLINT(4) unsigned NOT NULL DEFAULT 1, removepages SMALLINT(4) unsigned NOT NULL DEFAULT 1, revertchanges SMALLINT(4) unsigned NOT NULL DEFAULT 1, initialcontent VARCHAR(255) NOT NULL DEFAULT '', timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixwiki COMMENT='Main wik table'

Success

(mysql): CREATE INDEX ss_dbprefixwiki_cou_ix ON ss_dbprefixwiki (course)

Success

(mysql): CREATE TABLE ss_dbprefixwiki_entries ( id BIGINT(10) unsigned NOT NULL auto_increment, wikiid BIGINT(10) unsigned NOT NULL DEFAULT 0, course BIGINT(10) unsigned NOT NULL DEFAULT 0, groupid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, pagename VARCHAR(255) NOT NULL DEFAULT '', timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixwiki_entries COMMENT='Holds entries for each wiki start instance'

Success

(mysql): CREATE INDEX ss_dbprefixwikientr_cou_ix ON ss_dbprefixwiki_entries (course)

Success

(mysql): CREATE INDEX ss_dbprefixwikientr_gro_ix ON ss_dbprefixwiki_entries (groupid)

Success

(mysql): CREATE INDEX ss_dbprefixwikientr_use_ix ON ss_dbprefixwiki_entries (userid)

Success

(mysql): CREATE INDEX ss_dbprefixwikientr_pag_ix ON ss_dbprefixwiki_entries (pagename)

Success

(mysql): CREATE INDEX ss_dbprefixwikientr_wik_ix ON ss_dbprefixwiki_entries (wikiid)

Success

(mysql): CREATE TABLE ss_dbprefixwiki_pages ( id BIGINT(10) unsigned NOT NULL auto_increment, pagename VARCHAR(160) NOT NULL DEFAULT '', version BIGINT(10) unsigned NOT NULL DEFAULT 0, flags BIGINT(10) unsigned DEFAULT 0, content MEDIUMTEXT, author VARCHAR(100) DEFAULT 'ewiki', userid BIGINT(10) unsigned NOT NULL DEFAULT 0, created BIGINT(10) unsigned DEFAULT 0, lastmodified BIGINT(10) unsigned DEFAULT 0, refs MEDIUMTEXT, meta MEDIUMTEXT, hits BIGINT(10) unsigned DEFAULT 0, wiki BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixwiki_pages COMMENT='Holds the Wiki-Pages'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixwikipage_pagver_uix ON ss_dbprefixwiki_pages (pagename, version, wiki)

Success

(mysql): CREATE INDEX ss_dbprefixwikipage_wik_ix ON ss_dbprefixwiki_pages (wiki)

Success

(mysql): CREATE TABLE ss_dbprefixwiki_locks ( id BIGINT(10) unsigned NOT NULL auto_increment, wikiid BIGINT(10) unsigned NOT NULL, pagename VARCHAR(160) NOT NULL DEFAULT '', lockedby BIGINT(10) unsigned NOT NULL DEFAULT 0, lockedsince BIGINT(10) unsigned NOT NULL DEFAULT 0, lockedseen BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixwiki_locks COMMENT='Stores editing locks on Wiki pages'

Success

(mysql): CREATE UNIQUE INDEX ss_dbprefixwikilock_wikpag_uix ON ss_dbprefixwiki_locks (wikiid, pagename)

Success

(mysql): CREATE INDEX ss_dbprefixwikilock_loc_ix ON ss_dbprefixwiki_locks (lockedseen)

Success

(mysql): CREATE INDEX ss_dbprefixwikilock_wik_ix ON ss_dbprefixwiki_locks (wikiid)

Success

wiki tables have been set up correctly

workshop

(mysql): SHOW TABLES

(mysql): CREATE TABLE ss_dbprefixworkshop ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NOT NULL, wtype SMALLINT(3) unsigned NOT NULL DEFAULT 0, nelements SMALLINT(3) unsigned NOT NULL DEFAULT 1, nattachments SMALLINT(3) unsigned NOT NULL DEFAULT 0, phase TINYINT(2) unsigned NOT NULL DEFAULT 0, format TINYINT(2) unsigned NOT NULL DEFAULT 0, gradingstrategy TINYINT(2) unsigned NOT NULL DEFAULT 1, resubmit TINYINT(2) unsigned NOT NULL DEFAULT 0, agreeassessments TINYINT(2) unsigned NOT NULL DEFAULT 0, hidegrades TINYINT(2) unsigned NOT NULL DEFAULT 0, anonymous TINYINT(2) unsigned NOT NULL DEFAULT 0, includeself TINYINT(2) unsigned NOT NULL DEFAULT 0, maxbytes BIGINT(10) unsigned NOT NULL DEFAULT 100000, submissionstart BIGINT(10) unsigned NOT NULL DEFAULT 0, assessmentstart BIGINT(10) unsigned NOT NULL DEFAULT 0, submissionend BIGINT(10) unsigned NOT NULL DEFAULT 0, assessmentend BIGINT(10) unsigned NOT NULL DEFAULT 0, releasegrades BIGINT(10) unsigned NOT NULL DEFAULT 0, grade SMALLINT(3) NOT NULL DEFAULT 0, gradinggrade SMALLINT(3) NOT NULL DEFAULT 0, ntassessments SMALLINT(3) unsigned NOT NULL DEFAULT 0, assessmentcomps SMALLINT(3) unsigned NOT NULL DEFAULT 2, nsassessments SMALLINT(3) unsigned NOT NULL DEFAULT 0, overallocation SMALLINT(3) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, teacherweight SMALLINT(3) unsigned NOT NULL DEFAULT 1, showleaguetable SMALLINT(3) unsigned NOT NULL DEFAULT 0, usepassword SMALLINT(3) unsigned NOT NULL DEFAULT 0, password VARCHAR(32) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixworkshop COMMENT='Defines workshop'

Success

(mysql): CREATE INDEX ss_dbprefixwork_cou_ix ON ss_dbprefixworkshop (course)

Success

(mysql): CREATE TABLE ss_dbprefixworkshop_elements ( id BIGINT(10) unsigned NOT NULL auto_increment, workshopid BIGINT(10) unsigned NOT NULL DEFAULT 0, elementno SMALLINT(3) unsigned NOT NULL DEFAULT 0, description TEXT NOT NULL, scale SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxscore SMALLINT(3) unsigned NOT NULL DEFAULT 1, weight SMALLINT(3) unsigned NOT NULL DEFAULT 11, stddev DOUBLE NOT NULL DEFAULT 0, totalassessments BIGINT(10) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixworkshop_elements COMMENT='Info about marking scheme of assignment'

Success

(mysql): CREATE INDEX ss_dbprefixworkelem_wor_ix ON ss_dbprefixworkshop_elements (workshopid)

Success

(mysql): CREATE TABLE ss_dbprefixworkshop_rubrics ( id BIGINT(10) unsigned NOT NULL auto_increment, workshopid BIGINT(10) unsigned NOT NULL DEFAULT 0, elementno BIGINT(10) unsigned NOT NULL DEFAULT 0, rubricno SMALLINT(3) unsigned NOT NULL DEFAULT 0, description TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixworkshop_rubrics COMMENT='Info about the rubrics marking scheme'

Success

(mysql): CREATE INDEX ss_dbprefixworkrubr_wor_ix ON ss_dbprefixworkshop_rubrics (workshopid)

Success

(mysql): CREATE TABLE ss_dbprefixworkshop_submissions ( id BIGINT(10) unsigned NOT NULL auto_increment, workshopid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, title VARCHAR(100) NOT NULL DEFAULT '', timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, mailed TINYINT(2) unsigned NOT NULL DEFAULT 0, description TEXT NOT NULL, gradinggrade SMALLINT(3) unsigned NOT NULL DEFAULT 0, finalgrade SMALLINT(3) unsigned NOT NULL DEFAULT 0, late SMALLINT(3) unsigned NOT NULL DEFAULT 0, nassessments BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixworkshop_submissions COMMENT='Info about submitted work from teacher and students'

Success

(mysql): CREATE INDEX ss_dbprefixworksubm_use_ix ON ss_dbprefixworkshop_submissions (userid)

Success

(mysql): CREATE INDEX ss_dbprefixworksubm_mai_ix ON ss_dbprefixworkshop_submissions (mailed)

Success

(mysql): CREATE INDEX ss_dbprefixworksubm_wor_ix ON ss_dbprefixworkshop_submissions (workshopid)

Success

(mysql): CREATE TABLE ss_dbprefixworkshop_assessments ( id BIGINT(10) unsigned NOT NULL auto_increment, workshopid BIGINT(10) unsigned NOT NULL DEFAULT 0, submissionid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timegraded BIGINT(10) unsigned NOT NULL DEFAULT 0, timeagreed BIGINT(10) unsigned NOT NULL DEFAULT 0, grade DOUBLE NOT NULL DEFAULT 0, gradinggrade SMALLINT(3) NOT NULL DEFAULT 0, teachergraded SMALLINT(3) unsigned NOT NULL DEFAULT 0, mailed SMALLINT(3) unsigned NOT NULL DEFAULT 0, resubmission SMALLINT(3) unsigned NOT NULL DEFAULT 0, donotuse SMALLINT(3) unsigned NOT NULL DEFAULT 0, generalcomment TEXT NOT NULL, teachercomment TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixworkshop_assessments COMMENT='Info about assessments by teacher and students'

Success

(mysql): CREATE INDEX ss_dbprefixworkasse_use_ix ON ss_dbprefixworkshop_assessments (userid)

Success

(mysql): CREATE INDEX ss_dbprefixworkasse_mai_ix ON ss_dbprefixworkshop_assessments (mailed)

Success

(mysql): CREATE INDEX ss_dbprefixworkasse_wor_ix ON ss_dbprefixworkshop_assessments (workshopid)

Success

(mysql): CREATE INDEX ss_dbprefixworkasse_sub_ix ON ss_dbprefixworkshop_assessments (submissionid)

Success

(mysql): CREATE TABLE ss_dbprefixworkshop_grades ( id BIGINT(10) unsigned NOT NULL auto_increment, workshopid BIGINT(10) unsigned NOT NULL DEFAULT 0, assessmentid BIGINT(10) unsigned NOT NULL DEFAULT 0, elementno BIGINT(10) unsigned NOT NULL DEFAULT 0, feedback TEXT NOT NULL, grade SMALLINT(3) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixworkshop_grades COMMENT='Info about individual grades given to each element'

Success

(mysql): CREATE INDEX ss_dbprefixworkgrad_wor_ix ON ss_dbprefixworkshop_grades (workshopid)

Success

(mysql): CREATE INDEX ss_dbprefixworkgrad_ass_ix ON ss_dbprefixworkshop_grades (assessmentid)

Success

(mysql): CREATE TABLE ss_dbprefixworkshop_stockcomments ( id BIGINT(10) unsigned NOT NULL auto_increment, workshopid BIGINT(10) unsigned NOT NULL DEFAULT 0, elementno BIGINT(10) unsigned NOT NULL DEFAULT 0, comments TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixworkshop_stockcomments COMMENT='Info about the teacher comment bank'

Success

(mysql): CREATE INDEX ss_dbprefixworkstoc_wor_ix ON ss_dbprefixworkshop_stockcomments (workshopid)

Success

(mysql): CREATE TABLE ss_dbprefixworkshop_comments ( id BIGINT(10) unsigned NOT NULL auto_increment, workshopid BIGINT(10) unsigned NOT NULL DEFAULT 0, assessmentid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, mailed TINYINT(2) unsigned NOT NULL DEFAULT 0, comments TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE ss_dbprefixworkshop_comments COMMENT='Defines comments'

Success

(mysql): CREATE INDEX ss_dbprefixworkcomm_use_ix ON ss_dbprefixworkshop_comments (userid)

Success

(mysql): CREATE INDEX ss_dbprefixworkcomm_mai_ix ON ss_dbprefixworkshop_comments (mailed)

Success

(mysql): CREATE INDEX ss_dbprefixworkcomm_wor_ix ON ss_dbprefixworkshop_comments (workshopid)

Success

(mysql): CREATE INDEX ss_dbprefixworkcomm_ass_ix ON ss_dbprefixworkshop_comments (assessmentid)

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('workshop', 'assessments', 'workshop', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('workshop', 'close', 'workshop', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('workshop', 'display', 'workshop', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('workshop', 'resubmit', 'workshop', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('workshop', 'set up', 'workshop', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('workshop', 'submissions', 'workshop', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('workshop', 'view', 'workshop', 'name')

Success

(mysql): INSERT INTO ss_dbprefixlog_display(module, action, mtable, field) VALUES ('workshop', 'update', 'workshop', 'name')

Success

workshop tables have been set up correctly