-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 01, 2026 at 03:16 AM
-- Server version: 8.0.45-cll-lve
-- PHP Version: 8.1.34

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

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

--
-- Table structure for table `audits`
--

CREATE TABLE `audits` (
  `id` bigint UNSIGNED NOT NULL,
  `auditable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `auditable_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `event` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ;

--
-- Dumping data for table `audits`
--

INSERT INTO `audits` (`id`, `auditable_type`, `auditable_id`, `user_id`, `event`, `old_values`, `new_values`, `ip_address`, `user_agent`, `created_at`, `updated_at`) VALUES
(1, 'App\\Models\\Setting', 1, NULL, 'created', NULL, '{\"id\":1,\"site_name\":\"Saleem Sial Analytics\",\"tagline\":\"GA4, GTM and performance tracking specialist\",\"logo\":\"uploads\\/logos\\/saleem-sial-logo.png\",\"logo_media_id\":1,\"favicon\":\"uploads\\/placeholders\\/saleem-sial-favicon.png\",\"favicon_media_id\":3,\"contact_email\":\"hello@saleemsial.com\",\"contact_phone\":\"+92 300 1234567\",\"footer_text\":\"Saleem Sial Analytics builds clean, scalable tracking systems for advertisers, agencies, and growth teams.\",\"social_links\":\"{\\\"facebook\\\":\\\"https:\\\\\\/\\\\\\/facebook.com\\\\\\/#\\\",\\\"instagram\\\":\\\"https:\\\\\\/\\\\\\/instagram.com\\\\\\/#\\\",\\\"x\\\":\\\"https:\\\\\\/\\\\\\/x.com\\\\\\/#\\\",\\\"linkedin\\\":\\\"https:\\\\\\/\\\\\\/linkedin.com\\\\\\/#\\\"}\",\"header_cta_label\":\"Book a Consultation\",\"header_cta_url\":\"\\/contact\",\"footer_cta_label\":\"Start Your Tracking Setup\",\"footer_cta_url\":\"\\/contact\",\"admin_contact_notifications_enabled\":true,\"user_contact_auto_reply_enabled\":true,\"support_chat_enabled\":true,\"support_chat_title\":\"Need quick support?\",\"support_chat_intro\":\"Send a direct message about your tracking issue and we will follow up by email.\",\"support_chat_button_label\":\"Send support message\",\"admin_contact_subject\":\"New website inquiry from {{ name }}\",\"admin_contact_template\":\"<p>You have received a new inquiry on {{ site_name }}.<\\/p>\\n<p><strong>Name:<\\/strong> {{ name }}<\\/p>\\n<p><strong>Email:<\\/strong> {{ email }}<\\/p>\\n<p><strong>Phone:<\\/strong> {{ phone }}<\\/p>\\n<p><strong>Source:<\\/strong> {{ source_label }}<\\/p>\\n<p><strong>Page URL:<\\/strong> {{ page_url }}<\\/p>\\n<p><strong>Submitted:<\\/strong> {{ submitted_at }}<\\/p>\\n<p><strong>Message:<\\/strong><\\/p>\\n<p>{{ message }}<\\/p>\",\"user_contact_subject\":\"Thanks for contacting {{ site_name }}\",\"user_contact_template\":\"<p>Hello {{ name }},<\\/p>\\n<p>Thanks for reaching out to {{ site_name }}. Your message has been received and we will respond as soon as possible.<\\/p>\\n<p><strong>Source:<\\/strong> {{ source_label }}<\\/p>\\n<p><strong>Your message:<\\/strong><\\/p>\\n<p>{{ message }}<\\/p>\\n<p>You can reply directly to {{ contact_email }} if you need to share more details.<\\/p>\",\"gtm_container_id\":null,\"ga_measurement_id\":null}', '::1', 'curl/8.13.0', '2026-03-28 06:05:30', '2026-03-28 06:05:30');

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

--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `badge` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reading_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `excerpt` text COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `featured_image_media_id` bigint UNSIGNED DEFAULT NULL,
  `sort_order` int UNSIGNED NOT NULL DEFAULT '0',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `is_published` tinyint(1) NOT NULL DEFAULT '1',
  `published_at` timestamp NULL DEFAULT NULL,
  `seo_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_posts`
--

INSERT INTO `blog_posts` (`id`, `title`, `slug`, `badge`, `reading_time`, `excerpt`, `content`, `featured_image_media_id`, `sort_order`, `is_featured`, `is_published`, `published_at`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES
(1, 'How to audit a GA4 and GTM setup before scaling paid traffic', 'how-to-audit-a-ga4-and-gtm-setup-before-scaling-paid-traffic', 'Featured guide', '7 min read', 'A simple framework for checking events, conversions, tags, naming, and data quality before you make optimization decisions from broken reporting.', '<p>Start with the events that matter most to revenue and lead quality.</p><p>Then confirm that every conversion action is mapped consistently across GA4, Google Ads, and any supporting CRM or form tools.</p><p>Finally, review naming, triggers, and QA notes inside GTM so the setup stays maintainable as campaigns scale.</p>', 5, 0, 1, 1, '2026-03-23 06:05:30', 'How to Audit a GA4 and GTM Setup Before Scaling Paid Traffic', 'Use this checklist to validate GA4 and GTM before scaling paid traffic and making decisions from bad data.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(2, 'What to validate after a fresh GA4 implementation', 'what-to-validate-after-a-fresh-ga4-implementation', 'GA4', '5 min read', 'A quick checklist for event naming, conversion setup, enhanced measurement, filters, and reporting sanity checks.', '<p>Validate the events first so your reports reflect the actions that actually matter.</p><p>Then confirm conversions, filters, and reporting views before anyone uses the data for campaign decisions.</p>', 7, 1, 0, 1, '2026-03-24 06:05:30', 'What to Validate After a Fresh GA4 Implementation', 'A quick GA4 post-launch checklist for events, conversions, filters, and reporting sanity checks.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(3, 'How to keep your GTM container organized as campaigns grow', 'how-to-keep-your-gtm-container-organized-as-campaigns-grow', 'GTM', '6 min read', 'A practical structure for folders, tag naming, triggers, variables, and QA notes so scaling does not create chaos.', '<p>Use folders, naming conventions, and documentation from the beginning.</p><p>A clean GTM workspace makes audits, updates, and handoffs much easier as the account becomes more complex.</p>', 9, 2, 0, 1, '2026-03-25 06:05:30', 'How to Keep Your GTM Container Organized as Campaigns Grow', 'Structure your GTM container with folders, naming rules, and QA notes so it stays manageable as campaigns scale.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(4, 'What a useful Looker Studio dashboard should actually include', 'what-a-useful-looker-studio-dashboard-should-actually-include', 'Dashboards', '4 min read', 'Build reporting views that help teams act faster by focusing on trend context, conversion quality, and business-ready KPIs.', '<p>A useful dashboard should explain performance, not just display metrics.</p><p>Focus on KPIs, trend context, and the decisions each view is meant to support.</p>', 11, 3, 0, 1, '2026-03-26 06:05:30', 'What a Useful Looker Studio Dashboard Should Include', 'Learn what makes a Looker Studio dashboard actionable for reporting, optimization, and stakeholder communication.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(5, 'When server-side tracking is worth the extra setup', 'when-server-side-tracking-is-worth-the-extra-setup', 'Server-Side', '8 min read', 'Learn when the extra implementation effort improves data quality, privacy compliance, and platform attribution enough to matter.', '<p>Server-side tracking is most useful when browser-side loss is affecting attribution and optimization.</p><p>The extra setup pays off when better data quality improves reporting confidence and ad platform feedback loops.</p>', 19, 4, 0, 1, '2026-03-27 06:05:30', 'When Server-Side Tracking Is Worth the Extra Setup', 'See when server-side tracking improves attribution, privacy, and reporting enough to justify the added implementation work.', '2026-03-28 06:05:30', '2026-03-28 06:05:30');

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'new',
  `read_at` timestamp NULL DEFAULT NULL,
  `replied_at` timestamp NULL DEFAULT NULL,
  `notified_at` timestamp NULL DEFAULT NULL,
  `admin_notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extension` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` bigint UNSIGNED DEFAULT NULL,
  `width` int UNSIGNED DEFAULT NULL,
  `height` int UNSIGNED DEFAULT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_system` tinyint(1) NOT NULL DEFAULT '0',
  `uploaded_by` bigint UNSIGNED DEFAULT NULL,
  `alt_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `name`, `file_path`, `disk`, `type`, `mime_type`, `extension`, `size`, `width`, `height`, `category`, `is_system`, `uploaded_by`, `alt_text`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, 'Saleem Sial Logo PNG', 'uploads/system/saleem-sial-logo.png', 'public', 'image', 'image/png', 'png', 5013, 560, 120, 'branding', 1, NULL, 'Saleem Sial Analytics logo', 0, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(2, 'Saleem Sial Logo', 'uploads/system/saleem-sial-logo.jpeg', 'public', 'image', 'image/jpeg', 'jpeg', 9307, 300, 181, 'branding', 1, NULL, 'Saleem Sial Analytics logo', 1, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(3, 'Saleem Sial Favicon', 'uploads/system/saleem-sial-favicon.png', 'public', 'image', 'image/png', 'png', 1206, 64, 64, 'branding', 1, NULL, 'Saleem Sial Analytics favicon', 2, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(4, 'Default Favicon', 'uploads/system/default-favicon.ico', 'public', 'image', 'application/x-empty', 'ico', 0, NULL, NULL, 'branding', 1, NULL, 'Saleem Sial Analytics favicon', 3, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(5, 'Analytics Dashboard Hero', 'uploads/system/hero-analytics-dashboard.svg', 'public', 'image', 'image/svg+xml', 'svg', 3721, NULL, NULL, 'hero', 1, NULL, 'Illustrated analytics dashboard preview', 4, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(6, 'GA4 Service Image', 'uploads/media/2jfV7sDvnzxNqDruKT45yev8aeQvMHLXHQoowUtM.webp', 'public', 'image', 'image/webp', 'webp', 103478, 850, 669, 'service-image', 0, NULL, 'GA4 service image', 5, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(7, 'GA4 Service Icon', 'uploads/media/v79FaD7gAYHhwhCVU9jXaW6Wyo19v4wpO9OFcmuQ.png', 'public', 'image', 'image/png', 'png', 19391, 250, 250, 'service-icon', 0, NULL, 'GA4 service icon', 6, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(8, 'GTM Service Image', 'uploads/media/6CjrhLevKyKTEg5X52DUr8LRDdQJESmjFCnueG4W.png', 'public', 'image', 'image/png', 'png', 131222, 1857, 1067, 'service-image', 0, NULL, 'GTM service image', 7, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(9, 'GTM Service Icon', 'uploads/media/kiMpmVYtvcfuAtyLh02wRHiwsu2vLmTiV6kQpQYl.jpg', 'public', 'image', 'image/jpeg', 'jpg', 39237, 1200, 1200, 'service-icon', 0, NULL, 'GTM service icon', 8, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(10, 'Looker Studio Service Image', 'uploads/media/UVIb8sZBOy3DJRF4pYk5rO19RyPe1albJ1xEojni.png', 'public', 'image', 'image/png', 'png', 59317, 600, 336, 'service-image', 0, NULL, 'Looker Studio service image', 9, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(11, 'Looker Studio Service Icon', 'uploads/media/Y4Bi7JUJUcsDY20kUyTIBtVMZKoSRUljI2g5AXoN.png', 'public', 'image', 'image/png', 'png', 89268, 420, 375, 'service-icon', 0, NULL, 'Looker Studio service icon', 10, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(12, 'Google Ads Service Image', 'uploads/media/nx7tqNOE2Md4WPPJZzuLLohQRmPxaaniDb6oBPRQ.png', 'public', 'image', 'image/png', 'png', 45366, 622, 599, 'service-image', 0, NULL, 'Google Ads service image', 11, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(13, 'Google Ads Service Icon', 'uploads/media/s9G0trlaaAP9twGJP9LWkGaxLMNoMgl0uLnchQ7q.png', 'public', 'image', 'image/png', 'png', 32562, 500, 624, 'service-icon', 0, NULL, 'Google Ads service icon', 12, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(14, 'Meta Ads Service Image', 'uploads/media/oLV2M4zm3xkLMAJw2XHglJ2xs4Ejcm8II8smXSrb.png', 'public', 'image', 'image/png', 'png', 258818, 1163, 720, 'service-image', 0, NULL, 'Meta Ads service image', 13, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(15, 'Meta Ads Service Icon', 'uploads/media/HcPhcJm39jfEcKKBzswosdyEpf1uoIXLTLXBaqW5.png', 'public', 'image', 'image/png', 'png', 5550, 348, 196, 'service-icon', 0, NULL, 'Meta Ads service icon', 14, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(16, 'TikTok Ads Service Image', 'uploads/media/j7cTcFcX5wqiMhsfhk4lBuGGEHKs1Qo4M6qMqcmW.png', 'public', 'image', 'image/png', 'png', 431127, 1000, 523, 'service-image', 0, NULL, 'TikTok Ads service image', 15, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(17, 'TikTok Ads Service Icon', 'uploads/media/zYN1PnqHn8r1OPnyHYMS29Xvw8xqA9V1BdRG7NqK.png', 'public', 'image', 'image/png', 'png', 5375, 300, 168, 'service-icon', 0, NULL, 'TikTok Ads service icon', 16, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(18, 'Server Side Tracking Service Image', 'uploads/media/e8bTxQAhm5KtudWpwVuUuQzV7jt6ethzBLHghSuU.png', 'public', 'image', 'image/png', 'png', 333157, 1200, 675, 'service-image', 0, NULL, 'Server side tracking service image', 17, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(19, 'Server Side Tracking Service Icon', 'uploads/media/iJcm5ue8eXcbASnWFv0OMQgo4xkilmSfM3vT7Gd8.png', 'public', 'image', 'image/png', 'png', 248001, 1400, 788, 'service-icon', 0, NULL, 'Server side tracking service icon', 18, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(20, 'Trusted Logo 1', 'uploads/system/trusted-1.png', 'public', 'image', 'image/png', 'png', 3419, 226, 64, 'trusted-logo', 1, NULL, 'Trusted partner logo 1', 19, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(21, 'Trusted Logo 2', 'uploads/system/trusted-2.png', 'public', 'image', 'image/png', 'png', 2072, 210, 64, 'trusted-logo', 1, NULL, 'Trusted partner logo 2', 20, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(22, 'Trusted Logo 3', 'uploads/system/trusted-3.png', 'public', 'image', 'image/png', 'png', 3569, 210, 64, 'trusted-logo', 1, NULL, 'Trusted partner logo 3', 21, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(23, 'Trusted Logo 4', 'uploads/system/trusted-4.png', 'public', 'image', 'image/png', 'png', 2876, 210, 64, 'trusted-logo', 1, NULL, 'Trusted partner logo 4', 22, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(24, 'Trusted Logo 5', 'uploads/system/trusted-5.png', 'public', 'image', 'image/png', 'png', 3171, 210, 64, 'trusted-logo', 1, NULL, 'Trusted partner logo 5', 23, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(25, 'Why Tracking Trend Icon', 'uploads/system/why-tracking-trending.png', 'public', 'image', 'image/png', 'png', 2931, 118, 119, 'feature-icon', 1, NULL, 'Trend icon', 24, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(26, 'Why Tracking Cloud Icon', 'uploads/system/why-tracking-cloud.png', 'public', 'image', 'image/png', 'png', 3667, 119, 122, 'feature-icon', 1, NULL, 'Cloud icon', 25, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(27, 'Why Tracking Task Icon', 'uploads/system/why-tracking-task.png', 'public', 'image', 'image/png', 'png', 2303, 112, 113, 'feature-icon', 1, NULL, 'Task icon', 26, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(28, 'Why Tracking Speedometer Icon', 'uploads/system/why-tracking-speedometer.png', 'public', 'image', 'image/png', 'png', 3484, 121, 121, 'feature-icon', 1, NULL, 'Speedometer icon', 27, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(29, 'Bar chart Icon', 'uploads/system/benefit-bar-chart.png', 'public', 'image', 'image/png', 'png', 731, 96, 96, 'benefit-icon', 1, NULL, 'Bar chart icon', 28, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(30, 'Pie chart Icon', 'uploads/system/benefit-pie-chart.png', 'public', 'image', 'image/png', 'png', 2195, 96, 96, 'benefit-icon', 1, NULL, 'Pie chart icon', 29, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(31, 'Sparkles Icon', 'uploads/system/benefit-sparkles.png', 'public', 'image', 'image/png', 'png', 2194, 96, 96, 'benefit-icon', 1, NULL, 'Sparkles icon', 30, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(32, 'Workflows Icon', 'uploads/system/benefit-workflows.png', 'public', 'image', 'image/png', 'png', 1646, 128, 128, 'benefit-icon', 1, NULL, 'Workflows icon', 31, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(33, 'File Icon', 'uploads/system/benefit-file.png', 'public', 'image', 'image/png', 'png', 1010, 96, 96, 'benefit-icon', 1, NULL, 'File icon', 32, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(34, 'Circles Icon', 'uploads/system/benefit-circles.png', 'public', 'image', 'image/png', 'png', 3011, 96, 96, 'benefit-icon', 1, NULL, 'Circles icon', 33, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(35, 'Case Study 1 Before Dashboard', 'uploads/system/case-study-1-before.svg', 'public', 'image', 'image/svg+xml', 'svg', 1991, NULL, NULL, 'case-study', 1, NULL, 'Before dashboard screenshot for lead generation case study', 34, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(36, 'Case Study 1 After Dashboard', 'uploads/system/case-study-1-after.svg', 'public', 'image', 'image/svg+xml', 'svg', 1990, NULL, NULL, 'case-study', 1, NULL, 'After dashboard screenshot for lead generation case study', 35, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(37, 'Case Study 2 Before Dashboard', 'uploads/system/case-study-2-before.svg', 'public', 'image', 'image/svg+xml', 'svg', 1991, NULL, NULL, 'case-study', 1, NULL, 'Before dashboard screenshot for paid media reporting case study', 36, '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(38, 'Case Study 2 After Dashboard', 'uploads/system/case-study-2-after.svg', 'public', 'image', 'image/svg+xml', 'svg', 1990, NULL, NULL, 'case-study', 1, NULL, 'After dashboard screenshot for paid media reporting case study', 37, '2026-03-28 06:05:30', '2026-03-28 06:05:30');

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

--
-- Table structure for table `media_usages`
--

CREATE TABLE `media_usages` (
  `id` bigint UNSIGNED NOT NULL,
  `media_id` bigint UNSIGNED NOT NULL,
  `usable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `usable_id` bigint UNSIGNED NOT NULL,
  `field_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_03_06_000001_create_services_table', 1),
(5, '2026_03_06_000002_create_pages_table', 1),
(6, '2026_03_06_000003_create_settings_table', 1),
(7, '2026_03_06_000004_create_contacts_table', 1),
(8, '2026_03_06_000005_create_media_table', 1),
(9, '2026_03_09_000001_add_role_to_users_table', 1),
(10, '2026_03_09_000002_add_category_to_services_table', 1),
(11, '2026_03_09_000003_add_tags_and_sort_order_to_services_table', 1),
(12, '2026_03_09_000004_create_audits_table', 1),
(13, '2026_03_09_000005_add_sort_order_to_media_table', 1),
(14, '2026_03_16_000001_add_template_and_sections_to_pages_table', 1),
(15, '2026_03_16_000002_add_frontend_fields_to_settings_table', 1),
(16, '2026_03_16_100001_add_workflow_fields_to_contacts_table', 1),
(17, '2026_03_16_100002_expand_media_table_for_library', 1),
(18, '2026_03_16_100003_create_media_usages_table', 1),
(19, '2026_03_16_100004_add_media_references_to_services_and_settings', 1),
(20, '2026_03_16_100005_create_visits_table', 1),
(21, '2026_03_16_100006_add_country_and_contact_mail_fields', 1),
(22, '2026_03_16_100007_add_google_tag_fields_and_traffic_sources', 1),
(23, '2026_03_16_100008_create_roles_table', 1),
(24, '2026_03_16_100009_add_role_id_and_support_chat_fields', 1),
(25, '2026_03_16_120000_add_access_level_to_roles_table', 1),
(26, '2026_03_16_130001_create_blog_posts_table', 1),
(27, '2026_03_17_120000_add_permissions_to_roles_table', 1),
(28, '2026_03_17_130000_add_smtp_fields_to_settings_table', 1);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `template` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `sections` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `meta_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `title`, `slug`, `template`, `content`, `sections`, `meta_title`, `meta_description`, `created_at`, `updated_at`) VALUES
(1, 'Home', 'home', 'home', '<p>Saleem Sial Analytics helps growth teams build trustworthy measurement across websites, ads, and reporting stacks.</p>', '{\"hero\":{\"eyebrow\":\"Built for modern measurement\",\"eyebrow_highlight\":\"Track with confidence\",\"title_html\":\"<span class=\\\"ssa-hero-title__prefix\\\">Accurate tracking for every<\\/span><span class=\\\"prespa-saas-animated-text\\\" data-typed-words=\\\"Analytics|Tracking|Reporting|Advertising|Meta Ads|TikTok Ads|Google Ads|Google Analytics 4\\\">Analytics<\\/span>\",\"description\":\"From GA4 and GTM to ad pixels, dashboards, and server-side tracking, Saleem Sial Analytics helps you measure what matters and act on data you can trust.\",\"primary_cta_label\":\"Explore Services\",\"primary_cta_url\":\"\\/services\",\"secondary_cta_label\":\"Contact Saleem\",\"secondary_cta_url\":\"\\/contact\",\"image_media_id\":5,\"platforms\":[{\"label\":\"GA4\",\"media_id\":7},{\"label\":\"GTM\",\"media_id\":9},{\"label\":\"Looker Studio\",\"media_id\":11},{\"label\":\"Google Ads\",\"media_id\":13},{\"label\":\"Meta Ads\",\"media_id\":15},{\"label\":\"TikTok Ads\",\"media_id\":17},{\"label\":\"Server-Side\",\"media_id\":19}]},\"trusted\":{\"title\":\"Trusted by marketing teams that need cleaner reporting and better conversion visibility.\",\"logos\":[{\"label\":\"Trusted logo 1\",\"media_id\":20},{\"label\":\"Trusted logo 2\",\"media_id\":21},{\"label\":\"Trusted logo 3\",\"media_id\":22},{\"label\":\"Trusted logo 4\",\"media_id\":23},{\"label\":\"Trusted logo 5\",\"media_id\":24}]},\"why_tracking\":{\"badge\":\"Why tracking matters\",\"title\":\"Clear data creates better campaigns, better reporting, and better decisions.\",\"description\":\"When attribution breaks, every marketing decision gets harder. A strong tracking foundation gives your team visibility into performance, lead quality, and return on ad spend.\",\"cta_label\":\"About Saleem Sial\",\"cta_url\":\"\\/about\",\"items\":[{\"media_id\":25,\"title\":\"Know what actually converts\",\"description\":\"Measure critical actions across landing pages, forms, checkout flows, and ad platforms without guesswork.\"},{\"media_id\":26,\"title\":\"Reduce reporting noise\",\"description\":\"Bring paid media, analytics, and CRM signals into one cleaner source of truth for faster reporting.\"},{\"media_id\":27,\"title\":\"Scale without constant rework\",\"description\":\"Build GTM containers, naming conventions, and event structures that stay organized as campaigns grow.\"},{\"media_id\":28,\"title\":\"Stay accurate in a privacy-first web\",\"description\":\"Use server-side tracking and better implementation patterns to reduce data loss and improve attribution quality.\"}]},\"services_intro\":{\"badge\":\"Core tracking services\",\"title\":\"Measurement systems tailored to the platforms you rely on.\",\"description\":\"Every service below is managed from the database so it can later move directly into a full CMS workflow.\"},\"pricing\":{\"badge\":\"Pricing & packages\",\"title\":\"Competitor-aligned starter packages for setup, cleanup, and growth support.\",\"description\":\"These example packages are positioned around common freelancer and boutique-consultant ranges for GA4, GTM, ads tracking, and reporting support.\",\"audit_title\":\"Not sure which package fits? Start with a free audit request.\",\"audit_description\":\"If you already have analytics or paid media running, request a free audit first and get a cleaner recommendation based on your current setup.\",\"audit_label\":\"Request Free Audit\",\"packages\":[{\"badge\":\"Starter\",\"name\":\"Tracking Tune-Up\",\"price\":\"From $149\",\"timeline\":\"Typical delivery: 2-4 days\",\"summary\":\"Ideal for fixing GA4 events, cleaning up conversions, or repairing a small GTM setup.\",\"items\":[\"GA4 or GTM cleanup for one website\",\"Conversion checks and QA notes\",\"Short Loom or written handoff\"]},{\"badge\":\"Most requested\",\"featured\":true,\"name\":\"Cross-Channel Setup\",\"price\":\"From $349\",\"timeline\":\"Typical delivery: 4-7 days\",\"summary\":\"A stronger package for GA4, GTM, Google Ads, and Meta or TikTok event mapping on active campaigns.\",\"items\":[\"GA4 + GTM implementation or rebuild\",\"Ads platform conversion setup\",\"Naming structure, testing, and reporting checks\"]},{\"badge\":\"Advanced\",\"name\":\"Server-Side & Reporting Build\",\"price\":\"From $699\",\"timeline\":\"Typical delivery: 1-2 weeks\",\"summary\":\"Best for privacy-aware measurement, multi-platform reporting, and more advanced attribution support.\",\"items\":[\"Server-side or advanced tracking architecture\",\"Dashboard\\/reporting layer setup\",\"Implementation plan for scale and governance\"]}]},\"security\":{\"badge\":\"Security & governance\",\"title\":\"Cleaner tracking should also be safer, better documented, and easier to control.\",\"description\":\"The implementation approach focuses on permission control, privacy-aware measurement, and workflows that reduce accidental changes later.\",\"cta_label\":\"Request Free Audit\",\"items\":[{\"media_id\":33,\"title\":\"Documented tagging changes\",\"description\":\"Keep event naming, trigger logic, and reporting notes easier to review before new campaigns launch.\"},{\"media_id\":32,\"title\":\"Permission-aware GTM workflows\",\"description\":\"Reduce mistakes by structuring containers and publishing steps around clearer ownership.\"},{\"media_id\":34,\"title\":\"Privacy-ready measurement\",\"description\":\"Support browser restrictions with better consent-aware implementations and server-side options.\"},{\"media_id\":29,\"title\":\"Safer reporting handoff\",\"description\":\"Build dashboards and reporting layers that stakeholders can trust without direct tag edits.\"}]},\"case_studies\":{\"badge\":\"Case studies\",\"title\":\"Dashboard snapshots that show the difference between noisy data and a cleaner setup.\",\"description\":\"Use before-and-after screenshots to explain how implementation changes improve clarity, attribution, and reporting confidence.\",\"studies\":[{\"label\":\"Lead generation\",\"title\":\"GA4 + GTM repair for a paid traffic funnel\",\"summary\":\"The original reporting mixed duplicate events with missing form conversions. After the rebuild, campaign reporting clearly separated qualified leads from low-intent traffic.\",\"result\":\"Result: cleaner form conversion visibility and faster weekly reporting.\",\"before_media_id\":35,\"after_media_id\":36},{\"label\":\"Ecommerce tracking\",\"title\":\"Cross-platform dashboard cleanup for ads and analytics\",\"summary\":\"The first version forced the team to compare Meta, Google Ads, and GA4 manually. The new dashboard made spend, ROAS, and assisted conversions easier to explain in one place.\",\"result\":\"Result: clearer paid media reporting and fewer stakeholder questions.\",\"before_media_id\":37,\"after_media_id\":38}]},\"contact_options\":{\"badge\":\"Get in touch\",\"title\":\"Request a free audit, ask about pricing, or message directly.\",\"description\":\"Use whichever contact option fits your workflow best: contact form, email, WhatsApp, or support chat.\",\"headline\":\"Choose the fastest route for your tracking question.\"},\"benefits\":{\"badge\":\"Benefits\",\"highlight\":\"Built for accurate reporting\",\"title\":\"Why businesses choose Saleem Sial Analytics\",\"description\":\"You get a setup that is easier to trust, easier to explain, and easier to scale.\",\"items\":[{\"media_id\":29,\"title\":\"Reliable event data\",\"description\":\"Capture the right user actions and send them to the right destinations with confidence.\"},{\"media_id\":30,\"title\":\"Cross-platform reporting\",\"description\":\"Connect ad platforms and analytics tools so performance can be reviewed in one place.\"},{\"media_id\":31,\"title\":\"Smarter optimization\",\"description\":\"Improve campaign decisions with cleaner conversion signals and reporting clarity.\"},{\"media_id\":32,\"title\":\"Repeatable implementation\",\"description\":\"Documented tagging, naming, and tracking structures that support long-term growth.\"},{\"media_id\":33,\"title\":\"Faster stakeholder reporting\",\"description\":\"Create dashboards and summaries that make performance easier to understand and act on.\"},{\"media_id\":34,\"title\":\"Privacy-aware measurement\",\"description\":\"Support modern browser restrictions with better architecture and server-side options.\"}]},\"cta\":{\"title\":\"Ready to fix your tracking foundation?\",\"description\":\"Let\'s build a cleaner measurement stack for your website, ads, and reporting workflow.\",\"button_label\":\"Book a Tracking Consultation\",\"button_url\":\"\\/contact\"}}', 'Saleem Sial Analytics | GA4, GTM and Performance Tracking', 'Saleem Sial Analytics helps businesses implement GA4, GTM, ad tracking, dashboards, and server-side measurement with reliable data.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(2, 'About', 'about', 'about', '<p>Saleem Sial Analytics specializes in implementation, measurement strategy, and reporting systems that help businesses understand real performance.</p>', '{\"hero\":{\"eyebrow\":\"About Saleem Sial Analytics\",\"title\":\"Measurement strategy built around clarity, trust, and growth.\",\"description\":\"This practice focuses on helping brands and agencies build dependable tracking systems that support better decisions across analytics, media, and reporting.\"},\"intro\":{\"title\":\"What we do\",\"content\":\"We implement GA4, GTM, ad platform tracking, dashboards, and server-side setups so businesses can report with confidence and optimize based on cleaner data.\"},\"mission\":{\"title\":\"Our mission\",\"content\":\"To make modern measurement easier to understand and easier to manage by turning fragmented tracking setups into structured, scalable systems.\"},\"expertise\":{\"title\":\"How we help\",\"items\":[\"Audit tracking setups and find gaps in implementation.\",\"Build event, conversion, and pixel tracking for websites and campaigns.\",\"Create reporting layers that turn data into action.\"]},\"why_choose\":{\"title\":\"Why choose us\",\"items\":[\"A focused specialization in analytics and tracking.\",\"Implementation that is built for future CMS and admin workflows.\",\"Clean documentation and scalable structures that are easier to maintain later.\"]},\"cta\":{\"title\":\"Need help improving your measurement stack?\",\"button_label\":\"Contact Us\",\"button_url\":\"\\/contact\"}}', 'About Saleem Sial Analytics', 'Learn how Saleem Sial Analytics helps teams build reliable tracking and reporting systems.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(3, 'Blog', 'blog', 'blog', '<p>Insights and practical notes from Saleem Sial Analytics on measurement, reporting, and analytics implementation.</p>', '{\"hero\":{\"eyebrow\":\"Blog & Insights\",\"title\":\"Practical notes on cleaner tracking, reporting, and analytics decisions.\",\"description\":\"Use this page to share implementation tips, audits, case studies, and strategy insights around GA4, GTM, dashboards, and ad tracking.\"},\"featured\":{\"badge\":\"Featured guide\",\"title\":\"How to audit a GA4 and GTM setup before scaling paid traffic\",\"excerpt\":\"A simple framework for checking events, conversions, tags, naming, and data quality before you make optimization decisions from broken reporting.\",\"reading_time\":\"7 min read\",\"slug\":\"how-to-audit-a-ga4-and-gtm-setup-before-scaling-paid-traffic\",\"content\":\"Start with the events that matter most to revenue and lead quality.\\n\\nThen confirm that every conversion action is mapped consistently across GA4, Google Ads, and any supporting CRM or form tools.\\n\\nFinally, review naming, triggers, and QA notes inside GTM so the setup stays maintainable as campaigns scale.\",\"media_id\":5},\"posts_intro\":{\"badge\":\"Latest articles\",\"title\":\"Topics you can publish and update from the CMS\",\"description\":\"Use these cards as a starter structure for blog posts, case studies, technical explainers, or performance reporting guides.\"},\"posts\":[{\"badge\":\"GA4\",\"title\":\"What to validate after a fresh GA4 implementation\",\"excerpt\":\"A quick checklist for event naming, conversion setup, enhanced measurement, filters, and reporting sanity checks.\",\"reading_time\":\"5 min read\",\"slug\":\"what-to-validate-after-a-fresh-ga4-implementation\",\"content\":\"Validate the events first so your reports reflect the actions that actually matter.\\n\\nThen confirm conversions, filters, and reporting views before anyone uses the data for campaign decisions.\"},{\"badge\":\"GTM\",\"title\":\"How to keep your GTM container organized as campaigns grow\",\"excerpt\":\"A practical structure for folders, tag naming, triggers, variables, and QA notes so scaling does not create chaos.\",\"reading_time\":\"6 min read\",\"slug\":\"how-to-keep-your-gtm-container-organized-as-campaigns-grow\",\"content\":\"Use folders, naming conventions, and documentation from the beginning.\\n\\nA clean GTM workspace makes audits, updates, and handoffs much easier as the account becomes more complex.\"},{\"badge\":\"Dashboards\",\"title\":\"What a useful Looker Studio dashboard should actually include\",\"excerpt\":\"Build reporting views that help teams act faster by focusing on trend context, conversion quality, and business-ready KPIs.\",\"reading_time\":\"4 min read\",\"slug\":\"what-a-useful-looker-studio-dashboard-should-actually-include\",\"content\":\"A useful dashboard should explain performance, not just display metrics.\\n\\nFocus on KPIs, trend context, and the decisions each view is meant to support.\"},{\"badge\":\"Server-Side\",\"title\":\"When server-side tracking is worth the extra setup\",\"excerpt\":\"Learn when the extra implementation effort improves data quality, privacy compliance, and platform attribution enough to matter.\",\"reading_time\":\"8 min read\",\"slug\":\"when-server-side-tracking-is-worth-the-extra-setup\",\"content\":\"Server-side tracking is most useful when browser-side loss is affecting attribution and optimization.\\n\\nThe extra setup pays off when better data quality improves reporting confidence and ad platform feedback loops.\"}],\"cta\":{\"title\":\"Need help turning insights into a working setup?\",\"description\":\"Get support with GA4, GTM, dashboard reporting, and performance tracking that is built for long-term clarity.\",\"button_label\":\"Contact Saleem\",\"button_url\":\"\\/contact\"}}', 'Blog | Saleem Sial Analytics', 'Read Saleem Sial Analytics insights on GA4, GTM, dashboards, ad tracking, and modern measurement strategy.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(4, 'Tracking and analytics services built for modern growth teams.', 'services', 'services', '<p>Browse the full service catalog, filter by category, and request a free audit or direct support from any page.</p>', NULL, 'Services', 'Explore GA4, GTM, dashboard, ad tracking, and server-side analytics services from Saleem Sial Analytics.', '2026-03-28 06:05:30', '2026-03-28 06:05:30');

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `access_level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
  `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `is_system` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `slug`, `description`, `access_level`, `permissions`, `is_system`, `created_at`, `updated_at`) VALUES
(1, 'Administrator', 'admin', 'Full access to settings, media, users, roles, and content management.', 'admin', '[\"dashboard.view\",\"contacts.view\",\"contacts.update\",\"contacts.delete\",\"pages.view\",\"pages.create\",\"pages.update\",\"pages.delete\",\"blog_posts.view\",\"blog_posts.create\",\"blog_posts.update\",\"blog_posts.delete\",\"services.view\",\"services.create\",\"services.update\",\"services.delete\",\"settings.view\",\"settings.update\",\"settings.refresh\",\"media.view\",\"media.upload\",\"media.replace\",\"media.delete\",\"media.reorder\",\"users.view\",\"users.create\",\"users.update\",\"users.delete\",\"roles.view\",\"roles.create\",\"roles.update\",\"roles.delete\",\"audits.view\",\"backups.download\"]', 1, '2026-03-28 06:05:29', '2026-03-28 06:05:29'),
(2, 'Editor', 'editor', 'Can manage pages, services, and inbound messages.', 'editor', '[\"dashboard.view\",\"contacts.view\",\"contacts.update\",\"contacts.delete\",\"pages.view\",\"pages.create\",\"pages.update\",\"pages.delete\",\"blog_posts.view\",\"blog_posts.create\",\"blog_posts.update\",\"blog_posts.delete\",\"services.view\",\"services.create\",\"services.update\",\"services.delete\"]', 1, '2026-03-28 06:05:29', '2026-03-28 06:05:29'),
(3, 'User', 'user', 'Basic authenticated user with no admin panel access.', 'user', '[]', 1, '2026-03-28 06:05:29', '2026-03-28 06:05:29');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `sort_order` int NOT NULL DEFAULT '0',
  `short_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `long_description` text COLLATE utf8mb4_unicode_ci,
  `hero_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `benefits` text COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_media_id` bigint UNSIGNED DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_media_id` bigint UNSIGNED DEFAULT NULL,
  `seo_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `title`, `slug`, `category`, `tags`, `sort_order`, `short_description`, `long_description`, `hero_title`, `benefits`, `image`, `image_media_id`, `icon`, `icon_media_id`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES
(1, 'Google Analytics 4 (GA4) Setup', 'google-analytics-4-ga4-setup', 'Analytics', '[\"analytics\",\"ga4\",\"reporting\"]', 0, 'Event tracking, conversions, reporting.', '<p>Full GA4 implementation for websites and landing pages, including event planning, conversion setup, and reporting structures designed around business goals.</p><p>We make sure your analytics account is organized, your event names are meaningful, and your reports are easier to trust.</p>', 'Accurate GA4 Setup That Shows Real Business Results', 'Event tracking\nConversion setup\nReporting clarity\nReliable data', 'uploads/placeholders/ga4.jpg', 6, 'uploads/placeholders/ga4-icon.png', 7, 'GA4 Setup Services', 'Get accurate GA4 tracking and reporting for your website.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(2, 'Google Tag Manager (GTM)', 'google-tag-manager-gtm', 'Tracking', '[\"tag-management\",\"tracking\",\"gtm\"]', 1, 'Custom tags, triggers, server-side tracking.', '<p>GTM setup for scalable tracking, tags, triggers, variables, and cleaner deployment workflows.</p><p>This includes data layer planning, event mapping, and an implementation structure that can support server-side expansion later.</p>', 'Flexible Tag Management Without Editing Code Again and Again', 'Custom tags\nTrigger logic\nData layer planning\nScalable implementation', 'uploads/placeholders/gtm.jpg', 8, 'uploads/placeholders/gtm-icon.png', 9, 'GTM Setup Services', 'Scalable Google Tag Manager configuration.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(3, 'Looker Studio Dashboards', 'looker-studio-dashboards', 'Reporting', '[\"dashboards\",\"reporting\",\"looker\"]', 2, 'Unified reporting across platforms.', '<p>Build executive and marketing dashboards that connect GA4, Google Ads, Meta Ads, and other data sources into one reporting system.</p><p>We focus on clarity, KPI relevance, and dashboards that are simple for teams and clients to understand.</p>', 'Clear Dashboards for Smarter Decisions', 'Cross-platform reporting\nDashboard automation\nSimplified KPIs', 'uploads/placeholders/looker.jpg', 10, 'uploads/placeholders/looker-icon.png', 11, 'Looker Studio Dashboard Services', 'Unified dashboards for marketing and analytics.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(4, 'Google Ads Tracking', 'google-ads-tracking', 'Advertising', '[\"advertising\",\"ads\",\"tracking\"]', 3, 'Conversion tracking, ROI measurement.', '<p>Set up conversion tracking for Google Ads campaigns so you can measure leads, sales, and return on ad spend with more confidence.</p><p>We align goals, tags, and reporting so campaign performance is easier to optimize.</p>', 'Track Google Ads Conversions With Confidence', 'Accurate conversions\nROI visibility\nCampaign measurement', 'uploads/placeholders/google-ads.jpg', 12, 'uploads/placeholders/google-ads-icon.png', 13, 'Google Ads Tracking Services', 'Accurate conversion measurement for Google Ads.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(5, 'Meta Ads Tracking (Facebook/Instagram)', 'meta-ads-tracking-facebook-instagram', 'Advertising', '[\"advertising\",\"meta\",\"pixel\"]', 4, 'Pixel setup, campaign measurement.', '<p>Configure Meta Pixel and campaign measurement for Facebook and Instagram ad funnels with stronger event coverage and cleaner attribution.</p><p>We help ensure your key actions are visible to both your team and the platform.</p>', 'Better Meta Pixel Tracking for Better Ad Decisions', 'Pixel setup\nEvent tracking\nAttribution improvement', 'uploads/placeholders/meta.jpg', 14, 'uploads/placeholders/meta-icon.png', 15, 'Meta Ads Tracking Services', 'High quality Meta Pixel setup and measurement.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(6, 'TikTok Ads Tracking', 'tiktok-ads-tracking', 'Advertising', '[\"advertising\",\"tiktok\",\"tracking\"]', 5, 'Event tracking, audience insights.', '<p>TikTok tracking setup for events, conversions, and audience behavior insights that support performance-focused campaigns.</p><p>The goal is a cleaner handoff between website activity and platform optimization signals.</p>', 'Smarter TikTok Tracking for Performance Campaigns', 'Event setup\nConversion data\nAudience insights', 'uploads/placeholders/tiktok.jpg', 16, 'uploads/placeholders/tiktok-icon.png', 17, 'TikTok Ads Tracking Services', 'Detailed analytics for TikTok campaigns.', '2026-03-28 06:05:30', '2026-03-28 06:05:30'),
(7, 'Server-Side Tracking', 'server-side-tracking', 'Privacy', '[\"privacy\",\"server-side\",\"tracking\"]', 6, 'Advanced tracking for data accuracy and privacy.', '<p>Advanced server-side tracking implementation to reduce data loss, improve attribution, and support privacy-focused measurement strategies.</p><p>This is ideal for businesses that need stronger data continuity across browsers and platforms.</p>', 'More Accurate Tracking With Better Data Control', 'Better accuracy\nPrivacy support\nReduced tracking loss', 'uploads/placeholders/server-side.jpg', 18, 'uploads/placeholders/server-side-icon.png', 19, 'Server Side Tracking Services', 'Enhanced accuracy with server side data collection.', '2026-03-28 06:05:30', '2026-03-28 06:05:30');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('08OrKJRW6V3UOyAo99F07uh8fFUjgpvC4SjszJnn', NULL, '103.115.186.159', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQW1wcm0zMTZleE9qTHBseVMxMHpqUG5GcEtVUVRNanFSODlDZUZ5OSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774811169),
('0jghH0zT7r1SwaTN1MYtcdqBs8U4FJ3bhU3Nd6O3', NULL, '142.111.108.197', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWWphZGQ5MTBmM2NKSTczc05FZWxQWW9NWFB1SlNZaEl6N0JDaTh2UiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774811620),
('0mdqLfj3lNQrb0Cn9m9PQ0aeK9VO29memde5s7n6', NULL, '52.41.174.91', 'Mozilla/5.0 (Linux; Android 8.0.0; SM-G965U Build/R16NW) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.7680.153 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNFh6WFhFYXV3dm1OM1kyMDFRSmpBSTg2czBoM2FlM3czSnNKVDlhUiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vd3d3LnNhbGVlbXNhaWwueHNvZnRkZXZlbG9wLmNvbSI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774769791),
('0UbcL1Sp8797H9e8NXSwYNSWhu2ZJK6AhhZbTckm', NULL, '52.41.174.91', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.7680.153 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRUZVU3dzb2t3b3F5OVFHZEVqTXZCaEJYWUMwNFBWWWZWM2tqaG1RTCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vd3d3LnNhbGVlbXNhaWwueHNvZnRkZXZlbG9wLmNvbSI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774769780),
('12OaWZ8y6Ard3dQ3U0bfqBBGQY4Fq6jUi8CwXspb', NULL, '66.249.83.103', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVXM1d2dFdnJJeUdkYWRpdVk5ZjkyejdXUWRNOFhLcUJoQ1h5WEltQSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL3NlcnZpY2VzIjtzOjU6InJvdXRlIjtzOjE0OiJzZXJ2aWNlcy5pbmRleCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774847087),
('1B8OLGrjTJgPAbFdsLRCqtdMRyQE7TbI8eH0lwv8', NULL, '143.110.144.83', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUGpUUGo2MGRoZFY5RGVRd25yUVpSMmo5WkJ1c0VVcHpOdmJDaVRQQSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774787927),
('1wpbmvxRWl9M7qizAAxV3dcvk1fC42IXg7PfiaAx', NULL, '66.249.83.103', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTFJnSmZROUpyV1pLTFBZQjZRRlhNOU5JY2dxME9TODVlZVc5ZkNKayI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDM6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL2NvbnRhY3QiO3M6NToicm91dGUiO3M6NzoiY29udGFjdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774846794),
('22v3ScsWKqVKDmjRlVGMBHBPxABMq8frBacAKFxZ', NULL, '74.7.241.157', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36; compatible; OAI-SearchBot/1.3; robots.txt; +https://openai.com/searchbot', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNTVjQ0pNRWhQeHVXa1d1Z2VvZTkycTZWOHkxU1hPTThPdVBLdmY1SiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTA6Imh0dHBzOi8vd3d3LnNhbGVlbXNhaWwueHNvZnRkZXZlbG9wLmNvbS9yb2JvdHMudHh0IjtzOjU6InJvdXRlIjtzOjY6InJvYm90cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774915924),
('2gdKpZVFyNYGldvEQAR50C0uPAsi96PhdzjtKCGT', NULL, '35.87.148.36', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiM1FTZ1lZOG0xajNOWWdSNUUyNmpKZVh1ZkVYeTgwajJIeXQ4Y0VYViI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774699733),
('2oBTZVUAk0TxsLRkvvQeEqaifOaCc5iUGwRRk63Y', NULL, '137.184.80.36', 'Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVFV6NG53TldBRUgzemZkNHhzRXBYcktYODdYNFJKWFFCc2FDUldvNCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774772249),
('42u67HuTi1vZnLd39zfV74C442x5RA37yrbBW4UZ', NULL, '74.7.242.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYzdCS1VqMlpGR0lvMFdXN1NJTnFKZ29UM0FkSHhJMm5YSm53YkxXRiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDc6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL3NpdGVtYXAueG1sIjtzOjU6InJvdXRlIjtzOjc6InNpdGVtYXAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774784130),
('5tjyDEDFch4dGZfiLRAeazOGvKv55O3h7xmF5bRl', NULL, '198.232.7.54', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNVhQQ1ZwTFdQbmpmcWw5ckJRTnBwMUQxZDhpZlZMTGNBYVpvNmlzbiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774811642),
('5wfx9DymrYNGpdUYH85pfKtXYHSAZTwUCkws777C', NULL, '142.111.108.154', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVzh3clR6RXVNSVlwM3ZEY0h4T2JjUXljV0ltck0yVlBkZmN4Zlg5NCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774811194),
('72uURS5ug5LXPYDr8ERn6tX6hLKe8QPtONvKcam5', NULL, '35.204.166.221', 'Scrapy/2.13.4 (+https://scrapy.org)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibUJTU3Zyb1g4MHVEM3ZZUzFTWEU0aGF1bWh4cjI4THdXcGR6REdyZiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774824632),
('9CW7UtXasSjDNjBhOAhHYHKW2RWqGgII5hrpbfGG', NULL, '58.27.130.4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNjR5OU5sVE1XMEcyTXRHMnV0VXJSdFhSdE9lSm5iSEtXTVhnYW1yTSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774855786),
('aUphrj96MQCwzK4cSXAO2pKORJHKJUzVCqlACPBc', NULL, '66.249.93.69', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWmU4SnV0bEo0SWFJb0cza09pdmpaMnE2MERubVRGTkV1ck1nNlFtdiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTEyOiJodHRwczovL3NhbGVlbXNhaWwueHNvZnRkZXZlbG9wLmNvbS9jb250YWN0P2ludGVudD1mcmVlLWF1ZGl0JnNlcnZpY2U9R29vZ2xlJTIwQW5hbHl0aWNzJTIwNCUyMCUyOEdBNCUyOSUyMFNldHVwIjtzOjU6InJvdXRlIjtzOjc6ImNvbnRhY3QiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774846793),
('B2eOf1youQavFmbimcEtLob6WzbRDRZoOkomEJOk', NULL, '74.7.244.38', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36; compatible; OAI-SearchBot/1.3; robots.txt; +https://openai.com/searchbot', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVWtmNzViRXM5cUVxY29aTVhBZVNwZU5aQ3V3NUs1cXd6eVRieEVaeSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDY6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL3JvYm90cy50eHQiO3M6NToicm91dGUiO3M6Njoicm9ib3RzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774968536),
('bOBvMEyYfZ1QsI9tq4sIDdB24AEO7Tmuo8jvjfFC', NULL, '223.123.93.78', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVnJIY2JVeVFaVWRDbG1hd3lGV3hmejlyUVlQblZlUGlranE1THp5aSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NjE6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL2NvbnRhY3Q/aW50ZW50PWZyZWUtYXVkaXQiO3M6NToicm91dGUiO3M6NzoiY29udGFjdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774854441),
('caC2CJf8x6W5c2Ht27qnSd72BqtWA0sZTo1p9Zh3', NULL, '66.249.93.69', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibDJZRmQ1Njk4UEsyVlBsQXVJUU5vUnVvYkNFdWE2d0lpQ2dTVDB4NCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774845821),
('cCu449dcVM5POkcTVDcBONR6xw7Bzjb9P4W83yEe', NULL, '34.16.94.89', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicmV1amwwaU9YMjhoNVFWd05VYVBNeEJWc3JyNzZSQTQ3TUc5cXpxNSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774789636),
('CpuTzIA1Mtt1uV8fmLIFldnZ41AYsXDLAjPDzJWI', 1, '223.123.32.23', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiaHdKTnZzSXppeHZmVjJEbWtpdDJYSHlxU3JsN0ExRUc0QW50d2x1RiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTg6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL2FkbWluL2JhY2t1cHMvZGF0YWJhc2UiO3M6NToicm91dGUiO3M6MjI6ImFkbWluLmJhY2t1cHMuZGF0YWJhc2UiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjI2OiJsb2dpbl9jYXB0Y2hhX2dlbmVyYXRlZF9hdCI7aToxNzc0Njk3NjEzO3M6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1774697952),
('dDIHYh9fTu2blF4EjbktqNWPvFhVDFKLEcXSdyU4', NULL, '35.240.253.195', 'curl/7.83.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoib3VVdTdFU2hNSXVJTHJtS1d6UWNrVlk1QU4zNHZYdWVITHo1aGRyayI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774801347),
('dGrpLrE96egrgLi4ryGO703vKgE6G9gyWqKDKomH', NULL, '84.37.204.94', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMHJ4WE5paUh6aGx4RGlOS09uYURxMU5yYW5XUlViZEFTd05oS0p0dCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774811557),
('dvER86UGpKptCPYv7nG5iTA5BCuUFabP3p3WKrO5', NULL, '34.59.168.183', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZDRZajhpRFoxOFF0czd5WU82Sk1sdWpRbDdzN0c5dktNcVdtWVlFSCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774877676),
('EHVUyXEuGEtXfAN8yx7xni6wKnHBA6q01oHNrko9', NULL, '143.110.144.83', 'Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoic1RTQjNGQjBxUmJ1NGM3cEw2eFF0S1hJRmM4Z3owZUlNU3E0d2hVeSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vd3d3LnNhbGVlbXNhaWwueHNvZnRkZXZlbG9wLmNvbSI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774787927),
('fCwenUjB69c30q6XzqkNfGCFNzpV3ixHnYqlvjR2', NULL, '104.164.126.71', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQXJYR0NTNkxiNW5pS1hFMVNpS3FRdWdack9pVm56UHp6VHUwMWZnNyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774697119),
('FURUtjN2SrUcesJFbZmXezFSZ8E3T4UwKcYE4E5j', NULL, '66.249.83.101', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOXhFa01TWFE0TjNYd3lVVlM3bE5JdW9jckdEYmFpRFlNSDF0SjBVcyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDM6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL2NvbnRhY3QiO3M6NToicm91dGUiO3M6NzoiY29udGFjdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774854448),
('Fxz4A3y2l58gy9EKxqooL8L5QRiobZejiYKPmNJ2', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibTFWRWlTTndYckFyRHdua055NUhGNWNTclRhWGszZ3FoelE4dG5NYiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9sb2NhbGhvc3Qvc2FsZWVtc2FpbEFuYS5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774696169),
('g2gM58A85ThXEXdgFpxe3ec9txMONNrtkNvr4zbe', NULL, '107.172.195.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNVhnUjcyR1RLQVN4ZnVJQmNKN2g4cWhVMVBMTFVYRFFZcW81d2dYOCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774697122),
('gA0mAg0qrilAf1aS9Cf44OLjobTsUgXn9P4MXT42', NULL, '34.9.102.193', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNThSVnNualBWbzBzc3BQT3NBWjVsUnBNbTN5cXd0d1FmdVFOYVpHRyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774977587),
('GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', NULL, '154.192.129.10', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiY24wRXF3OTV2NHlPQjJjMXBWWTh6Y1RhRFNOU3BvUWFTS3FwTG9FaiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NjU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL3NlcnZpY2VzP2NhdGVnb3J5PUFkdmVydGlzaW5nIjtzOjU6InJvdXRlIjtzOjE0OiJzZXJ2aWNlcy5pbmRleCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774847083),
('GW27A1tx1TVRzxjfIBT4mxNaGv6OkceiIaqx7K74', NULL, '16.145.83.47', 'Mozilla/5.0 (Linux; Android 8.0.0; SM-G965U Build/R16NW) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.7680.153 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZHZkdGcxWndvcWRseWhVeUVxTkRzUlJRZUdlcUdDdFp0ek9TdDdBbSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774767909),
('HQBJ8cqQc16kkUWHKqb6sXj8ej1UeaUycABgod62', NULL, '68.183.95.85', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNkl2TzVvT0FucUVpcWM3QWVJTkRJOHYwT0hkWGVnMFVqRnR1V2xaTyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774948810),
('j04brmsi00tbSFTyagPMlkcjh4oPa6wJT8W0dgjZ', NULL, '66.249.83.102', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZnl3Y05DcGp5cXYyQWVhQ2pYcEhiRkx1WkZHdzI5U2R0Q0RQamNxNyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL2Jsb2ciO3M6NToicm91dGUiO3M6NDoiYmxvZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774847010),
('j7CXYlr5vXZruW5QloPRD21l78zR53CRuxA2gEzU', NULL, '34.56.167.233', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/32.0.1664.3 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRmxEVGR4cUxNdmZzTlJ2WjFoS2N5YWlUYktsVVhHOUt1dTRuWGFzWiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774699621),
('JcUa2PXlLbTyWvMoCYTrTLpVyI2kW17HZs04pnqj', NULL, '149.57.180.26', 'Mozilla/5.0 (X11; Linux i686; rv:109.0) Gecko/20100101 Firefox/120.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiN0luR0llSXh0Vkp4ckdVek5uaDlPSmJZUGtMMmNwMnpqdUo3Z2dvNyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vd3d3LnNhbGVlbXNhaWwueHNvZnRkZXZlbG9wLmNvbSI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774800667),
('JjawYtFPIHiFCzZXU4UYjIUCaSfRrdfflSmjryPo', NULL, '66.249.93.69', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibzVwMWNHZnl5QjdVQ3dNMkJKR2xLTm9LZ3FGQVVwd0tsSUE5MUFDeSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774845821),
('JkiJIfPBfeQFYVuecf9zQuU3cv1uuMwIMYqqSP8C', NULL, '82.24.23.65', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicXlwNlRwWVZ4aXJqZUlHYmZ4UXJadmpNN3doaGxHOFBkeThSMkVqUCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vd3d3LnNhbGVlbXNhaWwueHNvZnRkZXZlbG9wLmNvbSI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774811566),
('JNnSM3snTeZqBlyzR4C4xeesoYbvlyApHE635ahK', NULL, '74.7.241.157', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36; compatible; OAI-SearchBot/1.3; robots.txt; +https://openai.com/searchbot', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQkJhUnYxRzJvaGZlYVRZZlA0YVZjRXdhcEhxWm84dFc4ckRhNGR5eSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTA6Imh0dHBzOi8vd3d3LnNhbGVlbXNhaWwueHNvZnRkZXZlbG9wLmNvbS9yb2JvdHMudHh0IjtzOjU6InJvdXRlIjtzOjY6InJvYm90cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774989831),
('jqAHmKHTtbmhbcPVWnQA8PWFdMzxbBXdKTIi4bwI', NULL, '34.9.102.193', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSzJZcGU5VWlCUElYd2FNN1JPOVpNR3VldFhIQ3NITHZDa3dpbjVieiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774977587),
('kDu78ubYbmUZJ9JDB1E6NGGECUvK9THsqn4EJnSn', NULL, '223.123.32.23', 'WhatsApp/2.2607.106 W', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSzQ1dWt2RTJjbHRuQlh1dlVSaXJwMWNucDJrbEl4Q3NVdkpQNENWdiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774696835),
('l8aWx14EEi7iHG4BluZjOHkCrS44LIipnkgE61bF', NULL, '184.32.224.231', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibW95OFh6NTF6bTZJMDRZOWJEeHpSYlRRU3BNVlRVRFN4NnBBWXdPNSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774701019),
('MAJS6qTPKtpA3tjN0KNqutyE0KzdZuzEwEtZkPrT', NULL, '138.68.175.175', 'Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMVk5cU9CTnBjMDI3ZlJ2RVRDaHY3YlM5WjBiSE1IQ2ZXUXZwUGJsdiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vd3d3LnNhbGVlbXNhaWwueHNvZnRkZXZlbG9wLmNvbSI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774959464),
('mxyzpuTBczk8Uydrixi9Txw0k4iafs92N5lrTHiY', NULL, '66.249.93.70', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiU0E1eTNwZW01QzBPYW5hZUVXVkdnRllPRFJPTTA5ZHJrNnU5NDdmUSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NjE6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL2NvbnRhY3Q/aW50ZW50PWZyZWUtYXVkaXQiO3M6NToicm91dGUiO3M6NzoiY29udGFjdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774854447),
('MZH8UUNYHMA6lnSDuQHT7P9DMCB2L7aOBugNIV5q', NULL, '34.134.132.192', 'Mozilla/5.0 (Windows NT 6.2; Win64; x64; rv:16.0.1) Gecko/20121011 Firefox/21.0.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMEN0WHJQN25yb1M3Um9udG5aU2xiMFZQb2pKMHlSVVM0akRNS3cySiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774699639),
('NIp4Z9dXzaVJ3yHd5AWwxtJqgezkhKuGd3wf27yk', NULL, '138.68.175.175', 'Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidE9lS1V5bXBSUkIyRkd4S3ExZUJPQXFUZmtBdkdGMmx1M053UHNJciI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774959462),
('nsbON0gZqxUXbklE23kNMixHCd6gp70ZQqzCcoil', NULL, '154.192.129.64', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTktJVElFRExYSFVKSjh1Y0JUWHFoUWN0QnN1WmNKYUZLTjg5Qk50eCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774882406),
('ogQDgFJWFyMueJvu8lwQS9ygljbpPY2WusODHUQm', NULL, '137.184.80.36', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVEpvU1hRM1IwV0ZQR0Z2d2VhTFlKVzM3QzhOcEZuWm95cjc0Y2J2WSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774772248),
('olX8U0TVswC3lwHzHEp3h8w4KwSOqGxRD87EeDED', NULL, '74.7.244.38', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36; compatible; OAI-SearchBot/1.3; robots.txt; +https://openai.com/searchbot', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRDVRMzQ3cDVxSTVhQURqdzBkQUZnNW5qT1UwOXpiODB6N212N0tNNiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDY6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL3JvYm90cy50eHQiO3M6NToicm91dGUiO3M6Njoicm9ib3RzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774784140),
('P6vhcS60q5Dh6AN8gVjJuttA5z3oAXgJMZcLY8Ev', NULL, '23.27.145.151', 'Mozilla/5.0 (X11; Linux i686; rv:109.0) Gecko/20100101 Firefox/120.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVzN2eU45c3k2QkFUUGtBZ09aSDBld0FSSFdjR3BSYnB4SWZ3M3JDaiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774872555),
('pKmUkIIJXzJaYbtJK485dEqSX0H7ynACnfig2YWn', NULL, '84.32.70.52', 'Mozilla/5.0 (X11; Linux i686; rv:124.0) Gecko/20100101 Firefox/124.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibklKMnAzdndUYkJwbDh6eENrTVVESjB1b1lYUURXY1lBdmRWZWY2YyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774848979),
('Qnn4rasGTDoz8hQVcJCb9L6180lD8XEyhUtOeJh3', NULL, '16.145.83.47', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.7680.153 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ3UxSkc1V2NwYThKRVo2bWhNYmNRTWRSbkZ4NlNITWY2eld0QnlJUyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774767897),
('QUog6uBT1HYTj7G1KP5QalaHOvZt3oHfgduFwqMg', NULL, '66.249.93.71', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiajlLdW1tUzVhOXNNYjBQWWFKc3Y5UVRLZFZzejlaRnVYUXN4UmFnSiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL2Jsb2ciO3M6NToicm91dGUiO3M6NDoiYmxvZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774847009),
('qXlS9NjroLQGkgIKFxzHGRExSwDHwYpubMIh819x', NULL, '68.183.95.85', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMDFEYmlVUjdGQTBjT1JvckJSVGtMYzN1QTI2RElHNElueWo1eWxxcSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774948812),
('RkF2LrPFKsQGlfkou8QGOOGHvFYbrIJXbGmeUB8w', NULL, '44.252.90.167', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVEZEYlYxSFlCbTNrV0NrcERhNldER05TR0N0dm90V3hWMThjWnVLNiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774770215),
('RxpikoOXATjHO3lUu96O3lnenOZiHCG0wlEEr5Ry', NULL, '44.252.90.167', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.7680.153 Safari/537.36 Edge/18.19582', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOHNTTnE0YkZRQ0hNR1lTellFZGNiYXdLQ0h1VU5JYTZQbklENzhHUyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774770209),
('rziajOzF1HgcYfX4WLHn6oUZhhWIgBrCXD8bI71B', NULL, '107.172.195.77', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiempyNExKRnJSSWNYSjdpcUowU1ZNN0pocURDRmJSTW1TSEFKbWhUNSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774697115),
('s24yAwgteRsZ6mQZCZ9txmEPlVeMFG7oxPy7Oiza', NULL, '119.153.111.198', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiTm1SeHVaUXRnYjZ2NzdaYWtpUHVuTlZVTkU4Z2FWVjFQTFRZSnRneCI7czoyMjoibG9naW5fY2FwdGNoYV9xdWVzdGlvbiI7czo1OiI3ICsgMiI7czoyMDoibG9naW5fY2FwdGNoYV9hbnN3ZXIiO3M6MToiOSI7czoyNjoibG9naW5fY2FwdGNoYV9nZW5lcmF0ZWRfYXQiO2k6MTc3NDY5NzYzNTtzOjk6Il9wcmV2aW91cyI7YToyOntzOjM6InVybCI7czo0MToiaHR0cHM6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20vbG9naW4iO3M6NToicm91dGUiO3M6NToibG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774697636),
('sEa0EnjxWI0NDXOjSgQZYMnspoyyeAcSQojAZikd', NULL, '184.32.224.231', 'Mozilla/5.0 (Linux; Android 8.0.0; SM-G965U Build/R16NW) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.111 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRXNQYlUxeUZtRXJQbFdrQjFjSnNjeU1mejZvOGE3enZxMEhZc3c0byI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774701019),
('TCQY14wCV1R4UXbhXD43GlhFXaaNpke4dV2YWo5w', NULL, '35.222.108.53', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRVQydFdtbEo5Y2xXSXB1bElicUxzV0F2NzAyWllMUXpZeUNja083TCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774795766),
('tRlc8qbqbh3eZudaj08egRplAz8ZtCLWtPcy08PM', NULL, '74.7.244.38', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36; compatible; OAI-SearchBot/1.3; robots.txt; +https://openai.com/searchbot', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicFFxNTdralhSOXExNW9lTWs5WldaUllZN004RGFTcFl3SEk5Z1Y5eSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDY6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL3JvYm90cy50eHQiO3M6NToicm91dGUiO3M6Njoicm9ib3RzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774864388),
('Tz9Uwb7RhZK2RnS7k3eIcltdjMIEzvKYvjbx2ieP', NULL, '136.60.151.248', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.3 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMWRkckFHeGlWaVBUMHNoVFlYT29aUUExVW9PSk42a01CZmpBT0RZQiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774716078),
('UML8NbMt6Mjpzt5I6VMQsCPs83INpdOODVdekcLO', NULL, '74.7.242.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRktLTUtOcnM0WkVyS2s3OUViVHlTekdHSXJsUVZsNUN3OTNhdlcxdyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDc6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL3NpdGVtYXAueG1sIjtzOjU6InJvdXRlIjtzOjc6InNpdGVtYXAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774957458),
('vNKY181PuzLl6FFNoNW5FX3XLm7RDCWpeTje0fbU', NULL, '66.249.83.102', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZzI5b0Y1VGVGRG9FY2EzOFRUZTcyTXE3ZlpxQ1V6MThRVkVLMm5SOSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDM6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL2NvbnRhY3QiO3M6NToicm91dGUiO3M6NzoiY29udGFjdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774854448),
('wnV9k7wcDoyFP2HDVquvhyw4bRrioWXInvUlmw9L', NULL, '34.140.66.48', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTUdTWmJMSHVuRTZqR1lzbFpsSTA0VXFIbGFjMWZMZFNoRkJXRkw2NiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774792588),
('wOU46HXBxOuOr3QPDDYofhxG6cN1lT2TpR9HO2Pz', NULL, '66.249.93.70', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZHpmSXZXZktDdzl6VUNnNEZMSktDUmhURWR2c3h0c1lSVDJSeXlwbyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL2Jsb2ciO3M6NToicm91dGUiO3M6NDoiYmxvZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774847010),
('wxz9tIp9qnUDmWb1dvjLlXt2yNFRk71Lwjc61lir', NULL, '154.192.129.150', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibDZGYURtakg4OENBSkxLZ25OSDVoY2J0c2VDQnFuWXRuNnFJUFBlQyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL2Fib3V0IjtzOjU6InJvdXRlIjtzOjU6ImFib3V0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774697083),
('X1Bt0T08vlQbUkKt6CSJaPzHRRHouZywCXxyyTWV', NULL, '66.249.93.69', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiblFYYnU2cFFFVWtjQm50VDd5YXlEWVduSnFHaXVUaG1zSHZkWDl4WCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774845820),
('xEHHUqKg7YTUcUPqKHC0MYj1d7l1d8udO9rcR6vO', NULL, '149.57.180.49', 'Mozilla/5.0 (X11; Linux i686; rv:109.0) Gecko/20100101 Firefox/120.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRzl6NFd2Wm5yNDQzMXdvaTRQZUhSZlZaVHRqRlRjbFh0R2RCZExIbSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vd3d3LnNhbGVlbXNhaWwueHNvZnRkZXZlbG9wLmNvbSI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774886869),
('Y4NkQlRVO1EWuFvAoJOX1tENshNgLy0Ls8cGajWO', NULL, '154.192.129.64', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoianR1VWExcGpUb0kwNTR0aFFhMGNCVTlwV2lJRHRXWm5HWVZObjVxYyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774880579),
('y4RV598mKCMvKZL8nkRaKhw1KTCfShvm4YspdUDr', NULL, '66.249.83.103', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRmgzNzlKZ0didlBQNzVlNzBKNkxJUGNRNzdRR1RPUVF3SDdHaThqeCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL3NlcnZpY2VzIjtzOjU6InJvdXRlIjtzOjE0OiJzZXJ2aWNlcy5pbmRleCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774847087),
('yNUG1Rrby4KC43Vt9bJxHgLIwmRXv0JjDcQ8iZn1', NULL, '34.59.168.183', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieHg5Z3doaWdZd3REbWVhNkZWTWsyS3YxSFhTTU83RHh2MmZ2d0p2aiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774877676),
('ypxuqKY6RsKSWxtSvN98EUdn4d51Sjd0M3tmZcVX', NULL, '202.163.81.121', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiR3ZJN1dsRzlvaTRzbTU3VVRKb2hGT0wwV2pvS1owY01VVEZLeGp1YSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774862094),
('z2iicXIrZckTOlRijBRs7u0CbmfTqG4TSbIqCqys', NULL, '66.249.83.102', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZDF5Tmp0NXdWU2JhYmRIZWY5YUN2V0hhQTFlR3RQanBBMzFjcDlGWSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDM6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL2NvbnRhY3QiO3M6NToicm91dGUiO3M6NzoiY29udGFjdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774846794),
('Z7JCuLpckXmjYLdBRaTJlFdvKn09WHtFJ4Gz6Sug', NULL, '23.27.145.96', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiV1lVNHU1UGpnTlpYRXhvV2RSUnZlcFIzR0duUXJzVm54RjYwS0liaCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vd3d3LnNhbGVlbXNhaWwueHNvZnRkZXZlbG9wLmNvbSI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774805759),
('zA3ggVRRGBJXa3ogJx5qVyNwPvqspdNoUZv0Ogs6', NULL, '74.7.244.38', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36; compatible; OAI-SearchBot/1.3; robots.txt; +https://openai.com/searchbot', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWkJTaGo0ekFwdkhQVk1kWTU0MkFGMEloc3gxakZxZTFiRll1NG1pQiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDY6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL3JvYm90cy50eHQiO3M6NToicm91dGUiO3M6Njoicm9ib3RzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774697250),
('ZimE9y0dnfAMiuyCeOQZbSI5xdPX5EZFLH4V7Mcl', NULL, '35.87.148.36', 'Mozilla/5.0 (Linux; Android 8.0.0; SM-G965U Build/R16NW) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.111 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieEtDSjN2ZDNJU1lCdlQ5bEZNbU9CYkQzRW9OclNKanlEODhOY0tEWSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zYWxlZW1zYWlsLnhzb2Z0ZGV2ZWxvcC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774699733),
('zSe4nAdHVPI9hXwWZHgARbOYF04rozCPRRwg2qe7', NULL, '66.249.93.70', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQnFjN2ZKSlJhd04xc2tPc1A5NFg3aVJFanFGZjBXdk1QZVBETkprdyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NjU6Imh0dHBzOi8vc2FsZWVtc2FpbC54c29mdGRldmVsb3AuY29tL3NlcnZpY2VzP2NhdGVnb3J5PUFkdmVydGlzaW5nIjtzOjU6InJvdXRlIjtzOjE0OiJzZXJ2aWNlcy5pbmRleCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774847086);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint UNSIGNED NOT NULL,
  `site_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tagline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_media_id` bigint UNSIGNED DEFAULT NULL,
  `favicon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `favicon_media_id` bigint UNSIGNED DEFAULT NULL,
  `contact_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_port` int UNSIGNED DEFAULT NULL,
  `smtp_username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_scheme` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_from_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_from_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer_text` text COLLATE utf8mb4_unicode_ci,
  `social_links` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `header_cta_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `header_cta_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer_cta_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer_cta_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_contact_notifications_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `user_contact_auto_reply_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `support_chat_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `support_chat_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `support_chat_intro` text COLLATE utf8mb4_unicode_ci,
  `support_chat_button_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_contact_subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_contact_template` text COLLATE utf8mb4_unicode_ci,
  `user_contact_subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_contact_template` text COLLATE utf8mb4_unicode_ci,
  `gtm_container_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ga_measurement_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `site_name`, `tagline`, `logo`, `logo_media_id`, `favicon`, `favicon_media_id`, `contact_email`, `contact_phone`, `smtp_host`, `smtp_port`, `smtp_username`, `smtp_password`, `smtp_scheme`, `smtp_from_address`, `smtp_from_name`, `footer_text`, `social_links`, `header_cta_label`, `header_cta_url`, `footer_cta_label`, `footer_cta_url`, `admin_contact_notifications_enabled`, `user_contact_auto_reply_enabled`, `support_chat_enabled`, `support_chat_title`, `support_chat_intro`, `support_chat_button_label`, `admin_contact_subject`, `admin_contact_template`, `user_contact_subject`, `user_contact_template`, `gtm_container_id`, `ga_measurement_id`, `created_at`, `updated_at`) VALUES
(1, 'Saleem Sial Analytics', 'GA4, GTM and performance tracking specialist', 'uploads/logos/saleem-sial-logo.png', 1, 'uploads/placeholders/saleem-sial-favicon.png', 3, 'hello@saleemsial.com', '+92 300 1234567', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Saleem Sial Analytics builds clean, scalable tracking systems for advertisers, agencies, and growth teams.', '{\"facebook\":\"https:\\/\\/facebook.com\\/#\",\"instagram\":\"https:\\/\\/instagram.com\\/#\",\"x\":\"https:\\/\\/x.com\\/#\",\"linkedin\":\"https:\\/\\/linkedin.com\\/#\"}', 'Book a Consultation', '/contact', 'Start Your Tracking Setup', '/contact', 1, 1, 1, 'Need quick support?', 'Send a direct message about your tracking issue and we will follow up by email.', 'Send support message', 'New website inquiry from {{ name }}', '<p>You have received a new inquiry on {{ site_name }}.</p>\n<p><strong>Name:</strong> {{ name }}</p>\n<p><strong>Email:</strong> {{ email }}</p>\n<p><strong>Phone:</strong> {{ phone }}</p>\n<p><strong>Source:</strong> {{ source_label }}</p>\n<p><strong>Page URL:</strong> {{ page_url }}</p>\n<p><strong>Submitted:</strong> {{ submitted_at }}</p>\n<p><strong>Message:</strong></p>\n<p>{{ message }}</p>', 'Thanks for contacting {{ site_name }}', '<p>Hello {{ name }},</p>\n<p>Thanks for reaching out to {{ site_name }}. Your message has been received and we will respond as soon as possible.</p>\n<p><strong>Source:</strong> {{ source_label }}</p>\n<p><strong>Your message:</strong></p>\n<p>{{ message }}</p>\n<p>You can reply directly to {{ contact_email }} if you need to share more details.</p>', NULL, NULL, '2026-03-28 06:05:30', '2026-03-28 06:05:30');

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'editor',
  `role_id` bigint UNSIGNED DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `role`, `role_id`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin@example.com', 'admin', 1, '2026-03-28 06:05:30', '$2y$12$2KAZHviNg4.CwsILDmMfQeKg6YPM3Lh7HBfVgzoepQCfI.U05XFGW', NULL, '2026-03-28 06:05:30', '2026-03-28 06:05:30');

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

--
-- Table structure for table `visits`
--

CREATE TABLE `visits` (
  `id` bigint UNSIGNED NOT NULL,
  `session_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `route_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referer` text COLLATE utf8mb4_unicode_ci,
  `referrer_host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_hash` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `country_code` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `traffic_source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `traffic_medium` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `traffic_campaign` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visited_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `visits`
--

INSERT INTO `visits` (`id`, `session_id`, `path`, `route_name`, `referer`, `referrer_host`, `ip_hash`, `device_type`, `user_agent`, `country_code`, `country_name`, `traffic_source`, `traffic_medium`, `traffic_campaign`, `visited_at`, `created_at`, `updated_at`) VALUES
(1, 'Fxz4A3y2l58gy9EKxqooL8L5QRiobZejiYKPmNJ2', '/', 'home', NULL, NULL, 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 06:09:29', '2026-03-28 06:09:29', '2026-03-28 06:09:29'),
(2, '7mJU6ASvyym4FEtXvhnYFo8M9ft4K0Uec7FCRkh7', '/', 'home', NULL, NULL, '84e8852696cdb2dce5768b336569946d6b3c0477a03da5c3e2b2f74ae4e9ab3b', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 15:19:38', '2026-03-28 15:19:38', '2026-03-28 15:19:38'),
(3, 'kDu78ubYbmUZJ9JDB1E6NGGECUvK9THsqn4EJnSn', '/', 'home', NULL, NULL, '84e8852696cdb2dce5768b336569946d6b3c0477a03da5c3e2b2f74ae4e9ab3b', 'desktop', 'WhatsApp/2.2607.106 W', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-28 15:20:35', '2026-03-28 15:20:35', '2026-03-28 15:20:35'),
(4, 'wxz9tIp9qnUDmWb1dvjLlXt2yNFRk71Lwjc61lir', '/', 'home', NULL, NULL, 'b17e8473ec2794b14b24e4890a19c6d06813db8cd138e681f716254d380fdbbb', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 15:23:24', '2026-03-28 15:23:24', '2026-03-28 15:23:24'),
(5, 'wxz9tIp9qnUDmWb1dvjLlXt2yNFRk71Lwjc61lir', '/about', 'about', 'https://saleemsail.xsoftdevelop.com/', 'saleemsail.xsoftdevelop.com', 'b17e8473ec2794b14b24e4890a19c6d06813db8cd138e681f716254d380fdbbb', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 15:24:43', '2026-03-28 15:24:43', '2026-03-28 15:24:43'),
(6, 'rziajOzF1HgcYfX4WLHn6oUZhhWIgBrCXD8bI71B', '/', 'home', NULL, NULL, '91a5b70746f409580aabc48bce6e2fe8c10b9f60078282e12c1ecafc5d56b417', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 15:25:15', '2026-03-28 15:25:15', '2026-03-28 15:25:15'),
(7, 'fCwenUjB69c30q6XzqkNfGCFNzpV3ixHnYqlvjR2', '/', 'home', NULL, NULL, '48dada6de8c4ea61b3ebdf05ccb2faefe34ff54b1acd6564da978257c1def0ef', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 15:25:19', '2026-03-28 15:25:19', '2026-03-28 15:25:19'),
(8, 'g2gM58A85ThXEXdgFpxe3ec9txMONNrtkNvr4zbe', '/', 'home', NULL, NULL, '91a5b70746f409580aabc48bce6e2fe8c10b9f60078282e12c1ecafc5d56b417', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 15:25:22', '2026-03-28 15:25:22', '2026-03-28 15:25:22'),
(9, 'CpuTzIA1Mtt1uV8fmLIFldnZ41AYsXDLAjPDzJWI', '/service/google-analytics-4-ga4-setup', 'services.show', 'https://saleemsail.xsoftdevelop.com/admin/services', 'saleemsail.xsoftdevelop.com', '84e8852696cdb2dce5768b336569946d6b3c0477a03da5c3e2b2f74ae4e9ab3b', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 15:38:00', '2026-03-28 15:38:00', '2026-03-28 15:38:00'),
(10, 'CpuTzIA1Mtt1uV8fmLIFldnZ41AYsXDLAjPDzJWI', '/services', 'services.index', 'https://saleemsail.xsoftdevelop.com/service/google-analytics-4-ga4-setup', 'saleemsail.xsoftdevelop.com', '84e8852696cdb2dce5768b336569946d6b3c0477a03da5c3e2b2f74ae4e9ab3b', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 15:38:34', '2026-03-28 15:38:34', '2026-03-28 15:38:34'),
(11, 'CpuTzIA1Mtt1uV8fmLIFldnZ41AYsXDLAjPDzJWI', '/service/looker-studio-dashboards', 'services.show', 'https://saleemsail.xsoftdevelop.com/services', 'saleemsail.xsoftdevelop.com', '84e8852696cdb2dce5768b336569946d6b3c0477a03da5c3e2b2f74ae4e9ab3b', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 15:38:44', '2026-03-28 15:38:44', '2026-03-28 15:38:44'),
(12, 'CpuTzIA1Mtt1uV8fmLIFldnZ41AYsXDLAjPDzJWI', '/service/looker-studio-dashboards', 'services.show', 'https://saleemsail.xsoftdevelop.com/services', 'saleemsail.xsoftdevelop.com', '84e8852696cdb2dce5768b336569946d6b3c0477a03da5c3e2b2f74ae4e9ab3b', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 15:38:44', '2026-03-28 15:38:44', '2026-03-28 15:38:44'),
(13, 'CpuTzIA1Mtt1uV8fmLIFldnZ41AYsXDLAjPDzJWI', '/service/looker-studio-dashboards', 'services.show', 'https://saleemsail.xsoftdevelop.com/services', 'saleemsail.xsoftdevelop.com', '84e8852696cdb2dce5768b336569946d6b3c0477a03da5c3e2b2f74ae4e9ab3b', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 15:38:44', '2026-03-28 15:38:44', '2026-03-28 15:38:44'),
(14, 'j7CXYlr5vXZruW5QloPRD21l78zR53CRuxA2gEzU', '/', 'home', NULL, NULL, '22bbfe4d330147800de706ba9a6b8482a271859b3bc595158e7ad5b6d6cc7cbe', 'desktop', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/32.0.1664.3 Safari/537.36', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-28 16:07:01', '2026-03-28 16:07:01', '2026-03-28 16:07:01'),
(15, 'MZH8UUNYHMA6lnSDuQHT7P9DMCB2L7aOBugNIV5q', '/', 'home', NULL, NULL, '828e40cc6a236c7722d34ca546dde20a2c450d11621e2ba82e685abea685b9c0', 'desktop', 'Mozilla/5.0 (Windows NT 6.2; Win64; x64; rv:16.0.1) Gecko/20121011 Firefox/21.0.1', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-28 16:07:19', '2026-03-28 16:07:19', '2026-03-28 16:07:19'),
(16, '2gdKpZVFyNYGldvEQAR50C0uPAsi96PhdzjtKCGT', '/', 'home', NULL, NULL, 'bae531feaf3c7daf269682050f480454040f6cb782d88748b4465e2dd1aa5297', 'desktop', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-28 16:08:53', '2026-03-28 16:08:53', '2026-03-28 16:08:53'),
(17, 'ZimE9y0dnfAMiuyCeOQZbSI5xdPX5EZFLH4V7Mcl', '/', 'home', NULL, NULL, 'bae531feaf3c7daf269682050f480454040f6cb782d88748b4465e2dd1aa5297', 'mobile', 'Mozilla/5.0 (Linux; Android 8.0.0; SM-G965U Build/R16NW) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.111 Mobile Safari/537.36', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-28 16:08:53', '2026-03-28 16:08:53', '2026-03-28 16:08:53'),
(18, 'l8aWx14EEi7iHG4BluZjOHkCrS44LIipnkgE61bF', '/', 'home', NULL, NULL, '4f5fc97004efca1eff5d136a105fff24855d3873168c5c4c3317c77234b69fbb', 'desktop', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-28 16:30:19', '2026-03-28 16:30:19', '2026-03-28 16:30:19'),
(19, 'sEa0EnjxWI0NDXOjSgQZYMnspoyyeAcSQojAZikd', '/', 'home', NULL, NULL, '4f5fc97004efca1eff5d136a105fff24855d3873168c5c4c3317c77234b69fbb', 'mobile', 'Mozilla/5.0 (Linux; Android 8.0.0; SM-G965U Build/R16NW) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.111 Mobile Safari/537.36', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-28 16:30:19', '2026-03-28 16:30:19', '2026-03-28 16:30:19'),
(20, 'Tz9Uwb7RhZK2RnS7k3eIcltdjMIEzvKYvjbx2ieP', '/', 'home', 'http://www.saleemsail.xsoftdevelop.com/', 'www.saleemsail.xsoftdevelop.com', 'b6c6579f9a24aa6068caa902c999f6aeff4e5d2803eee7a59abd3bf59a636c11', 'desktop', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.3 Safari/605.1.15', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-28 20:41:18', '2026-03-28 20:41:18', '2026-03-28 20:41:18'),
(21, 'Qnn4rasGTDoz8hQVcJCb9L6180lD8XEyhUtOeJh3', '/', 'home', NULL, NULL, 'fb01334018fa65638268c2951cfb7d46aea76ab45a74219e5194e75f869e9a32', 'desktop', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.7680.153 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 11:04:57', '2026-03-29 11:04:57', '2026-03-29 11:04:57'),
(22, 'GW27A1tx1TVRzxjfIBT4mxNaGv6OkceiIaqx7K74', '/', 'home', NULL, NULL, 'fb01334018fa65638268c2951cfb7d46aea76ab45a74219e5194e75f869e9a32', 'mobile', 'Mozilla/5.0 (Linux; Android 8.0.0; SM-G965U Build/R16NW) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.7680.153 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 11:05:09', '2026-03-29 11:05:09', '2026-03-29 11:05:09'),
(23, '0UbcL1Sp8797H9e8NXSwYNSWhu2ZJK6AhhZbTckm', '/', 'home', NULL, NULL, '876d03cdc23358e75e9cdebc99dc2391bbe79ebc5ed8938f0db6600d9f634f2b', 'desktop', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.7680.153 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 11:36:20', '2026-03-29 11:36:20', '2026-03-29 11:36:20'),
(24, '0mdqLfj3lNQrb0Cn9m9PQ0aeK9VO29memde5s7n6', '/', 'home', NULL, NULL, '876d03cdc23358e75e9cdebc99dc2391bbe79ebc5ed8938f0db6600d9f634f2b', 'mobile', 'Mozilla/5.0 (Linux; Android 8.0.0; SM-G965U Build/R16NW) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.7680.153 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 11:36:31', '2026-03-29 11:36:31', '2026-03-29 11:36:31'),
(25, 'RxpikoOXATjHO3lUu96O3lnenOZiHCG0wlEEr5Ry', '/', 'home', NULL, NULL, '5adef1391407538d9f8ef8a8b22279a597105a488698b6d04e1e390657454434', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.7680.153 Safari/537.36 Edge/18.19582', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 11:43:29', '2026-03-29 11:43:29', '2026-03-29 11:43:29'),
(26, 'RkF2LrPFKsQGlfkou8QGOOGHvFYbrIJXbGmeUB8w', '/', 'home', NULL, NULL, '5adef1391407538d9f8ef8a8b22279a597105a488698b6d04e1e390657454434', 'mobile', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Mobile/15E148 Safari/604.1', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 11:43:35', '2026-03-29 11:43:35', '2026-03-29 11:43:35'),
(27, 'ogQDgFJWFyMueJvu8lwQS9ygljbpPY2WusODHUQm', '/', 'home', NULL, NULL, 'f265891f7ec4eb2ea12007d6f3f105cc9dbb24c8c1013d56e81fcec28a23c5b8', 'desktop', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 12:17:28', '2026-03-29 12:17:28', '2026-03-29 12:17:28'),
(28, '2oBTZVUAk0TxsLRkvvQeEqaifOaCc5iUGwRRk63Y', '/', 'home', NULL, NULL, 'f265891f7ec4eb2ea12007d6f3f105cc9dbb24c8c1013d56e81fcec28a23c5b8', 'desktop', 'Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 12:17:29', '2026-03-29 12:17:29', '2026-03-29 12:17:29'),
(29, '1B8OLGrjTJgPAbFdsLRCqtdMRyQE7TbI8eH0lwv8', '/', 'home', NULL, NULL, '2b8ab126de8a16a839eac000d54c9cc576b8396e9dd43a2fed0cca82898f6b25', 'desktop', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 16:38:47', '2026-03-29 16:38:47', '2026-03-29 16:38:47'),
(30, 'EHVUyXEuGEtXfAN8yx7xni6wKnHBA6q01oHNrko9', '/', 'home', NULL, NULL, '2b8ab126de8a16a839eac000d54c9cc576b8396e9dd43a2fed0cca82898f6b25', 'desktop', 'Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 16:38:47', '2026-03-29 16:38:47', '2026-03-29 16:38:47'),
(31, 'cCu449dcVM5POkcTVDcBONR6xw7Bzjb9P4W83yEe', '/', 'home', NULL, NULL, '84ee33b7f01d37d26479a9be02454ca21c048a0d955b5a0cfa2a55135fa81a6c', 'desktop', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-29 17:07:16', '2026-03-29 17:07:16', '2026-03-29 17:07:16'),
(32, 'wnV9k7wcDoyFP2HDVquvhyw4bRrioWXInvUlmw9L', '/', 'home', NULL, NULL, '1fa89abef3145d62b7ef47860fbfd7478861a5e2e8a6e26948f7e6e717edb90d', 'desktop', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-29 17:56:28', '2026-03-29 17:56:28', '2026-03-29 17:56:28'),
(33, 'TCQY14wCV1R4UXbhXD43GlhFXaaNpke4dV2YWo5w', '/', 'home', NULL, NULL, '758ebb9460e1dea3d0b7cc573bcd642d8f0a55e7c6a28416863e801fec70dc2f', 'desktop', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-29 18:49:26', '2026-03-29 18:49:26', '2026-03-29 18:49:26'),
(34, 'JcUa2PXlLbTyWvMoCYTrTLpVyI2kW17HZs04pnqj', '/', 'home', NULL, NULL, '91f618dd863fd7541c9bd457edf00587acbc61df5ba93ce5f7021874b7661883', 'desktop', 'Mozilla/5.0 (X11; Linux i686; rv:109.0) Gecko/20100101 Firefox/120.0', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 20:11:07', '2026-03-29 20:11:07', '2026-03-29 20:11:07'),
(35, 'dDIHYh9fTu2blF4EjbktqNWPvFhVDFKLEcXSdyU4', '/', 'home', NULL, NULL, '9af92364d44f2fe2a5c66a2a465bd9d591c744b64d88ded06ad0efcf1cde5cc5', 'desktop', 'curl/7.83.1', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-29 20:22:27', '2026-03-29 20:22:27', '2026-03-29 20:22:27'),
(36, 'Z7JCuLpckXmjYLdBRaTJlFdvKn09WHtFJ4Gz6Sug', '/', 'home', NULL, NULL, 'bcaf07b4108f4ccdbe26afdb333984bdd87b5e351112b899b5f41c7ffad33004', 'desktop', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-29 21:35:59', '2026-03-29 21:35:59', '2026-03-29 21:35:59'),
(37, '08OrKJRW6V3UOyAo99F07uh8fFUjgpvC4SjszJnn', '/', 'home', NULL, NULL, 'cc7b01cefe23b8bd8cd54a7cd67b6f47e087995e1b3688eb029381fbe9194f2d', 'desktop', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 23:06:09', '2026-03-29 23:06:09', '2026-03-29 23:06:09'),
(38, '5wfx9DymrYNGpdUYH85pfKtXYHSAZTwUCkws777C', '/', 'home', NULL, NULL, '74882d84279bbb83470dd63f8f6109365a2851122f5f5a262676319c5b58502a', 'desktop', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 23:06:34', '2026-03-29 23:06:34', '2026-03-29 23:06:34'),
(39, 'dGrpLrE96egrgLi4ryGO703vKgE6G9gyWqKDKomH', '/', 'home', NULL, NULL, '06af00f43f99d03ff61fde4e639305a5a9a95ff589d8e5810d96ea7bbb4a3a55', 'desktop', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-29 23:12:37', '2026-03-29 23:12:37', '2026-03-29 23:12:37'),
(40, 'JkiJIfPBfeQFYVuecf9zQuU3cv1uuMwIMYqqSP8C', '/', 'home', NULL, NULL, '49aed7f25069bf26ab06351518392b085c1ee4344724e117fe7bd566fced536c', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 23:12:46', '2026-03-29 23:12:46', '2026-03-29 23:12:46'),
(41, '0jghH0zT7r1SwaTN1MYtcdqBs8U4FJ3bhU3Nd6O3', '/', 'home', NULL, NULL, 'e19e383655ac94711527b8cd7fd4fb5f97277cdeb174b35af213e00a8bbcae22', 'desktop', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-29 23:13:40', '2026-03-29 23:13:40', '2026-03-29 23:13:40'),
(42, '5tjyDEDFch4dGZfiLRAeazOGvKv55O3h7xmF5bRl', '/', 'home', NULL, NULL, '3c5638639957295218c86ff97995bb4d5a0677ecf6102d368a0f6b9c8b0d32f7', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-29 23:14:02', '2026-03-29 23:14:02', '2026-03-29 23:14:02'),
(43, '72uURS5ug5LXPYDr8ERn6tX6hLKe8QPtONvKcam5', '/', 'home', NULL, NULL, '07f16ae3782029cd29add2daa031233dd49ee2ab9532225a157a6d565c5cf600', 'desktop', 'Scrapy/2.13.4 (+https://scrapy.org)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-30 02:50:32', '2026-03-30 02:50:32', '2026-03-30 02:50:32'),
(44, 'GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', '/', 'home', NULL, NULL, '71b9963a0dde85491170f1a53a6d38d32a9353efc6a6e7a32426d8e05a9bc4d1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 08:43:36', '2026-03-30 08:43:36', '2026-03-30 08:43:36'),
(45, 'X1Bt0T08vlQbUkKt6CSJaPzHRRHouZywCXxyyTWV', '/', 'home', NULL, NULL, '6f80fe04eff1297fdfd7b14f4f6e16e458de7bd3c5ce6191a7cdab6f2169d375', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-30 08:43:40', '2026-03-30 08:43:40', '2026-03-30 08:43:40'),
(46, 'caC2CJf8x6W5c2Ht27qnSd72BqtWA0sZTo1p9Zh3', '/', 'home', NULL, NULL, '6f80fe04eff1297fdfd7b14f4f6e16e458de7bd3c5ce6191a7cdab6f2169d375', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 08:43:41', '2026-03-30 08:43:41', '2026-03-30 08:43:41'),
(47, 'JjawYtFPIHiFCzZXU4UYjIUCaSfRrdfflSmjryPo', '/', 'home', NULL, NULL, '6f80fe04eff1297fdfd7b14f4f6e16e458de7bd3c5ce6191a7cdab6f2169d375', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 08:43:41', '2026-03-30 08:43:41', '2026-03-30 08:43:41'),
(48, 'GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', '/about', 'about', 'https://saleemsail.xsoftdevelop.com/', 'saleemsail.xsoftdevelop.com', '71b9963a0dde85491170f1a53a6d38d32a9353efc6a6e7a32426d8e05a9bc4d1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 08:57:23', '2026-03-30 08:57:23', '2026-03-30 08:57:23'),
(49, 'GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', '/service/google-analytics-4-ga4-setup', 'services.show', 'https://saleemsail.xsoftdevelop.com/', 'saleemsail.xsoftdevelop.com', '71b9963a0dde85491170f1a53a6d38d32a9353efc6a6e7a32426d8e05a9bc4d1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 08:58:47', '2026-03-30 08:58:47', '2026-03-30 08:58:47'),
(50, 'GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', '/contact', 'contact', 'https://saleemsail.xsoftdevelop.com/service/google-analytics-4-ga4-setup', 'saleemsail.xsoftdevelop.com', '71b9963a0dde85491170f1a53a6d38d32a9353efc6a6e7a32426d8e05a9bc4d1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 08:59:06', '2026-03-30 08:59:06', '2026-03-30 08:59:06'),
(51, 'GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', '/contact', 'contact', 'https://saleemsail.xsoftdevelop.com/contact?intent=pricing&service=Google%20Analytics%204%20%28GA4%29%20Setup', 'saleemsail.xsoftdevelop.com', '71b9963a0dde85491170f1a53a6d38d32a9353efc6a6e7a32426d8e05a9bc4d1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 08:59:50', '2026-03-30 08:59:50', '2026-03-30 08:59:50'),
(52, 'aUphrj96MQCwzK4cSXAO2pKORJHKJUzVCqlACPBc', '/contact', 'contact', NULL, NULL, '6f80fe04eff1297fdfd7b14f4f6e16e458de7bd3c5ce6191a7cdab6f2169d375', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-30 08:59:53', '2026-03-30 08:59:53', '2026-03-30 08:59:53'),
(53, '1wpbmvxRWl9M7qizAAxV3dcvk1fC42IXg7PfiaAx', '/contact', 'contact', NULL, NULL, '173ac9e20007d7123d761b6f0cfb4946882b4ac5d93130f22db1ea6bfdcd4c7b', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 08:59:54', '2026-03-30 08:59:54', '2026-03-30 08:59:54'),
(54, 'z2iicXIrZckTOlRijBRs7u0CbmfTqG4TSbIqCqys', '/contact', 'contact', NULL, NULL, '9913e24b04ab94be00b25deb510eb19f238ed09a76d119bff502d3b1bec96d1e', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 08:59:54', '2026-03-30 08:59:54', '2026-03-30 08:59:54'),
(55, 'GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', '/services', 'services.index', 'https://saleemsail.xsoftdevelop.com/service/google-analytics-4-ga4-setup', 'saleemsail.xsoftdevelop.com', '71b9963a0dde85491170f1a53a6d38d32a9353efc6a6e7a32426d8e05a9bc4d1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 09:00:55', '2026-03-30 09:00:55', '2026-03-30 09:00:55'),
(56, 'GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', '/services', 'services.index', 'https://saleemsail.xsoftdevelop.com/services', 'saleemsail.xsoftdevelop.com', '71b9963a0dde85491170f1a53a6d38d32a9353efc6a6e7a32426d8e05a9bc4d1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 09:01:21', '2026-03-30 09:01:21', '2026-03-30 09:01:21'),
(57, 'GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', '/blog', 'blog', 'https://saleemsail.xsoftdevelop.com/services', 'saleemsail.xsoftdevelop.com', '71b9963a0dde85491170f1a53a6d38d32a9353efc6a6e7a32426d8e05a9bc4d1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 09:03:27', '2026-03-30 09:03:27', '2026-03-30 09:03:27'),
(58, 'QUog6uBT1HYTj7G1KP5QalaHOvZt3oHfgduFwqMg', '/blog', 'blog', NULL, NULL, '957a5428d82dd26b48f94a910a6457766c1c8a8125591da7af124b4f178b0dd1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-30 09:03:29', '2026-03-30 09:03:29', '2026-03-30 09:03:29'),
(59, 'j04brmsi00tbSFTyagPMlkcjh4oPa6wJT8W0dgjZ', '/blog', 'blog', NULL, NULL, '9913e24b04ab94be00b25deb510eb19f238ed09a76d119bff502d3b1bec96d1e', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 09:03:30', '2026-03-30 09:03:30', '2026-03-30 09:03:30'),
(60, 'wOU46HXBxOuOr3QPDDYofhxG6cN1lT2TpR9HO2Pz', '/blog', 'blog', NULL, NULL, 'd8f193ddbdb6ba5071e8c67b89986b1d50b79588b0cb901f7a3ba3477e24fbda', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 09:03:30', '2026-03-30 09:03:30', '2026-03-30 09:03:30'),
(61, 'GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', '/blog/what-a-useful-looker-studio-dashboard-should-actually-include', 'blog.show', 'https://saleemsail.xsoftdevelop.com/blog', 'saleemsail.xsoftdevelop.com', '71b9963a0dde85491170f1a53a6d38d32a9353efc6a6e7a32426d8e05a9bc4d1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 09:04:02', '2026-03-30 09:04:02', '2026-03-30 09:04:02'),
(62, 'GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', '/services', 'services.index', 'https://saleemsail.xsoftdevelop.com/blog/what-a-useful-looker-studio-dashboard-should-actually-include', 'saleemsail.xsoftdevelop.com', '71b9963a0dde85491170f1a53a6d38d32a9353efc6a6e7a32426d8e05a9bc4d1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 09:04:28', '2026-03-30 09:04:28', '2026-03-30 09:04:28'),
(63, 'GkBJ1RidWXO5dWmZ2zOyKYChht3Ltsgmmf3hUPAt', '/services', 'services.index', 'https://saleemsail.xsoftdevelop.com/services', 'saleemsail.xsoftdevelop.com', '71b9963a0dde85491170f1a53a6d38d32a9353efc6a6e7a32426d8e05a9bc4d1', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 09:04:43', '2026-03-30 09:04:43', '2026-03-30 09:04:43'),
(64, 'zSe4nAdHVPI9hXwWZHgARbOYF04rozCPRRwg2qe7', '/services', 'services.index', NULL, NULL, 'd8f193ddbdb6ba5071e8c67b89986b1d50b79588b0cb901f7a3ba3477e24fbda', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-30 09:04:46', '2026-03-30 09:04:46', '2026-03-30 09:04:46'),
(65, 'y4RV598mKCMvKZL8nkRaKhw1KTCfShvm4YspdUDr', '/services', 'services.index', NULL, NULL, '173ac9e20007d7123d761b6f0cfb4946882b4ac5d93130f22db1ea6bfdcd4c7b', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 09:04:47', '2026-03-30 09:04:47', '2026-03-30 09:04:47'),
(66, '12OaWZ8y6Ard3dQ3U0bfqBBGQY4Fq6jUi8CwXspb', '/services', 'services.index', NULL, NULL, '173ac9e20007d7123d761b6f0cfb4946882b4ac5d93130f22db1ea6bfdcd4c7b', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 09:04:47', '2026-03-30 09:04:47', '2026-03-30 09:04:47'),
(67, 'pKmUkIIJXzJaYbtJK485dEqSX0H7ynACnfig2YWn', '/', 'home', NULL, NULL, 'a66ef9c7082b70aabcd59cd05abb4b32e8d660d7c07b6644a3c9bcddfd2f8caf', 'desktop', 'Mozilla/5.0 (X11; Linux i686; rv:124.0) Gecko/20100101 Firefox/124.0', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-30 09:36:19', '2026-03-30 09:36:19', '2026-03-30 09:36:19'),
(68, 'bOBvMEyYfZ1QsI9tq4sIDdB24AEO7Tmuo8jvjfFC', '/', 'home', NULL, NULL, '0d058947ff6f4fdec0ef0c814907c8376bedb965732b19f0168fcb76fc4e6788', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 11:05:45', '2026-03-30 11:05:45', '2026-03-30 11:05:45'),
(69, 'bOBvMEyYfZ1QsI9tq4sIDdB24AEO7Tmuo8jvjfFC', '/', 'home', NULL, NULL, '0d058947ff6f4fdec0ef0c814907c8376bedb965732b19f0168fcb76fc4e6788', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 11:05:56', '2026-03-30 11:05:56', '2026-03-30 11:05:56'),
(70, 'bOBvMEyYfZ1QsI9tq4sIDdB24AEO7Tmuo8jvjfFC', '/contact', 'contact', 'https://saleemsail.xsoftdevelop.com/', 'saleemsail.xsoftdevelop.com', '0d058947ff6f4fdec0ef0c814907c8376bedb965732b19f0168fcb76fc4e6788', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 11:07:21', '2026-03-30 11:07:21', '2026-03-30 11:07:21'),
(71, 'mxyzpuTBczk8Uydrixi9Txw0k4iafs92N5lrTHiY', '/contact', 'contact', NULL, NULL, 'd8f193ddbdb6ba5071e8c67b89986b1d50b79588b0cb901f7a3ba3477e24fbda', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-30 11:07:27', '2026-03-30 11:07:27', '2026-03-30 11:07:27'),
(72, 'vNKY181PuzLl6FFNoNW5FX3XLm7RDCWpeTje0fbU', '/contact', 'contact', NULL, NULL, '9913e24b04ab94be00b25deb510eb19f238ed09a76d119bff502d3b1bec96d1e', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 11:07:28', '2026-03-30 11:07:28', '2026-03-30 11:07:28'),
(73, 'FURUtjN2SrUcesJFbZmXezFSZ8E3T4UwKcYE4E5j', '/contact', 'contact', NULL, NULL, '474696dfdd5f531ee12670f834fc5e9329475b58d10f2e9c6456183d6de4a4c6', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 11:07:28', '2026-03-30 11:07:28', '2026-03-30 11:07:28'),
(74, 'ypxuqKY6RsKSWxtSvN98EUdn4d51Sjd0M3tmZcVX', '/', 'home', NULL, NULL, 'c2b8bbbc88d851283b6263f453c750fe4f8e4294aa5bab2ab97b9c76da8fb670', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 11:29:38', '2026-03-30 11:29:38', '2026-03-30 11:29:38'),
(75, '9CW7UtXasSjDNjBhOAhHYHKW2RWqGgII5hrpbfGG', '/', 'home', 'https://www.google.com/', 'www.google.com', 'c9692a8e030825d19ccf654e1490137f87ff6971e21e1b189321f982252e1951', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'US', 'United States', 'google', 'organic', NULL, '2026-03-30 11:29:46', '2026-03-30 11:29:46', '2026-03-30 11:29:46'),
(76, 'ypxuqKY6RsKSWxtSvN98EUdn4d51Sjd0M3tmZcVX', '/', 'home', NULL, NULL, 'c2b8bbbc88d851283b6263f453c750fe4f8e4294aa5bab2ab97b9c76da8fb670', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 11:51:54', '2026-03-30 11:51:54', '2026-03-30 11:51:54'),
(77, 'ypxuqKY6RsKSWxtSvN98EUdn4d51Sjd0M3tmZcVX', '/', 'home', NULL, NULL, 'c2b8bbbc88d851283b6263f453c750fe4f8e4294aa5bab2ab97b9c76da8fb670', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 13:14:54', '2026-03-30 13:14:54', '2026-03-30 13:14:54'),
(78, 'P6vhcS60q5Dh6AN8gVjJuttA5z3oAXgJMZcLY8Ev', '/', 'home', NULL, NULL, 'c4f983dc5afded658f6a3fdcef123fffa54c0c844cdf291edc397c32a04b552d', 'desktop', 'Mozilla/5.0 (X11; Linux i686; rv:109.0) Gecko/20100101 Firefox/120.0', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 16:09:15', '2026-03-30 16:09:15', '2026-03-30 16:09:15'),
(79, 'dvER86UGpKptCPYv7nG5iTA5BCuUFabP3p3WKrO5', '/', 'home', NULL, NULL, '070e72de5e0ceaf6cdea071d5915db9306f28589300c63ddf03e5ccb26a50d87', 'desktop', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-30 17:34:36', '2026-03-30 17:34:36', '2026-03-30 17:34:36'),
(80, 'yNUG1Rrby4KC43Vt9bJxHgLIwmRXv0JjDcQ8iZn1', '/', 'home', NULL, NULL, '070e72de5e0ceaf6cdea071d5915db9306f28589300c63ddf03e5ccb26a50d87', 'desktop', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-30 17:34:36', '2026-03-30 17:34:36', '2026-03-30 17:34:36'),
(81, 'Y4NkQlRVO1EWuFvAoJOX1tENshNgLy0Ls8cGajWO', '/', 'home', NULL, NULL, '89ff0c768768bfe5f08d50a8b0d2a9b0b0f1c6dffd196377dd67b59841528246', 'mobile', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 18:22:59', '2026-03-30 18:22:59', '2026-03-30 18:22:59'),
(82, 'nsbON0gZqxUXbklE23kNMixHCd6gp70ZQqzCcoil', '/', 'home', NULL, NULL, '89ff0c768768bfe5f08d50a8b0d2a9b0b0f1c6dffd196377dd67b59841528246', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 18:53:26', '2026-03-30 18:53:26', '2026-03-30 18:53:26'),
(83, 'xEHHUqKg7YTUcUPqKHC0MYj1d7l1d8udO9rcR6vO', '/', 'home', NULL, NULL, 'e8b758271b5dc20a3dd312c08eff7fb4d0b1ea820ae043a265e42d36b13e3218', 'desktop', 'Mozilla/5.0 (X11; Linux i686; rv:109.0) Gecko/20100101 Firefox/120.0', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-30 20:07:49', '2026-03-30 20:07:49', '2026-03-30 20:07:49'),
(84, 'HQBJ8cqQc16kkUWHKqb6sXj8ej1UeaUycABgod62', '/', 'home', NULL, NULL, '850ff886ab36e7e2dd04881455578d792bee279b38990fbb0a2b1333f2a22948', 'desktop', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-31 13:20:10', '2026-03-31 13:20:10', '2026-03-31 13:20:10'),
(85, 'qXlS9NjroLQGkgIKFxzHGRExSwDHwYpubMIh819x', '/', 'home', NULL, NULL, '850ff886ab36e7e2dd04881455578d792bee279b38990fbb0a2b1333f2a22948', 'desktop', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-31 13:20:12', '2026-03-31 13:20:12', '2026-03-31 13:20:12'),
(86, 'NIp4Z9dXzaVJ3yHd5AWwxtJqgezkhKuGd3wf27yk', '/', 'home', NULL, NULL, '5006939729fd52ff4a5506e690c77143af0a064ce96756200d65623e7950380b', 'desktop', 'Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-31 16:17:42', '2026-03-31 16:17:42', '2026-03-31 16:17:42'),
(87, 'MAJS6qTPKtpA3tjN0KNqutyE0KzdZuzEwEtZkPrT', '/', 'home', NULL, NULL, '5006939729fd52ff4a5506e690c77143af0a064ce96756200d65623e7950380b', 'desktop', 'Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0', 'US', 'United States', 'direct', 'direct', NULL, '2026-03-31 16:17:43', '2026-03-31 16:17:43', '2026-03-31 16:17:43'),
(88, 'jqAHmKHTtbmhbcPVWnQA8PWFdMzxbBXdKTIi4bwI', '/', 'home', NULL, NULL, '44f9253961f1c352d4ca83336644a5c7aee1ed0ab41ce1283bb9dfc86b0e8a2b', 'desktop', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-31 21:19:47', '2026-03-31 21:19:47', '2026-03-31 21:19:47'),
(89, 'gA0mAg0qrilAf1aS9Cf44OLjobTsUgXn9P4MXT42', '/', 'home', NULL, NULL, '44f9253961f1c352d4ca83336644a5c7aee1ed0ab41ce1283bb9dfc86b0e8a2b', 'desktop', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', NULL, 'Unknown', 'direct', 'direct', NULL, '2026-03-31 21:19:47', '2026-03-31 21:19:47', '2026-03-31 21:19:47');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `audits`
--
ALTER TABLE `audits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `audits_auditable_type_auditable_id_index` (`auditable_type`,`auditable_id`),
  ADD KEY `audits_user_id_index` (`user_id`);

--
-- Indexes for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `blog_posts_slug_unique` (`slug`),
  ADD KEY `blog_posts_featured_image_media_id_foreign` (`featured_image_media_id`),
  ADD KEY `blog_posts_is_published_is_featured_published_at_index` (`is_published`,`is_featured`,`published_at`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_uploaded_by_foreign` (`uploaded_by`);

--
-- Indexes for table `media_usages`
--
ALTER TABLE `media_usages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_usages_unique_link` (`media_id`,`usable_type`,`usable_id`,`field_key`),
  ADD KEY `media_usages_usable_type_usable_id_index` (`usable_type`,`usable_id`);

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

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pages_slug_unique` (`slug`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_slug_unique` (`slug`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `services_slug_unique` (`slug`),
  ADD KEY `services_image_media_id_foreign` (`image_media_id`),
  ADD KEY `services_icon_media_id_foreign` (`icon_media_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `settings_logo_media_id_foreign` (`logo_media_id`),
  ADD KEY `settings_favicon_media_id_foreign` (`favicon_media_id`);

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

--
-- Indexes for table `visits`
--
ALTER TABLE `visits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visits_session_id_index` (`session_id`),
  ADD KEY `visits_path_index` (`path`),
  ADD KEY `visits_route_name_index` (`route_name`),
  ADD KEY `visits_ip_hash_index` (`ip_hash`),
  ADD KEY `visits_visited_at_index` (`visited_at`),
  ADD KEY `visits_country_code_index` (`country_code`),
  ADD KEY `visits_traffic_source_index` (`traffic_source`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `audits`
--
ALTER TABLE `audits`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_posts`
--
ALTER TABLE `blog_posts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `media_usages`
--
ALTER TABLE `media_usages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `visits`
--
ALTER TABLE `visits`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD CONSTRAINT `blog_posts_featured_image_media_id_foreign` FOREIGN KEY (`featured_image_media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `media`
--
ALTER TABLE `media`
  ADD CONSTRAINT `media_uploaded_by_foreign` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `media_usages`
--
ALTER TABLE `media_usages`
  ADD CONSTRAINT `media_usages_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `services`
--
ALTER TABLE `services`
  ADD CONSTRAINT `services_icon_media_id_foreign` FOREIGN KEY (`icon_media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `services_image_media_id_foreign` FOREIGN KEY (`image_media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `settings`
--
ALTER TABLE `settings`
  ADD CONSTRAINT `settings_favicon_media_id_foreign` FOREIGN KEY (`favicon_media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `settings_logo_media_id_foreign` FOREIGN KEY (`logo_media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE SET NULL;
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 */;
