Author: seb Date: Tue Nov 28 17:39:49 2006 New Revision: 1018 Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/postgresql.sql Log: Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/postgresql.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/postgresql.sql Tue Nov 28 17:39:49 2006 @@ -0,0 +1,33 @@ +# This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender +# +# It is intended for PostgreSQL databases. + +DROP TABLE access_event_exception; +DROP SEQUENCE access_event_id_seq; +DROP TABLE access_event; + +CREATE SEQUENCE access_event_id_seq MINVALUE 1 START 1; + +CREATE TABLE access_event + ( + timestmp BIGINT NOT NULL, + requestURI VARCHAR(254), + requestURL VARCHAR(254), + remoteHost VARCHAR(254), + remoteUser VARCHAR(254), + remoteAddr VARCHAR(254), + protocol VARCHAR(254), + method VARCHAR(254), + serverName VARCHAR(254), + postContent VARCHAR(254), + event_id INT DEFAULT nextval('access_event_id_seq') PRIMARY KEY + ); + +CREATE TABLE access_event_header +( + event_id INT NOT NULL, + header_key VARCHAR(254) NOT NULL, + header_value VARCHAR(1024), + PRIMARY KEY(event_id, header_key), + FOREIGN KEY (event_id) REFERENCES access_event(event_id) + ); \ No newline at end of file