-- SIMPLEST VERSION for OLD MySQL
-- Just copy and paste this in phpMyAdmin SQL tab

CREATE TABLE bookings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    invoice_number VARCHAR(50) NOT NULL,
    full_name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    phone VARCHAR(20) NOT NULL,
    check_in DATE NOT NULL,
    check_out DATE NOT NULL,
    room_type VARCHAR(50) NOT NULL,
    guests INT NOT NULL,
    services TEXT,
    total_price DECIMAL(10, 2) NOT NULL,
    booking_date DATETIME,
    status VARCHAR(20),
    notes TEXT
);
