chatdesk-ui/auth_v2.169.0/migrations/20210722035447_adds_confirm...

5 lines
212 B
SQL

-- adds confirmed at
ALTER TABLE {{ index .Options "Namespace" }}.users
ADD COLUMN IF NOT EXISTS confirmed_at timestamptz GENERATED ALWAYS AS (LEAST (users.email_confirmed_at, users.phone_confirmed_at)) STORED;