-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'Afghanistan','AF','2022-08-15 08:27:10','2022-08-15 08:27:10'),(2,'Åland Islands','AX','2022-08-15 08:27:10','2022-08-15 08:27:10'),(3,'Albania','AL','2022-08-15 08:27:10','2022-08-15 08:27:10'),(4,'Algeria','DZ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(5,'American Samoa','AS','2022-08-15 08:27:10','2022-08-15 08:27:10'),(6,'Andorra','AD','2022-08-15 08:27:10','2022-08-15 08:27:10'),(7,'Angola','AO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(8,'Anguilla','AI','2022-08-15 08:27:10','2022-08-15 08:27:10'),(9,'Antarctica','AQ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(10,'Antigua and Barbuda','AG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(11,'Argentina','AR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(12,'Armenia','AM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(13,'Aruba','AW','2022-08-15 08:27:10','2022-08-15 08:27:10'),(14,'Australia','AU','2022-08-15 08:27:10','2022-08-15 08:27:10'),(15,'Austria','AT','2022-08-15 08:27:10','2022-08-15 08:27:10'),(16,'Azerbaijan','AZ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(17,'Bahamas','BS','2022-08-15 08:27:10','2022-08-15 08:27:10'),(18,'Bahrain','BH','2022-08-15 08:27:10','2022-08-15 08:27:10'),(19,'Bangladesh','BD','2022-08-15 08:27:10','2022-08-15 08:27:10'),(20,'Barbados','BB','2022-08-15 08:27:10','2022-08-15 08:27:10'),(21,'Belarus','BY','2022-08-15 08:27:10','2022-08-15 08:27:10'),(22,'Belgium','BE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(23,'Belize','BZ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(24,'Benin','BJ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(25,'Bermuda','BM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(26,'Bhutan','BT','2022-08-15 08:27:10','2022-08-15 08:27:10'),(27,'Bolivia, Plurinational State of','BO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(28,'Bonaire, Sint Eustatius and Saba','BQ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(29,'Bosnia and Herzegovina','BA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(30,'Botswana','BW','2022-08-15 08:27:10','2022-08-15 08:27:10'),(31,'Bouvet Island','BV','2022-08-15 08:27:10','2022-08-15 08:27:10'),(32,'Brazil','BR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(33,'British Indian Ocean Territory','IO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(34,'Brunei Darussalam','BN','2022-08-15 08:27:10','2022-08-15 08:27:10'),(35,'Bulgaria','BG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(36,'Burkina Faso','BF','2022-08-15 08:27:10','2022-08-15 08:27:10'),(37,'Burundi','BI','2022-08-15 08:27:10','2022-08-15 08:27:10'),(38,'Cambodia','KH','2022-08-15 08:27:10','2022-08-15 08:27:10'),(39,'Cameroon','CM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(40,'Canada','CA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(41,'Cape Verde','CV','2022-08-15 08:27:10','2022-08-15 08:27:10'),(42,'Cayman Islands','KY','2022-08-15 08:27:10','2022-08-15 08:27:10'),(43,'Central African Republic','CF','2022-08-15 08:27:10','2022-08-15 08:27:10'),(44,'Chad','TD','2022-08-15 08:27:10','2022-08-15 08:27:10'),(45,'Chile','CL','2022-08-15 08:27:10','2022-08-15 08:27:10'),(46,'China','CN','2022-08-15 08:27:10','2022-08-15 08:27:10'),(47,'Christmas Island','CX','2022-08-15 08:27:10','2022-08-15 08:27:10'),(48,'Cocos (Keeling) Islands','CC','2022-08-15 08:27:10','2022-08-15 08:27:10'),(49,'Colombia','CO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(50,'Comoros','KM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(51,'Congo','CG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(52,'Congo, the Democratic Republic of the','CD','2022-08-15 08:27:10','2022-08-15 08:27:10'),(53,'Cook Islands','CK','2022-08-15 08:27:10','2022-08-15 08:27:10'),(54,'Costa Rica','CR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(55,'Côte d\'Ivoire','CI','2022-08-15 08:27:10','2022-08-15 08:27:10'),(56,'Croatia','HR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(57,'Cuba','CU','2022-08-15 08:27:10','2022-08-15 08:27:10'),(58,'Curaçao','CW','2022-08-15 08:27:10','2022-08-15 08:27:10'),(59,'Cyprus','CY','2022-08-15 08:27:10','2022-08-15 08:27:10'),(60,'Czech Republic','CZ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(61,'Denmark','DK','2022-08-15 08:27:10','2022-08-15 08:27:10'),(62,'Djibouti','DJ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(63,'Dominica','DM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(64,'Dominican Republic','DO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(65,'Ecuador','EC','2022-08-15 08:27:10','2022-08-15 08:27:10'),(66,'Egypt','EG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(67,'El Salvador','SV','2022-08-15 08:27:10','2022-08-15 08:27:10'),(68,'Equatorial Guinea','GQ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(69,'Eritrea','ER','2022-08-15 08:27:10','2022-08-15 08:27:10'),(70,'Estonia','EE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(71,'Ethiopia','ET','2022-08-15 08:27:10','2022-08-15 08:27:10'),(72,'Falkland Islands (Malvinas)','FK','2022-08-15 08:27:10','2022-08-15 08:27:10'),(73,'Faroe Islands','FO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(74,'Fiji','FJ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(75,'Finland','FI','2022-08-15 08:27:10','2022-08-15 08:27:10'),(76,'France','FR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(77,'French Guiana','GF','2022-08-15 08:27:10','2022-08-15 08:27:10'),(78,'French Polynesia','PF','2022-08-15 08:27:10','2022-08-15 08:27:10'),(79,'French Southern Territories','TF','2022-08-15 08:27:10','2022-08-15 08:27:10'),(80,'Gabon','GA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(81,'Gambia','GM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(82,'Georgia','GE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(83,'Germany','DE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(84,'Ghana','GH','2022-08-15 08:27:10','2022-08-15 08:27:10'),(85,'Gibraltar','GI','2022-08-15 08:27:10','2022-08-15 08:27:10'),(86,'Greece','GR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(87,'Greenland','GL','2022-08-15 08:27:10','2022-08-15 08:27:10'),(88,'Grenada','GD','2022-08-15 08:27:10','2022-08-15 08:27:10'),(89,'Guadeloupe','GP','2022-08-15 08:27:10','2022-08-15 08:27:10'),(90,'Guam','GU','2022-08-15 08:27:10','2022-08-15 08:27:10'),(91,'Guatemala','GT','2022-08-15 08:27:10','2022-08-15 08:27:10'),(92,'Guernsey','GG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(93,'Guinea','GN','2022-08-15 08:27:10','2022-08-15 08:27:10'),(94,'Guinea-Bissau','GW','2022-08-15 08:27:10','2022-08-15 08:27:10'),(95,'Guyana','GY','2022-08-15 08:27:10','2022-08-15 08:27:10'),(96,'Haiti','HT','2022-08-15 08:27:10','2022-08-15 08:27:10'),(97,'Heard Island and McDonald Mcdonald Islands','HM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(98,'Holy See (Vatican City State)','VA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(99,'Honduras','HN','2022-08-15 08:27:10','2022-08-15 08:27:10'),(100,'Hong Kong','HK','2022-08-15 08:27:10','2022-08-15 08:27:10'),(101,'Hungary','HU','2022-08-15 08:27:10','2022-08-15 08:27:10'),(102,'Iceland','IS','2022-08-15 08:27:10','2022-08-15 08:27:10'),(103,'India','IN','2022-08-15 08:27:10','2022-08-15 08:27:10'),(104,'Indonesia','ID','2022-08-15 08:27:10','2022-08-15 08:27:10'),(105,'Iran, Islamic Republic of','IR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(106,'Iraq','IQ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(107,'Ireland','IE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(108,'Isle of Man','IM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(109,'Israel','IL','2022-08-15 08:27:10','2022-08-15 08:27:10'),(110,'Italy','IT','2022-08-15 08:27:10','2022-08-15 08:27:10'),(111,'Jamaica','JM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(112,'Japan','JP','2022-08-15 08:27:10','2022-08-15 08:27:10'),(113,'Jersey','JE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(114,'Jordan','JO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(115,'Kazakhstan','KZ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(116,'Kenya','KE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(117,'Kiribati','KI','2022-08-15 08:27:10','2022-08-15 08:27:10'),(118,'Korea, Democratic People\'s Republic of','KP','2022-08-15 08:27:10','2022-08-15 08:27:10'),(119,'Korea, Republic of','KR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(120,'Kuwait','KW','2022-08-15 08:27:10','2022-08-15 08:27:10'),(121,'Kyrgyzstan','KG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(122,'Lao People\'s Democratic Republic','LA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(123,'Latvia','LV','2022-08-15 08:27:10','2022-08-15 08:27:10'),(124,'Lebanon','LB','2022-08-15 08:27:10','2022-08-15 08:27:10'),(125,'Lesotho','LS','2022-08-15 08:27:10','2022-08-15 08:27:10'),(126,'Liberia','LR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(127,'Libya','LY','2022-08-15 08:27:10','2022-08-15 08:27:10'),(128,'Liechtenstein','LI','2022-08-15 08:27:10','2022-08-15 08:27:10'),(129,'Lithuania','LT','2022-08-15 08:27:10','2022-08-15 08:27:10'),(130,'Luxembourg','LU','2022-08-15 08:27:10','2022-08-15 08:27:10'),(131,'Macao','MO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(132,'Macedonia, the Former Yugoslav Republic of','MK','2022-08-15 08:27:10','2022-08-15 08:27:10'),(133,'Madagascar','MG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(134,'Malawi','MW','2022-08-15 08:27:10','2022-08-15 08:27:10'),(135,'Malaysia','MY','2022-08-15 08:27:10','2022-08-15 08:27:10'),(136,'Maldives','MV','2022-08-15 08:27:10','2022-08-15 08:27:10'),(137,'Mali','ML','2022-08-15 08:27:10','2022-08-15 08:27:10'),(138,'Malta','MT','2022-08-15 08:27:10','2022-08-15 08:27:10'),(139,'Marshall Islands','MH','2022-08-15 08:27:10','2022-08-15 08:27:10'),(140,'Martinique','MQ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(141,'Mauritania','MR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(142,'Mauritius','MU','2022-08-15 08:27:10','2022-08-15 08:27:10'),(143,'Mayotte','YT','2022-08-15 08:27:10','2022-08-15 08:27:10'),(144,'Mexico','MX','2022-08-15 08:27:10','2022-08-15 08:27:10'),(145,'Micronesia, Federated States of','FM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(146,'Moldova, Republic of','MD','2022-08-15 08:27:10','2022-08-15 08:27:10'),(147,'Monaco','MC','2022-08-15 08:27:10','2022-08-15 08:27:10'),(148,'Mongolia','MN','2022-08-15 08:27:10','2022-08-15 08:27:10'),(149,'Montenegro','ME','2022-08-15 08:27:10','2022-08-15 08:27:10'),(150,'Montserrat','MS','2022-08-15 08:27:10','2022-08-15 08:27:10'),(151,'Morocco','MA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(152,'Mozambique','MZ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(153,'Myanmar','MM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(154,'Namibia','NA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(155,'Nauru','NR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(156,'Nepal','NP','2022-08-15 08:27:10','2022-08-15 08:27:10'),(157,'Netherlands','NL','2022-08-15 08:27:10','2022-08-15 08:27:10'),(158,'New Caledonia','NC','2022-08-15 08:27:10','2022-08-15 08:27:10'),(159,'New Zealand','NZ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(160,'Nicaragua','NI','2022-08-15 08:27:10','2022-08-15 08:27:10'),(161,'Niger','NE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(162,'Nigeria','NG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(163,'Niue','NU','2022-08-15 08:27:10','2022-08-15 08:27:10'),(164,'Norfolk Island','NF','2022-08-15 08:27:10','2022-08-15 08:27:10'),(165,'Northern Mariana Islands','MP','2022-08-15 08:27:10','2022-08-15 08:27:10'),(166,'Norway','NO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(167,'Oman','OM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(168,'Pakistan','PK','2022-08-15 08:27:10','2022-08-15 08:27:10'),(169,'Palau','PW','2022-08-15 08:27:10','2022-08-15 08:27:10'),(170,'Palestine, State of','PS','2022-08-15 08:27:10','2022-08-15 08:27:10'),(171,'Panama','PA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(172,'Papua New Guinea','PG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(173,'Paraguay','PY','2022-08-15 08:27:10','2022-08-15 08:27:10'),(174,'Peru','PE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(175,'Philippines','PH','2022-08-15 08:27:10','2022-08-15 08:27:10'),(176,'Pitcairn','PN','2022-08-15 08:27:10','2022-08-15 08:27:10'),(177,'Poland','PL','2022-08-15 08:27:10','2022-08-15 08:27:10'),(178,'Portugal','PT','2022-08-15 08:27:10','2022-08-15 08:27:10'),(179,'Puerto Rico','PR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(180,'Qatar','QA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(181,'Réunion','RE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(182,'Romania','RO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(183,'Russian Federation','RU','2022-08-15 08:27:10','2022-08-15 08:27:10'),(184,'Rwanda','RW','2022-08-15 08:27:10','2022-08-15 08:27:10'),(185,'Saint Barthélemy','BL','2022-08-15 08:27:10','2022-08-15 08:27:10'),(186,'Saint Helena, Ascension and Tristan da Cunha','SH','2022-08-15 08:27:10','2022-08-15 08:27:10'),(187,'Saint Kitts and Nevis','KN','2022-08-15 08:27:10','2022-08-15 08:27:10'),(188,'Saint Lucia','LC','2022-08-15 08:27:10','2022-08-15 08:27:10'),(189,'Saint Martin (French part)','MF','2022-08-15 08:27:10','2022-08-15 08:27:10'),(190,'Saint Pierre and Miquelon','PM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(191,'Saint Vincent and the Grenadines','VC','2022-08-15 08:27:10','2022-08-15 08:27:10'),(192,'Samoa','WS','2022-08-15 08:27:10','2022-08-15 08:27:10'),(193,'San Marino','SM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(194,'Sao Tome and Principe','ST','2022-08-15 08:27:10','2022-08-15 08:27:10'),(195,'Saudi Arabia','SA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(196,'Senegal','SN','2022-08-15 08:27:10','2022-08-15 08:27:10'),(197,'Serbia','RS','2022-08-15 08:27:10','2022-08-15 08:27:10'),(198,'Seychelles','SC','2022-08-15 08:27:10','2022-08-15 08:27:10'),(199,'Sierra Leone','SL','2022-08-15 08:27:10','2022-08-15 08:27:10'),(200,'Singapore','SG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(201,'Sint Maarten (Dutch part)','SX','2022-08-15 08:27:10','2022-08-15 08:27:10'),(202,'Slovakia','SK','2022-08-15 08:27:10','2022-08-15 08:27:10'),(203,'Slovenia','SI','2022-08-15 08:27:10','2022-08-15 08:27:10'),(204,'Solomon Islands','SB','2022-08-15 08:27:10','2022-08-15 08:27:10'),(205,'Somalia','SO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(206,'South Africa','ZA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(207,'South Georgia and the South Sandwich Islands','GS','2022-08-15 08:27:10','2022-08-15 08:27:10'),(208,'South Sudan','SS','2022-08-15 08:27:10','2022-08-15 08:27:10'),(209,'Spain','ES','2022-08-15 08:27:10','2022-08-15 08:27:10'),(210,'Sri Lanka','LK','2022-08-15 08:27:10','2022-08-15 08:27:10'),(211,'Sudan','SD','2022-08-15 08:27:10','2022-08-15 08:27:10'),(212,'Suriname','SR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(213,'Svalbard and Jan Mayen','SJ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(214,'Swaziland','SZ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(215,'Sweden','SE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(216,'Switzerland','CH','2022-08-15 08:27:10','2022-08-15 08:27:10'),(217,'Syrian Arab Republic','SY','2022-08-15 08:27:10','2022-08-15 08:27:10'),(218,'Taiwan','TW','2022-08-15 08:27:10','2022-08-15 08:27:10'),(219,'Tajikistan','TJ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(220,'Tanzania, United Republic of','TZ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(221,'Thailand','TH','2022-08-15 08:27:10','2022-08-15 08:27:10'),(222,'Timor-Leste','TL','2022-08-15 08:27:10','2022-08-15 08:27:10'),(223,'Togo','TG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(224,'Tokelau','TK','2022-08-15 08:27:10','2022-08-15 08:27:10'),(225,'Tonga','TO','2022-08-15 08:27:10','2022-08-15 08:27:10'),(226,'Trinidad and Tobago','TT','2022-08-15 08:27:10','2022-08-15 08:27:10'),(227,'Tunisia','TN','2022-08-15 08:27:10','2022-08-15 08:27:10'),(228,'Turkey','TR','2022-08-15 08:27:10','2022-08-15 08:27:10'),(229,'Turkmenistan','TM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(230,'Turks and Caicos Islands','TC','2022-08-15 08:27:10','2022-08-15 08:27:10'),(231,'Tuvalu','TV','2022-08-15 08:27:10','2022-08-15 08:27:10'),(232,'Uganda','UG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(233,'Ukraine','UA','2022-08-15 08:27:10','2022-08-15 08:27:10'),(234,'United Arab Emirates','AE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(235,'United Kingdom','GB','2022-08-15 08:27:10','2022-08-15 08:27:10'),(236,'United States','US','2022-08-15 08:27:10','2022-08-15 08:27:10'),(237,'United States Minor Outlying Islands','UM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(238,'Uruguay','UY','2022-08-15 08:27:10','2022-08-15 08:27:10'),(239,'Uzbekistan','UZ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(240,'Vanuatu','VU','2022-08-15 08:27:10','2022-08-15 08:27:10'),(241,'Venezuela, Bolivarian Republic of','VE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(242,'Viet Nam','VN','2022-08-15 08:27:10','2022-08-15 08:27:10'),(243,'Virgin Islands, British','VG','2022-08-15 08:27:10','2022-08-15 08:27:10'),(244,'Virgin Islands, U.S.','VI','2022-08-15 08:27:10','2022-08-15 08:27:10'),(245,'Wallis and Futuna','WF','2022-08-15 08:27:10','2022-08-15 08:27:10'),(246,'Western Sahara','EH','2022-08-15 08:27:10','2022-08-15 08:27:10'),(247,'Yemen','YE','2022-08-15 08:27:10','2022-08-15 08:27:10'),(248,'Zambia','ZM','2022-08-15 08:27:10','2022-08-15 08:27:10'),(249,'Zimbabwe','ZW','2022-08-15 08:27:10','2022-08-15 08:27:10');

--
-- Table structure for table `course_accreditations`
--

CREATE TABLE `course_accreditations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_accreditations`
--

INSERT INTO `course_accreditations` VALUES (1,'MCT','MCT','2021-09-25 18:00:00',NULL),(2,'TNMC','TNMC','2021-09-23 18:00:00',NULL),(3,'MeLSAT','MeLSAT','2021-09-25 18:00:00',NULL),(4,'CHAVITA','CHAVITA','2021-09-25 18:00:00',NULL),(5,'TNMC','TNMC','2021-09-25 18:00:00',NULL),(7,'Test Accreditor','This Accreditor I created on 19/01/2023 to test the remaining courses','2023-01-19 09:37:32','2023-01-19 09:37:32'),(8,'Test Accreditor 2','This Accreditor I also created on 19/01/2023 to test the remaining problems in TMS','2023-01-19 09:53:01','2023-01-19 09:53:01'),(9,'Test Accreditor 3','Test Accreditor 3 Description','2023-02-27 04:58:36','2023-02-27 04:58:36');

--
-- Table structure for table `course_categories`
--

CREATE TABLE `course_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_categories`
--

INSERT INTO `course_categories` VALUES (2,'Clinical and Surgical','The further education of nurses is very important to us. In the realm of Maternal & Newborn Health or Perioperative Care we focus on transferring knowledge to practice','PUBLISHED','2021-09-23 18:00:00','2022-12-08 10:09:57'),(3,'Hospital Management','Hospital  Managementhh','PUBLISHED','2021-09-23 18:00:00','2022-11-27 23:58:24'),(4,'Clinical Support','Hospital  Management','PUBLISHED','2021-09-23 18:00:00','2022-12-01 07:25:33'),(5,'Disability and Inclusion','Disability and Inclusion','PUBLISHED','2021-09-23 18:00:00','2022-12-08 10:07:56'),(6,'Physical Rehabilitation','Physical Rehabilitation','PUBLISHED','2021-09-23 18:00:00','2022-12-01 07:25:49'),(7,'Healthcare Support','Preventing Healthcare-Associated Infections (HAI)','PUBLISHED','2022-11-28 04:23:17','2022-11-28 04:23:17'),(8,'General Nursing','General Nursing','PUBLISHED','2022-12-14 04:28:22','2022-12-14 04:28:22'),(9,'Test Category','This is a category I created on 19/01/2023 to test all the remaining changes in TMS','PUBLISHED','2023-01-19 09:25:01','2023-01-19 09:25:01'),(10,'Leadership and management','Febdays testing this course','PUBLISHED','2023-02-13 07:45:12','2023-02-13 07:46:43');

--
-- Table structure for table `course_credits`
--

CREATE TABLE `course_credits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `creditor_id` bigint(20) unsigned DEFAULT NULL,
  `course_id` bigint(20) unsigned DEFAULT NULL,
  `course_credits` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_credits_creditor_id_foreign` (`creditor_id`),
  KEY `course_credits_course_id_foreign` (`course_id`),
  CONSTRAINT `course_credits_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_credits`
--

INSERT INTO `course_credits` VALUES (11,1,8,24,'2022-12-23 04:54:24','2022-12-23 04:54:24'),(12,2,8,48,'2022-12-23 04:54:47','2022-12-23 04:54:47'),(13,1,29,20,'2022-12-23 05:01:30','2022-12-23 05:01:30'),(14,1,NULL,24,'2022-12-23 05:39:58','2022-12-23 05:39:58'),(15,2,NULL,48,'2022-12-23 05:40:13','2022-12-23 05:40:13'),(16,7,34,10,'2023-01-19 10:16:26','2023-01-19 10:16:26'),(17,8,34,20,'2023-01-19 10:16:40','2023-01-19 10:16:40'),(18,8,41,10,'2023-01-22 13:31:16','2023-01-22 13:31:16'),(19,7,41,12,'2023-01-22 13:31:31','2023-01-22 13:31:31'),(20,7,42,10,'2023-01-23 08:09:09','2023-01-23 08:09:09'),(21,8,42,12,'2023-01-23 08:09:26','2023-01-23 08:09:26'),(22,7,43,10,'2023-01-27 08:21:42','2023-01-27 08:21:42'),(23,8,43,20,'2023-01-27 08:21:58','2023-01-27 08:21:58'),(24,3,29,8,'2023-02-07 05:25:42','2023-02-07 05:25:42'),(25,2,27,30,'2023-02-07 05:30:41','2023-02-07 05:30:41'),(27,3,27,5,'2023-02-07 05:31:12','2023-02-07 05:31:12'),(28,2,43,30,'2023-02-07 05:47:40','2023-02-07 05:47:40'),(29,7,45,10,'2023-02-28 05:08:59','2023-02-28 05:08:59'),(31,9,45,7,'2023-02-28 06:39:20','2023-02-28 06:39:20'),(32,8,45,13,'2023-02-28 06:41:55','2023-02-28 06:41:55'),(33,1,46,10,'2023-07-31 04:34:29','2023-07-31 04:34:29');

--
-- Table structure for table `course_modules`
--

CREATE TABLE `course_modules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `objective` longtext COLLATE utf8mb4_unicode_ci,
  `audience` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_format` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price_currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'TZS',
  `module_schedule` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_cover` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` double NOT NULL DEFAULT '0',
  `course_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_modules_course_id_foreign` (`course_id`),
  CONSTRAINT `course_modules_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_modules`
--

INSERT INTO `course_modules` VALUES (9,'Hand Washing','Mixing theory and practice, participants will learn that hand hygiene which includes care of hands, nails, and skin \r\nis a key component in minimizing the spread of disease \r\nand maintaining an infection free environment. Failure to \r\nperform appropriate hand hygiene is among the leading \r\ncauses of healthcare acquired infection (nosocomial \r\ninfections).','# Hand hygiene and Hand washing terminologies\r\n# Protocols of hand hygiene\r\n# Type of hand hygiene','All health workers and house keeping staff in healthcare services','2','50% Lecture + 50% Practice','2 Hours','TZS','Feb, April, Jun & Aug','course_cover_default.jpg',47000,8,'2022-12-08 05:03:36','2022-12-08 05:03:36'),(10,'Personal Protective Equipment (PPE)','The healthcare staff  will learn the importance of wearing Personal Protective Equipment (PPE) whenever they are at risk of contact with contaminated material or blood and other body fluid to prevent them from infection or infecting others.','# Importance of wearing protective equipment \r\n# Identification of hazards posed to eyes, face, nose & feet\r\n# Types of equipment that protect against various hazards\r\n# Personal Protective Equipment donning and doffing','All health workers & housekeeping staff in health care services','1','50% Lecture + 50% Practice','2 Hours','TZS','Feb, April, Jun & Aug','course_cover_default.jpg',47000,8,'2022-12-08 05:16:40','2022-12-08 05:16:40'),(11,'Linen Processing','Housekeepers and laundry staff will learn about handling of dry dirty linen, wet infected linen, transportation, washing, ironing and storage of clean linen.','# Linen processing steps and tools\r\n# CDC guidelines for linens in healthcare facilities\r\n# Protocols for processing soiled and contaminated linens\r\n# Linen utilization process, linen supply and inventory in healthcare facilities','Housekeeping staff in healthcare services','4','60% Lecture/Group discussions + 40% Practice','2 hours','TZS','Feb, April, Jun & Aug','course_cover_default.jpg',47000,8,'2022-12-08 05:21:15','2022-12-08 05:21:15'),(12,'Housekeeping','This training relays sound housekeeping principles and best practices that help reduce HAI in healthcare facility and promotes cleanliness, health & safety in corporate organisations.','# Importance of housekeeping in a healthcare setting\r\n# Standardized cleaning methods\r\n# Infection control measures & sanitation procedures','All health workers & housekeeping staff in health care services','6','50% Lecture + 50% Practice','2 hours','TZS','Mar, May, July & Sep','course_cover_default.jpg',47000,8,'2022-12-08 05:27:08','2022-12-08 05:27:08'),(13,'Waste Management','Participation will learn, understand and practice how to manage wastes that are generated in the healthcare environment (hospital, laboratory, etc.) and hence protect patients and staff from spreading infectious diseases as well as reduce environmental pollution.\'','# Types, categories and sources of healthcare waste\r\n# Healthcare waste hazards and environmental pollution\r\n# Waste Management Hierarchy\r\n# Minimization, handling, collection, treatment & disposal of healthcare waste','All health workers & housekeeping staff in health care services','6','60% Lecture /Group discussion + 40% Practice','2 hours','TZS','Mar, May, July & Sep','course_cover_default.jpg',47000,8,'2022-12-08 05:41:17','2022-12-08 05:41:17'),(14,'Standard Precaution & Disease Transmission Cycle','This training focuses on standard precaution measures that every healthcare workers should adhere to in order to break the chain of infection and prevent transmission of pathogens in a health facility.','# Importance of Standard Precautions practices in healthcare environment\r\n# Elements and best practices of standard precaution in healthcare settings','All health workers','6','60% Lecture + 40% Practice','All health workers','TZS','Mar, May, July & Sep','course_cover_default.jpg',47000,8,'2022-12-08 05:48:08','2022-12-08 05:48:08'),(15,'Transmission Based Precaution','Transmission-Based Precaution training highlights a second tier of infection prevention measures that are introduced when standard precautions are not sufficient to prevent transmission of diseases.','# Modes of transmission\r\n# Contact transmission precautions, droplet transmission precautions and airborne transmission precautions\r\n# Elements of transmissions-based precautions, such as patient placement, environmental cleaning, and patient transportation','All health workers','7','60% Lecture + 40% Practice','2 hours','TZS','Mar, May, July & Sep','course_cover_default.jpg',47000,8,'2022-12-08 05:53:44','2022-12-08 05:53:44'),(16,'Clean & Safe Water','Participants will learn, understand methods of preparation and storage of clean and safe water by performing boiling, chlorination and filtration technique. Participants will also learn how to prevent cholera through contaminated water','# Methods of preparing clean and safe water\r\n# Prevention of cholera transmission through contaminated water\r\n# Boiling, chlorination and filtration technique','All health workers','8','60% Lecture + 40% Practice','2 Hours','TZS','Mar, May, July & Sep','course_cover_default.jpg',47000,8,'2022-12-08 05:58:01','2022-12-08 05:58:01'),(17,'Instrument Processing','This training is designed for healthcare workers who are responsible for infection prevention and sterilization processes for medical and surgical equipment','# Principles and techniques of instrument processing and sterilization\r\n# Cleaning and decontamination processes\r\n# Packaging, sterilizing and storage of medical/surgical instruments\r\n# Quality assurance processes','All healthcare workers','6','60% Lecture + 40% Practice','2 Hours','TZS','Mar, May, July and Sep','course_cover_default.jpg',47000,8,'2022-12-08 06:05:12','2022-12-08 06:05:12'),(18,'Preventing nosocomial pneumonia','Prevention of nosocomial infections begins with health-care facilities implementing infection control protocols to reduce risks of environmental cross-contamination or improper use of antibiotic. This training exposes healthcare workers to measures that can be applied to prevent incidents of hospital-acquired pneumonia.','# Exogenous and endogenous hospital-acquired pneumonia\r\n# Risk factors of nosocomial pneumonia\r\n# Measures to reduce the risk of nosocomial pneumonia\r\n# Management and treatment of nosocomial pneumonia','All health workers','5','60% Lecture + 40% Practice','2 Hours','TZS','Mar, May, July & Sep','course_cover_default.jpg',47000,8,'2022-12-08 06:13:59','2022-12-08 06:13:59'),(19,'Preventing Antimicrobial resistance','Antimicrobial resistance is a global health challenge that threatens to draw back advancements attained in the medical and health industry. This trained aims at creating awareness among healthcare workers about AMR and supporting them to adopt antimicrobial stewardship principles that will enable them to mitigate the spread of antimicrobial resistance.','# Basic Principles & science behind Antimicrobial Resistance\r\n# Impact and consequences of AMR\r\n# How to address Antimicrobial Resistance\r\n# Clinical guidelines for prescribing antibiotics','All health workers','6','100% Lecture/ presentation/Case Studies','All health workers','TZS','Apr & Jul','course_cover_default.jpg',47000,8,'2022-12-08 06:19:22','2022-12-08 06:19:22'),(20,'IPC Leadership & Championship','Leadership is an important part of a successful IPC programme. This training is designed to empower frontline clinicians with skills that will enable them to assume leadership positions in infection prevention and control practices thus contributing to changes in practice and ensuring continuous quality improvement that leads to improved patient care.','# Roles and responsibilities of ICP focal point & champion\r\n# IPC awareness strategies \r\n# Developing an action plan for IPC\r\n# Effective communication for IPC programmes','Frontline health workers responsible for IPC practices','4','100% Lecture/ presentation/Case studies','1 Day','TZS','Jun & Aug','course_cover_default.jpg',140000,8,'2022-12-08 06:28:22','2022-12-08 06:28:22'),(21,'Customer Care Training for Healthcare Services','This training exposes participants to the end-to-end customer experience in health care which enables them to understand the importance of caring for a customer and shows them how to improve their own performance.','# Who is a customer in healthcare?\r\n# Differentiating healthcare customer service from other business service interactions\r\n# Meeting and managing difficult, confused or scared customers and reducing anxiety\r\n# Identifying barriers to providing high quality customer service','Frontline desk officers, e.g receptionists, call center staff, clinical staff with contact to external parties, e.g. nurses','6','80% face-to-face lecture + 20% practice/scenarios','1 Day','TZS','April & October','course_cover_default.jpg',140000,9,'2022-12-13 05:20:41','2022-12-13 05:20:41'),(22,'Lean Management','Lean Management has the power to change the values, behaviors and culture of the organization as well as help improve processes and solve problems emerging from waste within healthcare processes and systems.','# Lean management principles and their advantages\r\n# Operational waste, cycle time waste and non-value adding actions in your organization\r\n# Impact of wastes on an organization\'s revenues, competitive edge and customer fulfillment\r\n# Appropriate lean management tools for your healthcare setting','All staff','7','50% Lecture + 50% Practice','One (1) day','TZS','Feb, Apr, Jun & Sept','course_cover_default.jpg',140000,10,'2022-12-13 05:27:52','2022-12-13 05:27:52'),(23,'Service Marketing','This training exposes participants to marketing concepts, principles, tools and techniques that can be specifically applied to service businesses.','# The importance and characteristics of service marketing\r\n# 7 P\'s framework of service marketing\r\n# Internal marketing - marketing from company to the employee\r\n# External marketing - marketing from the company to external customers and clients','Marketing officers, external affairs officers, liaisons officer','8','50% Lecture + 50% Practice/Scenarios','One (1) day','TZS','Ongoing on a monthly basis','course_cover_default.jpg',140000,11,'2022-12-13 06:06:46','2022-12-13 06:06:46'),(24,'Mental Health and Stress Management','This training focuses on the link between work-related stress and mental health problems, spells out harmful effects of stress on our health, stress triggers & stress management techniques.','# Mental Health definitions, concepts and principles \r\n# Stress triggers and management techniques\r\n# Expressing, recognising and regulating emotions and thoughts\r\n# Mental Health self assessment and burnout prevention','All people desiring to manage stress at an individual & or organisation level','6','50% Lecture + 50% Practice/Scenarios','One (1) day','TZS','Mar, May, July, Sep','course_cover_default.jpg',140000,12,'2022-12-13 07:28:37','2022-12-13 07:28:37'),(25,'Healthcare Financial Management','This training, enhances the financial management skills of professionals working with the healthcare organizations enabling them to make better decisions.','# Planning and budgeting in healthcare\r\n# Financial accounting in healthcare\r\n# Managing healthcare related costs and cash flow\r\n# Healthcare financial reporting','Professionals seeking to learn financial management skills applicable to the healthcare context.','4','100% Lecture','3 Days','TZS','June','course_cover_default.jpg',310000,13,'2022-12-13 07:35:51','2022-12-13 07:36:28'),(26,'Digital Skills for Healthcare Workers','This training aims to equip health professionals for the digital health future, placing a greater emphasis on the needs and abilities of the healthcare professionals as end-users in delivering healthcare services through technological tools and platforms.','# Create awareness and knowledge of digital security \r\n# Create awareness on digital health ethics\r\n# Improve attitude towards use of digital tools\r\n# Facilitate early adoption of digital health technologies','Professionals seeking to learn financial management skills applicable to the healthcare context.','3','100% Lecture','Two (2) Days','TZS','June','course_cover_default.jpg',140000,14,'2022-12-13 07:42:33','2022-12-13 07:42:33'),(27,'Basics of project management for healthcare services','This courses addresses the healthcare professional\'s need to improve the quality of care at their organization through projects delivered on time and within budget. From setting the foundation and planning, to execution and close out, you will study each step of managing a project in detail.','# Fundamental principles of Project Management (PM)\r\n# Project plan development and PM tools\r\n# Communication, monitoring and controlling project variables\r\n# Implementing successful project closures','Healthcare administrators, leaders and project managers','4','100% Lecture/ group discussion','5 Days','TZS','July','course_cover_default.jpg',550000,15,'2022-12-13 07:48:26','2022-12-13 07:48:26'),(28,'Emergency Preparedness - Basic Life Support (BLS) / First Aid','Emergency preparedness training will give you the skills to properly react to emergency situations until the medical team arrives on the scene.','# Promoting recognizing life-threatening emergencies\r\n# Using an Automated External Defibrillator (AED)\r\n# Giving high-quality chest compressions\r\n# Relieving a foreign-body airway obstruction (choking) for adults and infants\r\n# Managing shock, bleeding, fainting & fractures','Everyone','2','20% Lecture + 80% Practice','2 days (8 hours per day)','TZS','Jan, Mar, Jul & Sep','course_cover_default.jpg',226000,16,'2022-12-13 07:58:03','2022-12-13 07:58:03'),(29,'Strengthening Antenatal Care Services','This course teaches antenatal care services, with a focus on accurate pregnancy dating, recognizing high risk pregnancy, early management and referral of anaemia and hypertension and increased birth preparedness and emergency readiness in the third trimester.','# Skills and response to high risk pregnancy detection\r\n# Antenatal care standards and management of high risk pregnancies\r\n# Improving care in the third semester','Nurses, doctors and healthcare workers who manage pregnant women in labour and delivery','1','60% Face to face lecture + 40% Simulation (lab) practice','2 Days','TZS','April, June, September & November','course_cover_default.jpg',226000,17,'2022-12-13 08:09:57','2022-12-13 08:09:57'),(30,'Management of Hypertension in Pregnancy','This course teaches the understanding on the danger of eclampsia and severe hypertension and principles of hypertension management in pregnancy. Participants learn how to prevent and how to treat/manage eclampsia and monitoring for side effects.','# Recognize the clinical emergencies\r\n# Practice in the initial emergency management of severe hypertension in pregnancy/eclampsia\r\n# Prevent complications and follow up of patients','Nurses, doctors and healthcare workers who manage pregnant women in labour and delivery','3','30% Face to face lecture + 70% Simulation (lab) Practice','1 Day','TZS','February, June, August & November','course_cover_default.jpg',140000,18,'2022-12-13 08:22:35','2022-12-13 08:22:35'),(31,'Management of Obstetric Haemorrhage','The aim of this course is to improve competency in correctly responding to obstetric haemorrhage. It includes: 1. Early recognition, 2. visual estimation of blood loss, 3. Fluid and blood replacement, 4 Pre-surgical efforts to prevent excess blood loss and prevent shock and DIC, 5. Post haemorrhage monitoring and referral.','# Diagnosis of shock and haemorrhage\r\n# Standard based care for shock and PPH according to BEMONC SBMR standards','Nurses, doctors and healthcare workers who manage pregnant women in labour and delivery','4','20% Face to face lecture + 80% Simulation(lab) practice','1 Day','TZS','March, May, July, September','course_cover_default.jpg',140000,19,'2022-12-13 08:28:10','2022-12-13 08:28:10'),(32,'Respectful Maternity Care','This training aims at improving specific component of a pregnant woman\'s experience of care at childbirth through addressing health provider\'s knowledge and skills gap in current national standards for respectful care (2019). The desired respectful care (2019). The desired result is the health care workers will be motivated to change behaviour and hold each other accountable to promote respectful care during childbirth','# Drivers of disrespect and abuse at childbirth\r\n# Skills, tools, and ideas on best practices to address mistreatment and promote RMC at the workplace','Nurses, doctors and healthcare workers who manage pregnant women in labour and delivery','4','40% Face to face lecture + 60% Simulation (lab) practice','1 Day','TZS','February, April, July & October','course_cover_default.jpg',140000,20,'2022-12-13 08:40:11','2022-12-13 08:40:11'),(33,'Prevention and Management of Prolonged Labour','Participants will learn the procedures of the daily audit of neonatal admissions/referral/deaths and the importance of conducting perinatal audit routinely correctly on routine clinical practice.','# Using the partograph to monitor patients in labour and  to make decisions on timely delivery\r\n# Review standard and practice normal labour and delivery\r\n# Prevent and correctly respond to prolonged labour','Nurses, doctors and healthcare workers who manage pregnant women in labour and delivery','4','40% Face to face lecture + 60% Simulation (lab) practice','1 Day','TZS','February, April, July & October','course_cover_default.jpg',140000,21,'2022-12-13 08:51:47','2022-12-13 08:51:47'),(34,'Assisted Vaccum Delivery','This course explores the perceptions on the low use of vaccum extraction. Participants learn the indications and each participant is enabled to perform a vaccum delivery in the simulation lab. It includes a review and practice of neonatal resuscitation and care of the equipments','# The indications for vaccum delivery\r\n# Application of vaccum delivery\r\n# Management of a patient and new-born following a vaccum delivery','Nurses, doctors and healthcare workers who manage pregnant women in labour and delivery','5','30% Face to face lecture + 70% Simulation (lab) practice','2 Hours','TZS','February, April, June & August','course_cover_default.jpg',47000,22,'2022-12-13 08:57:27','2022-12-13 08:57:27'),(35,'Assisted Breech Delivery','This course demonstrates the procedures used to perform breech delivery','# Detection of breech presentation and refer it necessary \r\n# Performance of breech delivery in an emergency situation\r\n# Obstetric maneuvers care of newborn','Nurses, doctors and healthcare workers who manage pregnant women in labour and delivery','4','30% Face to face lecture + 70% Simulation (lab) practice','2 Hours','TZS','February, April, June & August','course_cover_default.jpg',47000,23,'2022-12-13 09:03:13','2022-12-13 09:03:13'),(36,'Management of Shoulder Dystocia','This course begins with a clarification of the definition and diagnosis of shoulder dystocia. Participants learn about various manoeuvres that are commonly used in the management of shoulder dystocia. They gain a better understanding of the risk of getting a shoulder dystocia and which complications of shoulder dystocia might occur','# Diagnosis of shoulder dystocia\r\n# Different maneuvers commonly used in the management of shoulder dystocia','Nurses, doctors and healthcare workers who manage pregnant women in labour and delivery','1','10% Face to face lecture + 90% Simulation (lab) practice','2 Hours','TZS','February, April, June & August','course_cover_default.jpg',47000,24,'2022-12-13 09:11:30','2022-12-13 09:11:30'),(37,'Referral and transport of a sick baby','Timely identification of sick neonates who need referral to a higher health facility and appropriate transport of these patient might be life-saving. The content of this module is to ensure that health workers know the indications for referral and how to prepare a transport. The importance of communication with the higher health facility including phone call prior to referral and referral letter as well as provision of care during transport will be highlighted.','# The indications for referral\r\n# How to prepare for transport \r\n# Principles of care during transport','Nurses, midwives, medical doctors and all health workers involved in maternal and neonatal healthcare','3','90% lecture + 10% Simulation practice','1 Day','TZS','May & August','course_cover_default.jpg',140000,25,'2022-12-13 09:24:32','2022-12-13 09:24:32'),(38,'Neonatal Resuscitation','Failure to establish spontaneous breathing after birth can lead to a life threatening situation. The content of this training module is to ensure that health workers have the skills and knowledge to immediately detect emergency situations and provide the appropriate steps of neonatal resuscitation in order to prevent further damage for the new-born infant','# The physiological changes at birth\r\n# How to be prepared for resuscitation\r\n# Practice ABC of neonatal resuscitation','Nurses, midwives and all health workers of labour, postnatal and neonatal wards','7','90% lecture + 105 Simulation practice','1 Day','TZS','May & August','course_cover_default.jpg',140000,26,'2022-12-13 09:34:19','2022-12-13 09:34:19'),(39,'Breastfeeding counselling','Breastfeeding gives infants the best start in life and also protects the health of the mother. The content of training module is to ensure that health workers have sufficient knowledge about the advantages of BF and how it works and the skills to support mothers to start BF , sustain it and overcome difficulties.','# The advantages of breastfeeding\r\n# How to support mothers on breastfeeding\r\n# How to resolve breastfeeding difficulties','Nurses, midwives, medical doctors, and all health workers involved in maternal and neonatal healthcare','4','60% lecture _ 20% Simulation practice + 20% Outpatient practice','1 Day','TZS','May & November','course_cover_default.jpg',140000,27,'2022-12-13 09:42:02','2022-12-13 09:42:02'),(40,'Essential Newborn Care','The first hours and days after birth are the most vulnerable period of a child\'s life. Content of this training module is to ensure that health workers have the skills and knowledge to provide appropriate care for every new-born. Keeping a baby warm, initiating breastfeeding in the first hour after birth, physical examination of the newborn and routine care including cord care, eye care and vaccinations are the key principles of essential newborn care combined with counselling of new parents on danger signs.','# The principles of newborn at time of birth\r\n# How to examine a newborn\r\n# The care of newborn until discharge','Nurses, midwives, medical doctors and all health workers involved in maternal and neonatal healthcare','3','60% lecture + 20% Simulation practice + 20% Outpatient practice','1 Day','TZS','March & July','course_cover_default.jpg',140000,28,'2022-12-13 10:10:17','2022-12-13 10:10:17'),(41,'Basic Clubfoot','The basic clubfoot training will cover a simple introduction to the core concepts and technique of the Ponseti method in a noncomplex, idiopathic case of clubfoot in a child under 2','# Hands-on practice in manipulation, scoring, casting, bracing (and tenotomy where relevant) on training models and patients (Basic Clubfoot Training)\r\n# Approach to measure and improve quality of care in clinics, to encourage reflection on what is (and isn\'t) working well in own practice/clinic setting and to identify priority actions (Advanced Non-surgical clubfoot training)','All clinical staff members','1','40% Face to face lecture + 60% Simulation (lab) practice','2 Days','TZS','May','course_cover_default.jpg',226000,29,'2022-12-13 11:15:18','2022-12-13 11:15:18'),(42,'Ophthalmology - Ophthalmic Triage Nurse','This training exposes participants to the end-to-end customer experience in health care which enables them to understand the importance of caring for a customer and shows them how to improve their own performance.','# Apply triage practicing standards\r\n# Differentiate between the concepts of urgency, severity & complexity of illness and injury\r\n# Describe the five-tier triage scale\r\n# Conduct triage assessment and documentation for clinical components','Ophthalmic Assistant Nurses and staff working in Ophthalmology Departments','1','70% lecture + 20% outpatient practice + 10% operation theatre practice','1 Day','TZS','March. May, July & September','course_cover_default.jpg',77000,30,'2022-12-14 04:40:59','2022-12-14 04:40:59'),(43,'module name festus','module description','# module objective 1','JSKDB','3','KSJDHF','2','TZS',NULL,'course_cover_default.jpg',130000,31,'2022-12-23 05:17:59','2022-12-23 05:17:59'),(49,'Test Module One','This is a test','# This is test module one\'s first objective\r\n# This is test module one\'s second objective\r\n# This is test module one\'s third objective','All health workers','1','50% lecture 50% practical','2 Days','TZS','January, February, March','course_cover_default.jpg',100000,34,'2023-01-19 10:40:54','2023-01-19 10:40:54'),(51,'Test Module One','This is the description for test module one','# Objective One\r\n# Objective Two\r\n# Objective Three','All Proffesionals','2','100% Theory','2 Days','TZS','Jan. Feb, Mar','course_cover_default.jpg',120000,41,'2023-01-22 13:34:46','2023-01-22 13:34:46'),(53,'Test Module Two','This is the description','# Objective One','All','2','100% Physical','2 Days','TZS','Mar, April, May, June','course_cover_default.jpg',70000,34,'2023-01-23 06:03:45','2023-01-23 06:03:45'),(54,'Test Module One','This is the description of test course three\'s module one','# This is objective one','All proffesionals','7','100% Physical','2 Hours','TZS','Monthly','course_cover_default.jpg',120000,42,'2023-01-23 08:23:36','2023-01-23 08:23:36'),(57,'Test Module Two','This is the description','# Objective One','All proffesionals','1','100% Physical','3 Days','TZS','Monthly','course_cover_default.jpg',50000,42,'2023-01-23 10:01:15','2023-01-23 10:01:15'),(58,'Infection Prevention and Control','This is the description','# Objective One\r\n# Objective Two\r\n# Objective Three','All Proffesionals','6','50% Practical 50% Theory','2 Days','TZS','Monthly','course_cover_default.jpg',120000,43,'2023-01-27 08:25:57','2023-01-27 08:25:57'),(60,'Child Abuse and Neglect Prevention','This module is about Child Abuse and Neglect Prevention','# Strengthening financial security of the household\r\n# Why children are abused\r\n# What is neglected','All proffesionals','4','50% lecture 50% practical','7 Days','TZS','Monthly','course_cover_default.jpg',150000,45,'2023-02-28 06:46:44','2023-02-28 06:46:44'),(61,'Child Protection Training','Child Protection Training','# Policy and procedures in safeguarding\r\n# Categories of child abuse and neglect\r\n# Signs and indicators of child abuse\r\n# What to do if abuse is suspected\r\n# Identify barriers to children and adults reporting concerns\r\n# Recording and reporting incidents in line with policy and procedure','All health care proffesionals','9','60% Theory 40% Practical','7 Hours','TZS','Monthly Session','course_cover_default.jpg',120000,45,'2023-02-28 06:53:23','2023-02-28 06:53:23'),(62,'Testing Module #1','Testing Module #1','# Testing Module1 Objective 1\r\n# Testing Module1 Objective 2\r\n# Testing Module1 Objective 3','All Healthcare proffesionals and related fields','2','40% Physical + 60% Practical','2 Days','TZS','August, September and October','course_cover_default.jpg',100000,46,'2023-07-31 04:33:10','2023-07-31 04:33:10');

--
-- Table structure for table `course_presenters`
--

CREATE TABLE `course_presenters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_presenters_user_id_foreign` (`user_id`),
  CONSTRAINT `course_presenters_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_presenters`
--

INSERT INTO `course_presenters` VALUES (1,'Dr. Peter Saria','Dr. Peter Saria',NULL,'2021-09-25 18:00:00',NULL),(2,'Ms. Anna Magingo','Ms. Anna Magingo',NULL,'2021-09-25 18:00:00',NULL),(3,'Moses Raymond','Moses Raymond',NULL,'2021-09-25 18:00:00',NULL),(4,'Ms. Hilda Mlay','Ms. Hilda Mlay',NULL,'2021-09-23 18:00:00',NULL),(5,'Dr. Timothy Mushi','Dr. Timothy Mushi',NULL,'2021-09-25 18:00:00',NULL),(6,'Mr. Kennedy','Mr. Kennedy',NULL,'2021-09-25 18:00:00',NULL),(7,'Ms. Anna Gugu','Ms. Anna Gugu',NULL,'2021-09-25 18:00:00',NULL),(8,'Remla','Remla',NULL,'2021-09-25 18:00:00',NULL),(9,'Febdays M','Skilled facilitator',NULL,'2023-02-13 07:58:57','2023-02-13 07:58:57'),(10,'Albert Edward Urassa','I am a skilled instructor with expertise in areas such as paramedic care, anasthesiology and home-based care',NULL,'2023-02-27 07:02:52','2023-02-27 07:02:52');

--
-- Table structure for table `course_providers`
--

CREATE TABLE `course_providers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_providers`
--

INSERT INTO `course_providers` VALUES (1,'CCBRT','CCBRT','2021-09-23 18:00:00',NULL),(2,'TIGO','TIGO','2021-09-23 18:00:00',NULL),(3,'TCCO','TCCO','2021-09-25 18:00:00',NULL),(4,'FM Company','Febdays Testing','2023-02-13 07:47:51','2023-02-13 07:47:51'),(6,'Test Provider One','Test Provider One - Test','2023-02-27 04:55:15','2023-02-27 04:55:15');

--
-- Table structure for table `course_registrations`
--

CREATE TABLE `course_registrations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `candidate_id` bigint(20) unsigned DEFAULT NULL,
  `course_id` bigint(20) unsigned DEFAULT NULL,
  `send_course_instruction` smallint(6) DEFAULT '0',
  `send_order` smallint(6) DEFAULT '0',
  `training_book` smallint(6) DEFAULT '0',
  `self_assessment_quiz` smallint(6) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_registrations_candidate_id_foreign` (`candidate_id`),
  KEY `course_registrations_course_id_foreign` (`course_id`),
  CONSTRAINT `course_registrations_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE SET NULL,
  CONSTRAINT `course_registrations_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_registrations`
--


--
-- Table structure for table `course_sessions`
--

CREATE TABLE `course_sessions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date_time` timestamp NULL DEFAULT NULL,
  `end_date_time` timestamp NULL DEFAULT NULL,
  `mode_of_delivery` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `online_description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_id` bigint(20) unsigned DEFAULT NULL,
  `venue_id` bigint(20) unsigned DEFAULT NULL,
  `venue_room_id` bigint(20) unsigned DEFAULT NULL,
  `room_capacity` int(11) NOT NULL DEFAULT '0',
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `course_presenter_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_registrant` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_registrant` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `course_module_id` bigint(20) unsigned NOT NULL,
  `session_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_sessions_course_id_foreign` (`course_id`),
  KEY `course_sessions_venue_id_foreign` (`venue_id`),
  KEY `course_sessions_venue_room_id_foreign` (`venue_room_id`),
  KEY `course_sessions_course_module_id_foreign` (`course_module_id`),
  CONSTRAINT `course_sessions_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `course_sessions_course_module_id_foreign` FOREIGN KEY (`course_module_id`) REFERENCES `course_modules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `course_sessions_venue_id_foreign` FOREIGN KEY (`venue_id`) REFERENCES `venues` (`id`) ON DELETE SET NULL,
  CONSTRAINT `course_sessions_venue_room_id_foreign` FOREIGN KEY (`venue_room_id`) REFERENCES `venue_rooms` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_sessions`
--

INSERT INTO `course_sessions` VALUES (1,'Session #1','2023-01-23 10:45:00','2023-01-23 11:15:00','physical','null',34,1,1,0,'ENDED',NULL,'1','20','2023-01-19 10:43:21','2023-01-25 14:32:59',49,NULL),(2,'Session 2','2023-01-25 10:00:00','2023-01-25 12:00:00','physical',NULL,34,2,7,0,'PUBLISHED',NULL,'4','20','2023-01-24 07:08:56','2023-01-24 07:08:56',49,NULL),(3,'Session #1','2023-01-27 08:00:00','2023-01-27 08:15:00','physical',NULL,34,2,7,0,'ENDED',NULL,'2','4','2023-01-27 04:42:12','2023-01-27 04:57:14',53,NULL),(4,'Session #1','2023-01-27 11:00:00','2023-01-27 11:30:00','physical',NULL,43,2,7,0,'ENDED',NULL,'2','20','2023-01-27 08:30:16','2023-02-02 12:30:55',58,NULL),(5,'Session #1','2023-02-02 15:00:00','2023-02-02 15:30:00','physical',NULL,41,2,7,0,'PUBLISHED',NULL,'2','4','2023-02-02 11:44:46','2023-02-02 11:44:46',51,NULL),(6,'Session #1','2023-02-15 08:00:00','2023-02-17 11:00:00','physical',NULL,29,2,7,0,'PUBLISHED',NULL,'1','20','2023-02-07 05:27:41','2023-02-07 05:27:41',41,NULL),(7,'Session #2','2023-02-17 11:00:00','2023-02-18 08:00:00','online','This is for candidates who will learn virtually',29,NULL,NULL,0,'PUBLISHED',NULL,'1','20','2023-02-07 05:28:43','2023-02-07 05:28:43',41,NULL),(8,'Session #1','2023-02-20 08:00:00','2023-02-20 11:00:00','physical','null',27,1,4,0,'PUBLISHED',NULL,'1','50','2023-02-07 05:32:20','2023-02-08 05:39:50',39,NULL),(9,'Session #1','2023-02-22 08:00:00','2023-02-25 08:00:00','physical',NULL,19,2,6,0,'PUBLISHED',NULL,'1','10','2023-02-07 05:34:05','2023-02-07 05:34:05',31,NULL),(10,'Session #2','2023-02-24 08:00:00','2023-02-27 08:00:00','physical',NULL,19,1,3,0,'PUBLISHED',NULL,'1','20','2023-02-07 05:34:50','2023-02-07 05:34:50',31,NULL),(11,'Session #3','2023-02-09 08:00:00','2023-02-09 12:00:00','online','This is for virtual learners',19,NULL,NULL,0,'PUBLISHED',NULL,'1','20','2023-02-07 05:37:20','2023-02-07 05:37:20',31,NULL),(12,'Session #3','2023-02-19 08:00:00','2023-02-20 08:00:00','physical',NULL,41,1,3,0,'PUBLISHED',NULL,'1','20','2023-02-17 05:16:46','2023-02-17 05:16:46',51,NULL),(13,'Session #4','2023-03-07 10:00:00','2023-03-07 17:00:00','physical','null',45,1,4,0,'PUBLISHED',NULL,'1','50','2023-02-28 07:05:07','2023-07-04 14:12:46',60,NULL),(14,'Session #1','2023-03-07 10:00:00','2023-03-07 17:00:00','physical','null',45,2,7,0,'PUBLISHED',NULL,'1','20','2023-02-28 07:09:07','2023-03-06 09:50:48',61,NULL),(15,'Session #2','2023-03-02 10:00:00','2023-03-02 17:00:00','physical',NULL,45,2,6,0,'PUBLISHED',NULL,'1','20','2023-02-28 07:10:31','2023-02-28 07:10:31',61,NULL),(16,'Session #2','2023-03-02 10:00:00','2023-03-02 17:00:00','physical',NULL,45,1,3,0,'PUBLISHED',NULL,'1','20','2023-02-28 07:50:20','2023-02-28 07:50:20',60,NULL),(17,'Session #3','2023-03-20 10:00:00','2023-03-21 13:00:00','physical',NULL,45,1,2,0,'PUBLISHED',NULL,'1','15','2023-03-06 10:40:26','2023-03-06 10:40:26',61,NULL),(18,'Session #1','2023-07-10 07:00:00','2023-07-11 08:15:00','physical',NULL,45,1,3,0,'PUBLISHED',NULL,'1','20','2023-07-04 14:12:25','2023-07-04 14:12:25',60,NULL),(19,'Session #5','2023-10-06 13:12:00','2023-10-06 13:13:00','physical','null',45,2,7,0,'PUBLISHED',NULL,'20','20','2023-07-26 10:13:29','2023-07-26 10:16:38',61,NULL),(20,'Session #1','2023-07-31 11:00:00','2023-07-31 12:00:00','physical',NULL,46,1,3,0,'PUBLISHED',NULL,'1','20','2023-07-31 04:48:17','2023-07-31 04:48:17',62,NULL);

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

CREATE TABLE `courses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `session_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price_per_registrant` double DEFAULT NULL,
  `price_currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Tsh',
  `price_per_tax` bigint(20) unsigned DEFAULT NULL,
  `deposit_enabled` tinyint(1) DEFAULT '0',
  `course_category_id` bigint(20) unsigned DEFAULT NULL,
  `course_provider_id` bigint(20) unsigned DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `publish_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_description` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `course_cover` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'course_cover_default.jpg',
  PRIMARY KEY (`id`),
  KEY `courses_price_per_tax_foreign` (`price_per_tax`),
  KEY `courses_course_category_id_foreign` (`course_category_id`),
  KEY `courses_course_provider_id_foreign` (`course_provider_id`),
  CONSTRAINT `courses_course_category_id_foreign` FOREIGN KEY (`course_category_id`) REFERENCES `course_categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `courses_course_provider_id_foreign` FOREIGN KEY (`course_provider_id`) REFERENCES `course_providers` (`id`) ON DELETE SET NULL,
  CONSTRAINT `courses_price_per_tax_foreign` FOREIGN KEY (`price_per_tax`) REFERENCES `price_taxes` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `courses` VALUES (8,'Infection Prevention - Series Part 01','multiple',0,'TZS',NULL,NULL,7,1,'This series oers a range of modules that an be undertaken by healthcare workers  in order to strengthen their knowledge on how implement Infection Prevention  and Control measures so as to reduce, prevent and mitigate the spread of Health  care-associated infections (HAIs). You can register for individual modules that fit  your needs or the full series, find each individual trainings overview and key  learnings on the following pages.','PUBLISHED',NULL,'2022-12-08 04:59:48','2022-12-08 04:59:48','course_cover_default.jpg'),(9,'Customer Care Training for Healthcare Services','multiple',0,'TZS',NULL,NULL,3,1,'This training exposes participants to the end-to-end  customer experience in health care which enables them to  understand the importance of caring for a customer and  shows them how to improve their own performance','PUBLISHED',NULL,'2022-12-13 05:15:05','2022-12-13 05:15:05','course_cover_default.jpg'),(10,'Lean Management','multiple',0,'TZS',NULL,NULL,3,1,'This training aims at bringing about better leadership and  management in health systems by exposing health care  leaders to revolutionary lean management principles','PUBLISHED',NULL,'2022-12-13 05:22:42','2022-12-13 05:22:42','course_cover_default.jpg'),(11,'Service Marketing','multiple',0,'TZS',NULL,NULL,3,1,'Service marketing skills are needed to persuade customers to purchase something they cannot physically own but which they need and or want.','PUBLISHED',NULL,'2022-12-13 06:01:48','2022-12-13 06:01:48','course_cover_default.jpg'),(12,'Mental Health and Stress Management','multiple',0,'TZS',NULL,NULL,3,1,'Stress is an inevitablel phenomenon. Although some stress is good, excessive ongoing stress can be detrimental to health and lead to low productivity and inefficiency in all spheres of life.','PUBLISHED',NULL,'2022-12-13 07:22:00','2022-12-13 07:22:00','course_cover_default.jpg'),(13,'Healthcare Financial Management','multiple',0,'TZS',NULL,NULL,3,1,'Success or failure of healthcare organisations in terms of good patient care, increased investment, securing new revenue sources is hinged on proper management of financial resources and process.','PUBLISHED',NULL,'2022-12-13 07:30:38','2022-12-13 07:30:38','course_cover_default.jpg'),(14,'Digital Skills for Healthcare Workers','multiple',0,'TZS',NULL,NULL,3,1,'Digital technology, including mHealth and eHealth, is an inevitable part of the future of healthcare service delivery. But are health professionals prepared?','PUBLISHED',NULL,'2022-12-13 07:38:15','2022-12-13 07:38:15','course_cover_default.jpg'),(15,'Basics of project management for healthcare services','multiple',0,'TZS',NULL,NULL,3,1,'In health care, clinical and administrative sta with no formal  training in project management often end up leading  projects. These individuals may be subject maer experts,  but they likely only have a passing knowledge of the science  of moving ideas to results and therefore need formal training  in project management.','PUBLISHED',NULL,'2022-12-13 07:43:31','2022-12-13 07:43:31','course_cover_default.jpg'),(16,'Emergency Preparedness - Basic Life Support (BLS) / First Aid','multiple',0,'TZS',NULL,NULL,7,1,'Unexpected life threatening situations can present themselves at any moment and knowing the proper steps in providing Basic Life Support can be the difference between life and death','PUBLISHED',NULL,'2022-12-13 07:53:05','2022-12-13 07:53:05','course_cover_default.jpg'),(17,'Strengthening Antenatal Care Services','multiple',0,'TZS',NULL,NULL,2,1,'This course teaches antenatal care services, with a focus on  accurate pregnancy dating, recognizing high risk pregnancy,  early management and referral of anaemia and hypertension  and increased birth preparedness and emergency readiness in  the third trimester.','PUBLISHED',NULL,'2022-12-13 08:02:37','2022-12-13 08:02:37','course_cover_default.jpg'),(18,'Management of Hypertension in Pregnancy','multiple',0,'TZS',NULL,NULL,2,1,'This course teaches the understanding on the dangers of eclampsia and severe hypertension and the principles of hypertension management  in pregnancy. Participants learn how to prevent and how to treat / manage eclampsia and monitoring  for side effects.','PUBLISHED',NULL,'2022-12-13 08:16:46','2022-12-13 08:16:46','course_cover_default.jpg'),(19,'Management of Obstetric Haemorrhage','multiple',0,'TZS',NULL,NULL,2,1,'The aim of this course is to improve competency in correctly  responding to obstetric haemorrhage. It includes: 1. Early  recognition, 2. visual estimation of blood loss, 3. Fluid and blood  replacement, 4 Pre-surgical efforts to prevent excess blood loss  and prevent shock and DIC, 5. Post haemorrhage monitoring and  referral.','PUBLISHED',NULL,'2022-12-13 08:23:35','2022-12-13 08:23:35','course_cover_default.jpg'),(20,'Respectful Maternity Care','multiple',0,'TZS',NULL,NULL,2,1,'This training aims at improving specific component of a pregnant  woman’s experience of care at childbirth through addressing health  providers’ knowledge and skills gap in current national standards for  respectful care (2019). The desired result is the health care workers  will be motivated to change behaviour and hold each other  accountable to promote respectful care during childbirth','PUBLISHED',NULL,'2022-12-13 08:29:44','2022-12-13 08:29:44','course_cover_default.jpg'),(21,'Prevention and Management of Prolonged Labour','multiple',0,'TZS',NULL,NULL,2,1,'The course teaches about utilizing the partograph to prevent the  danger resulting from prolonged labour like fistula, neonatal deaths  and stillbirths, Neonatal resuscitation/ primary care for baby with  birth asphyxia and prevention of neonatal sepsis','PUBLISHED',NULL,'2022-12-13 08:41:43','2022-12-13 08:41:43','course_cover_default.jpg'),(22,'Assisted Vaccum Delivery','multiple',0,'TZS',NULL,NULL,2,1,'This course explores the perceptions on the low use of vacuum  extraction. Participants learn the indications and each participant is  enabled to perform a vacuum delivery in the simulation lab. It includes  a review and practice of neonatal resuscitation and care of the  equipment','PUBLISHED',NULL,'2022-12-13 08:52:28','2022-12-13 08:52:28','course_cover_default.jpg'),(23,'Assisted Breech Delivery','multiple',0,'TZS',NULL,NULL,2,1,'This course demonstrates the procedures used to perform breech delivery','PUBLISHED',NULL,'2022-12-13 08:58:25','2022-12-13 08:58:25','course_cover_default.jpg'),(24,'Management of Shoulder Dystocia','multiple',0,'TZS',NULL,NULL,2,1,'This course begins with a clarification of the definition and  diagnosis of shoulder dystocia. Participants learn about various  manoeuvres that are commonly used in the management of  shoulder dystocia. They gain a better understanding of the risk of  getting a shoulder dystocia and which complications of shoulder  dystocia might occur.','PUBLISHED',NULL,'2022-12-13 09:04:02','2022-12-13 09:04:02','course_cover_default.jpg'),(25,'Referral and transport of a sick baby','multiple',0,'TZS',NULL,NULL,2,1,'Timely identification of sick neonates who need referral to a higher  health facility and appropriate transport of these patients might be  life-saving. The content of this module is to ensure that health  workers know the indications for referral and how to prepare a  transport. The importance of communication with the higher health  facility including phone call prior to referral and referral letter as  well as provision of care during transport will be highlighted','PUBLISHED',NULL,'2022-12-13 09:14:53','2022-12-13 09:14:53','course_cover_default.jpg'),(26,'Neonatal Resuscitation','multiple',0,'TZS',NULL,NULL,2,1,'Failure to establish spontaneous breathing after birth can lead to a life  threatening situation. The content of this training module is to ensure that  health workers have the skills and knowledge to immediately detect  emergency situations and provide the appropriate steps of neonatal  resuscitation in order to prevent further damage for the new-born infant.','PUBLISHED',NULL,'2022-12-13 09:26:30','2022-12-13 09:26:30','course_cover_default.jpg'),(27,'Breastfeeding Counselling','multiple',0,'TZS',NULL,NULL,2,1,'Breastfeeding gives infants the best start in life and also protects the  health of the mother. The content of this training module is to ensure  that health workers have sufficient knowledge about the advantages of  BF and how it works and the skills to support mothers to start BF,  sustain it and overcome difficulties','PUBLISHED',NULL,'2022-12-13 09:34:55','2022-12-13 09:34:55','course_cover_default.jpg'),(28,'Essential Newborn Care','multiple',0,'TZS',NULL,NULL,2,1,'The first hours and days after birth are the most vulnerable period of a  child’s life. Content of this training module is to ensure that health workers  have the skills and knowledge to provide appropriate care for every  new-born. Keeping a baby warm, initiating breastfeeding in the first hour  after birth, physical examination of the newborn and routine care including  cord care, eye care and vaccinations are the key principles of essential  newborn care combined with counselling of new parents on danger signs.','PUBLISHED',NULL,'2022-12-13 09:42:40','2022-12-13 09:42:40','course_cover_default.jpg'),(29,'Basic Clubfoot','multiple',0,'TZS',NULL,NULL,2,1,'The basic clubfoot training will cover a simple introduction to the  core concepts and technique of the Ponseti method in a  noncomplex, idiopathic case of clubfoot in a child under 2','PUBLISHED',NULL,'2022-12-13 10:11:14','2022-12-13 10:11:14','course_cover_default.jpg'),(30,'Ophthalmology - Ophthalmic Triage Nurse','multiple',0,'TZS',NULL,NULL,8,1,'The goal of this training is to provide nurses and other health  professionals with the knowledge and skills required to  identify patients needing immediate resuscitation; assign  patients predesignated patient care area; prioritize their  care; and initiate appropriate diagnostic measures.','PUBLISHED',NULL,'2022-12-14 04:30:01','2022-12-14 04:30:01','course_cover_default.jpg'),(31,'Perineal Repair Surgical Training','multiple',0,'TZS',NULL,NULL,8,1,'Perineal repair training is essential to improve the knowledge,  confidence and competency of obstetricians, gynecologists  and clinical practitioners who undertake perineal repair  procedures.','PUBLISHED',NULL,'2022-12-14 04:43:14','2022-12-14 04:43:14','course_cover_default.jpg'),(34,'Test Course One','multiple',0,'TZS',NULL,NULL,9,1,'This is a test category I created on 19/01/2023 to check the remaining bugs in TMS','PUBLISHED',NULL,'2023-01-19 09:26:12','2023-01-19 09:26:12','course_cover_default.jpg'),(41,'Test Course Two','multiple',0,'TZS',NULL,NULL,9,2,'This is test course two\'s description','PUBLISHED',NULL,'2023-01-21 08:31:49','2023-01-21 08:31:49','course_cover_default.jpg'),(42,'Test Course Three','multiple',0,'TZS',NULL,NULL,9,2,'This is test course three\'s description','PUBLISHED',NULL,'2023-01-22 13:21:51','2023-01-22 13:21:51','course_cover_default.jpg'),(43,'Test Course Four','multiple',0,'TZS',NULL,NULL,9,1,'This is the description','PUBLISHED',NULL,'2023-01-23 09:42:06','2023-01-23 09:42:06','course_cover_default.jpg'),(45,'Child Protection Training','multiple',0,'TZS',NULL,NULL,7,4,'Child Protection Training','PUBLISHED',NULL,'2023-02-27 10:41:00','2023-02-27 10:41:00','course_cover_default.jpg'),(46,'Testing Course #2','multiple',0,'TZS',NULL,NULL,9,1,'Testing course description','PUBLISHED',NULL,'2023-07-31 04:28:21','2023-07-31 04:28:21','course_cover_default.jpg');

--
-- Table structure for table `disabilities`
--

CREATE TABLE `disabilities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `disabilities`
--

INSERT INTO `disabilities` VALUES (1,'Visual Impairment','2022-08-15 08:27:10','2022-08-15 08:27:10'),(2,'Speech Impairment','2022-08-15 08:27:10','2022-08-15 08:27:10'),(3,'Mental health condition','2022-08-15 08:27:10','2022-08-15 08:27:10'),(4,'Intellectual Disability ','2022-08-15 08:27:10','2022-08-15 08:27:10'),(5,'Physical Disability','2022-08-15 08:27:10','2022-08-15 08:27:10'),(6,'Deaf or hard of hearing','2022-08-15 08:27:10','2022-08-15 08:27:10');

--
-- Table structure for table `document_libraries`
--

CREATE TABLE `document_libraries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_relevant_path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_size` int(11) NOT NULL,
  `module_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_primary_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `open_field` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `document_libraries`
--


--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start` date NOT NULL,
  `end` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `events`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `footer_notes`
--

CREATE TABLE `footer_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(30) NOT NULL,
  `footer_note` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `footer_notes`
--

INSERT INTO `footer_notes` VALUES (1,'quote','<p><span style=\"font-size: 1rem;\">Bank Name: CRDB</span><br></p><p>Account Name: CCBRT ADVOCACY</p><p>Account Number: 0150516115912</p><p>Address: Msasani Tower, Dar Es Salaam.</p>','2022-12-07 09:25:55','2022-12-07 06:25:55'),(2,'quote','<div><b>CCBRT ACADEMY</b></div><div><br></div><div>P.O.Box 23310,</div><div><br></div><div>Dar Es Salaam, Tanzania</div><div><br></div><div>Bank Name: CRDB</div><div><br></div><div>Account Name: CCBRT ADVOCACY</div><div><br></div><div>Account Number: 0150516115912</div><div><br></div><div>Address: Msasani Tower, Dar Es Salaam</div>','2022-12-07 08:16:12','2022-12-07 08:16:12');

--
-- Table structure for table `key_numbers`
--

CREATE TABLE `key_numbers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `key_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `key_numbers`
--

INSERT INTO `key_numbers` VALUES (1,'ORDER','BKNG-202212',1,'2022-12-06 09:22:34','2022-12-06 09:22:34'),(2,'ORDER','CCBRT/QT-202212',1,'2022-12-06 09:23:18','2022-12-06 09:23:18'),(3,'ORDER','BKNG-202212',2,'2022-12-07 06:13:06','2022-12-07 06:13:06'),(4,'ORDER','BKNG-202212',3,'2022-12-07 06:19:54','2022-12-07 06:19:54'),(5,'ORDER','CCBRT/QT-202212',2,'2022-12-07 06:20:19','2022-12-07 06:20:19'),(6,'ORDER','BKNG-202212',4,'2022-12-07 07:34:50','2022-12-07 07:34:50'),(7,'ORDER','BKNG-202212',5,'2022-12-07 08:22:13','2022-12-07 08:22:13'),(8,'ORDER','CCBRT/QT-202212',3,'2022-12-07 08:22:45','2022-12-07 08:22:45'),(9,'ORDER','BKNG-202212',6,'2022-12-07 09:02:43','2022-12-07 09:02:43'),(10,'ORDER','BKNG-202212',7,'2022-12-07 09:04:56','2022-12-07 09:04:56'),(11,'ORDER','BKNG-202212',8,'2022-12-07 09:08:17','2022-12-07 09:08:17'),(12,'ORDER','BKNG-202212',9,'2022-12-07 09:11:46','2022-12-07 09:11:46'),(13,'ORDER','CCBRT/QT-202212',4,'2022-12-07 09:14:18','2022-12-07 09:14:18'),(14,'ORDER','CCBRT/QT-202212',5,'2022-12-07 09:15:54','2022-12-07 09:15:54'),(15,'ORDER','BKNG-202212',10,'2022-12-14 12:22:30','2022-12-14 12:22:30'),(16,'ORDER','BKNG-202212',11,'2022-12-14 12:37:53','2022-12-14 12:37:53'),(17,'ORDER','CCBRT/QT-202212',6,'2022-12-14 12:42:22','2022-12-14 12:42:22'),(18,'ORDER','CCBRT/QT-202212',7,'2022-12-14 12:45:10','2022-12-14 12:45:10'),(19,'ORDER','BKNG-202212',12,'2022-12-14 12:51:27','2022-12-14 12:51:27'),(20,'ORDER','CCBRT/QT-202212',8,'2022-12-14 12:52:22','2022-12-14 12:52:22'),(21,'ORDER','BKNG-202212',13,'2022-12-14 13:36:44','2022-12-14 13:36:44'),(22,'ORDER','CCBRT/QT-202212',9,'2022-12-14 14:24:13','2022-12-14 14:24:13'),(23,'ORDER','BKNG-202212',14,'2022-12-14 14:34:11','2022-12-14 14:34:11'),(24,'ORDER','CCBRT/QT-202212',10,'2022-12-14 15:37:06','2022-12-14 15:37:06'),(25,'ORDER','CCBRT/QT-202212',11,'2022-12-14 15:44:17','2022-12-14 15:44:17'),(26,'ORDER','BKNG-202212',15,'2022-12-14 15:55:55','2022-12-14 15:55:55'),(27,'ORDER','CCBRT/QT-202212',12,'2022-12-14 16:18:39','2022-12-14 16:18:39'),(28,'ORDER','BKNG-202212',16,'2022-12-15 07:01:42','2022-12-15 07:01:42'),(29,'ORDER','CCBRT/QT-202212',13,'2022-12-15 07:27:53','2022-12-15 07:27:53'),(30,'ORDER','BKNG-202212',17,'2022-12-15 07:34:49','2022-12-15 07:34:49'),(31,'ORDER','CCBRT/QT-202212',14,'2022-12-15 07:35:41','2022-12-15 07:35:41'),(32,'ORDER','BKNG-202212',18,'2022-12-15 07:40:27','2022-12-15 07:40:27'),(33,'ORDER','CCBRT/QT-202212',15,'2022-12-15 07:42:15','2022-12-15 07:42:15'),(34,'ORDER','CCBRT/QT-202212',16,'2022-12-15 07:56:32','2022-12-15 07:56:32'),(35,'ORDER','BKNG-202212',19,'2022-12-15 08:01:55','2022-12-15 08:01:55'),(36,'ORDER','CCBRT/QT-202212',17,'2022-12-15 08:12:47','2022-12-15 08:12:47'),(37,'ORDER','BKNG-202212',20,'2022-12-15 08:19:28','2022-12-15 08:19:28'),(38,'ORDER','CCBRT/QT-202212',18,'2022-12-15 08:21:01','2022-12-15 08:21:01'),(39,'ORDER','CCBRT/QT-202212',19,'2022-12-15 12:30:19','2022-12-15 12:30:19'),(40,'ORDER','CCBRT/QT-202212',20,'2022-12-15 12:32:32','2022-12-15 12:32:32'),(41,'ORDER','CCBRT/QT-202212',21,'2022-12-15 12:33:15','2022-12-15 12:33:15'),(42,'ORDER','BKNG-202212',21,'2022-12-15 13:05:27','2022-12-15 13:05:27'),(43,'ORDER','CCBRT/QT-202212',22,'2022-12-15 13:06:26','2022-12-15 13:06:26'),(44,'ORDER','BKNG-202212',22,'2022-12-15 13:34:09','2022-12-15 13:34:09'),(45,'ORDER','CCBRT/QT-202212',23,'2022-12-15 13:35:07','2022-12-15 13:35:07'),(46,'ORDER','BKNG-202212',23,'2022-12-15 13:44:58','2022-12-15 13:44:58'),(47,'ORDER','CCBRT/QT-202212',24,'2022-12-15 13:45:58','2022-12-15 13:45:58'),(48,'ORDER','CCBRT/QT-202212',25,'2022-12-15 14:02:04','2022-12-15 14:02:04'),(49,'ORDER','CCBRT/QT-202212',26,'2022-12-15 14:03:44','2022-12-15 14:03:44'),(50,'ORDER','BKNG-202212',24,'2022-12-15 14:53:18','2022-12-15 14:53:18'),(51,'ORDER','CCBRT/QT-202212',27,'2022-12-15 14:55:19','2022-12-15 14:55:19'),(52,'ORDER','BKNG-202212',25,'2022-12-16 09:58:29','2022-12-16 09:58:29'),(53,'ORDER','CCBRT/QT-202212',28,'2022-12-16 11:00:13','2022-12-16 11:00:13'),(54,'ORDER','CCBRT/QT-202212',29,'2022-12-16 11:00:51','2022-12-16 11:00:51'),(55,'ORDER','CCBRT/QT-202212',30,'2022-12-16 11:45:46','2022-12-16 11:45:46'),(56,'ORDER','CCBRT/QT-202212',31,'2022-12-16 14:42:50','2022-12-16 14:42:50'),(57,'ORDER','CCBRT/QT-202212',32,'2022-12-16 14:47:01','2022-12-16 14:47:01'),(58,'ORDER','CCBRT/QT-202212',33,'2022-12-16 15:04:23','2022-12-16 15:04:23'),(59,'ORDER','CCBRT/QT-202212',34,'2022-12-16 16:03:01','2022-12-16 16:03:01'),(60,'ORDER','CCBRT/QT-202212',35,'2022-12-16 16:04:59','2022-12-16 16:04:59'),(61,'ORDER','BKNG-202212',26,'2022-12-19 10:09:13','2022-12-19 10:09:13'),(62,'ORDER','CCBRT/QT-202212',36,'2022-12-19 10:12:10','2022-12-19 10:12:10'),(63,'ORDER','BKNG-202212',27,'2022-12-19 10:34:35','2022-12-19 10:34:35'),(64,'ORDER','CCBRT/QT-202212',37,'2022-12-19 10:35:07','2022-12-19 10:35:07'),(65,'ORDER','BKNG-202212',28,'2022-12-20 12:20:22','2022-12-20 12:20:22'),(66,'ORDER','BKNG-202212',29,'2022-12-20 12:22:18','2022-12-20 12:22:18'),(67,'ORDER','CCBRT/QT-202212',38,'2022-12-20 13:54:01','2022-12-20 13:54:01'),(68,'ORDER','ORD-202301',1,'2023-01-23 09:29:07','2023-01-23 09:29:07'),(69,'ORDER','ORD-202301',2,'2023-01-23 09:44:58','2023-01-23 09:44:58'),(70,'ORDER','ORD-202301',3,'2023-01-24 11:22:14','2023-01-24 11:22:14'),(71,'ORDER','ORD-202301',4,'2023-01-24 12:08:24','2023-01-24 12:08:24'),(72,'ORDER','ORD-202301',5,'2023-01-27 07:47:52','2023-01-27 07:47:52'),(73,'ORDER','BKNG-202301',1,'2023-01-27 08:04:41','2023-01-27 08:04:41'),(74,'ORDER','CCBRT/QT-202301',1,'2023-01-27 08:06:01','2023-01-27 08:06:01'),(75,'ORDER','ORD-202301',6,'2023-01-27 11:56:08','2023-01-27 11:56:08'),(76,'ORDER','BKNG-202301',2,'2023-01-27 12:44:13','2023-01-27 12:44:13'),(77,'ORDER','CCBRT/QT-202301',2,'2023-01-27 12:46:14','2023-01-27 12:46:14'),(78,'ORDER','BKNG-202301',3,'2023-01-30 09:49:45','2023-01-30 09:49:45'),(79,'ORDER','CCBRT/QT-202301',3,'2023-01-30 09:50:41','2023-01-30 09:50:41'),(80,'ORDER','ORD-202302',1,'2023-02-02 14:53:13','2023-02-02 14:53:13'),(81,'ORDER','BKNG-202302',1,'2023-02-09 12:43:23','2023-02-09 12:43:23'),(82,'ORDER','BKNG-202302',2,'2023-02-13 13:48:05','2023-02-13 13:48:05'),(83,'ORDER','BKNG-202302',3,'2023-02-13 13:52:58','2023-02-13 13:52:58'),(84,'ORDER','CCBRT/QT-202302',1,'2023-02-13 13:54:19','2023-02-13 13:54:19'),(85,'ORDER','CCBRT/QT-202302',2,'2023-02-13 13:57:42','2023-02-13 13:57:42'),(86,'ORDER','BKNG-202302',4,'2023-02-13 16:54:44','2023-02-13 16:54:44'),(87,'ORDER','CCBRT/QT-202302',3,'2023-02-13 16:56:24','2023-02-13 16:56:24'),(88,'ORDER','BKNG-202302',5,'2023-02-14 09:03:44','2023-02-14 09:03:44'),(89,'ORDER','CCBRT/QT-202302',4,'2023-02-14 09:04:57','2023-02-14 09:04:57'),(90,'ORDER','ORD-202303',1,'2023-03-06 15:19:50','2023-03-06 15:19:50'),(91,'ORDER','ORD-202303',2,'2023-03-06 15:27:29','2023-03-06 15:27:29'),(92,'ORDER','ORD-202303',3,'2023-03-06 15:35:13','2023-03-06 15:35:13'),(93,'ORDER','ORD-202303',4,'2023-03-06 15:38:08','2023-03-06 15:38:08'),(94,'ORDER','ORD-202303',5,'2023-03-06 15:44:55','2023-03-06 15:44:55'),(95,'ORDER','ORD-202307',1,'2023-07-04 17:19:34','2023-07-04 17:19:34'),(96,'ORDER','BKNG-202307',1,'2023-07-26 12:54:49','2023-07-26 12:54:49'),(97,'ORDER','CCBRT/QT-202307',1,'2023-07-26 12:56:50','2023-07-26 12:56:50');

--
-- Table structure for table `learning_aids`
--

CREATE TABLE `learning_aids` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL,
  `course_module_id` int(11) NOT NULL,
  `description` text,
  `learning_material` varchar(150) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `learning_aids`
--

INSERT INTO `learning_aids` VALUES (1,9,21,'Desc','Product ticketing.pdf','2023-01-21 14:25:15','2023-01-21 14:25:15'),(4,10,22,'Desc1234 fefefefefe fefefe bra bra brabra bra','BATCH MANAGEMENT.pdf','2023-01-22 08:40:21','2023-01-22 10:20:25'),(5,34,49,'fewfwefw','Faraja Items 701-800 Alphabet M-N-O.pdf','2023-01-23 12:12:06','2023-01-23 12:12:06');

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

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

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2021_09_12_070859_create_course_categories_table',1),(6,'2021_09_12_071123_create_course_accreditation_table',1),(7,'2021_09_12_071123_create_course_providers_table',1),(8,'2021_09_12_074632_create_price_taxes_table',1),(9,'2021_09_12_074833_create_course_presenters_table',1),(10,'2021_09_12_080120_create_venues_table',1),(11,'2021_09_12_150045_create_venue_rooms_table',1),(12,'2021_09_13_060512_create_courses_table',1),(13,'2021_09_13_071407_create_course_sessions_table',1),(14,'2021_09_13_152112_create_session_presenters_table',1),(15,'2021_09_23_124234_add_course_cover_to_courses',1),(16,'2021_09_27_165703_add_room_capacity_to_venue_rooms',1),(17,'2021_09_27_180853_add_publish_status_to_course_categories',1),(18,'2021_09_28_053952_add_publish_status_to_courses',1),(19,'2021_09_29_114306_create_course_modules_table',1),(20,'2021_09_30_031750_add_course_module_id_to_course_sessions_table',1),(21,'2021_10_26_054020_create_candidates_table',1),(22,'2021_10_26_090920_create_certificate_templates_table',1),(23,'2021_10_26_094820_create_notification_templates_table',1),(24,'2021_10_27_050841_create_course_registration_table',1),(25,'2021_10_28_194241_create_registration_table',1),(26,'2021_12_09_184841_create_resource_table',1),(27,'2021_12_10_232612_create_session_resources_table',1),(28,'2021_12_12_211203_add_price_to_course_module',1),(29,'2021_12_13_184341_create_order_table',1),(30,'2021_12_13_184741_create_order_item_table',1),(31,'2021_12_13_191203_add_session_to_registration',1),(32,'2021_12_14_123241_create_system_setting_table',1),(33,'2021_12_14_171141_create_key_number_table',1),(34,'2021_12_15_141841_send_invoice_notification_seed',1),(35,'2021_12_15_141841_tibapay_system_setting_seed',1),(36,'2021_12_15_235441_add_control_number_order_table',1),(37,'2021_12_16_132441_add_pay_status_order_table',1),(38,'2021_12_16_133441_successful_payment_notification_seed',1),(39,'2021_12_16_144041_tibapay_update_paid_system_setting_seed',1),(40,'2021_12_16_151741_create_registration_stage_table',1),(41,'2021_12_16_185441_add_complete_profile_key_candidate_table',1),(42,'2021_12_16_193641_successful_enrollment_notification_seed',1),(43,'2021_12_20_195803_add_attendance_to_registration',1),(44,'2021_12_26_172841_create_document_library_table',1),(45,'2021_12_26_190341_document_library_update_system_setting_seed',1),(46,'2022_05_09_141211_create_permission_tables',1),(47,'2022_05_13_103733_add_price_currency_to_courses',1),(48,'2022_05_17_122041_add_permission_title_to_permission',1),(49,'2022_05_19_125252_login_credentials_seed',1),(50,'2022_05_23_101905_create_events_table',1),(51,'2022_05_24_150827_add_course_id_to_resource',1),(52,'2022_05_24_151108_add_course_module_id_to_resource',1),(53,'2022_05_24_195415_add_file_name_to_resource',1),(54,'2022_05_26_142243_add_certificate_file_to_certificate_templates',1),(55,'2022_05_31_074531_add_is_banned_to_users_table',1),(56,'2022_06_01_112626_certificate_template_seed',1),(57,'2022_06_04_214809_create_payment_proofs_table',1),(58,'2022_06_06_121640_add_certified_to_registration',1),(59,'2022_06_08_195545_add_column_to_registrations_table',1),(60,'2022_06_10_062135_add_flag_column_to_certificate_templates',1),(61,'2022_06_23_064750_create_attendances_table',1),(62,'2022_06_23_064846_create_candidate_attendances_table',1),(63,'2022_06_25_080709_add_columns_to_course_modules_table',1),(64,'2022_06_25_082953_create_course_credits_table',1),(65,'2022_06_25_132748_add_candidate_id_to_payment_proofs',1),(66,'2022_06_25_212821_create_certificate_signatures_table',1),(67,'2022_06_27_000624_add_session_no_to_course_sessions_table',1),(68,'2022_06_29_100818_create_scholarships_table',1),(69,'2022_06_29_100901_create_scholarship_criterias_table',1),(70,'2022_06_30_191826_add_columns_to_scholarship_criterials_table',1),(71,'2022_07_01_083704_update_organisation_column_to_scholarship_criterias_table',1),(72,'2022_07_04_195129_add_column_wait_status_to_regitrations_table',1),(73,'2022_07_05_120015_add_publish_column_to_scholarships_table',1),(74,'2022_07_05_191907_create_terms_conditions_table',1),(75,'2022_07_14_071923_create_countries_table',1),(76,'2022_07_15_060152_update_organisation_column_to_candidates_table',1),(77,'2022_07_18_080151_create_order_candidates_table',1),(78,'2022_07_19_193455_notification_template_seed',1),(79,'2022_07_19_224711_waiting_notification_template_seed',1),(80,'2022_07_20_154129_add_order_id_to_payment_proofs_table',1),(81,'2022_07_21_120614_create_disabilities_table',1),(82,'2022_07_21_120642_add_disabilities_seed',1),(83,'2022_07_21_142739_add_columns_to_order_items_table',1),(84,'2022_07_21_151915_add_email_columns_to_registrations_table',1),(85,'2022_07_23_201958_add_scholarship_id_to_orders_table',1),(86,'2022_07_26_113519_send_link_template_seed',1),(87,'2022_07_29_200555_add_acreditor_column_to_scholarship_criterias',1),(88,'2022_07_30_211645_add_signatures_to_certificate_templates',1),(89,'2022_08_06_072838_create_acreditor_criterias_table',1),(90,'2022_08_07_192350_add_columns_to_session_resources_table',1),(91,'2022_08_11_072930_create_publish_statuses_table',1),(92,'2022_08_11_200003_add_columns_to_orders_table',1),(93,'2022_08_11_201119_add_waiting_status_column_to_orders_table',1),(94,'2022_08_13_102355_change_status_column_at_candidate_attendances_table',1),(95,'2022_08_17_072330_change_waiting_status_column_at_registrations_table',2),(96,'2022_08_17_103055_change_limit_usage_column_at_scholarships_table',3),(97,'2022_08_19_120619_create_rental_services_table',4),(98,'2022_08_21_103737_add_price_column_to_venue_rooms_table',4),(99,'2022_08_21_105553_add_booking_status_column_to_orders_table',4),(100,'2022_08_24_021901_drop_unique_from_users_table',5),(101,'2022_08_25_095626_add_price_currency_to_orders_table',6),(102,'2022_08_25_095649_add_price_currency_to_scholarships_table',6);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--

INSERT INTO `model_has_permissions` VALUES (53,'App\\Models\\User',27),(53,'App\\Models\\User',28),(53,'App\\Models\\User',29),(53,'App\\Models\\User',30),(53,'App\\Models\\User',31);

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',3),(1,'App\\Models\\User',4),(1,'App\\Models\\User',25),(2,'App\\Models\\User',27),(2,'App\\Models\\User',28),(2,'App\\Models\\User',29),(2,'App\\Models\\User',30),(2,'App\\Models\\User',31);

--
-- Table structure for table `module_credits`
--

CREATE TABLE `module_credits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `creditor_id` bigint(20) unsigned DEFAULT NULL,
  `course_id` bigint(20) unsigned DEFAULT NULL,
  `module_id` bigint(20) unsigned DEFAULT NULL,
  `credits` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `course_creditor_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `module_credits_creditor_id_foreign` (`creditor_id`),
  KEY `module_credits_course_creditor_id_foreign` (`course_creditor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `module_credits`
--

INSERT INTO `module_credits` VALUES (1,1,7,1,'10','2022-12-05 13:39:06','2022-12-05 13:39:06',1),(2,2,6,2,'5','2022-12-05 13:48:34','2022-12-05 13:48:34',2),(3,3,5,3,'5','2022-12-05 13:54:18','2022-12-05 13:54:18',3),(4,2,4,4,'15','2022-12-05 13:58:24','2022-12-05 13:58:24',4),(5,1,4,4,'10','2022-12-05 13:58:24','2022-12-05 13:58:24',5),(6,4,3,5,'7','2022-12-05 14:04:18','2022-12-05 14:04:18',6),(7,1,2,6,'15','2022-12-05 14:08:49','2022-12-05 14:08:49',7),(8,1,7,8,'0','2022-12-07 05:28:33','2022-12-07 05:28:33',1),(9,1,8,9,NULL,'2022-12-23 04:54:25','2022-12-23 04:54:25',11),(10,1,8,10,NULL,'2022-12-23 04:54:25','2022-12-23 04:54:25',11),(11,1,8,11,NULL,'2022-12-23 04:54:25','2022-12-23 04:54:25',11),(12,1,8,12,NULL,'2022-12-23 04:54:25','2022-12-23 04:54:25',11),(13,1,8,13,NULL,'2022-12-23 04:54:25','2022-12-23 04:54:25',11),(14,1,8,14,NULL,'2022-12-23 04:54:26','2022-12-23 04:54:26',11),(15,1,8,15,NULL,'2022-12-23 04:54:26','2022-12-23 04:54:26',11),(16,1,8,16,NULL,'2022-12-23 04:54:26','2022-12-23 04:54:26',11),(17,1,8,17,NULL,'2022-12-23 04:54:26','2022-12-23 04:54:26',11),(18,1,8,18,NULL,'2022-12-23 04:54:26','2022-12-23 04:54:26',11),(19,1,8,19,NULL,'2022-12-23 04:54:26','2022-12-23 04:54:26',11),(20,1,8,20,NULL,'2022-12-23 04:54:27','2022-12-23 04:54:27',11),(21,2,8,9,NULL,'2022-12-23 04:54:47','2022-12-23 04:54:47',12),(22,2,8,10,NULL,'2022-12-23 04:54:47','2022-12-23 04:54:47',12),(23,2,8,11,NULL,'2022-12-23 04:54:48','2022-12-23 04:54:48',12),(24,2,8,12,NULL,'2022-12-23 04:54:48','2022-12-23 04:54:48',12),(25,2,8,13,NULL,'2022-12-23 04:54:48','2022-12-23 04:54:48',12),(26,2,8,14,NULL,'2022-12-23 04:54:48','2022-12-23 04:54:48',12),(27,2,8,15,NULL,'2022-12-23 04:54:48','2022-12-23 04:54:48',12),(28,2,8,16,NULL,'2022-12-23 04:54:48','2022-12-23 04:54:48',12),(29,2,8,17,NULL,'2022-12-23 04:54:49','2022-12-23 04:54:49',12),(30,2,8,18,NULL,'2022-12-23 04:54:49','2022-12-23 04:54:49',12),(31,2,8,19,NULL,'2022-12-23 04:54:49','2022-12-23 04:54:49',12),(32,2,8,20,NULL,'2022-12-23 04:54:49','2022-12-23 04:54:49',12),(33,1,29,41,NULL,'2022-12-23 05:01:31','2022-12-23 05:01:31',13),(34,1,32,45,'8','2022-12-23 05:42:27','2022-12-23 05:42:27',14),(35,2,32,45,'16','2022-12-23 05:42:28','2022-12-23 05:42:28',15),(36,1,32,46,'8','2022-12-23 05:44:47','2022-12-23 05:44:47',14),(37,2,32,46,'16','2022-12-23 05:44:48','2022-12-23 05:44:48',15),(38,1,32,47,'8','2022-12-23 05:47:42','2022-12-23 05:47:42',14),(39,2,32,47,'16','2022-12-23 05:47:42','2022-12-23 05:47:42',15),(40,1,32,48,'8','2022-12-23 05:50:14','2022-12-23 05:50:14',14),(41,2,32,48,'8','2022-12-23 05:50:14','2022-12-23 05:50:14',15),(42,7,34,49,'2','2023-01-19 10:40:54','2023-01-19 10:40:54',16),(43,8,34,49,'4','2023-01-19 10:40:55','2023-01-19 10:40:55',17),(44,7,34,50,'20','2023-01-21 06:03:16','2023-01-21 06:24:24',16),(45,8,34,50,'26','2023-01-21 06:03:17','2023-01-21 06:04:10',17),(46,8,41,51,'2','2023-01-22 13:34:47','2023-01-23 09:17:09',18),(47,7,41,51,'1','2023-01-22 13:34:47','2023-01-23 09:17:09',19),(48,8,41,52,'4','2023-01-22 13:37:01','2023-01-22 13:37:01',18),(49,7,41,52,'4','2023-01-22 13:37:01','2023-01-22 13:37:01',19),(50,7,34,53,'4','2023-01-23 06:03:45','2023-01-23 06:03:45',16),(51,8,34,53,'5','2023-01-23 06:03:46','2023-01-23 06:03:46',17),(52,7,42,54,'1','2023-01-23 08:23:36','2023-01-23 08:38:21',20),(53,8,42,54,'5','2023-01-23 08:23:37','2023-01-23 08:23:37',21),(58,7,42,57,'7','2023-01-23 10:01:16','2023-01-23 10:01:16',20),(59,8,42,57,'8','2023-01-23 10:01:16','2023-01-23 10:01:16',21),(60,7,43,58,'5','2023-01-27 08:25:58','2023-01-27 08:25:58',22),(61,8,43,58,'9','2023-01-27 08:25:58','2023-01-27 08:25:58',23),(62,3,29,41,NULL,'2023-02-07 05:25:42','2023-02-07 05:25:42',24),(65,3,27,39,NULL,'2023-02-07 05:31:12','2023-02-07 05:31:12',27),(66,2,43,58,NULL,'2023-02-07 05:47:40','2023-02-07 05:47:40',28),(71,7,45,60,'5','2023-02-28 06:46:45','2023-02-28 06:46:45',29),(72,9,45,60,'4','2023-02-28 06:46:45','2023-02-28 06:46:45',31),(73,8,45,60,'8','2023-02-28 06:46:46','2023-02-28 06:46:46',32),(74,7,45,61,'5','2023-02-28 06:53:24','2023-02-28 06:53:24',29),(75,9,45,61,'3','2023-02-28 06:53:24','2023-02-28 06:53:24',31),(76,8,45,61,'5','2023-02-28 06:53:24','2023-02-28 06:53:24',32);

--
-- Table structure for table `notification_templates`
--

CREATE TABLE `notification_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `send_via_email` smallint(6) NOT NULL DEFAULT '0',
  `send_via_sms` smallint(6) NOT NULL DEFAULT '0',
  `template` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_templates`
--

INSERT INTO `notification_templates` VALUES (1,'send.invoice','Send Invoice',1,0,NULL,NULL,NULL),(2,'send.invoice.on.generation','Send Invoice On Generation',1,0,'You have succsessfully created an order\r\nClick the link below to edit, remove or add attendees in order.\r\n<br/>\r\nAlso you can generate control number or cancel order before making payment\r\n<br/>\r\n\r\n<a href=\"{{url($link)}}\" class=\"btn btn-info btn-sm mx-2\">Make Payment</a>',NULL,'2022-08-29 04:05:59'),(3,'successful.payment','Successful Payment',1,0,'Hi {{ $order->contact_first_name }} {{ $order->contact_last_name }},\n<br/>\n<br/>Your payment was received successfully.\n@if($order->payer_type == \"2\")\n    <br/>You will receive enrollment instructions.\n@else\n    <br/>All attendees will receive enrollment instructions.\n@endif\n<br/>\n<br/>Thank you.\n','2022-08-15 08:27:09','2022-08-15 08:27:09'),(4,'successful.enrollment','Successful Enrollment',1,0,'Dear {{ $registration->first_name }} {{ $registration->last_name }},\r\n<br/>\r\n<br/>Your have successfully enrolled in {{ $registration->course_title }} training.\r\n<br/>\r\n<br/>Thank you.','2022-08-15 08:27:09','2022-08-29 04:02:06'),(5,'course.enrollment.instructions','Course Enrollment Instructions',1,0,'Hi {{ $registration->first_name }} {{ $registration->last_name }},\n<br/>\n<br/>Your have successfully been registered for {{ $registration->course_title }}.\n<br/>Please complete your profile to complete the enrollment process.\n<br/><a href=\"{{ asset(\'/web/complete-profile/\' . $registration->complete_profile_key.\'/\'.$registration->id) }}\">Click here to complete your profile</a>\n<br/>\n<br/>Thank you.\n','2022-08-15 08:27:09','2022-08-15 08:27:09'),(6,'login.credentials','Login Credentials',1,0,'<h1>Dear, {{ $name }}</h1>\r\n<p>Welcome To TMS. Please find your login details below</p>\r\n<p><b>Username: </b> {{$username}}</p>\r\n<p><b>Password: </b> {{$password}}</p>\r\n<p>Click the link below to access your self-service portal</p>\r\n<a href=\"{{url($link)}}\" class=\"btn btn-info btn-sm mx-2\">Login Here</a>\r\n<p>Thank you </p>','2022-08-15 08:27:09','2022-09-05 14:54:37'),(7,'certificate.template','Certificate Template',1,0,'<img src=\"logo.png\" alt=\"\">\r\n<br/>\r\n<h6>Certificate of Completion</h6>\r\n<br/>\r\n<p> Thank you for completing our course. </p>\r\n<br/>From the CCBRT Academy\r\n<br/>\r\n<br/>Thank you.','2022-08-15 08:27:09','2023-01-27 05:28:55'),(8,'remove.candidate.from.order','Remove candidate from order',1,0,'Hi {{ $registration->first_name }} {{ $registration->last_name }},\n<br/>\n<br/>Your have successfully been enrolled for {{ $registration->course_title }}.\n<br/>\n<br/>Thank you.\n','2022-08-15 08:27:10','2022-08-15 08:27:10'),(9,'cancel.order','Order was canceled',1,0,'Hi {{ $order->contact_first_name }} {{ $order->contact_last_name }},\n<br/>\n<br/>Your payment was received successfully.\n@if($order->payer_type == \"2\")\n    <br/>You will receive enrollment instructions.\n@else\n    <br/>All attendees will receive enrollment instructions.\n@endif\n<br/>\n<br/>Thank you.\n','2022-08-15 08:27:10','2022-08-15 08:27:10'),(10,'successful.sholarship','Successfully scholarship',1,0,'Congratulations\r\nThe CCBRT Academy has granted you a scholarship','2022-08-15 08:27:10','2022-08-29 04:00:38'),(11,'waiting.template','Waiting List',1,0,'Waiting\r\n\r\n\r\n','2022-08-15 08:27:10','2022-08-15 08:27:10'),(12,'accept.waiting','Accepting List',1,0,'Accepted','2022-08-15 08:27:10','2022-08-15 08:27:10'),(13,'reject.waiting','Rejected List',1,0,'Hi {{ $registration->first_name }} {{ $registration->last_name }},\n<br/>\n<br/>Your have successfully been enrolled for {{ $registration->course_title }}.\n<br/>\n<br/>Thank you.\n','2022-08-15 08:27:10','2022-08-15 08:27:10'),(14,'add.candidate.to.order','Rejected List',1,0,'Hi {{ $registration->first_name }} {{ $registration->last_name }},\n<br/>\n<br/>Your have successfully been enrolled for {{ $registration->course_title }}.\n<br/>\n<br/>Thank you.\n','2022-08-15 08:27:10','2022-08-15 08:27:10'),(15,'send.payment.link','Send Payment Link',1,0,'Refer Order Number {{$uid}} <br/>\r\nUse the link below to edit, remove or add attendees,\r\n<br/>\r\ncreate control number or cancel order before making payment\r\n<br/>\r\n\r\n<a href=\"{{url($link)}}\" class=\"btn btn-info btn-sm mx-2\">Make Payment</a>','2022-08-15 08:27:10','2022-08-16 04:13:17');

--
-- Table structure for table `order_candidates`
--

CREATE TABLE `order_candidates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `candidate_id` bigint(20) unsigned DEFAULT NULL,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `order_uid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_candidates_candidate_id_foreign` (`candidate_id`),
  KEY `order_candidates_order_id_foreign` (`order_id`),
  CONSTRAINT `order_candidates_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE SET NULL,
  CONSTRAINT `order_candidates_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_candidates`
--

INSERT INTO `order_candidates` VALUES (1,1,1,'ORD-2023010001',NULL,'2023-01-23 09:29:09','2023-01-23 09:29:09'),(2,2,2,'ORD-2023010002',NULL,'2023-01-23 09:45:00','2023-01-23 09:45:00'),(3,3,2,'ORD-2023010002',NULL,'2023-01-23 09:45:02','2023-01-23 09:45:02'),(4,4,3,'ORD-2023010003',NULL,'2023-01-24 11:22:17','2023-01-24 11:22:17'),(5,5,4,'ORD-2023010004',NULL,'2023-01-24 12:08:27','2023-01-24 12:08:27'),(6,6,5,'ORD-2023010005',NULL,'2023-01-27 07:47:54','2023-01-27 07:47:54'),(7,7,5,'ORD-2023010005',NULL,'2023-01-27 07:48:10','2023-01-27 07:48:10'),(8,8,6,'ORD-2023010006',NULL,'2023-01-27 11:56:10','2023-01-27 11:56:10'),(9,9,6,'ORD-2023010006',NULL,'2023-01-27 11:56:15','2023-01-27 11:56:15'),(10,10,7,'ORD-2023020001',NULL,'2023-02-02 14:53:15','2023-02-02 14:53:15'),(11,11,7,'ORD-2023020001',NULL,'2023-02-02 14:53:20','2023-02-02 14:53:20'),(12,12,8,'ORD-2023030001',NULL,'2023-03-06 15:19:54','2023-03-06 15:19:54'),(13,13,8,'ORD-2023030001',NULL,'2023-03-06 15:19:59','2023-03-06 15:19:59'),(14,14,9,'ORD-2023030002',NULL,'2023-03-06 15:27:33','2023-03-06 15:27:33'),(15,15,10,'ORD-2023030003',NULL,'2023-03-06 15:35:15','2023-03-06 15:35:15'),(16,16,11,'ORD-2023030004',NULL,'2023-03-06 15:38:12','2023-03-06 15:38:12'),(17,17,12,'ORD-2023030005',NULL,'2023-03-06 15:45:00','2023-03-06 15:45:00'),(18,18,13,'ORD-2023070001',NULL,'2023-07-04 17:19:34','2023-07-04 17:19:34'),(19,19,13,'ORD-2023070001',NULL,'2023-07-04 17:19:34','2023-07-04 17:19:34');

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT '1',
  `price` double NOT NULL DEFAULT '0',
  `sub_total` double NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `course_id` bigint(20) unsigned DEFAULT NULL,
  `module_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `session_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_items_order_id_foreign` (`order_id`),
  KEY `order_items_course_id_foreign` (`course_id`),
  CONSTRAINT `order_items_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` VALUES (1,1,'Test Course One : Test Module One : Session #1 [2023-01-30 10:00:00]',1,100000,100000,'2023-01-23 09:29:07','2023-01-23 09:29:07',34,'49','1'),(2,2,'Test Course One : Test Module One : Session #1 [2023-01-30 10:00:00]',2,100000,200000,'2023-01-23 09:44:59','2023-01-23 09:44:59',34,'49','1'),(3,3,'Test Course One : Test Module One : Session 2 [2023-01-25 13:00:00]',1,100000,100000,'2023-01-24 11:22:14','2023-01-24 11:22:15',34,'49','2'),(4,4,'Test Course One : Test Module One : Session 2 [2023-01-25 13:00:00]',1,100000,100000,'2023-01-24 12:08:25','2023-01-24 12:08:25',34,'49','2'),(5,5,'Test Course One : Test Module Two : Session #1 [2023-01-27 11:00:00]',2,70000,140000,'2023-01-27 07:47:52','2023-01-27 07:47:52',34,'53','3'),(6,6,'Test Course Four : Infection Prevention and Control : Session #1 [2023-01-27 14:00:00]',2,120000,240000,'2023-01-27 11:56:08','2023-01-27 11:56:09',43,'58','4'),(7,7,'Test Course Two : Test Module One : Session #1 [2023-02-02 18:00:00]',2,120000,240000,'2023-02-02 14:53:13','2023-02-02 14:53:14',41,'51','5'),(8,8,'Child Protection Training : Child Protection Training : Session #3 [2023-03-20 13:00:00]',2,120000,240000,'2023-03-06 15:19:51','2023-03-06 15:19:51',45,'61','17'),(9,9,'Child Protection Training : Child Protection Training : Session #3 [2023-03-20 13:00:00]',1,120000,120000,'2023-03-06 15:27:30','2023-03-06 15:27:31',45,'61','17'),(10,10,'Child Protection Training : Child Protection Training : Session #3 [2023-03-20 13:00:00]',1,120000,120000,'2023-03-06 15:35:13','2023-03-06 15:35:13',45,'61','17'),(11,11,'Child Protection Training : Child Protection Training : Session #3 [2023-03-20 13:00:00]',1,120000,114000,'2023-03-06 15:38:08','2023-03-06 15:38:11',45,'61','17'),(12,12,'Child Protection Training : Child Protection Training : Session #1 [2023-03-07 13:00:00]',1,120000,108000,'2023-03-06 15:44:55','2023-03-06 15:44:58',45,'61','14'),(13,13,'Child Protection Training : Child Abuse and Neglect Prevention : Session #4 [2023-03-07 13:00:00]',2,150000,300000,'2023-07-04 17:19:34','2023-07-04 17:19:34',45,'60','13');

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_date` date NOT NULL,
  `booking_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payer_type` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payer_box_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payer_city_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payer_country_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `paid_amount` double NOT NULL DEFAULT '0',
  `due_amount` double NOT NULL DEFAULT '0',
  `amount` double NOT NULL DEFAULT '0',
  `price_currency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice_status` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `pay_status` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `status` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `control_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `scholarship_id` bigint(20) unsigned DEFAULT NULL,
  `waiting_order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `non_waiting_order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `waiting_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `orders_scholarship_id_foreign` (`scholarship_id`),
  CONSTRAINT `orders_scholarship_id_foreign` FOREIGN KEY (`scholarship_id`) REFERENCES `scholarships` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` VALUES (1,'ORD-2023010001','2023-01-23',NULL,'2',NULL,'5000','Dar es Salaam','Tanzania, United Republic of','Bakili','Kiliba','0738069145','kabyk95@gmail.com',100000,0,100000,'TZS','2','2','2','2022587197831004638028','2023-01-23 09:29:07','2023-01-27 07:48:10',NULL,NULL,NULL,NULL),(2,'ORD-2023010002','2023-01-23',NULL,'2',NULL,'5725','Dar es Salaam','Tanzania, United Republic of','Derick','Kabyemela','0784320281','kabydee@gmail.com',280000,-80000,200000,'TZS','2','1','1',NULL,'2023-01-23 09:44:59','2023-01-27 07:48:07',NULL,NULL,NULL,NULL),(3,'ORD-2023010003','2023-01-24',NULL,'1','TIGO','5000','Dar es Salaam','Tanzania, United Republic of','Festus','Flowin','0692463122','festusflowin@gmail.com',100000,0,100000,'TZS','2','2','2','20221670740858285715312','2023-01-24 11:22:14','2023-01-27 07:48:05',NULL,NULL,NULL,NULL),(4,'ORD-2023010004','2023-01-24',NULL,'1','TIGO','7373','DSM','Tanzania, United Republic of','festus','flowin','0656121885','flowinfestus@gmail.com',0,100000,100000,'TZS','2','1','1',NULL,'2023-01-24 12:08:25','2023-01-27 07:48:02',NULL,NULL,NULL,NULL),(5,'ORD-2023010005','2023-01-27',NULL,'2',NULL,'5000','Dar es Salaam','Tanzania, United Republic of','Derick','Kabyemela','0718527660','kabydee@gmail.com',140000,0,140000,'TZS','2','2','2','202218576947501888038195','2023-01-27 07:47:52','2023-01-27 04:51:14',NULL,NULL,NULL,NULL),(6,'ORD-2023010006','2023-01-27',NULL,'1',NULL,'5725','Dar es Salaam','Tanzania, United Republic of','Edwin','Kashangaki','0894217422','edwin.kashangaki@ccbrt.org',240000,0,240000,'TZS','2','2','2','20221429772336134140429','2023-01-27 11:56:08','2023-01-27 09:06:51',NULL,NULL,NULL,NULL),(7,'ORD-2023020001','2023-02-02',NULL,'1','TrueBits Technologies PLC','5000','Dar es Salaam','Tanzania, United Republic of','Francois','Kabyemela','0692463122','kabydee@gmail.com',0,240000,240000,'TZS','2','1','1',NULL,'2023-02-02 14:53:13','2023-02-02 14:53:20',NULL,NULL,NULL,NULL),(8,'ORD-2023030001','2023-03-06',NULL,'1','Real Time Solutions','5725','Arusha','Tanzania, United Republic of','Derick','Kabyemela','0718527660','kabydee@gmail.com',240000,0,240000,'TZS','2','2','2','20222053256939892523455','2023-03-06 15:19:51','2023-03-06 12:23:40',NULL,NULL,NULL,NULL),(9,'ORD-2023030002','2023-03-06',NULL,'1','Real Time Solutions','9000','Simiyu','Tanzania, United Republic of','Kaijage','Kaizirege','+255 692 463 122','dorianblack255@gmail.com',0,120000,120000,'TZS','2','1','3',NULL,'2023-03-06 15:27:30','2023-03-06 12:29:41',NULL,NULL,NULL,NULL),(10,'ORD-2023030003','2023-03-06',NULL,'1',NULL,'0100','Dodoma','Tanzania, United Republic of','Derick','Kabyemela','0718527660','stevens.general.business.supplies@gmail.com',0,120000,120000,'TZS','2','1','1',NULL,'2023-03-06 15:35:13','2023-03-06 15:35:19',NULL,NULL,NULL,NULL),(11,'ORD-2023030004','2023-03-06',NULL,'1','Real Time Solutions','90142','Simiyu','Tanzania, United Republic of','Derick','Kaijage','0738069145','djsilencer2022@gmail.com',0,114000,114000,'TZS','2','1','1',NULL,'2023-03-06 15:38:08','2023-03-06 15:38:16',2,NULL,NULL,NULL),(12,'ORD-2023030005','2023-03-06',NULL,'2',NULL,'4000','Songea','Tanzania, United Republic of','Deodatha','Museveni','0718527660','fxkabydee@gmail.com',0,108000,108000,'TZS','2','1','1',NULL,'2023-03-06 15:44:55','2023-03-06 15:45:04',1,NULL,NULL,NULL),(13,'ORD-2023070001','2023-07-04',NULL,'2',NULL,'8000','Dodoma','Tanzania, United Republic of','Kaby','Dee','0754805755','kabydee@gmail.com',0,300000,300000,'TZS','1','1','1',NULL,'2023-07-04 17:19:34','2023-07-04 17:19:34',NULL,NULL,NULL,NULL);

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `payment_proofs`
--

CREATE TABLE `payment_proofs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `payment_proof` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `candidate_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_proofs`
--


--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `permission_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'view_users','web',NULL,NULL,'Users'),(2,'add_users','web',NULL,NULL,'Users'),(3,'edit_users','web',NULL,NULL,'Users'),(4,'delete_users','web',NULL,NULL,'Users'),(5,'view_roles','web',NULL,NULL,'Roles'),(6,'add_roles','web',NULL,NULL,'Roles'),(7,'edit_roles','web',NULL,NULL,'Roles'),(8,'delete_roles','web',NULL,NULL,'Roles'),(9,'view_category','web',NULL,NULL,'Category'),(10,'add_category','web',NULL,NULL,'Category'),(11,'edit_category','web',NULL,NULL,'Category'),(12,'delete_category','web',NULL,NULL,'Category'),(13,'view_provider','web',NULL,NULL,'Provider'),(14,'add_provider','web',NULL,NULL,'Provider'),(15,'edit_provider','web',NULL,NULL,'Provider'),(16,'delete_provider','web',NULL,NULL,'Provider'),(17,'view_accreditation','web',NULL,NULL,'Accreditation'),(18,'add_accreditation','web',NULL,NULL,'Accreditation'),(19,'edit_accreditation','web',NULL,NULL,'Accreditation'),(20,'delete_accreditation','web',NULL,NULL,'Accreditation'),(21,'view_venue','web',NULL,NULL,'Venue'),(22,'add_venue','web',NULL,NULL,'Venue'),(23,'edit_venue','web',NULL,NULL,'Venue'),(24,'delete_venue','web',NULL,NULL,'Venue'),(25,'view_price_tax','web',NULL,NULL,'Price Tax'),(26,'add_price_tax','web',NULL,NULL,'Price Tax'),(27,'edit_price_tax','web',NULL,NULL,'Price Tax'),(28,'delete_price_tax','web',NULL,NULL,'Price Tax'),(29,'view_presenter','web',NULL,NULL,'Presenter'),(30,'add_presenter','web',NULL,NULL,'Presenter'),(31,'edit_presenter','web',NULL,NULL,'Presenter'),(32,'delete_presenter','web',NULL,NULL,'Presenter'),(33,'view_resource','web',NULL,NULL,'Resource'),(34,'add_resource','web',NULL,NULL,'Resource'),(35,'edit_resource','web',NULL,NULL,'Resource'),(36,'delete_resource','web',NULL,NULL,'Resource'),(37,'view_course','web',NULL,NULL,'Course'),(38,'add_course','web',NULL,NULL,'Course'),(39,'edit_course','web',NULL,NULL,'Course'),(40,'delete_course','web',NULL,NULL,'Course'),(41,'view_candidate','web',NULL,NULL,'Candidate'),(42,'add_candidate','web',NULL,NULL,'Candidate'),(43,'edit_candidate','web',NULL,NULL,'Candidate'),(44,'delete_candidate','web',NULL,NULL,'Candidate'),(45,'view_order','web',NULL,NULL,'Order'),(46,'add_order','web',NULL,NULL,'Order'),(47,'edit_order','web',NULL,NULL,'Order'),(48,'delete_order','web',NULL,NULL,'Order'),(49,'view_template','web',NULL,NULL,'Template'),(50,'add_template','web',NULL,NULL,'Template'),(51,'edit_template','web',NULL,NULL,'Template'),(52,'delete_template','web',NULL,NULL,'Template'),(53,'candidate_portal','web',NULL,NULL,'Candidate Portal'),(54,'create_report','web',NULL,NULL,'Report'),(55,'view_course_setup','web',NULL,NULL,'Course Setup'),(56,'view_dashboard','web',NULL,NULL,'View Dashboard'),(57,'view_attendance','web',NULL,NULL,'View Attendance'),(58,'system_settings','web',NULL,NULL,'System Setting'),(59,'Admin','web','2022-08-15 08:27:10','2022-08-15 08:27:10',NULL),(60,'view_scholarship','web','2022-08-15 09:17:29','2022-08-15 09:17:29','Scholarship');

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `price_taxes`
--

CREATE TABLE `price_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `price_taxes`
--


--
-- Table structure for table `publish_statuses`
--

CREATE TABLE `publish_statuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `publish_statuses`
--

INSERT INTO `publish_statuses` VALUES (1,'PUBLISHED',NULL,NULL),(2,'DRAFT',NULL,NULL),(3,'ON_HOLD',NULL,NULL);

--
-- Table structure for table `quotation_charges`
--

CREATE TABLE `quotation_charges` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quote_id` bigint(20) unsigned DEFAULT NULL,
  `service_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_type` int(11) DEFAULT NULL,
  `qnty` int(11) DEFAULT NULL,
  `days` int(11) DEFAULT NULL,
  `subtotal` int(11) DEFAULT NULL,
  `total_amount` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quotation_charges_quote_id_foreign` (`quote_id`),
  CONSTRAINT `quotation_charges_quote_id_foreign` FOREIGN KEY (`quote_id`) REFERENCES `rental_quotations` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quotation_charges`
--

INSERT INTO `quotation_charges` VALUES (1,1,'Twiga',0,NULL,NULL,180000,180000,'2022-12-06 09:23:18','2022-12-06 09:23:18'),(2,2,'Pundamilia',0,NULL,NULL,80000,160000,'2022-12-07 06:20:19','2022-12-07 06:20:19'),(3,3,'Kiboko',0,NULL,NULL,350000,350000,'2022-12-07 08:22:45','2022-12-07 08:22:45'),(4,4,'Kanga',0,NULL,NULL,208000,208000,'2022-12-07 09:14:18','2022-12-07 09:14:18'),(5,5,'Kanga',0,NULL,NULL,208000,208000,'2022-12-07 09:15:54','2022-12-07 09:15:54'),(6,6,'Drinks',1,14,1,140000,140000,'2022-12-14 12:42:22','2022-12-14 12:42:22'),(7,6,'Computer Lab -Kipepeo',0,14,1,208000,208000,'2022-12-14 12:42:22','2022-12-14 12:42:22'),(8,7,'Food and Drinks',1,10,1,350000,350000,'2022-12-14 12:45:11','2022-12-14 12:45:11'),(9,7,'Kanga',0,10,1,208000,208000,'2022-12-14 12:45:11','2022-12-14 12:45:11'),(10,8,'Food and Drinks',1,10,1,200000,200000,'2022-12-14 12:52:22','2022-12-14 12:52:22'),(11,8,'Computer Lab -Kipepeo',0,10,1,208000,208000,'2022-12-14 12:52:22','2022-12-14 12:52:22'),(12,9,'Service Demo',1,1,2,6000,6000,'2022-12-14 14:24:14','2022-12-14 14:24:14'),(13,9,'Kiboko',0,3,3,350000,1050000,'2022-12-14 14:24:15','2022-12-14 14:24:15'),(14,10,'sess1',1,2,1,200,200,'2022-12-14 15:37:07','2022-12-14 15:37:07'),(15,10,'Kiboko',0,3,3,0,NULL,'2022-12-14 15:37:07','2022-12-14 15:37:07'),(16,11,'ssss',1,2,1,400,400,'2022-12-14 15:44:19','2022-12-14 15:44:19'),(17,11,'Kiboko',0,3,3,0,NULL,'2022-12-14 15:44:19','2022-12-14 15:44:19'),(18,12,'service name',1,2,1,600,600,'2022-12-14 16:18:40','2022-12-14 16:18:40'),(19,12,'Kiboko',0,3,3,0,NULL,'2022-12-14 16:18:40','2022-12-14 16:18:40'),(20,13,'Popo',0,10,1,53000,53000,'2022-12-15 07:27:54','2022-12-15 07:27:54'),(21,14,'Service',1,2,1,4000,4000,'2022-12-15 07:35:41','2022-12-15 07:35:41'),(22,14,'Swala',0,3,4,0,NULL,'2022-12-15 07:35:42','2022-12-15 07:35:42'),(23,15,'Service 2',1,3,2,60000,60000,'2022-12-15 07:42:16','2022-12-15 07:42:16'),(24,15,'Pundamilia',0,3,3,0,NULL,'2022-12-15 07:42:16','2022-12-15 07:42:16'),(25,16,'Kanga',0,10,1,208000,208000,'2022-12-15 07:56:32','2022-12-15 07:56:32'),(26,17,'Drinks',1,10,1,100000,100000,'2022-12-15 08:12:48','2022-12-15 08:12:48'),(27,17,'Kiboko',0,20,1,350000,350000,'2022-12-15 08:12:48','2022-12-15 08:12:48'),(28,18,'Drinks',1,10,1,50000,50000,'2022-12-15 08:21:02','2022-12-15 08:21:02'),(29,18,'Food',2,20,1,3500,70000,'2022-12-15 08:21:02','2022-12-15 08:21:02'),(30,18,'Kiboko',0,20,1,350000,350000,'2022-12-15 08:21:02','2022-12-15 08:21:02'),(31,19,'Service 1',1,4,1,120000,120000,'2022-12-15 12:30:21','2022-12-15 12:30:21'),(32,19,'Popo',0,5,3,0,NULL,'2022-12-15 12:30:21','2022-12-15 12:30:21'),(33,20,'Service 1',1,4,1,120000,120000,'2022-12-15 12:32:33','2022-12-15 12:32:33'),(34,20,'Popo',0,5,3,0,NULL,'2022-12-15 12:32:34','2022-12-15 12:32:34'),(35,21,'Service 1',1,4,1,120000,120000,'2022-12-15 12:33:16','2022-12-15 12:33:16'),(36,21,'Popo',0,5,3,0,NULL,'2022-12-15 12:33:17','2022-12-15 12:33:17'),(37,22,'Drinks',1,20,1,200000,200000,'2022-12-15 13:06:26','2022-12-15 13:06:26'),(38,22,'Pundamilia',0,10,1,80000,80000,'2022-12-15 13:06:26','2022-12-15 13:06:26'),(39,23,'Drinks',1,15,1,30000,30000,'2022-12-15 13:35:07','2022-12-15 13:35:07'),(40,23,'Twiga',0,20,1,180000,180000,'2022-12-15 13:35:07','2022-12-15 13:35:07'),(41,24,'Servive this',1,1,2,20000,20000,'2022-12-15 13:45:59','2022-12-15 13:45:59'),(42,24,'Pundamilia',0,2,3,80000,240000,'2022-12-15 13:45:59','2022-12-15 13:45:59'),(43,25,'charge per service',1,2,1,2000,2000,'2022-12-15 14:02:04','2022-12-15 14:02:04'),(44,25,'Pundamilia',0,2,3,80000,240000,'2022-12-15 14:02:04','2022-12-15 14:02:04'),(45,26,'charge per service',1,2,1,2000,2000,'2022-12-15 14:03:44','2022-12-15 14:03:44'),(46,26,'Pundamilia',0,2,3,80000,240000,'2022-12-15 14:03:44','2022-12-15 14:03:44'),(47,27,'Computer Lab -Kipepeo',0,10,1,208000,208000,'2022-12-15 14:55:20','2022-12-15 14:55:20'),(48,28,'Pundamilia',0,2,3,80000,240000,'2022-12-16 11:00:13','2022-12-16 11:00:13'),(49,29,'Pundamilia',0,2,3,80000,240000,'2022-12-16 11:00:51','2022-12-16 11:00:51'),(50,30,'hdh',1,2,1,2000,2000,'2022-12-16 11:45:46','2022-12-16 11:45:46'),(51,30,'Pundamilia',0,2,3,80000,240000,'2022-12-16 11:45:47','2022-12-16 11:45:47'),(52,31,'hddh',1,2,1,6000,6000,'2022-12-16 14:42:50','2022-12-16 14:42:50'),(53,31,'Pundamilia',0,2,3,80000,240000,'2022-12-16 14:42:51','2022-12-16 14:42:51'),(54,32,'hshsh',1,2,1,600,600,'2022-12-16 14:47:02','2022-12-16 14:47:02'),(55,32,'Pundamilia',0,2,3,80000,240000,'2022-12-16 14:47:02','2022-12-16 14:47:02'),(56,33,'Pundamilia',0,2,3,80000,240000,'2022-12-16 15:04:23','2022-12-16 15:04:23'),(57,34,'hshs',1,2,1,40000,40000,'2022-12-16 16:03:02','2022-12-16 16:03:02'),(58,34,'Pundamilia',0,2,3,80000,240000,'2022-12-16 16:03:02','2022-12-16 16:03:02'),(59,35,'gdgdg',1,2,1,600,600,'2022-12-16 16:05:00','2022-12-16 16:05:00'),(60,35,'Pundamilia',0,2,3,80000,240000,'2022-12-16 16:05:00','2022-12-16 16:05:00'),(61,36,'Food and Drinks',1,10,1,10000,10000,'2022-12-19 10:12:10','2022-12-19 10:12:10'),(62,36,'Computer Lab -Kipepeo',0,10,1,208000,208000,'2022-12-19 10:12:11','2022-12-19 10:12:11'),(63,37,'Drinks',1,15,1,15000,15000,'2022-12-19 10:35:07','2022-12-19 10:35:07'),(64,37,'Kanga',0,8,1,208000,208000,'2022-12-19 10:35:07','2022-12-19 10:35:07'),(65,38,'Drinks',1,14,1,42000,42000,'2022-12-20 13:54:01','2022-12-20 13:54:01'),(66,38,'Computer Lab -Kipepeo',0,10,1,208000,208000,'2022-12-20 13:54:01','2022-12-20 13:54:01'),(67,39,'Drinks',1,10,2,2400000,2400000,'2023-01-27 08:06:01','2023-01-27 08:06:01'),(68,39,'Twiga',0,10,2,180000,360000,'2023-01-27 08:06:02','2023-01-27 08:06:02'),(69,40,'Drinks',1,10,2,200000,200000,'2023-01-27 12:46:15','2023-01-27 12:46:15'),(70,40,'Popo',0,10,1,53000,53000,'2023-01-27 12:46:15','2023-01-27 12:46:15'),(71,41,'Drinks & Food',1,15,2,300000,300000,'2023-01-30 09:50:41','2023-01-30 09:50:41'),(72,41,'Kanga',0,15,3,208000,624000,'2023-01-30 09:50:42','2023-01-30 09:50:42'),(73,42,'Photographer',1,1,1,50000,50000,'2023-02-13 13:54:19','2023-02-13 13:54:19'),(74,42,'Drinks',2,20,2,2000,80000,'2023-02-13 13:54:19','2023-02-13 13:54:19'),(75,42,'Popo',0,20,2,53000,106000,'2023-02-13 13:54:19','2023-02-13 13:54:19'),(76,43,'Popo',0,3,3,53000,159000,'2023-02-13 13:57:42','2023-02-13 13:57:42'),(77,44,'Photographer',1,1,1,200000,200000,'2023-02-13 16:56:24','2023-02-13 16:56:24'),(78,44,'Drinks',2,10,2,1000,20000,'2023-02-13 16:56:24','2023-02-13 16:56:24'),(79,44,'Computer Lab -Kipepeo',0,10,2,208000,416000,'2023-02-13 16:56:24','2023-02-13 16:56:24'),(80,45,'Drinks',1,3,2,6000,6000,'2023-02-14 09:04:57','2023-02-14 09:04:57'),(81,45,'Photograph',2,3,1,1000,3000,'2023-02-14 09:04:57','2023-02-14 09:04:57'),(82,45,'Twiga',0,3,1,180000,180000,'2023-02-14 09:04:57','2023-02-14 09:04:57'),(83,46,'Accomodation',2,23,2,35000,1610000,'2023-07-26 12:56:50','2023-07-26 12:56:50'),(84,46,'Tembo',0,23,2,0,NULL,'2023-07-26 12:56:51','2023-07-26 12:56:51');

--
-- Table structure for table `quote_payment_proofs`
--

CREATE TABLE `quote_payment_proofs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quote_id` bigint(20) unsigned DEFAULT NULL,
  `payment_proof` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quote_payment_proofs_quote_id_foreign` (`quote_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quote_payment_proofs`
--

INSERT INTO `quote_payment_proofs` VALUES (1,5,'ABD INVOICE190822.pdf','2022-12-07 06:35:26','2022-12-07 06:35:26');

--
-- Table structure for table `registration_stages`
--

CREATE TABLE `registration_stages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `registration_id` bigint(20) unsigned NOT NULL,
  `status` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notify` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `notification_status` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `registration_stages_registration_id_foreign` (`registration_id`),
  CONSTRAINT `registration_stages_registration_id_foreign` FOREIGN KEY (`registration_id`) REFERENCES `registrations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `registration_stages`
--

INSERT INTO `registration_stages` VALUES (1,1,'4','1','2','2023-01-23 06:32:45','2023-01-23 06:32:52'),(2,2,'4','1','2','2023-01-23 06:49:46','2023-01-23 06:49:56'),(3,3,'4','1','2','2023-01-23 06:49:46','2023-01-23 06:49:52'),(4,6,'4','1','2','2023-01-27 04:52:15','2023-01-27 04:52:21'),(5,7,'4','1','2','2023-01-27 04:52:16','2023-01-27 04:52:18'),(6,8,'4','1','2','2023-01-27 09:20:49','2023-01-27 09:20:55'),(7,9,'4','1','2','2023-01-27 09:20:50','2023-01-27 09:20:53'),(8,10,'4','1','2','2023-02-02 12:25:11','2023-02-02 12:25:19'),(9,11,'4','1','2','2023-02-02 12:25:12','2023-02-02 12:25:17'),(10,12,'4','1','2','2023-03-06 12:23:36','2023-03-06 12:23:45'),(11,13,'4','1','2','2023-03-06 12:23:37','2023-03-06 12:23:43'),(12,18,'4','1','2','2023-07-10 05:13:21','2023-07-10 05:13:24'),(13,19,'4','1','2','2023-07-10 05:13:21','2023-07-10 05:13:23');

--
-- Table structure for table `registrations`
--

CREATE TABLE `registrations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `candidate_id` bigint(20) unsigned DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_id` bigint(20) unsigned DEFAULT NULL,
  `course_module_id` bigint(20) unsigned DEFAULT NULL,
  `course_session_id` bigint(20) unsigned DEFAULT NULL,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `current_status` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `send_course_details` smallint(6) DEFAULT '0',
  `send_order` smallint(6) DEFAULT '0',
  `attendance_status` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `attended_at` datetime DEFAULT NULL,
  `grade_status` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `certified` int(11) NOT NULL DEFAULT '0',
  `certified_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `wait_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `registrations_candidate_id_foreign` (`candidate_id`),
  KEY `registrations_course_id_foreign` (`course_id`),
  KEY `registrations_course_module_id_foreign` (`course_module_id`),
  KEY `registrations_course_session_id_foreign` (`course_session_id`),
  KEY `registrations_order_id_foreign` (`order_id`),
  CONSTRAINT `registrations_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE SET NULL,
  CONSTRAINT `registrations_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `registrations_course_module_id_foreign` FOREIGN KEY (`course_module_id`) REFERENCES `course_modules` (`id`) ON DELETE SET NULL,
  CONSTRAINT `registrations_course_session_id_foreign` FOREIGN KEY (`course_session_id`) REFERENCES `course_sessions` (`id`) ON DELETE SET NULL,
  CONSTRAINT `registrations_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `registrations`
--

INSERT INTO `registrations` VALUES (1,1,'kabyk95@gmail.com',34,49,1,1,NULL,0,1,'2','2023-01-25 17:30:55','1',0,NULL,'2023-01-23 09:29:10','2023-01-25 14:30:55','ENROLLED'),(2,2,'djsilencer2022@gmail.com',34,49,1,2,NULL,0,1,'2','2023-01-25 17:31:41','1',0,NULL,'2023-01-23 09:45:01','2023-01-25 14:31:41','ENROLLED'),(3,3,'kabycom2021@gmail.com',34,49,1,2,NULL,0,1,'2','2023-01-25 17:31:59','1',0,NULL,'2023-01-23 09:45:02','2023-01-25 14:31:59','ENROLLED'),(4,4,'festusflowin@gmail.com',34,49,2,3,NULL,0,1,'1',NULL,'1',0,NULL,'2023-01-24 11:22:17','2023-01-24 08:28:38','WAITING'),(5,5,'flowinfestus@gmail.com',34,49,2,4,NULL,0,1,'1',NULL,'1',0,NULL,'2023-01-24 12:08:28','2023-01-24 12:08:28','0'),(6,6,'kabyk95@gmail.com',34,53,3,5,NULL,0,1,'2','2023-01-27 07:56:11','1',0,NULL,'2023-01-27 07:47:54','2023-01-27 04:56:11','ENROLLED'),(7,7,'kabycom2021@gmail.com',34,53,3,5,NULL,0,1,'2','2023-01-27 07:56:28','1',0,NULL,'2023-01-27 07:48:11','2023-01-27 04:56:28','ENROLLED'),(8,8,'edwin.kashangaki@ccbrt.org',43,58,4,6,NULL,0,1,'2','2023-02-02 15:26:56','1',0,NULL,'2023-01-27 11:56:11','2023-02-02 12:26:56','ENROLLED'),(9,9,'djsilencer2022@gmail.com',43,58,4,6,NULL,0,1,'2','2023-02-02 15:27:13','1',0,NULL,'2023-01-27 11:56:15','2023-02-02 12:27:13','ENROLLED'),(10,10,'kabyk95@gmail.com',41,51,5,7,NULL,0,1,'1',NULL,'1',0,NULL,'2023-02-02 14:53:15','2023-02-02 12:25:12','ENROLLED'),(11,11,'fxkabydee@gmail.com',41,51,5,7,NULL,0,1,'1',NULL,'1',0,NULL,'2023-02-02 14:53:20','2023-02-02 12:25:12','ENROLLED'),(12,12,'kabycom2021@gmail.com',45,61,17,8,NULL,0,1,'1',NULL,'1',0,NULL,'2023-03-06 15:19:54','2023-03-06 12:23:36','ENROLLED'),(13,13,'kabyk95@gmail.com',45,61,17,8,NULL,0,1,'1',NULL,'1',0,NULL,'2023-03-06 15:20:00','2023-03-06 12:23:37','ENROLLED'),(14,14,'dorianblack255@gmail.com',45,61,17,9,NULL,0,1,'1',NULL,'1',0,NULL,'2023-03-06 15:27:33','2023-03-06 15:27:33','0'),(15,15,'stevens.general.business.supplies@gmail.com',45,61,17,10,NULL,0,1,'1',NULL,'1',0,NULL,'2023-03-06 15:35:16','2023-03-06 15:35:16','0'),(16,16,'djsilencer2022@gmail.com',45,61,17,11,NULL,0,1,'1',NULL,'1',0,NULL,'2023-03-06 15:38:13','2023-03-06 15:38:13','0'),(17,17,'fxkabydee@gmail.com',45,61,14,12,NULL,0,1,'1',NULL,'1',0,NULL,'2023-03-06 15:45:01','2023-03-06 15:45:01','0'),(18,18,'djsilencer2022@gmail.com',45,60,13,13,NULL,0,1,'1',NULL,'1',0,NULL,'2023-07-04 17:19:34','2023-07-10 05:13:21','ENROLLED'),(19,19,'kabydee@gmail.com',45,60,13,13,NULL,0,1,'1',NULL,'1',0,NULL,'2023-07-04 17:19:34','2023-07-10 05:13:21','ENROLLED');

--
-- Table structure for table `rental_bookings`
--

CREATE TABLE `rental_bookings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `bid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `venue_room_id` int(255) NOT NULL,
  `event_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `number_of_attendee` int(11) DEFAULT NULL,
  `number_of_days` int(11) DEFAULT NULL,
  `include_weekend` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `remark` text COLLATE utf8mb4_unicode_ci,
  `payer_type` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payer_box_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payer_city_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payer_country_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rental_bookings`
--

INSERT INTO `rental_bookings` VALUES (1,'BKNG-2022120001',1,'Senior Developer Interview','2022-12-30','2022-12-30',15,1,'on','Drinks','1','Labmoja Technologies','5725','Dar es Salaam','Tanzania, United Republic of','Derick','Kabyemela','0784559922','kabydee@gmail.com','QUOTED','2022-12-06 09:22:34','2022-12-06 09:23:18'),(2,'BKNG-2022120002',5,'Test Event','2022-12-11','2022-12-12',2,1,'on','AC','2',NULL,'11111','Dar Es Salaam','Tanzania, United Republic of','Festus','Mwilenga','0656121885','festusflowin@gmail.com','DECLINED','2022-12-07 06:13:06','2022-12-07 03:15:32'),(3,'BKNG-2022120003',6,'Event Sample','2022-12-13','2022-12-14',2,2,'on','AC','2',NULL,'11111','DSM','Tanzania, United Republic of','Brothers','Brothers','0656121885','flowinfestus@gmail.com','DECLINED','2022-12-07 06:19:54','2022-12-07 03:58:58'),(4,'BKNG-2022120004',4,'Chai Bora Marketing Pitch','2022-12-09','2022-12-09',10,1,'on','Food','2',NULL,'4000','Dar es Salaam','Tanzania, United Republic of','Savius','Edward','0754700700','kabyk95@gmail.com','DECLINED','2022-12-07 07:34:50','2022-12-07 04:35:04'),(5,'BKNG-2022120005',4,'Breech Delivery Training for IHI','2022-12-17','2022-12-17',50,1,'on','Drinks, Food','2',NULL,'5000','Dar es Salaam','Tanzania, United Republic of','Derick','Kaijage','0784590123','deekaby@gmail.com','QUOTED','2022-12-07 08:22:13','2022-12-07 08:22:45'),(6,'BKNG-2022120006',3,'IHI Training','2022-12-10','2022-12-10',10,1,'on','Drinks','1','CCBRT','4000','Dar es Salaam','Tanzania, United Republic of','Peter','Petro','0784900900','academy@ccbrt.org.tz','QUOTED','2022-12-07 09:02:43','2022-12-07 09:14:18'),(7,'BKNG-2022120007',3,'Breech Delivery Training','2022-12-16','2022-12-16',5,1,'on','Drinks','1','Ifakara Health Institute','3000','Arusha','Tanzania, United Republic of','Jackson','Jack','0754900900','academy@ccbrt.org.tz','DECLINED','2022-12-07 09:04:56','2022-12-07 06:05:54'),(8,'BKNG-2022120008',3,'Fistula Training','2022-12-18','2022-12-18',10,1,'on','Drinks','1','CCBRT','2400','Dar es Salaam','Tanzania, United Republic of','Hafsa','Hassan','0784500500','academy@ccbrt.org','DECLINED','2022-12-07 09:08:17','2022-12-07 06:08:31'),(9,'BKNG-2022120009',3,'Infant Delivery Training','2022-12-23','2022-12-23',10,1,'on','Drinks','2',NULL,'5000','Dar es Salaam','Tanzania, United Republic of','Erick','Erickson','0754900900','academy@ccbrt.org','QUOTED','2022-12-07 09:11:46','2022-12-07 09:15:54'),(10,'BKNG-2022120010',2,'Clubfoot Training','2022-12-16','2022-12-16',14,1,'on','Drinks and Food','1','Kai Engineering Consultation Ltd.','5725','Dar es Salaam','Tanzania, United Republic of','Derick','Kaijage','0784400500','kabydee@gmail.com','QUOTED','2022-12-14 12:22:30','2022-12-14 12:42:23'),(11,'BKNG-2022120011',3,'Assisted Breech Delivery Training','2022-12-25','2022-12-25',10,1,'on','Drinks','2',NULL,'9000','Dodoma','Tanzania, United Republic of','Francis','Franco','0739953432','kabyk95@gmail.com','QUOTED','2022-12-14 12:37:53','2022-12-14 12:45:11'),(12,'BKNG-2022120012',2,'Good Samaritan Fundraiser','2022-12-27','2022-12-27',10,1,'on','Drinks, Foods','1','Kaby Incorporations','5725','Dodoma','Tanzania, United Republic of','Derick','Kabyemela','0738069145','kabydee@gmail.com','QUOTED','2022-12-14 12:51:27','2022-12-14 12:52:22'),(13,'BKNG-2022120013',4,'konya event','2023-01-06','2023-01-08',3,3,'on','AC','2',NULL,'777','DSM','Tanzania, United Republic of','Babuu','Company','0687663767','festusflowin@gmail.com','QUOTED','2022-12-14 13:36:45','2022-12-14 14:24:16'),(14,'BKNG-2022120014',5,'Youtube Go Launch 2','2022-12-31','2022-12-31',10,1,'on','Food and Drinks','2',NULL,'4000','Arusha','Tanzania, United Republic of','Derick','Kabyemela','0738069145','kabydee@gmail.com','QUOTED','2022-12-14 14:34:12','2022-12-15 07:27:54'),(15,'BKNG-2022120015',5,'New Year Celebrations','2023-01-01','2023-01-03',5,3,'on','Food, Drinks, Videographer','1','Truebits Technologies PLC','6000','Dodoma','Tanzania, United Republic of','Rick','Rickson','0738069145','kabyk95@gmail.com','QUOTED','2022-12-14 15:55:55','2022-12-15 12:30:23'),(16,'BKNG-2022120016',3,'Avatar 2 Watchalong','2022-12-23','2022-12-23',10,1,'on','Food, Drinks','1','KabyNet Solutions','5000','Dodoma','Tanzania, United Republic of','Francisco','Franco','0738069145','kabyk95@gmail.com','QUOTED','2022-12-15 07:01:42','2022-12-15 07:56:32'),(17,'BKNG-2022120017',7,'test event','2022-12-17','2022-12-20',3,4,'on','AC','2',NULL,'222','Hhhh','Tanzania, United Republic of','Festus','Mwilenga','0687663767','festusflowin@gmail.com','QUOTED','2022-12-15 07:34:49','2022-12-15 07:35:42'),(18,'BKNG-2022120018',6,'test event 2','2023-01-08','2023-01-10',3,3,'on','AC','2',NULL,'11','DSM','Tanzania, United Republic of','Christina','Chalamila','0687663767','festusflowin@gmail.com','QUOTED','2022-12-15 07:40:27','2022-12-15 07:42:16'),(19,'BKNG-2022120019',4,'Food Delivery Mobile App Pitch','2022-12-31','2022-12-31',20,1,'on','Drinks, Food, Projector','1','Kabyinc Solutions','9000','Simiyu','Tanzania, United Republic of','Derick','Kabyemela','0784060152','kabyk95@gmail.com','QUOTED','2022-12-15 08:01:55','2022-12-15 08:12:48'),(20,'BKNG-2022120020',4,'War of the Dragons Watch Along','2022-12-17','2022-12-17',20,1,'on','Drinks, Projector','1','KabyNet Solutions','3000','Arusha','Tanzania, United Republic of','Victoria','Victor','0784559900','kabydee@gmail.com','QUOTED','2022-12-15 08:19:28','2022-12-15 08:21:02'),(21,'BKNG-2022120021',6,'St Laurent Mobile App Launch','2022-12-25','2022-12-25',10,1,'on','Drinks, Food','1','KabyInc Solutions','9000','Dodoma','Tanzania, United Republic of','Derick','Kabyemela','0754805757','kabydee@gmail.com','QUOTED','2022-12-15 13:05:28','2022-12-15 13:06:27'),(22,'BKNG-2022120022',1,'World Cup Final Watchalong','2022-12-17','2022-12-17',20,1,'on','Drinks','1','Azera Beauty','3200','Arusha','Tanzania, United Republic of','Derick','Kaijage','0754800900','kabydee@gmail.com','QUOTED','2022-12-15 13:34:09','2022-12-15 13:35:08'),(23,'BKNG-2022120023',6,'Babuu Ceremony','2022-12-28','2022-12-30',2,3,'on','AC','1','TrueBits','222','DSM','Tanzania, United Republic of','Babuu','Company','0687663767','festusflowin@gmail.com','QUOTED','2022-12-15 13:44:58','2022-12-16 16:03:02'),(24,'BKNG-2022120024',2,'Global Health Summit','2022-12-22','2022-12-22',10,1,'on','Drinks','1','Truebits Technologies PLC','5000','Dodoma','Tanzania, United Republic of','Derick','Kabyemela','0784900800','kabydee@gmail.com','QUOTED','2022-12-15 14:53:18','2022-12-15 14:55:20'),(25,'BKNG-2022120025',2,'Em Power Marketing Event','2022-12-18','2022-12-18',10,1,'on','Drinks, Food','1','Em Pawa Company Ltd','5000','Arusha','Tanzania, United Republic of','Mwanzo','Mwisho','0784339922','kabyk95@gmail.com','QUOTED','2022-12-16 09:58:29','2022-12-19 10:12:11'),(26,'BKNG-2022120026',5,'Web Developer Oral Interview','2022-12-23','2022-12-23',5,1,'on','Food, Drinks','2',NULL,'1000','Dar es Salaam','Tanzania, United Republic of','Derick','Kabyemela','0784339933','kabydee@gmail.com','DECLINED','2022-12-19 10:09:14','2022-12-19 07:10:39'),(27,'BKNG-2022120027',3,'TMS Website Presentation','2022-12-24','2022-12-24',8,1,'on','Drinks, Food','2',NULL,'5000','Dar es Salaam','Tanzania, United Republic of','Derick','Kabyemela','0768568815','kabydee@gmail.com','QUOTED','2022-12-19 10:34:35','2022-12-19 10:35:07'),(28,'BKNG-2022120028',2,'Real Estate Developer Interview','2022-12-23','2022-12-23',10,1,'on','Drinks, Foods','1','Kabynet Communications Ltd.','Derick','Kabyemela','Tanzania, United Republic of','Derick','Kabyemela','0784343122','flowinfestus@gmail.com','QUOTED','2022-12-20 12:20:22','2022-12-20 13:54:02'),(29,'BKNG-2022120029',1,'Booking Management System Interview','2022-12-25','2022-12-25',15,1,'on','Drinks','1','TrueBits','5000','5000','Tanzania, United Republic of','Festus','Flowin','0679343043','flowinfestus@gmail.com','-','2022-12-20 12:22:18','2022-12-20 12:22:18'),(30,'BKNG-2023010001',1,'Senior Developer Interview','2023-01-28','2023-01-29',10,2,'on','Foods, Drinks','2',NULL,'5725','Dar es Salaam','Tanzania, United Republic of','Derick','Kabymela','0754078922','kabydee@gmail.com','QUOTED','2023-01-27 08:04:41','2023-01-27 08:06:02'),(31,'BKNG-2023010002',5,'TMS Testing Meeting','2023-01-30','2023-01-30',10,1,'on','Drinks, Food','1','CCBRT Training Academy','5000','Dar es Salaam','Tanzania, United Republic of','Derick','Kabyemela','0754690134','kabydee@gmail.com','QUOTED','2023-01-27 12:44:14','2023-01-27 12:46:15'),(32,'BKNG-2023010003',3,'Probation Period 2','2023-02-01','2023-02-03',15,3,'on','Drinks, Food','2',NULL,'5725','Arusha','Tanzania, United Republic of','Derick','Kabyemela','0754099871','kabydee@gmail.com','QUOTED','2023-01-30 09:49:45','2023-01-30 09:50:42'),(33,'BKNG-2023020001',1,'CCBRT ACADEMY LAUNCH','2023-02-10','2023-02-14',4,5,'on','Photography and decoration','1','CCBRT','23310','Dar es salaam','Tanzania, United Republic of','Febdays','Minja','0622059625','febdaysminja@gmail.com','-','2023-02-09 12:43:23','2023-02-09 12:43:23'),(34,'BKNG-2023020002',5,'Event Test','2023-02-21','2023-02-23',3,3,'on','AC','2',NULL,'11111','Dar Es Salaam','Tanzania, United Republic of','James','Swai','0656121885','festusflowin@gmail.com','QUOTED','2023-02-13 13:48:05','2023-02-13 13:57:42'),(35,'BKNG-2023020003',5,'Point of Sales Marketing Pitch','2023-03-01','2023-03-02',20,2,'on','Food and Drinks','1','KabyNet Solutions','5000','Tanzania','Tanzania, United Republic of','Derick','Kabyemela','076323212','kabyk95@gmail.com','QUOTED','2023-02-13 13:52:58','2023-02-13 13:54:19'),(36,'BKNG-2023020004',2,'Laptop Sale Event','2023-02-14','2023-02-15',10,2,'on','Drinks','1','KabyNet Communications Ltd','5000','Dodoma','Tanzania, United Republic of','Derick','Kabyemela','0692463122','kabydee@gmail.com','QUOTED','2023-02-13 16:54:44','2023-02-13 16:56:24'),(37,'BKNG-2023020005',1,'sample event','2023-03-03','2023-03-05',3,1,'on','AC','2',NULL,'2222','Dar Es Salaam','Tanzania, United Republic of','James','Sawai','0656121885','festusflowin@gmail.com','QUOTED','2023-02-14 09:03:44','2023-02-14 09:04:57'),(38,'BKNG-2023070001',8,'Academy Candidate Screening','2023-10-04','2023-10-05',23,2,'on','Diskette and Dices','1','Green gan','3245','Dar','Tanzania, United Republic of','Ralmana','Bin Akbir','0767716712','febdays.minja@ccbrt.org','QUOTED','2023-07-26 12:54:49','2023-07-26 12:56:51');

--
-- Table structure for table `rental_quotations`
--

CREATE TABLE `rental_quotations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `bkng_id` bigint(20) unsigned DEFAULT NULL,
  `qtid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quote_date` date DEFAULT NULL,
  `quote_validity` int(11) DEFAULT NULL,
  `control_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtotal` int(11) DEFAULT NULL,
  `total_amount` int(11) DEFAULT NULL,
  `amount_paid` int(11) DEFAULT NULL,
  `due_amount` int(255) NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rental_quotations_qtid_unique` (`qtid`),
  KEY `rental_quotations_bkng_id_foreign` (`bkng_id`),
  CONSTRAINT `rental_quotations_bkng_id_foreign` FOREIGN KEY (`bkng_id`) REFERENCES `rental_bookings` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rental_quotations`
--

INSERT INTO `rental_quotations` VALUES (1,1,'CCBRT/QT-2022120001','2022-12-06',1,NULL,NULL,180000,180000,NULL,180000,'RESERVED','2022-12-06 09:23:18','2022-12-06 09:23:18'),(2,3,'CCBRT/QT-2022120002','2022-12-07',3,NULL,NULL,160000,160000,NULL,160000,'RESERVED','2022-12-07 06:20:19','2022-12-07 06:20:19'),(3,5,'CCBRT/QT-2022120003','2022-12-07',1,NULL,NULL,350000,350000,NULL,350000,'NOT RESERVED','2022-12-07 08:22:45','2022-12-07 05:22:52'),(4,6,'CCBRT/QT-2022120004','2022-12-07',1,NULL,NULL,208000,208000,NULL,208000,'NOT RESERVED','2022-12-07 09:14:18','2022-12-07 06:14:28'),(5,9,'CCBRT/QT-2022120005','2022-12-07',1,'2022175797037463480119',NULL,208000,208000,208000,0,'RESERVED','2022-12-07 09:15:54','2022-12-07 06:33:04'),(6,10,'CCBRT/QT-2022120006','2022-12-14',1,NULL,NULL,348000,348000,NULL,348000,'RESERVED','2022-12-14 12:42:22','2022-12-14 12:42:24'),(7,11,'CCBRT/QT-2022120007','2022-12-14',1,NULL,NULL,558000,558000,NULL,558000,'RESERVED','2022-12-14 12:45:10','2022-12-14 12:45:12'),(8,12,'CCBRT/QT-2022120008','2022-12-14',1,NULL,NULL,408000,408000,NULL,408000,'RESERVED','2022-12-14 12:52:22','2022-12-14 12:52:22'),(9,13,'CCBRT/QT-2022120009','2022-12-14',3,NULL,NULL,1056000,1056000,NULL,1056000,'NOT RESERVED','2022-12-14 14:24:13','2022-12-14 11:25:33'),(10,13,'CCBRT/QT-2022120010','2022-12-14',2,NULL,NULL,200,200,NULL,200,'RESERVED','2022-12-14 15:37:06','2022-12-14 15:37:10'),(11,13,'CCBRT/QT-2022120011','2022-12-14',2,NULL,NULL,400,400,NULL,400,'RESERVED','2022-12-14 15:44:19','2022-12-14 15:44:22'),(12,13,'CCBRT/QT-2022120012','2022-12-14',2,NULL,NULL,600,600,NULL,600,'NOT RESERVED','2022-12-14 16:18:39','2022-12-14 13:19:03'),(13,14,'CCBRT/QT-2022120013','2022-12-15',2,NULL,NULL,53000,53000,NULL,53000,'NOT RESERVED','2022-12-15 07:27:54','2022-12-15 04:28:12'),(14,17,'CCBRT/QT-2022120014','2022-12-15',2,NULL,NULL,4000,4000,NULL,4000,'NOT RESERVED','2022-12-15 07:35:41','2022-12-15 04:36:00'),(15,18,'CCBRT/QT-2022120015','2022-12-15',2,NULL,NULL,60000,60000,NULL,60000,'RESERVED','2022-12-15 07:42:16','2022-12-15 07:42:17'),(16,16,'CCBRT/QT-2022120016','2022-12-15',1,NULL,NULL,208000,208000,NULL,208000,'RESERVED','2022-12-15 07:56:32','2022-12-15 07:56:33'),(17,19,'CCBRT/QT-2022120017','2022-12-15',1,NULL,NULL,450000,450000,NULL,450000,'RESERVED','2022-12-15 08:12:47','2022-12-15 08:12:49'),(18,20,'CCBRT/QT-2022120018','2022-12-15',1,NULL,NULL,470000,470000,NULL,470000,'RESERVED','2022-12-15 08:21:01','2022-12-15 08:21:03'),(19,15,'CCBRT/QT-2022120019','2022-12-15',2,NULL,NULL,120000,120000,NULL,120000,'RESERVED','2022-12-15 12:30:20','2022-12-15 12:30:25'),(20,15,'CCBRT/QT-2022120020','2022-12-15',2,NULL,NULL,120000,120000,NULL,120000,'RESERVED','2022-12-15 12:32:33','2022-12-15 12:32:37'),(21,15,'CCBRT/QT-2022120021','2022-12-15',2,'20229997362081330380541',NULL,120000,120000,NULL,120000,'NOT RESERVED','2022-12-15 12:33:16','2022-12-15 09:50:32'),(22,21,'CCBRT/QT-2022120022','2022-12-15',1,NULL,NULL,280000,280000,NULL,280000,'RESERVED','2022-12-15 13:06:26','2022-12-15 13:06:27'),(23,22,'CCBRT/QT-2022120023','2022-12-15',1,NULL,NULL,210000,210000,NULL,210000,'RESERVED','2022-12-15 13:35:07','2022-12-15 13:35:09'),(24,23,'CCBRT/QT-2022120024','2022-12-15',2,NULL,NULL,260000,260000,NULL,260000,'RESERVED','2022-12-15 13:45:58','2022-12-15 13:46:00'),(25,23,'CCBRT/QT-2022120025','2022-12-15',2,NULL,NULL,242000,242000,NULL,242000,'RESERVED','2022-12-15 14:02:04','2022-12-15 14:02:05'),(26,23,'CCBRT/QT-2022120026','2022-12-15',2,NULL,NULL,242000,242000,NULL,242000,'RESERVED','2022-12-15 14:03:44','2022-12-15 14:03:45'),(27,24,'CCBRT/QT-2022120027','2022-12-15',1,NULL,NULL,208000,208000,NULL,208000,'RESERVED','2022-12-15 14:55:19','2022-12-15 14:55:21'),(28,23,'CCBRT/QT-2022120028','2022-12-16',2,NULL,NULL,240000,240000,NULL,240000,'RESERVED','2022-12-16 11:00:13','2022-12-16 11:00:16'),(29,23,'CCBRT/QT-2022120029','2022-12-16',2,NULL,NULL,240000,240000,NULL,240000,'RESERVED','2022-12-16 11:00:51','2022-12-16 11:00:54'),(30,23,'CCBRT/QT-2022120030','2022-12-16',2,NULL,NULL,242000,242000,NULL,242000,'RESERVED','2022-12-16 11:45:46','2022-12-16 11:45:49'),(31,23,'CCBRT/QT-2022120031','2022-12-16',2,NULL,NULL,246000,246000,NULL,246000,'RESERVED','2022-12-16 14:42:50','2022-12-16 14:42:52'),(32,23,'CCBRT/QT-2022120032','2022-12-16',2,NULL,NULL,240600,240600,NULL,240600,'RESERVED','2022-12-16 14:47:02','2022-12-16 14:47:03'),(33,23,'CCBRT/QT-2022120033','2022-12-16',2,NULL,NULL,240000,240000,NULL,240000,'RESERVED','2022-12-16 15:04:23','2022-12-16 15:04:25'),(34,23,'CCBRT/QT-2022120034','2022-12-16',2,NULL,NULL,280000,280000,NULL,280000,'RESERVED','2022-12-16 16:03:01','2022-12-16 16:03:04'),(35,23,'CCBRT/QT-2022120035','2022-12-16',2,NULL,NULL,240600,240600,NULL,240600,'RESERVED','2022-12-16 16:04:59','2022-12-16 16:05:02'),(36,25,'CCBRT/QT-2022120036','2022-12-19',1,NULL,NULL,218000,218000,NULL,218000,'RESERVED','2022-12-19 10:12:10','2022-12-19 10:12:12'),(37,27,'CCBRT/QT-2022120037','2022-12-19',1,NULL,NULL,223000,223000,NULL,223000,'RESERVED','2022-12-19 10:35:07','2022-12-19 10:35:07'),(38,28,'CCBRT/QT-2022120038','2022-12-20',1,NULL,NULL,250000,250000,NULL,250000,'NOT RESERVED','2022-12-20 13:54:01','2022-12-20 10:55:07'),(39,30,'CCBRT/QT-2023010001','2023-01-27',2,'2022776758199589406941',NULL,2760000,2760000,2760000,0,'RESERVED','2023-01-27 08:06:01','2023-01-27 05:09:52'),(40,31,'CCBRT/QT-2023010002','2023-01-27',2,'20225943971871548932098',NULL,253000,253000,253000,0,'RESERVED','2023-01-27 12:46:14','2023-01-27 09:52:17'),(41,32,'CCBRT/QT-2023010003','2023-01-30',2,'202213332519611000921636',NULL,924000,924000,924000,0,'RESERVED','2023-01-30 09:50:41','2023-01-30 07:07:36'),(42,35,'CCBRT/QT-2023020001','2023-02-13',2,NULL,NULL,236000,236000,NULL,236000,'RESERVED','2023-02-13 13:54:19','2023-02-13 13:54:19'),(43,34,'CCBRT/QT-2023020002','2023-02-13',2,NULL,NULL,159000,159000,NULL,159000,'RESERVED','2023-02-13 13:57:42','2023-02-13 13:57:42'),(44,36,'CCBRT/QT-2023020003','2023-02-13',2,NULL,NULL,636000,636000,NULL,636000,'RESERVED','2023-02-13 16:56:24','2023-02-13 16:56:25'),(45,37,'CCBRT/QT-2023020004','2023-02-14',2,NULL,NULL,189000,189000,NULL,189000,'RESERVED','2023-02-14 09:04:57','2023-02-14 09:04:57'),(46,38,'CCBRT/QT-2023070001','2023-07-26',2,NULL,NULL,1610000,1610000,NULL,1610000,'RESERVED','2023-07-26 12:56:50','2023-07-26 12:56:51');

--
-- Table structure for table `rental_services`
--

CREATE TABLE `rental_services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `venue_id` bigint(20) unsigned DEFAULT NULL,
  `number_of_days` int(11) DEFAULT NULL,
  `start_date_time` timestamp NULL DEFAULT NULL,
  `end_date_time` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rental_services_order_id_foreign` (`order_id`),
  KEY `rental_services_venue_id_foreign` (`venue_id`),
  CONSTRAINT `rental_services_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL,
  CONSTRAINT `rental_services_venue_id_foreign` FOREIGN KEY (`venue_id`) REFERENCES `venue_rooms` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rental_services`
--


--
-- Table structure for table `rental_terms_and_conditions`
--

CREATE TABLE `rental_terms_and_conditions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(10) DEFAULT NULL,
  `terms_and_conditions` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rental_terms_and_conditions`
--

INSERT INTO `rental_terms_and_conditions` VALUES (1,'rental','<p style=\"text-align: center; \"><img src=\"data:image/png;base64,[encoded data, 32168 characters]\" style=\"width: 303px;\" data-filename=\"image.png\"></p><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b>RENTAL TERMS &amp; CONDITIONS<o:p></o:p></b></p><p class=\"MsoNormal\">&nbsp;All our rental items\r\nand services are provided according to the following rental terms and\r\nconditions, to which all customers are required to agree:</p><p class=\"MsoNormal\"><b style=\"font-size: 1rem; text-indent: -0.25in;\">1. Reservation and usage of facility</b></p><p class=\"MsoNormal\">Reservation of the facility shall be on first come first\r\nserve basis. Usage of the facility shall be for the purpose agreed upon\r\nreservation and cannot be used for other purposes. Subleasing shall not be\r\nallowed without prior consent of the administration of the facility.</p><p class=\"MsoNormal\"><b style=\"text-indent: -0.25in; font-size: 1rem;\">2. Booking and payment</b></p><p class=\"MsoNormal\">Rental of facilities and dates is a contractual commitment.\r\nA rental deposit of 50% is required 3 days prior to the event. The remaining\r\n50% balance is due after the event.<o:p></o:p></p><p class=\"MsoListParagraph\" style=\"text-indent:-.25in;mso-list:l0 level1 lfo1\"><b>&nbsp; &nbsp; 3. Cancellation<o:p></o:p></b></p><p class=\"MsoNormal\">Upon cancellation of reservation 7 days before the event due\r\nto fortuitous causes, the 50% down payment shall be refundable. If the\r\ncancellation was due to other reasons, with the reservation 5 days prior to the\r\nscheduled reservation, 20% shall be deducted from the refundable amount. In any\r\ncase, there shall be no refunds to reservations cancelled 3 days prior to the\r\nscheduled reservation date.<o:p></o:p></p><p class=\"MsoListParagraph\" style=\"text-indent:-.25in;mso-list:l0 level1 lfo1\"><b>&nbsp; &nbsp; 4. Reservation Hours<o:p></o:p></b></p><p class=\"MsoNormal\">Setup, vendor drop-offs and usage of the facility must take\r\nplace within the working hours from 08:00am to 16:00pm, Monday to Friday. Extension\r\nof regular working hours will cost 10,000 per hour. Reservations during the\r\nweekend from 08:00am to 16:00pm shall cost an extra amount of 60,000 per day to\r\ncover the coordination &amp; administration fee. Customer agrees to return the\r\nrented goods and room during Rental Company’s regular working hours, upon\r\ntermination of the rental period.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</p><p class=\"MsoNormal\"><b style=\"font-size: 1rem; text-indent: -0.25in;\">5. Handling equipment in the rental facility</b></p><p class=\"MsoNormal\">Customer acknowledges that he or she, or their\r\nrepresentative, had an opportunity to personally inspect the room(s) and\r\nequipment and finds it suitable for his or her needs and in good condition. No\r\ndecorations, temporary fixtures, or any materials or application that may cause\r\nirreversible damage may be affixed to the walls of the facility.<o:p></o:p></p><p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n</p><p class=\"MsoNormal\">Customer agrees to assume the risk of, and hold Rental\r\nCompany harmless for, property damage and personal injuries caused by the\r\nequipment/room, the result of adverse weather conditions, or the result of\r\nnegligence on the part of the Customer and agrees to pay for any damage or loss\r\nof the goods, as an insurer, regardless of cause, except reasonable wear and\r\ntear.<o:p></o:p></p><p style=\"text-align: center; \">                                                \r\n                                            </p>','2022-12-07 08:09:14','2022-12-07 05:11:35');

--
-- Table structure for table `reservations`
--

CREATE TABLE `reservations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `venue_room_id` int(244) NOT NULL,
  `quote_id` bigint(20) unsigned DEFAULT NULL,
  `session_id` bigint(20) unsigned DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reservation_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reservations_quote_id_foreign` (`quote_id`),
  KEY `reservations_session_id_foreign` (`session_id`),
  CONSTRAINT `reservations_quote_id_foreign` FOREIGN KEY (`quote_id`) REFERENCES `rental_quotations` (`id`) ON DELETE SET NULL,
  CONSTRAINT `reservations_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `course_sessions` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reservations`
--

INSERT INTO `reservations` VALUES (58,3,NULL,12,'UPCOMING','INTERNAL','SESSION','2023-02-19','2023-02-20','2023-02-17 05:16:46','2023-02-17 05:16:46'),(59,4,NULL,13,'UPCOMING','INTERNAL','SESSION','2023-03-01','2023-03-01','2023-02-28 07:05:07','2023-02-28 07:05:07'),(60,7,NULL,14,'UPCOMING','INTERNAL','SESSION','2023-03-01','2023-03-01','2023-02-28 07:09:08','2023-02-28 07:09:08'),(61,6,NULL,15,'UPCOMING','INTERNAL','SESSION','2023-03-02','2023-03-02','2023-02-28 07:10:31','2023-02-28 07:10:31'),(62,3,NULL,16,'UPCOMING','INTERNAL','SESSION','2023-03-02','2023-03-02','2023-02-28 07:50:20','2023-02-28 07:50:20'),(63,2,NULL,17,'UPCOMING','INTERNAL','SESSION','2023-03-20','2023-03-21','2023-03-06 10:40:26','2023-03-06 10:40:26'),(64,3,NULL,18,'UPCOMING','INTERNAL','SESSION','2023-07-10','2023-07-11','2023-07-04 14:12:25','2023-07-04 14:12:25'),(65,8,46,NULL,'PENDING PAYMENT','EXTERNAL','EVENT','2023-10-04','2023-10-05','2023-07-26 12:56:51','2023-07-26 12:56:51'),(66,8,NULL,19,'UPCOMING','INTERNAL','SESSION','2023-11-04','2023-11-05','2023-07-26 10:13:29','2023-07-26 10:13:29'),(67,3,NULL,20,'UPCOMING','INTERNAL','SESSION','2023-07-31','2023-07-31','2023-07-31 04:48:17','2023-07-31 04:48:17');

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

CREATE TABLE `resources` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `course_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_module_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `resources` VALUES (1,'Premie Mannequin',NULL,NULL,'Baby Premie - for teaching natal care',NULL,'1',10,'2023-01-19 10:47:40','2023-01-19 10:47:40'),(2,'Adult Female Mannequin',NULL,NULL,'This is an Adult Female Mannequin',NULL,'1',5,'2023-01-19 10:48:31','2023-01-19 10:48:31'),(3,'Film Projector',NULL,NULL,'Film Projector',NULL,'1',1,'2023-01-19 10:48:55','2023-01-19 10:48:55'),(4,'Workstations (Core i7)',NULL,NULL,'These are desktop computer',NULL,'1',10,'2023-02-27 08:15:58','2023-02-27 08:15:58');

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(43,1),(44,1),(45,1),(46,1),(47,1),(48,1),(49,1),(50,1),(51,1),(52,1),(54,1),(55,1),(56,1),(57,1),(58,1),(59,1),(60,1),(53,2),(9,3),(10,3),(11,3),(12,3),(13,3),(17,3),(18,3),(19,3),(20,3),(21,3),(22,3),(23,3),(24,3),(33,3),(34,3),(35,3),(36,3),(37,3),(38,3),(39,3),(40,3),(41,3),(55,3);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Admin','web','2022-08-15 08:27:10','2022-08-15 08:27:10'),(2,'Candidate Portal','web','2022-08-16 05:29:51','2022-08-16 05:29:51'),(3,'Instructor Portal','web','2022-09-03 07:29:54','2022-09-03 07:29:54');

--
-- Table structure for table `scholarship_criterias`
--

CREATE TABLE `scholarship_criterias` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `scholarship_id` int(11) NOT NULL,
  `bird_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bird_value` int(11) DEFAULT NULL,
  `acreditor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `candidates_on_order` int(11) DEFAULT NULL,
  `payer_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `candidates_on_session` int(11) DEFAULT NULL,
  `module_id` int(11) DEFAULT NULL,
  `module_session_id` int(11) DEFAULT NULL,
  `organisation` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_of_disability` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `scholarship_criterias`
--

INSERT INTO `scholarship_criterias` VALUES (1,1,'early',NULL,NULL,2,NULL,20,NULL,NULL,'external','F',NULL,'2023-01-19 11:07:38','2023-03-06 12:41:35'),(2,2,NULL,NULL,NULL,1,NULL,10,61,17,'external','M','Mental health condition','2023-03-06 12:02:19','2023-03-06 12:33:48');

--
-- Table structure for table `scholarships`
--

CREATE TABLE `scholarships` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scholarship_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `calc_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `calc_value` int(11) DEFAULT NULL,
  `price_currency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mode_of_applying` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `limit_usage` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `priority` int(11) DEFAULT NULL,
  `combine` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `publish_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `scholarships`
--

INSERT INTO `scholarships` VALUES (1,'Test Scholarship One','This is a description for test scholarship one','both','percentage',10,'TZS','auto',NULL,2,0,'2023-01-19 11:07:38','2023-03-06 12:39:40',1),(2,'Child Protection Training Scholarship P1','This is test scholarship with priority one','individual','percentage',5,'TZS','auto',NULL,5,0,'2023-03-06 12:02:19','2023-03-06 12:02:19',1);

--
-- Table structure for table `session_presenters`
--

CREATE TABLE `session_presenters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `course_session_id` bigint(20) unsigned DEFAULT NULL,
  `course_presenter_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `session_presenters_course_session_id_foreign` (`course_session_id`),
  KEY `session_presenters_course_presenter_id_foreign` (`course_presenter_id`),
  CONSTRAINT `session_presenters_course_presenter_id_foreign` FOREIGN KEY (`course_presenter_id`) REFERENCES `course_presenters` (`id`) ON DELETE CASCADE,
  CONSTRAINT `session_presenters_course_session_id_foreign` FOREIGN KEY (`course_session_id`) REFERENCES `course_sessions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `session_presenters`
--

INSERT INTO `session_presenters` VALUES (2,1,2,'2023-01-23 07:42:09','2023-01-23 07:42:09'),(3,2,3,'2023-01-24 07:08:56','2023-01-24 07:08:56'),(4,3,5,'2023-01-27 04:42:12','2023-01-27 04:42:12'),(5,4,3,'2023-01-27 08:30:17','2023-01-27 08:30:17'),(6,4,4,'2023-01-27 08:30:17','2023-01-27 08:30:17'),(7,5,3,'2023-02-02 11:44:46','2023-02-02 11:44:46'),(8,6,4,'2023-02-07 05:27:41','2023-02-07 05:27:41'),(9,7,6,'2023-02-07 05:28:43','2023-02-07 05:28:43'),(11,9,7,'2023-02-07 05:34:05','2023-02-07 05:34:05'),(12,10,6,'2023-02-07 05:34:50','2023-02-07 05:34:50'),(13,11,5,'2023-02-07 05:37:20','2023-02-07 05:37:20'),(14,8,8,'2023-02-08 05:39:50','2023-02-08 05:39:50'),(15,12,3,'2023-02-17 05:16:46','2023-02-17 05:16:46'),(20,15,4,'2023-02-28 07:10:31','2023-02-28 07:10:31'),(21,16,9,'2023-02-28 07:50:20','2023-02-28 07:50:20'),(28,14,8,'2023-03-06 09:50:48','2023-03-06 09:50:48'),(29,14,10,'2023-03-06 09:50:49','2023-03-06 09:50:49'),(30,17,5,'2023-03-06 10:40:27','2023-03-06 10:40:27'),(31,18,2,'2023-07-04 14:12:25','2023-07-04 14:12:25'),(32,13,4,'2023-07-04 14:12:46','2023-07-04 14:12:46'),(33,13,5,'2023-07-04 14:12:46','2023-07-04 14:12:46'),(36,19,2,'2023-07-26 10:16:38','2023-07-26 10:16:38'),(37,20,4,'2023-07-31 04:48:17','2023-07-31 04:48:17');

--
-- Table structure for table `session_resources`
--

CREATE TABLE `session_resources` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `course_session_id` bigint(20) unsigned DEFAULT NULL,
  `resource_id` bigint(20) unsigned DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `start_date_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_date_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `session_resources_course_session_id_foreign` (`course_session_id`),
  KEY `session_resources_resource_id_foreign` (`resource_id`),
  CONSTRAINT `session_resources_course_session_id_foreign` FOREIGN KEY (`course_session_id`) REFERENCES `course_sessions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `session_resources_resource_id_foreign` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `session_resources`
--

INSERT INTO `session_resources` VALUES (1,1,3,1,'2023-01-30 10:00:00','2023-01-31 16:00:00','2023-01-19 10:50:07','2023-01-19 10:50:07'),(2,4,2,2,'2023-01-27 14:00:00','2023-01-27 14:30:00','2023-01-27 09:24:28','2023-01-27 09:24:28'),(3,13,4,5,'2023-03-01 13:00:00','2023-03-01 20:00:00','2023-02-28 08:27:36','2023-02-28 08:27:36');

--
-- Table structure for table `system_settings`
--

CREATE TABLE `system_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `property_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `property_value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `system_settings`
--

INSERT INTO `system_settings` VALUES (1,'system.string.tibapay.apiUrl','http://127.0.0.1:1230/api','Tibapay - API URL','2022-08-15 08:27:09','2022-08-15 08:27:09'),(2,'system.string.tibapay.urlAuthToken','http://127.0.0.1:1230/auth/token','Tibapay - URL AUTH TOKEN','2022-08-15 08:27:09','2022-08-15 08:27:09'),(3,'system.string.tibapay.endpointGenerateControlNumber','/payment/generateControlNumber','Tibapay - ENDPOINT GENERATE CONTROL NUMBER','2022-08-15 08:27:09','2022-08-15 08:27:09'),(4,'system.string.tibapay.endpointListPendingPaymentPaidControlNumber','/payment/listPendingPaymentPaidControlNumber','Tibapay - ENDPOINT LIST PENDING PAID CONTROL NUMBER','2022-08-15 08:27:09','2022-08-15 08:27:09'),(5,'system.string.tibapay.apiUsername','mawasiliano@truebitstech.com','Tibapay - API USERNAME','2022-08-15 08:27:09','2022-08-15 08:27:09'),(6,'system.password.tibapay.apiPassword','password@123','Tibapay - API PASSWORD','2022-08-15 08:27:09','2022-08-15 08:27:09'),(7,'system.password.tibapay.companyUid','0001','Tibapay - COMPANY UID','2022-08-15 08:27:09','2022-08-15 08:27:09'),(8,'system.string.tibapay.endpointUpdatePaid','/payment/updatePaid','Tibapay - ENDPOINT UPDATE PAID','2022-08-15 08:27:09','2022-08-15 08:27:09'),(9,'system.string.documentLibrary.rootPath','D:\\app\\data','Document Library - ROOT PATH','2022-08-15 08:27:09','2022-08-15 08:27:09'),(10,'system.integer.documentLibrary.uploadLimit','2','Document Library - FILE LIMIT SIZE (in MB)','2022-08-15 08:27:09','2022-08-15 08:27:09');

--
-- Table structure for table `terms_conditions`
--

CREATE TABLE `terms_conditions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `terms_conditions` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `terms_conditions`
--

INSERT INTO `terms_conditions` VALUES (1,'<p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;tab-stops:96.75pt\"><b><span lang=\"EN-US\" style=\"font-size:14.0pt;\r\nline-height:107%\">Terms and Conditions for CCBRT Academy Trainings<o:p></o:p></span></b></p>\r\n\r\n<p class=\"MsoListParagraph\" style=\"text-align:justify;text-indent:-.25in;\r\nmso-list:l0 level1 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><b><span lang=\"EN-US\">1.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></b><!--[endif]--><b><span lang=\"EN-US\">General Contract Terms<o:p></o:p></span></b></p>\r\n\r\n<p class=\"MsoNormal\" style=\"text-align:justify;tab-stops:96.75pt\"><span lang=\"EN-US\">These terms and conditions apply to all training programs delivered\r\nby the CCBRT Academy. <o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpFirst\" style=\"margin-left:.75in;mso-add-space:auto;\r\ntext-align:justify;text-indent:-.25in;mso-list:l1 level2 lfo1;tab-stops:96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">1.1<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;\r\n</span></span><!--[endif]--><span lang=\"EN-US\">These terms apply to all\r\nvisitors, users and others who access and engage in the training services\r\nprovided by the CCBRT Academy. <o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:.75in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l1 level2 lfo1;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">1.2<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">Your access to and participation in the training services is\r\nconditioned to your acceptance of these Terms. &nbsp;<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:.75in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l1 level2 lfo1;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">1.3<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">By accessing and participating in the training services you are\r\nbound by these terms.&nbsp; If you disagree\r\nwith any part of the terms you may not access the training services. Please\r\nread these terms and conditions carefully before registering for any of the\r\nCCBRT Academy Training.</span><span style=\"font-size: 1rem;\">&nbsp;</span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"text-align:justify;text-indent:-.25in;\r\nmso-list:l0 level1 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><b><span lang=\"EN-US\">2.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></b><!--[endif]--><b><span lang=\"EN-US\">Pre-Training Terms and\r\nConditions<o:p></o:p></span></b></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:1.0in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">a.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">Participants must register in advance to take part in CCBRT Academy\r\ntrainings. Registration consists of filling out the online form provided on the\r\nCCBRT Academy Website. Registration also includes selecting the training\r\nsession the participant intends to attend. The Training Course Catalog on the Website\r\nprovides a list of training services offered by the Academy.<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:1.0in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">b.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">The CCBRT Academy will generate a billing invoice for the selected\r\nservices/training through its Website and submit it to the participant through\r\nemail and or through the option of downloading and printing.<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:1.0in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">c.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">The participant will only be enrolled for training upon the\r\nsuccessful payment of the selected service/training.<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:1.0in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">d.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">Cancellation of orders cannot be done one day before the training\r\nand registrants who do not attend on the day of the training will be considered\r\n\'no shows\' and will be charged the full course registration fee.<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"text-align:justify;text-indent:-.25in;\r\nmso-list:l0 level1 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><b><span lang=\"EN-US\">3.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></b><!--[endif]--><b><span lang=\"EN-US\">Terms and Condition during\r\nTraining<o:p></o:p></span></b></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:1.0in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">a.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">All participants should attend and participate in the training as\r\nstipulated <o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:1.0in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">b.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">All participants should confirm their particular sign the attendance\r\nregister<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpLast\" style=\"text-align:justify;text-indent:-.25in;\r\nmso-list:l0 level1 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><b><span lang=\"EN-US\">4.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></b><!--[endif]--><b><span lang=\"EN-US\">Certification<o:p></o:p></span></b></p>\r\n\r\n<p class=\"MsoNormal\" style=\"margin-left:.5in;text-align:justify;tab-stops:96.75pt\"><span lang=\"EN-US\">Participant who meet all the criteria below will be eligible for a\r\ncertificate:<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpFirst\" style=\"margin-left:1.0in;mso-add-space:auto;\r\ntext-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">a.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n</span></span><!--[endif]--><span lang=\"EN-US\">Only participants who are\r\npresent for the full duration (stated hours &amp; date/s) of the training will\r\nqualify for the certificate<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpLast\" style=\"margin-left:1.0in;mso-add-space:auto;\r\ntext-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">b.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n</span></span><!--[endif]--><span lang=\"EN-US\">Only participants who sign the\r\nattendance register for all the planned days/ time/duration of the training.</span><span style=\"font-size: 1rem;\">&nbsp;</span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"text-align:justify;text-indent:-.25in;\r\nmso-list:l0 level1 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><b><span lang=\"EN-US\">5.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></b><!--[endif]--><b><span lang=\"EN-US\">Terms of payment<o:p></o:p></span></b></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:1.0in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">a.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">Training fees can be paid using a control number generated on the\r\nAcademy website during registration and proof of payment uploaded on the same\r\nsystem 48 hours before the training commences. Payment can also be made using\r\nthe bank details provided on</span><span style=\"font-size: 1rem;\">&nbsp;</span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"text-align:justify;text-indent:-.25in;\r\nmso-list:l0 level1 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><b><span lang=\"EN-US\">6.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp; &nbsp;&nbsp;</span></span></b><!--[endif]--><b><span lang=\"EN-US\">Cancellation and compensation\r\n<o:p></o:p></span></b></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:1.0in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">a.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">The Academy will provide cancellation notification not less than 24\r\nhours before the start of the training.<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:1.0in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">b.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">Trainee/s that you wish to cancel a training registration should in\r\nwriting (by email or post) submit a cancellation notification not less than 28\r\ndays before the start date of a course, you will be entitled to a 50% refund. <o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin-left:1.0in;mso-add-space:\r\nauto;text-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:\r\n96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">c.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"EN-US\">Trainees that make cancellations for any reason in less than 28 days\r\nbefore the start date of a course will receive no refund but may transfer the\r\nfee or substitute the training for another. &nbsp;<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpLast\" style=\"margin-left:1.0in;mso-add-space:auto;\r\ntext-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">d.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n</span></span><!--[endif]--><span lang=\"EN-US\">Trainees who fail to attend the\r\ncourse there are registered for without giving prior notice to the CCBRT\r\nAcademy, we are unable to refund the course fees or offer a transfer.</span><b style=\"font-size: 1rem;\"><span lang=\"EN-US\">&nbsp;</span></b></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"text-align:justify;text-indent:-.25in;\r\nmso-list:l0 level1 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><b><span lang=\"EN-US\">7.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></b><!--[endif]--><b><span lang=\"EN-US\">Rights to training\r\ndocuments, software<o:p></o:p></span></b></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"text-align:justify;tab-stops:96.75pt\"><span lang=\"EN-US\">All Training Material and all intellectual property rights in all\r\nTraining Material (including the design, graphics and text of all printed\r\nmaterials) is owned by CCBRT Academy. All trainees who have access to the\r\nvarious training material, are granted a non-exclusive, non-transferable,\r\nrevocable license to use the Training Material. None of the CCBRT Academy\r\nTraining Material may be copied, reproduced, uploaded, posted, displayed or\r\nlinked to in any way, in whole or in part, without obtaining permission from\r\nthe organization.</span></p>\r\n\r\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"text-align:justify;text-indent:-.25in;\r\nmso-list:l0 level1 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><b><span lang=\"EN-US\">8.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></b><!--[endif]--><b><span lang=\"EN-US\">Trainee Obligation<o:p></o:p></span></b></p>\r\n\r\n<p class=\"MsoListParagraphCxSpLast\" style=\"margin-left:1.0in;mso-add-space:auto;\r\ntext-align:justify;text-indent:-.25in;mso-list:l0 level2 lfo2;tab-stops:96.75pt\"><!--[if !supportLists]--><span lang=\"EN-US\">a.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n</span></span><!--[endif]--><span lang=\"EN-US\">You may not give access to your\r\nservice portal (log-in details) to a third party.<o:p></o:p></span></p>\r\n\r\n<span lang=\"EN-US\" style=\"font-size:11.0pt;line-height:107%;font-family:&quot;Calibri&quot;,sans-serif;\r\nmso-ascii-theme-font:minor-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:\r\nminor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:&quot;Times New Roman&quot;;\r\nmso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:\r\nEN-US;mso-bidi-language:AR-SA\">You are obliged to comply with all health and\r\nsafety rules and regulations and any other reasonable security requirements\r\nthat apply to the&nbsp;</span>','2022-08-31 12:56:07','2022-08-28 16:43:08');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `is_banned` int(11) NOT NULL DEFAULT '1',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (3,'Jeremiah Ngemera','mawasiliano@truebitstech.com','0657878299','1',1,NULL,'$2y$10$2Js2eOllzDf3hpllyuVqqeJKOWluEB2kF5PFekFvZzMr4a87MJyES',NULL,NULL,NULL),(4,'Regina Monyemangene','admin@admin.com','921212233456','1',1,NULL,'$2y$10$D/Yly.tQyaTF3UyTujpD/.Y66u5dvxPmuA9tNJIBWDFYPge3tEcNm','wofnSBidPJBXfSKNjouUc4EwdDyBBPg2lD0UZzihr6nmu1PUSuVzzTIO0PZ8','2022-08-15 08:27:10','2022-08-15 08:27:10'),(25,'Edwin Kashangaki','edwin.kashangaki@ccbrt.org','+255 718 069 395','1',1,NULL,'$2y$10$66o1QIQjnXdf8uZmgwSJvO0Pzd2tk2NGnswVzc0dPHZEvWawtaajq',NULL,'2022-09-05 05:13:02','2022-09-05 05:13:02'),(27,'Derick Kabyemela','kabyk95@gmail.com','+255738069145','0',1,NULL,'$2y$10$G8sX.uy7xsy3ofJ.ZQ4LeOZZ1/gW31G/7zIJjY3owZ0ShFbKkoAT6',NULL,'2023-01-23 06:32:49','2023-01-23 06:32:49'),(28,'Kaby Com','kabycom2021@gmail.com','0718527660','0',1,NULL,'$2y$10$yJe5g21JJfHXcjQP76RnNO1lSn8kFNvUdV.J2Q/l4PMKW07sA5UHq',NULL,'2023-01-23 06:49:48','2023-01-23 06:49:48'),(29,'DJ Silencer','djsilencer2022@gmail.com','0692463122','0',1,NULL,'$2y$10$NIYkXHjyWvykDTzhAo80T.eOPs8GJnrhOQHxXmOoTpfrHBxxVY6Je','t8JtZ7HDVJ1xjd7PvKEegrH3NCtSox8PKOa49VqR7xRlvDsfoNma0dddFQPt','2023-01-23 06:49:53','2023-07-04 13:50:33'),(30,'FX Kaby','fxkabydee@gmail.com','0783102192','0',1,NULL,'$2y$10$jQs7xDJj932CL6hF6elXgePLmI2zjMt/wJR8PEO3NDu3AZ573FDVq',NULL,'2023-02-02 12:25:14','2023-02-02 12:25:14'),(31,'Kaby Dee','kabydee@gmail.com','0754805757','0',1,NULL,'$2y$10$c0pzUhx047SjWH4iA/lE6.pR.8EDdG.RSI95.btmRxwqPcqTYWnCu',NULL,'2023-07-10 05:13:21','2023-07-10 05:13:21');

--
-- Table structure for table `venue_rooms`
--

CREATE TABLE `venue_rooms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `venue_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `room_capacity` int(11) NOT NULL DEFAULT '0',
  `price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price_currency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `venue_rooms_venue_id_foreign` (`venue_id`),
  CONSTRAINT `venue_rooms_venue_id_foreign` FOREIGN KEY (`venue_id`) REFERENCES `venues` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `venue_rooms`
--

INSERT INTO `venue_rooms` VALUES (1,1,'Twiga','Twiga',20,'180000','TZS','2021-09-23 18:00:00',NULL),(2,1,'Computer Lab -Kipepeo','Computer Lab -Kipepeo',15,'208000','TZS','2021-09-23 18:00:00',NULL),(3,1,'Kanga','Kanga',20,'208000','TZS','2021-09-23 18:00:00',NULL),(4,1,'Kiboko','Kiboko',50,'350000','TZS','2021-09-23 18:00:00',NULL),(5,2,'Popo','Popo',6,'53000','TZS','2021-09-23 18:00:00',NULL),(6,2,'Pundamilia','Pundamilia',10,'80000','TZS','2021-09-23 18:00:00',NULL),(7,2,'Swala','Swala',20,'150000','TZS','2021-09-23 18:00:00',NULL),(8,2,'Tembo','Tembo',40,'260000','TZS','2021-09-23 18:00:00',NULL),(9,NULL,'Puma','Puma Room Amenities',42,NULL,NULL,'2023-02-27 06:53:46','2023-02-27 06:53:46'),(10,4,'Ruaha','65 Inch TV',10,'180000',NULL,'2023-07-26 07:50:33','2023-07-26 07:50:33');

--
-- Table structure for table `venues`
--

CREATE TABLE `venues` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `venues`
--

INSERT INTO `venues` VALUES (1,'Maternal Health Wing','Maternal Health Wing','2021-09-23 18:00:00',NULL),(2,'Standard Building','Standard Building','2021-09-23 18:00:00',NULL),(3,'Paediatric Wing','The Paediatric wing is located in the Northeast side of CCBRT','2023-02-27 06:02:20','2023-02-27 06:02:20'),(4,'Private Clinic','Private Clinic','2023-07-26 07:49:50','2023-07-26 07:49:50');


