summaryrefslogtreecommitdiff
path: root/util/updates
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2011-04-08 19:08:45 +0200
committerYorhel <git@yorhel.nl>2011-04-08 19:08:45 +0200
commit50da6516a687442f09a05416ca1daff04d7bbf37 (patch)
tree9316c817560b30e68e15e6a50631fe6c1c3b47c7 /util/updates
parentc0b8fb4a60dda06bbe306273de8ac0cd92156fd6 (diff)
Added char/tag/trait stats to database statistics box
Diffstat (limited to 'util/updates')
-rw-r--r--util/updates/update_2.20.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/util/updates/update_2.20.sql b/util/updates/update_2.20.sql
index 236161d2..28efd713 100644
--- a/util/updates/update_2.20.sql
+++ b/util/updates/update_2.20.sql
@@ -9,3 +9,16 @@ DROP TYPE tmp;
CREATE TRIGGER notify_dbdel AFTER UPDATE ON chars FOR EACH ROW WHEN (NOT OLD.hidden AND NEW.hidden) EXECUTE PROCEDURE notify_dbdel();
CREATE TRIGGER notify_dbedit AFTER UPDATE ON chars FOR EACH ROW WHEN (OLD.latest IS DISTINCT FROM NEW.latest AND NOT NEW.hidden) EXECUTE PROCEDURE notify_dbedit();
+
+INSERT INTO stats_cache VALUES
+ ('chars', (SELECT COUNT(*) FROM chars WHERE NOT hidden)),
+ ('tags', (SELECT COUNT(*) FROM tags WHERE state = 2)),
+ ('traits', (SELECT COUNT(*) FROM traits WHERE state = 2));
+
+CREATE TRIGGER stats_cache_new AFTER INSERT ON chars FOR EACH ROW WHEN (NEW.hidden = FALSE) EXECUTE PROCEDURE update_stats_cache();
+CREATE TRIGGER stats_cache_edit AFTER UPDATE ON chars FOR EACH ROW WHEN (OLD.hidden IS DISTINCT FROM NEW.hidden) EXECUTE PROCEDURE update_stats_cache();
+CREATE TRIGGER stats_cache_new AFTER INSERT ON tags FOR EACH ROW WHEN (NEW.state = 2) EXECUTE PROCEDURE update_stats_cache();
+CREATE TRIGGER stats_cache_edit AFTER UPDATE ON tags FOR EACH ROW WHEN (OLD.state IS DISTINCT FROM NEW.state) EXECUTE PROCEDURE update_stats_cache();
+CREATE TRIGGER stats_cache_new AFTER INSERT ON traits FOR EACH ROW WHEN (NEW.state = 2) EXECUTE PROCEDURE update_stats_cache();
+CREATE TRIGGER stats_cache_edit AFTER UPDATE ON traits FOR EACH ROW WHEN (OLD.state IS DISTINCT FROM NEW.state) EXECUTE PROCEDURE update_stats_cache();
+