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

START TRANSACTION;



--
-- Database: `nacos_idify_db`
--

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

--
-- Table structure for table `alert_tab`
--

CREATE TABLE `alert_tab` (
  `sn` int(11) NOT NULL,
  `alert_id` varchar(255) NOT NULL,
  `alert_detail` varchar(255) NOT NULL,
  `staff_id` varchar(255) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `ipaddress` varchar(255) NOT NULL,
  `computer` varchar(255) NOT NULL,
  `role_id` int(11) NOT NULL,
  `seen_status` int(11) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `attendance_tab`
--

CREATE TABLE `attendance_tab` (
  `sn` int(11) NOT NULL,
  `attendance_id` varchar(100) NOT NULL,
  `department_id` varchar(100) NOT NULL,
  `class_id` varchar(100) NOT NULL,
  `week_id` int(11) NOT NULL,
  `level_id` varchar(100) NOT NULL,
  `course_id` varchar(100) NOT NULL,
  `staff_id` varchar(100) NOT NULL,
  `course_option_id` varchar(100) NOT NULL,
  `program_id` varchar(100) NOT NULL,
  `status_id` int(11) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `updated_by` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `attendance_tab`
--

INSERT INTO `attendance_tab` (`sn`, `attendance_id`, `department_id`, `class_id`, `week_id`, `level_id`, `course_id`, `staff_id`, `course_option_id`, `program_id`, `status_id`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'ATD000120240515111357', 'DEPT000120240507052522', 'CLS000120240513112153', 1, 'ND1', 'COUR000420240512012342', 'STF000620240511095739', '1', '', 1, 'STF000620240511095739', '', '2024-05-15 10:13:57', '2024-05-15 09:13:57'),
(2, 'ATD000220240515011235', 'DEPT000120240507052522', 'CLS000120240513112153', 1, 'ND1', 'COUR000420240512012342', 'STF000620240511095739', '1', '', 1, 'STF000620240511095739', '', '2024-05-15 12:12:35', '2024-05-15 11:12:35'),
(3, 'ATD000320240515101608', 'DEPT000120240507052522', 'CLS000420240513061215', 5, 'ND1', 'COUR000420240512012342', 'STF000620240511095739', '1', '', 2, 'STF000620240511095739', '', '2024-05-15 21:16:08', '2024-05-15 20:16:08'),
(4, 'ATD000420240516062429', 'DEPT000120240507052522', 'CLS000320240513112253', 3, 'ND1', 'COUR000420240512012342', 'STF000620240511095739', '1', 'FT', 1, 'STF000620240511095739', '', '2024-05-16 17:24:29', '2024-05-16 16:24:29');

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

--
-- Table structure for table `class_tab`
--

CREATE TABLE `class_tab` (
  `sn` int(11) NOT NULL,
  `department_id` varchar(100) NOT NULL,
  `class_id` varchar(100) NOT NULL,
  `class_name` varchar(255) NOT NULL,
  `status_id` int(11) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `updated_by` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `class_tab`
--

INSERT INTO `class_tab` (`sn`, `department_id`, `class_id`, `class_name`, `status_id`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'DEPT000120240507052522', 'CLS000120240513112153', 'ROOM 8', 2, 'STF0000', 'STF000620240511095739', '2024-05-13 10:21:53', '2024-05-14 09:32:57'),
(2, 'DEPT000120240507052522', 'CLS000220240513112241', 'ROOM 30', 1, 'STF0000', 'STF000620240511095739', '2024-05-13 10:22:41', '2024-05-14 09:33:04'),
(3, 'DEPT000120240507052522', 'CLS000320240513112253', 'LABORATORY 15', 1, 'STF0000', 'STF000620240511095739', '2024-05-13 10:22:53', '2024-05-14 09:49:29'),
(4, 'DEPT000120240507052522', 'CLS000420240513061215', 'LABORATORY 20', 1, 'STF0000', 'STF0000', '2024-05-13 17:12:15', '2024-05-14 08:50:32'),
(5, 'DEPT000220240507052611', 'CLS000520240513061516', 'ROOM 10', 1, 'STF0000', 'STF0000', '2024-05-13 17:15:16', '2024-05-14 08:31:16'),
(6, 'DEPT000120240507052522', 'CLS000620240514113937', 'ROOM 50', 1, 'STF000620240511095739', 'STF000620240511095739', '2024-05-14 10:39:37', '2024-05-14 09:39:58');

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

--
-- Table structure for table `course_tab`
--

CREATE TABLE `course_tab` (
  `sn` int(11) NOT NULL,
  `department_id` varchar(100) NOT NULL,
  `level_id` varchar(100) NOT NULL,
  `course_id` varchar(100) NOT NULL,
  `course_code` varchar(100) NOT NULL,
  `course_title` text NOT NULL,
  `course_unit` int(11) NOT NULL,
  `course_option_id` varchar(200) NOT NULL,
  `status_id` int(11) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `updated_by` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `course_tab`
--

INSERT INTO `course_tab` (`sn`, `department_id`, `level_id`, `course_id`, `course_code`, `course_title`, `course_unit`, `course_option_id`, `status_id`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'DEPT000120240507052522', 'HND1', 'COUR000120240507053244', 'COM315', 'PYTHON PROGRAMMING', 3, '2', 1, 'STF0000', 'STF000620240511095739', '2024-05-07 04:32:44', '2024-05-12 05:44:01'),
(2, 'DEPT000120240507052522', 'HND1', 'COUR000220240507053615', 'COM312', 'DATABASE DESIGN I', 3, '1', 1, 'STF0000', '', '2024-05-07 04:36:15', '2024-05-11 23:25:52'),
(3, 'DEPT000220240507052611', 'ND1', 'COUR000320240507053750', 'GNS101', 'USE OF ENGLISH', 0, '1', 1, 'STF0000', '', '2024-05-07 04:37:50', '2024-05-07 03:37:50'),
(4, 'DEPT000120240507052522', 'ND1', 'COUR000420240512012342', 'COM111', 'INTRODUCTION TO COMPUTING', 2, '1', 1, 'STF0000', '', '2024-05-12 00:23:42', '2024-05-11 23:25:31'),
(5, 'DEPT000120240507052522', 'ND1', 'COUR000520240512072504', 'STA111', 'STATISTICS', 2, '1', 1, 'STF000620240511095739', 'STF000620240511095739', '2024-05-12 06:25:04', '2024-05-12 05:41:54'),
(6, 'DEPT000120240507052522', 'HND1', 'COUR000620240512072655', 'STA311', 'PROBABILITY DENSITY FUNCTION', 2, '1', 1, 'STF000620240511095739', '', '2024-05-12 06:26:55', '2024-05-12 05:26:55'),
(7, 'DEPT000120240507052522', 'ND1', 'COUR000720240514114212', 'GNS202', 'ENGLISH', 2, '1', 1, 'STF000620240511095739', '', '2024-05-14 10:42:12', '2024-05-14 09:42:12'),
(8, 'DEPT000120240507052522', 'ND1', 'COUR000820240514114322', 'MTH111', 'MATHS', 2, '1', 1, 'STF000620240511095739', '', '2024-05-14 10:43:22', '2024-05-14 09:43:22'),
(9, 'DEPT000120240507052522', 'HND1', 'COUR000920240514114508', 'COM314', 'DATA ANALYSIS', 3, '3', 2, 'STF000620240511095739', 'STF000620240511095739', '2024-05-14 10:45:08', '2024-05-14 09:58:58'),
(10, 'DEPT000120240507052522', 'HND1', 'COUR001020240514114658', 'COM317', 'DATA SCIENCE', 3, '3', 2, 'STF000620240511095739', 'STF000620240511095739', '2024-05-14 10:46:58', '2024-05-14 09:47:30');

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

--
-- Table structure for table `department_tab`
--

CREATE TABLE `department_tab` (
  `sn` int(11) NOT NULL,
  `school_id` varchar(100) NOT NULL,
  `department_code` int(11) NOT NULL,
  `department_id` varchar(100) NOT NULL,
  `department_name` varchar(255) NOT NULL,
  `status_id` int(11) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `updated_by` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `department_tab`
--

INSERT INTO `department_tab` (`sn`, `school_id`, `department_code`, `department_id`, `department_name`, `status_id`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'SCH000120240507052143', 69, 'DEPT000120240507052522', 'COMPUTER SCIENCE', 1, 'STF0000', '', '2024-05-07 04:25:22', '2024-05-07 03:31:22'),
(2, 'SCH000320240507052348', 77, 'DEPT000220240507052611', 'MASS COMMUNICATION', 1, 'STF0000', '', '2024-05-07 04:26:11', '2024-05-07 03:36:40'),
(3, 'SCH000320240507052348', 88, 'DEPT000320240507052806', 'DIGITAL MARKETING', 2, 'STF0000', '', '2024-05-07 04:28:06', '2024-05-07 03:36:36'),
(4, 'SCH000120240507052143', 90, 'DEPT000420240507052927', 'SCIENCE LABORATORY AND TECHNOLOGY', 1, 'STF0000', '', '2024-05-07 04:29:27', '2024-05-07 03:30:08'),
(5, 'SCH000220240507052247', 56, 'DEPT000520240507054645', 'COMPUTER ENGINEERING', 1, 'STF0000', '', '2024-05-07 04:46:45', '2024-05-07 03:46:45'),
(6, 'SCH000320240507052348', 23, 'DEPT000620240514113603', 'SLT', 2, 'STF0000', 'STF0000', '2024-05-14 10:36:03', '2024-05-14 09:38:34');

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

--
-- Table structure for table `returning_student_tab`
--

CREATE TABLE `returning_student_tab` (
  `sn` int(11) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `address` varchar(255) NOT NULL,
  `status_id` varchar(50) NOT NULL,
  `otp` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `school_tab`
--

CREATE TABLE `school_tab` (
  `sn` int(11) NOT NULL,
  `school_id` varchar(100) NOT NULL,
  `school_name` varchar(255) NOT NULL,
  `status_id` int(11) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `updated_by` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `school_tab`
--

INSERT INTO `school_tab` (`sn`, `school_id`, `school_name`, `status_id`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'SCH000120240507052143', 'SCHOOL OF SCIENCE AND TECHNOLOGY', 1, 'STF0000', '', '2024-05-07 04:21:43', '2024-05-07 03:22:12'),
(2, 'SCH000220240507052247', 'SCHOOL OF ENGINEERING', 1, 'STF0000', '', '2024-05-07 04:22:47', '2024-05-12 01:30:26'),
(3, 'SCH000320240507052348', 'SCHOOL OF COMMUNICATION', 1, 'STF0000', '', '2024-05-07 04:23:48', '2024-05-07 03:23:48');

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

--
-- Table structure for table `setup_admission_link_tab`
--

CREATE TABLE `setup_admission_link_tab` (
  `sn` int(11) NOT NULL,
  `admission_link_id` int(11) NOT NULL,
  `admission_link_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `setup_admission_link_tab`
--

INSERT INTO `setup_admission_link_tab` (`sn`, `admission_link_id`, `admission_link_name`) VALUES
(1, 1, 'FRESHER STUDENT'),
(2, 2, 'RETURNING STUDENT');

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

--
-- Table structure for table `setup_backend_settings_tab`
--

CREATE TABLE `setup_backend_settings_tab` (
  `sn` int(11) NOT NULL,
  `backend_setting_id` varchar(10) NOT NULL,
  `smtp_host` varchar(100) NOT NULL,
  `smtp_username` varchar(100) NOT NULL,
  `smtp_password` varchar(100) NOT NULL,
  `smtp_port` int(11) NOT NULL,
  `sender_name` varchar(100) NOT NULL,
  `support_email` varchar(100) NOT NULL,
  `payment_key` text NOT NULL,
  `currency_id` varchar(50) NOT NULL,
  `session` varchar(100) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `setup_backend_settings_tab`
--

INSERT INTO `setup_backend_settings_tab` (`sn`, `backend_setting_id`, `smtp_host`, `smtp_username`, `smtp_password`, `smtp_port`, `sender_name`, `support_email`, `payment_key`, `currency_id`, `session`, `date`) VALUES
(1, 'BK_ID001', 'mail.agrohandlers.com', 'info@agrohandlers.com', '1971@@@ademorinola12', 465, 'AgroHandlers', 'afootech2016@gmail.com', 'pk_test_2c6df6d5a7b837ab3b3152750562b1b139155ffd', 'NGN', '2023/2024', '2024-04-08 17:23:01');

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

--
-- Table structure for table `setup_counter_tab`
--

CREATE TABLE `setup_counter_tab` (
  `sn` int(11) NOT NULL,
  `counter_id` varchar(100) NOT NULL,
  `counter_discription` varchar(225) NOT NULL,
  `counter_value` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `setup_counter_tab`
--

INSERT INTO `setup_counter_tab` (`sn`, `counter_id`, `counter_discription`, `counter_value`) VALUES
(1, 'STF', 'STAFF ID COUNT', 11),
(2, 'ALT', 'OPERATION ALERT', 0),
(3, 'TRANS', 'TRANSACTIONS COUNT', 0),
(4, 'IDIFY_NO_ND1_FT', 'STUDENT IDIFY NO ND1 FULL-TIME COUNT', 1),
(5, 'IDIFY_NO_ND1_PT', 'STUDENT IDIFY NO ND1 PART-TIME COUNT', 0),
(6, 'IDIFY_NO_HND1_FT', 'STUDENT IDIFY NO HND1 FULL-TIME COUNT', 0),
(7, 'IDIFY_NO_HND1_PT', 'STUDENT IDIFY NO HND1 PART-TIME COUNT', 0),
(8, 'SCH', 'SCHOOL COUNT', 3),
(9, 'DEPT', 'DEPARTMENT COUNT', 6),
(10, 'COUR', 'COURSES COUNT', 10),
(11, 'CLS', 'CLASS COUNT', 6),
(12, 'ATD', 'STUDENT ATTENDANCE COUNT', 4);

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

--
-- Table structure for table `setup_course_option_tab`
--

CREATE TABLE `setup_course_option_tab` (
  `sn` int(11) NOT NULL,
  `course_option_id` varchar(100) NOT NULL,
  `course_option_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `setup_course_option_tab`
--

INSERT INTO `setup_course_option_tab` (`sn`, `course_option_id`, `course_option_name`) VALUES
(1, '1', 'THEORY'),
(2, '2', 'THEORY & PRATICAL'),
(3, '3', 'PRATICAL');

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

--
-- Table structure for table `setup_department_tab`
--

CREATE TABLE `setup_department_tab` (
  `sn` int(11) NOT NULL,
  `department_id` int(11) NOT NULL,
  `department_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `setup_department_tab`
--

INSERT INTO `setup_department_tab` (`sn`, `department_id`, `department_name`) VALUES
(1, 69, 'COMPUTER SCIENCE');

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

--
-- Table structure for table `setup_level_tab`
--

CREATE TABLE `setup_level_tab` (
  `sn` int(11) NOT NULL,
  `level_id` varchar(100) NOT NULL,
  `level_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `setup_level_tab`
--

INSERT INTO `setup_level_tab` (`sn`, `level_id`, `level_name`) VALUES
(1, 'ND1', 'NATIONAL DIPLOMA(ND1)'),
(2, 'HND1', 'HIGHER NATIONAL DIPLOMA(HND1)');

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

--
-- Table structure for table `setup_pair_tab`
--

CREATE TABLE `setup_pair_tab` (
  `sn` int(11) NOT NULL,
  `pair_id` varchar(100) NOT NULL,
  `pair_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `setup_pair_tab`
--

INSERT INTO `setup_pair_tab` (`sn`, `pair_id`, `pair_name`) VALUES
(1, 'Mr', 'Mr'),
(2, 'Mrs', 'Mrs');

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

--
-- Table structure for table `setup_program_tab`
--

CREATE TABLE `setup_program_tab` (
  `sn` int(11) NOT NULL,
  `program_id` varchar(100) NOT NULL,
  `program_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `setup_program_tab`
--

INSERT INTO `setup_program_tab` (`sn`, `program_id`, `program_name`) VALUES
(1, 'FT', 'FULL TIME(FT)'),
(2, 'PT', 'PART TIME(PT)');

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

--
-- Table structure for table `setup_role_tab`
--

CREATE TABLE `setup_role_tab` (
  `sn` int(11) NOT NULL,
  `role_id` varchar(50) NOT NULL,
  `role_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `setup_role_tab`
--

INSERT INTO `setup_role_tab` (`sn`, `role_id`, `role_name`) VALUES
(1, '1', 'LECTURER'),
(2, '2', 'HOD'),
(3, '3', 'SUPER ADMIN');

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

--
-- Table structure for table `setup_status_tab`
--

CREATE TABLE `setup_status_tab` (
  `sn` int(10) UNSIGNED NOT NULL,
  `status_id` varchar(100) NOT NULL,
  `status_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `setup_status_tab`
--

INSERT INTO `setup_status_tab` (`sn`, `status_id`, `status_name`) VALUES
(1, '1', 'ACTIVE'),
(2, '2', 'SUSPEND'),
(3, '3', 'PENDING'),
(4, '4', 'INACTIVE'),
(5, '5', 'SUCCESS'),
(6, '6', 'CANCELLED'),
(7, '7', 'FAILED');

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

--
-- Table structure for table `setup_weeks_tab`
--

CREATE TABLE `setup_weeks_tab` (
  `sn` int(11) NOT NULL,
  `week_id` int(11) NOT NULL,
  `week_name` int(11) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `setup_weeks_tab`
--

INSERT INTO `setup_weeks_tab` (`sn`, `week_id`, `week_name`, `updated_at`) VALUES
(1, 1, 1, '2024-05-12 07:21:05'),
(2, 2, 2, '2024-05-12 07:21:05'),
(3, 3, 3, '2024-05-12 07:21:05'),
(4, 4, 4, '2024-05-12 07:21:05'),
(5, 5, 5, '2024-05-12 07:21:05'),
(6, 6, 6, '2024-05-12 07:21:05'),
(7, 7, 7, '2024-05-12 07:21:05'),
(8, 8, 8, '2024-05-12 07:21:05'),
(9, 9, 9, '2024-05-12 07:21:05'),
(10, 10, 10, '2024-05-12 07:21:05'),
(11, 11, 11, '2024-05-12 07:21:05'),
(12, 12, 12, '2024-05-12 07:21:05'),
(13, 13, 13, '2024-05-12 07:21:05');

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

--
-- Table structure for table `staff_course_tab`
--

CREATE TABLE `staff_course_tab` (
  `sn` int(11) NOT NULL,
  `staff_id` varchar(100) NOT NULL,
  `department_id` varchar(100) NOT NULL,
  `course_id` text NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `staff_course_tab`
--

INSERT INTO `staff_course_tab` (`sn`, `staff_id`, `department_id`, `course_id`, `created_at`, `updated_at`) VALUES
(3, 'STF000820240511103319', 'DEPT000120240507052522', 'COUR000120240507053244', '2024-05-12 01:05:05', '2024-05-12 00:05:05'),
(8, 'STF000720240511104828', 'DEPT000220240507052611', 'COUR000320240507053750', '2024-05-12 01:09:07', '2024-05-12 00:09:07'),
(15, 'STF001020240512061540', 'DEPT000120240507052522', 'COUR000120240507053244', '2024-05-12 05:38:54', '2024-05-12 04:38:54'),
(16, 'STF001020240512061540', 'DEPT000120240507052522', 'COUR000420240512012342', '2024-05-12 05:38:54', '2024-05-12 04:38:54'),
(27, 'STF000920240512060839', 'DEPT000120240507052522', 'COUR000220240507053615', '2024-05-14 10:06:15', '2024-05-14 09:06:15'),
(28, 'STF000920240512060839', 'DEPT000120240507052522', 'COUR000420240512012342', '2024-05-14 10:06:15', '2024-05-14 09:06:15'),
(29, 'STF000920240512060839', 'DEPT000120240507052522', 'COUR000120240507053244', '2024-05-14 10:06:16', '2024-05-14 09:06:16'),
(30, 'STF000920240512060839', 'DEPT000120240507052522', 'COUR000520240512072504', '2024-05-14 10:06:16', '2024-05-14 09:06:16'),
(31, 'STF001120240514120518', 'DEPT000120240507052522', 'COUR000520240512072504', '2024-05-14 11:05:18', '2024-05-14 10:05:18'),
(39, 'STF000620240511095739', 'DEPT000120240507052522', 'COUR000420240512012342', '2024-05-14 13:26:40', '2024-05-14 12:26:40'),
(40, 'STF000620240511095739', 'DEPT000120240507052522', 'COUR000520240512072504', '2024-05-14 13:26:40', '2024-05-14 12:26:40');

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

--
-- Table structure for table `staff_tab`
--

CREATE TABLE `staff_tab` (
  `sn` int(11) NOT NULL,
  `access_key` varchar(255) NOT NULL,
  `staff_id` varchar(100) NOT NULL,
  `pair_id` varchar(50) NOT NULL,
  `firstname` varchar(225) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `mobile` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `address` varchar(255) NOT NULL,
  `department_id` varchar(100) NOT NULL,
  `status_id` varchar(50) NOT NULL,
  `role_id` int(11) NOT NULL,
  `password` varchar(255) NOT NULL,
  `otp` int(11) NOT NULL,
  `profile_pix` varchar(255) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `updated_by` varchar(100) NOT NULL,
  `last_login_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `staff_tab`
--

INSERT INTO `staff_tab` (`sn`, `access_key`, `staff_id`, `pair_id`, `firstname`, `lastname`, `mobile`, `email`, `address`, `department_id`, `status_id`, `role_id`, `password`, `otp`, `profile_pix`, `created_by`, `updated_by`, `last_login_time`, `created_at`, `updated_at`) VALUES
(1, '95998a8dd1a4da181c55bde924dba68d', 'STF0000', 'MR', 'ABAYOMI', 'AFOLABI', '09151404598', 'afolabitaiwoabayomi112@gmail.com', '12, KOTCO ROAD, ODE REMO, OGUN STATE', '', '1', 3, 'f769485f2b7e303561aa44d1c0867cd7', 178468, 'friends.png', '', '', '2024-05-18 23:11:53', '0000-00-00 00:00:00', '2024-05-18 23:11:53'),
(12, '717904feb820e1d635bee5dadbe1e55a', 'STF000620240511095739', 'MR', 'MIKE', 'AFOLABI', '09055066744', 'sunaf4real@gmail.com', 'ODE REMO', 'DEPT000120240507052522', '1', 2, 'f769485f2b7e303561aa44d1c0867cd7', 930339, 'friends.png', '', 'STF0000', '2024-05-16 16:12:51', '2024-05-11 08:57:39', '2024-05-16 16:12:51'),
(13, '', 'STF000720240511104828', 'MRS', 'ADETONA', 'BASIT', '09055067444', 'basit@gmail.com', 'ABEOKUTA', 'DEPT000220240507052611', '1', 1, '', 0, 'friends.png', '', '', '2024-05-11 08:48:28', '2024-05-11 09:48:28', '2024-05-11 08:48:28'),
(14, '', 'STF000820240511103319', 'MR', 'HON', 'EMMA', '09055066744', 'emma@gmail.com', 'ABEOKUTA', 'DEPT000120240507052522', '1', 1, '', 0, 'friends.png', '', '', '2024-05-11 20:33:19', '2024-05-11 21:33:19', '2024-05-11 20:33:19'),
(15, '', 'STF000920240512060839', 'MRS', 'FLORENCE', 'ABOSEDE', '09055066755', 'florence@gmail.com', '12, ABEOKUTA', 'DEPT000120240507052522', '1', 1, '', 0, 'friends.png', 'STF000620240511095739', 'STF000620240511095739', '2024-05-12 05:24:02', '2024-05-12 05:08:39', '2024-05-12 05:24:02'),
(16, '', 'STF001020240512061540', 'MR', 'SOJI', 'ADEBESIN', '09055066755', 'soji@gmail.com', '12M OJERE', 'DEPT000120240507052522', '1', 1, '', 0, 'friends.png', 'STF000620240511095739', '', '2024-05-12 04:38:54', '2024-05-12 05:15:40', '2024-05-12 04:38:54'),
(17, '', 'STF001120240514120518', 'MR', 'LEKAN', 'SULIAMO', '0905567755', 'lekan@gmail.com', 'ABEKOUTA', 'DEPT000120240507052522', '1', 1, '', 0, 'friends.png', 'STF000620240511095739', '', '2024-05-14 10:05:18', '2024-05-14 11:05:18', '2024-05-14 10:05:18');

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

--
-- Table structure for table `student_tab`
--

CREATE TABLE `student_tab` (
  `sn` int(11) NOT NULL,
  `idify_no` varchar(100) NOT NULL,
  `matric_no` varchar(100) NOT NULL,
  `surname` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `admission_link_id` varchar(100) NOT NULL,
  `program_id` varchar(100) NOT NULL,
  `department_id` varchar(100) NOT NULL,
  `department_code` int(11) NOT NULL,
  `level_id` varchar(100) NOT NULL,
  `passport_pix` varchar(255) NOT NULL,
  `status_id` varchar(50) NOT NULL,
  `otp` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `session` varchar(100) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `updated_by` varchar(100) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `student_tab`
--

INSERT INTO `student_tab` (`sn`, `idify_no`, `matric_no`, `surname`, `firstname`, `email`, `admission_link_id`, `program_id`, `department_id`, `department_code`, `level_id`, `passport_pix`, `status_id`, `otp`, `password`, `session`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(2, 'NFT-24-69-0001', '', 'MIKE', 'SUNDAY', 'sunday@gmail.com', '1', 'FT', 'DEPT000120240507052522', 69, 'ND1', 'friends.png', '1', '851169', 'a8a57c904bdad4ea533613416fed8a18', '2023/2024', '', '', '2024-04-24 19:16:33', '2024-05-08 12:19:42');

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

--
-- Table structure for table `student_verification_tab`
--

CREATE TABLE `student_verification_tab` (
  `sn` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `otp` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `student_verification_tab`
--

INSERT INTO `student_verification_tab` (`sn`, `email`, `otp`, `created_at`, `updated_at`) VALUES
(1, 'honemmanuel@gmail.com', 464725, '2024-04-08 13:46:38', '0000-00-00 00:00:00'),
(3, 'afolabitaiwoabayomi112@gmail.com', 180939, '2024-04-08 14:19:23', '2024-04-24 19:02:30'),
(4, 'mikeafoo@gmail.com', 880329, '2024-04-08 14:36:17', '0000-00-00 00:00:00'),
(5, 'temitope@gmail.com', 592545, '2024-04-08 14:47:02', '0000-00-00 00:00:00'),
(6, 'abosede@gmail.com', 366799, '2024-04-08 17:59:01', '0000-00-00 00:00:00'),
(7, 'adebayo@gmail.com', 708970, '2024-04-08 18:30:45', '2024-04-08 18:31:49'),
(8, 'seun@gmail.com', 712057, '2024-04-08 19:11:19', '2024-04-08 19:12:36'),
(9, 'taiwo@gmail.com', 497795, '2024-04-11 20:32:16', '2024-04-11 21:45:37'),
(10, 'tt@gmail.com', 516240, '2024-04-11 21:49:07', '0000-00-00 00:00:00'),
(11, 'ff@gmail.com', 591536, '2024-04-11 21:50:04', '2024-04-24 14:48:26'),
(12, 'sunday@gmail.com', 398664, '2024-04-24 19:13:16', '0000-00-00 00:00:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `alert_tab`
--
ALTER TABLE `alert_tab`
  ADD PRIMARY KEY (`sn`),
  ADD KEY `seen_status` (`seen_status`),
  ADD KEY `user_id` (`staff_id`),
  ADD KEY `alert_id` (`alert_id`);

--
-- Indexes for table `attendance_tab`
--
ALTER TABLE `attendance_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `class_tab`
--
ALTER TABLE `class_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `course_tab`
--
ALTER TABLE `course_tab`
  ADD PRIMARY KEY (`sn`),
  ADD KEY `course_id` (`course_id`);

--
-- Indexes for table `department_tab`
--
ALTER TABLE `department_tab`
  ADD PRIMARY KEY (`sn`),
  ADD KEY `department_id` (`department_id`);

--
-- Indexes for table `returning_student_tab`
--
ALTER TABLE `returning_student_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `school_tab`
--
ALTER TABLE `school_tab`
  ADD PRIMARY KEY (`sn`),
  ADD KEY `school_id` (`school_id`);

--
-- Indexes for table `setup_admission_link_tab`
--
ALTER TABLE `setup_admission_link_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `setup_backend_settings_tab`
--
ALTER TABLE `setup_backend_settings_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `setup_counter_tab`
--
ALTER TABLE `setup_counter_tab`
  ADD PRIMARY KEY (`sn`),
  ADD KEY `counter_id` (`counter_id`);

--
-- Indexes for table `setup_course_option_tab`
--
ALTER TABLE `setup_course_option_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `setup_department_tab`
--
ALTER TABLE `setup_department_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `setup_level_tab`
--
ALTER TABLE `setup_level_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `setup_pair_tab`
--
ALTER TABLE `setup_pair_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `setup_program_tab`
--
ALTER TABLE `setup_program_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `setup_role_tab`
--
ALTER TABLE `setup_role_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `setup_status_tab`
--
ALTER TABLE `setup_status_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `setup_weeks_tab`
--
ALTER TABLE `setup_weeks_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `staff_course_tab`
--
ALTER TABLE `staff_course_tab`
  ADD PRIMARY KEY (`sn`);

--
-- Indexes for table `staff_tab`
--
ALTER TABLE `staff_tab`
  ADD PRIMARY KEY (`sn`),
  ADD KEY `staff_id` (`staff_id`);

--
-- Indexes for table `student_tab`
--
ALTER TABLE `student_tab`
  ADD PRIMARY KEY (`sn`),
  ADD KEY `idify_no` (`idify_no`);

--
-- Indexes for table `student_verification_tab`
--
ALTER TABLE `student_verification_tab`
  ADD PRIMARY KEY (`sn`),
  ADD KEY `email` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `alert_tab`
--
ALTER TABLE `alert_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `attendance_tab`
--
ALTER TABLE `attendance_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `class_tab`
--
ALTER TABLE `class_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `course_tab`
--
ALTER TABLE `course_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `department_tab`
--
ALTER TABLE `department_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `returning_student_tab`
--
ALTER TABLE `returning_student_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `school_tab`
--
ALTER TABLE `school_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `setup_admission_link_tab`
--
ALTER TABLE `setup_admission_link_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `setup_backend_settings_tab`
--
ALTER TABLE `setup_backend_settings_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `setup_course_option_tab`
--
ALTER TABLE `setup_course_option_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `setup_department_tab`
--
ALTER TABLE `setup_department_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `setup_level_tab`
--
ALTER TABLE `setup_level_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `setup_pair_tab`
--
ALTER TABLE `setup_pair_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `setup_program_tab`
--
ALTER TABLE `setup_program_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `setup_role_tab`
--
ALTER TABLE `setup_role_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `setup_status_tab`
--
ALTER TABLE `setup_status_tab`
  MODIFY `sn` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `setup_weeks_tab`
--
ALTER TABLE `setup_weeks_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `staff_course_tab`
--
ALTER TABLE `staff_course_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `staff_tab`
--
ALTER TABLE `staff_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `student_tab`
--
ALTER TABLE `student_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `student_verification_tab`
--
ALTER TABLE `student_verification_tab`
  MODIFY `sn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

