Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
22	[ DIR ]	drwxrwxrwx
36	[ DIR ]	drwxrwxrwx
application	[ DIR ]	drwxrwxrwx
site	[ DIR ]	drwxrwxrwx
vessel	[ DIR ]	drwxrwxrwx
22document(20).pdf	5.32 KB	-rw-rw-rw-
LifeAfter_Nanoplastic_Conversi...	67.48 KB	-rw-rw-rw-
URS-eDGPENS-LPKmn.pdf	921.31 KB	-rw-rw-rw-
config(1).php	6.41 KB	-rw-rw-rw-
dbedgpens20200327.sql	34.02 KB	-rw-rw-rw-
document(20).pdf	5.32 KB	-rw-rw-rw-
document(21).pdf	5.33 KB	-rw-rw-rw-
dompdf_out.pdf	23.52 KB	-rw-rw-rw-
index(1).php	1.52 KB	-rw-rw-rw-
index.html	0 B	-rw-rw-rw-
kodPort(1).php	15.75 KB	-rw-rw-rw-
logo_0_uYo_icon.ico	1.12 KB	-rw-rw-rw-
odbc(1).php	293 B	-rw-rw-rw-
odbc.php	293 B	-rw-rw-rw-
purpose.html	26 B	-rw-rw-rw-
purpose.json	6 B	-rw-rw-rw-
userList(1).php	14.46 KB	-rw-rw-rw-
userList.php	14.46 KB	-rw-rw-rw-

Code Editor : dbedgpens20200327.sql

-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 27, 2020 at 02:27 PM
-- Server version: 10.4.10-MariaDB
-- PHP Version: 7.3.12

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: `dbedgpens`
--
CREATE DATABASE IF NOT EXISTS `dbedgpens` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `dbedgpens`;

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

--
-- Table structure for table `kod_call_purpose`
--

CREATE TABLE `kod_call_purpose` (
  `idCallPurpose` bigint(20) NOT NULL,
  `kod` varchar(30) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_call_purpose`
--

INSERT INTO `kod_call_purpose` (`idCallPurpose`, `kod`, `nama`, `flagAktif`) VALUES
(1, '1', 'CARGO OPERATIONS', 'Y'),
(2, '2', 'PASSENGER OPERATIONS', 'Y'),
(3, '3', 'TAKING SUPPLIES ONLY', 'Y'),
(4, '4', 'REPAIR DOCKING', 'Y'),
(5, '5', 'OUTFITTING', 'Y'),
(6, '6', 'BUNKERING', 'Y'),
(7, '7', 'EMERGENCY', 'Y');

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

--
-- Table structure for table `kod_ctu_type`
--

CREATE TABLE `kod_ctu_type` (
  `idCTUType` bigint(20) NOT NULL,
  `kod` varchar(30) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_ctu_type`
--

INSERT INTO `kod_ctu_type` (`idCTUType`, `kod`, `nama`, `flagAktif`) VALUES
(3, '1', 'IN BULK', 'Y'),
(4, '2', 'DRUM', 'Y'),
(5, '3', 'BOXES', 'Y');

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

--
-- Table structure for table `kod_dg`
--

CREATE TABLE `kod_dg` (
  `idKodDG` bigint(20) NOT NULL,
  `UNNumber` varchar(30) NOT NULL,
  `IMOClass` varchar(30) NOT NULL,
  `nama` varchar(200) NOT NULL,
  `KPAGroup` varchar(30) NOT NULL,
  `properties` text NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_dg`
--

INSERT INTO `kod_dg` (`idKodDG`, `UNNumber`, `IMOClass`, `nama`, `KPAGroup`, `properties`, `flagAktif`) VALUES
(1, '3159', '2.2', '1,1,1, 2-TETRAFLUOROETHANE (REFRIGERANT GAS R 134A)', '3', 'Non-flammable gas with a mild ether-like odour. Much heavier than air\r\n', 'Y'),
(2, '2650', '6.1', '1,1-DICHLORO-1-NITROETHANE', '3', 'Liquid.Immiscible with water. May react vigorously with oxidising substance. Decomposes when heated. Toxic if swallowed, by skin or dust inhalation. Causes tears', 'Y'),
(3, '3022', '3', '1,2-BUTYLENE OXIDE STABILIZED', '2', 'Colorless liquid. F/point: 15oC c.c. Explosive limits: 1.5% to 18.3%. React violently with acids, alkalis and oxidizers. Miscible with water. Harmful if swallowed or by inhalation. Irritating to skin, eyes and mucous membranes', 'Y');

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

--
-- Table structure for table `kod_dimension`
--

CREATE TABLE `kod_dimension` (
  `idDimension` bigint(20) NOT NULL,
  `kod` varchar(30) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `kod_jenis_kapal`
--

CREATE TABLE `kod_jenis_kapal` (
  `idJenisKapal` bigint(20) NOT NULL,
  `kod` varchar(10) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_jenis_kapal`
--

INSERT INTO `kod_jenis_kapal` (`idJenisKapal`, `kod`, `nama`, `flagAktif`) VALUES
(1, '1', 'BARGE', 'Y'),
(2, '2', 'BULK CARRIER', 'Y');

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

--
-- Table structure for table `kod_jenis_syarikat`
--

CREATE TABLE `kod_jenis_syarikat` (
  `idJenisSyarikat` bigint(20) NOT NULL,
  `kod` varchar(10) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_jenis_syarikat`
--

INSERT INTO `kod_jenis_syarikat` (`idJenisSyarikat`, `kod`, `nama`, `flagAktif`) VALUES
(1, 'A', 'AGENT', 'Y'),
(2, 'V', 'VESSEL', 'Y'),
(3, 'C', 'CONSIGNEE', 'Y'),
(4, 'F', 'FORWARDER', 'Y'),
(5, 'T', 'TERMINAL', 'Y'),
(6, 'G', 'GOVERNMENT AGENCY', 'Y'),
(7, 'O', 'OPERATOR', 'Y');

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

--
-- Table structure for table `kod_kapal`
--

CREATE TABLE `kod_kapal` (
  `idKapal` bigint(20) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `idSyarikat` bigint(20) NOT NULL,
  `idJenisKapal` bigint(20) NOT NULL,
  `IMO` varchar(30) NOT NULL,
  `ISSC` varchar(30) NOT NULL,
  `Flag` varchar(30) NOT NULL,
  `CallSign` varchar(30) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y',
  `flagApprove` enum('N','Y','T') NOT NULL DEFAULT 'N',
  `idUserApply` bigint(20) NOT NULL,
  `tarikhApply` datetime NOT NULL,
  `idUserApprove` bigint(20) NOT NULL,
  `tarikhApprove` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_kapal`
--

INSERT INTO `kod_kapal` (`idKapal`, `nama`, `idSyarikat`, `idJenisKapal`, `IMO`, `ISSC`, `Flag`, `CallSign`, `flagAktif`, `flagApprove`, `idUserApply`, `tarikhApply`, `idUserApprove`, `tarikhApprove`) VALUES
(1, 'MV BUNGA MAWAR', 4, 2, 'imo1', 'issc1', 'flag1', 'call1', 'Y', 'Y', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(3, 'TEST1', 4, 2, '1', '2', '3', '4', 'Y', 'Y', 7, '2020-03-09 17:25:13', 1, '2020-03-25 15:27:52'),
(4, '1', 1, 2, '0', '0', '0', '0', 'Y', 'N', 1, '2020-03-17 11:15:12', 0, '0000-00-00 00:00:00');

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

--
-- Table structure for table `kod_marine_facility`
--

CREATE TABLE `kod_marine_facility` (
  `idMarineFacility` bigint(20) NOT NULL,
  `kod` varchar(30) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_marine_facility`
--

INSERT INTO `kod_marine_facility` (`idMarineFacility`, `kod`, `nama`, `flagAktif`) VALUES
(1, 'EW', 'KEMAMAN - EAST WHARVE', 'Y'),
(2, 'WW', 'KEMAMAN - WEST WHARVE', 'Y'),
(16, 'AN', 'ANCHORAGE', 'Y');

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

--
-- Table structure for table `kod_negara`
--

CREATE TABLE `kod_negara` (
  `idNegara` bigint(20) NOT NULL,
  `kod` varchar(20) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `iso_3166_2` varchar(5) NOT NULL,
  `iso_3166_3` varchar(5) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_negara`
--

INSERT INTO `kod_negara` (`idNegara`, `kod`, `nama`, `iso_3166_2`, `iso_3166_3`, `flagAktif`) VALUES
(1, '010', 'ANTARCTICA', 'AQ', 'ATA', 'Y'),
(2, '100', 'BULGARIA', 'BG', 'BGR', 'Y'),
(3, '104', 'MYANMAR', 'MM', 'MMR', 'Y'),
(4, '108', 'BURUNDI', 'BI', 'BDI', 'Y'),
(5, '112', 'BELARUS', 'BY', 'BLR', 'Y'),
(6, '116', 'CAMBODIA', 'KH', 'KHM', 'Y'),
(7, '012', 'ALGERIA', 'DZ', 'DZA', 'Y'),
(8, '120', 'CAMEROON', 'CM', 'CMR', 'Y'),
(9, '124', 'CANADA', 'CA', 'CAN', 'Y'),
(10, '132', 'CAPE VERDE', 'CV', 'CPV', 'Y'),
(11, '136', 'CAYMAN ISLANDS', 'KY', 'CYM', 'Y'),
(12, '140', 'CENTRAL AFRICAN REPUBLIC', 'CF', 'CAF', 'Y'),
(13, '144', 'SRI LANKA', 'LK', 'LKA', 'Y'),
(14, '148', 'CHAD', 'TD', 'TCD', 'Y'),
(15, '152', 'CHILE', 'CL', 'CHL', 'Y'),
(16, '156', 'CHINA', 'CN', 'CHN', 'Y'),
(17, '158', 'TAIWAN, PROVINCE OF CHINA', 'TW', 'TWN', 'Y'),
(18, '016', 'AMERICAN SAMOA', 'AS', 'ASM', 'Y'),
(19, '162', 'CHRISTMAS ISLAND', 'CX', 'CXR', 'Y'),
(20, '166', 'COCOS (KEELING) ISLANDS', 'CC', 'CCK', 'Y'),
(21, '170', 'COLOMBIA', 'CO', 'COL', 'Y'),
(22, '174', 'COMOROS', 'KM', 'COM', 'Y'),
(23, '175', 'MAYOTTE', 'YT', 'MYT', 'Y'),
(24, '178', 'CONGO', 'CG', 'COG', 'Y'),
(25, '180', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'CD', 'COD', 'Y'),
(26, '184', 'COOK ISLANDS', 'CK', 'COK', 'Y'),
(27, '188', 'COSTA RICA', 'CR', 'CRI', 'Y'),
(28, '191', 'CROATIA', 'HR', 'HRV', 'Y'),
(29, '192', 'CUBA', 'CU', 'CUB', 'Y'),
(30, '196', 'CYPRUS', 'CY', 'CYP', 'Y'),
(31, '020', 'ANDORRA', 'AD', 'AND', 'Y'),
(32, '203', 'CZECH REPUBLIC', 'CZ', 'CZE', 'Y'),
(33, '204', 'BENIN', 'BJ', 'BEN', 'Y'),
(34, '208', 'DENMARK', 'DK', 'DNK', 'Y'),
(35, '212', 'DOMINICA', 'DM', 'DMA', 'Y'),
(36, '214', 'DOMINICAN REPUBLIC', 'DO', 'DOM', 'Y'),
(37, '218', 'ECUADOR', 'EC', 'ECU', 'Y'),
(38, '222', 'EL SALVADOR', 'SV', 'SLV', 'Y'),
(39, '226', 'EQUATORIAL GUINEA', 'GQ', 'GNQ', 'Y'),
(40, '231', 'ETHIOPIA', 'ET', 'ETH', 'Y'),
(41, '232', 'ERITREA', 'ER', 'ERI', 'Y'),
(42, '233', 'ESTONIA', 'EE', 'EST', 'Y'),
(43, '234', 'FAROE ISLANDS', 'FO', 'FRO', 'Y'),
(44, '238', 'FALKLAND ISLANDS (MALVINAS)', 'FK', 'FLK', 'Y'),
(45, '239', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'GS', 'SGS', 'Y'),
(46, '024', 'ANGOLA', 'AO', 'AGO', 'Y'),
(47, '242', 'FIJI', 'FJ', 'FJI', 'Y'),
(48, '246', 'FINLAND', 'FI', 'FIN', 'Y'),
(49, '248', 'LAND ISLANDS', 'AX', 'ALA', 'Y'),
(50, '250', 'FRANCE', 'FR', 'FRA', 'Y'),
(51, '254', 'FRENCH GUIANA', 'GF', 'GUF', 'Y'),
(52, '258', 'FRENCH POLYNESIA', 'PF', 'PYF', 'Y'),
(53, '260', 'FRENCH SOUTHERN TERRITORIES', 'TF', 'ATF', 'Y'),
(54, '262', 'DJIBOUTI', 'DJ', 'DJI', 'Y'),
(55, '266', 'GABON', 'GA', 'GAB', 'Y'),
(56, '268', 'GEORGIA', 'GE', 'GEO', 'Y'),
(57, '270', 'GAMBIA', 'GM', 'GMB', 'Y'),
(58, '275', 'PALESTINIAN TERRITORY, OCCUPIED', 'PS', 'PSE', 'Y'),
(59, '276', 'GERMANY', 'DE', 'DEU', 'Y'),
(60, '028', 'ANTIGUA AND BARBUDA', 'AG', 'ATG', 'Y'),
(61, '288', 'GHANA', 'GH', 'GHA', 'Y'),
(62, '292', 'GIBRALTAR', 'GI', 'GIB', 'Y'),
(63, '296', 'KIRIBATI', 'KI', 'KIR', 'Y'),
(64, '300', 'GREECE', 'GR', 'GRC', 'Y'),
(65, '304', 'GREENLAND', 'GL', 'GRL', 'Y'),
(66, '308', 'GRENADA', 'GD', 'GRD', 'Y'),
(67, '031', 'AZERBAIJAN', 'AZ', 'AZE', 'Y'),
(68, '312', 'GUADELOUPE', 'GP', 'GLP', 'Y'),
(69, '316', 'GUAM', 'GU', 'GUM', 'Y'),
(70, '032', 'ARGENTINA', 'AR', 'ARG', 'Y'),
(71, '320', 'GUATEMALA', 'GT', 'GTM', 'Y'),
(72, '324', 'GUINEA', 'GN', 'GIN', 'Y'),
(73, '328', 'GUYANA', 'GY', 'GUY', 'Y'),
(74, '332', 'HAITI', 'HT', 'HTI', 'Y'),
(75, '334', 'HEARD ISLAND AND MCDONALD ISLANDS', 'HM', 'HMD', 'Y'),
(76, '336', 'HOLY SEE (VATICAN CITY STATE)', 'VA', 'VAT', 'Y'),
(77, '340', 'HONDURAS', 'HN', 'HND', 'Y'),
(78, '344', 'HONG KONG', 'HK', 'HKG', 'Y'),
(79, '348', 'HUNGARY', 'HU', 'HUN', 'Y'),
(80, '352', 'ICELAND', 'IS', 'ISL', 'Y'),
(81, '356', 'INDIA', 'IN', 'IND', 'Y'),
(82, '036', 'AUSTRALIA', 'AU', 'AUS', 'Y'),
(83, '360', 'INDONESIA', 'ID', 'IDN', 'Y'),
(84, '364', 'IRAN, ISLAMIC REPUBLIC OF', 'IR', 'IRN', 'Y'),
(85, '368', 'IRAQ', 'IQ', 'IRQ', 'Y'),
(86, '372', 'IRELAND', 'IE', 'IRL', 'Y'),
(87, '376', 'ISRAEL', 'IL', 'ISR', 'Y'),
(88, '380', 'ITALY', 'IT', 'ITA', 'Y'),
(89, '384', 'C™TE DIVOIRE', 'CI', 'CIV', 'Y'),
(90, '388', 'JAMAICA', 'JM', 'JAM', 'Y'),
(91, '392', 'JAPAN', 'JP', 'JPN', 'Y'),
(92, '398', 'KAZAKHSTAN', 'KZ', 'KAZ', 'Y'),
(93, '004', 'AFGHANISTAN', 'AF', 'AFG', 'Y'),
(94, '040', 'AUSTRIA', 'AT', 'AUT', 'Y'),
(95, '400', 'JORDAN', 'JO', 'JOR', 'Y'),
(96, '404', 'KENYA', 'KE', 'KEN', 'Y'),
(97, '408', 'KOREA, DEMOCRATIC PEOPLES REPUBLIC OF', 'KP', 'PRK', 'Y'),
(98, '410', 'KOREA, REPUBLIC OF', 'KR', 'KOR', 'Y'),
(99, '414', 'KUWAIT', 'KW', 'KWT', 'Y'),
(100, '417', 'KYRGYZSTAN', 'KG', 'KGZ', 'Y'),
(101, '418', 'LAO PEOPLES DEMOCRATIC REPUBLIC', 'LA', 'LAO', 'Y'),
(102, '422', 'LEBANON', 'LB', 'LBN', 'Y'),
(103, '426', 'LESOTHO', 'LS', 'LSO', 'Y'),
(104, '428', 'LATVIA', 'LV', 'LVA', 'Y'),
(105, '430', 'LIBERIA', 'LR', 'LBR', 'Y'),
(106, '434', 'LIBYA', 'LY', 'LBY', 'Y'),
(107, '438', 'LIECHTENSTEIN', 'LI', 'LIE', 'Y'),
(108, '044', 'BAHAMAS', 'BS', 'BHS', 'Y'),
(109, '440', 'LITHUANIA', 'LT', 'LTU', 'Y'),
(110, '442', 'LUXEMBOURG', 'LU', 'LUX', 'Y'),
(111, '446', 'MACAO', 'MO', 'MAC', 'Y'),
(112, '450', 'MADAGASCAR', 'MG', 'MDG', 'Y'),
(113, '454', 'MALAWI', 'MW', 'MWI', 'Y'),
(114, '458', 'MALAYSIA', 'MY', 'MYS', 'Y'),
(115, '462', 'MALDIVES', 'MV', 'MDV', 'Y'),
(116, '466', 'MALI', 'ML', 'MLI', 'Y'),
(117, '470', 'MALTA', 'MT', 'MLT', 'Y'),
(118, '474', 'MARTINIQUE', 'MQ', 'MTQ', 'Y'),
(119, '478', 'MAURITANIA', 'MR', 'MRT', 'Y'),
(120, '048', 'BAHRAIN', 'BH', 'BHR', 'Y'),
(121, '480', 'MAURITIUS', 'MU', 'MUS', 'Y'),
(122, '484', 'MEXICO', 'MX', 'MEX', 'Y'),
(123, '492', 'MONACO', 'MC', 'MCO', 'Y'),
(124, '496', 'MONGOLIA', 'MN', 'MNG', 'Y'),
(125, '498', 'MOLDOVA, REPUBLIC OF', 'MD', 'MDA', 'Y'),
(126, '499', 'MONTENEGRO', 'ME', 'MNE', 'Y'),
(127, '050', 'BANGLADESH', 'BD', 'BGD', 'Y'),
(128, '500', 'MONTSERRAT', 'MS', 'MSR', 'Y'),
(129, '504', 'MOROCCO', 'MA', 'MAR', 'Y'),
(130, '508', 'MOZAMBIQUE', 'MZ', 'MOZ', 'Y'),
(131, '051', 'ARMENIA', 'AM', 'ARM', 'Y'),
(132, '512', 'OMAN', 'OM', 'OMN', 'Y'),
(133, '516', 'NAMIBIA', 'NA', 'NAM', 'Y'),
(134, '052', 'BARBADOS', 'BB', 'BRB', 'Y'),
(135, '520', 'NAURU', 'NR', 'NRU', 'Y'),
(136, '524', 'NEPAL', 'NP', 'NPL', 'Y'),
(137, '528', 'NETHERLANDS', 'NL', 'NLD', 'Y'),
(138, '531', 'CURAAO', 'CW', 'CUW', 'Y'),
(139, '533', 'ARUBA', 'AW', 'ABW', 'Y'),
(140, '534', 'SINT MAARTEN (DUTCH PART)', 'SX', 'SXM', 'Y'),
(141, '535', 'BONAIRE, SINT EUSTATIUS AND SABA', 'BQ', 'BES', 'Y'),
(142, '540', 'NEW CALEDONIA', 'NC', 'NCL', 'Y'),
(143, '548', 'VANUATU', 'VU', 'VUT', 'Y'),
(144, '554', 'NEW ZEALAND', 'NZ', 'NZL', 'Y'),
(145, '558', 'NICARAGUA', 'NI', 'NIC', 'Y'),
(146, '056', 'BELGIUM', 'BE', 'BEL', 'Y'),
(147, '562', 'NIGER', 'NE', 'NER', 'Y'),
(148, '566', 'NIGERIA', 'NG', 'NGA', 'Y'),
(149, '570', 'NIUE', 'NU', 'NIU', 'Y'),
(150, '574', 'NORFOLK ISLAND', 'NF', 'NFK', 'Y'),
(151, '578', 'NORWAY', 'NO', 'NOR', 'Y'),
(152, '580', 'NORTHERN MARIANA ISLANDS', 'MP', 'MNP', 'Y'),
(153, '581', 'UNITED STATES MINOR OUTLYING ISLANDS', 'UM', 'UMI', 'Y'),
(154, '583', 'MICRONESIA, FEDERATED STATES OF', 'FM', 'FSM', 'Y'),
(155, '584', 'MARSHALL ISLANDS', 'MH', 'MHL', 'Y'),
(156, '585', 'PALAU', 'PW', 'PLW', 'Y'),
(157, '586', 'PAKISTAN', 'PK', 'PAK', 'Y'),
(158, '591', 'PANAMA', 'PA', 'PAN', 'Y'),
(159, '598', 'PAPUA NEW GUINEA', 'PG', 'PNG', 'Y'),
(160, '060', 'BERMUDA', 'BM', 'BMU', 'Y'),
(161, '600', 'PARAGUAY', 'PY', 'PRY', 'Y'),
(162, '604', 'PERU', 'PE', 'PER', 'Y'),
(163, '608', 'PHILIPPINES', 'PH', 'PHL', 'Y'),
(164, '612', 'PITCAIRN', 'PN', 'PCN', 'Y'),
(165, '616', 'POLAND', 'PL', 'POL', 'Y'),
(166, '620', 'PORTUGAL', 'PT', 'PRT', 'Y'),
(167, '624', 'GUINEA-BISSAU', 'GW', 'GNB', 'Y'),
(168, '626', 'TIMOR-LESTE', 'TL', 'TLS', 'Y'),
(169, '630', 'PUERTO RICO', 'PR', 'PRI', 'Y'),
(170, '634', 'QATAR', 'QA', 'QAT', 'Y'),
(171, '638', 'RŽUNION', 'RE', 'REU', 'Y'),
(172, '064', 'BHUTAN', 'BT', 'BTN', 'Y'),
(173, '642', 'ROMANIA', 'RO', 'ROU', 'Y'),
(174, '643', 'RUSSIAN FEDERATION', 'RU', 'RUS', 'Y'),
(175, '646', 'RWANDA', 'RW', 'RWA', 'Y'),
(176, '652', 'SAINT BARTHŽLEMY', 'BL', 'BLM', 'Y'),
(177, '654', 'SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA', 'SH', 'SHN', 'Y'),
(178, '659', 'SAINT KITTS AND NEVIS', 'KN', 'KNA', 'Y'),
(179, '660', 'ANGUILLA', 'AI', 'AIA', 'Y'),
(180, '662', 'SAINT LUCIA', 'LC', 'LCA', 'Y'),
(181, '663', 'SAINT MARTIN (FRENCH PART)', 'MF', 'MAF', 'Y'),
(182, '666', 'SAINT PIERRE AND MIQUELON', 'PM', 'SPM', 'Y'),
(183, '670', 'SAINT VINCENT AND THE GRENADINES', 'VC', 'VCT', 'Y'),
(184, '674', 'SAN MARINO', 'SM', 'SMR', 'Y'),
(185, '678', 'SAO TOME AND PRINCIPE', 'ST', 'STP', 'Y'),
(186, '068', 'BOLIVIA, PLURINATIONAL STATE OF', 'BO', 'BOL', 'Y'),
(187, '682', 'SAUDI ARABIA', 'SA', 'SAU', 'Y'),
(188, '686', 'SENEGAL', 'SN', 'SEN', 'Y'),
(189, '688', 'SERBIA', 'RS', 'SRB', 'Y'),
(190, '690', 'SEYCHELLES', 'SC', 'SYC', 'Y'),
(191, '694', 'SIERRA LEONE', 'SL', 'SLE', 'Y'),
(192, '070', 'BOSNIA AND HERZEGOVINA', 'BA', 'BIH', 'Y'),
(193, '702', 'SINGAPORE', 'SG', 'SGP', 'Y'),
(194, '703', 'SLOVAKIA', 'SK', 'SVK', 'Y'),
(195, '704', 'VIET NAM', 'VN', 'VNM', 'Y'),
(196, '705', 'SLOVENIA', 'SI', 'SVN', 'Y'),
(197, '706', 'SOMALIA', 'SO', 'SOM', 'Y'),
(198, '710', 'SOUTH AFRICA', 'ZA', 'ZAF', 'Y'),
(199, '716', 'ZIMBABWE', 'ZW', 'ZWE', 'Y'),
(200, '072', 'BOTSWANA', 'BW', 'BWA', 'Y'),
(201, '724', 'SPAIN', 'ES', 'ESP', 'Y'),
(202, '728', 'SOUTH SUDAN', 'SS', 'SSD', 'Y'),
(203, '729', 'SUDAN', 'SD', 'SDN', 'Y'),
(204, '732', 'WESTERN SAHARA', 'EH', 'ESH', 'Y'),
(205, '074', 'BOUVET ISLAND', 'BV', 'BVT', 'Y'),
(206, '740', 'SURINAME', 'SR', 'SUR', 'Y'),
(207, '744', 'SVALBARD AND JAN MAYEN', 'SJ', 'SJM', 'Y'),
(208, '748', 'SWAZILAND', 'SZ', 'SWZ', 'Y'),
(209, '752', 'SWEDEN', 'SE', 'SWE', 'Y'),
(210, '756', 'SWITZERLAND', 'CH', 'CHE', 'Y'),
(211, '076', 'BRAZIL', 'BR', 'BRA', 'Y'),
(212, '760', 'SYRIAN ARAB REPUBLIC', 'SY', 'SYR', 'Y'),
(213, '762', 'TAJIKISTAN', 'TJ', 'TJK', 'Y'),
(214, '764', 'THAILAND', 'TH', 'THA', 'Y'),
(215, '768', 'TOGO', 'TG', 'TGO', 'Y'),
(216, '772', 'TOKELAU', 'TK', 'TKL', 'Y'),
(217, '776', 'TONGA', 'TO', 'TON', 'Y'),
(218, '780', 'TRINIDAD AND TOBAGO', 'TT', 'TTO', 'Y'),
(219, '784', 'UNITED ARAB EMIRATES', 'AE', 'ARE', 'Y'),
(220, '788', 'TUNISIA', 'TN', 'TUN', 'Y'),
(221, '792', 'TURKEY', 'TR', 'TUR', 'Y'),
(222, '795', 'TURKMENISTAN', 'TM', 'TKM', 'Y'),
(223, '796', 'TURKS AND CAICOS ISLANDS', 'TC', 'TCA', 'Y'),
(224, '798', 'TUVALU', 'TV', 'TUV', 'Y'),
(225, '008', 'ALBANIA', 'AL', 'ALB', 'Y'),
(226, '800', 'UGANDA', 'UG', 'UGA', 'Y'),
(227, '804', 'UKRAINE', 'UA', 'UKR', 'Y'),
(228, '807', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'MK', 'MKD', 'Y'),
(229, '818', 'EGYPT', 'EG', 'EGY', 'Y'),
(230, '826', 'UNITED KINGDOM', 'GB', 'GBR', 'Y'),
(231, '831', 'GUERNSEY', 'GG', 'GGY', 'Y'),
(232, '832', 'JERSEY', 'JE', 'JEY', 'Y'),
(233, '833', 'ISLE OF MAN', 'IM', 'IMN', 'Y'),
(234, '834', 'TANZANIA, UNITED REPUBLIC OF', 'TZ', 'TZA', 'Y'),
(235, '084', 'BELIZE', 'BZ', 'BLZ', 'Y'),
(236, '840', 'UNITED STATES', 'US', 'USA', 'Y'),
(237, '850', 'VIRGIN ISLANDS, U.S.', 'VI', 'VIR', 'Y'),
(238, '854', 'BURKINA FASO', 'BF', 'BFA', 'Y'),
(239, '858', 'URUGUAY', 'UY', 'URY', 'Y'),
(240, '086', 'BRITISH INDIAN OCEAN TERRITORY', 'IO', 'IOT', 'Y'),
(241, '860', 'UZBEKISTAN', 'UZ', 'UZB', 'Y'),
(242, '862', 'VENEZUELA, BOLIVARIAN REPUBLIC OF', 'VE', 'VEN', 'Y'),
(243, '876', 'WALLIS AND FUTUNA', 'WF', 'WLF', 'Y'),
(244, '882', 'SAMOA', 'WS', 'WSM', 'Y'),
(245, '887', 'YEMEN', 'YE', 'YEM', 'Y'),
(246, '894', 'ZAMBIA', 'ZM', 'ZMB', 'Y'),
(247, '090', 'SOLOMON ISLANDS', 'SB', 'SLB', 'Y'),
(248, '092', 'VIRGIN ISLANDS, BRITISH', 'VG', 'VGB', 'Y'),
(249, '096', 'BRUNEI DARUSSALAM', 'BN', 'BRN', 'Y');

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

--
-- Table structure for table `kod_operation_type`
--

CREATE TABLE `kod_operation_type` (
  `idOpsType` bigint(20) NOT NULL,
  `kod` varchar(30) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `kod_packing_type`
--

CREATE TABLE `kod_packing_type` (
  `idPackingType` bigint(20) NOT NULL,
  `kod` varchar(30) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_packing_type`
--

INSERT INTO `kod_packing_type` (`idPackingType`, `kod`, `nama`, `flagAktif`) VALUES
(2, '1', 'BAGS - PAPER', 'Y'),
(3, '2', 'BAGS - PLASTICS FILM', 'Y'),
(4, '3', 'BARRELS', 'Y'),
(5, '4', 'BOXES - METAL', 'Y');

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

--
-- Table structure for table `kod_pelabuhan`
--

CREATE TABLE `kod_pelabuhan` (
  `idPelabuhan` bigint(20) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `idNegara` bigint(20) NOT NULL,
  `hadMasa` varchar(10) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y',
  `flagApprove` enum('N','Y','T') NOT NULL DEFAULT 'N',
  `idUserApply` bigint(20) NOT NULL,
  `tarikhApply` datetime NOT NULL,
  `idUserApprove` bigint(20) NOT NULL,
  `tarikhApprove` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_pelabuhan`
--

INSERT INTO `kod_pelabuhan` (`idPelabuhan`, `nama`, `idNegara`, `hadMasa`, `flagAktif`, `flagApprove`, `idUserApply`, `tarikhApply`, `idUserApprove`, `tarikhApprove`) VALUES
(1, 'KEMAMAN', 114, '48', 'Y', 'Y', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(2, 'KUCHING', 114, '48', 'Y', 'Y', 3, '2020-03-11 14:20:06', 1, '2020-03-22 15:10:53'),
(3, 'PASIR GUDANG', 114, '48', 'Y', 'Y', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(4, 'TANJUNG PELEPAS', 114, '48', 'Y', 'Y', 2, '2020-03-01 06:39:37', 1, '2020-03-22 15:11:24'),
(6, 'KLANG', 114, '48', 'Y', 'Y', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(7, 'PENANG', 114, '48', 'Y', 'Y', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(8, 'SINGAPORE', 193, '12', 'Y', 'Y', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(9, 'MANILA', 163, '48', 'Y', 'N', 2, '2020-03-10 03:38:06', 0, '0000-00-00 00:00:00'),
(10, 'ANTWERP', 146, '48', 'Y', 'N', 2, '2020-03-16 19:26:00', 0, '0000-00-00 00:00:00'),
(11, 'KUANTAN', 114, '48', 'Y', 'Y', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00');

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

--
-- Table structure for table `kod_syarikat`
--

CREATE TABLE `kod_syarikat` (
  `idSyarikat` bigint(20) NOT NULL,
  `kod` varchar(30) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `alamat` text NOT NULL,
  `noTel` varchar(20) NOT NULL,
  `noFax` varchar(20) NOT NULL,
  `idJenisSyarikat` bigint(20) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y',
  `flagApprove` enum('Y','T','N') NOT NULL DEFAULT 'N',
  `idUserApply` bigint(20) NOT NULL,
  `tarikhApply` datetime NOT NULL,
  `idUserApprove` bigint(20) NOT NULL,
  `tarikhApprove` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_syarikat`
--

INSERT INTO `kod_syarikat` (`idSyarikat`, `kod`, `nama`, `alamat`, `noTel`, `noFax`, `idJenisSyarikat`, `flagAktif`, `flagApprove`, `idUserApply`, `tarikhApply`, `idUserApprove`, `tarikhApprove`) VALUES
(1, '', 'KEMAMAN SUPPLY BASE', 'PETI SURAT 64\r\n24007 TELUK KALONG\r\nKEMAMAN\r\n', '09-8631566', '09-8631716', 5, 'Y', 'Y', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(2, '', 'AGENT1', 'ADD1\r\nADD2\r\nADD3\r\n12345 CITY1\r\nCOUNTRY', '013-9999999', '03-8880100', 1, 'Y', 'Y', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(3, '', 'KASTAM', '1', '1', '1', 6, 'Y', 'N', 2, '2020-03-10 05:22:08', 0, '0000-00-00 00:00:00'),
(4, '', 'TEST123', '1\r\n2\r\n3', '2', '2', 2, 'Y', 'Y', 2, '2020-03-02 08:28:37', 1, '2020-03-25 15:36:47'),
(5, '', 'AGENT2', 'A1\r\nB2\r\nC3', '7', '7', 1, 'Y', 'Y', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00');

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

--
-- Table structure for table `kod_weight`
--

CREATE TABLE `kod_weight` (
  `idWeight` bigint(20) NOT NULL,
  `kod` varchar(30) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `flagAktif` enum('Y','T') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kod_weight`
--

INSERT INTO `kod_weight` (`idWeight`, `kod`, `nama`, `flagAktif`) VALUES
(3, '1', 'KILOGRAM', 'Y'),
(4, '2', 'TONNE', 'Y'),
(5, '3', 'LITRE', 'Y');

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

--
-- Table structure for table `pemohonan_dg_package`
--

CREATE TABLE `pemohonan_dg_package` (
  `idDGPackage` bigint(20) NOT NULL,
  `idPDG` bigint(20) NOT NULL,
  `CTUID` varchar(100) NOT NULL,
  `weight` decimal(10,4) NOT NULL,
  `idWeight` bigint(20) NOT NULL,
  `idCTUType` bigint(20) NOT NULL,
  `idPackingType` bigint(20) NOT NULL,
  `idDimension` bigint(20) NOT NULL,
  `CTUTeus` varchar(100) NOT NULL,
  `lorryETA` datetime NOT NULL,
  `lorryPlateNo` varchar(20) NOT NULL,
  `lorryCompany` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `permohonan_dg`
--

CREATE TABLE `permohonan_dg` (
  `idPDG` bigint(20) NOT NULL,
  `idPermohonanMain` bigint(20) NOT NULL,
  `idKodDG` bigint(20) NOT NULL,
  `idOpsType` bigint(20) NOT NULL,
  `idPortLoading` bigint(20) NOT NULL,
  `idPortDischarging` bigint(20) NOT NULL,
  `flashPoint` varchar(100) NOT NULL,
  `comments` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `permohonan_dg_bulk`
--

CREATE TABLE `permohonan_dg_bulk` (
  `idDGBulk` bigint(20) NOT NULL,
  `idPDG` bigint(20) NOT NULL,
  `holdNumber` varchar(100) NOT NULL,
  `weight` decimal(10,4) NOT NULL,
  `idWeight` bigint(20) NOT NULL,
  `lorryETA` datetime NOT NULL,
  `lorryPlateNo` varchar(20) NOT NULL,
  `lorryCompany` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `permohonan_lampiran`
--

CREATE TABLE `permohonan_lampiran` (
  `idPL` bigint(20) NOT NULL,
  `idPermohonanMain` bigint(20) NOT NULL,
  `namaFail` varchar(100) NOT NULL,
  `keterengan` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `permohonan_main`
--

CREATE TABLE `permohonan_main` (
  `idPermohonan` bigint(20) NOT NULL,
  `idUserApply` bigint(20) NOT NULL,
  `tarikhApply` datetime NOT NULL,
  `refID` bigint(20) NOT NULL,
  `status` varchar(100) NOT NULL,
  `idKapal` bigint(20) NOT NULL,
  `bilKrew` int(11) NOT NULL,
  `bilPenumpang` int(11) NOT NULL,
  `GT` varchar(100) NOT NULL,
  `noSCN` varchar(100) NOT NULL,
  `noVoyage` varchar(100) NOT NULL,
  `idCallPurpose` bigint(20) NOT NULL,
  `otherCallPurpose` varchar(200) NOT NULL,
  `cargo2discharge` varchar(200) NOT NULL,
  `idMarineFacility` bigint(20) NOT NULL,
  `flagISSC` enum('Y','T') NOT NULL,
  `flagNCPort` enum('Y','T') NOT NULL,
  `flagDG12` enum('Y','T') NOT NULL,
  `tarikhLuputISSC` date NOT NULL,
  `ISSCAuthority` varchar(200) NOT NULL,
  `securityLevel` enum('1','2','3') NOT NULL,
  `flagSecurityMeasures` enum('Y','T') NOT NULL,
  `catatanSecurityMeasures` text NOT NULL,
  `latitude` varchar(30) NOT NULL,
  `longitude` varchar(30) NOT NULL,
  `ETA` datetime NOT NULL,
  `namaMaster` varchar(200) NOT NULL,
  `flagDG` enum('Y','T') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `permohonan_pelabuhan`
--

CREATE TABLE `permohonan_pelabuhan` (
  `idPP` bigint(20) NOT NULL,
  `idPermohonanMain` bigint(20) NOT NULL,
  `idPelabuhan` bigint(20) NOT NULL,
  `tarikhTiba` date NOT NULL,
  `tarikhBerlepas` date NOT NULL,
  `securityLevel` enum('1','2','3') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `user_list`
--

CREATE TABLE `user_list` (
  `idUser` bigint(20) NOT NULL,
  `idSyarikat` bigint(20) NOT NULL,
  `emailUser` varchar(150) NOT NULL,
  `passwordUser` text NOT NULL,
  `nameUser` varchar(200) NOT NULL,
  `mobileNo` varchar(20) NOT NULL,
  `idRoles` bigint(20) NOT NULL,
  `flagUser` enum('1','2','3') NOT NULL DEFAULT '1' COMMENT '1-aktif,2-blocked,3-xaktif',
  `idPelabuhan` bigint(20) NOT NULL COMMENT 'utk MFSO',
  `flagApprove` enum('N','Y','T') NOT NULL DEFAULT 'N',
  `dateCreated` datetime NOT NULL,
  `dateVerified` datetime NOT NULL,
  `dateModified` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_list`
--

INSERT INTO `user_list` (`idUser`, `idSyarikat`, `emailUser`, `passwordUser`, `nameUser`, `mobileNo`, `idRoles`, `flagUser`, `idPelabuhan`, `flagApprove`, `dateCreated`, `dateVerified`, `dateModified`) VALUES
(1, 1, 'fahmi@fifway.com.my', '', 'AZHAR FAHMI AHMAD', '60139823972', 2, '1', 2, 'Y', '2020-03-27 21:16:28', '2020-03-27 21:16:28', '2020-03-27 21:16:28'),
(2, 5, 'a@aaa', '', 'ABC', '123', 3, '2', 0, 'Y', '2020-03-27 21:19:55', '2020-03-27 21:19:55', '2020-03-27 21:26:24');

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

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `idRoles` bigint(20) NOT NULL,
  `nama` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` (`idRoles`, `nama`) VALUES
(1, 'AGENT'),
(2, 'MFSO\r\n'),
(3, 'MTSO'),
(4, 'REGULATOR\r\n'),
(5, 'ADMIN');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `kod_call_purpose`
--
ALTER TABLE `kod_call_purpose`
  ADD PRIMARY KEY (`idCallPurpose`);

--
-- Indexes for table `kod_ctu_type`
--
ALTER TABLE `kod_ctu_type`
  ADD PRIMARY KEY (`idCTUType`);

--
-- Indexes for table `kod_dg`
--
ALTER TABLE `kod_dg`
  ADD PRIMARY KEY (`idKodDG`);

--
-- Indexes for table `kod_dimension`
--
ALTER TABLE `kod_dimension`
  ADD PRIMARY KEY (`idDimension`);

--
-- Indexes for table `kod_jenis_kapal`
--
ALTER TABLE `kod_jenis_kapal`
  ADD PRIMARY KEY (`idJenisKapal`);

--
-- Indexes for table `kod_jenis_syarikat`
--
ALTER TABLE `kod_jenis_syarikat`
  ADD PRIMARY KEY (`idJenisSyarikat`);

--
-- Indexes for table `kod_kapal`
--
ALTER TABLE `kod_kapal`
  ADD PRIMARY KEY (`idKapal`);

--
-- Indexes for table `kod_marine_facility`
--
ALTER TABLE `kod_marine_facility`
  ADD PRIMARY KEY (`idMarineFacility`);

--
-- Indexes for table `kod_negara`
--
ALTER TABLE `kod_negara`
  ADD PRIMARY KEY (`idNegara`);

--
-- Indexes for table `kod_operation_type`
--
ALTER TABLE `kod_operation_type`
  ADD PRIMARY KEY (`idOpsType`);

--
-- Indexes for table `kod_packing_type`
--
ALTER TABLE `kod_packing_type`
  ADD PRIMARY KEY (`idPackingType`);

--
-- Indexes for table `kod_pelabuhan`
--
ALTER TABLE `kod_pelabuhan`
  ADD PRIMARY KEY (`idPelabuhan`);

--
-- Indexes for table `kod_syarikat`
--
ALTER TABLE `kod_syarikat`
  ADD PRIMARY KEY (`idSyarikat`);

--
-- Indexes for table `kod_weight`
--
ALTER TABLE `kod_weight`
  ADD PRIMARY KEY (`idWeight`);

--
-- Indexes for table `pemohonan_dg_package`
--
ALTER TABLE `pemohonan_dg_package`
  ADD PRIMARY KEY (`idDGPackage`);

--
-- Indexes for table `permohonan_dg`
--
ALTER TABLE `permohonan_dg`
  ADD PRIMARY KEY (`idPDG`);

--
-- Indexes for table `permohonan_dg_bulk`
--
ALTER TABLE `permohonan_dg_bulk`
  ADD PRIMARY KEY (`idDGBulk`);

--
-- Indexes for table `permohonan_lampiran`
--
ALTER TABLE `permohonan_lampiran`
  ADD PRIMARY KEY (`idPL`);

--
-- Indexes for table `permohonan_main`
--
ALTER TABLE `permohonan_main`
  ADD PRIMARY KEY (`idPermohonan`);

--
-- Indexes for table `permohonan_pelabuhan`
--
ALTER TABLE `permohonan_pelabuhan`
  ADD PRIMARY KEY (`idPP`);

--
-- Indexes for table `user_list`
--
ALTER TABLE `user_list`
  ADD PRIMARY KEY (`idUser`);

--
-- Indexes for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`idRoles`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `kod_call_purpose`
--
ALTER TABLE `kod_call_purpose`
  MODIFY `idCallPurpose` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `kod_ctu_type`
--
ALTER TABLE `kod_ctu_type`
  MODIFY `idCTUType` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `kod_dg`
--
ALTER TABLE `kod_dg`
  MODIFY `idKodDG` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `kod_dimension`
--
ALTER TABLE `kod_dimension`
  MODIFY `idDimension` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `kod_jenis_kapal`
--
ALTER TABLE `kod_jenis_kapal`
  MODIFY `idJenisKapal` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `kod_jenis_syarikat`
--
ALTER TABLE `kod_jenis_syarikat`
  MODIFY `idJenisSyarikat` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `kod_kapal`
--
ALTER TABLE `kod_kapal`
  MODIFY `idKapal` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `kod_marine_facility`
--
ALTER TABLE `kod_marine_facility`
  MODIFY `idMarineFacility` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `kod_negara`
--
ALTER TABLE `kod_negara`
  MODIFY `idNegara` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=250;

--
-- AUTO_INCREMENT for table `kod_operation_type`
--
ALTER TABLE `kod_operation_type`
  MODIFY `idOpsType` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `kod_packing_type`
--
ALTER TABLE `kod_packing_type`
  MODIFY `idPackingType` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `kod_pelabuhan`
--
ALTER TABLE `kod_pelabuhan`
  MODIFY `idPelabuhan` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `kod_syarikat`
--
ALTER TABLE `kod_syarikat`
  MODIFY `idSyarikat` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `kod_weight`
--
ALTER TABLE `kod_weight`
  MODIFY `idWeight` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `pemohonan_dg_package`
--
ALTER TABLE `pemohonan_dg_package`
  MODIFY `idDGPackage` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permohonan_dg`
--
ALTER TABLE `permohonan_dg`
  MODIFY `idPDG` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permohonan_dg_bulk`
--
ALTER TABLE `permohonan_dg_bulk`
  MODIFY `idDGBulk` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permohonan_lampiran`
--
ALTER TABLE `permohonan_lampiran`
  MODIFY `idPL` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permohonan_main`
--
ALTER TABLE `permohonan_main`
  MODIFY `idPermohonan` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permohonan_pelabuhan`
--
ALTER TABLE `permohonan_pelabuhan`
  MODIFY `idPP` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_list`
--
ALTER TABLE `user_list`
  MODIFY `idUser` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `user_roles`
--
ALTER TABLE `user_roles`
  MODIFY `idRoles` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
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 */;

${this.title}

Code Editor : dbedgpens20200327.sql