--
-- Host: localhost    Database: wjohnschool_whjohnschoolDB
-- ------------------------------------------------------


--
-- Current Database: `wjohnschool_whjohnschoolDB`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `wjohnschool_whjohnschoolDB` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `wjohnschool_whjohnschoolDB`;

--
-- Table structure for table `admission_query`
--

CREATE TABLE `admission_query` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `parents` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `mobile` varchar(15) NOT NULL,
  `message` varchar(200) NOT NULL,
  `address` varchar(200) NOT NULL,
  `zipcode` varchar(10) NOT NULL,
  `state` varchar(20) NOT NULL,
  `referer` varchar(200) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admission_query`
--


--
-- Table structure for table `banner_tbl`
--

CREATE TABLE `banner_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `bannerName` varchar(80) NOT NULL DEFAULT '',
  `bannerUrl` varchar(80) DEFAULT '',
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  `bannerImage` varchar(500) DEFAULT NULL,
  `bannerCat` varchar(200) DEFAULT NULL,
  `bannerSubcat` varchar(200) DEFAULT NULL,
  `bannerorder` int(11) DEFAULT NULL,
  `optimisation` varchar(1000) DEFAULT NULL,
  `tagline` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banner_tbl`
--

INSERT INTO `banner_tbl` VALUES (1,'Providing Holistic Education','','2022-05-11','Y','Providing Holistic Education38.jpg','','',2,NULL,'The world’s leading scholastic institution by 2022'),(2,'Building Success to you','','2022-05-11','Y','Building Success to you27.jpg','','',3,NULL,'Better Course for Better Skill'),(3,'Cultural Events','','2022-05-11','Y','Cultural Events52.jpg','','',4,NULL,'Better Course for Better Skill'),(4,'Admission Open for Session 2024-2025','','2023-10-30','Y','Admission Open for Session 2024-202543.jpg','','',1,NULL,'');

--
-- Table structure for table `blog_tbl`
--

CREATE TABLE `blog_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` varchar(11) DEFAULT NULL,
  `catgurl` varchar(100) DEFAULT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) DEFAULT NULL,
  `blogDname` varchar(500) DEFAULT NULL,
  `blogDate` varchar(100) DEFAULT NULL,
  `blog_written` varchar(1000) DEFAULT NULL,
  `catDesc` text,
  `catDesc1` text,
  `catImage` varchar(1000) DEFAULT NULL,
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) DEFAULT NULL,
  `pageKeywords` text,
  `pageDescription` text,
  `pageTitle1` varchar(250) DEFAULT NULL,
  `pageDescription1` text,
  `pageKeywords1` text,
  `featureimage` varchar(1000) DEFAULT NULL,
  `banner1` varchar(250) DEFAULT NULL,
  `banner2` varchar(250) DEFAULT NULL,
  `banner3` varchar(250) DEFAULT NULL,
  `en_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog_tbl`
--

INSERT INTO `blog_tbl` VALUES (2,'',NULL,0,'What are the factors that need to be examined while choosing a school hostel','What are the factors that need to be examined while choosing a school hostel?','2022-09-15','W. John Multipurpose Boarding School','','<p>Education plays an inevitable role in our life. In the modern era, we have developed numerous education methods that help students to understand the core learning aspects. Moreover, with practicality, we find that we have opened an enormous world of opportunities for our aspiring future generations. Most importantly, the word education defines every aspect of our surrounding world. Furthermore, knowledge and awareness are one of the best assets for any individual mind. These values make big changes and even develop critical thinking with creative sets of people who are going to experiment every day to make a better place to live in.</p>\r\n\r\n<p>Apart from the role of education, we need to find the best place to make the roadmap of this beautiful journey, at W. John Multipurpose boarding school we provide the best co-education with modern facilities. We support all individual thoughts of students and our experienced teachers and faculty help them to polish their thoughts. Now, you know insights into our leading boarding institution. Despite this, being parents you might be thinking about factors while choosing a school hostel. So, we have already written down the set of factors that help you to consider the best school hostel for your kids:-</p>\r\n\r\n<ol>\r\n	<li>Understand the vision of the school:- The first is to understand the set of visions of any leading institution. Although, the roadmap of any school helps to stretch your thoughts and give you a vivid perspective and philosophy of a school. Moreover, you can even attend open classes and quick interaction with the teaching faculty for deeper insights into the school.</li>\r\n	<li>Safe campus:- Safety of the students is one of the core components of any institution. Moreover, for considering a school hostel the first thing is to evaluate the safety majors of the school such as surveillance and a fully equipped campus with CCTV cameras. Apart from this, active and structured management will help to find the best way to dissolve any issue. Furthermore, a hostel campus should be stretched over good acres of space with a pollution-free environment.&nbsp;</li>\r\n	<li>Facilities:- The short insights into school facilities help to understand the well-organized structure of a school. For a hostel, we need to understand the major and crucial facilities that schools provide such as proper sanitation and norms for hygiene, pristine drinking water, and a proper framework of lighting on the entire campus has been set up. Most importantly, well-equipped safety major for uncertain calamities.&nbsp;</li>\r\n	<li>Nutritious food:- As education is one of the key factors for the step-by-step development of a human brain. For the growth of comprehensive and analytical thoughts, a student needs a balanced and nutritious diet so that they can get good amounts of crucial protein, vitamins, minerals, and a lot more. Moreover, the hostel mess is an integral part of the school so it is a major responsibility that there would be well-organized management for every department such as cooking, sanitation, and maintenance. All these factors make a balanced diet for a student.</li>\r\n	<li>Discipline:- In hostels, students not only interact with their peer groups but also understand the core objective of social life. Moreover, the set of rules and regulations develops a positive attitude and discipline for the rest of their life. And, in hostels, the management needs to set all the important norms so that every student will be accountable for their their actions.</li>\r\n</ol>\r\n','What-are-the-factors-that-need-to-be-examined-while-choosing-a-school-hostel52.jpg','N',1,'Y','','','Education plays an inevitable role in our life. In the modern era, we have developed numerous education methods that help students to understand the core learning aspects. Moreover, with practicality, we find that we have opened an enormous world of opportunities for our aspiring future generations. Most importantly, the word education defines every aspect of our surrounding world.',NULL,NULL,NULL,'',NULL,NULL,NULL,'2022-11-24 07:47:48'),(3,'',NULL,0,'How music and art helps in enhancing the personality of a student','How music and art helps in enhancing the personality of a student ?','2022-09-15','W. John Multipurpose Boarding School','','<p>Education is one of the best tools for comprehensive knowledge and the overall development of an individual personality. The core aspect of education helps grow analytical and innovative thought processes. Most importantly, education spreads awareness and supports enlightenment in the life of a person. Moreover, according to the major studies, the education that is retained from practical experience lasts for the rest of their life, and most interestingly, students grasp more skills through creative curriculums because the activities they perform impact positively and add vibrant thoughts, in addition, to help them to perform better in their academic results. Every institution has the vision to provide the best understanding and importance of education so that every student can make better changes in every step to building an accountable and supporting equal opportunities for every gender of society.</p>\r\n\r\n<p>Despite this, if you are wondering how effectively music and art forms help in enhancing the overall personality of a student then we are going to disclose some important factors that are going to blow your mind. Before heading those points, let&#39;s first glance over the importance of music and art in our life. Undoubtedly, music is a way to express every emotion of a human being. And, the way music and art define emotion is an unmatched aspect of our life. Some studies prove that music and art practices grow creativity and enhance the productivity of a person.</p>\r\n\r\n<p>How does music increase productivity in student life?</p>\r\n\r\n<ol>\r\n	<li>Healthy Heart:- According to research, every beat of the music makes the blood flow easier. Most importantly, it alleviates the heart rate and even reduces blood pressure. Despite this, music and art unanimously reduce stress and enhance body performance. Moreover, in student life, this helps them to boost their academic results.</li>\r\n	<li>Learning of collaborative work:- Teamwork is one of the important aspects that every student needs to learn so that they can understand social interaction skills. Moreover, teachers help students to draw a perimeter of society and comprehend the importance of teamwork. This increases public speaking and boosts confidence.</li>\r\n</ol>\r\n','How-music-and-art-helps-in-enhancing-the-personality-of-a-student00.jpg','N',2,'Y','','','Education is one of the best tools for comprehensive knowledge and the overall development of an individual personality. The core aspect of education helps in the growth of analytical and innovative thought processes. Most importantly, education spreads awareness and supports enlightenment in the life of a person.',NULL,NULL,NULL,'',NULL,NULL,NULL,'2022-11-24 07:52:14'),(4,'',NULL,0,'How to understand the norms of discipline through boarding school','How to understand the norms of discipline through boarding school?','2022-09-15','W. John Multipurpose Boarding School','','<p>Learning is one of the beautiful journeys to get an understanding of the core aspects of education. In today&rsquo;s era education is tremendously connected with modern technology that works on quality and develops most reliably with easily accessible tools to make the roadmap of knowledge based on practicality so that students grasp all the methods and use them on the ground level. Most importantly, choosing a top-leading educational institute for a child is one of the biggest hurdles. Today we want to stretch your attention to how you can select the best school for your kids. Apparently, in the modern world parents are doing enormous research on boarding schools. Although these schools are well-structured hubs of the current scenario moreover, boarding schools are run systemically and add all the crucial facilities with top-notch technology so that students get easily familiar with the technical world. And even, think out of the box and practice every day to make innovative ideas. In the education system, we are lacking in the development of creative thoughts. On the flip side, boarding school opens enormous opportunities for students to enhance their productivity and the experienced faculty of teachers paint unfold questions in their minds so that they find those answers and this helps them to evaluate multi-dimensions thoughts.</p>\r\n\r\n<p>Apart from supreme education, in boarding school, every student understands the rules of life. Certain rules help us to maintain our bodies effectively. We can term it Discipline, this word expresses a set of rules and regulations. These rules develop enormous habits, routines, and behavior for our entire life. Furthermore, these norms can change our lifestyle in a short period. So, the basic idea of discipline in school is to make the authority accountable and develop effective mechanisms for students for the rest of life. Now, you might have a question: how does discipline enhance the productivity of students? Here, we are disclosing some facts that are going to blow your mind.</p>\r\n\r\n<ol>\r\n	<li>Understanding of self-discipline:- In boarding school rules are based on the idea of accountability and management. Most importantly, this helps in the effective management of every authority. Moreover, the core importance of self-discipline refers to improving thoughts oneself and this helps students to understand and enhance their capability of creative thought process. Furthermore, these new ideas improvise their chain of thoughts and make them focused along with self-centeredness.&nbsp;</li>\r\n	<li>Good behavior:- Discipline involves building good behavior. For students, it is important to understand the deep meaning of behavior. And, the boarding builds an effective set of rules and regulations for helping the student to develop a basic routine and structured plan throughout the day.&nbsp;</li>\r\n	<li>Development of overall personality:- The objective of discipline improvises the overall personality of a student including the development of public speaking and management skill with boosting confidence. These factors are the core aspects of building the marvelous personality of any person. Moreover, in boarding school, students get a deep understanding of every important rule for living a better life in the future. So, do experience the unmatched journey of boarding school.</li>\r\n</ol>\r\n','How-to-understand-the-norms-of-discipline-through-boarding-school56.jpg','N',3,'Y','','','Learning is one of the beautiful journeys to get an understanding of the core aspects of education. In today’s era education is tremendously connected with modern technology that works on quality and develops most reliably with easily accessible tools to make the roadmap of knowledge based on practicality so that students grasp all the methods and use them on the ground level.',NULL,NULL,NULL,'',NULL,NULL,NULL,'2022-11-24 07:55:23');

--
-- Table structure for table `brand_tbl`
--

CREATE TABLE `brand_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `brandName` varchar(200) NOT NULL DEFAULT '',
  `brandImage` varchar(200) NOT NULL DEFAULT '',
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  `brandTitle` text NOT NULL,
  `brandKeyword` text NOT NULL,
  `brandDesc` text NOT NULL,
  `brandHeading` text NOT NULL,
  `brandDetail` text NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `brand_tbl`
--


--
-- Table structure for table `bus_fare_tbl`
--

CREATE TABLE `bus_fare_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `place` varchar(50) DEFAULT NULL,
  `fare` int(11) NOT NULL,
  `status` enum('Active','Inactive','','') NOT NULL DEFAULT 'Active',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bus_fare_tbl`
--

INSERT INTO `bus_fare_tbl` VALUES (1,'Itki',1512,'Active','2023-04-24 09:18:58'),(5,'College More',2101,'Active','2023-04-24 09:58:34'),(6,'Tetar Toli',2138,'Active','2023-04-24 09:58:55'),(7,'Bero Chowk',2248,'Active','2023-04-24 09:59:08'),(8,'Jamtoli, Bero',2276,'Active','2023-04-24 09:59:41'),(9,'Moro',1898,'Active','2023-04-24 09:59:55'),(10,'Itki More',1207,'Active','2023-04-24 10:00:10'),(11,'Zila Parishad',2248,'Active','2023-04-24 10:00:31'),(12,'Devimandap Chowk',2202,'Active','2023-04-24 10:00:42'),(13,'Patrachauli',977,'Active','2023-04-24 10:01:02'),(14,'Malar',1115,'Active','2023-04-24 10:01:19'),(15,'Semra',1336,'Active','2023-04-24 10:01:30'),(16,'Kurgi',1391,'Active','2023-04-24 10:01:44'),(17,'Bero',2248,'Active','2023-04-24 10:01:57'),(18,'Karanji',2350,'Active','2023-04-24 10:02:18'),(19,'Tuko',2746,'Active','2023-04-24 10:02:29'),(20,'Chatti Market',3089,'Active','2023-04-24 10:02:44'),(21,'Garhagaon',1668,'Active','2023-04-24 10:03:00'),(22,'Jarya',1944,'Active','2023-04-24 10:03:13'),(23,'Kasa Mode',2036,'Active','2023-04-24 10:03:31'),(24,'Tetartoli',2138,'Active','2023-04-24 10:03:48'),(25,'Jamtoli',2303,'Active','2023-04-24 10:04:34'),(26,'Binay Bagicha, Bero',2322,'Active','2023-04-24 10:04:57'),(27,'Baradhi, Bero',2332,'Active','2023-04-24 10:05:09'),(28,'College Gate',2101,'Active','2023-04-24 10:05:36'),(29,'Purna Pani, Bero',2608,'Active','2023-04-24 10:05:50'),(30,'Tikratoli',766,'Active','2023-04-24 10:06:05'),(31,'Kolambi More',867,'Active','2023-04-24 10:06:21'),(32,'Satish Chowk',894,'Active','2023-04-24 10:06:33'),(33,'Saparom Chowk',959,'Active','2023-04-24 10:06:50'),(34,'JK AutoCare',1014,'Active','2023-04-24 10:07:00'),(35,'Lalgutwa Ring Rd, Galaxy Motors',1262,'Active','2023-04-24 10:07:14'),(36,'Major Kothi',1456,'Active','2023-04-24 10:07:31'),(37,'Bajra, Pushpa Hardware',1492,'Active','2023-04-24 10:07:44'),(38,'Dhoni Farmhouse',1502,'Active','2023-04-24 10:07:57'),(39,'Jaslok Hospital',1475,'Active','2023-04-24 10:08:09'),(40,'Pahartoli Rd, Bajra',1484,'Active','2023-04-24 10:08:22'),(41,'ITI',1567,'Active','2023-04-24 10:08:34'),(42,'Uma Heights Kawasaki Showroom',1641,'Active','2023-04-24 10:08:55'),(43,'Pandra',2156,'Active','2023-04-24 10:09:06'),(44,'Kamlesh Dubey Chowk, Radio St. Rd',1604,'Active','2023-04-24 10:09:22'),(45,'Kathitand Chowk',1650,'Active','2023-04-24 10:09:34'),(46,'Kamre',1788,'Active','2023-04-24 10:09:52'),(47,'Kosaro',876,'Active','2023-04-24 10:10:10'),(48,'Premnagar',968,'Active','2023-04-24 10:10:37'),(49,'Erchoro',1428,'Active','2023-04-24 10:10:47'),(50,'Kathal More to Daladili Road',1428,'Active','2023-04-24 10:10:58'),(51,'Daladili',1512,'Active','2023-04-24 10:11:07'),(52,'Saparom',968,'Active','2023-04-24 10:11:23'),(53,'Lalgutwa Basti',1180,'Active','2023-04-24 10:11:44'),(54,'Hariyali',1410,'Active','2023-04-24 10:12:13'),(55,'Dhipatoli',1557,'Active','2023-04-24 10:12:28'),(56,'Pancham Nagar',1530,'Active','2023-04-24 10:12:50'),(57,'Chaputoli',1586,'Active','2023-04-24 10:13:04'),(58,'Kadru',1788,'Active','2023-04-24 10:13:15'),(59,'Rajendra Chowk',1917,'Active','2023-04-24 10:13:32'),(60,'Kutchery Chowk',1963,'Active','2023-04-24 10:13:58'),(61,'Bahu Bazar',2046,'Active','2023-04-24 10:14:12'),(62,'Elahi Nagar',1540,'Active','2023-04-24 10:14:30'),(63,'SBI Nagri',692,'Active','2023-04-24 10:14:43'),(64,'Mother Dairy',839,'Active','2023-04-24 10:14:55'),(65,'Kudlong',1005,'Active','2023-04-24 10:15:08'),(66,'IIM Road',1226,'Active','2023-04-24 10:15:23'),(67,'Balalong',1364,'Active','2023-04-24 10:15:37'),(68,'Sembo',1437,'Active','2023-04-24 10:15:50'),(69,'Dhurwa Golchakkar',1751,'Active','2023-04-24 10:16:03'),(70,'Hatia Chandni Chowk',1972,'Active','2023-04-24 10:16:15'),(71,'Singh More',2101,'Active','2023-04-24 10:16:30'),(72,'JSCA',1604,'Active','2023-04-24 10:16:42'),(73,'Tang Tang Toli',1632,'Active','2023-04-24 10:16:58'),(74,'Masjide Hanjla Saparom',1014,'Active','2023-04-24 10:17:11'),(75,'C.N.I. Church Saparom',1032,'Active','2023-04-24 10:17:24'),(76,'Dahutoli, Damside',1483,'Active','2023-04-24 10:17:44'),(77,'Daud Nagar, Dibdih Flyover',1816,'Active','2023-04-24 10:18:01'),(78,'Kujur Chowk, Nayasarai Road',1134,'Active','2023-04-24 10:18:15'),(79,'Kansili',1567,'Active','2023-04-24 10:18:30');

--
-- Table structure for table `category_tbl`
--

CREATE TABLE `category_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` varchar(11) DEFAULT NULL,
  `catgurl` varchar(100) DEFAULT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) DEFAULT NULL,
  `catIcon` varchar(200) DEFAULT NULL,
  `home_category` varchar(20) NOT NULL DEFAULT '0',
  `catDesc` text,
  `catDesc1` text,
  `catImage` varchar(500) DEFAULT NULL,
  `multi_image` varchar(500) DEFAULT NULL,
  `catBanner` varchar(500) DEFAULT NULL,
  `catVideo` varchar(250) DEFAULT NULL,
  `topBusinessCategory` char(1) DEFAULT 'N',
  `catOrder` int(11) DEFAULT '0',
  `status` char(1) DEFAULT 'Y',
  `pageTitle` varchar(250) DEFAULT NULL,
  `pageKeywords` text,
  `pageDescription` text,
  `pageTitle1` varchar(250) DEFAULT NULL,
  `pageDescription1` text,
  `pageDescription2` text,
  `pageKeywords1` text,
  `footerContent` text,
  `catalogImage` varchar(500) DEFAULT NULL,
  `catalogLink` varchar(600) DEFAULT NULL,
  `displayName` varchar(500) DEFAULT NULL,
  `faq_icon` varchar(500) DEFAULT NULL,
  `headingh1` varchar(200) DEFAULT NULL,
  `headingh2` varchar(200) DEFAULT NULL,
  `alttag` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category_tbl`
--

INSERT INTO `category_tbl` VALUES (1,'',NULL,0,'Beyond Academics','','0','The W. John Multipurpose Boarding School is entitled to provide top-notch academic results beyond academics, our school is committed to building an accountable and well-structured system. We provide the best housing infrastructure, adventurous and thrilling tours, and experimental activities, and retain modern equipment for sports & games, dance, and music. All these activities help students to enhance their physical capabilities. Apart from this, we have highly ventilated auditoriums and theater rooms for collaborative performances and live shows along with role plays.\r\n','<p>The W. John Multipurpose Boarding School is entitled to provide top-notch academic results; <strong>beyond academics, </strong>our school is committed to building an accountable and well-structured system. We provide the best housing infrastructure, adventurous and thrilling tours, and experimental activities, and retain modern equipment for sports &amp; games, dance, and music. All these activities help students to enhance their physical capabilities. Apart from this, we have highly ventilated auditoriums and theater rooms for collaborative performances and live shows along with role plays.</p>\r\n\r\n<p>Furthermore, we have expanded our curriculum activities in art &amp; crafts and yoga. Most importantly, we want to serve highly advanced and in-demand skills to every student. So, every student finds their capabilities and skills. Even studies have articulated that curriculum activities enhance the productivity of students although these activities improve the outcomes of results. This develops competitive spirit and even improves their confidence and helps them to choose their career beyond academics. So, the whole journey of education and curriculum activities go hand-in-hand with the overall performance of a student.</p>\r\n','Beyond-Academics45.jpg',NULL,'','','N',1,'Y','Beyond Academics','Beyond Academics','Beyond Academics',NULL,'','',NULL,'','','','Beyond Academics','',NULL,NULL,NULL),(2,'',NULL,1,'Sports','','0','John Multipurpose Boarding School is counted as one of the best sports boarding schools in Ranchi. We believe that the root of knowledge is not developed only in rectangular classrooms. Moreover, the sports field also teaches you unparalleled lessons about life. In the modern era, the world is focusing on developing core mechanisms in education and its co-curriculum as well. So, with our pioneering experience and dedicated teacher sports teachers, our school has to make glorifying achievements on the ground and add pride to our leading school.\r\n','<p>W. John Multipurpose Boarding School is counted as one of the <strong>Best Sports Boarding Schools in Ranchi</strong>. We believe that the root of knowledge is not developed only in rectangular classrooms. Moreover, the sports field also teaches you unparalleled lessons about life. In the modern era, the world is focusing on developing core mechanisms in education and its co-curriculum as well. So, with our pioneering experience and dedicated teacher sports teachers, our school has to make glorifying achievements on the ground and add pride to our leading school.</p>\r\n\r\n<p>Our school provides equal opportunities in sports to enhance the capabilities and overall development of the student. The vision of our school is to create knowledgeable and creative minds along with highly spirited citizens for the future. We are counted in&nbsp;<strong>Top Sports Boarding School in Jharkhand,</strong>&nbsp;Although all these core assets are the pride of our nation, we need to give our greatest strength to our enlightened generation.</p>\r\n\r\n<p>At W. John school, we acknowledge physical education as an integral component of life. And, we pay concern to each student so that we create crucial career options for their future prospective. Despite this, we prepare our students for district, state, and national level tournaments. Most importantly, we acknowledge our student&#39;s excellent and competitive spirit on the annual sports day. Furthermore, our school retains modern equipment with full-sized sports fields for volleyball courts, table tennis, badminton, and a lot more. We practice every day to perform better in the future.</p>\r\n','Sports50.jpg','gallery1.jpg,gallery2.jpg,gallery3.jpg,gallery4.jpg,gallery5.jpg,gallery6.jpg','','','N',1,'Y','Best Sports Boarding Schools in Ranchi, Top Sports Boarding School in Jharkhand','Best Sports Boarding Schools in Ranchi,  Top Sports Boarding School in Jharkhand, Sports Boarding Schools in Ranchi','W.John Multipurpose Boarding School runs its sports programs in the school for student fitness, healthier lifestyle and tremendous growth of the children.✓Boarding School ✓Secondary School ✓  Enroll Now!',NULL,'','',NULL,'','','','Sports','','','Best Sports Boarding Schools','Best Sports Boarding Schools'),(3,'',NULL,1,'Music and Dance','','0','W. John Multipurpose Boarding school serves the best music and dance classes in Ranchi. If education develops and widens critical thinking then other curriculum activities polish the core mind of students. You have probably heard that practice makes a man perfect. Moreover, learning the aspects of learning with the help of music and dance gives more fruitful outcomes. ','<p>W. John Multipurpose Boarding school serves the <strong>Best Music Classes in Ranchi</strong>. If education develops and widens critical thinking then other curriculum activities polish the core mind of students. You have probably heard that practice makes a man perfect. Moreover, learning the aspects of learning with the help of music and dance gives more fruitful outcomes.&nbsp;</p>\r\n\r\n<p>The perspective of our school is to make comprehensible learning of deep-root music and dance. Most importantly, our experienced teachers and organized management always support every student to engage with another student and share a creative set of thoughts. We provide the <strong>Top Dance Classes in Jharkhand,</strong>&nbsp;Through music and art, we have designed interactive sessions of learning. Moreover, in these programs, we add various assessments and presentations that can also boost morale and confidence in public speaking. Although, we help students in understanding music and dance forms so that they can easily get to know the culture and different religious music knowledge of playing instruments promotes career options in art in the future.</p>\r\n','Music-and-Dance03.jpg','gallery1.jpg,gallery2.jpg,gallery3.jpg,gallery4.jpg,gallery5.jpg,gallery6.jpg','','','N',2,'Y','Best Music Classes in Ranchi, Top Dance Classes in Jharkhand ','Best Music Classes in Ranchi, Top Dance Classes in Jharkhand, Music Classes in Ranchi, Top Dance Classes in Jharkhand','W. John Multipurpose Boarding School provides music and dance classes in Ranchi and all the benefits that can be gained through its learning. By promoting traditional music. ',NULL,'','',NULL,'','','','Music and Dance','','','Music and Dance Classes','Music and Dance Classes'),(4,'',NULL,1,'School Trips and Excursion','','0','W. John Multipurpose Boarding School believes that school trips and excursions are the best way to get closer to our surroundings and natural habitat. From the birth of a child, it is always learning about its surrounding environment. And, when a child entered the world of knowledge in school he already covered the aspects of life. Moreover, we know that teachers enlighten the pages of students life but you might have heard about the real experience and goals of life from the field trips.','<p>W. John Multipurpose Boarding School believes that <strong>School Trips and Excursion in Ranchi </strong>are the best way to get closer to our surroundings and natural habitat. From the birth of a child, it is always learning about its surrounding environment. And, when a child entered the world of knowledge in school he already covered the aspects of life. Moreover, we know that teachers enlighten the pages of students&#39; life but you might have heard about the real experience and goals of life from the field trips.</p>\r\n\r\n<p>The vision of our school is to develop the core and critical thinking of the outside world in our student&#39;s life&#39;s page with education and excursion. Furthermore,W. John Multipurpose Boarding School are counted in&nbsp;<strong>Best School Picnic Outing in Jharkhand,</strong> we provide annual education trips to engage our students with different cities and states so that they can understand the pioneering ritual and glorifying history of our nation. With this, they understand the importance of social interaction and adapt to different environments of our surroundings. On these trips, our teachers do interactive sessions and activities such as trekking, gaming, and competitive activities. Despite this, our educational trip includes visits to famous places, museums, and historic architects. This boosts enthusiasm in students and learning aspects as well.</p>\r\n','School-Trips-and-Excursion47.jpg','gallery1.jpg,gallery2.jpg,gallery5.jpg,gallery6.jpg','','','N',3,'Y','School Trips and Excursion in Ranchi, Best School Picnic Outing in Jharkhand ','School Trips and Excursion in Ranchi, Best School Picnic Outing in Jharkhand, School Trips in Ranchi','W. John Multipurpose Boarding School in Ranchi Organized an Educational Trip as well as a fun trip wherein the students got to see, learn, explore life and make memories forever.',NULL,'','',NULL,'','','','School Trips and Excursion','','','School Trips and Excursion','School Trips and Excursion'),(5,'',NULL,1,'Science And Art Exhibition','','0','At W. John Multipurpose Boarding School, with a rich tapestry of exhibits spanning various disciplines, this exhibition promises to captivate audiences and inspire a profound appreciation for the intersection of science and art. We are thrilled to announce our upcoming event, the Science & Art Exhibition 2024. This eagerly anticipated showcase will bring together the innovative and creative talents of our students, providing a platform for them to demonstrate their prowess in both scientific inquiry and artistic expression.','<p>At W. John Multipurpose Boarding School, with a rich tapestry of exhibits spanning various disciplines, this exhibition promises to captivate audiences and inspire a profound appreciation for the intersection of science and art. We are thrilled to announce our upcoming event, the <strong>Science &amp; Art Exhibition 2024</strong>. This eagerly anticipated showcase will bring together the innovative and creative talents of our students, providing a platform for them to demonstrate their prowess in both scientific inquiry and artistic expression.</p>\r\n\r\n<p>From captivating installations exploring the wonders of the cosmos to intricately crafted works of visual art inspired by the natural world, visitors will be immersed in a multifaceted exploration of human ingenuity and creativity. <strong>Science &amp; Art Exhibition in W. John Multipurpose Boarding School</strong> serves as a testament to our commitment to fostering holistic education that nurtures both the analytical and imaginative faculties of our students. By showcasing the interconnectedness of these seemingly disparate realms, we aim to ignite curiosity, spark dialogue, and cultivate a deeper understanding of the world around us. Join us as we celebrate the boundless potential of the human mind at the Science &amp; Art Exhibition in W. John Multipurpose Boarding School.</p>\r\n','Art-and-Craft23.jpg','gallery1.jpg,gallery2.jpg,gallery3.jpg,gallery4.jpg,gallery5.jpg,gallery6.jpg','','','N',4,'Y','Science & Art Exhibition- W. John Multipurpose Boarding School','Science & Art Exhibition 2024, Science & Art Exhibition in W. John Multipurpose Boarding School','W. John Multipurpose Boarding School organized every year Science & Art Exhibition to provide an opportunity for children to exhibit their ideas and talent in various subjects and concepts.',NULL,'','',NULL,'','','','Science & Art Exhibition','','','Science & Art Exhibition','Science & Art Exhibition'),(6,'',NULL,1,'School Band','','0','W. John Multipurpose Boarding School is one of the leading and pioneering schools in Ranchi. We persistently work to build and expand our facilities to enhance the capabilities of students. Moreover, our vision is to create more productive career options for our enthusiastic students. For the same, we obtain numerous curriculum activities including school band. And, indeed it is one of the best school bands in the boarding school of Ranchi.','<p>W. John Multipurpose Boarding School is one of the leading and pioneering <strong>School Band in Ranchi</strong>. We persistently work to build and expand our facilities to enhance the capabilities of students. Moreover, our vision is to create more productive career options for our enthusiastic students. For the same, we obtain numerous curriculum activities including school band. And, indeed it is one of the best school bands in the boarding school of Ranchi.</p>\r\n\r\n<p>The perspective creates a school band to comprise a group of individual and innovative students who can construct and design an unmatched set of ideas. Furthermore, the word band is synonymous with the constructive setup of melodies and music groups. The school band is further divided into marching and live concert bands. W. John Multipurpose Boarding School counted in &nbsp;<strong>Top Music Band in Jharkhand</strong>. We believe that practice and a set of disciplines are the best way to develop teamwork and build a path to achieve better outcomes in the future. Apart from the results, we have provided all the best equipment to your students such as drum kits, flutes, maracas, tambourines, harmoniums, and guitars. Our experienced and dedicated teachers make an accessible goal to students and support them to find their abilities and promote positive social bonds between the students.</p>\r\n','School-Band57.jpg','','','','N',5,'Y','School Band in Ranchi, Top Music Band in Jharkhand','School Band in Ranchi, Top Music Band in Jharkhand, Best School Band in Ranchi','W. John Multipurpose Boarding School Provide Music Art & Training in Ranchi, focuses on the Bands, especially Music Band, and all the benefits that can be gained through its learning. By promoting traditional music. ',NULL,'<p>It gives us great pleasure to present our humble Institute to you: W. John School of Multipurpose Boarding. Education that fosters universal and internal values, aimed at the unity and integration of our citizens, helps to eradicate populism, religious fanaticism, aggression, superstition, and fatalism in our culturally plural society.</p>\r\n','<p>It gives us great pleasure to present our humble Institute to you: W. John School of Multipurpose Boarding. Education that fosters universal and internal values, aimed at the unity and integration of our citizens, helps to eradicate populism, religious fanaticism, aggression, superstition, and fatalism in our culturally plural society.</p>\r\n',NULL,'','','','School Band','','','School Band','School Band');

--
-- Table structure for table `catpro_tbl`
--

CREATE TABLE `catpro_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `catDesc` text NOT NULL,
  `catDesc1` text NOT NULL,
  `catImage` varchar(50) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  `pageTitle1` varchar(250) NOT NULL,
  `pageDescription1` text NOT NULL,
  `pageKeywords1` text NOT NULL,
  `footerContent` text NOT NULL,
  `catalogImage` varchar(500) NOT NULL,
  `catalogLink` varchar(600) NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `catpro_tbl`
--


--
-- Table structure for table `catvideo_tbl`
--

CREATE TABLE `catvideo_tbl` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_title` varchar(800) NOT NULL,
  `product_code` varchar(700) NOT NULL,
  `product_image` text,
  `product_image1` varchar(500) DEFAULT NULL,
  `product_image2` varchar(500) DEFAULT NULL,
  `product_image3` varchar(500) DEFAULT NULL,
  `product_alt` varchar(500) NOT NULL,
  `product_desc` text NOT NULL,
  `product_metatitle` varchar(300) NOT NULL,
  `product_metadesc` varchar(800) NOT NULL,
  `product_metakeyword` varchar(800) NOT NULL,
  `product_cat` varchar(400) NOT NULL,
  `prodcut_subcat` varchar(400) NOT NULL,
  `product_subsubcat` varchar(400) NOT NULL,
  `product_date` varchar(400) NOT NULL,
  `prodcut_status` int(11) NOT NULL DEFAULT '0',
  `product_finalcat` varchar(600) NOT NULL,
  `product_min_order` varchar(400) NOT NULL,
  `product_supply` varchar(600) NOT NULL,
  `product_origin` varchar(600) NOT NULL,
  `product_pterms` varchar(600) NOT NULL,
  `product_price` varchar(600) NOT NULL,
  `product_swearType` varchar(100) NOT NULL,
  `product_supplyType` varchar(100) NOT NULL,
  `product_Gender` varchar(100) NOT NULL,
  `product_ageGroup` varchar(100) NOT NULL,
  `product_size` varchar(100) NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `catvideo_tbl`
--


--
-- Table structure for table `city`
--

CREATE TABLE `city` (
  `cityID` int(5) NOT NULL AUTO_INCREMENT,
  `parentID` int(5) NOT NULL,
  `cityName` varchar(70) NOT NULL,
  `cityURL` varchar(70) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'Y',
  `hotstatus` varchar(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`cityID`),
  KEY `parentID` (`parentID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `city`
--


--
-- Table structure for table `client_tbl`
--

CREATE TABLE `client_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `logo_image` varchar(800) NOT NULL,
  `client_order` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client_tbl`
--


--
-- Table structure for table `clinic_location_tbl`
--

CREATE TABLE `clinic_location_tbl` (
  `locationID` int(11) NOT NULL AUTO_INCREMENT,
  `parentID` varchar(30) DEFAULT NULL,
  `locationName` varchar(800) NOT NULL DEFAULT '',
  `locationtDesc` text NOT NULL,
  `locationImage` varchar(50) NOT NULL DEFAULT '',
  `locationOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  `pageTitle1` varchar(250) NOT NULL,
  `pageDescription1` text NOT NULL,
  `pageKeywords1` text NOT NULL,
  `locationPosition` int(11) NOT NULL DEFAULT '0',
  `locationIcon` varchar(100) NOT NULL,
  `locationBanner` text,
  PRIMARY KEY (`locationID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `clinic_location_tbl`
--


--
-- Table structure for table `colaboration_tbl`
--

CREATE TABLE `colaboration_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(300) DEFAULT NULL,
  `email` varchar(300) DEFAULT NULL,
  `mobile` varchar(300) DEFAULT NULL,
  `location` varchar(400) DEFAULT NULL,
  `qualification` varchar(400) DEFAULT NULL,
  `experience` varchar(200) DEFAULT NULL,
  `specialisation` varchar(500) DEFAULT NULL,
  `address` text,
  `cv_file` text,
  `ip` varchar(300) DEFAULT NULL,
  `url` varchar(500) DEFAULT NULL,
  `enquiry_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `colaboration_tbl`
--


--
-- Table structure for table `collar_tbl`
--

CREATE TABLE `collar_tbl` (
  `collar_id` int(11) NOT NULL AUTO_INCREMENT,
  `collar_name` varchar(600) NOT NULL,
  `collar_image` varchar(600) NOT NULL,
  PRIMARY KEY (`collar_id`),
  UNIQUE KEY `collar_id` (`collar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `collar_tbl`
--


--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `slno` int(6) NOT NULL AUTO_INCREMENT,
  `cont_code` varchar(2) DEFAULT NULL,
  `cont_name` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `country`
--


--
-- Table structure for table `country_tbl`
--

CREATE TABLE `country_tbl` (
  `slno` int(6) NOT NULL AUTO_INCREMENT,
  `countryCode` varchar(2) DEFAULT NULL,
  `countryName` varchar(40) DEFAULT NULL,
  `countryFlag` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `country_tbl`
--


--
-- Table structure for table `coupon_tbl`
--

CREATE TABLE `coupon_tbl` (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_title` varchar(1000) NOT NULL DEFAULT '',
  `coupon_desc` varchar(1000) NOT NULL DEFAULT '',
  `coupon_date` date NOT NULL DEFAULT '0000-00-00',
  `coupon_status` char(1) NOT NULL DEFAULT 'N',
  `coupon_cat` varchar(100) NOT NULL,
  `coupon_subcat` varchar(100) NOT NULL,
  `coupon_type` varchar(100) NOT NULL,
  `coupon_link` varchar(600) NOT NULL,
  `coupon_exdate` date NOT NULL,
  `coupon_brand` varchar(100) NOT NULL,
  `coupon_code` varchar(500) NOT NULL,
  PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `coupon_tbl`
--


--
-- Table structure for table `faq_tbl`
--

CREATE TABLE `faq_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `answer` longtext NOT NULL,
  `recvDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `faqOrder` int(11) NOT NULL DEFAULT '0',
  `status` varchar(30) NOT NULL DEFAULT '1',
  `category_id` varchar(30) DEFAULT '0',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faq_tbl`
--


--
-- Table structure for table `gallery_tbl`
--

CREATE TABLE `gallery_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(400) DEFAULT NULL,
  `gallery_order` int(11) NOT NULL DEFAULT '0',
  `gcat_id` varchar(250) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=270 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gallery_tbl`
--

INSERT INTO `gallery_tbl` VALUES (45,'Food and Dining W. John Multipurpose Boarding School','gallery_2211100422.jpg','','Food and Dining 1',36,'18',NULL),(46,'Food and Dining W. John Multipurpose Boarding School','gallery_2211100526.jpg','','Food and Dining 2',37,'18',NULL),(47,'Food and Dining W. John Multipurpose Boarding School','gallery_2211100640.jpg','','Food and Dining 3',38,'18',NULL),(48,'Food and Dining W. John Multipurpose Boarding School','gallery_2211100737.jpg','','Food and Dining 4',39,'18',NULL),(49,'Food and Dining W. John Multipurpose Boarding School','gallery_2211100933.jpg','','Food and Dining 5',40,'18',NULL),(50,'Food and Dining W. John Multipurpose Boarding School','gallery_2211101022.jpg','','Food and Dining 6',41,'18',NULL),(51,'Food and Dining W. John Multipurpose Boarding School','gallery_2211101256.jpg','','Food and Dining 7',42,'18',NULL),(52,'Food and Dining W. John Multipurpose Boarding School','gallery_2211101741.jpg','','Food and Dining 8',43,'18',NULL),(53,'Food and Dining W. John Multipurpose Boarding School','gallery_2211101852.jpg','','Food and Dining 9',44,'18',NULL),(54,'Food and Dining W. John Multipurpose Boarding School','gallery_2211103400.jpg','','Food and Dining 10',45,'18',NULL),(55,'Food and Dining W. John Multipurpose Boarding School','gallery_2211103551.jpg','','Food and Dining 11',46,'18',NULL),(56,'Food and Dining W. John Multipurpose Boarding School','gallery_2211103628.jpg','','Food and Dining 12',47,'18',NULL),(57,'Girls Hostel W. John Multipurpose Boarding School','gallery_2211103927.jpg','','Girls Hostel WJMBS 1',48,'15',NULL),(58,'Girls Hostel W. John Multipurpose Boarding School','gallery_2211104035.jpg','','Girls Hostel WJMBS 1',49,'15',NULL),(59,'Girls Hostel W. John Multipurpose Boarding School','gallery_2211104106.jpg','','Girls Hostel WJMBS 1',50,'15',NULL),(60,'Girls Hostel W. John Multipurpose Boarding School','gallery_2211104139.jpg','','Girls Hostel WJMBS 4',51,'15',NULL),(61,'Girls Hostel W. John Multipurpose Boarding School','gallery_2211104158.jpg','','Girls Hostel WJMBS 5',52,'15',NULL),(62,'Girls Hostel W. John Multipurpose Boarding School','gallery_2211104222.jpg','','Girls Hostel WJMBS 6',53,'15',NULL),(63,'Girls Hostel W. John Multipurpose Boarding School','gallery_2211104250.jpg','','Girls Hostel WJMBS 7',54,'15',NULL),(64,'Girls Hostel W. John Multipurpose Boarding School','gallery_2211104347.jpg','','Girls Hostel WJMBS 8',55,'15',NULL),(65,'Girls Hostel W. John Multipurpose Boarding School','gallery_2211104434.jpg','','Girls Hostel WJMBS 9',56,'15',NULL),(66,'Girls Hostel W. John Multipurpose Boarding School','gallery_2211104454.jpg','','Girls Hostel WJMBS 10',57,'15',NULL),(67,'Girls Hostel W. John Multipurpose Boarding School','gallery_2211104537.jpg','','Girls Hostel WJMBS 11',58,'15',NULL),(68,'Boys Hostel W. John Multipurpose Boarding School','gallery_2211104709.jpg','','Boys Hostel WJMBS',59,'15',NULL),(70,'Boys Hostel W. John Multipurpose Boarding School','gallery_2211104819.jpg','','Boys Hostel WJMBS 3',61,'15',NULL),(71,'Boys Hostel W. John Multipurpose Boarding School','gallery_2211105111.jpg','','Boys Hostel WJMBS 4',62,'15',NULL),(72,'Boys Hostel W. John Multipurpose Boarding School','gallery_2211105139.jpg','','Boys Hostel WJMBS 5',63,'15',NULL),(73,'Boys Hostel W. John Multipurpose Boarding School','gallery_2211105226.jpg','','Boys Hostel WJMBS 6',64,'15',NULL),(74,'Boys Hostel W. John Multipurpose Boarding School','gallery_2211105523.jpg','','Boys Hostel WJMBS 7',65,'15',NULL),(75,'Boys Hostel W. John Multipurpose Boarding School','gallery_2211105604.jpg','','Boys Hostel WJMBS 8',66,'15',NULL),(76,'Boys Hostel W. John Multipurpose Boarding School','gallery_2211105712.jpg','','Boys Hostel WJMBS 9',67,'15',NULL),(77,'W John Multipurpose Boarding School','gallery_2212061942.jpg','','Award and Achievement',68,'10',NULL),(78,'W John Multipurpose Boarding School','gallery_2212062020.jpg','','Award and Achievement 2',69,'10',NULL),(79,'W John Multipurpose Boarding School','gallery_2212062052.jpg','','Award and Achievement 3',70,'10',NULL),(80,'W John Multipurpose Boarding School	','gallery_2212062133.jpg','','Award and Achievement 4',71,'10',NULL),(81,'W John Multipurpose Boarding School	','gallery_2212062238.jpg','','Award and Achievement 5',72,'10',NULL),(113,'Alfa Jyoti Khalkho','','','Alfa Jyoti Khalkho',104,NULL,NULL),(116,'Alfa Jyoti Khalkho','gallery_2402061527.jpg','','Alfa Jyoti Khalkho',106,'7',NULL),(117,'Alma Minz','gallery_2402061700.jpg','','Alma Minz',107,'7',NULL),(119,'Amit Khalkho','gallery_2402062154.jpg','','Amit Khalkho',109,'7',NULL),(120,'Anita Tirkey','gallery_2402062633.jpg','','Anita Tirkey',110,'7',NULL),(121,'Bikas Toppo','gallery_2402062719.jpg','','Bikas Toppo',111,'7',NULL),(122,'Brajesh Mahto','gallery_2402062750.jpg','','Brajesh Mahto',112,'7',NULL),(123,'Dr. Sudarshan David Ekka','gallery_2402062926.jpg','','Dr. Sudarshan David Ekka',113,'7',NULL),(125,'Jitendra Kumar Ram','gallery_2402063418.jpg','','Jitendra Kumar Ram',115,'7',NULL),(126,'Jyoti Rosaliya Bihan','gallery_2402063605.jpg','','Jyoti Rosaliya Bihan',116,'7',NULL),(128,'Niman Jhariy Lakra','gallery_2402063834.jpg','','Niman Jhariy Lakra',118,'7',NULL),(129,'Nirmal Lakra','gallery_2402064021.jpg','','Nirmal Lakra',119,'7',NULL),(130,'Pramod Kumar Mahto','gallery_2402064111.jpg','','Pramod Kumar Mahto',120,'7',NULL),(131,'Punam Devi','gallery_2402064243.jpg','','Punam Devi',121,'7',NULL),(132,'Rajiv Choudhary','gallery_2402064317.jpg','','Rajiv Choudhary',122,'7',NULL),(133,'Ravi Emmanuel Kujur','gallery_2402064436.jpg','','Ravi Emmanuel Kujur',123,'7',NULL),(134,'Santosh Oraon','gallery_2402064517.jpg','','Santosh Oraon',124,'7',NULL),(135,'Seema Santoshi Khalkho','gallery_2402064558.jpg','','Seema Santoshi Khalkho',125,'7',NULL),(136,'Shanti Bajra','gallery_2402064641.jpg','','Shanti Bajra',126,'7',NULL),(137,'Sushila Minz','gallery_2402064752.jpg','','Sushila Minz',127,'7',NULL),(138,'Swarnlata Tigga','gallery_2402064840.jpg','','Swarnlata Tigga',128,'7',NULL),(140,'Uttam Asnupam Ekka','gallery_2402065010.jpg','','Uttam Asnupam Ekka',130,'7',NULL),(141,'School Bus','gallery_2402065229.jpg','','School Bus',131,'17',NULL),(142,'School Bus','gallery_2402065301.jpg','','School Bus',132,'17',NULL),(143,'School Bus','gallery_2402125757.jpg','','School Bus',133,'17',NULL),(144,'School Bus','gallery_2402103505.jpg','','School Bus',134,'17',NULL),(145,'School Bus','gallery_2402065436.jpg','','School Bus',135,'17',NULL),(146,'School Bus','gallery_2402103815.jpg','','School Bus',136,'17',NULL),(147,'School Bus','gallery_2402065509.jpg','','School Bus',137,'17',NULL),(148,'School Bus','gallery_2402065551.jpg','','School Bus',138,'17',NULL),(149,'Sports Day 2023','gallery_2402065812.jpg','','Sports Day',139,'2',2),(150,'Sports Day 2023','gallery_2402070732.jpg','','Sports Day',140,'',2),(151,'Sports Day 2023','gallery_2402070811.jpg','','Sports Day',141,'',2),(152,'Sports Day 2023','gallery_2402070853.jpg','','Sports Day',142,'',2),(153,'Sports Day 2023','gallery_2402070912.jpg','','Sports Day',143,'',2),(154,'Sports Day 2023','gallery_2402070933.jpg','','Sports Day',144,'',2),(155,'Sports Day 2023','gallery_2402070953.jpg','','Sports Day',145,'',2),(156,'Sports Day 2023','gallery_2402071033.jpg','','Sports Day',146,'',2),(157,'Sports Day 2023','gallery_2402071100.jpg','','Sports Day',147,'',2),(158,'Sports Day 2023','gallery_2402071137.jpg','','Sports Day',148,'',2),(159,'Sports Day 2023','gallery_2402071159.jpg','','Sports Day',149,'',2),(160,'Sports Day 2023','gallery_2402071227.jpg','','Sports Day',150,'',2),(162,'Swachta Pakhwada','gallery_2402074005.jpg','','Swachta Pakhwada',151,'6',NULL),(163,'Swachta Pakhwada','gallery_2402074034.jpg','','Swachta Pakhwada',152,'6',NULL),(164,'Swachta Pakhwada','gallery_2402074050.jpg','','Swachta Pakhwada',153,'6',NULL),(165,'Swachta Pakhwada','gallery_2402074112.jpg','','Swachta Pakhwada',154,'6',NULL),(166,'Swachta Pakhwada','gallery_2402074136.jpg','','Swachta Pakhwada',155,'6',NULL),(167,'Swachta Pakhwada','gallery_2402074152.jpg','','Swachta Pakhwada',156,'6',NULL),(168,'Swachta Pakhwada','gallery_2402074239.jpg','','Swachta Pakhwada',157,'6',NULL),(169,'Swachta Pakhwada','gallery_2402074300.jpg','','Swachta Pakhwada',158,'6',NULL),(170,'Swachta Pakhwada','gallery_2402074351.jpg','','Swachta Pakhwada',159,'6',NULL),(173,'Swachta Pakhwada','gallery_2402074610.jpg','','Swachta Pakhwada',160,'6',NULL),(174,'Swachta Pakhwada','gallery_2402074634.jpg','','Swachta Pakhwada',161,'6',NULL),(175,'Swachta Pakhwada','gallery_2402074715.jpg','','Swachta Pakhwada',162,'6',NULL),(176,'Swachta Pakhwada','gallery_2402074752.jpg','','Swachta Pakhwada',163,'6',NULL),(177,'Swachta Pakhwada','gallery_2402074813.jpg','','Swachta Pakhwada',164,'6',NULL),(178,'Swachta Pakhwada','gallery_2402074844.jpg','','Swachta Pakhwada',165,'6',NULL),(179,'Swachta Pakhwada','gallery_2402074902.jpg','','Swachta Pakhwada',166,'6',NULL),(180,'Carrom & Chess competition','gallery_2402075118.jpg','','Carrom & Chess competition',167,'6',NULL),(181,'Carrom & Chess competition','gallery_2402075144.jpg','','Carrom & Chess competition',168,'6',NULL),(182,'Carrom & Chess Competition','gallery_2402075529.jpg','','Carrom & Chess Competition',169,'6',NULL),(183,'Carrom & Chess Competition','gallery_2402075602.jpg','','Carrom & Chess Competition',170,'6',NULL),(184,'Carrom & Chess Competition','gallery_2402075620.jpg','','Carrom & Chess Competition',171,'6',NULL),(185,'Carrom & Chess Competition','gallery_2402075647.jpg','','Carrom & Chess Competition',172,'6',NULL),(187,'Carrom & Chess Competition','gallery_2402075754.jpg','','Carrom & Chess Competition',173,'6',NULL),(188,'Carrom & Chess Competition','gallery_2402075811.jpg','','Carrom & Chess Competition',174,'6',NULL),(189,'Carrom & Chess Competition','gallery_2402075837.jpg','','Carrom & Chess Competition',175,'6',NULL),(190,'Carrom & Chess Competition','gallery_2402075851.jpg','','Carrom & Chess Competition',176,'6',NULL),(191,'Carrom & Chess Competition','gallery_2402075919.jpg','','Carrom & Chess Competition',177,'6',NULL),(192,'Carrom & Chess Competition','gallery_2402075952.jpg','','Carrom & Chess Competition',178,'6',NULL),(193,'Carrom & Chess Competition','gallery_2402080006.jpg','','Carrom & Chess Competition',179,'6',NULL),(194,'Carrom & Chess Competition','gallery_2402080026.jpg','','Carrom & Chess Competition',180,'6',NULL),(195,'Carrom & Chess Competition','gallery_2402083319.jpg','','Carrom & Chess Competition',181,'6',NULL),(196,'Carrom & Chess Competition','gallery_2402083336.jpg','','Carrom & Chess Competition',182,'6',NULL),(197,'Carrom & Chess Competition','gallery_2402083646.jpg','','Carrom & Chess Competition',183,'6',NULL),(198,'Carrom & Chess Competition','gallery_2402083725.jpg','','Carrom & Chess Competition',184,'6',NULL),(199,'Carrom & Chess Competition','gallery_2402083911.jpg','','Carrom & Chess Competition',185,'6',NULL),(200,'Essay & Drawing Competition','gallery_2402084246.jpg','','Essay & Drawing Competition',186,'6',NULL),(201,'Essay & Drawing Competition','gallery_2402084303.jpg','','Essay & Drawing Competition',187,'6',NULL),(202,'Essay & Drawing Competition','gallery_2402084347.jpg','','Essay & Drawing Competition',188,'6',NULL),(203,'Essay & Drawing Competition','gallery_2402084411.jpg','','Essay & Drawing Competition',189,'6',NULL),(204,'Essay & Drawing Competition','gallery_2402084446.jpg','','Essay & Drawing Competition',190,'6',NULL),(205,'Essay & Drawing Competition','gallery_2402084508.jpg','','Essay & Drawing Competition',191,'6',NULL),(206,'Essay & Drawing Competition','gallery_2402084555.jpg','','Essay & Drawing Competition',192,'6',NULL),(207,'Essay & Drawing Competition','gallery_2402084618.jpg','','Essay & Drawing Competition',193,'6',NULL),(208,'Essay & Drawing Competition','gallery_2402084641.jpg','','Essay & Drawing Competition',194,'6',NULL),(209,'Essay & Drawing Competition','gallery_2402084702.jpg','','Essay & Drawing Competition',195,'6',NULL),(210,'Essay & Drawing Competition','gallery_2402084751.jpg','','Essay & Drawing Competition',196,'6',NULL),(211,'Essay & Drawing Competition','gallery_2402084808.jpg','','Essay & Drawing Competition',197,'6',NULL),(212,'Essay & Drawing Competition','gallery_2402084834.jpg','','Essay & Drawing Competition',198,'6',NULL),(213,'Essay & Drawing Competition','gallery_2402084911.jpg','','Essay & Drawing Competition',199,'6',NULL),(214,'Essay & Drawing Competition','gallery_2402084928.jpg','','Essay & Drawing Competition',200,'6',NULL),(215,'Hostel Dean Group','gallery_2402085218.jpg','','Hostel Dean Group',201,'15',NULL),(219,'Cicilia Tirkey','gallery_2402064829.jpg','','Cicilia Tirkey',203,'7',NULL),(220,'Support Staff','gallery_2402044329.jpg','','Support Staff',204,'8',NULL),(221,'School Trips and Excursion','gallery_2402070129.jpg','','School Trips and Excursion',205,'',4),(222,'School Trips and Excursion','gallery_2402070221.jpg','','School Trips and Excursion',206,'',4),(224,'School Trips and Excursion','gallery_2402070335.jpg','','School Trips and Excursion',208,'',4),(225,'Music and Dance','gallery_2402071045.JPG','','Music and Dance',209,'',3),(226,'Music and Dance','gallery_2402071115.JPG','','Music and Dance',210,'',3),(227,'Music and Dance','gallery_2402071216.JPG','','Music and Dance',211,'',3),(228,'Music and Dance','gallery_2402071233.JPG','','Music and Dance',212,'',3),(229,'Music and Dance','gallery_2402071254.JPG','','Music and Dance',213,'',3),(230,'Music and Dance','gallery_2402071308.JPG','','Music and Dance',214,'',3),(231,'Music and Dance','gallery_2402071325.JPG','','Music and Dance',215,'',3),(244,'Music and Dance','gallery_2402091106.JPG','','Music and Dance',216,'',3),(246,'School Band','gallery_2402091538.JPG','','School Band',218,'',6),(247,'Music and Dance','gallery_2402095615.jpg','','Music and Dance',219,'',3),(248,'Music and Dance','gallery_2402095705.jpg','','Music and Dance',220,'',3),(249,'Music and Dance','gallery_2402095739.jpg','','Music and Dance',221,'',3),(250,'Music and Dance','gallery_2402095830.jpg','','Music and Dance',222,'',3),(251,'Science & Art Exhibition','gallery_2402084009.jpg','','Science & Art Exhibition',223,'',5),(252,'Science & Art Exhibition','gallery_2402084313.jpg','','Science & Art Exhibition',224,'',5),(253,'Science & Art Exhibition','gallery_2402084619.jpg','','Science & Art Exhibition',225,'',5),(254,'Science & Art Exhibition','gallery_2402084727.jpg','','Science & Art Exhibition',226,'',5),(255,'Science & Art Exhibition','gallery_2402084803.jpg','','Science & Art Exhibition',227,'',5),(256,'Science & Art Exhibition','gallery_2402085626.jpg','','Science & Art Exhibition',228,'',5),(257,'Science & Art Exhibition','gallery_2402085829.jpg','','Science & Art Exhibition',229,'',5),(258,'Science & Art Exhibition','gallery_2402085924.jpg','','Science & Art Exhibition',230,'',5),(259,'Science & Art Exhibition','gallery_2402090019.jpg','','Science & Art Exhibition',231,'',5),(260,'Science & Art Exhibition','gallery_2402090141.jpg','','Science & Art Exhibition',232,'',5),(261,'Science & Art Exhibition','gallery_2402090216.jpg','','Science & Art Exhibition',233,'',5),(262,'Science & Art Exhibition','gallery_2402090306.jpg','','Science & Art Exhibition',234,'',5),(263,'Science & Art Exhibition','gallery_2402090413.jpg','','Science & Art Exhibition',235,'',5),(264,'Science & Art Exhibition','gallery_2402090455.jpg','','Science & Art Exhibition',236,'',5),(265,'Science & Art Exhibition','gallery_2402090601.jpg','','Science & Art Exhibition',237,'',5),(266,'Science & Art Exhibition','gallery_2402090659.jpg','','Science & Art Exhibition',238,'',5),(267,'Science & Art Exhibition','gallery_2402090754.jpg','','Science & Art Exhibition',239,'',5),(268,'Science & Art Exhibition','gallery_2402090828.jpg','','Science & Art Exhibition',240,'',5),(269,'Science & Art Exhibition','gallery_2402090903.jpg','','Science & Art Exhibition',241,'',5);

--
-- Table structure for table `homepage_pointer`
--

CREATE TABLE `homepage_pointer` (
  `slno` int(10) NOT NULL AUTO_INCREMENT,
  `web_type` enum('0','1') NOT NULL DEFAULT '1' COMMENT '0= Hide factsheet, 1 = show Factsheet',
  `title1` varchar(255) DEFAULT NULL,
  `description1` varchar(500) DEFAULT NULL,
  `title2` varchar(255) DEFAULT NULL,
  `description2` varchar(500) DEFAULT NULL,
  `title3` varchar(255) DEFAULT NULL,
  `description3` varchar(500) DEFAULT NULL,
  `title4` varchar(255) DEFAULT NULL,
  `description4` varchar(500) DEFAULT NULL,
  `title5` varchar(255) DEFAULT NULL,
  `description5` varchar(500) DEFAULT NULL,
  `title6` varchar(255) DEFAULT NULL,
  `description6` varchar(500) DEFAULT NULL,
  `title7` varchar(255) DEFAULT NULL,
  `description7` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `homepage_pointer`
--


--
-- Table structure for table `hotproduct_pages`
--

CREATE TABLE `hotproduct_pages` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `hotKeyword1` varchar(500) NOT NULL,
  `hotKeyword2` varchar(500) NOT NULL,
  `hotKeyword3` varchar(500) NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hotproduct_pages`
--


--
-- Table structure for table `location_content_tbl`
--

CREATE TABLE `location_content_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` varchar(20) DEFAULT NULL,
  `category_id` varchar(20) DEFAULT NULL,
  `meta_title` varchar(300) DEFAULT NULL,
  `meta_description` text,
  `meta_keyword` text,
  `description` text,
  `short_description` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `location_content_tbl`
--


--
-- Table structure for table `location_tbl`
--

CREATE TABLE `location_tbl` (
  `locationID` int(11) NOT NULL AUTO_INCREMENT,
  `locationType` varchar(11) DEFAULT NULL,
  `locationurl` varchar(100) DEFAULT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `locationName` varchar(800) DEFAULT NULL,
  `locationtDesc` text,
  `locationDesc1` text,
  `locationImage` varchar(50) DEFAULT NULL,
  `toplocation` char(1) NOT NULL DEFAULT 'N',
  `locationOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) DEFAULT NULL,
  `pageKeywords` text,
  `pageDescription` text,
  `pageTitle1` varchar(250) DEFAULT NULL,
  `pageDescription1` text,
  `pageKeywords1` text,
  `locationPosition` int(11) NOT NULL DEFAULT '0',
  `locationIcon` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`locationID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `location_tbl`
--


--
-- Table structure for table `logfile`
--

CREATE TABLE `logfile` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `newsletter` text NOT NULL,
  `subject` text NOT NULL,
  `newsletterOther` text NOT NULL,
  `subjectOther` text NOT NULL,
  `flash_banner` varchar(50) NOT NULL DEFAULT '',
  `shippingPrice` float NOT NULL DEFAULT '0',
  `vat` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logfile`
--


--
-- Table structure for table `mailer_list`
--

CREATE TABLE `mailer_list` (
  `mailer_id` int(10) NOT NULL AUTO_INCREMENT,
  `mailer_title` varchar(200) NOT NULL,
  `mailer_reply` varchar(200) NOT NULL,
  `mailer_code` text NOT NULL,
  `message` varchar(500) NOT NULL,
  `country` varchar(100) NOT NULL,
  `memberType` varchar(10) NOT NULL,
  `keyword` varchar(100) NOT NULL,
  `databasestatus` varchar(10) NOT NULL,
  `status` varchar(1) NOT NULL,
  PRIMARY KEY (`mailer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mailer_list`
--


--
-- Table structure for table `mass_mail`
--

CREATE TABLE `mass_mail` (
  `mailID` int(20) NOT NULL AUTO_INCREMENT,
  `mailerID` varchar(15) NOT NULL,
  `email` varchar(100) NOT NULL,
  `companyName` varchar(150) NOT NULL,
  `memberName` varchar(150) NOT NULL,
  `memberID` varchar(50) NOT NULL,
  `status` varchar(1) NOT NULL,
  PRIMARY KEY (`mailID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mass_mail`
--


--
-- Table structure for table `media_tbl`
--

CREATE TABLE `media_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(400) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `media_tbl`
--


--
-- Table structure for table `newsletter_member`
--

CREATE TABLE `newsletter_member` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `snewsletter` char(1) NOT NULL DEFAULT 'N',
  `cnewsletter` char(1) NOT NULL DEFAULT 'N',
  `mType` char(1) NOT NULL DEFAULT 'B',
  `join_date` date NOT NULL DEFAULT '0000-00-00',
  `status` char(2) NOT NULL DEFAULT 'Y',
  `mail_status` char(2) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `newsletter_member`
--


--
-- Table structure for table `notice_tbl`
--

CREATE TABLE `notice_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `notice_title` varchar(100) NOT NULL,
  `notice_desc` varchar(500) NOT NULL,
  `user` varchar(10) NOT NULL,
  `noticedate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sort_order` varchar(10) DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notice_tbl`
--

INSERT INTO `notice_tbl` VALUES (1,'Christmas Message by Principal','W. John Multi Purpose school','Admin','2022-05-17 23:30:15','0',1);

--
-- Table structure for table `procategory_tbl`
--

CREATE TABLE `procategory_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `catDesc` text NOT NULL,
  `catDesc1` text NOT NULL,
  `catImage` varchar(50) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  `pageTitle1` varchar(250) NOT NULL,
  `pageDescription1` text NOT NULL,
  `pageKeywords1` text NOT NULL,
  `footerContent` text NOT NULL,
  `catalogImage` varchar(500) NOT NULL,
  `catalogLink` varchar(600) NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `procategory_tbl`
--


--
-- Table structure for table `product_tbl`
--

CREATE TABLE `product_tbl` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_title` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_code` varchar(700) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_image` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_image1` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_image2` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_image3` varchar(500) CHARACTER SET utf16 COLLATE utf16_unicode_ci DEFAULT NULL,
  `product_alt` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_desc` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_metatitle` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_metadesc` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_metakeyword` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_cat` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `prodcut_subcat` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_subsubcat` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_specfi` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_video` varchar(150) DEFAULT NULL,
  `product_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `product_status` int(11) NOT NULL DEFAULT '1',
  `product_finalcat` varchar(600) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_min_order` varchar(400) DEFAULT NULL,
  `product_supply` varchar(600) DEFAULT NULL,
  `product_origin` varchar(600) DEFAULT NULL,
  `product_pterms` varchar(600) DEFAULT NULL,
  `product_price` varchar(600) DEFAULT NULL,
  `product_swearType` varchar(100) DEFAULT NULL,
  `product_supplyType` varchar(100) DEFAULT NULL,
  `product_Gender` varchar(100) DEFAULT NULL,
  `product_ageGroup` varchar(100) DEFAULT NULL,
  `product_size` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_tbl`
--


--
-- Table structure for table `productgallery_tbl`
--

CREATE TABLE `productgallery_tbl` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_title` varchar(800) NOT NULL,
  `product_code` varchar(700) NOT NULL,
  `product_image` varchar(500) NOT NULL,
  `product_alt` varchar(500) NOT NULL,
  `product_desc` text NOT NULL,
  `product_metatitle` varchar(300) NOT NULL,
  `product_metadesc` varchar(800) NOT NULL,
  `product_metakeyword` varchar(800) NOT NULL,
  `product_cat` varchar(400) NOT NULL,
  `prodcut_subcat` varchar(400) NOT NULL,
  `product_subsubcat` varchar(400) NOT NULL,
  `product_date` varchar(400) NOT NULL,
  `prodcut_status` int(11) NOT NULL DEFAULT '0',
  `product_finalcat` varchar(600) NOT NULL,
  `product_min_order` varchar(400) NOT NULL,
  `product_supply` varchar(600) NOT NULL,
  `product_origin` varchar(600) NOT NULL,
  `product_pterms` varchar(600) NOT NULL,
  `product_price` varchar(600) NOT NULL,
  `product_swearType` varchar(100) NOT NULL,
  `product_supplyType` varchar(100) NOT NULL,
  `product_Gender` varchar(100) NOT NULL,
  `product_ageGroup` varchar(100) NOT NULL,
  `product_size` varchar(100) NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productgallery_tbl`
--


--
-- Table structure for table `register_student`
--

CREATE TABLE `register_student` (
  `std_id` int(11) NOT NULL AUTO_INCREMENT,
  `std_name` varchar(100) NOT NULL,
  `std_parent` varchar(100) NOT NULL,
  `std_email` varchar(100) NOT NULL,
  `std_phone` int(15) NOT NULL,
  `std_class` varchar(15) NOT NULL,
  `std_address` varchar(200) NOT NULL,
  `fee_amount` int(100) NOT NULL,
  `txnId` varchar(200) NOT NULL,
  `payment_status` varchar(100) NOT NULL DEFAULT 'Pending',
  `payment_response` varchar(1000) DEFAULT NULL,
  `payment_mode` varchar(20) DEFAULT NULL,
  `payment_date` varchar(20) DEFAULT NULL,
  `rec_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`std_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `register_student`
--

INSERT INTO `register_student` VALUES (1,'Neeraj Prajapati','Ramesh Chand','neerajprajapati0909@gmail.com',2147483647,'STD-VIII','delhi',20300,'WJS0795424','Paid','pgRespCode=0000&PGTxnNo=sp26710652407313&SabPaisaTxId=314940401231246695&issuerRefNo=sp42555149756835&authIdCode=0&amount=20563.5&clientTxnId=WJS0795424&firstName=Neeraj Prajapati&lastName=&payMode=Credit Card&email=neerajprajapati0909@gmail.com&mobileNo=7455987808&spRespCode=0000&cid=NA&bid=NA&clientCode=NITE5&payeeProfile=null&transDate=2023-01-04 12:43:25.0&spRespStatus=SUCCESS&m3=NA&challanNo=null&reMsg=Your Transaction is Complete&orgTxnAmount=20300.0&programId=NITE5&midName=NA&Add=delhi&param1=NA&param2=NA&param3=NA&param4=NA&udf5=NA&udf6=STD-VIII&udf7=NA&udf8=NA&udf9=null&udf10=null&udf11=null&udf12=null&udf13=null&udf14=null&udf15=null&udf16=null&udf17=null&udf18=null&udf19=null&udf20=null','Credit Card','2023-01-04 12:43:25.','2023-01-04 02:05:08'),(2,'Test  A','P A','test@gmail.com',2147483647,'STD-IX','new address',40300,'WJS0561210','Failed','pgRespCode=0300&PGTxnNo=sp71902636709186&SabPaisaTxId=247100401230148558&issuerRefNo=sp66393386644819&authIdCode=0&amount=40823.1&clientTxnId=WJS0561210&firstName=Test  A&lastName=&payMode=Credit Card&email=test@gmail.com&mobileNo=7455987808&spRespCode=0300&cid=NA&bid=NA&clientCode=NITE5&payeeProfile=null&transDate=2023-01-04 13:09:48.0&spRespStatus=FAILED&m3=NA&challanNo=null&reMsg=Sorry, Your Transaction has Failed.&orgTxnAmount=40300.0&programId=NITE5&midName=NA&Add=new address&param1=NA&param2=NA&param3=NA&param4=NA&udf5=NA&udf6=STD-IX&udf7=NA&udf8=NA&udf9=null&udf10=null&udf11=null&udf12=null&udf13=null&udf14=null&udf15=null&udf16=null&udf17=null&udf18=null&udf19=null&udf20=null','Credit Card','2023-01-04 13:09:48.','2023-01-04 02:39:26'),(3,'Madhu Ranjan','Pushpalal singh','test@webpulse.com',1234567890,'STD-VII','delhi',1,'WJS0112266','Paid','pgRespCode=0000&PGTxnNo=sp6286318406146&SabPaisaTxId=093830401230170978&issuerRefNo=sp49318123366138&authIdCode=0&amount=1.02&clientTxnId=WJS0112266&firstName=Madhu Ranjan&lastName=&payMode=Debit Card&email=test@webpulse.com&mobileNo=1234567890&spRespCode=0000&cid=NA&bid=NA&clientCode=NITE5&payeeProfile=null&transDate=2023-01-04 13:30:39.0&spRespStatus=SUCCESS&m3=NA&challanNo=null&reMsg=Your Transaction is Complete&orgTxnAmount=1.0&programId=NITE5&midName=NA&Add=delhi&param1=NA&param2=NA&param3=NA&param4=NA&udf5=NA&udf6=STD-VII&udf7=NA&udf8=NA&udf9=null&udf10=null&udf11=null&udf12=null&udf13=null&udf14=null&udf15=null&udf16=null&udf17=null&udf18=null&udf19=null&udf20=null','Credit Card','2023-01-04 13:30:39.','2023-01-04 02:58:43'),(13,'date','date','date@gmail.com',2147483647,'NUR','delhi',40300,'WJS0970557','Failed','!%\0<VW{wPGTxnNo=055760401230587759&SabPaisaTxId=055760401230587759&issuerRefNo=101202300483976493&authIdCode=0&amount=40303.0&clientTxnId=WJS0970557&firstName=date&lastName=&payMode=UPI&email=date@gmail.com&mobileNo=4578457854&spRespCode=0300&cid=NA&bid=NA&clientCode=NITE5&payeeProfile=null&transDate=2023-01-04 17:04:55.0&spRespStatus=FAILED&m3=NA&challanNo=null&reMsg=upi is NOT CAPTURED  null&orgTxnAmount=40300.0&programId=NITE5&midName=NA&Add=delhi&param1=NA&param2=NA&param3=NA&param4=NA&udf5=NA&udf6=NUR&udf7=NA&udf8=NA&udf9=null&udf10=null&udf11=null&udf12=null&udf13=null&udf14=null&udf15=null&udf16=null&udf17=null&udf18=null&udf19=null&udf20=null','UPI','2023-01-04 17:04:55.','2023-01-04 06:34:38'),(14,'','','',0,'','',0,'WJS0753973','Pending',NULL,NULL,NULL,'2023-01-20 08:07:42'),(15,'','','',0,'','',0,'WJS0611531','Pending',NULL,NULL,NULL,'2023-01-20 21:48:54'),(16,'','','',0,'','',0,'WJS0773420','Pending',NULL,NULL,NULL,'2023-02-09 20:07:04'),(17,'','','',0,'','',0,'WJS0496654','Pending',NULL,NULL,NULL,'2023-02-25 02:01:00'),(18,'test','tet','test@gmail.com',854784578,'NUR','test',40300,'WJS0280213','Failed','!%\0<VWY=+]PGTxnNo=702180303230358670&SabPaisaTxId=702180303230358670&issuerRefNo=null&authIdCode=0&amount=40325.0&clientTxnId=WJS0280213&firstName=testNA&lastName=&payMode=CASH&email=test@gmail.com&mobileNo=854784578&spRespCode=0400&cid=NA&bid=NA&clientCode=NITE5&payeeProfile=null&transDate=2023-03-03 15:27:51.0&spRespStatus=CHALLAN_GENERATED&m3=NA&challanNo=BOI030323NITEA1125&reMsg=null&orgTxnAmount=40300.0&programId=NITE5&midName=NA&Add=test&param1=NA&param2=NA&param3=NA&param4=NA&udf5=NA&udf6=NUR&udf7=NA&udf8=NA&udf9=null&udf10=null&udf11=null&udf12=null&udf13=null&udf14=null&udf15=null&udf16=null&udf17=null&udf18=null&udf19=null&udf20=null','CASH','2023-03-03 15:27:51.','2023-03-03 04:57:32'),(19,'','','',0,'','',0,'WJS0129532','Pending',NULL,NULL,NULL,'2023-03-13 15:52:36'),(20,'t','t','t@gmail.com',2147483647,'STD-VII','a',20300,'WJS0297902','Pending',NULL,NULL,NULL,'2023-03-15 02:27:47'),(21,'','','',0,'','',0,'WJS0139995','Pending',NULL,NULL,NULL,'2023-03-30 11:27:21'),(22,'','','',0,'','',0,'WJS0426151','Pending',NULL,NULL,NULL,'2023-04-15 23:33:30'),(23,'','','',0,'','',0,'WJS0349755','Pending',NULL,NULL,NULL,'2023-05-29 04:10:17'),(24,'','','',0,'','',0,'WJS0311744','Pending',NULL,NULL,NULL,'2023-05-30 09:29:55'),(25,'t','t','t@gmail.com',2147483647,'NUR','delhi',40300,'WJS0576013','Pending',NULL,NULL,NULL,'2023-06-14 00:47:52'),(26,'n n',' mbm','n3253754854@gmail.com',1234567895,'NUR','mmn m',9630,'WJS0883456','Pending',NULL,NULL,NULL,'2023-07-17 00:52:53'),(27,'','','',0,'','',0,'WJS0151041','Pending',NULL,NULL,NULL,'2023-09-07 05:21:27'),(28,'','','',0,'','',0,'WJS0813889','Pending',NULL,NULL,NULL,'2023-10-13 05:47:37'),(29,'','','',0,'','',0,'WJS0172963','Pending',NULL,NULL,NULL,'2023-10-20 22:57:34'),(30,'','','',0,'','',0,'WJS0452656','Pending',NULL,NULL,NULL,'2023-11-18 22:05:50'),(31,'Manish Bachhuka','Manish Bachhuka','abc!@gmail.com',1234560789,'NUR','Jumri Taliya',1820,'WJS0125976','Pending',NULL,NULL,NULL,'2024-05-15 03:20:37');

--
-- Table structure for table `safe_business_tbl`
--

CREATE TABLE `safe_business_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `person_city` varchar(1000) DEFAULT NULL,
  `description` longtext NOT NULL,
  `sbtOrder` int(11) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `image` varchar(255) NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `safe_business_tbl`
--


--
-- Table structure for table `sponsor_banner_tbl`
--

CREATE TABLE `sponsor_banner_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `memberID` int(11) NOT NULL DEFAULT '0',
  `bannerPosition` varchar(50) NOT NULL,
  `bannerUrl` varchar(80) NOT NULL DEFAULT '',
  `bannerImage` varchar(50) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sponsor_banner_tbl`
--


--
-- Table structure for table `sponsor_tbl`
--

CREATE TABLE `sponsor_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `memberID` int(11) NOT NULL,
  `sponsoredCategories` varchar(250) NOT NULL,
  `sponsorDuration` int(11) NOT NULL,
  `sponsorStatus` char(1) NOT NULL DEFAULT 'N',
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  `recvDate` date NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sponsor_tbl`
--


--
-- Table structure for table `standard_meta_tags_pages`
--

CREATE TABLE `standard_meta_tags_pages` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `standard_meta_tags_pages`
--

INSERT INTO `standard_meta_tags_pages` VALUES (1,0,'',0,'Home','N',1,'Y','DC Power Supply Manufacturers in Thane, DC Power Suppliers in Mumbai','DC Power Supply','dc');

--
-- Table structure for table `static_pages`
--

CREATE TABLE `static_pages` (
  `pageID` int(11) NOT NULL AUTO_INCREMENT,
  `pageBanner` varchar(500) DEFAULT NULL,
  `pageImage` varchar(500) DEFAULT NULL,
  `pageTitle` varchar(255) NOT NULL DEFAULT '',
  `page_url` varchar(200) DEFAULT NULL,
  `pageDesc` text NOT NULL,
  `pageDesc1` longtext NOT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  `page_metatitle` varchar(500) NOT NULL,
  `page_keyword` varchar(500) NOT NULL,
  `page_metadesc` text NOT NULL,
  `name` varchar(500) DEFAULT NULL,
  `designation` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`pageID`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `static_pages`
--

INSERT INTO `static_pages` VALUES (1,NULL,NULL,'Home','home','<p>W. John Multipurpose Boarding School is the <strong>Best Boarding Schools in Ranchi</strong>, offering students a holistic environment and ample opportunities for their overall growth and development. Safe &amp; Secure Premises. Follows ICSE curriculum. ✓Boarding School ✓Secondary School ✓ Call at. Enroll Now!</p>\r\n\r\n<p>Welcome to W. John Multipurpose Boarding School, one of the prestigious and best boarding schools in Ranchi. Our vision is to make thousands of empowering students who will make big changes in the future. We never believe that only four corners of the classroom are enough for knowledge. Moreover, we offer a holistic environment and ample opportunities for the overall growth and development of our students.</p>\r\n\r\n<p>It is one of the <strong>Top Boarding School in Jharkhand</strong> and is known for its aspiring and excellent results over the years. Our school wants to paint 3&rsquo;A on every student note that is Aim, Action, and Achievement. The glorifying journey of our school started in 1990 as founder and director Dr. M P Ekka led the foundation stone of a prestigious boarding school in Ranchi. Our school is entitled and counted as a top leading boarding school most importantly, it is located at Piska Nagri, 15 Km west of Ranchi city on Ranchi-Mumbai National Highway Road No.- NH 23. Dr. Ekka is a generous person who believes education is a crucial aspect of the beautiful journey of enlightenment. Our campus retains a calm, peaceful, and pollution-free environment. And, in just a short span of years, we have established ourselves as a leading institution.</p>\r\n\r\n<p>W. John Multipurpose Boarding School&rsquo;s Principal Dr.(Mrs.) Suphal Ekka is a focused and ambiguous woman who is entitled to serve the best quality education to every student. The safest premises of the school campus offer the best learning atmosphere and modern equipment so that students can glorify their careers in both academics and co-curricular activities. Our school provides top-notch co-education and supports 10+2 education based on the ICSE curriculum. We have stretched our services in multifold including safety &amp; security, smart classes, furnished building, and ventilated classrooms. Moreover, we have well-organized management and a flock of experienced teachers who help every student to develop an analytical mindset so that they can make better career options in the future.</p>\r\n\r\n<p>The picturesque school surroundings include child-friendly environments that provide a separate section of co-curriculum activities such as sports, art &amp; craft, music, and dance. Here, every student develops a creative mind and enhances their growth every day.</p>\r\n','<p>Welcome to W. John Multipurpose Boarding School, one of the prestigious and best boarding schools in Ranchi. Our vision is to make thousands of empowering students who will make big changes in the future. We never believe that only four corners of the classroom are enough . Moreover, we offer a holistic environment and ample opportunities for the overall growth and development of our students.&nbsp;</p>\r\n\r\n<p>It is one of the <strong>Top Boarding School in Jharkhand</strong><strong> </strong>and is known for its aspiring and excellent results over the years. Our school wants to paint 3&rsquo;A on every student note that is Aim, Action, and Achievement. The glorifying journey of our school started in 1990 as founder and director Dr. M P Ekka led the foundation stone of a prestigious boarding school in Ranchi. Our school is entitled and counted as a top leading boarding school most importantly, it is located at Piska Nagri, 15 Km west of Ranchi city on Ranchi-Mumbai National Highway Road No.- NH 23. Dr. Ekka is a generous person who believes education is a crucial aspect of the beautiful journey of enlightenment. Our campus retains a calm, peaceful, and pollution-free environment. And, in just a short span of years, we have established ourselves as a leading institution.&nbsp;</p>\r\n\r\n<p>W. John Principal Dr.(Mrs.) Suphal Ekka is a focused and ambiguous woman who is entitled to serve the best quality education to every student. The safest premises of the school campus offer the best learning atmosphere and modern equipment so that students can glorify their career in both academics and co-curricular activities. Our school provides top-notch co-education and supports 10+2 education based on the ICSE curriculum. We have stretched our services in multifold including safety &amp; security, smart classes, furnished building, and ventilated classrooms. Moreover, we have well-organized management and a flock of experienced teachers who help every student to develop an analytical mindset and make better career options for their future.&nbsp;</p>\r\n','Y','Best Boarding Schools in Ranchi, Top Boarding School in Jharkhand','Best Boarding Schools in Ranchi, Top Boarding School in Jharkhand, Boarding Schools in Ranchi','W. John Multipurpose Boarding School is the Best Boarding School in Ranchi, offering students a holistic environment and ample opportunities for their overall growth and development. Safe & Secure Premises. Follows ICSE curriculum. ✓Boarding School ✓Secondary School ✓  Enroll Now!','  ','  '),(2,NULL,'image31.jpg','About Us','about-us','<p>W. John Multipurpose Boarding School was established in 1990 under the guidance of generous personality Dr. M.P Ekka. With a pioneering experience, we came up with the <strong>Top 5 Boarding Schools In Ranchi</strong>. Our school is based on co-ed education and follows the ICSE curriculum. The prestigious Bahuddesiya Samaj Seva Sanstha is one of the apex bodies of our school. In just a short period we have established our institution as leading and providing the safest and most peaceful environment with pollution-free surroundings.&nbsp;</p>\r\n\r\n<p>Our school is truly affiliated with the council for the Indian School Certificate Examination, New Delhi. The school curriculum provides teaching methodology based on the latest technology and supports trends in the education system so that students glance over a bunch of opportunities that are leading in their path to success. Moreover, we have all the top-notch facilities including well-structured and organized building addition fully ventilated with adequate natural lights. Apart from outstanding academic records, we also provide a flock of co-curriculum activities such as sports, games, culture, art &amp; craft, and music and dance. Furthermore, we have made smart classes where teachers can work on the practicality of education. In addition, this helps in building overall development and helps students to understand the core objective of education.</p>\r\n\r\n<p>Our school is dedicated to serving the best facilities for the future of our nation. We aim to serve a stress-free learning environment that encourages creativity and critical thinking. And, we believe that the parents of every student are also dedicated to covering the beautiful roadmap of education.</p>\r\n','','Y','Top 5 Boarding Schools in Ranchi | W. John Multipurpose Boarding School','Top 5 Boarding Schools in Ranchi, Top 5 Boarding Schools in Jharkhand, Boarding School in Ranchi','W. John Multipurpose Boarding School is counted in the Top 5 Boarding Schools In Ranchi and provides the best Education to the students. Follows ICSE curriculum. ✓Boarding School ✓Secondary School ✓  Enroll Now!','  ','  '),(3,NULL,'image48.jpg','Our Founder','our-founder','<p><strong>&quot;Keeping aim high is not harm but low aim is itself a crime&quot;.</strong></p>\r\n\r\n<p>At Piska Nagri, 15 km west from Ranchi city on Ranchi-Mumbai National Highway Road No. NH 23 in a calm, peaceful, and pollution-free environment. W. John Multipurpose Boarding School was set up in 1990, under the able guidance of conscientious and meticulous personality Dr. M P Ekka.&nbsp;<strong>Bahuddesiya Samaj Sewa Sanstha</strong>&nbsp;is the apex body of the school. In a short span of years, it has already established itself as a leading institution.</p>\r\n\r\n<p>The school is permanently affiliated with the council for the&nbsp;<strong>Indian School Certificate Examinations, New Delhi</strong>. The school curriculum and the teaching methodology are based on the latest thought and trends in Education.</p>\r\n\r\n<p>The school endeavors to fulfill and inculcate within the students four major dimensions of true education i.e; physical, mental, social, and spiritual. The distinctive Adventist ethos of the school creates the atmosphere in which children can flourish, as they develop their skills, and knowledge and realize their dreams come true.</p>\r\n','','Y','Our Founder |  Lt. Dr. M. P. Ekka','Our Founder: Lt. Dr. M. P. Ekka','The school is permanently affiliated with the council for the Indian School Certificate Examinations, New Delhi. The school curriculum and the teaching methodology are based on the latest thought and trends in Education.','Lt. Dr. M. P. Ekka','Founder Director'),(4,NULL,'image51.jpg','Director\'s Message','chairperson','<p>&quot;Literacy in itself is no education. Literacy is not the end of education or even the beginning. By education, I mean an all-round drawing out of the best in the child and man-body, mind and spirit. Mahatma Gandhi did not learn from facts but trained the mind to think&quot; Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance. In the current challenging times, it is essential that children should not only excel in academics but should also develop courtesy, discipline, smart personality, and social sensitivity and be imbibed with the traditional values and culture of our country. Childhood is the best time to lay the foundation of the core values essential for the overall development of the future citizen of tomorrow. Year by year the efforts of all our staff and students have taken the school forward in terms of excellence. The school has progressed in leaps and bounds. Today we stand as one of the noted educational landmarks in the heart of Ranchi, Jharkhand. We offer our students a stress-free learning environment which encourages creativity and critical thinking.&quot;</p>\r\n','<p>Literacy in itself is no education. Literacy is not the end of education or even the beginning. By education, I mean an all-round drawing out of the best in the child and man-body, mind and spirit. Mahatma Gandhi did not learn from facts but trained the mind to think.</p>\r\n','Y','Director | Mr. M. Pierson Ekka','Director’s  Message Mr. M. Pierson Ekka','Today we stand as one of the noted educational landmarks in the heart of Ranchi, Jharkhand. We offer our students a stress-free learning environment which encourages creativity and critical thinking.',' Mr. M. Pierson Ekka',' Director'),(5,NULL,'image41.jpg','Principal Message','principal','<p><strong>&quot;Success comes to those who work hard and stays with those, who don&#39;t rest on the laurels of the past&quot;</strong>&nbsp;- Dr. APJ Abdul Kalam</p>\r\n\r\n<p><strong>Dear Parents and Guardians</strong>,</p>\r\n\r\n<p>Education is not merely the acquirement of facts but also of values that help us improve the different facets of mankind. A pivotal role of education lies in shaping the personality of a child into a healthy mind and a happy soul, who is not only equipped with contemporary skills and aptitude required for academic excellence but also helping him face the challenges of life in a balanced and harmonious way.</p>\r\n\r\n<p>I am extremely delighted to say that our school has been instrumental in giving quality education and wings to the aspirations of our students in the tribal belt. Our school has been serving as a lighthouse for the community by providing four-fold education mental, physical, social, and spiritual as well. Besides a rigorous scholastic program, the school has marked its name in all spheres such as art and craft, music, a variety of sports, environmental conservation activities and the list goes on...</p>\r\n\r\n<p>This prospectus is intended to give you an idea of the work of our school. In it, you will find information about the everyday running of the school, the wide curriculum we offer, and the breadth of experiences available to our pupils. Of course, all that we aim to achieve is dependent on the fact that we work in partnership with you, the parents. This partnership is crucial, and it is at the center of all that is good for your child in our school.<br />\r\nThanking you.</p>\r\n','','Y','Principals’ Message: Dr. Suphal Ekka','Principal’s Message  Dr. Suphal Ekka','I am extremely delighted to say that our school has been instrumental in giving quality education and wings to the aspirations of our students in the tribal belt','  Dr. (Mrs). Suphal Ekka','  M.A. B.Ed., Ph.D'),(6,NULL,'image44.jpg','Curriculum','curriculum','<p>Education is a core aspect that helps every student to improvise their potential and develop intellectual thoughts so that they can make analytical decisions in their life. Moreover, it is a source that enhances skills, and techniques, and widens knowledge about society and the world in which we live. In schools, we beautifully cover the journey of enlightenment although the curriculum activities in the school develop an inseparable relationship between teachers and students.&nbsp;</p>\r\n\r\n<p>The effective and visual perspective of the curriculum enhances the quality of core education and even gives better outcomes. In addition, at <strong>W. John Multipurpose Boarding School </strong>our goal is not only to deliver knowledge and open the path of opportunities to students but also to make them better citizens so that they can take crucial decisions for the development of society. Moreover, our curriculum builds the confidence and personal growth of students. Most importantly, the teachers play a pivotal role that helps to develop, modify, and act as core developers in the journey of student education. And, our ambitious and creative aspects act as a road map for the path to success.</p>\r\n','<p>Education is a core aspect that helps every student to improvise their potential and develop intellectual thoughts so that they can make analytical decisions in their life. Moreover, it is a source that enhances skills, and techniques, and widens knowledge about society and the world in which we live. In schools, we beautifully cover the journey of enlightenment although the curriculum activities in the school develop an inseparable relation between teachers and students.</p>\r\n','Y','Curriculum','Curriculum','Curriculum','    ','    '),(7,NULL,NULL,'Teaching Faculty','teaching-faculty','<p>There is always a good teacher behind the success of every student. Teacher plays an inseparable role in the beautiful journey of a student&#39;s education. Teachers the road map of vision and aim. Most importantly, the seed of curiosity is developed by every student that stretches analytical thinking in every decision they make in the future.</p>\r\n\r\n<p>At W. John Multipurpose Boarding School in Ranchi, we have the most dedicated, experienced, diligent, and motivated teachers who always believe in achieving the core results, and their vision is to make society a better place to live in by developing the great citizens of the future.</p>\r\n\r\n<p>Our teaching faculty comprises visioned teachers whose analytical skill has the caliber to optimize the effective functioning of the school environment so that every student becomes a great asset to give their best work for developing an educated society. Most importantly, the highly motivated spirit of our teachers is the goal to make creative minds and improve confidence in the personal growth of students. And, we want you to join us to make analytical changes for our future.</p>\r\n','<p>There is always a good teacher behind the success of every student. Teacher plays an inseparable role in the beautiful journey of a student&#39;s education. Teachers the road map of vision and aim. Most importantly, the seed of curiosity is developed by every student that stretches analytical thinking in every decision they make in the future.</p>\r\n','Y','Teaching Faculty in Ranchi, Best Teaching Faculty in Jharkhand ','Teaching Faculty in Ranchi, Best Teaching Faculty in Jharkhand, Teaching Faculty','W. John Multipurpose Boarding School in Ranchi - The Best Teaching Faculty and its Teachers are well-qualified and professional. Follows ICSE curriculum.  ✓Boarding School ✓Secondary School ✓  Enroll Now!','     ','     '),(8,NULL,'image19.jpg','Support Staff','support-staff','<p>1. Kitchen Staff: Our dedicated kitchen team ensures nutritious meals are prepared with care, fostering healthy minds and bodies. They infuse each dish with love, catering to diverse dietary needs while creating a welcoming dining experience.<br />\r\n<br />\r\n2. Bus Drivers: Safeguarding journeys, our reliable bus drivers navigate routes with precision and prioritize student safety above all else. They cultivate a warm atmosphere onboard, fostering a sense of comfort and trust for every passenger.<br />\r\n<br />\r\n3. Helpers: The backbone of our school, helpers offer invaluable support across various tasks, from administrative duties to assisting teachers and students. Their flexibility and dedication streamline operations, enriching the educational environment for all.<br />\r\n<br />\r\n4. Premises Cleaning Staff: With meticulous attention to detail, our cleaning staff maintains a pristine learning environment conducive to growth and well-being. Their tireless efforts behind the scenes ensure every corner sparkles, promoting a hygienic and inviting space.<br />\r\n<br />\r\n5. Security Guards: Vigilant guardians of our school community, security guards uphold a safe and secure environment for learning and growth. Their unwavering presence and swift response to any situation instill confidence and peace of mind among students and staff.</p>\r\n','','Y','Support Staff','Support Staff','Support Staff','',''),(9,NULL,NULL,'Academic Calendar','academic-calendar','<p>W. John Multipurpose Boarding School</p>\r\n','','Y',' W. John Multipurpose Boarding School',' W. John Multipurpose Boarding School',' W. John Multipurpose Boarding School','',''),(10,NULL,NULL,'Awards and Achievements','awards-and-achievements','<p>W. John Multipurpose Boarding School</p>\r\n','','Y',' W. John Multipurpose Boarding School',' W. John Multipurpose Boarding School',' W. John Multipurpose Boarding School','',''),(11,NULL,NULL,'Prospectus and Form','prospectus-and-form','<p>W. John Multipurpose Boarding School</p>\r\n','','Y','School Prospectus 2022-23 and Form | W. John Multipurpose Boarding School in Ranchi','Prospectus and Form | W. John Multipurpose Boarding School in Ranchi','-W. John Multipurpose Boarding School in Ranchi-Check out Prospectus, Brochures, Application Forms, and Guidelines. ✓Boarding School ✓Secondary School ✓  Enroll Now!','',''),(12,NULL,NULL,'Fee Details','fee-details','<p>W. John Multipurpose Boarding School</p>\r\n','','Y','Fee Structure','Fee Structure','Fee Structure',' ',' '),(13,NULL,NULL,'Infrastructure','infrastructure','<p>The leading and pioneering W. John Multipurpose Boarding School provides one of the best school infrastructures. Students spend major hours in school, so it is important to achieve a good outcome. We need to provide the finest and well-structured infrastructure of buildings and furniture. Every student needs to cover the ladder of education and for the foundation of each step needs to improvise the core aspects of intellectual thinking and learning of a student. Most importantly, our furnished infrastructure enhances the productivity of student academic results.</p>\r\n\r\n<p>The fundamental elements of our school infrastructure include three elements.</p>\r\n\r\n<ol>\r\n	<li>comfortable equipment and wooden furniture: We provide a well-structured and organized campus with highly recommendable and modern equipment. Moreover, the furniture of the school is designed with the finest and most comfortable wood. These help students to actively sit for 8 hours a day.</li>\r\n	<li>Durability: Our school infrastructure is designed with a perspective of durability. Moreover, we ensure top-notch product quality and provide supreme equipment to our students so that they can perform and focus to achieve their goals.</li>\r\n	<li>Highly ventilated buildings: Our school buildings are well-ventilated and provide adequate space in a classroom. Most importantly, we have all the supreme facilities for our students who will indeed glorify our future.</li>\r\n</ol>\r\n','<p>The leading and pioneering W. John Multipurpose Boarding School provides one of the best school infrastructures. Students spend major hours in school, so it is important to achieve a good outcome. We need to provide the finest and well-structured infrastructure of buildings and furniture. Every student needs to cover the ladder of education and for the foundation of each step needs to improvise the core aspects of intellectual thinking and learning of a student. Most importantly, our furnished infrastructure enhances the productivity of student academic results.</p>\r\n','Y','School Infrastructure- W. John Multipurpose Boarding School in Ranchi','Infrastructure- W. John Multipurpose Boarding School in Ranchi','W. John Multipurpose Boarding School infrastructure is designed with a futuristic style.','  ','  '),(14,NULL,NULL,'Laboratories And Library','laboratories-and-library','<p>The core knowledge is always obtained from the source of good books. The W. John Multipurpose Boarding School provides the <strong>Best Laboratories and Library in School, Ranchi</strong>. Moreover, we offer a well-furnished area for the library and experimental laboratories. We believe that the intellectual growth of students is achieved with the knowledge and practice of experiments. We retain books of all genres so that students can develop a core understanding of each genre. Despite this, we have separate laboratories for the fundamental experiment of physics, chemistry, and biology.</p>\r\n\r\n<p>Most importantly, the objective to build a structured and organized library has the caliber to enhance and boost productivity along with getting to know more about the world of unrevealed questions. Apart from this, we provide furnished and most comfortable wooden furniture where every student can spend their fruitful time in the part of attaining knowledge. Even, we have added independent writing of anonymous authors so that our students develop a comprehensive understanding of every aspect of knowledge moreover, the experiments they perform in the lab are performed under the guidance of our brilliant and well-educated teacher although we add analytical assessments so, that our students perform better and understand the objective of teamwork as well.</p>\r\n','<p>The core knowledge is always obtained from the source of good books. The W. John Multipurpose Boarding School provides the best laboratories and library in the school. Moreover, we offer a well-furnished area for the library and experimental laboratories. We believe that the intellectual growth of students is achieved with the knowledge and practice of experiments. We retain books of all genres so that students can develop a core understanding of each genre. Despite this, we have separate laboratories for the fundamental experiment of physics, chemistry, and biology.</p>\r\n','Y','Best Laboratories and Library in School -W. John Multipurpose Boarding School in Ranchi','Laboratories and Library-W. John Multipurpose Boarding School in Ranchi','W. John Multipurpose Boarding School library plays a vital role in the life of students by catering as the storehouse of knowledge.','  ','  '),(15,NULL,NULL,'Hostel','hostel','<p>W. John Multipurpose Boarding School provides the best <strong>Boarding School With Hostel Facility in Ranchi</strong>. Our boarding school has proved its expertise over the ages. Moreover, we believe to support every change that can enhance our educational scenario. With persistence and years of practice, we have built structural and accountable management that helps to resolve any problem of our students. Talking about our hostel, we offer the safest hostel campus fully under surveillance. We are known as&nbsp;<strong>Best School With Hostel in Jharkhand</strong>, We know that the safety of each student is an inevitable part of our school. And, the facilities we provide in our hostel permies are:-</p>\r\n\r\n<ol>\r\n	<li>Separate blocks:- We offer separate blocks for boys and girls with fully furnished facilities with modern equipment to make our students be focused and determined in their studies.&nbsp;</li>\r\n	<li>Internet accessibility:- Each wing of hostels has the accessibility of a high internet network. This helps students to enhance their productivity.</li>\r\n	<li>Maintenance of discipline:- We know that discipline plays an inevitable role in students&#39; life. And we want to teach our students sets of rules and regulations to build good habits for the rest of their life.&nbsp;</li>\r\n	<li>Restrooms:- We provide a separate section of games, entertainment, and restrooms to our students so that we can share thoughts with their peer groups and learn about social parameters.</li>\r\n</ol>\r\n','<p>W. John Multipurpose Boarding School provides the best hostel facilities. Our boarding school has proved its expertise over the ages. Moreover, we believe to support every change that can enhance our educational scenario. With persistence and years of practice, we have built structural and accountable management that helps to resolve any problem of our students. Talking about our hostel, we offer the safest hostel campus fully under surveillance.</p>\r\n','Y','Boarding School With Hostel Facility in Ranchi, Best School With Hostel in Jharkhand','School With Hostel Facility in Ranchi, Best School With Hostel in Jharkhand, Hostel Facility in Ranchi','W. John Multipurpose Boarding School Provides Hostel Facilities to the students so that they can come from different parts of the Country and study here. We are listed among the best schools With hostels in Ranchi.','  ','  '),(16,NULL,NULL,'Classroom','classroom','<p>W. John Multipurpose Boarding Schools provide the best <strong>Smart Class Education in Ranchi</strong>. A classroom is a room that paints a beautiful journey of education in students&#39; lives. We believe that the classroom is the best place to attain enlightenment for the rest of your life. Moreover, we know that these rooms have inevitable roles so, with ample experience we have built highly interactive and comfortable classrooms with adequate space and an abundance of natural light. Despite this, we know that for attaining a core knowledge and understanding of the world students sit eight hours of the day in this classroom so, we have made it comfortable and customized with separate desks for each student. This helps students to focus on their studies and adds more productivity each day. We provide the best&nbsp;<strong>Digital Classrooms in Jharkhand</strong>.</p>\r\n\r\n<p>Apart from ample light, our classrooms are highly ventilated so that we can ensure the good health of our students. As we know that in today&rsquo;s world we can&#39;t separate ourselves from modern technology and this enhances our productivity, in addition, provides an unmatched experience. For the same, we have developed smart classes for our students so that they can perform better and be competitive with the world.</p>\r\n','<p>W. John Multipurpose Boarding Schools provide the best classroom for its students. A classroom is a room that paints a beautiful journey of education in students&#39; lives. We believe that the classroom is the best place to attain enlightenment for the rest of your life. Moreover, we know that these rooms have inevitable roles so, with ample experience we have built highly interactive and comfortable classrooms with adequate space and an abundance of natural light.</p>\r\n','Y','Smart Class Education in Ranchi, Digital Classrooms in Jharkhand','Smart Class Education in Ranchi, Digital Classrooms in Jharkhand, Best Smart Class Education in Ranchi','A Classroom is a learning space in which both children and adults learn- W. John Multipurpose Boarding School in Ranchi is equipped with smart classrooms for interactive and tech-savvy learning. ','   ','   '),(17,NULL,NULL,'Transportation','transportation','<p>Transportation is one of the important aspects that help students to cover a smooth journey to their school. At W. John Multipurpose Boarding school we provide the <strong>Best Transportation in Ranchi</strong>. Moreover, we believe in building trust with the parents of each student. Our school ensures every standard of the safe journey so that every student can travel hassle-free to school. Heading towards the facilities we provide in transportation:-</p>\r\n\r\n<ol>\r\n	<li>Fully furnished school bus:- At W. John School, we provide the <strong>Best School Bus in Jharkhand</strong>. Our school buses are fully furnished and are highly ventilated. Moreover, our school buses are designed with the best comfortable seats for kids, so that every child can travel safely and comfortably.</li>\r\n	<li>Experienced and licensed bus drivers:- Our school believes that safety major is the key factor in every journey. Our school buses are driven by highly experienced and licensed drivers. We always ensure that our students get the best facilities and for the same, we do changes to assure better performance and productivity every day.</li>\r\n	<li>Our trained drivers and dedicated helper staff ensure the safety of every student during pick-ups and drops.</li>\r\n</ol>\r\n','<p>Transportation is one of the important aspects that help students to cover a smooth journey to their school. At W. John Multipurpose Boarding school we provide the best transportation in Ranchi. Moreover, we believe in building trust with the parents of each student. Our school ensures every standard of the safe journey so that every student can travel hassle-free to school.</p>\r\n','Y','Best Transportation in Ranchi, Best School Bus in Jharkhand','Best Transportation in Ranchi, Best School Bus in Jharkhand','W. John Multipurpose Boarding School Provides Best Transportation in Ranchi to the students so that they can come from different parts of the City and study here. We are listed among the Best School Bus in Jharkhand.','  ','  '),(18,NULL,NULL,'Food and Dining','food-and-dining','<p>For the development of the child, education is an inevitable source of learning although growing children must need a nutritious and healthy diet to build a strong immunity system. At W. John Multipurpose Boarding school, we provide a nourishing <strong>Food Dining Areas</strong> in school. We retain a separate food area where students comfortably sit and get nutritious food. We believe that a healthy mind lives in a healthy body. And for the same, we ensure all the food quality parameters, so that each student gets all the essential nutritious food. Furthermore, our school is always concerned about safety and hygiene as well.&nbsp;</p>\r\n\r\n<p>We have built well-organized management that supports regular hygiene and sanitation in a food court. Talking about our food area, we always set a meal plan which includes premium quality and nutritious food that consist of high proteins, vitamins, carbohydrates, and fats. Furthermore, we add fruits and dairy products. Despite this, the sitting arrangements help to sit with their peer groups and share a set of thoughts. All these factors enhance and help them to build strong immune systems and a healthy body. We are one of the best <strong>School Dining Areas in Ranchi</strong>.</p>\r\n','<p>For the development of the child, education is an inevitable source of learning although growing children must need a nutritious and healthy diet to build a strong immunity system. At W. John Multipurpose Boarding school, we provide a nourishing food dining area in school. We retain a separate food area where students comfortably sit and get nutritious food. We believe that a healthy mind lives in a healthy body. And for the same, we ensure all the food quality parameters, so that each student gets all the essential nutritious food.</p>\r\n','Y','Food Dining Areas, School Dining Areas  in Ranchi','Food Dining Areas, School Dining Areas  in Ranchi','Children and young people are more likely to eat healthy meals at school- W. John Multipurpose Boarding School Offers your students an excellent Dining experience.','  ','  '),(19,NULL,'image46.jpg','Alumni','alumni','<p>As you gear up to commence this incredible journey at&nbsp;W&nbsp;John&nbsp;Multipurpose Boarding School, bear in mind that the choices you make, the connections you forge, and, above all, the perspective you adopt have the potential to shape your entire world. Make a commitment to expand your horizons, strive to empathize deeply, and engage in meaningful conversations to foster personal growth. Remember, you cannot paint the canvas of your life with your hands tucked in your pockets. Therefore, be bold enough to take risks that will propel you further along your path of self-discovery. Opportunities abound, waiting to be seized. Embrace them with determination and vigour.</p>\r\n','','Y',' W. John Multipurpose Boarding School',' W. John Multipurpose Boarding School','W. John Multipurpose Boarding School','',''),(20,NULL,NULL,'Contact Us','contact-us','<p>W. John Multipurpose Boarding School</p>\r\n','','Y','W. John Multipurpose Boarding School, Ranchi, India| Trusted Brand Since 1990','W. John Multipurpose Boarding School,W.john Multipurpose School in Ranchi','W. John Multipurpose Boarding School, Ranchi, India. Trusted Brand Since 1990, Topmost Boarding School in Ranchi','    ','    '),(21,NULL,'image33.jpg','Vice Principal','vice-principal','<p><strong>&quot;The function of education is to teach one to think intensively and to think critically Intelligence plus character, that is the goal of true Education&rdquo;</strong> -Martin Luther King</p>\r\n\r\n<p>The first step into school is that giant step forward, where children embark on the great adventure of discovering the wide world outside and the depth of the world within. As we hold the little finger and guide the young ones forward, we realize our responsibility of nurturing their curiosity, igniting their minds to pierce the skies, helping them to discover the world of books and richness of experience, ponder on the mystery of birds in the sky, the bees in the sun, the flowers on a green hill&rdquo;, and today master the magic of technology and the limitless span of cyberspace. A good career is important but a good character is paramount. We believe that &#39;individuals&#39; are the atoms that hold tremendous power within to serve as agents of change and thus are confident that our students, enriched with a sense of high morality and social responsibility will be makers of a virtuous society. In a world of stiff competition, strife, and unrealistic aspirations, it calls for sensitivity on our part as educators to help children understand that predicament is common to everyone. Problems and challenges need to be faced courageously with conviction in our principles and confidence in our inner strength and dreams.</p>\r\n','','Y','Vice-Principal: Mrs. Priyanka N Biswas','Vice-Principal: Mrs. Priyanka N Biswas','The first step into school is that giant step forward, where children embark on the great adventure of discovering the wide world outside and the depth of the world within.','Mrs. Priyanka N Biswas','Vice Principal');

--
-- Table structure for table `subcontent_tbl`
--

CREATE TABLE `subcontent_tbl` (
  `subcontent_id` int(11) NOT NULL AUTO_INCREMENT,
  `subcontent_cat` varchar(400) NOT NULL,
  `subcontent_subcat` varchar(800) NOT NULL,
  `subcontent_desc` longtext,
  `subcontent_metatitle` text NOT NULL,
  `subcontent_mrtakey` text NOT NULL,
  `subcontent_metadesc` text NOT NULL,
  `subcontent_country` varchar(700) NOT NULL,
  `subcontent_date` varchar(300) NOT NULL,
  `short_desc` varchar(500) NOT NULL,
  `prodcut_subcat` varchar(200) NOT NULL,
  `product_subsubcat` varchar(200) NOT NULL,
  `product_finalcat` int(11) NOT NULL,
  `location` varchar(1000) NOT NULL,
  `product_subsubsubcat` varchar(1000) NOT NULL,
  PRIMARY KEY (`subcontent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subcontent_tbl`
--


--
-- Table structure for table `subdomainmetatag_pages`
--

CREATE TABLE `subdomainmetatag_pages` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `catDesc1` text NOT NULL,
  `catDesc` text NOT NULL,
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subdomainmetatag_pages`
--


--
-- Table structure for table `tbl_corder`
--

CREATE TABLE `tbl_corder` (
  `corder_id` int(11) NOT NULL AUTO_INCREMENT,
  `corder_name` varchar(600) NOT NULL,
  `corder_email` varchar(200) NOT NULL,
  `corder_mobile` varchar(100) NOT NULL,
  `corder_country` varchar(300) NOT NULL,
  `corder_product` varchar(500) NOT NULL,
  `corder_artwork` varchar(300) NOT NULL,
  `corder_plname` varchar(600) NOT NULL,
  `corder_plno` varchar(200) NOT NULL,
  `corder_plsize` varchar(300) NOT NULL,
  `corder_plqty` varchar(500) NOT NULL,
  `corder_date` varchar(200) NOT NULL,
  PRIMARY KEY (`corder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_corder`
--


--
-- Table structure for table `tbl_enquiry`
--

CREATE TABLE `tbl_enquiry` (
  `en_id` int(11) NOT NULL AUTO_INCREMENT,
  `en_name` varchar(800) DEFAULT NULL,
  `en_parents` varchar(50) DEFAULT NULL,
  `en_mobile` varchar(100) DEFAULT NULL,
  `en_email` varchar(100) DEFAULT NULL,
  `en_country` varchar(100) DEFAULT NULL,
  `en_address` text NOT NULL,
  `en_zipcode` varchar(50) NOT NULL,
  `en_state` varchar(50) NOT NULL,
  `en_comment` varchar(900) DEFAULT NULL,
  `en_type` enum('1','2','3','4') NOT NULL COMMENT '1 = Enquiries, 2 = Subscription, 3 = Whatsapp, 4 = Adminssion Enquiry',
  `en_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `en_url` varchar(500) DEFAULT NULL,
  `locationID` varchar(100) DEFAULT NULL,
  `en_product_name` varchar(300) DEFAULT NULL,
  `en_ip` varchar(300) DEFAULT NULL,
  `en_doc_name` varchar(300) DEFAULT NULL,
  `en_doc_id` varchar(300) DEFAULT NULL,
  `booking_date` varchar(300) DEFAULT NULL,
  `en_time` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`en_id`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_enquiry`
--

INSERT INTO `tbl_enquiry` VALUES (1,'Madhu Ranjan','Pushpalal Singh','0123456789','test@webpulse.com',NULL,'Delhi','110045','Delhi','Admission form testing','4','2022-12-30 23:12:00','http://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','106.202.222.85',NULL,NULL,NULL,NULL),(2,'Madhu Ranjan','Pushpalal Singh','0123456789','test@webpulse.com',NULL,'Delhi','110045','Delhi','Admission form testing','4','2022-12-30 23:12:00','http://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','106.202.222.85',NULL,NULL,NULL,NULL),(3,'Satish kerketta',NULL,'7987497592',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-02-06 16:15:00','https://www.wjohnschool.org/',NULL,NULL,'49.35.186.110',NULL,NULL,NULL,NULL),(4,'Satish kerketta',NULL,'7987497592',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-02-06 16:16:00','https://www.wjohnschool.org/',NULL,NULL,'49.35.186.110',NULL,NULL,NULL,NULL),(5,'Vineeta Rashmi Topno ',NULL,'9304264469',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-02-27 23:24:00','https://www.wjohnschool.org/fee-structure.htm',NULL,NULL,'157.35.41.240',NULL,NULL,NULL,NULL),(6,'Vineeta Rashmi Topno ',NULL,'9939465783',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-02-27 23:26:00','https://www.wjohnschool.org/fee-structure.htm',NULL,NULL,'157.35.41.240',NULL,NULL,NULL,NULL),(7,'Indrajit Das',NULL,'9831965880',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-03-21 16:28:00','https://www.wjohnschool.org/fee-structure.htm',NULL,NULL,'171.79.22.51',NULL,NULL,NULL,NULL),(8,'Indrajit Das',NULL,'9831965880',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-03-21 16:29:00','https://www.wjohnschool.org/fee-structure.htm',NULL,NULL,'171.79.22.51',NULL,NULL,NULL,NULL),(9,'Prakash Kumar Bauri ',NULL,'9771308320','prakashsbw07@gmail.com','Bokaro ','','','','I saw a recruitment advertisement in indeed for PGT COMPUTE SCIENCE , is this true?','1','2023-04-01 15:00:00','https://www.wjohnschool.org/notice.htm',NULL,NULL,'157.35.58.28',NULL,NULL,NULL,NULL),(10,'Premomoy Jhapri',NULL,'8017877967',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-04-03 14:34:00','https://www.wjohnschool.org/',NULL,NULL,'157.39.64.44',NULL,NULL,NULL,NULL),(11,'Nikesh ',NULL,'7004905582',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-04-07 02:50:00','https://www.wjohnschool.org/',NULL,NULL,'49.37.26.131',NULL,NULL,NULL,NULL),(12,'Bimla',NULL,'7208540981',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-04-18 21:34:00','https://www.wjohnschool.org/fee-structure.htm',NULL,NULL,'106.208.116.77',NULL,NULL,NULL,NULL),(13,'Ankit Gupta ',NULL,'9693469525',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-05-01 19:02:00','https://www.wjohnschool.org/',NULL,NULL,'152.58.160.196',NULL,NULL,NULL,NULL),(14,'Ankit Gupta ',NULL,'9693469525',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-05-01 19:02:00','https://www.wjohnschool.org/',NULL,NULL,'152.58.160.196',NULL,NULL,NULL,NULL),(15,'Ankit Gupta ',NULL,'9693469525',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-05-01 19:02:00','https://www.wjohnschool.org/',NULL,NULL,'152.58.160.196',NULL,NULL,NULL,NULL),(16,'Amit Anand',NULL,'8638773463',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-05-05 02:02:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,NULL,'49.206.12.1',NULL,NULL,NULL,NULL),(17,'Amit Anand',NULL,'8638773463',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-05-05 02:03:00','https://www.wjohnschool.org/fee-structure.htm',NULL,NULL,'49.206.12.1',NULL,NULL,NULL,NULL),(18,'Anjali Sneha ',NULL,'7903467958',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-05-29 23:53:00','https://www.wjohnschool.org/',NULL,NULL,'49.37.26.133',NULL,NULL,NULL,NULL),(19,'Anjali Sneha ',NULL,'7903467958',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-05-29 23:54:00','https://www.wjohnschool.org/',NULL,NULL,'49.37.26.133',NULL,NULL,NULL,NULL),(20,'Anjali Sneha ',NULL,'7903467958',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-05-29 23:54:00','https://www.wjohnschool.org/',NULL,NULL,'49.37.26.133',NULL,NULL,NULL,NULL),(33,'Pratibha chaurasiya',NULL,'9905592852',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-07-12 17:21:00','https://www.wjohnschool.org/',NULL,NULL,'152.58.132.236',NULL,NULL,NULL,NULL),(28,'Deepanwita Bhattacharjee',NULL,'9572210859',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-06-20 04:57:00','https://www.wjohnschool.org/contact-us.htm',NULL,NULL,'117.99.236.54',NULL,NULL,NULL,NULL),(29,'Deepanwita Bhattacharjee',NULL,'9572210859',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-06-21 14:50:00','https://www.wjohnschool.org/',NULL,NULL,'117.99.224.114',NULL,NULL,NULL,NULL),(30,'varun rabari',NULL,'8928110663',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-06-27 15:22:00','https://www.wjohnschool.org/contact-us.htm',NULL,NULL,'49.36.121.137',NULL,NULL,NULL,NULL),(31,'Anjali kujur',NULL,'8986642289',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-07-09 21:14:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,NULL,'117.198.36.25',NULL,NULL,NULL,NULL),(32,'a',NULL,'7982126049',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-07-11 15:25:00','https://www.wjohnschool.org/contact-us.htm',NULL,NULL,'103.212.158.59',NULL,NULL,NULL,NULL),(34,'Rahul thapa',NULL,'6201571678',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-08-02 17:58:00','https://www.wjohnschool.org/',NULL,NULL,'157.42.5.53',NULL,NULL,NULL,NULL),(35,'R K Singh',NULL,'8984341381','singhrkjsr@gmail.com','Jamshedpur','','','','Dear Sir,\r\nSub: Required information for admission in 10th Class\r\nI went to your website to see the details of your school, I liked it very much. \r\nI want to get admission of my nephew in 10th class in your school.\r\n\r\nPlease tell me the process of admission and the fee structure of the School and Hostel.\r\n\r\nStudent Name: Anish Kumar Singh\r\nBoard: ICSE Board\r\n\r\n\r\nWith regards,\r\nRK Singh\r\nPh: +91 8984341381\r\nJamshedpur, Jharkhand','1','2023-08-03 05:57:50','https://www.wjohnschool.org/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'NILI PUSHPA TIRKEY',NULL,'7004934025','nilipushpa251092@gmail.com','Kantatoli','','','','For teacher vacancy ','1','2023-08-04 12:08:13','https://www.wjohnschool.org/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'Shishir Lukas Minj ',NULL,'8809010624',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-08-17 00:05:00','https://www.wjohnschool.org/contact-us.htm',NULL,NULL,'106.208.209.134',NULL,NULL,NULL,NULL),(38,'Shishir Lukas Minj ',NULL,'8809010624',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-08-17 00:06:00','https://www.wjohnschool.org/contact-us.htm',NULL,NULL,'106.208.209.134',NULL,NULL,NULL,NULL),(39,'Shishir Lukas Minj ',NULL,'8809010624',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-08-17 00:06:00','https://www.wjohnschool.org/contact-us.htm',NULL,NULL,'106.208.209.134',NULL,NULL,NULL,NULL),(40,'Nilamber kumar',NULL,'7762901916',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-08-17 22:23:00','https://www.wjohnschool.org/fee-structure.htm',NULL,NULL,'49.37.72.184',NULL,NULL,NULL,NULL),(41,'Akash Karmakar',NULL,'7908061369',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-09-03 08:07:00','https://www.wjohnschool.org/contact-us.htm',NULL,NULL,'49.37.52.62',NULL,NULL,NULL,NULL),(42,'Zainab Fatima',NULL,'7903667559',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-09-12 05:12:00','https://www.wjohnschool.org/',NULL,NULL,'182.77.98.137',NULL,NULL,NULL,NULL),(43,'Ranjeet',NULL,'7542913021',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-10-02 11:36:00','https://www.wjohnschool.org/fee-structure.htm',NULL,NULL,'106.207.41.152',NULL,NULL,NULL,NULL),(44,'Kavya Gupta',NULL,'9755867010',NULL,NULL,'','','','Whatsapp Enquiry','1','2023-10-05 21:04:00','https://www.wjohnschool.org/contact-us.htm',NULL,NULL,'49.43.42.185',NULL,NULL,NULL,NULL),(45,'RITU RANJANA KACHHAP',NULL,'8674958459','ishitaranjana03894@gmail.com','Ranchi','','','','I wanted to inquire if there are any teaching posts vacant for Computer Science TGT or PGT.','1','2023-10-09 19:44:00','https://www.wjohnschool.org/',NULL,NULL,'152.58.158.123',NULL,NULL,NULL,NULL),(46,'manvika priya','sanjay kumar sinha','8298188733','sksinha589@gmail.com',NULL,'krishna tawer flat no 110 ,sarweshwari nagar , behind iti bus stop, near holi child school , hehal-834005  ','834005','Jharkhand','admission for ukg age','4','2023-11-04 04:11:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','157.42.194.50',NULL,NULL,NULL,NULL),(47,'manvika priya','sanjay kumar sinha','8298188733','sksinha589@gmail.com',NULL,'krishna tawer flat no 110 ,sarweshwari nagar , behind iti bus stop, near holi child school , hehal-834005  ','834005','Jharkhand','admission for ukg age','4','2023-11-04 04:11:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','157.42.194.50',NULL,NULL,NULL,NULL),(48,'Prashant gagrai','Chandra mohan gagrai','7257826464','chandramohan506@gmail.com',NULL,'Tamboo chock chaibasa','833201','Jharkhand','Adimission','4','2024-02-20 22:15:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','157.35.78.217',NULL,NULL,NULL,NULL),(49,'Prashant gagrai','Chandra mohan gagrai','7257826464','chandramohan506@gmail.com',NULL,'Tamboo chock chaibasa','833201','Jharkhand','Adimission','4','2024-02-20 22:15:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','157.35.78.217',NULL,NULL,NULL,NULL),(50,'MD Arham ','Jamshed Aadil','7488016096','jamshedaadil5@gmail.com',NULL,'Road no3.Alkamar colony. Po-simaliya. Ps-Ratu. Ranchi','835222','Jharkhand','For Admission season2025-2026','4','2024-08-01 00:21:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','152.58.187.20',NULL,NULL,NULL,NULL),(51,'MD Arham ','Jamshed Aadil','7488016096','jamshedaadil5@gmail.com',NULL,'Road no3.Alkamar colony. Po-simaliya. Ps-Ratu. Ranchi','835222','Jharkhand','For Admission season2025-2026','4','2024-08-01 00:21:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','152.58.187.20',NULL,NULL,NULL,NULL),(52,'MD Arham ','Jamshed Aadil','7488016096','jamshedaadil5@gmail.com',NULL,'Road no3.Alkamar colony. Po-simaliya. Ps-Ratu. Ranchi','835222','Jharkhand','For Admission season2025-2026','4','2024-08-01 00:21:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','152.58.187.20',NULL,NULL,NULL,NULL),(53,'MD Arham ','Jamshed Aadil','7488016096','jamshedaadil5@gmail.com',NULL,'Road no3.Alkamar colony. Po-simaliya. Ps-Ratu. Ranchi','835222','Jharkhand','For Admission season2025-2026','4','2024-08-01 00:21:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','152.58.187.20',NULL,NULL,NULL,NULL),(54,'Veer Karmakar ','Bablu Karmakar ','8789324779','nivekar749@gmail.com',NULL,'Old A G colony Kadru Ranchi','834002','Jharkhand','Enrolling in hostel want to know rates','4','2024-09-07 19:22:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','49.37.26.65',NULL,NULL,NULL,NULL),(55,'Veer Karmakar ','Bablu Karmakar ','8789324779','nivekar749@gmail.com',NULL,'Old A G colony Kadru Ranchi','834002','Jharkhand','Enrolling in hostel want to know rates','4','2024-09-07 19:22:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','49.37.26.65',NULL,NULL,NULL,NULL),(56,'EVANGELINE  LAKRA','SANGRAS LAKRA ','7070610269','Sangraslakra8@gmail.com',NULL,'G.E.L MISSION SHANTI NAGAR GUMLA P.O+P.S - GUMLA','835207','Jharkhand','Admission in School','4','2024-10-21 22:18:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','152.58.188.113',NULL,NULL,NULL,NULL),(57,'EVANGELINE  LAKRA','SANGRAS LAKRA ','7070610269','Sangraslakra8@gmail.com',NULL,'G.E.L MISSION SHANTI NAGAR GUMLA P.O+P.S - GUMLA','835207','Jharkhand','Admission in School','4','2024-10-21 22:18:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','152.58.188.113',NULL,NULL,NULL,NULL),(58,'Krishna kumar ','Mithilesh Choudhary ','8340273902','mithleshchoudhary915@gmail.com',NULL,'At+post mobharkpur PS salkhaua District sahrsa','852126','Bihar','Please sir admission for 6th class my son','4','2024-12-08 23:28:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','152.59.133.165',NULL,NULL,NULL,NULL),(59,'Krishna kumar ','Mithilesh Choudhary ','8340273902','mithleshchoudhary915@gmail.com',NULL,'At+post mobharkpur PS salkhaua District sahrsa','852126','Bihar','Please sir admission for 6th class my son','4','2024-12-08 23:28:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','152.59.133.165',NULL,NULL,NULL,NULL),(60,'ELIZA XESS','EVA KANCHAN KUJUR ','7484017765','EVAKUJUR05@GMAIL.COM',NULL,'CHANDWA, LATEHAR ','829203','Jharkhand','Nursery admission form','4','2025-01-23 06:03:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','27.61.116.203',NULL,NULL,NULL,NULL),(61,'ELIZA XESS','EVA KANCHAN KUJUR ','7484017765','EVAKUJUR05@GMAIL.COM',NULL,'CHANDWA, LATEHAR ','829203','Jharkhand','Nursery admission form','4','2025-01-23 06:03:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','27.61.116.203',NULL,NULL,NULL,NULL),(62,'Subhasri Das ','Sanjay das','8789519116','das875866@gmail.com',NULL,'Aurobindo colony haludbani parsudih Jamshedpur pin 831002jharkhand','831002','Jharkhand','मà¥à¤े à¤डमिशन कराना है सà¥टैंडरà¥ड नाइन में अपनी बेटी के लिà¤।','4','2025-01-27 15:14:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','152.58.135.76',NULL,NULL,NULL,NULL),(63,'Subhasri Das ','Sanjay das','8789519116','das875866@gmail.com',NULL,'Aurobindo colony haludbani parsudih Jamshedpur pin 831002jharkhand','831002','Jharkhand','मà¥à¤े à¤डमिशन कराना है सà¥टैंडरà¥ड नाइन में अपनी बेटी के लिà¤।','4','2025-01-27 15:14:00','https://www.wjohnschool.org/prospectus-and-form.htm',NULL,'','152.58.135.76',NULL,NULL,NULL,NULL);

--
-- Table structure for table `team_group_tbl`
--

CREATE TABLE `team_group_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(200) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `team_group_tbl`
--


--
-- Table structure for table `team_tbl`
--

CREATE TABLE `team_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(300) DEFAULT NULL,
  `team_group_id` varchar(20) DEFAULT NULL,
  `image` varchar(400) DEFAULT NULL,
  `short_description` text,
  `description` text,
  `designation` varchar(300) DEFAULT NULL,
  `facebook_link` varchar(500) DEFAULT NULL,
  `experience` varchar(200) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT '1',
  `twitter_link` varchar(500) DEFAULT NULL,
  `instagram_link` varchar(500) DEFAULT NULL,
  `linkedin_link` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `team_tbl`
--


--
-- Table structure for table `technology_tbl`
--

CREATE TABLE `technology_tbl` (
  `technology_id` int(200) NOT NULL AUTO_INCREMENT,
  `technology_name` varchar(500) NOT NULL,
  `technology_detail` varchar(200) NOT NULL,
  `technology_images` varchar(200) NOT NULL,
  PRIMARY KEY (`technology_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `technology_tbl`
--


--
-- Table structure for table `testimonial_tbl`
--

CREATE TABLE `testimonial_tbl` (
  `slno` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL DEFAULT '',
  `image` varchar(60) NOT NULL,
  `email` varchar(80) NOT NULL DEFAULT '',
  `title` varchar(100) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `addedBy` varchar(10) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  `replyStatus` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonial_tbl`
--


--
-- Table structure for table `transplant_result_tbl`
--

CREATE TABLE `transplant_result_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(400) DEFAULT NULL,
  `gallery_order` varchar(300) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transplant_result_tbl`
--


--
-- Table structure for table `video_tbl`
--

CREATE TABLE `video_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slink_title` varchar(700) NOT NULL,
  `slink_url` varchar(800) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `video_tbl`
--

INSERT INTO `video_tbl` VALUES (1,'1st Tug of War Zonal Meet ( ASISC RANCHI ZONE) at W. John Multipurpose Boarding School','KsXj1hxYIrw'),(3,'National Band Winner School : W. John Multipurpose Boarding School','XMox71zwAWc');

--
-- Table structure for table `whatsapp_enquiry`
--

CREATE TABLE `whatsapp_enquiry` (
  `en_id` int(11) NOT NULL AUTO_INCREMENT,
  `en_name` varchar(800) DEFAULT NULL,
  `en_mobile` varchar(100) DEFAULT NULL,
  `en_email` varchar(100) DEFAULT NULL,
  `en_country` varchar(100) DEFAULT NULL,
  `en_comment` varchar(900) DEFAULT NULL,
  `en_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `en_url` varchar(500) DEFAULT NULL,
  `locationID` varchar(100) DEFAULT NULL,
  `en_product_name` varchar(300) DEFAULT NULL,
  `en_ip` varchar(300) DEFAULT NULL,
  `en_doc_name` varchar(300) DEFAULT NULL,
  `en_doc_id` varchar(300) DEFAULT NULL,
  `booking_date` varchar(300) DEFAULT NULL,
  `en_time` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`en_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `whatsapp_enquiry`
--



