-- 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 `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_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');

--
-- 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 `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_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`);

--
-- 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 `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_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;
COMMIT;

