]> wagnertech.de Git - mfinanz.git/blob - sql/Pg-upgrade2-auth/password_hashing.sql
Merge branch 'master' of github.com:kivitendo/kivitendo-erp
[mfinanz.git] / sql / Pg-upgrade2-auth / password_hashing.sql
1 -- @tag: password_hashing
2 -- @description: Explicitely set a password hashing algorithm
3 -- @depends:
4 UPDATE auth."user"
5   SET password = '{CRYPT}' || password
6   WHERE NOT (password IS NULL)
7     AND (password <> '')
8     AND NOT (password LIKE '{%}%');