Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
absent.sql	4.51 KB	-rw-r--r--
admfeestr.sql	30.11 KB	-rw-r--r--
ansstud.sql	2.98 KB	-rw-r--r--
appcanddet.sql	795.37 KB	-rw-r--r--
appcandsum.sql	528.11 KB	-rw-r--r--
appstudfee.sql	359.43 KB	-rw-r--r--
canddet.sql	1.36 MB	-rw-r--r--
candsum.sql	538.59 KB	-rw-r--r--
colldeg.sql	19.62 KB	-rw-r--r--
colldesp.sql	2.62 KB	-rw-r--r--
college.sql	8.26 KB	-rw-r--r--
collexam.sql	30.15 KB	-rw-r--r--
collia.sql	34.55 KB	-rw-r--r--
dcstud.sql	3.77 KB	-rw-r--r--
dctran.sql	3.93 KB	-rw-r--r--
degcntr.sql	2.31 KB	-rw-r--r--
degree.sql	39.33 KB	-rw-r--r--
exam_app_2024-04-29-04-43-57.z...	12.11 KB	-rw-r--r--
exam_app_marks_results_exam_pr...	494.94 KB	-rw-r--r--
exam_app_marks_results_exam_pr...	422.87 KB	-rw-r--r--
exam_app_marks_results_exam_pr...	661.03 KB	-rw-r--r--
exam_app_marks_results_exam_pr...	837.99 KB	-rw-r--r--
exam_app_marks_results_exam_pr...	663.05 KB	-rw-r--r--
exam_app_marks_results_exam_pr...	706.66 KB	-rw-r--r--
exam_app_marks_results_exam_pr...	757.34 KB	-rw-r--r--
exam_app_marks_results_exam_pr...	939.7 KB	-rw-r--r--
exam_app_marks_results_exam_pr...	940.12 KB	-rw-r--r--
marks.sql	1.74 MB	-rw-r--r--
marks_pr.sql	126.95 KB	-rw-r--r--
masroom.sql	7.34 KB	-rw-r--r--
practical_entry_freeze.sql	6.9 KB	-rw-r--r--
res_fee.sql	375.06 KB	-rw-r--r--
res_stud.sql	794.21 KB	-rw-r--r--
res_studsum.sql	91.02 KB	-rw-r--r--
resmarks.sql	3.13 MB	-rw-r--r--
resmarksdet.sql	2.89 MB	-rw-r--r--
room_allotment.sql	54.08 KB	-rw-r--r--
servdetl.sql	2.2 KB	-rw-r--r--
servfee.sql	2.18 KB	-rw-r--r--
servfeestr.sql	2.21 KB	-rw-r--r--
servproc.sql	2.14 KB	-rw-r--r--
servtran.sql	3.96 KB	-rw-r--r--
servtype.sql	2.21 KB	-rw-r--r--
student.sql	1.53 MB	-rw-r--r--
studfee.sql	354.77 KB	-rw-r--r--
subject.sql	455.69 KB	-rw-r--r--
tdvs_abreq.sql	915 B	-rw-r--r--
tdvs_check.sql	915 B	-rw-r--r--
tdvs_control.sql	915 B	-rw-r--r--
tdvs_deggrp.sql	2.36 KB	-rw-r--r--
tdvs_masboard.sql	915 B	-rw-r--r--
tdvs_mascomp.sql	915 B	-rw-r--r--
tdvs_masdev.sql	915 B	-rw-r--r--
tdvs_masmenu.sql	2.39 KB	-rw-r--r--
tdvs_masqp.sql	915 B	-rw-r--r--
tdvs_masrev.sql	2.41 KB	-rw-r--r--
tdvs_masteach.sql	915 B	-rw-r--r--
tdvs_qptempdetl.sql	2.4 KB	-rw-r--r--
tdvs_qptemphead.sql	3.79 KB	-rw-r--r--
tdvs_tabdetl.sql	3.01 KB	-rw-r--r--
tdvs_tabhead.sql	3.06 KB	-rw-r--r--
tdvs_tabpkt.sql	915 B	-rw-r--r--
tdvs_tabsum.sql	2.71 KB	-rw-r--r--
tdvs_tabulate.sql	915 B	-rw-r--r--
tdvs_tabuser.sql	2.71 KB	-rw-r--r--
tdvs_valcntr.sql	915 B	-rw-r--r--

Code Editor : tdvs_qptemphead.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_sjbit
-- ------------------------------------------------------
-- 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 `tdvs_qptemphead`
--

DROP TABLE IF EXISTS `tdvs_qptemphead`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tdvs_qptemphead` (
  `ftempcode` varchar(10) NOT NULL DEFAULT '',
  `ftempname` varchar(100) DEFAULT NULL,
  `ftempdesc` varchar(500) DEFAULT NULL,
  `fpartcode` varchar(10) NOT NULL DEFAULT '',
  `fpartdesc` varchar(100) DEFAULT NULL,
  `fmaxqn` int(20) DEFAULT NULL,
  `fmandqn` int(20) DEFAULT NULL,
  `fmaxmarks` decimal(5,0) DEFAULT NULL,
  `fqpcodes` varchar(100) DEFAULT NULL,
  `ftempmax` decimal(5,0) DEFAULT NULL,
  PRIMARY KEY (`ftempcode`,`fpartcode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tdvs_qptemphead`
--

LOCK TABLES `tdvs_qptemphead` WRITE;
/*!40000 ALTER TABLE `tdvs_qptemphead` DISABLE KEYS */;
INSERT INTO `tdvs_qptemphead` VALUES ('Temp01','MBA','Temp01','P01','P01',2,1,20,'1*2',NULL),('Temp01','MBA','Temp01','P02','P02',2,1,20,'3*4',NULL),('Temp01','MBA','Temp01','P03','P03',1,1,10,'5',NULL),('Temp02','Temp02','Temp02','P01','P01',2,1,25,'1*2',NULL),('Temp02','Temp02','Temp02','P02','P02',2,1,25,'3*4',NULL),('Temp03','Temp03','Temp03','P01','P01',6,6,50,'1*2*3*4*5*6',NULL),('Temp04','Temp04','Temp04','P01','Procedure',1,1,10,'1',NULL),('Temp04','Temp04','Temp04','P02','Cond/Exec',1,1,25,'2',NULL),('Temp04','Temp04','Temp04','P03','Analysis',1,1,10,'3',NULL),('Temp04','Temp04','Temp04','P04','Viva',1,1,5,'4',NULL),('Temp05','Temp05','Temp05','P01','Cond/Exec',1,1,10,'1',NULL),('Temp05','Temp05','Temp05','P02','Analysis',1,1,10,'2',NULL),('Temp05','Temp05','Temp05','P03','Report',1,1,20,'3',NULL),('Temp05','Temp05','Temp05','P05','Viva',1,1,10,'4',NULL),('Temp06','Temp06','Temp06','P01','P01',2,2,70,'1*2',NULL),('Temp06','Temp06','Temp06','P02','P02',3,1,30,'3*4*5',NULL),('Temp07','Temp07','Temp07','P01','Assig_Pres',6,6,25,'1*2*3*4*5*6',25),('Temp08','Temp08','Temp08','P01','Under/Writ',1,1,15,'1',50),('Temp08','Temp08','Temp08','P02','Cond',1,1,15,'2',50),('Temp08','Temp08','Temp08','P03','Results',1,1,10,'3',50),('Temp08','Temp08','Temp08','P04','Viva',1,1,10,'4',50),('Temp09','Temp09','Temp09','P01','P01',1,1,25,'1*2*3*4*5*6',25),('Temp10','Temp10','Temp10','P01','P01',1,1,25,'1',25);
/*!40000 ALTER TABLE `tdvs_qptemphead` 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-04 10:46:01

${this.title}

Code Editor : tdvs_qptemphead.sql