-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 01, 2021 at 10:55 AM
-- Server version: 10.3.32-MariaDB
-- PHP Version: 7.3.32

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `portalbd_mr_do`
--

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

--
-- 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_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_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;

--
-- Indexes for dumped tables
--

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

--
-- 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_packages`
--
ALTER TABLE `mlo_packages`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- 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_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_packages`
--
ALTER TABLE `mlo_packages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
