Skip to content

Instantly share code, notes, and snippets.

@FALL1N1
Last active Nov 14, 2019
Embed
What would you like to do?
This file has been truncated, but you can view the full file.
-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 02, 2019 at 04:15 PM
-- Server version: 10.3.18-MariaDB
-- PHP Version: 7.2.7
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;
--
-- Database: `ncc_moodle`
--
-- --------------------------------------------------------
--
-- Table structure for table `mdl_analytics_indicator_calc`
--
CREATE TABLE `mdl_analytics_indicator_calc` (
`id` bigint(10) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stored indicator calculations' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_analytics_models`
--
CREATE TABLE `mdl_analytics_models` (
`id` bigint(10) NOT NULL,
`enabled` tinyint(1) NOT NULL DEFAULT 0,
`trained` tinyint(1) NOT NULL DEFAULT 0,
`name` varchar(1333) DEFAULT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Analytic models.' ROW_FORMAT=COMPRESSED;
--
-- Dumping data for table `mdl_analytics_models`
--
INSERT INTO `mdl_analytics_models` (`id`, `enabled`, `trained`, `name`, `target`, `indicators`, `timesplitting`, `predictionsprocessor`, `version`, `timecreated`, `timemodified`, `usermodified`) VALUES
(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, 1570956275, 1570956275, 1570956275, 0),
(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, 1570956275, 1570956275, 1570956275, 0),
(3, 1, 1, NULL, '\\core_user\\analytics\\target\\upcoming_activities_due', '[\"\\\\core_course\\\\analytics\\\\indicator\\\\activities_due\"]', '\\core\\analytics\\time_splitting\\upcoming_week', NULL, 1570956275, 1570956275, 1570956275, 0);
-- --------------------------------------------------------
--
-- Table structure for table `mdl_analytics_models_log`
--
CREATE TABLE `mdl_analytics_models_log` (
`id` bigint(10) NOT NULL,
`modelid` bigint(10) NOT NULL,
`version` bigint(10) NOT NULL,
`evaluationmode` varchar(50) NOT NULL DEFAULT '',
`target` varchar(255) NOT NULL DEFAULT '',
`indicators` longtext NOT NULL,
`timesplitting` varchar(255) DEFAULT NULL,
`score` decimal(10,5) NOT NULL DEFAULT 0.00000,
`info` longtext DEFAULT NULL,
`dir` longtext NOT NULL,
`timecreated` bigint(10) NOT NULL,
`usermodified` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Analytic models changes during evaluation.' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_analytics_predictions`
--
CREATE TABLE `mdl_analytics_predictions` (
`id` bigint(10) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Predictions' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_analytics_prediction_actions`
--
CREATE TABLE `mdl_analytics_prediction_actions` (
`id` bigint(10) NOT NULL,
`predictionid` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL,
`actionname` varchar(255) NOT NULL DEFAULT '',
`timecreated` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Register of user actions over predictions.' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_analytics_predict_samples`
--
CREATE TABLE `mdl_analytics_predict_samples` (
`id` bigint(10) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Samples already used for predictions.' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_analytics_train_samples`
--
CREATE TABLE `mdl_analytics_train_samples` (
`id` bigint(10) NOT NULL,
`modelid` bigint(10) NOT NULL,
`analysableid` bigint(10) NOT NULL,
`timesplitting` varchar(255) NOT NULL DEFAULT '',
`sampleids` longtext NOT NULL,
`timecreated` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Samples used for training' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_analytics_used_analysables`
--
CREATE TABLE `mdl_analytics_used_analysables` (
`id` bigint(10) NOT NULL,
`modelid` bigint(10) NOT NULL,
`action` varchar(50) NOT NULL DEFAULT '',
`analysableid` bigint(10) NOT NULL,
`firstanalysis` bigint(10) NOT NULL,
`timeanalysed` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='List of analysables used by each model' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_analytics_used_files`
--
CREATE TABLE `mdl_analytics_used_files` (
`id` bigint(10) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Files that have already been used for training and predictio' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assign`
--
CREATE TABLE `mdl_assign` (
`id` bigint(10) NOT NULL,
`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,
`hidegrader` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='This table saves information about an instance of mod_assign' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignfeedback_comments`
--
CREATE TABLE `mdl_assignfeedback_comments` (
`id` bigint(10) NOT NULL,
`assignment` bigint(10) NOT NULL DEFAULT 0,
`grade` bigint(10) NOT NULL DEFAULT 0,
`commenttext` longtext DEFAULT NULL,
`commentformat` smallint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Text feedback for submitted assignments' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignfeedback_editpdf_annot`
--
CREATE TABLE `mdl_assignfeedback_editpdf_annot` (
`id` bigint(10) NOT NULL,
`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,
`path` longtext DEFAULT NULL,
`type` varchar(10) DEFAULT 'line',
`colour` varchar(10) DEFAULT 'black',
`draft` tinyint(2) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='stores annotations added to pdfs submitted by students' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignfeedback_editpdf_cmnt`
--
CREATE TABLE `mdl_assignfeedback_editpdf_cmnt` (
`id` bigint(10) NOT NULL,
`gradeid` bigint(10) NOT NULL DEFAULT 0,
`x` bigint(10) DEFAULT 0,
`y` bigint(10) DEFAULT 0,
`width` bigint(10) DEFAULT 120,
`rawtext` longtext DEFAULT NULL,
`pageno` bigint(10) NOT NULL DEFAULT 0,
`colour` varchar(10) DEFAULT 'black',
`draft` tinyint(2) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores comments added to pdfs' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignfeedback_editpdf_queue`
--
CREATE TABLE `mdl_assignfeedback_editpdf_queue` (
`id` bigint(10) NOT NULL,
`submissionid` bigint(10) NOT NULL,
`submissionattempt` bigint(10) NOT NULL,
`attemptedconversions` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Queue for processing.' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignfeedback_editpdf_quick`
--
CREATE TABLE `mdl_assignfeedback_editpdf_quick` (
`id` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL DEFAULT 0,
`rawtext` longtext NOT NULL,
`width` bigint(10) NOT NULL DEFAULT 120,
`colour` varchar(10) DEFAULT 'yellow'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores teacher specified quicklist comments' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignfeedback_editpdf_rot`
--
CREATE TABLE `mdl_assignfeedback_editpdf_rot` (
`id` bigint(10) NOT NULL,
`gradeid` bigint(10) NOT NULL DEFAULT 0,
`pageno` bigint(10) NOT NULL DEFAULT 0,
`pathnamehash` longtext NOT NULL,
`isrotated` tinyint(1) NOT NULL DEFAULT 0,
`degree` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores rotation information of a page.' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignfeedback_file`
--
CREATE TABLE `mdl_assignfeedback_file` (
`id` bigint(10) NOT NULL,
`assignment` bigint(10) NOT NULL DEFAULT 0,
`grade` bigint(10) NOT NULL DEFAULT 0,
`numfiles` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores info about the number of files submitted by a student' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignment`
--
CREATE TABLE `mdl_assignment` (
`id` bigint(10) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines assignments' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignment_submissions`
--
CREATE TABLE `mdl_assignment_submissions` (
`id` bigint(10) NOT NULL,
`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,
`data1` longtext DEFAULT NULL,
`data2` longtext DEFAULT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Info about submitted assignments' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignment_upgrade`
--
CREATE TABLE `mdl_assignment_upgrade` (
`id` bigint(10) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Info about upgraded assignments' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignsubmission_file`
--
CREATE TABLE `mdl_assignsubmission_file` (
`id` bigint(10) NOT NULL,
`assignment` bigint(10) NOT NULL DEFAULT 0,
`submission` bigint(10) NOT NULL DEFAULT 0,
`numfiles` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Info about file submissions for assignments' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assignsubmission_onlinetext`
--
CREATE TABLE `mdl_assignsubmission_onlinetext` (
`id` bigint(10) NOT NULL,
`assignment` bigint(10) NOT NULL DEFAULT 0,
`submission` bigint(10) NOT NULL DEFAULT 0,
`onlinetext` longtext DEFAULT NULL,
`onlineformat` smallint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Info about onlinetext submission' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assign_grades`
--
CREATE TABLE `mdl_assign_grades` (
`id` bigint(10) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Grading information about a single assignment submission.' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assign_overrides`
--
CREATE TABLE `mdl_assign_overrides` (
`id` bigint(10) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The overrides to assign settings.' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assign_plugin_config`
--
CREATE TABLE `mdl_assign_plugin_config` (
`id` bigint(10) NOT NULL,
`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 '',
`value` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Config data for an instance of a plugin in an assignment.' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assign_submission`
--
CREATE TABLE `mdl_assign_submission` (
`id` bigint(10) NOT NULL,
`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,
`latest` tinyint(2) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='This table keeps information about student interactions with' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assign_user_flags`
--
CREATE TABLE `mdl_assign_user_flags` (
`id` bigint(10) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='List of flags that can be set for a single user in a single ' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_assign_user_mapping`
--
CREATE TABLE `mdl_assign_user_mapping` (
`id` bigint(10) NOT NULL,
`assignment` bigint(10) NOT NULL DEFAULT 0,
`userid` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Map an assignment specific id number to a user' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_attendance`
--
CREATE TABLE `mdl_attendance` (
`id` bigint(10) NOT NULL,
`course` bigint(10) NOT NULL DEFAULT 0,
`name` varchar(255) DEFAULT NULL,
`grade` bigint(10) NOT NULL DEFAULT 100,
`timemodified` bigint(10) NOT NULL DEFAULT 0,
`intro` longtext DEFAULT NULL,
`introformat` smallint(4) NOT NULL DEFAULT 0,
`subnet` varchar(255) DEFAULT NULL,
`sessiondetailspos` varchar(5) NOT NULL DEFAULT 'left',
`showsessiondetails` tinyint(1) NOT NULL DEFAULT 1,
`showextrauserdetails` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Attendance module table' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_attendance_log`
--
CREATE TABLE `mdl_attendance_log` (
`id` bigint(10) NOT NULL,
`sessionid` bigint(10) NOT NULL DEFAULT 0,
`studentid` bigint(10) NOT NULL DEFAULT 0,
`statusid` bigint(10) NOT NULL DEFAULT 0,
`statusset` varchar(1333) DEFAULT NULL,
`timetaken` bigint(10) NOT NULL DEFAULT 0,
`takenby` bigint(10) NOT NULL DEFAULT 0,
`remarks` varchar(255) DEFAULT NULL,
`ipaddress` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='attendance_log table retrofitted from MySQL' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_attendance_sessions`
--
CREATE TABLE `mdl_attendance_sessions` (
`id` bigint(10) NOT NULL,
`attendanceid` bigint(10) NOT NULL DEFAULT 0,
`groupid` bigint(10) NOT NULL DEFAULT 0,
`sessdate` bigint(10) NOT NULL DEFAULT 0,
`duration` bigint(10) NOT NULL DEFAULT 0,
`lasttaken` bigint(10) DEFAULT NULL,
`lasttakenby` bigint(10) NOT NULL DEFAULT 0,
`timemodified` bigint(10) DEFAULT NULL,
`description` longtext NOT NULL,
`descriptionformat` tinyint(2) NOT NULL DEFAULT 0,
`studentscanmark` tinyint(1) NOT NULL DEFAULT 0,
`autoassignstatus` tinyint(1) NOT NULL DEFAULT 0,
`studentpassword` varchar(50) DEFAULT '',
`subnet` varchar(255) DEFAULT NULL,
`automark` tinyint(1) NOT NULL DEFAULT 0,
`automarkcompleted` tinyint(1) NOT NULL DEFAULT 0,
`statusset` mediumint(5) NOT NULL DEFAULT 0,
`absenteereport` tinyint(1) NOT NULL DEFAULT 1,
`preventsharedip` tinyint(1) NOT NULL DEFAULT 1,
`preventsharediptime` bigint(10) DEFAULT NULL,
`caleventid` bigint(10) NOT NULL DEFAULT 0,
`calendarevent` tinyint(1) NOT NULL DEFAULT 1,
`includeqrcode` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='attendance_sessions table' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_attendance_statuses`
--
CREATE TABLE `mdl_attendance_statuses` (
`id` bigint(10) NOT NULL,
`attendanceid` bigint(10) NOT NULL DEFAULT 0,
`acronym` varchar(2) NOT NULL DEFAULT '',
`description` varchar(30) NOT NULL DEFAULT '',
`grade` decimal(5,2) NOT NULL DEFAULT 0.00,
`studentavailability` bigint(10) DEFAULT NULL,
`setunmarked` tinyint(2) DEFAULT NULL,
`visible` tinyint(1) NOT NULL DEFAULT 1,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`setnumber` mediumint(5) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='attendance_statuses table retrofitted from MySQL' ROW_FORMAT=COMPRESSED;
--
-- Dumping data for table `mdl_attendance_statuses`
--
INSERT INTO `mdl_attendance_statuses` (`id`, `attendanceid`, `acronym`, `description`, `grade`, `studentavailability`, `setunmarked`, `visible`, `deleted`, `setnumber`) VALUES
(1, 0, 'P', 'Present', 2.00, NULL, NULL, 1, 0, 0),
(2, 0, 'A', 'Absent', 0.00, NULL, NULL, 1, 0, 0),
(3, 0, 'L', 'Late', 1.00, NULL, NULL, 1, 0, 0),
(4, 0, 'E', 'Excused', 1.00, NULL, NULL, 1, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `mdl_attendance_tempusers`
--
CREATE TABLE `mdl_attendance_tempusers` (
`id` bigint(10) NOT NULL,
`studentid` bigint(10) DEFAULT NULL,
`courseid` bigint(10) DEFAULT NULL,
`fullname` varchar(100) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`created` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores temporary users details' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_attendance_warning`
--
CREATE TABLE `mdl_attendance_warning` (
`id` bigint(10) NOT NULL,
`idnumber` bigint(10) NOT NULL,
`warningpercent` bigint(10) NOT NULL,
`warnafter` bigint(10) NOT NULL,
`maxwarn` bigint(10) NOT NULL,
`emailuser` smallint(4) NOT NULL,
`emailsubject` varchar(255) NOT NULL DEFAULT '',
`emailcontent` longtext NOT NULL,
`emailcontentformat` smallint(4) NOT NULL,
`thirdpartyemails` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Warning configuration' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_attendance_warning_done`
--
CREATE TABLE `mdl_attendance_warning_done` (
`id` bigint(10) NOT NULL,
`notifyid` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL,
`timesent` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Warnings processed' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_auth_oauth2_linked_login`
--
CREATE TABLE `mdl_auth_oauth2_linked_login` (
`id` bigint(10) NOT NULL,
`timecreated` bigint(10) NOT NULL,
`timemodified` bigint(10) NOT NULL,
`usermodified` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL,
`issuerid` bigint(10) NOT NULL,
`username` varchar(255) NOT NULL DEFAULT '',
`email` longtext NOT NULL,
`confirmtoken` varchar(64) NOT NULL DEFAULT '',
`confirmtokenexpires` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Accounts linked to a users Moodle account.' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_backup_controllers`
--
CREATE TABLE `mdl_backup_controllers` (
`id` bigint(10) NOT NULL,
`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,
`progress` decimal(15,14) NOT NULL DEFAULT 0.00000000000000,
`controller` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='To store the backup_controllers as they are used' ROW_FORMAT=COMPRESSED;
--
-- Dumping data for table `mdl_backup_controllers`
--
INSERT INTO `mdl_backup_controllers` (`id`, `backupid`, `operation`, `type`, `itemid`, `format`, `interactive`, `purpose`, `userid`, `status`, `execution`, `executiontime`, `checksum`, `timecreated`, `timemodified`, `progress`, `controller`) VALUES
(1, 'c454fa2e6e2c6096f80427e147f7d783', 'backup', 'course', 2, 'moodle2', 0, 50, 2, 1000, 1, 0, '14e7e07cedb5f8f8682e50abf5439802', 1571410550, 1571410552, 0.00000000000000, '');
-- --------------------------------------------------------
--
-- Table structure for table `mdl_backup_courses`
--
CREATE TABLE `mdl_backup_courses` (
`id` bigint(10) NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='To store every course backup status' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_backup_logs`
--
CREATE TABLE `mdl_backup_logs` (
`id` bigint(10) NOT NULL,
`backupid` varchar(32) NOT NULL DEFAULT '',
`loglevel` smallint(4) NOT NULL,
`message` longtext NOT NULL,
`timecreated` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='To store all the logs from backup and restore operations (by' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge`
--
CREATE TABLE `mdl_badge` (
`id` bigint(10) NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`description` longtext DEFAULT NULL,
`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,
`version` varchar(255) DEFAULT NULL,
`language` varchar(255) DEFAULT NULL,
`imageauthorname` varchar(255) DEFAULT NULL,
`imageauthoremail` varchar(255) DEFAULT NULL,
`imageauthorurl` varchar(255) DEFAULT NULL,
`imagecaption` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines badge' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_alignment`
--
CREATE TABLE `mdl_badge_alignment` (
`id` bigint(10) NOT NULL,
`badgeid` bigint(10) NOT NULL DEFAULT 0,
`targetname` varchar(255) NOT NULL DEFAULT '',
`targeturl` varchar(255) NOT NULL DEFAULT '',
`targetdescription` longtext DEFAULT NULL,
`targetframework` varchar(255) DEFAULT NULL,
`targetcode` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines alignment for badges' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_backpack`
--
CREATE TABLE `mdl_badge_backpack` (
`id` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL DEFAULT 0,
`email` varchar(100) NOT NULL DEFAULT '',
`backpackuid` bigint(10) NOT NULL,
`autosync` tinyint(1) NOT NULL DEFAULT 0,
`password` varchar(50) DEFAULT NULL,
`externalbackpackid` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines settings for connecting external backpack' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_criteria`
--
CREATE TABLE `mdl_badge_criteria` (
`id` bigint(10) NOT NULL,
`badgeid` bigint(10) NOT NULL DEFAULT 0,
`criteriatype` bigint(10) DEFAULT NULL,
`method` tinyint(1) NOT NULL DEFAULT 1,
`description` longtext DEFAULT NULL,
`descriptionformat` tinyint(2) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines criteria for issuing badges' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_criteria_met`
--
CREATE TABLE `mdl_badge_criteria_met` (
`id` bigint(10) NOT NULL,
`issuedid` bigint(10) DEFAULT NULL,
`critid` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL,
`datemet` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines criteria that were met for an issued badge' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_criteria_param`
--
CREATE TABLE `mdl_badge_criteria_param` (
`id` bigint(10) NOT NULL,
`critid` bigint(10) NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`value` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines parameters for badges criteria' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_endorsement`
--
CREATE TABLE `mdl_badge_endorsement` (
`id` bigint(10) NOT NULL,
`badgeid` bigint(10) NOT NULL DEFAULT 0,
`issuername` varchar(255) NOT NULL DEFAULT '',
`issuerurl` varchar(255) NOT NULL DEFAULT '',
`issueremail` varchar(255) NOT NULL DEFAULT '',
`claimid` varchar(255) DEFAULT NULL,
`claimcomment` longtext DEFAULT NULL,
`dateissued` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines endorsement for badge' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_external`
--
CREATE TABLE `mdl_badge_external` (
`id` bigint(10) NOT NULL,
`backpackid` bigint(10) NOT NULL,
`collectionid` bigint(10) NOT NULL,
`entityid` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Setting for external badges display' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_external_backpack`
--
CREATE TABLE `mdl_badge_external_backpack` (
`id` bigint(10) NOT NULL,
`backpackapiurl` varchar(255) NOT NULL DEFAULT '',
`backpackweburl` varchar(255) NOT NULL DEFAULT '',
`apiversion` varchar(12) NOT NULL DEFAULT '1.0',
`sortorder` bigint(10) NOT NULL DEFAULT 0,
`password` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines settings for site level backpacks that a user can co' ROW_FORMAT=COMPRESSED;
--
-- Dumping data for table `mdl_badge_external_backpack`
--
INSERT INTO `mdl_badge_external_backpack` (`id`, `backpackapiurl`, `backpackweburl`, `apiversion`, `sortorder`, `password`) VALUES
(1, 'https://backpack.openbadges.org', 'https://backpack.openbadges.org', '1', 0, ''),
(2, 'https://api.badgr.io/v2', 'https://badgr.io', '2', 1, '');
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_external_identifier`
--
CREATE TABLE `mdl_badge_external_identifier` (
`id` bigint(10) NOT NULL,
`sitebackpackid` bigint(10) NOT NULL,
`internalid` varchar(128) NOT NULL DEFAULT '',
`externalid` varchar(128) NOT NULL DEFAULT '',
`type` varchar(16) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Setting for external badges mappings' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_issued`
--
CREATE TABLE `mdl_badge_issued` (
`id` bigint(10) NOT NULL,
`badgeid` bigint(10) NOT NULL DEFAULT 0,
`userid` bigint(10) NOT NULL DEFAULT 0,
`uniquehash` longtext NOT NULL,
`dateissued` bigint(10) NOT NULL DEFAULT 0,
`dateexpire` bigint(10) DEFAULT NULL,
`visible` tinyint(1) NOT NULL DEFAULT 0,
`issuernotified` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines issued badges' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_manual_award`
--
CREATE TABLE `mdl_badge_manual_award` (
`id` bigint(10) NOT NULL,
`badgeid` bigint(10) NOT NULL,
`recipientid` bigint(10) NOT NULL,
`issuerid` bigint(10) NOT NULL,
`issuerrole` bigint(10) NOT NULL,
`datemet` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Track manual award criteria for badges' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_badge_related`
--
CREATE TABLE `mdl_badge_related` (
`id` bigint(10) NOT NULL,
`badgeid` bigint(10) NOT NULL DEFAULT 0,
`relatedbadgeid` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines badge related for badges' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_bigbluebuttonbn`
--
CREATE TABLE `mdl_bigbluebuttonbn` (
`id` bigint(10) NOT NULL,
`type` tinyint(2) NOT NULL DEFAULT 0,
`course` bigint(10) NOT NULL DEFAULT 0,
`name` varchar(255) NOT NULL DEFAULT '',
`intro` longtext DEFAULT NULL,
`introformat` smallint(4) NOT NULL DEFAULT 1,
`meetingid` varchar(255) NOT NULL DEFAULT '',
`moderatorpass` varchar(255) NOT NULL DEFAULT '',
`viewerpass` varchar(255) NOT NULL DEFAULT '',
`wait` tinyint(1) NOT NULL DEFAULT 0,
`record` tinyint(1) NOT NULL DEFAULT 0,
`recordallfromstart` tinyint(1) NOT NULL DEFAULT 0,
`recordhidebutton` tinyint(1) NOT NULL DEFAULT 0,
`welcome` longtext DEFAULT NULL,
`voicebridge` mediumint(5) NOT NULL DEFAULT 0,
`openingtime` bigint(10) NOT NULL DEFAULT 0,
`closingtime` bigint(10) NOT NULL DEFAULT 0,
`timecreated` bigint(10) NOT NULL DEFAULT 0,
`timemodified` bigint(10) NOT NULL DEFAULT 0,
`presentation` longtext DEFAULT NULL,
`participants` longtext DEFAULT NULL,
`userlimit` smallint(3) NOT NULL DEFAULT 0,
`recordings_html` tinyint(1) NOT NULL DEFAULT 0,
`recordings_deleted` tinyint(1) NOT NULL DEFAULT 1,
`recordings_imported` tinyint(1) NOT NULL DEFAULT 0,
`recordings_preview` tinyint(1) NOT NULL DEFAULT 0,
`clienttype` tinyint(1) NOT NULL DEFAULT 0,
`muteonstart` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The bigbluebuttonbn table to store information about a meeti' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_bigbluebuttonbn_logs`
--
CREATE TABLE `mdl_bigbluebuttonbn_logs` (
`id` bigint(10) NOT NULL,
`courseid` bigint(10) NOT NULL,
`bigbluebuttonbnid` bigint(10) NOT NULL,
`userid` bigint(10) DEFAULT NULL,
`timecreated` bigint(10) NOT NULL DEFAULT 0,
`meetingid` varchar(256) NOT NULL DEFAULT '',
`log` varchar(32) NOT NULL DEFAULT '',
`meta` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The bigbluebuttonbn table to store meeting activity events' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_block`
--
CREATE TABLE `mdl_block` (
`id` bigint(10) NOT NULL,
`name` varchar(40) NOT NULL DEFAULT '',
`cron` bigint(10) NOT NULL DEFAULT 0,
`lastcron` bigint(10) NOT NULL DEFAULT 0,
`visible` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='contains all installed blocks' ROW_FORMAT=COMPRESSED;
--
-- Dumping data for table `mdl_block`
--
INSERT INTO `mdl_block` (`id`, `name`, `cron`, `lastcron`, `visible`) VALUES
(1, 'activity_modules', 0, 0, 1),
(2, 'activity_results', 0, 0, 1),
(3, 'admin_bookmarks', 0, 0, 1),
(4, 'badges', 0, 0, 1),
(5, 'blog_menu', 0, 0, 1),
(6, 'blog_recent', 0, 0, 1),
(7, 'blog_tags', 0, 0, 1),
(8, 'calendar_month', 0, 0, 1),
(9, 'calendar_upcoming', 0, 0, 1),
(10, 'comments', 0, 0, 1),
(11, 'community', 0, 0, 1),
(12, 'completionstatus', 0, 0, 1),
(13, 'course_list', 0, 0, 1),
(14, 'course_summary', 0, 0, 1),
(15, 'feedback', 0, 0, 1),
(16, 'globalsearch', 0, 0, 1),
(17, 'glossary_random', 0, 0, 1),
(18, 'html', 0, 0, 1),
(19, 'login', 0, 0, 1),
(20, 'lp', 0, 0, 1),
(21, 'mentees', 0, 0, 1),
(22, 'mnet_hosts', 0, 0, 1),
(23, 'myoverview', 0, 0, 1),
(24, 'myprofile', 0, 0, 1),
(25, 'navigation', 0, 0, 1),
(26, 'news_items', 0, 0, 1),
(27, 'online_users', 0, 0, 1),
(28, 'participants', 0, 0, 1),
(29, 'private_files', 0, 0, 1),
(30, 'quiz_results', 0, 0, 0),
(31, 'recent_activity', 0, 0, 1),
(32, 'recentlyaccessedcourses', 0, 0, 1),
(33, 'recentlyaccesseditems', 0, 0, 1),
(34, 'rss_client', 0, 0, 1),
(35, 'search_forums', 0, 0, 1),
(36, 'section_links', 0, 0, 1),
(37, 'selfcompletion', 0, 0, 1),
(38, 'settings', 0, 0, 1),
(39, 'site_main_menu', 0, 0, 1),
(40, 'social_activities', 0, 0, 1),
(41, 'starredcourses', 0, 0, 1),
(42, 'tag_flickr', 0, 0, 1),
(43, 'tag_youtube', 0, 0, 0),
(44, 'tags', 0, 0, 1),
(45, 'timeline', 0, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `mdl_block_community`
--
CREATE TABLE `mdl_block_community` (
`id` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL,
`coursename` varchar(255) NOT NULL DEFAULT '',
`coursedescription` longtext DEFAULT NULL,
`courseurl` varchar(255) NOT NULL DEFAULT '',
`imageurl` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Community block' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_block_instances`
--
CREATE TABLE `mdl_block_instances` (
`id` bigint(10) NOT NULL,
`blockname` varchar(40) NOT NULL DEFAULT '',
`parentcontextid` bigint(10) NOT NULL,
`showinsubcontexts` smallint(4) NOT NULL,
`requiredbytheme` smallint(4) NOT NULL DEFAULT 0,
`pagetypepattern` varchar(64) NOT NULL DEFAULT '',
`subpagepattern` varchar(16) DEFAULT NULL,
`defaultregion` varchar(16) NOT NULL DEFAULT '',
`defaultweight` bigint(10) NOT NULL,
`configdata` longtext DEFAULT NULL,
`timecreated` bigint(10) NOT NULL,
`timemodified` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='This table stores block instances. The type of block this is' ROW_FORMAT=COMPRESSED;
--
-- Dumping data for table `mdl_block_instances`
--
INSERT INTO `mdl_block_instances` (`id`, `blockname`, `parentcontextid`, `showinsubcontexts`, `requiredbytheme`, `pagetypepattern`, `subpagepattern`, `defaultregion`, `defaultweight`, `configdata`, `timecreated`, `timemodified`) VALUES
(1, 'admin_bookmarks', 1, 0, 0, 'admin-*', NULL, 'side-pre', 2, '', 1570956287, 1570956287),
(2, 'timeline', 1, 0, 0, 'my-index', '2', 'side-post', 0, '', 1570956287, 1570956287),
(3, 'private_files', 1, 0, 0, 'my-index', '2', 'side-post', 1, '', 1570956287, 1570956287),
(4, 'online_users', 1, 0, 0, 'my-index', '2', 'side-post', 2, '', 1570956287, 1570956287),
(5, 'badges', 1, 0, 0, 'my-index', '2', 'side-post', 3, '', 1570956287, 1570956287),
(6, 'calendar_month', 1, 0, 0, 'my-index', '2', 'side-post', 4, '', 1570956287, 1570956287),
(7, 'calendar_upcoming', 1, 0, 0, 'my-index', '2', 'side-post', 5, '', 1570956287, 1570956287),
(8, 'lp', 1, 0, 0, 'my-index', '2', 'content', 0, '', 1570956287, 1570956287),
(9, 'recentlyaccessedcourses', 1, 0, 0, 'my-index', '2', 'content', 1, '', 1570956287, 1570956287),
(10, 'myoverview', 1, 0, 0, 'my-index', '2', 'content', 2, '', 1570956287, 1570956287),
(11, 'timeline', 5, 0, 0, 'my-index', '3', 'side-post', 0, '', 1570956620, 1570956620),
(12, 'private_files', 5, 0, 0, 'my-index', '3', 'side-post', 1, '', 1570956620, 1570956620),
(13, 'online_users', 5, 0, 0, 'my-index', '3', 'side-post', 2, '', 1570956620, 1570956620),
(14, 'badges', 5, 0, 0, 'my-index', '3', 'side-post', 3, '', 1570956620, 1570956620),
(15, 'calendar_month', 5, 0, 0, 'my-index', '3', 'side-post', 4, '', 1570956620, 1570956620),
(16, 'calendar_upcoming', 5, 0, 0, 'my-index', '3', 'side-post', 5, '', 1570956620, 1570956620),
(17, 'lp', 5, 0, 0, 'my-index', '3', 'content', 0, '', 1570956620, 1570956620),
(18, 'recentlyaccessedcourses', 5, 0, 0, 'my-index', '3', 'content', 1, '', 1570956620, 1570956620),
(19, 'myoverview', 5, 0, 0, 'my-index', '3', 'content', 2, '', 1570956620, 1570956620),
(20, 'navigation', 1, 1, 1, '*', NULL, 'side-pre', 0, '', 1571379785, 1571379785),
(21, 'settings', 1, 1, 1, '*', NULL, 'side-pre', 0, '', 1571379785, 1571379785);
-- --------------------------------------------------------
--
-- Table structure for table `mdl_block_positions`
--
CREATE TABLE `mdl_block_positions` (
`id` bigint(10) NOT NULL,
`blockinstanceid` bigint(10) NOT NULL,
`contextid` bigint(10) NOT NULL,
`pagetype` varchar(64) NOT NULL DEFAULT '',
`subpage` varchar(16) NOT NULL DEFAULT '',
`visible` smallint(4) NOT NULL,
`region` varchar(16) NOT NULL DEFAULT '',
`weight` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Stores the position of a sticky block_instance on a another ' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_block_recentlyaccesseditems`
--
CREATE TABLE `mdl_block_recentlyaccesseditems` (
`id` bigint(10) NOT NULL,
`courseid` bigint(10) NOT NULL,
`cmid` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL,
`timeaccess` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Most recently accessed items accessed by a user' ROW_FORMAT=COMPRESSED;
--
-- Dumping data for table `mdl_block_recentlyaccesseditems`
--
INSERT INTO `mdl_block_recentlyaccesseditems` (`id`, `courseid`, `cmid`, `userid`, `timeaccess`) VALUES
(6, 3, 8, 2, 1572277233),
(7, 3, 10, 2, 1572417375),
(8, 3, 14, 2, 1572417834),
(9, 3, 59, 2, 1572428195),
(10, 3, 9, 2, 1572456327),
(11, 3, 11, 2, 1572460617),
(12, 3, 22, 2, 1572461570),
(13, 3, 23, 2, 1572461644),
(14, 3, 26, 2, 1572461728);
-- --------------------------------------------------------
--
-- Table structure for table `mdl_block_recent_activity`
--
CREATE TABLE `mdl_block_recent_activity` (
`id` bigint(10) NOT NULL,
`courseid` bigint(10) NOT NULL,
`cmid` bigint(10) NOT NULL,
`timecreated` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL,
`action` tinyint(1) NOT NULL,
`modname` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Recent activity block' ROW_FORMAT=COMPRESSED;
--
-- Dumping data for table `mdl_block_recent_activity`
--
INSERT INTO `mdl_block_recent_activity` (`id`, `courseid`, `cmid`, `timecreated`, `userid`, `action`, `modname`) VALUES
(1, 3, 3, 1572084944, 2, 0, NULL),
(2, 3, 4, 1572093831, 2, 0, NULL),
(3, 3, 5, 1572093832, 2, 0, NULL),
(4, 3, 6, 1572095487, 2, 0, NULL),
(5, 3, 7, 1572109675, 2, 0, NULL),
(6, 3, 8, 1572277232, 2, 0, NULL),
(7, 3, 9, 1572417130, 2, 0, NULL),
(8, 3, 10, 1572417318, 2, 0, NULL),
(9, 3, 10, 1572417367, 2, 1, NULL),
(10, 3, 11, 1572417486, 2, 0, NULL),
(11, 3, 12, 1572417607, 2, 0, NULL),
(12, 3, 13, 1572417726, 2, 0, NULL),
(13, 3, 13, 1572417749, 2, 1, NULL),
(14, 3, 14, 1572417823, 2, 0, NULL),
(15, 3, 15, 1572418152, 2, 0, NULL),
(16, 3, 16, 1572418252, 2, 0, NULL),
(17, 3, 17, 1572418817, 2, 0, NULL),
(18, 3, 18, 1572418934, 2, 0, NULL),
(19, 3, 19, 1572418994, 2, 0, NULL),
(20, 3, 20, 1572419047, 2, 0, NULL),
(21, 3, 21, 1572419104, 2, 0, NULL),
(22, 3, 22, 1572419569, 2, 0, NULL),
(23, 3, 22, 1572419625, 2, 1, NULL),
(24, 3, 23, 1572419703, 2, 0, NULL),
(25, 3, 24, 1572419972, 2, 0, NULL),
(26, 3, 25, 1572420211, 2, 0, NULL),
(27, 3, 26, 1572420293, 2, 0, NULL),
(28, 3, 27, 1572420356, 2, 0, NULL),
(29, 3, 28, 1572420409, 2, 0, NULL),
(30, 3, 29, 1572420478, 2, 0, NULL),
(31, 3, 30, 1572420625, 2, 0, NULL),
(32, 3, 31, 1572420728, 2, 0, NULL),
(33, 3, 32, 1572420900, 2, 0, NULL),
(34, 3, 33, 1572420997, 2, 0, NULL),
(35, 3, 34, 1572421148, 2, 0, NULL),
(36, 3, 35, 1572421284, 2, 0, NULL),
(37, 3, 36, 1572421452, 2, 0, NULL),
(38, 3, 37, 1572421532, 2, 0, NULL),
(39, 3, 38, 1572421595, 2, 0, NULL),
(40, 3, 39, 1572421703, 2, 0, NULL),
(41, 3, 40, 1572421775, 2, 0, NULL),
(42, 3, 41, 1572421919, 2, 0, NULL),
(43, 3, 42, 1572421989, 2, 0, NULL),
(44, 3, 43, 1572422126, 2, 0, NULL),
(45, 3, 44, 1572422183, 2, 0, NULL),
(46, 3, 45, 1572422245, 2, 0, NULL),
(47, 3, 46, 1572422293, 2, 0, NULL),
(48, 3, 47, 1572422355, 2, 0, NULL),
(49, 3, 48, 1572422423, 2, 0, NULL),
(50, 3, 49, 1572422490, 2, 0, NULL),
(51, 3, 50, 1572422582, 2, 0, NULL),
(52, 3, 51, 1572422644, 2, 0, NULL),
(53, 3, 52, 1572422910, 2, 0, NULL),
(54, 3, 53, 1572424075, 2, 0, NULL),
(55, 3, 54, 1572424120, 2, 0, NULL),
(56, 3, 55, 1572424167, 2, 0, NULL),
(57, 3, 56, 1572424325, 2, 0, NULL),
(58, 3, 57, 1572424380, 2, 0, NULL),
(59, 3, 58, 1572424438, 2, 0, NULL),
(60, 3, 59, 1572424485, 2, 0, NULL),
(61, 3, 60, 1572424649, 2, 0, NULL),
(62, 3, 61, 1572424837, 2, 0, NULL),
(63, 3, 62, 1572424917, 2, 0, NULL),
(64, 3, 63, 1572425007, 2, 0, NULL),
(65, 3, 64, 1572425189, 2, 0, NULL),
(66, 3, 65, 1572425244, 2, 0, NULL),
(67, 3, 66, 1572425301, 2, 0, NULL),
(68, 3, 67, 1572425389, 2, 0, NULL),
(69, 3, 68, 1572425458, 2, 0, NULL),
(70, 3, 69, 1572425504, 2, 0, NULL),
(71, 3, 70, 1572425560, 2, 0, NULL),
(72, 3, 71, 1572425625, 2, 0, NULL),
(73, 3, 72, 1572425671, 2, 0, NULL),
(74, 3, 73, 1572425721, 2, 0, NULL),
(75, 3, 74, 1572425768, 2, 0, NULL),
(76, 3, 75, 1572425824, 2, 0, NULL),
(77, 3, 76, 1572425869, 2, 0, NULL),
(78, 3, 77, 1572425948, 2, 0, NULL),
(79, 3, 78, 1572426037, 2, 0, NULL),
(80, 3, 79, 1572426105, 2, 0, NULL),
(81, 3, 80, 1572426168, 2, 0, NULL),
(82, 3, 81, 1572426244, 2, 0, NULL),
(83, 3, 82, 1572426305, 2, 0, NULL),
(84, 3, 83, 1572426361, 2, 0, NULL),
(85, 3, 84, 1572426408, 2, 0, NULL),
(86, 3, 85, 1572426456, 2, 0, NULL),
(87, 3, 86, 1572426520, 2, 0, NULL),
(88, 3, 87, 1572426596, 2, 0, NULL),
(89, 3, 88, 1572426638, 2, 0, NULL),
(90, 3, 89, 1572426681, 2, 0, NULL),
(91, 3, 90, 1572426732, 2, 0, NULL),
(92, 3, 91, 1572426795, 2, 0, NULL),
(93, 3, 92, 1572426939, 2, 0, NULL),
(94, 3, 93, 1572426992, 2, 0, NULL),
(95, 3, 94, 1572427080, 2, 0, NULL),
(96, 3, 95, 1572427134, 2, 0, NULL),
(97, 3, 96, 1572427190, 2, 0, NULL),
(98, 3, 97, 1572427241, 2, 0, NULL),
(99, 3, 98, 1572427279, 2, 0, NULL),
(100, 3, 99, 1572427334, 2, 0, NULL),
(101, 3, 100, 1572427384, 2, 0, NULL),
(102, 3, 101, 1572427445, 2, 0, NULL),
(103, 3, 102, 1572427504, 2, 0, NULL),
(104, 3, 103, 1572427567, 2, 0, NULL),
(105, 3, 104, 1572427628, 2, 0, NULL),
(106, 3, 105, 1572427679, 2, 0, NULL),
(107, 3, 106, 1572427728, 2, 0, NULL),
(108, 3, 107, 1572427789, 2, 0, NULL),
(109, 3, 108, 1572427854, 2, 0, NULL),
(110, 3, 109, 1572427924, 2, 0, NULL),
(111, 3, 110, 1572428038, 2, 0, NULL),
(112, 3, 111, 1572428096, 2, 0, NULL),
(113, 3, 112, 1572428172, 2, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `mdl_block_rss_client`
--
CREATE TABLE `mdl_block_rss_client` (
`id` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL DEFAULT 0,
`title` longtext NOT NULL,
`preferredtitle` varchar(64) NOT NULL DEFAULT '',
`description` longtext NOT NULL,
`shared` tinyint(2) NOT NULL DEFAULT 0,
`url` varchar(255) NOT NULL DEFAULT '',
`skiptime` bigint(10) NOT NULL DEFAULT 0,
`skipuntil` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Remote news feed information. Contains the news feed id, the' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_blog_association`
--
CREATE TABLE `mdl_blog_association` (
`id` bigint(10) NOT NULL,
`contextid` bigint(10) NOT NULL,
`blogid` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Associations of blog entries with courses and module instanc' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_blog_external`
--
CREATE TABLE `mdl_blog_external` (
`id` bigint(10) NOT NULL,
`userid` bigint(10) NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`description` longtext DEFAULT NULL,
`url` longtext NOT NULL,
`filtertags` varchar(255) DEFAULT NULL,
`failedlastsync` tinyint(1) NOT NULL DEFAULT 0,
`timemodified` bigint(10) DEFAULT NULL,
`timefetched` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='External blog links used for RSS copying of blog entries to ' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_book`
--
CREATE TABLE `mdl_book` (
`id` bigint(10) NOT NULL,
`course` bigint(10) NOT NULL DEFAULT 0,
`name` varchar(255) NOT NULL DEFAULT '',
`intro` longtext DEFAULT NULL,
`introformat` smallint(4) NOT NULL DEFAULT 0,
`numbering` smallint(4) NOT NULL DEFAULT 0,
`navstyle` smallint(4) NOT NULL DEFAULT 1,
`customtitles` tinyint(2) NOT NULL DEFAULT 0,
`revision` bigint(10) NOT NULL DEFAULT 0,
`timecreated` bigint(10) NOT NULL DEFAULT 0,
`timemodified` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines book' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_book_chapters`
--
CREATE TABLE `mdl_book_chapters` (
`id` bigint(10) NOT NULL,
`bookid` bigint(10) NOT NULL DEFAULT 0,
`pagenum` bigint(10) NOT NULL DEFAULT 0,
`subchapter` bigint(10) NOT NULL DEFAULT 0,
`title` varchar(255) NOT NULL DEFAULT '',
`content` longtext NOT NULL,
`contentformat` smallint(4) NOT NULL DEFAULT 0,
`hidden` tinyint(2) NOT NULL DEFAULT 0,
`timecreated` bigint(10) NOT NULL DEFAULT 0,
`timemodified` bigint(10) NOT NULL DEFAULT 0,
`importsrc` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Defines book_chapters' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_cache_filters`
--
CREATE TABLE `mdl_cache_filters` (
`id` bigint(10) NOT NULL,
`filter` varchar(32) NOT NULL DEFAULT '',
`version` bigint(10) NOT NULL DEFAULT 0,
`md5key` varchar(32) NOT NULL DEFAULT '',
`rawtext` longtext NOT NULL,
`timemodified` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='For keeping information about cached data' ROW_FORMAT=COMPRESSED;
-- --------------------------------------------------------
--
-- Table structure for table `mdl_cache_flags`
--
CREATE TABLE `mdl_cache_flags` (
`id` bigint(10) NOT NULL,
`flagtype` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`timemodified` bigint(10) NOT NULL DEFAULT 0,
`value` longtext NOT NULL,
`expiry` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Cache of time-sensitive flags' ROW_FORMAT=COMPRESSED;
--
-- Dumping data for table `mdl_cache_flags`
--
INSERT INTO `mdl_cache_flags` (`id`, `flagtype`, `name`, `timemodified`, `value`, `expiry`) VALUES
(1, 'userpreferenceschanged', '2', 1572704344, '1', 1572711544),
(2, 'accesslib/dirtycontexts', '/1/29', 1570973954, '1', 1570981154),
(3, 'accesslib/dirtycontexts', '/1/26/35', 1571410553, '1', 1571417753);
-- --------------------------------------------------------
--
-- Table structure for table `mdl_capabilities`
--
CREATE TABLE `mdl_capabilities` (
`id` bigint(10) NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`captype` varchar(50) NOT NULL DEFAULT '',
`contextlevel` bigint(10) NOT NULL DEFAULT 0,
`component` varchar(100) NOT NULL DEFAULT '',
`riskbitmask` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='this defines all capabilities' ROW_FORMAT=COMPRESSED;
--
-- Dumping data for table `mdl_capabilities`
--
INSERT INTO `mdl_capabilities` (`id`, `name`, `captype`, `contextlevel`, `component`, `riskbitmask`) VALUES
(1, 'moodle/site:config', 'write', 10, 'moodle', 62),
(2, 'moodle/site:configview', 'read', 10, 'moodle', 0),
(3, 'moodle/site:readallmessages', 'read', 10, 'moodle', 8),
(4, 'moodle/site:manageallmessaging', 'write', 10, 'moodle', 8),
(5, 'moodle/site:deleteanymessage', 'write', 10, 'moodle', 32),
(6, 'moodle/site:sendmessage', 'write', 10, 'moodle', 16),
(7, 'moodle/site:deleteownmessage', 'write', 10, 'moodle', 0),
(8, 'moodle/site:approvecourse', 'write', 10, 'moodle', 4),
(9, 'moodle/backup:backupcourse', 'write', 50, 'moodle', 28),
(10, 'moodle/backup:backupsection', 'write', 50, 'moodle', 28),
(11, 'moodle/backup:backupactivity', 'write', 70, 'moodle', 28),
(12, 'moodle/backup:backuptargetimport', 'write', 50, 'moodle', 28),
(13, 'moodle/backup:downloadfile', 'write', 50, 'moodle', 28),
(14, 'moodle/backup:configure', 'write', 50, 'moodle', 28),
(15, 'moodle/backup:userinfo', 'read', 50, 'moodle', 8),
(16, 'moodle/backup:anonymise', 'read', 50, 'moodle', 8),
(17, 'moodle/restore:restorecourse', 'write', 50, 'moodle', 28),
(18, 'moodle/restore:restoresection', 'write', 50, 'moodle', 28),
(19, 'moodle/restore:restoreactivity', 'write', 50, 'moodle', 28),
(20, 'moodle/restore:viewautomatedfilearea', 'write', 50, 'moodle', 28),
(21, 'moodle/restore:restoretargetimport', 'write', 50, 'moodle', 28),
(22, 'moodle/restore:uploadfile', 'write', 50, 'moodle', 28),
(23, 'moodle/restore:configure', 'write', 50, 'moodle', 28),
(24, 'moodle/restore:rolldates', 'write', 50, 'moodle', 0),
(25, 'moodle/restore:userinfo', 'write', 50, 'moodle', 30),
(26, 'moodle/restore:createuser', 'write', 10, 'moodle', 24),
(27, 'moodle/site:manageblocks', 'write', 80, 'moodle', 20),
(28, 'moodle/site:accessallgroups', 'read', 70, 'moodle', 0),
(29, 'moodle/site:viewfullnames', 'read', 70, 'moodle', 0),
(30, 'moodle/site:viewuseridentity', 'read', 70, 'moodle', 0),
(31, 'moodle/site:viewreports', 'read', 50, 'moodle', 8),
(32, 'moodle/site:trustcontent', 'write', 70, 'moodle', 4),
(33, 'moodle/site:uploadusers', 'write', 10, 'moodle', 24),
(34, 'moodle/filter:manage', 'write', 50, 'moodle', 0),
(35, 'moodle/user:create', 'write', 10, 'moodle', 24),
(36, 'moodle/user:delete', 'write', 10, 'moodle', 40),
(37, 'moodle/user:update', 'write', 10, 'moodle', 24),
(38, 'moodle/user:viewdetails', 'read', 50, 'moodle', 0),
(39, 'moodle/user:viewalldetails', 'read', 30, 'moodle', 8),
(40, 'moodle/user:viewlastip', 'read', 30, 'moodle', 8),
(41, 'moodle/user:viewhiddendetails', 'read', 50, 'moodle', 8),
(42, 'moodle/user:loginas', 'write', 50, 'moodle', 30),
(43, 'moodle/user:managesyspages', 'write', 10, 'moodle', 0),
(44, 'moodle/user:manageblocks', 'write', 30, 'moodle', 0),
(45, 'moodle/user:manageownblocks', 'write', 10, 'moodle', 0),
(46, 'moodle/user:manageownfiles', 'write', 10, 'moodle', 0),
(47, 'moodle/user:ignoreuserquota', 'write', 10, 'moodle', 0),
(48, 'moodle/my:configsyspages', 'write', 10, 'moodle', 0),
(49, 'moodle/role:assign', 'write', 50, 'moodle', 28),
(50, 'moodle/role:review', 'read', 50, 'moodle', 8),
(51, 'moodle/role:override', 'write', 50, 'moodle', 28),
(52, 'moodle/role:safeoverride', 'write', 50, 'moodle', 16),
(53, 'moodle/role:manage', 'write', 10, 'moodle', 28),
(54, 'moodle/role:switchroles', 'read', 50, 'moodle', 12),
(55, 'moodle/category:manage', 'write', 40, 'moodle', 4),
(56, 'moodle/category:viewcourselist', 'read', 40, 'moodle', 0),
(57, 'moodle/category:viewhiddencategories', 'read', 40, 'moodle', 0),
(58, 'moodle/cohort:manage', 'write', 40, 'moodle', 0),
(59, 'moodle/cohort:assign', 'write', 40, 'moodle', 0),
(60, 'moodle/cohort:view', 'read', 50, 'moodle', 0),
(61, 'moodle/course:create', 'write', 40, 'moodle', 4),
(62, 'moodle/course:creategroupconversations', 'write', 50, 'moodle', 4),
(63, 'moodle/course:request', 'write', 10, 'moodle', 0),
(64, 'moodle/course:delete', 'write', 50, 'moodle', 32),
(65, 'moodle/course:update', 'write', 50, 'moodle', 4),
(66, 'moodle/course:view', 'read', 50, 'moodle', 0),
(67, 'moodle/course:enrolreview', 'read', 50, 'moodle', 8),
(68, 'moodle/course:enrolconfig', 'write', 50, 'moodle', 8),
(69, 'moodle/course:reviewotherusers', 'read', 50, 'moodle', 0),
(70, 'moodle/course:bulkmessaging', 'write', 50, 'moodle', 16),
(71, 'moodle/course:viewhiddenuserfields', 'read', 50, 'moodle', 8),
(72, 'moodle/course:viewhiddencourses', 'read', 50, 'moodle', 0),
(73, 'moodle/course:visibility', 'write', 50, 'moodle', 0),
(74, 'moodle/course:managefiles', 'write', 50, 'moodle', 4),
(75, 'moodle/course:ignoreavailabilityrestrictions', 'read', 70, 'moodle', 0),
(76, 'moodle/course:ignorefilesizelimits', 'write', 50, 'moodle', 0),
(77, 'moodle/course:manageactivities', 'write', 70, 'moodle', 4),
(78, 'moodle/course:activityvisibility', 'write', 70, 'moodle', 0),
(79, 'moodle/course:viewhiddenactivities', 'write', 70, 'moodle', 0),
(80, 'moodle/course:viewparticipants', 'read', 50, 'moodle', 0),
(81, 'moodle/course:changefullname', 'write', 50, 'moodle', 4),
(82, 'moodle/course:changeshortname', 'write', 50, 'moodle', 4),
(83, 'moodle/course:changelockedcustomfields', 'write', 50, 'moodle', 16),
(84, 'moodle/course:configurecustomfields', 'write', 10, 'moodle', 16),
(85, 'moodle/course:renameroles', 'write', 50, 'moodle', 0),
(86, 'moodle/course:changeidnumber', 'write', 50, 'moodle', 4),
(87, 'moodle/course:changecategory', 'write', 50, 'moodle', 4),
(88, 'moodle/course:changesummary', 'write', 50, 'moodle', 4),
(89, 'moodle/course:setforcedlanguage', 'write', 50, 'moodle', 0),
(90, 'moodle/site:viewparticipants', 'read', 10, 'moodle', 0),
(91, 'moodle/course:isincompletionreports', 'read', 50, 'moodle', 0),
(92, 'moodle/course:viewscales', 'read', 50, 'moodle', 0),
(93, 'moodle/course:managescales', 'write', 50, 'moodle', 0),
(94, 'moodle/course:managegroups', 'write', 50, 'moodle', 4),
(95, 'moodle/course:reset', 'write', 50, 'moodle', 32),
(96, 'moodle/course:viewsuspendedusers', 'read', 10, 'moodle', 0),
(97, 'moodle/course:tag', 'write', 50, 'moodle', 16),
(98, 'moodle/blog:view', 'read', 10, 'moodle', 0),
(99, 'moodle/blog:search', 'read', 10, 'moodle', 0),
(100, 'moodle/blog:viewdrafts', 'read', 10, 'moodle', 8),
(101, 'moodle/blog:create', 'write', 10, 'moodle', 16),
(102, 'moodle/blog:manageentries', 'write', 10, 'moodle', 16),
(103, 'moodle/blog:manageexternal', 'write', 10, 'moodle', 16),
(104, 'moodle/calendar:manageownentries', 'write', 50, 'moodle', 16),
(105, 'moodle/calendar:managegroupentries', 'write', 50, 'moodle', 16),
(106, 'moodle/calendar:manageentries', 'write', 50, 'moodle', 16),
(107, 'moodle/user:editprofile', 'write', 30, 'moodle', 24),
(108, 'moodle/user:editownprofile', 'write', 10, 'moodle', 16),
(109, 'moodle/user:changeownpassword', 'write', 10, 'moodle', 0),
(110, 'moodle/user:readuserposts', 'read', 30, 'moodle', 0),
(111, 'moodle/user:readuserblogs', 'read', 30, 'moodle', 0),
(112, 'moodle/user:viewuseractivitiesreport', 'read', 30, 'moodle', 8),
(113, 'moodle/user:editmessageprofile', 'write', 30, 'moodle', 16),
(114, 'moodle/user:editownmessageprofile', 'write', 10, 'moodle', 0),
(115, 'moodle/question:managecategory', 'write', 50, 'moodle', 20),
(116, 'moodle/question:add', 'write', 50, 'moodle', 20),
(117, 'moodle/question:editmine', 'write', 50, 'moodle', 20),
(118, 'moodle/question:editall', 'write', 50, 'moodle', 20),
(119, 'moodle/question:viewmine', 'read', 50, 'moodle', 0),
(120, 'moodle/question:viewall', 'read', 50, 'moodle', 0),
(121, 'moodle/question:usemine', 'read', 50, 'moodle', 0),
(122, 'moodle/question:useall', 'read', 50, 'moodle', 0),
(123, 'moodle/question:movemine', 'write', 50, 'moodle', 0),
(124, 'moodle/question:moveall', 'write', 50, 'moodle', 0),
(125, 'moodle/question:config', 'write', 10, 'moodle', 2),
(126, 'moodle/question:flag', 'write', 50, 'moodle', 0),
(127, 'moodle/question:tagmine', 'write', 50, 'moodle', 0),
(128, 'moodle/question:tagall', 'write', 50, 'moodle', 0),
(129, 'moodle/site:doclinks', 'read', 10, 'moodle', 0),
(130, 'moodle/course:sectionvisibility', 'write', 50, 'moodle', 0),
(131, 'moodle/course:useremail', 'write', 50, 'moodle', 0),
(132, 'moodle/course:viewhiddensections', 'write', 50, 'moodle', 0),
(133, 'moodle/course:setcurrentsection', 'write', 50, 'moodle', 0),
(134, 'moodle/course:movesections', 'write', 50, 'moodle', 0),
(135, 'moodle/site:mnetlogintoremote', 'read', 10, 'moodle', 0),
(136, 'moodle/grade:viewall', 'read', 50, 'moodle', 8),
(137, 'moodle/grade:view', 'read', 50, 'moodle', 0),
(138, 'moodle/grade:viewhidden', 'read', 50, 'moodle', 8),
(139, 'moodle/grade:import', 'write', 50, 'moodle', 12),
(140, 'moodle/grade:export', 'read', 50, 'moodle', 8),
(141, 'moodle/grade:manage', 'write', 50, 'moodle', 12),
(142, 'moodle/grade:edit', 'write', 50, 'moodle', 12),
(143, 'moodle/grade:managegradingforms', 'write', 50, 'moodle', 12),
(144, 'moodle/grade:sharegradingforms', 'write', 10, 'moodle', 4),
(145, 'moodle/grade:managesharedforms', 'write', 10, 'moodle', 4),
(146, 'moodle/grade:manageoutcomes', 'write', 50, 'moodle', 0),
(147, 'moodle/grade:manageletters', 'write', 50, 'moodle', 0),
(148, 'moodle/grade:hide', 'write', 50, 'moodle', 0),
(149, 'moodle/grade:lock', 'write', 50, 'moodle', 0),
(150, 'moodle/grade:unlock', 'write', 50, 'moodle', 0),
(151, 'moodle/my:manageblocks', 'write', 10, 'moodle', 0),
(152, 'moodle/notes:view', 'read', 50, 'moodle', 0),
(153, 'moodle/notes:manage', 'write', 50, 'moodle', 16),
(154, 'moodle/tag:manage', 'write', 10, 'moodle', 16),
(155, 'moodle/tag:edit', 'write', 10, 'moodle', 16),
(156, 'moodle/tag:flag', 'write', 10, 'moodle', 16),
(157, 'moodle/tag:editblocks', 'write', 10, 'moodle', 0),
(158, 'moodle/block:view', 'read', 80, 'moodle', 0),
(159, 'moodle/block:edit', 'write', 80, 'moodle', 20),
(160, 'moodle/portfolio:export', 'read', 10, 'moodle', 0),
(161, 'moodle/comment:view', 'read', 50, 'moodle', 0),
(162, 'moodle/comment:post', 'write', 50, 'moodle', 24),
(163, 'moodle/comment:delete', 'write', 50, 'moodle', 32),
(164, 'moodle/webservice:createtoken', 'write', 10, 'moodle', 62),
(165, 'moodle/webservice:managealltokens', 'write', 10, 'moodle', 42),
(166, 'moodle/webservice:createmobiletoken', 'write', 10, 'moodle', 24),
(167, 'moodle/rating:view', 'read', 50, 'moodle', 0),
(168, 'moodle/rating:viewany', 'read', 50, 'moodle', 8),
(169, 'moodle/rating:viewall', 'read', 50, 'moodle', 8),
(170, 'moodle/rating:rate', 'write', 50, 'moodle', 0),
(171, 'moodle/course:markcomplete', 'write', 50, 'moodle', 0),
(172, 'moodle/course:overridecompletion', 'write', 50, 'moodle', 0),
(173, 'moodle/community:add', 'write', 10, 'moodle', 0),
(174, 'moodle/community:download', 'write', 10, 'moodle', 0),
(175, 'moodle/badges:manageglobalsettings', 'write', 10, 'moodle', 34),
(176, 'moodle/badges:viewbadges', 'read', 50, 'moodle', 0),
(177, 'moodle/badges:manageownbadges', 'write', 30, 'moodle', 0),
(178, 'moodle/badges:viewotherbadges', 'read', 30, 'moodle', 0),
(179, 'moodle/badges:earnbadge', 'write', 50, 'moodle', 0),
(180, 'moodle/badges:createbadge', 'write', 50, 'moodle', 16),
(181, 'moodle/badges:deletebadge', 'write', 50, 'moodle', 32),
(182, 'moodle/badges:configuredetails', 'write', 50, 'moodle', 16),
(183, 'moodle/badges:configurecriteria', 'write', 50, 'moodle', 4),
(184, 'moodle/badges:configuremessages', 'write', 50, 'moodle', 16),
(185, 'moodle/badges:awardbadge', 'write', 50, 'moodle', 16),
(186, 'moodle/badges:revokebadge', 'write', 50, 'moodle', 16),
(187, 'moodle/badges:viewawarded', 'read', 50, 'moodle', 8),
(188, 'moodle/site:forcelanguage', 'read', 10, 'moodle', 0),
(189, 'moodle/search:query', 'read', 10, 'moodle', 0),
(190, 'moodle/competency:competencymanage', 'write', 40, 'moodle', 0),
(191, 'moodle/competency:competencyview', 'read', 40, 'moodle', 0),
(192, 'moodle/competency:competencygrade', 'write', 50, 'moodle', 0),
(193, 'moodle/competency:coursecompetencymanage', 'write', 50, 'moodle', 0),
(194, 'moodle/competency:coursecompetencyconfigure', 'write', 70, 'moodle', 0),
(195, 'moodle/competency:coursecompetencygradable', 'read', 50, 'moodle', 0),
(196, 'moodle/competency:coursecompetencyview', 'read', 50, 'moodle', 0),
(197, 'moodle/competency:evidencedelete', 'write', 30, 'moodle', 0),
(198, 'moodle/competency:planmanage', 'write', 30, 'moodle', 0),
(199, 'moodle/competency:planmanagedraft', 'write', 30, 'moodle', 0),
(200, 'moodle/competency:planmanageown', 'write', 30, 'moodle', 0),
(201, 'moodle/competency:planmanageowndraft', 'write', 30, 'moodle', 0),
(202, 'moodle/competency:planview', 'read', 30, 'moodle', 0),
(203, 'moodle/competency:planviewdraft', 'read', 30, 'moodle', 0),
(204, 'moodle/competency:planviewown', 'read', 30, 'moodle', 0),
(205, 'moodle/competency:planviewowndraft', 'read', 30, 'moodle', 0),
(206, 'moodle/competency:planrequestreview', 'write', 30, 'moodle', 0),
(207, 'moodle/competency:planrequestreviewown', 'write', 30, 'moodle', 0),
(208, 'moodle/competency:planreview', 'write', 30, 'moodle', 0),
(209, 'moodle/competency:plancomment', 'write', 30, 'moodle', 0),
(210, 'moodle/competency:plancommentown', 'write', 30, 'moodle', 0),
(211, 'moodle/competency:usercompetencyview', 'read', 30, 'moodle', 0),
(212, 'moodle/competency:usercompetencyrequestreview', 'write', 30, 'moodle', 0),
(213, 'moodle/competency:usercompetencyrequestreviewown', 'write', 30, 'moodle', 0),
(214, 'moodle/competency:usercompetencyreview', 'write', 30, 'moodle', 0),
(215, 'moodle/competency:usercompetencycomment', 'write', 30, 'moodle', 0),
(216, 'moodle/competency:usercompetencycommentown', 'write', 30, 'moodle', 0),
(217, 'moodle/competency:templatemanage', 'write', 40, 'moodle', 0),
(218, 'moodle/analytics:listinsights', 'read', 50, 'moodle', 8),
(219, 'moodle/analytics:managemodels', 'write', 10, 'moodle', 2),
(220, 'moodle/competency:templateview', 'read', 40, 'moodle', 0),
(221, 'moodle/competency:userevidencemanage', 'write', 30, 'moodle', 0),
(222, 'moodle/competency:userevidencemanageown', 'write', 30, 'moodle', 0),
(223, 'moodle/competency:userevidenceview', 'read', 30, 'moodle', 0),
(224, 'moodle/site:maintenanceaccess', 'write', 10, 'moodle', 0),
(225, 'moodle/site:messageanyuser', 'write', 10, 'moodle', 16),
(226, 'moodle/site:managecontextlocks', 'write', 70, 'moodle', 0),
(227, 'moodle/course:togglecompletion', 'write', 70, 'moodle', 0),
(228, 'moodle/analytics:listowninsights', 'read', 10, 'moodle', 0),
(229, 'mod/assign:view', 'read', 70, 'mod_assign', 0),
(230, 'mod/assign:submit', 'write', 70, 'mod_assign', 0),
(231, 'mod/assign:grade', 'write', 70, 'mod_assign', 4),
(232, 'mod/assign:exportownsubmission', 'read', 70, 'mod_assign', 0),
(233, 'mod/assign:addinstance', 'write', 50, 'mod_assign', 4),
(234, 'mod/assign:editothersubmission', 'write', 70, 'mod_assign', 41),
(235, 'mod/assign:grantextension', 'write', 70, 'mod_assign', 0),
(236, 'mod/assign:revealidentities', 'write', 70, 'mod_assign', 0),
(237, 'mod/assign:reviewgrades', 'write', 70, 'mod_assign', 0),
(238, 'mod/assign:releasegrades', 'write', 70, 'mod_assign', 0),
(239, 'mod/assign:managegrades', 'write', 70, 'mod_assign', 0),
(240, 'mod/assign:manageallocations', 'write', 70, 'mod_assign', 0),
(241, 'mod/assign:viewgrades', 'read', 70, 'mod_assign', 0),
(242, 'mod/assign:viewblinddetails', 'write', 70, 'mod_assign', 8),
(243, 'mod/assign:receivegradernotifications', 'read', 70, 'mod_assign', 0),
(244, 'mod/assign:manageoverrides', 'write', 70, 'mod_assign', 0),
(245, 'mod/assign:showhiddengrader', 'read', 70, 'mod_assign', 0),
(246, 'mod/assignment:view', 'read', 70, 'mod_assignment', 0),
(247, 'mod/assignment:addinstance', 'write', 50, 'mod_assignment', 4),
(248, 'mod/assignment:submit', 'write', 70, 'mod_assignment', 0),
(249, 'mod/assignment:grade', 'write', 70, 'mod_assignment', 4),
(250, 'mod/assignment:exportownsubmission', 'read', 70, 'mod_assignment', 0),
(251, 'mod/book:addinstance', 'write', 50, 'mod_book', 4),
(252, 'mod/book:read', 'read', 70, 'mod_book', 0),
(253, 'mod/book:viewhiddenchapters', 'read', 70, 'mod_book', 0),
(254, 'mod/book:edit', 'write', 70, 'mod_book', 4),
(255, 'mod/chat:addinstance', 'write', 50, 'mod_chat', 4),
(256, 'mod/chat:chat', 'write', 70, 'mod_chat', 16),
(257, 'mod/chat:readlog', 'read', 70, 'mod_chat', 0),
(258, 'mod/chat:deletelog', 'write', 70, 'mod_chat', 0),
(259, 'mod/chat:exportparticipatedsession', 'read', 70, 'mod_chat', 8),
(260, 'mod/chat:exportsession', 'read', 70, 'mod_chat', 8),
(261, 'mod/chat:view', 'read', 70, 'mod_chat', 0),
(262, 'mod/choice:addinstance', 'write', 50, 'mod_choice', 4),
(263, 'mod/choice:choose', 'write', 70, 'mod_choice', 0),
(264, 'mod/choice:readresponses', 'read', 70, 'mod_choice', 0),
(265, 'mod/choice:deleteresponses', 'write', 70, 'mod_choice', 0),
(266, 'mod/choice:downloadresponses', 'read', 70, 'mod_choice', 0),
(267, 'mod/choice:view', 'read', 70, 'mod_choice', 0),
(268, 'mod/data:addinstance', 'write', 50, 'mod_data', 4),
(269, 'mod/data:viewentry', 'read', 70, 'mod_data', 0),
(270, 'mod/data:writeentry', 'write', 70, 'mod_data', 16),
(271, 'mod/data:comment', 'write', 70, 'mod_data', 16),
(272, 'mod/data:rate', 'write', 70, 'mod_data', 0),
(273, 'mod/data:viewrating', 'read', 70, 'mod_data', 0),
(274, 'mod/data:viewanyrating', 'read', 70, 'mod_data', 8),
(275, 'mod/data:viewallratings', 'read', 70, 'mod_data', 8),
(276, 'mod/data:approve', 'write', 70, 'mod_data', 16),
(277, 'mod/data:manageentries', 'write', 70, 'mod_data', 16),
(278, 'mod/data:managecomments', 'write', 70, 'mod_data', 16),
(279, 'mod/data:managetemplates', 'write', 70, 'mod_data', 20),
(280, 'mod/data:viewalluserpresets', 'read', 70, 'mod_data', 0),
(281, 'mod/data:manageuserpresets', 'write', 70, 'mod_data', 20),
(282, 'mod/data:exportentry', 'read', 70, 'mod_data', 8),
(283, 'mod/data:exportownentry', 'read', 70, 'mod_data', 0),
(284, 'mod/data:exportallentries', 'read', 70, 'mod_data', 8),
(285, 'mod/data:exportuserinfo', 'read', 70, 'mod_data', 8),
(286, 'mod/data:view', 'read', 70, 'mod_data', 0),
(287, 'mod/feedback:addinstance', 'write', 50, 'mod_feedback', 4),
(288, 'mod/feedback:view', 'read', 70, 'mod_feedback', 0),
(289, 'mod/feedback:complete', 'write', 70, 'mod_feedback', 16),
(290, 'mod/feedback:viewanalysepage', 'read', 70, 'mod_feedback', 8),
(291, 'mod/feedback:deletesubmissions', 'write', 70, 'mod_feedback', 0),
(292, 'mod/feedback:mapcourse', 'write', 70, 'mod_feedback', 0),
(293, 'mod/feedback:edititems', 'write', 70, 'mod_feedback', 20),
(294, 'mod/feedback:createprivatetemplate', 'write', 70, 'mod_feedback', 16),
(295, 'mod/feedback:createpublictemplate', 'write', 70, 'mod_feedback', 16),
(296, 'mod/feedback:deletetemplate', 'write', 70, 'mod_feedback', 0),
(297, 'mod/feedback:viewreports', 'read', 70, 'mod_feedback', 8),
(298, 'mod/feedback:receivemail', 'read', 70, 'mod_feedback', 8),
(299, 'mod/folder:addinstance', 'write', 50, 'mod_folder', 4),
(300, 'mod/folder:view', 'read', 70, 'mod_folder', 0),
(301, 'mod/folder:managefiles', 'write', 70, 'mod_folder', 16),
(302, 'mod/forum:addinstance', 'write', 50, 'mod_forum', 4),
(303, 'mod/forum:viewdiscussion', 'read', 70, 'mod_forum', 0),
(304, 'mod/forum:viewhiddentimedposts', 'read', 70, 'mod_forum', 0),
(305, 'mod/forum:startdiscussion', 'write', 70, 'mod_forum', 16),
(306, 'mod/forum:replypost', 'write', 70, 'mod_forum', 16),
(307, 'mod/forum:addnews', 'write', 70, 'mod_forum', 16),
(308, 'mod/forum:replynews', 'write', 70, 'mod_forum', 16),
(309, 'mod/forum:viewrating', 'read', 70, 'mod_forum', 0),
(310, 'mod/forum:viewanyrating', 'read', 70, 'mod_forum', 8),
(311, 'mod/forum:viewallratings', 'read', 70, 'mod_forum', 8),
(312, 'mod/forum:rate', 'write', 70, 'mod_forum', 0),
(313, 'mod/forum:postprivatereply', 'write', 70, 'mod_forum', 0),
(314, 'mod/forum:readprivatereplies', 'read', 70, 'mod_forum', 0),
(315, 'mod/forum:createattachment', 'write', 70, 'mod_forum', 16),
(316, 'mod/forum:deleteownpost', 'write', 70, 'mod_forum', 0),
(317, 'mod/forum:deleteanypost', 'write', 70, 'mod_forum', 0),
(318, 'mod/forum:splitdiscussions', 'write', 70, 'mod_forum', 0),
(319, 'mod/forum:movediscussions', 'write', 70, 'mod_forum', 0),
(320, 'mod/forum:pindiscussions', 'write', 70, 'mod_forum', 0),
(321, 'mod/forum:editanypost', 'write', 70, 'mod_forum', 16),
(322, 'mod/forum:viewqandawithoutposting', 'read', 70, 'mod_forum', 0),
(323, 'mod/forum:viewsubscribers', 'read', 70, 'mod_forum', 0),
(324, 'mod/forum:managesubscriptions', 'write', 70, 'mod_forum', 16),
(325, 'mod/forum:postwithoutthrottling', 'write', 70, 'mod_forum', 16),
(326, 'mod/forum:exportdiscussion', 'read', 70, 'mod_forum', 8),
(327, 'mod/forum:exportpost', 'read', 70, 'mod_forum', 8),
(328, 'mod/forum:exportownpost', 'read', 70, 'mod_forum', 8),
(329, 'mod/forum:addquestion', 'write', 70, 'mod_forum', 16),
(330, 'mod/forum:allowforcesubscribe', 'read', 70, 'mod_forum', 0),
(331, 'mod/forum:canposttomygroups', 'write', 70, 'mod_forum', 0),
(332, 'mod/forum:canoverridediscussionlock', 'write', 70, 'mod_forum', 0),
(333, 'mod/forum:canoverridecutoff', 'write', 70, 'mod_forum', 0),
(334, 'mod/forum:cantogglefavourite', 'write', 70, 'mod_forum', 0),
(335, 'mod/glossary:addinstance', 'write', 50, 'mod_glossary', 4),
(336, 'mod/glossary:view', 'read', 70, 'mod_glossary', 0),
(337, 'mod/glossary:write', 'write', 70, 'mod_glossary', 16),
(338, 'mod/glossary:manageentries', 'write', 70, 'mod_glossary', 16),
(339, 'mod/glossary:managecategories', 'write', 70, 'mod_glossary', 16),
(340, 'mod/glossary:comment', 'write', 70, 'mod_glossary', 16),
(341, 'mod/glossary:managecomments', 'write', 70, 'mod_glossary', 16),
(342, 'mod/glossary:import', 'write', 70, 'mod_glossary', 16),
(343, 'mod/glossary:export', 'read', 70, 'mod_glossary', 0),
(344, 'mod/glossary:approve', 'write', 70, 'mod_glossary', 16),
(345, 'mod/glossary:rate', 'write', 70, 'mod_glossary', 0),
(346, 'mod/glossary:viewrating', 'read', 70, 'mod_glossary', 0),
(347, 'mod/glossary:viewanyrating', 'read', 70, 'mod_glossary', 8),
(348, 'mod/glossary:viewallratings', 'read', 70, 'mod_glossary', 8),
(349, 'mod/glossary:exportentry', 'read', 70, 'mod_glossary', 8),
(350, 'mod/glossary:exportownentry', 'read', 70, 'mod_glossary', 0),
(351, 'mod/imscp:view', 'read', 70, 'mod_imscp', 0),
(352, 'mod/imscp:addinstance', 'write', 50, 'mod_imscp', 4),
(353, 'mod/label:addinstance', 'write', 50, 'mod_label', 4),
(354, 'mod/label:view', 'read', 70, 'mod_label', 0),
(355, 'mod/lesson:addinstance', 'write', 50, 'mod_lesson', 4),
(356, 'mod/lesson:edit', 'write', 70, 'mod_lesson', 4),
(357, 'mod/lesson:grade', 'write', 70, 'mod_lesson', 20),
(358, 'mod/lesson:viewreports', 'read', 70, 'mod_lesson', 8),
(359, 'mod/lesson:manage', 'write', 70, 'mod_lesson', 0),
(360, 'mod/lesson:manageoverrides', 'write', 70, 'mod_lesson', 0),
(361, 'mod/lesson:view', 'read', 70, 'mod_lesson', 0),
(362, 'mod/lti:view', 'read', 70, 'mod_lti', 0),
(363, 'mod/lti:addinstance', 'write', 50, 'mod_lti', 4),
(364, 'mod/lti:manage', 'write', 70, 'mod_lti', 8),
(365, 'mod/lti:admin', 'write', 70, 'mod_lti', 8),
(366, 'mod/lti:addcoursetool', 'write', 50, 'mod_lti', 0),
(367, 'mod/lti:requesttooladd', 'write', 50, 'mod_lti', 0),
(368, 'mod/page:view', 'read', 70, 'mod_page', 0),
(369, 'mod/page:addinstance', 'write', 50, 'mod_page', 4),
(370, 'mod/quiz:view', 'read', 70, 'mod_quiz', 0),
(371, 'mod/quiz:addinstance', 'write', 50, 'mod_quiz', 4),
(372, 'mod/quiz:attempt', 'write', 70, 'mod_quiz', 16),
(373, 'mod/quiz:reviewmyattempts', 'read', 70, 'mod_quiz', 0),
(374, 'mod/quiz:manage', 'write', 70, 'mod_quiz', 16),
(375, 'mod/quiz:manageoverrides', 'write', 70, 'mod_quiz', 0),
(376, 'mod/quiz:preview', 'write', 70, 'mod_quiz', 0),
(377, 'mod/quiz:grade', 'write', 70, 'mod_quiz', 20),
(378, 'mod/quiz:regrade', 'write', 70, 'mod_quiz', 16),
(379, 'mod/quiz:viewreports', 'read', 70, 'mod_quiz', 8),
(380, 'mod/quiz:deleteattempts', 'write', 70, 'mod_quiz', 32),
(381, 'mod/quiz:ignoretimelimits', 'read', 70, 'mod_quiz', 0),
(382, 'mod/quiz:emailconfirmsubmission', 'read', 70, 'mod_quiz', 0),
(383, 'mod/quiz:emailnotifysubmission', 'read', 70, 'mod_quiz', 0),
(384, 'mod/quiz:emailwarnoverdue', 'read', 70, 'mod_quiz', 0),
(385, 'mod/resource:view', 'read', 70, 'mod_resource', 0),
(386, 'mod/resource:addinstance', 'write', 50, 'mod_resource', 4),
(387, 'mod/scorm:addinstance', 'write', 50, 'mod_scorm', 4),
(388, 'mod/scorm:viewreport', 'read', 70, 'mod_scorm', 0),
(389, 'mod/scorm:skipview', 'read', 70, 'mod_scorm', 0),
(390, 'mod/scorm:savetrack', 'write', 70, 'mod_scorm', 0),
(391, 'mod/scorm:viewscores', 'read', 70, 'mod_scorm', 0),
(392, 'mod/scorm:deleteresponses', 'write', 70, 'mod_scorm', 0),
(393, 'mod/scorm:deleteownresponses', 'write', 70, 'mod_scorm', 0),
(394, 'mod/survey:addinstance', 'write', 50, 'mod_survey', 4),
(395, 'mod/survey:participate', 'read', 70, 'mod_survey', 0),
(396, 'mod/survey:readresponses', 'read', 70, 'mod_survey', 0),
(397, 'mod/survey:download', 'read', 70, 'mod_survey', 0),
(398, 'mod/url:view', 'read', 70, 'mod_url', 0),
(399, 'mod/url:addinstance', 'write', 50, 'mod_url', 4),
(400, 'mod/wiki:addinstance', 'write', 50, 'mod_wiki', 4),
(401, 'mod/wiki:viewpage', 'read', 70, 'mod_wiki', 0),
(402, 'mod/wiki:editpage', 'write', 70, 'mod_wiki', 16),
(403, 'mod/wiki:createpage', 'write', 70, 'mod_wiki', 16),
(404, 'mod/wiki:viewcomment', 'read', 70, 'mod_wiki', 0),
(405, 'mod/wiki:editcomment', 'write', 70, 'mod_wiki', 16),
(406, 'mod/wiki:managecomment', 'write', 70, 'mod_wiki', 0),
(407, 'mod/wiki:managefiles', 'write', 70, 'mod_wiki', 0),
(408, 'mod/wiki:overridelock', 'write', 70, 'mod_wiki', 0),
(409, 'mod/wiki:managewiki', 'write', 70, 'mod_wiki', 0),
(410, 'mod/workshop:view', 'read', 70, 'mod_workshop', 0),
(411, 'mod/workshop:addinstance', 'write', 50, 'mod_workshop', 4),
(412, 'mod/workshop:switchphase', 'write', 70, 'mod_workshop', 0),
(413, 'mod/workshop:editdimensions', 'write', 70, 'mod_workshop', 4),
(414, 'mod/workshop:submit', 'write', 70, 'mod_workshop', 0),
(415, 'mod/workshop:peerassess', 'write', 70, 'mod_workshop', 0),
(416, 'mod/workshop:manageexamples', 'write', 70, 'mod_workshop', 0),
(417, 'mod/workshop:allocate', 'write', 70, 'mod_workshop', 0),
(418, 'mod/workshop:publishsubmissions', 'write', 70, 'mod_workshop', 0),
(419, 'mod/workshop:viewauthornames', 'read', 70, 'mod_workshop', 0),
(420, 'mod/workshop:viewreviewernames', 'read', 70, 'mod_workshop', 0),
(421, 'mod/workshop:viewallsubmissions', 'read', 70, 'mod_workshop', 0),
(422, 'mod/workshop:viewpublishedsubmissions', 'read', 70, 'mod_workshop', 0),
(423, 'mod/workshop:viewauthorpublished', 'read', 70, 'mod_workshop', 0),
(424, 'mod/workshop:viewallassessments', 'read', 70, 'mod_workshop', 0),
(425, 'mod/workshop:overridegrades', 'write', 70, 'mod_workshop', 0),
(426, 'mod/workshop:ignoredeadlines', 'write', 70, 'mod_workshop', 0),
(427, 'mod/workshop:deletesubmissions', 'write', 70, 'mod_workshop', 0),
(428, 'mod/workshop:exportsubmissions', 'read', 70, 'mod_workshop', 0),
(429, 'auth/oauth2:managelinkedlogins', 'write', 30, 'auth_oauth2', 0),
(430, 'enrol/category:synchronised', 'write', 10, 'enrol_category', 0),
(431, 'enrol/category:config', 'write', 50, 'enrol_category', 0),
(432, 'enrol/cohort:config', 'write', 50, 'enrol_cohort', 0),
(433, 'enrol/cohort:unenrol', 'write', 50, 'enrol_cohort', 0),
(434, 'enrol/database:unenrol', 'write', 50, 'enrol_database', 0),
(435, 'enrol/database:config', 'write', 50, 'enrol_database', 0),
(436, 'enrol/flatfile:manage', 'write', 50, 'enrol_flatfile', 0),
(437, 'enrol/flatfile:unenrol', 'write', 50, 'enrol_flatfile', 0),
(438, 'enrol/guest:config', 'write', 50, 'enrol_guest', 0),
(439, 'enrol/imsenterprise:config', 'write', 50, 'enrol_imsenterprise', 0),
(440, 'enrol/ldap:manage', 'write', 50, 'enrol_ldap', 0),
(441, 'enrol/lti:config', 'write', 50, 'enrol_lti', 0),
(442, 'enrol/lti:unenrol', 'write', 50, 'enrol_lti', 0),
(443, 'enrol/manual:config', 'write', 50, 'enrol_manual', 0),
(444, 'enrol/manual:enrol', 'write', 50, 'enrol_manual', 0),
(445, 'enrol/manual:manage', 'write', 50, 'enrol_manual', 0),
(446, 'enrol/manual:unenrol', 'write', 50, 'enrol_manual', 0),
(447, 'enrol/manual:unenrolself', 'write', 50, 'enrol_manual', 0),
(448, 'enrol/meta:config', 'write', 50, 'enrol_meta', 0),
(449, 'enrol/meta:selectaslinked', 'read', 50, 'enrol_meta', 0),
(450, 'enrol/meta:unenrol', 'write', 50, 'enrol_meta', 0),
(451, 'enrol/mnet:config', 'write', 50, 'enrol_mnet', 0),
(452, 'enrol/paypal:config', 'write', 50, 'enrol_paypal', 0),
(453, 'enrol/paypal:manage', 'write', 50, 'enrol_paypal', 0),
(454, 'enrol/paypal:unenrol', 'write', 50, 'enrol_paypal', 0),
(455, 'enrol/paypal:unenrolself', 'write', 50, 'enrol_paypal', 0),
(456, 'enrol/self:config', 'write', 50, 'enrol_self', 0),
(457, 'enrol/self:manage', 'write', 50, 'enrol_self', 0),
(458, 'enrol/self:holdkey', 'write', 50, 'enrol_self', 0),
(459, 'enrol/self:unenrolself', 'write', 50, 'enrol_self', 0),
(460, 'enrol/self:unenrol', 'write', 50, 'enrol_self', 0),
(461, 'message/airnotifier:managedevice', 'write', 10, 'message_airnotifier', 0),
(462, 'block/activity_modules:addinstance', 'write', 80, 'block_activity_modules', 20),
(463, 'block/activity_results:addinstance', 'write', 80, 'block_activity_results', 20),
(464, 'block/admin_bookmarks:myaddinstance', 'write', 10, 'block_admin_bookmarks', 0),
(465, 'block/admin_bookmarks:addinstance', 'write', 80, 'block_admin_bookmarks', 20),
(466, 'block/badges:addinstance', 'read', 80, 'block_badges', 0),
(467, 'block/badges:myaddinstance', 'read', 10, 'block_badges', 8),
(468, 'block/blog_menu:addinstance', 'write', 80, 'block_blog_menu', 20),
(469, 'block/blog_recent:addinstance', 'write', 80, 'block_blog_recent', 20),
(470, 'block/blog_tags:addinstance', 'write', 80, 'block_blog_tags', 20),
(471, 'block/calendar_month:myaddinstance', 'write', 10, 'block_calendar_month', 0),
(472, 'block/calendar_month:addinstance', 'write', 80, 'block_calendar_month', 20),
(473, 'block/calendar_upcoming:myaddinstance', 'write', 10, 'block_calendar_upcoming', 0),
(474, 'block/calendar_upcoming:addinstance', 'write', 80, 'block_calendar_upcoming', 20),
(475, 'block/comments:myaddinstance', 'write', 10, 'block_comments', 0),
(476, 'block/comments:addinstance', 'write', 80, 'block_comments', 20),
(477, 'block/community:myaddinstance', 'write', 10, 'block_community', 0),
(478, 'block/community:addinstance', 'write', 80, 'block_community', 20),
(479, 'block/completionstatus:addinstance', 'write', 80, 'block_completionstatus', 20),
(480, 'block/course_list:myaddinstance', 'write', 10, 'block_course_list', 0),
(481, 'block/course_list:addinstance', 'write', 80, 'block_course_list', 20),
(482, 'block/course_summary:addinstance', 'write', 80, 'block_course_summary', 20),
(483, 'block/feedback:addinstance', 'write', 80, 'block_feedback', 20),
(484, 'block/globalsearch:myaddinstance', 'write', 10, 'block_globalsearch', 0),
(485, 'block/globalsearch:addinstance', 'write', 80, 'block_globalsearch', 0),
(486, 'block/glossary_random:myaddinstance', 'write', 10, 'block_glossary_random', 0),
(487, 'block/glossary_random:addinstance', 'write', 80, 'block_glossary_random', 20),
(488, 'block/html:myaddinstance', 'write', 10, 'block_html', 0),
(489, 'block/html:addinstance', 'write', 80, 'block_html', 20),
(490, 'block/login:addinstance', 'write', 80, 'block_login', 20),
(491, 'block/lp:addinstance', 'write', 10, 'block_lp', 0),
(492, 'block/lp:myaddinstance', 'write', 10, 'block_lp', 0),
(493, 'block/mentees:myaddinstance', 'write', 10, 'block_mentees', 0),
(494, 'block/mentees:addinstance', 'write', 80, 'block_mentees', 20),
(495, 'block/mnet_hosts:myaddinstance', 'write', 10, 'block_mnet_hosts', 0),
(496, 'block/mnet_hosts:addinstance', 'write', 80, 'block_mnet_hosts', 20),
(497, 'block/myoverview:myaddinstance', 'write', 10, 'block_myoverview', 0),
(498, 'block/myprofile:myaddinstance', 'write', 10, 'block_myprofile', 0),
(499, 'block/myprofile:addinstance', 'write', 80, 'block_myprofile', 20),
(500, 'block/navigation:myaddinstance', 'write', 10, 'block_navigation', 0),
(501, 'block/navigation:addinstance', 'write', 80, 'block_navigation', 20),
(502, 'block/news_items:myaddinstance', 'write', 10, 'block_news_items', 0),
(503, 'block/news_items:addinstance', 'write', 80, 'block_news_items', 20),
(504, 'block/online_users:myaddinstance', 'write', 10, 'block_online_users', 0),
(505, 'block/online_users:addinstance', 'write', 80, 'block_online_users', 20),
(506, 'block/online_users:viewlist', 'read', 80, 'block_online_users', 0),
(507, 'block/participants:addinstance', 'write', 80, 'block_participants', 20),
(508, 'block/private_files:myaddinstance', 'write', 10, 'block_private_files', 0),
(509, 'block/private_files:addinstance', 'write', 80, 'block_private_files', 20),
(510, 'block/quiz_results:addinstance', 'write', 80, 'block_quiz_results', 20),
(511, 'block/recent_activity:addinstance', 'write', 80, 'block_recent_activity', 20),
(512, 'block/recent_activity:viewaddupdatemodule', 'read', 50, 'block_recent_activity', 0),
(513, 'block/recent_activity:viewdeletemodule', 'read', 50, 'block_recent_activity', 0),
(514, 'block/recentlyaccessedcourses:myaddinstance', 'write', 10, 'block_recentlyaccessedcourses', 0),
(515, 'block/recentlyaccesseditems:myaddinstance', 'write', 10, 'block_recentlyaccesseditems', 0),
(516, 'block/rss_client:myaddinstance', 'write', 10, 'block_rss_client', 0),
(517, 'block/rss_client:addinstance', 'write', 80, 'block_rss_client', 20),
(518, 'block/rss_client:manageownfeeds', 'write', 80, 'block_rss_client', 0),
(519, 'block/rss_client:manageanyfeeds', 'write', 80, 'block_rss_client', 16),
(520, 'block/search_forums:addinstance', 'write', 80, 'block_search_forums', 20),
(521, 'block/section_links:addinstance', 'write', 80, 'block_section_links', 20),
(522, 'block/selfcompletion:addinstance', 'write', 80, 'block_selfcompletion', 20),
(523, 'block/settings:myaddinstance', 'write', 10, 'block_settings', 0),
(524, 'block/settings:addinstance', 'write', 80, 'block_settings', 20),
(525, 'block/site_main_menu:addinstance', 'write', 80, 'block_site_main_menu', 20),
(526, 'block/social_activities:addinstance', 'write', 80, 'block_social_activities', 20),
(527, 'block/starredcourses:myaddinstance', 'write', 10, 'block_starredcourses', 0),
(528, 'block/tag_flickr:addinstance', 'write', 80, 'block_tag_flickr', 20),
(529, 'block/tag_youtube:addinstance', 'write', 80, 'block_tag_youtube', 20),
(530, 'block/tags:myaddinstance', 'write', 10, 'block_tags', 0),
(531, 'block/tags:addinstance', 'write', 80, 'block_tags', 20),
(532, 'block/timeline:myaddinstance', 'write', 10, 'block_timeline', 0),
(533, 'report/completion:view', 'read', 50, 'report_completion', 8),
(534, 'report/courseoverview:view', 'read', 10, 'report_courseoverview', 8),
(535, 'report/log:view', 'read', 50, 'report_log', 8),
(536, 'report/log:viewtoday', 'read', 50, 'report_log', 8),
(537, 'report/loglive:view', 'read', 50, 'report_loglive', 8),
(538, 'report/outline:view', 'read', 50, 'report_outline', 8),
(539, 'report/outline:viewuserreport', 'read', 50, 'report_outline', 8),
(540, 'report/participation:view', 'read', 50, 'report_participation', 8),
(541, 'report/performance:view', 'read', 10, 'report_performance', 2),
(542, 'report/progress:view', 'read', 50, 'report_progress', 8),
(543, 'report/questioninstances:view', 'read', 10, 'report_questioninstances', 0),
(544, 'report/security:view', 'read', 10, 'report_security', 2),
(545, 'report/stats:view', 'read', 50, 'report_stats', 8),
(546, 'report/usersessions:manageownsessions', 'write', 30, 'report_usersessions', 0),
(547, 'gradeexport/ods:view', 'read', 50, 'gradeexport_ods', 8),
(548, 'gradeexport/ods:publish', 'read', 50, 'gradeexport_ods', 8),
(549, 'gradeexport/txt:view', 'read', 50, 'gradeexport_txt', 8),
(550, 'gradeexport/txt:publish', 'read', 50, 'gradeexport_txt', 8),
(551, 'gradeexport/xls:view', 'read', 50, 'gradeexport_xls', 8),
(552, 'gradeexport/xls:publish', 'read', 50, 'gradeexport_xls', 8),
(553, 'gradeexport/xml:view', 'read', 5