-
Notifications
You must be signed in to change notification settings - Fork 0
/
Dump20220327.sql
57 lines (50 loc) · 12.4 KB
/
Dump20220327.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
-- MySQL dump 10.13 Distrib 8.0.25, for Linux (x86_64)
--
-- Host: 127.0.0.1 Database: db_gestion_empleados
-- ------------------------------------------------------
-- Server version 8.0.28-0ubuntu0.20.04.3
/*!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 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 */;
--
-- Table structure for table `empleados`
--
DROP TABLE IF EXISTS `empleados`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `empleados` (
`id` bigint NOT NULL AUTO_INCREMENT,
`apellido` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`fecha` date NOT NULL,
`nombre` varchar(255) DEFAULT NULL,
`salario` double NOT NULL,
`sexo` varchar(255) DEFAULT NULL,
`telefono` int NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `empleados`
--
LOCK TABLES `empleados` WRITE;
/*!40000 ALTER TABLE `empleados` DISABLE KEYS */;
INSERT INTO `empleados` VALUES (1,'Apellidos','[email protected]','2022-03-21','nombre',20000,'masculino',123456789),(3,'Jennings','[email protected]','2022-03-21','Leslie',50000,'femenino',415555145),(4,'Tseng','[email protected]','2022-03-21','Jerry',70000,'masculino',617555555),(9,'Bott','[email protected]','2022-03-21','Larry',854864,'masculino',652241555),(10,'Patterson','[email protected]','2022-03-21','Mary',23146,'femenino',142342555),(11,'Patterson','[email protected]','2022-03-21','Steve',644114,'masculino',650555680),(12,'King','[email protected]','2022-03-21','Tom',845500,'masculino',852225115),(13,'Gerard','[email protected]','2022-03-21','Martin',545541,'masculino',617765555),(14,'Fixter','[email protected]','2022-03-21','Andy',156454,'femenino',201615555),(15,'Vanauf','[email protected]','2022-03-21','George',654518,'masculino',508555255),(22,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(23,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(24,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(25,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(26,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(27,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(28,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(29,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(30,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(31,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(32,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(33,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(34,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(35,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(36,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(37,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(38,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(39,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(40,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(41,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(42,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(43,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(44,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(45,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(46,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(47,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(48,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(49,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(50,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(51,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(52,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(53,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(54,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(55,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(56,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(57,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(58,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(59,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(60,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(61,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(62,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(63,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(64,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(65,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(66,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(67,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(68,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(69,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(70,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(71,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(72,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(73,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(74,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(75,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(76,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(77,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(78,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(79,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(80,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(81,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(82,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(83,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(84,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(85,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(86,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(87,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(88,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(89,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(90,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(91,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(92,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(93,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(94,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(95,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(96,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(97,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(98,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(99,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(100,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(101,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(102,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(103,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(104,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(105,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(106,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(107,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(108,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(109,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(110,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(111,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(112,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(113,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(114,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(115,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(116,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(117,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365),(118,'Castillo','[email protected]','2022-03-21','Pamela',266543,'femenino',408555365);
/*!40000 ALTER TABLE `empleados` 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 2022-03-27 12:02:38