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

START TRANSACTION;



--
-- Database: `karnal_international`
--

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

--
-- Table structure for table `about`
--

CREATE TABLE `about` (
  `id` int(11) NOT NULL,
  `text` text NOT NULL,
  `vision` text NOT NULL,
  `mission` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `about`
--

INSERT INTO `about` (`id`, `text`, `vision`, `mission`, `created_at`, `updated_at`) VALUES
(3, 'Karnal International School Lush, Green & pollution free spread over 3.5 acres & housed in a thoughtfully designed building in Kunjpura, Karnal. The Karnal International is recognised by the Department of Education & affiliated to C.B.S.E. New Delhi aims to achieve a program that Gurukul with modern techniques, adjusted to changing times in order to provide a complete learning environment for your child.\r\n\r\nKIS endeavours to partner the overall learning process and development of your child, starting from the early years Progressive and secular in its philosophy, KIS follows a child oriented approach, looking upon each child as an individual & providing an educational programme which stresses the important of the total development of the child – head heart & hand.\r\n\r\nEducation is the opportunity of life. Our vision is to provide value – based education with new innovations and ideas so that our pupils grow into aesthetically aware and integrated young people. Hence, parents can afford, Karnal International School, but cannot afford to miss it.', 'Our vision is to bring our students into 21st century through innovation & modern technology. Learning will be enhanced with computer software and extracurricular activity – thereby allowing the students to proceed at their own pace according to their ability.', 'Our mission is imparting futuristic holistic education through experinced and highly qualified and dedicated staff.', '2022-03-10 19:18:44', '2022-03-10 19:18:44');

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

--
-- Table structure for table `academic_calender`
--

CREATE TABLE `academic_calender` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `month_title` text NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `image` varchar(512) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `admission_query` (
  `id` int(11) NOT NULL,
  `student_name` text NOT NULL,
  `father_name` text NOT NULL,
  `email` varchar(512) NOT NULL,
  `phone` text NOT NULL,
  `class` text NOT NULL,
  `enquiry_for` text NOT NULL,
  `msg` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `admission_query` (`id`, `student_name`, `father_name`, `email`, `phone`, `class`, `enquiry_for`, `msg`, `created_at`, `updated_at`) VALUES
(1, 'Pawan', 'kishan singh', 'pa@gmail.com', '9896907582', '11TH CLASS', 'Admission', 'hii', '2022-03-08 16:14:30', '2022-03-08 16:14:30');

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

--
-- Table structure for table `athletics`
--

CREATE TABLE `athletics` (
  `id` int(11) NOT NULL,
  `sport_name` text NOT NULL,
  `description` varchar(512) NOT NULL,
  `image` varchar(512) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `athletics`
--

INSERT INTO `athletics` (`id`, `sport_name`, `description`, `image`, `created_at`, `updated_at`) VALUES
(2, 'Net Ball', 'Netball is a ball sport played by two teams of seven players. Games are played on a rectangular court with raised goal rings at each end.', '1646802073.jpeg', '2022-03-09 12:01:13', '2022-03-09 12:01:13'),
(3, 'Kho-Kho', 'Kho-kho is played by two teams of twelve nominated players out of fifteen, of which nine enter the field who sit on their knees (Chasing Team), and three extra (Defending Team) who try to avoid being touched by members of the other opposing team.', '1646802250.jpeg', '2022-03-09 12:04:10', '2022-03-09 12:04:10'),
(4, 'Judo', 'Judo is a modern martial art which was traditionally practiced as a gentle way of defense. Working the physical, mental and moral agility for best moves of defense, today the art has established itself as a sport. Being a part of Olympic and involving special training, Judo instills in students the ability to take down the opponent and thus make them able to fight with situations and people in times of need.', '1646802315.png', '2022-03-09 12:05:15', '2022-03-09 12:05:15'),
(5, 'Karate', 'Karate on the other hand is a traditional martial art from China with striking as the base. It involves punching, kicking, elbow strikes and knee strikes as its mechanism to', '1646802383.JPG', '2022-03-09 12:06:23', '2022-03-09 12:06:23'),
(6, 'TaeKwando', 'Taekwando martial art form is associated with continuous kicking, and punching techniques. It is \"The art of Kicking and Punching\" or \"The art of unarmed combat\".', '1646802532.jpeg', '2022-03-09 05:08:52', '2022-03-09 12:08:52'),
(7, 'Basketball', 'It is a very popular sport worldwide, played with a round and usually orange(orange-brown) ball that bounces. Basketball players mainly use skills such as dribbling, shooting, running, and jumping. Each made basket is worth two points, while a basket made from beyond the three-point line is worth three points.', '1646802482.jpeg', '2022-03-09 12:08:02', '2022-03-09 12:08:02'),
(8, 'Kabaddi', 'Kabaddi is a team sport. Two teams are on opposite halves of a small field. They take turns sending a \"raider\" into the other half. This is to win points by tackling members of the opposing team.', '1646802506.jpeg', '2022-03-09 12:08:26', '2022-03-09 12:08:26');

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `focus_text` text,
  `image` varchar(512) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `title`, `focus_text`, `image`, `created_at`, `updated_at`) VALUES
(2, 'Welcome To', 'Karnal International School', '1646914272.png', '2022-03-10 19:11:12', '2022-03-10 19:11:12'),
(3, 'Meet', 'Our Experts', '1646914315.png', '2022-03-10 19:11:55', '2022-03-10 19:11:55');

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

--
-- Table structure for table `books`
--

CREATE TABLE `books` (
  `id` int(11) NOT NULL,
  `book_name` text NOT NULL,
  `class_name` text NOT NULL,
  `file` varchar(512) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `books`
--

INSERT INTO `books` (`id`, `book_name`, `class_name`, `file`, `created_at`, `updated_at`) VALUES
(3, 'Ist Class Books', '1st', '1646725142.pdf', '2022-03-08 14:39:02', '2022-03-08 14:39:02'),
(4, '2nd Class', '2nd', '1646725156.pdf', '2022-03-08 14:39:16', '2022-03-08 14:39:16'),
(5, '3rd', '3rd', '1646725167.pdf', '2022-03-08 14:39:27', '2022-03-08 14:39:27'),
(6, '4th class', '4th', '1646725183.pdf', '2022-03-08 14:39:43', '2022-03-08 14:39:43'),
(7, '5th class', '5th', '1646725194.pdf', '2022-03-08 14:39:54', '2022-03-08 14:39:54'),
(8, '6th class', '6th', '1646725813.pdf', '2022-03-08 14:50:13', '2022-03-08 14:50:13'),
(9, '7th class', '7th', '1646725826.pdf', '2022-03-08 14:50:26', '2022-03-08 14:50:26'),
(10, '8th class', '8th', '1646725839.pdf', '2022-03-08 14:50:39', '2022-03-08 14:50:39'),
(11, '9th class', '9th', '1646725855.pdf', '2022-03-08 14:50:55', '2022-03-08 14:50:55'),
(12, '10th class', '10th', '1646725878.pdf', '2022-03-08 14:51:18', '2022-03-08 14:51:18'),
(13, '11th class', '11th', '1646725993.pdf', '2022-03-08 14:53:13', '2022-03-08 14:53:13'),
(14, '12th class', '12th', '1646726008.pdf', '2022-03-08 14:53:28', '2022-03-08 14:53:28');

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

--
-- Table structure for table `campus_tour_appointment`
--

CREATE TABLE `campus_tour_appointment` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `date` date NOT NULL,
  `time` text NOT NULL,
  `phone` text NOT NULL,
  `email` varchar(512) NOT NULL,
  `special_request` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `campus_tour_appointment`
--

INSERT INTO `campus_tour_appointment` (`id`, `name`, `date`, `time`, `phone`, `email`, `special_request`, `created_at`, `updated_at`) VALUES
(1, 'pawan', '2022-03-14', '11 a.m.', '07896541230', 'pp1322420@gmail.com', NULL, '2022-03-08 17:32:07', '2022-03-08 17:32:07');

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `email` varchar(512) DEFAULT NULL,
  `message` varchar(512) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` (`id`, `name`, `email`, `message`, `created_at`, `updated_at`) VALUES
(1, 'Pawan yadav', 'hs@gmail.com', 'gj', '2022-02-25 12:33:18', '0000-00-00 00:00:00'),
(2, 'Pawan yadav', 'grv@gmail.com', 'uuu', '2022-02-25 12:33:18', '0000-00-00 00:00:00'),
(3, 'Doon Valley College', 'vv1322420@gmail.com', 'hhh', '2022-02-25 12:33:18', '0000-00-00 00:00:00'),
(4, 'Doon Valley College', 'ashok123@gmail.com', 'jhjj', '2022-02-25 12:33:18', '0000-00-00 00:00:00'),
(5, 'index.php', 'pp1322420@gmail.com', 'jj', '2022-02-25 12:33:18', '0000-00-00 00:00:00');

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

--
-- Table structure for table `curicular`
--

CREATE TABLE `curicular` (
  `id` int(11) NOT NULL,
  `curicular_name` text NOT NULL,
  `image` varchar(512) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `title` text,
  `description` text,
  `category` int(255) DEFAULT NULL,
  `image` varchar(512) DEFAULT NULL,
  `video_link` varchar(512) DEFAULT NULL,
  `status` int(255) NOT NULL,
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `updated_at` timestamp(6) NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `title`, `description`, `category`, `image`, `video_link`, `status`, `created_at`, `updated_at`) VALUES
(10, 'Morning Assembley', NULL, 3, '1646216558.jpeg', NULL, 1, '2022-03-02 17:22:38.000000', '2022-03-02 17:22:38.000000'),
(11, NULL, NULL, 3, '1646216565.jpeg', NULL, 1, '2022-03-02 17:22:45.000000', '2022-03-02 17:22:45.000000'),
(24, 'Awards', NULL, 7, '1646218704.jpg', NULL, 1, '2022-03-02 17:58:26.000000', '2022-03-02 17:58:26.000000'),
(25, 'Awards', NULL, 7, '1646218723.jpg', NULL, 1, '2022-03-02 17:58:46.000000', '2022-03-02 17:58:46.000000'),
(26, 'Awards', NULL, 7, '1646218742.jpg', NULL, 1, '2022-03-02 17:59:02.000000', '2022-03-02 17:59:02.000000'),
(27, 'Awards', NULL, 7, '1646218810.jpg', NULL, 1, '2022-03-02 18:00:14.000000', '2022-03-02 18:00:14.000000'),
(28, 'Awards', NULL, 7, '1646218831.jpg', NULL, 1, '2022-03-02 18:00:34.000000', '2022-03-02 18:00:34.000000'),
(29, 'Awards', NULL, 7, '1646218850.jpg', NULL, 1, '2022-03-02 18:00:54.000000', '2022-03-02 18:00:54.000000'),
(30, 'Awards', NULL, 7, '1646218872.jpg', NULL, 1, '2022-03-02 18:01:15.000000', '2022-03-02 18:01:15.000000'),
(31, 'Awards', NULL, 7, '1646218902.jpg', NULL, 1, '2022-03-02 18:01:42.000000', '2022-03-02 18:01:42.000000'),
(32, 'Awards', NULL, 7, '1646218920.jpg', NULL, 1, '2022-03-02 18:02:03.000000', '2022-03-02 18:02:03.000000'),
(33, 'Sports Day', NULL, 8, '1646219415.JPG', NULL, 1, '2022-03-02 18:10:15.000000', '2022-03-02 18:10:15.000000'),
(34, 'Sports Day', NULL, 8, '1646219429.JPG', NULL, 1, '2022-03-02 18:10:30.000000', '2022-03-02 18:10:30.000000'),
(35, 'Sports Day', NULL, 8, '1646219449.JPG', NULL, 1, '2022-03-02 18:10:49.000000', '2022-03-02 18:10:49.000000'),
(36, 'Sports Day', NULL, 8, '1646219464.JPG', NULL, 1, '2022-03-02 18:11:04.000000', '2022-03-02 18:11:04.000000'),
(37, 'Sports', NULL, 8, '1646219502.JPG', NULL, 1, '2022-03-02 18:11:45.000000', '2022-03-02 18:11:45.000000'),
(38, 'Sports Day', NULL, 8, '1646219520.JPG', NULL, 1, '2022-03-02 18:12:00.000000', '2022-03-02 18:12:00.000000'),
(39, 'Sports Days', NULL, 8, '1646219533.JPG', NULL, 1, '2022-03-02 18:12:14.000000', '2022-03-02 18:12:14.000000'),
(40, 'Sports Day', NULL, 8, '1646219554.JPG', NULL, 1, '2022-03-02 18:12:37.000000', '2022-03-02 18:12:37.000000'),
(41, 'Sports Day', NULL, 8, '1646219570.JPG', NULL, 1, '2022-03-02 18:12:50.000000', '2022-03-02 18:12:50.000000'),
(42, 'Sports Day', NULL, 8, '1646219582.JPG', NULL, 1, '2022-03-02 18:13:05.000000', '2022-03-02 18:13:05.000000'),
(43, 'Sports Day', NULL, 8, '1646219619.JPG', NULL, 1, '2022-03-02 18:13:39.000000', '2022-03-02 18:13:39.000000'),
(44, 'Sports Day', NULL, 8, '1646219639.JPG', NULL, 1, '2022-03-02 18:14:02.000000', '2022-03-02 18:14:02.000000'),
(45, 'Sports Day', NULL, 8, '1646219667.JPG', NULL, 1, '2022-03-02 18:14:27.000000', '2022-03-02 18:14:27.000000'),
(46, 'Sports Day', NULL, 8, '1646219692.JPG', NULL, 1, '2022-03-02 18:14:52.000000', '2022-03-02 18:14:52.000000'),
(53, 'video', NULL, 2, NULL, 'KawNHf4kaJY', 1, '2022-03-03 10:22:34.750757', '2022-03-03 17:22:34.000000');

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

--
-- Table structure for table `gallery_categories`
--

CREATE TABLE `gallery_categories` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gallery_categories`
--

INSERT INTO `gallery_categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(2, 'Videos', '2022-03-02 15:55:58', '2022-03-02 15:55:58'),
(3, 'Morning-assembely', '2022-03-02 15:56:08', '2022-03-02 15:56:08'),
(7, 'Awards', '2022-03-02 17:42:51', '2022-03-02 17:42:51'),
(8, 'Sports', '2022-03-02 17:51:26', '2022-03-02 17:51:26');

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

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `message` text NOT NULL,
  `msg_to` varchar(512) NOT NULL,
  `image` varchar(512) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `message`
--

INSERT INTO `message` (`id`, `name`, `message`, `msg_to`, `image`, `created_at`, `updated_at`) VALUES
(2, 'Mrs. Krishna Lather', 'With a great sense of pride and privilege, I welcome you to our school website.  We hope our pages give you an informative and useful overview of the campus in addition to an insight into the underlying mission and philosophy that govern the school. In keeping with our school motto, ‘FUTURE FIT, FUTURE READY‘we seek that our children will be ready for each and every situation and will be fit for top notch jobs.\r\n \r\nOur prime concern is a safe and conducive environment where students can develop a sense of belongingness and indulge in meaningful learning experiences. We endeavour to strive for academic excellence for which we constantly challenge ourselves and set new benchmarks.\r\n‘Quality’ is the key word here at Karnal International school, Kunjpura (KIS ). We focus on teaching our students on ‘how to think’ rather than ‘what to think’. Every child, at KIS is placed in the hands of qualified, well trained, dedicated and caring educators who stimulate young minds and help them to outgrow their cocoons thereby enabling them to feel valued and confident. Students here are taught to have a sense of pride in themselves and aspire to succeed. Our students are provided with a plethora of local and global activities geared towards building on their latent talents while encouraging an exploration of new and creative interests.\r\nAs educators, we are here to make the school years of our students as successful and educationally challenging as possible. We lay emphasis on creative and critical thinking skills, problem solving, time management and active learning on the part of our students. We are committed towards equipping every student with the 21st century skills of empathy, collaboration, teamwork, IT and communication skills.\r\nAs a model school in the vicinity, we realize out responsibility towards the environment and the community. At KIS , we motivate our students and staff to shoulder civic and social responsibilities by providing them with opportunities to become positive contributors to society. We intend to give back to the society by ensuring literacy, digital skills and environmental protection in our peripheral area. I believe this is what makes KIS one of its kind.\r\nI also believe that preparing today\'s youth for the future requires a strong parental partnership with the school. Therefore, I welcome the parental community to join hands in helping our children realize their full potential.\r\nI invite and encourage you to learn more, by visiting and discovering our school. We shall be glad to welcome you to the family.', 'principle', '1646480386.jpeg', '2022-03-07 05:21:45', '2022-03-07 12:21:45'),
(3, 'Name', 'Dear Parents, Guardians, Teachers and Students\r\nIt\'s an absolute pleasure to have you navigate an enlightening and delightful experience through our website.\r\n\r\n Karnal International school targets at becoming a trademark in education and is modeled on the concept of providing holistic education. The objective is to continue being recognized as a torch bearer of paramount teaching methods and an institution that furnishes a safe and friendly learning environment to its students. We make them grasp the skills of life with 3 R’s (Reverence, Responsibility and Respect) so that at the end of their educational tenure children should emerge with high Self-esteem, Self-respect and Self-confidence. For my message akin to thought, I would like to borrow the erudite words of Former President Dr. A.P.J. Abdul Kalam:\r\n\r\n\"Learning gives creativity. Creativity leads to thinking. Thinking provides knowledge. Knowledge makes you great.\"\r\n\r\nChildren are the world\'s most valuable resource and best hope for the future. KIS has been successfully serving as a bridge for the children to the future. We are confident that after being nurtured with rich knowledge & creativity as well as wisdom & inspiration, students of KIS  will become dutiful citizens-catalysts to positive change and growth in the country.\r\n\r\nI convey my warmest congratulations and appreciation to the Principal, faculties and supporting staff of the school for their ceaseless efforts to keep high the spirit of achievement and excellence. The confidence and cooperation of parents gives an impetus to our endeavours and encourages us to take KIS higher at the zenith of glory. Let the sky be limit for us…\r\n\r\nTo the Modest pupils :  “Whatever change you desire for the world, create that change in your own life. You are here for a purpose. Seek it out. Hunt it down”', 'director', '1646631212.png', '2022-03-07 05:33:32', '2022-03-07 12:33:32');

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

--
-- Table structure for table `notice_board`
--

CREATE TABLE `notice_board` (
  `id` int(11) NOT NULL,
  `notice_name` text NOT NULL,
  `image` varchar(512) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notice_board`
--

INSERT INTO `notice_board` (`id`, `notice_name`, `image`, `created_at`, `updated_at`) VALUES
(4, 'Class 10th (X) Date Sheet 2022', '1646998401.pdf', '2022-03-11 18:33:21', '2022-03-11 18:33:21'),
(5, 'Class 12th (XII) Date Sheet 2022', '1647057218.pdf', '2022-03-12 10:53:38', '2022-03-12 10:53:38');

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

--
-- Table structure for table `session_year`
--

CREATE TABLE `session_year` (
  `id` int(11) NOT NULL,
  `year` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `session_year`
--

INSERT INTO `session_year` (`id`, `year`, `created_at`, `updated_at`) VALUES
(1, '1999-2020', '2022-03-12 16:41:07', '2022-03-12 16:41:07'),
(2, '2021-2022', '2022-03-14 12:00:51', '2022-03-14 12:00:51');

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

--
-- Table structure for table `slc`
--

CREATE TABLE `slc` (
  `id` int(11) NOT NULL,
  `student_name` text NOT NULL,
  `father_name` text NOT NULL,
  `image` varchar(512) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slc`
--

INSERT INTO `slc` (`id`, `student_name`, `father_name`, `image`, `status`, `created_at`, `updated_at`) VALUES
(9, 'Simran', 'Raj Kumar', '1646214122.png', 1, '2022-03-02 16:42:02', '2022-03-02 16:42:02'),
(10, 'Vikas', 'Dharamraj', '1646214143.png', 1, '2022-03-02 16:42:23', '2022-03-02 16:42:23'),
(11, 'Kamal', 'Somnath', '1646214179.png', 1, '2022-03-02 16:42:59', '2022-03-02 16:42:59'),
(12, 'Harsh', 'Sukkhipal', '1646214199.png', 1, '2022-03-02 16:43:19', '2022-03-02 16:43:19'),
(13, 'Vikas', 'Baljeet', '1646214297.png', 1, '2022-03-02 16:44:57', '2022-03-02 16:44:57'),
(14, 'Ravi Kumar', 'Sanjay', '1646214377.png', 1, '2022-03-02 16:46:17', '2022-03-02 16:46:17'),
(15, 'Udayveer', 'Harpreet Singh', '1646214424.png', 1, '2022-03-02 16:47:04', '2022-03-02 16:47:04'),
(16, 'Vinay', 'Bijender', '1646214455.png', 1, '2022-03-02 16:47:35', '2022-03-02 16:47:35'),
(17, 'Vansh', 'Bajinder Jangra', '1646214496.png', 1, '2022-03-02 16:48:16', '2022-03-02 16:48:16'),
(18, 'Akant', 'Niranjan Saini', '1646214525.png', 1, '2022-03-02 16:48:45', '2022-03-02 16:48:45'),
(19, 'Dinesh', 'Jagdish Kumar', '1646214567.png', 1, '2022-03-02 16:49:27', '2022-03-02 16:49:27'),
(20, 'Gurjot Singh', 'Hardeep Singh', '1646214596.png', 1, '2022-03-02 16:49:56', '2022-03-02 16:49:56'),
(21, 'Subh Chhabra', 'Anup Chhabra', '1646214630.png', 1, '2022-03-02 16:50:30', '2022-03-02 16:50:30'),
(22, 'Rohit', 'Pankaj', '1646214688.png', 1, '2022-03-02 16:51:28', '2022-03-02 16:51:28'),
(23, 'Mandeep', 'Kuldeep', '1646214721.jpeg', 1, '2022-03-02 16:52:01', '2022-03-02 16:52:01'),
(24, 'Ranveer Singh', 'Rohtash Singh', '1646214761.jpeg', 1, '2022-03-02 16:52:41', '2022-03-02 16:52:41'),
(25, 'Vishnu', 'Sohan Lal Verma', '1646214787.jpeg', 1, '2022-03-02 16:53:07', '2022-03-02 16:53:07'),
(26, 'Yash', 'Joginder', '1646214826.jpeg', 1, '2022-03-02 16:53:46', '2022-03-02 16:53:46'),
(27, 'Vardaan Gabba', 'Gulshan Gabba', '1646214866.jpeg', 1, '2022-03-02 16:54:26', '2022-03-02 16:54:26'),
(28, 'Yash', 'Ajmer Singh', '1646214900.jpeg', 1, '2022-03-02 16:55:00', '2022-03-02 16:55:00'),
(29, 'Krish', 'Rajender Kumar', '1646214929.jpeg', 1, '2022-03-02 16:55:29', '2022-03-02 16:55:29'),
(30, 'Tanmay', 'Vinod Kumar', '1646215028.jpeg', 1, '2022-03-02 16:57:08', '2022-03-02 16:57:08'),
(31, 'Lakshay Narang', 'Deepak', '1646215060.jpeg', 1, '2022-03-02 16:57:40', '2022-03-02 16:57:40'),
(32, 'Vasu', 'Mohit Molhotra', '1646215090.jpeg', 1, '2022-03-02 16:58:10', '2022-03-02 16:58:10'),
(33, 'Hardik', 'Rakesh Kumar', '1646215116.jpeg', 1, '2022-03-02 16:58:36', '2022-03-02 16:58:36'),
(34, 'Vishwas', 'Surender', '1646215209.jpeg', 1, '2022-03-02 17:00:09', '2022-03-02 17:00:09'),
(35, 'Akash', 'Roshan Lal', '1646215240.jpeg', 1, '2022-03-02 17:00:40', '2022-03-02 17:00:40'),
(36, 'Rohit Raman', 'Charan Singh', '1646215284.jpeg', 1, '2022-03-02 17:01:24', '2022-03-02 17:01:24'),
(37, 'Ritik Kumar', 'Satish Kumar', '1646215338.jpeg', 1, '2022-03-02 17:02:18', '2022-03-02 17:02:18'),
(38, 'Harsh', 'Sukhipal', '1646287714.png', 1, '2022-03-03 13:08:34', '2022-03-03 13:08:34');

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

--
-- Table structure for table `student_registered`
--

CREATE TABLE `student_registered` (
  `id` int(11) NOT NULL,
  `student_name` text NOT NULL,
  `dob` date NOT NULL,
  `gender` text NOT NULL,
  `class` text NOT NULL,
  `aadhar_number` text NOT NULL,
  `email` varchar(512) NOT NULL,
  `phone` text NOT NULL,
  `address` varchar(512) NOT NULL,
  `image` varchar(512) NOT NULL,
  `father_name` text NOT NULL,
  `father_education` text NOT NULL,
  `father_profession` text NOT NULL,
  `father_mobile` text NOT NULL,
  `father_office_address` text NOT NULL,
  `mother_name` text NOT NULL,
  `mother_education` text NOT NULL,
  `mother_profession` text NOT NULL,
  `mother_mobile` text NOT NULL,
  `mother_office_address` text NOT NULL,
  `guardian_name` text NOT NULL,
  `guardian_mobile` text NOT NULL,
  `guardian_relation` text NOT NULL,
  `guardian_address` text NOT NULL,
  `school_transport` text NOT NULL,
  `pickup_location` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_registered`
--

INSERT INTO `student_registered` (`id`, `student_name`, `dob`, `gender`, `class`, `aadhar_number`, `email`, `phone`, `address`, `image`, `father_name`, `father_education`, `father_profession`, `father_mobile`, `father_office_address`, `mother_name`, `mother_education`, `mother_profession`, `mother_mobile`, `mother_office_address`, `guardian_name`, `guardian_mobile`, `guardian_relation`, `guardian_address`, `school_transport`, `pickup_location`, `created_at`, `updated_at`) VALUES
(1, 'Pawan', '2022-03-05', 'option1', 'LKG', '87978766456', 'ashok123@gmail.com', '01234567558', 'karnal ,old bus stand', '1646721161.png', 'pawan', 'bca', 'bca', '07896541230', 'karnal ,old bus stand', 'Anju chaudhary', 'ba', 'accountant', '01234567898', 'sikri', 'ashok', '01234567558', 'dost', 'karnal ,old bus stand', 'no', 'kkr', '2022-03-08 13:32:41', '2022-03-08 13:32:41');

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

--
-- Table structure for table `teachers`
--

CREATE TABLE `teachers` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `post` text NOT NULL,
  `description` varchar(512) DEFAULT NULL,
  `category` int(255) NOT NULL COMMENT '1=>PGT;2=>TGT,3=>TRT',
  `image` varchar(512) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `teachers`
--

INSERT INTO `teachers` (`id`, `name`, `post`, `description`, `category`, `image`, `status`, `created_at`, `updated_at`) VALUES
(7, 'Anjali Rani', 'PGT Maths (Grade-7 Teacher)', 'M.Sc B.Ed, Experience - 4 years', 1, '1645875765.png', 1, '2022-02-26 11:42:45', '2022-02-26 18:42:45'),
(8, 'Ashok', 'PGT Music', 'M.A. Experience - 14 years', 1, '1645870073.png', 1, '2022-02-26 17:07:53', '2022-02-26 17:07:53'),
(9, 'Anjali Sharma', 'PGT Commerce (Grade-11 Teacher)', 'M.Com B.Ed, Experience - 1 year', 1, '1645875851.png', 1, '2022-02-26 18:44:12', '2022-02-26 18:44:12'),
(10, 'Preeti', 'PGT Arts (Grade-11 Teacher)', 'M.A. B.Ed, Experience - 4 years', 1, '1645875918.png', 1, '2022-02-26 18:45:18', '2022-02-26 18:45:18'),
(11, 'Ashwani Sharma', 'PGT English (Grade-12 Teacher)', 'M.A. B.Ed, Experience - 10 years', 1, '1645875960.png', 1, '2022-02-26 18:46:00', '2022-02-26 18:46:00'),
(12, 'Shama', 'TGT English (Grade-6 Teacher)', 'M.A. M.Sc.B.Ed NTT, Experience - 15 years', 2, '1645876645.png', 1, '2022-02-26 18:57:25', '2022-02-26 18:57:25'),
(13, 'Shiwani Devi', 'TGT Maths (Grade-6 Teacher)', 'M.Sc B.Ed, Experience - Fresher', 2, '1645876735.png', 1, '2022-02-26 18:58:55', '2022-02-26 18:58:55'),
(14, 'Sonam', 'TGT Science(Grade-8 Teacher)', 'M.Sc B.Ed, Experience - Fresher', 2, '1645876786.png', 1, '2022-02-26 18:59:46', '2022-02-26 18:59:46'),
(15, 'Ekta', 'TGT English (Grade-8 Teacher)', 'B.A. B.Ed, Experience - 8 years', 2, '1645876876.png', 1, '2022-02-26 19:01:16', '2022-02-26 19:01:16'),
(16, 'Archana Devi', 'TGT Hindi (Grade-9Teacher)', 'B.A. B.Ed CTET, Experience - 8 years', 2, '1645876922.png', 1, '2022-02-26 19:02:02', '2022-02-26 19:02:02'),
(17, 'Payal', 'TGT S.ST (Grade-10 Teacher)', 'M.A. B.Ed, Experience - Fresher', 2, '1645876996.png', 1, '2022-02-26 19:03:16', '2022-02-26 19:03:16'),
(18, 'Sudesh', 'PRT (UKG Teacher)', 'B.A.B.Ed, Experience - 18 years', 3, '1645877346.png', 1, '2022-02-26 19:09:06', '2022-02-26 19:09:06'),
(19, 'Santosh Sharma', 'PRT  (Grade-1 Teacher)', 'M.A., Experience -16 years', 3, '1645877441.png', 1, '2022-02-26 19:10:41', '2022-02-26 19:10:41'),
(20, 'Jyoti', 'PRT (Grade-2 Teacher)', 'B.A. 1year Computer Diploma, Experience - 1 year', 3, '1645877542.png', 1, '2022-02-26 19:12:22', '2022-02-26 19:12:22'),
(21, 'Rajni Giri', 'PRT (Grade-2 Teacher)', 'B.A. B.Ed,M.Ed, Experience - 5 years', 3, '1645877588.png', 1, '2022-02-26 19:13:08', '2022-02-26 19:13:08'),
(22, 'Deepa', 'PRT (Grade-3 Teacher)', 'M.A. B.Ed,M.Ed,  Experience - Fresher', 3, '1645877631.png', 1, '2022-02-26 19:13:51', '2022-02-26 19:13:51'),
(23, 'Pooja', 'PRT (Grade-3 Teacher)', 'B.A. B.Ed, Experience - 12 years', 3, '1645877682.png', 1, '2022-02-26 19:14:42', '2022-02-26 19:14:42'),
(24, 'Manju Rathi', 'PRT (Grade-4 Teacher)', 'M.A. B.Ed, Experience - 9 years', 3, '1645877748.png', 1, '2022-02-26 19:15:48', '2022-02-26 19:15:48'),
(25, 'Saneha', 'PRT (Grade-4 Teacher)', 'B.Sc, Experience - 2 years', 3, '1645877812.png', 1, '2022-02-26 19:16:52', '2022-02-26 19:16:52'),
(26, 'Meenakshi', 'PRT (Grade-5 Teacher)', 'M.A. D.Ed, Experience - 6 years', 3, '1645877884.png', 1, '2022-02-26 19:18:04', '2022-02-26 19:18:04'),
(27, 'Sangeeta Rani', 'PRT (Grade-5 Teacher)', 'M.A. Experience - 16 years', 3, '1645877931.png', 1, '2022-02-26 19:18:51', '2022-02-26 19:18:51'),
(28, 'Varsha', 'PRT (Grade- Nursery Teacher)', 'B.A. NTT, Experience - 17 Years', 3, '1645877991.png', 1, '2022-02-26 19:19:51', '2022-02-26 19:19:51'),
(29, 'Kirti Mew', 'PRT (Grade- Nursery Teacher)', 'BAMS,M.A.B.Ed, Experience - Fresher', 3, '1645878074.png', 1, '2022-02-26 19:21:14', '2022-02-26 19:21:14'),
(30, 'Rajni Saini', 'PRT (Grade-LKG Teacher)', 'M.A. B.Ed, Experience - 9 years', 3, '1645878121.png', 1, '2022-02-26 19:22:01', '2022-02-26 19:22:01'),
(31, 'Poonam Babbar', 'PRT (Grade-3 Teacher)', 'M.A. B.Ed, Experience - 6 years', 3, '1645878163.png', 1, '2022-02-26 19:22:43', '2022-02-26 19:22:43'),
(32, 'Madhu Bala', 'PGT Physics', 'M.Sc., B.Ed,  Experience - 1 year', 1, '1646021836.png', 1, '2022-02-28 11:17:16', '2022-02-28 11:17:16'),
(33, 'Renu', 'PGT Biology', 'M.Sc., B.Ed  Experience - 7 years', 1, '1646021882.png', 1, '2022-02-28 11:18:02', '2022-02-28 11:18:02'),
(34, 'Sachin', 'TGT Science', 'B.Sc,  Experience - Fresher', 2, '1646022004.png', 1, '2022-02-28 11:20:04', '2022-02-28 11:20:04'),
(35, 'Shweta', 'PRT (Grade-1 Teacher)', 'M.Com , B.Ed   Experience - Fresher', 3, '1646032891.png', 1, '2022-02-28 14:21:31', '2022-02-28 14:21:31'),
(37, 'Mrs. Krishna Lather', 'Principal', 'M.A.(Hindi), M.A. (pol sci.),  B.Ed,M.Ed, Experience - 15 years', 6, '1646213362.png', 1, '2022-03-02 16:29:22', '2022-03-02 16:29:22'),
(38, 'Ms. Garima Sharma', 'School Coordinator', 'MBA, Experience - 13 years', 6, '1646213444.png', 1, '2022-03-02 16:30:44', '2022-03-02 16:30:44'),
(39, 'Mr. Anil Dutt', 'Academic Coordinator', 'M.Sc, M.tech, UGC-Net, Ctet, Htet, Experience - 14 years', 6, '1646213538.png', 1, '2022-03-02 16:32:18', '2022-03-02 16:32:18'),
(40, 'Mr. Lalit Kaushik', 'D.D.O', NULL, 6, '1646213797.png', 1, '2022-03-02 16:36:37', '2022-03-02 16:36:37'),
(41, 'Ms. Rakhi', 'Students Counsellor', NULL, 6, '1646213840.png', 1, '2022-03-02 16:37:20', '2022-03-02 16:37:20'),
(42, 'Deepika', 'Art & Craft Teacher', 'M.A. B.Ed, Experience - 4 years', 5, '1646213909.png', 1, '2022-03-02 16:38:29', '2022-03-02 16:38:29'),
(43, 'Sapna', 'DPI', 'B.Sc, BPED, MPED, Experience - 6 years', 4, '1646213959.png', 1, '2022-03-02 16:39:19', '2022-03-02 16:39:19'),
(44, 'Mr. Pawan', 'DPI', 'BPED, MPED, Experience - 8 years', 4, '1646213989.png', 1, '2022-03-02 16:39:49', '2022-03-02 16:39:49');

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

--
-- Table structure for table `uniforms`
--

CREATE TABLE `uniforms` (
  `id` int(11) NOT NULL,
  `session` text NOT NULL,
  `class_from` text NOT NULL,
  `class_to` text NOT NULL,
  `gender` text NOT NULL,
  `list_text` text,
  `image` varchar(512) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uniforms`
--

INSERT INTO `uniforms` (`id`, `session`, `class_from`, `class_to`, `gender`, `list_text`, `image`, `created_at`, `updated_at`) VALUES
(4, 'summer', 'nursery', '8th', 'girl', '<ul><li>Royal Blue skirt&nbsp;</li><li>White shirt&nbsp;</li><li>White socks&nbsp;</li><li>Black Shoes&nbsp;</li></ul>', '1647058634.png', '2022-03-12 11:17:14', '2022-03-12 11:17:14'),
(5, 'summer', '9th', '12th', 'girl', '<ul><li>Royal Blue &amp; white check shirt</li><li>Royal Blue salwar &nbsp;</li><li>White socks&nbsp;</li><li>Black Shoes</li></ul>', '1647059442.png', '2022-03-12 11:30:42', '2022-03-12 11:30:42'),
(6, 'summer', 'nursery', '3rd', 'boy', '<ul><li>Royal Blue half pant&nbsp;</li><li>White shirt&nbsp;</li><li>White socks&nbsp;</li><li>Black Shoes</li></ul>', '1647061699.png', '2022-03-12 05:08:19', '2022-03-12 12:08:19'),
(7, 'summer', '4th', '12th', 'boy', '<ul><li>Royal Blue pant&nbsp;</li><li>White shirt</li><li>White socks&nbsp;</li><li>Black Shoes&nbsp;</li></ul>', '1647061787.png', '2022-03-12 12:09:47', '2022-03-12 12:09:47'),
(8, 'winter', 'nursery', '8th', 'girl', '<ul><li>Royal Blue skirt&nbsp;</li><li>White shirt&nbsp;</li><li>White leggings</li><li>Maroon sweater</li><li>White socks&nbsp;</li><li>Black Shoes</li></ul>', '1647061888.jpeg', '2022-03-12 05:26:27', '2022-03-12 12:26:27'),
(9, 'winter', '9th', '12th', 'girl', '<ul><li>Royal Blue &amp; white check shirt&nbsp;</li><li>Royal Blue salwaar&nbsp;</li><li>Maroon sweater&nbsp;</li><li>White socks&nbsp;</li><li>Black Shoes</li></ul>', '1647062882.jpeg', '2022-03-12 12:28:02', '2022-03-12 12:28:02'),
(10, 'winter', 'nursery', '12th', 'boy', '<ul><li>Royal Blue pant</li><li>White shirt</li><li>Maroon sweater</li><li>White socks&nbsp;</li><li>Black Shoes&nbsp;</li></ul>', '1647062957.jpeg', '2022-03-12 12:29:17', '2022-03-12 12:29:17');

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

--
-- Table structure for table `vacancy`
--

CREATE TABLE `vacancy` (
  `id` int(11) NOT NULL,
  `job_title` text NOT NULL,
  `qualification` varchar(512) NOT NULL,
  `total_position` int(255) NOT NULL,
  `status` int(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vacancy`
--

INSERT INTO `vacancy` (`id`, `job_title`, `qualification`, `total_position`, `status`, `created_at`, `updated_at`) VALUES
(2, 'PGT Chemistry', 'M.Sc, B.Ed', 1, 1, '2022-03-03 18:24:20', '2022-03-03 18:24:20'),
(3, 'TGT Computer', 'MCA / M.Sc. B.Ed', 1, 1, '2022-03-03 18:24:58', '2022-03-03 18:24:58'),
(4, 'Dance Teaher', 'Graduation', 1, 1, '2022-03-03 18:25:49', '2022-03-03 18:25:49'),
(5, 'Music Teacher', 'Graduation', 1, 1, '2022-03-03 18:26:12', '2022-03-03 18:26:12');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

