--
-- Host: localhost    Database: noss2142_classic_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,'9ece7b2113f888fea2fd356e0897d247','admin','2025-12-31 10:55:33','2025','12','31','2026-01-02 14:34:09','N','95.92.11.14',NULL),(2,'effef82283f2af084fdb776b43f4c8a6','admin','2026-01-02 14:34:08','2026','01','02','2026-01-02 15:37:35','N','95.92.11.14',NULL),(3,'67e5c2c637a2275464cd1bbfecc374f7','admin','2026-01-02 15:37:35','2026','01','02','2026-01-05 17:07:50','N','95.92.11.14',NULL),(4,'43dc10bc1b97c611062dfa2047d24ecd','admin','2026-01-05 17:07:50','2026','01','05','2026-01-06 11:31:02','N','95.92.11.14',NULL),(5,'3c41bab1782d81008455f1d6843da018','admin','2026-01-06 11:31:02','2026','01','06','2026-01-07 16:51:55','N','95.92.11.14',NULL),(6,'b51730b8155ea99004576a91eeff372b','admin','2026-01-07 16:51:55','2026','01','07','2026-01-08 13:47:13','N','95.92.11.14',NULL),(7,'b5a33210eb7cf3afbdbab03878cba094','admin','2026-01-08 13:47:13','2026','01','08','2026-01-08 16:32:04','N','95.92.11.14',NULL),(8,'17ac627d56dadf7da713d44eb771613b','admin','2026-01-08 16:32:12','2026','01','08','2026-01-09 11:35:18','N','95.92.11.14',NULL),(9,'6572307ca503c94be014cbba930f7bdb','admin','2026-01-09 11:35:18','2026','01','09','2026-01-15 16:14:22','N','95.92.11.14',NULL),(10,'950522178ff7f21bf1172224a14e9db7','admin','2026-01-15 16:14:22','2026','01','15','2026-01-20 14:46:57','N','95.92.11.14',NULL),(11,'5f51296c6f1446efd00858826462e73d','admin','2026-01-20 14:46:57','2026','01','20','2026-01-21 14:27:05','N','95.92.11.14',NULL),(12,'b049d20312fcc5f277e8c4ae0c11eb5d','admin','2026-01-21 14:27:05','2026','01','21','2026-01-21 14:36:11','N','187.86.101.168',NULL),(13,'c753bd6c4828ce3a9ca2a30179999cab','admin','2026-01-21 14:36:15','2026','01','21','2026-01-21 14:43:35','N','187.86.101.168',NULL),(14,'43ec238a813a3b1096365cba4acdadde','admin','2026-01-21 14:43:38','2026','01','21','2026-01-21 14:44:42','N','187.86.101.168',NULL),(15,'e59c0da414672ef281b82df3caaeab94','user','2026-01-21 14:44:35','2026','01','21','2026-01-21 14:44:38','Y','187.86.101.168','admin'),(16,'5dc0e0609fe2482346dbb401d305242b','admin','2026-01-21 14:44:42','2026','01','21','2026-01-21 15:55:22','N','187.86.101.168',NULL),(17,'f4754c3b6b8bc1676efa37c3ba60e180','admin','2026-01-21 15:55:22','2026','01','21','2026-01-22 11:43:31','N','179.42.57.198',NULL),(18,'18ee61adbfa86320526d25cc21843505','admin','2026-01-22 11:43:31','2026','01','22','2026-01-22 13:04:25','N','95.92.11.14',NULL),(19,'f8c84699d2a7712608373bd1a8dbbc86','admin','2026-01-22 13:04:25','2026','01','22',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_classic_log'
--

--
-- Dumping routines for database 'noss2142_classic_log'
--


