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, '63e7c176c6f4d0770117e4c8036f54c6', 'backup', 'course', 2, 'moodle2', 0, 50, 2, 1000, 1, 0, '077ffe6beb4c31225aa427b3a9200faa', 1594667132, 1594667132, 0.00000000000000, ''),
(2, 'ede1e8672dbf05aff270b77ba530bf00', 'backup', 'activity', 56, 'moodle2', 0, 20, 2, 1000, 1, 0, '3304df3dea753a2a5c737c7ddc8668f1', 1595615724, 1595615724, 0.00000000000000, ''),
(3, '0df8f0db5badcb64b011244e8ee992e2', 'restore', 'activity', 3, 'moodle2', 0, 20, 2, 1000, 1, 0, '6f9c393224af2332f3b77a4a175f90c8', 1595615724, 1595615725, 0.00000000000000, ''),
(4, '0129fcdfdf1354ead7e9085fd90c46aa', 'backup', 'activity', 57, 'moodle2', 0, 20, 2, 1000, 1, 0, 'a7bab7b8d5f6eb88e5e17c73db5e703d', 1595616003, 1595616004, 0.00000000000000, ''),
(5, '442dcc170aca50a765232a23e6db3b08', 'restore', 'activity', 3, 'moodle2', 0, 20, 2, 1000, 1, 0, '33edc1277db57269944d32a706ef9b61', 1595616004, 1595616004, 0.00000000000000, ''),
(6, 'a68e778d25cdf235d8136549a7609a7a', 'backup', 'activity', 58, 'moodle2', 0, 20, 2, 1000, 1, 0, 'a58ece1f2247d9a2722fe32bf10fb066', 1595616287, 1595616287, 0.00000000000000, ''),
(7, 'b994b0524c47052f1fb90c0d6a4244db', 'restore', 'activity', 3, 'moodle2', 0, 20, 2, 1000, 1, 0, '17955c3ea8eabc3d6ef5a6f889986985', 1595616287, 1595616287, 0.00000000000000, ''),
(8, '9aa260ce817f464e23446f91fae55762', 'backup', 'activity', 59, 'moodle2', 0, 20, 2, 1000, 1, 0, 'b44718b61e8153ea0f7575747e2276e8', 1595616587, 1595616587, 0.00000000000000, ''),
(9, '5ea153cfa124909f6f3aef8ed9f81227', 'restore', 'activity', 3, 'moodle2', 0, 20, 2, 1000, 1, 0, '1026a91e1c90c70b3f03de1f730b2c14', 1595616587, 1595616587, 0.00000000000000, '');
INSERT INTO `mdl_backup_controllers` (`id`, `backupid`, `operation`, `type`, `itemid`, `format`, `interactive`, `purpose`, `userid`, `status`, `execution`, `executiontime`, `checksum`, `timecreated`, `timemodified`, `progress`, `controller`) VALUES
(10, 'cd7b6020eb0162071243737045e9d081', 'backup', 'course', 3, 'moodle2', 0, 80, 2, 700, 2, 0, 'a857bb7efd6323ebbc3e7b2a3e3ff493', 1604049813, 1604049813, 0.00000000000000, '[encoded data, 426060 characters]');
