QGV6A7PF

1DROP TABLE IF EXISTS `mail`;
2
3CREATE TABLE `mail` (
4  `mail_id` int(11) NOT NULL AUTO_INCREMENT,
5  `sender_name` text NOT NULL,
6  `recv_name` tinytext NOT NULL,
7  `subject` text NOT NULL,
8  `body` text,
9  `time` int(10) unsigned DEFAULT NULL,
10  `attachment_id` mediumint(8) unsigned DEFAULT NULL,
11  `read` tinyint(1) NOT NULL DEFAULT '0',
12  PRIMARY KEY (`mail_id`),
13  KEY `timkey` (`time`),
14  KEY `new_index` (`recv_name`(128)),
15  KEY `new_index2` (`sender_name`(128))
16) ENGINE=MyISAM AUTO_INCREMENT=10197154 DEFAULT CHARSET=latin1;