blob: dafc638a703693689087a3a892fdbed03294d30a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
drop database if exists pmacct;
create database pmacct;
use pmacct;
drop table is exists acct;
create table acct (
ip_src CHAR(15) NOT NULL,
ip_dst CHAR(15) NOT NULL,
src_port INT(2) UNSIGNED NOT NULL,
dst_port INT(2) UNSIGNED NOT NULL,
packets INT UNSIGNED NOT NULL,
bytes BIGINT UNSIGNED NOT NULL,
stamp_inserted DATETIME NOT NULL,
stamp_updated DATETIME,
PRIMARY KEY (ip_src, ip_dst, src_port, dst_port, stamp_inserted)
);
|
