7d6d SMS Gateway - SQL SMS Gateway, MySQL Script

Search the manual:

Overview

OZEKI NG SMS Gateway - Product Guide

Contents | Search

Home > Product Manual > Examples and Solutions > SQL SMS Gateway > MySQL Script

Examples and Solutions

Telephone networks

Pin game

E-mail to SMS Alerts

2 way SMS to Email gateway

Database Link Management

Birthday greeting - SQL Express

Birthday greeting - MySQL

Birthday greeting - Oracle

Instant brochure - MMS autoreply

Alphabet letter game

SMS sport betting service

E-mail about outgoing SMS messages

Bulk SMS to a given phone number range

Filtering phone numbers

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

MySQL create table script

Introduction

To create an SQL SMS Gateway with Ozeki NG, you can use a MySQL database, which can be accessed using an ADO or ODBC driver. All you have to do is create two database tables (in the ozekisms database): ozekimessagein and ozekimessageout. (The tables can have additional columns.) Ozeki NG will insert the incoming messages into the ozekimessagein table. If you want to send a message, you should insert a record into the ozekimessageout table. The SMS Server periodically checks this table for messages to send.

Database and tables creating

Copy the following text into a Notepad file, and then save it as C:\mysql_create.txt. This will create the ozekisms database including the ozekimessagein and the ozekimesageout table. Then, it will create a user called "sqluser" with the password "abc123" (these values can be freely modified). This user will be authorized to query, modify, delete rows or to insert new rows in the tables of the ozekisms database. You can also download this file here: mysql_create.txt.

CREATE DATABASE ozekisms;

USE ozekisms;

CREATE TABLE ozekimessagein
(
id int(11) NOT NULL auto_increment,
sender varchar(30) default NULL,
receiver varchar(30) default NULL,
msg varchar(1024) default NULL,
senttime varchar(100) default NULL,
receivedtime varchar(100) default NULL,
operator varchar(100),
msgtype varchar(160) default NULL,
PRIMARY KEY (id)
);

CREATE TABLE ozekimessageout
(
id int(11) NOT NULL auto_increment,
sender varchar(30) default NULL,
receiver varchar(30) default NULL,
msg varchar(1024) default NULL,
senttime varchar(100) default NULL,
receivedtime varchar(100) default NULL,
status varchar(20) default NULL,
msgtype varchar(160) default NULL,
operator varchar(100),
PRIMARY KEY (id)
);

grant insert,update,select,delete on ozekisms.* to sqluser@localhost
identified by 'abc123';

To start the MySQL Command Line Client: Start menu -> All Programs -> MySQL -> MySQL Server 5.0 -> MySQL Command Line Client.

Then, enter the password and press ENTER.

Enter the following, and press ENTER:

source c:\mysql_create.txt

If everything is working properly, you should see something like this:

You can check the result by issuing the following statements:

use ozekisms;
desc ozekimessagein;
desc ozekimessageout;

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

SQL SMS Gateway

Database link Management

Appendix

Feature list of Ozeki NG SMS Gateway

FAQ

Next page: Oracle script

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