DROP TABLE `room_categories`

CREATE TABLE IF NOT EXISTS `room_categories` (
  `id` int(3) NOT NULL default '0',
  `parent` int(3) NOT NULL default '0',
  `type` int(1) NOT NULL default '1',
  `name` varchar(100) collate latin1_general_ci NOT NULL default 'Non-named category',
  `access_rank_min` int(2) NOT NULL,
  `access_rank_hideforlower` enum('0','1') collate latin1_general_ci NOT NULL,
  `trading` enum('0','1') collate latin1_general_ci NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

INSERT INTO `room_categories` (`id`, `parent`, `type`, `name`, `access_rank_min`, `access_rank_hideforlower`, `trading`) VALUES
(29, 4, 2, 'Sans categories', 1, '1', '1'),
(28, 4, 2, 'Acceuils des nouveaux', 1, '0', '1'),
(22, 3, 0, 'Les Theatres', 1, '0', '0'),
(23, 3, 0, 'Les Piscines', 1, '0', '0'),
(25, 4, 2, 'Coin detente, discussions', 1, '0', '1'),
(26, 4, 2, 'Centre d''aides', 1, '0', '1'),
(27, 4, 2, 'Bar, pubs et cafe', 1, '0', '1'),
(10, 4, 2, 'Casinos et jeux', 1, '0', '1'),
(0, 1, 2, 'Apparts zen', 1, '0', '1'),
(3, 0, 0, 'Lieux Publiques', 1, '0', '0'),
(4, 0, 2, 'Apparts', 1, '0', '0'),
(6, 4, 2, 'Apparts des Staffs', 7, '0', '1');


INSERT INTO `rooms` (`id`, `name`, `description`, `owner`, `category`, `model`, `ccts`, `floor`, `wallpaper`, `state`, `password`, `showname`, `superusers`, `visitors_now`, `visitors_max`) VALUES

(1, 'Welcome Lounge', 'welcome_lounge', NULL, 3, 'newbie_lobby', 'hh_room_nlobby', 0, 0, 0, NULL, '1', '0', 0, 35),
(2, 'Librairie', 'library', NULL, 3, 'library', 'hh_room_library', 0, 0, 0, NULL, '1', '0', 0, 20),

(3, 'Piscine A', 'habbo_lido', NULL, 23, 'pool_a', 'hh_room_pool,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),
(4, 'Piscine B', 'habbo_lido_ii', NULL, 23, 'pool_b', 'hh_room_pool,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),
(5, 'Piscine A Calippo', 'habbo_lido', NULL, 23, 'pool_a', 'hh_room_pool_calippo,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),
(6, 'Piscine B Calippo', 'habbo_lido_ii', NULL, 23, 'pool_b', 'hh_room_pool_calippo,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),

(7, 'Theatre', 'theatredrome', NULL, 22, 'theater', 'hh_room_theater', 0, 0, 0, NULL, '1', '0', 0, 40),
(8, 'Theatre Halloween', 'theatredrome_halloween', NULL, 22, 'theater', 'hh_room_theater_halloween', 0, 0, 0, NULL, '1', '0', 0, 40),
(9, 'Theatre AXE', 'theatredrome', NULL, 22, 'theater', 'hh_room_theater_axe', 0, 0, 0, NULL, '1', '0', 0, 40),
(10, 'Theatre Deli', 'theatredrome', NULL, 22, 'theater', 'hh_room_theater_deli', 0, 0, 0, NULL, '1', '0', 0, 40),
(11, 'Theatre Pacques', 'theatredrome', NULL, 22, 'theater', 'hh_room_theater_easter', 0, 0, 0, NULL, '1', '0', 0, 40),
(12, 'Theatre Habbowood', 'theatredrome', NULL, 22, 'theater', 'hh_room_theater_hbowood', 0, 0, 0, NULL, '1', '0', 0, 40),
(13, 'Theatre Samsung', 'theatredrome', NULL, 22, 'theater', 'hh_room_theater_samsung', 0, 0, 0, NULL, '1', '0', 0, 40),
(14, 'Theatre Noel', 'theatredrome', NULL, 22, 'theater', 'hh_room_theater_xmas', 0, 0, 0, NULL, '1', '0', 0, 40),
(15, 'Theatre ST Valentin', 'theatredrome', NULL, 22, 'theater', 'hh_room_theater_valentine', 0, 0, 0, NULL, '1', '0', 0, 40),

(16, 'Sunset Cafe', 'sunset_cafe', NULL, 3, 'sunset_cafe', 'hh_room_sunsetcafe', 0, 0, 0, NULL, '1', '0', 0, 20),
(17, 'Duck Pub', 'the_dirty_duck_pub', NULL, 3, 'pub_a', 'hh_room_pub', 0, 0, 0, NULL, '1', '0', 0, 35),
(18, 'Jardins', 'floatinggarden', NULL, 3, 'floatinggarden', 'hh_room_floatinggarden', 0, 0, 0, NULL, '1', '0', 0, 30),
(19, 'Le toit', 'rooftop_rumble', NULL, 3, 'md_a', 'hh_room_terrace,hh_paalu,hh_people_pool,hh_people_paalu', 0, 0, 0, NULL, '1', '0', 0, 25),
(20, 'Picnic', 'picnic', NULL, 3, 'picnic', 'hh_room_picnic', 0, 0, 0, NULL, '1', '0', 0, 25),
(21, 'Parcs', 'park', NULL, 3, 'park_a', 'hh_room_park_general,hh_room_park', 0, 0, 0, NULL, '1', '0', 0, 30),
(22, 'Infobus', 'park', NULL, 3, 'park_b', 'hh_room_park_general,hh_room_park', 0, 0, 0, NULL, '1', '0', 0, 15),
(23, 'The Den', 'picnic', NULL, 3, 'den', 'hh_room_den', 0, 0, 0, NULL, '1', '0', 0, 40);