diff options
| author | SpaceRanger <space.ranger.vn@gmail.com> | 2012-07-24 10:07:04 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2012-07-24 10:07:04 +0200 |
| commit | 51d88d29e640f577d64549e8bd8fc7a94a05911f (patch) | |
| tree | 0a99f8cd3f3d3aaedc5ed69293d4a83290ad61f6 /util | |
| parent | 9a83733079e17f46c66d761a098952d0f50d93fa (diff) | |
Add wishlist / VN list status options to VN list browser
Diffstat (limited to 'util')
| -rw-r--r-- | util/sql/all.sql | 2 | ||||
| -rw-r--r-- | util/updates/update_2.23.sql | 6 |
2 files changed, 7 insertions, 1 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql index c0664c51..68739776 100644 --- a/util/sql/all.sql +++ b/util/sql/all.sql @@ -13,7 +13,7 @@ CREATE TYPE language AS ENUM ('cs', 'da', 'de', 'en', 'es', 'fi', 'fr', CREATE TYPE medium AS ENUM ('cd', 'dvd', 'gdr', 'blr', 'flp', 'mrt', 'mem', 'umd', 'nod', 'in', 'otc'); CREATE TYPE notification_ntype AS ENUM ('pm', 'dbdel', 'listdel', 'dbedit', 'announce'); CREATE TYPE notification_ltype AS ENUM ('v', 'r', 'p', 'c', 't'); -CREATE TYPE prefs_key AS ENUM ('l10n', 'skin', 'customcss', 'filter_vn', 'filter_release', 'show_nsfw', 'hide_list', 'notify_nodbedit', 'notify_announce'); +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'); 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'); diff --git a/util/updates/update_2.23.sql b/util/updates/update_2.23.sql index 69ef05c9..4464053c 100644 --- a/util/updates/update_2.23.sql +++ b/util/updates/update_2.23.sql @@ -46,3 +46,9 @@ UPDATE vn SET c_rating = (SELECT ( ((SELECT COUNT(vote)::real/COUNT(DISTINCT vid)::real FROM votes) + COUNT(uid)::real) ) FROM votes WHERE vid = id AND uid NOT IN(SELECT id FROM users WHERE ign_votes) ); + + +-- New enum types for user list display in VN list + +ALTER TYPE prefs_key ADD VALUE 'vn_list_own' AFTER 'notify_announce'; +ALTER TYPE prefs_key ADD VALUE 'vn_list_wish' AFTER 'vn_list_own'; |