-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Nov 17, 2025 at 02:12 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 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: `staff_db` -- -- -------------------------------------------------------- -- -- Table structure for table `audit_log` -- CREATE TABLE `audit_log` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `action` varchar(100) NOT NULL, `description` text DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `audit_log` -- INSERT INTO `audit_log` (`id`, `user_id`, `action`, `description`, `ip_address`, `user_agent`, `created_at`) VALUES (1, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:25:34'), (2, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:31:43'), (3, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:32:29'), (4, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:32:36'), (5, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:33:18'), (6, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:35:08'), (7, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:39:04'), (8, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:39:05'), (9, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:39:07'), (10, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:39:18'), (11, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:44:00'), (12, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:44:58'), (13, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:45:58'), (14, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:50:47'), (15, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:50:51'), (16, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 15:50:57'), (17, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:07:06'), (18, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:07:18'), (19, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:16:57'), (20, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:17:31'), (21, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:19:13'), (22, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:19:30'), (23, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:20:39'), (24, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:20:44'), (25, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:20:48'), (26, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:20:51'), (27, 1, 'REPORT_GENERATED', 'Generated Employment Status Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:20:53'), (28, 1, 'REPORT_GENERATED', 'Generated New Hires Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:20:59'), (29, 1, 'REPORT_GENERATED', 'Generated Complete Staff List', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:21:03'), (30, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:24:03'), (31, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:26:03'), (32, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:49:25'), (33, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:49:34'), (34, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:51:44'), (35, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 16:51:57'), (36, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 19:21:10'), (37, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 19:21:10'), (38, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 19:21:22'), (39, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 19:37:56'), (40, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 19:41:55'), (41, 1, 'LOGOUT', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-03 19:43:37'), (42, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 09:47:51'), (43, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 09:47:51'), (44, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 09:51:18'), (45, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 09:53:19'), (46, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 09:55:43'), (47, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 09:55:56'), (48, 1, 'REPORT_GENERATED', 'Generated Employment Status Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 09:56:05'), (49, 1, 'REPORT_GENERATED', 'Generated New Hires Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 09:56:21'), (50, 1, 'REPORT_GENERATED', 'Generated Complete Staff List', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 09:56:29'), (51, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 09:56:37'), (52, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:02:51'), (53, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:02:51'), (54, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:03:00'), (55, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:06:04'), (56, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:12:25'), (57, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:14:32'), (58, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:15:18'), (59, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:20:33'), (60, 1, 'STAFF_DEACTIVATED', 'Deactivated staff: Abubakar Mukhtar (ID: STF202511036420). Reason: End of Contract', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:28:51'), (61, 1, 'STAFF_REACTIVATED', 'Reactivated staff: Abubakar Mukhtar (ID: STF202511036420). Reason: Contract Renewal', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:30:25'), (62, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:30:35'), (63, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:56:28'), (64, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 14:56:29'), (65, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:01:30'), (66, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:06:09'), (67, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:06:22'), (68, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:06:31'), (69, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:08:29'), (70, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:09:22'), (71, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:24:06'), (72, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:24:32'), (73, 1, 'REPORT_GENERATED', 'Generated Comprehensive Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:32:28'), (74, 1, 'REPORT_GENERATED', 'Generated Comprehensive Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:43:56'), (75, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:45:51'), (76, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:45:57'), (77, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:45:59'), (78, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:46:05'), (79, 1, 'REPORT_GENERATED', 'Generated Comprehensive Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:46:08'), (80, 1, 'REPORT_GENERATED', 'Generated Employment Status Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:46:11'), (81, 1, 'REPORT_GENERATED', 'Generated New Hires Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:46:22'), (82, 1, 'REPORT_GENERATED', 'Generated New Hires Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:46:36'), (83, 1, 'REPORT_GENERATED', 'Generated New Hires Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:46:38'), (84, 1, 'REPORT_GENERATED', 'Generated Resources Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:46:41'), (85, 1, 'REPORT_GENERATED', 'Generated Complete Staff List', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:46:45'), (86, 1, 'REPORT_GENERATED', 'Generated Tasks Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:46:49'), (87, 1, 'REPORT_GENERATED', 'Generated Comprehensive Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:47:10'), (88, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:47:24'), (89, 1, 'REPORT_GENERATED', 'Generated Comprehensive Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:47:46'), (90, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:47:50'), (91, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:48:08'), (92, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:48:12'), (93, 1, 'REPORT_GENERATED', 'Generated Employment Status Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:48:17'), (94, 1, 'REPORT_GENERATED', 'Generated New Hires Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:48:22'), (95, 1, 'REPORT_GENERATED', 'Generated Complete Staff List', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:48:29'), (96, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:48:32'), (97, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:50:32'), (98, 1, 'LOGOUT', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:53:31'), (99, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:53:47'), (100, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:53:47'), (101, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:57:00'), (102, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 15:59:25'), (103, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 16:04:26'), (104, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 16:09:27'), (105, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 16:14:28'), (106, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 16:19:29'), (107, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 16:24:30'), (108, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 16:29:30'), (109, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 16:29:44'), (110, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 16:30:42'), (111, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 16:42:31'), (112, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-04 16:47:32'), (113, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 07:23:17'), (114, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 07:23:18'), (115, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 07:26:10'), (116, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 07:29:52'), (117, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 07:30:02'), (118, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 07:30:11'), (119, 1, 'REPORT_GENERATED', 'Generated Employment Status Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 07:30:21'), (120, 1, 'REPORT_GENERATED', 'Generated Complete Staff List', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 07:30:38'), (121, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 07:31:06'), (122, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 09:56:56'), (123, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 09:56:56'), (124, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 09:57:02'), (125, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 13:26:47'), (126, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 13:26:47'), (127, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 13:59:43'), (128, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 13:59:58'), (129, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:23:01'), (130, 1, 'LOGOUT', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:23:06'), (131, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:23:13'), (132, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:23:13'), (133, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:25:25'), (134, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:25:40'), (135, 1, 'REPORT_GENERATED', 'Generated Employment Status Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:25:45'), (136, 1, 'REPORT_GENERATED', 'Generated New Hires Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:25:53'), (137, 1, 'REPORT_GENERATED', 'Generated Complete Staff List', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:25:57'), (138, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:26:02'), (139, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:31:02'), (140, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:36:02'), (141, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:41:03'), (142, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:41:10'), (143, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:41:19'), (144, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-05 15:46:20'), (145, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-06 08:00:56'), (146, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-06 08:00:56'), (147, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-06 08:04:07'), (148, 1, 'REPORT_GENERATED', 'Generated Staff Summary Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-06 08:04:57'), (149, 1, 'REPORT_GENERATED', 'Generated Department Staff Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-06 08:05:12'), (150, 1, 'REPORT_GENERATED', 'Generated Employment Status Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-06 08:05:19'), (151, 1, 'REPORT_GENERATED', 'Generated New Hires Report', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-06 08:05:28'), (152, 1, 'REPORT_GENERATED', 'Generated Complete Staff List', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-06 08:05:32'), (153, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 09:42:00'), (154, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 09:42:00'), (155, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 09:47:02'), (156, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 09:52:03'), (157, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 09:57:04'), (158, 1, 'LOGIN', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:01:37'), (159, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:06:16'), (160, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:06:37'), (161, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:07:27'), (162, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:07:28'), (163, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:12:25'), (164, 1, 'REPORT_GENERATED', 'Generated ', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:12:41'), (165, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:14:09'), (166, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:16:49'), (167, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:29:36'), (168, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:31:43'), (169, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:36:44'), (170, 1, 'DASHBOARD_ACCESS', 'User accessed dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 10:41:44'); -- -------------------------------------------------------- -- -- Table structure for table `login_attempts` -- CREATE TABLE `login_attempts` ( `id` int(11) NOT NULL, `username` varchar(50) NOT NULL, `time` int(11) NOT NULL, `success` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `login_attempts` -- INSERT INTO `login_attempts` (`id`, `username`, `time`, `success`) VALUES (1, 'admin', 1762183525, 0), (2, 'admin', 1762183534, 1), (3, 'admin', 1762197670, 1), (4, 'admin', 1762249671, 1), (5, 'admin', 1762264971, 1), (6, 'admin', 1762271627, 1), (7, 'admin', 1762327397, 1), (8, 'admin', 1762336616, 1), (9, 'admin', 1762349207, 1), (10, 'admin', 1762356193, 1), (11, 'WeedardTech', 1762416043, 0), (12, 'admin', 1762416056, 1), (13, 'admin', 1763026920, 1), (14, 'admin', 1763028097, 1); -- -------------------------------------------------------- -- -- Table structure for table `staff` -- CREATE TABLE `staff` ( `id` int(11) NOT NULL, `staff_id` varchar(20) NOT NULL, `registration_step` enum('personal','employment','education','guarantor','declaration','complete') DEFAULT 'personal', `full_name` varchar(255) NOT NULL, `gender` enum('Male','Female','Other') DEFAULT NULL, `date_of_birth` date DEFAULT NULL, `marital_status` enum('Single','Married','Divorced','Widowed') DEFAULT NULL, `nationality` varchar(100) DEFAULT NULL, `state_of_origin` varchar(100) DEFAULT NULL, `lga` varchar(100) DEFAULT NULL, `home_town` varchar(100) DEFAULT NULL, `residential_address` text DEFAULT NULL, `phone_number` varchar(20) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `bvn` varchar(20) DEFAULT NULL, `nin` varchar(20) DEFAULT NULL, `means_of_identification` varchar(255) DEFAULT NULL, `next_of_kin_name` varchar(255) DEFAULT NULL, `next_of_kin_relationship` varchar(100) DEFAULT NULL, `next_of_kin_phone` varchar(20) DEFAULT NULL, `next_of_kin_address` text DEFAULT NULL, `department` varchar(100) DEFAULT NULL, `position` varchar(100) DEFAULT NULL, `date_employed` date DEFAULT NULL, `employment_type` enum('Full-time','Part-time','Contract') DEFAULT NULL, `employment_status` enum('Active','Terminated','Suspended') DEFAULT 'Active', `supervisor_manager` varchar(255) DEFAULT NULL, `work_location` varchar(100) DEFAULT NULL, `highest_qualification` varchar(100) DEFAULT NULL, `institution_attended` varchar(255) DEFAULT NULL, `year_of_graduation` int(11) DEFAULT NULL, `other_certificates` text DEFAULT NULL, `guarantor_name` varchar(255) DEFAULT NULL, `guarantor_occupation` varchar(100) DEFAULT NULL, `guarantor_office_address` text DEFAULT NULL, `guarantor_home_address` text DEFAULT NULL, `guarantor_phone` varchar(20) DEFAULT NULL, `guarantor_email` varchar(100) DEFAULT NULL, `guarantor_relationship` varchar(100) DEFAULT NULL, `declaration_signature` varchar(255) DEFAULT NULL, `declaration_date` date DEFAULT NULL, `staff_id_generated` varchar(50) DEFAULT NULL, `remarks` text DEFAULT NULL, `hr_officer_name` varchar(255) DEFAULT NULL, `hr_officer_signature` varchar(255) DEFAULT NULL, `hr_date` date DEFAULT NULL, `latitude` decimal(10,8) DEFAULT NULL, `longitude` decimal(11,8) DEFAULT NULL, `photo_path` varchar(255) DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `is_active` tinyint(1) DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `staff` -- INSERT INTO `staff` (`id`, `staff_id`, `registration_step`, `full_name`, `gender`, `date_of_birth`, `marital_status`, `nationality`, `state_of_origin`, `lga`, `home_town`, `residential_address`, `phone_number`, `email`, `bvn`, `nin`, `means_of_identification`, `next_of_kin_name`, `next_of_kin_relationship`, `next_of_kin_phone`, `next_of_kin_address`, `department`, `position`, `date_employed`, `employment_type`, `employment_status`, `supervisor_manager`, `work_location`, `highest_qualification`, `institution_attended`, `year_of_graduation`, `other_certificates`, `guarantor_name`, `guarantor_occupation`, `guarantor_office_address`, `guarantor_home_address`, `guarantor_phone`, `guarantor_email`, `guarantor_relationship`, `declaration_signature`, `declaration_date`, `staff_id_generated`, `remarks`, `hr_officer_name`, `hr_officer_signature`, `hr_date`, `latitude`, `longitude`, `photo_path`, `created_by`, `created_at`, `updated_at`, `is_active`) VALUES (1, 'STF202511036420', 'guarantor', 'Abubakar Mukhtar', 'Male', '1990-01-15', 'Married', 'Nigeria', 'Kano', 'Gwale', 'Tudun Yola', 'C2 Muhammadu Buhari Way, tudun Yola', '08033294500', 'abubakarmukhtar912@gmail.com', '22180038925', '40259684040', NULL, 'Mukhtar Bashir', 'Father', '08065884547', '70 Karkasara', 'IT', 'Head of IT', '2025-01-01', 'Contract', 'Active', 'Nasidi Sabo', 'UYK Nigeria Limited', 'Bachelor\'s Degree', 'Aliko Dangote University of Science and Technology, Wudil', 2014, 'Certified data Analyst', 'Bahijja Dalhatu Adamu', 'House Wife', 'Ado Bayero Royal City', 'Darmanawa Yamma', '08106540819', 'weedardtech@gmail.com', 'Colleague', 'Abubakar Mukhtar', '2025-11-03', 'STF202511036420', 'Verified', 'Nasidi Sabo', 'Nasidi', '2025-11-03', NULL, NULL, 'STF202511036420_1762186739.JPG', NULL, '2025-11-03 16:08:28', '2025-11-04 14:30:25', 1), (2, 'STF202511054317', 'complete', 'Sumayyah Abdullahi Umar ', 'Female', '1997-05-04', 'Married', 'Nigeria', 'Kano', 'Gwale', 'Rijiyar Zaki', 'Rijiyar Zaki Dorawar 4th Transformer', '08065645632', 'sumayyaabdullahiumar@gmail.com', '22425585470', '30670417125', NULL, 'Abubakar Bajo', 'Spouse', '08036272888', 'Rijiyar Zaki', 'IT', 'IT Personal', '2023-01-01', 'Full-time', 'Active', 'Hussaini Sulaiman Abdullahi', 'Sarari Klassique Merchandise Limited', 'Bachelor\'s Degree', 'Northwest University Kano', 2018, 'Certified Backend Engineer', 'Abubakar Mukhtar', 'IT Consultant', 'C2 Muhammadu Buhari Way, Tudun Yola, Kano', '70 Karkasara behind AKTH, Kano', '07037918638', 'abubakarmukhtar912@gmail.com', 'Colleague', 'Sumayyah Abdullahi Umar', '2025-11-05', NULL, 'Verified', 'Hussain Sulaiman Abdullahi', NULL, NULL, NULL, NULL, 'staff_2_1762352372.jpg', NULL, '2025-11-05 13:33:02', '2025-11-05 14:19:32', 1); -- -------------------------------------------------------- -- -- Table structure for table `staff_resources` -- CREATE TABLE `staff_resources` ( `resource_id` int(11) NOT NULL, `staff_id` int(11) NOT NULL, `resource_name` varchar(255) NOT NULL, `resource_description` text DEFAULT NULL, `serial_number` varchar(100) DEFAULT NULL, `assigned_date` date NOT NULL, `status` enum('Active','Returned','Lost','Damaged','Under Maintenance') DEFAULT 'Active', `created_by` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `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_resources` -- INSERT INTO `staff_resources` (`resource_id`, `staff_id`, `resource_name`, `resource_description`, `serial_number`, `assigned_date`, `status`, `created_by`, `created_at`, `updated_at`) VALUES (1, 1, 'Computer (HP Laptop)', 'HP laptop\r\n1TB HD + SSD\r\n12GB RAM\r\n8th Generation', '0001HP', '2025-11-04', 'Active', 1, '2025-11-04 14:07:34', '2025-11-06 08:03:12'); -- -------------------------------------------------------- -- -- Table structure for table `staff_tasks` -- CREATE TABLE `staff_tasks` ( `task_id` int(11) NOT NULL, `staff_id` int(11) NOT NULL, `task_title` varchar(255) NOT NULL, `task_description` text DEFAULT NULL, `assigned_date` date NOT NULL, `due_date` date DEFAULT NULL, `status` enum('Pending','In Progress','Completed','On Hold','Cancelled') DEFAULT 'Pending', `priority` enum('Low','Medium','High','Urgent') DEFAULT 'Medium', `completion_notes` text DEFAULT NULL, `completed_date` date DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `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_tasks` -- INSERT INTO `staff_tasks` (`task_id`, `staff_id`, `task_title`, `task_description`, `assigned_date`, `due_date`, `status`, `priority`, `completion_notes`, `completed_date`, `created_by`, `created_at`, `updated_at`) VALUES (1, 1, 'Website Update', 'Update of Company's official website with all update for month of October', '2025-11-04', '2025-11-07', 'In Progress', 'High', '', '0000-00-00', 1, '2025-11-04 14:10:14', '2025-11-04 14:19:46'), (2, 2, 'October Monthly Report', 'Submission of October monthly report.', '2025-10-31', '2025-11-07', 'Pending', 'Medium', NULL, NULL, 1, '2025-11-05 13:57:31', '2025-11-05 13:57:31'); -- -------------------------------------------------------- -- -- Table structure for table `staff_weekly_reports` -- CREATE TABLE `staff_weekly_reports` ( `report_id` int(11) NOT NULL, `staff_id` int(11) NOT NULL, `report_week` varchar(20) NOT NULL, `task_title` varchar(255) NOT NULL, `department_or_class` varchar(100) DEFAULT NULL, `achievements` text DEFAULT NULL, `challenges` text DEFAULT NULL, `recommendations` text DEFAULT NULL, `date_submitted` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `system_settings` -- CREATE TABLE `system_settings` ( `id` int(11) NOT NULL, `setting_key` varchar(100) NOT NULL, `setting_value` text 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 `system_settings` -- INSERT INTO `system_settings` (`id`, `setting_key`, `setting_value`, `updated_at`) VALUES (1, 'company_name', 'Your Company Name', '2025-11-13 09:58:10'), (2, 'company_logo', 'assets/images/logo.png', '2025-11-13 09:58:10'), (3, 'id_card_template', 'default', '2025-11-13 09:58:10'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `username` varchar(50) NOT NULL, `email` varchar(100) NOT NULL, `password_hash` varchar(255) NOT NULL, `role` enum('admin','hr') DEFAULT 'hr', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `last_login` timestamp NULL DEFAULT NULL, `is_active` tinyint(1) DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `email`, `password_hash`, `role`, `created_at`, `last_login`, `is_active`) VALUES (1, 'admin', 'admin@company.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin', '2025-11-03 14:57:08', '2025-11-13 10:01:37', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `audit_log` -- ALTER TABLE `audit_log` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `login_attempts` -- ALTER TABLE `login_attempts` ADD PRIMARY KEY (`id`), ADD KEY `idx_username_time` (`username`,`time`); -- -- Indexes for table `staff` -- ALTER TABLE `staff` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `staff_id` (`staff_id`), ADD KEY `created_by` (`created_by`); -- -- Indexes for table `staff_resources` -- ALTER TABLE `staff_resources` ADD PRIMARY KEY (`resource_id`), ADD KEY `created_by` (`created_by`), ADD KEY `idx_staff_resources_staff_id` (`staff_id`), ADD KEY `idx_staff_resources_status` (`status`); -- -- Indexes for table `staff_tasks` -- ALTER TABLE `staff_tasks` ADD PRIMARY KEY (`task_id`), ADD KEY `created_by` (`created_by`), ADD KEY `idx_staff_tasks_staff_id` (`staff_id`), ADD KEY `idx_staff_tasks_status` (`status`), ADD KEY `idx_staff_tasks_due_date` (`due_date`); -- -- Indexes for table `staff_weekly_reports` -- ALTER TABLE `staff_weekly_reports` ADD PRIMARY KEY (`report_id`), ADD UNIQUE KEY `unique_weekly_report` (`staff_id`,`report_week`); -- -- Indexes for table `system_settings` -- ALTER TABLE `system_settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `setting_key` (`setting_key`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `audit_log` -- ALTER TABLE `audit_log` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=171; -- -- AUTO_INCREMENT for table `login_attempts` -- ALTER TABLE `login_attempts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `staff` -- ALTER TABLE `staff` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `staff_resources` -- ALTER TABLE `staff_resources` MODIFY `resource_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `staff_tasks` -- ALTER TABLE `staff_tasks` MODIFY `task_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `staff_weekly_reports` -- ALTER TABLE `staff_weekly_reports` MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `system_settings` -- ALTER TABLE `system_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Constraints for dumped tables -- -- -- Constraints for table `audit_log` -- ALTER TABLE `audit_log` ADD CONSTRAINT `audit_log_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `staff` -- ALTER TABLE `staff` ADD CONSTRAINT `staff_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`); -- -- Constraints for table `staff_resources` -- ALTER TABLE `staff_resources` ADD CONSTRAINT `staff_resources_ibfk_1` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `staff_resources_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`); -- -- Constraints for table `staff_tasks` -- ALTER TABLE `staff_tasks` ADD CONSTRAINT `staff_tasks_ibfk_1` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `staff_tasks_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`); -- -- Constraints for table `staff_weekly_reports` -- ALTER TABLE `staff_weekly_reports` ADD CONSTRAINT `staff_weekly_reports_ibfk_1` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE; 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 */;