CREATE TABLE companies (
    id INT AUTO_INCREMENT PRIMARY KEY,
    company_name VARCHAR(255),
    industry VARCHAR(100),
    pain_point TEXT,
    repetitive_task TEXT,
    time_consuming_task TEXT,
    operational_problem TEXT,
    software_used TEXT,
    major_suppliers TEXT,
    growing_companies TEXT,
    ideal_customer TEXT,
    problem_solved TEXT,
    current_solution TEXT,
    biggest_challenge TEXT,
    customer_acquisition TEXT,
    average_deal_size VARCHAR(100),
    customer_double_effect TEXT,
    manual_process TEXT,
    tracked_metrics TEXT,
    hardest_part TEXT,
    business_improvement TEXT,
    eliminate_problem TEXT,
    pricing_model VARCHAR(100),
    photo_path TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
