Files
MiragenFlow/server/migrations/0013_v1_upload_idempotency.sql

5 lines
221 B
SQL

ALTER TABLE upload_objects ADD COLUMN IF NOT EXISTS idempotency_key TEXT;
CREATE UNIQUE INDEX IF NOT EXISTS upload_objects_owner_idem_uq
ON upload_objects(owner_id, idempotency_key)
WHERE idempotency_key IS NOT NULL;