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

START TRANSACTION;



--
-- Database: `gadgetoy_iciccltd`
--

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

--
-- Table structure for table `addendums`
--

CREATE TABLE `addendums` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cn_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `addn_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(50,2) NOT NULL,
  `extra` int(11) NOT NULL DEFAULT '0',
  `currency` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  `net_amounts` decimal(50,2) NOT NULL,
  `mr_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mr_date` date NOT NULL,
  `mop` tinyint(4) NOT NULL COMMENT 'cash =1 and payorder =2 cheque = 3 ',
  `bank_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cheque_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cheque_date` date NOT NULL,
  `clouse` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `producer_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `producer_number` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `risk_option` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `marine_rate` decimal(50,2) DEFAULT '0.00',
  `premium` decimal(50,2) DEFAULT '0.00',
  `marine_value` decimal(50,2) DEFAULT '0.00',
  `war_rate` decimal(50,2) DEFAULT '0.00',
  `war_value` decimal(50,2) DEFAULT '0.00',
  `vat_rate` decimal(50,2) DEFAULT '0.00',
  `vat_value` decimal(50,2) DEFAULT '0.00',
  `stamp_duty` decimal(50,2) NOT NULL,
  `grand_total` decimal(50,2) NOT NULL,
  `post_by` int(11) NOT NULL DEFAULT '0',
  `updated_by` int(11) 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 `addendums`
--

INSERT INTO `addendums` (`id`, `cn_no`, `addn_no`, `amount`, `extra`, `currency`, `rate`, `net_amounts`, `mr_no`, `mr_date`, `mop`, `bank_name`, `branch`, `cheque_no`, `cheque_date`, `clouse`, `producer_name`, `producer_number`, `risk_option`, `marine_rate`, `premium`, `marine_value`, `war_rate`, `war_value`, `vat_rate`, `vat_value`, `stamp_duty`, `grand_total`, `post_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'wsl-23445', '@w3-876%', 5000.00, 50, 'us', 20.00, 150000.00, '2300', '2021-02-11', 2, 'asia', 'ctg,bank', '2300', '2021-02-11', '2300', 'done', '2300', 'n\\a', 5.00, 15000.00, 7500.00, 5.00, 7500.00, 5.00, 750.00, 100.00, 15850.00, 0, 0, '2021-02-11 03:21:03', '2021-02-11 03:21:03'),
(2, 'ww-873,23329', 'w0-24556', 100.00, 5, 'us', 56.00, 5880.00, '230978', '2021-02-11', 2, 'asia', 'ctg', '2300', '2021-02-11', '334567', '34fdfd', 'hello57', 'n\\a', 6.00, 823.20, 352.80, 8.00, 470.40, 10.00, 82.32, 3.92, 909.44, 1, 1, '2021-02-11 03:33:33', '2021-02-11 06:36:53'),
(3, 'ww-873,23329', 'w-3245', 500.00, 10, 'us', 5.00, 2750.00, 'w-345', '2021-02-11', 2, 'bank asia', 'ctg,@-346', '2300', '2021-02-11', 'w-235', 'hello world', 'w-3402', 'none', 5.00, 275.00, 137.50, 5.00, 137.50, 5.00, 13.75, 1.83, 290.58, 1, 1, '2021-02-11 06:05:34', '2021-02-11 06:37:30'),
(4, 'h-3900', 'sl-3246', 500.00, 5, 'us', 84.50, 44362.50, '@#4-4578', '2021-02-11', 2, 'asia', 'cda,avenue,colnel hat', 'sl-32@-done,', '2021-02-11', '#@sl-wlree', 'donthug', '@#$sloww', 'n\\a ddddr-,sherr5', 5.00, 4436.25, 2218.13, 5.00, 2218.13, 5.00, 221.81, 29.58, 4687.64, 1, 0, '2021-02-11 07:07:01', '2021-02-11 07:07:01'),
(5, '#2-2-w#2-2-w', 'hv-3764', 200.00, 5, 'us', 84.60, 17766.00, 'sl-234$#', '2021-02-11', 1, NULL, NULL, NULL, '2021-02-11', 'don#@#4', 'hello world', 'sl-32$45', 'done@#none', 5.00, 1776.60, 888.30, 5.00, 888.30, 5.00, 88.83, 50.00, 1915.43, 1, 1, '2021-02-11 07:11:14', '2021-02-11 07:14:10'),
(6, '#2-2-w#2-2-w', 'sl0-2345', 500.00, 2, 'us', 400.00, 204000.00, 'sl@445', '2021-02-11', 2, 'aisa', 'chittagong, shopping -complex', 'sl-233455@34', '2021-02-11', 'sl-234@#s-w4', 'okS#', '200@#4e', 'N\\a', 2.50, 12240.00, 5100.00, 3.50, 7140.00, 4.00, 489.60, 50.00, 12779.60, 1, 1, '2021-02-11 07:27:20', '2021-02-11 07:33:39'),
(7, '@#swie2345', '@@#3467', 500.00, 8, 'us', 84.50, 45630.00, 'sl@#$ddf', '2021-02-15', 1, NULL, NULL, NULL, '2021-02-15', 'hello world', 'done', 'sl@#hello', 'none', 5.00, 4563.00, 2281.50, 5.00, 2281.50, 5.00, 228.15, 30.42, 4821.57, 1, 0, '2021-02-15 03:19:30', '2021-02-15 03:19:30'),
(8, '@#99585657680000', 'sl-0975@#$', 100000.00, 88, 'us', 500.00, 93750000.00, '2sllurr', '2021-02-16', 1, NULL, NULL, NULL, '2021-02-15', 'hello worlfl', 'done34556', 'he##$45', 'NONE@#$%', 1000.00, 1875000000.00, 937500000.00, 1000.00, 937500000.00, 1000.00, 18750000000.00, 62500.00, 20625062500.00, 1, 0, '2021-02-15 05:27:22', '2021-02-15 05:27:22'),
(9, '@#99585657680000', '456622jhhhgs3', 50000.00, 20, 'us', 85.60, 5136000.00, '34000', '2021-02-15', 1, NULL, NULL, NULL, '2021-02-16', '%^&**-hello world', '%^&**-hello world', '%^&**-hello world', '%^&**-hello world', 400.00, 469070880.00, 20544000.00, 8733.00, 448526880.00, 100.00, 469070880.00, 3424.00, 938145184.00, 1, 1, '2021-02-15 06:00:59', '2021-02-17 03:37:06'),
(10, 'jajsdfkj', '@ghyrytuiv', 500.00, 4, 'us', 4.00, 2080.00, '4', '2021-02-17', 1, NULL, NULL, NULL, '2021-02-17', 'done', '3', '3', '3', 3.00, 124.00, 62.00, 3.00, 62.00, 3.00, 4.00, 1.00, 129.00, 1, 0, '2021-02-17 03:40:48', '2021-02-17 03:40:48'),
(11, '@3040', 'Sffkgt0866', 6000.00, 0, 'us', 87.10, 522582.00, '345', '2021-02-18', 1, NULL, NULL, NULL, '2021-02-17', 'nohthwx3356', 'hello worr', '23994', 'n\\a', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 348.00, 348.00, 1, 0, '2021-02-17 05:19:32', '2021-02-17 05:19:32'),
(12, 'JH\'KKJJ\'LKK; 24.02.2021', 'BJH:ICIC:02.02.2022', 50000.00, 10, 'us', 84.50, 4647500.00, '1245', '2021-02-24', 2, 'Bank Asia', 'Dhaka, Bangladesh.', '1545412', '2021-03-02', 'NONE', '12154', '1244', 'ICIC\'JKH\'KJHH\'KJJHG', 10.00, 474696.00, 464750.00, 0.21, 9946.00, 15.00, 71204.00, 3098.00, 548998.00, 2, 0, '2021-02-24 09:08:31', '2021-02-24 09:08:31'),
(13, 'ICI/KTJ/MC-0043/02/2021', 'ICI/KTJ/MC-001/02/2021', 1000.00, 0, 'us', 84.95, 84950.00, '05', '2021-02-24', 3, 'Social Islami Bank Limited', 'Dwanhat Branch', '7799169', '2021-02-24', 'None', 'Mojammel', '0840', 'ICIC', 0.30, 297.00, 255.00, 0.05, 42.00, 15.00, 45.00, 57.00, 399.00, 2, 0, '2021-02-24 09:40:52', '2021-02-24 09:40:52'),
(14, 'ICI/KTJ/MC-0057/02/2021', '234000', 5000.00, 10, 'us', 84.50, 464750.00, '2300', '2021-02-26', 1, NULL, NULL, NULL, '2021-02-27', 'done', 'hello woel', '2300', 'done', 5.00, 23238.00, 23238.00, NULL, 0.00, 4.00, 930.00, 310.00, 24478.00, 1, 0, '2021-02-27 09:11:31', '2021-02-27 09:11:31'),
(15, 'ICIB/BLL/KJJ:01/03/2021', 'ICIB/BLL/KJJ:215:01/03/2021', 35000.00, 10, 'us', 84.95, 3270575.00, 'NL:1245LK', '2021-03-01', 3, 'Bank Asia Limited', 'Muradpur Branch, Chattogram', '2565664', '2021-03-01', 'None', 'Mojammel', '12544', 'ICC\'KLKK\'LKO\'JHUU', 0.30, 11447.00, 9812.00, 0.05, 1635.00, 15.00, 1717.00, 2180.00, 15344.00, 2, 2, '2021-03-01 11:13:10', '2021-03-01 11:19:26'),
(16, 'ICI/KTJ/MC-70/02/2021', 'ICI/KTJ/MC/ ADDM-0002/01/2021', 1000.00, 0, 'us', 84.95, 84950.00, '10', '2021-03-02', 1, NULL, NULL, NULL, '2021-03-02', 'No', 'Mozammel', '0840', 'ICC', 0.30, 255.00, 255.00, NULL, 0.00, 15.00, 38.00, 0.00, 293.00, 2, 0, '2021-03-02 11:15:12', '2021-03-02 11:15:12'),
(17, 'ICI/KTJ/MC-0040/02/2021', 'ICI/KTJ/MC/ADDM-005/03/2021', 20000.00, 0, 'us', 84.95, 1699000.00, '10', '2021-02-06', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799190', '2021-02-06', 'None', 'Mozammel', '0840', 'ICC\'C\' Risk Only', 0.30, 5097.00, 5097.00, NULL, 0.00, 15.00, 765.00, 1133.00, 6995.00, 2, 2, '2021-03-06 10:17:29', '2021-03-08 12:24:12'),
(18, 'ICI/KTJ/MC-0083/03/2021', 'JSHFS:0909', 10000.00, 10, 'us', 84.95, 934450.00, '76', '2021-03-08', 3, 'Social Islami Bank', 'Muradpur', '58456588', '2021-01-02', 'None', 'Mojammel', '1255', 'ICC\"C Risk Onley', 0.30, 3270.00, 2803.00, 0.05, 467.00, 15.00, 491.00, 623.00, 4384.00, 2, 0, '2021-03-08 11:57:39', '2021-03-08 11:57:39'),
(19, 'ICI/KTJ/MC-0083/03/2021', 'NJBH:1254', -46339.80, 10, 'us', 84.95, -4330223.00, 'NJ-877', '2021-03-08', 3, 'Social Bank', 'Dhaka', '125454', '2021-01-01', 'None', 'Moja', '125', 'ICC\"J Risk Only', 0.30, -12991.00, -12991.00, NULL, 0.00, 15.00, -1949.00, -2887.00, -17827.00, 2, 0, '2021-03-08 12:08:29', '2021-03-08 12:08:29'),
(20, 'ICI/KTJ/MC-0090/03/2021', 'ICI/KTJ/MC/ADDM-0020/03/2021', 2000.00, 10, 'us', 84.95, 186890.00, '116', '2021-03-10', 1, NULL, NULL, NULL, '2021-03-10', 'None', 'Mozammel', '0840', 'ICC\'C\'Risk only.', 0.30, 561.00, 561.00, NULL, 0.00, 15.00, 84.00, 125.00, 770.00, 2, 0, '2021-03-10 09:37:14', '2021-03-10 09:37:14'),
(21, 'ICI/KTJ/MC-87/03/2021', 'ICI/KTJ/ADDM', 12300.00, 0, 'us', 84.95, 1044885.00, '04', '2021-03-13', 3, NULL, 'DWANHAT', '121202', '2021-03-13', 'NONE', 'MOZMMEL', '08400', 'ICCC RISK ONLY', 0.30, 3135.00, 3135.00, NULL, 0.00, 15.00, 470.00, 697.00, 4302.00, 2, 0, '2021-03-13 10:46:31', '2021-03-13 10:46:31'),
(22, 'ICI/KTJ/MC-0090/03/2021', 'ICI/KTJ/MC/ADDM-10', 10000.00, 10, 'us', 84.95, 934450.00, '12', '2021-03-14', 3, 'sibl', 'dewanhat Branch', '7799169', '2021-03-14', 'none', 'Mozammel', '0840', 'ICC\'C\' Risk only.', 0.30, 2803.00, 2803.00, NULL, 0.00, 15.00, 420.00, 623.00, 3846.00, 2, 0, '2021-03-14 04:43:22', '2021-03-14 04:43:22'),
(23, 'ICI/KTJ/MC-95/03/2021', 'ICI/KTJ/MC/ADDM-0001/03/2021', 500.00, 10, 'us', 84.95, 46723.00, '121', '2021-03-14', 1, NULL, NULL, NULL, '2021-03-14', 'no', 'Mozammel', '0840', 'ICI\'C\'Risk Only.', 0.30, 140.00, 140.00, NULL, 0.00, 15.00, 21.00, 31.00, 192.00, 2, 0, '2021-03-14 06:55:10', '2021-03-14 06:55:10');

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

--
-- Table structure for table `cover_notes`
--

CREATE TABLE `cover_notes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cn_number` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime DEFAULT CURRENT_TIMESTAMP,
  `client_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_address` text COLLATE utf8mb4_unicode_ci,
  `bank_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_address` text COLLATE utf8mb4_unicode_ci,
  `branch` text COLLATE utf8mb4_unicode_ci,
  `interest_covered` text COLLATE utf8mb4_unicode_ci,
  `voyage_from` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voyage_to` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transit_by` int(11) NOT NULL DEFAULT '0' COMMENT 'stream  = 1 value = 1500,otherwise  lory = 2 value = 50 ',
  `period_from` date DEFAULT NULL,
  `period_to` date NOT NULL,
  `sum_insured` decimal(50,2) NOT NULL,
  `extra` int(50) DEFAULT NULL,
  `currency` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rate` decimal(50,2) NOT NULL,
  `amount` decimal(30,2) NOT NULL,
  `printing_sl` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `mr_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `mr_date` date DEFAULT NULL,
  `mop` tinyint(4) DEFAULT NULL COMMENT 'cash =1 and payorder =2 cheque = 3',
  `bankram_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cheque_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cheque_date` date DEFAULT NULL,
  `producer_number` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `producer_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `declaration` text COLLATE utf8mb4_unicode_ci,
  `risk_option` text COLLATE utf8mb4_unicode_ci,
  `issue_date` date DEFAULT NULL,
  `marine_rate` decimal(10,4) DEFAULT NULL,
  `premium` decimal(50,2) DEFAULT '0.00',
  `marine_value` decimal(50,2) DEFAULT '0.00',
  `war_rate` decimal(10,2) DEFAULT '0.00',
  `war_value` decimal(30,2) DEFAULT '0.00',
  `vat_rate` decimal(10,2) DEFAULT '0.00',
  `vat_value` decimal(50,2) DEFAULT '0.00',
  `stamp_duty` decimal(50,2) DEFAULT '0.00',
  `grand_total` decimal(50,2) DEFAULT '0.00',
  `post_by` int(11) NOT NULL DEFAULT '0',
  `updated_by` int(11) 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 `cover_notes`
--

INSERT INTO `cover_notes` (`id`, `no`, `cn_number`, `date`, `client_name`, `client_address`, `bank_name`, `bank_address`, `branch`, `interest_covered`, `voyage_from`, `voyage_to`, `transit_by`, `period_from`, `period_to`, `sum_insured`, `extra`, `currency`, `rate`, `amount`, `printing_sl`, `mr_no`, `mr_date`, `mop`, `bankram_mr`, `branch_mr`, `cheque_no`, `cheque_date`, `producer_number`, `producer_name`, `declaration`, `risk_option`, `issue_date`, `marine_rate`, `premium`, `marine_value`, `war_rate`, `war_value`, `vat_rate`, `vat_value`, `stamp_duty`, `grand_total`, `post_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'w-23455', 'wsl-23445', '2021-02-11 00:00:00', 'hasan mahmood', 'chittagong', 'simply dummy text of t', 't come from?', 't come from?', 'done,-2e', 't come from?', 't come from?', 1, '2021-02-11', '2021-02-11', 500.00, 200, 'us', 84.00, 126000.00, '2300', 'w-32', '2021-02-11', 2, 'asia', 'ctg -32,bangladesh', '200w-43', '2021-02-11', 'hello-34,21', 'hello world', 'n\\a', 'n\\a', '2021-02-11', 5.0000, 12600.00, 6300.00, 5.00, 6300.00, 5.00, 630.00, 84.00, 13314.00, 1, 0, '2021-02-11 03:04:32', '2021-02-11 03:04:32'),
(2, '3m,3-w-3457', 'ww-873,23329', '2021-02-11 00:00:00', 'md jahed', 'ctg,zobeda vila,muradpur-100', 'asia', 'gec-or nizam road,', 'ctg,@murdpur-2345', 'n\\a', 'china', 'chiittagong', 1, '2021-02-11', '2021-02-11', 500.00, 2, 'us', 84.50, 43095.00, 'w-234-k,34', '23w-sl', '2021-02-11', 2, 'jamuna bank', 'muradpur', 'w-sl-432', '2021-02-11', 'w-32-34', 'hello world', 'n\\a', 'none', '2021-02-11', 10.0000, 6033.30, 4309.50, 4.00, 1723.80, 5.00, 301.67, 28.73, 6363.69, 1, 1, '2021-02-11 03:09:47', '2021-02-11 03:14:38'),
(3, 'w-2300@#', 'h-3900', '2021-02-11 00:00:00', 'hasan mahmood', 'chittagong , bangladesh ,', 'bank asia', 'GEC circle #road no @33445', 'GEC Branch @ chittagong', 'done @#,', 'china', 'chittagong', 1, '2021-02-11', '2021-02-12', 5000.00, 10, 'us', 84.50, 464750.00, 'sl-233#', 'w-5463', '2021-02-11', 2, 'Jamuna Bank', 'Muradpur , Mirzarpul', 'sl2-#@23456', '2021-02-11', 'hm-754', 'donr445-23', 'n\\a-2', 'n\\a', '2021-02-11', 5.0000, 46475.00, 23237.50, 5.00, 23237.50, 5.00, 2323.75, 309.83, 49108.58, 1, 0, '2021-02-11 06:47:50', '2021-02-11 06:47:50'),
(4, '#2-2-w', '#2-2-w#2-2-w', '2021-02-11 00:00:00', 'lorem ipsum', 'chittagong,-@## Bangladesh', 'jamuna bank', 'chittagong, bnagladesh 234121#', 'chittagong, bnagladesh 234121#', '1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into elec', 'china', 'dhaka', 2, '2021-02-11', '2021-02-11', 5000.00, 2, 'us', 84.50, 430950.00, 'sw-234m,@3', 'sw-234m,@3', '2021-02-11', 1, NULL, NULL, '0', '2021-02-11', '@#5-w-sl', 'www.,', '1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into elec', '1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into elec', '2021-02-11', 5.0000, 64642.50, 21547.50, 10.00, 43095.00, 100.00, 64642.50, 50.00, 129335.00, 1, 0, '2021-02-11 06:51:37', '2021-02-11 06:51:37'),
(5, '@#-soneer;r', '#$%5sl-sler', '2021-02-11 00:00:00', 'zubayed karim', 'dhaka,savar ,polash bari-100', 'chittagong,bangladesh ,', 'chittagong', 'ctg,2003-@34', 'and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 'china', 'dhaka', 1, '2021-02-11', '2021-02-11', 500.00, 10, 'us', 84.50, 46475.00, 'sl-2345', '#2-9734', '2021-02-11', 1, NULL, NULL, '0', '2021-02-11', 'sl#@-2345', 'helolowdcnc@@#-df', 'and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 'none', '2021-02-11', 5.0000, 6971.25, 2323.75, 10.00, 4647.50, 10.00, 697.13, 30.98, 7699.36, 1, 0, '2021-02-11 07:23:02', '2021-02-11 07:23:02'),
(6, '@#3002wiwele does', '@#swie2345', NULL, 'rahat uddin', 'vanila javascript , 200@er', 'vanila javascript , 200@er', 'vanila javascript , 200@er', 'vanila javascript , 200@er', 'covered', 'chittagong', 'dhaka', 1, '2021-02-15', '2021-02-15', 5000.00, 80, 'us', 84.50, 760500.00, '34sk', '@345wrldf', '2021-02-15', 1, NULL, NULL, '0', '2021-02-15', '23400', 'helllo world', 'vanila javascript , 200@er', 'vanila javascript , 200@er', '2021-02-15', 5.0000, 76050.00, 38025.00, 5.00, 38025.00, 5.00, 3802.50, 507.00, 80359.50, 1, 1, '2021-02-15 03:10:40', '2021-02-15 03:12:00'),
(7, '@399374', 'hello worrdd###$455--47567', '2021-02-15 16:34:43', 'helllo world', 'chthiiifffffrr--r4r45467', 'chthiiifffffrr--r4r45467', 'chthiiifffffrr--r4r45467', 'chthiiifffffrr--r4r45467', 'chthiiifffffrr--r4r45467', 'chthiiifffffrr--r4r45467', 'chthiiifffffrr--r4r45467', 1, '2021-02-15', '2021-02-15', 5000000.00, 10000, 'us', 84.50, 42672500000.00, 'chthiiifffffrr--r4r45467', 'chthiiifffffrr--r4r45467', '2021-02-15', 1, NULL, NULL, '0', '2021-02-15', '@#3849345457', 'hellow worferfr', 'chthiiifffffrr--r4r45467', 'chthiiifffffrr--r4r45467', '2021-02-15', 5.0000, 4267250000.00, 2133625000.00, 5.00, 2133625000.00, 20.00, 853450000.00, 28448333.33, 5149148333.33, 1, 0, '2021-02-15 04:34:43', '2021-02-15 04:34:43'),
(8, '@#9958565768', '@#99585657680000', '2021-02-15 16:44:47', 'hello world@#$%^^', 'hello world@#$%^^', 'hello world@#$%^^', 'hello world@#$%^^', 'hello world@#$%^^', 'hello world@#$%^^hello world@#$%^^', 'hello world@#$%^^', 'hello world@#$%^^', 1, '2021-02-16', '2021-02-16', 10000000.00, 499, 'us', 90.00, 5400000000.00, '@#$%%^slslsls', '2300000356', '2021-02-15', 0, 'hello world@#$%^^', 'hello world@#$%^^hello world@#$%^^', 'swur847#$%^^', '2021-02-09', '23$$%%helloworlr', 'hello worldkdjefrf', 'hello world@#$%^^hello world@#$%^^hello world@#$%^^hello world@#$%^^hello world@#$%^^', 'hello world@#$%^^hello world@#$%^^hello world@#$%^^hello world@#$%^^', '2021-02-15', 1000.0000, 108000000000.00, 54000000000.00, 1000.00, 54000000000.00, 1000.00, 1080000000000.00, 3600000.00, 1188003600000.00, 1, 0, '2021-02-15 04:44:47', '2021-02-15 04:44:47'),
(9, '@#$$$%%%^gdgf', '@#$$$%%%^gdgf', '2021-02-15 17:15:36', '@#$$$%%%^gdgf', '@#$$$%%%^gdgf', '@#$$$%%%^gdgf', '@#$$$%%%^gdgf', '@#$$$%%%^gdgf', '@#$$$%%%^gdgf@#$$$%%%^gdgf@#$$$%%%^gdgf@#$$$%%%^gdgf', '@#$$$%%%^gdgf', '@#$$$%%%^gdgf', 1, '2021-02-15', '2021-02-15', 50000.00, 100, 'us', 84.50, 8450000.00, 'sl@#$%', '#$%slls', '2021-02-15', 1, NULL, NULL, '0', '2021-02-15', '@#$$$%%%^gdgf', '@#$$$%%%^gdgf', '@#$$$%%%^gdgf@#$$$%%%^gdgf@#$$$%%%^gdgf@#$$$%%%^gdgf', '@#$$$%%%^gdgf', '2021-02-15', 400.0000, 118300000.00, 33800000.00, 1000.00, 84500000.00, 4900.00, 5796700000.00, 5633.33, 5915005633.33, 1, 0, '2021-02-15 05:15:36', '2021-02-15 05:15:36'),
(10, '456223@##$6:', '456223@##$6:456223@##$6:456223@##$6:', '2021-02-15 17:23:42', '456223@##$6:', '456223@##$6:456223@##$6:', '456223@##$6:', '456223@##$6:', '456223@##$6:', '456223@##$6:456223@##$6:', '456223@##$6:', '456223@##$6:', 1, '2021-02-15', '2021-02-15', 5000000.00, 8599, 'us', 90.60, 39406470000.00, '456223@##$6:', '456223@##$6:456223@##$6:', '2021-02-16', 1, NULL, NULL, '0', '2021-02-15', '456223@##$6:', '456223@##$6:', '456223@##$6:456223@##$6:456223@##$6:', '456223@##$6:456223@##$6:', '2021-02-16', 0.0000, 4998119622.45, 48666990.45, 12.56, 4949452632.00, 5.00, 118219410000.00, 26270980.00, 123243800602.45, 1, 0, '2021-02-15 05:23:42', '2021-02-15 05:23:42'),
(11, '%^&**-hello world', '%^&**-hello world', '2021-02-15 17:30:48', '%^&**-hello world', '%^&**-hello world', '%^&**-hello world', '%^&**-hello world', '%^&**-hello world%^&**-hello world', '%^&**-hello world%^&**-hello world', '%^&**-hello world', '%^&**-hello world', 1, '2021-02-16', '2021-02-16', 50000000.00, 200, 'us', 89.90, 13485000000.00, '%^&**-hello world', '%^&**-hello world', '2021-02-15', 1, NULL, NULL, '0', '2021-02-15', '45000', '%^&**-hello world', '%^&**-hello world%^&**-hello world', '%^&**-hello world', '2021-02-15', 67000.0000, 9040466443800.00, 9034950000000.00, 40.00, 5516443800.00, 9.91, 546569251.70, 8990000.00, 9041022003051.70, 2, 0, '2021-02-15 05:30:48', '2021-02-15 05:30:48'),
(12, '1111', '111', '2021-02-15 17:57:34', 'ff', 'f', 'fffferwer33', 'afwe', 'afas', '111', 'qwer', 'qwer', 1, '2021-02-15', '2021-02-17', 100.00, 10, 'us', 19.20, 2112.00, '111', '1111', '2021-02-09', 2, '111', '111', '0111', '2021-02-18', 'vf', 'f', '111', 'ff', '2021-02-21', 1.0000, 42.73, 21.12, 1.02, 21.61, 10.00, 4.27, 1.41, 48.41, 1, 0, '2021-02-15 05:57:34', '2021-02-15 05:57:34'),
(13, 'ICI/KTJ/MC-0057/02/2022', 'ICI/KTJ/MC-0057/02/2022', '2021-02-16 17:24:00', 'A/c. M/s. Saikat Traders.', '505/554,Middle Chaktai.', 'Bank Asia Ltd', 'Chattogram.', 'Khatungonj', 'Lentils.', 'Australia', 'Chattogram', 1, '2021-02-16', '2022-02-15', 324000.00, 1, 'us', 84.95, 27799038.00, '47005', '70', '2021-02-16', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799189', '2021-02-16', '0840', 'Mozammel', 'Notice of shipments failing within the Scope  of This Covernote are to be made as follows: \n(a) By the Insured: To the above issuing office of the Company at khatungonj Branch, Bank Asia Building ( 3rd Floor) 273/268, Khatungonj.', 'ICC\'C\' Risk only.', '2021-02-16', 0.0000, 361387.00, 83397.00, 1.00, 277990.00, 15.00, 54208.00, 18533.00, 434128.00, 2, 1, '2021-02-16 05:24:00', '2021-02-16 23:53:37'),
(14, '@##$644', '@34556', '2021-02-17 11:44:37', 'helloe', 'sjffg', 'asia', 'adrht', 'ctg,0f', 'hfhfhf', 'ctg', 'dha', 1, '2021-02-18', '2021-02-17', 1000.00, 1, 'us', 84.50, 85345.00, '2378566', '4u566', '2021-02-17', 2, 'crgtgt', 'hfhtgtg', '23000', '2021-02-17', '200', '47575', 'jhhfhfjf', '64456fgg', '2021-02-17', 5.0000, 8534.00, 4267.00, 5.00, 4267.00, 5.00, 427.00, 57.00, 9018.00, 1, 0, '2021-02-16 23:44:37', '2021-02-16 23:44:37'),
(15, 'hhh', 'uju', '2021-02-17 12:05:48', 'fff', 'ffdd', 'ddd', 'dee', 'dddd', 'dfd', 'deee', 'dddd', 1, '2021-02-17', '2021-02-17', 100.00, 10, 'us', 84.50, 9295.00, '2323', '2323', '2021-02-17', 2, 'dgdg', 'dgdg', '233', '2021-02-17', 'g33', '3ddv', 'gdgdg', 'sfsf', '2021-02-17', 12.0000, 1580.00, 1115.00, 5.00, 465.00, 5.00, 79.00, 6.00, 1665.00, 1, 0, '2021-02-17 00:05:48', '2021-02-17 00:05:48'),
(16, 'fgsfg', 'sfgsfg', '2021-02-17 12:25:00', 'sfgsfdg', 'sfgsdfg', 'sfdgsfd', 'gsfdgsfdg', 'gsfgs', 'twretwert', 'sfdgsfdg', 'sfdgsfdg', 1, '2021-02-17', '2021-02-17', 500.00, 10, 'us', 20.00, 11000.00, 's555', 'fgs5555', '2021-02-17', 2, 'sfgsfg', 'wertwert', '0wertwret', '2021-02-17', 'wretwre', 'wertwret', 'wretwert', 'wertwert', '2021-02-17', 1.0000, 110.00, 110.00, 0.00, 0.00, 15.00, 17.00, 7.00, 134.00, 2, 0, '2021-02-17 00:25:00', '2021-02-17 00:25:00'),
(17, 'ghdfghd', 'dfghdgh', '2021-02-17 13:10:42', 'dfghdfgh', 'dgfhdfgh', 'dgfhd', 'hdhgdfgh', 'dfghdfh', 'ertyery', 'dfghdhg', 'dfghdfgh', 1, '2021-02-17', '2021-02-17', 100.00, 0, 'us', 522.00, 52200.00, '65656', '5656', '2021-02-17', 2, 'teye', 'etryerty', '0tyety', '2021-02-17', 'ertyety', 'ertyety', 'etryety', 'ertyerty', '2021-02-17', 1.0000, 522.00, 522.00, 0.00, 0.00, 15.00, 78.00, 0.00, 600.00, 2, 0, '2021-02-17 01:10:42', '2021-02-17 01:10:42'),
(18, 'ajsfjask', 'jajsdfkj', '2021-02-17 13:13:04', 'asfa', 'asdfa', 'afsaf', 'sasfda', 'asdfa', 'jkjkasd', 'adsf', 'sdg', 1, '2021-02-01', '2022-02-01', 100.00, 0, 'us', 8.00, 800.00, 'dfa', 'adfa', '2021-02-01', 2, 'asdfa', 'dfafa', '112', '2021-02-01', '21212a', 'asdfa2', 'jakjsdfk', 'adfa', '2021-02-01', 2.0000, 16.00, 16.00, 0.00, 0.00, 15.00, 2.00, 1.00, 19.00, 2, 0, '2021-02-17 01:13:04', '2021-02-17 01:13:04'),
(19, 'hjhjh', 'hjhj', '2021-02-17 13:20:36', 'jkjlkjf', 'jakljsfk', 'jalkjsfdk', 'jakljsfdk', 'jalkjskf', 'aklsglaf', 'jakljsdfkj', 'jkalkjsfdk', 1, '2021-02-01', '2022-02-01', 1000000.00, 0, 'us', 7.00, 7000000.00, '1212', '1212', '2021-02-01', 1, NULL, NULL, '0', '2021-02-01', 'klkl', 'jkjk', 'no', 'jkjkj', '2021-02-01', 11.0000, 770000.00, 770000.00, 0.00, 0.00, 15.00, 115500.00, 1.00, 885501.00, 2, 1, '2021-02-17 01:20:36', '2021-02-17 03:38:33'),
(20, '@2030', '@3040', '2021-02-17 17:01:46', 'tayroll otwell', 'chittagong', 'brac bank limited', 'agrabaad,chittagong', 'agrabaad,branch', 'no', 'chittagong', 'dhaka', 1, '2021-02-17', '2021-02-17', 5000.00, 0, 'us', 85.00, 425000.00, 'no23', '3rrsl', '2021-02-17', 1, NULL, NULL, '0', '2021-02-17', '23', 'don33', 'none', 'done', '2021-02-17', 5.0000, 21250.00, 21250.00, 0.00, 0.00, NULL, 0.00, 283.00, 21533.00, 1, 0, '2021-02-17 05:01:46', '2021-02-17 05:01:46'),
(21, '@##dhdhd', '@##dhdhd', '2021-02-18 10:42:26', 'hellee', 'rtth', 'dfrggr', 'fefe', 'wfef', 'done', 'china', 'dhaka', 1, '2021-02-19', '2021-02-17', 5000.00, 84, 'us', 84.50, 777400.00, 'r455', '455t', '2021-02-17', 1, NULL, NULL, '0', '2021-02-18', '2300', 'hello', 'done', 'done', '2021-02-18', 5.0000, 474214.00, 38870.00, 56.00, 435344.00, 5.00, 23711.00, 518.00, 498443.00, 1, 0, '2021-02-17 22:42:26', '2021-02-17 22:42:26'),
(22, 'kflakf', 'kla;klfk', '2021-02-18 11:13:52', 'asga', 'safa', 'jkhhhj', 'hjhj', 'hjhjh', '511', 'jhjh', 'jhjhj', 1, '2021-02-01', '2021-02-01', 5000011.00, 10, 'us', 5.00, 27500061.00, '4545', '4545', '2021-02-01', 2, 'hjhjh', 'hjhj', '15515', '2021-02-01', '9898', '8989', 'dgsgf', 'sgsfdg', '2021-02-01', 1.0000, 275001.00, 275001.00, 0.00, 0.00, 15.00, 41250.00, 2.00, 316253.00, 2, 0, '2021-02-17 23:13:52', '2021-02-17 23:13:52'),
(23, '@#40093', '@#0984', '2021-02-18 11:43:06', 'test', 'test', 'test', 'test', 'test', 'done', 'test', 'test', 1, '2021-02-18', '2021-02-18', 5000.00, 600, 'us', 84.00, 2940000.00, '3400', '@300344', '2021-02-18', 1, NULL, NULL, '0', '2021-02-18', '3', '344', 'done', '3', '2021-02-18', 4.0000, 235200.00, 117600.00, 4.00, 117600.00, 4.00, 9408.00, 1960.00, 246568.00, 1, 0, '2021-02-17 23:43:06', '2021-02-17 23:43:06'),
(24, '@#0093', '@#0093', '2021-02-18 11:46:02', 'hello', 'hello', 'hello', 'hello', 'hello', 'done', 'china', 'dhaka', 1, '2021-02-18', '2021-02-18', 500.00, 8, 'us', 84.00, 45360.00, '2300', '2300', '2021-02-18', 1, NULL, NULL, '0', '2021-02-18', '23', 'hello', 'ok', 'nione', '2021-02-18', 4.0000, 1814.00, 1814.00, 0.00, 0.00, NULL, 0.00, 30.00, 1844.00, 1, 0, '2021-02-17 23:46:02', '2021-02-17 23:46:02'),
(25, '@3done', '@444485', '2021-02-18 11:49:19', 'hello', 'hello', 'hello', 'hello', 'hello', 'done', 'hello', 'hello', 1, '2021-02-19', '2021-02-19', 500.00, 3, 'us', 84.00, 43260.00, '@#00', '@#00', '2021-02-18', 1, NULL, NULL, '0', '2021-02-18', '2300', '3455', 'done', 'done', '2021-02-18', 4.0000, 3893.00, 1730.00, 5.00, 2163.00, 4.00, 156.00, 28.00, 4077.00, 1, 0, '2021-02-17 23:49:19', '2021-02-17 23:49:19'),
(26, 'll', 'LL', '2021-02-18 12:29:25', 'JJ', 'JJ', 'KK', 'II', 'LL', 'OO', 'LL', 'KK', 1, '2021-02-17', '2022-02-16', 50000.00, NULL, 'us', 8.00, 400000.00, '4545', '122', '2021-02-17', 3, 'IIO', 'KL', '7799', '2021-02-17', '0840', 'M', 'NON', 'II', '2021-02-18', 0.0000, 1200.00, 1200.00, 0.00, 0.00, 15.00, 180.00, 267.00, 1647.00, 2, 0, '2021-02-18 00:29:25', '2021-02-18 00:29:25'),
(27, 'ICI/KTJ/MC-0045/02/2021', 'ICI/KTJ/MC-0045/02/2021', '2021-02-18 12:45:08', 'A/c. M/s. Saikat Traders', '505/554, Middle Chaktai.', 'Bank Asia Ltd', 'Chattogram.', 'Khatungonj Branch', 'Chickpeas', 'Australia', 'Chattogram', 1, '2021-02-02', '2022-02-01', 147600.00, NULL, 'us', 84.95, 12538620.00, '47002', '51', '2021-02-02', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799190', '2021-02-02', '0840', 'Mozammel', 'no', 'ICC\'C\' Risk only.', '2021-02-02', 0.0000, 37616.00, 37616.00, 0.00, 0.00, 15.00, 5642.00, 8325.00, 51583.00, 2, 0, '2021-02-18 00:45:08', '2021-02-18 00:45:08'),
(28, '@300r8tr', 'test@#$56', '2021-02-18 13:35:56', 'test', 'test1', 'test1', 'test1', 'test1', NULL, 'test1', 'test1', 1, '2021-02-19', '2021-02-19', 500.00, NULL, 'us', 84.00, 42000.00, 'test1', 'test1', '2021-02-19', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-19', 5.0000, 2100.00, 2100.00, 0.00, 0.00, NULL, 0.00, 28.00, 2128.00, 1, 0, '2021-02-18 01:35:56', '2021-02-18 01:35:56'),
(29, '34678', '34678', '2021-02-18 13:37:53', 'done', 'done', 'done', 'e', 'e', NULL, 'e', 'e', 1, '2021-02-19', '2021-02-19', 500.00, NULL, 'us', 85.09, 42545.00, '34556', '45566', '2021-02-19', 1, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, '2021-02-18', 5.0000, 2127.00, 2127.00, 0.00, 0.00, NULL, 0.00, 28.00, 2155.00, 1, 0, '2021-02-18 01:37:53', '2021-02-18 01:37:53'),
(30, '757866', '4567', '2021-02-18 14:08:57', 'hello', 'frtt', 'ffh', '456', 'rrt', NULL, '55', '55', 1, '2021-02-19', '2021-02-16', 500.00, NULL, 'us', 56.00, 28000.00, 'r5567', '778', '2021-02-20', 2, 'helloe', 'rrrr', 'hhfur555', '2021-02-19', NULL, NULL, NULL, NULL, '2021-02-19', 45.0000, 12600.00, 12600.00, 0.00, 0.00, NULL, 0.00, 19.00, 12619.00, 1, 1, '2021-02-18 02:08:57', '2021-02-18 08:20:31'),
(31, '@#09556', '@30947854', '2021-02-18 14:22:23', 'done', 'done', 'done', 'ctg', 'ctg', NULL, 'ctg', 'dha', 1, '2021-02-19', '2021-02-19', 500.00, NULL, 'us', 87.90, 43950.00, '23400', '45789', '2021-02-19', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-19', 6.0000, 2637.00, 2637.00, 0.00, 0.00, NULL, 0.00, 29.00, 2666.00, 1, 0, '2021-02-18 08:22:23', '2021-02-18 08:22:23'),
(32, 'ICI/KTJ/MC-043/02/2021', 'ICI/KTJ/MC-043/02/2021', '2021-02-24 14:02:48', 'A/c. M/s. M.R Trading', '5,Moulvi Bazar, Dhaka, Bangladesh.', 'Mercantile Bank LTd', 'Dhaka', 'Nayabazar Branch', 'Apple', 'China', 'Chattogram', 1, '2021-02-24', '2022-02-23', 23720.00, 0, 'us', 84.95, 2015014.00, '47006', '49', '2021-02-24', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799180', '2021-02-24', '0840', 'Mozammel', 'non', 'ICC\'C\' Risk only.', '2021-02-24', 0.0000, 6045.00, 6045.00, 0.00, 0.00, 15.00, 907.00, 1343.00, 8295.00, 2, 0, '2021-02-24 08:02:48', '2021-02-24 08:02:48'),
(33, 'JH\'KKJJ\'LKK; 24.02.2021', 'JH\'KKJJ\'LKK; 24.02.2021', '2021-02-24 15:01:31', 'Hotel Ocean Friend', 'Khatungange, Chattogram', 'Bank Asia Limited', 'Khatungange, Chattogram', 'Khatungange, Chattogram', 'Yes, No, ICC\'FLL', 'Austrilia', 'Chattogram', 1, '2021-02-24', '2021-02-24', 500000.00, 10, 'us', 84.50, 46475000.00, 'BL-2155', 'PLC: 2021', '2021-02-24', 2, 'Dhaka Bank Limited', 'Jubli Road, Chattogram', '25485', '2021-02-28', '1254', 'Test', 'Finish Goods,', 'ICC\'HGTT\'KJI\'GFTR\'KJHH', '2021-02-24', 0.0000, 1136314.00, 109216.00, 2.21, 1027098.00, 15.00, 170447.00, 30983.00, 1337744.00, 2, 0, '2021-02-24 09:01:31', '2021-02-24 09:01:31'),
(34, 'ICI/KTJ/MC-0043/02/2021', 'ICI/KTJ/MC-0043/02/2021', '2021-02-24 15:27:01', 'A/C. M/S. M.R Trading', 'Moulovi Bazar, Dhaka.', 'Mercantile Bank Limited', 'Dhaka', 'Noyabazar, Branch.', 'Apple', 'Chaina', 'Chattogram', 1, '2021-02-24', '2022-02-23', 23720.00, NULL, 'us', 84.95, 2015014.00, '47006', '49', '2021-02-24', 3, 'Social Islami Bank Limited', 'Dwanhat Branch', '7799180', '2021-02-24', '0840', 'Mojammel', NULL, 'ICIC\' War & SRCC Risk Only', '2021-02-24', 0.0000, 7053.00, 6045.00, 0.05, 1008.00, 15.00, 1058.00, 1343.00, 9454.00, 2, 0, '2021-02-24 09:27:01', '2021-02-24 09:27:01'),
(35, 'testing@#000', 'testing@#000', '2021-02-25 17:43:33', 'testing', '11/11 Jobeda Villa, Panchlaish, Chittagong, Bangladesh', 'jamuna bank limited', 'gec circle , chittagong bangladesh  .. .. .. ..', 'gec, branch', 'doneee', 'china', 'chittagong', 1, '2021-02-25', '2021-02-26', 5000.00, 56, 'us', 84.50, 659100.00, '3400', '2300', '2021-02-24', 1, NULL, NULL, '0', NULL, '23000', '3000', 'done', 'n\\a', '2021-02-25', 0.4300, 3164.00, 2834.00, 0.05, 330.00, 5.00, 158.00, 282.00, 3604.00, 1, 1, '2021-02-25 11:43:33', '2021-02-25 13:08:14'),
(36, 'ICI/KTJ/MC-0057/02/2021', 'ICI/KTJ/MC-0057/02/2021', '2021-02-25 20:47:11', 'A/c. M/s. Saikat Traders', '505/554, Middle Chaktai.', 'Bank Asia Ltd', 'Chattogram', 'Khatungonj Branch', 'Lentils.', 'Australia', 'Chattogram', 1, '2021-02-17', '2022-02-16', 224000.00, 0, 'us', 84.95, 19028800.00, '47007', '70', '2021-02-17', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799180', '2021-02-17', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk only.', '2021-02-17', 0.3000, 57086.00, 57086.00, 0.00, 0.00, 15.00, 8563.00, 12686.00, 78335.00, 2, 0, '2021-02-25 14:47:11', '2021-02-25 14:47:11'),
(37, '$%^&&3000', '$%^&&3000', '2021-02-27 15:08:03', 'test', 'jobeda vila 23900', 'asia', 'gec', 'gec', 'done', 'china', 'chittagong', 1, '2021-02-25', '2021-02-26', 5000.00, 10, 'us', 84.50, 464750.00, '2300', '3400', '2021-02-27', 1, NULL, NULL, '0', NULL, '2300', '23004', 'done', 'none', '2021-02-26', 4.0000, 18590.00, 18590.00, NULL, 0.00, 4.00, 744.00, 296.00, 19630.00, 1, 2, '2021-02-27 09:08:03', '2021-03-01 12:40:04'),
(38, 'ICI/KTJ/MC-0074/01/2021', 'ICI/KTJ/MC-0074/01/2021', '2021-02-28 17:20:19', 'A/c. M/s. T. N Trading', '222, Khatungonj', 'Bank Asia', 'Chattogram', 'Khatungonj Branch', 'Lentils.', 'Australia', 'Chattogram', 1, '2021-02-28', '2022-02-27', 165000.00, 0, 'us', 84.95, 14016750.00, '47007', '90', '2021-02-28', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799180', '2021-02-28', '0840', 'Mozammel', 'none', 'ICC\'C\' Risk Only.', '2021-02-28', 0.3000, 42050.00, 42050.00, NULL, 0.00, 15.00, 6308.00, 9345.00, 57703.00, 2, 0, '2021-02-28 11:20:19', '2021-02-28 11:20:19'),
(39, 'ICIB/BLL/KJJ:01/03/2021', 'ICIB/BLL/KJJ:01/03/2021', '2021-03-01 16:41:02', 'Zaif International Limited.', 'Muradpur, Chattagram.', 'Dhaka Bank Limited', 'Muradpur, Cgattogam', 'Muradpur Branch,', 'Apple, Orange, Mango', 'Chaina', 'Chattogram', 1, '2021-03-01', '2022-03-01', 500000.00, 10, 'us', 84.50, 46475000.00, '59', 'R: 8765', '2021-03-01', 3, 'Bank Asia Limited', 'Muradpur, Chattogram.', '251346', '2021-03-01', 'R25144', 'Mojammel', 'Frutes', 'ICCL\'JHHI\'LKOP\'JHS', '2021-03-01', 0.3000, 162663.00, 139425.00, 0.05, 23238.00, 15.00, 24399.00, 30983.00, 218045.00, 2, 2, '2021-03-01 10:41:02', '2021-03-01 11:05:54'),
(40, 'ICI/KTJ/MC-70/02/2021', 'ICI/KTJ/MC-70/02/2021', '2021-03-02 16:44:08', 'A/c. M/s. Abrar Trading', '950/B, Yakub Building', 'Uttara Bank Ltd', 'Chattogram', 'khatungonj Branch', 'Tamarind Seeds', 'Thailand', 'Chattogram', 1, '2021-03-02', '2021-03-01', 11000.00, 0, 'us', 84.95, 934450.00, '45095', '85', '2021-03-02', 2, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799190', '2021-03-02', '0840', 'Mozammel', 'Non', 'ICC\'C\' Risk only.', '2021-03-02', 0.3000, 2803.00, 2803.00, NULL, 0.00, 15.00, 420.00, 623.00, 3846.00, 2, 0, '2021-03-02 10:44:08', '2021-03-02 10:44:08'),
(41, 'ICI/KTJ/MC-0040/02/2021', 'ICI/KTJ/MC-0040/02/2021', '2021-03-06 15:51:02', 'A/c. M/s. Abrar Trading.', '950/B,Yakub Building(1st Floor),Khatungonj.', 'Uttara Bank Ltd.', 'Chattogram.', 'Khatungonj.', 'Tabu Powder', 'Vietnam', 'Chattogram.', 1, '2021-02-06', '2022-02-05', 31680.00, NULL, 'us', 84.95, 2691216.00, '47008', '45', '2021-02-06', 3, 'Social islami Bank Ltd', 'Dewanhat Branch.', '7799180', '2021-02-06', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk Only.', '2021-02-06', 0.3000, 8074.00, 8074.00, NULL, 0.00, 15.00, 1211.00, 1794.00, 11079.00, 2, 0, '2021-03-06 09:51:02', '2021-03-06 09:51:02'),
(42, 'ICI/KTJ/MC-00/03/2021', 'ICI/KTJ/MC-00/03/2021', '2021-03-07 15:42:28', 'A/c. M/s. Mozammel Store', '505, Khatungonj', 'Bank Asia', 'Chattogram', 'Khatungonj Branch', 'Lentils', 'China', 'Ctg', 2, '2021-03-07', '2022-03-06', 50000.00, 10, 'us', 84.95, 4672250.00, '4500', '100', '2021-03-07', 1, NULL, NULL, '0', NULL, '0840', 'Mozammel', 'None', 'ICC\'C\' War & Srcc Risk only.', '2021-03-07', 0.3000, 16353.00, 14017.00, 0.05, 2336.00, 15.00, 2453.00, 50.00, 18856.00, 2, 0, '2021-03-07 09:42:28', '2021-03-07 09:42:28'),
(43, 'ICI/KTJ/MC-0083/03/2021', 'ICI/KTJ/MC-0083/03/2021', '2021-03-08 12:54:07', 'A/c. Ms. Iqbal Trading', '147,Chan Meah Lane, Khatungonj,Chattogram.', 'Uttara Bank Ltd', 'Chattogram.', 'Khatungonj Branch', 'Tabu Powder', 'Australia', 'Chattogram', 1, '2021-03-08', '2022-03-07', 46339.80, 10, 'us', 84.95, 4330223.00, '47009', '102', '2021-03-08', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799167', '2021-03-08', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk only.', '2021-03-08', 0.3000, 12991.00, 12991.00, NULL, 0.00, 15.00, 1949.00, 2887.00, 17827.00, 2, 2, '2021-03-08 06:54:07', '2021-03-08 12:01:42'),
(44, 'ICI/KTJ/MC-0090/03/2021', 'ICI/KTJ/MC-0090/03/2021', '2021-03-10 15:21:52', 'A/c. M/s. Shajahan Coth Store', '271/268, khatungonj', 'Bank Asia Ltd', 'Chattogram.', 'Khatungonj', 'Ginger', 'China', 'Chattogram', 1, '2021-03-10', '2022-03-09', 10000.00, 10, 'us', 84.95, 934450.00, '4500', '115', '2021-03-10', 1, NULL, NULL, '0', NULL, '0840', 'Mozammel', 'None', 'ICC\'C\' Risk only.', '2021-03-10', 0.3000, 2803.00, 2803.00, NULL, 0.00, 15.00, 420.00, 623.00, 3846.00, 2, 0, '2021-03-10 09:21:52', '2021-03-10 09:21:52'),
(45, 'ICI/KTJ/MC-0086/03/2021', 'ICI/KTJ/MC-0086/03/2021', '2021-03-13 15:29:16', 'A/C.M/S. SAJIB INTERNATIONL,JAHAN Chamber,room no-15,2748 HALISHAHIR Road, chowmuuuhoni,chattogram.', 'A/C.M/S. SAJIB INTERNATIONL,JAHAN Chamber,room no-15,2748 HALISHAHIR Road, chowmuuuhoni,chattogram.', 'Union Bank ltd.', 'chattogram', 'khatungongj', 'Tamarind seeds H S Code:1211.9099', 'Any port Inda', 'Benapole port', 2, '2021-03-13', '2022-03-12', 6600.00, 10, 'us', 84.95, 616737.00, '2012', '012', '2021-03-13', 3, 'social islami Bank  Ltd', 'Dewanhat Branch', '13231', '2021-03-13', '0840', 'mozammel hossin', 'none', 'LORRY RISK ONLY', '2021-03-13', 0.4300, 2652.00, 2652.00, NULL, 0.00, 15.00, 398.00, 50.00, 3100.00, 2, 0, '2021-03-13 09:29:16', '2021-03-13 09:29:16'),
(46, 'ICI/KTJ/MC-86/03/2021', 'ICI/KTJ/MC-86/03/2021', '2021-03-13 16:00:25', 'TN trading', 'TN trading', 'BAMKASIA', 'Chattogram', 'katungonj', 'APPLE', 'China', 'Chattoram', 1, '2021-03-13', '2022-03-12', 22000.00, 10, 'us', 84.95, 2055790.00, '1212', '003.', '2021-03-13', 3, 'social bank', 'khatuingonj', '0', '2021-03-13', '0840', NULL, 'none', 'ICC`C`RISK ONLY', '2021-03-13', 0.3000, 6167.00, 6167.00, NULL, 0.00, 15.00, 925.00, 1371.00, 8463.00, 2, 0, '2021-03-13 10:00:25', '2021-03-13 10:00:25'),
(47, 'ICI/KTJ/MC-87/03/2021', 'ICI/KTJ/MC-87/03/2021', '2021-03-13 16:28:56', 'TN TRADING', 'BANGLADESH', 'BANK ASIA', 'CHATTAGORAM', 'KHATUNGONJ', 'APPLE', 'CHINA', 'CHATTAGORAM', 1, '2021-03-13', '2022-03-12', 23720.00, 0, 'us', 84.95, 2015014.00, '2222', '002', '2021-03-13', 3, 'SOCIAL BAQNK', 'DEWNHAT', '622222', '2021-03-13', '0840', 'MOZAMMEL', 'NONE', 'ICCC RISK ONLY', '2021-03-13', 0.3000, 6045.00, 6045.00, NULL, 0.00, 15.00, 907.00, 1343.00, 8295.00, 2, 0, '2021-03-13 10:28:56', '2021-03-13 10:28:56'),
(48, 'ICI/KTJ/MC-95/03/2021', 'ICI/KTJ/MC-95/03/2021', '2021-03-14 12:44:19', 'A/c. M/s. AC BAZAR INDUSTRIES LTD.', 'Office Address: 24 M M Ali Road, Lalkhan Bazar,Chattogram.', 'Uttara Bank Ltd,', 'Chattogram.', 'Khatungonj Branch,', 'Parts and Components for Air Conditioner Mfg.Ind,HS Code: 8415.90.91,4819.10.00', 'China', 'Chattogram', 1, '2021-03-11', '2022-03-10', 42550.00, 10, 'us', 84.95, 3976085.00, '47012', '120', '2021-03-11', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799195', '2021-03-11', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk only.', '2021-03-14', 0.3000, 11928.00, 11928.00, NULL, 0.00, 15.00, 1789.00, 2651.00, 16368.00, 2, 0, '2021-03-14 06:44:19', '2021-03-14 06:44:19'),
(49, 'ICI/KTJ/MC-100/003/2021', 'ICI/KTJ/MC-100/03/2021', '2021-03-14 19:26:12', 'TN TRADING', 'CHIKTI', 'Bank Asia', 'Chattogarm', 'Khatungonj', 'GOODS', 'china', 'Chattogarm', 1, '2021-03-14', '2022-03-13', 324000.00, 0, 'us', 84.95, 27523800.00, '370317', '107', '2021-03-14', 1, 'socil Islami Bank', 'Dewanhat', '7799189', '2021-03-14', '0840', 'MOZAMML', 'none', 'ICCC RISK ONLY', '2021-03-14', 0.3000, 82571.00, 82571.00, NULL, 0.00, 15.00, 12386.00, 18349.00, 113306.00, 2, 2, '2021-03-14 13:26:12', '2021-03-14 13:45:04'),
(50, 'ICI/KTJ/MC-99/03/20021', 'ICI/KTJ/MC-99/03/20021', '2021-03-15 13:55:52', 'SHAJHAN TRADING', 'bangladesh', 'BANK ASIA', 'CHATTOGRAM', 'KHATUNGONJ', 'GOODS', 'CHINA', 'CHATTOGRAM', 1, '2021-03-15', '2022-03-14', 324000.00, 0, 'us', 84.95, 27523800.00, '45127', '107', '2021-03-15', 3, 'Social islami bank', 'Dewanhat', '7766180', '2021-03-15', '0840', 'mozammel', 'none', 'ICCC RISK ONLY', '2021-03-15', 0.3000, 82571.00, 82571.00, NULL, 0.00, 15.00, 12386.00, 18349.00, 113306.00, 2, 0, '2021-03-15 07:55:52', '2021-03-15 07:55:52'),
(51, 'ICI/KTJ/MC-91/03/2021', 'ICI/KTJ/MC-91/03/2021', '2021-03-15 14:08:14', 'SSHAJHAN TRADING', 'FOH', 'BANK ASSIA', 'CHTTOGRAM', 'KHATUNGONJ', 'TABU POWDER', 'INDA', 'CHTTOGRAM', 1, '2021-03-15', '2022-03-14', 324000.00, 0, 'us', 84.95, 27523800.00, '45127', '15', '2021-03-15', 3, 'SOCIAL ISLAMI BANK', 'DEWANHAT', '120231', '2021-02-15', '0840', 'MOZAMMEL', 'NONE', 'ICCC RISK ONLY', '2021-03-15', 0.3000, 82571.00, 82571.00, NULL, 0.00, 15.00, 12386.00, 18349.00, 113306.00, 2, 0, '2021-03-15 08:08:14', '2021-03-15 08:08:14'),
(52, 'ICI/KTJ/MC-106/03/2021', 'ICI/KTJ/MC-106/03/2021', '2021-03-16 13:38:03', 'M/S Chwdhury Enterprise', '248,kHATUNGONJ(1st fioor)Chattogram', 'Trust Bank', 'Chattogram', 'Khatungonj', 'CUMIN SEED', 'ANY PORT OF INDIA', 'HILLI', 2, '2021-03-16', '2022-03-15', 46250.00, 10, 'us', 84.95, 4321831.00, '47013', '130', '2021-03-16', 3, 'socil islami bank', 'Dewanhat Branch', '7799183', '2021-03-16', '0840', 'MOZAMMEL', 'NONE', 'LORRY RISK ONLY', '2021-03-16', 0.4300, 18584.00, 18584.00, NULL, 0.00, 15.00, 2788.00, 50.00, 21422.00, 2, 0, '2021-03-16 07:38:03', '2021-03-16 07:38:03'),
(53, 'ICI/KTJ/MC-0116/03/2021', 'ICI/KTJ/MC-0116/03/2021', '2021-03-23 14:16:46', 'H.N Enterprise', '1079 No. Amanat Khan Road, khan Bari. Patantuli, Chattogram.', 'Exim Bank Ltd', 'Chattogram', 'Jubilee Road Branch', 'PVC THREAD FITTINGS PIPE.GREEN & WHITE COLOUR.', 'China', 'Chattogram', 1, '2021-03-23', '2022-03-22', 18498.41, 10, 'us', 84.95, 1728584.00, '47012', '143', '2021-03-23', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799160', '2021-03-23', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk only.', '2021-03-23', 0.3000, 5186.00, 5186.00, NULL, 0.00, 15.00, 778.00, 1152.00, 7116.00, 2, 0, '2021-03-23 08:16:46', '2021-03-23 08:16:46'),
(54, 'ICI/KTJ/MC-0118/03/2021', 'ICI/KTJ/MC-0118/03/2021', '2021-03-24 11:50:05', 'A/c. M/s. Modern Footwear Industries.', 'Raj Hotel Ltd,(5th Floor),154, Kabi Nazrul Islam Road,Chattogram.-4000 Bangladesh.', 'United Commercial Bank Limited.', 'Chattogram.', 'Jubilee Road Branch.', 'Parts of Plastic Footwear (Outer Sole of Slipper)', 'China', 'Chattogram', 1, '2021-03-24', '2022-03-23', 81000.00, 10, 'us', 84.95, 7569045.00, '47020', '147', '2021-03-24', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799160', '2021-03-24', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk only.', '2021-03-24', 0.3000, 22707.00, 22707.00, NULL, 0.00, 15.00, 3406.00, 5046.00, 31159.00, 2, 2, '2021-03-24 05:50:05', '2021-03-24 06:22:01'),
(55, 'ICI/KTJ/MC-0119/03/2021', 'ICI/KTJ/MC-0119/03/2021', '2021-03-24 12:38:02', 'A/c.M/s. Modern Footwear Industries.', 'Raj Hotel (5th Floor),154,Kabi Nazrul Islam Road,Chattogram-4000 Bangladesh.', 'United Commercial Bank Ltd.', 'Chattogram.', 'Jubilee Road Branch.', 'Parts of Plastic Footwear( Pvc Upper of Slipper)', 'China', 'Chattogram', 1, '2021-03-24', '2022-03-23', 22500.00, 10, 'us', 84.95, 2102513.00, '47022', '148', '2021-03-24', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799160', '2021-03-24', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk only.', '2021-03-24', 0.3000, 6308.00, 6308.00, NULL, 0.00, 15.00, 946.00, 1402.00, 8656.00, 2, 2, '2021-03-24 06:38:02', '2021-03-24 06:54:59'),
(56, 'ICI/KTJ/MC-0120/03/2021', 'ICI/KTJ/MC-0120/03/2021', '2021-03-24 13:39:40', 'A/c. M/s. N.S. FRUITS INTERNATIONAL.', 'Railway Mens Super Market 16, Station Road,Chattogram,Bangladesh.', 'United Commercial Bank Limited.', 'Chattogram.', 'Station Road Branch.', 'FRESH APPLES.', 'BRAZIL', 'Chattogram.', 1, '2021-03-24', '2022-03-23', 105840.00, 10, 'us', 84.95, 9890219.00, '47023', '149', '2021-03-24', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799169', '2021-03-24', '0840', 'Mozammel', 'nOne', 'ICC\"C\' Risk only.', '2021-03-24', 0.3000, 29671.00, 29671.00, NULL, 0.00, 15.00, 4451.00, 6593.00, 40715.00, 2, 0, '2021-03-24 07:39:40', '2021-03-24 07:39:40'),
(57, 'ICI/KTJ/MC-0121/03/2021', 'ICI/KTJ/MC-0121/03/2021', '2021-03-25 10:21:07', 'A/C. M/S. THE PILAGE ENTERPRISE.', '401/09 Eklas Market Khatungonj,Chattogram,Bangladesh.', 'National Bank Limited.', 'Chattogram.', 'Khatungonj Branch.', 'Soda Ash Light.', 'Poland', 'Chattogram.', 1, '2021-03-25', '2022-03-24', 52013.00, 10, 'us', 84.95, 4860355.00, '47024', '150', '2021-03-25', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch.', '7799169', '2021-03-25', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk only.', '2021-03-25', 0.3000, 14581.00, 14581.00, NULL, 0.00, 15.00, 2187.00, 3240.00, 20008.00, 2, 0, '2021-03-25 04:21:07', '2021-03-25 04:21:07'),
(58, 'ICI/KTJ/MC-0125/03/2021', 'ICI/KTJ/MC-0125/03/2021', '2021-03-29 16:24:15', 'A/c. M/s. A NABI AND SONS.', '404-A, KAPURIA PARA, NOZIR VANDAR LANE,PATANTULI,CHATTOGRAM,BANGLADESH.', 'United Commercial Bank Limited,', 'Chattogram.', 'Enayet Bazar Branch.', 'J.I. PIPE FITTINGS( In Export Standard packing)', 'China', 'Chattogram.', 1, '2021-03-29', '2022-03-28', 37883.52, 10, 'us', 84.95, 3540026.00, '47025', '160', '2021-03-29', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799160', '2021-03-29', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk only.', '2021-03-29', 0.3000, 10620.00, 10620.00, NULL, 0.00, 15.00, 1593.00, 2360.00, 14573.00, 2, 0, '2021-03-29 10:24:15', '2021-03-29 10:24:15'),
(59, 'ICI/KTJ/MC-0126/03/2021', 'ICI/KTJ/MC-0126/03/2021', '2021-03-29 16:36:51', 'A/c. M/s. A.R  FOOTWEAR', '154 Kazi Nazrul Islam Road,(5th Floor), Raz Hotel, Sadarghat, Chattogram.', 'Islami Bank Bangladesh Ltd', 'Chattogram.', 'Station Road Branch', '1) Raw Materials Of Plastic Footwear 2) Outer Sole Of Plastic Slipper.', 'China', 'Chattogram.', 1, '2021-03-29', '2022-03-28', 29310.00, 10, 'us', 84.95, 2738873.00, '47026', '161', '2021-03-29', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799169', '2021-03-29', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk only.', '2021-03-29', 0.3000, 8217.00, 8217.00, NULL, 0.00, 15.00, 1233.00, 1826.00, 11276.00, 2, 2, '2021-03-29 10:36:51', '2021-03-29 10:38:13'),
(60, 'ICI/KTJ/MC-0127/03/2021', 'ICI/KTJ/MC-0127/03/2021', '2021-03-29 16:49:33', 'A/c. M/s. A.R FOOTWEAR,', '154 Kazi Nazrul Islam Road,( 5th Floor), Raz Hotel, Sadarghat, Chattogram.', 'Islami Bank Bangladesh Ltd,', 'Chattogram.', 'Station Road Branch.', '1) Raw Materials Of Plastic Footwear 2) Upper Of Plastic Slipper.', 'China', 'Chattogram.', 1, '2021-03-29', '2022-03-28', 7500.00, 10, 'us', 84.95, 700838.00, '47028', '162', '2021-03-29', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch.', '7799170', '2021-03-29', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk Only.', '2021-03-29', 0.3000, 2103.00, 2103.00, NULL, 0.00, 15.00, 315.00, 467.00, 2885.00, 2, 2, '2021-03-29 10:49:33', '2021-03-29 10:52:14'),
(61, 'ICI/KTJ/MC-0131/04/2021', 'ICI/KTJ/MC-0131/04/2021', '2021-04-04 17:27:01', 'A/c. M/s. The Need Apparels( Pvt). Ltd.', '154/c Rajakhali Road, East Bakalia,Chattogram,Bangladesh.', 'NRB Bank Limited.', 'Chattogram.', 'Agrabad Branch', 'Jack Brand New Capital Machinery For 100% Export Oriented Readymade Garments Industry.H.S.Code:8452.21.00 & 8451.50.00', 'Ningbo, China', 'Chattogram.', 1, '2021-04-04', '2022-04-03', 195794.00, 10, 'us', 84.95, 18295970.00, '47029', '167', '2021-04-04', 3, 'Social Islami Bank Ltd', 'Dewanhat Branch', '7799160', '2021-04-04', '0840', 'Mozammel', 'None', 'ICC\'C\' Risk only.', '2021-04-04', 0.1400, 25614.00, 25614.00, NULL, 0.00, NULL, 0.00, 12197.00, 37811.00, 2, 0, '2021-04-04 11:27:01', '2021-04-04 11:27:01');

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

--
-- 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` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `marine_policies`
--

CREATE TABLE `marine_policies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cn_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `policy_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `transit` tinyint(4) NOT NULL COMMENT 'stream = 1 value = 1500,otherwise lory = 2 value = 50 	',
  `vessel` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bl` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bl_date` date NOT NULL,
  `sl_date` date NOT NULL,
  `lc_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lc_date` date NOT NULL,
  `inv_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inv_date` date DEFAULT NULL,
  `bundle_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `clause` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clauses_endorsements_special_condition` text COLLATE utf8mb4_unicode_ci,
  `chalan_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `chalan_date` date DEFAULT NULL,
  `post_by` int(11) NOT NULL DEFAULT '0',
  `updated_by` int(11) 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 `marine_policies`
--

INSERT INTO `marine_policies` (`id`, `cn_no`, `policy_no`, `date`, `transit`, `vessel`, `bl`, `bl_date`, `sl_date`, `lc_no`, `lc_date`, `inv_no`, `inv_date`, `bundle_no`, `clause`, `clauses_endorsements_special_condition`, `chalan_no`, `chalan_date`, `post_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'ww-873,23329', 'w@#%23-45', '2021-02-10 18:00:00', 1, 'we,@#,er-43', 'w-32,34,e345', '2021-02-11', '2021-02-11', '#@-234', '2021-02-11', 'w-23#$5', '2021-02-11', '@#-sler', 'done%23', NULL, NULL, NULL, 0, 0, '2021-02-11 03:17:05', '2021-02-11 03:17:36'),
(2, 'ww-873,23329', '09324', '2021-02-10 18:00:00', 1, '$32-8465', 'w-4987#@', '2021-02-11', '2021-02-11', '23,074dht', '2021-02-11', '$3320834-456', '2021-02-11', '#4000-hello', 'don$3-453', NULL, NULL, NULL, 1, 0, '2021-02-11 03:31:28', '2021-02-11 03:31:28'),
(3, '#2-2-w#2-2-w', '#@w-qooel', '2021-02-10 18:00:00', 2, 'h-2,@#hello,', 'sl-#@,346', '2021-02-11', '2021-02-11', 'llc-23#@', '2021-02-11', '@34-645', '2021-02-11', '#@456-12wetr', '#@-345', NULL, NULL, NULL, 1, 1, '2021-02-11 07:00:38', '2021-02-11 07:00:48'),
(4, '#2-2-w#2-2-w', '#@-3456w-23', '2021-02-10 18:00:00', 1, '#@w-2345', 'sl-#@562017', '2021-02-11', '2021-02-11', '#@-234', '2021-02-11', '#@-2345', '2021-02-11', '@#%^-wql', '@#$%^hello world', NULL, NULL, NULL, 1, 1, '2021-02-11 07:02:17', '2021-02-11 07:04:36'),
(5, 'h-3900', '#@nhd-23', '2021-02-10 18:00:00', 1, 'hello#@,44g', 'done@#$', '2021-02-11', '2021-02-11', '#$5-slollld-we', '2021-02-11', 'W@#-slworld', '2021-02-11', '#@done', 'number od@#$-m,sll', NULL, NULL, NULL, 1, 0, '2021-02-11 07:03:33', '2021-02-11 07:03:33'),
(6, '#$%5sl-sler', '#@-skdfff', '2021-02-10 18:00:00', 1, '#@-sll44', 'sl-3456', '2021-02-11', '2021-02-11', 'sl-w3465@33', '2021-02-13', '@3000slbft', '2021-02-20', 'Sl@#45', '#$%^#sldf', NULL, NULL, NULL, 1, 0, '2021-02-11 07:24:12', '2021-02-11 07:24:12'),
(7, '@#swie2345', 'none@@##$4', '2021-02-15 09:17:14', 1, '2300-w-234', 'Slw23344', '2021-02-15', '2021-02-15', '@#0094-w', '2021-02-15', 'w-@#0344', '2021-02-15', '@#-slkdjkf', 'Silsa', NULL, NULL, NULL, 1, 1, '2021-02-15 03:17:14', '2021-02-15 03:17:52'),
(8, '@#99585657680000', 'slwE$$%%', '2021-02-15 10:46:25', 1, 'hello worldf@#%$&', '23000dklsrr', '2021-02-15', '2021-02-15', 'gate no done', '2021-02-15', '23sl03934456', '2021-02-15', 'sl5000', 'none', NULL, NULL, NULL, 1, 0, '2021-02-15 04:46:25', '2021-02-15 04:46:25'),
(9, '%^&**-hello world', '%^&**-hello wor', '2021-02-15 11:59:02', 1, '%^&**-hello world', '%^&**-hello world', '2021-02-15', '2021-02-15', '%^&**-hello world', '2021-02-15', '%^&**-hello world', '2021-02-10', '%^&**-hello world', '%^&**-hello world', NULL, NULL, NULL, 1, 0, '2021-02-15 05:59:02', '2021-02-15 05:59:02'),
(10, 'JH\'KKJJ\'LKK; 24.02.2021', 'ICIC:125.021/125-24.02.2021', '2021-02-24 09:05:31', 1, 'HCL & TCL', 'By Truck & Cargo', '2021-02-24', '2024-02-24', 'ICIC/LC:12541212', '2024-02-25', '21548858', '2021-02-25', 'BN:125.021.211/24.02.2021', 'None', NULL, NULL, NULL, 2, 0, '2021-02-24 09:05:31', '2021-02-24 09:05:31'),
(11, 'ICI/KTJ/MC-0043/02/2021', 'ICI/KTJ/MP-0017/2021', '2021-02-24 09:34:29', 1, 'TOKYO BAY V. 002E', 'OOLU2658011420', '2021-01-22', '2021-02-24', '208820010901', '2020-11-01', 'OG-RFS-RSQ-08-02', '2020-10-22', '3001', 'Subject to Important Notice attached hereto', NULL, NULL, NULL, 2, 0, '2021-02-24 09:34:29', '2021-02-24 09:34:29'),
(12, 'ICIB/BLL/KJJ:01/03/2021', 'ICIC\'JHBH:09:01/03/2021', '2021-03-01 11:02:07', 1, 'Mother Vessel', 'Dhaka', '2021-03-01', '2021-03-01', 'ICIC\'PLC:23156544', '2020-09-02', 'INV:01254528', '2021-03-01', '351254', 'None', NULL, NULL, NULL, 2, 0, '2021-03-01 11:02:07', '2021-03-01 11:02:07'),
(13, 'ICI/KTJ/MC-0040/02/2021', 'ICI/KTJ/MP-0021/03/2021', '2021-03-06 10:36:04', 1, 'X PRESS KAILASH V.21004E', 'MAX/DXB/1362/2021', '2021-01-25', '2021-01-03', '208820011051', '2020-12-23', 'None', '0001-01-01', '3002', 'NONE', 'try', NULL, NULL, 2, 1, '2021-03-06 10:36:04', '2021-03-07 11:55:29'),
(14, 'ICI/KTJ/MC-0040/02/2021', 'test233', '2021-03-07 11:56:09', 1, 'test233', 'test233', '2021-03-02', '2021-03-23', 'test233', '2021-03-16', 'test233', '2021-03-24', 'test233', 'test233', 'test233', NULL, NULL, 1, 0, '2021-03-07 11:56:09', '2021-03-07 11:56:09'),
(15, '%^&**-hello world', '4555556', '2021-03-08 12:54:31', 1, '56676', '4455', '2021-03-10', '2021-03-09', '777', '2021-03-16', NULL, NULL, '556', NULL, 'done', NULL, NULL, 1, 0, '2021-03-08 12:54:31', '2021-03-08 12:54:31'),
(16, '@#swie2345', 'r44555', '2021-03-08 13:09:28', 1, 'rrr', 'eer', '2021-03-09', '2021-03-09', '555', '2021-03-16', NULL, NULL, '555', NULL, 'lorem ipsum dolor emit7', 'done4567', '2021-03-20', 1, 1, '2021-03-08 13:09:28', '2021-03-08 13:19:01'),
(17, '@#swie2345', '666', '2021-03-08 13:35:40', 1, '455', '3455', '2021-03-09', '2021-03-18', '666', '2021-03-09', NULL, NULL, '666', '666', 'donenenenene345667', '66646', '2021-03-16', 1, 1, '2021-03-08 13:35:40', '2021-03-08 13:35:56'),
(18, 'ICI/KTJ/MC-0083/03/2021', 'sgsdg', '2021-03-08 13:42:30', 1, 'sgdg', 'dsgsg', '2021-03-08', '2021-03-01', 'sdgsg', '2021-03-01', NULL, NULL, 'sgdfg5555', NULL, '1ggg\n2hhh\n3hhhh', '65', '2021-03-01', 1, 0, '2021-03-08 13:42:30', '2021-03-08 13:42:30'),
(19, 'ICI/KTJ/MC-00/03/2021', 'jkjk', '2021-03-09 06:12:12', 1, 'jkjk', 'jkjk', '2021-03-09', '2021-03-09', 'uiuiu', '2021-03-09', NULL, NULL, '9989', NULL, 'hjhjhjh', '87', '2021-03-01', 2, 0, '2021-03-09 06:12:12', '2021-03-09 06:12:12'),
(20, 'ICI/KTJ/MC-0090/03/2021', 'ICI/KTJ/MP-21/03/2021', '2021-03-14 06:12:31', 1, 'harma', 'jjjju', '2021-03-14', '2021-03-14', '1222', '2021-03-14', NULL, NULL, '125', NULL, 'Subtem', 'T-55', '2021-03-14', 2, 0, '2021-03-14 06:12:31', '2021-03-14 06:12:31'),
(21, 'ICI/KTJ/MC-95/03/2021', 'ICI/KTJ/MP-0001/03/2021', '2021-03-14 07:12:08', 1, 'X 3PRESS KAILSH V.21004E', 'MAX/DXB/1362/2021', '2021-01-25', '2021-01-03', '208820011051', '2021-12-23', 'PI # IRTC-TCI056/20', '2021-12-24', '3002', 'None', 'Subject to Important Notice attached hereto.   \nSubject to Institute Cargo Clause\"C\'\' attached hererto.\nSubject to Institute Classification Clause attached hereto.', 'Vide Challan No.T-55', '2021-01-07', 2, 2, '2021-03-14 07:12:08', '2021-03-14 07:14:13');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2021_01_25_111723_create_cover_notes_table', 1),
(5, '2021_01_26_075724_create_marine_policies_table', 1),
(6, '2021_01_26_075746_create_addendums_table', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `addendums`
--
ALTER TABLE `addendums`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `addendums_addn_no_unique` (`addn_no`);

--
-- Indexes for table `cover_notes`
--
ALTER TABLE `cover_notes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `cover_notes_no_unique` (`no`),
  ADD UNIQUE KEY `cover_notes_cn_number_unique` (`cn_number`);

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

--
-- Indexes for table `marine_policies`
--
ALTER TABLE `marine_policies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `marine_policies_policy_no_unique` (`policy_no`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

