Files
evening_detective_server/migrations/20260918130000_add_review_reminder.sql
2026-09-18 01:37:48 +07:00

14 lines
479 B
SQL

-- +goose Up
ALTER TABLE teams
ADD COLUMN review_reminder_sent_at TIMESTAMPTZ,
ADD COLUMN review_reminder_attempts INTEGER NOT NULL DEFAULT 0,
ADD COLUMN review_reminder_next_attempt_at TIMESTAMPTZ,
ADD COLUMN review_reminder_error TEXT NOT NULL DEFAULT '';
-- +goose Down
ALTER TABLE teams
DROP COLUMN review_reminder_sent_at,
DROP COLUMN review_reminder_attempts,
DROP COLUMN review_reminder_next_attempt_at,
DROP COLUMN review_reminder_error;