From d372b5a3bba98db6b70579751cac12dc01c23492 Mon Sep 17 00:00:00 2001 From: Eric Leblond Date: Mon, 2 Feb 2009 20:46:32 +0100 Subject: pgsql: fix type of mac_protocol and oob_protocol. The oob_protocol does not fit into a smallint (IPv6 case for example). This patch switches the length of the related field to an integer. --- doc/pgsql-ulogd2-flat.sql | 2 +- doc/pgsql-ulogd2.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/pgsql-ulogd2-flat.sql b/doc/pgsql-ulogd2-flat.sql index e950bbf..cf1a07f 100644 --- a/doc/pgsql-ulogd2-flat.sql +++ b/doc/pgsql-ulogd2-flat.sql @@ -52,7 +52,7 @@ CREATE TABLE ulog2 ( -- timestamp timestamp NOT NULL default 'now', mac_saddr_str macaddr default NULL, mac_daddr_str macaddr default NULL, - oob_protocol smallint default NULL, + oob_protocol integer default NULL, raw_type integer default NULL, mac_str varchar(256) default NULL, tcp_sport integer default NULL, diff --git a/doc/pgsql-ulogd2.sql b/doc/pgsql-ulogd2.sql index da66c85..8f47bf9 100644 --- a/doc/pgsql-ulogd2.sql +++ b/doc/pgsql-ulogd2.sql @@ -75,7 +75,7 @@ CREATE TABLE mac ( _mac_id bigint PRIMARY KEY UNIQUE NOT NULL DEFAULT nextval('mac__id_seq'), mac_saddr macaddr NOT NULL, mac_daddr macaddr default NULL, - mac_protocol smallint default NULL + mac_protocol integer default NULL ) WITH (OIDS=FALSE); CREATE INDEX mac_saddr ON mac(mac_saddr); -- cgit v1.2.3