diff options
author | Yorhel <git@yorhel.nl> | 2010-02-01 17:49:26 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2010-02-01 17:49:26 +0100 |
commit | c4afecd1c5135d10a36a3a663837f5b83083bdd2 (patch) | |
tree | f91a376e82a83511851554dcb31b68559c6e2717 /util/sql/all.sql | |
parent | 0c5c9bab2c022e251024cc2bd222bd7585ca6837 (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.sql | 6 |
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(); |