1 -- update the default sort type
5 default_sort_type = 'TopDay'
7 default_sort_type IN ('TopHour', 'TopSixHour', 'TopTwelveHour');
10 ALTER TYPE sort_type_enum RENAME TO sort_type_enum__;
12 -- create the new enum
13 CREATE TYPE sort_type_enum AS ENUM (
27 -- alter all you enum columns
28 ALTER TABLE local_user
29 ALTER COLUMN default_sort_type TYPE sort_type_enum
30 USING default_sort_type::text::sort_type_enum;
33 DROP TYPE sort_type_enum__;