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

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();
 */