CREATE TABLE `users` (  
     `id_user`    bigint(20) unsigned NOT NULL auto_increment,  
     `email`    CHAR(64),  
     `pass`  CHAR(16),  
     `name`  CHAR(16),
         `status`    int(10) unsigned NOT NULL default '1',
  `fraction` int(10) unsigned NOT NULL default '1',
  `class` varchar(15) NOT NULL default '',
     `consciousness`  INT DEFAULT 100,  
  `health` INT DEFAULT 100,
  `energy` double(11,1) NOT NULL default '10.0',
  `damagepsy`  INT DEFAULT 10,
     `damagebody`  INT DEFAULT 10,   
  `damageknife`  INT DEFAULT 0,  
     `damagelazer`  INT DEFAULT 0,  
     `morality`  INT DEFAULT 0,
  `endurance`  INT DEFAULT 5,  
     `armorknife`  INT DEFAULT 5,
     `armorlazer`  INT DEFAULT 5,  
     `rate`  INT DEFAULT 7,  
     `lvl`  INT DEFAULT 1,   
     `combatexperience`  INT DEFAULT 0,
     `knifeexperience`  INT DEFAULT 0,
  `lazerexperience`  INT DEFAULT 0,
  `ip` varchar(50) NOT NULL default '',
     PRIMARY KEY  (`id_user`)  
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;