1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
DROP TABLE IF EXISTS acct_v8;
CREATE TABLE acct_v8 (
agent_id INT(8) NOT NULL DEFAULT 0,
class_id CHAR(16) NOT NULL DEFAULT ' ',
mac_src CHAR(17) NOT NULL DEFAULT '0:0:0:0:0:0',
mac_dst CHAR(17) NOT NULL DEFAULT '0:0:0:0:0:0',
vlan INT(4) NOT NULL DEFAULT 0,
as_src INT(8) NOT NULL DEFAULT 0,
as_dst INT(8) NOT NULL DEFAULT 0,
ip_src CHAR(45) NOT NULL DEFAULT '0.0.0.0',
ip_dst CHAR(45) NOT NULL DEFAULT '0.0.0.0',
port_src INT(4) NOT NULL DEFAULT 0,
port_dst INT(4) NOT NULL DEFAULT 0,
tcp_flags INT(4) NOT NULL DEFAULT 0,
ip_proto CHAR(6) NOT NULL DEFAULT 0,
tos INT(4) NOT NULL DEFAULT 0,
packets INT NOT NULL,
bytes BIGINT NOT NULL,
flows INT NOT NULL DEFAULT 0,
stamp_inserted DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
stamp_updated DATETIME,
PRIMARY KEY (agent_id, class_id, mac_src, mac_dst, vlan, as_src, as_dst, ip_src, ip_dst, port_src, port_dst, ip_proto, tos, stamp_inserted)
);
|
