ALTER TABLE `c_website_vehicles`
  CHANGE COLUMN `TransmissionId` `TransmissionId` SMALLINT(2) UNSIGNED NULL DEFAULT NULL AFTER `Miles`,
  ADD COLUMN `EngineDescriptionId` SMALLINT UNSIGNED NULL DEFAULT '' AFTER `EngineDisplacement`;


CREATE TABLE `c_vehicles_lv_engine_descr` (
  `Id` SMALLINT(2) UNSIGNED NOT NULL AUTO_INCREMENT,
  `Nm` CHAR(255) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IdxNm` (`Nm`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

INSERT INTO c_vehicles_lv_engine_descr (nm)
SELECT DISTINCT `EngineDescription` FROM c_website_vehicles ORDER BY 1 ;

UPDATE c_website_vehicles, c_vehicles_lv_engine_descr
SET c_website_vehicles.EngineDescriptionId = c_vehicles_lv_engine_descr.id
WHERE c_website_vehicles.EngineDescription = c_vehicles_lv_engine_descr.nm;

UPDATE c_website_vehicles, c_vehicles_lv_epacity
SET c_website_vehicles.EpaCityId = c_vehicles_lv_epacity.id
WHERE c_website_vehicles.EpaCity = c_vehicles_lv_epacity.nm;

ALTER TABLE `c_website_vehicles`
  ADD INDEX  `IdxEngineDescriptionId` (`EngineDescriptionId`);

UPDATE c_website_vehicles
SET KeyMD5 = MD5(CONCAT(website_id,NewUsed,Make_id,lower(Make),Model_id,lower(model),Trim_id,lower(`trim`),Year, RoundPrice,ExtColorGenericId
  ,lower(ExtColorGeneric),StandardBody_id,lower(StandardBody),TransmissionId,lower(Transmission),dealer_id,lower(dealer_city),lower(dealer_name)
  ,EpaHighwayId,lower(EPAHighway),EpaCityId,lower(EpaCity),EngineDescriptionId,lower(EngineDescription)));




ALTER TABLE `ignite`.`c_website_vehicles`
  drop index    `IdxCube`,
  ADD  INDEX `IdxCube` (`website_id`, `Make_id`, `Model_id`,`Trim_id`, `Year`,RoundPrice, `NewUsed`, ExtColorGenericId,IsSpecial, StandardBody_Id,
    TransmissionId, `dealer_id`,EpaHighwayId,EpaCityId,EngineDescriptionId);