/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.19-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: pekanbaru_digital_sign
-- ------------------------------------------------------
-- Server version	10.11.19-MariaDB-ubu2404

/*!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 */;
/*!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 `tbl_sign`
--

DROP TABLE IF EXISTS `tbl_sign`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_sign` (
  `id_sign` int(11) NOT NULL AUTO_INCREMENT,
  `nip` varchar(18) NOT NULL,
  `email` varchar(100) NOT NULL,
  `token` varchar(5) NOT NULL,
  `status` enum('pending','active','revoke') DEFAULT 'pending',
  `sign_from` date DEFAULT NULL,
  `sign_to` date DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `deleted` datetime DEFAULT NULL,
  PRIMARY KEY (`id_sign`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_sign`
--

LOCK TABLES `tbl_sign` WRITE;
/*!40000 ALTER TABLE `tbl_sign` DISABLE KEYS */;
INSERT INTO `tbl_sign` VALUES
(1,'198508032009021007','augus.salim@gmail.com','VPBDW','active','2022-09-21','2032-09-21',NULL,'2022-11-13 12:28:27',NULL),
(2,'198909232020121007','nofirmanse@gmail.com','CBZHX','active','2022-09-21','2032-09-21',NULL,'2022-09-21 02:43:38',NULL),
(3,'199409112020121015','abdulbari1109@gmail.com','COPVZ','active','2022-09-22','2032-09-22',NULL,'2022-09-22 04:00:31',NULL),
(4,'198104102011021001','alfaizunthopank@gmail.com','OQIGJ','active','2022-09-22','2032-09-22',NULL,'2022-09-22 07:41:38',NULL),
(5,'198701052011022001','Janiarizka.dkp@gmail.com','EICPU','active','2022-09-22','2032-09-22',NULL,'2022-09-22 08:15:06',NULL),
(6,'198909122020121010','ramli1709@gmail.com','JFOGM','active','2022-09-22','2032-09-22',NULL,'2022-09-22 08:15:24',NULL),
(7,'198007182010011009','iwanafandi1980@gmail.com','OFUAJ','active','2022-09-23','2032-09-23',NULL,'2022-09-23 00:53:25',NULL),
(8,'198410132014072004','linarahayoe84@gmail.com','TMOHI','active','2022-09-23','2032-09-23',NULL,'2022-09-23 02:23:12',NULL),
(9,'197303091993031005','poetrakupapat@gmail.com','YKORV','active','2022-09-23','2032-09-23',NULL,'2022-09-23 04:16:19',NULL),
(10,'196306011986011002','dwiatmoko13@guru.smp.belajar.id','MQBTK','pending',NULL,NULL,NULL,NULL,NULL),
(11,'198707082014052001','sumarnianies@gmail.com','NSABQ','pending',NULL,NULL,NULL,NULL,NULL),
(12,'198707202015032002','eymajulianti1987@gmail.com','RWWQO','pending',NULL,NULL,NULL,NULL,NULL),
(13,'198307052009021006','fajriepedrosa@gmail.com','ZLQFY','active','2022-10-03','2032-10-03',NULL,'2022-10-03 13:01:25',NULL),
(14,'198304252006042008','dindahusna55@yahoo.co.id','IXNSY','active','2022-10-06','2032-10-06',NULL,'2022-10-06 02:56:55',NULL),
(15,'198606282015032003','rinasyarif1@gmail.com','WAIMB','active','2022-10-04','2032-10-04',NULL,'2022-10-04 05:58:06',NULL),
(16,'198201202005012006','puskesmasrumbai42@gmail.com','NQSEY','active','2022-10-04','2032-10-04',NULL,'2022-10-04 06:01:50',NULL),
(17,'197707132006041006','byhaqie@gmail.com','VZFRD','active','2022-10-04','2032-10-04',NULL,'2022-10-04 07:53:05',NULL),
(18,'199201162022031003','mfakhrig@gmail.com','ELKNF','active','2022-10-04','2032-10-04',NULL,'2022-10-04 12:40:57',NULL),
(19,'198709272014071001','rizki87ikhsan@gmail.com','SNYQA','active','2022-10-05','2032-10-05',NULL,'2022-10-05 01:54:12',NULL),
(20,'198211032012121001','noplinur@gmail.com','BZOJF','active','2022-10-10','2032-10-10',NULL,'2022-10-10 02:04:37',NULL),
(21,'197612142000031004','tkhairunnur@gmail.com','DNXHU','active','2022-10-11','2032-10-11',NULL,'2022-10-11 16:38:27',NULL),
(22,'199106012020121014','eaagung@gmail.com','TDCTO','active','2022-10-12','2032-10-12',NULL,'2022-10-12 01:36:40',NULL),
(23,'198506042010012011','dewimantilirasul@gmail.com','GXROR','active','2022-10-12','2032-10-12',NULL,'2022-10-12 04:10:08',NULL),
(24,'198611162011021001','randinova86@gmail.com','FMJDL','active','2022-10-14','2032-10-14',NULL,'2022-10-14 02:58:53',NULL),
(25,'197305132006042017','yetriasmerni26@gmail.com','LFCXZ','active','2022-10-17','2032-10-17',NULL,'2022-10-17 05:35:33',NULL),
(26,'198801022011011003','jeniadeerza@gmail.com','UMFRV','active','2022-10-29','2032-10-29',NULL,'2022-10-29 10:00:54',NULL),
(27,'199104112019031001','nonkekey9@gmail.com','HVVAU','pending',NULL,NULL,NULL,NULL,NULL),
(28,'199111072020121013','m.zakialhafiz@gmail.com','VPGRY','active','2022-11-01','2032-11-01',NULL,'2022-11-01 02:21:09',NULL),
(29,'199605042019031001','danifirmansyahhokky@gmail.com','AAJEC','active','2022-11-01','2032-11-01',NULL,'2022-11-01 02:47:10',NULL),
(30,'198704292019032001','rahmawee@gmail.com','VNPSP','pending',NULL,NULL,NULL,NULL,NULL),
(31,'198506042009022007','fatmawatiapri53@gmail.com','DUPDW','active','2022-11-03','2032-11-03',NULL,'2022-11-03 14:12:42',NULL),
(32,'197412122009022003','mulyatiu1212@gmail.com','HFBHW','pending',NULL,NULL,NULL,NULL,NULL),
(33,'197505172005011007','edi.kt75@gmail.com','MSXVB','active','2022-11-10','2032-11-10',NULL,'2022-11-10 04:44:23',NULL),
(34,'197108152006051001','akhmadnurdinsyah@gmail.com','FVVZC','active','2022-11-14','2032-11-14',NULL,'2022-11-14 01:37:30',NULL),
(35,'197208031997032001','thr3372@gmail.com','JSUIP','active','2022-11-14','2032-11-14',NULL,'2022-11-14 03:59:23',NULL),
(36,'197902092006042007','irmafebrianis@gmail.com','QUIGE','active','2022-11-14','2032-11-14',NULL,'2022-11-14 05:42:51',NULL),
(37,'198604142009021004','apriadikamri469@gmail.com','KWSAD','active','2022-11-14','2032-11-14',NULL,'2022-11-14 13:53:36',NULL),
(38,'199001042020122008','sri.wahyuningsih4190@gmail.com','CQKRC','pending',NULL,NULL,NULL,NULL,NULL),
(39,'198006012006042045','yeniandriasi16@guru.sd.belajar.id','NVXFM','active','2022-11-15','2032-11-15',NULL,'2022-11-15 06:41:29',NULL),
(40,'198407132010012007','fitrijulya@yahoo.com','YBJOF','active','2022-11-16','2032-11-16',NULL,'2022-11-16 03:09:01',NULL),
(41,'198610272011021001','Mayuindera103@gmail.com','BXDNE','active','2022-11-16','2032-11-16',NULL,'2022-11-16 07:39:47',NULL),
(42,'198009082009012004','erlina.wilda80@gmail.com','VROCF','pending',NULL,NULL,NULL,'2026-07-10 09:35:40',NULL),
(43,'199305212019031001','muhiqbal21.mi@gmail.com','UQBLJ','pending',NULL,NULL,NULL,NULL,NULL),
(44,'199304142019031001','farmasi.farel@gmail.com','NUOCU','pending',NULL,NULL,NULL,NULL,NULL),
(45,'198609032009032005','ratiherissa@gmail.com','LQKOA','pending',NULL,NULL,NULL,NULL,NULL),
(46,'198611072020121013','muhammad.reza@pekanbaru.go.id','TJHHZ','pending',NULL,NULL,NULL,NULL,NULL),
(47,'198610222022212002','astutiwidya018@gmail.com','QRKTJ','pending',NULL,NULL,NULL,NULL,NULL),
(48,'198204202010011018','hendrianis82@gmail.com','SYSFD','pending',NULL,NULL,NULL,'2023-01-02 07:38:03',NULL),
(49,'197511102001121010','rezafahlevi444@rocketmail.com','AVJUH','pending',NULL,NULL,NULL,NULL,NULL),
(50,'198207102005012006','nanayulia0710@gmail.com','XMZKE','pending',NULL,NULL,NULL,NULL,NULL),
(51,'197805122003121008','aripinwin@gmail.com','QKEQV','pending',NULL,NULL,NULL,'2023-01-04 02:02:15',NULL),
(52,'197808042021212001','nurhasnahharahap48@guru.smp.belajar.id','CYOXL','pending',NULL,NULL,NULL,NULL,NULL),
(53,'196706161993031005','jasreljs16@gmail.com','LZFWR','pending',NULL,NULL,NULL,NULL,NULL),
(54,'196904021995122001','repelitahasni@gmail.com','RGJQQ','pending',NULL,NULL,NULL,NULL,NULL),
(55,'198208012015031001','mirzawalad.pku@gmail.com','ETLHU','pending',NULL,NULL,NULL,NULL,NULL),
(56,'198705032010011004','kingjhie@gmail.com','HXOEM','pending',NULL,NULL,NULL,NULL,NULL),
(57,'199507182017082002','YESHIAF@GMAIL.COM','LYOMI','pending',NULL,NULL,NULL,NULL,NULL),
(58,'198309062014072004','dyuwita@gmail.com','QTZNE','pending',NULL,NULL,NULL,NULL,NULL),
(59,'197307072005041001','alexdirosa1973@gmail.com','TWILK','pending',NULL,NULL,NULL,'2025-03-15 02:14:58',NULL),
(60,'198404122009032008','jakarayak@gmail.com','NUOSB','pending',NULL,NULL,NULL,NULL,NULL),
(61,'197204112002122001','fennyafrita123@gmail.com','UZVJW','pending',NULL,NULL,NULL,NULL,NULL),
(62,'198208282011022002','amkrosmanelly@gmail.com','IQKQF','pending',NULL,NULL,NULL,'2025-05-21 05:56:27',NULL),
(63,'200006172025042001','ejovankaaulia@gmail.com','DCVHY','pending',NULL,NULL,NULL,NULL,NULL),
(64,'200005252025042014','nahdafaadhilap@gmail.com','RHQCY','pending',NULL,NULL,NULL,'2025-07-01 08:20:37',NULL),
(65,'198903292025211005','sutioa11@gmail.com','XLRZR','pending',NULL,NULL,NULL,NULL,NULL),
(66,'199110312025041003','datukvikry@gmail.com','JSZJG','pending',NULL,NULL,NULL,'2025-07-19 06:31:28',NULL),
(67,'199103232025041001','ardishf@gmail.com','DNOAC','pending',NULL,NULL,NULL,NULL,NULL),
(68,'198412162024211006','brama03.13@gmail.com','LORYB','active','2025-10-14','2035-10-14',NULL,'2025-10-14 03:49:33',NULL),
(69,'199907162025041005','adriyan.putra16@gmail.com','VUYSN','active','2025-11-07','2035-11-07',NULL,'2025-11-07 02:40:25',NULL),
(70,'198701302015032001','felcarosiana87@gmail.com','UAHDQ','active','2025-12-04','2035-12-04',NULL,'2025-12-04 08:23:01',NULL),
(71,'198106102024211002','agusfitrifaiz@gmail.com','OVXVZ','active','2025-12-05','2035-12-05',NULL,'2025-12-05 02:27:48',NULL),
(72,'197612182010011003','asd@gmail.com','HDGCD','pending',NULL,NULL,NULL,NULL,NULL),
(73,'197903052005011004','aak05_cute@yahoo.com','OZIIJ','pending',NULL,NULL,NULL,NULL,NULL),
(74,'199708202025041001','denisapri97@gmail.com','TOFWZ','active','2026-01-06','2036-01-06',NULL,'2026-01-06 01:50:41',NULL),
(75,'198708012020122003','nafisahdaulay0108@gmail.com','IIUJF','active','2026-02-11','2036-02-11',NULL,'2026-02-11 07:41:16',NULL),
(76,'199108182019032001','fannychiandra@gmail.com','SQQHL','active','2026-02-11','2036-02-11',NULL,'2026-02-11 13:16:19',NULL),
(77,'197609121996021002','spribaditeguh@gmail.com','NWAQG','active','2026-03-15','2036-03-15',NULL,'2026-03-15 10:02:50',NULL),
(78,'198409252010011019','ruby.adrian.ra@gmail.com','QJHQB','active','2026-03-12','2036-03-12',NULL,'2026-03-12 05:01:37',NULL),
(79,'198508062009022007','riskafatmawati68@guru.sd.belajar.id','JEQTV','pending',NULL,NULL,NULL,NULL,NULL),
(80,'198207102005012006','mommynana41@gmail.com','KUTLF','pending',NULL,NULL,NULL,NULL,NULL),
(81,'200308252026021001','idrishamid6@gmail.com','THABW','pending',NULL,NULL,NULL,NULL,NULL),
(82,'198301022025211106','fadh1283@gmail.com','NDLEO','active','2026-04-14','2036-04-14',NULL,'2026-04-14 10:54:58',NULL),
(83,'198201102005022005','ekinerja.yesti82@gmail.com','VSGDW','pending',NULL,NULL,NULL,NULL,NULL),
(84,'197212041998031004','afrizaladinata4@gmail.com','ZVQJY','active','2026-04-24','2036-04-24',NULL,'2026-04-24 00:11:25',NULL),
(85,'198407292006041002','yasril97@guru.sd.belajar.id','XSEOU','pending',NULL,NULL,NULL,NULL,NULL),
(86,'198204212023212012','afreni2019@gmail.com','NQDMT','active','2026-04-29','2036-04-29',NULL,'2026-04-29 12:24:57',NULL),
(87,'199310092025211115','usnanarif09@gmail.com','NWCFB','pending',NULL,NULL,NULL,NULL,NULL),
(88,'198304232025212007','indahmanurung34@guru.sd.belajar.id','ZBBAI','pending',NULL,NULL,NULL,NULL,NULL),
(89,'199605192025211055','rezkytungkin1996@gmail.com','HNKZZ','pending',NULL,NULL,NULL,'2026-06-10 02:36:53',NULL),
(90,'199410282024212009','juwitalestari80@guru.sd.belajar.id','FQMJF','pending',NULL,NULL,NULL,NULL,NULL),
(91,'199602132022211001','anshoriramadhan32@guru.smp.belajar.id','ODUZI','pending',NULL,NULL,NULL,NULL,NULL),
(92,'196707042014072004','minarni.putri67@gmail.com','PWAMD','pending',NULL,NULL,NULL,NULL,NULL),
(93,'198912092023211020','si.bkd.pku@gmail.com','HOHFN','pending',NULL,NULL,NULL,NULL,NULL),
(94,'198205262011011003','tengku.andyrokan82@gmail.com','KDMNT','pending',NULL,NULL,NULL,NULL,NULL),
(95,'197705122010011016','syaifurrahman648@gmail.com','QPZFR','pending',NULL,NULL,NULL,NULL,NULL),
(96,'198707082025211180','abisauqisiregar@gmail.com','LHAQA','pending',NULL,NULL,NULL,NULL,NULL),
(97,'200108172025212033','sherlyhutririchie@gmail.com','BRZTB','pending',NULL,NULL,NULL,NULL,NULL),
(98,'199808242025212143','milkhairrr@gmail.com','AGUVY','pending',NULL,NULL,NULL,NULL,NULL),
(99,'197911112024212003','denianggraini218@gmail.com','SLJBR','pending',NULL,NULL,NULL,NULL,NULL),
(100,'199510122025211109','daudrambe930@gmail.com','IUGHB','pending',NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `tbl_sign` 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-22 11:48:31