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

[noreply.seb at qos.ch]

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