diff options
Diffstat (limited to 'util/updates/update_2.25.sql')
-rw-r--r-- | util/updates/update_2.25.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/util/updates/update_2.25.sql b/util/updates/update_2.25.sql index 07275ae7..6302daaf 100644 --- a/util/updates/update_2.25.sql +++ b/util/updates/update_2.25.sql @@ -67,3 +67,10 @@ $$ LANGUAGE sql IMMUTABLE; -- Changes to search normalization UPDATE vn SET c_search = NULL; + + +-- Convert producers_rev.type to enum +CREATE TYPE producer_type AS ENUM ('co', 'in', 'ng'); +ALTER TABLE producers_rev ALTER COLUMN type DROP DEFAULT; +ALTER TABLE producers_rev ALTER COLUMN type TYPE producer_type USING type::producer_type; +ALTER TABLE producers_rev ALTER COLUMN type SET DEFAULT 'co'; |