1 files changed, 4 insertions, 6 deletions
diff --git a/util/updates/update_wip_lists.sql b/util/updates/update_wip_lists.sql
index 0ff7a452..7d8c4b82 100644
--- a/util/updates/update_wip_lists.sql
+++ b/util/updates/update_wip_lists.sql
@@ -118,14 +118,12 @@ DROP FUNCTION update_vnpopularity();
 ALTER TABLE users ADD COLUMN c_vns  integer NOT NULL DEFAULT 0;
 ALTER TABLE users ADD COLUMN c_wish integer NOT NULL DEFAULT 0;
 
-\i util/sql/func.sql
-\i util/sql/perms.sql
-
 DROP TRIGGER users_votes_update ON votes;
+DROP TRIGGER update_vnlist_rlist ON rlists;
 
-CREATE TRIGGER ulist_labels_create AFTER INSERT ON users FOR EACH ROW EXECUTE PROCEDURE ulist_labels_create();
-CREATE TRIGGER ulist_voted_label AFTER INSERT OR UPDATE ON ulist_vns FOR EACH ROW EXECUTE PROCEDURE ulist_voted_label();
-CREATE CONSTRAINT TRIGGER update_vnlist_rlist AFTER DELETE ON ulist_vns DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE update_vnlist_rlist();
+\i util/sql/func.sql
+\i util/sql/triggers.sql
+\i util/sql/perms.sql
 
 \timing
 SELECT update_users_ulist_stats(NULL);