Rev 37608 – Select a default schema before the multi-table deletes MySQL's ...

amit — Sat, 12 Sep 2026 17:57:09 +0530

amit – 1 file(s) modified
Select a default schema before the multi-table deletes

MySQL's 'DELETE alias FROM' form needs a default database even when every table is fully
qualified, so the deletes aborted with 'No database selected' while the backups above them
had already been written. Added USE inventory so the script runs end to end regardless of
how the client is invoked.

Run on hadb1 2026-09-12: 12,372 + 17,241 + 33,252 internal-supplier rows removed, external
pricing untouched at 40,670 / 45,049 / 68,749.

~ /trunk/profitmandi-dao/src/main/resources/sql/drop_internal_vendor_pricing_20260912.sql

Rev 37607 – SQL to remove vendor pricing held against internal suppliers ...

amit — Sat, 12 Sep 2026 17:45:19 +0530

amit – 1 file(s) modified
SQL to remove vendor pricing held against internal suppliers

Nothing reads these since r37603-05: an internal movement is priced from the stock being
moved, resolved to the original external vendor, and receiving no longer validates price for
those movements. A stale row would silently win over the derived price if any lookup were
reintroduced, so they are worse than inert.

Backs every row up to a _bak_ table and deletes against those frozen backups rather than
re-reading supplier.internal, so what is removed is exactly what is preserved. Run only
after the fofo WAR carrying the warehouse-grn-request-items.vm guard (r37606) is live.

+ /trunk/profitmandi-dao/src/main/resources/sql/drop_internal_vendor_pricing_20260912.sql

SmartDukaan – //trunk/profitmandi-dao/src/main/resources/sql/drop_internal_vendor_pricing_20260912.sql

Rev 37608 – Select a default schema before the multi-table deletes MySQL's ...

Rev 37607 – SQL to remove vendor pricing held against internal suppliers ...