dump.sql

-- MySQL dump 10.13  Distrib 8.0.18, for Win64 (x86_64)
--
-- Host: localhost    Database: shreya123
-- ------------------------------------------------------
-- Server version	8.0.18

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

DROP TABLE IF EXISTS `all_records`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `all_records` (
  `Teacher_id` int(11) NOT NULL,
  `full_name` varchar(20) DEFAULT NULL,
  `phone_no` varchar(10) DEFAULT NULL,
  `email_id` varchar(30) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `DOB` date DEFAULT NULL,
  `address` varchar(35) DEFAULT NULL,
  `subject` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`Teacher_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `all_records`
--

LOCK TABLES `all_records` WRITE;
/*!40000 ALTER TABLE `all_records` DISABLE KEYS */;
INSERT INTO `all_records` VALUES (10,'shreya panwar','9599207989','[email protected]','F','1992-12-21','city apartment sec 10 dwarka','chemistry'),(11,'Abhay dixit','9728235656','[email protected]','M','1992-08-23','mahavir enclave,new delhi','physics'),(12,'Tishika sachdeva','9011238273','[email protected]','F','1991-02-22','hehe apartment new delhi','economics'),(13,'Sonal rawat','9987356482','[email protected]','F','1993-06-17','Skyfall apartment,sec 10 dwarka','psychology'),(14,'Vatsal srivastva','7866524357','[email protected]','M','1991-09-11','IDK apartment,sec 10 dwarka','maths'),(15,'Shambhawi singh','7832925624','[email protected]','F','1994-09-12','shambhu place,sector 10 dwarka','physics'),(16,'Shagnik biswas','9122354762','[email protected]','M','1990-06-11','homeless apartment,sector 16 dwarka','CS lab assistant'),(17,'Pooja jha','9766523452','[email protected]','F','1994-08-21','mahavir enclave part1,new delhi','history'),(18,'Ayush kumar','9800987656','[email protected]','M','1989-02-12','janakpuri,new delhi','lab assistant'),(19,'Shashank sharma','7622345678','[email protected]','M','1991-11-29','palam,new delhi','physical edu'),(20,'Jyoti yadav','9876543210','[email protected]','F','1991-10-05','JS colony dwarka','sst'),(21,'Kashish khadria','9322454678','[email protected]','F','1988-02-20','B232,najafgarh','english'),(22,'Anuj gaur','9987654321','[email protected]','M','1988-01-24','JM apartment dwarka sec22','hindi'),(23,'Tanya mehrolia','9099876543','[email protected]','F','1992-10-08','mohan garden,A34 delhi','biology'),(24,'suvangi roy','9987654321','[email protected]','F','1990-08-20','sec11 timefall apartment','biology');
/*!40000 ALTER TABLE `all_records` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `experience`
--

DROP TABLE IF EXISTS `experience`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `experience` (
  `Teacher_id` int(11) NOT NULL,
  `name` varchar(25) DEFAULT NULL,
  `Qualification` varchar(30) DEFAULT NULL,
  `experience` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`Teacher_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `experience`
--

LOCK TABLES `experience` WRITE;
/*!40000 ALTER TABLE `experience` DISABLE KEYS */;
INSERT INTO `experience` VALUES (10,'shreya panwar','B-ed and PGT chemistry','3 years'),(11,'Abhay dixit','Masters in physics,B-ed','3 years'),(12,'Tishika sachdeva','M-P-ED for economics PGT','4 years'),(13,'Sonal rawat','BA,MA and phD in psychology','2 years'),(14,'Vatsal srivastava','M-Ed maths','4 years'),(15,'Shambhawi singh','phD physics,M-Ed','3 years'),(16,'Shagnik biswas','BCA,MCA','4 years'),(17,'Pooja jha','B-Ed,M-Ed history','5 years'),(18,'Ayush kumar','BSc physics and chemistry','2 years'),(19,'Shashank sharma','B-P-Ed','5 years'),(20,'Jyoti yadav','TGT Social studies','4 years'),(21,'Kashish khadria',' English Hons,MA and B-Ed','6 years'),(22,'Anuj gaur','MA,B-Ed and hindi hons','4 years'),(23,'Tanya mehrolia','phD,B-Ed biology','3 years'),(24,'suvangi roy','PGT and TGT biology','2 years');
/*!40000 ALTER TABLE `experience` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leaves`
--

DROP TABLE IF EXISTS `leaves`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `leaves` (
  `Teacher_id` int(11) NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  `jan` int(11) DEFAULT NULL,
  `feb` int(11) DEFAULT NULL,
  `march` int(11) DEFAULT NULL,
  `april` int(11) DEFAULT NULL,
  `may` int(11) DEFAULT NULL,
  `june` int(11) DEFAULT NULL,
  `july` int(11) DEFAULT NULL,
  `august` int(11) DEFAULT NULL,
  `sept` int(11) DEFAULT NULL,
  `oct` int(11) DEFAULT NULL,
  `nov` int(11) DEFAULT NULL,
  PRIMARY KEY (`Teacher_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leaves`
--

LOCK TABLES `leaves` WRITE;
/*!40000 ALTER TABLE `leaves` DISABLE KEYS */;
/*!40000 ALTER TABLE `leaves` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leaves_ofstaff`
--

DROP TABLE IF EXISTS `leaves_ofstaff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `leaves_ofstaff` (
  `Teacher_id` int(11) NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  `monthly_average_leave` int(11) DEFAULT NULL,
  `yearly_total` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Teacher_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leaves_ofstaff`
--

LOCK TABLES `leaves_ofstaff` WRITE;
/*!40000 ALTER TABLE `leaves_ofstaff` DISABLE KEYS */;
INSERT INTO `leaves_ofstaff` VALUES (10,'Shreya panwar',3,26),(11,'Abhay dixit',2,24),(12,'Tishika sachdeva',4,28),(13,'Sonal rawat',3,26),(14,'Vatsal srivastva',2,24),(15,'Shambhawi singh',2,22),(16,'Shagnik biswas',4,28),(17,'pooja jha',2,24),(18,'Ayush kumar',3,26),(19,'Shashank sharma',3,26),(20,'Jyoti yadav',2,24),(21,'Kashish khadria',3,26),(22,'Anuj gaur',2,25),(23,'Tanya mehrolia',3,29),(24,'suvangi roy',2,24);
/*!40000 ALTER TABLE `leaves_ofstaff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `myaccount`
--

DROP TABLE IF EXISTS `myaccount`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `myaccount` (
  `Teacher_id` int(11) NOT NULL,
  `full_name` varchar(20) DEFAULT NULL,
  `phone_no` varchar(10) DEFAULT NULL,
  `email_id` varchar(30) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `DOB` date DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  `subject` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`Teacher_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `myaccount`
--

LOCK TABLES `myaccount` WRITE;
/*!40000 ALTER TABLE `myaccount` DISABLE KEYS */;
INSERT INTO `myaccount` VALUES (10,'Shreya panwar','9920374857','[email protected]','F','1992-12-21','city apartment sec 10 dwarka','chemistry');
/*!40000 ALTER TABLE `myaccount` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salary`
--

DROP TABLE IF EXISTS `salary`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `salary` (
  `name` varchar(30) DEFAULT NULL,
  `monthly_salary` bigint(20) DEFAULT NULL,
  `yearly_salary` bigint(20) DEFAULT NULL,
  `Teacher_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salary`
--

LOCK TABLES `salary` WRITE;
/*!40000 ALTER TABLE `salary` DISABLE KEYS */;
INSERT INTO `salary` VALUES ('Shreya panwar',50000,600000,10),('Abhay dixit',60000,720000,11),('Tishika sachdeva',55000,660000,12),('Sonal rawat',65000,780000,13),('Vatsal srivastva',50000,600000,14),('Shambhawi singh',65000,780000,15),('Shagnik biswas',40000,480000,16),('Pooja jha',60000,720000,17),('Ayush kumar',45000,540000,18),('Shashank sharma',50000,600000,19),('Jyoti yadav',45000,540000,20),('Kashish khadria',55000,660000,21),('Anuj gaur',55000,660000,22),('Tanya mehrolia',60000,720000,23),('suvangi roy',60000,720000,24);
/*!40000 ALTER TABLE `salary` 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 2020-11-02 23:59:53