/*Table structure for table `billing_items` */

DROP TABLE IF EXISTS `billing_items`;

CREATE TABLE `billing_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `billing_id` bigint(20) unsigned NOT NULL,
  `description` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `item_date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `billing_items_billing_id_foreign` (`billing_id`),
  CONSTRAINT `billing_items_billing_id_foreign` FOREIGN KEY (`billing_id`) REFERENCES `billings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `billing_items` */

insert  into `billing_items`(`id`,`billing_id`,`description`,`amount`,`quantity`,`item_date`,`created_at`,`updated_at`) values (3,1,'Food','2.00',1,'2025-12-15 14:33:00','2025-12-15 14:34:01','2025-12-15 14:52:54'),(4,1,'drinks','3.00',1,'2025-12-15 14:33:00','2025-12-15 14:34:01','2025-12-15 14:52:54'),(5,1,'water','3.00',1,'2025-12-15 14:33:00','2025-12-15 14:34:01','2025-12-15 14:52:54'),(6,1,'water','3.00',1,'2025-12-15 14:44:00',NULL,'2025-12-15 14:52:54'),(7,1,'cocacola','2.00',1,'2025-12-15 14:48:00',NULL,'2025-12-15 14:52:54'),(8,1,'cocacola','2.00',1,'2025-12-15 14:48:00',NULL,'2025-12-15 14:52:54'),(9,1,'fanta','23.00',1,'2025-12-15 14:52:00',NULL,NULL),(10,1,'fanta','23.00',1,'2025-12-15 14:52:00',NULL,NULL),(11,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(12,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(13,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(14,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(15,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(16,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(17,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(18,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(19,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(20,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(21,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(22,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(23,3,'kuku','2.00',2,'2025-12-18 08:45:00',NULL,NULL),(24,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(25,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(26,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(27,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(28,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(29,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(30,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(31,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(32,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(33,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(34,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(35,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(36,3,'kuku','2.00',2,'2025-12-18 08:45:00',NULL,NULL),(37,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(38,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(39,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(40,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(41,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(42,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(43,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(44,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(45,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(46,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(47,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(48,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(49,3,'kuku','2.00',2,'2025-12-18 08:45:00',NULL,NULL),(50,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(51,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(52,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(53,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(54,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(55,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(56,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(57,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(58,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(59,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(60,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(61,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(62,3,'kuku','2.00',2,'2025-12-18 08:45:00',NULL,NULL),(63,3,'yyy','1.00',1,'2025-12-18 08:55:00',NULL,NULL),(64,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(65,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(66,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(67,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(68,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(69,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(70,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(71,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(72,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(73,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(74,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(75,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(76,3,'kuku','2.00',2,'2025-12-18 08:45:00',NULL,NULL),(77,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(78,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(79,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(80,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(81,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(82,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(83,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(84,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(85,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(86,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(87,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(88,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(89,3,'kuku','2.00',2,'2025-12-18 08:45:00',NULL,NULL),(90,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(91,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(92,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(93,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(94,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(95,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(96,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(97,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(98,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(99,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(100,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(101,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(102,3,'kuku','2.00',2,'2025-12-18 08:45:00',NULL,NULL),(103,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(104,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(105,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(106,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(107,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(108,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(109,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(110,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(111,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(112,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(113,3,'sod','1.00',1,'2025-12-18 08:23:00',NULL,NULL),(114,3,'maji','2.00',1,'2025-12-18 08:28:00',NULL,NULL),(115,3,'kuku','2.00',2,'2025-12-18 08:45:00',NULL,NULL),(116,3,'yyy','1.00',1,'2025-12-18 08:55:00',NULL,NULL),(117,2,'drink','4.00',1,'2025-12-18 09:19:00',NULL,NULL),(118,2,'drink','4.00',1,'2025-12-18 09:19:00',NULL,NULL),(119,2,'maji','6.00',1,'2025-12-18 09:19:00',NULL,NULL),(120,2,'soda','2.00',1,'2025-12-18 09:29:00','2025-12-18 09:30:04','2025-12-18 09:30:04'),(121,2,'cocacola','2.00',1,'2025-12-18 10:54:00','2025-12-18 10:54:15','2025-12-18 10:54:15'),(122,2,'fff','1.00',1,'2025-12-18 11:03:00','2025-12-18 11:03:31','2025-12-18 11:03:31');

/*Table structure for table `billings` */

DROP TABLE IF EXISTS `billings`;

CREATE TABLE `billings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` bigint(20) unsigned NOT NULL,
  `amount_to_pay` decimal(10,2) DEFAULT NULL,
  `amount_paid` decimal(10,2) DEFAULT NULL,
  `payment_method` enum('bank','mobile','cash') DEFAULT NULL,
  `bank_name` enum('NMB','CRDB','NBC') DEFAULT NULL,
  `mobile_operator` enum('MPESA','T-PESA','HALOPESA','YAS') DEFAULT NULL,
  `reference_number` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `billings_booking_id_foreign` (`booking_id`),
  CONSTRAINT `billings_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `billings` */

insert  into `billings`(`id`,`booking_id`,`amount_to_pay`,`amount_paid`,`payment_method`,`bank_name`,`mobile_operator`,`reference_number`,`created_at`,`updated_at`) values (1,1,'56.93','73.00','bank','CRDB',NULL,'www','2025-12-15 13:30:52','2025-12-15 15:52:05'),(2,3,'29.00','24.00','cash',NULL,NULL,'uuu','2025-12-15 16:48:29','2025-12-18 11:04:07'),(3,4,'282.00','210.00','cash',NULL,NULL,'wawwar','2025-12-18 07:51:41','2025-12-18 09:10:23'),(4,5,'240.00','0.00',NULL,NULL,NULL,NULL,'2026-04-13 08:14:57','2026-04-13 08:14:57');

/*Table structure for table `bookings` */

DROP TABLE IF EXISTS `bookings`;

CREATE TABLE `bookings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `room_id` bigint(20) unsigned NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `check_in` date DEFAULT NULL,
  `check_out` date DEFAULT NULL,
  `special_requests` text DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `released_at` datetime DEFAULT NULL,
  `booking_date` date DEFAULT NULL,
  `booking_source` enum('Call','SMS/WhatsApp','Email','Website') NOT NULL DEFAULT 'Website',
  `amount_to_pay` decimal(10,2) DEFAULT NULL,
  `amount_paid` decimal(10,2) DEFAULT NULL,
  `payment_method` enum('bank','mobile','cash') DEFAULT NULL,
  `bank_name` enum('NMB','CRDB','NBC') DEFAULT NULL,
  `mobile_operator` enum('MPESA','T-PESA','HALOPESA','YAS') DEFAULT NULL,
  `reference_number` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bookings_room_id_foreign` (`room_id`),
  CONSTRAINT `bookings_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `bookings` */

insert  into `bookings`(`id`,`room_id`,`full_name`,`email`,`phone`,`location`,`check_in`,`check_out`,`special_requests`,`status`,`released_at`,`booking_date`,`booking_source`,`amount_to_pay`,`amount_paid`,`payment_method`,`bank_name`,`mobile_operator`,`reference_number`,`created_at`,`updated_at`) values (1,12,'Rama Potts','kequsiz@mailinator.com','+1 (824) 129-3419','Non laudantium eu e','2025-12-16','2025-12-15','Et aliqua Laboris q','confirmed','2025-12-15 15:52:05','2025-12-15','Email',NULL,NULL,NULL,NULL,NULL,NULL,'2025-12-15 11:59:08','2025-12-15 15:52:05'),(2,11,'Athena Ferguson','wyqydak@mailinator.com','+1 (906) 541-5142','Sequi esse velit ips','2025-12-15','2025-12-17','Et mollitia alias pa','cancelled',NULL,'2025-12-15','Website',NULL,NULL,NULL,NULL,NULL,NULL,'2025-12-15 15:40:38','2025-12-15 15:41:32'),(3,11,'Shannon Durham','vevex@mailinator.com','+1 (896) 758-9558','Aut debitis aut eum','2025-12-15','2025-12-16','Sint rerum sed et ea','confirmed',NULL,'2025-12-15','Website',NULL,NULL,NULL,NULL,NULL,NULL,'2025-12-15 16:47:20','2025-12-15 16:48:29'),(4,6,'Ocean Clayton','masaga303@emca.tech','+1 (459) 836-6298','Voluptatem Omnis au','2025-12-18','2025-12-19','Minim aut deserunt c','confirmed_no_payment',NULL,'2025-12-18','Website',NULL,NULL,NULL,NULL,NULL,NULL,'2025-12-18 06:59:41','2025-12-18 07:51:41'),(5,6,'Adrienne Mckay','qexisady@mailinator.com','+1 (869) 452-2806','Amet accusantium ra','2026-04-13','2026-04-15','Anim et culpa suscip','confirmed_no_payment',NULL,'2026-04-13','Website',NULL,NULL,NULL,NULL,NULL,NULL,'2026-04-13 07:49:09','2026-04-13 08:14:57');

/*Table structure for table `cache` */

DROP TABLE IF EXISTS `cache`;

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;

/*Data for the table `cache` */

/*Table structure for table `cache_locks` */

DROP TABLE IF EXISTS `cache_locks`;

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;

/*Data for the table `cache_locks` */

/*Table structure for table `contact_messages` */

DROP TABLE IF EXISTS `contact_messages`;

CREATE TABLE `contact_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `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;

/*Data for the table `contact_messages` */

/*Table structure for table `failed_jobs` */

DROP TABLE IF EXISTS `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;

/*Data for the table `failed_jobs` */

/*Table structure for table `galleries` */

DROP TABLE IF EXISTS `galleries`;

CREATE TABLE `galleries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `category` enum('rooms','apartments','conferences','other_experiences','slider','post','news') NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `galleries_created_by_foreign` (`created_by`),
  CONSTRAINT `galleries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `galleries` */

insert  into `galleries`(`id`,`title`,`description`,`category`,`image`,`display_order`,`is_active`,`created_by`,`created_at`,`updated_at`) values (1,'Proident est dolor','Ipsum facilis alias','rooms','galleries/B1pRxYzDB861KROUsq6jlaxeuB2giq1HGmJlvQAO.png',36,1,2,'2026-04-13 09:05:43','2026-04-13 09:17:29'),(2,'Lorem exercitationem','Assumenda voluptate','other_experiences','galleries/fi4i5ZI9DIHLXK19fqxaEggk7sKRNNJhbYPfB5BL.png',63,1,2,'2026-04-13 09:13:34','2026-04-13 09:13:34');

/*Table structure for table `job_batches` */

DROP TABLE IF EXISTS `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;

/*Data for the table `job_batches` */

/*Table structure for table `jobs` */

DROP TABLE IF EXISTS `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `jobs` */

/*Table structure for table `migrations` */

DROP TABLE IF EXISTS `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=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `migrations` */

insert  into `migrations`(`id`,`migration`,`batch`) values (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2025_12_15_073837_create_rooms_table',2),(5,'2025_12_15_073842_create_bookings_table',2),(6,'2025_12_15_075051_create_testimonials_table',3),(7,'2025_12_15_080038_add_role_to_users_table',4),(8,'2025_12_15_080042_add_approval_status_to_rooms_table',4),(9,'2025_12_15_080045_add_approval_status_to_testimonials_table',4),(10,'2025_12_15_083419_change_rooms_images_to_json',5),(11,'2025_12_15_084401_add_amenities_to_rooms_table',6),(12,'2025_12_15_092820_add_room_number_and_category_to_rooms_table',7),(13,'2025_12_15_112232_add_booking_date_and_source_to_bookings_table',8),(14,'2025_12_15_124251_add_billing_details_to_bookings_table',9),(15,'2025_12_15_124918_add_reference_number_to_bookings_table',10),(16,'2025_12_15_131833_create_billings_table',11),(17,'2025_12_15_133720_create_billing_items_table',12),(18,'2025_12_15_141153_add_date_time_to_billing_items_table',13),(19,'2025_12_15_141248_add_released_at_to_bookings_table',13),(20,'2025_12_15_165807_create_galleries_table',14),(21,'2025_12_18_085205_create_payments_table',15),(22,'2026_04_13_120000_add_conference_category_to_rooms_table',16),(23,'2026_04_13_123000_add_conference_fields_to_rooms_table',16),(24,'2026_04_13_140000_expand_gallery_categories',17),(25,'2026_04_13_150000_create_contact_messages_table',18),(26,'2026_04_13_151000_create_newsletter_emails_table',18);

/*Table structure for table `newsletter_emails` */

DROP TABLE IF EXISTS `newsletter_emails`;

CREATE TABLE `newsletter_emails` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `subscribed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `newsletter_emails_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `newsletter_emails` */

insert  into `newsletter_emails`(`id`,`email`,`is_active`,`subscribed_at`,`created_at`,`updated_at`) values (5,'masaga303@gmail.com',1,'2026-04-14 07:47:53','2026-04-14 07:47:53','2026-04-14 07:47:53');

/*Table structure for table `password_reset_tokens` */

DROP TABLE IF EXISTS `password_reset_tokens`;

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;

/*Data for the table `password_reset_tokens` */

/*Table structure for table `payments` */

DROP TABLE IF EXISTS `payments`;

CREATE TABLE `payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `billing_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `payment_method` varchar(255) NOT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `mobile_operator` varchar(255) DEFAULT NULL,
  `reference_number` varchar(255) DEFAULT NULL,
  `payment_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payments_billing_id_foreign` (`billing_id`),
  CONSTRAINT `payments_billing_id_foreign` FOREIGN KEY (`billing_id`) REFERENCES `billings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `payments` */

insert  into `payments`(`id`,`billing_id`,`amount`,`payment_method`,`bank_name`,`mobile_operator`,`reference_number`,`payment_date`,`created_at`,`updated_at`) values (1,3,'200.00','cash',NULL,NULL,'wawwar','2025-12-18 09:10:23','2025-12-18 09:10:23','2025-12-18 09:10:23'),(2,2,'10.00','bank','NMB',NULL,'323213','2025-12-18 10:53:30','2025-12-18 10:53:30','2025-12-18 10:53:30'),(3,2,'5.00','cash',NULL,NULL,'uuu','2025-12-18 11:04:07','2025-12-18 11:04:07','2025-12-18 11:04:07');

/*Table structure for table `rooms` */

DROP TABLE IF EXISTS `rooms`;

CREATE TABLE `rooms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `room_number` varchar(255) DEFAULT NULL,
  `room_category` enum('single','double','apartment','conference') DEFAULT NULL,
  `conference_capacity` int(10) unsigned DEFAULT NULL,
  `description` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `pricing_unit` enum('night','session','day') NOT NULL DEFAULT 'night',
  `images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`images`)),
  `amenities` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`amenities`)),
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rooms_created_by_foreign` (`created_by`),
  CONSTRAINT `rooms_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `rooms` */

insert  into `rooms`(`id`,`name`,`room_number`,`room_category`,`conference_capacity`,`description`,`price`,`pricing_unit`,`images`,`amenities`,`status`,`created_at`,`updated_at`,`created_by`) values (1,'Mountain View Room',NULL,NULL,NULL,'Direct views of Kilimanjaro with private balcony and en-suite bathroom.','120.00','night','[\"https://images.unsplash.com/photo-1582582621959-48d27397dc69?ixlib=rb-4.0.3&auto=format&fit=crop&w=800&q=80\"]',NULL,'pending','2025-12-15 07:43:08','2025-12-15 07:43:08',NULL),(2,'Adventure Suite',NULL,NULL,NULL,'Spacious suite perfect for couples or solo adventurers with sitting area.','150.00','night','[\"https://images.unsplash.com/photo-1566665797739-1674de7a421a?ixlib=rb-4.0.3&auto=format&fit=crop&w=800&q=80\"]',NULL,'pending','2025-12-15 07:43:08','2025-12-15 07:43:08',NULL),(3,'Explorer\'s Lodge',NULL,NULL,NULL,'Cozy and affordable accommodation with shared lounge access.','90.00','night','[\"https://images.unsplash.com/photo-1522708323590-d24dbb6b0267?ixlib=rb-4.0.3&auto=format&fit=crop&w=800&q=80\"]',NULL,'pending','2025-12-15 07:43:08','2025-12-15 07:43:08',NULL),(4,'Wildlife View Room',NULL,NULL,NULL,'Cozy and affordable accommodation with shared lounge access.','90.00','night','[\"https://images.unsplash.com/photo-1522708323590-d24dbb6b0267?ixlib=rb-4.0.3&auto=format&fit=crop&w=800&q=80\"]',NULL,'pending','2025-12-15 07:43:08','2025-12-15 07:43:08',NULL),(5,'Kilimanjaro Suite',NULL,NULL,NULL,'Direct views of Kilimanjaro with private balcony and en-suite bathroom.','120.00','night','[\"https://images.unsplash.com/photo-1582582621959-48d27397dc69?ixlib=rb-4.0.3&auto=format&fit=crop&w=800&q=80\"]',NULL,'pending','2025-12-15 07:43:08','2025-12-15 07:43:08',NULL),(6,'Mountain View','100','apartment',NULL,'Direct views of Kilimanjaro with private balcony and en-suite bathroom.','120.00','night','[\"uploads\\/rooms\\/room_69dcaccd08faf1.39017741.png\",\"uploads\\/rooms\\/room_69dcace93d0148.65521512.jpeg\"]','[\"breakfast\",\"kitchen\"]','approved','2025-12-15 08:13:56','2026-04-13 08:44:25',NULL),(7,'Adventure Suite',NULL,NULL,NULL,'Spacious suite perfect for couples or solo adventurers with sitting area.','150.00','night','[\"https://images.unsplash.com/photo-1566665797739-1674de7a421a?ixlib=rb-4.0.3&auto=format&fit=crop&w=800&q=80\"]',NULL,'approved','2025-12-15 08:13:56','2025-12-17 10:30:25',NULL),(8,'Explorer\'s Lodge',NULL,NULL,NULL,'Cozy and affordable accommodation with shared lounge access.','90.00','night','[\"https://images.unsplash.com/photo-1522708323590-d24dbb6b0267?ixlib=rb-4.0.3&auto=format&fit=crop&w=800&q=80\"]',NULL,'approved','2025-12-15 08:13:56','2025-12-17 10:30:27',NULL),(9,'Wildlife View Room',NULL,NULL,NULL,'Cozy and affordable accommodation with shared lounge access.','90.00','night','[\"https://images.unsplash.com/photo-1522708323590-d24dbb6b0267?ixlib=rb-4.0.3&auto=format&fit=crop&w=800&q=80\"]',NULL,'pending','2025-12-15 08:13:56','2025-12-15 08:13:56',NULL),(10,'Kilimanjaro Suite',NULL,NULL,NULL,'Direct views of Kilimanjaro with private balcony and en-suite bathroom.','120.00','night','[\"https://images.unsplash.com/photo-1582582621959-48d27397dc69?ixlib=rb-4.0.3&auto=format&fit=crop&w=800&q=80\"]',NULL,'pending','2025-12-15 08:13:56','2025-12-15 08:13:56',NULL),(11,'Testing1','101','apartment',NULL,'Testing','10.00','night','[\"rooms\\/nfeaQWdKrcoPj9XA5YMgtw97yH39bCuWJqxf55uL.png\",\"rooms\\/ynAHdg3Y85PLaPjdFFcWJeZMwGdqPGgFiY5QeTQb.png\",\"rooms\\/sq2J5OnJeElvtI9f1vuiEU1RwtdY5yx4BmL04J5U.png\",\"rooms\\/9ElagxgyZJKeEx4YirKKZPbecYoFrMssJRqQKc3k.png\"]','[\"breakfast\",\"wifi\",\"parking\",\"air_conditioning\"]','approved','2025-12-15 09:17:25','2025-12-15 10:36:46',2),(12,'Juma Room','200','single',NULL,'werwqrhhhh\r\njjj','12.00','night','[\"uploads\\/rooms\\/room_69dcaca58f8a64.73823853.png\"]','[\"breakfast\",\"dinner\"]','approved','2025-12-15 10:25:32','2026-04-13 08:43:17',2);

/*Table structure for table `sessions` */

DROP TABLE IF EXISTS `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;

/*Data for the table `sessions` */

insert  into `sessions`(`id`,`user_id`,`ip_address`,`user_agent`,`payload`,`last_activity`) values ('Qhk2zD1MaqRPWn0NxkUG1UM66wFGZhgMusFVj1i5',2,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36 Edg/146.0.0.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOTlIY3N4OVFIdU9ITU5hMWEybHNCMTZndk54amRJejZaQnNsSWwxVCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9ib29raW5nIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Mjt9',1776158914);

/*Table structure for table `testimonials` */

DROP TABLE IF EXISTS `testimonials`;

CREATE TABLE `testimonials` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) NOT NULL,
  `customer_role` varchar(255) DEFAULT NULL,
  `testimonial_content` text NOT NULL,
  `customer_image` varchar(255) DEFAULT NULL,
  `rating` int(11) NOT NULL DEFAULT 5,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `display_order` int(11) NOT NULL DEFAULT 0,
  `approval_status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `testimonials_created_by_foreign` (`created_by`),
  CONSTRAINT `testimonials_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `testimonials` */

insert  into `testimonials`(`id`,`customer_name`,`customer_role`,`testimonial_content`,`customer_image`,`rating`,`is_active`,`display_order`,`approval_status`,`created_at`,`updated_at`,`created_by`) values (2,'August Maxwell','Soluta quia necessit','Sit velit qui deser','uploads/testimonials/testimonial_69dcb53f96af91.36792381.png',5,1,34,'approved','2026-04-13 09:19:59','2026-04-13 09:20:03',2);

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `role` enum('user','superadmin') NOT NULL DEFAULT 'user',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `users` */

insert  into `users`(`id`,`name`,`email`,`role`,`email_verified_at`,`password`,`remember_token`,`created_at`,`updated_at`) values (1,'Test User','test@example.com','user','2025-12-15 08:13:55','$2y$12$Ah1q.2Q7OCmBG.fR/Y9k5eg1wBG6x3jx1U1YqAsF1/G28mvwbYoHy','3JpexwAxe7','2025-12-15 08:13:56','2025-12-15 08:13:56'),(2,'Super Admin','admin@admin','superadmin',NULL,'$2y$12$xUQQoWzgt4HQD2BTAqoLEu3HpJKJC2/uYnB3DQUuiT0TV9dCQGz2.',NULL,'2025-12-15 08:13:56','2026-04-14 08:54:57');