Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS players (
  2. id INT(11) NOT NULL AUTO_INCREMENT,
  3. nick VARCHAR(24) NOT NULL,
  4. password VARCHAR(32) NOT NULL,
  5. PlayingTime INT(11) NOT NULL,
  6. AdminLevel SMALLINT(3) NOT NULL DEFAULT '0',
  7. Exp INT(11) NOT NULL DEFAULT '0',
  8. Money INT(11) NOT NULL DEFAULT '0',
  9. Kills INT(11) NOT NULL DEFAULT '0',
  10. Deaths INT(11) NOT NULL DEFAULT '0',
  11. BankMoney INT(11) NOT NULL DEFAULT '0',
  12. Visits INT(11) NOT NULL DEFAULT '0',
  13. Hitman INT(11) NOT NULL DEFAULT '0',
  14. Messages VARCHAR(64) NOT NULL DEFAULT 'brak opisu.',
  15. Warns INT(11) NOT NULL DEFAULT '0',
  16. Skin SMALLINT(3) NOT NULL DEFAULT '0',
  17. House MEDIUMINT(5) NOT NULL DEFAULT '-1',
  18. Jail INT(11) NOT NULL DEFAULT '-1',
  19. PRIMARY KEY `nick and id` (id, nick)
  20. ) ENGINE = MyISAM AUTO_INCREMENT = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement