CREATE TABLE IF NOT EXISTS `mubanpu_qiandao` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(100) CHARACTER SET utf8 NOT NULL, `mood` text CHARACTER SET utf8 NOT NULL, `time` int(10) unsigned NOT NULL, `integrate` int(10) unsigned NOT NULL, `group` int(10) unsigned NOT NULL, `uname` char(60) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
(此为gbk)
CREATE TABLE IF NOT EXISTS `mubanpu_qiandao` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(100) CHARACTER SET gbk NOT NULL, `mood` text CHARACTER SET gbk NOT NULL, `time` int(10) unsigned NOT NULL, `integrate` int(10) unsigned NOT NULL, `group` int(10) unsigned NOT NULL, `uname` char(60) CHARACTER SET gbk NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=0 ;