aboutsummaryrefslogtreecommitdiffstats
path: root/db/downgrade_0056---0055.sql
blob: 75b69dd4cc1e21e933d2777b085f53ac8f7281d7 (plain)
1
2
3
4
5
6
7
8
9
10
BEGIN;

ALTER TABLE users DROP email_verified;
ALTER TABLE users DROP phone_verified;

DELETE FROM users WHERE email IS NULL;
ALTER TABLE users ALTER email SET NOT NULL;
ALTER TABLE users ADD CONSTRAINT users_email_key UNIQUE (email);

COMMIT;