
--
-- Table structure for table `variance_scanned_datas`
--

CREATE TABLE `variance_scanned_datas` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `location_id` int DEFAULT NULL,
  `asset_tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `asset_type_ids` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `variance_scanned_datas`
--


--
-- Table structure for table `vendor_categories`
--

CREATE TABLE `vendor_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_categories`
--


--
-- Table structure for table `vendor_category_vendors`
--

CREATE TABLE `vendor_category_vendors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `vendor_id` int NOT NULL,
  `vendor_category_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_category_vendors`
--


--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `region_id` int DEFAULT NULL,
  `country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `punch_out` tinyint(1) NOT NULL DEFAULT '0',
  `vendor_stocking` tinyint(1) NOT NULL DEFAULT '0',
  `advance_payment` tinyint(1) NOT NULL DEFAULT '0',
  `asset_type_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `contact_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `contact_email` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendors`
--


--
-- Table structure for table `zoom_devices`
--

CREATE TABLE `zoom_devices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int DEFAULT NULL,
  `location_id` int DEFAULT NULL,
  `zoom_location_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `room_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `calendar_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `room_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `health` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `issue` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `network_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `camera` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `microphone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `speaker` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `room_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_system` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hostname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `manufacturer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `firmware` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `app_version` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mac_addresses` text COLLATE utf8mb4_unicode_ci,
  `last_start_time` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `building` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `zoom_devices`
--

INSERT INTO `zoom_devices` VALUES (1,923,16,'XlnApRJqR2CfSxJL0iw5cg','VttUS59WT-ui-6uKMI8RvQ','logi-2506FDN007D2','2506FDN007D2',NULL,'MR-CZ-4FL-Masaryk','PRG','CZ/PRG/WeWork','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Scheduling Display','Android 1.14.373','MR-CZ-4FL-Masaryk','Logitech','Tap Scheduler','1.14.373','6.5.5 (3902)','10.105.245.11','94:02:30:14:7D:83',NULL,'2025-07-15 02:25:49','2025-10-30 04:00:16','CZ','Floor1','Building1'),(2,924,16,'XlnApRJqR2CfSxJL0iw5cg','VttUS59WT-ui-6uKMI8RvQ','logi-2442FDS023X2','2442FDS023X2',NULL,'MR-CZ-4FL-Masaryk','PRG','CZ/PRG/WeWork','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 10','MR-CZ-4FL-Masaryk','Logitech','Tap IP','1.14.371','6.3.5 (3287)','10.105.245.40','94:02:30:12:07:D3',NULL,'2025-07-15 02:25:49','2025-12-10 04:06:05','CZ','Floor1','Building1'),(3,925,16,'XlnApRJqR2CfSxJL0iw5cg','VttUS59WT-ui-6uKMI8RvQ','logi-2443FDW06JH2','2443FDW06JH2',NULL,'MR-CZ-4FL-Masaryk','PRG','CZ/PRG/WeWork','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.14.377','MR-CZ-4FL-Masaryk Logitech VR0020','Logitech','Rally Bar Mini','1.14.377','6.5.5 (7566)','10.105.245.12','44:73:D6:F3:8F:DF',NULL,'2025-07-15 02:25:49','2025-10-30 04:00:16','CZ','Floor1','Building1'),(4,926,17,'XlnApRJqR2CfSxJL0iw5cg','SsU5DkkaTCqCpQcWRwVOTg','logi-2503FD005KC2','2503FD005KC2',NULL,'MR-CZ-4FL-Radecky','PRG','CZ/PRG/WeWork','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Scheduling Display','Android 1.15.132','MR-CZ-4FL-Radecky','Logitech','Tap Scheduler','1.15.132','6.6.10 (4464)','10.105.245.13','94:02:30:14:5B:60',NULL,'2025-07-15 02:25:55','2025-12-05 04:06:22','CZ','Floor1','Building1'),(5,927,17,'XlnApRJqR2CfSxJL0iw5cg','SsU5DkkaTCqCpQcWRwVOTg','logi-2442FD702EN2','2442FD702EN2',NULL,'MR-CZ-4FL-Radecky','PRG','CZ/PRG/WeWork','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.14.181','MR-CZ-4FL-Radecky','Logitech','Tap IP','1.14.181','6.3.5 (3287)','10.105.245.225','94:02:30:12:07:C7',NULL,'2025-07-15 02:25:55','2025-12-05 04:06:22','CZ','Floor1','Building1'),(6,928,17,'XlnApRJqR2CfSxJL0iw5cg','SsU5DkkaTCqCpQcWRwVOTg','logi-2443FD406T62','2443FD406T62',NULL,'MR-CZ-4FL-Radecky','PRG','CZ/PRG/WeWork','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.14.180','MR-CZ-4FL-Radecky Logitech VR0020','Logitech','Rally Bar Mini','1.14.180','6.3.5 (6258)','10.105.245.16','44:73:D6:F3:8F:4C',NULL,'2025-07-15 02:25:55','2025-11-07 04:00:22','CZ','Floor1','Building1'),(7,929,47,'m3KGplV_TwCfV1ts5-3-Lg','wwr0rdW7Tt6IkHp41bZR5g','logi-2201FDJXQEP2','2201FDJXQEP2',NULL,'MR-FI-2FL-Riisto','MAN','FI/MAN/DC','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.15.132','MR-FI-2FL-Riisto','Logitech','Tap IP','1.15.132','6.5.1 (3862)','2A13:5947:102:5:BADB:CA70:811:4FAA','44:73:D6:B8:48:50',NULL,'2025-07-15 02:26:00','2025-12-10 04:06:33','FI','Floor1','Building1'),(8,930,47,'m3KGplV_TwCfV1ts5-3-Lg','wwr0rdW7Tt6IkHp41bZR5g','logi-2143FDZ6TTF2','2143FDZ6TTF2',NULL,'MR-FI-2FL-Riisto','MAN','FI/MAN/DC','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.12.268','MR-FI-2FL-Riisto Logitech VR0020','Logitech','Rally Bar Mini','1.12.268','6.0.0 (4799)','10.64.50.5','44:73:D6:A3:0A:65',NULL,'2025-07-15 02:26:00','2025-12-10 04:06:33','FI','Floor1','Building1'),(9,931,19,'m3KGplV_TwCfV1ts5-3-Lg','gYg1bFp6R6e6494hTl0LHQ','logi-2201FDJXRHF2','2201FDJXRHF2',NULL,'MR-FI-2Fl-Mantsala','MAN','FI/MAN/DC','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.12.184','MR-FI-2Fl-Mantsala','Logitech','Tap IP','1.12.184','6.1.0 (2857)','2A13:5947:102:5:95F2:DBB3:5A9E:CED9','44:73:D6:B8:48:29',NULL,'2025-07-15 02:26:06','2025-12-06 04:06:27','FI','Floor1','Building1'),(10,932,19,'m3KGplV_TwCfV1ts5-3-Lg','gYg1bFp6R6e6494hTl0LHQ','logi-2147FDZ8MQK2','2147FDZ8MQK2',NULL,'MR-FI-2Fl-Mantsala','MAN','FI/MAN/DC','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.12.268','MR-FI-2Fl-Mantsala Logitech VR0020','Logitech','Rally Bar Mini','1.12.268','6.1.2 (5202)','10.64.50.7','44:73:D6:B4:2E:42',NULL,'2025-07-15 02:26:06','2025-12-08 04:06:30','FI','Floor1','Building1'),(11,933,20,'EQmmXkJtR6SPxEsaRpj57A','dfDkQZG1RV-12KS6JMYNXw','logi-2145FDJX8TU2','2145FDJX8TU2',NULL,'MR-IL-39FL-Andromeda','TA','IL/TA/Alon','Offline',NULL,NULL,NULL,NULL,NULL,NULL,'Offline','Controller','Android 1.11.200','MR-IL-39FL-Andromeda','Logitech','Tap IP','1.11.200','5.16.5 (2354)','10.64.18.116','44:73:D6:B2:9A:1C',NULL,'2025-07-15 02:26:11','2025-12-09 04:06:39','IL','Floor1','Building1'),(12,934,20,'EQmmXkJtR6SPxEsaRpj57A','dfDkQZG1RV-12KS6JMYNXw','logi-2147FDATHQX2','2147FDATHQX2',NULL,'MR-IL-39FL-Andromeda','TA','IL/TA/Alon','Offline',NULL,NULL,NULL,NULL,NULL,NULL,'Offline','Zoom Rooms Computer','Android 1.11.266','MR-IL-39FL-Andromeda Logitech VR0019','Logitech','Rally Bar','1.11.266','5.17.1 (4336)','10.64.18.10','44:73:D6:AF:52:E9',NULL,'2025-07-15 02:26:11','2025-12-09 04:06:39','IL','Floor1','Building1'),(13,935,21,'EQmmXkJtR6SPxEsaRpj57A','OhFaFsZKSK-ZM3ZIvxQetA','logi-2139FDJXQGH2','2139FDJXQGH2',NULL,'MR-IL-39FL-Inference','TA','IL/TA/Alon','Offline',NULL,NULL,NULL,NULL,NULL,NULL,'Offline','Controller','Android 1.11.205','MR-IL-39FL-Inference','Logitech','Tap IP','1.11.205','5.17.1 (2486)','10.64.18.5','44:73:D6:B2:7F:D9',NULL,'2025-07-15 02:26:17','2025-12-09 04:06:45','IL','Floor1','Building1'),(14,936,21,'EQmmXkJtR6SPxEsaRpj57A','OhFaFsZKSK-ZM3ZIvxQetA','logi-2137FDZ3VTZ2','2137FDZ3VTZ2',NULL,'MR-IL-39FL-Inference','TA','IL/TA/Alon','Offline',NULL,NULL,NULL,NULL,NULL,NULL,'Offline','Zoom Rooms Computer','Android 1.11.266','MR-IL-39FL-Inference Logitech VR0020','Logitech','Rally Bar Mini','1.11.266','5.17.1 (4336)','10.64.18.6','44:73:D6:A2:B1:DC',NULL,'2025-07-15 02:26:17','2025-12-09 04:06:45','IL','Floor1','Building1'),(15,937,22,'EQmmXkJtR6SPxEsaRpj57A','RSN8bckcSa-_KpEljVaGhA','logi-2145FDJX8RZ2','2145FDJX8RZ2',NULL,'MR-IL-39FL-Orion','TA','IL/TA/Alon','Offline',NULL,NULL,NULL,NULL,NULL,NULL,'Offline','Controller','Android 1.11.205','MR-IL-39FL-Orion','Logitech','Tap IP','1.11.205','5.17.1 (2486)','10.64.18.7','44:73:D6:B2:99:CE',NULL,'2025-07-15 02:26:22','2025-12-09 04:06:50','IL','Floor1','Building1'),(16,938,22,'EQmmXkJtR6SPxEsaRpj57A','RSN8bckcSa-_KpEljVaGhA','logi-2141FDAMSTE2','2141FDAMSTE2',NULL,'MR-IL-39FL-Orion','TA','IL/TA/Alon','Offline',NULL,NULL,NULL,NULL,NULL,NULL,'Offline','Zoom Rooms Computer','Android 1.8.716','MR-IL-39FL-Orion Logitech VR0019','Logitech','Rally Bar','1.8.716','5.17.1 (4336)','10.64.18.8','44:73:D6:AE:E8:B4',NULL,'2025-07-15 02:26:22','2025-12-09 04:06:50','IL','Floor1','Building1'),(17,939,23,'2kRqVAbNTxO0Gcyqlmp1cg','ZJJAXTChQlevhzMPluIqzg','logi-2223FDJX3802','2223FDJX3802',NULL,'MR-NL-2FL-Bosschaert','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Controller','Android 1.14.181','MR-NL-2FL-Bosschaert','Logitech','Tap IP','1.14.181','6.3.5 (3287)','10.64.2.23','44:73:D6:BB:3F:08',NULL,'2025-07-15 02:26:28','2025-12-08 04:06:58','NL','Floor1','Building1'),(18,940,23,'2kRqVAbNTxO0Gcyqlmp1cg','ZJJAXTChQlevhzMPluIqzg','logi-2150FDZ9NVD2','2150FDZ9NVD2',NULL,'MR-NL-2FL-Bosschaert','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Zoom Rooms Computer','Android 1.11.291','MR-NL-2FL-Bosschaert Logitech VR0020','Logitech','Rally Bar Mini','1.11.291','5.17.7 (5)','10.64.2.18','44:73:D6:B4:59:6E',NULL,'2025-07-15 02:26:28','2025-12-08 04:06:58','NL','Floor1','Building1'),(19,941,24,'2kRqVAbNTxO0Gcyqlmp1cg','HE_mdMNuS0OkUCOsjMsHbA','logi-2223FDJX5HH2','2223FDJX5HH2',NULL,'MR-NL-2FL-Bruegel','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Controller','Android 1.12.184','MR-NL-2FL-Bruegel','Logitech','Tap IP','1.12.184','6.0.0 (2720)','10.64.2.24','44:73:D6:BB:13:37',NULL,'2025-07-15 02:26:33','2025-12-08 04:07:03','NL','Floor1','Building1'),(20,942,24,'2kRqVAbNTxO0Gcyqlmp1cg','HE_mdMNuS0OkUCOsjMsHbA','logi-2147FDZ8NLY2','2147FDZ8NLY2',NULL,'MR-NL-2FL-Bruegel','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Zoom Rooms Computer','Android 1.12.264','MR-NL-2FL-Bruegel Logitech VR0020','Logitech','Rally Bar Mini','1.12.264','6.0.0 (4799)','10.64.2.25','44:73:D6:B3:F6:BC',NULL,'2025-07-15 02:26:33','2025-12-08 04:07:03','NL','Floor1','Building1'),(21,943,25,'2kRqVAbNTxO0Gcyqlmp1cg','vwhEzSQQQBuK8M0LBo1QWQ','logi-2215FDJX6MX2','2215FDJX6MX2',NULL,'MR-NL-2FL-Elburcht','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Controller','Android 1.10.129','MR-NL-2FL-Elburcht','Logitech','Tap IP','1.10.129','5.16.5 (2354)','10.64.2.31','44:73:D6:BA:35:C1',NULL,'2025-07-15 02:26:39','2025-12-10 04:07:06','NL','Floor1','Building1'),(22,944,25,'2kRqVAbNTxO0Gcyqlmp1cg','vwhEzSQQQBuK8M0LBo1QWQ','logi-2331FD2JCZB2','2331FD2JCZB2',NULL,'MR-NL-2FL-Elburcht','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Zoom Rooms Computer','Android 1.12.264','MR-NL-2FL-Elburcht Logitech VR0020','Logitech','Rally Bar Mini','1.12.264','6.0.6 (4892)','10.64.2.30','44:73:D6:C4:B8:46',NULL,'2025-07-15 02:26:39','2025-12-10 04:07:06','NL','Floor1','Building1'),(23,945,26,'2kRqVAbNTxO0Gcyqlmp1cg','sSimn34eRRCz9v25Q7Hr1w','logi-2215FDJX59K2','2215FDJX59K2',NULL,'MR-NL-2FL-Fabritius','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Controller','Android 1.12.184','MR-NL-2FL-Fabritius','Logitech','Tap IP','1.12.184','6.0.6 (2750)','10.64.2.29','44:73:D6:BA:45:BA',NULL,'2025-07-15 02:26:44','2025-12-10 04:07:11','NL','Floor1','Building1'),(24,946,26,'2kRqVAbNTxO0Gcyqlmp1cg','sSimn34eRRCz9v25Q7Hr1w','logi-2332FD2JE0U2','2332FD2JE0U2',NULL,'MR-NL-2FL-Fabritius','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Zoom Rooms Computer','Android 1.12.268','MR-NL-2FL-Fabritius Logitech VR0020','Logitech','Rally Bar Mini','1.12.268','6.0.6 (4892)','10.64.2.28','44:73:D6:C4:CA:76',NULL,'2025-07-15 02:26:44','2025-12-10 04:07:11','NL','Floor1','Building1'),(25,947,27,'2kRqVAbNTxO0Gcyqlmp1cg','87fBX8PkSbOV0ItWg9RdOg','logi-2223FDJX5R82','2223FDJX5R82',NULL,'MR-NL-2FL-Leyster','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Controller','Android 1.10.121','MR-NL-2FL-Leyster','Logitech','Tap IP','1.10.121','5.16.5 (2354)','10.64.2.26','44:73:D6:BB:3C:8F',NULL,'2025-07-15 02:26:50','2025-12-08 04:07:20','NL','Floor1','Building1'),(26,948,27,'2kRqVAbNTxO0Gcyqlmp1cg','87fBX8PkSbOV0ItWg9RdOg','logi-2147FDZ8Q5Q2','2147FDZ8Q5Q2',NULL,'MR-NL-2FL-Leyster','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Zoom Rooms Computer','Android 1.12.264','MR-NL-2FL-Leyster Logitech VR0020','Logitech','Rally Bar Mini','1.12.264','6.0.0 (4799)','10.64.2.27','44:73:D6:B4:2D:22',NULL,'2025-07-15 02:26:50','2025-12-08 04:07:20','NL','Floor1','Building1'),(27,949,28,'2kRqVAbNTxO0Gcyqlmp1cg','2_T0InYfQPS7n8f2WJNdSA','logi-2215FDJX5G32','2215FDJX5G32',NULL,'MR-NL-3FL-Van Haarlem','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.13.124','MR-NL-3FL-Van Haarlem','Logitech','Tap IP','1.13.124','6.2.1 (3112)','10.64.2.32','44:73:D6:BA:2A:15',NULL,'2025-07-15 02:26:55','2025-11-28 04:01:31','NL','Floor1','Building1'),(28,950,28,'2kRqVAbNTxO0Gcyqlmp1cg','2_T0InYfQPS7n8f2WJNdSA','logi-2332FD2JEXA2','2332FD2JEXA2',NULL,'MR-NL-3FL-Van Haarlem','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.13.127','MR-NL-3FL-Van Haarlem Logitech VR0020','Logitech','Rally Bar Mini','1.13.127','6.2.1 (5688)','10.64.2.33','44:73:D6:E4:87:19',NULL,'2025-07-15 02:26:55','2025-11-28 04:01:31','NL','Floor1','Building1'),(29,951,29,'2kRqVAbNTxO0Gcyqlmp1cg','hp8Z3kxMTyqss-FH2AC0nw','logi-2213FDJXD6V2','2213FDJXD6V2',NULL,'MR-NL-4FL-Bosch','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.12.184','MR-NL-4FL-Bosch','Logitech','Tap IP','1.12.184','6.0.0 (2720)','10.64.2.16','44:73:D6:B9:68:2C',NULL,'2025-07-15 02:27:00','2025-12-10 04:07:28','NL','Floor1','Building1'),(30,952,29,'2kRqVAbNTxO0Gcyqlmp1cg','hp8Z3kxMTyqss-FH2AC0nw','logi-2148FDZ94TD2','2148FDZ94TD2',NULL,'MR-NL-4FL-Bosch','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.12.264','MR-NL-4FL-Bosch Logitech VR0020','Logitech','Rally Bar Mini','1.12.264','6.0.0 (4799)','10.64.2.17','44:73:D6:B4:50:D4',NULL,'2025-07-15 02:27:00','2025-12-10 04:07:28','NL','Floor1','Building1'),(31,953,30,'2kRqVAbNTxO0Gcyqlmp1cg','vuHtOYNrRd68q-8Wp8Gj1w','logi-2213FDJXFXU2','2213FDJXFXU2',NULL,'MR-NL-4FL-De Hooch','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.10.121','MR-NL-4FL-De Hooch','Logitech','Tap IP','1.10.121','5.16.5 (2354)','10.64.2.38','44:73:D6:B9:69:1F',NULL,'2025-07-15 02:27:06','2025-12-06 04:07:33','NL','Floor1','Building1'),(32,954,30,'2kRqVAbNTxO0Gcyqlmp1cg','vuHtOYNrRd68q-8Wp8Gj1w','logi-2150FDZ9PCU2','2150FDZ9PCU2',NULL,'MR-NL-4FL-De Hooch','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 10','MR-NL-4FL-De Hooch Logitech VR0020','Logitech','Rally Bar Mini','1.11.291','5.17.7 (5)','10.64.2.14','44:73:D6:B4:50:C5',NULL,'2025-07-15 02:27:06','2025-12-06 04:07:33','NL','Floor1','Building1'),(33,955,31,'2kRqVAbNTxO0Gcyqlmp1cg','KIrj3aDjROehH-rckicFbw','logi-2209FDJX23M2','2209FDJX23M2',NULL,'MR-NL-4FL-Hals','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Controller','Android 1.11.209','MR-NL-4FL-Hals','Logitech','Tap IP','1.11.209','5.17.5 (2521)','10.64.2.37','44:73:D6:B9:68:FB',NULL,'2025-07-15 02:27:11','2025-12-08 04:07:42','NL','Floor1','Building1'),(34,956,31,'2kRqVAbNTxO0Gcyqlmp1cg','KIrj3aDjROehH-rckicFbw','logi-2150FDZ9NDL2','2150FDZ9NDL2',NULL,'MR-NL-4FL-Hals','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Zoom Rooms Computer','Android 1.11.291','MR-NL-4FL-Hals Logitech VR0020','Logitech','Rally Bar Mini','1.11.291','5.17.5 (4402)','10.64.2.36','44:73:D6:B4:50:F8',NULL,'2025-07-15 02:27:11','2025-12-08 04:07:42','NL','Floor1','Building1'),(35,957,33,'2kRqVAbNTxO0Gcyqlmp1cg','buMcff8tS6KvJvKeGSEZfg','logi-2215FDJX55Q2','2215FDJX55Q2',NULL,'MR-NL-4FL-Rembrandt','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Controller','Android 1.10.129','MR-NL-4FL-Rembrandt','Logitech','Tap IP','1.10.129','5.16.5 (2354)','10.64.2.21','44:73:D6:BA:33:F3',NULL,'2025-07-15 02:27:22','2025-12-08 04:07:53','NL','Floor1','Building1'),(36,958,33,'2kRqVAbNTxO0Gcyqlmp1cg','buMcff8tS6KvJvKeGSEZfg','logi-2332FD2JDCW2','2332FD2JDCW2',NULL,'MR-NL-4FL-Rembrandt','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Zoom Rooms Computer','Android 1.11.291','MR-NL-4FL-Rembrandt Logitech VR0020','Logitech','Rally Bar Mini','1.11.291','5.17.5 (4402)','10.64.2.22','44:73:D6:C4:CA:70',NULL,'2025-07-15 02:27:22','2025-12-08 04:07:53','NL','Floor1','Building1'),(37,959,34,'2kRqVAbNTxO0Gcyqlmp1cg','8EKr_nu6TgaPe0Gn-oLBfw','logi-2215FDJX65D2','2215FDJX65D2',NULL,'MR-NL-4FL-Van Gogh','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.11.209','MR-NL-4FL-Van Gogh','Logitech','Tap IP','1.11.209','5.17.5 (2521)','10.64.2.19','44:73:D6:BA:45:90',NULL,'2025-07-15 02:27:28','2025-12-10 04:07:55','NL','Floor1','Building1'),(38,960,34,'2kRqVAbNTxO0Gcyqlmp1cg','8EKr_nu6TgaPe0Gn-oLBfw','logi-2308FD2JBSS2','2308FD2JBSS2',NULL,'MR-NL-4FL-Van Gogh','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.11.291','MR-NL-4FL-Van Gogh Logitech VR0020','Logitech','Rally Bar Mini','1.11.291','5.17.7 (5)','10.64.2.20','44:73:D6:C4:80:E7',NULL,'2025-07-15 02:27:28','2025-12-10 04:07:55','NL','Floor1','Building1'),(39,961,35,'2kRqVAbNTxO0Gcyqlmp1cg','sboVTIuERPipOlWinAUAsA','logi-2209FDJX1K02','2209FDJX1K02',NULL,'MR-NL-4FL-Vermeer','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.12.184','MR-NL-4FL-Vermeer','Logitech','Tap IP','1.12.184','6.0.0 (2720)','10.64.2.12','44:73:D6:B9:67:D8',NULL,'2025-07-15 02:27:33','2025-12-10 04:08:01','NL','Floor1','Building1'),(40,962,35,'2kRqVAbNTxO0Gcyqlmp1cg','sboVTIuERPipOlWinAUAsA','logi-2150FDZ9MXK2','2150FDZ9MXK2',NULL,'MR-NL-4FL-Vermeer','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.12.268','MR-NL-4FL-Vermeer Logitech VR0020','Logitech','Rally Bar Mini','1.12.268','6.0.0 (4799)','10.64.2.13','44:73:D6:B4:50:5C',NULL,'2025-07-15 02:27:33','2025-12-10 04:08:01','NL','Floor1','Building1'),(41,963,36,'EQmmXkJtR6SPxEsaRpj57A','8ZghVCfASGuMGZpCdwWZMQ','logi-2139FDJXQWV2','2139FDJXQWV2',NULL,'P-IL-39FL-AV','TA','IL/TA/Alon','Offline',NULL,NULL,NULL,NULL,NULL,NULL,'Offline','Controller','Android 1.14.181','P-IL-39FL-AV','Logitech','Tap IP','1.14.181','6.3.5 (3287)','10.64.18.12','44:73:D6:B2:7F:F1',NULL,'2025-07-15 02:27:39','2025-12-09 04:08:08','IL','Floor1','Building1'),(42,964,36,'EQmmXkJtR6SPxEsaRpj57A','8ZghVCfASGuMGZpCdwWZMQ','logi-2139FDZ5SZF2','2139FDZ5SZF2',NULL,'P-IL-39FL-AV','TA','IL/TA/Alon','Offline',NULL,NULL,NULL,NULL,NULL,NULL,'Offline','Zoom Rooms Computer','Android 1.14.180','P-IL-39FL-AV Logitech VR0020','Logitech','Rally Bar Mini','1.14.180','6.3.5 (6258)','10.64.18.117','44:73:D6:A2:AF:F9',NULL,'2025-07-15 02:27:39','2025-12-09 04:08:08','IL','Floor1','Building1'),(43,965,37,'2kRqVAbNTxO0Gcyqlmp1cg','gbjnqSV1S2ea0gjxg9ZXeA','logi-2201FDJXQW02','2201FDJXQW02',NULL,'P-NL-3FL-Boaz.Tal','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.13.145','P-NL-3FL-Boaz.Tal','Logitech','Tap IP','1.13.145','6.0.6 (2750)','10.64.2.47','44:73:D6:B8:47:93',NULL,'2025-07-15 02:27:44','2025-12-02 04:08:13','NL','Floor1','Building1'),(44,966,37,'2kRqVAbNTxO0Gcyqlmp1cg','gbjnqSV1S2ea0gjxg9ZXeA','logi-2137FDZ3ZP62','2137FDZ3ZP62',NULL,'P-NL-3FL-Boaz.Tal','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.13.145','P-NL-3FL-Boaz.Tal Logitech VR0020','Logitech','Rally Bar Mini','1.13.145','6.2.7 (6005)','10.64.2.46','44:73:D6:A2:C1:78',NULL,'2025-07-15 02:27:44','2025-12-02 04:08:13','NL','Floor1','Building1'),(45,967,44,'2kRqVAbNTxO0Gcyqlmp1cg','Nw8OqX46R8SJ-3YdfYXiQw','logi-2223FDJX6RF2','2223FDJX6RF2',NULL,'P-NL-3FL-D.Alonso','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.10.121','P-NL-3FL-D.Alonso','Logitech','Tap IP','1.10.121','5.16.5 (2354)','10.64.2.34','44:73:D6:BB:3F:56',NULL,'2025-07-15 02:27:50','2025-12-04 04:08:16','NL','Floor1','Building1'),(46,968,44,'2kRqVAbNTxO0Gcyqlmp1cg','Nw8OqX46R8SJ-3YdfYXiQw','logi-2223FD2H0102','2223FD2H0102',NULL,'P-NL-3FL-D.Alonso','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.12.264','P-NL-3FL-D.Alonso Logitech VR0020','Logitech','Rally Bar Mini','1.12.264','6.0.0 (4799)','10.64.2.35','44:73:D6:B4:B4:AF',NULL,'2025-07-15 02:27:50','2025-12-04 04:08:16','NL','Floor1','Building1'),(47,969,39,'2kRqVAbNTxO0Gcyqlmp1cg','MSthccR_RluF1FCQc4XBSA','logi-2201FDJXQYW2','2201FDJXQYW2',NULL,'P-NL-3FL-S.Boulogne','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.14.371','P-NL-3FL-S.Boulogne','Logitech','Tap IP','1.14.371','6.3.5 (3287)','10.64.2.43','44:73:D6:B8:47:8A',NULL,'2025-07-15 02:27:55','2025-11-25 04:02:35','NL','Floor1','Building1'),(48,970,39,'2kRqVAbNTxO0Gcyqlmp1cg','MSthccR_RluF1FCQc4XBSA','logi-2142FDZ6GZ72','2142FDZ6GZ72',NULL,'P-NL-3FL-S.Boulogne','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.14.377','P-NL-3FL-S.Boulogne Logitech VR0020','Logitech','Rally Bar Mini','1.14.377','6.3.10 (6410)','10.64.2.45','44:73:D6:A2:C1:B7',NULL,'2025-07-15 02:27:55','2025-11-25 04:02:35','NL','Floor1','Building1'),(49,971,40,'2kRqVAbNTxO0Gcyqlmp1cg','bkOSH8DVRqOJIfP8nYSG4g','logi-2201FDJXR482','2201FDJXR482',NULL,'P-NL-4FL-A.Korolenko','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.14.181','P-NL-4FL-A.Korolenko','Logitech','Tap IP','1.14.181','6.3.5 (3287)','10.64.2.10','44:73:D6:B9:69:B8',NULL,'2025-07-15 02:28:01','2025-12-10 04:08:34','NL','Floor1','Building1'),(50,972,40,'2kRqVAbNTxO0Gcyqlmp1cg','bkOSH8DVRqOJIfP8nYSG4g','logi-2150FDZ9PJQ2','2150FDZ9PJQ2',NULL,'P-NL-4FL-A.Korolenko','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.14.180','P-NL-4FL-A.Korolenko Logitech VR0020','Logitech','Rally Bar Mini','1.14.180','6.3.5 (6258)','10.64.2.11','44:73:D6:B4:50:77',NULL,'2025-07-15 02:28:01','2025-12-10 04:08:34','NL','Floor1','Building1'),(51,973,41,'2kRqVAbNTxO0Gcyqlmp1cg','AyBlFCIMThOCjyDlRB0RBw','logi-2201FDJXRN32','2201FDJXRN32',NULL,'P-NL-4FL-AV','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.12.184','P-NL-4FL-AV','Logitech','Tap IP','1.12.184','6.0.6 (2750)','10.64.2.7','44:73:D6:B9:6A:AE',NULL,'2025-07-15 02:28:06','2025-11-21 04:02:47','NL','Floor1','Building1'),(52,974,41,'2kRqVAbNTxO0Gcyqlmp1cg','AyBlFCIMThOCjyDlRB0RBw','logi-2148FDZ94AA2','2148FDZ94AA2',NULL,'P-NL-4FL-AV','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.12.264','P-NL-4FL-AV Logitech VR0020','Logitech','Rally Bar Mini','1.12.264','6.0.6 (4892)','10.64.2.15','44:73:D6:B4:50:68',NULL,'2025-07-15 02:28:06','2025-11-21 04:02:47','NL','Floor1','Building1'),(53,975,42,'2kRqVAbNTxO0Gcyqlmp1cg','Qm91MO4BSTaEDzHHXmXJvg','logi-2213FDJXL0M2','2213FDJXL0M2',NULL,'P-NL-4FL-D.Shtan','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.14.181','P-NL-4FL-D.Shtan','Logitech','Tap IP','1.14.181','6.3.5 (3287)','10.64.2.9','44:73:D6:B9:64:ED',NULL,'2025-07-15 02:28:12','2025-12-09 04:08:46','NL','Floor1','Building1'),(54,976,42,'2kRqVAbNTxO0Gcyqlmp1cg','Qm91MO4BSTaEDzHHXmXJvg','logi-2143FDZ6VFP2','2143FDZ6VFP2',NULL,'P-NL-4FL-D.Shtan','AMS','NL/AMS/Tribes','Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.14.180','P-NL-4FL-D.Shtan Logitech VR0020','Logitech','Rally Bar Mini','1.14.180','6.3.5 (6258)','10.64.2.8','44:73:D6:B3:E2:8E',NULL,'2025-07-15 02:28:12','2025-12-09 04:08:46','NL','Floor1','Building1'),(55,NULL,43,'2kRqVAbNTxO0Gcyqlmp1cg','rWsi62dfRZGtE-Mh1rzNrg','opxXFdwwly0VOQRR/9Xo34yQ8LgMvhQTTl6OOY1JF74=','GL6CFY7HV2',NULL,'P-NL-PORTABLE','AMS','NL/AMS/Tribes','Offline',NULL,NULL,NULL,NULL,NULL,NULL,'Offline','Zoom Rooms Computer','Mac 15.1.1','Events’s Mac mini',NULL,'Mac14,3',NULL,'6.5.1 (9801)','10.64.112.197','',NULL,'2025-07-15 02:28:17','2025-11-05 04:02:59','NL','Floor1','Building1'),(56,977,43,'2kRqVAbNTxO0Gcyqlmp1cg','rWsi62dfRZGtE-Mh1rzNrg','logi-2201FDJXS1F2','2201FDJXS1F2',NULL,'P-NL-PORTABLE','AMS','NL/AMS/Tribes','Offline',NULL,NULL,NULL,NULL,NULL,NULL,'Offline','Controller','Android 1.15.132','P-NL-PORTABLE','Logitech','Tap IP','1.15.132','6.5.1 (3862)','10.64.112.199','44:73:D6:B8:46:3A',NULL,'2025-07-15 02:28:17','2025-11-05 04:02:59','NL','Floor1','Building1'),(57,1020,18,'m3KGplV_TwCfV1ts5-3-Lg','ES9WIwYlS86w7etiEvx_qg','logi-2450FDN04HA2','2450FDN04HA2',NULL,'MR-FI-2FL-Hirvihaara','MAN',NULL,'Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.15.132','MR-FI-2FL-Hirvihaara','Logitech','Tap IP','1.15.132','6.5.1 (3862)','2A13:5947:102:5:A930:5C4D:A7D6:50DD','94:02:30:13:BA:25',NULL,'2025-10-04 04:00:22','2025-11-05 04:00:25','FI','Floor1','Building1'),(58,1021,18,'m3KGplV_TwCfV1ts5-3-Lg','ES9WIwYlS86w7etiEvx_qg','logi-2450FD302CK2','2450FD302CK2',NULL,'MR-FI-2FL-Hirvihaara','MAN',NULL,'Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.15.165','MR-FI-2FL-Hirvihaara Logitech VR0019','Logitech','Rally Bar','1.15.165','6.5.1 (7441)','10.64.50.9','94:02:30:0C:0F:15',NULL,'2025-10-04 04:00:22','2025-11-30 04:00:40','FI','Floor1','Building1'),(59,1022,45,'2kRqVAbNTxO0Gcyqlmp1cg','WvvlGaRsQvq6SqT2T_Sciw','logi-2201FDJXRGB2','2201FDJXRGB2',NULL,'P-NL-3FL-N.Harst','AMS',NULL,'Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Controller','Android 1.15.132','P-NL-3FL-N.Harst','Logitech','Tap IP','1.15.132','6.5.1 (3862)','10.64.2.50','44:73:D6:B8:46:4C',NULL,'2025-10-14 04:02:17','2025-12-04 04:08:22','NL','Floor1','Building1'),(60,1023,45,'2kRqVAbNTxO0Gcyqlmp1cg','WvvlGaRsQvq6SqT2T_Sciw','logi-2150FDAWA752','2150FDAWA752',NULL,'P-NL-3FL-N.Harst','AMS',NULL,'Online',NULL,NULL,NULL,NULL,NULL,NULL,'Available','Zoom Rooms Computer','Android 1.15.165','P-NL-3FL-N.Harst Logitech VR0019','Logitech','Rally Bar','1.15.165','6.5.1 (7441)','10.64.2.51','44:73:D6:AF:AD:3A',NULL,'2025-10-14 04:02:17','2025-12-04 04:08:22','NL','Floor1','Building1'),(61,1024,46,'m3KGplV_TwCfV1ts5-3-Lg','XexMqcLwTDOcUYEsqAHdjA','logi-2451FDH01LV2','2451FDH01LV2',NULL,'MR-FI-2FL-Kapina','MAN',NULL,'Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Controller','Android 1.15.132','MR-FI-2FL-Kapina','Logitech','Tap IP','1.15.132','6.5.1 (3862)','2A13:5947:102:5:9C3:3866:4D9D:1240','94:02:30:13:BE:C3',NULL,'2025-10-17 04:00:28','2025-12-10 04:06:22','FI','Floor1','Building1'),(62,1025,46,'m3KGplV_TwCfV1ts5-3-Lg','XexMqcLwTDOcUYEsqAHdjA','logi-2451FD504YB2','2451FD504YB2',NULL,'MR-FI-2FL-Kapina','MAN',NULL,'Online',NULL,NULL,NULL,NULL,NULL,NULL,'InMeeting','Zoom Rooms Computer','Android 1.15.165','MR-FI-2FL-Kapina Logitech VR0020','Logitech','Rally Bar Mini','1.15.165','6.5.1 (7441)','10.64.50.12','94:02:30:0C:AA:BA',NULL,'2025-10-17 04:00:29','2025-12-10 04:06:22','FI','Floor1','Building1');

--
-- Table structure for table `zoom_location_mappings`
--

CREATE TABLE `zoom_location_mappings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `calendar_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `zoom_location_mappings`
--


--
-- Table structure for table `zoom_meetings`
--

CREATE TABLE `zoom_meetings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `zoom_meeting_id` bigint unsigned NOT NULL,
  `host_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `topic` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` tinyint DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `duration` bigint unsigned DEFAULT NULL,
  `timezone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meeting_created_at` datetime DEFAULT NULL,
  `join_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `zoom_meetings`
--


--
-- Table structure for table `zoom_members`
--

CREATE TABLE `zoom_members` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint DEFAULT NULL,
  `zoom_user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified` tinyint(1) DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `joined_on` datetime DEFAULT NULL,
  `role` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `zoom_members`
--



