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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
