19 lines
1.3 KiB
SQL
19 lines
1.3 KiB
SQL
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');
|