1 /* ulogd.pgsql.table, Version 0.1
3 * sample of a postgres table for ulogd
5 * All columns except "id" are optional! Comment all unwanted
6 * columns out, e.g. by prefixing them with '--'
8 * "raw_pkt" is not supported by ulogd_PGSQL
11 CREATE SEQUENCE "seq_ulog";
14 "id" integer DEFAULT nextval('seq_ulog') NOT NULL,
16 "oob_prefix" character varying(32),
17 "oob_time_sec" integer,
18 "oob_time_usec" integer,
20 "oob_in" character varying(32),
21 "oob_out" character varying(32),
23 "raw_mac" character varying(80),
32 "ip_protocol" smallint,
35 /* log IPs as unsigned int32 (default) */
39 /* log IPs as string (--with-pgsql-log-ip-as-string) */
40 -- "ip_saddr" character varying(40),
41 -- "ip_daddr" character varying(40),
43 /* log IPs as inet (--with-pgsql-log-ip-as-string) */
67 "icmp_echoid" integer,
68 "icmp_echoseq" integer,
69 "icmp_gateway" bigint,
70 "icmp_fragmtu" integer,
72 "pwsniff_user" character varying(30),
73 "pwsniff_pass" character varying(30),
78 "local_hostname" character varying(40)