diff options
Diffstat (limited to 'util/updates/update_2.21.sql')
| -rw-r--r-- | util/updates/update_2.21.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/util/updates/update_2.21.sql b/util/updates/update_2.21.sql index d90a510d..30ddac60 100644 --- a/util/updates/update_2.21.sql +++ b/util/updates/update_2.21.sql @@ -6,3 +6,12 @@ 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; + |