CREATE TABLE `pw_hack_killlog` (
  `kid` int(11) NOT NULL auto_increment,
  `uid` mediumint(8) unsigned NOT NULL,
  `username` varchar(15) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `safecv` varchar(10) NOT NULL default '',
  `email` varchar(60) NOT NULL default '',
  `groupid` tinyint(3) NOT NULL default '-1',
  `memberid` tinyint(3) NOT NULL default '0',
  `groups` varchar(255) NOT NULL default '',
  `icon` varchar(100) NOT NULL default '',
  `gender` tinyint(1) NOT NULL default '0',
  `regdate` int(10) unsigned NOT NULL default '0',
  `signature` text NOT NULL,
  `introduce` text NOT NULL,
  `oicq` varchar(12) NOT NULL default '',
  `aliww` varchar(30) NOT NULL,
  `icq` varchar(12) NOT NULL default '',
  `msn` varchar(35) NOT NULL default '',
  `yahoo` varchar(35) NOT NULL default '',
  `site` varchar(75) NOT NULL default '',
  `location` varchar(36) NOT NULL default '',
  `honor` varchar(100) NOT NULL default '',
  `bday` date NOT NULL default '0000-00-00',
  `lastaddrst` varchar(255) NOT NULL default '',
  `yz` int(10) NOT NULL default '1',
  `timedf` varchar(5) NOT NULL default '',
  `style` varchar(12) NOT NULL default '',
  `datefm` varchar(15) NOT NULL default '',
  `t_num` tinyint(3) unsigned NOT NULL default '0',
  `p_num` tinyint(3) unsigned NOT NULL default '0',
  `attach` varchar(50) NOT NULL default '',
  `hack` varchar(255) NOT NULL default '0',
  `newpm` tinyint(1) NOT NULL default '0',
  `banpm` text NOT NULL,
  `msggroups` varchar(255) NOT NULL default '',
  `medals` varchar(255) NOT NULL default '',
  `userstatus` int(10) unsigned NOT NULL default '0',
  `shortcut` varchar(255) NOT NULL default '',
  `kill_date` int(11) NOT NULL COMMENT 'ɾʺʱ',
  `kill_why` varchar(255) NOT NULL COMMENT 'ɾʺԭ',	
  `ip` varchar(50) NOT NULL,
  PRIMARY KEY  (`kid`),
  KEY `groupid` (`groupid`),
  KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk;
