Files
lndhub.go/db/migrations/20230703130000_replace_tx_entry_constraint.up.sql
2023-07-04 14:47:50 +02:00

2 lines
185 B
SQL

alter table transaction_entries drop constraint unique_tx_entry_tuple,
add constraint unique_tx_entry_tuple UNIQUE(user_id, invoice_id, debit_account_id, credit_account_id, entry_type);