Gecko [ dp-client.com ]

Name	Size	Permission
blog	[ DIR ]	drwxr-xr-x
clients	[ DIR ]	drwxr-xr-x
covers	[ DIR ]	drwxr-xr-x
default	[ DIR ]	drwxr-xr-x
file	[ DIR ]	drwxr-xr-x
media	[ DIR ]	drwxr-xr-x
media-gallery	[ DIR ]	drwxr-xr-x
pages	[ DIR ]	drwxr-xr-x
services	[ DIR ]	drwxr-xr-x
slides	[ DIR ]	drwxr-xr-x
sound	[ DIR ]	drwxr-xr-x
team	[ DIR ]	drwxr-xr-x
theme	[ DIR ]	drwxr-xr-x
work	[ DIR ]	drwxr-xr-x
bg.png	231.49 KB	-rw-r--r--
female-user.svg	15.53 KB	-rw-r--r--
logo.png	2.93 KB	-rw-r--r--
male-user.svg	2.53 KB	-rw-r--r--
male.png	19.46 KB	-rw-r--r--
mydemose_crpf.sql	43.3 KB	-rw-r--r--
user.svg	774 B	-rw-r--r--

Code Editor : mydemose_crpf.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 14, 2024 at 07:35 PM
-- Server version: 5.7.23-23
-- PHP Version: 8.1.27

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `mydemose_crpf`
--

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

--
-- Table structure for table `classes`
--

CREATE TABLE `classes` (
  `id` int(11) NOT NULL,
  `class_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `class_section` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classes`
--

INSERT INTO `classes` (`id`, `class_name`, `class_section`) VALUES
(1, 'PP', 'A'),
(2, 'PP', 'B'),
(3, 'PP', 'C'),
(6, 'PP', 'D'),
(7, '1', 'A'),
(8, '1', 'B'),
(9, '1', 'C'),
(10, '1', 'D'),
(12, '2', 'A'),
(13, '2', 'B'),
(14, '2', 'C'),
(15, '2', 'D'),
(16, '3', 'A'),
(17, '3', 'B'),
(18, '3', 'C'),
(19, '3', 'D'),
(20, '4', 'A'),
(21, '4', 'B'),
(22, '4', 'C'),
(23, '4', 'D'),
(24, '5', 'A'),
(25, '5', 'B'),
(26, '5', 'C'),
(27, '5', 'D'),
(28, '6', 'A'),
(29, '6', 'B'),
(30, '6', 'C'),
(31, '6', 'D'),
(32, '7', 'A'),
(33, '7', 'B'),
(34, '7', 'C'),
(35, '7', 'D'),
(36, '8', 'A'),
(37, '8', 'B'),
(38, '8', 'C'),
(39, '8', 'D'),
(40, '9', 'A'),
(41, '9', 'B'),
(42, '9', 'C'),
(43, '9', 'D'),
(44, '10', 'A'),
(45, '10', 'B'),
(46, '10', 'C'),
(47, '10', 'D'),
(48, '11', 'A'),
(49, '11', 'B'),
(50, '11', 'C'),
(51, '11', 'D'),
(52, '12', 'A'),
(53, '12', 'B'),
(54, '12', 'C'),
(55, '12', 'D');

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

--
-- Table structure for table `classes_number`
--

CREATE TABLE `classes_number` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classes_number`
--

INSERT INTO `classes_number` (`id`, `name`) VALUES
(1, '1'),
(2, '2'),
(3, '3'),
(4, '4'),
(5, '5'),
(6, '6'),
(7, '7'),
(8, '8'),
(9, '9'),
(10, '10'),
(11, '11'),
(12, '12'),
(13, 'PP');

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

--
-- Table structure for table `classes_sections`
--

CREATE TABLE `classes_sections` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classes_sections`
--

INSERT INTO `classes_sections` (`id`, `name`) VALUES
(1, 'A'),
(3, 'B'),
(4, 'C'),
(5, 'D');

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

--
-- Table structure for table `class_teacher`
--

CREATE TABLE `class_teacher` (
  `id` int(255) NOT NULL,
  `class_id` int(255) DEFAULT NULL,
  `teacher_id` int(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

CREATE TABLE `country` (
  `id` int(11) NOT NULL,
  `country_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `country` (`id`, `country_id`, `country_name`) VALUES
(1, 'AF', 'Afghanistan'),
(2, 'AL', 'Albania'),
(3, 'DZ', 'Algeria'),
(4, 'DS', 'American Samoa'),
(5, 'AD', 'Andorra'),
(6, 'AO', 'Angola'),
(7, 'AI', 'Anguilla'),
(8, 'AQ', 'Antarctica'),
(9, 'AG', 'Antigua and Barbuda'),
(10, 'AR', 'Argentina'),
(11, 'AM', 'Armenia'),
(12, 'AW', 'Aruba'),
(13, 'AU', 'Australia'),
(14, 'AT', 'Austria'),
(15, 'AZ', 'Azerbaijan'),
(16, 'BS', 'Bahamas'),
(17, 'BH', 'Bahrain'),
(18, 'BD', 'Bangladesh'),
(19, 'BB', 'Barbados'),
(20, 'BY', 'Belarus'),
(21, 'BE', 'Belgium'),
(22, 'BZ', 'Belize'),
(23, 'BJ', 'Benin'),
(24, 'BM', 'Bermuda'),
(25, 'BT', 'Bhutan'),
(26, 'BO', 'Bolivia'),
(27, 'BA', 'Bosnia and Herzegovina'),
(28, 'BW', 'Botswana'),
(29, 'BV', 'Bouvet Island'),
(30, 'BR', 'Brazil'),
(31, 'IO', 'British Indian Ocean Territory'),
(32, 'BN', 'Brunei Darussalam'),
(33, 'BG', 'Bulgaria'),
(34, 'BF', 'Burkina Faso'),
(35, 'BI', 'Burundi'),
(36, 'KH', 'Cambodia'),
(37, 'CM', 'Cameroon'),
(38, 'CA', 'Canada'),
(39, 'CV', 'Cape Verde'),
(40, 'KY', 'Cayman Islands'),
(41, 'CF', 'Central African Republic'),
(42, 'TD', 'Chad'),
(43, 'CL', 'Chile'),
(44, 'CN', 'China'),
(45, 'CX', 'Christmas Island'),
(46, 'CC', 'Cocos (Keeling) Islands'),
(47, 'CO', 'Colombia'),
(48, 'KM', 'Comoros'),
(49, 'CD', 'Democratic Republic of the Congo'),
(50, 'CG', 'Republic of Congo'),
(51, 'CK', 'Cook Islands'),
(52, 'CR', 'Costa Rica'),
(53, 'HR', 'Croatia (Hrvatska)'),
(54, 'CU', 'Cuba'),
(55, 'CY', 'Cyprus'),
(56, 'CZ', 'Czech Republic'),
(57, 'DK', 'Denmark'),
(58, 'DJ', 'Djibouti'),
(59, 'DM', 'Dominica'),
(60, 'DO', 'Dominican Republic'),
(61, 'TP', 'East Timor'),
(62, 'EC', 'Ecuador'),
(63, 'EG', 'Egypt'),
(64, 'SV', 'El Salvador'),
(65, 'GQ', 'Equatorial Guinea'),
(66, 'ER', 'Eritrea'),
(67, 'EE', 'Estonia'),
(68, 'ET', 'Ethiopia'),
(69, 'FK', 'Falkland Islands (Malvinas)'),
(70, 'FO', 'Faroe Islands'),
(71, 'FJ', 'Fiji'),
(72, 'FI', 'Finland'),
(73, 'FR', 'France'),
(74, 'FX', 'France, Metropolitan'),
(75, 'GF', 'French Guiana'),
(76, 'PF', 'French Polynesia'),
(77, 'TF', 'French Southern Territories'),
(78, 'GA', 'Gabon'),
(79, 'GM', 'Gambia'),
(80, 'GE', 'Georgia'),
(81, 'DE', 'Germany'),
(82, 'GH', 'Ghana'),
(83, 'GI', 'Gibraltar'),
(84, 'GK', 'Guernsey'),
(85, 'GR', 'Greece'),
(86, 'GL', 'Greenland'),
(87, 'GD', 'Grenada'),
(88, 'GP', 'Guadeloupe'),
(89, 'GU', 'Guam'),
(90, 'GT', 'Guatemala'),
(91, 'GN', 'Guinea'),
(92, 'GW', 'Guinea-Bissau'),
(93, 'GY', 'Guyana'),
(94, 'HT', 'Haiti'),
(95, 'HM', 'Heard and Mc Donald Islands'),
(96, 'HN', 'Honduras'),
(97, 'HK', 'Hong Kong'),
(98, 'HU', 'Hungary'),
(99, 'IS', 'Iceland'),
(100, 'IN', 'India'),
(101, 'IM', 'Isle of Man'),
(102, 'ID', 'Indonesia'),
(103, 'IR', 'Iran (Islamic Republic of)'),
(104, 'IQ', 'Iraq'),
(105, 'IE', 'Ireland'),
(106, 'IL', 'Israel'),
(107, 'IT', 'Italy'),
(108, 'CI', 'Ivory Coast'),
(109, 'JE', 'Jersey'),
(110, 'JM', 'Jamaica'),
(111, 'JP', 'Japan'),
(112, 'JO', 'Jordan'),
(113, 'KZ', 'Kazakhstan'),
(114, 'KE', 'Kenya'),
(115, 'KI', 'Kiribati'),
(116, 'KP', 'Korea, Democratic People\'s Republic of'),
(117, 'KR', 'Korea, Republic of'),
(118, 'XK', 'Kosovo'),
(119, 'KW', 'Kuwait'),
(120, 'KG', 'Kyrgyzstan'),
(121, 'LA', 'Lao People\'s Democratic Republic'),
(122, 'LV', 'Latvia'),
(123, 'LB', 'Lebanon'),
(124, 'LS', 'Lesotho'),
(125, 'LR', 'Liberia'),
(126, 'LY', 'Libyan Arab Jamahiriya'),
(127, 'LI', 'Liechtenstein'),
(128, 'LT', 'Lithuania'),
(129, 'LU', 'Luxembourg'),
(130, 'MO', 'Macau'),
(131, 'MK', 'North Macedonia'),
(132, 'MG', 'Madagascar'),
(133, 'MW', 'Malawi'),
(134, 'MY', 'Malaysia'),
(135, 'MV', 'Maldives'),
(136, 'ML', 'Mali'),
(137, 'MT', 'Malta'),
(138, 'MH', 'Marshall Islands'),
(139, 'MQ', 'Martinique'),
(140, 'MR', 'Mauritania'),
(141, 'MU', 'Mauritius'),
(142, 'TY', 'Mayotte'),
(143, 'MX', 'Mexico'),
(144, 'FM', 'Micronesia, Federated States of'),
(145, 'MD', 'Moldova, Republic of'),
(146, 'MC', 'Monaco'),
(147, 'MN', 'Mongolia'),
(148, 'ME', 'Montenegro'),
(149, 'MS', 'Montserrat'),
(150, 'MA', 'Morocco'),
(151, 'MZ', 'Mozambique'),
(152, 'MM', 'Myanmar'),
(153, 'NA', 'Namibia'),
(154, 'NR', 'Nauru'),
(155, 'NP', 'Nepal'),
(156, 'NL', 'Netherlands'),
(157, 'AN', 'Netherlands Antilles'),
(158, 'NC', 'New Caledonia'),
(159, 'NZ', 'New Zealand'),
(160, 'NI', 'Nicaragua'),
(161, 'NE', 'Niger'),
(162, 'NG', 'Nigeria'),
(163, 'NU', 'Niue'),
(164, 'NF', 'Norfolk Island'),
(165, 'MP', 'Northern Mariana Islands'),
(166, 'NO', 'Norway'),
(167, 'OM', 'Oman'),
(168, 'PK', 'Pakistan'),
(169, 'PW', 'Palau'),
(170, 'PS', 'Palestine'),
(171, 'PA', 'Panama'),
(172, 'PG', 'Papua New Guinea'),
(173, 'PY', 'Paraguay'),
(174, 'PE', 'Peru'),
(175, 'PH', 'Philippines'),
(176, 'PN', 'Pitcairn'),
(177, 'PL', 'Poland'),
(178, 'PT', 'Portugal'),
(179, 'PR', 'Puerto Rico'),
(180, 'QA', 'Qatar'),
(181, 'RE', 'Reunion'),
(182, 'RO', 'Romania'),
(183, 'RU', 'Russian Federation'),
(184, 'RW', 'Rwanda'),
(185, 'KN', 'Saint Kitts and Nevis'),
(186, 'LC', 'Saint Lucia'),
(187, 'VC', 'Saint Vincent and the Grenadines'),
(188, 'WS', 'Samoa'),
(189, 'SM', 'San Marino'),
(190, 'ST', 'Sao Tome and Principe'),
(191, 'SA', 'Saudi Arabia'),
(192, 'SN', 'Senegal'),
(193, 'RS', 'Serbia'),
(194, 'SC', 'Seychelles'),
(195, 'SL', 'Sierra Leone'),
(196, 'SG', 'Singapore'),
(197, 'SK', 'Slovakia'),
(198, 'SI', 'Slovenia'),
(199, 'SB', 'Solomon Islands'),
(200, 'SO', 'Somalia'),
(201, 'ZA', 'South Africa'),
(202, 'GS', 'South Georgia South Sandwich Islands'),
(203, 'SS', 'South Sudan'),
(204, 'ES', 'Spain'),
(205, 'LK', 'Sri Lanka'),
(206, 'SH', 'St. Helena'),
(207, 'PM', 'St. Pierre and Miquelon'),
(208, 'SD', 'Sudan'),
(209, 'SR', 'Suriname'),
(210, 'SJ', 'Svalbard and Jan Mayen Islands'),
(211, 'SZ', 'Swaziland'),
(212, 'SE', 'Sweden'),
(213, 'CH', 'Switzerland'),
(214, 'SY', 'Syrian Arab Republic'),
(215, 'TW', 'Taiwan'),
(216, 'TJ', 'Tajikistan'),
(217, 'TZ', 'Tanzania, United Republic of'),
(218, 'TH', 'Thailand'),
(219, 'TG', 'Togo'),
(220, 'TK', 'Tokelau'),
(221, 'TO', 'Tonga'),
(222, 'TT', 'Trinidad and Tobago'),
(223, 'TN', 'Tunisia'),
(224, 'TR', 'Turkey'),
(225, 'TM', 'Turkmenistan'),
(226, 'TC', 'Turks and Caicos Islands'),
(227, 'TV', 'Tuvalu'),
(228, 'UG', 'Uganda'),
(229, 'UA', 'Ukraine'),
(230, 'AE', 'United Arab Emirates'),
(231, 'GB', 'United Kingdom'),
(232, 'US', 'United States'),
(233, 'UM', 'United States minor outlying islands'),
(234, 'UY', 'Uruguay'),
(235, 'UZ', 'Uzbekistan'),
(236, 'VU', 'Vanuatu'),
(237, 'VA', 'Vatican City State'),
(238, 'VE', 'Venezuela'),
(239, 'VN', 'Vietnam'),
(240, 'VG', 'Virgin Islands (British)'),
(241, 'VI', 'Virgin Islands (U.S.)'),
(242, 'WF', 'Wallis and Futuna Islands'),
(243, 'EH', 'Western Sahara'),
(244, 'YE', 'Yemen'),
(245, 'ZM', 'Zambia'),
(246, 'ZW', 'Zimbabwe');

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

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

CREATE TABLE `message` (
  `id` int(255) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` text COLLATE utf8_unicode_ci,
  `message` text COLLATE utf8_unicode_ci,
  `page` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` enum('product','service','contact') COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` enum('read','unread') COLLATE utf8_unicode_ci DEFAULT 'unread',
  `important` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `pid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `heading` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sub_heading` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cover` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `seo_title` text COLLATE utf8_unicode_ci,
  `seo_description` text COLLATE utf8_unicode_ci,
  `seo_keywords` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` enum('show','hide') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'show',
  `type` enum('text','textarea','media','socialLink') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  `icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `name`, `value`, `text`, `desc`, `status`, `type`, `icon`) VALUES
(1, 'websiteName', 'CRPF Public School, Dwarka', 'School\'s Name', 'You can update your school\'s name.', 'show', 'text', 'building'),
(2, 'seoTitle', 'CRPF Public School, Dwarka', 'School\'s Default SEO Title', 'You can update default school\'s SEO title.', 'show', 'textarea', 'hashtag'),
(3, 'seoDesc', 'CRPF Public School, Dwarka', 'School\'s Default SEO Description', 'You can update default school\'s SEO description.', 'show', 'textarea', 'hashtag'),
(4, 'seoKeywords', 'CRPF Public School, Dwarka', 'School\'s Default SEO Keywords', 'You can update default school\'s SEO keywords.', 'show', 'textarea', 'hashtag'),
(5, 'websiteLogo', 'upload2/logo_main.png', 'School\'s Logo', 'You can update default school\'s logo.', 'show', 'media', 'image'),
(49, 'websiteLegalName', 'CRPF Public School, Dwarka', 'School\'s Legal Name', 'You can update your school\'s legal name.', 'show', 'text', 'building'),
(50, 'websitePhone', '011-28032245', 'School\'s Phone Number', 'You can update your school\'s phone number.', 'show', 'text', 'phone'),
(51, 'websiteEmail', 'crpfpsdwarka@gmail.com', 'School\'s Email Address', 'You can update your school\'s email address.', 'show', 'text', 'envelope'),
(53, 'websiteFacebookLink', 'https://www.facebook.com/crpfpsd_alumni-115514044480107/', 'School\'s Facebook Page Link', 'You can update your school\'s social facebook page link.', 'show', 'text', 'facebook'),
(54, 'websiteInstagramLink', 'https://instagram.com/crpfpsd_alumni?utm_medium=copy_link', 'School\'s Instagram Page Link', 'You can update your school\'s social instagram page link.', 'show', 'text', 'instagram'),
(55, 'websiteLinkedinLink', 'https://www.linkedin.com/in/crpf-dwarka-alumni-454246238/', 'School\'s Linkedin Page Link', 'You can update your school\'s social linkedin page link.', 'show', 'text', 'linkedin'),
(56, 'websiteStreetAddress', 'Pocket 4, Sector 16B Dwarka', 'School\'s Street Address', 'You can update your school\'s street address.', 'show', 'text', 'map'),
(57, 'websiteAddressLocality', 'Dwarka, Delhi', 'School\'s Address Locality', 'You can update your school\'s address locality.', 'show', 'text', 'map'),
(58, 'websitePostalCode', '110078', 'School\'s Address Postal Code', 'You can update your school\'s address postal code.', 'show', 'text', 'map'),
(59, 'websiteAddressCountry', 'India', 'School\'s Address Country', 'You can update your school\'s address country.', 'show', 'text', 'map'),
(61, 'websiteShortDescription', 'The school was established in 2006 for the wards of CRPF personnel residing in and around Dwarka. The school set up to spread the ideals of simplicity and high thinking, was initially started as a Primary school in pre-fabricated huts with just 5 teachers, 45 students and one office staff.. It was inaugurated on 27th November 2006, by the Honourable former Director General, CRPF Shri. J.K Sinha (IPS). ', 'School\'s Short Description', 'You can update your school\'s short description.', 'show', 'textarea', 'info'),
(62, 'websiteEnquiryEmail', 'crpfpsdwarka@gmail.com', 'School\'s Enquiry Email Address', 'You can update your school\'s enquiry email address.', 'show', 'text', 'envelope');

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

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` int(11) NOT NULL,
  `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_number` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `date_of_birth` date DEFAULT NULL,
  `gender` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admission_date` date DEFAULT NULL,
  `class` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `roll_number` int(11) DEFAULT NULL,
  `guardian_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `guardian_phone` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `emergency_contact_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `emergency_contact_phone` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `medical_history` text COLLATE utf8_unicode_ci,
  `nationality` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language_spoken` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `extracurricular_activities` text COLLATE utf8_unicode_ci,
  `added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `su`
--

CREATE TABLE `su` (
  `id` int(10) NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `su`
--

INSERT INTO `su` (`id`, `username`, `password`, `fname`, `lname`, `email`) VALUES
(1, 'WjR1OVp1TWhmWXkxWCtQK3pvaFVxQT09', 'dWFIemFqK2I1Vml5Tk0yUUlYRThXUCtDajRlQzBYQ1ZGamFNaUsydDl2MD0=', 'Super', 'Admin', 'crpfpsdwarka@gmail.com'),
(2, 'Q3VwVkMwV09keWl6R1M0blpJcmFTZz09', 'S2M0YVVZUHo2SnVDK1pDRndaeGFQQT09', 'Admin', 'Admin', 'Admin');

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

--
-- Table structure for table `subject`
--

CREATE TABLE `subject` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `class` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `subject`
--

INSERT INTO `subject` (`id`, `name`, `class`) VALUES
(1, 'Hindi', 1),
(2, 'English', 1),
(3, 'Math', 1),
(4, 'Science', 7),
(5, 'S.S.T', 7);

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

--
-- Table structure for table `subject_modules`
--

CREATE TABLE `subject_modules` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `subject_modules_options`
--

CREATE TABLE `subject_modules_options` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `subject_modules_options_pointers`
--

CREATE TABLE `subject_modules_options_pointers` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `subject_modules_options_id` int(255) DEFAULT NULL,
  `subject_modules_options_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

CREATE TABLE `teachers` (
  `id` int(11) NOT NULL,
  `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `department` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_number` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `subject_taught` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualification` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `joining_date` date DEFAULT NULL,
  `experience_years` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gender` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `teachers` (`id`, `first_name`, `last_name`, `department`, `email`, `phone_number`, `address`, `subject_taught`, `qualification`, `joining_date`, `experience_years`, `gender`, `date_of_birth`, `designation`, `user_type`, `added`) VALUES
(1, 'Meenu', 'Tiwari', 'Teaching', 'meenu_twr@yahoo.com', '9818114466', 'A-116 II nd Floor Phase III Ashok Vihar Delhi 110052', 'Principal', 'MBA', '2010-03-15', '14', 'Female', '1967-07-20', 'Principal', 'Principal', '2024-03-20 00:50:46'),
(2, 'Ritu', 'Ahuja', 'Teaching', 'rituahuja10@gmail.com', '9810414712', 'D-84 (FF) Ajay Enclave New-Delhi 18', NULL, 'BCom', '2013-07-01', '10 years 8 months', 'Female', '1976-06-11', 'Vice Principal', 'Class Coordinator', '2024-03-20 00:50:46'),
(3, 'Dilpreet', 'Kaur', 'Teaching', 'dilpreet.bagga@gmail.com', '9711745570', 'E-703 Himachali CGHS Plot no 3 Sector 3 Dwarka New-Delhi 76', NULL, 'BSc', '2013-07-01', '10 years 8 months', 'Female', '1984-08-18', 'PGT', 'Class Teacher', '2024-03-20 00:50:46'),
(4, 'Saroochi', 'Bhat', 'Teaching', 'saroochi@gmail.com', '9891435659', '133 Charak Sadan E block Vikas Puri New Delhi', NULL, 'BSc', '2013-07-01', '10 years 8 months', 'Female', '1984-11-05', 'PGT', 'Class Teacher', '2024-03-20 00:50:46'),
(5, 'Niharika', 'Sharma', 'Teaching', 's.niharikasharma@gmail.com', '9711604883', '297 Kangra Niketan Vikas Puri New Delhi 18', NULL, 'BSc', '2013-07-01', '10 years 8 months', 'Female', '1986-09-23', 'PGT', 'Class Teacher', '2024-03-20 00:50:46'),
(6, 'Shikha', 'Verma', 'Teaching', 'shikhaverma275@gmail.com', '9582070472', 'R-99 Vani Vihar Uttam Nagar New Delhi 99', NULL, 'MS', '2013-10-01', '10 years 5 months', 'Female', '1989-05-25', 'PGT', 'Class Coordinator', '2024-03-20 00:50:46'),
(7, 'Uttam Singh', 'Negi', 'Teaching', 'negiuttam14@gmail.com', '9871491310', 'A-383 Kidwai Nagar east New delhi 23', NULL, 'BCom', '2014-07-01', '9 years 8 months', 'Male', '1984-02-14', 'PGT', 'Class Teacher', '2024-03-20 00:50:46'),
(8, 'Jitendra', 'Popli', 'Teaching', 'jai.popli@gmail.com', '7503724001', 'B-273b Mohan Garden Uttam Nagar New Delhi 59', NULL, 'BCom', '2014-07-01', '9 years 8 months', 'Male', '1982-03-04', 'PGT', 'Class Coordinator', '2024-03-20 00:50:46'),
(9, 'Deepak', 'Bisht', 'Teaching', 'deepakbisht0008@gmail.com', '8860085232', '807 A Indra Park Etn Near Guru Nagar Najafgarh New Delhi 110043', NULL, 'BCom', '2014-07-01', '9 years 8 months', 'Female', '1987-05-17', 'PGT', 'Class Teacher', '2024-03-20 00:51:49'),
(10, 'Shikha', 'Aggarwal', 'Teaching', 'shikhsagrwl91@gmail.com', '9582254851', '570 Baba Farid Pura West Patel Nagar Delhi', NULL, 'BA', '2017-07-01', '6 years 8 months', 'Female', '1991-09-21', 'PGT', 'Class Teacher', '2024-03-20 00:51:49'),
(11, 'Megha', NULL, 'Teaching', 'megha.yk@gmail.com', '7701897021', 'House no 261 H-block Shakur Pur Delhi 110034', NULL, 'BCom', '2019-07-01', '4 years 8 months', 'Female', '1992-02-17', 'PGT', 'Class Teacher', '2024-03-20 00:51:49'),
(12, 'Priya', 'Chopra', 'Teaching', 'priyachopra03@gmail.com', '9999601902', 'A-19 Ext Mohan garden Near Dwarka More New Delhi 59', NULL, 'BSc', '2019-07-15', '4 years 8 months', 'Female', '1983-09-23', 'PGT', 'Class Teacher', '2024-03-20 00:51:49'),
(13, 'Barakha Gupta', 'Jindal', 'Teaching', 'barkha.jindal01@gmail.com', '9818954558', 'RZ/ A-23 Gurudwara Wali Gali Vishwas Park Uttam Nagar', NULL, 'BTech', '2010-07-01', '13 years 8 months', 'Female', '1984-09-01', 'TGT', 'Class Teacher', '2024-03-20 00:51:49'),
(14, 'Tanushree', NULL, 'Teaching', 'tanushree.ranjan@gmail.com', '9868025139', 'C/O Rakesh Ranjan Srivastava 86 C Platinum Enclave Block-I Sec-18 Rohini New-Delhi 85', NULL, 'BSc', '2011-07-01', '12 years 8 months', 'Female', '1978-01-05', 'TGT', 'Class Teacher', '2024-03-20 00:51:49'),
(15, 'Vandana', NULL, 'Teaching', 'vandana4925@gmail.com', '9871777062', 'A-54 Anoop nagar Jewan Park OppJanak puri Uttam Nagar', NULL, 'BTech', '2011-07-01', '12 years 8 months', 'Female', '1979-09-15', 'TGT', 'Class Teacher', '2024-03-20 00:51:49'),
(16, 'Madhumita', 'Hazra', 'Teaching', 'madhuhazra05@gmail.com', '9899087827', 'Flat No 18 Jaimata Kalyani CGHS Ltd Plot No 31 Sector 4 DwarkaNew-Delhi 75', NULL, 'BCom', '2011-07-01', '12 years 8 months', 'Female', '1980-08-08', 'TGT', 'Class Teacher', '2024-03-20 00:51:49'),
(17, 'Rupanky', 'Chowdhary', 'Teaching', 'chowdharyrup@gmail.com', '9971581112', 'R/o C-604 Gani Nath Nikunj Polt no 1 Sector 5 Dwarka New-Delhi', NULL, 'BCom', '2011-07-01', '12 years 8 months', 'Female', '1981-11-19', 'TGT', 'Class Coordinator', '2024-03-20 00:52:57'),
(18, 'Shruti', 'Nautiyal', 'Teaching', 'shrutinautiyal12@gmail.com', '9968267789', 'D-603 Mandir Marg New-Delhi', NULL, 'BSc', '2011-07-01', '12 years 8 months', 'Female', '1988-11-18', 'TGT', 'Class Teacher', '2024-03-20 00:52:57'),
(19, 'Samiksha', NULL, 'Teaching', 'samikshakaushik@yahoo.com', '8800581440', 'Samiksha c/o Shri BD Kaushik House No 893 Sec 22 Pocket B Gurgaon', NULL, 'BCom', '2011-12-12', '12 years 3 months', 'Female', '1983-05-06', 'TGT', 'Class Teacher', '2024-03-20 00:52:57'),
(20, 'Ashutosh', 'Sharma', 'Teaching', 'ashutosh84crpf@gmail.com', '9716204563', 'B-260 Gakalpuri Delhi 110094', NULL, 'BCom', '2011-07-01', '12 years 8 months', 'Male', '1984-06-15', 'TGT', 'Class Teacher', '2024-03-20 00:52:57'),
(21, 'Sapna', 'Sharma', 'Teaching', 'sapna1986_sharma@yahoo.in', '9818078581', 'RZ-32/4 Roshan Garden Najafgarh New-Delhi 110043', NULL, 'BCom', '2011-07-01', '12 years 8 months', 'Female', '1986-07-16', 'TGT', 'Class Teacher', '2024-03-20 00:52:57'),
(22, 'Sangeeta', 'Kumari', 'Teaching', 'sangitacrpf@gmail.com', '8178752327', '10-C A-2 Keshavapuram Delhi 110035', NULL, 'MSc', '2012-07-02', '11 years 8 months', 'Female', '1970-05-04', 'TGT', 'Class Teacher', '2024-03-20 00:52:58'),
(23, 'Dikshita', 'Narang', 'Teaching', 'dikshi.27@gmail.com', '9716188034', 'AB-153, SHALIMAR BAGH, DELHI-88', NULL, 'BCom', '2013-07-01', '10 years 8 months', 'Female', '1989-06-27', 'TGT', 'Class Coordinator', '2024-03-20 00:52:58'),
(24, 'Poonam', 'Sharma', 'Teaching', 'poonamsharma2111@gmail.com', '9953575409', 'B-986 Gali no 29 Sant Nagar Burai Delhi 84', NULL, 'BTech', '2013-07-01', '10 years 8 months', 'Female', '1986-11-21', 'TGT', 'Class Teacher', '2024-03-20 00:52:58'),
(25, 'Arti', 'Wadhwa', 'Teaching', 'artiwadhwa.25@gmail.com', '9711248848', 'CG-12 Shiva Enclave A-4 Paschim Vihar New-Delhi 63', NULL, 'BCom', '2013-07-01', '10 years 8 months', 'Female', '1987-08-25', 'TGT', 'Class Coordinator', '2024-03-20 00:53:54'),
(26, 'Lakshmy', 'Narayanan', 'Teaching', 'lakshmy.narayanan@gmail.com', '7827849500', 'C-305 Plot 1 A DJA Apartments Sector 13 Dwarka New Delhi 78', NULL, 'BSc', '2017-07-03', '6 years 8 months', 'Female', '1985-02-09', 'TGT', 'Class Teacher', '2024-03-20 00:53:54'),
(27, 'Jeenu', 'Rani Poonia', 'Teaching', 'jeenuranip@gmail.com', '7503740917', 'E-3/91 Shiv Ram Park Nangoli', NULL, 'BTech', '2017-07-03', '6 years 8 months', 'Female', '1986-07-17', 'TGT', 'Class Teacher', '2024-03-20 00:53:54'),
(28, 'Puneet Kumar', 'Sharma', 'Teaching', 'bhardwajpuni@gmail.com', '9050367048', 'B-986 Street no 29 Sant Nagar Burari Delhi 84', NULL, 'BSc', '2017-07-03', '6 years 8 months', 'Male', '1988-12-15', 'TGT', 'Class Teacher', '2024-03-20 00:53:54'),
(29, 'Akansha', 'Gupta', 'Teaching', 'akangupta95@gmail.com', '8447587543', 'WZ-13 Jwala Heri Mkt Pachim Vihar New Delhi 63', NULL, 'BCom', '2018-09-01', '5 years 6 months', 'Female', '1993-04-21', 'TGT', 'Class Teacher', '2024-03-20 00:53:54'),
(30, 'Vishakha', 'Verma', 'Teaching', 'vermavishakha10@gmail.com', '9899764481', 'RZF 1/6 Street No 1 Mahavir Enclave New Delhi 110045', NULL, 'BCom', '2019-07-15', '4 years 8 months', 'Female', '1992-06-11', 'TGT', 'Class Teacher', '2024-03-20 00:53:54'),
(31, 'Rajiv', 'Sharma', 'Teaching', 'rajeevfotografia@gmail.com', '7838367899', 'E-42/404 Aashirdwad Apartment Vishwash Park Uttam nagar New Delhi', NULL, 'BCom', '1995-07-06', '28 years 8 months', 'Male', '1968-05-01', 'PRT', 'Staff', '2024-03-20 00:53:54'),
(32, 'Sofi', 'Mathew', 'Teaching', 'sofishajan@gmail.com', '9350975631', 'Thattupattu House Kodikulam PO Thodupuzha Idukki dist', NULL, 'BCom', '2007-07-16', '16 years 8 months', 'Female', '1971-09-01', 'PRT', 'Class Teacher', '2024-03-20 00:53:54'),
(33, 'Shweta', 'Bhatia', 'Teaching', 'crpfps.5a@gmail.com', '9971444158', '51 Rashi Apartment plot no 3 Sec-7 Dwarka N-Delhi', NULL, 'BCom', '2007-07-02', '16 years 8 months', 'Female', '1976-05-10', 'PRT', 'Class Teacher', '2024-03-20 00:55:10'),
(34, 'Dr. Anushi', 'Sharma', 'Teaching', 'anushisharma10@gmail.com', '9013280810', 'Om Mandir G Block Mansarvor Garden Delhi-15', NULL, 'BCom', '2008-07-26', '15 years 8 months', 'Female', '1976-06-15', 'PRT', 'Class Teacher', '2024-03-20 00:55:10'),
(35, 'Hemlata', '', 'Teaching', 'hemasudesh925@gmail.com', '9250582353', 'RZ-53 New-Roshan Pura ext New-Delhi-43', NULL, 'BCom', '2008-07-26', '15 years 8 months', 'Female', '1976-03-11', 'PRT', 'Staff', '2024-03-20 00:55:10'),
(36, 'Deepika', 'Kapoor', 'Teaching', 'deepikakapoor19@hotmail.com', '9810597907', '17-197 Subhash Nagar New-Delhi 110027', NULL, 'BCom', '2009-07-06', '14 years 8 months', 'Female', '1987-08-19', 'PRT', 'Class Teacher', '2024-03-20 00:55:10'),
(37, 'C. Rashmi', '', 'Teaching', 'rashminair1584@gmail.com', '9891649650', 'Chathnath House Valanchery Vauyakunny Malappuram', NULL, 'BCom', '2009-09-01', '14 years 6 months', 'Female', '1984-10-15', 'PRT', 'Class Teacher', '2024-03-20 00:55:10'),
(38, 'Neha Abhishek', 'Joshi', 'Teaching', 'nehaabhishekjoshi@gmail.com', '9810387092', '158 Pink Apt DDA MIG Flats Sec-18 B N-Delhi 75', NULL, 'BCom', '2010-07-01', '13 years 8 months', 'Female', '1985-02-28', 'PRT', 'Class Teacher', '2024-03-20 00:55:10'),
(39, 'Yamini', '', 'Teaching', 'yaminitongria332@gmail.com', '9818853576', 'K-6/3 Sec-2 Udyan Marg DIZ Area New-Delhi-1', NULL, 'BCom', '2010-07-01', '13 years 8 months', 'Female', '1977-09-19', 'PRT', 'Class Coordinator', '2024-03-20 00:55:10'),
(40, 'Yogita', '', 'Teaching', 'yogitapassi14sep@gmail.com', '9968270633', 'C-3 NPL Colony New-Rajinder Nagar New-Delhi 60', NULL, 'BCom', '2010-07-01', '13 years 8 months', 'Female', '1983-09-14', 'PRT', 'Class Teacher', '2024-03-20 00:55:10'),
(42, 'Shewta', 'Bhatia', 'Teaching', 'crpfps.5a@gmail.com', '9971444158', '51 Rashi Apartment plot no 3 Sec-7 Dwarka N-Delhi', NULL, 'BCom', '2007-07-02', '16 years 8 months', 'Female', '1976-05-10', 'PRT', 'Class Teacher', '2024-03-20 00:57:09'),
(43, 'Dr. Anushi', 'Sharma', 'Teaching', 'anushisharma10@gmail.com', '9013280810', 'Om Mandir G Block Mansarvor Garden Delhi-15', NULL, 'BCom', '2008-07-26', '15 years 8 months', 'Female', '1976-06-15', 'PRT', 'Class Teacher', '2024-03-20 00:57:09'),
(44, 'Hemlata', '', 'Teaching', 'hemasudesh925@gmail.com', '9250582353', 'RZ-53 New-Roshan Pura ext New-Delhi-43', NULL, 'BCom', '2008-07-26', '15 years 8 months', 'Female', '1976-03-11', 'PRT', 'Staff', '2024-03-20 00:57:09'),
(45, 'Deepika', 'Kapoor', 'Teaching', 'deepikakapoor19@hotmail.com', '9810597907', '17-197 Subhash Nagar New-Delhi 110027', NULL, 'BCom', '2009-07-06', '14 years 8 months', 'Female', '1987-08-19', 'PRT', 'Class Teacher', '2024-03-20 00:57:09'),
(46, 'C. Rashmi', '', 'Teaching', 'rashminair1584@gmail.com', '9891649650', 'Chathnath House Valanchery Vauyakunny Malappuram', NULL, 'BCom', '2009-09-01', '14 years 6 months', 'Female', '1984-10-15', 'PRT', 'Class Teacher', '2024-03-20 00:57:09'),
(47, 'Neha Abhishek', 'Joshi', 'Teaching', 'nehaabhishekjoshi@gmail.com', '9810387092', '158 Pink Apt DDA MIG Flats Sec-18 B N-Delhi 75', NULL, 'BCom', '2010-07-01', '13 years 8 months', 'Female', '1985-02-28', 'PRT', 'Class Teacher', '2024-03-20 00:57:09'),
(48, 'Yamini', '', 'Teaching', 'yaminitongria332@gmail.com', '9818853576', 'K-6/3 Sec-2 Udyan Marg DIZ Area New-Delhi-1', NULL, 'BCom', '2010-07-01', '13 years 8 months', 'Female', '1977-09-19', 'PRT', 'Class Coordinator', '2024-03-20 00:57:09'),
(49, 'Yogita', '', 'Teaching', 'yogitapassi14sep@gmail.com', '9968270633', 'C-3 NPL Colony New-Rajinder Nagar New-Delhi 60', NULL, 'BCom', '2010-07-01', '13 years 8 months', 'Female', '1983-09-14', 'PRT', 'Class Teacher', '2024-03-20 00:57:09'),
(50, 'Ekta', 'Mittal', 'Teaching', 'govindarchana30@yahoo.in', '9868735168', '135 old Gupt Colony Near Gita Bhavan Delhi 9', NULL, 'MSc', '2010-07-01', '13 years 8 months', 'Female', '1973-11-08', 'PRT', 'Class Coordinator', '2024-03-20 00:59:16'),
(51, 'PRAGYA', 'NANDA', 'Teaching', 'dipragya77@gmail.com', '8595792659', 'DG-II 125 B Vikaspuri New-Delhi', NULL, 'BCom', '2010-07-01', '13 years 8 months', 'Female', '1977-12-31', 'PRT', 'Class Coordinator', '2024-03-20 00:59:16'),
(52, 'Sonal', 'Mehta', 'Teaching', 'sonaldua322015@gmail.com', '9999256909', 'BA-48 B Janak puri Delhi', NULL, 'BCom', '2011-07-01', '12 years 8 months', 'Female', '1981-09-05', 'PRT', 'Class Teacher', '2024-03-20 00:59:16'),
(53, 'MEENAL', 'UPADHYAY', 'Teaching', 'meenalkaur11@gmail.com', '8860194811', 'D-65 Maqsudabad Colony Najafgarh New-Delhi 43', NULL, 'BCom', '2011-07-01', '12 years 8 months', 'Female', '1980-12-11', 'PRT', 'Class Teacher', '2024-03-20 00:59:16'),
(54, 'Madhu', 'Gupta', 'Teaching', 'madhugupta2705@yahoo.co.in', '9015471605', 'RZ-1122 Gali no 14/5 Sadh Nagar Palam Colony NDelhi 45', NULL, 'BSc', '2010-07-01', '13 years 8 months', 'Female', '1974-05-27', 'PRT', 'Class Teacher', '2024-03-20 00:59:17'),
(55, 'Rama', 'Makin', 'Teaching', 'makinrama@gmail.com', '9971218995', '164 State bank nagar Pachim Vihar New-Delhi 63', NULL, 'BSc', '2011-07-01', '12 years 8 months', 'Female', '1971-01-13', 'PRT', 'Class Teacher', '2024-03-20 00:59:17'),
(56, 'Esha', 'Sharma', 'Teaching', 'esupmanu@gmail.com', '9560517781', 'WZ-44G PossangiPuri Janak Puri New-Delhi-58', NULL, 'BCom', '2011-07-01', '12 years 8 months', 'Female', '1989-12-01', 'PRT', 'Class Teacher', '2024-03-20 00:59:17'),
(57, 'Sashikanta', 'Nayak', 'Teaching', 'sashiodissidance@gmail.com', '9873058759', 'H-1/122 Second Floor Sec-16 Rohini Delhi-85', NULL, 'BCom', '2011-07-01', '12 years 8 months', 'Male', '1979-05-05', 'PRT', 'Class Teacher', '2024-03-20 00:59:17'),
(58, 'Meeta', 'Manocha', 'Teaching', 'meetamanochas@gmail.com', '9999010564', 'Flat no 13 DDA Sector 4 Pocket 1 Harmony Appts Dwarka New Delhi 75', NULL, 'BSc', '2019-01-15', '5 years 2 months', 'Female', '1982-10-15', 'PRT', 'Class Teacher', '2024-03-20 01:00:19'),
(59, 'Aseem', 'Sehrawat', 'Teaching', 'aseemsehrawat@gmail.com', '9311540650', 'HNo 85/86 Pocket 2 Sector 19 Amberhai Extension Dwarka New Delhi 110075', NULL, 'BCom', '2019-07-01', '4 years 8 months', 'Female', '1983-06-09', 'PRT', 'Class Teacher', '2024-03-20 01:00:19'),
(60, 'Bamadev', 'Mallick', 'Teaching', 'bdmallick.09@gmail.com', '9999474994', '20 Kartik Apts Sec-21C Faridabad (Haryana)', NULL, 'BCom', '2011-07-01', '12 years 8 months', 'Male', '1962-04-02', 'PRT', 'Staff', '2024-03-20 01:00:19'),
(65, 'Surupa', 'Dutt', 'Teaching', 'surupa8888@gmail.com', '9810565000', 'A-102 Harmony Apt Plot no 6 B Sec 23 Dwarka 77', NULL, 'BCom', '2014-07-04', '9 years 8 months', 'Female', '1974-03-30', 'French Teacher', 'Staff', '2024-03-20 01:01:21'),
(66, 'BHUVANESHWARI', 'P K', NULL, 'ambika301301@gmail.com', '7701997907', NULL, NULL, 'BCom', '2009-09-01', '14 years 6 months', 'Female', '1978-10-10', 'Admin Staff', NULL, '2024-03-20 01:01:21'),
(67, 'SHINY', 'SANADHANAN', NULL, 'shinysanad@gmail.com', '9873755742', NULL, NULL, 'BA', '2008-09-16', '15 years 6 months', 'Female', '1969-01-10', 'UDC(A/cs)', NULL, '2024-03-20 01:01:21'),
(68, 'SHEETAL', 'SETHI', NULL, 'sheetalkashyap@gmail.com', '9811182891', NULL, NULL, 'BCom', '2010-07-01', '13 years 8 months', 'Female', '1980-10-27', 'LDC', NULL, '2024-03-20 01:01:21'),
(69, 'JESSY', 'BIJU', NULL, 'jessybiju@gmail.com', '9868991972', NULL, NULL, 'HS', '2010-07-01', '13 years 8 months', 'Female', '1971-06-12', 'Medical Assistant', NULL, '2024-03-20 01:01:21'),
(70, 'ARPIT', 'KAUR', 'Teaching', 'typingwitharpit@gmail.com', '8586834335', 'A-117, First Floor, Ganesh Nagar, Tilak Nagar, New Delhi-110018', NULL, 'MCA', '2022-07-01', '1 years 8 months', 'Female', '1993-08-30', 'PRT Computer Science', 'Class Teacher', '2024-03-20 01:02:22'),
(71, 'VAISHALI', 'BAGGA', 'Teaching', 'vaishali.flies@gmail.com', '9205715174', NULL, NULL, 'BSc', '2022-07-01', '1 years 8 months', 'Female', '1993-08-21', 'PRT', 'Class Teacher', '2024-03-20 01:02:22'),
(72, 'KOMAL', 'HOODA', 'Teaching', 'crpfpsdwarka@gmail.com', '8851610199', NULL, NULL, 'BCom', '2022-07-22', '1 years 8 months', 'Female', '1994-06-02', 'PRT sst', 'Class Teacher', '2024-03-20 01:02:22'),
(73, 'MANU', 'BALI', 'Teaching', 'crpfpsdwarka@gmail.com', '9971323657', NULL, NULL, 'BSc', '2022-07-22', '1 years 8 months', 'Female', '2002-07-22', 'PRT sst', 'Class Teacher', '2024-03-20 01:02:23'),
(74, 'ANJALI', 'PATHAK', 'Teaching', 'crpfpsdwarka@gmail.com', '9953519376', NULL, NULL, 'BSc', '2022-07-22', '1 years 8 months', 'Female', '2002-07-22', 'PRT sst', 'Class Teacher', '2024-03-20 01:02:23'),
(75, 'SHRUTI', 'GOYAL', 'Teaching', 'crpfpsdwarka@gmail.com', '8766379205', NULL, NULL, 'BCom', '2022-08-06', '1 years 7 months', 'Female', '2002-08-06', 'PRT sst', 'Class Teacher', '2024-03-20 01:02:23'),
(76, 'SONIA', 'JARIAL', 'Teaching', 'jarialsonia20@gmail.com', '9560022920', NULL, NULL, 'BTech', '2022-10-17', '1 years 5 months', 'Female', '1989-04-09', 'Tata Co-Ordinator', 'Class Coordinator', '2024-03-20 01:02:23'),
(77, 'PREETI', 'AADESH', 'Non Teaching', 'preetidalal77@gmail.com', '8178563817', NULL, NULL, 'BTech', '2023-01-09', '1 years 2 months', 'Female', '1992-07-07', 'Admin Staff', 'Class Coordinator', '2024-03-20 01:02:23'),
(78, 'AANCHAL', 'ADHIKARI', 'Teaching', 'crpfpsdwarka@gmail.com', '9667454587', NULL, NULL, 'BCom', '2023-04-24', '0 years 11 months', 'Female', '2003-05-03', 'PRT sst', 'Class Teacher', '2024-03-20 01:03:23'),
(79, 'MS', 'LATIKA', 'Teaching', 'crpfpsdwarka@gmail.com', '9318499311', NULL, NULL, 'BCom', '2023-07-01', '0 years 8 months', 'Female', '2003-07-06', 'TGT (English)', 'Class Teacher', '2024-03-20 01:03:23'),
(80, 'MS', 'CHETNA', 'Teaching', 'crpfpsdwarka@gmail.com', '7065673140', NULL, NULL, 'BCom', '2023-07-06', '0 years 8 months', 'Female', '2003-07-06', 'PRT sst', 'Class Teacher', '2024-03-20 01:03:23'),
(81, 'SURABHI', 'CHOWDHARY', 'Teaching', 'crpfpsdwarka@gmail.com', '7838157376', NULL, NULL, 'M.A', '2023-07-06', '0 years 8 months', 'Male', '2003-07-06', 'PGT (History)', 'Class Teacher', '2024-03-20 01:03:23'),
(82, 'RANJANA', 'RANJANA', 'Teaching', 'crpfpsdwarka@gmail.com', '8433498065', NULL, NULL, 'MA', '2023-07-06', '0 years 8 months', 'Male', '2003-07-06', 'PGT (History)', 'Class Teacher', '2024-03-20 01:03:23');

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

--
-- Table structure for table `teacher_subject`
--

CREATE TABLE `teacher_subject` (
  `id` int(255) NOT NULL,
  `teacher_id` int(255) DEFAULT NULL,
  `subject_id` int(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `classes_number`
--
ALTER TABLE `classes_number`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`,`name`);

--
-- Indexes for table `classes_sections`
--
ALTER TABLE `classes_sections`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`,`name`);

--
-- Indexes for table `class_teacher`
--
ALTER TABLE `class_teacher`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`,`class_id`,`teacher_id`);

--
-- Indexes for table `country`
--
ALTER TABLE `country`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`,`country_id`),
  ADD KEY `country_name` (`country_name`);

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

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`,`name`),
  ADD KEY `text` (`text`,`desc`,`status`,`type`,`icon`);

--
-- Indexes for table `students`
--
ALTER TABLE `students`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

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

--
-- Indexes for table `subject`
--
ALTER TABLE `subject`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`,`name`);

--
-- Indexes for table `subject_modules`
--
ALTER TABLE `subject_modules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`,`name`);

--
-- Indexes for table `subject_modules_options`
--
ALTER TABLE `subject_modules_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`,`name`);

--
-- Indexes for table `subject_modules_options_pointers`
--
ALTER TABLE `subject_modules_options_pointers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`,`name`,`subject_modules_options_id`,`subject_modules_options_name`);

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

--
-- Indexes for table `teacher_subject`
--
ALTER TABLE `teacher_subject`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`,`teacher_id`,`subject_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `class_teacher`
--
ALTER TABLE `class_teacher`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `message`
--
ALTER TABLE `message`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `teacher_subject`
--
ALTER TABLE `teacher_subject`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

${this.title}

Code Editor : mydemose_crpf.sql