-- MySQL dump 10.13  Distrib 5.5.62, for linux-glibc2.12 (x86_64)
--
-- Host: localhost    Database: waqfmaha
-- ------------------------------------------------------
-- Server version	5.5.62

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `wmr_medical_leaves`
--

DROP TABLE IF EXISTS `wmr_medical_leaves`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wmr_medical_leaves` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `months` varchar(33) NOT NULL,
  `year` varchar(33) NOT NULL,
  `date` varchar(33) NOT NULL,
  `employee_name` varchar(33) NOT NULL,
  `type_leave` varchar(33) NOT NULL,
  `date_leave` varchar(33) NOT NULL,
  `date_expiry` varchar(33) NOT NULL,
  `remarks` longtext NOT NULL,
  `session_username` varchar(33) NOT NULL,
  `timestamp` varchar(33) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wmr_medical_leaves`
--

LOCK TABLES `wmr_medical_leaves` WRITE;
/*!40000 ALTER TABLE `wmr_medical_leaves` DISABLE KEYS */;
INSERT INTO `wmr_medical_leaves` VALUES (3,'October','1','10/20/2018','Qazi Abdul Hakeem, Jr.Asst.','Medical Leave','07/09/2018','18/09/2018','Medical Leave w.e.f. 07-09-2018 to 18-09-2018 (12) days.','syedmohammed','1540813298'),(4,'November','1','01-11-2018','Mohd. Ahmed Ali, Office Subordina','Earned Leave','29/10/2018','31/10/2018','Earned Leave with effect from 29-10-2018 to 31-10-2018','syedmohammed','1541059194'),(5,'November','1','01-11-2018','Mohammad Khan, Office Subordinate','Earned Leave','14/112018','06/12//2018','Earned Leave with effect from 14-11-2018 to 06-12-2018 proceed to Umrah.','syedmohammed','1541066951'),(6,'November','1','02-11-2018','Qazi Mohd. Ikramullah','Loss of pay','10/04/2018','31/12/2018','Sri Qazi Mohd. Ikramullah, Nazirul Qazath applied leave on loss of pay.','syedmohammed','1541154140'),(7,'November','1','03-11-2018','Mohd. Jameel Ahmed, O/S. Warangal','Earned Leave','18/08/2018','30/09/2018','Earned Leave with effect from 18-08-2018 to 30-09-2018','syedmohammed','1541242633'),(8,'November','1','09-11-2018','Mohd. Ahmed Ali, Office Subordina','Earned Leave','15/11/2018','20/11/2018','Earned Leave','syedmohammed','1541760056'),(9,'November','1','12-11-2018','Mazhar Shareef, Office Subordinat','Medical','18/04/2017','15/11/2018','Sri Khaja Najmuddin, I.A.Waqf, Kareem Nagar/ Jagtiyal District submitted the report on the individual frequently applying for medical leave from 18-04-2017 and extending time to time upto 15-11-2018','syedmohammed','1542003394'),(10,'December','1','03/12/2020','Mohd Abdul Subhan','Earned Leave','05/12/2020','16/12/2020','Earned Leave sanctioned vide proceedings No. E2/11/2010, dated: 03-12-2020.','obaid','1613628709'),(11,'December','1','18/02/2021','Mirza Lutf-e-Hussain, Jr. Asst, C','Loss of Pay','07/10/2020','06/04/2021','(06) months leave sanctioned on loss of pay vide proceedings No. E3/132/2013, dated: 19/11/2020','obaid','1613628909'),(12,'February','1','18/02/2021','Sri. Syed Ajaz, Office Subordinat','Paternity Leave','16/11/2020','30/11/2020','Paternity leave sanctioned to individual vide proceedings No. E2/85/2011, dated: 08-12-2020.','obaid','1613629058'),(13,'January','1','09-02-2022','Rayeesa Sultana, OSD-III','Earned Leave','01/17/2022','01/25/2022','File is under process','aiasalabath','1644397452'),(14,'January','1','09-02-2022','M.A. Jabbar, Sr.Asst.,','Commuted Leave','01/17/2022','01/23/2022','File is under process','aiasalabath','1644397499'),(15,'March','1','03/11/2024','Mohammed Asadullah Khan','Earned Leave','03/26/2024','04/10/2024','As per this office Proc. No. E1/13/2019. dated: 11-03-2024','gkhan','1714816277'),(16,'March','1','03/20/2024','Smt. Rayeesa Sultana, Tahsildar','Earned Leave','11/25/2023','12/22/2023','(07) days Earned Leave on various dates 25-11-2023, 12-12-2023, 13-12-2023, 14-12-2023, 18-12-2023, 21-12-2023, 22-12-2023, sanction vide this office Proc. No. E1/19/2021, Dt: 20-03-2024','gkhan','1714816409'),(17,'March','1','03/20/2024','Sri Sameem Arif','Earned Leave','11/08/2023','12/16/2023','(05) days earned leave was sanctioned on various dates 08-11-2023, 09-11-2023, 14-12-2023, 15-12-2023, 16-12-2023, vide this office proc. No. E1/19/2021, Dt: 20-03-2024','gkhan','1714816565'),(18,'March','1','03/11/2024','Sri Mohammed Ghouse Uddin Khan','Earned Leave','03/26/2024','04/10/2024','(16) days Earned Leave sanctioned vide Proc. No. E2/06/2012, Dt: 11-03-2024','gkhan','1714816639'),(19,'March','1','04-05-2024','Sri Ahmed Inayath Ali Salabath','Earned Leave','01/18/2024','02/23/2024','(12) days Earned Leave Sanction vide this office Proc. No. E2/09/2007, Dt: 20-03-2024 on various dates 18-01-2024, \n23-01-2024,  25-01-2024, 08-02-2024 to 14-02-2024, \n22-02-2024  23-02-2024','gkhan','1714816710'),(20,'March','1','03/20/2024','Sri Mohd. Abdul Subhan, Sr. Asst','Earned Leave','12/29/2023','01/05/2024','(08) days Earned Leave Sanctioned vide this office Proc. No. E1/19/2021, Dt: 20-03-2024','gkhan','1714816794'),(21,'March','1','03/20/2024','Sri Syed Asad Hussain Tirmizi, Sr','Earned Leave','12/30/2023','12/30/2023','(1) day Earned Leave was sanctioned Proc. No. E1/19/2021, Dt: 20-03-2024.','gkhan','1714816854'),(22,'March','1','03/19/2024','Sri Mohammed Ghouse Uddin, Driver','Earned Leave','03/26/2024','04/10/2024','(16) days Earned Leave was sanctioned vide this office Proc. No. E2/122/2006, Dt: 19-03-2024','gkhan','1714816919'),(23,'March','1','03/07/2024','Sri. Syed Siraj Uddin, Office Sub','Earned Leave','11/01/2023','01/21/2024','(82) days Earned Leave vide Proc. No. E2/09/2016, Dt: 07-03-2024.','gkhan','1714816982'),(24,'January','1','01/02/2024','Mohammed Sadath, Tahsildar','Earned Leave','01/08/2024','01/25/2024','18 days Earned Leave sanctioned vide this office Proc. No. E1/07/2023-S dated: 02-01-2024','gkhan','1714817182'),(26,'January','1','04-05-2024','Rayeesa Sultana, OSD','Earned Leave','09/05/2023','10/17/2023','04 day Earned leave sanction on various dates 05/09/2023, 14/09/2023, 19-09-2023','admin_prot','1714819380'),(27,'January','1','01/30/2024','Mohammed Ali','Earned Leave','12/01/2023','12/12/2023','06 days Earned Leave sanction vide Proc.No E2/77/2017 Dt: 30-01-2024','admin_prot','1714819629'),(28,'January','1','01/18/2024','Syed jaleel Ahmed Sr. Asst','Earned Leave','01/27/2024','02/24/2024','06 day Earned Leave sanction vide Proc.No E2/94/2006-s Dt : 18/01/2024','admin_prot','1714819936'),(29,'January','1','05/09/2024','M.A Muqeet','Earned Leave','09/21/2023','05/09/2024','4 Days Earned Leave Sanctioned on various dates 21/08/2023, 23/08/2024, 04/09/2023, 09/10/2023 Vide This Office Proc. No. E1/19/2021 Dated: 09-01-2024','admin_prot','1714820267'),(30,'January','1','01/09/2024','Mohd Irshad Ali','Earned Leave','08/16/2023','08/23/2023','4 Days Earned Leave Sanctioned on various dates 16/08/2023, 18/08/2023, 21/08/2023, 23/08/2023 Vide This Office Proc. No. E1/19/2021 Dated: 09-01-2024','admin_prot','1714820528'),(31,'January','1','01/09/2024','Mohd Farooq','Earned Leave','10/17/2023','11/05/2023','20 Days Earned Leave Sanctioned Vide This Office Proc. No. E1/19/2021 Dated: 09-01-2024','admin_prot','1714820752'),(32,'September','1','11/15/2023','Rayeesa Sultana, OSD','Earned Leave','09/05/2023','09/19/2023','2 Days Earned Leave Sanctioned  Vide This Office Proc. No. E1/19/2021 Dated: 15-11-2023','admin_prot','1714821610'),(33,'August','1','11-15-2023','Mohammed Irshad (OS)','Earned Leave','07/16/2023','07/23/2023','3 Days Earned Leave Sanctioned on various dates 16/07/2023, 18/07/2023, 21/07/2023, 23/10/2023 Vide This Office Proc. No. E1/19/2021 Dated: 05/11/2023','admin_prot','1714822067'),(34,'June','1','08/03/2023','Sameem Aif  A.S','Earned Leave','06/21/2023','06/22/2023','2 Days Earned Leave Sanctioned on various dates 21/06/2023, 22/06/2024,  Vide This Office Proc. No. E1/19/2021 Dated: 03-08-2024','admin_prot','1714822333'),(35,'June','1','08/03/2023','Mohd ghouse Uddin Khan Sr. Asst','Earned Leave','06/03/2023','06/03/2023','1 Days Earned Leave Sanctioned Vide This Office Proc. No. E1/19/2021 Dated: 03-08-2023','admin_prot','1714822536'),(36,'June','1','08/03/2023','Rayeesa Sultana, OSD','Earned Leave','06/30/2023','06/30/2023','01 Day Earned Leave Sanction This office Proc. No.E1/19/2021','admin_prot','1714824318'),(37,'May','1','08/03/2023','Sameem Aif  A.S','Earned Leave','05/11/2023','05/25/2023','15 Day Earned Leave Sanction This office Proc. No.E1/19/2021 Dt: 03/08/2023','admin_prot','1714824594'),(38,'April','1','08/03/2023','Sameem Aif  A.S','Earned Leave','04/27/2023','04/29/2023','04 Day Earned Leave Sanction This office Proc. No.E1/19/2021 Dt: 03-08-2023','admin_prot','1714824729'),(39,'November','1','11/15/2023','Mohd Farooq','Earned Leave','11/01/2023','11/05/2023','05 Day Earned Leave Sanction This office Proc. No.E1/19/2021','admin_prot','1714824901'),(40,'October','1','11/15/2023','Rayeesa Sultana, OSD','Earned Leave','10/17/2023','10/17/2023','01 day Earned leave sanction This office Proc.No : E1/19/2023 Dt: 15/11/2023','admin_prot','1714825107'),(41,'October','1','11/15/2023','Mohd Farooq','Earned Leave','10/17/2023','10/31/2023','15 day Earned leave sanction This office Proc.No : E1/19/2023 Dt: 15/11/2023','admin_prot','1714825270'),(42,'September','1','11/15/2023','M.A Muqeet','Earned Leave','09/04/2023','09/04/2024','01 day Earned leave sanction This office Proc.No : E1/19/2021 Dt: 15/11/2023','admin_prot','1714825428'),(43,'September','1','09/21/2023','M.A Rahman Owais Sr.Asst','Earned Leave','09/25/2023','09/30/2023','06 day Earned leave sanction This office Proc.No : E1/19/2006-S Dt: 21/09/2023','admin_prot','1714825654'),(44,'September','1','09/21/2023','Mohammed Ghouse Uddin Khan','Earned Leave','09/25/2023','09/30/2023','16 day Earned leave sanction This office Proc.No : E2/91/2006-S Dt: 21/09/2023','admin_prot','1714825834');
/*!40000 ALTER TABLE `wmr_medical_leaves` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-08-13 22:00:30
