-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jul 24, 2022 at 05:42 PM -- Server version: 10.4.24-MariaDB -- PHP Version: 8.0.19 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `laravel9_easyradius` -- -- -------------------------------------------------------- -- -- Table structure for table `uservisitedlogs` -- CREATE TABLE `uservisitedlogs` ( `id` int(10) UNSIGNED NOT NULL, `logtime` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `srcip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mac` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `clienttohost` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `extra` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `uservisitedlogs` -- INSERT INTO `uservisitedlogs` (`id`, `logtime`, `srcip`, `mac`, `clienttohost`, `url`, `extra`, `filename`, `created_at`, `updated_at`) VALUES (1, '07/22/2022 00:21:30', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.105:443->192.168.250.221:1181', '142.251.12.105:443->(192.168.137.2:1181->192.168.250.221:1181), len 40\n', '', '20220722-002143', NULL, NULL), (2, '07/22/2022 00:21:30', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1181->142.251.12.105:443', '(192.168.250.221:1181->192.168.137.2:1181)->142.251.12.105:443, len 40\n', '', '20220722-002143', NULL, NULL), (3, '07/22/2022 00:21:32', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.105:443->192.168.250.221:1180', '142.251.12.105:443->(192.168.137.2:1180->192.168.250.221:1180), len 40\n', '', '20220722-002143', NULL, NULL), (4, '07/22/2022 00:21:32', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.136:443->192.168.250.221:1184', '142.251.12.136:443->(192.168.137.2:1184->192.168.250.221:1184), len 284\n', '', '20220722-002143', NULL, NULL), (5, '07/22/2022 00:21:32', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '74.125.24.119:443->192.168.250.221:1185', '74.125.24.119:443->(192.168.137.2:1185->192.168.250.221:1185), len 40\n', '', '20220722-002143', NULL, NULL), (6, '07/22/2022 00:21:32', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1185->74.125.24.119:443', '(192.168.250.221:1185->192.168.137.2:1185)->74.125.24.119:443, len 40\n', '', '20220722-002143', NULL, NULL), (7, '07/22/2022 00:21:32', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1186->172.217.194.95:443', '(192.168.250.221:1186->192.168.137.2:1186)->172.217.194.95:443, len 40\n', '', '20220722-002143', NULL, NULL), (8, '07/22/2022 00:21:32', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1187->74.125.24.119:443', '(192.168.250.221:1187->192.168.137.2:1187)->74.125.24.119:443, len 40\n', '', '20220722-002143', NULL, NULL), (9, '07/22/2022 00:21:33', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.105:443->192.168.250.221:1180', '142.251.12.105:443->(192.168.137.2:1180->192.168.250.221:1180), len 40\n', '', '20220722-002143', NULL, NULL), (10, '07/22/2022 00:21:33', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '172.217.194.95:443->192.168.250.221:1186', '172.217.194.95:443->(192.168.137.2:1186->192.168.250.221:1186), len 40\n', '', '20220722-002143', NULL, NULL), (11, '07/22/2022 00:21:33', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1180->142.251.12.105:443', '(192.168.250.221:1180->192.168.137.2:1180)->142.251.12.105:443, len 40\n', '', '20220722-002143', NULL, NULL), (12, '07/22/2022 00:21:33', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1187->74.125.24.119:443', '(192.168.250.221:1187->192.168.137.2:1187)->74.125.24.119:443, len 40\n', '', '20220722-002143', NULL, NULL), (13, '07/22/2022 00:21:35', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.10.94:443->192.168.250.221:1189', '142.251.10.94:443->(192.168.137.2:1189->192.168.250.221:1189), len 40\n', '', '20220722-002143', NULL, NULL), (14, '07/22/2022 00:21:35', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.84:443->192.168.250.221:1190', '142.251.12.84:443->(192.168.137.2:1190->192.168.250.221:1190), len 1470\n', '', '20220722-002143', NULL, NULL), (15, '07/22/2022 00:21:35', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.84:443->192.168.250.221:1190', '142.251.12.84:443->(192.168.137.2:1190->192.168.250.221:1190), len 40\n', '', '20220722-002143', NULL, NULL), (16, '07/22/2022 00:21:36', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.84:443->192.168.250.221:1190', '142.251.12.84:443->(192.168.137.2:1190->192.168.250.221:1190), len 40\n', '', '20220722-002143', NULL, NULL), (17, '07/22/2022 00:21:40', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.105:443->192.168.250.221:1181', '142.251.12.105:443->(192.168.137.2:1181->192.168.250.221:1181), len 40\n', '', '20220722-002143', NULL, NULL), (18, '07/22/2022 00:21:40', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.136:443->192.168.250.221:1184', '142.251.12.136:443->(192.168.137.2:1184->192.168.250.221:1184), len 40\n', '', '20220722-002143', NULL, NULL), (19, '07/22/2022 00:21:41', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1181->142.251.12.105:443', '(192.168.250.221:1181->192.168.137.2:1181)->142.251.12.105:443, len 40\n', '', '20220722-002143', NULL, NULL), (20, '07/22/2022 00:21:43', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1187->74.125.24.119:443', '(192.168.250.221:1187->192.168.137.2:1187)->74.125.24.119:443, len 40\n', '', '20220722-002143', NULL, NULL), (21, '07/22/2022 00:21:43', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1188->172.217.194.95:443', '(192.168.250.221:1188->192.168.137.2:1188)->172.217.194.95:443, len 40\n', '', '20220722-002143', NULL, NULL), (22, '01/01/1970 00:00:00', '', '', '', '', '', '20220722-002143', NULL, NULL), (23, '07/22/2022 00:21:30', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.105:443->192.168.250.221:1181', '142.251.12.105:443->(192.168.137.2:1181->192.168.250.221:1181)', '', '20220722-002143', NULL, NULL), (24, '07/22/2022 00:21:30', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1181->142.251.12.105:443', '(192.168.250.221:1181->192.168.137.2:1181)->142.251.12.105:443', '', '20220722-002143', NULL, NULL), (25, '07/22/2022 00:21:32', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.105:443->192.168.250.221:1180', '142.251.12.105:443->(192.168.137.2:1180->192.168.250.221:1180)', '', '20220722-002143', NULL, NULL), (26, '07/22/2022 00:21:32', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.136:443->192.168.250.221:1184', '142.251.12.136:443->(192.168.137.2:1184->192.168.250.221:1184)', '', '20220722-002143', NULL, NULL), (27, '07/22/2022 00:21:32', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '74.125.24.119:443->192.168.250.221:1185', '74.125.24.119:443->(192.168.137.2:1185->192.168.250.221:1185)', '', '20220722-002143', NULL, NULL), (28, '07/22/2022 00:21:32', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1185->74.125.24.119:443', '(192.168.250.221:1185->192.168.137.2:1185)->74.125.24.119:443', '', '20220722-002143', NULL, NULL), (29, '07/22/2022 00:21:32', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1186->172.217.194.95:443', '(192.168.250.221:1186->192.168.137.2:1186)->172.217.194.95:443', '', '20220722-002143', NULL, NULL), (30, '07/22/2022 00:21:32', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1187->74.125.24.119:443', '(192.168.250.221:1187->192.168.137.2:1187)->74.125.24.119:443', '', '20220722-002143', NULL, NULL), (31, '07/22/2022 00:21:33', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.105:443->192.168.250.221:1180', '142.251.12.105:443->(192.168.137.2:1180->192.168.250.221:1180)', '', '20220722-002143', NULL, NULL), (32, '07/22/2022 00:21:33', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '172.217.194.95:443->192.168.250.221:1186', '172.217.194.95:443->(192.168.137.2:1186->192.168.250.221:1186)', '', '20220722-002143', NULL, NULL), (33, '07/22/2022 00:21:33', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1180->142.251.12.105:443', '(192.168.250.221:1180->192.168.137.2:1180)->142.251.12.105:443', '', '20220722-002143', NULL, NULL), (34, '07/22/2022 00:21:33', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1187->74.125.24.119:443', '(192.168.250.221:1187->192.168.137.2:1187)->74.125.24.119:443', '', '20220722-002143', NULL, NULL), (35, '07/22/2022 00:21:35', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.10.94:443->192.168.250.221:1189', '142.251.10.94:443->(192.168.137.2:1189->192.168.250.221:1189)', '', '20220722-002143', NULL, NULL), (36, '07/22/2022 00:21:35', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.84:443->192.168.250.221:1190', '142.251.12.84:443->(192.168.137.2:1190->192.168.250.221:1190)', '', '20220722-002143', NULL, NULL), (37, '07/22/2022 00:21:35', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.84:443->192.168.250.221:1190', '142.251.12.84:443->(192.168.137.2:1190->192.168.250.221:1190)', '', '20220722-002143', NULL, NULL), (38, '07/22/2022 00:21:36', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.84:443->192.168.250.221:1190', '142.251.12.84:443->(192.168.137.2:1190->192.168.250.221:1190)', '', '20220722-002143', NULL, NULL), (39, '07/22/2022 00:21:40', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.105:443->192.168.250.221:1181', '142.251.12.105:443->(192.168.137.2:1181->192.168.250.221:1181)', '', '20220722-002143', NULL, NULL), (40, '07/22/2022 00:21:40', 'in:ether1 out:ether2', '0a:00:27:00:00:13', '142.251.12.136:443->192.168.250.221:1184', '142.251.12.136:443->(192.168.137.2:1184->192.168.250.221:1184)', '', '20220722-002143', NULL, NULL), (41, '07/22/2022 00:21:41', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1181->142.251.12.105:443', '(192.168.250.221:1181->192.168.137.2:1181)->142.251.12.105:443', '', '20220722-002143', NULL, NULL), (42, '07/22/2022 00:21:43', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1187->74.125.24.119:443', '(192.168.250.221:1187->192.168.137.2:1187)->74.125.24.119:443', '', '20220722-002143', NULL, NULL), (43, '07/22/2022 00:21:43', 'in:ether2 out:ether1', '08:00:27:76:3e:6c', '192.168.250.221:1188->172.217.194.95:443', '(192.168.250.221:1188->192.168.137.2:1188)->172.217.194.95:443', '', '20220722-002143', NULL, NULL), (44, '01/01/1970 00:00:00', '', '', '', '', '', '20220722-002143', NULL, NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `uservisitedlogs` -- ALTER TABLE `uservisitedlogs` ADD PRIMARY KEY (`id`), ADD KEY `id` (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `uservisitedlogs` -- ALTER TABLE `uservisitedlogs` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; COMMIT; /*!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 */;