diff options
author | Yorhel <git@yorhel.nl> | 2011-04-08 19:08:45 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-04-08 19:08:45 +0200 |
commit | 50da6516a687442f09a05416ca1daff04d7bbf37 (patch) | |
tree | 9316c817560b30e68e15e6a50631fe6c1c3b47c7 /util/updates | |
parent | c0b8fb4a60dda06bbe306273de8ac0cd92156fd6 (diff) |
Added char/tag/trait stats to database statistics box
Diffstat (limited to 'util/updates')
-rw-r--r-- | util/updates/update_2.20.sql | 13 |
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(); + |