I made some changes regarding the database which can be seen below.
Mysql
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
CREATE SCHEMA IF NOT EXISTS `BGPstorage` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `BGPstorage` ;
-- -----------------------------------------------------
-- Table `BGPstorage`.`as_detail`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BGPstorage`.`as_detail` (
`AS_No` INT NOT NULL ,
`AS_Name` VARCHAR(45) NULL ,
`AS_Location` VARCHAR(45) NULL ,
PRIMARY KEY (`AS_No`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `BGPstorage`.`peer_detail`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BGPstorage`.`peer_detail` (
`Peer_IP` VARCHAR(45) NOT NULL ,
`Peer_Location` VARCHAR(45) NULL ,
`Peer_IP_Name` VARCHAR(45) NULL ,
`Peer_AS` INT NULL ,
PRIMARY KEY (`Peer_IP`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `BGPstorage`.`update_detail`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BGPstorage`.`update_detail` (
`Update_ID` INT NOT NULL AUTO_INCREMENT ,
`Time` VARCHAR(45) NOT NULL ,
`Type` VARCHAR(45) NULL ,
`Peer_IP` VARCHAR(45) NULL ,
PRIMARY KEY (`Update_ID`, `Time`) ,
INDEX `Peer_IP_PD_idx` (`Peer_IP` ASC) ,
CONSTRAINT `Peer_IP_fk`
FOREIGN KEY (`Peer_IP` )
REFERENCES `BGPstorage`.`peer_detail` (`Peer_IP` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `BGPstorage`.`announce_update`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BGPstorage`.`announce_update` (
`Announce_UpdateID` INT NOT NULL AUTO_INCREMENT ,
`IP` VARCHAR(45) NULL ,
`Subnet` VARCHAR(45) NULL ,
`Update_ID` INT NOT NULL ,
PRIMARY KEY (`Announce_UpdateID`, `Update_ID`) ,
INDEX `Update_ID_fk_idx` (`Update_ID` ASC) ,
CONSTRAINT `Update_ID_fk_announce`
FOREIGN KEY (`Update_ID` )
REFERENCES `BGPstorage`.`update_detail` (`Update_ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `BGPstorage`.`as_path`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BGPstorage`.`as_path` (
`AS_Path_ID` INT NOT NULL AUTO_INCREMENT ,
`Path_Index` INT NULL ,
`AS_No` INT NOT NULL ,
`Update_ID` INT NOT NULL ,
PRIMARY KEY (`AS_Path_ID`, `Update_ID`, `AS_No`) ,
INDEX `AS_No_fk_idx` (`AS_No` ASC) ,
INDEX `Update_ID_fk_as_path_idx` (`Update_ID` ASC) ,
CONSTRAINT `AS_No_fk`
FOREIGN KEY (`AS_No` )
REFERENCES `BGPstorage`.`as_detail` (`AS_No` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `Update_ID_fk_as_path`
FOREIGN KEY (`Update_ID` )
REFERENCES `BGPstorage`.`update_detail` (`Update_ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `BGPstorage`.`withdraw_update`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BGPstorage`.`withdraw_update` (
`Withdraw_UpdateID` INT NOT NULL AUTO_INCREMENT ,
`IP` VARCHAR(45) NULL ,
`Subnet` VARCHAR(45) NULL ,
`Update_ID` INT NOT NULL ,
PRIMARY KEY (`Withdraw_UpdateID`, `Update_ID`) ,
INDEX `Update_ID_fk_idx` (`Update_ID` ASC) ,
CONSTRAINT `Update_ID_fk_withdraw`
FOREIGN KEY (`Update_ID` )
REFERENCES `BGPstorage`.`update_detail` (`Update_ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
USE `BGPstorage` ;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
