blob: 6bc333138543ce081824accd1e6d6569cc2d6e5f (
plain)
1
2
3
4
5
6
7
8
9
10
|
-- 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;
-- No more 'charedit' permission flag
UPDATE users SET perm = (perm & ~8);
|