
-- Create a new database
CREATE DATABASE IF NOT EXISTS bookings_db;

CREATE TABLE bookings (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(120) NOT NULL,
  email VARCHAR(150) NOT NULL,
  whatsapp VARCHAR(30),
  country VARCHAR(100),
  travel_date VARCHAR(50),
  travelers INT,
  destination VARCHAR(150),
  message TEXT,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS `bookings` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `first_name` VARCHAR(100) NOT NULL,
    `last_name` VARCHAR(100) NOT NULL,
    `email` VARCHAR(100) NOT NULL,
    `phone` VARCHAR(20) NOT NULL,
    `nationality` VARCHAR(100) NOT NULL,
    `city` VARCHAR(100) NOT NULL,
    `travel_date` DATE NOT NULL,
    `length_of_stay` VARCHAR(50) NOT NULL,
    `message` TEXT,
    `id_number` VARCHAR(50),
    `id_type` VARCHAR(50),
    `passport_number` VARCHAR(50),
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE tour_bookings (
    id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    person_name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    airport VARCHAR(100) NOT NULL,
    hotel VARCHAR(100) NOT NULL,
    arrival_date_time DATETIME NOT NULL,
    areas_visit TEXT NOT NULL,
    car_type VARCHAR(50) NOT NULL,
    guide_name VARCHAR(100) NOT NULL,
    guide_phone VARCHAR(20) NOT NULL,
    guide_id VARCHAR(50) NOT NULL,
    departure_date_time DATETIME NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE ratings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    rating INT NOT NULL,
    comment TEXT NOT NULL
);
