active for currently drive and purchase intention
INSERT INTO `vehicles`.`makes` (`make`, `active`, `currently_drive`, `purchase_intention`, `ffs_code`, `ffs_1349`, `sort_top`) VALUES ('Fisker', 1, 1, 1, 'OTH', 'R', 0), ('Kandi', 1, 1, 1, 'OTH', 'R', 0), ('Karma', 1, 1, 1, 'OTH', 'R', 0);
PURCHASE INTENTION UPDATES/REMOVALS
no removals for currently drive
1 one-off addition of an existing model for purchase intention (3477)
UPDATE `vehicles`.`models` SET `purchase_intention` = '0' WHERE `model_id` in ('3862', '3222', '3498', '3163', '3281', '3282', '3283', '3915', '3472', '3489', '3073', '3403', '3404', '3738', '3442', '3443');
UPDATE `vehicles`.`models` SET `purchase_intention` = '1' WHERE (`model_id` = '3477');
active for currently drive and purchase intention
UPDATE `vehicles`.`models` SET `model` = 'Q3/Q3 Sportsback' WHERE (`model_id` = '3646');
UPDATE `vehicles`.`models` SET `model` = 'X3 (incl. iX3)' WHERE (`model_id` = '3894');
UPDATE `vehicles`.`models` SET `model` = 'C-Class (incl. Grand Coupe)' WHERE (`model_id` = '3198');
UPDATE `vehicles`.`models` SET `model` = 'S60/V60' WHERE (`model_id` = '3720');
active for currently drive and purchase intention
INSERT INTO `vehicles`.`models` (`model`, `active`, `make_id`, `currently_drive`, `purchase_intention`) VALUES ('Tonale', '1', '587', 1, 1),
('A6 e-tron', '1', '589', 1, 1), ('Q4 e-tron', '1', '589', 1, 1), ('iX', '1', '591', 1, 1), ('Lyriq', '1', '593', 1, 1), ('Ocean', '1', '657', 1, 1), ('Other/Discontinued', '1', '657', 1, 1),
('GV60', '1', '603', 1, 1), ('Hummer EV SUV', '1', '605', 1, 1), ('K23', '1', '658', 1, 1), ('K27', '1', '658', 1, 1), ('Other/Discontinued KANDI', '1', '658', 1, 1),
('GS-6', '1', '659', 1, 1), ('Other/Discontinued KARMA', '1', '659', 1, 1), ('Carnival', '1', '613', 1, 1), ('EV6', '1', '613', 1, 1), ('EQE', '1', '622', 1, 1), ('Solterra', '1', '642', 1, 1),
('bZ4X', '1', '645', 1, 1), ('C40', '1', '647', 1, 1);