CREATE TABLE IF NOT EXISTS jobs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    company VARCHAR(255) NOT NULL,
    location VARCHAR(255) NOT NULL,
    description TEXT,
    salary VARCHAR(100),
    job_type VARCHAR(50),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Insert dummy data
INSERT INTO jobs (title, company, location, description, salary, job_type) VALUES
('Senior Frontend Developer', 'Innovate Inc.', 'San Francisco, CA', 'Join our team to build next-gen web applications with React and TypeScript.', '$120,000 - $150,000', 'Full-time'),
('UX/UI Designer', 'Creative Solutions', 'New York, NY', 'Design beautiful and intuitive interfaces for our mobile and web products.', '$90,000 - $110,000', 'Full-time'),
('Data Scientist', 'Analytics Co.', 'Remote', 'Analyze large datasets to extract meaningful insights and drive business decisions.', '$130,000 - $160,000', 'Remote'),
('Product Manager', 'AppMakers LLC', 'Austin, TX', 'Lead the product lifecycle from conception to launch for our flagship mobile app.', '$115,000 - $140,000', 'Full-time'),
('Backend Engineer (PHP)', 'Legacy Systems', 'Chicago, IL', 'Maintain and improve our existing PHP codebase, ensuring reliability and performance.', '$100,000 - $125,000', 'Contract');
