MySQL table layout
From this page you can copy-paste CREATE TABLE statements to your MySQL command line to create the required table structure. Everytime Ozeki SMS Gateway SQL logger runs an SQL statement on the database, it will be logged. SQL reports will be sent after every incoming our outgoing message, regardless of the sender's or receiver's address.
Before setting up SQL reporting with MySQL, you need to install at least a MySQL ODBC version 5.3 driver.
It is recommended to use two different SQL reporting tables called 'inbox' and 'outbox', although you can give them any name you prefer. Please memorize it, so you can set the proper SQL statements later on your Ozeki SMS Gateway's GUI. Figure 2 contains the table definitions:
Please change these table definitions to fit your requirements and do not forget to review and change the SQL statements in Ozeki SMS Gateway to fit the freshly created tables.