Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
absent.sql	29.79 KB	-rw-r--r--
admfeestr.sql	9.74 MB	-rw-r--r--
ansstud.sql	49.55 MB	-rw-r--r--
appcanddet.sql	509.81 KB	-rw-r--r--
appcandsum.sql	1.15 MB	-rw-r--r--
appstudfee.sql	47.11 MB	-rw-r--r--
canddet.sql	139.49 MB	-rw-r--r--
candsum.sql	55.66 MB	-rw-r--r--
colldeg.sql	1.49 MB	-rw-r--r--
colldesp.sql	32.64 KB	-rw-r--r--
college.sql	108.77 KB	-rw-r--r--
collexam.sql	24.01 MB	-rw-r--r--
collia.sql	34.05 KB	-rw-r--r--
dcstud.sql	35.7 MB	-rw-r--r--
dctran.sql	7.01 MB	-rw-r--r--
degcntr.sql	21.38 KB	-rw-r--r--
degree.sql	310.87 KB	-rw-r--r--
exam_app_marks_results_exam_pr...	78.06 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	78.07 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	78.09 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	78.11 MB	-rw-r--r--
marks.sql	15.72 KB	-rw-r--r--
marks_pr.sql	16.88 KB	-rw-r--r--
masroom.sql	85.53 KB	-rw-r--r--
practical_entry_freeze.sql	11.07 KB	-rw-r--r--
res_fee.sql	62.15 MB	-rw-r--r--
res_stud.sql	9.44 MB	-rw-r--r--
res_studsum.sql	2.61 MB	-rw-r--r--
resmarks.sql	280.72 MB	-rw-r--r--
resmarksdet.sql	357.43 MB	-rw-r--r--
room_allotment.sql	69.73 KB	-rw-r--r--
servdetl.sql	399.08 KB	-rw-r--r--
servfee.sql	5.6 KB	-rw-r--r--
servfeestr.sql	356.81 KB	-rw-r--r--
servproc.sql	3.99 KB	-rw-r--r--
servtran.sql	1.46 MB	-rw-r--r--
servtype.sql	4.01 KB	-rw-r--r--
student.sql	341.63 MB	-rw-r--r--
studfee.sql	558.56 KB	-rw-r--r--
subject.sql	7.21 MB	-rw-r--r--
tdvs_abreq.sql	913 B	-rw-r--r--
tdvs_check.sql	913 B	-rw-r--r--
tdvs_control.sql	2.19 KB	-rw-r--r--
tdvs_deggrp.sql	2.94 KB	-rw-r--r--
tdvs_masboard.sql	2.28 KB	-rw-r--r--
tdvs_mascomp.sql	913 B	-rw-r--r--
tdvs_masdev.sql	913 B	-rw-r--r--
tdvs_masmenu.sql	8.33 KB	-rw-r--r--
tdvs_masqp.sql	441.46 KB	-rw-r--r--
tdvs_masrev.sql	2.68 KB	-rw-r--r--
tdvs_masteach.sql	665.66 KB	-rw-r--r--
tdvs_qptempdetl.sql	3.75 KB	-rw-r--r--
tdvs_qptemphead.sql	2.89 KB	-rw-r--r--
tdvs_tabdetl.sql	3 KB	-rw-r--r--
tdvs_tabhead.sql	3.37 KB	-rw-r--r--
tdvs_tabpkt.sql	2.64 KB	-rw-r--r--
tdvs_tabsum.sql	3.48 KB	-rw-r--r--
tdvs_tabulate.sql	3.17 KB	-rw-r--r--
tdvs_tabuser.sql	3.65 KB	-rw-r--r--
tdvs_valcntr.sql	2.16 KB	-rw-r--r--

Code Editor : absent.sql

-- MySQL dump 10.13  Distrib 5.7.42, for Linux (x86_64)
--
-- Host: logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com    Database: logisys3_kus
-- ------------------------------------------------------
-- Server version	5.7.12

/*!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 */;
SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
SET @@SESSION.SQL_LOG_BIN= 0;

--
-- Table structure for table `absent`
--

DROP TABLE IF EXISTS `absent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `absent` (
  `FDEGREE` varchar(10) DEFAULT NULL,
  `FEXAMNO` varchar(5) DEFAULT NULL,
  `FCOLLCODE` varchar(10) NOT NULL,
  `FCSUBCODE` varchar(10) DEFAULT NULL,
  `FREGNO` varchar(10) NOT NULL,
  `FDOE` date DEFAULT NULL,
  `FSESSION` varchar(5) DEFAULT NULL,
  `FABSTYPE` varchar(3) DEFAULT NULL,
  `FLOGNAME` varchar(10) DEFAULT NULL,
  `FLOGDATE` datetime DEFAULT NULL,
  `FDELETED` varchar(1) DEFAULT NULL,
  `FQPCODE` varchar(7) NOT NULL,
  `FYEAR` varchar(4) DEFAULT NULL,
  `FEXAMTYPE` varchar(1) DEFAULT NULL,
  `fupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fabsms` varchar(1) DEFAULT NULL,
  `fappab` varchar(1) DEFAULT NULL,
  `fcollremarks` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`FCOLLCODE`,`FREGNO`,`FQPCODE`),
  KEY `FDEGREE` (`FDEGREE`),
  KEY `FCOLLCODE` (`FCOLLCODE`),
  KEY `FEXAMNO` (`FEXAMNO`),
  KEY `FREGNO` (`FREGNO`),
  KEY `FSUBCODE` (`FCSUBCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `absent`
--

LOCK TABLES `absent` WRITE;
/*!40000 ALTER TABLE `absent` DISABLE KEYS */;
INSERT INTO `absent` VALUES ('BA2','C','101','C210','A1510011','2024-12-17','AM','QpA','admin','2024-12-17 10:12:34','F','10321','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BA2','D','101','D210','A1510011','2024-12-17','PM','QpA','admin','2024-12-17 15:12:14','F','10421','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BA2','E','101','E210','A1510011','2024-12-16','AM','QpA','admin','2024-12-16 10:12:40','F','10521','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','E','101','E211','A1510011','2024-12-18','AM','QpA','admin','2024-12-18 10:22:13','F','10522','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','F','101','F210','A1510011','2024-12-16','PM','QpA','admin','2024-12-16 15:20:35','F','10621','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','101','F211','A1510011','2024-12-18','PM','QpA','admin','2024-12-18 15:13:28','F','10622','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','F','101','F210','A1717645','2024-12-16','PM','QpA','admin','2024-12-16 15:20:35','F','10621','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','101','F211','A1717645','2024-12-18','PM','QpA','admin','2024-12-18 15:13:28','F','10622','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','C','101','C240','A2010863','2024-12-19','AM','QpA','admin','2024-12-19 10:23:15','F','10323','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BBA','C','101','C410','BB177008','2024-12-17','AM','QpA','admin','2024-12-17 10:13:23','F','19341','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BBA','F','101','F410','BB177008','2024-12-16','PM','QpA','admin','2024-12-16 15:21:01','F','19641','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BBA','F','101','F420','BB177008','2024-12-18','PM','QpA','admin','2024-12-18 15:13:45','F','19642','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BBA','E','101','E420','BB207002','2024-12-18','AM','QpA','admin','2024-12-18 10:21:52','F','19542','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BBA','E','101','E420','BB207008','2024-12-18','AM','QpA','admin','2024-12-18 10:21:52','F','19542','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BBA','E','101','E420','BB207009','2024-12-18','AM','QpA','admin','2024-12-18 10:21:52','F','19542','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCOM5','E','101','E410','C1901183','2024-12-16','AM','QpA','admin','2024-12-16 10:13:12','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','C','101','C410','C2001027','2024-12-17','AM','QpA','admin','2024-12-17 10:13:02','F','18301','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCOM5','E','101','E410','C2009138','2024-12-16','AM','QpA','admin','2024-12-16 10:13:12','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','C','101','C540','S2004617','2024-12-19','AM','QpA','admin','2024-12-19 10:22:59','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','D','101','D760','S2004635','2024-12-17','PM','QpA','admin','2024-12-17 15:11:55','F','15427','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BSC2','D','101','D540','S2004635','2024-12-19','PM','QpA','admin','2024-12-19 15:15:55','F','15440','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BA2','E','105','E210','A1911734','2024-12-16','AM','QpA','admin','2024-12-16 10:47:13','F','10521','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','E','105','E211','A1911734','2024-12-18','AM','QpA','admin','2024-12-18 11:45:42','F','10522','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','C','105','C240','A2018598','2024-12-19','AM','QpA','admin','2024-12-19 10:42:02','F','10323','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BCA6','E','105','E410','BC181526','2024-12-16','AM','QpA','admin','2024-12-16 10:48:46','F','12561','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','C','105','C540','S1907333','2024-12-19','AM','QpA','admin','2024-12-19 10:41:27','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','D','105','D540','S2009242','2024-12-19','PM','QpA','admin','2024-12-19 15:48:23','F','15440','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','C','105','C540','S2009319','2024-12-19','AM','QpA','admin','2024-12-19 10:41:27','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BA2','E','112','E210','a1812933','2024-12-16','AM','QpA','admin','2024-12-16 12:09:32','F','10521','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','E','112','E211','A1812933','2024-12-18','AM','QpA','admin','2024-12-18 11:29:58','F','10522','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','E','126','E210','A0829821','2024-12-16','AM','QpA','office','2024-12-16 11:13:51','F','10521','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','E','126','E210','A1105490','2024-12-16','AM','QpA','office','2024-12-16 11:13:51','F','10521','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','E','126','E211','a1105490','2024-12-18','AM','QpA','OFFICE','2024-12-18 10:35:19','F','10522','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','C','126','C210','A2014847','2024-12-17','AM','QpA','office','2024-12-17 10:24:26','F','10321','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BA2','C','126','C240','A2014847','2024-12-19','AM','QpA','office','2024-12-19 11:26:43','F','10323','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BCA7','C','126','C410','BC200507','2024-12-17','AM','QpA','office','2024-12-17 10:23:08','F','12371','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCA7','D','126','D420','bc200507','2024-12-19','PM','QpA','office','2024-12-19 15:58:40','F','12472','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BCA7','E','126','E410','BC200507','2024-12-16','AM','QpA','office','2024-12-16 11:15:47','F','12571','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCA7','E','126','E420','bc200507','2024-12-18','AM','QpA','OFFICE','2024-12-18 10:35:46','F','12572','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCA7','F','126','F410','BC200507','2024-12-16','PM','QpA','office','2024-12-16 15:40:53','F','12671','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCA7','F','126','F420','BC200507','2024-12-18','PM','QpA','OFFICE','2024-12-18 15:51:30','F','12672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCOM4','C','126','C410','C1510073','2024-12-17','AM','QpA','office','2024-12-17 10:23:50','F','18341','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCOM4','F','126','F410','C1510073','2024-12-16','PM','QpA','office','2024-12-16 15:40:20','F','18641','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','E','126','E410','C1810057','2024-12-16','AM','QpA','office','2024-12-16 11:16:38','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','F','126','F420','C1913915','2024-12-18','PM','QpA','OFFICE','2024-12-18 15:51:58','F','18602','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCOM5','C','126','C410','C2007316','2024-12-17','AM','QpA','office','2024-12-17 10:26:03','F','18301','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BSC2','D','126','D530','s0600851','2024-12-19','PM','QpA','office','2024-12-19 15:59:41','F','15422','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','E','126','E220','S0600851','2024-12-16','AM','QpA','office','2024-12-16 11:11:59','F','15523','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','E','126','E221','s0600851','2024-12-18','AM','QpA','OFFICE','2024-12-18 10:34:54','F','15524','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','F','126','F220','S0600851','2024-12-16','PM','QpA','office','2024-12-16 15:41:21','F','15623','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','F','126','F221','S0600851','2024-12-18','PM','QpA','OFFICE','2024-12-18 15:52:25','F','15624','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','C','126','C540','S1803394','2024-12-19','AM','QpA','office','2024-12-19 11:31:22','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','C','126','C540','S1903346','2024-12-19','AM','QpA','office','2024-12-19 11:31:22','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','C','126','C760','S1903427','2024-12-17','AM','QpA','office','2024-12-17 10:25:31','F','15327','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BSC2','C','126','C540','S1903427','2024-12-19','AM','QpA','office','2024-12-19 11:31:22','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','F','126','F250','S1903427','2024-12-16','PM','QpA','office','2024-12-16 15:42:34','F','15671','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','F','126','F251','S1903427','2024-12-18','PM','QpA','OFFICE','2024-12-18 15:53:29','F','15672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','F','126','F250','S1903509','2024-12-16','PM','QpA','office','2024-12-16 15:42:34','F','15671','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','F','126','F251','S1903509','2024-12-18','PM','QpA','OFFICE','2024-12-18 15:53:29','F','15672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','E','126','E250','S2003360','2024-12-16','AM','QpA','office','2024-12-16 11:12:56','F','15571','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','E','126','E251','s2003360','2024-12-18','AM','QpA','OFFICE','2024-12-18 10:36:22','F','15572','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','F','126','F250','S2003360','2024-12-16','PM','QpA','office','2024-12-16 15:42:34','F','15671','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','F','126','F251','S2003360','2024-12-18','PM','QpA','OFFICE','2024-12-18 15:53:29','F','15672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','E','126','E251','s2003366','2024-12-18','AM','QpA','OFFICE','2024-12-18 10:36:22','F','15572','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','C','126','C760','S2003376','2024-12-17','AM','QpA','office','2024-12-17 10:25:31','F','15327','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BSC2','D','126','D760','S2003376','2024-12-17','PM','QpA','office','2024-12-17 16:18:07','F','15427','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BSC2','E','126','E250','S2003376','2024-12-16','AM','QpA','office','2024-12-16 11:12:56','F','15571','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','F','126','F250','S2003376','2024-12-16','PM','QpA','office','2024-12-16 15:42:34','F','15671','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','F','126','F251','S2003376','2024-12-18','PM','QpA','OFFICE','2024-12-18 15:53:29','F','15672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','D','126','D540','s2003433','2024-12-19','PM','QpA','office','2024-12-19 16:01:11','F','15440','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','D','126','D540','s2003452','2024-12-19','PM','QpA','office','2024-12-19 16:01:11','F','15440','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','D','126','D760','S2003825','2024-12-17','PM','QpA','office','2024-12-17 16:18:07','F','15427','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BA2','D','136','D210','A1107048','2024-12-17','PM','QpA','admin','2024-12-17 15:19:51','F','10421','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BA2','E','136','E210','A1716642','2024-12-16','AM','QpA','admin','2024-12-16 10:21:00','F','10521','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','136','F210','A1716642','2024-12-16','PM','QpA','admin','2024-12-16 15:10:35','F','10621','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BBA','C','136','C420','BB188920','2024-12-19','AM','QpA','admin','2024-12-19 11:49:14','F','19342','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BCA7','D','136','D410','BC201607','2024-12-17','PM','QpA','admin','2024-12-17 15:20:36','F','12471','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCA7','F','136','F410','BC201607','2024-12-16','PM','QpA','admin','2024-12-16 15:12:06','F','12671','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCA7','F','136','F420','BC201607','2024-12-18','PM','QpA','admin','2024-12-18 15:14:31','F','12672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCOM5','D','136','D410','C1807812','2024-12-17','PM','QpA','admin','2024-12-17 15:21:40','F','18401','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCOM5','E','136','E410','C1911538','2024-12-16','AM','QpA','admin','2024-12-16 10:20:35','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','C','136','C410','C2007950','2024-12-17','AM','QpA','admin','2024-12-17 10:40:42','F','18301','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BSC2','C','136','C540','S1804025','2024-12-19','AM','QpA','admin','2024-12-19 11:48:44','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','E','136','E250','S1909710','2024-12-16','AM','QpA','admin','2024-12-16 10:21:24','F','15571','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','E','136','E251','S1909710','2024-12-18','AM','QpA','admin','2024-12-18 11:16:39','F','15572','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','D','136','D760','S2009721','2024-12-17','PM','QpA','admin','2024-12-17 15:21:04','F','15427','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BSC2','D','136','D540','S2009725','2024-12-19','PM','QpA','admin','2024-12-19 15:24:01','F','15440','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BA2','F','137','F210','A1317140','2024-12-16','PM','QpA','admin','2024-12-16 14:53:44','F','10621','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','137','F211','A1317140','2024-12-18','PM','QpA','admin','2024-12-18 15:00:44','F','10622','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','E','137','E211','A2012712','2024-12-18','AM','QpA','admin','2024-12-18 10:46:06','F','10522','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCOM4','F','137','F410','C1336671','2024-12-16','PM','QpA','admin','2024-12-16 14:54:09','F','18641','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM4','F','137','F420','C1336671','2024-12-18','PM','QpA','admin','2024-12-18 15:00:28','F','18642','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','E','138','E210','A2017357','2024-12-16','AM','QpA','Admin','2024-12-16 10:32:38','F','10521','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','E','138','E211','A2017357','2024-12-18','AM','QpA','Admin','2024-12-18 11:19:10','F','10522','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','F','163','F210','A0850278','2024-12-16','PM','QpA','admin','2024-12-16 15:53:53','F','10621','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','163','F211','A0850278','2024-12-18','PM','QpA','admin','2024-12-18 15:08:58','F','10622','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','D','163','D210','A1204118','2024-12-17','PM','QpA','admin','2024-12-17 14:58:29','F','10421','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BBA','C','163','C410','BB197801','2024-12-17','AM','QpA','admin','2024-12-17 11:07:28','F','19341','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BBA','F','163','F410','BB197801','2024-12-16','PM','QpA','admin','2024-12-16 15:52:54','F','19641','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BBM6','D','163','D420','bm137833','2024-12-19','PM','QpA','admin','2024-12-19 15:15:59','F','19442','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BCOM5','C','163','C410','C1905561','2024-12-17','AM','QpA','admin','2024-12-17 11:06:18','F','18301','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCOM5','C','163','C410','C2005356','2024-12-17','AM','QpA','admin','2024-12-17 11:06:18','F','18301','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCOM5','E','163','E410','C2005520','2024-12-16','AM','QpA','admin','2024-12-16 10:50:30','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('MHCH','C','163','C210','IC190017','2024-12-17','AM','QpA','admin','2024-12-17 11:07:10','F','15351','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('MHCH','E','163','E210','IC190017','2024-12-16','AM','QpA','admin','2024-12-16 10:50:54','F','15575','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('MHCH','E','163','E211','IC190017','2024-12-18','AM','QpA','admin','2024-12-18 10:50:49','F','15576','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','C','163','C540','s1808250','2024-12-19','AM','QpA','admin','2024-12-19 11:24:19','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','D','163','D760','S1808337','2024-12-17','PM','QpA','admin','2024-12-17 14:58:11','F','15427','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BSC2','C','163','C540','s1908280','2024-12-19','AM','QpA','admin','2024-12-19 11:24:19','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','E','163','E250','S1908608','2024-12-16','AM','QpA','admin','2024-12-16 10:49:44','F','15571','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','E','163','E251','s1908608','2024-12-18','AM','QpA','admin','2024-12-18 10:49:44','F','15572','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','F','163','F250','S2003740','2024-12-16','PM','QpA','admin','2024-12-16 15:53:25','F','15671','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','F','163','F251','S2003740','2024-12-18','PM','QpA','admin','2024-12-18 15:08:35','F','15672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','C','163','C870','s2008220','2024-12-19','AM','QpA','admin','2024-12-19 11:21:37','F','15339','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','F','163','F250','S2008291','2024-12-16','PM','QpA','admin','2024-12-16 15:53:25','F','15671','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','F','163','F251','S2008291','2024-12-18','PM','QpA','admin','2024-12-18 15:08:35','F','15672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','C','163','C540','s2008391','2024-12-19','AM','QpA','admin','2024-12-19 11:24:19','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BA2','F','403','F210','A1113958','2024-12-16','PM','QpA','ADMIN','2024-12-16 15:22:36','F','10621','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','403','F211','A1113958','2024-12-18','PM','QpA','ADMIN','2024-12-18 15:08:03','F','10622','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCOM5','C','403','C410','C2014980','2024-12-17','AM','QpA','ADMIN','2024-12-17 10:44:09','F','18301','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCOM5','F','403','F410','C2015109','2024-12-16','PM','QpA','ADMIN','2024-12-16 15:22:59','F','18601','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','E','403','E410','C2015117','2024-12-16','AM','QpA','ADMIN','2024-12-16 10:26:46','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','406','F210','A1620351','2024-12-16','PM','QpA','admin','2024-12-16 15:18:40','F','10621','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','406','F211','A1620351','2024-12-18','PM','QpA','admin','2024-12-18 16:02:11','F','10622','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','F','406','F210','A2020417','2024-12-16','PM','QpA','admin','2024-12-16 15:18:40','F','10621','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','406','F211','A2020417','2024-12-18','PM','QpA','admin','2024-12-18 16:02:11','F','10622','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','F','406','F210','A2020419','2024-12-16','PM','QpA','admin','2024-12-16 15:18:40','F','10621','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','406','F211','A2020419','2024-12-18','PM','QpA','admin','2024-12-18 16:02:11','F','10622','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','C','406','C240','A2020459','2024-12-19','AM','QpA','admin','2024-12-19 10:49:18','F','10323','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BCA7','C','406','C420','BC201713','2024-12-19','AM','QpA','admin','2024-12-19 10:48:05','F','12372','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BCA7','D','406','D410','BC201713','2024-12-17','PM','QpA','admin','2024-12-17 15:36:07','F','12471','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BBM6','F','406','F410','BM149673','2024-12-16','PM','QpA','admin','2024-12-16 15:17:05','F','19641','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM4','D','406','D410','C1615537','2024-12-17','PM','QpA','admin','2024-12-17 15:35:20','F','18441','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCOM4','C','406','C410','C1715641','2024-12-17','AM','QpA','admin','2024-12-17 10:31:10','F','18341','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCOM4','E','406','E410','C1715641','2024-12-16','AM','QpA','admin','2024-12-16 10:24:37','F','18541','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM4','F','406','F410','C1715641','2024-12-16','PM','QpA','admin','2024-12-16 15:18:04','F','18641','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','E','406','E410','C1915587','2024-12-16','AM','QpA','admin','2024-12-16 10:28:10','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','F','406','F410','C1915633','2024-12-16','PM','QpA','admin','2024-12-16 15:17:40','F','18601','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','F','406','F420','C1915633','2024-12-18','PM','QpA','admin','2024-12-18 15:56:13','F','18602','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCOM5','E','406','E410','C1915825','2024-12-16','AM','QpA','admin','2024-12-16 10:28:10','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','E','406','E420','C1915825','2024-12-18','AM','QpA','admin','2024-12-18 10:32:15','F','18502','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCOM5','E','406','E410','C1922301','2024-12-16','AM','QpA','admin','2024-12-16 10:28:10','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','E','406','E410','C2015324','2024-12-16','AM','QpA','admin','2024-12-16 10:28:10','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','E','406','E410','C2015650','2024-12-16','AM','QpA','admin','2024-12-16 10:28:10','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','E','406','E410','C2016402','2024-12-16','AM','QpA','admin','2024-12-16 10:28:10','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','E','406','E410','C2021457','2024-12-16','AM','QpA','admin','2024-12-16 10:28:10','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','F','406','F410','C2021457','2024-12-16','PM','QpA','admin','2024-12-16 15:17:40','F','18601','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','C','406','C540','S2005711','2024-12-19','AM','QpA','admin','2024-12-19 10:50:58','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','D','406','D760','S2005711','2024-12-17','PM','QpA','admin','2024-12-17 15:34:16','F','15427','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BSC2','D','406','D540','S2005711','2024-12-19','PM','QpA','admin','2024-12-19 16:09:25','F','15440','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','E','406','E250','S2005711','2024-12-16','AM','QpA','admin','2024-12-16 10:25:15','F','15571','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','E','406','E251','S2005711','2024-12-18','AM','QpA','admin','2024-12-18 10:30:17','F','15572','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','F','406','F250','S2005711','2024-12-16','PM','QpA','admin','2024-12-16 15:19:12','F','15671','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','F','406','F251','S2005711','2024-12-18','PM','QpA','admin','2024-12-18 15:59:49','F','15672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','C','406','C540','S2007501','2024-12-19','AM','QpA','admin','2024-12-19 10:50:59','F','15340','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BSC2','D','406','D760','S2007501','2024-12-17','PM','QpA','admin','2024-12-17 15:34:16','F','15427','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BSC2','E','406','E251','S2007501','2024-12-18','AM','QpA','admin','2024-12-18 10:30:17','F','15572','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','F','406','F250','S2007501','2024-12-16','PM','QpA','admin','2024-12-16 15:19:12','F','15671','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BSC2','F','406','F251','S2007501','2024-12-18','PM','QpA','admin','2024-12-18 15:59:49','F','15672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','F','406','F251','S2007548','2024-12-18','PM','QpA','admin','2024-12-18 15:59:49','F','15672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','E','406','E251','S2007552','2024-12-18','AM','QpA','admin','2024-12-18 10:30:17','F','15572','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BSC2','F','406','F251','S2007552','2024-12-18','PM','QpA','admin','2024-12-18 15:59:49','F','15672','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','F','409','F210','A2022442','2024-12-16','PM','QpA','ADMIN','2024-12-16 15:09:56','F','10621','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','409','F211','A2022442','2024-12-18','PM','QpA','ADMIN','2024-12-18 15:11:18','F','10622','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BBA','F','409','F420','BB209873','2024-12-18','PM','QpA','ADMIN','2024-12-18 15:13:25','F','19642','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCOM5','E','409','E410','C1917607','2024-12-16','AM','QpA','ADMIN','2024-12-16 10:39:12','F','18501','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BCOM5','C','409','C410','C2019503','2024-12-17','AM','QpA','ADMIN','2024-12-17 10:51:31','F','18301','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCOM5','D','409','D410','C2019503','2024-12-17','PM','QpA','ADMIN','2024-12-17 14:58:27','F','18401','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BSC2','D','409','D530','S1706004','2024-12-19','PM','QpA','ADMIN','2024-12-19 14:58:25','F','15422','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BA2','E','416','E210','A2023016','2024-12-16','AM','QpA','Admin','2024-12-16 10:56:39','F','10521','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','E','416','E211','A2023016','2024-12-18','AM','QpA','Admin','2024-12-18 10:27:00','F','10522','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','C','416','C210','A2023044','2024-12-17','AM','QpA','Admin','2024-12-17 10:30:24','F','10321','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BA2','D','416','D210','A2023044','2024-12-17','PM','QpA','Admin','2024-12-17 14:44:27','F','10421','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BA2','D','416','D240','A2023044','2024-12-19','PM','QpA','Admin','2024-12-19 15:09:33','F','10423','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BA2','E','416','E210','A2023044','2024-12-16','AM','QpA','Admin','2024-12-16 10:56:39','F','10521','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','E','416','E211','A2023044','2024-12-18','AM','QpA','Admin','2024-12-18 10:27:00','F','10522','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BA2','F','416','F210','A2023044','2024-12-16','PM','QpA','Admin','2024-12-16 15:11:18','F','10621','2024','1','2024-12-17 00:30:02',NULL,'T',NULL),('BA2','F','416','F211','A2023044','2024-12-18','PM','QpA','Admin','2024-12-18 15:12:18','F','10622','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BBA','D','416','D420','BB157703','2024-12-19','PM','QpA','Admin','2024-12-19 15:11:03','F','19442','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BBA','E','416','E420','BB157703','2024-12-18','AM','QpA','Admin','2024-12-18 10:27:29','F','19542','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCOM5','D','416','D420','C1818977','2024-12-19','PM','QpA','Admin','2024-12-19 15:10:28','F','18402','2024','1','2024-12-20 00:30:02',NULL,'T',NULL),('BCOM5','F','416','F420','C1818977','2024-12-18','PM','QpA','Admin','2024-12-18 15:12:49','F','18602','2024','1','2024-12-19 00:30:03',NULL,'T',NULL),('BCOM5','C','416','C410','C2004856','2024-12-17','AM','QpA','Admin','2024-12-17 10:30:47','F','18301','2024','1','2024-12-18 00:30:02',NULL,'T',NULL),('BCOM5','F','416','F420','C2018322','2024-12-18','PM','QpA','Admin','2024-12-18 15:12:49','F','18602','2024','1','2024-12-19 00:30:03',NULL,'T',NULL);
/*!40000 ALTER TABLE `absent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- GTID state at the end of the backup 
--

SET @@GLOBAL.GTID_PURGED='';
/*!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 2024-12-20 10:02:02

${this.title}

Code Editor : absent.sql