-- Reverses 000011.
--
-- Drops every declared employee role. Nothing else refers to this table — no
-- foreign key points at it — so the rollback is contained: worker profiles,
-- postings and applications are untouched.
--
-- `english_level` is NOT dropped. It is shared: job_postings.english_required
-- and job_applications.english_level are both that type, and dropping it here
-- would take two unrelated columns with it. `employee_role_status` IS dropped,
-- because 000011 is the only thing that ever created it.
--
-- The type goes after the table, because the table's column depends on it.

SET search_path = public;

DROP TABLE IF EXISTS public.employee_roles;
DROP TYPE  IF EXISTS public.employee_role_status;