You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

12 lines
385 B
MySQL

-- allow pronouns to be null
ALTER TABLE pronouns ADD COLUMN pronouns_nullable_tmp TEXT;
UPDATE pronouns SET pronouns_nullable_tmp = pronouns;
ALTER TABLE pronouns DROP COLUMN pronouns;
ALTER TABLE pronouns RENAME COLUMN pronouns_nullable_tmp TO pronouns;
-- change table name
ALTER TABLE pronouns RENAME TO users;
-- add authentication field
ALTER TABLE users ADD COLUMN auth BLOB;