INSERT INTO `JobCategory` (`id`, `name`, `slug`, `description`, `status`, `createdAt`, `updatedAt`) VALUES
  (UUID(), 'Administration', 'administration', 'Clerks, reception, office support and data capture', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'General Worker', 'general-worker', 'General work, labour, warehouse and entry-level support', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Government Jobs', 'government-jobs', 'National, provincial and municipal public-service posts', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Retail', 'retail', 'Stores, merchandising, cashiers and shop assistants', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Security', 'security', 'Security officers, guards and protection services', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Driving', 'driving', 'Drivers, couriers, transport and logistics roles', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Call Centre', 'call-centre', 'Contact-centre, customer support and service roles', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Cleaning', 'cleaning', 'Cleaning, housekeeping and facilities support', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Health', 'health', 'Healthcare, nursing, medical and social-service roles', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Education', 'education', 'Teachers, educators, lecturers and school support', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'IT', 'it', 'Information technology, software, data and ICT roles', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Engineering', 'engineering', 'Engineering, technical and built-environment roles', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Finance', 'finance', 'Accounting, audit, payroll and financial services', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Learnerships', 'learnerships', 'Structured workplace learning and training opportunities', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Internships', 'internships', 'Internships, graduate programmes and work experience', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Artisan', 'artisan', 'Trades, maintenance and qualified artisan roles', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Sales', 'sales', 'Sales, marketing and business-development roles', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3)),
  (UUID(), 'Hospitality', 'hospitality', 'Hotels, restaurants, catering and tourism roles', 'active', CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(3))
ON DUPLICATE KEY UPDATE
  `description` = VALUES(`description`),
  `status` = 'active',
  `updatedAt` = CURRENT_TIMESTAMP(3);