CREATE TABLE `user_histories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(32) NOT NULL,
  `fullname` varchar(64) NOT NULL,
  `groupname` varchar(32) NOT NULL,
  `visitdate` datetime NOT NULL,
  PRIMARY KEY  (`id`)
);