SQL Reporting in the SMS Gateway - Database layout (MySQL)
This page gives you the database connection information and the database
layout if you want to setup SQL reporting in a MySQL database server. SQL
reporting makes it possible to keep track of all incoming and outgoing
messages in the system regardless of who sent it.
To setup SQL reporting with MySQL, you need to install the MySQL ODBC v5
driver.
The recommended database table layout for SQL reporting into a MySQL database
contains two database tables called outbox and inbox. Their definitions are
displayed in the following
section.
If you want to change these table definitions to support your requirements,
do not forget to review (and change if necessary) the SQL templates that are
configured in the server preferences form.