
--
-- Дамп данных таблицы `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `user_type`) VALUES
(1, 'Admin', 'admin@tmgp.pl', '2024-11-12 11:07:12', '$2y$12$mZ5OteeTAdQfMKdGwD1rt.ndCvkQgnhk1PHt6XHGNgt3j0PpLFTs6', '', NULL, '2024-11-14 05:02:20', 3),
(3, 'Ihor Kyrchevskiy', 'kyrchevskiy@time-group.pl', '2024-11-11 19:00:00', '$2y$12$ehQq8hYXLIeoxXORGqmI/OULsmU9tifgVBVXkLMO/KInSp9tmFgOO', NULL, '2024-10-23 23:18:21', '2024-10-23 23:18:21', 3),
(6, 'Client', 'client@max-group.pl', '2024-11-19 12:06:16', '$2y$12$21HZmVInbTCpTIHPwTIo..clIw5yiBlM6j1oPmcP6gyFca9ZJLgC6', NULL, '2024-11-21 07:16:18', '2024-11-21 07:16:18', 1),
(8, 'Collector', 'collector@max-group.pl', '2024-11-19 12:06:16', '$2y$12$7Y.cWHYpAsL3R8UdyKdAn.Zz/YcJZOT6wQeA3wKMgF1zn1iNm0qMi', NULL, '2024-11-21 07:20:20', '2024-11-21 07:20:20', 2),
(10, 'Natasa', 'pdh.polska@gmail.com', '2024-11-30 02:44:20', '$2y$12$.Rod6vV/n6JA.JRH4u5m.O8pgkZtxC2tzeC7CHA2qAwHAmfOA3G3e', NULL, '2024-11-30 02:40:48', '2024-11-30 02:44:20', 1),
(11, 'Rava', 'rupor.info.pl@gmail.com', '2024-11-30 03:20:39', '$2y$12$kAk28DTX/R5wWNYk.bVPs.jjdgUsiA6wUDt1ssx4cexo03fjWxF1e', NULL, '2024-11-30 03:20:21', '2024-11-30 03:21:10', 3),
(13, 'AdminMAX', 'maxgroup.cargo@gmail.com', '2024-12-08 04:57:51', '$2y$12$SHeDC9DT3jNh2AX.Bta21udH14DuuKv7bBh/MPdfwxV3i6ZOLFHbW', NULL, '2024-12-08 03:57:40', '2024-12-08 03:57:53', 4),
(14, 'Admin PL', 'anatol.Karamanyan@gmail.com', '2024-12-12 16:33:28', '$2y$12$gJQbG5P6vTbxz3i4xRJBWuJvED8sORJJ7FXnwAtVTxzCAM44BwtOK', '3w5RlzDdnE5DKpGvpW1BjyywbVDhr8Utewwygu2z00S7gmIzoWPJaihXmghO', '2024-12-12 15:33:15', '2024-12-12 15:33:31', 4);

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


--
-- Дамп данных таблицы `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'web', NULL, NULL),
(2, 'Client', 'web', '2024-11-12 13:08:34', '2024-11-12 13:08:34'),
(3, 'Collector', 'web', '2024-11-12 13:08:49', '2024-11-12 13:08:49'),
(4, 'Coworker', 'web', '2024-11-14 07:59:37', '2024-11-14 07:59:37'),
(5, 'DeliveryWorker', 'web', '2024-12-12 06:08:44', '2024-12-12 06:08:44'),
(6, 'Agent', 'web', '2025-01-03 13:55:18', '2025-01-03 13:55:18');

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

--
-- Дамп данных таблицы `model_has_roles`
--
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(1, 'App\\Models\\User', 3),
(1, 'App\\Models\\User', 13),
(1, 'App\\Models\\User', 14),
(2, 'App\\Models\\User', 4),
(2, 'App\\Models\\User', 5),
(2, 'App\\Models\\User', 6),
(2, 'App\\Models\\User', 7),
(2, 'App\\Models\\User', 9),
(2, 'App\\Models\\User', 10),
(2, 'App\\Models\\User', 12),
(2, 'App\\Models\\User', 15),
(2, 'App\\Models\\User', 16),
(2, 'App\\Models\\User', 18),
(2, 'App\\Models\\User', 19),
(2, 'App\\Models\\User', 20),
(3, 'App\\Models\\User', 5),
(3, 'App\\Models\\User', 8),
(4, 'App\\Models\\User', 1),
(4, 'App\\Models\\User', 3),
(4, 'App\\Models\\User', 11),
(4, 'App\\Models\\User', 13),
(6, 'App\\Models\\User', 17),
(6, 'App\\Models\\User', 21);

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

--
-- Дамп данных таблицы `permissions`
--
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'view-any User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(2, 'view User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(3, 'create User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(4, 'update User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(5, 'delete User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(6, 'delete-any User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(7, 'replicate User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(8, 'restore User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(9, 'restore-any User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(10, 'reorder User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(11, 'force-delete User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(12, 'force-delete-any User', 'web', '2024-10-21 02:48:35', '2024-10-21 02:48:35'),
(13, 'view-any AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(14, 'view AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(15, 'create AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(16, 'update AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(17, 'delete AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(18, 'delete-any AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(19, 'replicate AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(20, 'restore AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(21, 'restore-any AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(22, 'reorder AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(23, 'force-delete AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(24, 'force-delete-any AddressDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(25, 'view-any CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(26, 'view CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(27, 'create CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(28, 'update CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(29, 'delete CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(30, 'delete-any CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(31, 'replicate CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(32, 'restore CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(33, 'restore-any CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(34, 'reorder CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(35, 'force-delete CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(36, 'force-delete-any CargoPickupRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(37, 'view-any Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(38, 'view Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(39, 'create Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(40, 'update Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(41, 'delete Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(42, 'delete-any Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(43, 'replicate Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(44, 'restore Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(45, 'restore-any Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(46, 'reorder Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(47, 'force-delete Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(48, 'force-delete-any Client', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(49, 'view-any ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(50, 'view ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(51, 'create ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(52, 'update ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(53, 'delete ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(54, 'delete-any ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(55, 'replicate ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(56, 'restore ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(57, 'restore-any ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(58, 'reorder ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(59, 'force-delete ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(60, 'force-delete-any ClientRequest', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(61, 'view-any CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(62, 'view CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(63, 'create CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(64, 'update CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(65, 'delete CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(66, 'delete-any CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(67, 'replicate CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(68, 'restore CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(69, 'restore-any CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(70, 'reorder CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(71, 'force-delete CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(72, 'force-delete-any CollectionHistory', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(73, 'view-any Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(74, 'view Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(75, 'create Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(76, 'update Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(77, 'delete Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(78, 'delete-any Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(79, 'replicate Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(80, 'restore Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(81, 'restore-any Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(82, 'reorder Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(83, 'force-delete Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(84, 'force-delete-any Collector', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(85, 'view-any DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(86, 'view DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(87, 'create DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(88, 'update DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(89, 'delete DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(90, 'delete-any DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(91, 'replicate DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(92, 'restore DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(93, 'restore-any DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(94, 'reorder DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(95, 'force-delete DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(96, 'force-delete-any DeliveryManagement', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(97, 'view-any GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(98, 'view GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(99, 'create GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(100, 'update GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(101, 'delete GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(102, 'delete-any GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(103, 'replicate GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(104, 'restore GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(105, 'restore-any GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(106, 'reorder GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(107, 'force-delete GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(108, 'force-delete-any GeneralDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(109, 'view-any Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(110, 'view Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(111, 'create Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(112, 'update Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(113, 'delete Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(114, 'delete-any Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(115, 'replicate Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(116, 'restore Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(117, 'restore-any Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(118, 'reorder Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(119, 'force-delete Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(120, 'force-delete-any Group', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(121, 'view-any RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(122, 'view RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(123, 'create RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(124, 'update RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(125, 'delete RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(126, 'delete-any RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(127, 'replicate RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(128, 'restore RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(129, 'restore-any RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(130, 'reorder RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(131, 'force-delete RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(132, 'force-delete-any RequestDataChange', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(133, 'view-any TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(134, 'view TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(135, 'create TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(136, 'update TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(137, 'delete TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(138, 'delete-any TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(139, 'replicate TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(140, 'restore TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(141, 'restore-any TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(142, 'reorder TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(143, 'force-delete TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(144, 'force-delete-any TransportOperator', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(145, 'view-any VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(146, 'view VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(147, 'create VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(148, 'update VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(149, 'delete VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(150, 'delete-any VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(151, 'replicate VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(152, 'restore VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(153, 'restore-any VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(154, 'reorder VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(155, 'force-delete VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(156, 'force-delete-any VehicleDatabase', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(157, 'view-any Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(158, 'view Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(159, 'create Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(160, 'update Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(161, 'delete Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(162, 'delete-any Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(163, 'replicate Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(164, 'restore Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(165, 'restore-any Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(166, 'reorder Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(167, 'force-delete Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(168, 'force-delete-any Withdrawal', 'web', '2024-11-12 10:58:30', '2024-11-12 10:58:30'),
(169, 'view-any Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(170, 'view Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(171, 'create Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(172, 'update Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(173, 'delete Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(174, 'delete-any Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(175, 'replicate Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(176, 'restore Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(177, 'restore-any Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(178, 'reorder Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(179, 'force-delete Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(180, 'force-delete-any Permission', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(181, 'view-any Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(182, 'view Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(183, 'create Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(184, 'update Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(185, 'delete Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(186, 'delete-any Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(187, 'replicate Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(188, 'restore Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(189, 'restore-any Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(190, 'reorder Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(191, 'force-delete Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(192, 'force-delete-any Role', 'web', '2024-11-12 11:29:40', '2024-11-12 11:29:40'),
(193, 'view-any CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(194, 'view CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(195, 'create CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(196, 'update CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(197, 'delete CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(198, 'delete-any CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(199, 'replicate CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(200, 'restore CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(201, 'restore-any CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(202, 'reorder CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(203, 'force-delete CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(204, 'force-delete-any CargoHistory', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(205, 'view-any Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(206, 'view Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(207, 'create Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(208, 'update Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(209, 'delete Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(210, 'delete-any Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(211, 'replicate Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(212, 'restore Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(213, 'restore-any Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(214, 'reorder Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(215, 'force-delete Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38'),
(216, 'force-delete-any Round', 'web', '2024-12-06 11:00:38', '2024-12-06 11:00:38');

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

--
-- Дамп данных таблицы `role_has_permissions`
--
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(1, 4),
(2, 1),
(2, 4),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(13, 2),
(13, 3),
(13, 4),
(13, 6),
(14, 1),
(14, 2),
(14, 3),
(14, 4),
(14, 6),
(15, 1),
(15, 2),
(15, 4),
(15, 6),
(16, 1),
(16, 2),
(16, 4),
(16, 6),
(17, 1),
(17, 4),
(17, 6),
(18, 1),
(18, 4),
(18, 6),
(19, 1),
(19, 4),
(20, 1),
(20, 4),
(20, 6),
(21, 1),
(21, 4),
(22, 1),
(22, 4),
(23, 1),
(23, 4),
(24, 1),
(24, 4),
(25, 1),
(25, 3),
(25, 4),
(26, 1),
(26, 3),
(26, 4),
(27, 1),
(27, 3),
(27, 4),
(28, 1),
(28, 3),
(28, 4),
(29, 1),
(29, 3),
(29, 4),
(30, 1),
(30, 3),
(30, 4),
(31, 1),
(31, 3),
(31, 4),
(32, 1),
(32, 3),
(32, 4),
(33, 1),
(33, 3),
(33, 4),
(34, 1),
(34, 3),
(34, 4),
(35, 1),
(35, 3),
(35, 4),
(36, 1),
(36, 3),
(36, 4),
(37, 1),
(37, 4),
(37, 6),
(38, 1),
(38, 4),
(38, 6),
(39, 1),
(39, 6),
(40, 1),
(40, 6),
(41, 1),
(41, 6),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1),
(49, 1),
(49, 2),
(49, 3),
(49, 6),
(50, 1),
(50, 2),
(50, 3),
(50, 4),
(50, 6),
(51, 1),
(51, 2),
(51, 4),
(51, 6),
(52, 1),
(52, 2),
(52, 3),
(52, 4),
(52, 6),
(53, 1),
(53, 2),
(53, 4),
(53, 6),
(54, 1),
(54, 2),
(54, 6),
(55, 1),
(55, 2),
(55, 3),
(56, 1),
(56, 2),
(56, 3),
(57, 1),
(57, 2),
(57, 3),
(58, 1),
(58, 2),
(58, 3),
(59, 1),
(59, 2),
(60, 1),
(60, 2),
(61, 1),
(61, 3),
(61, 4),
(62, 1),
(62, 3),
(62, 4),
(63, 1),
(63, 3),
(63, 4),
(64, 1),
(64, 3),
(64, 4),
(65, 1),
(65, 3),
(65, 4),
(66, 1),
(66, 3),
(66, 4),
(67, 1),
(67, 3),
(67, 4),
(68, 1),
(68, 3),
(68, 4),
(69, 1),
(69, 3),
(69, 4),
(70, 1),
(70, 3),
(70, 4),
(71, 1),
(71, 3),
(71, 4),
(72, 1),
(72, 3),
(72, 4),
(73, 1),
(73, 4),
(74, 1),
(74, 4),
(75, 1),
(76, 1),
(77, 1),
(78, 1),
(79, 1),
(80, 1),
(81, 1),
(82, 1),
(83, 1),
(84, 1),
(85, 1),
(85, 4),
(86, 1),
(86, 4),
(87, 1),
(87, 4),
(88, 1),
(88, 4),
(89, 1),
(89, 4),
(90, 1),
(90, 4),
(91, 1),
(91, 4),
(92, 1),
(92, 4),
(93, 1),
(93, 4),
(94, 1),
(94, 4),
(95, 1),
(95, 4),
(96, 1),
(96, 4),
(109, 1),
(109, 4),
(110, 1),
(110, 4),
(111, 1),
(112, 1),
(113, 1),
(114, 1),
(115, 1),
(115, 4),
(116, 1),
(116, 4),
(117, 1),
(117, 4),
(118, 1),
(118, 4),
(119, 1),
(120, 1),
(121, 1),
(121, 2),
(121, 3),
(121, 4),
(121, 6),
(122, 1),
(122, 2),
(122, 3),
(122, 4),
(122, 6),
(123, 1),
(123, 2),
(123, 3),
(123, 4),
(123, 6),
(124, 1),
(124, 2),
(124, 3),
(124, 4),
(124, 6),
(125, 1),
(125, 2),
(125, 3),
(125, 4),
(125, 6),
(126, 1),
(126, 2),
(126, 3),
(126, 4),
(126, 6),
(127, 1),
(127, 2),
(127, 3),
(127, 4),
(128, 1),
(128, 2),
(128, 3),
(128, 4),
(129, 1),
(129, 2),
(129, 3),
(129, 4),
(130, 1),
(130, 2),
(130, 3),
(130, 4),
(131, 1),
(131, 2),
(131, 3),
(131, 4),
(132, 1),
(132, 2),
(132, 3),
(132, 4),
(133, 1),
(133, 3),
(133, 4),
(134, 1),
(134, 3),
(134, 4),
(135, 1),
(136, 1),
(137, 1),
(138, 1),
(139, 1),
(140, 1),
(141, 1),
(142, 1),
(143, 1),
(144, 1),
(145, 1),
(145, 4),
(146, 1),
(146, 4),
(147, 1),
(148, 1),
(149, 1),
(150, 1),
(151, 1),
(152, 1),
(153, 1),
(154, 1),
(155, 1),
(156, 1),
(157, 1),
(157, 4),
(158, 1),
(158, 4),
(159, 1),
(159, 4),
(160, 1),
(161, 1),
(161, 4),
(162, 1),
(162, 4),
(163, 1),
(163, 4),
(164, 1),
(164, 4),
(165, 1),
(165, 4),
(166, 1),
(166, 4),
(167, 1),
(167, 4),
(168, 1),
(168, 4),
(169, 1),
(170, 1),
(171, 1),
(172, 1),
(173, 1),
(174, 1),
(175, 1),
(176, 1),
(177, 1),
(178, 1),
(179, 1),
(180, 1),
(181, 1),
(182, 1),
(183, 1),
(184, 1),
(185, 1),
(186, 1),
(187, 1),
(188, 1),
(189, 1),
(190, 1),
(191, 1),
(192, 1),
(193, 1),
(193, 3),
(193, 4),
(194, 1),
(194, 3),
(194, 4),
(195, 1),
(195, 3),
(195, 4),
(196, 1),
(196, 3),
(196, 4),
(197, 1),
(197, 3),
(197, 4),
(198, 1),
(198, 3),
(198, 4),
(199, 1),
(199, 3),
(199, 4),
(200, 1),
(200, 3),
(200, 4),
(201, 1),
(201, 3),
(201, 4),
(202, 1),
(202, 3),
(202, 4),
(203, 1),
(203, 3),
(203, 4),
(204, 1),
(204, 3),
(204, 4),
(205, 1),
(205, 4),
(206, 1),
(206, 4),
(207, 1),
(207, 4),
(208, 1),
(208, 4),
(209, 1),
(209, 4),
(210, 1),
(210, 4),
(211, 1),
(211, 4),
(212, 1),
(212, 4),
(213, 1),
(213, 4),
(214, 1),
(214, 4),
(215, 1),
(215, 4),
(216, 1),
(216, 4);

--
-- Dumping data for table `clients`
--
INSERT INTO `clients` (`id`, `user_id`, `name`, `phone_number`, `unique_client_number`, `group_id`, `rate`, `currency`, `created_at`, `updated_at`, `agent_id`) VALUES
(1, 1, 'Admin', '2131', 'Admin', 1, 5, 'EUR', '2024-11-19 08:02:08', '2024-11-19 08:02:08', NULL),
(7, 6, 'Client', '123123123', 'CL-006', 1, 10, 'EUR', '2024-11-21 07:16:18', '2024-11-21 07:16:18', NULL);

--
-- Dumping data for table `address_database`
--
INSERT INTO `address_database` (`id`, `user_id`, `address`, `notes`, `created_at`, `updated_at`) VALUES
(1, 1, 'Lavazza Milano', 'Piazza S. Fedele, 2, 20121 Milano MI', '2024-11-19 09:14:43', '2024-11-21 07:31:11'),
(2, 1, 'Lavazza Roma', 'Vicolo del Conte, 00187 Roma RM', '2024-11-21 07:31:51', '2024-11-21 07:31:51'),
(3, 10, 'Prato - Litto Terazzi', NULL, '2024-11-30 03:43:13', '2024-11-30 03:43:13'),
(4, 10, 'Prato - Macrolotto1', NULL, '2024-11-30 03:43:27', '2024-11-30 03:43:27'),
(5, 10, 'Prato - EuroIngro', NULL, '2024-11-30 03:43:36', '2024-11-30 03:43:36'),
(6, 10, 'Prato - Betty&Co', NULL, '2024-11-30 03:43:48', '2024-11-30 03:43:48'),
(7, 10, 'Prato - CentroMac', NULL, '2024-11-30 03:44:00', '2024-11-30 03:44:00'),
(8, 10, 'Prato - MissFashion', NULL, '2024-11-30 03:44:12', '2024-11-30 03:44:12');

-- Dumping data for table `collectors`
--
INSERT INTO `collectors` (`id`, `user_id`, `name`, `phone_number`, `created_at`, `updated_at`) VALUES
(3, 8, 'Collector', '123123123', '2024-11-21 07:20:20', '2024-11-21 07:20:20');
--
-- Dumping data for table `groups`
--
INSERT INTO `groups` (`id`, `name`, `rate`, `currency`, `group_notes`, `created_at`, `updated_at`) VALUES
(1, 'Newcommers', 11, 'EUR', NULL, '2024-11-21 07:17:24', '2024-12-12 14:51:20'),
(2, 'Оптовики', 10.5, 'EUR', NULL, '2024-12-12 14:51:33', '2024-12-12 14:51:33'),
(3, 'Агенты', 10.3, 'EUR', NULL, '2024-12-12 14:52:02', '2024-12-12 14:52:02'),
(4, 'Соломон агент', 10, 'EUR', 'все клиенты Соломона', '2024-12-12 14:52:29', '2024-12-12 14:52:29'),
(5, 'АгентыПрато', 10.8, 'EUR', NULL, '2025-01-10 08:03:15', '2025-01-10 08:03:15');
--
-- Dumping data for table `transport_operators`
--
INSERT INTO `transport_operators` (`id`, `default`, `name`, `phone_number`, `rate`, `currency`, `created_at`, `updated_at`) VALUES
(1, 1, 'DPA Trans', '123 123 123', 0.4, 'EUR', '2024-11-30 02:33:28', '2024-12-13 10:14:58'),
(2, 0, 'Wietnam Trans', '321 321 321', 0.45, 'EUR', '2024-11-30 02:33:41', '2024-12-13 10:14:58'),
(3, 0, 'MAX-Trans', '500320133', 0.3, 'EUR', '2024-12-12 05:32:49', '2024-12-13 10:14:58');
--
-- Dumping data for table `vehicle_database`
--
INSERT INTO `vehicle_database` (`id`, `vehicle_number`, `vehicle_model`, `assigned_driver`, `is_active`, `vehicle_notes`, `created_at`, `updated_at`) VALUES
(3, 'WU0285H', 'Boxer', 'Boxer', 1, 'Наше авто', '2024-11-30 02:34:50', '2024-11-30 02:34:50'),
(4, 'WU2789J', 'Ducato', 'Ducato', 1, 'Наше авто', '2024-11-30 02:35:21', '2024-12-12 05:33:26'),
(5, 'WI430EM', 'Crafter', 'Polak', 0, 'Авто отдано пользованию поляку', '2024-11-30 02:35:57', '2024-12-12 05:33:18'),
(6, 'MHB025//SM486', 'DAF mega', NULL, 1, 'Прицеп полумега\n+375 29 783-34-06', '2024-12-12 05:34:57', '2024-12-12 05:34:57'),
(7, 'ММВ 025/UR 025', NULL, NULL, 1, NULL, '2024-12-12 05:35:19', '2024-12-13 17:36:04'),
(8, 'MRP623', 'Iveco 5T', NULL, 1, '5ти тонник. Макс загрузка 5,2 в доках 4,95\n+48503704064', '2024-12-12 05:36:20', '2024-12-12 14:52:51');



