X-Git-Url: https://handorf.org/code/?p=soho-sigint.git;a=blobdiff_plain;f=server%2Fdatabase.sql;fp=server%2Fdatabase.sql;h=3cb69c44820a6df2e7525d4425a8e449f02c8d20;hp=681bc9fec8f699ee88cdd4c36378c436809acd06;hb=d12bfc61e602468e331c843c842135ccac3056c8;hpb=33d0324ec01087bf1d8a919dc2a3000e89534426

diff --git a/server/database.sql b/server/database.sql
index 681bc9f..3cb69c4 100644
--- a/server/database.sql
+++ b/server/database.sql
@@ -1,3 +1,9 @@
+-- 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 */;
@@ -9,6 +15,23 @@
 /*!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`
 --
@@ -103,6 +126,24 @@ CREATE TABLE `knownclients` (
 ) 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`
 --
@@ -127,3 +168,4 @@ CREATE 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