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

START TRANSACTION;



--
-- Database: `a3dtimad_export23d`
--

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

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` (`id`, `name`, `email`, `address`, `phone`, `logo`, `created_at`, `updated_at`) VALUES
(1, 'Tile Visualizer', 'inbox@tiles.com', NULL, NULL, 'company/rLZSPckHsgWiY8m9Ol73MAZsSmWaB4f0P7pYesoS.png', NULL, '2018-11-01 08:34:16');

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

--
-- Table structure for table `filters`
--

CREATE TABLE `filters` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `field` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `surface` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'checkbox',
  `values` text COLLATE utf8mb4_unicode_ci,
  `enabled` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2017_02_27_200633_create_tasks_table', 1),
(10, '2017_02_28_141841_create_filters_table', 2),
(11, '2017_02_28_141926_create_rooms_table', 2),
(12, '2017_02_28_112616_create_tiles_table', 3),
(13, '2017_03_14_081503_create_companies_table', 4),
(14, '2017_03_14_090456_create_savedrooms_table', 4),
(15, '2017_06_26_102031_create_room2ds_table', 4),
(16, '2017_09_11_174519_create_surface_types_table', 4),
(17, '2017_09_11_224734_create_room_types_table', 4),
(18, '2017_10_19_165335_create_panoramas_table', 4),
(19, '2017_12_22_154328_create_custom_tiles_table', 4);

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

--
-- Table structure for table `room2ds`
--

CREATE TABLE `room2ds` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shadow` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shadow_matt` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surfaces` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `room2ds`
--

INSERT INTO `room2ds` (`id`, `name`, `type`, `icon`, `image`, `shadow`, `shadow_matt`, `surfaces`, `enabled`, `created_at`, `updated_at`) VALUES
(1, 'Living Room-8', 'livingroom', 'rooms2d/room_icon_47.jpg', 'rooms2d/room_background_47.png', 'rooms2d/NhQxZGlnhndrebkraI5lYmzgEowoqj3oiqSTqZEY.png', 'rooms2d/n3M7O09MJ5wb4xYA580TvGJPayWNjLvutvZZ2PRp.png', '[{\"0\":\"1\",\"1\":\"-32.1\",\"2\":\"-16.8\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"13.9\",\"10\":\"13.9\",\"11\":[[\"247\",\"0\"],[\"1303\",\"0\"],[\"1303\",\"566\"],[\"236\",\"566\"],[\"247\",\"0\"]],\"176\":\"wall\",\"group\":\"2\",\"cameraFov\":\"40\",\"viewVerticalOffset\":\"-163\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"2\",\"1\":\"29.9\",\"2\":\"-16.8\",\"3\":\"0\",\"4\":\"0\",\"5\":\"-87.5\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"13.9\",\"10\":\"13.9\",\"11\":[[\"1303\",\"0\"],[\"1600\",\"0\"],[\"1600\",\"571\"],[\"1303\",\"430\"],[\"1303\",\"0\"]],\"176\":\"wall\",\"group\":\"2\",\"cameraFov\":\"40\",\"viewVerticalOffset\":\"-163\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"3\",\"1\":\"-32.1\",\"2\":\"-16.5\",\"3\":\"0\",\"4\":\"-90.7\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"13.9\",\"10\":\"13.9\",\"11\":[[\"230\",\"566\"],[\"1082\",\"566\"],[\"1209\",\"801\"],[\"1600\",\"812\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"677\"]],\"176\":\"floor\",\"group\":\"3\",\"cameraFov\":\"40\",\"viewVerticalOffset\":\"-163\",\"viewHorizontalOffset\":\"0\"}]', 1, '2017-07-12 00:00:00', '2019-07-04 18:27:56'),
(2, 'Living Room', 'livingroom', 'rooms2d/qVBKEazw5XzUkcxBEqOiDSzNahD3EFMwG9GOiCPV.jpeg', 'rooms2d/zDg19NlfYPflc5cGEoR52cQ9EE0ywZUEmHqsaMqC.png', 'rooms2d/v1KSTTpp6rluh8llX9MVuP81lRiZZxHivqXChcow.png', 'rooms2d/0Gsld6PWT8wwXXEaaunJbZCzAfdnqj6QeopRar2o.png', '[{\"0\":\"1\",\"1\":\"-22.5\",\"2\":\"-10.37\",\"3\":\"0\",\"4\":\"-86.3\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"13.8\",\"10\":\"13.8\",\"11\":[[\"95\",\"900\"],[\"545\",\"561\"],[\"661\",\"559\"],[\"686\",\"513\"],[\"695\",\"467\"],[\"747\",\"464\"],[\"751\",\"490\"],[\"939\",\"493\"],[\"1237\",\"741\"],[\"1334\",\"752\"],[\"1334\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"-13\"}]', 1, '2017-09-28 17:17:02', '2017-10-10 02:22:09'),
(3, 'Living Room', 'livingroom', 'rooms2d/1itGLok5obnNApQTZQT7Z9n7NvC8yDS2nFBLcpHs.jpeg', 'rooms2d/gGyquqZKdSuxWylIH906qY2wIVbnJkBR6WdZMn3Y.png', 'rooms2d/nJWUMYUZXQj4ZYxUXFeDS8mzwYLpDSGX3l0I25ST.png', 'rooms2d/jTGbplGJO2qo9nHYCyY5stDBAPQr3u8JBKiHtPWC.png', '[{\"0\":\"1\",\"1\":\"1.1\",\"2\":\"2.3755\",\"3\":\"0\",\"4\":\"-78.4\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"17\",\"10\":\"17\",\"11\":[[\"0\",\"609\"],[\"502\",\"372\"],[\"1114\",\"367\"],[\"1600\",\"576\"],[\"1600\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"}]', 1, '2017-09-28 17:48:12', '2017-09-30 06:05:19'),
(4, 'Living Room', 'livingroom', 'rooms2d/3lXP6xrnHcHk5s9N6yswVdnRch7tTQnpFazSixt1.jpeg', 'rooms2d/MDBi7DtsljnEUqSaLpBjg0hCdX9HwkiooJymcZQ8.png', 'rooms2d/iw6Nkev3kvjH5bsQvCQy7jr6brzEXTYgchgHk958.png', 'rooms2d/LVmBNIqaoQpZnbygACV0Nft4gF9dTunnj4D6ecQV.png', '[{\"0\":\"1\",\"1\":\"-42.3\",\"2\":\"11.2\",\"3\":\"0\",\"4\":\"-48.3\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"22.5\",\"10\":\"22.5\",\"11\":[[\"0\",\"170\"],[\"1600\",\"231\"],[\"1600\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"30\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"}]', 1, '2017-10-02 08:44:09', '2017-10-02 09:01:43'),
(5, 'Living Room', 'livingroom', 'rooms2d/6RPrq70i8NFegAcRYIEsO8o6AJxyk6f30uQeaCmB.jpeg', 'rooms2d/JiaWpgaZJUxGh9vyYQfD11M3xAjIDL11Q2upgBU2.png', 'rooms2d/JFsfYMzhHacM42qaiVHHRnikfdJDyMLpEmbR8438.png', NULL, '[{\"0\":\"1\",\"1\":\"-35.2\",\"2\":\"-13.7\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"19\",\"10\":\"19\",\"11\":[[\"208\",\"0\"],[\"1600\",\"1\"],[\"1600\",\"678\"],[\"211\",\"678\"]],\"176\":\"wall\"},{\"0\":\"2\",\"1\":\"-35\",\"2\":\"-13.4\",\"3\":\"0\",\"4\":\"-88.6\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"18.9\",\"10\":\"18.9\",\"11\":[[\"210\",\"678\"],[\"1600\",\"678\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"773\"]],\"176\":\"floor\"}]', 1, '2017-09-18 10:51:18', '2017-09-18 15:47:06'),
(6, 'Living Room with Dining', 'livingroom', 'rooms2d/lTS66zqDKPubV7f6f1DqTPE5UyUNFZLvGhO5LKFG.jpeg', 'rooms2d/gKl5NOBupXffxwOJQV1j5zbfXrKPX6Bto3R5CTIh.png', 'rooms2d/8f3yLM0011PEdW2eWO5vezjDjS6AX1Pu9qv8DSHw.png', NULL, '[{\"0\":\"1\",\"1\":\"-30.2\",\"2\":\"-13\",\"3\":\"0\",\"4\":\"-86.7\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"20\",\"10\":\"20\",\"11\":[[\"59\",\"833\"],[\"431\",\"611\"],[\"1299\",\"614\"],[\"1374\",\"670\"],[\"1572\",\"796\"],[\"1575\",\"900\"],[\"55\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"40\"}]', 1, '2017-09-21 16:17:11', '2017-09-21 16:20:58'),
(7, 'Living Room', 'livingroom', 'rooms2d/9jPw88KBJoQ5pnkHQireugEB50xtTBdprdYCYG7H.jpeg', 'rooms2d/ohWeKKtIpq0ueGEN10EFbPGxdU6SPL1aPMqTQbhB.png', 'rooms2d/61IwVBpuHsnaxxGfxmW060HbQ3B9yqeeH9ArNbln.png', NULL, '[{\"0\":\"1\",\"1\":\"-47.8\",\"2\":\"-17\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"24\",\"10\":\"24\",\"11\":[[\"0\",\"0\"],[\"1600\",\"0\"],[\"1600\",\"730\"],[\"0\",\"730\"]],\"176\":\"wall\",\"cameraFov\":\"30\"},{\"0\":\"2\",\"1\":\"-47.8\",\"2\":\"-17.7\",\"3\":\"0\",\"4\":\"-78.4\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"24\",\"10\":\"24\",\"11\":[[\"0\",\"749\"],[\"1600\",\"749\"],[\"1600\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"30\"}]', 1, '2017-09-21 16:24:05', '2017-09-21 16:38:11'),
(8, 'Living Room', 'livingroom', 'rooms2d/XOEaSgXoVbe8zf5T84jJk06BA2d83uba3h4yUd1f.jpeg', 'rooms2d/aYirIAOzH51EYZpHYOnx0XrPhCuviBtPLCDnTscb.png', 'rooms2d/E80na87oxZJsX1892CpQec4jMAaqXNcgAusjISDk.png', NULL, '[{\"0\":\"1\",\"1\":\"-47.8\",\"2\":\"-5.6\",\"3\":\"0\",\"4\":\"-77.9\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"25\",\"10\":\"25\",\"11\":[[\"0\",\"544\"],[\"1600\",\"541\"],[\"1600\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\"}]', 1, '2017-09-18 11:09:30', '2017-09-18 11:15:33'),
(9, 'Living Room', 'livingroom', 'rooms2d/wFjCNO0nmQtKrPiXArbCt6bOaHsUvFKvvKBZiGo7.jpeg', 'rooms2d/8EbXKGiWuZ1eHHaeMOjWsX5gyHRamgUhNyDx71S8.png', 'rooms2d/vGyLfFyi134dRbbiumYosrINtvrx9FD0RulNWG9q.png', NULL, '[{\"0\":\"1\",\"1\":\"-33.9\",\"2\":\"-14.8\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"6000\",\"8\":\"6000\",\"9\":\"13\",\"10\":\"13\",\"11\":[[\"302\",\"63\"],[\"1600\",\"63\"],[\"1600\",\"581\"],[\"302\",\"581\"]],\"176\":\"wall\",\"cameraFov\":\"40\",\"viewVerticalOffset\":\"-84\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"2\",\"1\":\"-33.9\",\"2\":\"-14.646\",\"3\":\"0\",\"4\":\"-90.23\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"13\",\"10\":\"13\",\"11\":[[\"302\",\"581\"],[\"1600\",\"581\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"810\"],[\"302\",\"644\"]],\"176\":\"floor\",\"cameraFov\":\"40\",\"viewVerticalOffset\":\"-84\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"3\",\"1\":\"-25.9\",\"2\":\"-14.6\",\"3\":\"0\",\"4\":\"\",\"5\":\"90\",\"6\":\"\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"13\",\"10\":\"13\",\"11\":[[\"0\",\"0\"],[\"302\",\"0\"],[\"302\",\"644\"],[\"0\",\"810\"]],\"176\":\"wall\",\"cameraFov\":\"40\",\"viewVerticalOffset\":\"-84\",\"viewHorizontalOffset\":\"0\"}]', 1, '2017-09-21 16:40:59', '2017-10-10 02:25:55'),
(10, 'Living Room', 'livingroom', 'rooms2d/Nclds91C2FbSOPRTYgyJe5jPlcYbeWcYPzVLb6MB.jpeg', 'rooms2d/tdgOgSrzv4qx1QBmgwt1zlMdu8ruCdTpkCZSdZVw.png', 'rooms2d/tnevihUyhajvq1Tdeaba42MX94hhxyPJonpSIWYk.png', NULL, '[{\"0\":\"1\",\"1\":\"-24.8\",\"2\":\"-10\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"18\",\"10\":\"18\",\"11\":[[\"366\",\"0\"],[\"1600\",\"0\"],[\"1600\",\"617\"],[\"1275\",\"617\"],[\"1093\",\"617\"],[\"366\",\"593\"]],\"176\":\"wall\",\"cameraFov\":\"30\"},{\"0\":\"2\",\"1\":\"-25.2\",\"2\":\"-9.9\",\"3\":\"0\",\"4\":\"-89.35\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"18\",\"10\":\"18\",\"11\":[[\"379\",\"610\"],[\"1270\",\"617\"],[\"1600\",\"617\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"778\"],[\"274\",\"659\"]],\"176\":\"floor\",\"cameraFov\":\"30\"}]', 1, '2017-09-22 04:08:34', '2017-09-24 16:33:08'),
(11, 'Living Room', 'livingroom', 'rooms2d/2FEZtvz2pYswFKJkrNur0fCqMgnttmv0cBUtoj9M.jpeg', 'rooms2d/saHOvmZBCKVDH2N7PfiatpfBpnvxQpauB8cH6AFc.png', 'rooms2d/jmqJghWeMsb5t6gDqcot7ycZYdfuIi8hFdQPPwpf.png', NULL, '[{\"0\":\"1\",\"1\":\"-47.8\",\"2\":\"-5.1\",\"3\":\"0\",\"4\":\"-80.9\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"25\",\"10\":\"25\",\"11\":[[\"0\",\"536\"],[\"1600\",\"531\"],[\"1600\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\"}]', 1, '2017-09-18 11:56:37', '2017-09-18 12:03:29'),
(12, 'Living Room-3', 'livingroom', 'rooms2d/room_icon_6.jpg', 'rooms2d/room_background_6.png', 'rooms2d/room_foreground_6.png', NULL, '[{\"0\":\"1\",\"1\":\"-37.3\",\"2\":\"-14.4\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"3700\",\"8\":\"3700\",\"9\":\"23.3\",\"10\":\"23.3\",\"11\":[[\"0\",\"0\"],[\"1600\",\"0\"],[\"1600\",\"687.5\"],[\"0\",\"687.5\"],[\"0\",\"0\"]],\"176\":\"wall\"},{\"0\":\"2\",\"1\":\"-37.3\",\"2\":\"-14.4\",\"3\":\"20\",\"4\":\"-89\",\"5\":\"0\",\"6\":\"0\",\"7\":\"3700\",\"8\":\"3700\",\"9\":\"23.3\",\"10\":\"23.3\",\"11\":[[\"-4.5\",\"688.5\"],[\"1618.5\",\"686.5\"],[\"1604.5\",\"919.5\"],[\"-0.5\",\"917.5\"]],\"176\":\"floor\"}]', 1, '2017-07-12 00:00:00', '2017-09-16 05:59:21'),
(13, 'Kitchen-5', 'kitchen', 'rooms2d/room_icon_34.jpg', 'rooms2d/room_background_34.png', 'rooms2d/room_foreground_34.png', 'rooms2d/fzTbO8EdWAdf22PCxL1FCE9adNAZZCkvVPCOQVs5.png', '[{\"0\":\"1\",\"1\":\"-29.3\",\"2\":\"-8.1\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"3000\",\"8\":\"3000\",\"9\":\"19.4\",\"10\":\"19.4\",\"11\":[[\"365\",\"0\"],[\"1240\",\"0\"],[\"1240\",\"403\"],[\"365\",\"411\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-169\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"2\",\"1\":\"-18.8\",\"2\":\"-25\",\"3\":\"0\",\"4\":\"-90.4\",\"5\":\"0\",\"6\":\"0\",\"7\":\"3000\",\"8\":\"3000\",\"9\":\"19.4\",\"10\":\"19.4\",\"11\":[[\"310\",\"900\"],[\"510\",\"670\"],[\"1108\",\"672\"],[\"1231\",\"811\"],[\"1507\",\"861\"],[\"1550\",\"900\"],[\"310\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-169\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"3\",\"1\":\"29.4\",\"2\":\"-8.1\",\"3\":\"0\",\"4\":\"\",\"5\":\"-89\",\"6\":\"\",\"7\":\"3000\",\"8\":\"3000\",\"9\":\"19.4\",\"10\":\"19.4\",\"11\":[[\"1240\",\"0\"],[\"1600\",\"0\"],[\"1600\",\"900\"],[\"1551\",\"900\"],[\"1510\",\"865\"],[\"1513\",\"471\"],[\"1240\",\"404\"],[\"1240\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-169\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"4\",\"1\":\"-29\",\"2\":\"-8.1\",\"3\":\"0\",\"4\":\"\",\"5\":\"89\",\"6\":\"\",\"7\":\"3000\",\"8\":\"3000\",\"9\":\"19.4\",\"10\":\"19.4\",\"11\":[[\"297\",\"395\"],[\"297\",\"0\"],[\"365\",\"0\"],[\"365\",\"413.5\"],[\"0\",\"512.5\"],[\"0\",\"1\"],[\"58\",\"0\"],[\"61\",\"443\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-169\",\"viewHorizontalOffset\":\"0\"}]', 1, '2017-07-12 00:00:00', '2017-09-26 09:25:24'),
(14, 'Kitchen-7', 'kitchen', 'rooms2d/room_icon_45.jpg', 'rooms2d/room_background_45.png', 'rooms2d/room_foreground_45.png', 'rooms2d/Q1SeSQ4D92Fe2h90DWlQkKTrbzdIxf00swGLxAkd.png', '[{\"0\":\"1\",\"1\":\"-32\",\"2\":\"-8.6\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"17.7\",\"10\":\"17.7\",\"11\":[[\"258\",\"0\"],[\"1341\",\"0\"],[\"1341\",\"339\"],[\"258\",\"338\"],[\"258\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-256\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"2\",\"1\":\"-31.8\",\"2\":\"-23.1\",\"3\":\"0\",\"4\":\"-90\",\"5\":\"0\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"17.7\",\"10\":\"17.7\",\"11\":[[\"218\",\"617\"],[\"1381\",\"617\"],[\"1600\",\"777\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"777\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-256\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"3\",\"1\":\"31.7\",\"2\":\"-8.6\",\"3\":\"\",\"4\":\"0\",\"5\":\"-90\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"17.7\",\"10\":\"17.7\",\"11\":[[\"1342\",\"0\"],[\"1342\",\"337\"],[\"1381\",\"352\"],[\"1381\",\"618\"],[\"1600\",\"777\"],[\"1600\",\"0\"],[\"1341\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-256\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"4\",\"1\":\"-31.7\",\"2\":\"-8.6\",\"3\":\"\",\"4\":\"0\",\"5\":\"90\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"17.7\",\"10\":\"17.7\",\"11\":[[\"0\",\"0\"],[\"257.5\",\"0\"],[\"257.5\",\"340\"],[\"220\",\"615\"],[\"0\",\"777\"],[\"0\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-256\",\"viewHorizontalOffset\":\"0\"}]', 1, '2017-07-12 00:00:00', '2017-09-26 16:16:18'),
(15, 'Kitchen-2', 'kitchen', 'rooms2d/room_icon_26.jpg', 'rooms2d/room_background_26.png', 'rooms2d/room_foreground_26.png', NULL, '[{\"0\":\"1\",\"1\":\"-47.6\",\"2\":\"-7.7\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"13.3\",\"10\":\"13.3\",\"11\":[[\"0\",\"100\"],[\"469\",\"95\"],[\"469\",\"1\"],[\"1091\",\"0\"],[\"1094\",\"577\"],[\"430\",\"577\"],[\"0\",\"472\"],[\"0\",\"100\"]],\"176\":\"wall\",\"cameraFov\":\"30\"},{\"0\":\"2\",\"1\":\"-47.6\",\"2\":\"-7.7\",\"3\":\"0\",\"4\":\"-85.73\",\"5\":\"0\",\"6\":\"0\",\"7\":\"50000\",\"8\":\"50000\",\"9\":\"13.3\",\"10\":\"13.3\",\"11\":[[\"432\",\"576\"],[\"1100\",\"576\"],[\"1482\",\"900\"],[\"0\",\"900\"],[\"0\",\"833\"],[\"159\",\"797\"],[\"432\",\"576\"]],\"176\":\"floor\",\"cameraFov\":\"30\"}]', 1, '2017-07-12 00:00:00', '2017-09-22 13:52:40'),
(16, 'Kitchen-1', 'kitchen', 'rooms2d/room_icon_8.jpg', 'rooms2d/room_background_8.png', 'rooms2d/room_foreground_8.png', NULL, '[{\"0\":\"1\",\"1\":\"-45.7\",\"2\":\"-7.7\",\"3\":\"0\",\"4\":\"-86.48\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"13.06\",\"10\":\"13.06\",\"11\":[[\"0\",\"574\"],[\"1270\",\"579\"],[\"1600\",\"786\"],[\"1600\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"30\"},{\"0\":\"2\",\"1\":\"-45.7\",\"2\":\"3.9\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"13.06\",\"10\":\"13.06\",\"11\":[[\"0\",\"0\"],[\"1600\",\"0\"],[\"1600\",\"580.5\"],[\"0\",\"577.5\"],[\"0\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"30\"}]', 1, '2017-07-12 00:00:00', '2017-09-22 11:07:45'),
(17, 'Kitchen-4', 'kitchen', 'rooms2d/room_icon_29.jpg', 'rooms2d/room_background_29.png', 'rooms2d/room_foreground_29.png', NULL, '[{\"0\":\"1\",\"1\":\"-32.5\",\"2\":\"-3.1\",\"3\":\"0\",\"4\":\"-80\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"18.4\",\"10\":\"18.4\",\"11\":[[\"1369\",\"498\"],[\"1600\",\"644\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"641\"],[\"150\",\"489\"]],\"176\":\"floor\",\"cameraFov\":\"30\"}]', 1, '2017-07-12 00:00:00', '2017-09-22 11:18:08'),
(18, 'Kitchen-6', 'kitchen', 'rooms2d/room_icon_35.jpg', 'rooms2d/room_background_35.png', 'rooms2d/room_foreground_35.png', NULL, '[{\"0\":\"1\",\"1\":\"-28.8\",\"2\":\"-12.5\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"20\",\"10\":\"20\",\"11\":[[\"332\",\"0\"],[\"1600\",\"0\"],[\"1600\",\"657\"],[\"298.5\",\"657\"],[\"332\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"30\"},{\"0\":\"2\",\"1\":\"-28.8\",\"2\":\"-12.5\",\"3\":\"0\",\"4\":\"-86\",\"5\":\"0\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"20\",\"10\":\"20\",\"11\":[[\"321.5\",\"650.5\"],[\"1600\",\"657\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"865\"]],\"176\":\"floor\",\"cameraFov\":\"30\"}]', 1, '2017-07-12 00:00:00', '2017-09-22 17:11:38'),
(19, 'Kitchen-3', 'kitchen', 'rooms2d/room_icon_19.jpg', 'rooms2d/room_background_19.png', 'rooms2d/room_foreground_19.png', NULL, '[{\"0\":\"1\",\"1\":\"-41.6\",\"2\":\"-37.6\",\"3\":\"\",\"4\":\"0\",\"5\":\"90\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"29\",\"10\":\"29\",\"11\":[[\"0\",\"0\"],[\"540\",\"0\"],[\"539\",\"412\"],[\"203\",\"834\"],[\"128\",\"900\"],[\"0\",\"900\"],[\"0\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-129\",\"viewHorizontalOffset\":\"-25\"},{\"0\":\"2\",\"1\":\"-41.9\",\"2\":\"-37.27\",\"3\":\"\",\"4\":\"-90.1\",\"5\":\"0\",\"6\":\"0\",\"7\":\"6000\",\"8\":\"6000\",\"9\":\"28.8\",\"10\":\"28.8\",\"11\":[[\"597\",\"511\"],[\"1600\",\"527\"],[\"1600\",\"900\"],[\"129\",\"900\"],[\"577.5\",\"504.5\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-129\",\"viewHorizontalOffset\":\"-25\"}]', 1, '2017-07-12 00:00:00', '2017-09-26 17:27:46'),
(20, 'Bathroom-5', 'bathroom', 'rooms2d/room_icon_40.jpg', 'rooms2d/room_background_40.png', 'rooms2d/room_foreground_40.png', 'rooms2d/kqeYLhXyb2Hy0HxwHsQ1kdaUP2mKNs0QvCqEGI01.png', '[{\"0\":\"1\",\"1\":\"-19.9\",\"2\":\"-25.5\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"3000\",\"8\":\"3000\",\"9\":\"16.6\",\"10\":\"16.6\",\"11\":[[\"484\",\"0\"],[\"1124\",\"0\"],[\"1124\",\"643\"],[\"484\",\"643\"],[\"484\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-213\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"2\",\"1\":\"20.2\",\"2\":\"-25.5\",\"3\":\"0\",\"4\":\"0\",\"5\":\"-88.9\",\"6\":\"0\",\"7\":\"3000\",\"8\":\"3000\",\"9\":\"16.6\",\"10\":\"16.6\",\"11\":[[\"1124\",\"0\"],[\"1533\",\"0\"],[\"1535.5\",\"900\"],[\"1353\",\"900\"],[\"1124\",\"647\"],[\"1124\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-213\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"3\",\"1\":\"-19.6\",\"2\":\"-25.5\",\"3\":\"\",\"4\":\"0\",\"5\":\"87.9\",\"6\":\"0\",\"7\":\"3000\",\"8\":\"3000\",\"9\":\"16.6\",\"10\":\"16.6\",\"11\":[[\"0\",\"0\"],[\"484\",\"0\"],[\"484\",\"643\"],[\"254\",\"900\"],[\"0\",\"900\"],[\"0\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-213\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"4\",\"1\":\"-19.9\",\"2\":\"-25.3\",\"3\":\"0\",\"4\":\"-90.9\",\"5\":\"0\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"16.6\",\"10\":\"16.6\",\"11\":[[\"484\",\"643\"],[\"1124\",\"643\"],[\"1353\",\"900\"],[\"254\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-213\",\"viewHorizontalOffset\":\"0\"}]', 1, '2017-07-12 00:00:00', '2017-09-26 10:50:36'),
(21, 'Bathroom-6', 'bathroom', 'rooms2d/room_icon_42.jpg', 'rooms2d/room_background_42.png', 'rooms2d/room_foreground_42.png', 'rooms2d/50dYn9i2jJDyImVRckwvd1kslHvYRO9fZoPsJOJm.png', '[{\"0\":\"1\",\"1\":\"28.5\",\"2\":\"-19.6\",\"3\":\"\",\"4\":\"0\",\"5\":\"-90\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"13.6\",\"10\":\"13.6\",\"11\":[[\"1258\",\"0\"],[\"1385\",\"0\"],[\"1384\",\"419\"],[\"1600\",\"488\"],[\"1600\",\"782\"],[\"1258\",\"551.5\"],[\"1258\",\"0\"]],\"176\":\"wall\",\"group\":\"1\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-213\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"2\",\"1\":\"-28.3\",\"2\":\"-19.6\",\"3\":\"\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"13.6\",\"10\":\"13.6\",\"11\":[[\"349\",\"0\"],[\"349\",\"546\"],[\"1257\",\"546\"],[\"1257\",\"0\"],[\"349\",\"0\"]],\"176\":\"wall\",\"group\":\"2\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-213\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"3\",\"1\":\"-28.15\",\"2\":\"-19.6\",\"3\":\"\",\"4\":\"0\",\"5\":\"90.4\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"13.6\",\"10\":\"13.6\",\"11\":[[\"0\",\"0\"],[\"348\",\"0\"],[\"348\",\"546\"],[\"0\",\"794\"],[\"0\",\"0\"]],\"176\":\"wall\",\"group\":\"3\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-213\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"4\",\"1\":\"-28.4\",\"2\":\"-19.1\",\"3\":\"\",\"4\":\"-89.61\",\"5\":\"0\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"13.6\",\"10\":\"13.6\",\"11\":[[\"349\",\"546\"],[\"1256\",\"546\"],[\"1600\",\"782\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"793\"],[\"349\",\"546\"]],\"176\":\"floor\",\"group\":\"4\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-213\",\"viewHorizontalOffset\":\"0\"}]', 1, '2017-07-12 00:00:00', '2019-07-05 13:53:18'),
(22, 'Bathroom-4', 'bathroom', 'rooms2d/room_icon_25.jpg', 'rooms2d/room_background_25.png', 'rooms2d/room_foreground_25.png', NULL, '[{\"0\":\"1\",\"1\":\"-49.6\",\"2\":\"-15.1\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"25.5\",\"10\":\"25.5\",\"11\":[[\"0\",\"113.5\"],[\"1004.5\",\"113.5\"],[\"1004.5\",\"699.5\"],[\"0\",\"701.5\"],[\"0\",\"113.5\"]],\"176\":\"wall\",\"cameraFov\":\"30\"},{\"0\":\"2\",\"1\":\"-49.6\",\"2\":\"-14.9\",\"3\":\"0\",\"4\":\"-84\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"25.5\",\"10\":\"25.5\",\"11\":[[\"0\",\"700\"],[\"1004\",\"701\"],[\"1005\",\"692\"],[\"1600\",\"695\"],[\"1600\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"30\"}]', 1, '2017-07-12 00:00:00', '2017-09-22 13:46:08'),
(23, 'Bathroom-1', 'bathroom', 'rooms2d/room_icon_23.jpg', 'rooms2d/room_background_23.png', 'rooms2d/room_foreground_23.png', NULL, '[{\"0\":\"1\",\"1\":\"-47.8\",\"2\":\"-16.6\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"24\",\"10\":\"24\",\"11\":[[\"0\",\"0\"],[\"1600\",\"0\"],[\"1600\",\"724\"],[\"0\",\"725\"],[\"0\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"30\"},{\"0\":\"2\",\"1\":\"-47.8\",\"2\":\"-16.2\",\"3\":\"0\",\"4\":\"-87\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"24\",\"10\":\"24\",\"11\":[[\"0\",\"724\"],[\"1600\",\"724\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"724\"]],\"176\":\"floor\",\"cameraFov\":\"30\"}]', 1, '2017-07-12 00:00:00', '2017-09-22 13:40:44'),
(24, 'Bathroom-2', 'bathroom', 'rooms2d/room_icon_12.jpg', 'rooms2d/room_background_12.png', 'rooms2d/room_foreground_12.png', NULL, '[{\"0\":\"1\",\"1\":\"-40\",\"2\":\"-9.3\",\"3\":\"16\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"16\",\"10\":\"16\",\"11\":[[\"0\",\"0\"],[\"1600\",\"0\"],[\"1600\",\"635\"],[\"0\",\"635\"],[\"0\",\"0\"]],\"176\":\"wall\"},{\"0\":\"2\",\"1\":\"-40.1\",\"2\":\"-9.3\",\"3\":\"16\",\"4\":\"-84.57\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"16\",\"10\":\"16\",\"11\":[[\"0\",\"635\"],[\"1600\",\"635\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"635\"]],\"176\":\"floor\"}]', 1, '2017-07-12 00:00:00', '2017-09-09 09:03:33'),
(25, 'Bedroom', 'bedroom', 'rooms2d/bfgo7seAyZybrQ1T1cFeE8smELtM1LV1fmZtYWrj.jpeg', 'rooms2d/V3zzgMoS6a9538lMSpgAUzncMFCX4va9gz2I42tb.png', 'rooms2d/CHObtlAHnbBOijX4HkcCbdK1hljGmMOMLDR32D9K.png', 'rooms2d/CK0FLxE6aqZnCUP1hIkSXlQWxhRyNc6NkznSr5pe.png', '[{\"0\":\"1\",\"1\":\"-46\",\"2\":\"-6.8\",\"3\":\"0\",\"4\":\"-83.7\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"24\",\"10\":\"24\",\"11\":[[\"292\",\"521\"],[\"1273\",\"519\"],[\"1600\",\"668\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"636\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"2\",\"1\":\"-46.3\",\"2\":\"8.9\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"25.6\",\"10\":\"25.6\",\"11\":[[\"298\",\"0\"],[\"1302\",\"0\"],[\"1302\",\"355\"],[\"294\",\"364\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"}]', 1, '2017-09-27 07:42:32', '2017-09-28 04:14:02'),
(26, 'Bedroom', 'bedroom', 'rooms2d/uxQxzp98jehBjrfn1lQXrQPCWUY2a2OUJOTk3udf.jpeg', 'rooms2d/5JySnNvhLXKnKRITZeEp7MqJunjpRldAm3x953FN.png', 'rooms2d/k51Pp7qMV7lXMnzRKdJBJD22CyHscgycPvlA0ncq.png', 'rooms2d/1V5PGPJ7GbXTUdeDJUi7H2LVePnUjKQqBAIosteu.png', '[{\"0\":\"1\",\"1\":\"-23.9\",\"2\":\"-12.92\",\"3\":\"0\",\"4\":\"-90\",\"5\":\"\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"16\",\"10\":\"16\",\"11\":[[\"998\",\"583\"],[\"1037\",\"578\"],[\"1562\",\"900\"],[\"0\",\"900\"],[\"0\",\"841\"],[\"352\",\"706\"],[\"1028\",\"716\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"}]', 1, '2017-09-27 07:43:10', '2017-10-02 15:04:07'),
(27, 'Bedroom', 'bedroom', 'rooms2d/6Oe3LrNoVoQUlVEKZJv5ApBfBfnFzaPlT2eKciPo.jpeg', 'rooms2d/Gjzv8twupf1RLOXDKFaz0MQc4QI5gLjmMqkM3CmX.png', 'rooms2d/1UvXNPlbujJnyKvQd5qN6utky3u4bLyWYL1MM0U5.png', NULL, '[{\"0\":\"1\",\"1\":\"-50.2\",\"2\":\"-16.7\",\"3\":\"0\",\"4\":\"-87\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"16.5\",\"10\":\"16.5\",\"11\":[[\"0\",\"644\"],[\"1417\",\"642\"],[\"1600\",\"774\"],[\"1600\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"27\"}]', 1, '2017-09-21 17:22:08', '2017-09-21 17:34:19'),
(28, 'Bedroom-4', 'bedroom', 'rooms2d/room_icon_39.jpg', 'rooms2d/room_background_39.png', 'rooms2d/room_foreground_39.png', NULL, '[{\"0\":\"1\",\"1\":\"-17\",\"2\":\"-21.3\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"17.8\",\"10\":\"17.8\",\"11\":[[\"0\",\"0\"],[\"1266\",\"0\"],[\"1266\",\"462\"],[\"0\",\"476\"],[\"0\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-440\",\"viewHorizontalOffset\":\"-439\"},{\"0\":\"2\",\"1\":\"42\",\"2\":\"-21.3\",\"3\":\"0\",\"4\":\"0\",\"5\":\"-90\",\"6\":\"0\",\"7\":\"2000\",\"8\":\"2000\",\"9\":\"17.8\",\"10\":\"17.8\",\"11\":[[\"1266\",\"0\"],[\"1389\",\"1\"],[\"1383\",\"521\"],[\"1266\",\"461\"],[\"1266\",\"0\"]],\"176\":\"wall\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-440\",\"viewHorizontalOffset\":\"-439\"},{\"0\":\"3\",\"1\":\"-17\",\"2\":\"-21\",\"3\":\"0\",\"4\":\"-89\",\"5\":\"0\",\"6\":\"0\",\"7\":\"4000\",\"8\":\"4000\",\"9\":\"17.8\",\"10\":\"17.8\",\"11\":[[\"0\",\"462\"],[\"1266\",\"462\"],[\"1600\",\"629\"],[\"1600\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"-440\",\"viewHorizontalOffset\":\"-439\"}]', 1, '2017-07-12 00:00:00', '2017-09-26 13:31:54'),
(29, 'Outdoor', 'outdoor', 'rooms2d/0H6lci7t9tczzsk97840HKcoUhCYqDE1AEO9uYz8.jpeg', 'rooms2d/hZAxVFl57L8MI1P3qbRgpfAQTpliJ19eVHw6Z75q.png', NULL, 'rooms2d/jrja3Mv1vnhxIH80fI6WExQBzbG0X0u3kU7BmPW4.png', '[{\"0\":\"1\",\"1\":\"-45.3\",\"2\":\"17.124\",\"3\":\"0\",\"4\":\"-63.5\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"15\",\"10\":\"15\",\"11\":[[\"19\",\"237\"],[\"47\",\"234\"],[\"46\",\"265\"],[\"737\",\"270\"],[\"1138\",\"282\"],[\"1477\",\"900\"],[\"0\",\"900\"],[\"0\",\"212\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"115\"}]', 1, '2017-10-02 05:30:15', '2017-10-10 04:51:24'),
(30, 'Outdoor', 'outdoor', 'rooms2d/YX9x6AgGvccphqlYVKTZG2KVFInKqBKzzIKkEnjx.jpeg', 'rooms2d/Q1KwgfZ2pJTDejoo6x9TWCPuu9Sy86L43CCjip5z.png', NULL, 'rooms2d/jQ7jYohgUigHoSxXGZtgCKIY4B76McKN63Rvz6Xq.png', '[{\"0\":\"1\",\"1\":\"-46.3\",\"2\":\"1.6\",\"3\":\"0\",\"4\":\"-75\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"15.7\",\"10\":\"15.7\",\"11\":[[\"0\",\"605\"],[\"349\",\"418\"],[\"1168\",\"430\"],[\"1192\",\"437\"],[\"1600\",\"805\"],[\"1600\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"33\"}]', 1, '2017-10-02 05:30:43', '2017-10-02 05:37:13'),
(31, 'Outdoor', 'outdoor', 'rooms2d/wwPv6mwGWnmJ0FuhGfAxPnrIUbhtYtWYfys3FX1J.jpeg', 'rooms2d/rPJyirlCRG5NefXEAKn4HwhpJcuAQfxVtCKxZ7ov.png', NULL, 'rooms2d/AsoSbisj37Ikzh0CHW3iKnDRyQ8ua2iW4HEIiXqk.png', '[{\"0\":\"1\",\"1\":\"-2.5\",\"2\":\"3.7\",\"3\":\"0\",\"4\":\"-79\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"11.63\",\"10\":\"11.63\",\"11\":[[\"787\",\"403\"],[\"1086\",\"406\"],[\"1395\",\"608\"],[\"1107\",\"614\"],[\"1317\",\"900\"],[\"706\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"20\"}]', 1, '2017-10-02 05:29:21', '2017-10-02 06:00:18'),
(32, 'Study Room', 'other', 'rooms2d/nnEKIZmYqo3qBYmW42qy2IamEWU5XxejOsERZJJ7.jpeg', 'rooms2d/eXXZOXOMR493KOkZI410CXyHTmehmbuRBnhtb93r.png', 'rooms2d/fq72zfK1sTbia01VPoTX6UIwbberth1tdMSuVMjR.png', NULL, '[{\"0\":\"1\",\"1\":\"-8.7\",\"2\":\"-13.6\",\"3\":\"0\",\"4\":\"-87.3\",\"5\":\"0\",\"6\":\"0\",\"7\":\"3000\",\"8\":\"3000\",\"9\":\"27\",\"10\":\"27\",\"11\":[[\"546\",\"548\"],[\"1036\",\"544\"],[\"1497\",\"900\"],[\"92\",\"900\"]],\"176\":\"floor\"}]', 1, '2017-09-16 06:25:05', '2017-09-18 10:49:57'),
(63, 'Living Room', 'livingroom', 'rooms2d/kGscq1wU5wzF2YQ3HznnQ5eGxW3ejyIbmhclx79z.jpeg', 'rooms2d/wsp2t3YT0NJqSwjHzHXGTGykVfiLtniqBSkVLkot.png', 'rooms2d/hw1ngFSXid5rk93wR2wJ6UYVq0svJiwCD0y7n6Je.png', 'rooms2d/NKn6CFfkFZQt3XWETr0ewtedqdtyEdt8kvoObmZK.png', '[{\"0\":\"1\",\"1\":\"-34\",\"2\":\"-12\",\"3\":\"0\",\"4\":\"-85.3\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"18.4\",\"10\":\"18.4\",\"11\":[[\"0\",\"587\"],[\"1205\",\"580\"],[\"1464\",\"775\"],[\"1495\",\"803\"],[\"1600\",\"805\"],[\"1600\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\",\"cameraFov\":\"40\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"-40\"}]', 1, '2017-10-22 07:31:44', '2017-10-22 08:05:51'),
(64, 'Living Room', 'livingroom', 'rooms2d/Jhrtm4kwiITSEcsPYCjoCS66ISkmceGZrBv7hco6.jpeg', 'rooms2d/Ef7WDjMmF7eyGPAnFo3BvYMvzKvY5nhKdzsRphOV.png', 'rooms2d/2etVTQXf5henDCQvMqQvB3cXyiasWuGPA87gUAGo.png', 'rooms2d/pGeqJqKHE4nmvu7DL2jNCkkfPZHKJeYNKKaFveLF.png', '[{\"0\":\"1\",\"1\":\"-28.6\",\"2\":\"-12.5\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"16.3\",\"10\":\"16.3\",\"11\":[[\"324\",\"0\"],[\"1600\",\"0\"],[\"1600\",\"657\"],[\"324\",\"657\"]],\"176\":\"wall\",\"cameraFov\":\"30\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"2\",\"1\":\"-28.2\",\"2\":\"-12.5\",\"3\":\"0\",\"4\":\"0\",\"5\":\"78.3\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"16.3\",\"10\":\"16.3\",\"11\":[[\"0\",\"0\"],[\"324\",\"0\"],[\"324\",\"657\"],[\"295\",\"664\"],[\"273\",\"144\"],[\"0\",\"80\"]],\"176\":\"wall\",\"cameraFov\":\"30\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"3\",\"1\":\"-28.6\",\"2\":\"-12.2\",\"3\":\"0\",\"4\":\"-87.2\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"16.3\",\"10\":\"16.3\",\"11\":[[\"324\",\"657\"],[\"1600\",\"657\"],[\"1600\",\"900\"],[\"0\",\"900\"],[\"0\",\"833\"]],\"176\":\"floor\",\"cameraFov\":\"30\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"}]', 1, '2017-10-22 11:51:25', '2017-10-26 06:11:06'),
(69, 'Stainsafe_Moorland_Twist_Zig_Zag_0950_L', 'other', 'rooms2d/zahWYLorUJvR0OsDXpRdVkftEJQ9uVW7mGYsmGXo.png', 'rooms2d/CeqYBEv3YHPpv1q8DtOFycJXsWQXr0i48q4Ox0AL.png', NULL, 'rooms2d/pIH2TcNT0nOfDIg4SI8FLRzYByDos3ryqudcYlkN.png', '[{\"0\":\"1\",\"1\":\"36.9\",\"2\":\"40.2\",\"3\":\"0\",\"4\":\"-30.4\",\"5\":\"4.9\",\"6\":\"17.8\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"25\",\"10\":\"25\",\"11\":[[\"0\",\"200\"],[\"630\",\"101\"],[\"1228\",\"0\"],[\"1381\",\"195\"],[\"1002\",\"245\"],[\"969\",\"311\"],[\"1269\",\"900\"],[\"0\",\"900\"]],\"176\":\"floor\",\"group\":\"1\",\"cameraFov\":\"45\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"}]', 1, '2019-08-03 06:05:59', '2019-08-03 16:34:47'),
(70, 'Test', 'livingroom', 'rooms2d/yDH6MiBbxNOFPv27zy8u7kRDwcjtKSDnSXfxiJcH.jpeg', 'rooms2d/b2i7AVdz0HnajmybbOZdMxqfx5cBDnjjnuQGpMH1.png', NULL, 'rooms2d/Y1gD8P16Uy1K711ojo8zqmyNq4lUxwDVprzfs4aV.png', '[{\"0\":\"1\",\"1\":\"96.1\",\"2\":\"-13.7\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"18.9\",\"10\":\"18.9\",\"11\":[[\"210\",\"0\"],[\"1598\",\"0\"],[\"1598\",\"676\"],[\"206\",\"679\"]],\"176\":\"wall\",\"group\":\"1\",\"cameraFov\":\"30\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"2\",\"1\":\"-34.9\",\"2\":\"-13.2\",\"3\":\"0\",\"4\":\"-88.1\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"18.9\",\"10\":\"18.9\",\"11\":[[\"210\",\"673\"],[\"1596\",\"675\"],[\"1598\",\"897\"],[\"0\",\"900\"],[\"2\",\"767\"]],\"176\":\"floor\",\"group\":\"2\",\"cameraFov\":\"30\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"},{\"0\":\"3\",\"1\":\"-132.1\",\"2\":\"-13.7\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\",\"7\":\"5000\",\"8\":\"5000\",\"9\":\"18.9\",\"10\":\"18.9\",\"11\":[[\"209\",\"0\"],[\"498\",\"0\"],[\"498\",\"675\"],[\"206\",\"672\"]],\"176\":\"wall\",\"group\":\"3\",\"cameraFov\":\"30\",\"viewVerticalOffset\":\"0\",\"viewHorizontalOffset\":\"0\"}]', 1, '2021-12-13 06:35:16', '2021-12-14 07:00:17'),
(72, 'New Room', 'bathroom', 'rooms2d/iFoimIVdYr4ixsbrJpYGZO4yH5ZSD9oYEiQcueTT.jpeg', 'rooms2d/SC0O2wNgW6P5MmG9jOxKvREPskWiuzUCHw6dqQCM.png', 'rooms2d/90EiHUXctNYAftK4RE3kOIiCxmILfZDcS3HDZ6kZ.png', 'rooms2d/VKRwRJQM9rArEYXbmCy93UiCVKtl3P0MwQHKOuPp.png', '[]', 1, '2021-12-13 08:15:09', '2021-12-13 08:15:09');

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

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

CREATE TABLE `rooms` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sourcesPath` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iconfile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mapSize` int(11) DEFAULT '1024',
  `cameraFov` int(11) DEFAULT '60',
  `size` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `firstPersonViewHeight` int(11) NOT NULL DEFAULT '1500',
  `endPoints` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `parts` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `tiledSurfaces` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `mirrors` text COLLATE utf8mb4_unicode_ci,
  `useMirrors` tinyint(1) NOT NULL DEFAULT '0',
  `enabled` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `rooms` (`id`, `name`, `type`, `sourcesPath`, `iconfile`, `mapSize`, `cameraFov`, `size`, `firstPersonViewHeight`, `endPoints`, `parts`, `tiledSurfaces`, `mirrors`, `useMirrors`, `enabled`, `created_at`, `updated_at`) VALUES
(1, 'Interior 46', 'bedroom', '/roomsResources/interior46/', 'rooms/VAtufqvWTleM3NAkaHUmZ5ziyqYEXs7sLoCkZA5F.jpeg', 2048, 60, '{ \"x\": 4000, \"y\": 2700, \"z\": 7000 }', 1500, '{         \"min\": { \"x\": -1880, \"y\": 550, \"z\": -1950 },         \"max\": { \"x\": 1950, \"y\": 2550, \"z\": 2500 }     }', '[         [\"balcony.js\", \"balconyVRayCompleteMap.jpg\"],         [\"balconyDoors.js\", \"balconyDoorsVRayCompleteMap.jpg\"],         [\"bed.js\", \"bedVRayCompleteMap.jpg\"],         [\"blanket.js\", \"blanketVRayCompleteMap.jpg\"],         [\"blanket2.js\", \"blanket2VRayCompleteMap.jpg\"],         [\"chair.js\", \"chairVRayCompleteMap.jpg\"],         [\"curtains1.js\", \"curtains1VRayCompleteMap.jpg\"],         [\"curtains2.js\", \"curtains2VRayCompleteMap.jpg\"],         [\"door.js\", \"doorVRayCompleteMap.jpg\"],         [\"light1.js\", \"light1VRayCompleteMap.jpg\"],         [\"nightstand.js\", \"nightstandVRayCompleteMap.jpg\"],         [\"pillows.js\", \"pillowsVRayCompleteMap.jpg\"],         [\"roomElements.js\", \"roomElementsVRayCompleteMap.jpg\"],         [\"table.js\", \"tableVRayCompleteMap.jpg\"],         [\"tvset.js\", \"tvsetVRayCompleteMap.jpg\"],         [\"windowView.js\", \"windowViewVRayCompleteMap.jpg\"],         [\"ceiling.js\", \"ceilingVRayCompleteMap.jpg\"]     ]', '[\r\n        {\r\n            \"name\": \"Wall 1\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall1-icon.jpg\",\r\n            \"geometryFile\": \"wall1.js\",\r\n            \"aoMapFile\": \"wall1VRayTotalLightingMap.jpg\",\r\n            \"lightMapFile\": \"wall1VRayLightingMap.jpg\",\r\n            \"width\": 4000,  \r\n            \"height\": 2700, \r\n            \"mirror\": {\r\n                \"width\": 4000,\r\n                \"height\": 2700,\r\n                \"position\": { \"x\": 22.51, \"y\": 1350, \"z\": 2578 },\r\n                \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": {\"x\": 78, \"y\": 1500, \"z\": -1421},\r\n                \"target\": {\"x\": 80, \"y\": 1500, \"z\": 2149}\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 2\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall2-icon.jpg\",\r\n            \"geometryFile\": \"wall2.js\",\r\n            \"aoMapFile\": \"wall2VRayTotalLightingMap.jpg\",\r\n            \"lightMapFile\": \"wall2VRayLightingMap.jpg\",\r\n            \"width\": 4786,\r\n            \"height\": 2700,\r\n            \"mirror\": {\r\n                \"width\": 4786,\r\n                \"height\": 2700,\r\n                \"position\": { \"x\": -1974, \"y\": 1350, \"z\": 186.535 },\r\n                \"rotation\": { \"x\": 0, \"y\": 1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": {\"x\": 1808, \"y\": 1500, \"z\": 884},\r\n                \"target\": {\"x\": -1825, \"y\": 1500, \"z\": 424}\r\n            }\r\n        },\r\n        { \r\n            \"name\": \"Wall 3\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall3-icon.jpg\",\r\n            \"geometryFile\": \"wall3.js\",\r\n            \"aoMapFile\": \"wall3VRayTotalLightingMap.jpg\",\r\n            \"lightMapFile\": \"wall3VRayLightingMap.jpg\",\r\n            \"width\": 4786,\r\n            \"height\": 2700,\r\n            \"mirror\": {\r\n                \"width\": 4786,\r\n                \"height\": 2700,\r\n                \"position\": { \"x\": 2021, \"y\": 1350, \"z\": 186.535 },\r\n                \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": {\"x\": -1876, \"y\": 1500, \"z\": 26},\r\n                \"target\": {\"x\": 1982, \"y\": 1500, \"z\": 192}\r\n            }\r\n        },\r\n        { \r\n            \"name\": \"Wall 4\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall4-icon.jpg\",\r\n            \"geometryFile\": \"wall4.js\",\r\n            \"aoMapFile\": \"wall4VRayTotalLightingMap.jpg\",\r\n            \"lightMapFile\": \"wall4VRayLightingMap.jpg\",\r\n            \"width\": 4000,\r\n            \"height\": 2700,\r\n            \"view\": {\r\n                \"position\": {\"x\": 1048, \"y\": 1500, \"z\": 924},\r\n                \"target\": {\"x\": 342, \"y\": 1500, \"z\": -1987}\r\n            }\r\n        },\r\n        { \r\n            \"name\": \"Floor\",\r\n            \"type\": \"floor\",\r\n            \"iconFile\": \"floor-icon.jpg\",\r\n            \"geometryFile\": \"floor.js\",\r\n            \"aoMapFile\": \"floorVRayTotalLightingMap.jpg\",\r\n            \"lightMapFile\": \"floorVRayLightingMap.jpg\",\r\n            \"width\": 6827.64,\r\n            \"height\": 4000,\r\n            \"mirror\": {\r\n                \"width\": 4000,\r\n                \"height\": 6827.64,\r\n                \"position\": { \"x\": 22.51, \"y\": 1, \"z\": -724.9 },\r\n                \"rotation\": { \"x\": -1, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": {\"x\": 1980, \"y\": 1500, \"z\": 2530},\r\n                \"target\": {\"x\": 845, \"y\": 570, \"z\": 796}\r\n            }\r\n        }\r\n    ]', NULL, 1, 1, '2017-03-02 13:38:46', '2021-09-22 01:22:07'),
(2, 'Bathroom', 'bathroom', '/roomsResources/bathroom/', 'rooms/ZoIqfZJIevp1JpoZcro42t8wPptyMNIIbJ2wgpOj.jpeg', 2048, 60, '{ \"x\": 3882, \"y\": 2693, \"z\": 2649 }', 1500, '{\r\n        \"min\": { \"x\": -1100, \"y\": 550, \"z\": -1600 },\r\n        \"max\": { \"x\": 1300, \"y\": 2650, \"z\": 2100 }\r\n    }', '[\r\n        [\"apron.js\", \"apronVRayCompleteMap.jpg\"],\r\n        [\"bath.js\", \"bathVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"bathAccessories.js\", \"bathAccessoriesVRayCompleteMap.jpg\"],\r\n        [\"ceiling.js\", \"ceilingVRayCompleteMap.jpg\"],\r\n        [\"curbstone.js\", \"curbstoneVRayCompleteMap.jpg\"],\r\n        [\"door.js\", \"doorVRayCompleteMap.jpg\"],\r\n        [\"glassDoor.js\", \"\", \"glassWall\"],\r\n        [\"lights.js\", \"lightsVRayCompleteMap.jpg\"],\r\n        [\"metalDetails.js\", \"\", \"metal\"],\r\n        [\"mirror.js\", \"mirrorVRayCompleteMap.jpg\"],\r\n        [\"paperHolder.js\", \"\", \"metal\"],\r\n        [\"shower.js\", \"\", \"metal\"],\r\n        [\"sinks.js\", \"sinksVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"toilet.js\", \"toiletVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"waterTaps.js\", \"\", \"metal\"]\r\n    ]', '[\r\n        {\r\n            \"name\": \"Wall 1\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall1-icon.jpg\",\r\n            \"geometryFile\": \"wall1.js\",\r\n            \"aoMapFile\": \"wall1VRayTotalLightingMap.jpg\",\r\n            \"lightMapFile\": \"wall1VRayLightingMap.jpg\",\r\n            \"width\": 3882,\r\n            \"height\": 2693,\r\n            \"mirror\": {\r\n                \"width\": 3882,\r\n                \"height\": 2693,\r\n                \"position\": { \"x\": -1230, \"y\": 1354, \"z\": 250 },\r\n                \"rotation\": { \"x\": 0, \"y\": 1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1200, \"y\": 1500, \"z\": 300 },\r\n                \"target\": { \"x\": 1300, \"y\": 1500, \"z\": 300 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 2\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall2-icon.jpg\",\r\n            \"geometryFile\": \"wall2.js\",\r\n            \"aoMapFile\": \"wall2VRayTotalLightingMap.jpg\",\r\n            \"lightMapFile\": \"wall2VRayLightingMap.jpg\",\r\n            \"width\": 2649,\r\n            \"height\": 2693,\r\n            \"mirror\": {\r\n                \"width\": 2649,\r\n                \"height\": 2693,\r\n                \"position\": { \"x\": 80, \"y\": 1354, \"z\": 2180 },\r\n                \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 37, \"y\": 1500, \"z\": -300 },\r\n                \"target\": { \"x\": 37, \"y\": 1500, \"z\": 1800 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 3\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall3-icon.jpg\",\r\n            \"geometryFile\": \"wall3.js\",\r\n            \"aoMapFile\": \"wall3VRayTotalLightingMap.jpg\",\r\n            \"lightMapFile\": \"wall3VRayLightingMap.jpg\",\r\n            \"width\": 3882,\r\n            \"height\": 2693,\r\n            \"mirror\": {\r\n                \"width\": 3882,\r\n                \"height\": 2693,\r\n                \"position\": { \"x\": 1390, \"y\": 1354, \"z\": 250 },\r\n                \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 1300, \"y\": 1500, \"z\": 300 },\r\n                \"target\": { \"x\": -1200, \"y\": 1500, \"z\": 300 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 4\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall4-icon.jpg\",\r\n            \"geometryFile\": \"wall4.js\",\r\n            \"aoMapFile\": \"wall4VRayTotalLightingMap.jpg\",\r\n            \"lightMapFile\": \"wall4VRayLightingMap.jpg\",\r\n            \"width\": 2649,\r\n            \"height\": 2693,\r\n            \"mirror\": {\r\n                \"width\": 2649,\r\n                \"height\": 2693,\r\n                \"position\": { \"x\": 80, \"y\": 1354, \"z\": -1680 },\r\n                \"rotation\": { \"x\": 0, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 37, \"y\": 1500, \"z\": 700 },\r\n                \"target\": { \"x\": 37, \"y\": 1500, \"z\": -1400 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Floor\",\r\n            \"type\": \"floor\",\r\n            \"iconFile\": \"floor-icon.jpg\",\r\n            \"geometryFile\": \"floor.js\",\r\n            \"aoMapFile\": \"floorVRayTotalLightingMap.jpg\",\r\n            \"lightMapFile\": \"floorVRayLightingMap.jpg\",\r\n            \"width\": 3882,\r\n            \"height\": 2649,\r\n            \"mirror\": {\r\n                \"width\": 2649,\r\n                \"height\": 3882,\r\n                \"position\": { \"x\": 80, \"y\": 20, \"z\": 250 },\r\n                \"rotation\": { \"x\": -1, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 1000, \"y\": 1500, \"z\": -1200 },\r\n                \"target\": { \"x\": 400, \"y\": 600, \"z\": -300 }\r\n            }\r\n        }\r\n    ]', '[\r\n        {\r\n            \"width\": 1200,\r\n            \"height\": 670,\r\n            \"position\": { \"x\": -1215, \"y\": 1455, \"z\": -180 },\r\n            \"rotation\": { \"x\": 0, \"y\": 1, \"z\": 0 },\r\n            \"opacity\": 1,\r\n            \"textureSize\": 2048\r\n        },\r\n        {\r\n            \"width\": 1445,\r\n            \"height\": 2098,\r\n            \"position\": { \"x\": -523, \"y\": 1051, \"z\": 1290 },\r\n            \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n            \"opacity\": 0.2,\r\n            \"color\": \"0x273340\"\r\n        }\r\n    ]', 1, 1, '2017-03-31 19:42:11', '2021-09-22 01:22:07'),
(3, 'Bathroom #1', 'bathroom', '/roomsResources/bathroom-1/', 'rooms/4W1d1psIqC3fyOGGEZs91NmZ4N8HXPbxoL5Gg0zA.jpeg', 2048, 60, '{ \"x\": 3657.6, \"y\": 2747.1, \"z\": 4572 }', 1500, '{\r\n        \"min\": { \"x\": -1350, \"y\": 550, \"z\": -2450 },\r\n        \"max\": { \"x\": 2150, \"y\": 2700, \"z\": 1950 }\r\n    }', '[\r\n        [\"ambry.js\", \"ambryVRayCompleteMap.jpg\"],\r\n        [\"ambryGlassDoor.js\", \"\", \"glass\"],\r\n        [\"bath.js\", \"bathVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"bathWaterTap.js\", \"\", \"metal\"],\r\n        [\"bidet.js\", \"bidetVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"ceiling.js\", \"ceilingVRayCompleteMap.jpg\"],\r\n        [\"door.js\", \"doorVRayCompleteMap.jpg\"],\r\n        [\"elements.js\", \"elementsVRayCompleteMap.jpg\"],\r\n        [\"glassWall.js\", \"\", \"glassWall\"],\r\n        [\"lights.js\", \"lightsVRayCompleteMap.jpg\"],\r\n        [\"metalParts.js\", \"\", \"metal\"],\r\n        [\"mirror.js\", \"mirrorVRayCompleteMap.jpg\"],\r\n        [\"shower.js\", \"\", \"metal\"],\r\n        [\"sink.js\", \"sinkVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"toilet.js\", \"toiletVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"towel.js\", \"towelVRayCompleteMap.jpg\"],\r\n        [\"waterTaps.js\", \"\", \"metal\"],\r\n        [\"window.js\", \"windowVRayCompleteMap.jpg\"],\r\n        [\"windowFrame.js\", \"\", \"metal\"],\r\n        [\"windowView.js\", \"windowViewVRayCompleteMap.jpg\"]\r\n    ]', '[\r\n        {\r\n            \"name\": \"Wall 1\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall1-icon.jpg\",\r\n            \"geometryFile\": \"wall1.js\",\r\n            \"aoMapFile\": \"wall1VRayTotalLightingMap.jpg\",\r\n            \"width\": 4572,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 4550,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": 2210, \"y\": 1373, \"z\": -223 },\r\n                \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1300, \"y\": 1500, \"z\": -200 },\r\n                \"target\": { \"x\": 1000, \"y\": 1500, \"z\": -200 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 2\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall2-icon.jpg\",\r\n            \"geometryFile\": \"wall2.js\",\r\n            \"aoMapFile\": \"wall2VRayTotalLightingMap.jpg\",\r\n            \"width\": 3657.6,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 3640,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": 388, \"y\": 1373, \"z\": 2050 },\r\n                \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 400, \"y\": 1500, \"z\": -1500 },\r\n                \"target\": { \"x\": 400, \"y\": 1500, \"z\": 1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 3\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall3-icon.jpg\",\r\n            \"geometryFile\": \"wall3.js\",\r\n            \"aoMapFile\": \"wall3VRayTotalLightingMap.jpg\",\r\n            \"width\": 4572,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 4550,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": -1430, \"y\": 1373, \"z\": -223 },\r\n                \"rotation\": { \"x\": 0, \"y\": 1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 2100, \"y\": 1500, \"z\": -200 },\r\n                \"target\": { \"x\": -1000, \"y\": 1500, \"z\": -200 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 4\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall4-icon.jpg\",\r\n            \"geometryFile\": \"wall4.js\",\r\n            \"aoMapFile\": \"wall4VRayTotalLightingMap.jpg\",\r\n            \"width\": 3657.6,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 3640,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": 388, \"y\": 1373, \"z\": -2500 },\r\n                \"rotation\": { \"x\": 0, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 400, \"y\": 1500, \"z\": 1200 },\r\n                \"target\": { \"x\": 400, \"y\": 1500, \"z\": -1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Floor\",\r\n            \"type\": \"floor\",\r\n            \"iconFile\": \"floor-icon.jpg\",\r\n            \"geometryFile\": \"floor.js\",\r\n            \"aoMapFile\": \"floorVRayTotalLightingMap.jpg\",\r\n            \"width\": 4572,\r\n            \"height\": 3657.6,\r\n            \"mirror\": {\r\n                \"width\": 3640,\r\n                \"height\": 4550,\r\n                \"position\": { \"x\": 388, \"y\": 20, \"z\": -223 },\r\n                \"rotation\": { \"x\": -1, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 1900, \"y\": 1500, \"z\": -2200 },\r\n                \"target\": { \"x\": 1200, \"y\": 600, \"z\": -1400 }\r\n            }\r\n        }\r\n    ]', '[\r\n        {\r\n            \"width\": 500,\r\n            \"height\": 600,\r\n            \"position\": { \"x\": 2208, \"y\": 1573, \"z\": -378 },\r\n            \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n            \"opacity\": 1,\r\n            \"textureSize\": 1024\r\n        },\r\n        {\r\n            \"width\": 984,\r\n            \"height\": 2424,\r\n            \"position\": { \"x\": -907, \"y\": 1228, \"z\": -1518 },\r\n            \"rotation\": { \"x\": 0, \"y\": 0, \"z\": 0 },\r\n            \"opacity\": 0.25,\r\n            \"color\": \"0x28403d\"\r\n        }\r\n    ]', 1, 1, '2017-04-06 22:11:48', '2021-09-22 01:22:07'),
(4, 'Living room #1', 'livingroom', '/roomsResources/livingroom-1/', 'rooms/xOIjyVSShFHuGoeLtYZCoYAInSOCaMa0Y9jfYDMu.jpeg', 2048, 60, '{ \"x\": 3991.5, \"y\": 2747.1, \"z\": 5793.2 }', 1500, '{\r\n        \"min\": { \"x\": -1500, \"y\": 550, \"z\": -2450 },\r\n        \"max\": { \"x\": 2300, \"y\": 2500, \"z\": 3200 }\r\n    }', '[\r\n        [\"lamp.js\", \"\", \"glass\"],\r\n        [\"ceiling.js\", \"ceilingVRayCompleteMap.jpg\"],\r\n        [\"books.js\", \"booksVRayCompleteMap.jpg\"],\r\n        [\"tvSet.js\", \"tvSetVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"vases.js\", \"vasesVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"wallOutside.js\", \"wallOutsideVRayCompleteMap.jpg\"],\r\n        [\"door.js\", \"doorVRayCompleteMap.jpg\"],\r\n        [\"table.js\", \"tableVRayCompleteMap.jpg\"],\r\n        [\"shelves.js\", \"shelvesVRayCompleteMap.jpg\"],\r\n        [\"picture.js\", \"pictureVRayCompleteMap.jpg\"],\r\n        [\"lights.js\", \"lightsVRayCompleteMap.jpg\"],\r\n        [\"sofaPart1.js\", \"sofaPart1VRayCompleteMap.jpg\"],\r\n        [\"sofaPart2.js\", \"sofaPart2VRayCompleteMap.jpg\"],\r\n        [\"sofaPart3.js\", \"sofaPart3VRayCompleteMap.jpg\"],\r\n        [\"sofaPart4.js\", \"sofaPart4VRayCompleteMap.jpg\"],\r\n        [\"handles.js\", \"\", \"metal\"],\r\n        [\"sofaLegs.js\", \"\", \"metal\"],\r\n        [\"torchLamp.js\", \"\", \"metal\"],\r\n        [\"torchLampMatt.js\", \"torchLampMattVRayCompleteMap.jpg\"],\r\n        [\"window.js\", \"windowVRayCompleteMap.jpg\"],\r\n        [\"windowView.js\", \"windowViewVRayCompleteMap.jpg\"]\r\n    ]', '[\r\n        {\r\n            \"name\": \"Wall 1\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall1-icon.jpg\",\r\n            \"geometryFile\": \"wall1.js\",\r\n            \"aoMapFile\": \"wall1VRayCompleteMap.jpg\",\r\n            \"width\": 5793.2,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 5770,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": -1572, \"y\": 1373, \"z\": 387 },\r\n                \"rotation\": { \"x\": 0, \"y\": 1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 2300, \"y\": 1500, \"z\": -400 },\r\n                \"target\": { \"x\": -1000, \"y\": 1500, \"z\": -400 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 2\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall2-icon.jpg\",\r\n            \"geometryFile\": \"wall2.js\",\r\n            \"aoMapFile\": \"wall2VRayCompleteMap.jpg\",\r\n            \"width\": 3991.5,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 3970,\r\n                \"height\": 2520,\r\n                \"position\": { \"x\": 403, \"y\": 1270, \"z\": -2490 },\r\n                \"rotation\": { \"x\": 0, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 400, \"y\": 1500, \"z\": 1500 },\r\n                \"target\": { \"x\": 400, \"y\": 1500, \"z\": -1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 3\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall3-icon.jpg\",\r\n            \"geometryFile\": \"wall3.js\",\r\n            \"aoMapFile\": \"wall3VRayCompleteMap.jpg\",\r\n            \"width\": 5793.2,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 5770,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": 2380, \"y\": 1373, \"z\": 387 },\r\n                \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1500, \"y\": 1500, \"z\": -400 },\r\n                \"target\": { \"x\": 1000, \"y\": 1500, \"z\": -400 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 4\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall4-icon.jpg\",\r\n            \"geometryFile\": \"wall4.js\",\r\n            \"aoMapFile\": \"wall4VRayCompleteMap.jpg\",\r\n            \"width\": 3991.5,\r\n            \"height\": 206,\r\n            \"mirror\": {\r\n                \"width\": 3970,\r\n                \"height\": 206,\r\n                \"position\": { \"x\": 403, \"y\": 2640, \"z\": 3274 },\r\n                \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 400, \"y\": 1500, \"z\": 0 },\r\n                \"target\": { \"x\": 400, \"y\": 1500, \"z\": 2000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Floor\",\r\n            \"type\": \"floor\",\r\n            \"iconFile\": \"floor-icon.jpg\",\r\n            \"geometryFile\": \"floor.js\",\r\n            \"aoMapFile\": \"floorVRayCompleteMap.jpg\",\r\n            \"width\": 5793.2,\r\n            \"height\": 3991.5,\r\n            \"mirror\": {\r\n                \"width\": 3970,\r\n                \"height\": 5770,\r\n                \"position\": { \"x\": 403, \"y\": 20, \"z\": 387 },\r\n                \"rotation\": { \"x\": -1, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1490, \"y\": 1500, \"z\": -2400 },\r\n                \"target\": { \"x\": -700, \"y\": 600, \"z\": -1200 }\r\n            }\r\n        }\r\n    ]', '[\r\n        {\r\n            \"width\": 3895,\r\n            \"height\": 2445,\r\n            \"position\": { \"x\": 403, \"y\": 1270, \"z\": 3293 },\r\n            \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n            \"opacity\": 0.2,\r\n            \"color\": \"0x28403d\"\r\n        }\r\n    ]', 1, 1, '2017-04-11 21:08:32', '2021-09-22 01:22:07'),
(5, 'Living room #2', 'livingroom', '/roomsResources/livingroom-2/', 'rooms/FeQc3mIgVMNmYU7AEMNDmSD1QirDv5xCAG3p1D3X.jpeg', 2048, 60, '{ \"x\": 4267.2, \"y\": 2747.1, \"z\": 6406.3 }', 1500, '{\r\n        \"min\": { \"x\": -1650, \"y\": 550, \"z\": -2950 },\r\n        \"max\": { \"x\": 2250, \"y\": 2700, \"z\": 3200 }\r\n    }', '[\r\n        [\"ceiling.js\", \"ceilingVRayCompleteMap.jpg\"],\r\n        [\"wallParts.js\", \"wallPartsVRayCompleteMap.jpg\"],\r\n        [\"picture.js\", \"pictureVRayCompleteMap.jpg\"],\r\n        [\"wallPanel.js\", \"wallPanelVRayCompleteMap.jpg\"],\r\n        [\"windowView.js\", \"windowViewVRayCompleteMap.jpg\"],\r\n        [\"lockers.js\", \"lockersVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"tvSet.js\", \"tvSetVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"door.js\", \"doorVRayCompleteMap.jpg\"],\r\n        [\"table.js\", \"tableVRayCompleteMap.jpg\"],\r\n        [\"window.js\", \"windowVRayCompleteMap.jpg\"],\r\n        [\"vase.js\", \"vaseVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"candleholders.js\", \"candleholdersVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"books.js\", \"booksVRayCompleteMap.jpg\"],\r\n        [\"tableLamp.js\", \"tableLampVRayCompleteMap.jpg\"],\r\n        [\"lights.js\", \"lightsVRayCompleteMap.jpg\"],\r\n        [\"lamp.js\", \"\", \"glass\"],\r\n        [\"metalParts.js\", \"\", \"metal\"],\r\n        [\"sofaPart1.js\", \"sofaPart1VRayCompleteMap.jpg\"],\r\n        [\"sofaPart2.js\", \"sofaPart2VRayCompleteMap.jpg\"],\r\n        [\"sofaPart3.js\", \"sofaPart3VRayCompleteMap.jpg\"]\r\n    ]', '[\r\n        {\r\n            \"name\": \"Wall 1\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall1-icon.jpg\",\r\n            \"geometryFile\": \"wall1.js\",\r\n            \"aoMapFile\": \"wall1VRayCompleteMap.jpg\",\r\n            \"width\": 6406.3,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 6390,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": -1850, \"y\": 1373, \"z\": 79 },\r\n                \"rotation\": { \"x\": 0, \"y\": 1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 2300, \"y\": 1500, \"z\": 79 },\r\n                \"target\": { \"x\": -1000, \"y\": 1500, \"z\": 79 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 2\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall2-icon.jpg\",\r\n            \"geometryFile\": \"wall2.js\",\r\n            \"aoMapFile\": \"wall2VRayCompleteMap.jpg\",\r\n            \"width\": 4267.2,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 4240,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": 265, \"y\": 1373, \"z\": -3105 },\r\n                \"rotation\": { \"x\": 0, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 265, \"y\": 1500, \"z\": 1500 },\r\n                \"target\": { \"x\": 265, \"y\": 1500, \"z\": -1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 3\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall3-icon.jpg\",\r\n            \"geometryFile\": \"wall3.js\",\r\n            \"aoMapFile\": \"wall3VRayCompleteMap.jpg\",\r\n            \"width\": 4267.2,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 4240,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": 265, \"y\": 1373, \"z\": 3262 },\r\n                \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 265, \"y\": 1500, \"z\": -1500 },\r\n                \"target\": { \"x\": 265, \"y\": 1500, \"z\": 1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Floor\",\r\n            \"type\": \"floor\",\r\n            \"iconFile\": \"floor-icon.jpg\",\r\n            \"geometryFile\": \"floor.js\",\r\n            \"aoMapFile\": \"floorVRayCompleteMap.jpg\",\r\n            \"width\": 6406.3,\r\n            \"height\": 4267.2,\r\n            \"mirror\": {\r\n                \"width\": 4240,\r\n                \"height\": 6390,\r\n                \"position\": { \"x\": 265, \"y\": 20, \"z\": 79 },\r\n                \"rotation\": { \"x\": -1, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1700, \"y\": 1500, \"z\": 3000 },\r\n                \"target\": { \"x\": -900, \"y\": 600, \"z\": 2200 }\r\n            }\r\n        }\r\n    ]', '[\r\n        {\r\n            \"width\": 6286.3,\r\n            \"height\": 2627.1,\r\n            \"position\": { \"x\": 2413, \"y\": 1373.55, \"z\": 79.2 },\r\n            \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n            \"opacity\": 0.2,\r\n            \"color\": \"0x28403d\"\r\n        }\r\n    ]', 1, 1, '2017-04-15 17:33:05', '2021-09-22 01:22:07'),
(6, 'Kitchen #1', 'kitchen', '/roomsResources/kitchen-1/', 'rooms/giog9bJXZWXUxtwHj0lizJKD9SEJ6VZWFMlxcY0P.jpeg', 2048, 60, '{ \"x\": 4309.4, \"y\": 2747.1, \"z\": 5497.8 }', 1500, '{\r\n        \"min\": { \"x\": -1800, \"y\": 550, \"z\": -1950 },\r\n        \"max\": { \"x\": 2350, \"y\": 2650, \"z\": 3200 }\r\n    }', '[\r\n        [\"ceiling.js\", \"ceilingVRayCompleteMap.jpg\"],\r\n        [\"wallParts.js\", \"wallPartsVRayCompleteMap.jpg\"],\r\n        [\"door.js\", \"doorVRayCompleteMap.jpg\"],\r\n        [\"lights.js\", \"lightsVRayCompleteMap.jpg\"],\r\n        [\"windowFrame.js\", \"windowFrameVRayCompleteMap.jpg\"],\r\n        [\"table.js\", \"tableVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"legs.js\", \"\", \"metal\", \"0xffffff\", 1.8],\r\n        [\"chair1.js\", \"chair1VRayCompleteMap.jpg\"],\r\n        [\"chair2.js\", \"chair2VRayCompleteMap.jpg\"],\r\n        [\"chair3.js\", \"chair3VRayCompleteMap.jpg\"],\r\n        [\"chair4.js\", \"chair4VRayCompleteMap.jpg\"],\r\n        [\"picture.js\", \"pictureVRayCompleteMap.jpg\"],\r\n        [\"domeLamp.js\", \"domeLampVRayCompleteMap.jpg\"],\r\n        [\"lamp.js\", \"\", \"glass\", \"0xe8e8e8\", 0.7],\r\n        [\"exhaustHood.js\", \"exhaustHoodVRayCompleteMap.jpg\"],\r\n        [\"banks.js\", \"banksVRayCompleteMap.jpg\"],\r\n        [\"kitchenSet.js\", \"kitchenSetVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"kitchenSetDoors.js\", \"kitchenSetDoorsVRayCompleteMap.jpg\"],\r\n        [\"stove.js\", \"stoveVRayCompleteMap.jpg\"],\r\n        [\"handles.js\", \"\", \"metal\"],\r\n        [\"waterTap.js\", \"\", \"metal\", \"0xffffff\", 1.8],\r\n        [\"sink.js\", \"\", \"metal\", \"0xffffff\", 1.8],\r\n        [\"windowView.js\", \"windowViewVRayCompleteMap.jpg\"]\r\n    ]', '[\r\n        {\r\n            \"name\": \"Wall 1\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall1-icon.jpg\",\r\n            \"geometryFile\": \"wall1.js\",\r\n            \"aoMapFile\": \"wall1VRayCompleteMap.jpg\",\r\n            \"width\": 5497.8,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 5480,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": -1850, \"y\": 1373, \"z\": 533 },\r\n                \"rotation\": { \"x\": 0, \"y\": 1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 2300, \"y\": 1500, \"z\": 533 },\r\n                \"target\": { \"x\": -1000, \"y\": 1500, \"z\": 533 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 2\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall2-icon.jpg\",\r\n            \"geometryFile\": \"wall2.js\",\r\n            \"aoMapFile\": \"wall2VRayCompleteMap.jpg\",\r\n            \"width\": 4309.4,\r\n            \"height\": 1896,\r\n            \"mirror\": {\r\n                \"width\": 4290,\r\n                \"height\": 1880,\r\n                \"position\": { \"x\": 286, \"y\": 1799, \"z\": -2200 },\r\n                \"rotation\": { \"x\": 0, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 286, \"y\": 1500, \"z\": 1500 },\r\n                \"target\": { \"x\": 286, \"y\": 1500, \"z\": -1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 3\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall3-icon.jpg\",\r\n            \"geometryFile\": \"wall3.js\",\r\n            \"aoMapFile\": \"wall3VRayCompleteMap.jpg\",\r\n            \"width\": 5497.8,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 5480,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": 2420, \"y\": 1373, \"z\": 533 },\r\n                \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1500, \"y\": 1500, \"z\": 533 },\r\n                \"target\": { \"x\": 1000, \"y\": 1500, \"z\": 533 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 4\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall4-icon.jpg\",\r\n            \"geometryFile\": \"wall4.js\",\r\n            \"aoMapFile\": \"wall4VRayCompleteMap.jpg\",\r\n            \"width\": 4309.4,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 4290,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": 286, \"y\": 1373, \"z\": 3270 },\r\n                \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 286, \"y\": 1500, \"z\": 0 },\r\n                \"target\": { \"x\": 286, \"y\": 1500, \"z\": 2000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Floor\",\r\n            \"type\": \"floor\",\r\n            \"iconFile\": \"floor-icon.jpg\",\r\n            \"geometryFile\": \"floor.js\",\r\n            \"aoMapFile\": \"floorVRayCompleteMap.jpg\",\r\n            \"width\": 5497.8,\r\n            \"height\": 4309.4,\r\n            \"mirror\": {\r\n                \"width\": 4280,\r\n                \"height\": 5470,\r\n                \"position\": { \"x\": 286, \"y\": 20, \"z\": 533 },\r\n                \"rotation\": { \"x\": -1, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1700, \"y\": 1500, \"z\": 3100 },\r\n                \"target\": { \"x\": -600, \"y\": 600, \"z\": 2100 }\r\n            }\r\n        }\r\n    ]', '[\r\n        {\r\n            \"width\": 1080,\r\n            \"height\": 1980,\r\n            \"position\": { \"x\": 2524.7, \"y\": 1450, \"z\": 65.3 },\r\n            \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n            \"opacity\": 0.2,\r\n            \"color\": \"0x28403d\"\r\n        },\r\n        {\r\n            \"width\": 1080,\r\n            \"height\": 1980,\r\n            \"position\": { \"x\": 2524.7, \"y\": 1450, \"z\": 2092.8 },\r\n            \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n            \"opacity\": 0.2,\r\n            \"color\": \"0x28403d\"\r\n        }\r\n    ]', 1, 1, '2017-04-19 17:31:26', '2021-09-22 01:22:07'),
(7, 'Kitchen #2', 'kitchen', '/roomsResources/kitchen-2/', 'rooms/l07HnKgBXVZoP0Cn6Cisw7pirczi5RWpR9vQy8WV.jpeg', 2048, 60, '{ \"x\": 4924.27, \"y\": 2747.1, \"z\": 6096 }', 1500, '{\r\n        \"min\": { \"x\": -1750, \"y\": 550, \"z\": -1600 },\r\n        \"max\": { \"x\": 2900, \"y\": 2400, \"z\": 3700 }\r\n    }', '[\r\n        [\"ceiling.js\", \"ceilingVRayCompleteMap.jpg\"],\r\n        [\"door.js\", \"doorVRayCompleteMap.jpg\"],\r\n        [\"doorHandle.js\", \"\", \"metal\"],\r\n        [\"window.js\", \"windowVRayCompleteMap.jpg\"],\r\n        [\"lights.js\", \"lightsVRayCompleteMap.jpg\"],\r\n        [\"picture.js\", \"pictureVRayCompleteMap.jpg\"],\r\n        [\"chair1.js\", \"chair1VRayCompleteMap.jpg\"],\r\n        [\"chair2.js\", \"chair2VRayCompleteMap.jpg\"],\r\n        [\"chair3.js\", \"chair3VRayCompleteMap.jpg\"],\r\n        [\"chair4.js\", \"chair4VRayCompleteMap.jpg\"],\r\n        [\"table.js\", \"tableVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"kitchenSet.js\", \"kitchenSetVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"vases.js\", \"vasesVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"waterTap.js\", \"\", \"metal\", \"0xffffff\", 1.8],\r\n        [\"sink.js\", \"\", \"metal\", \"0x111111\", 1.8],\r\n        [\"ventilation.js\", \"ventilationVRayCompleteMap.jpg\"],\r\n        [\"oven.js\", \"ovenVRayCompleteMap.jpg\"],\r\n        [\"ovenMetal.js\", \"\", \"metal\", \"0xbbbbbb\", 0.4],\r\n        [\"lamp.js\", \"\", \"metal\", \"0x181818\", 1.8],\r\n        [\"lampInner.js\", \"lampInnerVRayCompleteMap.jpg\"],\r\n        [\"stove.js\", \"stoveVRayCompleteMap.jpg\"],\r\n        [\"countertop.js\", \"\", \"metal\", \"0x222222\", 1.8],\r\n        [\"exhaustHood.js\", \"\", \"metal\", \"0xbbbbbb\", 0.4],\r\n        [\"windowView.js\", \"windowViewVRayCompleteMap.jpg\"]\r\n    ]', '[\r\n        {\r\n            \"name\": \"Wall 1\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall1-icon.jpg\",\r\n            \"geometryFile\": \"wall1.js\",\r\n            \"aoMapFile\": \"wall1VRayCompleteMap.jpg\",\r\n            \"width\": 6096,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 6070,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": -1850, \"y\": 1373, \"z\": 830 },\r\n                \"rotation\": { \"x\": 0, \"y\": 1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 2700, \"y\": 1500, \"z\": 900 },\r\n                \"target\": { \"x\": -1000, \"y\": 1500, \"z\": 900 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 2\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall2-icon.jpg\",\r\n            \"geometryFile\": \"wall2.js\",\r\n            \"aoMapFile\": \"wall2VRayCompleteMap.jpg\",\r\n            \"width\": 4924.27,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 4900,\r\n                \"height\": 1830,\r\n                \"position\": { \"x\": 594, \"y\": 1823, \"z\": -2200 },\r\n                \"rotation\": { \"x\": 0, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 600, \"y\": 1500, \"z\": 2500 },\r\n                \"target\": { \"x\": 600, \"y\": 1500, \"z\": -1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 3\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall3-icon.jpg\",\r\n            \"geometryFile\": \"wall3.js\",\r\n            \"aoMapFile\": \"wall3VRayCompleteMap.jpg\",\r\n            \"width\": 6096,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 6070,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": 3035, \"y\": 1373, \"z\": 830 },\r\n                \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1500, \"y\": 1500, \"z\": 900 },\r\n                \"target\": { \"x\": 1000, \"y\": 1500, \"z\": 900 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 4\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall4-icon.jpg\",\r\n            \"geometryFile\": \"wall4.js\",\r\n            \"aoMapFile\": \"wall4VRayCompleteMap.jpg\",\r\n            \"width\": 4924.27,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 4900,\r\n                \"height\": 2730,\r\n                \"position\": { \"x\": 594, \"y\": 1373, \"z\": 3860 },\r\n                \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 600, \"y\": 1500, \"z\": -1000 },\r\n                \"target\": { \"x\": 600, \"y\": 1500, \"z\": 1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Floor\",\r\n            \"type\": \"floor\",\r\n            \"iconFile\": \"floor-icon.jpg\",\r\n            \"geometryFile\": \"floor.js\",\r\n            \"aoMapFile\": \"floorVRayCompleteMap.jpg\",\r\n            \"width\": 5566,\r\n            \"height\": 4924.27,\r\n            \"mirror\": {\r\n                \"width\": 4900,\r\n                \"height\": 5550,\r\n                \"position\": { \"x\": 594, \"y\": 20, \"z\": 1096 },\r\n                \"rotation\": { \"x\": -1, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1600, \"y\": 1500, \"z\": 3600 },\r\n                \"target\": { \"x\": -500, \"y\": 600, \"z\": 2500 }\r\n            }\r\n        }\r\n    ]', '[\r\n        {\r\n            \"width\": 1880,\r\n            \"height\": 1251,\r\n            \"position\": { \"x\": 594, \"y\": 1436, \"z\": 3996 },\r\n            \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n            \"opacity\": 0.2,\r\n            \"color\": \"0x28403d\"\r\n        }\r\n    ]', 1, 1, '2017-04-30 18:57:52', '2021-09-22 01:22:07'),
(8, 'Bathroom #2', 'bathroom', '/roomsResources/bathroom-2/', 'rooms/hfPcxZTw0VrYzuXUb09jgGkhTCuKYdmAGyJq9Bj5.jpeg', 2048, 60, '{ \"x\": 3657.6, \"y\": 2747.1, \"z\": 4572 }', 1500, '{\r\n        \"min\": { \"x\": -1300, \"y\": 550, \"z\": -2400 },\r\n        \"max\": { \"x\": 2100, \"y\": 2600, \"z\": 1900 }\r\n    }', '[\r\n        [\"ceiling.js\", \"ceilingVRayCompleteMap.jpg\"],\r\n        [\"window.js\", \"windowVRayCompleteMap.jpg\"],\r\n        [\"door.js\", \"doorVRayCompleteMap.jpg\"],\r\n        [\"lights.js\", \"lightsVRayCompleteMap.jpg\"],\r\n        [\"mirror.js\", \"\", \"metal\", \"\", 1.8],\r\n        [\"shelf.js\", \"shelfVRayCompleteMap.jpg\"],\r\n        [\"ambry.js\", \"ambryVRayCompleteMap.jpg\"],\r\n        [\"windowFrame.js\", \"windowFrameVRayCompleteMap.jpg\"],\r\n        [\"showerBottom.js\", \"showerBottomVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"showerGlass.js\", \"\", \"glassWall\"],\r\n        [\"shower.js\", \"\", \"metal\", \"\", 1.8],\r\n        [\"metalParts.js\", \"\", \"metal\", \"\", 1.8],\r\n        [\"metalParts2.js\", \"\", \"metal\", \"\", 1.8],\r\n        [\"sinks.js\", \"sinksVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"toilet.js\", \"toiletVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"bath.js\", \"bathVRayCompleteMap.jpg\", \"ceramic\"],\r\n        [\"waterTaps.js\", \"\", \"metal\", \"0xcccccc\", 1.8],\r\n        [\"bathTap.js\", \"\", \"metal\", \"\", 1.8],\r\n        [\"windowView.js\", \"windowViewVRayCompleteMap.jpg\"]\r\n    ]', '[\r\n        {\r\n            \"name\": \"Wall 1\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall1-icon.jpg\",\r\n            \"geometryFile\": \"wall1.js\",\r\n            \"aoMapFile\": \"wall1VRayCompleteMap.jpg\",\r\n            \"width\": 4572,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 4552,\r\n                \"height\": 2727,\r\n                \"position\": { \"x\": -1400, \"y\": 1373, \"z\": -223 },\r\n                \"rotation\": { \"x\": 0, \"y\": 1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 2000, \"y\": 1500, \"z\": -300 },\r\n                \"target\": { \"x\": -1000, \"y\": 1500, \"z\": -300 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 2\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall2-icon.jpg\",\r\n            \"geometryFile\": \"wall2.js\",\r\n            \"aoMapFile\": \"wall2VRayCompleteMap.jpg\",\r\n            \"width\": 3657.6,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 3637,\r\n                \"height\": 2727,\r\n                \"position\": { \"x\": 412, \"y\": 1373, \"z\": -2490 },\r\n                \"rotation\": { \"x\": 0, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 400, \"y\": 1500, \"z\": 1000 },\r\n                \"target\": { \"x\": 400, \"y\": 1500, \"z\": -1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 3\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall3-icon.jpg\",\r\n            \"geometryFile\": \"wall3.js\",\r\n            \"aoMapFile\": \"wall3VRayCompleteMap.jpg\",\r\n            \"width\": 4572,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 4552,\r\n                \"height\": 2727,\r\n                \"position\": { \"x\": 2220, \"y\": 1373, \"z\": -223 },\r\n                \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1000, \"y\": 1500, \"z\": -300 },\r\n                \"target\": { \"x\": 1000, \"y\": 1500, \"z\": -300 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 4\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall4-icon.jpg\",\r\n            \"geometryFile\": \"wall4.js\",\r\n            \"aoMapFile\": \"wall4VRayCompleteMap.jpg\",\r\n            \"width\": 3657.6,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 3637,\r\n                \"height\": 2527,\r\n                \"position\": { \"x\": 412, \"y\": 1473, \"z\": 2044 },\r\n                \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 400, \"y\": 1500, \"z\": -1000 },\r\n                \"target\": { \"x\": 400, \"y\": 1500, \"z\": 1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Floor\",\r\n            \"type\": \"floor\",\r\n            \"iconFile\": \"floor-icon.jpg\",\r\n            \"geometryFile\": \"floor.js\",\r\n            \"aoMapFile\": \"floorVRayCompleteMap.jpg\",\r\n            \"width\": 4772,\r\n            \"height\": 3657.6,\r\n            \"mirror\": {\r\n                \"width\": 3637,\r\n                \"height\": 3552,\r\n                \"position\": { \"x\": 412, \"y\": 20, \"z\": -723 },\r\n                \"rotation\": { \"x\": -1, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1100, \"y\": 1500, \"z\": -2200 },\r\n                \"target\": { \"x\": -300, \"y\": 600, \"z\": -1400 }\r\n            }\r\n        }\r\n    ]', '[\r\n        {\r\n            \"width\": 2000,\r\n            \"height\": 700,\r\n            \"position\": { \"x\": -1400, \"y\": 1630, \"z\": -160 },\r\n            \"rotation\": { \"x\": 0, \"y\": 1, \"z\": 0 },\r\n            \"textureSize\": 1024\r\n        },\r\n        {\r\n            \"width\": 1100,\r\n            \"height\": 2200,\r\n            \"position\": { \"x\": 412.2, \"y\": 1300, \"z\": 1089.6 },\r\n            \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n            \"opacity\": 0.2,\r\n            \"color\": \"0x28403d\"\r\n        },\r\n        {\r\n            \"width\": 892.8,\r\n            \"height\": 2241,\r\n            \"position\": { \"x\": -920.2, \"y\": 1370.5, \"z\": 2181.5 },\r\n            \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n            \"opacity\": 0.2,\r\n            \"color\": \"0x28403d\"\r\n        },\r\n        {\r\n            \"width\": 892.8,\r\n            \"height\": 2241,\r\n            \"position\": { \"x\": 1744.6, \"y\": 1370.5, \"z\": 2181.5 },\r\n            \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n            \"opacity\": 0.2,\r\n            \"color\": \"0x28403d\"\r\n        }\r\n    ]', 1, 1, '2017-05-02 10:05:06', '2021-09-22 01:22:07');
INSERT INTO `rooms` (`id`, `name`, `type`, `sourcesPath`, `iconfile`, `mapSize`, `cameraFov`, `size`, `firstPersonViewHeight`, `endPoints`, `parts`, `tiledSurfaces`, `mirrors`, `useMirrors`, `enabled`, `created_at`, `updated_at`) VALUES
(9, 'Bedroom #2', 'bedroom', '/roomsResources/bedroom-2/', 'rooms/qMDriUOZd9MD9SNn0fLQ2E4ApaJn2RiUdlzHhgGK.jpeg', 2048, 60, '{ \"x\": 4269.2, \"y\": 2747.1, \"z\": 6406.3 }', 1500, '{\r\n        \"min\": { \"x\": -1700, \"y\": 550, \"z\": -3000 },\r\n        \"max\": { \"x\": 2300, \"y\": 2600, \"z\": 3100 }\r\n    }', '[\r\n        [\"ceiling.js\", \"ceilingVRayCompleteMap.jpg\"],\r\n        [\"wallOutside.js\", \"wallOutsideVRayCompleteMap.jpg\"],\r\n        [\"woodWall.js\", \"woodWallVRayCompleteMap.jpg\"],\r\n        [\"picture.js\", \"pictureVRayCompleteMap.jpg\"],\r\n        [\"lights.js\", \"lightsVRayCompleteMap.jpg\"],\r\n        [\"window.js\", \"windowVRayCompleteMap.jpg\"],\r\n        [\"shelves.js\", \"shelvesVRayCompleteMap.jpg\"],\r\n        [\"nightstands.js\", \"nightstandsVRayCompleteMap.jpg\"],\r\n        [\"bed.js\", \"bedVRayCompleteMap.jpg\"],\r\n        [\"lamp.js\", \"lampVRayCompleteMap.jpg\"],\r\n        [\"chair.js\", \"chairVRayCompleteMap.jpg\"],\r\n        [\"books.js\", \"booksVRayCompleteMap.jpg\"],\r\n        [\"blanket.js\", \"blanketVRayCompleteMap.jpg\"],\r\n        [\"doorHandle.js\", \"\", \"metal\", \"0xcccccc\", 1.8],\r\n        [\"windowView.js\", \"windowViewVRayCompleteMap.jpg\"]\r\n    ]', '[\r\n        {\r\n            \"name\": \"Wall 2\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall2-icon.jpg\",\r\n            \"geometryFile\": \"wall2.js\",\r\n            \"aoMapFile\": \"wall2VRayCompleteMap.jpg\",\r\n            \"width\": 4269.2,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 4249,\r\n                \"height\": 2727,\r\n                \"position\": { \"x\": 266, \"y\": 1373, \"z\": -3104 },\r\n                \"rotation\": { \"x\": 0, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 300, \"y\": 1500, \"z\": 1000 },\r\n                \"target\": { \"x\": 300, \"y\": 1500, \"z\": -1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 3\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall3-icon.jpg\",\r\n            \"geometryFile\": \"wall3.js\",\r\n            \"aoMapFile\": \"wall3VRayCompleteMap.jpg\",\r\n            \"width\": 6406.3,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 6386,\r\n                \"height\": 2727,\r\n                \"position\": { \"x\": 2380, \"y\": 1373, \"z\": 79 },\r\n                \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": -1600, \"y\": 1500, \"z\": 100 },\r\n                \"target\": { \"x\": 1000, \"y\": 1500, \"z\": 100 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Wall 4\",\r\n            \"type\": \"wall\",\r\n            \"iconFile\": \"wall4-icon.jpg\",\r\n            \"geometryFile\": \"wall4.js\",\r\n            \"aoMapFile\": \"wall4VRayCompleteMap.jpg\",\r\n            \"width\": 4269.2,\r\n            \"height\": 2747.1,\r\n            \"mirror\": {\r\n                \"width\": 4249,\r\n                \"height\": 2727,\r\n                \"position\": { \"x\": 266, \"y\": 1373, \"z\": 3263 },\r\n                \"rotation\": { \"x\": 0, \"y\": 2, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 300, \"y\": 1500, \"z\": -1000 },\r\n                \"target\": { \"x\": 300, \"y\": 1500, \"z\": 1000 }\r\n            }\r\n        },\r\n        {\r\n            \"name\": \"Floor\",\r\n            \"type\": \"floor\",\r\n            \"iconFile\": \"floor-icon.jpg\",\r\n            \"geometryFile\": \"floor.js\",\r\n            \"aoMapFile\": \"floorVRayCompleteMap.jpg\",\r\n            \"width\": 6406.3,\r\n            \"height\": 4269.2,\r\n            \"mirror\": {\r\n                \"width\": 4249,\r\n                \"height\": 6386,\r\n                \"position\": { \"x\": 266, \"y\": 20, \"z\": 79 },\r\n                \"rotation\": { \"x\": -1, \"y\": 0, \"z\": 0 },\r\n                \"opacity\": 0.08\r\n            },\r\n            \"view\": {\r\n                \"position\": { \"x\": 2200, \"y\": 1500, \"z\": -2900 },\r\n                \"target\": { \"x\": 1400, \"y\": 600, \"z\": -1800 }\r\n            }\r\n        }\r\n    ]', '[\r\n        {\r\n            \"width\": 4724,\r\n            \"height\": 2667,\r\n            \"position\": { \"x\": 2454, \"y\": 1374, \"z\": 12 },\r\n            \"rotation\": { \"x\": 0, \"y\": -1, \"z\": 0 },\r\n            \"opacity\": 0.2,\r\n            \"color\": \"0x28403d\"\r\n        }\r\n    ]', 1, 1, '2017-05-07 19:32:20', '2021-09-22 01:22:07');

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

--
-- Table structure for table `room_types`
--

CREATE TABLE `room_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `room_types`
--

INSERT INTO `room_types` (`id`, `name`, `display_name`, `enabled`, `created_at`, `updated_at`) VALUES
(1, 'bedroom', 'Bedroom', 1, '2017-09-12 18:26:16', '2017-09-12 18:26:16'),
(2, 'livingroom', 'Livingroom', 1, '2017-09-12 18:26:31', '2017-09-12 18:26:31'),
(3, 'kitchen', 'Kitchen', 1, '2017-09-12 18:26:38', '2017-09-12 18:26:38'),
(4, 'bathroom', 'Bathroom', 1, '2017-09-12 18:26:45', '2017-09-12 18:26:45'),
(5, 'hall', 'Hall', 1, '2017-09-12 18:26:52', '2017-09-12 18:26:52'),
(6, 'balcony', 'Balcony', 1, '2017-09-12 18:27:00', '2017-09-12 18:27:00'),
(7, 'outdoor', 'Outdoor', 1, '2017-09-12 18:27:31', '2017-09-12 18:27:31'),
(9, 'other', 'Other', 1, '2017-09-16 06:13:24', '2017-09-16 06:13:24');

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

--
-- Table structure for table `surface_types`
--

CREATE TABLE `surface_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `surface_types`
--

INSERT INTO `surface_types` (`id`, `name`, `display_name`, `enabled`, `created_at`, `updated_at`) VALUES
(1, 'wall', 'Wall', 1, '2017-09-12 18:25:07', '2017-09-12 18:25:07'),
(2, 'floor', 'Floor', 1, '2017-09-12 18:25:17', '2017-09-12 18:25:17'),
(3, 'furniture', 'Furniture', 1, '2017-09-12 18:25:44', '2017-09-12 18:25:44'),
(4, 'counter', 'Counter', 1, '2017-09-12 18:25:56', '2017-09-12 18:25:56');

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

--
-- Table structure for table `tiles`
--

CREATE TABLE `tiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shape` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'square',
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  `surface` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `finish` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 'glossy',
  `file` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `grout` tinyint(1) DEFAULT '1',
  `url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` float DEFAULT NULL,
  `rotoPrintSetName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expProps` text COLLATE utf8mb4_unicode_ci,
  `access_level` int(4) DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `filters`
--
ALTER TABLE `filters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `room2ds`
--
ALTER TABLE `room2ds`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `room_types`
--
ALTER TABLE `room_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `surface_types`
--
ALTER TABLE `surface_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tiles`
--
ALTER TABLE `tiles`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `companies`
--
ALTER TABLE `companies`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `filters`
--
ALTER TABLE `filters`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `room2ds`
--
ALTER TABLE `room2ds`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `rooms`
--
ALTER TABLE `rooms`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `room_types`
--
ALTER TABLE `room_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `surface_types`
--
ALTER TABLE `surface_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tiles`
--
ALTER TABLE `tiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;
COMMIT;

