HN5tLPTR

1CREATE  TABLE IF NOT EXISTS `game`.`buildingsBuild` (
2
3  `id` INT NOT NULL AUTO_INCREMENT ,
4
5  `buildingId` INT NOT NULL ,
6
7  `citiesInGameId` INT NULL ,
8
9  PRIMARY KEY (`id`) ,
10
11  INDEX `buildingsBuild_building` (`buildingId` ASC, `citiesInGameId` ASC) ,
12
13  INDEX `buildingsBuild_citiesInGame` () ,
14
15  CONSTRAINT `buildingsBuild_building`
16
17    FOREIGN KEY (`buildingId` , `citiesInGameId` )
18
19    REFERENCES `game`.`building` (`id` , `cityId` )
20
21    ON DELETE NO ACTION
22
23    ON UPDATE NO ACTION,
24
25  CONSTRAINT `buildingsBuild_citiesInGame`
26
27    FOREIGN KEY ()
28
29    REFERENCES `game`.`citiesInGame` ()
30
31    ON DELETE NO ACTION
32
33    ON UPDATE NO ACTION)
34
35ENGINE = InnoDB