CREATE TABLE IF NOT EXISTS jobs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    company VARCHAR(255),
    location VARCHAR(255),
    link VARCHAR(500) UNIQUE,
    snippet TEXT,
    salary VARCHAR(255),
    source VARCHAR(255),
    updated_at DATETIME
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;