1 -- update the default sort type
5 default_sort_type = 'TopDay'
7 default_sort_type IN ('TopThreeMonths', 'TopSixMonths', 'TopNineMonths');
10 ALTER TYPE sort_type_enum RENAME TO sort_type_enum__;
12 -- create the new enum
13 CREATE TYPE sort_type_enum AS ENUM (
30 -- alter all you enum columns
31 ALTER TABLE local_user
32 ALTER COLUMN default_sort_type TYPE sort_type_enum
33 USING default_sort_type::text::sort_type_enum;
36 DROP TYPE sort_type_enum__;