(2267,'sharon.tan1@ibm.com\'s 09/29/2021 test','sharon.tan1@ibm.com\'s 09/29/2021 Test',0,NULL,'2021-09-28 00:00:00','2022-09-29 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-09-29 08:45:59','2021-09-29 08:45:59',5,0.00,0),(2268,'sharon.tan1@ibm.com\'s 09/29/2021 test','sharon.tan1@ibm.com\'s 09/29/2021 Test',0,NULL,'2021-09-28 00:00:00','2022-09-29 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-09-29 08:50:33','2021-09-29 08:50:33',5,0.00,0),(2269,'sharon.tan1@ibm.com\'s 09/29/2021 test','sharon.tan1@ibm.com\'s 09/29/2021 Test',0,NULL,'2021-09-28 00:00:00','2022-09-29 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-09-29 08:57:22','2021-09-29 08:57:22',5,0.00,0),(2270,'sharon.tan1@ibm.com\'s 10/14/2021 test','sharon.tan1@ibm.com\'s 10/14/2021 Test',0,NULL,'2021-10-13 00:00:00','2022-10-14 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-10-14 07:41:26','2021-10-14 07:47:34',5,500.00,2),(2271,'sharon.tan1@ibm.com\'s 10/14/2021 test','sharon.tan1@ibm.com\'s 10/14/2021 Test',0,NULL,'2021-10-13 00:00:00','2022-10-14 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-10-14 07:47:52','2021-10-14 07:47:52',5,0.00,0),(2272,'sharon.tan1@ibm.com\'s 10/14/2021 test','sharon.tan1@ibm.com\'s 10/14/2021 Test',0,NULL,'2021-10-13 00:00:00','2022-10-14 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-10-14 07:52:42','2021-10-14 07:52:42',5,0.00,0),(2273,'sharon.tan1@ibm.com\'s 10/14/2021 test','sharon.tan1@ibm.com\'s 10/14/2021 Test',0,NULL,'2021-10-13 00:00:00','2022-10-14 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-10-14 07:57:13','2021-10-14 07:57:13',5,0.00,0),(2274,'sharon.tan1@ibm.com\'s 10/14/2021 test','sharon.tan1@ibm.com\'s 10/14/2021 Test',0,NULL,'2021-10-13 00:00:00','2022-10-14 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-10-14 07:58:56','2021-10-14 07:58:56',5,0.00,0),(2275,'sharon.tan1@ibm.com\'s 10/14/2021 test','sharon.tan1@ibm.com\'s 10/14/2021 Test',0,NULL,'2021-10-13 00:00:00','2022-10-14 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-10-14 08:00:29','2021-10-14 08:00:29',5,0.00,0),(2276,'sharon.tan1@ibm.com\'s 10/14/2021 test','sharon.tan1@ibm.com\'s 10/14/2021 Test',0,NULL,'2021-10-13 00:00:00','2022-10-14 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-10-14 08:02:38','2021-10-14 08:07:11',5,500.00,4),(2277,'sharon.tan1@ibm.com\'s 10/14/2021 test','sharon.tan1@ibm.com\'s 10/14/2021 Test',0,NULL,'2021-10-13 00:00:00','2022-10-14 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-10-14 08:07:29','2021-10-14 08:08:43',5,500.00,1),(2278,'sharon.tan1@ibm.com\'s 10/14/2021 test','sharon.tan1@ibm.com\'s 10/14/2021 Test',0,NULL,'2021-10-13 00:00:00','2022-10-14 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-10-14 08:10:07','2021-10-14 08:10:07',5,0.00,0),(2279,'sharon.tan1@ibm.com\'s 10/14/2021 test','sharon.tan1@ibm.com\'s 10/14/2021 Test',0,NULL,'2021-10-13 00:00:00','2022-10-14 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-10-14 08:14:11','2021-10-14 08:14:11',5,0.00,0),(2280,'sharon.shiling.tan@gmail.com\'s 11/26/2021 test','sharon.shiling.tan@gmail.com\'s 11/26/2021 Test',0,NULL,'2021-11-25 00:00:00','2022-11-26 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-26 06:16:48','2021-11-26 06:16:48',6,0.00,0),(2281,'sharon.tan1@ibm.com\'s 11/26/2021 test','sharon.tan1@ibm.com\'s 11/26/2021 Test',0,NULL,'2021-11-25 00:00:00','2022-11-26 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-26 06:50:34','2021-11-26 06:51:14',5,500.00,1),(2282,'sharon.tan1@ibm.com\'s 11/26/2021 test','sharon.tan1@ibm.com\'s 11/26/2021 Test',0,NULL,'2021-11-25 00:00:00','2022-11-26 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-26 06:55:09','2021-11-26 06:55:09',5,0.00,0),(2283,'sharon.tan1@ibm.com\'s 11/26/2021 test','sharon.tan1@ibm.com\'s 11/26/2021 Test',0,NULL,'2021-11-25 00:00:00','2022-11-26 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-26 07:02:12','2021-11-26 07:02:12',5,0.00,0),(2284,'sharon.tan1@ibm.com\'s 11/26/2021 test','sharon.tan1@ibm.com\'s 11/26/2021 Test',0,NULL,'2021-11-25 00:00:00','2022-11-26 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-26 07:10:34','2021-11-26 07:10:34',5,0.00,0),(2285,'sharon.tan1@ibm.com\'s 11/26/2021 test','sharon.tan1@ibm.com\'s 11/26/2021 Test',0,NULL,'2021-11-25 00:00:00','2022-11-26 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-26 07:20:04','2021-11-26 07:20:04',5,0.00,0),(2286,'sharon.tan1@ibm.com\'s 11/26/2021 test','sharon.tan1@ibm.com\'s 11/26/2021 Test',0,NULL,'2021-11-25 00:00:00','2022-11-26 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-26 07:29:44','2021-11-26 07:29:45',5,0.00,0),(2287,'sharon.tan1@ibm.com\'s 11/26/2021 test','sharon.tan1@ibm.com\'s 11/26/2021 Test',0,NULL,'2021-11-25 00:00:00','2022-11-26 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-26 07:33:54','2021-11-30 05:54:03',5,500.00,5),(2288,'sharon.tan1@ibm.com\'s 11/30/2021 test','sharon.tan1@ibm.com\'s 11/30/2021 Test',0,NULL,'2021-11-29 00:00:00','2022-11-30 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-30 05:58:37','2021-11-30 06:03:46',6,600.00,3),(2289,'sharon.tan1@ibm.com\'s 11/30/2021 test','sharon.tan1@ibm.com\'s 11/30/2021 Test',0,NULL,'2021-11-29 00:00:00','2022-11-30 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-30 06:10:06','2021-11-30 06:10:06',6,0.00,0),(2290,'sharon.tan1@ibm.com\'s 11/30/2021 test','sharon.tan1@ibm.com\'s 11/30/2021 Test',0,NULL,'2021-11-29 00:00:00','2022-11-30 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-30 06:13:07','2021-11-30 06:13:07',6,0.00,0),(2291,'sharon.tan1@ibm.com\'s 11/30/2021 test','sharon.tan1@ibm.com\'s 11/30/2021 Test',0,NULL,'2021-11-29 00:00:00','2022-11-30 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-30 06:15:46','2021-11-30 06:15:47',6,0.00,0),(2292,'sharon.shiling.tan@gmail.com\'s 11/30/2021 test','sharon.shiling.tan@gmail.com\'s 11/30/2021 Test',0,NULL,'2021-11-29 00:00:00','2022-11-30 00:00:00','0000-00-00 00:00:00',2,'highest',1,2,'2021-11-30 06:25:38','2021-11-30 06:25:38',6,0.00,0);

--
-- Table structure for table `track_track`
--

CREATE TABLE `track_track` (
  `preReq_track_id` int(10) unsigned NOT NULL,
  `track_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`preReq_track_id`,`track_id`),
  KEY `track_track_track_id_foreign` (`track_id`),
  CONSTRAINT `track_track_prereq_track_id_foreign` FOREIGN KEY (`preReq_track_id`) REFERENCES `tracks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `track_track_track_id_foreign` FOREIGN KEY (`track_id`) REFERENCES `tracks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `track_track`
--

INSERT INTO `track_track` VALUES (1,2,'2018-05-03 21:17:14','2018-05-03 21:17:14'),(2,3,'2018-05-03 21:17:14','2018-05-03 21:17:14'),(3,4,'2018-05-03 21:17:14','2018-05-03 21:17:14'),(4,5,'2018-05-03 21:17:14','2018-05-03 21:17:14'),(5,6,'2018-05-03 21:17:14','2018-05-03 21:17:14'),(6,7,'2018-05-03 21:17:14','2018-05-03 21:17:14');

--
-- Table structure for table `track_user`
--

CREATE TABLE `track_user` (
  `track_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `track_maxile` decimal(6,2) NOT NULL DEFAULT '0.00',
  `track_passed` tinyint(1) NOT NULL DEFAULT '0',
  `track_test_date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`track_id`,`user_id`),
  KEY `track_user_user_id_foreign` (`user_id`),
  CONSTRAINT `track_user_track_id_foreign` FOREIGN KEY (`track_id`) REFERENCES `tracks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `track_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `track_user`
--

INSERT INTO `track_user` VALUES (1,320,200.00,1,'2021-09-10 03:41:09','2021-09-09 09:00:32','2021-09-10 03:41:09'),(2,320,0.00,0,'2021-09-10 03:41:09','2021-09-09 09:00:32','2021-09-10 03:41:09'),(3,320,200.00,1,'2021-09-10 03:41:09','2021-09-09 09:00:32','2021-09-10 03:41:09'),(4,320,200.00,1,'2021-09-10 03:41:09','2021-09-09 09:00:32','2021-09-10 03:41:09'),(5,320,0.00,0,'2021-09-10 03:41:09','2021-09-09 09:00:32','2021-09-10 03:41:09'),(6,320,0.00,0,'2021-09-10 03:42:09','2021-09-09 09:00:32','2021-09-10 03:42:09'),(7,320,200.00,1,'2021-09-10 03:42:09','2021-09-09 09:00:32','2021-09-10 03:42:09'),(8,320,200.00,1,'2021-09-10 03:42:09','2021-09-09 09:00:32','2021-09-10 03:42:09'),(9,320,300.00,1,'2021-09-10 03:47:09','2021-09-10 03:44:50','2021-09-10 03:47:09'),(10,320,300.00,1,'2021-09-10 07:54:16','2021-09-10 03:44:50','2021-09-10 07:54:16'),(11,320,300.00,1,'2021-09-10 03:51:36','2021-09-10 03:44:50','2021-09-10 03:51:36'),(12,320,300.00,1,'2021-09-10 04:22:01','2021-09-10 03:44:50','2021-09-10 04:22:01'),(13,320,0.00,0,'2021-09-16 08:55:07','2021-09-10 03:44:50','2021-09-16 08:55:07'),(14,320,300.00,1,'2021-09-10 08:09:27','2021-09-10 03:44:50','2021-09-10 08:09:27'),(15,320,0.00,0,'2021-09-16 08:54:28','2021-09-10 03:44:50','2021-09-16 08:54:28'),(16,320,300.00,1,'2021-09-16 08:50:03','2021-09-10 03:44:50','2021-09-16 08:50:03'),(17,319,0.00,0,'2021-08-21 22:41:56','2021-08-20 06:33:10','2021-08-21 22:41:56'),(17,320,0.00,0,NULL,'2021-09-10 03:44:50','2021-09-10 03:44:50'),(18,319,0.00,0,'2021-08-21 22:39:57','2021-08-20 06:33:10','2021-08-21 22:39:57'),(18,320,0.00,0,NULL,'2021-09-10 03:44:50','2021-09-10 03:44:50'),(19,319,0.00,0,'2021-08-21 22:50:01','2021-08-20 06:33:10','2021-08-21 22:50:01'),(19,320,0.00,0,NULL,'2021-09-10 03:44:50','2021-09-10 03:44:50'),(20,320,400.00,1,'2021-09-16 09:06:47','2021-09-16 08:55:18','2021-09-16 09:06:47'),(21,320,400.00,1,'2021-09-22 08:16:19','2021-09-16 08:55:18','2021-09-22 08:16:19'),(22,320,400.00,1,'2021-09-22 08:26:42','2021-09-16 08:55:18','2021-09-22 08:26:42'),(23,320,0.00,0,'2021-09-23 09:19:52','2021-09-16 08:55:18','2021-09-23 09:19:52'),(24,320,0.00,0,'2021-09-23 09:19:25','2021-09-16 08:55:18','2021-09-23 09:19:25'),(25,320,400.00,1,'2021-09-22 08:55:25','2021-09-16 08:55:18','2021-09-22 08:55:25'),(26,320,400.00,1,'2021-09-22 08:58:56','2021-09-16 08:55:18','2021-09-22 08:58:56'),(27,320,400.00,1,'2021-09-22 09:02:29','2021-09-16 08:55:18','2021-09-22 09:02:29'),(28,320,0.00,0,'2021-09-23 09:18:18','2021-09-16 08:55:18','2021-09-23 09:18:18'),(29,2,0.00,0,NULL,'2021-08-15 09:18:28','2021-08-15 09:18:28'),(29,194,0.00,0,'2021-08-11 23:03:49','2020-09-04 02:12:27','2021-08-11 23:03:49'),(29,319,0.00,0,NULL,'2021-08-21 22:50:44','2021-08-21 22:50:44'),(29,320,0.00,0,NULL,'2021-09-16 08:55:18','2021-09-16 08:55:18'),(30,2,0.00,0,NULL,'2021-08-15 09:18:28','2021-08-15 09:18:28'),(30,194,400.00,1,'2021-08-05 23:25:48','2020-09-04 02:40:17','2021-08-05 23:25:48'),(30,319,0.00,0,NULL,'2021-08-21 22:50:44','2021-08-21 22:50:44'),(30,320,0.00,0,NULL,'2021-09-16 08:55:18','2021-09-16 08:55:18'),(31,2,0.00,0,NULL,'2021-08-15 09:18:28','2021-08-15 09:18:28'),(31,194,400.00,1,'2021-08-12 22:57:47','2020-09-04 00:48:49','2021-08-12 22:57:47'),(31,319,0.00,0,NULL,'2021-08-21 22:50:44','2021-08-21 22:50:44'),(31,320,0.00,0,NULL,'2021-09-16 08:55:18','2021-09-16 08:55:18'),(32,320,0.00,0,'2021-10-14 08:07:11','2021-09-29 07:58:23','2021-10-14 08:07:11'),(33,320,0.00,0,'2021-11-30 05:58:21','2021-09-23 09:20:02','2021-11-30 05:58:21'),(34,320,500.00,1,'2021-09-29 07:46:28','2021-09-23 09:20:02','2021-09-29 07:46:28'),(35,320,500.00,1,'2021-10-14 08:00:51','2021-09-23 09:20:02','2021-10-14 08:00:51'),(36,320,500.00,1,'2021-10-14 08:09:26','2021-09-23 09:20:02','2021-10-14 08:09:26'),(37,320,500.00,1,'2021-10-14 08:08:43','2021-09-23 09:20:02','2021-10-14 08:08:43'),(38,320,500.00,1,'2021-11-26 06:52:30','2021-09-23 09:20:02','2021-11-26 06:52:30'),(39,320,500.00,1,'2021-11-26 07:01:05','2021-09-29 07:58:23','2021-11-26 07:01:05'),(40,320,500.00,1,'2021-11-26 07:15:55','2021-09-23 09:20:02','2021-11-26 07:15:55'),(41,320,500.00,1,'2021-11-26 07:28:58','2021-09-23 09:20:02','2021-11-26 07:28:58'),(42,320,0.00,0,'2021-11-30 05:40:47','2021-09-29 07:58:23','2021-11-30 05:40:47'),(43,319,500.00,1,'2021-09-23 09:15:11','2021-09-13 09:49:12','2021-09-23 09:15:11'),(43,320,0.00,0,NULL,'2021-09-23 09:20:02','2021-09-23 09:20:02'),(44,84,0.00,0,NULL,'2019-11-04 00:29:10','2019-11-04 00:29:10'),(44,112,0.00,0,NULL,'2019-10-01 06:45:20','2019-10-01 06:45:20'),(44,115,0.00,0,NULL,'2020-01-31 17:27:40','2020-01-31 17:27:40'),(44,126,0.00,0,NULL,'2019-07-21 03:09:20','2019-07-21 03:09:20'),(44,149,0.00,0,NULL,'2019-06-19 13:13:15','2019-06-19 13:13:15'),(44,152,0.00,0,NULL,'2019-07-24 07:37:31','2019-07-24 07:37:31'),(44,155,0.00,0,NULL,'2019-09-18 14:15:14','2019-09-18 14:15:14'),(44,159,0.00,0,NULL,'2020-02-24 09:58:44','2020-02-24 09:58:44'),(44,164,0.00,0,NULL,'2020-02-02 06:20:45','2020-02-02 06:20:45'),(44,167,0.00,0,NULL,'2020-04-19 05:35:18','2020-04-19 05:35:18'),(44,174,0.00,0,NULL,'2020-01-27 13:10:08','2020-01-27 13:10:08'),(44,180,0.00,0,NULL,'2020-02-08 04:13:04','2020-02-08 04:13:04'),(44,194,0.00,0,NULL,'2020-05-15 10:02:25','2020-05-15 10:02:25'),(44,197,0.00,0,NULL,'2020-08-21 07:23:17','2020-08-21 07:23:17'),(44,319,0.00,0,NULL,'2021-09-13 09:49:12','2021-09-13 09:49:12'),(44,320,0.00,0,NULL,'2021-09-23 09:20:02','2021-09-23 09:20:02'),(45,194,500.00,1,'2021-08-05 23:26:38','2020-05-15 10:02:25','2021-08-05 23:26:38'),(45,319,0.00,0,NULL,'2021-09-13 09:49:12','2021-09-13 09:49:12'),(45,320,0.00,0,NULL,'2021-09-23 09:20:02','2021-09-23 09:20:02'),(46,319,0.00,0,'2021-08-21 22:50:01','2021-08-21 22:50:01','2021-08-21 22:50:01'),(46,320,0.00,0,NULL,'2021-09-23 09:20:02','2021-09-23 09:20:02'),(47,319,600.00,1,'2021-11-30 06:57:28','2021-11-30 06:25:38','2021-11-30 06:57:28'),(48,319,0.00,0,'2021-11-30 06:57:02','2021-11-30 06:25:38','2021-11-30 06:57:02'),(49,319,0.00,0,NULL,'2021-11-30 06:25:38','2021-11-30 06:25:38'),(49,320,0.00,0,'2021-11-30 06:22:06','2021-11-30 05:58:37','2021-11-30 06:22:06'),(50,319,0.00,0,NULL,'2021-11-30 06:25:38','2021-11-30 06:25:38'),(50,320,0.00,0,'2021-11-30 06:21:32','2021-11-30 05:58:37','2021-11-30 06:21:32'),(51,319,600.00,1,'2021-09-29 07:58:24','2021-08-21 22:46:37','2021-09-29 07:58:24'),(51,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(52,319,600.00,1,'2021-10-14 08:11:54','2021-09-28 06:42:05','2021-10-14 08:11:54'),(52,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(53,319,600.00,1,'2021-09-29 08:09:55','2021-09-28 06:42:05','2021-09-29 08:09:55'),(53,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(54,319,600.00,1,'2021-11-26 06:44:31','2021-09-28 06:42:05','2021-11-26 06:44:31'),(54,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(55,113,0.00,0,NULL,'2019-02-21 13:16:01','2019-02-21 13:16:01'),(55,114,0.00,0,NULL,'2019-02-19 13:02:22','2019-02-19 13:02:22'),(55,115,0.00,0,NULL,'2019-02-20 10:18:47','2019-02-20 10:18:47'),(55,116,0.00,0,NULL,'2019-02-21 08:14:06','2019-02-21 08:14:06'),(55,117,0.00,0,NULL,'2019-02-20 03:59:34','2019-02-20 03:59:34'),(55,118,0.00,0,NULL,'2019-02-23 09:38:56','2019-02-23 09:38:56'),(55,119,0.00,0,NULL,'2019-02-22 10:24:55','2019-02-22 10:24:55'),(55,120,0.00,0,NULL,'2019-02-20 14:53:39','2019-02-20 14:53:39'),(55,121,0.00,0,NULL,'2019-02-21 07:04:07','2019-02-21 07:04:07'),(55,122,0.00,0,NULL,'2019-02-22 00:31:25','2019-02-22 00:31:25'),(55,123,0.00,0,NULL,'2019-02-22 05:37:45','2019-02-22 05:37:45'),(55,124,0.00,0,NULL,'2019-02-23 07:16:47','2019-02-23 07:16:47'),(55,126,0.00,0,NULL,'2019-08-04 03:14:07','2019-08-04 03:14:07'),(55,128,0.00,0,NULL,'2019-02-24 09:22:43','2019-02-24 09:22:43'),(55,130,0.00,0,NULL,'2019-02-25 18:54:11','2019-02-25 18:54:11'),(55,131,0.00,0,NULL,'2019-03-10 06:57:41','2019-03-10 06:57:41'),(55,132,0.00,0,NULL,'2019-03-11 09:06:12','2019-03-11 09:06:12'),(55,133,0.00,0,NULL,'2019-03-01 15:07:10','2019-03-01 15:07:10'),(55,144,0.00,0,NULL,'2019-05-21 13:02:53','2019-05-21 13:02:53'),(55,164,0.00,0,NULL,'2020-04-18 06:13:27','2020-04-18 06:13:27'),(55,194,0.00,0,NULL,'2020-05-18 02:06:11','2020-05-18 02:06:11'),(55,319,0.00,0,NULL,'2021-09-28 06:42:05','2021-09-28 06:42:05'),(55,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(56,194,600.00,1,'2021-08-10 00:45:30','2020-07-13 03:05:09','2021-08-10 00:45:30'),(56,319,0.00,0,NULL,'2021-09-28 06:42:05','2021-09-28 06:42:05'),(56,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(57,194,600.00,1,'2021-08-11 23:05:03','2020-07-15 04:56:51','2021-08-11 23:05:03'),(57,319,0.00,0,NULL,'2021-09-28 06:42:05','2021-09-28 06:42:05'),(57,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(58,194,0.00,0,'2021-08-02 23:04:57','2020-05-18 02:06:11','2021-08-02 23:04:57'),(58,319,0.00,0,NULL,'2021-09-28 06:42:05','2021-09-28 06:42:05'),(58,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(59,194,600.00,1,'2021-07-20 23:20:10','2020-05-18 02:06:11','2021-07-20 23:20:10'),(59,319,0.00,0,NULL,'2021-09-28 06:42:05','2021-09-28 06:42:05'),(59,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(60,194,600.00,1,'2021-08-07 23:14:39','2020-05-18 02:06:11','2021-08-07 23:14:39'),(60,319,0.00,0,NULL,'2021-09-28 06:42:05','2021-09-28 06:42:05'),(60,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(61,319,0.00,0,'2021-08-21 22:46:37','2021-08-21 22:46:37','2021-08-21 22:46:37'),(61,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(62,194,600.00,1,'2021-08-08 23:39:21','2020-05-18 02:06:11','2021-08-08 23:39:21'),(62,319,0.00,0,NULL,'2021-09-28 06:42:05','2021-09-28 06:42:05'),(62,320,0.00,0,NULL,'2021-11-30 05:58:37','2021-11-30 05:58:37'),(63,194,0.00,0,'2021-08-10 22:56:05','2020-08-02 23:34:00','2021-08-10 22:56:05'),(64,194,0.00,0,'2021-08-05 06:16:45','2020-08-02 23:34:00','2021-08-05 06:16:45'),(65,194,700.00,1,'2021-08-12 22:55:18','2020-08-02 23:34:00','2021-08-12 22:55:18'),(66,194,0.00,0,'2021-08-10 00:46:22','2020-08-02 23:34:00','2021-08-10 00:46:22'),(67,194,700.00,1,'2021-08-12 22:57:08','2020-08-02 23:34:00','2021-08-12 22:57:08'),(68,194,0.00,0,'2021-07-22 22:58:29','2020-08-02 23:34:00','2021-07-22 22:58:29'),(69,194,0.00,0,'2021-07-26 03:25:41','2020-08-02 23:34:00','2021-07-26 03:25:41'),(70,319,0.00,0,'2021-08-21 22:48:06','2021-08-21 22:48:06','2021-08-21 22:48:06'),(71,194,700.00,1,'2021-08-10 00:27:59','2020-08-02 23:34:00','2021-08-10 00:27:59'),(72,194,700.00,1,'2021-08-12 22:56:05','2020-08-02 23:34:00','2021-08-12 22:56:05'),(105,319,200.00,1,'2021-08-21 22:48:06','2021-08-20 06:20:19','2021-08-21 22:48:06'),(105,320,0.00,0,NULL,'2021-09-09 09:00:32','2021-09-09 09:00:32'),(111,320,200.00,1,'2021-09-10 03:42:09','2021-09-09 09:00:32','2021-09-10 03:42:09'),(112,320,200.00,1,'2021-09-10 03:42:09','2021-09-09 09:00:32','2021-09-10 03:42:09'),(113,320,200.00,1,'2021-09-10 03:43:01','2021-09-09 09:00:32','2021-09-10 03:43:01'),(114,320,200.00,1,'2021-09-10 03:43:01','2021-09-09 09:00:32','2021-09-10 03:43:01'),(115,320,200.00,1,'2021-09-10 03:43:01','2021-09-09 09:00:32','2021-09-10 03:43:01'),(116,320,200.00,1,'2021-09-10 03:43:01','2021-09-09 09:00:32','2021-09-10 03:43:01'),(117,320,200.00,1,'2021-09-10 03:43:01','2021-09-09 09:00:32','2021-09-10 03:43:01'),(118,320,200.00,1,'2021-09-10 03:44:03','2021-09-09 09:00:32','2021-09-10 03:44:03'),(119,320,200.00,1,'2021-09-10 03:44:03','2021-09-09 09:00:32','2021-09-10 03:44:03'),(120,320,0.00,0,'2021-09-10 03:44:03','2021-09-09 09:00:32','2021-09-10 03:44:03'),(121,320,200.00,1,'2021-09-10 03:44:03','2021-09-09 09:00:32','2021-09-10 03:44:03'),(122,320,200.00,1,'2021-09-10 03:44:03','2021-09-09 09:00:32','2021-09-10 03:44:03'),(123,320,200.00,1,'2021-09-10 03:44:27','2021-09-09 09:00:32','2021-09-10 03:44:27'),(124,2,0.00,0,NULL,'2021-08-15 09:11:19','2021-08-15 09:11:19'),(124,319,0.00,0,NULL,'2021-08-20 06:20:19','2021-08-20 06:20:19'),(124,320,0.00,0,NULL,'2021-09-09 09:00:32','2021-09-09 09:00:32'),(125,2,0.00,0,NULL,'2021-08-15 09:11:19','2021-08-15 09:11:19'),(125,319,0.00,0,NULL,'2021-08-20 06:20:19','2021-08-20 06:20:19'),(125,320,0.00,0,NULL,'2021-09-09 09:00:32','2021-09-09 09:00:32'),(126,2,0.00,0,NULL,'2021-08-15 09:11:19','2021-08-15 09:11:19'),(126,319,0.00,0,NULL,'2021-08-20 06:20:19','2021-08-20 06:20:19'),(126,320,0.00,0,NULL,'2021-09-09 09:00:32','2021-09-09 09:00:32'),(127,2,0.00,0,NULL,'2021-08-15 09:11:19','2021-08-15 09:11:19'),(127,319,0.00,0,NULL,'2021-08-20 06:20:19','2021-08-20 06:20:19'),(127,320,0.00,0,NULL,'2021-09-09 09:00:32','2021-09-09 09:00:32'),(128,320,0.00,0,'2021-09-10 03:44:27','2021-09-09 09:00:32','2021-09-10 03:44:27'),(129,320,0.00,0,'2021-09-10 03:44:27','2021-09-09 09:00:32','2021-09-10 03:44:27'),(130,2,0.00,0,NULL,'2021-08-15 09:11:19','2021-08-15 09:11:19'),(130,319,0.00,0,NULL,'2021-08-20 06:20:19','2021-08-20 06:20:19'),(130,320,0.00,0,NULL,'2021-09-09 09:00:32','2021-09-09 09:00:32');

--
-- Table structure for table `tracks`
--

CREATE TABLE `tracks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `track` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '1',
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status_id` int(10) unsigned NOT NULL DEFAULT '1',
  `field_id` int(10) unsigned NOT NULL,
  `level_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tracks_user_id_foreign` (`user_id`),
  KEY `tracks_status_id_foreign` (`status_id`),
  KEY `tracks_field_id_foreign` (`field_id`),
  KEY `tracks_level_id_foreign` (`level_id`),
  CONSTRAINT `tracks_field_id_foreign` FOREIGN KEY (`field_id`) REFERENCES `fields` (`id`),
  CONSTRAINT `tracks_level_id_foreign` FOREIGN KEY (`level_id`) REFERENCES `levels` (`id`),
  CONSTRAINT `tracks_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`),
  CONSTRAINT `tracks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tracks`
--

INSERT INTO `tracks` VALUES (1,'Numbers up to 100','Numbers up to 100',1,NULL,3,1,2,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(2,'Addition and Subtraction to 100','Addition and Subtraction to 100',1,NULL,3,1,2,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(3,'Multiplication and Division to 100','Multiplication and Division to 100',1,NULL,3,1,2,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(4,'Money Year 1','Money Year 1',1,NULL,3,6,2,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(5,'Length Year 1','Length Year 1',1,NULL,3,6,2,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(6,'Time Year 1','Time Year 1',1,NULL,3,6,2,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(7,'2D Shapes','2D Shapes',1,NULL,3,7,2,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(8,'Picture Graphs','Picture Graphs',1,NULL,3,5,2,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(9,'Numbers up to 1000','Numbers up to 1000',1,NULL,3,1,3,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(10,'Addition and Subtraction to 1000','Addition and Subtraction to 1000',1,NULL,3,1,3,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(11,'Multiplication and Division to 1000','Multiplication and Division to 1000',1,NULL,3,1,3,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(12,'Fraction of a Whole','Fraction of a Whole',1,NULL,3,1,3,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(13,'Addition and Subtraction of fraction of a whole','Addition and Subtraction of fraction of a whole',1,NULL,3,1,3,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(14,'Money Year 2','Money Year 2',1,NULL,3,6,3,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(15,'Length, Mass Volume','Length, Mass Volume',1,NULL,3,6,3,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(16,'Time Year 2','Time Year 2',1,NULL,3,6,3,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(17,'2D Shapes Year 2','2D Shapes Year 2',1,NULL,3,7,3,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(18,'3D Shapes','3D Shapes',1,NULL,3,7,3,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(19,'Picture Graphs with Scales','Picture Graphs with Scales',1,NULL,3,5,3,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(20,'Numbers up to 10000','Numbers up to 10000',1,NULL,3,1,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(21,'Addition and Subtraction to 10000','Addition and Subtraction to 10000',1,NULL,3,1,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(22,'Multiplication and Dvision to 10000','Multiplication and Dvision to 10000',1,NULL,3,1,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(23,'Equivalent Fractions','Equivalent Fractions',1,NULL,3,1,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(24,'Addition and Subtraction of equivalent fractions','Addition and Subtraction of equivalent fractions',1,NULL,3,1,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(25,'Money Year 3','Money Year 3',1,NULL,3,6,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(26,'Length, Mass and Volume Year 3','Length, Mass and Volume Year 3',1,NULL,3,6,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(27,'Time Year 3','Time Year 3',1,NULL,3,6,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(28,'Area and Perimeter','Area and Perimeter',1,NULL,3,7,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(29,'Angles Year 3','Angles Year 3',1,NULL,3,7,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(30,'Perpendicular and Parallel Lines','Perpendicular and Parallel Lines',1,NULL,3,7,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(31,'Bar Graphs','Bar Graphs',1,NULL,3,5,4,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(32,'Numbers up to 100000','Numbers up to 100000',1,NULL,3,1,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(33,'Factors and Multiples','Factors and Multiples',1,NULL,3,1,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(34,'Four Operations','Four Operations',1,NULL,3,1,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(35,'Mixed Numbers and Improper Fractions','Mixed Numbers and Improper Fractions',1,NULL,3,1,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(36,'Fraction of a Set of Objects','Fraction of a Set of Objects',1,NULL,3,1,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(37,'Addition and subtraction of fractions','Addition and subtraction of fractions',1,NULL,3,1,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(38,'Decimals up to 3 decimal places','Decimals up to 3 decimal places',1,NULL,3,1,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(39,'Addition and Subtraction of Decimals','Addition and Subtraction of Decimals',1,NULL,3,1,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(40,'Multiplication and Division of decimals','Multiplication and Division of decimals',1,NULL,3,1,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(41,'Time Year 4','Time Year 4',1,NULL,3,6,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(42,'Area and Perimeter Year 4','Area and Perimeter Year 4',1,NULL,3,7,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(43,'Angles Year 4','Angles Year 4',1,NULL,3,7,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(44,'Rectangle and Square','Rectangle and Square',1,NULL,3,7,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(45,'Line Symmetry','Line Symmetry',1,NULL,3,7,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(46,'Tables and Line Graphs','Tables and Line Graphs',1,NULL,3,5,5,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(47,'Numbers up to 10\nmillion \nFour Operations','Numbers up to 10\nmillion \nFour Operations',1,NULL,3,1,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(48,'Four Operations to 10 million','Four Operations to 10 million',1,NULL,3,1,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(49,'Order of Operations to 10 million','Order of Operations to 10 million',1,NULL,3,1,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(50,'Concept of fraction as division','Concept of fraction as division',1,NULL,3,1,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(51,'Four operations of fractions','Four operations of fractions',1,NULL,3,1,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(52,'Four operations of decimals','Four operations of decimals',1,NULL,3,1,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(53,'Percentage Year 5','Percentage Year 5',1,NULL,3,1,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(54,'Ratio Year 5','Ratio Year 5',1,NULL,3,1,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(55,'Length, mass and volume Year 5','Length, mass and volume Year 5',1,NULL,3,6,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(56,'Area of triangle','Area of triangle',1,NULL,3,6,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(57,'Volume of cube and cuboid Year 5','Volume of cube and cuboid Year 5',1,NULL,3,6,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(58,'Angles Year 5','Angles Year 5',1,NULL,3,7,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(59,'Triangles','Triangles',1,NULL,3,7,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(60,'Parallelogram, rhombus and trapezium','Parallelogram, rhombus and trapezium',1,NULL,3,7,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(61,'Average of a set of data','Average of a set of data',1,NULL,3,5,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(62,'Four operations of fractions Year 6','Four operations of fractions Year 6',1,NULL,3,1,6,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(63,'Percentage Year 6','Percentage Year 6',1,NULL,3,1,7,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(64,'Ratio Year 6','Ratio Year 6',1,NULL,3,1,7,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(65,'Speed','Speed',1,NULL,3,3,7,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(66,'Area and circumference of circle','Area and circumference of circle',1,NULL,3,6,7,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(67,'Area and perimeter of composite figure','Area and perimeter of composite figure',1,NULL,3,6,7,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(68,'Volume of cube and cuboid Year 6','Volume of cube and cuboid Year 6',1,NULL,3,6,7,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(69,'Geometrical Figures','Geometrical Figures',1,NULL,3,7,7,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(70,'Nets','Nets',1,NULL,3,7,7,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(71,'Pie charts','Pie charts',1,NULL,3,5,7,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(72,'Algebraic expessions in one variable','Algebraic expessions in one variable',1,NULL,3,2,7,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(73,'Operations with signed numbers','Operations with signed numbers',1,NULL,3,1,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(74,'Mathematical properties','Mathematical properties',1,NULL,3,1,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(75,'Variable and Formulas','Variable and Formulas',1,NULL,3,1,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(76,'Monomials and polynomials','Monomials and polynomials',1,NULL,3,2,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(77,'Basic operations with monomials and polynomials','Basic operations with monomials and polynomials',1,NULL,3,2,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(78,'Multiplying binomials','Multiplying binomials',1,NULL,3,2,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(79,'Dividing Monomials','Dividing Monomials',1,NULL,3,2,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(80,'Dividing Polynomials','Dividing Polynomials',1,NULL,3,2,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(81,'Equations with one Unknown','Equations with one Unknown',1,NULL,3,2,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(82,'Simplying equations','Simplying equations',1,NULL,3,2,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(83,'Solving equations with 2 unknowns','Solving equations with 2 unknowns',1,NULL,3,2,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(84,'Inequalities and one unknown','Inequalities and one unknown',1,NULL,3,2,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(85,'The rectangular coordinate system','The rectangular coordinate system',1,NULL,3,2,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(86,'Graphing lines','Graphing lines',1,NULL,3,3,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(87,'The slope of a line','The slope of a line',1,NULL,3,3,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(88,'graphing linear equations','graphing linear equations',1,NULL,3,3,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(89,'Exponents','Exponents',1,NULL,3,1,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(90,'Roots','Roots',1,NULL,3,1,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(91,'The Pythagorean Theorem','The Pythagorean Theorem',1,NULL,3,1,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(92,'The basics of factoring','The basics of factoring',1,NULL,3,2,11,'2018-05-03 21:17:12','2018-05-03 21:17:12'),(93,'Quadratic Equations','Quadratic Equations',1,NULL,3,2,11,'2018-05-03 21:17:13','2018-05-03 21:17:13'),(94,'Algebra Introducation','Algebra Introducation',1,NULL,3,2,11,'2018-05-03 21:17:13','2018-05-03 21:17:13'),(95,'Algebraic fractions','Algebraic fractions',1,NULL,3,2,11,'2018-05-03 21:17:13','2018-05-03 21:17:13'),(96,'Multiplying fractions','Multiplying fractions',1,NULL,3,1,11,'2018-05-03 21:17:13','2018-05-03 21:17:13'),(97,'Dividing fractions','Dividing fractions',1,NULL,3,1,11,'2018-05-03 21:17:13','2018-05-03 21:17:13'),(98,'Like and unlike fractions','Like and unlike fractions',1,NULL,3,1,11,'2018-05-03 21:17:13','2018-05-03 21:17:13'),(99,'Adding and subtracting fractions','Adding and subtracting fractions',1,NULL,3,1,11,'2018-05-03 21:17:13','2018-05-03 21:17:13'),(100,'Complex Fractions','Complex Fractions',1,NULL,3,1,11,'2018-05-03 21:17:13','2018-05-03 21:17:13'),(101,'Linear Equations and Containing  Fractions','Linear Equations and Containing  Fractions',1,NULL,3,2,11,'2018-05-03 21:17:13','2018-05-03 21:17:13'),(102,'THis is a new track','A new descriptioin',4,NULL,1,9,12,'2018-05-05 03:03:55','2018-05-05 03:04:14'),(103,'Operations with signed numbers',NULL,4,NULL,3,1,12,'2018-05-07 01:30:16','2018-05-07 01:30:16'),(104,'Operational',NULL,4,NULL,3,1,12,'2018-05-07 01:32:34','2018-05-07 01:32:34'),(105,'Numbers up to 100',NULL,58,NULL,1,1,2,'2018-10-07 21:04:24','2018-10-07 21:04:24'),(109,'Track 2','Track 2',69,NULL,1,2,1,'2019-04-22 02:25:54','2019-04-22 02:25:54'),(111,'K1T1W1','K1T1 Week 1 track',4,NULL,3,1,2,'2020-09-16 09:09:30','2020-09-16 14:47:17'),(112,'K1T1W2','K1T1 Week 2 track',41,NULL,3,1,2,'2020-09-16 14:48:24','2020-09-16 14:48:24'),(113,'K1T1W3','K1 T1 Week 3 track',41,NULL,3,1,2,'2020-09-16 14:49:30','2020-09-16 14:49:30'),(114,'K1T1W4','K1 T1 Week 4 track',41,NULL,3,1,2,'2020-09-16 14:50:09','2020-09-16 14:50:09'),(115,'K1T1W5','K1 Term 1 Week 5 track',41,NULL,3,1,2,'2020-09-16 14:50:57','2020-09-16 14:50:57'),(116,'K1T1W6','K1 Term 1 Week 6 track',41,NULL,3,1,2,'2020-09-16 14:51:44','2020-09-16 14:51:44'),(117,'K1T1W7','K1 Term 1 Week 7 track',41,NULL,3,1,2,'2020-09-16 14:52:31','2020-09-16 14:52:31'),(118,'K1T1W8','K1 Term 1 Week 8 track',41,NULL,3,1,2,'2020-09-16 14:53:42','2020-09-16 14:53:42'),(119,'K1T1W9','K1 Term 1 week 9 track',41,NULL,3,1,2,'2020-09-16 14:54:25','2020-09-16 14:54:25'),(120,'K1T1W10','K1 Term 1 week 10 track',41,NULL,3,1,2,'2020-09-16 14:55:05','2020-09-16 14:55:05'),(121,'K1T1W11','K1 Term1 Week 11 track.   Bonus topic if progress is good.  Else revise previous tough topic',41,NULL,3,1,2,'2020-09-16 14:55:45','2020-09-16 14:58:02'),(122,'K1T1W12','K1 Term1 Week 12 track',41,NULL,3,1,2,'2020-09-16 14:56:28','2020-09-17 00:42:17'),(123,'Comparing and measuring lengths','Comparing, ordering and measuring, estimating length',41,NULL,3,1,2,'2020-12-10 16:00:55','2020-12-10 16:00:55'),(124,'Counting to 40','Counting to 40',41,NULL,3,1,2,'2020-12-10 16:11:45','2020-12-10 16:11:45'),(125,'Addition within 40 without regrouping','Addiiton within 40 without regrouping',41,NULL,3,1,2,'2020-12-10 16:12:52','2020-12-10 16:12:52'),(126,'Addition within 40 with regrouping','Addition within 40 with regrouping',41,NULL,3,1,2,'2020-12-10 16:13:51','2020-12-10 16:13:51'),(127,'Telling time','Telling time',41,NULL,3,1,2,'2020-12-10 16:14:47','2020-12-10 16:14:47'),(128,'Comparing and ordering within 40','Comparing and ordering within 40',41,NULL,3,1,2,'2020-12-10 16:15:58','2020-12-10 16:15:58'),(129,'Adding 3 numbers','Adding 3 numbers',41,NULL,3,1,2,'2020-12-10 16:16:35','2020-12-10 16:16:35'),(130,'Money','Money',41,NULL,3,1,2,'2020-12-10 16:17:03','2020-12-10 16:17:03');

--
-- Table structure for table `types`
--

CREATE TABLE `types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `types`
--

INSERT INTO `types` VALUES (1,'MCQ','Multiple choice questions','2018-05-03 21:15:37','2018-05-03 21:15:37'),(2,'Number','Fill in the blanks with numbers','2018-05-03 21:15:37','2018-05-03 21:15:37'),(3,'DAD','Drag and drop','2018-05-03 21:15:37','2018-05-03 21:15:37'),(4,'FIB','Fill in the Blanks','2018-05-03 21:15:37','2018-05-03 21:15:37'),(5,'MS','Multi-select','2018-05-03 21:15:37','2018-05-03 21:15:37'),(6,'Essay','Essay','2018-05-03 21:15:37','2018-05-03 21:15:37');

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `unit` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `units`
--

INSERT INTO `units` VALUES (1,'hours','hours','2018-05-03 21:15:38','2018-05-03 21:15:38'),(2,'days','24 hours','2018-05-03 21:15:38','2018-05-03 21:15:38'),(3,'months','12 months in a year','2018-05-03 21:15:38','2018-05-03 21:15:38'),(4,'years','12 months in a year','2018-05-03 21:15:38','2018-05-03 21:15:38');

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `video_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status_id` int(10) unsigned DEFAULT '4',
  `user_id` int(10) unsigned DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `videos_status_id_foreign` (`status_id`),
  KEY `videos_user_id_foreign` (`user_id`),
  CONSTRAINT `videos_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `videos_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `videos`
--



