Sql create table scripts

You can use any database with that can be accessed using an ADO or ODBC driver.

All you have to do is create two database tables: ozekimessagesin and ozekimessageout. (The tables can have additional columns.) Ozeki Message Server 6 will insert the incoming messages to the ozekimessagesin table. If you want to send a message, you should insert a record into the ozekimessageout table. The SMS Server checks this table periodically for messages to send.

Microsoft SQL Server

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

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

MySQL

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,
  reference varchar(100) 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,
  reference varchar(100) default NULL,
  status varchar(20) default NULL,
  msgtype varchar(160) default NULL,
  operator varchar(100),
  PRIMARY KEY (id)
);

Interbase

Installation instructions for Interbase: http://www.ozeki.hu/index.phtml?owpn=177

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

CREATE GENERATOR sms_id;

CREATE TRIGGER set_id FOR ozekimessageout
BEFORE INSERT  
AS
BEGIN
New.id =  gen_id(sms_id,1);
END;

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

CREATE GENERATOR sms_id_;

CREATE TRIGGER set_id_ FOR ozekimessagein
BEFORE INSERT  
AS
BEGIN
New.id = gen_id(sms_id_,1);
END;

Oracle

CREATE TABLE ozekimessagein (
  id int,
  sender  varchar(30) default NULL,
  receiver varchar(30) default  NULL,
  msg varchar(1024) default NULL,
  operator  varchar(120) default NULL,
  msgtype varchar(160) default  NULL,
  senttime varchar(100) default NULL,
  receivedtime  varchar(100) default NULL,
  reference varchar(100) default NULL
);

CREATE SEQUENCE X;

CREATE TRIGGER ozekimessagein_auto BEFORE INSERT on
ozekimessagein
for each row
when (new.id is null)
begin
SELECT x.nextval INTO :new.id FROM  DUAL;
end;

CREATE TABLE ozekimessageout (
  id int,
  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(120) default NULL,
  msgtype  varchar(160) default NULL,
  reference varchar(100) default  NULL,
  status varchar(20) default NULL
);

CREATE SEQUENCE Y;

CREATE TRIGGER ozekimessageout_auto BEFORE INSERT on 
ozekimessageout
for each row
when (new.id is null)
begin
SELECT y.nextval INTO :new.id FROM DUAL;
end;

PostgresSQL

CREATE TABLE ozekimessagein (
  id serial,	
  sender varchar(30), 
  receiver  varchar(30),
  msg varchar(1024),  
  senttime  varchar(100), 
  receivedtime varchar(100),
  operator  varchar(100),  
  msgtype varchar(160),  
  reference varchar(100)
);

CREATE TABLE ozekimessageout (
  id serial, 
  sender varchar(30),
  receiver  varchar(30),
  msg varchar(1024),
  senttime  varchar(100),
  receivedtime varchar(100),
  reference  varchar(100),
  status varchar(20),
  operator  varchar(100),
  msgtype varchar(160)
);

More information