Edit File by line

[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

-- Database: `moodle379`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

-- --------------------------------------------------------

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `[[dbprefix]]analytics_indicator_calc`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `[[dbprefix]]analytics_indicator_calc` (

[20] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`starttime` bigint(10) NOT NULL,

[22] Fix | Delete

`endtime` bigint(10) NOT NULL,

[23] Fix | Delete

`contextid` bigint(10) NOT NULL,

[24] Fix | Delete

`sampleorigin` varchar(255) NOT NULL DEFAULT '',

[25] Fix | Delete

`sampleid` bigint(10) NOT NULL,

[26] Fix | Delete

`indicator` varchar(255) NOT NULL DEFAULT '',

[27] Fix | Delete

`value` decimal(10,2) DEFAULT NULL,

[28] Fix | Delete

`timecreated` bigint(10) NOT NULL,

[29] Fix | Delete

PRIMARY KEY (`id`),

[30] Fix | Delete

KEY `[[dbprefix]]analindicalc_staendco_ix` (`starttime`,`endtime`,`contextid`),

[31] Fix | Delete

KEY `[[dbprefix]]analindicalc_con_ix` (`contextid`)

[32] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Stored indicator calculations' AUTO_INCREMENT=1 ;

[33] Fix | Delete

[34] Fix | Delete

-- --------------------------------------------------------

[35] Fix | Delete

[36] Fix | Delete

[37] Fix | Delete

-- Table structure for table `[[dbprefix]]analytics_models`

[38] Fix | Delete

[39] Fix | Delete

[40] Fix | Delete

CREATE TABLE `[[dbprefix]]analytics_models` (

[41] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[42] Fix | Delete

`enabled` tinyint(1) NOT NULL DEFAULT '0',

[43] Fix | Delete

`trained` tinyint(1) NOT NULL DEFAULT '0',

[44] Fix | Delete

`name` varchar(1333) DEFAULT NULL,

[45] Fix | Delete

`target` varchar(255) NOT NULL DEFAULT '',

[46] Fix | Delete

`indicators` longtext NOT NULL,

[47] Fix | Delete

`timesplitting` varchar(255) DEFAULT NULL,

[48] Fix | Delete

`predictionsprocessor` varchar(255) DEFAULT NULL,

[49] Fix | Delete

`version` bigint(10) NOT NULL,

[50] Fix | Delete

`timecreated` bigint(10) DEFAULT NULL,

[51] Fix | Delete

`timemodified` bigint(10) NOT NULL,

[52] Fix | Delete

`usermodified` bigint(10) NOT NULL,

[53] Fix | Delete

PRIMARY KEY (`id`),

[54] Fix | Delete

KEY `[[dbprefix]]analmode_enatra_ix` (`enabled`,`trained`)

[55] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Analytic models.' AUTO_INCREMENT=4 ;

[56] Fix | Delete

[57] Fix | Delete

[58] Fix | Delete

-- Dumping data for table `[[dbprefix]]analytics_models`

[59] Fix | Delete

[60] Fix | Delete

[61] Fix | Delete

INSERT INTO `[[dbprefix]]analytics_models` VALUES

[62] Fix | Delete

(1, 0, 0, NULL, '\\core_course\\analytics\\target\\course_dropout', '["\\\\core\\\\analytics\\\\indicator\\\\any_access_after_end","\\\\core\\\\analytics\\\\indicator\\\\any_access_before_start","\\\\core\\\\analytics\\\\indicator\\\\any_write_action_in_course","\\\\core\\\\analytics\\\\indicator\\\\read_actions","\\\\core_course\\\\analytics\\\\indicator\\\\completion_enabled","\\\\core_course\\\\analytics\\\\indicator\\\\potential_cognitive_depth","\\\\core_course\\\\analytics\\\\indicator\\\\potential_social_breadth","\\\\mod_assign\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_assign\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_book\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_book\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_chat\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_chat\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_choice\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_choice\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_data\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_data\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_feedback\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_feedback\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_folder\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_folder\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_forum\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_forum\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_glossary\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_glossary\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_imscp\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_imscp\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_label\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_label\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_lesson\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_lesson\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_lti\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_lti\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_page\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_page\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_quiz\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_quiz\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_resource\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_resource\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_scorm\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_scorm\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_survey\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_survey\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_url\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_url\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_wiki\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_wiki\\\\analytics\\\\indicator\\\\social_breadth","\\\\mod_workshop\\\\analytics\\\\indicator\\\\cognitive_depth","\\\\mod_workshop\\\\analytics\\\\indicator\\\\social_breadth"]', NULL, NULL, [[timestamp]], [[timestamp]], [[timestamp]], 0),

[63] Fix | Delete

(2, 1, 1, NULL, '\\core_course\\analytics\\target\\no_teaching', '["\\\\core_course\\\\analytics\\\\indicator\\\\no_teacher","\\\\core_course\\\\analytics\\\\indicator\\\\no_student"]', '\\core\\analytics\\time_splitting\\single_range', NULL, [[timestamp]], [[timestamp]], [[timestamp]], 0),

[64] Fix | Delete

(3, 1, 1, NULL, '\\core_user\\analytics\\target\\upcoming_activities_due', '["\\\\core_course\\\\analytics\\\\indicator\\\\activities_due"]', '\\core\\analytics\\time_splitting\\upcoming_week', NULL, [[timestamp]], [[timestamp]], [[timestamp]], 0);

[65] Fix | Delete

[66] Fix | Delete

-- --------------------------------------------------------

[67] Fix | Delete

[68] Fix | Delete

[69] Fix | Delete

-- Table structure for table `[[dbprefix]]analytics_models_log`

[70] Fix | Delete

[71] Fix | Delete

[72] Fix | Delete

CREATE TABLE `[[dbprefix]]analytics_models_log` (

[73] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[74] Fix | Delete

`modelid` bigint(10) NOT NULL,

[75] Fix | Delete

`version` bigint(10) NOT NULL,

[76] Fix | Delete

`evaluationmode` varchar(50) NOT NULL DEFAULT '',

[77] Fix | Delete

`target` varchar(255) NOT NULL DEFAULT '',

[78] Fix | Delete

`indicators` longtext NOT NULL,

[79] Fix | Delete

`timesplitting` varchar(255) DEFAULT NULL,

[80] Fix | Delete

`score` decimal(10,5) NOT NULL DEFAULT '0.00000',

[81] Fix | Delete

`info` longtext,

[82] Fix | Delete

`dir` longtext NOT NULL,

[83] Fix | Delete

`timecreated` bigint(10) NOT NULL,

[84] Fix | Delete

`usermodified` bigint(10) NOT NULL,

[85] Fix | Delete

PRIMARY KEY (`id`),

[86] Fix | Delete

KEY `[[dbprefix]]analmodelog_mod_ix` (`modelid`)

[87] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Analytic models changes during evaluation.' AUTO_INCREMENT=1 ;

[88] Fix | Delete

[89] Fix | Delete

-- --------------------------------------------------------

[90] Fix | Delete

[91] Fix | Delete

[92] Fix | Delete

-- Table structure for table `[[dbprefix]]analytics_predictions`

[93] Fix | Delete

[94] Fix | Delete

[95] Fix | Delete

CREATE TABLE `[[dbprefix]]analytics_predictions` (

[96] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[97] Fix | Delete

`modelid` bigint(10) NOT NULL,

[98] Fix | Delete

`contextid` bigint(10) NOT NULL,

[99] Fix | Delete

`sampleid` bigint(10) NOT NULL,

[100] Fix | Delete

`rangeindex` mediumint(5) NOT NULL,

[101] Fix | Delete

`prediction` decimal(10,2) NOT NULL,

[102] Fix | Delete

`predictionscore` decimal(10,5) NOT NULL,

[103] Fix | Delete

`calculations` longtext NOT NULL,

[104] Fix | Delete

`timecreated` bigint(10) NOT NULL DEFAULT '0',

[105] Fix | Delete

`timestart` bigint(10) DEFAULT NULL,

[106] Fix | Delete

`timeend` bigint(10) DEFAULT NULL,

[107] Fix | Delete

PRIMARY KEY (`id`),

[108] Fix | Delete

KEY `[[dbprefix]]analpred_modcon_ix` (`modelid`,`contextid`),

[109] Fix | Delete

KEY `[[dbprefix]]analpred_mod_ix` (`modelid`),

[110] Fix | Delete

KEY `[[dbprefix]]analpred_con_ix` (`contextid`)

[111] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Predictions' AUTO_INCREMENT=1 ;

[112] Fix | Delete

[113] Fix | Delete

-- --------------------------------------------------------

[114] Fix | Delete

[115] Fix | Delete

[116] Fix | Delete

-- Table structure for table `[[dbprefix]]analytics_prediction_actions`

[117] Fix | Delete

[118] Fix | Delete

[119] Fix | Delete

CREATE TABLE `[[dbprefix]]analytics_prediction_actions` (

[120] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[121] Fix | Delete

`predictionid` bigint(10) NOT NULL,

[122] Fix | Delete

`userid` bigint(10) NOT NULL,

[123] Fix | Delete

`actionname` varchar(255) NOT NULL DEFAULT '',

[124] Fix | Delete

`timecreated` bigint(10) NOT NULL,

[125] Fix | Delete

PRIMARY KEY (`id`),

[126] Fix | Delete

KEY `[[dbprefix]]analpredacti_preuseac_ix` (`predictionid`,`userid`,`actionname`),

[127] Fix | Delete

KEY `[[dbprefix]]analpredacti_pre_ix` (`predictionid`),

[128] Fix | Delete

KEY `[[dbprefix]]analpredacti_use_ix` (`userid`)

[129] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Register of user actions over predictions.' AUTO_INCREMENT=1 ;

[130] Fix | Delete

[131] Fix | Delete

-- --------------------------------------------------------

[132] Fix | Delete

[133] Fix | Delete

[134] Fix | Delete

-- Table structure for table `[[dbprefix]]analytics_predict_samples`

[135] Fix | Delete

[136] Fix | Delete

[137] Fix | Delete

CREATE TABLE `[[dbprefix]]analytics_predict_samples` (

[138] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[139] Fix | Delete

`modelid` bigint(10) NOT NULL,

[140] Fix | Delete

`analysableid` bigint(10) NOT NULL,

[141] Fix | Delete

`timesplitting` varchar(255) NOT NULL DEFAULT '',

[142] Fix | Delete

`rangeindex` bigint(10) NOT NULL,

[143] Fix | Delete

`sampleids` longtext NOT NULL,

[144] Fix | Delete

`timecreated` bigint(10) NOT NULL DEFAULT '0',

[145] Fix | Delete

`timemodified` bigint(10) NOT NULL DEFAULT '0',

[146] Fix | Delete

PRIMARY KEY (`id`),

[147] Fix | Delete

KEY `[[dbprefix]]analpredsamp_modanati_ix` (`modelid`,`analysableid`,`timesplitting`,`rangeindex`),

[148] Fix | Delete

KEY `[[dbprefix]]analpredsamp_mod_ix` (`modelid`)

[149] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Samples already used for predictions.' AUTO_INCREMENT=1 ;

[150] Fix | Delete

[151] Fix | Delete

-- --------------------------------------------------------

[152] Fix | Delete

[153] Fix | Delete

[154] Fix | Delete

-- Table structure for table `[[dbprefix]]analytics_train_samples`

[155] Fix | Delete

[156] Fix | Delete

[157] Fix | Delete

CREATE TABLE `[[dbprefix]]analytics_train_samples` (

[158] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[159] Fix | Delete

`modelid` bigint(10) NOT NULL,

[160] Fix | Delete

`analysableid` bigint(10) NOT NULL,

[161] Fix | Delete

`timesplitting` varchar(255) NOT NULL DEFAULT '',

[162] Fix | Delete

`sampleids` longtext NOT NULL,

[163] Fix | Delete

`timecreated` bigint(10) NOT NULL DEFAULT '0',

[164] Fix | Delete

PRIMARY KEY (`id`),

[165] Fix | Delete

KEY `[[dbprefix]]analtraisamp_modanati_ix` (`modelid`,`analysableid`,`timesplitting`),

[166] Fix | Delete

KEY `[[dbprefix]]analtraisamp_mod_ix` (`modelid`)

[167] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Samples used for training' AUTO_INCREMENT=1 ;

[168] Fix | Delete

[169] Fix | Delete

-- --------------------------------------------------------

[170] Fix | Delete

[171] Fix | Delete

[172] Fix | Delete

-- Table structure for table `[[dbprefix]]analytics_used_analysables`

[173] Fix | Delete

[174] Fix | Delete

[175] Fix | Delete

CREATE TABLE `[[dbprefix]]analytics_used_analysables` (

[176] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[177] Fix | Delete

`modelid` bigint(10) NOT NULL,

[178] Fix | Delete

`action` varchar(50) NOT NULL DEFAULT '',

[179] Fix | Delete

`analysableid` bigint(10) NOT NULL,

[180] Fix | Delete

`firstanalysis` bigint(10) NOT NULL,

[181] Fix | Delete

`timeanalysed` bigint(10) NOT NULL,

[182] Fix | Delete

PRIMARY KEY (`id`),

[183] Fix | Delete

KEY `[[dbprefix]]analusedanal_modact_ix` (`modelid`,`action`),

[184] Fix | Delete

KEY `[[dbprefix]]analusedanal_ana_ix` (`analysableid`),

[185] Fix | Delete

KEY `[[dbprefix]]analusedanal_mod_ix` (`modelid`)

[186] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='List of analysables used by each model' AUTO_INCREMENT=1 ;

[187] Fix | Delete

[188] Fix | Delete

-- --------------------------------------------------------

[189] Fix | Delete

[190] Fix | Delete

[191] Fix | Delete

-- Table structure for table `[[dbprefix]]analytics_used_files`

[192] Fix | Delete

[193] Fix | Delete

[194] Fix | Delete

CREATE TABLE `[[dbprefix]]analytics_used_files` (

[195] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[196] Fix | Delete

`modelid` bigint(10) NOT NULL DEFAULT '0',

[197] Fix | Delete

`fileid` bigint(10) NOT NULL DEFAULT '0',

[198] Fix | Delete

`action` varchar(50) NOT NULL DEFAULT '',

[199] Fix | Delete

`time` bigint(10) NOT NULL DEFAULT '0',

[200] Fix | Delete

PRIMARY KEY (`id`),

[201] Fix | Delete

KEY `[[dbprefix]]analusedfile_modactfi_ix` (`modelid`,`action`,`fileid`),

[202] Fix | Delete

KEY `[[dbprefix]]analusedfile_mod_ix` (`modelid`),

[203] Fix | Delete

KEY `[[dbprefix]]analusedfile_fil_ix` (`fileid`)

[204] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Files that have already been used for training and predictio' AUTO_INCREMENT=1 ;

[205] Fix | Delete

[206] Fix | Delete

-- --------------------------------------------------------

[207] Fix | Delete

[208] Fix | Delete

[209] Fix | Delete

-- Table structure for table `[[dbprefix]]assign`

[210] Fix | Delete

[211] Fix | Delete

[212] Fix | Delete

CREATE TABLE `[[dbprefix]]assign` (

[213] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[214] Fix | Delete

`course` bigint(10) NOT NULL DEFAULT '0',

[215] Fix | Delete

`name` varchar(255) NOT NULL DEFAULT '',

[216] Fix | Delete

`intro` longtext NOT NULL,

[217] Fix | Delete

`introformat` smallint(4) NOT NULL DEFAULT '0',

[218] Fix | Delete

`alwaysshowdescription` tinyint(2) NOT NULL DEFAULT '0',

[219] Fix | Delete

`nosubmissions` tinyint(2) NOT NULL DEFAULT '0',

[220] Fix | Delete

`submissiondrafts` tinyint(2) NOT NULL DEFAULT '0',

[221] Fix | Delete

`sendnotifications` tinyint(2) NOT NULL DEFAULT '0',

[222] Fix | Delete

`sendlatenotifications` tinyint(2) NOT NULL DEFAULT '0',

[223] Fix | Delete

`duedate` bigint(10) NOT NULL DEFAULT '0',

[224] Fix | Delete

`allowsubmissionsfromdate` bigint(10) NOT NULL DEFAULT '0',

[225] Fix | Delete

`grade` bigint(10) NOT NULL DEFAULT '0',

[226] Fix | Delete

`timemodified` bigint(10) NOT NULL DEFAULT '0',

[227] Fix | Delete

`requiresubmissionstatement` tinyint(2) NOT NULL DEFAULT '0',

[228] Fix | Delete

`completionsubmit` tinyint(2) NOT NULL DEFAULT '0',

[229] Fix | Delete

`cutoffdate` bigint(10) NOT NULL DEFAULT '0',

[230] Fix | Delete

`gradingduedate` bigint(10) NOT NULL DEFAULT '0',

[231] Fix | Delete

`teamsubmission` tinyint(2) NOT NULL DEFAULT '0',

[232] Fix | Delete

`requireallteammemberssubmit` tinyint(2) NOT NULL DEFAULT '0',

[233] Fix | Delete

`teamsubmissiongroupingid` bigint(10) NOT NULL DEFAULT '0',

[234] Fix | Delete

`blindmarking` tinyint(2) NOT NULL DEFAULT '0',

[235] Fix | Delete

`hidegrader` tinyint(2) NOT NULL DEFAULT '0',

[236] Fix | Delete

`revealidentities` tinyint(2) NOT NULL DEFAULT '0',

[237] Fix | Delete

`attemptreopenmethod` varchar(10) NOT NULL DEFAULT 'none',

[238] Fix | Delete

`maxattempts` mediumint(6) NOT NULL DEFAULT '-1',

[239] Fix | Delete

`markingworkflow` tinyint(2) NOT NULL DEFAULT '0',

[240] Fix | Delete

`markingallocation` tinyint(2) NOT NULL DEFAULT '0',

[241] Fix | Delete

`sendstudentnotifications` tinyint(2) NOT NULL DEFAULT '1',

[242] Fix | Delete

`preventsubmissionnotingroup` tinyint(2) NOT NULL DEFAULT '0',

[243] Fix | Delete

PRIMARY KEY (`id`),

[244] Fix | Delete

KEY `[[dbprefix]]assi_cou_ix` (`course`),

[245] Fix | Delete

KEY `[[dbprefix]]assi_tea_ix` (`teamsubmissiongroupingid`)

[246] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='This table saves information about an instance of mod_assign' AUTO_INCREMENT=1 ;

[247] Fix | Delete

[248] Fix | Delete

-- --------------------------------------------------------

[249] Fix | Delete

[250] Fix | Delete

[251] Fix | Delete

-- Table structure for table `[[dbprefix]]assignfeedback_comments`

[252] Fix | Delete

[253] Fix | Delete

[254] Fix | Delete

CREATE TABLE `[[dbprefix]]assignfeedback_comments` (

[255] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[256] Fix | Delete

`assignment` bigint(10) NOT NULL DEFAULT '0',

[257] Fix | Delete

`grade` bigint(10) NOT NULL DEFAULT '0',

[258] Fix | Delete

`commenttext` longtext,

[259] Fix | Delete

`commentformat` smallint(4) NOT NULL DEFAULT '0',

[260] Fix | Delete

PRIMARY KEY (`id`),

[261] Fix | Delete

KEY `[[dbprefix]]assicomm_ass_ix` (`assignment`),

[262] Fix | Delete

KEY `[[dbprefix]]assicomm_gra_ix` (`grade`)

[263] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Text feedback for submitted assignments' AUTO_INCREMENT=1 ;

[264] Fix | Delete

[265] Fix | Delete

-- --------------------------------------------------------

[266] Fix | Delete

[267] Fix | Delete

[268] Fix | Delete

-- Table structure for table `[[dbprefix]]assignfeedback_editpdf_annot`

[269] Fix | Delete

[270] Fix | Delete

[271] Fix | Delete

CREATE TABLE `[[dbprefix]]assignfeedback_editpdf_annot` (

[272] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[273] Fix | Delete

`gradeid` bigint(10) NOT NULL DEFAULT '0',

[274] Fix | Delete

`pageno` bigint(10) NOT NULL DEFAULT '0',

[275] Fix | Delete

`x` bigint(10) DEFAULT '0',

[276] Fix | Delete

`y` bigint(10) DEFAULT '0',

[277] Fix | Delete

`endx` bigint(10) DEFAULT '0',

[278] Fix | Delete

`endy` bigint(10) DEFAULT '0',

[279] Fix | Delete

`path` longtext,

[280] Fix | Delete

`type` varchar(10) DEFAULT 'line',

[281] Fix | Delete

`colour` varchar(10) DEFAULT 'black',

[282] Fix | Delete

`draft` tinyint(2) NOT NULL DEFAULT '1',

[283] Fix | Delete

PRIMARY KEY (`id`),

[284] Fix | Delete

KEY `[[dbprefix]]assieditanno_grapag_ix` (`gradeid`,`pageno`),

[285] Fix | Delete

KEY `[[dbprefix]]assieditanno_gra_ix` (`gradeid`)

[286] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='stores annotations added to pdfs submitted by students' AUTO_INCREMENT=1 ;

[287] Fix | Delete

[288] Fix | Delete

-- --------------------------------------------------------

[289] Fix | Delete

[290] Fix | Delete

[291] Fix | Delete

-- Table structure for table `[[dbprefix]]assignfeedback_editpdf_cmnt`

[292] Fix | Delete

[293] Fix | Delete

[294] Fix | Delete

CREATE TABLE `[[dbprefix]]assignfeedback_editpdf_cmnt` (

[295] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[296] Fix | Delete

`gradeid` bigint(10) NOT NULL DEFAULT '0',

[297] Fix | Delete

`x` bigint(10) DEFAULT '0',

[298] Fix | Delete

`y` bigint(10) DEFAULT '0',

[299] Fix | Delete

`width` bigint(10) DEFAULT '120',

[300] Fix | Delete

`rawtext` longtext,

[301] Fix | Delete

`pageno` bigint(10) NOT NULL DEFAULT '0',

[302] Fix | Delete

`colour` varchar(10) DEFAULT 'black',

[303] Fix | Delete

`draft` tinyint(2) NOT NULL DEFAULT '1',

[304] Fix | Delete

PRIMARY KEY (`id`),

[305] Fix | Delete

KEY `[[dbprefix]]assieditcmnt_grapag_ix` (`gradeid`,`pageno`),

[306] Fix | Delete

KEY `[[dbprefix]]assieditcmnt_gra_ix` (`gradeid`)

[307] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Stores comments added to pdfs' AUTO_INCREMENT=1 ;

[308] Fix | Delete

[309] Fix | Delete

-- --------------------------------------------------------

[310] Fix | Delete

[311] Fix | Delete

[312] Fix | Delete

-- Table structure for table `[[dbprefix]]assignfeedback_editpdf_queue`

[313] Fix | Delete

[314] Fix | Delete

[315] Fix | Delete

CREATE TABLE `[[dbprefix]]assignfeedback_editpdf_queue` (

[316] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[317] Fix | Delete

`submissionid` bigint(10) NOT NULL,

[318] Fix | Delete

`submissionattempt` bigint(10) NOT NULL,

[319] Fix | Delete

`attemptedconversions` bigint(10) NOT NULL DEFAULT '0',

[320] Fix | Delete

PRIMARY KEY (`id`),

[321] Fix | Delete

UNIQUE KEY `[[dbprefix]]assieditqueu_subsub_uix` (`submissionid`,`submissionattempt`)

[322] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Queue for processing.' AUTO_INCREMENT=1 ;

[323] Fix | Delete

[324] Fix | Delete

-- --------------------------------------------------------

[325] Fix | Delete

[326] Fix | Delete

[327] Fix | Delete

-- Table structure for table `[[dbprefix]]assignfeedback_editpdf_quick`

[328] Fix | Delete

[329] Fix | Delete

[330] Fix | Delete

CREATE TABLE `[[dbprefix]]assignfeedback_editpdf_quick` (

[331] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[332] Fix | Delete

`userid` bigint(10) NOT NULL DEFAULT '0',

[333] Fix | Delete

`rawtext` longtext NOT NULL,

[334] Fix | Delete

`width` bigint(10) NOT NULL DEFAULT '120',

[335] Fix | Delete

`colour` varchar(10) DEFAULT 'yellow',

[336] Fix | Delete

PRIMARY KEY (`id`),

[337] Fix | Delete

KEY `[[dbprefix]]assieditquic_use_ix` (`userid`)

[338] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Stores teacher specified quicklist comments' AUTO_INCREMENT=1 ;

[339] Fix | Delete

[340] Fix | Delete

-- --------------------------------------------------------

[341] Fix | Delete

[342] Fix | Delete

[343] Fix | Delete

-- Table structure for table `[[dbprefix]]assignfeedback_editpdf_rot`

[344] Fix | Delete

[345] Fix | Delete

[346] Fix | Delete

CREATE TABLE `[[dbprefix]]assignfeedback_editpdf_rot` (

[347] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[348] Fix | Delete

`gradeid` bigint(10) NOT NULL DEFAULT '0',

[349] Fix | Delete

`pageno` bigint(10) NOT NULL DEFAULT '0',

[350] Fix | Delete

`pathnamehash` longtext NOT NULL,

[351] Fix | Delete

`isrotated` tinyint(1) NOT NULL DEFAULT '0',

[352] Fix | Delete

`degree` bigint(10) NOT NULL DEFAULT '0',

[353] Fix | Delete

PRIMARY KEY (`id`),

[354] Fix | Delete

UNIQUE KEY `[[dbprefix]]assieditrot_grapag_uix` (`gradeid`,`pageno`),

[355] Fix | Delete

KEY `[[dbprefix]]assieditrot_gra_ix` (`gradeid`)

[356] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Stores rotation information of a page.' AUTO_INCREMENT=1 ;

[357] Fix | Delete

[358] Fix | Delete

-- --------------------------------------------------------

[359] Fix | Delete

[360] Fix | Delete

[361] Fix | Delete

-- Table structure for table `[[dbprefix]]assignfeedback_file`

[362] Fix | Delete

[363] Fix | Delete

[364] Fix | Delete

CREATE TABLE `[[dbprefix]]assignfeedback_file` (

[365] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[366] Fix | Delete

`assignment` bigint(10) NOT NULL DEFAULT '0',

[367] Fix | Delete

`grade` bigint(10) NOT NULL DEFAULT '0',

[368] Fix | Delete

`numfiles` bigint(10) NOT NULL DEFAULT '0',

[369] Fix | Delete

PRIMARY KEY (`id`),

[370] Fix | Delete

KEY `[[dbprefix]]assifile_ass2_ix` (`assignment`),

[371] Fix | Delete

KEY `[[dbprefix]]assifile_gra_ix` (`grade`)

[372] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Stores info about the number of files submitted by a student' AUTO_INCREMENT=1 ;

[373] Fix | Delete

[374] Fix | Delete

-- --------------------------------------------------------

[375] Fix | Delete

[376] Fix | Delete

[377] Fix | Delete

-- Table structure for table `[[dbprefix]]assignment`

[378] Fix | Delete

[379] Fix | Delete

[380] Fix | Delete

CREATE TABLE `[[dbprefix]]assignment` (

[381] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[382] Fix | Delete

`course` bigint(10) NOT NULL DEFAULT '0',

[383] Fix | Delete

`name` varchar(255) NOT NULL DEFAULT '',

[384] Fix | Delete

`intro` longtext NOT NULL,

[385] Fix | Delete

`introformat` smallint(4) NOT NULL DEFAULT '0',

[386] Fix | Delete

`assignmenttype` varchar(50) NOT NULL DEFAULT '',

[387] Fix | Delete

`resubmit` tinyint(2) NOT NULL DEFAULT '0',

[388] Fix | Delete

`preventlate` tinyint(2) NOT NULL DEFAULT '0',

[389] Fix | Delete

`emailteachers` tinyint(2) NOT NULL DEFAULT '0',

[390] Fix | Delete

`var1` bigint(10) DEFAULT '0',

[391] Fix | Delete

`var2` bigint(10) DEFAULT '0',

[392] Fix | Delete

`var3` bigint(10) DEFAULT '0',

[393] Fix | Delete

`var4` bigint(10) DEFAULT '0',

[394] Fix | Delete

`var5` bigint(10) DEFAULT '0',

[395] Fix | Delete

`maxbytes` bigint(10) NOT NULL DEFAULT '100000',

[396] Fix | Delete

`timedue` bigint(10) NOT NULL DEFAULT '0',

[397] Fix | Delete

`timeavailable` bigint(10) NOT NULL DEFAULT '0',

[398] Fix | Delete

`grade` bigint(10) NOT NULL DEFAULT '0',

[399] Fix | Delete

`timemodified` bigint(10) NOT NULL DEFAULT '0',

[400] Fix | Delete

PRIMARY KEY (`id`),

[401] Fix | Delete

KEY `[[dbprefix]]assi_cou2_ix` (`course`)

[402] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Defines assignments' AUTO_INCREMENT=1 ;

[403] Fix | Delete

[404] Fix | Delete

-- --------------------------------------------------------

[405] Fix | Delete

[406] Fix | Delete

[407] Fix | Delete

-- Table structure for table `[[dbprefix]]assignment_submissions`

[408] Fix | Delete

[409] Fix | Delete

[410] Fix | Delete

CREATE TABLE `[[dbprefix]]assignment_submissions` (

[411] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[412] Fix | Delete

`assignment` bigint(10) NOT NULL DEFAULT '0',

[413] Fix | Delete

`userid` bigint(10) NOT NULL DEFAULT '0',

[414] Fix | Delete

`timecreated` bigint(10) NOT NULL DEFAULT '0',

[415] Fix | Delete

`timemodified` bigint(10) NOT NULL DEFAULT '0',

[416] Fix | Delete

`numfiles` bigint(10) NOT NULL DEFAULT '0',

[417] Fix | Delete

`data1` longtext,

[418] Fix | Delete

`data2` longtext,

[419] Fix | Delete

`grade` bigint(11) NOT NULL DEFAULT '0',

[420] Fix | Delete

`submissioncomment` longtext NOT NULL,

[421] Fix | Delete

`format` smallint(4) NOT NULL DEFAULT '0',

[422] Fix | Delete

`teacher` bigint(10) NOT NULL DEFAULT '0',

[423] Fix | Delete

`timemarked` bigint(10) NOT NULL DEFAULT '0',

[424] Fix | Delete

`mailed` tinyint(1) NOT NULL DEFAULT '0',

[425] Fix | Delete

PRIMARY KEY (`id`),

[426] Fix | Delete

KEY `[[dbprefix]]assisubm_use2_ix` (`userid`),

[427] Fix | Delete

KEY `[[dbprefix]]assisubm_mai_ix` (`mailed`),

[428] Fix | Delete

KEY `[[dbprefix]]assisubm_tim_ix` (`timemarked`),

[429] Fix | Delete

KEY `[[dbprefix]]assisubm_ass2_ix` (`assignment`)

[430] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Info about submitted assignments' AUTO_INCREMENT=1 ;

[431] Fix | Delete

[432] Fix | Delete

-- --------------------------------------------------------

[433] Fix | Delete

[434] Fix | Delete

[435] Fix | Delete

-- Table structure for table `[[dbprefix]]assignment_upgrade`

[436] Fix | Delete

[437] Fix | Delete

[438] Fix | Delete

CREATE TABLE `[[dbprefix]]assignment_upgrade` (

[439] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[440] Fix | Delete

`oldcmid` bigint(10) NOT NULL DEFAULT '0',

[441] Fix | Delete

`oldinstance` bigint(10) NOT NULL DEFAULT '0',

[442] Fix | Delete

`newcmid` bigint(10) NOT NULL DEFAULT '0',

[443] Fix | Delete

`newinstance` bigint(10) NOT NULL DEFAULT '0',

[444] Fix | Delete

`timecreated` bigint(10) NOT NULL DEFAULT '0',

[445] Fix | Delete

PRIMARY KEY (`id`),

[446] Fix | Delete

KEY `[[dbprefix]]assiupgr_old_ix` (`oldcmid`),

[447] Fix | Delete

KEY `[[dbprefix]]assiupgr_old2_ix` (`oldinstance`)

[448] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Info about upgraded assignments' AUTO_INCREMENT=1 ;

[449] Fix | Delete

[450] Fix | Delete

-- --------------------------------------------------------

[451] Fix | Delete

[452] Fix | Delete

[453] Fix | Delete

-- Table structure for table `[[dbprefix]]assignsubmission_file`

[454] Fix | Delete

[455] Fix | Delete

[456] Fix | Delete

CREATE TABLE `[[dbprefix]]assignsubmission_file` (

[457] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[458] Fix | Delete

`assignment` bigint(10) NOT NULL DEFAULT '0',

[459] Fix | Delete

`submission` bigint(10) NOT NULL DEFAULT '0',

[460] Fix | Delete

`numfiles` bigint(10) NOT NULL DEFAULT '0',

[461] Fix | Delete

PRIMARY KEY (`id`),

[462] Fix | Delete

KEY `[[dbprefix]]assifile_ass_ix` (`assignment`),

[463] Fix | Delete

KEY `[[dbprefix]]assifile_sub_ix` (`submission`)

[464] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Info about file submissions for assignments' AUTO_INCREMENT=1 ;

[465] Fix | Delete

[466] Fix | Delete

-- --------------------------------------------------------

[467] Fix | Delete

[468] Fix | Delete

[469] Fix | Delete

-- Table structure for table `[[dbprefix]]assignsubmission_onlinetext`

[470] Fix | Delete

[471] Fix | Delete

[472] Fix | Delete

CREATE TABLE `[[dbprefix]]assignsubmission_onlinetext` (

[473] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[474] Fix | Delete

`assignment` bigint(10) NOT NULL DEFAULT '0',

[475] Fix | Delete

`submission` bigint(10) NOT NULL DEFAULT '0',

[476] Fix | Delete

`onlinetext` longtext,

[477] Fix | Delete

`onlineformat` smallint(4) NOT NULL DEFAULT '0',

[478] Fix | Delete

PRIMARY KEY (`id`),

[479] Fix | Delete

KEY `[[dbprefix]]assionli_ass_ix` (`assignment`),

[480] Fix | Delete

KEY `[[dbprefix]]assionli_sub_ix` (`submission`)

[481] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Info about onlinetext submission' AUTO_INCREMENT=1 ;

[482] Fix | Delete

[483] Fix | Delete

-- --------------------------------------------------------

[484] Fix | Delete

[485] Fix | Delete

[486] Fix | Delete

-- Table structure for table `[[dbprefix]]assign_grades`

[487] Fix | Delete

[488] Fix | Delete

[489] Fix | Delete

CREATE TABLE `[[dbprefix]]assign_grades` (

[490] Fix | Delete

`id` bigint(10) NOT NULL AUTO_INCREMENT,

[491] Fix | Delete

`assignment` bigint(10) NOT NULL DEFAULT '0',

[492] Fix | Delete

`userid` bigint(10) NOT NULL DEFAULT '0',

[493] Fix | Delete

`timecreated` bigint(10) NOT NULL DEFAULT '0',

[494] Fix | Delete

`timemodified` bigint(10) NOT NULL DEFAULT '0',

[495] Fix | Delete

`grader` bigint(10) NOT NULL DEFAULT '0',

[496] Fix | Delete

`grade` decimal(10,5) DEFAULT '0.00000',

[497] Fix | Delete

`attemptnumber` bigint(10) NOT NULL DEFAULT '0',

[498] Fix | Delete

PRIMARY KEY (`id`),

[499] Fix | Delete

12 3 4 5 6 ...36