I copied official repo of Moodle then followed steps in quickstarts here, so I get this kind of error. It is 1st installation. So don't know why this is happend
Debug info: Table 'm_config' already exists
CREATE TABLE m_config (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_bin NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_conf_nam2_uix (name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Moodle configuration variables'
;
CREATE TABLE m_config_plugins (
id BIGINT(10) NOT NULL auto_increment,
plugin VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT 'core',
name VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_bin NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_confplug_plunam2_uix (plugin, name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Moodle modules and plugins configuration variables'
;
CREATE TABLE m_config_log (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
timemodified BIGINT(10) NOT NULL,
plugin VARCHAR(100) COLLATE utf8mb4_bin,
name VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_bin,
oldvalue LONGTEXT COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_conflog_tim2_ix (timemodified)
, KEY m_conflog_use2_ix (userid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Changes done in server configuration through admin UI'
;
CREATE TABLE m_upgrade_log (
id BIGINT(10) NOT NULL auto_increment,
type BIGINT(10) NOT NULL,
plugin VARCHAR(100) COLLATE utf8mb4_bin,
version VARCHAR(100) COLLATE utf8mb4_bin,
targetversion VARCHAR(100) COLLATE utf8mb4_bin,
info VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
details LONGTEXT COLLATE utf8mb4_bin,
backtrace LONGTEXT COLLATE utf8mb4_bin,
userid BIGINT(10) NOT NULL,
timemodified BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY m_upgrlog_tim2_ix (timemodified)
, KEY m_upgrlog_typtim2_ix (type, timemodified)
, KEY m_upgrlog_use2_ix (userid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Upgrade logging'
;
CREATE TABLE m_course (
id BIGINT(10) NOT NULL auto_increment,
category BIGINT(10) NOT NULL DEFAULT 0,
sortorder BIGINT(10) NOT NULL DEFAULT 0,
fullname VARCHAR(254) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
shortname VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
idnumber VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
summary LONGTEXT COLLATE utf8mb4_bin,
summaryformat TINYINT(2) NOT NULL DEFAULT 0,
format VARCHAR(21) COLLATE utf8mb4_bin NOT NULL DEFAULT 'topics',
showgrades TINYINT(2) NOT NULL DEFAULT 1,
newsitems MEDIUMINT(5) NOT NULL DEFAULT 1,
startdate BIGINT(10) NOT NULL DEFAULT 0,
enddate BIGINT(10) NOT NULL DEFAULT 0,
relativedatesmode TINYINT(1) NOT NULL DEFAULT 0,
marker BIGINT(10) NOT NULL DEFAULT 0,
maxbytes BIGINT(10) NOT NULL DEFAULT 0,
legacyfiles SMALLINT(4) NOT NULL DEFAULT 0,
showreports SMALLINT(4) NOT NULL DEFAULT 0,
visible TINYINT(1) NOT NULL DEFAULT 1,
visibleold TINYINT(1) NOT NULL DEFAULT 1,
downloadcontent TINYINT(1),
groupmode SMALLINT(4) NOT NULL DEFAULT 0,
groupmodeforce SMALLINT(4) NOT NULL DEFAULT 0,
defaultgroupingid BIGINT(10) NOT NULL DEFAULT 0,
lang VARCHAR(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
calendartype VARCHAR(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
theme VARCHAR(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
requested TINYINT(1) NOT NULL DEFAULT 0,
enablecompletion TINYINT(1) NOT NULL DEFAULT 0,
completionnotify TINYINT(1) NOT NULL DEFAULT 0,
cacherev BIGINT(10) NOT NULL DEFAULT 0,
originalcourseid BIGINT(10),
showactivitydates TINYINT(1) NOT NULL DEFAULT 0,
showcompletionconditions TINYINT(1),
CONSTRAINT PRIMARY KEY (id)
, KEY m_cour_cat2_ix (category)
, KEY m_cour_idn2_ix (idnumber)
, KEY m_cour_sho2_ix (shortname)
, KEY m_cour_sor2_ix (sortorder)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Central course table'
;
CREATE TABLE m_course_categories (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
idnumber VARCHAR(100) COLLATE utf8mb4_bin,
description LONGTEXT COLLATE utf8mb4_bin,
descriptionformat TINYINT(2) NOT NULL DEFAULT 0,
parent BIGINT(10) NOT NULL DEFAULT 0,
sortorder BIGINT(10) NOT NULL DEFAULT 0,
coursecount BIGINT(10) NOT NULL DEFAULT 0,
visible TINYINT(1) NOT NULL DEFAULT 1,
visibleold TINYINT(1) NOT NULL DEFAULT 1,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
depth BIGINT(10) NOT NULL DEFAULT 0,
path VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
theme VARCHAR(50) COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_courcate_par2_ix (parent)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Course categories'
;
CREATE TABLE m_course_completion_aggr_methd (
id BIGINT(10) NOT NULL auto_increment,
course BIGINT(10) NOT NULL DEFAULT 0,
criteriatype BIGINT(10),
method TINYINT(1) NOT NULL DEFAULT 0,
value NUMERIC(10,5),
CONSTRAINT PRIMARY KEY (id)
, KEY m_courcompaggrmeth_cou2_ix (course)
, KEY m_courcompaggrmeth_cri2_ix (criteriatype)
, UNIQUE KEY m_courcompaggrmeth_coucri2_uix (course, criteriatype)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Course completion aggregation methods for criteria'
;
CREATE TABLE m_course_completion_criteria (
id BIGINT(10) NOT NULL auto_increment,
course BIGINT(10) NOT NULL DEFAULT 0,
criteriatype BIGINT(10) NOT NULL DEFAULT 0,
module VARCHAR(100) COLLATE utf8mb4_bin,
moduleinstance BIGINT(10),
courseinstance BIGINT(10),
enrolperiod BIGINT(10),
timeend BIGINT(10),
gradepass NUMERIC(10,5),
role BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY m_courcompcrit_cou2_ix (course)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Course completion criteria'
;
CREATE TABLE m_course_completion_crit_compl (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL DEFAULT 0,
course BIGINT(10) NOT NULL DEFAULT 0,
criteriaid BIGINT(10) NOT NULL DEFAULT 0,
gradefinal NUMERIC(10,5),
unenroled BIGINT(10),
timecompleted BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY m_courcompcritcomp_use2_ix (userid)
, KEY m_courcompcritcomp_cou2_ix (course)
, KEY m_courcompcritcomp_cri2_ix (criteriaid)
, KEY m_courcompcritcomp_tim2_ix (timecompleted)
, UNIQUE KEY m_courcompcritcomp_usecou2_uix (userid, course, criteriaid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Course completion user records'
;
CREATE TABLE m_course_completions (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL DEFAULT 0,
course BIGINT(10) NOT NULL DEFAULT 0,
timeenrolled BIGINT(10) NOT NULL DEFAULT 0,
timestarted BIGINT(10) NOT NULL DEFAULT 0,
timecompleted BIGINT(10),
reaggregate BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_courcomp_use2_ix (userid)
, KEY m_courcomp_cou2_ix (course)
, KEY m_courcomp_tim2_ix (timecompleted)
, UNIQUE KEY m_courcomp_usecou2_uix (userid, course)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Course completion records'
;
CREATE TABLE m_enrol (
id BIGINT(10) NOT NULL auto_increment,
enrol VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
status BIGINT(10) NOT NULL DEFAULT 0,
courseid BIGINT(10) NOT NULL,
sortorder BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(255) COLLATE utf8mb4_bin,
enrolperiod BIGINT(10) DEFAULT 0,
enrolstartdate BIGINT(10) DEFAULT 0,
enrolenddate BIGINT(10) DEFAULT 0,
expirynotify TINYINT(1) DEFAULT 0,
expirythreshold BIGINT(10) DEFAULT 0,
notifyall TINYINT(1) DEFAULT 0,
password VARCHAR(50) COLLATE utf8mb4_bin,
cost VARCHAR(20) COLLATE utf8mb4_bin,
currency VARCHAR(3) COLLATE utf8mb4_bin,
roleid BIGINT(10) DEFAULT 0,
customint1 BIGINT(10),
customint2 BIGINT(10),
customint3 BIGINT(10),
customint4 BIGINT(10),
customint5 BIGINT(10),
customint6 BIGINT(10),
customint7 BIGINT(10),
customint8 BIGINT(10),
customchar1 VARCHAR(255) COLLATE utf8mb4_bin,
customchar2 VARCHAR(255) COLLATE utf8mb4_bin,
customchar3 VARCHAR(1333) COLLATE utf8mb4_bin,
customdec1 NUMERIC(12,7),
customdec2 NUMERIC(12,7),
customtext1 LONGTEXT COLLATE utf8mb4_bin,
customtext2 LONGTEXT COLLATE utf8mb4_bin,
customtext3 LONGTEXT COLLATE utf8mb4_bin,
customtext4 LONGTEXT COLLATE utf8mb4_bin,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_enro_enr2_ix (enrol)
, KEY m_enro_cou2_ix (courseid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Instances of enrolment plugins used in courses, fields marke'
;
CREATE TABLE m_user_enrolments (
id BIGINT(10) NOT NULL auto_increment,
status BIGINT(10) NOT NULL DEFAULT 0,
enrolid BIGINT(10) NOT NULL,
userid BIGINT(10) NOT NULL,
timestart BIGINT(10) NOT NULL DEFAULT 0,
timeend BIGINT(10) NOT NULL DEFAULT 2147483647,
modifierid BIGINT(10) NOT NULL DEFAULT 0,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_userenro_enruse2_uix (enrolid, userid)
, KEY m_userenro_enr2_ix (enrolid)
, KEY m_userenro_use2_ix (userid)
, KEY m_userenro_mod2_ix (modifierid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Users participating in courses (aka enrolled users) - everyb'
;
CREATE TABLE m_course_modules (
id BIGINT(10) NOT NULL auto_increment,
course BIGINT(10) NOT NULL DEFAULT 0,
module BIGINT(10) NOT NULL DEFAULT 0,
instance BIGINT(10) NOT NULL DEFAULT 0,
section BIGINT(10) NOT NULL DEFAULT 0,
idnumber VARCHAR(100) COLLATE utf8mb4_bin,
added BIGINT(10) NOT NULL DEFAULT 0,
score SMALLINT(4) NOT NULL DEFAULT 0,
indent MEDIUMINT(5) NOT NULL DEFAULT 0,
visible TINYINT(1) NOT NULL DEFAULT 1,
visibleoncoursepage TINYINT(1) NOT NULL DEFAULT 1,
visibleold TINYINT(1) NOT NULL DEFAULT 1,
groupmode SMALLINT(4) NOT NULL DEFAULT 0,
groupingid BIGINT(10) NOT NULL DEFAULT 0,
completion TINYINT(1) NOT NULL DEFAULT 0,
completiongradeitemnumber BIGINT(10),
completionview TINYINT(1) NOT NULL DEFAULT 0,
completionexpected BIGINT(10) NOT NULL DEFAULT 0,
showdescription TINYINT(1) NOT NULL DEFAULT 0,
availability LONGTEXT COLLATE utf8mb4_bin,
deletioninprogress TINYINT(1) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_courmodu_vis2_ix (visible)
, KEY m_courmodu_cou2_ix (course)
, KEY m_courmodu_mod2_ix (module)
, KEY m_courmodu_ins2_ix (instance)
, KEY m_courmodu_idncou2_ix (idnumber, course)
, KEY m_courmodu_gro2_ix (groupingid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='course_modules table retrofitted from MySQL'
;
CREATE TABLE m_course_modules_completion (
id BIGINT(10) NOT NULL auto_increment,
coursemoduleid BIGINT(10) NOT NULL,
userid BIGINT(10) NOT NULL,
completionstate TINYINT(1) NOT NULL,
viewed TINYINT(1),
overrideby BIGINT(10),
timemodified BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY m_courmoducomp_cou2_ix (coursemoduleid)
, UNIQUE KEY m_courmoducomp_usecou2_uix (userid, coursemoduleid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores the completion state (completed or not completed, etc'
;
CREATE TABLE m_course_sections (
id BIGINT(10) NOT NULL auto_increment,
course BIGINT(10) NOT NULL DEFAULT 0,
section BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(255) COLLATE utf8mb4_bin,
summary LONGTEXT COLLATE utf8mb4_bin,
summaryformat TINYINT(2) NOT NULL DEFAULT 0,
sequence LONGTEXT COLLATE utf8mb4_bin,
visible TINYINT(1) NOT NULL DEFAULT 1,
availability LONGTEXT COLLATE utf8mb4_bin,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_coursect_cousec2_uix (course, section)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='to define the sections for each course'
;
CREATE TABLE m_course_request (
id BIGINT(10) NOT NULL auto_increment,
fullname VARCHAR(254) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
shortname VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
summary LONGTEXT COLLATE utf8mb4_bin NOT NULL,
summaryformat TINYINT(2) NOT NULL DEFAULT 0,
category BIGINT(10) NOT NULL DEFAULT 0,
reason LONGTEXT COLLATE utf8mb4_bin NOT NULL,
requester BIGINT(10) NOT NULL DEFAULT 0,
password VARCHAR(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, KEY m_courrequ_sho2_ix (shortname)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='course requests'
;
CREATE TABLE m_course_format_options (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL,
format VARCHAR(21) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
sectionid BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_courformopti_couforsecn2_uix (courseid, format, sectionid, name)
, KEY m_courformopti_cou2_ix (courseid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores format-specific options for the course or course sect'
;
CREATE TABLE m_filter_active (
id BIGINT(10) NOT NULL auto_increment,
filter VARCHAR(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
contextid BIGINT(10) NOT NULL,
active SMALLINT(4) NOT NULL,
sortorder BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_filtacti_confil2_uix (contextid, filter)
, KEY m_filtacti_con2_ix (contextid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores information about which filters are active in which c'
;
CREATE TABLE m_filter_config (
id BIGINT(10) NOT NULL auto_increment,
filter VARCHAR(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
contextid BIGINT(10) NOT NULL,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_filtconf_confilnam2_uix (contextid, filter, name)
, KEY m_filtconf_con2_ix (contextid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores per-context configuration settings for filters which '
;
CREATE TABLE m_event (
id BIGINT(10) NOT NULL auto_increment,
name LONGTEXT COLLATE utf8mb4_bin NOT NULL,
description LONGTEXT COLLATE utf8mb4_bin NOT NULL,
format SMALLINT(4) NOT NULL DEFAULT 0,
categoryid BIGINT(10) NOT NULL DEFAULT 0,
courseid BIGINT(10) NOT NULL DEFAULT 0,
groupid BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
repeatid BIGINT(10) NOT NULL DEFAULT 0,
component VARCHAR(100) COLLATE utf8mb4_bin,
modulename VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
instance BIGINT(10) NOT NULL DEFAULT 0,
type SMALLINT(4) NOT NULL DEFAULT 0,
eventtype VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
timestart BIGINT(10) NOT NULL DEFAULT 0,
timeduration BIGINT(10) NOT NULL DEFAULT 0,
timesort BIGINT(10),
visible SMALLINT(4) NOT NULL DEFAULT 1,
uuid VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
sequence BIGINT(10) NOT NULL DEFAULT 1,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
subscriptionid BIGINT(10),
priority BIGINT(10),
location LONGTEXT COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_even_cou2_ix (courseid)
, KEY m_even_use2_ix (userid)
, KEY m_even_tim3_ix (timestart)
, KEY m_even_tim4_ix (timeduration)
, KEY m_even_uui2_ix (uuid)
, KEY m_even_typtim2_ix (type, timesort)
, KEY m_even_grocoucatvisuse2_ix (groupid, courseid, categoryid, visible, userid)
, KEY m_even_eve2_ix (eventtype)
, KEY m_even_comeveins2_ix (component, eventtype, instance)
, KEY m_even_modinseve2_ix (modulename, instance, eventtype)
, KEY m_even_cat2_ix (categoryid)
, KEY m_even_sub2_ix (subscriptionid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='For everything with a time associated to it'
;
CREATE TABLE m_cache_filters (
id BIGINT(10) NOT NULL auto_increment,
filter VARCHAR(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
version BIGINT(10) NOT NULL DEFAULT 0,
md5key VARCHAR(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
rawtext LONGTEXT COLLATE utf8mb4_bin NOT NULL,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_cachfilt_filmd52_ix (filter, md5key)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='For keeping information about cached data'
;
CREATE TABLE m_log (
id BIGINT(10) NOT NULL auto_increment,
time BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
ip VARCHAR(45) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
course BIGINT(10) NOT NULL DEFAULT 0,
module VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
cmid BIGINT(10) NOT NULL DEFAULT 0,
action VARCHAR(40) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
url VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
info VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, KEY m_log_coumodact2_ix (course, module, action)
, KEY m_log_tim2_ix (time)
, KEY m_log_act2_ix (action)
, KEY m_log_usecou2_ix (userid, course)
, KEY m_log_cmi2_ix (cmid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Every action is logged as far as possible'
;
CREATE TABLE m_log_queries (
id BIGINT(10) NOT NULL auto_increment,
qtype MEDIUMINT(5) NOT NULL,
sqltext LONGTEXT COLLATE utf8mb4_bin NOT NULL,
sqlparams LONGTEXT COLLATE utf8mb4_bin,
error MEDIUMINT(5) NOT NULL DEFAULT 0,
info LONGTEXT COLLATE utf8mb4_bin,
backtrace LONGTEXT COLLATE utf8mb4_bin,
exectime NUMERIC(10,5) NOT NULL,
timelogged BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Logged database queries.'
;
CREATE TABLE m_log_display (
id BIGINT(10) NOT NULL auto_increment,
module VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
action VARCHAR(40) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
mtable VARCHAR(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
field VARCHAR(200) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
component VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_logdisp_modact2_uix (module, action)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='For a particular module/action, specifies a moodle table/fie'
;
CREATE TABLE m_message (
id BIGINT(10) NOT NULL auto_increment,
useridfrom BIGINT(10) NOT NULL DEFAULT 0,
useridto BIGINT(10) NOT NULL DEFAULT 0,
subject LONGTEXT COLLATE utf8mb4_bin,
fullmessage LONGTEXT COLLATE utf8mb4_bin,
fullmessageformat SMALLINT(4) DEFAULT 0,
fullmessagehtml LONGTEXT COLLATE utf8mb4_bin,
smallmessage LONGTEXT COLLATE utf8mb4_bin,
notification TINYINT(1) DEFAULT 0,
contexturl LONGTEXT COLLATE utf8mb4_bin,
contexturlname LONGTEXT COLLATE utf8mb4_bin,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timeuserfromdeleted BIGINT(10) NOT NULL DEFAULT 0,
timeusertodeleted BIGINT(10) NOT NULL DEFAULT 0,
component VARCHAR(100) COLLATE utf8mb4_bin,
eventtype VARCHAR(100) COLLATE utf8mb4_bin,
customdata LONGTEXT COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_mess_useusetimtim2_ix (useridfrom, useridto, timeuserfromdeleted, timeusertodeleted)
, KEY m_mess_usetimnot3_ix (useridfrom, timeuserfromdeleted, notification)
, KEY m_mess_usetimnot4_ix (useridto, timeusertodeleted, notification)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores all unread messages'
;
CREATE TABLE m_message_read (
id BIGINT(10) NOT NULL auto_increment,
useridfrom BIGINT(10) NOT NULL DEFAULT 0,
useridto BIGINT(10) NOT NULL DEFAULT 0,
subject LONGTEXT COLLATE utf8mb4_bin,
fullmessage LONGTEXT COLLATE utf8mb4_bin,
fullmessageformat SMALLINT(4) DEFAULT 0,
fullmessagehtml LONGTEXT COLLATE utf8mb4_bin,
smallmessage LONGTEXT COLLATE utf8mb4_bin,
notification TINYINT(1) DEFAULT 0,
contexturl LONGTEXT COLLATE utf8mb4_bin,
contexturlname LONGTEXT COLLATE utf8mb4_bin,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timeread BIGINT(10) NOT NULL DEFAULT 0,
timeuserfromdeleted BIGINT(10) NOT NULL DEFAULT 0,
timeusertodeleted BIGINT(10) NOT NULL DEFAULT 0,
component VARCHAR(100) COLLATE utf8mb4_bin,
eventtype VARCHAR(100) COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_messread_useusetimtim2_ix (useridfrom, useridto, timeuserfromdeleted, timeusertodeleted)
, KEY m_messread_nottim2_ix (notification, timeread)
, KEY m_messread_usetimnot3_ix (useridfrom, timeuserfromdeleted, notification)
, KEY m_messread_usetimnot4_ix (useridto, timeusertodeleted, notification)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores all messages that have been read'
;
CREATE TABLE m_messages (
id BIGINT(10) NOT NULL auto_increment,
useridfrom BIGINT(10) NOT NULL,
conversationid BIGINT(10) NOT NULL,
subject LONGTEXT COLLATE utf8mb4_bin,
fullmessage LONGTEXT COLLATE utf8mb4_bin,
fullmessageformat TINYINT(1) NOT NULL DEFAULT 0,
fullmessagehtml LONGTEXT COLLATE utf8mb4_bin,
smallmessage LONGTEXT COLLATE utf8mb4_bin,
timecreated BIGINT(10) NOT NULL,
fullmessagetrust TINYINT(2) NOT NULL DEFAULT 0,
customdata LONGTEXT COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_mess_contim2_ix (conversationid, timecreated)
, KEY m_mess_use2_ix (useridfrom)
, KEY m_mess_con2_ix (conversationid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores all messages'
;
CREATE TABLE m_message_conversations (
id BIGINT(10) NOT NULL auto_increment,
type BIGINT(10) NOT NULL DEFAULT 1,
name VARCHAR(255) COLLATE utf8mb4_bin,
convhash VARCHAR(40) COLLATE utf8mb4_bin,
component VARCHAR(100) COLLATE utf8mb4_bin,
itemtype VARCHAR(100) COLLATE utf8mb4_bin,
itemid BIGINT(10),
contextid BIGINT(10),
enabled TINYINT(1) NOT NULL DEFAULT 0,
timecreated BIGINT(10) NOT NULL,
timemodified BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY m_messconv_typ2_ix (type)
, KEY m_messconv_con3_ix (convhash)
, KEY m_messconv_comiteitecon2_ix (component, itemtype, itemid, contextid)
, KEY m_messconv_con4_ix (contextid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores all message conversations'
;
CREATE TABLE m_message_conversation_members (
id BIGINT(10) NOT NULL auto_increment,
conversationid BIGINT(10) NOT NULL,
userid BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY m_messconvmemb_con2_ix (conversationid)
, KEY m_messconvmemb_use2_ix (userid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores all members in a conversations'
;
CREATE TABLE m_message_conversation_actions (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
conversationid BIGINT(10) NOT NULL,
action BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY m_messconvacti_use2_ix (userid)
, KEY m_messconvacti_con2_ix (conversationid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores all per-user actions on individual conversations'
;
CREATE TABLE m_message_user_actions (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
messageid BIGINT(10) NOT NULL,
action BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_messuseracti_usemesact2_uix (userid, messageid, action)
, KEY m_messuseracti_use2_ix (userid)
, KEY m_messuseracti_mes2_ix (messageid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores all per-user actions on individual messages'
;
CREATE TABLE m_notifications (
id BIGINT(10) NOT NULL auto_increment,
useridfrom BIGINT(10) NOT NULL,
useridto BIGINT(10) NOT NULL,
subject LONGTEXT COLLATE utf8mb4_bin,
fullmessage LONGTEXT COLLATE utf8mb4_bin,
fullmessageformat TINYINT(1) NOT NULL DEFAULT 0,
fullmessagehtml LONGTEXT COLLATE utf8mb4_bin,
smallmessage LONGTEXT COLLATE utf8mb4_bin,
component VARCHAR(100) COLLATE utf8mb4_bin,
eventtype VARCHAR(100) COLLATE utf8mb4_bin,
contexturl LONGTEXT COLLATE utf8mb4_bin,
contexturlname LONGTEXT COLLATE utf8mb4_bin,
timeread BIGINT(10),
timecreated BIGINT(10) NOT NULL,
customdata LONGTEXT COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_noti_use3_ix (useridfrom)
, KEY m_noti_use4_ix (useridto)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores all notifications'
;
CREATE TABLE m_message_contacts (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
contactid BIGINT(10) NOT NULL,
timecreated BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_messcont_usecon2_uix (userid, contactid)
, KEY m_messcont_use2_ix (userid)
, KEY m_messcont_con2_ix (contactid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Maintains lists of contacts between users'
;
CREATE TABLE m_message_contact_requests (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
requesteduserid BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_messcontrequ_usereq2_uix (userid, requesteduserid)
, KEY m_messcontrequ_use2_ix (userid)
, KEY m_messcontrequ_req2_ix (requesteduserid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Maintains list of contact requests between users'
;
CREATE TABLE m_message_users_blocked (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
blockeduserid BIGINT(10) NOT NULL,
timecreated BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_messuserbloc_useblo2_uix (userid, blockeduserid)
, KEY m_messuserbloc_use2_ix (userid)
, KEY m_messuserbloc_blo2_ix (blockeduserid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Maintains lists of blocked users'
;
CREATE TABLE m_modules (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
cron BIGINT(10) NOT NULL DEFAULT 0,
lastcron BIGINT(10) NOT NULL DEFAULT 0,
search VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
visible TINYINT(1) NOT NULL DEFAULT 1,
CONSTRAINT PRIMARY KEY (id)
, KEY m_modu_nam2_ix (name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='modules available in the site'
;
CREATE TABLE m_my_pages (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) DEFAULT 0,
name VARCHAR(200) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
private TINYINT(1) NOT NULL DEFAULT 1,
sortorder MEDIUMINT(6) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_mypage_usepri2_ix (userid, private)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Extra user pages for the My Moodle system'
;
CREATE TABLE m_sessions (
id BIGINT(10) NOT NULL auto_increment,
state BIGINT(10) NOT NULL DEFAULT 0,
sid VARCHAR(128) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
userid BIGINT(10) NOT NULL,
sessdata LONGTEXT COLLATE utf8mb4_bin,
timecreated BIGINT(10) NOT NULL,
timemodified BIGINT(10) NOT NULL,
firstip VARCHAR(45) COLLATE utf8mb4_bin,
lastip VARCHAR(45) COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_sess_sta2_ix (state)
, UNIQUE KEY m_sess_sid2_uix (sid)
, KEY m_sess_tim3_ix (timecreated)
, KEY m_sess_tim4_ix (timemodified)
, KEY m_sess_use2_ix (userid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Database based session storage - now recommended'
;
CREATE TABLE m_user (
id BIGINT(10) NOT NULL auto_increment,
auth VARCHAR(20) COLLATE utf8mb4_bin 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,
suspended TINYINT(1) NOT NULL DEFAULT 0,
mnethostid BIGINT(10) NOT NULL DEFAULT 0,
username VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
password VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
idnumber VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
firstname VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
lastname VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
email VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
emailstop TINYINT(1) NOT NULL DEFAULT 0,
phone1 VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
phone2 VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
institution VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
department VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
address VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
city VARCHAR(120) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
country VARCHAR(2) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
lang VARCHAR(30) COLLATE utf8mb4_bin NOT NULL DEFAULT 'en',
calendartype VARCHAR(30) COLLATE utf8mb4_bin NOT NULL DEFAULT 'gregorian',
theme VARCHAR(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
timezone VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '99',
firstaccess BIGINT(10) NOT NULL DEFAULT 0,
lastaccess BIGINT(10) NOT NULL DEFAULT 0,
lastlogin BIGINT(10) NOT NULL DEFAULT 0,
currentlogin BIGINT(10) NOT NULL DEFAULT 0,
lastip VARCHAR(45) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
secret VARCHAR(15) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
picture BIGINT(10) NOT NULL DEFAULT 0,
description LONGTEXT COLLATE utf8mb4_bin,
descriptionformat TINYINT(2) NOT NULL DEFAULT 1,
mailformat TINYINT(1) NOT NULL DEFAULT 1,
maildigest TINYINT(1) NOT NULL DEFAULT 0,
maildisplay TINYINT(2) NOT NULL DEFAULT 2,
autosubscribe TINYINT(1) NOT NULL DEFAULT 1,
trackforums TINYINT(1) NOT NULL DEFAULT 0,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
trustbitmask BIGINT(10) NOT NULL DEFAULT 0,
imagealt VARCHAR(255) COLLATE utf8mb4_bin,
lastnamephonetic VARCHAR(255) COLLATE utf8mb4_bin,
firstnamephonetic VARCHAR(255) COLLATE utf8mb4_bin,
middlename VARCHAR(255) COLLATE utf8mb4_bin,
alternatename VARCHAR(255) COLLATE utf8mb4_bin,
moodlenetprofile VARCHAR(255) COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_user_mneuse2_uix (mnethostid, username)
, KEY m_user_del2_ix (deleted)
, KEY m_user_con2_ix (confirmed)
, KEY m_user_fir3_ix (firstname)
, KEY m_user_las4_ix (lastname)
, KEY m_user_cit2_ix (city)
, KEY m_user_cou2_ix (country)
, KEY m_user_las5_ix (lastaccess)
, KEY m_user_ema2_ix (email)
, KEY m_user_aut2_ix (auth)
, KEY m_user_idn2_ix (idnumber)
, KEY m_user_fir4_ix (firstnamephonetic)
, KEY m_user_las6_ix (lastnamephonetic)
, KEY m_user_mid2_ix (middlename)
, KEY m_user_alt2_ix (alternatename)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='One record for each person'
;
CREATE TABLE m_user_preferences (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
value VARCHAR(1333) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_userpref_usenam2_uix (userid, name)
, KEY m_userpref_nam2_ix (name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Allows modules to store arbitrary user preferences'
;
CREATE TABLE m_user_lastaccess (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL DEFAULT 0,
courseid BIGINT(10) NOT NULL DEFAULT 0,
timeaccess BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_userlast_usecou2_uix (userid, courseid)
, KEY m_userlast_use2_ix (userid)
, KEY m_userlast_cou2_ix (courseid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='To keep track of course page access times, used in online pa'
;
CREATE TABLE m_user_password_history (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
hash VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
timecreated BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY m_userpasshist_use2_ix (userid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='A rotating log of hashes of previously used passwords for ea'
;
CREATE TABLE m_scale (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
scale LONGTEXT COLLATE utf8mb4_bin NOT NULL,
description LONGTEXT COLLATE utf8mb4_bin NOT NULL,
descriptionformat TINYINT(2) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_scal_cou2_ix (courseid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Defines grading scales'
;
CREATE TABLE m_scale_history (
id BIGINT(10) NOT NULL auto_increment,
action BIGINT(10) NOT NULL DEFAULT 0,
oldid BIGINT(10) NOT NULL,
source VARCHAR(255) COLLATE utf8mb4_bin,
timemodified BIGINT(10),
loggeduser BIGINT(10),
courseid BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
scale LONGTEXT COLLATE utf8mb4_bin NOT NULL,
description LONGTEXT COLLATE utf8mb4_bin NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY m_scalhist_act2_ix (action)
, KEY m_scalhist_tim2_ix (timemodified)
, KEY m_scalhist_old2_ix (oldid)
, KEY m_scalhist_cou2_ix (courseid)
, KEY m_scalhist_log2_ix (loggeduser)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='History table'
;
CREATE TABLE m_stats_daily (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL DEFAULT 0,
timeend BIGINT(10) NOT NULL DEFAULT 0,
roleid BIGINT(10) NOT NULL DEFAULT 0,
stattype VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT 'activity',
stat1 BIGINT(10) NOT NULL DEFAULT 0,
stat2 BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_statdail_cou2_ix (courseid)
, KEY m_statdail_tim2_ix (timeend)
, KEY m_statdail_rol2_ix (roleid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='to accumulate daily stats'
;
CREATE TABLE m_stats_weekly (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL DEFAULT 0,
timeend BIGINT(10) NOT NULL DEFAULT 0,
roleid BIGINT(10) NOT NULL DEFAULT 0,
stattype VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT 'activity',
stat1 BIGINT(10) NOT NULL DEFAULT 0,
stat2 BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_statweek_cou2_ix (courseid)
, KEY m_statweek_tim2_ix (timeend)
, KEY m_statweek_rol2_ix (roleid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='To accumulate weekly stats'
;
CREATE TABLE m_stats_monthly (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL DEFAULT 0,
timeend BIGINT(10) NOT NULL DEFAULT 0,
roleid BIGINT(10) NOT NULL DEFAULT 0,
stattype VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT 'activity',
stat1 BIGINT(10) NOT NULL DEFAULT 0,
stat2 BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_statmont_cou2_ix (courseid)
, KEY m_statmont_tim2_ix (timeend)
, KEY m_statmont_rol2_ix (roleid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='To accumulate monthly stats'
;
CREATE TABLE m_stats_user_daily (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
roleid BIGINT(10) NOT NULL DEFAULT 0,
timeend BIGINT(10) NOT NULL DEFAULT 0,
statsreads BIGINT(10) NOT NULL DEFAULT 0,
statswrites BIGINT(10) NOT NULL DEFAULT 0,
stattype VARCHAR(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, KEY m_statuserdail_cou2_ix (courseid)
, KEY m_statuserdail_use2_ix (userid)
, KEY m_statuserdail_rol2_ix (roleid)
, KEY m_statuserdail_tim2_ix (timeend)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='To accumulate daily stats per course/user'
;
CREATE TABLE m_stats_user_weekly (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
roleid BIGINT(10) NOT NULL DEFAULT 0,
timeend BIGINT(10) NOT NULL DEFAULT 0,
statsreads BIGINT(10) NOT NULL DEFAULT 0,
statswrites BIGINT(10) NOT NULL DEFAULT 0,
stattype VARCHAR(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, KEY m_statuserweek_cou2_ix (courseid)
, KEY m_statuserweek_use2_ix (userid)
, KEY m_statuserweek_rol2_ix (roleid)
, KEY m_statuserweek_tim2_ix (timeend)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='To accumulate weekly stats per course/user'
;
CREATE TABLE m_stats_user_monthly (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
roleid BIGINT(10) NOT NULL DEFAULT 0,
timeend BIGINT(10) NOT NULL DEFAULT 0,
statsreads BIGINT(10) NOT NULL DEFAULT 0,
statswrites BIGINT(10) NOT NULL DEFAULT 0,
stattype VARCHAR(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, KEY m_statusermont_cou2_ix (courseid)
, KEY m_statusermont_use2_ix (userid)
, KEY m_statusermont_rol2_ix (roleid)
, KEY m_statusermont_tim2_ix (timeend)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='To accumulate monthly stats per course/user'
;
CREATE TABLE m_post (
id BIGINT(10) NOT NULL auto_increment,
module VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
userid BIGINT(10) NOT NULL DEFAULT 0,
courseid BIGINT(10) NOT NULL DEFAULT 0,
groupid BIGINT(10) NOT NULL DEFAULT 0,
moduleid BIGINT(10) NOT NULL DEFAULT 0,
coursemoduleid BIGINT(10) NOT NULL DEFAULT 0,
subject VARCHAR(128) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
summary LONGTEXT COLLATE utf8mb4_bin,
content LONGTEXT COLLATE utf8mb4_bin,
uniquehash VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
rating BIGINT(10) NOT NULL DEFAULT 0,
format BIGINT(10) NOT NULL DEFAULT 0,
summaryformat TINYINT(2) NOT NULL DEFAULT 0,
attachment VARCHAR(100) COLLATE utf8mb4_bin,
publishstate VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT 'draft',
lastmodified BIGINT(10) NOT NULL DEFAULT 0,
created BIGINT(10) NOT NULL DEFAULT 0,
usermodified BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_post_iduse2_uix (id, userid)
, KEY m_post_las2_ix (lastmodified)
, KEY m_post_mod2_ix (module)
, KEY m_post_sub2_ix (subject)
, KEY m_post_use2_ix (usermodified)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Generic post table to hold data blog entries etc in differen'
;
CREATE TABLE m_role (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
shortname VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
description LONGTEXT COLLATE utf8mb4_bin NOT NULL,
sortorder BIGINT(10) NOT NULL DEFAULT 0,
archetype VARCHAR(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_role_sor2_uix (sortorder)
, UNIQUE KEY m_role_sho2_uix (shortname)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='moodle roles'
;
CREATE TABLE m_context (
id BIGINT(10) NOT NULL auto_increment,
contextlevel BIGINT(10) NOT NULL DEFAULT 0,
instanceid BIGINT(10) NOT NULL DEFAULT 0,
path VARCHAR(255) COLLATE utf8mb4_bin,
depth TINYINT(2) NOT NULL DEFAULT 0,
locked TINYINT(2) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_cont_conins2_uix (contextlevel, instanceid)
, KEY m_cont_ins2_ix (instanceid)
, KEY m_cont_pat2_ix (path)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='one of these must be set'
;
CREATE TABLE m_context_temp (
id BIGINT(10) NOT NULL,
path VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
depth TINYINT(2) NOT NULL,
locked TINYINT(2) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Used by build_context_path() in upgrade and cron to keep con'
;
CREATE TABLE m_capabilities (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
captype VARCHAR(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
contextlevel BIGINT(10) NOT NULL DEFAULT 0,
component VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
riskbitmask BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_capa_nam2_uix (name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='this defines all capabilities'
;
CREATE TABLE m_role_allow_assign (
id BIGINT(10) NOT NULL auto_increment,
roleid BIGINT(10) NOT NULL DEFAULT 0,
allowassign BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_rolealloassi_rolall2_uix (roleid, allowassign)
, KEY m_rolealloassi_rol2_ix (roleid)
, KEY m_rolealloassi_all2_ix (allowassign)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='this defines what role can assign what role'
;
CREATE TABLE m_role_allow_override (
id BIGINT(10) NOT NULL auto_increment,
roleid BIGINT(10) NOT NULL DEFAULT 0,
allowoverride BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_rolealloover_rolall2_uix (roleid, allowoverride)
, KEY m_rolealloover_rol2_ix (roleid)
, KEY m_rolealloover_all2_ix (allowoverride)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='this defines what role can override what role'
;
CREATE TABLE m_role_allow_switch (
id BIGINT(10) NOT NULL auto_increment,
roleid BIGINT(10) NOT NULL,
allowswitch BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_rolealloswit_rolall2_uix (roleid, allowswitch)
, KEY m_rolealloswit_rol2_ix (roleid)
, KEY m_rolealloswit_all2_ix (allowswitch)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='This table stores which which other roles a user is allowed '
;
CREATE TABLE m_role_allow_view (
id BIGINT(10) NOT NULL auto_increment,
roleid BIGINT(10) NOT NULL,
allowview BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_rolealloview_rolall2_uix (roleid, allowview)
, KEY m_rolealloview_rol2_ix (roleid)
, KEY m_rolealloview_all2_ix (allowview)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='This table stores which which other roles a user is allowed '
;
CREATE TABLE m_role_assignments (
id BIGINT(10) NOT NULL auto_increment,
roleid BIGINT(10) NOT NULL DEFAULT 0,
contextid BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
modifierid BIGINT(10) NOT NULL DEFAULT 0,
component VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
itemid BIGINT(10) NOT NULL DEFAULT 0,
sortorder BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_roleassi_sor2_ix (sortorder)
, KEY m_roleassi_rolcon2_ix (roleid, contextid)
, KEY m_roleassi_useconrol2_ix (userid, contextid, roleid)
, KEY m_roleassi_comiteuse2_ix (component, itemid, userid)
, KEY m_roleassi_rol2_ix (roleid)
, KEY m_roleassi_con2_ix (contextid)
, KEY m_roleassi_use2_ix (userid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='assigning roles in different context'
;
CREATE TABLE m_role_capabilities (
id BIGINT(10) NOT NULL auto_increment,
contextid BIGINT(10) NOT NULL DEFAULT 0,
roleid BIGINT(10) NOT NULL DEFAULT 0,
capability VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
permission BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
modifierid BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_rolecapa_rolconcap2_uix (roleid, contextid, capability)
, KEY m_rolecapa_rol2_ix (roleid)
, KEY m_rolecapa_con2_ix (contextid)
, KEY m_rolecapa_mod2_ix (modifierid)
, KEY m_rolecapa_cap2_ix (capability)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='permission has to be signed, overriding a capability for a p'
;
CREATE TABLE m_role_names (
id BIGINT(10) NOT NULL auto_increment,
roleid BIGINT(10) NOT NULL DEFAULT 0,
contextid BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_rolename_rolcon2_uix (roleid, contextid)
, KEY m_rolename_rol2_ix (roleid)
, KEY m_rolename_con2_ix (contextid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='role names in native strings'
;
CREATE TABLE m_role_context_levels (
id BIGINT(10) NOT NULL auto_increment,
roleid BIGINT(10) NOT NULL,
contextlevel BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_rolecontleve_conrol2_uix (contextlevel, roleid)
, KEY m_rolecontleve_rol2_ix (roleid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Lists which roles can be assigned at which context levels. T'
;
CREATE TABLE m_user_info_field (
id BIGINT(10) NOT NULL auto_increment,
shortname VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT 'shortname',
name LONGTEXT COLLATE utf8mb4_bin NOT NULL,
datatype VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
description LONGTEXT COLLATE utf8mb4_bin,
descriptionformat TINYINT(2) NOT NULL DEFAULT 0,
categoryid BIGINT(10) NOT NULL DEFAULT 0,
sortorder BIGINT(10) NOT NULL DEFAULT 0,
required TINYINT(2) NOT NULL DEFAULT 0,
locked TINYINT(2) NOT NULL DEFAULT 0,
visible SMALLINT(4) NOT NULL DEFAULT 0,
forceunique TINYINT(2) NOT NULL DEFAULT 0,
signup TINYINT(2) NOT NULL DEFAULT 0,
defaultdata LONGTEXT COLLATE utf8mb4_bin,
defaultdataformat TINYINT(2) NOT NULL DEFAULT 0,
param1 LONGTEXT COLLATE utf8mb4_bin,
param2 LONGTEXT COLLATE utf8mb4_bin,
param3 LONGTEXT COLLATE utf8mb4_bin,
param4 LONGTEXT COLLATE utf8mb4_bin,
param5 LONGTEXT COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Customisable user profile fields'
;
CREATE TABLE m_user_info_category (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
sortorder BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Customisable fields categories'
;
CREATE TABLE m_user_info_data (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL DEFAULT 0,
fieldid BIGINT(10) NOT NULL DEFAULT 0,
data LONGTEXT COLLATE utf8mb4_bin NOT NULL,
dataformat TINYINT(2) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_userinfodata_usefie2_uix (userid, fieldid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Data for the customisable user fields'
;
CREATE TABLE m_question_categories (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
contextid BIGINT(10) NOT NULL DEFAULT 0,
info LONGTEXT COLLATE utf8mb4_bin NOT NULL,
infoformat TINYINT(2) NOT NULL DEFAULT 0,
stamp VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
parent BIGINT(10) NOT NULL DEFAULT 0,
sortorder BIGINT(10) NOT NULL DEFAULT 999,
idnumber VARCHAR(100) COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_quescate_con2_ix (contextid)
, UNIQUE KEY m_quescate_consta2_uix (contextid, stamp)
, UNIQUE KEY m_quescate_conidn2_uix (contextid, idnumber)
, KEY m_quescate_par2_ix (parent)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Categories are for grouping questions'
;
CREATE TABLE m_question (
id BIGINT(10) NOT NULL auto_increment,
category BIGINT(10) NOT NULL DEFAULT 0,
parent BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
questiontext LONGTEXT COLLATE utf8mb4_bin NOT NULL,
questiontextformat TINYINT(2) NOT NULL DEFAULT 0,
generalfeedback LONGTEXT COLLATE utf8mb4_bin NOT NULL,
generalfeedbackformat TINYINT(2) NOT NULL DEFAULT 0,
defaultmark NUMERIC(12,7) NOT NULL DEFAULT 1,
penalty NUMERIC(12,7) NOT NULL DEFAULT 0.3333333,
qtype VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
length BIGINT(10) NOT NULL DEFAULT 1,
stamp VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
version VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
hidden TINYINT(1) NOT NULL DEFAULT 0,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
createdby BIGINT(10),
modifiedby BIGINT(10),
idnumber VARCHAR(100) COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_ques_qty2_ix (qtype)
, UNIQUE KEY m_ques_catidn2_uix (category, idnumber)
, KEY m_ques_cat2_ix (category)
, KEY m_ques_par2_ix (parent)
, KEY m_ques_cre2_ix (createdby)
, KEY m_ques_mod2_ix (modifiedby)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='The questions themselves'
;
CREATE TABLE m_question_answers (
id BIGINT(10) NOT NULL auto_increment,
question BIGINT(10) NOT NULL DEFAULT 0,
answer LONGTEXT COLLATE utf8mb4_bin NOT NULL,
answerformat TINYINT(2) NOT NULL DEFAULT 0,
fraction NUMERIC(12,7) NOT NULL DEFAULT 0,
feedback LONGTEXT COLLATE utf8mb4_bin NOT NULL,
feedbackformat TINYINT(2) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_quesansw_que2_ix (question)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Answers, with a fractional grade (0-1) and feedback'
;
CREATE TABLE m_question_hints (
id BIGINT(10) NOT NULL auto_increment,
questionid BIGINT(10) NOT NULL,
hint LONGTEXT COLLATE utf8mb4_bin NOT NULL,
hintformat SMALLINT(4) NOT NULL DEFAULT 0,
shownumcorrect TINYINT(1),
clearwrong TINYINT(1),
options VARCHAR(255) COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_queshint_que2_ix (questionid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores the the part of the question definition that gives di'
;
CREATE TABLE m_question_usages (
id BIGINT(10) NOT NULL auto_increment,
contextid BIGINT(10) NOT NULL,
component VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
preferredbehaviour VARCHAR(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, KEY m_quesusag_con2_ix (contextid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='This table\'s main purpose it to assign a unique id to each a'
;
CREATE TABLE m_question_attempts (
id BIGINT(10) NOT NULL auto_increment,
questionusageid BIGINT(10) NOT NULL,
slot BIGINT(10) NOT NULL,
behaviour VARCHAR(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
questionid BIGINT(10) NOT NULL,
variant BIGINT(10) NOT NULL DEFAULT 1,
maxmark NUMERIC(12,7) NOT NULL,
minfraction NUMERIC(12,7) NOT NULL,
maxfraction NUMERIC(12,7) NOT NULL DEFAULT 1,
flagged TINYINT(1) NOT NULL DEFAULT 0,
questionsummary LONGTEXT COLLATE utf8mb4_bin,
rightanswer LONGTEXT COLLATE utf8mb4_bin,
responsesummary LONGTEXT COLLATE utf8mb4_bin,
timemodified BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_quesatte_queslo2_uix (questionusageid, slot)
, KEY m_quesatte_beh2_ix (behaviour)
, KEY m_quesatte_que3_ix (questionid)
, KEY m_quesatte_que4_ix (questionusageid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Each row here corresponds to an attempt at one question, as '
;
CREATE TABLE m_question_attempt_steps (
id BIGINT(10) NOT NULL auto_increment,
questionattemptid BIGINT(10) NOT NULL,
sequencenumber BIGINT(10) NOT NULL,
state VARCHAR(13) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
fraction NUMERIC(12,7),
timecreated BIGINT(10) NOT NULL,
userid BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_quesattestep_queseq2_uix (questionattemptid, sequencenumber)
, KEY m_quesattestep_que2_ix (questionattemptid)
, KEY m_quesattestep_use2_ix (userid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Stores one step in in a question attempt. As well as the dat'
;
CREATE TABLE m_question_attempt_step_data (
id BIGINT(10) NOT NULL auto_increment,
attemptstepid BIGINT(10) NOT NULL,
name VARCHAR(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_bin,
CONSTRAINT PRIMARY KEY (id)
, KEY m_quesattestepdata_att2_ix (attemptstepid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Each question_attempt_step has an associative array of the d'
;
CREATE TABLE m_question_statistics (
id BIGINT(10) NOT NULL auto_increment,
hashcode VARCHAR(40) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
timemodified BIGINT(10) NOT NULL,
questionid BIGINT(10) NOT NULL,
slot BIGINT(10),
subquestion SMALLINT(4) NOT NULL,
variant BIGINT(10),
s BIGINT(10) NOT NULL DEFAULT 0,
effectiveweight NUMERIC(15,5),
negcovar TINYINT(2) NOT NULL DEFAULT 0,
discriminationindex NUMERIC(15,5),
discriminativeefficiency NUMERIC(15,5),
sd NUMERIC(15,10),
facility NUMERIC(15,10),
subquestions LONGTEXT COLLATE utf8mb4_bin,
maxmark NUMERIC(12,7),
positions LONGTEXT COLLATE utf8mb4_bin,
randomguessscore NUMERIC(12,7),
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Statistics for individual questions used in an activity.'
;
CREATE TABLE m_question_response_analysis (
id BIGINT(10) NOT NULL auto_increment,
hashcode VARCHAR(40) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
whichtries VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
timemodified BIGINT(10) NOT NULL,
questionid BIGINT(10) NOT NULL,
variant BIGINT(10),
subqid VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
aid VARCHAR(100) COLLATE utf8mb4_bin,
response LONGTEXT COLLATE utf8mb4_bin,
credit NUMERIC(15,5) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Analysis of student responses given to questions.'
;
CREATE TABLE m_question_response_count (
id BIGINT(10) NOT NULL auto_increment,
analysisid BIGINT(10) NOT NULL,
try BIGINT(10) NOT NULL,
rcount BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY m_quesrespcoun_ana2_ix (analysisid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Count for each responses for each try at a question.'
;
CREATE TABLE m_mnet_application (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
display_name VARCHAR(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
xmlrpc_server_url VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
sso_land_url VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
sso_jump_url VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Information about applications on remote hosts'
;
CREATE TABLE m_mnet_host (
id BIGINT(10) NOT NULL auto_increment,
deleted TINYINT(1) NOT NULL DEFAULT 0,
wwwroot VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
ip_address VARCHAR(45) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
name VARCHAR(80) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
public_key LONGTEXT COLLATE utf8mb4_bin NOT NULL,
public_key_expires BIGINT(10) NOT NULL DEFAULT 0,
transport TINYINT(2) NOT NULL DEFAULT 0,
portno MEDIUMINT(5) NOT NULL DEFAULT 0,
last_connect_time BIGINT(10) NOT NULL DEFAULT 0,
last_log_id BIGINT(10) NOT NULL DEFAULT 0,
force_theme TINYINT(1) NOT NULL DEFAULT 0,
theme VARCHAR(100) COLLATE utf8mb4_bin,
applicationid BIGINT(10) NOT NULL DEFAULT 1,
sslverification TINYINT(1) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY m_mnethost_app2_ix (applicationid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Information about the local and remote hosts for RPC'
;
CREATE TABLE m_mnet_host2service (
id BIGINT(10) NOT NULL auto_increment,
hostid BIGINT(10) NOT NULL DEFAULT 0,
serviceid BIGINT(10) NOT NULL DEFAULT 0,
publish TINYINT(1) NOT NULL DEFAULT 0,
subscribe TINYINT(1) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_mnethost_hosser2_uix (hostid, serviceid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Information about the services for a given host'
;
CREATE TABLE m_mnet_log (
id BIGINT(10) NOT NULL auto_increment,
hostid BIGINT(10) NOT NULL DEFAULT 0,
remoteid BIGINT(10) NOT NULL DEFAULT 0,
time BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL DEFAULT 0,
ip VARCHAR(45) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
course BIGINT(10) NOT NULL DEFAULT 0,
coursename VARCHAR(40) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
module VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
cmid BIGINT(10) NOT NULL DEFAULT 0,
action VARCHAR(40) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
url VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
info VARCHAR(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, KEY m_mnetlog_hosusecou2_ix (hostid, userid, course)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Store session data from users migrating to other sites'
;
CREATE TABLE m_mnet_rpc (
id BIGINT(10) NOT NULL auto_increment,
functionname VARCHAR(40) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
xmlrpcpath VARCHAR(80) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
plugintype VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
pluginname VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
enabled TINYINT(1) NOT NULL DEFAULT 0,
help LONGTEXT COLLATE utf8mb4_bin NOT NULL,
profile LONGTEXT COLLATE utf8mb4_bin NOT NULL,
filename VARCHAR(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
classname VARCHAR(150) COLLATE utf8mb4_bin,
static TINYINT(1),
CONSTRAINT PRIMARY KEY (id)
, KEY m_mnetrpc_enaxml2_ix (enabled, xmlrpcpath)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='Functions or methods that we may publish or subscribe to'
;
CREATE TABLE m_mnet_remote_rpc (
id BIGINT(10) NOT NULL auto_increment,
functionname VARCHAR(40) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
xmlrpcpath VARCHAR(80) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
plugintype VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
pluginname VARCHAR(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
enabled TINYINT(1) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='This table describes functions that might be called remotely'
;
CREATE TABLE m_mnet_service (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(40) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
description VARCHAR(40) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
apiversion VARCHAR(10) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
offer TINYINT(1) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_bin ROW_FORMAT=Compressed
COMMENT='A service is a group of functions'
;
CREATE TABLE m_mnet_service2rpc (
id BIGINT(10) NOT NULL auto_increment,
serviceid BIGINT(10) NOT NULL DEFAULT 0,
rpcid BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY m_mnetserv_rpcser2_uix (rpcid, serviceid)
)
....
I copied official repo of Moodle then followed steps in quickstarts here, so I get this kind of error. It is 1st installation. So don't know why this is happend