diff options
author | Bob Hockney <zeus@ix.netcom.com> | 2012-12-19 12:51:16 -0700 |
---|---|---|
committer | Eric Leblond <eric@regit.org> | 2012-12-19 23:47:57 +0100 |
commit | 09c01f9e3d37417a5b0ceca6e907b3ae36ab62e1 (patch) | |
tree | b403b2c161a78e0ce068344b8731346802481586 /doc/pgsql-ulogd2-flat.sql | |
parent | f191fc8d431c52de17ff1ab7d5d807a14b51e945 (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.sql | 12 |
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, |