· 7 years ago · Feb 22, 2019, 06:16 PM
1CREATE DATABASE IF NOT EXISTS `empresa2016` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci */;
2USE `empresa2016`;
3-- MySQL dump 10.13 Distrib 5.7.9, for Win64 (x86_64)
4--
5-- Host: localhost Database: empresa2016
6-- ------------------------------------------------------
7-- Server version 5.7.10-log
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `departamento`
22--
23
24DROP TABLE IF EXISTS `departamento`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `departamento` (
28 `Ndep` int(11) NOT NULL,
29 `Nombdep` varchar(20) NOT NULL,
30 `Ciudad` varchar(20) DEFAULT NULL,
31 `Jefe` int(11) DEFAULT NULL,
32 `Presupuesto` decimal(10,2) DEFAULT '10000.00',
33 PRIMARY KEY (`Ndep`)
34) ENGINE=MyISAM DEFAULT CHARSET=utf8;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `departamento`
39--
40
41LOCK TABLES `departamento` WRITE;
42/*!40000 ALTER TABLE `departamento` DISABLE KEYS */;
43INSERT 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);
44/*!40000 ALTER TABLE `departamento` ENABLE KEYS */;
45UNLOCK TABLES;
46
47--
48-- Table structure for table `empleado`
49--
50
51DROP TABLE IF EXISTS `empleado`;
52/*!40101 SET @saved_cs_client = @@character_set_client */;
53/*!40101 SET character_set_client = utf8 */;
54CREATE TABLE `empleado` (
55 `Nemp` int(11) NOT NULL DEFAULT '0',
56 `Nombre` varchar(20) NOT NULL,
57 `Empleo` varchar(20) NOT NULL,
58 `FechaIng` date DEFAULT NULL,
59 `Supervs` int(11) DEFAULT NULL,
60 `Salario` decimal(8,2) DEFAULT NULL,
61 `Ndep` int(11) DEFAULT NULL,
62 `Comision` decimal(8,2) DEFAULT NULL,
63 `Email` varchar(60) DEFAULT NULL,
64 PRIMARY KEY (`Nemp`),
65 UNIQUE KEY `Nombre_UNIQUE` (`Nombre`)
66) ENGINE=InnoDB DEFAULT CHARSET=utf8;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `empleado`
71--
72
73LOCK TABLES `empleado` WRITE;
74/*!40000 ALTER TABLE `empleado` DISABLE KEYS */;
75INSERT 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');
76/*!40000 ALTER TABLE `empleado` ENABLE KEYS */;
77UNLOCK TABLES;
78
79--
80-- Table structure for table `proyectos`
81--
82
83DROP TABLE IF EXISTS `proyectos`;
84/*!40101 SET @saved_cs_client = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `proyectos` (
87 `CodPro` char(5) COLLATE latin1_general_ci NOT NULL,
88 `NomPro` varchar(50) COLLATE latin1_general_ci NOT NULL,
89 `FechaIni` date DEFAULT NULL,
90 `FechaFin` date DEFAULT NULL,
91 PRIMARY KEY (`CodPro`)
92) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
93/*!40101 SET character_set_client = @saved_cs_client */;
94
95--
96-- Dumping data for table `proyectos`
97--
98
99LOCK TABLES `proyectos` WRITE;
100/*!40000 ALTER TABLE `proyectos` DISABLE KEYS */;
101/*!40000 ALTER TABLE `proyectos` ENABLE KEYS */;
102UNLOCK TABLES;
103
104--
105-- Table structure for table `trabaja`
106--
107
108DROP TABLE IF EXISTS `trabaja`;
109/*!40101 SET @saved_cs_client = @@character_set_client */;
110/*!40101 SET character_set_client = utf8 */;
111CREATE TABLE `trabaja` (
112 `CodPro` char(5) COLLATE latin1_general_ci NOT NULL,
113 `CodEmp` int(11) NOT NULL,
114 `NumHoras` int(11) DEFAULT NULL,
115 PRIMARY KEY (`CodPro`,`CodEmp`),
116 KEY `CodEmp` (`CodEmp`),
117 CONSTRAINT `trabaja_ibfk_1` FOREIGN KEY (`CodPro`) REFERENCES `proyectos` (`CodPro`),
118 CONSTRAINT `trabaja_ibfk_2` FOREIGN KEY (`CodEmp`) REFERENCES `empleado` (`Nemp`)
119) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
120/*!40101 SET character_set_client = @saved_cs_client */;
121
122--
123-- Dumping data for table `trabaja`
124--
125
126LOCK TABLES `trabaja` WRITE;
127/*!40000 ALTER TABLE `trabaja` DISABLE KEYS */;
128/*!40000 ALTER TABLE `trabaja` ENABLE KEYS */;
129UNLOCK TABLES;
130
131--
132-- Table structure for table `trabaja2`
133--
134
135DROP TABLE IF EXISTS `trabaja2`;
136/*!40101 SET @saved_cs_client = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `trabaja2` (
139 `CodPro` char(5) COLLATE latin1_general_ci NOT NULL,
140 `CodEmp` int(11) NOT NULL,
141 `NumHoras` int(11) DEFAULT NULL,
142 PRIMARY KEY (`CodPro`,`CodEmp`),
143 KEY `CodEmp` (`CodEmp`),
144 CONSTRAINT `trabaja2_ibfk_1` FOREIGN KEY (`CodPro`) REFERENCES `proyectos` (`CodPro`),
145 CONSTRAINT `trabaja2_ibfk_2` FOREIGN KEY (`CodEmp`) REFERENCES `empleado` (`Nemp`)
146) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
147/*!40101 SET character_set_client = @saved_cs_client */;
148
149--
150-- Dumping data for table `trabaja2`
151--
152
153LOCK TABLES `trabaja2` WRITE;
154/*!40000 ALTER TABLE `trabaja2` DISABLE KEYS */;
155/*!40000 ALTER TABLE `trabaja2` ENABLE KEYS */;
156UNLOCK TABLES;
157/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
158
159/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
160/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
161/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
162/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
163/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
164/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
165/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
166
167-- Dump completed on 2017-01-16 23:52:31