Products
Ozeki 10
Apps
Chat
SMS Gateway
Quick Start Guide
SMS with Client Software
HTTP API
SMS from/to Database
PHP SMS API
Solutions
C# SMS API
VB.NET SMS API
SQL Logging
MySQL table layout
Oracle table layout
MSSQL table layout
SQL templates
SQL Log Tracking
Keywords
Advanced Traffic Queries
System Database
Robot Controller
Softphone
PBX
Connections
Installation guide
Terms and Definitions
HTTP API
SMS
Bulk Messenger
Cluster
Developer tools
Robots
Hardware
Installer
Technology
Company


Ozeki 10 - SMS Gateway server software
SQL Logging SQL Logging | Oracle table layout Oracle table layout

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.
Check the MySQL ODBC installation guide on the following page, so you can use the connection string below:

Connection Type:ODBC
Connection String:Driver={MySQL ODBC 5.3 Unicode Driver}; Server=127.0.0.1;Database=ozekisms;User=ozeki;Password=abc123;Option=4;
Figure 1 - Modify this connection string to fit your own ODBC driver connection

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:

CREATE TABLE  outbox (
id int not null auto_increment primary key,
username varchar(30),
msgtype varchar(160),
msgid varchar(60),
callbackid varchar(255),
sender varchar(30),
receiver varchar(30),
msgsubject varchar(1024),
msgdata text,
acceptedfordeliverytime datetime,
deliveredtonetworktime datetime,
deliveredtohandsettime datetime,
operator varchar(30),
route varchar(30),
status varchar(130),
errormessage varchar(1024),
cost varchar(10),
INDEX(msgid)
) charset=utf8;


CREATE TABLE  inbox (
id int not null auto_increment primary key,
username varchar(30),
msgtype varchar(160),
msgid varchar(60),
sender varchar(30),
receiver varchar(30),
msgsubject varchar(1024),
msgdata text,
senttime datetime,
receivedtime datetime,
operator varchar(30),
INDEX(msgid)
) charset=utf8;
Figure 2 - Copy CREATE TABLE statements

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.


Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Products > Ozeki 10 > Apps > SMS Gateway > SQL Logging > MySQL table layout
Legal | Privacy policy | Terms of use
Page: 5777 | Login | 3.95.131.97