summaryrefslogtreecommitdiff
path: root/util/updates/update_2.25.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/updates/update_2.25.sql')
-rw-r--r--util/updates/update_2.25.sql5
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';
+