MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

-- phpMyAdmin SQL Dump
-- version 4.9.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 05, 2020 at 12:26 AM
-- Server version: 10.4.8-MariaDB
-- PHP Version: 7.2.23

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: `moodle`
--

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

--
-- Table structure for table `mdl_course`
--

CREATE TABLE `mdl_course` (
  `id` bigint(10) NOT NULL,
  `category` bigint(10) NOT NULL DEFAULT 0,
  `sortorder` bigint(10) NOT NULL DEFAULT 0,
  `fullname` varchar(254) NOT NULL DEFAULT '',
  `shortname` varchar(255) NOT NULL DEFAULT '',
  `idnumber` varchar(100) NOT NULL DEFAULT '',
  `summary` longtext DEFAULT NULL,
  `summaryformat` tinyint(2) NOT NULL DEFAULT 0,
  `format` varchar(21) NOT NULL DEFAULT 'topics',
  `showgrades` tinyint(2) NOT NULL DEFAULT 1,
  `newsitems` mediumint(5) NOT NULL DEFAULT 1,
  `startdate` bigint(10) NOT NULL DEFAULT 0,
  `enddate` bigint(10) NOT NULL DEFAULT 0,
  `marker` bigint(10) NOT NULL DEFAULT 0,
  `maxbytes` bigint(10) NOT NULL DEFAULT 0,
  `legacyfiles` smallint(4) NOT NULL DEFAULT 0,
  `showreports` smallint(4) NOT NULL DEFAULT 0,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  `visibleold` tinyint(1) NOT NULL DEFAULT 1,
  `groupmode` smallint(4) NOT NULL DEFAULT 0,
  `groupmodeforce` smallint(4) NOT NULL DEFAULT 0,
  `defaultgroupingid` bigint(10) NOT NULL DEFAULT 0,
  `lang` varchar(30) NOT NULL DEFAULT '',
  `calendartype` varchar(30) NOT NULL DEFAULT '',
  `theme` varchar(50) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `requested` tinyint(1) NOT NULL DEFAULT 0,
  `enablecompletion` tinyint(1) NOT NULL DEFAULT 0,
  `completionnotify` tinyint(1) NOT NULL DEFAULT 0,
  `cacherev` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Central course table' ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `mdl_course`
--

INSERT INTO `mdl_course` (`id`, `category`, `sortorder`, `fullname`, `shortname`, `idnumber`, `summary`, `summaryformat`, `format`, `showgrades`, `newsitems`, `startdate`, `enddate`, `marker`, `maxbytes`, `legacyfiles`, `showreports`, `visible`, `visibleold`, `groupmode`, `groupmodeforce`, `defaultgroupingid`, `lang`, `calendartype`, `theme`, `timecreated`, `timemodified`, `requested`, `enablecompletion`, `completionnotify`, `cacherev`) VALUES
(1, 0, 1, 'Localhost Moodle v3.5', 'Moodle v3.5', '', '', 0, 'site', 1, 3, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, '', '', '', 1570754310, 1570755712, 0, 0, 0, 1570757804),
(2, 2, 40002, 'TDC Unit Tempate', 'TDC Unit Template', '', 'In this unit you will learn about:\r\n[Describe the application of the unit in student friendly language – this information is available in all unit of competency details on training.gov.au. do not directly copy the language used on training.gov.au ]', 1, 'onetopic', 1, 0, 1535292000, 1566828000, 0, 0, 0, 1, 1, 1, 1, 0, 0, '', '', 'tdcemumauve', 1535282021, 1571799518, 0, 1, 0, 1571799518),
(3, 2, 40001, 'TDC Course Template', 'TDC Course Template', '', '', 1, 'onetopic', 1, 1, 1535292000, 1566828000, 0, 0, 0, 1, 1, 1, 1, 0, 0, '', '', 'tdcemuyellow', 1535281461, 1571804324, 0, 1, 0, 1571804325),
(4, 1, 10001, 'Dummy Course', 'Dummy Course', '', '', 1, 'topics', 1, 5, 1570798800, 1602334800, 0, 0, 0, 0, 1, 1, 0, 0, 0, '', '', '', 1570756611, 1570756611, 0, 1, 0, 1570757804),
(5, 1, 10002, 'TDC Unit No Students', 'TDC Unit No Students', '', 'In this unit you will learn about:\n[Describe the application of the unit in student friendly language – this information is available in all unit of competency details on training.gov.au. do not directly copy the language used on training.gov.au ]', 1, 'onetopic', 1, 0, 1535292000, 1566828000, 0, 104857600, 0, 1, 1, 1, 1, 0, 0, '', '', 'tdcemugreen', 1535282021, 1556860536, 0, 1, 0, 1571804041),
(6, 6, 60002, 'Baking', 'baking', '', '', 1, 'topics', 1, 5, 1583154000, 1614690000, 0, 0, 0, 0, 1, 1, 0, 0, 0, '', '', '', 1583121560, 1583121560, 0, 1, 0, 1583121566),
(7, 6, 60001, 'Cookies', 'cookies', '', '', 1, 'topics', 1, 5, 1583154000, 1614690000, 0, 0, 0, 0, 1, 1, 0, 0, 0, '', '', '', 1583121570, 1583121570, 0, 1, 0, 1583121576),
(8, 3, 20002, 'Apples', 'apples', '', '', 1, 'topics', 1, 5, 1583154000, 1614690000, 0, 0, 0, 0, 1, 1, 0, 0, 0, '', '', '', 1583121586, 1583121586, 0, 1, 0, 1583121592),
(9, 3, 20001, 'Test course', 'tc', '', '', 1, 'topics', 1, 5, 1583154000, 1614690000, 0, 0, 0, 0, 1, 1, 0, 0, 0, '', '', '', 1583121600, 1583121600, 0, 1, 0, 1583121606);

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

--
-- Table structure for table `mdl_course_categories`
--

CREATE TABLE `mdl_course_categories` (
  `id` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `idnumber` varchar(100) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `descriptionformat` tinyint(2) NOT NULL DEFAULT 0,
  `parent` bigint(10) NOT NULL DEFAULT 0,
  `sortorder` bigint(10) NOT NULL DEFAULT 0,
  `coursecount` bigint(10) NOT NULL DEFAULT 0,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  `visibleold` tinyint(1) NOT NULL DEFAULT 1,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `depth` bigint(10) NOT NULL DEFAULT 0,
  `path` varchar(255) NOT NULL DEFAULT '',
  `theme` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Course categories' ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `mdl_course_categories`
--

INSERT INTO `mdl_course_categories` (`id`, `name`, `idnumber`, `description`, `descriptionformat`, `parent`, `sortorder`, `coursecount`, `visible`, `visibleold`, `timemodified`, `depth`, `path`, `theme`) VALUES
(1, 'Miscellaneous', NULL, NULL, 0, 0, 10000, 2, 1, 1, 1570754310, 1, '/1', NULL),
(2, 'TDC', '', '', 1, 0, 40000, 2, 1, 1, 1570756230, 1, '/2', NULL),
(3, 'Miscellaneous Sub-category', '', '', 1, 1, 20000, 2, 1, 1, 1583121516, 2, '/1/3', NULL),
(4, 'Test', '', '', 1, 3, 30000, 0, 1, 1, 1583121528, 3, '/1/3/4', NULL),
(5, 'Course Offerings', '', '', 1, 2, 50000, 0, 1, 1, 1583121539, 2, '/2/5', NULL),
(6, 'Commercial Cookery', '', '', 1, 5, 60000, 2, 1, 1, 1583121549, 3, '/2/5/6', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mdl_course`
--
ALTER TABLE `mdl_course`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_cour_cat_ix` (`category`),
  ADD KEY `mdl_cour_idn_ix` (`idnumber`),
  ADD KEY `mdl_cour_sho_ix` (`shortname`),
  ADD KEY `mdl_cour_sor_ix` (`sortorder`);

--
-- Indexes for table `mdl_course_categories`
--
ALTER TABLE `mdl_course_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_courcate_par_ix` (`parent`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mdl_course`
--
ALTER TABLE `mdl_course`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `mdl_course_categories`
--
ALTER TABLE `mdl_course_categories`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

--
-- Table structure for table `mdl_role_assignments`
--

CREATE TABLE `mdl_role_assignments` (
  `id` bigint(10) NOT NULL,
  `roleid` bigint(10) NOT NULL DEFAULT 0,
  `contextid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `modifierid` bigint(10) NOT NULL DEFAULT 0,
  `component` varchar(100) NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL DEFAULT 0,
  `sortorder` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='assigning roles in different context' ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `mdl_role_assignments`
--

INSERT INTO `mdl_role_assignments` (`id`, `roleid`, `contextid`, `userid`, `timemodified`, `modifierid`, `component`, `itemid`, `sortorder`) VALUES
(1, 5, 24, 3, 1570756774, 2, '', 0, 0),
(2, 5, 48, 3, 1570756774, 2, '', 0, 0),
(4, 5, 48, 4, 1570756775, 2, '', 0, 0),
(5, 5, 24, 2, 1571278351, 2, '', 0, 0),
(6, 9, 116, 2, 1583122365, 2, '', 0, 0),
(7, 5, 116, 3, 1583122374, 2, '', 0, 0),
(8, 5, 116, 4, 1583122374, 2, '', 0, 0),
(11, 5, 115, 4, 1583122407, 2, '', 0, 0),
(12, 9, 115, 2, 1583122415, 2, '', 0, 0),
(13, 9, 113, 2, 1583190892, 2, '', 0, 0),
(15, 5, 115, 3, 1583206459, 2, '', 0, 0),
(17, 5, 24, 4, 1583285956, 2, '', 0, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mdl_role_assignments`
--
ALTER TABLE `mdl_role_assignments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_roleassi_sor_ix` (`sortorder`),
  ADD KEY `mdl_roleassi_rolcon_ix` (`roleid`,`contextid`),
  ADD KEY `mdl_roleassi_useconrol_ix` (`userid`,`contextid`,`roleid`),
  ADD KEY `mdl_roleassi_comiteuse_ix` (`component`,`itemid`,`userid`),
  ADD KEY `mdl_roleassi_rol_ix` (`roleid`),
  ADD KEY `mdl_roleassi_con_ix` (`contextid`),
  ADD KEY `mdl_roleassi_use_ix` (`userid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mdl_role_assignments`
--
ALTER TABLE `mdl_role_assignments`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

--
-- Table structure for table `mdl_groups`
--

CREATE TABLE `mdl_groups` (
  `id` bigint(10) NOT NULL,
  `courseid` bigint(10) NOT NULL,
  `idnumber` varchar(100) NOT NULL DEFAULT '',
  `name` varchar(254) NOT NULL DEFAULT '',
  `description` longtext DEFAULT NULL,
  `descriptionformat` tinyint(2) NOT NULL DEFAULT 0,
  `enrolmentkey` varchar(50) DEFAULT NULL,
  `picture` bigint(10) NOT NULL DEFAULT 0,
  `hidepicture` tinyint(1) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Each record represents a group.' ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `mdl_groups`
--

INSERT INTO `mdl_groups` (`id`, `courseid`, `idnumber`, `name`, `description`, `descriptionformat`, `enrolmentkey`, `picture`, `hidepicture`, `timecreated`, `timemodified`) VALUES
(1, 2, '', 'Group 1', '', 1, 'Group_enrolment2', 0, 0, 1520290242, 1583121442),
(2, 2, '', 'Course template_2018 course', '', 0, 'Group_enrolment1', 0, 0, 1537422511, 1583125199),
(3, 5, '', 'Group 1', '', 1, '', 0, 0, 1520290242, 1520290242),
(4, 5, '', 'Course template_2018 course', NULL, 0, NULL, 0, 0, 1537422511, 1543987223),
(5, 7, '', 'Newcastle', '', 1, '_Newcastle1', 0, 0, 1583121735, 1583121801),
(6, 7, '', 'Ultimo', '', 1, '_Ultimo1', 0, 0, 1583121750, 1583121812),
(7, 9, '', 'Newcastle', '', 0, '_Newcastle1', 0, 0, 1583122199, 1583122397),
(8, 9, '', 'Ultimo', '', 0, '_Ultimo1', 0, 0, 1583122199, 1583122390),
(9, 8, '', 'Newcastle', '', 0, '_Newcastle1', 0, 0, 1583122218, 1583290827),
(10, 8, '', 'Ultimo', '', 0, '_Ultimo1', 0, 0, 1583122218, 1583122434);

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

--
-- Table structure for table `mdl_groups_members`
--

CREATE TABLE `mdl_groups_members` (
  `id` bigint(10) NOT NULL,
  `groupid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `timeadded` bigint(10) NOT NULL DEFAULT 0,
  `component` varchar(100) NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Link a user to a group.' ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `mdl_groups_members`
--

INSERT INTO `mdl_groups_members` (`id`, `groupid`, `userid`, `timeadded`, `component`, `itemid`) VALUES
(1, 2, 2, 1583121417, '', 0),
(3, 1, 4, 1583121426, '', 0),
(4, 7, 3, 1583122384, '', 0),
(5, 8, 4, 1583122390, '', 0),
(6, 7, 2, 1583122397, '', 0),
(8, 10, 4, 1583122429, '', 0),
(9, 10, 3, 1583122434, '', 0),
(10, 9, 2, 1583290827, '', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mdl_groups`
--
ALTER TABLE `mdl_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_grou_idn_ix` (`idnumber`),
  ADD KEY `mdl_grou_cou_ix` (`courseid`);

--
-- Indexes for table `mdl_groups_members`
--
ALTER TABLE `mdl_groups_members`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_groumemb_usegro_uix` (`userid`,`groupid`),
  ADD KEY `mdl_groumemb_gro_ix` (`groupid`),
  ADD KEY `mdl_groumemb_use_ix` (`userid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mdl_groups`
--
ALTER TABLE `mdl_groups`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `mdl_groups_members`
--
ALTER TABLE `mdl_groups_members`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

--
-- Table structure for table `mdl_context`
--

CREATE TABLE `mdl_context` (
  `id` bigint(10) NOT NULL,
  `contextlevel` bigint(10) NOT NULL DEFAULT 0,
  `instanceid` bigint(10) NOT NULL DEFAULT 0,
  `path` varchar(255) DEFAULT NULL,
  `depth` tinyint(2) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='one of these must be set' ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `mdl_context`
--

INSERT INTO `mdl_context` (`id`, `contextlevel`, `instanceid`, `path`, `depth`) VALUES
(2, 50, 1, '/1/2', 2),
(24, 50, 2, '/1/23/24', 3),
(48, 50, 3, '/1/23/48', 3),
(63, 50, 4, '/1/3/63', 3),
(85, 50, 5, '/1/3/85', 3),
(113, 50, 6, '/1/23/111/112/113', 5),
(114, 50, 7, '/1/23/111/112/114', 5),
(115, 50, 8, '/1/3/109/115', 4),
(116, 50, 9, '/1/3/109/116', 4);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mdl_context`
--
ALTER TABLE `mdl_context`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_cont_conins_uix` (`contextlevel`,`instanceid`),
  ADD KEY `mdl_cont_ins_ix` (`instanceid`),
  ADD KEY `mdl_cont_pat_ix` (`path`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mdl_context`
--
ALTER TABLE `mdl_context`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=122;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

category	course	groupname	groupmembercount	groupstudentcount	groupspnetcount
Commercial Cookery	Baking	null	0	0	0
Commercial Cookery	Cookies	Newcastle	0	0	0
Commercial Cookery	Cookies	Ultimo	0	0	0
Miscellaneous	Dummy Course	null	0	0	0
Miscellaneous	TDC Unit No Students	Course template_2018 course	0	0	0
Miscellaneous	TDC Unit No Students	Group 1	0	0	0
Miscellaneous Sub-category	Apples	Newcastle	1	0	1
Miscellaneous Sub-category	Apples	Ultimo	2	2	0
Miscellaneous Sub-category	Test course	Newcastle	2	2	0
Miscellaneous Sub-category	Test course	Ultimo	1	1	0
TDC	TDC Course Template	null	0	0	0
TDC	TDC Unit Tempate	Course template_2018 course	1	1	0
TDC	TDC Unit Tempate	Group 1	1	1	0