-- MariaDB dump 10.19 Distrib 10.4.32-MariaDB, for Win64 (AMD64) -- -- Host: 127.0.0.1 Database: logbook -- ------------------------------------------------------ -- Server version 10.4.32-MariaDB /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!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 */; -- -- Current Database: `logbook` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `logbook` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */; USE `logbook`; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `incident_logs` -- DROP TABLE IF EXISTS `incident_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `incident_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `incident_number` varchar(50) NOT NULL, `transmitter_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `off_air_at` datetime NOT NULL, `on_air_at` datetime DEFAULT NULL, `duration_minutes` int(10) unsigned DEFAULT NULL, `category` varchar(60) NOT NULL DEFAULT 'PLN Blackout', `impact` varchar(60) NOT NULL DEFAULT 'Total Off-Air', `symptoms` text NOT NULL, `cause` text DEFAULT NULL, `action_taken` text DEFAULT NULL, `status` enum('Open','In_Progress','Resolved') NOT NULL DEFAULT 'Open', `resolved_by` bigint(20) unsigned DEFAULT NULL, `resolved_at` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `incident_logs_incident_number_unique` (`incident_number`), KEY `incident_logs_transmitter_id_foreign` (`transmitter_id`), KEY `incident_logs_user_id_foreign` (`user_id`), KEY `incident_logs_resolved_by_foreign` (`resolved_by`), CONSTRAINT `incident_logs_resolved_by_foreign` FOREIGN KEY (`resolved_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `incident_logs_transmitter_id_foreign` FOREIGN KEY (`transmitter_id`) REFERENCES `transmitters` (`id`) ON DELETE CASCADE, CONSTRAINT `incident_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `incident_logs` -- LOCK TABLES `incident_logs` WRITE; /*!40000 ALTER TABLE `incident_logs` DISABLE KEYS */; INSERT INTO `incident_logs` VALUES (1,'INC-202609-001',1,3,'2026-09-27 13:15:23','2026-09-27 13:48:23',33,'PLN Blackout','Total Off-Air','Pemancar mendadak mati total, indikator power supply padam.','Pemadaman darurat gardu induk PLN area Gombel akibat pohon tumbang.','Menghidupkan genset darurat Perkins 60 kVA secara manual setelah ATS gagal trigger. Pemancar kembali on-air normal.','Resolved',3,'2026-09-27 13:48:23','2026-09-30 01:54:24','2026-09-30 01:54:24'),(2,'INC-202609-002',2,4,'2026-09-29 16:05:23','2026-09-29 16:22:23',17,'STL Failure','Dead Air Silent','Carrier RF tetap memancar tetapi audio siaran hening total (dead air).','Koneksi microwave STL terganggu hujan lebat disertai petir di jalur link.','Switching input audio ke backup IP Codec (Barix Exstreamer) via fiber optic. Audio kembali normal.','Resolved',4,'2026-09-29 16:22:23','2026-09-30 01:54:24','2026-09-30 01:54:24'); /*!40000 ALTER TABLE `incident_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `maintenance_records` -- DROP TABLE IF EXISTS `maintenance_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `maintenance_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `transmitter_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `maintenance_date` date NOT NULL, `type` enum('Preventive','Corrective','Calibration','Cleaning_Filter','Overhaul') NOT NULL DEFAULT 'Preventive', `title` varchar(150) NOT NULL, `description` text NOT NULL, `parts_replaced` text DEFAULT NULL, `status` enum('Scheduled','In_Progress','Completed','Cancelled') NOT NULL DEFAULT 'Scheduled', `notes` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `maintenance_records_transmitter_id_foreign` (`transmitter_id`), KEY `maintenance_records_user_id_foreign` (`user_id`), CONSTRAINT `maintenance_records_transmitter_id_foreign` FOREIGN KEY (`transmitter_id`) REFERENCES `transmitters` (`id`) ON DELETE CASCADE, CONSTRAINT `maintenance_records_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `maintenance_records` -- LOCK TABLES `maintenance_records` WRITE; /*!40000 ALTER TABLE `maintenance_records` DISABLE KEYS */; INSERT INTO `maintenance_records` VALUES (1,1,1,'2026-09-20','Cleaning_Filter','Pembersihan Filter Udara & Fan Cooling TX-FM-01','Pembersihan berkala debu pada saringan udara depan kabinet dan pengecekan bearing kipas hembus PA.','Penggantian filter spons intake udara (2 unit)','Completed','Aliran udara pendingin lancar, suhu PA turun rata-rata 3°C pasca pembersihan.','2026-09-30 01:54:24','2026-09-30 01:54:24'); /*!40000 ALTER TABLE `maintenance_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` 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_09_30_085111_create_personal_access_tokens_table',2),(5,'2026_09_30_100001_add_role_and_phone_to_users_table',3),(6,'2026_09_30_100002_create_transmitters_table',3),(7,'2026_09_30_100003_create_transmitter_logs_table',3),(8,'2026_09_30_100004_create_incident_logs_table',3),(9,'2026_09_30_100005_create_maintenance_records_table',3),(10,'2026_09_30_110001_create_shifts_table_and_add_nip_to_users',4); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` text NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`), KEY `personal_access_tokens_expires_at_index` (`expires_at`) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; INSERT INTO `personal_access_tokens` VALUES (1,'App\\Models\\User',1,'Flutter-Test-Device','a95c7a1261cf0a8bb7af9f41d4a385da5d93ac44dd67bbaceeb6c8054ea03bd5','[\"*\"]',NULL,NULL,'2026-09-30 02:09:30','2026-09-30 02:09:30'),(2,'App\\Models\\User',1,'test','f41a5ddf7c814232ac1304a300540f0cb7df897a2cb33febab86edb3e981990a','[\"*\"]','2026-09-30 02:09:31',NULL,'2026-09-30 02:09:30','2026-09-30 02:09:31'),(3,'App\\Models\\User',1,'Flutter-Test-Device','3b7bcc083b96b63ad163f11aff930df5d0e1ae7259731504fdf743ff5591e978','[\"*\"]',NULL,NULL,'2026-09-30 02:10:17','2026-09-30 02:10:17'),(4,'App\\Models\\User',1,'test','484fdee183a6d223f729d9c2e2bb307f859d4e805ebda930ce2b9a7e2b9c0011','[\"*\"]','2026-09-30 02:10:17',NULL,'2026-09-30 02:10:17','2026-09-30 02:10:17'),(5,'App\\Models\\User',1,'test-mobile','934b3d185f68c8d797f42a25795ad9f433064ea0e7ad9ba3db496a8da51777a8','[\"*\"]','2026-09-30 02:10:17',NULL,'2026-09-30 02:10:17','2026-09-30 02:10:17'),(6,'App\\Models\\User',1,'Flutter-Test-Device','dea9d2a64cc34f6da5c024c988d2674f21bc5040293549b26e2cf88d8525d57e','[\"*\"]',NULL,NULL,'2026-09-30 02:22:13','2026-09-30 02:22:13'),(7,'App\\Models\\User',1,'test','67284c2aec364354208e0521c5e2da5446d587d4fd84a57939c7acd8af008afd','[\"*\"]','2026-09-30 02:22:13',NULL,'2026-09-30 02:22:13','2026-09-30 02:22:13'),(8,'App\\Models\\User',1,'test-mobile','6226e30c617cb05d83516814bb923d1f27c2e68ee40b7f0a86ebb85fe1e145ef','[\"*\"]','2026-09-30 02:22:13',NULL,'2026-09-30 02:22:13','2026-09-30 02:22:13'),(9,'App\\Models\\User',1,'Flutter-Test-Device','6c507965d652866a69390df28480ca42b4cded1548cdd1a2b536d5ccb8dbcdb7','[\"*\"]',NULL,NULL,'2026-09-30 02:24:25','2026-09-30 02:24:25'),(10,'App\\Models\\User',1,'test','69f271d9843fc5cfc1fbe7d2312eb75e1b2e0aa7f2f4e472a3c284c03ba74b82','[\"*\"]','2026-09-30 02:24:25',NULL,'2026-09-30 02:24:25','2026-09-30 02:24:25'),(11,'App\\Models\\User',1,'test-mobile','106eaacf1c2280486834ef8fc1021384217175e1b717cb7d878792f380b5715c','[\"*\"]','2026-09-30 02:24:25',NULL,'2026-09-30 02:24:25','2026-09-30 02:24:25'),(12,'App\\Models\\User',1,'Flutter-Test-Device','0f4fe13243c800aed68840658df814885a9763bb3f9ee6a0c24f2aaaa80f98a7','[\"*\"]',NULL,NULL,'2026-09-30 02:28:52','2026-09-30 02:28:52'),(13,'App\\Models\\User',1,'test','5a3275fd98fa01cd8daa038385a49db466f7f67ef70b86bd03810c6935e5cffa','[\"*\"]','2026-09-30 02:28:52',NULL,'2026-09-30 02:28:52','2026-09-30 02:28:52'),(14,'App\\Models\\User',1,'test-mobile','052b68e938b186a7965b129aca738fa6775ef19c25cc0dbf7cd0c0ede1206106','[\"*\"]','2026-09-30 02:28:52',NULL,'2026-09-30 02:28:52','2026-09-30 02:28:52'),(15,'App\\Models\\User',1,'Flutter-Test-Device','c330b2524a9c5225b0b053d987b4bb9859670b51e8aae79c0abc31878693fb71','[\"*\"]',NULL,NULL,'2026-09-30 02:31:35','2026-09-30 02:31:35'),(16,'App\\Models\\User',1,'test','b9c8e33852cec9584bc027e5514f4c669b34ddfca650be0c0fa5c328bdac540d','[\"*\"]','2026-09-30 02:31:35',NULL,'2026-09-30 02:31:35','2026-09-30 02:31:35'),(17,'App\\Models\\User',1,'test-mobile','98b19f481922e9887b64d23d451eef4d283a91c0004d13db290bfd3b2f8e9f98','[\"*\"]','2026-09-30 02:31:35',NULL,'2026-09-30 02:31:35','2026-09-30 02:31:35'),(18,'App\\Models\\User',1,'Flutter-Test-Device','c1c3651c02ee25f834187c7e842f6a5f199d68119520567b8a5d0fe49f8007a7','[\"*\"]',NULL,NULL,'2026-09-30 02:38:41','2026-09-30 02:38:41'),(19,'App\\Models\\User',1,'test','84b88d3373cdae94640da7d113bfea8864a996639eac64925744babfbfb7f6fc','[\"*\"]','2026-09-30 02:38:41',NULL,'2026-09-30 02:38:41','2026-09-30 02:38:41'),(20,'App\\Models\\User',1,'test-mobile','a1f2871cc9908bf76ff4d857d59e84bef455389d293499fa3351f9160b116612','[\"*\"]','2026-09-30 02:38:41',NULL,'2026-09-30 02:38:41','2026-09-30 02:38:41'),(21,'App\\Models\\User',1,'Flutter-Test-Device','6cec726d3cc459d07add99f90380f7001b6e99635fa02eb863f46832ac0f2851','[\"*\"]',NULL,NULL,'2026-09-30 02:39:49','2026-09-30 02:39:49'),(22,'App\\Models\\User',1,'test','fbcdc71097b6b2e913ecee61473ba57360c2084d5430f92209aef444125ff53d','[\"*\"]','2026-09-30 02:39:49',NULL,'2026-09-30 02:39:49','2026-09-30 02:39:49'),(23,'App\\Models\\User',1,'test-mobile','8930352904e8637f688fe269597a9e3eaa997890880b4117aaf7fea6e9c337ae','[\"*\"]','2026-09-30 02:39:49',NULL,'2026-09-30 02:39:49','2026-09-30 02:39:49'),(24,'App\\Models\\User',1,'Flutter-Test-Device','19c6a0ccae077f07ff3f1f87d2c04fcd608e7a347fff5bdb9dc7b6e3299cdcda','[\"*\"]',NULL,NULL,'2026-09-30 02:52:40','2026-09-30 02:52:40'),(25,'App\\Models\\User',1,'test','08bc3798c7a333b563733eb143ffe554b417e8139cb3ec7286c1a573b138f344','[\"*\"]','2026-09-30 02:52:40',NULL,'2026-09-30 02:52:40','2026-09-30 02:52:40'),(26,'App\\Models\\User',1,'test-mobile','78f09da045ab86dbf3b8a27d315690b17aa536b31282654ca1c840ce36a493f4','[\"*\"]','2026-09-30 02:52:40',NULL,'2026-09-30 02:52:40','2026-09-30 02:52:40'),(27,'App\\Models\\User',1,'Flutter-Test-Device','6a7d105dfdec26170c84ef1030be8747c9e399f0c8721c0efa49f37f388fb84c','[\"*\"]',NULL,NULL,'2026-09-30 02:53:29','2026-09-30 02:53:29'),(28,'App\\Models\\User',1,'test','b01e05b027323f6e703214cd7e19bd3ef83b0de55e5bd271dff5e7a7e5975cef','[\"*\"]','2026-09-30 02:53:29',NULL,'2026-09-30 02:53:29','2026-09-30 02:53:29'),(29,'App\\Models\\User',1,'test-mobile','5a79fd30954e37db7e74b29480a3e58054a01032f7d4b050fc44e80fec8824a3','[\"*\"]','2026-09-30 02:53:29',NULL,'2026-09-30 02:53:29','2026-09-30 02:53:29'),(30,'App\\Models\\User',1,'Flutter-Test-Device','8c4cda241e22b2cfb552cc535fd1f2f5eaadcdc4081c116e82ad2f948838e32c','[\"*\"]',NULL,NULL,'2026-09-30 03:01:25','2026-09-30 03:01:25'),(31,'App\\Models\\User',1,'test','0961a04773f5a6718e46fa1fde9629fe7961fea4464ed79b1554e41da28cf0c2','[\"*\"]','2026-09-30 03:01:25',NULL,'2026-09-30 03:01:25','2026-09-30 03:01:25'),(32,'App\\Models\\User',1,'test-mobile','044bbcfe261d920ca7fde1295fc2dd2719f9d8d01714b7c2b78274f72cf69da5','[\"*\"]','2026-09-30 03:01:25',NULL,'2026-09-30 03:01:25','2026-09-30 03:01:25'),(33,'App\\Models\\User',1,'Flutter-Test-Device','4e426a651338eb48326c4ffe5f76cb12e6ebb5dfd0b36587211d0005abdb180c','[\"*\"]',NULL,NULL,'2026-09-30 03:13:56','2026-09-30 03:13:56'),(34,'App\\Models\\User',1,'test','8e632f9febceaf083a78d124930c82460f28e4f671131154e6b2488582371a11','[\"*\"]','2026-09-30 03:13:56',NULL,'2026-09-30 03:13:56','2026-09-30 03:13:56'),(35,'App\\Models\\User',1,'test-mobile','2dc0aa16abab2013d3dc0b89b41a81f9a58b99a9efee208f689b9bc58e4c253c','[\"*\"]','2026-09-30 03:13:56',NULL,'2026-09-30 03:13:56','2026-09-30 03:13:56'),(36,'App\\Models\\User',1,'Flutter-Test-Device','28b928d1faef5ca09bc57d2d29f14efa9e29045e1419205419051a2bad422e97','[\"*\"]',NULL,NULL,'2026-09-30 03:21:36','2026-09-30 03:21:36'),(37,'App\\Models\\User',1,'test','eb8d6f0cbb800520890bda82c73612e2db98501dbff031b3fa5977337e144ead','[\"*\"]','2026-09-30 03:21:36',NULL,'2026-09-30 03:21:36','2026-09-30 03:21:36'),(38,'App\\Models\\User',1,'test-mobile','89f3ab755f52c7b8fe8354cb18783ebbd08661c624f2989c073ce4d23c767cb3','[\"*\"]','2026-09-30 03:21:36',NULL,'2026-09-30 03:21:36','2026-09-30 03:21:36'),(39,'App\\Models\\User',1,'Flutter-Test-Device','2eb48701ca43c6c3516041f667ce8c4000a65fb12c2606e46402d3e67ddb7792','[\"*\"]',NULL,NULL,'2026-09-30 03:21:56','2026-09-30 03:21:56'),(40,'App\\Models\\User',1,'test','85e029bd7eb086ac36c4205d9b02218558f937e64355cd827ac1b3fb1add1a3b','[\"*\"]','2026-09-30 03:21:56',NULL,'2026-09-30 03:21:56','2026-09-30 03:21:56'),(41,'App\\Models\\User',1,'test-mobile','e4495a8cf64485c98d97feb024d6b4c0a1e59dd81bf8ec99c07174d8ed546389','[\"*\"]','2026-09-30 03:21:56',NULL,'2026-09-30 03:21:56','2026-09-30 03:21:56'),(42,'App\\Models\\User',1,'Flutter-Test-Device','e11d10349de818dd5812251f805f0786e06ac4515b0f68a8642c2578d69977e4','[\"*\"]',NULL,NULL,'2026-09-30 03:23:05','2026-09-30 03:23:05'),(43,'App\\Models\\User',1,'test','162c496be31bc545a10d34d5767fb985f852b5e6e0869fd1d294660bb0687fc3','[\"*\"]','2026-09-30 03:23:05',NULL,'2026-09-30 03:23:05','2026-09-30 03:23:05'),(44,'App\\Models\\User',1,'test-mobile','7794856bc18c31da432c72059606d2a2ae76e0b57f7a77bc13a7384282e694b1','[\"*\"]','2026-09-30 03:23:05',NULL,'2026-09-30 03:23:05','2026-09-30 03:23:05'),(45,'App\\Models\\User',1,'Flutter-Test-Device','dafc331c97eb256b140fe90375ce12d3fb31549d7e55aad2b893cf7f875bd622','[\"*\"]',NULL,NULL,'2026-09-30 03:24:31','2026-09-30 03:24:31'),(46,'App\\Models\\User',1,'test','baca88aedcb7a8aa047b495e70a3333a2dcbd5c651d65bdab2369dcdd00c72cb','[\"*\"]','2026-09-30 03:24:31',NULL,'2026-09-30 03:24:31','2026-09-30 03:24:31'),(47,'App\\Models\\User',1,'test-mobile','51341fcd044783e2a9d4dea72d624725e36d55ba060483c7ae37e323cc1524ad','[\"*\"]','2026-09-30 03:24:31',NULL,'2026-09-30 03:24:31','2026-09-30 03:24:31'),(48,'App\\Models\\User',1,'Flutter-Test-Device','fed3f21346025621095e0dfda3030245cd3117d82fa440c111bdd4a631bb9794','[\"*\"]',NULL,NULL,'2026-09-30 03:24:50','2026-09-30 03:24:50'),(49,'App\\Models\\User',1,'test','853db284ed8cc19fd29dd34a51a4cb6bd09f07e85923ccb37bc682283e26063e','[\"*\"]','2026-09-30 03:24:50',NULL,'2026-09-30 03:24:50','2026-09-30 03:24:50'),(50,'App\\Models\\User',1,'test-mobile','ea5455e9bb7cf1f8521f86200fd7f224cf9d58cd6036896725b573ab7ce04b44','[\"*\"]','2026-09-30 03:24:50',NULL,'2026-09-30 03:24:50','2026-09-30 03:24:50'),(51,'App\\Models\\User',1,'Flutter-Test-Device','39488087b6eac414aaccb7e96bfbf72efb7793ad26eb8adde153d5a8b45a8cdc','[\"*\"]',NULL,NULL,'2026-09-30 03:25:34','2026-09-30 03:25:34'),(52,'App\\Models\\User',1,'test','24fc9877561f3f9dd92b56a830beb5ef5c235738065499166b9da31e95dea58f','[\"*\"]','2026-09-30 03:25:34',NULL,'2026-09-30 03:25:34','2026-09-30 03:25:34'),(53,'App\\Models\\User',1,'test-mobile','40aaaed64823291ae2b2698ba3066ddf568590928123542c622c6c9ff5491fa6','[\"*\"]','2026-09-30 03:25:34',NULL,'2026-09-30 03:25:34','2026-09-30 03:25:34'),(54,'App\\Models\\User',1,'Flutter-Test-Device','8437f590f98a8fff5ce8af08127f6dffe42251859686ea83f4ed9fede3939b7f','[\"*\"]',NULL,NULL,'2026-09-30 03:26:27','2026-09-30 03:26:27'),(55,'App\\Models\\User',1,'test','527582b48fdfeaccf2a3881c0af8487dec52e353391708965c17224d3450f0e7','[\"*\"]','2026-09-30 03:26:27',NULL,'2026-09-30 03:26:27','2026-09-30 03:26:27'),(56,'App\\Models\\User',1,'test-mobile','be38de2de289b98400143fa5f43a2654c45140d00a317f7f55175cdc50152be4','[\"*\"]','2026-09-30 03:26:27',NULL,'2026-09-30 03:26:27','2026-09-30 03:26:27'),(57,'App\\Models\\User',1,'Flutter-Test-Device','7756bd504625453f9817d6eeff050749c5130d4a663979e6732f06714fc5f24c','[\"*\"]',NULL,NULL,'2026-09-30 03:36:55','2026-09-30 03:36:55'),(58,'App\\Models\\User',1,'test','255b92acef45abd9fc606e66e50675b6211582589f8e292352135abf6d87d969','[\"*\"]','2026-09-30 03:36:55',NULL,'2026-09-30 03:36:55','2026-09-30 03:36:55'),(59,'App\\Models\\User',1,'test-mobile','8a9f561807c0bff7f4202abd77ac722313892a0746de6086d735cac2e1fcbe7d','[\"*\"]','2026-09-30 03:36:55',NULL,'2026-09-30 03:36:55','2026-09-30 03:36:55'),(60,'App\\Models\\User',1,'Flutter-Test-Device','08237cfd68144ea5edf768967cb640215d6d33ea0810e0545337e6900cf9263f','[\"*\"]',NULL,NULL,'2026-09-30 03:48:25','2026-09-30 03:48:25'),(61,'App\\Models\\User',1,'test','4f85177dff33a2d8155cb5dd5fe12774264bcc3c63cb1983f6a97059ab1e84b3','[\"*\"]','2026-09-30 03:48:25',NULL,'2026-09-30 03:48:25','2026-09-30 03:48:25'),(62,'App\\Models\\User',1,'test-mobile','6deface821c51d62b0fb736a6e9d1bfeca5abd1a63731618faa34a6fbb56bf12','[\"*\"]','2026-09-30 03:48:25',NULL,'2026-09-30 03:48:25','2026-09-30 03:48:25'),(63,'App\\Models\\User',1,'Flutter-Test-Device','06140146c4bd73d697072e3728577c04f4b2004d492563edbe02d45a05051bfe','[\"*\"]',NULL,NULL,'2026-09-30 03:56:34','2026-09-30 03:56:34'),(64,'App\\Models\\User',1,'test','dc5e4b7c1322828fcd2ed1e43f8616448e528b980de038847154578d4fcc00be','[\"*\"]','2026-09-30 03:56:34',NULL,'2026-09-30 03:56:34','2026-09-30 03:56:34'),(65,'App\\Models\\User',1,'test-mobile','097d5466883d743e8851c099d689e47a417ff663e163cb871c4c76ac94336469','[\"*\"]','2026-09-30 03:56:34',NULL,'2026-09-30 03:56:34','2026-09-30 03:56:34'),(66,'App\\Models\\User',1,'Flutter-Test-Device','69fd5fcd6a96f6af79f37f59ba708430ca1ea298048a75013645bea8e89300e5','[\"*\"]',NULL,NULL,'2026-09-30 04:05:26','2026-09-30 04:05:26'),(67,'App\\Models\\User',1,'test','b87ef04f978de77f44f275830031af75764ee4685d09a83379af2bd7d55aeddb','[\"*\"]','2026-09-30 04:05:26',NULL,'2026-09-30 04:05:26','2026-09-30 04:05:26'),(68,'App\\Models\\User',1,'test-mobile','d2416940c22e0779cdfd8caf2af791112b4f9f32ca54f31fb8b9656fb5d317ca','[\"*\"]','2026-09-30 04:05:26',NULL,'2026-09-30 04:05:26','2026-09-30 04:05:26'),(69,'App\\Models\\User',1,'Flutter-Test-Device','8403f964e67e92f3ad12b8f86d66933a3b1b13ece8d5397a363d20ed97b38b67','[\"*\"]',NULL,NULL,'2026-09-30 04:06:22','2026-09-30 04:06:22'),(70,'App\\Models\\User',1,'test','82330dfddcd581994ded92d068d01442e17fbee4b37e6d4ce0d71160f8f03756','[\"*\"]','2026-09-30 04:06:22',NULL,'2026-09-30 04:06:22','2026-09-30 04:06:22'),(71,'App\\Models\\User',1,'test-mobile','e85a54249928f571d2ff1c62e4afd5b1eb95395a2573006afa2450e7850a3c23','[\"*\"]','2026-09-30 04:06:22',NULL,'2026-09-30 04:06:22','2026-09-30 04:06:22'),(72,'App\\Models\\User',1,'Flutter-Test-Device','2f92835b5b8ba3ed2e5e85d5270db2cd76f12ff6304c5de0b9231fa099b59bfd','[\"*\"]',NULL,NULL,'2026-09-30 04:06:46','2026-09-30 04:06:46'),(73,'App\\Models\\User',1,'test','37c87959efb0830b83b70258a3f5ff9ce6f82276ba2f6981de787f25a6a9c8f0','[\"*\"]','2026-09-30 04:06:46',NULL,'2026-09-30 04:06:46','2026-09-30 04:06:46'),(74,'App\\Models\\User',1,'test-mobile','88016a37eaee545f65a6fb5f40477ae1b14097f5e2eb3983a3f25e32eb25b298','[\"*\"]','2026-09-30 04:06:47',NULL,'2026-09-30 04:06:47','2026-09-30 04:06:47'),(75,'App\\Models\\User',1,'Flutter-Test-Device','c18c8baab1a4565061d9e2d17676d7567deb1c45365f06cb090b855041dc5fb8','[\"*\"]',NULL,NULL,'2026-09-30 04:16:09','2026-09-30 04:16:09'),(76,'App\\Models\\User',1,'test','873c8b0ac2a79ed4ec05aa22cf0259dc01ab33cd916aef5579b7888da140fab2','[\"*\"]','2026-09-30 04:16:09',NULL,'2026-09-30 04:16:09','2026-09-30 04:16:09'),(77,'App\\Models\\User',1,'test-mobile','850847c408ff209e13472787a6774e241642fac3ebc0b0816cb8b84af97ae1b8','[\"*\"]','2026-09-30 04:16:09',NULL,'2026-09-30 04:16:09','2026-09-30 04:16:09'),(78,'App\\Models\\User',1,'Flutter-Test-Device','e70c6e2709777c6e3cf2dec37823b6a0b382e86e2014ce5e548427deacebd635','[\"*\"]',NULL,NULL,'2026-09-30 04:16:59','2026-09-30 04:16:59'),(79,'App\\Models\\User',1,'test','700f1d6d144beb059e39f1471cff6b78df93a6f06f8e845ff4bc7ffbb410677d','[\"*\"]','2026-09-30 04:16:59',NULL,'2026-09-30 04:16:59','2026-09-30 04:16:59'),(80,'App\\Models\\User',1,'test-mobile','24080dbe37cba0a094aa097d1f374befa99f81d000a3ba1f7f811eb6738f2ff5','[\"*\"]','2026-09-30 04:16:59',NULL,'2026-09-30 04:16:59','2026-09-30 04:16:59'),(81,'App\\Models\\User',1,'Flutter-Test-Device','58f89174142392838fb52ed60c55405ca7591dc23e1d513af08c6b3d896fc6c0','[\"*\"]',NULL,NULL,'2026-09-30 04:19:56','2026-09-30 04:19:56'),(82,'App\\Models\\User',1,'test','44bf6c0546dca49dcc7433e7bcd6ef384838a84e4e1a8a982579d74dd37531e2','[\"*\"]','2026-09-30 04:19:56',NULL,'2026-09-30 04:19:56','2026-09-30 04:19:56'),(83,'App\\Models\\User',1,'test-mobile','f4a7a606d511b81296285a1a991cdb739f99a45280bf7bc4ef881b9c29fdf429','[\"*\"]','2026-09-30 04:19:56',NULL,'2026-09-30 04:19:56','2026-09-30 04:19:56'),(84,'App\\Models\\User',1,'Flutter-Test-Device','f2b3fe15b78fe930efeaba7435397ed341bab2e1c570c4ff160f1128ab46be90','[\"*\"]',NULL,NULL,'2026-09-30 04:26:10','2026-09-30 04:26:10'),(85,'App\\Models\\User',1,'Flutter-NIP-Device','c5c8d744e455bb8556c76c06ea389d60baacd31870b5c6fdd65cb3f97d272e94','[\"*\"]',NULL,NULL,'2026-09-30 04:26:10','2026-09-30 04:26:10'),(86,'App\\Models\\User',1,'test','f03e6f6d98cc82b2b3ae355777bd50cb070e2dc909a8b28815b4a19a779c57e5','[\"*\"]','2026-09-30 04:26:10',NULL,'2026-09-30 04:26:10','2026-09-30 04:26:10'),(87,'App\\Models\\User',1,'test-mobile','a0255fcc84a45a41814d55499ee990760b7155cc941d431dcbc8d35689788108','[\"*\"]','2026-09-30 04:26:10',NULL,'2026-09-30 04:26:10','2026-09-30 04:26:10'),(88,'App\\Models\\User',1,'Flutter-Test-Device','2bda09b44b75e6e8b533ca735778101b685de808b860cfe9b2e0dcdf1cfb91e1','[\"*\"]',NULL,NULL,'2026-09-30 05:15:13','2026-09-30 05:15:13'),(89,'App\\Models\\User',1,'Flutter-NIP-Device','bcd7445df6b062d1d463f99a7ed470e1dbf5a28f9dd5a538d6ab7c4b25782ff5','[\"*\"]',NULL,NULL,'2026-09-30 05:15:13','2026-09-30 05:15:13'),(90,'App\\Models\\User',1,'test','2a62a315cf2ee999d4cd9e091b7843e61a2ab951b80bf5c0dbaea72734ea18d0','[\"*\"]','2026-09-30 05:15:13',NULL,'2026-09-30 05:15:13','2026-09-30 05:15:13'),(91,'App\\Models\\User',1,'test-mobile','cc8119a445bb602e2b77ecfa76e0b713f7516320c0be65911b4d57e9c57c1804','[\"*\"]','2026-09-30 05:15:13',NULL,'2026-09-30 05:15:13','2026-09-30 05:15:13'),(92,'App\\Models\\User',1,'Flutter-Test-Device','b3ef6426a06f48db17fc80d730b3d6ea7e1f999bb35735e2af7fc95a851324b8','[\"*\"]',NULL,NULL,'2026-09-30 05:38:53','2026-09-30 05:38:53'),(93,'App\\Models\\User',1,'Flutter-NIP-Device','053d436f479e0c8a44c29a553eff4300b082ac4d05df222116a06f812b3af753','[\"*\"]',NULL,NULL,'2026-09-30 05:38:54','2026-09-30 05:38:54'),(94,'App\\Models\\User',1,'test','6a413546bb3697562626c2ed2cfa2883b2e9d46f4970bad4897455c43ddb48cf','[\"*\"]','2026-09-30 05:38:54',NULL,'2026-09-30 05:38:54','2026-09-30 05:38:54'),(95,'App\\Models\\User',1,'test-mobile','3212c5583c0f6ea046ec9601a170543e77127234b0756c25ece3d1a534641456','[\"*\"]','2026-09-30 05:38:54',NULL,'2026-09-30 05:38:54','2026-09-30 05:38:54'),(97,'App\\Models\\User',4,'Android-Flutter-Logbook','3089119791d23ec867e44865ac97b048d41f743e72b94ed47e66efe4b79cee0f','[\"*\"]','2026-09-30 06:04:16',NULL,'2026-09-30 06:03:37','2026-09-30 06:04:16'),(99,'App\\Models\\User',4,'Android-Flutter-Logbook','ac38beb5083aa2df5547b4382afe0690d527e944c55d8ac6ef67ec4a8f51ceb7','[\"*\"]','2026-09-30 07:31:27',NULL,'2026-09-30 07:30:53','2026-09-30 07:31:27'),(100,'App\\Models\\User',1,'Android-Flutter-Device','0b2bb9ea844a44a291cf39f45f274b92a2f2afdf9a9578bbd2dc4465e71c989a','[\"*\"]',NULL,NULL,'2026-09-30 07:36:44','2026-09-30 07:36:44'); /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; INSERT INTO `sessions` VALUES ('83Msno4Cj0tnM1p6LINh7ABl19fHEyIEsNMNPQB3',3,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiZU1SeGxqZUlNb1lXZkpUMFJaUHNxaHVQWWtEMTFXWWVxN2VQRFN3bCI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjMzOiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvbG9ncy9jcmVhdGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTozO30=',1790743084),('AUqlg2B1MVKqehCt4W5ztkoHaT4whiCEgHINGyh1',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.22621.1778','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaXVNMGVqaDhPTTdqSmtaV0NoeXBqR1V1VERPa0hjQWs1VVhjZURoNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1790754743),('h9QC0TS8yNJuqFXUYytMU1kxhJRBk3tYIPsMY3Ma',NULL,'192.168.1.241','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.22621.1778','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVVo5TFdHS2FqQ2lBRTZ5OVRpTXJyejNYUFdVakF3MGhhbDB2QTREVyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyNToiaHR0cDovLzE5Mi4xNjguMS4yNDE6ODAwMCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjMxOiJodHRwOi8vMTkyLjE2OC4xLjI0MTo4MDAwL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1790753399),('HrnX0usfCtfhZUqNuXv9rBaxbes1w3V9YtMmH0Fr',3,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoidXNYSlNtVk9NVHdBeDN2TURaWVpORG9BWDBzcEJzYVNkUnhyS0NyQSI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjMxOiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvaW5jaWRlbnRzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Mzt9',1790755551),('ie0uMD4Rpv6IU2R92fayIR0fTgK9O1zOUKanBwka',1,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMmFuTzlrQ3VnWEp6eE9QTVBScVpseDFqMDRpNW51VXdjSzZ6TWFYZCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dzL2NyZWF0ZSI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==',1790756177),('IVodb8XQSk8E0RmBU4GrmAfcSM4FlBY8illnLO1y',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.22621.1778','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWlJYRjdFeXdvR2s1UlRzQWN0YXF3ZzhZdktlbkVxd1hFZ0RUTzVkYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1790734245); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `shifts` -- DROP TABLE IF EXISTS `shifts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `shifts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `code` varchar(20) NOT NULL, `start_time` time NOT NULL, `end_time` time NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `notes` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `shifts_code_unique` (`code`) ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `shifts` -- LOCK TABLES `shifts` WRITE; /*!40000 ALTER TABLE `shifts` DISABLE KEYS */; INSERT INTO `shifts` VALUES (1,'Shift Pagi','PAGI','04:30:00','12:30:00',1,NULL,'2026-09-30 02:16:25','2026-09-30 04:42:57'),(3,'Shift Malam','DINI HARI','00:01:00','08:00:00',1,NULL,'2026-09-30 02:16:25','2026-09-30 04:43:27'),(4,'Shift Sore','SORE','16:00:00','23:59:00',1,NULL,'2026-09-30 02:24:26','2026-09-30 04:42:44'),(49,'Shift Khusus SH_1b6ba8','SH_1b6ba8','10:00:00','16:00:00',1,'Shift pemeliharaan antena berkala','2026-09-30 05:15:13','2026-09-30 05:15:13'),(52,'Shift Khusus SH_e8d143','SH_e8d143','10:00:00','16:00:00',1,'Shift pemeliharaan antena berkala','2026-09-30 05:38:54','2026-09-30 05:38:54'); /*!40000 ALTER TABLE `shifts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `transmitter_logs` -- DROP TABLE IF EXISTS `transmitter_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transmitter_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `transmitter_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `recorded_at` datetime NOT NULL, `shift` enum('Pagi','Siang','Malam') NOT NULL DEFAULT 'Pagi', `forward_power` decimal(10,2) NOT NULL, `reflected_power` decimal(10,2) NOT NULL DEFAULT 0.00, `vswr` decimal(5,2) NOT NULL DEFAULT 1.00, `pa_voltage` decimal(6,2) DEFAULT NULL, `pa_current` decimal(6,2) DEFAULT NULL, `temperature_pa` decimal(5,2) DEFAULT NULL, `temperature_room` decimal(5,2) DEFAULT NULL, `power_source` varchar(30) NOT NULL DEFAULT 'PLN', `pln_voltage_r` decimal(6,2) DEFAULT NULL, `pln_voltage_s` decimal(6,2) DEFAULT NULL, `pln_voltage_t` decimal(6,2) DEFAULT NULL, `pln_frequency` decimal(5,2) DEFAULT 50.00, `stl_status` varchar(30) NOT NULL DEFAULT 'Normal', `modulation_level` decimal(5,2) DEFAULT NULL, `audio_condition` varchar(100) DEFAULT NULL, `status` enum('Normal','Warning','Critical') NOT NULL DEFAULT 'Normal', `notes` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `transmitter_logs_transmitter_id_foreign` (`transmitter_id`), KEY `transmitter_logs_user_id_foreign` (`user_id`), KEY `transmitter_logs_recorded_at_index` (`recorded_at`), CONSTRAINT `transmitter_logs_transmitter_id_foreign` FOREIGN KEY (`transmitter_id`) REFERENCES `transmitters` (`id`) ON DELETE CASCADE, CONSTRAINT `transmitter_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transmitter_logs` -- LOCK TABLES `transmitter_logs` WRITE; /*!40000 ALTER TABLE `transmitter_logs` DISABLE KEYS */; INSERT INTO `transmitter_logs` VALUES (1,1,3,'2026-09-26 08:18:00','Pagi',996.00,14.00,1.27,48.20,27.90,42.90,26.50,'PLN',218.00,221.00,222.00,50.00,'Normal',93.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(2,1,4,'2026-09-26 14:29:00','Siang',996.00,7.00,1.18,47.40,28.40,46.50,26.00,'PLN',220.00,224.00,217.00,50.00,'Normal',94.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(3,1,3,'2026-09-26 20:28:00','Malam',982.00,18.00,1.31,48.40,27.40,49.60,24.10,'PLN',221.00,217.00,221.00,50.00,'Normal',93.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(4,1,3,'2026-09-27 08:25:00','Pagi',986.00,7.00,1.18,47.40,28.10,42.50,25.70,'PLN',223.00,223.00,216.00,50.00,'Normal',92.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(5,1,4,'2026-09-27 14:20:00','Siang',993.00,23.00,1.36,47.80,28.00,47.70,24.00,'PLN',223.00,224.00,220.00,50.00,'Normal',97.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(6,1,3,'2026-09-27 20:20:00','Malam',1020.00,5.00,1.15,47.10,29.20,46.70,23.90,'PLN',221.00,223.00,219.00,50.00,'Normal',91.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(7,1,3,'2026-09-28 08:20:00','Pagi',1005.00,25.00,1.37,47.50,28.60,49.90,24.90,'PLN',221.00,218.00,218.00,50.00,'Normal',92.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(8,1,4,'2026-09-28 14:12:00','Siang',988.00,20.00,1.33,48.50,27.50,46.10,26.20,'PLN',221.00,219.00,221.00,50.00,'Normal',95.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(9,1,3,'2026-09-28 20:22:00','Malam',1003.00,10.00,1.22,48.60,27.90,42.00,25.80,'PLN',218.00,218.00,219.00,50.00,'Normal',92.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(10,1,3,'2026-09-29 08:09:00','Pagi',1016.00,8.00,1.19,47.80,28.70,42.50,23.80,'PLN',219.00,218.00,222.00,50.00,'Normal',98.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(11,1,4,'2026-09-29 14:27:00','Siang',984.00,14.00,1.27,47.90,27.70,46.10,23.60,'PLN',224.00,221.00,223.00,50.00,'Normal',91.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(12,1,3,'2026-09-29 20:06:00','Malam',1007.00,12.00,1.25,48.90,27.80,45.70,25.80,'PLN',219.00,222.00,216.00,50.00,'Normal',90.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(13,1,3,'2026-09-30 08:23:00','Pagi',993.00,14.00,1.27,48.30,27.80,42.10,24.00,'PLN',219.00,219.00,217.00,50.00,'Normal',100.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(14,1,4,'2026-09-30 14:26:00','Siang',1008.00,16.00,1.29,48.60,28.00,47.30,26.10,'PLN',222.00,224.00,223.00,50.00,'Normal',93.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(15,1,3,'2026-09-30 20:14:00','Malam',1014.00,18.00,1.31,47.70,28.70,46.40,25.70,'PLN',218.00,224.00,216.00,50.00,'Normal',94.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(16,2,3,'2026-09-26 08:10:00','Pagi',5014.00,11.00,1.10,47.10,143.70,44.60,26.50,'PLN',221.00,225.00,217.00,50.00,'Normal',99.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(17,2,4,'2026-09-26 14:23:00','Siang',5005.00,21.00,1.14,48.10,140.50,45.60,24.20,'PLN',219.00,217.00,220.00,50.00,'Normal',96.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(18,2,3,'2026-09-26 20:20:00','Malam',4995.00,7.00,1.08,48.60,138.80,44.40,24.50,'PLN',220.00,218.00,223.00,50.00,'Normal',93.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(19,2,3,'2026-09-27 08:28:00','Pagi',4997.00,23.00,1.15,48.90,138.00,44.80,25.90,'PLN',221.00,220.00,215.00,50.00,'Normal',93.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(20,2,4,'2026-09-27 14:19:00','Siang',5000.00,15.00,1.12,47.00,143.60,47.60,26.50,'PLN',220.00,217.00,220.00,50.00,'Normal',98.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(21,2,3,'2026-09-27 20:07:00','Malam',4995.00,10.00,1.09,49.00,137.60,45.40,26.20,'PLN',220.00,217.00,223.00,50.00,'Normal',97.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(22,2,3,'2026-09-28 08:29:00','Pagi',5009.00,24.00,1.15,48.60,139.10,42.90,25.90,'PLN',222.00,218.00,218.00,50.00,'Normal',98.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(23,2,4,'2026-09-28 14:24:00','Siang',4987.00,25.00,1.15,48.20,139.70,47.70,26.00,'PLN',219.00,225.00,222.00,50.00,'Normal',95.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(24,2,3,'2026-09-28 20:05:00','Malam',5007.00,8.00,1.08,47.60,142.00,47.70,24.00,'PLN',217.00,224.00,221.00,50.00,'Normal',95.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(25,2,3,'2026-09-29 08:14:00','Pagi',4989.00,14.00,1.11,48.50,138.90,45.10,26.00,'PLN',216.00,223.00,215.00,50.00,'Normal',98.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(26,2,4,'2026-09-29 14:09:00','Siang',4983.00,22.00,1.14,48.60,138.40,44.70,25.80,'PLN',223.00,217.00,215.00,50.00,'Normal',99.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(27,2,3,'2026-09-29 20:23:00','Malam',4980.00,5.00,1.07,48.20,139.50,43.60,26.10,'PLN',224.00,220.00,218.00,50.00,'Normal',99.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(28,2,3,'2026-09-30 08:24:00','Pagi',5013.00,22.00,1.14,48.00,141.00,45.00,25.60,'PLN',221.00,219.00,218.00,50.00,'Normal',92.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(29,2,4,'2026-09-30 14:23:00','Siang',5014.00,15.00,1.12,48.70,139.00,46.10,24.10,'PLN',217.00,219.00,215.00,50.00,'Normal',94.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(30,2,3,'2026-09-30 20:24:00','Malam',5004.00,5.00,1.07,47.70,141.60,46.80,25.20,'PLN',222.00,222.00,220.00,50.00,'Normal',100.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(31,3,3,'2026-09-26 08:26:00','Pagi',4989.00,12.00,1.10,231.00,28.50,42.30,24.90,'PLN',222.00,219.00,223.00,50.00,'Normal',98.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(32,3,4,'2026-09-26 14:13:00','Siang',4984.00,6.00,1.07,234.00,28.50,49.60,24.80,'PLN',224.00,219.00,216.00,50.00,'Normal',99.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(33,3,3,'2026-09-26 20:24:00','Malam',5013.00,20.00,1.13,230.00,28.50,48.30,24.60,'PLN',217.00,218.00,221.00,50.00,'Normal',91.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(34,3,3,'2026-09-27 08:17:00','Pagi',4990.00,21.00,1.14,233.00,28.50,44.40,23.50,'PLN',219.00,222.00,223.00,50.00,'Normal',98.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(35,3,4,'2026-09-27 14:30:00','Siang',4994.00,17.00,1.12,226.00,28.50,47.50,26.00,'PLN',220.00,219.00,221.00,50.00,'Normal',93.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(36,3,3,'2026-09-27 20:30:00','Malam',5005.00,22.00,1.14,229.00,28.50,46.60,25.50,'PLN',223.00,225.00,216.00,50.00,'Normal',96.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(37,3,3,'2026-09-28 08:06:00','Pagi',4980.00,10.00,1.09,228.00,28.50,44.80,24.90,'PLN',216.00,224.00,215.00,50.00,'Normal',99.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(38,3,4,'2026-09-28 14:26:00','Siang',5001.00,8.00,1.08,233.00,28.50,43.60,23.70,'PLN',222.00,220.00,216.00,50.00,'Normal',92.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(39,3,3,'2026-09-28 20:13:00','Malam',4983.00,16.00,1.12,229.00,28.50,48.40,23.90,'PLN',219.00,225.00,217.00,50.00,'Normal',97.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(40,3,3,'2026-09-29 08:13:00','Pagi',4985.00,17.00,1.12,232.00,28.50,45.60,24.90,'PLN',217.00,222.00,217.00,50.00,'Normal',97.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(41,3,4,'2026-09-29 14:10:00','Siang',5008.00,19.00,1.13,225.00,28.50,47.40,26.40,'PLN',221.00,223.00,216.00,50.00,'Normal',100.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(42,3,3,'2026-09-29 20:19:00','Malam',4987.00,14.00,1.11,231.00,28.50,45.50,26.00,'PLN',221.00,224.00,222.00,50.00,'Normal',97.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(43,3,3,'2026-09-30 08:13:00','Pagi',5010.00,21.00,1.14,233.00,28.50,44.50,23.80,'PLN',219.00,217.00,222.00,50.00,'Normal',90.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Pagi. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:24','2026-09-30 01:54:24'),(44,3,4,'2026-09-30 14:09:00','Siang',4980.00,6.00,1.07,225.00,28.50,47.90,24.80,'PLN',221.00,217.00,219.00,50.00,'Normal',91.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Siang. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:24','2026-09-30 01:54:24'),(45,3,3,'2026-09-30 20:19:00','Malam',4992.00,17.00,1.12,229.00,28.50,42.00,26.30,'PLN',224.00,222.00,216.00,50.00,'Normal',92.00,'Stereo Jernih (Normal)','Normal','Pemeriksaan rutin shift Malam. Parameter pemancar dalam batas toleransi normal.','2026-09-30 01:54:24','2026-09-30 01:54:24'),(46,1,1,'2026-09-30 09:10:17','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 02:10:17','2026-09-30 02:10:17'),(47,1,1,'2026-09-30 09:22:13','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 02:22:13','2026-09-30 02:22:13'),(48,1,1,'2026-09-30 09:24:25','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 02:24:26','2026-09-30 02:24:26'),(49,1,1,'2026-09-30 09:28:52','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 02:28:52','2026-09-30 02:28:52'),(50,1,1,'2026-09-30 09:31:35','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 02:31:35','2026-09-30 02:31:35'),(51,1,1,'2026-09-30 09:38:41','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 02:38:41','2026-09-30 02:38:41'),(52,1,1,'2026-09-30 09:39:49','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 02:39:49','2026-09-30 02:39:49'),(53,1,1,'2026-09-30 09:52:40','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 02:52:40','2026-09-30 02:52:40'),(54,1,1,'2026-09-30 09:53:29','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 02:53:29','2026-09-30 02:53:29'),(55,1,1,'2026-09-30 10:01:25','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:01:25','2026-09-30 03:01:25'),(56,1,1,'2026-09-30 10:13:56','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:13:56','2026-09-30 03:13:56'),(57,1,1,'2026-09-30 10:21:36','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:21:36','2026-09-30 03:21:36'),(60,1,1,'2026-09-30 10:21:56','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:21:56','2026-09-30 03:21:56'),(61,1,1,'2026-09-30 10:23:05','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:23:05','2026-09-30 03:23:05'),(64,1,1,'2026-09-30 10:24:31','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:24:31','2026-09-30 03:24:31'),(67,1,1,'2026-09-30 10:24:50','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:24:50','2026-09-30 03:24:50'),(70,1,1,'2026-09-30 10:25:34','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:25:34','2026-09-30 03:25:34'),(73,1,1,'2026-09-30 10:26:27','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:26:27','2026-09-30 03:26:27'),(76,1,1,'2026-09-30 10:36:55','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:36:55','2026-09-30 03:36:55'),(79,1,1,'2026-09-30 10:48:25','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:48:25','2026-09-30 03:48:25'),(82,1,1,'2026-09-30 14:30:00','Pagi',1000.00,12.00,1.25,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Catatan uji tanggal dan jam terpisah','2026-09-30 03:48:26','2026-09-30 03:48:26'),(83,1,1,'2026-09-30 10:56:34','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 03:56:34','2026-09-30 03:56:34'),(86,1,1,'2026-09-30 14:30:00','Pagi',1000.00,12.00,1.25,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Catatan uji tanggal dan jam terpisah','2026-09-30 03:56:35','2026-09-30 03:56:35'),(87,1,1,'2026-09-30 11:05:26','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 04:05:26','2026-09-30 04:05:26'),(90,1,1,'2026-09-30 14:30:00','Pagi',1000.00,12.00,1.25,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Catatan uji tanggal dan jam terpisah','2026-09-30 04:05:27','2026-09-30 04:05:27'),(91,1,32,'2026-09-30 09:05:27','Pagi',1000.00,10.00,1.20,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi A','2026-09-30 04:05:27','2026-09-30 04:05:27'),(92,1,33,'2026-09-30 10:05:27','Siang',1000.00,12.00,1.23,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi B','2026-09-30 04:05:27','2026-09-30 04:05:27'),(93,1,1,'2026-09-30 11:06:22','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 04:06:22','2026-09-30 04:06:22'),(96,1,1,'2026-09-30 14:30:00','Pagi',1000.00,12.00,1.25,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Catatan uji tanggal dan jam terpisah','2026-09-30 04:06:23','2026-09-30 04:06:23'),(97,1,37,'2026-09-30 09:06:23','Pagi',1000.00,10.00,1.20,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi A','2026-09-30 04:06:23','2026-09-30 04:06:23'),(98,1,38,'2026-09-30 10:06:23','Siang',1000.00,12.00,1.23,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi B','2026-09-30 04:06:23','2026-09-30 04:06:23'),(99,1,1,'2026-09-30 11:06:47','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 04:06:47','2026-09-30 04:06:47'),(102,1,1,'2026-09-30 14:30:00','Pagi',1000.00,12.00,1.25,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Catatan uji tanggal dan jam terpisah','2026-09-30 04:06:47','2026-09-30 04:06:47'),(103,1,42,'2026-09-30 09:06:47','Pagi',1000.00,10.00,1.20,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi A','2026-09-30 04:06:47','2026-09-30 04:06:47'),(104,1,43,'2026-09-30 10:06:47','Siang',1000.00,12.00,1.23,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi B','2026-09-30 04:06:47','2026-09-30 04:06:47'),(105,1,1,'2026-09-30 11:16:09','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 04:16:09','2026-09-30 04:16:09'),(108,1,1,'2026-09-30 14:30:00','Pagi',1000.00,12.00,1.25,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Catatan uji tanggal dan jam terpisah','2026-09-30 04:16:10','2026-09-30 04:16:10'),(109,1,47,'2026-09-30 09:16:10','Pagi',1000.00,10.00,1.20,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi A','2026-09-30 04:16:10','2026-09-30 04:16:10'),(110,1,48,'2026-09-30 10:16:10','Siang',1000.00,12.00,1.23,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi B','2026-09-30 04:16:10','2026-09-30 04:16:10'),(111,1,1,'2026-09-30 11:16:59','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 04:16:59','2026-09-30 04:16:59'),(114,1,1,'2026-09-30 14:30:00','Pagi',1000.00,12.00,1.25,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Catatan uji tanggal dan jam terpisah','2026-09-30 04:17:00','2026-09-30 04:17:00'),(115,1,52,'2026-09-30 09:17:01','Pagi',1000.00,10.00,1.20,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi A','2026-09-30 04:17:01','2026-09-30 04:17:01'),(116,1,53,'2026-09-30 10:17:01','Siang',1000.00,12.00,1.23,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi B','2026-09-30 04:17:01','2026-09-30 04:17:01'),(117,1,1,'2026-09-30 11:19:56','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 04:19:56','2026-09-30 04:19:56'),(120,1,1,'2026-09-30 14:30:00','Pagi',1000.00,12.00,1.25,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Catatan uji tanggal dan jam terpisah','2026-09-30 04:19:57','2026-09-30 04:19:57'),(121,1,57,'2026-09-30 09:19:57','Pagi',1000.00,10.00,1.20,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi A','2026-09-30 04:19:57','2026-09-30 04:19:57'),(122,1,58,'2026-09-30 10:19:57','Siang',1000.00,12.00,1.23,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi B','2026-09-30 04:19:57','2026-09-30 04:19:57'),(123,1,1,'2026-09-30 11:26:10','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 04:26:10','2026-09-30 04:26:10'),(126,1,1,'2026-09-30 14:30:00','Pagi',1000.00,12.00,1.25,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Catatan uji tanggal dan jam terpisah','2026-09-30 04:26:13','2026-09-30 04:26:13'),(127,1,62,'2026-09-30 09:26:13','Pagi',1000.00,10.00,1.20,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi A','2026-09-30 04:26:13','2026-09-30 04:26:13'),(128,1,63,'2026-09-30 10:26:13','Siang',1000.00,12.00,1.23,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi B','2026-09-30 04:26:13','2026-09-30 04:26:13'),(129,1,1,'2026-09-30 12:15:13','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 05:15:13','2026-09-30 05:15:13'),(132,1,1,'2026-09-30 14:30:00','Pagi',1000.00,12.00,1.25,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Catatan uji tanggal dan jam terpisah','2026-09-30 05:15:14','2026-09-30 05:15:14'),(133,1,67,'2026-09-30 10:15:14','Pagi',1000.00,10.00,1.20,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi A','2026-09-30 05:15:14','2026-09-30 05:15:14'),(134,1,68,'2026-09-30 11:15:14','Siang',1000.00,12.00,1.23,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi B','2026-09-30 05:15:14','2026-09-30 05:15:14'),(135,1,1,'2026-09-30 12:38:54','Pagi',1000.00,15.00,1.28,NULL,NULL,44.50,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal','Logged from Flutter Android App','2026-09-30 05:38:54','2026-09-30 05:38:54'),(138,1,1,'2026-09-30 14:30:00','Pagi',1000.00,12.00,1.25,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Catatan uji tanggal dan jam terpisah','2026-09-30 05:38:55','2026-09-30 05:38:55'),(139,1,72,'2026-09-30 10:38:56','Pagi',1000.00,10.00,1.20,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi A','2026-09-30 05:38:56','2026-09-30 05:38:56'),(140,1,73,'2026-09-30 11:38:56','Siang',1000.00,12.00,1.23,NULL,NULL,NULL,NULL,'PLN Utama',NULL,NULL,NULL,50.00,'Good Link',NULL,NULL,'Normal','Log milik Teknisi B','2026-09-30 05:38:56','2026-09-30 05:38:56'),(141,4,4,'2026-09-30 14:31:00','Pagi',1000.00,15.00,1.28,48.00,28.50,42.00,24.00,'PLN',NULL,NULL,NULL,50.00,'Normal',NULL,NULL,'Normal',NULL,'2026-09-30 07:31:14','2026-09-30 07:31:14'); /*!40000 ALTER TABLE `transmitter_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `transmitters` -- DROP TABLE IF EXISTS `transmitters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transmitters` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(50) NOT NULL, `name` varchar(150) NOT NULL, `type` enum('FM','AM') NOT NULL DEFAULT 'FM', `frequency` varchar(50) NOT NULL, `call_sign` varchar(100) DEFAULT NULL, `site_location` varchar(200) DEFAULT NULL, `brand_model` varchar(150) DEFAULT NULL, `serial_number` varchar(100) DEFAULT NULL, `nominal_power` int(10) unsigned NOT NULL DEFAULT 1000, `max_power` int(10) unsigned DEFAULT NULL, `status` enum('active','standby','maintenance','off') NOT NULL DEFAULT 'active', `installed_year` smallint(5) unsigned DEFAULT NULL, `notes` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `transmitters_code_unique` (`code`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transmitters` -- LOCK TABLES `transmitters` WRITE; /*!40000 ALTER TABLE `transmitters` DISABLE KEYS */; INSERT INTO `transmitters` VALUES (1,'TX-FM-01','Pemancar Utama FM 101.5 MHz','FM','101.50 MHz','PRO 1 FM','Stasiun Transmisi Gombel','RVR TEX1000LCD','RVR-2022-8819',1000,1200,'active',2022,'Pemancar utama siaran Programa 1. Bekerja 24 Jam.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(2,'TX-FM-02','Pemancar Utama FM 97.2 MHz','FM','97.20 MHz','PRO 2 FM','Stasiun Transmisi Gombel','Nautel NV5-LT','NTL-NV5-2023-04',5000,5500,'active',2023,'Pemancar musik & anak muda Programa 2 FM.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(3,'TX-AM-01','Pemancar Utama AM 828 kHz','AM','828 kHz','PRO 1 AM','Stasiun Transmisi Sayung KM 14','GatesAir DAX-5','GA-DAX5-1998',5000,6000,'active',2019,'Pemancar Gelombang Menengah (MW / AM). Jangkauan Jawa Tengah.','2026-09-30 01:54:23','2026-09-30 01:54:23'),(4,'TX-FM-BK1','Pemancar Cadangan FM 101.5 MHz','FM','101.50 MHz','PRO 1 BK','Stasiun Transmisi Gombel','OMB EM 1000','OMB-1000-092',1000,1000,'standby',2020,'Standby hot-backup bila TX-FM-01 mengalami kendala teknis.','2026-09-30 01:54:23','2026-09-30 01:54:23'); /*!40000 ALTER TABLE `transmitters` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `nip` varchar(50) DEFAULT NULL, `email` varchar(255) NOT NULL, `role` varchar(30) NOT NULL DEFAULT 'technician', `phone` varchar(30) DEFAULT NULL, `call_sign` varchar(50) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'PURNOMO SHIDDIQ','199304092024211001','admin@logbook.local','admin','081234567890','YB2XYZ',1,NULL,'$2y$12$Kt4BPJP6OL9Ilp0z9wevWOThWaqx8zeGDpWqObJosuykOof5zJHTC','F40H2uAocpzLc7xwz81MV12shuNMflK72TJZRHhZcYUmF37fIknfRA1SGHRi','2026-09-30 01:54:22','2026-09-30 02:30:59'),(2,'Ir. Hendra Gunawan',NULL,'supervisor@logbook.local','supervisor','081234567891','YC2ABC',1,NULL,'$2y$12$pGrLXAN0KU70yulWWVjIIuBLRCKAttxmnwdcNMUCl4IbRc8dcOB7K',NULL,'2026-09-30 01:54:23','2026-09-30 01:54:23'),(3,'Rahmat Hidayat',NULL,'teknisi1@logbook.local','technician','081234567892','YD2OPQ',1,NULL,'$2y$12$wYsJgHDlOtGtiYHRRUewnu6p19fxepMkD.o4L0gcF86k7bEcGqdiG','fb1Rx88xGYHabB25pWvxy1qPDZsftrGWtaQdjoWI1YbWxpSfTDwHEt25N07z','2026-09-30 01:54:23','2026-09-30 01:54:23'),(4,'Agus Wicaksono',NULL,'teknisi2@logbook.local','technician','081234567893','YD2RST',1,NULL,'$2y$12$1S.uzru/pKB9UQ3NWSuGTuF2SD7JW7LiJT90fIcO.yyz/pE2bkuaK',NULL,'2026-09-30 01:54:23','2026-09-30 01:54:23'),(5,'Teknisi Baru Testing','199501012022011005','teknisi.test721@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$XQfGrvChkHQJylTYkRvKFen9E5Zgqad3EBTijSMpyJ730l6x4uIi.',NULL,'2026-09-30 02:24:26','2026-09-30 02:24:26'),(6,'Teknisi Baru Testing','199501012022011005','teknisi.test970@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$ZgQirHfBxD2LMdg551Mepud1pg4wSyBWefX9WYnOMTUCW5cZMpBrO',NULL,'2026-09-30 02:28:53','2026-09-30 02:28:53'),(7,'Teknisi Baru Testing','199501012022011005','teknisi.test408@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$okXraqRuP./9nbJNQeC9eun4B/kq4gj0JoNLxKAqnR9BbpyTqFmgu',NULL,'2026-09-30 02:31:35','2026-09-30 02:31:35'),(8,'Teknisi Baru Testing','199501012022011005','teknisi.test430@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$60t7G.quO7ZYiumqfgo.HuJWoEQP5IoHM6eTUk4GvYRFrqwoztyUK',NULL,'2026-09-30 02:38:41','2026-09-30 02:38:41'),(9,'Teknisi Baru Testing','199501012022011005','teknisi.test681@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$F1.xugMfsPux1BMBpp5mzuTQyf.AlnRHNtDms98bmUukHr4Wahj9.',NULL,'2026-09-30 02:39:49','2026-09-30 02:39:49'),(10,'Teknisi Baru Testing','199501012022011005','teknisi.test122@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$zsVLL/IBv.FKgRWoJ/ZyAuh8PP0ZtZy4qRrU1ngDU2FEyQR/Opk4a',NULL,'2026-09-30 02:52:40','2026-09-30 02:52:40'),(11,'Teknisi Baru Testing','199501012022011005','teknisi.test880@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$m4wwUuEyzcraK6au8K0Nmu1YFgBx0vVnMqgVe8clx.8ymGtbPUZcO',NULL,'2026-09-30 02:53:29','2026-09-30 02:53:29'),(12,'Teknisi Baru Testing','199501012022011005','teknisi.test848@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$YNKecrV5pfvkaKBsQstLXuOxn82JQWIhSsiMV3u889I2LQ1e0uhGy',NULL,'2026-09-30 03:01:26','2026-09-30 03:01:26'),(13,'Teknisi Baru Testing','199501012022011005','teknisi.test620@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$R8dl8WnTFW0/pcA0xc/PW.MiIho8JKBwQ0MQnfayRw6fh9Ze5/b3e',NULL,'2026-09-30 03:13:56','2026-09-30 03:13:56'),(14,'Teknisi Baru Testing','199501012022011005','teknisi.test239@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$LZpd43MM9zb21hHwREFqB.0EUarxQcQnS89ZDui3zEEoHReDzs80W',NULL,'2026-09-30 03:21:36','2026-09-30 03:21:36'),(15,'Teknisi Baru Testing','199501012022011005','teknisi.test751@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$AdcQDFyANp/7YuIcc0Iwp.bVfftfPKUNmIyuTAmV3oiiLXTxnIGnS',NULL,'2026-09-30 03:21:57','2026-09-30 03:21:57'),(16,'Teknisi Baru Testing','199501012022011005','teknisi.test666@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$QlX9TFGy7ekESeylshWZEupSmceWn.DN33kTXzADOPW/NSJsnxtBa',NULL,'2026-09-30 03:23:05','2026-09-30 03:23:05'),(17,'Teknisi Baru Testing','199501012022011005','teknisi.test261@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$4tYxGQTPHLDPoS9lZP1ThuGQvrjD.vY0TY9YMxBg8qlYjSk/0AeVq',NULL,'2026-09-30 03:24:32','2026-09-30 03:24:32'),(18,'Teknisi Baru Testing','199501012022011005','teknisi.test661@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$f4I67vEkm6/NaGZrbpqhwO3F6sAcJCiTdWfKyCI0x26yxeSNpY/dW',NULL,'2026-09-30 03:24:50','2026-09-30 03:24:50'),(19,'Teknisi Baru Testing 6abc81636376e','1995010139235173','teknisi_6abc81636376e@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$wunt..Z/.8/EbbsxQTIGjeNrCMfI/JodHMftkcJzu7W9TybzAMstC',NULL,'2026-09-30 03:26:27','2026-09-30 03:26:27'),(20,'Teknisi Baru Testing 6abc83d7552a8','1995010195309523','teknisi_6abc83d7552a8@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$4qx4tkZj7UZwubB1zro4O.WY0Sw/uVpGQ5ZVrZP0aheroDa2jtdki',NULL,'2026-09-30 03:36:55','2026-09-30 03:36:55'),(23,'Teknisi Baru Testing 6abc868a02c56','1995010156804135','teknisi_6abc868a02c56@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$F7KBiEAqRg0ZFjpA3EyoheZuIjHhF17lASYy.xyRP35ysFEIGShfq',NULL,'2026-09-30 03:48:26','2026-09-30 03:48:26'),(26,'Teknisi Baru Testing 6abc8872d6a5d','1995010175153045','teknisi_6abc8872d6a5d@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$g/bUwdKsA43DzcbVxhIl2.Hg31Al9jkGLRCOcyBFCfDhcsdIw0ILy',NULL,'2026-09-30 03:56:34','2026-09-30 03:56:34'),(29,'Teknisi Baru Testing 6abc8a86bef54','1995010146418797','teknisi_6abc8a86bef54@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$CBsBtgZc1xlulWeBBVkVBuoolll4AjY2sKKDAskzdfcBXy7LcXXi2',NULL,'2026-09-30 04:05:26','2026-09-30 04:05:26'),(32,'Teknisi A 6abc8a877f6dc',NULL,'techA_6abc8a877f6de@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$7Iu0mdCPlFJ0q03NXZ5POe3pIqOVQRZxMvlp6rWm58ulxXGeSL.e2',NULL,'2026-09-30 04:05:27','2026-09-30 04:05:27'),(33,'Teknisi B 6abc8a87815f2',NULL,'techB_6abc8a87815f6@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$Qq7QLRzl.aDTu6ttVWBoEeCKGV4pDgUJKOyEkuQKG/IH1m8xKBPmC',NULL,'2026-09-30 04:05:27','2026-09-30 04:05:27'),(34,'Teknisi Baru Testing 6abc8abee0f66','1995010119024803','teknisi_6abc8abee0f66@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$rcD52DrOnmF6YsQXYrEV0OQ7NeRUaUbkur2sepejHvX3u.VJBGsWG',NULL,'2026-09-30 04:06:22','2026-09-30 04:06:22'),(37,'Teknisi A 6abc8abf6adf1',NULL,'techA_6abc8abf6adf5@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$STFRVLw1jIZ6kOZqciPE1.bFkBN8z4c504QVHUmjfHadN7dEegcvq',NULL,'2026-09-30 04:06:23','2026-09-30 04:06:23'),(38,'Teknisi B 6abc8abf6c244',NULL,'techB_6abc8abf6c247@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$u051ICRn6OSVy0MEd.ciP.RFnUQ53D2xnxp.kcDCii4/M37t07G..',NULL,'2026-09-30 04:06:23','2026-09-30 04:06:23'),(39,'Teknisi Baru Testing 6abc8ad72a691','1995010183860867','teknisi_6abc8ad72a691@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$FOri9.NrlqirigFnm4gnROHpvQJteJ19l2RYjw46L1FmPtvsCu5ie',NULL,'2026-09-30 04:06:47','2026-09-30 04:06:47'),(42,'Teknisi A 6abc8ad7b5354',NULL,'techA_6abc8ad7b5356@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$dgqsjfiX9QXsjlyxJRp8NenWrOPqkoIXhY8V5oPSo.V4y6cwKfsSe',NULL,'2026-09-30 04:06:47','2026-09-30 04:06:47'),(43,'Teknisi B 6abc8ad7b6dda',NULL,'techB_6abc8ad7b6ddd@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$IHnJLf7BRbyUbeC7iQAy/eYSGuZbv0DNs1jdYpZy2aL.joLIB/2AS',NULL,'2026-09-30 04:06:47','2026-09-30 04:06:47'),(44,'Teknisi Baru Testing 6abc8d09a51fb','1995010188534255','teknisi_6abc8d09a51fb@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$jhOVDm34nLQ/3owPIvEVauD.ugBMMuSW0cIEMuryhI13JXx0Fr6PW',NULL,'2026-09-30 04:16:09','2026-09-30 04:16:09'),(47,'Teknisi A 6abc8d0a639ba',NULL,'techA_6abc8d0a639bd@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$tAVkCnECuWmlnf24dMK1cetdc7CujME17vncFF7zLz2Ba2fY5N4zG',NULL,'2026-09-30 04:16:10','2026-09-30 04:16:10'),(48,'Teknisi B 6abc8d0a65244',NULL,'techB_6abc8d0a65248@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$xivShUO.ul.5tw2NBj34R.DmbsAe8IjX9Hn3R37DQ7tQG.E/lgc/W',NULL,'2026-09-30 04:16:10','2026-09-30 04:16:10'),(49,'Teknisi Baru Testing 6abc8d3bec148','1995010125091600','teknisi_6abc8d3bec148@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$aR21YAZNDEFQ51k6Wj0tPeA6S/HQrr38xpQjjfu1FKW/5TgQLx/2q',NULL,'2026-09-30 04:16:59','2026-09-30 04:16:59'),(52,'Teknisi A 6abc8d3d28dea',NULL,'techA_6abc8d3d28dee@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$Z/vv9n4Fsx11WUVtYz/klegv9TlS5aZpKZmbZx2VcpgLdyfYHp8Ta',NULL,'2026-09-30 04:17:01','2026-09-30 04:17:01'),(53,'Teknisi B 6abc8d3d2a917',NULL,'techB_6abc8d3d2a91b@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$LThoun3nU9jrkpjsVwZRmO5JkL1SkQ2MzIeXvmsqq4GPtif7U2PQa',NULL,'2026-09-30 04:17:01','2026-09-30 04:17:01'),(54,'Teknisi Baru Testing 6abc8dec6a38e','1995010180165589','teknisi_6abc8dec6a38e@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$KaTQ/ksOE.Imze2SrGHKEuyyFjF0JSoVsdZK9OsH8hMNZzvpnLPU6',NULL,'2026-09-30 04:19:56','2026-09-30 04:19:56'),(57,'Teknisi A 6abc8ded4d6c8',NULL,'techA_6abc8ded4d6cb@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$33WcB92oaq9ItddkjlXYXOPTRIgALkI1sPZC2QOGLlMCYE3Pu886O',NULL,'2026-09-30 04:19:57','2026-09-30 04:19:57'),(58,'Teknisi B 6abc8ded4e72d',NULL,'techB_6abc8ded4e730@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$xAVUy8vmaxWVzMkhioun7OEdFXXPgyT4DOIwGqeYhin5LDnedt8GC',NULL,'2026-09-30 04:19:57','2026-09-30 04:19:57'),(59,'Teknisi Baru Testing 6abc8f6329f7b','1995010175904766','teknisi_6abc8f6329f7b@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$UZ/ezE5GnSgZtRR0TuM97O0A1vpxV3CAUteYUo2nCE0FUUL7BBd8W',NULL,'2026-09-30 04:26:11','2026-09-30 04:26:11'),(62,'Teknisi A 6abc8f65d35d2',NULL,'techA_6abc8f65d35d4@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$DdplrwP8le7te3it/kVT0.iqpcT0cU2c5ecJy99PHOstfdMr2SGRG',NULL,'2026-09-30 04:26:13','2026-09-30 04:26:13'),(63,'Teknisi B 6abc8f65d54bf',NULL,'techB_6abc8f65d54c1@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$PePq6BuNtyiwklHzRHna7uCBHHYkjhPh3GbHuhNGGNp1aCu1PQNSm',NULL,'2026-09-30 04:26:13','2026-09-30 04:26:13'),(64,'Teknisi Baru Testing 6abc9ae1e6500','1995010164183257','teknisi_6abc9ae1e6500@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$5kogK.D28K5DbsfU1zUWQu2ZxqZTguy/q9.Mgu5/JFBrO0h1dV722',NULL,'2026-09-30 05:15:13','2026-09-30 05:15:13'),(67,'Teknisi A 6abc9ae298974',NULL,'techA_6abc9ae298976@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$EffUYgTl95Ptmh7WdUaYFepcjVLLg5FKju.tK4lV64Dc3hCy7pnYG',NULL,'2026-09-30 05:15:14','2026-09-30 05:15:14'),(68,'Teknisi B 6abc9ae29a3d6',NULL,'techB_6abc9ae29a3d8@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$JmTHjZkrYOU8p6m95/s9u.EJIbPT7l.bwLXa96mo74ZefBx1edEB6',NULL,'2026-09-30 05:15:14','2026-09-30 05:15:14'),(69,'Teknisi Baru Testing 6abca06ebcab4','1995010157708483','teknisi_6abca06ebcab4@logbook.local','technician','089999888877','YD2NEW',1,NULL,'$2y$04$RPofhgM91aJrrO56ifgycu.CdZ88L3Y92qXIlk8g9QPj4x67ekbCe',NULL,'2026-09-30 05:38:54','2026-09-30 05:38:54'),(72,'Teknisi A 6abca0703be9f',NULL,'techA_6abca0703bea2@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$Pyc5HlY74hM62v/yiVw9We1ZdW.jCwhckJX0gNNAOlKNg97YXUk6q',NULL,'2026-09-30 05:38:56','2026-09-30 05:38:56'),(73,'Teknisi B 6abca0703d729',NULL,'techB_6abca0703d72c@logbook.local','technician',NULL,NULL,1,NULL,'$2y$04$K12CGBPRR8q0tRHEHDOfwei2PyqBEaCErkNQABUCzj3OIJOZqw27m',NULL,'2026-09-30 05:38:56','2026-09-30 05:38:56'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-09-30 15:22:13