SQL API / Configuration side SerwerSMS
To configure access to the SQL API side SerwerSMS, you must create a new configuration by selecting the field called "Type" to "LOCAL". Saving these settings will create two tables in the database SerwerSMS and the user who will have access to these tables (INSERT and SELECT). The following describes the structure of the table for the dispatch of messages and received messages (SMS replies and incoming).
The structure of the table for dispatch of messages:
| Filed | Description |
|---|---|
| id | record ID |
| number | the recipient's number (preferably a full international format 48500600700) |
| sender | the name of the sender previously credited to the customer's account. If a message ECO, the name should remain empty. For voice messages should be set to "VOICE". |
| message |
message encoding ASCII or UTF-8 |
| date |
dispatch date in ISO format "YYYY-MM-DD HH: ii: ss". For immediate dispatch blank or "0000-00-00 00:00:00" |
| flags |
additional attributes for example. FLASH - message class zero, the SPEED - a high-priority message sent fastest channels, UTF - SMS message sent to FULL coding UCS2 allows, among others, to use Polish diacritics. |
| smsid |
message ID (assigned by SerwerSMS). When is writing a new record value should be empty or NULL |
| dlr |
delivery report (update SerwerSMS. 0 - waiting for the update, 1 - delivered, 2 - undelivered, 3 - is not sent) |
| dlr_date | updated delivery report (update SerwerSMS, is writing the new record value should be empty or NULL) |
| dlr_code | numeric code delivery report (update SerwerSMS. The codes are described in the section Error codes) |
| dlr_description |
descriptions on delivery report (update SerwerSMS. The codes are described in the section Error codes) |
| parts | The number of parts that make up the message (update SerwerSMS, is writing the new record value should be empty or NULL) |
The structure of the table to receive messages:
| Field | Description |
|---|---|
| id | record ID |
| number |
the recipient's number (the number on which the message was sent) |
| sender |
number (number from which the message was sent) |
| message |
message encoding ASCII or UTF-8 |
| date |
date received in ISO format "YYYY-MM-DD HH: ii: ss". |
| type | type of message (reply ECO, ND / SC, NDI / SCI) |