This is an automated email from the git hooks/post-receive script. It was generated because a ref change was pushed to the repository containing the project "Logback: the generic, reliable, fast and flexible logging framework.". The branch, master has been updated via 705c0faec81a065b90a8bdbf6497c122e734aace (commit) from 7172853f27b3339eb1c1790f96f46c0162bdf141 (commit) Those revisions listed above that are new to this repository have not appeared on any other notification email; so we list those revisions in full, below. - Log ----------------------------------------------------------------- http://git.qos.ch/gitweb/?p=logback.git;a=commit;h=705c0faec81a065b90a8bdbf6... http://github.com/ceki/logback/commit/705c0faec81a065b90a8bdbf6497c122e734aa... commit 705c0faec81a065b90a8bdbf6497c122e734aace Author: Ceki Gulcu <ceki@qos.ch> Date: Thu Jan 28 08:11:56 2010 +0100 - added missing hsqldb.sql files. A live version of these files can be found in DBAppenderTestFixture.java in the ch.qos.logback.access.db and ch.qos.logback.classic.db packages under src/test. diff --git a/logback-access/src/main/java/ch/qos/logback/access/db/dialect/hsqldb.sql b/logback-access/src/main/java/ch/qos/logback/access/db/dialect/hsqldb.sql new file mode 100644 index 0000000..c82b677 --- /dev/null +++ b/logback-access/src/main/java/ch/qos/logback/access/db/dialect/hsqldb.sql @@ -0,0 +1,28 @@ +# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender +# +# It is intended for HSQL databases. + + +DROP TABLE access_event_header IF EXISTS; +DROP TABLE access_event IF EXISTS; + +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 NOT NULL IDENTITY); + + +CREATE TABLE access_event_header ( + event_id INT NOT NULL, + header_key VARCHAR(254) NOT NULL, + header_value LONGVARCHAR, + PRIMARY KEY(event_id, header_key), + FOREIGN KEY (event_id) REFERENCES access_event(event_id)); \ No newline at end of file diff --git a/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/hsqldb.sql b/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/hsqldb.sql new file mode 100644 index 0000000..3cdeccc --- /dev/null +++ b/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/hsqldb.sql @@ -0,0 +1,35 @@ +# This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender. +# +# It is intended for HSQL databases. It has been tested on HSQL 1.8.07. + +DROP TABLE logging_event_exception IF EXISTS; +DROP TABLE logging_event_property IF EXISTS; +DROP TABLE logging_event IF EXISTS; + +CREATE TABLE logging_event ( + timestmp BIGINT NOT NULL, + formatted_message LONGVARCHAR NOT NULL, + logger_name VARCHAR(256) NOT NULL, + level_string VARCHAR(256) NOT NULL, + thread_name VARCHAR(256), + reference_flag SMALLINT, + caller_filename VARCHAR(256), + caller_class VARCHAR(256), + caller_method VARCHAR(256), + caller_line CHAR(4), + event_id INT NOT NULL IDENTITY); + + +CREATE TABLE logging_event_property ( + event_id INT NOT NULL, + mapped_key VARCHAR(254) NOT NULL, + mapped_value LONGVARCHAR, + PRIMARY KEY(event_id, mapped_key), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id)); + +CREATE TABLE logging_event_exception ( + event_id INT NOT NULL, + i SMALLINT NOT NULL, + trace_line VARCHAR(256) NOT NULL, + PRIMARY KEY(event_id, i), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id)); \ No newline at end of file ----------------------------------------------------------------------- Summary of changes: .../ch/qos/logback/access/db/dialect/hsqldb.sql | 28 ++++++++++++++++ .../ch/qos/logback/classic/db/dialect/hsqldb.sql | 35 ++++++++++++++++++++ 2 files changed, 63 insertions(+), 0 deletions(-) create mode 100644 logback-access/src/main/java/ch/qos/logback/access/db/dialect/hsqldb.sql create mode 100644 logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/hsqldb.sql hooks/post-receive -- Logback: the generic, reliable, fast and flexible logging framework.