CREATE TABLE IF NOT EXISTS `details`.`details` (
  `scan_id` INT(11) NOT NULL AUTO_INCREMENT,
  `macaddress` VARCHAR(45) NULL DEFAULT NULL,
  `signalstrength` VARCHAR(45) NULL DEFAULT NULL,
  `hostname` VARCHAR(45) NULL DEFAULT NULL,
  `ssid` VARCHAR(45) NULL DEFAULT NULL,
  `security` VARCHAR(45) NULL DEFAULT NULL,
  `device_type` VARCHAR(45) NULL DEFAULT NULL,
  `wifichannel` VARCHAR(45) NULL DEFAULT NULL,
  `timestamp` DATETIME NULL DEFAULT NULL,
  PRIMARY KEY (`scan_id`))
ENGINE = InnoDB
AUTO_INCREMENT = 47
DEFAULT CHARACTER SET = utf8mb4