text: -- MariaDB dump 10.17  Distrib 10.5.3-MariaDB, for Win64 (AMD64)
  --
  -- Host: localhost    Database: clientes
  -- ------------------------------------------------------
  -- Server version	10.4.11-MariaDB
  
  /*!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 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 `empleados`
  --
  
  DROP TABLE IF EXISTS `empleados`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `empleados` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nombre` varchar(50) NOT NULL,
    `apellidos` varchar(100) NOT NULL,
    `fecha_nacimiento` date NOT NULL,
    `direccion` varchar(150) NOT NULL,
    `correo_electronico` varchar(30) NOT NULL,
    `telefono_movil` bigint(12) NOT NULL,
    `id_empresa` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `empleados_un` (`id`,`telefono_movil`,`id_empresa`),
    KEY `fk_empresas` (`id_empresa`),
    CONSTRAINT `fk_empresas` FOREIGN KEY (`id_empresa`) REFERENCES `empresas` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='Tabla de empleados.';
  /*!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,'Joaquín','Costa','1956-03-25','Calle Almería 2 -23','jc@mail.com',34669669669,1),(2,'Ramiro','Maeztu','1984-12-06','Calle Córdoba 78 -1','rm@mail.com',34612612612,2),(3,'Martínez','Izquierdo','1969-07-08','Calle Madrid 22 - 11','mi@mail.com',34666555444,3),(4,'Donoso','Cortés','1977-09-22','Calle Barcelona 89 - 2','dc@mail.com',34696696696,4);
  /*!40000 ALTER TABLE `empleados` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `empresas`
  --
  
  DROP TABLE IF EXISTS `empresas`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `empresas` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nombre` varchar(50) NOT NULL,
    `cif` varchar(9) NOT NULL,
    `web` varchar(100) NOT NULL,
    `numero_empleados` int(6) NOT NULL,
    `id_sector` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `empresas_un` (`id`,`cif`,`id_sector`,`nombre`),
    KEY `fk_sectores` (`id_sector`),
    CONSTRAINT `fk_sectores` FOREIGN KEY (`id_sector`) REFERENCES `sectores` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='Tabla de empresas.';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `empresas`
  --
  
  LOCK TABLES `empresas` WRITE;
  /*!40000 ALTER TABLE `empresas` DISABLE KEYS */;
  INSERT INTO `empresas` VALUES (1,'BMW Ibérica S.A.','A28713642','https://www.bmw.es/',200,3),(2,'Nestlé España S.A.','A08005449','https://empresa.nestle.es/',3711,2),(3,'Cepsa Química S.A.','A81861122','https://www.cepsa.com/',432,2),(4,'Abe Agropecuaria S.L.','B45257375','https://www.abe.com/',145,1);
  /*!40000 ALTER TABLE `empresas` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `sectores`
  --
  
  DROP TABLE IF EXISTS `sectores`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `sectores` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nombre` varchar(50) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `sectores_un` (`id`,`nombre`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='Tabla de sectores.';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `sectores`
  --
  
  LOCK TABLES `sectores` WRITE;
  /*!40000 ALTER TABLE `sectores` DISABLE KEYS */;
  INSERT INTO `sectores` VALUES (1,'Primario'),(2,'Secundario'),(3,'Servicios');
  /*!40000 ALTER TABLE `sectores` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Dumping routines for database 'clientes_'
  --
  /*!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-06-19 12:57:11
  