max / makenotwork

260 B · 5 lines History Blame Raw

1	-- Add unique constraint on pending_s3_deletions to prevent duplicate enqueue.
2	-- ON CONFLICT DO NOTHING makes this safe for concurrent insertions.
3	CREATE UNIQUE INDEX IF NOT EXISTS idx_pending_s3_deletions_key_bucket
4	ON pending_s3_deletions (s3_key, bucket);
5