blob: 30ddac60f89f3c3fb9506d192c8237e52a7bd134 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
-- New resolution added on index 5
UPDATE releases_rev SET resolution = resolution + 1 WHERE resolution >= 5;
-- Old MD5 passwords can't be used anymore, so delete them
UPDATE users SET passwd = '' WHERE salt = '';
-- Email addresses now have to be confirmed upon registration
-- This boolean column won't really checked on login, it's just here for
-- administration purposes. The passwd/salt columns contain a
-- password-reset-token, so the user won't be able to login directly after
-- registration anyway.
ALTER TABLE users ADD COLUMN email_confirmed boolean NOT NULL DEFAULT FALSE;
UPDATE users SET email_confirmed = TRUE;
|
