logging-log4j-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From c...@apache.org
Subject cvs commit: logging-log4j/src/java/org/apache/log4j/db/dialect postgresql.sql mysql.sql oracle.sql
Date Sat, 15 May 2004 18:23:35 GMT
ceki        2004/05/15 11:23:35

  Modified:    src/java/org/apache/log4j/db/dialect postgresql.sql
                        mysql.sql oracle.sql
  Log:
  Wider fields, minor changes...
  
  Revision  Changes    Path
  1.7       +1 -1      logging-log4j/src/java/org/apache/log4j/db/dialect/postgresql.sql
  
  Index: postgresql.sql
  ===================================================================
  RCS file: /home/cvs/logging-log4j/src/java/org/apache/log4j/db/dialect/postgresql.sql,v
  retrieving revision 1.6
  retrieving revision 1.7
  diff -u -r1.6 -r1.7
  --- postgresql.sql	12 May 2004 14:59:53 -0000	1.6
  +++ postgresql.sql	15 May 2004 18:23:35 -0000	1.7
  @@ -27,7 +27,7 @@
     (
       event_id	      INT NOT NULL,
       mapped_key        VARCHAR(254) NOT NULL,
  -    mapped_value      VARCHAR(254),
  +    mapped_value      VARCHAR(1024),
       PRIMARY KEY(event_id, mapped_key),
       FOREIGN KEY (event_id) REFERENCES logging_event(id)
     );
  
  
  
  1.8       +1 -1      logging-log4j/src/java/org/apache/log4j/db/dialect/mysql.sql
  
  Index: mysql.sql
  ===================================================================
  RCS file: /home/cvs/logging-log4j/src/java/org/apache/log4j/db/dialect/mysql.sql,v
  retrieving revision 1.7
  retrieving revision 1.8
  diff -u -r1.7 -r1.8
  --- mysql.sql	12 May 2004 20:05:39 -0000	1.7
  +++ mysql.sql	15 May 2004 18:23:35 -0000	1.8
  @@ -32,7 +32,7 @@
     (
       event_id	      INT NOT NULL,
       mapped_key        VARCHAR(254) NOT NULL,
  -    mapped_value      VARCHAR(254),
  +    mapped_value      TEXT,
       PRIMARY KEY(event_id, mapped_key),
       FOREIGN KEY (event_id) REFERENCES logging_event(event_id)
     );
  
  
  
  1.8       +7 -6      logging-log4j/src/java/org/apache/log4j/db/dialect/oracle.sql
  
  Index: oracle.sql
  ===================================================================
  RCS file: /home/cvs/logging-log4j/src/java/org/apache/log4j/db/dialect/oracle.sql,v
  retrieving revision 1.7
  retrieving revision 1.8
  diff -u -r1.7 -r1.8
  --- oracle.sql	12 May 2004 14:59:53 -0000	1.7
  +++ oracle.sql	15 May 2004 18:23:35 -0000	1.8
  @@ -25,31 +25,32 @@
       ndc               VARCHAR2(4000),
       thread_name       VARCHAR2(254),
       reference_flag    SMALLINT,
  -    event_id          INT PRIMARY KEY
  +    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.id 
  +    INTO   :NEW.event_id 
       FROM   DUAL;  
     END logging_event_id_seq_trig;
  -/
  +
   
   CREATE TABLE logging_event_property
     (
  -    event_id	      INT NOT NULL,
  +    event_id	      NUMBER(10) NOT NULL,
       mapped_key        VARCHAR2(254) NOT NULL,
  -    mapped_value      VARCHAR2(254),
  +    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         INT NOT NULL,
  +    event_id         NUMBER(10) NOT NULL,
       i                SMALLINT NOT NULL,
       trace_line       VARCHAR2(254) NOT NULL,
       PRIMARY KEY(event_id, i),
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-dev-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-dev-help@logging.apache.org


Mime
View raw message