Ozeki 10 SMS Gateway
Installation Installation | Command prompt Command prompt

Send SMS from MSSQL Express (part 2/4)
Create Database Tables

In this video series you can see how to connect Ozeki SMS Gateway and MSSQL Express database server for SMS messaging. This video shows how to create the proper database table structure by using MSSQL Express through it's command line.

Video content
1. Connect to MSSQL Express
2. Copy CREATE TABLE statement
3. Run CREATE TABLE statement
Start the video

Please scroll down to copy the CREATE TABLE statements used in the video. If you have created the database in MSSQL Express, you can jump to the next video.

Connect to the Microsoft SQL Express database
Figure 1 - Connect to the Microsoft SQL Express database



create database ozeki
GO

use ozeki
GO

CREATE TABLE ozekimessagein (
 id int IDENTITY (1,1),
 sender varchar(30),
 receiver varchar(30),
 msg nvarchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(30),
 msgtype varchar(30),
 reference varchar(30),
);

CREATE TABLE ozekimessageout (
 id int IDENTITY (1,1),
 sender varchar(30),
 receiver varchar(30),
 msg nvarchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(100),
 msgtype varchar(30),
 reference varchar(30),
 status varchar(30),
 errormsg varchar(250)
);

GO

sp_addLogin 'ozekiuser', 'ozekipass'
GO

sp_addsrvrolemember 'ozekiuser', 'sysadmin'
GO

Figure 2 - CREATE TABLE statement

Copy CREATE TABLE statement from the folowing LINK
Figure 3 - Copy CREATE TABLE statement from Figure 2


Run CREATE TABLE statement on the database
Figure 4 - Run CREATE TABLE statement on the database


 
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Developers guide > SMS from or to Database > MSSQL Express > Database layout
Legal | Privacy | Terms of use | 5710
34.204.187.106 | 92.118.27.157 | Login