sms_msgack — Clustered. Stores the acknowledgments received for a given message.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| userid | int unsigned |
|
||
| msgid | mediumint unsigned |
|
||
| type | enum('gateway','smsc','handset','unknown') | YES |
|
|
| timerecv | int unsigned |
|
||
| status_flag | enum('success','error','unknown') | YES |
|
|
| status_code | varchar(25) | YES |
|
|
| status_text | varchar(255) |
|
| Key name | Type | Column(s) |
|---|---|---|
| userid | INDEX |