-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 04, 2021 at 11:57 AM
-- Server version: 10.3.32-MariaDB
-- PHP Version: 7.3.33

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 `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 DEFAULT NULL,
  `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);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `principal`
--
ALTER TABLE `principal`
  MODIFY `id` int(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
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 */;
