Sql logging

You can use any database that can be accessed using an ADO or ODBC driver to save your outgoing and icoming messages. To configure this option you should open the server preferences form and specify a database connection string (Figure 1).

database logging
Figure 1 - Database logging

After you have specified the connection, make sure to create two database tables: outbox and inbox. (The tables can have additional columns.) Ozeki Message Server 6 will insert the incoming messages to the inbox table and the outgoing messages into the outbox table.

     Microsoft SQL Server

CREATE TABLE outbox (
id int IDENTITY(1,1),
username varchar(30),
pluginname varchar(30),
msgtype varchar(160),
msgid varchar(30),
callbackid varchar(30),
sender varchar(30),
receiver varchar(30),
msgsubject varchar(1024),
msgdata text,
senttime datetime,
receivedtime datetime,
operator varchar(30),
status varchar(30),
cost int,
history text
);


CREATE TABLE inbox (
id int IDENTITY(1,1),
username varchar(30),
pluginname varchar(30),
msgtype varchar(160),
msgid varchar(30),
callbackid varchar(30),
sender varchar(30),
receiver varchar(30),
msgsubject varchar(1024),
msgdata text,
senttime datetime,
receivedtime datetime,
operator varchar(30),
history text
);
MySQL

CREATE TABLE outbox (
id int(11) NOT NULL auto_increment primary key,
username varchar(30),
pluginname varchar(30),
msgtype varchar(160),
msgid varchar(30),
callbackid varchar(30),
sender varchar(30),
receiver varchar(30),
msgsubject varchar(1024),
msgdata text,
senttime datetime,
receivedtime datetime,
operator varchar(30),
cost int,
status varchar(30),
history text
);

CREATE TABLE inbox (
id int(11) NOT NULL auto_increment primary key,
username varchar(30),
pluginname varchar(30),
msgtype varchar(160),
msgid varchar(30),
callbackid varchar(30),
sender varchar(30),
receiver varchar(30),
msgsubject varchar(1024),
msgdata text,
senttime datetime,
receivedtime datetime,
operator varchar(30),
history text
);

More information