summaryrefslogtreecommitdiff
path: root/util/updates/update_2.24.sql
blob: 04d946f19253a433c34abb278d8f0ec7700c494a (plain)
1
2
3
4
5
6
-- Session tokens are stored in the database as a SHA-1 on the actual token
-- now.  Note that this query should be executed only once, otherwise any
-- existing sessions will be invalidated.
-- CREATE EXTENSION pgcrypto;
UPDATE sessions SET token = digest(token, 'sha1');
-- DROP EXTENSION pgcrypto;