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