--
-- Host: localhost    Database: portdb1
-- ------------------------------------------------------


--
-- Table structure for table `agent_monthly_vessel_form`
--

CREATE TABLE `agent_monthly_vessel_form` (
  `id_agent_monthly_vessel_form` int(11) NOT NULL AUTO_INCREMENT,
  `month` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vessel_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `voyage_inward` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `voyage_outward` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vessel_code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `eta` datetime DEFAULT NULL,
  `loa` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_port` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `next_port` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `line` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `service` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vessel_type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `etd` datetime DEFAULT NULL,
  `agent_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_draft` tinyint(1) NOT NULL DEFAULT '1',
  `liner_code` text COLLATE utf8_unicode_ci,
  `shipping_agent` text COLLATE utf8_unicode_ci,
  `lpo_number` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_agent_monthly_vessel_form`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `agent_monthly_vessel_form`
--

INSERT INTO `agent_monthly_vessel_form` VALUES (55,'february','container','1','1',NULL,'2022-04-16 09:37:00','1','1','1','1','1','1','2022-04-14 09:37:00','Test User','Test123','AMV-156','2022-04-13 16:07:34','2022-04-13 16:07:34',0,'PDL','Test Agent',NULL),(56,'january','V1','1','1',NULL,'2022-04-21 03:19:00','1','1','1','1','1','container','2022-04-21 03:19:00','Test1','test123','AMV-157','2022-04-20 09:49:50','2022-04-20 09:49:50',0,'PDL','Test Agent',NULL),(57,'march','V1','1','1',NULL,'2022-04-30 11:11:00','1','1','1','1','1','wheat','2022-04-29 11:12:00','Test1','test123','AMV-166','2022-04-22 17:43:40','2022-04-22 17:43:40',0,'PDL','Test Agent',NULL),(58,'march','V1','2','2',NULL,'2022-04-30 11:13:00','2','2','2','2','2','wheat','2022-04-30 11:13:00','Test1','test123','AMV-166','2022-04-22 17:43:40','2022-04-22 17:43:40',0,'PDL','Test Agent',NULL),(59,'march','V1','1','1',NULL,'2022-04-30 11:23:00','1','1','1','1','1','wheat','2022-04-28 11:23:00','Test1','test123','AMV-167','2022-04-22 17:53:19','2022-04-22 17:53:19',0,'COO','Test Agent',NULL),(60,'august','KAMOKUIKI','36','36',NULL,'2022-08-02 06:00:00','132','AKL','SKU','MAT','PACISL','container','2022-08-02 20:00:00','Chris Vafo\'ou','Chris Vafo\'ou','AMV-185','2022-08-01 15:37:55','2022-08-01 15:37:55',0,'PDL','Williams & Gosling',NULL),(61,'august','LILOA II','67','67',NULL,'2022-08-08 06:00:00','118','LTK','PPG','MAT','PACISL','container','2022-08-08 20:00:00','Chris Vafo\'ou','Chris Vafo\'ou','AMV-185','2022-08-01 15:37:55','2022-08-01 15:37:55',0,'PDL','Williams & Gosling',NULL),(62,'august','CAPITAINE TASMAN','072N','072S',NULL,'2022-08-08 06:00:00','184','AKL','LTK','NPD','NZPAC','container','2022-08-10 06:00:00','Chris Vafo\'ou','Chris Vafo\'ou','AMV-185','2022-08-01 15:37:55','2022-08-01 15:37:55',0,'PDL','Williams & Gosling',NULL),(63,'august','PAPA MAU','143','143',NULL,'2022-08-10 06:00:00','116','AKL','SKU','MAT','PACISL','container','2022-08-11 20:00:00','Chris Vafo\'ou','Chris Vafo\'ou','AMV-185','2022-08-01 15:37:55','2022-08-01 15:37:55',0,'PDL','Williams & Gosling',NULL),(64,'august','CAPITAINE MAGELLAN','17S','17N',NULL,'2022-08-10 06:00:00','126','LTK','VLI','NPD','NZPAC','container','2022-08-11 18:00:00','Chris Vafo\'ou','Chris Vafo\'ou','AMV-185','2022-08-01 15:37:55','2022-08-01 15:37:55',0,'PDL','Williams & Gosling',NULL);

--
-- Table structure for table `approval_receival_mail`
--

CREATE TABLE `approval_receival_mail` (
  `id_approval_receival_mail` int(11) NOT NULL AUTO_INCREMENT,
  `email1` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email3` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email4` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id_approval_receival_mail`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `approval_receival_mail`
--

INSERT INTO `approval_receival_mail` VALUES (2,'rangabiz97@gmail.com','umatec97@gmail.com','test3@gmail.com','test4@gmail.com','2021-07-26 15:48:58','0000-00-00 00:00:00');

--
-- Table structure for table `cargo_receiving_request_form`
--

CREATE TABLE `cargo_receiving_request_form` (
  `id_cargo_receiving_form` int(11) NOT NULL AUTO_INCREMENT,
  `vessel_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `voyage_no` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `port_of_rotation` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `service_code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `request_date` datetime NOT NULL,
  `request_time` datetime NOT NULL,
  `port_of_discharge` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agent_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `request_cut_off_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `request_cut_off_time` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_draft` tinyint(1) NOT NULL DEFAULT '1',
  `liner_code` text COLLATE utf8_unicode_ci,
  `shipping_agent` text COLLATE utf8_unicode_ci,
  `lpo_number` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_cargo_receiving_form`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cargo_receiving_request_form`
--

INSERT INTO `cargo_receiving_request_form` VALUES (13,'et','23','ert','wq','2022-04-23 00:00:00','2022-04-22 11:45:00',NULL,'Test1','test123','CRR-168','2022-04-22 18:12:53','2022-04-22 18:12:53','2022-04-27 00:00:00','2022-04-22 11:48:00',0,'COO','Test Agent',NULL),(14,'KAMOKUIKI','36','AKL, SUV, SHANGHAI','PACISL','2022-08-01 00:00:00','2022-08-01 08:00:00',NULL,'Chris Vafo\'ou','Chris Vafo\'ou','CRR-186','2022-08-01 15:42:10','2022-08-01 15:42:10','2022-08-02 00:00:00','2022-08-01 17:00:00',0,'MAT','Williams & Gosling',NULL);

--
-- Table structure for table `cargo_receiving_request_form_breakbulk`
--

CREATE TABLE `cargo_receiving_request_form_breakbulk` (
  `id_cargo_receiving_request_form_breakbulk` int(11) NOT NULL AUTO_INCREMENT,
  `break_bulk` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qty` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mt` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cbm` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cargo_receiving_request_form_id_cargo_receiving_request_form` int(64) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id_cargo_receiving_request_form_breakbulk`),
  KEY `cargo_receiving_request_form_id_cargo_receiving_request_form` (`cargo_receiving_request_form_id_cargo_receiving_request_form`),
  CONSTRAINT `cargo_receiving_request_form_breakbulk_ibfk_1` FOREIGN KEY (`cargo_receiving_request_form_id_cargo_receiving_request_form`) REFERENCES `cargo_receiving_request_form` (`id_cargo_receiving_form`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cargo_receiving_request_form_breakbulk`
--

INSERT INTO `cargo_receiving_request_form_breakbulk` VALUES (21,'master Packs','23','23','3',13,'2022-04-22 18:12:53','2022-04-22 18:12:53'),(22,'paper Rolls','2','8','15',14,'2022-08-01 15:42:10','2022-08-01 15:42:10');

--
-- Table structure for table `cargo_receiving_request_form_post_of_discharge`
--

CREATE TABLE `cargo_receiving_request_form_post_of_discharge` (
  `id_cargo_receiving_request_form_post_of_discharge` int(11) NOT NULL AUTO_INCREMENT,
  `laden_day1_20` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `laden_day1_40` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `laden_day2_20` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `laden_day2_40` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `laden_day3_20` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `laden_day3_40` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `empty_day1_20` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `empty_day1_40` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `empty_day2_20` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `empty_day2_40` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `empty_day3_20` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `empty_day3_40` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_20` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_40` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cargo_receiving_request_form_id_cargo_receiving_request_form` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `port_of_discharge` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id_cargo_receiving_request_form_post_of_discharge`),
  KEY `cargo_receiving_request_form_id_cargo_receiving_request_form` (`cargo_receiving_request_form_id_cargo_receiving_request_form`),
  CONSTRAINT `cargo_receiving_request_form_post_of_discharge_ibfk_1` FOREIGN KEY (`cargo_receiving_request_form_id_cargo_receiving_request_form`) REFERENCES `cargo_receiving_request_form` (`id_cargo_receiving_form`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cargo_receiving_request_form_post_of_discharge`
--

INSERT INTO `cargo_receiving_request_form_post_of_discharge` VALUES (33,'1','1','2','3','3','1','1','1','1','1','1','1','1','1',13,'2022-04-22 18:12:53','2022-04-22 18:12:53','1'),(34,'2','2','2','2','2','2','2','2','2','2','2','2','2','2',13,'2022-04-22 18:12:53','2022-04-22 18:12:53','2'),(35,'3','3','4','5','5','3','3','3','3','3','3','3','3','3',13,'2022-04-22 18:12:53','2022-04-22 18:12:53','TOTAL'),(36,'0','0','0','0','0','0','1','8','1','9','0','0','2','17',14,'2022-08-01 15:42:10','2022-08-01 15:42:10','SHANGHAI'),(37,'0','0','0','0','0','0','1','8','1','9','0','0','2','17',14,'2022-08-01 15:42:10','2022-08-01 15:42:10','TOTAL');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `late_receival_application`
--

CREATE TABLE `late_receival_application` (
  `id_late_receival_application` int(11) NOT NULL AUTO_INCREMENT,
  `vessel_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `voyage_no` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `line_operatior` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `container_no` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `port_of_discharge` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `weight` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reefer` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `oog` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `eta_of_arrival` datetime DEFAULT NULL,
  `transport_company` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agent_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_draft` tinyint(1) NOT NULL DEFAULT '1',
  `liner_code` text COLLATE utf8_unicode_ci,
  `shipping_agent` text COLLATE utf8_unicode_ci,
  `lpo_number` text COLLATE utf8_unicode_ci,
  `attachment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_late_receival_application`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `late_receival_application`
--

INSERT INTO `late_receival_application` VALUES (21,'et','23','tt','4','1','1','no','yes','2022-04-30 13:49:00','fg','Test1','test123','LRA-172','2022-04-22 20:19:39','2022-04-22 20:19:39',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650615579.download.jpg'),(22,'et','23','tt','1','1','1','no','no','2022-04-30 13:49:00','fsdf','Test1','test123','LRA-172','2022-04-22 20:19:39','2022-04-22 20:19:39',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650615579.download.jpg'),(23,'KAMOKUIKI','36','MAT','MATU5421356','SHANGHAI','4.6','no','no','2022-08-04 20:00:00','Williams & Gosling','Chris Vafo\'ou','Chris Vafo\'ou','LRA-188','2022-08-04 14:47:24','2022-08-04 14:47:24',0,'MAT','Williams & Gosling','546512',NULL);

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

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` 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,'2022_01_05_113912_create_user_login_details_table',1),(5,'2022_02_02_064501_add_status_column_to_late_receive',1),(6,'2022_02_02_162745_add_status_column_to_agent_monthly_vessel_form',1),(7,'2022_02_02_170142_add_status_column_to_vessel_berthing_application',1),(8,'2022_02_03_042733_add_status_column_to_cargo_receiving_request_form',1),(9,'2022_02_03_063550_add_status_column_to_status_change_form',1),(10,'2022_02_03_070846_add_status_column_to_terminallimited_domestic_reefer_plugging',1),(11,'2022_02_03_080924_add_status_column_to_reefer_unplugging_request',1),(12,'2022_02_03_081958_add_status_column_to_port_of_discharge_change_form',1),(13,'2022_02_03_083343_add_status_column_to_on_carrier_change_form',1),(14,'2022_02_03_084558_add_status_column_to_vessel_deposit_form',1),(15,'2022_02_03_131409_add_status_column_to_new_submission',1),(16,'2022_02_07_062004_add_new_columns_to_agent_monthly_vessel_form',2),(17,'2022_02_07_091506_add_new_columns_to_vessel_berthing_application',2),(18,'2022_02_07_092952_add_new_columns_to_cargo_receiving_request_form',2),(19,'2022_02_07_105903_add_new_columns_to_status_change_form',2),(20,'2022_02_07_112208_add_new_columns_to_terminallimited_domestic_reefer_plugging',2),(21,'2022_02_07_113739_add_new_columns_to_reefer_unplugging_request',2),(22,'2022_02_07_114756_add_new_columns_to_all_form_table',2),(23,'2022_02_07_153511_add_attachment_column_to_vessel_deposit_form',2);

--
-- Table structure for table `new_submission`
--

CREATE TABLE `new_submission` (
  `id_new_submission` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `port` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_number` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remark` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(16) NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8_unicode_ci,
  `table_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_draft` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_new_submission`)
) ENGINE=InnoDB AUTO_INCREMENT=195 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `new_submission`
--

INSERT INTO `new_submission` VALUES (167,NULL,NULL,'Suva Port','test123','AMV-167','Test1','Good',0,NULL,'agent_monthly_vessel_form','umayangaisuru97@gmail.com','2022-04-22 17:53:19','2022-04-22 17:53:19',0),(168,NULL,NULL,'Suva Port','test123','CRR-168','Test1','Good',0,NULL,'cargo_receiving_request_form','umayangaisuru97@gmail.com','2022-04-22 18:12:53','2022-04-22 18:12:53',0),(169,NULL,NULL,'Suva Port','test123','TDR-169','Test1','Good',0,NULL,'terminallimited_domestic_reefer_plugging','umayangaisuru97@gmail.com','2022-04-22 18:14:34','2022-04-22 18:14:34',0),(171,NULL,NULL,'Suva Port','test123','TDR-171','Test1','Good',0,NULL,'terminallimited_domestic_reefer_plugging','umayangaisuru97@gmail.com','2022-04-22 20:17:28','2022-04-22 20:17:28',0),(172,NULL,NULL,'Suva Port','test123','LRA-172','Test1','Good',0,NULL,'agent_monthly_vessel_form','umayangaisuru97@gmail.com','2022-04-22 20:19:39','2022-04-22 20:19:39',0),(173,NULL,NULL,'Suva Port','reshikat@icloud.com','SCF-173','FPTL','Good',0,NULL,'status_change_form','reshikat@icloud.com','2022-04-25 14:35:12','2022-04-25 14:35:12',0),(174,NULL,NULL,'Suva Port','test123','TDR-174','Test1','Good',0,NULL,'terminallimited_domestic_reefer_plugging','umayangaisuru97@gmail.com','2022-04-25 16:40:21','2022-04-25 16:40:21',0),(175,NULL,NULL,'Suva Port','test123','VBA-175','Test1','Good',0,NULL,'vessel_berthing_application','umayangaisuru97@gmail.com','2022-04-25 17:03:47','2022-04-25 17:03:47',0),(176,NULL,NULL,'Suva Port','test123','VBA-176','Test1','Good',0,NULL,'vessel_berthing_application','umayangaisuru97@gmail.com','2022-04-25 17:16:14','2022-04-25 17:16:14',0),(177,NULL,NULL,'Suva Port','test123','VBA-177','Test1','Good',0,NULL,'vessel_berthing_application','umayangaisuru97@gmail.com','2022-04-25 17:29:13','2022-04-25 17:29:13',0),(178,NULL,NULL,'Suva Port','reshikat@icloud.com','VBA-178','FPTL','Good',0,NULL,'vessel_berthing_application','reshikat@icloud.com','2022-04-26 10:29:21','2022-04-26 10:29:21',0),(179,NULL,NULL,'Suva Port','reshikat@icloud.com','VBA-179','FPTL','Good',0,NULL,'vessel_berthing_application','reshikat@icloud.com','2022-04-26 10:29:31','2022-04-26 10:29:31',0),(180,NULL,NULL,'Suva Port','reshikat@icloud.com','SCF-180','FPTL','Good',0,NULL,'status_change_form','reshikat@icloud.com','2022-04-26 10:38:46','2022-04-26 10:38:46',0),(181,NULL,NULL,'Suva Port','test123','SCF-181','Test1','Good',0,NULL,'status_change_form','umayangaisuru97@gmail.com','2022-04-26 16:01:21','2022-04-26 16:01:21',0),(182,NULL,NULL,'Suva Port','test123','SCF-182','Test1','Good',0,NULL,'status_change_form','umayangaisuru97@gmail.com','2022-04-26 16:07:03','2022-04-26 16:07:03',0),(183,NULL,NULL,'Suva Port','test123','VBA-183','Test1','Good',2,NULL,'vessel_berthing_application','umayangaisuru97@gmail.com','2022-04-29 22:54:31','2022-07-29 14:49:31',0),(184,NULL,NULL,'Suva Port','test123','VBA-184','Test1','Good',2,NULL,'vessel_berthing_application','umayangaisuru97@gmail.com','2022-04-30 00:06:09','2022-07-29 14:49:08',0),(185,NULL,NULL,'Suva Port','Chris Vafo\'ou','AMV-185','Williams & Gosling','Good',0,NULL,'agent_monthly_vessel_form','Christopher.vafoou@wgfiji.com.fj','2022-08-01 15:37:55','2022-08-01 15:37:55',0),(186,NULL,NULL,'Suva Port','Chris Vafo\'ou','CRR-186','Williams & Gosling','Good',0,NULL,'cargo_receiving_request_form','Christopher.vafoou@wgfiji.com.fj','2022-08-01 15:42:10','2022-08-01 15:42:10',0),(187,NULL,NULL,'Suva Port','Chris Vafo\'ou','TDR-187','Williams & Gosling','Good',0,NULL,'terminallimited_domestic_reefer_plugging','Christopher.vafoou@wgfiji.com.fj','2022-08-04 14:38:05','2022-08-04 14:38:05',0),(188,NULL,NULL,'Suva Port','Chris Vafo\'ou','LRA-188','Williams & Gosling','Good',0,NULL,'agent_monthly_vessel_form','Christopher.vafoou@wgfiji.com.fj','2022-08-04 14:47:24','2022-08-04 14:47:24',0),(189,NULL,NULL,'Suva Port','Chris Vafo\'ou','VDF-189','Williams & Gosling','Good',0,NULL,'vessel_deposit_form','Christopher.vafoou@wgfiji.com.fj','2022-08-04 14:56:40','2022-08-04 14:56:40',0),(190,NULL,NULL,'Suva Port','Chris Vafo\'ou','VBA-190','Williams & Gosling','Good',0,NULL,'vessel_berthing_application','Christopher.vafoou@wgfiji.com.fj','2022-08-04 15:05:52','2022-08-04 15:05:52',0),(191,NULL,NULL,'Suva Port','Chris Vafo\'ou','SCF-191','Williams & Gosling','Good',0,NULL,'status_change_form','Christopher.vafoou@wgfiji.com.fj','2022-08-04 15:25:34','2022-08-04 15:25:34',0),(192,NULL,NULL,'Suva Port','Chris Vafo\'ou','RUR-192','Williams & Gosling','Good',0,NULL,'reefer_unplugging_request','Christopher.vafoou@wgfiji.com.fj','2022-08-04 15:30:09','2022-08-04 15:30:09',0),(193,NULL,NULL,'Suva Port','Chris Vafo\'ou','PDC-193','Williams & Gosling','Good',0,NULL,'port_of_discharge_change_form','Christopher.vafoou@wgfiji.com.fj','2022-08-04 15:31:13','2022-08-04 15:31:13',0),(194,NULL,NULL,'Suva Port','Chris Vafo\'ou','OCC-194','Williams & Gosling','Good',0,NULL,'on_carrier_change_form','Christopher.vafoou@wgfiji.com.fj','2022-08-04 15:32:33','2022-08-04 15:32:33',0);

--
-- Table structure for table `on_carrier_change_form`
--

CREATE TABLE `on_carrier_change_form` (
  `id_on_carrier_change_form` int(11) NOT NULL AUTO_INCREMENT,
  `container_no` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `size` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vessel_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `request_change_to` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agent_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_draft` tinyint(1) NOT NULL DEFAULT '1',
  `liner_code` text COLLATE utf8_unicode_ci,
  `shipping_agent` text COLLATE utf8_unicode_ci,
  `lpo_number` text COLLATE utf8_unicode_ci,
  `attachment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_on_carrier_change_form`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `on_carrier_change_form`
--

INSERT INTO `on_carrier_change_form` VALUES (18,'1','20','V1','5545','Test1','test123','OCC-165','2022-04-22 16:28:35','2022-04-22 16:28:35',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650601693.download.jpg'),(19,'2','40','V2','12','Test1','test123','OCC-165','2022-04-22 16:28:35','2022-04-22 16:28:35',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650601693.download.jpg'),(20,'MATU4561234','40','KAMOKUIKI 036','LILOA 45','Chris Vafo\'ou','Chris Vafo\'ou','OCC-194','2022-08-04 15:32:33','2022-08-04 15:32:33',0,'MAT','Williams & Gosling','611421',NULL);

--
-- Table structure for table `port_of_discharge_change_form`
--

CREATE TABLE `port_of_discharge_change_form` (
  `id_port_of_discharge_change_form` int(11) NOT NULL AUTO_INCREMENT,
  `vessel_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `voyage_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `container_no` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `size` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `request_change_form_port_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `request_change_to_port_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agent_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_draft` tinyint(1) NOT NULL DEFAULT '1',
  `liner_code` text COLLATE utf8_unicode_ci,
  `shipping_agent` text COLLATE utf8_unicode_ci,
  `lpo_number` text COLLATE utf8_unicode_ci,
  `attachment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_port_of_discharge_change_form`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `port_of_discharge_change_form`
--

INSERT INTO `port_of_discharge_change_form` VALUES (17,'Capitaine Tasman','067N','TRHU1234567','20','Flatrack','AKL','SUV','Reshika','reshikat@icloud.com','PDC-153','2022-04-13 13:43:13','2022-04-13 13:43:13',0,'NSL','Neptune Pacific Direct Line','12345','uploads/vessel_deposit_attachments/1649814193.11.04.22.pdf'),(18,'et','23','23','20','r','re','er','Test1','test123','PDC-162','2022-04-22 10:53:45','2022-04-22 10:53:45',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650581625.neoMindsLogoNav.png'),(19,'KAMOKUIKI','36','MATU4561234','40','EMPTY','SHA','AKL','Chris Vafo\'ou','Chris Vafo\'ou','PDC-193','2022-08-04 15:31:13','2022-08-04 15:31:13',0,'MAT','Williams & Gosling','611421',NULL);

--
-- Table structure for table `reefer_unplugging_request`
--

CREATE TABLE `reefer_unplugging_request` (
  `id_reefer_unplugging_request` int(11) NOT NULL AUTO_INCREMENT,
  `container_no` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `size` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `unplugging_time` datetime NOT NULL,
  `agent_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_draft` tinyint(1) NOT NULL DEFAULT '1',
  `liner_code` text COLLATE utf8_unicode_ci,
  `shipping_agent` text COLLATE utf8_unicode_ci,
  `lpo_number` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_reefer_unplugging_request`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `reefer_unplugging_request`
--

INSERT INTO `reefer_unplugging_request` VALUES (1,'MATU4561234','40','2022-08-04 09:00:00','Chris Vafo\'ou','Chris Vafo\'ou','RUR-192','2022-08-04 15:30:09','2022-08-04 15:30:09',0,'MAT','Williams & Gosling',NULL);

--
-- Table structure for table `status_change_form`
--

CREATE TABLE `status_change_form` (
  `id_status_change_form` int(11) NOT NULL AUTO_INCREMENT,
  `vessel_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `voyage_number` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `container_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `size` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `original_status` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status_changed` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loading_vessel_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loading_voyage_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agent_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_number` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_draft` tinyint(1) NOT NULL DEFAULT '1',
  `liner_code` text COLLATE utf8_unicode_ci,
  `shipping_agent` text COLLATE utf8_unicode_ci,
  `lpo_number` text COLLATE utf8_unicode_ci,
  `attachment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_status_change_form`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `status_change_form`
--

INSERT INTO `status_change_form` VALUES (17,'et','23','rt','20','Import','Import','er','te','Test1','test123','SCF-160','2022-04-22 09:52:40','2022-04-22 09:52:40',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650577960.download.jpg'),(18,'et','23','rt','20','Import','Import','er','te','Test1','test123','SCF-161','2022-04-22 10:16:57','2022-04-22 10:16:57',0,'COO','Test Agent','123','uploads/vessel_deposit_attachments/1650579417.download.jpg'),(20,'Liloa II','63','ABCD1234567','20','Import','Export','Liloa II','64','Reshika','reshikat@icloud.com','SCF-173','2022-04-25 14:35:12','2022-04-25 14:35:12',0,'PDL','Neptune Pacific Direct Line','123456','uploads/vessel_deposit_attachments/1650854112.LPO # 609196.pdf'),(21,'CAPITAINE TASMAN','067N','ABCD1234567','20','Export','Transhipment','Liloa II','64','Reshika','reshikat@icloud.com','SCF-180','2022-04-26 10:38:46','2022-04-26 10:38:46',0,'PDL','Neptune Pacific Direct Line','123456','uploads/vessel_deposit_attachments/1650926326.LPO # 609196.pdf'),(22,'et','23','rt','20','Import','Import','er','te','Test1','test123','SCF-181','2022-04-26 16:01:21','2022-04-26 16:01:21',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650945681.malani-mart-heel-sticker-dp-2.PNG'),(23,'et','23','rt','40','Export','Export','er','te','Test1','test123','SCF-181','2022-04-26 16:01:21','2022-04-26 16:01:21',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650945681.malani-mart-heel-sticker-dp-2.PNG'),(24,'et','23','rt','20','Import','Export','er','te','Test1','test123','SCF-182','2022-04-26 16:07:03','2022-04-26 16:07:03',0,'COO','Test Agent','123','uploads/vessel_deposit_attachments/1650946023.69902264-58d1a800-1383-11ea-95f7-0d1b6b280db3.png'),(25,'KAMOKUIKI','36','CTAU2120358','20','Import','Export','LILOA','156','Chris Vafo\'ou','Chris Vafo\'ou','SCF-191','2022-08-04 15:25:34','2022-08-04 15:25:34',0,'MAT','Williams & Gosling','611421',NULL);

--
-- Table structure for table `subscriber_details`
--

CREATE TABLE `subscriber_details` (
  `id_subscriber_details` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `port` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact_number` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `featured_img` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_id_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_subscriber_details`),
  UNIQUE KEY `admin_details` (`email`),
  KEY `user_id_user` (`user_id_user`),
  CONSTRAINT `subscriber_details_ibfk_1` FOREIGN KEY (`user_id_user`) REFERENCES `user` (`id_user`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `subscriber_details`
--

INSERT INTO `subscriber_details` VALUES (19,'charaka rajanayake','charaka@candcsn.com','Suva Port','9053590','Suva','C&C Solutions','charaka@candcsn.com',NULL,NULL,'2022-04-06 14:03:39','2022-04-06 14:03:39',92),(20,'Reshika','reshikat@icloud.com','Suva Port','8928516','Suva','FPTL','reshikat@icloud.com',NULL,NULL,'2022-04-13 13:26:06','2022-04-13 13:26:06',94),(21,'Test User','umatec97@gmail.com','Suva Port','0778917921','Suva','Test','Test123',NULL,NULL,'2022-04-13 16:05:57','2022-04-13 16:05:57',95),(22,'fijiportsterminalportal.com ugrfeiohofidsksmvnjdbvsijf94t9u5t0i4r94ijgrjght9y84r49t64rkowf0ereiuguejdkwdiweofuehdskodjjdgofjsoddggfsidj','KsenofontMaidanov+5v6e@mail.ru','Lautoka Port','Uhjkkhkhjk','Lautoka','google','fijiportsterminalportal.com ugrfeiohofidsksmvnjdbvsijf94t9u5t0i4r94ijgrjght9y84r49t64rkowf0ereiuguejdkwdiweofuehdskodjjdgofjsoddggfsidj',NULL,NULL,'2022-04-16 17:41:02','2022-04-16 17:41:02',96),(23,'Test1','umayangaisuru97@gmail.com','Suva Port','0778917927','Suva','Test1','test123',NULL,NULL,'2022-04-20 09:40:30','2022-04-20 09:40:30',97),(24,'Test2','isurumayangaliyanarachchi@gmail.com','Suva Port','0778917929','Suva','Test12','test2',NULL,NULL,'2022-04-20 10:15:29','2022-04-20 10:15:29',98),(25,'Elena','elena@fijiports.com.fj','Suva Port','8928516','Suva','FPTL','elena@fijiports.com.fj',NULL,NULL,'2022-07-14 15:51:55','2022-07-14 15:51:55',99),(26,'Chris Vafo\'ou','Christopher.vafoou@wgfiji.com.fj','Suva Port','+6797777988','Suva','Williams & Gosling','Chris Vafo\'ou',NULL,NULL,'2022-07-14 16:10:08','2022-07-14 16:10:08',100),(27,'RESHIKA ROSHLYN LATA','reshika@fijiports.com.fj','Suva Port','+6799213963','Suva','FPTL','Reshika Lata',NULL,NULL,'2022-07-29 14:56:10','2022-07-29 14:56:10',101),(28,'WAQABACA TAGIMURI','ckpfiji@yahoo.com','Suva Port','9992525','Suva','CKP SHIPPING CO. PTE LTD','waqa.tagimuri',NULL,NULL,'2022-09-01 10:05:41','2022-09-01 10:05:41',102);

--
-- Table structure for table `terminallimited_domestic_reefer_plugging`
--

CREATE TABLE `terminallimited_domestic_reefer_plugging` (
  `id_terminallimited_domestic_reefer_plugging` int(11) NOT NULL AUTO_INCREMENT,
  `vessel_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `voyage_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `container_status` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `order_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `port` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `container_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `size` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `set_temperature` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `plugging_date` datetime DEFAULT NULL,
  `remarks` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agent_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `plugging_or_vessel` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_draft` tinyint(1) NOT NULL DEFAULT '1',
  `liner_code` text COLLATE utf8_unicode_ci,
  `shipping_agent` text COLLATE utf8_unicode_ci,
  `lpo_number` text COLLATE utf8_unicode_ci,
  `attachment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_terminallimited_domestic_reefer_plugging`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `terminallimited_domestic_reefer_plugging`
--

INSERT INTO `terminallimited_domestic_reefer_plugging` VALUES (44,'V1','trr','Laden','23','34',NULL,NULL,NULL,NULL,NULL,'Test1','test123','vessel','TDR-158','2022-04-20 09:51:20','2022-04-20 09:51:20',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650405080.download.jpg'),(45,NULL,NULL,NULL,NULL,NULL,'rt','20','rt','2022-04-28 00:00:00','rtr','Test1','test123','plugging','TDR-158','2022-04-20 09:51:20','2022-04-20 09:51:20',0,'PDL','Test Agent','123',NULL),(46,'V1','trr','Laden','23','34',NULL,NULL,NULL,NULL,NULL,'Test1','test123','vessel','TDR-159','2022-04-20 10:23:11','2022-04-20 10:23:11',0,'COO','Test Agent','07568','uploads/vessel_deposit_attachments/1650406991.download.jpg'),(47,NULL,NULL,NULL,NULL,NULL,'rt','20','rt','2022-04-21 00:00:00','rtr','Test1','test123','plugging','TDR-159','2022-04-20 10:23:11','2022-04-20 10:23:11',0,'COO','Test Agent','07568',NULL),(48,'Test Name','trr','Empty','23','34',NULL,NULL,NULL,NULL,NULL,'Test1','test123','vessel','TDR-169','2022-04-22 18:14:34','2022-04-22 18:14:34',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650608074.download.jpg'),(49,'1','1','Empty','23','34',NULL,NULL,NULL,NULL,NULL,'Test1','test123','vessel','TDR-169','2022-04-22 18:14:34','2022-04-22 18:14:34',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650608074.download.jpg'),(50,NULL,NULL,NULL,NULL,NULL,'rt','40','rt','2022-04-28 00:00:00','rtr','Test1','test123','plugging','TDR-169','2022-04-22 18:14:34','2022-04-22 18:14:34',0,'PDL','Test Agent','123',NULL),(51,NULL,NULL,NULL,NULL,NULL,'1','20','rt','2022-04-29 00:00:00','11','Test1','test123','plugging','TDR-169','2022-04-22 18:14:34','2022-04-22 18:14:34',0,'PDL','Test Agent','123',NULL),(56,'V1','trr','Laden','23','34',NULL,NULL,NULL,NULL,NULL,'Test1','test123','vessel','TDR-171','2022-04-22 20:17:28','2022-04-22 20:17:28',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650615448.download.jpg'),(57,'Test Name','1','Empty','23','1',NULL,NULL,NULL,NULL,NULL,'Test1','test123','vessel','TDR-171','2022-04-22 20:17:28','2022-04-22 20:17:28',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650615448.download.jpg'),(58,NULL,NULL,NULL,NULL,NULL,'rt','20','rt','2022-04-30 00:00:00','rtr','Test1','test123','plugging','TDR-171','2022-04-22 20:17:28','2022-04-22 20:17:28',0,'PDL','Test Agent','123',NULL),(59,NULL,NULL,NULL,NULL,NULL,'11','40','rt','2022-04-29 00:00:00','11','Test1','test123','plugging','TDR-171','2022-04-22 20:17:28','2022-04-22 20:17:28',0,'PDL','Test Agent','123',NULL),(60,'V1','trr','Laden','23','34',NULL,NULL,NULL,NULL,NULL,'Test1','test123','vessel','TDR-174','2022-04-25 16:40:21','2022-04-25 16:40:21',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650861621.malani-mart-heel-sticker-dp-1.PNG'),(61,'V2','1','Empty','1','1',NULL,NULL,NULL,NULL,NULL,'Test1','test123','vessel','TDR-174','2022-04-25 16:40:21','2022-04-25 16:40:21',0,'PDL','Test Agent','123','uploads/vessel_deposit_attachments/1650861621.malani-mart-heel-sticker-dp-1.PNG'),(62,NULL,NULL,NULL,NULL,NULL,'rt','20','rt','2022-04-29 00:00:00','11','Test1','test123','plugging','TDR-174','2022-04-25 16:40:21','2022-04-25 16:40:21',0,'PDL','Test Agent','123',NULL),(63,NULL,NULL,NULL,NULL,NULL,'11','40','11','2022-04-27 00:00:00','rtr','Test1','test123','plugging','TDR-174','2022-04-25 16:40:21','2022-04-25 16:40:21',0,'PDL','Test Agent','123',NULL),(64,'Olomana','139','Laden','611421','Suva',NULL,NULL,NULL,NULL,NULL,'Chris Vafo\'ou','Chris Vafo\'ou','vessel','TDR-187','2022-08-04 14:38:05','2022-08-04 14:38:05',0,'COO','Williams & Gosling','611421','uploads/vessel_deposit_attachments/1659580685.NPDL-SU2-OPS_20220722_125925.pdf'),(65,NULL,NULL,NULL,NULL,NULL,'CTAU2120358','20','-20','2022-07-22 00:00:00','Upon Discharge','Chris Vafo\'ou','Chris Vafo\'ou','plugging','TDR-187','2022-08-04 14:38:05','2022-08-04 14:38:05',0,'COO','Williams & Gosling','611421',NULL),(66,NULL,NULL,NULL,NULL,NULL,'PDLU7000631','20','-20','1970-01-01 12:00:00','Upon Discharge','Chris Vafo\'ou','Chris Vafo\'ou','plugging','TDR-187','2022-08-04 14:38:05','2022-08-04 14:38:05',0,'COO','Williams & Gosling','611421',NULL),(67,NULL,NULL,NULL,NULL,NULL,'PDLU7000858','20','-20','1970-01-01 12:00:00','Upon Discharge','Chris Vafo\'ou','Chris Vafo\'ou','plugging','TDR-187','2022-08-04 14:38:05','2022-08-04 14:38:05',0,'COO','Williams & Gosling','611421',NULL);

--
-- Table structure for table `user_login_details`
--

CREATE TABLE `user_login_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `port` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_login_details`
--

INSERT INTO `user_login_details` VALUES (16,'suvshipplanning@fijiports.com.fj','Suva Port','2022-04-13 15:41:25','2022-04-13 15:41:25');

--
-- Table structure for table `vessel_berthing_application`
--

CREATE TABLE `vessel_berthing_application` (
  `id_vessel_berthing_application` int(11) NOT NULL AUTO_INCREMENT,
  `vessel_code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `voyage_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loa` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `service_code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `voyage_no` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vessel_referance` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `arrival_draft` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `department_draft` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `aft1` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `aft2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `eta` datetime NOT NULL,
  `purpose_of_call` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lpc` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `npc` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_containers1` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_containers2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_vehicles1` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_vehicles2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_break1` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_break2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `liquid_qty1` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `liquid_qty2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `berthing_request` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agent_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_number` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `discharging` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loading` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `heavy_lift_val` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `row_stow_val` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dangerous_val` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `oog_val` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `security_val` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_draft` tinyint(1) NOT NULL DEFAULT '1',
  `liner_code` text COLLATE utf8_unicode_ci,
  `shipping_agent` text COLLATE utf8_unicode_ci,
  `lpo_number` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_vessel_berthing_application`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vessel_berthing_application`
--

INSERT INTO `vessel_berthing_application` VALUES (13,'cpt','capitaine tasman','180m','esea','067n','scpt067n','8m','8m','8m','8m','2022-04-15 06:00:00','Discharging Loading','akl','ltk','250','100','0','0','0','0','0','0','on arrival','Reshika','reshikat@icloud.com','VBA-154','2022-04-13 14:14:44','2022-04-13 14:14:44','2','2','y','y','y','y','y',0,'PDL','Neptune Pacific Direct Line',NULL),(14,'cpt','capitaine tasman','180m','esea','067n','scpt067n','8m','8m','8m','8m','2022-04-15 06:00:00','Discharging Loading','akl','ltk','250','100','0','0','0','0','0','0','on arrival','Reshika','reshikat@icloud.com','VBA-155','2022-04-13 14:14:45','2022-04-13 14:14:45','2','2','y','y','y','y','y',0,'PDL','Neptune Pacific Direct Line',NULL),(15,'11','22','313','wq','23','313','323','3123','21','23','2022-04-27 10:33:00','Discharging Loading','23','32','3213','312','23','232','312','323','321','32','2131','Test1','test123','VBA-175','2022-04-25 17:03:47','2022-04-25 17:03:47','ewr','er','y','y','y','y','y',0,'PDL','Test Agent',NULL),(16,'11','22','313','wq','23','313','323','3123','21','23','2022-04-27 10:45:00','Diplomatic','23','32','3213','312','23','232','312','323','321','32','2131','Test1','test123','VBA-176','2022-04-25 17:16:14','2022-04-25 17:16:14','ewr','er','y','y','y','y','y',0,'COO','Test Agent',NULL),(17,'11','22','313','wq','23','313','323','3123','21','23','2022-04-29 10:58:00','Bunkering','23','32','3213','312','23','232','312','323','321','32','2131','Test1','test123','VBA-177','2022-04-25 17:29:13','2022-04-25 17:29:13','ewr','er','y','y','y','y','y',0,'COO','Test Agent',NULL),(18,'CPT','CAPITAINE TASMAN','184M','NZPAC','046N','SCPT046N','8M','8.5M','8M','9M','2022-04-01 10:26:00','Discharging Loading','AKL','LTK','250','400','0','0','0','0','0','0','ON ARRIVAL','Reshika','reshikat@icloud.com','VBA-178','2022-04-26 10:29:21','2022-04-26 10:29:21','3','3','y','y','y','y','y',0,'PDL','NEPTUNE PACIFIC DIRECT LINE',NULL),(19,'CPT','CAPITAINE TASMAN','184M','NZPAC','046N','SCPT046N','8M','8.5M','8M','9M','2022-04-01 10:26:00','Discharging Loading','AKL','LTK','250','400','0','0','0','0','0','0','ON ARRIVAL','Reshika','reshikat@icloud.com','VBA-179','2022-04-26 10:29:31','2022-04-26 10:29:31','3','3','y','y','y','y','y',0,'PDL','NEPTUNE PACIFIC DIRECT LINE',NULL),(20,'11','22','313','wq','23','313','323','3123','21','23','2022-04-30 16:24:00','Loading','23','32','3213','312','23','232','312','323','321','32','2131','Test1','test123','VBA-183','2022-04-29 22:54:31','2022-04-29 22:54:31','ewr','er','y','y','y','y','y',0,'PDL','Test Agent',NULL),(21,'11','Testing vesel name','121','1111','1212','1212121','121','212','2222','2222','2022-05-07 22:40:00','Bunkering','121','111','1212','2121','2122','2122','1212','2121','2122','2121','Testing1212121212121','Test1','test123','VBA-184','2022-04-30 00:06:09','2022-04-30 00:06:09','1212','1212','y','y','y','y','y',0,'COO','Liyana Arachchige Isuru',NULL),(22,'kkm','kamokuiki','132.2','PACIS','36','skkm36','5.3','6.7','7.2','7.3','2022-08-03 09:00:00','Discharging Loading','akl','sha','40','42','1','2','2','1','1','2','centre kings','Chris Vafo\'ou','Chris Vafo\'ou','VBA-190','2022-08-04 15:05:52','2022-08-04 15:05:52','2','2','n','y','n','n','n',0,'MAT','Williams & Gosling',NULL);

--
-- Table structure for table `vessel_deposit_form`
--

CREATE TABLE `vessel_deposit_form` (
  `id_vessel_deposit_form` int(11) NOT NULL AUTO_INCREMENT,
  `vessel_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `eta` datetime NOT NULL,
  `voyage_no` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `port` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `etd` datetime DEFAULT NULL,
  `rotations_no` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltk` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `grt` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `online_ref_num` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agent_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_draft` tinyint(1) NOT NULL DEFAULT '1',
  `liner_code` text COLLATE utf8_unicode_ci,
  `shipping_agent` text COLLATE utf8_unicode_ci,
  `lpo_number` text COLLATE utf8_unicode_ci,
  `attachment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_vessel_deposit_form`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vessel_deposit_form`
--

INSERT INTO `vessel_deposit_form` VALUES (1,'KAMOKUIKI','2022-08-03 09:00:00','36','Suva','2022-08-04 10:00:00','183',NULL,'6,368','611421','Chris Vafo\'ou','Chris Vafo\'ou','VDF-189','2022-08-04 14:56:40','2022-08-04 14:56:40',0,'MAT','Williams & Gosling','611421',NULL);

--
-- Table structure for table `vessel_deposit_form_data`
--

CREATE TABLE `vessel_deposit_form_data` (
  `id_vessel_deposit_form_data` int(11) NOT NULL AUTO_INCREMENT,
  `row_ref` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qty` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `amount` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `in_or_out` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vessel_deposit_form_id_vessel_deposit_form` int(64) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id_vessel_deposit_form_data`),
  KEY `vessel_deposit_form_id_vessel_deposit_form` (`vessel_deposit_form_id_vessel_deposit_form`),
  CONSTRAINT `vessel_deposit_form_data_ibfk_1` FOREIGN KEY (`vessel_deposit_form_id_vessel_deposit_form`) REFERENCES `vessel_deposit_form` (`id_vessel_deposit_form`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vessel_deposit_form_data`
--

INSERT INTO `vessel_deposit_form_data` VALUES (1,'fcl_20','16',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(2,'fcl_40','5',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(3,'emp_20','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(4,'emp_40','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(5,'fcl_trans_20','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(6,'fcl_trans_40','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(7,'fcl_restow_20','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(8,'fcl_restow_40','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(9,'emp_restow_20','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(10,'emp_restow_40','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(11,'fcl_sob_20','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(12,'fcl_sob_40','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(13,'emp_sob_20','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(14,'emp_sob_40','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(15,'oog_20','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(16,'oog_40','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(17,'breakbulk','21',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(18,'master_packs','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(19,'steel','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(20,'vehicles','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(21,'dry_bulk','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(22,'others','1',NULL,'in',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(23,'fcl_20','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(24,'fcl_40','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(25,'emp_20','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(26,'emp_40','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(27,'fcl_trans_20','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(28,'fcl_trans_40','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(29,'fcl_restow_20','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(30,'fcl_restow_40','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(31,'emp_restow_20','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(32,'emp_restow_40','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(33,'fcl_sob_20','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(34,'fcl_sob_40','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(35,'emp_sob_20','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(36,'emp_sob_40','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(37,'oog_20','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(38,'oog_40','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(39,'breakbulk','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(40,'master_packs','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(41,'steel','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(42,'vehicles','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(43,'dry_bulk','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40'),(44,'others','1',NULL,'out',1,'2022-08-04 14:56:40','2022-08-04 14:56:40');


