· 8 years ago · Mar 13, 2018, 07:22 AM
1DROP TABLE IF EXISTS `mail`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `mail` (
5 `mail_id` int(11) NOT NULL AUTO_INCREMENT,
6 `sender_name` text NOT NULL,
7 `recv_name` tinytext NOT NULL,
8 `subject` text NOT NULL,
9 `body` text,
10 `time` int(10) unsigned DEFAULT NULL,
11 `attachment_id` mediumint(8) unsigned DEFAULT NULL,
12 `read` tinyint(1) NOT NULL DEFAULT '0',
13 PRIMARY KEY (`mail_id`),
14 KEY `timkey` (`time`),
15 KEY `new_index` (`recv_name`(128)),
16 KEY `new_index2` (`sender_name`(128))
17) ENGINE=MyISAM AUTO_INCREMENT=10197154 DEFAULT CHARSET=latin1;
18/*!40101 SET character_set_client = @saved_cs_client */;