Advertisement
Maddin

MySQL

Apr 8th, 2011
1,968
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.44 KB | None | 0 0
  1. DROP TABLE IF EXISTS `accounts`;
  2. CREATE 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.   PRIMARY KEY (`id`)
  12. ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement