CREATE UNIQUE INDEX IF NOT EXISTS idx_purchase_receipts_unique_delivery
ON purchase_receipts(order_reference,delivery_note)
WHERE delivery_note<>'';
PRAGMA optimize;