--
-- Host: localhost    Database: onlineleave
-- ------------------------------------------------------


--
-- Table structure for table `forgotpassword`
--

CREATE TABLE `forgotpassword` (
  `forgotpassword_id` int NOT NULL AUTO_INCREMENT,
  `forgotpassword_userid` int NOT NULL,
  `forgotpassword_key` varchar(255) NOT NULL,
  `forgotpassword_status` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`forgotpassword_id`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `forgotpassword`
--

INSERT INTO `forgotpassword` VALUES (1,148,'19627712188','expire','2025-04-30 18:53:35','2025-04-30 18:54:10'),(2,148,'79627164419','pending','2025-04-30 18:54:10','2025-04-30 18:54:10'),(3,165,'59544484559','expire','2025-05-02 15:56:29','2025-05-02 15:56:51'),(4,165,'38127602733','pending','2025-05-02 15:56:51','2025-05-02 15:56:51'),(5,105,'70149194222','pending','2025-05-02 16:10:19','2025-05-02 16:10:19'),(6,61,'38974780984','expire','2025-05-02 17:15:56','2025-05-02 17:17:06'),(7,61,'51900782412','pending','2025-05-02 17:17:06','2025-05-02 17:17:06'),(8,166,'53093103093','pending','2025-05-02 21:04:32','2025-05-02 21:04:32'),(9,103,'39249706260','changed','2025-05-04 10:48:34','2025-05-04 10:51:33'),(10,174,'86316789917','expire','2025-05-06 08:26:26','2025-05-06 08:26:57'),(11,174,'21951105164','changed','2025-05-06 08:26:57','2025-05-06 08:28:50'),(12,93,'60318089411','changed','2025-05-06 08:32:14','2025-05-06 08:34:46'),(13,117,'58868986804','changed','2025-05-06 11:41:13','2025-05-06 11:46:24'),(14,17,'99173738678','changed','2025-05-06 12:04:59','2025-05-06 12:06:27'),(15,27,'87511498613','changed','2025-05-06 20:41:04','2025-05-06 20:43:00'),(16,147,'61295144559','changed','2025-05-07 14:06:17','2025-05-07 14:08:08'),(17,213,'51314817756','changed','2025-05-07 15:18:12','2025-05-07 15:19:39'),(18,115,'76110837275','changed','2025-05-07 16:16:30','2025-05-07 16:17:33'),(19,32,'62093417210','changed','2025-05-07 21:38:09','2025-05-07 21:39:45'),(20,126,'42700221300','changed','2025-05-08 19:31:03','2025-05-08 19:38:09'),(21,66,'38465340268','changed','2025-05-12 22:13:57','2025-05-12 22:14:55'),(22,149,'46847157523','expire','2025-05-13 08:42:51','2025-05-13 08:44:55'),(23,149,'39311904946','changed','2025-05-13 08:44:55','2025-05-13 08:47:46'),(24,51,'99727525385','changed','2025-05-13 13:33:42','2025-05-13 13:35:26'),(25,88,'29007596814','changed','2025-05-13 15:34:53','2025-05-13 15:36:28'),(26,108,'22470153481','expire','2025-05-14 07:16:23','2025-05-14 07:17:04'),(27,108,'19632330163','changed','2025-05-14 07:17:04','2025-05-14 07:18:29'),(28,202,'65115475655','changed','2025-05-15 08:35:40','2025-05-15 08:40:08'),(29,57,'28826166206','changed','2025-05-15 10:08:20','2025-05-15 10:10:05'),(30,118,'91546799688','expire','2025-05-16 07:46:40','2025-05-16 07:47:07'),(31,118,'92936759798','changed','2025-05-16 07:47:07','2025-05-16 07:50:02'),(32,118,'55925467283','changed','2025-05-16 07:51:08','2025-05-16 08:00:37'),(33,112,'17088906704','expire','2025-05-16 09:33:29','2025-05-16 09:33:50'),(34,112,'36745856880','expire','2025-05-16 09:33:51','2025-05-16 09:34:56'),(35,112,'50274482019','changed','2025-05-16 09:34:56','2025-05-16 09:37:13'),(36,174,'30916802452','changed','2025-05-18 19:07:56','2025-05-18 19:08:47'),(37,36,'55936079660','changed','2025-05-19 10:54:18','2025-05-19 11:00:04'),(38,86,'70483979365','changed','2025-05-19 11:11:34','2025-05-19 11:13:07'),(39,32,'21533129301','changed','2025-05-19 14:55:11','2025-05-19 14:56:43'),(40,133,'29552488859','pending','2025-05-19 16:04:51','2025-05-19 16:04:51'),(41,157,'33094368663','changed','2025-05-22 08:27:01','2025-05-22 08:28:53'),(42,192,'76618218872','changed','2025-05-22 11:34:28','2025-05-22 11:37:24'),(43,220,'16089756503','changed','2025-05-23 09:40:38','2025-05-23 09:41:35'),(44,8,'46612685432','changed','2025-05-23 10:06:52','2025-05-23 10:07:35'),(45,218,'14565107025','expire','2025-05-26 17:40:07','2025-05-26 17:40:36'),(46,218,'87125417102','expire','2025-05-26 17:40:36','2025-05-26 17:41:42'),(47,218,'64678157271','expire','2025-05-26 17:41:42','2025-05-26 17:42:40'),(48,218,'22284696527','expire','2025-05-26 17:42:40','2025-05-26 17:44:33'),(49,218,'62831497919','expire','2025-05-26 17:44:33','2025-05-26 17:46:30'),(50,218,'43525191448','expire','2025-05-26 17:46:30','2025-05-26 17:48:13'),(51,218,'61001623652','changed','2025-05-26 17:48:13','2025-05-26 17:52:49'),(52,139,'34642739222','changed','2025-05-27 11:40:33','2025-05-27 11:41:32'),(53,218,'80556301060','changed','2025-05-27 14:23:04','2025-05-27 14:27:03'),(54,109,'34278178543','changed','2025-05-27 15:54:35','2025-05-27 15:56:00'),(55,218,'13396136277','changed','2025-05-28 09:51:20','2025-05-28 09:54:57'),(56,218,'58205434913','expire','2025-05-28 10:08:46','2025-05-28 10:24:02'),(57,218,'26362945652','expire','2025-05-28 10:24:02','2025-05-28 10:26:46'),(58,218,'89776135002','changed','2025-05-28 10:26:46','2025-05-28 10:32:23'),(59,218,'17833554586','changed','2025-05-28 11:37:05','2025-05-28 11:39:32'),(60,218,'48979925468','changed','2025-05-28 19:16:54','2025-05-28 19:18:52'),(61,218,'71557617705','changed','2025-05-28 19:21:44','2025-05-28 19:24:02'),(62,63,'58073298102','changed','2025-05-29 10:11:36','2025-05-29 10:12:42'),(63,82,'67462635799','changed','2025-05-29 10:22:32','2025-05-29 10:23:29'),(64,137,'95722304197','changed','2025-05-29 10:31:53','2025-05-29 10:32:24'),(65,143,'17685396332','changed','2025-05-29 10:33:51','2025-05-29 10:34:36'),(66,106,'22627480242','changed','2025-05-29 10:39:48','2025-05-29 14:01:43'),(67,134,'97745594968','expire','2025-05-29 13:15:02','2025-05-29 13:15:53'),(68,134,'83962853687','expire','2025-05-29 13:15:53','2025-05-29 13:17:31'),(69,159,'29280062032','expire','2025-05-29 13:15:53','2025-05-29 13:18:13'),(70,134,'65139377037','changed','2025-05-29 13:17:31','2025-05-29 13:27:07'),(71,159,'63837194285','changed','2025-05-29 13:18:13','2025-05-29 13:20:52'),(72,112,'65396656264','changed','2025-05-29 14:00:53','2025-05-29 14:01:55'),(73,160,'98475877059','expire','2025-05-29 14:13:07','2025-05-29 14:13:58'),(74,160,'31057988780','expire','2025-05-29 14:13:58','2025-05-29 14:23:18'),(75,5,'14574854988','changed','2025-05-29 14:19:51','2025-05-29 14:20:32'),(76,160,'72369108191','changed','2025-05-29 14:23:18','2025-05-29 14:24:59'),(77,218,'55303885597','changed','2025-05-29 17:13:21','2025-05-29 17:15:15'),(78,209,'47292046887','changed','2025-05-30 12:47:40','2025-05-30 12:48:36'),(79,158,'69758436374','changed','2025-05-30 13:42:30','2025-05-30 13:44:27'),(80,189,'59359743427','changed','2025-06-02 09:25:04','2025-06-02 09:27:30'),(81,29,'10884522983','changed','2025-06-02 10:36:52','2025-06-02 10:37:39'),(82,52,'59508975353','changed','2025-06-02 15:46:31','2025-06-02 15:48:10'),(83,26,'15925852353','expire','2025-06-04 07:32:16','2025-06-04 07:33:41'),(84,26,'67931719768','expire','2025-06-04 07:33:41','2025-06-04 07:35:41'),(85,26,'33263623188','expire','2025-06-04 07:35:41','2025-06-04 07:38:30'),(86,26,'48421215872','changed','2025-06-04 07:38:30','2025-06-04 07:39:41'),(87,98,'81908007033','changed','2025-06-04 13:50:46','2025-06-04 13:51:36'),(88,98,'78196296766','expire','2025-06-04 13:53:04','2025-06-04 13:55:43'),(89,98,'15385876799','changed','2025-06-04 13:55:43','2025-06-04 13:56:57'),(90,171,'39005783734','expire','2025-06-05 10:31:35','2025-06-05 10:32:31'),(91,171,'90265504446','expire','2025-06-05 10:32:31','2025-06-05 10:36:46'),(92,171,'33154950045','changed','2025-06-05 10:36:46','2025-06-05 10:38:35'),(93,35,'11382876109','changed','2025-06-05 11:24:03','2025-06-05 11:26:15'),(94,101,'20220158035','changed','2025-06-05 12:51:45','2025-06-05 12:53:20'),(95,124,'97203334983','changed','2025-06-05 14:42:01','2025-06-05 14:43:07'),(96,209,'32104235514','changed','2025-06-05 15:26:03','2025-06-05 15:27:25'),(97,218,'90309983439','changed','2025-06-09 05:45:13','2025-06-09 05:48:32'),(98,218,'50245382453','changed','2025-06-09 16:36:58','2025-06-09 16:37:36'),(99,35,'68334740752','changed','2025-06-11 05:56:18','2025-06-11 06:00:05'),(100,117,'94508255885','expire','2025-06-12 08:30:21','2025-06-12 08:30:56'),(101,117,'81912020675','changed','2025-06-12 08:30:56','2025-06-12 08:32:27'),(102,169,'85844378472','changed','2025-06-12 14:04:42','2025-06-12 14:06:06'),(103,130,'54493499289','changed','2025-06-16 08:42:27','2025-06-16 08:44:51'),(104,12,'67826697586','expire','2025-06-16 09:42:30','2025-06-16 09:43:35'),(105,12,'78550829586','expire','2025-06-16 09:43:35','2025-06-16 09:48:28'),(106,12,'71699684225','pending','2025-06-16 09:48:28','2025-06-16 09:48:28'),(107,221,'45298791613','changed','2025-06-18 12:36:02','2025-06-18 12:38:54'),(108,169,'92601663217','changed','2025-06-18 15:10:59','2025-06-18 15:16:50'),(109,180,'11446105086','changed','2025-06-18 16:33:14','2025-06-18 16:37:41'),(110,89,'66973242721','changed','2025-06-19 10:22:31','2025-06-19 10:23:42'),(111,62,'20580766439','expire','2025-06-19 10:27:07','2025-06-19 10:28:42'),(112,62,'54059232797','expire','2025-06-19 10:28:42','2025-06-19 10:31:24'),(113,62,'58904567007','changed','2025-06-19 10:31:24','2025-06-19 10:33:59'),(114,201,'40375004113','expire','2025-06-23 09:49:55','2025-06-23 09:53:12'),(115,201,'65683207949','expire','2025-06-23 09:53:12','2025-06-23 10:05:28'),(116,201,'63630747922','changed','2025-06-23 10:05:28','2025-06-23 10:08:44'),(117,101,'80676911701','expire','2025-06-23 12:27:33','2025-06-23 12:27:54'),(118,101,'55485165742','expire','2025-06-23 12:27:54','2025-06-23 12:29:08'),(119,101,'67379091404','expire','2025-06-23 12:29:08','2025-06-23 12:30:32'),(120,101,'70615157473','changed','2025-06-23 12:30:32','2025-06-23 12:31:39'),(121,102,'73498458817','changed','2025-06-23 17:19:29','2025-06-23 17:20:37'),(122,206,'29319219335','changed','2025-06-24 11:42:38','2025-06-24 11:43:31'),(123,159,'12125838944','changed','2025-06-24 11:55:08','2025-06-24 11:56:38'),(124,72,'60632256711','changed','2025-06-24 11:55:12','2025-06-24 12:00:33'),(125,10,'51819244437','changed','2025-06-24 14:59:09','2025-06-24 15:02:59'),(126,109,'29862074282','changed','2025-06-25 12:51:14','2025-06-25 12:54:21'),(127,132,'40830341229','expire','2025-06-30 07:46:44','2025-06-30 07:48:18'),(128,132,'68900411658','changed','2025-06-30 07:48:18','2025-06-30 07:49:19'),(129,73,'60854559998','pending','2025-06-30 16:22:22','2025-06-30 16:22:22'),(130,169,'43061357220','expire','2025-07-01 08:32:50','2025-07-01 08:33:12'),(131,169,'37687570919','expire','2025-07-01 08:33:12','2025-07-01 08:34:32'),(132,169,'21337095579','expire','2025-07-01 08:34:32','2025-07-01 08:36:07'),(133,169,'48608340988','changed','2025-07-01 08:36:07','2025-07-01 08:38:53'),(134,114,'35456529337','changed','2025-07-14 14:08:03','2025-07-14 14:10:07'),(135,41,'50056238041','changed','2025-07-15 09:29:50','2025-07-15 09:30:44');


