Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/resources/sql/ – Rev 36796

Last modification

Rev 36796 2026-06-08 13:44:16
Author: amit
Log message:
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.

Path	Last modification			Log	RSS
add_idx_account_statement_perf.sql	36691	55 d 5 h	amit	Log	RSS
add_idx_uwh_timestamp_reftype.sql	36330	90 d 7 h	amit	Log	RSS
add_irn_error_message.sql	36675	56 d 3 h	amit	Log	RSS
add_reference_to_offer_scheme.sql	36451	79 d 5 h	amit	Log	RSS
add_uk_fofo_order_fofo_invoice.sql	36362	89 d 3 h	amit	Log	RSS
alter_monitor_type_normal_to_base.sql	36443	80 d 7 h	amit	Log	RSS
backfill_po_rejected_orders.sql	36790	45 d 10 h	amit	Log	RSS
catalog_monitor_type.sql	36441	80 d 9 h	amit	Log	RSS
cleanup_abandoned_draft_orders.sql	36795	42 d 10 h	amit	Log	RSS
cleanup_phantom_payment_failed.sql	36795	42 d 10 h	amit	Log	RSS
create_cron_batch_tables.sql	36305	92 d 15 h	amit	Log	RSS
fix_invoice_receiveDate_from_purchase.sql	36314	91 d 11 h	amit	Log	RSS
flagship_credit_schema.sql	36557	65 d 17 h	amit	Log	RSS
mail_outbox.sql	35956	135 d 10 h	amit	Log	RSS
migration_bulk_order_approval_report_menu.sql	35966	135 d 9 h	amit	Log	RSS
migration_dn_status_retailer_ack.sql	36446	79 d 23 h	amit	Log	RSS
migration_dummy_warehouses.sql	36309	91 d 23 h	amit	Log	RSS
migration_gst_to_fofo_store.sql	35908	140 d 12 h	amit	Log	RSS
migration_imei_net_margin_modal_api.sql	36407	84 d 3 h	amit	Log	RSS
migration_lead_live_location.sql	36711	54 d 4 h	ranu	Log	RSS
migration_lead_visit_approval.sql	36642	59 d 3 h	ranu	Log	RSS
migration_menu_icons.sql	36567	65 d 9 h	amit	Log	RSS
migration_order_wallet_adjustment.sql	36713	54 d 4 h	amit	Log	RSS
migration_outlet_name_to_fofo_store.sql	36439	80 d 11 h	amit	Log	RSS
migration_running_balance_wallet_history.sql	36515	71 d 4 h	amit	Log	RSS
migration_scheme_item_windowing.sql	36406	84 d 5 h	amit	Log	RSS
migration_unsettled_purchase_return_menu.sql	36318	91 d 4 h	aman	Log	RSS
model_flagship_schema.sql	36565	65 d 9 h	amit	Log	RSS
reconcile_inventory_snapshot.sql	36512	71 d 7 h	amit	Log	RSS
solr_update_failures.sql	35547	187 d 7 h	amit	Log	RSS
void_net_settled_stranded_orders.sql	36796	42 d 9 h	amit	Log	RSS