-- Saleem Sial Analytics MySQL backup
-- Generated from SQLite on 2026-03-16 17:24:41
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;
CREATE DATABASE IF NOT EXISTS `saleemsial_cms` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `saleemsial_cms`;

DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` VARCHAR(255) NOT NULL,
  `batch` INT NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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', 2),
(22, '2026_03_16_100007_add_google_tag_fields_and_traffic_sources', 3),
(23, '2026_03_16_100008_create_roles_table', 4),
(24, '2026_03_16_100009_add_role_id_and_support_chat_fields', 4),
(25, '2026_03_16_120000_add_access_level_to_roles_table', 4),
(26, '2026_03_16_130001_create_blog_posts_table', 5);

DROP TABLE IF EXISTS `audits`;
CREATE TABLE `audits` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `auditable_type` VARCHAR(255) NOT NULL,
  `auditable_id` BIGINT UNSIGNED NOT NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `event` VARCHAR(255) NOT NULL,
  `old_values` TEXT NULL,
  `new_values` TEXT NULL,
  `ip_address` VARCHAR(255) NULL,
  `user_agent` VARCHAR(255) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `audits_user_id_index` (`user_id`),
  KEY `audits_auditable_type_auditable_id_index` (`auditable_type`, `auditable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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.jpeg","logo_media_id":1,"favicon":"uploads\\/placeholders\\/default-favicon.ico","favicon_media_id":2,"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"}', '127.0.0.1', 'Symfony', '2026-03-16 10:56:47', '2026-03-16 10:56:47');

DROP TABLE IF EXISTS `blog_posts`;
CREATE TABLE `blog_posts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(255) NOT NULL,
  `slug` VARCHAR(255) NOT NULL,
  `badge` VARCHAR(255) NULL,
  `reading_time` VARCHAR(255) NULL,
  `excerpt` TEXT NULL,
  `content` TEXT NULL,
  `featured_image_media_id` BIGINT UNSIGNED NULL,
  `sort_order` INT NOT NULL DEFAULT '0',
  `is_featured` TINYINT NOT NULL DEFAULT '0',
  `is_published` TINYINT NOT NULL DEFAULT '1',
  `published_at` DATETIME NULL,
  `seo_title` VARCHAR(255) NULL,
  `seo_description` TEXT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `blog_posts_slug_unique` (`slug`),
  KEY `blog_posts_is_published_is_featured_published_at_index` (`is_published`, `is_featured`, `published_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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>', NULL, 0, 1, 1, '2026-03-11 14:48:33', '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-16 14:48:33', '2026-03-16 14:48:33'),
(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>', 5, 1, 0, 1, '2026-03-12 14:48:33', 'What to Validate After a Fresh GA4 Implementation', 'A quick GA4 post-launch checklist for events, conversions, filters, and reporting sanity checks.', '2026-03-16 14:48:33', '2026-03-16 14:48:33'),
(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>', 7, 2, 0, 1, '2026-03-13 14:48:33', '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-16 14:48:33', '2026-03-16 14:48:33'),
(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>', 9, 3, 0, 1, '2026-03-14 14:48:33', 'What a Useful Looker Studio Dashboard Should Include', 'Learn what makes a Looker Studio dashboard actionable for reporting, optimization, and stakeholder communication.', '2026-03-16 14:48:33', '2026-03-16 14:48:33'),
(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>', 17, 4, 0, 1, '2026-03-15 14:48:33', '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-16 14:48:33', '2026-03-16 14:48:33');

DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `key` VARCHAR(255) NOT NULL,
  `value` TEXT NOT NULL,
  `expiration` INT NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('saleem-sial-analytics-cache-admin@example.vom|::1:timer', 'i:1773670290;', 1773670290),
('saleem-sial-analytics-cache-admin@example.vom|::1', 'i:1;', 1773670290);

DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE `cache_locks` (
  `key` VARCHAR(255) NOT NULL,
  `owner` VARCHAR(255) NOT NULL,
  `expiration` INT NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `contacts`;
CREATE TABLE `contacts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `phone` VARCHAR(255) NULL,
  `message` TEXT NOT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `status` VARCHAR(255) NOT NULL DEFAULT 'new',
  `read_at` DATETIME NULL,
  `replied_at` DATETIME NULL,
  `notified_at` DATETIME NULL,
  `admin_notes` TEXT NULL,
  `source` VARCHAR(255) NULL,
  `page_url` VARCHAR(255) NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` VARCHAR(255) NOT NULL,
  `connection` TEXT NOT NULL,
  `queue` TEXT NOT NULL,
  `payload` TEXT NOT NULL,
  `exception` TEXT NOT NULL,
  `failed_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `job_batches`;
CREATE TABLE `job_batches` (
  `id` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `total_jobs` INT NOT NULL,
  `pending_jobs` INT NOT NULL,
  `failed_jobs` INT NOT NULL,
  `failed_job_ids` TEXT NOT NULL,
  `options` TEXT NULL,
  `cancelled_at` INT NULL,
  `created_at` INT NOT NULL,
  `finished_at` INT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `queue` VARCHAR(255) NOT NULL,
  `payload` TEXT NOT NULL,
  `attempts` INT NOT NULL,
  `reserved_at` INT NULL,
  `available_at` INT NOT NULL,
  `created_at` INT NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `media`;
CREATE TABLE `media` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `file_path` VARCHAR(255) NOT NULL,
  `type` VARCHAR(255) NULL,
  `alt_text` VARCHAR(255) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `sort_order` INT NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NULL,
  `disk` VARCHAR(255) NOT NULL DEFAULT 'public',
  `mime_type` VARCHAR(255) NULL,
  `extension` VARCHAR(255) NULL,
  `size` INT NULL,
  `width` INT NULL,
  `height` INT NULL,
  `category` VARCHAR(255) NULL,
  `is_system` TINYINT NOT NULL DEFAULT '0',
  `uploaded_by` INT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

DROP TABLE IF EXISTS `media_usages`;
CREATE TABLE `media_usages` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `media_id` BIGINT UNSIGNED NOT NULL,
  `usable_type` VARCHAR(255) NOT NULL,
  `usable_id` BIGINT UNSIGNED NOT NULL,
  `field_key` VARCHAR(255) NOT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `media_usages_unique_link` (`media_id`, `usable_type`, `usable_id`, `field_key`),
  KEY `media_usages_usable_type_usable_id_index` (`usable_type`, `usable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(255) NOT NULL,
  `slug` VARCHAR(255) NOT NULL,
  `content` TEXT NULL,
  `meta_title` VARCHAR(255) NULL,
  `meta_description` TEXT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `template` VARCHAR(255) NULL,
  `sections` TEXT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pages_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `meta_title`, `meta_description`, `created_at`, `updated_at`, `template`, `sections`) VALUES
(1, 'Home', 'home', '<p>Saleem Sial Analytics helps growth teams build trustworthy measurement across websites, ads, and reporting stacks.</p>', '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-16 10:56:47', '2026-03-16 15:25:08', 'home', '{"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":3,"platforms":[{"label":"GA4","media_id":5},{"label":"GTM","media_id":7},{"label":"Looker Studio","media_id":9},{"label":"Google Ads","media_id":11},{"label":"Meta Ads","media_id":13},{"label":"TikTok Ads","media_id":15},{"label":"Server-Side","media_id":17}]},"trusted":{"title":"Trusted by marketing teams that need cleaner reporting and better conversion visibility.","logos":[{"label":"Trusted logo 1","media_id":18},{"label":"Trusted logo 2","media_id":19},{"label":"Trusted logo 3","media_id":20},{"label":"Trusted logo 4","media_id":21},{"label":"Trusted logo 5","media_id":22}]},"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":23,"title":"Know what actually converts","description":"Measure critical actions across landing pages, forms, checkout flows, and ad platforms without guesswork."},{"media_id":24,"title":"Reduce reporting noise","description":"Bring paid media, analytics, and CRM signals into one cleaner source of truth for faster reporting."},{"media_id":25,"title":"Scale without constant rework","description":"Build GTM containers, naming conventions, and event structures that stay organized as campaigns grow."},{"media_id":26,"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."},"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":27,"title":"Reliable event data","description":"Capture the right user actions and send them to the right destinations with confidence."},{"media_id":28,"title":"Cross-platform reporting","description":"Connect ad platforms and analytics tools so performance can be reviewed in one place."},{"media_id":29,"title":"Smarter optimization","description":"Improve campaign decisions with cleaner conversion signals and reporting clarity."},{"media_id":30,"title":"Repeatable implementation","description":"Documented tagging, naming, and tracking structures that support long-term growth."},{"media_id":31,"title":"Faster stakeholder reporting","description":"Create dashboards and summaries that make performance easier to understand and act on."},{"media_id":32,"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"}}'),
(2, 'About', 'about', '<p>Saleem Sial Analytics specializes in implementation, measurement strategy, and reporting systems that help businesses understand real performance.</p>', 'About Saleem Sial Analytics', 'Learn how Saleem Sial Analytics helps teams build reliable tracking and reporting systems.', '2026-03-16 10:56:47', '2026-03-16 10:56:47', 'about', '{"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"}}'),
(3, 'Blog', 'blog', '<p>Insights and practical notes from Saleem Sial Analytics on measurement, reporting, and analytics implementation.</p>', 'Blog | Saleem Sial Analytics', 'Read Saleem Sial Analytics insights on GA4, GTM, dashboards, ad tracking, and modern measurement strategy.', '2026-03-16 14:18:51', '2026-03-16 14:18:51', 'blog', '{"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","url":"\\/contact","media_id":null},"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","url":"\\/services"},{"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","url":"\\/services"},{"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","url":"\\/services"},{"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","url":"\\/services"}],"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"}}');

DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE `password_reset_tokens` (
  `email` VARCHAR(255) NOT NULL,
  `token` VARCHAR(255) NOT NULL,
  `created_at` DATETIME NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `slug` VARCHAR(255) NOT NULL,
  `description` TEXT NULL,
  `is_system` TINYINT NOT NULL DEFAULT '0',
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `access_level` VARCHAR(255) NOT NULL DEFAULT 'user',
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `roles` (`id`, `name`, `slug`, `description`, `is_system`, `created_at`, `updated_at`, `access_level`) VALUES
(1, 'Administrator', 'admin', 'Full access to settings, media, users, roles, and content management.', 1, '2026-03-16 13:32:57', '2026-03-16 13:32:57', 'admin'),
(2, 'Editor', 'editor', 'Can manage pages, services, and inbound messages.', 1, '2026-03-16 13:32:57', '2026-03-16 13:32:57', 'editor'),
(3, 'User', 'user', 'Basic authenticated user with no admin panel access.', 1, '2026-03-16 13:32:57', '2026-03-16 13:32:57', 'user');

DROP TABLE IF EXISTS `services`;
CREATE TABLE `services` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(255) NOT NULL,
  `slug` VARCHAR(255) NOT NULL,
  `short_description` VARCHAR(255) NULL,
  `long_description` TEXT NULL,
  `hero_title` VARCHAR(255) NULL,
  `benefits` TEXT NULL,
  `image` VARCHAR(255) NULL,
  `icon` VARCHAR(255) NULL,
  `seo_title` VARCHAR(255) NULL,
  `seo_description` TEXT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `category` VARCHAR(255) NULL,
  `tags` TEXT NULL,
  `sort_order` INT NOT NULL DEFAULT '0',
  `image_media_id` BIGINT UNSIGNED NULL,
  `icon_media_id` BIGINT UNSIGNED NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `services_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `services` (`id`, `title`, `slug`, `short_description`, `long_description`, `hero_title`, `benefits`, `image`, `icon`, `seo_title`, `seo_description`, `created_at`, `updated_at`, `category`, `tags`, `sort_order`, `image_media_id`, `icon_media_id`) VALUES
(1, 'Google Analytics 4 (GA4) Setup', 'google-analytics-4-ga4-setup', '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', 'uploads/placeholders/ga4-icon.png', 'GA4 Setup Services', 'Get accurate GA4 tracking and reporting for your website.', '2026-03-16 10:56:47', '2026-03-16 10:56:47', 'Analytics', '["analytics","ga4","reporting"]', 0, 4, 5),
(2, 'Google Tag Manager (GTM)', 'google-tag-manager-gtm', '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', 'uploads/placeholders/gtm-icon.png', 'GTM Setup Services', 'Scalable Google Tag Manager configuration.', '2026-03-16 10:56:47', '2026-03-16 10:56:47', 'Tracking', '["tag-management","tracking","gtm"]', 1, 6, 7),
(3, 'Looker Studio Dashboards', 'looker-studio-dashboards', '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', 'uploads/placeholders/looker-icon.png', 'Looker Studio Dashboard Services', 'Unified dashboards for marketing and analytics.', '2026-03-16 10:56:47', '2026-03-16 10:56:47', 'Reporting', '["dashboards","reporting","looker"]', 2, 8, 9),
(4, 'Google Ads Tracking', 'google-ads-tracking', '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', 'uploads/placeholders/google-ads-icon.png', 'Google Ads Tracking Services', 'Accurate conversion measurement for Google Ads.', '2026-03-16 10:56:47', '2026-03-16 10:56:47', 'Advertising', '["advertising","ads","tracking"]', 3, 10, 11),
(5, 'Meta Ads Tracking (Facebook/Instagram)', 'meta-ads-tracking-facebook-instagram', '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', 'uploads/placeholders/meta-icon.png', 'Meta Ads Tracking Services', 'High quality Meta Pixel setup and measurement.', '2026-03-16 10:56:47', '2026-03-16 10:56:47', 'Advertising', '["advertising","meta","pixel"]', 4, 12, 13),
(6, 'TikTok Ads Tracking', 'tiktok-ads-tracking', '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', 'uploads/placeholders/tiktok-icon.png', 'TikTok Ads Tracking Services', 'Detailed analytics for TikTok campaigns.', '2026-03-16 10:56:47', '2026-03-16 10:56:47', 'Advertising', '["advertising","tiktok","tracking"]', 5, 14, 15),
(7, 'Server-Side Tracking', 'server-side-tracking', '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', 'uploads/placeholders/server-side-icon.png', 'Server Side Tracking Services', 'Enhanced accuracy with server side data collection.', '2026-03-16 10:56:47', '2026-03-16 10:56:47', 'Privacy', '["privacy","server-side","tracking"]', 6, 16, 17);

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `id` VARCHAR(255) NOT NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `ip_address` VARCHAR(255) NULL,
  `user_agent` TEXT NULL,
  `payload` TEXT NOT NULL,
  `last_activity` INT NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_last_activity_index` (`last_activity`),
  KEY `sessions_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiTVR0NHc0QzJWOGVtUEhyVUc0M0VYaXpBcFFyaHFIaW1KWlFRV3UxRCI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjQ2OiJodHRwOi8vbG9jYWxob3N0L3NhbGVlbXNpYWwtbGFyYXZlbC1jbXMvcHVibGljIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1773667211),
('FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOHRSODROTUI1VndlMHFrYU9jVjVEcG9DeGpoS0N1TXFnNkZjTlFHbCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTQ6Imh0dHA6Ly9sb2NhbGhvc3Qvc2FsZWVtc2lhbC1sYXJhdmVsLWNtcy9wdWJsaWMvY29udGFjdCI7czo1OiJyb3V0ZSI7czo3OiJjb250YWN0Ijt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1773678079);

DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `site_name` VARCHAR(255) NULL,
  `logo` VARCHAR(255) NULL,
  `favicon` VARCHAR(255) NULL,
  `contact_email` VARCHAR(255) NULL,
  `contact_phone` VARCHAR(255) NULL,
  `footer_text` TEXT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `tagline` VARCHAR(255) NULL,
  `social_links` TEXT NULL,
  `header_cta_label` VARCHAR(255) NULL,
  `header_cta_url` VARCHAR(255) NULL,
  `footer_cta_label` VARCHAR(255) NULL,
  `footer_cta_url` VARCHAR(255) NULL,
  `logo_media_id` BIGINT UNSIGNED NULL,
  `favicon_media_id` BIGINT UNSIGNED NULL,
  `admin_contact_notifications_enabled` TINYINT NOT NULL DEFAULT '1',
  `user_contact_auto_reply_enabled` TINYINT NOT NULL DEFAULT '1',
  `admin_contact_subject` VARCHAR(255) NULL,
  `admin_contact_template` TEXT NULL,
  `user_contact_subject` VARCHAR(255) NULL,
  `user_contact_template` TEXT NULL,
  `gtm_container_id` VARCHAR(255) NULL,
  `ga_measurement_id` VARCHAR(255) NULL,
  `support_chat_enabled` TINYINT NOT NULL DEFAULT '1',
  `support_chat_title` VARCHAR(255) NULL,
  `support_chat_intro` TEXT NULL,
  `support_chat_button_label` VARCHAR(255) NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `settings` (`id`, `site_name`, `logo`, `favicon`, `contact_email`, `contact_phone`, `footer_text`, `created_at`, `updated_at`, `tagline`, `social_links`, `header_cta_label`, `header_cta_url`, `footer_cta_label`, `footer_cta_url`, `logo_media_id`, `favicon_media_id`, `admin_contact_notifications_enabled`, `user_contact_auto_reply_enabled`, `admin_contact_subject`, `admin_contact_template`, `user_contact_subject`, `user_contact_template`, `gtm_container_id`, `ga_measurement_id`, `support_chat_enabled`, `support_chat_title`, `support_chat_intro`, `support_chat_button_label`) VALUES
(1, 'Saleem Sial Analytics', 'uploads/logos/saleem-sial-logo.png', 'uploads/placeholders/saleem-sial-favicon.png', 'hello@saleemsial.com', '+92 300 1234567', 'Saleem Sial Analytics builds clean, scalable tracking systems for advertisers, agencies, and growth teams.', '2026-03-16 10:56:47', '2026-03-16 12:27:09', 'GA4, GTM and performance tracking specialist', '{"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, 1, 'New website inquiry from {{ name }}', '<p>You have received a new inquiry on {{ site_name }}.</p>\r\n<p><strong>Name:</strong> {{ name }}</p>\r\n<p><strong>Email:</strong> {{ email }}</p>\r\n<p><strong>Phone:</strong> {{ phone }}</p>\r\n<p><strong>Submitted:</strong> {{ submitted_at }}</p>\r\n<p><strong>Message:</strong></p>\r\n<p>{{ message }}</p>', 'Thanks for contacting {{ site_name }}', '<p>Hello {{ name }},</p>\r\n<p>Thanks for reaching out to {{ site_name }}. Your message has been received and we will respond as soon as possible.</p>\r\n<p><strong>Your message:</strong></p>\r\n<p>{{ message }}</p>\r\n<p>You can reply directly to {{ contact_email }} if you need to share more details.</p>', NULL, NULL, 1, NULL, NULL, NULL);

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `email_verified_at` DATETIME NULL,
  `password` VARCHAR(255) NOT NULL,
  `remember_token` VARCHAR(255) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `role` VARCHAR(255) NOT NULL DEFAULT 'editor',
  `role_id` BIGINT UNSIGNED NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `role`, `role_id`) VALUES
(1, 'Admin', 'admin@example.com', '2026-03-16 10:56:46', '$2y$12$KxVd5v.CzMs4.StfLKnOGef1fJGWwXt1vj2akVybAxs4yirvM3I8.', NULL, '2026-03-16 10:56:46', '2026-03-16 10:56:46', 'admin', 1);

DROP TABLE IF EXISTS `visits`;
CREATE TABLE `visits` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `session_id` VARCHAR(255) NULL,
  `path` VARCHAR(255) NOT NULL,
  `route_name` VARCHAR(255) NULL,
  `referer` TEXT NULL,
  `ip_hash` VARCHAR(255) NULL,
  `device_type` VARCHAR(255) NULL,
  `user_agent` TEXT NULL,
  `visited_at` DATETIME NOT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `country_code` VARCHAR(255) NULL,
  `country_name` VARCHAR(255) NULL,
  `referrer_host` VARCHAR(255) NULL,
  `traffic_source` VARCHAR(255) NULL,
  `traffic_medium` VARCHAR(255) NULL,
  `traffic_campaign` VARCHAR(255) NULL,
  PRIMARY KEY (`id`),
  KEY `visits_traffic_source_index` (`traffic_source`),
  KEY `visits_country_code_index` (`country_code`),
  KEY `visits_visited_at_index` (`visited_at`),
  KEY `visits_ip_hash_index` (`ip_hash`),
  KEY `visits_route_name_index` (`route_name`),
  KEY `visits_path_index` (`path`),
  KEY `visits_session_id_index` (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `visits` (`id`, `session_id`, `path`, `route_name`, `referer`, `ip_hash`, `device_type`, `user_agent`, `visited_at`, `created_at`, `updated_at`, `country_code`, `country_name`, `referrer_host`, `traffic_source`, `traffic_medium`, `traffic_campaign`) VALUES
(1, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/admin/pages/1/edit', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 11:01:32', '2026-03-16 11:01:32', '2026-03-16 11:01:32', NULL, NULL, NULL, NULL, NULL, NULL),
(2, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/admin/pages/1/edit', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 11:01:42', '2026-03-16 11:01:42', '2026-03-16 11:01:42', NULL, NULL, NULL, NULL, NULL, NULL),
(3, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/about', 'about', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1', '2026-03-16 11:02:24', '2026-03-16 11:02:24', '2026-03-16 11:02:24', NULL, NULL, NULL, NULL, NULL, NULL),
(4, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1', '2026-03-16 11:02:55', '2026-03-16 11:02:55', '2026-03-16 11:02:55', NULL, NULL, NULL, NULL, NULL, NULL),
(5, 'G11zzwlGMqQwYwT6fCY0PGhcpLxfy59QEaHzifHb', '/', 'home', NULL, 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456', '2026-03-16 11:10:15', '2026-03-16 11:10:15', '2026-03-16 11:10:15', NULL, NULL, NULL, NULL, NULL, NULL),
(6, 'HYTBU7Dla97QrUb3palpnxyWGaXJl4J9OwuSjodF', '/', 'home', NULL, 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456', '2026-03-16 11:33:33', '2026-03-16 11:33:33', '2026-03-16 11:33:33', NULL, 'Unknown', NULL, NULL, NULL, NULL),
(7, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 11:42:25', '2026-03-16 11:42:25', '2026-03-16 11:42:25', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(8, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 11:56:33', '2026-03-16 11:56:33', '2026-03-16 11:56:33', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(9, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:15:38', '2026-03-16 12:15:38', '2026-03-16 12:15:38', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(10, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:25:18', '2026-03-16 12:25:18', '2026-03-16 12:25:18', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(11, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:27:13', '2026-03-16 12:27:13', '2026-03-16 12:27:13', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(12, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:28:45', '2026-03-16 12:28:45', '2026-03-16 12:28:45', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(13, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1', '2026-03-16 12:29:01', '2026-03-16 12:29:01', '2026-03-16 12:29:01', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(14, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (Linux; Android 13; SM-G981B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', '2026-03-16 12:29:15', '2026-03-16 12:29:15', '2026-03-16 12:29:15', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(15, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (Linux; Android 13; SM-G981B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', '2026-03-16 12:30:07', '2026-03-16 12:30:07', '2026-03-16 12:30:07', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(16, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (Linux; Android 13; SM-G981B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', '2026-03-16 12:33:41', '2026-03-16 12:33:41', '2026-03-16 12:33:41', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(17, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (Linux; Android 13; SM-G981B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', '2026-03-16 12:34:47', '2026-03-16 12:34:47', '2026-03-16 12:34:47', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(18, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (Linux; Android 13; SM-G981B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', '2026-03-16 12:35:41', '2026-03-16 12:35:41', '2026-03-16 12:35:41', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(19, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/service/tiktok-ads-tracking', 'services.show', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:36:29', '2026-03-16 12:36:29', '2026-03-16 12:36:29', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(20, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1', '2026-03-16 12:37:06', '2026-03-16 12:37:06', '2026-03-16 12:37:06', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(21, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1', '2026-03-16 12:37:43', '2026-03-16 12:37:43', '2026-03-16 12:37:43', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(22, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:45:50', '2026-03-16 12:45:50', '2026-03-16 12:45:50', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(23, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:51:00', '2026-03-16 12:51:00', '2026-03-16 12:51:00', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(24, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:51:23', '2026-03-16 12:51:23', '2026-03-16 12:51:23', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(25, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/about', 'about', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:51:25', '2026-03-16 12:51:25', '2026-03-16 12:51:25', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(26, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/services', 'services.index', 'http://localhost/saleemsial-laravel-cms/public/about', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:51:27', '2026-03-16 12:51:27', '2026-03-16 12:51:27', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(27, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/contact', 'contact', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:51:28', '2026-03-16 12:51:28', '2026-03-16 12:51:28', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(28, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/contact', 'contact', 'http://localhost/saleemsial-laravel-cms/public/contact', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:51:34', '2026-03-16 12:51:34', '2026-03-16 12:51:34', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(29, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/services', 'services.index', 'http://localhost/saleemsial-laravel-cms/public/contact', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:51:42', '2026-03-16 12:51:42', '2026-03-16 12:51:42', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(30, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:55:34', '2026-03-16 12:55:34', '2026-03-16 12:55:34', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(31, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 12:57:59', '2026-03-16 12:57:59', '2026-03-16 12:57:59', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(32, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 13:04:15', '2026-03-16 13:04:15', '2026-03-16 13:04:15', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(33, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 13:05:50', '2026-03-16 13:05:50', '2026-03-16 13:05:50', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(34, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 13:15:11', '2026-03-16 13:15:11', '2026-03-16 13:15:11', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(35, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/service/google-analytics-4-ga4-setup', 'services.show', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 13:16:06', '2026-03-16 13:16:06', '2026-03-16 13:16:06', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(36, 'Y0qnfxnauSSLMY01tFBUuOBMaZpl7mVfQ5wIODcJ', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 13:20:11', '2026-03-16 13:20:11', '2026-03-16 13:20:11', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(37, 'C9NuVHegIEOQU1eKFp39bZD2j2H1MOY1nk49ryAp', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 13:40:49', '2026-03-16 13:40:49', '2026-03-16 13:40:49', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(38, 'C9NuVHegIEOQU1eKFp39bZD2j2H1MOY1nk49ryAp', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 13:41:06', '2026-03-16 13:41:06', '2026-03-16 13:41:06', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(39, 'C9NuVHegIEOQU1eKFp39bZD2j2H1MOY1nk49ryAp', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 13:42:05', '2026-03-16 13:42:05', '2026-03-16 13:42:05', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(40, 'C9NuVHegIEOQU1eKFp39bZD2j2H1MOY1nk49ryAp', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:08:12', '2026-03-16 14:08:12', '2026-03-16 14:08:12', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(41, 'LNRtBKXcPyAMVatN1UNwSaYdOE2t47I7mBPE9rRO', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/services', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:15:48', '2026-03-16 14:15:48', '2026-03-16 14:15:48', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(42, 'LNRtBKXcPyAMVatN1UNwSaYdOE2t47I7mBPE9rRO', '/contact', 'contact', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:15:55', '2026-03-16 14:15:55', '2026-03-16 14:15:55', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(43, 'LNRtBKXcPyAMVatN1UNwSaYdOE2t47I7mBPE9rRO', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/contact', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:15:59', '2026-03-16 14:15:59', '2026-03-16 14:15:59', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(44, 'LNRtBKXcPyAMVatN1UNwSaYdOE2t47I7mBPE9rRO', '/contact', 'contact', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:16:44', '2026-03-16 14:16:44', '2026-03-16 14:16:44', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(45, 'LNRtBKXcPyAMVatN1UNwSaYdOE2t47I7mBPE9rRO', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/contact', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:20:30', '2026-03-16 14:20:30', '2026-03-16 14:20:30', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(46, 'LNRtBKXcPyAMVatN1UNwSaYdOE2t47I7mBPE9rRO', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/contact', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:23:12', '2026-03-16 14:23:12', '2026-03-16 14:23:12', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(47, 'LNRtBKXcPyAMVatN1UNwSaYdOE2t47I7mBPE9rRO', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/admin/dashboard', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:24:20', '2026-03-16 14:24:20', '2026-03-16 14:24:20', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(48, 'pZgoYDWZSiTiSIiMTlVGlK8jeg6PLBFhlfxtXiUR', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/admin/dashboard', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:24:28', '2026-03-16 14:24:28', '2026-03-16 14:24:28', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(49, 'pZgoYDWZSiTiSIiMTlVGlK8jeg6PLBFhlfxtXiUR', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/contact', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:24:30', '2026-03-16 14:24:30', '2026-03-16 14:24:30', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(50, 'pZgoYDWZSiTiSIiMTlVGlK8jeg6PLBFhlfxtXiUR', '/contact', 'contact', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', '2026-03-16 14:25:46', '2026-03-16 14:25:46', '2026-03-16 14:25:46', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(51, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/blog', 'blog', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', '2026-03-16 14:30:26', '2026-03-16 14:30:26', '2026-03-16 14:30:26', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(52, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/contact', 'contact', 'http://localhost/saleemsial-laravel-cms/public/blog', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:31:10', '2026-03-16 14:31:10', '2026-03-16 14:31:10', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(53, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/blog', 'blog', 'http://localhost/saleemsial-laravel-cms/public/contact', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:31:16', '2026-03-16 14:31:16', '2026-03-16 14:31:16', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(54, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/contact', 'contact', 'http://localhost/saleemsial-laravel-cms/public/blog', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:31:25', '2026-03-16 14:31:25', '2026-03-16 14:31:25', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(55, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/admin/dashboard', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:36:22', '2026-03-16 14:36:22', '2026-03-16 14:36:22', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(56, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/admin/dashboard', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:36:43', '2026-03-16 14:36:43', '2026-03-16 14:36:43', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(57, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/admin/dashboard', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:38:32', '2026-03-16 14:38:32', '2026-03-16 14:38:32', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(58, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/admin/dashboard', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:40:55', '2026-03-16 14:40:55', '2026-03-16 14:40:55', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(59, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/admin/dashboard', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:41:37', '2026-03-16 14:41:37', '2026-03-16 14:41:37', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(60, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/admin/dashboard', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:55:29', '2026-03-16 14:55:29', '2026-03-16 14:55:29', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(61, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/blog', 'blog', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:58:07', '2026-03-16 14:58:07', '2026-03-16 14:58:07', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(62, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/blog', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 14:59:12', '2026-03-16 14:59:12', '2026-03-16 14:59:12', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(63, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/blog', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:03:02', '2026-03-16 15:03:02', '2026-03-16 15:03:02', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(64, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/blog', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:03:03', '2026-03-16 15:03:03', '2026-03-16 15:03:03', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(65, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/blog', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:03:25', '2026-03-16 15:03:25', '2026-03-16 15:03:25', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(66, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/blog', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (Linux; Android 13; SM-G981B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', '2026-03-16 15:04:27', '2026-03-16 15:04:27', '2026-03-16 15:04:27', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(67, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/blog', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:06:38', '2026-03-16 15:06:38', '2026-03-16 15:06:38', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(68, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/blog', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:12:52', '2026-03-16 15:12:52', '2026-03-16 15:12:52', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(69, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/service/tiktok-ads-tracking', 'services.show', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:16:36', '2026-03-16 15:16:36', '2026-03-16 15:16:36', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(70, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/service/tiktok-ads-tracking', 'services.show', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:16:36', '2026-03-16 15:16:36', '2026-03-16 15:16:36', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(71, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:16:54', '2026-03-16 15:16:54', '2026-03-16 15:16:54', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(72, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:20:14', '2026-03-16 15:20:14', '2026-03-16 15:20:14', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(73, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:33:02', '2026-03-16 15:33:02', '2026-03-16 15:33:02', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(74, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:36:26', '2026-03-16 15:36:26', '2026-03-16 15:36:26', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(75, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:37:08', '2026-03-16 15:37:08', '2026-03-16 15:37:08', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(76, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:37:34', '2026-03-16 15:37:34', '2026-03-16 15:37:34', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(77, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:38:55', '2026-03-16 15:38:55', '2026-03-16 15:38:55', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(78, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:41:05', '2026-03-16 15:41:05', '2026-03-16 15:41:05', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(79, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:43:22', '2026-03-16 15:43:22', '2026-03-16 15:43:22', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(80, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:45:59', '2026-03-16 15:45:59', '2026-03-16 15:45:59', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(81, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:47:06', '2026-03-16 15:47:06', '2026-03-16 15:47:06', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(82, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:51:40', '2026-03-16 15:51:40', '2026-03-16 15:51:40', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(83, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:56:56', '2026-03-16 15:56:56', '2026-03-16 15:56:56', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(84, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 15:59:34', '2026-03-16 15:59:34', '2026-03-16 15:59:34', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(85, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 16:10:45', '2026-03-16 16:10:45', '2026-03-16 16:10:45', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(86, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/', 'home', 'http://localhost/saleemsial-laravel-cms/public/service/tiktok-ads-tracking', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'mobile', 'Mozilla/5.0 (Linux; Android 13; SM-G981B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', '2026-03-16 16:18:23', '2026-03-16 16:18:23', '2026-03-16 16:18:23', 'US', 'United States', 'localhost', 'direct', 'direct', NULL),
(87, 'FOxayoUl7nkO9SV96YP5w6W7J65RxfECMwImao6n', '/contact', 'contact', 'http://localhost/saleemsial-laravel-cms/public/', 'eff8e7ca506627fe15dda5e0e512fcaad70b6d520f37cc76597fdb4f2d83a1a3', 'desktop', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-16 16:21:19', '2026-03-16 16:21:19', '2026-03-16 16:21:19', 'US', 'United States', 'localhost', 'direct', 'direct', NULL);

-- Deferred foreign keys
ALTER TABLE `blog_posts` ADD CONSTRAINT `fk_blog_posts_0` FOREIGN KEY (`featured_image_media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;
ALTER TABLE `media` ADD CONSTRAINT `fk_media_0` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;
ALTER TABLE `media_usages` ADD CONSTRAINT `fk_media_usages_0` FOREIGN KEY (`media_id`) REFERENCES `media` (`id`) ON DELETE CASCADE;
ALTER TABLE `services` ADD CONSTRAINT `fk_services_0` FOREIGN KEY (`icon_media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;
ALTER TABLE `services` ADD CONSTRAINT `fk_services_1` FOREIGN KEY (`image_media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;
ALTER TABLE `settings` ADD CONSTRAINT `fk_settings_0` FOREIGN KEY (`favicon_media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;
ALTER TABLE `settings` ADD CONSTRAINT `fk_settings_1` FOREIGN KEY (`logo_media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;
ALTER TABLE `users` ADD CONSTRAINT `fk_users_0` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE SET NULL;

SET FOREIGN_KEY_CHECKS=1;
