CREATE TABLE subscriptions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    firstname VARCHAR(100),
    lastname VARCHAR(100),
    email VARCHAR(255),
    phone_number VARCHAR(50),
    plan VARCHAR(100),
    site ENUM('site1','site2','site3') DEFAULT 'site1',
    zoho_request_id VARCHAR(255),
    sign_status ENUM('pending','signed') DEFAULT 'pending',
    signed_doc_url TEXT,
    payment_status ENUM('pending','paid') DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_email (email),
    INDEX idx_site (site),
    INDEX idx_email_site (email, site)
);