--
-- Host: localhost    Database: ismsglobalnew
-- ------------------------------------------------------


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_name_unique` (`name`),
  UNIQUE KEY `categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (8,'Study Abroad','study-abroad','fa-plane','2026-08-04 02:15:47','2026-08-04 02:15:47'),(9,'Universities','universities','fa-building-columns','2026-08-04 02:15:47','2026-08-04 02:15:47'),(10,'Scholarships','scholarships','fa-graduation-cap','2026-08-04 02:15:47','2026-08-04 02:15:47'),(11,'Visa Guidance','visa-guidance','fa-shield-halved','2026-08-04 02:15:47','2026-08-04 02:15:47'),(12,'Exams','exams','fa-book-open','2026-08-04 02:15:47','2026-08-04 02:15:47'),(13,'Career Tips','career-tips','fa-briefcase','2026-08-04 02:15:47','2026-08-04 02:15:47'),(14,'Student Life','student-life','fa-user-graduate','2026-08-04 02:15:47','2026-08-04 02:15:47'),(15,'fsfsfsf','fsfsfsf','fa-folder-open','2026-08-04 02:56:38','2026-08-04 02:56:38'),(16,'TEST','test','fa-folder-open','2026-08-04 04:39:43','2026-08-04 04:39:43'),(17,'tes12','tes12','fa-folder-open','2026-08-04 04:41:20','2026-08-04 04:41:20'),(18,'TESTING','testing','fa-folder-open','2026-08-04 04:42:01','2026-08-04 04:42:01'),(19,'Education','education','fa-folder-open','2026-08-06 03:39:58','2026-08-06 03:39:58');

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` varchar(255) NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext 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;

--
-- Dumping data for table `failed_jobs`
--


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

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

--
-- Dumping data for table `job_batches`
--


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

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

--
-- Dumping data for table `jobs`
--


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

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` 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_08_04_070732_create_categories_table',2),(5,'2026_08_04_070733_create_posts_table',2),(6,'2026_08_04_074357_add_structured_fields_to_posts_table',3),(7,'2026_08_04_075028_create_personal_access_tokens_table',4),(8,'2026_08_04_082049_add_section_titles_to_posts_table',5),(9,'2026_08_05_102941_add_seo_fields_to_posts_table',6),(10,'2026_08_05_103017_create_post_schemas_table',6),(11,'2026_08_05_103025_create_redirects_table',6),(12,'2026_08_06_072747_change_excerpt_column_type_in_posts_table',7);

--
-- Table structure for table `post_schemas`
--

CREATE TABLE `post_schemas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL,
  `schema_type` varchar(255) NOT NULL,
  `schema_name` varchar(255) NOT NULL,
  `schema_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`schema_data`)),
  `is_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `post_schemas_post_id_foreign` (`post_id`),
  CONSTRAINT `post_schemas_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_schemas`
--

INSERT INTO `post_schemas` VALUES (4,33,'BlogPosting','BlogPosting Schema','{\"admin_description\":\"Main schema for blog post\",\"headline\":null,\"description\":null,\"image_hidden\":null,\"author_type\":\"Organization\",\"author_name\":\"ISMS Global Team\",\"author_url\":\"https:\\/\\/www.ismsglobal.in\\/about-us\",\"publisher_name\":\"ISMS Global\",\"publisher_logo_hidden\":null,\"date_published\":null,\"date_modified\":null}',1,0,'2026-08-06 01:49:35','2026-08-06 01:49:35'),(6,37,'BlogPosting','BlogPosting Schema','{\"admin_description\":\"Main schema for blog post\",\"headline\":null,\"description\":null,\"image_hidden\":null,\"author_type\":\"Organization\",\"author_name\":\"ISMS Global Team\",\"author_url\":\"https:\\/\\/www.ismsglobal.in\\/about-us\",\"publisher_name\":\"ISMS Global\",\"publisher_logo_hidden\":null,\"date_published\":null,\"date_modified\":null}',1,0,'2026-08-06 01:58:49','2026-08-06 01:58:49'),(9,39,'BlogPosting','BlogPosting Schema','{\"admin_description\":\"Main schema for blog post\",\"headline\":null,\"description\":null,\"image_hidden\":null,\"author_type\":\"Organization\",\"author_name\":\"ISMS Global Team\",\"author_url\":\"https:\\/\\/www.ismsglobal.in\\/about-us\",\"publisher_name\":\"ISMS Global\",\"publisher_logo_hidden\":null,\"date_published\":null,\"date_modified\":null}',1,0,'2026-08-06 03:46:41','2026-08-06 03:46:41');

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `excerpt` mediumtext NOT NULL,
  `content` longtext NOT NULL,
  `cover_image` longtext DEFAULT NULL,
  `author_name` varchar(255) NOT NULL DEFAULT 'ISMS Global Team',
  `read_time` int(11) NOT NULL DEFAULT 5,
  `views_count` int(11) NOT NULL DEFAULT 0,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `published_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `advantages` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`advantages`)),
  `popular_courses` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`popular_courses`)),
  `cost_of_studying` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`cost_of_studying`)),
  `advantages_title` varchar(255) DEFAULT NULL,
  `popular_courses_title` varchar(255) DEFAULT NULL,
  `cost_of_studying_title` varchar(255) DEFAULT NULL,
  `custom_sections` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`custom_sections`)),
  `seo_slug` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_keywords` text DEFAULT NULL,
  `canonical_url` varchar(255) DEFAULT NULL,
  `robots_index` varchar(255) NOT NULL DEFAULT 'index',
  `robots_follow` varchar(255) NOT NULL DEFAULT 'follow',
  `social_title` varchar(255) DEFAULT NULL,
  `social_description` text DEFAULT NULL,
  `social_image` longtext DEFAULT NULL,
  `ai_search_summary` text DEFAULT NULL,
  `primary_topic` varchar(255) DEFAULT NULL,
  `related_topics` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`related_topics`)),
  PRIMARY KEY (`id`),
  UNIQUE KEY `posts_slug_unique` (`slug`),
  KEY `posts_category_id_foreign` (`category_id`),
  CONSTRAINT `posts_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` VALUES (15,8,'Study in UK: A Complete Guide for Indian Students 2026','study-in-uk-a-complete-guide-for-indian-students-2026','Everything you need to know about universities, courses, visas, costs and PR opportunities in UK.','This is the full detail content for: Study in UK: A Complete Guide for Indian Students 2026. Everything you need to know about universities, courses, visas, costs and PR opportunities in UK. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/uk-big-ben.jpg','ISMS Global Team',6,120,1,'2026-05-29 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47','[{\"title\":\"Top Universities\",\"icon\":\"fa-building-columns\",\"text\":\"Home to some of the world\'s best universities like Oxford, Cambridge and Imperial College.\"},{\"title\":\"Short-Course Programs\",\"icon\":\"fa-regular fa-calendar-days\",\"text\":\"Undergraduate programs take 3 years and postgraduate 1 year.\"},{\"title\":\"Career Benefits\",\"icon\":\"fa-solid fa-briefcase\",\"text\":\"Global career exposure and highly valued degrees.\"},{\"title\":\"Work Opportunities\",\"icon\":\"fa-solid fa-user-gear\",\"text\":\"Graduate Route allows 2 years of stay and work after studies.\"},{\"title\":\"Diverse Culture\",\"icon\":\"fa-solid fa-earth-americas\",\"text\":\"Students from 200+ countries creating a vibrant community.\"},{\"title\":\"Focus on Research\",\"icon\":\"fa-solid fa-magnifying-glass\",\"text\":\"Strong focus on innovation, research and practical learning.\"},{\"title\":\"Global Recognition\",\"icon\":\"fa-solid fa-award\",\"text\":\"UK degrees are recognized and respected worldwide.\"},{\"title\":\"Cultural Exposure\",\"icon\":\"fa-solid fa-people-group\",\"text\":\"Enhances confidence, communication and life skills.\"}]','[{\"name\":\"MBA\",\"icon\":\"fa-graduation-cap\"},{\"name\":\"MSc Data Science\",\"icon\":\"fa-database\"},{\"name\":\"MSc Computer Science\",\"icon\":\"fa-laptop-code\"},{\"name\":\"Law\",\"icon\":\"fa-scale-balanced\"},{\"name\":\"Engineering\",\"icon\":\"fa-gears\"},{\"name\":\"Psychology\",\"icon\":\"fa-brain\"},{\"name\":\"Business Analytics\",\"icon\":\"fa-chart-simple\"},{\"name\":\"Nursing\",\"icon\":\"fa-user-nurse\"},{\"name\":\"Cyber Security\",\"icon\":\"fa-shield-halved\"},{\"name\":\"Finance\",\"icon\":\"fa-coins\"},{\"name\":\"Public Health\",\"icon\":\"fa-heart-pulse\"}]','[{\"head\":\"Tuition Fees\",\"undergrad\":\"u00a312,000 - u00a320,000\",\"postgrad\":\"u00a314,000 - u00a325,000\"},{\"head\":\"Accommodation\",\"undergrad\":\"u00a35,000 - u00a38,000\",\"postgrad\":\"u00a35,000 - u00a38,000\"},{\"head\":\"Living Expenses\",\"undergrad\":\"u00a37,000 - u00a310,000\",\"postgrad\":\"u00a37,000 - u00a310,000\"},{\"head\":\"Visa & Health Surcharge\",\"undergrad\":\"u00a3776 - u00a31,035\",\"postgrad\":\"u00a3776 - u00a31,035\"},{\"head\":\"Total (Approx.)\",\"undergrad\":\"u00a324,000 - u00a339,000\",\"postgrad\":\"u00a326,000 - u00a344,000\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(16,8,'Study in Australia: Top Universities, Courses & Cost 2026','study-in-australia-top-universities-courses-cost-2026','Explore popular courses, PR opportunities, scholarships and student life in Australia.','This is the full detail content for: Study in Australia: Top Universities, Courses & Cost 2026. Explore popular courses, PR opportunities, scholarships and student life in Australia. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/hero-sydney.jpg','ISMS Global Team',6,110,1,'2026-05-27 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(17,8,'Study in Germany: Tuition-Free Education & Top Universities','study-in-germany-tuition-free-education-top-universities','Why Germany is a top choice for international students in 2026.','This is the full detail content for: Study in Germany: Tuition-Free Education & Top Universities. Why Germany is a top choice for international students in 2026. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/germany.png','ISMS Global Team',5,95,1,'2026-05-25 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(18,8,'Study in Dubai: Top Universities, Courses & Cost 2026','study-in-dubai-top-universities-courses-cost-2026','Discover top-ranked universities, popular courses, and career opportunities in UAE.','This is the full detail content for: Study in Dubai: Top Universities, Courses & Cost 2026. Discover top-ranked universities, popular courses, and career opportunities in UAE. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/burjkhalifa_Sketch.png','ISMS Global Team',5,80,1,'2026-05-23 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(19,10,'Top Scholarships for International Students in 2026','top-scholarships-for-international-students-in-2026','Merit-based, need-based & government scholarships to fund your dream.','This is the full detail content for: Top Scholarships for International Students in 2026. Merit-based, need-based & government scholarships to fund your dream. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/Books.png','ISMS Global Team',4,150,1,'2026-05-21 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(20,11,'Student Visa Process: Step-by-Step Guide for 2026','student-visa-process-step-by-step-guide-for-2026','A complete guide to student visa application and documentation.','This is the full detail content for: Student Visa Process: Step-by-Step Guide for 2026. A complete guide to student visa application and documentation. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/card-vanier.jpg','ISMS Global Team',6,140,1,'2026-05-19 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(21,12,'IELTS vs PTE vs TOEFL: Which Exam is Right for You?','ielts-vs-pte-vs-toefl-which-exam-is-right-for-you','Compare scoring, cost, acceptance and format to choose the best exam.','This is the full detail content for: IELTS vs PTE vs TOEFL: Which Exam is Right for You?. Compare scoring, cost, acceptance and format to choose the best exam. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/Students.png','ISMS Global Team',5,70,1,'2026-05-17 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(22,9,'Top 10 Universities in the World for International Students','top-10-universities-in-the-world-for-international-students','QS ranked universities offering excellent education and global exposure.','This is the full detail content for: Top 10 Universities in the World for International Students. QS ranked universities offering excellent education and global exposure. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/University_Hero.png','ISMS Global Team',5,105,1,'2026-05-15 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(23,14,'Pre-Departure Checklist for International Students','pre-departure-checklist-for-international-students','Important things to do before you fly abroad for your studies.','This is the full detail content for: Pre-Departure Checklist for International Students. Important things to do before you fly abroad for your studies. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/hero-illustration.png','ISMS Global Team',4,60,1,'2026-05-13 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(24,10,'How to Get a Scholarship to Study Abroad in 2026','how-to-get-a-scholarship-to-study-abroad-in-2026','Learn the tips and tricks to secure funding for your international degree.','This is the full detail content for: How to Get a Scholarship to Study Abroad in 2026. Learn the tips and tricks to secure funding for your international degree. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/Books.png','ISMS Global Team',5,200,1,'2026-05-26 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(25,11,'USA Student Visa: F1 Visa Process Explained','usa-student-visa-f1-visa-process-explained','Everything you need to know about preparing for your F1 visa interview and application.','This is the full detail content for: USA Student Visa: F1 Visa Process Explained. Everything you need to know about preparing for your F1 visa interview and application. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/card-vanier.jpg','ISMS Global Team',6,190,1,'2026-05-26 03:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(26,14,'Part-Time Jobs for International Students','part-time-jobs-for-international-students','Find out how to manage study and part-time work balance while studying abroad.','This is the full detail content for: Part-Time Jobs for International Students. Find out how to manage study and part-time work balance while studying abroad. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/Students.png','ISMS Global Team',5,180,1,'2026-05-24 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(27,8,'Study in Canada: PR Pathways After Study','study-in-canada-pr-pathways-after-study','Understand the Post-Graduation Work Permit (PGWP) and pathways to permanent residency in Canada.','This is the full detail content for: Study in Canada: PR Pathways After Study. Understand the Post-Graduation Work Permit (PGWP) and pathways to permanent residency in Canada. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/canada.png','ISMS Global Team',5,170,1,'2026-05-22 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(28,9,'Best Courses to Study Abroad in 2026','best-courses-to-study-abroad-in-2026','A comprehensive review of high-demand jobs and top degrees globally.','This is the full detail content for: Best Courses to Study Abroad in 2026. A comprehensive review of high-demand jobs and top degrees globally. More detailed study information, requirements, application guidelines, eligibility criteria, and step-by-step processes will be described here.','assets/University_Hero.png','ISMS Global Team',5,160,1,'2026-05-20 04:30:00','2026-08-04 02:15:47','2026-08-04 02:15:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL),(29,8,'Study in Germany: Top Universities & Tuition Fees 2026','study-in-germany-top-universities-tuition-fees-2026','Complete guide to study in Germany including cost, universities, and student life.','<h2>Why Study in Germany?</h2><p>Germany offers world-class education with low tuition costs.</p>','assets/germany.png','ISMS Germany Expert',7,2,1,'2026-08-04 02:25:23','2026-08-04 02:25:23','2026-08-06 03:34:32','[{\"title\":\"Tuition-Free\",\"icon\":\"fa-graduation-cap\",\"text\":\"Most public universities offer free tuition.\"},{\"title\":\"Top Engineering\",\"icon\":\"fa-gears\",\"text\":\"Renowned globally for engineering and tech courses.\"}]','[{\"name\":\"Automotive Engineering\",\"icon\":\"fa-car\"},{\"name\":\"Data Science\",\"icon\":\"fa-database\"}]','[{\"head\":\"Tuition Fees\",\"undergrad\":\"u20ac0\",\"postgrad\":\"u20ac0\"},{\"head\":\"Living Costs\",\"undergrad\":\"u20ac900/month\",\"postgrad\":\"u20ac900/month\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'index','follow',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `posts` VALUES (32,16,'TEST','test','121','121','data:image/png;base64,[BLOB]