Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
absent.sql	3.38 KB	-rw-r--r--
admfeestr.sql	152.39 KB	-rw-r--r--
ansstud.sql	2.17 KB	-rw-r--r--
appcanddet.sql	2.66 KB	-rw-r--r--
appcandsum.sql	5.86 KB	-rw-r--r--
appstudfee.sql	2.77 KB	-rw-r--r--
bkpzip2021-12-01-12-56-04.zip	950 B	-rw-r--r--
bkpzip2022-01-01-04-46-31.zip	5.66 KB	-rw-r--r--
canddet.sql	2.08 MB	-rw-r--r--
candsum.sql	911.76 KB	-rw-r--r--
colldeg.sql	50.54 KB	-rw-r--r--
colldesp.sql	2.55 KB	-rw-r--r--
college.sql	9.46 KB	-rw-r--r--
collexam.sql	225.15 KB	-rw-r--r--
collia.sql	33.9 KB	-rw-r--r--
dcstud.sql	2.52 KB	-rw-r--r--
dctran.sql	3.18 KB	-rw-r--r--
degcntr.sql	2.25 KB	-rw-r--r--
degree.sql	76.7 KB	-rw-r--r--
exam_app_marks_results_exam_pr...	1.86 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	1.84 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	1.84 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	1.92 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	2.49 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	2.26 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	2.38 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	2.82 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	2.95 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	2.98 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	3.2 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	4.02 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	3.6 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	3.85 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	3.87 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	4.26 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	4.12 MB	-rw-r--r--
exam_app_marks_results_exam_pr...	4.19 MB	-rw-r--r--
marks.sql	3.11 MB	-rw-r--r--
marks_pr.sql	6.91 KB	-rw-r--r--
marks_results_2022-07-14-01-01...	2.09 MB	-rw-r--r--
marks_results_2022-10-31-11-10...	2.54 MB	-rw-r--r--
masroom.sql	13.42 KB	-rw-r--r--
practical_entry_freeze.sql	5.59 KB	-rw-r--r--
res_fee.sql	3.91 MB	-rw-r--r--
res_stud.sql	3.95 KB	-rw-r--r--
res_studsum.sql	2.35 KB	-rw-r--r--
resmarks.sql	43.02 MB	-rw-r--r--
resmarksdet.sql	38.94 MB	-rw-r--r--
room_allotment.sql	16.56 KB	-rw-r--r--
servdetl.sql	2.21 KB	-rw-r--r--
servfee.sql	2.16 KB	-rw-r--r--
servfeestr.sql	2.14 KB	-rw-r--r--
servproc.sql	2.13 KB	-rw-r--r--
servtran.sql	3.49 KB	-rw-r--r--
servtype.sql	2.2 KB	-rw-r--r--
student.sql	5.39 MB	-rw-r--r--
studfee.sql	1.75 MB	-rw-r--r--
subject.sql	2.55 MB	-rw-r--r--
tdvs_abreq.sql	913 B	-rw-r--r--
tdvs_check.sql	913 B	-rw-r--r--
tdvs_control.sql	913 B	-rw-r--r--
tdvs_deggrp.sql	913 B	-rw-r--r--
tdvs_masboard.sql	913 B	-rw-r--r--
tdvs_mascomp.sql	913 B	-rw-r--r--
tdvs_masdev.sql	913 B	-rw-r--r--
tdvs_masmenu.sql	913 B	-rw-r--r--
tdvs_masqp.sql	913 B	-rw-r--r--
tdvs_masrev.sql	913 B	-rw-r--r--
tdvs_masteach.sql	913 B	-rw-r--r--
tdvs_qptempdetl.sql	913 B	-rw-r--r--
tdvs_qptemphead.sql	913 B	-rw-r--r--
tdvs_tabdetl.sql	913 B	-rw-r--r--
tdvs_tabhead.sql	913 B	-rw-r--r--
tdvs_tabpkt.sql	913 B	-rw-r--r--
tdvs_tabsum.sql	913 B	-rw-r--r--
tdvs_tabulate.sql	913 B	-rw-r--r--
tdvs_tabuser.sql	913 B	-rw-r--r--
tdvs_valcntr.sql	913 B	-rw-r--r--

Code Editor : room_allotment.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_mcu
-- ------------------------------------------------------
-- 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 `room_allotment`
--

DROP TABLE IF EXISTS `room_allotment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `room_allotment` (
  `internal_code` int(11) NOT NULL AUTO_INCREMENT,
  `FCOLLCODE` varchar(10) NOT NULL,
  `FQPCODE` varchar(10) NOT NULL,
  `FHALLNO` varchar(5) NOT NULL,
  `FCAPACITY` int(11) DEFAULT NULL,
  `FDOE` date DEFAULT NULL,
  `FSESSION` varchar(25) DEFAULT NULL,
  `FLOGNAME` varchar(25) DEFAULT NULL,
  `FLOGDATE` datetime DEFAULT NULL,
  `FCREATEDATE` datetime DEFAULT NULL,
  `FCREATEUSER` varchar(50) DEFAULT NULL,
  `FMODIFYDATE1` datetime DEFAULT NULL,
  `FMODIFYUSER1` varchar(50) DEFAULT NULL,
  `FMODIFYDATE2` datetime DEFAULT NULL,
  `FMODIFYUSER2` varchar(50) DEFAULT NULL,
  `FORDER` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`FCOLLCODE`,`FQPCODE`,`FHALLNO`),
  KEY `NewIndex1` (`FCOLLCODE`,`FQPCODE`),
  KEY `internal_code` (`internal_code`)
) ENGINE=InnoDB AUTO_INCREMENT=4206 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `room_allotment`
--

LOCK TABLES `room_allotment` WRITE;
/*!40000 ALTER TABLE `room_allotment` DISABLE KEYS */;
INSERT INTO `room_allotment` VALUES (4137,'8004','10329','001',1,'2024-03-12','10:00 AM - 01:00 PM','Admin','2024-03-12 15:10:01',NULL,NULL,NULL,NULL,NULL,NULL,'3'),(4114,'8004','10524','001',1,'2024-03-04','1:30 PM to 4:30 PM','Admin','2024-03-04 13:09:34',NULL,NULL,NULL,NULL,NULL,NULL,'3'),(4122,'8004','11101','001',1,'2024-03-06','10:00 AM - 01:00 PM','Admin','2024-03-06 08:58:11',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4109,'8004','11102','001',1,'2024-03-04','10:00 AM - 01:00 PM','Admin','2024-03-04 09:24:00',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4110,'8004','11113','001',1,'2024-03-04','10:00 AM - 01:00 PM','Admin','2024-03-04 09:24:00',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4132,'8004','11121','001',3,'2024-03-09','10:00 AM - 01:00 PM','Admin','2024-03-09 09:24:18',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4155,'8004','11122','001',1,'2024-03-22','10:00 AM - 01:00 PM','Admin','2024-03-21 15:03:13',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4165,'8004','11123','001',9,'2024-03-25','10:00 AM - 01:00 PM','Admin','2024-03-25 08:57:15',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4145,'8004','11133','001',3,'2024-03-15','10:00 AM - 01:00 PM','Admin','2024-03-14 17:03:53',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4129,'8004','11301','001',1,'2024-03-07','10:00 AM - 01:00 PM','Admin','2024-03-07 09:09:15',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4116,'8004','11302','001',2,'2024-03-05','10:00 AM - 01:00 PM','Admin','2024-03-05 09:36:24',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4117,'8004','11313','001',2,'2024-03-05','10:00 AM - 01:00 PM','Admin','2024-03-05 09:36:24',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4136,'8004','11321','001',2,'2024-03-12','10:00 AM - 01:00 PM','Admin','2024-03-12 15:10:01',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4171,'8004','11322','001',3,'2024-03-28','10:00 AM - 01:00 PM','Admin','2024-03-28 09:24:48',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(381,'8004','11323','009',36,'2022-04-01','10:00 AM - 01:00 PM','admin','2022-03-31 14:17:55',NULL,NULL,NULL,NULL,NULL,NULL,'11'),(382,'8004','11323','010',14,'2022-04-01','10:00 AM - 01:00 PM','admin','2022-03-31 14:17:55',NULL,NULL,NULL,NULL,NULL,NULL,'12'),(4167,'8004','11325','001',2,'2024-03-26','10:00 AM - 01:00 PM','Admin','2024-03-25 15:26:27',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(347,'8004','11326','015',3,'2022-03-30','10:00 AM - 01:00 PM','admin','2022-03-29 11:11:58',NULL,NULL,NULL,NULL,NULL,NULL,'21'),(210,'8004','11327','017',10,'2022-03-25','10:00 AM - 01:00 PM','admin','2022-03-24 11:09:12',NULL,NULL,NULL,NULL,NULL,NULL,'22'),(383,'8004','11328','010',9,'2022-04-01','10:00 AM - 01:00 PM','admin','2022-03-31 14:17:55',NULL,NULL,NULL,NULL,NULL,NULL,'13'),(4143,'8004','11333','001',2,'2024-03-14','10:00 AM - 01:00 PM','Admin','2024-03-13 16:38:01',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(290,'8004','11334','009',20,'2022-03-28','10:00 AM - 01:00 PM','admin','2022-03-28 10:44:59',NULL,NULL,NULL,NULL,NULL,NULL,'13'),(4135,'8004','11335','001',4,'2024-03-12','10:00 AM - 01:00 PM','Admin','2024-03-12 15:10:01',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4156,'8004','11521','001',2,'2024-03-22','1:30 PM to 4:30 PM','admin','2024-03-22 12:59:42',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4169,'8004','11522','001',1,'2024-03-27','1:30 PM to 4:30 PM','Admin','2024-03-26 16:16:41',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4113,'8004','11523','001',6,'2024-03-04','1:30 PM to 4:30 PM','Admin','2024-03-04 13:09:33',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4124,'8004','11524','001',2,'2024-03-06','1:30 PM to 4:30 PM','Admin','2024-03-06 12:06:33',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4179,'8004','11525','001',5,'2024-03-30','1:30 PM to 4:30 PM','Admin','2024-03-30 10:50:08',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4182,'8004','11526','001',6,'2024-04-04','1:30 PM to 4:30 PM','Admin','2024-04-04 12:36:37',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4148,'8004','11530','001',2,'2024-03-18','1:30 PM to 4:30 PM','Admin','2024-03-18 09:42:06',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4151,'8004','11535','001',1,'2024-03-20','1:30 PM to 4:30 PM','Admin','2024-03-19 15:44:40',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4157,'8004','11555','001',2,'2024-03-22','1:30 PM to 4:30 PM','admin','2024-03-22 12:59:42',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4134,'8004','11564','001',7,'2024-03-09','1:30 PM to 4:30 PM','Admin','2024-03-09 09:50:17',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4149,'8004','11565','001',2,'2024-03-18','1:30 PM to 4:30 PM','Admin','2024-03-18 09:42:06',NULL,NULL,NULL,NULL,NULL,NULL,'3'),(4147,'8004','11568','001',3,'2024-03-18','1:30 PM to 4:30 PM','Admin','2024-03-18 09:42:06',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4133,'8004','12121','001',3,'2024-03-09','10:00 AM - 01:00 PM','Admin','2024-03-09 09:24:18',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4154,'8004','12122','001',4,'2024-03-22','10:00 AM - 01:00 PM','Admin','2024-03-21 15:03:13',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4166,'8004','12123','001',4,'2024-03-25','10:00 AM - 01:00 PM','Admin','2024-03-25 08:57:15',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4131,'8004','12128','001',1,'2024-03-13','10:00 AM - 01:00 PM','Admin','2024-03-12 15:10:50',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4170,'8004','12322','001',7,'2024-03-28','10:00 AM - 01:00 PM','Admin','2024-03-28 09:24:48',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4185,'8004','12323','001',13,'2024-04-02','10:00 AM - 01:00 PM','Admin','2024-04-02 09:12:15',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4144,'8004','12326','001',1,'2024-03-14','10:00 AM - 01:00 PM','Admin','2024-03-13 16:38:02',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4146,'8004','12328','001',4,'2024-03-16','10:00 AM - 01:00 PM','Admin','2024-03-16 08:42:07',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4158,'8004','12521','001',2,'2024-03-22','1:30 PM to 4:30 PM','admin','2024-03-22 12:59:42',NULL,NULL,NULL,NULL,NULL,NULL,'3'),(4168,'8004','12522','001',5,'2024-03-27','1:30 PM to 4:30 PM','Admin','2024-03-26 16:16:40',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4112,'8004','12523','001',21,'2024-03-04','1:30 PM to 4:30 PM','Admin','2024-03-04 13:09:33',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4123,'8004','12524','001',22,'2024-03-06','1:30 PM to 4:30 PM','Admin','2024-03-06 12:06:32',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4178,'8004','12525','001',9,'2024-03-30','1:30 PM to 4:30 PM','Admin','2024-03-30 10:50:08',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4180,'8004','12526','001',19,'2024-04-01','1:30 PM to 4:30 PM','Admin','2024-04-01 13:49:19',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4125,'8004','12532','001',1,'2024-03-06','1:30 PM to 4:30 PM','Admin','2024-03-06 12:06:33',NULL,NULL,NULL,NULL,NULL,NULL,'3'),(4115,'8004','12533','001',1,'2024-03-04','1:30 PM to 4:30 PM','Admin','2024-03-04 13:09:34',NULL,NULL,NULL,NULL,NULL,NULL,'4'),(4152,'8004','12535','001',1,'2024-03-20','1:30 PM to 4:30 PM','Admin','2024-03-19 15:44:41',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4111,'8004','15102','001',1,'2024-03-04','10:00 AM - 01:00 PM','Admin','2024-03-04 09:24:00',NULL,NULL,NULL,NULL,NULL,NULL,'3'),(4130,'8004','15123','001',12,'2024-03-13','10:00 AM - 01:00 PM','Admin','2024-03-12 15:10:50',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4118,'8004','15313','001',1,'2024-03-05','10:00 AM - 01:00 PM','Admin','2024-03-05 09:36:24',NULL,NULL,NULL,NULL,NULL,NULL,'3'),(18,'8004','32305','014',3,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:04',NULL,NULL,NULL,NULL,NULL,NULL,'18'),(91,'8004','32305','015',7,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:04',NULL,NULL,NULL,NULL,NULL,NULL,'19'),(23,'8004','32307','015',2,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:05',NULL,NULL,NULL,NULL,NULL,NULL,'23'),(25,'8004','32310','015',1,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:05',NULL,NULL,NULL,NULL,NULL,NULL,'25'),(118,'8004','32524','017',11,'2022-03-22','10:00 AM - 01:00 PM','admin','2022-03-21 11:13:12',NULL,NULL,NULL,NULL,NULL,NULL,'21'),(140,'8004','33301','001',40,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 14:57:43',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(141,'8004','33301','002',40,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 14:57:44',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(142,'8004','33301','003',40,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 14:57:44',NULL,NULL,NULL,NULL,NULL,NULL,'3'),(143,'8004','33301','004',40,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 14:57:44',NULL,NULL,NULL,NULL,NULL,NULL,'4'),(144,'8004','33301','005',40,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 14:57:44',NULL,NULL,NULL,NULL,NULL,NULL,'5'),(145,'8004','33301','006',40,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 14:57:45',NULL,NULL,NULL,NULL,NULL,NULL,'6'),(146,'8004','33301','007',40,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 14:57:45',NULL,NULL,NULL,NULL,NULL,NULL,'7'),(147,'8004','33301','008',40,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 14:57:45',NULL,NULL,NULL,NULL,NULL,NULL,'8'),(148,'8004','33301','009',40,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 14:57:45',NULL,NULL,NULL,NULL,NULL,NULL,'9'),(149,'8004','33301','010',40,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 14:57:45',NULL,NULL,NULL,NULL,NULL,NULL,'10'),(150,'8004','33301','011',33,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 14:57:46',NULL,NULL,NULL,NULL,NULL,NULL,'11'),(15,'8004','33303','013',26,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:03',NULL,NULL,NULL,NULL,NULL,NULL,'15'),(16,'8004','33303','014',20,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:04',NULL,NULL,NULL,NULL,NULL,NULL,'16'),(1,'8004','33315','001',40,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:02',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(2,'8004','33315','002',40,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:02',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(3,'8004','33315','003',40,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:02',NULL,NULL,NULL,NULL,NULL,NULL,'3'),(4,'8004','33315','004',40,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:02',NULL,NULL,NULL,NULL,NULL,NULL,'4'),(5,'8004','33315','005',40,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:03',NULL,NULL,NULL,NULL,NULL,NULL,'5'),(6,'8004','33315','006',40,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:03',NULL,NULL,NULL,NULL,NULL,NULL,'6'),(7,'8004','33315','007',40,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:03',NULL,NULL,NULL,NULL,NULL,NULL,'7'),(8,'8004','33315','008',40,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:03',NULL,NULL,NULL,NULL,NULL,NULL,'8'),(9,'8004','33315','009',40,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:03',NULL,NULL,NULL,NULL,NULL,NULL,'9'),(10,'8004','33315','010',10,'2022-03-21','10:00 AM - 01:00 PM','admin','2022-03-21 08:38:03',NULL,NULL,NULL,NULL,NULL,NULL,'10'),(56,'8004','60671','018',13,'2022-03-21','10:00 AM - 01:00 PM','Admin','2022-03-19 11:41:22',NULL,NULL,NULL,NULL,NULL,NULL,'6'),(57,'8004','60671','019',7,'2022-03-21','10:00 AM - 01:00 PM','Admin','2022-03-19 11:41:22',NULL,NULL,NULL,NULL,NULL,NULL,'7'),(160,'8004','60672','003',9,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 15:04:41',NULL,NULL,NULL,NULL,NULL,NULL,'5'),(161,'8004','60672','004',12,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 15:04:41',NULL,NULL,NULL,NULL,NULL,NULL,'6'),(51,'8004','60821','016',40,'2022-03-21','10:00 AM - 01:00 PM','Admin','2022-03-19 11:41:22',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(52,'8004','60821','017',6,'2022-03-21','10:00 AM - 01:00 PM','Admin','2022-03-19 11:41:22',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(156,'8004','60822','001',40,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 15:04:41',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(157,'8004','60822','002',7,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 15:04:41',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(53,'8004','60831','017',31,'2022-03-21','10:00 AM - 01:00 PM','Admin','2022-03-19 11:41:22',NULL,NULL,NULL,NULL,NULL,NULL,'3'),(159,'8004','60832','003',31,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 15:04:41',NULL,NULL,NULL,NULL,NULL,NULL,'4'),(54,'8004','62121','017',3,'2022-03-21','10:00 AM - 01:00 PM','Admin','2022-03-19 11:41:22',NULL,NULL,NULL,NULL,NULL,NULL,'4'),(55,'8004','62121','018',27,'2022-03-21','10:00 AM - 01:00 PM','Admin','2022-03-19 11:41:22',NULL,NULL,NULL,NULL,NULL,NULL,'5'),(158,'8004','62122','002',33,'2022-03-23','10:00 AM - 01:00 PM','admin','2022-03-21 15:04:41',NULL,NULL,NULL,NULL,NULL,NULL,'3'),(4189,'8004','71312','001',3,'2024-05-13','10:00 AM - 01:00 PM','Admin','2024-05-13 09:32:47',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4187,'8004','71313','001',2,'2024-05-04','10:00 AM - 01:00 PM','Admin','2024-05-04 09:49:31',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4186,'8004','71331','001',1,'2024-05-02','10:00 AM - 01:00 PM','Admin','2024-05-02 09:46:36',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4190,'8004','71333','001',2,'2024-05-13','10:00 AM - 01:00 PM','Admin','2024-05-13 09:32:47',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4197,'8004','71334','001',1,'2024-05-15','10:00 AM - 01:00 PM','Admin','2024-05-15 09:38:11',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4204,'8004','71335','001',1,'2024-05-17','10:00 AM - 01:00 PM','Admin','2024-05-16 17:52:10',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4205,'8004','71336','001',1,'2024-05-20','10:00 AM - 01:00 PM','Admin','2024-05-20 09:29:01',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4188,'8004','73311','001',2,'2024-05-09','10:00 AM - 01:00 PM','Admin','2024-05-09 10:21:36',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4191,'8004','73312','001',1,'2024-05-14','10:00 AM - 01:00 PM','Admin','2024-05-14 13:12:58',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4198,'8004','73313','001',5,'2024-05-16','10:00 AM - 01:00 PM','Admin','2024-05-16 17:51:44',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4199,'8004','73333','001',1,'2024-05-16','10:00 AM - 01:00 PM','Admin','2024-05-16 17:51:44',NULL,NULL,NULL,NULL,NULL,NULL,'2'),(4192,'8004','73341','001',2,'2024-05-14','10:00 AM - 01:00 PM','Admin','2024-05-14 13:12:58',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4150,'8004','90012','001',1,'2024-03-20','10:00 AM - 01:00 PM','Admin','2024-03-19 15:41:43',NULL,NULL,NULL,NULL,NULL,NULL,'1'),(4153,'8004','90022','001',1,'2024-03-21','10:00 AM - 01:00 PM','Admin','2024-03-21 08:45:59',NULL,NULL,NULL,NULL,NULL,NULL,'1');
/*!40000 ALTER TABLE `room_allotment` 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-10-19 12:14:48

${this.title}

Code Editor : room_allotment.sql