--
-- Host: localhost    Database: noss2142_galetobia_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,'7ca1d540fadd95409fe8daa655e73f12','admin','2025-09-05 14:38:49','2025','09','05',NULL,'N','104.28.243.219',NULL),(2,'ebfbee74fefe13a9409281786ea15256','admin','2025-09-05 15:29:56','2025','09','05',NULL,'N','104.28.243.222',NULL),(3,'55a04db2a3a598e27fbbef997c277458','admin','2025-09-05 15:54:11','2025','09','05','2025-09-05 16:00:12','N','85.139.144.139',NULL),(4,'7a71d4345dcef0a0af50b9a706d744aa','fabiola','2025-09-05 16:00:23','2025','09','05','2025-09-05 18:35:29','N','85.139.144.139',NULL),(5,'1acdec1db069147fb87543cb17d7542c','admin','2025-09-05 18:35:41','2025','09','05','2025-09-05 18:37:25','N','85.139.144.139',NULL),(6,'06854c56530367ac87e4380ef396d489','fabiola','2025-09-05 18:37:35','2025','09','05',NULL,'N','85.139.144.139',NULL),(7,'5b6b9888414b11aba0ae479cd2c8103b','fabiola','2025-09-06 03:38:56','2025','09','06',NULL,'N','85.241.185.180',NULL),(8,'6562303a5bb313c174d9f69fbdc4383f','admin','2025-09-09 16:50:56','2025','09','09',NULL,'N','85.139.144.139',NULL),(9,'2bddc5a11db4282979b40ad47fdc279f','admin','2025-09-10 09:57:27','2025','09','10',NULL,'N','85.139.144.139',NULL),(10,'d8777556fede5fd5318ff4b17dd81b1a','fabiola','2025-09-11 13:12:40','2025','09','11',NULL,'N','95.93.246.162',NULL),(11,'b8ca772dcd0855b6d6599de3e0797b99','fabiola','2025-09-11 13:38:44','2025','09','11',NULL,'N','95.93.246.162',NULL),(12,'bfa00f775669a75707a929671da87f6a','fabiola','2025-09-11 14:05:56','2025','09','11','2025-09-11 17:12:54','N','95.93.246.162',NULL),(13,'f4573b0140a769a0c67db46457d8796f','admin','2025-09-11 16:00:00','2025','09','11',NULL,'N','85.139.144.139',NULL),(14,'d8ec9270da3836c90d2208c132f31a31','fabiola','2025-09-11 17:13:30','2025','09','11','2025-09-13 13:50:23','N','95.93.246.162',NULL),(15,'a134a0531c52d33e708324883c5c4092','fabiola','2025-09-13 13:50:40','2025','09','13','2025-09-16 11:31:49','N','95.93.246.162',NULL),(16,'55c87658cbc607c9cbf2cc6780e60821','admin','2025-09-15 14:14:40','2025','09','15','2025-09-15 16:43:21','N','85.139.144.139',NULL),(17,'b3c081cb55d8c60da4f3f4ca08100e6c','admin','2025-09-15 14:28:55','2025','09','15',NULL,'N','189.45.20.220',NULL),(18,'00411b5767352b65bac20ac703189e16','fabiola','2025-09-16 11:32:03','2025','09','16',NULL,'N','95.93.246.162',NULL),(19,'4deea71947e0b99c828528f9c43379b6','fabiola','2025-09-16 11:39:23','2025','09','16',NULL,'N','95.93.246.162',NULL),(20,'50253aa3c58960874115de0a68dc7c7a','fabiola','2025-09-18 12:05:52','2025','09','18','2025-09-18 14:08:20','N','95.93.246.162',NULL),(21,'8cdec0394fa647407853b189fff55983','fabiola','2025-09-18 14:08:50','2025','09','18','2025-09-19 12:57:15','N','95.93.246.162',NULL),(22,'8200829c88b961d611e1dfceecd6f8e4','fabiola','2025-09-19 12:57:29','2025','09','19','2025-09-23 11:58:24','N','95.93.246.162',NULL),(23,'adf7174930a02fc523e981e8aecf0cab','fabiola','2025-09-23 12:01:43','2025','09','23',NULL,'N','95.93.246.162',NULL),(24,'ef3d4e3e436fc061cc5a1feb87566744','fabiola','2025-09-23 13:46:38','2025','09','23','2025-09-23 15:16:23','N','95.93.246.162',NULL),(25,'5162a3a93333111cf8ffe111f58c7d2c','fabiola','2025-09-23 15:17:04','2025','09','23',NULL,'N','95.93.246.162',NULL),(26,'85551b6d3e85ba4747757cd404e9a66f','fabiola','2025-09-23 15:26:42','2025','09','23','2025-09-23 16:27:13','N','95.93.246.162',NULL),(27,'fafcbce883a78cff56d8c91b25b273b0','fabiola','2025-09-23 16:27:44','2025','09','23','2025-09-25 15:16:32','N','95.93.246.162',NULL),(28,'e8f6897fdb523260140665df50b88a06','admin','2025-09-25 10:54:12','2025','09','25',NULL,'N','85.139.144.139',NULL),(29,'a4203c66b0e9b54debc24ece395f015b','fabiola','2025-09-25 15:20:30','2025','09','25','2025-09-26 06:39:32','N','95.93.246.162',NULL),(30,'7da8be8ae8ebe324ea1e398b9a597c45','fabiola','2025-09-26 06:39:59','2025','09','26',NULL,'N','95.93.246.162',NULL),(31,'b971fd6291ff6937b306300b3cea8efe','fabiola','2025-09-27 14:12:09','2025','09','27','2025-09-30 13:58:59','N','95.93.246.162',NULL),(32,'03825e1c21e677f8a4deca454126c1d7','fabiola','2025-09-30 14:28:10','2025','09','30',NULL,'N','95.93.246.162',NULL),(33,'3c8cd159a261e143ad1c2ab9a557810c','fabiola','2025-10-01 14:04:32','2025','10','01','2025-10-02 12:33:31','N','95.93.246.162',NULL),(34,'f8b4dcbf940c52cab1be30854e7b69fb','fabiola','2025-10-02 12:33:46','2025','10','02',NULL,'N','95.93.246.162',NULL),(35,'f00474c041851b8c3f938b283ecda04d','admin','2025-10-06 13:04:27','2025','10','06',NULL,'N','85.139.144.139',NULL),(36,'1615eb072d60ef5891ddc6ad621228a0','fabiola','2025-10-10 13:36:36','2025','10','10',NULL,'N','95.93.246.162',NULL),(37,'142ee16f4c71f74a21060f283904c1ec','admin','2025-10-10 17:04:51','2025','10','10',NULL,'N','85.139.144.139',NULL),(38,'cd696cdbafc0526528db5c2790c13a99','admin','2025-10-13 11:33:35','2025','10','13',NULL,'N','85.139.144.139',NULL),(39,'14fff47c4dafc0656c446891f7089975','fabiola','2025-10-14 15:01:16','2025','10','14',NULL,'N','95.93.214.215',NULL),(40,'af61c8991191570a53750a7220126aac','admin','2025-10-15 12:55:08','2025','10','15',NULL,'N','200.233.82.114',NULL),(41,'cf0e447c0a3325311aaa650e016c24b9','admin','2025-10-15 13:59:08','2025','10','15','2025-10-15 16:18:13','N','85.139.144.139',NULL),(42,'079498a177e5d6d6910cc25342dfdfef','fabiola','2025-10-15 14:23:42','2025','10','15','2025-10-16 13:48:41','N','95.93.214.215',NULL),(43,'7522a71088d0815e6e39aa6211cf330d','admin','2025-10-15 16:18:23','2025','10','15','2025-10-15 17:20:59','N','85.139.144.139',NULL),(44,'34d86fbc9054fe9538c1bca06c7ff058','admin','2025-10-15 17:04:55','2025','10','15',NULL,'N','200.233.82.114',NULL),(45,'407f6d94b4a331f4cdedde9a8b1d70d1','admin','2025-10-15 17:21:06','2025','10','15','2025-10-15 18:27:51','N','85.139.144.139',NULL),(46,'668f4b200ff538cdfb50a846a9b7e01a','admin','2025-10-15 18:28:00','2025','10','15','2025-10-15 18:53:51','N','85.139.144.139',NULL),(47,'974088365e25c969944722bcd43bea27','admin','2025-10-15 18:54:07','2025','10','15',NULL,'N','85.139.144.139',NULL),(48,'2d881bed1938cc498d21cd2e13dd507e','admin','2025-10-16 09:01:20','2025','10','16',NULL,'N','200.233.82.114',NULL),(49,'2bdd53e3aafc2a85f6538a4eaeb45237','admin','2025-10-16 13:44:32','2025','10','16','2025-10-16 15:15:13','N','85.139.144.139',NULL),(50,'367c08c387627107627f126126ff3626','fabiola','2025-10-16 13:49:08','2025','10','16','2025-10-16 15:57:44','N','95.93.214.215',NULL),(51,'da1620cd0af5262ef0f4f45e6c1a9b0f','admin','2025-10-16 15:15:19','2025','10','16','2025-10-16 18:08:52','N','85.139.144.139',NULL),(52,'963370176fc1ee7e584f7cf9b482edb3','fabiola','2025-10-16 15:58:13','2025','10','16','2025-10-17 06:15:15','N','95.93.214.215',NULL),(53,'f589fbbe0332584c57d1dd4ee5a87eac','admin','2025-10-16 18:09:01','2025','10','16',NULL,'N','85.139.144.139',NULL),(54,'f85851a8c87fed16aac3e5e0525ab190','fabiola','2025-10-17 06:15:27','2025','10','17','2025-10-17 13:06:14','N','95.93.214.215',NULL),(55,'81d04962753fcbe07fd6401cbb084b0d','admin','2025-10-17 10:57:14','2025','10','17',NULL,'N','85.139.144.139',NULL),(56,'33146651a60e1305f252c77896d1399c','fabiola','2025-10-17 13:06:38','2025','10','17',NULL,'N','95.93.214.215',NULL),(57,'c2f344f1ceeda8314e13f3a1577d5762','admin','2025-10-17 15:13:33','2025','10','17','2025-10-17 16:01:40','N','85.139.144.139',NULL),(58,'b7f7daa6d1e1ba3bc55301ba80c4c16e','admin','2025-10-20 13:45:46','2025','10','20',NULL,'N','85.139.144.139',NULL),(59,'8a3214fd1d7a6c4c8119628497a5246e','admin','2025-10-22 09:34:33','2025','10','22',NULL,'N','85.139.144.139',NULL),(60,'3212b7f2baf816ac1fb6160140782b08','admin','2025-10-29 19:50:57','2025','10','29',NULL,'N','85.139.144.139',NULL),(61,'e0516db13d345df68d2d515d36e92cb8','fabiola','2025-10-30 16:14:11','2025','10','30',NULL,'N','95.93.222.150',NULL),(62,'16d1aab35170210e91621f0b0a9e2962','admin','2025-11-04 17:53:29','2025','11','04',NULL,'N','85.139.144.139',NULL),(63,'368775937bc9340cd7001ba3b75929f0','admin','2025-11-04 17:57:51','2025','11','04',NULL,'N','186.193.109.119',NULL),(64,'f6f15c64b3b608e86e31acb4a0aa3152','admin','2025-11-10 11:58:48','2025','11','10',NULL,'N','85.139.144.139',NULL),(65,'32e5a27933357dd9e965d6f705712bf5','admin','2025-11-14 18:39:14','2025','11','14',NULL,'N','85.139.144.139',NULL),(66,'7fb638c3030311f2073901c68d9eaebe','admin','2025-11-17 15:50:29','2025','11','17','2025-11-17 16:37:22','N','85.139.144.139',NULL),(67,'e624ff7763f3abdc691bf9eb5ae01068','admin','2025-11-17 16:37:29','2025','11','17',NULL,'N','85.139.144.139',NULL),(68,'a0488ce703a7ecda5ce95d6016c43992','admin','2025-11-20 11:13:22','2025','11','20',NULL,'N','85.139.144.139',NULL),(69,'8804ab49701c5ab3b02a225d2dadedfc','admin','2026-01-05 15:40:50','2026','01','05',NULL,'N','95.92.11.14',NULL),(70,'676354bd5a8c5f962ea78f994c75c981','admin','2026-01-21 14:42:48','2026','01','21',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_galetobia_log'
--

--
-- Dumping routines for database 'noss2142_galetobia_log'
--


