MySql Script for kannel for storing response from SMPP

step -1

Mysql;

step-2

create database kannel_engine;

step-3

use kannel_engine;

step -4
CREATE TABLE dlr (
smsc varchar(40),
ts varchar(40),
destination varchar(40),
source varchar(40),
service varchar(40),
url varchar(255),
mask int(10),
status int(10),
boxc varchar(40)
)

step-5

#--- mysql connection

  group = mysql-connection
  id = mydlr
  host = localhost
  port = 3306
  username = root
  password = xxxxx
  database = kannel
  max-connections = 1

  #---- DLR table structure

  group = dlr-db
  id = mydlr
  table = dlr
  field-smsc = smsc
  field-timestamp = ts
  field-destination = destination
  field-source = source
  field-service = service
  field-url = url
  field-mask = mask
  field-status = status
  field-boxc-id = boxc
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s