-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `ibtoverseas`
--

-- --------------------------------------------------------

--
-- Table structure for table `tbl_academic_resourses`
--

CREATE TABLE `tbl_academic_resourses` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `sub_title` varchar(255) DEFAULT NULL,
  `target_url` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_academic_resourses`
--

INSERT INTO `tbl_academic_resourses` (`id`, `title`, `sub_title`, `target_url`, `photo`, `status`, `cdate`) VALUES
(2, 'Blog - MME', 'Notifications, Articles, Quiz, Video Lectures & more', 'https://www.makemyexam.in', '05.png', 1, '2018-11-14 06:02:11'),
(3, 'Download App\'s', 'On The Go Learning With IBT and MME\'s iOS and Android App\'s', '#', '03.png', 1, '2018-11-14 06:09:36'),
(4, 'Weekly Schedule', 'Topic wise class schedule for better transparency and learning', '#', '04.png', 1, '2018-11-14 06:10:35'),
(5, 'Attempt Quiz', 'Attempt Daily Quizzes to boost your skills and knowledge', 'https://www.makemyexam.in/bank-blog-menu/daily-quiz', '6.png', 1, '2018-11-14 06:11:53'),
(6, 'E - Magazine', 'Improve your Current Affairs and knowledge with IBT E-Magazines', 'https://www.makemyexam.in/bank-blog-menu/e-magazine', '06.png', 1, '2018-11-14 06:13:56'),
(7, 'GK Zone', 'One-stop solution for your GK needs', 'https://www.makemyexam.in', '1.png', 1, '2018-11-14 06:14:30');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_banner`
--

CREATE TABLE `tbl_banner` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `short_desc` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `mphoto` varchar(255) DEFAULT NULL,
  `target_url` text,
  `banner_icon` varchar(255) DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `button_text_color` varchar(50) DEFAULT NULL,
  `banner_text_color` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_banner`
--

INSERT INTO `tbl_banner` (`id`, `title`, `short_desc`, `photo`, `mphoto`, `target_url`, `banner_icon`, `button_text`, `button_text_color`, `banner_text_color`, `status`) VALUES
(19, '', '', 'IELTS_PTE_Banner_-_Web1.jpg', 'IELTS_PTE_Banner_-_Mobile1.jpg', '', NULL, '', 'FFFFFF', 'FFFFFF', 1);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_career_job_apply`
--

CREATE TABLE `tbl_career_job_apply` (
  `id` int(11) NOT NULL,
  `job_category` varchar(255) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email_id` varchar(255) DEFAULT NULL,
  `gender` varchar(50) DEFAULT NULL,
  `contact_number` varchar(255) DEFAULT NULL,
  `alternate_number` varchar(255) DEFAULT NULL,
  `subject_type` varchar(255) DEFAULT NULL,
  `educational_qualification` varchar(255) DEFAULT NULL,
  `prefered_locationcenter_list` varchar(255) DEFAULT NULL,
  `experience` varchar(255) DEFAULT NULL,
  `messageif_any` text,
  `resume` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_career_job_apply`
--

INSERT INTO `tbl_career_job_apply` (`id`, `job_category`, `first_name`, `last_name`, `email_id`, `gender`, `contact_number`, `alternate_number`, `subject_type`, `educational_qualification`, `prefered_locationcenter_list`, `experience`, `messageif_any`, `resume`, `status`, `cdate`) VALUES
(3, 'Front Desk', 'Arun', 'Rajput', 'arun@gmail.com', 'Male ', '9711652941', '9711652294', 'Test', 'MCA', 'Noida', '4', '', 'demoform1.pdf', 1, '2019-03-27 05:24:38'),
(5, 'Trainers', 'Akhil ', 'Sharma', 'akhil30sharma@gmail.com', 'Male ', '9478662998', '', 'english ', 'B.com', 'jalandhar', '1 year', '', 'Resume.pdf', 1, '2019-06-29 09:13:30'),
(12, 'Administration', 'Varun', 'Talwar', 'varun77772004@gmail.com', 'Male ', '9815815551', '', 'Resume', 'post graduate', 'Ludhiana', '10 yeara', ' Dear sir/ma`am\r\n \r\n                                 Kindly fund my resume for your reference.\r\nKindly guide and verify if i can contribute to your prestigious organisation \r\n\r\n', 'Resume_(1)_(1).pdf', 1, '2020-04-16 19:24:38'),
(15, 'Trainers', 'Amanpreet', 'Singh', 'singh.amanpreet50@gmail.com', 'Male ', '8567000482', '', 'Applying IELTS trainer', 'Master of Technology (Mechanical Engg.)', 'Ferozepur', '4 years', 'I also have a website (https://www.profielts.com/) where I upload model answers for IELTS modules.', 'AMAN_CV(IELTS).pdf', 1, '2020-06-10 07:53:42'),
(17, 'Counsellor', 'Kawaljeet ', 'Kaur ', 'kawaljeet2101@gmail.com', 'Female ', '9779593638', '', 'Job ', 'B.sc non medical', 'Jalandhar ', '2 years', '', 'Kawal_Resume.docx', 1, '2020-08-19 02:06:29'),
(18, 'Trainers', 'Jyot Inder Kaur', 'Virdi', 'jyotinderkaur@gmail.com', 'Female ', '8556948788', '', 'IELTS', 'Masters', 'Patiala', '6 years', 'I have done masters and have appeared three times for IELTS.', 'resume.doc', 1, '2020-11-13 14:32:12'),
(19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'AMAN_CV(IELTS)1.pdf', 1, '2020-12-24 05:19:27');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_center`
--

CREATE TABLE `tbl_center` (
  `id` int(11) NOT NULL,
  `state_id` int(11) DEFAULT NULL,
  `zone` enum('north','east','south','west') DEFAULT NULL,
  `center_name` varchar(255) DEFAULT NULL,
  `center_address` text,
  `center_url` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_center_setting`
--

CREATE TABLE `tbl_center_setting` (
  `id` int(11) NOT NULL,
  `banner_photo` varchar(255) NOT NULL,
  `mobile_banner` varchar(255) NOT NULL,
  `banner_status` int(2) NOT NULL DEFAULT '0',
  `meta_tag` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_center_setting`
--

INSERT INTO `tbl_center_setting` (`id`, `banner_photo`, `mobile_banner`, `banner_status`, `meta_tag`) VALUES
(1, 'aqa.jpg', 'mob_1.jpg', 1, '<title>Our Centers</title>');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_cms`
--

CREATE TABLE `tbl_cms` (
  `id` int(11) NOT NULL,
  `layout` enum('leftbar','rightbar','topbar','simple') DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` longtext,
  `photo` varchar(255) DEFAULT NULL,
  `banner_photo` varchar(255) DEFAULT NULL,
  `mobile_banner` varchar(255) DEFAULT NULL,
  `banner_status` int(2) NOT NULL DEFAULT '0',
  `meta_tag` blob,
  `status` tinyint(4) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_cms`
--

INSERT INTO `tbl_cms` (`id`, `layout`, `title`, `slug`, `content`, `photo`, `banner_photo`, `mobile_banner`, `banner_status`, `meta_tag`, `status`, `cdate`) VALUES
(1, 'leftbar', 'About Us', 'about-us', '<p style=\"text-align:justify\">IBT English Prep ( A Division of IBT Institute Private Limited) is a premier institute with its presence pan India and working in the field of Eglish preparation courses of&nbsp;varying kinds &ndash; wiz: IELTS, PTE, CELPIP, TOEFL &amp; Spoken English Examinations&nbsp;etc. The Institute has given excellent results particularly in IELTS and PTE Exams. The Institute&#39;s commitment to the success of its students is a unique feature that gives consistent motivation, support, practice, and latest notes/study material. IBT is incorporated in 2009 from Jalandhar (Punjab) and Now in 2019 IBT has a huge Network of 100+ Branches across India. IBT is managed by a team of professionals from top business schools and Management Institutes. As they have themselves gone through the Exams and process so they are the best motivators and pathmakers for the students.</p>\r\n', 'iso_new_low1.png', 'main-banner.png', 'aamir-khan3.jpg', 0, 0x[BLOB], 1, '2018-10-30 07:35:45'),
(10, 'simple', 'Privacy policy', 'privacy-policy', '<h4><span style=\"color:#015198\"><strong>PRIVACY POLICY</strong></span></h4>\r\n\r\n<p style=\"text-align:justify\">The following privacy policy is being published in accordance with the provisions of the Information Technology Act, 2000 (&quot;IT ACT&quot;), Information Technology (Intermediary Guidelines) Rules, 2011, Information Technology (Reasonable Security Practices and Procedures and Sensitive Personal Data or Information) Rules, 2011.</p>\r\n&nbsp;\r\n\r\n<h4><strong><span style=\"color:#015198\">INTRODUCTION</span></strong></h4>\r\n\r\n<p style=\"text-align:justify\">This Privacy Policy explains the policy of IBT Institute Private Limited website (hereinafter referred to as &quot;the Website&quot;) with respect to the disclosure, collection, storage, usage and protection of your information during the course your interaction with the Website.</p>\r\n\r\n<p style=\"text-align:justify\">Please read this Privacy Policy carefully and in conjunction with the Terms of Use. If you do not understand this policy, or do not accept any part of it, then you should not use the Platform, as the case may be. Your use and/or continued use of the Platform, as the case may be amounts to an express consent to the terms of this Privacy Policy as well as the Terms of Use.</p>\r\n\r\n<p style=\"text-align:justify\">This Privacy Policy forms part and parcel of the Terms of Use for the IBT Services and shall be read as a whole. Capitalized terms used here, but undefined, shall have the same meaning as attributed to them in the Terms of Use.<br />\r\n&nbsp;</p>\r\n&nbsp;\r\n\r\n<h4><span style=\"color:#015198\"><strong>INFORMATION COLLECTED FROM YOU</strong></span></h4>\r\n\r\n<p style=\"text-align:justify\">When you use the Platform by way of registration, log in, creation of a user account or creation of a post, purchase of a test series, attempting a mock test, etc. or by way of interaction via third party websites and/or mobile applications or by way of any other communication with the Platform, IBT may collect your personally identifiable information including name, date of birth, gender, demographic information, photos, e-mail address, telephone number, mobile phone number, credit card or debit card details, geographic location, mailing address, social media account details including list of contacts/friends and examination preference.</p>\r\n\r\n<p style=\"text-align:justify\">IBT will use this information to validate you as a user when using the Platform, to provide the Service to you, including administration of your user account, to notify you of changes to the Service or about any changes to our terms and conditions or this privacy policy, to manage its business, including financial reporting and billing of its Service, for the development of new products and services, to send you newsletters, offers and promotion coupons to market and advertise its products and services by email, to comply with applicable laws, court orders and government enforcement agency requests, for research and analytic purposes including to improve the quality of the Service and to ensure that the Service is presented in the most effective manner for you and your device.</p>\r\n\r\n<p style=\"text-align:justify\">By registering on the Platform, you agree and confirm your consent for IBT for providing your aforementioned personal information, which is lawful, necessary and permissible. You at all times have the right to discontinue the use of the Platform. IBT is not liable to provide you its Services in the absence of or your refusal to provide the aforesaid information. Additionally, IBT is not liable to ensure or maintain the same quality of its Services to you, as it may for a user who provides all aforementioned information.<br />\r\n&nbsp;</p>\r\n\r\n<h4><span style=\"color:#015198\"><strong>SHARING OR DISCLOSURE OF INFORMATION COLLECTED</strong></span></h4>\r\n\r\n<p style=\"text-align:justify\">As a strict policy we will not disclose, share or exploit your information with anyone without your express permission.</p>\r\n\r\n<p style=\"text-align:justify\">However, we may be mandated under law or under contracts to make certain limited disclosures under the following circumstances:</p>\r\n\r\n<p style=\"text-align:justify\">Legal Necessity: IBT may share any of the aforesaid information, including your personally identifiable information or Sensitive Personal Data or Information, without obtaining a separate consent from you, if and when such information is requested or required by law or by any court or governmental agency or authority to disclose, for the purpose of verification of identity, or for the prevention, detection, investigation of any criminal activity, or for prosecution and punishment of offences.</p>\r\n\r\n<p style=\"text-align:justify\">Limited Disclosure to Service Providers: we may disclose your information (but not Sensitive Personal Data or Information) to our service providers and business partners (&quot;Service Providers&quot; ) for the purposes of betterment and improvement of our services including but not limited to hosting the Platform, payment processing, analyzing data, providing customer service, etc., for the purpose of making various features, services and products of IBT available to you and investigating or redressing grievances. This will be in the form of aggregated anonymized data and will be under strict contractual arrangements that preserve the confidentiality and security of your personal information in accordance with this Privacy Policy;</p>\r\n\r\n<p style=\"text-align:justify\">Limited Disclosures for improvement of services: IBT may share the aforesaid information including your personally identifiable information (but not Sensitive Personal Data or Information) when it is required to be shared with sponsors, partners, advertisers, analytics companies or third parties for the purpose of marketing, advertising promotional offers, offering product information and market research, in connection with the Service. This will be in the form of aggregated anonymized data and will be under strict contractual arrangements that preserve the confidentiality and security of your personal information in accordance with this Privacy Policy;<br />\r\n&nbsp;</p>\r\n\r\n<h4><span style=\"color:#015198\"><strong>SECURITY OF INFORMATION COLLECTED</strong></span></h4>\r\n\r\n<p style=\"text-align:justify\">We take the security of your personal information seriously and use appropriate technical and organizational measures to protect your personal information against unauthorized or unlawful processing and against accidental loss, destruction or damage. Unfortunately, the transmission of information via the internet is not completely secure. Although we will do our best to protect your personal data, we cannot guarantee the security of your data which is transmitted to or from the Service. Any transmission is at your own risk.</p>\r\n\r\n<p style=\"text-align:justify\">We keep your personal information for no longer than is necessary for our business purposes or for legal requirements.<br />\r\n&nbsp;</p>\r\n\r\n<h4><span style=\"color:#015198\"><strong>AMENDMENTS TO THE PRIVACY POLICY</strong></span></h4>\r\n\r\n<p style=\"text-align:justify\">IBT may amend the Privacy Policy posted on the Website from time to time at its sole discretion. Your continued access or use of the Platform or Services constitute your acceptance of the amendments. Your access and use of the Platform and Services will be subject to the most current version of the Terms of Use, rules and guidelines posted on the Website at the time of such use. Please regularly check the link on the home page to view the most current Privacy Policy.<br />\r\n&nbsp;</p>\r\n\r\n<h4><span style=\"color:#015198\"><strong>CONTACT US</strong></span></h4>\r\n\r\n<p style=\"text-align:justify\">ibtenquiry@gmail.com</p>\r\n', 'download1.png', 'download11.png', 'download12.png', 0, 0x3c7469746c653e5072697661637920506f6c6963793c2f7469746c653e, 1, '2019-08-28 14:04:48');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_country`
--

CREATE TABLE `tbl_country` (
  `id` int(11) NOT NULL,
  `country_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(2) DEFAULT NULL,
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_country`
--

INSERT INTO `tbl_country` (`id`, `country_name`, `country_code`, `status`, `cdate`) VALUES
(11, 'Afghanistan', '+93', 1, '2017-01-09 07:03:37'),
(12, 'Albania', '+355', 1, '2017-01-09 07:03:37'),
(13, 'Algeria', '+213', 1, '2017-01-09 07:03:37'),
(14, 'American Samoa', '+684', 1, '2017-01-09 07:03:37'),
(15, 'Andorra', '+376', 1, '2017-01-09 07:03:37'),
(16, 'Angola', '+244', 1, '2017-01-09 07:03:37'),
(17, 'Anguilla', '+264', 1, '2017-01-09 07:03:37'),
(18, 'Antarctica', '+672', 1, '2017-01-09 07:03:37'),
(19, 'Antigua', '+268', 1, '2017-01-09 07:03:37'),
(20, 'Argentina', '+54', 1, '2017-01-09 07:03:37'),
(21, 'Armenia', '+374', 1, '2017-01-09 07:03:37'),
(22, 'Aruba', '+297', 1, '2017-01-09 07:03:37'),
(23, 'Ascension Island', '+247', 1, '2017-01-09 07:03:37'),
(24, 'Australia', '+61', 1, '2017-01-09 07:03:37'),
(25, 'Austria', '+43', 1, '2017-01-09 07:03:37'),
(26, 'Azerbaijan', '+994', 1, '2017-01-09 07:03:37'),
(27, 'Bahamas', '+242', 1, '2017-01-09 07:03:37'),
(28, 'Bahrain', '+973', 1, '2017-01-09 07:03:37'),
(29, 'Bangladesh', '+880', 1, '2017-01-09 07:03:37'),
(30, 'Barbados', '+246', 1, '2017-01-09 07:03:37'),
(31, 'Barbuda', '+268', 1, '2017-01-09 07:03:37'),
(32, 'Belarus', '+375', 1, '2017-01-09 07:03:37'),
(33, 'Belgium', '+32', 1, '2017-01-09 07:03:37'),
(34, 'Belize', '+501', 1, '2017-01-09 07:03:37'),
(35, 'Benin', '+229', 1, '2017-01-09 07:03:37'),
(36, 'Bermuda', '+441', 1, '2017-01-09 07:03:37'),
(37, 'Bhutan', '+975', 1, '2017-01-09 07:03:37'),
(38, 'Bolivia', '+591', 1, '2017-01-09 07:03:37'),
(39, 'Bosnia & Herzogovin', '+387', 1, '2017-01-09 07:03:37'),
(40, 'Botswana', '+267', 1, '2017-01-09 07:03:37'),
(41, 'Brazil', '+55', 1, '2017-01-09 07:03:37'),
(42, 'British Virgin Islands', '+284', 1, '2017-01-09 07:03:37'),
(43, 'Brunei', '+673', 1, '2017-01-09 07:03:37'),
(44, 'Bulgaria', '+359', 1, '2017-01-09 07:03:37'),
(45, 'Burkina Faso', '+226', 1, '2017-01-09 07:03:37'),
(46, 'Burma (Myanmar)', '+95', 1, '2017-01-09 07:03:37'),
(47, 'Burundi', '+257', 1, '2017-01-09 07:03:37'),
(48, 'Cambodia', '+855', 1, '2017-01-09 07:03:37'),
(49, 'Cameroon', '+237', 1, '2017-01-09 07:03:37'),
(50, 'Canada', '+1', 1, '2017-01-09 07:03:37'),
(51, 'Cape Verde Islands', '+238', 1, '2017-01-09 07:03:37'),
(52, 'Cayman Islands', '+345', 1, '2017-01-09 07:03:37'),
(53, 'Central African Republic', '+236', 1, '2017-01-09 07:03:37'),
(54, 'Chad', '+235', 1, '2017-01-09 07:03:37'),
(55, 'Chatham Island (New Zealand)', '+64', 1, '2017-01-09 07:03:37'),
(56, 'Chile', '+56', 1, '2017-01-09 07:03:37'),
(57, 'China (PRC)', '+86', 1, '2017-01-09 07:03:37'),
(58, 'Christmas Island', '+61', 1, '2017-01-09 07:03:37'),
(59, 'Cocos-Keeling Islands', '+61', 1, '2017-01-09 07:03:37'),
(60, 'Colombia', '+57', 1, '2017-01-09 07:03:37'),
(61, 'Comoros', '+269', 1, '2017-01-09 07:03:37'),
(62, 'Congo', '+242', 1, '2017-01-09 07:03:37'),
(63, 'Congo, Dem. Rep. of (former Zaire)', '+243', 1, '2017-01-09 07:03:37'),
(64, 'Cook Islands', '+682', 1, '2017-01-09 07:03:37'),
(65, 'Costa Rica', '+506', 1, '2017-01-09 07:03:37'),
(66, 'Croatia', '+385', 1, '2017-01-09 07:03:37'),
(67, 'Cuba', '+53', 1, '2017-01-09 07:03:37'),
(68, 'Cuba (Guantanamo Bay)', '+5399', 1, '2017-01-09 07:03:37'),
(69, 'Cyprus', '+357', 1, '2017-01-09 07:03:37'),
(70, 'Czech Republic', '+420', 1, '2017-01-09 07:03:37'),
(71, 'Denmark', '+45', 1, '2017-01-09 07:03:37'),
(72, 'Diego Garcia', '+246', 1, '2017-01-09 07:03:37'),
(73, 'Djibouti', '+253', 1, '2017-01-09 07:03:37'),
(74, 'Dominica', '+767', 1, '2017-01-09 07:03:37'),
(75, 'Dominican Republic', '+809', 1, '2017-01-09 07:03:37'),
(76, 'Easter Island', '+56', 1, '2017-01-09 07:03:37'),
(77, 'Ecuador', '+593', 1, '2017-01-09 07:03:37'),
(78, 'Egypt', '+20', 1, '2017-01-09 07:03:37'),
(79, 'El Salvador', '+503', 1, '2017-01-09 07:03:37'),
(80, 'Equatorial Guinea', '+240', 1, '2017-01-09 07:03:37'),
(81, 'Eritrea', '+291', 1, '2017-01-09 07:03:37'),
(82, 'Estonia', '+372', 1, '2017-01-09 07:03:37'),
(83, 'Ethiopia', '+251', 1, '2017-01-09 07:03:37'),
(84, 'Faeroe Islands', '+298', 1, '2017-01-09 07:03:37'),
(85, 'Falkland Islands', '+500', 1, '2017-01-09 07:03:37'),
(86, 'Fiji Islands', '+679', 1, '2017-01-09 07:03:37'),
(87, 'Finland', '+358', 1, '2017-01-09 07:03:37'),
(88, 'France', '+33', 1, '2017-01-09 07:03:37'),
(89, 'French Antilles', '+596', 1, '2017-01-09 07:03:37'),
(90, 'French Guiana', '+594', 1, '2017-01-09 07:03:37'),
(91, 'French Polynesia', '+689', 1, '2017-01-09 07:03:37'),
(92, 'Gabon', '+241', 1, '2017-01-09 07:03:37'),
(93, 'Gambia', '+220', 1, '2017-01-09 07:03:37'),
(94, 'Georgia', '+995', 1, '2017-01-09 07:03:37'),
(95, 'Germany', '+49', 1, '2017-01-09 07:03:37'),
(96, 'Ghana', '+233', 1, '2017-01-09 07:03:37'),
(97, 'Gibraltar', '+350', 1, '2017-01-09 07:03:37'),
(98, 'Greece', '+30', 1, '2017-01-09 07:03:37'),
(99, 'Greenland', '+299', 1, '2017-01-09 07:03:37'),
(100, 'Grenada', '+473', 1, '2017-01-09 07:03:37'),
(101, 'Guadeloupe', '+590', 1, '2017-01-09 07:03:37'),
(102, 'Guam', '+670', 1, '2017-01-09 07:03:37'),
(103, 'Guantanamo Bay', '+5399', 1, '2017-01-09 07:03:37'),
(104, 'Guatemala', '+502', 1, '2017-01-09 07:03:37'),
(105, 'Guinea-Bissau', '+245', 1, '2017-01-09 07:03:37'),
(106, 'Guinea (PRP)', '+224', 1, '2017-01-09 07:03:37'),
(107, 'Guyana', '+592', 1, '2017-01-09 07:03:37'),
(108, 'Haiti', '+509', 1, '2017-01-09 07:03:37'),
(109, 'Honduras', '+504', 1, '2017-01-09 07:03:37'),
(110, 'Hong Kong', '+852', 1, '2017-01-09 07:03:37'),
(111, 'Hungary', '+36', 1, '2017-01-09 07:03:37'),
(112, 'Iceland', '+354', 1, '2017-01-09 07:03:37'),
(113, 'India', '+91', 1, '2017-01-09 07:03:37'),
(114, 'Indonesia', '+62', 1, '2017-01-09 07:03:37'),
(115, 'Iran', '+98', 1, '2017-01-09 07:03:37'),
(116, 'Iraq', '+964', 1, '2017-01-09 07:03:37'),
(117, 'Ireland', '+353', 1, '2017-01-09 07:03:37'),
(118, 'Israel', '+972', 1, '2017-01-09 07:03:37'),
(119, 'Italy', '+39', 1, '2017-01-09 07:03:37'),
(120, 'Ivory Coast (CÃ´te d\'Ivoire)', '+225', 1, '2017-01-09 07:03:37'),
(121, 'Jamaica', '+876', 1, '2017-01-09 07:03:37'),
(122, 'Japan', '+81', 1, '2017-01-09 07:03:37'),
(123, 'Jordan', '+962', 1, '2017-01-09 07:03:37'),
(124, 'Kazakhstan', '+7', 1, '2017-01-09 07:03:37'),
(125, 'Kenya', '+254', 1, '2017-01-09 07:03:37'),
(126, 'Kiribati', '+686', 1, '2017-01-09 07:03:37'),
(127, 'Korea (North)', '+850', 1, '2017-01-09 07:03:37'),
(128, 'Korea (South)', '+82', 1, '2017-01-09 07:03:37'),
(129, 'Kuwait', '+965', 1, '2017-01-09 07:03:37'),
(130, 'Kyrgyz Republic', '+996', 1, '2017-01-09 07:03:37'),
(131, 'Laos', '+856', 1, '2017-01-09 07:03:37'),
(132, 'Latvia', '+371', 1, '2017-01-09 07:03:37'),
(133, 'Lebanon', '+961', 1, '2017-01-09 07:03:37'),
(134, 'Lesotho', '+266', 1, '2017-01-09 07:03:37'),
(135, 'Liberia', '+231', 1, '2017-01-09 07:03:37'),
(136, 'Libya', '+218', 1, '2017-01-09 07:03:37'),
(137, 'Liechtenstein', '+41', 1, '2017-01-09 07:03:37'),
(138, 'Lithuania', '+370', 1, '2017-01-09 07:03:37'),
(139, 'Luxembourg', '+352', 1, '2017-01-09 07:03:37'),
(140, 'Macau', '+853', 1, '2017-01-09 07:03:37'),
(141, 'Macedonia (former Yugoslav Rep.)', '+389', 1, '2017-01-09 07:03:37'),
(142, 'Madagascar', '+261', 1, '2017-01-09 07:03:37'),
(143, 'Malawi', '+265', 1, '2017-01-09 07:03:37'),
(144, 'Malaysia', '+60', 1, '2017-01-09 07:03:37'),
(145, 'Maldives', '+960', 1, '2017-01-09 07:03:37'),
(146, 'Mali Republic', '+223', 1, '2017-01-09 07:03:37'),
(147, 'Malta', '+356', 1, '2017-01-09 07:03:37'),
(148, 'Marshall Islands', '+692', 1, '2017-01-09 07:03:37'),
(149, 'Martinique', '+596', 1, '2017-01-09 07:03:37'),
(150, 'Mauritania', '+222', 1, '2017-01-09 07:03:37'),
(151, 'Mauritius', '+230', 1, '2017-01-09 07:03:37'),
(152, 'Mayotte Island', '+269', 1, '2017-01-09 07:03:37'),
(153, 'Mexico', '+52', 1, '2017-01-09 07:03:37'),
(154, 'Micronesia', '+691', 1, '2017-01-09 07:03:37'),
(155, 'Midway Island', '+808', 1, '2017-01-09 07:03:37'),
(156, 'Moldova', '+373', 1, '2017-01-09 07:03:37'),
(157, 'Monaco', '+377', 1, '2017-01-09 07:03:37'),
(158, 'Mongolia', '+976', 1, '2017-01-09 07:03:37'),
(159, 'Montserrat', '+664', 1, '2017-01-09 07:03:37'),
(160, 'Morocco', '+212', 1, '2017-01-09 07:03:37'),
(161, 'Mozambique', '+258', 1, '2017-01-09 07:03:37'),
(162, 'Myanmar', '+95', 1, '2017-01-09 07:03:37'),
(163, 'Namibia', '+264', 1, '2017-01-09 07:03:37'),
(164, 'Nauru', '+674', 1, '2017-01-09 07:03:37'),
(165, 'Nepal', '+977', 1, '2017-01-09 07:03:37'),
(166, 'Netherlands', '+31', 1, '2017-01-09 07:03:37'),
(167, 'Netherlands Antilles', '+599', 1, '2017-01-09 07:03:37'),
(168, 'Nevis', '+869', 1, '2017-01-09 07:03:37'),
(169, 'New Caledonia', '+687', 1, '2017-01-09 07:03:37'),
(170, 'New Zealand', '+64', 1, '2017-01-09 07:03:37'),
(171, 'Nicaragua', '+505', 1, '2017-01-09 07:03:37'),
(172, 'Niger', '+227', 1, '2017-01-09 07:03:37'),
(173, 'Nigeria', '+234', 1, '2017-01-09 07:03:37'),
(174, 'Niue', '+683', 1, '2017-01-09 07:03:37'),
(175, 'Norfolk Island', '+672', 1, '2017-01-09 07:03:37'),
(176, 'North Korea', '+850', 1, '2017-01-09 07:03:37'),
(177, 'Norway', '+47', 1, '2017-01-09 07:03:37'),
(178, 'Oman', '+968', 1, '2017-01-09 07:03:37'),
(179, 'Pakistan', '+92', 1, '2017-01-09 07:03:37'),
(180, 'Palau', '+680', 1, '2017-01-09 07:03:37'),
(181, 'Panama', '+507', 1, '2017-01-09 07:03:37'),
(182, 'Papua New Guinea', '+675', 1, '2017-01-09 07:03:37'),
(183, 'Paraguay', '+595', 1, '2017-01-09 07:03:37'),
(184, 'Peru', '+51', 1, '2017-01-09 07:03:37'),
(185, 'Philippines', '+63', 1, '2017-01-09 07:03:37'),
(186, 'Poland', '+48', 1, '2017-01-09 07:03:37'),
(187, 'Portugal', '+351', 1, '2017-01-09 07:03:37'),
(188, 'Puerto Rico', '+787', 1, '2017-01-09 07:03:37'),
(189, 'Qatar', '+974', 1, '2017-01-09 07:03:37'),
(190, 'RÃ©union Island', '+262', 1, '2017-01-09 07:03:37'),
(191, 'Romania', '+40', 1, '2017-01-09 07:03:37'),
(192, 'Rota Island', '+670', 1, '2017-01-09 07:03:37'),
(193, 'Russia', '+7', 1, '2017-01-09 07:03:37'),
(194, 'Rwanda', '+250', 1, '2017-01-09 07:03:37'),
(195, 'St. Helena', '+290', 1, '2017-01-09 07:03:37'),
(196, 'St. Kitts/Nevis', '+869', 1, '2017-01-09 07:03:37'),
(197, 'St. Lucia', '+758', 1, '2017-01-09 07:03:37'),
(198, 'St. Pierre & Miquelon', '+508', 1, '2017-01-09 07:03:37'),
(199, 'St. Vincent & Grenadines', '+809', 1, '2017-01-09 07:03:37'),
(200, 'Saipan Island', '+670', 1, '2017-01-09 07:03:37'),
(201, 'San Marino', '+378', 1, '2017-01-09 07:03:37'),
(202, 'SÃ£o TomÃ© and Principe', '+239', 1, '2017-01-09 07:03:37'),
(203, 'Saudi Arabia', '+966', 1, '2017-01-09 07:03:37'),
(204, 'Senegal', '+221', 1, '2017-01-09 07:03:37'),
(205, 'Serbia', '+381', 1, '2017-01-09 07:03:37'),
(206, 'Seychelles Islands', '+248', 1, '2017-01-09 07:03:37'),
(207, 'Sierra Leone', '+232', 1, '2017-01-09 07:03:37'),
(208, 'Singapore', '+65', 1, '2017-01-09 07:03:37'),
(209, 'Slovak Republic', '+421', 1, '2017-01-09 07:03:37'),
(210, 'Slovenia', '+386', 1, '2017-01-09 07:03:37'),
(211, 'Solomon Islands', '+677', 1, '2017-01-09 07:03:37'),
(212, 'Somalia', '+252', 1, '2017-01-09 07:03:37'),
(213, 'South Africa', '+27', 1, '2017-01-09 07:03:37'),
(214, 'South Korea', '+82', 1, '2017-01-09 07:03:37'),
(215, 'Spain', '+34', 1, '2017-01-09 07:03:37'),
(216, 'Sri Lanka', '+94', 1, '2017-01-09 07:03:37'),
(217, 'Sudan', '+249', 1, '2017-01-09 07:03:37'),
(218, 'Suriname', '+597', 1, '2017-01-09 07:03:37'),
(219, 'Swaziland', '+268', 1, '2017-01-09 07:03:37'),
(220, 'Sweden', '+46', 1, '2017-01-09 07:03:37'),
(221, 'Switzerland', '+41', 1, '2017-01-09 07:03:37'),
(222, 'Syria', '+963', 1, '2017-01-09 07:03:37'),
(223, 'Taiwan', '+886', 1, '2017-01-09 07:03:37'),
(224, 'Tajikistan', '+7', 1, '2017-01-09 07:03:37'),
(225, 'Tanzania', '+255', 1, '2017-01-09 07:03:37'),
(226, 'Thailand', '+66', 1, '2017-01-09 07:03:37'),
(227, 'Tinian Island', '+970', 1, '2017-01-09 07:03:37'),
(228, 'Togo', '+228', 1, '2017-01-09 07:03:37'),
(229, 'Tokelau', '+690', 1, '2017-01-09 07:03:37'),
(230, 'Tonga Islands', '+676', 1, '2017-01-09 07:03:37'),
(231, 'Trinidad & Tobago', '+868', 1, '2017-01-09 07:03:37'),
(232, 'Tunisia', '+216', 1, '2017-01-09 07:03:37'),
(233, 'Turkey', '+90', 1, '2017-01-09 07:03:37'),
(234, 'Turkmenistan', '+993', 1, '2017-01-09 07:03:37'),
(235, 'Turks and Caicos Islands', '+649', 1, '2017-01-09 07:03:37'),
(236, 'Tuvalu', '+688', 1, '2017-01-09 07:03:37'),
(237, 'Uganda', '+256', 1, '2017-01-09 07:03:37'),
(238, 'Ukraine', '+380', 1, '2017-01-09 07:03:37'),
(239, 'United Arab Emirates', '+971', 1, '2017-01-09 07:03:37'),
(240, 'United Kingdom', '+44', 1, '2017-01-09 07:03:37'),
(241, 'United States of America', '+1', 1, '2017-01-09 07:03:37'),
(242, 'US Virgin Islands', '+1', 1, '2017-01-09 07:03:37'),
(243, 'Uruguay', '+598', 1, '2017-01-09 07:03:37'),
(244, 'Uzbekistan', '+998', 1, '2017-01-09 07:03:37'),
(245, 'Vanuatu', '+678', 1, '2017-01-09 07:03:37'),
(246, 'Vatican City', '+376', 1, '2017-01-09 07:03:37'),
(247, 'Venezuela', '+58', 1, '2017-01-09 07:03:37'),
(248, 'Vietnam', '+84', 1, '2017-01-09 07:03:37'),
(249, 'Wake Island', '+808', 1, '2017-01-09 07:03:37'),
(250, 'Wallis and Futuna Islands', '+681', 1, '2017-01-09 07:03:37'),
(251, 'Western Samoa', '+685', 1, '2017-01-09 07:03:37'),
(252, 'Yemen', '+967', 1, '2017-01-09 07:03:37'),
(253, 'Yugoslavia', '+381', 1, '2017-01-09 07:03:37'),
(254, 'Zambia', '+260', 1, '2017-01-09 07:03:37'),
(255, 'Zimbabwe', '+263', 1, '2017-01-09 07:03:37');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_course`
--

CREATE TABLE `tbl_course` (
  `id` int(11) NOT NULL,
  `c_cat_id` int(11) NOT NULL COMMENT 'course_category_id',
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `bg_color` varchar(50) DEFAULT NULL,
  `classroom_title1` varchar(255) DEFAULT NULL,
  `classroom_photo1` varchar(255) DEFAULT NULL,
  `classroom_bg1` varchar(255) DEFAULT NULL,
  `classroom_title2` varchar(255) DEFAULT NULL,
  `classroom_photo2` varchar(255) DEFAULT NULL,
  `classroom_bg2` varchar(255) DEFAULT NULL,
  `classroom_title3` varchar(255) DEFAULT NULL,
  `classroom_photo3` varchar(255) DEFAULT NULL,
  `classroom_bg3` varchar(255) DEFAULT NULL,
  `classroom_title4` varchar(255) DEFAULT NULL,
  `classroom_photo4` varchar(255) DEFAULT NULL,
  `classroom_bg4` varchar(255) DEFAULT NULL,
  `classroom_title5` varchar(255) DEFAULT NULL,
  `classroom_photo5` varchar(255) DEFAULT NULL,
  `classroom_bg5` varchar(255) DEFAULT NULL,
  `classroom_title6` varchar(255) DEFAULT NULL,
  `classroom_photo6` varchar(255) DEFAULT NULL,
  `classroom_bg6` varchar(255) DEFAULT NULL,
  `classroom_title7` varchar(255) DEFAULT NULL,
  `classroom_photo7` varchar(255) DEFAULT NULL,
  `classroom_bg7` varchar(255) DEFAULT NULL,
  `classroom_title8` varchar(255) DEFAULT NULL,
  `classroom_photo8` varchar(255) DEFAULT NULL,
  `classroom_bg8` varchar(255) DEFAULT NULL,
  `online_test_link` varchar(255) DEFAULT NULL,
  `online_test_url` varchar(255) DEFAULT NULL,
  `study_link` varchar(255) DEFAULT NULL,
  `study_url` varchar(255) DEFAULT NULL,
  `correspondence_link` varchar(255) DEFAULT NULL,
  `correspondence_url` varchar(255) DEFAULT NULL,
  `video_link` varchar(255) DEFAULT NULL,
  `video_url` varchar(255) DEFAULT NULL,
  `learn_more` varchar(255) DEFAULT NULL,
  `meta_tag` blob,
  `status` int(2) NOT NULL DEFAULT '0',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_course`
--

INSERT INTO `tbl_course` (`id`, `c_cat_id`, `name`, `slug`, `photo`, `bg_color`, `classroom_title1`, `classroom_photo1`, `classroom_bg1`, `classroom_title2`, `classroom_photo2`, `classroom_bg2`, `classroom_title3`, `classroom_photo3`, `classroom_bg3`, `classroom_title4`, `classroom_photo4`, `classroom_bg4`, `classroom_title5`, `classroom_photo5`, `classroom_bg5`, `classroom_title6`, `classroom_photo6`, `classroom_bg6`, `classroom_title7`, `classroom_photo7`, `classroom_bg7`, `classroom_title8`, `classroom_photo8`, `classroom_bg8`, `online_test_link`, `online_test_url`, `study_link`, `study_url`, `correspondence_link`, `correspondence_url`, `video_link`, `video_url`, `learn_more`, `meta_tag`, `status`, `cdate`) VALUES
(22, 3, 'NIA , NICL , UIIC , GIC- AO', 'nia--nicl--uiic--gic-ao', 'LIC2.png', '1D16FF', 'Classroom Sessions', 'classroom-sessions11.png', 'FFFFFF', 'Daily 2-3 Hrs Classes', '2-3-hrs-classes10.png', 'FFFFFF', 'Specially designed books for each subject', 'specially-designed11.png', 'FFFFFF', 'Online text series of MakemyExam', 'test-series11.png', 'FFFFFF', 'Classesroom Assignments', 'classroom-assignments12.png', 'FFFFFF', 'Doubt Clearing Sessions', 'doubt-clearing-sessions11.png', 'FFFFFF', 'Capsules for GK & Current Affairs', 'capsules11.png', 'FFFFFF', 'Online Support', 'online-support11.png', 'FFFFFF', 'Online Testseries', '', 'Study Material', '', 'Correspondence Course', '', 'Video Course', '', 'https://www.ibtindia.com', '', 1, '2019-01-19 07:18:42'),
(23, 3, 'United India Assistant', 'united-india-assistant', 'united1.png', '1D16FF', 'Classroom Sessions', 'classroom-sessions12.png', 'FFFFFF', 'Daily 2-3 Hrs Classes', '2-3-hrs-classes11.png', 'FFFFFF', 'Specially designed books for each subject', 'specially-designed12.png', 'FFFFFF', 'Online text series of MakemyExam', 'test-series12.png', 'FFFFFF', 'Classesroom Assignments', 'classroom-assignments13.png', 'FFFFFF', 'Doubt Clearing Sessions', 'doubt-clearing-sessions12.png', 'FFFFFF', 'Capsules for GK & Current Affairs', 'capsules12.png', 'FFFFFF', 'Online Support', 'online-support12.png', 'FFFFFF', 'Online Testseries', '', 'Study Material', '', 'Correspondence Course', '', 'Video Course', '', 'https://www.ibtindia.com', '', 1, '2019-01-19 07:20:18'),
(31, 4, 'COMMON ADMISSION TEST', 'common-admission-test', 'cat-2.png', 'FFFFFF', 'Classroom Sessions', 'classroom-sessions20.png', 'FFFFFF', 'Daily 2-3 Hrs Classes', '2-3-hrs-classes19.png', 'FFFFFF', 'Specially designed books for each subject', 'specially-designed20.png', 'FFFFFF', 'Online text series of MakemyExam', 'test-series20.png', 'FFFFFF', 'Classesroom Assignments', 'classroom-assignments21.png', 'FFFFFF', 'Doubt Clearing Sessions', 'doubt-clearing-sessions20.png', 'FFFFFF', 'Capsules for GK & Current Affairs', 'capsules19.png', 'FFFFFF', 'Online Support', 'online-support20.png', 'FFFFFF', 'Online Testseries', '', 'Study Material', '', 'Correspondence Course', '', 'Video Course', '', 'https://www.ibtindia.com', '', 1, '2019-01-19 09:28:52');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_course_category`
--

CREATE TABLE `tbl_course_category` (
  `id` int(11) NOT NULL,
  `course_name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `short_description` text,
  `photo` varchar(255) DEFAULT NULL,
  `target_url` varchar(255) DEFAULT NULL,
  `meta_tag` blob,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_course_category`
--

INSERT INTO `tbl_course_category` (`id`, `course_name`, `slug`, `short_description`, `photo`, `target_url`, `meta_tag`, `status`, `cdate`) VALUES
(1, 'CANADA', NULL, 'IELTS stands for International English Language Testing System. It is a test of English language for students who want to go for Study Abroad.', 'learning1.png', 'ibt-ielts-coaching-jalandhar', NULL, 1, '2018-11-05 06:56:30'),
(2, 'AUSTRALIA', NULL, 'The PTE Academic is a computer-based test of English. It is designed to measure the academic English abilities of candidates.', 'ebook1.png', 'pte-coaching', NULL, 1, '2018-11-05 06:57:25'),
(3, 'USA', NULL, 'In today\'s global society, English is the lingua franca. It\'s almost imperative to know and speak English to feel comfortable in most circles.', 'lecture1.png', 'ibt-spoken-english-classes-jalandhar', NULL, 1, '2018-11-05 06:59:00'),
(4, 'UNITED KINGDOM', NULL, 'CELPIP is an English language proficiency evaluating tool to judge the test-takers efficiency in four components.', 'studying1.png', 'celpip-coaching', NULL, 1, '2018-11-05 06:59:56'),
(5, 'SCHENGEN', NULL, 'Study Abroad gives an opportunity to experience the world as your classroom with variety of courses for the aspirants.', 'travel1.png', 'study-abroad-canada-australia', NULL, 1, '2019-03-29 09:29:06');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_course_zone`
--

CREATE TABLE `tbl_course_zone` (
  `id` int(11) NOT NULL,
  `course_id` int(11) DEFAULT NULL,
  `main_heading` varchar(255) DEFAULT NULL,
  `north_heading` varchar(255) DEFAULT NULL,
  `north_data` text,
  `east_heading` varchar(255) DEFAULT NULL,
  `east_data` text,
  `west_heading` varchar(255) DEFAULT NULL,
  `west_data` text,
  `south_heading` varchar(255) DEFAULT NULL,
  `south_data` text,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_course_zone`
--

INSERT INTO `tbl_course_zone` (`id`, `course_id`, `main_heading`, `north_heading`, `north_data`, `east_heading`, `east_data`, `west_heading`, `west_data`, `south_heading`, `south_data`, `status`, `cdate`) VALUES
(1, 3, 'SBI PO Coaching center in India', 'SBI Coaching in North India', '[{\"title\":\"SBI Coaching in Aligrah\",\"url\":\"#\"},{\"title\":\"SBI Coaching in Delhi_NCR\",\"url\":\"#\"},{\"title\":\"SBI Coaching in Allahabad\",\"url\":\"#\"},{\"title\":\"SBI Coaching in Ghaziabad\",\"url\":\"##\"},{\"title\":\"SBI Coaching in Jhansi\",\"url\":\"##\"},{\"title\":\"SBI Coaching in Gorakhpur\",\"url\":\"##\"}]', 'SBI Coaching in East India', '[{\"title\":\"SBI Coaching in Gaya\",\"url\":\"#\"},{\"title\":\"SBI Coaching in Patna\",\"url\":\"#\"},{\"title\":\"SBI Coaching in Kolkata\",\"url\":\"#\"}]', 'SBI Coaching in West India', '[{\"title\":\"SBI Coaching in Jaipur1\",\"url\":\"#\"},{\"title\":\"SBI Coaching in Gandhinagar\",\"url\":\"#\"}]', 'SBI Coaching in South India', '[{\"title\":\"SBI PO Coaching in Chennai\",\"url\":\"#\"}]', 1, '2018-11-05 11:57:38'),
(2, 4, 'SSC CGLE Coaching center in India', 'SSC Coaching in North India', '[{\"title\":\"SSC Coaching in Aligrah\",\"url\":\"#\"},{\"title\":\"SSC Coaching in Delhi_NCR\",\"url\":\"#\"},{\"title\":\"SSC Coaching in Allahabad\",\"url\":\"#\"},{\"title\":\"SSC Coaching in Ghaziabad\",\"url\":\"##\"},{\"title\":\"SSC Coaching in Jhansi\",\"url\":\"##\"},{\"title\":\"SSC Coaching in Gorakhpur\",\"url\":\"##\"}]', 'SSC Coaching in East India', '[{\"title\":\"SSC Coaching in Gaya\",\"url\":\"#\"},{\"title\":\"SSC Coaching in Patna\",\"url\":\"#\"},{\"title\":\"SSC Coaching in Kolkata\",\"url\":\"#\"}]', 'SSC Coaching in West India', '[{\"title\":\"SSC Coaching in Jaipur1\",\"url\":\"#\"},{\"title\":\"SSC Coaching in Gandhinagar\",\"url\":\"#\"}]', 'SSC Coaching in South India', '[{\"title\":\"SSC Coaching in Chennai\",\"url\":\"#\"},{\"title\":\"ssc coaching karnataka\",\"url\":\"\"}]', 1, '2018-11-05 12:19:29'),
(6, 2, 'IBPS-CLERK Coaching center in India', 'IBPS-CLERK Coaching in North India', '[{\"title\":\"IBPS-CLERK Coaching in Aligrah\",\"url\":\"#\"},{\"title\":\"IBPS-CLERK Coaching in Delhi_NCR\",\"url\":\"#\"},{\"title\":\"IBPS-CLERK Coaching in Allahabad\",\"url\":\"#\"},{\"title\":\"IBPS-CLERK Coaching in Ghaziabad\",\"url\":\"##\"},{\"title\":\"IBPS-CLERK Coaching in Jhansi\",\"url\":\"##\"},{\"title\":\"IBPS-CLERK Coaching in Gorakhpur\",\"url\":\"##\"}]', 'IBPS-CLERK Coaching in East India', '[{\"title\":\"IBPS-CLERK Coaching in Gaya\",\"url\":\"#\"},{\"title\":\"IBPS-CLERK Coaching in Patna\",\"url\":\"#\"},{\"title\":\"IBPS-CLERK Coaching in Kolkata\",\"url\":\"#\"}]', 'IBPS-CLERK Coaching in West India', '[{\"title\":\"IBPS-CLERK Coaching in Jaipur1\",\"url\":\"#\"},{\"title\":\"IBPS-CLERK Coaching in Gandhinagar\",\"url\":\"#\"}]', 'IBPS-CLERK Coaching in South India', '[{\"title\":\"IBPS-CLERK Coaching in Chennai\",\"url\":\"#\"}]', 1, '2018-11-12 05:09:15'),
(7, 1, 'IBPS-PO Coaching center in India', 'IBPS-PO Coaching in North India', '[{\"title\":\"IBPS-PO Coaching in Aligrah\",\"url\":\"http:\\/\\/google.com\"},{\"title\":\"IBPS-PO Coaching in Delhi_NCR\",\"url\":\"#\"},{\"title\":\"IBPS-PO Coaching in Allahabad\",\"url\":\"#\"},{\"title\":\"IBPS-PO Coaching in Ghaziabad\",\"url\":\"##\"},{\"title\":\"IBPS-PO Coaching in Jhansi\",\"url\":\"##\"},{\"title\":\"IBPS-PO Coaching in Gorakhpur\",\"url\":\"##\"}]', 'IBPS-PO Coaching in East India', '[{\"title\":\"IBPS-PO Coaching in Gaya\",\"url\":\"#\"},{\"title\":\"IBPS-PO Coaching in Patna\",\"url\":\"#\"},{\"title\":\"IBPS-PO Coaching in Kolkata\",\"url\":\"#\"}]', 'IBPS-PO Coaching in West India', '[{\"title\":\"IBPS-PO Coaching in Jaipur1\",\"url\":\"#\"},{\"title\":\"IBPS-PO Coaching in Gandhinagar\",\"url\":\"#\"}]', 'IBPS-PO Coaching in South India', '[{\"title\":\"IBPS-PO Coaching in Chennai\",\"url\":\"#\"}]', 1, '2018-11-15 08:29:08'),
(8, 10, 'Our Centers', 'East Center', '[{\"title\":\"IBT Kolkat Center\",\"url\":\"ibtindia.com\"}]', '', 'null', '', 'null', '', 'null', 1, '2019-01-10 10:40:43');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_document`
--

CREATE TABLE `tbl_document` (
  `id` int(11) NOT NULL,
  `document_file` varchar(255) NOT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_document`
--

INSERT INTO `tbl_document` (`id`, `document_file`, `status`, `cdate`) VALUES
(8, 'IBT_IELTS_PROPOSAL_-_Mohan_New.pdf', 1, '2019-08-10 05:37:56'),
(9, 'IBT_IELTS_PROPOSAL_-_Version_1_1.pdf', 1, '2019-08-10 05:38:09'),
(10, 'IBT_IELTS_PROPOSAL_-_Punjab_Version_1_1.pdf', 1, '2019-08-20 09:52:11'),
(12, 'IBT_IELTS_PROPOSAL_-_India-_Version_1_1.pdf', 1, '2019-08-20 09:53:48'),
(15, 'IBT_IELTS_PROPOSAL_-_India_-Version_1_2.pdf', 1, '2019-09-04 06:10:11'),
(16, 'IBT_IELTS_PROPOSAL_-_Punjab_-Version_1_2.pdf', 1, '2019-09-04 06:10:22'),
(17, 'IBT_IELTS_PROPOSAL_-_Punjab_-Version_1_21.pdf', 1, '2019-10-02 10:05:22');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_download`
--

CREATE TABLE `tbl_download` (
  `id` int(11) NOT NULL,
  `d_cat_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `month` varchar(50) DEFAULT NULL,
  `year` varchar(50) DEFAULT NULL,
  `magazine` varchar(255) DEFAULT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_download`
--

INSERT INTO `tbl_download` (`id`, `d_cat_id`, `title`, `month`, `year`, `magazine`, `status`, `cdate`) VALUES
(19, 7, 'IDP Awards 2019 Touchstone Educationall', NULL, NULL, 'vid_1.jpg', 1, '2019-02-15 10:57:07'),
(20, 7, 'IDP Awards 2019 Touchstone Educational', NULL, NULL, 'course-pic-1.png', 1, '2019-02-15 11:02:13'),
(21, 7, 'IDP Awards 2019 Touchstone Educationall	', NULL, NULL, 'vid_3.jpg', 1, '2019-02-15 11:02:34'),
(22, 8, 'IDP Awards 2018 Touchstone Educationall	', NULL, NULL, 'vid_4.jpg', 1, '2019-02-15 11:02:53'),
(23, 9, 'IDP Awards 2017 Touchstone Educational', NULL, NULL, 'DJ7n-31VoAAfU0k.jpg', 1, '2019-02-15 11:06:35'),
(24, 9, 'IDP Awards 2017 Touchstone Educationall	', NULL, NULL, '37bc171bbec873547ca19161aaf1b1d43acf66d8d0482b1427f6d51034165919-770x443.jpg', 1, '2019-02-15 11:06:52'),
(25, 10, 'IDP Awards 2019 Touchstone Educational', NULL, NULL, 'vid_5c651cf25405d.jpg', 1, '2019-02-15 11:07:25');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_download_category`
--

CREATE TABLE `tbl_download_category` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `type` enum('month_year','no_month_year') NOT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_download_category`
--

INSERT INTO `tbl_download_category` (`id`, `title`, `slug`, `photo`, `type`, `status`, `cdate`) VALUES
(7, '2019', NULL, NULL, 'month_year', 1, '2019-02-15 10:54:28'),
(8, '2018', NULL, NULL, 'month_year', 1, '2019-02-15 10:54:33'),
(9, '2017', NULL, NULL, 'month_year', 1, '2019-02-15 10:54:38'),
(10, '2016', NULL, NULL, 'month_year', 1, '2019-02-15 10:54:43');

-- --------------------------------------------------------

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

CREATE TABLE `tbl_enquiry` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(50) NOT NULL,
  `contact_number` varchar(50) NOT NULL,
  `city` varchar(255) DEFAULT NULL,
  `message` text,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_enquiry` (`id`, `name`, `email`, `contact_number`, `city`, `message`, `status`, `cdate`) VALUES
(2, 'Arun', 'anranya@gmail.com', '9711652294', 'Noida', 'dsfsd', 1, '2019-03-26 13:23:25'),
(3, 'Subhkanteshwarm ', 'subhkanteshwarm@gmail.com', '9415246175', 'Varanasi', 'For canada PR I wish to join your institution.', 1, '2020-04-15 13:27:59');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_enquiry_contactus`
--

CREATE TABLE `tbl_enquiry_contactus` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `contact_number` varchar(50) DEFAULT NULL,
  `course` varchar(100) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `center` varchar(255) DEFAULT NULL,
  `type` int(2) NOT NULL DEFAULT '1',
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_enquiry_franchise`
--

CREATE TABLE `tbl_enquiry_franchise` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `proposes_address` varchar(255) NOT NULL,
  `contact_number` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `social_plateform` varchar(100) DEFAULT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_exam_pre`
--

CREATE TABLE `tbl_exam_pre` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `target_url` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_exam_pre`
--

INSERT INTO `tbl_exam_pre` (`id`, `title`, `description`, `target_url`, `photo`, `icon`, `status`, `cdate`) VALUES
(3, 'Canada', '<h2>WHAT IS IELTS</h2>\r\n\r\n<p style=\"margin-left:0px; margin-right:0px\">The International English Language Testing System, or IELTS, as it is popularly called, is an English Language proficiency test that is required to be taken by non-native students so as to study in countries where the medium of instruction is English. IELTS is accepted by Universities in UK, Australia, New Zealand and Canada. It has become a mandatory test for study in Australia. One cannot be granted an Australian Student Visa without an IELTS Score. All other study destinations require one to appear for either the TOEFL or the IELTS. The IELTS tests all four language skills that are important for effective communication: speaking, listening, reading, and writing.</p>\r\n', '##', '04_new.png', '<i class=\"fa fa-university\"></i>', 1, '2018-11-13 13:34:02'),
(4, 'Australia', '<h2>READING</h2>\r\n\r\n<p style=\"margin-left:0px; margin-right:0px\"><strong>Academic Reading test</strong> comprises of 40 questions, which are to be solved within 60 minutes. All together there are 3 passages and on an average there will be 11 to 12 questions in each passage, with the allotment of 20 minutes time for each passage. All the passages are of same difficulty level and the length will be of approximately 800-900 words.<br />\r\n<strong>General Training Reading test</strong> comprises of 40 questions, which are to be solved within 60 minutes. All together there are 3 sections and on an average there will be 7 to 8 questions in each sub-section of section 1 &2, and around 11 to 12 questions in section 3. The content of the sections will be in relevance to some factual texts like adverts or work related issues.</p>\r\n', '#', '01_new.png', '<i class=\"fa fa-book\" aria-hidden=\"true\"></i>', 1, '2018-11-13 13:34:54'),
(5, 'New Zeeland', '<h2>WRITING</h2>\r\n\r\n<p style=\"margin-left:0px; margin-right:0px\"><strong>In Writing module, </strong>there will be Task 1 and Task 2. The test time for writing module is 60 minutes where one has to spend 20 minutes on WT1 and 40 minutes on WT2. In WT1, there will be Report Writing for Academic student in which data will be provided in the form of Pie chart, Bar graph, Tabular data, Line graph, Map and Pictorial data whereas Letter Writing for General Training candidate in which there will be 3 types of letter i.e. Formal , Informal and semi-formal whilst.<br />\r\nWriting Task 2 is Essay Writing, which is same for Academic and General Training students which covers debatable questions, argumentary topics, Current affairs, Opinion based question etcetera.</p>\r\n', '#', '02_new.png', '<i class=\"fa fa-pencil\" aria-hidden=\"true\"></i>', 1, '2018-11-13 13:36:08'),
(7, 'UK', '<h2>LISTENING</h2>\r\n\r\n<p style=\"margin-left:0px; margin-right:0px\"><strong>Listening module</strong> consists of 40 questions, where one has to listen to the conversation for 30 minutes and later the student will get 10 minutes to transfer the answers on the answer sheet.<br />\r\nIn listening module, 40 questions are divided into 4 parts and there will be 10 questions in each section. Moreover, the conversations will be based on booking arrangements, student services, research projects, university lectures and many more.</p>\r\n', '#', '03_new.png', '<i class=\"fa fa-headphones\" aria-hidden=\"true\"></i>', 1, '2018-11-13 13:59:28'),
(8, ' Europe', '<h2>SPEAKING</h2>\r\n\r\n<p style=\"margin-left:0px; margin-right:0px\">In <strong>Speaking Module</strong>, there will be one to one interaction with the examiner for 11-14 minutes. There are 3 parts in the speaking test, where 1<sup>st</sup> part is about the personal interview questions and other general questions related to any topic, in 2<sup>nd</sup> part, a cue card means a topic is given to the candidate on which one has to speak for 90-120 seconds after the completion of preparation time of 60 seconds, and in the last part, follow up questions related to the cue card will be asked from the candidate.</p>\r\n', '#', '05_new.png', '<i class=\"fa fa-volume-up\" aria-hidden=\"true\"></i>', 1, '2019-02-08 08:08:05');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_faq`
--

CREATE TABLE `tbl_faq` (
  `id` int(11) NOT NULL,
  `faq_cat_id` int(11) NOT NULL,
  `question` text NOT NULL,
  `answer` text NOT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_faq`
--

INSERT INTO `tbl_faq` (`id`, `faq_cat_id`, `question`, `answer`, `status`, `cdate`) VALUES
(15, 1, 'WHERE CAN I TAKE IELTS?', 'IDP: IELTS Australia offers over 200 test locations in 50 countries. Find a test centre near you. IELTS is available on 48 fixed dates a year – up to four times a month on Thursdays and Saturdays, depending on local demand. Click here for a list of test dates then contact a test centre to book your test.', 1, '2019-04-05 10:50:37'),
(16, 1, 'HOW MUCH DOES IT COST?', 'The Academic and General Training tests are the same cost. The test fee in india 13250/- RS. Wef. 1st April 2019.', 1, '2019-04-05 10:50:57'),
(17, 1, 'HOW LONG IS AN IELTS SCORE VALID?', 'An IELTS Test Report Form (TRF) is valid for two (2) years.', 1, '2019-04-05 10:51:19'),
(18, 1, 'WHAT IS THE AGE LIMIT OF TAKING IELTS?', 'You must be atleast 16 years old to write an IELTS exam.', 1, '2019-04-05 10:51:38'),
(19, 1, 'HOW DO I BOOK/REGISTER MY TEST?', 'You may either book your IELTS test online or visit your nearest IDP branch to book it offline. Here’s how: Log on to our IELTS India website. Select the option ‘Register for Test.’ Select your preferred test – computer-delivered IELTS/ paper-based (IELTS, IELTS for UKVI or Life Skills). Select your test type/module – Academic or General Training for IELTS, IELTS for UKVI, A1 and B1 for Life Skills (be extremely careful while choosing the module you wish to take). Pick your desired test location/city (from the available IELTS test centres in India). Once done, you will find a list of dates available for your preferences. Select your desired date and time slot. Fill up the required details and complete your online application. Remember, you will also have to upload a clear, scanned colour copy of your passport to complete the process. Proceed to pay the test fee.', 1, '2019-04-05 10:52:06'),
(20, 1, 'WHAT IF I NEED TO POSTPONE OR CANCEL MY TEST?', 'IELTS has a strict booking and cancellation policy to be fair to all of our test takers. Changing any of your booking details can be done through the test centre where you booked your test. If you postpone or cancel your application more than five weeks before the test date, you will receive a refund, minus an administration charge. If you postpone or cancel within five weeks of the test date, you will be charged the full fee unless you have a serious medical reason. If you provide a medical certificate within five days of the test date, we will be happy to provide you with a refund minus the local administrative cost.', 1, '2019-04-05 10:53:13'),
(22, 1, 'WHAT CAN I TAKE INTO EXAMINATION ROOM?', 'Only pens, pencils and erasers. You must bring the valid passport/national identity card you used on the IELTS Application Form with you to the test. You must leave everything else outside the examination room. Mobile phones and pagers must be switched off and placed with personal belongings in the area designated by the supervisor. If you do not switch off your phone/pager or if you keep it with you, you will be disqualified.', 1, '2019-04-05 10:54:07'),
(23, 1, 'WHICH PART DO I TAKE FIRST?', 'The Listening, Reading and Writing tests must be completed on the same day. The order in which these tests are taken may vary. Depending on the test centre, the Speaking test may be taken up to 7 days either before or after the test date.', 1, '2019-04-05 10:54:24'),
(24, 1, 'WHAT DO I NEED FOR SPEAKING TEST?', 'You must bring the same identification documents (ID) you supplied on your IELTS Application Form and continue to use the same ID for each part of the test. Your ID will be checked before you enter the interview room', 1, '2019-04-05 10:54:43'),
(25, 1, 'DO I HAVE TO WRITE IN PENCIL?', 'Typically pencil has always been recommended for the IELTS Listening and Reading of the test.  In many test centres, we now also require the Writing test to be completed in pencil. This is because gradually, all of our test centres are upgrading to new scanners. These particular scanners work best with a pencil as there is no risk of your answers smudging (whereas there is with pen/ink). These test centres are also using answers sheets with a slightly updated design.  We would like to emphasise that no changes have been made to the test format, content, or marking standards. This is simply an operational change. It is also important to note that if you forget to bring a pencil, the test centre staff can provide a pencil for you.', 1, '2019-04-07 05:32:50'),
(26, 1, 'HOW ARE THE TEST MARKED?', 'IELTS uses a 9-band scoring system to measure and report test scores in a consistent manner. You receive individual band scores for Listening, Reading, Writing and Speaking and an Overall Band Score on a band scale from one to nine.', 1, '2019-04-07 05:33:17'),
(27, 1, 'WHEN WILL I RECEIVE MY TEST SCORES?', 'Your Test Report Form will be available to you 13 calendar days after your test date. You will only receive one copy of your Test Report Form, unless you are applying to Citizenship and Immigration Canada (CIC), or United Kingdom Visas and Immigration (UKVI) – in this case, you can receive two. Some test centres provide SMS alerts and you can preview your results online.', 1, '2019-04-07 05:34:04'),
(28, 1, 'HOW MANY TEST REPORT FORM (TRFs) AM I ENTITLED TO?', 'You will only receive one copy of your Test Report Form – unless you are applying to Citizenship and Immigration Canada (CIC) or United Kingdom Visas and Immigration (UKVI) – in this case, you can receive two. Up to five (5) copies of your TRF will be posted to the relevant institution(s) you have listed on your IELTS application form. Regular postage is free of charge. Charges for courier services and/or overseas postage will be passed onto you. Additional TRFs beyond these five can be requested from the test centre which issued the TRF. Please note, an administration fee may be charged for additional TRFs. If you have lost your TRF, please contact the test centre which issued your TRF.', 1, '2019-04-07 05:34:45'),
(29, 1, 'WHICH IS BEST FOR IELTS, IDP OR BCD?', 'There is no difference between the IELTS test at the BC and in IDP. There is also no difference between examiners and marking in the BCD and IDP.', 1, '2019-04-07 05:35:06'),
(30, 1, 'HOW CAN I IMPROVE MY WRITING SCORE?', 'It is vital to fulfil the Writing task, especially Task 2, in order to demonstrate your skills. Writing Task 2 is worth twice as many marks as Task 1. 25 percent of the Writing score for Task 2 (GT and Academic) is based on the completeness of the response. Make sure you respond to all parts of the task. This criterion is referred to as “Task Response”. If all parts of the Writing Task 2 are addressed, a person will score band 6 or higher for this quarter of their Task 2 score. If the task is not fully addressed, an examiner must award less than band 6 for this criterion. So responding to every individual part of a Writing task is very important. The remaining 75 percent of the score for Task 2 in Writing is based on vocabulary, accurate grammar and the structure and linking of ideas. Read the assessment criteria used for Academic and General Training writing tests carefully before your test day.', 1, '2019-04-07 05:35:32'),
(31, 4, 'WHICH TEST IS BEST FOR ME, IELTS OR COMPUTER DELIVERED IELTS?', 'This comes down to personal preference and choice. Some test takers will be used to paper-based tests as this might feel similar to other exam situations from school, whereas other people might feel more comfortable typing. ', 1, '2019-04-07 05:36:16'),
(32, 4, 'IS IELTS ON A COMPUTER IS HARDER THAN IELTS PAPER BASED?', 'No. The computer-delivered test will cover the listening, reading and writing skills. The test will be the same as paper-based IELTS in terms of content, scoring, level of difficulty and question types. The Speaking test is not changing and will still be carried out face-to-face with a trained IELTS Examiner.', 1, '2019-04-07 05:36:49'),
(33, 4, 'CAN I BRING MY OWN LAPTOP/KEYBOARD?', 'No. There is no need to bring your own keyboard or laptop as all equipment is provided by the test centre and no other equipment is permitted.', 1, '2019-04-07 05:37:20'),
(34, 4, 'IS COMPUTER DELIVERED IELTS IS AVAILABLE ON DEMAND?', 'Computer-delivered IELTS is not available on demand at present. Registration for computer-delivered IELTS is the same as for paper-based IELTS.', 1, '2019-04-07 05:37:55'),
(35, 4, 'DOES COMPUTER DELIVERED IELTS MEAN I’ll GET MY RESULT FASTER?', 'If you take the computer-delivered IELTS test then you will receive your results five to seven days after you complete the last section of your test.', 1, '2019-04-07 05:38:19'),
(36, 5, 'Do I need computer skills to take the test?', 'You do not need any special computer skills.  PTE Academic is taken using a QWERTY keyboard, where the letters on the top line spell out ‘QWERTY’. IF you are not used to this type of keyboard, it may help to practice with one before you take the test.', 1, '2019-04-07 06:21:00'),
(37, 5, 'HOW MUCH DOES IT COST?', 'The test fee in India is Rs.13300/-.', 1, '2019-04-07 06:21:20'),
(38, 5, 'How old do I need to be to take PTE Academic?', 'You must be at least 16 years old. If you are 16 or 17 years old, you must provide a signed parental consent form before taking the test. Complete the form, then follow the instructions printed on it to send it to us.', 1, '2019-04-07 06:23:27'),
(39, 5, 'WHAT IF I NEED TO CANCEL MY TEST?', 'To cancel your scheduled test, click on “Cancel” next to the relevant test. If you cancel more than seven calendar days before your test date, you will be entitled to a 50% refund. If you cancel seven calendar days or less before the test date, you will not receive a refund and must pay a new test fee if you wish to take the test in the future.', 1, '2019-04-07 06:24:23'),
(40, 5, 'WHAT IF I NEED TO POSTPONE MY TEST?', 'Rescheduling your test means that you keep the test you have scheduled, but change the date, time or location (within the same country). To reschedule your test, click on “Reschedule” next to the relevant test and follow the same steps you took when you initially booked the test. If you reschedule more than seven calendar days before your test date, you will pay an additional 25% of the test fee. If you reschedule seven calendar days or less before the test date, you will have to pay a new test fee in full. If you do not attend your test at the scheduled time, date and location, it will be recorded as a “No show.” You will not receive a refund of your test fee. To take the test, you will need to schedule a new test and pay the fee again.', 1, '2019-04-07 06:24:50'),
(41, 5, 'Will I be penalised in speaking tasks for not having an accent from a native English speaking country?', 'No. PTE Academic has been designed to recognise speech from non-native speakers of English representing over 100 different native languages.', 1, '2019-04-07 06:25:34'),
(42, 5, 'Are all communicative skills scores (e.g. reading, writing) weighted equally?', 'Yes', 1, '2019-04-07 06:25:52'),
(43, 5, 'How many times can I take the test?', 'You can take PTE Academic as many times as you like. You must wait to receive your scores before you can book your next test.', 1, '2019-04-07 06:26:13'),
(44, 5, 'Do I have to take PTE Academic in my home country?', 'No. You can take it at any of our test centers around the world. Make sure you check what type of ID you have to use. Refer to the Acceptable ID policy. If you are outside your home country, you will probably be asked to show your passport at the test center.', 1, '2019-04-07 06:26:52'),
(45, 5, 'Can I register directly with the test center?', 'No. You can register for the test online or by phone through PTE call centers. Contact the customer service team in your region.', 1, '2019-04-07 06:27:16'),
(46, 5, 'How do I book a PTE Academic test?', 'Important: Please ensure your name on your ID matches your PTE-A registration name, otherwise you may not be permitted to enter the exam. If you don’t have a Pearson account: Go to http://pearsonpte.com/book-now/ read all the information on the page. In order to book your PTE Academic test, you will need to complete the following: 1.Click ‘Sign in Now’ & enter your details. Once you have successfully logged in, click ‘PTE-A: Pearson Test of English Academic’ under Exam Catalogue. 2.Select ‘Schedule Exams’ on the right hand side. 3.Provide answers to all the required questions then click ‘Next’ 4.Select your desired location and click ‘Next’. Search for available dates and times. 5.Once you have confirmed your location, date & time you will be asked to review your booking information and proceed to checkout. 6.Confirm all the details and make full payment to secure your booking. 7.Once you have completed your booking you will receive an email confirmation. The email will contain details on test center location, directions of how to get there and a few points to remember on the test day. For both cases ensure you have read the ID policy on the following page www.pearsonpte.com/acceptable-id/ and that your ID is valid at the time of registration and on the day of the test.', 1, '2019-04-07 06:33:00'),
(47, 5, 'What documents can I use as ID at the test center?', 'You should show your passport when arriving at the test center.', 1, '2019-04-07 06:33:31'),
(48, 5, 'What happens if there is a problem with my computer during the test?', 'Raise your hand and tell the test administrator. They will do whatever they can to help and will ensure the problem is recorded and reported. Make sure you tell the test administrator about any problems you feel affect your ability to complete the test. Without their record of the problem, it is very hard for us to trace these issues later on', 1, '2019-04-07 06:34:02'),
(49, 6, ' What is the connection between CELPIP and Immigration, Refugees and Citizenship Canada (IRCC)?', 'The CELPIP Test is designated by Immigration, Refugees and Citizenship Canada (IRCC). The CELPIP-General Test is proof of English language proficiency for permanent resident status in Canada and the CELPIP-General LS Test is proof of Listening and Speaking proficiency for Canadian citizenship. ', 1, '2019-04-07 06:35:15'),
(50, 6, 'How do I register for a test?', '1.Online (Recommended) 2.By mail (For registrations in Canada only) Download a CELPIP Registration Form. Complete and submit the CELPIP Registration Form by mail. 3.In person at the CELPIP Head Office in Vancouver, British Columbia, or at the Paragon Office in Toronto, Ontario Please note that CELPIP Test Centres do not process any registration applications. All registrations are completed through Paragon’s CELPIP Office by any of the methods listed above.', 1, '2019-04-07 06:36:11'),
(51, 6, 'How much does the test cost? How do I pay?', 'For information on test fees, see  https://www.celpip.ca/test-locations-fees/ Celpip accept the following forms of payment: Online: VISA®, MasterCard®, American Express®,  PayPal® By Mail: Money Orders If you do not have a credit card for online payment, it do recommend prepaid credit cards such as Mastercard® Prepaid Cards or Visa® Gift Cards. Full payment must be made with one card only. You can register and pay in person at either of their head offices which are located in Vancouver, BC and Toronto, ON.', 1, '2019-04-07 06:36:55'),
(53, 6, ' How do I change or cancel my test date?', 'Your registration for a Test Session is specific to the session (date, time and location) specified in the registration. You may not cancel or transfer your registration for a Test Session except in accordance with this Policy. Cancellation Before Test Session is Held If you are unable to attend a Test Session for which you are registered, you may request a cancellation of the registration in your CELPIP Account. If your cancellation request is received by Paragon at least nine (9) calendar days before the date of the Test Session, then Paragon will grant your cancellation request and provide you with a refund of fifty percent (50%) of the fee you paid for the Test Session registration. If your cancellation request is received by Paragon less than nine (9) calendar days before the date of the Test Session, then Paragon will grant your cancellation request and you will not receive any refund of the fee that you paid for the cancelled Test Session registration. Transfer Before Test Session is Held If you are unable to attend a Test Session then you may transfer to another Test Session in your CELPIP Account for the same type of Test to which the original Test Session applied. If your transfer request is received by Paragon at least nine (9) calendar days before the date of the Test Session and Paragon grants your transfer request, then you will be required to pay a transfer fee of $50.00 CAD plus applicable taxes. If your transfer request is received by Paragon less than nine (9) calendar days before the date of the Test Session contact Paragon’s customer service at 778-327-6854 or info@celpip.ca. Paragon in its discretion may require that you support your transfer request with appropriate documentation (e.g. doctor’s note or evidence of bereavement) confirming the reason for the transfer request in form and content satisfactory to Paragon. Paragon in its discretion will determine whether to grant or refuse your request for the transfer of a Test Session registration.', 1, '2019-04-07 06:38:44'),
(54, 6, 'What if I haven’t received (or have lost) my Test Confirmation Email?', 'A test confirmation email is sent to each test taker who has successfully registered for a CELPIP Test. If you have not received (or have lost) your test confirmation email, please: 1.Check you email junk folder, or 2.Contact CELPIP office.', 1, '2019-04-07 06:39:30'),
(55, 6, ' Since the CELPIP Test is fully computer delivered, can I take this test remotely?', 'The CELPIP Test is fully computer delivered. However, the test must be completed in person at one of their test centres.', 1, '2019-04-07 06:39:49'),
(56, 6, '  I don’t live in Canada. Can I take the test in my country?', 'CELPIP Tests are now available internationally, with test sittings now available in India, Dubai, UAE, New York, USA, and Manila, Philippines. Please check their website often for updates regarding new testing locations. See https://www.celpip.ca/test-locations-fees/', 1, '2019-04-07 06:40:09'),
(57, 7, 'Is speaking English grammar necessary?', 'Using correct grammar is important when you speak English. If you use incorrect tenses or word forms it could be very confusing for the person you are speaking to. But, you don\'t have to understand much about grammar to speak correctly.', 1, '2019-04-07 06:46:21'),
(58, 7, 'What is grammar and why is it important?', 'Grammar is important because it provides information that helps the reader\'s comprehension. It is the structure that conveys precise meaning from the writer to the audience. Eliminate grammatical errors from your writing, and reward your readers with clear communication.', 1, '2019-04-07 06:46:40'),
(59, 7, 'Is grammar necessary to learn a language?', 'Making grammatical mistakes when we speak or write is a natural part of learning a language and this is fine but to improve our production skills (writing and speaking), learning grammar is essential. Grammar is the building blocks of any language and necessary for us to convey what we want to say properly.', 1, '2019-04-07 06:46:59'),
(60, 7, 'Do all languages have the same parts of speech?', 'Not all languages have the same parts of speech. ... A common assertion is that all languages have at least nouns and verbs. It is true that all languages have some means of conveying information as a concept or as an event, but what a noun or verb is differs from language to language.', 1, '2019-04-07 06:47:21'),
(61, 7, 'What are the benefits of speaking English?', 'But regardless of your reason for choosing to learn to speak English, just learning a second language has huge neurological benefits: it allows your brain to work in different ways, expanding your potential and intelligence', 1, '2019-04-07 06:48:18'),
(62, 7, 'What is important for speaking English?', 'Don\'t Study Grammar Too Much. The key to learning a language is finding a balance between studying and practicing. Fluent English speaking isn\'t the same as knowing perfect English grammar—even native English speakers make grammar mistakes! Fluency is about being able to communicate.', 1, '2019-04-07 06:48:57'),
(63, 7, 'Can I speak English fluently?', 'You can speak fluently when you learn lots of grammar and vocabulary but even then sometimes you find it difficult to make sentences. ... for some people speaking English fluently just means having a good general level of English. However fluency is more specific than that of fluency which means you can speak smoothly without stopping or hesitating.', 1, '2019-04-07 06:49:17'),
(64, 7, 'How can I avoid grammar mistakes when speaking English?', 'Rules of error-free speaking and writing 1.Use simple language. Some beginners try to build very complicated sentences with things like the present perfect tense or conditionals. ... 2.Be slow and careful. ... 3.If you\'re not sure how to say something, don\'t say it. ... 4.When writing, always look things up. ... 5.Know where you can screw up.', 1, '2019-04-07 06:51:11'),
(65, 7, 'What are the common mistakes in English?', '1.Subject-Verb Agreement Errors 2.Sentence Fragments 3.Missing Comma After Introductory Element 4.Misusing The Apostrophe With “Its” 5.No Comma In A Compound Sentence 6.Misplaced Or Dangling Modifier 7.Vague Pronoun Reference 8.Wrong Word Usage 9.Run-On Sentence 10.Superfluous Commas 11.Lack Of Parallel Structure 12.Sentence Sprawl 13.Comma Splice 14.Colon Mistakes 15.Split Infinitives', 1, '2019-04-07 06:55:17'),
(66, 8, 'What is the TOEFL test?', 'The TOEFL (Test of English as a Foreign Language) test measures the ability of non-native English speakers to use and understand the English language as it is heard, spoken, read and written in the university classroom. It has several advantages over other English language tests, and helps you to stand out among other applicants.', 1, '2019-04-07 06:56:57'),
(67, 8, 'What is the difference between the TOEFL iBT® test and TOEFL® paper-delivered testing?', 'The TOEFL iBT test, delivered via the internet, measures reading, listening, speaking and writing skills. It is offered more than 50 times a year and is administered online at testing sites around the world. The TOEFL PBT test, which has been discontinued, was a paper-and-pencil test that measured reading, listening, grammar and writing skills and was offered only in locations where testing via the internet is not available. The revised TOEFL Paper-delivered Test, which replaced the TOEFL PBT test, measures reading, listening and writing. There is no speaking component because of the technical requirements of capturing spoken responses.', 1, '2019-04-07 06:59:34'),
(68, 8, 'Where are TOEFL test scores accepted?', 'TOEFL scores are accepted by more than 10,000 universities and other institutions worldwide, including universities in Australia, Canada, New Zealand, the U.K., the United States, and across Europe and Asia.', 1, '2019-04-07 06:59:55'),
(69, 8, 'How often is the test given?', 'The TOEFL iBT test is given on fixed dates, more than 50 times a year. Visit given link to select your test location and date https://www.ets.org/bin/getprogram.cgi?test=toefl', 1, '2019-04-07 07:00:13'),
(70, 8, 'Can I take the entire test in 1 day?', 'Yes, the test is given in 1 day. The test takes about 4 hours, but with check-in you should plan to be at the test center for at least 4½ hours.', 1, '2019-04-07 07:00:32'),
(71, 8, 'Can I retake the test?', 'Yes, you can. There is no limit to the number of times you can take the test, but you cannot take it more than once in a 12-day period. If you already have a test appointment, you cannot register for another test date that is within 12 days of your existing appointment. The registration fee is due each time you register for a test date.', 1, '2019-04-07 07:00:58'),
(72, 8, 'Why should I choose the TOEFL test over another test?', 'Compared to other English-language tests, the TOEFL test includes a number of advantages that will help you stand out from other applicants. ', 1, '2019-04-07 07:01:15'),
(73, 8, 'What is difference between GRE and Toefl?', 'The TOEFL and GRE are both tests many people looking to attend grad school need to take, but the two tests serve different purposes. The GRE is used to determine how prepared a test-taker is for graduate-level coursework, while the TOEFL measures English language skills. ... It\'s possible you may have to take both exams.', 1, '2019-04-07 07:01:34');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_faq_category`
--

CREATE TABLE `tbl_faq_category` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_faq_category`
--

INSERT INTO `tbl_faq_category` (`id`, `name`, `status`, `cdate`) VALUES
(1, 'IELTS', 1, '2019-02-16 05:59:58'),
(4, 'CD-IELTS', 1, '2019-02-16 06:05:03'),
(5, 'PTE', 1, '2019-04-05 10:39:04'),
(6, 'CELPIP', 1, '2019-04-05 10:44:30'),
(7, 'Spoken English', 1, '2019-04-07 06:45:41'),
(8, 'TOEFL', 1, '2019-04-07 06:55:45');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_franchise`
--

CREATE TABLE `tbl_franchise` (
  `id` int(11) NOT NULL,
  `main_heading` varchar(255) DEFAULT NULL,
  `description` text,
  `target_url` varchar(255) DEFAULT NULL,
  `video_url` varchar(255) DEFAULT NULL,
  `banner_content` longtext,
  `why_ibt` longtext,
  `application_procedure` longtext,
  `videos` longtext,
  `meta_tag` longtext,
  `status` int(2) DEFAULT NULL,
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_franchise`
--

INSERT INTO `tbl_franchise` (`id`, `main_heading`, `description`, `target_url`, `video_url`, `banner_content`, `why_ibt`, `application_procedure`, `videos`, `meta_tag`, `status`, `cdate`) VALUES
(1, 'Become an IBT Business Partner', 'Love for teaching, an entrepreneurial attitude, and a desire to be the best, these are some of the ingredients that make a successful edupreneur.\r\nIf this sounds like you, join us and open your own IELTS, CELPIP, TOEFL, Spoken English, PTE Institute.\r\n', '#', 'https://www.youtube.com/embed/-AW8DKZGvFM', '[{\"title\":\"Is teaching your passion?\",\"subtitle\":\"Make it your Business\",\"url\":\"#\"},{\"title\":\"An Investment in Education builds nation\",\"subtitle\":\"Just us in building nation\",\"url\":\"#\"}]', '[{\"title\":\"Student\\u2019s Success\",\"description\":\"IBT works for the single goal i.e Student\\u2019s Success. We put best of our efforts to get best selections. Our success is based on student\\u2019s success only.\",\"image\":\"Student-Success.png\"},{\"title\":\"Academic brilliance\",\"description\":\"With the continuous improvement in course curriculum, Faculty training and quality enhancement we have achieved academic brilliance\",\"image\":\"Academic-brilliance.png\"},{\"title\":\"Best ROI\",\"description\":\"Grab an opportunity to earn name and fame by joining hands with IBT. Earn the respect of your peers, contribute to the growth of your community, and reap financial rewards.\",\"image\":\"Best-ROI.png\"},{\"title\":\"Start up Support\",\"description\":\"IBT Provides full guidance to build up new center and helps in selection of proper location to set up center.\",\"image\":\"Start-up-Support.png\"},{\"title\":\"Marketing Support\",\"description\":\"IBT takes marketing and advertising initiatives at a national level. For region specific advertising IBT provides Marketing aid to Business Partners.\",\"image\":\"Marketing-Support.png\"},{\"title\":\"HR Support\",\"description\":\"IBT provides continuous support for staff recruitment and staff training at Zonal, Regional & Corporate office.\",\"image\":\"HR-Support.png\"}]', '[{\"title\":\"Apply online\",\"description\":\"Help us know you better. Complete your profile information.\"},{\"title\":\"Go through Franchise Proposal\",\"description\":\"Read our Franchise proposal & have word with Franchisee support managers to know what IBT has to offer you\"},{\"title\":\"Physical\\/Online meeting with Founders\",\"description\":\"A Physical\\/Online meeting with founders\\/Directors will help us to understand your vision.\"},{\"title\":\"Go Through Franchise Agreement\",\"description\":\"Go through our Standard Franchisee Agreement to have better understanding.\"},{\"title\":\"Final Approval\",\"description\":\"A Final approval from Higher Management will gear-up with process to shake hands for better future\"}]', '[{\"title\":\"Shambhu Tiwari\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/_nfI5E_Lip0\"},{\"title\":\"Nand Kumar \",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/bZ18ItAl-SM\"},{\"title\":\" Gadi Srinivas Rao\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/oU2wvwYYOw8\"},{\"title\":\" Mohan Hardas\",\"url\":\"https:\\/\\/www.youtube.com\\/embed\\/TRd8-YUuo3w\"}]', '<title>IELTS, PTE, Spoken English Franchise | Start Business With IBT Institute At Low Investment</title>\r\n\r\n<meta name=\"description\" content=\"Start your own IELTS/Spoken English franchise with IBT at low investment. We offer franchise opportunity for you to grow your business with us, also learn how to register a coaching center and the minimum requirement to start it.\">\r\n\r\n\r\n<link rel=\"canonical\" href=\"https://www.ibtenglish.in/franchise\" />\r\n\r\n\r\n<script type=\"application/ld+json\">\r\n{\r\n  \"@context\": \"https://schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"What is the procedure to open an IELTS institute ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Contact IBT Head Office at 7520512345, secondly, there are few contracts policy and fees which you need to agree upon and submit the fee.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Do we offer ielts franchise outside punjab?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Yes, you can get the IELTS franchise outside punjab, there is no restriction for any cities.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Apart from IELTS , Do we offer spoken english franchise at cheapest rate ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Yes, we have nominal documentation and fees for Spoken English franchise,\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"What other franchise we offer other than ielts and spoken english franchise In India ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Yes, we offer franchises for CELPIP, TOEFL, PTE other than IELTS and Spoken English franchise In India.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Where is IBT\'s head office located ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"IBT Institute, SCO-65, Opposite PIMS, Garha Road, Jalandhar, Punjab-144022.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Where is IBT\'s Corporate Office located ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"1st Floor, C-1,2, Near Nirman vihar metro station, Laxmi Nagar, Delhi.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"How many franchise are there of IBT institute  ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"IBT has a network for more than 100+ franchise across India and list is growing month by month.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"How to contact for franchise enquiry?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"One can contact us through phone line that is 7520512345.\"\r\n    }\r\n },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"What are benefit one could get after getting franchise from IBT?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Benefits include marketing for students and we also provide help for teachers recruitment\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Apart from English language courses, What are the other Franchises & Partnership offered by IBT India?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"IBT has a network for more than 100+ institutes across India, And apart from English language courses, IBT offers franchises or say partnership for competitive exam coaching like bank and ssc coaching.\"\r\n    }\r\n  }]\r\n}\r\n</script>\r\n\r\n\r\n\r\n<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-137917645-1\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\'js\', new Date());\r\n\r\n  gtag(\'config\', \'UA-137917645-1\');\r\n</script>\r\n', 1, '2018-11-26 06:36:40');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_home_banner_section`
--

CREATE TABLE `tbl_home_banner_section` (
  `id` int(11) NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `target_url` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_home_banner_section`
--

INSERT INTO `tbl_home_banner_section` (`id`, `title`, `target_url`, `photo`, `status`, `cdate`) VALUES
(2, 'Speaking', '#', '73081885-people-speaking-or-singing-sign-vector-white-icon-in-red-circle-on-white-background-isolated-.jpg', 0, '2018-11-13 11:39:56'),
(3, 'Speaking', '#', 'ielts-icon1.png', 1, '2018-11-13 11:40:19'),
(4, 'Reading', '#', 'speaking-icon.png', 1, '2018-11-13 11:40:42'),
(5, 'Writing', '#', 'reading-icon.png', 1, '2018-11-13 11:40:59'),
(6, 'Listening', '#', 'Listening1.png', 1, '2019-02-08 07:29:41');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_job_category`
--

CREATE TABLE `tbl_job_category` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_job_category`
--

INSERT INTO `tbl_job_category` (`id`, `name`, `status`, `cdate`) VALUES
(5, 'Administration', 1, '2019-01-18 11:11:32'),
(6, 'Counsellor', 1, '2019-01-18 11:11:41'),
(7, 'Front Desk', 1, '2019-01-18 11:11:53'),
(8, 'ITs & SEO', 1, '2019-01-18 11:12:02'),
(9, 'Marketing', 1, '2019-01-18 11:12:11'),
(10, 'Trainers', 1, '2019-01-18 11:12:18'),
(11, 'Marketing Manager', 1, '2019-01-19 06:35:08');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_landing_page`
--

CREATE TABLE `tbl_landing_page` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` longtext,
  `photo` varchar(255) DEFAULT NULL,
  `mobile_photo` varchar(255) DEFAULT NULL,
  `left_heading_color` varchar(50) DEFAULT NULL,
  `right_heading_color` varchar(50) DEFAULT NULL,
  `whtasapp_icon` int(2) DEFAULT '0',
  `whtasapp_icon_align` enum('right','left') DEFAULT 'left',
  `whatsapp_link` varchar(255) DEFAULT NULL,
  `whatsapp_mobile` varchar(255) DEFAULT NULL,
  `meta_tag` blob,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_landing_page`
--

INSERT INTO `tbl_landing_page` (`id`, `title`, `slug`, `description`, `photo`, `mobile_photo`, `left_heading_color`, `right_heading_color`, `whtasapp_icon`, `whtasapp_icon_align`, `whatsapp_link`, `whatsapp_mobile`, `meta_tag`, `status`, `cdate`) VALUES
(1, 'overseas-landing', 'overseas-landing', '<h1><strong>IBT: Best IELTS Coaching Institute in Jalandhar</strong></h1>\r\n\r\n<p>Jalandhar is a hub of language classes which has led to the mushrooming of reputed IELTS center&nbsp;in Jalandhar. IBT Institute has earned a name in Jalandhar with success rate rising every year with as much as 80 percent of their registered candidates. Join IBT Jalandhar for IELTS to score the desired band score.</p>\r\n\r\n<h2><strong><a id=\"why-IBT-is-best-IELTS-institute-in-jalandhar\" name=\"why-IBT-is-best-IELTS-institute-in-jalandhar\"></a></strong><strong>Why&nbsp;IBT is the best IELTS Institute in Jalandhar?</strong></h2>\r\n\r\n<p>If you are planning to appear for the IELTS in Jalandhar,&nbsp;then it&#39;s very important to find an institute that can provide the best practice material and experienced teachers. IBT has given outstanding results in the past several years. A great number of students have&nbsp;obtained more than 7 bands after taking classes from IBT. Join the&nbsp;best&nbsp;IELTS coaching in Jalandhar right now.</p>\r\n\r\n<h3><strong><a id=\"2\" name=\"2\"></a>IBT&nbsp;</strong><strong>Special Features</strong></h3>\r\n\r\n<p>The salient features that makes IBT a unique coaching hub for the aspirants are:<br />\r\n&nbsp;</p>\r\n\r\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"0\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n			<p><img alt=\"Books for IELETs in Jalandhar\" src=\"https://www.ibtenglish.in/assets/upload/ckeditor/Books.png\" /></p>\r\n			</td>\r\n			<td>\r\n			<p><img alt=\"\" src=\"https://www.ibtenglish.in/assets/upload/ckeditor/Smart_Class_Room-removebg-preview1.png\" /></p>\r\n			</td>\r\n			<td>\r\n			<p><img alt=\"Free Monthly Magazine\" src=\"https://www.ibtenglish.in/assets/upload/ckeditor/Magazine.png\" /></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n			<p><strong>Free Study Material</strong><br />\r\n			<br />\r\n			IBT provides&nbsp;<a href=\"https://www.ibtenglish.in/ielts-preparation-books\">free Study Material</a>&nbsp;to all the students. Books Kit contains 9 Books which is updated on a regular basis.<br />\r\n			<br />\r\n			<strong>India&#39;s Best Selling Study material.</strong></p>\r\n			</td>\r\n			<td>\r\n			<p><strong>Smart Class Room</strong><br />\r\n			<br />\r\n			All our classrooms are equipped with projectors which makes the learning very interactive.<br />\r\n			<br />\r\n			<br />\r\n			<strong>Tests very close to Final Examination.</strong></p>\r\n			</td>\r\n			<td>\r\n			<p><strong>Full Day Classes</strong><br />\r\n			<br />\r\n			IBT provived full day 8 hours classes to our students. We cover all four modules twice a day for best results.<br />\r\n			<br />\r\n			<strong>Best Magazine for Competitive Exam</strong></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3><strong><a id=\"3\" name=\"3\">IBT Highlights</a></strong></h3>\r\n\r\n<p>IBT is ranked amongst the reputed coaching institutes due to its highlighted features.</p>\r\n\r\n<ul>\r\n	<li>100+ Centers across India</li>\r\n	<li>10+ Years of Presence</li>\r\n	<li>1 Lakh+ Success Stories</li>\r\n	<li>09 IELTS Book Materials</li>\r\n	<li>Trainers Certified from IDP &amp; BCD</li>\r\n	<li>ISO 9001: 2008 Certified IELTS Coaching Centre in Jalandhar</li>\r\n	<li>Small Batch Size having 15-20 students only</li>\r\n	<li>Teaching through Smart Classes</li>\r\n	<li>Full Day Classes where student can attempt all four modules twice.</li>\r\n	<li>Daily Grammar Classes</li>\r\n	<li>Top choice of students for IELTS Coaching Jalandhar</li>\r\n	<li>Weekly Mock Test as per final exam pattern</li>\r\n</ul>\r\n\r\n<h3><strong><a id=\"4\" name=\"4\">IBT Infrastructure</a></strong></h3>\r\n\r\n<p>IBT is No. 1 IELTS Institute in Jalandhar not only in terms of study but in terms of infrastructure as well.</p>\r\n\r\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\">\r\n	<tbody>\r\n		<tr>\r\n			<td><img alt=\"IELTS center in Jalandhar\" src=\"https://www.ibtenglish.in/assets/upload/ckeditor/4.png\" /></td>\r\n			<td><img alt=\"IELTS Coaching Jalandhar\" src=\"https://www.ibtenglish.in/assets/upload/ckeditor/2.jpg\" /></td>\r\n			<td><img alt=\"IELTS Coaching classes in Jalandhar\" src=\"https://www.ibtenglish.in/assets/upload/ckeditor/3.jpg\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><strong>Front Desk View</strong></td>\r\n			<td><strong>PTE &amp; Listening Lab</strong></td>\r\n			<td><strong>Smart Classrooms</strong></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3><strong><a id=\"5\" name=\"5\">IBT IELTS 9 Band Achievers</a></strong></h3>\r\n\r\n<p>The success story of IBT can be visibly seen from our top band achievers.</p>\r\n\r\n<p><img alt=\"IELTS 9 Band Achievers\" src=\"https://www.ibtenglish.in/assets/upload/ckeditor/IELTS_9_Band_Achievers.png\" style=\"height:100%; width:100%\" /></p>\r\n\r\n<h3><strong><a id=\"6\" name=\"6\">IBT Class Activities</a></strong></h3>\r\n\r\n<p>The class activities of IELTS students is managed as given in the table below:</p>\r\n\r\n<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n			<p>Vocabulary Building</p>\r\n			</td>\r\n			<td>\r\n			<p>Hesitation Removal</p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n			<p>Fluent Conversation</p>\r\n			</td>\r\n			<td>\r\n			<p>Pronunciation Improvement</p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n			<p>Group Discussions</p>\r\n			</td>\r\n			<td>\r\n			<p>Newspaper Reading</p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n			<p>Motivational Video Lectures</p>\r\n			</td>\r\n			<td>\r\n			<p>Audio/Video Clips with Tapescripts</p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3><strong><a id=\"7\" name=\"7\">IBT Teaching Methodology</a></strong></h3>\r\n\r\n<p>The teaching methodology is very well planned to impart proficient training and guidance with the essential attributes these are:</p>\r\n\r\n<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n			<p>Small Batch Size</p>\r\n			</td>\r\n			<td>\r\n			<p>Multiple Cabin Speaking</p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n			<p>Smart Class Rooms</p>\r\n			</td>\r\n			<td>\r\n			<p>Level Based Learning</p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n			<p>Frequent Doubt Sessions&nbsp;</p>\r\n			</td>\r\n			<td>\r\n			<p>Scheduled Course Material</p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n			<p>Personal Attention</p>\r\n			</td>\r\n			<td>\r\n			<p>Certified &amp; Experienced Faculty</p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3><strong><a id=\"8\" name=\"8\"></a>Other Reasons to Choose IBT for IELTS in Jalandhar</strong></h3>\r\n\r\n<p>IBT follow level based approach that helps students to clear their doubts and study in the batch as per their level. There are three levels: Beginners, Learners, and Movers.</p>\r\n\r\n<ol>\r\n	<li>Students can attempt all the modules twice a day with detailed discussion of the modules. Pre and post discussion of each module helps to understand the basic concepts in detail.</li>\r\n	<li>Learning at IBT Institute is done in smart class, as this is the latest technology which helps to make learning interesting and effective.&nbsp;</li>\r\n	<li>Trainers pay personal attention to each student which helps students to ask questions without any hesitation. Separate sessions can also be provided for IELTS Coaching in Jalandhar.</li>\r\n	<li>Special doubt sessions of each module is conducted to overcome the difficulties which students face while attempting the test.</li>\r\n	<li>Daily performance report of writing and speaking is given to the students so that they know about their weakness.</li>\r\n	<li>Learners do speaking in the same environment as they get in the exam that is cabin speaking is there for students to help them to overcome their hesitation to speak in front of invigilator.</li>\r\n	<li>Special grammar classes are arranged for the students who are unable to understand the English language.&nbsp;</li>\r\n	<li>Vocabulary is always a hurdle for the learners and in IELTS class at IBT, several activities are conducted to make vocab learning easy and effective.</li>\r\n	<li>Time to time counselling of weak students is done by the management to know about their problems they face during learning.</li>\r\n	<li>Also, the free demo sessions are conducted for he new comers before taking admision at IBT Institute, so that they can be familiar with the techniques used by the experts at IBT institute.</li>\r\n	<li>Fluency and pronunciation in speaking module is improved by the special sessions conducted by the highly experienced faculty and the video and audio lectures are played in the classrooms to encourage and motivate the students improve their speaking skills.</li>\r\n	<li><a href=\"https://www.ibtenglish.in/view-ielts-result-online\">Effective exam preparation tips</a>&nbsp;and techniques are shared with the learners to improve their reading and writing module.</li>\r\n	<li>English speaking environment in the classroom also contributes to overcome the hesitation of the students to speak in front of others.</li>\r\n	<li>Newspaper reading is done as an activity to improve the reading and speaking skills at our IELTS Center in Jalandhar.</li>\r\n	<li>Also, IBT Institute is providing the facility to its students to register for the real exam at discounted fee less than the actual fee.</li>\r\n	<li>IBT Institute conducts the reality test for IELTS once in a month so that the students can be familiar with the real exam pattern and environment, the best part of the reality test is that it is free of cost and is also for the aspirants who are not from IBT family.</li>\r\n	<li>IBT provides IELTS Coaching in Jalandhar at the prime location near bus stand so reach over there is not a big deal, one can easily reach the location in less time.</li>\r\n</ol>\r\n\r\n<p>Join next batch at best IELTS Coaching institute in Jalandhar. You might also be interested in&nbsp;<a href=\"https://www.ibtenglish.in/ielts-exam-dates-2020\">IELTS exam dates calendar</a>.</p>\r\n', 'bg.jpg', 'download1.jpeg', 'FFFFFF', 'FFFFFF', 1, 'right', '', '', '', 1, '2021-02-25 09:32:04');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_landing_page_left`
--

CREATE TABLE `tbl_landing_page_left` (
  `id` int(11) NOT NULL,
  `page_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `ordering` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_landing_page_left`
--

INSERT INTO `tbl_landing_page_left` (`id`, `page_id`, `title`, `url`, `ordering`) VALUES
(53, 1, 'IBT Overseas', '#first#highlight', 1),
(54, 1, 'why ibt', '#why-IBT-is-best-IELTS-institute-in-jalandhar', 2),
(55, 1, 'IBT Highligths', '#3', 3),
(56, 1, 'IBT IELTS 9 Band Achievers', '#5', 4),
(57, 1, 'Hweading 2', '#first #highlight', 5);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_landing_page_right`
--

CREATE TABLE `tbl_landing_page_right` (
  `id` int(11) NOT NULL,
  `page_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `ordering` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_landing_page_section`
--

CREATE TABLE `tbl_landing_page_section` (
  `id` int(11) NOT NULL,
  `page_id` int(11) DEFAULT NULL,
  `section_type` int(11) DEFAULT NULL COMMENT '"1:Daily GK update","2:Study note","3:ads image","4:Course section","5:Page bottom"',
  `content` text,
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_landing_page_section`
--

INSERT INTO `tbl_landing_page_section` (`id`, `page_id`, `section_type`, `content`, `cdate`) VALUES
(21, 1, 6, '', '2021-03-02 11:53:09');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_media_event`
--

CREATE TABLE `tbl_media_event` (
  `id` int(11) NOT NULL,
  `type` enum('Academic','Non-academic','Press Coverage','') DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_media_event`
--

INSERT INTO `tbl_media_event` (`id`, `type`, `title`, `photo`, `status`, `cdate`) VALUES
(5, 'Academic', 'MOCK TEST', 'MOCK_TEST__0.jpg', 1, '2018-12-27 10:19:01'),
(6, 'Academic', 'MOCK TEST WINNER', 'MOCK_TEST_WINNER.jpg', 1, '2018-12-27 10:20:09'),
(7, 'Academic', 'CLASS ROOM TEACHING', 'academic1_jpg_1_0.png', 1, '2018-12-27 10:22:03'),
(8, 'Academic', 'COLLEGE SEMINARS', 'SEMINAR.jpg', 1, '2018-12-27 10:23:13'),
(9, 'Non-academic', 'DIWALI CELEBRATION', 'DIWALI.jpg', 1, '2018-12-27 10:24:19'),
(10, 'Non-academic', 'MARY CHRISMAS CELEBRATION', 'CHRISMAS_0.jpg', 1, '2018-12-27 10:25:31'),
(11, 'Non-academic', 'QUIZ COMPETITION', 'QUIZ.jpg', 1, '2018-12-27 10:26:10'),
(12, 'Press Coverage', 'News paper', 'IBPS_CLERK.jpg', 1, '2018-12-27 10:28:44'),
(13, 'Press Coverage', 'News paper', 'CLERK.jpg', 1, '2018-12-27 10:29:27'),
(14, 'Press Coverage', 'News paper', 'press2.jpg', 1, '2018-12-27 10:29:59'),
(15, 'Press Coverage', 'News paper', 'press21.jpg', 1, '2018-12-27 10:30:38'),
(16, 'Press Coverage', 'newa', 'press22.jpg', 1, '2018-12-27 11:35:47');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_menu`
--

CREATE TABLE `tbl_menu` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT '0',
  `menu_name` varchar(255) DEFAULT NULL,
  `target_url` varchar(255) DEFAULT NULL,
  `target` int(10) DEFAULT '0' COMMENT '"1:new window","0:same window"',
  `menu` int(2) DEFAULT NULL COMMENT '"1:Top","2:Main","3:Important","4:Top","5:Quick"',
  `menu_style` int(10) NOT NULL DEFAULT '0' COMMENT '"1:new","0:normal"',
  `status` int(2) DEFAULT NULL,
  `display_order` int(10) DEFAULT NULL,
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_menu`
--

INSERT INTO `tbl_menu` (`id`, `parent_id`, `menu_name`, `target_url`, `target`, `menu`, `menu_style`, `status`, `display_order`, `cdate`) VALUES
(1, 0, 'Login', '#', 0, 1, 0, 0, 1, '2018-11-12 07:59:45'),
(2, 1, 'Smart Class Login', 'http://smartclass.ibtindia.com/', 1, 1, 0, 1, 1, '2018-11-12 08:00:11'),
(4, 0, 'Visa Stamped', 'visastamped', 0, 2, 0, 1, 5, '2018-11-12 08:01:10'),
(5, 0, 'Faq\'s', 'faq', 0, 1, 0, 1, 5, '2018-11-12 08:06:30'),
(6, 0, 'IELTS Band Calculatar', 'ielts-band-calculator', 0, 1, 0, 0, 6, '2018-11-12 08:07:32'),
(10, 1, 'Center login', 'http://erp.ibtindia.com/', 1, 1, 0, 1, 2, '2018-11-12 08:10:59'),
(24, 0, 'Awards', 'awards', 0, 1, 1, 0, 3, '2018-11-12 10:40:29'),
(31, 0, 'IBPS PO 2018', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/ibps-po-exam-2018', 0, 3, 0, 1, 1, '2018-11-12 11:32:42'),
(32, 0, 'SSC CHSL 2018', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/ssc-chsl-exam-2018', 1, 3, 0, 1, 2, '2018-11-12 11:34:38'),
(33, 0, 'UP Constable 2018 ', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/up-constable-2018-recruitment', 0, 3, 0, 1, 3, '2018-11-12 11:52:58'),
(34, 0, 'CANARA BANK PO ', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/canara-bank-po-2018', 0, 3, 0, 1, 4, '2018-11-12 11:53:19'),
(35, 0, 'Railway JE ', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/railway-je-recruitment', 0, 3, 0, 1, 5, '2018-11-12 11:53:51'),
(36, 0, 'IBPS CLERK 2018', '##', 0, 3, 0, 1, 6, '2018-11-12 11:54:56'),
(37, 0, 'Railway Recruitment ', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/railway-recruitment-2018-notification', 0, 3, 0, 1, 7, '2018-11-12 11:55:10'),
(38, 0, 'BANK PO 2018', '#', 0, 3, 0, 1, 8, '2018-11-12 11:55:21'),
(39, 0, 'TNPSC Group II Exam', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/tnpsc-group-ii-exam', 1, 3, 0, 1, 9, '2018-11-12 11:55:36'),
(40, 0, 'RBI GRADE B 2018', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/rbi-grade-b-recruitment-2018', 0, 3, 0, 1, 10, '2018-11-12 11:55:50'),
(41, 0, 'IB Recruitment', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/ib-recruitment-2018', 0, 3, 0, 1, 11, '2018-11-12 11:56:01'),
(42, 0, 'Government Exams', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/government-exams', 0, 3, 0, 1, 12, '2018-11-12 11:56:36'),
(43, 0, 'RBI ASSISTANT', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/rbi-assistant', 0, 3, 0, 1, 13, '2018-11-12 11:56:49'),
(44, 0, 'NICLAO 2018', '#', 0, 3, 0, 1, 14, '2018-11-12 11:57:01'),
(45, 0, 'RBI ASSISTANT 2018', '#', 0, 3, 0, 1, 15, '2018-11-12 11:57:12'),
(46, 0, 'IBPS SO 2018', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/bank-coaching', 0, 4, 0, 0, 1, '2018-11-12 11:59:07'),
(47, 0, 'IELTS Class Jalandhar', 'https://www.ibtenglish.in/ibt-ielts-coaching-jalandhar', 1, 4, 0, 1, 1, '2018-11-12 11:59:22'),
(48, 0, 'PTE Coaching', 'https://www.ibtenglish.in/pte-coaching', 1, 4, 0, 1, 3, '2018-11-12 11:59:36'),
(49, 0, 'CELPIP Classes', 'https://www.ibtenglish.in/celpip-coaching', 1, 4, 0, 1, 4, '2018-11-12 11:59:49'),
(50, 0, 'CD- IELTS', 'https://www.ibtenglish.in/ibt-ielts-coaching-jalandhar', 1, 4, 0, 1, 5, '2018-11-12 12:00:01'),
(51, 0, 'Spoken English', 'https://www.ibtenglish.in/ibt-spoken-english-classes-jalandhar', 1, 4, 0, 1, 6, '2018-11-12 12:00:12'),
(52, 0, 'SBI Clerk 2019', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/sbi-clerk-exam-2019', 0, 4, 0, 0, 7, '2018-11-12 12:00:26'),
(53, 0, 'SSC CPO 2018', '#', 0, 4, 0, 0, 8, '2018-11-12 12:01:10'),
(54, 0, 'IPPB 2018', '#', 0, 4, 0, 0, 9, '2018-11-12 12:01:25'),
(55, 0, 'RAILWAY EXAM 2018', '#', 0, 4, 0, 0, 11, '2018-11-12 12:01:36'),
(56, 0, 'Best IELTS Coaching', 'https://www.ibtenglish.in/ibt-ielts-coaching-jalandhar', 1, 5, 0, 1, 1, '2018-11-12 12:03:14'),
(57, 0, 'PTE Classes Jalandhar', 'https://www.ibtenglish.in/pte-coaching', 1, 5, 0, 1, 2, '2018-11-12 12:03:27'),
(58, 0, 'IELTS Exam Date', 'https://www.ibtenglish.in/ielts-exam-dates-2020', 1, 5, 0, 1, 3, '2018-11-12 12:03:38'),
(59, 0, 'CD- IELTS Coaching', 'https://www.ibtenglish.in/ielts-coaching-in-patiala', 1, 5, 0, 1, 4, '2018-11-12 12:03:51'),
(60, 0, 'IELTS Exam Booking', 'https://www.ibtenglish.in/ielts-exam', 1, 5, 0, 1, 5, '2018-11-12 12:04:01'),
(61, 0, 'IELTS Coaching Pathankot', 'https://www.ibtenglish.in/ielts-institute-in-pathankot', 1, 5, 0, 1, 6, '2018-11-12 12:04:12'),
(62, 0, 'CELPIP Training', 'https://www.ibtenglish.in/celpip-coaching', 1, 5, 0, 1, 7, '2018-11-12 12:04:23'),
(63, 0, 'PTE Coaching Pathankot', 'https://www.ibtenglish.in/pte-institute-in-pathankot', 1, 5, 0, 1, 8, '2018-11-12 12:04:31'),
(64, 0, 'PTE Online Test', 'https://www.ibtenglish.in/pte-coaching', 1, 5, 0, 1, 9, '2018-11-12 12:04:42'),
(65, 0, 'Spoken English Franchise', 'https://www.ibtenglish.in/franchise', 1, 5, 0, 1, 10, '2018-11-12 12:04:52'),
(66, 0, 'CTET 2018', '#', 0, 5, 0, 0, 11, '2018-11-12 12:05:02'),
(67, 0, 'NABARD 2018', '#', 0, 5, 0, 0, 12, '2018-11-12 12:05:15'),
(68, 0, 'SSC CPO 2018', '#', 0, 5, 0, 0, 13, '2018-11-12 12:05:25'),
(69, 0, 'IPPB 2018', '#', 0, 5, 0, 0, 14, '2018-11-12 12:05:36'),
(70, 0, 'RAILWAY EXAM 2018', '#', 0, 5, 0, 0, 15, '2018-11-12 12:05:47'),
(78, 0, 'Test Exam', '#12', 0, 4, 0, 0, 10, '2019-01-02 07:58:58'),
(82, 0, 'News and Articles', '#', 0, 1, 0, 0, 4, '2019-02-07 12:11:17'),
(83, 0, 'About Us', 'about-us', 0, 2, 0, 1, 1, '2019-02-07 12:24:14'),
(84, 0, 'Center Locator', 'branches-list', 0, 2, 0, 0, 2, '2019-02-07 12:24:39'),
(85, 0, 'Courses', 'https://www.ibtenglish.in/ibt-ielts-coaching-jalandhar', 1, 2, 0, 1, 2, '2019-02-07 12:25:02'),
(86, 0, 'Student Enquiry', 'students-enquiry', 0, 2, 0, 1, 3, '2019-02-07 12:25:16'),
(87, 0, 'Franchise Enquiry', 'franchise', 0, 2, 0, 0, 4, '2019-02-07 12:25:50'),
(88, 0, 'Career', 'ibt-careers', 0, 1, 0, 1, 6, '2019-02-07 12:26:10'),
(89, 0, 'Contact Us', 'contactus', 0, 2, 0, 1, 7, '2019-02-07 12:26:29'),
(90, 85, 'CANDADA', 'https://www.ibtenglish.in/ibt-ielts-coaching-jalandhar', 1, 2, 0, 1, 1, '2019-04-20 08:19:42'),
(91, 85, 'AUSTRALIA', 'https://www.ibtenglish.in/pte-coaching', 1, 2, 0, 1, 2, '2019-04-20 08:21:29'),
(92, 85, 'USA', 'https://www.ibtenglish.in/celpip-coaching', 1, 2, 0, 1, 3, '2019-04-20 08:21:56'),
(93, 85, 'UNITED KINGDOM', 'https://www.ibtenglish.in/ibt-spoken-english-classes-jalandhar', 0, 2, 0, 1, 4, '2019-04-20 08:22:13'),
(94, 85, 'SCHENGEN', 'https://www.ibtenglish.in/toefl-coaching', 0, 2, 0, 1, 5, '2019-04-20 08:22:35'),
(95, 85, 'Study Abroad', 'https://www.ibtenglish.in/study-abroad-canada-australia', 0, 2, 0, 0, 6, '2019-04-20 08:22:52');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mobile_number`
--

CREATE TABLE `tbl_mobile_number` (
  `id` int(11) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `status` int(2) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_mobile_number`
--

INSERT INTO `tbl_mobile_number` (`id`, `mobile`, `status`) VALUES
(1, '7508040811', 1),
(3, '9041500546', 1),
(4, '9023623056', 1),
(5, '9711652294', 1),
(6, '9818670052', 1),
(8, '9803905949', 1),
(9, '9759005006', 1),
(10, '8586070112', 1);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_our_center`
--

CREATE TABLE `tbl_our_center` (
  `id` int(11) NOT NULL,
  `main_heading` varchar(255) DEFAULT NULL,
  `sub_heading` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  `target_url` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_our_center`
--

INSERT INTO `tbl_our_center` (`id`, `main_heading`, `sub_heading`, `title`, `content`, `target_url`, `photo`, `status`, `cdate`) VALUES
(1, 'OUR CENTERS', 'We have 100+ Center’s in 21+ States', 'Leading in 100 Cities in India', '\"IBT has expanded its horizon of coaching institutes with as much as 100+ branches in a very short span of time by rendering outstanding coaching.', 'http://122.176.54.2/development/dev2016/phpdevelopment/IBT/branches-list', 'map_new_icon_map_(2)3.png', 1, '2018-11-01 08:19:00');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_popup`
--

CREATE TABLE `tbl_popup` (
  `id` int(11) NOT NULL,
  `page_id` varchar(255) DEFAULT NULL,
  `type` enum('landing','cms') DEFAULT NULL,
  `popup_type` enum('top','page') DEFAULT NULL,
  `popup_location` enum('left','right','center','top') DEFAULT NULL,
  `popup_content` longtext,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_popup`
--

INSERT INTO `tbl_popup` (`id`, `page_id`, `type`, `popup_type`, `popup_location`, `popup_content`, `status`, `cdate`) VALUES
(24, 'courses', 'cms', 'page', 'center', '{\"popup_image\":\"Newsletter-signup.jpg\",\"popup_url\":\"#\"}', 0, '2019-01-04 09:18:29'),
(25, 'home', 'cms', 'page', 'center', '{\"popup_image\":\"Newsletter-signup.jpg\",\"popup_url\":\"#\"}', 0, '2019-01-04 09:18:29'),
(26, 'student_enq', 'cms', 'page', 'left', '{\"popup_image\":\"maxresdefault.jpg\",\"popup_url\":\"http:\\/\\/122.176.54.2\\/development\\/dev2016\\/phpdevelopment\\/IBT\\/\"}', 0, '2019-01-10 09:51:01'),
(27, 'home', 'cms', 'page', 'left', '{\"popup_image\":\"maxresdefault.jpg\",\"popup_url\":\"http:\\/\\/122.176.54.2\\/development\\/dev2016\\/phpdevelopment\\/IBT\\/\"}', 0, '2019-01-10 09:51:01'),
(28, 'locate_center', 'cms', 'page', 'left', '{\"popup_image\":\"maxresdefault.jpg\",\"popup_url\":\"http:\\/\\/122.176.54.2\\/development\\/dev2016\\/phpdevelopment\\/IBT\\/\"}', 0, '2019-01-10 09:51:01'),
(29, 'career', 'cms', 'page', 'left', '{\"popup_image\":\"maxresdefault.jpg\",\"popup_url\":\"http:\\/\\/122.176.54.2\\/development\\/dev2016\\/phpdevelopment\\/IBT\\/\"}', 0, '2019-01-10 09:51:01'),
(30, 'franchise_enq', 'cms', 'page', 'center', '{\"popup_image\":\"color-effects-png-color-effects-png-1196.png\",\"popup_url\":\"#####\"}', 0, '2019-01-17 07:37:25'),
(31, 'home', 'cms', 'top', 'top', '{\"text1\":\"Test\",\"button1_text\":\"Test\",\"target_url1\":\"##\",\"text2\":\"Test2\",\"button2_text\":\"Test2\",\"target_url2\":\"###\",\"bg_color\":\"0F4FFF\"}', 0, '2019-01-17 07:39:25'),
(32, 'home', 'cms', 'top', 'top', '{\"text1\":\"hgdfhd\",\"button1_text\":\"fdh\",\"target_url1\":\"dfhdfhd\",\"text2\":\"hdfhdfh\",\"button2_text\":\"dfhdf\",\"target_url2\":\"dfh\",\"bg_color\":\"E6C9FF\"}', 0, '2019-01-17 07:47:51'),
(33, 'courses', 'cms', 'top', 'top', '{\"text1\":\"Its testing\",\"button1_text\":\"testing\",\"target_url1\":\"\",\"text2\":\"no testing\",\"button2_text\":\"why testing\",\"target_url2\":\"\",\"bg_color\":\"E9FF78\"}', 0, '2019-01-17 07:51:18'),
(34, '2', 'landing', 'page', 'center', '{\"popup_image\":\"sp1.png\",\"popup_url\":\"##\"}', 0, '2019-01-17 08:05:27'),
(35, '3', 'landing', 'page', 'center', '{\"popup_image\":\"jvgfoot.png\",\"popup_url\":\"##\"}', 0, '2019-01-17 08:14:20'),
(36, '2', 'landing', 'page', 'center', '{\"popup_image\":\"USC70AUC041B021001.jpg\",\"popup_url\":\"##\"}', 0, '2019-01-17 08:16:48'),
(37, '3', 'landing', 'page', 'center', '{\"popup_image\":\"USC70AUC041B021001.jpg\",\"popup_url\":\"##\"}', 0, '2019-01-17 08:16:48'),
(38, 'locate_center', 'cms', 'page', 'left', '{\"popup_image\":\"color-effects-png-color-effects-png-11962.png\",\"popup_url\":\"www.ibtindia.com\"}', 0, '2019-01-17 11:41:32'),
(39, '1', 'landing', 'top', 'top', '{\"text1\":\"dfgdf\",\"button1_text\":\"457457\",\"target_url1\":\"54745\",\"text2\":\"fgjfgjfgj\",\"button2_text\":\"54745\",\"target_url2\":\"457454\",\"bg_color\":\"FFFFFF\"}', 0, '2019-01-18 06:12:56'),
(40, '2', 'landing', 'top', 'top', '{\"text1\":\"dfgdf\",\"button1_text\":\"457457\",\"target_url1\":\"54745\",\"text2\":\"fgjfgjfgj\",\"button2_text\":\"54745\",\"target_url2\":\"457454\",\"bg_color\":\"FFFFFF\"}', 0, '2019-01-18 06:12:56'),
(41, '3', 'landing', 'top', 'top', '{\"text1\":\"dfgdf\",\"button1_text\":\"457457\",\"target_url1\":\"54745\",\"text2\":\"fgjfgjfgj\",\"button2_text\":\"54745\",\"target_url2\":\"457454\",\"bg_color\":\"FFFFFF\"}', 0, '2019-01-18 06:12:56'),
(42, 'courses', 'cms', 'page', 'center', '{\"popup_image\":\"color-effects-png-color-effects-png-11961.png\",\"popup_url\":\"www.ibtindia.com\"}', 0, '2019-01-18 06:18:56'),
(43, 'franchise_enq', 'cms', 'page', 'center', '{\"popup_image\":\"color-effects-png-color-effects-png-11961.png\",\"popup_url\":\"www.ibtindia.com\"}', 0, '2019-01-18 06:18:56'),
(44, 'student_enq', 'cms', 'page', 'center', '{\"popup_image\":\"color-effects-png-color-effects-png-11961.png\",\"popup_url\":\"www.ibtindia.com\"}', 0, '2019-01-18 06:18:56'),
(45, 'home', 'cms', 'page', 'center', '{\"popup_image\":\"color-effects-png-color-effects-png-11961.png\",\"popup_url\":\"www.ibtindia.com\"}', 0, '2019-01-18 06:18:56'),
(46, 'locate_center', 'cms', 'page', 'center', '{\"popup_image\":\"color-effects-png-color-effects-png-11961.png\",\"popup_url\":\"www.ibtindia.com\"}', 0, '2019-01-18 06:18:56'),
(47, 'career', 'cms', 'page', 'center', '{\"popup_image\":\"color-effects-png-color-effects-png-11961.png\",\"popup_url\":\"www.ibtindia.com\"}', 0, '2019-01-18 06:18:56');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_programe_enquiry`
--

CREATE TABLE `tbl_programe_enquiry` (
  `id` int(11) NOT NULL,
  `programe_id` int(11) DEFAULT NULL,
  `contact_number` varchar(50) NOT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_programe_enquiry`
--

INSERT INTO `tbl_programe_enquiry` (`id`, `programe_id`, `contact_number`, `status`, `cdate`) VALUES
(4, 1, '9711652294', 1, '2021-03-12 11:18:33'),
(5, 1, '8700571711', 1, '2021-03-13 11:49:33'),
(6, 1, '8700571711', 1, '2021-03-13 11:49:35'),
(7, 1, '8700571711', 1, '2021-03-13 11:49:35'),
(8, 1, '9023623056', 1, '2021-03-16 05:45:16');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_programme`
--

CREATE TABLE `tbl_programme` (
  `id` int(11) NOT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `subcat_id` int(11) DEFAULT NULL,
  `college_name` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `application_fee` varchar(255) DEFAULT NULL,
  `tuition_fee` varchar(255) DEFAULT NULL,
  `course_name` varchar(255) DEFAULT NULL,
  `programme_length` int(2) DEFAULT NULL,
  `programme_level` varchar(100) DEFAULT NULL,
  `Intake` varchar(30) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_programme`
--

INSERT INTO `tbl_programme` (`id`, `cat_id`, `subcat_id`, `college_name`, `city`, `state`, `country`, `application_fee`, `tuition_fee`, `course_name`, `programme_length`, `programme_level`, `Intake`, `photo`, `status`, `cdate`) VALUES
(1, 1, 1, 'manbir', 'Ottawa', 'Ontario ', 'Canada', '200', 'CA 9500', 'Computer Programmer(0336X01F)', 2, 'Post Secondary (Under Graduate) Program Status', 'April', '1528184625algonquin_(1).jpg', 1, '2021-03-05 12:46:46');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_program_cat`
--

CREATE TABLE `tbl_program_cat` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_program_cat`
--

INSERT INTO `tbl_program_cat` (`id`, `name`, `slug`, `status`, `cdate`) VALUES
(1, 'Post Diploma Program Status', 'post_diploma_program_status', 1, '2021-03-05 07:44:15'),
(2, 'Post Secondary ( Under Graduate) Program Status\r\n', 'post_secondary_under_graduate_program_status\r\n', 1, '2021-03-05 07:44:15'),
(3, 'Post Graduate Certificate Program Status', 'post_graduate_certificate_program_status', 1, '2021-03-05 07:44:23');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_program_subcat`
--

CREATE TABLE `tbl_program_subcat` (
  `id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_program_subcat`
--

INSERT INTO `tbl_program_subcat` (`id`, `cat_id`, `name`, `status`, `cdate`) VALUES
(1, 1, 'Computers & Telecommunications', 1, '2021-03-05 12:31:35'),
(2, 1, 'Health,Food & Medical', 1, '2021-03-16 05:53:27');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_selected_student`
--

CREATE TABLE `tbl_selected_student` (
  `id` int(11) NOT NULL,
  `student_name` varchar(255) DEFAULT NULL,
  `exam_cleared` varchar(100) DEFAULT NULL,
  `department_allocated` varchar(100) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_selected_student`
--

INSERT INTO `tbl_selected_student` (`id`, `student_name`, `exam_cleared`, `department_allocated`, `photo`, `status`, `cdate`) VALUES
(3, 'Sankalap Mehta', 'Overall 7.5 Bands', NULL, 'bg_banner21.jpg', 1, '2018-12-05 09:31:14'),
(4, 'Kiranjeet Kaur', 'Overall 9.0 Bands', NULL, 'bg_banner31.jpg', 1, '2018-12-05 09:32:35'),
(5, 'Arshdeep Kaur', 'Overall 7.0 Bands', NULL, 'bg_banner41.jpg', 1, '2018-12-05 09:33:16'),
(6, 'Rajat Chawla', 'Overall 7.0 Bands', NULL, '7.png', 1, '2018-12-05 09:33:50'),
(7, 'Rajbeer Kaur', 'Overall 6.0 Bands', NULL, 'bg_banner61.jpg', 1, '2018-12-05 09:34:18'),
(15, 'Naina', 'Overall 6.5 bands', NULL, 'Naina.jpg', 1, '2019-12-18 09:58:00');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_selections`
--

CREATE TABLE `tbl_selections` (
  `id` int(11) NOT NULL,
  `photo` varchar(500) NOT NULL,
  `status` varchar(2) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_selections`
--

INSERT INTO `tbl_selections` (`id`, `photo`, `status`, `cdate`) VALUES
(2, '01.jpg', '1', '2019-02-15 08:03:18'),
(3, '02.jpg', '1', '2019-02-15 08:05:09'),
(4, '03.jpg', '1', '2019-02-15 08:07:44'),
(5, '04.jpg', '1', '2019-02-15 08:07:49'),
(6, '05.jpg', '1', '2019-02-15 08:07:55'),
(7, '06.jpg', '1', '2019-02-15 08:08:05'),
(8, '07.jpg', '1', '2019-02-15 08:08:15'),
(9, '08.jpg', '1', '2019-02-15 08:08:23'),
(10, '09.jpg', '1', '2019-03-29 06:34:08'),
(11, '10.jpg', '1', '2019-03-29 06:34:16'),
(12, '11.jpg', '1', '2019-03-29 06:34:56'),
(13, '12.jpg', '1', '2019-03-29 06:35:05'),
(14, '16.jpg', '1', '2019-11-20 07:31:22'),
(15, '17.jpg', '1', '2019-11-20 07:38:18'),
(16, '021.jpg', '1', '2019-11-20 07:42:13'),
(17, '031.jpg', '1', '2019-11-20 07:42:52'),
(18, '051.jpg', '1', '2019-11-20 07:43:21'),
(19, '061.jpg', '1', '2019-11-20 07:43:39'),
(20, '071.jpg', '1', '2019-11-20 07:43:59'),
(21, '081.jpg', '1', '2019-11-20 07:46:02'),
(22, '091.jpg', '1', '2019-11-20 07:46:51'),
(23, '101.jpg', '1', '2019-11-20 07:47:11'),
(24, '111.jpg', '1', '2019-11-20 07:47:23'),
(25, '121.jpg', '1', '2019-11-20 07:47:38'),
(26, '14.jpg', '1', '2019-11-20 07:48:20'),
(27, '15.jpg', '1', '2019-11-20 07:48:47'),
(28, 'JAHNAVEY.jpg', '1', '2019-12-18 11:07:04'),
(29, 'NAINA.jpg', '1', '2019-12-18 11:07:26');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_setting`
--

CREATE TABLE `tbl_setting` (
  `id` int(11) NOT NULL,
  `admin_name` varchar(100) NOT NULL,
  `admin_email` varchar(100) NOT NULL,
  `head_office` varchar(255) NOT NULL,
  `corporate_address` varchar(255) NOT NULL,
  `admin_contact_number` varchar(100) NOT NULL,
  `site_title` varchar(255) NOT NULL,
  `site_sub_title` varchar(255) NOT NULL,
  `support_email` varchar(100) NOT NULL,
  `support_contact_number` varchar(100) NOT NULL,
  `meta_tags` longtext NOT NULL,
  `site_logo` varchar(255) DEFAULT NULL,
  `site_favicon` varchar(255) DEFAULT NULL,
  `site_youtube_video` text NOT NULL,
  `exam_pre_heading` varchar(255) DEFAULT NULL,
  `exam_pre_subheading` varchar(255) DEFAULT NULL,
  `academic_main_heading` varchar(500) DEFAULT NULL,
  `academic_sub_heading` varchar(500) DEFAULT NULL,
  `academic_content` text,
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `home_banner_section` longtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_setting`
--

INSERT INTO `tbl_setting` (`id`, `admin_name`, `admin_email`, `head_office`, `corporate_address`, `admin_contact_number`, `site_title`, `site_sub_title`, `support_email`, `support_contact_number`, `meta_tags`, `site_logo`, `site_favicon`, `site_youtube_video`, `exam_pre_heading`, `exam_pre_subheading`, `academic_main_heading`, `academic_sub_heading`, `academic_content`, `date_created`, `home_banner_section`) VALUES
(1, 'Testeeeeeeeeee', 'headoffice@ibtenglish.in', 'IBT Institute, SCO-65, Opposite PIMS, Garha Road, Jalandhar, Punjab-144022\r\n', '1st Floor, C-1,2, Near Nirman vihar metro station, Laxmi Nagar, Delhi. Calll : 96969-60029', '75205-12345, 0181-4606262', 'IBT English Prep', 'IBT English Prep', 'visa@ibtoverseas.com', '8677812345', '<title>IELTS Classes | IELTS Prepration |Spoken English - IBT Coaching Insitute</title>\r\n\r\n<meta name=\"description\" content=\"Search for Best Coaching Institute for IELTS Classes? Welcome to IBT PREP, We have the Top faculties for IELTS Coaching Classes, IELTS Preparation and also for English Speaking Classes \" />\r\n\r\n<meta name=\"keywords\" content=\"Best IELTS Coaching ,Best IELTS CLasses ,Best IELTS Institute, IELTS Prepration ,Best English Speaking Coaching ,Best English Speaking Classes,Best Spoken English CLasses,Best Spoken English Institute  \" />\r\n\r\n\r\n<link rel=\"canonical\" href=\"https://www.ibtenglish.in/\" />\r\n<script type=\"application/ld+json\">\r\n{\r\n  \"@context\": \"https://schema.org\",\r\n  \"@type\": \"Organization\",\r\n  \"url\": \"https://www.ibtenglish.in/ibt-ielts-coaching-jalandhar\",\r\n  \"contactPoint\": [\r\n    { \"@type\": \"ContactPoint\",\r\n      \"telephone\": \"+917520512345\",\r\n      \"contactType\": \"customer service\"\r\n    }\r\n  ]\r\n}\r\n</script>\r\n\r\n<script type=\"application/ld+json\">\r\n{\r\n  \"@context\": \"http://schema.org\",\r\n  \"@type\": \"ProfessionalService\",    \r\n  \"name\": \"IBT Institute\",\r\n  \"address\": {\r\n    \"@type\": \"PostalAddress\",\r\n    \"streetAddress\": \"IBT Institute, SCO-65, Opposite PIMS, Garha Road, Jalandhar, Punjab-144022\",\r\n      \"addressLocality\": \"Jalandhar\",\r\n    \"addressRegion\": \"Punjab\",\r\n    \"postalCode\": \"144022\",\r\n    \"addressCountry\": \"India\"\r\n  },\r\n  \"telePhone\": \"91-7520212345\",\r\n \"openingHours\": \"Mo, Tu, We, Th, Fr, Sa, Su 08:30-17:00\",\r\n   \"geo\": {\r\n    \"@type\": \"GeoCoordinates\",\r\n    \"latitude\": \"28.6365803\",\r\n    \"longitude\": \"77.2868277\"\r\n  },\r\n    \"url\": \"https://www.ibtenglish.in/ibt-ielts-coaching-jalandhar\",\r\n  \"logo\": \"https://www.ibtenglish.in/assets/upload/setting/logo/1550214297.png\",\r\n  \"image\": \"https://www.ibtenglish.in/assets/upload/setting/logo/1550214297.png\",\r\n  \"description\": \"Looking for best IELTS Coaching Institute in Jalandhar? IBT provides result oriented quality IELTS coaching classes in Jalandhar from professional and certified IELTS trainer.\",\r\n  \"priceRange\":\"INR 14,000\",\r\n  \"aggregateRating\": {\r\n    \"@type\": \"AggregateRating\",\r\n    \"ratingValue\": \"4.8\",\r\n    \"ratingCount\": \"140\"\r\n 	}\r\n}\r\n</script>\r\n\r\n\r\n\r\n<meta name=\"google-site-verification\" content=\"cvauqlrnU7ELaucgyi7HyIVQBAV_bSQwM3fmnCuGy1o\" />\r\n<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-137917645-1\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\'js\', new Date());\r\n\r\n  gtag(\'config\', \'UA-137917645-1\');\r\n</script>\r\n<meta name=\"p:domain_verify\" content=\"3fed29407c2a2e99695183c6d959f6e7\"/>', '1550214297.png', '1542090193.png', '', '   Choose Your Country', ' ', 'Daily Dose', 'Daily Dose for all your preparation needs', '<h2>What&#39;s New</h2>\r\n\r\n<ul>\r\n	<li><a href=\"http://ibtindia.com\" target=\"_blank\">I</a><a href=\"https://www.ibps.in/wp-content/uploads/Notification_Calendar_Examinations_during_2018_2019.pdf\" target=\"_blank\">BT Calender for bank jobs in 2019</a></li>\r\n	<li><a href=\"https://www.makemyexam.in/police-fireman-recruitment-2019-i-apply-online\">UP Police Fireman Recruitment 2019 I Apply Online?</a></li>\r\n	<li><a href=\"https://www.makemyexam.in/cisf-head-constable-2019-recruitment-notification-released\">CISF head constable 2019 | Recruitment notification released</a></li>\r\n	<li><a href=\"https://www.makemyexam.in/ibps-po-2018-19-interview-call-letter-out\">IBPS PO 2018-19 interview call letter out</a></li>\r\n	<li><a href=\"https://www.makemyexam.in/current-affairs-january-25-2019\">Current Affairs January 25, 2019?</a></li>\r\n	<li><a href=\"https://www.makemyexam.in/current-affairs-january-23-and-24-2019\">Current Affairs January 23 &amp; 24, 2019?</a></li>\r\n</ul>\r\n', '2021-02-23 11:01:00', '<div class=\"col-xs-12 col-sm-3 icons\"><img src=\"http://203.122.26.98/development/dev2016/phpdevelopment/IBT/assets/images/02.png\" />\r\n<p>100+<br />\r\nCenters</p>\r\n</div>\r\n');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_setting_data`
--

CREATE TABLE `tbl_setting_data` (
  `id` int(11) NOT NULL,
  `page` enum('student_enq','career','contactus','awards','selection','selections','faq','calc') DEFAULT NULL,
  `banner_photo` varchar(255) NOT NULL,
  `mobile_banner` varchar(255) DEFAULT NULL,
  `meta_tag` longtext NOT NULL,
  `banner_status` int(2) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_setting_data`
--

INSERT INTO `tbl_setting_data` (`id`, `page`, `banner_photo`, `mobile_banner`, `meta_tag`, `banner_status`) VALUES
(1, 'student_enq', '1548062817download.jpeg', '1548062504aamir-khan3.jpg', '<title>IBT ENGLISH PREP - Enrollment Assistance| Customer Relationship Management</title>\r\n<meta name=\"description\" content=\"Have any query related to any career , exams or services they are always ready to solve your query. You want any information or clarification related to any course they are 24*7 to revert you.\">\r\n<meta name=\"keywords\" content=\"Contact Us , Student Enquiry, Education Councellor , Centeralized Enrollment , helpdesk\">\r\n<meta name=\"robots\" content=\"index, follow\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<meta name=\"language\" content=\"English\">\r\n<meta name=\"revisit-after\" content=\"15 days\">\r\n<meta name=\"author\" content=\"IBT ENGLISH PREP\">\r\n<meta property=\"og:type\" content=\"business.business\">\r\n<meta property=\"og:title\" content=\"IBT ENGLISH PREP - Enrollment Assistance| Customer Relationship Management\">\r\n<meta property=\"og:url\" content=\"https://www.ibtenglish.in/students-enquiry\">\r\n<meta property=\"og:image\" content=\"undefined\">\r\n<meta property=\"business:contact_data:street_address\" content=\"IBT IELTS CLASSES, SCO-65, Opposite PIMS, Garha Rd, Jalandhar, Punjab 144022\">\r\n<meta property=\"business:contact_data:locality\" content=\"Jalandhar\">\r\n<meta property=\"business:contact_data:region\" content=\"Punjab\">\r\n<meta property=\"business:contact_data:postal_code\" content=\"144022\">\r\n<meta property=\"business:contact_data:country_name\" content=\"India\">\r\n<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-137917645-1\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\'js\', new Date());\r\n\r\n  gtag(\'config\', \'UA-137917645-1\');\r\n</script>\r\n', 0),
(2, 'career', '34-calendar_(2).jpg', '1548853576rent1.jpg', '<title>IBT ENGLISH PREP - Make your Carrer With IBT</title>\r\n<meta name=\"description\" content=\"If you want to join in IBT for your carrer then you can apply here and can upload your resume here with your full information. While getting your resume IBT Hr team will contact you.\">\r\n<meta name=\"keywords\" content=\"Career , Resumes , Emails , Hr Team , Contact\">\r\n<meta name=\"robots\" content=\"index, follow\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<meta name=\"language\" content=\"English\">\r\n<meta name=\"revisit-after\" content=\"15 days\">\r\n<meta name=\"author\" content=\"IBT ENGLISH PREP\">\r\n<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-137917645-1\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\'js\', new Date());\r\n\r\n  gtag(\'config\', \'UA-137917645-1\');\r\n</script>\r\n<meta property=\"og:type\" content=\"business.business\">\r\n<meta property=\"og:title\" content=\"IBT ENGLISH PREP - Make your Carrer With IBT\">\r\n<meta property=\"og:url\" content=\"https://www.ibtenglish.in/ibt-careers\">\r\n<meta property=\"og:image\" content=\"undefined\">\r\n<meta property=\"business:contact_data:street_address\" content=\"IBT IELTS CLASSES, SCO-65, Opposite PIMS, Garha Rd, Jalandhar, Punjab 144022\">\r\n<meta property=\"business:contact_data:locality\" content=\"Jalandhar\">\r\n<meta property=\"business:contact_data:region\" content=\"Punjab\">\r\n<meta property=\"business:contact_data:postal_code\" content=\"144022\">\r\n<meta property=\"business:contact_data:country_name\" content=\"India\">', 0),
(3, 'contactus', 'banner33_(1).png', '1548062840aamir-khan3.jpg', '<title>IBT ENGLISH PREP - Get Contact Details and Other Information</title>\r\n<meta name=\"description\" content=\"Get contact details and other realted information of contacting with IBT like their address , Email ID and phone number. We have shared our full contact details with you . not tough to reach us.\">\r\n<meta name=\"keywords\" content=\"Contact , Address , Phone , Email\">\r\n<meta name=\"robots\" content=\"index, follow\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<meta name=\"language\" content=\"English\">\r\n<meta name=\"revisit-after\" content=\"15 days\">\r\n<meta name=\"author\" content=\"IBT ENGLISH PREP\">\r\n<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-137917645-1\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\'js\', new Date());\r\n\r\n  gtag(\'config\', \'UA-137917645-1\');\r\n</script>\r\n<meta property=\"og:type\" content=\"business.business\">\r\n<meta property=\"og:title\" content=\"IBT ENGLISH PREP - Get Contact Details and Other Information\">\r\n<meta property=\"og:url\" content=\"https://www.ibtenglish.in/contactus\">\r\n<meta property=\"og:image\" content=\"undefined\">\r\n<meta property=\"business:contact_data:street_address\" content=\"IBT IELTS CLASSES, SCO-65, Opposite PIMS, Garha Rd, Jalandhar, Punjab 144022\">\r\n<meta property=\"business:contact_data:locality\" content=\"Jalandhar\">\r\n<meta property=\"business:contact_data:region\" content=\"Punjab\">\r\n<meta property=\"business:contact_data:postal_code\" content=\"144022\">\r\n<meta property=\"business:contact_data:country_name\" content=\"India\">', 0),
(4, 'awards', '15502379867159fa358c9fb86b01cd0f7c192db6f221_c29721fe245724aad2a6ac0bca49f11b.jpg', '1550237986main-banner.png', '<title>Awards</title>', 1),
(5, 'selection', '1548065311download.jpeg', '1548065311aamir-khan3.jpg', '<title>Selection</title>', 0),
(6, 'selections', '1550223972banner2.png', '1548066954aamir-khan3.jpg', '<title>IBT ENGLISH PREP - Top students of IBT selected in English Courses Exams</title>\r\n<meta name=\"description\" content=\"Here we have provided you the list of selected students who crossed different english courses exams. This will also help you to select IBT.\">\r\n<meta name=\"keywords\" content=\"Selected Students , Selctions of IBT Students , IELTS , English Spoken Exams\">\r\n<meta name=\"robots\" content=\"index, follow\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<meta name=\"language\" content=\"English\">\r\n<meta name=\"revisit-after\" content=\"15 days\">\r\n<meta name=\"author\" content=\"IBT ENGLISH PREP\">\r\n<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-137917645-1\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\'js\', new Date());\r\n\r\n  gtag(\'config\', \'UA-137917645-1\');\r\n</script>\r\n<meta property=\"og:type\" content=\"business.business\">\r\n<meta property=\"og:title\" content=\"IBT ENGLISH PREP - Top students of IBT selected in English Courses Exams\">\r\n<meta property=\"og:url\" content=\"https://www.ibtenglish.in/selection\">\r\n<meta property=\"og:image\" content=\"undefined\">\r\n<meta property=\"business:contact_data:street_address\" content=\"IBT IELTS CLASSES, SCO-65, Opposite PIMS, Garha Rd, Jalandhar, Punjab 144022\">\r\n<meta property=\"business:contact_data:locality\" content=\"Jalandhar\">\r\n<meta property=\"business:contact_data:region\" content=\"Punjab\">\r\n<meta property=\"business:contact_data:postal_code\" content=\"144022\">\r\n<meta property=\"business:contact_data:country_name\" content=\"India\">', 0),
(7, 'faq', '1550303175main-banner.png', '1550303089pic12.jpg', '<title>IBT ENGLISH PREP - FAQ |IELTS |CD - IELTS |PTE | CELPIP|Spoken English | TOEFL</title>\r\n<meta name=\"description\" content=\"When you join any course related to english spoken you have many questions and you want to know the answers of those questions , we have provided the FAQ\'s here but if you have your own questions you can ask here.\">\r\n<meta name=\"keywords\" content=\"Questions , FAQ\'s , Answers , IELTS , Spoken English \">\r\n<meta name=\"robots\" content=\"index, follow\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<meta name=\"language\" content=\"English\">\r\n<meta name=\"revisit-after\" content=\"15 days\">\r\n<meta name=\"author\" content=\"IBT ENGLISH PREP\">\r\n<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-137917645-1\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\'js\', new Date());\r\n\r\n  gtag(\'config\', \'UA-137917645-1\');\r\n</script>\r\n<meta property=\"og:type\" content=\"business.business\">\r\n<meta property=\"og:title\" content=\"IBT ENGLISH PREP - FAQ |IELTS |CD - IELTS |PTE | CELPIP|Spoken English | TOEFL\">\r\n<meta property=\"og:url\" content=\"https://www.ibtenglish.in/faq\">\r\n<meta property=\"og:image\" content=\"undefined\">\r\n<meta property=\"business:contact_data:street_address\" content=\"IBT IELTS CLASSES, SCO-65, Opposite PIMS, Garha Rd, Jalandhar, Punjab 144022\">\r\n<meta property=\"business:contact_data:locality\" content=\"Jalandhar\">\r\n<meta property=\"business:contact_data:region\" content=\"Punjab\">\r\n<meta property=\"business:contact_data:postal_code\" content=\"144022\">\r\n<meta property=\"business:contact_data:country_name\" content=\"India\">', 0),
(8, 'calc', '1550303258main-banner.png', '155030325837bc171bbec873547ca19161aaf1b1d43acf66d8d0482b1427f6d51034165919-770x443.jpg', '<title>IBT ENGLISH PREP - Calculator for IELTS Band</title>\r\n<meta name=\"description\" content=\"IBT provides you the band calculator of IELTS through which you can calculate your scores of listening , Academic reading , General reading. It will be very helpful for you.\">\r\n<meta name=\"keywords\" content=\"IELTS band calculator general , IELTS band calculator academic ,IELTS band calculator reading , IELTS band calculator listening , IELTS band score calculator\">\r\n<meta name=\"robots\" content=\"index, follow\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<meta name=\"language\" content=\"English\">\r\n<meta name=\"revisit-after\" content=\"15 days\">\r\n<meta name=\"author\" content=\"IBT ENGLISH PREP\">\r\n<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-137917645-1\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\'js\', new Date());\r\n\r\n  gtag(\'config\', \'UA-137917645-1\');\r\n</script>\r\n<meta property=\"og:type\" content=\"business.business\">\r\n<meta property=\"og:title\" content=\"IBT ENGLISH PREP - Calculator for IELTS Band\">\r\n<meta property=\"og:url\" content=\"https://www.ibtenglish.in/ielts-band-calculator\">\r\n<meta property=\"og:image\" content=\"undefined\">\r\n<meta property=\"business:contact_data:street_address\" content=\"IBT IELTS CLASSES, SCO-65, Opposite PIMS, Garha Rd, Jalandhar, Punjab 144022\">\r\n<meta property=\"business:contact_data:locality\" content=\"Jalandhar\">\r\n<meta property=\"business:contact_data:region\" content=\"Punjab\">\r\n<meta property=\"business:contact_data:postal_code\" content=\"144022\">\r\n<meta property=\"business:contact_data:country_name\" content=\"India\">', 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_social_setting`
--

CREATE TABLE `tbl_social_setting` (
  `id` int(11) NOT NULL,
  `social_type` varchar(255) NOT NULL,
  `social_icon` varchar(255) NOT NULL,
  `social_link` varchar(255) NOT NULL,
  `visibile_on_footer` int(11) NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_social_setting`
--

INSERT INTO `tbl_social_setting` (`id`, `social_type`, `social_icon`, `social_link`, `visibile_on_footer`, `date_created`) VALUES
(1, 'Facebook', '<i class=\"fa fa-facebook\" aria-hidden=\"true\"></i>', 'https://www.facebook.com/IBTIELTSJALANDHAR/', 0, '2021-02-23 07:04:08'),
(2, 'Twitter', '<i class=\"fa fa-twitter\" aria-hidden=\"true\"></i>', 'https://twitter.com/', 0, '2021-02-23 07:04:08'),
(3, 'Pinterest', '<i class=\"fa fa-pinterest\" aria-hidden=\"true\"></i>', 'zcvg', 0, '2021-02-23 07:04:08'),
(4, 'Google Plus', '<i class=\"fa fa-google-plus\" aria-hidden=\"true\"></i>', 'https://www.facebook.com/IBTIELTSJALANDHAR/', 0, '2021-02-23 07:04:08'),
(5, 'LinkedIn', '<i class=\"fa fa-linkedin\" aria-hidden=\"true\"></i>', 'https://in.linkedin.com/', 0, '2021-02-23 07:04:08');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_state`
--

CREATE TABLE `tbl_state` (
  `id` int(11) NOT NULL,
  `direction` enum('North','East','South','West') DEFAULT NULL,
  `state_name` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_state`
--

INSERT INTO `tbl_state` (`id`, `direction`, `state_name`, `status`, `cdate`) VALUES
(58, NULL, 'Punjab', 1, '2019-03-29 07:07:08'),
(59, NULL, 'Ahmedabad', 1, '2019-09-13 06:52:44'),
(60, NULL, 'Maharashtra', 1, '2020-02-10 06:11:25');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_student_enquiry`
--

CREATE TABLE `tbl_student_enquiry` (
  `id` int(11) NOT NULL,
  `student_name` varchar(255) NOT NULL,
  `student_mobile` varchar(255) DEFAULT NULL,
  `student_email` varchar(255) DEFAULT NULL,
  `student_course` varchar(255) DEFAULT NULL,
  `student_state` varchar(255) DEFAULT NULL,
  `student_center` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_student_support`
--

CREATE TABLE `tbl_student_support` (
  `id` int(11) NOT NULL,
  `type` enum('class_room','online_test','course_material','correspondence_course') NOT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `subheading` varchar(255) DEFAULT NULL,
  `data` longtext,
  `meta_tag` longtext,
  `banner_photo` varchar(255) DEFAULT NULL,
  `mobile_banner` varchar(255) DEFAULT NULL,
  `banner_status` int(2) DEFAULT '1',
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_student_support`
--

INSERT INTO `tbl_student_support` (`id`, `type`, `heading`, `subheading`, `data`, `meta_tag`, `banner_photo`, `mobile_banner`, `banner_status`, `status`, `cdate`) VALUES
(1, 'class_room', 'CLASS ROOM COURSES', 'We assure 100% student satisfaction, If still we lack please share', '[\"Faculty not able to meet students\' expectations\",\"Weekly schedule not prepared\\/displayed or followed.\",\"Login\\/Password issues\",\"Study Material not provided\",\"Payment receipt not given at the time of payment.\",\"Membership card not issued by the center\"]', '<title>Student Support</title>', '34-calendar_(2).jpg', 'download.jpeg', 0, 1, '2018-12-11 06:13:19'),
(2, 'online_test', 'ONLINE TEST SERIES', 'ONLINE TEST SERIES', '[\"Purchase and activation of Test Series\",\"Content Error\",\"Unable to access services\\/tests\",\"Queries related to test,schedules\",\"Test not working properly on Mobile Apps\",\"Login\\/Password issues\"]', '<title>Student Support</title>', NULL, NULL, NULL, 1, '2018-12-11 06:13:19'),
(3, 'course_material', 'COURSE MATERIAL', 'We sell best updated study material, If still we lack please share', '[\"Purchase of Course Material\",\"Content Error\",\"Course Material not received on time\",\"Academic queries related to Study material\"]', '<title>Student Support</title>', NULL, NULL, NULL, 1, '2018-12-11 06:15:46'),
(4, 'correspondence_course', 'CORRESPONDENCE COURSE', 'We assure 100% student satisfaction through correspondence course, If still we lack please share', '[\"Purchase and activation of Correspondence course\",\"Unable to access services\\/tests\",\"Test not working properly on Mobile Apps\",\"Login\\/Password issues\",\"Purchase of Course Material\",\"Content Error\",\"Course Material not received on time\",\"Academic queries related to Study material\"]', '<title>Student Support</title>', NULL, NULL, NULL, 1, '2018-12-11 06:15:46');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_student_support_enquiry`
--

CREATE TABLE `tbl_student_support_enquiry` (
  `id` int(11) NOT NULL,
  `enq_message` longtext NOT NULL,
  `enq_type` enum('classroom','online_test','course_material','correspondence_course') NOT NULL,
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_subscriber`
--

CREATE TABLE `tbl_subscriber` (
  `id` int(11) NOT NULL,
  `subscriber` varchar(255) DEFAULT NULL,
  `subscribed_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_subscriber`
--

INSERT INTO `tbl_subscriber` (`id`, `subscriber`, `subscribed_on`) VALUES
(15, 'arun@uniquecoder.com/9711652294', '2018-11-14 10:35:41'),
(16, 'test@gmail.com', '2018-11-14 10:36:04');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_testimonial`
--

CREATE TABLE `tbl_testimonial` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  `photo` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '1',
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_testimonial`
--

INSERT INTO `tbl_testimonial` (`id`, `name`, `description`, `photo`, `status`, `cdate`) VALUES
(4, 'SHRUTI', 'My experience with IBT was very great. IBT provides Grammar and Basic English classes for weak students. They conduct Mock Interview 3-4 times in a day to improve our communication skills. IBT trainers are well experienced and knowledgeable. I got 7 bands each in IELTS.', 'BeautyPlus_20190329161726217_save1.jpg', 1, '2018-10-22 08:27:18'),
(5, 'ANSHUL KUMAR', 'It is a great pleasure being a part of IBT. It is a great institution with innovative approach of learning. The faculty members and staff are very much experienced and always helpful. Atmosphere is great over here with high standard. My best wishes are always with IBT.', 'BeautyPlus_20190329161740147_save.jpg', 1, '2018-10-22 09:28:28'),
(6, 'RAMESH KUMAR', 'My experience with IBT was very fabulous, I was guided very well. The best part is that they strictly not allow anyone to speak in Punjabi and Hindi in classes. I am improving day by day and now i am able to communicate with my friends in English. Thanks you IBT Staff.', 'BeautyPlus_20190329161806520_save.jpg', 1, '2019-01-22 07:18:50'),
(7, 'YASHICA', 'It was fabulous experience with IBT Institute as they have provided each and every service and all the teachers of IBT Institute have helped me alot. The best part is the full day classes which helped me alot to do enough practice to get 7 Bands in IELTS. Thank you IBT.\r\n', 'BeautyPlus_20190329161707980_save.jpg', 1, '2019-02-08 11:12:31'),
(8, 'Kamaljit kaur', 'My experience at IBT was great. I learnt about my mistakes I do while speaking and writing. My teacher was very cooperative. Study environment and SMART CLASSES provided by them was up to date.  I\'m very happy that I went to IBT for IELTS. ', 'kamaljit_pic.jpg', 1, '2019-11-13 09:40:46'),
(9, 'Gaurav', 'Classes were very helpful in preparation for IELTS examination. Staff and teachers were very supportive during the entire course. Emphasis should be given on writing section as I felt that listening and reading could be managed. Overall I felt it was good to be prepared from the IBT Institute.', 'GAURAV_PIC.png', 1, '2019-11-13 09:42:57'),
(10, 'Harpreet', 'It\'s a place where you can excel your hidden talents. I don\'t like to read/ reading. But after going to classes here I was able to get interest and I did very well in my reading test(main exam). This shows that IELTS academy as encouraged me and trained me to get success in the main exam. On the whole it\'s the place where you can learn a progress to your success.', 'HARPREET_PIC.jpg', 1, '2019-11-13 09:44:43'),
(11, 'Sahil', 'Thank you for helping and guiding me to prepare for my IELTS exam. It would not have been possible without your efforts to score 8 bands in the first go. Just 4 hours of classes worked wonders for me. You helped me a lot and I am very grateful to you. Thank you. ', 'sahil_pic.jpg', 1, '2019-11-13 09:46:22'),
(12, 'Vagisha', 'The faculty is really good, especially Ms. Neha and Ms. Jaspreet Mam, their way of teaching and giving attention to each student is nice. They covered parts of speech and tenses and other grammar portions which was a refresh for us and was very useful. ', 'vagisha_pic.jpg', 1, '2019-11-13 09:48:25'),
(13, 'Barjesh', 'I attended the IELTS classes at IBT Institute. IBT made us familiar with the actual test format which helped me gain confidence in the test day. The study material is comprehensive and smart classes are really helpful. IBT helped me to score 7.5 bands in IELTS.', 'BARJESH_PIC.png', 1, '2019-11-13 09:52:22'),
(14, 'Gaurav', 'I was a student of IELTS at IBT. The teachers and the staff at IBT not only gave me all the attention and guidance but also planned out an effective schedule for me to get a good score in my IELTS exam in very less time. I am glad that I scored good and chose IBT.', 'GAURAV_PIC.jpeg', 1, '2019-11-13 09:53:33'),
(15, 'Rajwinder kaur', 'IBt for me was an assistance to face IELTS, but I was wrong. IBT was a lot more than that.To begin with the faculty here is highly proficient, attending these classes helped polish my English language skills. Overall, I am enthralled to have been part of this institution.', 'Rajwinder.jpg', 1, '2019-11-13 09:55:32'),
(16, 'Karanveer', 'IBT provided me with the resources and the necessary skills to improve my command on English language as per International Norms.  The faculty gave personal attention to everyone which served as a major factor in improving our mistakes. I recommend IBT to everyone for IELTS.', 'Karanveer.jpg', 1, '2019-11-13 09:57:04'),
(17, 'Pallavi', '\"I would not have been able to score so well if it wasn’t for the help of the IELTS instructors at IBT. I thank them for their guidance.”', 'Pallavi.jpg', 1, '2019-11-13 09:58:50');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_url`
--

CREATE TABLE `tbl_url` (
  `id` int(11) NOT NULL,
  `to_url` varchar(255) DEFAULT NULL,
  `from_url` varchar(255) DEFAULT NULL,
  `cdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_academic_resourses`
--
ALTER TABLE `tbl_academic_resourses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_banner`
--
ALTER TABLE `tbl_banner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_career_job_apply`
--
ALTER TABLE `tbl_career_job_apply`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_center`
--
ALTER TABLE `tbl_center`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_center_setting`
--
ALTER TABLE `tbl_center_setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_cms`
--
ALTER TABLE `tbl_cms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_country`
--
ALTER TABLE `tbl_country`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_course`
--
ALTER TABLE `tbl_course`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_course_category`
--
ALTER TABLE `tbl_course_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_course_zone`
--
ALTER TABLE `tbl_course_zone`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_document`
--
ALTER TABLE `tbl_document`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_download`
--
ALTER TABLE `tbl_download`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_download_category`
--
ALTER TABLE `tbl_download_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_enquiry`
--
ALTER TABLE `tbl_enquiry`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_enquiry_contactus`
--
ALTER TABLE `tbl_enquiry_contactus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_enquiry_franchise`
--
ALTER TABLE `tbl_enquiry_franchise`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_exam_pre`
--
ALTER TABLE `tbl_exam_pre`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_faq`
--
ALTER TABLE `tbl_faq`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_faq_category`
--
ALTER TABLE `tbl_faq_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_franchise`
--
ALTER TABLE `tbl_franchise`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_home_banner_section`
--
ALTER TABLE `tbl_home_banner_section`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_job_category`
--
ALTER TABLE `tbl_job_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_landing_page`
--
ALTER TABLE `tbl_landing_page`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_landing_page_left`
--
ALTER TABLE `tbl_landing_page_left`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_landing_page_right`
--
ALTER TABLE `tbl_landing_page_right`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_landing_page_section`
--
ALTER TABLE `tbl_landing_page_section`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_media_event`
--
ALTER TABLE `tbl_media_event`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_menu`
--
ALTER TABLE `tbl_menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_mobile_number`
--
ALTER TABLE `tbl_mobile_number`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_our_center`
--
ALTER TABLE `tbl_our_center`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_popup`
--
ALTER TABLE `tbl_popup`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_programe_enquiry`
--
ALTER TABLE `tbl_programe_enquiry`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_programme`
--
ALTER TABLE `tbl_programme`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_program_cat`
--
ALTER TABLE `tbl_program_cat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_program_subcat`
--
ALTER TABLE `tbl_program_subcat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_selected_student`
--
ALTER TABLE `tbl_selected_student`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_selections`
--
ALTER TABLE `tbl_selections`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_setting`
--
ALTER TABLE `tbl_setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_setting_data`
--
ALTER TABLE `tbl_setting_data`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_social_setting`
--
ALTER TABLE `tbl_social_setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_state`
--
ALTER TABLE `tbl_state`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_student_enquiry`
--
ALTER TABLE `tbl_student_enquiry`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_student_support`
--
ALTER TABLE `tbl_student_support`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_student_support_enquiry`
--
ALTER TABLE `tbl_student_support_enquiry`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_subscriber`
--
ALTER TABLE `tbl_subscriber`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_testimonial`
--
ALTER TABLE `tbl_testimonial`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_url`
--
ALTER TABLE `tbl_url`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_academic_resourses`
--
ALTER TABLE `tbl_academic_resourses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_banner`
--
ALTER TABLE `tbl_banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `tbl_career_job_apply`
--
ALTER TABLE `tbl_career_job_apply`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `tbl_center`
--
ALTER TABLE `tbl_center`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_center_setting`
--
ALTER TABLE `tbl_center_setting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_cms`
--
ALTER TABLE `tbl_cms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `tbl_country`
--
ALTER TABLE `tbl_country`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=256;

--
-- AUTO_INCREMENT for table `tbl_course`
--
ALTER TABLE `tbl_course`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `tbl_course_category`
--
ALTER TABLE `tbl_course_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_course_zone`
--
ALTER TABLE `tbl_course_zone`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_document`
--
ALTER TABLE `tbl_document`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `tbl_download`
--
ALTER TABLE `tbl_download`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `tbl_download_category`
--
ALTER TABLE `tbl_download_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `tbl_enquiry`
--
ALTER TABLE `tbl_enquiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_enquiry_contactus`
--
ALTER TABLE `tbl_enquiry_contactus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_enquiry_franchise`
--
ALTER TABLE `tbl_enquiry_franchise`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_exam_pre`
--
ALTER TABLE `tbl_exam_pre`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_faq`
--
ALTER TABLE `tbl_faq`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- AUTO_INCREMENT for table `tbl_faq_category`
--
ALTER TABLE `tbl_faq_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_franchise`
--
ALTER TABLE `tbl_franchise`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_home_banner_section`
--
ALTER TABLE `tbl_home_banner_section`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_job_category`
--
ALTER TABLE `tbl_job_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tbl_landing_page`
--
ALTER TABLE `tbl_landing_page`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_landing_page_left`
--
ALTER TABLE `tbl_landing_page_left`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `tbl_landing_page_right`
--
ALTER TABLE `tbl_landing_page_right`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_landing_page_section`
--
ALTER TABLE `tbl_landing_page_section`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `tbl_media_event`
--
ALTER TABLE `tbl_media_event`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `tbl_menu`
--
ALTER TABLE `tbl_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96;

--
-- AUTO_INCREMENT for table `tbl_mobile_number`
--
ALTER TABLE `tbl_mobile_number`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `tbl_our_center`
--
ALTER TABLE `tbl_our_center`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_popup`
--
ALTER TABLE `tbl_popup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `tbl_programe_enquiry`
--
ALTER TABLE `tbl_programe_enquiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_programme`
--
ALTER TABLE `tbl_programme`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_program_cat`
--
ALTER TABLE `tbl_program_cat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_program_subcat`
--
ALTER TABLE `tbl_program_subcat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_selected_student`
--
ALTER TABLE `tbl_selected_student`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `tbl_selections`
--
ALTER TABLE `tbl_selections`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `tbl_setting`
--
ALTER TABLE `tbl_setting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_setting_data`
--
ALTER TABLE `tbl_setting_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_social_setting`
--
ALTER TABLE `tbl_social_setting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_state`
--
ALTER TABLE `tbl_state`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `tbl_student_enquiry`
--
ALTER TABLE `tbl_student_enquiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_student_support`
--
ALTER TABLE `tbl_student_support`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbl_student_support_enquiry`
--
ALTER TABLE `tbl_student_support_enquiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_subscriber`
--
ALTER TABLE `tbl_subscriber`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `tbl_testimonial`
--
ALTER TABLE `tbl_testimonial`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `tbl_url`
--
ALTER TABLE `tbl_url`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

