ㅇㅇㅇ
Tables (50)
cache_filters
- id — BIGINT(10) — Primary key — NOT NULL
- filter — VARCHAR(32) — NOT NULL
- version — BIGINT(10) — NOT NULL
- md5key — VARCHAR(32) — NOT NULL
- rawtext — LONGTEXT — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `cachfilt_filmd52_ix`
capabilities
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- captype — VARCHAR(50) — NOT NULL
- contextlevel — BIGINT(10) — NOT NULL
- component — VARCHAR(100) — NOT NULL
- riskbitmask — BIGINT(10) — NOT NULL
config
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- value — LONGTEXT — NOT NULL
config_log
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — Foreign key → user.id — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- plugin — VARCHAR(100)
- name — VARCHAR(100) — NOT NULL
- value — LONGTEXT
- oldvalue — LONGTEXT
- INDEX — `conflog_tim2_ix`
- INDEX — `conflog_use4_ix`
config_plugins
- id — BIGINT(10) — Primary key — NOT NULL
- plugin — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- value — LONGTEXT — NOT NULL
context
- id — BIGINT(10) — Primary key — NOT NULL
- contextlevel — BIGINT(10) — NOT NULL
- instanceid — BIGINT(10) — NOT NULL
- path — VARCHAR(255)
- depth — TINYINT(2) — NOT NULL
- INDEX — `cont_ins2_ix`
- INDEX — `cont_pat2_ix`
context_temp
- id — BIGINT(10) — Primary key — NOT NULL
- path — VARCHAR(255) — NOT NULL
- depth — TINYINT(2) — NOT NULL
course
- id — BIGINT(10) — Primary key — NOT NULL
- category — BIGINT(10) — Foreign key → course_categories.id — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- fullname — VARCHAR(254) — NOT NULL
- shortname — VARCHAR(255) — NOT NULL
- idnumber — VARCHAR(100) — NOT NULL
- summary — LONGTEXT
- summaryformat — TINYINT(2) — NOT NULL
- format — VARCHAR(21) — NOT NULL
- showgrades — TINYINT(2) — NOT NULL
- newsitems — MEDIUMINT(5) — NOT NULL
- startdate — BIGINT(10) — NOT NULL
- enddate — BIGINT(10) — NOT NULL
- marker — BIGINT(10) — NOT NULL
- maxbytes — BIGINT(10) — NOT NULL
- legacyfiles — SMALLINT(4) — NOT NULL
- showreports — SMALLINT(4) — NOT NULL
- visible — TINYINT(1) — NOT NULL
- visibleold — TINYINT(1) — NOT NULL
- groupmode — SMALLINT(4) — NOT NULL
- groupmodeforce — SMALLINT(4) — NOT NULL
- defaultgroupingid — BIGINT(10) — NOT NULL
- lang — VARCHAR(30) — NOT NULL
- calendartype — VARCHAR(30) — NOT NULL
- theme — VARCHAR(50) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- requested — TINYINT(1) — NOT NULL
- enablecompletion — TINYINT(1) — NOT NULL
- completionnotify — TINYINT(1) — NOT NULL
- cacherev — BIGINT(10) — NOT NULL
- INDEX — `cour_cat2_ix`
- INDEX — `cour_idn2_ix`
- INDEX — `cour_sho2_ix`
- INDEX — `cour_sor2_ix`
course_categories
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- idnumber — VARCHAR(100)
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- parent — BIGINT(10) — Foreign key → course_categories.id — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- coursecount — BIGINT(10) — NOT NULL
- visible — TINYINT(1) — NOT NULL
- visibleold — TINYINT(1) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- depth — BIGINT(10) — NOT NULL
- path — VARCHAR(255) — NOT NULL
- theme — VARCHAR(50)
- INDEX — `courcate_par4_ix`
course_completion_aggr_methd
- id — BIGINT(10) — Primary key — NOT NULL
- course — BIGINT(10) — Foreign key → course.id — NOT NULL
- criteriatype — BIGINT(10)
- method — TINYINT(1) — NOT NULL
- value — DECIMAL(10, 5)
- INDEX — `courcompaggrmeth_cou2_ix`
- INDEX — `courcompaggrmeth_cri2_ix`
course_completion_crit_compl
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — NOT NULL
- course — BIGINT(10) — NOT NULL
- criteriaid — BIGINT(10) — NOT NULL
- gradefinal — DECIMAL(10, 5)
- unenroled — BIGINT(10)
- timecompleted — BIGINT(10)
- INDEX — `courcompcritcomp_use2_ix`
- INDEX — `courcompcritcomp_cou2_ix`
- INDEX — `courcompcritcomp_cri2_ix`
- INDEX — `courcompcritcomp_tim2_ix`
course_completion_criteria
- id — BIGINT(10) — Primary key — NOT NULL
- course — BIGINT(10) — Foreign key → course.id — NOT NULL
- criteriatype — BIGINT(10) — NOT NULL
- module — VARCHAR(100)
- moduleinstance — BIGINT(10)
- courseinstance — BIGINT(10)
- enrolperiod — BIGINT(10)
- timeend — BIGINT(10)
- gradepass — DECIMAL(10, 5)
- role — BIGINT(10)
- INDEX — `courcompcrit_cou2_ix`
course_completions
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — NOT NULL
- course — BIGINT(10) — Foreign key → course.id — NOT NULL
- timeenrolled — BIGINT(10) — NOT NULL
- timestarted — BIGINT(10) — NOT NULL
- timecompleted — BIGINT(10)
- reaggregate — BIGINT(10) — NOT NULL
- INDEX — `courcomp_use2_ix`
- INDEX — `courcomp_cou2_ix`
- INDEX — `courcomp_tim2_ix`
course_format_options
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — Foreign key → course.id — NOT NULL
- format — VARCHAR(21) — NOT NULL
- sectionid — BIGINT(10) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- value — LONGTEXT
- INDEX — `courformopti_cou4_ix`
course_modules
- id — BIGINT(10) — Primary key — NOT NULL
- course — BIGINT(10) — Foreign key → course.id — NOT NULL
- module — BIGINT(10) — NOT NULL
- instance — BIGINT(10) — NOT NULL
- section — BIGINT(10) — NOT NULL
- idnumber — VARCHAR(100)
- added — BIGINT(10) — NOT NULL
- score — SMALLINT(4) — NOT NULL
- indent — MEDIUMINT(5) — NOT NULL
- visible — TINYINT(1) — NOT NULL
- visibleoncoursepage — TINYINT(1) — NOT NULL
- visibleold — TINYINT(1) — NOT NULL
- groupmode — SMALLINT(4) — NOT NULL
- groupingid — BIGINT(10) — Foreign key → groupings.id — NOT NULL
- completion — TINYINT(1) — NOT NULL
- completiongradeitemnumber — BIGINT(10)
- completionview — TINYINT(1) — NOT NULL
- completionexpected — BIGINT(10) — NOT NULL
- showdescription — TINYINT(1) — NOT NULL
- availability — LONGTEXT
- deletioninprogress — TINYINT(1) — NOT NULL
- INDEX — `courmodu_vis2_ix`
- INDEX — `courmodu_cou2_ix`
- INDEX — `courmodu_mod2_ix`
- INDEX — `courmodu_ins2_ix`
- INDEX — `courmodu_idncou2_ix`
- INDEX — `courmodu_gro4_ix`
course_modules_completion
- id — BIGINT(10) — Primary key — NOT NULL
- 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
- INDEX — `courmoducomp_cou2_ix`
course_request
- id — BIGINT(10) — Primary key — NOT NULL
- fullname — VARCHAR(254) — NOT NULL
- shortname — VARCHAR(100) — NOT NULL
- summary — LONGTEXT — NOT NULL
- summaryformat — TINYINT(2) — NOT NULL
- category — BIGINT(10) — NOT NULL
- reason — LONGTEXT — NOT NULL
- requester — BIGINT(10) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- INDEX — `courrequ_sho2_ix`
course_sections
- id — BIGINT(10) — Primary key — NOT NULL
- course — BIGINT(10) — Foreign key → course.id — NOT NULL
- section — BIGINT(10) — NOT NULL
- name — VARCHAR(255)
- summary — LONGTEXT
- summaryformat — TINYINT(2) — NOT NULL
- sequence — LONGTEXT
- visible — TINYINT(1) — NOT NULL
- availability — LONGTEXT
- timemodified — BIGINT(10) — NOT NULL
enrol
- id — BIGINT(10) — Primary key — NOT NULL
- enrol — VARCHAR(20) — NOT NULL
- status — BIGINT(10) — NOT NULL
- courseid — BIGINT(10) — Foreign key → course.id — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- name — VARCHAR(255)
- enrolperiod — BIGINT(10)
- enrolstartdate — BIGINT(10)
- enrolenddate — BIGINT(10)
- expirynotify — TINYINT(1)
- expirythreshold — BIGINT(10)
- notifyall — TINYINT(1)
- password — VARCHAR(50)
- cost — VARCHAR(20)
- currency — VARCHAR(3)
- roleid — BIGINT(10)
- 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)
- customchar2 — VARCHAR(255)
- customchar3 — VARCHAR(1333)
- customdec1 — DECIMAL(12, 7)
- customdec2 — DECIMAL(12, 7)
- customtext1 — LONGTEXT
- customtext2 — LONGTEXT
- customtext3 — LONGTEXT
- customtext4 — LONGTEXT
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `enro_enr2_ix`
- INDEX — `enro_cou4_ix`
event
- id — BIGINT(10) — Primary key — NOT NULL
- name — LONGTEXT — NOT NULL
- description — LONGTEXT — NOT NULL
- format — SMALLINT(4) — NOT NULL
- categoryid — BIGINT(10) — Foreign key → course_categories.id — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- groupid — BIGINT(10) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- repeatid — BIGINT(10) — NOT NULL
- modulename — VARCHAR(20) — NOT NULL
- instance — BIGINT(10) — NOT NULL
- type — SMALLINT(4) — NOT NULL
- eventtype — VARCHAR(20) — NOT NULL
- timestart — BIGINT(10) — NOT NULL
- timeduration — BIGINT(10) — NOT NULL
- timesort — BIGINT(10)
- visible — SMALLINT(4) — NOT NULL
- uuid — VARCHAR(255) — NOT NULL
- sequence — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- subscriptionid — BIGINT(10)
- priority — BIGINT(10)
- INDEX — `even_cou2_ix`
- INDEX — `even_use2_ix`
- INDEX — `even_tim3_ix`
- INDEX — `even_tim4_ix`
- INDEX — `even_typtim2_ix`
- INDEX — `even_grocoucatvisuse2_ix`
- INDEX — `even_cat4_ix`
filter_active
- id — BIGINT(10) — Primary key — NOT NULL
- filter — VARCHAR(32) — NOT NULL
- contextid — BIGINT(10) — Foreign key → context.id — NOT NULL
- active — SMALLINT(4) — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- INDEX — `filtacti_con4_ix`
filter_config
- id — BIGINT(10) — Primary key — NOT NULL
- filter — VARCHAR(32) — NOT NULL
- contextid — BIGINT(10) — Foreign key → context.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- value — LONGTEXT
- INDEX — `filtconf_con4_ix`
groupings
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — Foreign key → course.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- idnumber — VARCHAR(100) — NOT NULL
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- configdata — LONGTEXT
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `grou_idn3_ix`
- INDEX — `grou_cou8_ix`
log
- id — BIGINT(10) — Primary key — NOT NULL
- time — BIGINT(10) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- ip — VARCHAR(45) — NOT NULL
- course — BIGINT(10) — NOT NULL
- module — VARCHAR(20) — NOT NULL
- cmid — BIGINT(10) — NOT NULL
- action — VARCHAR(40) — NOT NULL
- url — VARCHAR(100) — NOT NULL
- info — VARCHAR(255) — NOT NULL
- INDEX — `log_coumodact2_ix`
- INDEX — `log_tim2_ix`
- INDEX — `log_act2_ix`
- INDEX — `log_usecou2_ix`
- INDEX — `log_cmi2_ix`
log_display
- id — BIGINT(10) — Primary key — NOT NULL
- module — VARCHAR(20) — NOT NULL
- action — VARCHAR(40) — NOT NULL
- mtable — VARCHAR(30) — NOT NULL
- field — VARCHAR(200) — NOT NULL
- component — VARCHAR(100) — NOT NULL
log_queries
- id — BIGINT(10) — Primary key — NOT NULL
- qtype — MEDIUMINT(5) — NOT NULL
- sqltext — LONGTEXT — NOT NULL
- sqlparams — LONGTEXT
- error — MEDIUMINT(5) — NOT NULL
- info — LONGTEXT
- backtrace — LONGTEXT
- exectime — DECIMAL(10, 5) — NOT NULL
- timelogged — BIGINT(10) — NOT NULL
message
- id — BIGINT(10) — Primary key — NOT NULL
- useridfrom — BIGINT(10) — NOT NULL
- useridto — BIGINT(10) — NOT NULL
- subject — LONGTEXT
- fullmessage — LONGTEXT
- fullmessageformat — SMALLINT(4)
- fullmessagehtml — LONGTEXT
- smallmessage — LONGTEXT
- notification — TINYINT(1)
- contexturl — LONGTEXT
- contexturlname — LONGTEXT
- timecreated — BIGINT(10) — NOT NULL
- timeuserfromdeleted — BIGINT(10) — NOT NULL
- timeusertodeleted — BIGINT(10) — NOT NULL
- component — VARCHAR(100)
- eventtype — VARCHAR(100)
- INDEX — `mess_useusetimtim2_ix`
- INDEX — `mess_usetimnot3_ix`
- INDEX — `mess_usetimnot4_ix`
message_contacts
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — Foreign key → user.id — NOT NULL
- contactid — BIGINT(10) — NOT NULL
- blocked — TINYINT(1) — NOT NULL
message_read
- id — BIGINT(10) — Primary key — NOT NULL
- useridfrom — BIGINT(10) — Foreign key → user.id — NOT NULL
- useridto — BIGINT(10) — Foreign key → user.id — NOT NULL
- subject — LONGTEXT
- fullmessage — LONGTEXT
- fullmessageformat — SMALLINT(4)
- fullmessagehtml — LONGTEXT
- smallmessage — LONGTEXT
- notification — TINYINT(1)
- contexturl — LONGTEXT
- contexturlname — LONGTEXT
- timecreated — BIGINT(10) — NOT NULL
- timeread — BIGINT(10) — NOT NULL
- timeuserfromdeleted — BIGINT(10) — NOT NULL
- timeusertodeleted — BIGINT(10) — NOT NULL
- component — VARCHAR(100)
- eventtype — VARCHAR(100)
- INDEX — `messread_useusetimtim2_ix`
- INDEX — `messread_nottim2_ix`
- INDEX — `messread_usetimnot3_ix`
- INDEX — `messread_usetimnot4_ix`
modules
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
- cron — BIGINT(10) — NOT NULL
- lastcron — BIGINT(10) — NOT NULL
- search — VARCHAR(255) — NOT NULL
- visible — TINYINT(1) — NOT NULL
- INDEX — `modu_nam2_ix`
my_pages
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10)
- name — VARCHAR(200) — NOT NULL
- private — TINYINT(1) — NOT NULL
- sortorder — MEDIUMINT(6) — NOT NULL
- INDEX — `mypage_usepri2_ix`
post
- id — BIGINT(10) — Primary key — NOT NULL
- module — VARCHAR(20) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- groupid — BIGINT(10) — NOT NULL
- moduleid — BIGINT(10) — NOT NULL
- coursemoduleid — BIGINT(10) — NOT NULL
- subject — VARCHAR(128) — NOT NULL
- summary — LONGTEXT
- content — LONGTEXT
- uniquehash — VARCHAR(255) — NOT NULL
- rating — BIGINT(10) — NOT NULL
- format — BIGINT(10) — NOT NULL
- summaryformat — TINYINT(2) — NOT NULL
- attachment — VARCHAR(100)
- publishstate — VARCHAR(20) — NOT NULL
- lastmodified — BIGINT(10) — NOT NULL
- created — BIGINT(10) — NOT NULL
- usermodified — BIGINT(10) — Foreign key → user.id
- INDEX — `post_las2_ix`
- INDEX — `post_mod2_ix`
- INDEX — `post_sub2_ix`
- INDEX — `post_use4_ix`
role
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- shortname — VARCHAR(100) — NOT NULL
- description — LONGTEXT — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- archetype — VARCHAR(30) — NOT NULL
role_allow_assign
- id — BIGINT(10) — Primary key — NOT NULL
- roleid — BIGINT(10) — Foreign key → role.id — NOT NULL
- allowassign — BIGINT(10) — Foreign key → role.id — NOT NULL
- INDEX — `rolealloassi_rol4_ix`
- INDEX — `rolealloassi_all4_ix`
role_allow_override
- id — BIGINT(10) — Primary key — NOT NULL
- roleid — BIGINT(10) — Foreign key → role.id — NOT NULL
- allowoverride — BIGINT(10) — Foreign key → role.id — NOT NULL
- INDEX — `rolealloover_rol4_ix`
- INDEX — `rolealloover_all4_ix`
scale
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- scale — LONGTEXT — NOT NULL
- description — LONGTEXT — NOT NULL
- descriptionformat — TINYINT(2) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `scal_cou2_ix`
scale_history
- id — BIGINT(10) — Primary key — NOT NULL
- action — BIGINT(10) — NOT NULL
- oldid — BIGINT(10) — Foreign key → scale.id — NOT NULL
- source — VARCHAR(255)
- timemodified — BIGINT(10)
- loggeduser — BIGINT(10) — Foreign key → user.id
- courseid — BIGINT(10) — Foreign key → course.id — NOT NULL
- userid — BIGINT(10) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- scale — LONGTEXT — NOT NULL
- description — LONGTEXT — NOT NULL
- INDEX — `scalhist_act2_ix`
- INDEX — `scalhist_tim2_ix`
- INDEX — `scalhist_old4_ix`
- INDEX — `scalhist_cou4_ix`
- INDEX — `scalhist_log4_ix`
sessions
- id — BIGINT(10) — Primary key — NOT NULL
- state — BIGINT(10) — NOT NULL
- sid — VARCHAR(128) — NOT NULL
- userid — BIGINT(10) — Foreign key → user.id — NOT NULL
- sessdata — LONGTEXT
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- firstip — VARCHAR(45)
- lastip — VARCHAR(45)
- INDEX — `sess_sta2_ix`
- INDEX — `sess_tim3_ix`
- INDEX — `sess_tim4_ix`
- INDEX — `sess_use4_ix`
stats_daily
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- timeend — BIGINT(10) — NOT NULL
- roleid — BIGINT(10) — NOT NULL
- stattype — VARCHAR(20) — NOT NULL
- stat1 — BIGINT(10) — NOT NULL
- stat2 — BIGINT(10) — NOT NULL
- INDEX — `statdail_cou2_ix`
- INDEX — `statdail_tim2_ix`
- INDEX — `statdail_rol2_ix`
stats_monthly
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- timeend — BIGINT(10) — NOT NULL
- roleid — BIGINT(10) — NOT NULL
- stattype — VARCHAR(20) — NOT NULL
- stat1 — BIGINT(10) — NOT NULL
- stat2 — BIGINT(10) — NOT NULL
- INDEX — `statmont_cou2_ix`
- INDEX — `statmont_tim2_ix`
- INDEX — `statmont_rol2_ix`
stats_user_daily
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- roleid — BIGINT(10) — NOT NULL
- timeend — BIGINT(10) — NOT NULL
- statsreads — BIGINT(10) — NOT NULL
- statswrites — BIGINT(10) — NOT NULL
- stattype — VARCHAR(30) — NOT NULL
- INDEX — `statuserdail_cou2_ix`
- INDEX — `statuserdail_use2_ix`
- INDEX — `statuserdail_rol2_ix`
- INDEX — `statuserdail_tim2_ix`
stats_user_monthly
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- roleid — BIGINT(10) — NOT NULL
- timeend — BIGINT(10) — NOT NULL
- statsreads — BIGINT(10) — NOT NULL
- statswrites — BIGINT(10) — NOT NULL
- stattype — VARCHAR(30) — NOT NULL
- INDEX — `statusermont_cou2_ix`
- INDEX — `statusermont_use2_ix`
- INDEX — `statusermont_rol2_ix`
- INDEX — `statusermont_tim2_ix`
stats_user_weekly
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- userid — BIGINT(10) — NOT NULL
- roleid — BIGINT(10) — NOT NULL
- timeend — BIGINT(10) — NOT NULL
- statsreads — BIGINT(10) — NOT NULL
- statswrites — BIGINT(10) — NOT NULL
- stattype — VARCHAR(30) — NOT NULL
- INDEX — `statuserweek_cou2_ix`
- INDEX — `statuserweek_use2_ix`
- INDEX — `statuserweek_rol2_ix`
- INDEX — `statuserweek_tim2_ix`
stats_weekly
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- timeend — BIGINT(10) — NOT NULL
- roleid — BIGINT(10) — NOT NULL
- stattype — VARCHAR(20) — NOT NULL
- stat1 — BIGINT(10) — NOT NULL
- stat2 — BIGINT(10) — NOT NULL
- INDEX — `statweek_cou2_ix`
- INDEX — `statweek_tim2_ix`
- INDEX — `statweek_rol2_ix`
upgrade_log
- id — BIGINT(10) — Primary key — NOT NULL
- type — BIGINT(10) — NOT NULL
- plugin — VARCHAR(100)
- version — VARCHAR(100)
- targetversion — VARCHAR(100)
- info — VARCHAR(255) — NOT NULL
- details — LONGTEXT
- backtrace — LONGTEXT
- userid — BIGINT(10) — Foreign key → user.id — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `upgrlog_tim2_ix`
- INDEX — `upgrlog_typtim2_ix`
- INDEX — `upgrlog_use4_ix`
user
- id — BIGINT(10) — Primary key — NOT NULL
- auth — VARCHAR(20) — NOT NULL
- confirmed — TINYINT(1) — NOT NULL
- policyagreed — TINYINT(1) — NOT NULL
- deleted — TINYINT(1) — NOT NULL
- suspended — TINYINT(1) — NOT NULL
- mnethostid — BIGINT(10) — NOT NULL
- username — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- idnumber — VARCHAR(255) — NOT NULL
- firstname — VARCHAR(100) — NOT NULL
- lastname — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- emailstop — TINYINT(1) — NOT NULL
- icq — VARCHAR(15) — NOT NULL
- skype — VARCHAR(50) — NOT NULL
- yahoo — VARCHAR(50) — NOT NULL
- aim — VARCHAR(50) — NOT NULL
- msn — VARCHAR(50) — NOT NULL
- phone1 — VARCHAR(20) — NOT NULL
- phone2 — VARCHAR(20) — NOT NULL
- institution — VARCHAR(255) — NOT NULL
- department — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- city — VARCHAR(120) — NOT NULL
- country — VARCHAR(2) — NOT NULL
- lang — VARCHAR(30) — NOT NULL
- calendartype — VARCHAR(30) — NOT NULL
- theme — VARCHAR(50) — NOT NULL
- timezone — VARCHAR(100) — NOT NULL
- firstaccess — BIGINT(10) — NOT NULL
- lastaccess — BIGINT(10) — NOT NULL
- lastlogin — BIGINT(10) — NOT NULL
- currentlogin — BIGINT(10) — NOT NULL
- lastip — VARCHAR(45) — NOT NULL
- secret — VARCHAR(15) — NOT NULL
- picture — BIGINT(10) — NOT NULL
- url — VARCHAR(255) — NOT NULL
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- mailformat — TINYINT(1) — NOT NULL
- maildigest — TINYINT(1) — NOT NULL
- maildisplay — TINYINT(2) — NOT NULL
- autosubscribe — TINYINT(1) — NOT NULL
- trackforums — TINYINT(1) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- trustbitmask — BIGINT(10) — NOT NULL
- imagealt — VARCHAR(255)
- lastnamephonetic — VARCHAR(255)
- firstnamephonetic — VARCHAR(255)
- middlename — VARCHAR(255)
- alternatename — VARCHAR(255)
- INDEX — `user_del2_ix`
- INDEX — `user_con2_ix`
- INDEX — `user_fir3_ix`
- INDEX — `user_las4_ix`
- INDEX — `user_cit2_ix`
- INDEX — `user_cou2_ix`
- INDEX — `user_las5_ix`
- … +7
user_enrolments
- id — BIGINT(10) — Primary key — NOT NULL
- status — BIGINT(10) — NOT NULL
- enrolid — BIGINT(10) — Foreign key → enrol.id — NOT NULL
- userid — BIGINT(10) — Foreign key → user.id — NOT NULL
- timestart — BIGINT(10) — NOT NULL
- timeend — BIGINT(10) — NOT NULL
- modifierid — BIGINT(10) — Foreign key → user.id — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `userenro_enr4_ix`
- INDEX — `userenro_use4_ix`
- INDEX — `userenro_mod4_ix`
user_lastaccess
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — Foreign key → user.id — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- timeaccess — BIGINT(10) — NOT NULL
- INDEX — `userlast_use2_ix`
- INDEX — `userlast_cou2_ix`
user_password_history
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — Foreign key → user.id — NOT NULL
- hash — VARCHAR(255) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- INDEX — `userpasshist_use4_ix`
user_preferences
- id — BIGINT(10) — Primary key — NOT NULL
- userid — BIGINT(10) — Foreign key → user.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- value — VARCHAR(1333) — NOT NULL