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 | |
parent | 0c5c9bab2c022e251024cc2bd222bd7585ca6837 (diff) |
SQL: Renamed the hidlock_update trigger names
Nothing wrong with using the same name...
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/all.sql | 6 | ||||
-rw-r--r-- | util/updates/update_2.11.sql | 6 |
2 files changed, 6 insertions, 6 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(); diff --git a/util/updates/update_2.11.sql b/util/updates/update_2.11.sql index 396ea540..0a077bc1 100644 --- a/util/updates/update_2.11.sql +++ b/util/updates/update_2.11.sql @@ -35,9 +35,9 @@ ALTER TABLE changes ADD COLUMN ilock boolean NOT NULL DEFAULT FALSE; \i util/sql/func.sql -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 notify_pm AFTER INSERT ON threads_posts FOR EACH ROW EXECUTE PROCEDURE notify_pm(); |