-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               8.4.3 - MySQL Community Server - GPL
-- Server OS:                    Win64
-- HeidiSQL Version:             12.8.0.6908
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dumping database structure for dpengawasan


-- Dumping structure for table dpengawasan.blocked_ips
DROP TABLE IF EXISTS `blocked_ips`;
CREATE TABLE IF NOT EXISTS `blocked_ips` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `npp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `blocked_until` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.blocked_ips: ~0 rows (approximately)

-- Dumping structure for table dpengawasan.cache
DROP TABLE IF EXISTS `cache`;
CREATE TABLE IF NOT EXISTS `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.cache: ~2 rows (approximately)
INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
	('laravel-cache-user-is-online-1', 'b:1;', 1771483450),
	('laravel-cache-user-is-online-27', 'b:1;', 1771483344),
	('laravel-cache-user-is-online-30', 'b:1;', 1771483413);

-- Dumping structure for table dpengawasan.cache_locks
DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE IF NOT EXISTS `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.cache_locks: ~0 rows (approximately)

-- Dumping structure for table dpengawasan.departments
DROP TABLE IF EXISTS `departments`;
CREATE TABLE IF NOT EXISTS `departments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.departments: ~0 rows (approximately)

-- Dumping structure for table dpengawasan.failed_jobs
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table dpengawasan.indicators
DROP TABLE IF EXISTS `indicators`;
CREATE TABLE IF NOT EXISTS `indicators` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `supervisor_id` bigint unsigned DEFAULT NULL,
  `user_npp` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Rutin',
  `start_date` date DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `budget` decimal(15,2) DEFAULT '0.00',
  `actual_cost` decimal(15,2) DEFAULT NULL,
  `category` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target_value` int NOT NULL DEFAULT '100',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `indicators_user_npp_index` (`user_npp`),
  CONSTRAINT `indicators_user_npp_foreign` FOREIGN KEY (`user_npp`) REFERENCES `users` (`npp`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.indicators: ~8 rows (approximately)

-- Dumping structure for table dpengawasan.indicator_user
DROP TABLE IF EXISTS `indicator_user`;
CREATE TABLE IF NOT EXISTS `indicator_user` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `indicator_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `indicator_user_indicator_id_foreign` (`indicator_id`),
  KEY `indicator_user_user_id_foreign` (`user_id`),
  CONSTRAINT `indicator_user_indicator_id_foreign` FOREIGN KEY (`indicator_id`) REFERENCES `indicators` (`id`) ON DELETE CASCADE,
  CONSTRAINT `indicator_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.indicator_user: ~9 rows (approximately)

-- Dumping structure for table dpengawasan.jobs
DROP TABLE IF EXISTS `jobs`;
CREATE TABLE IF NOT EXISTS `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.jobs: ~0 rows (approximately)

-- Dumping structure for table dpengawasan.job_batches
DROP TABLE IF EXISTS `job_batches`;
CREATE TABLE IF NOT EXISTS `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.job_batches: ~0 rows (approximately)

-- Dumping structure for table dpengawasan.migrations
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.migrations: ~17 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '0001_01_01_000000_create_users_table', 1),
	(2, '0001_01_01_000001_create_cache_table', 1),
	(3, '0001_01_01_000002_create_jobs_table', 1),
	(4, '2026_01_20_012746_setup_crm_tables', 1),
	(5, '2026_01_23_090813_add_keterangan_to_performance_logs_table', 1),
	(6, '2026_01_25_091825_add_subtasks_and_start_date', 1),
	(7, '2026_01_26_072848_add_budget_to_indicators_table', 1),
	(8, '2026_01_28_024445_add_type_to_indicators_table', 1),
	(9, '2026_01_29_044204_update_structure_for_team_project', 1),
	(10, '2026_01_29_072351_make_performance_log_id_nullable', 1),
	(11, '2026_01_29_072811_fix_subtasks_nullable', 1),
	(12, '2026_01_29_143944_add_dates_to_indicators_table', 1),
	(13, '2026_01_29_145512_add_missing_columns_to_indicators', 1),
	(14, '2026_01_30_082333_change_subtask_title_to_text', 1),
	(16, '2026_02_18_140250_add_last_seen_to_users_table', 2),
	(17, '2026_02_18_171541_add_status_to_users_table', 2),
	(18, '2026_02_18_173035_add_status_columns_to_users_table', 2);

-- Dumping structure for table dpengawasan.password_reset_tokens
DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE IF NOT EXISTS `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.password_reset_tokens: ~0 rows (approximately)

-- Dumping structure for table dpengawasan.performance_logs
DROP TABLE IF EXISTS `performance_logs`;
CREATE TABLE IF NOT EXISTS `performance_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `indicator_id` bigint unsigned NOT NULL,
  `start_date` date DEFAULT NULL,
  `user_npp` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `month` int NOT NULL,
  `year` int NOT NULL,
  `actual_percentage` decimal(5,2) NOT NULL DEFAULT '0.00',
  `deadline` date DEFAULT NULL,
  `status` enum('Progress','On Progress','Overdue','Selesai') COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `performance_logs_indicator_id_foreign` (`indicator_id`),
  KEY `performance_logs_user_npp_index` (`user_npp`),
  CONSTRAINT `performance_logs_indicator_id_foreign` FOREIGN KEY (`indicator_id`) REFERENCES `indicators` (`id`) ON DELETE CASCADE,
  CONSTRAINT `performance_logs_user_npp_foreign` FOREIGN KEY (`user_npp`) REFERENCES `users` (`npp`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.performance_logs: ~9 rows (approximately)

-- Dumping structure for table dpengawasan.sessions
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE IF NOT EXISTS `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.sessions: ~3 rows (approximately)
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
	('KZwdFexYY4UydYntsoTuUU0uGUnf5DNAlazt6TgU', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNnRYNVVqdXpsZmlhbFBva09oUDFmcng1VlNyWE5WNHE0UlI5c25wMiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjM6Imh0dHA6Ly9kcGVuZ2F3YXNhbi50ZXN0IjtzOjU6InJvdXRlIjtzOjU6ImxvZ2luIjt9fQ==', 1771483330),
	('noNDyrFkYMeIpfgFHSfufXHfHvq6avIyuv96aPs4', 4, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSWtZWXU3YnkwUWxwdW9ucDlZM2pEVExkUVlFeVJDMXpJVlJTTE5xSyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9kYXNoYm9hcmQ/dGFiPVJ1dGluIjtzOjU6InJvdXRlIjtzOjk6ImRhc2hib2FyZCI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjQ7fQ==', 1771475754);

-- Dumping structure for table dpengawasan.sub_tasks
DROP TABLE IF EXISTS `sub_tasks`;
CREATE TABLE IF NOT EXISTS `sub_tasks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `indicator_id` bigint unsigned DEFAULT NULL,
  `performance_log_id` bigint unsigned DEFAULT NULL,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_completed` tinyint(1) NOT NULL DEFAULT '0',
  `executed_by` bigint unsigned DEFAULT NULL,
  `proof_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sub_tasks_performance_log_id_foreign` (`performance_log_id`),
  KEY `sub_tasks_indicator_id_foreign` (`indicator_id`),
  CONSTRAINT `sub_tasks_indicator_id_foreign` FOREIGN KEY (`indicator_id`) REFERENCES `indicators` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sub_tasks_performance_log_id_foreign` FOREIGN KEY (`performance_log_id`) REFERENCES `performance_logs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.sub_tasks: ~13 rows (approximately)

-- Dumping structure for table dpengawasan.users
DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `npp` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_seen` timestamp NULL DEFAULT NULL,
  `role` enum('Super Admin','Executive','Supervisor','PIC','Auditor') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PIC',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `department_id` bigint unsigned DEFAULT NULL,
  `position` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `login_attempts` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_npp_unique` (`npp`),
  KEY `users_department_id_foreign` (`department_id`),
  CONSTRAINT `users_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table dpengawasan.users: ~29 rows (approximately)
INSERT INTO `users` (`id`, `npp`, `name`, `email`, `email_verified_at`, `password`, `last_seen`, `role`, `remember_token`, `created_at`, `updated_at`, `department_id`, `position`, `is_active`, `login_attempts`) VALUES
	(1, '0001', 'Super Administrator', 'admin@sumutpengawasan.com', NULL, '$2y$12$gPb9VcJuoaH9bGa9FLNBRudYwMKz3fvmTo9TzVijuIWPQK5r5X6E2', '2026-02-18 23:42:10', 'Super Admin', NULL, '2026-02-18 02:15:28', '2026-02-18 23:42:10', NULL, NULL, 1, 0),
	(4, '1256', 'Abdilla Fansuri', 'pdev@dpg.com', NULL, '$2y$12$bDNmV2aulE7G.VZigk0UJusT8Dz.Qj0vsKJaep43ggxh9e2dMSIX.', '2026-02-18 21:35:54', 'Executive', NULL, '2026-02-18 18:11:48', '2026-02-18 21:35:54', NULL, 'Pemimpin Divisi Pengawasan', 1, 0),
	(8, '1160', 'Angki Prabowo', 'spv01@dpg.com', NULL, '$2y$12$eAf3.WLmW3hh9m30Qs/7a.LaZahnm90EHlbsAt886s5m8XX2/4ND6', NULL, 'Supervisor', NULL, '2026-02-18 22:13:38', '2026-02-18 22:13:38', NULL, 'Pemimpin Bidang Audit Kredit I', 1, 0),
	(9, '1730', 'Aja Muhammad Harri Alfani', 'aud1dpg01@dpg.com', NULL, '$2y$12$6eiLvrkqoCUL606H26ev6eHCyTvL0GNAKnoYzPUAJBbJxHeGUPNcO', '2026-02-18 23:39:27', 'PIC', NULL, '2026-02-18 22:14:24', '2026-02-18 23:39:27', NULL, 'Senior Auditor Audit Kredit I', 1, 0),
	(10, '1417', 'Hesti Cahyani', 'aud1dpg02@dpg.com', NULL, '$2y$12$4ktQ2khoXeZzximCMS3SP.gLrH76cPzjRdHiwhaXVRnQfUKMDEwYW', NULL, 'PIC', NULL, '2026-02-18 22:17:06', '2026-02-18 22:17:06', NULL, 'Senior Auditor Audit Kredit I', 1, 0),
	(11, '1322', 'Jackson Aruntara Siagian', 'aud1dpg03@dpg.com', NULL, '$2y$12$N/cuWuCfNitDwkx1ldH/Bu/outfkaiwZATtjjhHJqOgL9wNUMbVx2', NULL, 'PIC', NULL, '2026-02-18 22:17:57', '2026-02-18 22:17:57', NULL, 'Senior Auditor Audit Kredit I', 1, 0),
	(12, '1325', 'Khaeruddin Yusuf', 'aud1dpg04@dpg.com', NULL, '$2y$12$4YL6cNpJM3tudJzPew4Mjeb3MgHXAtjuN205TWqgFl.07hmzSOZE2', NULL, 'PIC', NULL, '2026-02-18 22:18:48', '2026-02-18 22:19:08', NULL, 'Senior Auditor Audit Kredit I', 1, 0),
	(13, '1540', 'Rialdi Mahbub', 'aud1dpg05@dpg.com', NULL, '$2y$12$P9ZGl/bOGXny8foOg5mAyOGSjXsJ.N8chhhD9/ECuoZduazt3ihYu', NULL, 'PIC', NULL, '2026-02-18 22:20:15', '2026-02-18 22:20:15', NULL, 'Senior Auditor Audit Kredit I', 1, 0),
	(14, '3418', 'Yessy Debora Sibarani', 'aud1dpg06@dpg.com', NULL, '$2y$12$HerjaOjNM0.axQH20xj67e3iEKEiYN.5j8pLEu4OQI38eal6Okfx2', NULL, 'PIC', NULL, '2026-02-18 22:21:43', '2026-02-18 22:21:43', NULL, 'Senior Auditor Audit Kredit I', 1, 0),
	(15, '1143', 'Rusdiono', 'spv02@dpg.com', NULL, '$2y$12$.wWiWJ6yiE4EyqcMK1c3qO9FYaAT1cEc0dR75hEBMN1Kahu84yTNS', NULL, 'Supervisor', NULL, '2026-02-18 22:22:54', '2026-02-18 22:22:54', NULL, 'Pemimpin Bidang Audit Kredit II', 1, 0),
	(16, '1272', 'Aulia Abadi', 'aud2dpg01@dpg.com', NULL, '$2y$12$DXTaAOMpXGuGHtn6h9gHI.cfPUAxK39lSqLvWV/iVCEtgRi3VqfRq', NULL, 'PIC', NULL, '2026-02-18 22:23:53', '2026-02-18 22:24:18', NULL, 'Senior Auditor Audit Kredit II', 1, 0),
	(17, '1176', 'Junita Dumasari Lubis', 'aud2dpg02@dpg.com', NULL, '$2y$12$D29Cd9P.z6XQgNXlTQ7REOSUhKiF/DFDRl.PoFQfSTg6IImo5HGbK', NULL, 'PIC', NULL, '2026-02-18 22:25:23', '2026-02-18 22:25:23', NULL, 'Senior Auditor Audit Kredit II', 1, 0),
	(18, '1401', 'Dahliana Lubis', 'aud2dpg03@dpg.com', NULL, '$2y$12$yfEkNh8AwDh/oHqxyUwRmeAItvNriwi6lg8m2wBxbqYP/eYrVoqSy', NULL, 'PIC', NULL, '2026-02-18 22:26:24', '2026-02-18 22:26:24', NULL, 'Senior Auditor Audit Kredit II', 1, 0),
	(19, '2587', 'Muhammad Harsono', 'aud2dpg04@dpg.com', NULL, '$2y$12$CUzDAoqqUUx.saSe6lcDyuq/48LVasaBfAE1oke3MuSTXwfkJA3Iu', NULL, 'PIC', NULL, '2026-02-18 22:27:25', '2026-02-18 22:27:44', NULL, 'Senior Auditor Audit Kredit II', 1, 0),
	(20, '1140', 'Romy Irawan', 'spv03@dpg.com', NULL, '$2y$12$6m2ziw2od85.I/PPSoL3TOlZ29drPOltKZtp5HuT4JAuZr/ozOguC', NULL, 'Supervisor', NULL, '2026-02-18 22:28:41', '2026-02-18 22:28:41', NULL, 'Pemimpin Bidang Audit Kredit III', 1, 0),
	(21, '1808', 'Joppy Nugraha', 'aud3dpg01@dpg.com', NULL, '$2y$12$BYNTrUKDY05aMa.5Qmk9..eoc299mh4vpeSZngTYlklvBm8i2H2ve', NULL, 'PIC', NULL, '2026-02-18 22:29:39', '2026-02-18 22:29:39', NULL, 'Senior Auditor Audit Kredit III', 1, 0),
	(22, '1119', 'Leonard Franky Siregar', 'aud3dpg02@dpg.com', NULL, '$2y$12$3k6OEjPeXA.xR62Org75F.pb3p8vEUE.X/p86fYteQgKqH7tux4wO', NULL, 'PIC', NULL, '2026-02-18 22:30:55', '2026-02-18 22:30:55', NULL, 'Senior Auditor Audit Kredit III', 1, 0),
	(23, '1355', 'Ronny S', 'aud3dpg03@dpg.com', NULL, '$2y$12$ahMi3PtA9rd/GtSHr1F/POK1uCtCxcrrYqI9hS9ZhU2rTL4Ky0CL.', NULL, 'PIC', NULL, '2026-02-18 22:31:52', '2026-02-18 22:31:52', NULL, 'Senior Auditor Audit Kredit III', 1, 0),
	(24, '1553', 'Syahril Rianto Sidabutar', 'aud3dpg04@dpg.com', NULL, '$2y$12$2ypAr/vbA2fE5T23.e150efdkUJc6NFtHBbcBBcmy1TdK1XC1rQ0i', NULL, 'PIC', NULL, '2026-02-18 22:33:03', '2026-02-18 22:33:15', NULL, 'Senior Auditor Audit Kredit III', 1, 0),
	(25, '4008', 'Siti Azlika Salsabilla', 'aud3dpg05@dpg.com', NULL, '$2y$12$4zIVpPG5b0bWmneudrYDJ.0oWVznsYoqW8F2VROremTFAi30drtXW', NULL, 'PIC', NULL, '2026-02-18 22:34:10', '2026-02-18 22:34:10', NULL, 'Junior Auditor Audit Kredit III', 1, 0),
	(26, '1497', 'Dolly Maulana Harahap', 'spv04@dpg.com', NULL, '$2y$12$SOse.O5FFkcbV/9zEig6PuXG4dTjrZWbssBZh9l9mtHTK6ha0UlLG', NULL, 'Supervisor', NULL, '2026-02-18 22:35:08', '2026-02-18 22:35:08', NULL, 'Pemimpin Bidang Investigasi', 1, 0),
	(27, '1473', 'Achmad Sodikin', 'audinves01@dpg.com', NULL, '$2y$12$emEzHm2DbZebVGzqNLTsaOboipsXZfsFfpqF5vUL1E8XuXnzXslQW', '2026-02-18 23:40:24', 'PIC', NULL, '2026-02-18 22:36:21', '2026-02-18 23:40:24', NULL, 'Auditor Investigasi Speciialist', 1, 0),
	(28, '1338', 'Muhammad Iskandar', 'audinves02@dpg.com', NULL, '$2y$12$aVz05asFd8xAdCjloEbeV.dh1fy/K.Hu/j6ZxNnudRS7oWxhcZsvm', NULL, 'PIC', NULL, '2026-02-18 22:37:16', '2026-02-18 22:37:16', NULL, 'Auditor Investigasi Speciialist', 1, 0),
	(29, '3564', 'Muhammad Arif Azhar', 'audinves03@dpg.com', NULL, '$2y$12$lwpEPYv9YPMOya7h9FnXSu9kKBbf6WB5U.iuNm.ELo0qxb8OwIpgq', NULL, 'PIC', NULL, '2026-02-18 22:38:18', '2026-02-18 22:38:18', NULL, 'Auditor Investigasi Speciialist', 1, 0),
	(30, '2038', 'Ahmad Arief Heru Diningrat', 'spv05@dpg.com', NULL, '$2y$12$BWAf87uE.C9bZSJTxrGFz.UGOcxg9cl/akcFzpgq.UWghQvmK63UK', '2026-02-18 23:41:33', 'Supervisor', NULL, '2026-02-18 22:39:15', '2026-02-18 23:41:33', NULL, 'Pemimpin Bidang Auditor Operasional & TI', 1, 0),
	(31, '3562', 'Faris Ilham Yudistira', 'audopti01@dpg.com', NULL, '$2y$12$WKoprwYzaS/zu1.3hqI/AuxEJkniig4cd/ADtvqeAov9K5Hk5kUp.', NULL, 'PIC', NULL, '2026-02-18 22:40:17', '2026-02-18 22:40:17', NULL, 'Senior Auditor Operasional & TI', 1, 0),
	(32, '3615', 'Ishar Alamsyah', 'audopti02@dpg.com', NULL, '$2y$12$tfPq5L5shVsSAXbMPuXYV.0cXxuPCMogCmgpnXaf76krq9UtGUwdC', NULL, 'PIC', NULL, '2026-02-18 22:41:33', '2026-02-18 22:42:15', NULL, 'Senior Auditor Operasional & TI', 1, 0),
	(33, '3413', 'Muhammad Zaen Nawawi', 'audopti03@dpg.com', NULL, '$2y$12$PPyLqpEzJy9D8yTeorBy7uSBI5NxP1U2eDV5L8U6WpSI0sP2Jah7i', NULL, 'PIC', NULL, '2026-02-18 22:43:06', '2026-02-18 22:43:06', NULL, 'Senior Auditor Operasional & TI', 1, 0),
	(34, '1392', 'Zul Arianto', 'audopti04@dpg.com', NULL, '$2y$12$nsN6vT8kzrrYFGuQC.HcLu82ieQ/sKktAW7Gl3eFINiMn501vbMVu', NULL, 'PIC', NULL, '2026-02-18 22:44:02', '2026-02-18 22:44:02', NULL, 'Senior Auditor Operasional & TI', 1, 0),
	(35, '4066', 'Nabila', 'audopti05@dpg.com', NULL, '$2y$12$JbMHl3DYEHZEJrm6IGVMS.Vn5I4/G99bMeYSRVSNAP06odLHlpPhK', '2026-02-18 23:24:25', 'PIC', NULL, '2026-02-18 23:05:29', '2026-02-18 23:24:25', NULL, 'Junior Auditor Operasional & TI', 1, 0);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;