Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"

OZEKI NG SMS Gateway - Product Guide

MyODBC v5 Contents | SearchMyODBC driver installation

Home > Product Manual > Installation Guide > Users and applications > SMS from or to database > MySQL > Database layout

 


Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

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(30) default NULL,
  	receiver varchar(30) 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(30) default NULL,
  	receiver varchar(30) 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





Next page: MyODBC driver installation
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Product Manual > Installation Guide > Users and applications > SMS from or to database > MySQL > Database layout
Legal | Privacy | Terms of use | 2418
35.172.236.135 | 87.229.102.173 | Login