Datenbank

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(24) NOT NULL,
  `Passwort` varchar(128) NOT NULL,
  `Level` int(11) NOT NULL DEFAULT '1',
  `Geld` int(11) NOT NULL DEFAULT '0',
  `Kills` int(11) NOT NULL DEFAULT '0',
  `Tode` int(11) NOT NULL DEFAULT '0',
  `Health` float NOT NULL DEFAULT '100',
  `Rang` int(11) NOT NULL,
  `Member` int(11) NOT NULL,
  `Leader` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;