-- MySQL dump 9.08
--
-- Host: localhost    Database: wifiabuse
---------------------------------------------------------
-- Server version	4.0.17

--
-- Table structure for table 'detecteddevices'
--

CREATE TABLE detecteddevices (
  id int(255) NOT NULL auto_increment,
  devmac varchar(17) NOT NULL default '',
  devssid varchar(255) NOT NULL default '',
  time int(255) NOT NULL default '0',
  devbsmac varchar(17) default NULL,
  rates blob,
  channel int(3) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

--
-- Table structure for table 'devices'
--

CREATE TABLE devices (
  id int(255) NOT NULL auto_increment,
  devid varchar(255) NOT NULL default '',
  devip varchar(15) NOT NULL default '',
  devmac varchar(17) NOT NULL default '',
  devmap blob,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

--
-- Table structure for table 'events'
--

CREATE TABLE events (
  id int(255) NOT NULL auto_increment,
  offip varchar(15) NOT NULL default '',
  offmac varchar(17) NOT NULL default '',
  offos blob,
  offrssi int(3) default NULL,
  offtype varchar(255) NOT NULL default '',
  time int(255) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

--
-- Table structure for table 'leo'
--

CREATE TABLE leo (
  id int(255) NOT NULL auto_increment,
  leoname varchar(255) NOT NULL default '',
  leonum varchar(15) NOT NULL default '',
  leoemail blob,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

--
-- Table structure for table 'notes'
--

CREATE TABLE notes (
  id int(255) NOT NULL auto_increment,
  ticketid varchar(255) NOT NULL default '',
  note blob,
  date int(255) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

--
-- Table structure for table 'offences'
--

CREATE TABLE offences (
  id int(255) NOT NULL auto_increment,
  offip varchar(15) NOT NULL default '',
  offmac varchar(17) NOT NULL default '',
  offos blob,
  offrssi int(3) default NULL,
  offtype varchar(255) NOT NULL default '',
  time int(255) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

--
-- Table structure for table 'tickets'
--

CREATE TABLE tickets (
  id int(255) NOT NULL auto_increment,
  status char(2) NOT NULL default '',
  date varchar(255) NOT NULL default '',
  time varchar(255) NOT NULL default '',
  devid int(255) NOT NULL default '0',
  offid int(255) NOT NULL default '0',
  leoid int(255) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

