-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 20, 2025 at 02:14 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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: `iplztpse_final`
--

-- --------------------------------------------------------

--
-- Table structure for table `admin_messages`
--

CREATE TABLE `admin_messages` (
  `id` int(11) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `title` varchar(200) NOT NULL,
  `body` text DEFAULT NULL,
  `read_status` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `admin_settings`
--

CREATE TABLE `admin_settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `maintenance_mode` tinyint(1) DEFAULT 0,
  `registration_mode` varchar(20) DEFAULT 'otp' COMMENT 'otp or direct',
  `otp_expiry_minutes` int(11) DEFAULT 5,
  `otp_enabled` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin_settings`
--

INSERT INTO `admin_settings` (`id`, `setting_key`, `setting_value`, `created_at`, `updated_at`, `maintenance_mode`, `registration_mode`, `otp_expiry_minutes`, `otp_enabled`) VALUES
(31, 'allow_registration', '1', '2025-11-12 14:00:47', '2025-11-20 12:10:46', 0, 'otp', 5, 1),
(32, 'maintenance_mode', '0', '2025-11-12 14:00:47', '2025-11-19 13:59:54', 0, 'otp', 5, 1),
(33, 'allow_export', '0', '2025-11-12 14:00:47', '2025-11-19 13:59:54', 0, 'otp', 5, 1),
(34, 'allow_share', '0', '2025-11-12 14:00:47', '2025-11-19 13:59:54', 0, 'otp', 5, 1),
(35, 'allow_raw_json_view', '0', '2025-11-12 14:00:47', '2025-11-19 13:59:54', 0, 'otp', 5, 1),
(36, 'show_mobile_field', '1', '2025-11-12 14:00:47', '2025-11-13 10:29:30', 0, 'otp', 5, 1),
(37, 'show_name_field', '1', '2025-11-12 14:00:47', '2025-11-13 10:33:07', 0, 'otp', 5, 1),
(38, 'show_fname_field', '1', '2025-11-12 14:00:47', '2025-11-13 09:13:40', 0, 'otp', 5, 1),
(39, 'show_address_field', '1', '2025-11-12 14:00:47', '2025-11-13 10:29:30', 0, 'otp', 5, 1),
(40, 'show_circle_field', '1', '2025-11-12 14:00:47', '2025-11-13 10:29:30', 0, 'otp', 5, 1),
(41, 'show_id_field', '1', '2025-11-12 14:00:47', '2025-11-19 15:03:50', 0, 'otp', 5, 1),
(42, 'show_credit_field', '0', '2025-11-12 14:00:47', '2025-11-15 07:35:01', 0, 'otp', 5, 1),
(43, 'show_developer_field', '0', '2025-11-12 14:00:47', '2025-11-15 07:35:01', 0, 'otp', 5, 1),
(44, 'show_address_aadhaar', '1', '2025-11-12 14:00:47', '2025-11-13 10:32:14', 0, 'otp', 5, 1),
(45, 'show_allowed_onorc', '1', '2025-11-12 14:00:47', '2025-11-13 11:39:56', 0, 'otp', 5, 1),
(46, 'show_districtCode', '1', '2025-11-12 14:00:47', '2025-11-13 11:39:56', 0, 'otp', 5, 1),
(47, 'show_dup_uid_status', '1', '2025-11-12 14:00:47', '2025-11-13 11:39:56', 0, 'otp', 5, 1),
(48, 'show_fpsId', '1', '2025-11-12 14:00:47', '2025-11-13 11:39:56', 0, 'otp', 5, 1),
(49, 'show_homeDistName', '1', '2025-11-12 14:00:47', '2025-11-12 14:01:11', 0, 'otp', 5, 1),
(50, 'show_homeStateName', '1', '2025-11-12 14:00:47', '2025-11-12 14:01:11', 0, 'otp', 5, 1),
(51, 'show_schemeId', '1', '2025-11-12 14:00:47', '2025-11-12 14:01:11', 0, 'otp', 5, 1),
(52, 'show_schemeName', '1', '2025-11-12 14:00:47', '2025-11-12 14:01:11', 0, 'otp', 5, 1),
(53, 'show_memberDetailsList', '1', '2025-11-12 14:00:47', '2025-11-12 14:01:11', 0, 'otp', 5, 1),
(54, 'theme_color', '#2e2e4d', '2025-11-12 14:00:47', '2025-11-19 16:07:17', 0, 'otp', 5, 1),
(55, 'mobile_search_cost', '10', '2025-11-12 14:00:47', '2025-11-20 08:09:22', 0, 'otp', 5, 1),
(56, 'aadhaar_search_cost', '10', '2025-11-12 14:00:47', '2025-11-20 08:09:22', 0, 'otp', 5, 1),
(57, 'mobile_api_url', 'https://seller-ki-mkc.taitanx.workers.dev/?mobile=', '2025-11-13 11:51:19', '2025-11-14 17:12:49', 0, 'otp', 5, 1),
(58, 'aadhaar_api_url', 'https://ox-tawny.vercel.app/fetch?api_key=aniket123&aadhaar=', '2025-11-13 11:51:19', '2025-11-19 06:34:05', 0, 'otp', 5, 1),
(67, 'email_mode', 'smtp', '2025-11-20 07:23:59', '2025-11-20 11:53:59', 0, 'otp', 5, 1),
(68, 'mail_host', 'smtp.gmail.com', '2025-11-20 07:23:59', '2025-11-20 11:53:59', 0, 'otp', 5, 1),
(69, 'mail_port', '465', '2025-11-20 07:23:59', '2025-11-20 11:59:23', 0, 'otp', 5, 1),
(70, 'mail_encryption', 'ssl', '2025-11-20 07:23:59', '2025-11-20 11:53:59', 0, 'otp', 5, 1),
(71, 'mail_username', 's26118152@gmail.com', '2025-11-20 07:23:59', '2025-11-20 11:53:59', 0, 'otp', 5, 1),
(72, 'mail_password_encrypted', 'Z3lpdiBlYm1sIGh6b2Mgb3RtaA==', '2025-11-20 07:23:59', '2025-11-20 11:53:59', 0, 'otp', 5, 1),
(73, 'mail_from_email', 's26118152@gmail.com', '2025-11-20 07:23:59', '2025-11-20 11:53:59', 0, 'otp', 5, 1),
(74, 'mail_from_name', 'Advanced Search Info', '2025-11-20 07:23:59', '2025-11-20 13:03:24', 0, 'otp', 5, 1);

-- --------------------------------------------------------

--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `action` varchar(100) NOT NULL,
  `details` text DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `audit_logs`
--

INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `details`, `ip_address`, `user_agent`, `created_at`) VALUES
(2, 2, 'register', 'User registered successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:31:07'),
(3, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:31:13'),
(4, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:32:06'),
(5, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:32:42'),
(6, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:33:26'),
(7, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:34:48'),
(8, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:36:52'),
(9, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:36:56'),
(10, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:42:26'),
(11, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:42:29'),
(12, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:43:09'),
(13, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:45:58'),
(14, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:49:23'),
(15, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:49:29'),
(16, NULL, 'register', 'User registered successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:50:50'),
(17, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:51:01'),
(18, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:55:34'),
(19, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:55:36'),
(20, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:56:38'),
(21, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:57:40'),
(22, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 11:01:26'),
(23, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 11:06:44'),
(24, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 11:09:13'),
(25, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 06:43:12'),
(26, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 06:44:50'),
(27, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 06:45:47'),
(28, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 06:45:50'),
(29, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 06:46:07'),
(30, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 06:55:51'),
(31, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 06:55:54'),
(32, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 06:55:56'),
(33, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 06:59:12'),
(34, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 07:02:47'),
(35, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 07:02:49'),
(36, NULL, 'register', 'User registered successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 07:05:19'),
(37, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 07:05:27'),
(38, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 07:19:09'),
(39, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 07:19:11'),
(40, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 07:32:20'),
(41, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 07:32:22'),
(42, NULL, 'register', 'User registered successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 07:39:15'),
(43, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 07:39:34'),
(44, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 07:51:03'),
(45, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 07:51:05'),
(46, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 07:54:49'),
(47, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 07:54:51'),
(48, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 08:08:51'),
(49, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 08:08:53'),
(50, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 08:31:24'),
(51, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 08:31:26'),
(52, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 08:34:38'),
(53, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 08:34:40'),
(54, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 08:37:31'),
(55, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 08:37:35'),
(56, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 08:38:17'),
(57, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 08:38:19'),
(58, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 08:40:16'),
(59, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 08:40:18'),
(60, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 09:52:43'),
(61, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-12 09:52:45'),
(62, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:00:10'),
(63, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-12 10:00:12'),
(64, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 00:05:05'),
(65, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 00:18:13'),
(66, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 00:18:15'),
(67, NULL, 'register', 'User registered successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 00:30:23'),
(68, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 00:30:37'),
(69, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 01:05:30'),
(70, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:17:38'),
(71, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:17:40'),
(72, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:18:40'),
(73, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:18:42'),
(74, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:19:08'),
(75, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:19:27'),
(76, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:22:21'),
(77, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:22:41'),
(78, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:23:20'),
(79, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:23:22'),
(80, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:25:01'),
(81, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:33:22'),
(82, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:34:49'),
(83, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:35:20'),
(84, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:54:50'),
(85, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:55:10'),
(86, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:56:07'),
(87, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 01:56:09'),
(88, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:07:51'),
(89, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:07:53'),
(90, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:08:21'),
(91, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:08:23'),
(92, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:09:19'),
(93, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:09:21'),
(94, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:09:58'),
(95, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:09:59'),
(96, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 02:20:48'),
(97, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:22:04'),
(98, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:38:18'),
(99, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 02:48:39'),
(100, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 02:48:42'),
(101, NULL, 'register', 'User registered successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:50:24'),
(102, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:50:30'),
(103, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:55:48'),
(104, NULL, 'register', 'User registered successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:56:32'),
(105, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 02:56:43'),
(106, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 03:18:54'),
(107, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 03:19:06'),
(108, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 03:48:50'),
(109, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 03:48:52'),
(110, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 03:51:56'),
(111, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 03:51:58'),
(112, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 04:02:10'),
(113, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 04:02:12'),
(114, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 04:43:16'),
(115, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 04:43:53'),
(116, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 04:49:49'),
(117, NULL, 'register', 'User registered successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 04:50:33'),
(118, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 04:50:40'),
(119, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 06:14:51'),
(120, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 06:14:54'),
(121, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 06:17:04'),
(122, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 06:17:06'),
(124, NULL, 'register', 'User registered successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 06:48:04'),
(125, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 06:48:21'),
(126, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 07:05:31'),
(127, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 07:10:28'),
(128, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 07:47:17'),
(129, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-13 07:47:31'),
(130, NULL, 'register', 'User registered successfully', '152.57.44.157', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 07:19:43'),
(131, NULL, 'login', 'User logged in successfully', '152.57.44.157', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 07:19:49'),
(132, NULL, 'logout', 'User logged out', '152.57.40.160', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 07:56:21'),
(133, 2, 'login', 'User logged in successfully', '152.57.40.160', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 07:59:00'),
(134, 2, 'logout', 'User logged out', '152.57.40.160', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 07:59:34'),
(135, NULL, 'register', 'User registered successfully', '152.57.39.135', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 08:00:14'),
(136, NULL, 'login', 'User logged in successfully', '152.57.37.253', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 08:00:30'),
(137, NULL, 'logout', 'User logged out', '152.57.40.102', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 08:01:05'),
(138, NULL, 'login', 'User logged in successfully', '152.57.39.231', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 08:10:48'),
(139, NULL, 'logout', 'User logged out', '152.57.39.231', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 08:10:59'),
(140, NULL, 'login', 'User logged in successfully', '152.57.39.231', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 08:11:55'),
(141, NULL, 'logout', 'User logged out', '152.57.39.231', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 08:12:20'),
(142, 2, 'login', 'User logged in successfully', '152.57.39.231', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 08:12:26'),
(143, NULL, 'register', 'User registered successfully', '152.57.31.191', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-13 09:16:43'),
(144, NULL, 'login', 'User logged in successfully', '152.57.31.191', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-13 09:16:57'),
(145, NULL, 'logout', 'User logged out', '152.57.31.191', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 09:17:57'),
(146, NULL, 'login', 'User logged in successfully', '152.57.27.14', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 09:43:13'),
(147, NULL, 'logout', 'User logged out', '152.57.27.14', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-13 09:43:51'),
(148, 2, 'login', 'User logged in successfully', '152.57.27.14', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-13 09:44:06'),
(149, 2, 'logout', 'User logged out', '152.57.27.14', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 09:44:41'),
(150, 2, 'login', 'User logged in successfully', '152.57.27.14', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-13 09:46:27'),
(151, 2, 'logout', 'User logged out', '152.57.27.14', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-13 09:46:52'),
(152, NULL, 'login', 'User logged in successfully', '152.57.27.14', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-13 09:47:00'),
(153, 14, 'register', 'User registered successfully', '152.57.26.177', 'Mozilla/5.0 (Linux; Android 13; IV2201  ) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0  Mobile Safari/537.36 Chrome/118.0.0.0', '2025-11-13 21:10:03'),
(154, 14, 'login', 'User logged in successfully', '152.57.26.177', 'Mozilla/5.0 (Linux; Android 13; IV2201  ) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0  Mobile Safari/537.36 Chrome/118.0.0.0', '2025-11-13 21:10:16'),
(155, NULL, 'login', 'User logged in successfully', '152.57.26.177', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 21:10:56'),
(156, NULL, 'logout', 'User logged out', '152.57.17.131', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 21:49:10'),
(157, 2, 'login', 'User logged in successfully', '152.57.17.131', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 21:49:36'),
(158, 2, 'logout', 'User logged out', '152.57.17.131', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 21:50:32'),
(159, NULL, 'login', 'User logged in successfully', '152.57.17.131', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 21:50:39'),
(160, NULL, 'logout', 'User logged out', '152.57.17.131', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 21:51:10'),
(161, 2, 'login', 'User logged in successfully', '152.57.17.131', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 21:51:14'),
(162, 2, 'logout', 'User logged out', '152.57.17.131', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 21:51:41'),
(163, 2, 'login', 'User logged in successfully', '152.57.25.209', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 22:25:18'),
(164, 2, 'login', 'User logged in successfully', '152.57.23.21', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 22:49:44'),
(165, 2, 'logout', 'User logged out', '152.57.23.21', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 22:49:53'),
(166, 2, 'login', 'User logged in successfully', '152.57.25.184', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 23:36:14'),
(167, 2, 'logout', 'User logged out', '152.57.25.184', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 23:37:02'),
(168, 14, 'login', 'User logged in successfully', '152.57.25.184', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 23:37:18'),
(169, 14, 'logout', 'User logged out', '152.57.25.184', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 23:37:45'),
(170, 2, 'login', 'User logged in successfully', '152.57.25.184', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 23:37:47'),
(171, 2, 'logout', 'User logged out', '152.57.18.21', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-13 23:43:10'),
(172, 14, 'login', 'User logged in successfully', '157.50.178.68', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 01:40:20'),
(173, 14, 'logout', 'User logged out', '157.50.178.68', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 01:41:07'),
(174, 2, 'login', 'User logged in successfully', '157.50.178.68', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 01:41:57'),
(175, 2, 'logout', 'User logged out', '157.50.178.68', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 01:42:49'),
(176, 14, 'login', 'User logged in successfully', '157.50.178.68', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 01:42:58'),
(177, 14, 'logout', 'User logged out', '157.50.178.68', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 01:44:10'),
(178, 2, 'login', 'User logged in successfully', '157.50.179.208', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-14 05:56:35'),
(179, 2, 'logout', 'User logged out', '157.50.182.50', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-14 06:15:22'),
(180, 2, 'login', 'User logged in successfully', '157.50.182.50', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-14 06:15:25'),
(181, 2, 'logout', 'User logged out', '157.50.182.50', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-14 06:20:53'),
(182, 2, 'login', 'User logged in successfully', '157.50.183.1', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 06:22:48'),
(183, 2, 'logout', 'User logged out', '157.50.183.1', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 06:27:40'),
(184, 14, 'login', 'User logged in successfully', '157.50.183.1', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 06:27:46'),
(185, 14, 'logout', 'User logged out', '157.50.183.1', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 06:28:19'),
(186, 2, 'login', 'User logged in successfully', '157.50.177.0', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-14 06:46:30'),
(187, 2, 'login', 'User logged in successfully', '157.50.177.201', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-14 08:04:37'),
(188, 2, 'logout', 'User logged out', '157.50.177.201', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-14 08:09:34'),
(189, NULL, 'login', 'User logged in successfully', '157.50.177.201', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-14 08:09:37'),
(190, NULL, 'logout', 'User logged out', '157.50.177.201', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-14 08:10:52'),
(191, NULL, 'login', 'User logged in successfully', '157.50.177.201', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-14 08:11:47'),
(192, 2, 'login', 'User logged in successfully', '157.50.177.201', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:26:03'),
(193, 2, 'logout', 'User logged out', '157.50.177.201', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:26:46'),
(194, 14, 'login', 'User logged in successfully', '157.50.177.201', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:26:52'),
(195, 14, 'logout', 'User logged out', '157.50.177.201', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:28:45'),
(196, 14, 'login', 'User logged in successfully', '157.50.177.201', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:28:51'),
(197, 14, 'logout', 'User logged out', '157.50.177.201', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:29:33'),
(198, 14, 'login', 'User logged in successfully', '157.50.177.201', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:29:53'),
(199, 14, 'logout', 'User logged out', '157.50.177.201', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:48:17'),
(200, 2, 'login', 'User logged in successfully', '157.50.177.201', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:48:24'),
(201, 2, 'logout', 'User logged out', '157.50.177.201', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:49:02'),
(202, 2, 'login', 'User logged in successfully', '157.50.183.100', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:59:17'),
(203, 2, 'logout', 'User logged out', '157.50.183.100', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:59:29'),
(204, 14, 'login', 'User logged in successfully', '157.50.183.100', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:59:35'),
(205, 14, 'logout', 'User logged out', '157.50.183.100', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 08:59:57'),
(206, 2, 'login', 'User logged in successfully', '157.50.183.100', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:03:27'),
(207, 2, 'logout', 'User logged out', '157.50.183.100', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:15:34'),
(208, 2, 'login', 'User logged in successfully', '157.50.183.100', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:15:40'),
(209, 2, 'logout', 'User logged out', '157.50.183.100', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:17:25'),
(210, 2, 'login', 'User logged in successfully', '157.50.183.100', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:19:10'),
(211, 2, 'logout', 'User logged out', '157.50.183.100', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:22:39'),
(212, 14, 'login', 'User logged in successfully', '157.50.183.100', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:22:47'),
(213, 14, 'logout', 'User logged out', '157.50.178.70', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:23:34'),
(214, 2, 'login', 'User logged in successfully', '157.50.178.70', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:23:39'),
(215, 2, 'logout', 'User logged out', '157.50.178.70', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:44:39'),
(216, 2, 'login', 'User logged in successfully', '157.50.178.70', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:44:45'),
(217, 2, 'logout', 'User logged out', '157.50.179.224', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 09:53:33'),
(218, 2, 'login', 'User logged in successfully', '157.50.179.224', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 10:03:49'),
(219, 2, 'logout', 'User logged out', '157.50.180.89', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 10:05:01'),
(220, 2, 'login', 'User logged in successfully', '157.50.180.89', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 10:06:18'),
(221, 2, 'logout', 'User logged out', '157.50.180.89', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 10:06:23'),
(222, 14, 'login', 'User logged in successfully', '157.50.180.89', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 10:06:29'),
(223, 14, 'logout', 'User logged out', '157.50.180.89', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 10:08:35'),
(224, 2, 'login', 'User logged in successfully', '157.50.180.89', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 10:08:40'),
(225, 2, 'logout', 'User logged out', '157.50.180.89', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 10:08:56'),
(226, 14, 'login', 'User logged in successfully', '157.50.180.89', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 10:09:01'),
(227, 14, 'logout', 'User logged out', '157.50.180.89', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 10:11:19'),
(228, 2, 'login', 'User logged in successfully', '157.50.180.89', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 10:26:37'),
(229, 2, 'login', 'User logged in successfully', '157.50.176.101', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 11:29:57'),
(230, 2, 'logout', 'User logged out', '157.50.176.101', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 11:31:00'),
(231, 14, 'login', 'User logged in successfully', '157.50.176.101', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 11:31:06'),
(232, 14, 'logout', 'User logged out', '157.50.176.101', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 11:32:07'),
(233, 2, 'login', 'User logged in successfully', '157.50.182.29', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 11:42:27'),
(234, 2, 'login', 'User logged in successfully', '157.50.190.59', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 20:41:24'),
(235, 2, 'logout', 'User logged out', '157.50.190.59', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 20:42:20'),
(236, 2, 'login', 'User logged in successfully', '157.50.191.168', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 21:13:56'),
(237, 2, 'logout', 'User logged out', '157.50.191.168', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 21:14:57'),
(238, 2, 'login', 'User logged in successfully', '157.50.191.168', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 21:49:12'),
(239, 2, 'logout', 'User logged out', '157.50.186.147', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 22:01:54'),
(240, 14, 'login', 'User logged in successfully', '157.50.186.147', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-14 22:01:59'),
(241, NULL, 'login', 'User logged in successfully', '157.50.186.147', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-14 22:04:35'),
(242, NULL, 'logout', 'User logged out', '157.50.187.237', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-14 22:16:32'),
(243, NULL, 'login', 'User logged in successfully', '157.50.187.237', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '2025-11-14 22:18:18'),
(244, 2, 'login', 'User logged in successfully', '157.50.187.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 01:42:19'),
(245, 2, 'logout', 'User logged out', '157.50.187.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 01:42:27'),
(246, 14, 'login', 'User logged in successfully', '157.50.187.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 01:42:34'),
(247, 14, 'logout', 'User logged out', '157.50.187.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 01:43:13'),
(248, 2, 'login', 'User logged in successfully', '157.50.187.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 01:43:19'),
(249, 2, 'logout', 'User logged out', '157.50.187.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 01:43:53'),
(250, 14, 'login', 'User logged in successfully', '157.50.187.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 01:44:03'),
(251, 14, 'logout', 'User logged out', '152.57.42.144', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 02:04:22');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `details`, `ip_address`, `user_agent`, `created_at`) VALUES
(252, 2, 'login', 'User logged in successfully', '152.57.42.144', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 02:04:28'),
(253, 2, 'logout', 'User logged out', '152.57.42.144', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 02:05:24'),
(254, 14, 'login', 'User logged in successfully', '152.57.38.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 03:14:05'),
(255, 14, 'logout', 'User logged out', '152.57.38.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 03:14:30'),
(256, 2, 'login', 'User logged in successfully', '152.57.38.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 03:14:48'),
(257, 2, 'logout', 'User logged out', '152.57.38.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 03:16:21'),
(258, 14, 'login', 'User logged in successfully', '152.57.38.152', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 03:16:27'),
(259, 14, 'logout', 'User logged out', '152.57.34.78', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 03:50:46'),
(260, 2, 'login', 'User logged in successfully', '152.57.34.78', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 03:50:52'),
(261, 15, 'register', 'User registered successfully', '106.219.186.252', 'Mozilla/5.0 (iPhone; CPU iPhone OS 26_0_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/141.0.7390.96 Mobile/15E148 Safari/604.1', '2025-11-15 03:55:05'),
(262, 15, 'login', 'User logged in successfully', '106.219.186.252', 'Mozilla/5.0 (iPhone; CPU iPhone OS 26_0_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/141.0.7390.96 Mobile/15E148 Safari/604.1', '2025-11-15 03:55:16'),
(263, 2, 'logout', 'User logged out', '152.57.34.130', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 05:38:40'),
(264, 14, 'login', 'User logged in successfully', '152.57.34.130', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 05:38:47'),
(265, 14, 'logout', 'User logged out', '152.57.34.130', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 05:43:40'),
(266, 2, 'login', 'User logged in successfully', '152.57.40.70', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 06:40:05'),
(267, 2, 'logout', 'User logged out', '152.57.33.129', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 07:50:15'),
(268, 14, 'login', 'User logged in successfully', '152.57.33.129', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 07:50:22'),
(269, 14, 'logout', 'User logged out', '152.57.35.130', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 08:19:49'),
(270, 14, 'login', 'User logged in successfully', '152.57.40.198', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 08:48:17'),
(271, 14, 'logout', 'User logged out', '152.57.40.198', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 08:50:20'),
(272, 16, 'register', 'User registered successfully', '157.50.168.232', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 08:52:03'),
(273, 16, 'login', 'User logged in successfully', '157.50.168.232', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 08:52:14'),
(274, 2, 'login', 'User logged in successfully', '152.57.40.198', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 08:52:37'),
(275, 2, 'login', 'User logged in successfully', '152.57.36.229', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 11:46:00'),
(276, 2, 'logout', 'User logged out', '152.57.36.229', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 11:46:49'),
(277, 14, 'login', 'User logged in successfully', '152.57.36.229', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 11:46:56'),
(278, 2, 'login', 'User logged in successfully', '157.50.190.220', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-15 23:52:26'),
(279, 14, 'login', 'User logged in successfully', '157.50.189.29', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-16 00:45:50'),
(280, 14, 'logout', 'User logged out', '157.50.189.29', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-16 00:46:02'),
(281, 2, 'login', 'User logged in successfully', '157.50.189.29', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-16 00:46:12'),
(282, 14, 'login', 'User logged in successfully', '157.50.184.96', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-16 02:20:53'),
(283, 2, 'login', 'User logged in successfully', '157.50.173.223', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-16 02:23:23'),
(284, 2, 'logout', 'User logged out', '157.50.173.223', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-16 02:23:42'),
(285, NULL, 'register', 'User registered successfully', '157.50.173.223', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-16 02:25:20'),
(286, NULL, 'login', 'User logged in successfully', '157.50.173.223', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-16 02:25:32'),
(287, NULL, 'logout', 'User logged out', '157.50.173.223', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-16 02:25:42'),
(288, 2, 'login', 'User logged in successfully', '157.50.173.223', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-16 02:29:27'),
(289, NULL, 'login', 'User logged in successfully', '157.50.173.223', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-16 02:29:33'),
(290, 14, 'logout', 'User logged out', '157.50.184.96', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-16 02:44:19'),
(291, 14, 'login', 'User logged in successfully', '157.50.184.96', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-16 02:48:11'),
(292, 2, 'logout', 'User logged out', '157.50.171.163', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-16 02:49:34'),
(293, 14, 'logout', 'User logged out', '157.50.184.96', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-16 02:49:59'),
(294, 14, 'login', 'User logged in successfully', '157.50.184.203', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-16 03:09:41'),
(295, 14, 'login', 'User logged in successfully', '157.50.184.44', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-16 05:41:30'),
(296, 14, 'login', 'User logged in successfully', '157.50.104.62', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-16 23:56:00'),
(297, 14, 'login', 'User logged in successfully', '157.50.112.30', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-17 08:36:52'),
(298, 2, 'login', 'User logged in successfully', '152.57.18.96', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-18 03:14:15'),
(299, 2, 'logout', 'User logged out', '152.57.18.96', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-18 03:14:32'),
(300, 14, 'login', 'User logged in successfully', '152.57.29.150', 'Mozilla/5.0 (Linux; Android; K) App1 AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.144 Mobile Safari/537.36', '2025-11-18 08:31:43'),
(301, 14, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 00:50:07'),
(302, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 00:55:53'),
(303, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 00:58:20'),
(304, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 01:14:24'),
(305, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 01:14:25'),
(306, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 01:19:06'),
(307, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 01:19:13'),
(308, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 01:20:12'),
(309, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 01:20:20'),
(310, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 01:24:37'),
(311, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 01:24:39'),
(312, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.106.1 Chrome/138.0.7204.251 Electron/37.7.0 Safari/537.36', '2025-11-19 01:25:16'),
(313, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.106.1 Chrome/138.0.7204.251 Electron/37.7.0 Safari/537.36', '2025-11-19 01:25:29'),
(314, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 01:28:16'),
(315, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 01:28:18'),
(316, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 01:45:37'),
(317, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 01:45:39'),
(318, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 01:56:15'),
(319, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 01:56:17'),
(320, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.106.1 Chrome/138.0.7204.251 Electron/37.7.0 Safari/537.36', '2025-11-19 02:01:56'),
(321, 18, 'register', 'User registered successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.106.1 Chrome/138.0.7204.251 Electron/37.7.0 Safari/537.36', '2025-11-19 02:02:31'),
(322, 18, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.106.1 Chrome/138.0.7204.251 Electron/37.7.0 Safari/537.36', '2025-11-19 02:02:41'),
(323, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 02:06:29'),
(324, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 02:06:31'),
(325, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 02:09:55'),
(326, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 02:09:57'),
(327, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 03:43:06'),
(328, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 03:50:01'),
(329, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 03:50:03'),
(330, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 03:54:41'),
(331, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 03:54:43'),
(332, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 04:01:06'),
(333, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 04:01:07'),
(334, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 04:03:54'),
(335, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 04:04:26'),
(336, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 04:04:28'),
(337, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 04:05:15'),
(338, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 04:05:16'),
(339, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 04:06:09'),
(340, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 04:17:28'),
(341, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 04:17:29'),
(342, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 05:11:54'),
(343, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 05:11:56'),
(344, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 05:15:16'),
(345, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 05:15:18'),
(346, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 05:16:51'),
(347, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 05:16:53'),
(348, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 05:17:49'),
(349, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 05:18:12'),
(350, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 05:28:05'),
(351, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 05:28:09'),
(352, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 06:01:40'),
(353, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 06:01:48'),
(354, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 06:02:50'),
(355, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 06:03:16'),
(356, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 08:58:41'),
(357, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 09:19:43'),
(358, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 09:19:49'),
(359, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 09:19:53'),
(360, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 09:21:10'),
(361, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 09:23:10'),
(362, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 09:23:21'),
(363, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 09:27:15'),
(364, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 09:27:20'),
(365, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 10:48:32'),
(366, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 10:48:32'),
(367, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 10:48:38'),
(368, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 11:03:25'),
(369, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 11:03:26'),
(370, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 11:21:40'),
(371, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 11:22:08'),
(372, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-19 11:22:10'),
(373, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 11:22:28'),
(374, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-19 11:39:13'),
(375, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 00:30:19'),
(376, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 00:31:03'),
(377, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 01:09:45'),
(378, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 01:09:47'),
(379, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 02:02:03'),
(380, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 02:02:05'),
(381, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 02:05:30'),
(382, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 02:05:33'),
(383, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 02:08:28'),
(384, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 02:08:32'),
(385, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 02:22:36'),
(386, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 02:22:38'),
(387, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 02:27:03'),
(388, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 02:27:14'),
(389, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 03:46:54'),
(390, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 03:50:03'),
(391, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 03:51:14'),
(392, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 03:59:25'),
(393, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 03:59:27'),
(394, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 04:03:14'),
(395, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 04:07:30'),
(396, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:09:49'),
(397, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:10:16'),
(398, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:22:56'),
(399, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:23:01'),
(400, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:26:54'),
(401, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:27:54'),
(402, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:35:49'),
(403, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:36:04'),
(404, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:38:33'),
(405, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:38:34'),
(406, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:38:53'),
(407, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 04:40:03'),
(408, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:41:50'),
(409, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 04:41:53'),
(411, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 04:54:20'),
(412, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 04:54:26'),
(413, NULL, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 04:54:30'),
(414, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 04:55:05'),
(415, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 05:00:21'),
(416, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 05:03:40'),
(417, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 07:12:44'),
(418, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 07:12:46'),
(419, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 07:14:18'),
(420, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 07:14:30'),
(421, 16, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 07:14:53'),
(422, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 07:33:28'),
(423, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 07:33:30'),
(424, 16, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 07:36:56'),
(425, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 07:37:30'),
(426, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 07:38:02'),
(427, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 07:38:10'),
(429, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 07:41:43'),
(430, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 07:45:27'),
(431, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 07:49:50'),
(432, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 07:50:34'),
(433, NULL, 'register', 'User registered - waiting for email verification', '0.0.0.0', '', '2025-11-20 07:56:32'),
(434, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 07:59:12'),
(435, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 08:02:23'),
(436, NULL, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 08:03:02'),
(438, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 08:03:45'),
(439, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 08:05:55'),
(440, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 08:07:37'),
(441, NULL, 'register', 'User registered - waiting for email verification', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0', '2025-11-20 08:09:04'),
(442, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 08:33:37'),
(443, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 08:33:51'),
(444, 2, 'logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 08:41:28'),
(445, 2, 'login', 'User logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '2025-11-20 08:41:32');

-- --------------------------------------------------------

--
-- Table structure for table `chatbot_chats`
--

CREATE TABLE `chatbot_chats` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` varchar(50) DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chatbot_chats`
--

INSERT INTO `chatbot_chats` (`id`, `user_id`, `status`, `created_at`) VALUES
(1, 16, 'active', '2025-11-20 02:17:16'),
(2, 2, 'active', '2025-11-20 02:24:55');

-- --------------------------------------------------------

--
-- Table structure for table `chatbot_messages`
--

CREATE TABLE `chatbot_messages` (
  `id` int(11) NOT NULL,
  `chat_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `message` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chatbot_messages`
--

INSERT INTO `chatbot_messages` (`id`, `chat_id`, `sender_id`, `message`, `created_at`) VALUES
(1, 1, 16, 'hi', '2025-11-20 02:17:21'),
(2, 2, 2, 'Hello! I need help with my account.', '2025-11-20 01:24:55'),
(3, 2, 2, 'Can you help me with payment issue?', '2025-11-20 01:54:55'),
(4, 1, 1, 'Hello! ???? Thank you for contacting us.', '2025-11-20 02:35:39'),
(5, 1, 1, 'Hello! ???? Thank you for contacting us.', '2025-11-20 02:35:40'),
(6, 2, 1, 'Hello! ???? Thank you for contacting us.', '2025-11-20 02:44:53'),
(7, 1, 16, 'ok', '2025-11-20 02:45:42'),
(8, 2, 1, 'I understand your issue. Let me help!', '2025-11-20 02:45:56'),
(9, 2, 1, 'I understand your issue. Let me help!', '2025-11-20 02:46:03'),
(10, 2, 1, 'I understand your issue. Let me help!', '2025-11-20 02:46:04'),
(11, 2, 1, 'I understand your issue. Let me help!', '2025-11-20 02:46:04'),
(12, 1, 16, 'f', '2025-11-20 02:49:09'),
(13, 1, 1, 'Hello! ???? Thank you for contacting us.', '2025-11-20 02:49:26'),
(14, 1, 16, 'Test message 1763623274547', '2025-11-20 02:51:14'),
(15, 1, 1, 'I understand your issue. Let me help!', '2025-11-20 02:51:48'),
(16, 1, 16, '4', '2025-11-20 02:53:12'),
(17, 1, 1, 'Hello! ???? Thank you for contacting us.', '2025-11-20 02:53:23'),
(18, 1, 1, 'I understand your issue. Let me help!', '2025-11-20 02:57:05'),
(19, 1, 1, 'I understand your issue. Let me help!', '2025-11-20 03:24:14'),
(20, 1, 1, 'I understand your issue. Let me help!', '2025-11-20 03:24:17'),
(21, 1, 16, 'hi', '2025-11-20 03:24:38');

-- --------------------------------------------------------

--
-- Table structure for table `email_otps`
--

CREATE TABLE `email_otps` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `otp` varchar(6) NOT NULL,
  `attempts` int(11) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp(),
  `expires_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `email_otps`
--

INSERT INTO `email_otps` (`id`, `email`, `otp`, `attempts`, `created_at`, `expires_at`) VALUES
(6, 'sandeshs11110@gmail.com', '920216', 0, '2025-11-20 10:25:34', '2025-11-20 10:30:34'),
(10, 's26118152@gmail.com', '099610', 0, '2025-11-20 12:53:29', '2025-11-20 12:58:29'),
(22, 'www.zgang7@gmail.com', '257444', 3, '2025-11-20 13:33:45', '2025-11-20 13:38:45'),
(26, '9731305830s@gmail.com', '263499', 0, '2025-11-20 13:39:04', '2025-11-20 13:44:04');

-- --------------------------------------------------------

--
-- Table structure for table `payment_details`
--

CREATE TABLE `payment_details` (
  `id` int(11) NOT NULL,
  `qr_code_path` varchar(255) DEFAULT NULL,
  `upi_id` varchar(50) DEFAULT NULL,
  `telegram_bot_token` varchar(255) DEFAULT NULL,
  `telegram_admin_chat_id` varchar(100) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_details`
--

INSERT INTO `payment_details` (`id`, `qr_code_path`, `upi_id`, `telegram_bot_token`, `telegram_admin_chat_id`, `is_active`, `updated_at`) VALUES
(1, 'uploads/qrcodes/qr_1763532593.png', '6361773935@ybl', '8547703649:AAE17yXixrbwGZvDM2Lm5SVH4rFXItovTMg', '6034515846', 1, '2025-11-19 06:24:55');

-- --------------------------------------------------------

--
-- Table structure for table `payment_orders`
--

CREATE TABLE `payment_orders` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `order_id` varchar(100) NOT NULL,
  `package_name` varchar(100) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `screenshot_path` varchar(255) DEFAULT NULL,
  `payment_method` varchar(50) DEFAULT NULL,
  `status` enum('pending','completed','failed','cancelled','awaiting_approval','rejected') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `confirmed_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_orders`
--

INSERT INTO `payment_orders` (`id`, `user_id`, `order_id`, `package_name`, `amount`, `transaction_id`, `screenshot_path`, `payment_method`, `status`, `created_at`, `confirmed_at`) VALUES
(38, 16, 'ORD-1763543354-16', '', 111.00, '56434235', 'uploads/payments/payment_16_1763543360.png', 'manual_approval', 'completed', '2025-11-19 04:39:14', NULL),
(39, 16, 'ORD-1763545357-16', '', 111.00, '65757567658', 'uploads/payments/payment_16_1763545375.png', 'manual_upi', 'rejected', '2025-11-19 05:12:37', NULL),
(40, 16, 'ORD-1763545526-16', '', 100.00, '9876543', 'uploads/payments/payment_16_1763545532.png', 'manual_approval', 'completed', '2025-11-19 05:15:26', NULL),
(41, 16, 'ORD-1763546095-16', '', 11.00, '1234567', 'uploads/payments/payment_16_1763546102.png', 'manual_approval', 'completed', '2025-11-19 05:24:55', NULL),
(42, 16, 'ORD-1763546598-16', '', 100.00, NULL, NULL, 'manual_upi', 'pending', '2025-11-19 05:33:18', NULL),
(43, 16, 'ORD-1763546989-16', '', 100.00, '9876543456', 'uploads/payments/payment_16_1763546998.png', 'manual_approval', 'completed', '2025-11-19 05:39:49', NULL),
(44, 16, 'ORD-1763547004-9135', 'Test Package', 50.00, NULL, NULL, 'manual_approval', 'completed', '2025-11-19 05:40:04', NULL),
(45, 16, 'ORD-1763547087-16', '', 100.00, '987575656', 'uploads/payments/payment_16_1763547097.png', 'manual_approval', 'completed', '2025-11-19 05:41:27', NULL),
(46, 16, 'ORD-1763547132-16', '', 11.00, '8765434567', 'uploads/payments/payment_16_1763547141.png', 'manual_upi', 'rejected', '2025-11-19 05:42:12', NULL),
(47, 16, 'ORD-1763547598-16', '', 11.00, NULL, NULL, 'manual_upi', 'pending', '2025-11-19 05:49:58', NULL),
(48, 16, 'ORD-1763547663-16', '', 232.00, '65432', 'uploads/payments/payment_16_1763547669.png', 'manual_approval', 'completed', '2025-11-19 05:51:03', NULL),
(49, 16, 'ORD-1763565443-16', '', 100.00, '765434567887654', 'uploads/payments/payment_16_1763565451.png', 'manual_approval', 'completed', '2025-11-19 10:47:23', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `can_view_raw_json` tinyint(1) DEFAULT 0,
  `can_export` tinyint(1) DEFAULT 0,
  `can_view_sensitive` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `user_id`, `can_view_raw_json`, `can_export`, `can_view_sensitive`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, 1, '2025-11-12 10:27:20', '2025-11-12 10:27:20'),
(2, 2, 0, 0, 0, '2025-11-12 10:31:07', '2025-11-12 10:31:07'),
(14, 14, 0, 0, 0, '2025-11-14 02:40:03', '2025-11-14 02:40:03'),
(15, 15, 0, 0, 0, '2025-11-15 09:25:05', '2025-11-15 09:25:05'),
(16, 16, 0, 0, 0, '2025-11-15 14:22:03', '2025-11-15 14:22:03'),
(18, 18, 0, 0, 0, '2025-11-19 06:32:31', '2025-11-19 06:32:31');

-- --------------------------------------------------------

--
-- Table structure for table `search_cache`
--

CREATE TABLE `search_cache` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `search_type` varchar(20) DEFAULT NULL,
  `query` varchar(255) DEFAULT NULL,
  `response_json` mediumtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `search_logs`
--

CREATE TABLE `search_logs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `type` enum('mobile','aadhaar') NOT NULL,
  `query` varchar(50) NOT NULL,
  `response_json` longtext DEFAULT NULL,
  `cost` decimal(3,1) NOT NULL,
  `status` enum('success','failed','pending') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `search_logs`
--

INSERT INTO `search_logs` (`id`, `user_id`, `type`, `query`, `response_json`, `cost`, `status`, `created_at`) VALUES
(126, 14, 'mobile', '6361773935', '[{\"mobile\":\"9964773935\",\"name\":\"S Sandesh\",\"fname\":\"S\\/O Sathish S\",\"address\":\"S\\/O Sathish S! !Gowdara Street Near Tharalubalu School!Nalluru Davangere!Near Tharalubalu School!DAVANAGERE!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"7353832274\",\"name\":\"H N KAMALAMMA\",\"fname\":\"shanthaveerappa s\",\"address\":\"!w\\/p shanthaveerappa s!nalluru basaveshewara!nallur!channagiri nallur!Davangere!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"701728922808\"},{\"mobile\":\"7204635947\",\"name\":\"Bhuvan M\",\"fname\":\"S\\/O T P Mallikarjuna\",\"address\":\"S\\/O T P Mallikarjuna!#71\\/1!2nd main 14th cross Main Nittuvalli Road!K T J Nagar Davanagere!Main Nittuvalli Road!DAVANAGERE!Davanagere!Karnataka!577002\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"6361773935\",\"name\":\"PRASAD\",\"fname\":\"ramdas\",\"address\":\"!!GOWDRU STREET CHANNAGIRI Nallur!!Nallur Davanagere!Karnataka!577221\",\"circle\":\"JIO KARNATKA\",\"id\":\"600612029967\"}]', 10.0, 'success', '2025-11-14 07:10:30'),
(127, 14, 'aadhaar', '910277498644', '{\"address\":\"W O SATHISH S  GOWDRU STSREET\\rNallur\\rNallur PO\",\"allowed_onorc\":\"Yes\",\"districtCode\":\"567\",\"dup_uid_status\":\"No\",\"fpsId\":\"757211\",\"homeDistName\":\"DAVANGERE\",\"homeStateCode\":\"29\",\"homeStateName\":\"KARNATAKA\",\"memberDetailsList\":[{\"memberId\":\"1201001637332\",\"memberName\":\"SHIVANNA\",\"relationship_code\":\"18\",\"releationship_name\":\"FATHER IN LAW\",\"uid\":\"Yes\"},{\"memberId\":\"1201001637331\",\"memberName\":\"ROOPA\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\",\"uid\":\"Yes\"},{\"memberId\":\"1201001637333\",\"memberName\":\"Shriram Samarth\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"},{\"memberId\":\"1201001637334\",\"memberName\":\"S Sandesh\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"}],\"rcId\":\"120100163733\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\"}', 10.0, 'success', '2025-11-14 07:11:03'),
(128, 14, 'mobile', '6361773935', '[{\"mobile\":\"9964773935\",\"name\":\"S Sandesh\",\"fname\":\"S\\/O Sathish S\",\"address\":\"S\\/O Sathish S! !Gowdara Street Near Tharalubalu School!Nalluru Davangere!Near Tharalubalu School!DAVANAGERE!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"7353832274\",\"name\":\"H N KAMALAMMA\",\"fname\":\"shanthaveerappa s\",\"address\":\"!w\\/p shanthaveerappa s!nalluru basaveshewara!nallur!channagiri nallur!Davangere!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"701728922808\"},{\"mobile\":\"7204635947\",\"name\":\"Bhuvan M\",\"fname\":\"S\\/O T P Mallikarjuna\",\"address\":\"S\\/O T P Mallikarjuna!#71\\/1!2nd main 14th cross Main Nittuvalli Road!K T J Nagar Davanagere!Main Nittuvalli Road!DAVANAGERE!Davanagere!Karnataka!577002\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"6361773935\",\"name\":\"PRASAD\",\"fname\":\"ramdas\",\"address\":\"!!GOWDRU STREET CHANNAGIRI Nallur!!Nallur Davanagere!Karnataka!577221\",\"circle\":\"JIO KARNATKA\",\"id\":\"600612029967\"}]', 10.0, '', '2025-11-14 07:13:14'),
(129, 14, 'mobile', '8748848829', '[{\"mobile\":\"8748848829\",\"name\":\"N M Sowmya\",\"fname\":\"Rudresh A D\",\"address\":\"W\\/O Rudresh A D 19 Huchchavvanahalli Hutchavvanahalli  Huchhavvanahalli Davanagere Davangere Karnataka 577534\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"808262365427\"}]', 10.0, '', '2025-11-14 07:13:44'),
(130, 14, 'aadhaar', '808262365427', '{\"address\":\"HUCHAVANAHALLI DAVANGERE T.D.\",\"allowed_onorc\":\"Yes\",\"districtCode\":\"567\",\"dup_uid_status\":\"No\",\"fpsId\":\"7896217\",\"homeDistName\":\"DAVANGERE\",\"homeStateCode\":\"29\",\"homeStateName\":\"KARNATAKA\",\"memberDetailsList\":[{\"memberId\":\"1202002764801\",\"memberName\":\"VINAMALMAM\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\",\"uid\":\"Yes\"},{\"memberId\":\"12020027648010\",\"memberName\":\"Sanvi R\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764809\",\"memberName\":\"N M Sowmya\",\"relationship_code\":\"48\",\"releationship_name\":\"DAUGHTER IN LAW\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764804\",\"memberName\":\"Dayanand D\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764808\",\"memberName\":\"RUDRERSH\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764805\",\"memberName\":\"Sujatha\",\"relationship_code\":\"48\",\"releationship_name\":\"DAUGHTER IN LAW\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764806\",\"memberName\":\"Vereesh D\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764807\",\"memberName\":\"Yashavanth D\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\",\"uid\":\"Yes\"}],\"rcId\":\"120200276480\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\"}', 10.0, 'success', '2025-11-14 07:13:58'),
(131, 14, 'mobile', '6361773935', '[{\"mobile\":\"9964773935\",\"name\":\"S Sandesh\",\"fname\":\"S\\/O Sathish S\",\"address\":\"S\\/O Sathish S! !Gowdara Street Near Tharalubalu School!Nalluru Davangere!Near Tharalubalu School!DAVANAGERE!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"7353832274\",\"name\":\"H N KAMALAMMA\",\"fname\":\"shanthaveerappa s\",\"address\":\"!w\\/p shanthaveerappa s!nalluru basaveshewara!nallur!channagiri nallur!Davangere!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"701728922808\"},{\"mobile\":\"7204635947\",\"name\":\"Bhuvan M\",\"fname\":\"S\\/O T P Mallikarjuna\",\"address\":\"S\\/O T P Mallikarjuna!#71\\/1!2nd main 14th cross Main Nittuvalli Road!K T J Nagar Davanagere!Main Nittuvalli Road!DAVANAGERE!Davanagere!Karnataka!577002\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"6361773935\",\"name\":\"PRASAD\",\"fname\":\"ramdas\",\"address\":\"!!GOWDRU STREET CHANNAGIRI Nallur!!Nallur Davanagere!Karnataka!577221\",\"circle\":\"JIO KARNATKA\",\"id\":\"600612029967\"}]', 10.0, 'success', '2025-11-14 11:57:57'),
(132, 14, 'mobile', '6361773935', '[{\"mobile\":\"9964773935\",\"name\":\"S Sandesh\",\"fname\":\"S\\/O Sathish S\",\"address\":\"S\\/O Sathish S! !Gowdara Street Near Tharalubalu School!Nalluru Davangere!Near Tharalubalu School!DAVANAGERE!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"7353832274\",\"name\":\"H N KAMALAMMA\",\"fname\":\"shanthaveerappa s\",\"address\":\"!w\\/p shanthaveerappa s!nalluru basaveshewara!nallur!channagiri nallur!Davangere!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"701728922808\"},{\"mobile\":\"7204635947\",\"name\":\"Bhuvan M\",\"fname\":\"S\\/O T P Mallikarjuna\",\"address\":\"S\\/O T P Mallikarjuna!#71\\/1!2nd main 14th cross Main Nittuvalli Road!K T J Nagar Davanagere!Main Nittuvalli Road!DAVANAGERE!Davanagere!Karnataka!577002\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"6361773935\",\"name\":\"PRASAD\",\"fname\":\"ramdas\",\"address\":\"!!GOWDRU STREET CHANNAGIRI Nallur!!Nallur Davanagere!Karnataka!577221\",\"circle\":\"JIO KARNATKA\",\"id\":\"600612029967\"}]', 10.0, 'success', '2025-11-14 13:57:00'),
(133, 14, 'mobile', '8310346008', '[{\"mobile\":\"8310346008\",\"name\":\"S Sandesh\",\"fname\":\"Sathish S\",\"address\":\"S\\/O Sathish S!!Gowdara Street Near Tharalubalu School!Nalluru!Nallur Davangere!Karnataka!577221\",\"alt\":\"919568291523\",\"circle\":\"JIO KARNATKA\"},{\"mobile\":\"8310346008\",\"name\":\"Anand Patil\",\"fname\":\"Krishnaji\",\"address\":\"S\\/O Krishnaji!!!Brahampur Near jagrata Hanuman Temple H No 10 551 Rojekar Wada!GULBARGA!Karnataka!585103\",\"alt\":\"919591207422\",\"circle\":\"KARNATAKA JIO \",\"id\":\"822418777120\"}]', 10.0, 'success', '2025-11-14 14:17:27'),
(134, 14, 'aadhaar', '822418777120', '{\"respCode\":\"214\",\"respMessage\":\"Ration card not found in IMPDS\"}', 10.0, 'success', '2025-11-14 14:17:52'),
(135, 14, 'mobile', '6361773935', '[{\"mobile\":\"9964773935\",\"name\":\"S Sandesh\",\"fname\":\"S\\/O Sathish S\",\"address\":\"S\\/O Sathish S! !Gowdara Street Near Tharalubalu School!Nalluru Davangere!Near Tharalubalu School!DAVANAGERE!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"7353832274\",\"name\":\"H N KAMALAMMA\",\"fname\":\"shanthaveerappa s\",\"address\":\"!w\\/p shanthaveerappa s!nalluru basaveshewara!nallur!channagiri nallur!Davangere!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"701728922808\"},{\"mobile\":\"7204635947\",\"name\":\"Bhuvan M\",\"fname\":\"S\\/O T P Mallikarjuna\",\"address\":\"S\\/O T P Mallikarjuna!#71\\/1!2nd main 14th cross Main Nittuvalli Road!K T J Nagar Davanagere!Main Nittuvalli Road!DAVANAGERE!Davanagere!Karnataka!577002\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"6361773935\",\"name\":\"PRASAD\",\"fname\":\"ramdas\",\"address\":\"!!GOWDRU STREET CHANNAGIRI Nallur!!Nallur Davanagere!Karnataka!577221\",\"circle\":\"JIO KARNATKA\",\"id\":\"600612029967\"}]', 10.0, 'success', '2025-11-14 15:36:38'),
(136, 14, 'mobile', '8748848829', '[{\"mobile\":\"8748848829\",\"name\":\"N M Sowmya\",\"fname\":\"Rudresh A D\",\"address\":\"W\\/O Rudresh A D 19 Huchchavvanahalli Hutchavvanahalli  Huchhavvanahalli Davanagere Davangere Karnataka 577534\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"808262365427\"}]', 10.0, 'success', '2025-11-14 15:37:08'),
(137, 14, 'mobile', '9844121325', '[{\"mobile\":\"9482094410\",\"name\":\"Veeresh B G  \",\"fname\":\"S\\/O Basavarajappa G R\",\"address\":\"#130  Pump House Street  Lingadahalli  Davanagere Karnataka 577221\",\"alt\":\"9844121325\",\"circle\":\"BSNL KARNATKA\",\"id\":\"230998098940\"},{\"mobile\":\"9482092729\",\"name\":\"Veeresh B G  \",\"fname\":\"S\\/O Basavarajappa G R\",\"address\":\"#130  Pump House Street  Lingadahalli  Davanagere Karnataka 577221\",\"alt\":\"9844121325\",\"circle\":\"BSNL KARNATKA\",\"id\":\"230998098940\"},{\"mobile\":\"9448558393\",\"name\":\"VEERESH -------\",\"fname\":\"BASAVARAJAPPA G R\",\"address\":\"83 LINGADAHALLI CHANNAGIRI DAVANAGERE KARNATAKA 577221\",\"alt\":\"9844121325\",\"circle\":\"BSNL KARNATKA\",\"id\":\"MDP1455955\"},{\"mobile\":\"8310807641\",\"name\":\"JAGADISH\",\"fname\":\"Shivalingappa\",\"address\":\"S\\/O Shivalingappa!!RAITHARA STREET Nallur!NALLURU POST!nallur!Nallur!Davanagere!Karnataka!577221\",\"alt\":\"9844121325\",\"circle\":\"JIO KARNATKA\",\"id\":\"568326467890\"},{\"mobile\":\"9844121325\",\"name\":\"Veeresh B G\",\"fname\":\"Basavarajappa G R\",\"address\":\"130 Pupm House Street Channagiri Lingadahalli  Davangere Karnataka 577221\",\"alt\":\"7483275787\",\"circle\":\"KARNATAKA AIRTEL\",\"id\":\"230998098940\"}]', 10.0, 'success', '2025-11-14 15:37:53'),
(138, 14, 'mobile', '8660239659', '[{\"mobile\":\"8660239659\",\"name\":\"Shivananda P V\",\"fname\":\"Veerabadrappa\",\"address\":\"c\\/o veerabhadrappa! 00!Nallur!Nallur!nallur pete beedi channagiri taluk!nallur!davangere!Karnataka!577221\",\"alt\":\"8431968318\",\"circle\":\"JIO KARNATKA\",\"id\":\"263198368205\"}]', 10.0, 'success', '2025-11-14 15:38:23'),
(139, 14, 'mobile', '8660239659', '[{\"mobile\":\"8660239659\",\"name\":\"Shivananda P V\",\"fname\":\"Veerabadrappa\",\"address\":\"c\\/o veerabhadrappa! 00!Nallur!Nallur!nallur pete beedi channagiri taluk!nallur!davangere!Karnataka!577221\",\"alt\":\"8431968318\",\"circle\":\"JIO KARNATKA\",\"id\":\"263198368205\"}]', 10.0, 'success', '2025-11-14 15:39:20'),
(140, 14, 'aadhaar', '263198368205', '{\"address\":\"S O.P.J.JAYADEVAPPA. PETE BEEDI, NALLUR 577221.\",\"allowed_onorc\":\"Yes\",\"districtCode\":\"567\",\"dup_uid_status\":\"No\",\"fpsId\":\"757211\",\"homeDistName\":\"DAVANGERE\",\"homeStateCode\":\"29\",\"homeStateName\":\"KARNATAKA\",\"memberDetailsList\":[{\"memberId\":\"1201001886773\",\"memberName\":\"SAVITHRAMMA\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\",\"uid\":\"Yes\"},{\"memberId\":\"1201001886771\",\"memberName\":\"Veerabhadrappa P G\",\"relationship_code\":\"7\",\"releationship_name\":\"HUSBAND\",\"uid\":\"Yes\"},{\"memberId\":\"1201001886772\",\"memberName\":\"shivananda\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"}],\"rcId\":\"120100188677\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\"}', 10.0, 'success', '2025-11-14 15:39:39'),
(141, 14, 'mobile', '8762458796', '[{\"mobile\":\"8050651178\",\"name\":\"Akash B S\",\"fname\":\"B R Sathish\",\"address\":\"S\\/O  B R Sathish!155!Kumbarakeri Right Side Shimoga!!Kumbarakeri Right Side Shimoga Shimoga Shimoga!Shimoga Shimoga!Shimoga!Karnataka!577201\",\"alt\":\"8762458796\",\"circle\":\"JIO KARNATKA\",\"id\":\"656521545682\"},{\"mobile\":\"8762458796\",\"name\":\"Gurudatta Ramesh Shet\",\"fname\":\"Ramesh  Shet\",\"address\":\"S\\/O Ramesh Shet Hosa Heravatta  Heravatta Post Kumta   Uttara Kannada Karnataka 581332\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"673960563795\"}]', 10.0, 'success', '2025-11-14 15:40:17'),
(142, 14, 'aadhaar', '673960563795', '{\"respCode\":\"214\",\"respMessage\":\"Ration card not found in IMPDS\"}', 10.0, 'success', '2025-11-14 15:40:52'),
(143, 14, 'aadhaar', '656521545682', '{\"respCode\":\"214\",\"respMessage\":\"Ration card not found in IMPDS\"}', 10.0, 'success', '2025-11-14 15:41:09'),
(144, 14, 'mobile', '6361773935', '[{\"mobile\":\"9964773935\",\"name\":\"S Sandesh\",\"fname\":\"S\\/O Sathish S\",\"address\":\"S\\/O Sathish S! !Gowdara Street Near Tharalubalu School!Nalluru Davangere!Near Tharalubalu School!DAVANAGERE!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"7353832274\",\"name\":\"H N KAMALAMMA\",\"fname\":\"shanthaveerappa s\",\"address\":\"!w\\/p shanthaveerappa s!nalluru basaveshewara!nallur!channagiri nallur!Davangere!Davangere!Karnataka!577221\",\"alt\":\"6361773935\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"701728922808\"},{\"mobile\":\"7204635947\",\"name\":\"Bhuvan M\",\"fname\":\"S\\/O T P Mallikarjuna\",\"address\":\"S\\/O T P Mallikarjuna!#71\\/1!2nd main 14th cross Main Nittuvalli Road!K T J Nagar Davanagere!Main Nittuvalli Road!DAVANAGERE!Davanagere!Karnataka!577002\",\"alt\":\"6361773935\",\"circle\":\"VI KARNATKA\"},{\"mobile\":\"6361773935\",\"name\":\"PRASAD\",\"fname\":\"ramdas\",\"address\":\"!!GOWDRU STREET CHANNAGIRI Nallur!!Nallur Davanagere!Karnataka!577221\",\"circle\":\"JIO KARNATKA\",\"id\":\"600612029967\"}]', 10.0, '', '2025-11-14 17:01:45'),
(145, 14, 'mobile', '8748848829', '[{\"mobile\":\"8748848829\",\"name\":\"N M Sowmya\",\"fname\":\"Rudresh A D\",\"address\":\"W\\/O Rudresh A D 19 Huchchavvanahalli Hutchavvanahalli  Huchhavvanahalli Davanagere Davangere Karnataka 577534\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"808262365427\"}]', 10.0, 'success', '2025-11-15 07:12:51'),
(146, 14, 'mobile', '8748848829', '[{\"mobile\":\"8748848829\",\"name\":\"N M Sowmya\",\"fname\":\"Rudresh A D\",\"address\":\"W\\/O Rudresh A D 19 Huchchavvanahalli Hutchavvanahalli  Huchhavvanahalli Davanagere Davangere Karnataka 577534\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"808262365427\"}]', 10.0, 'success', '2025-11-15 07:14:27'),
(147, 14, 'aadhaar', '808262365427', '{\"address\":\"HUCHAVANAHALLI DAVANGERE T.D.\",\"allowed_onorc\":\"Yes\",\"districtCode\":\"567\",\"dup_uid_status\":\"No\",\"fpsId\":\"7896217\",\"homeDistName\":\"DAVANGERE\",\"homeStateCode\":\"29\",\"homeStateName\":\"KARNATAKA\",\"memberDetailsList\":[{\"memberId\":\"1202002764801\",\"memberName\":\"VINAMALMAM\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\",\"uid\":\"Yes\"},{\"memberId\":\"12020027648010\",\"memberName\":\"Sanvi R\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764809\",\"memberName\":\"N M Sowmya\",\"relationship_code\":\"48\",\"releationship_name\":\"DAUGHTER IN LAW\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764804\",\"memberName\":\"Dayanand D\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764808\",\"memberName\":\"RUDRERSH\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764805\",\"memberName\":\"Sujatha\",\"relationship_code\":\"48\",\"releationship_name\":\"DAUGHTER IN LAW\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764806\",\"memberName\":\"Vereesh D\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764807\",\"memberName\":\"Yashavanth D\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\",\"uid\":\"Yes\"}],\"rcId\":\"120200276480\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\"}', 10.0, 'success', '2025-11-15 07:14:44'),
(148, 14, 'aadhaar', '239572923554', '{\"address\":\"W O SATHISH S  GOWDRU STSREET\\rNallur\\rNallur PO\",\"allowed_onorc\":\"Yes\",\"districtCode\":\"567\",\"dup_uid_status\":\"No\",\"fpsId\":\"757211\",\"homeDistName\":\"DAVANGERE\",\"homeStateCode\":\"29\",\"homeStateName\":\"KARNATAKA\",\"memberDetailsList\":[{\"memberId\":\"1201001637332\",\"memberName\":\"SHIVANNA\",\"relationship_code\":\"18\",\"releationship_name\":\"FATHER IN LAW\",\"uid\":\"Yes\"},{\"memberId\":\"1201001637331\",\"memberName\":\"ROOPA\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\",\"uid\":\"Yes\"},{\"memberId\":\"1201001637333\",\"memberName\":\"Shriram Samarth\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"},{\"memberId\":\"1201001637334\",\"memberName\":\"S Sandesh\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"}],\"rcId\":\"120100163733\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\"}', 10.0, '', '2025-11-15 08:44:20'),
(149, 14, 'aadhaar', '239572923554', '{\"homeStateCode\":\"29\",\"districtCode\":\"567\",\"rcId\":\"120100163733\",\"homeStateName\":\"KARNATAKA\",\"homeDistName\":\"DAVANGERE\",\"fpsId\":\"757211\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\",\"dup_uid_status\":\"No\",\"allowed_onorc\":\"Yes\",\"address\":\"W O SATHISH S  GOWDRU STSREET\\rNallur\\rNallur PO\",\"memberDetailsList\":[{\"memberId\":\"1201001637332\",\"memberName\":\"SHIVANNA\",\"uid\":\"Yes\",\"relationship_code\":\"18\",\"releationship_name\":\"FATHER IN LAW\"},{\"memberId\":\"1201001637331\",\"memberName\":\"ROOPA\",\"uid\":\"Yes\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\"},{\"memberId\":\"1201001637333\",\"memberName\":\"Shriram Samarth\",\"uid\":\"Yes\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\"},{\"memberId\":\"1201001637334\",\"memberName\":\"S Sandesh\",\"uid\":\"Yes\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\"}],\"developer\":\"RAHUL SHARMA\"}', 10.0, 'success', '2025-11-15 08:46:45'),
(150, 15, 'aadhaar', '306631515902', '{\"respCode\":\"214\",\"respMessage\":\"Ration card not found in IMPDS\",\"developer\":\"RAHUL SHARMA\"}', 10.0, 'success', '2025-11-15 09:26:42'),
(151, 15, 'mobile', '9303482602', '[{\"mobile\":\"8467039619\",\"name\":\"Sudhir Prasad Tiwari\",\"fname\":\"dinesh prasad tiwari\",\"address\":\"s\\/o  dinesh prasad tiwari!!Lalitpur!!!panari Mahroni!lalitpur!Uttar Pradesh!284403\",\"alt\":\"9303482602\",\"circle\":\"JIO UPE\",\"id\":\"688854090286\"},{\"mobile\":\"7880943168\",\"name\":\"Shalendra Ray\",\"fname\":\"Santosh Kumar\",\"address\":\"S\\/O Santosh Kumar!Panari!Lalitpur!!Lalitpur!Lalitpur!Lalitpur!Uttar Pradesh!284403\",\"alt\":\"9303482602\",\"circle\":\"UP EAST\",\"id\":\"447435209028\"},{\"mobile\":\"8467039619\",\"name\":\"Sudhir Prasad Tiwari\",\"fname\":\"dinesh prasad tiwari\",\"address\":\"s\\/o  dinesh prasad tiwari!!Lalitpur!!!panari Mahroni!lalitpur!Uttar Pradesh!284403\",\"alt\":\"9303482602\",\"circle\":\"JIO UPE\",\"id\":\"688854090286\"},{\"mobile\":\"7880943168\",\"name\":\"Shalendra Ray\",\"fname\":\"Santosh Kumar\",\"address\":\"S\\/O Santosh Kumar!Panari!Lalitpur!!Lalitpur!Lalitpur!Lalitpur!Uttar Pradesh!284403\",\"alt\":\"9303482602\",\"circle\":\"UP EAST\",\"id\":\"447435209028\"}]', 10.0, 'success', '2025-11-15 09:27:00'),
(152, 15, 'aadhaar', '306631515902', '{\"respCode\":\"214\",\"respMessage\":\"Ration card not found in IMPDS\",\"developer\":\"RAHUL SHARMA\"}', 10.0, 'success', '2025-11-15 09:27:49'),
(153, 15, 'mobile', '6292360996', '{\"message\":\"No matching records found\",\"credit\":\"@oxmzoo\",\"developer\":\"@oxmzoo\"}', 10.0, 'success', '2025-11-15 09:28:19'),
(154, 14, 'mobile', '8748848829', '[{\"mobile\":\"8748848829\",\"name\":\"N M Sowmya\",\"fname\":\"Rudresh A D\",\"address\":\"W\\/O Rudresh A D 19 Huchchavvanahalli Hutchavvanahalli  Huchhavvanahalli Davanagere Davangere Karnataka 577534\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"808262365427\"}]', 10.0, 'success', '2025-11-15 11:09:22'),
(155, 14, 'aadhaar', '808262365427', '{\"homeStateCode\":\"29\",\"districtCode\":\"567\",\"rcId\":\"120200276480\",\"homeStateName\":\"KARNATAKA\",\"homeDistName\":\"DAVANGERE\",\"fpsId\":\"7896217\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\",\"dup_uid_status\":\"No\",\"allowed_onorc\":\"Yes\",\"address\":\"HUCHAVANAHALLI DAVANGERE T.D.\",\"memberDetailsList\":[{\"memberId\":\"1202002764801\",\"memberName\":\"VINAMALMAM\",\"uid\":\"Yes\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\"},{\"memberId\":\"12020027648010\",\"memberName\":\"Sanvi R\",\"uid\":\"Yes\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\"},{\"memberId\":\"1202002764809\",\"memberName\":\"N M Sowmya\",\"uid\":\"Yes\",\"relationship_code\":\"48\",\"releationship_name\":\"DAUGHTER IN LAW\"},{\"memberId\":\"1202002764804\",\"memberName\":\"Dayanand D\",\"uid\":\"Yes\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\"},{\"memberId\":\"1202002764808\",\"memberName\":\"RUDRERSH\",\"uid\":\"Yes\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\"},{\"memberId\":\"1202002764805\",\"memberName\":\"Sujatha\",\"uid\":\"Yes\",\"relationship_code\":\"48\",\"releationship_name\":\"DAUGHTER IN LAW\"},{\"memberId\":\"1202002764806\",\"memberName\":\"Vereesh D\",\"uid\":\"Yes\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\"},{\"memberId\":\"1202002764807\",\"memberName\":\"Yashavanth D\",\"uid\":\"Yes\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\"}],\"developer\":\"RAHUL SHARMA\"}', 10.0, 'success', '2025-11-15 11:09:39'),
(156, 14, 'mobile', '8748848829', '[{\"mobile\":\"8748848829\",\"name\":\"N M Sowmya\",\"fname\":\"Rudresh A D\",\"address\":\"W\\/O Rudresh A D 19 Huchchavvanahalli Hutchavvanahalli  Huchhavvanahalli Davanagere Davangere Karnataka 577534\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"808262365427\"}]', 10.0, 'success', '2025-11-15 11:13:14'),
(157, 14, 'mobile', '9964767731', '[{\"mobile\":\"9964767731\",\"name\":\"ROOPA    \",\"fname\":\"W\\/O SATHISH S\",\"address\":\"01 GOWDRU STsREET nallur Nallur Davangere KARNATAKA 577221\",\"alt\":\"9964452592\",\"circle\":\"KARNATAKA BSNL\",\"id\":\"XXXXXXXX3554\"},{\"mobile\":\"9964767731\",\"name\":\"ROOPA\",\"fname\":\"Sathish S\",\"address\":\"W\\/O Sathish S!!GOWDRU STsREET!!Nallur Davanagere!Karnataka!577221\",\"alt\":\"916361773935\",\"circle\":\"JIO KARNATKA\"}]', 10.0, 'success', '2025-11-15 13:20:47'),
(158, 14, 'aadhaar', '239572923554', '{\"homeStateCode\":\"29\",\"districtCode\":\"567\",\"rcId\":\"120100163733\",\"homeStateName\":\"KARNATAKA\",\"homeDistName\":\"DAVANGERE\",\"fpsId\":\"757211\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\",\"dup_uid_status\":\"No\",\"allowed_onorc\":\"Yes\",\"address\":\"W O SATHISH S  GOWDRU STSREET\\rNallur\\rNallur PO\",\"memberDetailsList\":[{\"memberId\":\"1201001637332\",\"memberName\":\"SHIVANNA\",\"uid\":\"Yes\",\"relationship_code\":\"18\",\"releationship_name\":\"FATHER IN LAW\"},{\"memberId\":\"1201001637331\",\"memberName\":\"ROOPA\",\"uid\":\"Yes\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\"},{\"memberId\":\"1201001637333\",\"memberName\":\"Shriram Samarth\",\"uid\":\"Yes\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\"},{\"memberId\":\"1201001637334\",\"memberName\":\"S Sandesh\",\"uid\":\"Yes\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\"}],\"developer\":\"RAHUL SHARMA\"}', 10.0, 'success', '2025-11-15 13:21:07'),
(159, 14, 'mobile', '8970324412', '[{\"mobile\":\"9972223750\",\"name\":\"A R Panchashari\",\"fname\":\"A N RAJAPPA\",\"address\":\"S\\/O A N RAJAPPA!!RAITHARA STREET Nallur!!Nallur Nallur Davanagere!Nallur!Davanagere!Karnataka!577221\",\"alt\":\"8970324412\",\"circle\":\"JIO KARNATKA\",\"id\":\"675247692165\"},{\"mobile\":\"8970324412\",\"name\":\"A R Panchashari\",\"fname\":\"A N Rajappa\",\"address\":\"S\\/O A N Rajappa!!RAITHARA STREET Nallur!!!Nallur!Davanagere!Karnataka!577221\",\"alt\":\"9844796380\",\"circle\":\"JIO KARNATKA\",\"id\":\"675247692165\"}]', 10.0, 'success', '2025-11-15 14:18:34'),
(160, 14, 'aadhaar', '675247692165', '{\"homeStateCode\":\"29\",\"districtCode\":\"567\",\"rcId\":\"120100158487\",\"homeStateName\":\"KARNATAKA\",\"homeDistName\":\"DAVANGERE\",\"fpsId\":\"757211\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\",\"dup_uid_status\":\"No\",\"allowed_onorc\":\"Yes\",\"address\":\"W O PANCHAKSHARI  RAITHARA STREET\\r\\r\",\"memberDetailsList\":[{\"memberId\":\"1201001584871\",\"memberName\":\"A R Panchashari\",\"uid\":\"Yes\",\"relationship_code\":\"7\",\"releationship_name\":\"HUSBAND\"},{\"memberId\":\"1201001584872\",\"memberName\":\"K S Roopa\",\"uid\":\"Yes\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\"},{\"memberId\":\"1201001584874\",\"memberName\":\"Chaithra P\",\"uid\":\"Yes\",\"relationship_code\":\"9\",\"releationship_name\":\"DAUGHTER\"},{\"memberId\":\"1201001584873\",\"memberName\":\"Likhitha P\",\"uid\":\"Yes\",\"relationship_code\":\"9\",\"releationship_name\":\"DAUGHTER\"}],\"developer\":\"RAHUL SHARMA\"}', 10.0, 'success', '2025-11-15 14:18:58'),
(162, 14, 'aadhaar', '239572923554', '{\"address\":\"W O SATHISH S  GOWDRU STSREET\\rNallur\\rNallur PO\",\"allowed_onorc\":\"Yes\",\"districtCode\":\"567\",\"dup_uid_status\":\"No\",\"fpsId\":\"757211\",\"homeDistName\":\"DAVANGERE\",\"homeStateCode\":\"29\",\"homeStateName\":\"KARNATAKA\",\"memberDetailsList\":[{\"memberId\":\"1201001637332\",\"memberName\":\"SHIVANNA\",\"relationship_code\":\"18\",\"releationship_name\":\"FATHER IN LAW\",\"uid\":\"Yes\"},{\"memberId\":\"1201001637331\",\"memberName\":\"ROOPA\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\",\"uid\":\"Yes\"},{\"memberId\":\"1201001637333\",\"memberName\":\"Shriram Samarth\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"},{\"memberId\":\"1201001637334\",\"memberName\":\"S Sandesh\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"}],\"rcId\":\"120100163733\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\"}', 10.0, 'success', '2025-11-15 17:17:14'),
(163, 14, 'mobile', '8748848829', '[{\"mobile\":\"8748848829\",\"name\":\"N M Sowmya\",\"fname\":\"Rudresh A D\",\"address\":\"W\\/O Rudresh A D 19 Huchchavvanahalli Hutchavvanahalli  Huchhavvanahalli Davanagere Davangere Karnataka 577534\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"808262365427\"}]', 10.0, 'success', '2025-11-16 07:51:04'),
(164, 14, 'mobile', '8748848829', '[{\"mobile\":\"8748848829\",\"name\":\"N M Sowmya\",\"fname\":\"Rudresh A D\",\"address\":\"W\\/O Rudresh A D 19 Huchchavvanahalli Hutchavvanahalli  Huchhavvanahalli Davanagere Davangere Karnataka 577534\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"808262365427\"}]', 10.0, 'success', '2025-11-16 07:51:43'),
(165, 14, 'mobile', '8748848829', '[{\"mobile\":\"8748848829\",\"name\":\"N M Sowmya\",\"fname\":\"Rudresh A D\",\"address\":\"W\\/O Rudresh A D 19 Huchchavvanahalli Hutchavvanahalli  Huchhavvanahalli Davanagere Davangere Karnataka 577534\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"808262365427\"}]', 10.0, 'success', '2025-11-16 07:51:49'),
(166, 14, 'mobile', '8748848826', '[{\"mobile\":\"8747809758\",\"name\":\"PALLAVI N R\",\"fname\":\"DO N RAJANNA \",\"address\":\"D\\/O N Rajanna!D\\/O N Rajanna  550\\/1!Kaipete!Davangere Near Basaveshwara Temple!DAVANAGERE-DAVANAGERE!KA!577001\",\"alt\":\"8748848826\",\"circle\":\"VI KARNATKA\",\"id\":\"600911682325\"},{\"mobile\":\"8748848826\",\"name\":\"Pallavi N R\",\"fname\":\"N  Rajanna\",\"address\":\"D\\/O N Rajanna 550\\/1  Kaipete Davanagere Davanagere Near Basaveshwara Temple Karnataka 577001\",\"alt\":\"9986264042\",\"circle\":\"AIRTEL KARNATKA\"}]', 10.0, 'success', '2025-11-16 07:51:53'),
(168, 14, 'mobile', '8748848829', '[{\"mobile\":\"8748848829\",\"name\":\"N M Sowmya\",\"fname\":\"Rudresh A D\",\"address\":\"W\\/O Rudresh A D 19 Huchchavvanahalli Hutchavvanahalli  Huchhavvanahalli Davanagere Davangere Karnataka 577534\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"808262365427\"}]', 10.0, 'success', '2025-11-16 08:18:43'),
(169, 14, 'aadhaar', '675247692165', '{\"address\":\"W O PANCHAKSHARI  RAITHARA STREET\\r\\r\",\"allowed_onorc\":\"Yes\",\"districtCode\":\"567\",\"dup_uid_status\":\"No\",\"fpsId\":\"757211\",\"homeDistName\":\"DAVANGERE\",\"homeStateCode\":\"29\",\"homeStateName\":\"KARNATAKA\",\"memberDetailsList\":[{\"memberId\":\"1201001584871\",\"memberName\":\"A R Panchashari\",\"relationship_code\":\"7\",\"releationship_name\":\"HUSBAND\",\"uid\":\"Yes\"},{\"memberId\":\"1201001584872\",\"memberName\":\"K S Roopa\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\",\"uid\":\"Yes\"},{\"memberId\":\"1201001584874\",\"memberName\":\"Chaithra P\",\"relationship_code\":\"9\",\"releationship_name\":\"DAUGHTER\",\"uid\":\"Yes\"},{\"memberId\":\"1201001584873\",\"memberName\":\"Likhitha P\",\"relationship_code\":\"9\",\"releationship_name\":\"DAUGHTER\",\"uid\":\"Yes\"}],\"rcId\":\"120100158487\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\"}', 10.0, 'success', '2025-11-16 08:19:02'),
(170, 14, 'mobile', '8748848829', '[{\"mobile\":\"8748848829\",\"name\":\"N M Sowmya\",\"fname\":\"Rudresh A D\",\"address\":\"W\\/O Rudresh A D 19 Huchchavvanahalli Hutchavvanahalli  Huchhavvanahalli Davanagere Davangere Karnataka 577534\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"808262365427\"}]', 10.0, 'success', '2025-11-16 11:11:41'),
(171, 14, 'aadhaar', '808262365427', '{\"address\":\"HUCHAVANAHALLI DAVANGERE T.D.\",\"allowed_onorc\":\"Yes\",\"districtCode\":\"567\",\"dup_uid_status\":\"No\",\"fpsId\":\"7896217\",\"homeDistName\":\"DAVANGERE\",\"homeStateCode\":\"29\",\"homeStateName\":\"KARNATAKA\",\"memberDetailsList\":[{\"memberId\":\"1202002764801\",\"memberName\":\"VINAMALMAM\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\",\"uid\":\"Yes\"},{\"memberId\":\"12020027648010\",\"memberName\":\"Sanvi R\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764809\",\"memberName\":\"N M Sowmya\",\"relationship_code\":\"48\",\"releationship_name\":\"DAUGHTER IN LAW\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764804\",\"memberName\":\"Dayanand D\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764808\",\"memberName\":\"RUDRERSH\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764805\",\"memberName\":\"Sujatha\",\"relationship_code\":\"48\",\"releationship_name\":\"DAUGHTER IN LAW\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764806\",\"memberName\":\"Vereesh D\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\",\"uid\":\"Yes\"},{\"memberId\":\"1202002764807\",\"memberName\":\"Yashavanth D\",\"relationship_code\":\"34\",\"releationship_name\":\"GRAND SON\",\"uid\":\"Yes\"}],\"rcId\":\"120200276480\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\"}', 10.0, 'success', '2025-11-16 11:11:56'),
(172, 14, 'mobile', '9972377784', '[{\"mobile\":\"9972377784\",\"name\":\"Naveena Kumara M S\",\"fname\":\"Mohan D S\",\"address\":\"S\\/O Mohan D S!!Nallur!CHANNAGIRI!channagiri nallur!nallur!davanagere!Karnataka!577221\",\"alt\":\"7483884895\",\"circle\":\"JIO KARNATKA\",\"id\":\"979467838307\"}]', 10.0, 'success', '2025-11-16 11:27:32'),
(173, 14, 'aadhaar', '979467838307', '{\"address\":\"S o Late.Subbaraya Shet Nalluru Channagiri - 577221\",\"allowed_onorc\":\"Yes\",\"districtCode\":\"567\",\"dup_uid_status\":\"No\",\"fpsId\":\"757211\",\"homeDistName\":\"DAVANGERE\",\"homeStateCode\":\"29\",\"homeStateName\":\"KARNATAKA\",\"memberDetailsList\":[{\"memberId\":\"1201001892294\",\"memberName\":\"GEETHA\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\",\"uid\":\"Yes\"},{\"memberId\":\"1201001892293\",\"memberName\":\"PREETHI M\",\"relationship_code\":\"9\",\"releationship_name\":\"DAUGHTER\",\"uid\":\"Yes\"},{\"memberId\":\"1201001892292\",\"memberName\":\"Naveena Kumara M S\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"}],\"rcId\":\"120100189229\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\"}', 10.0, 'success', '2025-11-16 11:27:55'),
(174, 14, 'mobile', '9381054537', '[{\"mobile\":\"9381054537\",\"name\":\"ChakaliRamesh\",\"fname\":\"Hanumanthappa\",\"address\":\"S\\/O Hanumanthappa!!H.No.1-65 IBRAHIMPURAM IBRAHIMPURAM!NANDAVARAMMD!Ibharampuram Kurnool!Andhra Pradesh!518345\",\"circle\":\"JIO AP\"}]', 10.0, 'success', '2025-11-17 05:26:29'),
(175, 14, 'mobile', '9343169383', '[{\"mobile\":\"8105435022\",\"name\":\"Manoj N S\",\"fname\":\"SHIVALINGAPPA\",\"address\":\"S\\/O SHIVALINGAPPA!!FARMER STREET Nallur!CHANNAGIRI!CHANNAGIRI Nallur Nallur Davanagere!Nallur!Davanagere!Karnataka!577221\",\"alt\":\"9343169383\",\"circle\":\"JIO KARNATKA\",\"id\":\"530511616477\"},{\"mobile\":\"6360652625\",\"name\":\"Manoj N S\",\"fname\":\"Shivalingappa\",\"address\":\"S\\/O Shivalingappa!!FARMER STREET Nallur!CHANNAGIRI!!Nallur!Davanagere!Karnataka!577221\",\"alt\":\"9343169383\",\"circle\":\"JIO KARNATKA\",\"id\":\"530511616477\"},{\"mobile\":\"9343169383\",\"name\":\"Manoj N S\",\"fname\":\"SHIVALINGAPPA\",\"address\":\"S\\/O SHIVALINGAPPA!!FARMER STREET Nallur!CHANNAGIRI!!Nallur!Davanagere!Karnataka!577221\",\"alt\":\"8880166099\",\"circle\":\"JIO KARNATKA\",\"id\":\"530511616477\"}]', 10.0, 'success', '2025-11-17 05:27:12'),
(176, 14, 'aadhaar', '530511616477', '{\"address\":\"Shivalingappa S o Nanjundappa Raitara Beedi Nallur Channagiri Ta Davangere dist\",\"allowed_onorc\":\"Yes\",\"districtCode\":\"567\",\"dup_uid_status\":\"No\",\"fpsId\":\"757211\",\"homeDistName\":\"DAVANGERE\",\"homeStateCode\":\"29\",\"homeStateName\":\"KARNATAKA\",\"memberDetailsList\":[{\"memberId\":\"1201002279551\",\"memberName\":\"VISHALAKSHI\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\",\"uid\":\"Yes\"},{\"memberId\":\"1201002279553\",\"memberName\":\"Rakshitha N S\",\"relationship_code\":\"9\",\"releationship_name\":\"DAUGHTER\",\"uid\":\"Yes\"},{\"memberId\":\"1201002279552\",\"memberName\":\"Manoj N S\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"},{\"memberId\":\"1201002279550\",\"memberName\":\"SHIVALINGAPPA\",\"relationship_code\":\"7\",\"releationship_name\":\"HUSBAND\",\"uid\":\"Yes\"}],\"rcId\":\"120100227955\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\"}', 10.0, 'success', '2025-11-17 05:27:32'),
(177, 14, 'mobile', '7003061488', '[{\"mobile\":\"7003061488\",\"name\":\"Paresh Chandra Naskar\",\"fname\":\"krishnapada naskar\",\"address\":\"!s\\/o krishnapada naskar!asuti!!ganneygangadharpur!asuti!south 24 parganas!West Bengal!700141\",\"alt\":\"9433367038\",\"circle\":\"JIO KOL\",\"id\":\"603456837449\"},{\"mobile\":\"7003061488\",\"name\":\"Paresh Chandra Naskar\",\"fname\":\"krishnapada naskar\",\"address\":\"!s\\/o krishnapada naskar!asuti!!ganneygangadharpur!asuti!south 24 parganas!West Bengal!700141\",\"alt\":\"9433367038\",\"circle\":\"JIO KOL\",\"id\":\"603456837449\"}]', 10.0, 'success', '2025-11-17 14:07:08'),
(178, 14, 'aadhaar', '603456837449', '{\"respCode\":\"214\",\"respMessage\":\"Ration card not found in IMPDS\"}', 10.0, 'success', '2025-11-17 14:07:31'),
(179, 14, 'mobile', '8044131266', '{\"message\":\"No matching records found\",\"credit\":\"@oxmzoo\",\"developer\":\"@oxmzoo\"}', 10.0, 'success', '2025-11-18 14:01:57'),
(208, 16, 'mobile', '9844121325', '[{\"mobile\":\"9482094410\",\"name\":\"Veeresh B G  \",\"fname\":\"S\\/O Basavarajappa G R\",\"address\":\"#130  Pump House Street  Lingadahalli  Davanagere Karnataka 577221\",\"alt\":\"9844121325\",\"circle\":\"BSNL KARNATKA\",\"id\":\"230998098940\"},{\"mobile\":\"9482092729\",\"name\":\"Veeresh B G  \",\"fname\":\"S\\/O Basavarajappa G R\",\"address\":\"#130  Pump House Street  Lingadahalli  Davanagere Karnataka 577221\",\"alt\":\"9844121325\",\"circle\":\"BSNL KARNATKA\",\"id\":\"230998098940\"},{\"mobile\":\"9448558393\",\"name\":\"VEERESH -------\",\"fname\":\"BASAVARAJAPPA G R\",\"address\":\"83 LINGADAHALLI CHANNAGIRI DAVANAGERE KARNATAKA 577221\",\"alt\":\"9844121325\",\"circle\":\"BSNL KARNATKA\",\"id\":\"MDP1455955\"},{\"mobile\":\"8310807641\",\"name\":\"JAGADISH\",\"fname\":\"Shivalingappa\",\"address\":\"S\\/O Shivalingappa!!RAITHARA STREET Nallur!NALLURU POST!nallur!Nallur!Davanagere!Karnataka!577221\",\"alt\":\"9844121325\",\"circle\":\"JIO KARNATKA\",\"id\":\"568326467890\"},{\"mobile\":\"9844121325\",\"name\":\"Veeresh B G\",\"fname\":\"Basavarajappa G R\",\"address\":\"130 Pupm House Street Channagiri Lingadahalli  Davangere Karnataka 577221\",\"alt\":\"7483275787\",\"circle\":\"KARNATAKA AIRTEL\",\"id\":\"230998098940\"}]', 10.0, 'success', '2025-11-20 11:57:54'),
(209, 16, 'mobile', '9945291558', '[{\"mobile\":\"9844679159\",\"name\":\"Rudrappa K\",\"fname\":\"Krishnappa\",\"address\":\"! 14!near road!!thilineerkatte!Shimoga nallur!Davangere!Karnataka!577221\",\"alt\":\"9945291558\",\"circle\":\"JIO KARNATKA\",\"id\":\"931894246237\"},{\"mobile\":\"9036316138\",\"name\":\"MARUTHI \",\"fname\":\"DEVENDRAPA \",\"address\":\"!KUMBARAHATTI!Somlapura!!Somlapura Davanagere!CHANNAPURA!Davangere!Karnataka!577218\",\"alt\":\"9945291558\",\"circle\":\"AIRTEL KARNATKA\",\"id\":\"963728117320\"},{\"mobile\":\"8217565417\",\"name\":\"Rudrappa K\",\"fname\":\"krishnappa\",\"address\":\"s\\/o krishnappa! 14!near road!!. . thilineerkatte!nallur!davangere!Karnataka!577221\",\"alt\":\"9945291558\",\"circle\":\"JIO KARNATKA\",\"id\":\"931894246237\"},{\"mobile\":\"9945291558\",\"name\":\"Rudrappa  K\",\"fname\":\"Krishnappa   \",\"address\":\"S\\/O Krishnappa 14  thilineerkatte  Nallur Davangere  Karnataka 577221\",\"circle\":\"KARNATAKA AIRTEL\"}]', 10.0, 'success', '2025-11-20 11:58:44'),
(210, 16, 'aadhaar', '931894246237', '{\"address\":\"W O Rudrappa K . . jayanthi nagara near anjaneya temple Nallur\",\"allowed_onorc\":\"Yes\",\"districtCode\":\"567\",\"dup_uid_status\":\"No\",\"fpsId\":\"757211\",\"homeDistName\":\"DAVANGERE\",\"homeStateCode\":\"29\",\"homeStateName\":\"KARNATAKA\",\"memberDetailsList\":[{\"memberId\":\"1201001960411\",\"memberName\":\"Sumalatha S\",\"relationship_code\":\"1\",\"releationship_name\":\"SELF\",\"uid\":\"Yes\"},{\"memberId\":\"1201001960414\",\"memberName\":\"Yuktha J R\",\"relationship_code\":\"9\",\"releationship_name\":\"DAUGHTER\",\"uid\":\"Yes\"},{\"memberId\":\"1201001960410\",\"memberName\":\"RUDRAPPA.K\",\"relationship_code\":\"7\",\"releationship_name\":\"HUSBAND\",\"uid\":\"Yes\"},{\"memberId\":\"1201001960413\",\"memberName\":\"Dhanush J R\",\"relationship_code\":\"8\",\"releationship_name\":\"SON\",\"uid\":\"Yes\"}],\"rcId\":\"120100196041\",\"schemeId\":\"PHH\",\"schemeName\":\"PHH\"}', 10.0, 'success', '2025-11-20 11:59:50');

-- --------------------------------------------------------

--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `status` enum('open','closed','pending') DEFAULT 'open',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `support_tickets`
--

INSERT INTO `support_tickets` (`id`, `user_id`, `title`, `body`, `status`, `created_at`, `updated_at`) VALUES
(9, 16, 'Support', 'Support Chat', 'open', '2025-11-19 15:48:09', '2025-11-19 15:48:09'),
(10, 16, 'Admin Chat (AI Widget)', '', 'open', '2025-11-20 05:39:26', '2025-11-20 05:39:26'),
(11, 2, 'Admin Chat (AI Widget)', '', 'open', '2025-11-20 02:07:24', '2025-11-20 06:37:24');

-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `type` enum('credit','debit') NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `balance_after` decimal(10,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `type`, `amount`, `description`, `balance_after`, `created_at`) VALUES
(1, 16, 'credit', 11.00, 'Payment Approved - ORD-1763541873-16', 31.00, '2025-11-19 04:17:37'),
(2, 16, 'credit', 11.00, 'Payment Approved - ORD-1763541873-16', 42.00, '2025-11-19 04:19:00'),
(3, 16, 'credit', 11.00, 'Payment Approved - ORD-1763541873-16', 53.00, '2025-11-19 04:19:05'),
(4, 16, 'credit', 11.00, 'Payment Approved - ORD-1763541873-16', 64.00, '2025-11-19 04:27:07'),
(5, 16, 'credit', 11.00, 'Payment Approved - ORD-1763546095-16', 75.00, '2025-11-19 05:32:32'),
(6, 16, 'credit', 11.00, 'Payment Approved - ORD-1763546095-16', 86.00, '2025-11-19 05:33:55'),
(7, 16, 'credit', 11.00, 'Payment Approved - ORD-1763546095-16', 97.00, '2025-11-19 05:34:09'),
(8, 16, 'credit', 111.00, 'Payment Approved - ORD-1763543354-16', 208.00, '2025-11-19 05:34:34'),
(9, 16, 'credit', 11.00, 'Payment Approved - ORD-1763546095-16', 219.00, '2025-11-19 05:35:09'),
(10, 16, 'credit', 111.00, 'Payment Approved - ORD-1763543354-16', 208.00, '2025-11-19 05:35:23'),
(11, 16, 'credit', 100.00, 'Payment Approved - ORD-1763545526-16', 200.00, '2025-11-19 05:37:03'),
(12, 16, 'credit', 50.00, 'Payment Approved - ORD-1763547004-9135', 50.00, '2025-11-19 05:40:04'),
(13, 16, 'credit', 100.00, 'Payment Approved - ORD-1763546989-16', 150.00, '2025-11-19 05:40:19'),
(14, 16, 'credit', 100.00, 'Payment Approved - ORD-1763547087-16', 250.00, '2025-11-19 05:41:47'),
(15, 16, 'credit', 232.00, 'Payment Approved - ORD-1763547663-16', 472.00, '2025-11-19 05:51:26'),
(16, 16, 'credit', 100.00, 'Payment Approved - ORD-1763565443-16', 442.00, '2025-11-19 10:47:53');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('user','admin') DEFAULT 'user',
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `login_blocked` tinyint(1) NOT NULL DEFAULT 0,
  `can_search` tinyint(1) NOT NULL DEFAULT 1,
  `wallet_frozen` tinyint(1) NOT NULL DEFAULT 0,
  `credit_limit` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `wallet_balance` int(11) DEFAULT 0,
  `email_verified` tinyint(1) DEFAULT 0,
  `email_verified_at` datetime DEFAULT NULL,
  `otp_bypass_by_admin` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `password`, `role`, `settings`, `is_active`, `login_blocked`, `can_search`, `wallet_frozen`, `credit_limit`, `created_at`, `updated_at`, `wallet_balance`, `email_verified`, `email_verified_at`, `otp_bypass_by_admin`) VALUES
(1, 'System Admin', 'admin@gmail.com', '$2y$12$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin', NULL, 1, 0, 0, 0, 0, '2025-11-12 10:27:20', '2025-11-13 12:06:54', 0, 0, NULL, 0),
(2, 'Admin', 'ssandy8435@gmail.com', '$2y$12$9HktjeBMePtzj7f1ZsEE4u8E.Tq942CyLs3ljCw.a9bhXLynM5RGe', 'admin', NULL, 1, 0, 0, 0, 0, '2025-11-12 10:31:07', '2025-11-13 13:44:29', 0, 0, NULL, 0),
(14, 'Samarth', 'samarth12@gmail.com', '$2y$12$rBw/kDhRt3EKzyDAQ4GQTuPC0kq//krm2nhZ0LQJKsR2UsJm/bQUu', 'user', NULL, 1, 0, 1, 0, 0, '2025-11-13 21:10:03', '2025-11-15 11:13:32', 0, 0, NULL, 0),
(15, 'Nitin thakur', 'digitalnitin123@gmail.com', '$2y$12$4d6GM6xzP4hmYngfVQ1ewOCAFjUpGrNJ2zJmNEjQtX9cGnvgFLdZm', 'user', NULL, 1, 0, 1, 0, 0, '2025-11-15 03:55:05', '2025-11-15 14:22:57', 0, 0, NULL, 0),
(16, 'Roopa', 'samarths0805@gmail.com', '$2y$12$jFgG2AINhBIdVyJcgIhfi.57RkRDhuXpSteE1fW.qK4xnpbTpDwcC', 'user', NULL, 1, 0, 1, 0, 0, '2025-11-15 08:52:03', '2025-11-20 08:29:34', 0, 0, NULL, 0),
(18, 'demo12', 'demo12@gmail.com', '$2y$12$XP1HekE8c//w13B.6D.3YOsCl3C3aXYNZ1GAmj4iXD8mu1G8N3rFi', 'user', NULL, 1, 0, 1, 0, 0, '2025-11-19 02:02:31', '2025-11-19 06:32:31', 0, 0, NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `wallets`
--

CREATE TABLE `wallets` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `balance` decimal(10,2) DEFAULT 0.00,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wallets`
--

INSERT INTO `wallets` (`id`, `user_id`, `balance`, `updated_at`) VALUES
(1, 1, 0.00, '2025-11-14 17:00:34'),
(2, 2, 0.00, '2025-11-12 10:31:07'),
(16, 14, 3142.00, '2025-11-18 14:01:56'),
(17, 15, 60.00, '2025-11-15 09:28:19'),
(18, 16, 337.00, '2025-11-20 08:05:38'),
(20, 18, 12.00, '2025-11-19 08:29:21');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin_messages`
--
ALTER TABLE `admin_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_id` (`admin_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `admin_settings`
--
ALTER TABLE `admin_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

--
-- Indexes for table `audit_logs`
--
ALTER TABLE `audit_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `chatbot_chats`
--
ALTER TABLE `chatbot_chats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `chatbot_messages`
--
ALTER TABLE `chatbot_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_chat_id` (`chat_id`),
  ADD KEY `idx_sender_id` (`sender_id`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `email_otps`
--
ALTER TABLE `email_otps`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `payment_details`
--
ALTER TABLE `payment_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment_orders`
--
ALTER TABLE `payment_orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_id` (`order_id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_order_id` (`order_id`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `search_cache`
--
ALTER TABLE `search_cache`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `search_logs`
--
ALTER TABLE `search_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `wallets`
--
ALTER TABLE `wallets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_messages`
--
ALTER TABLE `admin_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_settings`
--
ALTER TABLE `admin_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;

--
-- AUTO_INCREMENT for table `audit_logs`
--
ALTER TABLE `audit_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=446;

--
-- AUTO_INCREMENT for table `chatbot_chats`
--
ALTER TABLE `chatbot_chats`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `chatbot_messages`
--
ALTER TABLE `chatbot_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `email_otps`
--
ALTER TABLE `email_otps`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `payment_details`
--
ALTER TABLE `payment_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `payment_orders`
--
ALTER TABLE `payment_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `search_cache`
--
ALTER TABLE `search_cache`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `search_logs`
--
ALTER TABLE `search_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=211;

--
-- AUTO_INCREMENT for table `support_tickets`
--
ALTER TABLE `support_tickets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `wallets`
--
ALTER TABLE `wallets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `admin_messages`
--
ALTER TABLE `admin_messages`
  ADD CONSTRAINT `admin_messages_ibfk_1` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `admin_messages_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `audit_logs`
--
ALTER TABLE `audit_logs`
  ADD CONSTRAINT `audit_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `chatbot_chats`
--
ALTER TABLE `chatbot_chats`
  ADD CONSTRAINT `chatbot_chats_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `chatbot_messages`
--
ALTER TABLE `chatbot_messages`
  ADD CONSTRAINT `chatbot_messages_ibfk_1` FOREIGN KEY (`chat_id`) REFERENCES `chatbot_chats` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `chatbot_messages_ibfk_2` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payment_orders`
--
ALTER TABLE `payment_orders`
  ADD CONSTRAINT `payment_orders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `permissions`
--
ALTER TABLE `permissions`
  ADD CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `search_logs`
--
ALTER TABLE `search_logs`
  ADD CONSTRAINT `search_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD CONSTRAINT `support_tickets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `wallets`
--
ALTER TABLE `wallets`
  ADD CONSTRAINT `wallets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
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 */;
