sms_msgack

sms_msgack — Clustered. Stores the acknowledgments received for a given message.

sms_msgack

Column name Type Null Default Description
userid int unsigned   0  
msgid mediumint unsigned   0  
type enum('gateway','smsc','handset','unknown') YES  
timerecv int unsigned   0  
status_flag enum('success','error','unknown') YES  
status_code varchar(25) YES  
status_text varchar(255)    
messageid int unsigned auto_increment    
Key name Type Column(s)
PRIMARY PRIMARY
userid INDEX