diff options
| author | Yorhel <git@yorhel.nl> | 2015-07-21 02:13:31 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2015-07-21 02:13:31 +0200 |
| commit | 0032d62652c6168316fd9429d17604b61a812598 (patch) | |
| tree | 20a40c8771b179dacf37bd62666410159c9fc7fe /util | |
| parent | 7605b38f304f043b1a0947278eca12daad32a608 (diff) | |
Add profile option to show or summarize tags on VN pages by default
Diffstat (limited to 'util')
| -rw-r--r-- | util/sql/all.sql | 2 | ||||
| -rw-r--r-- | util/updates/update_2.25.sql | 5 |
2 files changed, 6 insertions, 1 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql index 1377e3ad..fc32d3c4 100644 --- a/util/sql/all.sql +++ b/util/sql/all.sql @@ -15,7 +15,7 @@ CREATE TYPE medium AS ENUM ('cd', 'dvd', 'gdr', 'blr', 'flp', 'mrt', CREATE TYPE notification_ntype AS ENUM ('pm', 'dbdel', 'listdel', 'dbedit', 'announce'); 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'); +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'); 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.25.sql b/util/updates/update_2.25.sql index a7ccf6c4..05839565 100644 --- a/util/updates/update_2.25.sql +++ b/util/updates/update_2.25.sql @@ -36,3 +36,8 @@ INSERT INTO stats_cache (section, count) VALUES ('staff', 0); CREATE TRIGGER stats_cache_new AFTER INSERT ON staff FOR EACH ROW WHEN (NEW.hidden = FALSE) EXECUTE PROCEDURE update_stats_cache(); CREATE TRIGGER stats_cache_edit AFTER UPDATE ON staff FOR EACH ROW WHEN (OLD.hidden IS DISTINCT FROM NEW.hidden) EXECUTE PROCEDURE update_stats_cache(); UPDATE stats_cache SET count = (SELECT COUNT(*) FROM staff WHERE hidden = FALSE) WHERE section = 'staff' + + +-- New preferences +ALTER TYPE prefs_key ADD VALUE 'tags_all'; + |