· 8 years ago · Aug 07, 2018, 07:22 PM
1DROP TABLE IF EXISTS `accounts`;
2CREATE TABLE `accounts` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `Name` varchar(24) NOT NULL,
5 `Passwort` varchar(128) NOT NULL,
6 `Level` int(11) NOT NULL DEFAULT '1',
7 `Geld` int(11) NOT NULL DEFAULT '0',
8 `Kills` int(11) NOT NULL DEFAULT '0',
9 `Tode` int(11) NOT NULL DEFAULT '0',
10 `Health` float NOT NULL DEFAULT '100',
11 `Adminlevel` int(11) NOT NULL DEFAULT '0',
12 `Fraktion` int(11) NOT NULL DEFAULT '0',
13 `Banned` int(11) NOT NULL DEFAULT '0',
14 PRIMARY KEY (`id`)
15) ENGINE=MyISAM AUTO_INCREMENT=220 DEFAULT CHARSET=latin1;