CREATE TABLE `CarrierHasCountry` (
  `carrierId` INT(10) UNSIGNED NOT NULL,
  `countryId` INT(10) UNSIGNED NOT NULL,
  `shipmentMinTime` INT(10) UNSIGNED NULL DEFAULT NULL,
  `shipmentMaxTime` INT(10) UNSIGNED NULL DEFAULT NULL,
  `shipmentCost` DECIMAL(5,2) UNSIGNED NULL DEFAULT NULL,
  `shipmentPrice` DECIMAL(5,2) UNSIGNED NULL DEFAULT NULL,
  `isActive` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`carrierId`, `countryId`),
  INDEX `FK1_CarrierHasCountry_Country` (`countryId`),
  INDEX `FK2_CarrierHasCountry_Carrier` (`carrierId`),
  CONSTRAINT `FK1_CarrierHasCountry_Country` FOREIGN KEY (`countryId`) REFERENCES `Country` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT `FK2_CarrierHasCountry_Carrier` FOREIGN KEY (`carrierId`) REFERENCES `Carrier` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
)
  COLLATE='utf8_general_ci'
  ENGINE=InnoDB
;
