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

START TRANSACTION;



--
-- Database: `tracking`
--

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

--
-- Table structure for table `cars`
--

CREATE TABLE `cars` (
  `id` bigint(20) NOT NULL,
  `plate_number` varchar(15) NOT NULL,
  `model` varchar(55) NOT NULL,
  `color` varchar(30) DEFAULT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `driver_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cars`
--

INSERT INTO `cars` (`id`, `plate_number`, `model`, `color`, `contact_person`, `description`, `status`, `created_at`, `updated_at`, `driver_id`) VALUES
(1, '312www', '2021', 'red', '966551543042', '333', 1, '2021-08-18 03:27:33', '2021-08-18 03:27:33', NULL),
(3, '312www', '2021', 'green', '966551543042', '333', 1, '2021-08-18 03:45:45', '2021-09-11 08:06:08', 17),
(5, '312www', '2021', 'green', '966551543042', '333', 2, '2021-08-18 03:45:45', '2021-08-18 03:45:45', NULL),
(7, '2344', '2021', 'green', '966551543042', '333', 1, '2021-08-18 03:45:45', '2021-08-18 03:45:45', NULL),
(8, 'jtyuyk', '2022', 'green', '966551543042', '333', 3, '2021-08-18 03:45:45', '2021-08-18 03:45:45', NULL),
(9, '312www', '2021', 'green', '966551543042', '333', 2, '2021-08-18 03:45:45', '2021-08-18 03:45:45', NULL),
(10, '312www', '2021', 'green', '966551543042', '333', 1, '2021-08-18 03:45:45', '2021-08-18 03:45:45', NULL),
(11, 'gdfgd', '2000', 'green', '966551543042', '333', 2, '2021-08-18 03:45:45', '2021-08-18 03:45:45', NULL),
(12, '312www', '2010', 'green', '966551543042', '333', 1, '2021-08-18 03:45:45', '2021-08-18 03:45:45', NULL),
(13, 'www', '2021', 'black', '966551543042', '333', 3, '2021-08-18 03:45:45', '2021-08-18 03:45:45', NULL),
(14, '312www', '2021', 'green', '966551543042', '333', 2, '2021-08-18 03:45:45', '2021-08-18 03:45:45', NULL),
(15, 'w', 'w', 'w', 'w', '1', 1, '2021-09-09 05:19:51', '2021-09-09 05:19:51', 15),
(16, 'qweqwe', 'qwe', '21231wer', '6545465', '6q5w4e65', 2, '2021-09-11 07:42:59', '2021-09-11 07:42:59', NULL),
(18, '645654', 'qwe', '564654', '654654', '654', 2, '2021-09-11 07:46:30', '2021-09-11 07:46:30', NULL),
(19, 'qwe312', 'qwe', 'qwe', '123', '123', 1, '2021-09-11 07:58:57', '2021-09-11 07:58:57', 15),
(20, '312www', '2021', 'green', '966551543042', '333', 1, '2021-09-11 08:03:44', '2021-09-11 08:03:44', 17),
(21, '312www', '2021', 'green', '966551543042', '333', 1, '2021-09-11 08:04:04', '2021-09-11 08:04:04', 17),
(22, '312www', '2021', 'green', '966551543042', '333', 1, '2021-09-11 08:04:19', '2021-09-11 08:04:19', 15),
(23, '312www', '2021', 'green', '966551543042', '333', 1, '2021-09-11 08:04:31', '2021-09-11 08:04:31', 15),
(24, '312www', '2021', 'green', '966551543042', '333', 1, '2021-09-11 08:04:35', '2021-09-11 08:04:35', 17),
(26, '741', 'Quae consequatur Qu', 'Ipsum eveniet tempo', 'Ut do molestias unde', 'Enim et rem suscipit', 0, '2021-09-18 15:24:17', '2021-09-18 15:24:17', NULL),
(28, '738', 'Voluptate consectetu', 'Et laboriosam quos ', 'Odit mollit ut eum q', 'Elit fuga Illo inc', 1, '2021-09-18 15:30:19', '2021-09-18 15:30:19', NULL),
(29, '613', 'Labore at ipsam qui ', 'Esse laborum Perfer', 'Minim nesciunt magn', 'Dolores veniam cum ', 0, '2021-09-18 15:31:05', '2021-09-18 15:31:05', NULL),
(30, '841', 'Dolor minus in iusto', 'Proident qui rerum ', 'Ex dolores totam sin', 'Molestiae in non rec', 1, '2021-09-18 15:32:00', '2021-09-18 15:32:00', NULL),
(31, '349', 'Velit obcaecati est', 'Aut quod consectetur', 'Commodi dolorum quis', 'Non quis eveniet co', 0, '2021-09-18 15:35:26', '2021-09-18 15:35:26', NULL),
(32, '139345', 'Odio non ea adipiscie', 'red', 'Non quia duis sit q', 'Ad porro veniam fug', 0, '2021-09-18 15:39:51', '2021-09-30 15:05:27', 18);

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

--
-- Table structure for table `car_driver`
--

CREATE TABLE `car_driver` (
  `car_id` int(10) UNSIGNED NOT NULL,
  `driver_id` int(10) UNSIGNED NOT NULL,
  `isLinked` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_driver`
--

INSERT INTO `car_driver` (`car_id`, `driver_id`, `isLinked`, `created_at`, `updated_at`) VALUES
(32, 18, 1, '2021-09-30 14:21:37', '2021-09-30 14:21:37');

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

--
-- Table structure for table `car_link_history`
--

CREATE TABLE `car_link_history` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `car_id` int(11) NOT NULL,
  `driver_id` int(11) NOT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_link_history`
--

INSERT INTO `car_link_history` (`id`, `car_id`, `driver_id`, `action`, `created_at`, `updated_at`) VALUES
(1, 32, 22, 'linked', '2021-09-30 14:21:28', '2021-09-30 14:21:28'),
(2, 32, 22, 'unlinked', '2021-09-30 14:21:33', '2021-09-30 14:21:33'),
(3, 32, 25, 'linked', '2021-09-30 14:21:33', '2021-09-30 14:21:33'),
(4, 32, 25, 'unlinked', '2021-09-30 14:21:37', '2021-09-30 14:21:37'),
(5, 32, 18, 'linked', '2021-09-30 14:21:37', '2021-09-30 14:21:37'),
(6, 20, 23, 'linked', '2021-09-30 14:50:47', '2021-09-30 14:50:47'),
(7, 20, 17, 'unlinked', '2021-09-30 14:50:47', '2021-09-30 14:50:47'),
(8, 20, 18, 'linked', '2021-09-30 14:50:52', '2021-09-30 14:50:52'),
(9, 20, 17, 'unlinked', '2021-09-30 14:50:52', '2021-09-30 14:50:52'),
(10, 32, 20, 'linked', '2021-09-30 14:55:47', '2021-09-30 14:55:47'),
(11, 32, 21, 'linked', '2021-09-30 14:56:30', '2021-09-30 14:56:30'),
(12, 32, 20, 'linked', '2021-09-30 14:57:21', '2021-09-30 14:57:21'),
(13, 32, 22, 'linked', '2021-09-30 14:57:33', '2021-09-30 14:57:33'),
(14, 32, 22, 'linked', '2021-09-30 14:58:35', '2021-09-30 14:58:35'),
(15, 32, 22, 'linked', '2021-09-30 14:58:45', '2021-09-30 14:58:45'),
(16, 32, 21, 'linked', '2021-09-30 15:02:52', '2021-09-30 15:02:52'),
(17, 32, 18, 'linked', '2021-09-30 15:05:27', '2021-09-30 15:05:27'),
(18, 32, 18, 'unlinked', '2021-09-30 15:05:27', '2021-09-30 15:05:27');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(2, 'qwe', 'qwe', '2021-09-11 04:07:43', '2021-09-11 04:07:43'),
(4, 'asd', 'asd', '2021-09-11 04:11:42', '2021-09-11 04:11:42'),
(5, '234', '234', NULL, NULL);

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` bigint(20) NOT NULL,
  `arabic_name` varchar(255) NOT NULL,
  `english_name` varchar(255) NOT NULL,
  `address` text DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `arabic_name`, `english_name`, `address`, `status`, `created_at`, `updated_at`) VALUES
(1, 'test', 'aWadwerwer', 'testww', 1, '2021-09-09 03:43:15', '2021-09-11 12:51:12'),
(7, 'hospital1', 'hospital1', 'hospital1', 1, '2021-09-12 02:07:40', '2021-09-12 02:07:40'),
(8, 'Arabic Name of client', 'Client English name', 'Riyadh', 1, '2021-09-12 02:07:51', '2021-09-12 09:52:11'),
(9, 'Lab 1', 'Lab 1', 'Dammam', 1, '2021-09-12 02:08:03', '2021-09-12 02:08:03'),
(10, 'Lab 2', 'Lab 2', 'Jeddah', 1, '2021-09-12 02:08:19', '2021-09-12 02:08:19'),
(11, 'Lab 3', 'Lab 3', 'Riyadh', 1, '2021-09-12 02:08:27', '2021-09-12 02:08:27'),
(12, 'Ariana Weeks', 'Helen Moore', 'Aspernatur dolorem q', 1, '2021-09-19 13:16:30', '2021-09-19 13:16:30'),
(13, 'Ray Gallagherr', 'Lunea Grant', 'Blanditiis velit ius', 1, '2021-09-19 13:17:06', '2021-09-19 13:22:17');

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

--
-- Table structure for table `client_service`
--

CREATE TABLE `client_service` (
  `service_id` bigint(20) NOT NULL,
  `client_id` bigint(20) NOT NULL,
  `default_price` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `client_service`
--

INSERT INTO `client_service` (`service_id`, `client_id`, `default_price`) VALUES
(3, 1, 500),
(3, 7, 34234),
(3, 13, 434),
(4, 1, 500),
(4, 7, 324),
(4, 13, 500),
(5, 1, 234),
(5, 13, 453354),
(6, 1, 6565),
(6, 7, NULL),
(6, 13, 345345),
(7, 1, 35),
(8, 1, 35354),
(8, 13, 3353),
(9, 1, 4543),
(9, 7, 3434),
(9, 13, 342),
(10, 13, 345345),
(11, 1, 23434),
(11, 7, NULL),
(12, 1, 2344),
(12, 13, 233242),
(13, 13, 233242);

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `containers`
--

CREATE TABLE `containers` (
  `id` bigint(20) NOT NULL,
  `imei` varchar(255) NOT NULL,
  `model` varchar(255) NOT NULL,
  `car_id` bigint(20) NOT NULL,
  `type` enum('ROOM','REFRIGERATE','FROZEN') DEFAULT NULL COMMENT 'ROOM TEMPERATURE (+15C TO +25C)\r\nREFRIGERATE (+2C TO +8C)\r\nFROZEN(0C TO -18C)',
  `description` text DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `containers`
--

INSERT INTO `containers` (`id`, `imei`, `model`, `car_id`, `type`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'asd', 'asd', 3, 'ROOM', 'asdasd', 1, '2021-09-11 10:28:07', '2021-09-11 10:28:07'),
(3, 'asd', 'asd', 7, 'ROOM', 'asd', 1, '2021-09-11 10:58:28', '2021-09-11 10:58:28'),
(4, 'Qui doloribus ut updated', 'Amet Nam aliquip et', 29, 'FROZEN', 'Nemo quisquam lorem ', 1, '2021-10-03 07:02:32', '2021-10-03 07:04:00');

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

--
-- Table structure for table `failed_jobs`
--

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

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

--
-- Table structure for table `geofences`
--

CREATE TABLE `geofences` (
  `id` bigint(20) NOT NULL,
  `area` text NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `geofences`
--

INSERT INTO `geofences` (`id`, `area`, `name`, `description`, `status`, `created_at`, `updated_at`) VALUES
(9, '[{\"lat\":40.933863932753006,\"lng\":-74.25763738930664},{\"lat\":40.95059110161928,\"lng\":-74.24991262734375},{\"lat\":40.95162830591386,\"lng\":-74.23806799233398},{\"lat\":40.93749499604366,\"lng\":-74.2310298758789},{\"lat\":40.93529044570517,\"lng\":-74.23738134682617},{\"lat\":40.933863932753006,\"lng\":-74.25763738930664}]', 'eddsa', 'dsfdsaf', 1, '2021-09-17 13:03:33', '2021-09-17 13:03:33'),
(10, '[{\"lat\":40.940607177154135,\"lng\":-74.26175726235351},{\"lat\":40.938921430588,\"lng\":-74.23446310341797},{\"lat\":40.932048326264535,\"lng\":-74.23978460610351},{\"lat\":40.92867635326948,\"lng\":-74.25059927285156},{\"lat\":40.927898181217245,\"lng\":-74.25986898720703},{\"lat\":40.93529044570517,\"lng\":-74.26484716713867},{\"lat\":40.94073684818489,\"lng\":-74.26707876503906},{\"lat\":40.940607177154135,\"lng\":-74.26175726235351}]', 'dasf', 'dsfsafsa', 1, '2021-09-17 13:49:04', '2021-09-17 13:49:04'),
(11, '[{\"lat\":40.937754350070165,\"lng\":-74.26055563271484},{\"lat\":40.947868362823904,\"lng\":-74.24768102944336},{\"lat\":40.938921430588,\"lng\":-74.23806799233398},{\"lat\":40.937754350070165,\"lng\":-74.26055563271484}]', 'dsafdsf', 'dsfdsfds', 1, '2021-09-17 14:25:31', '2021-09-17 14:25:31'),
(12, '[{\"lat\":40.93801370307836,\"lng\":-74.24441946328125},{\"lat\":40.94670144039958,\"lng\":-74.23205984414062},{\"lat\":40.93853240603988,\"lng\":-74.22416342080078},{\"lat\":40.93191863817756,\"lng\":-74.23137319863281},{\"lat\":40.93801370307836,\"lng\":-74.24441946328125}]', 'eddsa', 'dsfdsaf', 0, '2021-09-17 14:41:02', '2021-09-17 14:41:02');

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

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `client_id` bigint(20) NOT NULL,
  `description` text DEFAULT NULL,
  `lat` double(11,7) NOT NULL,
  `lng` double(11,4) NOT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` time DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `name`, `client_id`, `description`, `lat`, `lng`, `status`, `created_at`, `updated_at`) VALUES
(1, 'test location', 1, 'asdd', 1.0000000, 1.0000, 1, '2021-09-12 04:17:18', NULL),
(2, 'location b', 1, '222', 1.0000000, 2.0000, 1, '2021-09-12 04:32:00', NULL),
(4, 'New york street', 1, 'description', -19.1611104, 142.7994, 1, '2021-09-21 07:59:33', '13:59:33'),
(5, 'Exercitationem deser', 1, 'Dolorum minima dolor', -23.6599829, 142.7115, 1, '2021-09-21 08:01:14', '14:01:14'),
(6, 'my location', 13, 'Location for anik', 42.7263617, -76.0321, 1, '2021-09-24 12:32:21', '18:32:21'),
(7, 'my location 2', 13, 'Location for anik', 42.7818221, -75.9538, 1, '2021-09-24 12:32:47', '18:32:47'),
(8, 'Edited name', 11, 'Suscipit eius amet fdv', 42.7919005, -76.3349, 1, '2021-10-03 06:31:17', '12:35:25');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2021_08_28_081949_create_permission_tables', 1),
(5, '2020_06_24_110922_create_weapons_table', 2),
(6, '2020_06_24_111709_create_user_weapon_table', 2),
(7, '2020_06_28_005157_create_planets_table', 2),
(8, '2020_06_28_155531_create_pages_table', 2),
(9, '2020_07_27_232421_create_regions_table', 2),
(10, '2019_12_14_000001_create_personal_access_tokens_table', 3),
(11, '2021_09_11_100347_create_categories_table', 3),
(13, '2021_09_16_122828_create_notifications_table', 4),
(14, '2021_09_30_185842_create_car_driver_table', 5),
(15, '2021_09_30_201322_create_car_link_history_table', 5);

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

--
-- Table structure for table `model_has_permissions`
--

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

--
-- Dumping data for table `model_has_permissions`
--

INSERT INTO `model_has_permissions` (`permission_id`, `model_type`, `model_id`) VALUES
(2, 'App\\Models\\User', 1),
(3, 'App\\Models\\User', 1);

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

--
-- Table structure for table `model_has_roles`
--

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

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(2, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 8),
(2, 'App\\Models\\User', 9),
(2, 'App\\Models\\User', 10),
(2, 'App\\Models\\User', 11),
(2, 'App\\Models\\User', 16),
(3, 'App\\Models\\User', 1),
(3, 'App\\Models\\User', 6),
(3, 'App\\Models\\User', 7),
(3, 'App\\Models\\User', 8),
(3, 'App\\Models\\User', 9),
(3, 'App\\Models\\User', 10),
(3, 'App\\Models\\User', 14),
(3, 'App\\Models\\User', 15),
(3, 'App\\Models\\User', 16),
(4, 'App\\Models\\User', 7),
(4, 'App\\Models\\User', 8),
(4, 'App\\Models\\User', 9),
(4, 'App\\Models\\User', 13),
(4, 'App\\Models\\User', 16);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `permissions`
--

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

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'manage_user', 'web', '2021-10-07 08:47:15', '2021-10-07 08:47:15'),
(2, 'mange_car', 'web', '2021-10-07 13:11:34', '2021-10-07 13:40:08'),
(3, 'manage_task', 'web', '2021-10-07 13:41:34', '2021-10-07 13:41:34'),
(4, 'manage_report', 'web', '2021-10-07 14:48:48', '2021-10-07 14:49:07');

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

--
-- Table structure for table `pricings`
--

CREATE TABLE `pricings` (
  `id` bigint(20) NOT NULL,
  `type` varchar(100) NOT NULL,
  `name` varchar(200) NOT NULL,
  `fixed_price_value` double DEFAULT 0,
  `km_price` double DEFAULT 0,
  `time_price` double DEFAULT 0,
  `status` varchar(30) NOT NULL DEFAULT 'Enabled',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `pricings`
--

INSERT INTO `pricings` (`id`, `type`, `name`, `fixed_price_value`, `km_price`, `time_price`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Corrupti doloremque', 'Ashton Mann', 0, 0, 0, 'Disabled', '2021-10-01 15:57:40', '2021-10-01 16:01:13'),
(2, 'Harum consequatur e', 'Fiona Horne', 312, 911, 587, 'Enabled', '2021-10-01 16:00:53', '2021-10-01 16:00:53');

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

--
-- Table structure for table `pricing_model_location`
--

CREATE TABLE `pricing_model_location` (
  `location_id` bigint(20) NOT NULL,
  `pricing_model_id` bigint(20) NOT NULL,
  `price` double NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `roles`
--

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

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(2, 'fddfdsfadf', 'web', '2021-10-07 14:42:46', '2021-10-07 14:42:46'),
(3, 'ssfdgfds', 'web', '2021-10-07 14:45:43', '2021-10-07 14:45:43'),
(4, 'administrator', 'web', '2021-10-07 14:51:53', '2021-10-07 15:02:02');

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

--
-- Table structure for table `role_has_permissions`
--

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

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 4),
(2, 3),
(2, 4),
(3, 4);

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

--
-- Table structure for table `samples`
--

CREATE TABLE `samples` (
  `id` bigint(20) NOT NULL,
  `location_id` bigint(20) DEFAULT NULL,
  `qrcode` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) NOT NULL,
  `type` varchar(100) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `type`, `name`, `status`, `created_at`, `updated_at`) VALUES
(3, 'both', 'Both', 1, '2021-09-11 08:51:26', '2021-09-11 08:55:50'),
(4, 'fixed edited', 'Fixed edited', 0, '2021-09-11 09:28:52', '2021-09-19 14:47:14'),
(5, 'Debitis quia quasi m', 'Amaya Wilson', 0, '2021-09-19 14:46:27', '2021-09-19 14:46:27'),
(6, 'Esse possimus omni', 'Alan David', 1, '2021-09-19 15:55:04', '2021-09-19 15:55:04'),
(7, 'Et est error aperiam', 'Madonna Gray', 1, '2021-09-19 15:57:08', '2021-09-19 15:57:08'),
(8, 'Quia laudantium tot', 'Tanner Beck', 0, '2021-09-19 15:58:07', '2021-09-19 15:58:07'),
(9, 'Eu elit deserunt co', 'Tobias Higgins', 1, '2021-09-19 15:58:44', '2021-09-19 15:58:44'),
(10, 'Commodi quas illo it', 'Sebastian Barnes', 1, '2021-09-19 16:10:05', '2021-09-19 16:10:05'),
(11, 'Explicabo Doloribus', 'Xenos Ashley', 1, '2021-09-19 16:19:43', '2021-09-19 16:19:43'),
(12, 'Culpa itaque eligend', 'Guy Manning', 1, '2021-09-19 16:21:44', '2021-09-19 16:21:44'),
(13, 'Quod qui doloremque ', 'Chiquita Evans', 0, '2021-09-19 16:24:01', '2021-09-19 16:24:01');

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` bigint(20) NOT NULL,
  `from_location` bigint(20) NOT NULL,
  `to_location` bigint(20) NOT NULL,
  `cost` double NOT NULL,
  `billing_client` bigint(20) DEFAULT NULL,
  `driver_id` bigint(20) DEFAULT NULL,
  `type` enum('one_time','scheduled','','') NOT NULL DEFAULT 'one_time',
  `time_of_visit` datetime DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` enum('Closed','Opened','Completed','Cancelled') DEFAULT 'Opened',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`id`, `from_location`, `to_location`, `cost`, `billing_client`, `driver_id`, `type`, `time_of_visit`, `start_date`, `end_date`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1833, 10, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-26 22:47:58', '2021-09-24 14:27:52'),
(2, 1, 1, 1810, 1, 18, 'one_time', NULL, NULL, NULL, 'Descirption', 'Completed', '2021-04-14 06:21:21', '2021-09-30 06:17:59'),
(3, 2, 1, 2606, 10, 23, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-07-22 10:23:20', '2021-09-24 14:27:52'),
(4, 2, 1, 4278, 1, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-21 08:50:09', '2021-09-24 14:27:53'),
(5, 1, 2, 1959, 7, 21, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-08-03 14:38:42', '2021-09-24 14:27:53'),
(6, 1, 1, 2895, 10, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-28 16:26:19', '2021-09-24 14:27:53'),
(7, 2, 1, 1712, 10, 21, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-05-09 06:33:59', '2021-09-24 14:27:53'),
(8, 1, 2, 2974, 12, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-05-15 08:36:03', '2021-09-24 14:27:53'),
(9, 1, 2, 4628, 11, 24, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-09-05 21:45:28', '2021-09-24 14:27:53'),
(10, 2, 2, 2044, 11, 24, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-21 06:15:17', '2021-09-24 14:27:53'),
(11, 1, 1, 1721, 7, 23, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-28 18:25:15', '2021-09-24 14:27:53'),
(12, 1, 2, 782, 13, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-27 19:04:13', '2021-09-24 14:27:53'),
(13, 1, 2, 82, 12, 20, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-01 20:36:27', '2021-09-24 14:27:53'),
(14, 2, 1, 1274, 8, 20, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-30 13:34:53', '2021-09-24 14:27:53'),
(15, 2, 2, 3408, 8, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-18 20:36:06', '2021-09-24 14:27:53'),
(16, 1, 2, 868, 10, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-27 03:33:36', '2021-09-24 14:27:53'),
(17, 1, 1, 1099, 12, 24, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-22 10:35:46', '2021-09-24 14:27:53'),
(18, 2, 1, 2878, 8, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-04-18 12:37:59', '2021-09-24 14:27:53'),
(19, 1, 2, 3180, 12, 15, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-02-03 20:22:09', '2021-09-24 14:27:53'),
(20, 1, 2, 1618, 10, 22, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-09-02 11:23:20', '2021-09-24 14:27:53'),
(21, 1, 1, 804, 13, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-04-25 06:18:10', '2021-09-24 14:27:53'),
(22, 2, 1, 3959, 11, 15, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-05-29 12:04:52', '2021-09-24 14:27:53'),
(23, 2, 1, 4879, 10, 25, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-19 23:07:11', '2021-09-24 14:27:53'),
(24, 1, 2, 319, 10, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-17 12:48:51', '2021-09-24 14:27:53'),
(25, 2, 2, 3798, 7, 22, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-09-08 18:01:21', '2021-09-24 14:27:53'),
(26, 1, 1, 1351, 12, 20, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-21 16:42:15', '2021-09-24 14:27:53'),
(27, 2, 1, 517, 13, 22, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-25 02:00:10', '2021-09-24 14:27:53'),
(28, 2, 2, 1485, 10, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-20 12:34:12', '2021-09-24 14:27:53'),
(29, 2, 1, 87, 9, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-04-03 16:32:53', '2021-09-24 14:27:53'),
(30, 1, 2, 3063, 12, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-05-03 06:48:45', '2021-09-24 14:27:53'),
(31, 2, 2, 3278, 13, 25, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-02-20 19:01:05', '2021-09-24 14:27:53'),
(32, 1, 2, 2366, 11, 25, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-07-22 17:02:36', '2021-09-24 14:27:53'),
(33, 2, 2, 2393, 8, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-13 02:33:31', '2021-09-24 14:27:53'),
(34, 2, 1, 3258, 13, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-12 07:13:54', '2021-09-24 14:27:53'),
(35, 2, 2, 3259, 10, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-03-13 22:58:55', '2021-09-24 14:27:53'),
(36, 2, 2, 3616, 8, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-01-28 20:41:01', '2021-09-24 14:27:53'),
(37, 2, 1, 3072, 7, 22, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-14 04:40:19', '2021-09-24 14:27:53'),
(38, 1, 2, 2155, 11, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-08-06 19:35:12', '2021-09-24 14:27:53'),
(39, 1, 1, 4389, 12, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-06-02 15:40:58', '2021-09-24 14:27:53'),
(40, 1, 1, 3535, 13, 22, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-03-01 14:57:35', '2021-09-24 14:27:53'),
(41, 2, 2, 2414, 8, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-05-27 02:16:21', '2021-09-24 14:27:53'),
(42, 2, 1, 26, 1, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-02-19 11:49:43', '2021-09-24 14:27:53'),
(43, 1, 2, 3452, 10, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-29 05:06:16', '2021-09-24 14:27:53'),
(44, 1, 2, 223, 1, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-06 13:16:12', '2021-09-24 14:27:53'),
(45, 1, 1, 306, 8, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-08-25 17:41:28', '2021-09-24 14:27:53'),
(46, 1, 2, 11, 11, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-10 09:53:01', '2021-09-24 14:27:54'),
(47, 1, 2, 3876, 9, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-07-27 10:47:40', '2021-09-24 14:27:54'),
(48, 1, 1, 2441, 8, 17, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-24 11:53:46', '2021-09-24 14:27:54'),
(49, 2, 2, 2375, 11, 22, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-09-16 19:40:42', '2021-09-24 14:27:54'),
(50, 2, 2, 2788, 9, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-05-24 07:25:04', '2021-09-24 14:27:54'),
(51, 2, 1, 3111, 9, 17, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-02-06 01:45:37', '2021-09-24 14:27:54'),
(52, 1, 1, 1840, 10, 24, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-09 03:56:43', '2021-09-24 14:27:54'),
(53, 1, 1, 2655, 7, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-03-14 23:02:13', '2021-09-24 14:27:54'),
(54, 1, 1, 3687, 12, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-06-18 21:10:38', '2021-09-24 14:27:54'),
(55, 1, 1, 662, 8, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-04-10 00:44:35', '2021-09-24 14:27:54'),
(56, 2, 2, 4580, 11, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-02-16 14:46:59', '2021-09-24 14:27:54'),
(57, 2, 2, 2819, 12, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-26 13:08:47', '2021-09-24 14:27:54'),
(58, 1, 2, 2235, 13, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-05-20 18:45:38', '2021-09-24 14:27:54'),
(59, 2, 1, 533, 10, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-15 23:34:01', '2021-09-24 14:27:54'),
(60, 1, 1, 925, 12, 22, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-27 18:37:05', '2021-09-24 14:27:54'),
(61, 2, 2, 169, 13, 22, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-08-23 17:46:28', '2021-09-24 14:27:54'),
(62, 1, 1, 4949, 13, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-01-27 20:16:21', '2021-09-24 14:27:54'),
(63, 1, 1, 2692, 9, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-09-11 22:03:23', '2021-09-24 14:27:54'),
(64, 1, 2, 1773, 10, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-09-20 20:15:02', '2021-09-24 14:27:54'),
(65, 2, 1, 2065, 7, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-24 22:25:08', '2021-09-24 14:27:54'),
(66, 1, 2, 3737, 11, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-09-01 19:04:18', '2021-09-24 14:27:54'),
(67, 2, 1, 152, 1, 20, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-27 02:30:47', '2021-09-24 14:27:54'),
(68, 2, 1, 4470, 9, 23, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-05-17 02:05:31', '2021-09-24 14:27:55'),
(69, 1, 2, 3353, 8, 21, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-05-05 13:50:31', '2021-09-24 14:27:55'),
(70, 1, 1, 927, 10, 20, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-09-13 22:58:48', '2021-09-24 14:27:55'),
(71, 2, 1, 275, 8, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-17 21:51:48', '2021-09-24 14:27:55'),
(72, 2, 1, 1317, 10, 25, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-02 06:38:10', '2021-09-24 14:27:55'),
(73, 2, 2, 451, 8, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-12 02:15:00', '2021-09-24 14:27:55'),
(74, 2, 1, 3480, 9, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-12 12:18:00', '2021-09-24 14:27:55'),
(75, 1, 2, 2744, 13, 24, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-09-19 11:39:57', '2021-09-24 14:27:55'),
(76, 1, 1, 2768, 13, 17, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-05-10 14:22:54', '2021-09-24 14:27:55'),
(77, 2, 1, 2016, 10, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-28 01:38:07', '2021-09-24 14:27:55'),
(78, 2, 1, 3765, 7, 23, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-09-06 12:57:01', '2021-09-24 14:27:55'),
(79, 1, 2, 4119, 12, 23, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-11 00:39:34', '2021-09-24 14:27:55'),
(80, 1, 2, 2665, 12, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-02-07 14:36:47', '2021-09-24 14:27:55'),
(81, 2, 2, 3759, 7, 23, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-06-20 07:17:54', '2021-09-24 14:27:55'),
(82, 2, 2, 1853, 1, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-02-26 02:14:10', '2021-09-24 14:27:55'),
(83, 1, 2, 522, 11, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-09-18 10:23:05', '2021-09-24 14:27:55'),
(84, 1, 2, 512, 1, 21, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-05-19 17:34:04', '2021-09-24 14:27:55'),
(85, 1, 2, 3611, 13, 20, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-08 16:26:21', '2021-09-24 14:27:55'),
(86, 2, 1, 1259, 7, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-02 23:51:04', '2021-09-24 14:27:55'),
(87, 1, 2, 4870, 12, 22, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-04 16:20:30', '2021-09-24 14:27:55'),
(88, 1, 2, 2972, 7, 25, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-02-22 05:00:34', '2021-09-24 14:27:55'),
(89, 1, 2, 283, 1, 23, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-28 08:10:18', '2021-09-24 14:27:55'),
(90, 1, 1, 590, 8, 25, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-04 09:32:04', '2021-09-24 14:27:55'),
(91, 1, 2, 1318, 9, 24, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-03-01 03:02:38', '2021-09-24 14:27:55'),
(92, 1, 1, 2471, 9, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-30 07:54:31', '2021-09-24 14:27:55'),
(93, 1, 2, 1048, 1, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-05-28 10:11:21', '2021-09-24 14:27:55'),
(94, 2, 2, 4847, 7, 24, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-05-26 08:12:51', '2021-09-24 14:27:55'),
(95, 1, 1, 2565, 9, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-24 09:31:25', '2021-09-24 14:27:55'),
(96, 2, 1, 3811, 1, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-05 10:56:28', '2021-09-24 14:27:55'),
(97, 2, 2, 3259, 10, 22, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-08-05 21:55:56', '2021-09-24 14:27:55'),
(98, 1, 2, 3814, 7, 24, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-08-27 23:30:45', '2021-09-24 14:27:55'),
(99, 1, 1, 94, 7, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-26 11:16:09', '2021-09-24 14:27:55'),
(100, 2, 1, 1183, 9, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-05 06:09:16', '2021-09-24 14:27:55'),
(101, 2, 1, 4865, 9, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-28 17:41:57', '2021-09-24 14:27:56'),
(102, 1, 2, 1141, 9, 17, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-16 18:58:47', '2021-09-24 14:27:56'),
(103, 1, 1, 4008, 1, 20, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-08-27 06:43:48', '2021-09-24 14:27:56'),
(104, 1, 1, 1747, 1, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-07-10 09:13:33', '2021-09-24 14:27:56'),
(105, 1, 2, 3575, 8, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-08-17 08:26:19', '2021-09-24 14:27:56'),
(106, 2, 1, 2484, 9, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-06-30 14:27:58', '2021-09-24 14:27:56'),
(107, 1, 1, 2146, 9, 18, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-21 01:43:38', '2021-09-24 14:27:56'),
(108, 2, 2, 330, 7, 23, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-02-23 21:41:00', '2021-09-24 14:27:56'),
(109, 2, 1, 1458, 7, 23, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-14 16:09:47', '2021-09-24 14:27:56'),
(110, 2, 2, 4319, 10, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-05-01 01:14:29', '2021-09-24 14:27:56'),
(111, 2, 1, 3667, 9, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-08-08 15:33:15', '2021-09-24 14:27:56'),
(112, 1, 1, 2973, 13, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-19 23:38:25', '2021-09-24 14:27:56'),
(113, 1, 2, 2172, 10, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-07 13:26:50', '2021-09-24 14:27:56'),
(114, 2, 1, 2056, 12, 22, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-09-06 04:37:17', '2021-09-24 14:27:56'),
(115, 2, 2, 2200, 8, 18, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-06-25 07:13:48', '2021-09-24 14:27:56'),
(116, 2, 2, 3341, 10, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-14 18:31:09', '2021-09-24 14:27:56'),
(117, 1, 2, 1667, 7, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-18 02:58:20', '2021-09-24 14:27:56'),
(118, 1, 2, 3643, 13, 23, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-23 18:56:19', '2021-09-24 14:27:56'),
(119, 2, 1, 922, 11, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-09-15 05:04:07', '2021-09-24 14:27:56'),
(120, 2, 2, 664, 12, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-18 19:53:20', '2021-09-24 14:27:56'),
(121, 2, 1, 2220, 13, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-12 19:24:55', '2021-09-24 14:27:56'),
(122, 2, 2, 4053, 10, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-14 02:15:33', '2021-09-24 14:27:56'),
(123, 1, 2, 1830, 9, 25, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-06-04 11:16:04', '2021-09-24 14:27:56'),
(124, 2, 1, 4831, 9, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-24 11:29:02', '2021-09-24 14:27:56'),
(125, 2, 2, 3039, 9, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-07-23 12:04:28', '2021-09-24 14:27:56'),
(126, 1, 2, 4987, 10, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-16 03:59:15', '2021-09-24 14:27:56'),
(127, 2, 1, 2202, 1, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-31 16:45:08', '2021-09-24 14:27:56'),
(128, 1, 2, 4987, 12, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-07-14 19:09:41', '2021-09-24 14:27:56'),
(129, 2, 2, 2841, 1, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-19 15:49:22', '2021-09-24 14:27:56'),
(130, 2, 1, 2452, 7, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-07-04 17:37:10', '2021-09-24 14:27:56'),
(131, 2, 2, 1774, 12, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-01 19:06:26', '2021-09-24 14:27:56'),
(132, 1, 1, 1279, 11, 15, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-07-04 17:14:45', '2021-09-24 14:27:56'),
(133, 2, 2, 1052, 11, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-15 23:56:34', '2021-09-24 14:27:56'),
(134, 1, 2, 4047, 7, 25, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-20 13:43:44', '2021-09-24 14:27:56'),
(135, 2, 1, 3524, 7, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-04-29 06:09:21', '2021-09-24 14:27:56'),
(136, 2, 2, 3741, 11, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-17 08:04:31', '2021-09-24 14:27:56'),
(137, 1, 2, 3747, 13, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-08-26 14:46:40', '2021-09-24 14:27:56'),
(138, 2, 1, 2647, 11, 25, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-31 04:59:47', '2021-09-24 14:27:56'),
(139, 1, 2, 3583, 8, 22, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-13 14:47:02', '2021-09-24 14:27:56'),
(140, 2, 1, 2135, 11, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-05-11 01:11:45', '2021-09-24 14:27:56'),
(141, 2, 2, 792, 10, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-08-29 06:25:38', '2021-09-24 14:27:56'),
(142, 2, 1, 1059, 7, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-08-25 23:00:17', '2021-09-24 14:27:56'),
(143, 2, 1, 1834, 7, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-04-07 22:17:43', '2021-09-24 14:27:57'),
(144, 2, 2, 1009, 7, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-14 00:07:18', '2021-09-24 14:27:57'),
(145, 2, 2, 659, 7, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-06-29 11:44:14', '2021-09-24 14:27:57'),
(146, 2, 2, 1796, 7, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-07-26 02:30:59', '2021-09-24 14:27:57'),
(147, 2, 1, 302, 10, 25, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-06-24 09:11:16', '2021-09-24 14:27:57'),
(148, 1, 2, 336, 11, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-06-05 17:27:08', '2021-09-24 14:27:57'),
(149, 2, 2, 2616, 13, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-28 17:49:37', '2021-09-24 14:27:57'),
(150, 1, 2, 2353, 13, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-03 02:54:39', '2021-09-24 14:27:57'),
(151, 2, 2, 4136, 10, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-20 17:25:37', '2021-09-24 14:27:57'),
(152, 2, 2, 2082, 7, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-08-21 17:37:52', '2021-09-24 14:27:57'),
(153, 1, 2, 3819, 12, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-17 06:27:13', '2021-09-24 14:27:57'),
(154, 1, 1, 4243, 8, 23, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-09-02 04:57:54', '2021-09-24 14:27:57'),
(155, 2, 1, 1288, 7, 23, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-09-12 12:14:06', '2021-09-24 14:27:57'),
(156, 2, 1, 1125, 11, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-22 02:56:46', '2021-09-24 14:27:57'),
(157, 2, 1, 2200, 13, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-08-02 01:58:12', '2021-09-24 14:27:57'),
(158, 1, 1, 4744, 9, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-07-12 14:26:26', '2021-09-24 14:27:57'),
(159, 1, 2, 2087, 11, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-02-21 01:14:28', '2021-09-24 14:27:57'),
(160, 2, 1, 4036, 13, 20, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-07-02 06:16:16', '2021-09-24 14:27:57'),
(161, 2, 2, 923, 1, 24, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-19 09:29:34', '2021-09-24 14:27:57'),
(162, 1, 2, 3735, 11, 20, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-05-06 06:08:33', '2021-09-24 14:27:57'),
(163, 1, 2, 1221, 11, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-29 23:17:12', '2021-09-24 14:27:57'),
(164, 2, 1, 3620, 8, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-23 22:20:45', '2021-09-24 14:27:57'),
(165, 1, 2, 3858, 1, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-29 16:51:25', '2021-09-24 14:27:57'),
(166, 1, 1, 3587, 9, 24, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-19 08:37:58', '2021-09-24 14:27:57'),
(167, 1, 1, 824, 7, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-12 01:17:32', '2021-09-24 14:27:57'),
(168, 2, 2, 3817, 1, 20, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-02-14 10:09:59', '2021-09-24 14:27:57'),
(169, 1, 1, 4192, 7, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-20 13:34:38', '2021-09-24 14:27:57'),
(170, 2, 1, 4289, 8, 21, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-10 13:10:13', '2021-09-24 14:27:57'),
(171, 1, 1, 3111, 11, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-12 02:03:45', '2021-09-24 14:27:57'),
(172, 1, 1, 4000, 9, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-05 16:47:29', '2021-09-24 14:27:57'),
(173, 2, 2, 4028, 13, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-04 08:22:47', '2021-09-24 14:27:57'),
(174, 2, 1, 639, 12, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-08-09 16:38:57', '2021-09-24 14:27:57'),
(175, 2, 2, 4613, 10, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-08-01 01:45:11', '2021-09-24 14:27:57'),
(176, 1, 1, 330, 9, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-08-12 21:56:15', '2021-09-24 14:27:57'),
(177, 2, 1, 4671, 8, 25, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-06-15 05:42:16', '2021-09-24 14:27:57'),
(178, 1, 2, 2784, 10, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-13 03:57:35', '2021-09-24 14:27:57'),
(179, 1, 1, 3052, 13, 21, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-16 05:41:33', '2021-09-24 14:27:57'),
(180, 1, 1, 3394, 13, 22, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-04-13 18:01:11', '2021-09-24 14:27:57'),
(181, 2, 2, 4663, 7, 25, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-15 12:13:45', '2021-09-24 14:27:57'),
(182, 2, 2, 95, 7, 23, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-01 20:39:22', '2021-09-24 14:27:57'),
(183, 2, 2, 4718, 10, 20, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-08 10:58:18', '2021-09-24 14:27:57'),
(184, 1, 2, 819, 12, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-28 21:29:50', '2021-09-24 14:27:57'),
(185, 1, 1, 4635, 11, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-08-31 21:24:15', '2021-09-24 14:27:57'),
(186, 2, 1, 3863, 13, 20, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-02-15 22:34:30', '2021-09-24 14:27:57'),
(187, 1, 1, 3092, 13, 20, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-05 19:27:05', '2021-09-24 14:27:57'),
(188, 1, 2, 1885, 7, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-07 05:49:01', '2021-09-24 14:27:57'),
(189, 2, 2, 628, 7, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-18 01:34:26', '2021-09-24 14:27:58'),
(190, 2, 1, 4111, 1, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-09 11:02:25', '2021-09-24 14:27:58'),
(191, 1, 1, 258, 9, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-08-27 08:31:54', '2021-09-24 14:27:58'),
(192, 2, 1, 1493, 1, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-14 16:20:01', '2021-09-24 14:27:58'),
(193, 2, 1, 3166, 13, 17, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-09-07 13:29:46', '2021-09-24 14:27:58'),
(194, 2, 2, 1223, 7, 23, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-31 01:55:33', '2021-09-24 14:27:58'),
(195, 1, 1, 3906, 12, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-09 19:04:51', '2021-09-24 14:27:58'),
(196, 1, 2, 1427, 9, 22, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-08-10 04:48:40', '2021-09-24 14:27:58'),
(197, 2, 1, 3354, 1, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-04-28 01:24:22', '2021-09-24 14:27:58'),
(198, 2, 2, 694, 12, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-04-10 04:40:26', '2021-09-24 14:27:58'),
(199, 1, 1, 857, 9, 23, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-05-30 00:13:14', '2021-09-24 14:27:58'),
(200, 1, 2, 177, 8, 22, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-04-27 22:53:36', '2021-09-24 14:27:58'),
(201, 2, 2, 3912, 12, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-09-19 17:18:05', '2021-09-24 14:27:58'),
(202, 2, 2, 1630, 7, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-08-07 09:13:35', '2021-09-24 14:27:58'),
(203, 2, 1, 2688, 12, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-02-04 20:26:14', '2021-09-24 14:27:58'),
(204, 2, 1, 3880, 8, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-08-04 20:12:03', '2021-09-24 14:27:58'),
(205, 1, 1, 273, 12, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-06-07 12:20:17', '2021-09-24 14:27:58'),
(206, 2, 1, 4931, 11, 22, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-06-21 20:44:49', '2021-09-24 14:27:58'),
(207, 2, 1, 282, 13, 23, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-20 22:41:08', '2021-09-24 14:27:58'),
(208, 2, 2, 4887, 12, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-05-27 14:40:06', '2021-09-24 14:27:58'),
(209, 2, 2, 4074, 1, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-19 17:25:47', '2021-09-24 14:27:58'),
(210, 2, 2, 1663, 13, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-04-11 00:11:13', '2021-09-24 14:27:58'),
(211, 2, 2, 1114, 9, 23, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-02-24 20:32:59', '2021-09-24 14:27:58'),
(212, 2, 1, 3428, 11, 24, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-02-25 17:19:37', '2021-09-24 14:27:58'),
(213, 2, 1, 121, 13, 17, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-07 20:31:30', '2021-09-24 14:27:58'),
(214, 2, 1, 2622, 11, 17, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-05-21 04:14:39', '2021-09-24 14:27:58'),
(215, 1, 1, 1360, 10, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-16 08:41:42', '2021-09-24 14:27:58'),
(216, 1, 1, 4878, 9, 18, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-08-23 23:38:38', '2021-09-24 14:27:58'),
(217, 2, 2, 950, 1, 23, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-03-19 04:58:49', '2021-09-24 14:27:58'),
(218, 2, 1, 4787, 11, 24, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-08-14 13:41:37', '2021-09-24 14:27:58'),
(219, 2, 2, 2124, 9, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-10 08:41:18', '2021-09-24 14:27:58'),
(220, 1, 1, 1275, 11, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-08-31 16:26:20', '2021-09-24 14:27:58'),
(221, 1, 2, 440, 13, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-05-04 08:03:47', '2021-09-24 14:27:58'),
(222, 1, 2, 928, 11, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-05 14:18:29', '2021-09-24 14:27:58'),
(223, 2, 2, 2350, 8, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-04 20:50:16', '2021-09-24 14:27:58'),
(224, 2, 1, 245, 11, 25, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-04 01:57:14', '2021-09-24 14:27:58'),
(225, 2, 2, 4872, 13, 17, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-06 00:46:18', '2021-09-24 14:27:58'),
(226, 2, 1, 1645, 7, 22, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-19 09:28:14', '2021-09-24 14:27:58'),
(227, 1, 1, 458, 11, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-03-11 09:52:23', '2021-09-24 14:27:58'),
(228, 1, 2, 1349, 13, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-12 08:57:29', '2021-09-24 14:27:58'),
(229, 1, 1, 3752, 12, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-17 06:32:01', '2021-09-24 14:27:58'),
(230, 1, 2, 714, 12, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-16 03:01:13', '2021-09-24 14:27:58'),
(231, 1, 1, 4255, 10, 24, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-08-26 18:38:02', '2021-09-24 14:27:58'),
(232, 1, 2, 3410, 7, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-01-27 19:27:00', '2021-09-24 14:27:58'),
(233, 2, 2, 1369, 1, 20, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-06 12:42:07', '2021-09-24 14:27:58'),
(234, 2, 2, 3300, 1, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-23 12:30:08', '2021-09-24 14:27:58'),
(235, 2, 2, 3300, 12, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-08-16 03:06:54', '2021-09-24 14:27:58'),
(236, 1, 1, 116, 10, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-22 18:12:16', '2021-09-24 14:27:58'),
(237, 2, 2, 2139, 12, 25, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-08-09 07:14:37', '2021-09-24 14:27:58'),
(238, 2, 2, 2795, 7, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-28 01:35:11', '2021-09-24 14:27:58'),
(239, 2, 2, 4289, 8, 25, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-27 07:51:46', '2021-09-24 14:27:58'),
(240, 2, 2, 979, 9, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-04-19 21:25:46', '2021-09-24 14:27:58'),
(241, 1, 2, 1586, 9, 23, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-03 11:51:14', '2021-09-24 14:27:58'),
(242, 1, 1, 1925, 13, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-06-07 20:06:01', '2021-09-24 14:27:58'),
(243, 2, 2, 400, 12, 25, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-22 12:31:01', '2021-09-24 14:27:59'),
(244, 2, 1, 1865, 7, 24, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-19 11:08:40', '2021-09-24 14:27:59'),
(245, 1, 1, 1871, 9, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-17 18:35:47', '2021-09-24 14:27:59'),
(246, 1, 1, 4930, 7, 23, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-27 16:06:38', '2021-09-24 14:27:59'),
(247, 1, 1, 291, 11, 25, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-09-07 20:32:38', '2021-09-24 14:27:59'),
(248, 1, 1, 2967, 11, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-05-16 04:44:44', '2021-09-24 14:27:59'),
(249, 2, 2, 2787, 9, 20, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-13 12:29:46', '2021-09-24 14:27:59'),
(250, 2, 2, 4076, 8, 17, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-08 01:18:20', '2021-09-24 14:27:59'),
(251, 1, 1, 4398, 1, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-01-01 13:24:40', '2021-09-24 14:27:59'),
(252, 2, 2, 4941, 8, 23, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-23 20:45:57', '2021-09-24 14:27:59'),
(253, 1, 1, 4737, 7, 20, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-14 22:53:16', '2021-09-24 14:27:59'),
(254, 1, 2, 1178, 13, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-21 19:41:01', '2021-09-24 14:27:59'),
(255, 2, 1, 2003, 1, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-18 03:58:31', '2021-09-24 14:27:59'),
(256, 2, 2, 2917, 13, 25, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-08-09 09:58:05', '2021-09-24 14:27:59'),
(257, 1, 1, 16, 10, 15, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-05-13 13:06:47', '2021-09-24 14:27:59'),
(258, 1, 2, 4779, 7, 20, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-08-01 11:48:50', '2021-09-24 14:27:59'),
(259, 2, 2, 86, 1, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-05-03 05:05:30', '2021-09-24 14:27:59'),
(260, 2, 2, 3405, 9, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-07-22 13:28:31', '2021-09-24 14:27:59'),
(261, 2, 2, 2342, 11, 20, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-06 19:12:22', '2021-09-24 14:27:59'),
(262, 1, 2, 714, 1, 18, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-06-08 06:30:06', '2021-09-24 14:27:59'),
(263, 2, 2, 4098, 10, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-09-19 04:42:03', '2021-09-24 14:27:59'),
(264, 1, 1, 4101, 11, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-19 07:27:45', '2021-09-24 14:27:59'),
(265, 2, 2, 1810, 8, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-01-21 13:55:23', '2021-09-24 14:27:59'),
(266, 1, 1, 1622, 13, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-05-05 13:42:36', '2021-09-24 14:27:59'),
(267, 1, 1, 3986, 8, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-08-11 07:13:02', '2021-09-24 14:27:59'),
(268, 2, 2, 4183, 10, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-02 04:50:44', '2021-09-24 14:27:59'),
(269, 2, 1, 330, 12, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-25 19:27:24', '2021-09-24 14:27:59'),
(270, 2, 1, 443, 11, 18, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-01-23 08:44:31', '2021-09-24 14:27:59'),
(271, 1, 2, 3282, 8, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-09 01:54:20', '2021-09-24 14:27:59'),
(272, 2, 1, 2305, 13, 17, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-03 15:56:00', '2021-09-24 14:27:59'),
(273, 2, 1, 36, 7, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-09 23:16:39', '2021-09-24 14:27:59'),
(274, 1, 1, 2800, 7, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-28 13:27:59', '2021-09-24 14:27:59'),
(275, 1, 2, 3555, 10, 23, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-23 02:04:25', '2021-09-24 14:27:59'),
(276, 1, 2, 2138, 1, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-08-01 15:13:27', '2021-09-24 14:27:59'),
(277, 2, 2, 4368, 8, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-03 06:39:40', '2021-09-24 14:27:59'),
(278, 2, 1, 3664, 13, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-29 20:26:12', '2021-09-24 14:27:59'),
(279, 2, 2, 223, 9, 24, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-15 06:28:11', '2021-09-24 14:27:59'),
(280, 2, 1, 4533, 8, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-27 02:34:01', '2021-09-24 14:27:59'),
(281, 1, 1, 3334, 11, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-21 20:13:00', '2021-09-24 14:28:00'),
(282, 1, 2, 2808, 9, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-02-25 13:03:09', '2021-09-24 14:28:00'),
(283, 1, 2, 2225, 13, 24, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-17 04:35:15', '2021-09-24 14:28:00'),
(284, 1, 2, 4738, 11, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-04-15 15:25:55', '2021-09-24 14:28:00'),
(285, 2, 2, 3786, 12, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-06-22 07:15:20', '2021-09-24 14:28:00'),
(286, 1, 2, 437, 13, 25, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-02-09 05:23:17', '2021-09-24 14:28:00'),
(287, 2, 1, 231, 9, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-08 17:28:37', '2021-09-24 14:28:00'),
(288, 1, 2, 1591, 7, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-21 16:02:26', '2021-09-24 14:28:00'),
(289, 1, 1, 1320, 7, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-09-11 12:25:54', '2021-09-24 14:28:00'),
(290, 1, 1, 4888, 9, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-01-30 01:26:38', '2021-09-24 14:28:00'),
(291, 1, 1, 65, 11, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-03 21:57:37', '2021-09-24 14:28:00'),
(292, 2, 1, 4637, 9, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-09-06 18:41:53', '2021-09-24 14:28:00'),
(293, 1, 2, 2700, 10, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-09-18 08:02:47', '2021-09-24 14:28:00'),
(294, 1, 2, 1416, 13, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-13 17:09:29', '2021-09-24 14:28:00'),
(295, 1, 1, 4574, 11, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-08-18 09:51:10', '2021-09-24 14:28:00'),
(296, 1, 2, 1101, 11, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-07-27 20:56:38', '2021-09-24 14:28:00'),
(297, 2, 1, 3630, 8, 23, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-18 00:08:38', '2021-09-24 14:28:00'),
(298, 1, 2, 3514, 12, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-02-27 08:35:13', '2021-09-24 14:28:00'),
(299, 1, 1, 4169, 7, 23, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-04-18 05:09:49', '2021-09-24 14:28:00'),
(300, 2, 2, 4676, 10, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-22 16:03:15', '2021-09-24 14:28:00'),
(301, 2, 1, 4698, 1, 18, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-03-28 05:49:34', '2021-09-24 14:28:00'),
(302, 2, 1, 348, 1, 24, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-20 13:51:08', '2021-09-24 14:28:00'),
(303, 1, 2, 1310, 9, 20, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-05-14 21:11:16', '2021-09-24 14:28:00'),
(304, 2, 1, 1948, 7, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-25 18:56:15', '2021-09-24 14:28:00'),
(305, 2, 2, 2757, 10, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-19 09:05:18', '2021-09-24 14:28:00'),
(306, 2, 1, 2705, 13, 22, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-04-25 03:11:54', '2021-09-24 14:28:00'),
(307, 2, 1, 1169, 7, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-03-19 19:32:06', '2021-09-24 14:28:00'),
(308, 2, 2, 1940, 13, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-30 21:59:52', '2021-09-24 14:28:00'),
(309, 1, 1, 1010, 7, 20, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-29 09:22:13', '2021-09-24 14:28:00'),
(310, 1, 1, 4958, 7, 25, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-03 04:43:03', '2021-09-24 14:28:00'),
(311, 1, 1, 4002, 10, 18, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-07-27 00:49:58', '2021-09-24 14:28:01'),
(312, 1, 2, 1547, 12, 25, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-18 19:03:05', '2021-09-24 14:28:01'),
(313, 1, 2, 4671, 7, 22, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-17 01:51:15', '2021-09-24 14:28:01'),
(314, 1, 2, 2137, 13, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-02-13 15:18:44', '2021-09-24 14:28:01'),
(315, 2, 1, 3104, 9, 25, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-09-04 16:27:28', '2021-09-24 14:28:01'),
(316, 1, 1, 2306, 9, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-13 10:22:22', '2021-09-24 14:28:01'),
(317, 2, 2, 972, 13, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-05 17:50:21', '2021-09-24 14:28:01'),
(318, 1, 1, 51, 1, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-18 19:45:29', '2021-09-24 14:28:01'),
(319, 1, 1, 4359, 13, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-03-04 06:48:02', '2021-09-24 14:28:01'),
(320, 2, 2, 281, 1, 25, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-16 13:31:16', '2021-09-24 14:28:01'),
(321, 1, 1, 818, 1, 18, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-04-12 05:32:34', '2021-09-24 14:28:01'),
(322, 1, 1, 3157, 1, 23, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-16 10:35:21', '2021-09-24 14:28:01'),
(323, 2, 1, 4436, 13, 20, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-02 21:38:42', '2021-09-24 14:28:01'),
(324, 2, 2, 487, 12, 22, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-07-07 18:51:04', '2021-09-24 14:28:01'),
(325, 2, 1, 3132, 11, 20, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-21 02:49:10', '2021-09-24 14:28:01'),
(326, 2, 2, 1262, 12, 25, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-08-23 03:05:19', '2021-09-24 14:28:01'),
(327, 1, 1, 882, 8, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-17 21:54:41', '2021-09-24 14:28:01'),
(328, 2, 2, 4271, 13, 24, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-06-16 19:25:24', '2021-09-24 14:28:01'),
(329, 1, 2, 37, 1, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-09-20 04:09:31', '2021-09-24 14:28:01'),
(330, 1, 2, 3908, 10, 22, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-07-01 10:50:32', '2021-09-24 14:28:01'),
(331, 1, 2, 522, 9, 17, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-30 11:53:25', '2021-09-24 14:28:01'),
(332, 2, 2, 4976, 7, 17, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-02-27 11:40:28', '2021-09-24 14:28:01'),
(333, 1, 1, 1387, 7, 21, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-06-24 23:38:17', '2021-09-24 14:28:01'),
(334, 2, 1, 2955, 7, 25, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-07-14 23:55:28', '2021-09-24 14:28:01'),
(335, 1, 2, 1036, 9, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-04 02:41:52', '2021-09-24 14:28:01'),
(336, 2, 2, 1238, 11, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-08-14 11:56:44', '2021-09-24 14:28:01'),
(337, 2, 1, 1985, 13, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-05-11 15:56:37', '2021-09-24 14:28:01'),
(338, 2, 2, 1659, 9, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-05 22:29:16', '2021-09-24 14:28:01'),
(339, 2, 2, 3826, 9, 15, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-07-26 11:27:40', '2021-09-24 14:28:01'),
(340, 1, 2, 1131, 11, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-23 13:31:59', '2021-09-24 14:28:01'),
(341, 1, 2, 3093, 9, 17, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-27 04:14:07', '2021-09-24 14:28:01'),
(342, 1, 1, 1110, 8, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-16 05:53:23', '2021-09-24 14:28:01'),
(343, 1, 2, 2014, 8, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-02-23 23:07:21', '2021-09-24 14:28:01'),
(344, 1, 1, 826, 10, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-16 00:51:52', '2021-09-24 14:28:02'),
(345, 1, 2, 2196, 12, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-02 19:29:34', '2021-09-24 14:28:02'),
(346, 1, 2, 4929, 9, 25, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-07-02 19:01:47', '2021-09-24 14:28:02'),
(347, 2, 1, 4280, 9, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-08-20 01:40:07', '2021-09-24 14:28:02'),
(348, 2, 2, 4935, 10, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-26 08:07:32', '2021-09-24 14:28:02'),
(349, 2, 1, 2508, 7, 25, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-10 18:04:13', '2021-09-24 14:28:02'),
(350, 1, 2, 1770, 10, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-27 17:30:35', '2021-09-24 14:28:02'),
(351, 1, 1, 1959, 10, 25, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-09-22 08:11:15', '2021-09-24 14:28:02'),
(352, 2, 1, 4872, 7, 24, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-02-19 20:00:18', '2021-09-24 14:28:02'),
(353, 2, 2, 4020, 8, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-01-31 22:44:30', '2021-09-24 14:28:02'),
(354, 1, 1, 758, 11, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-26 11:24:30', '2021-09-24 14:28:02'),
(355, 2, 2, 826, 10, 22, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-06-23 18:35:33', '2021-09-24 14:28:02'),
(356, 1, 1, 1635, 10, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-01-27 00:01:28', '2021-09-24 14:28:02'),
(357, 1, 2, 2743, 8, 24, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-08-08 11:48:27', '2021-09-24 14:28:02'),
(358, 2, 2, 112, 9, 15, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-09-05 08:09:13', '2021-09-24 14:28:02'),
(359, 1, 1, 4876, 13, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-07-27 06:23:28', '2021-09-24 14:28:02'),
(360, 1, 1, 4359, 10, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-08-04 03:37:15', '2021-09-24 14:28:02'),
(361, 1, 2, 4373, 12, 22, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-09-02 12:53:34', '2021-09-24 14:28:02'),
(362, 1, 1, 491, 12, 20, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-19 04:26:16', '2021-09-24 14:28:02'),
(363, 2, 2, 4133, 8, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-02-03 05:46:52', '2021-09-24 14:28:02'),
(364, 2, 1, 2166, 11, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-17 08:07:42', '2021-09-24 14:28:02'),
(365, 2, 1, 1527, 13, 21, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-01-09 01:16:50', '2021-09-24 14:28:02'),
(366, 2, 2, 4908, 7, 25, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-01-28 00:41:27', '2021-09-24 14:28:02'),
(367, 2, 1, 950, 9, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-07-10 17:48:42', '2021-09-24 14:28:02'),
(368, 2, 2, 4249, 9, 23, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-11 08:11:41', '2021-09-24 14:28:02'),
(369, 1, 2, 2037, 11, 15, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-07-22 15:45:46', '2021-09-24 14:28:02'),
(370, 2, 2, 4818, 7, 24, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-05 19:27:21', '2021-09-24 14:28:02'),
(371, 1, 2, 3299, 12, 15, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-02 04:19:58', '2021-09-24 14:28:02'),
(372, 1, 2, 2436, 8, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-09-04 06:05:20', '2021-09-24 14:28:02'),
(373, 2, 1, 1843, 9, 25, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-03-26 07:30:34', '2021-09-24 14:28:02'),
(374, 1, 2, 194, 11, 18, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-09 22:03:17', '2021-09-24 14:28:02'),
(375, 2, 2, 1797, 7, 25, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-07-14 04:23:28', '2021-09-24 14:28:02'),
(376, 1, 1, 2362, 10, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-05-18 21:10:05', '2021-09-24 14:28:02'),
(377, 2, 1, 2924, 1, 15, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-01-13 21:32:50', '2021-09-24 14:28:02'),
(378, 1, 1, 3595, 10, 15, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-07-23 08:18:43', '2021-09-24 14:28:02'),
(379, 2, 1, 247, 1, 20, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-24 01:21:45', '2021-09-24 14:28:02'),
(380, 1, 2, 1238, 8, 25, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-05-01 06:20:53', '2021-09-24 14:28:02'),
(381, 1, 2, 3462, 7, 22, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-02-27 05:59:11', '2021-09-24 14:28:03'),
(382, 1, 2, 501, 1, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-09-07 12:44:59', '2021-09-24 14:28:03'),
(383, 1, 2, 479, 13, 24, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-09-09 11:30:22', '2021-09-24 14:28:03'),
(384, 1, 1, 835, 7, 20, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-05-20 13:15:57', '2021-09-24 14:28:03'),
(385, 2, 2, 3707, 13, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-05 19:28:10', '2021-09-24 14:28:03'),
(386, 1, 1, 1472, 11, 15, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-04-26 21:30:42', '2021-09-24 14:28:03'),
(387, 1, 1, 4759, 1, 23, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-08 01:58:29', '2021-09-24 14:28:03'),
(388, 2, 2, 2116, 12, 21, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-08-19 01:09:42', '2021-09-24 14:28:03'),
(389, 2, 1, 3471, 13, 18, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-05-04 13:50:06', '2021-09-24 14:28:03'),
(390, 1, 1, 4441, 8, 22, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-03-01 21:54:50', '2021-09-24 14:28:03'),
(391, 2, 2, 3367, 12, 22, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-03-27 02:05:23', '2021-09-24 14:28:03'),
(392, 2, 1, 3338, 1, 21, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-04-25 15:39:58', '2021-09-24 14:28:03'),
(393, 1, 1, 4473, 8, 23, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-04-18 11:03:49', '2021-09-24 14:28:03'),
(394, 1, 1, 816, 12, 18, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-08-21 10:32:18', '2021-09-24 14:28:03'),
(395, 1, 1, 2467, 13, 20, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-15 08:48:42', '2021-09-24 14:28:03'),
(396, 2, 2, 1611, 11, 23, 'one_time', NULL, NULL, NULL, NULL, 'Cancelled', '2021-06-25 02:17:54', '2021-09-24 14:28:03'),
(397, 2, 2, 3919, 7, 20, 'one_time', NULL, NULL, NULL, NULL, 'Completed', '2021-06-01 06:14:58', '2021-09-24 14:28:03'),
(398, 2, 1, 4809, 9, 21, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-02-26 12:36:58', '2021-09-24 14:28:03'),
(399, 1, 2, 631, 1, 21, 'one_time', NULL, NULL, NULL, NULL, 'Opened', '2021-09-19 10:37:32', '2021-09-24 14:28:03'),
(400, 2, 2, 4072, 9, 20, 'one_time', NULL, NULL, NULL, NULL, 'Closed', '2021-06-20 02:12:37', '2021-09-24 14:28:03'),
(401, 4, 5, 66, 12, 20, 'one_time', NULL, NULL, NULL, 'Officia tempore ex ', 'Opened', '2021-09-26 16:19:17', '2021-09-26 16:19:17'),
(402, 6, 6, 78, 11, 25, 'scheduled', NULL, '2014-08-23 19:35:00', '2021-09-27 23:18:00', 'Et doloremque autem ', 'Opened', '2021-09-26 16:19:59', '2021-09-26 16:19:59'),
(403, 5, 4, 47, 9, 22, 'scheduled', NULL, '2021-09-27 04:21:00', '2021-10-09 04:26:00', 'Corrupti similique ', 'Opened', '2021-09-26 16:20:36', '2021-09-26 16:33:53');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- Indexes for table `client_service`
--
ALTER TABLE `client_service`
  ADD PRIMARY KEY (`service_id`,`client_id`),
  ADD KEY `client_service_client__fk` (`client_id`);

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

--
-- Indexes for table `containers`
--
ALTER TABLE `containers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `containers_car__fk` (`car_id`);

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

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

--
-- Indexes for table `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `locations_client__fk` (`client_id`);

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

--
-- Indexes for table `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`);

--
-- Indexes for table `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`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

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

--
-- Indexes for table `pricing_model_location`
--
ALTER TABLE `pricing_model_location`
  ADD PRIMARY KEY (`location_id`,`pricing_model_id`),
  ADD KEY `pricing_model_location__pricing_fk` (`pricing_model_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `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`);

--
-- Indexes for table `samples`
--
ALTER TABLE `samples`
  ADD PRIMARY KEY (`id`),
  ADD KEY `samples__location_fk` (`location_id`);

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

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tasks__client_fk` (`billing_client`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cars`
--
ALTER TABLE `cars`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `car_link_history`
--
ALTER TABLE `car_link_history`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `containers`
--
ALTER TABLE `containers`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geofences`
--
ALTER TABLE `geofences`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `locations`
--
ALTER TABLE `locations`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `pricings`
--
ALTER TABLE `pricings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `samples`
--
ALTER TABLE `samples`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=404;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `client_service`
--
ALTER TABLE `client_service`
  ADD CONSTRAINT `client_service_client__fk` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`);

--
-- Constraints for table `containers`
--
ALTER TABLE `containers`
  ADD CONSTRAINT `containers_car__fk` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`);

--
-- Constraints for table `locations`
--
ALTER TABLE `locations`
  ADD CONSTRAINT `locations_client__fk` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`);

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pricing_model_location`
--
ALTER TABLE `pricing_model_location`
  ADD CONSTRAINT `pricing_model_location__pricing_fk` FOREIGN KEY (`pricing_model_id`) REFERENCES `pricings` (`id`),
  ADD CONSTRAINT `pricing_model_location_location__fk` FOREIGN KEY (`location_id`) REFERENCES `locations` (`id`);

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `samples`
--
ALTER TABLE `samples`
  ADD CONSTRAINT `samples__location_fk` FOREIGN KEY (`location_id`) REFERENCES `locations` (`id`);

--
-- Constraints for table `tasks`
--
ALTER TABLE `tasks`
  ADD CONSTRAINT `tasks__client_fk` FOREIGN KEY (`billing_client`) REFERENCES `clients` (`id`);
COMMIT;

