diff options
| author | Yorhel <git@yorhel.nl> | 2015-05-13 11:44:04 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2015-05-13 11:44:04 +0200 |
| commit | 2a783edbab51aa490884814c9c45f919886d70ef (patch) | |
| tree | 98651556b6bd7f8b3e059381aa1a968cad624161 /util/sql/all.sql | |
| parent | 339599d9f8afaa61862836d2c89ce0d76045f122 (diff) | |
Add staff statistic to main menu
Diffstat (limited to 'util/sql/all.sql')
| -rw-r--r-- | util/sql/all.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql index c4afb502..1377e3ad 100644 --- a/util/sql/all.sql +++ b/util/sql/all.sql @@ -52,6 +52,8 @@ CREATE TRIGGER stats_cache_new AFTER INSERT ON releases CREATE TRIGGER stats_cache_edit AFTER UPDATE ON releases FOR EACH ROW WHEN (OLD.hidden IS DISTINCT FROM NEW.hidden) EXECUTE PROCEDURE update_stats_cache(); 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 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(); 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(); @@ -132,6 +134,7 @@ INSERT INTO stats_cache (section, count) VALUES ('producers', 0), ('releases', 0), ('chars', 0), + ('staff', 0), ('tags', 0), ('traits', 0), ('threads', 0), |