-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `home_ads`
--

-- --------------------------------------------------------

--
-- Table structure for table `ad_promotions`
--

CREATE TABLE IF NOT EXISTS `ad_promotions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `owner_id` int NOT NULL,
  `promoter_id` int NOT NULL,
  `referral_code` varchar(255) NOT NULL,
  `referral_link` varchar(255) NOT NULL,
  `reward_amount` decimal(10,2) DEFAULT '0.00',
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `reward_paid_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`),
  KEY `owner_id` (`owner_id`),
  KEY `promoter_id` (`promoter_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ad_promotions`
--

INSERT INTO `ad_promotions` (`id`, `listing_id`, `owner_id`, `promoter_id`, `referral_code`, `referral_link`, `reward_amount`, `status`, `reward_paid_at`, `created_at`, `updated_at`) VALUES
(1, 14, 1, 1, 'promo_67f6fd131a1405.50795516', 'https://yourwebsite.com/referral.php?code=promo_67f6fd131a1405.50795516', 0.00, '', '2025-05-08 16:40:25', '2025-04-09 23:04:51', '2025-05-19 14:25:57'),
(2, 12, 1, 1, 'promo_67f7181cb2c5d', 'https://yourwebsite.com/referral.php?code=promo_67f7181cb2c5d', 0.00, 'rejected', '2025-04-09 19:04:21', '2025-04-10 01:00:12', '2025-04-10 02:04:21'),
(3, 51, 2, 2, '253b39ac', 'https://www.livioh.com/ads_details.php?ref=253b39ac', 0.00, 'approved', NULL, '2025-06-19 02:25:24', '2025-06-19 05:20:59'),
(4, 75, 2, 2, '60d56787', 'https://www.livioh.com/ads_details.php?ref=60d56787', 0.00, 'approved', NULL, '2025-06-19 02:58:04', '2025-06-19 05:20:59'),
(5, 78, 2, 2, 'b29d2588', 'https://www.livioh.com/public/ads_details.php?id=78&&ref=b29d2588', 0.00, 'approved', NULL, '2025-06-19 03:07:40', '2025-06-19 05:20:59'),
(6, 79, 2, 2, '7967d146', 'https://www.livioh.com/public/ads_details.php?id=79&&ref=7967d146', 0.00, 'pending', NULL, '2025-06-19 05:38:52', '2025-06-19 05:38:52'),
(7, 65, 2, 2, 'cce4d0b7', 'https://www.livioh.com/public/ads_details.php?id=65&&ref=cce4d0b7', 0.00, 'pending', NULL, '2025-06-19 05:39:17', '2025-06-19 05:39:17'),
(8, 59, 1, 2, 'b53143db', 'https://www.livioh.com/public/ads_details.php?id=59&&ref=b53143db', 0.00, 'pending', NULL, '2025-06-19 05:41:17', '2025-06-19 05:41:17'),
(9, 74, 2, 2, '2ff4e128', 'https://www.livioh.com/public/ads_details.php?id=74&&ref=2ff4e128', 0.00, 'pending', NULL, '2025-06-19 05:53:44', '2025-06-19 05:53:44'),
(10, 73, 2, 2, '73ad2ab2', 'https://www.livioh.com/public/ads_details.php?id=73&&ref=73ad2ab2', 0.00, 'pending', NULL, '2025-06-22 21:17:20', '2025-06-22 21:17:20'),
(11, 61, 1, 2, '204c4990', 'https://www.livioh.com/public/ads_details.php?id=61&&ref=204c4990', 0.00, 'pending', NULL, '2025-06-22 21:50:28', '2025-06-22 21:50:28');

-- --------------------------------------------------------

--
-- Table structure for table `agents`
--

CREATE TABLE IF NOT EXISTS `agents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `experience` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `social_links` varchar(500) DEFAULT NULL,
  `preferred_locations` varchar(255) NOT NULL,
  `certification` varchar(500) DEFAULT NULL,
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `applied_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `agents`
--

INSERT INTO `agents` (`id`, `user_id`, `experience`, `title`, `description`, `social_links`, `preferred_locations`, `certification`, `status`, `applied_at`) VALUES
(1, 1, 3, 'Ibrahimi Apartmens', 'xzggh cgjh jjhk', 'fgxghjkk.com', 'ghana', NULL, 'approved', '2025-03-22 16:47:58'),
(2, 1, 7, 'I am a satisfied real estate agent from Ghana', 'I am a satisfied real estate agent from Ghana. i have manage to sell 55 newly build houses to a satisfy customers across the globe. i iam trustworthy and you can ceheck on my review', 'facebook.com', 'ghana', NULL, 'approved', '2025-04-04 17:26:56'),
(3, 2, 21, 'when it comes to a satisfied real estate agent from Ghana. Think of me', 'when it comes to a satisfied real estate agent from Ghana. Think of me. well the quality of of work is there to prove itself and say all the good words about me. Trust is also on another level. Hire me to sell your property.', 'facebook.com', 'ghana', NULL, 'approved', '2025-04-05 21:28:03'),
(4, 4, 12, 'Sell Premiums properties', 'I am a certify real estate agent. I sell a lot of premium property you can contact me if you need to sell your property or if you need to buy one.', 'No social', 'Bimbila', NULL, 'approved', '2025-05-19 00:59:44');

-- --------------------------------------------------------

--
-- Table structure for table `apartments`
--

CREATE TABLE IF NOT EXISTS `apartments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `bedrooms` int NOT NULL,
  `bathrooms` int NOT NULL,
  `furnished` enum('yes','no') NOT NULL,
  `parking_space` enum('yes','no') NOT NULL,
  `balcony` enum('yes','no') NOT NULL,
  `floor_level` varchar(20) NOT NULL,
  `availability` varchar(10) NOT NULL,
  `security_features` varchar(10) NOT NULL,
  `size_sqft` float DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `apartments`
--

INSERT INTO `apartments` (`id`, `listing_id`, `bedrooms`, `bathrooms`, `furnished`, `parking_space`, `balcony`, `floor_level`, `availability`, `security_features`, `size_sqft`) VALUES
(1, 57, 0, 0, '', '', '', '', '', '', NULL),
(2, 58, 5, 2, '', 'yes', 'yes', 'second floor', 'Available', 'cctv', NULL),
(3, 59, 4, 2, '', 'yes', 'yes', '3rd floor', 'Available', 'Gated', NULL),
(4, 60, 3, 3, '', 'yes', 'yes', 'SECOND FLOOR', 'Available', 'CCTV', NULL),
(5, 61, 3, 3, '', 'yes', 'yes', '3 FLOOR', 'Available', 'CCTV', NULL),
(6, 62, 4, 4, '', 'yes', 'yes', '4', 'Available', 'CCTV', NULL),
(7, 63, 4, 4, '', 'yes', 'yes', '4', 'Available', 'CCTV', NULL),
(8, 64, 7, 6, '', 'yes', 'yes', '5', 'Available', 'Gated', NULL),
(9, 65, 6, 5, '', 'yes', 'yes', '6', 'Available', 'cctv', NULL),
(10, 66, 10, 6, '', 'yes', 'yes', '8', 'Available', 'cctv', NULL),
(11, 67, 4, 4, '', 'yes', 'yes', '4', 'Available', 'cctv', NULL),
(12, 68, 4, 4, '', 'yes', 'yes', '4', 'Available', 'cctv', NULL),
(13, 69, 4, 4, '', 'yes', 'yes', '4', 'Available', 'cctv', NULL),
(14, 70, 7, 6, '', 'yes', 'yes', '6', 'Available', 'Gated', NULL),
(15, 71, 5, 7, '', 'yes', 'yes', '5', 'Available', 'gated', NULL),
(16, 72, 4, 4, '', 'yes', 'yes', '5', 'Available', 'ds', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `auction_notifications`
--

CREATE TABLE IF NOT EXISTS `auction_notifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `auction_id` int NOT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `auction_id` (`auction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `auction_payments`
--

CREATE TABLE IF NOT EXISTS `auction_payments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `auction_id` int NOT NULL,
  `winner_id` int NOT NULL,
  `amount_paid` decimal(10,2) NOT NULL,
  `currency` varchar(10) DEFAULT 'USD',
  `payment_method` enum('Flutterwave','Paystack','Stripe') NOT NULL,
  `transaction_id` varchar(100) NOT NULL,
  `status` enum('Pending','Completed','Failed','Refunded') DEFAULT 'Pending',
  `paid_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `auction_id` (`auction_id`),
  KEY `winner_id` (`winner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `auto_bidding`
--

CREATE TABLE IF NOT EXISTS `auto_bidding` (
  `id` int NOT NULL AUTO_INCREMENT,
  `auction_id` int NOT NULL,
  `user_id` int NOT NULL,
  `max_bid_limit` decimal(10,2) NOT NULL,
  `current_highest_bid` decimal(10,2) DEFAULT '0.00',
  `enabled` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `auction_id` (`auction_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bids`
--

CREATE TABLE IF NOT EXISTS `bids` (
  `id` int NOT NULL AUTO_INCREMENT,
  `auction_id` int NOT NULL,
  `bidder_id` int NOT NULL,
  `bid_amount` decimal(10,2) NOT NULL,
  `bid_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `is_auto_bid` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `auction_id` (`auction_id`),
  KEY `bidder_id` (`bidder_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `bids`
--

INSERT INTO `bids` (`id`, `auction_id`, `bidder_id`, `bid_amount`, `bid_time`, `is_auto_bid`) VALUES
(1, 1, 1, 55345.00, '2025-03-29 00:09:14', 0),
(2, 1, 1, 2176.00, '2025-03-29 00:16:16', 0),
(3, 1, 2, 53536362.00, '2025-04-04 19:19:05', 0),
(4, 1, 2, 99999999.99, '2025-04-04 19:19:40', 0),
(5, 1, 2, 5636.00, '2025-04-04 19:33:23', 0),
(6, 1, 2, 99999999.99, '2025-04-04 20:08:28', 0),
(7, 1, 2, 99999999.99, '2025-04-04 20:12:21', 0),
(8, 1, 2, 99999999.99, '2025-04-04 20:16:51', 0),
(9, 1, 2, 99999999.99, '2025-04-04 20:18:06', 0),
(10, 1, 2, 99999999.99, '2025-04-04 20:28:14', 0),
(11, 1, 2, 99999999.99, '2025-04-04 20:42:48', 0),
(12, 1, 2, 99999999.99, '2025-04-04 21:08:34', 0),
(13, 1, 2, 99999999.99, '2025-04-04 22:48:46', 0),
(14, 1, 2, 99999999.99, '2025-04-04 23:33:12', 0),
(15, 1, 2, 99999999.99, '2025-04-04 23:46:36', 0),
(16, 1, 1, 99999999.99, '2025-04-05 00:28:52', 0),
(17, 1, 1, 99999999.99, '2025-04-05 00:29:30', 0),
(18, 1, 1, 99999999.99, '2025-05-01 15:24:00', 0),
(19, 1, 1, 99999999.99, '2025-05-01 15:24:00', 0),
(20, 1, 1, 99999999.99, '2025-05-19 16:52:30', 0),
(21, 2, 1, 23230.00, '2025-05-19 17:49:05', 0),
(22, 4, 1, 7866.00, '2025-05-19 18:29:38', 0);

-- --------------------------------------------------------

--
-- Table structure for table `contacts`
--

CREATE TABLE IF NOT EXISTS `contacts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `full_name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `subject` varchar(150) DEFAULT NULL,
  `message` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `full_name`, `email`, `subject`, `message`, `created_at`) VALUES
(1, 'andani', 'andaniabdulai1@gmail.com', 'No query just a test', 'no message ', '2025-05-10 13:04:16');

-- --------------------------------------------------------

--
-- Table structure for table `escrow_mappings`
--

CREATE TABLE IF NOT EXISTS `escrow_mappings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `internal_transaction_id` int NOT NULL,
  `escrow_transaction_id` varchar(100) NOT NULL,
  `escrow_status` varchar(50) DEFAULT NULL,
  `last_synced_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `escrow_transaction_id_unique` (`escrow_transaction_id`),
  KEY `internal_transaction_idx` (`internal_transaction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `escrow_webhook_logs`
--

CREATE TABLE IF NOT EXISTS `escrow_webhook_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `escrow_transaction_id` varchar(100) DEFAULT NULL,
  `payload` text,
  `received_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hotels`
--

CREATE TABLE IF NOT EXISTS `hotels` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `room_types` enum('single','double','suite','family') NOT NULL,
  `wifi_available` enum('yes','no') NOT NULL,
  `breakfast_included` enum('yes','no') NOT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `houses`
--

CREATE TABLE IF NOT EXISTS `houses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `bedrooms` int NOT NULL,
  `bathrooms` int NOT NULL,
  `floors` int NOT NULL,
  `furnishing` varchar(50) NOT NULL,
  `year_built` year NOT NULL,
  `parking` varchar(100) DEFAULT NULL,
  `garden` enum('Yes','No') NOT NULL,
  `availability` enum('Available','Occupied','Under Construction') NOT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `houses`
--

INSERT INTO `houses` (`id`, `listing_id`, `bedrooms`, `bathrooms`, `floors`, `furnishing`, `year_built`, `parking`, `garden`, `availability`) VALUES
(6, 78, 5, 6, 4, 'Fully Furnished', '0000', 'yes', 'Yes', 'Available');

-- --------------------------------------------------------

--
-- Table structure for table `lands`
--

CREATE TABLE IF NOT EXISTS `lands` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `land_size` decimal(10,2) NOT NULL,
  `land_type` enum('residential','commercial','agricultural') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `road_access` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `utilities` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `land_title_type` varchar(9) DEFAULT NULL,
  `survey_plan` varchar(3) DEFAULT NULL,
  `topography` varchar(7) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lands`
--

INSERT INTO `lands` (`id`, `listing_id`, `land_size`, `land_type`, `road_access`, `utilities`, `land_title_type`, `survey_plan`, `topography`) VALUES
(1, 73, 0.00, 'commercial', '0', '0', '0', '0', '0');

-- --------------------------------------------------------

--
-- Table structure for table `likes`
--

CREATE TABLE IF NOT EXISTS `likes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `listing_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `likes`
--

INSERT INTO `likes` (`id`, `user_id`, `listing_id`, `created_at`) VALUES
(24, 2, 73, '2025-05-31 02:08:28'),
(22, 1, 12, '2025-04-09 22:03:35'),
(18, 1, 11, '2025-04-09 00:25:37'),
(23, 1, 14, '2025-04-10 12:56:26');

-- --------------------------------------------------------

--
-- Table structure for table `listings`
--

CREATE TABLE IF NOT EXISTS `listings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `title` varchar(50) NOT NULL,
  `description` text,
  `price` decimal(10,2) NOT NULL,
  `address` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `country` varchar(100) NOT NULL,
  `city` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `category` enum('House','Apartment','Land','Office','Store','Room') NOT NULL,
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  `negotiable` varchar(16) DEFAULT 'Negotiable',
  `status` enum('Available','Sold','Rented') DEFAULT 'Available',
  `listing_expiry` date DEFAULT NULL,
  `upload_status` enum('Draft','Published') DEFAULT 'Draft',
  `allow_promotion` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'Yes',
  `listed_for` varchar(4) DEFAULT NULL,
  `payment_plan` varchar(12) NOT NULL,
  `payment_status` enum('pending','paid','failed') DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `listings`
--

INSERT INTO `listings` (`id`, `user_id`, `title`, `description`, `price`, `address`, `country`, `city`, `category`, `latitude`, `longitude`, `negotiable`, `status`, `listing_expiry`, `upload_status`, `allow_promotion`, `listed_for`, `payment_plan`, `payment_status`, `created_at`) VALUES
(10, 2, 'Town House apartment', 'A laxerious apartment anyone can ever dream to aquire. siren inveroment that promise quality living and happy life', 340000.00, 'Accra - Cantonment', 'Ghana', 'Tamale', 'Apartment', 99.99999999, 999.99999999, '1', 'Available', '2025-04-05', 'Published', 'allow', 'sale', '', 'pending', '2025-03-09 04:25:38'),
(11, 1, 'The Horrizon Tower', 'The Horrizon Tower is the best building at airport residential, The location matter and not to talk about it beauty and standard of living it provide for its dwellers. modern achitecture with master plan', 650000.00, 'Accra - Airport Residential', 'Ghana', 'Accra', 'House', 5.55450000, -0.19020000, '1', 'Available', '2025-04-05', 'Draft', 'allow', 'sale', '', 'pending', '2025-03-09 05:13:17'),
(12, 1, 'Town House apartment', 'chvmv jvuj', 442355.00, 'dxbcgj nbjhbk', 'Ghana', '', 'Apartment', 5.55450000, -0.19020000, '0', 'Rented', NULL, 'Published', 'allow', 'sale', '', 'pending', '2025-03-16 21:09:08'),
(13, 1, 'Andani valley tower', 'The valley tower is the number one best laxerious tower in Ghana design to accommodate dignitries. We are open for rent sales welcome to heaven on earth.', 544636.00, 'Osu oxford street', 'Ghana', '', 'Office', NULL, NULL, '1', 'Available', NULL, 'Draft', 'allow', 'rent', '', 'pending', '2025-03-16 21:30:52'),
(14, 1, 'Ibrahimi Apartmens', 'Ibrahimi Apartmens is the best luxerous appartment in nigeria we welcome everyone from around the world. What are you looking for all is in one package for at Ibrahimi Apartmens', 70000.00, 'Number 12 up eridiwa benicity', 'Nageria', '', 'Apartment', NULL, NULL, '0', 'Available', NULL, 'Published', 'allow', 'rent', '', 'pending', '2025-03-19 21:39:55'),
(49, 2, 'I am a satisfied real estate agent from Ghana', '', 55.00, '', 'Afghanistan', 'Bimbilla', 'Office', NULL, 999.99999999, 'Negotiable', 'Available', NULL, 'Published', 'allow', 'sale', '', 'pending', '2025-04-13 21:43:26'),
(50, 2, 'I am a satisfied real estate agent from Ghana', '', 55.00, '', 'Afghanistan', 'Bimbilla', 'Store', NULL, 999.99999999, 'Negotiable', 'Available', NULL, 'Published', 'allow', 'rent', '', 'pending', '2025-04-13 21:43:27'),
(51, 2, 'I am a satisfied real estate agent from Ghana', '', 55.00, '', 'Afghanistan', 'Bimbilla', 'Room', NULL, 999.99999999, 'Negotiable', 'Available', NULL, 'Published', 'allow', 'sale', '', 'pending', '2025-04-13 21:43:27'),
(52, 2, 'I am a satisfied real estate agent from Ghana', '', 55.00, '', 'Afghanistan', 'Bimbilla', 'House', NULL, 999.99999999, 'Negotiable', 'Available', NULL, 'Published', 'allow', 'rent', '', 'pending', '2025-04-13 21:43:28'),
(58, 1, 'uuuuuu', 'uuuuu', 34543.00, 'bjh', 'Afghanistan', 'hhghh', 'Apartment', 99.99999999, 677.00000000, 'Negotiable', 'Available', NULL, 'Draft', 'allow', 'sale', '', 'pending', '2025-05-17 10:33:56'),
(59, 1, 'AY Apartmants', 'AY apartments unit one ready for rent', 2323.00, 'ede dcdc', 'Afghanistan', 'Accra', 'Apartment', 99.99999999, 999.99999999, 'None Negotiable', 'Available', NULL, 'Published', 'allow', 'rent', '', 'paid', '2025-05-17 14:15:48'),
(61, 1, '3 acres of land DF property', 'FVC BF', 2322.00, 'BGFD', 'Tunisia', 'DCX', 'Land', 99.99999999, 443.00000000, 'Negotiable', 'Available', NULL, 'Draft', 'allow', 'rent', '', 'pending', '2025-05-17 18:30:11'),
(62, 2, 'EE base 2 apartments', 'cdcssd', 40000.00, 'ewew edeedd 342', 'Afghanistan', 'Accra', 'Apartment', NULL, NULL, 'Negotiable', 'Available', NULL, 'Published', 'allow', 'rent', 'installment', 'pending', '2025-05-30 12:54:01'),
(63, 2, 'Rebby lanes apartments', 'cdcssd', 40000.00, 'ewew edeedd 342', 'Afghanistan', 'Accra', 'Apartment', NULL, NULL, 'Negotiable', 'Available', NULL, 'Published', 'allow', 'rent', 'installment', 'pending', '2025-05-30 13:06:05'),
(64, 2, 'Mr Telson Apartments', 'ddfsds dvvdf', 43422.00, 'aad dfsd', 'Afghanistan', 'Accra', 'Apartment', NULL, NULL, 'Negotiable', 'Available', NULL, 'Published', 'allow', 'rent', 'outright', 'pending', '2025-05-30 13:08:02'),
(65, 2, 'New build', 'wheh hbdh dbjd cvf', 4542.00, 'dd dfrfe r', 'Afghanistan', 'Accra', 'Apartment', NULL, NULL, 'Negotiable', 'Available', NULL, 'Published', 'allow', 'rent', 'outright', 'pending', '2025-05-30 13:38:42'),
(66, 2, 'Days appartments', 'fdhe djfief kfje', 323.00, 'efdffg', 'Afghanistan', 'Accra', 'Apartment', NULL, NULL, 'Negotiable', 'Available', NULL, 'Published', 'allow', 'rent', 'installment', 'pending', '2025-05-30 13:53:29'),
(73, 2, 'Pelsons', 'sds', 344.00, 'fdfs', 'Afghanistan', 'Accra', 'Land', NULL, NULL, 'Negotiable', 'Available', NULL, 'Published', 'allow', 'sale', '0', 'pending', '2025-05-31 02:06:12'),
(74, 2, 'xx', 'edwd', 322.00, 'scsc', '', 'cc', 'Room', NULL, NULL, 'Negotiable', 'Available', NULL, 'Published', 'allow', 'rent', '0', 'pending', '2025-05-31 03:24:44'),
(75, 2, 'ffdc', 'xscx', 343.00, 'sf', 'Afghanistan', 'cd', 'Office', NULL, NULL, 'Negotiable', 'Available', NULL, 'Draft', 'allow', 'sale', '0', 'pending', '2025-05-31 10:44:59'),
(76, 2, 'xsxs', 'scs', 3232.00, 'fsdf', 'Afghanistan', 'dsd', 'House', NULL, NULL, 'Negotiable', 'Available', NULL, 'Draft', 'allow', 'rent', '0', 'pending', '2025-05-31 11:24:58'),
(77, 2, 'dfdv', 'fdff', 3433.00, 'vxdd', 'Åland Islands', 'xc', 'House', NULL, NULL, 'Negotiable', 'Available', NULL, 'Draft', 'allow', 'rent', '0', 'pending', '2025-05-31 11:33:31'),
(78, 2, 'cc', 'cxcc', 343.00, 'fvd', 'Afghanistan', 'dcx', 'House', NULL, NULL, 'Negotiable', 'Available', NULL, 'Draft', 'allow', 'rent', '0', 'pending', '2025-05-31 11:43:59'),
(79, 2, 'b', 'bb', 453.00, 'dcd', 'Afghanistan', 'vc', 'Office', NULL, NULL, 'Negotiable', 'Available', NULL, 'Draft', 'allow', 'sale', '0', 'pending', '2025-05-31 15:42:54');

-- --------------------------------------------------------

--
-- Table structure for table `listing_3d_assets`
--

CREATE TABLE IF NOT EXISTS `listing_3d_assets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `file_url` varchar(255) NOT NULL,
  `file_type` enum('3d_model','panorama','video') NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `listing_3d_assets`
--

INSERT INTO `listing_3d_assets` (`id`, `listing_id`, `file_url`, `file_type`, `created_at`) VALUES
(2, 14, '3d_models/1743056601_download (10).jpg', 'panorama', '2025-03-27 06:23:22'),
(3, 14, '3d_models/1743056947_download (3).jpg', 'panorama', '2025-03-27 06:29:07'),
(4, 14, '3d_models/1743057301_7578550-uhd_3840_2160_30fps.mp4', 'video', '2025-03-27 06:35:01');

-- --------------------------------------------------------

--
-- Table structure for table `listing_images`
--

CREATE TABLE IF NOT EXISTS `listing_images` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `uploaded_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=259 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `listing_images`
--

INSERT INTO `listing_images` (`id`, `listing_id`, `image_path`, `uploaded_at`) VALUES
(1, 7, 'uploads/images/b1.jpg', '2025-03-09 00:06:40'),
(2, 7, 'uploads/images/b3.jpg', '2025-03-09 00:06:40'),
(3, 7, 'uploads/images/b4.jpg', '2025-03-09 00:06:40'),
(4, 7, 'uploads/images/b5.jpg', '2025-03-09 00:06:40'),
(5, 8, 'uploads/imagesdownload.jpg', '2025-03-09 00:28:22'),
(6, 8, 'uploads/imagesFB_IMG_1682813827207.jpg', '2025-03-09 00:28:22'),
(7, 8, 'uploads/imagesFB_IMG_1683325255220.jpg', '2025-03-09 00:28:22'),
(8, 9, 'uploads/images/FB_IMG_1683326749384.jpg', '2025-03-09 00:49:33'),
(9, 9, 'uploads/images/FB_IMG_16831627666780853.jpg', '2025-03-09 00:49:33'),
(10, 9, 'uploads/images/FB_IMG_16831628324548298.jpg', '2025-03-09 00:49:33'),
(11, 9, 'uploads/images/FB_IMG_16834158151593879.jpg', '2025-03-09 00:49:33'),
(12, 10, 'uploads/images/download.jpg', '2025-03-09 04:25:38'),
(13, 10, 'uploads/images/FB_IMG_1682813827207.jpg', '2025-03-09 04:25:38'),
(14, 10, 'uploads/images/FB_IMG_1683325255220.jpg', '2025-03-09 04:25:38'),
(15, 10, 'uploads/images/FB_IMG_16831627666780853.jpg', '2025-03-09 04:25:38'),
(16, 10, 'uploads/images/FB_IMG_16831628324548298.jpg', '2025-03-09 04:25:38'),
(17, 10, 'uploads/images/FB_IMG_16834158151593879.jpg', '2025-03-09 04:25:38'),
(18, 11, 'uploads/images/download (2).jpg', '2025-03-09 05:13:17'),
(19, 11, 'uploads/images/download (3).jpg', '2025-03-09 05:13:17'),
(20, 11, 'uploads/images/download (4).jpg', '2025-03-09 05:13:17'),
(21, 11, 'uploads/images/download (6).jpg', '2025-03-09 05:13:17'),
(22, 11, 'uploads/images/download (7).jpg', '2025-03-09 05:13:17'),
(23, 11, 'uploads/images/download (8).jpg', '2025-03-09 05:13:17'),
(24, 12, 'uploads/images/b1.jpg', '2025-03-16 21:09:08'),
(25, 12, 'uploads/images/b3.jpg', '2025-03-16 21:09:08'),
(26, 12, 'uploads/images/b4.jpg', '2025-03-16 21:09:08'),
(27, 12, 'uploads/images/b5.jpg', '2025-03-16 21:09:08'),
(28, 13, 'uploads/images/download (5).jpg', '2025-03-16 21:30:52'),
(29, 13, 'uploads/images/download (6).jpg', '2025-03-16 21:30:52'),
(30, 13, 'uploads/images/download (7).jpg', '2025-03-16 21:30:52'),
(31, 13, 'uploads/images/download (8).jpg', '2025-03-16 21:30:52'),
(32, 14, 'uploads/images/OIP (12).jpg', '2025-03-19 21:39:55'),
(33, 14, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:26'),
(34, 14, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:26'),
(35, 14, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:26'),
(36, 15, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:27'),
(37, 15, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:27'),
(38, 15, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:27'),
(39, 15, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:27'),
(40, 16, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:29'),
(41, 16, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:29'),
(42, 16, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:29'),
(43, 16, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:29'),
(44, 17, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:31'),
(45, 17, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:31'),
(46, 17, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:31'),
(47, 17, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:31'),
(48, 18, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:31'),
(49, 18, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:31'),
(50, 18, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:31'),
(51, 18, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:31'),
(52, 19, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:33'),
(53, 19, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:33'),
(54, 19, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:33'),
(55, 19, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:33'),
(56, 20, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:33'),
(57, 20, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:33'),
(58, 20, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:33'),
(59, 20, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:33'),
(60, 21, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:33'),
(61, 21, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:33'),
(62, 21, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:33'),
(63, 21, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:33'),
(64, 22, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:34'),
(65, 22, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:34'),
(66, 22, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:34'),
(67, 22, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:34'),
(68, 23, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:34'),
(69, 23, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:34'),
(70, 23, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:34'),
(71, 23, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:34'),
(72, 24, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:34'),
(73, 24, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:34'),
(74, 24, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:34'),
(75, 24, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:34'),
(76, 25, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:34'),
(77, 25, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:34'),
(78, 25, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:34'),
(79, 25, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:34'),
(80, 26, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:34'),
(81, 26, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:34'),
(82, 26, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:34'),
(83, 26, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:34'),
(84, 27, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:34'),
(85, 27, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:34'),
(86, 27, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:34'),
(87, 27, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:34'),
(88, 28, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:34'),
(89, 28, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:34'),
(90, 28, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:34'),
(91, 28, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:34'),
(92, 29, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:35'),
(93, 29, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:35'),
(94, 29, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:35'),
(95, 29, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:35'),
(96, 30, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:35'),
(97, 30, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:35'),
(98, 30, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:35'),
(99, 30, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:35'),
(100, 31, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:35'),
(101, 31, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:35'),
(102, 31, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:35'),
(103, 31, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:35'),
(104, 32, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:35'),
(105, 32, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:35'),
(106, 32, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:35'),
(107, 32, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:35'),
(108, 33, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:35'),
(109, 33, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:35'),
(110, 33, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:35'),
(111, 33, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:35'),
(112, 34, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:35'),
(113, 34, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:35'),
(114, 34, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:35'),
(115, 34, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:35'),
(116, 35, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:35'),
(117, 35, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:35'),
(118, 35, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:35'),
(119, 35, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:35'),
(120, 36, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:35'),
(121, 36, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:35'),
(122, 36, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:35'),
(123, 36, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:35'),
(124, 37, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:35'),
(125, 37, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:35'),
(126, 37, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:35'),
(127, 37, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:35'),
(128, 38, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:35'),
(129, 38, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:35'),
(130, 38, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:35'),
(131, 38, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:35'),
(132, 39, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:36'),
(133, 39, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:36'),
(134, 39, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:36'),
(135, 39, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:36'),
(136, 40, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:36'),
(137, 40, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:36'),
(138, 40, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:36'),
(139, 40, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:36'),
(140, 41, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:36'),
(141, 41, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:36'),
(142, 41, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:36'),
(143, 41, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:36'),
(144, 42, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:36'),
(145, 42, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:36'),
(146, 42, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:36'),
(147, 42, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:36'),
(148, 43, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:36'),
(149, 43, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:36'),
(150, 43, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:36'),
(151, 43, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:36'),
(152, 44, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:36'),
(153, 44, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:36'),
(154, 44, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:36'),
(155, 44, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:36'),
(156, 45, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:36'),
(157, 45, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:36'),
(158, 45, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:36'),
(159, 45, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:36'),
(160, 46, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:36'),
(161, 46, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:36'),
(162, 46, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:36'),
(163, 46, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:36'),
(164, 47, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:37'),
(165, 47, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:37'),
(166, 47, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:37'),
(167, 47, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:37'),
(168, 48, 'uploads/images/OIP (12).jpg', '2025-03-19 21:40:37'),
(169, 48, 'uploads/images/OIP (13).jpg', '2025-03-19 21:40:37'),
(170, 48, 'uploads/images/OIP (14).jpg', '2025-03-19 21:40:37'),
(171, 48, 'uploads/images/OIP (15).jpg', '2025-03-19 21:40:37'),
(172, 49, 'uploads/images/67fc2ffeee47f.jpg', '2025-04-13 21:43:26'),
(173, 49, 'uploads/images/67fc2fff12410.jpg', '2025-04-13 21:43:27'),
(174, 49, 'uploads/images/67fc2fff12ce4.jpg', '2025-04-13 21:43:27'),
(175, 49, 'uploads/images/67fc2fff135cb.jpg', '2025-04-13 21:43:27'),
(176, 50, 'uploads/images/67fc2fff406ef.jpg', '2025-04-13 21:43:27'),
(177, 50, 'uploads/images/67fc2fff4106f.jpg', '2025-04-13 21:43:27'),
(178, 50, 'uploads/images/67fc2fff418bb.jpg', '2025-04-13 21:43:27'),
(179, 50, 'uploads/images/67fc2fff420c2.jpg', '2025-04-13 21:43:27'),
(180, 51, 'uploads/images/67fc30000808f.jpg', '2025-04-13 21:43:28'),
(181, 51, 'uploads/images/67fc300008cb6.jpg', '2025-04-13 21:43:28'),
(182, 51, 'uploads/images/67fc30000d242.jpg', '2025-04-13 21:43:28'),
(183, 51, 'uploads/images/67fc30000dcc2.jpg', '2025-04-13 21:43:28'),
(184, 52, 'uploads/images/67fc300024ed3.jpg', '2025-04-13 21:43:28'),
(185, 52, 'uploads/images/67fc300025e81.jpg', '2025-04-13 21:43:28'),
(186, 52, 'uploads/images/67fc3000265a2.jpg', '2025-04-13 21:43:28'),
(187, 52, 'uploads/images/67fc300026bf0.jpg', '2025-04-13 21:43:28'),
(188, 58, 'uploads/images/6828661543853_OIP (19).jpg', '2025-05-17 10:33:57'),
(189, 58, 'uploads/images/6828661544dfc_OIP (23).jpg', '2025-05-17 10:33:57'),
(190, 58, 'uploads/images/6828661545c93_th (1).jpg', '2025-05-17 10:33:57'),
(191, 58, 'uploads/images/682866154685b_th (5).jpg', '2025-05-17 10:33:57'),
(192, 59, 'uploads/images/68289a145041b_th (3).jpg', '2025-05-17 14:15:48'),
(193, 59, 'uploads/images/68289a1450ffd_th (4).jpg', '2025-05-17 14:15:48'),
(194, 59, 'uploads/images/68289a1451afd_th (5).jpg', '2025-05-17 14:15:48'),
(195, 59, 'uploads/images/68289a14525c2_th (7).jpg', '2025-05-17 14:15:48'),
(196, 59, 'uploads/images/68289a14530e1_th (8).jpg', '2025-05-17 14:15:48'),
(197, 59, 'uploads/images/68289a1453c5b_th (9).jpg', '2025-05-17 14:15:48'),
(198, 61, 'uploads/images/6828d5b3e3053_download (11).jpg', '2025-05-17 18:30:11'),
(199, 61, 'uploads/images/6828d5b3e3e34_download.jpg', '2025-05-17 18:30:11'),
(200, 61, 'uploads/images/6828d5b3e4cb6_OIP (2).jpg', '2025-05-17 18:30:11'),
(201, 61, 'uploads/images/6828d5b3e5ea9_OIP (3).jpg', '2025-05-17 18:30:11'),
(202, 62, 'uploads/images/6839aa69e04de_1748609641_download (9).jpg', '2025-05-30 12:54:01'),
(203, 62, 'uploads/images/6839aa6a177d0_1748609642_download (10).jpg', '2025-05-30 12:54:02'),
(204, 62, 'uploads/images/6839aa6a18755_1748609642_OIF.jpg', '2025-05-30 12:54:02'),
(205, 62, 'uploads/images/6839aa6a27c0e_1748609642_OIP (1).jpg', '2025-05-30 12:54:02'),
(206, 63, 'uploads/images/6839ad3d22254_1748610365_download (9).jpg', '2025-05-30 13:06:05'),
(207, 63, 'uploads/images/6839ad3d23390_1748610365_download (10).jpg', '2025-05-30 13:06:05'),
(208, 63, 'uploads/images/6839ad3d24432_1748610365_OIF.jpg', '2025-05-30 13:06:05'),
(209, 63, 'uploads/images/6839ad3d285a7_1748610365_OIP (1).jpg', '2025-05-30 13:06:05'),
(210, 64, 'uploads/images/6839adb25e744_1748610482_OIP (20).jpg', '2025-05-30 13:08:02'),
(211, 64, 'uploads/images/6839adb25edee_1748610482_OIP (21).jpg', '2025-05-30 13:08:02'),
(212, 64, 'uploads/images/6839adb25f35b_1748610482_OIP (24).jpg', '2025-05-30 13:08:02'),
(213, 64, 'uploads/images/6839adb25f8b3_1748610482_OIP (25).jpg', '2025-05-30 13:08:02'),
(214, 65, 'uploads/images/6839b4e2b4f96_1748612322_OIP (12).jpg', '2025-05-30 13:38:42'),
(215, 65, 'uploads/images/6839b4e2b5cf5_1748612322_OIP (16).jpg', '2025-05-30 13:38:42'),
(216, 65, 'uploads/images/6839b4e2b6c39_1748612322_OIP (20).jpg', '2025-05-30 13:38:42'),
(217, 65, 'uploads/images/6839b4e2b7bf4_1748612322_OIP (24).jpg', '2025-05-30 13:38:42'),
(218, 66, 'uploads/images/6839b85938a0c_1748613209_th (1).jpg', '2025-05-30 13:53:29'),
(219, 66, 'uploads/images/6839b859397f2_1748613209_th (2).jpg', '2025-05-30 13:53:29'),
(220, 66, 'uploads/images/6839b8593a6e1_1748613209_th (5).jpg', '2025-05-30 13:53:29'),
(221, 66, 'uploads/images/6839b8593b367_1748613209_th (6).jpg', '2025-05-30 13:53:29'),
(222, 67, 'uploads/images/img_6839c06a6fcab2.50565030.jpg', '2025-05-30 14:27:54'),
(223, 67, 'uploads/images/img_6839c06a709079.14459651.jpg', '2025-05-30 14:27:54'),
(224, 67, 'uploads/images/img_6839c06a713d39.47380339.jpg', '2025-05-30 14:27:54'),
(225, 67, 'uploads/images/img_6839c06a71dcc7.00643019.jpg', '2025-05-30 14:27:54'),
(226, 68, 'uploads/images/img_6839db218e1423.50360006.jpg', '2025-05-30 16:21:53'),
(227, 68, 'uploads/images/img_6839db218eeb40.24718458.jpg', '2025-05-30 16:21:53'),
(228, 68, 'uploads/images/img_6839db218f7db1.20093637.jpg', '2025-05-30 16:21:53'),
(229, 68, 'uploads/images/img_6839db218ff471.22575323.jpg', '2025-05-30 16:21:53'),
(230, 69, 'uploads/images/img_6839db6f8cf2f7.83650832.jpg', '2025-05-30 16:23:11'),
(231, 69, 'uploads/images/img_6839db6f8d72a9.81516219.jpg', '2025-05-30 16:23:11'),
(232, 69, 'uploads/images/img_6839db6f8dd774.51722892.jpg', '2025-05-30 16:23:11'),
(233, 69, 'uploads/images/img_6839db6f8e3863.10801534.jpg', '2025-05-30 16:23:11'),
(234, 70, 'uploads/images/img_6839e02bdcd2b7.72287899.jpg', '2025-05-30 16:43:23'),
(235, 70, 'uploads/images/img_6839e02bdde4a6.03645693.jpg', '2025-05-30 16:43:23'),
(236, 70, 'uploads/images/img_6839e02bdedcd3.28952776.jpg', '2025-05-30 16:43:23'),
(237, 70, 'uploads/images/img_6839e02bdfc4f2.07695635.jpg', '2025-05-30 16:43:23'),
(238, 71, 'uploads/images/img_6839ed37e91553.38334345.jpg', '2025-05-30 17:39:03'),
(239, 71, 'uploads/images/img_6839ed37e9f588.64022886.jpg', '2025-05-30 17:39:03'),
(240, 71, 'uploads/images/img_6839ed37ea9608.28366061.jpg', '2025-05-30 17:39:03'),
(241, 71, 'uploads/images/img_6839ed37eb4a37.69048482.jpg', '2025-05-30 17:39:03'),
(242, 72, 'uploads/images/img_6839ef8ad7cde6.80665062.jpg', '2025-05-30 17:48:58'),
(243, 72, 'uploads/images/img_6839ef8ad8c149.93199764.jpg', '2025-05-30 17:48:58'),
(244, 72, 'uploads/images/img_6839ef8ada02a4.78206368.jpg', '2025-05-30 17:48:58'),
(245, 73, 'uploads/images/img_683a6414991c17.54931633.jpg', '2025-05-31 02:06:12'),
(246, 73, 'uploads/images/img_683a64149a13e9.99147275.jpg', '2025-05-31 02:06:12'),
(247, 73, 'uploads/images/img_683a64149ad0b4.65033287.jpg', '2025-05-31 02:06:12'),
(248, 74, 'uploads/images/img_683a767cce6d81.47055626.jpg', '2025-05-31 03:24:44'),
(249, 74, 'uploads/images/img_683a767ccf7344.83138025.jpg', '2025-05-31 03:24:44'),
(250, 74, 'uploads/images/img_683a767cd04153.13955534.jpg', '2025-05-31 03:24:44'),
(251, 75, 'uploads/images/img_683addaba5e771.93669543.jpg', '2025-05-31 10:44:59'),
(252, 75, 'uploads/images/img_683addaba6b7b9.64067385.jpg', '2025-05-31 10:44:59'),
(253, 75, 'uploads/images/img_683addaba75a69.44094551.jpg', '2025-05-31 10:44:59'),
(254, 75, 'uploads/images/img_683addaba7e682.40543851.jpg', '2025-05-31 10:44:59'),
(255, 78, 'uploads/images/img_683aeb7f811b00.62053239.jpg', '2025-05-31 11:43:59'),
(256, 78, 'uploads/images/img_683aeb7f81eda8.82918798.jpg', '2025-05-31 11:43:59'),
(257, 78, 'uploads/images/img_683aeb7f8271d9.66049392.jpg', '2025-05-31 11:43:59'),
(258, 79, 'uploads/images/img_683b237ec9d314.57883622.jpg', '2025-05-31 15:42:54');

-- --------------------------------------------------------

--
-- Table structure for table `listing_videos`
--

CREATE TABLE IF NOT EXISTS `listing_videos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `video_path` varchar(255) NOT NULL,
  `uploaded_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `listing_videos`
--

INSERT INTO `listing_videos` (`id`, `listing_id`, `video_path`, `uploaded_at`) VALUES
(1, 9, 'uploads/videos/video_662b95e428e42_1714132452.mp4', '2025-03-09 00:49:33'),
(2, 10, 'uploads/videos/1687022757.mp4', '2025-03-09 04:25:38'),
(3, 11, 'uploads/videos/1687021853.mp4', '2025-03-09 05:13:17'),
(4, 13, 'uploads/videos/1687022757.mp4', '2025-03-16 21:30:52'),
(5, 14, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:26'),
(6, 15, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:27'),
(7, 16, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:30'),
(8, 17, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:31'),
(9, 18, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:32'),
(10, 19, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:33'),
(11, 20, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:33'),
(12, 21, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:33'),
(13, 22, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:34'),
(14, 23, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:34'),
(15, 24, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:34'),
(16, 25, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:34'),
(17, 26, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:34'),
(18, 27, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:34'),
(19, 28, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:34'),
(20, 29, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:35'),
(21, 30, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:35'),
(22, 31, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:35'),
(23, 32, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:35'),
(24, 33, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:35'),
(25, 34, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:35'),
(26, 35, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:35'),
(27, 36, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:35'),
(28, 37, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:35'),
(29, 38, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:35'),
(30, 39, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:36'),
(31, 40, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:36'),
(32, 41, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:36'),
(33, 42, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:36'),
(34, 43, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:36'),
(35, 44, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:36'),
(36, 45, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:36'),
(37, 46, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:36'),
(38, 47, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:37'),
(39, 48, 'uploads/videos/video_662b8aa5db6ae_1714129573.mp4', '2025-03-19 21:40:37'),
(40, 49, 'uploads/videos/67fc2fff146be.mp4', '2025-04-13 21:43:27'),
(41, 50, 'uploads/videos/67fc2fff42a37.mp4', '2025-04-13 21:43:27'),
(42, 51, 'uploads/videos/67fc30000e8b8.mp4', '2025-04-13 21:43:28'),
(43, 52, 'uploads/videos/67fc300027364.mp4', '2025-04-13 21:43:28'),
(44, 58, '../../uploads/videos/682866154765b_1687021853.mp4', '2025-05-17 10:33:57'),
(45, 62, 'uploads/videos/6839aa6a3cd61_1748609642_tumblr_qtvhrdmndb1z2wskb.mp4', '2025-05-30 12:54:02'),
(46, 63, 'uploads/videos/6839ad3d28c66_1748610365_tumblr_qtvhrdmndb1z2wskb.mp4', '2025-05-30 13:06:05'),
(47, 64, 'uploads/videos/6839adb2655f0_1748610482_tumblr_qtvhrdmndb1z2wskb.mp4', '2025-05-30 13:08:02'),
(48, 65, 'uploads/videos/6839b4e2b8993_1748612322_tumblr_qtvhrdmndb1z2wskb.mp4', '2025-05-30 13:38:42'),
(49, 66, 'uploads/videos/6839b8593c1d1_1748613209_tumblr_qtvhrdmndb1z2wskb.mp4', '2025-05-30 13:53:29'),
(50, 67, 'uploads/videos/vid_6839c06a7273a8.60584712.mp4', '2025-05-30 14:27:54'),
(51, 68, 'uploads/videos/vid_6839db21906bb8.36005660.mp4', '2025-05-30 16:21:53'),
(52, 69, 'uploads/videos/vid_6839db6f8ea9c3.32828986.mp4', '2025-05-30 16:23:11'),
(53, 70, 'uploads/videos/vid_6839e02be0af97.37561320.mp4', '2025-05-30 16:43:23'),
(54, 71, 'uploads/videos/vid_6839ed37ebda91.79890006.mp4', '2025-05-30 17:39:03'),
(55, 72, 'uploads/videos/vid_6839ef8adb2755.07815720.mp4', '2025-05-30 17:48:58'),
(56, 73, 'uploads/videos/vid_683a64149b8b33.96319631.mp4', '2025-05-31 02:06:12'),
(57, 74, 'uploads/videos/vid_683a767cd139b6.20524504.mp4', '2025-05-31 03:24:44'),
(58, 75, 'uploads/videos/vid_683addaba85f25.06254632.mp4', '2025-05-31 10:44:59'),
(59, 78, 'uploads/videos/vid_683aeb7f82de83.61508961.mp4', '2025-05-31 11:43:59'),
(60, 79, 'uploads/videos/vid_683b237ecb5df4.93498191.mp4', '2025-05-31 15:42:54');

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sender_id` int NOT NULL,
  `receiver_id` int NOT NULL,
  `message` text NOT NULL,
  `message_type` enum('text','image','video','file') DEFAULT 'text',
  `file_path` varchar(255) DEFAULT NULL,
  `read_status` enum('Read','Unread') DEFAULT 'Unread',
  `sent_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `sender_id` (`sender_id`),
  KEY `receiver_id` (`receiver_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `messages` (`id`, `sender_id`, `receiver_id`, `message`, `message_type`, `file_path`, `read_status`, `sent_at`) VALUES
(1, 1, 2, 'hello', 'text', NULL, 'Read', '2025-03-13 02:42:18'),
(2, 1, 2, 'how much', 'text', NULL, 'Read', '2025-03-13 02:46:56'),
(3, 1, 2, 'to go home now', 'text', NULL, 'Read', '2025-03-13 03:24:20'),
(4, 2, 1, 'gh', 'text', NULL, 'Read', '2025-04-05 22:35:37'),
(5, 2, 1, 'Andani Them: hello  Them: how much  Them: to go home now  You: gh  Type your message... Send', 'text', NULL, 'Read', '2025-04-05 22:37:38'),
(6, 2, 1, 'Andani Them: hello  Them: how much  Them: to go home now  You: gh  Type your message... SendAndani Them: hello  Them: how much  Them: to go home now  You: gh  Type your message... SendAndani Them: hello  Them: how much  Them: to go home now  You: gh  Type your message... Send', 'text', NULL, 'Read', '2025-04-05 22:37:54'),
(7, 2, 1, 'ggss', 'text', NULL, 'Read', '2025-04-05 22:43:51'),
(8, 2, 1, 'bbvb', 'text', NULL, 'Read', '2025-04-05 23:02:27'),
(9, 2, 1, 'Yussif', 'text', NULL, 'Read', '2025-04-05 23:41:12'),
(10, 2, 1, 'ff', 'image', 'chat_images/67f1c22cbf3d2.jpg', 'Read', '2025-04-05 23:52:12'),
(11, 1, 2, 'how much', 'text', NULL, 'Read', '2025-05-10 12:52:13'),
(12, 1, 2, '20000', 'image', 'chat_images/681f4c1e87818.jpg', 'Read', '2025-05-10 12:52:46');

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `notifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `sender_id` int DEFAULT NULL,
  `ad_id` int DEFAULT NULL,
  `type` enum('view','search','like','chat','payment_success','payment_fail','register','publish','expired','other') NOT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `sender_id` (`sender_id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM AUTO_INCREMENT=191 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `notifications` (`id`, `user_id`, `sender_id`, `ad_id`, `type`, `message`, `is_read`, `created_at`) VALUES
(5, 2, 0, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-16 15:30:33'),
(4, 1, 2, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-15 03:24:54'),
(6, 2, 0, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-16 15:30:45'),
(7, 1, 2, 11, 'view', 'Someone viewed your ad: The Horrizon Tower.', 0, '2025-03-16 19:48:31'),
(8, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-19 21:26:01'),
(9, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-19 21:41:03'),
(10, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-19 22:49:52'),
(11, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 22:53:02'),
(12, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 22:55:07'),
(13, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:00:42'),
(14, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:01:18'),
(15, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:02:45'),
(16, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:04:53'),
(17, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:11:31'),
(18, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:13:31'),
(19, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:15:27'),
(20, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:16:24'),
(21, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:18:11'),
(22, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:18:53'),
(23, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:20:54'),
(24, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:22:57'),
(25, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:24:46'),
(26, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:28:42'),
(27, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:29:49'),
(28, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:30:20'),
(29, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:30:21'),
(30, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:30:21'),
(31, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:31:45'),
(32, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:32:53'),
(33, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:34:50'),
(34, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:38:55'),
(35, 1, 3, 47, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-19 23:44:34'),
(36, 1, 3, 48, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-20 00:07:28'),
(37, 1, 3, 48, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-20 00:08:42'),
(38, 1, 3, 48, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-03-20 00:19:05'),
(39, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 01:48:26'),
(40, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 02:07:48'),
(41, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 02:10:25'),
(42, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 02:12:37'),
(43, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 02:20:14'),
(44, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 02:21:29'),
(45, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 02:21:53'),
(46, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:15:56'),
(47, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:16:01'),
(48, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:16:04'),
(49, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:19:53'),
(50, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:21:38'),
(51, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:24:50'),
(52, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:26:05'),
(53, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:28:08'),
(54, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:29:15'),
(55, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:31:57'),
(56, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:44:09'),
(57, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:55:13'),
(58, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:57:39'),
(59, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:57:49'),
(60, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:57:50'),
(61, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:57:51'),
(62, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:57:52'),
(63, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 03:58:35'),
(64, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 11:28:25'),
(65, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 11:28:53'),
(66, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 12:09:38'),
(67, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 12:09:45'),
(68, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 12:27:24'),
(69, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 12:34:55'),
(70, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 12:48:01'),
(71, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 12:58:24'),
(72, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 15:18:21'),
(73, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 15:24:30'),
(74, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 15:25:12'),
(75, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 15:26:34'),
(76, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 15:28:06'),
(77, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 15:28:40'),
(78, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 15:28:46'),
(79, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 15:30:02'),
(80, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 15:33:38'),
(81, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 15:36:58'),
(82, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 15:47:46'),
(83, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 16:01:19'),
(84, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-22 16:02:03'),
(85, 2, 0, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-03-23 12:26:26'),
(86, 1, 2, 14, 'like', 'Someone liked your ad: Ibrahimi Apartmens.', 0, '2025-03-23 14:19:11'),
(87, 1, 2, 11, 'view', 'Someone viewed your ad: The Horrizon Tower.', 0, '2025-03-23 14:23:09'),
(88, 1, 1, 13, 'like', 'Someone liked your ad: Andani valley tower.', 0, '2025-03-24 16:56:12'),
(89, 1, 1, 14, 'like', 'Someone liked your ad: Ibrahimi Apartmens.', 0, '2025-03-24 17:08:38'),
(90, 1, 2, 14, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-04-04 18:25:16'),
(91, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-04-05 14:51:41'),
(92, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-04-05 14:51:55'),
(93, 1, 1, 14, 'like', 'Someone liked your ad: Ibrahimi Apartmens.', 0, '2025-04-07 15:05:22'),
(94, 1, 1, 13, 'like', 'Someone liked your ad: Andani valley tower.', 0, '2025-04-07 15:05:28'),
(95, 2, 1, 10, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-04-07 22:35:26'),
(96, 1, 1, 14, 'like', 'Someone liked your ad: Ibrahimi Apartmens.', 0, '2025-04-08 01:02:19'),
(97, 1, 2, 14, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-04-08 01:09:03'),
(98, 1, 2, 14, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-04-08 01:13:29'),
(99, 1, 2, 14, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-04-08 01:18:25'),
(100, 1, 1, 14, 'like', 'Someone liked your ad: Ibrahimi Apartmens.', 0, '2025-04-08 01:19:38'),
(101, 1, 1, 14, 'like', 'Someone liked your ad: Ibrahimi Apartmens.', 0, '2025-04-08 23:58:38'),
(102, 1, 1, 11, 'like', 'Someone liked your ad: The Horrizon Tower.', 0, '2025-04-09 00:25:37'),
(103, 1, 1, 14, 'like', 'Someone liked your ad: Ibrahimi Apartmens.', 0, '2025-04-09 18:23:42'),
(104, 1, 1, 14, 'like', 'Someone liked your ad: Ibrahimi Apartmens.', 0, '2025-04-09 18:38:49'),
(105, 1, 1, 14, 'like', 'Someone liked your ad: Ibrahimi Apartmens.', 0, '2025-04-09 18:40:36'),
(106, 1, 1, 12, 'like', 'Someone liked your ad: Town House apartment.', 0, '2025-04-09 22:03:35'),
(107, 1, 2, 14, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-04-09 23:18:03'),
(108, 1, 1, 14, 'like', 'Someone liked your ad: Ibrahimi Apartmens.', 0, '2025-04-10 12:56:26'),
(109, 1, 2, 14, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-04-10 21:46:07'),
(110, 1, 2, 14, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-04-10 21:46:46'),
(111, 1, 2, 14, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-04-13 15:47:40'),
(112, 1, 2, 14, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-04-13 15:49:57'),
(113, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-01 15:27:40'),
(114, 2, 1, 51, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-08 10:27:39'),
(115, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-09 18:14:36'),
(116, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 00:32:20'),
(117, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 00:38:49'),
(118, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 00:39:53'),
(119, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 00:41:43'),
(120, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 00:42:23'),
(121, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 00:43:06'),
(122, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 00:49:32'),
(123, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 00:53:06'),
(124, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 00:53:44'),
(125, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 01:03:33'),
(126, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 01:12:38'),
(127, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-10 01:13:39'),
(128, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:20:59'),
(129, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:21:53'),
(130, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:21:56'),
(131, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:21:57'),
(132, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:21:58'),
(133, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:21:59'),
(134, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:21:59'),
(135, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:21:59'),
(136, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:22:00'),
(137, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:22:01'),
(138, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:22:01'),
(139, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:22:01'),
(140, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:22:06'),
(141, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:23:52'),
(142, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:25:13'),
(143, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:25:19'),
(144, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:25:25'),
(145, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:25:30'),
(146, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:25:36'),
(147, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:32:27'),
(148, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:34:02'),
(149, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:34:05'),
(150, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:41:05'),
(151, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:41:10'),
(152, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:41:44'),
(153, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:41:47'),
(154, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:41:53'),
(155, 2, 1, 52, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-12 02:41:57'),
(178, 1, 2, 12, 'view', 'Someone viewed your ad: Town House apartment.', 0, '2025-06-05 02:12:53'),
(179, 1, 2, 58, 'view', 'Someone viewed your ad: uuuuuu.', 0, '2025-06-19 04:08:14'),
(180, 1, 2, 58, 'view', 'Someone viewed your ad: uuuuuu.', 0, '2025-06-19 04:48:49'),
(181, 1, 2, 58, 'view', 'Someone viewed your ad: uuuuuu.', 0, '2025-06-19 04:56:11'),
(182, 1, 2, 59, 'view', 'Someone viewed your ad: AY Apartmants.', 0, '2025-06-19 05:41:14'),
(183, 1, 2, 59, 'view', 'Someone viewed your ad: AY Apartmants.', 0, '2025-06-19 05:41:42'),
(184, 1, 2, 59, 'view', 'Someone viewed your ad: AY Apartmants.', 0, '2025-06-19 05:41:45'),
(185, 1, 2, 59, 'view', 'Someone viewed your ad: AY Apartmants.', 0, '2025-06-19 05:41:59'),
(186, 1, 2, 59, 'view', 'Someone viewed your ad: AY Apartmants.', 0, '2025-06-19 05:42:00'),
(187, 1, 2, 59, 'view', 'Someone viewed your ad: AY Apartmants.', 0, '2025-06-19 05:44:28'),
(165, 1, NULL, NULL, '', 'A customer contacted you via a promoter!', 0, '2025-05-19 14:25:57'),
(166, 2, 1, 50, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-22 02:19:52'),
(167, 2, 1, 50, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-22 02:24:49'),
(168, 2, 1, 50, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-22 02:25:41'),
(169, 2, 1, 50, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-22 02:26:03'),
(170, 2, 1, 50, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-22 02:26:08'),
(171, 2, 1, 50, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-22 02:28:47'),
(172, 2, 1, 50, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-22 02:29:57'),
(173, 2, 1, 50, 'view', 'Someone viewed your ad: I am a satisfied real estate agent from Ghana.', 0, '2025-05-22 02:32:37'),
(176, 1, 2, 14, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-06-04 13:29:37'),
(177, 1, 2, 14, 'view', 'Someone viewed your ad: Ibrahimi Apartmens.', 0, '2025-06-04 13:41:05'),
(188, 1, 2, 59, 'view', 'Someone viewed your ad: AY Apartmants.', 0, '2025-06-19 05:44:32'),
(189, 1, 2, 61, 'view', 'Someone viewed your ad: 3 acres of land DF property.', 0, '2025-06-22 20:53:24'),
(190, 1, 2, 61, 'view', 'Someone viewed your ad: 3 acres of land DF property.', 0, '2025-06-22 21:50:22');

-- --------------------------------------------------------

--
-- Table structure for table `offices`
--

CREATE TABLE IF NOT EXISTS `offices` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `office_type` varchar(100) DEFAULT NULL,
  `office_size` int DEFAULT NULL,
  `rooms` int DEFAULT NULL,
  `floor_level` varchar(100) DEFAULT NULL,
  `furnishing` varchar(100) DEFAULT NULL,
  `internet` varchar(50) DEFAULT NULL,
  `security` text,
  `parking` varchar(10) DEFAULT NULL,
  `conference_room` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `offices`
--

INSERT INTO `offices` (`id`, `listing_id`, `office_type`, `office_size`, `rooms`, `floor_level`, `furnishing`, `internet`, `security`, `parking`, `conference_room`) VALUES
(1, 75, '', 0, 23, '', 'Fully Furnished', 'Available', 'cctv', 'Yes', ''),
(2, 79, 'Open Space', 343, 3, 'dcfd', 'Fully Furnished', 'Available', 'cctv', 'Yes', 'Yes');

-- --------------------------------------------------------

--
-- Table structure for table `payments`
--

CREATE TABLE IF NOT EXISTS `payments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `listing_id` int NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `currency` varchar(10) DEFAULT 'USD',
  `status` enum('Pending','Completed','Failed','Refunded') DEFAULT 'Pending',
  `payment_method` enum('Flutterwave','Paystack','Stripe') NOT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `payment_reference` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_reference` (`payment_reference`),
  UNIQUE KEY `transaction_id` (`transaction_id`),
  KEY `user_id` (`user_id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `payment_logs`
--

CREATE TABLE IF NOT EXISTS `payment_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `payment_id` int NOT NULL,
  `gateway` varchar(50) NOT NULL,
  `response` text NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `payment_id` (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pricing_rules`
--

CREATE TABLE IF NOT EXISTS `pricing_rules` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category` enum('House','Apartment','Land','Office','Store','Room') NOT NULL,
  `listed_for` enum('sale','rent') NOT NULL,
  `duration` enum('1_week','2_weeks','1_month','3_months','6_months','1_year') NOT NULL,
  `price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=185 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `pricing_rules`
--

INSERT INTO `pricing_rules` (`id`, `category`, `listed_for`, `duration`, `price`) VALUES
(1, 'House', 'sale', '1_week', 100.00),
(2, 'House', 'sale', '2_weeks', 150.00),
(3, 'House', 'sale', '1_month', 250.00),
(4, 'House', 'sale', '3_months', 600.00),
(5, 'House', 'sale', '6_months', 1200.00),
(6, 'House', 'sale', '1_year', 2000.00),
(7, 'House', 'rent', '1_week', 50.00),
(8, 'House', 'rent', '2_weeks', 75.00),
(9, 'House', 'rent', '1_month', 125.00),
(10, 'House', 'rent', '3_months', 300.00),
(11, 'House', 'rent', '6_months', 600.00),
(12, 'House', 'rent', '1_year', 1000.00),
(13, 'Apartment', 'sale', '1_week', 80.00),
(14, 'Apartment', 'sale', '1_month', 200.00),
(15, 'Apartment', 'rent', '1_week', 40.00),
(16, 'Apartment', 'rent', '1_month', 100.00),
(17, 'House', 'sale', '1_week', 100.00),
(18, 'House', 'sale', '2_weeks', 150.00),
(19, 'House', 'sale', '1_month', 250.00),
(20, 'House', 'sale', '3_months', 600.00),
(21, 'House', 'sale', '6_months', 1200.00),
(22, 'House', 'sale', '1_year', 2000.00),
(23, 'House', 'rent', '1_week', 50.00),
(24, 'House', 'rent', '2_weeks', 75.00),
(25, 'House', 'rent', '1_month', 125.00),
(26, 'House', 'rent', '3_months', 300.00),
(27, 'House', 'rent', '6_months', 600.00),
(28, 'House', 'rent', '1_year', 1000.00),
(29, 'Apartment', 'sale', '1_week', 80.00),
(30, 'Apartment', 'sale', '2_weeks', 120.00),
(31, 'Apartment', 'sale', '1_month', 200.00),
(32, 'Apartment', 'sale', '3_months', 480.00),
(33, 'Apartment', 'sale', '6_months', 900.00),
(34, 'Apartment', 'sale', '1_year', 1500.00),
(35, 'Apartment', 'rent', '1_week', 40.00),
(36, 'Apartment', 'rent', '2_weeks', 60.00),
(37, 'Apartment', 'rent', '1_month', 100.00),
(38, 'Apartment', 'rent', '3_months', 240.00),
(39, 'Apartment', 'rent', '6_months', 450.00),
(40, 'Apartment', 'rent', '1_year', 800.00),
(41, 'Land', 'sale', '1_week', 70.00),
(42, 'Land', 'sale', '2_weeks', 110.00),
(43, 'Land', 'sale', '1_month', 180.00),
(44, 'Land', 'sale', '3_months', 420.00),
(45, 'Land', 'sale', '6_months', 800.00),
(46, 'Land', 'sale', '1_year', 1500.00),
(47, 'Land', 'rent', '1_week', 35.00),
(48, 'Land', 'rent', '2_weeks', 55.00),
(49, 'Land', 'rent', '1_month', 90.00),
(50, 'Land', 'rent', '3_months', 210.00),
(51, 'Land', 'rent', '6_months', 400.00),
(52, 'Land', 'rent', '1_year', 750.00),
(53, 'Office', 'sale', '1_week', 90.00),
(54, 'Office', 'sale', '2_weeks', 130.00),
(55, 'Office', 'sale', '1_month', 220.00),
(56, 'Office', 'sale', '3_months', 500.00),
(57, 'Office', 'sale', '6_months', 950.00),
(58, 'Office', 'sale', '1_year', 1800.00),
(59, 'Office', 'rent', '1_week', 45.00),
(60, 'Office', 'rent', '2_weeks', 65.00),
(61, 'Office', 'rent', '1_month', 110.00),
(62, 'Office', 'rent', '3_months', 250.00),
(63, 'Office', 'rent', '6_months', 475.00),
(64, 'Office', 'rent', '1_year', 900.00),
(65, 'Store', 'sale', '1_week', 90.00),
(66, 'Store', 'sale', '2_weeks', 130.00),
(67, 'Store', 'sale', '1_month', 220.00),
(68, 'Store', 'sale', '3_months', 500.00),
(69, 'Store', 'sale', '6_months', 950.00),
(70, 'Store', 'sale', '1_year', 1800.00),
(71, 'Store', 'rent', '1_week', 45.00),
(72, 'Store', 'rent', '2_weeks', 65.00),
(73, 'Store', 'rent', '1_month', 110.00),
(74, 'Store', 'rent', '3_months', 250.00),
(75, 'Store', 'rent', '6_months', 475.00),
(76, 'Store', 'rent', '1_year', 900.00),
(77, 'Room', 'sale', '1_week', 60.00),
(78, 'Room', 'sale', '2_weeks', 90.00),
(79, 'Room', 'sale', '1_month', 150.00),
(80, 'Room', 'sale', '3_months', 350.00),
(81, 'Room', 'sale', '6_months', 700.00),
(82, 'Room', 'sale', '1_year', 1200.00),
(83, 'Room', 'rent', '1_week', 30.00),
(84, 'Room', 'rent', '2_weeks', 45.00),
(85, 'Room', 'rent', '1_month', 75.00),
(86, 'Room', 'rent', '3_months', 175.00),
(87, 'Room', 'rent', '6_months', 350.00),
(88, 'Room', 'rent', '1_year', 600.00),
(89, '', 'sale', '1_week', 150.00),
(90, '', 'sale', '2_weeks', 200.00),
(91, '', 'sale', '1_month', 350.00),
(92, '', 'sale', '3_months', 800.00),
(93, '', 'sale', '6_months', 1500.00),
(94, '', 'sale', '1_year', 2500.00),
(95, '', 'rent', '1_week', 75.00),
(96, '', 'rent', '2_weeks', 100.00),
(97, '', 'rent', '1_month', 175.00),
(98, '', 'rent', '3_months', 400.00),
(99, '', 'rent', '6_months', 750.00),
(100, '', 'rent', '1_year', 1250.00),
(101, 'House', 'sale', '1_week', 100.00),
(102, 'House', 'sale', '2_weeks', 150.00),
(103, 'House', 'sale', '1_month', 250.00),
(104, 'House', 'sale', '3_months', 600.00),
(105, 'House', 'sale', '6_months', 1200.00),
(106, 'House', 'sale', '1_year', 2000.00),
(107, 'House', 'rent', '1_week', 50.00),
(108, 'House', 'rent', '2_weeks', 75.00),
(109, 'House', 'rent', '1_month', 125.00),
(110, 'House', 'rent', '3_months', 300.00),
(111, 'House', 'rent', '6_months', 600.00),
(112, 'House', 'rent', '1_year', 1000.00),
(113, 'Apartment', 'sale', '1_week', 80.00),
(114, 'Apartment', 'sale', '2_weeks', 120.00),
(115, 'Apartment', 'sale', '1_month', 200.00),
(116, 'Apartment', 'sale', '3_months', 480.00),
(117, 'Apartment', 'sale', '6_months', 900.00),
(118, 'Apartment', 'sale', '1_year', 1500.00),
(119, 'Apartment', 'rent', '1_week', 40.00),
(120, 'Apartment', 'rent', '2_weeks', 60.00),
(121, 'Apartment', 'rent', '1_month', 100.00),
(122, 'Apartment', 'rent', '3_months', 240.00),
(123, 'Apartment', 'rent', '6_months', 450.00),
(124, 'Apartment', 'rent', '1_year', 800.00),
(125, 'Land', 'sale', '1_week', 70.00),
(126, 'Land', 'sale', '2_weeks', 110.00),
(127, 'Land', 'sale', '1_month', 180.00),
(128, 'Land', 'sale', '3_months', 420.00),
(129, 'Land', 'sale', '6_months', 800.00),
(130, 'Land', 'sale', '1_year', 1500.00),
(131, 'Land', 'rent', '1_week', 35.00),
(132, 'Land', 'rent', '2_weeks', 55.00),
(133, 'Land', 'rent', '1_month', 90.00),
(134, 'Land', 'rent', '3_months', 210.00),
(135, 'Land', 'rent', '6_months', 400.00),
(136, 'Land', 'rent', '1_year', 750.00),
(137, 'Office', 'sale', '1_week', 90.00),
(138, 'Office', 'sale', '2_weeks', 130.00),
(139, 'Office', 'sale', '1_month', 220.00),
(140, 'Office', 'sale', '3_months', 500.00),
(141, 'Office', 'sale', '6_months', 950.00),
(142, 'Office', 'sale', '1_year', 1800.00),
(143, 'Office', 'rent', '1_week', 45.00),
(144, 'Office', 'rent', '2_weeks', 65.00),
(145, 'Office', 'rent', '1_month', 110.00),
(146, 'Office', 'rent', '3_months', 250.00),
(147, 'Office', 'rent', '6_months', 475.00),
(148, 'Office', 'rent', '1_year', 900.00),
(149, 'Store', 'sale', '1_week', 90.00),
(150, 'Store', 'sale', '2_weeks', 130.00),
(151, 'Store', 'sale', '1_month', 220.00),
(152, 'Store', 'sale', '3_months', 500.00),
(153, 'Store', 'sale', '6_months', 950.00),
(154, 'Store', 'sale', '1_year', 1800.00),
(155, 'Store', 'rent', '1_week', 45.00),
(156, 'Store', 'rent', '2_weeks', 65.00),
(157, 'Store', 'rent', '1_month', 110.00),
(158, 'Store', 'rent', '3_months', 250.00),
(159, 'Store', 'rent', '6_months', 475.00),
(160, 'Store', 'rent', '1_year', 900.00),
(161, 'Room', 'sale', '1_week', 60.00),
(162, 'Room', 'sale', '2_weeks', 90.00),
(163, 'Room', 'sale', '1_month', 150.00),
(164, 'Room', 'sale', '3_months', 350.00),
(165, 'Room', 'sale', '6_months', 700.00),
(166, 'Room', 'sale', '1_year', 1200.00),
(167, 'Room', 'rent', '1_week', 30.00),
(168, 'Room', 'rent', '2_weeks', 45.00),
(169, 'Room', 'rent', '1_month', 75.00),
(170, 'Room', 'rent', '3_months', 175.00),
(171, 'Room', 'rent', '6_months', 350.00),
(172, 'Room', 'rent', '1_year', 600.00),
(173, '', 'sale', '1_week', 150.00),
(174, '', 'sale', '2_weeks', 200.00),
(175, '', 'sale', '1_month', 350.00),
(176, '', 'sale', '3_months', 800.00),
(177, '', 'sale', '6_months', 1500.00),
(178, '', 'sale', '1_year', 2500.00),
(179, '', 'rent', '1_week', 75.00),
(180, '', 'rent', '2_weeks', 100.00),
(181, '', 'rent', '1_month', 175.00),
(182, '', 'rent', '3_months', 400.00),
(183, '', 'rent', '6_months', 750.00),
(184, '', 'rent', '1_year', 1250.00);

-- --------------------------------------------------------

--
-- Table structure for table `promotions`
--

CREATE TABLE IF NOT EXISTS `promotions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `reward_amount` decimal(10,2) NOT NULL,
  `promotion_type` enum('fixed','percentage') NOT NULL,
  `promotion_terms` text NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `promotions`
--

INSERT INTO `promotions` (`id`, `listing_id`, `reward_amount`, `promotion_type`, `promotion_terms`, `created_at`) VALUES
(1, 14, 454.00, 'fixed', 'Terms and Conditions\r\nLast Updated: April 09, 2025\r\n\r\n1. Acceptance of Terms\r\nBy using our classified ads platform, you agree to comply with these terms and conditions. If you do not agree, please refrain from using our services.\r\n\r\n2. User Responsibilities\r\nUsers are responsible for ensuring that their listings comply with our platform policies. Prohibited content includes but is not limited to:\r\n- Illegal items, scams, or fraudulent listings.\r\n- Offensive, misleading, or false advertisements.\r\n- Listings that violate intellectual property rights.\r\n\r\n3. Payments and Fees\r\nSome features of our platform may require payments. Users agree to pay the applicable fees for premium listings or promotional services. Payments are non-refundable except as required by law.\r\n\r\n4. Liability Disclaimer\r\nWe do not guarantee the accuracy or reliability of user-generated content. Transactions are solely between buyers and sellers, and we are not responsible for disputes.\r\n\r\n5. Account Suspension and Termination\r\nWe reserve the right to suspend or terminate accounts found violating our policies, including fraudulent activities, spamming, or harassment.\r\n\r\n6. Changes to Terms\r\nWe may update these terms periodically. Continued use of our platform signifies acceptance of any modifications.', '2025-04-09 21:39:02'),
(4, 13, 999.00, 'fixed', 'gfjh  hjvjh bkbgk uh chg jhgjh', '2025-04-09 21:56:22');

-- --------------------------------------------------------

--
-- Table structure for table `promotion_clicks`
--

CREATE TABLE IF NOT EXISTS `promotion_clicks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `promotion_id` int NOT NULL,
  `referral_code` varchar(255) NOT NULL,
  `ip_address` varchar(100) DEFAULT NULL,
  `user_agent` text,
  `referrer` text,
  `visited_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `promotion_id` (`promotion_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `promotion_leads`
--

CREATE TABLE IF NOT EXISTS `promotion_leads` (
  `id` int NOT NULL AUTO_INCREMENT,
  `promotion_id` int NOT NULL,
  `lead_name` varchar(255) NOT NULL,
  `lead_phone` varchar(100) DEFAULT NULL,
  `lead_email` varchar(255) DEFAULT NULL,
  `message` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `promotion_id` (`promotion_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `property_auctions`
--

CREATE TABLE IF NOT EXISTS `property_auctions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `seller_id` int NOT NULL,
  `starting_price` decimal(10,2) NOT NULL,
  `reserve_price` decimal(10,2) DEFAULT NULL,
  `buy_now_price` decimal(10,2) DEFAULT NULL,
  `auction_start` datetime NOT NULL,
  `auction_end` datetime NOT NULL,
  `status` enum('Upcoming','Live','Completed','Canceled') DEFAULT 'Upcoming',
  `winner_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`),
  KEY `seller_id` (`seller_id`),
  KEY `winner_id` (`winner_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `property_auctions`
--

INSERT INTO `property_auctions` (`id`, `listing_id`, `seller_id`, `starting_price`, `reserve_price`, `buy_now_price`, `auction_start`, `auction_end`, `status`, `winner_id`, `created_at`) VALUES
(1, 14, 1, 1232.00, 4343.00, 12333.00, '2025-03-28 17:03:24', '2025-04-28 17:09:00', 'Live', NULL, '2025-03-29 00:03:24'),
(2, 59, 1, 20000.00, 570000.00, 800000.00, '2025-05-19 09:55:24', '2025-10-31 09:54:00', 'Live', NULL, '2025-05-19 16:55:24'),
(3, 13, 1, 500.00, 100000.00, 150000.00, '2025-05-19 10:00:55', '2026-07-23 10:00:00', 'Live', NULL, '2025-05-19 17:00:55'),
(4, 11, 1, 6000.00, 60000.00, 68000.00, '2025-05-19 10:01:42', '2026-01-05 10:01:00', 'Live', NULL, '2025-05-19 17:01:42');

-- --------------------------------------------------------

--
-- Table structure for table `property_transactions`
--

CREATE TABLE IF NOT EXISTS `property_transactions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `buyer_id` int DEFAULT NULL,
  `seller_id` int DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `status` varchar(50) DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `referral_visits`
--

CREATE TABLE IF NOT EXISTS `referral_visits` (
  `id` int NOT NULL AUTO_INCREMENT,
  `referral_code` varchar(100) NOT NULL,
  `promoter_id` int NOT NULL,
  `listing_id` int NOT NULL,
  `ip_address` varchar(100) DEFAULT NULL,
  `user_agent` text,
  `visited_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `referral_visits`
--

INSERT INTO `referral_visits` (`id`, `referral_code`, `promoter_id`, `listing_id`, `ip_address`, `user_agent`, `visited_at`) VALUES
(1, 'promo_67f7181cb2c5d', 1, 12, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 Edg/135.0.0.0', '2025-04-10 01:12:31'),
(2, 'promo_67f7181cb2c5d', 1, 12, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 Edg/135.0.0.0', '2025-04-10 01:14:38'),
(3, 'promo_67f7181cb2c5d', 1, 12, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 Edg/135.0.0.0', '2025-04-10 01:15:23');

-- --------------------------------------------------------

--
-- Table structure for table `rooms`
--

CREATE TABLE IF NOT EXISTS `rooms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `room_type` varchar(16) DEFAULT NULL,
  `furnishing` varchar(17) DEFAULT NULL,
  `occupants` int DEFAULT NULL,
  `size_sqft` int DEFAULT NULL,
  `bathroom_type` varchar(7) DEFAULT NULL,
  `cooking_area` varchar(3) DEFAULT NULL,
  `internet_utilities` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` (`id`, `listing_id`, `room_type`, `furnishing`, `occupants`, `size_sqft`, `bathroom_type`, `cooking_area`, `internet_utilities`) VALUES
(1, 74, 'Single Room', 'Fully Furnished', 6, 45, 'Shared', 'Yes', 'Yes');

-- --------------------------------------------------------

--
-- Table structure for table `saved_listings`
--

CREATE TABLE IF NOT EXISTS `saved_listings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `listing_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `saved_listings`
--

INSERT INTO `saved_listings` (`id`, `user_id`, `listing_id`, `created_at`) VALUES
(11, 1, 11, '2025-04-09 00:31:14'),
(7, 1, 13, '2025-03-24 17:08:53'),
(9, 2, 14, '2025-04-08 01:09:36'),
(13, 1, 14, '2025-04-09 18:38:32'),
(14, 1, 12, '2025-04-09 22:03:27');

-- --------------------------------------------------------

--
-- Table structure for table `stores`
--

CREATE TABLE IF NOT EXISTS `stores` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `shop_type` varchar(50) DEFAULT NULL,
  `size_sqft` int DEFAULT NULL,
  `security_features` varchar(255) DEFAULT NULL,
  `stock_storage` enum('Yes','No') DEFAULT NULL,
  `furnishing` varchar(50) DEFAULT NULL,
  `electricity_supply` enum('Yes','No') DEFAULT NULL,
  `water_supply` enum('Yes','No') DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `venues`
--

CREATE TABLE IF NOT EXISTS `venues` (
  `id` int NOT NULL AUTO_INCREMENT,
  `listing_id` int NOT NULL,
  `capacity` int NOT NULL,
  `indoor_outdoor` enum('indoor','outdoor','both') NOT NULL,
  `parking_space` enum('yes','no') NOT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `views`
--

CREATE TABLE IF NOT EXISTS `views` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `listing_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`listing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wallets`
--

CREATE TABLE IF NOT EXISTS `wallets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `balance` decimal(12,2) NOT NULL DEFAULT '0.00',
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `wallets`
--

INSERT INTO `wallets` (`id`, `user_id`, `balance`, `updated_at`) VALUES
(1, 2, 24.00, '2025-06-01 06:19:52'),
(2, 8, 1.00, '2025-06-01 08:23:44'),
(3, 9, 0.00, '2025-06-01 09:41:11');

-- --------------------------------------------------------

--
-- Table structure for table `wallet_transactions`
--

CREATE TABLE IF NOT EXISTS `wallet_transactions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `wallet_id` int NOT NULL,
  `type` enum('deposit','withdrawal','payment') NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `status` enum('pending','completed','failed') DEFAULT 'completed',
  `reference` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reference` (`reference`),
  KEY `wallet_id` (`wallet_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `wallet_transactions`
--

INSERT INTO `wallet_transactions` (`id`, `wallet_id`, `type`, `amount`, `status`, `reference`, `created_at`) VALUES
(1, 1, 'deposit', 2000.00, 'completed', 'dep_683bd02d46a63', '2025-06-01 03:59:41'),
(2, 1, 'withdrawal', 40.00, 'completed', 'wd_683bd09236f72', '2025-06-01 04:01:22'),
(3, 1, 'withdrawal', 10.00, 'completed', 'wd_683bd0b244140', '2025-06-01 04:01:54'),
(4, 1, 'deposit', 5.00, 'completed', 'dep_683bd764da752', '2025-06-01 04:30:28'),
(5, 1, 'withdrawal', 6.00, 'completed', 'wd_683bd77c3e2a2', '2025-06-01 04:30:52'),
(6, 1, 'withdrawal', 1000.00, 'completed', 'wd_683be09cc069a', '2025-06-01 05:09:48'),
(7, 1, 'deposit', 32.00, 'completed', 'dep_683be1c172c11', '2025-06-01 05:14:41'),
(8, 1, 'deposit', 5.00, '', 'dep_683be3481155f', '2025-06-01 05:21:12'),
(9, 1, 'withdrawal', 8.00, '', 'wd_683be359be8a3', '2025-06-01 05:21:29'),
(10, 1, 'deposit', 9999999999.99, '', 'dep_683be3b2e3613', '2025-06-01 05:22:58'),
(11, 1, 'withdrawal', 800000433.00, '', 'wd_683be3d3ef1e1', '2025-06-01 05:23:31'),
(12, 1, 'withdrawal', 8000004338.00, '', 'wd_683be3e191106', '2025-06-01 05:23:45'),
(13, 1, 'withdrawal', 1199995220.99, '', 'wd_683be424162b8', '2025-06-01 05:24:52'),
(14, 1, 'deposit', 6.00, 'completed', 'dep_683bef078de6f', '2025-06-01 06:11:19'),
(15, 1, 'deposit', 10.00, 'completed', 'dep_683bf1088759f', '2025-06-01 06:19:52'),
(16, 2, 'deposit', 1.00, 'completed', 'dep_683c0e102229b', '2025-06-01 08:23:44');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `listings`
--
ALTER TABLE `listings` ADD FULLTEXT KEY `title` (`title`,`description`,`address`,`country`,`city`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `auction_notifications`
--
ALTER TABLE `auction_notifications`
  ADD CONSTRAINT `auction_notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `auction_notifications_ibfk_2` FOREIGN KEY (`auction_id`) REFERENCES `property_auctions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `auction_payments`
--
ALTER TABLE `auction_payments`
  ADD CONSTRAINT `auction_payments_ibfk_1` FOREIGN KEY (`auction_id`) REFERENCES `property_auctions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `auction_payments_ibfk_2` FOREIGN KEY (`winner_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `auto_bidding`
--
ALTER TABLE `auto_bidding`
  ADD CONSTRAINT `auto_bidding_ibfk_1` FOREIGN KEY (`auction_id`) REFERENCES `property_auctions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `auto_bidding_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `bids`
--
ALTER TABLE `bids`
  ADD CONSTRAINT `bids_ibfk_1` FOREIGN KEY (`auction_id`) REFERENCES `property_auctions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bids_ibfk_2` FOREIGN KEY (`bidder_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `property_auctions`
--
ALTER TABLE `property_auctions`
  ADD CONSTRAINT `property_auctions_ibfk_1` FOREIGN KEY (`listing_id`) REFERENCES `listings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `property_auctions_ibfk_2` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `property_auctions_ibfk_3` FOREIGN KEY (`winner_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;
COMMIT;

