summaryrefslogtreecommitdiffstats
path: root/doc/pgsql-ulogd2-flat.sql
diff options
context:
space:
mode:
authorBob Hockney <zeus@ix.netcom.com>2012-12-19 12:51:16 -0700
committerEric Leblond <eric@regit.org>2012-12-19 23:47:57 +0100
commit09c01f9e3d37417a5b0ceca6e907b3ae36ab62e1 (patch)
treeb403b2c161a78e0ce068344b8731346802481586 /doc/pgsql-ulogd2-flat.sql
parentf191fc8d431c52de17ff1ab7d5d807a14b51e945 (diff)
Add additional ip6 header fields to database scripts
Rename internal keyname ip6.payload_len to remove "_" to facilitate this.
Diffstat (limited to 'doc/pgsql-ulogd2-flat.sql')
-rw-r--r--doc/pgsql-ulogd2-flat.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/doc/pgsql-ulogd2-flat.sql b/doc/pgsql-ulogd2-flat.sql
index 9ff0ec6..6cd2150 100644
--- a/doc/pgsql-ulogd2-flat.sql
+++ b/doc/pgsql-ulogd2-flat.sql
@@ -48,6 +48,12 @@ CREATE TABLE ulog2 (
ip_csum integer default NULL,
ip_id integer default NULL,
ip_fragoff smallint default NULL,
+ ip6_payloadlen bigint default NULL,
+ ip6_priority smallint default NULL,
+ ip6_hoplimit smallint default NULL,
+ ip6_flowlabel bigint default NULL,
+ ip6_fragoff integer default NULL,
+ ip6_fragid bigint default NULL,
raw_label smallint default NULL,
-- timestamp timestamp NOT NULL default 'now',
mac_saddr_str macaddr default NULL,
@@ -140,6 +146,12 @@ CREATE OR REPLACE VIEW ulog AS
ip_csum,
ip_id,
ip_fragoff,
+ ip6_payloadlen,
+ ip6_priority,
+ ip6_hoplimit,
+ ip6_flowlabel,
+ ip6_fragoff,
+ ip6_fragid,
tcp_sport,
tcp_dport,
tcp_seq,