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

START TRANSACTION;



--
-- Database: `mlo_erp`
--

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

--
-- Table structure for table `actions`
--

CREATE TABLE `actions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_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 `action_step`
--

CREATE TABLE `action_step` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `action_id` bigint(20) UNSIGNED NOT NULL,
  `step_id` bigint(20) UNSIGNED NOT NULL,
  `order_sl` bigint(20) UNSIGNED NOT NULL COMMENT 'asc 1 to 10...',
  `is_required` tinyint(1) NOT NULL DEFAULT '0',
  `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 `admins`
--

CREATE TABLE `admins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `days_for_backdate_post` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `store_data_fetch` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `warehouse_id` bigint(20) UNSIGNED NOT NULL COMMENT 'active warehouse id',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_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;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `status`, `days_for_backdate_post`, `store_data_fetch`, `warehouse_id`, `created_by`, `updated_by`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin@gmail.com', NULL, '$2y$10$423ArVjAaxUwXc2N/vvI3e2lzy0hHaaXXNTpxd6TIrNBYd/OH7.TC', NULL, 1, 0, 0, 7, 1, NULL, NULL, NULL, NULL, '2021-11-27 01:48:23');

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

--
-- Table structure for table `admin_costcenter`
--

CREATE TABLE `admin_costcenter` (
  `admin_id` bigint(20) UNSIGNED NOT NULL,
  `cost_center_id` bigint(20) 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 `admin_costcenter`
--

INSERT INTO `admin_costcenter` (`admin_id`, `cost_center_id`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL);

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

--
-- Table structure for table `admin_role`
--

CREATE TABLE `admin_role` (
  `admin_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) 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 `admin_role`
--

INSERT INTO `admin_role` (`admin_id`, `role_id`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL);

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

--
-- Table structure for table `admin_warehouse`
--

CREATE TABLE `admin_warehouse` (
  `admin_id` bigint(20) UNSIGNED NOT NULL,
  `warehouse_id` bigint(20) 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 `admin_warehouse`
--

INSERT INTO `admin_warehouse` (`admin_id`, `warehouse_id`, `created_at`, `updated_at`) VALUES
(1, 7, NULL, NULL);

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

--
-- Table structure for table `approvals`
--

CREATE TABLE `approvals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `approvable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approvable_id` bigint(20) UNSIGNED NOT NULL,
  `action_step_id` bigint(20) UNSIGNED DEFAULT NULL,
  `admin_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Approved or rejected by',
  `status` bigint(20) UNSIGNED NOT NULL COMMENT '0=>Rejected , 1=>Approved ',
  `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 `costcenter_mappings`
--

CREATE TABLE `costcenter_mappings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `action_step_id` bigint(20) UNSIGNED NOT NULL,
  `cost_center_id` bigint(20) UNSIGNED DEFAULT NULL,
  `admin_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` 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;

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

--
-- Table structure for table `cost_centers`
--

CREATE TABLE `cost_centers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_local` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED NOT NULL,
  `default` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'active = 1 inactive =0',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'active = 1 inactive =0',
  `created_by` bigint(20) UNSIGNED NOT NULL DEFAULT '1',
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` 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 `cost_centers`
--

INSERT INTO `cost_centers` (`id`, `name`, `name_local`, `parent_id`, `warehouse_id`, `default`, `status`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`) VALUES
(1, 'Default Branch', 'Default Branch', NULL, 1, 1, 1, 1, NULL, NULL, NULL, NULL),
(2, 'Default Branch', 'Default Branch', NULL, 7, 1, 1, 1, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `database_backups`
--

CREATE TABLE `database_backups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `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 `database_credentials`
--

CREATE TABLE `database_credentials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `db_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `db_username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `db_password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `db_host_ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ignore_tables` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'input format = db_name.table1, db_name.table2',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `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(20) UNSIGNED 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 `logs`
--

CREATE TABLE `logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `laggable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `laggable_id` bigint(20) UNSIGNED NOT NULL,
  `log_data` json DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'active = 1 inactive =0',
  `warehouse_id` bigint(20) UNSIGNED 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 `marketing_admins`
--

CREATE TABLE `marketing_admins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `office_level_id` bigint(20) UNSIGNED DEFAULT NULL,
  `admin_id` bigint(20) UNSIGNED NOT NULL,
  `group_ids` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'keep comma separated customer group ids',
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=on/0=off',
  `warehouse_id` int(10) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` 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;

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

--
-- 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, '2013_01_23_105832_create_warehouses_table', 1),
(2, '2013_02_16_082341_create_admins_table', 1),
(3, '2013_02_17_070310_admin_warehouse', 1),
(4, '2014_01_04_094000_create_modules_table', 1),
(5, '2014_01_04_095651_create_module_wise_tables_table', 1),
(6, '2014_10_12_000000_create_users_table', 1),
(7, '2014_10_12_100000_create_password_resets_table', 1),
(8, '2019_08_19_000000_create_failed_jobs_table', 1),
(9, '2020_12_20_093515_create_roles_table', 1),
(10, '2020_12_20_094104_create_permissions_table', 1),
(11, '2020_12_20_101009_permission_role', 1),
(12, '2020_12_22_100521_module_role', 1),
(13, '2020_12_27_042415_module_warehouse', 1),
(14, '2021_01_12_105223_create_cost_centers_table', 1),
(15, '2021_02_16_091416_admin_role', 1),
(16, '2021_03_01_065402_create_actions_table', 1),
(17, '2021_03_01_065701_create_steps_table', 1),
(18, '2021_03_01_065815_action_step', 1),
(19, '2021_03_01_065851_create_role_mappings_table', 1),
(20, '2021_03_02_094925_create_approvals_table', 1),
(21, '2021_04_05_105146_create_step_settings_table', 1),
(22, '2021_04_05_154824_create_quick_accesses_table', 1),
(23, '2021_04_05_173245_admin_costcenter', 1),
(24, '2021_04_05_174135_create_costcenter_mappings_table', 1),
(25, '2021_04_21_132410_create_logs_table', 1),
(26, '2021_06_14_152402_create_report_print_set_ups_table', 1),
(27, '2021_06_26_071659_create_vat_taxes_table', 1),
(28, '2021_08_09_123732_create_marketing_admins_table', 1),
(29, '2021_08_22_120230_create_database_backups_table', 1),
(30, '2021_08_22_120740_create_database_credentials_table', 1),
(32, '2021_11_27_094925_create_customers_table', 2),
(33, '2021_11_28_065259_create_mlo_customers_table', 3),
(35, '2021_11_28_095047_create_mlo_msns_table', 4),
(36, '2021_11_28_100747_create_mlo_scns_table', 5),
(37, '2021_12_01_101004_create_mlo_eq_port_lists_table', 6),
(38, '2021_12_01_104740_create_mlo_commodities_table', 6),
(39, '2021_12_01_110657_create_mlo_eq_depots_table', 6),
(40, '2021_12_02_095458_create_mlo_ctr_code_ci_table', 6),
(41, '2021_12_04_060017_create_mlo_container_type_groups_table', 6),
(48, '2021_12_04_083014_create_mlo_booking_advice_table', 7),
(49, '2021_12_04_083101_create_mlo_booking_advice_details_table', 7),
(50, '2021_12_06_045723_create_shipping_orders_table', 8),
(52, '2021_12_06_054523_create_mlo_shipping_orders_table', 9),
(57, '2021_12_07_064406_create_mlo_eq_vessels_table', 10),
(58, '2021_12_07_102026_create_mlo_preshipment_advice_table', 10);

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

--
-- Table structure for table `mlo_booking_advice`
--

CREATE TABLE `mlo_booking_advice` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `booking_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'booking party',
  `is_stuffed` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'is stuff =1 ohter wise 0',
  `shipper_id` bigint(20) UNSIGNED DEFAULT NULL,
  `pol_id` bigint(20) UNSIGNED DEFAULT NULL,
  `fpod_id` bigint(20) UNSIGNED DEFAULT NULL,
  `shipping_term` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'FCL Or LCL',
  `commodity_id` bigint(20) UNSIGNED DEFAULT NULL,
  `c_qty` int(11) NOT NULL DEFAULT '0' COMMENT 'cargo quantity',
  `c_weight` int(11) NOT NULL DEFAULT '0' COMMENT 'cargo weight',
  `package_type_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'package type id',
  `payment_mode` tinyint(1) NOT NULL COMMENT 'prepaid = 1,collect = 2',
  `cnf_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'C&F Name',
  `pic` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'PIC & Mobile NO',
  `dg_non_dg` tinyint(1) NOT NULL COMMENT 'IS THIS SHIPMENT HAZARDOUS  yes = 1 no =2',
  `un_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'if dg_nondg = yes',
  `imco` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'if dg_nondg = yes',
  `flash_point` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'if dg_nondg = yes',
  `temp` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'if container type RF/RH/HR ',
  `ventilation` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'if container type RF/RH/HR ',
  `stuffing_location_id` bigint(20) UNSIGNED DEFAULT NULL,
  `stuffing_location_date` datetime DEFAULT NULL,
  `invoice_file` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Might be any kind of file',
  `packing_list_file` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Might be any kind of file',
  `msds_file` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Might be any kind of file',
  `warehouse_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `last_updated_type` tinyint(1) DEFAULT NULL COMMENT '1 =admin, 2 = customer',
  `approved_by` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL COMMENT 'ba p = 2,a=3; sho p =4,a=5; prso p=6 a=7;bld p=8,a=9',
  `deleted_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;

--
-- Dumping data for table `mlo_booking_advice`
--

INSERT INTO `mlo_booking_advice` (`id`, `booking_number`, `customer_id`, `is_stuffed`, `shipper_id`, `pol_id`, `fpod_id`, `shipping_term`, `commodity_id`, `c_qty`, `c_weight`, `package_type_id`, `payment_mode`, `cnf_name`, `pic`, `dg_non_dg`, `un_no`, `imco`, `flash_point`, `temp`, `ventilation`, `stuffing_location_id`, `stuffing_location_date`, `invoice_file`, `packing_list_file`, `msds_file`, `warehouse_id`, `created_by`, `updated_by`, `last_updated_type`, `approved_by`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'SCCMYPMYP2112001', 1, 0, 2, 2, 2, '2', 2, 20, 200, '1B', 2, 'Jasim', '01624772008', 1, '2008', '2998', '2009', '2009', 'uu222', 5, '2021-12-07 19:00:00', NULL, NULL, NULL, 7, 1, NULL, NULL, 1, 7, NULL, '2021-12-08 01:27:51', '2021-12-08 03:58:58'),
(2, 'SCCSGSMYB2112002', 1, 0, 2, 1, 3, '1', 3, 12, 90, '1D', 2, 'REWR', '3423', 1, '3423', '34', '34', '4', '6', 2, '2021-12-08 03:00:00', NULL, NULL, NULL, 7, 1, NULL, NULL, 1, 3, NULL, '2021-12-08 05:25:47', '2021-12-08 05:39:55'),
(3, 'SCCMYPMYP2112003', 1, 0, 3, 2, 2, '2', 1, 10, 200, '1B', 2, 'Jahed', '0001', 2, NULL, NULL, NULL, NULL, NULL, 1, '2021-12-07 17:00:00', NULL, NULL, NULL, 7, 1, NULL, NULL, 1, 7, NULL, '2021-12-08 06:22:47', '2021-12-08 06:28:07');

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

--
-- Table structure for table `mlo_booking_advice_details`
--

CREATE TABLE `mlo_booking_advice_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `mlo_booking_advice_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'id from mlo_booking_advices table',
  `ctr_size_type_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'container size type table = mlo_container_type_groups',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `deleted_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;

--
-- Dumping data for table `mlo_booking_advice_details`
--

INSERT INTO `mlo_booking_advice_details` (`id`, `mlo_booking_advice_id`, `ctr_size_type_id`, `quantity`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 3, 60, NULL, '2021-12-06 03:06:48', '2021-12-07 00:09:04'),
(2, 1, 1, 80, NULL, '2021-12-06 03:06:48', '2021-12-07 00:09:04'),
(3, 2, 4, 2, NULL, '2021-12-06 03:11:59', '2021-12-06 03:11:59'),
(4, 2, 11, 3, NULL, '2021-12-06 03:11:59', '2021-12-06 03:11:59'),
(5, 3, 3, 23, NULL, '2021-12-06 05:11:22', '2021-12-06 05:11:22'),
(6, 3, 5, 60, NULL, '2021-12-06 05:11:22', '2021-12-07 00:06:23'),
(7, 4, 3, 23, NULL, '2021-12-06 05:13:58', '2021-12-06 05:13:58'),
(9, 5, 3, 23, NULL, '2021-12-06 23:23:40', '2021-12-06 23:23:40'),
(10, 6, 3, 23, NULL, '2021-12-06 23:32:29', '2021-12-06 23:32:29'),
(11, 7, 3, 23, NULL, '2021-12-06 23:34:41', '2021-12-06 23:34:41'),
(12, 1, 9, 100, NULL, '2021-12-07 00:18:12', '2021-12-07 00:18:12'),
(13, 1, 3, 20, NULL, '2021-12-08 01:27:51', '2021-12-08 01:27:51'),
(14, 1, 4, 10, NULL, '2021-12-08 01:27:51', '2021-12-08 01:27:51'),
(15, 2, 3, 4, NULL, '2021-12-08 05:25:47', '2021-12-08 05:25:47'),
(16, 3, 4, 20, NULL, '2021-12-08 06:22:47', '2021-12-08 06:22:47');

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

--
-- Table structure for table `mlo_commodities`
--

CREATE TABLE `mlo_commodities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `vat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'yes/no',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `type` tinyint(1) NOT NULL COMMENT '1=import, 2=export',
  `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;

--
-- Dumping data for table `mlo_commodities`
--

INSERT INTO `mlo_commodities` (`id`, `code`, `name`, `vat`, `status`, `type`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 'Bicycle', 'Yes', 1, 2, '2020-02-02 08:47:20', NULL, NULL),
(2, NULL, 'Brash Scrape', 'Yes', 1, 2, '2020-02-02 08:47:21', NULL, NULL),
(3, NULL, 'Ceramics', 'Yes', 1, 2, '2020-02-02 08:47:22', NULL, NULL),
(4, NULL, 'Charcoal', 'Yes', 1, 2, '2020-02-02 08:47:23', NULL, NULL),
(5, NULL, 'Denim Fabric', 'Yes', 1, 2, '2020-02-02 08:47:24', NULL, NULL),
(6, NULL, 'Electronics', 'Yes', 1, 2, '2020-02-02 08:47:25', NULL, NULL),
(7, NULL, 'Food Items', 'Yes', 1, 2, '2020-02-02 08:47:26', NULL, NULL),
(8, NULL, 'Footwear', 'Yes', 1, 2, '2020-02-02 08:47:27', NULL, NULL),
(9, NULL, 'Frozen Fish', 'Yes', 1, 2, '2020-02-02 08:47:28', NULL, NULL),
(10, NULL, 'Fruits', 'Yes', 1, 2, '2020-02-02 08:47:29', NULL, NULL),
(11, NULL, 'Furniture', 'Yes', 1, 2, '2020-02-02 08:47:30', NULL, NULL),
(12, NULL, 'Handicrafts', 'YES', 1, 2, '2020-02-02 08:47:31', '2021-11-25 04:21:29', NULL),
(13, NULL, 'Hair Product', 'Yes', 1, 2, '2020-02-02 08:47:32', NULL, NULL),
(14, NULL, 'Halal Meat', 'Yes', 1, 2, '2020-02-02 08:47:33', NULL, NULL),
(15, NULL, 'Herbs & Herbal', 'Yes', 1, 2, '2020-02-02 08:47:34', NULL, NULL),
(16, NULL, 'Home Textile', 'Yes', 1, 2, '2020-02-02 08:47:35', NULL, NULL),
(17, NULL, 'Jewelry', 'Yes', 1, 2, '2020-02-02 08:47:36', NULL, NULL),
(18, NULL, 'Jute Goods', 'Yes', 1, 2, '2020-02-02 08:47:37', NULL, NULL),
(19, NULL, 'Jute Yarn', 'YES', 1, 2, '2020-02-02 08:47:38', NULL, NULL),
(20, NULL, 'Knitted Fabric', 'Yes', 1, 2, '2020-02-02 08:47:39', NULL, NULL),
(21, NULL, 'Leather Goods', 'Yes', 1, 2, '2020-02-02 08:47:40', NULL, NULL),
(22, NULL, 'Live Fish', 'Yes', 1, 2, '2020-02-02 08:47:41', NULL, NULL),
(23, NULL, 'Marine Fisheries', 'Yes', 1, 2, '2020-02-02 08:47:42', NULL, NULL),
(24, NULL, 'Medicine', 'Yes', 1, 2, '2020-02-02 08:47:43', NULL, NULL),
(25, NULL, 'Mill Scale', 'Yes', 1, 2, '2020-02-02 08:47:44', NULL, NULL),
(26, NULL, 'Mosquito Net', 'Yes', 1, 2, '2020-02-02 08:47:45', NULL, NULL),
(27, NULL, 'Paper', 'Yes', 1, 2, '2020-02-02 08:47:46', NULL, NULL),
(28, NULL, 'Partical Board', 'Yes', 1, 2, '2020-02-02 08:47:47', NULL, NULL),
(29, NULL, 'Pet Bottle Flakes', 'Yes', 1, 2, '2020-02-02 08:47:48', NULL, NULL),
(30, NULL, 'Plastic Goods', 'Yes', 1, 2, '2020-02-02 08:47:49', NULL, NULL),
(31, NULL, 'Potato', 'Yes', 1, 2, '2020-02-02 08:47:50', NULL, NULL),
(32, NULL, 'PVC Bags', 'Yes', 1, 2, '2020-02-02 08:47:51', NULL, NULL),
(33, NULL, 'Raw Jute', 'Yes', 1, 2, '2020-02-02 08:47:52', NULL, NULL),
(34, NULL, 'Ready Made Garments', 'No', 1, 2, '2020-02-02 08:47:53', NULL, NULL),
(35, NULL, 'Rice Bran Oil', 'Yes', 1, 2, '2020-02-02 08:47:54', NULL, NULL),
(36, NULL, 'Rubber', 'Yes', 1, 2, '2020-02-02 08:47:55', NULL, NULL),
(37, NULL, 'Rubber Smoked Sheet', 'Yes', 1, 2, '2020-02-02 08:47:56', NULL, NULL),
(38, NULL, 'Tea', 'Yes', 1, 2, '2020-02-02 08:47:57', NULL, NULL),
(39, NULL, 'Terry Towel', 'Yes', 1, 2, '2020-02-02 08:47:58', NULL, NULL),
(40, NULL, 'Tobacco', 'Yes', 1, 2, '2020-02-02 08:47:59', NULL, NULL),
(41, NULL, 'Toiletries', 'Yes', 1, 2, '0000-00-00 00:00:00', NULL, NULL),
(42, NULL, 'Toys', 'Yes', 1, 2, '0000-00-00 00:00:00', NULL, NULL),
(43, NULL, 'Vegetables', 'Yes', 1, 2, '0000-00-00 00:00:00', NULL, NULL),
(44, NULL, 'Yarn', 'YES', 1, 2, '0000-00-00 00:00:00', NULL, NULL),
(51, NULL, 'Rope', 'YES', 1, 2, '2020-08-10 09:06:16', NULL, NULL),
(52, NULL, 'Tent', 'YES', 1, 2, '2020-08-13 10:45:18', NULL, NULL),
(53, NULL, 'Hand Gloves', 'YES', 1, 2, '2020-08-16 05:36:19', NULL, NULL),
(54, NULL, 'Sleeping Bag', 'YES', 1, 2, '2020-08-16 06:41:48', NULL, NULL),
(55, NULL, 'Cap', 'YES', 1, 2, '2020-09-02 05:39:15', NULL, NULL),
(56, NULL, 'Westage', 'YES', 1, 2, '2020-09-13 06:51:46', NULL, NULL),
(57, NULL, 'Cotton Tote Bag', 'YES', 1, 2, '2020-09-15 04:13:01', NULL, NULL),
(58, NULL, 'Carrying Bag', 'YES', 1, 2, '2020-09-20 06:14:12', NULL, NULL),
(59, NULL, 'Blood Tubing', 'NO', 1, 2, '2020-09-29 04:53:56', NULL, NULL),
(60, NULL, 'Crude Sesame Oil', 'YES', 1, 2, '2020-10-06 05:56:34', NULL, NULL),
(61, NULL, 'Sesame Seed', 'YES', 1, 2, '2020-10-06 06:01:11', NULL, NULL),
(62, NULL, 'Canola Meal', 'YES', 1, 2, '2020-10-18 04:29:35', NULL, NULL),
(63, NULL, 'Back Pack', 'YES', 1, 2, '2020-11-06 05:15:29', NULL, NULL),
(64, NULL, 'Cotton Waste', 'YES', 1, 2, '2020-11-13 06:00:11', NULL, NULL),
(65, NULL, 'Cotton Febric', 'YES', 1, 2, '2020-11-13 06:00:36', NULL, NULL),
(66, NULL, 'WHEAT ATTA', 'YES', 1, 2, '2020-11-16 08:13:48', NULL, NULL),
(67, NULL, 'Pet Pacakging Strap', 'YES', 1, 2, '2020-11-18 09:23:00', NULL, NULL),
(68, NULL, 'Duck Feather', 'YES', 1, 2, '2020-11-19 05:16:51', NULL, NULL),
(69, NULL, 'Sleeper', 'YES', 1, 2, '2020-11-22 07:24:52', NULL, NULL),
(70, NULL, 'Wiping Rags', 'YES', 1, 2, '2020-11-29 06:41:42', NULL, NULL),
(71, NULL, 'Kitchen Utilities', 'YES', 1, 2, '2020-11-29 08:57:56', NULL, NULL),
(72, NULL, 'Dot Printer', 'YES', 1, 2, '2020-11-30 04:31:56', NULL, NULL),
(73, NULL, 'Fish Scale', 'YES', 1, 2, '2020-12-01 04:07:28', NULL, NULL),
(74, NULL, 'Camping Chair', 'YES', 1, 2, '2020-12-02 06:43:13', NULL, NULL),
(75, NULL, 'Fishing Tackle', 'NO', 1, 2, '2020-12-06 05:31:33', NULL, NULL),
(76, NULL, 'PET Packing Straps Belt', 'YES', 1, 2, '2020-12-07 05:46:07', NULL, NULL),
(77, NULL, 'Toilet & Facial Tissue', 'YES', 1, 2, '2020-12-09 05:07:53', NULL, NULL),
(78, NULL, 'Poly Mesh', 'NO', 1, 2, '2020-12-09 06:30:48', NULL, NULL),
(79, NULL, 'Hand Bag', 'YES', 1, 2, '2020-12-13 04:38:19', NULL, NULL),
(80, NULL, 'Jute Rope', 'YES', 1, 2, '2020-12-21 03:39:10', NULL, NULL),
(81, NULL, 'FIBC Bag', 'YES', 1, 2, '2020-12-23 03:36:14', NULL, NULL),
(82, NULL, 'Fabrics', 'NO', 1, 2, '2020-12-25 05:08:02', NULL, NULL),
(83, NULL, 'Raw Jute', 'YES', 1, 2, '2020-12-26 04:38:16', NULL, NULL),
(84, NULL, 'Household Goods', 'YES', 1, 2, '2020-12-28 10:16:59', NULL, NULL),
(85, NULL, 'Outdoor Product', 'YES', 1, 2, '2021-01-01 06:14:36', NULL, NULL),
(86, NULL, 'Synthetic Staple Fiber', 'YES', 1, 2, '2021-01-10 05:51:12', NULL, NULL),
(87, NULL, 'Woven Bulk Bag', 'YES', 1, 2, '2021-01-12 04:05:42', NULL, NULL),
(88, NULL, 'Leather', 'YES', 1, 2, '2021-01-12 04:38:00', NULL, NULL),
(89, NULL, 'Unwrought Aluminium Alloy', 'YES', 1, 2, '2021-01-17 09:17:31', NULL, NULL),
(90, NULL, 'SERGEL INJECTION', 'NO', 1, 2, '2021-01-18 04:27:58', NULL, NULL),
(91, NULL, 'Dry Fish', 'YES', 1, 2, '2021-01-22 04:05:05', NULL, NULL),
(92, NULL, 'SWEING THREAD', 'NO', 1, 2, '2021-01-28 09:17:58', NULL, NULL),
(93, NULL, 'DRIED FISH MAWS & SKIN', 'YES', 1, 2, '2021-02-06 04:33:12', NULL, NULL),
(94, NULL, 'Empty Sylinder', 'YES', 1, 2, '2021-02-08 06:00:12', NULL, NULL),
(95, NULL, 'HANGER', 'NO', 1, 2, '2021-02-26 04:54:11', NULL, NULL),
(96, NULL, 'DRY FISH SCALE', 'YES', 1, 2, '2021-03-14 05:04:18', NULL, NULL),
(97, NULL, 'FOLDING BAG', 'YES', 1, 2, '2021-03-22 05:51:12', NULL, NULL),
(98, NULL, 'PADDING', 'YES', 1, 2, '2021-03-25 04:33:05', NULL, NULL),
(99, NULL, 'ACCESSORIES FOR  EXPORT ORIENTED READY MADE GARMENTS', 'YES', 1, 2, '2021-04-05 05:10:44', NULL, NULL),
(100, NULL, 'Cleaning cloths & mops', 'YES', 1, 2, '2021-04-08 04:10:19', NULL, NULL),
(101, NULL, 'MOTOR CASING, FAN GRILL, COPPER COIL                  ', 'YES', 1, 2, '2021-04-14 05:53:20', NULL, NULL),
(102, NULL, 'COIR PEAT', 'YES', 1, 2, '2021-05-01 04:26:57', NULL, NULL),
(103, NULL, 'ATTENDANCE CHECK ', 'YES', 1, 2, '2021-05-05 06:03:58', '2021-05-05 06:54:57', NULL),
(104, '01', 'Raw Cotton', NULL, 1, 1, NULL, NULL, NULL),
(105, '02', 'Waste Paper', NULL, 1, 1, NULL, NULL, NULL),
(106, '03', 'Scrap', NULL, 1, 1, NULL, NULL, NULL),
(107, '04', 'Rice/ Seeds', NULL, 1, 1, NULL, NULL, NULL),
(108, '05', 'Lentils', NULL, 1, 1, NULL, NULL, NULL),
(109, '06', 'Wheat, Flour', NULL, 1, 1, NULL, NULL, NULL),
(110, '07', 'Mustard Seed', NULL, 1, 1, NULL, NULL, NULL),
(111, '08', 'Sugar', NULL, 1, 1, NULL, NULL, NULL),
(112, '09', 'Peas', NULL, 1, 1, NULL, NULL, NULL),
(113, '10', 'Fresh fruit', NULL, 1, 1, NULL, NULL, NULL),
(114, '11', 'Frozen Fish', NULL, 1, 1, NULL, NULL, NULL),
(115, '12', 'Animal Feed', NULL, 1, 1, NULL, NULL, NULL),
(116, '13', 'Chemicals', NULL, 1, 1, NULL, NULL, NULL),
(117, '14', 'Paper', NULL, 1, 1, NULL, NULL, NULL),
(118, '15', 'Steel/Iron Goods', NULL, 1, 1, NULL, NULL, NULL),
(119, '16', 'Garments', NULL, 1, 1, NULL, NULL, NULL),
(120, '17', 'Machineries', NULL, 1, 1, NULL, NULL, NULL),
(121, '18', 'Food Items', NULL, 1, 1, NULL, NULL, NULL),
(122, '19', 'Polypropylene', NULL, 1, 1, NULL, NULL, NULL),
(123, '20', 'Ingot, Billet', NULL, 1, 1, NULL, NULL, NULL),
(124, '21', 'Fabricated Building Material', NULL, 1, 1, NULL, NULL, NULL),
(125, '22', 'Tiles/ Ceramic', NULL, 1, 1, NULL, NULL, NULL),
(126, '23', 'M.S.Billet', NULL, 1, 1, NULL, NULL, NULL),
(127, '24', 'M Parts/Auxiliaries', NULL, 1, 1, NULL, NULL, NULL),
(128, '25', 'Television', NULL, 1, 1, NULL, NULL, NULL),
(129, '26', 'Marble Chips', NULL, 1, 1, NULL, NULL, NULL),
(130, '27', 'Refregerator, Freezer', NULL, 1, 1, NULL, NULL, NULL),
(131, '28', 'Wood Pulp, Logs', NULL, 1, 1, NULL, NULL, NULL),
(132, '29', 'Bicycle Parts', NULL, 1, 1, NULL, NULL, NULL),
(133, '30', 'Tyre Tube', NULL, 1, 1, NULL, NULL, NULL),
(134, '31', 'Porcelain/Glass Ware', NULL, 1, 1, NULL, NULL, NULL),
(135, '32', 'Generating Set', NULL, 1, 1, NULL, NULL, NULL),
(136, '33', 'Electric, Electronics', NULL, 1, 1, NULL, NULL, NULL),
(137, '34', 'Pumic Stones', NULL, 1, 1, NULL, NULL, NULL),
(138, '35', 'Others', NULL, 1, 1, NULL, NULL, NULL),
(139, '36', 'GINGER', NULL, 1, 1, NULL, NULL, NULL),
(140, '37', 'GARLIC, ONION', NULL, 1, 1, NULL, NULL, NULL),
(141, '38', 'Car/ Vehicle', NULL, 1, 1, NULL, NULL, NULL),
(142, '39', 'P.Tiller, D. Engine', NULL, 1, 1, NULL, NULL, NULL),
(143, '40', 'Computer & accessories', NULL, 1, 1, NULL, NULL, NULL),
(144, '41', 'Milk Powder', NULL, 1, 1, NULL, NULL, NULL),
(145, '42', 'Resin', NULL, 1, 1, NULL, NULL, NULL),
(146, '43', 'OILS', NULL, 1, 1, NULL, NULL, NULL),
(147, '44', 'Sports Goods', NULL, 1, 1, NULL, NULL, NULL),
(148, '45', 'Defence cargo', NULL, 1, 1, NULL, NULL, NULL),
(149, '46', 'Color', NULL, 1, 1, NULL, NULL, NULL),
(150, '47', 'NILL', NULL, 1, 1, NULL, NULL, NULL),
(151, '48', 'Recondition Car', NULL, 1, 1, NULL, NULL, NULL),
(152, '49', 'Auto Car', NULL, 1, 1, NULL, NULL, NULL),
(153, '50', 'Sodium Sulphate', NULL, 1, 1, NULL, NULL, NULL),
(154, '51', 'Pipes & Fittings', NULL, 1, 1, NULL, NULL, NULL),
(155, '52', 'Bopp Matt Film', NULL, 1, 1, NULL, NULL, NULL),
(156, '53', 'Master Batch', NULL, 1, 1, NULL, NULL, NULL),
(157, '54', 'Plaster Of Paris', NULL, 1, 1, NULL, NULL, NULL),
(158, '55', 'Cotton', NULL, 1, 1, NULL, NULL, NULL),
(159, '72', 'scarp', NULL, 1, 1, NULL, NULL, NULL),
(160, '52', 'Raw Cotton', NULL, 1, 1, NULL, NULL, NULL),
(161, '52', 'Raw Cotton', NULL, 1, 1, NULL, NULL, NULL),
(162, '12', 'SEED', NULL, 1, 1, NULL, NULL, NULL),
(163, '7', 'Lentils', NULL, 1, 1, NULL, NULL, NULL),
(164, '07', 'Lentils', NULL, 1, 1, NULL, NULL, NULL),
(165, '03', 'Steel Scrap', NULL, 1, 1, NULL, NULL, NULL),
(166, '03', 'Steel Scrap', NULL, 1, 1, NULL, NULL, NULL),
(167, NULL, 'PAPER BOX', 'YES', 1, 2, '2021-05-11 05:04:11', NULL, NULL),
(168, NULL, 'TEXTILE WASTE', 'YES', 1, 2, '2021-06-01 04:07:00', NULL, NULL),
(169, NULL, 'TOILET & KITCHEN LINEN', 'YES', 1, 2, '2021-06-01 05:56:46', '2021-07-14 05:52:57', NULL),
(170, NULL, 'WHITE HOSIERY CLIPS', 'YES', 1, 2, '2021-06-02 04:48:31', NULL, NULL),
(171, NULL, 'FIBC', 'YES', 1, 2, '2021-06-06 08:41:14', NULL, NULL),
(172, NULL, 'SHIP SCRAP', 'YES', 1, 2, '2021-06-19 04:51:17', NULL, NULL),
(173, NULL, 'CASHEW NUT', 'YES', 1, 2, '2021-06-24 03:55:54', NULL, NULL),
(174, NULL, 'METAL HOOKS', 'YES', 1, 2, '2021-06-25 04:11:02', NULL, NULL),
(175, NULL, 'COTTON OISHIBORY', 'YES', 1, 2, '2021-06-30 05:51:13', NULL, NULL),
(176, NULL, 'RUCKSACK', 'YES', 1, 2, '2021-07-01 10:11:56', NULL, NULL),
(177, NULL, 'SYNTHETIC FASHIONABLE WIGS', 'YES', 1, 2, '2021-07-03 06:01:15', NULL, NULL),
(178, NULL, 'EXHAUST FAN BLADE', 'YES', 1, 2, '2021-07-07 04:47:39', NULL, NULL),
(179, NULL, 'THERMAL PRINTER', 'YES', 1, 2, '2021-07-20 17:11:36', NULL, NULL),
(180, NULL, 'Medical Items', 'YES', 1, 2, '2021-08-09 04:22:56', NULL, NULL),
(181, NULL, 'Training Head', 'YES', 1, 2, '2021-08-17 10:17:22', NULL, NULL),
(182, NULL, 'SHIP SPARE PARTS                        ', 'YES', 1, 2, '2021-08-18 03:49:10', NULL, NULL),
(183, NULL, 'PA6 RECYCLE PELLET', 'YES', 1, 2, '2021-08-26 03:57:22', NULL, NULL),
(184, NULL, 'COTTON YARN', 'YES', 1, 2, '2021-08-29 06:25:54', NULL, NULL),
(185, NULL, 'CUMIN SEED', 'YES', 1, 2, '2021-08-31 04:34:22', NULL, NULL),
(186, NULL, 'PAPER IN ROLLS', 'YES', 1, 2, '2021-09-06 04:00:43', NULL, NULL),
(187, NULL, 'ALUMINIUM ALLOY', 'YES', 1, 2, '2021-09-09 04:07:23', NULL, NULL),
(188, NULL, 'JUTE STICK CHARCOAL', 'YES', 1, 2, '2021-09-10 04:01:42', NULL, NULL),
(189, NULL, 'COW TAIL HAIR ', 'YES', 1, 2, '2021-09-14 03:51:21', NULL, NULL),
(190, NULL, 'FESTIVAL CARNIVAL ', 'YES', 1, 2, '2021-10-06 04:17:18', NULL, NULL),
(191, NULL, 'LUGGAGE & TRAVEL', 'YES', 1, 2, '2021-10-19 09:47:44', NULL, NULL),
(192, NULL, 'JUTE FIBER', 'YES', 1, 2, '2021-10-26 06:54:38', NULL, NULL),
(193, NULL, 'JUTE BAGS', 'YES', 1, 2, '2021-10-27 04:08:16', NULL, NULL),
(194, NULL, 'SHIP BREAKING PLATE', 'YES', 1, 2, '2021-11-02 04:26:38', NULL, NULL),
(195, NULL, 'FOOTWEAR OUTSOLE', 'YES', 1, 2, '2021-11-12 06:03:25', NULL, NULL),
(196, NULL, 'VEHICLE', 'YES', 1, 2, '2021-11-26 05:32:07', NULL, NULL),
(197, NULL, 'NAPKIN HOLDER', 'YES', 1, 2, '2021-11-30 06:21:26', NULL, NULL);

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

--
-- Table structure for table `mlo_container_type_groups`
--

CREATE TABLE `mlo_container_type_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `size` int(11) NOT NULL DEFAULT '0',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `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;

--
-- Dumping data for table `mlo_container_type_groups`
--

INSERT INTO `mlo_container_type_groups` (`id`, `size`, `type`, `details`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 20, 'GP', 'General Purpose', 1, NULL, NULL, NULL),
(2, 20, 'FR', 'Flat Rack', 1, NULL, NULL, NULL),
(3, 20, 'RF', 'Reffer', 1, NULL, NULL, NULL),
(4, 20, 'OT', 'Open Top', 1, NULL, NULL, NULL),
(5, 20, 'TK', 'Tank', 1, NULL, NULL, NULL),
(6, 40, 'GP', 'General Purpose', 1, NULL, NULL, NULL),
(7, 40, 'FR', 'Flat Rack', 1, NULL, NULL, NULL),
(8, 40, 'RF', 'Reffer', 1, NULL, NULL, NULL),
(9, 40, 'OT', 'Open Top', 1, NULL, NULL, NULL),
(10, 40, 'TK', 'Tank', 1, NULL, NULL, NULL),
(11, 40, 'HC', 'High Cube', 1, NULL, NULL, NULL),
(12, 40, 'HR', 'High Cube Reffer', 1, NULL, NULL, NULL),
(13, 45, 'HC', 'High Cube', 1, NULL, NULL, NULL);

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

--
-- Table structure for table `mlo_ctr_code_ci`
--

CREATE TABLE `mlo_ctr_code_ci` (
  `id` int(2) NOT NULL,
  `code` varchar(5) NOT NULL,
  `size` int(2) NOT NULL,
  `height` varchar(4) NOT NULL,
  `name` varchar(4) NOT NULL,
  `type` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mlo_ctr_code_ci`
--

INSERT INTO `mlo_ctr_code_ci` (`id`, `code`, `size`, `height`, `name`, `type`) VALUES
(1, '22G1', 20, '8.6', 'GP', 'DRY'),
(2, '45G1', 40, '9.6', 'HC', 'DRY'),
(3, '22R1', 20, '', 'RF', 'REEFER'),
(4, '45R1', 40, '', 'RH', 'REEFER'),
(5, '42G1', 40, '', 'GP', 'DRY'),
(6, '42U1', 40, '', 'OT', 'OPEN TOP'),
(7, '42P1', 40, '', 'FR', 'FLAT RACK'),
(8, '42P3', 40, '', 'FR', 'FLAT RACK'),
(9, '22U1', 20, '', 'OT', 'OPEN TOP'),
(10, '22P3', 20, '', 'FR', 'FLAT RACK'),
(11, '22P1', 20, '', 'FR', 'FLAT RACK'),
(12, '22T1', 20, '', 'TK', 'TANK'),
(13, '45P1', 40, '', 'FR', 'FLAT RACK'),
(14, '22T6', 20, '', 'TK', 'TANK'),
(15, '42T1', 40, '', 'TK', 'TANK'),
(16, '42T6', 40, '', 'TK', 'TANK'),
(17, '42R1', 40, '', 'RH', 'REEFER'),
(18, '42P4', 40, '', 'FR', 'FLAT RACK'),
(19, '22T3', 20, '', 'TK', 'TANK'),
(20, 'L5G1', 45, '', 'HC', 'HIGH QUBE'),
(21, '45U1', 40, '', 'OT', 'OPEN TOP'),
(22, '45T6', 40, '', 'TK', 'TANK'),
(23, '45T1', 40, '', 'TK', 'TANK');

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

--
-- Table structure for table `mlo_customers`
--

CREATE TABLE `mlo_customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ain` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bin` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pic_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `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 `mlo_customers`
--

INSERT INTO `mlo_customers` (`id`, `name`, `address`, `email`, `phone`, `ain`, `bin`, `password`, `pic_name`, `warehouse_id`, `created_at`, `updated_at`) VALUES
(1, 'Sudipto Kumar Shil', 'Chittagong,Bangladesh.', 'sudipto@gmail.com', '01624772008', '1234', '5678', '$2y$10$3kG.pWV04Tq3jew3PeKiwOYR7aSNhtoqcvenmhpWce.RkaL.8cdaG', 'St123', 7, '2021-11-28 00:59:54', '2021-11-29 01:25:51'),
(2, 'Hasan mahmood nayem', 'Dhaka', 'hasan@gmail.com', '00098765', '87654', '0986', '$2y$10$fZt6wh8UlFo5AqymQIsQ.eW/wQ6nvBbtyFCFRztXGSZRMHhxrMdf2', 'Name 234', 0, '2021-11-28 01:45:20', '2021-11-29 03:43:33'),
(3, 'Jhon Doe', 'Usa', 'jhondoe@gmail.com', '+8801624772008', '2345', '2345', '$2y$10$TmYk5gCRau3PTc5ihRJ5KuEaOi4Q80pHIPU/UlLe.TQm23Rjab7Fq', 'jhon_doe', 1, '2021-12-02 06:02:03', '2021-12-04 05:05:15');

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

--
-- Table structure for table `mlo_eq_depots`
--

CREATE TABLE `mlo_eq_depots` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` tinyint(4) DEFAULT '0',
  `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 `mlo_eq_depots`
--

INSERT INTO `mlo_eq_depots` (`id`, `code`, `name`, `details`, `location`, `created_at`, `updated_at`) VALUES
(1, 'CGP01', 'PORT', 'Something', 1, NULL, NULL),
(2, 'CGP21', 'EBL', 'Something', 2, NULL, NULL),
(3, 'CGP22', 'OCL', '', 2, NULL, NULL),
(4, 'CGP34', 'SML', '', 2, NULL, NULL),
(5, 'CGP29', 'VERTEX', '', 2, NULL, NULL),
(6, 'CGP27', 'INCL', '', 2, NULL, NULL),
(7, 'CGP25', 'KDS', '', 2, NULL, NULL),
(8, 'CGP31', 'CCTCL', '', 2, NULL, NULL),
(9, 'CGP26', 'BMCDL', '', 2, NULL, NULL),
(10, 'CGP23', 'SAPL', '', 2, NULL, NULL),
(11, 'CGP22', 'K&T', '', 2, NULL, NULL),
(12, 'CGP30', 'QNS', '', 2, NULL, NULL),
(13, 'CGP36', 'PLLCL', 'PORTLINK', 2, NULL, NULL),
(14, 'CGP51', 'NCL', '', 2, NULL, NULL),
(15, 'CGP02', 'DHK/ICD', '', 2, NULL, NULL),
(16, 'CGP24', 'GCL', '', 2, NULL, NULL),
(17, 'CGP33', 'CONSIGNEE', '', 3, NULL, NULL),
(18, 'CGP32', 'CEPZ', '', 4, NULL, NULL),
(19, 'CGP32', 'KEPZ', '', 4, NULL, NULL),
(20, '5321', 'COEPZ', '', 2, NULL, NULL),
(21, 'CGP28', 'ELL', 'EASTERN LOGISTICS LIMITED', 2, NULL, NULL),
(22, 'CGP35', 'HSAT', 'HAZI SABER AHMED CO. LTD', 2, NULL, NULL),
(23, 'CGP04', 'ISATL', '', 2, NULL, NULL),
(24, 'RWGON', 'R WAGON', '', 4, NULL, NULL),
(25, 'CGP33', 'SHIPPER', '', 4, NULL, NULL),
(26, '', 'DI/offire', '', 4, NULL, NULL),
(27, 'VSL', 'VESSEL', '', 4, NULL, NULL),
(28, 'BGPGN', 'PANGAON/ICT', '', 2, NULL, NULL),
(29, 'DGP32', 'DEPZ', '', 2, NULL, NULL);

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

--
-- Table structure for table `mlo_eq_port_lists`
--

CREATE TABLE `mlo_eq_port_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `port_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `user_id` tinyint(4) DEFAULT '0',
  `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 `mlo_eq_port_lists`
--

INSERT INTO `mlo_eq_port_lists` (`id`, `name`, `port_name`, `status`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'SGSIN', 'Singapore', 1, 0, NULL, NULL),
(2, 'MYPKG', 'Port Kelang', 1, 0, NULL, NULL),
(3, 'MYBTU', 'Bintulu', 1, 0, NULL, NULL),
(4, 'LKCMB', 'Colombo', 1, 0, NULL, NULL),
(5, 'THLCH', 'Laem Chabang', 1, 0, NULL, NULL),
(6, 'AEJEA', 'Jebel Ali', 1, 0, NULL, NULL),
(7, 'IRBND', 'Bandar Abbas', 1, 0, NULL, NULL),
(8, 'SOMGQ', 'Mogadishu', 1, 0, NULL, NULL),
(9, 'SADMM', 'Dammam', 1, 0, NULL, NULL),
(10, 'SOBBO', 'Berbera', 1, 0, NULL, NULL),
(11, 'KRPUS', 'Busan (ex Pusan)', 1, 0, NULL, NULL),
(12, 'PKKHI', 'Karachi', 1, 0, NULL, NULL),
(13, 'INCCU', 'Kolkata', 1, 0, NULL, NULL),
(14, 'INMUN', 'Mundra', 1, 0, NULL, NULL),
(15, 'MMRGN', 'Yangon', 1, 0, NULL, NULL),
(16, 'AESHJ', 'Sharjah', 1, 0, NULL, NULL),
(17, 'PHMNN', 'Manila North Harbour', 1, 0, NULL, NULL),
(18, 'JPHKT', 'Hakata/Fukuoka', 1, 0, NULL, NULL),
(19, 'JPNGO', 'Nagoya, Aichi', 1, 0, NULL, NULL),
(20, 'JPTAK', 'Takamatsu', 1, 0, NULL, NULL),
(21, 'JPMOJ', 'Moji/Kitakyushu', 1, 0, NULL, NULL),
(22, 'JPFKY', 'Fukuyama', 1, 0, NULL, NULL),
(23, 'JPTMK', 'Tomakomai', 1, 0, NULL, NULL),
(24, 'KRKAN', 'Kwangyang', 0, 0, NULL, NULL),
(25, 'KRINC', 'Inchon', 1, 0, NULL, NULL),
(26, 'RUVST', 'Vladivostok', 1, 0, NULL, NULL),
(27, 'CNSHA', 'Shanghai', 1, 0, NULL, NULL),
(28, 'JPMIZ', 'Mizushima', 1, 0, NULL, NULL),
(29, 'MYPEN', 'Penang (Georgetown)', 1, 0, NULL, NULL),
(30, 'JPKNZ', 'Kanazawa', 1, 0, NULL, NULL),
(31, 'MYTPP', 'Tanjong Pelepas', 1, 0, NULL, NULL),
(32, 'JPKBU', 'Kubuki', 1, 0, NULL, NULL),
(33, 'JPOSA', 'Osaka', 1, 0, NULL, NULL),
(34, 'MYPGU', 'Pasir Gudang, Johor', 1, 0, NULL, NULL),
(35, 'JPSEN', 'Satsumasendai', 1, 0, NULL, NULL),
(36, 'JPSDJ', 'Sendai', 0, 0, NULL, NULL),
(37, 'JPHIR', 'Hiroo', 1, 0, NULL, NULL),
(38, 'KUSWK', 'Shuwaikh', 1, 0, NULL, NULL),
(39, 'JPTKS', 'Tokushima', 1, 0, NULL, NULL),
(40, 'JPISI', 'Ishikari', 1, 0, NULL, NULL),
(41, 'JPISS', 'Isa', 1, 0, NULL, NULL),
(42, 'JPNGO', 'Nagoya, Aichi', 0, 0, NULL, NULL),
(43, 'JPYAT', 'Yatsushiro', 1, 0, NULL, NULL),
(44, 'BHBAH', 'Bahrain', 1, 0, NULL, NULL),
(45, 'JPYOK', 'Yokohama', 1, 0, NULL, NULL),
(46, 'JPKIJ', 'Niigata', 1, 0, NULL, NULL),
(47, 'JPTYO', 'Tokyo', 1, 0, NULL, NULL),
(48, 'JPUKB', 'Kobe', 1, 0, NULL, NULL),
(49, 'CNNGB', 'Ningbo', 1, 0, NULL, NULL),
(50, 'JPHHE', 'Hachinohe', 1, 0, NULL, NULL),
(51, 'KRKPO', 'Pohang', 1, 0, NULL, NULL),
(52, 'CNCSX', 'Changsha', 1, 0, NULL, NULL),
(53, 'KRSEL', 'Seoul', 1, 0, NULL, NULL),
(54, 'CNDLC', 'Dalian', 1, 0, NULL, NULL),
(55, 'IDTPP', 'Tanjung Priok', 1, 0, NULL, NULL),
(56, 'IDJKT', 'Jakarta, Java', 1, 0, NULL, NULL),
(57, 'MYWSP', 'Port Kelang (West)', 1, 0, NULL, NULL),
(58, 'VNSGN', 'Hochiminh', 1, 0, NULL, NULL),
(59, 'JPOIT', 'Oita', 1, 0, NULL, NULL),
(60, 'THBKK', 'Bangkok', 1, 0, NULL, NULL),
(61, 'CNSHK', 'Shekou', 1, 0, NULL, NULL),
(62, 'VNHPH', 'HAIPHONG', 1, 0, NULL, NULL),
(63, 'KHSHV', 'Sihanoukville', 1, 0, NULL, NULL),
(64, 'HKHKG', 'Hong Kong', 1, 0, NULL, NULL),
(65, 'TWTPE', 'Taipei', 1, 0, NULL, NULL),
(66, 'TWKEL', 'Keelung', 1, 0, NULL, NULL),
(67, 'KRPTK', 'Pyeongtaek', 1, 0, NULL, NULL),
(68, 'CNZJG', 'Zhangjiagang', 1, 0, NULL, NULL),
(69, 'CNJXN', 'JIAOXIN', 1, 0, NULL, NULL),
(70, 'INMAA', 'Chennai', 1, 0, NULL, NULL),
(71, 'TWKHH', 'KAOHSIUNG', 1, 0, NULL, NULL),
(72, 'TWTXG', 'Taichung', 1, 0, NULL, NULL),
(73, 'CNXMN', 'Xiamen', 1, 0, NULL, NULL),
(74, 'CNTAO', 'Qingdao', 1, 0, NULL, NULL),
(75, 'INNSA', 'Nhava Sheva', 1, 0, NULL, NULL),
(76, 'KRKAN', 'GWANGYANG (Kwangyang)', 1, 0, NULL, NULL),
(77, 'CNTXG', 'TIANJIN', 1, 0, NULL, NULL),
(78, 'CNZHA', 'ZHANJIANG', 1, 0, NULL, NULL),
(79, 'CNNTG', 'NANTONG', 1, 0, NULL, NULL),
(80, 'CNWUH', 'WUHAN', 1, 0, NULL, NULL),
(81, 'JPMYJ', 'Matstuyama', 1, 0, NULL, NULL),
(82, 'JPSDJ', 'Sendai', 1, 0, NULL, NULL),
(83, 'JPSMZ', 'Shimizu', 1, 0, NULL, NULL),
(84, 'CNQZH', 'Qinzhou', 1, 0, NULL, NULL),
(85, 'THLKB', 'Lat karabang', 1, 0, NULL, NULL),
(86, 'CNCAN', 'GUANGZHOU', 1, 0, NULL, NULL),
(87, 'CNZSH', 'HUANGPU', 1, 0, NULL, NULL),
(88, 'CNHUA', 'HUANGPU', 1, 0, NULL, NULL),
(89, 'JPUKB', 'KOBE', 0, 0, NULL, NULL),
(90, 'IDSUB', 'SURABAYA', 1, 0, NULL, NULL),
(91, 'CNJIA', 'JIANGYIN', 1, 0, NULL, NULL),
(92, 'CNNSA', 'NANSHA', 1, 0, NULL, NULL),
(93, 'CNWNZ', 'WENZHOU', 1, 0, NULL, NULL),
(94, 'CNSSN', 'SANSHAN', 1, 0, NULL, NULL),
(95, 'CNGAS', 'GAOSHA', 1, 0, NULL, NULL),
(97, 'CNSDG', 'SHUIDONG', 1, 0, NULL, NULL),
(98, 'CNZSN', 'ZHONGSHAN', 1, 0, NULL, NULL),
(99, 'OMSOH', 'Shohar', 1, 0, NULL, NULL),
(100, 'CNYTN', 'YANTIAN', 1, 0, NULL, NULL),
(101, 'JPSBK', 'SAKAISENBOKU', 1, 0, NULL, NULL),
(102, 'CNLIH', 'LIANHUASHAN', 1, 0, NULL, NULL),
(103, 'RUVYP', 'VOSTOCHNYY', 1, 0, NULL, NULL),
(104, 'PHCEB', 'CEBU', 1, 0, NULL, NULL),
(105, 'PHDVO', 'DAVAO', 1, 0, NULL, NULL),
(106, 'CNSTN', 'SHATIAN', 1, 0, NULL, NULL),
(107, 'PHBTG', 'BATANGAS', 1, 0, NULL, NULL),
(108, 'CNHMN', 'HUMEN', 1, 0, NULL, NULL),
(109, 'CNHAK', 'HAIKOU', 1, 0, NULL, NULL),
(110, 'CNQYN', 'QINGYUAN', 1, 0, NULL, NULL),
(111, 'MYPKL', 'Port Kelang', 1, 0, NULL, NULL),
(112, 'CNHUD', 'HUA DU', 1, 0, NULL, NULL);

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

--
-- Table structure for table `mlo_msns`
--

CREATE TABLE `mlo_msns` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `pic_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `com_code` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usci` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` 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 `mlo_packages`
--

CREATE TABLE `mlo_packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `mlo_preshipment_advice`
--

CREATE TABLE `mlo_preshipment_advice` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shipping_order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `mlo_booking_advice_id` bigint(20) UNSIGNED DEFAULT NULL,
  `project_vessel_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'protected moth vessel',
  `bl_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'BILL OF LADING (B/L) No.',
  `etd_pod` datetime DEFAULT NULL COMMENT 'ETD POD/ETA FPOD',
  `etd_pol` datetime DEFAULT NULL COMMENT 'ETD POL(CODE & NAME)/ ETA POD(CODE & NAME)',
  `ts` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Trans Shipment. yes =1',
  `quantity_of_package` int(11) NOT NULL DEFAULT '0',
  `cbm` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vgm` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `last_updated_type` tinyint(1) DEFAULT NULL COMMENT '1 =admin, 2 = customer',
  `approved_by` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL COMMENT 'approve =1 ,pending = 2',
  `deleted_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 `mlo_scns`
--

CREATE TABLE `mlo_scns` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `pic_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `com_code` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usci` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mlo_customer_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` 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 `mlo_scns`
--

INSERT INTO `mlo_scns` (`id`, `name`, `address`, `pic_name`, `com_code`, `usci`, `contact`, `email`, `ain`, `bin`, `mlo_customer_id`, `type`, `created_at`, `updated_at`) VALUES
(1, 'Test Consignees', 'Chittagong,Gec,Bangladesh...', '098765', '098765', '1234567', '01624772008', 'sudiptoshil@gmail.com', '2345', '2345', 1, 'consignee', '2021-11-28 05:12:51', '2021-12-02 00:29:23'),
(2, 'Hello Shipper', 'Ctg...', '098765', '678990', '098765', '0987654', 'Test@gmail.com', '45645', '098765', 1, 'shippers', '2021-11-28 05:23:54', '2021-11-29 04:10:10'),
(3, 'Test 123', 'Dhaka..', 'Alu', '09876', '6789', '01776543', 'abc@gmail.com', '0987', '5678', 1, 'shippers', '2021-11-28 05:26:23', '2021-11-29 04:10:21'),
(4, 'Test Notify', 'CTG', 'fdgdfg', '09876', '1234', '09876', 'admin@gmail.com', '6789', '98765', 1, 'notify', '2021-11-28 05:28:10', '2021-11-29 04:10:46'),
(5, 'Ano Consignee', 'Chittagong Bangladesh.', '09876', '678888', '55675', '0011133333', 'sudipto@gmail.com', '345678', '2345', 1, 'consignee', '2021-11-28 23:27:29', '2021-11-28 23:28:07'),
(6, 'ANo Test Shipper', 'ctg', '1234', '23456', '12345', '45678', 'jakanaka@gmail.com', '123456', '23456', 1, 'shippers', '2021-11-29 04:13:38', '2021-11-29 04:13:38'),
(7, 'Sayem Barakat 123', 'Sayem Barakat 123', 'Sayem Barakat', 'Sayem Barakat', 'Sayem Barakat', 'Sayem Barakat', 'jun@gmail.com', 'Sayem Barakat', 'Sayem Barakat', 1, 'shippers', '2021-12-02 00:26:42', '2021-12-02 00:29:08'),
(8, 'The Name', 'Ctg', 'Ctg', 'Ctg', 'Ctg', 'Ctg', 'ctg@gmail.com', 'ctg', 'ctg', 3, 'shippers', '2021-12-02 06:03:54', '2021-12-02 06:03:54');

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

--
-- Table structure for table `mlo_shipping_orders`
--

CREATE TABLE `mlo_shipping_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sl_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mlo_booking_advice_id` bigint(20) UNSIGNED DEFAULT NULL,
  `posting_date` datetime DEFAULT NULL,
  `vessel_id` bigint(20) UNSIGNED DEFAULT NULL,
  `voyage_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exp_reg_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `buyer` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'buyer/notifyparty',
  `forwarder` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `last_updated_type` tinyint(1) DEFAULT NULL COMMENT '1 =admin, 2 = customer',
  `approved_by` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL COMMENT 'approve =1 ,pending = 2',
  `deleted_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;

--
-- Dumping data for table `mlo_shipping_orders`
--

INSERT INTO `mlo_shipping_orders` (`id`, `sl_no`, `mlo_booking_advice_id`, `posting_date`, `vessel_id`, `voyage_no`, `exp_reg_no`, `buyer`, `forwarder`, `phone`, `date`, `warehouse_id`, `created_by`, `updated_by`, `last_updated_type`, `approved_by`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, NULL, 1, '2021-12-08 07:33:20', 5, 'Jalal Enterprise', '#@20098', NULL, 'jasim', '00199992222', '2021-12-08 13:33:00', 7, 1, NULL, NULL, 1, 1, NULL, '2021-12-08 01:33:20', '2021-12-08 01:38:54'),
(2, NULL, 3, '2021-12-08 12:24:16', 1, 'hHHH34355', 'JJH445666', NULL, 'jasim', '01624772008', '2021-12-07 16:00:00', 7, 1, NULL, NULL, 1, 1, NULL, '2021-12-08 06:24:16', '2021-12-08 06:25:09');

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

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `updated_by` 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 `modules`
--

INSERT INTO `modules` (`id`, `name`, `parent_id`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Setting', NULL, 1, 1, NULL, NULL, NULL),
(2, 'Purchase', NULL, 1, 1, NULL, NULL, NULL),
(3, 'Inventory', NULL, 1, 1, NULL, NULL, NULL),
(4, 'Production', NULL, 1, 1, NULL, NULL, NULL),
(5, 'Accounts', NULL, 1, 1, NULL, NULL, NULL),
(6, 'Showroom', NULL, 1, 1, NULL, NULL, NULL),
(101, 'Booking', NULL, 1, 1, NULL, NULL, NULL);

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

--
-- Table structure for table `module_role`
--

CREATE TABLE `module_role` (
  `module_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED 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 `module_wise_tables`
--

CREATE TABLE `module_wise_tables` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `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 `module_wise_tables`
--

INSERT INTO `module_wise_tables` (`id`, `table_name`, `module_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 'accounts_heads', 1, 1, NULL, NULL),
(2, 'admin_accounthead', 1, 1, NULL, NULL),
(3, 'invoice_types', 1, 1, NULL, NULL),
(4, 'invoice_parameters', 1, 1, NULL, NULL),
(5, 'types', 1, 1, NULL, NULL),
(6, 'settings', 1, 1, NULL, NULL),
(7, 'groups', 1, 1, NULL, NULL),
(8, 'vendors', 1, 1, NULL, NULL),
(9, 'product_settings', 1, 1, NULL, NULL),
(10, 'color_sizes', 1, 1, NULL, NULL),
(11, 'customers', 1, 1, NULL, NULL),
(12, 'product_categories', 1, 1, NULL, NULL),
(13, 'brands', 1, 1, NULL, NULL),
(14, 'products', 1, 1, NULL, NULL),
(15, 'card_grades', 1, 1, NULL, NULL),
(16, 'card_members', 1, 1, NULL, NULL),
(17, 'cash_banks', 1, 1, NULL, NULL),
(18, 'initial_accounts_set_ups', 1, 1, NULL, NULL),
(19, 'carts', 1, 1, NULL, NULL),
(20, 'product_serial_carts', 1, 1, NULL, NULL),
(21, 'vouchers', 1, 1, NULL, NULL),
(22, 'manage_checkbooks', 1, 1, NULL, NULL),
(23, 'journal_transactions', 1, 1, NULL, NULL),
(24, 'cost_centers', 1, 1, NULL, NULL),
(25, 'store_invoices', 1, 1, NULL, NULL),
(26, 'store_transactions', 1, 1, NULL, NULL),
(27, 'store_serial_carts', 1, 1, NULL, NULL),
(28, 'store_product_promotions', 1, 1, NULL, NULL),
(29, 'cheque_details', 1, 1, NULL, NULL),
(30, 'invoice_transportations', 1, 1, NULL, NULL),
(31, 'recipes', 1, 1, NULL, NULL),
(32, 'reciperawproducts', 1, 1, NULL, NULL),
(33, 'indents', 1, 1, NULL, NULL),
(34, 'indentdetails', 1, 1, NULL, NULL),
(35, 'fgstore_invoices', 1, 1, NULL, NULL),
(36, 'fgstore_transactions', 1, 1, NULL, NULL),
(37, 'order_carts', 1, 1, NULL, NULL),
(38, 'requisitions', 1, 1, NULL, NULL),
(39, 'requisition_details', 1, 1, NULL, NULL),
(40, 'quotations', 1, 1, NULL, NULL),
(41, 'quotation_details', 1, 1, NULL, NULL),
(42, 'actions', 1, 1, NULL, NULL),
(43, 'steps', 1, 1, NULL, NULL),
(44, 'action_step', 1, 1, NULL, NULL),
(45, 'role_mappings', 1, 1, NULL, NULL),
(46, 'costcenter_mappings', 1, 1, NULL, NULL),
(47, 'approvals', 1, 1, NULL, NULL),
(48, 'stock_ledgers', 1, 1, NULL, NULL),
(49, 'party_wise_product_prices', 1, 1, NULL, NULL),
(50, 'currencies', 1, 1, NULL, NULL),
(51, 'order_invoices', 1, 1, NULL, NULL),
(52, 'product_groups', 1, 1, NULL, NULL),
(53, 'purchase_orders', 1, 1, NULL, NULL),
(54, 'po_details', 1, 1, NULL, NULL),
(55, 'cake_orders', 1, 1, NULL, NULL),
(56, 'cake_order_details', 1, 1, NULL, NULL),
(57, 'cake_carts', 1, 1, NULL, NULL),
(58, 'units', 1, 1, NULL, NULL),
(59, 'step_settings', 1, 1, NULL, NULL),
(60, 'quick_accesses', 1, 1, NULL, NULL),
(61, 'admin_costcenter', 1, 1, NULL, NULL);

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

--
-- Table structure for table `package_code`
--

CREATE TABLE `package_code` (
  `code` varchar(3) DEFAULT NULL,
  `description` varchar(58) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `package_code`
--

INSERT INTO `package_code` (`code`, `description`) VALUES
('1A', 'Drum, steel '),
('1B', 'Drum, aluminium '),
('1D', 'Drum, plywood '),
('1G', 'Drum, fibre '),
('1W', 'Drum, wooden '),
('2C', 'Barrel, wooden '),
('3A', 'Jerrican, steel '),
('3H', 'Jerrican, plastic '),
('4A', 'Box, steel '),
('4B', 'Box, aluminium '),
('4C', 'Box, natural wood '),
('4D', 'Box, plywood '),
('4F', 'Box, reconstituted wood '),
('4G', 'Box, fibreboard '),
('4H', 'Box, plastic '),
('5H', 'Bag, woven plastic '),
('5L', 'Bag, textile'),
('5M', 'Bag, paper'),
('6H', 'Comp. pkg, plastic recept. '),
('6P', 'Comp. pkg, glass recept. '),
('AA', 'Int. bulk cont., rigid plastic '),
('AB', 'recept., fibre '),
('AC', 'recept., paper '),
('AD', 'recept., wooden '),
('AE', 'Aerosol'),
('AF', 'Pallet, modular, collars 80cms * 60cms '),
('AG', 'Pallet, shrinkwrapped'),
('AH', 'Pallet, 100cms * 110cms '),
('AI', 'Clamshell '),
('AJ', 'Cone'),
('AM', 'Ampoule, non-protected '),
('AP', 'Ampoule, protected '),
('AT', 'Atomizer'),
('AV', 'Capsule '),
('BA', 'Barrel '),
('BB', 'Bobbin '),
('BC', 'Bottlecrate / bottlerack '),
('BD', 'Board '),
('BE', 'Bundle '),
('BF', 'Balloon, non-protected '),
('BG', 'Bag '),
('BH', 'Bunch '),
('BI', 'Bin '),
('BJ', 'Bucket '),
('BK', 'Basket '),
('BL', 'Bale, compressed '),
('BM', 'Basin '),
('BN', 'Bale, non-compressed '),
('BO', 'Bottle, non-protected, cylindrical '),
('BP', 'Balloon, protected '),
('BQ', 'Bottle, protected cylindrical '),
('BR', 'Bar '),
('BS', 'Bottle, non-protected, bulbous '),
('BT', 'Bolt '),
('BU', 'Butt '),
('BV', 'Bottle, protected bulbous '),
('BW', 'Box, for liquids'),
('BX', 'Box '),
('BY', 'Board, in bundle/bunch/truss '),
('BZ', 'Bars, in bundle/bunch/truss '),
('CA', 'Can, rectangular '),
('CB', 'Crate, beer '),
('CC', 'Churn '),
('CD', 'Can, with handle and spout '),
('CE', 'Creel '),
('CF', 'Coffer '),
('CG', 'Cage '),
('CH', 'Chest '),
('CI', 'Canister '),
('CJ', 'Coffin'),
('CK', 'Cask '),
('CL', 'Coil '),
('CM', 'Card '),
('CN', 'cont., not otherwise specified '),
('CO', 'Carboy, non-protected '),
('CP', 'Carboy, protected '),
('CQ', 'Cartridge'),
('CR', 'Crate'),
('CS', 'Case'),
('CT', 'Carton '),
('CU', 'Cup '),
('CV', 'Cover'),
('CW', 'Cage, roll'),
('CX', 'Can, cylindrical '),
('CY', 'Cylinder '),
('CZ', 'Canvas '),
('DA', 'Crate, multiple layer, plastic '),
('DB', 'Crate, multiple layer, wooden '),
('DC', 'Crate, multiple layer, cardboard '),
('DG', 'Cage, Commonwealth Handling Equipment Pool (CHEP) '),
('DI', 'Drum, iron '),
('DJ', 'Demijohn, non-protected '),
('DK', 'Crate, bulk, cardboard '),
('DL', 'Crate, bulk, plastic '),
('DM', 'Crate, bulk, wooden '),
('DN', 'Dispenser'),
('DP', 'Demijohn, protected '),
('DR', 'Drum '),
('DS', 'Tray, one layer no cover, plastic '),
('DT', 'Tray, one layer no cover, wooden '),
('DU', 'Tray, one layer no cover, polystyrene'),
('DV', 'Tray, one layer no cover, cardboard '),
('DW', 'Tray, two layers no cover, plastic tray '),
('DX', 'Tray, two layers no cover, wooden '),
('DY', 'Tray, two layers no cover, cardboard '),
('EC', 'Bag, plastic'),
('ED', 'Case, with pallet base '),
('EE', 'Case, with pallet base, wooden '),
('EF', 'Case, with pallet base, cardboard '),
('EG', 'Case, with pallet base, plastic '),
('EH', 'Case, with pallet base, metal '),
('EI', 'Case, isothermic '),
('EN', 'Envelope '),
('FC', 'Crate, fruit '),
('FD', 'Crate, framed '),
('FI', 'Firkin '),
('FL', 'Flask '),
('FO', 'Footlocker '),
('FP', 'Filmpack '),
('FR', 'Frame '),
('FT', 'Foodtainer '),
('FX', 'Bag, flexible cont.'),
('GB', 'Bottle, gas '),
('GI', 'Girder '),
('GR', 'recept., glass '),
('GZ', 'Girders, in bundle/bunch/truss '),
('HA ', 'Basket, with handle, plastic '),
('HB', 'Basket, with handle, wooden '),
('HC', 'Basket, with handle, cardboard '),
('HG', 'Hogshead '),
('HR', 'Hamper '),
('IA', 'Package, display, wooden '),
('IB', 'Package, display, cardboard '),
('IC', 'Package, display, plastic '),
('ID', 'Package, display, metal '),
('IE', 'Package, show '),
('IF', 'Package, flow '),
('IG', 'Package, paper wrapped '),
('IH', 'Drum, plastic '),
('IK', 'Package, cardboard, with bottle grip-holes '),
('IN', 'Ingot '),
('IZ', 'Ingots, in bundle/bunch/truss '),
('JC', 'Jerrican, rectangular '),
('JG', 'Jug '),
('JR', 'Jar '),
('JT', 'Jutebag '),
('JY', 'Jerrican, cylindrical '),
('KG', 'Keg '),
('LG', 'Log '),
('LT', 'Lot '),
('LV', 'Liftvan '),
('LZ', 'Logs, in bundle/bunch/truss '),
('MB', 'Bag, multiply'),
('MC', 'Crate, milk'),
('MR', 'recept., metal '),
('MS', 'Sack, multi-wall'),
('MT', 'Mat '),
('MW', 'recept., plastic wrapped'),
('MX', 'Matchbox '),
('NA', 'Not available'),
('NE', 'Unpacked or unpackaged '),
('NF', 'Unpacked or unpackaged, single unit '),
('NG', 'Unpacked or unpackaged, multiple units '),
('NS', 'Nest'),
('NT', 'Net'),
('NU', 'Net, tube, plastic'),
('NV', 'Net, tube, textile '),
('PA', 'Packet '),
('PB', 'Pallet, box '),
('PC', 'Parcel '),
('PD', 'Pallet, modular, collars 80cms * 100cms'),
('PE', 'Pallet, modular, collars 80cms * 120cms '),
('PF', 'Pen'),
('PG', 'Plate '),
('PH', 'Pitcher '),
('PI', 'Pipe'),
('PJ', 'Punnet'),
('PK', 'Package '),
('PL', 'Pail '),
('PN', 'Plank '),
('PO', 'Pouch '),
('PR', 'recept., plastic '),
('PT', 'Pot '),
('PU', 'Tray '),
('PV', 'Pipes, in bundle/bunch/truss '),
('PX', 'Pallet '),
('PY', 'Plates, in bundle/bunch/truss '),
('PZ', 'Planks, in bundle/bunch/truss '),
('QA', 'Drum, steel, non-removable head '),
('QB', 'Drum, steel, removable head '),
('QC', 'Drum, aluminium, non-removable head '),
('QD', 'Drum, aluminium, removable head '),
('QF', 'Drum, plastic, non-removable head '),
('QG', 'Drum, plastic, removable head '),
('QH', 'Barrel, wooden, bung type '),
('QJ', 'Barrel, wooden, removable head '),
('QK', 'Jerrican, steel, non-removable head '),
('QL', 'Jerrican, steel, removable head '),
('QM', 'Jerrican, plastic, non-removable head '),
('QN', 'Jerrican, plastic, removable head '),
('QP', 'Box, wooden, natural wood, ordinary '),
('QQ', 'Box, wooden, natural wood, with sift proof walls '),
('QR', 'Box, plastic, expanded '),
('QS', 'Box, plastic, solid '),
('RD', 'Rod'),
('RG', 'Ring '),
('RJ', 'Rack, clothing hanger'),
('RK', 'Rack'),
('RL', 'Reel '),
('RO', 'Roll '),
('RT', 'Rednet '),
('RZ', 'Rods, in bundle/bunch/truss '),
('SA', 'Sack '),
('SB', 'Slab'),
('SC', 'Crate, shallow '),
('SD', 'Spindle '),
('SE', 'Sea-chest '),
('SH', 'Sachet '),
('SI', 'Skid '),
('SK', 'Case, skeleton '),
('SL', 'Slipsheet '),
('SM', 'Sheetmetal '),
('SO', 'Spool'),
('SP', 'Sheet, plastic wrapping '),
('SS', 'Case, steel '),
('ST', 'Sheet '),
('SU', 'Suitcase '),
('SV', 'Envelope, steel '),
('SW', 'Shrinkwrapped '),
('SX', 'X Set '),
('SY', 'Sleeve'),
('SZ', 'Sheets, in bundle/bunch/truss '),
('TB', 'Tub '),
('TC', 'Tea-chest '),
('TD', 'Tube, collapsible '),
('TI', 'Tierce '),
('TK', 'Tank, rectangular '),
('TL', 'Tub, with lid '),
('TN', 'Tin '),
('TO ', 'Tun '),
('TR', 'Trunk '),
('TS', 'Truss '),
('TU', 'Tube '),
('TV', 'Tube, with nozzle '),
('TY', 'Tank, cylindrical '),
('TZ', 'Tubes, in bundle/bunch/truss '),
('UC', 'Uncaged '),
('VA', 'Vat '),
('VG', 'Bulk, gas (at 1031 mbar and 15'),
('VI', 'Vial '),
('VK', 'Vanpack '),
('VL', 'Bulk, liquid '),
('VO', 'Bulk, solid, large particles ('),
('VP', 'Vacuum-packed '),
('VQ', 'Bulk, liquefied gas (at abnormal temperature/pressure) '),
('VR', 'Bulk, solid, granular particles ('),
('VY', 'Bulk, solid, fine particles ('),
('WA', 'Int. bulk cont.'),
('WB', 'Wickerbottle'),
('WC', 'Int. bulk cont., steel'),
('WD', 'Int. bulk cont., aluminium '),
('WF', 'Int. bulk cont., metal'),
('WG', 'Int. bulk cont., steel, pressurised > 10 kpa '),
('WH', 'Int. bulk cont., aluminium, pressurised > 10 kpa '),
('WJ', 'Int. bulk cont., metal, pressure 10 kpa '),
('WK ', 'Int. bulk cont., steel, liquid '),
('WL', 'Int. bulk cont., aluminium, liquid '),
('WM', 'Int. bulk cont., metal, liquid'),
('WN', 'Int. bulk cont., woven plastic, without coat/liner '),
('WP', 'Int. bulk cont., woven plastic, coated '),
('WQ', 'Int. bulk cont., woven plastic, with liner '),
('WR', 'Int. bulk cont., woven plastic, coated and liner '),
('WS', 'Int. bulk cont., plastic film '),
('WT', 'Int. bulk cont., textile with out coat/liner '),
('WU', 'Int. bulk cont., natural wood, with inner liner'),
('WV', 'Int. bulk cont., textile, coated '),
('WW', 'Int. bulk cont., textile, with liner'),
('WX', 'Int. bulk cont., textile, coated and liner '),
('WY', 'Int. bulk cont., plywood, with inner liner '),
('WZ', 'Int. bulk cont., reconstituted wood, with inner liner'),
('XA', 'Bag, woven plastic, without inner coat/liner '),
('XB', 'Bag, woven plastic, sift proof '),
('XC', 'Bag, woven plastic, water resistant '),
('XD', 'Bag, plastics film '),
('XF', 'Bag, textile, without inner coat/liner '),
('XG', 'Bag, textile, sift proof '),
('XH', 'Bag, textile, water resistant '),
('XJ', 'Bag, paper, multi-wall '),
('XK', 'Bag, paper, multi-wall, water resistant '),
('YA', 'Comp. pkg, plastic recept. in steel drum '),
('YB', 'Comp. pkg, plastic recept. in steel crate box '),
('YC', 'Comp. pkg, plastic recept. in aluminium drum '),
('YD', 'Comp. pkg, plastic recept. in aluminium crate '),
('YF', 'Comp. pkg, plastic recept. in wooden box '),
('YG', 'Comp. pkg, plastic recept. in plywood drum '),
('YH', 'Comp. pkg, plastic recept. in plywood box '),
('YJ', 'Comp. pkg, plastic recept. in fibre drum '),
('YK', 'Comp. pkg, plastic recept. in fibreboard box '),
('YL', 'Comp. pkg, plastic recept. in plastic drum '),
('YM', 'Comp. pkg, plastic recept. in solid plastic box '),
('YN', 'Comp. pkg, glass recept. in steel drum '),
('YP', 'Comp. pkg, glass recept. in steel crate box '),
('YQ', 'Comp. pkg, glass recept. in aluminium drum '),
('YR', 'Comp. pkg, glass recept. in aluminium crate '),
('YS', 'Comp. pkg, glass recept. in wooden box '),
('YT', 'Comp. pkg, glass recept. in plywood drum '),
('YV', 'Comp. pkg, glass recept. in wickerwork hamper '),
('YW', 'Comp. pkg, glass recept. in fibre drum '),
('YX', 'Comp. pkg, glass recept. in fibreboard box '),
('YY', 'Comp. pkg, glass recept. in expand. plastic pack'),
('YZ', 'Comp. pkg, glass recept. in solid plastic pack '),
('ZA', 'Int. bulk cont., paper, multi-wall '),
('ZB', 'Bag, large'),
('ZC', 'Int. bulk cont., paper, multi-wall, water resistant '),
('ZD', 'Int. bulk cont., rigid plastic, with str. eqpt, solids '),
('ZF', 'Int. bulk cont., rigid plastic, freestanding, solids '),
('ZH', 'Int. bulk cont., rigid plastic, freestanding, pressurised '),
('ZJ', 'Int. bulk cont., rigid plastic, with str. eqpt., liquids '),
('ZK', 'Int. bulk cont., rigid plastic, freestanding, liquids '),
('ZL', 'Int. bulk cont., Comp., rigid plastic, solids '),
('ZM', 'Int. bulk cont., Comp., flexible plastic, solids '),
('ZN', 'Int. bulk cont., Comp., rigid plastic, pressurised '),
('ZP', 'Int. bulk cont., Comp., flexible plastic, pressurised '),
('ZQ', 'Int. bulk cont., Comp., rigid plastic, liquids '),
('ZR', 'Int. bulk cont., Comp., flexible plastic, liquids '),
('ZT', 'Int. bulk cont., fibreboard '),
('ZU', 'Int. bulk cont., flexible'),
('ZV', 'Int. bulk cont., metal, other than steel '),
('ZW', 'Int. bulk cont., natural wood'),
('ZY', 'Int. bulk cont., reconstituted wood');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_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,
  `code` bigint(20) UNSIGNED DEFAULT '1' COMMENT 'this field is used to combine group',
  `sorting_index` bigint(20) UNSIGNED DEFAULT NULL,
  `task` bigint(20) UNSIGNED DEFAULT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `route_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `type` tinyint(1) NOT NULL COMMENT '1=show,hide=2',
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_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;

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

INSERT INTO `permissions` (`id`, `code`, `sorting_index`, `task`, `parent_id`, `name`, `route_name`, `group_name`, `module_id`, `status`, `type`, `created_by`, `updated_by`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, 6, NULL, 'HEALTHCHECK', 'ignition.healthCheck', 'ignition', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(2, NULL, NULL, 6, NULL, 'EXECUTESOLUTION', 'ignition.executeSolution', 'ignition', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(3, NULL, NULL, 6, NULL, 'SHAREREPORT', 'ignition.shareReport', 'ignition', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(4, NULL, NULL, 6, NULL, 'SCRIPTS', 'ignition.scripts', 'ignition', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(5, NULL, NULL, 6, NULL, 'STYLES', 'ignition.styles', 'ignition', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(6, NULL, NULL, 6, NULL, 'HOME', 'home', 'default', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(7, NULL, NULL, 6, NULL, 'LOGIN', 'admin.login', 'admin', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(8, NULL, NULL, 6, NULL, 'LOGIN ATTEMPT', 'admin.login_attempt', 'admin', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(9, NULL, NULL, 6, NULL, 'REGISTER UPDATE', 'admin.register_update', 'admin', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(10, NULL, NULL, 6, NULL, 'REGISTER UPDATE STATUS', 'admin.register_update_status', 'admin', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(11, NULL, NULL, 6, NULL, 'PROFILE', 'admin.profile', 'admin', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(12, NULL, NULL, 6, NULL, 'REGISTER INDEX', 'admin.register_index', 'admin', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(13, NULL, NULL, 6, NULL, 'REGISTER STORE', 'admin.register_store', 'admin', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(14, NULL, NULL, 6, NULL, 'LOGOUT', 'admin.logout', 'admin', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(15, NULL, NULL, 6, NULL, 'CUSTOM LOGOUT', 'custom_logout', 'default', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(16, NULL, NULL, 0, NULL, 'INDEX', 'db.index', 'db', 1, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:03:58'),
(17, NULL, NULL, 5, NULL, 'DESTROY', 'db.destroy', 'db', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(18, NULL, NULL, 6, NULL, 'PERMISSION SYNC', 'default.permission_sync', 'default', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(19, NULL, NULL, 6, NULL, 'WRITE PERMISSION', 'default.write_permission', 'default', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(20, NULL, NULL, 0, NULL, 'INDEX', 'stepsettings.index', 'stepsettings', 1, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:04:03'),
(21, NULL, NULL, 2, NULL, 'STORE', 'stepsettings.store', 'stepsettings', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(22, NULL, NULL, 3, NULL, 'EDIT', 'stepsettings.edit', 'stepsettings', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(23, NULL, NULL, 0, NULL, 'INDEX', 'quickaccess.index', 'quickaccess', 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(24, NULL, NULL, 2, NULL, 'STORE', 'quickaccess.store', 'quickaccess', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(25, NULL, NULL, 3, NULL, 'EDIT', 'quickaccess.edit', 'quickaccess', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(26, NULL, NULL, 0, NULL, 'INDEX', 'dashboard.index', 'dashboard', 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(27, NULL, NULL, 0, NULL, 'INDEX', 'branch.index', 'branch', 1, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:04:15'),
(28, NULL, NULL, 2, NULL, 'STORE', 'branch.store', 'branch', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(29, NULL, NULL, 3, NULL, 'EDIT', 'branch.edit', 'branch', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(30, NULL, NULL, 6, NULL, 'GETALLBRANCH', 'branch.getAllBranch', 'branch', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(31, NULL, NULL, 6, NULL, 'CHANGESTATUS', 'branch.changeStatus', 'branch', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(32, NULL, NULL, 0, NULL, 'INDEX', 'warehouse.index', 'warehouse', 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(33, NULL, NULL, 2, NULL, 'STORE', 'warehouse.store', 'warehouse', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(34, NULL, NULL, 3, NULL, 'EDIT', 'warehouse.edit', 'warehouse', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(35, NULL, NULL, 6, NULL, 'CHANGESTATUS', 'warehouse.changeStatus', 'warehouse', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(36, NULL, NULL, 6, NULL, 'SETTINGS', 'company.settings', 'company', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(37, NULL, NULL, 2, NULL, 'STORE', 'company.store', 'company', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(38, NULL, NULL, 0, NULL, 'INDEX', 'store.index', 'store', 1, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:04:22'),
(39, NULL, NULL, 2, NULL, 'STORE', 'store.store', 'store', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(40, NULL, NULL, 3, NULL, 'EDIT', 'store.edit', 'store', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(41, NULL, NULL, 6, NULL, 'CHANGESTATUS', 'store.changeStatus', 'store', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(42, NULL, NULL, 0, NULL, 'INDEX', 'module.index', 'module', 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(43, NULL, NULL, 2, NULL, 'STORE', 'module.store', 'module', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(44, NULL, NULL, 0, NULL, 'INDEX', 'role.index', 'role', 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(45, NULL, NULL, 1, NULL, 'CREATE', 'role.create', 'role', 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(46, NULL, NULL, 3, NULL, 'EDIT', 'role.edit', 'role', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(47, NULL, NULL, 2, NULL, 'STORE', 'role.store', 'role', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(48, NULL, NULL, 4, NULL, 'UPDATE', 'role.update', 'role', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(49, NULL, NULL, 5, NULL, 'DESTROY', 'role.destroy', 'role', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(50, NULL, NULL, 0, NULL, 'INDEX', 'permission.index', 'permission', 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(51, NULL, NULL, 1, NULL, 'CREATE', 'permission.create', 'permission', 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(52, NULL, NULL, 3, NULL, 'EDIT', 'permission.edit', 'permission', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(53, NULL, NULL, 2, NULL, 'STORE', 'permission.store', 'permission', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(54, NULL, NULL, 4, NULL, 'UPDATE', 'permission.update', 'permission', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(55, NULL, NULL, 5, NULL, 'DESTROY', 'permission.destroy', 'permission', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(56, NULL, NULL, 6, NULL, 'PERMISSION BY SUBMODULE', 'default.permission_by_submodule', 'default', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(57, NULL, NULL, 6, NULL, 'SET ACTIVE WAREHOUSE', 'default.set_active_warehouse', 'default', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(58, NULL, NULL, 6, NULL, 'SET ACTIVE STORE', 'default.set_active_store', 'default', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(59, NULL, NULL, 6, NULL, 'DEFAULT REPORT SETUP', 'default.default_report_setup', 'default', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(60, NULL, NULL, 6, NULL, 'SET SIDE BAR', 'default.set_side_bar', 'default', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(61, NULL, NULL, 6, NULL, 'SET CONFIG FILE', 'default.set_config_file', 'default', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(62, NULL, NULL, 0, NULL, 'INDEX', 'costcenter.index', 'costcenter', 1, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:04:34'),
(63, NULL, NULL, 2, NULL, 'STORE', 'costcenter.store', 'costcenter', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(64, NULL, NULL, 3, NULL, 'EDIT', 'costcenter.edit', 'costcenter', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(65, NULL, NULL, 0, NULL, 'INDEX', 'role_mapping.index', 'role_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:04:59'),
(66, NULL, NULL, 1, NULL, 'CREATE', 'role_mapping.create', 'role_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:04:54'),
(67, NULL, NULL, 2, NULL, 'STORE', 'role_mapping.store', 'role_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(68, NULL, NULL, 3, NULL, 'EDIT', 'role_mapping.edit', 'role_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(69, NULL, NULL, 4, NULL, 'UPDATE', 'role_mapping.update', 'role_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(70, NULL, NULL, 6, NULL, 'UPDATE APPROVAL LOG', 'role_mapping.update_approval_log', 'role_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(71, NULL, NULL, 0, NULL, 'INDEX', 'costcenter_mapping.index', 'costcenter_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:05:29'),
(72, NULL, NULL, 1, NULL, 'CREATE', 'costcenter_mapping.create', 'costcenter_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:05:24'),
(73, NULL, NULL, 2, NULL, 'STORE', 'costcenter_mapping.store', 'costcenter_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(74, NULL, NULL, 3, NULL, 'EDIT', 'costcenter_mapping.edit', 'costcenter_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(75, NULL, NULL, 4, NULL, 'UPDATE', 'costcenter_mapping.update', 'costcenter_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(76, NULL, NULL, 6, NULL, 'UPDATE APPROVAL LOG', 'costcenter_mapping.update_approval_log', 'costcenter_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(77, NULL, NULL, 6, NULL, 'CHECK APPROVALS', 'costcenter_mapping.check_approvals', 'costcenter_mapping', 1, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(78, NULL, NULL, 0, NULL, 'INDEX', 'log.index', 'log', 1, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:05:36'),
(79, 101, NULL, 0, NULL, 'INDEX', 'admin.booking_advice.index', 'booking_advice', 101, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(80, 101, NULL, 6, NULL, 'APPROVE', 'admin.booking_advice.approve', 'booking_advice', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(81, 101, NULL, 3, NULL, 'EDIT', 'admin.booking_advice.edit', 'booking_advice', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(82, 101, NULL, 4, NULL, 'UPDATE', 'admin.booking_advice.update', 'booking_advice', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(83, NULL, NULL, 0, NULL, 'INDEX', 'admin.shipping_order.index', 'shipping_order', 101, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(84, NULL, NULL, 6, NULL, 'APPROVE', 'admin.shipping_order.approve', 'shipping_order', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(85, NULL, NULL, 3, NULL, 'EDIT', 'admin.shipping_order.edit', 'shipping_order', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(86, NULL, NULL, 4, NULL, 'UPDATE', 'admin.shipping_order.update', 'shipping_order', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(87, NULL, NULL, 6, NULL, 'DASHBOARD', 'booking.dashboard', 'booking', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(88, NULL, NULL, 6, NULL, 'LOGOUT', 'booking.logout', 'booking', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(89, NULL, NULL, 0, NULL, 'INDEX', 'booking.shippers.index', 'shippers', 101, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:06:20'),
(90, NULL, NULL, 1, NULL, 'CREATE', 'booking.shippers.create', 'shippers', 101, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:06:25'),
(91, NULL, NULL, 2, NULL, 'STORE', 'booking.shippers.store', 'shippers', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(92, NULL, NULL, 3, NULL, 'EDIT', 'booking.shippers.edit', 'shippers', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(93, NULL, NULL, 4, NULL, 'UPDATE', 'booking.shippers.update', 'shippers', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(94, NULL, NULL, 0, NULL, 'INDEX', 'booking.consignee.index', 'consignee', 101, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:06:34'),
(95, NULL, NULL, 1, NULL, 'CREATE', 'booking.consignee.create', 'consignee', 101, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:06:30'),
(96, NULL, NULL, 2, NULL, 'STORE', 'booking.consignee.store', 'consignee', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(97, NULL, NULL, 3, NULL, 'EDIT', 'booking.consignee.edit', 'consignee', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(98, NULL, NULL, 4, NULL, 'UPDATE', 'booking.consignee.update', 'consignee', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(99, NULL, NULL, 0, NULL, 'INDEX', 'booking.notify.index', 'notify', 101, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:06:44'),
(100, NULL, NULL, 1, NULL, 'CREATE', 'booking.notify.create', 'notify', 101, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:06:40'),
(101, NULL, NULL, 2, NULL, 'STORE', 'booking.notify.store', 'notify', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(102, NULL, NULL, 3, NULL, 'EDIT', 'booking.notify.edit', 'notify', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(103, NULL, NULL, 4, NULL, 'UPDATE', 'booking.notify.update', 'notify', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(104, NULL, NULL, 1, NULL, 'CREATE', 'booking.booking_advice.create', 'booking_advice', 101, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:39:06'),
(105, NULL, NULL, 2, NULL, 'STORE', 'booking.booking_advice.store', 'booking_advice', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(106, NULL, NULL, 0, NULL, 'INDEX', 'booking.booking_advice.index', 'booking_advice', 101, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:24:12'),
(107, NULL, NULL, 6, NULL, 'GET DATAFORBADV', 'booking.booking_advice.get_dataforbadv', 'booking_advice', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(108, NULL, NULL, 1, NULL, 'CREATE', 'booking.shipping_order.create', 'shipping_order', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(109, NULL, NULL, 2, NULL, 'STORE', 'booking.shipping_order.store', 'shipping_order', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(110, NULL, NULL, 0, NULL, 'INDEX', 'booking.shipping_order.index', 'shipping_order', 101, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(111, NULL, NULL, 1, NULL, 'CREATE', 'booking.pre_shipment_advice.create', 'pre_shipment_advice', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(112, NULL, NULL, 2, NULL, 'STORE', 'booking.pre_shipment_advice.store', 'pre_shipment_advice', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(113, NULL, NULL, 0, NULL, 'INDEX', 'booking.pre_shipment_advice.index', 'pre_shipment_advice', 101, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:06:59'),
(114, NULL, NULL, 1, NULL, 'CREATE', 'booking.bl_draft.create', 'bl_draft', 101, 1, 2, 1, NULL, NULL, NULL, NULL, '2021-12-08 03:07:02'),
(115, NULL, NULL, 6, NULL, 'LOGIN', 'booking.login', 'booking', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(116, NULL, NULL, 6, NULL, 'ADMIN LOGIN', 'booking.admin_login', 'booking', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(117, 101, NULL, 0, NULL, 'INDEX', 'booking.customer.index', 'customer', 101, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(118, 101, NULL, 1, NULL, 'CREATE', 'booking.customer.create', 'customer', 101, 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(119, 101, NULL, 2, NULL, 'STORE', 'booking.customer.store', 'customer', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(120, 101, NULL, 3, NULL, 'EDIT', 'booking.customer.edit', 'customer', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL),
(121, 101, NULL, 4, NULL, 'UPDATE', 'booking.customer.update', 'customer', 101, 1, 2, 1, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) 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 `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL),
(2, 1, NULL, NULL),
(3, 1, NULL, NULL),
(4, 1, NULL, NULL),
(5, 1, NULL, NULL),
(6, 1, NULL, NULL),
(7, 1, NULL, NULL),
(8, 1, NULL, NULL),
(9, 1, NULL, NULL),
(10, 1, NULL, NULL),
(11, 1, NULL, NULL),
(12, 1, NULL, NULL),
(13, 1, NULL, NULL),
(14, 1, NULL, NULL),
(15, 1, NULL, NULL),
(16, 1, NULL, NULL),
(17, 1, NULL, NULL),
(18, 1, NULL, NULL),
(19, 1, NULL, NULL),
(20, 1, NULL, NULL),
(21, 1, NULL, NULL),
(22, 1, NULL, NULL),
(23, 1, NULL, NULL),
(24, 1, NULL, NULL),
(25, 1, NULL, NULL),
(26, 1, NULL, NULL),
(27, 1, NULL, NULL),
(28, 1, NULL, NULL),
(29, 1, NULL, NULL),
(30, 1, NULL, NULL),
(31, 1, NULL, NULL),
(32, 1, NULL, NULL),
(33, 1, NULL, NULL),
(34, 1, NULL, NULL),
(35, 1, NULL, NULL),
(36, 1, NULL, NULL),
(37, 1, NULL, NULL),
(38, 1, NULL, NULL),
(39, 1, NULL, NULL),
(40, 1, NULL, NULL),
(41, 1, NULL, NULL),
(42, 1, NULL, NULL),
(43, 1, NULL, NULL),
(44, 1, NULL, NULL),
(45, 1, NULL, NULL),
(46, 1, NULL, NULL),
(47, 1, NULL, NULL),
(48, 1, NULL, NULL),
(49, 1, NULL, NULL),
(50, 1, NULL, NULL),
(51, 1, NULL, NULL),
(52, 1, NULL, NULL),
(53, 1, NULL, NULL),
(54, 1, NULL, NULL),
(55, 1, NULL, NULL),
(56, 1, NULL, NULL),
(57, 1, NULL, NULL),
(58, 1, NULL, NULL),
(59, 1, NULL, NULL),
(60, 1, NULL, NULL),
(61, 1, NULL, NULL),
(62, 1, NULL, NULL),
(63, 1, NULL, NULL),
(64, 1, NULL, NULL),
(65, 1, NULL, NULL),
(66, 1, NULL, NULL),
(67, 1, NULL, NULL),
(68, 1, NULL, NULL),
(69, 1, NULL, NULL),
(70, 1, NULL, NULL),
(71, 1, NULL, NULL),
(72, 1, NULL, NULL),
(73, 1, NULL, NULL),
(74, 1, NULL, NULL),
(75, 1, NULL, NULL),
(76, 1, NULL, NULL),
(77, 1, NULL, NULL),
(78, 1, NULL, NULL),
(79, 1, NULL, NULL),
(80, 1, NULL, NULL),
(81, 1, NULL, NULL),
(82, 1, NULL, NULL),
(83, 1, NULL, NULL),
(84, 1, NULL, NULL),
(85, 1, NULL, NULL),
(86, 1, NULL, NULL),
(87, 1, NULL, NULL),
(88, 1, NULL, NULL),
(89, 1, NULL, NULL),
(90, 1, NULL, NULL),
(91, 1, NULL, NULL),
(92, 1, NULL, NULL),
(93, 1, NULL, NULL),
(94, 1, NULL, NULL),
(95, 1, NULL, NULL),
(96, 1, NULL, NULL),
(97, 1, NULL, NULL),
(98, 1, NULL, NULL),
(99, 1, NULL, NULL),
(100, 1, NULL, NULL),
(101, 1, NULL, NULL),
(102, 1, NULL, NULL),
(103, 1, NULL, NULL),
(104, 1, NULL, NULL),
(105, 1, NULL, NULL),
(106, 1, NULL, NULL),
(107, 1, NULL, NULL),
(108, 1, NULL, NULL),
(109, 1, NULL, NULL),
(110, 1, NULL, NULL),
(111, 1, NULL, NULL),
(112, 1, NULL, NULL),
(113, 1, NULL, NULL),
(114, 1, NULL, NULL),
(115, 1, NULL, NULL),
(116, 1, NULL, NULL),
(117, 1, NULL, NULL),
(118, 1, NULL, NULL),
(119, 1, NULL, NULL),
(120, 1, NULL, NULL),
(121, 1, NULL, NULL);

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

--
-- Table structure for table `principal`
--

CREATE TABLE `principal` (
  `id` int(1) NOT NULL,
  `name` varchar(30) NOT NULL,
  `company` varchar(50) NOT NULL,
  `short` varchar(3) NOT NULL,
  `eq_head` varchar(300) NOT NULL,
  `mr_head` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `address2` varchar(200) NOT NULL,
  `rda_acc` varchar(100) NOT NULL,
  `bin_no` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `agent` int(11) NOT NULL COMMENT '1=famfa,2=globelink',
  `office_address` text NOT NULL,
  `contact_no` text,
  `agent_code` varchar(20) DEFAULT NULL,
  `rda_no` varchar(20) DEFAULT NULL,
  `ordering` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `principal`
--

INSERT INTO `principal` (`id`, `name`, `company`, `short`, `eq_head`, `mr_head`, `address`, `address2`, `rda_acc`, `bin_no`, `agent`, `office_address`, `contact_no`, `agent_code`, `rda_no`, `ordering`) VALUES
(1, 'Sinokor(FSL)', 'Sinokor Merchant Marine Co. Ltd.', 'SKN', 'Famfa Solution Limited', '<h3>As Agent only for: Sinokor Merchant Marine Co. Ltd.</h3>', '<b><u>Operational Office: </u></b>HBFC Building (1st Floor),1/D,Agrabad C/A,Chittagong-4100,Bangladesh. Tel:+88 02333311149-50,Fax:+88 031-2513273', '<b><u>Dhaka Office: </u></b>Bashati Horizon,52/1,Flat No #B-3,Road No #17,House #21,Banani C/A,Dhaka-1213,Bangladesh. Phone: +88 029821892-94', '<b>0030062914068</b> maintained with <b>One Bank Ltd</b>.', '০০০১৭৭৫৯৪-০৫০৩', 1, 'HBFC Building (1st Floor),1/D Agrabad C/A, Chattogram', 'Tel:(880) 2333311149-50,Fax:(880) 31 2513273', 'FSL', '0030062914068', 20),
(2, 'Perma', 'Perma Shipping Lines Pte Ltd.', 'PMS', 'Globe Link Associates Limited.', '<h3>As Agent only for: Perma Shipping Pte Ltd.</h3>', '<b><u>Chittagong Office: </u></b>HBFC Building (3rd Floor),1/D,Agrabad C/A,Chittagong-4100,Bangladesh. Tel:+880 2333313272-3,Fax:+880 2333313273', '<b><u>Dhaka Office: </u></b>Bashati Horizon,52/1,Flat No #B-3,Road No #17,House #21,BananiC/A,Dhaka-1213,Bangladesh. Phone: +88029-821892-94', '<b>0030062914068</b> maintained with <b>One Bank Ltd</b>.', '০০০২৮৫২২৯-০৫০৩', 2, 'HBFC Building (3rd Floor),1/D Agrabad C/A, Chattogram', 'Tel:+880 2333313272-3,Fax:(880) 31 2513273', 'GLA', '0030062914068', 5),
(4, 'Sinokor (GLA)', 'Sinokor Merchant Marine Co. Ltd.', 'SNK', 'Globe Link Associates Limited.', '<h3>As Agent only for: Sinokor Merchant Marine Co. Ltd.</h3>', '<b><u>Operational Office: </u></b>HBFC Building (1st Floor),1/D,Agrabad C/A,Chittagong-4100,Bangladesh. Tel:+88 02333311149-50,Fax: +88 \r\n02333313273', '<b><u>Dhaka Office: </u></b>Bashati Horizon,52/1,Flat No #B-3,Road No #17,House #21,Banani C/A,Dhaka-1213,Bangladesh. Phone: +88 029821892-94, Fax: +88 02333313273', '<b>0030062914068</b> maintained with <b>One Bank Ltd</b>.', '০০০২৮৫২২৯-০৫০৩', 2, 'HBFC Building (1st Floor),1/D Agrabad C/A, Chattogram', 'Tel:(880) 2333311149-50,Fax:+880 2333313273', 'GLA', '0030062914068', 10),
(5, 'Intergulf', 'Intergulf Shipping Lines Pvt. Ltd.', 'IGL', 'Globe Link Associates Limited.', '<h3>As Agent only for: Intergulf Shipping Line Pte Ltd.</h3>', '<b><u>Chittagong Office: </u></b>HBFC Building (1st Floor),1/D,Agrabad C/A.Chittagong-4100,Bangladesh. Tel:(880)31-711149-50,Fax:(880)31-2513273', '<b><u>Dhaka Office</u></b></br>Bashati Horizon, 52/1, Flat No # B-3, Road No # 17 </br>House # 21, Banani C/A, Dhaka-1213, Bangladesh</br>Tel : Phone: +880 29 821892-94<b><u>Dhaka Office: </u></b>Bash', '<b>0030062914068</b> maintained with <b>One Bank Ltd</b>.', '০০০২৮৫২২৯-০৫০৩', 2, 'HBFC Building (3rd Floor),1/D Agrabad C/A, Chattogram', 'Tel:(880) 31 711149-50,Fax:(880) 31 2513273', 'GLA', '0030062914068', 25),
(6, 'MarineLinks', 'Marine Links Shipping Services LLC.', 'MRL', 'Globe Link Associates Limited.', '<h3>As Agent only for: Marine Links Shipping Line.</h3>', '<b><u>Chittagong Office: </u></b>HBFC Building (1st Floor),1/D,Agrabad C/A.Chittagong-4100,Bangladesh. Tel:(880)31-711149-50,Fax:(880)31-2513273', '<b><u>Dhaka Office: </u></b>Bashati Horizon,52/1,Flat No #B-3,Road No #17,House # 21,Banani C/A,Dhaka-1213,Bangladesh. Phone: +88029821892-94', '<b>0030062914068</b> maintained with <b>One Bank Ltd</b>.', '০০০২৮৫২২৯-০৫০৩', 2, 'HBFC Building (3rd Floor),1/D Agrabad C/A, Chattogram', 'Tel:(880) 31 711149-50,Fax:(880) 31 2513273', 'GLA', '0030062914068', 30),
(7, 'SITC', 'SITC Container Lines Co. Ltd.', 'SCC', 'Famfa Solution Limited', '<h3>As Agent only for: SITC Container Lines Co. Ltd.</h3>', '<b><u>Operational Office:</u> </b>HBFC Building (4th Floor),1/D,Agrabad C/A.Chittagong-4100,Bangladesh. Phone: +880725475-77.', '<b><u>Dhaka Office:</u> </b>Hasan Holdings (11th Floor),52/1,New Eskaton Road,Dhaka-1000,Bangladesh. Phone: +880725475-77.', '0031040001479 with One Bank Limited', '০০০১৭৭৫৯৪-০৫০৩', 1, 'HBFC Building (4th Floor),1/D Agrabad C/A, Chattogram', 'Phone: +880 725475-77', 'FSL', '0031040001479', 15);

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

--
-- Table structure for table `quick_accesses`
--

CREATE TABLE `quick_accesses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sorting` int(11) NOT NULL DEFAULT '0',
  `module_id` bigint(20) UNSIGNED DEFAULT NULL,
  `admin_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'active = 1 inactive =2',
  `warehouse_id` bigint(20) UNSIGNED DEFAULT '1',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_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 `report_print_set_ups`
--

CREATE TABLE `report_print_set_ups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `print_view` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=full/0=pos',
  `print_head` longtext COLLATE utf8mb4_unicode_ci COMMENT 'Html with php',
  `print_foot` longtext COLLATE utf8mb4_unicode_ci COMMENT 'Html with php',
  `dual_currency` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1-yes/0-no',
  `type` bigint(20) UNSIGNED NOT NULL,
  `warehouse_id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_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;

--
-- Dumping data for table `report_print_set_ups`
--

INSERT INTO `report_print_set_ups` (`id`, `name`, `print_view`, `print_head`, `print_foot`, `dual_currency`, `type`, `warehouse_id`, `status`, `created_by`, `updated_by`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Default', 1, NULL, NULL, 0, 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL);

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `warehouse_id` tinyint(1) NOT NULL,
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_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;

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

INSERT INTO `roles` (`id`, `name`, `status`, `warehouse_id`, `created_by`, `updated_by`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 1, 1, 1, NULL, NULL, NULL, NULL, NULL),
(2, 'Admin', 1, 1, 1, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `role_mappings`
--

CREATE TABLE `role_mappings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `action_step_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED DEFAULT NULL,
  `admin_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` 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;

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

--
-- Table structure for table `steps`
--

CREATE TABLE `steps` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `warehouse_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_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 `step_settings`
--

CREATE TABLE `step_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sorting` int(11) NOT NULL DEFAULT '1',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'active = 1 inactive =2',
  `warehouse_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_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 `vat_taxes`
--

CREATE TABLE `vat_taxes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` double(8,2) NOT NULL DEFAULT '0.00' COMMENT 'value as percent',
  `is_fixed` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1-fixed/0-customized',
  `serial` int(11) NOT NULL DEFAULT '0',
  `depends_on` int(11) NOT NULL DEFAULT '0',
  `ledger_id` int(10) UNSIGNED DEFAULT NULL,
  `expense_ledger_id` int(10) UNSIGNED DEFAULT NULL,
  `module_id` int(10) UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `warehouse_id` int(10) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` 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;

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

--
-- Table structure for table `warehouses`
--

CREATE TABLE `warehouses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_table_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=>storeTransaction,1=>FgstoreTransaction',
  `name_eng` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_local` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` tinyint(1) NOT NULL COMMENT '1=>branch,2=>warehouse,3=>store',
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_eng` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_local` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_info` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sell_price` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=warehouse/ 0=store',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `store_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custome_pl` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=Yes/ 0=No',
  `acc_inventory` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=Yes/ 0=No',
  `cal_method` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=AVG/ 2=LIFO/ 3=FIFO',
  `use_acc_group` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=multiple/ 0=single',
  `stock_check` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=yes/ 0=no',
  `avg_check` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=yes/ 0=no',
  `use_expiry` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=yes/ 0=no',
  `order_all` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=yes/ 0=no',
  `marketing` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=yes/ 0=no',
  `vat_reg_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `cheque_maintain` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=Yes/ 0=No',
  `purchase_attr` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=dont show, 2=buy price, 3=buy code',
  `currency_id` int(11) DEFAULT NULL,
  `barcode_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-EAN_128, 8-EAN_8, 13-EAN_13, 14=EAN_14',
  `barcode_head` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `barcode_foot` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time_zone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_in_time` time DEFAULT NULL,
  `check_in_consider_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_out_consider_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_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;

--
-- Dumping data for table `warehouses`
--

INSERT INTO `warehouses` (`id`, `parent_id`, `store_table_type`, `name_eng`, `name_local`, `type`, `logo`, `signature`, `address_eng`, `address_local`, `contact_info`, `email`, `sell_price`, `status`, `store_name`, `custome_pl`, `acc_inventory`, `cal_method`, `use_acc_group`, `stock_check`, `avg_check`, `use_expiry`, `order_all`, `marketing`, `vat_reg_no`, `start_date`, `end_date`, `cheque_maintain`, `purchase_attr`, `currency_id`, `barcode_type`, `barcode_head`, `barcode_foot`, `country`, `time_zone`, `check_in_time`, `check_in_consider_time`, `check_out_consider_time`, `created_by`, `updated_by`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(7, NULL, 0, 'SITC', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, 1, 1, 1, 1, 1, 1, 0, 1, 0, NULL, NULL, NULL, 1, 1, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `action_step`
--
ALTER TABLE `action_step`
  ADD PRIMARY KEY (`id`),
  ADD KEY `action_step_action_id_foreign` (`action_id`),
  ADD KEY `action_step_step_id_foreign` (`step_id`);

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

--
-- Indexes for table `admin_costcenter`
--
ALTER TABLE `admin_costcenter`
  ADD PRIMARY KEY (`admin_id`,`cost_center_id`);

--
-- Indexes for table `admin_role`
--
ALTER TABLE `admin_role`
  ADD PRIMARY KEY (`admin_id`,`role_id`),
  ADD KEY `admin_role_role_id_foreign` (`role_id`);

--
-- Indexes for table `approvals`
--
ALTER TABLE `approvals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `approvals_approvable_type_approvable_id_index` (`approvable_type`,`approvable_id`);

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

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

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

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

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

--
-- Indexes for table `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `logs_laggable_type_laggable_id_index` (`laggable_type`,`laggable_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `module_role`
--
ALTER TABLE `module_role`
  ADD PRIMARY KEY (`module_id`,`role_id`),
  ADD KEY `module_role_role_id_foreign` (`role_id`);

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_route_name_unique` (`route_name`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `permission_role_permission_id_index` (`permission_id`),
  ADD KEY `permission_role_role_id_index` (`role_id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `warehouses`
--
ALTER TABLE `warehouses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `warehouses_parent_id_foreign` (`parent_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `mlo_ctr_code_ci`
--
ALTER TABLE `mlo_ctr_code_ci`
  MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `principal`
--
ALTER TABLE `principal`
  MODIFY `id` int(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `action_step`
--
ALTER TABLE `action_step`
  ADD CONSTRAINT `action_step_action_id_foreign` FOREIGN KEY (`action_id`) REFERENCES `actions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `action_step_step_id_foreign` FOREIGN KEY (`step_id`) REFERENCES `steps` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `admin_role`
--
ALTER TABLE `admin_role`
  ADD CONSTRAINT `admin_role_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `admin_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `module_role`
--
ALTER TABLE `module_role`
  ADD CONSTRAINT `module_role_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `module_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `warehouses`
--
ALTER TABLE `warehouses`
  ADD CONSTRAINT `warehouses_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `warehouses` (`id`);
COMMIT;

