Subversion Repositories SmartDukaan

-- Hot Deal attributes: five mandatory informational fields per deal
-- Date: 2026-08-05
-- DEPLOY-GATED: run on hadb1 only with explicit confirmation.
-- NOT NULL without defaults is intentional (form is mandatory, no defaults);
-- if any rows exist at migration time, backfill them first or the ALTER fails
-- on strict mode — decide backfill values with the Category team.

ALTER TABLE catalog.model_hot_deal
  ADD COLUMN warranty_months TINYINT NOT NULL,
  ADD COLUMN item_condition VARCHAR(16) NOT NULL,
  ADD COLUMN fresh TINYINT(1) NOT NULL COMMENT 'true = device unused/sealed',
  ADD COLUMN finance_mapping TINYINT(1) NOT NULL,
  ADD COLUMN affordability TINYINT(1) NOT NULL;