-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 04, 2024 at 08:27 AM
-- Server version: 10.6.17-MariaDB-cll-lve
-- PHP Version: 8.1.27

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `gearcloudtech_cisnstudentportal`
--

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

--
-- Table structure for table `carryover_courses`
--

CREATE TABLE `carryover_courses` (
  `id` int(11) NOT NULL,
  `sname` varchar(255) NOT NULL,
  `Dept` varchar(255) NOT NULL,
  `leveld` varchar(255) NOT NULL,
  `leveld_id` int(11) NOT NULL,
  `course_title` varchar(255) NOT NULL,
  `course_code` varchar(255) NOT NULL,
  `course_unit` varchar(255) NOT NULL,
  `course_status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `carryover_courses`
--

INSERT INTO `carryover_courses` (`id`, `sname`, `Dept`, `leveld`, `leveld_id`, `course_title`, `course_code`, `course_unit`, `course_status`) VALUES
(12, 'austin', '', '', 5, 'COMPUTER APPREC & LIBRARY', 'COM 101', '2', 'Core'),
(13, 'austin', '', '', 5, 'MARITIME GEOGRAPHY', 'COM 111', '3', 'Core'),
(14, 'austin', '', '', 5, 'FRENCH LANGUAGE', 'MRN 111', '3', 'Core');

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `course_id` int(255) NOT NULL,
  `department_id` int(11) NOT NULL,
  `leveld_id` int(11) NOT NULL,
  `course_title` varchar(255) NOT NULL,
  `course_code` varchar(255) NOT NULL,
  `course_unit` varchar(255) NOT NULL,
  `course_Status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`course_id`, `department_id`, `leveld_id`, `course_title`, `course_code`, `course_unit`, `course_Status`) VALUES
(1, 1, 1, 'FUNDAMENTER OF SHIPPING', 'ASS 101', '3', 'Core'),
(2, 1, 1, 'SHIPPING ECONOMICS', 'ASS 102', '3', 'Core'),
(3, 1, 1, 'QUANTITATIVE METHODS ', 'ASS 103', '3', 'Core'),
(4, 1, 1, 'BUSINESS COMMS. SKILL', 'ASS 104', '3', 'Core'),
(5, 1, 1, 'FREIGHT FORWARDING', 'ASS 105', '3', 'Core'),
(6, 1, 1, 'INTRODUCTION TO TRANSPORT', 'ASS 106', '3', 'Core'),
(8, 1, 2, 'BASIC MGT. IN SHIPPING', 'ASS 201', '2', 'Core'),
(9, 1, 2, 'STATISTICS IN SHIPPING', 'ASS 202', '3', 'Core'),
(10, 1, 2, 'PORT OPERATION & DOCKWORKERS PRACTICE', 'ASS 203', '3', 'Core'),
(11, 1, 2, 'MARKETING PRACTICE', 'ASS 204', '3', 'Core'),
(12, 1, 2, 'MARITIME INSURANCE', 'ASS 205', '3', 'Core'),
(13, 1, 2, 'CARGO HANDLING (SEA & AIR)', 'ASS 206', '3', 'Core'),
(14, 1, 3, 'INT’ TRADE & SHIPPING LAW ', 'ASS 301', '3', 'Core'),
(15, 1, 3, 'FIN/MGT ACCOUNTING', 'ASS 302', '2', 'Core'),
(16, 1, 3, 'SHIPPING PRACT / SHIP BROKING', 'ASS 303', '2', 'Core'),
(17, 1, 3, 'SAFETY & ENVIRONMENT ', 'ASS 304', '2', 'Core'),
(18, 1, 3, 'HUMAN RESOURCE MGT ', 'ASS 305', '2', 'Core'),
(19, 1, 3, 'RESEARCH METHOD', 'ASS 306', '3', 'Core'),
(20, 1, 4, 'SHIPPING MANAGEMENT', 'ASS 401', '2', 'Core'),
(21, 1, 4, 'PORT MANAGEMENT', 'ASS 402', '3', 'Core'),
(22, 1, 4, 'MULTI-MODAL TRANSPORT', 'ASS 403', '3', 'Core'),
(23, 1, 4, 'LOGISTICS & SUPPLY CHAIN MGT', 'ASS 404', '3', 'Core'),
(24, 1, 4, 'MARITIME ARB&CONFLICT/DISPUTE RESOLUTION', 'ASS 405', '2', 'Core'),
(25, 1, 4, 'MARITIME/SHIPPING LAW', 'ASS 406', '2', 'Core'),
(26, 2, 5, 'COMPUTER APPREC & LIBRARY', 'COM 101', '2', 'Core'),
(27, 2, 5, 'MARITIME GEOGRAPHY', 'COM 111', '3', 'Core'),
(28, 2, 5, 'FRENCH LANGUAGE', 'MRN 111', '3', 'Core'),
(30, 2, 5, 'MARITIME ECONOMICS', 'SHM 112', '3', 'Core'),
(31, 2, 5, 'GEN.SHIPPING KNOWLEDGE', 'SHM 113', '3', 'Core'),
(32, 2, 5, 'PRINCIPLES OF ACCOUNTING', 'SHM 114', '3', 'Core'),
(33, 2, 5, 'PRINCIPLES OF MANAGEMENT', 'SHM 115', '3', 'Core'),
(34, 2, 5, 'PRINCIPLES OF LAW', 'SHM 116', '3', 'Core'),
(35, 2, 5, 'BUSINESS MATHEMATICS', 'MAT 241', '2', 'Core'),
(36, 2, 5, 'USE OF ENGLISH', 'CSK 401', '4', 'Core'),
(37, 2, 6, 'USE OF COMPUTER ', 'COM 111', '3', 'Core'),
(38, 2, 6, 'INTRO TO MULTIMODAL TRANSPT.', 'SHM 117', '3', 'Core'),
(39, 2, 6, 'FRENCH LANG.II', 'MRN 121', '3', 'Core'),
(40, 2, 6, 'MARINE ENVIRN. PROTECTION', 'SHM 121', '3', 'Core'),
(41, 2, 6, 'MARITIME ECONOMICS II', 'SHM 123', '3', 'Core'),
(42, 2, 6, 'PORT OPERATION & MGT.', 'SHM 124', '3', 'Core'),
(43, 2, 6, 'BASIC COST ACCTING', 'SHM 125', '3', 'Core'),
(44, 2, 6, 'MARITIME GEOGRAPHY II', 'SHM 126', '3', 'Core'),
(45, 2, 6, 'BUSINESS MATHS II', 'MAT 252', '2', 'Core'),
(46, 2, 6, 'COMMUNICATION SKILLS ', 'CSK 402', '3', 'Core'),
(47, 2, 7, 'RESEARCH METHODOLOGY', 'SHM 116', '3', 'Core'),
(48, 2, 7, 'INTRO. TO ENTREPRENEUR', 'EPD 201', '3', 'Core'),
(49, 2, 7, 'MARITIME LAW', 'SHM 211', '3', 'Core'),
(50, 2, 7, 'PORT OPERATION & MGT II', 'SHM 212', '3', 'Core'),
(51, 2, 7, 'EXPORT MGT', 'SHM 213', '3', 'Core'),
(52, 2, 7, 'PURCHASING PRACTICE', 'SHM 213', '3', 'Core'),
(53, 2, 7, 'INT. TRADE & PAYMENT', 'SHM 215', '2', 'Core'),
(54, 2, 7, 'MARITIME SECURITY', 'SMT 222', '2', 'Core'),
(55, 2, 7, 'MARITIME COMMUNICATION', 'CSK 501', '3', 'Core'),
(56, 2, 7, 'LOGISTICS & SUPPLY CHAINS ', 'SMT 224', '3', 'Core'),
(57, 2, 8, 'MARINE INSURANCE ', 'SHM 211', '3', 'Core'),
(58, 2, 8, 'PRINCIPLES & PRACTICE OF SHI.', 'SHM 222', '3', 'Core'),
(59, 2, 8, 'FRIGHT FORWARDING PRACTICE ', 'SHM 223', '3', 'Core'),
(60, 2, 8, 'PRACTICE OF MARKETING ', 'SHM 224', '3', 'Core'),
(61, 2, 8, 'MARITIME LAW II', 'SHM 225', '3', 'Core'),
(62, 2, 8, 'MARITIME TRANSPORT', 'SHM 227', '3', 'Core'),
(63, 2, 8, 'COMMUNICATION', 'CSK 502', '2', 'Core'),
(64, 3, 9, 'FUNDAMENTER OF SHIPPING', 'ASS 101', '2', 'Core'),
(65, 3, 9, 'SHIPPING ECONOMICS', 'ASS 102', '3', 'Core'),
(66, 3, 9, 'QUANTITATIVE METHODS ', 'ASS 103', '3', 'Core'),
(67, 3, 9, 'BUSINESS COMMS. SKILL', 'ASS 104', '3', 'Core'),
(68, 3, 9, 'FREIGHT FORWARDING', 'ASS 105', '3', 'Core'),
(69, 3, 9, 'INTRODUCTION TO TRANSPORT', 'ASS 106', '4', 'Core'),
(70, 3, 10, 'BASIC MGT. IN SHIPPING', 'ASS 201', '3', 'Core'),
(71, 3, 10, 'STATISTICS IN SHIPPING', ' ASS 202', '2', 'Core'),
(72, 3, 10, 'PORT OPERATION & DOCKWORKERS PRACTICE', 'ASS 203', '2', 'Core'),
(73, 3, 10, 'MARKETING PRACTICE', 'ASS 204', '2', 'Core'),
(74, 3, 10, 'MARITIME INSURANCE', 'ASS 205', '2', 'Core'),
(75, 3, 10, 'CARGO HANDLING (SEA & AIR)lementary Trigonometry', 'ASS 206', '2', 'Core'),
(76, 3, 11, 'INT’ TRADE & SHIPPING LAW ', 'ASS 301', '3', 'Core'),
(77, 3, 11, 'FIN/MGT ACCOUNTING', 'ASS 302', '3', 'Core'),
(78, 3, 11, 'SHIPPING PRACT / SHIP BROKING', 'ASS 303', '3', ' Core'),
(79, 3, 11, 'SAFETY & ENVIRONMENT ', 'ASS 304', '3', ' Core'),
(80, 3, 11, 'HUMAN RESOURCE MGT ', 'ASS 305', '3', ' Core'),
(81, 3, 11, 'RESEARCH METHOD', 'ASS 306', '3', ' Core'),
(82, 3, 12, 'SHIPPING MANAGEMENT', 'ASS 401', '3', ' Core'),
(83, 3, 12, 'PORT MANAGEMENT', 'ASS 402', '2', ' Core'),
(84, 3, 12, 'MULTI-MODAL TRANSPORT', 'ASS 403', '2', ' Core'),
(85, 3, 12, 'LOGISTICS & SUPPLY CHAIN MGT', 'ASS 404', '2', ' Core'),
(86, 3, 12, 'MARITIME ARB&CONFLICT/DISPUTE RESOLUTION', 'ASS 405', '2', ' Core'),
(87, 3, 12, 'MARITIME/SHIPPING LAW', 'ASS 406', '3', ' Core'),
(88, 4, 13, 'INTRO PORTS FACILITY SECURITY   ', 'ASMT 101', '3', ' Core'),
(89, 4, 13, 'DEVELOPMENT OF SECURITY TECTH  ', 'ASMT 102', '3', ' Core'),
(90, 4, 13, 'AVIATION INDUSTRY & SECURITY', 'ASMT 103', '3', ' Core'),
(91, 4, 13, 'BUSINESS COMMUNICATION', 'ASMT 104', '3', ' Core'),
(92, 4, 13, 'CROWED & RIOT DAMMAGE COUTROL', 'ASMT 105', '3', ' Core'),
(93, 4, 13, 'SECURITY INVESIGATION REPORT WRITTING', 'ASMT 106', '3', ' Core'),
(94, 4, 14, 'I.C.T', 'ASMT 201', '3', ' Core'),
(95, 4, 14, 'RISK ASSESSMENT', 'ASMT 202', '2', ' Core'),
(96, 4, 14, 'MANAGEMENT PRINCIPLES & PRACTICE', 'ASMT 203', '2', ' Core'),
(97, 4, 14, 'CORPORATE INFRASTURES MGT', 'ASMT 203', '2', ' Core'),
(98, 4, 14, 'CONFLICTS RESOLUTION MGT', 'ASMT 205', '2', ' Core'),
(99, 4, 14, 'TRANSNATIONAL ORGANISED CRIME & INSURGENCY', 'ASMT 206', '3', ' Core'),
(100, 4, 15, 'ADVANCED ELECTRONIC SECURITY MGT', 'ASMT 301 ', '2', ' Core'),
(101, 4, 15, 'GENERAL SECURITY FACILITY MGT', 'ASMT 302', '3', ' Core'),
(102, 4, 15, 'RESEACH METHODOLOGY', 'ASMT 303', '3', ' Core'),
(103, 4, 15, 'ORGANIZATIONAL BEHAVIOUR IN SECURITY ', 'ASMT 304', '3', ' Core'),
(104, 4, 15, 'HUMAN RESOURCES MGT IN SECURITY', 'ASMT 305 ', '3', ' Core'),
(105, 4, 15, 'SECURITY SYSTEM TECHNOLOGY MGT', 'ASMT 306', '3', ' Core'),
(106, 4, 16, 'INTERAGENCY SECURITY OPERATION MGT', 'ASMT 401', '2', ' Core'),
(107, 4, 16, 'NIG AVIATION STRUCTURE & SECURITY', 'ASMT 402', '2', ' Core'),
(108, 4, 16, 'COOPERATE GOVERNANCE & ETHICS', 'ASMT  403', '2', ' Core'),
(109, 4, 16, 'SECURITY LOGISTIC & SUPPLY', 'ASMT 404', '2', ' Core'),
(110, 4, 16, 'MULTI-MODAL TRANSPORT IN SECURITY', 'ASMT 405', '3', ' Core'),
(111, 4, 16, 'MARITIME SAFETY & SECURITY', 'ASMT 406', '3', ' Core'),
(112, 5, 17, 'QUANTITATIVE TECH.', 'SHIP 602', '2', ' Core'),
(113, 5, 17, 'TRANSPORT MGT.', 'SHIP 603', '3', ' Core'),
(114, 5, 17, 'FREIGHTFORWARDING', 'SHIP 604', '4', ' Core'),
(115, 5, 17, 'MARITIME INSURANCE', 'SHIP 605', '2', ' Core'),
(116, 5, 17, 'ACCOUNTING FOR MANAGERS', 'SHIP 606', '2', ' Core'),
(117, 5, 17, 'RESEARCH METHOD', 'SHIP 607', '2', ' Core'),
(118, 5, 18, 'MARITIME ADMINISTRATION', 'SHIP 620', '3', ' Core'),
(119, 5, 18, 'SHIPPING MGT ', 'SHIP 621', '3', ' Core'),
(120, 5, 18, 'PORT MANAGEMENT ', 'SHIP 622', '2', ' Core'),
(121, 5, 18, 'LOGISTICS', 'SHIP 623', '2', ' Core'),
(122, 5, 18, 'MARITIME LAW', 'SHIP 625', '2', ' Core'),
(123, 5, 18, 'GENERAL SECURITY', 'SHIP 626', '3', ' Core'),
(124, 5, 18, 'MANAGERIAL/ TRANSPORT ECONS', 'SHIP 627', '3', ' Core'),
(125, 5, 18, 'SAFETY MGT. COMPARATIVE ISSUES', 'SHIP 628', '2', ' Core'),
(126, 5, 18, 'OCCUPATIONAL HEALTH', 'SHIP 629', '2', ' Core'),
(127, 5, 18, 'ENVIRN. ISSUES & IMPACT ASSMT', 'SHIP 630', '2', ' Core'),
(128, 5, 18, 'MARITIME ARB & CONFLICT RESOLUTION', 'SHIP 620', '2', ' Core'),
(129, 6, 19, 'USE OF ENGLISH ', 'GNS 101', '2', ' Core'),
(130, 6, 19, 'FREACH', 'MRS 101', '2', ' Core'),
(131, 6, 19, 'GENERAL MATHEMATICS', 'MTH 101', '2', ' Core'),
(132, 6, 19, 'COMPUTER APPRECIATION ', 'COM 101', '4', ' Core'),
(133, 6, 19, 'TECHNICAL DRAWING', 'MEC 101', '3', ' Core'),
(134, 6, 19, 'ELECTRICAL ENGINEERING', 'IEE 101', '4', ' Core'),
(135, 6, 19, 'ARC WELDING ', 'IME 101 ', '4', ' Core'),
(136, 6, 19, 'MECHANICAL ENGINEERING ', 'MEC 103', '4', ' Core'),
(137, 6, 19, 'MARINE POLLUTION', 'IME 103 ', '2', ' Core'),
(138, 6, 19, 'WORKSHOP TECHNOLOGY ', 'MEC 105', '3', ' Core'),
(139, 6, 20, 'ASSEMBLY DRAWING & DEVELOPMENT', 'MEC 101', '3', ' Core'),
(140, 6, 20, 'COMMUNICATION SKILLS', 'MRN 102', '2', ' Core'),
(141, 6, 20, 'FRENCH', 'MRN 103', '2', ' Core'),
(142, 6, 20, 'CALCULUS', 'IEE 102', '2', ' Core'),
(143, 6, 20, 'SHIP FAMILIARIZATION', 'IME 102', '4', ' Core'),
(144, 6, 20, 'GAS WELDING ', 'IME 104', '3', ' Core'),
(145, 6, 20, 'THERMODYNAMICS', 'MEC 104', '4', ' Core'),
(146, 6, 20, 'ENGINEERING MATERIALS', 'MEC 106', '3', ' Core'),
(147, 6, 20, 'WORKSHOP TECHNOLOGY', 'MEC 108', '3', ' Core'),
(148, 6, 21, 'ENTREPRENEURSHIP DEVELOP', 'GNS 201', '2', ' Core'),
(149, 6, 21, 'AUTOCAD', 'IME 201', '3', ' Core'),
(150, 6, 21, 'ENGINEERING MEASUREMENT', 'MEC 201', '3', 'Core'),
(151, 6, 21, 'TRIGONOMETRY & ANALYTICAL', 'MTH 201', '2', 'Core'),
(152, 6, 21, 'FRENCH ', 'MRN 203', '2', 'Core'),
(153, 6, 21, 'STRENGTH OF MATERIALS	', 'MEC 203', '4', 'Core'),
(154, 6, 21, 'NAVAL ARCHITECTURE	', 'IME 203', '3', 'Core'),
(155, 6, 21, 'FLUID MECHANICS	', 'MEC 205', '4', 'Core'),
(156, 6, 21, 'MARINE ENGINES	', 'MEC 205', '4', 'Core'),
(157, 6, 21, 'FIRE PREVENTION	', 'IME 209', '2', 'Core'),
(158, 6, 21, 'INTRO TO RESEARCH METHOD	', 'SHM 216', '2', 'Core'),
(159, 6, 22, 'ENTERPRENEURSHIP DEVELOP	', 'GNS 202', '2', 'Core'),
(160, 6, 22, 'AUTOCAD	', 'IME 202', '3', 'Core'),
(161, 6, 22, 'MARINE REFRIGERATION	', 'IME 204 ', '4', 'Core'),
(162, 6, 22, 'MARINE PLANT SERVICE 	', 'IME 206', '4', 'Core'),
(163, 6, 22, 'MARINE AUXILIARY MACH	', 'IME 208', '4', 'Core'),
(164, 6, 22, 'SHIP YARD TECHNOLOGY	', 'IME 210', '4', 'Core'),
(165, 6, 22, 'FINAL YEAR PROJECT	', 'IME 216', '6', 'Core'),
(166, 6, 22, 'MARITIME TRANSPORT	', 'SHM 227', '2', 'Core'),
(167, 7, 23, 'USE OF ENGLISH	', 'SMT 101', '2', 'Core'),
(168, 7, 23, 'FRENCH	', 'MRN 101', '2', 'Core'),
(169, 7, 23, 'MATHEMATICS	', 'MAT 101', '2', 'Core'),
(170, 7, 23, 'INTRODUCTION TO SECURITY	', 'SMT 103', '2', 'Core'),
(171, 7, 23, 'SECURITY & LAW ENFORCEMENT	', 'SMT 105', '2', 'Core'),
(172, 7, 23, 'SECURITY REPORT WRITTING	', 'SMT 107', '2', 'Core'),
(173, 7, 23, 'PHYSICAL SECURITY	', 'SMT 109', '2', 'Core'),
(174, 7, 23, 'BLUEPRINT READING	', 'SMT 111', '2', 'Core'),
(175, 7, 23, 'INTRO. TO ELEC INSTALLATION	', 'SMT 112', '2', 'Core'),
(176, 7, 23, 'GENERAL SHIP KNOWLEDGE	', 'SMT 113', '2', 'Core'),
(177, 7, 24, 'ELECTRONIC SECURITY DEVICES	', 'SMT 102', '4', 'Core'),
(178, 7, 24, 'HEALTH & SAFETY AT WORK	', 'SMT 104', '4', 'Core'),
(179, 7, 24, 'INTRO TO COMPUTER	', 'GEO 104', '3', 'Core'),
(180, 7, 24, 'INTRO TO INVESTIGATION	', 'SMT 106', '4', 'Core'),
(181, 7, 24, 'FIRE CONTROL TECHNIQUES	', 'SMT 108', '3', 'Core'),
(182, 7, 24, 'EMERGENCY MANAGEMENT	', 'SMT 110', '4', 'Core'),
(183, 7, 24, 'FIELD OF SECURITY SPECIALIZATION	', 'SMT 112', '2', 'Core'),
(184, 7, 24, 'Intro. To Entrepreneurship', 'EPD 201', '3', 'Core'),
(185, 7, 24, 'FRENCH	', 'MRN 121', '2', 'Core'),
(186, 7, 24, 'COMMUNICATION SKILL	', 'CSK 402 not find', '2', 'Core'),
(187, 7, 24, 'PORT OPERATION	', 'SHM 124 not find', '2', 'Core'),
(188, 7, 25, 'SEARCHING	', 'SMT 203', '4', 'Core'),
(189, 7, 25, 'PUBLIC EVENT SECURITY	', 'SMT 205', '4', 'Core'),
(190, 7, 25, 'COMMUNICATION SKILLS	', 'SMT 207', '3', 'Core'),
(191, 7, 25, 'UNARMED COMBAT	', 'SMT 209', '4', 'Core'),
(192, 7, 25, 'FIRST AID ADMINISTRATION	', 'SMT 211', '3', 'Core'),
(193, 7, 25, 'RESEARCH METHODOLOGY	', 'SMT 216', '3', 'Core'),
(194, 7, 25, 'Marine Environmental protection	', 'SHM 121	', '2', 'Core'),
(195, 7, 25, 'Port operation & management I	', 'SHM 124	', '3', 'Core'),
(196, 7, 25, 'MARITIME SECURITY	', 'SMT 222 not find', '2', 'Core'),
(197, 7, 25, 'CAMPUS SECURITY	', 'SMT 216 not find', '2', 'Core'),
(198, 7, 25, 'SIWES 	', 'SHM 189	', '3', 'Core'),
(199, 7, 26, 'CONFLICT RESOLUTION & MGT	', 'SMT 202', '4', 'Core'),
(200, 7, 26, 'MARITIME COMMUNICATION	', 'SMT 202', '2', 'Core'),
(201, 7, 26, 'PUBLIC RELATION& S. SKILLS	', 'SMT 204', '3', 'Core'),
(202, 7, 26, 'CORPORATE SECURITY	', 'SMT 206', '4', 'Core'),
(203, 7, 26, 'CANINE SECURITY', 'SMT 208', '4', 'Core'),
(204, 7, 26, 'RISK ASSESSMENT	', 'SMT 210', '3', 'Core'),
(205, 7, 26, ' PROJECT', 'SMT 212', '4', 'Core'),
(206, 7, 26, 'MARITIME TRANSPORT	', 'SHM 227', '2', 'Core'),
(207, 8, 27, 'BUSINESS MATHS	', 'STS 101', '3', 'Core'),
(208, 8, 27, 'INTRO. TO SHIPPING ORG.', 'STS 102', '3', 'Core'),
(209, 8, 27, 'MARINE GEOGRAPHY	', 'STS 103', '2', 'Core'),
(210, 8, 27, 'AIRPORT OPERATION & MGT.	', 'STS 104', '3', 'Core'),
(211, 8, 27, 'HISTORY OF TRANSPORT	', 'STS 105', '3', 'Core'),
(212, 8, 27, 'ENGLISH LANGUAGE & COMM	', 'STS 106', '3', 'Core'),
(213, 8, 28, 'CONTRACT & DOCUMENTATION	', 'STS 201', '2', 'Core'),
(214, 8, 28, 'CARGO HANDLING & STEV	', 'STS 202', '3', 'Core'),
(215, 8, 28, 'SHIP FAMILIARIZATION	', 'STS 203', '3', 'Core'),
(216, 8, 28, 'SAFETY & SECURITY IN MARITIME	', 'STS 204', '2', 'Core'),
(217, 8, 28, 'BASIC PRINCIPLE OF FREIGHT.FW	', 'STS 205', '3', 'Core'),
(218, 8, 28, 'INTRO TO FRENCH LANG.	', 'STS 206', '3', 'Core'),
(219, 8, 29, 'SHIPPING ECONS (MICRO)	', 'STS 301', '2', 'Core'),
(220, 8, 29, 'INTRO TO RESEARCH	', 'STS 302', '2', 'Core'),
(221, 8, 29, 'COMPUTER APPR & E . SHIPPING	', 'STS 303', '3', 'Core'),
(222, 8, 29, 'MARITIME / PORT MARKETING	', 'STS 304', '2', 'Core'),
(223, 8, 29, 'IMPORT & EXPORT	', 'STS 304', '3', 'Core'),
(224, 8, 29, 'MARINE COMM & RADIO APPRE.	', 'STS 306', '3', 'Core'),
(225, 8, 30, 'MARITIME LOGISTICS	', 'STS 401', '3', 'Core'),
(226, 8, 30, 'HSE IN MARITIME	', 'STS 402', '3', 'Core'),
(227, 8, 30, 'ENTREP. STUDIES.	', 'STS 403', '2', 'Core'),
(228, 8, 30, 'INTRO TO MARITIME TRANSPT LAW.', 'STS 404', '3', 'Core'),
(229, 8, 30, 'FUNDAMENTAL OF ACCTING.	', 'STS 405', '2', 'Core'),
(230, 8, 30, 'COMPARATIVE STUDIES IN SHIPPING	', 'STS 406', '3', 'Core'),
(231, 6, 19, 'Maritime Security 	', 'SMT 222	', '2', ' Core'),
(232, 6, 21, 'SIWES	', 'IME 209	', '3', 'Core'),
(233, 6, 22, 'Instrumentation & Control Engineering	\r\n	', 'IME 211	', '2', 'Core'),
(234, 6, 20, 'Electrical Engineering Tech.	', 'IEE 102	', '4', ' Core'),
(235, 6, 20, 'Technical Report Writing	', 'IME 110	', '3', ' Core');

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

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `department_id` int(11) NOT NULL,
  `department_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`department_id`, `department_name`) VALUES
(1, 'Shipping MGT HND'),
(2, 'Shipping MGT NID'),
(3, 'Shipping MGT ASS '),
(4, 'Shipping MGT ASS Sec '),
(5, 'Shipping PGD '),
(6, 'Engineering NID'),
(7, 'Security MGT NID SEC');

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

--
-- Table structure for table `hostel_table`
--

CREATE TABLE `hostel_table` (
  `student_id` int(11) NOT NULL,
  `surname` varchar(500) NOT NULL,
  `othernames` varchar(500) NOT NULL,
  `department` varchar(500) NOT NULL,
  `dob` varchar(500) NOT NULL,
  `residential_address` varchar(500) NOT NULL,
  `postal_address` varchar(500) NOT NULL,
  `place_birth` varchar(500) NOT NULL,
  `state_origin` varchar(500) NOT NULL,
  `LGA` varchar(500) NOT NULL,
  `blood_group` varchar(500) NOT NULL,
  `illness` varchar(500) NOT NULL,
  `phone` varchar(500) NOT NULL,
  `email` varchar(500) NOT NULL,
  `fname` varchar(500) NOT NULL,
  `mother` varchar(500) NOT NULL,
  `aaddress` varchar(500) NOT NULL,
  `nameguardian` varchar(500) NOT NULL,
  `occfather` varchar(500) NOT NULL,
  `occmother` varchar(500) NOT NULL,
  `occguardian` varchar(500) NOT NULL,
  `phoneall` varchar(500) NOT NULL,
  `fathername` varchar(500) NOT NULL,
  `mothername` varchar(500) NOT NULL,
  `guardian` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `hostel_table`
--

INSERT INTO `hostel_table` (`student_id`, `surname`, `othernames`, `department`, `dob`, `residential_address`, `postal_address`, `place_birth`, `state_origin`, `LGA`, `blood_group`, `illness`, `phone`, `email`, `fname`, `mother`, `aaddress`, `nameguardian`, `occfather`, `occmother`, `occguardian`, `phoneall`, `fathername`, `mothername`, `guardian`) VALUES
(19, 'Ahossi', 'Austin', '', '2024-02-14', '17, titus morogbo lagos', '17, titus morogbo lagos', 'Lagos', 'Lagos', 'Badagry', 'A+', 'Lagos', '07061115430', 'josephaustin105@gmail.com', 'Joseph austin', 'Mary', '17, titus morogbo lagos', 'Mary', 'tt', 'Business', 'Business', '07061115430', '2wedwe', 'Mary', 'Mary'),
(20, 'Ahossi', 'Austin', '', '2024-02-13', '17, titus morogbo lagos', '17, titus morogbo lagos', 'Lagos', 'Lagos', 'Badagry', 'A+', 'Lagos', '07061115430', 'josephaustin105@gmail.com', 'Joseph austin', 'Mary', '17, titus morogbo lagos', 'Mary', 'Business', 'Business', 'Business', '07061115430', 'Stev', 'Mary', 'Mary');

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

--
-- Table structure for table `leveld`
--

CREATE TABLE `leveld` (
  `leveld_id` int(11) NOT NULL,
  `leveld_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `leveld`
--

INSERT INTO `leveld` (`leveld_id`, `leveld_name`) VALUES
(1, 'HND 1 MGT '),
(2, 'HND 2 MGT'),
(3, 'HND 3 MGT'),
(4, 'HND 4 MGT'),
(5, 'NID 1 MGT'),
(6, 'NID 2 MGT'),
(7, 'NID 3 MGT'),
(8, 'NID 4 MGT'),
(9, 'ASS 1 MGT\r\n'),
(10, 'ASS 2 MGT\r\n\r\n'),
(11, 'ASS 3 MGT\r\n'),
(12, 'ASS 4 MGT\r\n'),
(13, 'ASS 1 SEC\r\n\r\n'),
(14, 'ASS 2 SEC\r\n\r\n'),
(15, 'ASS 3 SEC\r\n\r\n'),
(16, 'ASS 4 SEC\r\n'),
(17, 'PGD 1'),
(18, 'PGD 2'),
(19, 'NID 1 ENG'),
(20, 'NID 2 ENG'),
(21, 'NID 3 ENG'),
(22, 'NID 4 ENG'),
(23, 'NID 1 SEC'),
(24, 'NID 2 SEC'),
(25, 'NID 3 SEC'),
(26, 'NID 4 SEC'),
(27, 'STS 1'),
(28, 'STS 2'),
(29, 'STS 3'),
(30, 'STS 4');

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(255) NOT NULL,
  `paymentfiles` varchar(500) NOT NULL,
  `pay` varchar(400) NOT NULL,
  `sname` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` (`id`, `paymentfiles`, `pay`, `sname`) VALUES
(6, 'Ahossi joseph.pdf', 'school fee', 'austin'),
(7, 'Mr Useh result.pdf', 'first semester school fee', 'austin');

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

--
-- Table structure for table `portal`
--

CREATE TABLE `portal` (
  `student_id` int(255) NOT NULL,
  `fname` varchar(500) NOT NULL,
  `sname` varchar(255) NOT NULL,
  `mat` varchar(500) NOT NULL,
  `program` varchar(500) NOT NULL,
  `sessiond` varchar(500) NOT NULL,
  `school` varchar(500) NOT NULL,
  `Dept` varchar(500) NOT NULL,
  `leveld` varchar(500) NOT NULL,
  `sex` varchar(500) NOT NULL,
  `dob` varchar(500) NOT NULL,
  `email` varchar(500) NOT NULL,
  `phone` varchar(455) NOT NULL,
  `addressd` varchar(500) NOT NULL,
  `pbirth` varchar(500) NOT NULL,
  `sorigin` varchar(500) NOT NULL,
  `lgovt` varchar(500) NOT NULL,
  `pgname` varchar(500) NOT NULL,
  `pgnumb` varchar(500) NOT NULL,
  `passport` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `portal`
--

INSERT INTO `portal` (`student_id`, `fname`, `sname`, `mat`, `program`, `sessiond`, `school`, `Dept`, `leveld`, `sex`, `dob`, `email`, `phone`, `addressd`, `pbirth`, `sorigin`, `lgovt`, `pgname`, `pgnumb`, `passport`) VALUES
(25, 'Joseph', 'austin', 'f21/nd/63002', 'ND Full TIme', '2022/2023', 'Management', 'Shipping MGT NID', 'NID 1 MGT', 'MALE', '2024-02-14', 'josephaustin105@gmail.com', '07061115430', '17, titus morogbo lagos', 'lagos state', 'Lagos', 'ikeja', 'micky', '07061115430', '');

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

--
-- Table structure for table `registered_courses`
--

CREATE TABLE `registered_courses` (
  `id` int(11) NOT NULL,
  `sname` varchar(255) NOT NULL,
  `Dept` varchar(255) NOT NULL,
  `leveld` varchar(255) NOT NULL,
  `leveld_id` int(11) NOT NULL,
  `course_title` varchar(255) NOT NULL,
  `course_code` varchar(255) NOT NULL,
  `course_unit` varchar(255) NOT NULL,
  `course_status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `registered_courses`
--

INSERT INTO `registered_courses` (`id`, `sname`, `Dept`, `leveld`, `leveld_id`, `course_title`, `course_code`, `course_unit`, `course_status`) VALUES
(142, 'austin', '', '', 5, 'COMPUTER APPREC & LIBRARY', 'COM 101', '2', 'Core'),
(143, 'austin', '', '', 5, 'MARITIME GEOGRAPHY', 'COM 111', '3', 'Core'),
(144, 'austin', '', '', 5, 'FRENCH LANGUAGE', 'MRN 111', '3', 'Core'),
(145, 'austin', '', '', 5, 'MARITIME ECONOMICS', 'SHM 112', '3', 'Core'),
(146, 'austin', '', '', 5, 'GEN.SHIPPING KNOWLEDGE', 'SHM 113', '3', 'Core'),
(147, 'austin', '', '', 5, 'PRINCIPLES OF ACCOUNTING', 'SHM 114', '3', 'Core'),
(148, 'austin', '', '', 5, 'PRINCIPLES OF MANAGEMENT', 'SHM 115', '3', 'Core'),
(149, 'austin', '', '', 5, 'PRINCIPLES OF LAW', 'SHM 116', '3', 'Core'),
(150, 'austin', '', '', 5, 'BUSINESS MATHEMATICS', 'MAT 241', '2', 'Core'),
(151, 'austin', '', '', 5, 'USE OF ENGLISH', 'CSK 401', '4', 'Core'),
(152, 'austin', '', '', 5, 'COMPUTER APPREC & LIBRARY', 'COM 101', '2', 'Core'),
(153, 'austin', '', '', 5, 'MARITIME GEOGRAPHY', 'COM 111', '3', 'Core'),
(154, 'austin', '', '', 5, 'FRENCH LANGUAGE', 'MRN 111', '3', 'Core'),
(155, 'austin', '', '', 5, 'MARITIME ECONOMICS', 'SHM 112', '3', 'Core'),
(156, 'austin', '', '', 5, 'GEN.SHIPPING KNOWLEDGE', 'SHM 113', '3', 'Core'),
(157, 'austin', '', '', 5, 'PRINCIPLES OF ACCOUNTING', 'SHM 114', '3', 'Core'),
(158, 'austin', '', '', 5, 'PRINCIPLES OF MANAGEMENT', 'SHM 115', '3', 'Core'),
(159, 'austin', '', '', 5, 'PRINCIPLES OF LAW', 'SHM 116', '3', 'Core'),
(160, 'austin', '', '', 5, 'BUSINESS MATHEMATICS', 'MAT 241', '2', 'Core'),
(161, 'austin', '', '', 5, 'USE OF ENGLISH', 'CSK 401', '4', 'Core');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  ADD PRIMARY KEY (`course_id`);

--
-- Indexes for table `department`
--
ALTER TABLE `department`
  ADD PRIMARY KEY (`department_id`);

--
-- Indexes for table `hostel_table`
--
ALTER TABLE `hostel_table`
  ADD PRIMARY KEY (`student_id`);

--
-- Indexes for table `leveld`
--
ALTER TABLE `leveld`
  ADD PRIMARY KEY (`leveld_id`);

--
-- Indexes for table `payment`
--
ALTER TABLE `payment`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pay` (`id`);

--
-- Indexes for table `portal`
--
ALTER TABLE `portal`
  ADD PRIMARY KEY (`student_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `carryover_courses`
--
ALTER TABLE `carryover_courses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `courses`
--
ALTER TABLE `courses`
  MODIFY `course_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=236;

--
-- AUTO_INCREMENT for table `department`
--
ALTER TABLE `department`
  MODIFY `department_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `hostel_table`
--
ALTER TABLE `hostel_table`
  MODIFY `student_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `leveld`
--
ALTER TABLE `leveld`
  MODIFY `leveld_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `payment`
--
ALTER TABLE `payment`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `portal`
--
ALTER TABLE `portal`
  MODIFY `student_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

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