@zLockey9 tenta assim:
 

CREATE TABLE `pet_all_info_system` (
  `id` int(11) NOT NULL auto_increment,
  `player_id` int(11) NOT NULL,
  `player_name` varchar(255) NOT NULL,
  `pet_name` varchar(255) NOT NULL,
  `pet_level` int(11) NOT NULL,
  `pet_experience` int(11) NOT NULL,
  `pet_hp` int(11) NOT NULL,
  `pet_hp_max` int(11) NOT NULL,
  `pet_base_name` varchar(255) NOT NULL,
  `date` int(11),
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

CREATE TABLE `pet_experience_info_system` (
  `id` int(11) NOT NULL,
  `experience_base` bigint(11) NOT NULL,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB;

 

6 minutos atrás, Rayo disse:

@zLockey9 tenta assim:
 

CREATE TABLE `pet_all_info_system` (
  `id` int(11) NOT NULL auto_increment,
  `player_id` int(11) NOT NULL,
  `player_name` varchar(255) NOT NULL,
  `pet_name` varchar(255) NOT NULL,
  `pet_level` int(11) NOT NULL,
  `pet_experience` int(11) NOT NULL,
  `pet_hp` int(11) NOT NULL,
  `pet_hp_max` int(11) NOT NULL,
  `pet_base_name` varchar(255) NOT NULL,
  `date` int(11),
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

CREATE TABLE `pet_experience_info_system` (
  `id` int(11) NOT NULL,
  `experience_base` bigint(11) NOT NULL,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB;

 

 

Mesmo erro  

Estou tentando executar no Open SQL editor ( ALT+E ) , é lá msm ?

Editado Agosto 6, 2019 5 anos por zLockey9 (veja o histórico de edições)

@zLockey9 tenta desta forma:
 

CREATE TABLE `pet_all_info_system` (
  `id` int(11) NOT NULL auto_increment,
  `player_id` int(11) NOT NULL,
  `player_name` varchar(255) NOT NULL,
  `pet_name` varchar(255) NOT NULL,
  `pet_level` int(11) NOT NULL,
  `pet_experience` int(11) NOT NULL,
  `pet_hp` int(11) NOT NULL,
  `pet_hp_max` int(11) NOT NULL,
  `pet_base_name` varchar(255) NOT NULL,
  `date` int(11),
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

CREATE TABLE `pet_experience_info_system` (
  `id` int(11) NOT NULL,
  `experience_base` bigint(11) NOT NULL,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB;

Eu testei e funcionou:

7 minutos atrás, Rayo disse:

@zLockey9 tenta desta forma:
 

CREATE TABLE `pet_all_info_system` (
  `id` int(11) NOT NULL auto_increment,
  `player_id` int(11) NOT NULL,
  `player_name` varchar(255) NOT NULL,
  `pet_name` varchar(255) NOT NULL,
  `pet_level` int(11) NOT NULL,
  `pet_experience` int(11) NOT NULL,
  `pet_hp` int(11) NOT NULL,
  `pet_hp_max` int(11) NOT NULL,
  `pet_base_name` varchar(255) NOT NULL,
  `date` int(11),
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

CREATE TABLE `pet_experience_info_system` (
  `id` int(11) NOT NULL,
  `experience_base` bigint(11) NOT NULL,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB;

Eu testei e funcionou:

 

Mesma coisa , sempre erro no ENGINE

@zLockey9 amigo ,tenta com o MySQL Workbrench(o que eu uso),por que as vezes pode ser algum recurso que o seu SQL Editor não tem.