附上数据库信息:
CREATE TABLE IF NOT EXISTS `php21_haoyou` ( `id` int(11) NOT NULL AUTO_INCREMENT, `u_id` int(11) DEFAULT NULL, `h_id` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
CREATE TABLE IF NOT EXISTS `php21_message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `f_id` int(11) NOT NULL, `s_id` int(11) NOT NULL, `msg` varchar(255) NOT NULL, `addtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;
CREATE TABLE IF NOT EXISTS `php21_user` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id', `user_name` varchar(30) NOT NULL COMMENT 'ç¨æ·å', `password` char(34) NOT NULL COMMENT 'å¯ç ', `face` varchar(150) NOT NULL DEFAULT '' COMMENT '头å', `email` varchar(150) NOT NULL DEFAULT '' COMMENT 'é®ç®±', `jifen` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '积å', `chenghu` varchar(18) DEFAULT NULL COMMENT '称å¼', `manglin` decimal(10,2) DEFAULT NULL, `sex` enum('ç·','女','æªç¥') DEFAULT NULL, `email_code` char(32) NOT NULL DEFAULT '', `email_time` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ä¼å' AUTO_INCREMENT=0;
CREATE TABLE IF NOT EXISTS `php21_zhongjian` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uu_id` int(11) NOT NULL, `t_id` int(11) DEFAULT NULL, `zt` tinyint(4) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=0;