- logback-dev - mailman3.qos.ch

svn commit: r1021 - logback/trunk/logback-core/src/test/java/ch/qos/logback/core/util
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 20:29:30 2006 New Revision: 1021 Modified: logback/trunk/logback-core/src/test/java/ch/qos/logback/core/util/StatusPrinterTest.java Log: silent tests are beautiful Modified: logback/trunk/logback-core/src/test/java/ch/qos/logback/core/util/StatusPrinterTest.java ============================================================================== --- logback/trunk/logback-core/src/test/java/ch/qos/logback/core/util/StatusPrinterTest.java (original) +++ logback/trunk/logback-core/src/test/java/ch/qos/logback/core/util/StatusPrinterTest.java Tue Nov 28 20:29:30 2006 @@ -95,7 +95,6 @@ context.getStatusManager().add(s2); StatusPrinter.print(context); String result = outputStream.toString(); - System.out.println(result); assertTrue(result.contains("|-ERROR in testWithException")); assertTrue(result.contains("+ INFO in testWithException")); assertTrue(result.contains("ch.qos.logback.core.util.StatusPrinterTest.testWithException"));

1 0

[continuum] BUILD FAILURE: Logback Access Module
by John Noreplai 28 Nov '06

28 Nov '06

Online report : http://localhost:8090/continuum/servlet/continuum/target/ProjectBuild.vm/vi… Build statistics: State: Failed Previous State: Failed Started at: Tue, 28 Nov 2006 20:21:52 +0100 Finished at: Tue, 28 Nov 2006 20:22:04 +0100 Total time: 12s Build Trigger: Forced Exit code: 1 Building machine hostname: pixie Operating system : Linux(unknown) Java version : 1.5.0_08(Sun Microsystems Inc.) Changes No files changed **************************************************************************** Output: **************************************************************************** [INFO] Scanning for projects... [INFO] ---------------------------------------------------------------------------- [INFO] Building Logback Access Module [INFO] task-segment: [clean, install] [INFO] ---------------------------------------------------------------------------- [INFO] [clean:clean] [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/classes [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/test-classes [INFO] [resources:resources] [INFO] Using default encoding to copy filtered resources. [INFO] [compiler:compile] Compiling 56 source files to /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/classes [INFO] [resources:testResources] [INFO] Using default encoding to copy filtered resources. [INFO] [compiler:testCompile] Compiling 22 source files to /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/test-classes [INFO] [surefire:test] [INFO] Surefire report directory: /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/surefire-reports ------------------------------------------------------- T E S T S ------------------------------------------------------- Running ch.qos.logback.access.db.DBAppenderTest [Server@3c6f579]: [Thread[main,5,main]]: checkRunning(false) entered [Server@3c6f579]: [Thread[main,5,main]]: checkRunning(false) exited [Server@3c6f579]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@3c6f579]: [Thread[main,5,main]]: checkRunning(false) entered [Server@3c6f579]: [Thread[main,5,main]]: checkRunning(false) exited [Server@3c6f579]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) [Server@2ca6d51e]: [Thread[main,5,main]]: checkRunning(false) entered [Server@2ca6d51e]: [Thread[main,5,main]]: checkRunning(false) exited [Server@2ca6d51e]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@2ca6d51e]: [Thread[main,5,main]]: checkRunning(false) entered [Server@2ca6d51e]: [Thread[main,5,main]]: checkRunning(false) exited [Server@2ca6d51e]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) [Server@12b7eea]: [Thread[main,5,main]]: checkRunning(false) entered [Server@12b7eea]: [Thread[main,5,main]]: checkRunning(false) exited [Server@12b7eea]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@12b7eea]: [Thread[main,5,main]]: checkRunning(false) entered [Server@12b7eea]: [Thread[main,5,main]]: checkRunning(false) exited [Server@12b7eea]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) Tests run: 3, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.657 sec <<< FAILURE! Running ch.qos.logback.access.jetty.JettyBasicTest 2006-11-28 20:22:03.232::INFO: Logging to STDERR via org.mortbay.log.StdErrLog |-WARN in ch.qos.logback.access.jetty.RequestLogImpl@60f47bf5 - filename property not set. Assuming [null/etc/logback-access.xml] |-ERROR in ch.qos.logback.access.jetty.RequestLogImpl@60f47bf5 - [null/etc/logback-access.xml] does not exist |-INFO in ch.qos.logback.access.jetty.RequestLogImpl@60f47bf5 - RequestLog added to RequestLogRegistry with name: LogbackRequestLog 2006-11-28 20:22:03.279::INFO: jetty-6.0.x 2006-11-28 20:22:03.350::INFO: Started SelectChannelConnector @ 0.0.0.0:1234 28/11/2006:20:22:03 +0100 localhost 127.0.0.1 Tests run: 2, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 1.282 sec <<< FAILURE! Running ch.qos.logback.access.filter.AccessStatsTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec Running ch.qos.logback.access.pattern.ConverterTest Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.03 sec Running ch.qos.logback.access.filter.StatsByDayTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.012 sec Running ch.qos.logback.access.net.URLEvaluatorTest Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.015 sec Running ch.qos.logback.access.net.SocketAppenderTest Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.129 sec Results : Tests run: 28, Failures: 0, Errors: 2, Skipped: 0 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] There are test failures. [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ [INFO] Total time: 10 seconds [INFO] Finished at: Tue Nov 28 20:22:04 CET 2006 [INFO] Final Memory: 12M/142M [INFO] ------------------------------------------------------------------------ ****************************************************************************

1 0

[continuum] BUILD FAILURE: Logback Access Module
by John Noreplai 28 Nov '06

28 Nov '06

Online report : http://localhost:8090/continuum/servlet/continuum/target/ProjectBuild.vm/vi… Build statistics: State: Failed Previous State: Ok Started at: Tue, 28 Nov 2006 20:20:18 +0100 Finished at: Tue, 28 Nov 2006 20:20:28 +0100 Total time: 9s Build Trigger: Schedule Exit code: 1 Building machine hostname: pixie Operating system : Linux(unknown) Java version : 1.5.0_08(Sun Microsystems Inc.) Changes seb minor fix /logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net/SerializationPerfTest.java **************************************************************************** Output: **************************************************************************** [INFO] Scanning for projects... [INFO] ---------------------------------------------------------------------------- [INFO] Building Logback Access Module [INFO] task-segment: [clean, install] [INFO] ---------------------------------------------------------------------------- [INFO] [clean:clean] [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/classes [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/test-classes [INFO] [resources:resources] [INFO] Using default encoding to copy filtered resources. [INFO] [compiler:compile] Compiling 56 source files to /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/classes [INFO] [resources:testResources] [INFO] Using default encoding to copy filtered resources. [INFO] [compiler:testCompile] Compiling 22 source files to /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/test-classes [INFO] [surefire:test] [INFO] Surefire report directory: /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/surefire-reports ------------------------------------------------------- T E S T S ------------------------------------------------------- Running ch.qos.logback.access.db.DBAppenderTest [Server@658fb1f7]: [Thread[main,5,main]]: checkRunning(false) entered [Server@658fb1f7]: [Thread[main,5,main]]: checkRunning(false) exited [Server@658fb1f7]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@658fb1f7]: [Thread[main,5,main]]: checkRunning(false) entered [Server@658fb1f7]: [Thread[main,5,main]]: checkRunning(false) exited [Server@658fb1f7]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) [Server@2aca0115]: [Thread[main,5,main]]: checkRunning(false) entered [Server@2aca0115]: [Thread[main,5,main]]: checkRunning(false) exited [Server@2aca0115]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@2aca0115]: [Thread[main,5,main]]: checkRunning(false) entered [Server@2aca0115]: [Thread[main,5,main]]: checkRunning(false) exited [Server@2aca0115]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) [Server@4e99353f]: [Thread[main,5,main]]: checkRunning(false) entered [Server@4e99353f]: [Thread[main,5,main]]: checkRunning(false) exited [Server@4e99353f]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@4e99353f]: [Thread[main,5,main]]: checkRunning(false) entered [Server@4e99353f]: [Thread[main,5,main]]: checkRunning(false) exited [Server@4e99353f]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.826 sec Running ch.qos.logback.access.jetty.JettyBasicTest 2006-11-28 20:20:26.346::INFO: Logging to STDERR via org.mortbay.log.StdErrLog 2006-11-28 20:20:26.388::INFO: jetty-6.0.x |-WARN in ch.qos.logback.access.jetty.RequestLogImpl@1fd0fafc - filename property not set. Assuming [null/etc/logback-access.xml] |-ERROR in ch.qos.logback.access.jetty.RequestLogImpl@1fd0fafc - [null/etc/logback-access.xml] does not exist |-INFO in ch.qos.logback.access.jetty.RequestLogImpl@1fd0fafc - RequestLog added to RequestLogRegistry with name: LogbackRequestLog 2006-11-28 20:20:26.454::INFO: Started SelectChannelConnector @ 0.0.0.0:1234 28/11/2006:20:20:26 +0100 localhost 127.0.0.1 Tests run: 2, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 1.264 sec <<< FAILURE! Running ch.qos.logback.access.filter.AccessStatsTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.01 sec Running ch.qos.logback.access.pattern.ConverterTest Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.021 sec Running ch.qos.logback.access.filter.StatsByDayTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec Running ch.qos.logback.access.net.URLEvaluatorTest Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.013 sec Running ch.qos.logback.access.net.SocketAppenderTest Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.136 sec Results : Tests run: 28, Failures: 0, Errors: 1, Skipped: 0 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] There are test failures. [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ [INFO] Total time: 8 seconds [INFO] Finished at: Tue Nov 28 20:20:27 CET 2006 [INFO] Final Memory: 12M/142M [INFO] ------------------------------------------------------------------------ ****************************************************************************

1 0

svn commit: r1020 - logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 20:05:25 2006 New Revision: 1020 Modified: logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net/SerializationPerfTest.java Log: minor fix Modified: logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net/SerializationPerfTest.java ============================================================================== --- logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net/SerializationPerfTest.java (original) +++ logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net/SerializationPerfTest.java Tue Nov 28 20:05:25 2006 @@ -89,7 +89,7 @@ total /= (1000);//nanos -> micros System.out.println("Loop done : average time = " + total / loopNumber + " microsecs after " + loopNumber + " writes."); - //average time: 26-30 microsec = 0.034 milis + //average time: 26-30 microsec = 0.030 millis } private AccessEvent buildNewAccessEvent() {

1 0

svn commit: r1019 - logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 17:41:06 2006 New Revision: 1019 Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql Log: end of script moving around Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql ============================================================================== --- logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql (original) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql Tue Nov 28 17:41:06 2006 @@ -1,38 +1,51 @@ -# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender. +# This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender. # # It is intended for MySQL databases. It has been tested on MySQL 5.0.22 with # INNODB tables. BEGIN; -DROP TABLE IF EXISTS access_event_header; -DROP TABLE IF EXISTS access_event; +DROP TABLE IF EXISTS logging_event_property; +DROP TABLE IF EXISTS logging_event_exception; +DROP TABLE IF EXISTS logging_event; COMMIT; + BEGIN; -CREATE TABLE access_event +CREATE TABLE logging_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), + timestmp BIGINT NOT NULL, + formatted_message TEXT NOT NULL, + logger_name VARCHAR(254) NOT NULL, + level_string VARCHAR(254) NOT NULL, + thread_name VARCHAR(254), + reference_flag SMALLINT, + caller_filename VARCHAR(254) NOT NULL, + caller_class VARCHAR(254) NOT NULL, + caller_method VARCHAR(254) NOT NULL, + caller_line CHAR(4) NOT NULL, event_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ); COMMIT; BEGIN; -CREATE TABLE access_event_header +CREATE TABLE logging_event_property ( event_id INT NOT NULL, - header_key VARCHAR(254) NOT NULL, - header_value TEXT, - PRIMARY KEY(event_id, header_key), - FOREIGN KEY (event_id) REFERENCES access_event(event_id) + mapped_key VARCHAR(254) NOT NULL, + mapped_value TEXT, + PRIMARY KEY(event_id, mapped_key), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + ); +COMMIT; + +BEGIN; +CREATE TABLE logging_event_exception + ( + event_id INT NOT NULL, + i SMALLINT NOT NULL, + trace_line VARCHAR(254) NOT NULL, + PRIMARY KEY(event_id, i), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) ); COMMIT; \ No newline at end of file Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql ============================================================================== --- logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql (original) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql Tue Nov 28 17:41:06 2006 @@ -2,32 +2,44 @@ # # It is intended for PostgreSQL databases. -DROP TABLE access_event_exception; -DROP SEQUENCE access_event_id_seq; -DROP TABLE access_event; +DROP TABLE logging_event_property; +DROP TABLE logging_event_exception; +DROP SEQUENCE logging_event_id_seq; +DROP TABLE logging_event; -CREATE SEQUENCE access_event_id_seq MINVALUE 1 START 1; -CREATE TABLE access_event +CREATE SEQUENCE logging_event_id_seq MINVALUE 1 START 1; + + +CREATE TABLE logging_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 + timestmp BIGINT NOT NULL, + formatted_message TEXT NOT NULL, + logger_name VARCHAR(254) NOT NULL, + level_string VARCHAR(254) NOT NULL, + thread_name VARCHAR(254), + reference_flag SMALLINT, + caller_filename VARCHAR(254) NOT NULL, + caller_class VARCHAR(254) NOT NULL, + caller_method VARCHAR(254) NOT NULL, + caller_line CHAR(4) NOT NULL, + event_id INT DEFAULT nextval('logging_event_id_seq') PRIMARY KEY ); -CREATE TABLE access_event_header -( +CREATE TABLE logging_event_property + ( 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 + mapped_key VARCHAR(254) NOT NULL, + mapped_value VARCHAR(1024), + 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(254) NOT NULL, + PRIMARY KEY(event_id, i), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + );

1 0

svn commit: r1018 - logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

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

1 0

svn commit: r1017 - logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 17:37:16 2006 New Revision: 1017 Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2.sql logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2l.sql logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/deleteTables.sql logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mssql.sql logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mysql.sql logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/oracle.sql Log: Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,36 @@ +# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender +# +# It is intended for IBM DB2 databases. +# +# WARNING WARNING WARNING WARNING +# ================================= +# This SQL script has not been tested on an actual DB2 +# instance. It may contain errors or even invalid SQL +# statements. + +DROP TABLE access_event_header; +DROP TABLE access_event; + +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 INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1) + ); + +CREATE TABLE access_event_header + ( + event_id INTEGER 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) + ); Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2l.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2l.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,32 @@ +# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender +# +# It is intended for PostgreSQL databases. + +DROP TABLE access_event_header; +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 NOT NULL AUTO_INCREMENT 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 Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/deleteTables.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/deleteTables.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,3 @@ + +delete from access_event_property; +delete from access_event; Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mssql.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mssql.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,31 @@ +-- This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender +-- + +DROP TABLE access_event_header +DROP TABLE access_event + +CREATE TABLE logging_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, + PRIMARY KEY(event_id) + ) + +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) + ) + Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mysql.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mysql.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,38 @@ +# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender. +# +# It is intended for MySQL databases. It has been tested on MySQL 5.0.22 with +# INNODB tables. + + +BEGIN; +DROP TABLE IF EXISTS access_event_header; +DROP TABLE IF EXISTS access_event; +COMMIT; + +BEGIN; +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 AUTO_INCREMENT PRIMARY KEY + ); +COMMIT; + +BEGIN; +CREATE TABLE access_event_header + ( + event_id INT NOT NULL, + header_key VARCHAR(254) NOT NULL, + header_value TEXT, + PRIMARY KEY(event_id, header_key), + FOREIGN KEY (event_id) REFERENCES access_event(event_id) + ); +COMMIT; \ No newline at end of file Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/oracle.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/oracle.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,45 @@ +-- This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender +-- +-- It is intended for Oracle databases. + + +CREATE SEQUENCE access_event_id_seq MINVALUE 1 START WITH 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 NUMBER(10) PRIMARY KEY + ); + + +CREATE TRIGGER access_event_id_seq_trig + BEFORE INSERT ON access_event + FOR EACH ROW + BEGIN + SELECT access_event_id_seq.NEXTVAL + INTO :NEW.event_id + FROM DUAL; + END access_event_id_seq_trig; + + +CREATE TABLE access_event_header + ( + event_id NUMBER(10) NOT NULL, + header_key VARCHAR2(254) NOT NULL, + header_value VARCHAR2(1024), + PRIMARY KEY(event_id, header_key), + FOREIGN KEY (event_id) REFERENCES access_event(event_id) + ); + + + +

1 0

svn commit: r1016 - logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 17:33:13 2006 New Revision: 1016 Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mssql.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql Log: script updates Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mssql.sql ============================================================================== --- logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mssql.sql (original) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mssql.sql Tue Nov 28 17:33:13 2006 @@ -1,6 +1,5 @@ -- This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender -- --- It is intended for MS SQL Server databases. This has been tested with version 7.0. DROP TABLE logging_event_property DROP TABLE logging_event_exception Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql ============================================================================== --- logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql (original) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql Tue Nov 28 17:33:13 2006 @@ -2,8 +2,6 @@ -- -- It is intended for Oracle databases. --- Tested successfully on Oracle9i Release 9.2.0.3.0 by James Stauffer - -- The following lines are useful in cleaning any previous tables --drop TRIGGER logging_event_id_seq_trig; Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql ============================================================================== --- logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql (original) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql Tue Nov 28 17:33:13 2006 @@ -2,44 +2,32 @@ # # It is intended for PostgreSQL databases. -DROP TABLE logging_event_property; -DROP TABLE logging_event_exception; -DROP SEQUENCE logging_event_id_seq; -DROP TABLE logging_event; +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 SEQUENCE logging_event_id_seq MINVALUE 1 START 1; - - -CREATE TABLE logging_event +CREATE TABLE access_event ( - timestmp BIGINT NOT NULL, - formatted_message TEXT NOT NULL, - logger_name VARCHAR(254) NOT NULL, - level_string VARCHAR(254) NOT NULL, - thread_name VARCHAR(254), - reference_flag SMALLINT, - caller_filename VARCHAR(254) NOT NULL, - caller_class VARCHAR(254) NOT NULL, - caller_method VARCHAR(254) NOT NULL, - caller_line CHAR(4) NOT NULL, - event_id INT DEFAULT nextval('logging_event_id_seq') PRIMARY KEY + 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 logging_event_property - ( +CREATE TABLE access_event_header +( event_id INT NOT NULL, - mapped_key VARCHAR(254) NOT NULL, - mapped_value VARCHAR(1024), - 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(254) NOT NULL, - PRIMARY KEY(event_id, i), - FOREIGN KEY (event_id) REFERENCES logging_event(event_id) - ); + 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

1 0

svn commit: r1015 - logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 17:19:04 2006 New Revision: 1015 Added: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/db2.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/db2l.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mssql.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql Log: script updates Added: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/db2.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/db2.sql Tue Nov 28 17:19:04 2006 @@ -0,0 +1,46 @@ +# This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender +# +# It is intended for IBM DB2 databases. +# +# WARNING WARNING WARNING WARNING +# ================================= +# This SQL script has not been tested on an actual DB2 +# instance. It may contain errors or even invalid SQL +# statements. + +DROP TABLE logging_event_property; +DROP TABLE logging_event_exception; +DROP TABLE logging_event; + +CREATE TABLE logging_event + ( + timestmp BIGINT NOT NULL, + formatted_message VARCHAR(4000) NOT NULL, + logger_name VARCHAR(254) NOT NULL, + level_string VARCHAR(254) NOT NULL, + thread_name VARCHAR(254), + reference_flag SMALLINT, + caller_filename VARCHAR(254) NOT NULL, + caller_class VARCHAR(254) NOT NULL, + caller_method VARCHAR(254) NOT NULL, + caller_line CHAR(4) NOT NULL, + event_id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1) + ); + +CREATE TABLE logging_event_property + ( + event_id INTEGER NOT NULL, + mapped_key VARCHAR(254) NOT NULL, + mapped_value VARCHAR(1024), + PRIMARY KEY(event_id, mapped_key), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + ); + +CREATE TABLE logging_event_exception + ( + event_id INTEGER NOT NULL, + i SMALLINT NOT NULL, + trace_line VARCHAR(254) NOT NULL, + PRIMARY KEY(event_id, i), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + ); Added: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/db2l.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/db2l.sql Tue Nov 28 17:19:04 2006 @@ -0,0 +1,44 @@ +# This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender +# +# It is intended for PostgreSQL databases. + +DROP TABLE logging_event_property; +DROP TABLE logging_event_exception; +DROP TABLE logging_event; + + +CREATE SEQUENCE logging_event_id_seq MINVALUE 1 START 1; + + +CREATE TABLE logging_event + ( + timestmp BIGINT NOT NULL, + formatted_message TEXT NOT NULL, + logger_name VARCHAR(254) NOT NULL, + level_string VARCHAR(254) NOT NULL, + thread_name VARCHAR(254), + reference_flag SMALLINT, + caller_filename VARCHAR(254) NOT NULL, + caller_class VARCHAR(254) NOT NULL, + caller_method VARCHAR(254) NOT NULL, + caller_line CHAR(4) NOT NULL, + event_id INT IDENTITY GENERATED ALWAYS PRIMARY KEY + ); + +CREATE TABLE logging_event_property + ( + event_id INT NOT NULL, + mapped_key VARCHAR(254) NOT NULL, + mapped_value VARCHAR(1024), + 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(254) NOT NULL, + PRIMARY KEY(event_id, i), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + ); Added: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mssql.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mssql.sql Tue Nov 28 17:19:04 2006 @@ -0,0 +1,42 @@ +-- This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender +-- +-- It is intended for MS SQL Server databases. This has been tested with version 7.0. + +DROP TABLE logging_event_property +DROP TABLE logging_event_exception +DROP TABLE logging_event + +CREATE TABLE logging_event + ( + timestmp DECIMAL(20) NOT NULL, + formatted_message VARCHAR(4000) NOT NULL, + logger_name VARCHAR(254) NOT NULL, + level_string VARCHAR(254) NOT NULL, + thread_name VARCHAR(254), + reference_flag SMALLINT, + caller_filename VARCHAR(254) NOT NULL, + caller_class VARCHAR(254) NOT NULL, + caller_method VARCHAR(254) NOT NULL, + caller_line CHAR(4) NOT NULL, + event_id INT NOT NULL identity, + PRIMARY KEY(event_id) + ) + +CREATE TABLE logging_event_property + ( + event_id INT NOT NULL, + mapped_key VARCHAR(254) NOT NULL, + mapped_value VARCHAR(1024), + 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(254) NOT NULL, + PRIMARY KEY(event_id, i), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + ) + Added: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql Tue Nov 28 17:19:04 2006 @@ -0,0 +1,64 @@ +-- This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender +-- +-- It is intended for Oracle databases. + +-- Tested successfully on Oracle9i Release 9.2.0.3.0 by James Stauffer + +-- The following lines are useful in cleaning any previous tables + +--drop TRIGGER logging_event_id_seq_trig; +--drop SEQUENCE logging_event_id_seq; +--drop table logging_event_property; +--drop table logging_event_exception; +--drop table logging_event; + + +CREATE SEQUENCE logging_event_id_seq MINVALUE 1 START WITH 1; + +CREATE TABLE logging_event + ( + timestmp NUMBER(20) NOT NULL, + formatted_message VARCHAR2(4000) NOT NULL, + logger_name VARCHAR(254) NOT NULL, + level_string VARCHAR(254) NOT NULL, + thread_name VARCHAR(254), + reference_flag SMALLINT, + caller_filename VARCHAR(254) NOT NULL, + caller_class VARCHAR(254) NOT NULL, + caller_method VARCHAR(254) NOT NULL, + caller_line CHAR(4) NOT NULL, + event_id NUMBER(10) PRIMARY KEY + ); + + +CREATE TRIGGER logging_event_id_seq_trig + BEFORE INSERT ON logging_event + FOR EACH ROW + BEGIN + SELECT logging_event_id_seq.NEXTVAL + INTO :NEW.event_id + FROM DUAL; + END logging_event_id_seq_trig; + + +CREATE TABLE logging_event_property + ( + event_id NUMBER(10) NOT NULL, + mapped_key VARCHAR2(254) NOT NULL, + mapped_value VARCHAR2(1024), + PRIMARY KEY(event_id, mapped_key), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + ); + +CREATE TABLE logging_event_exception + ( + event_id NUMBER(10) NOT NULL, + i SMALLINT NOT NULL, + trace_line VARCHAR2(254) NOT NULL, + PRIMARY KEY(event_id, i), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + ); + + + + Added: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql Tue Nov 28 17:19:04 2006 @@ -0,0 +1,45 @@ +# This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender +# +# It is intended for PostgreSQL databases. + +DROP TABLE logging_event_property; +DROP TABLE logging_event_exception; +DROP SEQUENCE logging_event_id_seq; +DROP TABLE logging_event; + + +CREATE SEQUENCE logging_event_id_seq MINVALUE 1 START 1; + + +CREATE TABLE logging_event + ( + timestmp BIGINT NOT NULL, + formatted_message TEXT NOT NULL, + logger_name VARCHAR(254) NOT NULL, + level_string VARCHAR(254) NOT NULL, + thread_name VARCHAR(254), + reference_flag SMALLINT, + caller_filename VARCHAR(254) NOT NULL, + caller_class VARCHAR(254) NOT NULL, + caller_method VARCHAR(254) NOT NULL, + caller_line CHAR(4) NOT NULL, + event_id INT DEFAULT nextval('logging_event_id_seq') PRIMARY KEY + ); + +CREATE TABLE logging_event_property + ( + event_id INT NOT NULL, + mapped_key VARCHAR(254) NOT NULL, + mapped_value VARCHAR(1024), + 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(254) NOT NULL, + PRIMARY KEY(event_id, i), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + );

1 0

svn commit: r1014 - logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 16:57:17 2006 New Revision: 1014 Removed: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/db2.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/db2l.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/hsqldb.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mssql.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/deleteTables.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql Log: Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/deleteTables.sql ============================================================================== --- logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/deleteTables.sql (original) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/deleteTables.sql Tue Nov 28 16:57:17 2006 @@ -1,4 +1,3 @@ -delete from logging_event_exception; -delete from logging_event_property; -delete from logging_event; +delete from access_event_property; +delete from access_event; Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql ============================================================================== --- logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql (original) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql Tue Nov 28 16:57:17 2006 @@ -1,51 +1,38 @@ -# This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender. +# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender. # # It is intended for MySQL databases. It has been tested on MySQL 5.0.22 with # INNODB tables. BEGIN; -DROP TABLE IF EXISTS logging_event_property; -DROP TABLE IF EXISTS logging_event_exception; -DROP TABLE IF EXISTS logging_event; +DROP TABLE IF EXISTS access_event_header; +DROP TABLE IF EXISTS access_event; COMMIT; - BEGIN; -CREATE TABLE logging_event +CREATE TABLE access_event ( - timestmp BIGINT NOT NULL, - formatted_message TEXT NOT NULL, - logger_name VARCHAR(254) NOT NULL, - level_string VARCHAR(254) NOT NULL, - thread_name VARCHAR(254), - reference_flag SMALLINT, - caller_filename VARCHAR(254) NOT NULL, - caller_class VARCHAR(254) NOT NULL, - caller_method VARCHAR(254) NOT NULL, - caller_line CHAR(4) NOT NULL, + 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 AUTO_INCREMENT PRIMARY KEY ); COMMIT; BEGIN; -CREATE TABLE logging_event_property +CREATE TABLE access_event_header ( event_id INT NOT NULL, - mapped_key VARCHAR(254) NOT NULL, - mapped_value TEXT, - PRIMARY KEY(event_id, mapped_key), - FOREIGN KEY (event_id) REFERENCES logging_event(event_id) - ); -COMMIT; - -BEGIN; -CREATE TABLE logging_event_exception - ( - event_id INT NOT NULL, - i SMALLINT NOT NULL, - trace_line VARCHAR(254) NOT NULL, - PRIMARY KEY(event_id, i), - FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + header_key VARCHAR(254) NOT NULL, + header_value TEXT, + PRIMARY KEY(event_id, header_key), + FOREIGN KEY (event_id) REFERENCES access_event(event_id) ); COMMIT; \ No newline at end of file

1 0