WebSVN RSS feed – SmartDukaanWed, 06 May 2026 15:13:33 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fmigration_outlet_name_to_fofo_store.sql&max=40& Fri, 01 May 2026 12:15:46 +0530amit<div><strong>amit – 3 file(s) modified</strong><br/>Add outlet_name field to FofoStore entity, set from address.name on store creation<br /> <br /> Adds outlet_name (VARCHAR 255) to FofoStore entity so the store's display<br /> name is persisted directly on fofo_store instead of requiring a join through<br /> retailer_registered_address -> address every time it is needed.<br /> <br /> Sets fofoStore.setOutletName(retailerAddress.getName()) in both creation<br /> paths: RetailerServiceImpl.createFofoStoreCodeByRetailerId (primary) and<br /> RetailerController.createFofoStore (secondary).<br /> <br /> Includes migration SQL script (migration_outlet_name_to_fofo_store.sql) to<br /> ALTER TABLE and backfill existing rows from address.name. Must be run during<br /> low-traffic window - fofo_store is heavily queried and ALTER takes a metadata<br /> lock that blocks all concurrent SELECTs.</div>~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/FofoStore.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/user/RetailerServiceImpl.java<br />+ /trunk/profitmandi-dao/src/main/resources/sql/migration_outlet_name_to_fofo_store.sql<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fmigration_outlet_name_to_fofo_store.sql&rev=36439https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fmigration_outlet_name_to_fofo_store.sql&rev=36439