-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 21, 2026 at 06:55 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: `iams_db`
--

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

--
-- Table structure for table `accountability_scores`
--

CREATE TABLE `accountability_scores` (
  `id` int(10) UNSIGNED NOT NULL,
  `entity_id` int(10) UNSIGNED NOT NULL,
  `assessment_year` year(4) NOT NULL,
  `financial_compliance` decimal(5,2) NOT NULL DEFAULT 0.00 COMMENT 'Percentage 0-100',
  `asset_management` decimal(5,2) NOT NULL DEFAULT 0.00,
  `procurement_compliance` decimal(5,2) NOT NULL DEFAULT 0.00,
  `overall_percentage` decimal(5,2) NOT NULL DEFAULT 0.00,
  `star_rating` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '1 to 5 Stars',
  `assessed_by` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accountability_scores`
--

INSERT INTO `accountability_scores` (`id`, `entity_id`, `assessment_year`, `financial_compliance`, `asset_management`, `procurement_compliance`, `overall_percentage`, `star_rating`, `assessed_by`, `created_at`) VALUES
(1, 1, '2026', 65.00, 80.00, 45.00, 63.33, 3, 3, '2026-09-11 16:26:12'),
(2, 2, '2026', 95.00, 90.00, 92.00, 92.33, 5, 3, '2026-09-11 16:26:12');

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

--
-- Table structure for table `annual_audit_plans`
--

CREATE TABLE `annual_audit_plans` (
  `id` int(10) UNSIGNED NOT NULL,
  `entity_id` int(10) UNSIGNED NOT NULL,
  `target_year` year(4) NOT NULL,
  `planned_quarter` enum('Q1','Q2','Q3','Q4') NOT NULL,
  `lead_auditor_id` int(10) UNSIGNED NOT NULL,
  `allocated_man_days` decimal(5,2) NOT NULL DEFAULT 0.00,
  `status` enum('DRAFT','SUBMITTED','ENDORSED','APPROVED') DEFAULT 'DRAFT',
  `remarks` text 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_unicode_ci;

--
-- Dumping data for table `annual_audit_plans`
--

INSERT INTO `annual_audit_plans` (`id`, `entity_id`, `target_year`, `planned_quarter`, `lead_auditor_id`, `allocated_man_days`, `status`, `remarks`, `created_at`, `updated_at`) VALUES
(1, 1, '2026', 'Q1', 4, 15.00, 'APPROVED', NULL, '2026-09-11 16:13:27', '2026-09-11 16:13:27'),
(2, 2, '2026', 'Q2', 4, 10.00, 'SUBMITTED', NULL, '2026-09-11 16:13:27', '2026-09-11 16:13:27'),
(3, 4, '2026', 'Q3', 4, 20.00, 'DRAFT', NULL, '2026-09-11 16:13:27', '2026-09-11 16:13:27');

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

--
-- Table structure for table `auditable_entities`
--

CREATE TABLE `auditable_entities` (
  `id` int(10) UNSIGNED NOT NULL,
  `entity_code` varchar(50) NOT NULL COMMENT 'e.g., BAHE, UNIT KEWANGAN',
  `entity_name` varchar(200) NOT NULL,
  `entity_type` enum('Division','Branch','Procurement Unit','Project') NOT NULL,
  `fin_l` tinyint(3) UNSIGNED DEFAULT 0 COMMENT 'Financial Likelihood (1-5)',
  `fin_i` tinyint(3) UNSIGNED DEFAULT 0 COMMENT 'Financial Impact (1-5)',
  `perf_l` tinyint(3) UNSIGNED DEFAULT 0,
  `perf_i` tinyint(3) UNSIGNED DEFAULT 0,
  `comp_l` tinyint(3) UNSIGNED DEFAULT 0,
  `comp_i` tinyint(3) UNSIGNED DEFAULT 0,
  `media_l` tinyint(3) UNSIGNED DEFAULT 0,
  `media_i` tinyint(3) UNSIGNED DEFAULT 0,
  `risk_score` tinyint(3) UNSIGNED DEFAULT 0 COMMENT 'Max score across 4 categories',
  `risk_band` enum('Low','Medium','High') DEFAULT 'Low',
  `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_unicode_ci;

--
-- Dumping data for table `auditable_entities`
--

INSERT INTO `auditable_entities` (`id`, `entity_code`, `entity_name`, `entity_type`, `fin_l`, `fin_i`, `perf_l`, `perf_i`, `comp_l`, `comp_i`, `media_l`, `media_i`, `risk_score`, `risk_band`, `created_at`, `updated_at`) VALUES
(1, 'BAHE', 'Bahagian Hal Ehwal Eksekutif', 'Division', 4, 5, 3, 4, 5, 5, 4, 4, 25, 'High', '2026-09-10 18:00:48', '2026-09-10 18:00:48'),
(2, 'UNIT KEW', 'Unit Kewangan & Pengurusan', 'Branch', 3, 4, 2, 3, 3, 3, 1, 2, 16, 'High', '2026-09-10 18:00:48', '2026-09-10 18:00:48'),
(3, 'UNIT ASET', 'Unit Pengurusan Aset & Stor', 'Branch', 2, 2, 3, 3, 2, 2, 1, 1, 9, 'Medium', '2026-09-10 18:00:48', '2026-09-10 18:00:48'),
(4, 'PROJ ICT', 'Projek Transformasi ICT', 'Project', 4, 4, 5, 5, 3, 3, 5, 5, 25, 'High', '2026-09-10 18:00:48', '2026-09-10 18:00:48');

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

--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'NULL for system/guest actions',
  `role_id` int(10) UNSIGNED DEFAULT NULL,
  `module` varchar(50) NOT NULL,
  `action` varchar(50) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Payload of the action (e.g., changed fields)' CHECK (json_valid(`details`)),
  `record_hash` char(64) NOT NULL COMMENT 'SHA-256 hash for tamper-evidence',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_logs`
--

INSERT INTO `audit_logs` (`id`, `user_id`, `role_id`, `module`, `action`, `ip_address`, `user_agent`, `details`, `record_hash`, `created_at`) VALUES
(1, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', 'ba1a5eca7b3fd0884aa2308273a546a073d8b8746148d5b0baaf687c10d68b0f', '2026-09-10 11:48:04'),
(2, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '1fcdd1c41116d8b7d4a251136e611e82380267e4bb691cdcc84519e6b2409e52', '2026-09-11 10:27:36'),
(3, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '89543291a22603b6fa0ed64115f76a3309ae2e0083b0459ca7fb6e1f3ea37a94', '2026-09-11 10:27:39'),
(4, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', 'd4d9ab09efda2d4d101e642eeed1a426094051ef62142daa6022a7b5bd7d1ff3', '2026-09-11 10:34:26'),
(5, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', 'eb7d8a73bfe73d8a5ded5ac5bb2f6e217b531f4d4092a2a64f1f9d7817fbd9a6', '2026-09-11 10:34:46'),
(6, NULL, NULL, 'auth', 'login_failed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '{\"email\":\"auditor@iams.gov.my\",\"reason\":\"Invalid credentials or inactive\"}', '5e67f11ed4ca889aa2207acca4575742345e5b25d26a267074ae669228c5c999', '2026-09-11 10:34:46'),
(7, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '957730be67fd2546ec71877376ad0454262fed95cbc6a49329b4c2ec0ef522e6', '2026-09-11 10:35:25'),
(8, NULL, NULL, 'auth', 'login_failed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '{\"email\":\"auditor@iams.gov.my\",\"reason\":\"Invalid credentials or inactive\"}', '498f0ac5ed6795235274bacb86b5d09165695006f382f0e3d175fdd964343abf', '2026-09-11 10:35:25'),
(9, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', 'fad7d0aef0111e39390222a0a2c6e98a647342b2149c1cdb63e5142f12b195d0', '2026-09-11 10:47:41'),
(10, NULL, NULL, 'auth', 'login_failed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '{\"email\":\"auditor@iams.gov.my\",\"reason\":\"Invalid credentials or inactive\"}', '4225d2f7b102c1f5e703c76f6042e9f5a00fc31e6189af3c6af85f2e63573141', '2026-09-11 10:47:42'),
(11, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '2481894a1fbde74588ac38fc918c56be5d41de62b547d9aa0c9cc2978c8f04c2', '2026-09-11 10:48:06'),
(12, NULL, NULL, 'auth', 'login_failed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '{\"email\":\"auditor@iams.gov.my\",\"reason\":\"Invalid credentials or inactive\"}', '7d90f47a9171c8350593a24a17a88e86476d6e777b4bfe4e173064d25a89115b', '2026-09-11 10:48:06'),
(13, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '4b60c5b184f0aea841f7ff763eb5f0bfe04a588ba6256f30cd664e9a779bc37a', '2026-09-11 10:48:10'),
(14, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '48c41a0624402fef56a4d5ddf672e184c824453738d590e96da26d1c2a6d53fd', '2026-09-11 10:48:14'),
(15, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '8f333ec1b8ec625f6ef9756ed49f625ecaa828a1325217dc52ac30f5df127bb8', '2026-09-11 10:48:16'),
(16, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', 'e411e4dd373ece3f4f4f8edbc92daee187e16c3030ed33d1bf1f05810cf80d2e', '2026-09-11 10:49:28'),
(17, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '04f4d1c8759778ec56c86ef748b0fad5e622764b62daee1b0e8a12573a515604', '2026-09-11 10:50:43'),
(18, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', 'e80f376b87570d65204c285d1d599b2083a992707136f2d8350d83b8364c1d1c', '2026-09-11 10:50:44'),
(19, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '3cbea36134f64577ff67bcc10b0e05a8422c8663388336825195e18df9451975', '2026-09-11 10:50:45'),
(20, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', 'e88d2c2c31a5d890505e6ae8182546432ade5d35c7cc75b00b6ac7bf3b0e232e', '2026-09-11 10:51:06'),
(21, NULL, NULL, 'auth', 'login_failed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '{\"email\":\"auditor@iams.gov.my\",\"reason\":\"Invalid credentials or inactive\"}', '4eae832e9649c983a85acacff40a7ca9e9c615f6ff76b55b1fcf701e94808cd0', '2026-09-11 10:51:06'),
(22, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '907484788c10c3f9326dea78a084e454951e204f84975a13616912ba7f09ef06', '2026-09-11 10:54:33'),
(23, NULL, NULL, 'auth', 'login_failed', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '{\"email\":\"auditor@iams.gov.my\",\"reason\":\"Invalid credentials or inactive\"}', '71f916476104e2ec58ca0bea23cdeafdbff4eabd74484deab4f2cd26911bfc19', '2026-09-11 10:54:33'),
(24, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '5a30429edbeea58491cfbc6afd149594d37527d0325438354a7a421bace1139a', '2026-09-11 11:02:39'),
(25, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', 'cbe8093f573da99b70c8d22854449ec84ff81ac9314e8d19258dcbf168aa76b3', '2026-09-11 11:02:48'),
(26, 4, 4, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '{\"email\":\"auditor@iams.gov.my\"}', 'a54f880099f6c8fe0e474ca69f0dfed18dcc8ece4956c33fcc819c9f8b2d8913', '2026-09-11 11:02:48'),
(27, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '[]', '347fefaf68ccc1e0b56a1e2c20d81914252ea439e3cfcae4c242d561466f62d7', '2026-09-11 11:19:08'),
(28, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '0df8a44ccfac3f189a87c87686a4dfb4625ccb7916c3f408013e08d7a5347cf3', '2026-09-12 08:23:43'),
(29, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '30bf1120c0a1b85c38de2f3919b1d21983863c28db309e2ce372ffb104200742', '2026-09-12 10:40:17'),
(30, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '9698897bfec6f8bbbf6afc8a3e6934d7c71cfc2738dab3e4645e82fc19494c9f', '2026-09-12 10:40:19'),
(31, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '77481f56cc375aac1d0da17b9f423019b136cb1d6370264986ceee115ff3dc4c', '2026-09-12 10:40:21'),
(32, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '1e4afbf425cd35f34da86632afa5803ecc4deaa167f94786721f2d04e1bb597c', '2026-09-12 10:40:23'),
(33, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '8bbaae472395c68c055b7ece54b64c1dab64f626702e50c9803f4863dbd7e046', '2026-09-12 10:40:23'),
(34, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '0da93e09b780bc19a6c7ba03a224a063d37fb7e583019a88ede6fca732e89ac6', '2026-09-12 10:40:24'),
(35, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '11a1416383b9d4fec5f632cd08c2f8684b29233e27686ca8d0f3ce8fa4eb47f7', '2026-09-12 10:40:24'),
(36, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '2c49563b47e6158d9a1dc9f70c15131b8e4a20f2939479efd3edc384d79f92b8', '2026-09-12 10:40:25'),
(37, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '52348832c9bb058f5e6ada1d85d4f356785e1f8aa0be7e49071896a61d409de8', '2026-09-12 10:40:25'),
(38, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '66d95450060f67851c94207ae7c1c4fe5ab151c08cdb6ba5fbd24a12f56c99c8', '2026-09-12 10:40:26'),
(39, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '2b6a1d84cb3467b00086a4125868ecb020dae349a7631e136b2d0447c915fffe', '2026-09-12 10:40:26'),
(40, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'd061fb16609daa9ad23708c913de52ce5cb4e346f36ec9900a1b2620f42923d1', '2026-09-12 10:40:26'),
(41, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '3869ebbd551216652ede8e13f27fd6613b11dc402e6d72eb73fa2868d06488ac', '2026-09-12 10:40:27'),
(42, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'e122d584a8fc9ca46e7d71daf04bdaea96a112763c42dbec2174558f3bdd5fba', '2026-09-12 10:40:27'),
(43, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '90bf947e520dba7620ce51f6df45dd6dc0971207e9a91517b2431013ec4bf788', '2026-09-12 10:40:27'),
(44, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'd2364453556785949f980c6e2536963d401383553efdee7ce0c787a880ec2f8d', '2026-09-12 10:40:35'),
(45, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '9d6bce47fd98dd111b21a9c8b800b6c2744bbada978d5c4d9d15707074a6474e', '2026-09-12 10:40:55'),
(46, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '7698a87a2a8d173776c96aa166a8486d109741a0d3ec7cd849145ceeaffbbf1b', '2026-09-12 10:41:05'),
(47, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '4c1b4c768787fc63cf9cb7552476b8860187f532bdb9c039375d8a59577d180f', '2026-09-12 10:41:38'),
(48, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'a9287652d77f518bd993d97e44af2b4ea6143ccb19f4428decf7b1ebba731c1d', '2026-09-12 10:41:45'),
(49, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'c3c026e27aa7bbc24edab2f4e76d88d9b4104ae7476b0c0fc646d498602867eb', '2026-09-12 10:42:29'),
(50, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'ea10f053b4965c5e9d9df40a6d7228bf5760f150616b4bd06e910ab2e77c1308', '2026-09-12 10:42:50'),
(51, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '24e4e42d37b0e1df61d46e3150f540036d9b930e0a2db5344f2e10b4816f2676', '2026-09-12 10:42:55'),
(52, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'e01d31bcfc14220d9aa5e00823f52582400a12c5e8a5d3a38791b0f2bbe468a8', '2026-09-12 10:43:12'),
(53, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '457d057cf59e99f028e1929fa8b6a0c728b92b9a5bebc4193a03fab290da1f84', '2026-09-12 10:43:43'),
(54, 4, 4, 'dashboard', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '{\"status\":\"403 Forbidden\",\"role\":\"auditor\",\"user_id\":4}', '1aea491f2f751594ede0305458fe28666ee5b4d92b289ee91a4207cd843e83c4', '2026-09-12 10:44:00'),
(55, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '5c9dec993835aeb696b164a3eb2fdab2e5f95fe846fad9ef6289208d18546331', '2026-09-12 10:44:19'),
(56, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'a423d495b8b5df298cd672324b753753c72f8da75df36702b192926abe91c2d7', '2026-09-12 10:44:28'),
(57, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'faf2b37c3b021491638e8f291c09dba5cdc1e5ec5fc67313b48b06ec3d092f21', '2026-09-12 10:44:40'),
(58, 4, 4, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '{\"status\":\"403 Forbidden\",\"role\":\"auditor\",\"user_id\":4}', '24a8d5d182e403483e1815ed54db124d0f88ccfae4f96f223e180da542a767d4', '2026-09-12 10:47:22'),
(59, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'eef2fd921c73e4530c3661d48c637d9f118912e19d37bc8e6bbc3a330bfc83ea', '2026-09-12 10:47:38'),
(60, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '50d3b4da8161910464b9eeb0d84247b5d686f8b896fa6d97846ce233bee299dd', '2026-09-12 10:49:23'),
(61, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '53fee2501fa21c00fb766460ca4b88efac365a5e40ab5f2877641fc343e12481', '2026-09-12 11:14:33'),
(62, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '5091492eb0390b5a492f85bcbecb015b473e318e76b16cb5eea42094b807107c', '2026-09-12 11:14:38'),
(63, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '62937fe1fb1b91a71e76d41f2bb47ef307de54b070b4f1edeabfe111b9cf504a', '2026-09-12 11:14:41'),
(64, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '4b364df240e0d77bb2b6fe8fea9875a74c096fd6237b7879b83738cefb8ec16e', '2026-09-12 11:14:58'),
(65, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '3f6a857d7029b7df54a5d287ab71955b848287c89881e6a2879f7629c6edaba8', '2026-09-12 11:28:09'),
(66, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '009f0a047a86167a1d1fbb043979729f4b58dfd6b179de0428359cc5be355b8d', '2026-09-12 11:28:12'),
(67, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '3df28b0afb8f5acfdb6055d4d3328ee4740497c1d8e59fb95377f3d37db35647', '2026-09-12 11:28:15'),
(68, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'fba2db5713e5fa1d4340d62f99a7b7eceb9e8fdc6e607d9eadbe6152f31917ec', '2026-09-12 11:28:23'),
(69, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'e97f036b6642f384876fcf46d3a6dd5d4cc5cad475db8fb22b9a0b28b88b64fc', '2026-09-12 11:32:13'),
(70, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '6d05f380c00bbbc412750a12e90ff6f6b3e8c9060fd55dd84185c66dd460bab2', '2026-09-12 11:32:18'),
(71, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '6f06c4b7a12150b52d4a1f62ad9ae4558092a9c7a944e36ec73317a8c95070de', '2026-09-12 11:32:20'),
(72, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '7ad72e3e45a7661ec7dbbb34fea3957a87fae5aa453bb50847f07906b553c28f', '2026-09-12 11:34:28'),
(73, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'c1f33561759353ec313aa99c451363ea749a2d5d232eea39459ac026bb609653', '2026-09-12 11:35:54'),
(74, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '196d17c7b8f0204405e1afb54c6a458f65ceb901d8f7dde4e837f7ac15ca208d', '2026-09-12 11:36:45'),
(75, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '4468489376b6c6b50669075d8ba6aacf669ff8d8704ce8a7647063b063ddc76c', '2026-09-12 11:39:14'),
(76, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'ffec9090b2579fa432856823a3c51149666346cfbe7d301b7eb9fa815a0c5a9c', '2026-09-12 11:39:54'),
(77, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'd2821bce249a104e9d330ea672bac814e5a9403e88414be2e4bf0b707984ca2c', '2026-09-12 11:39:58'),
(78, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'fe233f3a21ece41e7ea328b93564348bf5cdbd79e570c50351e96718ee402d47', '2026-09-12 11:40:00'),
(79, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '47d88211a4557757025e5bf7e3567155e9c74da84afbfbf94c1f72e57c52e9f5', '2026-09-12 11:40:42'),
(80, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '12edd795b7f9e092d4f854d433a94c00f985fe92e5bb904c618714dc5f51768e', '2026-09-12 11:40:54'),
(81, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'c1f51021405a58cac0186d67da056885771502e0fe7f0f938830a5392843ca8b', '2026-09-12 11:51:50'),
(82, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'cda75a5ddc97af9f46c65ffb0b3bc2df8af8b047f4b2fb85752a8f1201af1093', '2026-09-12 12:06:48'),
(83, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '6c0ec19e2f4aeb97ff0e551fce5b199390cb9d5f0ff44c978db7981c7f5ebc23', '2026-09-12 12:07:04'),
(84, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '9f79500c7884604c337e0cc2d566fce3bb578112ce67fe44618583c8c5a02535', '2026-09-12 12:07:05'),
(85, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '02cfcda7c4fb83c116b1b3afae83d59c74f92adec8c6b9c2069e6c35f09fb34d', '2026-09-12 12:07:06'),
(86, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '5c04c79dd7917a8219fee96884572328df2d00fae21748256768b59ff2f31c4b', '2026-09-12 12:07:06'),
(87, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '6cedb77af5fbed41098bf2ec5812d05b5c9006c89145679da7eb9ed2e2468362', '2026-09-12 12:07:07'),
(88, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '36c1ba8a7178f82c39d63f9429ef95ecb6ba4a434c2c9b9507c58864a2dbb301', '2026-09-12 12:07:07'),
(89, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '93fc08ad49c2e02680c4bd9cc07d435d2a5cf290142e57e6f18d458fbbfd22f5', '2026-09-12 12:07:07'),
(90, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '738a2a22c494da1ef348071b24500056d04111d89fe971d16569cf07b11e79f0', '2026-09-12 12:07:08'),
(91, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '838be463dbc4e46157c7169f69562fddd84959272a1cd72c906a576371199748', '2026-09-12 12:07:08'),
(92, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '6de3557f3d02ae68ab6ef50ac335154420de21526ba859921874245b636ea6f2', '2026-09-12 12:07:08'),
(93, 4, 4, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'e4d1f86b54f40e61674d1e3e69c477af3a5ff70352b261f24ff5e864157a47d5', '2026-09-12 12:07:12'),
(94, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'f0da1a8cd53a670a2b7ff0ed354c8ee11dd600fad392650a79e383a0dcdbea17', '2026-09-12 12:07:17'),
(95, 4, 4, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'b997f42fe2de7bf6dcc7b6fe9968af41be61f53442e044e62623d4cd9595e35b', '2026-09-12 12:07:22'),
(96, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '9faa98a6dd17b05ed44ee472af858d846df8f64556103e8627aaa2e9d4c779a0', '2026-09-12 12:07:38'),
(97, 4, 4, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '70485dac4e7818230e5a042ca17cf267e901bd1fc3d7ca605b5b1ef19a394741', '2026-09-12 12:07:51'),
(98, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '4234252d1f1e5237b3077481349a78a721eab2e679e96a7e26bc75cd9c8ff19f', '2026-09-12 12:08:32'),
(99, 4, 4, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '259a99d1d9801eca0eb32375f13db0384c78645fedbbfb2ca7c149abf2a1e42c', '2026-09-12 12:08:36'),
(100, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '440838d1fe25ac002b8291ed1bed57a517acc2d51b156bd0b7215b02d78d5405', '2026-09-12 12:08:49'),
(101, 4, 4, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'd481f0095d169312444decf7ce869565279da89918ebda1f293847365f84cd65', '2026-09-12 12:08:53'),
(102, 4, 4, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '{\"status\":\"403 Forbidden\",\"role\":\"auditor\",\"user_id\":4}', '7d2b4dca2f77510d3c1ed7ce5ee5d1d5d9e74e8b4bc5bbd03c61068463013280', '2026-09-12 12:09:09'),
(103, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '7ac6921c4f37468fd311ebf11c6e3ad8ef6e2dc56fe107bcb2b23c2aeb2ace50', '2026-09-12 12:09:17'),
(104, 4, 4, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '{\"status\":\"403 Forbidden\",\"role\":\"auditor\",\"user_id\":4}', 'e3d0f4fe73fc742dce09c34230851542909c583411b545cdd30f6bc312a2f3c9', '2026-09-12 12:09:27'),
(105, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'c51c671a8375a6fdf891a8cb57c258067c75e2d591a13ed3f896e0048c5b580b', '2026-09-12 12:16:25'),
(106, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '2368fb5c9ed5bd2eb16998c69b97f20cb5c438b60f5cc1e4e1631f3f32405a61', '2026-09-12 12:16:28'),
(107, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '8234b337c8c3f910734158dc966d49ae46794d052bc94424f00743eaca1cc4fa', '2026-09-12 12:16:29'),
(108, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '6d76ec599d4efd78a704cd0e47be67bfb3559c2528f0b902689b6f09557f78de', '2026-09-12 12:16:32'),
(109, 4, 4, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '5f6393f6d10a60f0a2f0bf64442cc92c1feef09969856bc3ffff4f2d56e16c85', '2026-09-12 12:16:37'),
(110, 4, 4, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '9ec8c570548ab91bb8f7d5b3114c7b16c1bb2689343e8d328ebcf0f7cd4752c9', '2026-09-12 12:16:37'),
(111, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'd8854810739b39add82ddc8346a995315818717d9bbe574c70751d4d816d4067', '2026-09-12 12:30:54'),
(112, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '26e4252218352c0d61e315facfaf30aa3a1908c37665ec657bcdc0c8c1a9063e', '2026-09-12 12:31:58'),
(113, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '0ed6d9015f97712794486576af36e979acd42fe3096c3b2b063d29d90adee044', '2026-09-12 12:32:06'),
(114, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'fe57298522e26a2a651ff94d513930d7130fac04a5588ec4f5254c94185f0760', '2026-09-12 12:32:18'),
(115, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'fc04cc3a96e00cc0feea79821e75f7e77b8f32263aa25656f9abeca3b64e5467', '2026-09-12 12:32:24'),
(116, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'a31ef73746555ab634b4b81cae211148f6d2ef5e0a02c3ad7df6f58f23ddcf18', '2026-09-17 08:45:33'),
(117, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'ee6837a05de5f1e2a925c26003e5bfb9aa134649b1fcef9e0a464251045e8749', '2026-09-18 08:20:29'),
(118, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'ab22f77f4f340079515d2a85ee2ce5f1b1c961f9641f8e1fffe4c65b9e7a4119', '2026-09-18 11:34:07'),
(119, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'f656bb8e3a2c5d0dc3c3ad14d25ef18147859bc53d00dca0e22f819936ef94b9', '2026-09-18 11:53:14'),
(120, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'f549655a830c58c20d5e7ccc40f5911507ebec0674c0f23e036dc9bc41249cfc', '2026-09-18 11:59:03'),
(121, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '4779e566e4b29e774983e6a7eb04bb44cb897d5a0f4e8442e27ad2ddadb7dc62', '2026-09-22 08:23:31'),
(122, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '508c2e3073108d94bd8bb53cc31556a3562f11777b07faa51037fdc2074cc937', '2026-09-26 09:12:46'),
(123, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '13ae88d5c7231d21b01b70de146f7d71f778673d1df1d7ee8326bf0d59cdbe0b', '2026-09-26 10:07:22'),
(124, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'f6c9e8e16cb00a8d52bd637b451e96f179e7f5fb84a3dbfab0fb2c7e79b5d351', '2026-09-26 10:40:21'),
(125, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '2ec8206be2d6fd6bdd9a1dc7916036bea25f27b93eea0cebfc1492a99c403d85', '2026-09-26 10:43:46'),
(126, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '52c43eb2118512ddd53ef20d5f3dfbbb3b96e08f19672b74a9694b0613da0572', '2026-09-26 10:43:47'),
(127, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '4d0e1fd45d7980ab06c10f9566b1c27cf2ead70a4ded6a77239949598c08124c', '2026-09-26 10:43:47'),
(128, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '9aeea72aa2d620a4beae2b3730a16587767767573f03fdc28a7dd66f2ceb51ad', '2026-09-26 10:44:38'),
(129, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '5a33f7f2a96253e74b8fdb2226bff2333cb994903113d75381e72a07d2c1e08a', '2026-09-26 10:48:03'),
(130, NULL, NULL, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'de451372e1de061a59f1f14186eeb6d69b81af04c55de25db98787031e6b9f51', '2026-09-26 10:54:18'),
(131, NULL, NULL, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '{\"status\":\"success\"}', 'e3ff4c9fe2052259e9a91d617cf2ee3f12a2a8161c5b7ef6b0ecffaf5bce6136', '2026-09-26 10:54:18'),
(132, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'f80b3181fb25aca8d64dec67cd97af77aa105f0f222e96c82988c802e07cfc2b', '2026-09-26 10:54:18'),
(133, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '92060932bad290280073603bb2e1f570c1497165bed4613208b9e0747b3372a4', '2026-09-26 10:54:37'),
(134, 4, 4, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '{\"email\":\"auditor@iams.gov.my\"}', 'e01e430f295c3c418136f3fe5e09ffaa737dca2324afcdb307d62209719057c1', '2026-09-26 10:54:37'),
(135, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'fadc41a3f387b25dae90ba3006314b14dd31049f9956aa7d2647f7477b71c49e', '2026-09-26 10:54:37'),
(136, 4, 4, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'eea2b2f814f978bf37f70ef7d1d577e01429b20ba0d173d1855a724d98603fc9', '2026-09-26 10:54:47'),
(137, 4, 4, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '204ce7e3ab6e3fc5fcf3e6762560ac98cc86ea0dd359b318aed47beadc8a8f9e', '2026-09-26 10:55:36'),
(138, 4, 4, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '90a09d07fe3c1b8e8049a38d0cb6f6e9493d74299048698516e175f41598b5ea', '2026-09-26 10:55:36'),
(139, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'f6153d4a44c1de131fcbd3ae8496712ac7f9ec68af1569ed94da96264e5c7ef9', '2026-09-26 10:55:36'),
(140, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '44823a8b1bdd2bf6cd55478f3d7ecb2373b90a3e7b9fcbda0e2119750e3392db', '2026-09-26 10:55:54'),
(141, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '970fc4e1d9c9b115ad963ceb2a0bed233958382cc7c44849c087e4a51c209020', '2026-09-26 10:55:54'),
(142, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '4eaa981e65265c32e6f44e956bcd49c4c413c2a3a1a1732d89e57fc9b1a7833c', '2026-09-26 10:55:54'),
(143, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '829beff48ae60ed1e7209ea4f9d5ef5d0fbdf0fd1f7a11711d3aec35769d02bc', '2026-09-26 10:56:04'),
(144, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '94e1bd29f7c675d6e52a3b7b6e6598d2de6d0f3858f5be93f4b536a7b0c0e631', '2026-09-26 10:56:28'),
(145, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'f89eccc9e005ddb237dabdea62fbd9a91e261231e856073f68394a54c1ae8013', '2026-09-26 10:56:34'),
(146, 3, 3, 'working_papers', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'c285af12f7607d3e101704d1218f8c5a0eb5959c6bf0eeca2463448dfac30897', '2026-09-26 10:56:44'),
(147, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'c6056681f01f1b05d52ad0f988900a896f3d1e65f8c1fc5997e2dbe503dc7719', '2026-09-27 09:11:54'),
(148, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '7b28773bc9a0e2c1b0e7ca0d670ee791071a09ad28dbcbeb9c0cf8659acc503c', '2026-09-28 10:40:11'),
(149, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', 'bcd001b4c76707a9e13820809c7af0cd7d906ec016372784784714a25dc32ced', '2026-09-29 09:59:06'),
(150, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '2129b7c789fd222ecd8e171d1a2f8f945a5cb39d4f0b8c66487099f84503a863', '2026-09-30 08:36:51'),
(151, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '[]', '85350d2ed048fe19d41ba516493c87b47c6f5e84fe8c7beab826591520d85589', '2026-09-30 08:52:29'),
(152, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'e5cee0fafad34ccc646e705236670fb1ca0f4dcaa78b2c694ef28d2fa81a6463', '2026-09-30 23:01:58'),
(153, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'aa3d1f9d7eab2c3ecec0e96af726308edff3fb2ece8fc76d87bd9f494db56d94', '2026-10-01 11:53:37'),
(154, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '85191cc4a5f9e6684cfeaec1dc5d45b2bbdc1de2ab68c7c329ef678a3f118022', '2026-10-02 08:00:02'),
(155, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '74abacc2beb379c7201f3bf0c8088dee960a142ae4ede12ff8c62326cba28ced', '2026-10-03 08:10:50'),
(156, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'ffe35e532c5adbcd82c6599160f7b28033dba8fbc5b52d128f941f07a271e159', '2026-10-03 08:12:19'),
(157, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'bb9bc748a1928d4fded45f67e4ec3fe3f6e78dba5152bf170f6ec082678ca960', '2026-10-03 09:00:05'),
(158, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'fa7f7736a902689be16deef4f439a3f31474e1fb0d0396b9c9300289d49070f1', '2026-10-03 09:00:33'),
(159, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '57bdb42dcff7f78f00746f95a79a889a13a912cc02fa356654d933f5755f94fd', '2026-10-03 09:00:34'),
(160, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '49d9afe3de81b6a0ce7ad5136ef8b611b4deaa06b3d33e767481cd69ec1801ab', '2026-10-03 09:00:34'),
(161, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '0f7ac1cb3921efd76d12b4f719a6a3f74250d36dd5e695dcadb043323cc61596', '2026-10-03 09:01:05'),
(162, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a289d9e05d4d50a9d61c1d1c0f8ac8388ffe5a16ee8ba0ad5796db26501a595c', '2026-10-03 09:01:14'),
(163, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '750f8842996ec54facc54370b1a6f4633efbcd0707dc3dbb875bf9a56c922871', '2026-10-03 09:01:14'),
(164, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'ff65d86c7665dba497a5b6767363b8f2840b8a81e28df978c5b972306e9084be', '2026-10-03 09:01:14'),
(165, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '3775ca6077c057cbbc17219a818fbd18a85cff372d26f897e2bd5f2297673926', '2026-10-03 09:15:41'),
(166, 4, 4, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"auditor@iams.gov.my\"}', '12490da85af68dc74b0353b337f8620b5b34d681ef034e4044cb77402028496b', '2026-10-03 09:15:41'),
(167, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '86701c71ec63fa1f376038a579e6fa1c12e7d977b2532a1ea70132042f902bbd', '2026-10-03 09:15:41'),
(168, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'f8f50fcdf321588d08d3c18c602560d2414e4d383abbf452716344150e24e77e', '2026-10-03 09:15:46'),
(169, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'cbf7dd0c996aaed6ca1007de2e8c6ea2f15629da4d09e1f634b10c76a6746949', '2026-10-03 09:15:49'),
(170, 4, 4, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '9c4ae9f9da51d15618b780b374745958ee299a407e13e0e994c87a2e52c558be', '2026-10-03 09:15:53'),
(171, 4, 4, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '490552401e4fb37a6495047d5641229b5b59912fccb348abf14e58d6ff6ada5e', '2026-10-03 09:15:59'),
(172, 4, 4, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '8d1f6f237a12eaee8d47a5620c6648beb176fc32fb884235b355d3f2bc37ec5d', '2026-10-03 09:15:59'),
(173, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '32662ac5b1d451d4d378ce86ae4b1486db9b3246b7fbebcf9e0c77489721371b', '2026-10-03 09:15:59'),
(174, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'ba0f8b39e16b280644f72e46a575ebb16b14fa50c4fee4d89ce5fc3f6a859b54', '2026-10-03 09:38:00'),
(175, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '0ab6e2afa36901b18d1c716d77a7eeb3b96abb08bb396b01375114db34785ef5', '2026-10-03 09:38:00'),
(176, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '099170c9648300e4273773057320fefb8ad53c130d94808e40976d7c0d2956fa', '2026-10-03 09:38:00'),
(177, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'b9af59b710dd46f8af9eb8f98ffa827cd41bf9401d272d2172174205e44690ac', '2026-10-03 09:43:10'),
(178, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c0ec519bf219d09a8c640c73f1c6e9881e29104819aa57c6f4842d5b00879431', '2026-10-03 10:15:10'),
(179, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'aadd5f478ec71711f6abf67b4530a17e88053ba89b32e4d5155a974dfb2bacac', '2026-10-03 10:15:13'),
(180, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '25ef8b472e37c32a9cdfa80e7a5f11069668f4c265089d98ef7e88c2cb4df328', '2026-10-03 10:15:19'),
(181, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '54d40c8fd069aac03d05cf124c0ede6c4cb1228e05eadaf39c14caa7a0c0243a', '2026-10-03 10:15:19'),
(182, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '217c66db21aa79bfcb5073a4a6014a04bf968d39748dadc59d0dea5fc9137483', '2026-10-03 10:15:19'),
(183, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'ccbe272e29a6a12a9f5378d32b7428d4f4b261a3199d8dcf400a735be9257c9f', '2026-10-03 10:16:28'),
(184, 5, 5, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"ppd.bahe@iams.gov.my\"}', '89116089ea3f649292a6e98abf07911b28338619fbf7d19be5ebafee5e7ae4eb', '2026-10-03 10:16:29'),
(185, 5, 5, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c29518f665cec8eb037cac068837b9bc9195a6b9b73c60306cd31578b42f099b', '2026-10-03 10:16:29'),
(186, 5, 5, 'queries', 'cap_portal', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '7ae71099dbd5b31e31cde73fe58818ab9f53f0712476abd7c69a782d9a842080', '2026-10-03 10:16:46'),
(187, 5, 5, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'f74bd35b318f259311c5df72a1df03d25cb7f6776262fcbbb492850cd9b542c1', '2026-10-03 10:17:01'),
(188, 5, 5, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '5e58c05f96f5133f8a8f31cd63cea608ad2126523faf44a77a7f2500277c1426', '2026-10-03 10:17:26'),
(189, 5, 5, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '431c834064e54299c33659ef93cb89534b77304d0b36527a747168bf9072bad2', '2026-10-03 10:17:26'),
(190, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '2a57e15f78bef218597e857efbfe96519731b76572e422fa8048ce877b20530a', '2026-10-03 10:17:26'),
(191, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '3913f75585d6614271b5373081496eaf9a706e025afb50d7c2a4c062775efab6', '2026-10-03 10:29:04'),
(192, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'f455a622a214a2a5c8a1bcd40aa7ee85ffdd002d9647dc46cd63c5f7b6130e29', '2026-10-03 10:29:15'),
(193, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '24f2a1121561cd5d920674e1b3be8b9206cbfc0a566ec100d8f7a391c4b33cc2', '2026-10-03 10:29:15');
INSERT INTO `audit_logs` (`id`, `user_id`, `role_id`, `module`, `action`, `ip_address`, `user_agent`, `details`, `record_hash`, `created_at`) VALUES
(194, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '506494ea73bca3f2963881885612fd1e1d47345842d04110e61c8d36bf0511b0', '2026-10-03 10:29:15'),
(195, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a6246607c9dad9e640e6d3b5e712ea70d122b7bbca109273ffef44854b712e26', '2026-10-03 10:29:27'),
(196, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '3725b9f3b4ca99e87503df27659547eecd8be4425b1db91cb1a93f76b1c340f3', '2026-10-03 10:32:14'),
(197, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '011f10e7d43f1c1a7c1de0f805169b0a78a57612919e7062305998f5c697e892', '2026-10-03 10:32:16'),
(198, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '1491c3359ef85a680d10bf66bd98d0165022de58d738fe995c0de34a4a189524', '2026-10-03 10:32:18'),
(199, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '052549b96bf08e49f8185defb0809c738eebdec2c908d1444d4d3330e9406a42', '2026-10-03 10:32:21'),
(200, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '823dba69d6375898f4ec59759c68244f84456bc608adea643c2d14d111533162', '2026-10-03 10:37:50'),
(201, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c53af65b33b52364753d4c25bb73dd736d0e481d38e5b056e8fe0854422f36dc', '2026-10-03 10:37:54'),
(202, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a9c84f5113ede015db27431ffbcbe58df641ece65801dc9a32e897bffc328fa9', '2026-10-03 10:37:58'),
(203, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'd10228d34bc9adb5c515b1cc27f413099dadad9f295aef0eb0f51ed7fe0c836c', '2026-10-03 10:38:10'),
(204, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a6e0628d20534e6d65d61e3ff0b052020ca9da34f44c7079a64acb84fdb5a6f9', '2026-10-03 10:38:27'),
(205, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '3fcf54a38a836c694338a15a5d87e68fd5dadfd41edb6cfcad688e2867d86b0b', '2026-10-03 10:39:18'),
(206, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c4786ab62e3f89a727a499d1b3e306a795644f94e0473a819147be3783acc632', '2026-10-03 10:40:51'),
(207, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '9f291252f81e4bf3ac9ed2bf9764453a467d87bf81b940999ff06ec405200dda', '2026-10-03 10:41:18'),
(208, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c6e16619c2ebfc461d804109497774a3e65d9c5c3a2d7de95f8874de14f281a6', '2026-10-03 10:43:15'),
(209, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'ea9ec2edd1448b7e562faba8fdb94eaf1ed7ee782342762d44be7508b8126770', '2026-10-03 10:43:22'),
(210, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '4771b7505a6d7f99308e1c473a7db34d9e9f678d4e4ea7f5326da0f8d19dc0ae', '2026-10-03 10:43:26'),
(211, 3, 3, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'fc4eba7beb2355c279c7d06c8daa70a7ea028d593ca16dd48b366c25dc084d52', '2026-10-03 10:43:31'),
(212, 3, 3, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '62624640644adde2dcf96388e4ae7b58114ffbcb61a25a98044c292990f38210', '2026-10-03 10:43:36'),
(213, 3, 3, 'remediation', 'follow_up', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'e2b5af3a5e7aeff14b938282631f44221aabb84840078454b57359872445000f', '2026-10-03 10:43:49'),
(214, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '292b3a69a3eb4c2be9125d22efc16ffa5f01178cc6dbaafbcb6dbfb3017171f1', '2026-10-03 10:44:06'),
(215, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '7512a5c403cff4741d3c1aa270b80081a4f8cd0d30ff8bf6266a04fcc3c1bb69', '2026-10-03 10:44:24'),
(216, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '3e03f62be7d0006641e0cfe4738ff96cc1674ec1f7f7eda3ac9d7365a30d9e99', '2026-10-03 10:46:44'),
(217, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c43e655ab11412e3946cf4a1134a6ca2fc838baead66d43675c5fe1de185160d', '2026-10-03 10:46:59'),
(218, 3, 3, 'working_papers', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'e2814f53fe150bed9de29d5ef51b1502d224da1c5f1e714822cb11ba49d96700', '2026-10-03 10:49:01'),
(219, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '28002329e9ed8101de9d3d58250d0b31c33f4d17b802ee8cafb544d80efd37e2', '2026-10-03 10:49:15'),
(220, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '12dae0e0267b54738fe7fe9d6e4c9fbf5022cb573dbea67ccef46f1a7eb4d205', '2026-10-03 11:37:49'),
(221, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '4484e83770fdc886af9bc02902696869bdb2b399dbebe6991ae77477ce9575f8', '2026-10-03 11:37:56'),
(222, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c8c861050bd7274d9290705d2aeef7b2fa4da1411c1817df3a9dc6a66fb7ecd1', '2026-10-03 11:38:02'),
(223, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', 'e7230fe1cfc0042130391ef679829f7ed0f4b8206279a533afb24929ed9b07a4', '2026-10-03 11:38:02'),
(224, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'f53b021f3bb1ac37e655344a78103e159b874248527627dea1c4be8d1322525a', '2026-10-03 11:38:02'),
(225, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'ee4c3fe9ad4567e897d805dcf988088a7aedd7c499545265f825f9b6fe7b315c', '2026-10-03 11:38:49'),
(226, 6, 5, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"ppd.kew@iams.gov.my\"}', 'eecf349ebe10655721e37855b16c44fdcb68469ee827d6a6244ea7180f378a8f', '2026-10-03 11:38:49'),
(227, 6, 5, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '54ad26acd9cd9988043ee406c8de279e1a35be135b6d31bc047e305a75214c72', '2026-10-03 11:38:49'),
(228, 6, 5, 'queries', 'portal', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '6a54274461d5d6d6f85935768ad4e1f98a8215d5d01151ad95061d187dc50304', '2026-10-03 11:38:57'),
(229, 6, 5, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '299220b24c7ca422be0d5d714b64bbe24d18e1d3a677dcb2c79b58aa5fb049c3', '2026-10-03 11:39:04'),
(230, 6, 5, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '6803c803a3fed844075c656482a9725d22406c92ae13f19085cbade15e5b6f0b', '2026-10-03 11:39:21'),
(231, 6, 5, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '76c0633b82b2938d6840c8376f2730756ef76ee3aaa53d85d653e8833dfc1f4c', '2026-10-03 11:39:21'),
(232, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '0611fa1b1d1954edc38d3010b874933f0e4130127505cd6ee901f2cea1594a1a', '2026-10-03 11:39:21'),
(233, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '45b383302e522c43d8feb29f4bff9db6a24742788f43e417d08b8eb78989fc65', '2026-10-03 11:39:38'),
(234, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '63142415d1a44570f54269bcb56832f03671ad28055073aa81070347d7930373', '2026-10-03 11:39:38'),
(235, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '701215ba974fddb9c741989c302ab3cc7e0a72805a1192de84e16c24c8696e84', '2026-10-03 11:39:38'),
(236, 3, 3, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '15eda0e9f7be244c499f056ad1340d75e6ae8f48039e2430310b701d7b8cddf9', '2026-10-03 11:39:45'),
(237, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'd9ad11d322f5617b6a47a423568de61e767ce7ce01629b02ff510aa67562ab50', '2026-10-03 11:39:55'),
(238, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '7bf834fbf5be6ec25960a99de6e5d0a167659d33bdeb0074a081cc2350959345', '2026-10-03 12:05:14'),
(239, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '28519560bcac34d0c469617b46ddfe8a39b85448a87d55661fd3d2380ffdbfde', '2026-10-03 12:05:28'),
(240, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '8bc09af3ceb5b46ab2c8664ccd4f0706d59f72fe8bfaf6e68d8149ddf58342c8', '2026-10-03 12:05:33'),
(241, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '026966293f7c325f9c36ea00f404b7693c9b511196fb784941ae8e2fad3f39b1', '2026-10-03 12:05:33'),
(242, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '22446a92ff625ead3fd441d973f8a66cf11d1eae33c1f1931f1a8a03d7166bf5', '2026-10-03 12:05:33'),
(243, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '465d6dc40c3e02f2ca45dd2b0fd3c2ffd77482d8a41d598c588d45d1f88c280f', '2026-10-03 12:05:43'),
(244, 2, 2, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"aup@iams.gov.my\"}', 'edd7284507243642b0d3ddd5e8e9c12c903c30ed758b0a782157b29e4156c58a', '2026-10-03 12:05:43'),
(245, 2, 2, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'b353a9250ad89a45090ef432cc9919f1072978a0f3e51e4be3d21655843dca1e', '2026-10-03 12:05:43'),
(246, 2, 2, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'ff53cd622c6e2343312b6b5fd2e155db3a3286e577872fd0371955c54a92f376', '2026-10-03 12:06:04'),
(247, 2, 2, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '2373988d48916bc734184253534f6aa38ac4241a5e7044fbd15df63c543fafdf', '2026-10-03 12:06:13'),
(248, 2, 2, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'bb1b08a37af6700652e03fba01c94bd7e90516512bfe7534aec0893b373178c0', '2026-10-03 12:06:20'),
(249, 2, 2, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '2e95e293bbc0ddaf37d9912f5bf976925f174f806bff8f693a1c476712ef2f86', '2026-10-03 12:06:20'),
(250, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '83cabc7cb9adb59755cd159b5aa1bab3c1fca7d0e2b7c4241a4cf4a9a34de134', '2026-10-03 12:06:20'),
(251, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '5d4316bf636e0433cf39a2869fd708831226906c07ab1c0b0a9e2ea92d932443', '2026-10-03 12:06:31'),
(252, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', 'ff9f801ecb2a8df7ab873b1bee582cb5e474393e4d716a46ddfeadca1c143de4', '2026-10-03 12:06:31'),
(253, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c57b0536b7f70240ad3a9e50b5280e128cd30b9b6a01226ede05d98b97123b3b', '2026-10-03 12:06:31'),
(254, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '4bdbf95d148f3d0bd8509ee8f8684857caf3bd5b20b3452d41fedc1ffdc70827', '2026-10-03 12:06:38'),
(255, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'e78dcca8868671bda5362ba2e5d3aacfaeda9b2a93d208c1dd099ffd1676b395', '2026-10-03 12:19:09'),
(256, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '01d19f3b69d2a897d8bc2f421657c5c7bf7f45c54c5aa0c441de5ed2801fe68f', '2026-10-03 12:20:06'),
(257, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '23fb234c369bfba4f683ef88f69144a7ee9e964a9bd0fc31c4920d4748d9083d', '2026-10-03 12:20:08'),
(258, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'd2735b54eaf82217aab22d492991aafad065ff2b087eebf54b7ff1fe0c05580b', '2026-10-03 12:20:13'),
(259, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '7d87577412d55a11d6d5bcef34d147977be93fd49c08cfb3a6bc923a2576b11f', '2026-10-03 12:20:37'),
(260, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'ac895a87e5a6fa439d47f0c06ef5b24cee0b05ced40d5e56bfe850e436cae130', '2026-10-03 12:20:43'),
(261, 3, 3, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '7a2b5fc95bca0ac2479072f88824df4f0bbe69e21f2102c477ad247102b60085', '2026-10-03 12:21:07'),
(262, 3, 3, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a9c8be5c5d4dd3211f22b79879ae43ecf7e67139d4efcb616eb72bf4c30bcf9b', '2026-10-03 12:21:21'),
(263, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'fb55259bd6ef85ed4bf223ef77a0335b576eabbfa6195c14bbe761ccd3fc7d6d', '2026-10-03 12:21:25'),
(264, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '198bf9162571b8ea66d2c77b6a9d78cb95fd51c38a77b3a19a81a23daaa9a8a2', '2026-10-03 12:21:31'),
(265, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '26f2a2e17e57b92db9aaa39f2c0a5b70eb636ccf56ae86dc2e9d6a7c114aafca', '2026-10-03 12:21:37'),
(266, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '9c8072a124327e38982870b5dd66f9ce970ddac3da8a4d96d1613bed55cf652a', '2026-10-03 12:22:28'),
(267, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '6cd2c3c697e86dbecd75008a7c498ef9038784171d7a7da69ad713f8bd04ed8a', '2026-10-03 12:22:28'),
(268, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '5c005bf7311754ce3b54f3cdfec1da01fb3f63ed29843536559117c39ab4846c', '2026-10-03 12:22:28'),
(269, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '0ed1551d0927484d6f1eba981bad5afce72390ed6f6d8b64b2e26d4c886842f4', '2026-10-03 12:22:41'),
(270, 2, 2, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"aup@iams.gov.my\"}', '29ed7b0cd078f36e83d0d50fad027b9818def594089d4ae4ed171d3fbc350528', '2026-10-03 12:22:42'),
(271, 2, 2, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'fd2c10eae43fc751605a29b152aad59d80cefaeb8b7908c77b14ef4a34b90950', '2026-10-03 12:22:42'),
(272, 2, 2, 'remediation', 'follow_up', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '0d5a649426e73485a8069d327d34f23e01174ede8f7c7dffe2683c327d47ea3f', '2026-10-03 12:22:50'),
(273, 2, 2, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'e1199f932a2d1d9e461e335f524f24e875a02930004d56409937f3935f49ac30', '2026-10-03 12:27:46'),
(274, 2, 2, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'ad9e3896a2b8e5ddf1473c244d2742916725c50185bf290dad8a2f3abd3fda4d', '2026-10-03 12:27:59'),
(275, 2, 2, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '8a048cfc39de221853167b65ffeecf9745ec4c3d469fca77630664d6e70f3323', '2026-10-03 12:27:59'),
(276, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '007ce055b81dc9fd59067bf4f73c427733914f6f1205162e8ad817b1de4a3218', '2026-10-03 12:27:59'),
(277, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '505bf9dad9ab3d2d1d1a753437f89022b839b404ff209f707e3a92070463d779', '2026-10-04 07:56:53'),
(278, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '6af14b8078ecbd0eb8eee812ed3a2cb25f34c119fd9155ccadd12147751f64da', '2026-10-04 09:43:52'),
(279, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '3f427eda4d943d9e1fbd4e8818715d181eb7b96fbe1d5a47b4cfdab6f6eb0a50', '2026-10-04 09:44:05'),
(280, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '70846afcb9619933faae783752c8acf93ba76b0b256a8607ef01e84f105a6c4b', '2026-10-04 09:44:05'),
(281, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a29d8f830e7a5cfc72c404ad373ce3d2afda6d01b810dffb79f043f566bb68b4', '2026-10-04 09:44:05'),
(282, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a1fb38358b50ec4b6c71ab9b4866a74b08f36876381f31676c89bf5187caed0d', '2026-10-04 09:49:11'),
(283, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '03831c18a9d54e461fda0e976ddaa97dc7b1b3a7f4b5ad0e3bee89f1fd0556cc', '2026-10-04 10:27:24'),
(284, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'dc9d993bc16ed58fa085378a5b9ff3cd765c69b944a25c4646d1f8d1121a6c0a', '2026-10-04 10:27:29'),
(285, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', 'e3268ab41cec3d311251e809ac2cfbd0c158d663adf1426167d87fcdd23b35a4', '2026-10-04 10:27:29'),
(286, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '313ccb79c5c6aa9ead520de76f9ce45a42d2594768333b1fc329d64a9e5bb4ba', '2026-10-04 10:27:29'),
(287, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'f8dcee0983a14a72e6c082a82e8bc464cecd3107f7cc5a583322c00db53a83bc', '2026-10-04 10:36:49'),
(288, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '8fb2f00896282b0775f1a5bffb8ffd689b2db46216ca213457c2eba6a126de51', '2026-10-04 10:36:49'),
(289, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '499d78d73d9f3e635ac6173717308e2de577fa526e9f336182dc3766ade8240c', '2026-10-04 10:36:49'),
(290, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '0f7c63f94e0ddc8c94202aa59256e54d26c677c6073ff6f087a6ad2789537742', '2026-10-04 10:37:19'),
(291, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'de0fd1ca9401f3373ec15ba81e6bedbd1f3ee6173e43312f58b52b30ca72c7d5', '2026-10-04 10:37:33'),
(292, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '11bd63abac064350f61239dadb22d28029f2ef9a82da819b5136123fb6bcd857', '2026-10-04 10:37:38'),
(293, 3, 3, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '41df47d4a2eff3683dd90a3d8b3e644941c424333f1796a9ad7adb363c3a85ec', '2026-10-04 10:37:42'),
(294, 3, 3, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '2d6ae5c097ef49487469f398675ece7b08196b97ea235980e8fb1407aa920d22', '2026-10-04 10:37:46'),
(295, 3, 3, 'remediation', 'follow_up', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a75e1c2a347bf1c1a807dce7a0ec13662966b785f1f48963dcdc30367b2b922e', '2026-10-04 10:37:52'),
(296, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '4414cf609b295708c92c29ef8b9d4658e7bc21f645d572038e97939e8341f1c9', '2026-10-04 10:37:59'),
(297, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '20dd96415b84b5293c1420ce38198a5797b857a08e3770468462701759756f45', '2026-10-04 10:38:24'),
(298, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', 'c2bfab1991241b33d4a88bece45e972fb1e1ec7cff6a5abd690009b522027fce', '2026-10-04 10:38:24'),
(299, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'd604f014f5c9e60a69090283c69579d0b323c6af5e09a2dd3b54a36ddada4403', '2026-10-04 10:38:24'),
(300, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '7892486ddea721b6ee292bd4b00dd2f1682250e42664ce3192075c2cd9f82ff4', '2026-10-04 11:24:01'),
(301, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '20201326c9c5cdecc827919cccfaf1e9c06024963ab548aa94c3bef4baa0c2fd', '2026-10-04 11:24:04'),
(302, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '9f228fcea5b741afc0fa72bbd5ca0830e5caf1a9c3e70a659b7a347cdf2f70ab', '2026-10-04 11:24:17'),
(303, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '2be18527a49b2612808fe80502e36c0649aa5c2e6e9b954762e8ec6d54d5c647', '2026-10-04 11:24:18'),
(304, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c93a14a8a5928eb9e6bb022e953bfebd78045ce0585aa37cc90dba533d3632db', '2026-10-04 11:24:18'),
(305, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '269d7f4d3d8b9836c3405361d6e47bd727d745f4ebfbc70c05f722d0c2360090', '2026-10-04 11:24:27'),
(306, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '476ef281ea2c1007da509a15fbd6887ed2167475acda9f32d71c13b9c894325f', '2026-10-04 11:24:29'),
(307, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '1f7ffc9c227245a290c945f4c91409087bb69b9b73ed913c6368a31dcb732387', '2026-10-04 11:25:11'),
(308, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '8237429bed9c90c41c5b4bc26359642ca1ee6c238cab0f10cf4ac3f4da9e495c', '2026-10-04 11:25:25'),
(309, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '3081272cd06ef6d7c484919de0eda2952f348fdaae4660fe0e3f0da14ec57ac0', '2026-10-04 11:25:37'),
(310, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'db13035ff1d911c5402946954b1d12c58b901ea71102079c309e0d28f4d03b6a', '2026-10-04 11:25:38'),
(311, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '68d081a545d1f3408a1844fa832a838e19fb60ce504f26c8e90b31f78b022c9e', '2026-10-04 11:25:40'),
(312, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '6d72b444a12bbcffc47da6e120daa6f17283297d13868c9c0324eb92da24818c', '2026-10-04 11:25:50'),
(313, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '4e971c7119bb851a0604e854f7507e085cd3ff8a1f342478ee5a2ca710f9b8a4', '2026-10-04 11:25:52'),
(314, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '8bd7e392891435c501a885cb9134d702cad03f21339d86af1d21261d93542a14', '2026-10-04 11:25:53'),
(315, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '1a972b908bcb098309c02a0deccc7ecfef5af52c3472907ccbcd9c13c5502348', '2026-10-04 11:25:54'),
(316, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '35355a11483f7d5acfcdee2ca754dc4318c1e2059ab30c2e4dd6870e641984f7', '2026-10-04 11:26:26'),
(317, 3, 3, 'working_papers', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'b851118d805a769e27ed9f5db64fe39d5a52d22b6acadb43c6dea0040672883f', '2026-10-04 11:26:29'),
(318, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '44f4f8ed1dfdecf41e47f7d25f97aeab672a7b6ca4a48fe5309c30727e904c6b', '2026-10-04 11:26:37'),
(319, 3, 3, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'b950bcb08d1c8367f2ffa03521be4cc049582b327e6625ecd378b2cb0f6e625a', '2026-10-04 11:26:42'),
(320, 3, 3, 'queries', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '6d8ced5779c2d361aa8caa46e0019bc024b5baf8ae7752b6991ee23a98044be1', '2026-10-04 11:26:49'),
(321, 3, 3, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'cc003d21136c057b574d2931a2b00e1ba8b15c41638e4a2112215b17a47232ff', '2026-10-04 11:26:54'),
(322, 3, 3, 'queries', 'closing_meeting', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '34e07e18265ac36a78247b738a2973f259a7fc4f67fa2191abcb43a4292a963e', '2026-10-04 11:26:57'),
(323, 3, 3, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '436d8e647ce09fd198892131e11b67bac7e12ca60a94655d19b33ccaffdfeb36', '2026-10-04 11:27:02'),
(324, 3, 3, 'queries', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '7d5bba7a5d077e8d1a2d0d004e504745f2fb2c3051917f3ed277d3b90f82fb34', '2026-10-04 11:27:04'),
(325, 3, 3, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '74f4e00a8a57f6a928236c6a6a9fae578f3f95c0fe75e4f9d0a219c9330163e0', '2026-10-04 11:27:05'),
(326, 3, 3, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '6c4fa6fe7b52e546ba70a8778dedfc9f021583503e8653d8499169ad4fbda3ec', '2026-10-04 11:27:10'),
(327, 3, 3, 'remediation', 'follow_up', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '9a63da2135f3ae58c20f9b8a49bde100af526ae684fea925281f84b5ef125f2b', '2026-10-04 11:27:17'),
(328, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '058f6b1939ac6720282a98804425de159a6d38998915ff28f531253a03d9095a', '2026-10-04 11:27:49'),
(329, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c26aebf473abf628c609fc742e21ace2c17588915ed77a6c6d7eb4b1b201904f', '2026-10-04 11:36:56'),
(330, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '4ebe641db6d4704b46b7bb221fdac994c2d992953aacea7f9ab286772dba0879', '2026-10-04 11:36:56'),
(331, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '89e83c963d35383319bd61611f83405226593c4addd0f85109a5324cd07ab27b', '2026-10-04 11:36:56'),
(332, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'f2875b0ea8695daa8c8fc279bf121a9e0b0861df278ef3d8fcbaf449970ca00e', '2026-10-04 11:36:58'),
(333, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '876c0913ca0583df691b3d8578d709dcbedef72ee4c6dea8891939aa678b5228', '2026-10-04 11:39:37'),
(334, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'd830bef32c969e7d38c47faedd4519884c8b7d4352b64255853659a5d5d5e008', '2026-10-04 11:42:00'),
(335, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '7804e28c23114694456a7ae7d1ab93cc042d287a490569d66bfc918e9a64d8d8', '2026-10-04 11:42:00'),
(336, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a579b32644d7faa9aa8231fd1aabfaa6f618c7b2508b50e18b8f0479a10492cf', '2026-10-04 11:42:00'),
(337, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '503bca006c0f05ad98bbc7fefc90522da5d34389c21a869b378b4a39b4cfc698', '2026-10-04 11:42:18'),
(338, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '6e1e6947777c4026b45ce609545ee1b35d526f3bb7d6fb23f3c4c0bd75b10521', '2026-10-04 11:42:26'),
(339, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', 'c64bd378b22bb25cd1b2c07e803ef607fc2047fd0d9a84e880c135ebdeadf009', '2026-10-04 11:42:26'),
(340, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'ffe1201c03ce73aade376456cf07eb64296f9e3d18e7921024687774d8274f52', '2026-10-04 11:42:26'),
(341, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'efc08a0be5e07a80dee91fc3734815bed63eabb91c3622d1b84d5a68202e178d', '2026-10-04 11:50:25'),
(342, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '83638d9e66bcfdf8084626e64c145b842d3cfd1849b1774913099dd2417659cb', '2026-10-04 11:51:17'),
(343, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '73a0de444a6815298d6bea2cdfadc33478e56bfc0c7119a751705f24e88afb8c', '2026-10-04 11:52:06'),
(344, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '7b94b688cd74f843ee569d303e2c96fe7f2177383429bde156e564b757bf457b', '2026-10-04 11:52:11'),
(345, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '250742b33a0d8f528b5f4ed6a5ee5468c8ecb81d4e1ce4cdda6d4c7ecdeb1d37', '2026-10-04 11:52:39'),
(346, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a65697c7ee0e4094b5184a67f5c5e8307edc446fcb9965ad2c0fede41cdbe95b', '2026-10-04 11:52:40'),
(347, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '36cd9e75f7e16d00a8a77a8571bba0f0354ad16a0846174e6c82885c6b30f002', '2026-10-04 11:52:54'),
(348, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'df5950c3aea73c7fcdd9d819a0b8e02318837ae1d0ce68d640926e0daa1636d1', '2026-10-04 12:03:52'),
(349, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '8095325c24b6a7fa3c56879629088e534ccbaa896a63e6f578849140e4e6cdea', '2026-10-04 12:03:52'),
(350, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'd8c9e2387a1335e01f1351541215a6492adc5732556b0af3cf1a0be5a57bf9e3', '2026-10-04 12:03:52'),
(351, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'b08f5de82116bfaee39e03004e9b99acf32be3574aa30a0832a2195e36dae7f8', '2026-10-04 12:04:04'),
(352, 3, 3, 'working_papers', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c39c3ac7e320d3ff0acc6415da3df18b358fbc4dfe7a5f7b60a8c22531cbcf7a', '2026-10-04 12:04:06'),
(353, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'f61d3077b45c67bf082e3e7170ff30a2c3ae1079d643383ebb979f7fa99b2416', '2026-10-04 12:04:30'),
(354, 3, 3, 'working_papers', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '33145ef04b58eb37560142bf738cdf1d9e0de3ac8ead8ea6dc110b44ef94f78e', '2026-10-04 12:04:51'),
(355, 3, 3, 'working_papers', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c928fb9575a3b1ae5cdf688e4e3f46b3798d0499984aa601c063172514713bea', '2026-10-04 12:06:16'),
(356, 3, 3, 'working_papers', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '5dee12a9887856a8df95edc077098904fcd6be3a1db67b493ea92285547ef3a8', '2026-10-04 12:07:41'),
(357, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '02981efc9f82158bb6b950241ce8502c609df4585de37a581c403315af0b5b7c', '2026-10-04 12:07:50'),
(358, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '40de2bd406465b49445d1d66b16b562d8c86af77e1b24c0cb0b6f7a9530afbda', '2026-10-04 12:07:53'),
(359, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '41dadda51bcf6208b7b4fa907869a92b7b28289e46108a001f210250b139efe0', '2026-10-04 12:07:53'),
(360, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '1e6954f36fcc17458056a7a2c39b545eaad9d157ba9cd551b6068b7b274b6500', '2026-10-04 12:07:53'),
(361, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'b4945bbbb81564cc512b66d76aaa14558eb57f22feeba7ef5867faecc43861da', '2026-10-04 12:07:56'),
(362, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '1eac07585e6ff54fae961cd22430624fe633d6c4bb387b7d7d73bbd976b3387e', '2026-10-04 12:15:12'),
(363, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '940e4b155f62ec54320a24b403f874ee27bc12d6593a0afbaf8b5b3f1692f727', '2026-10-04 12:15:12'),
(364, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'd2bcabebdecdaffa5551581d9ccf3f9524887914b3c10ada7f772f0ad7bd9422', '2026-10-04 12:15:12'),
(365, 3, 3, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'c533b6faab2c609db07cac753c252e6c20e2d80bbec723e45558fa690a8aa4a3', '2026-10-04 12:15:16'),
(366, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'db47f8bbadd44c002bcbdc62704c91de1da8242763ed05adf70fb8e5dcd8df72', '2026-10-04 12:15:36'),
(367, 3, 3, 'remediation', 'follow_up', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'b49486b969d7862cdae8d86b193a22d620137952d1f5f974972c28931e90ea80', '2026-10-04 12:15:48'),
(368, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '139c20250b1ef25375be081a4e745d7562b69736bc25f4a821143313c2759293', '2026-10-04 12:16:03'),
(369, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a5f2133419000f9778b6b6cc295fe4760ae190cc44637a35bad732f634f3ccae', '2026-10-04 12:16:18'),
(370, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '881760e8193399f28bf88426547c5fb4857b5fda340a639fb82588f2759ee17c', '2026-10-04 12:16:24'),
(371, 3, 3, 'remediation', 'follow_up', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '5dbe29d22975e1add1e0bc544e8a1185aad3f7bc5eda33673e204c0bc62c6f5f', '2026-10-04 12:16:30'),
(372, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '207e04f9d7eb9cb742da2f6974c821a91ffe384e1d7b9278976c19566455383a', '2026-10-04 12:16:52'),
(373, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '333045955533806aeaddf19673243704275bac4b14fcc6c8b0a7656a2f670c20', '2026-10-04 12:16:58'),
(374, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '4752577451099f614ef8caddd39560a8bf8783d2ec36a665d766aa991ec86314', '2026-10-04 12:16:58'),
(375, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'e7845a935134e96abfdfdc5f63813b362518c48382ed213a2620c59996306579', '2026-10-04 12:16:58'),
(376, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '039fcfb0844bddc32e32f281867b34149e7070a1d6c3431e512023bafbd4f9b8', '2026-10-04 12:17:06'),
(377, 2, 2, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"email\":\"aup@iams.gov.my\"}', '7dd60e9e59ee4f346659ad8d4d180dde374cf6c423a64bf47c1a5061acb65b1e', '2026-10-04 12:17:06'),
(378, 2, 2, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a90c232a49a44b0dc9dc62aa7cc57ed68f3ff56404f8d838df28ac409d589593', '2026-10-04 12:17:06'),
(379, 2, 2, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '6edb91b30edda548e8fc286ed6541a1af8a530a90603f392319d06bc9a72c2c4', '2026-10-04 12:17:12'),
(380, 2, 2, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '325a36ac11138b1b77a45b2654aa055d94d15c150501bffecd9ee1bd89947a90', '2026-10-04 12:19:03'),
(381, 2, 2, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '1ff5a21e76cdd2d7c38fb77288f48bcad7f2c5d9f5f0db38cf5bc6c304002558', '2026-10-04 12:21:46'),
(382, 2, 2, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'f149d14a29aeb74fc079072a657a2ce012efacdb3dbe7aaad36dc00015e8178d', '2026-10-04 12:21:50'),
(383, 2, 2, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '252461c103a10f55c19135bafed9265b2e0189e722ee51a05ba02fd792b2f987', '2026-10-04 12:21:56'),
(384, 2, 2, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '8993542510d6d5b1b973b2656909d8bfa4848ed7012b2173c0319efcc6623e12', '2026-10-04 12:29:23'),
(385, 2, 2, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '{\"status\":\"success\"}', '7cc39d9df2cd46960bd44eadbb3f3782b153bb761a445ff5c341bdda190e6332', '2026-10-04 12:29:23'),
(386, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'eeec0aecac723fc5f710c1c1740f180568961fb4a3983517116ab8bf44ac34a7', '2026-10-04 12:29:23');
INSERT INTO `audit_logs` (`id`, `user_id`, `role_id`, `module`, `action`, `ip_address`, `user_agent`, `details`, `record_hash`, `created_at`) VALUES
(387, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '34cc498d523532e22103ebd5c12cc9ed085f268a7cd001666fddffa2283f2bff', '2026-10-05 08:20:57'),
(388, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '513a839013d17cca6e6b7e520d73c98c42bfde4c98ac4f07f7fd3b6dec7dc2fe', '2026-10-06 08:54:34'),
(389, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'fbf52c267b462cf5fdee542073e8424cde6beaf0e1362d96b60212d6e511bce6', '2026-10-06 11:07:31'),
(390, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'e09f8f46bed5eac2319676919eab2acd710c69d0a66fc6b20f6ac27c6b5da477', '2026-10-07 08:24:22'),
(391, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', '954f6727318a3c36d68080910c0be9c76d27126fb79e410cf8acbaac227bd17b', '2026-10-07 09:46:12'),
(392, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'a8125bb6f062d749aa0e82f4c037acc877211c7cac1a0e297a8f05634829b2cf', '2026-10-08 08:05:16'),
(393, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'f72c8eb601cb854ec2492fa33753c7f2bffb59c90efdab58f886c6cd1ff4e286', '2026-10-10 11:12:57'),
(394, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36', '[]', 'bad38da666c0ef6b507897ece7896ccabeac969029b5cb3759d80213dfa7654f', '2026-10-11 10:26:58'),
(395, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '4a6ea1653c8eb81d8b6615e937b6c0abc1e0af385f598bb3ac16f512aad686d9', '2026-10-13 11:58:51'),
(396, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '5818d7b6bbf71f4d0dd97717a713faec4b864f8e07523de34b8d6840dfb93f4a', '2026-10-15 10:24:49'),
(397, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'b13601f7231fe168d72de4ed7332c806ebb0ea956e09ebd87e54b82f80dd53d4', '2026-10-20 09:42:46'),
(398, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'b02b06543fd102ef8d46096d150799566ba778b45ff1833bf4d978151eab2115', '2026-10-20 09:43:22'),
(399, 1, 1, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '{\"email\":\"ksu@iams.gov.my\"}', '4e65ae2c6f04128ced8d6e530aaec3816563392ac78c9320f882456f3b67d451', '2026-10-20 09:43:23'),
(400, 1, 1, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'f45b867068da4e671f1123b3dfbb6b6599ae03b7fc0089ee9935a9c685a69644', '2026-10-20 09:43:23'),
(401, 1, 1, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '01c92201d6cc21753caa08057263d664cf9d44bf645c250cdb72f4f5c81ac567', '2026-10-20 09:43:46'),
(402, 1, 1, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '6b1b41f7a97637e1ac28dafca817b6f4b683f558cdcc7089bee2217031549ff8', '2026-10-20 09:43:52'),
(403, 1, 1, 'remediation', 'follow_up', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'f776711df21113d53abd02906564815b8ece6e33797574522a76461c6d49eea4', '2026-10-20 09:43:58'),
(404, 1, 1, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '1fab37cd35f9170e73aa8f9d285b3547d97cc9377ccec14feede82b0810a317e', '2026-10-20 09:44:19'),
(405, 1, 1, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '40c029c28fe49409bd1a62fdcce69339bb283625a79deb07565c92e927eea598', '2026-10-20 09:44:24'),
(406, 1, 1, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '{\"status\":\"success\"}', 'dd6472083cde8a09329ec9ae83ea1de886cd2fcfc4fea11a29e3b66fd750b8eb', '2026-10-20 09:44:24'),
(407, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '4d385e46c0767bff1d685b7348ec12fc8a2e45e4b91dd184912440b99e956812', '2026-10-20 09:44:24'),
(408, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '05d8a3ee7156c8f095898142fd7bfaef8bb8940b8bedda371d7514db48207a8b', '2026-10-20 09:44:40'),
(409, 2, 2, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '{\"email\":\"aup@iams.gov.my\"}', '8c4c54c7a69bfeba152233bf74dc5eb1e999de744ca77bc0aa040df0a7cd14e4', '2026-10-20 09:44:40'),
(410, 2, 2, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '02ed81fe9f84a6a2858fadd521d65b991bbea7da1782203f17df5929c5a3d80f', '2026-10-20 09:44:40'),
(411, 2, 2, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '84dda51009c0aeaa7bc992ec375f786537e733f6f4e75a22b84aad0d93b63407', '2026-10-20 09:44:50'),
(412, 2, 2, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '1d115347945a99c253f7d263189ffc54a7b2f41e6b568b636053ee9521326042', '2026-10-20 09:45:08'),
(413, 2, 2, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '7d054d54cc0c5e2ae023e2154afb97bd795a3e803aa82a08f4abcb42a4cae599', '2026-10-20 09:45:15'),
(414, 2, 2, 'queries', 'closing_meeting', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '{\"status\":\"403 Forbidden\",\"role\":\"audit_committee\",\"user_id\":2}', 'e2972905a78ab9421a74628a3ade04422dbf02ad2bb6e7271242d5dc7bcce5e2', '2026-10-20 09:45:20'),
(415, 2, 2, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'af15f42c1679e2acc9f9c7b656e9aa4e9938421d1ffcd588304bf73a1d0c650b', '2026-10-20 09:45:34'),
(416, 2, 2, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '8efdc3ec8ea0292d91ccd96d70571855c3aa9bf9f7844138d8f041f1b3bfebe6', '2026-10-20 09:45:39'),
(417, 2, 2, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'bb31ef2997f55347636ce248e5c4ec592b75c71b503d2e4d15de3aff0ac50d31', '2026-10-20 09:45:42'),
(418, 2, 2, 'queries', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '{\"status\":\"403 Forbidden\",\"role\":\"audit_committee\",\"user_id\":2}', 'a6c2c3f3d321127c6a3233da8c01a373ad4aa8ae4fc88c96f1cb396ae5895d8b', '2026-10-20 09:45:45'),
(419, 2, 2, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '5c4928330832dcab311de11f2a3b102a581595b95dacc6dc82fb5fff1e3a5af6', '2026-10-20 09:46:04'),
(420, 2, 2, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '72f26f7c782c45ab2da862a1eac3ea6f23498619ddcfb23f2f16ff7a6683ddbe', '2026-10-20 09:46:10'),
(421, 2, 2, 'remediation', 'follow_up', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '1e5c8edc36fa393150dc02a6a3e66e811a3d783ce9e6a0ffa8e0bbb23ae96def', '2026-10-20 09:46:18'),
(422, 2, 2, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '70094fe1a40d71aad3399b96994306f7967a7bf742203983cf2690175b25cef0', '2026-10-20 09:46:48'),
(423, 2, 2, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '35c883759924c3bc6ad437b73e91ad3e4f07f60063f2a10aaa89021c17d3f6a9', '2026-10-20 09:46:56'),
(424, 2, 2, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '600a8a985d9edcb0787e22f11b9b63fbb0348decbc9e623252d8d4ab4f955d3e', '2026-10-20 09:46:58'),
(425, 2, 2, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '9c9f7c781b519a9a5fb9419685e2a3f1347bddc04393afe216d158950914752d', '2026-10-20 09:47:41'),
(426, 2, 2, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '{\"status\":\"success\"}', 'd23c789693e08a75478209d20357f5fd54b7513b1d4dba21a835adc3bfb32999', '2026-10-20 09:47:41'),
(427, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '63d805376fa716ee1eefe918486297117ea384d0fd14f775552406105b4b5976', '2026-10-20 09:47:41'),
(428, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'f1e89f61fd9e477b88c29cbfbe8a0ea24596070c92f2827d3e9ca0dfb654d025', '2026-10-20 09:48:00'),
(429, 3, 3, 'auth', 'login_success', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '{\"email\":\"kad@iams.gov.my\"}', '964b9112614cbe228a32f7df60ee4bd10ed08a2ed4c7b29ceefe49e9162fc66d', '2026-10-20 09:48:00'),
(430, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '5e9767b93c27ddfff998519dd12bf56aabe1eff2b942756e907a2183ee7a083a', '2026-10-20 09:48:00'),
(431, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '45192e8bababe5c81753f87334275e5bdef93f69cc698852f7b1bbd1f92cff26', '2026-10-20 09:48:14'),
(432, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '6a473d06c7684086defa5accd9d4fe8b876ca487d3e3308aaa5fdd0287b8f48e', '2026-10-20 09:48:55'),
(433, 3, 3, 'engagement', 'notice', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '5e02b3ba50be065b4b9d442ed113873500ee8267b617e959f5ce9d63a4fa1517', '2026-10-20 09:49:21'),
(434, 3, 3, 'engagement', 'notice', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '9cd9fb4ff3c993e91d6707a5dc494241320a6d131c4951f173482047a3a78076', '2026-10-20 10:03:57'),
(435, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '9553b1bbe6ebe0936bb35d7f5503e6dfb46776314c5f66b38a076899eda01d63', '2026-10-20 10:04:17'),
(436, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'a507f8d79858f65e1d754f6a63514b82b7556482b9215b8169cd02b3f93bc3a3', '2026-10-20 10:26:17'),
(437, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '5702688dddcb07b9316f57c3c5c5cdf9a7ba7bfff48c1436f0ec05f3f7dbfabf', '2026-10-20 10:26:19'),
(438, 3, 3, 'engagement', 'opening_meeting', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '35dc167d2a9b0ed2a7452012e43e646ac8a4c6f1d6e1128b4eaae5819a538384', '2026-10-20 10:26:57'),
(439, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'be91d0bc66d85d046b6ea0586a08a9679b281878c6caffbfb46510644b63b89c', '2026-10-20 10:27:53'),
(440, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '99dd5e4dd91bac0984c0185a1230ab15e0ca2424c16b3b9276e1e80c7878f11f', '2026-10-20 10:28:35'),
(441, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '5f26d220297338e60820484e4882b2c5669daa9546387301a64944f9ac259552', '2026-10-20 10:28:50'),
(442, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '576ae1776054e6117e9f9dc0c60db6249894382afbe4b8242782ec9674fe3547', '2026-10-20 10:29:07'),
(443, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '96a11560cbd860e9e7fb38224663a37d345c248ed2d2affce92a71f73a75bb2b', '2026-10-20 10:29:13'),
(444, 3, 3, 'working_papers', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'd3555a6c682d1bb31e81780ff0da2aabbd98a8bb8ae7ac89396486e9222bffb9', '2026-10-20 10:29:22'),
(445, 3, 3, 'working_papers', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '8c089842602ca2cd9d586a8eb58372080cabe82aa6239e56b5824e5d62e93872', '2026-10-20 10:38:47'),
(446, 3, 3, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'e8100a59f32e11e97d8c25ef4f61697c730ea31d6e4063066cc691ddc437c7ff', '2026-10-20 10:39:07'),
(447, 3, 3, 'queries', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'c0880591e3aa0803d3df9db11104bfed301120585f57d6a745b20d7454589ec3', '2026-10-20 10:39:33'),
(448, 3, 3, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'f687736f33876da247660dd1399d0f4693accc3e5ff6cb09e1ac39096dd33c35', '2026-10-20 10:41:21'),
(449, 3, 3, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'd5de7052366d88e085d46f3f377c9ae6323350d160a15b32aad53357f85d1f78', '2026-10-20 10:47:43'),
(450, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'd94fc6b5fab2e0edbb561452496e41a75a1f0bf5746f10c69df458fdaac82534', '2026-10-20 10:48:15'),
(451, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'd1f81d619931f4317eacff77bf7a23695b5d49d31b60486acefc7a701a9c7303', '2026-10-20 10:51:52'),
(452, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'ea3e2bf82efdcae05f9cddcf307f54bb9c02128081a6563306589ead17b1ac78', '2026-10-20 10:51:56'),
(453, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '22503a44f6d06c045ffd8cf09d84aece510ded061295907389eaa3dface47da6', '2026-10-20 10:51:58'),
(454, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '68f2fd5482ad123c1d853450bf908e2085c6f65cd7f57160a7f45e3ff1f17a0b', '2026-10-20 10:51:59'),
(455, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'd73aadc354f39ebb6cdbf7758e587487c5f839dc783600821d91348e78722b7a', '2026-10-20 10:52:00'),
(456, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'd88384b881417027db931b471c3444b1e4df9f24d30e7fd6a8ba579fab71aa69', '2026-10-20 10:52:01'),
(457, 3, 3, 'queries', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '9c79b3594daf6d2cd0e2dc3ca673e9687cb9624bee836c4948e0c44cbb2875bc', '2026-10-20 10:52:05'),
(458, 3, 3, 'working_papers', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '1cc8f38c9336a3d8806a8b8f3b0d0dac9c4361c49a8a76cfd928267667c0d3b6', '2026-10-20 10:52:07'),
(459, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '645cff66a6ff4676bf26a0d3ce8a99e2775f9465fbf9260652240e7b0bd6b787', '2026-10-20 10:52:08'),
(460, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'fdd4588e6945330cc8550b0626b3dc755225b86f052a834d0f6f52471ae58e71', '2026-10-20 10:52:09'),
(461, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '03337032ae33c60eb214c3db236c8ecc5863713f04148a2abd03053686f6938a', '2026-10-20 10:52:12'),
(462, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '99da359b2d80740a8206e35359800ca6389c75261e85f9b4012fd10f81f53a8c', '2026-10-20 10:52:13'),
(463, 3, 3, 'engagement', 'checklists', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '6a599ce45893df4d008759497d681bc74e60ccf684c044f83ff139c0a5767932', '2026-10-20 10:52:14'),
(464, 3, 3, 'engagement', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'aa44aa1b892550a5ea5a6c66552275ff4caed50d2c4a56b5e88597a0657935a3', '2026-10-20 10:52:14'),
(465, 3, 3, 'audit_universe', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '23d85fa8e82c53444ed1f1a6e7f0185bbbb38c946a16c8e9e3f75795f48f8fc9', '2026-10-20 10:52:15'),
(466, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '4590485fa8f5318bfdfa33ea72727664f90e01fbbffdb6b674c76f8410abdf53', '2026-10-20 10:52:16'),
(467, 3, 3, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '9c29aa15729ef751bc6853473e08b0c2543862f869017ea2371285a4c3e082eb', '2026-10-20 10:52:17'),
(468, 3, 3, 'dashboard', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '772318f918dcd7b0e802b70bc2b55fe939f2e418fd9490cd2df0f72dcfc2cec2', '2026-10-20 10:52:17'),
(469, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'e6f3073956a10d2551e4db0652f816db77b5d1be7b29664390beb60c9307fa82', '2026-10-20 10:52:26'),
(470, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '8bee4a6bb3270e56a220bddd8db2a7b1b932e88654806f32f29e2f2aaaa4677d', '2026-10-20 10:52:30'),
(471, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '0e77b05eee16cb2e512770584d762fb26767fa999aacbc446ff8091cb5ec068d', '2026-10-20 10:52:37'),
(472, 3, 3, 'working_papers', 'create', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '151e1a29777f2a107eeaf60360673ac2b1c498db88ea54fa22df6d729174a37a', '2026-10-20 10:55:34'),
(473, 3, 3, 'working_papers', 'index', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '09601bb8f340edc353437baf0755b1d877b22c7989f7ecec44c2704989a55ef4', '2026-10-20 10:55:53'),
(474, 3, 3, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '6f0dcf15a09d34168833866e0024431a002760f7634e3b99baa13d1d57ada008', '2026-10-20 10:58:40'),
(475, 3, 3, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '5da1831a7b59c27fee86f3a9f2f6c5368ccbd8b2be20010522dde85ea5512725', '2026-10-20 10:59:28'),
(476, 3, 3, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '6d0b38dc364e68b31ad75ff150ef8017477805aca4ca132196360e8ac314046e', '2026-10-20 11:17:57'),
(477, 3, 3, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', 'b4521b8347770e935ac97f8e6ccb298d9f3d8d37f02f6978645e586b12a32288', '2026-10-20 11:18:02'),
(478, 3, 3, 'reports', 'executive_dashboard', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '7b799601a695abbe8f481ffb9b0f0179e085230d00c3b90c717aa1565d123241', '2026-10-20 11:18:12'),
(479, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '2c95177d9e3cdd5100355ebdc0b0cded3e527835e1013f291a53d5345cb35055', '2026-10-20 11:19:53'),
(480, 3, 3, 'auth', 'logout', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '{\"status\":\"success\"}', 'ede40c85e6a069de700d06bfa1d4a330dd059abb10d13f80db75ead896901726', '2026-10-20 11:19:53'),
(481, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', '[]', '76cacaf089c071ab72939a0c7368b12af0924fc6f0cbf70dc47d5d2218957f28', '2026-10-20 11:19:53'),
(482, NULL, NULL, 'auth', 'login', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/156.0.0.0 Safari/537.36', '[]', '8fe42af4a0a2e53ac451106f4cc0ca998674f53f81470f09df97223426715816', '2026-10-21 10:53:35');

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

--
-- Table structure for table `audit_queries`
--

CREATE TABLE `audit_queries` (
  `id` int(10) UNSIGNED NOT NULL,
  `engagement_id` int(10) UNSIGNED NOT NULL,
  `working_paper_id` int(10) UNSIGNED NOT NULL COMMENT 'Source of the observation',
  `query_ref_no` varchar(50) NOT NULL COMMENT 'e.g., KUERI-KEW-01',
  `query_text` text NOT NULL COMMENT 'The formal question/observation directed to auditee',
  `risk_rating` enum('HIGH','MEDIUM','LOW') NOT NULL,
  `deadline_date` date NOT NULL,
  `status` enum('DRAFT','ISSUED','REPLIED','CLOSED') DEFAULT 'DRAFT',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_queries`
--

INSERT INTO `audit_queries` (`id`, `engagement_id`, `working_paper_id`, `query_ref_no`, `query_text`, `risk_rating`, `deadline_date`, `status`, `created_at`) VALUES
(1, 1, 1, 'KUERI-BAHE-01', 'Sila jelaskan mengapa 3 fail perolehan tidak mematuhi PP 3.2 mengenai minimum 3 sebut harga, dan apakah tindakan pembetulan yang akan diambil?', 'HIGH', '2026-09-07', 'ISSUED', '2026-09-11 16:23:51'),
(2, 1, 2, 'KUERI-BAHE-02', 'Sila kemukakan bukti pendaftaran 15 unit komputer riba tersebut ke dalam sistem e-DAFTAR.', 'MEDIUM', '2026-09-17', 'REPLIED', '2026-09-11 16:23:51');

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

--
-- Table structure for table `cap_evidences`
--

CREATE TABLE `cap_evidences` (
  `id` int(10) UNSIGNED NOT NULL,
  `cap_id` int(10) UNSIGNED NOT NULL,
  `original_filename` varchar(255) NOT NULL,
  `stored_filename` varchar(255) NOT NULL,
  `mime_type` varchar(100) NOT NULL,
  `file_size` int(10) UNSIGNED NOT NULL,
  `uploaded_by` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `closing_meetings`
--

CREATE TABLE `closing_meetings` (
  `id` int(10) UNSIGNED NOT NULL,
  `engagement_id` int(10) UNSIGNED NOT NULL,
  `meeting_date` date NOT NULL,
  `venue` varchar(200) NOT NULL,
  `minutes` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `closing_meetings`
--

INSERT INTO `closing_meetings` (`id`, `engagement_id`, `meeting_date`, `venue`, `minutes`, `created_at`) VALUES
(1, 1, '2026-09-22', 'Bilik Mesyuarat Utama', 'Auditee bersetuju dengan penemuan WP-BAHE-02 tetapi membantah penemuan WP-BAHE-01 kerana mendapat pekeliling baru.', '2026-09-11 16:24:36');

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

--
-- Table structure for table `closing_meeting_findings`
--

CREATE TABLE `closing_meeting_findings` (
  `id` int(10) UNSIGNED NOT NULL,
  `closing_meeting_id` int(10) UNSIGNED NOT NULL,
  `query_id` int(10) UNSIGNED NOT NULL,
  `status` enum('AGREED','DISPUTED') NOT NULL,
  `auditee_comments` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `closing_meeting_findings`
--

INSERT INTO `closing_meeting_findings` (`id`, `closing_meeting_id`, `query_id`, `status`, `auditee_comments`) VALUES
(1, 1, 1, 'DISPUTED', 'Kami telah mendapat pekeliling pengecualian dari Kementerian Kewangan pada bulan Feb.'),
(2, 1, 2, 'AGREED', 'Kami bersetuju dan telah mengambil tindakan pembetulan.');

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

--
-- Table structure for table `corrective_action_plans`
--

CREATE TABLE `corrective_action_plans` (
  `id` int(10) UNSIGNED NOT NULL,
  `query_id` int(10) UNSIGNED NOT NULL COMMENT 'Links to the specific audit finding',
  `action_description` text NOT NULL,
  `responsible_officer` varchar(150) NOT NULL,
  `target_date` date NOT NULL,
  `status` enum('OPEN','IN_PROGRESS','COMPLETED','VERIFIED') DEFAULT 'OPEN',
  `completed_date` date DEFAULT NULL,
  `verified_by` int(10) UNSIGNED DEFAULT NULL COMMENT 'Auditor who verified the fix',
  `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_unicode_ci;

--
-- Dumping data for table `corrective_action_plans`
--

INSERT INTO `corrective_action_plans` (`id`, `query_id`, `action_description`, `responsible_officer`, `target_date`, `status`, `completed_date`, `verified_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'Menganjurkan taklimat khas Pekeliling Perbendaharaan untuk semua pegawai perolehan.', 'Pn. Penolong Pengarah BAHE', '2026-08-03', 'OPEN', NULL, NULL, '2026-09-11 16:25:19', '2026-09-11 16:25:19'),
(2, 2, 'Mengemaskini sistem e-DAFTAR dan melantik pegawai ganti.', 'Encik Penolong Unit Aset', '2026-09-02', 'COMPLETED', NULL, NULL, '2026-09-11 16:25:19', '2026-09-11 16:25:19');

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

--
-- Table structure for table `engagements`
--

CREATE TABLE `engagements` (
  `id` int(10) UNSIGNED NOT NULL,
  `rat_plan_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Links back to the approved RAT',
  `entity_id` int(10) UNSIGNED NOT NULL,
  `engagement_code` varchar(50) NOT NULL COMMENT 'e.g., AUDIT-KEW-2024-01',
  `scope_description` text NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `status` enum('PLANNED','IN_PROGRESS','COMPLETED','CLOSED') DEFAULT 'PLANNED',
  `created_by` int(10) UNSIGNED NOT 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_unicode_ci;

--
-- Dumping data for table `engagements`
--

INSERT INTO `engagements` (`id`, `rat_plan_id`, `entity_id`, `engagement_code`, `scope_description`, `start_date`, `end_date`, `status`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'AUDIT-BAHE-2024-01', 'Audit pengurusan kewangan dan perolehan BAHE bagi tahun 2023.', '2026-08-28', '2026-09-27', 'IN_PROGRESS', 4, '2026-09-11 16:15:38', '2026-09-11 16:15:38'),
(2, 2, 2, 'AUDIT-KEW-2024-02', 'Audit pematuhan Pekeliling Perbendaharaan di Unit Kewangan.', '2026-10-12', '2026-11-11', 'PLANNED', 4, '2026-09-11 16:15:38', '2026-09-11 16:15:38');

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

--
-- Table structure for table `engagement_checklists`
--

CREATE TABLE `engagement_checklists` (
  `id` int(10) UNSIGNED NOT NULL,
  `engagement_id` int(10) UNSIGNED NOT NULL,
  `category` enum('CASH','PROCUREMENT','ASSET') NOT NULL,
  `responses` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Stores checklist answers as JSON {item_id: "Comply"/"Non-Comply"/"N/A"}' CHECK (json_valid(`responses`)),
  `status` enum('DRAFT','COMPLETED') DEFAULT 'DRAFT',
  `completed_at` timestamp NULL DEFAULT NULL,
  `completed_by` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `engagement_checklists`
--

INSERT INTO `engagement_checklists` (`id`, `engagement_id`, `category`, `responses`, `status`, `completed_at`, `completed_by`) VALUES
(1, 1, 'CASH', '{\"cash_1\": \"Comply\", \"cash_2\": \"Non-Comply\", \"cash_3\": \"Comply\"}', 'COMPLETED', NULL, 4),
(2, 1, 'PROCUREMENT', '{\"proc_1\": \"Non-Comply\", \"proc_2\": \"Non-Comply\", \"proc_3\": \"Comply\"}', 'COMPLETED', NULL, 4);

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

--
-- Table structure for table `kka_evidences`
--

CREATE TABLE `kka_evidences` (
  `id` int(10) UNSIGNED NOT NULL,
  `kka_id` int(10) UNSIGNED NOT NULL,
  `original_filename` varchar(255) NOT NULL,
  `stored_filename` varchar(255) NOT NULL COMMENT 'Secure hashed filename',
  `mime_type` varchar(100) NOT NULL,
  `file_size` int(10) UNSIGNED NOT NULL COMMENT 'Size in bytes',
  `uploaded_by` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `lad_reports`
--

CREATE TABLE `lad_reports` (
  `id` int(10) UNSIGNED NOT NULL,
  `engagement_id` int(10) UNSIGNED NOT NULL,
  `report_ref_no` varchar(50) NOT NULL COMMENT 'e.g., LAD-KEW-2024-01',
  `status` enum('DRAFT','FINAL') DEFAULT 'DRAFT',
  `generated_by` int(10) UNSIGNED NOT NULL,
  `file_path` varchar(255) NOT NULL COMMENT 'Path to stored PDF in storage/reports/',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `opening_meetings`
--

CREATE TABLE `opening_meetings` (
  `id` int(10) UNSIGNED NOT NULL,
  `engagement_id` int(10) UNSIGNED NOT NULL,
  `meeting_date` date NOT NULL,
  `meeting_time` time NOT NULL,
  `venue` varchar(200) NOT NULL,
  `attendees` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'List of attendees [{name, designation, role}]' CHECK (json_valid(`attendees`)),
  `minutes` text NOT NULL,
  `agreed_timelines` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Key milestones [{milestone, deadline}]' CHECK (json_valid(`agreed_timelines`)),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `opening_meetings`
--

INSERT INTO `opening_meetings` (`id`, `engagement_id`, `meeting_date`, `meeting_time`, `venue`, `attendees`, `minutes`, `agreed_timelines`, `created_at`) VALUES
(1, 1, '2026-08-29', '10:00:00', 'Bilik Mesyuarat Utama BAHE', '[{\"name\":\"Puan Penolong Pengarah BAHE\",\"designation\":\"PPD\",\"role\":\"Auditee\"},{\"name\":\"Encik Auditor Kanan\",\"designation\":\"Auditor\",\"role\":\"Ketua Pasukan\"}]', 'Mesyuarat pembukaan telah bersetuju dengan skop audit. Auditee akan menyediakan dokumen sokongan dalam masa 3 hari.', '1', '2026-09-11 16:17:56');

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

--
-- Table structure for table `query_evidences`
--

CREATE TABLE `query_evidences` (
  `id` int(10) UNSIGNED NOT NULL,
  `query_id` int(10) UNSIGNED NOT NULL,
  `original_filename` varchar(255) NOT NULL,
  `stored_filename` varchar(255) NOT NULL,
  `mime_type` varchar(100) NOT NULL,
  `file_size` int(10) UNSIGNED NOT NULL,
  `uploaded_by` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `query_responses`
--

CREATE TABLE `query_responses` (
  `id` int(10) UNSIGNED NOT NULL,
  `query_id` int(10) UNSIGNED NOT NULL,
  `response_text` text NOT NULL COMMENT 'Official reply from auditee',
  `action_plan` text DEFAULT NULL COMMENT 'Management Action Plan (MAP)',
  `responded_by` int(10) UNSIGNED NOT NULL,
  `responded_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `query_responses`
--

INSERT INTO `query_responses` (`id`, `query_id`, `response_text`, `action_plan`, `responded_by`, `responded_at`) VALUES
(1, 2, 'Kami mengakui kelewatan tersebut. Pegawai yang berkenaan telah kembali bertugas.', '15 unit komputer riba telah didaftarkan sepenuhnya pada 15 Mac 2024. Surat akuan dilampirkan.', 5, '2026-09-11 16:23:51');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_key` varchar(50) NOT NULL COMMENT 'System identifier for RBAC',
  `role_name` varchar(100) NOT NULL COMMENT 'Official Malay/English title',
  `description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `role_key`, `role_name`, `description`, `created_at`) VALUES
(1, 'controlling_officer', 'Pegawai Pengawal (KSU/SUK/Mayor)', 'Ultimate responsibility for ministry/department finances and operations.', '2026-09-10 16:54:22'),
(2, 'audit_committee', 'Jawatankuasa Audit (PS 3.2)', 'Oversees internal audit function and reviews audit reports.', '2026-09-10 16:54:22'),
(3, 'head_internal_audit', 'Ketua Audit Dalam (PS 3.1)', 'Leads the internal audit unit, approves RAT and LAD.', '2026-09-10 16:54:22'),
(4, 'auditor', 'Auditor (Ketua/Pembantu)', 'Executes fieldwork, prepares KKA (4Cs), and issues Kuiri.', '2026-09-10 16:54:22'),
(5, 'auditee', 'Auditee (Representative)', 'Department representative responding to Kuiri and CAP.', '2026-09-10 16:54:22');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `staff_id` varchar(50) NOT NULL COMMENT 'Government Staff ID (NRIC/Service No)',
  `email` varchar(150) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `full_name` varchar(150) NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  `entity_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Links Auditee to their department',
  `is_active` tinyint(1) DEFAULT 1 COMMENT '1=Active, 0=Suspended',
  `last_login` timestamp NULL 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_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `staff_id`, `email`, `password_hash`, `full_name`, `role_id`, `entity_id`, `is_active`, `last_login`, `created_at`, `updated_at`) VALUES
(1, 'KSU001', 'ksu@iams.gov.my', '$2y$10$rJnqCPANbqwm0uFd3xsAaueFMuxZrUsWrGdrL4L/cgYWrVZPr5i46', 'YBhg. Datuk KSU', 1, NULL, 1, '2026-10-20 15:43:23', '2026-09-10 18:01:53', '2026-10-20 15:43:23'),
(2, 'AUP002', 'aup@iams.gov.my', '$2y$10$rJnqCPANbqwm0uFd3xsAaueFMuxZrUsWrGdrL4L/cgYWrVZPr5i46', 'Tan Sri Pengerusi Audit', 2, NULL, 1, '2026-10-20 15:44:40', '2026-09-10 18:01:53', '2026-10-20 15:44:40'),
(3, 'KAD003', 'kad@iams.gov.my', '$2y$10$rJnqCPANbqwm0uFd3xsAaueFMuxZrUsWrGdrL4L/cgYWrVZPr5i46', 'Dato\' Ketua Audit Dalam', 3, NULL, 1, '2026-10-20 15:48:00', '2026-09-10 18:01:53', '2026-10-20 15:48:00'),
(4, 'AUD004', 'auditor@iams.gov.my', '$2y$10$rJnqCPANbqwm0uFd3xsAaueFMuxZrUsWrGdrL4L/cgYWrVZPr5i46', 'Encik Auditor Kanan', 4, NULL, 1, '2026-10-03 15:15:41', '2026-09-10 18:01:53', '2026-10-03 15:15:41'),
(5, 'BAHE01', 'ppd.bahe@iams.gov.my', '$2y$10$rJnqCPANbqwm0uFd3xsAaueFMuxZrUsWrGdrL4L/cgYWrVZPr5i46', 'Puan Penolong Pengarah BAHE', 5, 1, 1, '2026-10-03 16:16:28', '2026-09-10 18:01:53', '2026-10-03 16:16:28'),
(6, 'KEW002', 'ppd.kew@iams.gov.my', '$2y$10$rJnqCPANbqwm0uFd3xsAaueFMuxZrUsWrGdrL4L/cgYWrVZPr5i46', 'Encik Penolong Unit Kewangan', 5, 2, 1, '2026-10-03 17:38:49', '2026-09-10 18:01:53', '2026-10-03 17:38:49');

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

--
-- Table structure for table `working_papers`
--

CREATE TABLE `working_papers` (
  `id` int(10) UNSIGNED NOT NULL,
  `engagement_id` int(10) UNSIGNED NOT NULL,
  `reference_no` varchar(50) NOT NULL COMMENT 'e.g., WP-KEW-01',
  `title` varchar(255) NOT NULL,
  `kriteria` text NOT NULL COMMENT 'Criteria / Law / Circular reference',
  `keadaan` text NOT NULL COMMENT 'Condition / Actual observation',
  `sebab` text NOT NULL COMMENT 'Cause / Reason for gap',
  `kesan` text NOT NULL COMMENT 'Effect / Financial or operational impact',
  `risk_rating` enum('HIGH','MEDIUM','LOW') NOT NULL DEFAULT 'LOW',
  `status` enum('DRAFT','SUBMITTED','REVIEWED','APPROVED') DEFAULT 'DRAFT',
  `reviewer_comments` text DEFAULT NULL,
  `approver_comments` text DEFAULT NULL,
  `created_by` int(10) UNSIGNED NOT 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_unicode_ci;

--
-- Dumping data for table `working_papers`
--

INSERT INTO `working_papers` (`id`, `engagement_id`, `reference_no`, `title`, `kriteria`, `keadaan`, `sebab`, `kesan`, `risk_rating`, `status`, `reviewer_comments`, `approver_comments`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'WP-BAHE-01', 'Ketidakpatuhan Had Kuotasi Perolehan', 'Pekeliling Perbendaharaan (PP) 3.2: Perolehan bernilai RM10,000 hingga RM50,000 wajib mendapatkan minimum 3 sebut harga bertulis.', 'Semakan terhadap 5 fail perolehan mendapati 3 fail hanya mempunyai 1 sebut harga, dan 2 fail tiada rekod sebut harga langsung.', 'Kekurangan kesedaran pegawai mengenai had kewangan terkini dan ketiadaan semakan oleh jawatankuasa perolehan cawangan.', 'Risiko ketirisan kewangan berjumlah RM45,000 dan potensi pelanggaran peraturan perolehan negara.', 'HIGH', 'APPROVED', NULL, NULL, 4, '2026-09-11 16:22:43', '2026-09-11 16:22:43'),
(2, 1, 'WP-BAHE-02', 'Lewat Pendaftaran Aset Baharu', 'Pekeliling Perbendaharaan (PP) 6: Semua aset baharu mesti didaftarkan dalam sistem e-DAFTAR dalam tempoh 7 hari dari tarikh diterima.', 'Sebanyak 15 unit komputer riba yang diterima pada bulan Januari belum dikemaskini dalam sistem e-DAFTAR setakat bulan Mac.', 'Pegawai aset sedang cuti sakit dan tiada pegawai ganti yang dilantik untuk menguruskan sistem.', 'Aset bernilai RM60,000 berisiko hilang atau disalahgunakan kerana tiada rekod kawalan semasa.', 'MEDIUM', 'REVIEWED', NULL, NULL, 4, '2026-09-11 16:22:43', '2026-09-11 16:22:43');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accountability_scores`
--
ALTER TABLE `accountability_scores`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_entity_year` (`entity_id`,`assessment_year`),
  ADD KEY `fk_ai_user` (`assessed_by`);

--
-- Indexes for table `annual_audit_plans`
--
ALTER TABLE `annual_audit_plans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_rat_entity` (`entity_id`),
  ADD KEY `fk_rat_auditor` (`lead_auditor_id`),
  ADD KEY `idx_target_year` (`target_year`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `auditable_entities`
--
ALTER TABLE `auditable_entities`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `entity_code` (`entity_code`),
  ADD KEY `idx_risk_band` (`risk_band`),
  ADD KEY `idx_entity_code` (`entity_code`);

--
-- Indexes for table `audit_logs`
--
ALTER TABLE `audit_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_module_action` (`module`,`action`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `audit_queries`
--
ALTER TABLE `audit_queries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `query_ref_no` (`query_ref_no`),
  ADD KEY `fk_query_eng` (`engagement_id`),
  ADD KEY `fk_query_wp` (`working_paper_id`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `cap_evidences`
--
ALTER TABLE `cap_evidences`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_capev_cap` (`cap_id`);

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

--
-- Indexes for table `closing_meeting_findings`
--
ALTER TABLE `closing_meeting_findings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_cmf_cm` (`closing_meeting_id`),
  ADD KEY `fk_cmf_query` (`query_id`);

--
-- Indexes for table `corrective_action_plans`
--
ALTER TABLE `corrective_action_plans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_cap_query` (`query_id`),
  ADD KEY `fk_cap_user` (`verified_by`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_target_date` (`target_date`);

--
-- Indexes for table `engagements`
--
ALTER TABLE `engagements`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `engagement_code` (`engagement_code`),
  ADD KEY `fk_eng_entity` (`entity_id`),
  ADD KEY `fk_eng_rat` (`rat_plan_id`),
  ADD KEY `fk_eng_user` (`created_by`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `engagement_checklists`
--
ALTER TABLE `engagement_checklists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_checklist_eng` (`engagement_id`),
  ADD KEY `fk_checklist_user` (`completed_by`);

--
-- Indexes for table `kka_evidences`
--
ALTER TABLE `kka_evidences`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_evidence_kka` (`kka_id`),
  ADD KEY `fk_evidence_user` (`uploaded_by`);

--
-- Indexes for table `lad_reports`
--
ALTER TABLE `lad_reports`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `report_ref_no` (`report_ref_no`),
  ADD KEY `fk_lad_eng` (`engagement_id`),
  ADD KEY `fk_lad_user` (`generated_by`);

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

--
-- Indexes for table `query_evidences`
--
ALTER TABLE `query_evidences`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_qev_query` (`query_id`);

--
-- Indexes for table `query_responses`
--
ALTER TABLE `query_responses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_response_query` (`query_id`),
  ADD KEY `fk_response_user` (`responded_by`);

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `staff_id` (`staff_id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `fk_users_role` (`role_id`),
  ADD KEY `idx_email` (`email`),
  ADD KEY `idx_staff_id` (`staff_id`),
  ADD KEY `fk_users_entity` (`entity_id`);

--
-- Indexes for table `working_papers`
--
ALTER TABLE `working_papers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `reference_no` (`reference_no`),
  ADD KEY `fk_wp_engagement` (`engagement_id`),
  ADD KEY `fk_wp_user` (`created_by`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_risk` (`risk_rating`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accountability_scores`
--
ALTER TABLE `accountability_scores`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `annual_audit_plans`
--
ALTER TABLE `annual_audit_plans`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `auditable_entities`
--
ALTER TABLE `auditable_entities`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `audit_logs`
--
ALTER TABLE `audit_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=483;

--
-- AUTO_INCREMENT for table `audit_queries`
--
ALTER TABLE `audit_queries`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cap_evidences`
--
ALTER TABLE `cap_evidences`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `closing_meetings`
--
ALTER TABLE `closing_meetings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `closing_meeting_findings`
--
ALTER TABLE `closing_meeting_findings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `corrective_action_plans`
--
ALTER TABLE `corrective_action_plans`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `engagements`
--
ALTER TABLE `engagements`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `engagement_checklists`
--
ALTER TABLE `engagement_checklists`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `kka_evidences`
--
ALTER TABLE `kka_evidences`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lad_reports`
--
ALTER TABLE `lad_reports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `opening_meetings`
--
ALTER TABLE `opening_meetings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `query_evidences`
--
ALTER TABLE `query_evidences`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `query_responses`
--
ALTER TABLE `query_responses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `working_papers`
--
ALTER TABLE `working_papers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `accountability_scores`
--
ALTER TABLE `accountability_scores`
  ADD CONSTRAINT `fk_ai_entity` FOREIGN KEY (`entity_id`) REFERENCES `auditable_entities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_ai_user` FOREIGN KEY (`assessed_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `annual_audit_plans`
--
ALTER TABLE `annual_audit_plans`
  ADD CONSTRAINT `fk_rat_auditor` FOREIGN KEY (`lead_auditor_id`) REFERENCES `users` (`id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_rat_entity` FOREIGN KEY (`entity_id`) REFERENCES `auditable_entities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `audit_queries`
--
ALTER TABLE `audit_queries`
  ADD CONSTRAINT `fk_query_eng` FOREIGN KEY (`engagement_id`) REFERENCES `engagements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_query_wp` FOREIGN KEY (`working_paper_id`) REFERENCES `working_papers` (`id`);

--
-- Constraints for table `cap_evidences`
--
ALTER TABLE `cap_evidences`
  ADD CONSTRAINT `fk_capev_cap` FOREIGN KEY (`cap_id`) REFERENCES `corrective_action_plans` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `closing_meetings`
--
ALTER TABLE `closing_meetings`
  ADD CONSTRAINT `fk_cm_eng` FOREIGN KEY (`engagement_id`) REFERENCES `engagements` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `closing_meeting_findings`
--
ALTER TABLE `closing_meeting_findings`
  ADD CONSTRAINT `fk_cmf_cm` FOREIGN KEY (`closing_meeting_id`) REFERENCES `closing_meetings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_cmf_query` FOREIGN KEY (`query_id`) REFERENCES `audit_queries` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `corrective_action_plans`
--
ALTER TABLE `corrective_action_plans`
  ADD CONSTRAINT `fk_cap_query` FOREIGN KEY (`query_id`) REFERENCES `audit_queries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_cap_user` FOREIGN KEY (`verified_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `engagements`
--
ALTER TABLE `engagements`
  ADD CONSTRAINT `fk_eng_entity` FOREIGN KEY (`entity_id`) REFERENCES `auditable_entities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_eng_rat` FOREIGN KEY (`rat_plan_id`) REFERENCES `annual_audit_plans` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_eng_user` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `engagement_checklists`
--
ALTER TABLE `engagement_checklists`
  ADD CONSTRAINT `fk_checklist_eng` FOREIGN KEY (`engagement_id`) REFERENCES `engagements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_checklist_user` FOREIGN KEY (`completed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `kka_evidences`
--
ALTER TABLE `kka_evidences`
  ADD CONSTRAINT `fk_evidence_kka` FOREIGN KEY (`kka_id`) REFERENCES `working_papers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_evidence_user` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `lad_reports`
--
ALTER TABLE `lad_reports`
  ADD CONSTRAINT `fk_lad_eng` FOREIGN KEY (`engagement_id`) REFERENCES `engagements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_lad_user` FOREIGN KEY (`generated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `opening_meetings`
--
ALTER TABLE `opening_meetings`
  ADD CONSTRAINT `fk_meeting_eng` FOREIGN KEY (`engagement_id`) REFERENCES `engagements` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `query_evidences`
--
ALTER TABLE `query_evidences`
  ADD CONSTRAINT `fk_qev_query` FOREIGN KEY (`query_id`) REFERENCES `audit_queries` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `query_responses`
--
ALTER TABLE `query_responses`
  ADD CONSTRAINT `fk_response_query` FOREIGN KEY (`query_id`) REFERENCES `audit_queries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_response_user` FOREIGN KEY (`responded_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `fk_users_entity` FOREIGN KEY (`entity_id`) REFERENCES `auditable_entities` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_users_role` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON UPDATE CASCADE;

--
-- Constraints for table `working_papers`
--
ALTER TABLE `working_papers`
  ADD CONSTRAINT `fk_wp_engagement` FOREIGN KEY (`engagement_id`) REFERENCES `engagements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_wp_user` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`);
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 */;
