+-- MySQL dump 10.13 Distrib 5.5.41, for debian-linux-gnu (x86_64)
+--
+-- Host: localhost Database: wireless
+-- ------------------------------------------------------
+-- Server version 5.5.41-0+wheezy1
+
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+--
+-- Table structure for table `beacon`
+--
+
+DROP TABLE IF EXISTS `beacon`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `beacon` (
+ `SSID` varchar(32) NOT NULL DEFAULT '<CLOKED>',
+ `BSSID` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00',
+ `CHANNEL` varchar(4) DEFAULT NULL,
+ `RSSI` int(11) DEFAULT NULL,
+ `LASTSEEN` int(11) DEFAULT NULL,
+ PRIMARY KEY (`SSID`,`BSSID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
--
-- Table structure for table `bssid`
--
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
+--
+-- Table structure for table `probe`
+--
+
+DROP TABLE IF EXISTS `probe`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `probe` (
+ `SSID` varchar(32) NOT NULL DEFAULT '<CLOKED>',
+ `MAC` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00',
+ `BSSID` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00',
+ `CHANNEL` varchar(4) DEFAULT NULL,
+ `RSSI` int(11) DEFAULT NULL,
+ `LASTSEEN` int(11) DEFAULT NULL,
+ PRIMARY KEY (`SSID`,`MAC`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
--
-- Table structure for table `ssid`
--
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+-- Dump completed on 2016-03-01 22:40:22