-- Table structure for table `tbl_order_details`
--

CREATE TABLE `tbl_order_details` (
  `order_detail_id` int(11) NOT NULL AUTO_INCREMENT,
  `customers_id` int(11) NOT NULL,
  `orders_id` int(11) NOT NULL,
  `products_id` int(11) NOT NULL,
  `product_quantity` int(11) NOT NULL,
  `unit_price` decimal(10,2) NOT NULL,
  `discount` decimal(5,2) DEFAULT NULL,
  `total_price` decimal(10,2) NOT NULL,
  `order_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `delivery_date` timestamp NULL DEFAULT NULL,
  `alias` varchar(50) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `seo_keywords` text DEFAULT NULL,
  `seo_title` text DEFAULT NULL,
  `seo_descriptions` text DEFAULT NULL,
  `og_tags` text DEFAULT NULL,
  PRIMARY KEY (`order_detail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `tbl_order_details`
--


--
-- Table structure for table `tbl_orders`
--

CREATE TABLE `tbl_orders` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `customers_id` int(11) NOT NULL,
  `order_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `alias` varchar(50) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `seo_keywords` text DEFAULT NULL,
  `seo_title` text DEFAULT NULL,
  `seo_descriptions` text DEFAULT NULL,
  `og_tags` text DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `tbl_orders`
--


--
-- Table structure for table `tbl_partners`
--

CREATE TABLE `tbl_partners` (
  `partner_id` int(11) NOT NULL AUTO_INCREMENT,
  `display` varchar(255) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`partner_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_partners`
--

INSERT INTO `tbl_partners` VALUES (1,'Migration Institute of Australia','Migration Institute of Australia','','storage/ved/files/1/Partners/icef.JPG','','',1,1,1,1,'2024-05-20 01:25:40','2024-05-20 01:25:40'),(2,'World University Ranking','World University Ranking','','storage/ved/files/1/Partners/airc.JPG','','',2,1,1,1,'2024-05-20 01:25:57','2024-05-20 01:25:57'),(3,'World University Ranking','World University Ranking','','storage/ved/files/1/Partners/world.JPG','','',3,1,1,1,'2024-05-20 01:26:10','2024-05-20 01:26:10');

--
-- Table structure for table `tbl_password_reset_tokens`
--

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

--
-- Dumping data for table `tbl_password_reset_tokens`
--


--
-- Table structure for table `tbl_personal_access_tokens`
--

CREATE TABLE `tbl_personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) DEFAULT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_personal_access_tokens`
--


--
-- Table structure for table `tbl_photos`
--

CREATE TABLE `tbl_photos` (
  `photo_id` int(11) NOT NULL AUTO_INCREMENT,
  `galleries_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`photo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `tbl_photos`
--


--
-- Table structure for table `tbl_popups`
--

CREATE TABLE `tbl_popups` (
  `popup_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `alias` varchar(250) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `photo` varchar(500) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`popup_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_popups`
--

INSERT INTO `tbl_popups` VALUES (1,'About Us','about-us','<p>Dream on Education is a licensed educational consultant who specializes in overseas education services. We are located in Dillibazar (opposite Padma Kanya School), Kathmandu, Nepal, the educational hub of the country.</p>','',1,1,'2024-03-27 00:49:54','2024-03-27 00:49:54',1,1);

--
-- Table structure for table `tbl_positions`
--

CREATE TABLE `tbl_positions` (
  `position_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `vacancies` varchar(255) DEFAULT NULL,
  `alias` varchar(50) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`position_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `tbl_positions`
--

INSERT INTO `tbl_positions` VALUES (1,'Front Desk','2','developer',1,1,1,1,'2024-05-21 04:12:37','2024-06-12 06:36:35'),(2,'Designer','3','designer',2,-1,1,1,'2024-05-21 04:17:59','2024-06-12 06:36:48'),(3,'Project Manager','2','project-manager',3,1,1,1,'2024-05-21 04:18:11','2024-05-21 04:18:11');

--
-- Table structure for table `tbl_preparationclasses`
--

CREATE TABLE `tbl_preparationclasses` (
  `preparationclass_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `parent_preparationclass` int(11) NOT NULL,
  `details` text DEFAULT NULL,
  `intro` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `seo_keywords` text DEFAULT NULL,
  `seo_title` text DEFAULT NULL,
  `seo_descriptions` text DEFAULT NULL,
  `og_tags` text DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`preparationclass_id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_preparationclasses`
--

INSERT INTO `tbl_preparationclasses` VALUES (11,'IELTS','ielts',0,'<p>The International English Language Testing System (IELTS) is an English language competence test that is needed in many countries for education, job, and immigration. It is intended to measure the language competence of non-native English speakers who need to study or work in an English-speaking setting. The test is broken into four sections: hearing, reading, writing, and speaking, and it is graded on a scale of 1 (non-user) to 9 (expert) (expert user). The IELTS exam is widely recognised by colleges, businesses, and immigration agencies in nations such as the United States, the United Kingdom, Australia, and Canada.</p>','Why IELTS?','storage/ved/files/1/Preparation/ielts.png','storage/ved/files/1/Preparation/aus1.png','','',1,1,'2024-05-20 06:29:23','2024-05-23 04:44:55','','','','',1,1),(12,'About IELTS','about-ielts',11,'<div class=\"aos-animate aos-init course__details__tab__wrapper\">\r\n<div class=\"tab-content tab__content__wrapper\" id=\"myTabContent\">\r\n<div class=\"active fade show tab-pane\" id=\"projects__two\">\r\n<div class=\"experence__description\">\r\n<p><strong>The International English Language Testing System or IELTS</strong> is an international standardized test of English language proficiency for non-native English language speakers. It is jointly managed by the <strong>British Council, IDP: IELTS Australia, and Cambridge English Language Assessment</strong> and was established in <strong>1989</strong>. It is one of the major English-language tests in the world, others being the <strong>TOEFL, TOEIC, PTE: A, and OPI/OPIc.</strong></p>\r\n\r\n<p><strong>IELTS</strong> is accepted by most Australian, British, Canadian, and New Zealand academic institutions, by over 3,000 academic institutions in the United States, and by various professional organizations across the world.</p>\r\n\r\n<p><strong>IELTS </strong> the only Secure English Language Test approved by UK Visas and Immigration (UKVI) for visa customers applying both outside and inside the UK. It is also a requirement for immigration to Australia and New Zealand. In Canada, IELTS, TEF, or CELPIP are accepted by the immigration authority.</p>\r\n\r\n<p>No minimum score is required to pass the test. An IELTS result or <strong>Test Report Form </strong> issued to all test takers with a score from <strong>&ldquo;band 1&rdquo; (&ldquo;non-user&rdquo;) to &ldquo;band 9&rdquo; (&ldquo;expert user&rdquo;) </strong> each institution set a different threshold. There is also a &ldquo;band 0&rdquo; score for those who did not attempt the test. Institutions are advised not to consider a report older than two years to be valid unless the user proves that they have worked to maintain their level.</p>\r\n\r\n<p>In <strong>2016,</strong> 3 million tests were taken in more than <strong>140</strong> countries, up from 2 million tests in 2012, 1.7 million tests in 2011, and 1.4 million tests in 2009. In 2007, IELTS administered more than one million tests in a single<strong> 12-month</strong> period for the first time ever, making it the world&rsquo;s most popular English language test for higher education and immigration.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"aos-animate aos-init course__list__wraper\">&nbsp;</div>','','','','','',2,1,'2024-05-20 06:30:09','2024-05-20 09:41:57','','','','',1,1),(13,'To Apply','to-apply',11,'<div class=\"aos-animate aos-init course__details__tab__wrapper\">\r\n<div class=\"tab-content tab__content__wrapper\" id=\"myTabContent\">\r\n<div class=\"active fade show tab-pane\" id=\"projects__one\">\r\n<div class=\"experence__heading\">\r\n<p>Anyone who is planning to study, work, or immigrate to an English-speaking country may start or apply for IELTS (International English Language Testing System) or PTE (Pearson Test of English) classes. These exams assess English language proficiency and are widely recognized by universities, employers, and immigration authorities globally. Here&#39;s a breakdown of who can benefit from IELTS and PTE classes:</p>\r\n\r\n<ol>\r\n	<li>\r\n	<p><strong>Students:</strong> Students who are applying to universities or colleges in English-speaking countries often need to demonstrate their English language proficiency through exams like IELTS or PTE. Taking classes specifically tailored for these exams can help students prepare effectively and achieve their desired scores.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Professionals:</strong> Professionals who are planning to work in an English-speaking environment or seek professional certification often need to demonstrate their English language skills through exams like IELTS or PTE. Classes can help professionals improve their language skills and perform well in these exams.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Immigrants:</strong> Individuals who are planning to immigrate to an English-speaking country may be required to take English language proficiency exams as part of their visa application process. IELTS and PTE classes can help immigrants prepare for these exams and meet the language requirements for immigration.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>General English Learners:</strong> Even individuals who simply want to improve their English language skills for personal or professional development can benefit from IELTS or PTE classes. These classes focus on various aspects of English, such as speaking, listening, reading, and writing, and can help learners enhance their overall language proficiency.</p>\r\n	</li>\r\n</ol>\r\n</div>\r\n</div>\r\n</div>\r\n</div>','','','','','',3,1,'2024-05-20 06:30:44','2024-06-06 07:12:39','','','','',1,1),(14,'Class time','class-time',11,'<div class=\"aos-animate aos-init course__details__tab__wrapper\">\r\n<div class=\"tab-content tab__content__wrapper\" id=\"myTabContent\">\r\n<div class=\"active fade show tab-pane\" id=\"projects__three\">\r\n<div class=\"experence__heading\">\r\n<h5>Class Time</h5>\r\n</div>\r\n\r\n<div class=\"experence__description\">\r\n<p>Classes at Ved International : Six weeks of regular classes</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"aos-animate aos-init course__list__wraper\">&nbsp;</div>','','','','','',4,1,'2024-05-20 06:31:10','2024-05-20 09:41:01','','','','',1,1),(15,'Mock Test','mock-test',11,'<div class=\"aos-animate aos-init course__details__tab__wrapper\">\r\n<div class=\"tab-content tab__content__wrapper\" id=\"myTabContent\">\r\n<div class=\"active fade show tab-pane\" id=\"projects__four\">\r\n<div class=\"experence__heading\">\r\n<h5>Mock Test</h5>\r\n</div>\r\n\r\n<div class=\"experence__description\">\r\n<p>Every (Sunday and Wednesday )<br />\r\nTime : 12 PM - 3 PM.</p>\r\n\r\n<p>&nbsp;</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"aos-animate aos-init course__list__wraper\">&nbsp;</div>','','','','','',5,1,'2024-05-20 06:31:41','2024-06-06 07:13:47','','','','',1,1),(16,'Why IELTS Is Important ?','why-ielts-is-important',0,'','','','','','',6,-1,'2024-05-20 09:35:32','2024-05-21 09:52:35','','','','',1,1),(17,'','',16,'','Lorem Ipsum is simply dummying text of the printing andtypesetting industry most of the standard.','','','','',7,-1,'2024-05-20 09:35:56','2024-05-21 09:52:39','','','','',1,1),(18,'','',16,'','Lorem Ipsum is simply dummying text of the printing andtypesetting industry most of the standard.','','','','',8,-1,'2024-05-20 09:36:07','2024-05-21 09:52:43','','','','',1,1),(19,'','',16,'','Lorem Ipsum is simply dummying text of the printing andtypesetting industry most of the standard.','','','','',9,-1,'2024-05-20 09:36:18','2024-05-21 09:52:48','','','','',1,1),(20,'PTE','pte',0,'<p>The International English Language Testing System (PTE) is an English language competence test that is needed in many countries for education, job, and immigration. It is intended to measure the language competence of non-native English speakers who need to study or work in an English-speaking setting. The test is broken into four sections: hearing, reading, writing, and speaking, and it is graded on a scale of 1 (non-user) to 9 (expert) (expert user). The PTE exam is widely recognised by colleges, businesses, and immigration agencies in nations such as the United States, the United Kingdom, Australia, and Canada.</p>\r\n\r\n<p>&nbsp;</p>','What is PTE?','storage/ved/files/1/Preparation/pte.png','storage/ved/files/1/Preparation/usa1.png','','',10,1,'2024-05-20 09:43:28','2024-05-23 04:47:08','','','','',1,1),(21,'Why PTE Is Important ?','why-pte-is-important',0,'','','','','','',11,-1,'2024-05-20 22:49:43','2024-05-21 09:52:54','','','','',1,1),(22,'','',21,'','Lorem Ipsum is simply dummying text of the printing andtypesetting industry most of the standard.','','','','',12,-1,'2024-05-20 22:50:44','2024-05-21 09:53:04','','','','',1,1),(23,'','',21,'','Lorem Ipsum is simply dummying text of the printing andtypesetting industry most of the standard.','','','','',13,-1,'2024-05-20 22:50:50','2024-05-21 09:53:14','','','','',1,1),(24,'Language Classes','language-classes',0,'','','storage/ved/files/1/Preparation/languageclass.png','','','',14,1,'2024-05-21 01:12:31','2024-05-24 00:25:20','','','','',1,1),(25,'Japanese','japanese',24,'<div class=\"active fade show tab-pane\" id=\"projects__one\">\r\n<div class=\"col-xl-12\">\r\n<div class=\"aboutarea__content__tap__wraper\">\r\n<p>At Ved International Education Consultancy, we offer Japanese language classes to cater to the growing interest and demand for learning Japanese. Whether you are a student, professional, or simply interested in exploring a new language and culture, our Japanese language classes provide an immersive and interactive learning experience. Here&#39;s what you can expect from our Japanese language program at Ved:</p>\r\n\r\n<ol>\r\n	<li>\r\n	<p><strong>Qualified Instructors:</strong> Our Japanese language classes are led by experienced and certified instructors who are native or fluent speakers of Japanese. They use effective teaching methods to help students grasp the language&#39;s nuances, pronunciation, grammar, and vocabulary.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Structured Curriculum:</strong> Our Japanese language curriculum is designed to cater to learners of all levels, from beginners to advanced speakers. We offer courses that cover essential language skills such as speaking, listening, reading, and writing, as well as cultural aspects of Japan.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Interactive Learning:</strong> We believe in active learning and provide interactive sessions, group activities, role-playing exercises, and multimedia resources to engage students and enhance their learning experience.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Flexible Schedule:</strong> Our Japanese language classes are offered in flexible schedules to accommodate students&#39; diverse needs. Whether you prefer weekday or weekend classes, morning or evening sessions, we have options to suit your schedule.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Small Class Sizes:</strong> We keep our class sizes small to ensure personalized attention and ample opportunities for students to practice speaking and listening skills in a supportive environment.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Cultural Immersion:</strong> In addition to language proficiency, our Japanese language classes provide insights into Japanese culture, traditions, etiquette, and customs. This cultural immersion enhances students&#39; understanding and appreciation of Japan beyond language learning.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Exam Preparation:</strong> For students planning to take Japanese language proficiency exams such as the JLPT (Japanese Language Proficiency Test), we offer specialized exam preparation courses to help them succeed in their language goals.</p>\r\n	</li>\r\n</ol>\r\n\r\n<p>Whether you are learning Japanese for academic, professional, travel, or personal reasons, our Japanese language classes at Ved International Education Consultancy offer a comprehensive and enriching learning experience. Join us to embark on a journey of language discovery and cultural exploration.</p>\r\n</div>\r\n</div>\r\n</div>','','','','','',15,1,'2024-05-21 01:13:19','2024-06-06 07:46:51','','','','',1,1),(26,'Korean','korean',24,'<div class=\"active fade show tab-pane\" id=\"projects__one\">\r\n<div class=\"col-xl-12\">\r\n<div class=\"aboutarea__content__tap__wraper\">\r\n<p>At Ved International Education Consultancy, we offer Korean language classes to cater to the growing demand and interest in learning Korean. Whether you are a student, professional, or language enthusiast, our Korean language classes are designed to help you achieve fluency and proficiency in Korean communication.</p>\r\n\r\n<p>Our Korean language classes are suitable for:</p>\r\n\r\n<ol>\r\n	<li>\r\n	<p><strong>Students:</strong> Students who are interested in Korean language and culture, or are planning to study in South Korea, can benefit from our Korean language classes. We provide a structured curriculum that covers grammar, vocabulary, speaking, listening, reading, and writing skills.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Professionals:</strong> Professionals who work with Korean companies, plan to pursue career opportunities in South Korea, or simply want to enhance their language skills for business purposes can join our Korean language classes. We focus on business communication, etiquette, and terminology relevant to various industries.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Travel Enthusiasts:</strong> If you are planning to visit South Korea for tourism or travel, learning Korean can enrich your experience and help you communicate effectively with locals. Our Korean language classes cover essential phrases, cultural insights, and practical language skills for travelers.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Language Enthusiasts:</strong> For individuals passionate about learning new languages and exploring different cultures, our Korean language classes offer an immersive and engaging learning experience. Our certified instructors create interactive lessons and provide personalized guidance to help you progress in your Korean language journey.</p>\r\n	</li>\r\n</ol>\r\n\r\n<p>Our Korean language classes include:</p>\r\n\r\n<ul>\r\n	<li>Beginner, intermediate, and advanced levels to accommodate learners of all proficiency levels.</li>\r\n	<li>Interactive lessons with a focus on speaking, listening, reading, and writing skills.</li>\r\n	<li>Cultural insights, language etiquette, and real-life scenarios to enhance cultural understanding.</li>\r\n	<li>Small class sizes for personalized attention and effective learning.</li>\r\n	<li>Experienced and certified instructors with expertise in teaching Korean language and culture.</li>\r\n</ul>\r\n\r\n<p>Join us at Ved International Education Consultancy and embark on a rewarding journey of learning Korean language and culture. Whether your goal is academic, professional, or personal enrichment, our Korean language classes provide a valuable opportunity to expand your language skills and cultural knowledge.</p>\r\n</div>\r\n</div>\r\n</div>','','','','','',16,1,'2024-05-21 01:13:39','2024-06-06 07:47:25','','','','',1,1),(27,'Spanish','spanish',24,'<div class=\"active fade show tab-pane\" id=\"projects__one\">\r\n<div class=\"col-xl-12\">\r\n<div class=\"aboutarea__content__tap__wraper\">\r\n<p>VED International Education Consultancy offers Spanish language classes to cater to the growing demand for language proficiency in Spanish-speaking countries and industries. Our Spanish language courses are designed for individuals who wish to learn Spanish for personal, academic, or professional reasons. Here are key features of our Spanish language classes:</p>\r\n\r\n<ol>\r\n	<li>\r\n	<p><strong>Qualified Instructors:</strong> Our Spanish language instructors are native speakers or proficient speakers with extensive experience in teaching Spanish as a foreign language. They provide expert guidance, personalized instruction, and interactive learning experiences to help students grasp the language effectively.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Comprehensive Curriculum:</strong> Our Spanish language curriculum covers all aspects of language learning, including vocabulary, grammar, pronunciation, reading comprehension, writing skills, and conversational practice. The curriculum is designed to cater to different proficiency levels, from beginners to advanced learners.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Flexible Learning Options:</strong> We offer flexible learning options to accommodate students&#39; schedules and preferences. Students can choose from group classes, private tutoring sessions, intensive courses, or customized programs based on their learning goals and availability.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Interactive Learning Environment:</strong> Our Spanish language classes provide an interactive and engaging learning environment with multimedia resources, audiovisual materials, interactive exercises, and real-life simulations. This immersive approach helps students develop practical language skills and cultural awareness.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Progress Monitoring:</strong> We regularly assess students&#39; progress through quizzes, tests, assignments, and interactive activities. Feedback from instructors helps students identify areas for improvement and track their language learning journey effectively.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Cultural Enrichment:</strong> In addition to language instruction, our Spanish language classes incorporate cultural elements, such as traditions, customs, history, and cultural nuances of Spanish-speaking countries. This cultural enrichment enhances students&#39; understanding and appreciation of the Spanish language and culture.</p>\r\n	</li>\r\n</ol>\r\n\r\n<p>Whether you are a beginner looking to learn basic Spanish phrases or an advanced learner aiming for fluency, our Spanish language classes at VED International Education Consultancy provide a structured and supportive learning environment to help you achieve your language learning goals. Join us and embark on a rewarding journey of language proficiency and cultural exploration.</p>\r\n</div>\r\n</div>\r\n</div>','','','','','',17,1,'2024-05-21 01:13:50','2024-06-06 07:48:03','','','','',1,1),(28,'Other','other',24,'<div class=\"active fade show tab-pane\" id=\"projects__one\">\r\n<div class=\"col-xl-12\">\r\n<div class=\"aboutarea__content__tap__wraper\">\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn&#39;t anything embarrassing hidden in the middle of text. Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from characteristic words etc.</p>\r\n\r\n<div class=\"aboutarea__tap__heading\">\r\n<h5>World best education site - (Computer engeenering)</h5>\r\n\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which dont look even slightly believable. If you are going to useery</p>\r\n</div>\r\n\r\n<div class=\"aboutarea__tap__heading\">\r\n<h5>Web and user interface design - Development</h5>\r\n\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which dont look even slightly believable. If you are going to useery</p>\r\n</div>\r\n\r\n<div class=\"aboutarea__tap__heading\">\r\n<h5>Interaction design - Animation</h5>\r\n\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which dont look even slightly believable. If you are going to useery</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>','','','','','',18,-1,'2024-05-21 01:13:59','2024-06-06 07:48:17','','','','',1,1),(29,'TOEFL','toefl',0,'<p>The TOEFL (Test of English as a Foreign Language) is a widely recognized English language proficiency test that assesses the reading, listening, speaking, and writing skills of non-native English speakers. It is accepted by thousands of universities, colleges, and organizations worldwide as proof of English language proficiency for academic and professional purposes.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>','What is TOEFL?','storage/ved/files/1/Preparation/ielts.png','storage/ved/files/1/StudyDestaination/Small Images/uk1.png','','',19,1,'2024-05-24 00:19:28','2024-06-06 07:43:01','','','','',1,1),(30,'GRE','gre-gmat',0,'<p>The Graduate Record Examination (GRE) is a standardized test widely used for admissions to graduate and business schools worldwide. The GRE assesses verbal reasoning, quantitative reasoning, analytical writing, and critical thinking skills that are essential for success in graduate-level academic programs. The test is computer-based and administered by Educational Testing Service (ETS) and is accepted by thousands of graduate and business schools globally.</p>','','storage/ved/files/1/Preparation/ielts.png','storage/ved/files/1/StudyDestaination/Small Images/uk1.png','','',20,1,'2024-05-24 00:20:19','2024-06-06 07:38:17','','','','',1,1),(31,'TOEFL','toefl',0,'','Why TOEFL?','storage/ved/files/1/Preparation/pte.png','storage/ved/files/1/StudyDestaination/Small Images/usa1.png','','',21,1,'2024-05-24 00:27:04','2024-05-24 00:27:04','','','','',1,1),(32,'About PTE','about-pte',20,'<p>PTE (Pearson Test of English) is an internationally recognized English language proficiency test designed to assess the reading, writing, listening, and speaking skills of non-native English speakers. The test is accepted by universities, colleges, and governments around the world as proof of English language proficiency for academic, immigration, and professional purposes.</p>\r\n\r\n<p>The PTE exam is computer-based and utilizes advanced technology to ensure accuracy, fairness, and security in the assessment process. It consists of various question types, including multiple-choice, essay writing, summarizing spoken texts, and describing images. Test takers are evaluated on their ability to understand and use English in real-life situations, making it a comprehensive measure of language proficiency.</p>\r\n\r\n<p>One of the key advantages of the PTE exam is its fast turnaround time for results, typically providing scores within five business days. This makes it a preferred choice for individuals who require timely assessment of their English language skills for academic admissions, visa applications, or employment opportunities.</p>','','','','','',22,1,'2024-06-06 07:31:58','2024-06-06 07:32:08','','','','',1,1),(33,'To Apply','to-apply',20,'<p>Anyone who wants to improve their English language skills and prepare for the PTE (Pearson Test of English) exam can start or apply for PTE classes. Here are some specific groups of people who may benefit from PTE classes:</p>\r\n\r\n<ol>\r\n	<li>\r\n	<p><strong>Students:</strong> Students who are planning to study at universities or colleges in English-speaking countries and need to demonstrate their English proficiency for admissions can benefit from PTE classes. These classes help students prepare for the exam and achieve the required scores for their desired courses.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Professionals:</strong> Professionals who are seeking employment opportunities in English-speaking environments or need to demonstrate their English proficiency for career advancement can start PTE classes. These classes focus on business English and communication skills relevant to the workplace.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Immigrants:</strong> Individuals who are planning to immigrate to English-speaking countries and need to prove their English language proficiency as part of their visa application process can benefit from PTE classes. These classes prepare immigrants for the language requirements of immigration authorities.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>General English Learners:</strong> Even individuals who simply want to improve their overall English language skills, including reading, writing, listening, and speaking, can start PTE classes. These classes provide structured learning and practice to enhance language proficiency.</p>\r\n	</li>\r\n</ol>\r\n\r\n<p>PTE classes are designed to cater to the needs of a diverse range of learners, from beginners to advanced speakers, and offer a comprehensive curriculum that covers all aspects of the PTE exam. The classes are typically led by experienced instructors who provide guidance, practice materials, and feedback to help students achieve their language goals and succeed in the PTE exam.</p>','','','','','',23,1,'2024-06-06 07:33:04','2024-06-06 07:33:04','','','','',1,1),(34,'Description','description',30,'<p>The GRE consists of three main sections:</p>\r\n\r\n<ol>\r\n	<li><strong>Verbal Reasoning: </strong>This section assesses your ability to analyze and evaluate written material, comprehend and draw conclusions from it, and recognize relationships between words and concepts.</li>\r\n	<li><strong>Quantitative Reasoning:</strong> This section measures your ability to solve mathematical problems, interpret and analyze quantitative data, and apply mathematical concepts to real-world scenarios.</li>\r\n	<li><strong>Analytical Writing: </strong>This section evaluates your ability to articulate and support complex ideas effectively, analyze arguments, and present logical and coherent written arguments.</li>\r\n</ol>\r\n\r\n<p>Preparing for the GRE involves studying a wide range of topics, practicing sample questions, and developing test-taking strategies. Many test preparation resources, such as study guides, practice tests, and online courses, are available to help students achieve their target scores on the GRE.</p>\r\n\r\n<p>Achieving a competitive score on the GRE can enhance your chances of admission to top graduate and business schools, as it demonstrates your readiness for advanced academic coursework and your ability to excel in a rigorous academic environment. Many schools also consider GRE scores when awarding scholarships and assistantships, making it an important factor in the graduate school application process.</p>','','','','','',24,1,'2024-06-06 07:38:47','2024-06-06 07:38:47','','','','',1,1),(35,'To Apply','to-apply',30,'<p>The GRE (Graduate Record Examination) is primarily taken by individuals who are planning to pursue graduate or business school programs. Here are the main groups of people who typically apply for or study for the GRE:</p>\r\n\r\n<ol>\r\n	<li>\r\n	<p><strong>Undergraduate Students:</strong> College students who are approaching the end of their undergraduate studies and plan to apply for graduate programs such as master&#39;s or doctoral degrees often study for the GRE. It&#39;s common for students in fields like engineering, science, humanities, social sciences, and business to take the GRE as part of their application process.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Graduate School Applicants:</strong> Individuals who have already completed their undergraduate studies and are applying for admission to graduate programs, including master&#39;s, doctoral, and MBA programs, study for the GRE. This includes both domestic and international students seeking admission to universities and colleges worldwide.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Working Professionals:</strong> Professionals who have been working in their respective fields and now wish to pursue advanced degrees or certifications, such as an MBA, a master&#39;s in a specialized field, or a doctoral degree, may study for the GRE to meet admission requirements.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Career Changers:</strong> Individuals who are considering a career change and want to transition into a new field that requires an advanced degree often apply for graduate programs and study for the GRE as part of their career development strategy.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Scholarship Seekers:</strong> Some scholarships and fellowships for graduate programs require GRE scores as part of the application process. Therefore, individuals seeking financial aid for their graduate studies may study for and take the GRE.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>International Students:</strong> International students planning to study abroad in countries like the United States, Canada, Australia, or Europe may need to take the GRE as part of their application for graduate programs at universities in these countries.</p>\r\n	</li>\r\n</ol>','','','','','',25,1,'2024-06-06 07:39:35','2024-06-06 07:39:35','','','','',1,1),(36,'Mock Test','mock-test',30,'<p>At Ved International Education Consultancy, students can access mock GRE tests as part of their test preparation services. These mock tests typically cover all sections of the GRE, including verbal reasoning, quantitative reasoning, and analytical writing. They are timed to mimic the real exam conditions and provide students with a realistic assessment of their performance.</p>\r\n\r\n<p>The benefits of taking mock tests for the GRE at Ved International Education Consultancy or any other reputable institution include:</p>\r\n\r\n<ol>\r\n	<li>\r\n	<p><strong>Assessment of Readiness:</strong> Mock tests help students gauge their preparedness for the actual GRE exam by simulating the test format, difficulty level, and time constraints.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Identifying Strengths and Weaknesses:</strong> Mock tests highlight areas where students excel and areas where they may need to focus more attention and practice.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Time Management Practice:</strong> Since the GRE is a timed exam, mock tests help students practice managing their time effectively to complete each section within the allotted time.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Familiarization with Exam Interface:</strong> Mock tests familiarize students with the computer-based GRE exam interface, question formats, and navigation tools, reducing anxiety and enhancing confidence on test day.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Feedback and Performance Analysis:</strong> After completing a mock test, students receive feedback on their performance, including scores, correct and incorrect answers, and explanations for answers. This feedback helps students understand their strengths and areas for improvement.</p>\r\n	</li>\r\n</ol>','','','','','',26,1,'2024-06-06 07:41:04','2024-06-06 07:41:11','','','','',1,1),(37,'Description','description',29,'<p>The TOEFL exam is computer-based and is designed to accurately measure an individual&#39;s ability to understand and use English in academic settings. It includes various question types, such as multiple-choice, short-answer, and essay writing, to evaluate different aspects of language proficiency.</p>\r\n\r\n<p>One of the key benefits of the TOEFL exam is its global recognition and acceptance, making it a preferred choice for students and professionals aiming to study or work in English-speaking countries. Additionally, the TOEFL exam provides unbiased and standardized scoring, ensuring fairness and reliability in assessing language skills.</p>\r\n\r\n<p>TOEFL preparation classes are available to help test takers improve their English language abilities and familiarize themselves with the format and content of the exam. These classes focus on developing reading, listening, speaking, and writing skills through interactive lessons, practice tests, and feedback from experienced instructors.</p>','','','','','',27,1,'2024-06-06 07:43:30','2024-06-06 07:43:30','','','','',1,1),(38,'To Apply','to-apply',31,'<p>Individuals who wish to demonstrate their English language proficiency for academic, professional, or immigration purposes can apply to study for the TOEFL (Test of English as a Foreign Language) exam. Here are specific groups of people who may benefit from studying for the TOEFL exam:</p>\r\n\r\n<ol>\r\n	<li>\r\n	<p><strong>Students Applying to Universities:</strong> TOEFL is widely accepted by universities and colleges in English-speaking countries as proof of English proficiency for admissions. Students who are planning to pursue undergraduate or graduate studies abroad can benefit from studying for the TOEFL exam to meet the language requirements of their desired institutions.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Professionals Seeking Career Opportunities:</strong> Professionals who want to enhance their English language skills for career advancement or job opportunities in English-speaking environments can study for the TOEFL exam. Many employers and industries require English proficiency, and a high TOEFL score can demonstrate language competency to potential employers.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Immigrants Applying for Visas:</strong> Individuals who are applying for visas or immigration to English-speaking countries often need to demonstrate English proficiency as part of their visa application process. Studying for the TOEFL exam can help immigrants meet the language requirements set by immigration authorities and facilitate their visa applications.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>General English Learners:</strong> Even individuals who want to improve their overall English language skills, including reading, writing, listening, and speaking, can study for the TOEFL exam. TOEFL preparation courses offer structured learning and practice materials to help learners enhance their language proficiency.</p>\r\n	</li>\r\n</ol>','','','','','',28,1,'2024-06-06 07:44:14','2024-06-06 07:44:14','','','','',1,1);

--
-- Table structure for table `tbl_preparationclasses_cf`
--

CREATE TABLE `tbl_preparationclasses_cf` (
  `preparationclass_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `parent_preparationclass` int(11) DEFAULT 0,
  `details` text DEFAULT NULL,
  `intro` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `display_order` int(11) DEFAULT 0,
  `status` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`preparationclass_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_preparationclasses_cf`
--


--
-- Table structure for table `tbl_preparationclassoffers`
--

CREATE TABLE `tbl_preparationclassoffers` (
  `preparationclassoffer_id` int(11) NOT NULL AUTO_INCREMENT,
  `preparationclasses_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `classtime` time DEFAULT NULL,
  `details` text DEFAULT NULL,
  `intro` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `seo_keywords` text DEFAULT NULL,
  `seo_title` text DEFAULT NULL,
  `seo_descriptions` text DEFAULT NULL,
  `og_tags` text DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`preparationclassoffer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_preparationclassoffers`
--


--
-- Table structure for table `tbl_preparationclasstestimonials`
--

CREATE TABLE `tbl_preparationclasstestimonials` (
  `testimonial_id` int(11) NOT NULL AUTO_INCREMENT,
  `preparationclasses_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `student` varchar(255) DEFAULT NULL,
  `rating` varchar(255) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`testimonial_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_preparationclasstestimonials`
--


--
-- Table structure for table `tbl_products`
--

CREATE TABLE `tbl_products` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `price` tinyint(4) DEFAULT 0,
  `discountrate` tinyint(4) DEFAULT 0,
  `netprice` tinyint(4) DEFAULT 0,
  `description` varchar(250) DEFAULT NULL,
  `categories_id` int(11) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_products`
--


--
-- Table structure for table `tbl_programlevels`
--

CREATE TABLE `tbl_programlevels` (
  `programlevel_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`programlevel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_programlevels`
--


--
-- Table structure for table `tbl_programs`
--

CREATE TABLE `tbl_programs` (
  `program_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `countries_id` int(11) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `required_documents` text DEFAULT NULL,
  `qualification` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `seo_keywords` text DEFAULT NULL,
  `seo_title` text DEFAULT NULL,
  `seo_descriptions` text DEFAULT NULL,
  `og_tags` text DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`program_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_programs`
--


--
-- Table structure for table `tbl_programs_cf`
--

CREATE TABLE `tbl_programs_cf` (
  `program_id` int(11) NOT NULL AUTO_INCREMENT,
  `institutions_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `programlevels_id` int(11) DEFAULT NULL,
  `program_level` varchar(255) DEFAULT NULL,
  `years` varchar(255) DEFAULT NULL,
  `psw` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `coops_id` int(11) DEFAULT NULL,
  `documentsets_id` int(11) DEFAULT NULL,
  `program_url` text DEFAULT NULL,
  `prospects` text DEFAULT NULL,
  `intake` varchar(255) DEFAULT NULL,
  `institution` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `application_open` varchar(255) DEFAULT NULL,
  `application_deadline` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `level` varchar(255) DEFAULT NULL,
  `min_level` varchar(255) DEFAULT NULL,
  `min_level_faculty` varchar(255) DEFAULT NULL,
  `min_level_score` varchar(255) DEFAULT NULL,
  `min_level_passout` varchar(255) DEFAULT NULL,
  `min_level_optional_requirement` varchar(255) DEFAULT NULL,
  `prof_test_required` int(11) DEFAULT NULL,
  `prof_test_accepted` varchar(255) DEFAULT NULL,
  `prof_test_min_score` varchar(255) DEFAULT NULL,
  `prof_test_band_score` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `createdby` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT current_timestamp(),
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`program_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_programs_cf`
--


--
-- Table structure for table `tbl_quicklinks`
--

CREATE TABLE `tbl_quicklinks` (
  `quicklink_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `alias` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `link` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`quicklink_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_quicklinks`
--


--
-- Table structure for table `tbl_requireddocuments`
--

CREATE TABLE `tbl_requireddocuments` (
  `requireddocument_id` int(11) NOT NULL AUTO_INCREMENT,
  `documentsets_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`requireddocument_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_requireddocuments`
--


--
-- Table structure for table `tbl_resourcearticles`
--

CREATE TABLE `tbl_resourcearticles` (
  `institutionarticle_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_article` int(11) DEFAULT 0,
  `title` varchar(250) DEFAULT NULL,
  `subtitle` text DEFAULT NULL,
  `alias` varchar(250) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `cover_photo` varchar(500) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `seo_keywords` text DEFAULT NULL,
  `seo_title` text DEFAULT NULL,
  `seo_descriptions` text DEFAULT NULL,
  `og_tags` text DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`institutionarticle_id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `tbl_resourcearticles`
--

INSERT INTO `tbl_resourcearticles` VALUES (1,0,'Gallery','','gallery','','','',1,-1,'2024-05-20 23:18:41','2024-05-28 23:26:42','','','','',1,1),(31,4,'Second Image','','second-image','','storage/ved/files/1/Preparation/australia.jpeg','',31,-1,'2024-05-28 23:10:16','2024-05-28 23:26:56','','','','',1,1),(30,4,'First Image','','first-image','','storage/ved/files/1/miltestone/award-1.jpg','',30,-1,'2024-05-28 23:09:47','2024-05-28 23:26:51','','','','',1,1),(4,1,'Point Park University spot admission','','point-park-university-spot-admission','','storage/ved/files/1/Gallery/3.jpg','',4,-1,'2024-05-20 23:20:50','2024-05-28 23:26:46','','','','',1,1),(5,0,'Sample Documents','','sample-documents','','','',5,1,'2024-05-20 23:32:23','2024-05-20 23:32:23','','','','',1,1),(6,5,'document','','document','','storage/ved/files/1/Gallery/6.jpg','storage/ved/files/1/DocumentSamplePDF/sample-compressed.pdf',6,1,'2024-05-20 23:32:43','2024-05-20 23:52:23','','','','',1,1),(7,5,'document','','document','','storage/ved/files/1/Gallery/4.jpg','storage/ved/files/1/DocumentSamplePDF/sample-compressed.pdf',7,1,'2024-05-20 23:33:01','2024-05-28 23:57:28','','','','',1,1),(8,0,'Preparation Guide','','preparation-guide','','','',8,1,'2024-05-20 23:34:54','2024-05-20 23:34:54','','','','',1,1),(9,8,'document','','document','','storage/ved/files/1/Gallery/5.jpg','storage/ved/files/1/DocumentSamplePDF/sample-compressed.pdf',9,1,'2024-05-20 23:35:08','2024-05-20 23:59:26','','','','',1,1),(10,8,'document','','document','','storage/ved/files/1/Gallery/5.jpg','storage/ved/files/1/DocumentSamplePDF/sample-compressed.pdf',10,1,'2024-05-20 23:35:25','2024-05-20 23:59:39','','','','',1,1),(11,0,'FAQs','','faqs','','','',11,-1,'2024-05-21 00:50:09','2024-05-22 01:58:51','','','','',1,1),(12,11,'Can i cancel my account at any time?','','can-i-cancel-my-account-at-any-time','<p>Engineers should help solve the hardest questions, the unknowns, where being familiar with how the product was built is essential. But we don&rsquo;t want to keep answering solved problems over and over again. That&rsquo;s where Stack Overflow for Teams really helps.</p>','','',12,-1,'2024-05-21 00:51:00','2024-05-22 01:59:10','','','','',1,1),(13,11,'Who am i?','','who-am-i','<p>Engineers should help solve the hardest questions, the unknowns, where being familiar with how the product was built is essential. But we don&rsquo;t want to keep answering solved problems over and over again. That&rsquo;s where Stack Overflow for Teams really helps.</p>','','',13,-1,'2024-05-21 00:51:51','2024-05-22 01:59:17','','','','',1,1),(14,0,'Institutions Prospectors','','institutions-prospectors','<p>At VED International Education Consultancy, we recognize the importance of building strong relationships with educational institutions around the globe. Our team of Institutions Prospectors is dedicated to identifying and establishing partnerships with prestigious universities, colleges, and language schools that align with our mission of providing students with high-quality education opportunities. By leveraging our extensive network and market research capabilities, we ensure that our students have access to a diverse range of programs and institutions that meet their academic and professional aspirations.</p>\r\n\r\n<p>Our Institutions Prospectors work diligently to stay informed about the latest developments in the education sector, enabling us to connect with institutions that offer innovative programs and cutting-edge facilities. This proactive approach allows us to provide our students with up-to-date information about admission requirements, scholarship opportunities, and unique course offerings. Through these strategic partnerships, VED is able to enhance the overall student experience, ensuring that our clients receive the best possible guidance and support as they embark on their educational journeys abroad.</p>','','',14,1,'2024-05-21 01:43:43','2024-06-06 09:17:40','','','','',1,1),(15,14,'Brochures of VED Education','','brochures-of-ved-education','<p>Discover endless opportunities with VED International Education Consultancy! Since 2010, VED has been dedicated to guiding students towards their dreams of studying abroad in world-renowned institutions. Our expert team offers personalized counseling, test preparation classes (IELTS, SAT, TOEFL, GRE, GMAT, PTE, CAE), and seamless visa assistance, ensuring a smooth journey to your desired destination. With a commitment to excellence and a family-like atmosphere, we provide reliable information, scholarship opportunities, and support every step of the way. Join VED and embark on a transformative educational adventure today! Visit our website for more details and student testimonials.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>','storage/ved/files/1/Brochures/brochures-1.jpg','storage/ved/files/1/DocumentSamplePDF/sample-compressed.pdf',15,1,'2024-05-21 01:46:30','2024-06-06 09:24:50','','','','',1,1),(16,0,'Promotional Brochures','','promotional-brochures','','','',16,1,'2024-05-21 01:47:07','2024-05-21 01:47:07','','','','',1,1),(17,16,'Promotional Brochures','','promotional-brochures','<p>Discover endless opportunities with VED International Education Consultancy! Since 2010, VED has been dedicated to guiding students towards their dreams of studying abroad in world-renowned institutions. Our expert team offers personalized counseling, test preparation classes (IELTS, SAT, TOEFL, GRE, GMAT, PTE, CAE), and seamless visa assistance, ensuring a smooth journey to your desired destination. With a commitment to excellence and a family-like atmosphere, we provide reliable information, scholarship opportunities, and support every step of the way. Join VED and embark on a transformative educational adventure today! Visit our website for more details and student testimonials.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>','storage/ved/files/1/Brochures/brochures-1.jpg','storage/ved/files/1/DocumentSamplePDF/sample-compressed.pdf',17,1,'2024-05-21 01:48:57','2024-06-06 09:19:49','','','','',1,1),(18,0,'Application Flow Chart','','application-flow-chart','<p>This flowchart outlines the step-by-step process VED International Education Consultancy follows to ensure a smooth and successful application journey for students aspiring to study abroad. From the initial inquiry to ongoing support after arrival, VED provides comprehensive services to guide students through every stage of their educational journey.</p>','','',18,1,'2024-05-21 01:49:23','2024-06-06 09:21:44','','','','',1,1),(19,18,'Application Flowchart of VED Education','','application-flowchart-of-ved-education','<div class=\"aos-animate aos-init event__details__content\">\r\n<p>This flowchart outlines the step-by-step process VED International Education Consultancy follows to ensure a smooth and successful application journey for students aspiring to study abroad. From the initial inquiry to ongoing support after arrival, VED provides comprehensive services to guide students through every stage of their educational journey.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n</div>','storage/ved/files/1/Brochures/application.png','',19,1,'2024-05-21 01:50:37','2024-06-06 09:25:19','','','','',1,1),(20,0,'Privilege Card','','privilege-card','','','',20,1,'2024-05-21 03:41:31','2024-05-21 03:41:31','','','','',1,1),(21,20,'Privilege','','privilege','<p>At VED International Education Consultancy, we value our students and aim to provide them with additional benefits to enhance their study abroad experience. Our VED Privilege Cards offer exclusive advantages and discounts to our students, ensuring they receive the best support and services throughout their journey. Here&rsquo;s a detailed overview of our VED Privilege Cards:</p>\r\n\r\n<h4>1. <strong>Bronze Privilege Card</strong></h4>\r\n\r\n<ul>\r\n	<li><strong>Eligibility:</strong> Issued to students upon initial consultation.</li>\r\n	<li><strong>Benefits:</strong>\r\n	<ul>\r\n		<li><strong>Discount on Test Preparation Classes:</strong> Enjoy a 5% discount on all test preparation classes (IELTS, SAT, TOEFL, GRE, GMAT, PTE, CAE).</li>\r\n		<li><strong>Access to Exclusive Seminars:</strong> Invitations to special seminars and webinars conducted by VED experts and guest speakers.</li>\r\n		<li><strong>Counseling Sessions:</strong> One additional free counseling session with our certified advisors.</li>\r\n	</ul>\r\n	</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<h4>2. <strong>Silver Privilege Card</strong></h4>\r\n\r\n<ul>\r\n	<li><strong>Eligibility:</strong> Issued to students upon submission of university applications through VED.</li>\r\n	<li><strong>Benefits:</strong>\r\n	<ul>\r\n		<li><strong>Higher Discount on Test Preparation Classes:</strong> 10% discount on all test preparation classes.</li>\r\n		<li><strong>Priority Counseling:</strong> Priority access to counseling sessions and quick response times for queries.</li>\r\n		<li><strong>Accommodation Assistance:</strong> Assistance in finding and securing accommodation options.</li>\r\n		<li><strong>Access to Study Materials:</strong> Free access to premium study materials and resources.</li>\r\n	</ul>\r\n	</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<h4>3. <strong>Gold Privilege Card</strong></h4>\r\n\r\n<ul>\r\n	<li><strong>Eligibility:</strong> Issued to students who receive an offer of admission from a university.</li>\r\n	<li><strong>Benefits:</strong>\r\n	<ul>\r\n		<li><strong>Exclusive Discounts:</strong> 15% discount on test preparation classes and additional discounts on educational resources.</li>\r\n		<li><strong>Visa Application Support:</strong> Comprehensive support with visa applications, including document review and interview preparation.</li>\r\n		<li><strong>Networking Events:</strong> Invitations to exclusive networking events with alumni and industry professionals.</li>\r\n		<li><strong>Travel Assistance:</strong> Guidance on travel arrangements and discounts on selected travel agencies.</li>\r\n	</ul>\r\n	</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<h4>4. <strong>Platinum Privilege Card</strong></h4>\r\n\r\n<ul>\r\n	<li><strong>Eligibility:</strong> Issued to students who have secured a visa and are preparing for departure.</li>\r\n	<li><strong>Benefits:</strong>\r\n	<ul>\r\n		<li><strong>Maximum Discounts:</strong> 20% discount on test preparation classes and other VED services.</li>\r\n		<li><strong>Comprehensive Pre-Departure Orientation:</strong> Detailed pre-departure orientation sessions and materials.</li>\r\n		<li><strong>Post-Arrival Support:</strong> Ongoing support in the host country, including assistance with local resources and emergency contacts.</li>\r\n		<li><strong>Health Insurance Discounts:</strong> Discounts on OSHC and other health insurance plans.</li>\r\n	</ul>\r\n	</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<h3>How to Avail VED Privilege Cards</h3>\r\n\r\n<ol>\r\n	<li><strong>Registration:</strong> Start by registering with VED International Education Consultancy and scheduling your initial consultation.</li>\r\n	<li><strong>Progress through the Application Process:</strong> As you progress through each stage of the application process (from consultation to visa acquisition), you will automatically be upgraded to the next level of the privilege card.</li>\r\n	<li><strong>Enjoy Exclusive Benefits:</strong> Utilize the benefits associated with your current privilege card to enhance your study abroad experience.</li>\r\n</ol>\r\n\r\n<h3>&nbsp;</h3>','storage/ved/files/1/Sliders/gregmat.png','',21,1,'2024-05-21 03:42:52','2024-06-06 09:29:43','','','','',1,1),(22,0,'SOP','','sop','','','',22,1,'2024-05-21 04:05:16','2024-05-21 04:05:16','','','','',1,1),(23,22,'Statement Of Purpose','','statement-of-purpose','<p>The&nbsp;<strong>Statement of Purpose&nbsp;</strong>is the most important part of your application that will tell the admissions committee who you are in some detail, what you want to learn about in your applied courses, what has influenced your career path so far, your professional interests and where you plan to go from here. It is a long essay that includes a brief introduction, educational background, employment history, course details of the applied course, career goals, and many more things.</p>\r\n\r\n<p>The statement of purpose approximately consists of 1000 words. It is a declarative sentence that summarizes the specific topic and goals of a document. It is typically included in the introduction to give the reader an accurate, concrete understanding of what the document will cover and what admissions committee can gain from reading it. So the statement of purpose should be clear and genuine with proper checking of every grammar error, spelling, or any else mistakes. It plays a vital role in admission.</p>\r\n\r\n<p>Statement of Purpose must include the following information:</p>\r\n\r\n<ul>\r\n	<li>Your personal brief introduction or you can start with personal philosophy/motto if you like. It includes your name, address, your intent for the course, etc.</li>\r\n	<li>You should state your academic achievements or history and English proficiency with respective dates. Also the training, internship, employment history if applicable.</li>\r\n	<li>The reason to choose the particular education destination where students should have some comparative differences like health and safety, education system, duration to complete and cost analysis as well as definitely career opportunity with that country and also why not to study in Nepal or any other country.</li>\r\n	<li>The reason to choose a particular education provider compares to other institutions in terms of graduation and employability rate, student support, student/teacher ratio at the class, and any further good point like Academic requirement, tuition fees, IELTS requirement of institution ranking and also with about the chosen city.</li>\r\n	<li>The student must be clear about the course he/she is applying for and how that program fits with your future plans and career pathways. In-depth you can explain the course (units, compulsory subjects, elective/major/optional subject, and possible career opportunity.</li>\r\n	<li>The main point of the statement of purpose is to show your vision clearly to the admission committee so your career plan should be clear and specific. You can mention the potentiality to achieve the goals you have set for yourself the career opportunity, the competitive benefit you will get with the help of your applied course.</li>\r\n	<li>For the financial coverage of your studies, you should explain your family&rsquo;s financial capacity and circumstances of the sponsor.</li>\r\n	<li>The student should aware of the GTE requirement and immigration history, here student needs to explain whether they have applied earlier to any country, immigration history, previous travel history.</li>\r\n	<li>As final words, you can conclude the statement of purpose by requesting your admission to that particular institution with the course you have chosen.</li>\r\n</ul>','storage/ved/files/1/Sliders/slider2.jpg','',23,1,'2024-05-21 04:05:57','2024-06-06 09:41:59','','','','',1,1),(24,0,'Career','','career','','','',24,1,'2024-05-21 04:20:33','2024-05-21 04:20:33','','','','',1,1),(25,24,'Large Office','Enjoy a comfortable office environment with the most modern and stylish furnishing.','large-office','','','',25,1,'2024-05-21 04:21:28','2024-05-21 04:21:28','','','','',1,1),(26,24,'Easy Location','Commute easily to work at your convenience and enjoy compensation transport costs.','easy-location','','','',26,1,'2024-05-21 04:22:03','2024-05-21 04:22:03','','','','',1,1),(27,24,'Great Co-workers','Work with some of the best talent in the industry and build strong networks with them.','great-co-workers','','','',27,1,'2024-05-21 04:22:30','2024-05-21 04:22:30','','','','',1,1),(28,24,'Performance Award','Get awarded for better performance every 6 months and be recognized your work.','performance-award','','','',28,1,'2024-05-21 04:22:55','2024-05-21 04:22:55','','','','',1,1),(29,24,'','','','<div class=\"populerarea__content__2\">\r\n<p>At VEd Education we believe in working together and working hard. With over 800,0 happy clients, we are looking for dynamic and creative individuals who are willing to dedicate themselves to providing innovative products and services for our clients.</p>\r\n\r\n<p>Besides getting the opportunity to unlock your true potential, at EleHirely you can also network with some of the most talented people in the industry, go on annual picnics outside the country and enjoy many other benefits by working with us.</p>\r\n</div>','','',29,1,'2024-05-21 04:23:27','2024-05-21 04:23:27','','','','',1,1);

--
-- Table structure for table `tbl_resources`
--

CREATE TABLE `tbl_resources` (
  `resource_id` int(11) NOT NULL AUTO_INCREMENT,
  `resourcetypes_id` int(11) DEFAULT NULL,
  `parent_resource` int(11) DEFAULT 0,
  `title` varchar(250) DEFAULT NULL,
  `alias` varchar(250) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `link` varchar(500) DEFAULT NULL,
  `cover_photo` varchar(500) DEFAULT NULL,
  `thumb` varchar(250) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `seo_keywords` text DEFAULT NULL,
  `seo_title` text DEFAULT NULL,
  `seo_descriptions` text DEFAULT NULL,
  `og_tags` text DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`resource_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_resources`
--


--
-- Table structure for table `tbl_resourcetypes`
--

CREATE TABLE `tbl_resourcetypes` (
  `resourcetype_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_resourcetype` int(11) DEFAULT 0,
  `title` varchar(250) DEFAULT NULL,
  `alias` varchar(250) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `cover_photo` varchar(500) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`resourcetype_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_resourcetypes`
--


--
-- Table structure for table `tbl_services`
--

CREATE TABLE `tbl_services` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_service` int(11) DEFAULT 0,
  `title` varchar(250) DEFAULT NULL,
  `alias` varchar(250) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `link` varchar(500) DEFAULT NULL,
  `cover_photo` varchar(500) DEFAULT NULL,
  `image_thumb` varchar(500) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `seo_keywords` text DEFAULT NULL,
  `seo_title` text DEFAULT NULL,
  `seo_descriptions` text DEFAULT NULL,
  `og_tags` text DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`service_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_services`
--

INSERT INTO `tbl_services` VALUES (1,0,'Educational Counselling','educational-counselling','<p>It is important for one to choose and decide on a definite career path early in one&rsquo;s life. With a wide range of courses and university colleges. Seeking international students like YOU.We promise you to provide wonderful/ Best educational counselling. While selecting universities/colleges, it is important for the students to take the Standardized Test Application, Application Essay, Admission Requirements and many more.</p>\r\n\r\n<ul>\r\n	<li>Course selection</li>\r\n	<li>University selection</li>\r\n	<li>Standardised test (PTE/IELTS)</li>\r\n	<li>Scholarship Assistance</li>\r\n	<li>Admission Requirement</li>\r\n</ul>','','storage/dreamon/files/1/background/page-header-bg.jpg','storage/dreamon/files/1/choose/mortarboard_1940611.png',1,1,'2024-03-27 01:23:37','2024-03-28 23:04:45','','','','',1,1),(2,0,'Interview Preparation','interview-preparation','<p>Preparing for a visa interview can be tricky. Once everything is prepared, it is the final and most crucial step. With our professional members, we assist you with interview preparation. We prepare you for typical questions asked during the visa interview, such as the reason for your visa, your intended activities, the length of your stay, and your ties to your home country. You will receive instructions on how to prepare your responses to these inquiries, with a focus on being precise, succinct, and truthful.</p>\r\n\r\n<p>Other considerations are also necessary, and we will make sure to bring them up to you during your interview.&nbsp;</p>','','storage/dreamon/files/1/background/page-header-bg.jpg','storage/dreamon/files/1/choose/mortarboard_1940611.png',2,1,'2024-03-27 01:24:02','2024-03-28 23:07:34','','','','',1,1),(3,0,'University Selection','university-selection','<p>Broad term that can refer to various aspects of interconnectedness and communication on a global scale.</p>','','storage/dreamon/files/1/background/page-header-bg.jpg','storage/dreamon/files/1/choose/mortarboard_1940611.png',3,-1,'2024-03-27 01:25:14','2024-03-28 23:07:57','','','','',1,1),(4,0,'Visa Assistance','visa-assistance','<p>Obtaining a visa for study abroad can be a complicated process. We are here to help students with their visa applications by offering support and direction. We also assist students with researching the country&rsquo;s visa requirements so they can familiarise themselves with the process and give themselves plenty of time to complete all the required steps. It is important to make plans in advance because some countries have lengthy processing times.</p>\r\n\r\n<p>Our main objectives are to assist you with your financial paperwork, provide guidance regarding the payment of any application fees, and maintain a copy of your application and all supporting materials for your records. For the most accurate and recent information , keep us in mind for your visa applications.</p>','','storage/dreamon/files/1/background/page-header-bg.jpg','storage/dreamon/files/1/choose/mortarboard_1940611.png',4,1,'2024-03-27 01:25:44','2024-03-28 23:06:56','','','','',1,1),(5,0,'Collaborations to institutions','collaborations-to-institutions','<p>We offer a space for you to introduce yourself and foster strong professional relationships by sharing updates, progress, and ideas. We give you the opportunity to network with professionals at events in your field, which enables you to keep in touch with your collaborators in a timely and efficient manner.&nbsp;</p>','','storage/dreamon/files/1/background/page-header-bg.jpg','storage/dreamon/files/1/choose/mortarboard_1940611.png',5,1,'2024-03-27 01:26:12','2024-03-28 23:07:16','','','','',1,1),(6,0,'Registration for Entrance and English tests','registration-for-entrance-and-english-tests','<p>We conduct both IELTS and PTE classes and also help you with Standardized English Test booking.</p>\r\n\r\n<p><strong>IELTS:</strong></p>\r\n\r\n<p>It is a globally recognized Standardised English Test that assesses English Language Skill in the areas of Listening, Reading, writing and Speaking.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>\r\n\r\n<p><strong>PTE- academic</strong></p>\r\n\r\n<p>PTE Academic Exam is a computer-based English Language Test accepted by educational institutions around the world. PTE Academic measures your English speaking, listening, reading, and writing skills in a single, short test. It lasts for three hours and is divided into sections. The test will automatically continue after the section&rsquo;s assigned time has passed.</p>','','storage/dreamon/files/1/background/page-header-bg.jpg','storage/dreamon/files/1/choose/mortarboard_1940611.png',6,1,'2024-03-27 01:26:33','2024-03-28 23:05:42','','','','',1,1),(7,1,'Over the last 35 Years we made an impact that is strong & we have long way to go.','over-the-last-35-years-we-made-an-impact-that-is-strong-we-have-long-way-to-go','<p>These are the concepts that shape our distinctive culture &amp; differentiate us from others. They true the unique spirit of our Firm guide the behaviors that enable us to deliver the promises we make to our clients and our people.</p>','','storage/dreamon/files/1/background/page-header-bg.jpg','storage/dreamon/files/1/services/13 (1).jpg',7,-1,'2024-03-27 01:26:54','2024-03-28 23:08:51','','','','',1,1),(8,1,'Service Process','service-process','<p>At Immigway our culture comes to life through three core values:</p>\r\n\r\n<ul>\r\n	<li>We seize opportunities to innovate and grow</li>\r\n	<li>We are one firm with a shared sense of purpose</li>\r\n	<li>We care about each other and the world around us</li>\r\n</ul>','','','storage/dreamon/files/1/services/13 (1).jpg',8,-1,'2024-03-27 01:27:36','2024-03-28 23:08:57','','','','',1,1),(9,0,'Academic Counselling','academic-counselling','<p>In today&rsquo;s world, choosing the right course is crucial for students.&nbsp;Dream On can help students explore different courses and programs that fit with their interests, academic qualifications, and financial situation.</p>\r\n\r\n<p>Our counselling department knows what universities in different countries will look for and what Standardized English Test courses students should take to be eligible for admission to university. We also search for colleges or universities that provide financial aid. Students are also encouraged to check admission requirements with individual universities.</p>','','storage/dreamon/files/1/background/page-header-bg.jpg','storage/dreamon/files/1/services/13 (1).jpg',9,1,'2024-03-28 23:06:40','2024-03-28 23:09:07','','','','',1,1);

--
-- Table structure for table `tbl_settings`
--

CREATE TABLE `tbl_settings` (
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `url1` varchar(255) DEFAULT NULL,
  `url2` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `secondary_phone` varchar(255) DEFAULT NULL,
  `working_hours` varchar(255) DEFAULT NULL,
  `working_days` varchar(255) DEFAULT NULL,
  `leave_days` varchar(255) DEFAULT NULL,
  `google_map` text DEFAULT NULL,
  `fb` varchar(255) DEFAULT NULL,
  `insta` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `tiktok` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `primary_logo` varchar(255) DEFAULT NULL,
  `secondary_logo` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `og_image` varchar(255) DEFAULT NULL,
  `no_image` varchar(250) DEFAULT NULL,
  `copyright_text` varchar(250) DEFAULT NULL,
  `content1` text DEFAULT NULL,
  `content2` text DEFAULT NULL,
  `content3` text DEFAULT NULL,
  `seo_title` varchar(255) DEFAULT NULL,
  `seo_description` text DEFAULT NULL,
  `seo_keywords` text DEFAULT NULL,
  `og_tags` text DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  `recaptcha_secret_key` varchar(255) DEFAULT NULL,
  `recaptcha_site_key` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`setting_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_settings`
--

INSERT INTO `tbl_settings` VALUES (1,'Bibhuti LMS','Ved International Education Consultancy is a private limited company registered under the Government of Nepal (REGD. No. 78839/067/068). Ved International Education Consultancy is the best consultancy in Nepal established in 2010,','info@dreamoneducation.com','','Dillibazar, Kathmandu','info@vedinternational.com','+977 1 4010588','','09:30 AM - 5:30 PM','Sun - Fri','','https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d883.0949391974468!2d85.32302736933097!3d27.705558793809068!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x39eb19fdc6a9c123%3A0xb39c97df78aa662a!2sVed%20International%20Education%20Consultancy!5e0!3m2!1sen!2snp!4v1715830558741!5m2!1sen!2snp','https://www.facebook.com','https://www.facebook.com','https://www.x.com/','https://www.youtube.com/','https://www.facebook.com','storage/ved/files/1/Logo/logo.png','storage/ved/files/1/Logo/logo.png','','storage/ved/files/1/logo-icon-02-01.png','','','©Copyright 2024 Ved International Consultancy. All rights reserved','https://www.youtube.com/watch?v=8Hf9gSXyPBc','','',NULL,'','','',1,1,NULL,'2024-10-01 07:09:15',NULL,1,'','');

--
-- Table structure for table `tbl_shortcodes`
--

CREATE TABLE `tbl_shortcodes` (
  `shortcode_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`shortcode_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_shortcodes`
--


--
-- Table structure for table `tbl_sliders`
--

CREATE TABLE `tbl_sliders` (
  `slider_id` int(11) NOT NULL AUTO_INCREMENT,
  `slider_title` varchar(255) DEFAULT NULL,
  `slider_desc` varchar(255) DEFAULT NULL,
  `url1` varchar(255) DEFAULT NULL,
  `url2` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`slider_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_sliders`
--

INSERT INTO `tbl_sliders` VALUES (3,'Repellendus Nihil q','Elit et non dolorem','Similique minima quo','Rerum doloremque eos','storage/ved/files/1/Sliders/slider1.jpg',1,1,1,1,'2024-05-19 02:19:43','2024-05-19 03:50:52'),(4,'','','','','storage/ved/files/1/Sliders/slider2.jpg',2,1,1,1,'2024-05-19 03:51:11','2024-05-19 03:51:11');

--
-- Table structure for table `tbl_subscribers`
--

CREATE TABLE `tbl_subscribers` (
  `subscriber_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`subscriber_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_subscribers`
--

INSERT INTO `tbl_subscribers` VALUES (1,NULL,NULL,'tancho@gmail.com',1,1,1,1,'2024-05-21 23:43:12','2024-05-21 23:43:12'),(2,NULL,NULL,'tanchohanglimb2@gmail.com',1,1,1,1,'2024-05-21 23:43:22','2024-05-21 23:43:22'),(3,NULL,NULL,'tanchohangtest@gmail.com',1,1,1,1,'2024-05-21 23:55:25','2024-05-21 23:55:25'),(4,NULL,NULL,'razusrest@gmail.com',1,1,1,1,'2024-06-10 06:52:27','2024-06-10 06:52:27');

--
-- Table structure for table `tbl_successstories`
--

CREATE TABLE `tbl_successstories` (
  `successstory_id` int(11) NOT NULL AUTO_INCREMENT,
  `countries_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(200) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `university` varchar(255) DEFAULT NULL,
  `faculty` varchar(255) DEFAULT NULL,
  `createdby` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updatedby` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`successstory_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_successstories`
--


--
-- Table structure for table `tbl_teams`
--

CREATE TABLE `tbl_teams` (
  `team_id` int(11) NOT NULL AUTO_INCREMENT,
  `branches_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`team_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_teams`
--

INSERT INTO `tbl_teams` VALUES (5,0,'Name','name',NULL,'storage/dreamon/files/1/team/1 (1).jpg','Designation','','',1,1,'2024-03-25 01:27:52','2024-03-25 01:27:52',1,1),(6,0,'Name','name',NULL,'storage/dreamon/files/1/team/2 (1).jpg','Designation','','',2,1,'2024-03-25 01:28:10','2024-03-25 01:28:10',1,1),(7,0,'Name','name',NULL,'storage/dreamon/files/1/team/3 (1).jpg','Designation','','',3,1,'2024-03-25 01:28:36','2024-03-25 01:28:36',1,1),(8,0,'Name','name',NULL,'storage/dreamon/files/1/team/4 (1).jpg','Designation','','',4,1,'2024-03-25 01:28:49','2024-03-25 01:28:49',1,1),(9,0,'Name','name',NULL,'storage/dreamon/files/1/team/5.jpg','Designation','','',5,1,'2024-03-25 01:29:01','2024-03-25 01:29:01',1,1),(10,0,'Name','name',NULL,'storage/dreamon/files/1/team/6.jpg','Designation','','',6,1,'2024-03-25 01:29:14','2024-03-25 01:29:14',1,1),(11,0,'Name','name',NULL,'storage/dreamon/files/1/team/7.jpg','Designation','','',7,1,'2024-03-25 01:29:38','2024-03-25 01:29:38',1,1),(12,0,'Name','name',NULL,'storage/dreamon/files/1/team/8.jpg','Designation','','',8,1,'2024-03-25 01:29:53','2024-03-25 01:29:53',1,1),(13,0,'Sima karki','sima-karki',NULL,'storage/dreamon/files/1/team/5.jpg','Manager','','',9,1,'2024-03-28 03:51:09','2024-03-28 03:51:09',1,1);

--
-- Table structure for table `tbl_testimonials`
--

CREATE TABLE `tbl_testimonials` (
  `testimonial_id` int(11) NOT NULL AUTO_INCREMENT,
  `branches_id` int(11) DEFAULT NULL,
  `for` varchar(255) DEFAULT NULL,
  `ref` int(11) DEFAULT 0,
  `by` varchar(255) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `alias` varchar(200) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `testimonials_faculty` varchar(255) DEFAULT NULL,
  `testimonials_university` varchar(255) DEFAULT NULL,
  `university` varchar(255) DEFAULT NULL,
  `faculty` varchar(255) DEFAULT NULL,
  `createdby` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updatedby` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`testimonial_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_testimonials`
--

INSERT INTO `tbl_testimonials` VALUES (10,NULL,NULL,0,'Shiva Regmi',NULL,'','storage/ved/files/1/images.png','','<p>Thanks to VED International, I was able to navigate the complex visa application process with ease. Their expert guidance and support ensured that all my documents were in order, and I received my student visa to Australia without any hitches. I highly recommend VED for their professionalism and commitment to student success.</p>','',1,1,NULL,NULL,NULL,'','1','2024-05-19 04:37:30','1','2024-06-06 07:56:26'),(11,NULL,NULL,0,'Anu Karki',NULL,'','storage/ved/files/1/images.png','','<p>VED International played a crucial role in helping me secure my student visa for Canada. Their team provided personalized assistance, helped me prepare all necessary documents, and guided me through the entire visa application process. I am grateful for their support and would recommend VED to anyone seeking visa assistance</p>','',2,1,NULL,NULL,NULL,'','1','2024-05-19 04:38:09','1','2024-06-06 07:56:54'),(12,NULL,NULL,0,'Sonam Rai',NULL,'','storage/ved/files/1/images.png','','<p>VED International exceeded my expectations in assisting me with my student visa application for New Zealand. Their knowledgeable counselors provided valuable insights, helped me with visa documentation, and guided me through every step of the process. I am now ready to pursue my dream of studying abroad, all thanks to VED.</p>','',3,1,NULL,NULL,NULL,'','1','2024-06-06 07:58:38','1','2024-06-06 07:58:38');

--
-- Table structure for table `tbl_universities`
--

CREATE TABLE `tbl_universities` (
  `university_id` int(11) NOT NULL AUTO_INCREMENT,
  `countries_id` int(11) DEFAULT 0,
  `title` varchar(250) DEFAULT NULL,
  `alias` varchar(250) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `thumb` varchar(250) DEFAULT NULL,
  `cover_photo` varchar(500) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `seo_keywords` text DEFAULT NULL,
  `seo_title` text DEFAULT NULL,
  `seo_descriptions` text DEFAULT NULL,
  `og_tags` text DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`university_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_universities`
--

INSERT INTO `tbl_universities` VALUES (1,5,'Test University','test-university','10','222','','',1,1,'2024-06-06 07:40:14','2024-06-06 07:40:14','','','','',1,1);

--
-- Table structure for table `tbl_university`
--

CREATE TABLE `tbl_university` (
  `university_id` int(11) NOT NULL AUTO_INCREMENT,
  `institution_id` int(11) DEFAULT NULL,
  `institutiontypes_id` int(11) DEFAULT NULL,
  `countries_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `createdby` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT current_timestamp(),
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`university_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_university`
--


--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_users`
--

INSERT INTO `tbl_users` VALUES (1,'Prajwal Adhikari','prajwalbro@hotmail.com','prajwalbro@hotmail.com',NULL,'$2y$10$3zlF9VeXexzWKRDPZuDio.W7RZIC3tU.cjwMoLzG8ki8bVwAQn1WW',NULL,NULL,NULL,NULL,1);

--
-- Table structure for table `tbl_videos`
--

CREATE TABLE `tbl_videos` (
  `video_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `alias` varchar(250) DEFAULT NULL,
  `link` varchar(250) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `updatedby` int(11) DEFAULT NULL,
  PRIMARY KEY (`video_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `tbl_videos`
--


--
-- Table structure for table `tbl_visas`
--

CREATE TABLE `tbl_visas` (
  `visa_id` int(11) NOT NULL AUTO_INCREMENT,
  `branches_id` int(11) DEFAULT NULL,
  `for` varchar(255) DEFAULT NULL,
  `ref` int(11) DEFAULT 0,
  `title` varchar(255) DEFAULT NULL,
  `alias` varchar(200) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `text` text DEFAULT NULL,
  `university` varchar(255) DEFAULT NULL,
  `faculty` varchar(255) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `createdby` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updatedby` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`visa_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_visas`
--



