3 -- Host: localhost Database: wifiabuse
4 ---------------------------------------------------------
5 -- Server version 4.0.17
8 -- Table structure for table 'detecteddevices'
11 CREATE TABLE detecteddevices (
12 id int(255) NOT NULL auto_increment,
13 devmac varchar(17) NOT NULL default '',
14 devssid varchar(255) NOT NULL default '',
15 time int(255) NOT NULL default '0',
16 devbsmac varchar(17) default NULL,
18 channel int(3) default NULL,
24 -- Table structure for table 'devices'
27 CREATE TABLE devices (
28 id int(255) NOT NULL auto_increment,
29 devid varchar(255) NOT NULL default '',
30 devip varchar(15) NOT NULL default '',
31 devmac varchar(17) NOT NULL default '',
38 -- Table structure for table 'events'
42 id int(255) NOT NULL auto_increment,
43 offip varchar(15) NOT NULL default '',
44 offmac varchar(17) NOT NULL default '',
46 offrssi int(3) default NULL,
47 offtype varchar(255) NOT NULL default '',
48 time int(255) NOT NULL default '0',
54 -- Table structure for table 'leo'
58 id int(255) NOT NULL auto_increment,
59 leoname varchar(255) NOT NULL default '',
60 leonum varchar(15) NOT NULL default '',
67 -- Table structure for table 'notes'
71 id int(255) NOT NULL auto_increment,
72 ticketid varchar(255) NOT NULL default '',
74 date int(255) default NULL,
80 -- Table structure for table 'offences'
83 CREATE TABLE offences (
84 id int(255) NOT NULL auto_increment,
85 offip varchar(15) NOT NULL default '',
86 offmac varchar(17) NOT NULL default '',
88 offrssi int(3) default NULL,
89 offtype varchar(255) NOT NULL default '',
90 time int(255) NOT NULL default '0',
96 -- Table structure for table 'tickets'
99 CREATE TABLE tickets (
100 id int(255) NOT NULL auto_increment,
101 status char(2) NOT NULL default '',
102 date varchar(255) NOT NULL default '',
103 time varchar(255) NOT NULL default '',
104 devid int(255) NOT NULL default '0',
105 offid int(255) NOT NULL default '0',
106 leoid int(255) NOT NULL default '0',