Skip to content

Instantly share code, notes, and snippets.

@upperwal

upperwal/dump.sql

Last active November 3, 2020 06:05
Show Gist options
  • Save upperwal/d2db62086f312e3b3ea92c8b38a02d3a to your computer and use it in GitHub Desktop.
Save upperwal/d2db62086f312e3b3ea92c8b38a02d3a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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','shreya@gmail.com','F','1992-12-21','city apartment sec 10 dwarka','chemistry'),(11,'Abhay dixit','9728235656','abhay23@gmail.com','M','1992-08-23','mahavir enclave,new delhi','physics'),(12,'Tishika sachdeva','9011238273','tisha@gmail.com','F','1991-02-22','hehe apartment new delhi','economics'),(13,'Sonal rawat','9987356482','chatterbox@gmail.com','F','1993-06-17','Skyfall apartment,sec 10 dwarka','psychology'),(14,'Vatsal srivastva','7866524357','vats1@gmail.com','M','1991-09-11','IDK apartment,sec 10 dwarka','maths'),(15,'Shambhawi singh','7832925624','spv1@gmail.com','F','1994-09-12','shambhu place,sector 10 dwarka','physics'),(16,'Shagnik biswas','9122354762','shaggy@gmail.com','M','1990-06-11','homeless apartment,sector 16 dwarka','CS lab assistant'),(17,'Pooja jha','9766523452','pjha@gmail.com','F','1994-08-21','mahavir enclave part1,new delhi','history'),(18,'Ayush kumar','9800987656','ayushk@gmail.com','M','1989-02-12','janakpuri,new delhi','lab assistant'),(19,'Shashank sharma','7622345678','shashank@gmail.com','M','1991-11-29','palam,new delhi','physical edu'),(20,'Jyoti yadav','9876543210','jyoti@yahoo.com','F','1991-10-05','JS colony dwarka','sst'),(21,'Kashish khadria','9322454678','kashish@gmail.com','F','1988-02-20','B232,najafgarh','english'),(22,'Anuj gaur','9987654321','anuj111@yahoo.com','M','1988-01-24','JM apartment dwarka sec22','hindi'),(23,'Tanya mehrolia','9099876543','tanya000@gmail.com','F','1992-10-08','mohan garden,A34 delhi','biology'),(24,'suvangi roy','9987654321','suvi@gmail.com','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','shreya@gmail.com','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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment