migrations/20251219_rename_email_confirmed.sql at 17e3fd87788390e445b4a8a8673656ce14b8984e · lewis.moe/bspds-sandbox

lewis.moe / bspds-sandbox

this repo has no description

bspds-sandbox / migrations / 20251219_rename_email_confirmed.sql

at 17e3fd87788390e445b4a8a8673656ce14b8984e 232 B view raw

1DO $$
2BEGIN
3    IF EXISTS (SELECT 1 FROM information_schema.columns WHERE table_name = 'users' AND column_name = 'email_confirmed') THEN
4        ALTER TABLE users RENAME COLUMN email_confirmed TO email_verified;
5    END IF;
6END $$;