Subversion Repositories SmartDukaan
(root)//trunk/profitmandi-dao/src/main/resources/sql/drop_dead_ageing_columns_20260912.sql – Rev 37601
Directory listing | Details | Blame | View Log | RSS feed
Last modification
- Rev 37601 – 26 d 9 h
- Author: amit
- Log message:
- Remove dead stock-ageing fields rootInvoiceDate and oldest/newest_invoice_date
rootInvoiceDate on WarehouseInventoryItem had no writer anywhere in the codebase and
was read only by ScheduledTasks.refreshSnapshotAgeing(), which therefore matched zero
rows on every 30-minute run. oldest/newest_invoice_date on SaholicInventorySnapshot
were written only by that task and read by nothing. Verified on prod: null on all
1,528,669 inventoryItem rows and all 11,686 snapshot rows respectively.
Stock ageing that is actually in use resolves the original external supplier at query
time by serialNumber + supplier.internal = false, and does not read these columns.
originalInventoryItemId is deliberately left alone - it is populated on 157,020 rows.
Includes sql/drop_dead_ageing_columns_20260912.sql to drop the columns. Run it only
after web, fofo and cron are all on this build.
