CREATE TABLE IF NOT EXISTS projects (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    slug VARCHAR(255) UNIQUE NOT NULL,
    client_name VARCHAR(255) NOT NULL,
    country VARCHAR(255) NOT NULL,
    description TEXT,
    services TEXT,
    sector ENUM(
        'Hospitality',
        'Apartment & Luxury Houses',
        'Industrial',
        'High-rise and Commercial',
        'Other'
    ) NOT NULL DEFAULT 'Other',
    scope TEXT,
    completion_date DATE,
    images JSON DEFAULT NULL,
    display BOOLEAN DEFAULT TRUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_display (display)
);
