projects
/
kivitendo-erp.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
c1db61363dc7aafbcd759efb1c14131fb820516b
[kivitendo-erp.git]
/
password_hashing.sql
1
-- @tag: password_hashing
2
-- @description: Explicitely set a password hashing algorithm
3
-- @depends:
4
-- @charset: utf-8
5
UPDATE auth."user"
6
SET password = '{CRYPT}' || password
7
WHERE NOT (password IS NULL)
8
AND (password <> '')
9
AND NOT (password LIKE '{%}%');