CREATE DATABASE  IF NOT EXISTS `dbelearning` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `dbelearning`;
--
-- Host: 127.0.0.1    Database: dbelearning
-- ------------------------------------------------------


--
-- Table structure for table `administrators`
--

CREATE TABLE `administrators` (
  `administrator_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `lastname` varchar(45) DEFAULT NULL,
  `documenttype_id` int(11) DEFAULT NULL,
  `document` varchar(45) DEFAULT NULL,
  `password` varchar(500) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `is_active` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`administrator_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `administrators`
--

INSERT INTO `administrators` VALUES (1,'Admin','Admin',1,'11111111','$2y$10$bY9uipDnC9uNzdpByLLukOqJ6X3vUBJ89oICrUss8dVnoGX8w41/i','2020-03-07 03:27:34',1,'2020-03-07 03:27:34',1,1);

--
-- Table structure for table `areas`
--

CREATE TABLE `areas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `areas`
--

INSERT INTO `areas` VALUES (1,'Agente inmobiliario'),(2,'Empresarios / Emprendedores'),(3,'Diseñadores'),(4,'Contadores'),(5,'Programadores'),(6,'Fotógrafos'),(7,'Videógrafos'),(8,'Nutricionistas'),(9,'Farmacias'),(10,'Trainers'),(11,'Dentistas'),(12,'Pymes'),(13,'Escuelas de yoga'),(14,'Community manager'),(15,'Publicicistas'),(16,'Profesores'),(17,'Restaurantes por delivery'),(18,'Clínicas'),(19,'Supermercados'),(20,'Tiendas de ropa'),(21,'E-Commerce'),(22,'Retailers'),(23,'Importadores de productos médicos'),(24,'Empresas agrícolas'),(25,'Asesores comerciales'),(26,'Consultores de negocios'),(27,'Empresas de Eventos');

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `idCategory` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`idCategory`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'3D y Animación'),(2,'Data Science'),(3,'Contabilidad'),(4,'Diseñador gráfico'),(5,'Office'),(6,'Marketing digital'),(7,'Idiomas'),(8,'Programación'),(9,'Finanzas'),(10,'Fotografía y Video'),(11,'Logística'),(12,'Negocios'),(13,'Ventas');

--
-- Table structure for table `course_students`
--

CREATE TABLE `course_students` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idCourse` int(11) DEFAULT NULL,
  `idStudent` int(11) DEFAULT NULL,
  `idPayment` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_students`
--

INSERT INTO `course_students` VALUES (3,1,1,3,'2020-04-05 13:06:56',1,'2020-04-05 13:06:57',1),(4,2,1,4,'2020-04-05 16:18:12',1,'2020-04-05 16:18:13',1),(5,3,1,5,'2020-04-05 16:27:30',1,'2020-04-05 16:27:30',1);

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `idCourse` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(60) DEFAULT NULL,
  `aliasCourse` varchar(200) DEFAULT NULL,
  `subtitle` varchar(120) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `idLevel` int(11) DEFAULT NULL,
  `idTeacher` int(11) DEFAULT NULL,
  `idCategory` int(11) DEFAULT NULL,
  `idArea` int(11) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `promotionPrice` double DEFAULT NULL,
  `promotionDate` date DEFAULT NULL,
  `image` text DEFAULT NULL,
  `video` text DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `is_active` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`idCourse`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` VALUES (1,'Marketing Digital','mark',NULL,'xxxx',1,1,1,NULL,466,NULL,NULL,'teachers/1/courses/1/info/cursomarketing.jpg',NULL,1,NULL,NULL,NULL,NULL,1),(2,'Programacion','dev',NULL,'aaa',3,1,1,NULL,100,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,1),(3,'Hotelería',NULL,NULL,'ccc',1,1,2,NULL,78,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,1),(4,'Turismo',NULL,NULL,'dd',2,1,3,NULL,9,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,1),(5,'Enfermedad',NULL,NULL,'gg',2,1,2,NULL,77,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,1),(24,'Marketing 3',NULL,NULL,'Marketing Detail',1,1,1,NULL,450,NULL,NULL,'teachers/1/courses/25/info/Que?-es-marketing-1-1280x720.png','public/storage/teachers/1/courses/25/info/Snowfall - 29314.mp4',0,'2020-03-25 22:55:51',1,'2020-03-25 23:57:06',1,1),(25,'Videojuegos 1',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2020-03-28 21:49:23',1,'2020-03-28 21:49:23',1,1);

--
-- Table structure for table `lessons`
--

CREATE TABLE `lessons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSection` int(11) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `video` text DEFAULT NULL,
  `videoName` text DEFAULT NULL,
  `videoTime` double DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lessons`
--

INSERT INTO `lessons` VALUES (1,8,'leccion 1',NULL,NULL,NULL,'2020-04-12 16:05:55',1,'2020-04-12 16:05:55',1);

--
-- Table structure for table `levels`
--

CREATE TABLE `levels` (
  `idLevel` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idLevel`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `levels`
--

INSERT INTO `levels` VALUES (1,'Principiante'),(2,'Intermedio'),(3,'Avanzado'),(4,'Todos los niveles');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `migrations`
--


--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(200) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` VALUES ('007d867b1c02b1c40b9a3beaa285d226e95e9744f34f74905d15688b9d698b649df30eaff6557e45',1,3,'Laravel','[]',0,'2020-03-29 00:48:34','2020-03-29 00:48:34','2021-03-28 19:48:34'),('025bae6a2a768e3ed878b8216b280a1fe3a7d029508aa5f396de56e93d1a7ed3d1d053f93f9434f3',1,3,'Laravel','[]',0,'2020-03-29 00:07:58','2020-03-29 00:07:58','2021-03-28 19:07:58'),('0427f57c07b324e94038893af442d20cd71bb70c99e790fe3e78eea59b93531159d792ff305b7e73',1,3,'Laravel','[]',0,'2020-03-28 18:30:23','2020-03-28 18:30:23','2021-03-28 13:30:23'),('071a1d30abbe81aedc3c210a2f2cce1081744573cd64c99abe5361280c2d0c020c0e96e71f844b21',1,3,'Laravel','[]',0,'2020-03-29 00:52:29','2020-03-29 00:52:29','2021-03-28 19:52:29'),('074f8e73c54d851d3bd7437fc503fc92d4086d398be7743ffe707a8645172794b5c30222cd6bdd00',1,3,'Laravel','[]',0,'2020-03-29 00:21:13','2020-03-29 00:21:13','2021-03-28 19:21:13'),('077b2930a715fea4716b8ca5c82d6cd988538ae31c8c8cc1b4fecb66f24abc8126fd030b62003021',1,3,'Laravel','[]',0,'2020-03-29 00:10:16','2020-03-29 00:10:16','2021-03-28 19:10:16'),('09ef755c3736a592df3db5c31428ee977b94422570ada799df61e13979201a21c69186e2db171a25',1,3,'Laravel','[]',0,'2020-03-29 00:46:38','2020-03-29 00:46:38','2021-03-28 19:46:38'),('0ca97595c017bfd647779165f0de8aa9bc587e350acb30e0b3fac63ba8e2fdd64c66dbdfd3013c37',1,3,'Laravel','[]',0,'2020-03-28 18:18:19','2020-03-28 18:18:19','2021-03-28 13:18:19'),('0e7664541c2f597e268020b83dca1cd8214c92f10a6eb603c480fa506322967f34d7eb3772fc197d',1,3,'Laravel','[]',0,'2020-03-29 00:21:19','2020-03-29 00:21:19','2021-03-28 19:21:19'),('0f3acc006843bdd999302ff9fb2a6fecbbbd1fb20973648837a1af9b8d437c42facfd265910fd6a6',1,3,'Laravel','[]',0,'2020-03-29 00:45:35','2020-03-29 00:45:35','2021-03-28 19:45:35'),('0f7f03f4cc6f59d0d5ec4e8928ef772529a156040631fd36200d4a1d28d7657a12fb7c2b2c10ac2e',1,3,'Laravel','[]',0,'2020-03-29 00:50:15','2020-03-29 00:50:15','2021-03-28 19:50:15'),('115df696d9807e26231246eb835314b956b21e639a0dc93dc9e4924186ef17cdd52db21f162eb392',1,3,'Laravel','[]',0,'2020-03-28 18:37:59','2020-03-28 18:37:59','2021-03-28 13:37:59'),('1340432f9e6bed65b91aa7a4e292f73ff540f321e4a341fec235c66c8a730e5c771099ed80a2144d',1,3,'Laravel','[]',0,'2020-03-29 00:45:23','2020-03-29 00:45:23','2021-03-28 19:45:23'),('137aeda4f975782aa82f9b6fdcf661d664f65826a86b9c2c3f718cfa0fe0d5fd81d4942dd5cff758',1,3,'Laravel','[]',0,'2020-03-29 00:49:04','2020-03-29 00:49:04','2021-03-28 19:49:04'),('14ed428b1f0651929adaeb6faeb374360d642a7e95d0facbe3572a75e241d877ae23d2b957b4204d',1,3,'Laravel','[]',0,'2020-03-28 21:22:00','2020-03-28 21:22:00','2021-03-28 16:22:00'),('1537713e5451decbdbb9ade659f9f453bf724c472f8c28435b4752500cc627951706caa575c7899c',1,3,'Laravel','[]',0,'2020-03-28 23:55:01','2020-03-28 23:55:01','2021-03-28 18:55:01'),('160ae94d7badf670ac8106395b7205e17c1bf65ed9818680e625418e3e924861ec74f5d3c09d613b',1,3,'Laravel','[]',0,'2020-03-29 00:09:15','2020-03-29 00:09:15','2021-03-28 19:09:15'),('1b7b4135c5a472855b2fa81e3d9ff7e0e8275149406407ef048cbdab82d65c4a1586ef0ab063f164',1,3,'Laravel','[]',0,'2020-03-29 00:24:57','2020-03-29 00:24:57','2021-03-28 19:24:57'),('1ba33063639b9f9aaa24bfedf086f68c8154a1e3889652e7323a798929c62cbee954485318f9c1fd',1,3,'Laravel','[]',0,'2020-03-29 00:08:12','2020-03-29 00:08:12','2021-03-28 19:08:12'),('1bbb7f1c2c82466519bc8bc529cc31d562075ed4f37229a711bc8715423578753d0245eb478c630d',1,3,'Laravel','[]',0,'2020-03-28 23:00:03','2020-03-28 23:00:03','2021-03-28 18:00:03'),('1f03e0fd5c46a35da3dc5ba8d4fbce54e8644ccaa7e9f95b2e8587e760075e912a04bc8ee716c902',1,3,'Laravel','[]',0,'2020-03-28 21:56:30','2020-03-28 21:56:30','2021-03-28 16:56:30'),('259c5f062e255131fc18e98aecb691d470f5f61971e0212a252f56abdd85ca4560a7d2eb86f76a2e',1,3,'Laravel','[]',0,'2020-03-29 00:21:19','2020-03-29 00:21:19','2021-03-28 19:21:19'),('28067c676332fb6eebc1795564b98b19fbe2f7d1f95299d7120723c0ce97ecffae867b1494e9fe6b',1,3,'Laravel','[]',0,'2020-04-05 18:30:37','2020-04-05 18:30:37','2021-04-05 13:30:37'),('2aec755d6cbf975d04fe8a594f65035e76949bb4824aa814aae93460a8c6ac68c29c71af485cb5ec',1,3,'Laravel','[]',0,'2020-03-29 00:21:16','2020-03-29 00:21:16','2021-03-28 19:21:16'),('2d966d1712f3d11bead7a9f62bb344de8faace5bf91efbe161844a277413c59ae2d98537a6fab8f7',1,3,'Laravel','[]',0,'2020-03-29 00:07:52','2020-03-29 00:07:52','2021-03-28 19:07:52'),('2e6149d3b8bcde1b3bdf11dc1cb06e3f336d41f33b2b6145a954749fc055697ee18d74e144ae0d9f',1,3,'Laravel','[]',0,'2020-03-29 00:10:29','2020-03-29 00:10:29','2021-03-28 19:10:29'),('3314b130f3ac4d771c32bb6617d8d217370beb61a9ed382075a5a14709edb69fee046481631b41e5',1,3,'Laravel','[]',0,'2020-03-30 01:32:19','2020-03-30 01:32:19','2021-03-29 20:32:19'),('33a7ebcf729be5c869fd53c0ac4f95092568dc66027c48f2cef507ee9412146ea1be4375303b4e7f',1,3,'Laravel','[]',0,'2020-03-29 00:31:09','2020-03-29 00:31:09','2021-03-28 19:31:09'),('343fa0827dd56b00a8f657f56c81c932bd3697eee779fc724f675c108cb50f978d382a91ec8fd218',1,3,'Laravel','[]',0,'2020-03-29 17:00:35','2020-03-29 17:00:35','2021-03-29 12:00:35'),('350b413a153fa7b3867b2a99534d9604bdce8c55bbc6b9e48d4bc9c9a81c6f297b621f0b27b725dd',1,3,'Laravel','[]',0,'2020-03-29 00:16:11','2020-03-29 00:16:11','2021-03-28 19:16:11'),('36dc18d51f0e0a5172566d51449c2ca50fdc9f36a970629d16ff89f1b91d84c22e17d9557db03af8',1,3,'Laravel','[]',0,'2020-03-29 01:07:02','2020-03-29 01:07:02','2021-03-28 20:07:02'),('378906e091cad35c4172a434a4a1592ea8f38d55f43896b9b55dc396107a728c81f522e46dfea9eb',1,3,'Laravel','[]',0,'2020-03-21 23:36:37','2020-03-21 23:36:37','2021-03-21 18:36:37'),('37a7410303320274ea11f0f3b111fe7d3890b3a041e97b437839861d8ec4542a7a1baf0ac080ab2d',1,3,'Laravel','[]',0,'2020-03-29 00:05:40','2020-03-29 00:05:40','2021-03-28 19:05:40'),('3aba3b1fa5f38e5997d54ec0c6f566cf54b09faa8798ddf997e22421cdcea97266ec9472fb7132d9',1,3,'Laravel','[]',0,'2020-03-29 00:21:13','2020-03-29 00:21:13','2021-03-28 19:21:13'),('3c44ec55a8c725684cbd053fdc80747b6fea403b9101e2876996673d8806682c185bd05bac211dc4',1,3,'Laravel','[]',0,'2020-03-28 22:36:44','2020-03-28 22:36:44','2021-03-28 17:36:44'),('3d2f6211b0a37e2d2ef66b3d799d5dc634f160fe5e9bf08afeece354d03212f133985eeeec988ba5',1,3,'Laravel','[]',0,'2020-03-29 00:47:12','2020-03-29 00:47:12','2021-03-28 19:47:12'),('3dcc4bac98e00c384cbd88e3b1f1731180d173e51504e98c0a965ef7ddd7b5c77f8d40c10e1ded3c',1,3,'Laravel','[]',0,'2020-03-29 00:31:09','2020-03-29 00:31:09','2021-03-28 19:31:09'),('3ed6ce2daf27d381fa41685120b30148233e5ceca4a85541ce432110af4866f12cfa0a922800d632',1,3,'Laravel','[]',0,'2020-03-21 23:56:50','2020-03-21 23:56:50','2021-03-21 18:56:50'),('3fb28c05daf0cf300144879e315f045062bd9984b109f74d813f4fe9edc7f432bc02a319f5fe3da5',1,3,'Laravel','[]',0,'2020-03-22 00:46:03','2020-03-22 00:46:03','2021-03-21 19:46:03'),('3fd17f889e03cae56a823f713b383d6030c7b5aa5ea71966f268d9616fcc19e752a413ed6eaa9353',1,3,'Laravel','[]',0,'2020-03-28 18:18:27','2020-03-28 18:18:27','2021-03-28 13:18:27'),('4443f2bc0dc506e170c15f51abd7a4366c1d22341598e6fdb05ba93a11ea26f3f3ce7ffc80a99199',1,3,'Laravel','[]',0,'2020-03-28 21:32:10','2020-03-28 21:32:10','2021-03-28 16:32:10'),('45f78960736c5eeee9e1bc9847b748f18c799da3fc6b679fc713b08237986faed3c22409f4055410',1,3,'Laravel','[]',0,'2020-03-28 21:00:21','2020-03-28 21:00:21','2021-03-28 16:00:21'),('476e8e1418fc6e5939e84fb3889e648780c8eaf980fcb6e0d25c55d3b5fea74ec82d2b57c2a03703',1,3,'Laravel','[]',0,'2020-03-29 00:12:26','2020-03-29 00:12:26','2021-03-28 19:12:26'),('47dad6019c080214e07e2bc413fb50d3f4ae4b8e4b48f7cefdb377f835ea9604aab4a7b66bc411c1',1,3,'Laravel','[]',0,'2020-03-29 00:07:55','2020-03-29 00:07:55','2021-03-28 19:07:55'),('4a76296060da5e342886af8d6acb2f673f26a4578ebc6eb02cd77445eeefec5dd696321e68062894',1,3,'Laravel','[]',0,'2020-03-29 00:31:57','2020-03-29 00:31:57','2021-03-28 19:31:57'),('4ab0ed53a34075b712fbdad2f354c3c4262feb840149a5269f964a007323244f2d2f7f5ce852edf2',1,3,'Laravel','[]',0,'2020-03-29 00:47:12','2020-03-29 00:47:12','2021-03-28 19:47:12'),('4ba62538d112c588b3e09732b36f153d13e9073543fd1382e7ca127045529e57b926063650b7b0e3',1,3,'Laravel','[]',0,'2020-03-21 23:38:12','2020-03-21 23:38:12','2021-03-21 18:38:12'),('4bbb0883e696d228725c91b8f2ab2349a6f4dbfc3abb2b9a7af89f72111f257f66f1934b0f7e28fb',1,3,'Laravel','[]',0,'2020-03-29 00:06:05','2020-03-29 00:06:05','2021-03-28 19:06:05'),('4bc5017b94732295b0cd973837faca5428b6eafd5b6f45b095d5f1e391f9eed884bd621f3fc080ac',1,3,'Laravel','[]',0,'2020-04-05 17:35:00','2020-04-05 17:35:00','2021-04-05 12:35:00'),('506dc5ec18352f495e087e58ad5a762d945465c441cd4a2c9e1d13e22a0a581904f117e1b12149c7',1,3,'Laravel','[]',0,'2020-03-22 00:13:37','2020-03-22 00:13:37','2021-03-21 19:13:37'),('58c36c485300efaf74d1ff14348d049c368e87eb34d8834b00d50b5ac8e983d575f6e534c0302915',1,3,'Laravel','[]',0,'2020-03-29 00:27:42','2020-03-29 00:27:42','2021-03-28 19:27:42'),('5dc095c342998d2ac5a6465e25a17c64961db51ffdf789d03e8d22a12814f3880614ec5f6437c179',1,3,'Laravel','[]',0,'2020-03-29 00:52:09','2020-03-29 00:52:09','2021-03-28 19:52:09'),('5f796e6114b51be3a821a68e915a36adfeb30c982581d7da873a102c092dbdc1fe80e32713ef9648',1,3,'Laravel','[]',0,'2020-03-29 00:08:17','2020-03-29 00:08:17','2021-03-28 19:08:17'),('5fe8a3a3e2ce4533a7edb12317f4d0d51e8af00cda576cebed0dc5c89643f19bc41b911b9fa7ef31',1,3,'Laravel','[]',0,'2020-03-28 23:22:53','2020-03-28 23:22:53','2021-03-28 18:22:53'),('65a4b0fc62545462473054817d9010c17eac2f0d0f43785432b440ba7d0ae6fd1b62284149e41a46',1,3,'Laravel','[]',0,'2020-03-29 00:12:25','2020-03-29 00:12:25','2021-03-28 19:12:25'),('66a49eb9691d253740c28ea3647a272da88dffd5732579b6b684d554dded0028fbcefe1d08a5b8cd',1,3,'Laravel','[]',0,'2020-03-29 00:51:24','2020-03-29 00:51:24','2021-03-28 19:51:24'),('6cfceea4073a528c9f1d73386ba2a0792447064202ecacb6a1a087f9dee7ddfa5bf48ee889ed6701',1,3,'Laravel','[]',0,'2020-03-28 23:54:03','2020-03-28 23:54:03','2021-03-28 18:54:03'),('7348152d72b630f5690459a4e25c4dc512091a65773fb5e19ac6a34dd9c0c829a9b64e5d39ac5d97',1,3,'Laravel','[]',0,'2020-03-29 00:06:34','2020-03-29 00:06:34','2021-03-28 19:06:34'),('74f892fda99fa990306df17a5bb7441db9a243ddfe49863af2a403babe1604351e040423a7b84584',1,3,'Laravel','[]',0,'2020-03-29 00:30:44','2020-03-29 00:30:44','2021-03-28 19:30:44'),('758c06bcb200752ca08798ce2432a0327b820781ca979aafb770bcc46b97d10f30b975ed703a362b',1,3,'Laravel','[]',0,'2020-03-29 01:13:03','2020-03-29 01:13:03','2021-03-28 20:13:03'),('76b268f2243b3bf4c04a78cb509d5c4fc78e6c527593984a39e5ac8fbf94b64f3dc4365e14fd291f',1,3,'Laravel','[]',0,'2020-03-28 22:30:39','2020-03-28 22:30:39','2021-03-28 17:30:39'),('772c5e1fd75a184c2a5e1ca8e1002bc417144c2177a6f947d71348083bb0a94fcfcbbe9bce413df7',1,3,'Laravel','[]',0,'2020-03-29 00:54:17','2020-03-29 00:54:17','2021-03-28 19:54:17'),('78f0987588417f8ed900e59159bc2f6ae98c41a09155187be9676da5c3afe011e020818aa7f2aaec',1,3,'Laravel','[]',0,'2020-03-29 00:06:01','2020-03-29 00:06:01','2021-03-28 19:06:01'),('7ce1ab769bc189c73dd0508268299c01e8a205dddd9f708c97285d121450d561e619800f64a81bdc',1,3,'Laravel','[]',0,'2020-03-28 21:37:15','2020-03-28 21:37:15','2021-03-28 16:37:15'),('7d8bfed7de045eacf2386d2ad1c84cdd019717a3861f36b4a1edf9d2d3c30cefd011cb184945e610',1,3,'Laravel','[]',0,'2020-03-29 00:45:23','2020-03-29 00:45:23','2021-03-28 19:45:23'),('82e47b7d7e90df171e203863fb7f0c13b9480a7c1b8dddd492720ed10d9f788e9d06aa49fa88d046',1,3,'Laravel','[]',0,'2020-03-28 23:45:28','2020-03-28 23:45:28','2021-03-28 18:45:28'),('82fb3b1102ab1c35e774080ea856fa358d02dbcbb29d2e7643ca3269a9a4bce4f8f8d89c31ab68dd',1,3,'Laravel','[]',0,'2020-03-29 00:21:16','2020-03-29 00:21:16','2021-03-28 19:21:16'),('84c1587b6349d379d8ad1d17864b88d07c9003ea6b54d47405d37968e4219cd05231abc583740b88',1,3,'Laravel','[]',0,'2020-03-29 00:06:25','2020-03-29 00:06:25','2021-03-28 19:06:25'),('86753da786c98a11a9674505fe23a310ae18fc3eb44c8902e9dfb5825bbe719b8c0cd66143dbf8e7',1,3,'Laravel','[]',1,'2020-03-22 00:25:50','2020-03-22 00:25:50','2021-03-21 19:25:50'),('87b33e554d22228b68aa8235a4c41390fbb1a5f7a27ee9a6bbc55ecb773a9a706d5c497f849bc4b8',1,3,'Laravel','[]',0,'2020-03-29 00:10:16','2020-03-29 00:10:16','2021-03-28 19:10:16'),('8a3c19569af2f34d7b27a32b72b650a6a017d0cf2dd8a1eb948ab211187609bedf574378c756ba56',1,3,'Laravel','[]',0,'2020-03-29 00:47:03','2020-03-29 00:47:03','2021-03-28 19:47:03'),('8cbd7f40906ca22067cf73df411c6d9c084f1fb3f39c578e408b53f1093432157874bfc7c3b96d39',1,3,'Laravel','[]',0,'2020-03-28 23:44:08','2020-03-28 23:44:08','2021-03-28 18:44:08'),('907ffe2a3fe86d63e7bdb3342fedc6053d09ecaef673188232515b7d8d4460c61b59e282b3389884',1,3,'Laravel','[]',0,'2020-03-21 23:40:12','2020-03-21 23:40:12','2021-03-21 18:40:12'),('91ce75f16f2a10ea0a46d62970ee6d82692212792f2d4d184f485f0bfca249a8274b2d8b5da1953c',1,3,'Laravel','[]',0,'2020-03-28 21:54:46','2020-03-28 21:54:46','2021-03-28 16:54:46'),('92ae07241d97e4c768d94f16ae3b50f530888db3307bd4fe16ec61fe8803e9b95ab9f1e8f6e3985d',1,3,'Laravel','[]',0,'2020-03-29 00:24:56','2020-03-29 00:24:56','2021-03-28 19:24:56'),('92e55477a41aa412cc91602c49480bf4423299dfdd976d589c166e5b2c931126d642c0c1617d7780',1,3,'Laravel','[]',0,'2020-03-28 21:38:45','2020-03-28 21:38:45','2021-03-28 16:38:45'),('9300567c16856a13d720981c3059ec621f35c8ef8a5abaec9c7a5d53776be7a70a8d6e9f9fd39be8',1,3,'Laravel','[]',0,'2020-03-28 18:38:39','2020-03-28 18:38:39','2021-03-28 13:38:39'),('93ef32d239f879d9d27be8842726b3a23396ed90b6b5ca2f782ace842929954ac02f6688359344dc',1,3,'Laravel','[]',0,'2020-03-28 22:54:35','2020-03-28 22:54:35','2021-03-28 17:54:35'),('95f902c8d6fdd37c0d418933fe1a590c27756f7d797995048e295097b664e4a5822a2c4b7b6f08d6',1,3,'Laravel','[]',0,'2020-03-22 20:21:39','2020-03-22 20:21:39','2021-03-22 15:21:39'),('96145f27d794d40a329cc84ab42c9dc96cb90d15ab8d487ae2bef4e9b25e981d7464067ca2fbe37c',1,3,'Laravel','[]',0,'2020-03-28 18:25:11','2020-03-28 18:25:11','2021-03-28 13:25:11'),('964a9243c36f01928ad5593528604837df195f0436a0f5dd0cdae22db1673fe36f7f6b8cfa6c646a',1,3,'Laravel','[]',0,'2020-03-22 00:14:31','2020-03-22 00:14:31','2021-03-21 19:14:31'),('971859fb67557661767839711313a60eacd9113c70cb16fa9fc907cb73054b2a153a7ce6b793cfab',1,3,'Laravel','[]',0,'2020-03-29 00:52:29','2020-03-29 00:52:29','2021-03-28 19:52:29'),('986c2ebda3287f949e25efeb6e32944ed2c83b1a0f3891b995a41c5f603f2e8e5f97298450f1257e',1,3,'Laravel','[]',0,'2020-03-28 17:24:12','2020-03-28 17:24:12','2021-03-28 12:24:12'),('986dae822da8d34568f79d238ef464d0154b5eca1b379de303d5d6494da0441a6c7e8f4eeb720fb3',1,3,'Laravel','[]',0,'2020-03-29 00:09:15','2020-03-29 00:09:15','2021-03-28 19:09:15'),('9983d307fa533c2decfcad00c455e29051a33a0c7da0947c3ce12afc88b3762091c0e76272d688eb',1,3,'Laravel','[]',0,'2020-03-29 00:52:10','2020-03-29 00:52:10','2021-03-28 19:52:10'),('9cd4d4ccb0b73a9a47b5aa881d3ae85824f19baa864e1e79bba21c0b73ee84c5e3bc824286078dc0',1,3,'Laravel','[]',0,'2020-03-22 05:19:32','2020-03-22 05:19:32','2021-03-22 00:19:32'),('9e975ecda44f3333654df277154287c501d99653246877e85884678c3e989d0e39a2046462c288c6',1,3,'Laravel','[]',0,'2020-03-28 23:01:27','2020-03-28 23:01:27','2021-03-28 18:01:27'),('9f1f0ed0aae664c7d38586f277cf300f6a5f48805f11b492e769c2e2090cae06bfe510ed70cc1140',1,3,'Laravel','[]',0,'2020-03-28 20:58:43','2020-03-28 20:58:43','2021-03-28 15:58:43'),('a0c14d2e4a51c2fd2eb0cd226a5f6c355c98ede8b7b750558b1815dcfd486190c7bc52edc1935e34',1,3,'Laravel','[]',0,'2020-03-28 18:22:36','2020-03-28 18:22:36','2021-03-28 13:22:36'),('a2316368302b1c8e6e9b4391cbfd0a1299ea2c2bdbf97e07301184f95743b29ebda04a61c0d28e2d',1,3,'Laravel','[]',0,'2020-03-29 00:50:55','2020-03-29 00:50:55','2021-03-28 19:50:55'),('a251cc76b9bbf7c671b5a64616ae45ea6df1017cfc67a20c0a806efa639e233c90cdb32e2824e0d7',1,3,'Laravel','[]',0,'2020-03-28 18:30:35','2020-03-28 18:30:35','2021-03-28 13:30:35'),('a382adb0149a395d862d190cd3f147ba7325501f4c519d04863ba4ca10caefc03951de08ff5ab711',1,3,'Laravel','[]',0,'2020-03-22 00:11:24','2020-03-22 00:11:24','2021-03-21 19:11:24'),('a64684ffef6ec43a5fa522ec73fe131476193ffea2cfe2c4e14e1b355a1772f7b1cedebc2d9f93dd',1,3,'Laravel','[]',0,'2020-03-29 00:49:04','2020-03-29 00:49:04','2021-03-28 19:49:04'),('a68d649352f40af7959e631cb7f3805b5ed32d40533060980ab34a965aeb2cdfc3ef2ba0a4e6f68a',1,3,'Laravel','[]',0,'2020-03-29 00:08:17','2020-03-29 00:08:17','2021-03-28 19:08:17'),('a771d95725cb16b3a18bd388e8879e8e9073f49f06ea1c23a6eafd89fcceb6a98dc7d1cf2979b085',1,3,'Laravel','[]',0,'2020-03-29 01:16:49','2020-03-29 01:16:49','2021-03-28 20:16:49'),('a94143699a42fe381c8970fed2b3a7dba9a800efe38404bb89a5d92c71d41a39e483d7f07274c103',1,3,'Laravel','[]',0,'2020-03-29 00:50:55','2020-03-29 00:50:55','2021-03-28 19:50:55'),('a98f0506291c19697bf00e9d28bc9aacd290066ad5f56080a4a2de6cfc66f910ba81a480801b6ed6',1,3,'Laravel','[]',0,'2020-03-28 20:42:09','2020-03-28 20:42:09','2021-03-28 15:42:09'),('ae606136b1fe526bace328506c526234dd2a955f9c90676b3e81daf42192751168ebb27d1e22bc1a',1,3,'Laravel','[]',0,'2020-03-28 17:47:21','2020-03-28 17:47:21','2021-03-28 12:47:21'),('af412f8d2a16c9c4e90fb4bda2fbfe141dcd0145b83a32a68696fd9cd0056be86b0e3ad0235a5741',1,3,'Laravel','[]',0,'2020-03-28 21:18:04','2020-03-28 21:18:04','2021-03-28 16:18:04'),('b207859821042aa51a10507156d8fe6bae9b4e78297cb599d93e658a4b99747d82c237420009a283',1,3,'Laravel','[]',0,'2020-03-21 23:51:58','2020-03-21 23:51:58','2021-03-21 18:51:58'),('bbd25ace8c7252d7e6e666f7ebd247aa575bd54e04fefcd04e2a022418013edb55b8c7e2f51cfcdd',1,3,'Laravel','[]',0,'2020-03-29 00:47:44','2020-03-29 00:47:44','2021-03-28 19:47:44'),('bce511966d137a0ea722cc20ca5a9e2b03516efc4b8c1417052567b6ac14cb3da0e5fa965745dd44',1,3,'Laravel','[]',0,'2020-03-29 00:08:02','2020-03-29 00:08:02','2021-03-28 19:08:02'),('bd7b3db978be77484cc4e7a717d2d02ad5aaa23a4eda453da11036d7e18bfbd4724027f796a368fc',1,3,'Laravel','[]',0,'2020-03-29 00:44:36','2020-03-29 00:44:36','2021-03-28 19:44:36'),('bf4436b97156d42f497bf2a9381b1b50ab00f514dfa095689a5571ac3b6a3ea94d2ab44b3e7d5617',1,3,'Laravel','[]',0,'2020-03-29 00:45:35','2020-03-29 00:45:35','2021-03-28 19:45:35'),('c00e038e282f00478d77b81183cf78f8a22185d493b32ae09812df1e423da9126046a74193ed95bb',1,3,'Laravel','[]',0,'2020-03-29 00:10:15','2020-03-29 00:10:15','2021-03-28 19:10:15'),('c08464f4e23fb9e09fd78da5c11c730bc602312498ad96099caf9ae73bd54c1838a15a51d13e1448',1,3,'Laravel','[]',0,'2020-03-29 00:16:11','2020-03-29 00:16:11','2021-03-28 19:16:11'),('c553c45c29fbd6c1ac8b7093c0574c483a840dddbedf4aaf429fbada7c282650b8786203b50a10cc',1,3,'Laravel','[]',0,'2020-03-22 00:14:51','2020-03-22 00:14:51','2021-03-21 19:14:51'),('c87b68cd35ec0b57cdd839d67a664009c159b4509edbba7ec0e09dd3d46505fc87ca198914f1c807',1,3,'Laravel','[]',0,'2020-03-28 18:21:34','2020-03-28 18:21:34','2021-03-28 13:21:34'),('c9006639e8252bc8bd039ed4701bd9630a6b02e0431683196bbaaa17a59f38970ef53b381d78cb2a',1,3,'Laravel','[]',0,'2020-04-10 16:15:47','2020-04-10 16:15:47','2021-04-10 11:15:47'),('c90a3cefb29ae36da22e57285454a584dd184fdb92cbec0d200445cff915dccd9b1c36d502589152',1,3,'Laravel','[]',0,'2020-03-29 00:31:57','2020-03-29 00:31:57','2021-03-28 19:31:57'),('ca91b5eb583c2ad9e3c4fa56c55b66622ff1ad938429971b6e7d0e449333689b72b4a3cc871387f0',1,3,'Laravel','[]',0,'2020-04-12 20:44:33','2020-04-12 20:44:33','2021-04-12 15:44:33'),('cacc18def6d70ea00d1c652b6226b8857424dfd790b8aec52f96132e49e31efc299d91a0a8c90b73',1,3,'Laravel','[]',0,'2020-03-29 00:54:17','2020-03-29 00:54:17','2021-03-28 19:54:17'),('cb230603748d57a6e91bff46d26fda175e27754e3167c9eef4ffe9017c5a3fa30920d6a13c6aa7aa',1,3,'Laravel','[]',0,'2020-03-22 00:14:42','2020-03-22 00:14:42','2021-03-21 19:14:42'),('ce5d55954582562b38482375b37903edf13ba22d73b185ba5c867be1ca62217d2af8846f45c0524b',1,3,'Laravel','[]',0,'2020-03-29 00:27:42','2020-03-29 00:27:42','2021-03-28 19:27:42'),('cec8a3a05436b672399bc8d5bd507204345bcfe357c1e835dc8abbedb6c5a190adb752b74940f2df',1,3,'Laravel','[]',0,'2020-03-29 00:08:12','2020-03-29 00:08:12','2021-03-28 19:08:12'),('cf35f98137897e22a8f5fb479963dc7307ec67e0f53deb1cca1d9485dbf18a699b9164b29f3a8da1',1,3,'Laravel','[]',0,'2020-03-21 23:40:34','2020-03-21 23:40:34','2021-03-21 18:40:34'),('d66c78c6d770e976cd451eb0ab323335d46c731dc85d380c688522c3dd30b7dae35c19503e2e5250',1,3,'Laravel','[]',0,'2020-03-22 17:25:22','2020-03-22 17:25:22','2021-03-22 12:25:22'),('d6915d21841a5d6ce42a8c11e00e9afae68a5963adcf79c7c11860a21b83dd6ebcb738640ce9c70a',1,3,'Laravel','[]',0,'2020-03-29 00:50:15','2020-03-29 00:50:15','2021-03-28 19:50:15'),('d9cad1c90aca2243902937a70b927b1f98f5bb850b64a1bae1d5467dfdbb074a083d6480333ba9b1',1,3,'Laravel','[]',0,'2020-03-29 00:55:08','2020-03-29 00:55:08','2021-03-28 19:55:08'),('da23a029923884a56b61bddc8895609dc4037dd0620c8d70b0d231f2a6537855596b8cd07381257e',1,3,'Laravel','[]',0,'2020-03-29 00:46:38','2020-03-29 00:46:38','2021-03-28 19:46:38'),('da9a47a74151568a0f24bfc70f9cde4ab47a3a01a9cc467c8a4790d9247e13fed99cbc8dd17e1eb3',1,3,'Laravel','[]',0,'2020-03-29 00:48:56','2020-03-29 00:48:56','2021-03-28 19:48:56'),('dc2c881a406203cb6a2997c36d378fd08581e397c3e9a3359ed9084d3fce2902d005859c5e866503',1,3,'Laravel','[]',0,'2020-03-29 00:06:31','2020-03-29 00:06:31','2021-03-28 19:06:31'),('dcca5be08fc5522709eeb0fe5df5e15ae2c8507ad3dddc4ef6c04bc23c7b1d337ec4beed2c95feae',1,3,'Laravel','[]',0,'2020-03-25 01:37:57','2020-03-25 01:37:57','2021-03-24 20:37:57'),('e04e53a09b915ef3e2424be6c27d44153c01f466d637f4d93c41c3667416a31a7f7950c810070619',1,3,'Laravel','[]',0,'2020-03-28 21:00:26','2020-03-28 21:00:26','2021-03-28 16:00:26'),('e335c65145800e37dde1e6361e9ef62989f6f59000d7d936effec16bfaa1b00333c4135a0b86c2ff',1,3,'Laravel','[]',0,'2020-03-29 01:13:28','2020-03-29 01:13:28','2021-03-28 20:13:28'),('e3bc190813161f3d8e3ab33f488e2e33deb3c9fb4597a144e8a3408e6585bdb58f52aa3e4093e591',1,3,'Laravel','[]',0,'2020-03-29 00:44:36','2020-03-29 00:44:36','2021-03-28 19:44:36'),('e3e18dfa5898aa18ae45c00effaa62c41ce839e6c01530ea0d9bc4de29fb13c7168feff012f2fedc',1,3,'Laravel','[]',0,'2020-04-05 20:46:28','2020-04-05 20:46:28','2021-04-05 15:46:28'),('e40e5f5d7ec428bffd2ea6c455969f703d9990bb41ca7a72a6638f0376dafe3c3d96a62f2ef84b12',1,3,'Laravel','[]',0,'2020-03-29 00:30:45','2020-03-29 00:30:45','2021-03-28 19:30:45'),('e47b47dffd348427265c81a0122f6d139ab04384a8b13c7c590adacfa47af692e965b1e4450db062',1,3,'Laravel','[]',0,'2020-03-29 00:10:29','2020-03-29 00:10:29','2021-03-28 19:10:29'),('e7d1091c65531ee117d86d78888a58082ef4042e16938d90c0e50957fe2d787d4a74cea7fafd0a7a',1,3,'Laravel','[]',0,'2020-03-29 00:48:34','2020-03-29 00:48:34','2021-03-28 19:48:34'),('e9c4bf1e07d4118cae4f7ee10b66c743882120b549f58d5db2820c599860b832574c6ea4dd17968c',1,3,'Laravel','[]',0,'2020-03-29 00:47:03','2020-03-29 00:47:03','2021-03-28 19:47:03'),('eac1e31f0fc92d7f710a942288a7d58a54df957ad2c176ae2e5771ab5d55612f643ffd698999f476',1,3,'Laravel','[]',0,'2020-03-28 21:38:01','2020-03-28 21:38:01','2021-03-28 16:38:01'),('eaec0a9ca1ab2af904be154d3bfec279871b8fa212b2e60301cc82abc44b862c8d115986ca3c67b4',1,3,'Laravel','[]',0,'2020-03-29 00:47:45','2020-03-29 00:47:45','2021-03-28 19:47:45'),('ec74b83c752b56ed7af5160be225779d8b8cb1df80f4621b6a5aeb2aff772923e184e48d9d0002a6',1,3,'Laravel','[]',0,'2020-03-22 00:22:21','2020-03-22 00:22:21','2021-03-21 19:22:21'),('f072ddec172caa2dfdecb3f7e06fef0da71f8422ef00833da23fd0e7413516475b071da3590ab14a',1,3,'Laravel','[]',0,'2020-03-29 00:06:28','2020-03-29 00:06:28','2021-03-28 19:06:28'),('f104aa85b48a63b7ec2acf7f3fc6c0e706bd6f0bef98f0934bc0edcb5873e5e3e83aa78cac73578d',1,3,'Laravel','[]',0,'2020-03-29 00:49:34','2020-03-29 00:49:34','2021-03-28 19:49:34'),('f1b3ddc925d6570f09f9f84ecba422afed51bcca81961d21d4fe80034ccb93e022173b003626a611',1,3,'Laravel','[]',0,'2020-03-29 00:48:56','2020-03-29 00:48:56','2021-03-28 19:48:56'),('f51e7909f41c377fbca3e9fb73b93931178c88e5a851de2b49b6f9e8bebe4e6f676440e2a37fef00',1,3,'Laravel','[]',0,'2020-03-29 00:09:15','2020-03-29 00:09:15','2021-03-28 19:09:15'),('f7ccc839b2e0b8282eaec6b6d87c6591a8b3e870ae02df7ae6db24af1e85eb1a1ff786829b0d1c99',1,3,'Laravel','[]',0,'2020-03-29 00:10:29','2020-03-29 00:10:29','2021-03-28 19:10:29'),('f803e199855ae728ea2a8aa853e8da9e7bbf078c72d6d6463a5d8e6b7ca563a0df4cbe65915e54be',1,3,'Laravel','[]',0,'2020-03-28 21:31:04','2020-03-28 21:31:04','2021-03-28 16:31:04'),('f847f563662b18961d0534605649d224139f27230b37bc7729e6814e9a10fa94d6a8d1584c98f851',1,3,'Laravel','[]',0,'2020-03-28 21:20:14','2020-03-28 21:20:14','2021-03-28 16:20:14'),('f9084ae47c3c84297c11db2a92cd7542c83fe6f79b228ea036698cc182c4fae0bbbe3a39e139454a',1,3,'Laravel','[]',0,'2020-03-29 00:49:34','2020-03-29 00:49:34','2021-03-28 19:49:34');

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `secret` varchar(100) NOT NULL,
  `redirect` text NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `oauth_clients`
--

INSERT INTO `oauth_clients` VALUES (3,NULL,'Laravel Personal Access Client','uViyAM7NPALCPbfRXIGgUhqoX0Mptm40MQYnN7yy','http://localhost',1,0,0,'2020-03-21 23:36:31','2020-03-21 23:36:31'),(4,NULL,'Laravel Password Grant Client','ccwXzn0Ds0E1E3tKrL85qCJXTMOhZHjKf3W3NVcS','http://localhost',0,1,0,'2020-03-21 23:36:32','2020-03-21 23:36:32');

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_personal_access_clients_client_id_index` (`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` VALUES (2,3,'2020-03-21 23:36:31','2020-03-21 23:36:31');

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) NOT NULL,
  `access_token_id` varchar(100) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `oauth_refresh_tokens`
--


--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` VALUES (1,'efectivo'),(2,'tarjeta');

--
-- Table structure for table `payment_states`
--

CREATE TABLE `payment_states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `color` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_states`
--

INSERT INTO `payment_states` VALUES (1,'Pendiente de Pago','yellow'),(2,'Pagado','green');

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idPaymentMethod` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `idPaymentState` int(11) DEFAULT NULL,
  `idTransaction` varchar(200) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` VALUES (3,1,466,2,'123123xxxxxx123','2020-04-05 13:06:57',1,'2020-04-05 13:57:25',1),(4,1,100,1,NULL,'2020-04-05 16:18:12',1,'2020-04-05 16:18:12',1),(5,1,78,1,NULL,'2020-04-05 16:27:30',1,'2020-04-05 16:27:30',1);

--
-- Table structure for table `resource_types`
--

CREATE TABLE `resource_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_types`
--

INSERT INTO `resource_types` VALUES (1,'Archivo'),(2,'Link');

--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idLesson` int(11) DEFAULT NULL,
  `idResourceType` int(11) DEFAULT NULL,
  `name` varchar(500) DEFAULT NULL,
  `link` text DEFAULT NULL,
  `file` text DEFAULT NULL,
  `fileSize` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resources`
--


--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idCourse` int(11) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` VALUES (8,1,'section3','2020-04-12 15:54:35',1,'2020-04-12 15:54:35',1),(9,1,'seccion 5','2020-04-12 16:15:38',1,'2020-04-12 16:15:38',1);

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `idStudent` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `lastName` varchar(500) DEFAULT NULL,
  `idDocumentType` int(11) DEFAULT NULL,
  `document` varchar(45) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `password` varchar(500) DEFAULT NULL,
  `idCountry` int(11) DEFAULT NULL,
  `address` varchar(500) DEFAULT NULL,
  `telephone` varchar(45) DEFAULT NULL,
  `phone` varchar(45) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `is_active` tinyint(4) DEFAULT NULL,
  `api_token` text DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`idStudent`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `students`
--

INSERT INTO `students` VALUES (1,'Deryam','Hermosilla',1,'22222222','estudiante@email.com','$2y$10$QhOFPBcCDkj0ckvESJihAuBQiIJeG/ZUl/9nrC4FS2DLRqRBBvqfm',1,'','','51956359559','2020-03-21 05:56:04',1,'2020-04-05 15:46:30',1,1,'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsImp0aSI6ImUzZTE4ZGZhNTg5OGFhMThhZTQ1YzAwZWZmYWE2MmM0MWNlODM5ZTZjMDE1MzBlYTBkOWJjNGRlMjlmYjEzYzcxNjhmZWZmMDEyZjJmZWRjIn0.eyJhdWQiOiIzIiwianRpIjoiZTNlMThkZmE1ODk4YWExOGFlNDVjMDBlZmZhYTYyYzQxY2U4MzllNmMwMTUzMGVhMGQ5YmM0ZGUyOWZiMTNjNzE2OGZlZmYwMTJmMmZlZGMiLCJpYXQiOjE1ODYxMTk1ODgsIm5iZiI6MTU4NjExOTU4OCwiZXhwIjoxNjE3NjU1NTg4LCJzdWIiOiIxIiwic2NvcGVzIjpbXX0.MWg0hXBWQiKwOU2zME1bAru0Mto-I3P0nO_WDI9-LlYg5FRBpY3ZcHqG6RkA8Fc6S4OTJbxLYoDL_bvxFUoD2KsDHBlXJpFMq-9xiNg15pK3AvSGNOmvyMzp32uugw-R5AcjVtIeBNdDzsFI55Nhl6BfzxpusA5lGVPeqomQVGdsTdkH04A_5QgkiyYuJQozMY6Lt0LrFwwtxhccmiT6azlBohEwwQyYOS-ASNL5ZPe9aFJabI6KYF10iOE7h0OxpwV-ZoCcqTZDba91hFkl_eya9l1fnr0glxMTL84O8zhWb4lPd-roq5NF1JmHlg3hA7s69SQFr-fLITDW0pbZYAfnSLazw2qDomhHJk2jnbYf4XaLLCscFP1cILLR8WvcdPAstmcS7fwNVAFflxRi1toMC5TB-mLcQ-uefEuh4y360U9u_7sRrpOP6JMmghth5-gi0lfRUX6RsdVKFnlBfZNa8YrQPhRp1F-9Z2a4vvOWSe98gkvJJCydvZXf8gmZck4fWEosOlMTitsw9Keg6oW0VZsMtMYvaGXymJvBTmjqNZMmJcg7-KoehKK-JYcEEXoSdvmjuzLByE2j9b1qib54qhvshkP_hjOgY3ZGQdBb2EOe02R1rbHQLzl_qJfaZhO8SP5QbFYH8bsPpSkfvyUXK728pAuJ-ZUjJDcBgxM','2021-04-05 15:46:30'),(6,'Lucho','morales',NULL,NULL,'lucho@gmail.com','eyJpdiI6IjVmWXNIOXZrV1wvcjhtdEtwRDNOaWR3PT0iLCJ2YWx1ZSI6ImZcL2tidDRUN3d1SldqREFpODAzNnVBPT0iLCJtYWMiOiJkYWY4MmE0NmRiNTFhZmFhYTc0NmI3MmMzNjU4ZDJlMmIwYTJlNmUzZmY5YzVhNGZkNWE3YmZjMzE2MDA0ZDFkIn0=',NULL,NULL,NULL,'123456789','2020-03-21 19:40:42',1,'2020-03-21 19:40:42',1,1,NULL,NULL),(7,'Luch','Morales Segobia',NULL,NULL,'luchoms09@gmail.com','eyJpdiI6InM4MWVweHdaa3hnSWtWU3dCR0E5M2c9PSIsInZhbHVlIjoieGVtbGx1STZFMFBiaGRyaFNUbTM2UT09IiwibWFjIjoiNzJkZGEzYjY3ZDdlMjA5OWM4NzMxZjUwNmMyYTE5MmU4YTFiZDQxMDM0NmIyYzIwYjllODI5MjZhZDEwODQxMyJ9',NULL,NULL,NULL,'929430274','2020-03-22 00:09:46',1,'2020-03-22 00:09:46',1,1,NULL,NULL);

--
-- Table structure for table `teachers`
--

CREATE TABLE `teachers` (
  `idTeacher` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `lastName` varchar(500) DEFAULT NULL,
  `idDocumentType` int(11) DEFAULT NULL,
  `document` varchar(45) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `password` varchar(500) DEFAULT NULL,
  `idCountry` int(11) DEFAULT NULL,
  `address` varchar(500) DEFAULT NULL,
  `telephone` varchar(45) DEFAULT NULL,
  `phone` varchar(45) DEFAULT NULL,
  `experiences` text DEFAULT NULL,
  `achievements` text DEFAULT NULL,
  `accountInformation` varchar(500) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `is_active` tinyint(4) DEFAULT NULL,
  `api_token` text DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`idTeacher`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `teachers`
--

INSERT INTO `teachers` VALUES (1,'Ciro','Alegria',1,'11111111','docente@email.com','$2y$10$USGYu7hhbdD7cjAKjL9LDewZaSYg22yQTXQhHRT8qu0Aiyrf1dJcG',1,'','','',NULL,NULL,'Recuerda antes de acudir a cualquier sucursal bancaria, debes de verificar qué datos necesitas para hacer el deposito; como recomendación personal, anota en un papel los datos que necesitas para hacer el depósito (número de cuenta, nombre de la persona o institución, monto a depositar) y verifica cada dígito del número de cuenta o mejor utiliza la banca en línea.','2020-03-21 05:56:04',1,'2020-04-12 15:44:34',1,1,'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsImp0aSI6ImNhOTFiNWViNTgzYzJhZDllM2M0ZmE1NmM1NWI2NjYyMmZmMWFkOTM4NDI5OTcxYjZlN2QwZTQ0OTMzMzY4OWI3MmI0YTNjYzg3MTM4N2YwIn0.eyJhdWQiOiIzIiwianRpIjoiY2E5MWI1ZWI1ODNjMmFkOWUzYzRmYTU2YzU1YjY2NjIyZmYxYWQ5Mzg0Mjk5NzFiNmU3ZDBlNDQ5MzMzNjg5YjcyYjRhM2NjODcxMzg3ZjAiLCJpYXQiOjE1ODY3MjQyNzMsIm5iZiI6MTU4NjcyNDI3MywiZXhwIjoxNjE4MjYwMjczLCJzdWIiOiIxIiwic2NvcGVzIjpbXX0.lLVjpVw_8LtuXM22BxitL4R30X37Ur3TfyypGDUZ8VBIxAWsjs3SaOonRQ6n_fOcZ6KtQp_sydsFqoh4rj22xoIQxv-ERYNmDVv55E6Ip0wZguMjGzip7JN2jtfjnXCRsdWgQIcTopGq9gYN1Q5uIDBaZjK3S7WKRQ2mnInY_KzL7tM1l-J5x9ae8jmkJtPb2rEBDH1G2j2phyWYFpXyz-znviSP4BY9WNO7WDf3XJD2o9rS7_BfDP5aGjD7V2rFV-tioNFIvCRntearhWzSGfNVqhQscjW5oO8I0p-FZEfIywc25PK3REx6h8wlE8r9PHdI4doutf0qXHp5nQDPTYtLW65hRzhti1Fup1GS74Xxzn5gdKJS6UqiYiw2WuSG8nCh_Q6JLu9Sap5FIkTR8DHx0Fp5jtLyDENNbQob03DUILAYwtXsLdXUuU2S7UlVHaKwCNwGpseH-UuHhCqp_CgmzTorjaxUbkVJNGugI5pxW8A2CQeh20hYG4DYwad324ul_Y-x6jbRGLl9hBuQGRyyGTWxgI6DYi8Hih0vPzVcWWJkSZMJXB75_So47bWWuU4cotS2HsEKg6mfkm2-lg6IUnQdREL0KoxK5EgZ3883ExJN4mSnYRRiX91LGchcJenbKeU3X5FXwE84RDasnbbHCSpg47ELbmrfEjNRCpE','2021-04-12 15:44:34');


