/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `category_type` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL 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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (1,'Neutek','Education','Neutek',NULL,'2024-08-26 17:30:02','2024-08-26 17:30:02'),(2,'lorem opium','Practice','lorem opium, lorem opium, lorem opium, lorem opium, lorem opium, lorem opium, lorem opium, lorem opium, lorem opium',NULL,'2024-08-26 17:46:32','2024-08-26 17:46:32');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `districts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `districts` (
  `id` int(11) NOT NULL,
  `district_name` varchar(50) NOT NULL,
  `region_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `districts` WRITE;
/*!40000 ALTER TABLE `districts` DISABLE KEYS */;
INSERT INTO `districts` VALUES (1,'Asunafo North Municipal',2),(2,'Asunafo South District',2),(3,'Asutifi North District',2),(4,'Asutifi South District',2),(5,'Tano North Municipal',2),(6,'Tano South Municipal',2),(7,'Adansi North District',1),(8,'Adansi South District',1),(9,'Afigya Kwabre District',1),(10,'Ahafo Ano North Municipal',1),(11,'Ahafo Ano South West District',1),(12,'Amansie Central District',1),(13,'Amansie West District',1),(14,'Asante Akim Central Municipal',1),(15,'Asante Akim North District',1),(16,'Asante Akim South Municipal',1),(17,'Asokore Mampong Municipal',1),(18,'Atwima Kwanwoma District',1),(19,'Atwima Mponua District',1),(20,'Atwima Nwabiagya Municipal',1),(21,'Bekwai Municipal',1),(22,'Bosome Freho District',1),(23,'Bosomtwe District',1),(24,'Ejisu Municipal',1),(25,'Ejura Sekyedumase Municipal',1),(26,'Kumasi Metropolitan',1),(27,'Kwabre East Municipal',1),(28,'Mampong Municipal ',1),(29,'Obuasi Municipal',1),(30,'Offinso Municipal',1),(31,'Offinso North District',1),(32,'Sekyere Afram Plains District',1),(33,'Sekyere Central District',1),(34,'Sekyere East District',1),(35,'Sekyere Kumawu District',1),(36,'Sekyere South District',1),(37,'Oforikrom Municipal',1),(38,'Kwadaso Municipal',1),(39,'Old Tafo Municipal',1),(40,'Asokwa Municipal',1),(41,'Suame Municipal',1),(42,'Juaben Municipal',1),(43,'Ahafo Ano South East District',1),(44,'Amansie South District',1),(45,'Atwima Nwabiagya North District',1),(46,'Akrofuom District',1),(47,'Adansi Asokwa District',1),(48,'Obuasi East District',1),(49,'Afigya Kwabre North District',1),(50,'Banda District',4),(51,'Berekum Municipal',4),(52,'Dormaa Central Municipal',4),(53,'Dormaa East District',4),(54,'Dormaa West District',4),(55,'Jaman North District',4),(56,'Jaman South Municipal',4),(57,'Sunyani Municipal',4),(58,'Sunyani West District',4),(59,'Tain District',4),(60,'Wenchi Municipal',4),(61,'Berekum West District',4),(62,'Atebubu Amantin Municipal',3),(63,'Kintampo North Municipal',3),(64,'Kintampo South District',3),(65,'Nkoranza South Municipal ',3),(66,'Nkoranza  North District',3),(67,'Pru East District',3),(68,'Sene East District',3),(69,'Sene West District',3),(70,'Techiman Municipal',3),(71,'Techiman North District',3),(72,'Pru West District',3),(73,'Abura Asebu Kwamankese District',5),(74,'Agona East District',5),(75,'Agona West Municipal',5),(76,'Ajumako Enyan Essiam District',5),(77,'Asikuma Odoben Brankwa District',5),(78,'Assin Central Municipal',5),(79,'Assin South District',5),(80,'Awutu Senya East Municipal',5),(81,'Awutu Senya West District',5),(82,'Cape Coast Metropolitan',5),(83,'Effutu Municipal',5),(84,'Ekumfi District',5),(85,'Gomoa Central District',5),(86,'Gomoa West District',5),(87,'Komenda Edina Eguafo Abirem Municipal',5),(88,'Mfantseman Municipal',5),(89,'Twifo Atti Morkwa District',5),(90,'Twifo Heman Lower Denkyira District',5),(91,'Upper Denkyira East Municipal',5),(92,'Upper Denkyira West District',5),(93,'Assin North District',5),(94,'Gomoa East District',5),(95,'Akuapem North Municipal',6),(96,'Akuapim South District',6),(97,'Akyemansa District',6),(98,'Asuogyaman District',6),(99,'Atiwa West District',6),(100,'Ayensuano District',6),(101,'Birim Central Municipal',6),(102,'Birim North District',6),(103,'Birim South District',6),(104,'Denkyembour District',6),(105,'Abuakwa South Municipal',6),(106,'Fanteakwa North District',6),(107,'Kwaebibirem Municipal',6),(108,'Kwahu Afram Plains North District',6),(109,'Kwahu Afram Plains South District',6),(110,'Kwahu East District',6),(111,'Kwahu South District',6),(112,'Kwahu West Municipal',6),(113,'Lower Manya Krobo Municipal',6),(114,'New Juaben South Municipal',6),(115,'Nsawam Adoagyiri Municipal',6),(116,'Suhum Municipal',6),(117,'Upper Manya Krobo District',6),(118,'Upper West Akim District',6),(119,'West Akim Municipal',6),(120,'Yilo Krobo Municipal',6),(121,'Okere District',6),(122,'Atiwa East District',6),(123,'Fanteakwa South District',6),(124,'Asene Manso Akroso District',6),(125,'Abuakwa North Municipal',6),(126,'New Juaben North Municipal',6),(127,'Achiase District',6),(128,'Accra Metropolitan',7),(129,'Ada West District',7),(130,'Ada East District',7),(131,'Adentan Municipal',7),(132,'Ashaiman Municipal',7),(133,'Ga Central Municipal',7),(134,'Ga South Municipal',7),(135,'Ga East Municipal',7),(136,'Ga West Municipal',7),(137,'La Dade Kotopon Municipal',7),(138,'Ledzekuku Municipal',7),(139,'La Nkwantanang Madina Municipal',7),(140,'Ningo Prampram District',7),(141,'Shai Osudoku District',7),(142,'Tema Metropolitan',7),(143,'Kpone Katamanso Municipal',7),(144,'Okaikwei North Municipal',7),(145,'Ablekuma North Municipal',7),(146,'Ablekuma West Municipal',7),(147,'Ayawaso East Municipal',7),(148,'Ayawaso North Municipal',7),(149,'Ayawaso West Municipal',7),(150,'Ga North Municipal',7),(151,'Weija Gbawe Municipal',7),(152,'Tema West Municipal',7),(153,'Krowor Municipal',7),(154,'Korle Klottey Municipal',7),(155,'Ablekuma Central Municipal',7),(156,'Ayawaso Central Municipal',7),(157,'Bunkpurugu Nyankpanduri District',9),(158,'Chereponi District',9),(159,'East Mamprusi Municipal',9),(160,'Mamprugu Moagduri District',9),(161,'West Mamprusi Municipal',9),(162,'Yunyoo-Nasuan District',9),(163,'Gushegu Municipal',10),(164,'Karaga District',10),(165,'Kpandai District',10),(166,'Kumbungu District',10),(167,'Mion District',10),(168,'Nanumba North Municipal',10),(169,'Nanumba South District',10),(170,'Saboba District',10),(171,'Sagnarigu Municipal',10),(172,'Savelugu Municipal',10),(173,'Tamale Metropolitan',10),(174,'Tatale/Sanguli District',10),(175,'Tolon District',10),(176,'Yendi Municipal',10),(177,'Zabzugu District',10),(178,'Nanton District',10),(179,'Biakoye District',14),(180,'Jasikan District',14),(181,'Kadjebi District',14),(182,'Krachi East Municipal',14),(183,'Krachi Nchumuru District',14),(184,'Krachi West District',14),(185,'Nkwanta North District',14),(186,'Nkwanta South Municipal',14),(187,'Bole District',8),(188,'Central Gonja District',8),(189,'East Gonja Municipal',8),(190,'North Gonja District',8),(191,'Sawla-Tuna-Kalba District',8),(192,'West Gonja District',8),(193,'North East Gonja District',8),(194,'Bawku Municipal',11),(195,'Bawku West District',11),(196,'Binduri District',11),(197,'Bolgatanga Municipal',11),(198,'Bongo District',11),(199,'Builsa North Municipal',11),(200,'Builsa South District',11),(201,'Garu District',11),(202,'Kassena Nankana Municipal',11),(203,'Kassena Nankana West District',11),(204,'Nabdam District',11),(205,'Pusiga District',11),(206,'Talensi District',11),(207,'Bolgatanga East District',11),(208,'Tempane District',11),(209,'Daffiama Bussie Issa District',12),(210,'Jirapa Municipal',12),(211,'Lambussie Karni District',12),(212,'Lawra Municipal',12),(213,'Nadowli Kaleo District',12),(214,'Nandom District',12),(215,'Sissala East Municipal',12),(216,'Sissala West District',12),(217,'Wa East District',12),(218,'Wa Municipal',12),(219,'Wa West District',12),(220,'Adaklu District',13),(221,'Afadzato South District',13),(222,'Agotime Ziope District',13),(223,'Akatsi North District',13),(224,'Akatsi South District',13),(225,'Central Tongu District',13),(226,'Ho Municipal',13),(227,'Ho West District',13),(228,'Hohoe Municipal',13),(229,'Keta Municipal',13),(230,'Ketu North Municipal',13),(231,'Ketu South Municipal',13),(232,'Kpando Municipal',13),(233,'North Dayi District',13),(234,'North Tongu District',13),(235,'South Dayi District',13),(236,'South Tongu District',13),(237,'Anloga District',13),(238,'Ahanta West Municipal',15),(239,'Amenfi Central District',15),(240,'Wassa Amenfi East Municipal',15),(241,'Amenfi West Municipal',15),(242,'Ellembelle District',15),(243,'Jomoro Municipal',15),(244,'Mpohor District',15),(245,'Nzema East Municipal',15),(246,'Prestea-Huni Valley Municipal',15),(247,'Sekondi Takoradi Metropolitan',15),(248,'Shama District',15),(249,'Tarkwa Nsuaem Municipal',15),(250,'Wassa East District',15),(251,'Effia Kwesimintsim Municipal',15),(252,'Aowin Municipal',16),(253,'Bia East District',16),(254,'Bia West District',16),(255,'Bibiani-Anhwiaso Bekwai Municipal',16),(256,'Bodi District',16),(257,'Juaboso District',16),(258,'Sefwi Akontombra District',16),(259,'Sefwi Wiawso Municipal',16),(260,'Suaman District',16);
/*!40000 ALTER TABLE `districts` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `hotels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hotels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `rate` double NOT NULL,
  `contact` varchar(255) NOT NULL,
  `distance` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL 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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `hotels` WRITE;
/*!40000 ALTER TABLE `hotels` DISABLE KEYS */;
INSERT INTO `hotels` VALUES (1,'Capital View',300,'0501091299','3mins',1,NULL,'2024-09-08 17:57:18','2024-09-08 17:57:18'),(2,'Accra View',250,'0501091299','3mins',1,NULL,'2024-09-08 17:57:52','2024-09-08 17:57:52');
/*!40000 ALTER TABLE `hotels` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `job_titles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_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=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `job_titles` WRITE;
/*!40000 ALTER TABLE `job_titles` DISABLE KEYS */;
INSERT INTO `job_titles` VALUES (6,'Nurse Manager','2024-09-06 16:43:12','2024-09-06 16:43:12'),(8,'Director of Nursing and Midwifery  Services','2024-09-06 16:44:39','2024-09-06 16:44:39'),(9,'CNO/ CMO/ CHT','2024-09-06 16:44:55','2024-09-06 16:44:55'),(10,'Principal','2024-09-06 16:45:10','2024-09-06 16:45:10'),(11,'DCNO/ DCMO/ DCHT','2024-09-06 16:45:25','2024-09-06 16:45:25'),(12,'PNO/ PMO/ PHT','2024-09-06 16:45:39','2024-09-06 16:45:39'),(13,'SNO/ SMO/ SHT','2024-09-06 16:45:57','2024-09-06 16:45:57'),(14,'NO/ MO/ HT','2024-09-06 16:46:14','2024-09-06 16:46:14'),(15,'Consultant Nurse/ Midwife','2024-09-06 16:46:31','2024-09-06 16:46:31'),(16,'Specialist Nurse/ Midwife','2024-09-06 16:46:49','2024-09-06 16:46:49');
/*!40000 ALTER TABLE `job_titles` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (2,'0001_01_01_000001_create_cache_table',2),(3,'0001_01_01_000002_create_jobs_table',2),(4,'2024_07_31_123549_create_personal_access_tokens_table',2),(5,'2024_08_02_155006_create_patients_table',2),(6,'2024_08_05_081239_create_motions_table',2),(7,'2024_08_05_081244_create_options_table',2),(8,'2024_08_05_081252_create_votes_table',2),(9,'2024_08_21_020642_create_oauth_auth_codes_table',2),(10,'2024_08_21_020643_create_oauth_access_tokens_table',2),(11,'2024_08_21_020644_create_oauth_refresh_tokens_table',2),(12,'2024_08_21_020645_create_oauth_clients_table',2),(13,'2024_08_21_020646_create_oauth_personal_access_clients_table',2),(18,'2024_08_26_170821_create_categories_table',4),(29,'2024_09_06_123442_create_job_titles_table',8),(30,'2024_09_06_123449_create_user_titles_table',8),(32,'2024_09_07_164732_create_settlements_table',10),(33,'0001_01_01_000000_create_users_table',11),(37,'2024_09_07_180305_create_payments_table',12),(38,'2024_09_08_173732_create_user_hotels_table',13),(39,'2024_09_06_123416_create_hotels_table',14),(40,'2024_09_01_192442_create_nominees_table',15);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `motions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `motions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `topic` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `motions` WRITE;
/*!40000 ALTER TABLE `motions` DISABLE KEYS */;
/*!40000 ALTER TABLE `motions` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `nominees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nominees` (
  `id` char(36) NOT NULL,
  `user_title_id` bigint(20) unsigned NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `nominator_name` varchar(255) NOT NULL,
  `nominator_phone` varchar(255) NOT NULL,
  `nominator_address` varchar(255) NOT NULL,
  `nomination_reason` varchar(255) NOT NULL,
  `profile` varchar(255) NOT NULL,
  `cv` varchar(255) NOT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  `approved` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `nominees` WRITE;
/*!40000 ALTER TABLE `nominees` DISABLE KEYS */;
INSERT INTO `nominees` VALUES ('',3,'Eugene','Yaw','501091299','Euen','501091299','Airport','Msc','http://127.0.0.1:8000/storage/documents/nominee/profile/Eugene_Yaw_1NkmN3JKcm.png','http://127.0.0.1:8000/storage/documents/nominee/cv/Eugene_Yaw_KMfiCUm5tc.pdf',1,0,'2024-09-08 19:26:25','2024-09-08 19:26:25');
/*!40000 ALTER TABLE `nominees` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `oauth_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) NOT NULL,
  `user_id` char(36) DEFAULT NULL,
  `client_id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `oauth_access_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */;
INSERT INTO `oauth_access_tokens` VALUES ('2de86b28adf4110d9465f6a1f5c599f6f1da1eb1b6190a7d2bd9b9a7de2bdb0665097b3c3c0c7ef2','9cf6040d-905f-44d6-888b-5db2e4e083fc','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-09-08 14:07:35','2024-09-08 14:07:35','2025-09-08 14:07:35'),('46b05d2260fe4373b00b6c4c571c495b79c807cdbefadee5ae91ea8b6ae0b5f67fe723bbf8ea317d','9cf24640-4e67-4406-bcab-1c1c4736c1af','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-09-06 17:29:27','2024-09-06 17:29:27','2025-09-06 17:29:27'),('49127bbcccbc513833d7fd7e725629401c8765c934b38bc2ce270d9a73400cee2da2121195eb49ae','9ce573a5-ceae-4d9e-9dc0-8168680598be','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-08-31 08:31:10','2024-08-31 08:31:11','2025-08-31 08:31:10'),('589e576acfb19e78d9533eb4b67ff1d5e686688da4112ede0815242c98a06f633229e227070da5e2','9cf23e99-d51e-4202-86cf-92a5f1aedc73','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-09-06 17:08:07','2024-09-06 17:08:08','2025-09-06 17:08:07'),('87652768ec85fb9f66f92b80664edd10cddb3c704c4437e5e428dfb4545b655bbd1b75581a0cb7de','9ce5689b-9370-4807-bf0c-60053a71d543','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-08-31 07:59:50','2024-08-31 07:59:50','2025-08-31 07:59:50'),('8976275a7fedfd7e6e079c3ab6b8e764fed122b557a8095887ad7aac43647ebdcb620e9bf764ed01','9ce56d64-9e90-4319-92f3-7bcf913f96f0','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-08-31 08:13:07','2024-08-31 08:13:08','2025-08-31 08:13:07'),('8d5c400f433951e43a9a0b8e781d8493e637741e1fe6b6f68538440f6d64a645e77523040143b4db','9ce9ec7e-3e13-4577-b199-f3d56270abf7','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-09-02 13:51:52','2024-09-02 13:51:53','2025-09-02 13:51:52'),('9d0ba1e23f70eacb8664e951b859b79515fc3aea9cd0ba8d0c7ecf0debf6e15a73812816b8f8ffa5','9cdbaf9e-2f3b-4d4a-990f-3c11df8d1975','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-08-26 12:00:37','2024-08-26 12:00:37','2025-08-26 12:00:37'),('af2c93784a7f9dea6d0d8d0c89b74a8216e5b36d63eae58ac1f26750bbad571164a1150cfc5dd2cb','9ce208c0-1a65-497e-9685-18053870b0d4','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-08-29 15:44:24','2024-08-29 15:44:25','2025-08-29 15:44:24'),('cc2d3b6ef4fbc97b61868da121b25f155fe6c6b09c9103014a1380f6f7cc6f83c87f07ee48a79509','9ce56f80-3824-4b31-a3b6-0e9e5736545d','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-08-31 08:18:57','2024-08-31 08:18:57','2025-08-31 08:18:57'),('dce03850e7e64540e1a84db0b95b8e61b909ad9fbd67ff2a2a8e45f0c597166ca5659fbc0cc202a3','9ce57143-17cf-4658-8b4d-d531071b4b71','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-08-31 08:23:52','2024-08-31 08:23:53','2025-08-31 08:23:52'),('de09cfe4b4d06ec12b5e75c2d9d10ad384f7f9915f459ff443a05b4221674f91b956582a12477679','9ce8007d-5c12-4aff-9d73-9481e72473fe','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-09-01 14:56:16','2024-09-01 14:56:17','2025-09-01 14:56:16'),('e97524a44fde41b2bfb557474a0da4ad8fb9c0693c5e8e8fff8707efea9615eaebe1afedce706c5a','9ce56240-144b-47f1-a781-02205516aaaf','9cdba6a8-da05-46bc-aa3c-5efd319fba1d','passportToken','[]',0,'2024-08-31 07:42:00','2024-08-31 07:42:00','2025-08-31 07:42:00');
/*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `oauth_auth_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` char(36) NOT NULL,
  `client_id` char(36) NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `oauth_auth_codes` WRITE;
/*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `oauth_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_clients` (
  `id` char(36) NOT NULL,
  `user_id` char(36) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `secret` varchar(100) DEFAULT NULL,
  `provider` varchar(255) DEFAULT NULL,
  `redirect` text NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `oauth_clients` WRITE;
/*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */;
INSERT INTO `oauth_clients` VALUES ('9cdba6a8-da05-46bc-aa3c-5efd319fba1d',NULL,'Laravel Personal Access Client','8bXT3w6STS0Mx3f0HDSNMZDQOt8HYUS4rPQeuK53',NULL,'http://localhost',1,0,0,'2024-08-26 11:34:38','2024-08-26 11:34:38'),('9cdba6ca-ee6f-43a0-b943-0492883afbf4',NULL,'Laravel Password Grant Client','06ZeM9HqV4R4m0eUyPjacyp5nPjBMXCGTGDvOcBJ','users','http://localhost',0,1,0,'2024-08-26 11:35:00','2024-08-26 11:35:00');
/*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `oauth_personal_access_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` char(36) NOT NULL,
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `oauth_personal_access_clients` WRITE;
/*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */;
INSERT INTO `oauth_personal_access_clients` VALUES (1,'9cdba6a8-da05-46bc-aa3c-5efd319fba1d','2024-08-26 11:34:39','2024-08-26 11:34:39');
/*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `oauth_refresh_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) NOT NULL,
  `access_token_id` varchar(100) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `oauth_refresh_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `options` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `motion_id` bigint(20) unsigned NOT NULL,
  `option` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `options` WRITE;
/*!40000 ALTER TABLE `options` DISABLE KEYS */;
/*!40000 ALTER TABLE `options` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `patients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `patients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `residence` varchar(255) NOT NULL,
  `landmark` varchar(255) NOT NULL,
  `record_id` varchar(255) 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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `patients` WRITE;
/*!40000 ALTER TABLE `patients` DISABLE KEYS */;
/*!40000 ALTER TABLE `patients` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payments` (
  `id` char(36) NOT NULL,
  `payment_type` varchar(255) NOT NULL,
  `user_id` char(36) NOT NULL,
  `amount` double NOT NULL,
  `currency` varchar(4) NOT NULL DEFAULT 'GHS',
  `paid` tinyint(1) NOT NULL DEFAULT 0,
  `paid_on` timestamp NULL DEFAULT NULL,
  `payment_processor` varchar(10) NOT NULL,
  `payment_response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_response`)),
  `client_reference` varchar(255) NOT NULL,
  `settlement_id` char(36) 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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
INSERT INTO `payments` VALUES ('9cf622c7-ba08-4a4b-a90d-d238bd357bd8','hotel','9cf6040d-905f-44d6-888b-5db2e4e083fc',300,'GHS',0,NULL,'hubtel',NULL,'c829eaa7-83f9-4e96-83a4-cf380782f7e7',NULL,'2024-09-08 15:33:14','2024-09-08 18:36:30'),('9cf624ab-6b55-41a3-9947-5b81df533ac6','registration','9cf6040d-905f-44d6-888b-5db2e4e083fc',0.2,'GHS',0,NULL,'hubtel',NULL,'265ff8d4-c979-4100-9caa-2b7e022d5e45',NULL,'2024-09-08 15:38:31','2024-09-08 15:40:31');
/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `regions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `regions` (
  `id` int(11) NOT NULL,
  `region_name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `regions` WRITE;
/*!40000 ALTER TABLE `regions` DISABLE KEYS */;
INSERT INTO `regions` VALUES (1,'Ashanti'),(2,'Ahafo'),(3,'Bono East'),(4,'Bono'),(5,'Central'),(6,'Eastern'),(7,'Greater Accra'),(8,'Savannah'),(9,'North East'),(10,'Northern'),(11,'Upper East'),(12,'Upper West'),(13,'Volta'),(14,'Oti'),(15,'Western'),(16,'Western North');
/*!40000 ALTER TABLE `regions` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('0UTskfXCZRuvsmNk5BYpFKWI9hXErpuLcOSFKAC6',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNzFsY2lUOTlnQVA4YkN5bzBYbmtPYUlmWWxuSUtUZWVwYlRHSzNjSSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1725823549),('VOGzdtjEixoyJAR2u9V51V2HPIzJfMzpekehqbJw',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoieHJocGRFTHNSRHBaOGdjMTNRTEJubVF2TkRFb1d6UE5qdW5DTFI4VyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9ub21pbmF0ZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1725834277);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `settlements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settlements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `count` int(11) NOT NULL,
  `amount` double NOT NULL,
  `requested_by` char(36) NOT NULL,
  `requested_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `confirmed_by` char(36) DEFAULT NULL,
  `confirmed_on` timestamp NULL DEFAULT NULL,
  `payment_reference` varchar(255) 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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `settlements` WRITE;
/*!40000 ALTER TABLE `settlements` DISABLE KEYS */;
/*!40000 ALTER TABLE `settlements` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `user_hotels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_hotels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` char(36) NOT NULL,
  `hotel_id` bigint(20) unsigned NOT NULL,
  `paid` tinyint(1) NOT NULL DEFAULT 0,
  `payment_id` char(36) DEFAULT 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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `user_hotels` WRITE;
/*!40000 ALTER TABLE `user_hotels` DISABLE KEYS */;
INSERT INTO `user_hotels` VALUES (3,'9cf6040d-905f-44d6-888b-5db2e4e083fc',1,0,NULL,'2024-09-08 18:36:30','2024-09-08 18:36:30');
/*!40000 ALTER TABLE `user_hotels` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `user_titles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `user_titles` WRITE;
/*!40000 ALTER TABLE `user_titles` DISABLE KEYS */;
INSERT INTO `user_titles` VALUES (3,'Prof','2024-09-06 16:38:57','2024-09-06 16:38:57'),(4,'Dr','2024-09-06 16:39:07','2024-09-06 16:39:07'),(5,'Mrs','2024-09-06 16:39:17','2024-09-06 16:39:17'),(6,'Mr','2024-09-06 16:39:28','2024-09-06 16:39:28'),(7,'Miss','2024-09-06 16:39:36','2024-09-06 16:39:36');
/*!40000 ALTER TABLE `user_titles` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` char(36) NOT NULL,
  `user_title_id` bigint(20) unsigned NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `role` varchar(255) NOT NULL,
  `token` varchar(255) DEFAULT NULL,
  `gender` varchar(10) NOT NULL,
  `country` varchar(10) NOT NULL,
  `job_title_id` bigint(20) unsigned NOT NULL,
  `nmc_pin` varchar(255) NOT NULL,
  `place_of_work` varchar(255) NOT NULL,
  `work_phone_number` varchar(255) NOT NULL,
  `work_address` varchar(255) NOT NULL,
  `region_id` bigint(20) unsigned NOT NULL,
  `district_id` bigint(20) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `password` varchar(255) NOT NULL,
  `profile` varchar(255) DEFAULT NULL,
  `registration_paid` tinyint(1) NOT NULL DEFAULT 0,
  `hotel_paid` tinyint(1) NOT NULL DEFAULT 0,
  `reported` tinyint(1) NOT NULL DEFAULT 0,
  `payment_response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_response`)),
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_phone_unique` (`phone`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('9cf6040d-905f-44d6-888b-5db2e4e083fc',3,'Eugene','Yaw','240945395','opoku.s.eugene@gmail.com','participant',NULL,'M','GH',9,'123456','Airport','0501091299','',1,7,1,'$2y$12$8FtYbn4F50AXcGPQejC.f.IJG3gb6SQCwZk1tdEwhbzNnUt9Se9/u','http://127.0.0.1:8000/storage/documents/users/profile/Eugene_Yaw_GgPkD7BJEe.png',0,0,0,NULL,NULL,'2024-09-08 14:07:18','2024-09-08 14:07:18');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `votes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `votes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `motion_id` bigint(20) unsigned NOT NULL,
  `option_id` bigint(20) unsigned NOT NULL,
  `user_id` char(36) 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;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `votes` WRITE;
/*!40000 ALTER TABLE `votes` DISABLE KEYS */;
/*!40000 ALTER TABLE `votes` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;