-- An account is identified by an email address. The column keeps its values: an account made -- before addresses were asked for keeps the name it has, and logs in with it. Its uniqueness -- (NOCASE) goes with the column. ALTER TABLE users RENAME COLUMN username TO email;