-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `havana`
--

-- --------------------------------------------------------

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` int(11) NOT NULL,
  `owner_id` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` int(11) DEFAULT 2,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ccts` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `wallpaper` int(4) DEFAULT 0,
  `floor` int(4) DEFAULT 0,
  `landscape` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `showname` tinyint(1) DEFAULT 1,
  `superusers` tinyint(1) DEFAULT 0,
  `accesstype` tinyint(3) DEFAULT 0,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `visitors_now` int(11) DEFAULT 0,
  `visitors_max` int(11) DEFAULT 25,
  `rating` int(11) NOT NULL DEFAULT 0,
  `icon_data` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0|0|',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` (`id`, `owner_id`, `category`, `name`, `description`, `model`, `ccts`, `wallpaper`, `floor`, `landscape`, `showname`, `superusers`, `accesstype`, `password`, `visitors_now`, `visitors_max`, `rating`, `icon_data`, `created_at`, `updated_at`) VALUES
(1, '0', 3, 'Welcome Lounge', 'welcome_lounge', 'newbie_lobby', 'hh_room_nlobby', 0, 0, '0.0', 0, 0, 0, '', 0, 40, 0, '0|0|', '2018-08-11 07:54:01', '2019-01-05 14:23:12'),
(2, '0', 3, 'Theatredome', 'theatredrome', 'theater', 'hh_room_theater_xmas', 0, 0, '0.0', 0, 0, 0, '', 0, 100, 0, '0|0|', '2018-08-11 07:54:01', '2019-01-06 10:07:41'),
(3, '0', 3, 'Library', 'library', 'library', 'hh_room_library', 0, 0, '0.0', 0, 0, 0, '', 0, 30, 0, '0|0|', '2018-08-11 07:54:01', '2019-01-06 10:17:52'),
(4, '0', 5, 'TV Studio', 'tv_studio', 'tv_studio', 'hh_room_tv_studio_general', 0, 0, '0.0', 0, 0, 0, '', 0, 20, 0, '0|0|', '2018-08-11 07:54:01', '2019-01-06 00:35:02'),
(5, '0', 5, 'Cinema', 'habbo_cinema', 'cinema_a', 'hh_room_cinema', 0, 0, '0.0', 0, 0, 0, '', 0, 50, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-09 12:06:19'),
(6, '0', 5, 'Power Gym', 'sport', 'sport', 'hh_room_sport', 0, 0, '0.0', 0, 0, 0, '', 0, 35, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-09 18:41:10'),
(7, '0', 5, 'Olympic Stadium', 'ballroom', 'ballroom', 'hh_room_ballroom', 0, 0, '0.0', 0, 0, 0, '', 0, 50, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-28 06:39:30'),
(8, '0', 5, 'Habbo Kitchen', 'hotel_kitchen', 'cr_kitchen', 'hh_room_kitchen', 0, 0, '0.0', 0, 0, 0, '', 0, 20, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-28 18:39:46'),
(9, '0', 6, 'The Dirty Duck Pub', 'the_dirty_duck_pub', 'pub_a', 'hh_room_pub', 0, 0, '0.0', 0, 0, 0, '', 0, 40, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-29 05:44:21'),
(10, '0', 6, 'Cafe Ole', 'cafe_ole', 'cafe_ole', 'hh_room_cafe_xms08', 0, 0, '0.0', 0, 0, 0, '', 0, 35, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-02 12:10:45'),
(11, '0', 6, 'Eric\'s Eaterie', 'eric\'s_eaterie', 'cr_cafe', 'hh_room_erics', 0, 0, '0.0', 0, 0, 0, '', 0, 35, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-09 15:14:52'),
(12, '0', 6, 'Space Cafe', 'space_cafe', 'space_cafe', 'hh_room_space_cafe', 0, 0, '0.0', 0, 0, 0, '', 0, 35, 0, '0|0|', '2018-08-11 07:54:01', '2019-01-04 02:01:02'),
(13, '0', 7, 'Rooftop Terrace', 'rooftop', 'rooftop', 'hh_room_rooftop_xms08', 0, 0, '0.0', 0, 0, 0, '', 0, 30, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-29 04:53:59'),
(14, '0', 7, 'Rooftop Cafe', 'rooftop', 'rooftop_2', 'hh_room_rooftop', 0, 0, '0.0', 0, 0, 0, '', 0, 20, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-29 04:55:15'),
(15, '0', 6, 'Palazzo Pizza', 'pizza', 'pizza', 'hh_room_pizza', 0, 0, '0.0', 0, 0, 0, '', 0, 40, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-02 13:10:11'),
(16, '0', 6, 'Habburgers', 'habburger\'s', 'habburger', 'hh_room_habburger', 0, 0, '0.0', 0, 0, 0, '', 0, 40, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-03 14:30:22'),
(17, '0', 8, 'Grandfathers Lounge', 'dusty_lounge', 'dusty_lounge', 'hh_room_dustylounge', 0, 0, '0.0', 0, 0, 0, '', 0, 45, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-24 19:16:05'),
(18, '0', 7, 'Oriental Tearoom', 'tearoom', 'tearoom', 'hh_room_tearoom', 0, 0, '0.0', 0, 0, 0, '', 0, 40, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-27 10:00:43'),
(19, '0', 7, 'Oldskool Lounge', 'old_skool', 'old_skool0', 'hh_room_old_skool', 0, 0, '0.0', 0, 0, 0, '', 0, 45, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-08 17:44:58'),
(20, '0', 7, 'Oldskool Dancefloor', 'old_skool', 'old_skool1', 'hh_room_old_skool', 0, 0, '0.0', 0, 0, 0, '', 0, 45, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-27 03:13:48'),
(21, '0', 7, 'The Chromide Club', 'the_chromide_club', 'malja_bar_a', 'hh_room_disco', 0, 0, '0.0', 0, 0, 0, '', 0, 45, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-28 10:57:04'),
(22, '0', 7, 'The Chromide Club II', 'the_chromide_club', 'malja_bar_b', 'hh_room_disco', 0, 0, '0.0', 0, 0, 0, '', 0, 50, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-27 13:22:48'),
(23, '0', 7, 'Club Massiva', 'club_massiva', 'bar_a', 'hh_room_bar', 0, 0, '0.0', 0, 0, 0, '', 0, 45, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-29 04:08:38'),
(24, '0', 7, 'Club Massiva II', 'club_massiva2', 'bar_b', 'hh_room_bar', 0, 0, '0.0', 0, 0, 0, '', 0, 70, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-27 03:12:16'),
(25, '0', 6, 'Sunset Cafe', 'sunset_cafe', 'sunset_cafe', 'hh_room_sunsetcafe', 0, 0, '0.0', 0, 0, 0, '', 0, 35, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-29 04:08:17'),
(26, '0', 7, 'Oasis Spa', 'cafe_gold', 'cafe_gold0', 'hh_room_gold', 0, 0, '0.0', 0, 0, 0, '', 0, 50, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-01 14:48:26'),
(27, '0', 9, 'Zen Garden', 'chill', 'chill', 'hh_room_chill', 0, 0, '0.0', 0, 0, 0, '', 0, 30, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-06 19:08:16'),
(28, '0', 8, 'Club Mammoth', 'club_mammoth', 'club_mammoth', 'hh_room_clubmammoth', 0, 0, '0.0', 0, 0, 0, '', 0, 45, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-10 14:36:10'),
(29, '0', 9, 'Floating Garden', 'floatinggarden', 'floatinggarden', 'hh_room_floatinggarden', 0, 0, '0.0', 0, 0, 0, '', 0, 80, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-09 17:32:58'),
(30, '0', 9, 'Picnic Fields', 'picnic', 'picnic', 'hh_room_picnic', 0, 0, '0.0', 0, 0, 0, '', 0, 55, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-06 18:42:09'),
(31, '0', 9, 'Sun Terrace', 'sun_terrace', 'sun_terrace', 'hh_room_sun_xms08', 0, 0, '0.0', 0, 0, 0, '', 0, 50, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-09 14:46:35'),
(32, '0', 9, 'Peaceful Park', 'gate_park', 'gate_park', 'hh_room_gate_park', 0, 0, '0.0', 0, 0, 0, '', 0, 50, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-06 17:41:03'),
(33, '0', 9, 'Peaceful Park - B', 'gate_park', 'gate_park_2', 'hh_room_gate_park', 0, 0, '0.0', 0, 0, 0, '', 0, 50, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-06 17:41:13'),
(34, '0', 9, 'The Park', 'park', 'park_a', 'hh_room_park,hh_room_park_general', 0, 0, '0.0', 0, 0, 0, '', 0, 45, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-21 01:01:26'),
(35, '0', 9, 'The Infobus', 'park', 'park_b', 'hh_room_park,hh_people_pool', 0, 0, '0.0', 0, 0, 0, '', 0, 20, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-21 01:01:12'),
(36, '0', 10, 'Habbo Lido', 'habbo_lido', 'pool_a', 'hh_room_pool_calippo,hh_people_pool', 0, 0, '0.0', 0, 0, 0, '', 0, 60, 0, '0|0|', '2018-08-11 07:54:01', '2019-01-04 02:01:19'),
(37, '0', 10, 'Lido B', 'habbo_lido_ii', 'pool_b', 'hh_room_pool_calippo,hh_people_pool', 0, 0, '0.0', 0, 0, 0, '', 0, 60, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-17 20:58:58'),
(38, '0', 10, 'Rooftop Rumble', 'rooftop_rumble', 'md_a', 'hh_room_terrace,hh_paalu,hh_people_pool,hh_people_paalu', 0, 0, '0.0', 0, 0, 0, '', 0, 50, 0, '0|0|', '2018-08-11 07:54:01', '2019-01-03 22:55:55'),
(39, '0', 11, 'Main Lobby', 'main_lobby', 'lobby_a', 'hh_room_lobby_xms08', 0, 0, '0.0', 0, 0, 0, '', 0, 100, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-11 13:31:01'),
(40, '0', 11, 'Basement Lobby', 'basement_lobby', 'floorlobby_a', 'hh_room_floorlobbies', 0, 0, '0.0', 0, 0, 0, '', 0, 50, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-26 08:53:15'),
(41, '0', 11, 'Median Lobby', 'median_lobby', 'floorlobby_b', 'hh_room_floorlobbies', 0, 0, '0.0', 0, 0, 0, '', 0, 50, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-21 01:01:36'),
(42, '0', 11, 'Skylight Lobby', 'skylight_lobby', 'floorlobby_c', 'hh_room_floorlobbies', 0, 0, '0.0', 0, 0, 0, '', 0, 50, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-27 12:51:59'),
(43, '0', 6, 'Ice Cafe', 'ice_cafe', 'ice_cafe', 'hh_room_icecafe', 0, 0, '0.0', 0, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-02 12:10:28'),
(44, '0', 6, 'Net Cafe', 'netcafe', 'netcafe', 'hh_room_netcafe', 0, 0, '0.0', 0, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-08 09:11:20'),
(45, '0', 5, 'Beauty Salon', 'beauty_salon_loreal', 'beauty_salon0', 'hh_room_beauty_salon_general', 0, 0, '0.0', 0, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-05 14:38:58'),
(46, '0', 5, 'The Den', 'the_den', 'cr_staff', 'hh_room_den', 0, 0, '0.0', 0, 0, 0, '', 0, 100, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-26 16:07:49'),
(47, '0', 12, 'Lower Hallways', 'hallway', 'hallway2', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2019-01-06 00:40:48'),
(48, '0', 12, 'Lower Hallways I', 'hallway', 'hallway0', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-25 11:02:50'),
(49, '0', 12, 'Lower Hallways II', 'hallway', 'hallway1', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-25 11:01:15'),
(50, '0', 12, 'Lower Hallways III', 'hallway', 'hallway3', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-25 11:01:03'),
(51, '0', 12, 'Lower Hallways IV', 'hallway', 'hallway5', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-05 16:24:26'),
(52, '0', 12, 'Lower Hallways V', 'hallway', 'hallway4', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2019-01-06 00:41:06'),
(53, '0', 12, 'Upper Hallways', 'hallway_ii', 'hallway9', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-09 16:37:01'),
(54, '0', 12, 'Upper Hallways I', 'hallway_ii', 'hallway8', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-09 01:58:56'),
(55, '0', 12, 'Upper Hallways II', 'hallway_ii', 'hallway7', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-09 11:55:41'),
(56, '0', 12, 'Upper Hallways III', 'hallway_ii', 'hallway6', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-09 12:13:37'),
(57, '0', 12, 'Upper Hallways IV', 'hallway_ii', 'hallway10', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-26 16:19:02'),
(58, '0', 12, 'Upper Hallways V', 'hallway_ii', 'hallway11', 'hh_room_hallway', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-09 17:00:35'),
(59, '0', 7, 'Star Lounge', 'star_lounge', 'star_lounge', 'hh_room_starlounge', 0, 0, '0.0', 1, 0, 0, '', 0, 35, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-27 13:23:24'),
(60, '0', 8, 'Club Orient', 'orient', 'orient', 'hh_room_orient_hw08', 0, 0, '0.0', 1, 0, 0, '', 0, 35, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-27 14:45:58'),
(61, '0', 13, 'Cunning Fox Gamehall', 'cunning_fox_gamehall', 'entryhall', 'hh_room_gamehall,hh_games', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-08 19:46:24'),
(62, '0', 13, 'TicTacToe hall', 'cunning_fox_gamehall/1', 'hallA', 'hh_room_gamehall,hh_games', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-30 11:42:25'),
(63, '0', 13, 'Battleships hall', 'cunning_fox_gamehall/2', 'hallB', 'hh_room_gamehall,hh_games', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-16 10:09:55'),
(64, '0', 13, 'Chess hall', 'cunning_fox_gamehall/3', 'hallC', 'hh_room_gamehall,hh_games', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-30 11:40:22'),
(65, '0', 13, 'Poker hall', 'cunning_fox_gamehall/4', 'hallD', 'hh_room_gamehall,hh_games', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-11-16 10:09:34'),
(66, '0', 13, 'Battleball Lobby', 'bb_lobby_beginner_0', 'bb_lobby_1', 'hh_game_bb,hh_game_bb_room,hh_game_bb_ui,hh_gamesys', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-21 02:26:42'),
(67, '0', 13, 'Snowstorm Lobby', 'sw_lobby_beginner_0', 'snowwar_lobby_1', 'hh_gamesys,hh_game_snowwar,hh_game_snowwar_room,hh_game_snowwar_ui', 0, 0, '0.0', 1, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-21 01:01:44'),
(68, '0', 5, 'Imperial Palace', 'emperors', 'emperors', 'hh_room_emperors', 0, 0, '0.0', 0, 0, 0, '', 0, 30, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-09 02:39:19'),
(69, '0', 5, 'Beauty Salon II', 'beauty_salon_loreal', 'beauty_salon1', 'hh_room_beauty_salon_general', 0, 0, '0.0', 0, 0, 0, '', 0, 25, 0, '0|0|', '2018-08-11 07:54:01', '2018-12-05 14:54:14');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rooms`
--
ALTER TABLE `rooms`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `rooms`
--
ALTER TABLE `rooms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1000;
COMMIT;

