(Resolvido)Erro faltando coluna no PHPMyadmin

[vitinhoo96 0]

Estou com esse erro, alguem pode me ajudar a criar essa tabela no phpmyadmin?

 

Está surgindo algum erro? Se sim coloque-o aqui. 

Citar

mysql_real_query(): SELECT `value` FROM `account_storage` WHERE `account_id` = 4 and `key` = 145144 LIMIT 1; - MYSQL ERROR: Table 'baiak2.account_storage' doesn't exist (1146)

 

 

[Aksz 46]

Bom dia!
 

CREATE TABLE `account_storage` (
`account_id` int(11) NOT NULL default '0',
`key` int(10) unsigned NOT NULL default '0',
`value` varchar(255) NOT NULL default '0',
UNIQUE KEY `account_id_2` (`account_id`,`key`),
KEY `account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[vitinhoo96 0]

1 hora atrás, Aksz disse:

Bom dia!
 

CREATE TABLE `account_storage` (
`account_id` int(11) NOT NULL default '0',
`key` int(10) unsigned NOT NULL default '0',
`value` varchar(255) NOT NULL default '0',
UNIQUE KEY `account_id_2` (`account_id`,`key`),
KEY `account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Bom dia,

Cara me salvou em kkkk resolvido, muito obrigado

[vitinhoo96 0]

14 horas atrás, Aksz disse:

Bom dia!
 

CREATE TABLE `account_storage` (
`account_id` int(11) NOT NULL default '0',
`key` int(10) unsigned NOT NULL default '0',
`value` varchar(255) NOT NULL default '0',
UNIQUE KEY `account_id_2` (`account_id`,`key`),
KEY `account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

Agora deu erro em outra tabela, poderia me ajudar?

 

mysql_real_query(): INSERT INTO top_mining (player_id,lvl,exp) VALUES ("61","1","4634") - MYSQL ERROR: Table 'baiak2.top_mining' doesn't exist (1146)