· 5 years ago · Mar 06, 2020, 05:08 PM
1-- MySQL dump 10.13 Distrib 5.7.29, for Linux (x86_64)
2--
3-- Host: localhost Database: empresa
4-- ------------------------------------------------------
5-- Server version 5.7.29-0ubuntu0.18.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `CLIENTE`
20--
21
22DROP TABLE IF EXISTS `CLIENTE`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `CLIENTE` (
26 `CLIENTE_COD` int(6) unsigned NOT NULL,
27 `NOMBRE` varchar(45) NOT NULL,
28 `DIRECCIÓN` varchar(40) NOT NULL,
29 `CIUDAD` varchar(30) NOT NULL,
30 `ESTADO` varchar(2) DEFAULT NULL,
31 `CODI_POSTAL` varchar(9) NOT NULL,
32 `AREA` smallint(3) DEFAULT NULL,
33 `TELEFONO` varchar(9) DEFAULT NULL,
34 `REPR_COD` smallint(4) unsigned DEFAULT NULL,
35 `LIMIT_CREDITO` decimal(9,2) unsigned DEFAULT NULL,
36 `OBSERVACIONES` text,
37 PRIMARY KEY (`CLIENTE_COD`),
38 KEY `IDX_CLIENT_REPR_COD` (`REPR_COD`),
39 KEY `CLIENTE_NOM` (`NOMBRE`),
40 KEY `CLIENTE_REPR_CLI` (`REPR_COD`,`CLIENTE_COD`),
41 CONSTRAINT `CLIENTE_ibfk_1` FOREIGN KEY (`REPR_COD`) REFERENCES `EMP` (`EMP_NO`)
42) ENGINE=InnoDB DEFAULT CHARSET=utf8;
43/*!40101 SET character_set_client = @saved_cs_client */;
44
45--
46-- Dumping data for table `CLIENTE`
47--
48
49LOCK TABLES `CLIENTE` WRITE;
50/*!40000 ALTER TABLE `CLIENTE` DISABLE KEYS */;
51INSERT INTO `CLIENTE` VALUES (100,'JOCKSPORTS','345 VIEWRIDGE','BELMONT','CA','96711',415,'598-6609',7844,5000.00,'Very friendly people to work with -- sales rep likes to be called Mike.'),(101,'TKB SPORT SHOP','490 BOLI RD.','REDWOOD CIUTAT','CA','94061',415,'368-1223',7521,10000.00,'Rep called 5/8 about change in order - contact shipping.'),(102,'VOLLYRITE','9722 HAMILTON','BURLINGAME','CA','95133',415,'644-3341',7654,7000.00,'Company doing heavy promotion beginning 10/89. Prepare for large orders during winter.'),(103,'JUST TENNIS','HILLVIEW MALL','BURLINGAME','CA','97544',415,'677-9312',7521,3000.00,'Contact rep about new line of tennis rackets.'),(104,'EVERY MOUNTAIN','574 SURRY RD.','CUPERTINO','CA','93301',408,'996-2323',7499,10000.00,'CLIENT with high market share (23%) due to aggressive advertising.'),(105,'K + T SPORTS','3476 EL PASEO','SANTA CLARA','CA','91003',408,'376-9966',7844,5000.00,'Tends to order large amounts of merchandise at once. Accounting is considering raising their credit limit. Usually pays on time.'),(106,'SHAPE UP','908 SEQUOIA','PALO ALTO','CA','94301',415,'364-9777',7521,6000.00,'Support intensive. Orders small amounts (< 800) of merchandise at a time.'),(107,'WOMEN SPORTS','VALCO VILLAGE','SUNNYVALE','CA','93301',408,'967-4398',7499,10000.00,'First sporting goods store geared exclusively towards women. Unusual promotion al style and very willing to take chances towards new PRODUCTEs!'),(108,'NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER','98 LONE PINE WAY','HIBBING','MN','55649',612,'566-9123',7844,8000.00,''),(109,'SPRINGFIELD NUCLEAR POWER PLANT','13 PERCEBE STR.','SPRINGFIELD','NT','0000',636,'999-6666',NULL,10000.00,'');
52/*!40000 ALTER TABLE `CLIENTE` ENABLE KEYS */;
53UNLOCK TABLES;
54
55--
56-- Table structure for table `COMANDA`
57--
58
59DROP TABLE IF EXISTS `COMANDA`;
60/*!40101 SET @saved_cs_client = @@character_set_client */;
61/*!40101 SET character_set_client = utf8 */;
62CREATE TABLE `COMANDA` (
63 `COM_NUM` smallint(4) unsigned NOT NULL,
64 `COM_FECHA` date DEFAULT NULL,
65 `COM_TIPO` char(1) DEFAULT NULL,
66 `CLIENTE_COD` int(6) unsigned NOT NULL,
67 `FECHA_TRAM` date DEFAULT NULL,
68 `TOTAL` decimal(8,2) unsigned DEFAULT NULL,
69 PRIMARY KEY (`COM_NUM`),
70 KEY `IDX_COMANDA_CLIENT_COD` (`CLIENTE_COD`),
71 KEY `COMANDA_DATA_NUM` (`COM_FECHA`,`COM_NUM`),
72 KEY `COMANDA_TRAMESA_NUM` (`FECHA_TRAM`,`COM_NUM`),
73 CONSTRAINT `COMANDA_ibfk_1` FOREIGN KEY (`CLIENTE_COD`) REFERENCES `CLIENTE` (`CLIENTE_COD`)
74) ENGINE=InnoDB DEFAULT CHARSET=utf8;
75/*!40101 SET character_set_client = @saved_cs_client */;
76
77--
78-- Dumping data for table `COMANDA`
79--
80
81LOCK TABLES `COMANDA` WRITE;
82/*!40000 ALTER TABLE `COMANDA` DISABLE KEYS */;
83INSERT INTO `COMANDA` VALUES (601,'1986-05-01','A',106,'1986-05-30',2.40),(602,'1986-06-05','B',102,'1986-06-20',56.00),(603,'1986-06-05',NULL,102,'1986-06-05',224.00),(604,'1986-06-15','A',106,'1986-06-30',698.00),(605,'1986-07-14','A',106,'1986-07-30',8324.00),(606,'1986-07-14','A',100,'1986-07-30',3.40),(607,'1986-07-18','C',104,'1986-07-18',5.60),(608,'1986-07-25','C',104,'1986-07-25',35.20),(609,'1986-08-01','B',100,'1986-08-15',97.50),(610,'1987-01-07','A',101,'1987-01-08',101.40),(611,'1987-01-11','B',102,'1987-01-11',45.00),(612,'1987-01-15','C',104,'1987-01-20',5860.00),(613,'1987-02-01',NULL,108,'1987-02-01',6400.00),(614,'1987-02-01',NULL,102,'1987-02-05',23940.00),(615,'1987-02-01',NULL,107,'1987-02-06',710.00),(616,'1987-02-03',NULL,103,'1987-02-10',764.00),(617,'1987-02-05',NULL,104,'1987-03-03',46370.00),(618,'1987-02-15','A',102,'1987-03-06',3510.50),(619,'1987-02-22',NULL,104,'1987-02-04',1260.00),(620,'1987-03-12',NULL,100,'1987-03-12',4450.00),(621,'1987-03-15','A',100,'1987-01-01',730.00);
84/*!40000 ALTER TABLE `COMANDA` ENABLE KEYS */;
85UNLOCK TABLES;
86
87--
88-- Table structure for table `DEPT`
89--
90
91DROP TABLE IF EXISTS `DEPT`;
92/*!40101 SET @saved_cs_client = @@character_set_client */;
93/*!40101 SET character_set_client = utf8 */;
94CREATE TABLE `DEPT` (
95 `DEPT_NO` tinyint(2) unsigned NOT NULL,
96 `DNOM` varchar(14) NOT NULL,
97 `LOC` varchar(14) DEFAULT NULL,
98 PRIMARY KEY (`DEPT_NO`),
99 UNIQUE KEY `DNOM` (`DNOM`)
100) ENGINE=InnoDB DEFAULT CHARSET=utf8;
101/*!40101 SET character_set_client = @saved_cs_client */;
102
103--
104-- Dumping data for table `DEPT`
105--
106
107LOCK TABLES `DEPT` WRITE;
108/*!40000 ALTER TABLE `DEPT` DISABLE KEYS */;
109INSERT INTO `DEPT` VALUES (10,'CONTABILIDAD','SEVILLA'),(20,'INVESTIGACIÓN','MADRID'),(30,'VENTAS','BARCELONA'),(40,'PRODUCCIÓN','BILBAO');
110/*!40000 ALTER TABLE `DEPT` ENABLE KEYS */;
111UNLOCK TABLES;
112
113--
114-- Table structure for table `DETALLE`
115--
116
117DROP TABLE IF EXISTS `DETALLE`;
118/*!40101 SET @saved_cs_client = @@character_set_client */;
119/*!40101 SET character_set_client = utf8 */;
120CREATE TABLE `DETALLE` (
121 `COM_NUM` smallint(4) unsigned NOT NULL,
122 `DETALLE_NUM` smallint(4) unsigned NOT NULL,
123 `PROD_NUM` int(6) unsigned NOT NULL,
124 `PRECIO_VENTA` decimal(8,2) unsigned DEFAULT NULL,
125 `CANTIDAD` int(8) DEFAULT NULL,
126 `IMPORTE` decimal(8,2) DEFAULT NULL,
127 PRIMARY KEY (`COM_NUM`,`DETALLE_NUM`),
128 KEY `IDX_DETAL_COM_NUM` (`COM_NUM`),
129 KEY `IDX_PROD_NUM` (`PROD_NUM`),
130 KEY `DETALL_PROD_COM_DET` (`PROD_NUM`,`COM_NUM`,`DETALLE_NUM`),
131 CONSTRAINT `DETALLE_ibfk_1` FOREIGN KEY (`COM_NUM`) REFERENCES `COMANDA` (`COM_NUM`),
132 CONSTRAINT `DETALLE_ibfk_2` FOREIGN KEY (`PROD_NUM`) REFERENCES `PRODUCTO` (`PROD_NUM`)
133) ENGINE=InnoDB DEFAULT CHARSET=utf8;
134/*!40101 SET character_set_client = @saved_cs_client */;
135
136--
137-- Dumping data for table `DETALLE`
138--
139
140LOCK TABLES `DETALLE` WRITE;
141/*!40000 ALTER TABLE `DETALLE` DISABLE KEYS */;
142INSERT INTO `DETALLE` VALUES (601,1,200376,2.40,1,2.40),(602,1,100870,2.80,20,56.00),(603,2,100860,56.00,4,224.00),(604,1,100890,58.00,3,174.00),(604,2,100861,42.00,2,84.00),(604,3,100860,44.00,10,440.00),(605,1,100861,45.00,100,4500.00),(605,2,100870,2.80,500,1400.00),(605,3,100890,58.00,5,290.00),(605,4,101860,24.00,50,1200.00),(605,5,101863,9.00,100,900.00),(605,6,102130,3.40,10,34.00),(606,1,102130,3.40,1,3.40),(607,1,100871,5.60,1,5.60),(608,1,101860,24.00,1,24.00),(608,2,100871,5.60,2,11.20),(609,1,100861,35.00,1,35.00),(609,2,100870,2.50,5,12.50),(609,3,100890,50.00,1,50.00),(610,1,100860,35.00,1,35.00),(610,2,100870,2.80,3,8.40),(610,3,100890,58.00,1,58.00),(611,1,100861,45.00,1,45.00),(612,1,100860,30.00,100,3000.00),(612,2,100861,40.50,20,810.00),(612,3,101863,10.00,150,1500.00),(612,4,100871,5.50,100,550.00),(613,1,100871,5.60,100,560.00),(613,2,101860,24.00,200,4800.00),(613,3,200380,4.00,150,600.00),(613,4,200376,2.20,200,440.00),(614,1,100860,35.00,444,15540.00),(614,2,100870,2.80,1000,2800.00),(614,3,100871,5.60,1000,5600.00),(615,1,100861,45.00,4,180.00),(615,2,100870,2.80,100,280.00),(615,3,100871,5.00,50,250.00),(616,1,100861,45.00,10,450.00),(616,2,100870,2.80,50,140.00),(616,3,100890,58.00,2,116.00),(616,4,102130,3.40,10,34.00),(616,5,200376,2.40,10,24.00),(617,1,100860,35.00,50,1750.00),(617,2,100861,45.00,100,4500.00),(617,3,100870,2.80,500,1400.00),(617,4,100871,5.60,500,2800.00),(617,5,100890,58.00,500,29000.00),(617,6,101860,24.00,100,2400.00),(617,7,101863,12.50,200,2500.00),(617,8,102130,3.40,100,340.00),(617,9,200376,2.40,200,480.00),(617,10,200380,4.00,300,1200.00),(618,1,100860,35.00,23,805.00),(618,2,100861,45.11,50,2255.50),(618,3,100870,45.00,10,450.00),(619,1,200380,4.00,100,400.00),(619,2,200376,2.40,100,240.00),(619,3,102130,3.40,100,340.00),(619,4,100871,5.60,50,280.00),(620,1,100860,35.00,10,350.00),(620,2,200376,2.40,1000,2400.00),(620,3,102130,3.40,500,1700.00),(621,1,100861,45.00,10,450.00),(621,2,100870,2.80,100,280.00);
143/*!40000 ALTER TABLE `DETALLE` ENABLE KEYS */;
144UNLOCK TABLES;
145
146--
147-- Table structure for table `EMP`
148--
149
150DROP TABLE IF EXISTS `EMP`;
151/*!40101 SET @saved_cs_client = @@character_set_client */;
152/*!40101 SET character_set_client = utf8 */;
153CREATE TABLE `EMP` (
154 `EMP_NO` smallint(4) unsigned NOT NULL,
155 `APELLIDO` varchar(10) NOT NULL,
156 `OFICIO` varchar(10) DEFAULT NULL,
157 `JEFE` smallint(4) unsigned DEFAULT NULL,
158 `FECHA_ALTA` date DEFAULT NULL,
159 `SALARIO` int(10) unsigned DEFAULT NULL,
160 `COMISIÓN` int(10) unsigned DEFAULT NULL,
161 `DEPT_NO` tinyint(2) unsigned NOT NULL,
162 PRIMARY KEY (`EMP_NO`),
163 KEY `IDX_EMP_JEFE` (`JEFE`),
164 KEY `IDX_EMP_DEPT_NO` (`DEPT_NO`),
165 KEY `EMP_APELLIDO` (`APELLIDO`),
166 KEY `EMP_DEPT_NO_EMP` (`DEPT_NO`,`EMP_NO`),
167 CONSTRAINT `EMP_ibfk_1` FOREIGN KEY (`DEPT_NO`) REFERENCES `DEPT` (`DEPT_NO`),
168 CONSTRAINT `EMP_ibfk_2` FOREIGN KEY (`JEFE`) REFERENCES `EMP` (`EMP_NO`)
169) ENGINE=InnoDB DEFAULT CHARSET=utf8;
170/*!40101 SET character_set_client = @saved_cs_client */;
171
172--
173-- Dumping data for table `EMP`
174--
175
176LOCK TABLES `EMP` WRITE;
177/*!40000 ALTER TABLE `EMP` DISABLE KEYS */;
178INSERT INTO `EMP` VALUES (7369,'SÁNCHEZ','EMPLEADO',7902,'1980-12-17',104000,NULL,20),(7499,'ARROYO','VENDEDOR',7698,'1980-02-20',208000,39000,30),(7521,'SALA','VENDEDOR',7698,'1981-02-22',162500,65000,30),(7566,'JIMENEZ','DIRECTOR',7839,'1981-04-02',386750,NULL,20),(7654,'MARTIN','VENDEDOR',7698,'1981-09-29',162500,182000,30),(7698,'NEGRO','DIRECTOR',7839,'1981-05-01',370500,NULL,30),(7782,'CEREZO','DIRECTOR',7839,'1981-06-09',318500,NULL,10),(7788,'GIL','ANALISTA',7566,'1981-11-09',390000,NULL,20),(7839,'REY','PRESIDENTE',NULL,'1981-11-17',650000,NULL,10),(7844,'TOVAR','VENDEDOR',7698,'1981-09-08',195000,0,30),(7876,'ALONSO','EMPLEADO',7788,'1981-09-23',143000,NULL,20),(7900,'JIMENO','EMPLEADO',7698,'1981-12-03',123500,NULL,30),(7902,'FERNÁNDEZ','ANALISTA',7566,'1981-12-03',390000,NULL,20),(7934,'MUÑOZ','EMPLEADO',7782,'1982-01-23',169000,NULL,10);
179/*!40000 ALTER TABLE `EMP` ENABLE KEYS */;
180UNLOCK TABLES;
181
182--
183-- Table structure for table `PRODUCTO`
184--
185
186DROP TABLE IF EXISTS `PRODUCTO`;
187/*!40101 SET @saved_cs_client = @@character_set_client */;
188/*!40101 SET character_set_client = utf8 */;
189CREATE TABLE `PRODUCTO` (
190 `PROD_NUM` int(6) unsigned NOT NULL,
191 `DESCRIPCIÓN` varchar(30) NOT NULL,
192 PRIMARY KEY (`PROD_NUM`),
193 UNIQUE KEY `DESCRIPCIÓN` (`DESCRIPCIÓN`)
194) ENGINE=InnoDB DEFAULT CHARSET=utf8;
195/*!40101 SET character_set_client = @saved_cs_client */;
196
197--
198-- Dumping data for table `PRODUCTO`
199--
200
201LOCK TABLES `PRODUCTO` WRITE;
202/*!40000 ALTER TABLE `PRODUCTO` DISABLE KEYS */;
203INSERT INTO `PRODUCTO` VALUES (100870,'ACE TENNIS BALLS-3 PACK'),(100871,'ACE TENNIS BALLS-6 PACK'),(100890,'ACE TENNIS NET'),(100860,'ACE TENNIS RACKET I'),(100861,'ACE TENNIS RACKET II'),(102130,'RH: \"GUIDE TO TENNIS\"'),(200376,'SB ENERGY BAR-6 PACK'),(200380,'SB VITA SNACK-6 PACK'),(101863,'SP JUNIOR RACKET'),(101860,'SP TENNIS RACKET');
204/*!40000 ALTER TABLE `PRODUCTO` ENABLE KEYS */;
205UNLOCK TABLES;
206/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
207
208/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
209/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
210/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
211/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
212/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
213/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
214/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
215
216-- Dump completed on 2020-03-06 17:58:40