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: `moodle2611`
-- --------------------------------------------------------
-- 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',
`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',
KEY `[[dbprefix]]assi_cou_ix` (`course`),
KEY `[[dbprefix]]assi_tea_ix` (`teamsubmissiongroupingid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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 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 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 COMMENT='Stores comments added to pdfs' 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 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 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 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 COMMENT='Info about submitted 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 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 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 COMMENT='Grading information about a single assignment submission.' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assign_plugin_config`
CREATE TABLE `[[dbprefix]]assign_plugin_config` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`assignment` bigint(10) NOT NULL DEFAULT '0',
`plugin` varchar(28) NOT NULL DEFAULT '',
`subtype` varchar(28) NOT NULL DEFAULT '',
`name` varchar(28) NOT NULL DEFAULT '',
KEY `[[dbprefix]]assiplugconf_plu_ix` (`plugin`),
KEY `[[dbprefix]]assiplugconf_sub_ix` (`subtype`),
KEY `[[dbprefix]]assiplugconf_nam_ix` (`name`),
KEY `[[dbprefix]]assiplugconf_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Config data for an instance of a plugin in an assignment.' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assign_submission`
CREATE TABLE `[[dbprefix]]assign_submission` (
`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',
`status` varchar(10) DEFAULT NULL,
`groupid` bigint(10) NOT NULL DEFAULT '0',
`attemptnumber` bigint(10) NOT NULL DEFAULT '0',
UNIQUE KEY `[[dbprefix]]assisubm_assusegroa_uix` (`assignment`,`userid`,`groupid`,`attemptnumber`),
KEY `[[dbprefix]]assisubm_use_ix` (`userid`),
KEY `[[dbprefix]]assisubm_att_ix` (`attemptnumber`),
KEY `[[dbprefix]]assisubm_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table keeps information about student interactions with' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assign_user_flags`
CREATE TABLE `[[dbprefix]]assign_user_flags` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`userid` bigint(10) NOT NULL DEFAULT '0',
`assignment` bigint(10) NOT NULL DEFAULT '0',
`locked` bigint(10) NOT NULL DEFAULT '0',
`mailed` smallint(4) NOT NULL DEFAULT '0',
`extensionduedate` bigint(10) NOT NULL DEFAULT '0',
`workflowstate` varchar(20) DEFAULT NULL,
`allocatedmarker` bigint(10) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]assiuserflag_mai_ix` (`mailed`),
KEY `[[dbprefix]]assiuserflag_use_ix` (`userid`),
KEY `[[dbprefix]]assiuserflag_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='List of flags that can be set for a single user in a single ' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assign_user_mapping`
CREATE TABLE `[[dbprefix]]assign_user_mapping` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`assignment` bigint(10) NOT NULL DEFAULT '0',
`userid` bigint(10) NOT NULL DEFAULT '0',
KEY `[[dbprefix]]assiusermapp_ass_ix` (`assignment`),
KEY `[[dbprefix]]assiusermapp_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Map an assignment specific id number to a user' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]backup_controllers`
CREATE TABLE `[[dbprefix]]backup_controllers` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`backupid` varchar(32) NOT NULL DEFAULT '',
`operation` varchar(20) NOT NULL DEFAULT 'backup',
`type` varchar(10) NOT NULL DEFAULT '',
`itemid` bigint(10) NOT NULL,
`format` varchar(20) NOT NULL DEFAULT '',
`interactive` smallint(4) NOT NULL,
`purpose` smallint(4) NOT NULL,
`userid` bigint(10) NOT NULL,
`status` smallint(4) NOT NULL,
`execution` smallint(4) NOT NULL,
`executiontime` bigint(10) NOT NULL,
`checksum` varchar(32) NOT NULL DEFAULT '',
`timecreated` bigint(10) NOT NULL,
`timemodified` bigint(10) NOT NULL,
`controller` longtext NOT NULL,
UNIQUE KEY `[[dbprefix]]backcont_bac_uix` (`backupid`),
KEY `[[dbprefix]]backcont_typite_ix` (`type`,`itemid`),
KEY `[[dbprefix]]backcont_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='To store the backup_controllers as they are used' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]backup_courses`
CREATE TABLE `[[dbprefix]]backup_courses` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`courseid` bigint(10) NOT NULL DEFAULT '0',
`laststarttime` bigint(10) NOT NULL DEFAULT '0',
`lastendtime` bigint(10) NOT NULL DEFAULT '0',
`laststatus` varchar(1) NOT NULL DEFAULT '5',
`nextstarttime` bigint(10) NOT NULL DEFAULT '0',
UNIQUE KEY `[[dbprefix]]backcour_cou_uix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='To store every course backup status' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]backup_logs`
CREATE TABLE `[[dbprefix]]backup_logs` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`backupid` varchar(32) NOT NULL DEFAULT '',
`loglevel` smallint(4) NOT NULL,
`message` longtext NOT NULL,
`timecreated` bigint(10) NOT NULL,
UNIQUE KEY `[[dbprefix]]backlogs_bacid_uix` (`backupid`,`id`),
KEY `[[dbprefix]]backlogs_bac_ix` (`backupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='To store all the logs from backup and restore operations (by' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]badge`
CREATE TABLE `[[dbprefix]]badge` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`timecreated` bigint(10) NOT NULL DEFAULT '0',
`timemodified` bigint(10) NOT NULL DEFAULT '0',
`usercreated` bigint(10) NOT NULL,
`usermodified` bigint(10) NOT NULL,
`issuername` varchar(255) NOT NULL DEFAULT '',
`issuerurl` varchar(255) NOT NULL DEFAULT '',
`issuercontact` varchar(255) DEFAULT NULL,
`expiredate` bigint(10) DEFAULT NULL,
`expireperiod` bigint(10) DEFAULT NULL,
`type` tinyint(1) NOT NULL DEFAULT '1',
`courseid` bigint(10) DEFAULT NULL,
`message` longtext NOT NULL,
`messagesubject` longtext NOT NULL,
`attachment` tinyint(1) NOT NULL DEFAULT '1',
`notification` tinyint(1) NOT NULL DEFAULT '1',
`status` tinyint(1) NOT NULL DEFAULT '0',
`nextcron` bigint(10) DEFAULT NULL,
KEY `[[dbprefix]]badg_typ_ix` (`type`),
KEY `[[dbprefix]]badg_cou_ix` (`courseid`),
KEY `[[dbprefix]]badg_use_ix` (`usermodified`),
KEY `[[dbprefix]]badg_use2_ix` (`usercreated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Defines badge' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]badge_backpack`
CREATE TABLE `[[dbprefix]]badge_backpack` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`userid` bigint(10) NOT NULL DEFAULT '0',
`email` varchar(100) NOT NULL DEFAULT '',
`backpackurl` varchar(255) NOT NULL DEFAULT '',
`backpackuid` bigint(10) NOT NULL,
`autosync` tinyint(1) NOT NULL DEFAULT '0',
`password` varchar(50) DEFAULT NULL,
KEY `[[dbprefix]]badgback_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Defines settings for connecting external backpack' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]badge_criteria`
CREATE TABLE `[[dbprefix]]badge_criteria` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`badgeid` bigint(10) NOT NULL DEFAULT '0',
`criteriatype` bigint(10) DEFAULT NULL,
`method` tinyint(1) NOT NULL DEFAULT '1',
UNIQUE KEY `[[dbprefix]]badgcrit_badcri_uix` (`badgeid`,`criteriatype`),
KEY `[[dbprefix]]badgcrit_cri_ix` (`criteriatype`),
KEY `[[dbprefix]]badgcrit_bad_ix` (`badgeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Defines criteria for issuing badges' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]badge_criteria_met`
CREATE TABLE `[[dbprefix]]badge_criteria_met` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`issuedid` bigint(10) DEFAULT NULL,
`critid` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL,
`datemet` bigint(10) NOT NULL,
KEY `[[dbprefix]]badgcritmet_cri_ix` (`critid`),
KEY `[[dbprefix]]badgcritmet_use_ix` (`userid`),
KEY `[[dbprefix]]badgcritmet_iss_ix` (`issuedid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Defines criteria that were met for an issued badge' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]badge_criteria_param`
CREATE TABLE `[[dbprefix]]badge_criteria_param` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`critid` bigint(10) NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`value` varchar(255) DEFAULT NULL,
KEY `[[dbprefix]]badgcritpara_cri_ix` (`critid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Defines parameters for badges criteria' AUTO_INCREMENT=1 ;
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
