CREATE TABLE `project_heatmap`.`test_1` (
  `latitude` double(9,7) NOT NULL,
  `longitude` double(9,7) NOT NULL,
  `ssid` varchar(45) NOT NULL,
  `mac` varchar(45) NOT NULL,
  `encryption` tinyint(4) NOT NULL,
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ID`)
);