sms_msg

sms_msg — Clustered. Stores log of SMS message data.

sms_msg

Column name Type Null Default Description
userid int unsigned   0  
msgid mediumint unsigned   0  
timecreate int unsigned   0  
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