Add staff statistic to main menu

1 files changed, 7 insertions, 0 deletions

diff --git a/util/updates/update_2.25.sql b/util/updates/update_2.25.sql
index 5aef2ece..a7ccf6c4 100644
--- a/util/updates/update_2.25.sql
+++ b/util/updates/update_2.25.sql
@@ -29,3 +29,10 @@ ALTER TABLE vn_staff ALTER role DROP DEFAULT;
 ALTER TABLE vn_staff ALTER role TYPE credit_type USING role::text::credit_type;
 ALTER TABLE vn_staff ALTER role SET DEFAULT 'staff';
 DROP TYPE credit_type2;
+
+
+-- Staff stat
+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'