1 -- MySQL dump 10.13 Distrib 5.5.41, for debian-linux-gnu (x86_64)
3 -- Host: localhost Database: wireless
4 -- ------------------------------------------------------
5 -- Server version 5.5.41-0+wheezy1
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19 -- Table structure for table `beacon`
22 DROP TABLE IF EXISTS `beacon`;
23 /*!40101 SET @saved_cs_client = @@character_set_client */;
24 /*!40101 SET character_set_client = utf8 */;
25 CREATE TABLE `beacon` (
26 `SSID` varchar(32) NOT NULL DEFAULT '<CLOKED>',
27 `BSSID` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00',
28 `CHANNEL` varchar(4) DEFAULT NULL,
29 `RSSI` int(11) DEFAULT NULL,
30 `LASTSEEN` int(11) DEFAULT NULL,
31 PRIMARY KEY (`SSID`,`BSSID`)
32 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33 /*!40101 SET character_set_client = @saved_cs_client */;
36 -- Table structure for table `bssid`
39 DROP TABLE IF EXISTS `bssid`;
40 /*!40101 SET @saved_cs_client = @@character_set_client */;
41 /*!40101 SET character_set_client = utf8 */;
42 CREATE TABLE `bssid` (
43 `BSSID` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00',
44 `LASTSEEN` int(11) DEFAULT NULL,
46 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
47 /*!40101 SET character_set_client = @saved_cs_client */;
50 -- Table structure for table `clients`
53 DROP TABLE IF EXISTS `clients`;
54 /*!40101 SET @saved_cs_client = @@character_set_client */;
55 /*!40101 SET character_set_client = utf8 */;
56 CREATE TABLE `clients` (
57 `BSSID` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00',
58 `MAC` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00',
59 `LASTSEEN` int(11) DEFAULT NULL,
60 PRIMARY KEY (`BSSID`,`MAC`)
61 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62 /*!40101 SET character_set_client = @saved_cs_client */;
65 -- Table structure for table `kismet`
68 DROP TABLE IF EXISTS `kismet`;
69 /*!40101 SET @saved_cs_client = @@character_set_client */;
70 /*!40101 SET character_set_client = utf8 */;
71 CREATE TABLE `kismet` (
72 `Network` int(11) DEFAULT NULL,
73 `NetType` varchar(15) DEFAULT NULL,
74 `ESSID` varchar(255) DEFAULT NULL,
75 `BSSID` varchar(17) DEFAULT '00:00:00:00:00:00',
76 `Info` varchar(255) DEFAULT NULL,
77 `Channel` int(11) DEFAULT NULL,
78 `Cloaked` enum('Yes','No') DEFAULT NULL,
79 `WEP` enum('Yes','No') DEFAULT NULL,
80 `Decrypted` enum('Yes','No') DEFAULT NULL,
81 `Maxrate` float DEFAULT NULL,
82 `MaxSeenRate` float DEFAULT NULL,
83 `Beacon` int(11) DEFAULT NULL,
84 `LLC` int(11) DEFAULT NULL,
85 `Data` int(11) DEFAULT NULL,
86 `Crypt` int(11) DEFAULT NULL,
87 `Weak` int(11) DEFAULT NULL,
88 `Total` int(11) DEFAULT NULL,
89 `Carrier` varchar(255) DEFAULT NULL,
90 `Encoding` varchar(255) DEFAULT NULL,
91 `First` varchar(255) DEFAULT NULL,
92 `Last` varchar(255) DEFAULT NULL,
93 `BestQuality` int(11) DEFAULT NULL,
94 `BestSignal` int(11) DEFAULT NULL,
95 `BestNoise` int(11) DEFAULT NULL,
96 `GPSMinLat` float DEFAULT NULL,
97 `GPSMinLon` float DEFAULT NULL,
98 `GPSMinAlt` float DEFAULT NULL,
99 `GPSMinSpd` float DEFAULT NULL,
100 `GPSMaxLat` float DEFAULT NULL,
101 `GPSMaxLon` float DEFAULT NULL,
102 `GPSMaxAlt` float DEFAULT NULL,
103 `GPSMaxSpd` float DEFAULT NULL,
104 `GPSBestLat` float DEFAULT NULL,
105 `GPSBestLon` float DEFAULT NULL,
106 `GPSBestAlt` float DEFAULT NULL,
107 `Datasize` int(11) DEFAULT NULL,
108 `IPType` varchar(25) DEFAULT NULL,
109 `IP` varchar(15) DEFAULT NULL,
110 `id` int(11) NOT NULL AUTO_INCREMENT,
112 ) ENGINE=MyISAM AUTO_INCREMENT=6661 DEFAULT CHARSET=latin1;
113 /*!40101 SET character_set_client = @saved_cs_client */;
116 -- Table structure for table `knownclients`
119 DROP TABLE IF EXISTS `knownclients`;
120 /*!40101 SET @saved_cs_client = @@character_set_client */;
121 /*!40101 SET character_set_client = utf8 */;
122 CREATE TABLE `knownclients` (
123 `MAC` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00',
124 `USER` varchar(255) DEFAULT NULL,
126 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
127 /*!40101 SET character_set_client = @saved_cs_client */;
130 -- Table structure for table `probe`
133 DROP TABLE IF EXISTS `probe`;
134 /*!40101 SET @saved_cs_client = @@character_set_client */;
135 /*!40101 SET character_set_client = utf8 */;
136 CREATE TABLE `probe` (
137 `SSID` varchar(32) NOT NULL DEFAULT '<CLOKED>',
138 `MAC` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00',
139 `BSSID` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00',
140 `CHANNEL` varchar(4) DEFAULT NULL,
141 `RSSI` int(11) DEFAULT NULL,
142 `LASTSEEN` int(11) DEFAULT NULL,
143 PRIMARY KEY (`SSID`,`MAC`)
144 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
145 /*!40101 SET character_set_client = @saved_cs_client */;
148 -- Table structure for table `ssid`
151 DROP TABLE IF EXISTS `ssid`;
152 /*!40101 SET @saved_cs_client = @@character_set_client */;
153 /*!40101 SET character_set_client = utf8 */;
154 CREATE TABLE `ssid` (
155 `SSID` varchar(32) NOT NULL DEFAULT '<CLOKED>',
156 `MAC` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00',
157 `LASTSEEN` int(11) DEFAULT NULL,
158 PRIMARY KEY (`SSID`,`MAC`)
159 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
160 /*!40101 SET character_set_client = @saved_cs_client */;
161 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
163 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
164 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
165 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
166 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
167 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
168 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
169 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
171 -- Dump completed on 2016-03-01 22:40:22