-- Migration: Update employment_type constraint with additional values
-- Description: Add permanent, training, temporary, voluntary to employment_type

-- Drop existing constraint and recreate with expanded values
ALTER TABLE jobs DROP CONSTRAINT IF EXISTS jobs_employment_type_check;

ALTER TABLE jobs ADD CONSTRAINT jobs_employment_type_check 
    CHECK (employment_type IN (
        'full-time', 
        'part-time', 
        'dispatch', 
        'contract',
        'permanent',
        'training',
        'temporary',
        'voluntary'
    ));

COMMENT ON COLUMN jobs.employment_type IS 'Employment type: full-time, part-time, dispatch, contract, permanent, training, temporary, voluntary';
