WebSVN RSS feed – SmartDukaanWed, 06 May 2026 15:13:40 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fmigration_scheme_item_windowing.sql&max=40& Mon, 27 Apr 2026 17:43:00 +0530amit<div><strong>amit – 1 file(s) modified</strong><br/>Add scheme_item windowing migration script.<br /> <br /> Migrates fofo.scheme_item from composite (scheme_id, catalog_id) PK to<br /> surrogate id BIGINT, adds audit columns, swaps the old uniqueness to<br /> the 4-column window key, adds a date-driven lookup index, and installs<br /> BEFORE INSERT/UPDATE triggers that enforce start&lt;=end, containment in<br /> parent scheme window, and non-overlap within (catalog_id, scheme_id).<br /> <br /> Step 4b drops the legacy UNIQUE scheme_catalog (scheme_id, catalog_id);<br /> without this the windowing feature is functionally blocked.<br /> <br /> Applied on hadb1 in this revision.</div>+ /trunk/profitmandi-dao/src/main/resources/sql/migration_scheme_item_windowing.sql<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fmigration_scheme_item_windowing.sql&rev=36406https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fmigration_scheme_item_windowing.sql&rev=36406