sms_msg — Clustered. Stores log of SMS message data.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| userid | int unsigned |
|
||
| msgid | mediumint unsigned |
|
||
| timecreate | int unsigned |
|
||
| class_key | varchar(25) |
unknown
|
||
| type | enum('incoming','outgoing') | YES |
|
|
| status | enum('success','error','ack_wait','unknown') |
unknown
|
||
| from_number | varchar(15) | YES |
|
|
| to_number | varchar(15) | YES |
|
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| timecreate | INDEX | |
| userid | INDEX |