CREATE DATABASE testgame DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE testgame;   

CREATE TABLE `users` (
   id_user bigint(20) unsigned NOT NULL auto_increment,
   email CHAR(64),      
   pass CHAR(32),     
   name CHAR(32),  
   life INT DEFAULT 50,
   atk INT DEFAULT 7,
   def INT DEFAULT 5,
   lov INT DEFAULT 7,
   lvl INT DEFAULT 1,
   exp INT DEFAULT 0,
   ip CHAR(15),
   PRIMARY KEY (id_user)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `avatar` (
   id_ava bigint(20) unsigned NOT NULL auto_increment,
   gander INT(2),
   vid CHAR(32),
   path CHAR(32),
   PRIMARY KEY (`id_ava`)
) ENGINE=MyISAM;

CREATE TABLE `chat` (
   id_msg bigint(20) unsigned NOT NULL auto_increment,
   msg CHAR(255),
   time_msg CHAR(5),
   wrt_user CHAR(32),
   who CHAR(32),
   PRIMARY KEY (`id_msg`)
) ENGINE=MyISAM;

CREATE TABLE `inventar` (
   id_inv bigint(20) unsigned NOT NULL auto_increment,
   name_object CHAR(64),
   atk_up INT(2),
   def_up INT(2),
   lov_up INT(2),
   life_up INT(4),
   PRIMARY KEY (`id_inv`)
) ENGINE=MyISAM;

CREATE TABLE `quest` (
   id_quest bigint(20) unsigned NOT NULL auto_increment,
   cont_quest CHAR(32),
   kill_quest INT DEFAULT 0,
   PRIMARY KEY (`id_quest`)
) ENGINE=MyISAM;

CREATE TABLE `battle` (
   id_btl bigint(20) unsigned NOT NULL auto_increment,
   end_btl CHAR(32),
   PRIMARY KEY (`id_btl`)
) ENGINE=MyISAM;

CREATE TABLE `enemy` (
   id_enm bigint(20) unsigned NOT NULL auto_increment,
   name_enm CHAR(32),
   atk_enm INT,
   life_enm INT,
   def_enm INT,
   lov_enm INT,
   exp_enm INT,
   path_enm CHAR(32),
   PRIMARY KEY (`id_enm`)
) ENGINE=MyISAM;

INSERT INTO enemy (name_enm, atk_enm, life_enm, def_enm, lov_enm, exp_enm, path_enm)
VALUES('Призраки','7','40','6','4','10','path/enemy/');

id_enm BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,  
name_enm CHAR( 32 ) ,  
atk_enm INT,  
life_enm INT,  
def_enm INT,  
lov_enm INT,  
exp_enm INT,  
path_enm CHAR( 32 ) ,  
PRIMARY KEY ( `id_enm` )  
) ENGINE = MYISAM ;