-- MySQL dump 10.13  Distrib 8.0.44, for Linux (x86_64)
--
-- Host: localhost    Database: onlineapplication
-- ------------------------------------------------------
-- Server version	8.0.44-0ubuntu0.22.04.1

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

DROP TABLE IF EXISTS `access_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `access_log` (
  `access_log_id` int NOT NULL AUTO_INCREMENT,
  `access_log_pk` int NOT NULL,
  `access_log_ip` varchar(255) NOT NULL,
  `access_log_activity` varchar(255) NOT NULL,
  `access_log_loginas` varchar(255) DEFAULT NULL,
  `access_log_time` datetime NOT NULL,
  PRIMARY KEY (`access_log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `access_log`
--

LOCK TABLES `access_log` WRITE;
/*!40000 ALTER TABLE `access_log` DISABLE KEYS */;
INSERT INTO `access_log` VALUES (1,1,'192.168.43.127','Login','','2024-05-29 15:19:21'),(2,1,'192.168.43.127','Logout','','2024-05-29 15:21:30'),(3,1,'192.168.43.127','Login','','2024-05-29 15:37:22'),(4,1,'203.131.209.86','Login','','2024-11-14 17:00:01'),(5,1,'192.168.41.109','Login','','2025-01-10 13:37:53'),(6,1,'192.168.41.242','Login','','2025-03-04 14:52:43'),(7,1,'192.168.41.242','SessionTimeOut','','2025-03-05 09:51:05'),(8,1,'192.168.41.242','Login','','2025-03-05 09:51:10'),(9,1,'192.168.41.242','SessionTimeOut','','2025-03-05 13:21:37'),(10,1,'192.168.41.242','Login','','2025-03-05 13:21:42'),(11,1,'192.168.41.242','SessionTimeOut','','2025-03-06 10:00:50'),(12,1,'192.168.41.242','Login','','2025-03-06 10:01:13'),(13,1,'192.168.41.242','Logout','','2025-03-06 10:01:23'),(14,1,'192.168.41.242','Login','','2025-03-06 10:02:12'),(15,1,'203.131.209.86','SessionTimeOut','','2025-03-06 14:42:08'),(16,1,'203.131.209.86','Login','','2025-03-06 14:44:06'),(17,1,'192.168.41.242','Logout','','2025-03-06 16:34:38'),(18,1,'192.168.41.242','Login','','2025-03-06 16:34:45'),(19,1,'192.168.41.242','SessionTimeOut','','2025-03-07 09:58:42'),(20,1,'192.168.41.242','Login','','2025-03-07 09:59:00'),(21,1,'192.168.41.242','Logout','','2025-03-07 10:18:45'),(22,1,'192.168.41.242','Login','','2025-03-07 10:19:00'),(23,1,'192.168.42.19','Login','','2025-03-10 09:50:40'),(24,1,'192.168.42.19','SessionTimeOut','','2025-03-10 15:07:51'),(25,1,'192.168.42.19','Login','','2025-03-10 15:07:56'),(26,1,'192.168.42.39','Login','','2025-03-11 10:04:33'),(27,1,'192.168.42.39','Logout','','2025-03-11 14:49:33'),(28,1,'192.168.42.39','Login','','2025-03-11 14:52:33'),(29,1,'192.168.42.39','Logout','','2025-03-11 14:52:46'),(30,2,'192.168.42.39','Login','','2025-03-11 16:56:05'),(31,2,'192.168.42.39','Logout','','2025-03-11 16:56:22'),(32,1,'192.168.42.39','Login','','2025-03-11 16:56:27'),(33,1,'192.168.42.39','Logout','','2025-03-11 17:19:02'),(34,1,'192.168.42.39','Login','','2025-03-12 10:18:06'),(35,1,'192.168.42.39','SessionTimeOut','','2025-03-12 13:42:24'),(36,1,'192.168.42.39','Login','','2025-03-12 13:43:01'),(37,1,'192.168.42.39','Logout','','2025-03-12 13:50:54'),(38,1,'192.168.42.39','Login','','2025-03-12 14:41:11'),(39,1,'192.168.42.210','Login','','2025-03-17 10:20:25'),(40,1,'192.168.42.210','Logout','','2025-03-17 11:04:24'),(41,2,'192.168.42.210','Login','','2025-03-17 11:04:30'),(42,2,'192.168.42.210','Logout','','2025-03-17 11:09:38'),(43,1,'192.168.42.210','Login','','2025-03-17 11:09:43'),(44,1,'192.168.42.210','LoginAsGo','1','2025-03-17 11:15:12'),(45,1,'192.168.42.210','LoginAsBack','1','2025-03-17 11:15:15'),(46,1,'192.168.42.210','LoginAsGo','1','2025-03-17 11:15:32'),(47,1,'192.168.42.210','LoginAsBack','1','2025-03-17 11:19:43'),(48,1,'192.168.42.210','Logout','','2025-03-17 11:19:44'),(49,1,'192.168.42.210','Login','','2025-03-17 11:19:48'),(50,1,'192.168.42.210','LoginAsGo','2','2025-03-17 11:20:05'),(51,1,'192.168.42.210','LoginAsBack','2','2025-03-17 11:26:01'),(52,1,'192.168.42.210','Logout','','2025-03-17 11:26:48'),(53,1,'192.168.42.210','Login','','2025-03-17 11:28:04'),(54,1,'192.168.42.210','Logout','','2025-03-17 11:28:44'),(55,2,'192.168.42.210','Login','','2025-03-17 11:50:04'),(56,1,'192.168.2.215','Login','','2025-03-17 12:15:56'),(57,2,'192.168.42.210','SessionTimeOut','','2025-03-17 14:11:09'),(58,2,'192.168.42.210','Login','','2025-03-17 14:11:27'),(59,2,'192.168.42.210','Logout','','2025-03-17 14:30:40'),(60,1,'192.168.42.210','Login','','2025-03-17 14:31:55'),(61,1,'192.168.42.210','LoginAsGo','2','2025-03-17 14:32:21'),(62,1,'192.168.42.210','LoginAsBack','2','2025-03-17 15:45:24'),(63,1,'192.168.42.210','Logout','','2025-03-17 15:45:25'),(64,1,'192.168.42.210','Login','','2025-03-17 15:59:16'),(65,1,'192.168.42.210','Logout','','2025-03-17 15:59:19'),(66,1,'192.168.42.210','Login','','2025-03-17 15:59:26'),(67,1,'192.168.2.215','SessionTimeOut','','2025-03-17 16:35:47'),(68,1,'192.168.2.215','Login','','2025-03-17 16:35:55'),(69,1,'192.168.42.210','SessionTimeOut','','2025-03-19 14:13:59'),(70,1,'192.168.42.210','Login','','2025-03-19 14:19:08'),(71,1,'172.16.5.223','Login','','2025-03-21 14:53:26'),(72,1,'203.131.209.86','SessionTimeOut','','2025-03-24 10:05:56'),(73,1,'192.168.43.9','Login','','2025-03-24 10:28:22'),(74,1,'192.168.43.9','SessionTimeOut','','2025-04-08 15:24:21'),(75,1,'203.131.209.86','Login','','2025-04-24 18:28:18'),(76,1,'192.168.43.192','Login','','2025-04-25 18:40:33'),(77,1,'192.168.43.192','SessionTimeOut','','2025-04-26 16:14:39'),(78,1,'192.168.43.192','Login','','2025-04-30 20:17:29'),(79,1,'192.168.43.192','SessionTimeOut','','2025-05-01 09:20:26'),(80,1,'203.131.209.86','SessionTimeOut','','2025-08-05 15:53:47'),(81,1,'172.16.1.198','Login','','2025-08-07 10:12:50'),(82,1,'172.16.1.198','Logout','','2025-08-07 10:14:01'),(83,1,'49.229.124.175','Login','','2025-08-07 14:30:54'),(84,1,'49.229.124.175','Logout','','2025-08-07 14:31:50'),(85,1,'49.229.126.234','Login','','2025-08-08 09:55:45'),(86,1,'49.229.126.234','SessionTimeOut','','2025-08-08 13:22:02'),(87,1,'49.229.126.234','Login','','2025-08-08 13:22:09'),(88,1,'49.229.126.234','SessionTimeOut','','2025-08-08 13:26:21'),(89,1,'192.168.2.251','Login','','2025-09-24 10:01:25'),(90,1,'192.168.2.251','SessionTimeOut','','2025-09-25 11:08:59'),(91,1,'192.168.2.251','Login','','2025-09-25 16:18:12'),(92,1,'192.168.2.251','Logout','','2025-09-25 16:18:26'),(93,1,'192.168.2.251','Login','','2025-09-25 16:18:35'),(94,1,'192.168.3.180','Login','','2025-09-25 16:21:04'),(95,1,'192.168.3.180','Logout','','2025-09-25 16:25:27'),(96,1,'192.168.3.180','Login','','2025-09-25 16:25:31'),(97,1,'192.168.3.180','SessionTimeOut','','2025-09-26 09:52:57'),(98,1,'192.168.3.180','Login','','2025-09-26 13:28:49'),(99,1,'192.168.3.180','SessionTimeOut','','2025-09-29 11:14:04'),(100,1,'192.168.3.180','Login','','2025-09-29 11:14:08'),(101,1,'192.168.3.180','SessionTimeOut','','2025-09-29 13:24:16'),(102,1,'192.168.3.180','Login','','2025-09-29 13:26:02'),(103,1,'192.168.3.180','SessionTimeOut','','2025-09-30 10:15:54'),(104,1,'192.168.3.180','Login','','2025-09-30 10:16:54'),(105,1,'192.168.2.141','Login','','2025-10-14 10:06:54'),(106,1,'192.168.2.141','SessionTimeOut','','2025-10-14 10:34:18'),(107,1,'192.168.2.141','Login','','2025-10-14 10:34:23'),(108,1,'192.168.2.251','SessionTimeOut','','2025-10-14 14:24:37'),(109,1,'192.168.2.251','Login','','2025-10-14 14:24:43'),(110,1,'192.168.2.141','SessionTimeOut','','2025-10-15 10:11:15'),(111,1,'192.168.2.141','Login','','2025-10-15 10:11:18'),(112,1,'192.168.2.141','SessionTimeOut','','2025-10-16 10:21:13'),(113,1,'192.168.2.141','Login','','2025-10-16 10:21:27'),(114,1,'192.168.2.141','SessionTimeOut','','2025-10-16 13:51:55'),(115,1,'192.168.2.141','Login','','2025-10-17 13:09:57'),(116,1,'192.168.2.251','SessionTimeOut','','2025-10-17 13:43:08'),(117,1,'192.168.2.141','SessionTimeOut','','2025-10-20 15:14:51'),(118,1,'172.16.3.115','Login','','2025-10-24 10:56:55'),(119,1,'49.229.124.223','Login','','2025-10-24 11:31:57'),(120,1,'49.229.125.216','Login','','2025-10-27 10:05:13'),(121,1,'172.16.3.115','SessionTimeOut','','2025-10-27 10:43:12'),(122,1,'172.16.3.115','Login','','2025-10-27 10:51:13'),(123,1,'192.168.2.205','Login','','2025-10-28 10:06:22'),(124,1,'192.168.2.205','Logout','','2025-10-28 10:15:38'),(125,1,'192.168.2.205','Login','','2025-10-28 10:15:42'),(126,1,'192.168.2.87','Login','','2025-10-28 10:41:30'),(127,1,'192.168.2.87','SessionTimeOut','','2025-10-28 13:39:03'),(128,1,'192.168.2.87','Login','','2025-10-28 13:47:50'),(129,1,'192.168.2.205','SessionTimeOut','','2025-10-28 14:44:23'),(130,1,'192.168.2.205','Login','','2025-10-28 14:45:15'),(131,1,'192.168.2.205','SessionTimeOut','','2025-10-28 17:24:52'),(132,1,'192.168.2.87','SessionTimeOut','','2025-10-29 14:45:58'),(133,1,'192.168.2.87','Login','','2025-10-29 15:11:02'),(134,1,'49.229.125.65','Login','','2025-10-30 10:27:54'),(135,1,'49.229.124.200','Login','','2025-10-30 13:41:15'),(136,1,'49.229.124.200','Logout','','2025-10-30 13:46:13'),(137,1,'49.229.124.200','Login','','2025-10-30 13:46:20'),(138,1,'49.229.124.33','Login','','2025-11-03 10:19:55'),(139,1,'49.229.127.241','Login','','2025-11-07 10:06:51'),(140,1,'49.229.125.175','Login','','2025-11-11 14:25:52'),(141,1,'49.229.127.87','Login','','2025-11-12 10:20:56'),(142,1,'49.229.126.209','Login','','2025-11-14 13:21:32'),(143,1,'49.229.126.5','Login','','2025-11-17 14:48:10'),(144,1,'183.88.238.30','Login','','2025-11-19 15:56:00'),(145,1,'49.229.125.80','Login','','2025-11-19 16:56:08'),(146,1,'49.229.126.194','Login','','2025-11-20 10:07:18'),(147,1,'49.229.126.194','SessionTimeOut','','2025-11-20 10:33:54'),(148,1,'49.229.126.194','Login','','2025-11-20 10:34:12'),(149,1,'49.229.126.194','SessionTimeOut','','2025-11-20 11:51:55'),(150,1,'49.229.126.194','Login','','2025-11-20 14:10:25'),(151,1,'49.229.126.4','Login','','2025-11-24 14:23:44'),(152,1,'203.131.209.86','Logout','','2025-11-24 15:02:32'),(153,1,'203.131.209.86','Login','','2025-11-24 15:05:02'),(154,1,'192.168.3.64','Login','','2025-11-25 10:09:53'),(155,1,'192.168.3.64','SessionTimeOut','','2025-11-25 13:33:33'),(156,1,'192.168.3.64','Login','','2025-11-25 13:33:38'),(157,1,'192.168.3.64','Logout','','2025-11-25 15:49:41'),(158,1,'192.168.3.64','Login','','2025-11-25 15:52:52'),(159,1,'182.232.60.193','Login','','2025-11-25 15:56:00'),(160,1,'49.229.127.45','Login','','2025-11-26 10:04:49'),(161,1,'49.229.124.210','Login','','2025-11-27 09:59:48'),(162,1,'203.131.209.86','Logout','','2025-11-27 12:39:32'),(163,1,'203.131.209.86','Login','','2025-11-27 12:40:49'),(164,1,'203.131.209.86','Login','','2025-11-27 13:16:54'),(165,1,'49.229.124.210','SessionTimeOut','','2025-11-27 15:24:13'),(166,1,'49.229.124.210','Login','','2025-11-27 15:24:18'),(167,1,'183.88.238.30','SessionTimeOut','','2025-11-28 10:42:29'),(168,1,'183.88.238.30','Login','','2025-11-28 10:43:55'),(169,1,'183.88.238.30','SessionTimeOut','','2025-11-28 10:53:25'),(170,1,'183.88.238.30','Login','','2025-11-28 11:07:28'),(171,1,'183.88.238.30','SessionTimeOut','','2025-11-28 11:16:19'),(172,1,'49.229.127.184','Login','','2025-11-28 11:33:03'),(173,1,'49.229.126.170','Login','','2025-12-01 09:51:15'),(174,1,'49.229.126.170','SessionTimeOut','','2025-12-01 10:13:24'),(175,1,'49.229.126.170','Login','','2025-12-01 10:13:28'),(176,1,'49.237.205.235','Login','','2025-12-01 10:43:01'),(177,1,'49.237.205.243','Login','','2025-12-01 10:45:15'),(178,1,'49.237.205.250','Login','','2025-12-01 10:47:36'),(179,1,'49.229.124.93','Login','','2025-12-01 14:50:06'),(180,1,'172.16.2.43','Login','','2025-12-01 16:35:14'),(181,1,'49.229.126.70','Login','','2025-12-02 10:06:04'),(182,1,'172.16.1.107','Login','','2025-12-02 10:24:43'),(183,1,'192.168.3.208','Login','','2025-12-02 11:04:56'),(184,1,'49.229.125.77','Login','','2025-12-02 14:16:05'),(185,1,'172.16.2.0','Login','','2025-12-03 09:52:58'),(186,1,'172.16.2.0','SessionTimeOut','','2025-12-03 13:36:56'),(187,1,'172.16.2.0','Login','','2025-12-03 13:37:00'),(188,1,'192.168.3.208','SessionTimeOut','','2025-12-04 10:16:56'),(189,1,'192.168.3.208','Login','','2025-12-04 10:17:07'),(190,1,'49.229.127.9','Login','','2025-12-04 13:18:19'),(191,1,'172.16.1.79','Login','','2025-12-08 10:40:50'),(192,7,'192.168.2.235','Login','','2025-12-08 13:31:12'),(193,7,'192.168.2.235','Logout','','2025-12-08 13:31:52'),(194,7,'192.168.2.235','Login','','2025-12-08 13:33:16'),(195,7,'192.168.2.235','SessionTimeOut','','2025-12-08 14:31:32'),(196,8,'192.168.2.235','Login','','2025-12-08 14:31:58'),(197,8,'192.168.2.235','Logout','','2025-12-08 17:05:29'),(198,10,'192.168.2.235','Login','','2025-12-08 17:06:10'),(199,10,'192.168.2.235','Logout','','2025-12-08 17:07:31'),(200,8,'192.168.2.235','Login','','2025-12-08 17:07:46'),(201,8,'192.168.2.235','SessionTimeOut','','2025-12-09 10:05:11'),(202,1,'192.168.2.235','Login','','2025-12-09 10:05:28'),(203,1,'192.168.2.235','SessionTimeOut','','2025-12-09 10:09:58'),(204,8,'192.168.2.235','Login','','2025-12-09 10:11:31'),(205,8,'192.168.2.235','SessionTimeOut','','2025-12-09 16:20:36'),(206,1,'172.16.4.168','Login','','2025-12-15 13:29:22'),(207,1,'172.16.4.168','SessionTimeOut','','2025-12-15 13:31:31'),(208,8,'172.16.4.168','Login','','2025-12-15 13:33:27'),(209,1,'172.16.1.58','Login','','2025-12-16 10:49:42'),(210,1,'172.16.1.58','Logout','','2025-12-16 10:50:01'),(211,1,'172.16.1.58','Login','','2025-12-16 10:50:09'),(212,1,'172.16.1.58','Logout','','2025-12-16 10:50:49'),(213,8,'172.16.1.58','Login','','2025-12-16 10:51:01');
/*!40000 ALTER TABLE `access_log` 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 2025-12-18  3:29:22
