Ozeki 10 SMS Gateway
SQL migration SQL migration | 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 > SMS > SMS gateway > SQL Logging > MySQL table layout
Legal | Privacy policy | Terms of use
Page: 5777 | Login | 3.235.172.213