-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 18, 2026 at 09:56 PM
-- Server version: 10.4.21-MariaDB
-- PHP Version: 7.3.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `vrbo_clone`
--

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

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

CREATE TABLE `bookings` (
  `id` int(11) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(150) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `zip_code` varchar(20) DEFAULT NULL,
  `checkin_date` date DEFAULT NULL,
  `checkout_date` date DEFAULT NULL,
  `guests` varchar(50) DEFAULT NULL,
  `total_price` varchar(50) DEFAULT NULL,
  `property_id` int(11) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `phone` varchar(50) DEFAULT NULL,
  `bank_account` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `footer`
--

CREATE TABLE `footer` (
  `id` int(11) NOT NULL DEFAULT 1,
  `company_col_title` varchar(100) DEFAULT NULL,
  `company_col_links` text DEFAULT NULL,
  `support_col_title` varchar(100) DEFAULT NULL,
  `support_col_links` text DEFAULT NULL,
  `contact_col_title` varchar(100) DEFAULT NULL,
  `contact_address` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(100) DEFAULT NULL,
  `contact_email` varchar(150) DEFAULT NULL,
  `copyright_text` varchar(255) DEFAULT NULL,
  `bottom_links` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `footer`
--

INSERT INTO `footer` (`id`, `company_col_title`, `company_col_links`, `support_col_title`, `support_col_links`, `contact_col_title`, `contact_address`, `contact_phone`, `contact_email`, `copyright_text`, `bottom_links`) VALUES
(1, 'Companie', '<a href=\"about.html\">About Us</a>\r\n<a href=\"careers.html\">Careers</a>\r\n<a href=\"investors.html\">Investors</a>', 'Support', '<a href=\"help-centers.html\">Help Center</a>\r\n<a href=\"cancellation.html\">Cancellation Options</a>\r\n<a href=\"trust-safety.html\">Trust & Safety</a>', 'Contact Us', '1234 Travel Avenue, Suite 400, New York, NY 10001', '+0763 842 888', 'support@pulamea.com', '&copy; 2026 Puleashka - All rights reserved.', '<a href=\"#\" style=\"color: #cbd5e1; text-decoration: none; margin: 0 10px\">Terms and Conditions</a> | <a href=\"#\" style=\"color: #cbd5e1; text-decoration: none; margin: 0 10px\">Privacy Policy</a>');

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

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

CREATE TABLE `properties` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `loc` varchar(255) NOT NULL,
  `price` varchar(100) NOT NULL,
  `priceNum` int(11) NOT NULL,
  `category` varchar(50) NOT NULL,
  `rating` decimal(3,1) NOT NULL,
  `reviews` int(11) NOT NULL,
  `beds` int(11) NOT NULL,
  `baths` int(11) NOT NULL,
  `img` varchar(255) NOT NULL,
  `map_iframe` text DEFAULT NULL,
  `reviews_json` text DEFAULT NULL,
  `host_name` varchar(100) DEFAULT 'Sarah',
  `host_bio` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `setting_key` varchar(50) NOT NULL,
  `setting_value` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`setting_key`, `setting_value`) VALUES
('site_name', 'Vrbo');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `footer`
--
ALTER TABLE `footer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `properties`
--
ALTER TABLE `properties`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`setting_key`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `properties`
--
ALTER TABLE `properties`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
