-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 25, 2025 at 08:36 PM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

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: `esekotli`
--

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

--
-- Table structure for table `attendance`
--

CREATE TABLE `attendance` (
  `id` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `timestamp` datetime NOT NULL,
  `location_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `board_results`
--

CREATE TABLE `board_results` (
  `id` int(11) NOT NULL,
  `emis_code` varchar(255) NOT NULL,
  `class_name` varchar(255) NOT NULL,
  `result_year` int(11) NOT NULL,
  `arts` int(11) DEFAULT 0,
  `science` int(11) DEFAULT 0,
  `total_students` int(11) NOT NULL,
  `pass` int(11) NOT NULL,
  `fail` int(11) NOT NULL,
  `result_percent` decimal(5,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `board_results`
--

INSERT INTO `board_results` (`id`, `emis_code`, `class_name`, `result_year`, `arts`, `science`, `total_students`, `pass`, `fail`, `result_percent`) VALUES
(1, '20000', '5', 2020, 7, 3, 10, 5, 5, 50.00),
(2, '20000', '8', 2020, 10, 0, 10, 10, 0, 100.00),
(3, '20000', '9', 2020, 5, 5, 10, 5, 5, 50.00),
(4, '50', '5', 2020, 5, 0, 5, 5, 0, 100.00),
(5, '50', '11', 2020, 6, 6, 12, 5, 7, 41.67),
(6, '2000034567899', '5', 0, 7, 5, 12, 8, 4, 66.67),
(7, '2000034567899', '10', 0, 12, 8, 20, 15, 5, 75.00),
(8, '2000034567899', '5', 0, 7, 5, 12, 8, 4, 66.67),
(9, '2000034567899', '10', 0, 12, 8, 20, 15, 5, 75.00),
(10, '2000034567899', '5', 0, 7, 5, 12, 8, 4, 66.67),
(11, '2000034567899', '10', 0, 12, 8, 20, 15, 5, 75.00),
(12, '20000', '8', 2021, 5, 0, 5, 5, 0, 100.00);

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

--
-- Table structure for table `bps`
--

CREATE TABLE `bps` (
  `bps_id` int(11) NOT NULL,
  `bps_name` varchar(10) NOT NULL,
  `bps_label` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bps`
--

INSERT INTO `bps` (`bps_id`, `bps_name`, `bps_label`) VALUES
(1, 'BPS-1', 'Basic Pay Scale 1'),
(2, 'BPS-2', 'Basic Pay Scale 2'),
(3, 'BPS-3', 'Basic Pay Scale 3'),
(4, 'BPS-4', 'Basic Pay Scale 4'),
(5, 'BPS-5', 'Basic Pay Scale 5'),
(6, 'BPS-6', 'Basic Pay Scale 6'),
(7, 'BPS-7', 'Basic Pay Scale 7'),
(8, 'BPS-8', 'Basic Pay Scale 8'),
(9, 'BPS-9', 'Basic Pay Scale 9'),
(10, 'BPS-10', 'Basic Pay Scale 10'),
(11, 'BPS-11', 'Basic Pay Scale 11'),
(12, 'BPS-12', 'Basic Pay Scale 12'),
(13, 'BPS-13', 'Basic Pay Scale 13'),
(14, 'BPS-14', 'Basic Pay Scale 14'),
(15, 'BPS-15', 'Basic Pay Scale 15'),
(16, 'BPS-16', 'Basic Pay Scale 16'),
(17, 'BPS-17', 'Basic Pay Scale 17'),
(18, 'BPS-18', 'Basic Pay Scale 18'),
(19, 'BPS-19', 'Basic Pay Scale 19'),
(20, 'BPS-20', 'Basic Pay Scale 20'),
(21, 'BPS-21', 'Basic Pay Scale 21'),
(22, 'BPS-22', 'Basic Pay Scale 22'),
(23, 'BPS-23', 'Basic Pay Scale 23');

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

--
-- Table structure for table `building_details`
--

CREATE TABLE `building_details` (
  `id` int(11) NOT NULL,
  `emis_code` varchar(40) NOT NULL,
  `building_select` enum('yes','no') NOT NULL,
  `ownership_type` enum('Govt.','Rental','Without Rent','Donated','Masjid','In Other school building') DEFAULT NULL,
  `rental_payee` varchar(255) DEFAULT NULL,
  `construction_year` int(11) DEFAULT NULL,
  `building_condition` enum('Satisfactory','Need Repair','Need Construction') DEFAULT NULL,
  `construction_material` enum('Cemented','Mud/wood','Pre Fabricated','Shelter','Wood/Iron sheet','Mixed') DEFAULT NULL,
  `boundary_wall` enum('yes','no') DEFAULT NULL,
  `no_building_reason` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `building_details`
--

INSERT INTO `building_details` (`id`, `emis_code`, `building_select`, `ownership_type`, `rental_payee`, `construction_year`, `building_condition`, `construction_material`, `boundary_wall`, `no_building_reason`, `created_at`) VALUES
(1, '888000', 'yes', 'Govt.', '', 1910, 'Satisfactory', 'Cemented', 'yes', '', '2024-07-31 05:53:14'),
(2, '200000', 'no', '', '', 0, '', '', '', 'Under Construction', '2024-07-31 05:54:41'),
(3, '8901234', 'no', '', '', 0, '', '', '', 'Under Construction', '2024-07-31 05:58:06'),
(4, '890123400', 'yes', 'Govt.', 'ali', 1900, 'Satisfactory', 'Cemented', 'yes', 'Under Construction', '2024-07-31 05:59:10'),
(5, '200000', 'yes', 'Govt.', 'ali', 1900, 'Satisfactory', 'Cemented', 'yes', '', '2024-08-01 09:57:44'),
(6, '200000', 'no', 'Govt.', 'ali', 1900, 'Satisfactory', 'Cemented', 'yes', 'hamza', '2024-08-01 10:00:37'),
(7, '123', 'no', '', '', 0, '', '', '', 'hamza', '2024-08-07 04:39:14');

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

--
-- Table structure for table `class`
--

CREATE TABLE `class` (
  `class_id` int(10) NOT NULL,
  `class_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `class`
--

INSERT INTO `class` (`class_id`, `class_name`) VALUES
(1, 'ECE'),
(2, 'K.G'),
(3, 'Nursery'),
(4, 'Prep'),
(5, 'One'),
(6, 'Two'),
(7, 'Three'),
(8, '4th'),
(9, '5th'),
(10, '6th'),
(11, '7th'),
(12, '8th'),
(13, '9th'),
(14, '10th'),
(15, '1st Year'),
(16, '2nd Year');

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

--
-- Table structure for table `constituency`
--

CREATE TABLE `constituency` (
  `cons_id` int(11) NOT NULL,
  `cons_name` varchar(50) NOT NULL,
  `tehsil_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=Active | 0=Inactive'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `constituency`
--

INSERT INTO `constituency` (`cons_id`, `cons_name`, `tehsil_id`, `status`) VALUES
(1, 'LA-18 Kotli-I', 1, 1),
(2, 'LA-19 Kotli-II', 1, 1),
(3, 'LA-20 Kotli-III', 1, 1),
(4, 'LA-21 Kotli-IV', 2, 1),
(5, 'LA-19 Kotli-II', 3, 1),
(6, 'LA-18 Kotli-I', 4, 1),
(7, 'LA-19 Kotli-II', 4, 1),
(8, 'LA-20 Kotli-III', 4, 1),
(9, 'LA-19 Kotli-II', 5, 1),
(10, 'LA-19 Kotli-II', 6, 1),
(11, 'LA-20 Kotli-III', 6, 1);

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

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

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `contact_no` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `message` text NOT NULL,
  `submission_date` datetime NOT NULL,
  `ip_address` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `contact_us` (`id`, `name`, `contact_no`, `email`, `message`, `submission_date`, `ip_address`) VALUES
(7, 'Mohsin Bashir', '03435115550', 'mohsinbashirraja@gmail.com', 'sent from website', '2025-07-08 10:31:52', '::1'),
(8, 'Mohsin Bashir', '03435115550', 'mohsinbashirraja@gmail.com', 'hello again', '2025-07-08 10:43:21', '::1'),
(9, 'Mohsin Bashir', '03435115550', 'mohsinbashirraja@gmail.com', 'kklkkk', '2025-07-09 11:10:49', '::1');

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

--
-- Table structure for table `designations`
--

CREATE TABLE `designations` (
  `des_id` int(11) NOT NULL,
  `designation_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `designations`
--

INSERT INTO `designations` (`des_id`, `designation_name`) VALUES
(1, 'Senior Principal'),
(2, 'Principal'),
(3, 'Senior Headmaster'),
(4, 'Headmaster'),
(5, 'Senior Headmistress'),
(6, 'Headmistress'),
(7, 'Senior Subject Specialist'),
(8, 'Subject Specialist'),
(9, 'Computer Instructor'),
(10, 'Senior Teacher (General Line)'),
(11, 'Senior Teacher (Science)'),
(12, 'Senior Teacher (Biology)'),
(13, 'Senior Technical Teacher'),
(14, 'DPE'),
(15, 'Librarian'),
(16, 'Junior Computer Teacher'),
(17, 'Elementary Teacher (Junior)'),
(18, 'Elementary Teacher (Science)'),
(19, 'Elementary Teacher (Qari)'),
(20, 'Elementary Teacher (Arabic)'),
(21, 'PET'),
(22, 'Elementary Teacher (Drawing)'),
(23, 'Elementary Teacher (Agrotech)'),
(24, 'Elementary Teacher (Technical)'),
(25, 'Elementary Teacher (Primary)'),
(26, 'Library Assistant'),
(27, 'Moallam Ul Quran'),
(28, 'Head Clerk'),
(29, 'Senior Clerk'),
(30, 'Junior Clerk'),
(31, 'Computer Lab Assistant'),
(32, 'Bandmaster'),
(33, 'Laboratory Attendant'),
(34, 'Naib Qasid'),
(35, 'Water Carrier'),
(36, 'Sweaper'),
(37, 'Chowkidar'),
(38, 'Mali/Malan'),
(39, 'Cook'),
(40, 'Other');

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

--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `district_id` int(5) NOT NULL,
  `district_name` varchar(50) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=Active | 0=Inactive'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `districts`
--

INSERT INTO `districts` (`district_id`, `district_name`, `status`) VALUES
(1, 'KOTLI', 1),
(2, 'MIRPUR', 1),
(3, 'BHIMBER', 1),
(4, 'POONCH', 1),
(5, 'BAGH', 1),
(6, 'HAVELI', 1),
(7, 'MUZAFFARABAD', 1),
(8, 'NEELUM', 1),
(9, 'JEHLUM VALLEY', 1),
(10, 'SUDHNUTI', 1);

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

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `name`, `latitude`, `longitude`) VALUES
(2, 'ps bagah', 12.00000000, 65.00000000);

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

--
-- Table structure for table `location_data`
--

CREATE TABLE `location_data` (
  `id` int(11) NOT NULL,
  `district_id` int(11) DEFAULT NULL,
  `tehsil_id` int(11) DEFAULT NULL,
  `union_council_id` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `location_data`
--

INSERT INTO `location_data` (`id`, `district_id`, `tehsil_id`, `union_council_id`, `created_at`) VALUES
(1, 1, 1, 4, 0),
(2, 1, 1, 1, 0),
(3, 4, 3, 5, 0),
(4, 1, 1, 1, 0),
(5, 4, 3, 6, 0),
(6, 1, 1, 2, 0);

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

--
-- Table structure for table `next_kin`
--

CREATE TABLE `next_kin` (
  `relationship_id` int(11) NOT NULL,
  `relationship_name` varchar(50) NOT NULL,
  `relationship_name_urdu` varchar(50) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `next_kin`
--

INSERT INTO `next_kin` (`relationship_id`, `relationship_name`, `relationship_name_urdu`, `is_active`) VALUES
(1, 'Father', 'والد', 1),
(2, 'Mother', 'والدہ', 1),
(3, 'Husband', 'شوہر', 1),
(4, 'Wife', 'بیوی', 1),
(5, 'Son', 'بیٹا', 1),
(6, 'Daughter', 'بیٹی', 1),
(7, 'Brother', 'بھائی', 1),
(8, 'Sister', 'بہن', 1),
(9, 'Uncle (Paternal)', 'چچا/تایا', 1),
(10, 'Uncle (Maternal)', 'ماموں', 1),
(11, 'Aunt (Paternal)', 'پھپھو', 1),
(12, 'Aunt (Maternal)', 'خالہ', 1),
(13, 'Grandfather (Paternal)', 'دادا', 1),
(14, 'Grandfather (Maternal)', 'نانا', 1),
(15, 'Grandmother (Paternal)', 'دادی', 1),
(16, 'Grandmother (Maternal)', 'نانی', 1),
(17, 'Nephew', 'بھتیجا/بھانجا', 1),
(18, 'Niece', 'بھتیجی/بھانجی', 1),
(19, 'Cousin', 'کزن', 1),
(20, 'Guardian', 'سرپرست', 1),
(21, 'Other', 'دیگر', 1);

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` int(11) NOT NULL,
  `emis_code` varchar(255) NOT NULL,
  `post_name` varchar(255) NOT NULL,
  `male` int(11) NOT NULL,
  `female` int(11) NOT NULL,
  `post_as_per_budget` int(11) NOT NULL,
  `filled_post` int(11) NOT NULL,
  `vacant_post` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`id`, `emis_code`, `post_name`, `male`, `female`, `post_as_per_budget`, `filled_post`, `vacant_post`, `created_at`) VALUES
(1, '50', 'Principal', 1, 0, 1, 1, 0, '2024-07-30 08:54:22'),
(2, '40', 'Principal', 1, 0, 1, 1, 0, '2024-07-30 08:56:04'),
(3, '40', 'Teacher', 10, 5, 18, 20, 3, '2024-07-30 08:56:04'),
(4, '40', 'Clerk', 1, 0, 1, 1, 0, '2024-07-30 08:56:04'),
(5, '20000', 'Cook', 1, 1, 1, 1, 1, '2024-07-30 10:08:09'),
(6, '20000', 'Librarian', 1, 1, 1, 1, 1, '2024-07-30 10:08:09'),
(7, '20000', 'Senior Teacher general line', 1, 1, 1, 1, 1, '2024-07-30 10:08:09'),
(8, '20000', 'Senior Teacher Biology', 1, 1, 1, 1, 1, '2024-07-30 10:08:09'),
(9, '20000', 'Senior Principal', 2, 1, 2, 2, 1, '2024-07-31 06:02:03'),
(10, '20000', 'Senior Headmaster', 2, 2, 5, 4, 1, '2024-08-01 10:02:38'),
(11, '20000', 'Senior Teacher Biology', 1, 0, 1, 1, 0, '2024-08-01 10:02:38'),
(12, '5050', 'Headmistress', 0, 1, 1, 1, 0, '2024-08-01 10:04:37');

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

--
-- Table structure for table `private_schools`
--

CREATE TABLE `private_schools` (
  `id` int(12) NOT NULL,
  `name` varchar(55) NOT NULL,
  `level` varchar(25) NOT NULL,
  `district` varchar(55) NOT NULL,
  `tehsil` varchar(55) NOT NULL,
  `status` varchar(55) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `private_schools`
--

INSERT INTO `private_schools` (`id`, `name`, `level`, `district`, `tehsil`, `status`) VALUES
(1, 'Al-Ghazali College of Sciences', 'College', 'Kotli', 'Kotli', 'Registered'),
(2, 'Fatima Tuz Zahra College of Sciences', 'College', 'Kotli', 'Kotli', 'Registered'),
(3, 'Arfah Institute of Modern Studies', 'College', 'Kotli', 'Kotli', 'Registered'),
(4, 'ABC Public School', 'Primary', 'Kotli', 'Charhoi', 'Un-registered'),
(5, 'MRT Public School', 'Middle', 'Kotli', 'Sehnsa', 'Blacklisted'),
(6, 'BBC Public School', 'High', 'Kotli', 'Khuiratta', 'Blacklisted'),
(7, 'www Public School', 'Primary', 'Kotli', 'Dulliyah Jattan', 'Blacklisted'),
(8, 'qqq Public School', 'Higher Secondary', 'Kotli', 'Fatehpur', 'Un-registered'),
(9, 'zaw Public School', 'High', 'Kotli', 'Sehnsa', 'Registered');

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

--
-- Table structure for table `quota`
--

CREATE TABLE `quota` (
  `quota_id` int(11) NOT NULL,
  `quota_type` varchar(100) NOT NULL,
  `description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `quota`
--

INSERT INTO `quota` (`quota_id`, `quota_type`, `description`) VALUES
(1, 'Merit-Based Quota', 'Selections made purely on academic performance and test scores'),
(2, 'Regional/District Quota', 'Reserved for candidates from specific districts of AJK'),
(3, 'Disabled Persons Quota', 'Reserved for persons with disabilities'),
(4, 'Kashmiri Refugees Quota 1947', 'For refugees who migrated from Indian-administered Kashmir in 1947'),
(5, 'Kashmiri Refugees Quota 1965', 'For refugees who migrated from Indian-administered Kashmir in 1965'),
(6, 'Kashmiri Refugees Quota 1990', 'For refugees who migrated from Indian-administered Kashmir in 1990'),
(7, 'Kashmiri Refugees Settled in Pakistan', 'For Kashmiri refugees settled in other parts of Pakistan'),
(8, 'Departmental Quota', 'Reserved for children of government employees or serving employees');

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

--
-- Table structure for table `registrations`
--

CREATE TABLE `registrations` (
  `emis_code` varchar(50) NOT NULL,
  `school_name` varchar(100) NOT NULL,
  `cate_id` int(11) NOT NULL,
  `level_id` int(11) NOT NULL,
  `password` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1=Active | 0=Inactive',
  `created_at` timestamp(6) NOT NULL DEFAULT current_timestamp(6)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `registrations`
--

INSERT INTO `registrations` (`emis_code`, `school_name`, `cate_id`, `level_id`, `password`, `status`, `created_at`) VALUES
('50230210335', 'GMPS CHAPAR DHAR', 1, 1, '$2y$10$kJvGAYqCIYjGhRi/uIYQ4.JK47VcsRuNk9XSB8P82OmcnZAqQwWPW', 0, '2024-08-17 17:07:27.856795'),
('50250321429', 'GGPS DOBA', 1, 2, '$2y$10$oKrUsvoDAbyOnqJg1rijhO36BWfGcBf1XRsYdBefZGenJHv6frlxC', 1, '2024-08-08 20:27:34.709563'),
('50720322079', 'GGPS SARY', 1, 2, '$2y$10$ZEh.qGPuVJIL4v0hqIySqO6vA66aRKxYlamB51l1oG79UJvbNUNd2', 0, '2024-08-08 20:27:34.709563'),
('50830320677', 'GGPS ANDAR', 1, 2, '$2y$10$/AX87hVRcP0atd3zPU4ujulqfzOGHLaJnsYWgY7E2OXfzRRu4hXVm', 1, '2024-08-08 20:27:34.709563'),
('50850420844', 'GGMS SAWAR', 1, 3, '$2y$10$WtJKFTB6ejLkF.g8faS8.ucXeJOiGohZToQOBiwe0J1k.FRcPQo2q', 0, '2024-08-08 20:27:34.709563'),
('50850510854', 'GBHS PRNJRA', 1, 4, '$2y$10$9Woka/mq/zDnYR7l58vWPe3pUiZYs7utnpt/C1ndxog6UtC7pBvpG', 1, '2024-08-08 20:27:34.709563'),
('50860510784', 'GBHS DAKH', 1, 4, '$2y$10$.ngSkHc37B/HlAq/WDhaFumEQicBxFNFVKm8jVxH4Ame/uG69Tvzy', 1, '2024-08-08 20:27:34.709563'),
('50860510813', 'GBHS PALYAT SAYDEN', 1, 4, '$2y$10$Bc.1YdgG819Fvo0eBJj/GO6AqPS5jwVMaUu5SBSPz2k.nTilE0BhK', 0, '2024-08-08 20:27:34.709563');

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

--
-- Table structure for table `room_details`
--

CREATE TABLE `room_details` (
  `id` int(11) NOT NULL,
  `building_id` int(11) DEFAULT NULL,
  `room_type` enum('Heads Office','Staff Room','Clerk Office','Library','Labs','Class Rooms','Hall','Store','Kitchen','Residential Room','Hostel','Staff Washrooms','Students Washrooms') DEFAULT NULL,
  `total_rooms` int(11) DEFAULT NULL,
  `room_condition` enum('Satisfactory','Need Repair','Need Construction') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `room_details`
--

INSERT INTO `room_details` (`id`, `building_id`, `room_type`, `total_rooms`, `room_condition`) VALUES
(1, 1, 'Heads Office', 1, 'Satisfactory'),
(2, 1, 'Staff Room', 1, 'Need Repair'),
(3, 1, 'Class Rooms', 12, 'Satisfactory'),
(4, 4, 'Store', 1, 'Need Construction'),
(5, 5, 'Clerk Office', 2, 'Satisfactory'),
(6, 5, 'Heads Office', 1, 'Need Construction');

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

--
-- Table structure for table `school_budget`
--

CREATE TABLE `school_budget` (
  `id` int(11) NOT NULL,
  `emis_code` int(11) NOT NULL,
  `total_budget` varchar(255) NOT NULL,
  `total_fee_collected` varchar(255) NOT NULL,
  `donation` varchar(255) DEFAULT NULL,
  `govt_account` varchar(255) DEFAULT NULL,
  `bank_amount` varchar(255) DEFAULT NULL,
  `scout_guide_fund` varchar(255) DEFAULT NULL,
  `other_amount` varchar(255) DEFAULT NULL,
  `expenses` varchar(255) DEFAULT NULL,
  `last_year_shortfall` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `school_budget`
--

INSERT INTO `school_budget` (`id`, `emis_code`, `total_budget`, `total_fee_collected`, `donation`, `govt_account`, `bank_amount`, `scout_guide_fund`, `other_amount`, `expenses`, `last_year_shortfall`) VALUES
(1, 0, '1082000', '5000', '600', '7000', '9000', '1223', '123445', '160000', '0'),
(2, 0, '1082000', '5000', '898', '9089', '89', '89', '87', '87', '5655');

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

--
-- Table structure for table `school_building`
--

CREATE TABLE `school_building` (
  `id` int(11) NOT NULL,
  `building_status` enum('Yes','No') DEFAULT NULL,
  `ownership_type` varchar(50) DEFAULT NULL,
  `rental_payee` varchar(100) DEFAULT NULL,
  `construction_year` int(11) DEFAULT NULL,
  `building_condition` enum('Satisfactory','Need repair','Need Construction') DEFAULT NULL,
  `construction_material` varchar(50) DEFAULT NULL,
  `boundary_wall` enum('YES','NO') DEFAULT NULL,
  `heads_office` int(11) DEFAULT NULL,
  `heads_office_condition` enum('Satisfactory','Need repair','Need Construction') DEFAULT NULL,
  `staff_room` int(11) DEFAULT NULL,
  `staff_room_condition` enum('Satisfactory','Need repair','Need Construction') DEFAULT NULL,
  `clerk_office` int(11) DEFAULT NULL,
  `clerk_office_condition` enum('Satisfactory','Need repair','Need Construction') DEFAULT NULL,
  `class_rooms` int(11) DEFAULT NULL,
  `class_rooms_condition` enum('Satisfactory','Need repair','Need Construction') DEFAULT NULL,
  `hall` int(11) DEFAULT NULL,
  `hall_condition` enum('Satisfactory','Need repair','Need Construction') DEFAULT NULL,
  `labs` int(11) DEFAULT NULL,
  `labs_condition` enum('Satisfactory','Need repair','Need Construction') DEFAULT NULL,
  `library` int(11) DEFAULT NULL,
  `library_condition` enum('Satisfactory','Need repair','Need Construction') DEFAULT NULL,
  `store` int(11) DEFAULT NULL,
  `store_condition` enum('Satisfactory','Need repair','Need Construction') DEFAULT NULL,
  `staff_washrooms` int(11) DEFAULT NULL,
  `student_washrooms` int(11) DEFAULT NULL,
  `residential_rooms` int(11) DEFAULT NULL,
  `residential_rooms_condition` enum('Satisfactory','Need repair','Need Construction') DEFAULT NULL,
  `hostel` int(11) DEFAULT NULL,
  `hostel_condition` enum('Satisfactory','Need repair','Need Construction') DEFAULT NULL,
  `kitchen` int(11) DEFAULT NULL,
  `other_rooms` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `school_building`
--

INSERT INTO `school_building` (`id`, `building_status`, `ownership_type`, `rental_payee`, `construction_year`, `building_condition`, `construction_material`, `boundary_wall`, `heads_office`, `heads_office_condition`, `staff_room`, `staff_room_condition`, `clerk_office`, `clerk_office_condition`, `class_rooms`, `class_rooms_condition`, `hall`, `hall_condition`, `labs`, `labs_condition`, `library`, `library_condition`, `store`, `store_condition`, `staff_washrooms`, `student_washrooms`, `residential_rooms`, `residential_rooms_condition`, `hostel`, `hostel_condition`, `kitchen`, `other_rooms`) VALUES
(1, '', 'Without Rent', 'vvv', 1900, 'Satisfactory', 'Pre Febricated', 'YES', 0, '', 0, '', 0, '', 0, '', 0, '', 0, '', 0, '', 0, '', 0, 0, 0, '', 0, '', 0, 0),
(2, '', 'Without Rent', 'vvv', 1900, 'Satisfactory', 'Pre Febricated', 'YES', 0, '', 0, '', 0, '', 0, '', 0, '', 0, '', 0, '', 0, '', 0, 0, 0, '', 0, '', 0, 0),
(3, '', 'Without Rent', 'vvv', 1900, 'Satisfactory', 'Pre Febricated', 'YES', 0, '', 0, '', 0, '', 0, '', 0, '', 0, '', 0, '', 0, '', 0, 0, 0, '', 0, '', 0, 0);

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

--
-- Table structure for table `school_cate`
--

CREATE TABLE `school_cate` (
  `cate_id` int(10) NOT NULL,
  `school_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `school_cate`
--

INSERT INTO `school_cate` (`cate_id`, `school_type`) VALUES
(1, 'Government'),
(2, 'Semi-Government'),
(3, 'Private');

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

--
-- Table structure for table `school_emis`
--

CREATE TABLE `school_emis` (
  `emis_code` varchar(12) NOT NULL,
  `school_name` varchar(100) NOT NULL,
  `level_id` int(10) NOT NULL,
  `cate_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `school_emis`
--

INSERT INTO `school_emis` (`emis_code`, `school_name`, `level_id`, `cate_id`) VALUES
('11111111111', 'TEST', 1, 1),
('50230210335', 'GMPS CHAPAR DHAR', 1, 1),
('50250321429', 'GGPS DOBA', 2, 1),
('50340311783', 'GBPS GALI', 2, 1),
('50410311414', 'GBPS NALY', 2, 1),
('50430211468', 'G MASJID S GALA LAHUTI', 1, 1),
('50430321186', 'GGPS', 2, 1),
('50430321211', 'GGPS KASS', 2, 1),
('50430411531', 'GBMS DHOKAN', 3, 1),
('50620320264', 'GGPS KHOJALMORA', 2, 1),
('50620320268', 'GGPS NANGAL', 2, 1),
('50620320277', 'GGPS CHEERAN', 2, 1),
('50630320312', 'GGPS KALABAN', 2, 1),
('50640110225', 'GBPS SANTALA', 0, 1),
('50720322079', 'GGPS SARY', 2, 1),
('50720521508', 'GGHS DHING ROON', 4, 1),
('50810111180', 'GBPS KARI JATTAN', 0, 1),
('50810112923', 'GOVT MAKTAB BOYS PRIMARY SCHOOL CHANI', 0, 1),
('50810210900', 'GBPS GAHAI SIADAN', 1, 1),
('50810210928', 'GBPS NAGHAL', 1, 1),
('50810211008', 'GBPS CHEHRAN JUNA', 1, 1),
('50810211261', 'GOVERNMENT BOYS PRIMARY SCHOOL BALERI', 1, 1),
('50810212898', 'GBPS PALOTI', 1, 1),
('50810310904', 'GBPS NAWNI', 2, 1),
('50810310905', 'GBPS CHARKYAN', 2, 1),
('50810310906', 'GBPS MOHAJIR CAMPGULPUR', 2, 1),
('50810310910', 'GBPS DHARA', 2, 1),
('50810310911', 'GBPS CHAK', 2, 1),
('50810310914', 'MSQ ORI', 2, 1),
('50810310916', 'GBPS SAMALA', 2, 1),
('50810310920', 'GBPS MAHOLI', 2, 1),
('50810310924', 'GBPS KHATKHOLI', 2, 1),
('50810310925', 'GBPS GAHI', 2, 1),
('50810310931', 'GBPS BILL', 2, 1),
('50810310932', 'GBPS THROCHI', 2, 1),
('50810310935', 'GBPS GAKHRA', 2, 1),
('50810310939', 'GBPS NAGHAL', 2, 1),
('50810310940', 'GBPS MUHAJIR', 2, 1),
('50810310942', 'GBPS NAROOCH', 2, 1),
('50810310945', 'GBPS SAWELIAN BALA', 2, 1),
('50810310947', 'GBPS KHAWAS', 2, 1),
('50810310948', 'GBPS CHAK', 2, 1),
('50810310950', 'GBMS SCHOOL KOTLI SAWALYA', 3, 1),
('50810310953', 'GBPS KANYAL', 2, 1),
('50810310956', 'GBPS NUMB', 2, 1),
('50810310960', 'GBPS CHAHAWLA', 2, 1),
('50810310962', 'GBPS PATI', 2, 1),
('50810310963', 'GBPS ANDROOT', 2, 1),
('50810311000', 'GBMS DAMAS', 2, 1),
('50810311134', 'GBPS KAIN', 2, 1),
('50810311148', 'GBPS SAMLOON', 2, 1),
('50810311150', 'GBPS PANJAN', 2, 1),
('50810311162', 'GBPS NARA', 2, 1),
('50810311168', 'GBPS MOHRI', 2, 1),
('50810311176', 'GBPS BANDIAN', 2, 1),
('50810311185', 'GBPS NARALA', 2, 1),
('50810311190', 'GBPS KANORA', 2, 1),
('50810311192', 'GBPS DARAN NAR', 2, 1),
('50810311194', 'GBPS SANYAH', 2, 1),
('50810311199', 'GBPS NAJPUR', 2, 1),
('50810311202', 'GBPS CHARHOI', 2, 1),
('50810311219', 'GBPS RATTA', 2, 1),
('50810311255', 'GBPS BARATLA', 2, 1),
('50810311263', 'GBPS GAGRI', 2, 1),
('50810311267', 'GBPS TAIN', 2, 1),
('50810311270', 'GBPS RARATLA', 2, 1),
('50810311273', 'GBPS CHAFLOTI', 2, 1),
('50810311278', 'GBPS KANTHI', 2, 1),
('50810311280', 'GBPS KANI BHAIAN', 2, 1),
('50810311284', 'GBPS BAJWAL NAR', 2, 1),
('50810311289', 'GBPS DARLIAH GOJRAN', 2, 1),
('50810311294', 'GBPS BRALILA BALA', 2, 1),
('50810311301', 'GBPS BARATLA', 2, 1),
('50810311308', 'GBPS PARKAS BARATLA', 2, 1),
('50810311316', 'GBPS NALA', 2, 1),
('50810311340', 'GBPS NATHI NARI', 2, 1),
('50810311353', 'GBPS HATTAN NAAR', 2, 1),
('50810320726', 'GGPS SARI', 2, 1),
('50810320728', 'GGPS BAIN', 2, 1),
('50810320739', 'GGPS GAGRY', 2, 1),
('50810320741', 'GGPS CHOWKI', 2, 1),
('50810320743', 'GGPS GAHI', 2, 1),
('50810320744', 'GGPS KALHOR', 2, 1),
('50810320745', 'GGPS BAL', 2, 1),
('50810320746', 'GGPS DARGOOTI', 2, 1),
('50810320747', 'GGPS MORAGHERAN', 2, 1),
('50810320750', 'GGPS DARGOI', 2, 1),
('50810320753', 'GGPS LOWER', 2, 1),
('50810320754', 'GGPS DAMMAS', 2, 1),
('50810320760', 'GGPS KAS', 2, 1),
('50810320763', 'GGPS KHATKOLI', 2, 1),
('50810320773', 'GGMS CHAK', 2, 1),
('50810320909', 'GGPS FEROOZ', 2, 1),
('50810320910', 'GGPS MUSLIM', 2, 1),
('50810320912', 'GGPS TAHA BARATLA', 2, 1),
('50810320914', 'GGPS DARLIAH GUJRAN', 2, 1),
('50810320916', 'GGPS NARALA', 2, 1),
('50810320918', 'GGPS NARMAH', 2, 1),
('50810320919', 'GGPS BRALA', 2, 1),
('50810320926', 'GGPS SABZ', 2, 1),
('50810320927', 'GGPS NAR', 2, 1),
('50810320930', 'GGPS KHADAL', 2, 1),
('50810320933', 'GGPS SAMLOON NAAR', 2, 1),
('50810320936', 'GGPS GHORA NAAR', 2, 1),
('50810320938', 'GGPS PATHARI', 2, 1),
('50810320943', 'GGPS SAHSHU BARTLA', 2, 1),
('50810320949', 'GGPS BRAH NAAR', 2, 1),
('50810320951', 'GGPS BLERI', 2, 1),
('50810320955', 'GGPS DARLIA GUJRAN', 2, 1),
('50810320981', 'GGPS KALADAB', 2, 1),
('50810320982', 'GGPS BAJWAL', 2, 1),
('50810320984', 'GGPS CAHFLOTI', 2, 1),
('50810320986', 'GGPS DARAN NAR', 2, 1),
('50810320997', 'GGPS NANOOR BARATLA', 2, 1),
('50810321086', 'GGPS BANDIYAN NAAR', 2, 1),
('50810321100', 'GGPS', 2, 1),
('50810322891', 'GGPS CHANI BALIAH', 2, 1),
('50810410961', 'GBMS DARKOOTI CROSS', 3, 1),
('50810411054', 'GBMS GULPUR', 3, 1),
('50810411133', 'GBMS', 3, 1),
('50810411136', 'GBMS PANJAN CHAROI', 3, 1),
('50810411153', 'GBMS DAGGAR', 3, 1),
('50810411332', 'GBMS NAAR', 3, 1),
('50810420757', 'GGMS KHANKA KOTEHRA', 3, 1),
('50810420766', 'GGMS SAMALA', 3, 1),
('50810420767', 'GGMS DHAMAL', 3, 1),
('50810420770', 'GGMS THROCHI', 3, 1),
('50810420771', 'GGMS DARKOOTI CROSS', 3, 1),
('50810420775', 'GGMS BIALIYAN', 3, 1),
('50810420776', 'GGMS NAGHAL', 3, 1),
('50810420779', 'GGMS DHAMAL', 3, 1),
('50810420813', 'GGMS CHANGPUR KHAWAS', 3, 1),
('50810420965', 'GGMS NARA KOT', 3, 1),
('50810420969', 'GGMS BRATLA', 3, 1),
('50810420973', 'GGMS KHAN ABYAN', 3, 1),
('50810510921', 'CHOHDARY AFZAL ILAHI GBHS CHOONA', 4, 1),
('50810511018', 'GBHS KHANKA KOTEHRA', 4, 1),
('50810511033', 'GBHS CHANGPUR KHAWAS', 4, 1),
('50810511218', 'GBHS KAJLANI', 4, 1),
('50810511229', 'GBHS NARA KOT', 4, 1),
('50810511238', 'GBHS PANJAN CHARHOI', 4, 1),
('50810511262', 'GBHS GOLA', 4, 1),
('50810511276', 'GBHS PLAHAL KALAN', 4, 1),
('50810511322', 'GBHS BARATLA', 4, 1),
('50810520922', 'GGHS KAJLANI', 4, 1),
('50810520957', 'GGHS SANYAH', 4, 1),
('50810520976', 'GGHS PANJAN CHARHOI', 4, 1),
('50810520978', 'GGHS PLAHAL RAJGAN', 4, 1),
('50810520989', 'GGHS GOLA PANJAN', 4, 1),
('50810520991', 'GGHS SAAH', 4, 1),
('50810521069', 'GGHS DARLIN GUJRAN', 4, 1),
('50810521079', 'GGHS NAR MATYAL', 4, 1),
('50810521093', 'GGHS NAAR', 4, 1),
('50810620735', 'GGHSS BIL BRAHMNAN', 5, 1),
('50810620737', 'PROFESSOR MUHAMMAD SHABEER GGHSS CHAHAWLA', 5, 1),
('50810620740', 'GGHSS JOONA', 5, 1),
('50810620829', 'GGHSS GULPUR', 5, 1),
('50810622862', 'GGHSS BAL BRAHMNAN', 5, 1),
('50810820998', 'GGHS KOTLI SOHALNAH', 4, 1),
('50820111207', 'MAKTAB SCHOOL SAYYDAN', 0, 1),
('50820211254', 'GOVT MASJID PS TARNOT', 1, 1),
('50820311195', 'GBPS KALADAB', 2, 1),
('50820311200', 'GBPS AMBAN', 2, 1),
('50820311206', 'GBPS MITHI', 2, 1),
('50820311213', 'GBPS SHEE', 2, 1),
('50820311224', 'GBPS GLATER', 2, 1),
('50820311227', 'GBPS SANDHALI', 2, 1),
('50820311239', 'GBPS SHAAH', 2, 1),
('50820311243', 'GBPS SIMBALGAH', 2, 1),
('50820311248', 'GBPS BILLY', 2, 1),
('50820311250', 'GBPS KARMAL', 2, 1),
('50820311253', 'GBPS KRARI', 2, 1),
('50820311257', 'GBPS HALL', 2, 1),
('50820320923', 'GGPS SAMLOON', 2, 1),
('50820320944', 'GGPS KASONDA', 2, 1),
('50820320946', 'GGPS PRAYANI', 2, 1),
('50820320953', 'GGPS KANORA', 2, 1),
('50820320960', 'GGPS BASRAAL', 2, 1),
('50820320963', 'GGPS GOWAND', 2, 1),
('50820320966', 'GGPS KRARI', 2, 1),
('50820320970', 'GGPS MASKEEN', 2, 1),
('50820320972', 'GGPS TARNOT', 2, 1),
('50820320975', 'GGPS AMBAN', 2, 1),
('50820410840', 'GBMS GULATER', 3, 1),
('50820411122', 'GBMS NARMAH', 3, 1),
('50820411167', 'GBMS GOWAND', 3, 1),
('50820411186', 'GBMS NALLA ZARIN', 3, 1),
('50820411187', 'GBMS PLAHAL RAJGAN KOTLI', 3, 1),
('50820411252', 'GBMS JALHARI', 3, 1),
('50820411274', 'GBMS GHARI', 3, 1),
('50820420994', 'GGMS CHOWK SAHIBAN', 3, 1),
('50820421002', 'GGMS JARAHI', 3, 1),
('50820511266', 'GBHS CHOWK SHIBAN', 4, 1),
('50820511281', 'GBHS DULLYAH JATTAN', 4, 1),
('50820520845', 'GGHS GOI', 4, 1),
('50820520920', 'GGHS DULLYAH JATTAN', 4, 1),
('50820520928', 'GGHS CHOWK SHIBAN', 4, 1),
('50820521000', 'GGHS PARAHI AMBAN', 4, 1),
('50820611178', 'GBHSS PARAHI AMBAN', 5, 1),
('50820611286', 'HAJI MUHAMMAD SADIQ GBHS RAJDHANI KOTLI', 5, 1),
('50820620935', 'GGHSS RAJDHANI', 5, 1),
('50830110851', 'GBPS DIHRIAN MAJHAN', 0, 1),
('50830110857', 'PS AKI KHAN MAHIL', 0, 1),
('50830110870', 'GBPS MAHAL BALA MANDHATER', 0, 1),
('50830110887', 'MAKTAB BOYS SCHOOL NIYARA MATHRANI', 0, 1),
('50830210821', 'GBPS PHAILI', 1, 1),
('50830210829', 'GMPS KAREELA BALA', 1, 1),
('50830210832', 'GOVT BOYS PRIMARY SCHOOL NAWON BHOAIL', 1, 1),
('50830210834', 'GPS NARGIL', 1, 1),
('50830210837', 'GPS MAJHAN COLONY', 1, 1),
('50830210838', 'GBMPS GHEKKI MAJHAN', 1, 1),
('50830210839', 'GB MASJID SCHOOL JAIR MAHAL`', 1, 1),
('50830210842', 'GPS BANDI BAJRANA', 1, 1),
('50830210844', 'GOVT MASJID SCHOOL POTHI GALI', 1, 1),
('50830210861', 'GBPS DHAROTI KHAS', 1, 1),
('50830210867', 'GOVT MASJID PRAMARY SCHOOL RINGLI NO 1', 1, 1),
('50830210869', 'GBPS NARAN TRAR', 1, 1),
('50830210873', 'PS BOYIL COLONY BOYS', 1, 1),
('50830210875', 'GBPS RINJALY MATHRANI NO2', 1, 1),
('50830210878', 'GPS JAMALOUT', 1, 1),
('50830210881', 'GMS BATLA BARE DARA', 1, 1),
('50830210884', 'GB MASJID SCHOOL GAHI TARKUNDI', 1, 1),
('50830210889', 'GOVT MASJID BARALI GALA MATHRANI', 1, 1),
('50830210979', 'GMPS KANYAT DATOTE', 1, 1),
('50830210983', 'GBPS PANYAS PALANY', 1, 1),
('50830210992', 'GBPS NARDABSI ZAREEN', 1, 1),
('50830210999', 'GBPS KHANDHAR BALA', 1, 1),
('50830211005', 'GBPS BALAKOT', 2, 1),
('50830211009', 'GOVT  MASJID PRIMARY SCHOOL DANGALI DABSI', 1, 1),
('50830211012', 'GMPS PTOCHI', 1, 1),
('50830211023', 'GBPS KHRAN', 1, 1),
('50830211027', 'GBPS NARDABSI', 2, 1),
('50830211030', 'GBPS NAKHNAL', 1, 1),
('50830211140', 'GOVT MASJID PRIMARY SCHOOL', 1, 1),
('50830211149', 'GOVT MASJID PRIMARY SCHOOL NAIL BHIL', 1, 1),
('50830211201', 'PANAKHA COLONY', 1, 1),
('50830211210', 'GBPS DACHAN SALOON', 2, 1),
('50830211217', 'GOVT BOYS MASJID SCHOOL SANDHARA', 1, 1),
('50830211235', 'GBPS JHALAKA', 1, 1),
('50830220833', 'GPS SHAH GAJJAN', 1, 1),
('50830310822', 'GBPS KHANDHAR', 2, 1),
('50830310823', 'GBPS RANGALA GALI', 2, 1),
('50830310827', 'GBPS NAIK SAIF ALI SHAHEED KHANDAR', 2, 1),
('50830310830', 'GBPS KARELA', 2, 1),
('50830310841', 'GBPS POTHI', 2, 1),
('50830310855', 'GGPS MOHRHA', 2, 1),
('50830310863', 'GBPS SERI', 2, 1),
('50830310865', 'GBPS THANDI BAN', 2, 1),
('50830310868', 'GBPS NARA DHURTI', 2, 1),
('50830310871', 'GBPS NARMALKAN', 2, 1),
('50830310872', 'GBPS SAKRALI', 2, 1),
('50830310876', 'GBPS SALOOR', 2, 1),
('50830310880', 'GBPS THALA', 2, 1),
('50830310882', 'GBPS DHUMPUR', 2, 1),
('50830310883', 'GBPS NAWAN', 2, 1),
('50830310896', 'GBPS MOHRA GHIMB BALA', 2, 1),
('50830310903', 'GBPS BANALA', 2, 1),
('50830310973', 'GBPS BHAIN', 2, 1),
('50830310976', 'GBPS SUBEN', 2, 1),
('50830310980', 'GBPS DARARY', 2, 1),
('50830310997', 'GBPS CHUTA', 2, 1),
('50830311017', 'GBPS CHAKRALI', 2, 1),
('50830311034', 'GBPS SANDHWAL', 2, 1),
('50830311037', 'GGPS DOTHELA', 2, 1),
('50830311154', 'GBPS LATARY', 2, 1),
('50830311160', 'GBPS MEHRA', 2, 1),
('50830311223', 'GBPS BHIL JANDROT', 2, 1),
('50830311226', 'GBPS', 2, 1),
('50830311244', 'GBPS TANGAL', 2, 1),
('50830320638', 'GGPS NALA', 2, 1),
('50830320640', 'GGPS KENI', 2, 1),
('50830320667', 'GGPS SWATI', 2, 1),
('50830320669', 'GGPS BHATA', 2, 1),
('50830320674', 'GGPS JAIR', 2, 1),
('50830320676', 'GGPS MODEL', 2, 1),
('50830320677', 'GGPS ANDAR', 2, 1),
('50830320679', 'GGPS KAREELA', 2, 1),
('50830320681', 'GGPS KARILA', 2, 1),
('50830320682', 'GGPS BANDI', 2, 1),
('50830320695', 'GGPS JAIR', 2, 1),
('50830320698', 'GGPS NARA', 2, 1),
('50830320703', 'GGPS MORA', 2, 1),
('50830320705', 'GGPS BASALA BOHAIL', 2, 1),
('50830320707', 'GGPS THUBPUR', 2, 1),
('50830320708', 'GGPS MOHRHA', 2, 1),
('50830320709', 'GGPS BANALA', 2, 1),
('50830320710', 'GGPS TURKUNDI', 2, 1),
('50830320711', 'GGPS NAAR', 2, 1),
('50830320713', 'GGPS HATTLI', 2, 1),
('50830320714', 'GGPS GLETHAR', 2, 1),
('50830320717', 'GGPS BARRI', 2, 1),
('50830320718', 'GBPS KALYARI', 2, 1),
('50830320723', 'GGPS SERI', 2, 1),
('50830320727', 'GGPS BASALA', 2, 1),
('50830320783', 'GGPS KATHILI', 2, 1),
('50830320790', 'GGPS PUNJNI', 2, 1),
('50830320793', 'GGPS TANGAL', 2, 1),
('50830320794', 'GGPS THARU', 2, 1),
('50830320801', 'GGPS OLI', 2, 1),
('50830320802', 'GGPS BAKNARA', 2, 1),
('50830320803', 'GGPS KHANDHAR', 2, 1),
('50830320805', 'GGPS THANGRY', 2, 1),
('50830320835', 'GGPS BALAKOT', 2, 1),
('50830320838', 'GGPS NAR', 2, 1),
('50830320841', 'GGPS CHAKRALI', 2, 1),
('50830320924', 'GGPS JAMEERY JANDROOT', 2, 1),
('50830320932', 'GGPS CHASHTIA ABAD', 2, 1),
('50830320980', 'GGPS SALOON', 2, 1),
('50830320996', 'GGPS SINDARAH', 2, 1),
('50830321001', 'GGPS HAJYA', 2, 1),
('50830321003', 'GGPS NAVON', 2, 1),
('50830321011', 'GGPS MERA', 2, 1),
('50830321015', 'GGPS DUSI', 2, 1),
('50830321021', 'GGPS PALLAI', 2, 1),
('50830321025', 'GGPS PANAKHA', 2, 1),
('50830322940', 'GGPS KHORH', 2, 1),
('50830410831', 'GBMS SAMTI', 3, 1),
('50830410843', 'GBMS KHANDALAR', 3, 1),
('50830410845', 'GBMS NAJAL KHANDHAR', 3, 1),
('50830410846', 'GBMS SCHOOL KARELA MAJHAN', 3, 1),
('50830410848', 'GBMS MAJHAN', 3, 1),
('50830410859', 'GBMS MOHRA CHINAB', 3, 1),
('50830410862', 'GBMS MOHRA GHIMB', 3, 1),
('50830410982', 'GBMS BOHAIL', 3, 1),
('50830410987', 'GBMS DHARA BOGLIAN', 3, 1),
('50830411002', 'GBMS KALAPANI ANDROOTH', 3, 1),
('50830411024', 'GBMS DATOTE', 3, 1),
('50830411031', 'GBMS NAKYAL GHARBI', 3, 1),
('50830411035', 'GBMS BALAKOT', 3, 1),
('50830411042', 'GBMS LANJOT', 3, 1),
('50830412936', 'GBMS CHACHATER', 3, 1),
('50830420678', 'GGMS NURGAL', 3, 1),
('50830420683', 'GGMS KARELA', 3, 1),
('50830420702', 'GGMS MOHRHA KAMBH', 3, 1),
('50830420730', 'GGMS MANDHATER', 3, 1),
('50830420786', 'GGMS LANJOT', 3, 1),
('50830420788', 'GGMS DABSI', 3, 1),
('50830420806', 'GGMS HILLAN DABSI', 3, 1),
('50830420807', 'GGMS HATLLI ZAREEN', 3, 1),
('50830420825', 'GGMS NAKYAL GHARBI', 3, 1),
('50830420839', 'GGMS SALOON', 3, 1),
('50830420846', 'GGMS NAKHNAL', 3, 1),
('50830420847', 'GGMS BAGLIAN', 3, 1),
('50830510877', 'GBHS TARKUNDI', 4, 1),
('50830510888', 'GBHS MATHRANI', 4, 1),
('50830510977', 'GBHS DABSI', 4, 1),
('50830510984', 'GBHS DARI DABSI', 4, 1),
('50830511015', 'GBHS OLI', 4, 1),
('50830511061', 'GBHS JANDROT', 4, 1),
('50830511099', 'GBHS HUTTLI', 4, 1),
('50830511105', 'GBHS FATEHPURKHANDHAR', 4, 1),
('50830520644', 'GGHS KHANDHAR', 4, 1),
('50830520715', 'GGHS KALAR GALA TARKUNDI', 4, 1),
('50830520719', 'GGHS SATHRANI', 4, 1),
('50830520720', 'GGHS DHRUTI MOHRA', 4, 1),
('50830520722', 'GGHS NADARKOT', 4, 1),
('50830520780', 'GGHS NAKYAL', 4, 1),
('50830520785', 'GGHS DATOTA', 4, 1),
('50830520797', 'GGHS DREARY', 4, 1),
('50830520942', 'GGHS JANDROT', 4, 1),
('50830610874', 'GBHSS ANDERLANAR', 5, 1),
('50830610885', 'GBHSS MANDEHTAR', 5, 1),
('50830611174', 'GBHSS SALOON', 5, 1),
('50840110894', 'GBPS ZEERI DHARA', 0, 1),
('50840110899', 'GBPS THATHI DHANNA', 0, 1),
('50840110922', 'GBPS HARIPUR SOHANA', 0, 1),
('50840111155', 'GBPS GUJIARY', 0, 1),
('50840111164', 'GBPS BALYAL', 0, 1),
('50840111251', 'GBPS PEHLAN KHAJOORLA', 0, 1),
('50840111264', 'GBPS THILL', 0, 1),
('50840111277', 'GBPS  SUKYAN BAAIEN', 0, 1),
('50840120939', 'GGPS PANGALIANA', 0, 1),
('50840210901', 'GBPS MORHOTA', 1, 1),
('50840210909', 'GBMS HAIL MMEHNI', 1, 1),
('50840210917', 'GMPS THANDER KANAS', 1, 1),
('50840210918', 'GMPS NIDDI SOHANA', 1, 1),
('50840210946', 'GMPS  GURAH BALIAN', 1, 1),
('50840210949', 'GBPS BALA DHARA', 1, 1),
('50840211139', 'GBPS DHERI NAON', 1, 1),
('50840211144', 'GBPS MARYARA', 1, 1),
('50840211147', 'G MASJID SCHOOL SEHPUR', 1, 1),
('50840211151', 'GBPS KHAGROOT', 1, 1),
('50840211158', 'GBPS CHAKLI', 1, 1),
('50840211172', 'GBPS  KHORE SROOLY', 1, 1),
('50840211173', 'GBPS BROOTH', 1, 1),
('50840211188', 'GBPS KHOER GRAN', 1, 1),
('50840211220', 'GBPS GANGAL', 1, 1),
('50840211230', 'GBPS BANGALIAN', 1, 1),
('50840211241', 'GBPS KHORE CHEER GALLA', 1, 1),
('50840211297', 'GPS KHANPUR', 1, 1),
('50840211362', 'GPS MAHAL PITHANAR', 1, 1),
('50840211364', 'GBPS PAILAN', 1, 1),
('50840211368', 'BGHPSS', 1, 1),
('50840211378', 'MPSR', 1, 1),
('50840211384', 'GBPSS', 1, 1),
('50840220952', 'GGMS SERI', 1, 1),
('50840220958', 'GGPS PAILAN SAIDPUR', 1, 1),
('50840310908', 'GBPS KHAD', 2, 1),
('50840310923', 'GBPS BADHIAL', 2, 1),
('50840310933', 'GBPS HATTI', 2, 1),
('50840310938', 'GGPS TANYOUT', 2, 1),
('50840310951', 'GBPS BHERA', 2, 1),
('50840311124', 'GGPS BHIAL', 2, 1),
('50840311126', 'GBPS NAQIB', 2, 1),
('50840311128', 'GBPS BATTAL', 2, 1),
('50840311129', 'GBPS PERA', 2, 1),
('50840311131', 'GBPS DOMANDA', 2, 1),
('50840311135', 'GBPS HILL', 2, 1),
('50840311138', 'GBPS MODEL MANJWAL', 2, 1),
('50840311142', 'GBPS THILL', 2, 1),
('50840311152', 'GBPS SUMERYALI', 2, 1),
('50840311157', 'GBPS FATEH', 2, 1),
('50840311159', 'GBPS GHUMBI', 2, 1),
('50840311161', 'GBPS SAMLAHAR', 2, 1),
('50840311165', 'GBPS MIAN', 2, 1),
('50840311169', 'GBPS DOHK', 2, 1),
('50840311170', 'GBPS HOOD', 2, 1),
('50840311175', 'GBPS BATTAL', 2, 1),
('50840311177', 'GBPS HILLAN', 2, 1),
('50840311181', 'GBPS KHUND', 2, 1),
('50840311191', 'GBPS ROSHAN', 2, 1),
('50840311197', 'GBPS RUKAN', 2, 1),
('50840311204', 'GBPS MAHAJOR', 2, 1),
('50840311205', 'GBPS KATASERI', 2, 1),
('50840311208', 'GGPS DHARA', 2, 1),
('50840311211', 'GBPS DUMAN', 2, 1),
('50840311215', 'GBPS CHIRRI', 2, 1),
('50840311216', 'GBPS SAMLAR', 2, 1),
('50840311225', 'GBPS AMRAL', 2, 1),
('50840311232', 'GBPS KACHARBARI', 2, 1),
('50840311233', 'GBPS GHORA', 2, 1),
('50840311246', 'GBPS CHAKAINDA', 2, 1),
('50840311258', 'GBPS SALUT', 2, 1),
('50840311260', 'GBPS DARKOOTI', 2, 1),
('50840311268', 'GBPS PALANA', 2, 1),
('50840311272', 'GBPS KOT', 2, 1),
('50840311291', 'GBPS CHATRO', 2, 1),
('50840311300', 'GBPS KORA', 2, 1),
('50840311303', 'GBPS GANDPALI', 2, 1),
('50840311306', 'GBPS KAS', 2, 1),
('50840311313', 'GBPS KAS', 2, 1),
('50840311330', 'GBPS DHARYA', 2, 1),
('50840311338', 'GBPS JOGALLIAN', 2, 1),
('50840311344', 'GBPS GUJARMORA', 2, 1),
('50840311358', 'GBPS CHOWKI', 2, 1),
('50840311372', 'GBPS', 2, 1),
('50840320725', 'GGPS GHORA', 2, 1),
('50840320738', 'GGPS ZEREE', 2, 1),
('50840320769', 'GGPS PUTIAN', 2, 1),
('50840320772', 'GGMS BHERHA', 2, 1),
('50840320774', 'GGPS HARIPUR', 2, 1),
('50840320777', 'GGPS MITHI', 2, 1),
('50840320894', 'GGPS DOMANDA', 2, 1),
('50840320895', 'GGPS MAJHER', 2, 1),
('50840320897', 'GGPS', 2, 1),
('50840320898', 'GGPS MAJWAL', 2, 1),
('50840320899', 'GGPS GAIEN', 2, 1),
('50840320900', 'GGPS PHAYAM', 2, 1),
('50840320901', 'GGPS BAHIL', 2, 1),
('50840320903', 'GGPS KARJAHI', 2, 1),
('50840320904', 'GGPS SEHOOR', 2, 1),
('50840320905', 'GGPS BALAI SAMLAHAR', 2, 1),
('50840320907', 'GGPS FATEH PUR DEHARI', 2, 1),
('50840320908', 'GGPS DHARA', 2, 1),
('50840320911', 'GGPS SAIDPUR', 2, 1),
('50840320915', 'GGPS GHORA', 2, 1),
('50840320917', 'GGPS LANGER', 2, 1),
('50840320925', 'GGPS THANDI', 2, 1),
('50840320929', 'GGPS KHORA', 2, 1),
('50840320931', 'GGPS RANTHA', 2, 1),
('50840320934', 'GGPS BROOTH', 2, 1),
('50840320937', 'GGPS RUKAN', 2, 1),
('50840320947', 'GGPS JAGHALPAL', 2, 1),
('50840320948', 'GGPS GURRA', 2, 1),
('50840320949', 'GGPS PITHA', 2, 1),
('50840320950', 'GGPS KOLA', 2, 1),
('50840320954', 'GGPS BANDLI', 2, 1),
('50840320956', 'GGPS GHAIR', 2, 1),
('50840320959', 'GGPS KHORE', 2, 1),
('50840320961', 'GGPS GALLA', 2, 1),
('50840320962', 'GGPS KASS', 2, 1),
('50840320964', 'GGMS KOTLA', 2, 1),
('50840320967', 'GGPS CHATTER', 2, 1),
('50840320968', 'GGPS KUND', 2, 1),
('50840320971', 'GGPS MERA', 2, 1),
('50840320974', 'GGPS THANDI', 2, 1),
('50840320983', 'GGPS CHIRE', 2, 1),
('50840320985', 'GGPS THILL', 2, 1),
('50840320987', 'GGPS WASTI BANDLY', 2, 1),
('50840320990', 'GGPS BANSA', 2, 1),
('50840320992', 'GGPS RAITLA', 2, 1),
('50840321005', 'GGPS JATOOT BAHDAR', 2, 1),
('50840321016', 'GGPS ROPARI', 2, 1),
('50840321017', 'GGPS KOT', 2, 1),
('50840321020', 'GGPS', 2, 1),
('50840321023', 'GGPS KHAD', 2, 1),
('50840321049', 'GGPS GURRAH BALYAL', 2, 1),
('50840321054', 'GGPS PAHALNI', 2, 1),
('50840410943', 'GBMS SOHANA', 3, 1),
('50840411121', 'GBMS PLANA', 3, 1),
('50840411125', 'GBMS KARJAI', 3, 1),
('50840411141', 'GBMS KUNDAPAN', 3, 1),
('50840411145', 'GBMS BRAHI', 3, 1),
('50840411156', 'GBMS', 3, 1),
('50840411163', 'GBMS', 3, 1),
('50840411196', 'GBMS DHERI SAHIBZADAIN', 3, 1),
('50840411228', 'GBMS SAMLAR', 3, 1),
('50840411234', 'GBMS KUND PATHANAN', 3, 1),
('50840411237', 'GBMS KOTLA', 3, 1),
('50840411240', 'GBMS KHAJOORIA', 3, 1),
('50840411245', 'GBMS KHAD BROHAMMNAN', 3, 1),
('50840411259', 'GBMS PITHA NAR', 3, 1),
('50840411287', 'GBMS BATTAL BRAHI', 3, 1),
('50840412953', 'GBMS PAPAN', 3, 1),
('50840420732', 'GGMS RAJDANI SOHANA', 3, 1),
('50840420752', 'GGMS BADHYAL DHANNA', 3, 1),
('50840420902', 'GGMS MANJWAL', 3, 1),
('50840420913', 'GGPS BINDIAN', 2, 1),
('50840420921', 'GGMS KHAJOORLA', 3, 1),
('50840420940', 'GGMS BATTLE', 3, 1),
('50840420945', 'GGMS KHORE CHEER', 3, 1),
('50840420999', 'GGMS KHANPUR', 3, 1),
('50840421006', 'GGMS ROSHAN ABAD', 3, 1),
('50840421010', 'GGMS CHOWKI KAHOTA', 3, 1),
('50840421013', 'GGMS BHROIN BNDLI', 3, 1),
('50840421014', 'GGMS SAMLAHAR', 3, 1),
('50840510952', 'GBHS KOHMAR', 4, 1),
('50840510957', 'GBHS DHANNA', 4, 1),
('50840510964', 'GBHS NADDI SOHANA', 4, 1),
('50840511127', 'GBHS HAJI ALAFDEEN', 4, 1),
('50840511132', 'GBHS INDARALA KATHERA', 4, 1),
('50840511137', 'GGHS GAMBI BERA', 4, 1),
('50840511146', 'GBHS RAJDHANI SOHNA', 4, 1),
('50840511182', 'GBHS BHIAL', 4, 1),
('50840511222', 'GBHS JAVID IQBAL KHOOR PACHALA', 4, 1),
('50840511247', 'GBHS BANDLI', 4, 1),
('50840511249', 'GBHS GHAIN', 4, 1),
('50840511256', 'GBHS SAIDPUR', 4, 1),
('50840520811', 'GGHS NADI SOHNA', 4, 1),
('50840520977', 'GGHS GHAIN', 4, 1),
('50840520993', 'GGHS BROOT GALA', 4, 1),
('50840521019', 'GGHS BANDLI', 4, 1),
('50840521026', 'GGHS KHUIRATTA', 4, 1),
('50840611171', 'GBHSS', 5, 1),
('50840611184', 'GGHSS ANDERALA KOTERA', 5, 1),
('50840620761', 'GGHSS DHANNA', 5, 1),
('50850110930', 'MAKTAB PRIMARY SCHOOL NEELI KHAD', 0, 1),
('50850110986', 'GBPS SHAMALI GARHAD', 0, 1),
('50850110993', 'GOVT MAKTAB PRIMARY SCHOOL PARARION', 0, 1),
('50850111004', 'GPS THATTI JANJORA', 0, 1),
('50850111014', 'GBPS MOHAR', 0, 1),
('50850111019', 'GMS PRATAN', 0, 1),
('50850111025', 'GBPS  GORA GOI', 0, 1),
('50850111041', 'GOVERNMENT PRIMARY SCHOOL RAIGAN SHARIF', 0, 1),
('50850111053', 'GMPS GALI JANJORA', 0, 1),
('50850111117', 'GPS  SOUNCHIL', 0, 1),
('50850112930', 'GBPS PUNJNOTA KOTHIAN', 0, 1),
('50850210439', 'BPS BAMKOT', 1, 1),
('50850210913', 'GPS DHERA NALA', 1, 1),
('50850210926', 'GOVT MASJID PRIMARY SCHOOL AGHAR BERMOUCH', 1, 1),
('50850210927', 'GPS BANI SARHOTA', 1, 1),
('50850210965', 'GOVT PRIMARY SCHOOL SAMERRY BAGAH', 1, 1),
('50850210970', 'GOVT PRIMARY SCHOOL ATRIAN NARABGAH', 1, 1),
('50850210971', 'GOVT MASJID SCHOOL', 1, 1),
('50850210978', 'GBPS BANDU MAKKA', 1, 1),
('50850210988', 'GBPS CHATLRARIAN', 1, 1),
('50850210991', 'GBPS AKALI MANJYARA', 1, 1),
('50850210998', 'GBMS NANDA NARIAN', 1, 1),
('50850211006', 'GBPS NADHERI', 1, 1),
('50850211021', 'GOVT MASJID PRIMARY SCHOOL SEHNI', 1, 1),
('50850211040', 'GPS HILL DANDLI', 1, 1),
('50850211057', 'GBMS DHASHAL', 1, 1),
('50850211062', 'GMPS KARARI', 1, 1),
('50850211088', 'GPS NAILLAN QAMROOTI', 1, 1),
('50850211093', 'GPS DADI QAMROOTI', 1, 1),
('50850211097', 'GBPS RAYAM KOLONY', 1, 1),
('50850212925', 'GBPS DHANGROT', 1, 1),
('50850212926', 'GOVT PRIMARY SCHOOL AGHAR COLONY', 1, 1),
('50850212960', 'GBPS KAMANGOLA', 1, 1),
('50850220684', 'GGMS NAIK SAIF ALI SHAHEED', 1, 1),
('50850220712', 'GGPS CHAKNOOR', 2, 1),
('50850221004', 'GGHS KARA', 1, 1),
('50850310849', 'GBPS NAIN', 2, 1),
('50850310850', 'GBPS CHANI', 2, 1),
('50850310852', 'GBPS KOTLA', 2, 1),
('50850310858', 'GBPS CHAKNOR', 2, 1),
('50850310866', 'GBPS SHAH', 2, 1),
('50850310879', 'GBPS NAIN', 2, 1),
('50850310886', 'GBPS KATYARI', 2, 1),
('50850310890', 'GBPS WAHI', 2, 1),
('50850310891', 'GBPS KATANI', 2, 1),
('50850310898', 'GBPS KAINI', 2, 1),
('50850310907', 'GBPS MALL', 2, 1),
('50850310912', 'GBPS NAVEL', 2, 1),
('50850310915', 'GBPS DAHRA', 2, 1),
('50850310919', 'GBPS DRAIRH', 2, 1),
('50850310934', 'GBPS LAAT', 2, 1),
('50850310936', 'GBPS DUHSSI', 2, 1),
('50850310937', 'GBPS KARNOTI', 2, 1),
('50850310941', 'GBPS KORIEN', 2, 1),
('50850310944', 'GBPS SEGRI', 2, 1),
('50850310954', 'GBPS', 2, 1),
('50850310958', 'GBPS LASARWA KOTLY', 2, 1),
('50850310966', 'GBPS PURL', 2, 1),
('50850310967', 'GBPS TATTA', 2, 1),
('50850310968', 'GBPS PANAKHA', 2, 1),
('50850310969', 'GBPS AHLE HADIS', 2, 1),
('50850310974', 'GBPS BERMOUCH', 2, 1),
('50850310975', 'GBPS GOI', 2, 1),
('50850310981', 'GBPS DHORYAAN', 2, 1),
('50850310985', 'GBPS HARI', 2, 1),
('50850310990', 'GBPS KAHTAR', 2, 1),
('50850310995', 'GBPS DANNA', 2, 1),
('50850310996', 'GBPS HARIDHARA', 2, 1),
('50850311001', 'GBPS KAROTAN', 2, 1),
('50850311003', 'GBPS RAD', 2, 1),
('50850311007', 'GBPS JANUBI', 2, 1),
('50850311011', 'GBPS BATALI', 2, 1),
('50850311022', 'GGPS SANGEEL', 2, 1),
('50850311026', 'GBPS MAJUMA', 2, 1),
('50850311028', 'GBPS MANDYARI', 2, 1),
('50850311029', 'GBPS CHARNARI', 2, 1),
('50850311038', 'GBPS DARAMNA', 2, 1),
('50850311043', 'GBPS JHOR', 2, 1),
('50850311044', 'GBPS BINDI', 2, 1),
('50850311045', 'GBPS DEWAT BHANDYAN', 2, 1),
('50850311046', 'GBPS MENTHLY', 2, 1),
('50850311047', 'GBPS LASAN GOWAN', 2, 1),
('50850311050', 'GBPS GIRYALA', 2, 1),
('50850311051', 'GBPS KHUDIAN', 2, 1),
('50850311055', 'GBPS GUMNI MALKAN', 2, 1),
('50850311056', 'GBPS SAGYAM', 2, 1),
('50850311059', 'GBPS GAZAN PKAKWARI', 2, 1),
('50850311060', 'GBPS NUMB DANNA', 2, 1),
('50850311064', 'GBPS SAWAR', 2, 1),
('50850311065', 'GBPS FAFEEL', 2, 1),
('50850311066', 'GBPS THATHI', 2, 1),
('50850311068', 'GBPS CHOWKI', 2, 1),
('50850311069', 'GBPS HILLAN', 2, 1),
('50850311070', 'GBPS NEHANI', 2, 1),
('50850311072', 'GBPS BAIN', 2, 1),
('50850311073', 'GBPS KAS', 2, 1),
('50850311075', 'GBPS SIATH', 2, 1),
('50850311076', 'GBPS CHAMBER COLONY', 2, 1),
('50850311077', 'GBPS NEHAN', 2, 1),
('50850311079', 'GBPS NAGAI', 2, 1),
('50850311080', 'GBPS NOORPUR', 2, 1),
('50850311082', 'GBPS CHAK', 2, 1),
('50850311086', 'GBPS CHOHARA', 2, 1),
('50850311087', 'GBPS DHERI SAYEDAN', 2, 1),
('50850311091', 'GBPS SARSAWA', 2, 1),
('50850311092', 'GBPS KUND', 2, 1),
('50850311095', 'GBPS FAIZABAD', 2, 1),
('50850311096', 'GGPS NAIL', 2, 1),
('50850311098', 'GBPS KAS', 2, 1),
('50850311100', 'GBPS NAIL SAJOONI', 2, 1),
('50850311101', 'GBPS NUMB', 2, 1),
('50850311102', 'GBPS NAIL SAJOONI', 2, 1),
('50850311109', 'GBPS CHUNA', 2, 1),
('50850311111', 'GGPS SAIDPUR', 2, 1),
('50850311112', 'GBPS CHAPEER', 2, 1),
('50850311114', 'GBPS CHATTER', 2, 1),
('50850311115', 'GBPS BANY', 2, 1),
('50850311116', 'GBPS KARTOT', 2, 1),
('50850311119', 'GBPS GAWAL', 2, 1),
('50850311447', 'GBPS BHURKA', 2, 1),
('50850312892', 'GBPS DHANAH', 2, 1),
('50850312909', 'GBPS KOTLIAN', 2, 1),
('50850312914', 'GBPS TALAIR', 2, 1),
('50850312916', 'GBPS PANG PIRAN', 2, 1),
('50850312919', 'GBPS CHALYAR PANAG', 2, 1),
('50850312920', 'GBPS GRANDA KOHIAN', 2, 1),
('50850312927', 'GBPS DANGHROT', 2, 1),
('50850312929', 'GBMS NALA', 2, 1),
('50850312946', 'GBPS HATHLA', 2, 1),
('50850312967', 'GBPS BAUNER', 2, 1),
('50850312983', 'GGPS SARNAZ', 2, 1),
('50850312984', 'PMS BALOTI', 2, 1),
('50850312995', 'GBPS DHANNA', 2, 1),
('50850312999', 'GBPS NAKKA', 2, 1),
('50850313001', 'GBPS HATHLA', 2, 1),
('50850313004', 'GBPS DHAK', 2, 1),
('50850313009', 'GBPS GALI', 2, 1),
('50850320687', 'GGPS KTANI', 2, 1),
('50850320693', 'GGPS CHANI', 2, 1),
('50850320694', 'GGPS KANI', 2, 1),
('50850320699', 'GGPS KATANI', 2, 1),
('50850320700', 'GGPS GAGNARA', 2, 1),
('50850320704', 'GGPS ADRAD', 2, 1),
('50850320706', 'GGPS GALA', 2, 1),
('50850320716', 'GGPS GALA', 2, 1),
('50850320721', 'GGPS KHATYARI', 2, 1),
('50850320724', 'GGPS BHAUNER', 2, 1),
('50850320731', 'GGPS NALI', 2, 1),
('50850320733', 'GGPS JANUBI', 2, 1),
('50850320736', 'GGPS BAGAH', 2, 1),
('50850320748', 'GGPS KOHMER', 2, 1),
('50850320749', 'GGPS HILL KHURD', 2, 1),
('50850320755', 'GGPS NEELI', 2, 1),
('50850320758', 'GGPS BAND HORI', 2, 1),
('50850320759', 'GGPS BALMI', 2, 1),
('50850320762', 'GGPS NEVEL', 2, 1),
('50850320764', 'GGPS BANDHARE BALA', 2, 1),
('50850320765', 'GGPS MAIL', 2, 1),
('50850320768', 'GGPS BINDI', 2, 1),
('50850320781', 'GGPS GAWAN', 2, 1),
('50850320782', 'GGPS GARIYALAH', 2, 1),
('50850320784', 'GGPS FAGOSH', 2, 1),
('50850320787', 'GGPS FAGOSH', 2, 1),
('50850320789', 'GGPS BATALI', 2, 1),
('50850320791', 'GGPS DANNA', 2, 1),
('50850320792', 'GGPS LEHRI', 2, 1),
('50850320795', 'GGPS BHABRA', 2, 1),
('50850320796', 'GGPS PURAL', 2, 1),
('50850320798', 'GGPS HAGNI MALKAN', 2, 1),
('50850320804', 'GGPS DHASHAL', 2, 1),
('50850320810', 'GGPS', 2, 1),
('50850320814', 'GGPS BAGHLA', 2, 1),
('50850320816', 'GGPS KASS', 2, 1),
('50850320817', 'GGPS BARMOCH', 2, 1),
('50850320818', 'GGPS CHATRIRAIN', 2, 1),
('50850320820', 'GGPS HARI', 2, 1),
('50850320821', 'GGPS BANDYAL', 2, 1),
('50850320823', 'GGPS GATARI', 2, 1),
('50850320824', 'GGPS PHALA', 2, 1),
('50850320826', 'GGPS BARALI', 2, 1),
('50850320827', 'GGPS NARALI', 2, 1),
('50850320828', 'GGPS BANDU', 2, 1),
('50850320830', 'GGPS DHERI', 2, 1),
('50850320831', 'GGPS RED', 2, 1),
('50850320832', 'GGPS GOI', 2, 1),
('50850320840', 'GGPS CHARNARI', 2, 1),
('50850320842', 'GGPS RED', 2, 1),
('50850320849', 'GGPS KOOT', 2, 1),
('50850320850', 'GGPS PRATAN', 2, 1),
('50850320855', 'GGPS KASS', 2, 1),
('50850320856', 'GGPS ROLI', 2, 1),
('50850320858', 'GGPS TALAIR', 2, 1),
('50850320859', 'GGPS DHARI', 2, 1),
('50850320860', 'GGPS NAVNI', 2, 1),
('50850320861', 'GGPS SAID', 2, 1),
('50850320863', 'GGPS GLOIN', 2, 1),
('50850320865', 'GGPS PALHATER', 2, 1),
('50850320869', 'GBPS DHERI', 2, 1),
('50850320872', 'GGPS BRARI', 2, 1),
('50850320874', 'GGPS DOMAIL', 2, 1),
('50850320876', 'GGPS GHEMAN', 2, 1),
('50850320877', 'GGPS NAIL', 2, 1),
('50850320879', 'GGPS SARRANDLAH', 2, 1),
('50850320881', 'GGPS WASTI SANGYAM', 2, 1),
('50850320884', 'GGPS CHOHARA', 2, 1),
('50850320886', 'GGPS BANI', 2, 1),
('50850320887', 'GGPS KARTOOT', 2, 1),
('50850320888', 'GGPS SAROHASARSAWA', 2, 1),
('50850320889', 'GGPS SAMROR', 2, 1),
('50850320891', 'GGPS KOTLA', 2, 1),
('50850320892', 'GGPS MUHAJIR', 2, 1),
('50850320893', 'GGPS NAGHI', 2, 1),
('50850322875', 'GGPS PHAGWARI', 2, 1),
('50850322876', 'GGPS SHUMALI GAHRAN', 2, 1),
('50850322881', 'GGPS SARDA', 2, 1),
('50850322883', 'GGPS NOOR PUR', 2, 1),
('50850322884', 'GGPS KOTIAN', 2, 1),
('50850322885', 'GGPS MANDYARI', 2, 1),
('50850322888', 'GGPS SADIQ', 2, 1),
('50850322899', 'GGPS WAHI', 2, 1),
('50850322931', 'GGPS SARSAWA', 2, 1),
('50850322950', 'GGPS SHERA', 2, 1),
('50850322953', 'GGPS', 2, 1),
('50850322957', 'GGPS QAMROOTI', 2, 1),
('50850322964', 'GGPS BHAUNER', 2, 1),
('50850410853', 'GBMS GANGNARA', 3, 1),
('50850410856', 'GBMS MANOOR', 3, 1),
('50850410860', 'GBMS SIAH SHARIF', 3, 1),
('50850410892', 'GBMS KAKAMI', 3, 1),
('50850410897', 'GBMS TATA PANI', 3, 1),
('50850410902', 'GBMS THALA LAT', 3, 1),
('50850410955', 'GBMS AGHAR', 3, 1),
('50850410959', 'GBMS BERMOUCH', 3, 1),
('50850410972', 'GBMS BAGAH', 3, 1),
('50850411010', 'GBMS DANNA', 3, 1),
('50850411020', 'GBMS MANEEL', 3, 1),
('50850411039', 'GBMS MANSOOH', 3, 1),
('50850411058', 'GBMS GOI', 3, 1),
('50850411078', 'GBMS MANDI', 3, 1),
('50850411081', 'GBMS JANJORA', 3, 1),
('50850411084', 'GBMS HABRA', 3, 1),
('50850411089', 'GBMS ASHQIALI', 3, 1),
('50850411106', 'GBMS KALI KHORI', 3, 1),
('50850411108', 'GBMS NAR SARANDLA', 3, 1),
('50850411118', 'GBMS SIMOR', 3, 1),
('50850411120', 'GBMS SARSAWA', 3, 1),
('50850411123', 'GBMS SANDAIRI', 3, 1),
('50850412917', 'GBMS GULHAR SHARIF', 3, 1),
('50850412918', 'GBMS KOTHIAN', 3, 1),
('50850412928', 'GBMS PLAHATAR', 3, 1),
('50850420689', 'GGMS PANJERA', 3, 1),
('50850420691', 'GGMS MANOOR', 3, 1),
('50850420696', 'GGMS ODHEY SHARIF', 3, 1),
('50850420697', 'GGMS SIAH SHAREEF', 3, 1),
('50850420751', 'GGMS KAKANI', 3, 1),
('50850420800', 'GGMS GHANI KHAZIAN', 3, 1),
('50850420822', 'GGMS HILLAN', 3, 1),
('50850420836', 'GGMS MOHAR', 3, 1),
('50850420843', 'GGMS BUDHAN', 3, 1),
('50850420844', 'GGMS SAWAR', 3, 1),
('50850420851', 'GGMS BARMOCH', 3, 1),
('50850420866', 'GGMS ASHQ ALI', 3, 1),
('50850420867', 'GGMS PHAAWAR MOHRA', 3, 1),
('50850420868', 'GGMS TATA', 3, 1),
('50850420870', 'GGMS SARSAWA', 3, 1),
('50850420875', 'GGMS DONGI', 3, 1),
('50850420882', 'GGMS MAHRIAN', 3, 1),
('50850420885', 'GGMS SARDAR ATIQUE UR REHMAN MANEEL', 3, 1),
('50850420890', 'GGMS SARHOTA', 3, 1),
('50850420941', 'GGMS KAFRA', 3, 1),
('50850422892', 'GGMS MANDI', 3, 1),
('50850422894', 'GGMS DHERI NALA', 3, 1),
('50850510854', 'GBHS PRNJRA', 4, 1),
('50850510893', 'GBHS KHAD GOJRAN', 4, 1),
('50850510895', 'GBHS ANOHI SAROTA', 4, 1),
('50850510929', 'GBHS PHAGWAR MORA', 4, 1),
('50850511013', 'GBHS GANI GHAZIN PHAGWARI', 4, 1),
('50850511016', 'GBHS PHAGWARI', 4, 1),
('50850511032', 'GBHS GOWAN', 4, 1),
('50850511036', 'GBHS TATTA PANI', 4, 1),
('50850511048', 'GBHS NARALI MOHRA', 4, 1),
('50850511052', 'GBHS KANYAT', 4, 1),
('50850511063', 'GBHS MAHRIAN', 4, 1),
('50850511071', 'GBHS PANAG', 4, 1),
('50850511085', 'GBHS KURTI', 4, 1),
('50850511094', 'GBHS ROLI', 4, 1),
('50850511103', 'GBHS ROLI', 4, 1),
('50850511113', 'GBHS SARHOTA NUMBER 2', 4, 1),
('50850511130', 'GBHS KHORABHROT GALA', 4, 1),
('50850512875', 'GBHS CHIEF JUSTICE ® CHOUDARY RAHM SHOWKI MONG', 4, 1),
('50850520734', 'GGHS SONA KHAD GOJRAN', 4, 1),
('50850520742', 'GGHS ANOHI SARHORA', 4, 1),
('50850520809', 'GGHS TATTA PANI', 4, 1),
('50850520815', 'GGHS PHAGWARI', 4, 1),
('50850520837', 'GGHS KANYAT', 4, 1),
('50850520852', 'GGHS NO I KOTLI', 4, 1),
('50850520857', 'GGHS PANAG', 4, 1),
('50850520862', 'GGHS QAMROOTI', 4, 1),
('50850520871', 'GGHS DANDLI KOTLI', 4, 1),
('50850520873', 'GGHS KARTI', 4, 1),
('50850520878', 'GGHS DANA', 4, 1),
('50850520880', 'GGHS CHOKI MOONG', 4, 1),
('50850520883', 'GGHS SAGYAM', 4, 1),
('50850520988', 'GGHS JHANGORA', 4, 1),
('50850522877', 'GGHS GULHAR', 4, 1),
('50850522962', 'GGHS MALHAR', 4, 1),
('50850611074', 'GBHSS DHANWAN', 5, 1),
('50850611090', 'GBHSS', 5, 1),
('50850611104', 'GBHSS DANDLI', 5, 1),
('50850611107', 'GBHSS DONGI', 5, 1),
('50850611110', 'GBHSS QUMROOTI', 5, 1),
('50850620864', 'GGHSS DHAMOL', 5, 1),
('50860110778', 'GPS BUDDLI', 0, 1),
('50860110797', 'GMPS DONGI CHOOCH', 0, 1),
('50860110800', 'GBPS KHARAWAT', 0, 1),
('50860110819', 'GMS TARIYAN', 0, 1),
('50860110847', 'GOVT BOYS PRIMARY SCHOOL SUMROHI', 0, 1),
('50860111189', 'GPS BANDI', 0, 1),
('50860111231', 'GPS THILL KRITOT', 0, 1),
('50860111246', 'GMPS BHABOTA', 0, 1),
('50860113002', 'GPBS SHAKAR GAR', 0, 1),
('50860120647', 'GPS RANJOOT', 0, 1),
('50860121061', 'GGPS BADLI', 0, 1),
('50860210785', 'GBPS GORHA', 1, 1),
('50860210790', 'GPS KHERA', 1, 1),
('50860210804', 'GBPS PHARAL', 1, 1),
('50860210811', 'GBPS POTHA', 1, 1),
('50860210861', 'GBPS JHANDAH', 1, 1),
('50860212980', 'GOVT MASJID PS HEER KOTLI', 1, 1),
('50860220641', 'GPS BURJAN', 1, 1),
('50860222961', 'GOVT MASJID PRIMARY SCHOOL DHAKAN SERA', 1, 1),
('50860222966', 'GGPS WAHAI', 2, 1),
('50860310773', 'GBPS', 2, 1),
('50860310774', 'GBPS ISLAMABAD', 2, 1),
('50860310777', 'GBPS PEHLAN', 2, 1),
('50860310781', 'GBPS DERA', 2, 1),
('50860310782', 'GBPS GURRATA', 2, 1),
('50860310783', 'GBPS PASARIAN', 2, 1),
('50860310786', 'GBPS PERANY', 2, 1),
('50860310788', 'GBPS CHAMEERHI', 2, 1),
('50860310789', 'GBPS NAROOYA', 2, 1),
('50860310793', 'GBPS CHILLA', 2, 1),
('50860310794', 'GBPS BEHERI', 2, 1),
('50860310795', 'GBPS NEELI', 2, 1),
('50860310796', 'GBPS KALLAH', 2, 1),
('50860310798', 'GBPS JALOW PEERAN', 2, 1),
('50860310799', 'GBPS TANGOHA', 2, 1),
('50860310803', 'GBPS ALLAGAR', 2, 1),
('50860310805', 'GBPS PALANG', 2, 1),
('50860310806', 'GBPS DUDIAN', 2, 1),
('50860310808', 'GBPS GEH', 2, 1),
('50860310812', 'GBPS HIL ANDROTH', 2, 1),
('50860310815', 'GBPS SEHAR', 2, 1),
('50860310816', 'GBPS PLATHIAN', 2, 1),
('50860310817', 'GBPS HARNA', 2, 1),
('50860310822', 'GBPS PATHALI', 2, 1),
('50860310824', 'GBPS RAIPUR', 2, 1),
('50860310825', 'GBPS KOTHIAN', 2, 1),
('50860310835', 'GBPS SUNNA', 2, 1),
('50860310836', 'GBPS PALIGA', 2, 1),
('50860310864', 'GBPS SANHOT', 2, 1),
('50860311179', 'GBPS KALORE', 2, 1),
('50860311183', 'GBPS BHRAND', 2, 1),
('50860311193', 'GBPS LAPARRA', 2, 1),
('50860311198', 'GBPS LONA', 2, 1),
('50860311203', 'GBPS JABRI', 2, 1),
('50860311209', 'GBPS NASRIAN', 2, 1),
('50860311212', 'GBPS SHKRA', 2, 1),
('50860311214', 'GBPS BROYIAN', 2, 1),
('50860311221', 'GBPS BROOTI', 2, 1),
('50860311236', 'GBPS JABBER', 2, 1),
('50860311242', 'GBPS ANTI BALA', 2, 1),
('50860311265', 'GBPS FAFRILA', 2, 1),
('50860311269', 'GBPS KAHALA', 2, 1),
('50860311271', 'GBPS BALAWAL', 2, 1),
('50860311275', 'GBPS GLOTIAN', 2, 1),
('50860311315', 'GBPS CHICHLAR', 2, 1),
('50860311328', 'GBPS DONGA', 2, 1),
('50860311349', 'GBPS KOTLA', 2, 1),
('50860312968', 'GBPS PHAGWARAH', 2, 1),
('50860312986', 'GGPS', 2, 1),
('50860312987', 'GBPS KAHALA', 2, 1),
('50860312993', 'GBPS LASSAN', 2, 1),
('50860312994', 'GBPS RALA', 2, 1),
('50860313087', 'GBPS THALI', 2, 1),
('50860320629', 'GGPS BARIGORAH', 2, 1),
('50860320631', 'GGPS PASARIAN', 2, 1),
('50860320632', 'GGPS RAJOOR', 2, 1),
('50860320634', 'GGPS GOHRA', 2, 1),
('50860320635', 'GGPS ISLAMABAD', 2, 1),
('50860320642', 'GGPS HILL', 2, 1),
('50860320643', 'GGPS NAWAN', 2, 1),
('50860320645', 'GGPS PINYALI', 2, 1),
('50860320646', 'GGPS KARAITOTI', 2, 1),
('50860320649', 'GGPS NAMB', 2, 1),
('50860320651', 'GGPS KERI', 2, 1),
('50860320653', 'GGPS JALO', 2, 1),
('50860320654', 'GBPS JALOH', 2, 1),
('50860320655', 'GGPS', 2, 1),
('50860320658', 'GGPS CHOCH', 2, 1),
('50860320659', 'GGPS PLAIGALA', 2, 1),
('50860320660', 'GGPS', 2, 1),
('50860320661', 'GGPS KOHGALI', 2, 1),
('50860320662', 'GGPS BHARAIN', 2, 1),
('50860320663', 'GGPS CHAK', 2, 1),
('50860320664', 'GGPS DALHYOT', 2, 1),
('50860320665', 'GGPS GEH', 2, 1),
('50860320666', 'GGPS KOTLI', 2, 1),
('50860320668', 'GGPS SOON', 2, 1),
('50860320671', 'GGPS KHARAWAT', 2, 1),
('50860320672', 'GGPS PASARIAN', 2, 1),
('50860320673', 'GGPS DONGI', 2, 1),
('50860320675', 'GGPS ALLAGAR', 2, 1),
('50860320685', 'GGPS GHANRA', 2, 1),
('50860320686', 'GGPS RAYE', 2, 1),
('50860320688', 'GGPS THALIYARA', 2, 1),
('50860320690', 'GGPS KAHAR', 2, 1),
('50860320692', 'GGPS RAHOORA', 2, 1),
('50860320979', 'GGPS RATALA', 2, 1),
('50860320995', 'GGPS NARNAH', 2, 1),
('50860321024', 'GGPS BROHAIN', 2, 1),
('50860321027', 'GGPS SANDHI', 2, 1),
('50860321030', 'GGPS SAROWA', 2, 1),
('50860321033', 'GGPS HILL', 2, 1),
('50860321036', 'GGPS NARALA', 2, 1),
('50860321039', 'GGPS HILLAN', 2, 1),
('50860321048', 'GGPS AJRORA', 2, 1),
('50860321053', 'GGPS STAAL', 2, 1),
('50860321059', 'GGPS BHRAND', 2, 1),
('50860321068', 'GGPS FAFRILA', 2, 1),
('50860321073', 'GGPS SAINLA', 2, 1),
('50860321076', 'GGPS JALOH', 2, 1),
('50860321078', 'GGPS GLOTIAN', 2, 1),
('50860321092', 'GGPS NAMATRIAN', 2, 1),
('50860321095', 'GGPS BALAWAL', 2, 1),
('50860322934', 'GGPS CHACHLARH', 2, 1),
('50860322967', 'GGPS BIYAYE', 2, 1),
('50860410775', 'GBMS DAROONA NAR', 3, 1),
('50860410779', 'GBMS NAR MANDO', 3, 1),
('50860410787', 'GBMS PALYAT SEDAAN', 3, 1),
('50860410801', 'GBMS HAILAN', 3, 1),
('50860410807', 'GBMS SHER MUHAMMAD KHAN HOLAR', 3, 1),
('50860410809', 'GBMS DOONGI SANHOOT', 3, 1),
('50860410810', 'GBMS NAWAN', 3, 1),
('50860410820', 'GBMS KAIRI MELLAN', 3, 1),
('50860410826', 'GBMS KRAITOTE', 3, 1),
('50860410833', 'GBMS RUMBLI BABOT', 3, 1),
('50860411279', 'GBMS THERA', 3, 1),
('50860411283', 'GBMS ANTI', 3, 1),
('50860411395', 'GBMS THREDHI DHAR', 3, 1),
('50860420633', 'GGMS CHAMEERI', 3, 1),
('50860420636', 'GGMS NARMANDO', 3, 1),
('50860420648', 'GGMS POTHA', 3, 1),
('50860420650', 'GGMS SALYOUS', 3, 1),
('50860420652', 'GGMS HOLAR', 3, 1),
('50860420656', 'GGMS PLEER', 3, 1),
('50860420701', 'GGMS PATHALI', 3, 1),
('50860421072', 'GGMS ANTI', 3, 1),
('50860421098', 'GGMS JABBRI MOHRT', 3, 1),
('50860421120', 'GGMS DHARYAR', 3, 1),
('50860421126', 'GGMS CHANI SYEDAN', 3, 1),
('50860422959', 'GGMS SAROT', 3, 1),
('50860510784', 'GBHS DAKH', 4, 1),
('50860510791', 'GBHS CHOCHH', 4, 1),
('50860510802', 'GBHS KATHAR', 4, 1),
('50860510813', 'GBHS PALYAT SAYDEN', 4, 1),
('50860510814', 'GBHS PRLEER', 4, 1),
('50860510818', 'GBHS TARALA', 4, 1),
('50860510828', 'GBHS SEHR MANDI', 4, 1),
('50860511406', 'GBHS BARGORA', 4, 1),
('50860511435', 'GBHS JABRI MOHRI', 4, 1),
('50860511446', 'GBHS SEHNSA', 4, 1),
('50860520639', 'GGHS KATHAR', 4, 1),
('50860520670', 'GGHS SEHR MANDI', 4, 1),
('50860520680', 'GGHS ATKORA', 4, 1),
('50860521123', 'GGHS MAKOR', 4, 1),
('50860521129', 'GGHS SEHNA', 4, 1),
('50860610792', 'GBHSS ATKORA', 5, 1),
('50860620657', 'GGHSS TARALA', 5, 1),
('50910313016', 'GBPS SHAKAR GARH', 2, 1),
('51020211985', 'GMS NAKA SHMALI', 1, 1),
('51020212032', 'GBPS GIGEN MUSSA', 1, 1),
('51020311938', 'GBPS CHERAN', 2, 1),
('51020311957', 'GBPS GURRAH', 2, 1),
('51020321650', 'GGPS ALI', 2, 1),
('51020321803', 'GGPS LASS', 2, 1),
('51020321804', 'GGPS MARYAL', 2, 1),
('51020412012', 'GBMS SOKASAN', 3, 1),
('51020412078', 'GBMS PANJERI', 3, 1),
('51020512063', 'GBHS CHILLAH KOHL', 4, 1),
('51030212347', 'GBPS KALYARI', 2, 1),
('51030212487', 'GMS CHENAI TEH SEMEHNI', 1, 1),
('51030312590', 'GBPS SUKA TALLAB', 2, 1),
('51030512275', 'GBHS DUB', 4, 1),
('51030521988', 'GGHS CHANDRI CHONTRA', 4, 1);

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

--
-- Table structure for table `school_facilities`
--

CREATE TABLE `school_facilities` (
  `id` int(11) NOT NULL,
  `emis_code` varchar(20) DEFAULT NULL,
  `electricity` varchar(10) DEFAULT NULL,
  `water` varchar(10) DEFAULT NULL,
  `internet` varchar(10) DEFAULT NULL,
  `road` varchar(10) DEFAULT NULL,
  `assembly` varchar(10) DEFAULT NULL,
  `ground` varchar(10) DEFAULT NULL,
  `medical` varchar(10) DEFAULT NULL,
  `gas` varchar(10) DEFAULT NULL,
  `ptransport` varchar(10) DEFAULT NULL,
  `schair` int(11) DEFAULT NULL,
  `stable` int(11) DEFAULT NULL,
  `desk` int(11) DEFAULT NULL,
  `cupboard` int(11) DEFAULT NULL,
  `board` int(11) DEFAULT NULL,
  `dice` int(11) DEFAULT NULL,
  `computer_lab` varchar(10) DEFAULT NULL,
  `computers` int(11) DEFAULT NULL,
  `printers` int(11) DEFAULT NULL,
  `comchair` int(11) DEFAULT NULL,
  `comtable` int(11) DEFAULT NULL,
  `bio_lab` varchar(10) DEFAULT NULL,
  `bioequipment` varchar(10) DEFAULT NULL,
  `bioreq` varchar(10) DEFAULT NULL,
  `phy_lab` varchar(10) DEFAULT NULL,
  `phequipment` varchar(10) DEFAULT NULL,
  `phreq` varchar(10) DEFAULT NULL,
  `com_lab` varchar(10) DEFAULT NULL,
  `comequipment` varchar(10) DEFAULT NULL,
  `comreq` varchar(10) DEFAULT NULL,
  `zoo_lab` varchar(10) DEFAULT NULL,
  `zooequipment` varchar(10) DEFAULT NULL,
  `zooreq` varchar(10) DEFAULT NULL,
  `bot_lab` varchar(10) DEFAULT NULL,
  `botequipment` varchar(10) DEFAULT NULL,
  `botreq` varchar(10) DEFAULT NULL,
  `home_lab` varchar(10) DEFAULT NULL,
  `homeequipment` varchar(10) DEFAULT NULL,
  `homereq` varchar(10) DEFAULT NULL,
  `tech_lab` varchar(10) DEFAULT NULL,
  `tecequipment` varchar(10) DEFAULT NULL,
  `tecreq` varchar(10) DEFAULT NULL,
  `smart_classroom` varchar(10) DEFAULT NULL,
  `smequipment` varchar(10) DEFAULT NULL,
  `smreq` varchar(10) DEFAULT NULL,
  `ece_classroom` varchar(10) DEFAULT NULL,
  `eceequipment` varchar(10) DEFAULT NULL,
  `ecereq` varchar(10) DEFAULT NULL,
  `sports_stock` varchar(10) DEFAULT NULL,
  `spequipment` varchar(10) DEFAULT NULL,
  `spreq` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `school_facilities`
--

INSERT INTO `school_facilities` (`id`, `emis_code`, `electricity`, `water`, `internet`, `road`, `assembly`, `ground`, `medical`, `gas`, `ptransport`, `schair`, `stable`, `desk`, `cupboard`, `board`, `dice`, `computer_lab`, `computers`, `printers`, `comchair`, `comtable`, `bio_lab`, `bioequipment`, `bioreq`, `phy_lab`, `phequipment`, `phreq`, `com_lab`, `comequipment`, `comreq`, `zoo_lab`, `zooequipment`, `zooreq`, `bot_lab`, `botequipment`, `botreq`, `home_lab`, `homeequipment`, `homereq`, `tech_lab`, `tecequipment`, `tecreq`, `smart_classroom`, `smequipment`, `smreq`, `ece_classroom`, `eceequipment`, `ecereq`, `sports_stock`, `spequipment`, `spreq`) VALUES
(1, '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, '0', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(2, '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, '0', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(3, '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, '0', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(4, '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, '0', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(5, '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, '0', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(6, '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, '0', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(7, '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, '0', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(8, '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, '0', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `school_lab`
--

CREATE TABLE `school_lab` (
  `id` int(11) NOT NULL,
  `computer_lab` tinyint(1) DEFAULT NULL,
  `computer_count` int(11) DEFAULT NULL,
  `printer_count` int(11) DEFAULT NULL,
  `computer_chairs_count` int(11) DEFAULT NULL,
  `computer_tables_count` int(11) DEFAULT NULL,
  `biology_chemistry_lab` tinyint(1) DEFAULT NULL,
  `bio_equipment` tinyint(1) DEFAULT NULL,
  `bio_requirements` text DEFAULT NULL,
  `physics_lab` tinyint(1) DEFAULT NULL,
  `physics_equipment` tinyint(1) DEFAULT NULL,
  `physics_requirements` text DEFAULT NULL,
  `combined_lab` tinyint(1) DEFAULT NULL,
  `combined_equipment` tinyint(1) DEFAULT NULL,
  `combined_requirements` text DEFAULT NULL,
  `zoology_lab` tinyint(1) DEFAULT NULL,
  `zoo_equipment` tinyint(1) DEFAULT NULL,
  `zoo_requirements` text DEFAULT NULL,
  `botany_lab` tinyint(1) DEFAULT NULL,
  `bot_equipment` tinyint(1) DEFAULT NULL,
  `bot_requirements` text DEFAULT NULL,
  `home_economics_lab` tinyint(1) DEFAULT NULL,
  `home_equipment` tinyint(1) DEFAULT NULL,
  `home_requirements` text DEFAULT NULL,
  `technical_workshop` tinyint(1) DEFAULT NULL,
  `tec_equipment` tinyint(1) DEFAULT NULL,
  `tec_requirements` text DEFAULT NULL,
  `smart_classroom` tinyint(1) DEFAULT NULL,
  `sm_equipment` tinyint(1) DEFAULT NULL,
  `sm_requirements` text DEFAULT NULL,
  `ece_classroom` tinyint(1) DEFAULT NULL,
  `ece_equipment` tinyint(1) DEFAULT NULL,
  `ece_requirements` text DEFAULT NULL,
  `sports_stock` tinyint(1) DEFAULT NULL,
  `sp_equipment` tinyint(1) DEFAULT NULL,
  `sp_requirements` text DEFAULT NULL,
  `submission_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `school_land`
--

CREATE TABLE `school_land` (
  `id` int(11) NOT NULL,
  `emis_code` varchar(255) NOT NULL,
  `land_select` varchar(3) NOT NULL,
  `kanal` varchar(10) DEFAULT NULL,
  `marla` varchar(10) DEFAULT NULL,
  `land_type` varchar(50) DEFAULT NULL,
  `ownershipstatus` varchar(50) DEFAULT NULL,
  `landdocument` varchar(3) DEFAULT NULL,
  `noland` varchar(255) DEFAULT NULL,
  `submission_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `school_level`
--

CREATE TABLE `school_level` (
  `level_id` int(10) NOT NULL,
  `level_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `school_level`
--

INSERT INTO `school_level` (`level_id`, `level_name`) VALUES
(0, 'Maktab School'),
(1, 'Masjid School'),
(2, 'Primary School'),
(3, 'Middle School'),
(4, 'High School'),
(5, 'Higher Secondary School'),
(6, 'Inter College'),
(7, 'Degree College'),
(8, 'Post Graduate College'),
(9, 'F.G Public School'),
(10, 'Special School'),
(11, 'Community School'),
(12, 'Village Workshop'),
(13, 'Elementary College'),
(14, 'OPF School'),
(15, 'Fauji Foundation School');

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

--
-- Table structure for table `school_profile`
--

CREATE TABLE `school_profile` (
  `id` int(11) NOT NULL,
  `school_name` varchar(255) NOT NULL,
  `school_type` varchar(50) NOT NULL,
  `emis_code` varchar(50) NOT NULL,
  `ddo_code` varchar(50) NOT NULL,
  `village` varchar(100) NOT NULL,
  `post_office` varchar(100) NOT NULL,
  `district` varchar(100) NOT NULL,
  `tehsil` varchar(100) NOT NULL,
  `union_council` varchar(100) NOT NULL,
  `constituency` varchar(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  `contact_no` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `locality` varchar(50) NOT NULL,
  `distance` varchar(50) NOT NULL,
  `zone` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `school_gender` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `school_profile`
--

INSERT INTO `school_profile` (`id`, `school_name`, `school_type`, `emis_code`, `ddo_code`, `village`, `post_office`, `district`, `tehsil`, `union_council`, `constituency`, `level`, `contact_no`, `email`, `locality`, `distance`, `zone`, `status`, `school_gender`) VALUES
(27, 'hhhhhhhhhhhhh', 'Government', '50860510784', 'hhhhhhhhh', 'ko', 'ggggggggg', '1', '1', '9', '3', 'Middle', '3435115550', 'mohsinbashirraja@gmail.com', 'Rural', '222', 'Winter Station', 'Active', 'Male'),
(28, 'hhhhhhhhhhhhh', 'Government', '50860510784', 'hhhhhhhhh', 'ko', 'ggggggggg', '1', '1', '9', '3', 'Middle', '3435115550', 'mohsinbashirraja@gmail.com', 'Rural', '222', 'Winter Station', 'Active', 'Male'),
(29, 'hhhhhhhhhhhhh', 'Semi Government', '123', '22222222222222', 'ko', 'ggggggggg', '1', '1', '10', '3', 'Middle', '3435115550', 'mohsinbashirraja@gmail.com', 'Rural', '222', 'Winter Station', 'Active', 'Male'),
(30, 'hhhhhhhhhhhhh', 'Semi Government', '123', '22222222222222', 'ko', 'ggggggggg', '1', '1', '10', '3', 'Middle', '3435115550', 'mohsinbashirraja@gmail.com', 'Rural', '222', 'Winter Station', 'Active', 'female'),
(31, 'hhhhhhhhhhhhh', 'Government', '50860510784', 'hhhhhhhhh', 'ko', 'ggggggggg', '1', '1', '6', '2', 'High', '3435115550', 'mohsinbashirraja@gmail.com', 'Rural', '222', 'Winter Station', 'Active', 'Male'),
(32, 'hhhhhhhhhhhhh', 'Government', '50860510784', 'hhhhhhhhh', 'ko', 'ggggggggg', '1', '1', '6', '2', 'High', '3435115550', 'mohsinbashirraja@gmail.com', 'Rural', '222', 'Winter Station', 'Active', 'Male'),
(33, 'hhhhhhhhhhhhh', 'Government', '50860510784', 'hhhhhhhhh', 'ko', 'ggggggggg', '1', '1', '6', '2', 'High', '3435115550', 'mohsinbashirraja@gmail.com', 'Rural', '222', 'Winter Station', 'Active', 'Female'),
(34, 'hhhhhhhhhhhhh', 'Government', '50860510784', 'hhhhhhhhh', 'ko', 'ggggggggg', '1', '1', '6', '2', 'High', '3435115550', 'mohsinbashirraja@gmail.com', 'Rural', '222', 'Winter Station', 'Active', 'Male'),
(35, 'hhhhhhhhhhhhh', 'Semi Government', '50860510784', 'hhhhhhhhh', 'ko', 'ggggggggg', '1', '1', '10', '3', 'High', '3435115550', 'mohsinbashirraja@gmail.com', 'Rural', '222', 'Summer Station', 'Active', 'Male'),
(36, 'hhhhhhhhhhhhh', 'Semi Government', '50860510784', 'hhhhhhhhh', 'ko', 'ggggggggg', '1', '1', '10', '3', 'High', '3435115550', 'mohsinbashirraja@gmail.com', 'Rural', '222', 'Summer Station', 'Active', 'Female'),
(37, 'hhhhhhhhhhhhh', 'Semi Government', '50860510784', 'hhhhhhhhh', 'ko', 'ggggggggg', '1', '1', '10', '3', 'High', '3435115550', 'mohsinbashirraja@gmail.com', 'Rural', '222', 'Summer Station', 'Active', 'Male');

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

--
-- Table structure for table `school_smc`
--

CREATE TABLE `school_smc` (
  `id` int(11) NOT NULL,
  `emis_code` int(11) NOT NULL,
  `smc` varchar(10) DEFAULT NULL,
  `smcactive` varchar(3) DEFAULT NULL,
  `smctraining` varchar(3) DEFAULT NULL,
  `smcp` varchar(50) DEFAULT NULL,
  `smcpc` varchar(50) DEFAULT NULL,
  `smcbankaccount` varchar(3) DEFAULT NULL,
  `smcbankname` varchar(50) DEFAULT NULL,
  `smcbac` varchar(30) DEFAULT NULL,
  `smcamount` varchar(30) DEFAULT NULL,
  `nosmc` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `school_smc`
--

INSERT INTO `school_smc` (`id`, `emis_code`, `smc`, `smcactive`, `smctraining`, `smcp`, `smcpc`, `smcbankaccount`, `smcbankname`, `smcbac`, `smcamount`, `nosmc`) VALUES
(1, 0, 'yes', 'Yes', 'No', 'rafiq ahmed', '03430547661', 'Yes', 'hbl', '909090090', '5000', ''),
(2, 0, 'no', 'Yes', 'No', 'rafiq ahmed', '03430547661', 'Yes', 'hbl', '909090090', '5000', 'smc not present in school'),
(3, 123, 'yes', 'Yes', 'No', 'rafiq', '03430547661', 'Yes', 'hbl', '909090090', '5000', 'smc not present in school'),
(4, 2147483647, 'yes', 'Yes', 'Yes', '', '', 'No', '', '', '', 'smc not present in school'),
(5, 2147483647, NULL, 'Yes', 'Yes', 'rafiq', '03430547661', 'Yes', 'hbl', '909090090', '5000', 'smc not present in school'),
(6, 2147483647, 'yes', 'Yes', 'Yes', 'rafiq', '03430547661', 'Yes', 'hbl', '909090090', '5000', 'smc not present in school'),
(7, 2147483647, 'no', 'Yes', 'Yes', 'rafiq', '03430547661', 'Yes', 'hbl', '909090090', '5000', 'smc not present in school'),
(8, 2147483647, 'yes', 'Yes', 'Yes', 'rafiqkkkkkkkk', '03430547661', 'Yes', 'hbl', '909090090', '5000', 'smc not present in school'),
(9, 2147483647, 'yes', 'Yes', 'Yes', 'rafiqkkkkkkkk', '03430547661', 'Yes', 'hbl', '909090090', '5000', 'smc not present in school'),
(10, 2147483647, 'no', '', '', '', '', '', '', '', '', 'smc not present in school'),
(11, 50000, 'no', '', '', '', '', '', '', '', '', 'i am a boy'),
(12, 2147483647, 'yes', 'Yes', 'Yes', 'Babar Sohail', '03430547661', 'Yes', 'hbl', '00097869', '10000', ''),
(13, 2147483647, 'no', '', '', '', '', '', '', '', '', 'i am a boy'),
(14, 200000, 'yes', 'Yes', 'Yes', 'rafiq ahmed', '03430547661', 'Yes', 'hbl', '909090090', '5000', ''),
(15, 200000, 'no', '', '', '', '', '', '', '', '', 'hhhhh');

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

--
-- Table structure for table `school_students`
--

CREATE TABLE `school_students` (
  `id` int(11) NOT NULL,
  `emis_code` varchar(50) NOT NULL,
  `class_name` varchar(50) NOT NULL,
  `total_male` int(11) DEFAULT 0,
  `total_female` int(11) DEFAULT 0,
  `repeating_male` int(11) DEFAULT 0,
  `repeating_female` int(11) DEFAULT 0,
  `orphan_male` int(11) DEFAULT 0,
  `orphan_female` int(11) DEFAULT 0,
  `special_male` int(11) DEFAULT 0,
  `special_female` int(11) DEFAULT 0,
  `scholar_male` int(11) DEFAULT 0,
  `scholar_female` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `school_students`
--

INSERT INTO `school_students` (`id`, `emis_code`, `class_name`, `total_male`, `total_female`, `repeating_male`, `repeating_female`, `orphan_male`, `orphan_female`, `special_male`, `special_female`, `scholar_male`, `scholar_female`) VALUES
(1, '5600', 'Nursery', 222, 22, 33, 32, 33, 3, 2, 2, 22, 11),
(2, '5600', 'Nursery', 222, 22, 33, 32, 33, 3, 2, 2, 22, 11),
(3, '5600', 'ONE', 33, 0, 12, 0, 11, 0, 0, 0, 0, 0),
(4, '5600', 'Three', 2, 0, 1, 0, 0, 0, 0, 0, 0, 0),
(5, '5600', '4th', 90, 0, 9, 0, 21, 0, 2, 0, 5, 0),
(6, '5600', 'Nursery', 10, 10, 0, 0, 0, 0, 0, 0, 0, 0),
(7, '5600', 'Nursery', 4, 3, 1, 1, 2, 0, 0, 0, 0, 0),
(8, '5600', '10th', 5, 0, 1, 0, 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `id` int(11) NOT NULL,
  `designation` varchar(50) DEFAULT NULL,
  `education` varchar(50) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `location` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`id`, `designation`, `education`, `gender`, `location`) VALUES
(1, 'senior principal', 'phd', 'male', 'kotli'),
(2, ' principal', 'phd', 'male', 'kotli'),
(3, ' principal', 'phd', 'female', 'kotli'),
(4, ' headmaster', 'matric', 'male', 'kotli'),
(5, ' headmaster', 'f.a', 'female', 'kotli'),
(6, 'Computer Instructor', 'Mphil', 'male', 'Poonch'),
(7, 'Computer Instructor', 'Mphil', 'female', 'Bagh'),
(8, 'elementary teacher', 'B.A', 'female', 'kotli'),
(9, 'elementary teacher', 'B.A', 'male', 'kotli'),
(10, 'elementary teacher', 'M.A', 'female', 'kotli'),
(11, 'elementary teacher', 'B.A', 'female', 'kotli'),
(12, 'elementary teacher', 'B.A', 'female', 'kotli'),
(13, 'elementary teacher', 'B.A', 'female', 'kotli'),
(14, 'elementary teacher', 'B.A', 'female', 'kotli'),
(15, 'elementary teacher', 'B.A', 'female', 'kotli'),
(16, 'elementary teacher', 'B.A', 'female', 'kotli'),
(17, 'elementary teacher', 'B.A', 'female', 'kotli');

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

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

CREATE TABLE `students` (
  `id` int(11) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `age` int(11) DEFAULT NULL,
  `grade` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `students1`
--

CREATE TABLE `students1` (
  `id` int(11) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `age` int(11) DEFAULT NULL,
  `class` varchar(10) DEFAULT NULL,
  `male_students` int(11) NOT NULL,
  `female_students` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `students1`
--

INSERT INTO `students1` (`id`, `first_name`, `last_name`, `age`, `class`, `male_students`, `female_students`) VALUES
(1, 'aa', 'bb', 99, '1', 12, 23),
(2, 'eeee', 'ee', 44, '2', 25, 35),
(3, 'vv', 'vv', 22, '3', 17, 21),
(4, 'vv', 'vv', 22, '4', 23, 67),
(5, 'vv', 'vv', 22, '5', 130, 89),
(6, 'vv', 'vv', 22, '6', 160, 110),
(7, 'vv', 'vv', 22, '7', 75, 65),
(8, 'vv', 'vv', 22, '8', 55, 45),
(9, 'vv', 'vv', 22, '9', 100, 120),
(10, 'vv', 'vv', 22, '10', 37, 47);

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

--
-- Table structure for table `student_information`
--

CREATE TABLE `student_information` (
  `emis_code` varchar(12) NOT NULL,
  `cate_id` int(10) NOT NULL,
  `level_id` int(10) NOT NULL,
  `stname` varchar(100) NOT NULL,
  `stfname` varchar(100) NOT NULL,
  `stge` varchar(10) NOT NULL,
  `stbirthday` date NOT NULL,
  `stbfno` varchar(13) NOT NULL,
  `strel` varchar(50) NOT NULL,
  `stmobno` varchar(11) NOT NULL,
  `classadm` int(50) NOT NULL,
  `doadm` date NOT NULL,
  `admno` varchar(25) NOT NULL,
  `stpic` varchar(255) NOT NULL,
  `stclass` int(50) NOT NULL,
  `stcsec` varchar(11) NOT NULL DEFAULT 'A',
  `stcno` varchar(50) NOT NULL,
  `stgroup` varchar(50) DEFAULT NULL,
  `stvillage` varchar(100) NOT NULL,
  `stpo` varchar(100) NOT NULL,
  `district_id` int(11) NOT NULL,
  `tehsil_id` int(11) NOT NULL,
  `uc_id` int(11) NOT NULL,
  `cons_id` int(11) NOT NULL,
  `created_at` timestamp(6) NOT NULL DEFAULT current_timestamp(6)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `student_information`
--

INSERT INTO `student_information` (`emis_code`, `cate_id`, `level_id`, `stname`, `stfname`, `stge`, `stbirthday`, `stbfno`, `strel`, `stmobno`, `classadm`, `doadm`, `admno`, `stpic`, `stclass`, `stcsec`, `stcno`, `stgroup`, `stvillage`, `stpo`, `district_id`, `tehsil_id`, `uc_id`, `cons_id`, `created_at`) VALUES
('50250321429', 1, 2, 'Mohsin Bashir', 'Muhammad Bashir', 'Male', '1988-08-14', '8120240197136', 'Islam', '03005295022', 9, '2024-08-16', '222', '8120240197136.jpg', 14, 'A', '1', 'Humanities', 'kotli', 'kotli', 1, 1, 8, 2, '2024-08-17 18:18:13.433935');

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

--
-- Table structure for table `subjects`
--

CREATE TABLE `subjects` (
  `subj_id` int(11) NOT NULL,
  `subj_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subjects`
--

INSERT INTO `subjects` (`subj_id`, `subj_name`) VALUES
(24, 'Agriculture'),
(21, 'Arabic'),
(28, 'Arts & Design'),
(11, 'Biology'),
(25, 'Business Studies'),
(10, 'Chemistry'),
(15, 'Civics'),
(12, 'Computer Science'),
(14, 'Economics'),
(20, 'Education'),
(1, 'English'),
(31, 'Environmental Science'),
(6, 'Ethics (for non-Muslims)'),
(34, 'Functional English (vocational)'),
(4, 'General Mathematics (Arts)'),
(8, 'General Science'),
(16, 'Geography'),
(30, 'Health & Hygiene'),
(17, 'History'),
(23, 'Home Economics'),
(35, 'Islamic History (elective)'),
(5, 'Islamic Studies'),
(32, 'Kashmiri (optional)'),
(3, 'Mathematics'),
(33, 'Pahari (optional)'),
(7, 'Pakistan Studies'),
(22, 'Persian'),
(29, 'Physical Education'),
(9, 'Physics'),
(36, 'Political Science (elective)'),
(26, 'Principles of Accounting'),
(18, 'Psychology'),
(13, 'Social Studies'),
(19, 'Sociology'),
(27, 'Statistics'),
(2, 'Urdu');

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

--
-- Table structure for table `subject_group`
--

CREATE TABLE `subject_group` (
  `group_id` int(20) NOT NULL,
  `group_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subject_group`
--

INSERT INTO `subject_group` (`group_id`, `group_name`) VALUES
(1, 'Science'),
(2, 'Humanities'),
(3, 'Technical'),
(4, 'Special Education'),
(5, 'Matric Tech');

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

--
-- Table structure for table `subject_results`
--

CREATE TABLE `subject_results` (
  `id` int(11) NOT NULL,
  `stbfno` varchar(13) NOT NULL,
  `subject_name` varchar(255) NOT NULL,
  `teacher_name` varchar(255) NOT NULL,
  `firsttermobtainmarks` int(11) NOT NULL,
  `absentpresent` varchar(255) NOT NULL,
  `firstresultsstatus` varchar(255) NOT NULL,
  `secondtermmarks` int(11) NOT NULL,
  `secondresultsstatus` varchar(255) NOT NULL,
  `finalmarks` int(11) NOT NULL,
  `finalresultsstatus` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subject_results`
--

INSERT INTO `subject_results` (`id`, `stbfno`, `subject_name`, `teacher_name`, `firsttermobtainmarks`, `absentpresent`, `firstresultsstatus`, `secondtermmarks`, `secondresultsstatus`, `finalmarks`, `finalresultsstatus`) VALUES
(19, '7', 'english', '1', 100, 'present', 'pass', 0, '', 0, ''),
(20, '7', '', '', 0, '', '', 0, '', 0, ''),
(21, '7', '', '', 0, '', '', 0, '', 0, ''),
(22, '8', 'english', 'wajid', 100, 'present', 'pass', 80, 'pass', 87, 'pass'),
(23, '8', 'Urdu', 'wajid', 100, 'p', 'pass', 90, 'pass', 97, 'pass'),
(24, '8', 'Maths', 'wajid', 100, 'p', 'pass', 69, 'pass', 64, 'pass'),
(25, '9', 'english', 'w', 100, 'present', 'pass', 80, 'pass', 87, 'pass'),
(26, '9', '', '', 0, '', '', 0, '', 0, ''),
(27, '9', '', '', 0, '', '', 0, '', 0, '');

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

--
-- Table structure for table `target_table`
--

CREATE TABLE `target_table` (
  `name` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `target_table`
--

INSERT INTO `target_table` (`name`) VALUES
('3'),
('1'),
('2'),
('3'),
('wajid'),
('mohsin');

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

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

CREATE TABLE `teachers` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `teacher_profile`
--

CREATE TABLE `teacher_profile` (
  `personalno` varchar(255) NOT NULL,
  `tename` varchar(255) DEFAULT NULL,
  `tefname` varchar(255) DEFAULT NULL,
  `tege` enum('Male','Female','Other') DEFAULT NULL,
  `tebirthday` date DEFAULT NULL,
  `tebplace` varchar(255) DEFAULT NULL,
  `tecnic` varchar(255) DEFAULT NULL,
  `teemq` varchar(255) DEFAULT NULL,
  `temarst` enum('Married','Un-Married','Divorced','Widow') DEFAULT NULL,
  `temobno` varchar(255) DEFAULT NULL,
  `tewano` varchar(255) DEFAULT NULL,
  `tegpfno` varchar(255) DEFAULT NULL,
  `teddono` varchar(255) DEFAULT NULL,
  `tenok` varchar(255) DEFAULT NULL,
  `tenokre` varchar(255) DEFAULT NULL,
  `tevillage` varchar(255) DEFAULT NULL,
  `tepo` varchar(255) DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  `tehsil` varchar(255) DEFAULT NULL,
  `unionCouncil` varchar(255) DEFAULT NULL,
  `tconstituency` varchar(255) DEFAULT NULL,
  `tecudesig` varchar(255) DEFAULT NULL,
  `tecups` int(11) DEFAULT NULL,
  `dojcp` date DEFAULT NULL,
  `tetimes` date DEFAULT NULL,
  `iaa` varchar(255) DEFAULT NULL,
  `doapp` date DEFAULT NULL,
  `workin` varchar(255) DEFAULT NULL,
  `wtis` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `teacher_profile`
--

INSERT INTO `teacher_profile` (`personalno`, `tename`, `tefname`, `tege`, `tebirthday`, `tebplace`, `tecnic`, `teemq`, `temarst`, `temobno`, `tewano`, `tegpfno`, `teddono`, `tenok`, `tenokre`, `tevillage`, `tepo`, `district`, `tehsil`, `unionCouncil`, `tconstituency`, `tecudesig`, `tecups`, `dojcp`, `tetimes`, `iaa`, `doapp`, `workin`, `wtis`) VALUES
('', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '1', '', '', '', '', 0, '0000-00-00', '0000-00-00', '', '0000-00-00', '', '0000-00-00'),
('1', 'mohsin', 'bashir', 'Male', '1988-08-14', '', '', '', 'Married', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '0000-00-00', '0000-00-00', '', '0000-00-00', '', '0000-00-00'),
('123', 'ali', 'Muzaffar', 'Male', '2024-07-16', 'Tahi', '8230238743745', 'Direct', 'Divorced', '03468145393', '03468145393', 'okkk', 'kj0104', 'abiha', 'daughter', 'bagha', 'tahi', 'undefined', '', '', 'aaaaa', '', 0, '0000-00-00', '0000-00-00', '', '0000-00-00', '', '0000-00-00'),
('890560', 'khan', 'ali bahadar', 'Male', '1987-05-17', 'bagha', '8120207142185', 'Direct', 'Married', '03430547661', '03430547661', '9132', 'kjo134', 'abiha', 'daughter', 'bagha', 'tattapani', '1', '1', '1', 'RajMehal', 'computer instructor', 17, '2017-12-21', '2017-12-21', 'computer instructor', '2017-12-21', 'same position', '2017-12-21'),
('89056090', 'khan', 'ali bahadar', 'Male', '1987-05-17', 'bagha', '8120207142185', 'Direct', 'Married', '03430547661', '03430547661', '9132', 'kjo134', 'abiha', 'daughter', 'bagha', 'tattapani', '4', '3', '5', 'RajMehal', 'computer instructor', 17, '2017-12-21', '2017-12-21', 'computer instructor', '2017-12-21', 'same position', '2017-12-21'),
('90091261', 'Wajid', 'Muzaffar', 'Male', '1985-05-23', 'Tahi', '8230238743745', 'Direct', 'Married', '03468145393', '03468145393', 'okkk', 'kj0104', 'mmm', 'ooo', 'tahi', 'tahi', '4', '3', '5', 'aaaaa', 'CI', 17, '2017-12-20', '0000-00-00', 'CI', '2017-12-20', 'HSSD', '2019-07-13'),
('900963', 'amir hamza', 'ali bahadar', 'Male', '1987-05-17', 'bagha', '8120207142185', 'Direct', 'Married', '03430547661', '03430547661', '9132', 'kjo134', 'abiha', 'daughter', 'bagha', 'tattapani', '1', '1', '1', 'RajMehal', 'computer instructor', 17, '2017-12-21', '2017-12-21', 'computer instructor', '2017-12-21', 'same position', '2017-12-21'),
('900963897', 'khan', 'ali bahadar', 'Male', '1987-05-17', 'bagha', '8120207142185', 'Direct', 'Married', '03430547661', '03430547661', '9132', 'kjo134', 'abiha', 'daughter', 'bagha', 'tattapani', '1', '', '', 'RajMehal', 'computer instructor', 17, '2017-12-21', '2017-12-21', 'computer instructor', '2017-12-21', 'same position', '2017-12-21'),
('90096389700', 'khan', 'ali bahadar', 'Male', '1987-05-17', 'bagha', '8120207142185', 'Direct', 'Married', '03430547661', '03430547661', '9132', 'kjo134', 'abiha', 'daughter', 'bagha', 'tattapani', '1', '1', '1', 'RajMehal', 'computer instructor', 17, '2017-12-21', '2017-12-21', 'computer instructor', '2017-12-21', 'same position', '2017-12-21'),
('900963897000000', 'khan', 'ali bahadar', 'Male', '1987-05-17', 'bagha', '8120207142185', 'Direct', 'Married', '03430547661', '03430547661', '9132', 'kjo134', 'abiha', 'daughter', 'bagha', 'tattapani', '1', '1', '1', 'RajMehal', 'computer instructor', 17, '2017-12-21', '2017-12-21', 'computer instructor', '2017-12-21', 'same position', '2017-12-21'),
('9101020', '', '', 'Female', '0000-00-00', '', '', '', 'Married', '', '', '', '', '', '', '', '', '1', '1', '1', '', '', 0, '0000-00-00', '0000-00-00', '', '0000-00-00', '', '0000-00-00'),
('910102015667', 'ham', '', 'Male', '0000-00-00', '', '', '', 'Married', '', '', '', '', '', '', '', '', '1', '1', '1', 'RajMehal', '', 0, '0000-00-00', '0000-00-00', '', '0000-00-00', '', '0000-00-00'),
('gggggggg', 'ggggggggg', 'ggggggggg', 'Male', '2025-07-23', '777777777', '77777-7777777-7', '4', 'Married', '03777777777', '03777777777', '77777777777', '7777777777', '77777777', '9', 'gggggggg', 'gggggggggggggg', '1', '1', '3', '', '19', 14, '2025-07-15', '2025-07-22', '17', '2025-07-08', '11111111111', '2025-07-25');

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

--
-- Table structure for table `teacher_promotion`
--

CREATE TABLE `teacher_promotion` (
  `personalno` varchar(255) NOT NULL,
  `tepredesig1` varchar(255) DEFAULT NULL,
  `teprescale1` int(11) DEFAULT NULL,
  `tenewdesig1` varchar(255) DEFAULT NULL,
  `tenewscale1` int(11) DEFAULT NULL,
  `teprodate1` date DEFAULT NULL,
  `tepredesig2` varchar(255) DEFAULT NULL,
  `teprescale2` int(11) DEFAULT NULL,
  `tenewdesig2` varchar(255) DEFAULT NULL,
  `tenewscale2` int(11) DEFAULT NULL,
  `teprodate2` date DEFAULT NULL,
  `tepredesig3` varchar(255) DEFAULT NULL,
  `teprescale3` int(11) DEFAULT NULL,
  `tenewdesig3` varchar(255) DEFAULT NULL,
  `tenewscale3` int(11) DEFAULT NULL,
  `teprodate3` date DEFAULT NULL,
  `tepredesig4` varchar(255) DEFAULT NULL,
  `teprescale4` int(11) DEFAULT NULL,
  `tenewdesig4` varchar(255) DEFAULT NULL,
  `tenewscale4` int(11) DEFAULT NULL,
  `teprodate4` date DEFAULT NULL,
  `tepredesig5` varchar(255) DEFAULT NULL,
  `teprescale5` int(11) DEFAULT NULL,
  `tenewdesig5` varchar(255) DEFAULT NULL,
  `tenewscale5` int(11) DEFAULT NULL,
  `teprodate5` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `teacher_promotion`
--

INSERT INTO `teacher_promotion` (`personalno`, `tepredesig1`, `teprescale1`, `tenewdesig1`, `tenewscale1`, `teprodate1`, `tepredesig2`, `teprescale2`, `tenewdesig2`, `tenewscale2`, `teprodate2`, `tepredesig3`, `teprescale3`, `tenewdesig3`, `tenewscale3`, `teprodate3`, `tepredesig4`, `teprescale4`, `tenewdesig4`, `tenewscale4`, `teprodate4`, `tepredesig5`, `teprescale5`, `tenewdesig5`, `tenewscale5`, `teprodate5`) VALUES
('', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00'),
('1', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00'),
('123', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00'),
('890560', 'ci', 17, 'ci', 17, '2017-12-21', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00'),
('89056090', 'ci', 17, 'ci', 17, '2017-12-21', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00'),
('90091261', 'ci', 17, 'CI', 17, '2017-12-20', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00'),
('900963', 'ci', 17, 'ci', 17, '2017-12-21', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00'),
('900963897', 'ci', 17, 'ci', 17, '2017-12-21', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00'),
('90096389700', 'ci', 17, 'ci', 17, '2017-12-21', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00'),
('900963897000000', 'ci', 17, 'ci', 17, '2017-12-21', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00'),
('910102015667', 'ci', 1, 'ci', 1, '2024-01-15', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00'),
('gggggggg', '7', 3, '7', 12, '2025-07-24', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00', '', 0, '', 0, '0000-00-00');

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

--
-- Table structure for table `teacher_pro_qualification`
--

CREATE TABLE `teacher_pro_qualification` (
  `personalno` varchar(255) NOT NULL,
  `teptpass` varchar(255) DEFAULT NULL,
  `teptis` varchar(255) DEFAULT NULL,
  `teptom` varchar(255) DEFAULT NULL,
  `teptdiv` varchar(10) DEFAULT NULL,
  `tebedpass` varchar(255) DEFAULT NULL,
  `tebedis` varchar(255) DEFAULT NULL,
  `tebedom` varchar(255) DEFAULT NULL,
  `tebeddiv` varchar(10) DEFAULT NULL,
  `temedpass` varchar(255) DEFAULT NULL,
  `temedis` varchar(255) DEFAULT NULL,
  `temedom` varchar(255) DEFAULT NULL,
  `temeddiv` varchar(10) DEFAULT NULL,
  `teo1name` varchar(255) DEFAULT NULL,
  `teo1pass` varchar(255) DEFAULT NULL,
  `teo1is` varchar(255) DEFAULT NULL,
  `teo1om` varchar(255) DEFAULT NULL,
  `teo1div` varchar(10) DEFAULT NULL,
  `teo2name` varchar(255) DEFAULT NULL,
  `teo2pass` varchar(255) DEFAULT NULL,
  `teo2is` varchar(255) DEFAULT NULL,
  `teo2om` varchar(255) DEFAULT NULL,
  `teo2div` varchar(10) DEFAULT NULL,
  `teo3name` varchar(255) DEFAULT NULL,
  `teo3pass` varchar(255) DEFAULT NULL,
  `teo3is` varchar(255) DEFAULT NULL,
  `teo3om` varchar(255) DEFAULT NULL,
  `teo3div` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `teacher_pro_qualification`
--

INSERT INTO `teacher_pro_qualification` (`personalno`, `teptpass`, `teptis`, `teptom`, `teptdiv`, `tebedpass`, `tebedis`, `tebedom`, `tebeddiv`, `temedpass`, `temedis`, `temedom`, `temeddiv`, `teo1name`, `teo1pass`, `teo1is`, `teo1om`, `teo1div`, `teo2name`, `teo2pass`, `teo2is`, `teo2om`, `teo2div`, `teo3name`, `teo3pass`, `teo3is`, `teo3om`, `teo3div`) VALUES
('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('123', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('890560', '', '', '', '', '', '', '', '', '2020-08', 'aiou', '900', 'a', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('89056090', '', '', '', '', '', '', '', '', '2020-08', 'aiou', '900', 'a', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('90091261', '2000-02', 'AIOU', '3200', 'b', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('900963', '', '', '', '', '', '', '', '', '2020-08', 'aiou', '900', 'a', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('900963897', '', '', '', '', '', '', '', '', '2020-08', 'aiou', '900', 'a', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('90096389700', '', '', '', '', '', '', '', '', '2020-08', 'aiou', '900', 'a', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('900963897000000', '', '', '', '', '', '', '', '', '2020-08', 'aiou', '900', 'a', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('9101020', '', 'ajk u', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('910102015667', '2024-01', 'ajk u', '3200', 'b', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('gggggggg', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `teacher_qualification`
--

CREATE TABLE `teacher_qualification` (
  `personalno` varchar(255) NOT NULL,
  `tesscpass` varchar(50) DEFAULT NULL,
  `tesscsub` varchar(255) DEFAULT NULL,
  `tesscuni` varchar(255) DEFAULT NULL,
  `tesscom` varchar(255) DEFAULT NULL,
  `tesscdiv` varchar(255) DEFAULT NULL,
  `tehscpass` varchar(50) DEFAULT NULL,
  `tehscsub` varchar(255) DEFAULT NULL,
  `tehscuni` varchar(255) DEFAULT NULL,
  `tehscom` varchar(255) DEFAULT NULL,
  `tehscdiv` varchar(255) DEFAULT NULL,
  `tebspass` varchar(50) DEFAULT NULL,
  `tebssub` varchar(255) DEFAULT NULL,
  `tebsuni` varchar(255) DEFAULT NULL,
  `tebsom` varchar(255) DEFAULT NULL,
  `tebsdiv` varchar(255) DEFAULT NULL,
  `temapass` varchar(50) DEFAULT NULL,
  `temasub` varchar(255) DEFAULT NULL,
  `temauni` varchar(255) DEFAULT NULL,
  `temaom` varchar(255) DEFAULT NULL,
  `temadiv` varchar(255) DEFAULT NULL,
  `temapass2` varchar(50) DEFAULT NULL,
  `temasub2` varchar(255) DEFAULT NULL,
  `temauni2` varchar(255) DEFAULT NULL,
  `temaom2` varchar(255) DEFAULT NULL,
  `temadiv2` varchar(255) DEFAULT NULL,
  `temapass3` varchar(50) DEFAULT NULL,
  `temasub3` varchar(255) DEFAULT NULL,
  `temauni3` varchar(255) DEFAULT NULL,
  `temaom3` varchar(255) DEFAULT NULL,
  `temadiv3` varchar(255) DEFAULT NULL,
  `temphillpass` varchar(50) DEFAULT NULL,
  `temphillsub` varchar(255) DEFAULT NULL,
  `temphilluni` varchar(255) DEFAULT NULL,
  `temphillom` varchar(255) DEFAULT NULL,
  `temphilldiv` varchar(255) DEFAULT NULL,
  `tephdpass` varchar(50) DEFAULT NULL,
  `tephdsub` varchar(255) DEFAULT NULL,
  `tephduni` varchar(255) DEFAULT NULL,
  `tephdom` varchar(255) DEFAULT NULL,
  `tephddiv` varchar(255) DEFAULT NULL,
  `teotherpass` varchar(50) DEFAULT NULL,
  `teothersub` varchar(255) DEFAULT NULL,
  `teotheruni` varchar(255) DEFAULT NULL,
  `teotherom` varchar(255) DEFAULT NULL,
  `teotherdiv` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `teacher_qualification`
--

INSERT INTO `teacher_qualification` (`personalno`, `tesscpass`, `tesscsub`, `tesscuni`, `tesscom`, `tesscdiv`, `tehscpass`, `tehscsub`, `tehscuni`, `tehscom`, `tehscdiv`, `tebspass`, `tebssub`, `tebsuni`, `tebsom`, `tebsdiv`, `temapass`, `temasub`, `temauni`, `temaom`, `temadiv`, `temapass2`, `temasub2`, `temauni2`, `temaom2`, `temadiv2`, `temapass3`, `temasub3`, `temauni3`, `temaom3`, `temadiv3`, `temphillpass`, `temphillsub`, `temphilluni`, `temphillom`, `temphilldiv`, `tephdpass`, `tephdsub`, `tephduni`, `tephdom`, `tephddiv`, `teotherpass`, `teothersub`, `teotheruni`, `teotherom`, `teotherdiv`) VALUES
('', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('1', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('123', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('890560', '2003-02', 'Science', 'AJKBISE', '400', 'c', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('89056090', '2003-02', 'Science', 'AJKBISE', '400', 'c', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('90091261', '0000-00-00', 'Science', 'AJKBISE', '629', 'A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('900963', '0000-00-00', 'Science', 'AJKBISE', '400', 'c', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('900963897', '2003-02', 'Science', 'AJKBISE', '400', 'c', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('90096389700', '2003-02', 'Science', 'AJKBISE', '400', 'c', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('900963897000000', '2003-02', 'Science', 'AJKBISE', '400', 'c', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('9101020', '0000-00-00', 'urdu', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('910102015667', '2024-01', 'urdu', 'AJKBISE', '629', 'A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('gggggggg', '2025-07-17', 'vv', 'vvvvvvvvvvvvv', '666', 'A (First Division)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

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

CREATE TABLE `teacher_subject` (
  `personalno` varchar(255) NOT NULL,
  `tesubject1` varchar(255) DEFAULT NULL,
  `teclass1` varchar(255) DEFAULT NULL,
  `teperiod1` int(11) DEFAULT NULL,
  `tesubject2` varchar(255) DEFAULT NULL,
  `teclass2` varchar(255) DEFAULT NULL,
  `teperiod2` int(11) DEFAULT NULL,
  `tesubject3` varchar(255) DEFAULT NULL,
  `teclass3` varchar(255) DEFAULT NULL,
  `teperiod3` int(11) DEFAULT NULL,
  `tesubject4` varchar(255) DEFAULT NULL,
  `teclass4` varchar(255) DEFAULT NULL,
  `teperiod4` int(11) DEFAULT NULL,
  `tesubject5` varchar(255) DEFAULT NULL,
  `teclass5` varchar(255) DEFAULT NULL,
  `teperiod5` int(11) DEFAULT NULL,
  `tesubject6` varchar(255) DEFAULT NULL,
  `teclass6` varchar(255) DEFAULT NULL,
  `teperiod6` int(11) DEFAULT NULL,
  `tesubject7` varchar(255) DEFAULT NULL,
  `teclass7` varchar(255) DEFAULT NULL,
  `teperiod7` int(11) DEFAULT NULL,
  `tesubject8` varchar(255) DEFAULT NULL,
  `teclass8` varchar(255) DEFAULT NULL,
  `teperiod8` int(11) DEFAULT NULL,
  `tesubject9` varchar(255) DEFAULT NULL,
  `teclass9` varchar(255) DEFAULT NULL,
  `teperiod9` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `teacher_subject`
--

INSERT INTO `teacher_subject` (`personalno`, `tesubject1`, `teclass1`, `teperiod1`, `tesubject2`, `teclass2`, `teperiod2`, `tesubject3`, `teclass3`, `teperiod3`, `tesubject4`, `teclass4`, `teperiod4`, `tesubject5`, `teclass5`, `teperiod5`, `tesubject6`, `teclass6`, `teperiod6`, `tesubject7`, `teclass7`, `teperiod7`, `tesubject8`, `teclass8`, `teperiod8`, `tesubject9`, `teclass9`, `teperiod9`) VALUES
('', '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0),
('1', '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0),
('123', '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0),
('890560', 'english', '8th', 6, 'computer', '9', 6, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0),
('89056090', 'english', '8th', 6, 'computer', '9', 6, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0),
('90091261', 'Computer', '11', 6, 'Computer', '12', 6, 'Computer', '10', 6, 'Computer', '9', 6, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0),
('900963', 'english', '8th', 6, 'computer', '9', 6, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0),
('900963897', 'english', '8th', 6, 'computer', '9', 6, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0),
('90096389700', 'english', '8th', 6, 'computer', '9', 6, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0),
('900963897000000', 'english', '8th', 6, 'computer', '9', 6, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0),
('910102015667', 'Computer', '9th', 1, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0),
('gggggggg', '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0);

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

--
-- Table structure for table `teacher_training`
--

CREATE TABLE `teacher_training` (
  `personalno` varchar(255) NOT NULL,
  `tr1name` varchar(255) DEFAULT NULL,
  `tr1year` varchar(50) DEFAULT NULL,
  `tr1institute` varchar(255) DEFAULT NULL,
  `tr1place` varchar(255) DEFAULT NULL,
  `tr1duration` varchar(10) DEFAULT NULL,
  `tr2name` varchar(255) DEFAULT NULL,
  `tr2year` varchar(50) DEFAULT NULL,
  `tr2institute` varchar(255) DEFAULT NULL,
  `tr2place` varchar(255) DEFAULT NULL,
  `tr2duration` varchar(10) DEFAULT NULL,
  `tr3name` varchar(255) DEFAULT NULL,
  `tr3year` varchar(50) DEFAULT NULL,
  `tr3institute` varchar(255) DEFAULT NULL,
  `tr3place` varchar(255) DEFAULT NULL,
  `tr3duration` varchar(10) DEFAULT NULL,
  `tr4name` varchar(255) DEFAULT NULL,
  `tr4year` varchar(50) DEFAULT NULL,
  `tr4institute` varchar(255) DEFAULT NULL,
  `tr4place` varchar(255) DEFAULT NULL,
  `tr4duration` varchar(10) DEFAULT NULL,
  `tr5name` varchar(255) DEFAULT NULL,
  `tr5year` varchar(50) DEFAULT NULL,
  `tr5institute` varchar(255) DEFAULT NULL,
  `tr5place` varchar(255) DEFAULT NULL,
  `tr5duration` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `teacher_training`
--

INSERT INTO `teacher_training` (`personalno`, `tr1name`, `tr1year`, `tr1institute`, `tr1place`, `tr1duration`, `tr2name`, `tr2year`, `tr2institute`, `tr2place`, `tr2duration`, `tr3name`, `tr3year`, `tr3institute`, `tr3place`, `tr3duration`, `tr4name`, `tr4year`, `tr4institute`, `tr4place`, `tr4duration`, `tr5name`, `tr5year`, `tr5institute`, `tr5place`, `tr5duration`) VALUES
('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('123', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('890560', 'ajk', '2010-02', 'ajjkbise', 'basji', '2 month', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('89056090', 'ajk', '2010-02', 'ajjkbise', 'basji', '2 month', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('90091261', 'industion', '0000-00-00', 'bise', '', '', '', '0000-00-00', '', '', '', '', '0000-00-00', '', '', '', '', '0000-00-00', '', '', '', '', '0000-00-00', '', '', ''),
('900963', 'ajk', '0000-00-00', 'ajjkbise', 'basji', '2 month', '', '0000-00-00', '', '', '', '', '0000-00-00', '', '', '', '', '0000-00-00', '', '', '', '', '0000-00-00', '', '', ''),
('900963897', 'ajk', '0000-00-00', 'ajjkbise', 'basji', '2 month', '', '0000-00-00', '', '', '', '', '0000-00-00', '', '', '', '', '0000-00-00', '', '', '', '', '0000-00-00', '', '', ''),
('90096389700', 'ajk', '2010-02', 'ajjkbise', 'basji', '2 month', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('900963897000000', 'ajk', '2010-02', 'ajjkbise', 'basji', '2 month', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('910102015667', 'industion', '2024-02', 'ajjkbise', 'basji', '2 month', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('gggggggg', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `teacher_transfer`
--

CREATE TABLE `teacher_transfer` (
  `personalno` varchar(255) NOT NULL,
  `tetfrom1` varchar(255) DEFAULT NULL,
  `toto1` varchar(255) DEFAULT NULL,
  `tetreason1` varchar(255) DEFAULT NULL,
  `tetdate1` date DEFAULT NULL,
  `tetfrom2` varchar(255) DEFAULT NULL,
  `toto2` varchar(255) DEFAULT NULL,
  `tetreason2` varchar(255) DEFAULT NULL,
  `tetdate2` date DEFAULT NULL,
  `tetfrom3` varchar(255) DEFAULT NULL,
  `toto3` varchar(255) DEFAULT NULL,
  `tetreason3` varchar(255) DEFAULT NULL,
  `tetdate3` date DEFAULT NULL,
  `tetfrom4` varchar(255) DEFAULT NULL,
  `toto4` varchar(255) DEFAULT NULL,
  `tetreason4` varchar(255) DEFAULT NULL,
  `tetdate4` date DEFAULT NULL,
  `tetfrom5` varchar(255) DEFAULT NULL,
  `toto5` varchar(255) DEFAULT NULL,
  `tetreason5` varchar(255) DEFAULT NULL,
  `tetdate5` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `teacher_transfer`
--

INSERT INTO `teacher_transfer` (`personalno`, `tetfrom1`, `toto1`, `tetreason1`, `tetdate1`, `tetfrom2`, `toto2`, `tetreason2`, `tetdate2`, `tetfrom3`, `toto3`, `tetreason3`, `tetdate3`, `tetfrom4`, `toto4`, `tetreason4`, `tetdate4`, `tetfrom5`, `toto5`, `tetreason5`, `tetdate5`) VALUES
('', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00'),
('1', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00'),
('123', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00'),
('890560', 'bhhs dhanwan', 'bhs chowki', '', '2020-10-20', '', '', '', '2024-01-18', '', '', '', '2024-01-16', '', '', '', '2024-01-08', '', '', '', '2024-01-08'),
('89056090', 'bhhs dhanwan', 'bhs chowki', '', '2020-10-20', 'bhhs dhanwan', 'bhhs dhanwan', '', '2024-01-18', '', '', '', '2024-01-16', '', '', '', '2024-01-08', '', '', '', '2024-01-08'),
('90091261', 'BHS Chatroh', 'BHSS Dhanwan', '', '2019-07-13', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00'),
('900963', 'bhhs dhanwan', 'bhs chowki', '', '2020-10-20', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00'),
('900963897', 'bhhs dhanwan', 'bhs chowki', '', '2020-10-20', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00'),
('90096389700', 'bhhs dhanwan', 'bhs chowki', '', '2020-10-20', '', '', '', '2024-01-18', '', '', '', '2024-01-16', '', '', '', '2024-01-08', '', '', '', '2024-01-08'),
('900963897000000', 'bhhs dhanwan', 'bhs chowki', '', '2020-10-20', '', '', '', '2024-01-18', '', '', '', '2024-01-16', '', '', '', '2024-01-08', '', '', '', '2024-01-08'),
('910102015667', 'bhhs dhanwan', 'bhs chowki', '555', '2024-01-08', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00'),
('gggggggg', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00', '', '', '', '0000-00-00');

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

--
-- Table structure for table `tehsils`
--

CREATE TABLE `tehsils` (
  `tehsil_id` int(10) NOT NULL,
  `tehsil_name` varchar(50) NOT NULL,
  `district_id` int(10) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=Active | 0=Inactive'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tehsils`
--

INSERT INTO `tehsils` (`tehsil_id`, `tehsil_name`, `district_id`, `status`) VALUES
(1, 'Kotli', 1, 1),
(2, 'Fatehpur', 1, 1),
(3, 'Khuirata', 1, 1),
(4, 'Charhoi', 1, 1),
(5, 'Dulya Jattan', 1, 1),
(6, 'Sehansa', 1, 1),
(7, 'Mirpur', 2, 1),
(8, 'Dadyal', 2, 1),
(9, 'Bhimber', 3, 1),
(10, 'Barnala', 3, 1),
(11, 'Samahni', 3, 1),
(12, 'Abbaspur', 4, 1),
(13, 'Hajira', 4, 1),
(14, 'Rawalakot', 4, 1),
(15, 'Thorar', 4, 1),
(16, 'Bagh', 5, 1),
(17, 'Dhirkot', 5, 1),
(18, 'Hari Ghel', 5, 1),
(19, 'Rera', 5, 1),
(20, 'Birpani', 5, 1),
(21, 'Haveli', 6, 1),
(22, 'Khurshidabad', 6, 1),
(23, 'Mumtazabad', 6, 1),
(24, 'Muzaffarabad', 7, 1),
(25, 'Patika (Naseerabad)', 7, 1),
(26, 'Athmuqam', 8, 1),
(27, 'Sharda', 8, 1),
(28, 'Hattian Bala', 9, 1),
(29, 'Chikar', 9, 1),
(30, 'Leepa', 9, 1),
(31, 'Balouch', 10, 1),
(32, 'Trarkhal', 10, 1),
(33, 'Mang', 10, 1),
(34, 'Palandri', 10, 1);

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

--
-- Table structure for table `time_scales`
--

CREATE TABLE `time_scales` (
  `ts_id` int(11) NOT NULL,
  `ts_name` varchar(10) NOT NULL,
  `ts_label` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `time_scales`
--

INSERT INTO `time_scales` (`ts_id`, `ts_name`, `ts_label`, `created_at`, `updated_at`) VALUES
(1, 'TS-1', 'Time Scale 1', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(2, 'TS-2', 'Time Scale 2', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(3, 'TS-3', 'Time Scale 3', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(4, 'TS-4', 'Time Scale 4', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(5, 'TS-5', 'Time Scale 5', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(6, 'TS-6', 'Time Scale 6', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(7, 'TS-7', 'Time Scale 7', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(8, 'TS-8', 'Time Scale 8', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(9, 'TS-9', 'Time Scale 9', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(10, 'TS-10', 'Time Scale 10', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(11, 'TS-11', 'Time Scale 11', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(12, 'TS-12', 'Time Scale 12', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(13, 'TS-13', 'Time Scale 13', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(14, 'TS-14', 'Time Scale 14', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(15, 'TS-15', 'Time Scale 15', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(16, 'TS-16', 'Time Scale 16', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(17, 'TS-17', 'Time Scale 17', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(18, 'TS-18', 'Time Scale 18', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(19, 'TS-19', 'Time Scale 19', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(20, 'TS-20', 'Time Scale 20', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(21, 'TS-21', 'Time Scale 21', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(22, 'TS-22', 'Time Scale 22', '2025-07-14 04:28:41', '2025-07-14 04:28:41'),
(23, 'TS-23', 'Time Scale 23', '2025-07-14 04:28:41', '2025-07-14 04:28:41');

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

--
-- Table structure for table `transfer_reasons`
--

CREATE TABLE `transfer_reasons` (
  `reason_id` int(11) NOT NULL,
  `reason_code` varchar(20) NOT NULL,
  `reason_name` varchar(50) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transfer_reasons`
--

INSERT INTO `transfer_reasons` (`reason_id`, `reason_code`, `reason_name`, `description`, `is_active`) VALUES
(1, 'ADMIN', 'Administrative', 'Administrative transfer initiated by education department', 1),
(2, 'MUTUAL', 'Mutual Transfer', 'Mutual exchange between teachers', 1),
(3, 'PROMOTION', 'Promotion', 'Transfer due to promotion to higher position', 1),
(4, 'PERSONAL', 'Personal Request', 'Transfer requested for personal reasons', 1),
(5, 'OTHER', 'Other', 'Other unspecified reasons', 1);

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

--
-- Table structure for table `union_councils`
--

CREATE TABLE `union_councils` (
  `uc_id` int(11) NOT NULL,
  `uc_name` varchar(50) NOT NULL,
  `cons_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=Active | 0=Inactive'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `union_councils`
--

INSERT INTO `union_councils` (`uc_id`, `uc_name`, `cons_id`, `status`) VALUES
(1, 'Kotli City', 1, 1),
(2, 'Dungi', 1, 1),
(3, 'Khuiratta', 1, 1),
(4, 'Seri', 1, 1),
(5, 'Fatehpur Thakyala', 1, 1),
(6, 'Sehnsa', 2, 1),
(7, 'Fatehpur Thakyala', 2, 1),
(8, 'Khari Sharif', 2, 1),
(9, 'Dhakku', 2, 1),
(10, 'Bandi', 2, 1),
(11, 'Tatrinote', 3, 1),
(12, 'Fatehpur Thakyala', 3, 1),
(13, 'Kharick', 3, 1),
(14, 'Charhoi', 3, 1),
(15, 'Trar Dewa', 3, 1),
(16, 'Tharkhal', 4, 1),
(17, 'Fatehpur Thakyala Town', 4, 1),
(18, 'Dungi', 4, 1),
(19, 'Khuiratta', 4, 1),
(20, 'Bandi', 4, 1),
(21, 'Khui Gala', 4, 1),
(22, 'Barmang', 4, 1),
(23, 'Banjosa', 4, 1),
(24, 'Khuiratta (Main Town)', 5, 1),
(25, 'Dara Sher Khan', 5, 1),
(26, 'Bandi', 5, 1),
(27, 'Dhakku', 5, 1),
(28, 'Bandi', 5, 1),
(29, 'Bharandi', 5, 1),
(30, 'Khuiratta Bala', 5, 1),
(31, 'Khuiratta Payan', 5, 1),
(32, 'Fatehpur Thakiala', 5, 1),
(33, 'Charhoi', 6, 1),
(34, 'Khuiratta', 6, 1),
(35, 'Trar Dewan', 6, 1),
(36, 'Dara Sher Khan', 6, 1),
(37, 'Charhoi', 7, 1),
(38, 'Khuiratta', 7, 1),
(39, 'Trar Dewan', 7, 1),
(40, 'Dara Sher Khan', 7, 1),
(41, 'Charhoi', 8, 1),
(42, 'Khuiratta', 8, 1),
(43, 'Trar Dewan', 8, 1),
(44, 'Dara Sher Khan', 8, 1),
(45, 'Dulya Jattan (Main town)', 9, 1),
(46, 'Khuiratta', 9, 1),
(47, 'Bandi', 9, 1),
(48, 'Nakra', 9, 1),
(49, 'Seri', 9, 1),
(50, 'Bheri', 9, 1),
(51, 'Khui Dullah Jattan', 9, 1),
(52, 'Khuiratta', 10, 1),
(53, 'Barali', 10, 1),
(54, 'Bandi Sehnsa', 10, 1),
(55, 'Sehnsa town', 10, 1),
(56, 'Dharoti', 10, 1),
(57, 'Fatehpur Thakyala', 11, 1),
(58, 'Tharkhal', 11, 1),
(59, 'Bandi Sehnsa', 11, 1);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `cnic` varchar(13) NOT NULL,
  `mobile` varchar(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `cnic`, `mobile`, `created_at`) VALUES
(1, '8120240197121', '03435115550', '2024-08-07 08:08:32');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `bps`
--
ALTER TABLE `bps`
  ADD PRIMARY KEY (`bps_id`);

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

--
-- Indexes for table `class`
--
ALTER TABLE `class`
  ADD PRIMARY KEY (`class_id`) USING BTREE;

--
-- Indexes for table `constituency`
--
ALTER TABLE `constituency`
  ADD PRIMARY KEY (`cons_id`),
  ADD KEY `tehsil_id` (`tehsil_id`);

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

--
-- Indexes for table `designations`
--
ALTER TABLE `designations`
  ADD PRIMARY KEY (`des_id`);

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`district_id`);

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

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

--
-- Indexes for table `next_kin`
--
ALTER TABLE `next_kin`
  ADD PRIMARY KEY (`relationship_id`),
  ADD UNIQUE KEY `relationship_name` (`relationship_name`);

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

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

--
-- Indexes for table `quota`
--
ALTER TABLE `quota`
  ADD PRIMARY KEY (`quota_id`),
  ADD UNIQUE KEY `quota_type` (`quota_type`);

--
-- Indexes for table `registrations`
--
ALTER TABLE `registrations`
  ADD PRIMARY KEY (`emis_code`),
  ADD KEY `cate_id` (`cate_id`),
  ADD KEY `level_id` (`level_id`);

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

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

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

--
-- Indexes for table `school_cate`
--
ALTER TABLE `school_cate`
  ADD PRIMARY KEY (`cate_id`);

--
-- Indexes for table `school_emis`
--
ALTER TABLE `school_emis`
  ADD PRIMARY KEY (`emis_code`),
  ADD KEY `level_id` (`level_id`),
  ADD KEY `cate_id` (`cate_id`);

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

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

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

--
-- Indexes for table `school_level`
--
ALTER TABLE `school_level`
  ADD PRIMARY KEY (`level_id`);

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

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

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

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

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

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

--
-- Indexes for table `student_information`
--
ALTER TABLE `student_information`
  ADD PRIMARY KEY (`stbfno`),
  ADD KEY `cate_id` (`cate_id`),
  ADD KEY `cons_id` (`cons_id`),
  ADD KEY `district_id` (`district_id`),
  ADD KEY `tehsil_id` (`tehsil_id`),
  ADD KEY `uc_id` (`uc_id`),
  ADD KEY `emis_code` (`emis_code`),
  ADD KEY `level_id` (`level_id`),
  ADD KEY `classadm` (`classadm`),
  ADD KEY `stclass` (`stclass`);

--
-- Indexes for table `subjects`
--
ALTER TABLE `subjects`
  ADD PRIMARY KEY (`subj_id`),
  ADD UNIQUE KEY `subj_name` (`subj_name`);

--
-- Indexes for table `subject_group`
--
ALTER TABLE `subject_group`
  ADD PRIMARY KEY (`group_id`);

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

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

--
-- Indexes for table `teacher_profile`
--
ALTER TABLE `teacher_profile`
  ADD PRIMARY KEY (`personalno`);

--
-- Indexes for table `teacher_promotion`
--
ALTER TABLE `teacher_promotion`
  ADD PRIMARY KEY (`personalno`);

--
-- Indexes for table `teacher_pro_qualification`
--
ALTER TABLE `teacher_pro_qualification`
  ADD PRIMARY KEY (`personalno`);

--
-- Indexes for table `teacher_qualification`
--
ALTER TABLE `teacher_qualification`
  ADD PRIMARY KEY (`personalno`);

--
-- Indexes for table `teacher_subject`
--
ALTER TABLE `teacher_subject`
  ADD PRIMARY KEY (`personalno`);

--
-- Indexes for table `teacher_training`
--
ALTER TABLE `teacher_training`
  ADD PRIMARY KEY (`personalno`);

--
-- Indexes for table `teacher_transfer`
--
ALTER TABLE `teacher_transfer`
  ADD PRIMARY KEY (`personalno`);

--
-- Indexes for table `tehsils`
--
ALTER TABLE `tehsils`
  ADD PRIMARY KEY (`tehsil_id`),
  ADD KEY `district_id` (`district_id`);

--
-- Indexes for table `time_scales`
--
ALTER TABLE `time_scales`
  ADD PRIMARY KEY (`ts_id`);

--
-- Indexes for table `transfer_reasons`
--
ALTER TABLE `transfer_reasons`
  ADD PRIMARY KEY (`reason_id`),
  ADD UNIQUE KEY `reason_code` (`reason_code`);

--
-- Indexes for table `union_councils`
--
ALTER TABLE `union_councils`
  ADD PRIMARY KEY (`uc_id`),
  ADD KEY `cons_id` (`cons_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `bps`
--
ALTER TABLE `bps`
  MODIFY `bps_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

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

--
-- AUTO_INCREMENT for table `class`
--
ALTER TABLE `class`
  MODIFY `class_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `constituency`
--
ALTER TABLE `constituency`
  MODIFY `cons_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

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

--
-- AUTO_INCREMENT for table `designations`
--
ALTER TABLE `designations`
  MODIFY `des_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `districts`
--
ALTER TABLE `districts`
  MODIFY `district_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `school_cate`
--
ALTER TABLE `school_cate`
  MODIFY `cate_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

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

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

--
-- AUTO_INCREMENT for table `school_level`
--
ALTER TABLE `school_level`
  MODIFY `level_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `subjects`
--
ALTER TABLE `subjects`
  MODIFY `subj_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `subject_group`
--
ALTER TABLE `subject_group`
  MODIFY `group_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

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

--
-- AUTO_INCREMENT for table `tehsils`
--
ALTER TABLE `tehsils`
  MODIFY `tehsil_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `time_scales`
--
ALTER TABLE `time_scales`
  MODIFY `ts_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

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

--
-- AUTO_INCREMENT for table `union_councils`
--
ALTER TABLE `union_councils`
  MODIFY `uc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `attendance`
--
ALTER TABLE `attendance`
  ADD CONSTRAINT `attendance_ibfk_1` FOREIGN KEY (`teacher_id`) REFERENCES `teachers` (`id`);

--
-- Constraints for table `constituency`
--
ALTER TABLE `constituency`
  ADD CONSTRAINT `constituency_ibfk_1` FOREIGN KEY (`tehsil_id`) REFERENCES `tehsils` (`tehsil_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `registrations`
--
ALTER TABLE `registrations`
  ADD CONSTRAINT `registrations_ibfk_1` FOREIGN KEY (`cate_id`) REFERENCES `school_cate` (`cate_id`),
  ADD CONSTRAINT `registrations_ibfk_2` FOREIGN KEY (`level_id`) REFERENCES `school_level` (`level_id`);

--
-- Constraints for table `room_details`
--
ALTER TABLE `room_details`
  ADD CONSTRAINT `room_details_ibfk_1` FOREIGN KEY (`building_id`) REFERENCES `building_details` (`id`);

--
-- Constraints for table `school_emis`
--
ALTER TABLE `school_emis`
  ADD CONSTRAINT `school_emis_ibfk_1` FOREIGN KEY (`cate_id`) REFERENCES `school_cate` (`cate_id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `school_emis_ibfk_2` FOREIGN KEY (`level_id`) REFERENCES `school_level` (`level_id`) ON UPDATE CASCADE;

--
-- Constraints for table `student_information`
--
ALTER TABLE `student_information`
  ADD CONSTRAINT `student_information_ibfk_1` FOREIGN KEY (`emis_code`) REFERENCES `school_emis` (`emis_code`) ON UPDATE CASCADE,
  ADD CONSTRAINT `student_information_ibfk_10` FOREIGN KEY (`classadm`) REFERENCES `class` (`class_id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `student_information_ibfk_2` FOREIGN KEY (`level_id`) REFERENCES `school_level` (`level_id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `student_information_ibfk_3` FOREIGN KEY (`cate_id`) REFERENCES `school_cate` (`cate_id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `student_information_ibfk_4` FOREIGN KEY (`uc_id`) REFERENCES `union_councils` (`uc_id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `student_information_ibfk_5` FOREIGN KEY (`cons_id`) REFERENCES `constituency` (`cons_id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `student_information_ibfk_6` FOREIGN KEY (`tehsil_id`) REFERENCES `tehsils` (`tehsil_id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `student_information_ibfk_7` FOREIGN KEY (`district_id`) REFERENCES `districts` (`district_id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `student_information_ibfk_9` FOREIGN KEY (`stclass`) REFERENCES `class` (`class_id`) ON UPDATE CASCADE;

--
-- Constraints for table `tehsils`
--
ALTER TABLE `tehsils`
  ADD CONSTRAINT `tehsils_ibfk_1` FOREIGN KEY (`district_id`) REFERENCES `districts` (`district_id`) ON UPDATE CASCADE;

--
-- Constraints for table `union_councils`
--
ALTER TABLE `union_councils`
  ADD CONSTRAINT `union_councils_ibfk_1` FOREIGN KEY (`cons_id`) REFERENCES `constituency` (`cons_id`);
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 */;
