WZ2Vk6Jg

1CREATE  TABLE IF NOT EXISTS `sm360_webauto`.`UsedVehicleExteriorColorMapping` (
2  `usedVehicleExteriorColorMappingId` INT NOT NULL ,
3  `regex` VARCHAR(255) NULL ,
4  `lang` VARCHAR(45) NULL ,
5  `usedVehicleExteriorColorId` INT NOT NULL ,
6  `priority` INT NULL DEFAULT 0 ,
7  PRIMARY KEY (`usedVehicleExteriorColorMappingId`) ,
8  INDEX `fk_UsedVehicleExteriorColorMapping_UsedVehicleExteriorColor_idx` (`usedVehicleExteriorColorId` ASC) ,
9  CONSTRAINT `fk_UsedVehicleExteriorColorMapping_UsedVehicleExteriorColor1`
10    FOREIGN KEY (`usedVehicleExteriorColorId` )
11    REFERENCES `sm360_webauto`.`UsedVehicleExteriorColor` (`usedVehicleExteriorColorId` )
12    ON DELETE NO ACTION
13    ON UPDATE NO ACTION)
14ENGINE = InnoDB;
15CREATE  TABLE IF NOT EXISTS `sm360_webauto`.`UsedVehicleInteriorColorMapping` (
16  `usedVehicleInteriorColorMappingId` INT NOT NULL ,
17  `regex` VARCHAR(255) NULL ,
18  `lang` VARCHAR(45) NULL ,
19  `usedVehicleInteriorColorId` INT NOT NULL ,
20  `priority` INT NULL DEFAULT 0 ,
21  PRIMARY KEY (`usedVehicleInteriorColorMappingId`) ,
22  INDEX `fk_UsedVehicleInteriorColorMapping_UsedVehicleInteriorColor_idx` (`usedVehicleInteriorColorId` ASC) ,
23  CONSTRAINT `fk_UsedVehicleInteriorColorMapping_UsedVehicleInteriorColor1`
24    FOREIGN KEY (`usedVehicleInteriorColorId` )
25    REFERENCES `sm360_webauto`.`UsedVehicleInteriorColor` (`usedVehicleInteriorColorId` )
26    ON DELETE NO ACTION
27    ON UPDATE NO ACTION)
28ENGINE = InnoDB