-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: 360homesub
-- ------------------------------------------------------
-- Server version	10.4.32-MariaDB

/*!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 */;

--
-- Table structure for table `amenities`
--

DROP TABLE IF EXISTS `amenities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `amenities` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `amenities`
--

LOCK TABLES `amenities` WRITE;
/*!40000 ALTER TABLE `amenities` DISABLE KEYS */;
/*!40000 ALTER TABLE `amenities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bookings`
--

DROP TABLE IF EXISTS `bookings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bookings` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `property_id` bigint(20) NOT NULL,
  `guest_id` bigint(20) NOT NULL,
  `host_id` bigint(20) NOT NULL,
  `check_in` date NOT NULL,
  `check_out` date NOT NULL,
  `nights` int(11) NOT NULL,
  `adults` int(11) DEFAULT 1,
  `children` int(11) DEFAULT 0,
  `rooms` int(11) DEFAULT 1,
  `rent_amount` decimal(10,2) DEFAULT NULL,
  `caution_fee` decimal(10,2) DEFAULT NULL,
  `service_fee` decimal(10,2) DEFAULT NULL,
  `tax_amount` decimal(10,2) DEFAULT NULL,
  `total_amount` decimal(10,2) DEFAULT NULL,
  `status` enum('pending','approved','rejected','paid') DEFAULT 'pending',
  `rejection_reason` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bookings`
--

LOCK TABLES `bookings` WRITE;
/*!40000 ALTER TABLE `bookings` DISABLE KEYS */;
/*!40000 ALTER TABLE `bookings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kyc`
--

DROP TABLE IF EXISTS `kyc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kyc` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `country` varchar(100) NOT NULL,
  `identity_type` enum('passport','national_id','drivers_license') NOT NULL,
  `id_front` varchar(255) NOT NULL,
  `id_back` varchar(255) NOT NULL,
  `selfie` varchar(255) NOT NULL,
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `admin_note` text DEFAULT NULL,
  `submitted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `kyc_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kyc`
--

LOCK TABLES `kyc` WRITE;
/*!40000 ALTER TABLE `kyc` DISABLE KEYS */;
/*!40000 ALTER TABLE `kyc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sender_id` bigint(20) NOT NULL,
  `receiver_id` bigint(20) NOT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `sender_id` (`sender_id`),
  KEY `receiver_id` (`receiver_id`),
  CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `messages_ibfk_2` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `messages`
--

LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` VALUES (1,2,1,'Hi John, welcome! Let me know if you have any questions about the apartment.',0,'2026-01-27 11:27:49'),(2,1,2,'Thanks Jane! It looks great. I might have a question about parking later.',1,'2026-01-27 11:27:49'),(3,2,1,'No problem, parking is included. Enjoy your stay!',0,'2026-01-27 11:27:49'),(4,2,1,'Just wanted to check if you have settled in well.',0,'2026-01-27 11:27:49'),(5,9,3,'tyujkl\n',0,'2026-02-02 12:16:14');
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notifications` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `message` varchar(255) NOT NULL,
  `is_read` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
INSERT INTO `notifications` VALUES (1,1,'Your booking for \"Luxury Downtown Apartment\" has been confirmed.',0,'2026-01-27 11:27:49'),(2,1,'A new property \"Modern Studio Loft\" is available near you.',0,'2026-01-27 11:27:49'),(3,1,'Welcome to 360 HomeHub! Complete your profile to get started.',1,'2026-01-27 11:27:49'),(4,1,'Your password was changed successfully.',1,'2026-01-27 11:27:49'),(5,1,'You have a new message from Jane Smith.',0,'2026-01-27 11:27:49'),(6,3,'tyhujkl',0,'2026-02-02 12:16:10'),(7,1,'test notifications',0,'2026-02-02 12:18:34'),(8,2,'test notifications',0,'2026-02-02 12:18:34'),(9,3,'test notifications',0,'2026-02-02 12:18:34'),(10,4,'test notifications',0,'2026-02-02 12:18:34'),(11,6,'test notifications',0,'2026-02-02 12:18:34'),(12,8,'test notifications',0,'2026-02-02 12:18:34'),(13,9,'test notifications',0,'2026-02-02 12:18:34'),(14,13,'.dmdd\n',0,'2026-02-02 13:05:03');
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `otps`
--

DROP TABLE IF EXISTS `otps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `otps` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `code` varchar(6) NOT NULL,
  `expires_at` datetime NOT NULL,
  `used` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `otps_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `otps`
--

LOCK TABLES `otps` WRITE;
/*!40000 ALTER TABLE `otps` DISABLE KEYS */;
INSERT INTO `otps` VALUES (2,6,'042458','2026-01-27 12:53:38',0),(3,8,'606322','2026-01-27 12:53:46',0),(4,9,'781961','2026-01-27 13:02:28',1);
/*!40000 ALTER TABLE `otps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `properties`
--

DROP TABLE IF EXISTS `properties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `properties` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `host_id` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `type` enum('apartment','house','studio','duplex','hotel') NOT NULL,
  `space_type` enum('whole','private','shared') NOT NULL,
  `guests_max` int(11) NOT NULL DEFAULT 1,
  `price` decimal(10,2) NOT NULL,
  `price_type` enum('night','week','month') DEFAULT 'night',
  `bedrooms` int(11) NOT NULL,
  `beds` int(11) NOT NULL DEFAULT 1,
  `bathrooms` int(11) NOT NULL,
  `area` int(11) DEFAULT NULL,
  `booking_type` enum('instant','request') DEFAULT 'request',
  `free_cancellation` tinyint(1) DEFAULT 0,
  `amenities` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`amenities`)),
  `address` varchar(255) NOT NULL,
  `apartment_suite` varchar(100) DEFAULT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `zip_code` varchar(20) NOT NULL,
  `country` varchar(100) NOT NULL,
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `onboarding_step` int(11) DEFAULT 1,
  `status` enum('draft','published','archived') DEFAULT 'draft',
  `check_in_time` time DEFAULT NULL,
  `check_out_time` time DEFAULT NULL,
  `pets_allowed` tinyint(1) DEFAULT 0,
  `age_restriction` tinyint(1) DEFAULT 0,
  `smoking_allowed` tinyint(1) DEFAULT 0,
  `extra_rules` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`extra_rules`)),
  `cancellation_policy` enum('flexible','moderate','strict') DEFAULT 'flexible',
  `availability_type` enum('default','manual') DEFAULT 'default',
  `instant_booking` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `host_id` (`host_id`),
  CONSTRAINT `properties_ibfk_1` FOREIGN KEY (`host_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `properties`
--

LOCK TABLES `properties` WRITE;
/*!40000 ALTER TABLE `properties` DISABLE KEYS */;
INSERT INTO `properties` VALUES (1,2,'Luxury Downtown Apartment','A beautiful apartment in the heart of the city, offering stunning views and modern amenities.','apartment','whole',1,250.00,'night',2,1,2,NULL,'instant',1,'[\"wifi\", \"pool\", \"gym\", \"ac\"]','123 Main St',NULL,'New York','NY','10001','USA',40.71380000,-74.00700000,'2026-01-27 11:27:49',1,'published',NULL,NULL,0,0,0,NULL,'flexible','default',0),(2,2,'Cozy Suburban House','A charming house in a quiet suburban neighborhood, perfect for families.','house','whole',1,350.00,'night',4,1,3,NULL,'request',1,'[\"wifi\", \"kitchen\", \"parking\", \"garden\"]','456 Oak Ave',NULL,'White Plains','NY','10601','USA',41.03390000,-73.76290000,'2026-01-27 11:27:49',1,'draft',NULL,NULL,0,0,0,NULL,'flexible','default',0),(3,4,'Modern Studio Loft','A stylish and compact studio in a trendy arts district.','studio','whole',1,150.00,'night',1,1,1,NULL,'instant',0,'[\"wifi\", \"ac\", \"kitchenette\"]','789 Art St',NULL,'Brooklyn','NY','11201','USA',40.69250000,-73.99050000,'2026-01-27 11:27:49',1,'draft',NULL,NULL,0,0,0,NULL,'flexible','default',0),(4,4,'Spacious Duplex with Rooftop','A large duplex with a private rooftop terrace, great for entertaining.','duplex','whole',1,450.00,'night',3,1,2,NULL,'request',1,'[\"wifi\", \"pool\", \"rooftop\", \"ac\"]','101 Sky High Rd',NULL,'New York','NY','10002','USA',40.71450000,-73.99850000,'2026-01-27 11:27:49',1,'draft',NULL,NULL,0,0,0,NULL,'flexible','default',0),(5,2,'Boutique Hotel Room','A private room in a centrally located boutique hotel.','hotel','whole',1,180.00,'night',1,1,1,NULL,'instant',0,'[\"wifi\", \"room_service\", \"gym\"]','212 Central Ave',NULL,'New York','NY','10003','USA',40.73080000,-73.99730000,'2026-01-27 11:27:49',1,'draft',NULL,NULL,0,0,0,NULL,'flexible','default',0);
/*!40000 ALTER TABLE `properties` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `property_amenities`
--

DROP TABLE IF EXISTS `property_amenities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `property_amenities` (
  `property_id` bigint(20) DEFAULT NULL,
  `amenity_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `property_amenities`
--

LOCK TABLES `property_amenities` WRITE;
/*!40000 ALTER TABLE `property_amenities` DISABLE KEYS */;
/*!40000 ALTER TABLE `property_amenities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `property_availability`
--

DROP TABLE IF EXISTS `property_availability`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `property_availability` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `property_id` bigint(20) NOT NULL,
  `date` date NOT NULL,
  `is_available` tinyint(1) DEFAULT 1,
  `price_override` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `property_id` (`property_id`),
  CONSTRAINT `property_availability_ibfk_1` FOREIGN KEY (`property_id`) REFERENCES `properties` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `property_availability`
--

LOCK TABLES `property_availability` WRITE;
/*!40000 ALTER TABLE `property_availability` DISABLE KEYS */;
/*!40000 ALTER TABLE `property_availability` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `property_images`
--

DROP TABLE IF EXISTS `property_images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `property_images` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `property_id` bigint(20) NOT NULL,
  `media_url` varchar(255) NOT NULL,
  `media_type` enum('image','video') DEFAULT 'image',
  `description` varchar(255) DEFAULT NULL,
  `uploaded_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `property_id` (`property_id`),
  CONSTRAINT `property_images_ibfk_1` FOREIGN KEY (`property_id`) REFERENCES `properties` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `property_images`
--

LOCK TABLES `property_images` WRITE;
/*!40000 ALTER TABLE `property_images` DISABLE KEYS */;
INSERT INTO `property_images` VALUES (1,1,'https://source.unsplash.com/random/800x600?apartment,interior','image',NULL,'2026-01-27 11:27:49'),(2,1,'https://source.unsplash.com/random/800x600?apartment,livingroom','image',NULL,'2026-01-27 11:27:49'),(3,2,'https://source.unsplash.com/random/800x600?house,exterior','image',NULL,'2026-01-27 11:27:49'),(4,2,'https://source.unsplash.com/random/800x600?house,kitchen','image',NULL,'2026-01-27 11:27:49'),(5,3,'https://source.unsplash.com/random/800x600?studio,loft','image',NULL,'2026-01-27 11:27:49'),(6,4,'https://source.unsplash.com/random/800x600?duplex,rooftop','image',NULL,'2026-01-27 11:27:49'),(7,5,'https://source.unsplash.com/random/800x600?hotel,room','image',NULL,'2026-01-27 11:27:49');
/*!40000 ALTER TABLE `property_images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `booking_id` bigint(20) DEFAULT NULL,
  `reference` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `gateway` enum('paystack','flutterwave') NOT NULL,
  `status` enum('pending','success','failed') DEFAULT 'pending',
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `reference` (`reference`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions`
--

LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `google_id` varchar(255) DEFAULT NULL,
  `password_hash` varchar(255) NOT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `bio` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `role` enum('guest','host','admin') DEFAULT NULL,
  `auth_provider` enum('email','phone','google') NOT NULL,
  `is_verified` tinyint(1) DEFAULT 0,
  `onboarding_step` enum('otp','password','profile','location','avatar','role','kyc','completed') DEFAULT 'otp',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `phone` (`phone`),
  UNIQUE KEY `google_id` (`google_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'john.doe@example.com',NULL,NULL,'$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi','John','Doe',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'http://example.com/avatars/john.jpg','host','email',1,'completed','2026-01-27 11:27:49'),(2,'jane.smith@example.com',NULL,NULL,'$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi','Jane','Smith',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'http://example.com/avatars/jane.jpg','host','email',1,'completed','2026-01-27 11:27:49'),(3,'admin@example.com',NULL,NULL,'$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi','Admin','User',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'http://example.com/avatars/admin.jpg','admin','email',1,'otp','2026-01-27 11:27:49'),(4,'host.extra@example.com',NULL,NULL,'$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi','Peter','Jones',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'http://example.com/avatars/peter.jpg','host','email',1,'completed','2026-01-27 11:27:49'),(6,'tester@example.com',NULL,NULL,'$2y$10$ErXxuaZ.pZ3UHUp8JFL/le6UNnPV2TREXgvhk5sbCFEPh.RHLlpBe',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'email',0,'otp','2026-01-27 11:48:38'),(8,'tester@example.comk',NULL,NULL,'$2y$10$nDQbBlG237ZNA55ywlprHe.KFVjW3iHwrhW85YkQi7myn6G0XHS0m',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'email',0,'otp','2026-01-27 11:48:46'),(9,'apreezofficial@gmail.com',NULL,NULL,'$2y$10$4sl0a29iA1jqLWGlvJeM5O23tcDbhKcxVQFm5ldYjYH2Sg7PHv5Ua','Precious','Doe','I am a property enthusiast.','123 Main St','Ikeja','Lagos','Nigeria',NULL,NULL,'http://example.com/avatars/peter.jpg','admin','email',0,'completed','2026-01-27 11:57:28'),(13,'apreezofficial@gmail.com.mm','1234r',NULL,'$2y$10$qsP/vm/.I6J.tz9rNS4iYOh.FXcATLBQw2ZMHWqxIDY8fdZHbPH5S','qq','qq',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'guest','email',1,'completed','2026-02-02 13:04:49');
/*!40000 ALTER TABLE `users` 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 */;

-- Dump completed on 2026-02-02  5:37:24