Configuration of Database

• Kylix SMS Server exchanges data with your software through database, so you need to build two tables according to certain rules.
  1. SMSOut table records messages need to be sent, which should include the following fields:
              MsgID, Phone, MsgBody, Status
  2. SMSIn table records messages received, which should include the following fields:
              Phone, MsgBody, RecTime

• You can use other field names, so long as you can match these fields with the escape sequence in the three SQL scripts. The software uses a MS Access database by default, where you can see time format (#<TIME>#) in the insert script, and you can modify it into "<TIME>" in case you are using other databases. Escape sequence is the section enclosed by "<" and ">", which takes the same format with the following examples.

            select msgid as <MSGID>, phone as <PHONE>, msgbody as <MSGBODY> from smsout where status=0

            update smsout set status=<RESULT> where msgid=<MSGID>
            insert into smsin(phone, msgbody, rectime) values('<PHONE>', '<MSGBODY>', #<TIME>#)