DROP TABLE IF EXISTS `Zip Codes`;
CREATE  TABLE `Zip Codes` (
   `Zip Code ID` INT(32) NOT NULL ,
   `City` VARCHAR(32) NOT NULL ,
   `State` VARCHAR(32) NOT NULL ,
   `Zip Code` INT(32) NOT NULL ,
   PRIMARY KEY (`Zip Code ID`) ,
   UNIQUE INDEX `Zip CodeUIQUEINDEX` (`Zip Code` ASC) ,
   INDEX `Zip CodeINDEX` (`Zip Code` ASC) ,
   KEY `Zip_Code_IDPublisher1` (`Zip Code ID`),
   CONSTRAINT `Zip_Code_IDPublisher` FOREIGN KEY (`Zip Code ID`) REFERENCES `Publisher` (`Zip Code ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
)
ENGINE = InnoDB;