diff options
Diffstat (limited to 'pmacct/dbSetupCustom.mysql')
| -rw-r--r-- | pmacct/dbSetupCustom.mysql | 24 |
1 files changed, 14 insertions, 10 deletions
diff --git a/pmacct/dbSetupCustom.mysql b/pmacct/dbSetupCustom.mysql index 9cc8f6b..167ffb1 100644 --- a/pmacct/dbSetupCustom.mysql +++ b/pmacct/dbSetupCustom.mysql @@ -3,14 +3,18 @@ create database pmacct; use pmacct; drop table if 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) + 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) ); + |