8136 SMS Gateway - MySQL, Database layout

Search the manual:

Overview

OZEKI NG SMS Gateway - Product Guide

Contents | Search

Home > Product Manual > Installation Guide > Users and applications > Database user > MySQL > Database layout

Service Provider Connections

Users and applications

MyODBC driver installation

Connection string builder

Dynamic SMPP parameters

AutoreplyDatabase user

Outlook Mobile Service

Examples and Solutions

Appendix

FAQ

Feature list

Commercial Information

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.

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create:

Webphone solutions:
- Adobe Flash video phone
- Silverlight video phone
- Web to web calls
- Web to VoIP calls

Custom SIP clients:
- Silverlight SIP VoIP client
- Flash SIP VoIP client
- C# .net SIP VoIP client
- ASP .net SIP VoIP client
- Web based SIP VoIP client

Custom VoIP solutions:
- VoIP SIP softphones
- VoIP call center clients
- VoIP IVR systems
- VoIP predictive dialer systems
- VoIP auto dialer systems
- VoIP call assistant
- VoIP call recording systems
- VoIP intercom solutions

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

Dig deeper!
People who read this also read...

Next page: MyODBC driver installation

Software PBX for Windows | VoIP SDK | Legal information | Privacy policy | Terms of use
Please, address your inquiries to info@ozekisms.com