--
-- Host: localhost    Database: noss2142_jk_log
-- ------------------------------------------------------


--
-- Table structure for table `system_access_log`
--

CREATE TABLE `system_access_log` (
  `id` int(11) NOT NULL,
  `sessionid` text DEFAULT NULL,
  `login` text DEFAULT NULL,
  `login_time` datetime DEFAULT NULL,
  `login_year` varchar(4) DEFAULT NULL,
  `login_month` varchar(2) DEFAULT NULL,
  `login_day` varchar(2) DEFAULT NULL,
  `logout_time` datetime DEFAULT NULL,
  `impersonated` char(1) DEFAULT NULL,
  `access_ip` varchar(45) DEFAULT NULL,
  `impersonated_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_access_log`
--

INSERT INTO `system_access_log` (`id`, `sessionid`, `login`, `login_time`, `login_year`, `login_month`, `login_day`, `logout_time`, `impersonated`, `access_ip`, `impersonated_by`) VALUES (1,'67d59fc570e31c95f69958d6136cc125','admin','2026-01-02 15:26:28','2026','01','02','2026-01-26 16:31:49','N','95.92.11.14',NULL),(2,'fb84f3d0529e8f1b2644f4ce19f81d30','admin','2026-01-26 16:31:49','2026','01','26','2026-01-26 16:47:13','N','95.92.11.14',NULL),(3,'9d5e7bcc377f1488005c7f8820f5582f','admin','2026-01-26 16:47:25','2026','01','26','2026-01-26 16:48:22','N','95.92.11.14',NULL),(4,'614f15eeedd94b6a406b82e5a9f5062a','juliana','2026-01-26 16:48:29','2026','01','26','2026-01-26 17:01:33','N','95.92.11.14',NULL),(5,'a8e218a066cdcbb79d36e0a8ba104d67','admin','2026-01-26 17:01:40','2026','01','26','2026-01-26 17:02:14','N','95.92.11.14',NULL),(6,'7d5d83b48914922a193ee1013ff77839','admin','2026-01-26 17:02:46','2026','01','26',NULL,'N','95.92.11.14',NULL);

--
-- Table structure for table `system_access_notification_log`
--

CREATE TABLE `system_access_notification_log` (
  `id` int(11) NOT NULL,
  `login` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `ip_address` text DEFAULT NULL,
  `login_time` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_access_notification_log`
--


--
-- Table structure for table `system_change_log`
--

CREATE TABLE `system_change_log` (
  `id` int(11) NOT NULL,
  `logdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `login` text DEFAULT NULL,
  `tablename` text DEFAULT NULL,
  `primarykey` text DEFAULT NULL,
  `pkvalue` text DEFAULT NULL,
  `operation` text DEFAULT NULL,
  `columnname` text DEFAULT NULL,
  `oldvalue` text DEFAULT NULL,
  `newvalue` text DEFAULT NULL,
  `access_ip` text DEFAULT NULL,
  `transaction_id` text DEFAULT NULL,
  `log_trace` text DEFAULT NULL,
  `session_id` text DEFAULT NULL,
  `class_name` text DEFAULT NULL,
  `php_sapi` text DEFAULT NULL,
  `log_year` varchar(4) DEFAULT NULL,
  `log_month` varchar(2) DEFAULT NULL,
  `log_day` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_change_log`
--


--
-- Table structure for table `system_request_log`
--

CREATE TABLE `system_request_log` (
  `id` int(11) NOT NULL,
  `endpoint` text DEFAULT NULL,
  `logdate` text DEFAULT NULL,
  `log_year` varchar(4) DEFAULT NULL,
  `log_month` varchar(2) DEFAULT NULL,
  `log_day` varchar(2) DEFAULT NULL,
  `session_id` text DEFAULT NULL,
  `login` text DEFAULT NULL,
  `access_ip` text DEFAULT NULL,
  `class_name` text DEFAULT NULL,
  `http_host` text DEFAULT NULL,
  `server_port` text DEFAULT NULL,
  `request_uri` text DEFAULT NULL,
  `request_method` text DEFAULT NULL,
  `query_string` text DEFAULT NULL,
  `request_headers` text DEFAULT NULL,
  `request_body` longtext DEFAULT NULL,
  `request_duration` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_request_log`
--


--
-- Table structure for table `system_sql_log`
--

CREATE TABLE `system_sql_log` (
  `id` int(11) NOT NULL,
  `logdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `login` text DEFAULT NULL,
  `database_name` text DEFAULT NULL,
  `sql_command` longtext DEFAULT NULL,
  `statement_type` text DEFAULT NULL,
  `access_ip` varchar(45) DEFAULT NULL,
  `transaction_id` text DEFAULT NULL,
  `log_trace` text DEFAULT NULL,
  `session_id` text DEFAULT NULL,
  `class_name` text DEFAULT NULL,
  `php_sapi` text DEFAULT NULL,
  `request_id` text DEFAULT NULL,
  `log_year` varchar(4) DEFAULT NULL,
  `log_month` varchar(2) DEFAULT NULL,
  `log_day` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_sql_log`
--



--
-- Dumping events for database 'noss2142_jk_log'
--

--
-- Dumping routines for database 'noss2142_jk_log'
--


