DROP TABLE IF EXISTS `phpcms_sms_report`; CREATE TABLE `phpcms_sms_report` ( `id` bigint(15) NOT NULL AUTO_INCREMENT, `mobile` varchar(11) NOT NULL, `posttime` int(10) unsigned NOT NULL DEFAULT '0', `id_code` varchar(10) NOT NULL, `msg` varchar(90) NOT NULL, `send_userid` mediumint(8) unsigned NOT NULL DEFAULT '0', `status` tinyint(2) NOT NULL DEFAULT '0', `return_id` varchar(30) NOT NULL, `ip` varchar(15) NOT NULL, PRIMARY KEY (`id`), KEY `mobile` (`mobile`,`posttime`) ) TYPE=MyISAM;