[FIX] Erros DB

Olá hoje irei postar uma sequencia de fix de erros no Banco de Dados (DB).

Irei passar os códigos SQL, só pasta ir em sua DB, clicar na aba SQL, por esse código e executar.

Erros:

Unknown column 'working' in 'field list'

ALTER TABLE `users` ADD COLUMN `working` varchar(50) NOT NULL DEFAULT '0'

Unknown column 'secretcode' in 'field list'

ALTER TABLE `users` ADD COLUMN `secretcode` varchar(50) NOT NULL DEFAULT '0'

Unknown column 'mymusik' in 'field list

ALTER TABLE `users` ADD COLUMN `mymusik` varchar(50) NOT NULL DEFAULT '0'

Unknown column 'pethair' in 'field list'

ALTER TABLE `user_pets` ADD COLUMN `pethair` int(11) NOT NULL

Unknown column 'hairdye' in 'field list'*Novo

ALTER TABLE `user_pets` ADD COLUMN `hairdye` int(11) NOT NULL

Table 'homes_stickers' doesn't exist*Novo


CREATE TABLE IF NOT EXISTS `homes_stickers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`x` varchar(6) NOT NULL DEFAULT '1' COMMENT 'left',
`y` varchar(6) NOT NULL DEFAULT '1' COMMENT 'top',
`z` varchar(6) NOT NULL DEFAULT '1' COMMENT 'boder:',
`data` text NOT NULL,
`type` varchar(1) NOT NULL DEFAULT '1',
`subtype` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Widget Type (if widget)',
`skin` text NOT NULL,
`groupid` int(11) NOT NULL DEFAULT '-1',
`var` int(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

Table 'habbo.homes_group_linker' doesn't exist*Novo

CREATE TABLE IF NOT EXISTS `homes_group_linker` (
`userid` int(11) NOT NULL,
`groupid` int(11) NOT NULL,
`active` varchar(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Créditos :
~ Power Pixel Fórum

COMPARTILHAR