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 not null,
        priority int not null,
        level int not null,
        program text not null,
        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 not null,
11	priority int not null,
12	level int not null,
13	program text not null,
14	message text,
15	PRIMARY KEY (id)
16	);
17