jam-cloud/db/up/bounced_email_cleanup.sql

3 lines
168 B
SQL

ALTER TABLE generic_state ADD COLUMN bounce_check_at DATE;
UPDATE generic_state SET bounce_check_at = NOW();
ALTER TABLE users ADD COLUMN bounced BOOLEAN DEFAULT FALSE;