X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Ffunctions%2Fuser_password.sql;h=0e86be8d03bcd988d4b2d12836c1768be782a48d;hp=c15cc00226acf607ac4eb5e15d248560014d4265;hb=e71f5648d2823f89024c52b77f9ab04d23a75a2d;hpb=9f873f796fe945835f748bafecb3e2ac9ef0b014

diff --git a/database/functions/user_password.sql b/database/functions/user_password.sql
index c15cc00..0e86be8 100644
--- a/database/functions/user_password.sql
+++ b/database/functions/user_password.sql
@@ -18,5 +18,6 @@ $_X$ LANGUAGE plpgsql;
 
 /*
 alter table users alter COLUMN password drop not null ;
-CREATE TRIGGER user_password BEFORE UPDATE OR INSERT ON users FOR EACH ROW EXECUTE PROCEDURE user_password()
+DROP TRIGGER user_password ON users;
+CREATE TRIGGER user_password BEFORE INSERT OR UPDATE OF password ON users FOR EACH ROW EXECUTE PROCEDURE user_password();
 */