9bEMjy8K

12018-2019 1SIT GBD
2Tablón
3Trabajo de clase
4Personas
52018-2019 1SIT GBD
6Fecha de entrega próxima
7¡Yuju! ¡No tienes que entregar ninguna tarea esta semana!
8Ver todo
9
10Comparte algo con tu clase…
11
12Anuncio: "Os comunico algunas fechas…"
13Roberto Fdez.
14Fecha de creación: 4 jun.4 jun.
15Os comunico algunas fechas significativas que existían, desde el inicio de curso, en la agenda del centro. Esto quiere decir que, si hay algún cambio, deberá aparecer en los tablones del centro.
16
17- Día 11: entrega de boletines de notas, a las 17h, en aula de tutoría. A partir de este día se abre el periodo de reclamación de calificaciones finales.
18
19- Días 10 al 13 (yo me adelanto y empiezo mañana, ya que tengo permiso): Comienzo de actividades de ampliación (para aquellos alumnos que hubiesen aprobado) y de recuperación (para aquellos que tienen que presentarse a la convocatoria extraordinaria). 
20
21Nota: en mi caso, si hay gente que viene tanto a actividades de ampliación como de recuperación, repartiré el tiempo. Sobre los posibles temas que podéis tratar conmigo en las actividades de ampliación son, por ejemplo: bases de datos, programación, redes, ciberseguridad, servicios (web, dns, correo electrónico...) o cualquier cosa que se os ocurra y lo pueda abordar. Ojo: esto lo hago yo, por tanto, no quiere decir que el resto de los profesores haga lo mismo. Debéis hablar con ellos.
22
23- Días 11, 12 y 13: renuncia a convocatoria extraordinaria.
24
25- Día 25: entrega de boletines de notas, a las 17h, en aula de tutoría.
26
27Roberto Fdez.10 jun.
28En clase
29
30Anuncio: "Mañana hay tutoría. Tenéis que estar…"
31Roberto Fdez.
32Fecha de creación: 28 may.28 may.
33Mañana hay tutoría. Tenéis que estar todos
34
35Anuncio: "En la práctica faltaban 0.3 puntos, así…"
36Roberto Fdez.
37Fecha de creación: 26 may.26 may.
38En la práctica faltaban 0.3 puntos, así que a todos os añado esos 0.3 puntos.
39
40Anuncio: "Os recuerdo a todos que tenéis hasta…"
41Roberto Fdez.
42Fecha de creación: 19 may.19 may. (Última modificación: 19 may.)
43Os recuerdo a todos que tenéis hasta hoy, como plazo, para entregar la práctica. No se admitirá ninguna práctica pasada la hora (ni un segundo más), sería agravio comparativo. No obstante, aunque no hay por qué justificar lo anterior, por si alguien tiene dudas, en la misma programación se indica "El alumno debe entregar en tiempo y forma todas las prácticas concretas".
44
45Por otro lado, recordad también que la pérdida de evaluación continua significa que el alumno no puede alcanzar los objetivos porque sencillamente se falta a clase (da igual el motivo: asuntos de trabajo, enfermedades u otros motivos). De hecho, todos los que habéis superado el límite y habéis intentado hacer la práctica encontráis serias dificultades para entender algunos apartados de la práctica. Es lógico.
46
47Os pido que seáis coherentes, razonables. Ya lo hemos hablado en clase y, además, he sido laxo con el cómputo de horas y os pedí feedback con este asunto porque me preocupa mucho y parece ser, también, que confundíais esta pérdida de evaluación continua (normas del centro) con pérdidas de matrícula. Os dejo el enlace de la normativa al respecto: http://www.madrid.org/wleg_pub/secure/normativas/contenidoNormativa.jsf?opcion=VerHtml&nmnorma=5722&cdestado=P#no-back-button
48
49Ánimo a todos.
50
51Anuncio: "Aunque igual ya no viene a cuento, el…"
52Roberto Fdez.
53Fecha de creación: 14 may.14 may.
54Aunque igual ya no viene a cuento, el fichero que tenéis subido al Google Classroom (Erratas_Martinez_Diseño_de_bases_de_datos.pdf) tenía mal el contenido, aunque en su momento, en las transparencias que se utilizaron en clase estuviese bien. Ya está corregido.
55
56El fichero en cuestión está en el apartado del "Modelo relacional" en la pestaña "Trabajo de clase" de Google Classroom.
57
58Anuncio: "Ya tenéis la práctica de la tercera…"
59Roberto Fdez.
60Fecha de creación: 12 may.12 may.
61Ya tenéis la práctica de la tercera evaluación al completo junto con la calificación de cada apartado y los criterios de evaluación.
62
63Ánimo.
64
65Anuncio: "Me he dado cuenta de que hay un error…"
66Roberto Fdez.
67Fecha de creación: 12 may.12 may.
68Me he dado cuenta de que hay un error en la transparencia de los disparadores, donde se explicaban las cláusulas FOLLOWS y PRECEDES .
69
70Siendo "nombreDisparador" el disparador donde se incluye una de esas dos cláusulas, entonces:
71
72- FOLLOWS nombreOtroDisparador: se activa primero nombreOtroDisparador. (nombreOtroDisparador → nombreDisparador).
73
74- PRECEDES nombreOtroDisparador: se activa primero nombreDisparador (nombreDisparador → nombreOtroDisparador).
75
76Anuncio: "ALTER DATABASE tiendaVirtual DEFAULT…"
77Roberto Fdez.
78Fecha de creación: 6 may.6 may.
79ALTER DATABASE tiendaVirtual DEFAULT CHARACTER SET=utf8 DEFAULT COLLATE=utf8_spanish_ci; 
80ALTER TABLE departamentos DEFAULT CHARACTER SET=utf8 DEFAULT COLLATE=utf8_spanish_ci;
81
82Anuncio: "Apartado de normalización añadido a la…"
83Roberto Fdez.
84Fecha de creación: 4 may.4 may.
85Apartado de normalización añadido a la práctica. Faltan dos apartados más a añadir.
86
87La fecha límite de entrega está fijada para el domingo día 19 de mayo a las 23:59h.
88
89Anuncio: "Quería desearos unas vacaciones con…"
90Roberto Fdez.
91Fecha de creación: 12 abr.12 abr.
92Quería desearos unas vacaciones con mucho relax.. o no...: he añadido, en la tarea, los dos apartados que os comenté el otro día.
93
94Ánimo
95
96Anuncio: "Soluciones rec 2ª eval (recordad que…"
97Roberto Fdez.
98Fecha de creación: 9 abr.9 abr.
99Soluciones rec 2ª eval (recordad que pueden haber varias soluciones diferentes)
100
101BD_18-19_ex_rec2eval_2019_sol_alumno
102Documentos de Google
103Roberto Fdez. ha publicado una nueva tarea: Práctica. Tercera evaluación
104Límite de entrega: 19 may. 23:59
105Publicado el 7 abr. (Última modificación: 26 may.)
106Tarea entregada
107Recordad que las tareas del enunciado se irá incrementando a medida que avance el curso.
108Faltan por meter también, criterios de calificación y la fecha de entrega.
109
110BD_2018-2019_3eval_practica_alumno
111Documentos de Google
112
113Roberto Fdez.12 may.
114Práctica de la tercera evaluación al completo junto con la calificación de cada apartado y los criterios de evaluación.
115
116Anuncio: "Voy a cambiar el nombre de una columna…"
117Roberto Fdez.
118Fecha de creación: 22 mar.22 mar.
119Voy a cambiar el nombre de una columna (de la tabla proveedores) e indicarle que sea única en la base de datos tiendaVirtual. No hace falta que volváis a bajar el fichero .sql si ejecutáis las siguientes sentencias:
120
121ALTER TABLE tiendaVirtual.proveedores CHANGE COLUMN SupplierName nombre VARCHAR(255) NULL DEFAULT NULL;
122
123ALTER TABLE tiendaVirtual.proveedores ADD UNIQUE INDEX (nombre);
124
125Anuncio: "La base de datos de la tienda virtual…"
126Roberto Fdez.
127Fecha de creación: 20 mar.20 mar.
128La base de datos de la tienda virtual se ha modificado ligeramente: 
129
130- Hay pedidos sin asignación a empleados.
131- Algunas de las fechas de los pedidos se han modificado.
132- Las tablas de clientes y proveedores utilizan la tabla paises; 
133- Algunas columnas de diversas tablas no permiten nulos.
134
135También os he dejado una imagen con el diseño E-R.
136
137Saludos
138Roberto Fdez. ha publicado nuevo material: Base de datos tienda Virtual
139Publicado el 20 mar. (Última modificación: 22 mar.)
140La usaremos en clase y en el examen. Es probable que sufra modificaciones
141
142tiendaVirtual.png
143Imagen
144
145tiendaVirtual_alumno.sql
146SQL
147
148Anuncio: "Examen de recuperación de la 2ª…"
149Roberto Fdez.
150Fecha de creación: 18 mar.18 mar. (Última modificación: 18 mar.)
151Examen de recuperación de la 2ª evaluación: 3 de abril. En horas de clase
152
153Roberto Fdez.18 mar.
154Corregido
155Roberto Fdez. ha publicado nuevo material: Instalación PhpMyAdmin
156Publicado el 13 mar.
157
158InstalaciónPhpMyAdmin_alumnos
159Documentos de Google
160
161Anuncio: "Proceso de las clases el día de mañana:…"
162Roberto Fdez.
163Fecha de creación: 13 mar.13 mar.
164Proceso de las clases el día de mañana:
165
166Como ya sabéis, mañana es el concurso de Programame. Además, hay un acto de graduación, para los alumnos de 2º curso, con lo que puede (he dicho puede) haber algún adelanto de clases o cambios de horario.
167
168Por tanto, mañana, a no ser que os digan lo contrario, tendréis clase de principio a fin como siempre (no se suspenden). Evidentemente, el viernes también hay clase, de manera normal.
169
170Anuncio: "Soluciones preguntas 2ª evaluación…"
171Roberto Fdez.
172Fecha de creación: 27 feb.27 feb.
173Soluciones preguntas 2ª evaluación (recordad que puede haber otras soluciones igualmente válidas)
174
175BD_18-19_ex_2eval_sol_alumno
176Documentos de Google
177
178Anuncio: "Base de datos de w3schools para MySQL.…"
179Roberto Fdez.
180Fecha de creación: 18 feb.18 feb.
181Base de datos de w3schools para MySQL. ¡Gracias Jaime!
182
183Procedimiento para instalar la base de datos:
1841.- Descargaros el fichero que os adjunto (w3schools.sql).
1852.- Abrid el MySQL Workbench. En el menú, ejecutad File -> Open SQL Script.
1863.- Ejecutad el script (con el icono del "rayo").
1874.- A la izquierda del MySQL Workbench apareceá la base de datos cuando refresquéis: hay que pulsar el icono que aparece a la derecha de "SCHEMAS".
188
189Para cualquier duda, contactad conmigo.
190
191w3schools.sql
192SQL
193
194-- MySQL dump 10.13  Distrib 5.7.25, for Linux (x86_64)
195--
196-- Host: localhost    Database: tiendaVirtual
197-- ------------------------------------------------------
198-- Server version	5.7.25-0ubuntu0.18.04.2
199
200/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
201/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
202/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
203/*!40101 SET NAMES utf8 */;
204/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
205/*!40103 SET TIME_ZONE='+00:00' */;
206/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
207/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
208/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
209/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
210
211CREATE DATABASE IF NOT EXISTS `tiendaVirtual` /*!40100 DEFAULT CHARACTER SET utf8 */;
212USE `tiendaVirtual`;
213
214--
215-- Table structure for table `categorias`
216--
217
218DROP TABLE IF EXISTS `categorias`;
219/*!40101 SET @saved_cs_client     = @@character_set_client */;
220/*!40101 SET character_set_client = utf8 */;
221CREATE TABLE `categorias` (
222  `idCategoria` int(11) NOT NULL AUTO_INCREMENT,
223  `nombre` varchar(255) NOT NULL,
224  `descripcion` varchar(255) DEFAULT NULL,
225  PRIMARY KEY (`idCategoria`)
226) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
227/*!40101 SET character_set_client = @saved_cs_client */;
228
229--
230-- Dumping data for table `categorias`
231--
232
233LOCK TABLES `categorias` WRITE;
234/*!40000 ALTER TABLE `categorias` DISABLE KEYS */;
235INSERT INTO `categorias` VALUES (1,'Beverages','Soft drinks, coffees, teas, beers, and ales'),(2,'Condiments','Sweet and savory sauces, relishes, spreads, and seasonings'),(3,'Confections','Desserts, candies, and sweet breads'),(4,'Dairy productos','Cheeses'),(5,'Grains/Cereals','Breads, crackers, pasta, and cereal'),(6,'Meat/Poultry','Prepared meats'),(7,'Produce','Dried fruit and bean curd'),(8,'Seafood','Seaweed and fish');
236/*!40000 ALTER TABLE `categorias` ENABLE KEYS */;
237UNLOCK TABLES;
238
239--
240-- Table structure for table `clientes`
241--
242
243DROP TABLE IF EXISTS `clientes`;
244/*!40101 SET @saved_cs_client     = @@character_set_client */;
245/*!40101 SET character_set_client = utf8 */;
246CREATE TABLE `clientes` (
247  `idCliente` int(11) NOT NULL AUTO_INCREMENT,
248  `nombre` varchar(255) NOT NULL,
249  `nombreContacto` varchar(255) DEFAULT NULL,
250  `direccion` varchar(255) DEFAULT NULL,
251  `ciudad` varchar(255) DEFAULT NULL,
252  `codigoPostal` varchar(255) DEFAULT NULL,
253  `codigoPais` varchar(3) DEFAULT NULL,
254  PRIMARY KEY (`idCliente`),
255  KEY `fk_pais_idx` (`codigoPais`),
256  CONSTRAINT `fk_pais` FOREIGN KEY (`codigoPais`) REFERENCES `paises` (`codigoPais`) ON UPDATE CASCADE
257) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8;
258/*!40101 SET character_set_client = @saved_cs_client */;
259
260--
261-- Dumping data for table `clientes`
262--
263
264LOCK TABLES `clientes` WRITE;
265/*!40000 ALTER TABLE `clientes` DISABLE KEYS */;
266INSERT INTO `clientes` VALUES (1,'Alfreds Futterkiste','Maria Anders','Obere Str. 57','Berlin','12209','Ger'),(2,'Ana Trujillo Emparedados y helados','Ana Trujillo','Avda. de la Constitución 2222','México D.F.','05021','Mex'),(3,'Antonio Moreno Taquería','Antonio Moreno','Mataderos 2312','México D.F.','05023','Mex'),(4,'Around the Horn','Thomas Hardy','120 Hanover Sq.','London','WA1 1DP','UK'),(5,'Berglunds snabbköp','Christina Berglund','Berguvsvägen 8','Luleå','S-958 22','Swe'),(6,'Blauer See Delikatessen','Hanna Moos','Forsterstr. 57','Mannheim','68306','Ger'),(7,'Blondel père et fils','Frédérique Citeaux','24, place Kléber','Strasbourg','67000','Fra'),(8,'Bólido Comidas preparadas','Martín Sommer','C/ Araquil, 67','Madrid','28023','Spa'),(9,'Bon app\'','Laurence Lebihans','12, rue des Bouchers','Marseille','13008','Fra'),(10,'Bottom-Dollar Marketse','Elizabeth Lincoln','23 Tsawassen Blvd.','Tsawassen','T2F 8M4','Can'),(11,'B\'s Beverages','Victoria Ashworth','Fauntleroy Circus','London','EC2 5NT','UK'),(12,'Cactus Comidas para llevar','Patricio Simpson','Cerrito 333','Buenos Aires','1010','Arg'),(13,'Centro comercial Moctezuma','Francisco Chang','Sierras de Granada 9993','México D.F.','05022','Mex'),(14,'Chop-suey Chinese','Yang Wang','Hauptstr. 29','Bern','3012','Swi'),(15,'Comércio Mineiro','Pedro Afonso','Av. dos Lusíadas, 23','São Paulo','05432-043','Bra'),(16,'Consolidated Holdings','Elizabeth Brown','Berkeley Gardens 12 Brewery','London','WX1 6LT','UK'),(17,'Drachenblut Delikatessend','Sven Ottlieb','Walserweg 21','Aachen','52066','Ger'),(18,'Du monde entier','Janine Labrune','67, rue des Cinquante Otages','Nantes','44000','Fra'),(19,'Eastern Connection','Ann Devon','35 King George','London','WX3 6FW','UK'),(20,'Ernst Handel','Roland Mendel','Kirchgasse 6','Graz','8010','Aus'),(21,'Familia Arquibaldo','Aria Cruz','Rua Orós, 92','São Paulo','05442-030','Bra'),(22,'FISSA Fabrica Inter. Salchichas S.A.','Diego Roel','C/ Moralzarzal, 86','Madrid','28034','Spa'),(23,'Folies gourmandes','Martine Rancé','184, chaussée de Tournai','Lille','59000','Fra'),(24,'Folk och fä HB','Maria Larsson','Åkergatan 24','Bräcke','S-844 67','Swe'),(25,'Frankenversand','Peter Franken','Berliner Platz 43','München','80805','Ger'),(26,'France restauration','Carine Schmitt','54, rue Royale','Nantes','44000','Fra'),(27,'Franchi S.p.A.','Paolo Accorti','Via Monte Bianco 34','Torino','10100','Ita'),(28,'Furia Bacalhau e Frutos do Mar','Lino Rodriguez','Jardim das rosas n. 32','Lisboa','1675','Por'),(29,'Galería del gastrónomo','Eduardo Saavedra','Rambla de Cataluña, 23','Barcelona','08022','Spa'),(30,'Godos Cocina Típica','José Pedro Freyre','C/ Romero, 33','Sevilla','41101','Spa'),(31,'Gourmet Lanchonetes','André Fonseca','Av. Brasil, 442','Campinas','04876-786','Bra'),(32,'Great Lakes Food Market','Howard Snyder','2732 Baker Blvd.','Eugene','97403','USA'),(33,'GROSELLA-Restaurante','Manuel Pereira','5ª Ave. Los Palos Grandes','Caracas','1081','Ven'),(34,'Hanari Carnes','Mario Pontes','Rua do Paço, 67','Rio de Janeiro','05454-876','Bra'),(35,'HILARIÓN-Abastos','Carlos Hernández','Carrera 22 con Ave. Carlos Soublette #8-35','San Cristóbal','5022','Ven'),(36,'Hungry Coyote Import Store','Yoshi Latimer','ciudad Center Plaza 516 Main St.','Elgin','97827','USA'),(37,'Hungry Owl All-Night Grocers','Patricia McKenna','8 Johnstown Road','Cork','','Ire'),(38,'Island Trading','Helen Bennett','Garden House Crowther Way','Cowes','PO31 7PJ','UK'),(39,'Königlich Essen','Philip Cramer','Maubelstr. 90','Brandenburg','14776','Ger'),(40,'La corne d\'abondance','Daniel Tonini','67, avenue de l\'Europe','Versailles','78000','Fra'),(41,'La maison d\'Asie','Annette Roulet','1 rue Alsace-Lorraine','Toulouse','31000','Fra'),(42,'Laughing Bacchus Wine Cellars','Yoshi Tannamuri','1900 Oak St.','Vancouver','V3F 2K1','Can'),(43,'Lazy K Kountry Store','John Steel','12 Orchestra Terrace','Walla Walla','99362','USA'),(44,'Lehmanns Marktstand','Renate Messner','Magazinweg 7','Frankfurt a.M.','60528','Ger'),(45,'Let\'s Stop N Shop','Jaime Yorres','87 Polk St. Suite 5','San Francisco','94117','USA'),(46,'LILA-Supermercado','Carlos González','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','3508','Ven'),(47,'LINO-Delicateses','Felipe Izquierdo','Ave. 5 de Mayo Porlamar','I. de Margarita','4980','Ven'),(48,'Lonesome Pine Restaurant','Fran Wilson','89 Chiaroscuro Rd.','Portland','97219','USA'),(49,'Magazzini Alimentari Riunidadi','Giovanni Rovelli','Via Ludovico il Moro 22','Bergamo','24100','Ita'),(50,'Maison Dewey','Catherine Dewey','Rue Joseph-Bens 532','Bruxelles','B-1180','Bel'),(51,'Mère Paillarde','Jean Fresnière','43 rue St. Laurent','Montréal','H1J 1C3','Can'),(52,'Morgenstern Gesundkost','Alexander Feuer','Heerstr. 22','Leipzig','04179','Ger'),(53,'North/South','Simon Crowther','South House 300 Queensbridge','London','SW7 1RZ','UK'),(54,'Océano Atlántico Ltda.','Yvonne Moncada','Ing. Gustavo Moncada 8585 Piso 20-A','Buenos Aires','1010','Arg'),(55,'Old World Delicatessen','Rene Phillips','2743 Bering St.','Anchorage','99508','USA'),(56,'Ottilies Käseladen','Henriette Pfalzheim','Mehrheimerstr. 369','Köln','50739','Ger'),(57,'Paris spécialités','Marie Bertrand','265, boulevard Charonne','Paris','75012','Fra'),(58,'Pericles Comidas clásicas','Guillermo Fernández','Calle Dr. Jorge Cash 321','México D.F.','05033','Mex'),(59,'Piccolo und mehr','Georg Pipps','Geislweg 14','Salzburg','5020','Aus'),(60,'Princesa Isabel Vinhoss','Isabel de Castro','Estrada da saúde n. 58','Lisboa','1756','Por'),(61,'Que Delícia','Bernardo Batista','Rua da Panificadora, 12','Rio de Janeiro','02389-673','Bra'),(62,'Queen Cozinha','Lúcia Carvalho','Alameda dos Canàrios, 891','São Paulo','05487-020','Bra'),(63,'QUICK-Stop','Horst Kloss','Taucherstraße 10','Cunewalde','01307','Ger'),(64,'Rancho grande','Sergio Gutiérrez','Av. del Libertador 900','Buenos Aires','1010','Arg'),(65,'Rattlesnake Canyon Grocery','Paula Wilson','2817 Milton Dr.','Albuquerque','87110','USA'),(66,'Reggiani Caseifici','Maurizio Moroni','Strada Provinciale 124','Reggio Emilia','42100','Ita'),(67,'Ricardo Adocicados','Janete Limeira','Av. Copacabana, 267','Rio de Janeiro','02389-890','Bra'),(68,'Richter Supermarkt','Michael Holz','Grenzacherweg 237','Genève','1203','Swi'),(69,'Romero y tomillo','Alejandra Camino','Gran Vía, 1','Madrid','28001','Spa'),(70,'Santé Gourmet','Jonas Bergulfsen','Erling Skakkes gate 78','Stavern','4110','Nor'),(71,'Save-a-lot Markets','Jose Pavarotti','187 Suffolk Ln.','Boise','83720','USA'),(72,'Seven Seas Imports','Hari Kumar','90 Wadhurst Rd.','London','OX15 4NB','UK'),(73,'Simons bistro','Jytte Petersen','Vinbæltet 34','København','1734','Den'),(74,'Spécialités du monde','Dominique Perrier','25, rue Lauriston','Paris','75016','Fra'),(75,'Split Rail Beer & Ale','Art Braunschweiger','P.O. Box 555','Lander','82520','USA'),(76,'Suprêmes délices','Pascale Cartrain','Boulevard Tirou, 255','Charleroi','B-6000','Bel'),(77,'The Big Cheese','Liz Nixon','89 Jefferson Way Suite 2','Portland','97201','USA'),(78,'The Cracker Box','Liu Wong','55 Grizzly Peak Rd.','Butte','59801','USA'),(79,'Toms Spezialitäten','Karin Josephs','Luisenstr. 48','Münster','44087','Ger'),(80,'Tortuga Restaurante','Miguel Angel Paolino','Avda. Azteca 123','México D.F.','05033','Mex'),(81,'Tradição Hipermercados','Anabela Domingues','Av. Inês de Castro, 414','São Paulo','05634-030','Bra'),(82,'Trail\'s Head Gourmet Provisioners','Helvetius Nagy','722 DaVinci Blvd.','Kirkland','98034','USA'),(83,'Vaffeljernet','Palle Ibsen','Smagsløget 45','Århus','8200','Den'),(84,'Victuailles en stock','Mary Saveley','2, rue du Commerce','Lyon','69004','Fra'),(85,'Vins et alcools Chevalier','Paul Henriot','59 rue de l\'Abbaye','Reims','51100','Fra'),(86,'Die Wandernde Kuh','Rita Müller','Adenauerallee 900','Stuttgart','70563','Ger'),(87,'Wartian Herkku','Pirkko Koskitalo','Torikatu 38','Oulu','90110','Fin'),(88,'Wellington Importadora','Paula Parente','Rua do Mercado, 12','Resende','08737-363','Bra'),(89,'White Clover Markets','Karl Jablonski','305 - 14th Ave. S. Suite 3B','Seattle','98128','USA'),(90,'Wilman Kala','Matti Karttunen','Keskuskatu 45','Helsinki','21240','Fin'),(91,'Wolski','Zbyszek','ul. Filtrowa 68','Walla','01-012','Pol');
267/*!40000 ALTER TABLE `clientes` ENABLE KEYS */;
268UNLOCK TABLES;
269
270--
271-- Table structure for table `companiaTransportes`
272--
273
274DROP TABLE IF EXISTS `companiaTransportes`;
275/*!40101 SET @saved_cs_client     = @@character_set_client */;
276/*!40101 SET character_set_client = utf8 */;
277CREATE TABLE `companiaTransportes` (
278  `idCompaniaTransportes` int(11) NOT NULL AUTO_INCREMENT,
279  `nombre` varchar(255) NOT NULL,
280  `telefono` varchar(255) DEFAULT NULL,
281  PRIMARY KEY (`idCompaniaTransportes`)
282) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
283/*!40101 SET character_set_client = @saved_cs_client */;
284
285--
286-- Dumping data for table `companiaTransportes`
287--
288
289LOCK TABLES `companiaTransportes` WRITE;
290/*!40000 ALTER TABLE `companiaTransportes` DISABLE KEYS */;
291INSERT INTO `companiaTransportes` VALUES (1,'Speedy Express','(503) 555-9831'),(2,'unidaded Package','(503) 555-3199'),(3,'Federal Shipping','(503) 555-9931');
292/*!40000 ALTER TABLE `companiaTransportes` ENABLE KEYS */;
293UNLOCK TABLES;
294
295--
296-- Table structure for table `departamentos`
297--
298
299DROP TABLE IF EXISTS `departamentos`;
300/*!40101 SET @saved_cs_client     = @@character_set_client */;
301/*!40101 SET character_set_client = utf8 */;
302CREATE TABLE `departamentos` (
303  `idDepartamento` smallint(6) NOT NULL AUTO_INCREMENT,
304  `codigo` varchar(5) COLLATE utf8_spanish_ci NOT NULL,
305  `nombre` varchar(30) COLLATE utf8_spanish_ci NOT NULL,
306  `localizacion` varchar(22) COLLATE utf8_spanish_ci DEFAULT NULL,
307  PRIMARY KEY (`idDepartamento`),
308  UNIQUE KEY `codigo` (`codigo`)
309) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
310/*!40101 SET character_set_client = @saved_cs_client */;
311
312--
313-- Dumping data for table `departamentos`
314--
315
316LOCK TABLES `departamentos` WRITE;
317/*!40000 ALTER TABLE `departamentos` DISABLE KEYS */;
318INSERT INTO `departamentos` VALUES (4,'I','Informática',NULL),(5,'M','Márketing',NULL),(6,'V','Ventas',NULL);
319/*!40000 ALTER TABLE `departamentos` ENABLE KEYS */;
320UNLOCK TABLES;
321
322--
323-- Table structure for table `empleados`
324--
325
326DROP TABLE IF EXISTS `empleados`;
327/*!40101 SET @saved_cs_client     = @@character_set_client */;
328/*!40101 SET character_set_client = utf8 */;
329CREATE TABLE `empleados` (
330  `idEmpleado` int(11) NOT NULL AUTO_INCREMENT,
331  `apellidos` varchar(255) NOT NULL,
332  `nombre` varchar(255) NOT NULL,
333  `fechaNacimiento` date DEFAULT NULL,
334  `foto` varchar(255) DEFAULT NULL,
335  `notas` text,
336  `idDepartamento` smallint(6) NULL,
337  `idSupervisor` int(11) DEFAULT NULL,
338  PRIMARY KEY (`idEmpleado`),
339  foreign key (idDepartamento) references departamentos(idDepartamento) on delete restrict on update cascade,
340  foreign key (`idSupervisor`) references empleados(idEmpleado) on delete restrict on update cascade
341) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
342/*!40101 SET character_set_client = @saved_cs_client */;
343
344--
345-- Dumping data for table `empleados`
346--
347
348LOCK TABLES `empleados` WRITE;
349/*!40000 ALTER TABLE `empleados` DISABLE KEYS */;
350INSERT INTO `empleados` VALUES (1,'Davolio','Nancy','1968-12-08','EmpID1.pic','Education includes a BA in psychology from Colorado State University. She also completed (The Art of the Cold Call). Nancy is a member of \'Toastmasters International\'.',6,NULL),(2,'Fuller','Andrew','1952-02-19','EmpID2.pic','Andrew received his BTS commercial and a Ph.D. in international marketing from the University of Dallas. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.',6,NULL),(3,'Leverling','Janet','1963-08-30','EmpID3.pic','Janet has a BS degree in chemistry from Boston College). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate and was promoted to sales representative.',6,5),(4,'Peacock','Margaret','1958-09-19','EmpID4.pic','Margaret holds a BA in English literature from Concordia College and an MA from the American Institute of Culinary Arts. She was temporarily assigned to the London office before returning to her permanent post in Seattle.',6,6),(5,'Buchanan','Steven','1955-03-04','EmpID5.pic','Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree. Upon joining the company as a sales representative, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London, where he was promoted to sales manager. Mr. Buchanan has completed the courses \'Successful Telemarketing\' and \'International Sales Management\'. He is fluent in French.',6,7),(6,'Suyama','Michael','1963-07-02','EmpID6.pic','Michael is a graduate of Sussex University (MA, economics) and the University of California at Los Angeles (MBA, marketing). He has also taken the courses \'Multi-Cultural Selling\' and \'Time Management for the Sales Professional\'. He is fluent in Japanese and can read and write French, Portuguese, and Spanish.',6,7),(7,'King','Robert','1960-05-29','EmpID7.pic','Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan and then joining the company. After completing a course entitled \'Selling in Europe\', he was transferred to the London office.',6,5),(8,'Callahan','Laura','1958-01-09','EmpID8.pic','Laura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French.',6,6),(9,'Dodsworth','Anne','1969-07-02','EmpID9.pic','Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.',6,NULL),(10,'West','Adam','1928-09-19','EmpID10.pic','An old chum.',6,NULL),(11,'López','Luisa','1958-09-19',NULL,NULL,4,NULL);
351/*!40000 ALTER TABLE `empleados` ENABLE KEYS */;
352UNLOCK TABLES;
353
354--
355-- Table structure for table `lineasDePedido`
356--
357
358DROP TABLE IF EXISTS `lineasDePedido`;
359/*!40101 SET @saved_cs_client     = @@character_set_client */;
360/*!40101 SET character_set_client = utf8 */;
361CREATE TABLE `lineasDePedido` (
362  `idLineaDePedido` int(11) NOT NULL AUTO_INCREMENT,
363  `idPedido` int(11) NOT NULL,
364  `idProducto` int(11) NOT NULL,
365  `cantidad` int(11) NOT NULL,
366  `precioUnitario` decimal(10,3) NOT NULL,
367  PRIMARY KEY (`idLineaDePedido`),
368  unique key `index4` (`idPedido`,`idProducto`),
369  KEY `idPedido` (`idPedido`),
370  KEY `idProducto` (`idProducto`),
371  CONSTRAINT `lineasDePedido_ibfk_1` FOREIGN KEY (`idPedido`) REFERENCES `pedidos` (`idPedido`),
372  CONSTRAINT `lineasDePedido_ibfk_2` FOREIGN KEY (`idProducto`) REFERENCES `productos` (`idProducto`)
373) ENGINE=InnoDB AUTO_INCREMENT=519 DEFAULT CHARSET=utf8;
374/*!40101 SET character_set_client = @saved_cs_client */;
375
376--
377-- Dumping data for table `lineasDePedido`
378--
379
380LOCK TABLES `lineasDePedido` WRITE;
381/*!40000 ALTER TABLE `lineasDePedido` DISABLE KEYS */;
382INSERT INTO `lineasDePedido` VALUES (1,10248,11,12,21.000),(2,10248,42,10,14.000),(3,10248,72,5,34.800),(4,10249,14,9,23.250),(5,10249,51,40,53.000),(6,10250,41,10,9.650),(7,10250,51,35,53.000),(8,10250,65,15,21.050),(9,10251,22,6,21.000),(10,10251,57,15,19.500),(11,10251,65,20,21.050),(12,10252,20,40,81.000),(13,10252,33,25,2.500),(14,10252,60,40,34.000),(15,10253,31,20,12.500),(16,10253,39,42,18.000),(17,10253,49,40,20.000),(18,10254,24,15,4.500),(19,10254,55,21,24.000),(20,10254,74,21,10.000),(21,10255,2,20,19.000),(22,10255,16,35,17.450),(23,10255,36,25,19.000),(24,10255,59,30,55.000),(25,10256,53,15,32.800),(26,10256,77,12,13.000),(27,10257,27,25,43.900),(28,10257,39,6,18.000),(29,10257,77,15,13.000),(30,10258,2,50,19.000),(31,10258,5,65,21.350),(32,10258,32,6,32.000),(33,10259,21,10,10.000),(34,10259,37,1,26.000),(35,10260,41,16,9.650),(36,10260,57,50,19.500),(37,10260,62,15,49.300),(38,10260,70,21,15.000),(39,10261,21,20,10.000),(40,10261,35,20,18.000),(41,10262,5,12,21.350),(42,10262,7,15,30.000),(43,10262,56,2,38.000),(44,10263,16,60,17.450),(45,10263,24,28,4.500),(46,10263,30,60,25.890),(47,10263,74,36,10.000),(48,10264,2,35,19.000),(49,10264,41,25,9.650),(50,10265,17,30,39.000),(51,10265,70,20,15.000),(52,10266,12,12,38.000),(53,10267,40,50,18.400),(54,10267,59,70,55.000),(55,10267,76,15,18.000),(56,10268,29,10,123.790),(57,10268,72,4,34.800),(58,10269,33,60,2.500),(59,10269,72,20,34.800),(60,10270,36,30,19.000),(61,10270,43,25,46.000),(62,10271,33,24,2.500),(63,10272,20,6,81.000),(64,10272,31,40,12.500),(65,10272,72,24,34.800),(66,10273,10,24,31.000),(67,10273,31,15,12.500),(68,10273,33,20,2.500),(69,10273,40,60,18.400),(70,10273,76,33,18.000),(71,10274,71,20,21.500),(72,10274,72,7,34.800),(73,10275,24,12,4.500),(74,10275,59,6,55.000),(75,10276,10,15,31.000),(76,10276,13,10,6.000),(77,10277,28,20,45.600),(78,10277,62,12,49.300),(79,10278,44,16,19.450),(80,10278,59,15,55.000),(81,10278,63,8,43.900),(82,10278,73,25,15.000),(83,10279,17,15,39.000),(84,10280,24,12,4.500),(85,10280,55,20,24.000),(86,10280,75,30,7.750),(87,10281,19,1,9.200),(88,10281,24,6,4.500),(89,10281,35,4,18.000),(90,10282,30,6,25.890),(91,10282,57,2,19.500),(92,10283,15,20,15.500),(93,10283,19,18,9.200),(94,10283,60,35,34.000),(95,10283,72,3,34.800),(96,10284,27,15,43.900),(97,10284,44,21,19.450),(98,10284,60,20,34.000),(99,10284,67,5,14.000),(100,10285,1,45,18.000),(101,10285,40,40,18.400),(102,10285,53,36,32.800),(103,10286,35,100,18.000),(104,10286,62,40,49.300),(105,10287,16,40,17.450),(106,10287,34,20,14.000),(107,10287,46,15,12.000),(108,10288,54,10,7.450),(109,10288,68,3,12.500),(110,10289,3,30,10.000),(111,10289,64,9,33.250),(112,10290,5,20,21.350),(113,10290,29,15,123.790),(114,10290,49,15,20.000),(115,10290,77,10,13.000),(116,10291,13,20,6.000),(117,10291,44,24,19.450),(118,10291,51,2,53.000),(119,10292,20,20,81.000),(120,10293,18,12,62.500),(121,10293,24,10,4.500),(122,10293,63,5,43.900),(123,10293,75,6,7.750),(124,10294,1,18,18.000),(125,10294,17,15,39.000),(126,10294,43,15,46.000),(127,10294,60,21,34.000),(128,10294,75,6,7.750),(129,10295,56,4,38.000),(130,10296,11,12,21.000),(131,10296,16,30,17.450),(132,10296,69,15,36.000),(133,10297,39,60,18.000),(134,10297,72,20,34.800),(135,10298,2,40,19.000),(136,10298,36,40,19.000),(137,10298,59,30,55.000),(138,10298,62,15,49.300),(139,10299,19,15,9.200),(140,10299,70,20,15.000),(141,10300,66,30,17.000),(142,10300,68,20,12.500),(143,10301,40,10,18.400),(144,10301,56,20,38.000),(145,10302,17,40,39.000),(146,10302,28,28,45.600),(147,10302,43,12,46.000),(148,10303,40,40,18.400),(149,10303,65,30,21.050),(150,10303,68,15,12.500),(151,10304,49,30,20.000),(152,10304,59,10,55.000),(153,10304,71,2,21.500),(154,10305,18,25,62.500),(155,10305,29,25,123.790),(156,10305,39,30,18.000),(157,10306,30,10,25.890),(158,10306,53,10,32.800),(159,10306,54,5,7.450),(160,10307,62,10,49.300),(161,10307,68,3,12.500),(162,10308,69,1,36.000),(163,10308,70,5,15.000),(164,10309,4,20,22.000),(165,10309,6,30,25.000),(166,10309,42,2,14.000),(167,10309,43,20,46.000),(168,10309,71,3,21.500),(169,10310,16,10,17.450),(170,10310,62,5,49.300),(171,10311,42,6,14.000),(172,10311,69,7,36.000),(173,10312,28,4,45.600),(174,10312,43,24,46.000),(175,10312,53,20,32.800),(176,10312,75,10,7.750),(177,10313,36,12,19.000),(178,10314,32,40,32.000),(179,10314,58,30,13.250),(180,10314,62,25,49.300),(181,10315,34,14,14.000),(182,10315,70,30,15.000),(183,10316,41,10,9.650),(184,10316,62,70,49.300),(185,10317,1,20,18.000),(186,10318,41,20,9.650),(187,10318,76,6,18.000),(188,10319,17,8,39.000),(189,10319,28,14,45.600),(190,10319,76,30,18.000),(191,10320,71,30,21.500),(192,10321,35,10,18.000),(193,10322,52,20,7.000),(194,10323,15,5,15.500),(195,10323,25,4,14.000),(196,10323,39,4,18.000),(197,10324,16,21,17.450),(198,10324,35,70,18.000),(199,10324,46,30,12.000),(200,10324,59,40,55.000),(201,10324,63,80,43.900),(202,10325,6,6,25.000),(203,10325,13,12,6.000),(204,10325,14,9,23.250),(205,10325,31,4,12.500),(206,10325,72,40,34.800),(207,10326,4,24,22.000),(208,10326,57,16,19.500),(209,10326,75,50,7.750),(210,10327,2,25,19.000),(211,10327,11,50,21.000),(212,10327,30,35,25.890),(213,10327,58,30,13.250),(214,10328,59,9,55.000),(215,10328,65,40,21.050),(216,10328,68,10,12.500),(217,10329,19,10,9.200),(218,10329,30,8,25.890),(219,10329,38,20,263.500),(220,10329,56,12,38.000),(221,10330,26,50,31.230),(222,10330,72,25,34.800),(223,10331,54,15,7.450),(224,10332,18,40,62.500),(225,10332,42,10,14.000),(226,10332,47,16,9.500),(227,10333,14,10,23.250),(228,10333,21,10,10.000),(229,10333,71,40,21.500),(230,10334,52,8,7.000),(231,10334,68,10,12.500),(232,10335,2,7,19.000),(233,10335,31,25,12.500),(234,10335,32,6,32.000),(235,10335,51,48,53.000),(236,10336,4,18,22.000),(237,10337,23,40,9.000),(238,10337,26,24,31.230),(239,10337,36,20,19.000),(240,10337,37,28,26.000),(241,10337,72,25,34.800),(242,10338,17,20,39.000),(243,10338,30,15,25.890),(244,10339,4,10,22.000),(245,10339,17,70,39.000),(246,10339,62,28,49.300),(247,10340,18,20,62.500),(248,10340,41,12,9.650),(249,10340,43,40,46.000),(250,10341,33,8,2.500),(251,10341,59,9,55.000),(252,10342,2,24,19.000),(253,10342,31,56,12.500),(254,10342,36,40,19.000),(255,10342,55,40,24.000),(256,10343,64,50,33.250),(257,10343,68,4,12.500),(258,10343,76,15,18.000),(259,10344,4,35,22.000),(260,10344,8,70,40.000),(261,10345,8,70,40.000),(262,10345,19,80,9.200),(263,10345,42,9,14.000),(264,10346,17,36,39.000),(265,10346,56,20,38.000),(266,10347,25,10,14.000),(267,10347,39,50,18.000),(268,10347,40,4,18.400),(269,10347,75,6,7.750),(270,10348,1,15,18.000),(271,10348,23,25,9.000),(272,10349,54,24,7.450),(273,10350,50,15,16.250),(274,10350,69,18,36.000),(275,10351,38,20,263.500),(276,10351,41,13,9.650),(277,10351,44,77,19.450),(278,10351,65,10,21.050),(279,10352,24,10,4.500),(280,10352,54,20,7.450),(281,10353,11,12,21.000),(282,10353,38,50,263.500),(283,10354,1,12,18.000),(284,10354,29,4,123.790),(285,10355,24,25,4.500),(286,10355,57,25,19.500),(287,10356,31,30,12.500),(288,10356,55,12,24.000),(289,10356,69,20,36.000),(290,10357,10,30,31.000),(291,10357,26,16,31.230),(292,10357,60,8,34.000),(293,10358,24,10,4.500),(294,10358,34,10,14.000),(295,10358,36,20,19.000),(296,10359,16,56,17.450),(297,10359,31,70,12.500),(298,10359,60,80,34.000),(299,10360,28,30,45.600),(300,10360,29,35,123.790),(301,10360,38,10,263.500),(302,10360,49,35,20.000),(303,10360,54,28,7.450),(304,10361,39,54,18.000),(305,10361,60,55,34.000),(306,10362,25,50,14.000),(307,10362,51,20,53.000),(308,10362,54,24,7.450),(309,10363,31,20,12.500),(310,10363,75,12,7.750),(311,10363,76,12,18.000),(312,10364,69,30,36.000),(313,10364,71,5,21.500),(314,10365,11,24,21.000),(315,10366,65,5,21.050),(316,10366,77,5,13.000),(317,10367,34,36,14.000),(318,10367,54,18,7.450),(319,10367,65,15,21.050),(320,10367,77,7,13.000),(321,10368,21,5,10.000),(322,10368,28,13,45.600),(323,10368,57,25,19.500),(324,10368,64,35,33.250),(325,10369,29,20,123.790),(326,10369,56,18,38.000),(327,10370,1,15,18.000),(328,10370,64,30,33.250),(329,10370,74,20,10.000),(330,10371,36,6,19.000),(331,10372,20,12,81.000),(332,10372,38,40,263.500),(333,10372,60,70,34.000),(334,10372,72,42,34.800),(335,10373,58,80,13.250),(336,10373,71,50,21.500),(337,10374,31,30,12.500),(338,10374,58,15,13.250),(339,10375,14,15,23.250),(340,10375,54,10,7.450),(341,10376,31,42,12.500),(342,10377,28,20,45.600),(343,10377,39,20,18.000),(344,10378,71,6,21.500),(345,10379,41,8,9.650),(346,10379,63,16,43.900),(347,10379,65,20,21.050),(348,10380,30,18,25.890),(349,10380,53,20,32.800),(350,10380,60,6,34.000),(351,10380,70,30,15.000),(352,10381,74,14,10.000),(353,10382,5,32,21.350),(354,10382,18,9,62.500),(355,10382,29,14,123.790),(356,10382,33,60,2.500),(357,10382,74,50,10.000),(358,10383,13,20,6.000),(359,10383,50,15,16.250),(360,10383,56,20,38.000),(361,10384,20,28,81.000),(362,10384,60,15,34.000),(363,10385,7,10,30.000),(364,10385,60,20,34.000),(365,10385,68,8,12.500),(366,10386,24,15,4.500),(367,10386,34,10,14.000),(368,10387,24,15,4.500),(369,10387,28,6,45.600),(370,10387,59,12,55.000),(371,10387,71,15,21.500),(372,10388,45,15,9.500),(373,10388,52,20,7.000),(374,10388,53,40,32.800),(375,10389,10,16,31.000),(376,10389,55,15,24.000),(377,10389,62,20,49.300),(378,10389,70,30,15.000),(379,10390,31,60,12.500),(380,10390,35,40,18.000),(381,10390,46,45,12.000),(382,10390,72,24,34.800),(383,10391,13,18,6.000),(384,10392,69,50,36.000),(385,10393,2,25,19.000),(386,10393,14,42,23.250),(387,10393,25,7,14.000),(388,10393,26,70,31.230),(389,10393,31,32,12.500),(390,10394,13,10,6.000),(391,10394,62,10,49.300),(392,10395,46,28,12.000),(393,10395,53,70,32.800),(394,10395,69,8,36.000),(395,10396,23,40,9.000),(396,10396,71,60,21.500),(397,10396,72,21,34.800),(398,10397,21,10,10.000),(399,10397,51,18,53.000),(400,10398,35,30,18.000),(401,10398,55,120,24.000),(402,10399,68,60,12.500),(403,10399,71,30,21.500),(404,10399,76,35,18.000),(405,10399,77,14,13.000),(406,10400,29,21,123.790),(407,10400,35,35,18.000),(408,10400,49,30,20.000),(409,10401,30,18,25.890),(410,10401,56,70,38.000),(411,10401,65,20,21.050),(412,10401,71,60,21.500),(413,10402,23,60,9.000),(414,10402,63,65,43.900),(415,10403,16,21,17.450),(416,10403,48,70,12.750),(417,10404,26,30,31.230),(418,10404,42,40,14.000),(419,10404,49,30,20.000),(420,10405,3,50,10.000),(421,10406,1,10,18.000),(422,10406,21,30,10.000),(423,10406,28,42,45.600),(424,10406,36,5,19.000),(425,10406,40,2,18.400),(426,10407,11,30,21.000),(427,10407,69,15,36.000),(428,10407,71,15,21.500),(429,10408,37,10,26.000),(430,10408,54,6,7.450),(431,10408,62,35,49.300),(432,10409,14,12,23.250),(433,10409,21,12,10.000),(434,10410,33,49,2.500),(435,10410,59,16,55.000),(436,10411,41,25,9.650),(437,10411,44,40,19.450),(438,10411,59,9,55.000),(439,10412,14,20,23.250),(440,10413,1,24,18.000),(441,10413,62,40,49.300),(442,10413,76,14,18.000),(443,10414,19,18,9.200),(444,10414,33,50,2.500),(445,10415,17,2,39.000),(446,10415,33,20,2.500),(447,10416,19,20,9.200),(448,10416,53,10,32.800),(449,10416,57,20,19.500),(450,10417,38,50,263.500),(451,10417,46,2,12.000),(452,10417,68,36,12.500),(453,10417,77,35,13.000),(454,10418,2,60,19.000),(455,10418,47,55,9.500),(456,10418,61,16,28.500),(457,10418,74,15,10.000),(458,10419,60,60,34.000),(459,10419,69,20,36.000),(460,10420,9,20,97.000),(461,10420,13,2,6.000),(462,10420,70,8,15.000),(463,10420,73,20,15.000),(464,10421,19,4,9.200),(465,10421,26,30,31.230),(466,10421,53,15,32.800),(467,10421,77,10,13.000),(468,10422,26,2,31.230),(469,10423,31,14,12.500),(470,10423,59,20,55.000),(471,10424,35,60,18.000),(472,10424,38,49,263.500),(473,10424,68,30,12.500),(474,10425,55,10,24.000),(475,10425,76,20,18.000),(476,10426,56,5,38.000),(477,10426,64,7,33.250),(478,10427,14,35,23.250),(479,10428,46,20,12.000),(480,10429,50,40,16.250),(481,10429,63,35,43.900),(482,10430,17,45,39.000),(483,10430,21,50,10.000),(484,10430,56,30,38.000),(485,10430,59,70,55.000),(486,10431,17,50,39.000),(487,10431,40,50,18.400),(488,10431,47,30,9.500),(489,10432,26,10,31.230),(490,10432,54,40,7.450),(491,10433,56,28,38.000),(492,10434,11,6,21.000),(493,10434,76,18,18.000),(494,10435,2,10,19.000),(495,10435,22,12,21.000),(496,10435,72,10,34.800),(497,10436,46,5,12.000),(498,10436,56,40,38.000),(499,10436,64,30,33.250),(500,10436,75,24,7.750),(501,10437,53,15,32.800),(502,10438,19,15,9.200),(503,10438,34,20,14.000),(504,10438,57,15,19.500),(505,10439,12,15,38.000),(506,10439,16,16,17.450),(507,10439,64,6,33.250),(508,10439,74,30,10.000),(509,10440,2,45,19.000),(510,10440,16,49,17.450),(511,10440,29,24,123.790),(512,10440,61,90,28.500),(513,10441,27,50,43.900),(514,10442,11,30,21.000),(515,10442,54,80,7.450),(516,10442,66,60,17.000),(517,10443,11,6,21.000),(518,10443,28,12,45.600);
383/*!40000 ALTER TABLE `lineasDePedido` ENABLE KEYS */;
384UNLOCK TABLES;
385
386--
387-- Table structure for table `paises`
388--
389
390DROP TABLE IF EXISTS `paises`;
391/*!40101 SET @saved_cs_client     = @@character_set_client */;
392/*!40101 SET character_set_client = utf8 */;
393CREATE TABLE `paises` (
394  `codigoPais` varchar(3) NOT NULL,
395  `pais` varchar(100) NOT NULL,
396  PRIMARY KEY (`codigoPais`)
397) ENGINE=InnoDB DEFAULT CHARSET=utf8;
398/*!40101 SET character_set_client = @saved_cs_client */;
399
400--
401-- Dumping data for table `paises`
402--
403
404LOCK TABLES `paises` WRITE;
405/*!40000 ALTER TABLE `paises` DISABLE KEYS */;
406INSERT INTO `paises` VALUES ('Arg','Argentina'),('Aus','Austria'),('Bel','Belgium'),('Bra','Brazil'),('Can','Canada'),('Den','Denmark'),('Fin','Finland'),('Fra','France'),('Ger','Germany'),('Ire','Ireland'),('Ita','Italy'),('Mex','Mexico'),('Nor','Norway'),('Pol','Poland'),('Por','Portugal'),('Spa','Spain'),('Swe','Sweden'),('Swi','Switzerland'),('UK','UK'),('USA','USA'),('Ven','Venezuela'),('Jap','Japan'),('Sin','Singapore'),('Net','Netherlands');
407/*!40000 ALTER TABLE `paises` ENABLE KEYS */;
408UNLOCK TABLES;
409
410--
411-- Table structure for table `pedidos`
412--
413
414DROP TABLE IF EXISTS `pedidos`;
415/*!40101 SET @saved_cs_client     = @@character_set_client */;
416/*!40101 SET character_set_client = utf8 */;
417CREATE TABLE `pedidos` (
418  `idPedido` int(11) NOT NULL AUTO_INCREMENT,
419  `idCliente` int(11) NOT NULL,
420  `idEmpleado` int(11) DEFAULT NULL,
421  `fechaPedido` date DEFAULT NULL,
422  `idCompaniaTransportes` int(11) DEFAULT NULL,
423  PRIMARY KEY (`idPedido`),
424  KEY `idCliente` (`idCliente`),
425  KEY `idEmpleado` (`idEmpleado`),
426  KEY `idCompaniaTransportes` (`idCompaniaTransportes`),
427  CONSTRAINT `pedidos_ibfk_1` FOREIGN KEY (`idCliente`) REFERENCES `clientes` (`idCliente`),
428  CONSTRAINT `pedidos_ibfk_2` FOREIGN KEY (`idEmpleado`) REFERENCES `empleados` (`idEmpleado`),
429  CONSTRAINT `pedidos_ibfk_3` FOREIGN KEY (`idCompaniaTransportes`) REFERENCES `companiaTransportes` (`idCompaniaTransportes`)
430) ENGINE=InnoDB AUTO_INCREMENT=10444 DEFAULT CHARSET=utf8;
431/*!40101 SET character_set_client = @saved_cs_client */;
432
433--
434-- Dumping data for table `pedidos`
435--
436
437LOCK TABLES `pedidos` WRITE;
438/*!40000 ALTER TABLE `pedidos` DISABLE KEYS */;
439INSERT INTO `pedidos` VALUES (10248,90,5,'2010-07-04',3),(10249,81,6,'2018-07-05',1),(10250,34,4,'2018-07-08',2),(10251,84,3,'2019-07-08',1),(10252,76,4,'2019-07-09',2),(10253,34,3,'1996-03-10',2),(10254,14,5,'1996-01-11',2),(10255,68,9,'1996-02-12',3),(10256,88,3,'1996-03-15',2),(10257,35,4,'1996-01-16',3),(10258,20,1,'1996-07-17',1),(10259,13,4,'1996-07-18',3),(10260,55,4,'1996-07-19',1),(10261,61,4,'1996-07-19',2),(10262,65,8,'1996-07-22',3),(10263,20,9,'1996-07-23',3),(10264,24,6,'1996-07-24',3),(10265,7,2,'1996-07-25',1),(10266,87,3,'1996-07-26',3),(10267,25,4,'1996-07-29',1),(10268,33,8,'1996-07-30',3),(10269,89,5,'1996-07-31',1),(10270,87,1,'1996-08-01',1),(10271,75,6,'1996-08-01',2),(10272,65,6,'1996-08-02',2),(10273,63,3,'1996-08-05',3),(10274,85,6,'1996-08-06',1),(10275,49,1,'1996-08-07',1),(10276,80,8,'1996-08-08',3),(10277,52,2,'1996-08-09',3),(10278,5,8,'1996-08-12',2),(10279,44,8,'1996-08-13',2),(10280,5,2,'1996-08-14',1),(10281,69,4,'1996-08-14',1),(10282,69,4,'1996-08-15',1),(10283,46,3,'1996-08-16',3),(10284,44,4,'1996-08-19',1),(10285,63,1,'1996-08-20',2),(10286,63,8,'1997-08-21',3),(10287,67,8,'1996-08-22',3),(10288,66,4,'1996-08-23',1),(10289,11,7,'1996-08-26',3),(10290,15,8,'1996-08-27',1),(10291,61,6,'1996-08-27',2),(10292,81,1,'1996-08-28',2),(10293,80,1,'1996-08-29',3),(10294,65,null,'1996-08-30',3),(10295,85,2,'1996-09-02',2),(10296,46,6,'1997-09-03',1),(10297,7,5,'1996-09-04',2),(10298,37,6,'1996-09-05',2),(10299,67,null,'1996-09-06',2),(10300,49,2,'1996-09-09',2),(10301,86,8,'1997-09-09',2),(10302,76,4,'1996-09-10',2),(10303,30,7,'1996-09-11',2),(10304,80,null,'1996-09-12',1),(10305,55,8,'1996-09-13',3),(10306,69,1,'1997-09-16',3),(10307,48,2,'1996-09-17',2),(10308,2,7,'1996-09-18',3),(10309,37,3,'1996-09-19',1),(10310,77,8,'1996-09-20',2),(10311,18,1,'1996-09-20',3),(10312,86,2,'1996-09-23',2),(10313,63,2,'1996-09-24',2),(10314,65,1,'1996-09-25',2),(10315,38,4,'1996-09-26',2),(10316,65,1,'1996-09-27',3),(10317,48,6,'1996-09-30',1),(10318,38,8,'1996-10-01',2),(10319,80,7,'1996-10-02',3),(10320,87,5,'1996-10-03',3),(10321,38,3,'1996-10-03',2),(10322,58,7,'1996-10-04',3),(10323,39,4,'1996-10-07',1),(10324,71,9,'1996-10-08',1),(10325,39,1,'1996-10-09',3),(10326,8,4,'1996-10-10',2),(10327,24,2,'1996-10-11',1),(10328,28,4,'1996-10-14',3),(10329,75,4,'1996-10-15',2),(10330,46,3,'1996-10-16',1),(10331,9,9,'1996-10-16',1),(10332,51,3,'1996-10-17',2),(10333,87,5,'1996-10-18',3),(10334,84,8,'1996-10-21',2),(10335,37,7,'1996-10-22',2),(10336,60,7,'1996-10-23',2),(10337,25,4,'1996-10-24',3),(10338,55,4,'1996-10-25',3),(10339,51,2,'1996-10-28',2),(10340,9,1,'1996-10-29',3),(10341,73,7,'1996-10-29',3),(10342,25,4,'1996-10-30',2),(10343,44,4,'1996-10-31',1),(10344,89,4,'1996-11-01',2),(10345,63,2,'1996-11-04',2),(10346,65,3,'1996-11-05',3),(10347,21,4,'1996-11-06',3),(10348,86,4,'1996-11-07',2),(10349,75,7,'1996-11-08',1),(10350,41,6,'1996-11-11',2),(10351,20,1,'1996-11-11',1),(10352,28,3,'1996-11-12',3),(10353,59,7,'1996-11-13',3),(10354,58,8,'1996-11-14',3),(10355,4,6,'1996-11-15',1),(10356,86,6,'1996-11-18',2),(10357,46,1,'1996-11-19',3),(10358,41,5,'1996-11-20',1),(10359,72,5,'1996-11-21',3),(10360,7,4,'1996-11-22',3),(10361,63,1,'1996-11-22',2),(10362,9,3,'1996-11-25',1),(10363,17,4,'1996-11-26',3),(10364,19,1,'1996-11-26',1),(10365,3,3,'1996-11-27',2),(10366,29,8,'1996-11-28',2),(10367,83,7,'1996-11-28',3),(10368,20,2,'1996-11-29',2),(10369,75,8,'1996-12-02',2),(10370,14,6,'1996-12-03',2),(10371,41,1,'1996-12-03',1),(10372,62,5,'1996-12-04',2),(10373,37,4,'1996-12-05',3),(10374,91,1,'1996-12-05',3),(10375,36,3,'1996-12-06',2),(10376,51,1,'1996-12-09',2),(10377,72,1,'1996-12-09',3),(10378,24,5,'1996-12-10',3),(10379,61,2,'1996-12-11',1),(10380,37,8,'1996-12-12',3),(10381,46,3,'1996-12-12',3),(10382,20,4,'1996-12-13',1),(10383,4,8,'1996-12-16',3),(10384,5,3,'1996-12-16',3),(10385,75,1,'1996-12-17',2),(10386,21,9,'1996-12-18',3),(10387,70,1,'1996-12-18',2),(10388,72,2,'1996-12-19',1),(10389,10,4,'1996-12-20',2),(10390,20,6,'1996-12-23',1),(10391,17,3,'1996-12-23',3),(10392,59,2,'1996-12-24',3),(10393,71,1,'1996-12-25',3),(10394,36,1,'1996-12-25',3),(10395,35,6,'1996-12-26',1),(10396,25,1,'1996-12-27',3),(10397,60,5,'1996-12-27',1),(10398,71,2,'1996-12-30',3),(10399,83,8,'1996-12-31',3),(10400,19,1,'1997-01-01',3),(10401,65,1,'1997-01-01',1),(10402,20,8,'1997-01-02',2),(10403,20,4,'1997-01-03',3),(10404,49,2,'1997-01-03',1),(10405,47,1,'1997-01-06',1),(10406,62,7,'1997-01-07',1),(10407,56,2,'1997-01-07',2),(10408,23,8,'1997-01-08',1),(10409,54,3,'1997-01-09',1),(10410,10,3,'1997-01-10',3),(10411,10,9,'1997-01-10',3),(10412,87,8,'1997-01-13',2),(10413,41,3,'1997-01-14',2),(10414,21,2,'1997-01-14',3),(10415,36,3,'1997-01-15',1),(10416,87,8,'1997-01-16',3),(10417,73,4,'1997-01-16',3),(10418,63,4,'1997-01-17',1),(10419,68,4,'1997-01-20',2),(10420,88,3,'1997-01-21',1),(10421,61,8,'1997-01-21',1),(10422,27,2,'1997-01-22',1),(10423,31,6,'1997-01-23',3),(10424,51,7,'1997-01-23',2),(10425,41,6,'1997-01-24',2),(10426,29,4,'1997-01-27',1),(10427,59,4,'1997-01-27',2),(10428,66,7,'1997-01-28',1),(10429,37,3,'1997-01-29',2),(10430,20,4,'1997-01-30',1),(10431,10,4,'1997-01-30',2),(10432,75,3,'1997-01-31',2),(10433,60,3,'1997-02-03',3),(10434,24,3,'1997-02-03',2),(10435,16,8,'1997-02-04',2),(10436,7,3,'1997-02-05',2),(10437,87,8,'1997-02-05',1),(10438,79,3,'1997-02-06',2),(10439,51,6,'1997-02-07',3),(10440,71,4,'1997-02-10',2),(10441,55,3,'1997-02-10',2),(10442,20,3,'1997-02-11',2),(10443,66,8,'1997-02-12',1);
440/*!40000 ALTER TABLE `pedidos` ENABLE KEYS */;
441UNLOCK TABLES;
442
443--
444-- Table structure for table `productos`
445--
446
447DROP TABLE IF EXISTS `productos`;
448/*!40101 SET @saved_cs_client     = @@character_set_client */;
449/*!40101 SET character_set_client = utf8 */;
450CREATE TABLE `productos` (
451  `idProducto` int(11) NOT NULL AUTO_INCREMENT,
452  `nombre` varchar(255) NOT NULL,
453  `idProveedor` int(11) NOT NULL,
454  `idCategoria` int(11) NOT NULL,
455  `unidad` varchar(255) NOT NULL,
456  `precio` decimal(10,3) NOT NULL,
457  PRIMARY KEY (`idProducto`),
458  KEY `idCategoria` (`idCategoria`),
459  KEY `idProveedor` (`idProveedor`),
460  CONSTRAINT `productos_ibfk_1` FOREIGN KEY (`idCategoria`) REFERENCES `categorias` (`idCategoria`),
461  CONSTRAINT `productos_ibfk_2` FOREIGN KEY (`idProveedor`) REFERENCES `proveedores` (`idProveedor`)
462) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;
463/*!40101 SET character_set_client = @saved_cs_client */;
464
465--
466-- Dumping data for table `productos`
467--
468
469LOCK TABLES `productos` WRITE;
470/*!40000 ALTER TABLE `productos` DISABLE KEYS */;
471INSERT INTO `productos` VALUES (1,'Chais',1,1,'10 boxes x 20 bags',18.000),(2,'Chang',1,1,'24 - 12 oz bottles',19.000),(3,'Aniseed Syrup',1,2,'12 - 550 ml bottles',10.000),(4,'Chef Anton\'s Cajun Seasoning',2,2,'48 - 6 oz jars',22.000),(5,'Chef Anton\'s Gumbo Mix',2,2,'36 boxes',21.350),(6,'Grandma\'s Boysenberry Spread',3,2,'12 - 8 oz jars',25.000),(7,'Uncle Bob\'s Organic Dried Pears',3,7,'12 - 1 lb pkgs.',30.000),(8,'Northwoods Cranberry Sauce',3,2,'12 - 12 oz jars',40.000),(9,'Mishi Kobe Niku',4,6,'18 - 500 g pkgs.',97.000),(10,'Ikura',4,8,'12 - 200 ml jars',31.000),(11,'Queso Cabrales',5,4,'1 kg pkg.',21.000),(12,'Queso Manchego La Pastora',5,4,'10 - 500 g pkgs.',38.000),(13,'Konbu',6,8,'2 kg box',6.000),(14,'Tofu',6,7,'40 - 100 g pkgs.',23.250),(15,'Genen Shouyu',6,2,'24 - 250 ml bottles',15.500),(16,'Pavlova',7,3,'32 - 500 g boxes',17.450),(17,'Alice Mutton',7,6,'20 - 1 kg tins',39.000),(18,'Carnarvon Tigers',7,8,'16 kg pkg.',62.500),(19,'Teatime Chocolate Biscuits',8,3,'10 boxes x 12 pieces',9.200),(20,'Sir Rodney\'s Marmalade',8,3,'30 gift boxes',81.000),(21,'Sir Rodney\'s Scones',8,3,'24 pkgs. x 4 pieces',10.000),(22,'Gustaf\'s Knäckebröd',9,5,'24 - 500 g pkgs.',21.000),(23,'Tunnbröd',9,5,'12 - 250 g pkgs.',9.000),(24,'Guaraná Fantástica',10,1,'12 - 355 ml cans',4.500),(25,'NuNuCa Nuß-Nougat-Creme',11,3,'20 - 450 g glasses',14.000),(26,'Gumbär Gummibärchen',11,3,'100 - 250 g bags',31.230),(27,'Schoggi Schokolade',11,3,'100 - 100 g pieces',43.900),(28,'Rössle Sauerkraut',12,7,'25 - 825 g cans',45.600),(29,'Thüringer Rostbratwurst',12,6,'50 bags x 30 sausgs.',123.790),(30,'Nord-Ost Matjeshering',13,8,'10 - 200 g glasses',25.890),(31,'Gorgonzola Telino',14,4,'12 - 100 g pkgs',12.500),(32,'Mascarpone Fabioli',14,4,'24 - 200 g pkgs.',32.000),(33,'Geitost',15,4,'500 g',2.500),(34,'Sasquatch Ale',16,1,'24 - 12 oz bottles',14.000),(35,'Steeleye Stout',16,1,'24 - 12 oz bottles',18.000),(36,'Inlagd Sill',17,8,'24 - 250 g jars',19.000),(37,'Gravad lax',17,8,'12 - 500 g pkgs.',26.000),(38,'Côte de Blaye',18,1,'12 - 75 cl bottles',263.500),(39,'Chartreuse verte',18,1,'750 cc per bottle',18.000),(40,'Boston Crab Meat',19,8,'24 - 4 oz tins',18.400),(41,'Jack\'s New England Clam Chowder',19,8,'12 - 12 oz cans',9.650),(42,'Singaporean Hokkien Fried Mee',20,5,'32 - 1 kg pkgs.',14.000),(43,'Ipoh Coffee',20,1,'16 - 500 g tins',46.000),(44,'Gula Malacca',20,2,'20 - 2 kg bags',19.450),(45,'Røgede sild',21,8,'1k pkg.',9.500),(46,'Spegesild',21,8,'4 - 450 g glasses',12.000),(47,'Zaanse koeken',22,3,'10 - 4 oz boxes',9.500),(48,'Chocolade',22,3,'10 pkgs.',12.750),(49,'Maxilaku',23,3,'24 - 50 g pkgs.',20.000),(50,'Valkoinen suklaa',23,3,'12 - 100 g bars',16.250),(51,'Manjimup Dried Apples',24,7,'50 - 300 g pkgs.',53.000),(52,'Filo Mix',24,5,'16 - 2 kg boxes',7.000),(53,'Perth Pasties',24,6,'48 pieces',32.800),(54,'Tourtière',25,6,'16 pies',7.450),(55,'Pâté chinois',25,6,'24 boxes x 2 pies',24.000),(56,'Gnocchi di nonna Alice',26,5,'24 - 250 g pkgs.',38.000),(57,'Ravioli Angelo',26,5,'24 - 250 g pkgs.',19.500),(58,'Escargots de Bourgogne',27,8,'24 pieces',13.250),(59,'Raclette Courdavault',28,4,'5 kg pkg.',55.000),(60,'Camembert Pierrot',28,4,'15 - 300 g rounds',34.000),(61,'Sirop d\'érable',29,2,'24 - 500 ml bottles',28.500),(62,'Tarte au sucre',29,3,'48 pies',49.300),(63,'Vegie-spread',7,2,'15 - 625 g jars',43.900),(64,'Wimmers gute Semmelknödel',12,5,'20 bags x 4 pieces',33.250),(65,'Louisiana Fiery Hot Pepper Sauce',2,2,'32 - 8 oz bottles',21.050),(66,'Louisiana Hot Spiced Okra',2,2,'24 - 8 oz jars',17.000),(67,'Laughing Lumberjack Lager',16,1,'24 - 12 oz bottles',14.000),(68,'Scottish Longbreads',8,3,'10 boxes x 8 pieces',12.500),(69,'Gudbrandsdalsost',15,4,'10 kg pkg.',36.000),(70,'Outback Lager',7,1,'24 - 355 ml bottles',15.000),(71,'Fløtemysost',15,4,'10 - 500 g pkgs.',21.500),(72,'Mozzarella di Giovanni',14,4,'24 - 200 g pkgs.',34.800),(73,'Röd Kaviar',17,8,'24 - 150 g jars',15.000),(74,'Longlife Tofu',4,7,'5 kg pkg.',10.000),(75,'Rhönbräu Klosterbier',12,1,'24 - 0.5 l bottles',7.750),(76,'Lakkalikööri',23,1,'500 ml',18.000),(77,'Original Frankfurter grüne Soße',12,2,'12 boxes',13.000);
472/*!40000 ALTER TABLE `productos` ENABLE KEYS */;
473UNLOCK TABLES;
474
475--
476-- Table structure for table `proveedores`
477--
478
479DROP TABLE IF EXISTS `proveedores`;
480/*!40101 SET @saved_cs_client     = @@character_set_client */;
481/*!40101 SET character_set_client = utf8 */;
482CREATE TABLE `proveedores` (
483  `idProveedor` int(11) NOT NULL AUTO_INCREMENT,
484  `nombre` varchar(255) NOT NULL,
485  `nombreContacto` varchar(255) DEFAULT NULL,
486  `direccion` varchar(255) DEFAULT NULL,
487  `ciudad` varchar(255) DEFAULT NULL,
488  `codigoPostal` varchar(255) DEFAULT NULL,
489  `codigoPais` varchar(3) DEFAULT NULL,
490  `telefono` varchar(255) DEFAULT NULL,
491  unique index (`nombre`),
492  PRIMARY KEY (`idProveedor`),
493  foreign key (codigoPais) references paises(codigoPais) on update cascade on delete restrict
494) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
495/*!40101 SET character_set_client = @saved_cs_client */;
496
497--
498-- Dumping data for table `proveedores`
499--
500
501LOCK TABLES `proveedores` WRITE;
502/*!40000 ALTER TABLE `proveedores` DISABLE KEYS */;
503INSERT INTO `proveedores` VALUES (1,'Exotic Liquid','Charlotte Cooper','49 Gilbert St.','Londona','EC1 4SD','UK','(171) 555-2222'),(2,'New Orleans Cajun Delights','Shelley Burke','P.O. Box 78934','New Orleans','70117','USA','(100) 555-4822'),(3,'Grandma Kelly\'s Homestead','Regina Murphy','707 Oxford Rd.','Ann Arbor','48104','USA','(313) 555-5735'),(4,'Tokyo Traders','Yoshi Nagase','9-8 Sekimai Musashino-shi','Tokyo','100','Jap','(03) 3555-5011'),(5,'Cooperativa de Quesos \'Las Cabras\'','Antonio del Valle Saavedra','Calle del Rosal 4','Oviedo','33007','Spa','(98) 598 76 54'),(6,'Mayumi\'s','Mayumi Ohno','92 Setsuko Chuo-ku','Osaka','545','Jap','(06) 431-7877'),(7,'Pavlova, Ltd.','Ian Devling','74 Rose St. Moonie Ponds','Melbourne','3058','Aus','(03) 444-2343'),(8,'Specialty Biscuits, Ltd.','Peter Wilson','29 King\'s Way','Manchester','M14 GSD','UK','(161) 555-4448'),(9,'PB Knäckebröd AB','Lars Peterson','Kaloadagatan 13','Göteborg','S-345 67','Swe','031-987 65 43'),(10,'Refrescos Americanas LTDA','Carlos Diaz','Av. das Americanas 12.890','São Paulo','5442','Bra','(11) 555 4640'),(11,'Heli Süßwaren GmbH & Co. KG','Petra Winkler','Tiergartenstraße 5','Berlin','10785','Ger','(010) 9984510'),(12,'Plutzer Lebensmittelgroßmärkte AG','Martin Bein','Bogenallee 51','Frankfurt','60439','Ger','(069) 992755'),(13,'Nord-Ost-Fisch Handelsgesellschaft mbH','Sven Petersen','Frahmredder 112a','Cuxhaven','27478','Ger','(04721) 8713'),(14,'Formaggi Fortini s.r.l.','Elio Rossi','Viale Dante, 75','Ravenna','48100','Ita','(0544) 60323'),(15,'Norske Meierier','Beate Vileid','Hatlevegen 5','Sandvika','1320','Nor','(0)2-953010'),(16,'Bigfoot Breweries','Cheryl Saylor','3400 - 8th Avenue Suite 210','Bend','97101','USA','(503) 555-9931'),(17,'Svensk Sjöföda AB','Michael Björn','Brovallavägen 231','Sto','S-123 45','Sweden','08-123 45 67'),(18,'Aux joyeux ecclésiastiques','Guylène Nodier','203, Rue des Francs-Bourgeois','Paris','75004','Fra','(1) 03.83.00.68'),(19,'New England Seafood Cannery','Robb Merchant','Order Processing Dept. 2100 Paul Revere Blvd.','Boston','02134','USA','(617) 555-3267'),(20,'Leka Trading','Chandra Leka','471 Serangoon Loop, Suite #402','Singapore','0512','Sin','555-8787'),(21,'Lyngbysild','Niels Petersen','Lyngbysild Fiskebakken 10','Lyngby','2800','Den','43844108'),(22,'Zaanse Snoepfabriek','Dirk Luchte','Verkoop Rijnweg 22','Zaandam','9999 ZZ','Net','(12345) 1212'),(23,'Karkki Oy','Anne Heikkonen','Valtakatu 12','Lappeenranta','53120','Fin','(953) 10956'),(24,'G\'day, Mate','Wendy Mackenzie','170 Prince Edward Parade Hunter\'s Hill','Sydney','2042','Aus','(02) 555-5914'),(25,'Ma Maison','Jean-Guy Lauzon','2960 Rue St. Laurent','Montréal','H1J 1C3','Can','(514) 555-9022'),(26,'Pasta Buttini s.r.l.','Giovanni Giudici','Via dei Gelsomini, 153','Salerno','84100','Ita','(089) 6547665'),(27,'Escargots Nouveaux','Marie Delamare','22, rue H. Voiron','Montceau','71300','Fra','85.57.00.07'),(28,'Gai pâturage','Eliane Noz','Bat. B 3, rue des Alpes','Annecy','74000','Fra','38.76.98.06'),(29,'Forêts d\'érables','Chantal Goulet','148 rue Chasseur','Ste-Hyacinthe','J2S 7S8','Can','(514) 555-2955');
504/*!40000 ALTER TABLE `proveedores` ENABLE KEYS */;
505UNLOCK TABLES;
506/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
507
508/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
509/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
510/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
511/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
512/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
513/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
514/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
515
516-- Dump completed on 2019-03-20 13:43:09
517tiendaVirtual_alumno.sql
518Mostrando tiendaVirtual_alumno.sql.