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