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
42
43
44
45
46
47
48
49
|
--
-- MySQL databse creation script for db_dump.pm
--
-- !!! Warning: This script will delete all pre-existing data !!!
--
-- This is a rather rudimentary database structure, but it ought
-- to at least provide a decent starting point.
--
--
-- Create httpry database; wipe database if it already exists
--
DROP DATABASE IF EXISTS httpry;
CREATE DATABASE httpry;
USE httpry;
--
-- Create client_data table; wipe table if it already exists
--
DROP TABLE IF EXISTS client_data;
CREATE TABLE client_data (
id int(10) unsigned NOT NULL auto_increment,
timestamp datetime NOT NULL default '0000-00-00 00:00:00',
pktstamp datetime NOT NULL default '0000-00-00 00:00:00',
src_ip varchar(45) NOT NULL default '',
dst_ip varchar(45) NOT NULL default '',
hostname varchar(255) NOT NULL default '',
uri varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=InnoDB;
--
-- Create server_data table; wipe table if it already exists
--
DROP TABLE IF EXISTS server_data;
CREATE TABLE server_data (
id int(10) unsigned NOT NULL auto_increment,
timestamp datetime NOT NULL default '0000-00-00 00:00:00',
pktstamp datetime NOT NULL default '0000-00-00 00:00:00',
src_ip varchar(45) NOT NULL default '',
dst_ip varchar(45) NOT NULL default '',
status_code varchar(255) NOT NULL default '',
reason_phrase varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=InnoDB;
|
