SQL file for creating sflow data table

sflow.sql (text/plain), 978 bytes, created by Juan Pedro Escalona Rueda on 2007-04-27 08:08:16 UTC

DROP TABLE IF EXISTS sflow;
CREATE TABLE sflow (
        id int(10) unsigned NOT NULL auto_increment,
	PRIMARY KEY (id),
        agent_ip varchar(64),
        in_int int(4),
        out_int int(4),
        src_mac varchar(16),
        dst_mac varchar(16),
        eth_type varchar(16),
        in_vlan int(4),
        out_vlan int(4),
        src_ip varchar(16),
        dst_ip varchar(16),
        ip_protocol int(3),
        ip_tos varchar(16),
        ip_ttl int(3),
        src_port int(5),
        dst_port int(5),
        tcp_flags varchar(16),
        packet_size int(5),
        ip_size int(5),
        sample_rate int(6),
        src_mask int(2),
        dst_mask int(2),
        my_as int(5),
        src_as int(5),
        src_peer_as int(5),
        dst_as_path_len int(2),
        dst_peer_as int(5),
        dst_as int(5),

	key (agent_ip,in_int,out_int,in_vlan,out_vlan,src_ip,dst_ip,ip_protocol,src_port,dst_port,my_as,src_as,src_peer_as,dst_peer_as,dst_as)
);