summaryrefslogtreecommitdiff
path: root/util/updates/update_2.25.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/updates/update_2.25.sql')
-rw-r--r--util/updates/update_2.25.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/update_2.25.sql b/util/updates/update_2.25.sql
index eb2f2776..8207adc6 100644
--- a/util/updates/update_2.25.sql
+++ b/util/updates/update_2.25.sql
@@ -44,3 +44,8 @@ ALTER TYPE prefs_key ADD VALUE 'tags_cat';
ALTER TYPE prefs_key ADD VALUE 'spoilers';
ALTER TYPE prefs_key ADD VALUE 'traits_sexual';
+
+-- Convert threads_boards.type to enum
+CREATE TYPE board_type AS ENUM ('an', 'db', 'ge', 'v', 'p', 'u');
+ALTER TABLE threads_boards ALTER COLUMN type DROP DEFAULT;
+ALTER TABLE threads_boards ALTER COLUMN type TYPE board_type USING trim(type)::board_type;