diff options
author | Yorhel <git@yorhel.nl> | 2015-10-11 12:00:48 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-10-11 12:00:48 +0200 |
commit | 15382265b39f045fc5f20e9e676b24941da6bd63 (patch) | |
tree | 89a581d32849e113f28de85746d3d12cd5108998 /util/sql/all.sql | |
parent | 3d10c6358eb0594a6a2970facf56e79205e002a4 (diff) |
SQL: Convert producers_rev.type into enum
Same reasoning as 19ce5fcf536ed478ad34b6b1014bf6f44841d25d
Diffstat (limited to 'util/sql/all.sql')
-rw-r--r-- | util/sql/all.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql index a1689149..91f58267 100644 --- a/util/sql/all.sql +++ b/util/sql/all.sql @@ -17,6 +17,7 @@ CREATE TYPE notification_ntype AS ENUM ('pm', 'dbdel', 'listdel', 'dbedit', 'ann CREATE TYPE notification_ltype AS ENUM ('v', 'r', 'p', 'c', 't', 's'); CREATE TYPE platform AS ENUM ('win', 'dos', 'lin', 'mac', 'ios', 'and', 'dvd', 'bdp', 'fmt', 'gba', 'gbc', 'msx', 'nds', 'nes', 'p88', 'p98', 'pce', 'pcf', 'psp', 'ps1', 'ps2', 'ps3', 'ps4', 'psv', 'drc', 'sat', 'sfc', 'wii', 'n3d', 'x68', 'xb1', 'xb3', 'xbo', 'web', 'oth'); CREATE TYPE prefs_key AS ENUM ('l10n', 'skin', 'customcss', 'filter_vn', 'filter_release', 'show_nsfw', 'hide_list', 'notify_nodbedit', 'notify_announce', 'vn_list_own', 'vn_list_wish', 'tags_all', 'tags_cat', 'spoilers', 'traits_sexual'); +CREATE TYPE producer_type AS ENUM ('co', 'in', 'ng'); CREATE TYPE producer_relation AS ENUM ('old', 'new', 'sub', 'par', 'imp', 'ipa', 'spa', 'ori'); CREATE TYPE release_type AS ENUM ('complete', 'partial', 'trial'); CREATE TYPE tag_category AS ENUM('cont', 'ero', 'tech'); |