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
You can find information on how to install this driver in the
MySQL ODBC v5 installation
The database connection type, you should choose is:
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.
People who read this also read...