-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 13-11-2023 a las 06:02:00
-- Versión del servidor: 10.5.20-MariaDB-cll-lve-log
-- Versión de PHP: 7.4.27

START TRANSACTION;



--
-- Base de datos: `themskxg_parkbyplate`
--

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

--
-- Estructura de tabla para la tabla `communities`
--

CREATE TABLE `communities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `type` varchar(191) DEFAULT NULL,
  `community_name` varchar(191) DEFAULT NULL,
  `management_company` varchar(191) DEFAULT NULL,
  `location` varchar(191) DEFAULT NULL,
  `contact_person` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `resident_spaces` varchar(191) DEFAULT NULL,
  `number_of_visitor_spaces` varchar(191) DEFAULT NULL,
  `bank_account_number` varchar(191) DEFAULT NULL,
  `routing_number` varchar(191) DEFAULT NULL,
  `lat` varchar(191) DEFAULT NULL,
  `lang` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `price_name` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `communities`
--

INSERT INTO `communities` (`id`, `user_id`, `type`, `community_name`, `management_company`, `location`, `contact_person`, `email`, `resident_spaces`, `number_of_visitor_spaces`, `bank_account_number`, `routing_number`, `lat`, `lang`, `status`, `price_name`, `created_at`, `updated_at`) VALUES
(1, 1, 'House', 'aas updated', 'asdasd', 'Islamabad, Islamabad Capital Territory, Pakistan', 'Mian Roshan', 'abidabad786@gmail.com', '232', '23', '234234', '23', '33.6844202', '73.04788479999999', 1, NULL, '2023-11-06 15:52:13', '2023-11-08 17:32:56'),
(2, 1, 'House', 'Zubair Lara', 'Management Company', 'Test Location', 'Test Contact Person', 'test@gmail.com', 'test', 'test', '123456', '123456', '32.163827', '74.189673', 1, NULL, '2023-11-06 17:08:58', '2023-11-06 17:51:12'),
(6, 1, 'House', 'aas', 'asdasd', 'Cali, Valle del Cauca, Colombia', 'Mian Roshan(testing account)', 'abidabad786@gmail.com', '232', '23', '234234', '23', '3.4516467', '-76.5319854', 1, NULL, '2023-11-07 01:50:21', '2023-11-07 01:50:21'),
(5, 1, 'House', 'comunita', 'asdasd', 'Atlanta, GA, USA', 'Mian Roshan(testing account)', 'abidabad786@gmail.com', '232', '23', '234234', '23', '33.748752', '-84.38768449999999', 0, NULL, '2023-11-06 18:27:00', '2023-11-07 01:51:24'),
(7, 1, 'Appartment', 'aas', 'asdasd', 'Mexico City, CDMX, Mexico', 'Mian Roshan(testing account)', 'abidabad786@gmail.com', '32`', '343', '343343344344', '343343', '19.4326077', '-99.133208', 0, NULL, '2023-11-07 01:52:08', '2023-11-07 01:52:08'),
(8, 1, 'Office', 'asda', 'asdasd', 'Cádiz, Spain', 'Mian Roshan(testing account)', 'abidabad786@gmail.com', '232', '2', '3423423422wd2', '232', '36.5210142', '-6.2804565', 1, NULL, '2023-11-07 01:52:58', '2023-11-07 01:52:58'),
(9, 1, 'Others', 'test', 'test', '23936 Testorf-Steinfort, Germany', 'test', 'test@gmail.com', '20', '10', '7821738723', '837', '53.7806491', '11.26495', 0, NULL, '2023-11-08 11:01:40', '2023-11-08 11:01:40'),
(10, 1, 'House', 'Test Community 3', 'Management Company', 'Test Location', 'Test Contact Person', 'test@gmail.com', 'test', 'test', '123456', '123456', '32.163827', '74.189673', 1, NULL, '2023-11-08 12:37:00', '2023-11-08 12:37:00');

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

--
-- Estructura de tabla para la tabla `community_pricings`
--

CREATE TABLE `community_pricings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `community_id` bigint(20) UNSIGNED NOT NULL,
  `hours` varchar(191) DEFAULT NULL,
  `price` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `community_pricings`
--

INSERT INTO `community_pricings` (`id`, `community_id`, `hours`, `price`, `created_at`, `updated_at`) VALUES
(66, 1, '43', '453', '2023-11-08 17:32:56', '2023-11-08 17:32:56'),
(65, 1, '2', '45', '2023-11-08 17:32:56', '2023-11-08 17:32:56'),
(24, 2, '2', '10', '2023-11-06 17:51:12', '2023-11-06 17:51:12'),
(23, 2, '3', '5', '2023-11-06 17:51:12', '2023-11-06 17:51:12'),
(26, 3, '3', '5', '2023-11-06 18:01:44', '2023-11-06 18:01:44'),
(25, 3, '2', '10', '2023-11-06 18:01:44', '2023-11-06 18:01:44'),
(7, 4, '2', '10', '2023-11-06 17:09:11', '2023-11-06 17:09:11'),
(8, 4, '3', '5', '2023-11-06 17:09:11', '2023-11-06 17:09:11'),
(64, 1, '2', '34', '2023-11-08 17:32:56', '2023-11-08 17:32:56'),
(52, 5, '43', '3443', '2023-11-07 01:51:24', '2023-11-07 01:51:24'),
(51, 5, '23', '45', '2023-11-07 01:51:24', '2023-11-07 01:51:24'),
(50, 6, '2', '3', '2023-11-07 01:50:21', '2023-11-07 01:50:21'),
(53, 7, '2', '45', '2023-11-07 01:52:08', '2023-11-07 01:52:08'),
(54, 8, '33', '234', '2023-11-07 01:52:58', '2023-11-07 01:52:58'),
(58, 9, '1', '10', '2023-11-08 11:01:40', '2023-11-08 11:01:40'),
(62, 10, '2', '10', '2023-11-08 12:37:00', '2023-11-08 12:37:00'),
(63, 10, '3', '5', '2023-11-08 12:37:00', '2023-11-08 12:37:00');

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

--
-- Estructura de tabla para la tabla `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(191) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `locations`
--

CREATE TABLE `locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `type` varchar(191) NOT NULL,
  `address` varchar(191) NOT NULL,
  `notes` text DEFAULT NULL,
  `price` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0: inactive, 1:active'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `migrations`
--

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

--
-- Volcado de datos para la tabla `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, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(4, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(5, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(6, '2016_06_01_000004_create_oauth_clients_table', 1),
(7, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(8, '2019_08_19_000000_create_failed_jobs_table', 1),
(9, '2023_10_23_085005_create_permission_tables', 1),
(10, '2023_10_23_110904_create_locations_table', 1),
(11, '2023_10_23_171329_add_status_to_locations_table', 1),
(12, '2023_10_23_173519_add_telephone_to_users_table', 1),
(13, '2023_10_24_161241_create_parkings_table', 1),
(14, '2023_10_24_162515_add_social_columns_to_users_table', 1),
(15, '2023_10_24_181624_add_price_to_parking_table', 1),
(16, '2023_10_31_155158_add_status_to_users_table', 1),
(17, '2023_10_31_164543_create_communities_table', 1),
(18, '2023_10_31_172844_create_community_pricings_table', 1),
(19, '2023_11_01_100006_add_otp_to_users_table', 2),
(20, '2023_11_01_130123_add_community_to_users_table', 3),
(21, '2023_11_02_092639_add_profile_to_users_table', 4),
(22, '2023_11_02_095706_add_self_update_to_users_table', 5),
(23, '2023_11_06_181535_add_company_name_to_users_table', 6),
(24, '2023_11_07_082103_add_customer_id_to_users_table', 7),
(25, '2023_11_07_091310_add_ephemeral_key_to_users_table', 7),
(26, '2023_11_07_094438_add_stripe_to_parkings_table', 7),
(27, '2023_11_07_114355_add_intent_secret_to_parkings_table', 8),
(28, '2023_11_07_201818_create_user_communities_table', 9),
(29, '0000_00_00_000000_create_websockets_statistics_entries_table', 10),
(30, '2023_11_09_150951_add_spent_time_to_parkings_table', 10);

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

--
-- Estructura de tabla para la tabla `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(191) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(191) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 2),
(1, 'App\\Models\\User', 4),
(1, 'App\\Models\\User', 5),
(1, 'App\\Models\\User', 6),
(1, 'App\\Models\\User', 7),
(1, 'App\\Models\\User', 27),
(1, 'App\\Models\\User', 28),
(1, 'App\\Models\\User', 29),
(1, 'App\\Models\\User', 30),
(1, 'App\\Models\\User', 31),
(2, 'App\\Models\\User', 16),
(2, 'App\\Models\\User', 23),
(2, 'App\\Models\\User', 24),
(2, 'App\\Models\\User', 25),
(2, 'App\\Models\\User', 26),
(4, 'App\\Models\\User', 1);

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

--
-- Estructura de tabla para la tabla `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
('4dfad08df192eaba64b97a7789f745ef3a861aee243e152334584af112f7ea79194b52805fec2b40', 1, 1, 'passport', '[]', 0, '2023-11-01 15:40:29', '2023-11-01 15:40:29', '2024-11-01 11:40:29'),
('b9c69aeb7144c7f641882daf4c967f2006dad7585362e3ce6f1e55a44f639feb715048782af9afa4', 1, 1, 'passport', '[]', 0, '2023-11-01 15:42:00', '2023-11-01 15:42:00', '2024-11-01 11:42:00'),
('b7f4e4f36ebeadafb10fb4805ef8df39844684777973bd3f89af3ad154896060202094a1b2b76c69', 1, 1, 'passport', '[]', 0, '2023-11-01 17:44:39', '2023-11-01 17:44:39', '2024-11-01 13:44:39'),
('b1a2029504d00b03ee5202469cd0bce007e182430e94889113b9e220c88030bda4476ac318f846a5', 2, 1, 'passport', '[]', 0, '2023-11-01 18:12:52', '2023-11-01 18:12:52', '2024-11-01 14:12:52'),
('f29d666e5508657f68ecc78bb86a3a3a877ea8fdebef556fd263f4690f1d426674e552592c7e7c82', 2, 1, 'passport', '[]', 0, '2023-11-02 12:33:29', '2023-11-02 12:33:29', '2024-11-02 08:33:29'),
('e6f8353e5a191ae9c341bf62e5f4a576d1c4aba5a49cf4672f45449612ff60e4f2f0e62c06e88dc1', 2, 1, 'passport', '[]', 0, '2023-11-02 12:55:09', '2023-11-02 12:55:09', '2024-11-02 08:55:09'),
('3583c0cfac09a305f798c4ed75efdd1cd33fcc8f47449376a4f5781c24d0b7d5770cfbf765eabc36', 2, 1, 'passport', '[]', 0, '2023-11-02 12:57:37', '2023-11-02 12:57:37', '2024-11-02 08:57:37'),
('5f9029541b5148eb14ab846ba0b0c468f3dbf2f4340d2e36f1e034fe2eca9aa7682fab92fded95ff', 2, 1, 'passport', '[]', 0, '2023-11-02 12:58:19', '2023-11-02 12:58:19', '2024-11-02 08:58:19'),
('ad94092c89ffe8335c0f769f72605f2700b940e9026c7d530c5927aeb1430d1f5c2050277e75d5a2', 4, 1, 'passport', '[]', 0, '2023-11-02 13:23:24', '2023-11-02 13:23:24', '2024-11-02 09:23:24'),
('9367b943e03944de9998e7077959134ba6ba8953f23b03261f74e10d0fed809c29fcb81381e536dc', 4, 1, 'passport', '[]', 0, '2023-11-02 13:24:46', '2023-11-02 13:24:46', '2024-11-02 09:24:46'),
('e972b3b6fd6034511386a7555d9930f0c21fd8c6088fd6826c518769e259d6d136901340ae7a93c0', 2, 1, 'passport', '[]', 0, '2023-11-02 13:37:29', '2023-11-02 13:37:29', '2024-11-02 09:37:29'),
('f830e8730cabeb57bde629fa1928dedf7ec3f381a71b0879b847d2d978d9291f2d20eb5f2c37e00d', 2, 1, 'passport', '[]', 0, '2023-11-02 13:38:46', '2023-11-02 13:38:46', '2024-11-02 09:38:46'),
('a81ddce671e77d4e704efa0f6255652107c604d7fb2e423a034fe96500dbaa5e57947c68908f055c', 2, 1, 'passport', '[]', 0, '2023-11-02 13:48:54', '2023-11-02 13:48:54', '2024-11-02 09:48:54'),
('9ba3f09237bbf176418136623b8a4eba9279d506e382f367a0283b91a20db619045ccffef101d1d4', 2, 1, 'passport', '[]', 0, '2023-11-02 13:49:23', '2023-11-02 13:49:23', '2024-11-02 09:49:23'),
('77ecf354b7d318271ebc61368160a276be6b06a0cd4f73f4c9306232438334ee243ce64b7b6cd3ee', 6, 1, 'passport', '[]', 0, '2023-11-02 13:49:47', '2023-11-02 13:49:47', '2024-11-02 09:49:47'),
('2466a29217293d6e2504171bc35f352fbb904ce93d7fece2f9994c143f0c327dea5ef8dc0fb9b2e8', 7, 1, 'passport', '[]', 0, '2023-11-02 13:51:33', '2023-11-02 13:51:33', '2024-11-02 09:51:33'),
('d0dd4bb751671bacf91ea1906c60d4231b003f62b871f7beb837c32c45ab6b75f8491f13f2a54306', 7, 1, 'passport', '[]', 0, '2023-11-02 14:05:39', '2023-11-02 14:05:39', '2024-11-02 10:05:39'),
('4691643f4fafcb7fde3da3267671ab067eb3584f5503be023787aae9f69a68108a0236853fce45e1', 4, 1, 'passport', '[]', 0, '2023-11-02 14:37:43', '2023-11-02 14:37:43', '2024-11-02 10:37:43'),
('f6b29f4efd6356bd90b11fda088acfb65e60f7bd988620a4c159a8188fb29b39d78ee2e969e3a4e0', 4, 1, 'passport', '[]', 0, '2023-11-02 14:39:37', '2023-11-02 14:39:37', '2024-11-02 10:39:37'),
('6bf734ab509d1f0841e7887b64f76acbffd6e46a6596603bfb37551384fe35b0c9d6a150350e2b63', 1, 1, 'passport', '[]', 0, '2023-11-03 09:35:18', '2023-11-03 09:35:18', '2024-11-03 05:35:18'),
('598347aa30a7d4dbed06848aea1658db684c31b6f68cc88eb8fd9453196c0be092bca7ffd84401c6', 1, 1, 'passport', '[]', 0, '2023-11-03 16:19:43', '2023-11-03 16:19:43', '2024-11-03 12:19:43'),
('b93a588fd262f16d0051c91c6d8b75236c3ea7f4e892b47b60606fadf528bdc25dac889161179265', 1, 1, 'passport', '[]', 0, '2023-11-03 22:12:22', '2023-11-03 22:12:22', '2024-11-03 18:12:22'),
('3db4df4c620924d80eb38b82fde1f3880a5fde1a82ea6dd910298279b7a22fe06f77fae336c774d8', 1, 1, 'passport', '[]', 0, '2023-11-06 10:32:05', '2023-11-06 10:32:05', '2024-11-06 05:32:05'),
('96b8dbebf6b192ffe7a7812f7950ebdfa7fce4b2921a7f43974e0b94e8160fe65e58a2aa2ee2f71e', 1, 1, 'passport', '[]', 0, '2023-11-06 10:36:20', '2023-11-06 10:36:20', '2024-11-06 05:36:20'),
('03ad624618d4358e5adb7f7115f1746226e943fd15285a2bfee52065713c0126de5a9d95dcb21255', 7, 1, 'passport', '[]', 0, '2023-11-06 10:56:09', '2023-11-06 10:56:09', '2024-11-06 05:56:09'),
('5ee73d2b0e6d366ac434e22ad8d80f24499ec3216f50d292d916d68f319a936a7f1581fc23d85229', 7, 1, 'passport', '[]', 0, '2023-11-06 10:59:31', '2023-11-06 10:59:31', '2024-11-06 05:59:31'),
('c8101b1dcfb3699f6cd34ed61d24bcbaee483b389ca71f27e223e80c1c4ffb373d2c655ddbcd96be', 7, 1, 'passport', '[]', 0, '2023-11-06 11:00:20', '2023-11-06 11:00:20', '2024-11-06 06:00:20'),
('f00f046d2e01e4e07cd993cf98272ceb9c9af23c868b2e8783d113a52fbb6ccce618c43ea473faec', 7, 1, 'passport', '[]', 0, '2023-11-06 11:04:40', '2023-11-06 11:04:40', '2024-11-06 06:04:40'),
('90ff522860d54c401d8aa1b1129a7f7c2ebabdc76444a1dadf4fc9c9a862e1d5f9d7d80ccefb23e1', 4, 1, 'passport', '[]', 0, '2023-11-06 12:58:46', '2023-11-06 12:58:46', '2024-11-06 07:58:46'),
('673d6e1fd4c41d9d31c88e1ef8326e05c2301e19b701546cc9f398c37e75ee2bf75def2f7d506549', 4, 1, 'passport', '[]', 0, '2023-11-06 12:59:05', '2023-11-06 12:59:05', '2024-11-06 07:59:05'),
('11cef32052d5c6d4b41f2045ba9b1378475720e56ee60b89ae739149ddfc8d0af88b2a8cee22dbab', 4, 1, 'passport', '[]', 0, '2023-11-06 13:13:59', '2023-11-06 13:13:59', '2024-11-06 08:13:59'),
('178b01e8d4d5f127d6e21ee3d807ac22145c4ef7200a729576f9d9de024bda02a5932393bf6ce6df', 4, 1, 'passport', '[]', 0, '2023-11-06 13:14:52', '2023-11-06 13:14:52', '2024-11-06 08:14:52'),
('92f40a459bdf491b4ba1dde465064968337cd9f0fa23b0ceefd305a79b9260a35b648e8bfd35cde6', 4, 1, 'passport', '[]', 0, '2023-11-06 13:15:25', '2023-11-06 13:15:25', '2024-11-06 08:15:25'),
('cb8366cf67859a84d05458cb345e1cf3d98b04bd40b6c1f10e1d4abfc2fcdc2c1398cebcf85975ca', 4, 1, 'passport', '[]', 0, '2023-11-06 13:18:18', '2023-11-06 13:18:18', '2024-11-06 08:18:18'),
('6ffcdd65eb0ba8d20ec9eb0001206e98c4bb934ca57c7c17efa0372944da5fa6f04437ac48bfa550', 7, 1, 'passport', '[]', 0, '2023-11-06 13:25:39', '2023-11-06 13:25:39', '2024-11-06 08:25:39'),
('bf86ed9ca0c88436b0bd34ed62caead85e7d553292ec1c6e1c63557f849274dcd3c24681a5f662e2', 1, 1, 'passport', '[]', 0, '2023-11-06 13:56:17', '2023-11-06 13:56:17', '2024-11-06 08:56:17'),
('fa013c4d1230fc99e7ef501374413ffa049e7c009dfd00395edcc2872447bce26772d29f51fba398', 4, 1, 'passport', '[]', 0, '2023-11-06 14:25:23', '2023-11-06 14:25:23', '2024-11-06 09:25:23'),
('ca4175e504ee7b5ee03126afca7510670e32041106d1ff9d831c45ac6579dff512d61afdc7287498', 1, 1, 'passport', '[]', 0, '2023-11-06 14:25:45', '2023-11-06 14:25:45', '2024-11-06 09:25:45'),
('2b0f0186eeb475d43ea51c1b83358427ecb2673d8152de1411abc0d1cfcdea8b2ce7cb98b79289be', 7, 1, 'passport', '[]', 0, '2023-11-06 15:37:02', '2023-11-06 15:37:02', '2024-11-06 10:37:02'),
('4bbd1041cda5f8fbac5dc81a8e3a6a5f507cb11da8ba41faf02487972ebf2ddbff0a7588d9d37bd8', 7, 1, 'passport', '[]', 0, '2023-11-06 15:37:28', '2023-11-06 15:37:28', '2024-11-06 10:37:28'),
('bc580f79eca992828990f16390ad62e25d9f7ca95b6baf07a3df2a088db4fbf4fe410ac760522c82', 7, 1, 'passport', '[]', 0, '2023-11-06 15:37:43', '2023-11-06 15:37:43', '2024-11-06 10:37:43'),
('e5a72550c6fdbd8edf894eee796c43ca26d5e9b355597bc9c10a1589e1381551b5a2bbbea7390fe3', 1, 1, 'passport', '[]', 0, '2023-11-06 15:40:46', '2023-11-06 15:40:46', '2024-11-06 10:40:46'),
('4b140af8d31750ceecfd0122c26afc38c67f0b5fa7cd1dd9997806dbcfaaf010d72389171bd8e7f2', 1, 1, 'passport', '[]', 0, '2023-11-06 16:48:03', '2023-11-06 16:48:03', '2024-11-06 11:48:03'),
('fddcf4c1bc728d3ed67f670b19e375e3d49b2310015c27e9d4d073daf2e2f456a691bc7798e6022e', 1, 1, 'passport', '[]', 0, '2023-11-06 17:08:43', '2023-11-06 17:08:43', '2024-11-06 12:08:43'),
('b4ee0d0c7da26064866c7f104dc6c7988b70af5973fce765071449cee1d68c279c35d9cbd674164f', 7, 1, 'passport', '[]', 0, '2023-11-06 18:28:22', '2023-11-06 18:28:22', '2024-11-06 13:28:22'),
('67c3f3144532f28fa14a281454ba55419a607a3e1612c2315b210c4b8337b2c6f1dd29bde17ad72a', 7, 1, 'passport', '[]', 0, '2023-11-06 18:28:51', '2023-11-06 18:28:51', '2024-11-06 13:28:51'),
('f4291f799c48980bf5e96329af1621a0b8c9a8f2e4b976634af2877376fef0de4ce8b4829724c14a', 1, 1, 'passport', '[]', 0, '2023-11-06 19:14:36', '2023-11-06 19:14:36', '2024-11-06 14:14:36'),
('2421018c79fbd64f5874effc77416082f90320e8f803c71bff1ffba279322014d7915998da9ca923', 1, 1, 'passport', '[]', 0, '2023-11-06 22:21:26', '2023-11-06 22:21:26', '2024-11-06 17:21:26'),
('0cb575424e641185270a5f711f3ce6752ad6eb41986bf92fc7f2572842ecd0a6e16004f7ccdf32a8', 1, 1, 'passport', '[]', 0, '2023-11-06 22:33:23', '2023-11-06 22:33:23', '2024-11-06 17:33:23'),
('03260343986704f591bf6aac276512074a834c7fcfb0687a837f7eccc16f372dbc86d6d979ba2c0d', 1, 1, 'passport', '[]', 0, '2023-11-07 02:07:58', '2023-11-07 02:07:58', '2024-11-06 21:07:58'),
('5aef73f0ebd58e404c454de8107b4e8f84c0e751490c785004b13aa2845091e97cb0c592aedba975', 1, 1, 'passport', '[]', 0, '2023-11-07 02:12:08', '2023-11-07 02:12:08', '2024-11-06 21:12:08'),
('f5a839b573aa19db12d12393408aff97a54d9917b9acf0a11132685ba7aad93081dd3a7dd8448c38', 1, 1, 'passport', '[]', 0, '2023-11-07 06:25:11', '2023-11-07 06:25:11', '2024-11-07 01:25:11'),
('b9e97946b648c0c0689641100db34c3729a68b1fa8e725d2babcd685c884279a5fddd9f64663d423', 1, 1, 'passport', '[]', 0, '2023-11-07 10:36:21', '2023-11-07 10:36:21', '2024-11-07 05:36:21'),
('92e69557810454270febada30266741343450ebd10e8183bdb8c3bcf718a38c5f052455eb527f4d0', 1, 1, 'passport', '[]', 0, '2023-11-07 10:45:32', '2023-11-07 10:45:32', '2024-11-07 05:45:32'),
('12dcdd74def908d42f65a158ba5cdf808c261e3f38cc5a0881047c376b63ccec15bc88944138839d', 1, 1, 'passport', '[]', 0, '2023-11-07 10:46:32', '2023-11-07 10:46:32', '2024-11-07 05:46:32'),
('6d9a0ca48ba55e38c0b8b902905fab0fa72db6078cfc7e95798154dd623012434c035bb41b61da29', 4, 1, 'passport', '[]', 0, '2023-11-07 15:16:43', '2023-11-07 15:16:43', '2024-11-07 10:16:43'),
('7cba00f7f2b78c4ceb20a9993ed8e53c752d2ac885ca1bb6ae4e567afea0d6f70b748a04ced56343', 1, 1, 'passport', '[]', 0, '2023-11-07 20:13:32', '2023-11-07 20:13:32', '2024-11-07 15:13:32'),
('581c1cedb4f4b4e880f46cedf84b4972c8f4968719821949a8b1c3e7c9c1d40d9081eb40882a478f', 16, 1, 'passport', '[]', 0, '2023-11-07 20:17:31', '2023-11-07 20:17:31', '2024-11-07 15:17:31'),
('9f8ebe5e3e34707c4dedf4e547c067545ca860e28af2800261ac4e88521f1e8513c7c7c995291015', 1, 1, 'passport', '[]', 0, '2023-11-07 22:08:28', '2023-11-07 22:08:28', '2024-11-07 17:08:28'),
('1016da88a5c93c354e5b154ec7595b8dacdff738cf6521c116c587a25962ee0d8eaed692aa94190d', 1, 1, 'passport', '[]', 0, '2023-11-08 00:36:39', '2023-11-08 00:36:39', '2024-11-07 19:36:39'),
('d1a6c770def344d45bb2226b65b68d25698e2441cb507bf83e6b57dddfeb23d1cc71c617e70fbf14', 4, 1, 'passport', '[]', 0, '2023-11-08 01:58:04', '2023-11-08 01:58:04', '2024-11-07 20:58:04'),
('4c08e7ff6fef62b952493f2cc97eb58a55c2f5c0ce3ad8c2ef4ba5120b2f783162c64dfe2fd51187', 1, 1, 'passport', '[]', 0, '2023-11-08 01:58:16', '2023-11-08 01:58:16', '2024-11-07 20:58:16'),
('eaa758091ee9508506a01b12af1031836c735372d9109a8698b351540167b08fadfc7940139736a6', 4, 1, 'passport', '[]', 0, '2023-11-08 02:20:30', '2023-11-08 02:20:30', '2024-11-07 21:20:30'),
('d711ad959107ed25348715ceb3a51baf3fbc1b1596ae4c3f17bd4c94847d2be3a9f346fee8c6757d', 1, 1, 'passport', '[]', 0, '2023-11-08 10:46:02', '2023-11-08 10:46:02', '2024-11-08 05:46:02'),
('e7988d363bab907fb412d52a6cbbe204e8ba4b4b945e8b13914745c1b39964762434a0cff07d957e', 1, 1, 'passport', '[]', 0, '2023-11-08 10:47:47', '2023-11-08 10:47:47', '2024-11-08 05:47:47'),
('f97a2e68c740604fe84f906f9fecf707b8e362b7c512563788c53187982d2ec375e610a04f506b77', 1, 1, 'passport', '[]', 0, '2023-11-08 10:53:11', '2023-11-08 10:53:11', '2024-11-08 05:53:11'),
('a2b74bce3cf84a352c35aefd1415889ad3fd04e14f93a8012f6025158d3d58cf4a2e9ef450119bbb', 1, 1, 'passport', '[]', 0, '2023-11-08 11:18:04', '2023-11-08 11:18:04', '2024-11-08 06:18:04'),
('eb42d78ae8a35c101f74b7d0ff105d32300bfb60b3e278bb3bf35e3a3c58031cc4ff73a6bb2c8255', 1, 1, 'passport', '[]', 0, '2023-11-08 11:19:21', '2023-11-08 11:19:21', '2024-11-08 06:19:21'),
('41f4711fbf96366c089cdf989389b91750a359894e9628866040f9e4fdd46b04b61680b64a462a00', 1, 1, 'passport', '[]', 0, '2023-11-08 11:21:40', '2023-11-08 11:21:40', '2024-11-08 06:21:40'),
('6edd21e98627aeaf7bde5af1c0be6644b0c720d39ec0a3a6a1a214c15b3955baeb2ba93ab3143719', 1, 1, 'passport', '[]', 0, '2023-11-08 11:22:12', '2023-11-08 11:22:12', '2024-11-08 06:22:12'),
('ee4d67ae9069a16bfedb5bea0ec294411d56c4cbc171a2937fa3b4020463c280ce7da9202704f887', 1, 1, 'passport', '[]', 0, '2023-11-08 11:23:13', '2023-11-08 11:23:13', '2024-11-08 06:23:13'),
('02a8d89f6d91327ce1ddcb3b90a4a2666b0f61af7152b76a80ea4b726aa9311c286cdba74a84ca07', 1, 1, 'passport', '[]', 0, '2023-11-08 11:25:36', '2023-11-08 11:25:36', '2024-11-08 06:25:36'),
('ca134363e9b028258710ae818cdcc84f3713a51e06c48f4a42bde203979adb2b01632bcc0bafdcc1', 1, 1, 'passport', '[]', 0, '2023-11-08 11:27:06', '2023-11-08 11:27:06', '2024-11-08 06:27:06'),
('31e623378fc984bb34bf70b402c53ab9aa6cb69cd4c2dadc62913d4200030698d36d8d75b568eb18', 1, 1, 'passport', '[]', 0, '2023-11-08 11:37:27', '2023-11-08 11:37:27', '2024-11-08 06:37:27'),
('31e5b0a7f100afd0fefdb40bfdd3f3a00bd4d37dc94e2671aef4c9cb1131fc599e61082ab6142d4c', 1, 1, 'passport', '[]', 0, '2023-11-08 11:47:22', '2023-11-08 11:47:22', '2024-11-08 06:47:22'),
('7859eb5410aaf230ec408466f9bf44c60e5658617fff7fcd848f56048b0f71009a53155d5bef8755', 1, 1, 'passport', '[]', 0, '2023-11-08 11:50:24', '2023-11-08 11:50:24', '2024-11-08 06:50:24'),
('6fec3a4972f02f664ea40e0ca6dc30fd6a4e6888611af3ad2741fcc038109c344c8ee444909f430a', 1, 1, 'passport', '[]', 0, '2023-11-08 11:54:46', '2023-11-08 11:54:46', '2024-11-08 06:54:46'),
('939af2580ca89fcf25ce6f9784a65c9c566847ef6c3b60c5d8d0bf2a5e0d59866012106a6cc94382', 1, 1, 'passport', '[]', 0, '2023-11-08 11:55:15', '2023-11-08 11:55:15', '2024-11-08 06:55:15'),
('530b0a0871e92144677cc1b8405142d539e239e4383cec0887206c83bef8cabc13bfc75683a1b4cd', 1, 1, 'passport', '[]', 0, '2023-11-08 11:56:43', '2023-11-08 11:56:43', '2024-11-08 06:56:43'),
('6be68c88b94b78ca196f7e00b7030fafd2b7013708a7b0afeb4694780256dc2efba0bab287113545', 1, 1, 'passport', '[]', 0, '2023-11-08 11:58:53', '2023-11-08 11:58:53', '2024-11-08 06:58:53'),
('f74672f04573fb816021aa127536341e8dd2915a9f31f001d154eaba9e58867f7932967f430d5f1e', 1, 1, 'passport', '[]', 0, '2023-11-08 12:04:08', '2023-11-08 12:04:08', '2024-11-08 07:04:08'),
('a773e191b25e803466a56b87e699f6bec020165df7f278b9dd92b8ada442464e8f436c85d4c136c3', 4, 1, 'passport', '[]', 0, '2023-11-08 12:34:17', '2023-11-08 12:34:17', '2024-11-08 07:34:17'),
('86f196acc5fc11adda074c3e90b9065da379d4615ad51948b50e1a033eaa6af90a6b22cac7fbcdea', 7, 1, 'passport', '[]', 0, '2023-11-08 14:19:13', '2023-11-08 14:19:13', '2024-11-08 09:19:13'),
('fe6b5f5fc41474afb653c42907259e9b10a8095fe65d15197f82b1dafef22b65fba2c2b6e8c1c014', 1, 1, 'passport', '[]', 0, '2023-11-08 14:20:49', '2023-11-08 14:20:49', '2024-11-08 09:20:49'),
('84522be1fc9af72ca07c3a2ada30440aeb6361dfb96bb41d3dbbadac43d80d373b7a5e06252330b7', 4, 1, 'passport', '[]', 0, '2023-11-08 14:38:10', '2023-11-08 14:38:10', '2024-11-08 09:38:10'),
('b943eeff46be5a28d001a38258bcb9972d77ed7d76e0daa5b93d366bbc79ac943444c4e42943465b', 4, 1, 'passport', '[]', 0, '2023-11-08 14:40:24', '2023-11-08 14:40:24', '2024-11-08 09:40:24'),
('da0637ee97de51ea6b111bacd9a9d74d19baedcf0a4dc025eb312e2601bc45f374ce6778d28ec857', 1, 1, 'passport', '[]', 0, '2023-11-08 14:46:21', '2023-11-08 14:46:21', '2024-11-08 09:46:21'),
('46ca4d8cab07c0d47e16dc5245be3932d6b66249ffb77cccf09e01212ee630dbf68e9e596dea821e', 1, 1, 'passport', '[]', 0, '2023-11-08 16:46:10', '2023-11-08 16:46:10', '2024-11-08 11:46:10'),
('2b6b42f8c67645cc1b283479d9d537d5962062daa05f316cf162e34964782fc230f92922145c2834', 7, 1, 'passport', '[]', 0, '2023-11-08 16:58:59', '2023-11-08 16:58:59', '2024-11-08 11:58:59'),
('5cd56092df86a33cb69cf56da0c3a2304b7e1602e6b28c495379acfbb2185caa331db0f2836b8c76', 7, 1, 'passport', '[]', 0, '2023-11-08 17:07:07', '2023-11-08 17:07:07', '2024-11-08 12:07:07'),
('7b3ae8ae1d88f72b12b4edebd092b9225c73e2c625dd5b86d946f9196c18a238d73455c5ab8943d0', 1, 1, 'passport', '[]', 0, '2023-11-08 17:10:23', '2023-11-08 17:10:23', '2024-11-08 12:10:23'),
('30ff2e353fe930792887c308ec73d8184f67dd1f7581dfd747edbee456dac7395392f4ed2b06820e', 1, 1, 'passport', '[]', 0, '2023-11-08 18:08:17', '2023-11-08 18:08:17', '2024-11-08 13:08:17'),
('c26d6333a5ce126a1a1f3c08937895a8e93851bf664968876e6b6d25630b6c83f16b8d12cab85c08', 1, 1, 'passport', '[]', 0, '2023-11-08 18:17:18', '2023-11-08 18:17:18', '2024-11-08 13:17:18'),
('6a80ece872de5b1275be3e78fb1f990a2886b116248be16c34441dda6be8c56fc51cd0bf2e310869', 1, 1, 'passport', '[]', 0, '2023-11-08 18:34:43', '2023-11-08 18:34:43', '2024-11-08 13:34:43'),
('3b960deff74fc98d7da28653b769f988399319b1396b586a26a1cd0843c4073aa126ce2908de4002', 1, 1, 'passport', '[]', 0, '2023-11-08 18:38:17', '2023-11-08 18:38:17', '2024-11-08 13:38:17'),
('98ef8f068036f8b83fe70de80573cac7982ae1e12f0e8300cec8e00c7e01018175fb60825dbe06f7', 1, 1, 'passport', '[]', 0, '2023-11-08 18:44:40', '2023-11-08 18:44:40', '2024-11-08 13:44:40'),
('1db48b528579c5c2178b87b238946a85d505356fa6613506faa40753aa23813bc738d6b89c3f96e1', 1, 1, 'passport', '[]', 0, '2023-11-08 18:58:38', '2023-11-08 18:58:38', '2024-11-08 13:58:38'),
('f4916d71b49dabcd29f6d4143ac318e0debdc6884365e2b3c9e44bd220b13d8e86e5403939a98d77', 1, 1, 'passport', '[]', 0, '2023-11-08 19:01:47', '2023-11-08 19:01:47', '2024-11-08 14:01:47'),
('bfc43c007f84887bd5c8e26839d755d86e318aef182cb7c3dd58b81aa36148b6efb9a80aff842600', 26, 1, 'passport', '[]', 0, '2023-11-08 19:09:27', '2023-11-08 19:09:27', '2024-11-08 14:09:27'),
('bb2ba58d9eb7a51ca3f036cb1ce3deb5aecf5b0412feebcc122b3c590b45ba92e1fa168c9b7f0705', 1, 1, 'passport', '[]', 0, '2023-11-08 19:13:01', '2023-11-08 19:13:01', '2024-11-08 14:13:01'),
('4ce7e30f3bc68e41cb61fa8136d02cb5eeeeb35bea11c3a1535193431c0bdc83b7d9c8f72444abee', 1, 1, 'passport', '[]', 0, '2023-11-08 19:22:29', '2023-11-08 19:22:29', '2024-11-08 14:22:29'),
('48210b624b831ed05ea3a8ca6abbd70f8fb30825f1adeb132cbb39eb47d3bbc72e20eb4e4fb05504', 1, 1, 'passport', '[]', 0, '2023-11-08 20:50:30', '2023-11-08 20:50:30', '2024-11-08 15:50:30'),
('968f9414b129d13eb52a8728d230b937356aa9ca87b774a31eba0de5ffcbd5c37317aa8f0c395cea', 1, 1, 'passport', '[]', 0, '2023-11-09 14:04:02', '2023-11-09 14:04:02', '2024-11-09 09:04:02'),
('bb09f83b42d2a4eadeeea65eff23db0aea11ea2e56e391fc25ffd6e8774cbcd5ab02df1193a604c6', 7, 1, 'passport', '[]', 0, '2023-11-09 17:07:26', '2023-11-09 17:07:26', '2024-11-09 12:07:26'),
('0a53f67f8892b37d6da7f41bb8f9d34b58a4e2a202bab4ad1c9451c2c6106232b79aedd01ab434da', 7, 1, 'passport', '[]', 0, '2023-11-09 17:08:30', '2023-11-09 17:08:30', '2024-11-09 12:08:30'),
('b77095a206496d9458156444fae1b4d295c42fad778c895c6590c6e38466e1b25302e02408d8858c', 7, 1, 'passport', '[]', 0, '2023-11-09 17:12:23', '2023-11-09 17:12:23', '2024-11-09 12:12:23'),
('73f60fc403a6c274c2ccf0c83cc79011583da7af21d42af468421a37ee778626ca46f5f2bcfa53f3', 26, 1, 'passport', '[]', 0, '2023-11-09 18:20:05', '2023-11-09 18:20:05', '2024-11-09 13:20:05'),
('90810d416e5652cfc7d26029ec94c78e597769a43a44adb122558e0b435cb8c75e712247482d4c25', 26, 1, 'passport', '[]', 0, '2023-11-09 18:20:31', '2023-11-09 18:20:31', '2024-11-09 13:20:31'),
('fbeb076f4fa0cda4e785b11a10f97a554191a9e1e42a13433dba3b434a9fc030a355aa17bd53ea0d', 27, 1, 'passport', '[]', 0, '2023-11-09 18:39:47', '2023-11-09 18:39:47', '2024-11-09 13:39:47'),
('5c3c1e65edb044c4ba02f087e7a3aa0a519a0a5bee3c15bdd8e3513a68759013397675fd13d8d8ee', 28, 1, 'passport', '[]', 0, '2023-11-09 18:40:52', '2023-11-09 18:40:52', '2024-11-09 13:40:52'),
('f5bd962f583f176efaf037275109d829c0366642be8f9ee68ebda1295db9657aaf366e89a7c599ae', 29, 1, 'passport', '[]', 0, '2023-11-09 18:42:27', '2023-11-09 18:42:27', '2024-11-09 13:42:27'),
('79a2bdfdb2c64045b136ca7248d7462e8bab719b212f2c2c31ac030068c2b7bfd53130c1fe0c6a9f', 28, 1, 'passport', '[]', 0, '2023-11-09 18:46:23', '2023-11-09 18:46:23', '2024-11-09 13:46:23'),
('069c2f6071573a385ac6b4abf441d78cfc28ca3295e9b936bedff56092410bc7b5bed2c5f9ab4004', 27, 1, 'passport', '[]', 0, '2023-11-09 19:28:50', '2023-11-09 19:28:50', '2024-11-09 14:28:50'),
('95e7e18f9db8bdc98684caa6609801a430581399f1035115bdd35d2a8214673a1e5808ee8b988938', 30, 1, 'passport', '[]', 0, '2023-11-09 22:48:59', '2023-11-09 22:48:59', '2024-11-09 17:48:59'),
('1521dde01f1c743588013a8e89831b4034895d8f1105bfbf70902a85ba745d0df33c5b23f7e7e425', 30, 1, 'passport', '[]', 0, '2023-11-10 00:21:19', '2023-11-10 00:21:19', '2024-11-09 19:21:19'),
('ba460490ccc2804236be4895f099b8bd5dc87f1a05cf33419a816ffb1af4318f1ce92282ef4e6a09', 30, 1, 'passport', '[]', 0, '2023-11-10 00:25:55', '2023-11-10 00:25:55', '2024-11-09 19:25:55'),
('bbe973c3c53d04370048d89bf1e297f7fb8564ca7770041d6aeea6e76eee2ff7b7286fc5041f0d2b', 1, 1, 'passport', '[]', 0, '2023-11-10 10:37:57', '2023-11-10 10:37:57', '2024-11-10 05:37:57'),
('e098f73fa35c06b295886c13c966ff3226558dadd8fd403e3310ab88c7a08441249c7b2005f58239', 1, 1, 'passport', '[]', 0, '2023-11-10 10:43:14', '2023-11-10 10:43:14', '2024-11-10 05:43:14'),
('2b68703669b4566058451eeeebdad75dbce39c146786a2ebc30a2560fcc36d8c877481db05af5c59', 1, 1, 'passport', '[]', 0, '2023-11-10 10:51:15', '2023-11-10 10:51:15', '2024-11-10 05:51:15'),
('a5f4e200b9a5fc23a060aeedc1f11badf735736540d2d6f3110d173f89f16fda6fc54307d687f908', 1, 1, 'passport', '[]', 0, '2023-11-10 11:09:16', '2023-11-10 11:09:16', '2024-11-10 06:09:16'),
('ae2485f178a56dd6776d962575208bf3093e783c677e93b28e8d2dcfe5dd4ea2866f5b9abadab3dd', 1, 1, 'passport', '[]', 0, '2023-11-10 11:35:04', '2023-11-10 11:35:04', '2024-11-10 06:35:04'),
('bd7505962247926b93cd8b8a602e04c43172bd56ab820e574ffe90edc5196778f7c39683e77addc1', 1, 1, 'passport', '[]', 0, '2023-11-10 11:48:51', '2023-11-10 11:48:51', '2024-11-10 06:48:51'),
('5e866617628fce55c42e256d1593734457ce39e152f9343eb7cb1412e02ea1bcf4125783adb93f27', 1, 1, 'passport', '[]', 0, '2023-11-10 11:49:20', '2023-11-10 11:49:20', '2024-11-10 06:49:20'),
('f304d9685edcab5df9f0beed64230bc0516d0147b078f805bfe78920d2a060db96a95a44fac02d19', 1, 1, 'passport', '[]', 0, '2023-11-10 12:09:53', '2023-11-10 12:09:53', '2024-11-10 07:09:53'),
('905c23f38ed8322f8f9e223b9e7f538d442f013ae21e4becbe8416f2d50cd9028f44b17a7d26137d', 1, 1, 'passport', '[]', 0, '2023-11-10 12:13:16', '2023-11-10 12:13:16', '2024-11-10 07:13:16'),
('d6444d418132c172e7eef6f568cb45402f81007d2ea8ea8a6c20640a068b641a18d4d00d71ef11f6', 1, 1, 'passport', '[]', 0, '2023-11-10 13:53:06', '2023-11-10 13:53:06', '2024-11-10 08:53:06'),
('d724d2c158d2b286dd7cf55b646627089ecd14be1fc98cefa21e684bf3839f0f7fe4406ffae19cc6', 1, 1, 'passport', '[]', 0, '2023-11-10 13:58:00', '2023-11-10 13:58:00', '2024-11-10 08:58:00'),
('7891f27cbb63995d71f2847ff960e7e126f882f34d3cd1c40a604ae9b9a34287287611e01fe55f19', 1, 1, 'passport', '[]', 0, '2023-11-10 14:00:18', '2023-11-10 14:00:18', '2024-11-10 09:00:18'),
('86f92fcbd25196329a2165b94b5018ad2d866315ffa1305713dadab6fce1701927a7c46b234bfbc1', 1, 1, 'passport', '[]', 0, '2023-11-10 14:23:20', '2023-11-10 14:23:20', '2024-11-10 09:23:20'),
('b480246903c3bac13d910290a9e4d9faf328e6fd4e97cbc1f21da27db9cf2584bb5cee6b517c7587', 1, 1, 'passport', '[]', 0, '2023-11-10 14:38:18', '2023-11-10 14:38:18', '2024-11-10 09:38:18'),
('38e0eef521eb253114b5fb66a79c29c7a612b765dac8a15388fb5ebf71def191f37523fc1528a3b3', 1, 1, 'passport', '[]', 0, '2023-11-10 14:43:24', '2023-11-10 14:43:24', '2024-11-10 09:43:24'),
('1cc6b2f5a2402b656d37b06a8bb8d45ad3ade04d5ec13f7028d0b9ad683c9eaa32f3bef92b9073a7', 1, 1, 'passport', '[]', 0, '2023-11-10 15:13:45', '2023-11-10 15:13:45', '2024-11-10 10:13:45'),
('d6a42fd55b9cae4c71f2e2623a2753cd91fff416d759056d9a9e7eb30c7faf5915ebfdde71e22913', 7, 1, 'passport', '[]', 0, '2023-11-10 15:49:52', '2023-11-10 15:49:52', '2024-11-10 10:49:52'),
('c2e1d7c7685db1bcf94760ae4863da3c69bfa8ece3ceb1f83eec4545f047fe248632dc441c8a400b', 7, 1, 'passport', '[]', 0, '2023-11-10 16:31:24', '2023-11-10 16:31:24', '2024-11-10 11:31:24'),
('f2e76e78432e4793047262ff07cefbf81c47e63814424ed1813074e4b981cf85f3e1c4289f5dc01a', 1, 1, 'passport', '[]', 0, '2023-11-10 17:07:08', '2023-11-10 17:07:08', '2024-11-10 12:07:08'),
('b63a31ee136622f82a861b691daa8eda8706442bc67f199e83abbf7e91e1bd124ec8c1c886d7ef23', 1, 1, 'passport', '[]', 0, '2023-11-10 17:45:21', '2023-11-10 17:45:21', '2024-11-10 12:45:21'),
('67fb3b1d6dbe3c15cbb5026b54bb389fe06e55974680380dc97f73735d0ae6ac0f3ac612647922b9', 1, 1, 'passport', '[]', 0, '2023-11-10 18:33:30', '2023-11-10 18:33:30', '2024-11-10 13:33:30'),
('db218f2608fb65ffc6bcb2f9c28e62e41729258333a0ed6bd3b66424ff3d01e7bc4d89c9aa3ecf07', 1, 1, 'passport', '[]', 0, '2023-11-10 18:39:13', '2023-11-10 18:39:13', '2024-11-10 13:39:13'),
('e044e10cb2e7c26f6bea408d46f041c70a96ee9476e3b101446aa9466dbff2a2efef24df1a019fc5', 1, 1, 'passport', '[]', 0, '2023-11-10 19:00:38', '2023-11-10 19:00:38', '2024-11-10 14:00:38'),
('f838ac8d22de7eb885fb474412b2f19b32d251efa05a5dba26121a934af81af9b31d0bc5f1be3bb2', 1, 1, 'passport', '[]', 0, '2023-11-10 19:12:22', '2023-11-10 19:12:22', '2024-11-10 14:12:22'),
('91b3ba1a661a7b3324473d06392654d0a2c6fa62c80ebeaf5e22531f1543abc1f673ad54e0513567', 7, 1, 'passport', '[]', 0, '2023-11-10 19:22:43', '2023-11-10 19:22:43', '2024-11-10 14:22:43'),
('f23f7250492599768fd22649da03fffd644f62b3670ecfdb764fdc23817167ecd658bd02a75cf177', 7, 1, 'passport', '[]', 0, '2023-11-10 20:53:13', '2023-11-10 20:53:13', '2024-11-10 15:53:13'),
('f6df400383a2232df6b05b64d07291a42cf0e4898f419b212f9de4bcc76399e83ed9828f1b40390c', 7, 1, 'passport', '[]', 0, '2023-11-10 20:55:10', '2023-11-10 20:55:10', '2024-11-10 15:55:10'),
('e6e9fa00d9e4f86d2c2f862b0cb28b29a904f6d8d77057b6268afffba575d148f5155e4a9f76ab31', 1, 1, 'passport', '[]', 0, '2023-11-11 19:17:09', '2023-11-11 19:17:09', '2024-11-11 14:17:09'),
('4f1ac75b79f4e612c2730ae6d672cac0e40445e297d2b3383c306d4216b539d122096412bba60728', 1, 1, 'passport', '[]', 0, '2023-11-13 10:34:20', '2023-11-13 10:34:20', '2024-11-13 05:34:20'),
('eda6626da246c6fecfef7e978a2c1d8163569f4511e488a47acab5566ccde18d2bbbff2e858a24da', 1, 1, 'passport', '[]', 0, '2023-11-13 13:56:22', '2023-11-13 13:56:22', '2024-11-13 08:56:22'),
('b72e554d712f09db60a0e5088795ec355ab963ccfb175d6548ac0d5d632be14a4904d206d4df7fc5', 1, 1, 'passport', '[]', 0, '2023-11-13 14:52:36', '2023-11-13 14:52:36', '2024-11-13 09:52:36');

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

--
-- Estructura de tabla para la tabla `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `secret` varchar(100) DEFAULT NULL,
  `provider` varchar(191) DEFAULT NULL,
  `redirect` text NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `oauth_clients`
--

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Laravel Personal Access Client', '3AlT8gP9Emj9UHbReVxSu1ILaBrCvFz1efNiEs0F', NULL, 'http://localhost', 1, 0, 0, '2023-11-01 15:40:06', '2023-11-01 15:40:06');

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

--
-- Estructura de tabla para la tabla `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2023-11-01 15:40:06', '2023-11-01 15:40:06');

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

--
-- Estructura de tabla para la tabla `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) NOT NULL,
  `access_token_id` varchar(100) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `parkings`
--

CREATE TABLE `parkings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `hours` varchar(191) NOT NULL,
  `license_plate_number` varchar(191) DEFAULT NULL,
  `make` varchar(191) DEFAULT NULL,
  `model` varchar(191) DEFAULT NULL,
  `nick_name` varchar(191) DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `resident_name_being` varchar(191) DEFAULT NULL,
  `unit_number_visiting` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0: inavtive, 1: active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `price` varchar(191) NOT NULL,
  `payment_status` tinyint(4) NOT NULL DEFAULT 0,
  `hours_id` int(11) DEFAULT NULL,
  `client_secret` text DEFAULT NULL,
  `total_time` int(11) DEFAULT NULL,
  `total_time_unit` varchar(191) DEFAULT NULL,
  `spent_time` int(11) DEFAULT NULL,
  `spent_time_unit` varchar(191) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `parkings`
--

INSERT INTO `parkings` (`id`, `user_id`, `location_id`, `hours`, `license_plate_number`, `make`, `model`, `nick_name`, `name`, `email`, `phone`, `resident_name_being`, `unit_number_visiting`, `status`, `created_at`, `updated_at`, `price`, `payment_status`, `hours_id`, `client_secret`, `total_time`, `total_time_unit`, `spent_time`, `spent_time_unit`) VALUES
(17, 4, 2, '2', '123abc', 'Honda', '2014', 'Test', 'abc', 'Zuabir@gmail.com', '123123123', 'abc', '20', 1, '2023-11-08 14:59:10', '2023-11-08 14:59:10', '34', 0, 61, 'pi_3OA8XSLWGwmPtACI1zXTFO02', NULL, NULL, NULL, NULL),
(16, 4, 2, '2', '123abc', 'Honda', '2014', 'Test', 'abc', 'Zuabir@gmail.com', '123123123', 'abc', '20', 1, '2023-11-08 14:58:16', '2023-11-08 14:58:16', '34', 0, 61, 'pi_3OA8WaLWGwmPtACI1Ba2BsoN', NULL, NULL, NULL, NULL),
(15, 4, 2, '2', '123abc', 'Honda', '2014', 'Test', 'abc', 'Zuabir@gmail.com', '123123123', 'abc', '20', 1, '2023-11-08 14:58:02', '2023-11-08 14:58:02', '34', 0, 61, 'pi_3OA8WLLWGwmPtACI1wk9AtHl', NULL, NULL, NULL, NULL),
(14, 4, 2, '2', '123abc', 'Honda', '2014', 'Test', 'abc', 'Zuabir@gmail.com', '123123123', 'abc', '20', 1, '2023-11-08 02:21:05', '2023-11-08 02:21:05', '50', 0, 57, 'pi_3O9whpLWGwmPtACI0WHvjTWj', NULL, NULL, NULL, NULL),
(18, 7, 2, '3', 'Uggusu', 'Disgusgg', 'Dugididg', 'Duvsuvs', 'Engr. Ameer Muawiya', 'maviamughal96@gmail.com', '75758787', 'Dudhdbbd', '75', 1, '2023-11-08 15:01:55', '2023-11-08 15:01:55', '5', 0, 23, 'pi_3OA8a6LWGwmPtACI1yLMsB1d', NULL, NULL, NULL, NULL),
(19, 4, 1, '2', '123abc', 'Honda', '2014', 'Test', 'abc', 'Zuabir@gmail.com', '123123123', 'abc', '20', 1, '2023-11-08 15:19:07', '2023-11-08 15:19:07', '34', 0, 61, 'pi_3OA8qlLWGwmPtACI1XezTfzN', NULL, NULL, NULL, NULL),
(20, 7, 2, '3', 'Ddhhdhhd', 'Dbdbdb', 'Dbdhdh', 'Dhdh', 'Engr. Ameer Muawiya', 'maviamughal96@gmail.com', '48787887', 'Dbdbdb', '788', 1, '2023-11-08 16:34:05', '2023-11-08 16:34:05', '5', 0, 23, 'pi_3OAA1ILWGwmPtACI1hr2FldK', NULL, NULL, NULL, NULL),
(21, 7, 2, '3', 'Ddhhdhhd', 'Dbdbdb', 'Dbdhdh', 'Dhdh', 'Engr. Ameer Muawiya', 'maviamughal96@gmail.com', '48787887', 'Dbdbdb', '788', 1, '2023-11-08 16:37:01', '2023-11-08 16:37:01', '5', 0, 23, 'pi_3OAA49LWGwmPtACI1duOvHSB', NULL, NULL, NULL, NULL),
(22, 7, 2, '3', 'Ddhhdhhd', 'Dbdbdb', 'Dbdhdh', 'Dhdh', 'Engr. Ameer Muawiya', 'maviamughal96@gmail.com', '48787887', 'Dbdbdb', '788', 1, '2023-11-08 16:41:01', '2023-11-08 16:41:01', '5', 0, 23, 'pi_3OAA80LWGwmPtACI0JoSInC5', NULL, NULL, NULL, NULL),
(23, 7, 2, '3', 'Ddhhdhhd', 'Dbdbdb', 'Dbdhdh', 'Dhdh', 'Engr. Ameer Muawiya', 'maviamughal96@gmail.com', '48787887', 'Dbdbdb', '788', 1, '2023-11-08 16:46:11', '2023-11-08 16:46:11', '5', 0, 23, 'pi_3OAAD1LWGwmPtACI0ZgiDemz', NULL, NULL, NULL, NULL),
(24, 7, 2, '2', 'Ddhhdhhd', 'Dbdbdb', 'Dbdhdh', 'Dhdh', 'Engr. Ameer Muawiya', 'maviamughal96@gmail.com', '48787887', 'Dbdbdb', '788', 1, '2023-11-08 16:46:35', '2023-11-08 16:46:35', '10', 0, 24, 'pi_3OAADPLWGwmPtACI1Ryup3jt', NULL, NULL, NULL, NULL),
(25, 7, 2, '2', 'Ddhhdhhd', 'Dbdbdb', 'Dbdhdh', 'Dhdh', 'Engr. Ameer Muawiya', 'maviamughal96@gmail.com', '48787887', 'Dbdbdb', '788', 1, '2023-11-08 16:46:50', '2023-11-08 16:46:50', '10', 0, 24, 'pi_3OAADeLWGwmPtACI16fER0dh', NULL, NULL, NULL, NULL),
(27, 7, 2, '3', 'Hddhdh', 'Shddhh', 'Shehdh', 'Dhdhdh', 'Engr. Ameer Muawiya', 'maviamughal96@gmail.com', '454545', 'Dhehdh', '4845', 1, '2023-11-08 17:07:42', '2023-11-08 17:07:42', '5', 0, 23, 'pi_3OAAXpLWGwmPtACI0Wvi7dr4', NULL, NULL, NULL, NULL),
(28, 7, 2, '3', 'Dhsbsb', 'Sbsbshsh', 'Sbsbshsh', 'Sbsbsb', 'Engr. Ameer Muawiya', 'maviamughal96@gmail.com', '484548488', 'SbsbshsEbh', '45', 1, '2023-11-09 09:50:17', '2023-11-09 22:23:00', '5', 1, 23, 'pi_3OAQC5LWGwmPtACI1ReaESS2', NULL, NULL, 1, NULL),
(29, 7, 2, '3', 'Fndjdjdjdjb', 'Dhdddhh', 'Dhdhddj', 'Dhdhjdjd', 'Engr. Ameer Muawiya', 'maviamughal96@gmail.com', '4845488484', 'Dhdhdh', '45455454', 0, '2023-11-09 16:49:54', '2023-11-09 17:12:46', '5', 1, 23, 'pi_3OAWkALWGwmPtACI0FWT8tYF', NULL, NULL, NULL, NULL),
(30, 28, 2, '20', 'Sa14drx', 'Kia', 'Sportage', 'Jhon', 'Talal Tahir', 'talal@theappguys.com', '07448371041', 'Doe', '15', 1, '2023-11-09 18:47:51', '2023-11-09 22:25:17', '10', 1, 24, 'pi_3OAYaJLWGwmPtACI0Pab4jkJ', 3600, NULL, 2, NULL),
(31, 30, 2, '3', 'HBC123', 'Black', 'BMW123', 'Test Car', 'Gemm', 'gemm@theappguys.com', '09991231211', 'Test', '12', 1, '2023-11-09 22:51:16', '2023-11-09 22:51:16', '5', 0, 23, 'pi_3OAcNsLWGwmPtACI0cXuj4JN', 10800, 'secondes', 0, 'secondes'),
(32, 30, 2, '3', 'ABC123', 'Black', 'Bmw123', 'Test', 'Gemm', 'gemm@theappguys.com', '0918', 'Test', '5', 0, '2023-11-09 23:00:19', '2023-11-10 00:26:17', '5', 1, 23, 'pi_3OAcWdLWGwmPtACI1kH7vcOy', 10800, 'secondes', 0, 'secondes');

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

--
-- Estructura de tabla para la tabla `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'User', 'web', NULL, NULL),
(2, 'Manager', 'web', NULL, NULL),
(3, 'Enforce', 'web', NULL, NULL),
(4, 'Admin', 'web', NULL, NULL);

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

--
-- Estructura de tabla para la tabla `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `email` varchar(191) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `add_by` varchar(191) DEFAULT NULL,
  `social_account_id` text DEFAULT NULL,
  `social_account_type` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `otp` varchar(191) DEFAULT NULL,
  `community_id` int(11) DEFAULT NULL,
  `profile` varchar(191) DEFAULT NULL,
  `self_update` tinyint(4) NOT NULL DEFAULT 0,
  `company_name` varchar(191) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `ephemeral_key` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `phone`, `add_by`, `social_account_id`, `social_account_type`, `status`, `otp`, `community_id`, `profile`, `self_update`, `company_name`, `notes`, `customer_id`, `ephemeral_key`) VALUES
(1, 'admin', 'admin@gmail.com', NULL, '$2y$10$gY6Omf3w3HdmzWpbpwqFSukytd6Yld3Q5lI1R4/xGAfKiQYopTuu2', NULL, '2023-11-01 13:48:54', '2023-11-13 15:59:40', NULL, NULL, NULL, NULL, 1, '$2y$10$HGgNPe4Id1YqLxYagRoXWOZlqD3EECC0ZK0k.wJTDXymBblHxQ8g2', NULL, 'https://parkbyplate-apis.thewebjobs.us/public/storage/users/1699873180342709333.png', 0, NULL, NULL, 'cus_OxmXBqIIN0l3T2', 'ek_test_YWNjdF8xSjdKVFFMV0d3bVB0QUNJLHVzMmc0cDJZRFA5TmJzWlJBdHkxN2ltUTNYZ0o4VVM_00STf6i0a3'),
(7, 'Ameer Muawiya', 'maviamughal96@gmail.com', NULL, '$2y$10$mMGNFXbhBeLKq8rUWN0iGuLukR19.sGVtY8VV8OzTqtwHhd3K2cLi', NULL, '2023-11-02 13:51:33', '2023-11-10 20:55:10', NULL, NULL, 'eyJraWQiOiJZdXlYb1kiLCJhbGciOiJSUzI1NiJ9.eyJpc3MiOiJodHRwczovL2FwcGxlaWQuYXBwbGUuY29tIiwiYXVkIjoiY29tLnRoZXdlYmpvYnMucGFya2J5cGxhdGUiLCJleHAiOjE2OTk3MTgxMDcsImlhdCI6MTY5OTYzMTcwNywic3ViIjoiMDAwNjk2Ljk0YmZkNmJhMDEwYzRkOGZiNjFiYTJmODZmMmYxOWMwLjEyMjQiLCJub25jZSI6ImE2MzkxMjM4OTM4NjlmNDBlZDdhMjI1N2IzODY0YWU1NTU5MzdmZjljNDk5OWM2YjRjODE0ZmQ5ZTI4ZjAyNzEiLCJjX2hhc2giOiJxaU0yd09nU0UwUWhGRXBQQklzRElBIiwiZW1haWwiOiJtYXZpYW11Z2hhbDk2QGdtYWlsLmNvbSIsImVtYWlsX3ZlcmlmaWVkIjoidHJ1ZSIsImF1dGhfdGltZSI6MTY5OTYzMTcwNywibm9uY2Vfc3VwcG9ydGVkIjp0cnVlLCJyZWFsX3VzZXJfc3RhdHVzIjoyfQ.V9iM8nPMx_WBiuGaitVXrPPJQbaHo-y4iGA0T6dI4MdLVHNXMhlIxWtn6FjAfQNIJwg0m2gs9kgHx_0KclBha8CvUJWBAjE9nA0PFlbkY82fU6TrsT6jbkcQCwWUe4EQgVJCwVFUJOGcEe9NoeulIsG0nNJoSKuPHAx9H1HWj5d8C8zWDIoUEibAmOJiiudTGa0QWqQw7Oplth0WFZ9Ua0DRUEku13eoUb9Z9mMeHLSJxGVsD-Vg3fPDFYsGW6hLaHW9JbSWMxU4DtJqTiEFDIS61MYdDSb7IMkzs1ArTSzAqA7gDZMgaz6SEmdiadMS4uuD4v5URCseqdDVk2liJg', 'apple', 1, '$2y$10$zodKcctksRBQcKy11DcXKuZqsN/K1RSUYbeBUPU/88lJ8bex2GlQa', NULL, NULL, 1, NULL, NULL, 'cus_Oy6k7caxypWeGi', NULL),
(27, 'Talal Tahir', 'qmbfb5c5xd@privaterelay.appleid.com', NULL, '$2y$10$oJ1TKNfUaW16MVE3ozttV.ae692LYPcUSKINpCcjIVALmWJjlGwzy', NULL, '2023-11-09 18:39:45', '2023-11-09 19:28:50', NULL, NULL, 'eyJraWQiOiJmaDZCczhDIiwiYWxnIjoiUlMyNTYifQ.eyJpc3MiOiJodHRwczovL2FwcGxlaWQuYXBwbGUuY29tIiwiYXVkIjoiY29tLnRoZXdlYmpvYnMucGFya2J5cGxhdGUiLCJleHAiOjE2OTk2MjY1MjYsImlhdCI6MTY5OTU0MDEyNiwic3ViIjoiMDAxMjk5LjBjZDNlNWRiMzhhZDRiZWViOTc4ZGFhZDVlZWFiODA5LjE3MjgiLCJub25jZSI6ImM1NmMwOGU1ZTRjZjQ4YjNkOTg3OTY0ZGVjNDE3YjE2MTMyNDRjY2UwNDJjYzlkMzYwNDUyMzBiZGM5N2JjOGQiLCJjX2hhc2giOiJsa1A2eDI4UmdlQmNWMUZQbVRCdFlnIiwiZW1haWwiOiJxbWJmYjVjNXhkQHByaXZhdGVyZWxheS5hcHBsZWlkLmNvbSIsImVtYWlsX3ZlcmlmaWVkIjoidHJ1ZSIsImlzX3ByaXZhdGVfZW1haWwiOiJ0cnVlIiwiYXV0aF90aW1lIjoxNjk5NTQwMTI2LCJub25jZV9zdXBwb3J0ZWQiOnRydWV9.kc-00URGAMU2aC0p_hHAUS_k-7Lw5NbWJ8QaM8Qqc9vX-vHRXSSgDz6BZZOFdK13KSFaXb3JG0aXKuKirt-8ieTGCEwjnZvlIkJmWdl4aNPVUgt10UOSNQWc_cyGThmi6NAFEDtycyetZU7F1n0AHcwIdDpIRFayZbN7d9NIqEw6FKXKBbwpeOckkYKVLCwc0Y_hQzBddzNaswVuVsgtiMAYRpCqHX0m0cNH5NHd8lguGM_stPAgXKUH3G_KZ9BCPYtwtSOHjSHmGe3dE9du0Qa6d7W41DIhwRBhPlWWb3hUKl2fLfGwgVk7yOcOCVCXDte-rImu8j4VDYI4F2BKsw', 'apple', 1, NULL, NULL, NULL, 0, NULL, NULL, 'cus_OyVTGPoAxtYajb', NULL),
(5, 'Heisenberg', 'Ehejej@dhdj.sjsj', NULL, '$2y$10$YhzlqRTw0nhPCoHQUDb3Qe/89nBmpZ9JMTrsgf68YM2Le/GbEqTG2', NULL, '2023-11-02 13:36:12', '2023-11-02 13:36:12', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL),
(23, 'Mian Roshan(testing account)', 'abidabad786@gmail.com', NULL, '$2y$10$klmlCLwnrfjzHLI50s2L6e98iYUgtdJwreVcb6o3ZWC9QeNxoEi56', NULL, '2023-11-08 18:59:31', '2023-11-08 18:59:31', '03016261883', '1', NULL, NULL, 1, NULL, 2, NULL, 0, 'The web jobs', 'asdasd', NULL, NULL),
(25, 'zubair', 'zubairbasharat143@gmail.com', NULL, '$2y$10$oEPE.2eBDycC0gAHbYR4heqWXAFmhRpvbKUd73DGf6CfD1u.g7Eye', NULL, '2023-11-08 19:04:37', '2023-11-10 17:59:40', '123456', '1', NULL, NULL, 1, '$2y$10$axJiAwup5nZde4TCoxRwMe/WFHpqHrM/qc03nj3spk8fdbS9j643O', 1, NULL, 0, 'company', 'test', NULL, NULL),
(26, 'Zubair Basharat', 'zubairbasharat14@gmail.com', NULL, '$2y$10$NutUxDGtKdBut6TJdaDmoucDCwJojdoVz27AC/vYG9vzk1xBzIpb.', NULL, '2023-11-08 19:05:31', '2023-11-10 18:31:48', '123456', '1', 'ya29.a0AfB_byBeEgcL0-vNr4ig5S-1eiWl-TVNbYaNjwzLISFvs0aTZEaInhojuGVwT37gmQ-Vxh3hDUb5Vx2Utdg0yDh1-OY7kIvnMlGYxBCGFVfBfqsZh_k21NufYjfoWyjzuOiyIZyjORJsvr4EbxuAJQUxjiy7-qJ09nwRaCgYKAScSARASFQHGX2MivubK1BBoZaAVU_ygOjbwSA0171', 'google', 1, '$2y$10$fW72UTz8kpN9h9p4H.2DP.8iRXOplxttmLm6h7OrXq1JpuCP4eQ3u', 1, 'https://lh3.googleusercontent.com/a/ACg8ocLKYy_1ihLOBOix4S07Jqgvatyh85haX4fCQeeaeKlaVXo=s96-c', 0, 'company', 'test', 'cus_Oy8jZwnEPa8YqO', NULL),
(28, 'Talal Tahir', 'talal@theappguys.com', NULL, '$2y$10$wGbgvQGASC76VCWyQXoZcuujN2M2Id35mJ2b.Sp0fWh7GQyIMynTm', NULL, '2023-11-09 18:40:52', '2023-11-09 18:46:22', NULL, NULL, 'ya29.a0AfB_byAWfbC1X9xMYFKZ3RahNlRutnk3omMPttFOlRiwZS475K1fKcB_37nNm0MCItLc-ntyofr-038jmyNkhma-6ar0cCiayueceDTW1Mhdj9W02pGdFOqr27w2Tj-byaZ7k9yHxTeMgWxBLx-7e5Kl_LrL3jzOmgUdaCgYKASkSARMSFQHGX2MidV9_t0Zc4O9iE0sEd7OEOA0171', 'google', 1, NULL, NULL, 'https://lh3.googleusercontent.com/a/ACg8ocIrSbGZsx_t4YRFUM5q7WTLlaWMCf2Xg51Ef16XSYzGBQ=s96-c', 0, NULL, NULL, 'cus_OyVUwd1T8c9ET7', NULL),
(29, 'Talal Tahir', 'Talaltahir7899@gmail.com', NULL, '$2y$10$WVTsQQpp9j3psJ82QO3pbenI/krTdodlKsp6m0gnJhCCOeHrTH3Ku', NULL, '2023-11-09 18:42:11', '2023-11-09 18:44:18', NULL, NULL, NULL, NULL, 1, '$2y$10$HH9rsXJFlBxfieX91ZNC.eYxaU5KDzI79bJbvKWcPHE6A7F3t9Tx6', NULL, NULL, 0, NULL, NULL, 'cus_OyVVCtZEiqtDyh', NULL),
(30, 'Gemm Mangali', 'gemm@theappguys.com', NULL, '$2y$10$6TNBEwnC3jVX0mD.CrHRROqYZYiDWi4eo4nzkSjL2mmrRHyaWpbPK', NULL, '2023-11-09 22:48:49', '2023-11-10 00:21:19', NULL, NULL, 'ya29.a0AfB_byBqrdSmeK18IGmufmNuVORdPJ9kSMbZ7vv9IDnWV8wc50d_Rb8NM70mc2l3SqIA_9v-VIBH_9fiOsXqrBY1w2Ov6_v-oZ5FgqdsSyTqmkddY8veazQ5x_Xn7yoZr6vsrru1RttObKZzd59m7ueAPr8HjoiUswizaCgYKAc0SARMSFQHGX2Mi8gCzK_vEAcNa4wZjyOCgng0171', 'google', 1, NULL, NULL, 'https://lh3.googleusercontent.com/a/ACg8ocJagEosG0W7A2yD912SEFJ_RpM38ACgU7MMmzE4_cM=s96-c', 0, NULL, NULL, 'cus_OyZU8AL6XOxYOF', NULL),
(31, 'Gemm Mangali', 'qvt4d9bw92@privaterelay.appleid.com', NULL, '$2y$10$HWDHCTJCZXt9DRFEUs6OPOGKWzN4nsRuR164Rwe7lQ0GDLH0t4Qxe', NULL, '2023-11-10 00:20:41', '2023-11-10 00:20:41', NULL, NULL, 'eyJraWQiOiJmaDZCczhDIiwiYWxnIjoiUlMyNTYifQ.eyJpc3MiOiJodHRwczovL2FwcGxlaWQuYXBwbGUuY29tIiwiYXVkIjoiY29tLnRoZXdlYmpvYnMucGFya2J5cGxhdGUiLCJleHAiOjE2OTk2NDQwNDAsImlhdCI6MTY5OTU1NzY0MCwic3ViIjoiMDAwNzUwLmE2M2FiMDBkMDJiYjQ0ZDg4ZjBiNjIzMjUwMGM5YmVmLjE5MjAiLCJub25jZSI6IjM4OWVhYmZkYWZiM2Q1MWU0ZjVmYzc3ZDQzMzc0MmI2YTM5MDJlYmFjNjFlYzdmMmU3YTAyNWU0ZDhkZjRhMzkiLCJjX2hhc2giOiI0bjhrenVMcFY0STJqY04wWlpuTTdnIiwiZW1haWwiOiJxdnQ0ZDlidzkyQHByaXZhdGVyZWxheS5hcHBsZWlkLmNvbSIsImVtYWlsX3ZlcmlmaWVkIjoidHJ1ZSIsImlzX3ByaXZhdGVfZW1haWwiOiJ0cnVlIiwiYXV0aF90aW1lIjoxNjk5NTU3NjQwLCJub25jZV9zdXBwb3J0ZWQiOnRydWUsInJlYWxfdXNlcl9zdGF0dXMiOjJ9.qoelgZo4JvuQ69bTDztOaI7H9Gulzvgz1lAC2nQladYpuFCExLuVl7PMaNT6slCiv0NxBbrKyhFR7scMwIHOlxQWN5DJBIvwhbFKnUbKegbDGT6wkT98a78-qT2pGtZVpsVAMsxOjUAhkfLwu96YrDpf6kLzMNcwa7DQOHE4xDZY5TyAdJJzrU7Sf43_AB1A4jRSKzzdurS-Hqs1VjQkOM0s7smkJ5hytDjUWoHv7xfYMQl5q8b4hmpmMItGaSB-VyHV4mYGPONSsgSjKicafWHQ309BbZKeSFWLSeWs5T0RjxRzhx65NGzdFmi73VIOP3BrlyTnt3AsCFV_bb-Ihg', 'apple', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL);

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

--
-- Estructura de tabla para la tabla `user_communities`
--

CREATE TABLE `user_communities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `community_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `user_communities`
--

INSERT INTO `user_communities` (`id`, `user_id`, `community_id`, `created_at`, `updated_at`) VALUES
(1, 21, 1, '2023-11-08 01:58:53', '2023-11-08 01:58:53'),
(6, 19, 5, '2023-11-08 17:03:41', '2023-11-08 17:03:41'),
(5, 19, 2, '2023-11-08 17:03:41', '2023-11-08 17:03:41'),
(22, 22, 6, '2023-11-08 17:31:09', '2023-11-08 17:31:09'),
(21, 22, 10, '2023-11-08 17:31:09', '2023-11-08 17:31:09'),
(20, 22, 5, '2023-11-08 17:31:09', '2023-11-08 17:31:09'),
(19, 22, 2, '2023-11-08 17:31:09', '2023-11-08 17:31:09'),
(18, 20, 9, '2023-11-08 17:29:04', '2023-11-08 17:29:04'),
(17, 20, 2, '2023-11-08 17:29:04', '2023-11-08 17:29:04'),
(16, 20, 8, '2023-11-08 17:29:04', '2023-11-08 17:29:04'),
(23, 22, 8, '2023-11-08 17:31:09', '2023-11-08 17:31:09');

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

--
-- Estructura de tabla para la tabla `websockets_statistics_entries`
--

CREATE TABLE `websockets_statistics_entries` (
  `id` int(10) UNSIGNED NOT NULL,
  `app_id` varchar(191) NOT NULL,
  `peak_connection_count` int(11) NOT NULL,
  `websocket_message_count` int(11) NOT NULL,
  `api_message_count` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `communities`
--
ALTER TABLE `communities`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `community_pricings`
--
ALTER TABLE `community_pricings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `community_pricings_community_id_foreign` (`community_id`);

--
-- Indices de la tabla `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indices de la tabla `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indices de la tabla `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indices de la tabla `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

--
-- Indices de la tabla `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

--
-- Indices de la tabla `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_user_id_index` (`user_id`);

--
-- Indices de la tabla `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Indices de la tabla `parkings`
--
ALTER TABLE `parkings`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indices de la tabla `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`) USING HASH;

--
-- Indices de la tabla `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`) USING HASH;

--
-- Indices de la tabla `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indices de la tabla `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indices de la tabla `user_communities`
--
ALTER TABLE `user_communities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_communities_user_id_foreign` (`user_id`),
  ADD KEY `user_communities_community_id_foreign` (`community_id`);

--
-- Indices de la tabla `websockets_statistics_entries`
--
ALTER TABLE `websockets_statistics_entries`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `communities`
--
ALTER TABLE `communities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT de la tabla `community_pricings`
--
ALTER TABLE `community_pricings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- AUTO_INCREMENT de la tabla `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `locations`
--
ALTER TABLE `locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT de la tabla `oauth_clients`
--
ALTER TABLE `oauth_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `parkings`
--
ALTER TABLE `parkings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT de la tabla `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de la tabla `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT de la tabla `user_communities`
--
ALTER TABLE `user_communities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT de la tabla `websockets_statistics_entries`
--
ALTER TABLE `websockets_statistics_entries`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

