summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-01-29 09:44:00 +0100
committerYorhel <git@yorhel.nl>2015-01-29 09:44:13 +0100
commitf1156c6369ee9f22183951c1531972ac99fec52c (patch)
treed8eee2867d593ee8f402dcf3cac0b4b361217e16 /util
parenta73b9d000b2dfb18567704f8c14d1ab3ca62d59d (diff)
staff: Added 'scenario' credit type
Diffstat (limited to 'util')
-rw-r--r--util/sql/all.sql2
-rw-r--r--util/updates/update_2.25.sql2
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';
+