· 6 years ago · Mar 20, 2019, 11:40 AM
1CREATE TABLE IF NOT EXISTS `tool_db`.`MACvendor` (
2 `MAC_vendorID` INT(11) NOT NULL AUTO_INCREMENT,
3 `address` VARCHAR(255) NOT NULL,
4 `vendor` VARCHAR(25) NOT NULL,
5 PRIMARY KEY (`MAC_vendorID`),
6 UNIQUE INDEX `address_UNIQUE` (`address` ASC),
7 UNIQUE INDEX `vendor_UNIQUE` (`vendor` ASC))
8ENGINE = InnoDB