-- MySQL dump 10.13  Distrib 5.5.62, for linux-glibc2.12 (x86_64)
--
-- Host: localhost    Database: waqfdb
-- ------------------------------------------------------
-- 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 `qz_online_khula_certificate_reissue`
--

DROP TABLE IF EXISTS `qz_online_khula_certificate_reissue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qz_online_khula_certificate_reissue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `basic_details_id` varchar(33) NOT NULL,
  `old_khula_id` varchar(33) NOT NULL,
  `uniqid` varchar(33) NOT NULL,
  `app_rf` varchar(33) NOT NULL,
  `app_type` varchar(33) NOT NULL,
  `issue_no` varchar(33) NOT NULL,
  `apply_from` varchar(33) NOT NULL,
  `dulha_name` varchar(33) NOT NULL,
  `dulha_fname` varchar(33) NOT NULL,
  `dulha_age` varchar(33) NOT NULL,
  `dulha_dob` varchar(33) NOT NULL,
  `dulha_nationality` varchar(33) NOT NULL,
  `dulha_occupation` varchar(33) NOT NULL,
  `dulha_resident` varchar(33) NOT NULL,
  `dulha_address` longtext NOT NULL,
  `dulha_foriegn_address` longtext NOT NULL,
  `dulhan_name` varchar(33) NOT NULL,
  `dulhan_fname` varchar(33) NOT NULL,
  `dulhan_age` varchar(33) NOT NULL,
  `dulhan_dob` varchar(33) NOT NULL,
  `dulhan_nationality` varchar(33) NOT NULL,
  `dulhan_occupation` varchar(33) NOT NULL,
  `dulhan_apply_from` varchar(33) NOT NULL,
  `dulhan_resident` longtext NOT NULL,
  `dulhan_address` longtext NOT NULL,
  `dulhan_foriegn_address` longtext NOT NULL,
  `months` varchar(33) NOT NULL,
  `year` varchar(33) NOT NULL,
  `date` varchar(33) NOT NULL,
  `date_khula` varchar(33) NOT NULL,
  `date_issue_khula` varchar(33) NOT NULL,
  `qazzath_no` varchar(33) NOT NULL,
  `booklet_number` varchar(33) NOT NULL,
  `qazzath_district_name` varchar(33) NOT NULL,
  `qazzath_name` varchar(33) NOT NULL,
  `crt_type` varchar(33) NOT NULL,
  `no_certificates` varchar(33) NOT NULL,
  `total_amount` varchar(33) NOT NULL,
  `delivery_mode` varchar(33) NOT NULL,
  `iff_courier` varchar(33) NOT NULL,
  `name` varchar(333) NOT NULL,
  `mobile` varchar(33) NOT NULL,
  `pincode` varchar(33) NOT NULL,
  `del_address` text NOT NULL,
  `payment` varchar(33) NOT NULL,
  `schedule_id` varchar(33) NOT NULL,
  `schedule_date` varchar(33) NOT NULL,
  `status` varchar(11) NOT NULL,
  `session_username` varchar(33) NOT NULL,
  `timestamp` varchar(33) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qz_online_khula_certificate_reissue`
--

LOCK TABLES `qz_online_khula_certificate_reissue` WRITE;
/*!40000 ALTER TABLE `qz_online_khula_certificate_reissue` DISABLE KEYS */;
INSERT INTO `qz_online_khula_certificate_reissue` VALUES (1,'26633','80','K-108','K1593411549','Khula Re-issue','KR1602583617','local','mohd nayeem ahmed','abdul majeed','----','17-01-1982','indian','private service','MIGH Colony, Mehdipatnam, Hyderab','','','salma begum','shaik liyaquath ali','-----','08-06-1991','indian','house hold','local','10-22-277, A Battery Line, Hyderabad.','','','','2020','13-10-2020','31-05-2020','11-06-2020','mohd nayeem ahmed','110','7','11','ordinary','2','600','1','undefined','razzak','9182619996','undefined','undefined','1','511','15-10-2020','1','admin','1602583617'),(2,'31137','60','K-138','K1592386219','Khula Re-issue','KR1609405184','local','ahmed mustaqeemuddin','ahmed muqeemuddin','','15-09-1987','indian','private service','12-2-910 1 Floor Asif Nagar Zeba ','','','ayesha fatima','sundarraj devadass','37','----','indian','house hold','local','55 E BLK Ashoknagar Plice QTR Karnataka,  At Hyderabad','','','','2020','31-12-2020','15-12-2017','11-06-2020','ahmed mustaqeemuddin','178/41','7','13','ordinary','1','300','1','undefined','ayeha fatima','9052303187','undefined','undefined','1','511','02-01-2021','1','admin','1609405184'),(3,'35360','163','K-173','K1614571918','Khula Re-issue','KR1615349044','local','mohammed hameed','mohammed yousuf','','23-08-1996','indian','house hold','1-5-30, Domalkonda Dist Nizamabad','','','zahera begum','aslam bin amar','','26-06-1996','indian','private service','local','6-3-1132/1/2/1, B.S. Maktha, Begumpet, Hyderabad','','','','2021','10-03-2021','19-07-2020','25-01-2021','mohammed hameed','01','27','103','ordinary','1','300','1','undefined','K-165','7013235308','undefined','undefined','1','511','12-03-2021','4','Guest','1615349044'),(4,'37909','170','K-191','K1615010325','Khula Re-issue','KR1619512420','local','mirza hasan mustaba','mirza hasan askari','----','05-01-1990','indian','private service','17-1-364/1,Khalander Nagar Santos','','','tahera fatima abbas','syed shahid abbas','----','14-11-1995','indian','house hold','local','Flat No 507  Gulrez Somajiguda','','','','2021','27-04-2021','25-01-2021','25-01-2021','mirza hasan muSTABA','84','7','160','ordinary','1','300','1','undefined','MIRZA','8886792003','undefined','undefined','2','511','29-04-2021','1','Guest','1619512420'),(5,'46729','310','K-321','K1635745504','Khula Re-issue','KR1636090692','local','mohammad muneer ali','mohammad shabber ali khan','','02-02-1983','indian','private employee','Eig Gah, Lakshar Bazar, Hanamkond','','','rahmath unnisa begum','mir faiyaz uddin ali khan','15-07-1985','','indian','house hold','local','Subedari, Hanamkonda','','','','2021','05-11-2021','04-09-2018','17-09-2018','mohammad muneer ali','56/39','33','31','tatkal','1','400','1','undefined','Amjad','9949369427','undefined','undefined','1','545','05-11-2021','1','Guest','1636090692'),(6,'47313','310','K-337','K1635745504','Khula Re-issue','KR1637127152','local','mohammad muneer ali khan','mohammad shabber ali khan','','02-02-1983','indian','private employee','Eig Gah, Lakshar Bazar, Hanamkond','','','rahmath unnisa begum','mir faiyaz uddin ali khan','---','25-07-1985','indian','house hold','local','Subedari, Hanamkonda','','','','2021','17-11-2021','04-09-2018','17-09-2018','mohammad muneer ali','56/39','33','31','tatkal','1','400','1','undefined','Rahmath unnisa begum','9949369427','undefined','undefined','1','545','17-11-2021','1','Guest','1637127152'),(7,'47313','310','K-338','K1635745504','Khula Re-issue','KR1637127249','local','mohammad muneer ali','mohammad shabber ali khan','','02-02-1983','indian','private employee','Eig Gah, Lakshar Bazar, Hanamkond','','','rahmath unnisa begum','mir faiyaz uddin ali khan','---','25-07-1985','indian','house hold','local','Subedari, Hanamkonda','','','','2021','17-11-2021','04-09-2018','17-09-2018','mohammad muneer ali','56/39','33','31','tatkal','2','800','1','undefined','Rahmath unnisa begum','9949369427','undefined','undefined','1','545','17-11-2021','1','Guest','1637127249'),(8,'95341','867','K-885','K1692859275','Khula Re-issue','KR1693296210','local','mohammed  athar aalam','mohammad  akhtar aalam','','25-12-1976','indian','private service','11-5-252,  AKHTAR VILLA, RED HILL','','','asma nargis','azeem ullah khan','','01-07-1982','indian','house hold','local','FLAT NO..204,  PLOT NO. 67, \n ROAD NO.12, BANJARA HILLS,  HYDERABAD','','','','2023','29-08-2023','12-03-2022','15-03-2022','3352/22','1036','7','8','tatkal','1','500','','undefined','rasheed','9951626358','undefined','undefined','1','626','29-08-2023','4','Guest','1693296210'),(9,'106228','1021','K-1113','K1698641371','Khula Re-issue','KR1700110180','local','syed zaheeruddin','syed sayeeduddin','','08-03-1986','indian','engineer','4-2-16/6/d1 Ramaiah Bowli Mahabub','','','amena tabassum','mohammed ameenuddin','','08-01-1996','indian','house hold','local','H No 7-7, Old Bazar Badeally Jadcheria Mandal Mahabub Nagar','','','','2023','16-11-2023','23-08-2023','23-08-2023','syed zaheeruddin','117/2023','17','19','tatkal','1','500','1','undefined','amena tabassum','9885110810','undefined','undefined','1','623','15-11-2023','1','Guest','1700110180'),(10,'106300','1021','K-1119','K1698641371','Khula Re-issue','KR1700116944','local','syed zaheeruddin','syed sayeeduddin','','08-03-1986','indian','engineer','4-2-16/6/d1 RaMAIAH Bowli Mahabub','','','amena tabassum','mohammed ameenuddin','','08-01-1996','indian','house hold','local','H No 7-7, Old Bazar Badeally Jadcheria Mandal Mahabub Nagar','','','','2023','16-11-2023','23-08-2023','23-08-2023','syed zaheeruddin','117/2023','17','19','tatkal','1','500','1','undefined','MOHAMMED','8179114305','undefined','undefined','1','623','16-11-2023','1','Guest','1700116944'),(11,'149871','1081','K-1952','K1699428893','Khula Re-issue','KR1720846925','local','mohammad amer sohel','mohammad aleem','','26-12-1992','indian','private service','Flat.No.401, Al-Kareem Apartment,','','','afrah zahid','mohammed zahid hussain','','16-07-2000','indian','house hold','local','20-3-144/8, Shibli Gunj, Shah Gunj, Charminar, Hyderabad.','','','','2024','13-07-2024','01-11-2023','04-11-2023','mohammad amer sohel','1044','7','8','tatkal','1','500','1','undefined','ishtiyaq','9700899470','undefined','undefined','1','','','1','Guest','1720846925'),(12,'150010','1081','K-1953','K1699428893','Khula Re-issue','KR1720847155','local','mohammad amer sohel','mohammad aleem','','26-12-1992','indian','private service','Flat.No.401, Al-Kareem Apartment,','','','afrah zahid','mohammed zahid hussain','','16-07-2000','indian','house hold','local','20-3-144/8, Shibli Gunj, Shah Gunj, Charminar, Hyderabad.','','','','2024','13-07-2024','01-11-2023','04-11-2023','mohammad amer sohel','1044','7','8','tatkal','1','500','1','undefined','amer sohel','9700899470','undefined','undefined','1','626','15-07-2024','4','Guest','1720847155'),(13,'160548','2090','K-2173','K1724306178','Khula Re-issue','KR1726029569','local','abdul kareem','abdul hakeem','','15-08-1987','indian','business','13-3-22 Lalwadi Bidar Karnataka','','','masarrat begum','mohammed iqbal ahmed','','24-12-1989','indian','house hold','local','10-4-13/11/F Masab Tank  Hyderabad.','','','','2024','11-09-2024','08-02-2017','21-08-2024','abdul kareem','737','7','10','tatkal','1','500','1','undefined','MASARRAT BEGUM','8297229100','undefined','undefined','1','626','11-09-2024','4','Guest','1726029569'),(14,'168760','478','K-2395','K1648448148','Khula Re-issue','KR1730445574','local','md nayeem uddin','qamar uddin','','04-04-1972','indian','tailar','Nawab Sab Canta Hyderabad','','','qamar unnisa urf sharf unnisa','mohd madar khan','','20-09-1973','indian','house hold','local','Kotla Hassan Ulha Khan Hyderabad','','','','2024','01-11-2024','09-04-2016','09-04-2016','md nayeem uddin','866','7','10','tatkal','1','500','1','undefined','qamar unnisa urf sharf unnisa','7329021862','undefined','undefined','1','623','01-11-2024','1','Guest','1730445574'),(15,'168972','2276','K-2400','K1728367287','Khula Re-issue','KR1730553921','local','sana khanam','mohammed abdul rasheed khan','','05-08-1993','indian','house hold','H.No. 7-3-336/C, Kashmeergadda, K','','','mujahid ahmed khan mohammed','mohammed fasi ahmed khan','','19-05-1989','indian','private service','local','H.No. 10-27/1,Razvi Chaman, Bommakal, Karimnagar District.','','','','2024','02-11-2024','26-08-2024','29-09-2024','sana khanam','006774','7','13','ordinary','1','500','1','undefined','mohammed mujahid ahmed khan','9884978122','undefined','undefined','2','','','1','Guest','1730553921'),(16,'169387','2276','K-2414','K1728367287','Khula Re-issue','KR1730793661','local','mohammed mujahid ahmed khan','fasi ahmed khan','','19-05-1987','indian','private','H.No. 10-27/1,Razvi Chaman, Bomma','','','sana khanam','mohammed abdul rasheed khan','','05-08-1993','indian','house hold','local','H.No. 7-3-336/C, Kashmeergadda, Karimnagar Town And District.','','','','2024','05-11-2024','26-08-2024','29-09-2024','682','682/2024','7','13','tatkal','1','500','1','undefined','Mohammed Mujahid Ahmed khan','9884978122','undefined','undefined','2','','','1','Guest','1730793661'),(17,'169387','2276','K-2415','K1728367287','Khula Re-issue','KR1730794304','local','mohammed mujahid ahmed khan','fasi ahmed khan','','19-05-1987','indian','private','H.No. 10-27/1,Razvi Chaman, Bomma','','','sana khanam','mohammed abdul rasheed khan','','05-08-1993','indian','house hold','local','H.No. 7-3-336/C, Kashmeergadda, Karimnagar Town And District 505001','','','','2024','05-11-2024','26-08-2024','29-09-2024','682','682/2024','7','13','tatkal','1','500','','undefined','Mohammed Mujahid Ahmed khan','9884978122','undefined','undefined','1','623','08-11-2024','1','Guest','1730794304'),(18,'173555','2468','K-2525','K1732086083','Khula Re-issue','KR1732737538','local','mohd aslaan','m.a. waheed','','21-11-1986','indian','doctor','Old Malakpet','','','samreen afzal fatima','mohammed shafi farooqi','','20-01-1988','indian','doctor','local','MALLAPALLY','','','','2024','28-11-2024','08-05-2016','08-05-2016','mohd aslaan','1041','7','10','tatkal','2','1000','1','undefined','SAMREEN AFZAL FATIMA','9700151519','undefined','undefined','1','623','28-11-2024','1','Guest','1732737538'),(19,'181196','2026','K-2692','K1722920574','Khula Re-issue','KR1736404106','local','syed mohatousimullah','syed aleemullah','32','22-06-1992','indian','doctor','7-1-160 Narsa Reddy Colony, Hyder','','','adeeba mehjabeen','abdul hai ansari','29','16-08-1995','indian','private employee','local','8-3-169/38 Plot No 38 Ganga Nagar Yousufguda Hyderabad.','','','','2025','09-01-2025','29-06-2024','11-07-2024','syed mohatousimullah','006487','7','8','tatkal','1','500','','undefined','SYED MOHATOUSIMULLAH','9030634046','undefined','undefined','2','623','10-01-2025','1','Guest','1736404106'),(20,'181196','2026','K-2693','K1722920574','Khula Re-issue','KR1736405904','local','syed mohatousimullah','syed aleemullah','32','22-06-1992','indian','doctor','7-1-160 Narsa Reddy Colony, Hyder','','','adeeba mehjabeen','abdul hai ansari','29','16-08-1995','indian','private employee','local','8-3-169/38 Plot No 38 Ganga Nagar Yousufguda Hyderabad.','','','','2025','09-01-2025','29-06-2024','11-07-2024','16/17/2024','006487','7','8','tatkal','2','1000','1','undefined','SYED MOHATOUSIMULLAH','9030634046','undefined','undefined','2','','','1','Guest','1736405904'),(21,'181493','2026','K-2703','K1722920574','Khula Re-issue','KR1736493045','local','syed mohatousimullah','syed aleemullah','32','22-06-1992','indian','doctor','7-1-160 Narsa Reddy Colony, Hyder','','','adeeba mehjabeen','abdul hai ansari','29','16-08-1995','indian','private employee','local','8-3-169/38 Plot No 38 Ganga Nagar Yousufguda Hyderabad.','','','','2025','10-01-2025','29-06-2024','11-07-2024','16/17/2024','006487','7','8','tatkal','1','500','1','undefined','SYED MOHATOUSIMULLAH','9030634046','undefined','undefined','2','624','11-01-2025','1','Guest','1736493045'),(22,'181493','2026','K-2713','K1722920574','Khula Re-issue','KR1736926829','local','syed mohatousimullah','syed aleemullah','32','22-06-1992','indian','doctor','7-1-160 Narsa Reddy Colony, Hyder','','','adeeba mehjabeen','abdul hai ansari','29','16-08-1995','indian','private employee','local','8-3-169/38 Plot No 38 Ganga Nagar Yousufguda Hyderabad.','','','','2025','15-01-2025','29-06-2024','11-07-2024','16/44/1446h','3337','7','8','tatkal','1','500','1','undefined','SYED MOHATOUSIMULLAH','9030634046','undefined','undefined','2','623','16-01-2025','1','Guest','1736926829'),(23,'204695','1051','K-3137','K1698993467','Khula Re-issue','KR1747073711','local','mohammed azam ullah','mohammed naim ullah','','20-01-1985','indian','it','18-587, Azamabad, Hyderabad.','','','sana nazish','syed rustum ali','','14-04-1995','indian','housewife','local','Hno 9-3-58/52/D, Ahmed Colony, Moti Darwaza, Golconda, Hyderabad','','','','2025','12-05-2025','09-09-2023','09-09-2023','mohammed azam ullah','005428','7','8','ordinary','1','500','1','undefined','Azam ullah Mohammed','9704359161','undefined','undefined','1','621','15-05-2025','1','Guest','1747073711'),(24,'248791','3503','K-4070','K1755759618','Khula Re-issue','KR1765099554','local','roovy jaweed','javed ali','','16-02-1988','indian','private service','FLAT NO. 302, SALEHEEN APARTMENT,','','','sakina raza','mohd raza ali khan','','27-12-1985','indian','house hold','local','126/3RT, VIJAY NAGAR COLONY, HYDERABAD.','','','','2025','07-12-2025','16-08-2025','18-08-2025','roovy jaweed','7/2025','7','216','tatkal','1','500','1','undefined','ROOVY JAWEED','8977539346','undefined','undefined','1','626','08-12-2025','1','Guest','1765099554'),(25,'257019','2065','K-4230','K1723791141','Khula Re-issue','KR1768215039','local','shaik saleem','shaik imam','','04-08-1979','indian','private service','H B Colony, Moula Ali, Secunderab','','','anees fatima','late. mohammed yousuf','','04-05-1965','indian','house hold','local','Moula Ali Secunderabad','','','','2026','12-01-2026','29-06-2024','29-06-2024','shaik saleem','K-2078','7','8','ordinary','1','500','1','undefined','ANEES FATIMA','7731961072','undefined','undefined','1','622','15-01-2026','1','Guest','1768215039'),(26,'265995','4278','K-4364','K1770104034','Khula Re-issue','KR1771226923','local','mohammed abdul salam','mohammed abdul ghaffar','','25-09-1990','indian','eletrical engineer','9-4-86/262/2, Salajung Colony, To','','','sana farheen','mohammed muneeruddin','','14-03-1996','indian','house hold','local','9-4-86/100/a, Quli Qutub Shah Nagar, Seven Tombs Road, Hyderabad','','','','2026','16-02-2026','14-12-2025','20-12-2025','mohammed abdul salam','566/1634/2025','7','8','tatkal','2','1000','1','undefined','SHAIMA FATIMA','9121344348','undefined','undefined','1','624','16-02-2026','1','Guest','1771226923'),(27,'271444','4409','K-4467','K1773042170','Khula Re-issue','KR1774414813','local','shaik ameer basha','shaik khadar basha','','01-12-1985','indian','government employee','Kanigiri Mandal, Prakasam','','','pathan bashirunnisa','rasheed khan pathan','','14-09-1987','indian','private doctor','local','7-2-1791/G5 Czech Colony Sanathnagar Hyderabad','','','','2026','25-03-2026','08-03-2026','09-03-2026','shaik ameer basha','99/2026','7','216','ordinary','1','500','1','undefined','xyz','9949803426','undefined','undefined','2','621','28-03-2026','1','Guest','1774414813'),(28,'284727','3098','K-4697','K1746683368','Khula Re-issue','KR1778943074','local','mohd husain','naushad husain','','12-04-1993','indian','govt employee','H NO: 17/128, Ram Narayan Bazar, ','','','aiman fatima arastu','dr asad husain arastu','','16-02-1998','indian','house hold','local','H NO: 11-5-339, Red Hills Hyderabad,','','','','2026','16-05-2026','06-05-2025','06-05-2025','mohd husain','000467','7','108','ordinary','1','500','1','undefined','Mohd Husain','7007027689','undefined','undefined','1','','','1','Guest','1778943074'),(29,'305107','4454','K-5060','K1774849846','Khula Re-issue','KR1784965580','local','syed hafeez','syed abdul rasheed','','15-02-1980','indian','private service','Hyderabad.','','','farahanaz','ahmed ullah khan','','18-01-1989','indian','house hold','local','Hanamkonda.','','','','2026','25-07-2026','08-07-2019','30-11-2025','syed hafeez','60/40/425/2025','34','18','ordinary','1','500','1','undefined','SYED WASEEM','9948004283','undefined','undefined','2','622','27-07-2026','1','Guest','1784965580');
/*!40000 ALTER TABLE `qz_online_khula_certificate_reissue` 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-09 22:00:14
