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