-- Default category mappings for job matching
INSERT IGNORE INTO `#__job_category_mappings` (`job_title_pattern`, `category`, `keywords`) VALUES
('accountant', 'Finance', 'accounting,bookkeeping,finance,fiscal'),
('finance', 'Finance', 'financial,analyst,budget,treasury'),
('auditor', 'Finance', 'auditing,internal audit,compliance'),
('teacher', 'Education', 'teaching,instructor,educator,school'),
('lecturer', 'Education', 'university,academic,professor'),
('engineer', 'Engineering', 'engineering,technical,design,construction'),
('developer', 'IT', 'software,programming,developer, coding'),
('it', 'IT', 'information technology,systems,network,technical support'),
('nurse', 'Healthcare', 'nursing,medical,clinical,healthcare'),
('doctor', 'Healthcare', 'medical,physician,clinical,hospital'),
('driver', 'Logistics', 'driving,transport,delivery,chauffeur'),
('sales', 'Sales', 'selling,business development,marketing'),
('hr', 'Human Resources', 'human resources,recruitment,personnel,staffing'),
('procurement', 'Procurement', 'purchasing,supply chain,logistics'),
('manager', 'Management', 'management,supervisor,leadership'),
('administrator', 'Administration', 'administrative,office,secretary,clerical'),
('marketing', 'Marketing', 'digital marketing,social media,branding,communications'),
('customer service', 'Customer Service', 'support,client relations,call center'),
('security', 'Security', 'safety,guard,protection,surveillance'),
('hospitality', 'Hospitality', 'hotel,restaurant,catering,tourism');

-- Insert a test job seeker profile (optional)
INSERT IGNORE INTO `#__job_seeker_profiles` (`email`, `subscription_active`, `unsubscribe_token`) 
SELECT 'test@example.com', 1, MD5(RAND()) 
WHERE NOT EXISTS (SELECT 1 FROM `#__job_seeker_profiles` WHERE `email` = 'test@example.com');