this repo has no description
lewis.moe
1ALTER TABLE channel_verifications ADD COLUMN pending_identifier TEXT;
2
3INSERT INTO channel_verifications (user_id, channel, code, pending_identifier, expires_at)
4SELECT id, 'email', email_confirmation_code, email_pending_verification, email_confirmation_code_expires_at
5FROM users
6WHERE email_confirmation_code IS NOT NULL AND email_confirmation_code_expires_at IS NOT NULL;
7
8ALTER TABLE users
9DROP COLUMN email_confirmation_code,
10DROP COLUMN email_confirmation_code_expires_at,
11DROP COLUMN email_pending_verification;