assignment
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_assignment (
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 mdl_assignment COMMENT='Defines assignments'
Success
(mysql): CREATE INDEX mdl_assi_cou_ix ON mdl_assignment (course)
Success
(mysql): CREATE TABLE mdl_assignment_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 mdl_assignment_submissions COMMENT='Info about submitted assignments'
Success
(mysql): CREATE INDEX mdl_assisubm_use_ix ON mdl_assignment_submissions (userid)
Success
(mysql): CREATE INDEX mdl_assisubm_mai_ix ON mdl_assignment_submissions (mailed)
Success
(mysql): CREATE INDEX mdl_assisubm_tim_ix ON mdl_assignment_submissions (timemarked)
Success
(mysql): CREATE INDEX mdl_assisubm_ass_ix ON mdl_assignment_submissions (assignment)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'view submission', 'assignment', 'name')
Success
(mysql): INSERT INTO mdl_log_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): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_chat (
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 mdl_chat COMMENT='Each of these is a chat room'
Success
(mysql): CREATE INDEX mdl_chat_cou_ix ON mdl_chat (course)
Success
(mysql): CREATE TABLE mdl_chat_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 mdl_chat_messages COMMENT='Stores all the actual chat messages'
Success
(mysql): CREATE INDEX mdl_chatmess_use_ix ON mdl_chat_messages (userid)
Success
(mysql): CREATE INDEX mdl_chatmess_gro_ix ON mdl_chat_messages (groupid)
Success
(mysql): CREATE INDEX mdl_chatmess_timcha_ix ON mdl_chat_messages (timestamp, chatid)
Success
(mysql): CREATE INDEX mdl_chatmess_cha_ix ON mdl_chat_messages (chatid)
Success
(mysql): CREATE TABLE mdl_chat_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 mdl_chat_users COMMENT='Keeps track of which users are in which chat rooms'
Success
(mysql): CREATE INDEX mdl_chatuser_use_ix ON mdl_chat_users (userid)
Success
(mysql): CREATE INDEX mdl_chatuser_las_ix ON mdl_chat_users (lastping)
Success
(mysql): CREATE INDEX mdl_chatuser_gro_ix ON mdl_chat_users (groupid)
Success
(mysql): CREATE INDEX mdl_chatuser_cha_ix ON mdl_chat_users (chatid)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'view', 'chat', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'add', 'chat', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'update', 'chat', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'report', 'chat', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'talk', 'chat', 'name')
Success
chat tables have been set up correctly
choice
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_choice (
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 mdl_choice COMMENT='Available choices are stored here'
Success
(mysql): CREATE INDEX mdl_choi_cou_ix ON mdl_choice (course)
Success
(mysql): CREATE TABLE mdl_choice_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 mdl_choice_options COMMENT='available options to choice'
Success
(mysql): CREATE INDEX mdl_choiopti_cho_ix ON mdl_choice_options (choiceid)
Success
(mysql): CREATE TABLE mdl_choice_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 mdl_choice_answers COMMENT='choices performed by users'
Success
(mysql): CREATE INDEX mdl_choiansw_use_ix ON mdl_choice_answers (userid)
Success
(mysql): CREATE INDEX mdl_choiansw_cho_ix ON mdl_choice_answers (choiceid)
Success
(mysql): CREATE INDEX mdl_choiansw_opt_ix ON mdl_choice_answers (optionid)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('choice', 'view', 'choice', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('choice', 'update', 'choice', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('choice', 'add', 'choice', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('choice', 'report', 'choice', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('choice', 'choose', 'choice', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('choice', 'choose again', 'choice', 'name')
Success
choice tables have been set up correctly
data
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_data (
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) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_data COMMENT='all database activities'
Success
(mysql): CREATE INDEX mdl_data_cou_ix ON mdl_data (course)
Success
(mysql): CREATE TABLE mdl_data_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 mdl_data_fields COMMENT='every field available'
Success
(mysql): CREATE INDEX mdl_datafiel_typdat_ix ON mdl_data_fields (type, dataid)
Success
(mysql): CREATE INDEX mdl_datafiel_dat_ix ON mdl_data_fields (dataid)
Success
(mysql): CREATE TABLE mdl_data_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 mdl_data_records COMMENT='every record introduced'
Success
(mysql): CREATE INDEX mdl_datareco_dat_ix ON mdl_data_records (dataid)
Success
(mysql): CREATE TABLE mdl_data_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 mdl_data_content COMMENT='the content introduced in each record/fields'
Success
(mysql): CREATE INDEX mdl_datacont_rec_ix ON mdl_data_content (recordid)
Success
(mysql): CREATE INDEX mdl_datacont_fie_ix ON mdl_data_content (fieldid)
Success
(mysql): CREATE TABLE mdl_data_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 mdl_data_comments COMMENT='to comment data records'
Success
(mysql): CREATE INDEX mdl_datacomm_rec_ix ON mdl_data_comments (recordid)
Success
(mysql): CREATE TABLE mdl_data_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 mdl_data_ratings COMMENT='to rate data records'
Success
(mysql): CREATE INDEX mdl_datarati_rec_ix ON mdl_data_ratings (recordid)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('data', 'view', 'data', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('data', 'add', 'data', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('data', 'update', 'data', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('data', 'record delete', 'data', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('data', 'fields add', 'data_fields', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('data', 'fields update', 'data_fields', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('data', 'templates saved', 'data', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('data', 'templates def', 'data', 'name')
Success
data tables have been set up correctly
forum
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_forum (
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 mdl_forum COMMENT='Forums contain and structure discussion'
Success
(mysql): CREATE INDEX mdl_foru_cou_ix ON mdl_forum (course)
Success
(mysql): CREATE TABLE mdl_forum_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 mdl_forum_discussions COMMENT='Forums are composed of discussions'
Success
(mysql): CREATE INDEX mdl_forudisc_use_ix ON mdl_forum_discussions (userid)
Success
(mysql): CREATE INDEX mdl_forudisc_for_ix ON mdl_forum_discussions (forum)
Success
(mysql): CREATE TABLE mdl_forum_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 mdl_forum_posts COMMENT='All posts are stored in this table'
Success
(mysql): CREATE INDEX mdl_forupost_use_ix ON mdl_forum_posts (userid)
Success
(mysql): CREATE INDEX mdl_forupost_cre_ix ON mdl_forum_posts (created)
Success
(mysql): CREATE INDEX mdl_forupost_mai_ix ON mdl_forum_posts (mailed)
Success
(mysql): CREATE INDEX mdl_forupost_dis_ix ON mdl_forum_posts (discussion)
Success
(mysql): CREATE INDEX mdl_forupost_par_ix ON mdl_forum_posts (parent)
Success
(mysql): CREATE TABLE mdl_forum_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 mdl_forum_queue COMMENT='For keeping track of posts that will be mailed in digest for'
Success
(mysql): CREATE INDEX mdl_foruqueu_use_ix ON mdl_forum_queue (userid)
Success
(mysql): CREATE INDEX mdl_foruqueu_dis_ix ON mdl_forum_queue (discussionid)
Success
(mysql): CREATE INDEX mdl_foruqueu_pos_ix ON mdl_forum_queue (postid)
Success
(mysql): CREATE TABLE mdl_forum_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 mdl_forum_ratings COMMENT='forum_ratings table retrofitted from MySQL'
Success
(mysql): CREATE INDEX mdl_forurati_use_ix ON mdl_forum_ratings (userid)
Success
(mysql): CREATE INDEX mdl_forurati_pos_ix ON mdl_forum_ratings (post)
Success
(mysql): CREATE TABLE mdl_forum_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 mdl_forum_subscriptions COMMENT='Keeps track of who is subscribed to what forum'
Success
(mysql): CREATE INDEX mdl_forusubs_use_ix ON mdl_forum_subscriptions (userid)
Success
(mysql): CREATE INDEX mdl_forusubs_for_ix ON mdl_forum_subscriptions (forum)
Success
(mysql): CREATE TABLE mdl_forum_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 mdl_forum_read COMMENT='Tracks each users read posts'
Success
(mysql): CREATE INDEX mdl_foruread_usefor_ix ON mdl_forum_read (userid, forumid)
Success
(mysql): CREATE INDEX mdl_foruread_usedis_ix ON mdl_forum_read (userid, discussionid)
Success
(mysql): CREATE INDEX mdl_foruread_usepos_ix ON mdl_forum_read (userid, postid)
Success
(mysql): CREATE TABLE mdl_forum_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 mdl_forum_track_prefs COMMENT='Tracks each users untracked forums'
Success
(mysql): CREATE INDEX mdl_forutracpref_usefor_ix ON mdl_forum_track_prefs (userid, forumid)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'add', 'forum', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'update', 'forum', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'add discussion', 'forum_discussions', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'add post', 'forum_posts', 'subject')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'update post', 'forum_posts', 'subject')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'user report', 'user', 'CONCAT(firstname,\' \',lastname)')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'move discussion', 'forum_discussions', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'view subscribers', 'forum', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'view discussion', 'forum_discussions', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'view forum', 'forum', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'subscribe', 'forum', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('forum', 'unsubscribe', 'forum', 'name')
Success
forum tables have been set up correctly
glossary
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_glossary (
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 mdl_glossary COMMENT='all glossaries'
Success
(mysql): CREATE INDEX mdl_glos_cou_ix ON mdl_glossary (course)
Success
(mysql): CREATE TABLE mdl_glossary_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 mdl_glossary_entries COMMENT='all glossary entries'
Success
(mysql): CREATE INDEX mdl_glosentr_use_ix ON mdl_glossary_entries (userid)
Success
(mysql): CREATE INDEX mdl_glosentr_con_ix ON mdl_glossary_entries (concept)
Success
(mysql): CREATE INDEX mdl_glosentr_glo_ix ON mdl_glossary_entries (glossaryid)
Success
(mysql): CREATE TABLE mdl_glossary_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 mdl_glossary_alias COMMENT='entries alias'
Success
(mysql): CREATE INDEX mdl_glosalia_ent_ix ON mdl_glossary_alias (entryid)
Success
(mysql): CREATE TABLE mdl_glossary_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 mdl_glossary_categories COMMENT='all categories for glossary entries'
Success
(mysql): CREATE INDEX mdl_gloscate_glo_ix ON mdl_glossary_categories (glossaryid)
Success
(mysql): CREATE TABLE mdl_glossary_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 mdl_glossary_entries_categories COMMENT='categories of each glossary entry'
Success
(mysql): CREATE INDEX mdl_glosentrcate_cat_ix ON mdl_glossary_entries_categories (categoryid)
Success
(mysql): CREATE INDEX mdl_glosentrcate_ent_ix ON mdl_glossary_entries_categories (entryid)
Success
(mysql): CREATE TABLE mdl_glossary_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 mdl_glossary_comments COMMENT='comments on glossary entries'
Success
(mysql): CREATE INDEX mdl_gloscomm_use_ix ON mdl_glossary_comments (userid)
Success
(mysql): CREATE INDEX mdl_gloscomm_ent_ix ON mdl_glossary_comments (entryid)
Success
(mysql): CREATE TABLE mdl_glossary_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 mdl_glossary_formats COMMENT='Setting of the display formats'
Success
(mysql): CREATE TABLE mdl_glossary_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 mdl_glossary_ratings COMMENT='Contains user ratings for entries'
Success
(mysql): CREATE INDEX mdl_glosrati_use_ix ON mdl_glossary_ratings (userid)
Success
(mysql): CREATE INDEX mdl_glosrati_ent_ix ON mdl_glossary_ratings (entryid)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'add', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'update', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'view', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'view all', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'add entry', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'update entry', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'add category', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'update category', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'delete category', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'add comment', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'update comment', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'delete comment', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('glossary', 'approve entry', 'glossary', 'name')
Success
(mysql): INSERT INTO mdl_log_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): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_hotpot (
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 mdl_hotpot COMMENT='details about Hot Potatoes quizzes'
Success
(mysql): CREATE TABLE mdl_hotpot_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 mdl_hotpot_attempts COMMENT='details about Hot Potatoes quiz attempts'
Success
(mysql): CREATE INDEX mdl_hotpatte_use_ix ON mdl_hotpot_attempts (userid)
Success
(mysql): CREATE INDEX mdl_hotpatte_hot_ix ON mdl_hotpot_attempts (hotpot)
Success
(mysql): CREATE TABLE mdl_hotpot_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 mdl_hotpot_details COMMENT='raw details (as XML) of Hot Potatoes quiz attempts'
Success
(mysql): CREATE INDEX mdl_hotpdeta_att_ix ON mdl_hotpot_details (attempt)
Success
(mysql): CREATE TABLE mdl_hotpot_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 mdl_hotpot_questions COMMENT='details about questions in Hot Potatoes quiz attempts'
Success
(mysql): CREATE INDEX mdl_hotpques_md5_ix ON mdl_hotpot_questions (md5key)
Success
(mysql): CREATE INDEX mdl_hotpques_hot_ix ON mdl_hotpot_questions (hotpot)
Success
(mysql): CREATE TABLE mdl_hotpot_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 mdl_hotpot_responses COMMENT='details about responses in Hot Potatoes quiz attempts'
Success
(mysql): CREATE INDEX mdl_hotpresp_att_ix ON mdl_hotpot_responses (attempt)
Success
(mysql): CREATE INDEX mdl_hotpresp_que_ix ON mdl_hotpot_responses (question)
Success
(mysql): CREATE TABLE mdl_hotpot_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 mdl_hotpot_strings COMMENT='strings used in Hot Potatoes questions and responses'
Success
(mysql): CREATE INDEX mdl_hotpstri_md5_ix ON mdl_hotpot_strings (md5key)
Success
hotpot tables have been set up correctly
journal
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_journal (
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 mdl_journal COMMENT='data for each journal'
Success
(mysql): CREATE INDEX mdl_jour_cou_ix ON mdl_journal (course)
Success
(mysql): CREATE TABLE mdl_journal_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 mdl_journal_entries COMMENT='All the journal entries of all people'
Success
(mysql): CREATE INDEX mdl_jourentr_use_ix ON mdl_journal_entries (userid)
Success
(mysql): CREATE INDEX mdl_jourentr_jou_ix ON mdl_journal_entries (journal)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('journal', 'view', 'journal', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('journal', 'add entry', 'journal', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('journal', 'update entry', 'journal', 'name')
Success
(mysql): INSERT INTO mdl_log_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 mdl_label (
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 mdl_label COMMENT='Defines labels'
Success
(mysql): CREATE INDEX mdl_labe_cou_ix ON mdl_label (course)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('label', 'add', 'label', 'name')
Success
(mysql): INSERT INTO mdl_log_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 mdl_lams (
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 mdl_lams COMMENT='LAMS activity'
Success
(mysql): CREATE INDEX mdl_lams_cou_ix ON mdl_lams (course)
Success
lams tables have been set up correctly
lesson
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_lesson (
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 mdl_lesson COMMENT='Defines lesson'
Success
(mysql): CREATE INDEX mdl_less_cou_ix ON mdl_lesson (course)
Success
(mysql): CREATE TABLE mdl_lesson_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 mdl_lesson_pages COMMENT='Defines lesson_pages'
Success
(mysql): CREATE INDEX mdl_lesspage_les_ix ON mdl_lesson_pages (lessonid)
Success
(mysql): CREATE TABLE mdl_lesson_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 mdl_lesson_answers COMMENT='Defines lesson_answers'
Success
(mysql): CREATE INDEX mdl_lessansw_les_ix ON mdl_lesson_answers (lessonid)
Success
(mysql): CREATE INDEX mdl_lessansw_pag_ix ON mdl_lesson_answers (pageid)
Success
(mysql): CREATE TABLE mdl_lesson_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 mdl_lesson_attempts COMMENT='Defines lesson_attempts'
Success
(mysql): CREATE INDEX mdl_lessatte_use_ix ON mdl_lesson_attempts (userid)
Success
(mysql): CREATE INDEX mdl_lessatte_les_ix ON mdl_lesson_attempts (lessonid)
Success
(mysql): CREATE INDEX mdl_lessatte_pag_ix ON mdl_lesson_attempts (pageid)
Success
(mysql): CREATE INDEX mdl_lessatte_ans_ix ON mdl_lesson_attempts (answerid)
Success
(mysql): CREATE TABLE mdl_lesson_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 mdl_lesson_grades COMMENT='Defines lesson_grades'
Success
(mysql): CREATE INDEX mdl_lessgrad_use_ix ON mdl_lesson_grades (userid)
Success
(mysql): CREATE INDEX mdl_lessgrad_les_ix ON mdl_lesson_grades (lessonid)
Success
(mysql): CREATE TABLE mdl_lesson_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 mdl_lesson_default COMMENT='Defines lesson_default'
Success
(mysql): CREATE TABLE mdl_lesson_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 mdl_lesson_timer COMMENT='lesson timer for each lesson'
Success
(mysql): CREATE INDEX mdl_lesstime_use_ix ON mdl_lesson_timer (userid)
Success
(mysql): CREATE INDEX mdl_lesstime_les_ix ON mdl_lesson_timer (lessonid)
Success
(mysql): CREATE TABLE mdl_lesson_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 mdl_lesson_branch COMMENT='branches for each lesson/user'
Success
(mysql): CREATE INDEX mdl_lessbran_use_ix ON mdl_lesson_branch (userid)
Success
(mysql): CREATE INDEX mdl_lessbran_les_ix ON mdl_lesson_branch (lessonid)
Success
(mysql): CREATE INDEX mdl_lessbran_pag_ix ON mdl_lesson_branch (pageid)
Success
(mysql): CREATE TABLE mdl_lesson_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 mdl_lesson_high_scores COMMENT='high scores for each lesson'
Success
(mysql): CREATE INDEX mdl_lesshighscor_use_ix ON mdl_lesson_high_scores (userid)
Success
(mysql): CREATE INDEX mdl_lesshighscor_les_ix ON mdl_lesson_high_scores (lessonid)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'start', 'lesson', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'end', 'lesson', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'view', 'lesson_pages', 'title')
Success
lesson tables have been set up correctly
quiz
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_question_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 mdl_question_categories COMMENT='Categories are for grouping questions'
Success
(mysql): CREATE INDEX mdl_quescate_con_ix ON mdl_question_categories (contextid)
Success
(mysql): CREATE INDEX mdl_quescate_par_ix ON mdl_question_categories (parent)
Success
(mysql): CREATE TABLE mdl_question (
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 mdl_question COMMENT='The questions themselves'
Success
(mysql): CREATE INDEX mdl_ques_cat_ix ON mdl_question (category)
Success
(mysql): CREATE INDEX mdl_ques_par_ix ON mdl_question (parent)
Success
(mysql): CREATE INDEX mdl_ques_cre_ix ON mdl_question (createdby)
Success
(mysql): CREATE INDEX mdl_ques_mod_ix ON mdl_question (modifiedby)
Success
(mysql): CREATE TABLE mdl_question_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 mdl_question_answers COMMENT='Answers, with a fractional grade (0-1) and feedback'
Success
(mysql): CREATE INDEX mdl_quesansw_que_ix ON mdl_question_answers (question)
Success
(mysql): CREATE TABLE mdl_question_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 mdl_question_dataset_definitions COMMENT='Organises and stores properties for dataset items'
Success
(mysql): CREATE INDEX mdl_quesdatadefi_cat_ix ON mdl_question_dataset_definitions (category)
Success
(mysql): CREATE TABLE mdl_question_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 mdl_question_dataset_items COMMENT='Individual dataset items'
Success
(mysql): CREATE INDEX mdl_quesdataitem_def_ix ON mdl_question_dataset_items (definition)
Success
(mysql): CREATE TABLE mdl_question_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 mdl_question_datasets COMMENT='Many-many relation between questions and dataset definitions'
Success
(mysql): CREATE INDEX mdl_quesdata_quedat_ix ON mdl_question_datasets (question, datasetdefinition)
Success
(mysql): CREATE INDEX mdl_quesdata_que_ix ON mdl_question_datasets (question)
Success
(mysql): CREATE INDEX mdl_quesdata_dat_ix ON mdl_question_datasets (datasetdefinition)
Success
(mysql): CREATE TABLE mdl_question_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 mdl_question_numerical_units COMMENT='Optional unit options for numerical questions'
Success
(mysql): CREATE UNIQUE INDEX mdl_quesnumeunit_queuni_uix ON mdl_question_numerical_units (question, unit)
Success
(mysql): CREATE INDEX mdl_quesnumeunit_que_ix ON mdl_question_numerical_units (question)
Success
(mysql): CREATE TABLE mdl_question_attempts (
id BIGINT(10) unsigned NOT NULL auto_increment,
modulename VARCHAR(20) NOT NULL DEFAULT 'quiz',
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_question_attempts COMMENT='Student attempts. This table gets extended by the modules'
Success
(mysql): CREATE TABLE mdl_question_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 mdl_question_states COMMENT='Stores user responses to an attempt, and percentage grades'
Success
(mysql): CREATE INDEX mdl_quesstat_att_ix ON mdl_question_states (attempt)
Success
(mysql): CREATE INDEX mdl_quesstat_que_ix ON mdl_question_states (question)
Success
(mysql): CREATE TABLE mdl_question_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 mdl_question_sessions COMMENT='Gives ids of the newest open and newest graded states'
Success
(mysql): CREATE UNIQUE INDEX mdl_quessess_attque_uix ON mdl_question_sessions (attemptid, questionid)
Success
(mysql): CREATE INDEX mdl_quessess_att_ix ON mdl_question_sessions (attemptid)
Success
(mysql): CREATE INDEX mdl_quessess_que_ix ON mdl_question_sessions (questionid)
Success
(mysql): CREATE INDEX mdl_quessess_new_ix ON mdl_question_sessions (newest)
Success
(mysql): CREATE INDEX mdl_quessess_new2_ix ON mdl_question_sessions (newgraded)
Success
(mysql): CREATE TABLE mdl_quiz (
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 mdl_quiz COMMENT='Main information about each quiz'
Success
(mysql): CREATE INDEX mdl_quiz_cou_ix ON mdl_quiz (course)
Success
(mysql): CREATE TABLE mdl_quiz_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 mdl_quiz_attempts COMMENT='Stores various attempts on a quiz'
Success
(mysql): CREATE INDEX mdl_quizatte_use_ix ON mdl_quiz_attempts (userid)
Success
(mysql): CREATE UNIQUE INDEX mdl_quizatte_uni_uix ON mdl_quiz_attempts (uniqueid)
Success
(mysql): CREATE INDEX mdl_quizatte_qui_ix ON mdl_quiz_attempts (quiz)
Success
(mysql): CREATE TABLE mdl_quiz_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 mdl_quiz_grades COMMENT='Final quiz grade (may be best of several attempts)'
Success
(mysql): CREATE INDEX mdl_quizgrad_use_ix ON mdl_quiz_grades (userid)
Success
(mysql): CREATE INDEX mdl_quizgrad_qui_ix ON mdl_quiz_grades (quiz)
Success
(mysql): CREATE TABLE mdl_quiz_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 mdl_quiz_question_instances COMMENT='The grade for a question in a quiz'
Success
(mysql): CREATE INDEX mdl_quizquesinst_qui_ix ON mdl_quiz_question_instances (quiz)
Success
(mysql): CREATE INDEX mdl_quizquesinst_que_ix ON mdl_quiz_question_instances (question)
Success
(mysql): CREATE TABLE mdl_quiz_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 mdl_quiz_question_versions COMMENT='quiz_question_versions table retrofitted from MySQL'
Success
(mysql): CREATE INDEX mdl_quizquesvers_qui_ix ON mdl_quiz_question_versions (quiz)
Success
(mysql): CREATE INDEX mdl_quizquesvers_old_ix ON mdl_quiz_question_versions (oldquestion)
Success
(mysql): CREATE INDEX mdl_quizquesvers_new_ix ON mdl_quiz_question_versions (newquestion)
Success
(mysql): CREATE INDEX mdl_quizquesvers_ori_ix ON mdl_quiz_question_versions (originalquestion)
Success
(mysql): CREATE TABLE mdl_quiz_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 mdl_quiz_feedback COMMENT='Feedback given to students based on their overall score on t'
Success
(mysql): CREATE INDEX mdl_quizfeed_qui_ix ON mdl_quiz_feedback (quizid)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('quiz', 'add', 'quiz', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('quiz', 'update', 'quiz', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('quiz', 'view', 'quiz', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('quiz', 'report', 'quiz', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('quiz', 'attempt', 'quiz', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('quiz', 'submit', 'quiz', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('quiz', 'review', 'quiz', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('quiz', 'editquestions', 'quiz', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('quiz', 'preview', 'quiz', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('quiz', 'start attempt', 'quiz', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('quiz', 'close attempt', 'quiz', 'name')
Success
(mysql): INSERT INTO mdl_log_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 mdl_resource (
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 mdl_resource COMMENT='each record is one resource and its config data'
Success
(mysql): CREATE INDEX mdl_reso_cou_ix ON mdl_resource (course)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('resource', 'view', 'resource', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('resource', 'update', 'resource', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('resource', 'add', 'resource', 'name')
Success
resource tables have been set up correctly
scorm
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_scorm (
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 mdl_scorm COMMENT='each table is one SCORM module and its configuration'
Success
(mysql): CREATE INDEX mdl_scor_cou_ix ON mdl_scorm (course)
Success
(mysql): CREATE TABLE mdl_scorm_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 mdl_scorm_scoes COMMENT='each SCO part of the SCORM module'
Success
(mysql): CREATE INDEX mdl_scorscoe_sco_ix ON mdl_scorm_scoes (scorm)
Success
(mysql): CREATE TABLE mdl_scorm_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 mdl_scorm_scoes_data COMMENT='Contains variable data get from packages'
Success
(mysql): CREATE INDEX mdl_scorscoedata_sco_ix ON mdl_scorm_scoes_data (scoid)
Success
(mysql): CREATE TABLE mdl_scorm_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 mdl_scorm_scoes_track COMMENT='to track SCOes'
Success
(mysql): CREATE UNIQUE INDEX mdl_scorscoetrac_usescosco_uix ON mdl_scorm_scoes_track (userid, scormid, scoid, attempt, element)
Success
(mysql): CREATE INDEX mdl_scorscoetrac_use_ix ON mdl_scorm_scoes_track (userid)
Success
(mysql): CREATE INDEX mdl_scorscoetrac_ele_ix ON mdl_scorm_scoes_track (element)
Success
(mysql): CREATE INDEX mdl_scorscoetrac_sco_ix ON mdl_scorm_scoes_track (scormid)
Success
(mysql): CREATE INDEX mdl_scorscoetrac_sco2_ix ON mdl_scorm_scoes_track (scoid)
Success
(mysql): CREATE TABLE mdl_scorm_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 mdl_scorm_seq_objective COMMENT='SCORM2004 objective description'
Success
(mysql): CREATE UNIQUE INDEX mdl_scorseqobje_scoid_uix ON mdl_scorm_seq_objective (scoid, id)
Success
(mysql): CREATE INDEX mdl_scorseqobje_sco_ix ON mdl_scorm_seq_objective (scoid)
Success
(mysql): CREATE TABLE mdl_scorm_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 mdl_scorm_seq_mapinfo COMMENT='SCORM2004 objective mapinfo description'
Success
(mysql): CREATE UNIQUE INDEX mdl_scorseqmapi_scoidobj_uix ON mdl_scorm_seq_mapinfo (scoid, id, objectiveid)
Success
(mysql): CREATE INDEX mdl_scorseqmapi_sco_ix ON mdl_scorm_seq_mapinfo (scoid)
Success
(mysql): CREATE INDEX mdl_scorseqmapi_obj_ix ON mdl_scorm_seq_mapinfo (objectiveid)
Success
(mysql): CREATE TABLE mdl_scorm_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 mdl_scorm_seq_ruleconds COMMENT='SCORM2004 rule conditions'
Success
(mysql): CREATE UNIQUE INDEX mdl_scorseqrule_scoid_uix ON mdl_scorm_seq_ruleconds (scoid, id)
Success
(mysql): CREATE INDEX mdl_scorseqrule_sco_ix ON mdl_scorm_seq_ruleconds (scoid)
Success
(mysql): CREATE TABLE mdl_scorm_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 mdl_scorm_seq_rulecond COMMENT='SCORM2004 rule condition'
Success
(mysql): CREATE UNIQUE INDEX mdl_scorseqrule_idscorul_uix ON mdl_scorm_seq_rulecond (id, scoid, ruleconditionsid)
Success
(mysql): CREATE INDEX mdl_scorseqrule_sco2_ix ON mdl_scorm_seq_rulecond (scoid)
Success
(mysql): CREATE INDEX mdl_scorseqrule_rul_ix ON mdl_scorm_seq_rulecond (ruleconditionsid)
Success
(mysql): CREATE TABLE mdl_scorm_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 mdl_scorm_seq_rolluprule COMMENT='SCORM2004 sequencing rule'
Success
(mysql): CREATE UNIQUE INDEX mdl_scorseqroll_scoid_uix ON mdl_scorm_seq_rolluprule (scoid, id)
Success
(mysql): CREATE INDEX mdl_scorseqroll_sco_ix ON mdl_scorm_seq_rolluprule (scoid)
Success
(mysql): CREATE TABLE mdl_scorm_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 mdl_scorm_seq_rolluprulecond COMMENT='SCORM2004 sequencing rule'
Success
(mysql): CREATE UNIQUE INDEX mdl_scorseqroll_scorolid_uix ON mdl_scorm_seq_rolluprulecond (scoid, rollupruleid, id)
Success
(mysql): CREATE INDEX mdl_scorseqroll_sco2_ix ON mdl_scorm_seq_rolluprulecond (scoid)
Success
(mysql): CREATE INDEX mdl_scorseqroll_rol_ix ON mdl_scorm_seq_rolluprulecond (rollupruleid)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'view', 'scorm', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'review', 'scorm', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'update', 'scorm', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'add', 'scorm', 'name')
Success
scorm tables have been set up correctly
survey
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_survey (
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 mdl_survey COMMENT='Each record is one SURVEY module with its configuration'
Success
(mysql): CREATE INDEX mdl_surv_cou_ix ON mdl_survey (course)
Success
(mysql): CREATE TABLE mdl_survey_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 mdl_survey_questions COMMENT='the questions conforming one survey'
Success
(mysql): CREATE TABLE mdl_survey_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 mdl_survey_answers COMMENT='the answers to each questions filled by the users'
Success
(mysql): CREATE INDEX mdl_survansw_use_ix ON mdl_survey_answers (userid)
Success
(mysql): CREATE INDEX mdl_survansw_sur_ix ON mdl_survey_answers (survey)
Success
(mysql): CREATE INDEX mdl_survansw_que_ix ON mdl_survey_answers (question)
Success
(mysql): CREATE TABLE mdl_survey_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 mdl_survey_analysis COMMENT='text about each survey submission'
Success
(mysql): CREATE INDEX mdl_survanal_use_ix ON mdl_survey_analysis (userid)
Success
(mysql): CREATE INDEX mdl_survanal_sur_ix ON mdl_survey_analysis (survey)
Success
(mysql): INSERT INTO mdl_survey(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 mdl_survey(course, template, days, timecreated, timemodified, name, intro, questions) VALUES ('0', '0', '0', '985017600', '985017600', 'collespname', 'collespintro', '31,32,33,34,35,36,43,44')
Success
(mysql): INSERT INTO mdl_survey(course, template, days, timecreated, timemodified, name, intro, questions) VALUES ('0', '0', '0', '985017600', '985017600', 'collesapname', 'collesapintro', '37,38,39,40,41,42,43,44')
Success
(mysql): INSERT INTO mdl_survey(course, template, days, timecreated, timemodified, name, intro, questions) VALUES ('0', '0', '0', '985017600', '985017600', 'attlsname', 'attlsintro', '65,67,68')
Success
(mysql): INSERT INTO mdl_survey(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 mdl_survey_questions(text, shorttext, type, options) VALUES ('colles1', 'colles1short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles2', 'colles2short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles3', 'colles3short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles4', 'colles4short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles5', 'colles5short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles6', 'colles6short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles7', 'colles7short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles8', 'colles8short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles9', 'colles9short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles10', 'colles10short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles11', 'colles11short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles12', 'colles12short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles13', 'colles13short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles14', 'colles14short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles15', 'colles15short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles16', 'colles16short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles17', 'colles17short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles18', 'colles18short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles19', 'colles19short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles20', 'colles20short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles21', 'colles21short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles22', 'colles22short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles23', 'colles23short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('colles24', 'colles24short', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm1', 'collesm1short', '1,2,3,4', 'collesmintro', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm2', 'collesm2short', '5,6,7,8', 'collesmintro', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm3', 'collesm3short', '9,10,11,12', 'collesmintro', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm4', 'collesm4short', '13,14,15,16', 'collesmintro', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm5', 'collesm5short', '17,18,19,20', 'collesmintro', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm6', 'collesm6short', '21,22,23,24', 'collesmintro', '1', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm1', 'collesm1short', '1,2,3,4', 'collesmintro', '2', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm2', 'collesm2short', '5,6,7,8', 'collesmintro', '2', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm3', 'collesm3short', '9,10,11,12', 'collesmintro', '2', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm4', 'collesm4short', '13,14,15,16', 'collesmintro', '2', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm5', 'collesm5short', '17,18,19,20', 'collesmintro', '2', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm6', 'collesm6short', '21,22,23,24', 'collesmintro', '2', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm1', 'collesm1short', '1,2,3,4', 'collesmintro', '3', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm2', 'collesm2short', '5,6,7,8', 'collesmintro', '3', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm3', 'collesm3short', '9,10,11,12', 'collesmintro', '3', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm4', 'collesm4short', '13,14,15,16', 'collesmintro', '3', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm5', 'collesm5short', '17,18,19,20', 'collesmintro', '3', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('collesm6', 'collesm6short', '21,22,23,24', 'collesmintro', '3', 'scaletimes5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, type, options) VALUES ('howlong', '1', 'howlongoptions')
Success
(mysql): INSERT INTO mdl_survey_questions(text, type) VALUES ('othercomments', '0')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls1', 'attls1short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls2', 'attls2short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls3', 'attls3short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls4', 'attls4short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls5', 'attls5short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls6', 'attls6short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls7', 'attls7short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls8', 'attls8short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls9', 'attls9short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls10', 'attls10short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls11', 'attls11short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls12', 'attls12short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls13', 'attls13short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls14', 'attls14short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls15', 'attls15short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls16', 'attls16short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls17', 'attls17short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls18', 'attls18short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls19', 'attls19short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type, options) VALUES ('attls20', 'attls20short', '1', 'scaleagree5')
Success
(mysql): INSERT INTO mdl_survey_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 mdl_survey_questions(text, shorttext, multi, intro, type, options) VALUES ('-', '-', '-', '-', '0', '-')
Success
(mysql): INSERT INTO mdl_survey_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 mdl_survey_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 mdl_survey_questions(text, shorttext, type) VALUES ('ciq1', 'ciq1short', '0')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type) VALUES ('ciq2', 'ciq2short', '0')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type) VALUES ('ciq3', 'ciq3short', '0')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type) VALUES ('ciq4', 'ciq4short', '0')
Success
(mysql): INSERT INTO mdl_survey_questions(text, shorttext, type) VALUES ('ciq5', 'ciq5short', '0')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('survey', 'add', 'survey', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('survey', 'update', 'survey', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('survey', 'download', 'survey', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('survey', 'view form', 'survey', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('survey', 'view graph', 'survey', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('survey', 'view report', 'survey', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('survey', 'submit', 'survey', 'name')
Success
survey tables have been set up correctly
wiki
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_wiki (
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 mdl_wiki COMMENT='Main wik table'
Success
(mysql): CREATE INDEX mdl_wiki_cou_ix ON mdl_wiki (course)
Success
(mysql): CREATE TABLE mdl_wiki_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 mdl_wiki_entries COMMENT='Holds entries for each wiki start instance'
Success
(mysql): CREATE INDEX mdl_wikientr_cou_ix ON mdl_wiki_entries (course)
Success
(mysql): CREATE INDEX mdl_wikientr_gro_ix ON mdl_wiki_entries (groupid)
Success
(mysql): CREATE INDEX mdl_wikientr_use_ix ON mdl_wiki_entries (userid)
Success
(mysql): CREATE INDEX mdl_wikientr_pag_ix ON mdl_wiki_entries (pagename)
Success
(mysql): CREATE INDEX mdl_wikientr_wik_ix ON mdl_wiki_entries (wikiid)
Success
(mysql): CREATE TABLE mdl_wiki_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 mdl_wiki_pages COMMENT='Holds the Wiki-Pages'
Success
(mysql): CREATE UNIQUE INDEX mdl_wikipage_pagverwik_uix ON mdl_wiki_pages (pagename, version, wiki)
Success
(mysql): CREATE INDEX mdl_wikipage_wik_ix ON mdl_wiki_pages (wiki)
Success
(mysql): CREATE TABLE mdl_wiki_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 mdl_wiki_locks COMMENT='Stores editing locks on Wiki pages'
Success
(mysql): CREATE UNIQUE INDEX mdl_wikilock_wikpag_uix ON mdl_wiki_locks (wikiid, pagename)
Success
(mysql): CREATE INDEX mdl_wikilock_loc_ix ON mdl_wiki_locks (lockedseen)
Success
(mysql): CREATE INDEX mdl_wikilock_wik_ix ON mdl_wiki_locks (wikiid)
Success
wiki tables have been set up correctly
workshop
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_workshop (
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 mdl_workshop COMMENT='Defines workshop'
Success
(mysql): CREATE INDEX mdl_work_cou_ix ON mdl_workshop (course)
Success
(mysql): CREATE TABLE mdl_workshop_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 mdl_workshop_elements COMMENT='Info about marking scheme of assignment'
Success
(mysql): CREATE INDEX mdl_workelem_wor_ix ON mdl_workshop_elements (workshopid)
Success
(mysql): CREATE TABLE mdl_workshop_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 mdl_workshop_rubrics COMMENT='Info about the rubrics marking scheme'
Success
(mysql): CREATE INDEX mdl_workrubr_wor_ix ON mdl_workshop_rubrics (workshopid)
Success
(mysql): CREATE TABLE mdl_workshop_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 mdl_workshop_submissions COMMENT='Info about submitted work from teacher and students'
Success
(mysql): CREATE INDEX mdl_worksubm_use_ix ON mdl_workshop_submissions (userid)
Success
(mysql): CREATE INDEX mdl_worksubm_mai_ix ON mdl_workshop_submissions (mailed)
Success
(mysql): CREATE INDEX mdl_worksubm_wor_ix ON mdl_workshop_submissions (workshopid)
Success
(mysql): CREATE TABLE mdl_workshop_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,
teachercomment TEXT,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_workshop_assessments COMMENT='Info about assessments by teacher and students'
Success
(mysql): CREATE INDEX mdl_workasse_use_ix ON mdl_workshop_assessments (userid)
Success
(mysql): CREATE INDEX mdl_workasse_mai_ix ON mdl_workshop_assessments (mailed)
Success
(mysql): CREATE INDEX mdl_workasse_wor_ix ON mdl_workshop_assessments (workshopid)
Success
(mysql): CREATE INDEX mdl_workasse_sub_ix ON mdl_workshop_assessments (submissionid)
Success
(mysql): CREATE TABLE mdl_workshop_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 mdl_workshop_grades COMMENT='Info about individual grades given to each element'
Success
(mysql): CREATE INDEX mdl_workgrad_wor_ix ON mdl_workshop_grades (workshopid)
Success
(mysql): CREATE INDEX mdl_workgrad_ass_ix ON mdl_workshop_grades (assessmentid)
Success
(mysql): CREATE TABLE mdl_workshop_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 mdl_workshop_stockcomments COMMENT='Info about the teacher comment bank'
Success
(mysql): CREATE INDEX mdl_workstoc_wor_ix ON mdl_workshop_stockcomments (workshopid)
Success
(mysql): CREATE TABLE mdl_workshop_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 mdl_workshop_comments COMMENT='Defines comments'
Success
(mysql): CREATE INDEX mdl_workcomm_use_ix ON mdl_workshop_comments (userid)
Success
(mysql): CREATE INDEX mdl_workcomm_mai_ix ON mdl_workshop_comments (mailed)
Success
(mysql): CREATE INDEX mdl_workcomm_wor_ix ON mdl_workshop_comments (workshopid)
Success
(mysql): CREATE INDEX mdl_workcomm_ass_ix ON mdl_workshop_comments (assessmentid)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('workshop', 'assessments', 'workshop', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('workshop', 'close', 'workshop', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('workshop', 'display', 'workshop', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('workshop', 'resubmit', 'workshop', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('workshop', 'set up', 'workshop', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('workshop', 'submissions', 'workshop', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('workshop', 'view', 'workshop', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('workshop', 'update', 'workshop', 'name')
Success
workshop tables have been set up correctly