SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- Database: `moodle3610`
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]analytics_indicator_calc`
CREATE TABLE `[[dbprefix]]analytics_indicator_calc` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`starttime` bigint(10) NOT NULL,
`endtime` bigint(10) NOT NULL,
`contextid` bigint(10) NOT NULL,
`sampleorigin` varchar(255) NOT NULL DEFAULT '',
`sampleid` bigint(10) NOT NULL,
`indicator` varchar(255) NOT NULL DEFAULT '',
`value` decimal(10,2) DEFAULT NULL,
`timecreated` bigint(10) NOT NULL,
KEY `[[dbprefix]]analindicalc_staendco_ix` (`starttime`,`endtime`,`contextid`),
KEY `[[dbprefix]]analindicalc_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Stored indicator calculations' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]analytics_models`
CREATE TABLE `[[dbprefix]]analytics_models` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`enabled` tinyint(1) NOT NULL DEFAULT '0',
`trained` tinyint(1) NOT NULL DEFAULT '0',
`target` varchar(255) NOT NULL DEFAULT '',
`indicators` longtext NOT NULL,
`timesplitting` varchar(255) DEFAULT NULL,
`predictionsprocessor` varchar(255) DEFAULT NULL,
`version` bigint(10) NOT NULL,
`timecreated` bigint(10) DEFAULT NULL,
`timemodified` bigint(10) NOT NULL,
`usermodified` bigint(10) NOT NULL,
KEY `[[dbprefix]]analmode_enatra_ix` (`enabled`,`trained`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Analytic models.' AUTO_INCREMENT=3 ;
-- Dumping data for table `[[dbprefix]]analytics_models`
INSERT INTO `[[dbprefix]]analytics_models` VALUES
(1, 0, 0, '\\core\\analytics\\target\\course_dropout', '["\\\\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","\\\\core_course\\\\analytics\\\\indicator\\\\completion_enabled","\\\\core_course\\\\analytics\\\\indicator\\\\potential_cognitive_depth","\\\\core_course\\\\analytics\\\\indicator\\\\potential_social_breadth","\\\\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"]', NULL, '0', [[timestamp]], [[timestamp]], [[timestamp]], 0),
(2, 1, 1, '\\core\\analytics\\target\\no_teaching', '["\\\\core_course\\\\analytics\\\\indicator\\\\no_teacher","\\\\core_course\\\\analytics\\\\indicator\\\\no_student"]', '\\core\\analytics\\time_splitting\\single_range', '0', [[timestamp]], [[timestamp]], [[timestamp]], 0);
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]analytics_models_log`
CREATE TABLE `[[dbprefix]]analytics_models_log` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`modelid` bigint(10) NOT NULL,
`version` bigint(10) NOT NULL,
`target` varchar(255) NOT NULL DEFAULT '',
`indicators` longtext NOT NULL,
`timesplitting` varchar(255) DEFAULT NULL,
`score` decimal(10,5) NOT NULL DEFAULT '0.00000',
`timecreated` bigint(10) NOT NULL,
`usermodified` bigint(10) NOT NULL,
KEY `[[dbprefix]]analmodelog_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Analytic models changes during evaluation.' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]analytics_predictions`
CREATE TABLE `[[dbprefix]]analytics_predictions` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`modelid` bigint(10) NOT NULL,
`contextid` bigint(10) NOT NULL,
`sampleid` bigint(10) NOT NULL,
`rangeindex` mediumint(5) NOT NULL,
`prediction` decimal(10,2) NOT NULL,
`predictionscore` decimal(10,5) NOT NULL,
`calculations` longtext NOT NULL,
`timecreated` bigint(10) NOT NULL DEFAULT '0',
`timestart` bigint(10) DEFAULT NULL,
`timeend` bigint(10) DEFAULT NULL,
KEY `[[dbprefix]]analpred_modcon_ix` (`modelid`,`contextid`),
KEY `[[dbprefix]]analpred_mod_ix` (`modelid`),
KEY `[[dbprefix]]analpred_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Predictions' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]analytics_prediction_actions`
CREATE TABLE `[[dbprefix]]analytics_prediction_actions` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`predictionid` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL,
`actionname` varchar(255) NOT NULL DEFAULT '',
`timecreated` bigint(10) NOT NULL,
KEY `[[dbprefix]]analpredacti_preuseac_ix` (`predictionid`,`userid`,`actionname`),
KEY `[[dbprefix]]analpredacti_pre_ix` (`predictionid`),
KEY `[[dbprefix]]analpredacti_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Register of user actions over predictions.' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]analytics_predict_samples`
CREATE TABLE `[[dbprefix]]analytics_predict_samples` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`modelid` bigint(10) NOT NULL,
`analysableid` bigint(10) NOT NULL,
`timesplitting` varchar(255) NOT NULL DEFAULT '',
`rangeindex` bigint(10) NOT NULL,
`sampleids` longtext NOT NULL,
`timecreated` bigint(10) NOT NULL DEFAULT '0',
`timemodified` bigint(10) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]analpredsamp_modanati_ix` (`modelid`,`analysableid`,`timesplitting`,`rangeindex`),
KEY `[[dbprefix]]analpredsamp_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Samples already used for predictions.' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]analytics_train_samples`
CREATE TABLE `[[dbprefix]]analytics_train_samples` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`modelid` bigint(10) NOT NULL,
`analysableid` bigint(10) NOT NULL,
`timesplitting` varchar(255) NOT NULL DEFAULT '',
`fileid` bigint(10) NOT NULL,
`sampleids` longtext NOT NULL,
`timecreated` bigint(10) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]analtraisamp_modanati_ix` (`modelid`,`analysableid`,`timesplitting`),
KEY `[[dbprefix]]analtraisamp_mod_ix` (`modelid`),
KEY `[[dbprefix]]analtraisamp_fil_ix` (`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Samples used for training' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]analytics_used_analysables`
CREATE TABLE `[[dbprefix]]analytics_used_analysables` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`modelid` bigint(10) NOT NULL,
`action` varchar(50) NOT NULL DEFAULT '',
`analysableid` bigint(10) NOT NULL,
`timeanalysed` bigint(10) NOT NULL,
KEY `[[dbprefix]]analusedanal_modact_ix` (`modelid`,`action`),
KEY `[[dbprefix]]analusedanal_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='List of analysables used by each model' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]analytics_used_files`
CREATE TABLE `[[dbprefix]]analytics_used_files` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`modelid` bigint(10) NOT NULL DEFAULT '0',
`fileid` bigint(10) NOT NULL DEFAULT '0',
`action` varchar(50) NOT NULL DEFAULT '',
`time` bigint(10) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]analusedfile_modactfi_ix` (`modelid`,`action`,`fileid`),
KEY `[[dbprefix]]analusedfile_mod_ix` (`modelid`),
KEY `[[dbprefix]]analusedfile_fil_ix` (`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Files that have already been used for training and predictio' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assign`
CREATE TABLE `[[dbprefix]]assign` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`course` bigint(10) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`intro` longtext NOT NULL,
`introformat` smallint(4) NOT NULL DEFAULT '0',
`alwaysshowdescription` tinyint(2) NOT NULL DEFAULT '0',
`nosubmissions` tinyint(2) NOT NULL DEFAULT '0',
`submissiondrafts` tinyint(2) NOT NULL DEFAULT '0',
`sendnotifications` tinyint(2) NOT NULL DEFAULT '0',
`sendlatenotifications` tinyint(2) NOT NULL DEFAULT '0',
`duedate` bigint(10) NOT NULL DEFAULT '0',
`allowsubmissionsfromdate` bigint(10) NOT NULL DEFAULT '0',
`grade` bigint(10) NOT NULL DEFAULT '0',
`timemodified` bigint(10) NOT NULL DEFAULT '0',
`requiresubmissionstatement` tinyint(2) NOT NULL DEFAULT '0',
`completionsubmit` tinyint(2) NOT NULL DEFAULT '0',
`cutoffdate` bigint(10) NOT NULL DEFAULT '0',
`gradingduedate` bigint(10) NOT NULL DEFAULT '0',
`teamsubmission` tinyint(2) NOT NULL DEFAULT '0',
`requireallteammemberssubmit` tinyint(2) NOT NULL DEFAULT '0',
`teamsubmissiongroupingid` bigint(10) NOT NULL DEFAULT '0',
`blindmarking` tinyint(2) NOT NULL DEFAULT '0',
`revealidentities` tinyint(2) NOT NULL DEFAULT '0',
`attemptreopenmethod` varchar(10) NOT NULL DEFAULT 'none',
`maxattempts` mediumint(6) NOT NULL DEFAULT '-1',
`markingworkflow` tinyint(2) NOT NULL DEFAULT '0',
`markingallocation` tinyint(2) NOT NULL DEFAULT '0',
`sendstudentnotifications` tinyint(2) NOT NULL DEFAULT '1',
`preventsubmissionnotingroup` tinyint(2) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]assi_cou_ix` (`course`),
KEY `[[dbprefix]]assi_tea_ix` (`teamsubmissiongroupingid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='This table saves information about an instance of mod_assign' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignfeedback_comments`
CREATE TABLE `[[dbprefix]]assignfeedback_comments` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`assignment` bigint(10) NOT NULL DEFAULT '0',
`grade` bigint(10) NOT NULL DEFAULT '0',
`commentformat` smallint(4) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]assicomm_ass_ix` (`assignment`),
KEY `[[dbprefix]]assicomm_gra_ix` (`grade`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Text feedback for submitted assignments' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignfeedback_editpdf_annot`
CREATE TABLE `[[dbprefix]]assignfeedback_editpdf_annot` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`gradeid` bigint(10) NOT NULL DEFAULT '0',
`pageno` bigint(10) NOT NULL DEFAULT '0',
`x` bigint(10) DEFAULT '0',
`y` bigint(10) DEFAULT '0',
`endx` bigint(10) DEFAULT '0',
`endy` bigint(10) DEFAULT '0',
`type` varchar(10) DEFAULT 'line',
`colour` varchar(10) DEFAULT 'black',
`draft` tinyint(2) NOT NULL DEFAULT '1',
KEY `[[dbprefix]]assieditanno_grapag_ix` (`gradeid`,`pageno`),
KEY `[[dbprefix]]assieditanno_gra_ix` (`gradeid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='stores annotations added to pdfs submitted by students' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignfeedback_editpdf_cmnt`
CREATE TABLE `[[dbprefix]]assignfeedback_editpdf_cmnt` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`gradeid` bigint(10) NOT NULL DEFAULT '0',
`x` bigint(10) DEFAULT '0',
`y` bigint(10) DEFAULT '0',
`width` bigint(10) DEFAULT '120',
`pageno` bigint(10) NOT NULL DEFAULT '0',
`colour` varchar(10) DEFAULT 'black',
`draft` tinyint(2) NOT NULL DEFAULT '1',
KEY `[[dbprefix]]assieditcmnt_grapag_ix` (`gradeid`,`pageno`),
KEY `[[dbprefix]]assieditcmnt_gra_ix` (`gradeid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Stores comments added to pdfs' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignfeedback_editpdf_queue`
CREATE TABLE `[[dbprefix]]assignfeedback_editpdf_queue` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`submissionid` bigint(10) NOT NULL,
`submissionattempt` bigint(10) NOT NULL,
`attemptedconversions` bigint(10) NOT NULL DEFAULT '0',
UNIQUE KEY `[[dbprefix]]assieditqueu_subsub_uix` (`submissionid`,`submissionattempt`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Queue for processing.' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignfeedback_editpdf_quick`
CREATE TABLE `[[dbprefix]]assignfeedback_editpdf_quick` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`userid` bigint(10) NOT NULL DEFAULT '0',
`rawtext` longtext NOT NULL,
`width` bigint(10) NOT NULL DEFAULT '120',
`colour` varchar(10) DEFAULT 'yellow',
KEY `[[dbprefix]]assieditquic_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Stores teacher specified quicklist comments' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignfeedback_file`
CREATE TABLE `[[dbprefix]]assignfeedback_file` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`assignment` bigint(10) NOT NULL DEFAULT '0',
`grade` bigint(10) NOT NULL DEFAULT '0',
`numfiles` bigint(10) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]assifile_ass2_ix` (`assignment`),
KEY `[[dbprefix]]assifile_gra_ix` (`grade`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Stores info about the number of files submitted by a student' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignment`
CREATE TABLE `[[dbprefix]]assignment` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`course` bigint(10) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`intro` longtext NOT NULL,
`introformat` smallint(4) NOT NULL DEFAULT '0',
`assignmenttype` varchar(50) NOT NULL DEFAULT '',
`resubmit` tinyint(2) NOT NULL DEFAULT '0',
`preventlate` tinyint(2) NOT NULL DEFAULT '0',
`emailteachers` tinyint(2) 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) NOT NULL DEFAULT '100000',
`timedue` bigint(10) NOT NULL DEFAULT '0',
`timeavailable` bigint(10) NOT NULL DEFAULT '0',
`grade` bigint(10) NOT NULL DEFAULT '0',
`timemodified` bigint(10) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]assi_cou2_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Defines assignments' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignment_submissions`
CREATE TABLE `[[dbprefix]]assignment_submissions` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`assignment` bigint(10) NOT NULL DEFAULT '0',
`userid` bigint(10) NOT NULL DEFAULT '0',
`timecreated` bigint(10) NOT NULL DEFAULT '0',
`timemodified` bigint(10) NOT NULL DEFAULT '0',
`numfiles` bigint(10) NOT NULL DEFAULT '0',
`grade` bigint(11) NOT NULL DEFAULT '0',
`submissioncomment` longtext NOT NULL,
`format` smallint(4) NOT NULL DEFAULT '0',
`teacher` bigint(10) NOT NULL DEFAULT '0',
`timemarked` bigint(10) NOT NULL DEFAULT '0',
`mailed` tinyint(1) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]assisubm_use2_ix` (`userid`),
KEY `[[dbprefix]]assisubm_mai_ix` (`mailed`),
KEY `[[dbprefix]]assisubm_tim_ix` (`timemarked`),
KEY `[[dbprefix]]assisubm_ass2_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Info about submitted assignments' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignment_upgrade`
CREATE TABLE `[[dbprefix]]assignment_upgrade` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`oldcmid` bigint(10) NOT NULL DEFAULT '0',
`oldinstance` bigint(10) NOT NULL DEFAULT '0',
`newcmid` bigint(10) NOT NULL DEFAULT '0',
`newinstance` bigint(10) NOT NULL DEFAULT '0',
`timecreated` bigint(10) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]assiupgr_old_ix` (`oldcmid`),
KEY `[[dbprefix]]assiupgr_old2_ix` (`oldinstance`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Info about upgraded assignments' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignsubmission_file`
CREATE TABLE `[[dbprefix]]assignsubmission_file` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`assignment` bigint(10) NOT NULL DEFAULT '0',
`submission` bigint(10) NOT NULL DEFAULT '0',
`numfiles` bigint(10) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]assifile_ass_ix` (`assignment`),
KEY `[[dbprefix]]assifile_sub_ix` (`submission`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Info about file submissions for assignments' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignsubmission_onlinetext`
CREATE TABLE `[[dbprefix]]assignsubmission_onlinetext` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`assignment` bigint(10) NOT NULL DEFAULT '0',
`submission` bigint(10) NOT NULL DEFAULT '0',
`onlineformat` smallint(4) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]assionli_ass_ix` (`assignment`),
KEY `[[dbprefix]]assionli_sub_ix` (`submission`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Info about onlinetext submission' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assign_grades`
CREATE TABLE `[[dbprefix]]assign_grades` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`assignment` bigint(10) NOT NULL DEFAULT '0',
`userid` bigint(10) NOT NULL DEFAULT '0',
`timecreated` bigint(10) NOT NULL DEFAULT '0',
`timemodified` bigint(10) NOT NULL DEFAULT '0',
`grader` bigint(10) NOT NULL DEFAULT '0',
`grade` decimal(10,5) DEFAULT '0.00000',
`attemptnumber` bigint(10) NOT NULL DEFAULT '0',
UNIQUE KEY `[[dbprefix]]assigrad_assuseatt_uix` (`assignment`,`userid`,`attemptnumber`),
KEY `[[dbprefix]]assigrad_use_ix` (`userid`),
KEY `[[dbprefix]]assigrad_att_ix` (`attemptnumber`),
KEY `[[dbprefix]]assigrad_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]][[row_format]] COMMENT='Grading information about a single assignment submission.' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assign_overrides`
CREATE TABLE `[[dbprefix]]assign_overrides` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`assignid` bigint(10) NOT NULL DEFAULT '0',
`groupid` bigint(10) DEFAULT NULL,
`userid` bigint(10) DEFAULT NULL,
`sortorder` bigint(10) DEFAULT NULL,
`allowsubmissionsfromdate` bigint(10) DEFAULT NULL,
`duedate` bigint(10) DEFAULT NULL,
`cutoffdate` bigint(10) DEFAULT NULL,
KEY `[[dbprefix]]assiover_ass_ix` (`assignid`),
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
