Files
payments/internal/storage/migrations/20-psu-bank-bridges-connection-updated-at.sql
Paul NicolasandGitHub 18897d220c feat(bankbridges): add error type when a connection is disconnected (#531)
* feat(bankbridges): add error type when a connection is disconnected

* website unavailable should be temporary

* remove others

* add updated at column

* fix missing marshal/unmarshal

* add missing user id
2025-09-05 08:15:35 +00:00

3 lines
272 B
SQL

ALTER TABLE psu_bank_bridge_connections ADD COLUMN IF NOT EXISTS updated_at timestamp without time zone;
UPDATE psu_bank_bridge_connections SET updated_at = created_at WHERE updated_at IS NULL;
ALTER TABLE psu_bank_bridge_connections ALTER COLUMN updated_at SET NOT NULL;