--
-- Host: localhost    Database: moodle_DB
-- ------------------------------------------------------


--
-- Table structure for table `mdl_backup_controllers`
--

CREATE TABLE `mdl_backup_controllers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `backupid` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `operation` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'backup',
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL,
  `format` varchar(20) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `progress` decimal(15,14) NOT NULL DEFAULT '0.00000000000000',
  `controller` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_backcont_bac_uix` (`backupid`),
  KEY `mdl_backcont_typite_ix` (`type`,`itemid`),
  KEY `mdl_backcont_use_ix` (`userid`),
  KEY `mdl_backcont_useite_ix` (`userid`,`itemid`)
) ENGINE=InnoDB AUTO_INCREMENT=5316 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='To store the backup_controllers as they are used';

--
-- Dumping data for table `mdl_backup_controllers`
--

INSERT INTO `mdl_backup_controllers` VALUES (4874,'2d62a99ab56b492496bca0e7640d65a2','backup','course',1076,'moodle2',1,20,4245,1000,1,0,'f43a374779c2bcb42238d19160f4f202',1574484257,1574484352,0.00000000000000,''),(4875,'49b524be5e4c36192b800d38d7d6e29a','backup','course',1076,'moodle2',1,20,4227,1000,1,0,'c3af4600306c6bd0e150f3bf08fe78b4',1574484264,1574484392,0.00000000000000,''),(4876,'dfa692d4811c5c3db1c2f17762da347f','backup','course',1076,'moodle2',1,20,4222,1000,1,0,'16066fd53ed06ede052883d1be12fe9e',1574484265,1574484342,0.00000000000000,''),(4877,'11b8cba64ead2ca82904df9a71524208','backup','course',1076,'moodle2',1,20,9217,500,1,0,'61e68abe94f71793af550a9416f9d62a',1574484277,0,0.00000000000000,'[BLOB]'),(4878,'4c9b9461948925c635b1de99f7f42807','backup','course',1076,'moodle2',1,20,4221,1000,1,0,'d91b2ef9de8ba6c41aeb31bff5ae9235',1574484286,1574484344,0.00000000000000,''),(4879,'a80582be018a2a0fb53f14624cabf76c','backup','course',1076,'moodle2',1,20,250,1000,1,0,'c27dde75b0162f349c5f3a8a0701c64e',1574484316,1574484344,0.00000000000000,''),(4880,'d9cbda8d871f42e97cdf10c4d9109d30','backup','course',1076,'moodle2',1,20,9217,1000,1,0,'56f1c89992d9fbd4da3ee7639591fa4e',1574484322,1574484355,0.00000000000000,''),(4881,'567fbdfd366f461a0b08a93a2d56cf5d','backup','course',1076,'moodle2',1,20,4226,500,1,0,'6a891f66c40485409e7deabfd7ab58ed',1574484333,1574484342,0.00000000000000,'[BLOB]'),(4882,'4f98f4950a71967ff526a09fd1cc9c97','restore','course',2940,'moodle2',1,20,4222,1000,1,0,'3ceedd314abe6535eabf430527991566',1574484342,1574484562,0.00000000000000,''),(4883,'6e327f4cac6268bbaa7783c49d1c8e94','restore','course',2937,'moodle2',1,20,4221,1000,1,0,'e9dd5b7268519690fdf4a88627a233db',1574484344,1574484562,0.00000000000000,''),(4884,'8fc19e13a86272ed0940d6818f4a5cf4','restore','course',2927,'moodle2',1,20,250,1000,1,0,'625319c2ea388caafd03b2465fd03a1f',1574484344,1574484562,0.00000000000000,''),(4885,'8b2dc7381d0cae0cceb80d6473bf8614','restore','course',2949,'moodle2',1,20,4245,1000,1,0,'5809d31d0acdef02b6e7d7fbb1140357',1574484352,1574484565,0.00000000000000,''),(4886,'b6de3e85e5ce5e1b12fb4900b0bd9e52','restore','course',2935,'moodle2',1,20,9217,1000,1,0,'abb31f2717c23d213535e34c70444daa',1574484355,1574484570,0.00000000000000,''),(4887,'41bdc22f6ee304726cd6ef18ca9f7316','backup','course',1076,'moodle2',1,20,4223,1000,1,0,'492c2e7092abb77c65421b565cc0ae1e',1574484359,1574484387,0.00000000000000,''),(4888,'6f28fe8d8f1b39efe3e76e0bac52964b','backup','course',1076,'moodle2',1,20,4226,1000,1,0,'0365632024e418a84fb7e1e5d5dbb9ae',1574484375,1574484430,0.00000000000000,''),(4889,'89438aed2c5d41fc382a3f6da2f5a53b','restore','course',2943,'moodle2',1,20,4223,1000,1,0,'3c70bf61e3b06285436ce1e3aa79160c',1574484387,1574484600,0.00000000000000,''),(4890,'db8c5b31dc4ba286aee913cbf363fc10','restore','course',2932,'moodle2',1,20,4227,1000,1,0,'01ba0afcf74064cea801e3a06c82bc3d',1574484392,1574484602,0.00000000000000,''),(4891,'d5672fd7ea673f0edd02319066b96e8a','restore','course',2946,'moodle2',1,20,4226,800,1,0,'03214010ae1a81e5e371978c382f4128',1574484430,1574484432,0.00000000000000,'[BLOB]'),(4892,'289fc93e71219604be17782b9ab2700e','backup','course',1076,'moodle2',1,20,4228,1000,1,0,'5f6b225b1c6b17e5e4c8090e731e6efe',1574484445,1574484455,0.00000000000000,''),(4893,'72e2324286af4cb09851e974d53cc647','restore','course',2933,'moodle2',1,20,4228,1000,1,0,'a2719d064e5620eadc9b00b73522faa5',1574484455,1574484644,0.00000000000000,''),(4894,'7534fe81ae36a387c62ae186fd9bcaaf','backup','course',1076,'moodle2',1,20,4226,800,1,0,'1d36a8c3b54079515cdaf7f5ca495540',1574484584,1574484584,0.00000000000000,'[BLOB]'),(4895,'fb63f43b6f59ef69602a86cc8f5fb754','backup','course',1076,'moodle2',1,20,4226,1000,1,0,'fab1e168bfa257ae9632f6213935c974',1574484681,1574484711,0.00000000000000,''),(4896,'e99002ddea904b6f72398e5a22e30669','restore','course',2946,'moodle2',1,20,4226,1000,1,0,'a996564bab32e63c91fea589e3f55fb8',1574484711,1574484729,0.00000000000000,''),(4897,'1995a7b938bc87d6dc7f8b5dfef25540','backup','activity',11706,'moodle2',0,20,4221,1000,1,0,'822c88997b770e1f8390503e2f688198',1574484842,1574484842,0.00000000000000,''),(4898,'6d5a47ad7afc16bda69282416bed31fb','restore','activity',2937,'moodle2',0,20,4221,1000,1,0,'94d7458863dd8461ddec4bfe912adea3',1574484842,1574484843,0.00000000000000,''),(4899,'23df857733db4ea47201b4f8061e5b65','backup','activity',13081,'moodle2',0,20,292,1000,1,0,'ee44dd262a860d4b65cbcb818db3a45f',1574596349,1574596350,0.00000000000000,''),(4900,'96ccdc73633541d1ae12a381a91844da','restore','activity',3273,'moodle2',0,20,292,1000,1,0,'153e44cb0e5f80c568c958d8e980e472',1574596350,1574596352,0.00000000000000,''),(4901,'c7040a14beacacf2f49a1730a9eb5b43','backup','course',819,'moodle2',1,20,250,1000,1,0,'013700902949fb1dc35323c733b41e24',1574654221,1574654228,0.00000000000000,''),(4902,'62ff78ef0749c96d1af3ecc5ff8b90eb','restore','course',3225,'moodle2',1,20,250,1000,1,0,'ca6dcac72234ae3d74ca3ec8ca7746c6',1574654228,1574654236,0.00000000000000,''),(4903,'28bca71b9eb044d275e56b71c41a1a25','backup','activity',10857,'moodle2',0,50,250,1000,1,0,'e5dafb979065271d470f049fb956f71b',1574659261,1574659261,0.00000000000000,''),(4904,'2fa223f88b385c072f1b70aa4cbd1551','backup','course',2836,'moodle2',0,50,250,800,1,0,'21ed4133ff695a7a87ce494aaa2ff0be',1574659327,1574659327,0.00000000000000,'[BLOB]'),