Subversion Repositories SmartDukaan

Last modification

• Rev 36406 2026-04-27 17:43:00
• Author: amit

• Log message:

  Add scheme_item windowing migration script.
  
  Migrates fofo.scheme_item from composite (scheme_id, catalog_id) PK to
  surrogate id BIGINT, adds audit columns, swaps the old uniqueness to
  the 4-column window key, adds a date-driven lookup index, and installs
  BEFORE INSERT/UPDATE triggers that enforce start<=end, containment in
  parent scheme window, and non-overlap within (catalog_id, scheme_id).
  
  Step 4b drops the legacy UNIQUE scheme_catalog (scheme_id, catalog_id);
  without this the windowing feature is functionally blocked.
  
  Applied on hadb1 in this revision.