diff options
author | Eric Leblond <eric@inl.fr> | 2009-02-02 20:46:32 +0100 |
---|---|---|
committer | Eric Leblond <eric@inl.fr> | 2009-02-08 21:08:06 +0100 |
commit | d372b5a3bba98db6b70579751cac12dc01c23492 (patch) | |
tree | 259333749f834f8a3df20d95b6f352b1dac62338 | |
parent | 8f80ed06233bac73891f6cf9d94f1d6d95d2bd40 (diff) |
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.
-rw-r--r-- | doc/pgsql-ulogd2-flat.sql | 2 | ||||
-rw-r--r-- | 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); |