Subversion Repositories SmartDukaan

Rev

Rev 37244 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 37244 Rev 37268
Line 6... Line 6...
6 
-- on strict mode — decide backfill values with the Category team.
 6 
-- on strict mode — decide backfill values with the Category team.
7 
 
 7 
 
8 
ALTER TABLE catalog.model_hot_deal
 8 
ALTER TABLE catalog.model_hot_deal
9 
  ADD COLUMN warranty_months TINYINT NOT NULL,
 9 
  ADD COLUMN warranty_months TINYINT NOT NULL,
10 
  ADD COLUMN item_condition VARCHAR(16) NOT NULL,
 10 
  ADD COLUMN item_condition VARCHAR(16) NOT NULL,
11 
  ADD COLUMN activated TINYINT(1) NOT NULL,
 11 
  ADD COLUMN fresh TINYINT(1) NOT NULL COMMENT 'true = device unused/sealed',
12 
  ADD COLUMN finance_mapping TINYINT(1) NOT NULL,
 12 
  ADD COLUMN finance_mapping TINYINT(1) NOT NULL,
13 
  ADD COLUMN affordability TINYINT(1) NOT NULL;
 13 
  ADD COLUMN affordability TINYINT(1) NOT NULL;