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