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;