[logback-dev] svn commit: r1014 - logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect

[noreply.seb at qos.ch]

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