· 6 years ago · Apr 19, 2019, 07:50 PM
1CREATE TABLE IF NOT EXISTS `details`.`details` (
2 `scan_id` INT(11) NOT NULL AUTO_INCREMENT,
3 `macaddress` VARCHAR(45) NULL DEFAULT NULL,
4 `signalstrength` VARCHAR(45) NULL DEFAULT NULL,
5 `hostname` VARCHAR(45) NULL DEFAULT NULL,
6 `ssid` VARCHAR(45) NULL DEFAULT NULL,
7 `security` VARCHAR(45) NULL DEFAULT NULL,
8 `device_type` VARCHAR(45) NULL DEFAULT NULL,
9 `wifichannel` VARCHAR(45) NULL DEFAULT NULL,
10 `timestamp` DATETIME NULL DEFAULT NULL,
11 PRIMARY KEY (`scan_id`))
12ENGINE = InnoDB
13AUTO_INCREMENT = 47
14DEFAULT CHARACTER SET = utf8mb4