8 lines
269 B
MySQL
8 lines
269 B
MySQL
|
-- 001_ledger_idempotency.sql
|
||
|
|
-- Add unique constraint for ledger entry idempotency
|
||
|
|
-- Prevents duplicate postings with same reference_id per ledger
|
||
|
|
|
||
|
|
ALTER TABLE ledger_entries
|
||
|
|
ADD CONSTRAINT ledger_entries_unique_ledger_reference
|
||
|
|
UNIQUE (ledger_id, reference_id);
|