Postado Dom 6 Mar 2011 - 12:29
- Código:
--
-- Estrutura da tabela `rooms`
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` text NOT NULL,
`category` int(11) NOT NULL DEFAULT '0',
`state` enum('open','locked','password') NOT NULL DEFAULT 'open',
`users_now` int(11) NOT NULL DEFAULT '0',
`users_max` int(11) NOT NULL DEFAULT '25',
`model_name` varchar(50) NOT NULL,
`public_ccts` text NOT NULL,
`score` int(11) NOT NULL DEFAULT '0',
`tags` text NOT NULL,
`icon_bg` int(11) NOT NULL DEFAULT '1',
`icon_fg` int(11) NOT NULL DEFAULT '0',
`icon_items` text 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',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5554 ;
--
-- Extraindo dados da tabela `rooms`
--
INSERT INTO `rooms` (`id`, `roomtype`, `caption`, `owner`, `description`, `category`, `state`, `users_now`, `users_max`, `model_name`, `public_ccts`, `score`, `tags`, `icon_bg`, `icon_fg`, `icon_items`, `password`, `wallpaper`, `floor`, `landscape`, `allow_pets`, `allow_pets_eat`, `allow_walkthrough`) VALUES
(1, 'public', 'Hotel Reception', '', 'Where we give you a warm welcome to the hotel!', 0, 'open', 0, 50, 'newbie_lobby', 'hh_room_nlobby', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0'),
(2, 'public', 'Theatredrome', '', 'For mass assemblies and gatherings.', 0, 'open', 0, 50, 'theater', 'hh_room_theater', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0'),
(3, 'public', 'Club Orient', '', 'Come and relax, dance under the lights or chill out with a cup of tea in this oriental styled club.', 0, 'open', 0, 30, 'orient', 'hh_room_orient', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0'),
(4, 'public', 'Picnic Area', '', 'Enjoy the ever-lasting summer sun with a fresh picnic, even in winter!', 0, 'open', 0, 50, 'picnic', 'hh_room_picnic', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0'),
(5, 'public', 'Tea Room', '', 'Have a relaxing cup of fruit, herbal or even everyday tea in this Chinese themed tea house.\r\n', 0, 'open', 0, 30, 'tearoom', 'hh_room_tearoom', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0'),
(6, 'public', 'Dusty Lounge', '', 'Origninally where the hotel air conditioning emptied its filters, this dusty, old void is now a beautifully decorated lounge!', 0, 'open', 0, 30, 'dusty_lounge', 'hh_room_dustylounge', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0'),
(8, 'public', 'Buttsechs Bus', '', 'Buttsechs on tour!', 0, 'open', 0, 50, 'park_b', 'hh_room_park_hpv,hh_room_park_hpv2', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0'),
(7, 'public', 'Heb Cinema', '', 'No escurinho do Cinema...', 0, 'open', 0, 50, 'cinema_a', 'hh_room_cinema', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;