-- V3 tables are automatically created by pwa-bootstrap.php.
-- This file is provided as a reference/manual fallback.
CREATE TABLE IF NOT EXISTS guest_users (
 id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 hotel_id INT UNSIGNED NOT NULL,
 full_name VARCHAR(190) NOT NULL,
 email VARCHAR(190) NOT NULL,
 phone VARCHAR(80) NULL,
 password_hash VARCHAR(255) NOT NULL,
 status ENUM('active','inactive') NOT NULL DEFAULT 'active',
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 UNIQUE KEY uniq_hotel_email (hotel_id,email)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS guest_user_bookings (
 id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 user_id INT UNSIGNED NOT NULL,
 hotel_id INT UNSIGNED NOT NULL,
 booking_ref VARCHAR(120) NOT NULL,
 guest_name VARCHAR(190) NULL,
 guest_email VARCHAR(190) NULL,
 room_number VARCHAR(80) NULL,
 arrival_date DATE NULL,
 departure_date DATE NULL,
 status ENUM('pending','verified','rejected') NOT NULL DEFAULT 'pending',
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 UNIQUE KEY uniq_user_booking (user_id,booking_ref)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;