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

START TRANSACTION;



--
-- Database: `currier_db`
--

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

--
-- Table structure for table `admin_wise_agents`
--

CREATE TABLE `admin_wise_agents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` varchar(255) DEFAULT NULL,
  `agent_id` varchar(255) 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 `admin_wise_agents`
--

INSERT INTO `admin_wise_agents` (`id`, `admin_id`, `agent_id`, `created_at`, `updated_at`) VALUES
(3, '1', '130', NULL, NULL),
(4, '1', '269', NULL, NULL),
(5, '1', '272', NULL, NULL);

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

--
-- Table structure for table `agents`
--

CREATE TABLE `agents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `agent_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `discount` varchar(255) 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 `agents`
--

INSERT INTO `agents` (`id`, `agent_id`, `name`, `phone`, `address`, `discount`, `created_at`, `updated_at`) VALUES
(3, '130', 'Dilouar Hossain', '01313476850', 'Creative Software, Lavel-4, 68-69,Concept Tower', '0', '2025-04-23 15:08:09', '2025-04-23 15:08:09'),
(4, '269', 'RAkib', '01616467898', 'dhaka', '10', '2025-06-28 10:59:54', '2025-06-28 10:59:54'),
(5, '272', 'FAST EXP', '01726701238', 'SYLHET', '0', '2025-06-30 13:30:20', '2025-06-30 13:30:20');

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

--
-- Table structure for table `agent_payments`
--

CREATE TABLE `agent_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `booking_no` varchar(255) DEFAULT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `agent_id` varchar(255) DEFAULT NULL,
  `total_charge` varchar(255) DEFAULT NULL,
  `total_collect_amount` varchar(255) DEFAULT NULL,
  `total_charge_amount` varchar(255) DEFAULT NULL,
  `status` varchar(255) 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 `agent_payments`
--

INSERT INTO `agent_payments` (`id`, `booking_no`, `invoice_no`, `agent_id`, `total_charge`, `total_collect_amount`, `total_charge_amount`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'INV11499', NULL, NULL, NULL, NULL, 'Order fulfillment', '2025-08-05 02:20:32', '2025-08-05 02:20:32');

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

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` varchar(255) DEFAULT NULL,
  `booking_no` varchar(255) DEFAULT NULL,
  `account_no` varchar(255) DEFAULT NULL,
  `origin` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `service` varchar(255) DEFAULT NULL,
  `spx_dpx` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `weight` varchar(255) DEFAULT NULL,
  `charge` varchar(255) DEFAULT NULL,
  `shipper` varchar(255) DEFAULT NULL,
  `shipper_address` varchar(255) DEFAULT NULL,
  `shipper_address_two` varchar(255) DEFAULT NULL,
  `shipper_address_three` varchar(255) DEFAULT NULL,
  `shipper_contact_person` varchar(255) DEFAULT NULL,
  `shipper_contact_no` varchar(255) DEFAULT NULL,
  `shipper_city` varchar(255) DEFAULT NULL,
  `shipper_state` varchar(255) DEFAULT NULL,
  `shipper_postcode` varchar(255) DEFAULT NULL,
  `shipper_country` varchar(255) DEFAULT NULL,
  `consignee` varchar(255) DEFAULT NULL,
  `consignee_address` varchar(255) DEFAULT NULL,
  `consignee_address_two` varchar(255) DEFAULT NULL,
  `consignee_address_three` varchar(255) DEFAULT NULL,
  `consignee_contact_person` varchar(255) DEFAULT NULL,
  `consignee_contact_no` varchar(255) DEFAULT NULL,
  `consignee_post_code` varchar(255) DEFAULT NULL,
  `consignee_city` varchar(255) DEFAULT NULL,
  `consignee_state` varchar(255) DEFAULT NULL,
  `consignee_country` varchar(255) DEFAULT NULL,
  `description_of_goods` longtext DEFAULT NULL,
  `cp_pp` varchar(255) DEFAULT NULL,
  `bill_amount` varchar(255) DEFAULT NULL,
  `collect_amount` varchar(255) DEFAULT NULL,
  `insurance` varchar(255) DEFAULT NULL,
  `admin_id` varchar(255) DEFAULT NULL,
  `agent_id` varchar(255) DEFAULT NULL,
  `status` varchar(255) 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 `bookings`
--

INSERT INTO `bookings` (`id`, `date`, `booking_no`, `account_no`, `origin`, `destination`, `service`, `spx_dpx`, `price`, `weight`, `charge`, `shipper`, `shipper_address`, `shipper_address_two`, `shipper_address_three`, `shipper_contact_person`, `shipper_contact_no`, `shipper_city`, `shipper_state`, `shipper_postcode`, `shipper_country`, `consignee`, `consignee_address`, `consignee_address_two`, `consignee_address_three`, `consignee_contact_person`, `consignee_contact_no`, `consignee_post_code`, `consignee_city`, `consignee_state`, `consignee_country`, `description_of_goods`, `cp_pp`, `bill_amount`, `collect_amount`, `insurance`, `admin_id`, `agent_id`, `status`, `created_at`, `updated_at`) VALUES
(11, '2025-07-22', 'TS2025072211', '23455', '242', '232', '1', 'Pices', '250', '65', '40', 'shipper', 'blpck-b', 'block-2', 'Nisi eiusmod autem m', 'ship_demo_c_persion', 'consign_88295', 'dhaka', 'Et et dolorem doloru', '3333', '241', 'consignee', 'blpck-b', 'block-2', 'Mollitia nihil incid', 'consigne_demo_c_persion', 'consign_88295', '3333', 'dhaka', 'xvcxcxcvxcv', '166', 'eedfddsf', 'PostPaid', '40', '10000', 'Yes', '1', '3', 'Booking Created', '2025-07-22 06:00:37', '2025-07-22 06:00:37'),
(18, '2022-07-18', 'TS2025080512', 'Fugiat molestiae sit', '134', '44', '1', 'Pices', '548', '40', '121212', 'Nulla et beatae esse', 'Id in quia ipsa non', 'Nisi qui laudantium', 'Consequatur Omnis n', 'Laboriosam sit con', 'Fuga Nostrud aut no', 'Tenetur qui atque ve', 'Amet ut mollitia of', 'Eligendi amet saepe', '157', 'Dolorem omnis quis s', 'Nemo provident tota', 'Quibusdam fugiat Nam', 'Laborum eos modi ma', 'Dolor excepteur est', 'Error eveniet et re', 'Dolore eiusmod itaqu', 'Temporibus consequat', 'Ducimus non non eum', '91', 'Atque ut repudiandae', 'PostPaid', '121212', '12121212', 'Yes', '1', NULL, 'Order fulfillment', '2025-08-05 02:15:15', '2025-08-05 02:20:32'),
(19, '2022-07-18', 'TS2025080512', 'Fugiat molestiae sit', '134', '44', '3', 'Pices', '548', 'Dolorem minus dolori', '121212', 'Nulla et beatae esse', 'Id in quia ipsa non', 'Nisi qui laudantium', 'Consequatur Omnis n', 'Laboriosam sit con', 'Fuga Nostrud aut no', 'Tenetur qui atque ve', 'Amet ut mollitia of', 'Eligendi amet saepe', '157', 'Dolorem omnis quis s', 'Nemo provident tota', 'Quibusdam fugiat Nam', 'Laborum eos modi ma', 'Dolor excepteur est', 'Error eveniet et re', 'Dolore eiusmod itaqu', 'Temporibus consequat', 'Ducimus non non eum', '91', 'Atque ut repudiandae', 'PostPaid', '121212', '12121212', 'Yes', '1', NULL, 'Order fulfillment', '2025-08-05 02:15:40', '2025-08-05 02:20:32'),
(20, '1987-09-21', 'TS1608202520', 'Facilis consequuntur', '39', '57', '3', 'Box', '458', '23', 'Sunt numquam maiores', 'Tempor proident vel', 'Fugiat excepteur rep', 'Soluta consequatur c', 'Enim et eu laborum v', 'Pariatur Perferendi', 'Dolore esse sed est', 'Minus eligendi repel', 'Voluptatum adipisci', '23434', '174', 'Dolore dolore sit u', 'Nulla et quisquam so', 'Possimus quos hic v', 'Non aliquid aperiam', 'Distinctio Odit ut', 'Quo deleniti nisi ve', '324234', 'Doloremque velit par', 'Facilis dolor dolor', '99', 'Optio quis at volup', 'PostPaid', 'Neque velit sed ist', 'Nobis excepteur cons', 'No', '1', NULL, 'Booking Created', '2025-08-16 03:06:50', '2025-08-16 03:06:50');

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

--
-- Table structure for table `booking_status_histories`
--

CREATE TABLE `booking_status_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `booking_no` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `status` varchar(255) 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 `booking_status_histories`
--

INSERT INTO `booking_status_histories` (`id`, `booking_no`, `user_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 'TS202405301', '1', 'Booking Created', '2024-05-30 04:04:42', '2024-05-30 04:04:42'),
(2, 'TS202405312', '1', 'Booking Created', '2024-05-31 14:49:14', '2024-05-31 14:49:14'),
(3, 'TS202405313', '2', 'Booking Created', '2024-05-31 14:57:36', '2024-05-31 14:57:36'),
(4, 'TS202506285', '269', 'Booking Created', '2025-06-28 11:03:06', '2025-06-28 11:03:06'),
(5, 'TS202506285', '1', 'Booking Collect HeadOffice', '2025-06-28 11:06:06', '2025-06-28 11:06:06'),
(6, 'TS202409144', '1', 'Booking Collect HeadOffice', '2025-06-28 11:06:06', '2025-06-28 11:06:06'),
(7, 'TS202405313', '1', 'Booking Collect HeadOffice', '2025-06-28 11:06:06', '2025-06-28 11:06:06'),
(8, 'TS202405312', '1', 'Booking Collect HeadOffice', '2025-06-28 11:06:06', '2025-06-28 11:06:06'),
(9, 'TS202405301', '1', 'Booking Collect HeadOffice', '2025-06-28 11:06:06', '2025-06-28 11:06:06'),
(10, 'TS202507227', '1', 'Booking Created', '2025-07-22 01:49:54', '2025-07-22 01:49:54'),
(11, 'TS202507228', '1', 'Booking Created', '2025-07-22 01:51:53', '2025-07-22 01:51:53'),
(12, 'TS202507221', '1', 'Booking Created', '2025-07-22 05:54:59', '2025-07-22 05:54:59'),
(13, 'TS2025072211', '1', 'Booking Created', '2025-07-22 06:00:37', '2025-07-22 06:00:37'),
(14, 'TS2025080414', '1', 'Booking Created', '2025-08-04 06:06:05', '2025-08-04 06:06:05'),
(15, 'TS2025080414', '1', 'Booking Created', '2025-08-04 06:07:23', '2025-08-04 06:07:23'),
(16, 'TS2025080417', '1', 'Booking Created', '2025-08-04 06:08:29', '2025-08-04 06:08:29'),
(17, 'TS2025080512', '1', 'Booking Created', '2025-08-05 02:15:40', '2025-08-05 02:15:40'),
(18, 'TS2025080512', '1', 'Order fulfillment', '2025-08-05 02:20:32', '2025-08-05 02:20:32'),
(19, 'TS1608202520', '1', 'Booking Created', '2025-08-16 03:06:50', '2025-08-16 03:06:50');

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

--
-- Table structure for table `booking_transfer_deatils`
--

CREATE TABLE `booking_transfer_deatils` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `booking_no` varchar(255) DEFAULT NULL,
  `agent_id` varchar(255) DEFAULT NULL,
  `status` varchar(255) 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 `book_invoices`
--

CREATE TABLE `book_invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `booking_no` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `weight` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `value` varchar(255) 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 `book_invoices`
--

INSERT INTO `book_invoices` (`id`, `booking_no`, `description`, `weight`, `price`, `value`, `created_at`, `updated_at`) VALUES
(22, 'TS2025072211', 'aasdfsd', '12', '10', '11', '2025-07-22 06:00:37', '2025-07-22 06:00:37'),
(23, 'TS2025072211', 'aasdfsd', '45', '47', '48', '2025-07-22 06:00:37', '2025-07-22 06:00:37'),
(24, 'TS2025072212', 'aasdfsd', '12', '23', '23', '2025-07-22 06:11:57', '2025-07-22 06:11:57'),
(25, 'TS2025072213', 'aasdfsd', '12', '12', '23', '2025-07-22 06:13:28', '2025-07-22 06:13:28'),
(26, 'TS2025072213', 'fetrw', '23', '23', '23', '2025-07-22 06:13:28', '2025-07-22 06:13:28'),
(27, 'TS2025072213', 'aasdfsd34', '23', '45', '34', '2025-07-22 06:13:28', '2025-07-22 06:13:28'),
(28, 'TS2025080414', 'tyjytjhy', '232', '23', '232', '2025-08-04 06:06:05', '2025-08-04 06:06:05'),
(29, 'TS2025080414', 'Facilis consectetur', '67', '407', '100', '2025-08-04 06:07:23', '2025-08-04 06:07:23'),
(30, 'TS2025080414', 'Commodi commodi irur', '70', '221', '65', '2025-08-04 06:07:23', '2025-08-04 06:07:23'),
(31, 'TS2025080417', 'we', '23', '23', '23', '2025-08-04 06:08:29', '2025-08-04 06:08:29'),
(32, 'TS2025080417', 'us', '23', '23', '23', '2025-08-04 06:08:29', '2025-08-04 06:08:29'),
(33, 'TS2025080512', 'Facilis consectetur', '1221', '1212', '1212', '2025-08-05 02:15:40', '2025-08-05 02:15:40'),
(34, 'TS1608202520', 'Facilis consectetur hgfh', '23', '232', '2323', '2025-08-16 03:06:50', '2025-08-16 03:06:50');

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

--
-- Table structure for table `charges`
--

CREATE TABLE `charges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `weight` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `charge` varchar(255) 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 `collections`
--

CREATE TABLE `collections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `collection_id` varchar(255) DEFAULT NULL,
  `tracking_id` varchar(255) NOT NULL,
  `amount` varchar(10) NOT NULL,
  `date` varchar(255) NOT NULL,
  `payment_date` varchar(255) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `booking_id` bigint(20) UNSIGNED 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 `collections`
--

INSERT INTO `collections` (`id`, `collection_id`, `tracking_id`, `amount`, `date`, `payment_date`, `notes`, `booking_id`, `created_at`, `updated_at`) VALUES
(21, 'TSC2025081310', 'TS2025072211', '250', '2025-07-22', '2025-08-13', NULL, 11, '2025-08-13 02:45:40', '2025-08-13 02:45:40'),
(22, 'TSC2025081601', 'TS2025072211', '250', '2025-07-22', '2025-08-16', NULL, 11, '2025-08-15 21:16:52', '2025-08-15 21:16:52'),
(23, 'TSC2025081602', 'TS2025080512', '548', '2022-07-18', '2025-08-16', NULL, 18, '2025-08-16 01:44:08', '2025-08-16 01:44:08'),
(24, 'TSC2025081603', 'TS2025080512', '548', '2022-07-18', '2025-08-16', NULL, 18, '2025-08-16 01:48:35', '2025-08-16 01:48:35'),
(25, 'TSC2025081604', 'TS2025072211', '250', '2025-07-22', '2025-08-16', NULL, 11, '2025-08-16 01:58:53', '2025-08-16 01:58:53'),
(26, 'TSC2025081605', 'TS1608202520', '458', '1987-09-21', '2025-08-16', NULL, 20, '2025-08-16 03:36:22', '2025-08-16 03:36:22'),
(27, 'TSC2025081606', 'TS1608202520', '458', '1987-09-21', '2025-08-16', NULL, 20, '2025-08-16 03:36:45', '2025-08-16 03:36:45'),
(28, 'TSC2025081607', 'TS2025072211', '250', '2025-07-22', '2025-08-16', NULL, 11, '2025-08-16 03:38:18', '2025-08-16 03:38:18'),
(29, 'TSC2025081608', 'TS1608202520', '458', '1987-09-21', '2025-08-16', NULL, 20, '2025-08-16 03:38:26', '2025-08-16 03:38:26'),
(30, 'TSC2025081609', 'TS2025080512', '548', '2022-07-18', '2025-08-16', NULL, 18, '2025-08-16 03:39:14', '2025-08-16 03:39:14');

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

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `currencies` varchar(255) DEFAULT NULL,
  `logo` varchar(255) 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 `companies`
--

INSERT INTO `companies` (`id`, `name`, `address`, `phone`, `email`, `website`, `country`, `currencies`, `logo`, `created_at`, `updated_at`) VALUES
(1, 'FEDEX', 'DHAKA', '01700000', 'fedex@gmail.com', 'www.fedex.com', '20', '9', 'uploads/company/1800602570081136.jpeg', '2024-05-31 14:47:05', '2024-05-31 14:47:05'),
(2, 'DHL', 'DHAKA', '01700000', 'dhl@gmail.com', 'www.dhl.com', '20', '9', 'uploads/company/1800602869856729.png', '2024-05-31 14:51:51', '2024-05-31 14:51:51');

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `code`, `name`) VALUES
(1, 'US', 'United States'),
(2, 'CA', 'Canada'),
(3, 'AF', 'Afghanistan'),
(4, 'AL', 'Albania'),
(5, 'DZ', 'Algeria'),
(6, 'AS', 'American Samoa'),
(7, 'AD', 'Andorra'),
(8, 'AO', 'Angola'),
(9, 'AI', 'Anguilla'),
(10, 'AQ', 'Antarctica'),
(11, 'AG', 'Antigua and/or Barbuda'),
(12, 'AR', 'Argentina'),
(13, 'AM', 'Armenia'),
(14, 'AW', 'Aruba'),
(15, 'AU', 'Australia'),
(16, 'AT', 'Austria'),
(17, 'AZ', 'Azerbaijan'),
(18, 'BS', 'Bahamas'),
(19, 'BH', 'Bahrain'),
(20, 'BD', 'Bangladesh'),
(21, 'BB', 'Barbados'),
(22, 'BY', 'Belarus'),
(23, 'BE', 'Belgium'),
(24, 'BZ', 'Belize'),
(25, 'BJ', 'Benin'),
(26, 'BM', 'Bermuda'),
(27, 'BT', 'Bhutan'),
(28, 'BO', 'Bolivia'),
(29, 'BA', 'Bosnia and Herzegovina'),
(30, 'BW', 'Botswana'),
(31, 'BV', 'Bouvet Island'),
(32, 'BR', 'Brazil'),
(33, 'IO', 'British lndian Ocean Territory'),
(34, 'BN', 'Brunei Darussalam'),
(35, 'BG', 'Bulgaria'),
(36, 'BF', 'Burkina Faso'),
(37, 'BI', 'Burundi'),
(38, 'KH', 'Cambodia'),
(39, 'CM', 'Cameroon'),
(40, 'CV', 'Cape Verde'),
(41, 'KY', 'Cayman Islands'),
(42, 'CF', 'Central African Republic'),
(43, 'TD', 'Chad'),
(44, 'CL', 'Chile'),
(45, 'CN', 'China'),
(46, 'CX', 'Christmas Island'),
(47, 'CC', 'Cocos (Keeling) Islands'),
(48, 'CO', 'Colombia'),
(49, 'KM', 'Comoros'),
(50, 'CG', 'Congo'),
(51, 'CK', 'Cook Islands'),
(52, 'CR', 'Costa Rica'),
(53, 'HR', 'Croatia (Hrvatska)'),
(54, 'CU', 'Cuba'),
(55, 'CY', 'Cyprus'),
(56, 'CZ', 'Czech Republic'),
(57, 'CD', 'Democratic Republic of Congo'),
(58, 'DK', 'Denmark'),
(59, 'DJ', 'Djibouti'),
(60, 'DM', 'Dominica'),
(61, 'DO', 'Dominican Republic'),
(62, 'TP', 'East Timor'),
(63, 'EC', 'Ecudaor'),
(64, 'EG', 'Egypt'),
(65, 'SV', 'El Salvador'),
(66, 'GQ', 'Equatorial Guinea'),
(67, 'ER', 'Eritrea'),
(68, 'EE', 'Estonia'),
(69, 'ET', 'Ethiopia'),
(70, 'FK', 'Falkland Islands (Malvinas)'),
(71, 'FO', 'Faroe Islands'),
(72, 'FJ', 'Fiji'),
(73, 'FI', 'Finland'),
(74, 'FR', 'France'),
(75, 'FX', 'France, Metropolitan'),
(76, 'GF', 'French Guiana'),
(77, 'PF', 'French Polynesia'),
(78, 'TF', 'French Southern Territories'),
(79, 'GA', 'Gabon'),
(80, 'GM', 'Gambia'),
(81, 'GE', 'Georgia'),
(82, 'DE', 'Germany'),
(83, 'GH', 'Ghana'),
(84, 'GI', 'Gibraltar'),
(85, 'GR', 'Greece'),
(86, 'GL', 'Greenland'),
(87, 'GD', 'Grenada'),
(88, 'GP', 'Guadeloupe'),
(89, 'GU', 'Guam'),
(90, 'GT', 'Guatemala'),
(91, 'GN', 'Guinea'),
(92, 'GW', 'Guinea-Bissau'),
(93, 'GY', 'Guyana'),
(94, 'HT', 'Haiti'),
(95, 'HM', 'Heard and Mc Donald Islands'),
(96, 'HN', 'Honduras'),
(97, 'HK', 'Hong Kong'),
(98, 'HU', 'Hungary'),
(99, 'IS', 'Iceland'),
(100, 'IN', 'India'),
(101, 'ID', 'Indonesia'),
(102, 'IR', 'Iran (Islamic Republic of)'),
(103, 'IQ', 'Iraq'),
(104, 'IE', 'Ireland'),
(105, 'IL', 'Israel'),
(106, 'IT', 'Italy'),
(107, 'CI', 'Ivory Coast'),
(108, 'JM', 'Jamaica'),
(109, 'JP', 'Japan'),
(110, 'JO', 'Jordan'),
(111, 'KZ', 'Kazakhstan'),
(112, 'KE', 'Kenya'),
(113, 'KI', 'Kiribati'),
(114, 'KP', 'Korea, Democratic People\'s Republic of'),
(115, 'KR', 'Korea, Republic of'),
(116, 'KW', 'Kuwait'),
(117, 'KG', 'Kyrgyzstan'),
(118, 'LA', 'Lao People\'s Democratic Republic'),
(119, 'LV', 'Latvia'),
(120, 'LB', 'Lebanon'),
(121, 'LS', 'Lesotho'),
(122, 'LR', 'Liberia'),
(123, 'LY', 'Libyan Arab Jamahiriya'),
(124, 'LI', 'Liechtenstein'),
(125, 'LT', 'Lithuania'),
(126, 'LU', 'Luxembourg'),
(127, 'MO', 'Macau'),
(128, 'MK', 'Macedonia'),
(129, 'MG', 'Madagascar'),
(130, 'MW', 'Malawi'),
(131, 'MY', 'Malaysia'),
(132, 'MV', 'Maldives'),
(133, 'ML', 'Mali'),
(134, 'MT', 'Malta'),
(135, 'MH', 'Marshall Islands'),
(136, 'MQ', 'Martinique'),
(137, 'MR', 'Mauritania'),
(138, 'MU', 'Mauritius'),
(139, 'TY', 'Mayotte'),
(140, 'MX', 'Mexico'),
(141, 'FM', 'Micronesia, Federated States of'),
(142, 'MD', 'Moldova, Republic of'),
(143, 'MC', 'Monaco'),
(144, 'MN', 'Mongolia'),
(145, 'MS', 'Montserrat'),
(146, 'MA', 'Morocco'),
(147, 'MZ', 'Mozambique'),
(148, 'MM', 'Myanmar'),
(149, 'NA', 'Namibia'),
(150, 'NR', 'Nauru'),
(151, 'NP', 'Nepal'),
(152, 'NL', 'Netherlands'),
(153, 'AN', 'Netherlands Antilles'),
(154, 'NC', 'New Caledonia'),
(155, 'NZ', 'New Zealand'),
(156, 'NI', 'Nicaragua'),
(157, 'NE', 'Niger'),
(158, 'NG', 'Nigeria'),
(159, 'NU', 'Niue'),
(160, 'NF', 'Norfork Island'),
(161, 'MP', 'Northern Mariana Islands'),
(162, 'NO', 'Norway'),
(163, 'OM', 'Oman'),
(164, 'PK', 'Pakistan'),
(165, 'PW', 'Palau'),
(166, 'PA', 'Panama'),
(167, 'PG', 'Papua New Guinea'),
(168, 'PY', 'Paraguay'),
(169, 'PE', 'Peru'),
(170, 'PH', 'Philippines'),
(171, 'PN', 'Pitcairn'),
(172, 'PL', 'Poland'),
(173, 'PT', 'Portugal'),
(174, 'PR', 'Puerto Rico'),
(175, 'QA', 'Qatar'),
(176, 'SS', 'Republic of South Sudan'),
(177, 'RE', 'Reunion'),
(178, 'RO', 'Romania'),
(179, 'RU', 'Russian Federation'),
(180, 'RW', 'Rwanda'),
(181, 'KN', 'Saint Kitts and Nevis'),
(182, 'LC', 'Saint Lucia'),
(183, 'VC', 'Saint Vincent and the Grenadines'),
(184, 'WS', 'Samoa'),
(185, 'SM', 'San Marino'),
(186, 'ST', 'Sao Tome and Principe'),
(187, 'SA', 'Saudi Arabia'),
(188, 'SN', 'Senegal'),
(189, 'RS', 'Serbia'),
(190, 'SC', 'Seychelles'),
(191, 'SL', 'Sierra Leone'),
(192, 'SG', 'Singapore'),
(193, 'SK', 'Slovakia'),
(194, 'SI', 'Slovenia'),
(195, 'SB', 'Solomon Islands'),
(196, 'SO', 'Somalia'),
(197, 'ZA', 'South Africa'),
(198, 'GS', 'South Georgia South Sandwich Islands'),
(199, 'ES', 'Spain'),
(200, 'LK', 'Sri Lanka'),
(201, 'SH', 'St. Helena'),
(202, 'PM', 'St. Pierre and Miquelon'),
(203, 'SD', 'Sudan'),
(204, 'SR', 'Suriname'),
(205, 'SJ', 'Svalbarn and Jan Mayen Islands'),
(206, 'SZ', 'Swaziland'),
(207, 'SE', 'Sweden'),
(208, 'CH', 'Switzerland'),
(209, 'SY', 'Syrian Arab Republic'),
(210, 'TW', 'Taiwan'),
(211, 'TJ', 'Tajikistan'),
(212, 'TZ', 'Tanzania, United Republic of'),
(213, 'TH', 'Thailand'),
(214, 'TG', 'Togo'),
(215, 'TK', 'Tokelau'),
(216, 'TO', 'Tonga'),
(217, 'TT', 'Trinidad and Tobago'),
(218, 'TN', 'Tunisia'),
(219, 'TR', 'Turkey'),
(220, 'TM', 'Turkmenistan'),
(221, 'TC', 'Turks and Caicos Islands'),
(222, 'TV', 'Tuvalu'),
(223, 'UG', 'Uganda'),
(224, 'UA', 'Ukraine'),
(225, 'AE', 'United Arab Emirates'),
(226, 'GB', 'United Kingdom'),
(227, 'UM', 'United States minor outlying islands'),
(228, 'UY', 'Uruguay'),
(229, 'UZ', 'Uzbekistan'),
(230, 'VU', 'Vanuatu'),
(231, 'VA', 'Vatican City State'),
(232, 'VE', 'Venezuela'),
(233, 'VN', 'Vietnam'),
(234, 'VG', 'Virgin Islands (British)'),
(235, 'VI', 'Virgin Islands (U.S.)'),
(236, 'WF', 'Wallis and Futuna Islands'),
(237, 'EH', 'Western Sahara'),
(238, 'YE', 'Yemen'),
(239, 'YU', 'Yugoslavia'),
(240, 'ZR', 'Zaire'),
(241, 'ZM', 'Zambia'),
(242, 'ZW', 'Zimbabwe');

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

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `symbol` varchar(5) 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 `currencies`
--

INSERT INTO `currencies` (`id`, `name`, `code`, `symbol`, `created_at`, `updated_at`) VALUES
(1, 'Afghani', 'AFN', '؋', NULL, NULL),
(2, 'Lek', 'ALL', 'Lek', NULL, NULL),
(3, 'Netherlands Antillian Guilder', 'ANG', 'ƒ', NULL, NULL),
(4, 'Argentine Peso', 'ARS', '$', NULL, NULL),
(5, 'Australian Dollar', 'AUD', '$', NULL, NULL),
(6, 'Aruban Guilder', 'AWG', 'ƒ', NULL, NULL),
(7, 'Azerbaijanian Manat', 'AZN', 'ман', NULL, NULL),
(8, 'Convertible Marks', 'BAM', 'KM', NULL, NULL),
(9, 'Bangladeshi Taka', 'BDT', '৳', NULL, NULL),
(10, 'Barbados Dollar', 'BBD', '$', NULL, NULL),
(11, 'Bulgarian Lev', 'BGN', 'лв', NULL, NULL),
(12, 'Bermudian Dollar', 'BMD', '$', NULL, NULL),
(13, 'Brunei Dollar', 'BND', '$', NULL, NULL),
(14, 'BOV Boliviano Mvdol', 'BOB', '$b', NULL, NULL),
(15, 'Brazilian Real', 'BRL', 'R$', NULL, NULL),
(16, 'Bahamian Dollar', 'BSD', '$', NULL, NULL),
(17, 'Pula', 'BWP', 'P', NULL, NULL),
(18, 'Belarussian Ruble', 'BYR', '₽', NULL, NULL),
(19, 'Belize Dollar', 'BZD', 'BZ$', NULL, NULL),
(20, 'Canadian Dollar', 'CAD', '$', NULL, NULL),
(21, 'Swiss Franc', 'CHF', 'CHF', NULL, NULL),
(22, 'CLF Chilean Peso Unidades de fomento', 'CLP', '$', NULL, NULL),
(23, 'Yuan Renminbi', 'CNY', '¥', NULL, NULL),
(24, 'COU Colombian Peso Unidad de Valor Real', 'COP', '$', NULL, NULL),
(25, 'Costa Rican Colon', 'CRC', '₡', NULL, NULL),
(26, 'CUC Cuban Peso Peso Convertible', 'CUP', '₱', NULL, NULL),
(27, 'Czech Koruna', 'CZK', 'Kč', NULL, NULL),
(28, 'Danish Krone', 'DKK', 'kr', NULL, NULL),
(29, 'Dominican Peso', 'DOP', 'RD$', NULL, NULL),
(30, 'Egyptian Pound', 'EGP', '£', NULL, NULL),
(31, 'Euro', 'EUR', '€', NULL, NULL),
(32, 'Fiji Dollar', 'FJD', '$', NULL, NULL),
(33, 'Falkland Islands Pound', 'FKP', '£', NULL, NULL),
(34, 'Pound Sterling', 'GBP', '£', NULL, NULL),
(35, 'Gibraltar Pound', 'GIP', '£', NULL, NULL),
(36, 'Quetzal', 'GTQ', 'Q', NULL, NULL),
(37, 'Guyana Dollar', 'GYD', '$', NULL, NULL),
(38, 'Hong Kong Dollar', 'HKD', '$', NULL, NULL),
(39, 'Lempira', 'HNL', 'L', NULL, NULL),
(40, 'Croatian Kuna', 'HRK', 'kn', NULL, NULL),
(41, 'Forint', 'HUF', 'Ft', NULL, NULL),
(42, 'Rupiah', 'IDR', 'Rp', NULL, NULL),
(43, 'New Israeli Sheqel', 'ILS', '₪', NULL, NULL),
(44, 'Iranian Rial', 'IRR', '﷼', NULL, NULL),
(45, 'Iceland Krona', 'ISK', 'kr', NULL, NULL),
(46, 'Jamaican Dollar', 'JMD', 'J$', NULL, NULL),
(47, 'Yen', 'JPY', '¥', NULL, NULL),
(48, 'Som', 'KGS', 'лв', NULL, NULL),
(49, 'Riel', 'KHR', '៛', NULL, NULL),
(50, 'North Korean Won', 'KPW', '₩', NULL, NULL),
(51, 'Won', 'KRW', '₩', NULL, NULL),
(52, 'Cayman Islands Dollar', 'KYD', '$', NULL, NULL),
(53, 'Tenge', 'KZT', 'лв', NULL, NULL),
(54, 'Kip', 'LAK', '₭', NULL, NULL),
(55, 'Lebanese Pound', 'LBP', '£', NULL, NULL),
(56, 'Sri Lanka Rupee', 'LKR', '₨', NULL, NULL),
(57, 'Liberian Dollar', 'LRD', '$', NULL, NULL),
(58, 'Lithuanian Litas', 'LTL', 'Lt', NULL, NULL),
(59, 'Latvian Lats', 'LVL', 'Ls', NULL, NULL),
(60, 'Denar', 'MKD', 'ден', NULL, NULL),
(61, 'Tugrik', 'MNT', '₮', NULL, NULL),
(62, 'Mauritius Rupee', 'MUR', '₨', NULL, NULL),
(63, 'MXV Mexican Peso Mexican Unidad de Inversion (UDI]', 'MXN', '$', NULL, NULL),
(64, 'Malaysian Ringgit', 'MYR', 'RM', NULL, NULL),
(65, 'Metical', 'MZN', 'MT', NULL, NULL),
(66, 'Naira', 'NGN', '₦', NULL, NULL),
(67, 'Cordoba Oro', 'NIO', 'C$', NULL, NULL),
(68, 'Norwegian Krone', 'NOK', 'kr', NULL, NULL),
(69, 'Nepalese Rupee', 'NPR', '₨', NULL, NULL),
(70, 'New Zealand Dollar', 'NZD', '$', NULL, NULL),
(71, 'Rial Omani', 'OMR', '﷼', NULL, NULL),
(72, 'USD Balboa US Dollar', 'PAB', 'B/.', NULL, NULL),
(73, 'Nuevo Sol', 'PEN', 'S/.', NULL, NULL),
(74, 'Philippine Peso', 'PHP', 'Php', NULL, NULL),
(75, 'Pakistan Rupee', 'PKR', '₨', NULL, NULL),
(76, 'Zloty', 'PLN', 'zł', NULL, NULL),
(77, 'Guarani', 'PYG', 'Gs', NULL, NULL),
(78, 'Qatari Rial', 'QAR', '﷼', NULL, NULL),
(79, 'New Leu', 'RON', 'lei', NULL, NULL),
(80, 'Serbian Dinar', 'RSD', 'Дин.', NULL, NULL),
(81, 'Russian Ruble', 'RUB', 'руб', NULL, NULL),
(82, 'Saudi Riyal', 'SAR', '﷼', NULL, NULL),
(83, 'Solomon Islands Dollar', 'SBD', '$', NULL, NULL),
(84, 'Seychelles Rupee', 'SCR', '₨', NULL, NULL),
(85, 'Swedish Krona', 'SEK', 'kr', NULL, NULL),
(86, 'Singapore Dollar', 'SGD', '$', NULL, NULL),
(87, 'Saint Helena Pound', 'SHP', '£', NULL, NULL),
(88, 'Somali Shilling', 'SOS', 'S', NULL, NULL),
(89, 'Surinam Dollar', 'SRD', '$', NULL, NULL),
(90, 'USD El Salvador Colon US Dollar', 'SVC', '$', NULL, NULL),
(91, 'Syrian Pound', 'SYP', '£', NULL, NULL),
(92, 'Baht', 'THB', '฿', NULL, NULL),
(93, 'Turkish Lira', 'TRY', 'TL', NULL, NULL),
(94, 'Trinidad and Tobago Dollar', 'TTD', 'TT$', NULL, NULL),
(95, 'New Taiwan Dollar', 'TWD', 'NT$', NULL, NULL),
(96, 'Hryvnia', 'UAH', '₴', NULL, NULL),
(97, 'US Dollar', 'USD', '$', NULL, NULL),
(98, 'UYI Uruguay Peso en Unidades Indexadas', 'UYU', '$U', NULL, NULL),
(99, 'Uzbekistan Sum', 'UZS', 'лв', NULL, NULL),
(100, 'Bolivar Fuerte', 'VEF', 'Bs', NULL, NULL),
(101, 'Dong', 'VND', '₫', NULL, NULL),
(102, 'East Caribbean Dollar', 'XCD', '$', NULL, NULL),
(103, 'Yemeni Rial', 'YER', '﷼', NULL, NULL),
(104, 'Rand', 'ZAR', 'R', NULL, NULL);

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

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

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

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

--
-- Table structure for table `invoice_reports`
--

CREATE TABLE `invoice_reports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `booking_no` varchar(255) DEFAULT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `agent_id` varchar(255) DEFAULT NULL,
  `charge` varchar(255) DEFAULT NULL,
  `collect_amount` varchar(255) DEFAULT NULL,
  `charge_amount` varchar(255) DEFAULT NULL,
  `status` varchar(255) 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 `invoice_reports`
--

INSERT INTO `invoice_reports` (`id`, `booking_no`, `invoice_no`, `agent_id`, `charge`, `collect_amount`, `charge_amount`, `status`, `created_at`, `updated_at`) VALUES
(1, 'TS2025080512', 'INV11499', NULL, '121212', '12121212', '12', 'Order fulfillment', '2025-08-05 02:20:32', '2025-08-05 02:20:32');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2024_02_12_024938_create_companies_table', 1),
(6, '2024_02_12_085438_create_charges_table', 1),
(7, '2024_02_12_085450_create_agents_table', 1),
(8, '2024_02_12_091915_create_countries_table', 1),
(9, '2024_02_12_091934_create_currencies_table', 1),
(10, '2024_02_15_040821_create_admin_wise_agents_table', 1),
(11, '2024_02_15_102434_create_bookings_table', 1),
(12, '2024_02_18_103133_create_invoice_reports_table', 1),
(13, '2024_02_18_103844_create_agent_payments_table', 1),
(14, '2024_02_19_050744_create_booking_status_histories_table', 1),
(15, '2024_02_19_093540_create_transfer_invoices_table', 1),
(16, '2024_02_19_170448_create_booking_transfer_deatils_table', 1),
(17, '2024_02_25_032459_create_services_table', 1),
(18, '2025_07_21_071746_create_book_invoices_table', 2),
(19, '2025_08_12_073008_create_collections_table', 3),
(20, '2025_08_12_081902_create_collections_table', 4),
(21, '2025_08_13_083110_add_collection_id_to_collections_table', 5);

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

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

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) 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 `services`
--

INSERT INTO `services` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'DHL', '2024-05-30 04:04:00', '2024-05-30 04:04:00'),
(2, 'FEDEX', '2025-04-23 16:31:09', '2025-04-23 16:31:09'),
(3, 'DPD', '2025-04-23 16:31:16', '2025-04-23 16:31:16'),
(4, 'redex', '2025-08-12 03:58:53', '2025-08-12 03:58:53');

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

--
-- Table structure for table `transfer_invoices`
--

CREATE TABLE `transfer_invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `agent_id` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- Indexes for table `collections`
--
ALTER TABLE `collections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `collections_collection_id_unique` (`collection_id`),
  ADD KEY `collections_booking_id_foreign` (`booking_id`);

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

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

--
-- Indexes for table `currencies`
--
ALTER TABLE `currencies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `currencies_name_unique` (`name`),
  ADD UNIQUE KEY `currencies_code_unique` (`code`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `collections`
--
ALTER TABLE `collections`
  ADD CONSTRAINT `collections_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE SET NULL;
COMMIT;

