-- MariaDB dump 10.17  Distrib 10.4.8-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: acc_one_log
-- ------------------------------------------------------
-- Server version	10.4.8-MariaDB-1:10.4.8+maria~bionic-log

/*!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 */;

--
-- Table structure for table `itemunit_log`
--

DROP TABLE IF EXISTS `itemunit_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `itemunit_log` (
  `ItemUnitLogID` int(11) NOT NULL AUTO_INCREMENT,
  `ItemUnitLogItemUnitID` int(11) DEFAULT NULL,
  `ItemUnitLogStatus` varchar(15) DEFAULT NULL COMMENT 'ADD,EDIT,DELETE',
  `ItemUnitLogJSONBefore` text DEFAULT NULL,
  `ItemUnitLogJSONAfter` text DEFAULT NULL,
  `ItemUnitLogUserID` int(11) DEFAULT NULL,
  `ItemUnitLogCreated` datetime DEFAULT NULL,
  PRIMARY KEY (`ItemUnitLogID`),
  KEY `ItemUnitLogItemUnitID` (`ItemUnitLogItemUnitID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `itemunit_log`
--

LOCK TABLES `itemunit_log` WRITE;
/*!40000 ALTER TABLE `itemunit_log` DISABLE KEYS */;
INSERT INTO `itemunit_log` VALUES (1,17,'ADD',NULL,'{\"ItemUnitID\":\"17\",\"ItemUnitCode\":\"UI2400027\",\"ItemUnitName\":\"coba tes\",\"ItemUnitIsActive\":\"Y\",\"ItemUnitCreated\":\"2024-09-24 16:16:04\",\"ItemUnitLastUpdated\":\"2024-09-24 16:16:04\",\"ItemUnitUserID\":\"3\"}',3,'2024-09-24 16:16:04'),(2,17,'EDIT','{\"ItemUnitID\":\"17\",\"ItemUnitCode\":\"UI2400027\",\"ItemUnitName\":\"coba tes\",\"ItemUnitIsActive\":\"Y\",\"ItemUnitCreated\":\"2024-09-24 16:16:04\",\"ItemUnitLastUpdated\":\"2024-09-24 16:16:04\",\"ItemUnitUserID\":\"3\"}','{\"ItemUnitID\":\"17\",\"ItemUnitCode\":\"UI2400027\",\"ItemUnitName\":\"coba\",\"ItemUnitIsActive\":\"Y\",\"ItemUnitCreated\":\"2024-09-24 16:16:04\",\"ItemUnitLastUpdated\":\"2024-09-24 16:16:20\",\"ItemUnitUserID\":\"3\"}',3,'2024-09-24 16:16:20'),(3,17,'DELETE',NULL,'{\"ItemUnitID\":\"17\",\"ItemUnitCode\":\"UI2400027\",\"ItemUnitName\":\"coba\",\"ItemUnitIsActive\":\"N\",\"ItemUnitCreated\":\"2024-09-24 16:16:04\",\"ItemUnitLastUpdated\":\"2024-09-24 16:16:24\",\"ItemUnitUserID\":\"3\"}',3,'2024-09-24 16:16:24');
/*!40000 ALTER TABLE `itemunit_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_login`
--

DROP TABLE IF EXISTS `log_login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_login` (
  `Log_LoginID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_LoginDateTime` datetime NOT NULL,
  `Log_LoginIP` varchar(30) NOT NULL,
  `Log_LoginType` varchar(6) NOT NULL COMMENT 'LOGIN / LOGOUT',
  `Log_LoginStatus` varchar(10) NOT NULL COMMENT 'SUCCESS / FAILED',
  `Log_LoginLogin` varchar(50) NOT NULL COMMENT 'Username',
  `Log_LoginIsActive` char(1) NOT NULL DEFAULT 'Y',
  `Log_LoginLastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`Log_LoginID`)
) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_login`
--

LOCK TABLES `log_login` WRITE;
/*!40000 ALTER TABLE `log_login` DISABLE KEYS */;
INSERT INTO `log_login` VALUES (1,'2024-09-02 09:58:51','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 02:58:51'),(2,'2024-09-02 09:59:29','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 02:59:29'),(3,'2024-09-02 10:41:15','149.113.95.153','LOGIN','SUCCESS','adminsas','Y','2024-09-02 03:41:15'),(4,'2024-09-02 10:59:15','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 03:59:15'),(5,'2024-09-02 11:11:25','149.113.95.153','LOGIN','SUCCESS','adminsas','Y','2024-09-02 04:11:25'),(6,'2024-09-02 11:15:01','149.113.95.153','LOGIN','FAILED','','Y','2024-09-02 04:15:01'),(7,'2024-09-02 11:15:31','149.113.95.153','LOGIN','FAILED','','Y','2024-09-02 04:15:31'),(8,'2024-09-02 11:15:50','149.113.95.153','LOGIN','SUCCESS','adminsas','Y','2024-09-02 04:15:50'),(9,'2024-09-02 11:36:08','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 04:36:08'),(10,'2024-09-02 14:26:20','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 07:26:20'),(11,'2024-09-02 14:27:30','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 07:27:30'),(12,'2024-09-02 14:29:44','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 07:29:44'),(13,'2024-09-02 14:29:56','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 07:29:56'),(14,'2024-09-02 14:31:48','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 07:31:48'),(15,'2024-09-02 14:32:32','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 07:32:32'),(16,'2024-09-02 14:37:04','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 07:37:04'),(17,'2024-09-02 14:40:01','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 07:40:01'),(18,'2024-09-02 15:24:46','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 08:24:46'),(19,'2024-09-02 16:39:58','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 09:39:58'),(20,'2024-09-02 16:56:09','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 09:56:09'),(21,'2024-09-02 18:22:01','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 11:22:01'),(22,'2024-09-02 18:25:33','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 11:25:33'),(23,'2024-09-02 18:42:36','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 11:42:36'),(24,'2024-09-02 18:47:40','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 11:47:40'),(25,'2024-09-02 19:18:07','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 12:18:07'),(26,'2024-09-02 20:15:02','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-02 13:15:02'),(27,'2024-09-03 08:08:41','149.113.95.153','LOGIN','FAILED','adminsas','Y','2024-09-03 01:08:41'),(28,'2024-09-03 08:08:47','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-03 01:08:47'),(29,'2024-09-03 08:12:38','149.113.95.153','LOGIN','FAILED','admin','Y','2024-09-03 01:12:38'),(30,'2024-09-03 08:12:43','149.113.95.153','LOGIN','FAILED','admin','Y','2024-09-03 01:12:43'),(31,'2024-09-03 08:12:46','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-03 01:12:46'),(32,'2024-09-03 09:00:54','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-03 02:00:54'),(33,'2024-09-03 09:11:05','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-03 02:11:05'),(34,'2024-09-03 10:34:56','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-03 03:34:56'),(35,'2024-09-03 10:38:28','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-03 03:38:28'),(36,'2024-09-03 11:05:52','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-03 04:05:52'),(37,'2024-09-03 11:21:37','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-03 04:21:37'),(38,'2024-09-03 15:31:50','149.113.95.153','LOGIN','FAILED','admin','Y','2024-09-03 08:31:50'),(39,'2024-09-03 15:31:52','149.113.95.153','LOGIN','FAILED','admin','Y','2024-09-03 08:31:52'),(40,'2024-09-03 15:31:52','149.113.95.153','LOGIN','FAILED','admin','Y','2024-09-03 08:31:52'),(41,'2024-09-03 15:31:53','149.113.95.153','LOGIN','FAILED','admin','Y','2024-09-03 08:31:53'),(42,'2024-09-03 15:31:59','149.113.95.153','LOGIN','SUCCESS','admin','Y','2024-09-03 08:31:59'),(43,'2024-09-03 16:14:05','149.113.95.153','LOGIN','SUCCESS','adminsas','Y','2024-09-03 09:14:05'),(44,'2024-09-04 16:13:02','149.108.30.138','LOGIN','SUCCESS','admin','Y','2024-09-04 09:13:02'),(45,'2024-09-09 11:22:48','139.0.234.199','LOGIN','SUCCESS','admin','Y','2024-09-09 04:22:48'),(46,'2024-09-16 15:09:33','36.68.10.232','LOGIN','FAILED','admin','Y','2024-09-16 08:09:33'),(47,'2024-09-16 15:09:37','36.68.10.232','LOGIN','SUCCESS','admin','Y','2024-09-16 08:09:37'),(48,'2024-09-19 11:36:25','139.195.124.200','LOGIN','SUCCESS','admin','Y','2024-09-19 04:36:25'),(49,'2024-09-24 13:55:24','139.0.96.211','LOGIN','FAILED','admin','Y','2024-09-24 06:55:24'),(50,'2024-09-24 13:55:44','139.0.96.211','LOGIN','SUCCESS','adminsas','Y','2024-09-24 06:55:44'),(51,'2024-09-26 14:55:12','118.136.64.10','LOGIN','FAILED','admin','Y','2024-09-26 07:55:12'),(52,'2024-09-26 14:55:13','118.136.64.10','LOGIN','FAILED','admin','Y','2024-09-26 07:55:13'),(53,'2024-09-26 14:55:17','118.136.64.10','LOGIN','SUCCESS','adminsas','Y','2024-09-26 07:55:17'),(54,'2024-09-26 15:39:24','103.124.138.26','LOGIN','SUCCESS','adminsas','Y','2024-09-26 08:39:24'),(55,'2024-12-24 15:10:27','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:10:27'),(56,'2024-12-24 15:10:30','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:10:30'),(57,'2024-12-24 15:10:34','139.0.159.65','LOGIN','SUCCESS','adminsas','Y','2024-12-24 08:10:34'),(58,'2024-12-24 15:10:50','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:10:50'),(59,'2024-12-24 15:10:53','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:10:53'),(60,'2024-12-24 15:11:00','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:11:00'),(61,'2024-12-24 15:11:07','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:11:07'),(62,'2024-12-24 15:11:07','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:11:07'),(63,'2024-12-24 15:11:07','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:11:07'),(64,'2024-12-24 15:11:08','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:11:08'),(65,'2024-12-24 15:11:15','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:11:15'),(66,'2024-12-24 15:11:20','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:11:20'),(67,'2024-12-24 15:11:23','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:11:23'),(68,'2024-12-24 15:11:27','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 08:11:27'),(69,'2024-12-24 15:11:39','139.0.159.65','LOGIN','SUCCESS','adminsas','Y','2024-12-24 08:11:39'),(70,'2024-12-24 16:09:54','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 09:09:54'),(71,'2024-12-24 16:10:01','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 09:10:01'),(72,'2024-12-24 16:10:39','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 09:10:39'),(73,'2024-12-24 16:10:45','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 09:10:45'),(74,'2024-12-24 16:11:03','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 09:11:03'),(75,'2024-12-24 16:11:07','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 09:11:07'),(76,'2024-12-24 16:11:11','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 09:11:11'),(77,'2024-12-24 16:11:11','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 09:11:11'),(78,'2024-12-24 16:11:11','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 09:11:11'),(79,'2024-12-24 16:11:15','139.0.159.65','LOGIN','FAILED','admin','Y','2024-12-24 09:11:15'),(80,'2024-12-24 16:14:06','139.0.159.65','LOGIN','SUCCESS','adminsas','Y','2024-12-24 09:14:06'),(81,'2025-01-06 14:42:05','139.192.162.175','LOGIN','SUCCESS','adminsas','Y','2025-01-06 07:42:05'),(82,'2025-01-07 08:53:53','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 01:53:53'),(83,'2025-01-07 08:57:13','139.192.162.175','LOGIN','SUCCESS','adminsas','Y','2025-01-07 01:57:13'),(84,'2025-01-07 08:58:43','139.192.162.175','LOGIN','FAILED','adminsas','Y','2025-01-07 01:58:43'),(85,'2025-01-07 08:58:49','139.192.162.175','LOGIN','FAILED','adminsas','Y','2025-01-07 01:58:49'),(86,'2025-01-07 08:58:56','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 01:58:56'),(87,'2025-01-07 08:59:01','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 01:59:01'),(88,'2025-01-07 08:59:10','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 01:59:10'),(89,'2025-01-07 08:59:15','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 01:59:15'),(90,'2025-01-07 08:59:23','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 01:59:23'),(91,'2025-01-07 08:59:32','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 01:59:32'),(92,'2025-01-07 09:00:27','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 02:00:27'),(93,'2025-01-07 09:00:45','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 02:00:45'),(94,'2025-01-07 09:00:53','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 02:00:53'),(95,'2025-01-07 09:00:58','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 02:00:58'),(96,'2025-01-07 09:01:02','139.192.162.175','LOGIN','FAILED','admin','Y','2025-01-07 02:01:02'),(97,'2025-01-07 09:01:07','139.192.162.175','LOGIN','SUCCESS','admin','Y','2025-01-07 02:01:07'),(98,'2025-01-07 09:12:24','139.192.162.175','LOGIN','FAILED','Stek','Y','2025-01-07 02:12:24'),(99,'2025-01-07 09:12:33','139.192.162.175','LOGIN','FAILED','Stek','Y','2025-01-07 02:12:33'),(100,'2025-01-07 09:12:44','139.192.162.175','LOGIN','FAILED','Stek','Y','2025-01-07 02:12:44'),(101,'2025-01-07 09:12:46','139.192.162.175','LOGIN','FAILED','Stek','Y','2025-01-07 02:12:46'),(102,'2025-01-07 09:12:50','139.192.162.175','LOGIN','SUCCESS','Stek','Y','2025-01-07 02:12:50'),(103,'2025-01-07 09:40:02','139.192.162.175','LOGIN','SUCCESS','admin','Y','2025-01-07 02:40:02'),(104,'2025-01-07 09:43:28','139.192.162.175','LOGIN','SUCCESS','adminsas','Y','2025-01-07 02:43:28'),(105,'2025-01-07 15:05:49','149.113.119.246','LOGIN','FAILED','sad','Y','2025-01-07 08:05:49'),(106,'2025-01-07 15:06:03','149.113.119.246','LOGIN','FAILED','sad','Y','2025-01-07 08:06:03'),(107,'2025-01-07 15:11:49','149.113.119.246','LOGIN','FAILED','admin','Y','2025-01-07 08:11:49'),(108,'2025-01-07 15:11:51','149.113.119.246','LOGIN','FAILED','admin','Y','2025-01-07 08:11:51'),(109,'2025-01-07 15:12:00','149.113.119.246','LOGIN','FAILED','admin','Y','2025-01-07 08:12:00'),(110,'2025-01-07 15:12:06','149.113.119.246','LOGIN','FAILED','admin','Y','2025-01-07 08:12:06'),(111,'2025-01-07 15:12:10','149.113.119.246','LOGIN','FAILED','adminfo','Y','2025-01-07 08:12:10'),(112,'2025-01-07 15:12:14','149.113.119.246','LOGIN','SUCCESS','adminsas','Y','2025-01-07 08:12:14'),(113,'2025-01-07 19:08:43','149.113.119.246','LOGIN','FAILED','sad','Y','2025-01-07 12:08:43'),(114,'2025-01-07 19:08:54','149.113.119.246','LOGIN','FAILED','sad','Y','2025-01-07 12:08:54'),(115,'2025-01-07 19:09:48','149.113.119.246','LOGIN','FAILED','asd','Y','2025-01-07 12:09:48'),(116,'2025-01-08 10:06:03','149.113.119.246','LOGIN','FAILED','asd','Y','2025-01-08 03:06:03'),(117,'2025-01-08 10:07:17','149.113.119.246','LOGIN','FAILED','sad','Y','2025-01-08 03:07:17'),(118,'2025-01-08 10:20:17','149.113.119.246','LOGIN','FAILED','admin','Y','2025-01-08 03:20:17'),(119,'2025-01-08 10:20:38','149.113.119.246','LOGIN','FAILED','admin','Y','2025-01-08 03:20:38'),(120,'2025-01-08 10:20:46','149.113.119.246','LOGIN','FAILED','adminsas','Y','2025-01-08 03:20:46'),(121,'2025-01-08 10:20:49','149.113.119.246','LOGIN','FAILED','admin','Y','2025-01-08 03:20:49'),(122,'2025-01-08 10:20:59','149.113.119.246','LOGIN','FAILED','admin','Y','2025-01-08 03:20:59'),(123,'2025-01-08 10:21:14','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 03:21:14'),(124,'2025-01-08 10:40:22','149.113.119.246','LOGIN','FAILED','adminsas','Y','2025-01-08 03:40:22'),(125,'2025-01-08 10:40:32','149.113.119.246','LOGIN','FAILED','adminsas','Y','2025-01-08 03:40:32'),(126,'2025-01-08 10:54:23','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 03:54:23'),(127,'2025-01-08 10:54:48','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 03:54:48'),(128,'2025-01-08 10:55:02','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 03:55:02'),(129,'2025-01-08 10:55:04','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 03:55:04'),(130,'2025-01-08 10:55:04','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 03:55:04'),(131,'2025-01-08 11:13:44','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 04:13:44'),(132,'2025-01-08 11:24:32','149.113.119.246','LOGIN','SUCCESS','cobabranch','Y','2025-01-08 04:24:32'),(133,'2025-01-08 13:37:08','149.113.119.246','LOGIN','SUCCESS','cobabranch','Y','2025-01-08 06:37:08'),(134,'2025-01-08 14:00:04','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 07:00:04'),(135,'2025-01-08 14:24:13','149.113.119.246','LOGIN','FAILED','adminsas','Y','2025-01-08 07:24:13'),(136,'2025-01-08 14:24:19','149.113.119.246','LOGIN','FAILED','adminsas','Y','2025-01-08 07:24:19'),(137,'2025-01-08 14:24:23','149.113.119.246','LOGIN','FAILED','adminsas','Y','2025-01-08 07:24:23'),(138,'2025-01-08 14:39:36','149.113.119.246','LOGIN','FAILED','adminsas','Y','2025-01-08 07:39:36'),(139,'2025-01-08 14:39:58','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 07:39:58'),(140,'2025-01-08 14:40:35','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 07:40:35'),(141,'2025-01-08 14:46:32','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 07:46:32'),(142,'2025-01-08 14:47:17','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 07:47:17'),(143,'2025-01-08 14:48:53','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 07:48:53'),(144,'2025-01-08 14:49:06','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 07:49:06'),(145,'2025-01-08 14:49:18','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 07:49:18'),(146,'2025-01-08 14:50:33','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 07:50:33'),(147,'2025-01-08 14:50:38','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 07:50:38'),(148,'2025-01-08 14:51:48','149.113.119.246','LOGIN','SUCCESS','cobabranch','Y','2025-01-08 07:51:48'),(149,'2025-01-08 14:52:19','149.113.119.246','LOGIN','SUCCESS','cobabranch2','Y','2025-01-08 07:52:19'),(150,'2025-01-08 14:58:59','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 07:58:59'),(151,'2025-01-08 15:10:39','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 08:10:39'),(152,'2025-01-08 17:18:46','149.113.119.246','LOGIN','SUCCESS','cobabranch','Y','2025-01-08 10:18:46'),(153,'2025-01-08 17:19:28','149.113.119.246','LOGIN','SUCCESS','cobabranch','Y','2025-01-08 10:19:28'),(154,'2025-01-08 17:25:53','149.113.119.246','LOGIN','SUCCESS','admin','Y','2025-01-08 10:25:53'),(155,'2025-01-08 17:29:35','149.113.119.246','LOGIN','SUCCESS','cobabranch','Y','2025-01-08 10:29:35'),(156,'2025-01-08 18:07:18','149.113.119.246','LOGIN','SUCCESS','cobabranch','Y','2025-01-08 11:07:18'),(157,'2025-01-08 18:09:35','149.113.119.246','LOGIN','SUCCESS','cobabranch','Y','2025-01-08 11:09:35'),(158,'2025-01-09 13:52:13','149.113.119.246','LOGIN','SUCCESS','cobabranch','Y','2025-01-09 06:52:13'),(159,'2025-01-10 08:52:36','139.192.158.103','LOGIN','FAILED','admincoba','Y','2025-01-10 01:52:36'),(160,'2025-01-10 08:52:41','139.192.158.103','LOGIN','FAILED','admincoba','Y','2025-01-10 01:52:41'),(161,'2025-01-10 08:52:50','139.192.158.103','LOGIN','FAILED','adminsas','Y','2025-01-10 01:52:50'),(162,'2025-01-10 08:53:55','139.192.158.103','LOGIN','FAILED','cobabranch','Y','2025-01-10 01:53:55'),(163,'2025-01-10 08:54:01','139.192.158.103','LOGIN','FAILED','cobabranch','Y','2025-01-10 01:54:01'),(164,'2025-01-10 08:56:08','139.192.158.103','LOGIN','FAILED','adminsas','Y','2025-01-10 01:56:08'),(165,'2025-01-10 08:56:19','139.192.158.103','LOGIN','FAILED','adminsas','Y','2025-01-10 01:56:19'),(166,'2025-01-10 08:56:51','139.192.158.103','LOGIN','FAILED','adminsas','Y','2025-01-10 01:56:51'),(167,'2025-01-10 08:57:01','139.192.158.103','LOGIN','FAILED','adminsas','Y','2025-01-10 01:57:01'),(168,'2025-01-10 08:57:06','139.192.158.103','LOGIN','FAILED','adminsas','Y','2025-01-10 01:57:06'),(169,'2025-01-10 08:57:56','139.192.158.103','LOGIN','FAILED','adminsas','Y','2025-01-10 01:57:56'),(170,'2025-01-10 08:58:05','139.192.158.103','LOGIN','FAILED','adminsas','Y','2025-01-10 01:58:05'),(171,'2025-01-10 09:05:21','139.192.158.103','LOGIN','SUCCESS','fajriganteng','Y','2025-01-10 02:05:21'),(172,'2025-01-10 09:41:26','149.108.29.197','LOGIN','SUCCESS','admin','Y','2025-01-10 02:41:26'),(173,'2025-01-10 16:07:57','149.108.29.197','LOGIN','SUCCESS','admin','Y','2025-01-10 09:07:57'),(174,'2025-01-13 09:30:50','149.113.117.43','LOGIN','SUCCESS','admin','Y','2025-01-13 02:30:50'),(175,'2025-01-14 08:12:53','139.195.123.79','LOGIN','SUCCESS','adminsas','Y','2025-01-14 01:12:53'),(176,'2025-01-14 08:16:15','139.195.123.79','LOGIN','FAILED','admin','Y','2025-01-14 01:16:15'),(177,'2025-01-14 08:16:26','139.195.123.79','LOGIN','FAILED','admin','Y','2025-01-14 01:16:26'),(178,'2025-01-14 08:16:36','139.195.123.79','LOGIN','SUCCESS','adminsas','Y','2025-01-14 01:16:36'),(179,'2025-01-14 08:25:49','139.195.123.79','LOGIN','FAILED','adminmatraman','Y','2025-01-14 01:25:49'),(180,'2025-01-14 08:26:06','139.195.123.79','LOGIN','FAILED','adminmatraman','Y','2025-01-14 01:26:06'),(181,'2025-01-14 08:26:08','139.195.123.79','LOGIN','FAILED','adminmatraman','Y','2025-01-14 01:26:08'),(182,'2025-01-14 08:27:00','139.195.123.79','LOGIN','FAILED','adminsas','Y','2025-01-14 01:27:00'),(183,'2025-01-14 08:27:07','139.195.123.79','LOGIN','FAILED','adminsas','Y','2025-01-14 01:27:07'),(184,'2025-01-14 08:48:19','139.195.123.79','LOGIN','FAILED','adminsas','Y','2025-01-14 01:48:19'),(185,'2025-01-14 08:48:24','139.195.123.79','LOGIN','FAILED','adminsas','Y','2025-01-14 01:48:24'),(186,'2025-01-14 08:48:27','139.195.123.79','LOGIN','FAILED','adminsas','Y','2025-01-14 01:48:27'),(187,'2025-01-14 08:48:33','139.195.123.79','LOGIN','FAILED','adminsas','Y','2025-01-14 01:48:33'),(188,'2025-01-14 08:48:40','139.195.123.79','LOGIN','SUCCESS','adminsas','Y','2025-01-14 01:48:40'),(189,'2025-01-14 08:49:30','139.195.123.79','LOGIN','FAILED','adminbonjer','Y','2025-01-14 01:49:30'),(190,'2025-01-14 08:49:50','139.195.123.79','LOGIN','FAILED','adminjkt','Y','2025-01-14 01:49:50'),(191,'2025-01-14 08:51:26','139.195.123.79','LOGIN','FAILED','adminjkt','Y','2025-01-14 01:51:26'),(192,'2025-01-14 08:51:44','139.195.123.79','LOGIN','FAILED','adminjkt','Y','2025-01-14 01:51:44'),(193,'2025-01-14 08:52:05','139.195.123.79','LOGIN','FAILED','adminjkt','Y','2025-01-14 01:52:05'),(194,'2025-01-14 08:52:20','139.195.123.79','LOGIN','FAILED','adminjkt','Y','2025-01-14 01:52:20'),(195,'2025-01-14 08:52:40','139.195.123.79','LOGIN','FAILED','adminsamanhudi','Y','2025-01-14 01:52:40'),(196,'2025-01-14 08:53:23','139.195.123.79','LOGIN','SUCCESS','adminsas','Y','2025-01-14 01:53:23'),(197,'2025-01-14 08:55:05','139.195.123.79','LOGIN','FAILED','admsamanhudi','Y','2025-01-14 01:55:05'),(198,'2025-01-14 08:55:12','139.195.123.79','LOGIN','SUCCESS','admsamanhudi','Y','2025-01-14 01:55:12'),(199,'2025-01-14 08:55:55','139.195.123.79','LOGIN','SUCCESS','admmatraman','Y','2025-01-14 01:55:55'),(200,'2025-01-14 08:56:42','139.195.123.79','LOGIN','SUCCESS','admmatraman','Y','2025-01-14 01:56:42'),(201,'2025-01-14 08:56:54','139.195.123.79','LOGIN','SUCCESS','adminsas','Y','2025-01-14 01:56:54'),(202,'2025-01-14 09:00:06','139.195.123.79','LOGIN','SUCCESS','admbonjer','Y','2025-01-14 02:00:06'),(203,'2025-01-14 09:00:18','139.195.123.79','LOGIN','SUCCESS','adminsas','Y','2025-01-14 02:00:18'),(204,'2025-01-14 09:58:55','139.195.123.79','LOGIN','SUCCESS','cobabranch','Y','2025-01-14 02:58:55'),(205,'2025-01-14 13:42:43','139.195.123.79','LOGIN','SUCCESS','adminsas','Y','2025-01-14 06:42:43'),(206,'2025-01-15 15:13:22','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-15 08:13:22'),(207,'2025-01-15 15:16:05','139.0.104.99','LOGIN','FAILED','admmatraman ','Y','2025-01-15 08:16:05'),(208,'2025-01-15 15:16:16','139.0.104.99','LOGIN','FAILED','admmatraman ','Y','2025-01-15 08:16:16'),(209,'2025-01-15 15:16:19','139.0.104.99','LOGIN','FAILED','admmatraman ','Y','2025-01-15 08:16:19'),(210,'2025-01-15 15:16:20','139.0.104.99','LOGIN','FAILED','admmatraman ','Y','2025-01-15 08:16:20'),(211,'2025-01-15 15:16:42','139.0.104.99','LOGIN','FAILED','admmatraman ','Y','2025-01-15 08:16:42'),(212,'2025-01-15 15:16:47','139.0.104.99','LOGIN','SUCCESS','admmatraman ','Y','2025-01-15 08:16:47'),(213,'2025-01-15 16:05:13','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-15 09:05:13'),(214,'2025-01-15 16:07:26','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-15 09:07:26'),(215,'2025-01-15 16:45:58','139.0.104.99','LOGIN','SUCCESS','admmatraman','Y','2025-01-15 09:45:58'),(216,'2025-01-15 16:48:47','139.0.104.99','LOGIN','SUCCESS','admbonjer','Y','2025-01-15 09:48:47'),(217,'2025-01-15 16:49:44','139.0.104.99','LOGIN','SUCCESS','admsamanhudi','Y','2025-01-15 09:49:44'),(218,'2025-01-15 16:53:55','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-15 09:53:55'),(219,'2025-01-15 16:59:09','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-15 09:59:09'),(220,'2025-01-15 17:04:18','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-15 10:04:18'),(221,'2025-01-15 17:05:01','139.0.104.99','LOGIN','SUCCESS','admbonjer','Y','2025-01-15 10:05:01'),(222,'2025-01-15 18:03:24','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-15 11:03:24'),(223,'2025-01-15 18:03:58','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-15 11:03:58'),(224,'2025-01-15 18:45:49','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-15 11:45:49'),(225,'2025-01-15 18:51:22','139.0.104.99','LOGIN','SUCCESS','admmatraman','Y','2025-01-15 11:51:22'),(226,'2025-01-15 18:53:14','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-15 11:53:14'),(227,'2025-01-15 18:53:57','139.0.104.99','LOGIN','SUCCESS','admbandungraya','Y','2025-01-15 11:53:57'),(228,'2025-01-15 19:31:30','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-15 12:31:30'),(229,'2025-01-15 19:31:47','139.0.104.99','LOGIN','SUCCESS','adminsas','Y','2025-01-15 12:31:47'),(230,'2025-01-15 19:32:18','139.0.104.99','LOGIN','SUCCESS','admmatraman','Y','2025-01-15 12:32:18'),(231,'2025-01-15 19:42:14','139.0.104.99','LOGIN','FAILED','admbandungraya','Y','2025-01-15 12:42:14'),(232,'2025-01-15 19:42:18','139.0.104.99','LOGIN','SUCCESS','admbandungraya','Y','2025-01-15 12:42:18'),(233,'2025-01-16 08:55:05','139.0.104.99','LOGIN','FAILED','cobabranch','Y','2025-01-16 01:55:05'),(234,'2025-01-16 08:55:06','139.0.104.99','LOGIN','FAILED','cobabranch','Y','2025-01-16 01:55:06'),(235,'2025-01-16 08:55:06','139.0.104.99','LOGIN','FAILED','cobabranch','Y','2025-01-16 01:55:06'),(236,'2025-01-16 08:55:19','139.0.104.99','LOGIN','SUCCESS','cobabranch','Y','2025-01-16 01:55:19'),(237,'2025-01-16 14:25:22','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-16 07:25:22'),(238,'2025-01-16 15:59:51','139.0.104.99','LOGIN','SUCCESS','adminsas','Y','2025-01-16 08:59:51'),(239,'2025-01-16 16:41:32','139.0.104.99','LOGIN','SUCCESS','adminsas','Y','2025-01-16 09:41:32'),(240,'2025-01-16 16:49:29','139.0.104.99','LOGIN','SUCCESS','adminsas','Y','2025-01-16 09:49:29'),(241,'2025-01-17 09:38:09','139.0.104.99','LOGIN','SUCCESS','cobabranch','Y','2025-01-17 02:38:09'),(242,'2025-01-17 10:15:40','139.0.104.99','LOGIN','SUCCESS','admmatraman','Y','2025-01-17 03:15:40'),(243,'2025-01-17 10:36:37','139.0.104.99','LOGIN','FAILED','adminsas','Y','2025-01-17 03:36:37'),(244,'2025-01-17 10:36:51','139.0.104.99','LOGIN','SUCCESS','adminsas','Y','2025-01-17 03:36:51'),(245,'2025-01-17 14:11:00','139.0.104.99','LOGIN','SUCCESS','admmatraman','Y','2025-01-17 07:11:00'),(246,'2025-01-17 14:16:11','139.0.104.99','LOGIN','SUCCESS','admjkt','Y','2025-01-17 07:16:11');
/*!40000 ALTER TABLE `log_login` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `unitconvert_log`
--

DROP TABLE IF EXISTS `unitconvert_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unitconvert_log` (
  `UnitConvertLogID` int(11) NOT NULL AUTO_INCREMENT,
  `UnitConvertLogStatus` varchar(15) DEFAULT NULL,
  `UnitConvertLogUnitConvertID` int(11) DEFAULT NULL,
  `UnitConvertLogJSONBefore` text DEFAULT NULL,
  `UnitConvertLogJSONAfter` text DEFAULT NULL,
  `UnitConvertLogUserID` int(11) DEFAULT NULL,
  `UnitConvertLogCreated` datetime NOT NULL,
  PRIMARY KEY (`UnitConvertLogID`),
  KEY `UnitConvertLogUnitConvertID` (`UnitConvertLogUnitConvertID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unitconvert_log`
--

LOCK TABLES `unitconvert_log` WRITE;
/*!40000 ALTER TABLE `unitconvert_log` DISABLE KEYS */;
INSERT INTO `unitconvert_log` VALUES (1,'ADD',3,NULL,'{\"UnitConvertID\":\"3\",\"UnitConvertFromItemUnitID\":\"8\",\"UnitConvertToItemUnitID\":\"7\",\"UnitConvertAmount\":\"100\",\"UnitConvertIsActive\":\"Y\",\"UnitConvertUserID\":\"3\",\"UnitConvertCreated\":\"2024-09-24 15:35:46\",\"UnitConvertLAstUpdated\":\"2024-09-24 15:35:46\"}',3,'2024-09-24 15:35:46'),(2,'EDIT',3,'{\"UnitConvertID\":\"3\",\"UnitConvertFromItemUnitID\":\"8\",\"UnitConvertToItemUnitID\":\"7\",\"UnitConvertAmount\":\"150\",\"UnitConvertIsActive\":\"Y\",\"UnitConvertUserID\":\"3\",\"UnitConvertCreated\":\"2024-09-24 15:35:46\",\"UnitConvertLAstUpdated\":\"2024-09-24 15:36:23\"}','{\"UnitConvertID\":\"3\",\"UnitConvertFromItemUnitID\":\"8\",\"UnitConvertToItemUnitID\":\"7\",\"UnitConvertAmount\":\"150\",\"UnitConvertIsActive\":\"Y\",\"UnitConvertUserID\":\"3\",\"UnitConvertCreated\":\"2024-09-24 15:35:46\",\"UnitConvertLAstUpdated\":\"2024-09-24 15:36:23\"}',3,'2024-09-24 15:36:23'),(3,'ADD',4,NULL,'{\"UnitConvertID\":\"4\",\"UnitConvertFromItemUnitID\":\"2\",\"UnitConvertToItemUnitID\":\"1\",\"UnitConvertAmount\":\"5\",\"UnitConvertIsActive\":\"Y\",\"UnitConvertUserID\":\"3\",\"UnitConvertCreated\":\"2024-09-24 16:50:14\",\"UnitConvertLAstUpdated\":\"2024-09-24 16:50:14\"}',3,'2024-09-24 16:50:14');
/*!40000 ALTER TABLE `unitconvert_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'acc_one_log'
--
/*!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 2025-01-17 15:42:01
