Bukkit

CREATE TABLE IF NOT EXISTS `playerlist` (
  `ID` tinyint(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `lastSeen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `kills` int(10) NOT NULL,
  `deaths` int(10) NOT NULL,
  `totaltime` varchar(10000) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;


CREATE TABLE IF NOT EXISTS `pvpkills` (
  `ID` tinyint(11) NOT NULL AUTO_INCREMENT,
  `killer` varchar(50) NOT NULL,
  `victim` varchar(50) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;