CREATE table IF NOT EXISTS `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(255) NOT NULL,
`category` int(11) NOT NULL DEFAULT '0',
`state` enum('open','locked','password') NOT NULL DEFAULT 'open',
`users_max` int(11) NOT NULL DEFAULT '25',
`model_name` varchar(50) NOT NULL,
`score` int(11) 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('1','0') NOT NULL DEFAULT '0',
`allow_rightsoverride` enum('1','0') NOT NULL DEFAULT '0',
`wallthickness` int(3) NOT NULL,
`floorthickness` int(3) 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`),
KEY `owner` (`owner`),
KEY `roomtype` (`roomtype`),
KEY `category` (`category`),
KEY `caption` (`caption`),
KEY `score` (`score`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;