2 oob_time_sec INTEGER NOT NULL,
3 oob_time_usec INTEGER NOT NULL,
25 ip6_payloadlen INTEGER,
28 ip6_flowlabel INTEGER,
54 icmpv6_echoid INTEGER,
55 icmpv6_echoseq INTEGER,
59 arp_protocoltype INTEGER,
60 arp_operation INTEGER,
70 CREATE INDEX hits_time ON hits(oob_time_sec);
71 CREATE INDEX hits_prefix ON hits(oob_prefix);
72 CREATE INDEX hits_oob_family ON hits(oob_family);
74 /* Layer 2 - MAC addresses */
75 CREATE INDEX hits_mac_saddr ON hits(mac_saddr_str);
76 CREATE INDEX hits_mac_daddr ON hits(mac_daddr_str);
79 CREATE INDEX hits_ip_saddr ON hits(ip_saddr);
80 CREATE INDEX hits_ip_daddr ON hits(ip_daddr);
81 CREATE INDEX hits_ip_protocol ON hits(ip_protocol);
83 /* Layer 4 protocols */
84 CREATE INDEX hits_tcp_sport ON hits(tcp_sport);
85 CREATE INDEX hits_tcp_dport ON hits(tcp_dport);
86 CREATE INDEX hits_udp_sport ON hits(udp_sport);
87 CREATE INDEX hits_udp_dport ON hits(udp_dport);
88 CREATE INDEX hits_sctp_sport ON hits(sctp_sport);
89 CREATE INDEX hits_sctp_dport ON hits(sctp_dport);
91 CREATE INDEX hits_icmpv6_type ON hits(icmpv6_type);
92 CREATE INDEX hits_icmp_type ON hits(icmp_type);
95 flow_start_sec INTEGER,
96 flow_start_usec INTEGER,
98 flow_end_usec INTEGER,
99 orig_ip_saddr BLOB NOT NULL,
100 orig_ip_saddr_str TEXT NOT NULL,
101 orig_ip_daddr BLOB NOT NULL,
102 orig_ip_daddr_str TEXT NOT NULL,
103 orig_ip_protocol INTEGER NOT NULL,
104 orig_l4_sport INTEGER,
105 orig_l4_dport INTEGER,
106 orig_raw_pktcount INTEGER NOT NULL,
107 orig_raw_pktlen INTEGER NOT NULL,
108 reply_ip_saddr BLOB NOT NULL,
109 reply_ip_saddr_str BLOB NOT NULL,
110 reply_ip_daddr BLOB NOT NULL,
111 reply_ip_daddr_str BLOB NOT NULL,
112 reply_ip_protocol INTEGER NOT NULL,
113 reply_l4_sport INTEGER,
114 reply_l4_dport INTEGER,
115 reply_raw_pktcount INTEGER NOT NULL,
116 reply_raw_pktlen INTEGER NOT NULL,
119 ct_id INTEGER NOT NULL,
120 ct_event INTEGER NOT NULL,
124 CREATE INDEX flows_ip_saddr ON flows(orig_ip_saddr);
125 CREATE INDEX flows_ip_daddr ON flows(orig_ip_daddr);
126 CREATE INDEX flows_ip_protocol ON flows(orig_ip_protocol);