/* 
SQLyog v3.1
Host - localhost : Database - wifimapping
**************************************************************
Server version 3.23.32
*/


/*
Table struture for coverage
*/

drop table if exists `coverage`;
CREATE TABLE `coverage` (
  `MAC` varchar(17) NOT NULL default '',
  `Lat` double default NULL,
  `Lon` double default NULL,
  `Lining` int(11) default NULL
) TYPE=MyISAM;

/*
Table struture for datainfo
*/

drop table if exists `datainfo`;
CREATE TABLE `datainfo` (
  `minlat` double default NULL,
  `minlon` double default NULL,
  `maxlat` double default NULL,
  `maxlon` double default NULL,
  `wiglelastget` bigint(20) default NULL
) TYPE=MyISAM;

/*
Table struture for gpstracks
*/

drop table if exists `gpstracks`;
CREATE TABLE `gpstracks` (
  `gpsid` smallint(6) default NULL,
  `lat` double default NULL,
  `lon` double default NULL,
  `time` bigint(20) default NULL,
  `speed` double default '-1',
  KEY `lat`(`lat`),
  KEY `lon`(`lon`)
) TYPE=MyISAM;

/*
Table struture for kismetmsgs
*/

drop table if exists `kismetmsgs`;
CREATE TABLE `kismetmsgs` (
  `time` bigint(20) default NULL,
  `type` text,
  `msg` blob
) TYPE=MyISAM;

/*
Table struture for nets
*/

drop table if exists `nets`;
CREATE TABLE `nets` (
  `MAC` varchar(17) NOT NULL default '',
  `SSID` varchar(32) default NULL,
  `Name` varchar(50) default NULL,
  `Type` varchar(50) default NULL,
  `FreeNet` tinyint(1) default NULL,
  `PayNet` tinyint(1) default NULL,
  `WEP` tinyint(1) default NULL,
  `DHCP` tinyint(1) default NULL,
  `FirstTime` datetime default NULL,
  `LastUpdated` datetime default NULL,
  `Lat` double default NULL,
  `Lon` double default NULL,
  `Flags` varchar(50) default NULL,
  `Channel` smallint(6) default NULL,
  `Active` tinyint(1) default NULL,
  `BeaconInterval` int(11) default NULL,
  `WiGLEQOS` int(11) default NULL,
  `WiGLEUserFound` varchar(50) default NULL,
  `Comment` mediumtext,
  `Source` text,
  PRIMARY KEY (`MAC`),
  KEY `Lat`(`Lat`),
  KEY `Lon`(`Lon`)
) TYPE=MyISAM;

/*
Table struture for waypoints
*/

drop table if exists `waypoints`;
CREATE TABLE `waypoints` (
  `name` tinytext NOT NULL,
  `description` longtext,
  `icon` int(11) default NULL,
  `lat` double NOT NULL default '0',
  `lon` double NOT NULL default '0',
  `elevation` float default NULL,
  `type` text,
  `comment` blob,
  KEY `lat`(`lat`,`lon`)
) TYPE=MyISAM;