--
-- Host: localhost    Database: conference
-- ------------------------------------------------------


--
-- Table structure for table `confirms`
--

CREATE TABLE `confirms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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 `confirms`
--


--
-- Table structure for table `countries`
--

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

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

INSERT INTO `countries` VALUES (1,'Angola','AO','+244',NULL,NULL),(2,'Benin','BJ','+229',NULL,NULL),(3,'Botswana','BW','+267',NULL,NULL),(4,'Burkina Faso','BF','+226',NULL,NULL),(5,'Burundi','BI','+257',NULL,NULL),(6,'Cameroon','CM','+237',NULL,NULL),(7,'Cape Verde','CV','+238',NULL,NULL),(8,'Central African Republic','CF','+236',NULL,NULL),(9,'Chad','TD','+235',NULL,NULL),(10,'Comoros','KM','+269',NULL,NULL),(11,'Congo (Brazzaville)','CG','+242',NULL,NULL),(12,'Congo (Kinshasa)','CD','+243',NULL,NULL),(13,'Djibouti','DJ','+253',NULL,NULL),(14,'Equatorial Guinea','GQ','+240',NULL,NULL),(15,'Eritrea','ER','+291',NULL,NULL),(16,'Eswatini','SZ','+268',NULL,NULL),(17,'Ethiopia','ET','+251',NULL,NULL),(18,'Gabon','GA','+241',NULL,NULL),(19,'Gambia','GM','+220',NULL,NULL),(20,'Ghana','GH','+233',NULL,NULL),(21,'Guinea','GN','+224',NULL,NULL),(22,'Guinea-Bissau','GW','+245',NULL,NULL),(23,'Ivory Coast','CI','+225',NULL,NULL),(24,'Kenya','KE','+254',NULL,NULL),(25,'Lesotho','LS','+266',NULL,NULL),(26,'Liberia','LR','+231',NULL,NULL),(27,'Madagascar','MG','+261',NULL,NULL),(28,'Malawi','MW','+265',NULL,NULL),(29,'Mali','ML','+223',NULL,NULL),(30,'Mauritania','MR','+222',NULL,NULL),(31,'Mauritius','MU','+230',NULL,NULL),(32,'Mozambique','MZ','+258',NULL,NULL),(33,'Namibia','NA','+264',NULL,NULL),(34,'Niger','NE','+227',NULL,NULL),(35,'Nigeria','NG','+234',NULL,NULL),(36,'Rwanda','RW','+250',NULL,NULL),(37,'Sao Tome and Principe','ST','+239',NULL,NULL),(38,'Senegal','SN','+221',NULL,NULL),(39,'Seychelles','SC','+248',NULL,NULL),(40,'Sierra Leone','SL','+232',NULL,NULL),(41,'Somalia','SO','+252',NULL,NULL),(42,'South Africa','ZA','+27',NULL,NULL),(43,'South Sudan','SS','+211',NULL,NULL),(44,'Sudan','SD','+249',NULL,NULL),(45,'Tanzania','TZ','+255',NULL,NULL),(46,'Togo','TG','+228',NULL,NULL),(47,'Uganda','UG','+256',NULL,NULL),(48,'Zambia','ZM','+260',NULL,NULL),(49,'Zimbabwe','ZW','+263',NULL,NULL),(50,'Algeria','DZA','213','2024-11-07 03:52:50','2024-11-07 03:52:50'),(51,'Egypt','EGY','+20','2024-11-07 04:05:14','2024-11-07 04:05:14'),(52,'Morocco','MAR','+212','2024-11-07 04:07:00','2024-11-07 04:07:00'),(53,'Lybia','LY','+218','2024-11-07 04:07:52','2024-11-07 04:07:52'),(54,'Tunisia','TUN','+216','2024-11-07 04:08:45','2024-11-07 04:08:45'),(55,'Saudi Arabia','SAU','+966','2024-11-07 04:13:26','2024-11-07 04:13:26'),(56,'Yemen','YE','+967','2024-11-07 04:16:05','2024-11-07 04:16:05'),(57,'Oman.','OMN','+968','2024-11-07 04:17:09','2024-11-07 04:24:23');

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext 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 `fetp_statuses`
--

CREATE TABLE `fetp_statuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(255) 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 `fetp_statuses`
--

INSERT INTO `fetp_statuses` VALUES (1,'Alumni','2024-11-04 03:58:52','2024-11-04 03:58:52'),(2,'Resident','2024-11-04 04:00:23','2024-11-04 04:00:23'),(3,'N/A','2024-11-05 06:30:22','2024-11-05 06:30:22');

--
-- Table structure for table `fetp_tiers`
--

CREATE TABLE `fetp_tiers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tier` varchar(255) NOT 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 `fetp_tiers`
--

INSERT INTO `fetp_tiers` VALUES (1,'Frontline FETP','2024-11-04 03:57:53','2024-11-04 03:57:53'),(2,'Intermediate FETP','2024-11-04 03:58:05','2024-11-04 03:58:05'),(3,'Advanced FETP','2024-11-04 03:58:14','2024-11-04 03:58:14'),(4,'N/A','2024-11-05 06:30:12','2024-11-05 06:30:12');

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` VALUES (10,'default','{\"uuid\":\"0ea88a82-83df-414a-9341-e70a9c352224\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:4;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:2:{i:0;a:21:{s:4:\\\"name\\\";s:12:\\\"markAsUnread\\\";s:5:\\\"color\\\";N;s:5:\\\"event\\\";N;s:9:\\\"eventData\\\";a:0:{}s:17:\\\"dispatchDirection\\\";b:0;s:19:\\\"dispatchToComponent\\\";N;s:15:\\\"extraAttributes\\\";a:0:{}s:4:\\\"icon\\\";N;s:12:\\\"iconPosition\\\";E:42:\\\"Filament\\\\Support\\\\Enums\\\\IconPosition:Before\\\";s:8:\\\"iconSize\\\";N;s:10:\\\"isOutlined\\\";b:0;s:10:\\\"isDisabled\\\";b:0;s:5:\\\"label\\\";s:14:\\\"Mark as unread\\\";s:11:\\\"shouldClose\\\";b:0;s:16:\\\"shouldMarkAsRead\\\";b:0;s:18:\\\"shouldMarkAsUnread\\\";b:1;s:21:\\\"shouldOpenUrlInNewTab\\\";b:0;s:4:\\\"size\\\";E:39:\\\"Filament\\\\Support\\\\Enums\\\\ActionSize:Small\\\";s:7:\\\"tooltip\\\";N;s:3:\\\"url\\\";N;s:4:\\\"view\\\";s:31:\\\"filament-actions::button-action\\\";}i:1;a:21:{s:4:\\\"name\\\";s:10:\\\"markAsRead\\\";s:5:\\\"color\\\";N;s:5:\\\"event\\\";N;s:9:\\\"eventData\\\";a:0:{}s:17:\\\"dispatchDirection\\\";b:0;s:19:\\\"dispatchToComponent\\\";N;s:15:\\\"extraAttributes\\\";a:0:{}s:4:\\\"icon\\\";N;s:12:\\\"iconPosition\\\";r:21;s:8:\\\"iconSize\\\";N;s:10:\\\"isOutlined\\\";b:0;s:10:\\\"isDisabled\\\";b:0;s:5:\\\"label\\\";s:12:\\\"Mark as read\\\";s:11:\\\"shouldClose\\\";b:0;s:16:\\\"shouldMarkAsRead\\\";b:1;s:18:\\\"shouldMarkAsUnread\\\";b:0;s:21:\\\"shouldOpenUrlInNewTab\\\";b:0;s:4:\\\"size\\\";r:30;s:7:\\\"tooltip\\\";N;s:3:\\\"url\\\";N;s:4:\\\"view\\\";s:31:\\\"filament-actions::button-action\\\";}}s:4:\\\"body\\\";s:346:\\\"Please note: An Abstract with the following details has been created: \\n                    Name:<p>&nbsp;| Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>, Track:One Health and Climate Change, Auther:Michael Nkanika on 2024-11-08 06:48:09.\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:35:\\\"heroicon-o-clipboard-document-check\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";s:7:\\\"success\\\";s:5:\\\"title\\\";s:203:\\\"An Abstract titled \'<p>&nbsp;| Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>\' has been created\\\";s:4:\\\"view\\\";s:36:\\\"filament-notifications::notification\\\";s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"6e5e8f5a-9da8-4e23-af83-dbb6eae2d4e4\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}',0,NULL,1731048489,1731048489),(11,'default','{\"uuid\":\"b04cdcea-dd29-4007-91b0-f61fe56e8ce5\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:7;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:2:{i:0;a:21:{s:4:\\\"name\\\";s:12:\\\"markAsUnread\\\";s:5:\\\"color\\\";N;s:5:\\\"event\\\";N;s:9:\\\"eventData\\\";a:0:{}s:17:\\\"dispatchDirection\\\";b:0;s:19:\\\"dispatchToComponent\\\";N;s:15:\\\"extraAttributes\\\";a:0:{}s:4:\\\"icon\\\";N;s:12:\\\"iconPosition\\\";E:42:\\\"Filament\\\\Support\\\\Enums\\\\IconPosition:Before\\\";s:8:\\\"iconSize\\\";N;s:10:\\\"isOutlined\\\";b:0;s:10:\\\"isDisabled\\\";b:0;s:5:\\\"label\\\";s:14:\\\"Mark as unread\\\";s:11:\\\"shouldClose\\\";b:0;s:16:\\\"shouldMarkAsRead\\\";b:0;s:18:\\\"shouldMarkAsUnread\\\";b:1;s:21:\\\"shouldOpenUrlInNewTab\\\";b:0;s:4:\\\"size\\\";E:39:\\\"Filament\\\\Support\\\\Enums\\\\ActionSize:Small\\\";s:7:\\\"tooltip\\\";N;s:3:\\\"url\\\";N;s:4:\\\"view\\\";s:31:\\\"filament-actions::button-action\\\";}i:1;a:21:{s:4:\\\"name\\\";s:10:\\\"markAsRead\\\";s:5:\\\"color\\\";N;s:5:\\\"event\\\";N;s:9:\\\"eventData\\\";a:0:{}s:17:\\\"dispatchDirection\\\";b:0;s:19:\\\"dispatchToComponent\\\";N;s:15:\\\"extraAttributes\\\";a:0:{}s:4:\\\"icon\\\";N;s:12:\\\"iconPosition\\\";r:21;s:8:\\\"iconSize\\\";N;s:10:\\\"isOutlined\\\";b:0;s:10:\\\"isDisabled\\\";b:0;s:5:\\\"label\\\";s:12:\\\"Mark as read\\\";s:11:\\\"shouldClose\\\";b:0;s:16:\\\"shouldMarkAsRead\\\";b:1;s:18:\\\"shouldMarkAsUnread\\\";b:0;s:21:\\\"shouldOpenUrlInNewTab\\\";b:0;s:4:\\\"size\\\";r:30;s:7:\\\"tooltip\\\";N;s:3:\\\"url\\\";N;s:4:\\\"view\\\";s:31:\\\"filament-actions::button-action\\\";}}s:4:\\\"body\\\";s:346:\\\"Please note: An Abstract with the following details has been created: \\n                    Name:<p>&nbsp;| Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>, Track:One Health and Climate Change, Auther:Michael Nkanika on 2024-11-08 06:48:09.\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:35:\\\"heroicon-o-clipboard-document-check\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";s:7:\\\"success\\\";s:5:\\\"title\\\";s:203:\\\"An Abstract titled \'<p>&nbsp;| Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>\' has been created\\\";s:4:\\\"view\\\";s:36:\\\"filament-notifications::notification\\\";s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"05c1250b-3327-41c8-9b16-c1f33f56854c\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}',0,NULL,1731048489,1731048489);

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

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

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

INSERT INTO `migrations` VALUES (2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2024_11_04_055718_create_titles_table',2),(5,'2024_11_04_055727_create_countries_table',2),(6,'2024_11_04_065457_create_fetp_statuses_table',3),(7,'2024_11_04_065505_create_fetp_tiers_table',3),(9,'2024_11_04_070258_create_workshops_table',4),(12,'2024_11_05_140637_create_sub_themes_table',6),(13,'2024_11_05_093523_create_submit_abstracts_table',7),(14,'0001_01_01_000000_create_users_table',1),(15,'2024_11_05_093530_create_reviews_table',8),(16,'2024_11_05_093542_create_confirms_table',8),(17,'2024_11_06_113907_create_permission_tables',8),(18,'2024_11_07_064833_create_notifications_table',9);

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

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) 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`
--


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

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) 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',4),(2,'App\\Models\\User',5),(2,'App\\Models\\User',6),(2,'App\\Models\\User',7);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(255) NOT NULL,
  `notifiable_type` varchar(255) NOT NULL,
  `notifiable_id` bigint(20) unsigned NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` VALUES ('03a4fa88-3fe6-4491-b478-df472d7cd052','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: An Abstract with the following details has been created: \\n                **Abstract Name:** <p>Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>\\n                **Track:** Maternal, Reproductive, and Child Health\\n                **Author:** Munir Makumbi\\n                **Date Submitted:** 2024-11-07 07:40:00\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"An Abstract titled \'<p>Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>\' has been Edited\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:56:54','2024-11-07 04:56:54'),('20f0bbab-a29f-4953-b8d0-6390fa2c27d0','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: A country with the following details has been Edited: \\n                    Country Name:\'Oman.\', Country Code:\'OMN\', Dialing Code:\'+968\'.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"Counntry \'Oman.\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:24:24','2024-11-07 04:24:24'),('4cb41108-ef05-4ec5-af8a-f79717307a08','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: A country with the following details has been Edited: \\n                    Country Name:\'Oman.\', Country Code:\'OMN\', Dialing Code:\'+999\'.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"Counntry \'Oman.\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:23:51','2024-11-07 04:23:51'),('54363c69-70af-4c3c-83ef-88e1a17f4ffd','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: An Abstract with the following details has been created: \\n                    Name:<p>Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>, Track:Maternal, Reproductive, and Child Health, Auther:Munir Makumbi on 2024-11-07 07:40:00.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"An Abstract titled \'<p>Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>\' has been Edited\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:50:15','2024-11-07 04:50:15'),('54ef2a74-7ca4-4a97-b0c4-30a0a78fa9ff','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: An Abstract with the following details has been created: \\n                    Name:\'<p>y<\\/p>\', Track:\'One Health and Climate Change\', Auther:\'Munir\' \'Makumbi\' on \'\'.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"An Abstract titled \'<p>y<\\/p>\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:45:50','2024-11-07 04:45:50'),('aaa8c571-d561-4d53-a930-00a1d9a8d581','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: A country with the following details has been created: \\n                    Country Name:\'Oman\', Country Code:\'OMN\', Dialing Code:\'+968\'.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"Counntry \'Oman\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:17:12','2024-11-07 04:17:12');

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

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

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

INSERT INTO `permissions` VALUES (1,'view_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(2,'view_any_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(3,'create_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(4,'update_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(5,'restore_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(6,'restore_any_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(7,'replicate_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(8,'reorder_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(9,'delete_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(10,'delete_any_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(11,'force_delete_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(12,'force_delete_any_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(13,'view_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(14,'view_any_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(15,'create_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(16,'update_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(17,'restore_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(18,'restore_any_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(19,'replicate_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(20,'reorder_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(21,'delete_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(22,'delete_any_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(23,'force_delete_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(24,'force_delete_any_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(25,'view_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(26,'view_any_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(27,'create_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(28,'update_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(29,'restore_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(30,'restore_any_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(31,'replicate_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(32,'reorder_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(33,'delete_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(34,'delete_any_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(35,'force_delete_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(36,'force_delete_any_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(37,'view_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(38,'view_any_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(39,'create_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(40,'update_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(41,'delete_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(42,'delete_any_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(43,'view_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(44,'view_any_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(45,'create_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(46,'update_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(47,'restore_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(48,'restore_any_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(49,'replicate_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(50,'reorder_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(51,'delete_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(52,'delete_any_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(53,'force_delete_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(54,'force_delete_any_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(55,'view_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(56,'view_any_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(57,'create_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(58,'update_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(59,'restore_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(60,'restore_any_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(61,'replicate_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(62,'reorder_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(63,'delete_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(64,'delete_any_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(65,'force_delete_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(66,'force_delete_any_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(67,'view_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(68,'view_any_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(69,'create_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(70,'update_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(71,'restore_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(72,'restore_any_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(73,'replicate_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(74,'reorder_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(75,'delete_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(76,'delete_any_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(77,'force_delete_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(78,'force_delete_any_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(79,'view_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(80,'view_any_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(81,'create_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(82,'update_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(83,'restore_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(84,'restore_any_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(85,'replicate_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(86,'reorder_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(87,'delete_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(88,'delete_any_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(89,'force_delete_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(90,'force_delete_any_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(91,'page_MyProfilePage','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(92,'view_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(93,'view_any_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(94,'create_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(95,'update_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(96,'restore_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(97,'restore_any_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(98,'replicate_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(99,'reorder_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(100,'delete_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(101,'delete_any_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(102,'force_delete_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(103,'force_delete_any_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(104,'view_notification','web','2024-11-07 05:21:39','2024-11-07 05:21:39'),(105,'view_any_notification','web','2024-11-07 05:21:39','2024-11-07 05:21:39');

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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 `reviews`
--


--
-- 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),(1,3),(2,1),(2,3),(3,1),(3,3),(4,1),(5,1),(5,3),(6,1),(6,3),(7,1),(7,3),(8,1),(8,3),(9,1),(10,1),(11,1),(12,1),(13,1),(13,3),(14,1),(14,3),(15,1),(15,3),(16,1),(16,3),(17,1),(17,3),(18,1),(18,3),(19,1),(19,3),(20,1),(20,3),(21,1),(21,3),(22,1),(22,3),(23,1),(23,3),(24,1),(24,3),(25,1),(25,3),(26,1),(26,3),(27,1),(27,3),(28,1),(28,3),(29,1),(29,3),(30,1),(30,3),(31,1),(31,3),(32,1),(32,3),(33,1),(33,3),(34,1),(34,3),(35,1),(35,3),(36,1),(36,3),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(43,1),(43,3),(44,1),(44,3),(45,1),(45,3),(46,1),(47,1),(47,3),(48,1),(48,3),(49,1),(49,3),(50,1),(50,3),(51,1),(52,1),(53,1),(54,1),(54,3),(55,1),(55,2),(55,3),(56,1),(56,2),(56,3),(57,1),(57,2),(57,3),(58,1),(58,2),(59,1),(60,1),(61,1),(62,1),(63,1),(64,1),(65,1),(66,1),(67,1),(67,3),(68,1),(68,3),(69,1),(69,3),(70,1),(71,1),(71,3),(72,1),(72,3),(73,1),(73,3),(74,1),(74,3),(75,1),(76,1),(77,1),(78,1),(79,1),(79,3),(80,1),(80,3),(81,1),(81,3),(82,1),(82,3),(83,1),(83,3),(84,1),(84,3),(85,1),(85,3),(86,1),(86,3),(87,1),(87,3),(88,1),(88,3),(89,1),(89,3),(90,1),(90,3),(91,1),(91,3),(92,1),(92,3),(93,1),(93,3),(94,1),(94,3),(95,1),(96,1),(97,1),(98,1),(99,1),(100,1),(101,1),(102,1),(103,1),(104,2),(105,2);

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

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) 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,'super_admin','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(2,'user','web','2024-11-06 08:42:40','2024-11-06 08:42:40'),(3,'Conf_admin','web','2024-11-07 03:10:44','2024-11-07 03:10:44');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES ('eHtlm2C1RlpOqBHP56ZWtwq2A3tMaWIsq5GWGPFE',4,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36','YTo2OntzOjY6Il90b2tlbiI7czo0MDoiank4eExENTl1YzZ5UWdReFlqOTJseEgwTlE5MEpWd0F4bjRTNTZmeSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQ0OiJodHRwOi8vbG9jYWxob3N0OjgwMDAvYWRtaW4vc3VibWl0LWFic3RyYWN0cyI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjQ7czoxNzoicGFzc3dvcmRfaGFzaF93ZWIiO3M6NjA6IiQyeSQxMiRwWE5jU2IuSGNDNmNRaC5EdjJuTnEuVEM1emk5NEFOSG9kR0tDY0FtM2VMeUxzSmVIQ3pYRyI7fQ==',1731083078),('nFtIlRV5bU7HsxzghcYhjAmyCv9WKDFGq2Sk1vAB',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36 Edg/130.0.0.0','YToyOntzOjY6Il90b2tlbiI7czo0MDoiNWlzWHpFVjYzYTFBVEhPalJodjB5aUcwZjBzUWFYc0J6VzFrSklnSCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1731082099);

--
-- Table structure for table `sub_themes`
--

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

--
-- Dumping data for table `sub_themes`
--

INSERT INTO `sub_themes` VALUES (1,'Public Health Systems Strengthening Initiatives','2024-11-05 11:13:06','2024-11-05 11:14:59'),(2,'Non-Communicable Diseases (NCDs), Injuries, and Mental Health','2024-11-05 11:13:23','2024-11-05 11:15:18'),(3,'Public Health Emergency Preparedness, Surveillance, Outbreak Investigations, and Response','2024-11-05 11:13:33','2024-11-05 11:16:03'),(4,'Public Health Laboratory Systems and Infection Prevention Control','2024-11-05 11:13:40','2024-11-05 11:16:18'),(5,'Vector-Borne and Neglected Tropical Diseases (NTDs)','2024-11-05 11:13:46','2024-11-05 11:16:29'),(6,'Maternal, Reproductive, and Child Health','2024-11-05 11:13:52','2024-11-05 11:16:40'),(7,'Communication and Technological Innovations for Public Health','2024-11-05 11:16:50','2024-11-05 11:16:50'),(8,'HIV/AIDS, Tuberculosis, and Other Opportunistic Infections','2024-11-05 11:16:57','2024-11-05 11:16:57'),(9,'Vaccine-Preventable Diseases','2024-11-05 11:17:02','2024-11-05 11:17:02'),(10,'One Health and Climate Change','2024-11-05 11:17:09','2024-11-05 11:17:09'),(11,'xyz','2024-11-08 04:02:04','2024-11-08 04:02:04');

--
-- Table structure for table `submit_abstracts`
--

CREATE TABLE `submit_abstracts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subtheme_id` int(5) DEFAULT NULL,
  `co_authors` text DEFAULT NULL,
  `abstract_title` text DEFAULT NULL,
  `abstract_backgound` text DEFAULT NULL,
  `abstract_methods` text DEFAULT NULL,
  `abstract_results` text DEFAULT NULL,
  `abstract_conclusion` text DEFAULT NULL,
  `key_words` text DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `submit_abstracts`
--

INSERT INTO `submit_abstracts` VALUES (1,8,'<p>Chukwuma Umeokonkwo, Jonh Kerry, Ronald Regean, Nancy Pelosi&nbsp;</p>','<p>Donec vel erat tincidunt tortor luctus faucibus sed quis sem. Ut interdum, nisl in vulputate gravida, nisl augue facilisis augue, eget aliquet ante massa in nunc. Sed lectus mi, cursus ac tincidunt sit amet, tempus in lorem. Maecenas aliquet tempor mauris,</p>','<p>Donec vel erat tincidunt tortor luctus faucibus sed quis sem. Ut interdum, nisl in vulputate gravida, nisl augue facilisis augue, eget aliquet ante massa in nunc. Sed lectus mi, cursus ac tincidunt sit amet, tempus in lorem. Maecenas aliquet tempor mauris, vitae rhoncus lacus faucibus pellentesque. Sed consectetur molestie magna ac rutrum. Maecenas vitae neque suscipit, ultricies arcu sit amet, maximus arcu. Phasellus tristique consequat lectus consectetur efficitur. Aliquam risus orci, imperdiet ac velit in, luctus tincidunt neque. Suspendisse potenti. Vestibulum aliquet vel ligula et blandit. Vestibulum venenatis, lectus id gravida porttitor, magna tortor faucibus neque, ac vulputate nisi quam vel ante. Integer ac lacus et nibh volutpat bibendum. Curabitur quis metus non ligula vestibulum blandit id quis sem.</p><p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p><p>Morbi vestibulum ornare rutrum. Vestibulum dignissim aliquam orci eget vestibulum. Duis leo nulla, suscipit eget nisi ac, mattis dictum odio. Mauris sit amet mollis sem, sed iaculis nibh. Vestibulum auctor tellus in sapien semper, at accumsan sapien mollis. Donec nulla tellus, pulvinar ut leo a, commodo dictum quam. Fusce nec finibus felis. Etiam ex felis, molestie eget dolor vitae, ultricies facilisis risus. Quisque ante lorem, ultrices vel imperdiet eu, vestibulum nec felis. Nunc consectetur interdum justo in dignissim. Sed ac pulvinar ex. Etiam ut ligula dui. In hac habitasse platea dictumst. Morbi nec lectus efficitur, ultricies mauris ac, ultricies diam.</p><p>Suspendisse et consectetur dolor. Proin laoreet nisi nec neque vulputate sagittis. Sed faucibus lobortis enim, eget tempus turpis pulvinar ut. Integer tempor tellus at sapien rhoncus, vel ullamcorper lorem mattis. Duis a tellus sed dolor viverra sagittis. Donec maximus elementum congue. In at mi id ligula eleifend maximus in quis diam. Aenean tortor quam, pulvinar at magna at, pellentesque imperdiet tortor.</p>','<p>Donec vel erat tincidunt tortor luctus faucibus sed quis sem. Ut interdum, nisl in vulputate gravida, nisl augue facilisis augue, eget aliquet ante massa in nunc. Sed lectus mi, cursus ac tincidunt sit amet, tempus in lorem. Maecenas aliquet tempor mauris, vitae rhoncus lacus faucibus pellentesque. Sed consectetur molestie magna ac rutrum. Maecenas vitae neque suscipit, ultricies arcu sit amet, maximus arcu. Phasellus tristique consequat lectus consectetur efficitur. Aliquam risus orci, imperdiet ac velit in, luctus tincidunt neque. Suspendisse potenti. Vestibulum aliquet vel ligula et blandit. Vestibulum venenatis, lectus id gravida porttitor, magna tortor faucibus neque, ac vulputate nisi quam vel ante. Integer ac lacus et nibh volutpat bibendum. Curabitur quis metus non ligula vestibulum blandit id quis sem.</p><p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p><p>Morbi vestibulum ornare rutrum. Vestibulum dignissim aliquam orci eget vestibulum. Duis leo nulla, suscipit eget nisi ac, mattis dictum odio. Mauris sit amet mollis sem, sed iaculis nibh. Vestibulum auctor tellus in sapien semper, at accumsan sapien mollis. Donec nulla tellus, pulvinar ut leo a, commodo dictum quam. Fusce nec finibus felis. Etiam ex felis, molestie eget dolor vitae, ultricies facilisis risus. Quisque ante lorem, ultrices vel imperdiet eu, vestibulum nec felis. Nunc consectetur interdum justo in dignissim. Sed ac pulvinar ex. Etiam ut ligula dui. In hac habitasse platea dictumst. Morbi nec lectus efficitur, ultricies mauris ac, ultricies diam.</p><p>Suspendisse et consectetur dolor. Proin laoreet nisi nec neque vulputate sagittis. Sed faucibus lobortis enim, eget tempus turpis pulvinar ut. Integer tempor tellus at sapien rhoncus, vel ullamcorper lorem mattis. Duis a tellus sed dolor viverra sagittis. Donec maximus elementum congue. In at mi id ligula eleifend maximus in quis diam. Aenean tortor quam, pulvinar at magna at, pellentesque imperdiet tortor.</p>','<p>Donec vel erat tincidunt tortor luctus faucibus sed quis sem. Ut interdum, nisl in vulputate gravida, nisl augue facilisis augue, eget aliquet ante massa in nunc. Sed lectus mi, cursus ac tincidunt sit amet, tempus in lorem. Maecenas aliquet tempor mauris, vitae rhoncus lacus faucibus pellentesque. Sed consectetur molestie magna ac rutrum. Maecenas vitae neque suscipit, ultricies arcu sit amet, maximus arcu. Phasellus tristique consequat lectus consectetur efficitur. Aliquam risus orci, imperdiet ac velit in, luctus tincidunt neque. Suspendisse potenti. Vestibulum aliquet vel ligula et blandit. Vestibulum venenatis, lectus id gravida porttitor, magna tortor faucibus neque, ac vulputate nisi quam vel ante. Integer ac lacus et nibh volutpat bibendum. Curabitur quis metus non ligula vestibulum blandit id quis sem.</p><p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p><p>Morbi vestibulum ornare rutrum. Vestibulum dignissim aliquam orci eget vestibulum. Duis leo nulla, suscipit eget nisi ac, mattis dictum odio. Mauris sit amet mollis sem, sed iaculis nibh. Vestibulum auctor tellus in sapien semper, at accumsan sapien mollis. Donec nulla tellus, pulvinar ut leo a, commodo dictum quam. Fusce nec finibus felis. Etiam ex felis, molestie eget dolor vitae, ultricies facilisis risus. Quisque ante lorem, ultrices vel imperdiet eu, vestibulum nec felis. Nunc consectetur interdum justo in dignissim. Sed ac pulvinar ex. Etiam ut ligula dui. In hac habitasse platea dictumst. Morbi nec lectus efficitur, ultricies mauris ac, ultricies diam.</p><p>Suspendisse et consectetur dolor. Proin laoreet nisi nec neque vulputate sagittis. Sed faucibus lobortis enim, eget tempus turpis pulvinar ut. Integer tempor tellus at sapien rhoncus, vel ullamcorper lorem mattis. Duis a tellus sed dolor viverra sagittis. Donec maximus elementum congue. In at mi id ligula eleifend maximus in quis diam. Aenean tortor quam, pulvinar at magna at, pellentesque imperdiet tortor.</p>','<p>Donec vel erat tincidunt tortor luctus faucibus sed quis sem. Ut interdum, nisl in vulputate gravida, nisl augue facilisis augue, eget aliquet ante massa in nunc. Sed lectus mi, cursus ac tincidunt sit amet, tempus in lorem. Maecenas aliquet tempor mauris, vitae rhoncus lacus faucibus pellentesque. Sed consectetur molestie magna ac rutrum. Maecenas vitae neque suscipit, ultricies arcu sit amet, maximus arcu. Phasellus tristique consequat lectus consectetur efficitur. Aliquam risus orci, imperdiet ac velit in, luctus tincidunt neque. Suspendisse potenti. Vestibulum aliquet vel ligula et blandit. Vestibulum venenatis, lectus id gravida porttitor, magna tortor faucibus neque, ac vulputate nisi quam vel ante. Integer ac lacus et nibh volutpat bibendum. Curabitur quis metus non ligula vestibulum blandit id quis sem.</p><p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p><p>Morbi vestibulum ornare rutrum. Vestibulum dignissim aliquam orci eget vestibulum. Duis leo nulla, suscipit eget nisi ac, mattis dictum odio. Mauris sit amet mollis sem, sed iaculis nibh. Vestibulum auctor tellus in sapien semper, at accumsan sapien mollis. Donec nulla tellus, pulvinar ut leo a, commodo dictum quam. Fusce nec finibus felis. Etiam ex felis, molestie eget dolor vitae, ultricies facilisis risus. Quisque ante lorem, ultrices vel imperdiet eu, vestibulum nec felis. Nunc consectetur interdum justo in dignissim. Sed ac pulvinar ex. Etiam ut ligula dui. In hac habitasse platea dictumst. Morbi nec lectus efficitur, ultricies mauris ac, ultricies diam.</p><p>Suspendisse et consectetur dolor. Proin laoreet nisi nec neque vulputate sagittis. Sed faucibus lobortis enim, eget tempus turpis pulvinar ut. Integer tempor tellus at sapien rhoncus, vel ullamcorper lorem mattis. Duis a tellus sed dolor viverra sagittis. Donec maximus elementum congue. In at mi id ligula eleifend maximus in quis diam. Aenean tortor quam, pulvinar at magna at, pellentesque imperdiet tortor.</p>','<p>Morbi vestibulum ornare rutrum</p>','4','2024-11-05 11:35:52','2024-11-06 06:23:24'),(2,7,'<p>awdasd</p>','<p>Assessment of Long Lasting Insecticide Nets Coverage, Utilization and Associated Factors Among Households In Malaria Elimination Districts of Arsi Zone, Oromia Region, Ethiopia, 2021.</p>','<p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p>','<p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p>','<p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p>','<p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p>','<p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p>','4','2024-11-05 11:41:15','2024-11-06 08:31:38'),(3,4,'<p>fdfsd</p>','<p>sdfsdf</p>','<p>sdfsdf</p>','<p>sdfdsf</p>','<p>sdfsdfsdfsdf</p>','<p><span style=\"text-decoration: underline;\">sdfdsfsdf</span></p>','<p>sfsdffsdfs</p>','4','2024-11-05 11:56:52','2024-11-05 11:56:52'),(4,2,'<p>x</p>','<p>x</p>','<p>x</p>','<p>x</p>','<p>x</p>','<p>x</p>','<p>x</p>','4','2024-11-06 03:12:44','2024-11-06 03:12:44'),(5,2,'<p>Joe Biden, Jill Biden</p>','<p>Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia</p>','<p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p>','<p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p>','<p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p>','<p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p>','<p>Praesent fermentum viverra condimentum. Suspendisse pulvinar mauris tortor, vel egestas magna porttitor id. Pellentesque dictum nibh eu lacus pellentesque venenatis. Quisque in sem consequat, tempor arcu sit amet, vehicula leo. Donec libero odio, ornare eu sem nec, dictum dapibus sem. Curabitur nisl nisl, varius a tortor at, finibus congue massa. Nam vitae mauris interdum, consequat mauris vel, elementum felis. Vivamus id lacinia est. Nam sit amet sapien sit amet massa congue eleifend id eu ipsum. Praesent iaculis neque ante, id porta lectus egestas eu.</p><p>Aliquam consequat leo eget ex elementum viverra. Curabitur fringilla, ex laoreet imperdiet lacinia, felis urna euismod ligula, quis ullamcorper ex turpis sit amet purus. Nam eu bibendum dui, et interdum erat. Nulla facilisi. Morbi tempor, tortor sit amet rutrum rhoncus, dolor massa placerat nulla, a bibendum justo nisl tempor dolor. Vestibulum eu diam vitae nibh viverra eleifend sed eget felis. Mauris pellentesque tortor tortor, et hendrerit diam pretium nec. Maecenas non risus ac libero semper ullamcorper eu eget leo.</p>','5','2024-11-06 08:59:34','2024-11-06 08:59:55'),(6,6,'<p>T. G. Gebrehiwot, Mekelle University, tesfig@gmail.com, K. Gebrselassie, Mekelle University, drhaileab@gmail.com, D. Zenebe, Mekelle University, dawitzemichael12@gmail.com<br>&nbsp;G. Gebregiorgis, Mekelle University, gebrecherkos.g@gmail.com<br><br></p>','<p>Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia</p>','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi finibus quam suscipit mi malesuada, non pellentesque tortor dignissim. Donec vel erat tincidunt tortor luctus faucibus sed quis sem. Ut interdum, nisl in vulputate gravida, nisl augue facilisis augue, eget aliquet ante massa in nunc. Sed lectus mi, cursus ac tincidunt sit amet, tempus in lorem. Maecenas aliquet tempor mauris, vitae rhoncus lacus faucibus pellentesque. Sed consectetur molestie magna ac rutrum. Maecenas vitae neque suscipit, ultricies arcu sit amet, maximus arcu. Phasellus tristique consequat lectus consectetur efficitur. Aliquam risus orci, imperdiet ac velit in, luctus tincidunt neque. Suspendisse potenti. Vestibulum aliquet vel ligula et blandit. Vestibulum venenatis, lectus id gravida porttitor, magna tortor faucibus neque, ac vulputate nisi quam vel ante. Integer ac lacus et nibh volutpat bibendum. Curabitur quis metus non ligula vestibulum blandit id quis sem.</p>','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi finibus quam suscipit mi malesuada, non pellentesque tortor dignissim. Donec vel erat tincidunt tortor luctus faucibus sed quis sem. Ut interdum, nisl in vulputate gravida, nisl augue facilisis augue, eget aliquet ante massa in nunc. Sed lectus mi, cursus ac tincidunt sit amet, tempus in lorem. Maecenas aliquet tempor mauris, vitae rhoncus lacus faucibus pellentesque. Sed consectetur molestie magna ac rutrum. Maecenas vitae neque suscipit, ultricies arcu sit amet, maximus arcu. Phasellus tristique consequat lectus consectetur efficitur. Aliquam risus orci, imperdiet ac velit in, luctus tincidunt neque. Suspendisse potenti. Vestibulum aliquet vel ligula et blandit. Vestibulum venenatis, lectus id gravida porttitor, magna tortor faucibus neque, ac vulputate nisi quam vel ante. Integer ac lacus et nibh volutpat bibendum. Curabitur quis metus non ligula vestibulum blandit id quis sem.</p>','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi finibus quam suscipit mi malesuada, non pellentesque tortor dignissim. Donec vel erat tincidunt tortor luctus faucibus sed quis sem. Ut interdum, nisl in vulputate gravida, nisl augue facilisis augue, eget aliquet ante massa in nunc. Sed lectus mi, cursus ac tincidunt sit amet, tempus in lorem. Maecenas aliquet tempor mauris, vitae rhoncus lacus faucibus pellentesque. Sed consectetur molestie magna ac rutrum. Maecenas vitae neque suscipit, ultricies arcu sit amet, maximus arcu. Phasellus tristique consequat lectus consectetur efficitur. Aliquam risus orci, imperdiet ac velit in, luctus tincidunt neque. Suspendisse potenti. Vestibulum aliquet vel ligula et blandit. Vestibulum venenatis, lectus id gravida porttitor, magna tortor faucibus neque, ac vulputate nisi quam vel ante. Integer ac lacus et nibh volutpat bibendum. Curabitur quis metus non ligula vestibulum blandit id quis sem.</p>','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi finibus quam suscipit mi malesuada, non pellentesque tortor dignissim. Donec vel erat tincidunt tortor luctus faucibus sed quis sem. Ut interdum, nisl in vulputate gravida, nisl augue facilisis augue, eget aliquet ante massa in nunc. Sed lectus mi, cursus ac tincidunt sit amet, tempus in lorem. Maecenas aliquet tempor mauris, vitae rhoncus lacus faucibus pellentesque. Sed consectetur molestie magna ac rutrum. Maecenas vitae neque suscipit, ultricies arcu sit amet, maximus arcu. Phasellus tristique consequat lectus consectetur efficitur. Aliquam risus orci, imperdiet ac velit in, luctus tincidunt neque. Suspendisse potenti. Vestibulum aliquet vel ligula et blandit. Vestibulum venenatis, lectus id gravida porttitor, magna tortor faucibus neque, ac vulputate nisi quam vel ante. Integer ac lacus et nibh volutpat bibendum. Curabitur quis metus non ligula vestibulum blandit id quis sem.</p>','<p>&nbsp;| Attitude, COVID-19, Ethiopia, Health Personnel, Pandemics</p>','5','2024-11-07 04:40:00','2024-11-07 04:55:09'),(7,10,'<p>y</p>','<p>y</p>','<p>y</p>','<p>y</p>','<p>y</p>','<p>y</p>','<p>y</p>','5','2024-11-07 04:45:49','2024-11-07 04:45:49'),(8,10,'<p>&nbsp;T. G. Gebrehiwot, Mekelle University, tesfig@gmail.com<br>&nbsp;K. Gebrselassie, Mekelle University, drhaileab@gmail.com<br>&nbsp;D. Zenebe, Mekelle University, dawitzemichael12@gmail.com<br>&nbsp;G. Gebregiorgis, Mekelle University, gebrecherkos.g@gmail.com<br><br></p>','<p>&nbsp;| Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia</p>','<p>&nbsp;| Globally, healthcare workers (HCWs) are at the frontline of Coronavirus Disease 19 (COVID-19) pandemic prevention and response measures. However, fear and hesitation due to the occupational risk coupled with knowledge gaps can compromise the COVID-19 prevention and control measures. Therefore, this study was conducted to assess the knowledge, perception and attitude of HCWs towards COVID-19 prevention and control in Tigray, Ethiopia, to fill the gap in evidence.&nbsp;</p>','<p>&nbsp;| Globally, healthcare workers (HCWs) are at the frontline of Coronavirus Disease 19 (COVID-19) pandemic prevention and response measures. However, fear and hesitation due to the occupational risk coupled with knowledge gaps can compromise the COVID-19 prevention and control measures. Therefore, this study was conducted to assess the knowledge, perception and attitude of HCWs towards COVID-19 prevention and control in Tigray, Ethiopia, to fill the gap in evidence.&nbsp;</p>','<p>&nbsp;| Globally, healthcare workers (HCWs) are at the frontline of Coronavirus Disease 19 (COVID-19) pandemic prevention and response measures. However, fear and hesitation due to the occupational risk coupled with knowledge gaps can compromise the COVID-19 prevention and control measures. Therefore, this study was conducted to assess the knowledge, perception and attitude of HCWs towards COVID-19 prevention and control in Tigray, Ethiopia, to fill the gap in evidence.&nbsp;</p>','<p>&nbsp;| Globally, healthcare workers (HCWs) are at the frontline of Coronavirus Disease 19 (COVID-19) pandemic prevention and response measures. However, fear and hesitation due to the occupational risk coupled with knowledge gaps can compromise the COVID-19 prevention and control measures. Therefore, this study was conducted to assess the knowledge, perception and attitude of HCWs towards COVID-19 prevention and control in Tigray, Ethiopia, to fill the gap in evidence.&nbsp;</p>','<p>&nbsp;| Globally, healthcare workers (HCWs) are at the frontline of Coronavirus Disease 19 (COVID-19) pandemic prevention and response measures. However, fear and hesitation due to the occupational risk coupled with knowledge gaps can compromise the COVID-19 prevention and control measures. Therefore, this study was conducted to assess the knowledge, perception and attitude of HCWs towards COVID-19 prevention and control in Tigray, Ethiopia, to fill the gap in evidence.&nbsp;</p>','7','2024-11-08 03:48:09','2024-11-08 03:48:09');

--
-- Table structure for table `titles`
--

CREATE TABLE `titles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) 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 `titles`
--

INSERT INTO `titles` VALUES (1,'Mr.','2024-11-04 03:24:14','2024-11-04 03:27:15'),(2,'Mrs.','2024-11-04 03:24:19','2024-11-04 03:27:20'),(3,'Ms.','2024-11-04 03:24:22','2024-11-04 03:27:29'),(4,'Dr.','2024-11-04 03:24:26','2024-11-04 03:27:49'),(5,'Prof.','2024-11-04 03:24:32','2024-11-04 03:27:56');

--
-- Table structure for table `workshops`
--

CREATE TABLE `workshops` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `details` text 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 `workshops`
--

INSERT INTO `workshops` VALUES (1,'The Art and Science of Peer Review','<p>The Art and Science of Peer Review</p>','2024-11-04 04:12:28','2024-11-04 04:12:28'),(2,'N/A','<p>Not Applicable</p>','2024-11-04 04:12:42','2024-11-04 04:12:42'),(3,'Training on 7-1-7 Planning and Implementation for Timely Detection, Notification and Response to Outbreaks','<p>Training on 7-1-7 Planning and Implementation for Timely Detection, Notification and Response to Outbreaks</p>','2024-11-04 04:13:37','2024-11-04 04:13:37'),(4,'Youth and Digital Public Health Interventions ','<p>Youth and Digital Public Health Interventions&nbsp;</p>','2024-11-04 04:13:55','2024-11-04 04:13:55'),(5,'FETP Quality Assurance: Accreditation/AFENET Star Rating System/REDPETT ','<p>FETP Quality Assurance: Accreditation/AFENET Star Rating System/REDPETT&nbsp;</p>','2024-11-04 04:14:07','2024-11-04 04:14:07'),(6,'Environmental Epidemiology and Toxicological Outbreak Investigation Pre-workshop Training','<p>Environmental Epidemiology and&nbsp;Toxicological&nbsp;Outbreak Investigation&nbsp;Pre-workshop&nbsp;Training</p>','2024-11-04 04:14:21','2024-11-04 04:14:21');


