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/updates | |
parent | 7605b38f304f043b1a0947278eca12daad32a608 (diff) |
Add profile option to show or summarize tags on VN pages by default
Diffstat (limited to 'util/updates')
-rw-r--r-- | util/updates/update_2.25.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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'; + |