-
Notifications
You must be signed in to change notification settings - Fork 2
/
creates.sql
41 lines (34 loc) · 1.66 KB
/
creates.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
create table traffix_hits ( id int auto_increment primary key not null,
ip varchar(40) not null default '',
time_stamp int(11) not null default 0 );
create table traffix_request_log ( id int auto_increment primary key not null,
ip varchar(40) not null default '',
rDNS varchar(60) not null default '',
request_time int(11) not null default 0,
user_agent varchar(250) not null default '',
script varchar(35) not null default '',
request_headers text not null,
method varchar(10) not null default '',
rh_host tinyint(1) not null default 0,
rh_accept tinyint(1) not null default 0,
rh_accept_encoding tinyint(1) not null default 0,
rh_accept_language tinyint(1) not null default 0,
rh_cache_control tinyint(1) not null default 0,
rh_connection tinyint(1) not null default 0,
rh_user_agent tinyint(1) not null default 0,
page_count int not null default 1,
pages_per_minute not null default 0,
analyzed tinyint(1) not null default 0 );
create table traffix_banned_ips ( ip varchar(40) primary key not null );
create table traffix_banned_user_agents ( user_agent varchar(250) primary key not null );
create table traffix_css_file_hits ( id int auto_increment primary key not null,
ip varchar(40) not null default '',
time_stamp int(11) not null default 0 );
create table traffix_js_file_hits ( id int auto_increment primary key not null,
ip varchar(40) not null default '',
time_stamp int(11) not null default 0 );
create table traffix_img_file_hits ( id int auto_increment primary key not null,
ip varchar(40) not null default '',
time_stamp int(11) not null default 0 );
create table traffix_suspicious_traffic ( id int auto_increment primary key not null,
ip varchar(40) not null default '' );