| # This SQL script creates the required tables by org.apache.log4j.db.DBAppender and |
| # org.apache.log4j.db.DBReceiver. |
| # |
| # 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; |
| |
| |
| CREATE SEQUENCE logging_event_id_seq MINVALUE 1 START 1; |
| |
| |
| CREATE TABLE logging_event |
| ( |
| sequence_number BIGINT NOT NULL, |
| timestamp BIGINT NOT NULL, |
| rendered_message TEXT NOT NULL, |
| logger_name VARCHAR(254) NOT NULL, |
| level_string VARCHAR(254) NOT NULL, |
| ndc TEXT, |
| 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 |
| ); |
| |
| CREATE TABLE logging_event_property |
| ( |
| 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) |
| ); |