|hUdZddlmZmZddlmZddlZdZe e d<dZ ee ee dfe d<dZ ee ee dfe d <dZ ee ee dfe d <d d Zd d Zy)zzChange STAFF role to UNIVERSITY Revision ID: a75ae73ea814 Revises: a5eea47dd9d9 Create Date: 2025-09-12 20:02:22.417658 )SequenceUnion)opN a75ae73ea814revision a5eea47dd9d9 down_revision branch_labels depends_onctjdtjdtjdtjdy)zUpgrade schema.+ALTER TYPE userrole RENAME TO userrole_old;z4CREATE TYPE userrole AS ENUM('ADMIN', 'UNIVERSITY');zALTER TABLE users ALTER COLUMN role TYPE userrole USING CASE role::text WHEN 'STAFF' THEN 'UNIVERSITY' ELSE role::text::userrole END;DROP TYPE userrole_old;Nrexecute/Users/theessential/Documents/Github/40Admission/40-admission-backend/migrations/versions/a75ae73ea814_change_staff_role_to_university.pyupgraders>JJ<=JJEFJJWXJJ()rctjdtjdtjdtjdy)zDowngrade schema.r z/CREATE TYPE userrole AS ENUM('ADMIN', 'STAFF');zALTER TABLE users ALTER COLUMN role TYPE userrole USING CASE role::text WHEN 'UNIVERSITY' THEN 'STAFF' ELSE role::text::userrole END;rNrrrr downgraders>JJ<=JJ@AJJWXJJ()r)returnN)__doc__typingrralembicr sqlalchemysarstr__annotations__r r r rrrrrrsy##1? uS(3--.?15 uS(3--.5.2 E#x}d* +2**r