Subversion Repositories SmartDukaan

-- Rename activated -> fresh with polarity inversion (fresh = NOT activated).
-- Only for environments that applied the original model_hot_deal_attributes.sql
-- (local dev / saholic-test); the prod script now creates `fresh` directly.
-- Date: 2026-08-08

ALTER TABLE catalog.model_hot_deal
  CHANGE COLUMN activated fresh TINYINT(1) NOT NULL COMMENT 'true = device unused/sealed';
UPDATE catalog.model_hot_deal SET fresh = 1 - fresh;