From b5968956992d8d2ba1628b19c35278e074619b44 Mon Sep 17 00:00:00 2001 From: "/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org" Date: Sat, 12 Apr 2008 11:55:53 +0000 Subject: fix PGSql types Signed-off-by: Eric Leblond --- doc/pgsql-ulogd2.sql | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'doc') diff --git a/doc/pgsql-ulogd2.sql b/doc/pgsql-ulogd2.sql index fc4aa1b..cfef267 100644 --- a/doc/pgsql-ulogd2.sql +++ b/doc/pgsql-ulogd2.sql @@ -78,7 +78,7 @@ CREATE TABLE tcp ( tcp_sport integer default NULL, tcp_dport integer default NULL, tcp_seq bigint default NULL, - tcp_ackseq integer default NULL, + tcp_ackseq bigint default NULL, tcp_window integer default NULL, tcp_urg boolean default NULL, tcp_urgp integer default NULL, @@ -112,8 +112,8 @@ CREATE TABLE icmp ( _icmp_id bigint PRIMARY KEY UNIQUE NOT NULL, icmp_type smallint default NULL, icmp_code smallint default NULL, - icmp_echoid smallint default NULL, - icmp_echoseq smallint default NULL, + icmp_echoid integer default NULL, + icmp_echoseq integer default NULL, icmp_gateway integer default NULL, icmp_fragmtu smallint default NULL ) WITH (OIDS=FALSE); @@ -122,8 +122,8 @@ CREATE TABLE icmpv6 ( _icmpv6_id bigint PRIMARY KEY UNIQUE NOT NULL, icmpv6_type smallint default NULL, icmpv6_code smallint default NULL, - icmpv6_echoid smallint default NULL, - icmpv6_echoseq smallint default NULL, + icmpv6_echoid integer default NULL, + icmpv6_echoseq integer default NULL, icmpv6_csum integer default NULL ) WITH (OIDS=FALSE); @@ -284,7 +284,7 @@ DROP TABLE IF EXISTS nufw; CREATE TABLE nufw ( _nufw_id bigint PRIMARY KEY UNIQUE NOT NULL, username varchar(30) default NULL, - user_id smallint default NULL, + user_id integer default NULL, client_os varchar(100) default NULL, client_app varchar(256) default NULL ) WITH (OIDS=FALSE); @@ -375,7 +375,7 @@ CREATE OR REPLACE FUNCTION INSERT_TCP_FULL( IN tcp_sport integer, IN tcp_dport integer, IN tcp_seq bigint, - IN tcp_ackseq integer, + IN tcp_ackseq bigint, IN tcp_window integer, IN tcp_urg boolean, IN tcp_urgp integer , @@ -468,7 +468,7 @@ CREATE OR REPLACE FUNCTION INSERT_PACKET_FULL( IN tcp_sport integer, IN tcp_dport integer, IN tcp_seq bigint, - IN tcp_ackseq integer, + IN tcp_ackseq bigint, IN tcp_window integer, IN tcp_urg boolean, IN tcp_urgp integer , -- cgit v1.2.3