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
SQL
12 lines
385 B
SQL
-- 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;
|