- Product Manual
- Introduction
- Installation Guide
- Prerequisites
- SMS technology
- Download Information
- Installation Steps
- GSM Modem Setup
- Mobile Network Connections
- Users and applications
- Standard user
- SMPP user
- SMS from or to database
- MSSQL
- MySQL
- MyODBC v8
- Database layout
- MyODBC driver installation
- Oracle
- Sybase SQL Anywhere
- PostgreSQL
- Pervasive SQL
- Date Format Strings
- Scheduled SMS
- SQL templates
- Informix
- Access
- Video
- Connection string builder
- Keywords
- MS SQL high speed
- Oracle High Speed
- SQL statements
- Polling technology
- Dynamic Keywords
- Dynamic SMPP parameters
- Autoreply SMS from database
- Autoreply SMS using a script
- Simple autoreply SMS
- SMS from or to file
- SMS through E-mail
- SMS via HTTP Request
- SMS via colour protocol
- Application starter SMS
- SMS Voting
- SMS from MS Outlook
- SMS from/to FTP server
- PDF Request in SMS
- SMS to WCF service
- SMS Forwarder
- RSS to SMS
- Linux
- User Guide
- Developers Guide
- Examples and Solutions
- Appendix
- SMS FAQ
- Feature list
- Commercial Information
- Search
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 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 templatesThe 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); |
More information