...
In order to create a database and a table for the JDBC Appender to log to, use the SQL commands below.
| Code Block |
|---|
|
CREATE DATABASE IF NOT EXISTS db_name
where db_name is the name of the database you would like to create.
|
| Code Block |
|---|
|
CREATE TABLE `table_name` (
`Id` int(11) NOT NULL auto_increment,
`Logger` varchar(64) default NULL,
`Priority` varchar(10) default NULL,
`Message` varchar(250) default NULL,
`Date` varchar(40) default NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=1005 DEFAULT CHARSET=utf8
|
...