/usr/share/httpry/plugins/db_dump.mysql is in httpry-tools 0.1.7-3.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 | --
-- 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;
|