-- 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 `holidays`
--

DROP TABLE IF EXISTS `holidays`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `holidays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(33) NOT NULL,
  `description` longtext NOT NULL,
  `timestamp` varchar(33) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=325 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `holidays`
--

LOCK TABLES `holidays` WRITE;
/*!40000 ALTER TABLE `holidays` DISABLE KEYS */;
INSERT INTO `holidays` VALUES (8,'1550946600','Sunday','1550740629'),(9,'1551551400','Sunday','1550740665'),(10,'1551637800','Mahashivratri','1550740685'),(11,'1552069800','Second Saturday','1550740697'),(12,'1552156200','Sunday','1550740707'),(13,'1553106600','Holi','1551524791'),(14,'1554402600','Babu Jagjivan Ram Birthday','1551524822'),(15,'1554489000','Ugadi','1551524831'),(16,'1555093800','Second Saturday','1551524844'),(17,'1555612200','Good Friday','1551524862'),(18,'1557513000','Second Saturday','1554277472'),(19,'1559673000','Eid-Ul-Fitr','1554277504'),(20,'1559759400','Next Day of Eid-Ul-Fitr','1554277515'),(21,'1559932200','Second Saturday','1554277529'),(22,'1554921000','Due to Election Day','1554289840'),(23,'1554921000','Due to Election Day','1554289840'),(24,'1562956200','Second Saturday','1560944429'),(25,'1564338600','Bonalu','1560944442'),(26,'1565375400','Second Saturday','1560944458'),(27,'1565548200','Eid-Ul-Adha','1560944474'),(28,'1565807400','Independence Day','1560944488'),(29,'1566585000','Krishnashtami','1560944557'),(30,'1567362600','Vinayaka Chavithi','1560944740'),(31,'1568053800','Moharrum','1560944750'),(42,'1577817000','New Year','1577447509'),(33,'1569609000','Batkamma','1560944776'),(34,'1569954600','Gandhi Jayanthi','1560944788'),(35,'1570473000','Vijaya Dasami','1560944801'),(36,'1570818600','Second Saturday','1560944823'),(37,'1573237800','Second Saturday','1560944831'),(38,'1573497000','Guru Nanak Jayanthi','1560944846'),(39,'1576261800','Second Saturday','1560944855'),(40,'1577212200','Christmas','1560944866'),(41,'1577298600','Boxing Day','1560944878'),(43,'1578940200','Bhogi','1577447530'),(44,'1579026600','SANKRANTI / PONGAL','1577447574'),(45,'1582223400','MAHA SHIVARATRI','1577447601'),(46,'1583692200','HOLI','1577447621'),(47,'1585074600','UGADI','1577447637'),(48,'1585765800','SRI RAMA NAVAMI','1577447647'),(49,'1586457000','GOOD FRIDAY','1577447665'),(50,'1586802600','DR.B.R. AMBEDKARâ€™S BIRTHDAY','1577447676'),(51,'1590345000','EIDUL FITAR (RAMZAN)','1577447687'),(52,'1590431400','FOLLOWING DAY OF RAMZAN','1577447706'),(53,'1595183400','BONALU','1577447722'),(54,'1596220200','EIDUL AZHA (BAKRID)','1577447746'),(55,'1597084200','SRI KRISHNA ASTAMI','1577447755'),(56,'1597429800','NDEPENDENCE DAY','1577447768'),(57,'1601577000','MAHATMA GANDHI JAYANTHI','1577447882'),(58,'1598034600','VINAYAKA CHAVITHI','1577447902'),(59,'1602873000','BATHUKAMMA STARTING DAY','1577447929'),(60,'1603477800','DURGASTAMI','1577447941'),(61,'1603996200','EID MILADUN NABI','1577447954'),(62,'1606674600','KARTIKA PURNIMA / GURU NANAKâ€™S BIRTHDAY','1577447968'),(63,'1608834600','CHRISTMAS','1577447977'),(64,'1608921000','BOXING DAY','1577447990'),(65,'1584124200','Second Saturday','1583914529'),(66,'1585247400','lockdown due to coronavirus','1584954275'),(67,'1585333800','lockdown due to coronavirus','1584954283'),(68,'1585420200','lockdown due to coronavirus','1584954290'),(69,'1585420200','lockdown due to coronavirus','1584954300'),(70,'1585506600','lockdown due to coronavirus','1584954306'),(71,'1585593000','lockdown due to coronavirus','1584954312'),(72,'1596825000','Second Saturday','1596776968'),(73,'1599849000','Second Saturday','1596777245'),(74,'1609439400','New Year','1608787064'),(75,'1610130600','Second Saturday','1608787183'),(76,'1610476200','Sankrathi','1609902578'),(77,'1610562600','Pongal','1609902593'),(78,'1611599400','Republic Holiday','1609902628'),(80,'1615573800','Second Saturday.','1614997490'),(81,'1615401000','Mahashivarathri.','1614997546'),(87,'1643135400','Republic Day','1642076210'),(83,'1617301800','Good Friday','1616722291'),(84,'1617561000','Babu Jagheevan ram birthday','1616722325'),(85,'1617993000','Second Saturday','1617153364'),(88,'1646073000','Maha Shivaratri','1642076268'),(89,'1647541800','Holi','1642076288'),(90,'1648837800','Uagadi','1642076324'),(91,'1649097000','Babu Jagjivan Rams Birthday','1642076369'),(92,'1649529000','Sri Ramam Navami','1642076393'),(93,'1649874600','Dr B R Ambedkar Birthday','1642076437'),(94,'1649961000','Good Friday','1642076457'),(95,'1651516200','Eid Ul Fitr ( Ramzan)','1642076492'),(96,'1651602600','Following Day of Ramzan','1642076527'),(97,'1657391400','Eidul Azha (Bakrid)','1642076569'),(98,'1658687400','Bonalu','1642076603'),(99,'1659983400','Shahadat Imam Hussain ( R. A) 10th Moharam','1642076639'),(100,'1660501800','INdependence Day','1642076665'),(101,'1660933800','Sri Krishna Astami ( As Per SRivaishnava Agamam)','1642076706'),(102,'1661884200','Vinayaka Chavithi','1642076729'),(103,'1664044200','Bathukamma Starting Day','1642076757'),(104,'1664649000','Mahatma Gandhi Jayanthi','1642076787'),(105,'1664908200','Vijaya Dasami','1642076812'),(106,'1664994600','Following Day Of Vijaya Dasami','1642076841'),(107,'1665253800','Eid Miladun Nabi','1642076868'),(108,'1666636200','Deepavali','1642076887'),(109,'1667845800','Kartika Purnima Guru Nanaks Birthday','1642076931'),(110,'1671906600','Christmas','1642076964'),(111,'1671993000','Boxing Day','1642076988'),(112,'1647023400','Second Saturday','1642077466'),(113,'1649442600','Second Saturday','1642077476'),(114,'1652466600','Second Saturday','1642077483'),(115,'1654885800','Second Saturday','1642077495'),(116,'1657305000','Second Saturday','1642077507'),(117,'1660329000','Second Saturday','1642077518'),(118,'1662748200','Second Saturday','1642077528'),(119,'1665167400','Second Saturday','1642077537'),(120,'1668191400','Second Saturday','1642077549'),(121,'1670610600','Second Saturday','1642077557'),(122,'1645986600','Holiday declared by the District Collector on account of Election of TSWB Members.','1645538408'),(123,'1673634600','Bhogi','1672222016'),(124,'1673721000','Sankranthi','1672222035'),(125,'1674671400','Republic Day','1672222051'),(126,'1676658600','Mahashivratri','1672222152'),(127,'1678127400','Holi','1672222185'),(128,'1680114600','Holiday on Sri Ram Navami','1672222458'),(129,'1680805800','Holiday on Good Friday','1672222556'),(130,'1681410600','Holiday on Birthday of  Dr. B.R. Ambedkar','1672222583'),(131,'1682101800','Holiday on Eid-Ul-Fitr','1672222603'),(132,'1682188200','Holiday on Following day of Eid-ul-Fitr','1672222630'),(133,'1687977000','Holiday on Eid Ul Adha','1672222652'),(134,'1689532200','Holiday on Bonalu','1672222672'),(135,'1690569000','Holiday on Moharram','1672222686'),(136,'1692037800','Holiday on Independence Day','1672222704'),(137,'1694025000','Holiday on Sri Krishanastami','1672222759'),(138,'1694975400','Holiday on Vinayaka Chaturithi','1672222821'),(139,'1695839400','Holiday on Milad Un Nabi','1672222839'),(140,'1696185000','Holiday on Gandhi Jayanthi','1672222857'),(141,'1697221800','Holiday on First Day of Bathukamma','1672222912'),(142,'1698085800','Holiday on VIJAYA DASAMI','1672222981'),(161,'1697999400','Maharnavami','1697439424'),(144,'1699727400','Holiday on DEEPAVALI','1672223019'),(145,'1701023400','Holiday on KARTIKA PURNIMA / GURU NANAKâ€™S BIRTHDAY','1672223036'),(146,'1703442600','Holiday on CHRISTMAS','1672223056'),(147,'1703529000','Holiday on BOXING DAY','1672223070'),(148,'1672511400','Holiday on New Year','1672223098'),(149,'1679423400','Holiday on Ugadi','1672223177'),(150,'1680633000','Babu Jagjeevan Ram Birthday','1672223613'),(151,'1676053800','Second Saturday','1672223719'),(152,'1678473000','Second Saturday','1672223730'),(153,'1680892200','Second Saturday','1672223749'),(154,'1683916200','Second Saturday','1672223768'),(155,'1686335400','Second Saturday','1672223781'),(156,'1688754600','Second Saturday','1672223792'),(157,'1691778600','Second Saturday','1672223802'),(158,'1694197800','Second Saturday','1672223819'),(159,'1699641000','Second Saturday','1672223848'),(160,'1702060200','Second Saturday','1672223863'),(162,'1704047400','New Year','1703843384'),(163,'1705170600','Holiday on Bhogi','1703843406'),(164,'1705257000','Holiday on SANKRANTI / PONGAL','1703843689'),(165,'1706207400','Holiday on REPUBLIC DAY','1703843717'),(166,'1709836200','Holiday on MAHA SHIVARATRI','1703843740'),(167,'1711305000','Holiday on Holi','1703843770'),(168,'1711650600','Holiday on GOOD FRIDAY','1703843805'),(169,'1712255400','Holiday on  BABU JAGJIVAN RAMâ€™S\nBIRTHDAY','1703843835'),(170,'1712601000','Holiday on UGADI','1703843852'),(171,'1712773800','Holiday on EID UL FITR (RAMZAN)','1703843895'),(172,'1712860200','Holiday on FOLLOWING DAY OF\nRAMZAN','1703843929'),(173,'1713033000','Holiday on DR.B.R. AMBEDKARâ€™S\nBIRTHDAY','1703843948'),(174,'1713292200','Holiday on SRI RAMA NAVAMI','1703843965'),(175,'1718562600','Holiday on \nEIDUL AZHA (BAKRID)','1703843984'),(176,'1721154600','Holiday on SHAHADAT IMAM HUSSAIN\n(R.A) 10th MOHARAM','1703844005'),(177,'1722191400','Holiday on BONALU','1703844024'),(178,'1723660200','Holiday on INDEPENDENCE DAY','1703844039'),(179,'1724610600','Holiday on SRI KRISHNA ASTAMI','1703844074'),(180,'1725647400','Holiday on VINAYAKA CHAVITHI','1703844095'),(181,'1726425000','Holiday on EID MILADUN NABI','1703844117'),(182,'1727807400','Holiday on MAHATMA GANDHI\nJAYANTHI / BATHUKAMMA\nSTARTING DAY','1703844135'),(183,'1728671400','Holiday on VIJAYA DASAMI / 2nd Saturday','1703844150'),(184,'1728757800','Holiday on FOLLOWING DAY OF\nVIJAYA DASAMI','1703844167'),(185,'1730313000','Holiday on DEEPAVALI','1703844183'),(186,'1731609000','Holiday on \nKARTIKA PURNIMA /\nGURU NANAKâ€™S BIRTHDAY','1703844205'),(187,'1735065000','Holiday on CHRISTMAS','1703844221'),(188,'1735151400','Holiday on FOLLOWING DAY OF\nCHRISTMAS\n(BOXING DAY)','1703844235'),(189,'1705084200','Second Saturday','1703844331'),(201,'1736706600','Bhogi','1738320547'),(191,'1709922600','Second Saturday','1703844376'),(192,'1712946600','Second Saturday','1703844393'),(193,'1715365800','Second Saturday','1703844403'),(194,'1717785000','Second Saturday','1703844412'),(195,'1720809000','Second Saturday','1703844428'),(196,'1723228200','Second Saturday','1703844440'),(197,'1726252200','Second Saturday','1703844455'),(200,'1735669800','New Year','1738320506'),(199,'1734114600','Second Saturday','1703844595'),(202,'1736793000','Sankranthi','1738320563'),(203,'1737829800','Republic Day','1738320582'),(204,'1740508200','Maha Shivarathri','1738320607'),(205,'1741890600','Holi','1738320623'),(206,'1743273000','Ugaadi','1738320653'),(207,'1743359400','Ramzan Eid Ul Fitr','1738320688'),(208,'1743445800','Following Day of Ramazan','1738320710'),(209,'1743877800','Sri Rama Navami','1738320765'),(210,'1744569000','Dr. B.R. Ambedkar Birthday','1738320787'),(211,'1744914600','Good Friday','1738320807'),(212,'1749234600','Bakrid (Eid Ul Azha)','1738320849'),(213,'1751740200','Muharrum','1738320870'),(214,'1753036200','Bonalu','1738320883'),(215,'1755196200','Independence Day','1738320905'),(216,'1755282600','Sri Kirshnashtami','1738320941'),(217,'1756233000','Vinayaka Chavithi','1738320974'),(218,'1757010600','Eid Milad Un Nabi Sallallahu Alaih wa Sallam','1738321021'),(219,'1758393000','Bhatukamma Starting Day','1738321072'),(220,'1759343400','Mahathma Gandhi Jayanthi','1738321093'),(221,'1759429800','Following Day of Vijaya Dasami','1738321143'),(222,'1760898600','Deepavali','1738321164'),(228,'1736533800','Second Saturday','1738321766'),(224,'1766601000','Christmas','1738321353'),(225,'1766687400','Following day of Christmas, Boxing Day','1738321374'),(226,'1743791400','Babu Jagjivan ram birthday','1738321610'),(227,'1762281000','Karthika puranima and Gurunanak Jayanthi','1738321678'),(229,'1741372200','Second Saturday','1738321788'),(230,'1744396200','Second Saturday','1738321871'),(231,'1746815400','Second Saturday','1738321883'),(232,'1749839400','Second Saturday','1738321898'),(233,'1752258600','Second Saturday','1738321914'),(234,'1754677800','Second Saturday','1738321926'),(235,'1757701800','Second Saturday','1738321945'),(236,'1760121000','Second Saturday','1738321959'),(237,'1762540200','Second Saturday','1738321970'),(238,'1765564200','Second Saturday','1738321985'),(239,'1767465000','Sunday','1767181902'),(240,'1767983400','Second Saturday','1767181941'),(241,'1768069800','Sunday','1767181965'),(242,'1768329000','Bhogi','1767181994'),(244,'1768674600','Sunday','1767182024'),(245,'1769279400','Sunday','1767182132'),(246,'1769365800','Republic day','1767182150'),(247,'1769884200','Sunday','1767182218'),(248,'1767810600','Sunday','1767182251'),(249,'1771007400','Second Saturday','1767182265'),(250,'1771093800','Sunday','1767182274'),(251,'1771698600','Sunday','1767182304'),(252,'1772303400','Sunday','1767182316'),(253,'1772476200','Holi','1767182328'),(254,'1772908200','Sunday','1767182346'),(255,'1773426600','Second Saturday','1767182381'),(256,'1773513000','Sunday','1767182396'),(257,'1773858600','Ugadi','1767182411'),(258,'1774031400','Ramazan Eid ul Fitr','1767182441'),(259,'1774117800','Following day of Ramazan and Sunday','1767182467'),(260,'1774549800','Sri Ramanavami','1767182493'),(261,'1774722600','Sunday','1767182517'),(262,'1775154600','Good Friday','1767182540'),(263,'1775327400','Babu Jagjivan Ram Jayanthi and Sunday','1767182576'),(264,'1775845800','Second Saturday','1767182591'),(265,'1775932200','Sunday','1767182617'),(266,'1776105000','Dr B R Ambedkar Jayanthi','1767182642'),(267,'1776537000','Sunday','1767182663'),(268,'1777141800','Sunday','1767182674'),(269,'1777746600','Sunday','1767182698'),(270,'1778265000','Second Saturday','1767182714'),(271,'1778351400','Sunday','1767182724'),(272,'1778956200','Sunday','1767182736'),(273,'1779561000','Sunday','1767182756'),(274,'1748284200','Bakrid Eid Ul Adha','1767182780'),(275,'1780165800','Sunday','1767182790'),(276,'1780770600','Sunday','1767182817'),(277,'1781289000','Second Saturday','1767182834'),(278,'1781375400','Sunday','1767182844'),(279,'1781980200','Sunday','1767182852'),(280,'1782412200','Muharram','1767182876'),(281,'1782585000','Sunday','1767182883'),(282,'1783189800','Sunday','1767182903'),(283,'1783708200','Second Saturday','1767182914'),(284,'1783794600','Sunday','1767182927'),(285,'1784399400','Sunday','1767182936'),(286,'1785004200','Sunday','1767182948'),(287,'1785609000','Sunday','1767182961'),(288,'1786127400','Second Saturday','1767182984'),(289,'1786213800','Sunday','1767182995'),(290,'1786300200','Bonalu','1767183010'),(291,'1786732200','Independence day','1767183052'),(292,'1786818600','Sunday','1767183065'),(293,'1787423400','Sunday','1767183089'),(294,'1787682600','Eid Milad Un Nabi sallallahu alaihi wa sallam','1767183125'),(295,'1788028200','Sunday','1767183131'),(296,'1788460200','Sri Krishnashtami','1767183162'),(297,'1788633000','Sunday','1767183174'),(298,'1789151400','Second Saturday','1767183188'),(299,'1789237800','Sunday','1767183212'),(300,'1789324200','Vinayaka Chavithi','1767183233'),(301,'1789842600','Sunday','1767183251'),(302,'1790447400','Sunday','1767183259'),(303,'1790879400','Mahthma Gandhi Jayanthi','1767183284'),(304,'1791052200','Sunday','1767183295'),(305,'1791570600','Second Saturday','1767183308'),(306,'1791657000','Sunday','1767183323'),(307,'1792261800','Saddula Bhatukamma and Sunday','1767183354'),(308,'1792434600','Vijaya Dashami','1767183374'),(309,'1792521000','Following day of Vijaya Dashami','1767183395'),(310,'1792866600','Sunday','1767183407'),(311,'1793471400','Sunday','1767183419'),(312,'1794076200','Deepavali and Sunday','1767183436'),(313,'1794594600','Second Saturday','1767183450'),(314,'1794681000','Sunday','1767183456'),(315,'1795285800','Sunday','1767183468'),(316,'1795458600','Karthika Purnima','1767183488'),(317,'1795890600','Sunday','1767183496'),(318,'1796495400','Sunday','1767183521'),(319,'1797013800','Second Saturday','1767183536'),(320,'1797100200','Sunday','1767183548'),(321,'1797705000','Sunday','1767183560'),(322,'1798137000','Christmas','1767183579'),(323,'1798223400','Following day of Christmas','1767183598'),(324,'1798309800','Sunday','1767183615');
/*!40000 ALTER TABLE `holidays` 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-05 22:00:10
