Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS players (
- id INT(11) NOT NULL AUTO_INCREMENT,
- nick VARCHAR(24) NOT NULL,
- password VARCHAR(32) NOT NULL,
- PlayingTime INT(11) NOT NULL,
- AdminLevel SMALLINT(3) NOT NULL DEFAULT '0',
- Exp INT(11) NOT NULL DEFAULT '0',
- Money INT(11) NOT NULL DEFAULT '0',
- Kills INT(11) NOT NULL DEFAULT '0',
- Deaths INT(11) NOT NULL DEFAULT '0',
- BankMoney INT(11) NOT NULL DEFAULT '0',
- Visits INT(11) NOT NULL DEFAULT '0',
- Hitman INT(11) NOT NULL DEFAULT '0',
- Messages VARCHAR(64) NOT NULL DEFAULT 'brak opisu.',
- Warns INT(11) NOT NULL DEFAULT '0',
- Skin SMALLINT(3) NOT NULL DEFAULT '0',
- House MEDIUMINT(5) NOT NULL DEFAULT '-1',
- Jail INT(11) NOT NULL DEFAULT '-1',
- PRIMARY KEY `nick and id` (id, nick)
- ) ENGINE = MyISAM AUTO_INCREMENT = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement