-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 01, 2025 at 05:23 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `armore` -- -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `author` varchar(255) NOT NULL, `category_id` int(11) NOT NULL, `content` text NOT NULL, `slug` varchar(255) NOT NULL, `status` enum('active','inactive') DEFAULT 'inactive', `publish_date` date NOT NULL, `images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`images`)), `seo_title` text DEFAULT NULL, `seo_description` text DEFAULT NULL, `seo_keywords` text DEFAULT NULL, `faqs` longtext DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `blogs` -- INSERT INTO `blogs` (`id`, `title`, `author`, `category_id`, `content`, `slug`, `status`, `publish_date`, `images`, `seo_title`, `seo_description`, `seo_keywords`, `faqs`, `created_at`, `updated_at`) VALUES (4, 'Russia and Ukrainian War- Impact on...', 'vikas kesar', 1, '

University Categories and Admissions

Universities are often classified into various categories to help students select the best option based on their preferences and needs. These categories include:

  1. Public vs Private Universities:
  2. Public Universities: These are government-funded institutions that generally have lower tuition fees for domestic students. They often offer a wide variety of programs and have strong research facilities.
  3. Private Universities: These universities are privately funded and tend to offer specialized courses with a focus on providing quality education. Tuition fees may be higher compared to public universities.
  4. Undergraduate and Graduate Programs:
  5. Undergraduate Programs: These programs typically include bachelor\'s degrees in fields such as arts, science, engineering, medicine, and more. They are generally for students who have completed their high school education.
  6. Graduate Programs: These are advanced programs that lead to master\'s degrees or doctoral degrees. They often require specific prerequisites and qualifications such as a bachelor\'s degree in a related field.
  7. Top Ranking Universities:
  8. Some universities are ranked higher due to their academic reputation, research outputs, faculty, and alumni success. Top universities offer globally recognized degrees and extensive academic resources.
  9. International Universities:
  10. Many universities operate internationally, offering programs that allow students to study abroad. International universities are popular among students looking for global exposure and advanced learning.
  11. State-wise Universities:
  12. Universities may also be categorized based on their location, particularly if they are specific to a particular state or region. These institutions focus on the needs and opportunities of students within that geographic area




', 'importance-of-universities-in-shaping-futures', 'active', '2024-12-05', '\"[\\\"blog_images\\\\\\/LPKBcuqrvgrh9LujY7f2RqbU5ds2BZgmP6ezTHhx.jpg\\\"]\"', 'fghfg', 'fghfg', '[{\"value\":\"ggh\"},{\"value\":\"hfg\"},{\"value\":\"hfgh\"}]', '[{\"question\":\"yy\",\"answer\":\"yyy\"},{\"question\":\"ryt\",\"answer\":\"yrtyrt\"}]', '2024-12-05 01:15:21', '2025-01-18 06:04:40'), (5, 'PG in Germany', 'Saurabh kesare', 1, '

University Categories and Admissions

Universities are often classified into various categories to help students select the best option based on their preferences and needs. These categories include:

  1. Public vs Private Universities:
  2. Public Universities: These are government-funded institutions that generally have lower tuition fees for domestic students. They often offer a wide variety of programs and have strong research facilities.
  3. Private Universities: These universities are privately funded and tend to offer specialized courses with a focus on providing quality education. Tuition fees may be higher compared to public universities.
  4. Undergraduate and Graduate Programs:
  5. Undergraduate Programs: These programs typically include bachelor\'s degrees in fields such as arts, science, engineering, medicine, and more. They are generally for students who have completed their high school education.
  6. Graduate Programs: These are advanced programs that lead to master\'s degrees or doctoral degrees. They often require specific prerequisites and qualifications such as a bachelor\'s degree in a related field.
  7. Top Ranking Universities:
  8. Some universities are ranked higher due to their academic reputation, research outputs, faculty, and alumni success. Top universities offer globally recognized degrees and extensive academic resources.
  9. International Universities:
  10. Many universities operate internationally, offering programs that allow students to study abroad. International universities are popular among students looking for global exposure and advanced learning.
  11. State-wise Universities:
  12. Universities may also be categorized based on their location, particularly if they are specific to a particular state or region. These institutions focus on the needs and opportunities of students within that geographic area



', 'the-role-of-universities-in-career-development', 'active', '2024-12-14', '\"[\\\"blog_images\\\\\\/9IUA3pS4GSrH4BPUG7cMTsamvYTPlxZu5UnUd6ld.jpg\\\"]\"', 'yrty', 'yrtyrt', '[{\"value\":\"jg\"},{\"value\":\"ghj\"},{\"value\":\"try\"},{\"value\":\"yrty\"}]', '[{\"question\":\"tyrty\",\"answer\":\"rytryr\"},{\"question\":\"yrty\",\"answer\":\"tryrt\"}]', '2024-12-05 01:16:54', '2025-01-20 01:09:29'), (6, 'PG in Belarus', 'Gagan', 2, '

University Categories and Admissions

Universities are often classified into various categories to help students select the best option based on their preferences and needs. These categories include:

  1. Public vs Private Universities:
  2. Public Universities: These are government-funded institutions that generally have lower tuition fees for domestic students. They often offer a wide variety of programs and have strong research facilities.
  3. Private Universities: These universities are privately funded and tend to offer specialized courses with a focus on providing quality education. Tuition fees may be higher compared to public universities.
  4. Undergraduate and Graduate Programs:
  5. Undergraduate Programs: These programs typically include bachelor\'s degrees in fields such as arts, science, engineering, medicine, and more. They are generally for students who have completed their high school education.
  6. Graduate Programs: These are advanced programs that lead to master\'s degrees or doctoral degrees. They often require specific prerequisites and qualifications such as a bachelor\'s degree in a related field.
  7. Top Ranking Universities:
  8. Some universities are ranked higher due to their academic reputation, research outputs, faculty, and alumni success. Top universities offer globally recognized degrees and extensive academic resources.
  9. International Universities:
  10. Many universities operate internationally, offering programs that allow students to study abroad. International universities are popular among students looking for global exposure and advanced learning.
  11. State-wise Universities:
  12. Universities may also be categorized based on their location, particularly if they are specific to a particular state or region. These institutions focus on the needs and opportunities of students within that geographic area




', 'pg-in-belarus', 'active', '2024-12-18', '\"[\\\"blog_images\\\\\\/P4spaFY7NTXjPhzBgQRrxMUmPVlRpjDDcrXJON50.jpg\\\"]\"', 'yrtyr', 'ytryrt', '[{\"value\":\"yry\"},{\"value\":\"yrt\"},{\"value\":\"rty\"},{\"value\":\"yrty\"}]', '[{\"question\":\"yrt\",\"answer\":\"yrtyrty\"},{\"question\":\"yrty\",\"answer\":\"yrtyrt\"}]', '2024-12-05 01:17:35', '2025-01-20 01:09:48'); -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `status` enum('active','inactive') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES (1, 'Security Solutions', 'active', '2024-12-04 05:04:23', '2025-03-01 08:25:52'), (2, 'Failities Management', 'active', '2024-12-04 05:05:25', '2025-03-01 08:26:38'); -- -------------------------------------------------------- -- -- Table structure for table `enquiries` -- CREATE TABLE `enquiries` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `mobile_no` varchar(20) NOT NULL, `questions` text NOT NULL, `status` enum('active','inactive') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `location` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `enquiries` -- INSERT INTO `enquiries` (`id`, `name`, `email`, `mobile_no`, `questions`, `status`, `created_at`, `updated_at`, `location`) VALUES (65, 'vikas kesar', 'vikas@gmail.com', '9125126121', 'no Enquary', 'active', '2025-03-01 04:27:26', '2025-03-01 04:27:26', 'contact-us'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `faqs` -- CREATE TABLE `faqs` ( `id` int(11) NOT NULL, `question` varchar(255) NOT NULL, `answer` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `faqs` -- INSERT INTO `faqs` (`id`, `question`, `answer`, `created_at`, `updated_at`) VALUES (2, 'Is MBBS from other countries valid in India?', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. How much score in NEET do I need to study MBBS abroad? \r\n\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. How much score in NEET do I need to study MBBS abroad?', '2024-12-04 01:37:25', '2024-12-04 03:03:23'), (3, 'Is their any exit / qualifying exam in India after studying MBBS from Abroad?', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. How much score in NEET do I need to study MBBS abroad?', '2024-12-04 03:03:39', '2024-12-13 01:20:05'), (4, 'How much does it cost to study MBBS abroad?', 'Is there any exit/qualifying test in India after completing MBBS from abroad?', '2024-12-04 03:03:54', '2024-12-04 03:03:54'), (5, 'Is NEET mandatory for studying MBBS Abroad?', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. How much score in NEET do I need to study MBBS abroad?', '2024-12-04 03:04:07', '2024-12-13 01:20:19'), (6, 'What is Duration of studying MBBS Abroad?', 'Apart from the pre-admission guidance, we\r\ntake responsibility to help you throughout\r\nyour study program.', '2024-12-04 03:04:30', '2024-12-13 01:20:59'), (7, 'Is Living Cost is Europe Expensive?', 'Is Living Cost is Europe Expensive?Is Living Cost is Europe Expensive?Is Living Cost is Europe Expensive?Is Living Cost is Europe Expensive?Is Living Cost is Europe Expensive?Is Living Cost is Europe Expensive?Is Living Cost is Europe Expensive?Is Living Cost is Europe Expensive?Is Living Cost is Europe Expensive?', '2024-12-13 01:21:14', '2024-12-13 01:21:14'), (8, 'What are the Top Medical Universities in Abroad?', 'What are the Top Medical Universities in Abroad?What are the Top Medical Universities in Abroad?What are the Top Medical Universities in Abroad?', '2024-12-13 01:21:32', '2024-12-13 01:21:32'), (9, 'Is Indian food available in Abroad Universities?', 'Is Indian food available in Abroad Universities? Is Indian food available in Abroad Universities? Is Indian food available in Abroad Universities?', '2024-12-13 01:21:47', '2024-12-13 01:21:47'), (10, 'Is Part-Time Job available while studying MBBS in Abroad Universities?', 'Is Part-Time Job available while studying MBBS in Abroad Universities? \r\nIs Part-Time Job available while studying MBBS in Abroad Universities? \r\nIs Part-Time Job available while studying MBBS in Abroad Universities?', '2024-12-13 01:21:58', '2024-12-13 01:21:58'); -- -------------------------------------------------------- -- -- Table structure for table `general_settings` -- CREATE TABLE `general_settings` ( `id` int(11) NOT NULL, `site_name` varchar(255) NOT NULL, `site_description` text DEFAULT NULL, `site_keywords` text DEFAULT NULL, `contact_email` varchar(255) DEFAULT NULL, `phone_number` varchar(20) DEFAULT NULL, `facebook_link` varchar(255) DEFAULT NULL, `twitter_link` varchar(255) DEFAULT NULL, `instagram_link` varchar(255) DEFAULT NULL, `linkedin_link` varchar(255) DEFAULT NULL, `meta_title` varchar(255) DEFAULT NULL, `meta_description` text DEFAULT NULL, `meta_keywords` text DEFAULT NULL, `header_logo` varchar(255) DEFAULT NULL, `footer_logo` varchar(255) DEFAULT NULL, `contact_address` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `general_settings` -- INSERT INTO `general_settings` (`id`, `site_name`, `site_description`, `site_keywords`, `contact_email`, `phone_number`, `facebook_link`, `twitter_link`, `instagram_link`, `linkedin_link`, `meta_title`, `meta_description`, `meta_keywords`, `header_logo`, `footer_logo`, `contact_address`, `created_at`, `updated_at`) VALUES (1, 'Armore', 'it\'s an adventure! Leaving one\'s country and going abroad to study isn’t that easy.', 'website, blog, articles, tutorials', 'armour_guards@yahoo.co.in', '+91 9810139833', 'https://facebook.com/mywebsite', 'https://twitter.com/mywebsite', 'https://instagram.com/mywebsite', 'https://linkedin.com/mywebsite', 'Welcome to My Website', 'This is the meta description for my website.', 'meta, keywords, SEO', 'logos/Ua3l5mQpyWdUkdYRKYcZ4JuABpIed6Wd5RCu1CMv.png', 'logos/BIUNRp2fDkE4ACxNcs47vPT7eEHFu2P70hxc23ki.png', 'B-87, 2 nd floor , Defence Colony New Delhi - 110 024 India', '2024-12-11 11:10:41', '2025-02-28 23:59:07'); -- -------------------------------------------------------- -- -- 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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (5, '0001_01_01_000000_create_users_table', 1), (6, '0001_01_01_000001_create_cache_table', 1), (7, '0001_01_01_000002_create_jobs_table', 1), (8, '2024_08_13_102039_add_users_table', 1), (9, '2025_01_20_112156_create_fast_facts_table', 2), (10, '2025_01_21_071318_create_why_studies_table', 3), (11, '2025_01_21_094623_create_medium_of_teachings_table', 4); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` int(11) NOT NULL, `heading` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `category_id` int(11) NOT NULL, `description` text DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `heading`, `slug`, `category_id`, `description`, `image`, `created_at`, `updated_at`) VALUES (1, 'ggg', 'ggg', 2, 'dfbhgrdcdfd', 'products/ymWahuU8vxJO9o4Xg1vOBsCoTBcpIDJuQjtLKJZa.jpg', '2025-03-01 09:28:14', '2025-03-01 09:34:47'); -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('9JbUdRz1n8isgmjdWzlSMW2O9f3ExNr3NTMwCZi5', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiYmJpdzVYcGloamVTOWhRd3BHbjhCQ04zaTl0NkMzdExGdFJUMEY4WiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9wcm9kdWN0cy9mYWlsaXRpZXMtbWFuYWdlbWVudC9nZ2ciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUyOiJsb2dpbl9hZG1pbl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1740845963); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(11) NOT NULL, `content` longtext DEFAULT NULL, `image1` varchar(255) DEFAULT NULL, `image2` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `type` varchar(50) DEFAULT 'about_us' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `content`, `image1`, `image2`, `created_at`, `updated_at`, `type`) VALUES (1, '

About Us

Lorem ipsum dolor sit amet consectetur adipisicing elit. Suscipit est ut quibusdam ab, et perferendis facere provident commodi natus non, vitae magnam in ipsum aspernatur. Odit repellendus saepe ut voluptas quam minima minus eaque, dolor quia, quis aliquid dolore? Quidem? Lorem ipsum dolor sit amet consectetur, adipisicing elit. Adipisci quis pariatur atque doloribus reiciendis, non repellendus dolore ullam nam, laboriosam eum consectetur ipsum laudantium consequatur, animi quas accusantium quae? Quae?


', 'about_us_images1/LFQmiGvt1IxrCf255cmLr1fuxw4DLNyzRiUWgk8X.jpg', 'about_us_images2/eqH7DakI1vj7OgAtI60wRBAoqf1URIZ0H8YraxAu.jpg', '2024-12-06 04:16:41', '2025-03-01 00:55:59', 'about_us'), (2, '

The Admission Advisor

Best Countries to Study MBBS Abroad

It\'s an adventure! Leaving one\'s country and going abroad to study isn’t easy. However, for medical students, there are many benefits to studying overseas (outside India).

Here are some reasons why you should pursue medical/MBBS education outside of India. However, ensure that you apply to great countries and good universities since the standards of education may vary.

1. CULTURAL EXPOSURE

2. GLOBAL NETWORKING

3. QUALITY EDUCATION

4. PERSONAL GROWTH

', 'why_study_mbbs_abroad/KjoiUmRTPCNem7FyGKSuf0creJ6hq9i6RUMnqvtB.png', NULL, '2024-12-06 04:54:26', '2025-01-31 05:28:47', 'why_study_mbbs_abroad'), (4, 'This is the third About Us data.', 'about_us_image3.jpg', NULL, '2024-12-06 04:54:26', '2024-12-06 04:54:26', 'about_us'), (5, '

📜 Privacy Policy

Last Updated:

1. Introduction

The Admission Advisor is committed to protecting your privacy. This policy explains how we collect, use, and safeguard your personal information when you use our website.

2. Information We Collect

We may collect the following types of information:

  1. Personal Information: Name, email, phone number, etc.
  2. Academic Details: Course preferences, past education details, etc.
  3. Technical Data: IP address, browser type, and website usage data.

3. How We Use Your Information

We use your information for:

  1. Processing student applications and guiding admissions.
  2. Sending relevant updates, offers, and notifications.
  3. Improving our website and services.

4. Data Protection & Security

  1. We implement strict security measures to protect your data.
  2. Your personal information is never shared with third parties without consent.

5. Cookies & Tracking Technologies

We use cookies to enhance user experience and analyze website traffic. You can disable cookies in your browser settings.

6. Third-Party Links

Our website may contain links to external websites. We are not responsible for their privacy policies.

7. Your Rights

  1. You can request access, correction, or deletion of your personal data.
  2. You may opt out of receiving marketing emails.

8. Changes to This Policy

We may update this policy from time to time. Changes will be posted on this page.

9. Contact Us

For any privacy-related concerns, contact us at:

📧 Email:

📞 Phone:



', NULL, NULL, '2025-02-03 10:53:26', '2025-03-01 08:21:35', 'privacypolicy'), (6, '

📑 Terms & Conditions

Last Updated:

1. Acceptance of Terms

By using The Admission Advisor website, you agree to these Terms & Conditions.

2. Services Offered

  1. We provide information on foreign colleges, universities, and courses.
  2. We assist students with the admission process.

3. User Responsibilities

  1. Provide accurate and complete information.
  2. Do not misuse the website or its content.
  3. Respect intellectual property rights.

4. Intellectual Property Rights

All website content (text, images, logos, etc.) is owned by The Admission Advisor and cannot be copied or distributed without permission.

5. Limitation of Liability

  1. We strive for accurate information but do not guarantee completeness or correctness.
  2. We are not responsible for any admissions decisions made by universities.

6. Third-Party Services

We may feature third-party services. We are not liable for their policies or actions.

7. Changes to Terms

We may update these terms without prior notice. Users should review them regularly.

8. Termination of Access

We reserve the right to block users violating our terms.

9. Contact Us

For any questions, contact:

📧 Email:

📞 Phone:



', 'tearms_conditions', NULL, '2025-02-03 11:00:15', '2025-03-01 08:21:03', 'tearms_conditions'); -- -------------------------------------------------------- -- -- Table structure for table `sliders` -- CREATE TABLE `sliders` ( `id` int(11) NOT NULL, `heading` varchar(255) NOT NULL, `subheading` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `background_image` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `sliders` -- INSERT INTO `sliders` (`id`, `heading`, `subheading`, `url`, `background_image`, `created_at`, `updated_at`) VALUES (2, 'Tech Target', 'Tech Target', 'https://www.instagram.com/reel/C8hDfvgo7pd/?igsh=MWR2dTQ2OWpoaWd0bg==', 'slider_images/bFVmvfa8U3oHgbj1dYif9lshQe9OCJJTaDdyI3zZ.jpg', '2024-12-05 03:33:35', '2025-03-01 00:46:18'), (3, 'Tech Target Managed', 'Tech Target Managed', 'https://www.instagram.com/reel/C8hDfvgo7pd/?igsh=MWR2dTQ2OWpoaWd0bg==', 'slider_images/NPumqBIUqH3dnefZbZJFaCz1RVHzfy0VDLhBtkvT.jpg', '2024-12-05 03:34:35', '2025-03-01 00:46:56'), (4, 'Managed', 'Tech Target', 'https://www.instagram.com/reel/C8hDfvgo7pd/?igsh=MWR2dTQ2OWpoaWd0bg==', 'slider_images/jJWqWKQK3CvnfLu2mvasR7gMdPPlEsxtRqLtpa7p.png', '2024-12-05 03:52:09', '2025-03-01 00:47:27'); -- -------------------------------------------------------- -- -- Table structure for table `subcategories` -- CREATE TABLE `subcategories` ( `id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `subcategories` -- INSERT INTO `subcategories` (`id`, `category_id`, `name`, `status`, `created_at`, `updated_at`) VALUES (1, 1, 'Integrated Building Security System..', 'active', '2025-03-01 08:56:17', '2025-03-01 09:02:21'); -- -------------------------------------------------------- -- -- Table structure for table `subscriptions` -- CREATE TABLE `subscriptions` ( `id` int(11) NOT NULL, `email` varchar(255) NOT NULL, `created_at` datetime DEFAULT current_timestamp(), `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `subscriptions` -- INSERT INTO `subscriptions` (`id`, `email`, `created_at`, `updated_at`) VALUES (12, 'vikaskesar@gmail.com', '2024-12-20 06:09:34', '2024-12-20 06:09:34'), (21, 'vikaskesar575@gmail.com', '2024-12-20 06:39:15', '2024-12-20 06:39:15'); -- -------------------------------------------------------- -- -- Table structure for table `teams` -- CREATE TABLE `teams` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `designation` varchar(255) NOT NULL, `image` varchar(255) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `teams` -- INSERT INTO `teams` (`id`, `name`, `designation`, `image`, `created_at`, `updated_at`) VALUES (1, 'vikas ji', 'CEO', 'team_images/murOWyAFiUmoE3tPF1PLXK7mq72CTN9GIS8qaBb2.png', '2025-03-01 06:12:33', '2025-03-01 06:12:33'), (2, 'vikas', 'CEO', 'team_images/hKVHc3IAVeZO9em7JasNNxWIbe8h8MaYWpzRsbzs.png', '2025-03-01 06:13:08', '2025-03-01 06:18:47'); -- -------------------------------------------------------- -- -- Table structure for table `testimonials` -- CREATE TABLE `testimonials` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `paragraph` text NOT NULL, `image` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `testimonials` -- INSERT INTO `testimonials` (`id`, `name`, `paragraph`, `image`, `created_at`, `updated_at`) VALUES (4, 'Saurabhkesar', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', 'testimonials/3QkeAt7CF78HKAMMEDMvdSWW3tuElXNPMVizLVkU.png', '2024-12-04 04:30:32', '2025-01-10 07:06:23'), (6, 'vikas kesar', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', 'testimonials/BtdmESBXSY2hpBfJMJS1fKgvBYtgjIZvVD3Szt0G.png', '2024-12-04 04:46:04', '2025-01-10 07:06:39'), (7, 'mohan Singh', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', 'testimonials/PhHjSdSDG7CVhORFIyg9fegZhLADBAKOIjjOz5rv.png', '2024-12-04 04:46:29', '2025-01-10 07:06:54'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `role` enum('customer','admin') NOT NULL DEFAULT 'customer', `about` text DEFAULT NULL, `profile_picture` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `role`, `about`, `profile_picture`) VALUES (1, 'vikas kesar', 'admin@gmail.com', NULL, '$2y$12$mbkg9rKmDS1ganAj7gy6yeeYqVQZOS1p3VVKtGYedrIjSkt5uBfgm', NULL, NULL, '2025-01-20 04:19:33', 'admin', NULL, 'profile_pictures/m2FwfliDh2Hn7x9AReQ4BNWtegDLSXaDkTUHeKOH.webp'), (2, 'vikas', 'admn@gmail.com', NULL, '$2y$12$mbkg9rKmDS1ganAj7gy6yeeYqVQZOS1p3VVKtGYedrIjSkt5uBfgm', NULL, '2025-01-08 07:07:44', '2025-01-08 07:07:44', 'customer', NULL, NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`), ADD KEY `category_id` (`category_id`); -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `enquiries` -- ALTER TABLE `enquiries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `faqs` -- ALTER TABLE `faqs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `general_settings` -- ALTER TABLE `general_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`), ADD KEY `category_id` (`category_id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sliders` -- ALTER TABLE `sliders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `subcategories` -- ALTER TABLE `subcategories` ADD PRIMARY KEY (`id`), ADD KEY `category_id` (`category_id`); -- -- Indexes for table `subscriptions` -- ALTER TABLE `subscriptions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `teams` -- ALTER TABLE `teams` ADD PRIMARY KEY (`id`); -- -- Indexes for table `testimonials` -- ALTER TABLE `testimonials` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `blogs` -- ALTER TABLE `blogs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `enquiries` -- ALTER TABLE `enquiries` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `faqs` -- ALTER TABLE `faqs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `general_settings` -- ALTER TABLE `general_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `sliders` -- ALTER TABLE `sliders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `subcategories` -- ALTER TABLE `subcategories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `subscriptions` -- ALTER TABLE `subscriptions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `teams` -- ALTER TABLE `teams` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `testimonials` -- ALTER TABLE `testimonials` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- Constraints for dumped tables -- -- -- Constraints for table `products` -- ALTER TABLE `products` ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE; -- -- Constraints for table `subcategories` -- ALTER TABLE `subcategories` ADD CONSTRAINT `subcategories_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;