CREATE DATABASE IF NOT EXISTS rachid_website;
USE rachid_website;

CREATE TABLE IF NOT EXISTS quotes (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    phone VARCHAR(20) NOT NULL,
    event_date VARCHAR(50),
    event_time VARCHAR(20),
    groom_origins TEXT,
    bride_origins TEXT,
    place VARCHAR(255),
    guest_count INT,
    venue_address TEXT,
    groom_address TEXT,
    bride_address TEXT,
    message TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
