-- Reverses 000002, dropping each added column. Indexes and the check
-- constraint go with their columns.
SET search_path = public;

DROP INDEX IF EXISTS public.job_applications_interview_idx;

ALTER TABLE public.job_applications
  DROP COLUMN IF EXISTS interview_id;

ALTER TABLE public.courses
  DROP COLUMN IF EXISTS training_outline;

ALTER TABLE public.worker_profiles
  DROP CONSTRAINT IF EXISTS worker_profiles_score_breakdown_object;

ALTER TABLE public.worker_profiles
  DROP COLUMN IF EXISTS score_breakdown;