uK0iWm4a

1CREATE TABLE IF NOT EXISTS `ndnManagement`.`face` (
2  `nodeName` VARCHAR(255) NOT NULL,
3  `faceId` INT NOT NULL AUTO_INCREMENT,
4  `localUri` VARCHAR(255) NULL,
5  `remoteUri` VARCHAR(255) NULL,
6  PRIMARY KEY (`nodeName`, `faceId`),
7  INDEX `nodeName_idx` (`nodeName` ASC))
8ENGINE = MyISAM
9	
10CREATE TABLE IF NOT EXISTS `ndnManagement`.`fibEntry` (
11  `namePrefix` VARCHAR(255) NOT NULL,
12  `nodeName` VARCHAR(255) NOT NULL,
13  UNIQUE INDEX `namePrefix_UNIQUE` (`namePrefix` ASC),
14  PRIMARY KEY (`namePrefix`, `nodeName`),
15  INDEX `fk_fibEntry_FIB1_idx` (`nodeName` ASC),
16  CONSTRAINT `fk_fibEntry_FIB1`
17    FOREIGN KEY (`nodeName`)
18    REFERENCES `ndnManagement`.`FIB` (`nodeName`)
19    ON DELETE NO ACTION
20    ON UPDATE NO ACTION)
21ENGINE = InnoDB
22	
23CREATE TABLE IF NOT EXISTS `ndnManagement`.`nextHop` (
24  `namePrefix` VARCHAR(255) NOT NULL,
25  `nodeName` VARCHAR(255) NOT NULL,
26  `faceId` INT NOT NULL,
27  `cost` INT NULL,
28  PRIMARY KEY (`namePrefix`, `nodeName`, `faceId`),
29  INDEX `fk_nextHop_face1_idx` (`faceId` ASC, `nodeName` ASC),
30  CONSTRAINT `fk_nextHop_fibEntry1`
31    FOREIGN KEY (`nodeName` , `namePrefix`)
32    REFERENCES `ndnManagement`.`fibEntry` (`nodeName` , `namePrefix`)
33    ON DELETE NO ACTION
34    ON UPDATE NO ACTION,
35  CONSTRAINT `fk_nextHop_face1`
36    FOREIGN KEY (`faceId` , `nodeName`)
37    REFERENCES `ndnManagement`.`face` (`faceId` , `nodeName`)
38    ON DELETE NO ACTION
39    ON UPDATE NO ACTION)
40ENGINE = InnoDB