viewvc.cgi/sysplogd/syslog.sql

-- PostgreSQL schema

drop table log;

CREATE TABLE log (
        id serial,
        timestamp timestamp default now(),
        ip inet not null,
        hostname text not null,
        facility int,
        priority int,
        level int,
        program text,
        message text,
        PRIMARY KEY (id)
);

1	-- PostgreSQL schema
2
3	drop table log;
4
5	CREATE TABLE log (
6	id serial,
7	timestamp timestamp default now(),
8	ip inet not null,
9	hostname text not null,
10	facility int,
11	priority int,
12	level int,
13	program text,
14	message text,
15	PRIMARY KEY (id)
16	);
17