RKqfuhiK

1ERROR: Error 1215: Cannot add foreign key constraint
2	
3-- -----------------------------------------------------
4    -- Table `mydb`.`MARINE`
5    -- -----------------------------------------------------
6    CREATE TABLE IF NOT EXISTS `mydb`.`MARINE` (
7      `EDIPI` DECIMAL(10) NOT NULL,
8      `LastName` VARCHAR(25) NOT NULL,
9      `FirstName` VARCHAR(25) NOT NULL,
10      `MiddleInitial` CHAR(1) NULL,
11      `Rank` VARCHAR(6) NOT NULL,
12      `MOS` DECIMAL(4) NOT NULL,
13      `BATTLE_SPACE_Company` CHAR(1) NOT NULL,
14      `BATTLE_SPACE_Section/Platoon` VARCHAR(2) NOT NULL,
15      PRIMARY KEY (`EDIPI`),
16      INDEX `fk_MARINE_BATTLE_SPACE1_idx` (`BATTLE_SPACE_Company` ASC, `BATTLE_SPACE_Section/Platoon` ASC),
17      CONSTRAINT `fk_MARINE_BATTLE_SPACE1`
18        FOREIGN KEY (`BATTLE_SPACE_Company` , `BATTLE_SPACE_Section/Platoon`)
19        REFERENCES `mydb`.`BATTLE_SPACE` (`Company` , `Section/Platoon`)
20        ON DELETE NO ACTION
21        ON UPDATE NO ACTION)
22    ENGINE = InnoDB
23	
24CREATE TABLE `battle_space` (
25  `Company` char(1) NOT NULL,
26  `Location` varchar(20) NOT NULL,
27  `Section/Platoon` varchar(2) NOT NULL,
28  PRIMARY KEY (`Company`,`Location`,`Section/Platoon`)
29) ENGINE=InnoDB DEFAULT CHARSET=utf8