Bugamento no Quarto

CREATE table `rooms` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`roomtype` enum('public','private') NOT NULL DEFAULT 'private',
`caption` varchar(100) NOT NULL DEFAULT 'Room',
`owner` varchar(75) NOT NULL DEFAULT '',
`description` varchar(200) NOT NULL,
`category` int(2) NOT NULL DEFAULT '1',
`state` enum('open','locked','password','invisible') NOT NULL DEFAULT 'open',
`users_max` int(3) NOT NULL DEFAULT '25',
`model_name` varchar(20) NOT NULL,
`score` int(6) NOT NULL DEFAULT '0',
`tags` varchar(100) NOT NULL,
`password` text NOT NULL,
`wallpaper` varchar(10) NOT NULL DEFAULT '0.0',
`floor` varchar(10) NOT NULL DEFAULT '0.0',
`landscape` varchar(10) NOT NULL DEFAULT '0.0',
`allow_pets` enum('0','1') NOT NULL DEFAULT '1',
`allow_pets_eat` enum('0','1') NOT NULL DEFAULT '0',
`allow_walkthrough` enum('0','1') NOT NULL DEFAULT '0',
`allow_hidewall` enum('0','1') NOT NULL DEFAULT '0',
`allow_rightsoverride` enum('0','1') NOT NULL DEFAULT '0',
`floorthickness` int(6) NOT NULL,
`wallthickness` int(6) NOT NULL,
`moderation_mute_fuse` enum('0','1') NOT NULL DEFAULT '0',
`moderation_kick_fuse` enum('0','1','2') NOT NULL DEFAULT '0',
`moderation_ban_fuse` enum('0','1') DEFAULT '0',
`groupId` int(11) DEFAULT '0',
`bubble_mode` enum('0','1') DEFAULT '0',
`bubble_type` enum('0','1','2') DEFAULT '0',
`bubble_scroll` enum('0','1','2') DEFAULT '0',
`trade_settings` int(1) NOT NULL DEFAULT '0',
`antiflood_settings` int(1) NOT NULL DEFAULT '0',
`chat_distance` int(1) NOT NULL DEFAULT '0',
`wall_height` int(2) NOT NULL DEFAULT '-1',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`) USING HASH,
KEY `owner` (`owner`) USING BTREE,
KEY `category` (`category`) USING BTREE,
KEY `caption` (`caption`) USING BTREE,
KEY `tags` (`tags`) USING BTREE 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;