diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/all.sql | 2 | ||||
-rw-r--r-- | util/updates/update_2.25.sql | 2 |
2 files changed, 3 insertions, 1 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql index 96787bd5..f9f8a6dd 100644 --- a/util/sql/all.sql +++ b/util/sql/all.sql @@ -6,7 +6,7 @@ CREATE TYPE anime_type AS ENUM ('tv', 'ova', 'mov', 'oth', 'web', 'spe', 'mv'); CREATE TYPE blood_type AS ENUM ('unknown', 'a', 'b', 'ab', 'o'); CREATE TYPE char_role AS ENUM ('main', 'primary', 'side', 'appears'); -CREATE TYPE credit_type AS ENUM ('script', 'chardesign', 'music', 'director', 'art', 'songs', 'staff'); +CREATE TYPE credit_type AS ENUM ('scenario', 'script', 'chardesign', 'music', 'director', 'art', 'songs', 'staff'); CREATE TYPE dbentry_type AS ENUM ('v', 'r', 'p', 'c', 's'); CREATE TYPE edit_rettype AS (iid integer, cid integer, rev integer); CREATE TYPE gender AS ENUM ('unknown', 'm', 'f', 'b'); diff --git a/util/updates/update_2.25.sql b/util/updates/update_2.25.sql new file mode 100644 index 00000000..5188cca2 --- /dev/null +++ b/util/updates/update_2.25.sql @@ -0,0 +1,2 @@ +ALTER TYPE credit_type ADD VALUE 'scenario' BEFORE 'script'; + |