
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;

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');
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;

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);
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;

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;

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');
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;

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;

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');
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;

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;

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);
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;

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;

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');
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;

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;

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');
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;

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;

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;

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');
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;

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');
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;

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);
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;

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;

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');
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;

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');
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;



