diff options
Diffstat (limited to 'util/updates/update_2.8.sql')
| -rw-r--r-- | util/updates/update_2.8.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/util/updates/update_2.8.sql b/util/updates/update_2.8.sql index e72af294..df5221ee 100644 --- a/util/updates/update_2.8.sql +++ b/util/updates/update_2.8.sql @@ -47,3 +47,10 @@ ALTER TABLE anime ALTER COLUMN type TYPE anime_type USING ELSE NULL END; + +-- Release media stored as enum +CREATE TYPE medium AS ENUM ('cd', 'dvd', 'gdr', 'blr', 'flp', 'mrt', 'mem', 'umd', 'nod', 'in', 'otc'); +ALTER TABLE releases_media ALTER COLUMN medium DROP DEFAULT; +ALTER TABLE releases_media ALTER COLUMN medium TYPE medium USING TRIM(both ' ' from medium)::medium; + + |