1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
drop database if exists pmacct;
create database pmacct;
use pmacct;
drop table if exists acct;
create table acct (
ip_src CHAR(39) NOT NULL,
ip_dst CHAR(39) NOT NULL,
as_src INT(4) UNSIGNED NOT NULL,
as_dst INT(4) UNSIGNED NOT NULL,
port_src INT(2) UNSIGNED NOT NULL,
port_dst INT(2) UNSIGNED NOT NULL,
packets INT UNSIGNED NOT NULL,
bytes INT UNSIGNED NOT NULL,
pkt_len_distrib CHAR(10) NOT NULL,
stamp_inserted DATETIME NOT NULL,
stamp_updated DATETIME,
PRIMARY KEY (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, pkt_len_distrib, stamp_inserted)
);
|
