| 36796 |
11 d 13 h |
amit |
/trunk/profitmandi-dao/src/main/resources/sql/ |
Add migration: void net-settled stranded status=0 orders
Captures the two ad-hoc cleanups run on hadb1 (the live DB): rejected-txn orders
the PO_REJECTED backfill missed (non-standard refund) -> PO_REJECTED(91), and
non-rejected status=0 orders whose wallet debit was reversed by a non-standard
entry -> refund_timestamp. Net-settled only; net-committed/awaiting-approval POs
left untouched. Temp-table form to avoid locking the live DB. Idempotent. |
|
/trunk/profitmandi-dao/src/main/resources/sql/void_net_settled_stranded_orders.sql
|