Change order of staff roles

https://vndb.org/t6138.226 - https://vndb.org/t6048.132

1 files changed, 9 insertions, 0 deletions

diff --git a/util/updates/update_2.25.sql b/util/updates/update_2.25.sql
index 3d862491..5aef2ece 100644
--- a/util/updates/update_2.25.sql
+++ b/util/updates/update_2.25.sql
@@ -20,3 +20,12 @@ ALTER TYPE platform ADD VALUE 'x68' BEFORE 'xb1';
 
 -- New language
 ALTER TYPE language ADD VALUE 'ca' BEFORE 'cs';
+
+
+-- Reorder credit_type (and remove 'script')
+ALTER TYPE credit_type RENAME TO credit_type2;
+CREATE TYPE credit_type AS ENUM ('scenario', 'chardesign', 'art', 'music', 'songs', 'director', 'staff');
+ALTER TABLE vn_staff ALTER role DROP DEFAULT;
+ALTER TABLE vn_staff ALTER role TYPE credit_type USING role::text::credit_type;
+ALTER TABLE vn_staff ALTER role SET DEFAULT 'staff';
+DROP TYPE credit_type2;