Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE IF NOT EXISTS `empresa2016` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci */;
- USE `empresa2016`;
- -- MySQL dump 10.13 Distrib 5.7.9, for Win64 (x86_64)
- --
- -- Host: localhost Database: empresa2016
- -- ------------------------------------------------------
- -- Server version 5.7.10-log
- /*!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 */;
- --
- -- Table structure for table `departamento`
- --
- DROP TABLE IF EXISTS `departamento`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `departamento` (
- `Ndep` int(11) NOT NULL,
- `Nombdep` varchar(20) NOT NULL,
- `Ciudad` varchar(20) DEFAULT NULL,
- `Jefe` int(11) DEFAULT NULL,
- `Presupuesto` decimal(10,2) DEFAULT '10000.00',
- PRIMARY KEY (`Ndep`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `departamento`
- --
- LOCK TABLES `departamento` WRITE;
- /*!40000 ALTER TABLE `departamento` DISABLE KEYS */;
- INSERT INTO `departamento` VALUES (10,'CONTABILIDAD ','MADRID ',7566,10000.00),(20,'INVESTIGACION ','BARCELONA ',7788,10000.00),(30,'VENTAS ','SEVILLA ',7499,21500.00),(40,'OPERACIONES ','HUELVA ',7782,10000.00),(50,'MARKETING ','MADRID ',7839,10000.00),(60,'PUBLICIDAD','SEVILLA',7698,10000.00);
- /*!40000 ALTER TABLE `departamento` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `empleado`
- --
- DROP TABLE IF EXISTS `empleado`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `empleado` (
- `Nemp` int(11) NOT NULL DEFAULT '0',
- `Nombre` varchar(20) NOT NULL,
- `Empleo` varchar(20) NOT NULL,
- `FechaIng` date DEFAULT NULL,
- `Supervs` int(11) DEFAULT NULL,
- `Salario` decimal(8,2) DEFAULT NULL,
- `Ndep` int(11) DEFAULT NULL,
- `Comision` decimal(8,2) DEFAULT NULL,
- `Email` varchar(60) DEFAULT NULL,
- PRIMARY KEY (`Nemp`),
- UNIQUE KEY `Nombre_UNIQUE` (`Nombre`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `empleado`
- --
- LOCK TABLES `empleado` WRITE;
- /*!40000 ALTER TABLE `empleado` DISABLE KEYS */;
- INSERT INTO `empleado` VALUES (7329,'JUAN ','OFICINISTA ','1995-12-17',7902,900.00,20,120.00,'juan7329@gmail.com'),(7499,'ANTONIO ','VENDEDOR ','2008-01-20',7698,1600.00,30,300.00,'antonio7499@hotmail.com'),(7521,'PEDRO ','VENDEDOR ','2004-01-22',7698,1250.00,30,500.00,'pedro7521@gamil.com'),(7566,'CARLOS ','GERENTE ','2002-04-23',7839,2975.00,20,NULL,'carlos7566@yahoo.es'),(7654,'JESUS ','VENDEDOR ','1995-09-28',7698,900.00,30,200.00,'jesus7654@gamil.com'),(7698,'MARCOS ','GERENTE ','2005-05-01',7839,2850.00,30,NULL,'marcos7698@hotmail.com'),(7782,'JORGE ','GERENTE ','2000-06-09',7839,2450.00,10,NULL,'jorge7782@hotmail.com'),(7788,'MANUEL ','ANALISTA ','1989-12-09',7566,3000.00,20,NULL,'manuel7788@yahoo.es'),(7839,'SIMEON ','PRESIDENTE ','1997-11-17',NULL,5000.00,10,NULL,'simeon7839@yahoo.es'),(7844,'LUIS ','VENDEDOR ','2002-09-07',7698,1500.00,30,0.00,'luis7844@hotmail.com'),(7876,'JOSE ','OFICINISTA ','1983-01-12',7566,1300.00,20,50.00,'jose7876@gmail.com'),(7900,'JAVIER ','OFICINISTA ','2003-12-03',7698,1300.00,30,NULL,'javier7900@gmail.com'),(7902,'SANTOS ','ANALISTA ','2002-12-03',7566,3000.00,20,NULL,'santos7902@gamil.com'),(7934,'TOMAS ','OFICINISTA ','2002-03-23',7782,900.00,10,NULL,'tomas7934@gamil.com');
- /*!40000 ALTER TABLE `empleado` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `proyectos`
- --
- DROP TABLE IF EXISTS `proyectos`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `proyectos` (
- `CodPro` char(5) COLLATE latin1_general_ci NOT NULL,
- `NomPro` varchar(50) COLLATE latin1_general_ci NOT NULL,
- `FechaIni` date DEFAULT NULL,
- `FechaFin` date DEFAULT NULL,
- PRIMARY KEY (`CodPro`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `proyectos`
- --
- LOCK TABLES `proyectos` WRITE;
- /*!40000 ALTER TABLE `proyectos` DISABLE KEYS */;
- /*!40000 ALTER TABLE `proyectos` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `trabaja`
- --
- DROP TABLE IF EXISTS `trabaja`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `trabaja` (
- `CodPro` char(5) COLLATE latin1_general_ci NOT NULL,
- `CodEmp` int(11) NOT NULL,
- `NumHoras` int(11) DEFAULT NULL,
- PRIMARY KEY (`CodPro`,`CodEmp`),
- KEY `CodEmp` (`CodEmp`),
- CONSTRAINT `trabaja_ibfk_1` FOREIGN KEY (`CodPro`) REFERENCES `proyectos` (`CodPro`),
- CONSTRAINT `trabaja_ibfk_2` FOREIGN KEY (`CodEmp`) REFERENCES `empleado` (`Nemp`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `trabaja`
- --
- LOCK TABLES `trabaja` WRITE;
- /*!40000 ALTER TABLE `trabaja` DISABLE KEYS */;
- /*!40000 ALTER TABLE `trabaja` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `trabaja2`
- --
- DROP TABLE IF EXISTS `trabaja2`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `trabaja2` (
- `CodPro` char(5) COLLATE latin1_general_ci NOT NULL,
- `CodEmp` int(11) NOT NULL,
- `NumHoras` int(11) DEFAULT NULL,
- PRIMARY KEY (`CodPro`,`CodEmp`),
- KEY `CodEmp` (`CodEmp`),
- CONSTRAINT `trabaja2_ibfk_1` FOREIGN KEY (`CodPro`) REFERENCES `proyectos` (`CodPro`),
- CONSTRAINT `trabaja2_ibfk_2` FOREIGN KEY (`CodEmp`) REFERENCES `empleado` (`Nemp`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `trabaja2`
- --
- LOCK TABLES `trabaja2` WRITE;
- /*!40000 ALTER TABLE `trabaja2` DISABLE KEYS */;
- /*!40000 ALTER TABLE `trabaja2` 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 2017-01-16 23:52:31
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement