-- Adminer 5.3.0 MySQL 8.4.3 dump

SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';



CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` varchar(255) 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`),
  KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` smallint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `locations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `locations_name_unique` (`name`),
  UNIQUE KEY `locations_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `locations` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1,	'Madurai',	'madurai',	1,	'2026-08-12 04:20:36',	'2026-08-12 04:20:51',	NULL),
(2,	't1',	't1',	1,	'2026-08-12 04:44:27',	'2026-08-12 04:44:27',	NULL);

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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_06_25_000001_create_locations_table',	2),
(5,	'2026_06_25_000002_create_services_table',	2),
(6,	'2026_06_25_000003_create_service_location_pages_table',	2);


CREATE TABLE `service_location_pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `service_id` bigint unsigned NOT NULL,
  `location_id` bigint unsigned NOT NULL,
  `url_slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_content` longtext COLLATE utf8mb4_unicode_ci,
  `meta_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `meta_keyword` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `deactivated_by_service` tinyint(1) NOT NULL DEFAULT '0',
  `is_manually_edited` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `service_location_unique` (`service_id`,`location_id`),
  UNIQUE KEY `service_location_pages_url_slug_unique` (`url_slug`),
  KEY `service_location_pages_location_id_foreign` (`location_id`),
  CONSTRAINT `service_location_pages_location_id_foreign` FOREIGN KEY (`location_id`) REFERENCES `locations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `service_location_pages_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `service_location_pages` (`id`, `service_id`, `location_id`, `url_slug`, `page_title`, `page_content`, `meta_title`, `meta_description`, `meta_keyword`, `is_active`, `deactivated_by_service`, `is_manually_edited`, `created_at`, `updated_at`) VALUES
(1,	1,	1,	'block-chain-development-company-in-madurai',	'Block Chain Development Company in Madurai',	'Block Chain Development Company in Madurai',	'Block Chain Development Company in Madurai',	'Best Block Chain Development Company services in Madurai. Contact us today.',	'dfdsadsad',	0,	0,	1,	'2026-08-12 04:21:38',	'2026-08-12 04:43:03'),
(2,	1,	2,	'block-chain-development-company-in-t1',	'Block Chain Development Company in t1',	'<section class=\"hero-section\">\r\n    <svg width=\"0\" height=\"0\" class=\"position-absolute d-none\">\r\n      <defs>\r\n        <clipPath id=\"hero-curve\" clipPathUnits=\"objectBoundingBox\">\r\n          <path d=\"M 0.05,0 Q 0.55,0.45 0.40,1 L 1,1 L 1,0 Z\" />\r\n        </clipPath>\r\n      </defs>\r\n    </svg>\r\n\r\n    <div class=\"hero-image-bg\"></div>\r\n\r\n    <div class=\"hero-gradient-line\">\r\n      <img src=\"{ASSET}dynamic_page/assets/images/gradient-line.png}\" alt=\"Decorative line\" class=\"gradient-line-img\">\r\n    </div>\r\n\r\n    <div class=\"container position-relative z-1\">\r\n      <div class=\"row align-items-center hero-row\">\r\n        <div class=\"col-lg-6\">\r\n          <div class=\"hero-content\">\r\n            <div>\r\n              <h1>AI Artificial Intelligence<br>Course in t1</h1>\r\n              <p class=\"hero-description\">\r\n                Looking for the best AI Artificial Intelligence Course in t1? BSEtec Training Center offers\r\n                industry-focused AI training with hands-on projects, expert mentors, live sessions, and career support\r\n                to help you become job-ready.\r\n              </p>\r\n              <a href=\"#\" class=\"btn-enroll\">\r\n                <span class=\"hero-enroll-icon\">\r\n                  <img src=\"{ASSET}dynamic_page/assets/icons/rocket-icon.png\" alt=\"Enroll Icon\" class=\"me-2\">\r\n                </span> Enroll Now\r\n              </a>\r\n            </div>\r\n          </div>\r\n        </div>\r\n        <div class=\"col-lg-6 d-none d-lg-block\"></div>\r\n      </div>\r\n    </div>\r\n  </section>',	'Block Chain Development Company in t1 | BSEtec Training Center',	'Join the best Block Chain Development Company in t1 at BSEtec Training Center. Learn Generative AI, Machine Learning, Prompt Engineering, Python, AI Agents, and more with hands-on projects and expert mentorship. Enroll today!',	'Block Chain Development Company, t1, Block Chain Development Company in t1',	1,	0,	1,	'2026-08-12 04:44:37',	'2026-08-12 05:21:40'),
(3,	2,	1,	'ai-artificial-intelligence-course-in-madurai',	'AI Artificial Intelligence Course in Madurai',	'<section class=\"hero-section\">\r\n    <svg width=\"0\" height=\"0\" class=\"position-absolute d-none\">\r\n      <defs>\r\n        <clipPath id=\"hero-curve\" clipPathUnits=\"objectBoundingBox\">\r\n          <path d=\"M 0.05,0 Q 0.55,0.45 0.40,1 L 1,1 L 1,0 Z\" />\r\n        </clipPath>\r\n      </defs>\r\n    </svg>\r\n\r\n    <div class=\"hero-image-bg\"></div>\r\n\r\n    <div class=\"hero-gradient-line\">\r\n      <img src=\"{ASSET}dynamic_page/assets/images/gradient-line.png}\" alt=\"Decorative line\" class=\"gradient-line-img\">\r\n    </div>\r\n\r\n    <div class=\"container position-relative z-1\">\r\n      <div class=\"row align-items-center hero-row\">\r\n        <div class=\"col-lg-6\">\r\n          <div class=\"hero-content\">\r\n            <div>\r\n              <h1>AI Artificial Intelligence<br>Course in Madurai</h1>\r\n              <p class=\"hero-description\">\r\n                Looking for the best AI Artificial Intelligence Course in Madurai? BSEtec Training Center offers\r\n                industry-focused AI training with hands-on projects, expert mentors, live sessions, and career support\r\n                to help you become job-ready.\r\n              </p>\r\n              <a href=\"#\" class=\"btn-enroll\">\r\n                <span class=\"hero-enroll-icon\">\r\n                  <img src=\"{ASSET}dynamic_page/assets/icons/rocket-icon.png\" alt=\"Enroll Icon\" class=\"me-2\">\r\n                </span> Enroll Now\r\n              </a>\r\n            </div>\r\n          </div>\r\n        </div>\r\n        <div class=\"col-lg-6 d-none d-lg-block\"></div>\r\n      </div>\r\n    </div>\r\n  </section>',	'AI Artificial Intelligence Course in Madurai | BSEtec Training Center',	'Join the best AI Artificial Intelligence Course in Madurai at BSEtec Training Center. Learn Generative AI, Machine Learning, Prompt Engineering, Python, AI Agents, and more with hands-on projects and expert mentorship. Enroll today!',	'AI Artificial Intelligence Course, AI Course in Madurai, Artificial Intelligence Training, Best AI Course in Madurai, AI Certification Course, Generative AI Course, Machine Learning Course, Prompt Engineering Course, Python for AI, AI Training Center, AI Classes in Madurai, AI Institute in Madurai, AI Career Course, AI Skills Training, BSEtec Training Center',	1,	0,	1,	'2026-08-12 06:20:45',	'2026-08-12 06:39:29');

CREATE TABLE `services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_content` longtext COLLATE utf8mb4_unicode_ci,
  `meta_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `meta_keyword` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `services_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `services` (`id`, `name`, `slug`, `page_content`, `meta_title`, `meta_description`, `meta_keyword`, `is_active`, `created_at`, `updated_at`) VALUES
(1,	'Block Chain Development Company',	'block-chain-development-company',	'<section class=\"hero-section\">\r\n    <svg width=\"0\" height=\"0\" class=\"position-absolute d-none\">\r\n      <defs>\r\n        <clipPath id=\"hero-curve\" clipPathUnits=\"objectBoundingBox\">\r\n          <path d=\"M 0.05,0 Q 0.55,0.45 0.40,1 L 1,1 L 1,0 Z\" />\r\n        </clipPath>\r\n      </defs>\r\n    </svg>\r\n\r\n    <div class=\"hero-image-bg\"></div>\r\n\r\n    <div class=\"hero-gradient-line\">\r\n      <img src=\"{ASSET}academics/images/gradient-line.png}\" alt=\"Decorative line\" class=\"gradient-line-img\">\r\n    </div>\r\n\r\n    <div class=\"container position-relative z-1\">\r\n      <div class=\"row align-items-center hero-row\">\r\n        <div class=\"col-lg-6\">\r\n          <div class=\"hero-content\">\r\n            <div>\r\n              <h1>AI Artificial Intelligence<br>Course in {location}</h1>\r\n              <p class=\"hero-description\">\r\n                Looking for the best AI Artificial Intelligence Course in {location}? BSEtec Training Center offers\r\n                industry-focused AI training with hands-on projects, expert mentors, live sessions, and career support\r\n                to help you become job-ready.\r\n              </p>\r\n              <a href=\"#\" class=\"btn-enroll\">\r\n                <span class=\"hero-enroll-icon\">\r\n                  <img src=\"{ASSET}public/academics/icons/rocket-icon.png\" alt=\"Enroll Icon\" class=\"me-2\">\r\n                </span> Enroll Now\r\n              </a>\r\n            </div>\r\n          </div>\r\n        </div>\r\n        <div class=\"col-lg-6 d-none d-lg-block\"></div>\r\n      </div>\r\n    </div>\r\n  </section>',	'{service} in {location} | BSEtec Training Center',	'Join the best {service} in {location} at BSEtec Training Center. Learn Generative AI, Machine Learning, Prompt Engineering, Python, AI Agents, and more with hands-on projects and expert mentorship. Enroll today!',	NULL,	1,	'2026-08-12 04:21:38',	'2026-08-12 05:16:05'),
(2,	'AI Artificial Intelligence Course',	'ai-artificial-intelligence-course',	'<section class=\"hero-section\">\r\n    <svg width=\"0\" height=\"0\" class=\"position-absolute d-none\">\r\n      <defs>\r\n        <clipPath id=\"hero-curve\" clipPathUnits=\"objectBoundingBox\">\r\n          <path d=\"M 0.05,0 Q 0.55,0.45 0.40,1 L 1,1 L 1,0 Z\" />\r\n        </clipPath>\r\n      </defs>\r\n    </svg>\r\n\r\n    <div class=\"hero-image-bg\"></div>\r\n\r\n    <div class=\"hero-gradient-line\">\r\n      <img src=\"{ASSET}dynamic_page/assets/images/gradient-line.png}\" alt=\"Decorative line\" class=\"gradient-line-img\">\r\n    </div>\r\n\r\n    <div class=\"container position-relative z-1\">\r\n      <div class=\"row align-items-center hero-row\">\r\n        <div class=\"col-lg-6\">\r\n          <div class=\"hero-content\">\r\n            <div>\r\n              <h1>AI Artificial Intelligence<br>Course in {location}</h1>\r\n              <p class=\"hero-description\">\r\n                Looking for the best AI Artificial Intelligence Course in {location}? BSEtec Training Center offers\r\n                industry-focused AI training with hands-on projects, expert mentors, live sessions, and career support\r\n                to help you become job-ready.\r\n              </p>\r\n              <a href=\"#\" class=\"btn-enroll\">\r\n                <span class=\"hero-enroll-icon\">\r\n                  <img src=\"{ASSET}dynamic_page/assets/academics/icons/rocket-icon.png\" alt=\"Enroll Icon\" class=\"me-2\">\r\n                </span> Enroll Now\r\n              </a>\r\n            </div>\r\n          </div>\r\n        </div>\r\n        <div class=\"col-lg-6 d-none d-lg-block\"></div>\r\n      </div>\r\n    </div>\r\n  </section>',	'{service} in {location} | BSEtec Training Center',	'Join the best {service} in {location} at BSEtec Training Center. Learn Generative AI, Machine Learning, Prompt Engineering, Python, AI Agents, and more with hands-on projects and expert mentorship. Enroll today!',	'{service}, AI Course in {location}, Artificial Intelligence Training, Best AI Course in {location}, AI Certification Course, Generative AI Course, Machine Learning Course, Prompt Engineering Course, Python for AI, AI Training Center, AI Classes in {location}, AI Institute in {location}, AI Career Course, AI Skills Training, BSEtec Training Center',	1,	'2026-08-12 06:20:45',	'2026-08-12 06:40:03');

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,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('DBKUCYy51ctZfmmLnuOSb1o6VcaKRxvhPsbecI2z',	NULL,	'127.0.0.1',	'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:153.0) Gecko/20100101 Firefox/153.0',	'eyJfdG9rZW4iOiIwUEJVc0NodE81UnRYRmlmT1RKWjhOdWhxUlNOdGR0T0ZBZ2UxQkhEIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdDo4MDAwIiwicm91dGUiOm51bGx9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19',	1786514559);

-- 2026-08-25 13:01:13 UTC
