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

START TRANSACTION;



--
-- Database: `example_app`
--

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

--
-- Table structure for table `action_events`
--

CREATE TABLE `action_events` (
  `id` bigint UNSIGNED NOT NULL,
  `batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actionable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actionable_id` bigint UNSIGNED NOT NULL,
  `target_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED DEFAULT NULL,
  `fields` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'running',
  `exception` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `original` mediumtext COLLATE utf8mb4_unicode_ci,
  `changes` mediumtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `action_events`
--

INSERT INTO `action_events` (`id`, `batch_id`, `user_id`, `name`, `actionable_type`, `actionable_id`, `target_type`, `target_id`, `model_type`, `model_id`, `fields`, `status`, `exception`, `created_at`, `updated_at`, `original`, `changes`) VALUES
(1, '9aa7afb3-d0ab-4dee-9219-0871c35e419f', 1, 'Update', 'App\\Models\\Admin', 10, 'App\\Models\\Admin', 10, 'App\\Models\\Admin', 10, '', 'finished', '', '2023-11-20 03:13:00', '2023-11-20 03:13:00', '{\"type\":null}', '{\"type\":\"super\"}'),
(2, '9aa7afe7-b13b-43e0-a337-ea72f6115bb5', 1, 'Update', 'App\\Models\\Admin', 1, 'App\\Models\\Admin', 1, 'App\\Models\\Admin', 1, '', 'finished', '', '2023-11-20 03:13:34', '2023-11-20 03:13:34', '{\"type\":null}', '{\"type\":\"super\"}'),
(3, '9aa7b011-c258-4ed1-9f4c-1b22136cf089', 1, 'Update', 'App\\Models\\Admin', 9, 'App\\Models\\Admin', 9, 'App\\Models\\Admin', 9, '', 'finished', '', '2023-11-20 03:14:01', '2023-11-20 03:14:01', '{\"email\":\"littel.yoshiko@example.net\",\"type\":null}', '{\"email\":\"agent@gmail.com\",\"type\":\"agent\"}'),
(4, '9aa7b1e5-d59f-42a4-be17-2f77774acc13', 1, 'Create', 'App\\Models\\Setting', 1, 'App\\Models\\Setting', 1, 'App\\Models\\Setting', 1, '', 'finished', '', '2023-11-20 03:19:08', '2023-11-20 03:19:08', NULL, '{\"phone\":\"0908880998\",\"phone1\":\"099999889988\",\"email\":\"info@jorayalogistics.com\",\"email1\":\"pachristong@gmail.com\",\"address\":\"00994900494903939\",\"bank_name\":\"zenit Bank\",\"bank_account_no\":\"0949940499\",\"bank_account_name\":\"Chris test\",\"bank_name1\":\"access Bank\",\"bank_account_no1\":\"0044949449\",\"bank_account_name1\":\"David Uko049449499\",\"about\":null,\"policy\":null,\"terms\":null,\"updated_at\":\"2023-11-20T03:19:08.000000Z\",\"created_at\":\"2023-11-20T03:19:08.000000Z\",\"id\":1}'),
(9, '9aa7bfae-a809-4cfa-90e0-9a3a6cc00754', 1, 'Send Price', 'App\\Models\\Order', 1, 'App\\Models\\Order', 1, 'App\\Models\\Order', 1, 'a:2:{s:6:\"amount\";s:3:\"900\";s:13:\"delivery_time\";s:24:\"2023-11-21T04:54:49.000Z\";}', 'finished', '', '2023-11-20 03:57:41', '2023-11-20 03:57:42', NULL, NULL),
(10, '9aa7c068-cd43-42f0-afb6-9d5ca45b2bff', 1, 'Change Order Status', 'App\\Models\\Order', 1, 'App\\Models\\Order', 1, 'App\\Models\\Order', 1, 'a:1:{s:6:\"status\";s:10:\"processing\";}', 'finished', '', '2023-11-20 03:59:43', '2023-11-20 03:59:48', NULL, NULL),
(11, '9aa7dc0b-b377-44ab-9251-1ccfebd03715', 1, 'Update', 'App\\Models\\User', 1, 'App\\Models\\User', 1, 'App\\Models\\User', 1, '', 'finished', '', '2023-11-20 05:16:59', '2023-11-20 05:16:59', '{\"email\":\"pachristong@gmail.com\"}', '{\"email\":\"xpachristo@gmail.com\"}');

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

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

CREATE TABLE `contacts` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `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 `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint 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 `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int 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_reset_tokens_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2018_01_01_000000_create_action_events_table', 1),
(5, '2019_05_10_000000_add_fields_to_action_events_table', 1),
(6, '2019_08_19_000000_create_failed_jobs_table', 1),
(7, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(8, '2021_08_25_193039_create_nova_notifications_table', 1),
(9, '2022_04_26_000000_add_fields_to_nova_notifications_table', 1),
(10, '2022_12_19_000000_create_field_attachments_table', 1),
(11, '2023_09_20_083741_create_orders_table', 1),
(12, '2023_09_20_093056_create_admins_table', 1),
(13, '2023_09_20_172526_create_order_images_table', 1),
(15, '2023_09_21_095230_create_contacts_table', 1),
(16, '2023_09_21_094552_create_settings_table', 2),
(17, '2023_11_19_190544_add_passwrd_addmin', 3),
(18, '2023_11_19_190758_add_passwrd_addremembermemin', 4),
(19, '2023_11_19_190950_add_passwrd_addremembermemino', 5),
(20, '2023_11_19_191240_add_passwrd_addremembermemieno', 6),
(21, '2023_11_20_031747_add_address_settigs', 7),
(22, '2023_11_20_032934_add_sendeirs_and_recieviers_contactss', 8),
(23, '2023_11_20_034802_adddeleiverytargts', 9),
(24, '2023_11_20_035532_add_order_amount', 10),
(25, '2023_11_20_035654_add_order_amountandtime', 11),
(26, '2016_06_01_000001_create_oauth_auth_codes_table', 12),
(27, '2016_06_01_000002_create_oauth_access_tokens_table', 12),
(28, '2016_06_01_000003_create_oauth_refresh_tokens_table', 12),
(29, '2016_06_01_000004_create_oauth_clients_table', 12),
(30, '2016_06_01_000005_create_oauth_personal_access_clients_table', 12),
(31, '2023_11_20_061343_add_order_device_token', 13),
(32, '2023_11_20_063552_create_notifications_table', 14),
(33, '2023_11_20_064509_add_user_id_notification', 15);

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

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

CREATE TABLE `notifications` (
  `id` bigint UNSIGNED NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `data_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `nova_field_attachments`
--

CREATE TABLE `nova_field_attachments` (
  `id` int UNSIGNED NOT NULL,
  `attachable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachable_id` bigint UNSIGNED NOT NULL,
  `attachment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` 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;

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

--
-- Table structure for table `nova_notifications`
--

CREATE TABLE `nova_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 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,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `nova_pending_field_attachments`
--

CREATE TABLE `nova_pending_field_attachments` (
  `id` int UNSIGNED NOT NULL,
  `draft_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `disk` 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;

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

--
-- Table structure for table `oauth_auth_codes`
--

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

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint UNSIGNED NOT NULL,
  `client_id` bigint UNSIGNED 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 `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2023-11-20 04:20:36', '2023-11-20 04:20:36');

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` text COLLATE utf8mb4_unicode_ci,
  `destination` text COLLATE utf8mb4_unicode_ci,
  `kg` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `review` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_proof` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sender_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reciever_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_target` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `order_id`, `user_id`, `location`, `destination`, `kg`, `status`, `review`, `payment_proof`, `details`, `created_at`, `updated_at`, `sender_phone`, `reciever_phone`, `payment_method`, `delivery_target`, `amount`, `delivery_time`) VALUES
(1, 'ORD1202311200349275631', '1', '11 Aka Road Uyo', '12 Aka Road  uyo', NULL, 'processing', NULL, NULL, 'pack of indome', '2023-11-20 03:49:27', '2023-11-20 03:59:43', '0903030399', '09039393488', 'cash', 'me', '900', '2023-11-21 04:54:49'),
(2, 'ORD1202311200850414720', '1', '5 Abak road uyo', '3 ring road uyo', NULL, 'pending', NULL, NULL, 'cartoons of indomie', '2023-11-20 08:50:41', '2023-11-20 08:50:41', '23490939393939', '234819383838844', 'cash', 'me', NULL, NULL),
(3, 'ORD1202311200852367087', '1', '5 Abak road uyo', '3 ring road uyo', NULL, 'pending', NULL, NULL, 'cartoons of indomie', '2023-11-20 08:52:36', '2023-11-20 08:52:36', '23490939393939', '234819383838844', 'cash', 'me', NULL, NULL),
(4, 'ORD1202311200946016423', '1', '5 Abak road uyo', '3 ring road uyo', NULL, 'pending', NULL, NULL, 'cartoons of indomie', '2023-11-20 09:46:01', '2023-11-20 09:46:01', '23490939393939', '234819383838844', 'cash', 'me', NULL, NULL),
(5, 'ORD1202311200946431412', '1', '5 Abak road uyo', '3 ring road uyo', NULL, 'pending', NULL, NULL, 'cartoons of indomie', '2023-11-20 09:46:43', '2023-11-20 09:46:43', '23490939393939', '234819383838844', 'cash', 'me', NULL, NULL),
(6, 'ORD1202311200947315779', '1', '5 Abak road uyo', '3 ring road uyo', NULL, 'pending', NULL, NULL, 'cartoons of indomie', '2023-11-20 09:47:31', '2023-11-20 09:47:31', '23490939393939', '234819383838844', 'cash', 'me', NULL, NULL);

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

--
-- Table structure for table `order_images`
--

CREATE TABLE `order_images` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) 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 `order_images`
--

INSERT INTO `order_images` (`id`, `order_id`, `image`, `created_at`, `updated_at`) VALUES
(1, 'ORD1202311200349275631', 'g068c8oAsV5Oc3moBJNZ9qNrR60cNhEUvikOQnFu.png', '2023-11-20 03:49:30', '2023-11-20 03:49:30'),
(2, 'ORD1202311200349275631', 'FwGmiW9H9W0U4GRz4fvpC3q91qh0sQJfrhDSkowS.png', '2023-11-20 03:49:30', '2023-11-20 03:49:30'),
(3, 'ORD1202311200852367087', 'lEikKV2mefjEUtHByaLm6Bq4B7XtQtsjAWVPPcE4.jpg', '2023-11-20 08:52:41', '2023-11-20 08:52:41'),
(4, 'ORD1202311200852367087', '0016bC1BTDk7lTihzkRI7ZXePHY7BdlYc0uM14Ac.jpg', '2023-11-20 08:52:41', '2023-11-20 08:52:41'),
(5, 'ORD1202311200852367087', '3mcOO0PsK6wgqNHheW9pyxDMzhxpaM0PXAkpxyOQ.png', '2023-11-20 08:52:41', '2023-11-20 08:52:41'),
(6, 'ORD1202311200946016423', 'zPVT6VBWNTmpmM7n3vqFGBjQVwTc8ViWAFGVugoW.jpg', '2023-11-20 09:46:03', '2023-11-20 09:46:03'),
(7, 'ORD1202311200946016423', 'Qx5GP5EHkzAUeGyxRMQ5X3GiuO5wQGo4ScIL8gip.jpg', '2023-11-20 09:46:03', '2023-11-20 09:46:03'),
(8, 'ORD1202311200946016423', 'kPkWwL4JE1M64C1piJEPMBa8pqJLVIyq9WjgoJcL.png', '2023-11-20 09:46:03', '2023-11-20 09:46:03'),
(9, 'ORD1202311200946431412', 't7sFKpTeMG71m2OBONCQ6ojhY2niYE3vr6Hg53OL.jpg', '2023-11-20 09:46:45', '2023-11-20 09:46:45'),
(10, 'ORD1202311200946431412', 'jS50Cb0jPUs7F7TpRxC2LgYz7RR1OOF2jw76a8cc.jpg', '2023-11-20 09:46:45', '2023-11-20 09:46:45'),
(11, 'ORD1202311200946431412', 'sov3qcHuTnAKsO0eZ0WWa8qAvDb8t4kLxNNb5Kyr.png', '2023-11-20 09:46:45', '2023-11-20 09:46:45'),
(12, 'ORD1202311200947315779', 'YlzbaH8MFoMBfqZ6FDquAjrBVUSBEoUk7sNy0teG.jpg', '2023-11-20 09:47:32', '2023-11-20 09:47:32'),
(13, 'ORD1202311200947315779', 'QGo0sEScbvWwckEbPGvIol0r738QGQgu9nTgl1pz.jpg', '2023-11-20 09:47:32', '2023-11-20 09:47:32'),
(14, 'ORD1202311200947315779', 'd3DdRacBn9fIude1l5nXXhCPytoY11GgHxh3xcIk.png', '2023-11-20 09:47:32', '2023-11-20 09:47:32'),
(15, 'ORD1202311200948464230', 'oKKllQ6LLXob1xP1UmLuwgoAZ3kVROCsp6ZuCki7.jpg', '2023-11-20 09:48:47', '2023-11-20 09:48:47'),
(16, 'ORD1202311200948464230', 'DGnrV94S94SYiXyv70JZMlGokOCUiz3OMLIrK89k.jpg', '2023-11-20 09:48:47', '2023-11-20 09:48:47'),
(17, 'ORD1202311200948464230', 'vWyV2YpxTWmC9rzutzc6AhEGukptSecrnyZf1foT.png', '2023-11-20 09:48:48', '2023-11-20 09:48:48');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint UNSIGNED NOT NULL,
  `phone1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_account_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_account_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_account_name1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_account_no1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `policy` text COLLATE utf8mb4_unicode_ci,
  `about` text COLLATE utf8mb4_unicode_ci,
  `terms` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `phone1`, `phone`, `email1`, `email`, `bank_name`, `bank_account_name`, `bank_account_no`, `bank_name1`, `bank_account_name1`, `bank_account_no1`, `policy`, `about`, `terms`, `created_at`, `updated_at`, `address`) VALUES
(1, '099999889988', '0908880998', 'pachristong@gmail.com', 'info@jorayalogistics.com', 'zenit Bank', 'Chris test', '0949940499', 'access Bank', 'David Uko049449499', '0044949449', NULL, NULL, NULL, '2023-11-20 03:19:08', '2023-11-20 03:19:08', '00994900494903939');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `action_events`
--
ALTER TABLE `action_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `action_events_actionable_type_actionable_id_index` (`actionable_type`,`actionable_id`),
  ADD KEY `action_events_target_type_target_id_index` (`target_type`,`target_id`),
  ADD KEY `action_events_batch_id_model_type_model_id_index` (`batch_id`,`model_type`,`model_id`),
  ADD KEY `action_events_user_id_index` (`user_id`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`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 `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `nova_field_attachments`
--
ALTER TABLE `nova_field_attachments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nova_field_attachments_attachable_type_attachable_id_index` (`attachable_type`,`attachable_id`),
  ADD KEY `nova_field_attachments_url_index` (`url`);

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

--
-- Indexes for table `nova_pending_field_attachments`
--
ALTER TABLE `nova_pending_field_attachments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nova_pending_field_attachments_draft_id_index` (`draft_id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `action_events`
--
ALTER TABLE `action_events`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `nova_field_attachments`
--
ALTER TABLE `nova_field_attachments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `nova_pending_field_attachments`
--
ALTER TABLE `nova_pending_field_attachments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `order_images`
--
ALTER TABLE `order_images`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

