summaryrefslogtreecommitdiff
path: root/util/sql/all.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-02-01 17:49:26 +0100
committerYorhel <git@yorhel.nl>2010-02-01 17:49:26 +0100
commitc4afecd1c5135d10a36a3a663837f5b83083bdd2 (patch)
treef91a376e82a83511851554dcb31b68559c6e2717 /util/sql/all.sql
parent0c5c9bab2c022e251024cc2bd222bd7585ca6837 (diff)
SQL: Renamed the hidlock_update trigger names
Nothing wrong with using the same name...
Diffstat (limited to 'util/sql/all.sql')
-rw-r--r--util/sql/all.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql
index dee71614..06c1ca7f 100644
--- a/util/sql/all.sql
+++ b/util/sql/all.sql
@@ -29,9 +29,9 @@ CREATE TYPE vn_relation AS ENUM ('seq', 'preq', 'set', 'alt', 'char', 'sid
-- triggers
-CREATE TRIGGER vn_hidlock_update BEFORE UPDATE ON vn FOR EACH ROW EXECUTE PROCEDURE update_hidlock();
-CREATE TRIGGER producers_hidlock_update BEFORE UPDATE ON producers FOR EACH ROW EXECUTE PROCEDURE update_hidlock();
-CREATE TRIGGER releases_hidlock_update BEFORE UPDATE ON releases FOR EACH ROW EXECUTE PROCEDURE update_hidlock();
+CREATE TRIGGER hidlock_update BEFORE UPDATE ON vn FOR EACH ROW EXECUTE PROCEDURE update_hidlock();
+CREATE TRIGGER hidlock_update BEFORE UPDATE ON producers FOR EACH ROW EXECUTE PROCEDURE update_hidlock();
+CREATE TRIGGER hidlock_update BEFORE UPDATE ON releases FOR EACH ROW EXECUTE PROCEDURE update_hidlock();
CREATE TRIGGER users_changes_update AFTER INSERT OR DELETE ON changes FOR EACH ROW EXECUTE PROCEDURE update_users_cache();
CREATE TRIGGER users_votes_update AFTER INSERT OR DELETE ON votes FOR EACH ROW EXECUTE PROCEDURE update_users_cache();