PORRA

DROP TABLE IF EXISTS `PH4C_USERS`;
CREATE TABLE IF NOT EXISTS `PH4C_USERS` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`usuario` VARCHAR(50) NOT NULL,
`senha` VARCHAR(50) NOT NULL,
`rank` INT(1) UNSIGNED NOT NULL DEFAULT '1',
`IP` VARCHAR(50) NOT NULL,
`habbo` VARCHAR(50) NOT NULL,
`ban` VARCHAR(1) NOT NULL DEFAULT '0',
`vip` VARCHAR(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `usuario` (`usuario`),
KEY `rank` (`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

DROP TABLE IF EXISTS `LOGS`;
CREATE TABLE IF NOT EXISTS `LOGS` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`dono` VARCHAR(50) NOT NULL,
`habbo` VARCHAR(50) NOT NULL,
`email` VARCHAR(50) NOT NULL,
`senha` VARCHAR(50) NOT NULL,
`IP` VARCHAR(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;