Home
RECOMMENDED FOR YOU:
SMS Gateway software
Ozeki brings you outstanding
SMS Gateway technology. Use our SMS Server products on Windows,Linux, or Android

C# SMS API
Developers can use our C# SMS API to send SMS from C#.Net. The C# SMS API comes with full source code

PHP SMS API
The ozeki PHP SMS gateway software can be used to send SMS from PHP and to receive SMS usig PHP on your website

SMPP SMS Gateway
SMS service providers use our SMPP gateway solution, that offers a high performance SMPP server and SMPP client gateway with amazing routing capabilities
Ozeki NG SMS Gateway

SQL to SMS Gateway configuration - MySQL table definition

This page gives you the database table layout if you want to setup an SQL to SMS Gateway configuration for MySQL. The tables defined here can be used as a startup. If you wish you can add extra columns to these tables or you can create custom tables.

If you want to change these table definitions to support your requirements, do not forget to review the SQL templates that are used by the SMS gateway to work with these tables. The following guide gives you information on how to view and modify the SQL templates:

SQL to SMS Gateway configuration - SQL templates

The recommended database table layout for MySQL contains two database tables called ozekimessagout and ozekimessagein. Their definitions are displayed in Figure 1.

CREATE TABLE ozekimessagein (
  	id int(11) NOT NULL auto_increment,
  	sender varchar(255) default NULL,
  	receiver varchar(255) default NULL,
  	msg varchar(160) default NULL,
  	senttime varchar(100) default NULL,
  	receivedtime varchar(100) default NULL,
  	operator varchar(100) default NULL,
 	msgtype varchar(160) default NULL,
  	reference varchar(100) default NULL,
  	PRIMARY KEY (id)) 
  	charset=utf8;
	
ALTER TABLE ozekimessagein ADD INDEX (id) ;
CREATE TABLE ozekimessageout (
  	id int(11) NOT NULL auto_increment,
  	sender varchar(255) default NULL,
  	receiver varchar(255) default NULL,
  	msg varchar(160) default NULL,
  	senttime varchar(100) default NULL,
  	receivedtime varchar(100) default NULL,
  	reference varchar(100) default NULL,
  	status varchar(20) default NULL,
  	msgtype varchar(160) default NULL,
  	operator varchar(100) default NULL,
  	errormsg varchar(250) default NULL,
  	PRIMARY KEY (id)) 
  	charset=utf8;
  	
ALTER TABLE ozekimessageout ADD INDEX (id);

Figure 1 - MySQL table definition for SQL to SMS gateway configuration

More information