CREATE TABLE `tblinbox` (
`inbox_msg_id` varchar(50) NOT NULL default '',
`username` varchar(100) default NULL,
`phone_number` varchar(20) default NULL,
`rec_time` datetime default NULL,
PRIMARY KEY  (`inbox_msg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('A1','USER1','441234567890',20080101000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('B2','USER1','441234567891',20080101000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('A3','USER2','441234567892',20080101000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('A4','USER1','441234567893',20080101000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('B5','USER1','441234567894',2008010100000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('A6','USER1','441234567895',20080102000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('A7','USER1','441234567896',20080102000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('A8','USER2','441234567897',20080103000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('B9','USER1','441234567898',20080104000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('B10','USER1','441234567899',20080104000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('B11','USER3','441234567880',20080104000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('A12','USER1','441234567881',20080105000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('B13','USER2','441234567881',20080105000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('A14','USER1','441234567882',20080106000000);
INSERT INTO tblinbox (inbox_msg_id, username, phone_number, rec_time) VALUES ('A15','USER1','441234567883',20080107000000);