--
-- Host: localhost    Database: noss2142_cdr_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,'4e493b51e2b4a4e77813ec12952c75dd','admin','2025-09-17 10:53:29','2025','09','17',NULL,'N','85.139.144.139',NULL),(2,'30c9da34a27468acb32578fa4a39a452','admin','2025-09-17 11:03:51','2025','09','17','2025-09-17 13:05:34','N','189.45.20.220',NULL),(3,'41fdacd6a5798acad4f2ef282c199dfa','admin','2025-09-17 13:05:38','2025','09','17','2025-09-17 14:00:28','N','189.45.20.220',NULL),(4,'9907f90c86c237c0d0f6427ef2bdc148','admin','2025-09-17 14:00:31','2025','09','17','2025-09-17 15:11:21','N','189.45.20.220',NULL),(5,'7684ac529635daaf4b162f7ebfbc05c5','admin','2025-09-17 15:11:37','2025','09','17','2025-09-17 18:59:05','N','189.45.20.220',NULL),(6,'db3fc033256b79ac6a8fe2fcf1ad98a7','admin','2025-09-17 18:59:08','2025','09','17','2025-09-17 19:57:00','N','189.45.20.220',NULL),(7,'3a0f49f47657e1240b9ca1e016fde4fe','admin','2025-09-17 19:57:08','2025','09','17','2025-09-17 19:57:58','N','189.45.20.220',NULL),(8,'c5be702de970a9b5b7b2e8dd39194c52','admin','2025-09-17 19:58:16','2025','09','17','2025-09-17 20:02:01','N','189.45.20.220',NULL),(9,'609464f58f8baa4bfc4cedebe048b143','admin','2025-09-17 20:02:05','2025','09','17','2025-09-17 20:03:03','N','189.45.20.220',NULL),(10,'7d5b31a393dd97f2c3ab6a1c1c710f3e','user','2025-09-17 20:03:08','2025','09','17','2025-09-17 20:05:01','N','189.45.20.220',NULL),(11,'aeac31136ad69850a67c71821dc40cbe','admin','2025-09-17 20:05:04','2025','09','17','2025-09-17 20:08:34','N','189.45.20.220',NULL),(12,'a4a46862984fe5d5902f3c317b55809f','user','2025-09-17 20:08:41','2025','09','17','2025-09-17 20:08:45','N','189.45.20.220',NULL),(13,'d5c5f65418fbf46caa60b7e7526bc0fb','admin','2025-09-17 20:08:49','2025','09','17',NULL,'N','189.45.20.220',NULL),(14,'c6afc7170958a956f147186f02506f13','admin','2025-09-18 22:56:07','2025','09','18',NULL,'N','189.45.20.220',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_cdr_log'
--

--
-- Dumping routines for database 'noss2142_cdr_log'
--


