| 37244 |
amit |
1 |
-- Hot Deal attributes: five mandatory informational fields per deal
|
|
|
2 |
-- Date: 2026-08-05
|
|
|
3 |
-- DEPLOY-GATED: run on hadb1 only with explicit confirmation.
|
|
|
4 |
-- NOT NULL without defaults is intentional (form is mandatory, no defaults);
|
|
|
5 |
-- if any rows exist at migration time, backfill them first or the ALTER fails
|
|
|
6 |
-- on strict mode — decide backfill values with the Category team.
|
|
|
7 |
|
|
|
8 |
ALTER TABLE catalog.model_hot_deal
|
|
|
9 |
ADD COLUMN warranty_months TINYINT NOT NULL,
|
|
|
10 |
ADD COLUMN item_condition VARCHAR(16) NOT NULL,
|
| 37268 |
amit |
11 |
ADD COLUMN fresh TINYINT(1) NOT NULL COMMENT 'true = device unused/sealed',
|
| 37244 |
amit |
12 |
ADD COLUMN finance_mapping TINYINT(1) NOT NULL,
|
|
|
13 |
ADD COLUMN affordability TINYINT(1) NOT NULL;
|