Subversion Repositories SmartDukaan
(root)//trunk/profitmandi-dao/src/main/resources/sql/drop_internal_vendor_pricing_20260912.sql – Rev 37607
Go to most recent revision | Directory listing | Details | Blame | View Log | RSS feed
Last modification
- Rev 37607 – 26 d 3 h
- Author: amit
- Log message:
- 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.
