CREATE TABLE ulog (
CREATE TABLE IF NOT EXISTS ulog (
raw_mac VARCHAR(80),
oob_time_sec INT UNSIGNED,
oob_time_usec INT UNSIGNED,
ip_saddr INT UNSIGNED,
oob_prefix VARCHAR(32),
ip_daddr INT UNSIGNED,
oob_in VARCHAR(32),
oob_out VARCHAR(32),
ip_saddr VARCHAR(16),
ip_daddr VARCHAR(16),
ip_protocol TINYINT UNSIGNED,
ip_totlen SMALLINT UNSIGNED,
tcp_sport SMALLINT UNSIGNED,
memset(&addr, 0, sizeof(addr));
addr.s_addr = ntohl(res->value.ui32);
ipaddr = inet_ntoa(addr);
sqlite3_bind_text(p_stmt,col_counter,ipaddr,strlen(ipaddr),SQLITE_STATIC);
sqlite3_bind_text(p_stmt,col_counter,ipaddr,strlen(ipaddr),SQLITE_TRANSIENT);
break;
#endif /* IP_AS_STRING */
/* EVIL: fallthrough when logging IP as u_int32_t */