-- --------------------------------------------------------

-- Host: [Link]
-- Versión del servidor: 9.0.1 - MySQL Community Server - GPL
-- SO del servidor: Linux
-- HeidiSQL Versión: 12.1.0.6537
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

-- Volcando estructura de base de datos para railway

CREATE DATABASE IF NOT EXISTS `railway` /*!40100 DEFAULT CHARACTER SET utf8mb4
COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `railway`;

-- Volcando estructura para tabla [Link]

CREATE TABLE IF NOT EXISTS `Categories` (
`CategoryID` int NOT NULL AUTO_INCREMENT,
`CategoryName` varchar(100) NOT NULL,
`Description` text,
PRIMARY KEY (`CategoryID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

-- Volcando datos para la tabla [Link]: ~8 rows (aproximadamente)

DELETE FROM `Categories`;
INSERT INTO `Categories` (`CategoryID`, `CategoryName`, `Description`) 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 Products', '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');

-- Volcando estructura para tabla [Link]

CREATE TABLE IF NOT EXISTS `customers` (
`CustomerID` int NOT NULL AUTO_INCREMENT,
`CustomerName` varchar(100) NOT NULL,
`ContactName` varchar(100) DEFAULT NULL,
`Address` varchar(255) DEFAULT NULL,
`City` varchar(100) DEFAULT NULL,
`PostalCode` varchar(20) DEFAULT NULL,
`Country` varchar(100) DEFAULT NULL,
PRIMARY KEY (`CustomerID`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

-- Volcando datos para la tabla [Link]: ~91 rows (aproximadamente)

DELETE FROM `customers`;
INSERT INTO `customers` (`CustomerID`, `CustomerName`, `ContactName`, `Address`,
`City`, `PostalCode`, `Country`) VALUES
(1, 'Alfreds Futterkiste ', 'Maria Anders ', 'Obere Str. 57 ', 'Berlin ',
'12209 ', 'Germany '),
(2, 'Ana Trujillo Emparedados y helados ', 'Ana Trujillo ', 'Avda. de la
Constitución 2222 ', 'México D.F. ', '05021 ', 'Mexico '),
(3, 'Antonio Moreno Taquería ', 'Antonio Moreno ', 'Mataderos 2312 ', 'México
D.F. ', '05023 ', 'Mexico '),
(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 ', 'Sweden '),
(6, 'Blauer See Delikatessen ', 'Hanna Moos ', 'Forsterstr. 57 ',
'Mannheim ', '68306 ', 'Germany '),
(7, 'Blondel père et fils ', 'Frédérique Citeaux ', '24, place Kléber ',
'Strasbourg ', '67000 ', 'France '),
(8, 'Bólido Comidas preparadas ', 'Martín Sommer ', 'C/ Araquil, 67 ',
'Madrid ', '28023 ', 'Spain '),
(9, 'Bon app\' ', 'Laurence Lebihans ', '12, rue des Bouchers ',
'Marseille ', '13008 ', 'France '),
(10, 'Bottom-Dollar Marketse ', 'Elizabeth Lincoln ', '23 Tsawassen Blvd. ',
'Tsawassen ', 'T2F 8M4 ', 'Canada '),
(11, 'B\'s Beverages ', 'Victoria Ashworth ', 'Fauntleroy Circus ',
'London ', 'EC2 5NT ', 'UK '),
(12, 'Cactus Comidas para llevar ', 'Patricio Simpson ', 'Cerrito 333 ',
'Buenos Aires ', '1010 ', 'Argentina '),
(13, 'Centro comercial Moctezuma ', 'Francisco Chang ', 'Sierras de Granada
9993 ', 'México D.F. ', '05022 ', 'Mexico '),
(14, 'Chop-suey Chinese ', 'Yang Wang ', 'Hauptstr. 29 ', 'Bern ', '3012 ',
'Switzerland '),
(15, 'Comércio Mineiro ', 'Pedro Afonso ', 'Av. dos Lusíadas, 23 ', 'São
Paulo ', '05432-043 ', 'Brazil '),
(16, 'Consolidated Holdings ', 'Elizabeth Brown ', 'Berkeley Gardens 12
Brewery ', 'London ', 'WX1 6LT ', 'UK '),
(17, 'Drachenblut Delikatessend ', 'Sven Ottlieb ', 'Walserweg 21 ',
'Aachen ', '52066 ', 'Germany '),
(18, 'Du monde entier ', 'Janine Labrune ', '67, rue des Cinquante Otages ',
'Nantes ', '44000 ', 'France '),
(19, 'Eastern Connection ', 'Ann Devon ', '35 King George ', 'London ', 'WX3
6FW ', 'UK '),
(20, 'Ernst Handel ', 'Roland Mendel ', 'Kirchgasse 6 ', 'Graz ', '8010 ',
'Austria '),
(21, 'Familia Arquibaldo ', 'Aria Cruz ', 'Rua Orós, 92 ', 'São Paulo ',
'05442-030 ', 'Brazil '),
(22, 'FISSA Fabrica Inter. Salchichas S.A. ', 'Diego Roel ', 'C/ Moralzarzal,
86 ', 'Madrid ', '28034 ', 'Spain '),
(23, 'Folies gourmandes ', 'Martine Rancé ', '184, chaussée de Tournai ',
'Lille ', '59000 ', 'France '),
(24, 'Folk och fä HB ', 'Maria Larsson ', 'Åkergatan 24 ', 'Bräcke ', 'S-844
67 ', 'Sweden '),
(25, 'Frankenversand ', 'Peter Franken ', 'Berliner Platz 43 ', 'München ',
'80805 ', 'Germany '),
(26, 'France restauration ', 'Carine Schmitt ', '54, rue Royale ', 'Nantes ',
'44000 ', 'France '),
(27, 'Franchi S.p.A. ', 'Paolo Accorti ', 'Via Monte Bianco 34 ', 'Torino ',
'10100 ', 'Italy '),
(28, 'Furia Bacalhau e Frutos do Mar ', 'Lino Rodriguez ', 'Jardim das rosas
n. 32 ', 'Lisboa ', '1675 ', 'Portugal '),
(29, 'Galería del gastrónomo ', 'Eduardo Saavedra ', 'Rambla de Cataluña,
23 ', 'Barcelona ', '08022 ', 'Spain '),
(30, 'Godos Cocina Típica ', 'José Pedro Freyre ', 'C/ Romero, 33 ',
'Sevilla ', '41101 ', 'Spain '),
(31, 'Gourmet Lanchonetes ', 'André Fonseca ', 'Av. Brasil, 442 ',
'Campinas ', '04876-786 ', 'Brazil '),
(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 ', 'Venezuela '),
(34, 'Hanari Carnes ', 'Mario Pontes ', 'Rua do Paço, 67 ', 'Rio de
Janeiro ', '05454-876 ', 'Brazil '),
(35, 'HILARIÓN-Abastos ', 'Carlos Hernández ', 'Carrera 22 con Ave. Carlos
Soublette #8-35 ', 'San Cristóbal ', '5022 ', 'Venezuela '),
(36, 'Hungry Coyote Import Store ', 'Yoshi Latimer ', 'City Center Plaza 516
Main St. ', 'Elgin ', '97827 ', 'USA '),
(37, 'Hungry Owl All-Night Grocers ', 'Patricia McKenna ', '8 Johnstown
Road ', 'Cork ', '', 'Ireland '),
(38, 'Island Trading ', 'Helen Bennett ', 'Garden House Crowther Way ',
'Cowes ', 'PO31 7PJ ', 'UK '),
(39, 'Königlich Essen ', 'Philip Cramer ', 'Maubelstr. 90 ', 'Brandenburg ',
'14776 ', 'Germany '),
(40, 'La corne d\'abondance ', 'Daniel Tonini ', '67, avenue de l\'Europe ',
'Versailles ', '78000 ', 'France '),
(41, 'La maison d\'Asie ', 'Annette Roulet ', '1 rue Alsace-Lorraine ',
'Toulouse ', '31000 ', 'France '),
(42, 'Laughing Bacchus Wine Cellars ', 'Yoshi Tannamuri ', '1900 Oak St. ',
'Vancouver ', 'V3F 2K1 ', 'Canada '),
(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 ', 'Germany '),
(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 ', 'Venezuela '),
(47, 'LINO-Delicateses ', 'Felipe Izquierdo ', 'Ave. 5 de Mayo Porlamar ',
'I. de Margarita ', '4980 ', 'Venezuela '),
(48, 'Lonesome Pine Restaurant ', 'Fran Wilson ', '89 Chiaroscuro Rd. ',
'Portland ', '97219 ', 'USA '),
(49, 'Magazzini Alimentari Riuniti ', 'Giovanni Rovelli ', 'Via Ludovico il
Moro 22 ', 'Bergamo ', '24100 ', 'Italy '),
(50, 'Maison Dewey ', 'Catherine Dewey ', 'Rue Joseph-Bens 532 ',
'Bruxelles ', 'B-1180 ', 'Belgium '),
(51, 'Mère Paillarde ', 'Jean Fresnière ', '43 rue St. Laurent ',
'Montréal ', 'H1J 1C3 ', 'Canada '),
(52, 'Morgenstern Gesundkost ', 'Alexander Feuer ', 'Heerstr. 22 ',
'Leipzig ', '04179 ', 'Germany '),
(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 ', 'Argentina '),
(55, 'Old World Delicatessen ', 'Rene Phillips ', '2743 Bering St. ',
'Anchorage ', '99508 ', 'USA '),
(56, 'Ottilies Käseladen ', 'Henriette Pfalzheim ', 'Mehrheimerstr. 369 ',
'Köln ', '50739 ', 'Germany '),
(57, 'Paris spécialités ', 'Marie Bertrand ', '265, boulevard Charonne ',
'Paris ', '75012 ', 'France '),
(58, 'Pericles Comidas clásicas ', 'Guillermo Fernández ', 'Calle Dr. Jorge
Cash 321 ', 'México D.F. ', '05033 ', 'Mexico '),
 (59, 'Piccolo und mehr ', 'Georg Pipps ', 'Geislweg 14 ', 'Salzburg ',
'5020 ', 'Austria '),
(60, 'Princesa Isabel Vinhoss ', 'Isabel de Castro ', 'Estrada da saúde n.
58 ', 'Lisboa ', '1756 ', 'Portugal '),
(61, 'Que Delícia ', 'Bernardo Batista ', 'Rua da Panificadora, 12 ', 'Rio de
Janeiro ', '02389-673 ', 'Brazil '),
(62, 'Queen Cozinha ', 'Lúcia Carvalho ', 'Alameda dos Canàrios, 891 ', 'São
Paulo ', '05487-020 ', 'Brazil '),
(63, 'QUICK-Stop ', 'Horst Kloss ', 'Taucherstraße 10 ', 'Cunewalde ',
'01307 ', 'Germany '),
(64, 'Rancho grande ', 'Sergio Gutiérrez ', 'Av. del Libertador 900 ',
'Buenos Aires ', '1010 ', 'Argentina '),
(65, 'Rattlesnake Canyon Grocery ', 'Paula Wilson ', '2817 Milton Dr. ',
'Albuquerque ', '87110 ', 'USA '),
(66, 'Reggiani Caseifici ', 'Maurizio Moroni ', 'Strada Provinciale 124 ',
'Reggio Emilia ', '42100 ', 'Italy '),
(67, 'Ricardo Adocicados ', 'Janete Limeira ', 'Av. Copacabana, 267 ', 'Rio
de Janeiro ', '02389-890 ', 'Brazil '),
(68, 'Richter Supermarkt ', 'Michael Holz ', 'Grenzacherweg 237 ', 'Genève ',
'1203 ', 'Switzerland '),
(69, 'Romero y tomillo ', 'Alejandra Camino ', 'Gran Vía, 1 ', 'Madrid ',
'28001 ', 'Spain '),
(70, 'Santé Gourmet ', 'Jonas Bergulfsen ', 'Erling Skakkes gate 78 ',
'Stavern ', '4110 ', 'Norway '),
(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 ', 'Denmark '),
(74, 'Spécialités du monde ', 'Dominique Perrier ', '25, rue Lauriston ',
'Paris ', '75016 ', 'France '),
(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 ', 'Belgium '),
(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 ', 'Germany '),
(80, 'Tortuga Restaurante ', 'Miguel Angel Paolino ', 'Avda. Azteca 123 ',
'México D.F. ', '05033 ', 'Mexico '),
(81, 'Tradição Hipermercados ', 'Anabela Domingues ', 'Av. Inês de Castro,
414 ', 'São Paulo ', '05634-030 ', 'Brazil '),
(82, 'Trail\'s Head Gourmet Provisioners ', 'Helvetius Nagy ', '722 DaVinci
Blvd. ', 'Kirkland ', '98034 ', 'USA '),
(83, 'Vaffeljernet ', 'Palle Ibsen ', 'Smagsløget 45 ', 'Århus ', '8200 ',
'Denmark '),
(84, 'Victuailles en stock ', 'Mary Saveley ', '2, rue du Commerce ',
'Lyon ', '69004 ', 'France '),
(85, 'Vins et alcools Chevalier ', 'Paul Henriot ', '59 rue de l\'Abbaye ',
'Reims ', '51100 ', 'France '),
(86, 'Die Wandernde Kuh ', 'Rita Müller ', 'Adenauerallee 900 ',
'Stuttgart ', '70563 ', 'Germany '),
(87, 'Wartian Herkku ', 'Pirkko Koskitalo ', 'Torikatu 38 ', 'Oulu ',
'90110 ', 'Finland '),
(88, 'Wellington Importadora ', 'Paula Parente ', 'Rua do Mercado, 12 ',
'Resende ', '08737-363 ', 'Brazil '),
(89, 'White Clover Markets ', 'Karl Jablonski ', '305 - 14th Ave. S. Suite
3B ', 'Seattle ', '98128 ', 'USA '),
(90, 'Wilman Kala ', 'Matti Karttunen ', 'Keskuskatu 45 ', 'Helsinki ',
'21240 ', 'Finland '),
(91, 'Wolski ', 'Zbyszek ', 'ul. Filtrowa 68 ', 'Walla ', '01-012 ',
'Poland ');

-- Volcando estructura para tabla [Link]

CREATE TABLE IF NOT EXISTS `Employees` (
`EmployeeID` int NOT NULL AUTO_INCREMENT,
`LastName` varchar(50) NOT NULL,
`FirstName` varchar(50) NOT NULL,
`BirthDate` date DEFAULT NULL,
`Photo` varchar(100) DEFAULT NULL,
`Notes` text,
PRIMARY KEY (`EmployeeID`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

-- Volcando datos para la tabla [Link]: ~10 rows (aproximadamente)

DELETE FROM `Employees`;
INSERT INTO `Employees` (`EmployeeID`, `LastName`, `FirstName`, `BirthDate`,
`Photo`, `Notes`) VALUES
(1, 'Davolio', 'Nancy', '1968-12-08', '[Link]', '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'),
(2, 'Fuller ', 'Andrew ', '1952-02-19', '[Link] ', '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. '),
(3, 'Leverling ', 'Janet ', '1963-08-30', '[Link] ', '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. '),
(4, 'Peacock ', 'Margaret ', '1958-09-19', '[Link] ', '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. '),
(5, 'Buchanan ', 'Steven ', '1955-03-04', '[Link] ', '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, 'Suyama ', 'Michael ', '1963-07-02', '[Link] ', '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. '),
(7, 'King ', 'Robert ', '1960-05-29', '[Link] ', '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. '),
(8, 'Callahan ', 'Laura ', '1958-01-09', '[Link] ', '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. '),
 (9, 'Dodsworth ', 'Anne ', '1969-07-02', '[Link] ', 'Anne has a BA degree
in English from St. Lawrence College. She is fluent in French and German. '),
(10, 'West ', 'Adam ', '1928-09-19', '[Link] ', 'An old chum ');

-- Volcando estructura para tabla [Link]

CREATE TABLE IF NOT EXISTS `OrderDetails` (
`OrderDetailID` int NOT NULL AUTO_INCREMENT,
`OrderID` int NOT NULL,
`ProductID` int NOT NULL,
`Quantity` int NOT NULL,
PRIMARY KEY (`OrderDetailID`),
KEY `OrderDetails_ibfk_1` (`OrderID`),
KEY `OrderDetails_ibfk_2` (`ProductID`),
CONSTRAINT `order_details_ibfk_1` FOREIGN KEY (`OrderID`) REFERENCES `Orders`
(`OrderID`),
CONSTRAINT `order_details_ibfk_2` FOREIGN KEY (`ProductID`) REFERENCES `Products`
(`ProductID`),
CONSTRAINT `OrderDetails_ibfk_1` FOREIGN KEY (`OrderID`) REFERENCES `Orders`
(`OrderID`),
CONSTRAINT `OrderDetails_ibfk_2` FOREIGN KEY (`ProductID`) REFERENCES `Products`
(`ProductID`)
) ENGINE=InnoDB AUTO_INCREMENT=1025 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

-- Volcando datos para la tabla [Link]: ~518 rows (aproximadamente)

DELETE FROM `OrderDetails`;
INSERT INTO `OrderDetails` (`OrderDetailID`, `OrderID`, `ProductID`, `Quantity`)
VALUES
(2, 10248, 11, 12),
(3, 10248, 42, 10),
(4, 10248, 72, 5),
(5, 10249, 14, 9),
(6, 10249, 51, 40),
(7, 10250, 41, 10),
(8, 10250, 51, 35),
(9, 10250, 65, 15),
(10, 10251, 22, 6),
(11, 10251, 57, 15),
(12, 10251, 65, 20),
(13, 10252, 20, 40),
(14, 10252, 33, 25),
(15, 10252, 60, 40),
(16, 10253, 31, 20),
(17, 10253, 39, 42),
(18, 10253, 49, 40),
(19, 10254, 24, 15),
(20, 10254, 55, 21),
(21, 10254, 74, 21),
(22, 10255, 2, 20),
(23, 10255, 16, 35),
(24, 10255, 36, 25),
(25, 10255, 59, 30),
(26, 10256, 53, 15),
(27, 10256, 77, 12),
(28, 10257, 27, 25),
(29, 10257, 39, 6),
(30, 10257, 77, 15),
(31, 10258, 2, 50),
(32, 10258, 5, 65),
(33, 10258, 32, 6),
(34, 10259, 21, 10),
(35, 10259, 37, 1),
(36, 10260, 41, 16),
(37, 10260, 57, 50),
(38, 10260, 62, 15),
(39, 10260, 70, 21),
(40, 10261, 21, 20),
(41, 10261, 35, 20),
(42, 10262, 5, 12),
(43, 10262, 7, 15),
(44, 10262, 56, 2),
(45, 10263, 16, 60),
(46, 10263, 24, 28),
(47, 10263, 30, 60),
(48, 10263, 74, 36),
(49, 10264, 2, 35),
(50, 10264, 41, 25),
(51, 10265, 17, 30),
(52, 10265, 70, 20),
(53, 10266, 12, 12),
(54, 10267, 40, 50),
(55, 10267, 59, 70),
(56, 10267, 76, 15),
(57, 10268, 29, 10),
(58, 10268, 72, 4),
(59, 10269, 33, 60),
(60, 10269, 72, 20),
(61, 10270, 36, 30),
(62, 10270, 43, 25),
(63, 10271, 33, 24),
(64, 10272, 20, 6),
(65, 10272, 31, 40),
(66, 10272, 72, 24),
(67, 10273, 10, 24),
(68, 10273, 31, 15),
(69, 10273, 33, 20),
(70, 10273, 40, 60),
(71, 10273, 76, 33),
(72, 10274, 71, 20),
(73, 10274, 72, 7),
(74, 10275, 24, 12),
(75, 10275, 59, 6),
(76, 10276, 10, 15),
(77, 10276, 13, 10),
(78, 10277, 28, 20),
(79, 10277, 62, 12),
(80, 10278, 44, 16),
(81, 10278, 59, 15),
(82, 10278, 63, 8),
(83, 10278, 73, 25),
(84, 10279, 17, 15),
(85, 10280, 24, 12),
(86, 10280, 55, 20),
(87, 10280, 75, 30),
(88, 10281, 19, 1),
(89, 10281, 24, 6),
(90, 10281, 35, 4),
(91, 10282, 30, 6),
(92, 10282, 57, 2),
(93, 10283, 15, 20),
(94, 10283, 19, 18),
(95, 10283, 60, 35),
(96, 10283, 72, 3),
(97, 10284, 27, 15),
(98, 10284, 44, 21),
(99, 10284, 60, 20),
(100, 10284, 67, 5),
(101, 10285, 1, 45),
(102, 10285, 40, 40),
(103, 10285, 53, 36),
(104, 10286, 35, 100),
(105, 10286, 62, 40),
(106, 10287, 16, 40),
(107, 10287, 34, 20),
(108, 10287, 46, 15),
(109, 10288, 54, 10),
(110, 10288, 68, 3),
(111, 10289, 3, 30),
(112, 10289, 64, 9),
(113, 10290, 5, 20),
(114, 10290, 29, 15),
(115, 10290, 49, 15),
(116, 10290, 77, 10),
(117, 10291, 13, 20),
(118, 10291, 44, 24),
(119, 10291, 51, 2),
(120, 10292, 20, 20),
(121, 10293, 18, 12),
(122, 10293, 24, 10),
(123, 10293, 63, 5),
(124, 10293, 75, 6),
(125, 10294, 1, 18),
(126, 10294, 17, 15),
(127, 10294, 43, 15),
(128, 10294, 60, 21),
(129, 10294, 75, 6),
(130, 10295, 56, 4),
(131, 10296, 11, 12),
(132, 10296, 16, 30),
(133, 10296, 69, 15),
(134, 10297, 39, 60),
(135, 10297, 72, 20),
(136, 10298, 2, 40),
(137, 10298, 36, 40),
(138, 10298, 59, 30),
(139, 10298, 62, 15),
(140, 10299, 19, 15),
(141, 10299, 70, 20),
(142, 10300, 66, 30),
(143, 10300, 68, 20),
(144, 10301, 40, 10),
(145, 10301, 56, 20),
(146, 10302, 17, 40),
(147, 10302, 28, 28),
(148, 10302, 43, 12),
(149, 10303, 40, 40),
(150, 10303, 65, 30),
(151, 10303, 68, 15),
(152, 10304, 49, 30),
(153, 10304, 59, 10),
(154, 10304, 71, 2),
(155, 10305, 18, 25),
(156, 10305, 29, 25),
(157, 10305, 39, 30),
(158, 10306, 30, 10),
(159, 10306, 53, 10),
(160, 10306, 54, 5),
(161, 10307, 62, 10),
(162, 10307, 68, 3),
(163, 10308, 69, 1),
(164, 10308, 70, 5),
(165, 10309, 4, 20),
(166, 10309, 6, 30),
(167, 10309, 42, 2),
(168, 10309, 43, 20),
(169, 10309, 71, 3),
(170, 10310, 16, 10),
(171, 10310, 62, 5),
(172, 10311, 42, 6),
(173, 10311, 69, 7),
(174, 10312, 28, 4),
(175, 10312, 43, 24),
(176, 10312, 53, 20),
(177, 10312, 75, 10),
(178, 10313, 36, 12),
(179, 10314, 32, 40),
(180, 10314, 58, 30),
(181, 10314, 62, 25),
(182, 10315, 34, 14),
(183, 10315, 70, 30),
(184, 10316, 41, 10),
(185, 10316, 62, 70),
(186, 10317, 1, 20),
(187, 10318, 41, 20),
(188, 10318, 76, 6),
(189, 10319, 17, 8),
(190, 10319, 28, 14),
(191, 10319, 76, 30),
(192, 10320, 71, 30),
(193, 10321, 35, 10),
(194, 10322, 52, 20),
(195, 10323, 15, 5),
(196, 10323, 25, 4),
(197, 10323, 39, 4),
(198, 10324, 16, 21),
(199, 10324, 35, 70),
(200, 10324, 46, 30),
(201, 10324, 59, 40),
(202, 10324, 63, 80),
(203, 10325, 6, 6),
(204, 10325, 13, 12),
(205, 10325, 14, 9),
(206, 10325, 31, 4),
(207, 10325, 72, 40),
(208, 10326, 4, 24),
(209, 10326, 57, 16),
(210, 10326, 75, 50),
(211, 10327, 2, 25),
(212, 10327, 11, 50),
(213, 10327, 30, 35),
(214, 10327, 58, 30),
(215, 10328, 59, 9),
(216, 10328, 65, 40),
(217, 10328, 68, 10),
(218, 10329, 19, 10),
(219, 10329, 30, 8),
(220, 10329, 38, 20),
(221, 10329, 56, 12),
(222, 10330, 26, 50),
(223, 10330, 72, 25),
(224, 10331, 54, 15),
(225, 10332, 18, 40),
(226, 10332, 42, 10),
(227, 10332, 47, 16),
(228, 10333, 14, 10),
(229, 10333, 21, 10),
(230, 10333, 71, 40),
(231, 10334, 52, 8),
(232, 10334, 68, 10),
(233, 10335, 2, 7),
(234, 10335, 31, 25),
(235, 10335, 32, 6),
(236, 10335, 51, 48),
(237, 10336, 4, 18),
(238, 10337, 23, 40),
(239, 10337, 26, 24),
(240, 10337, 36, 20),
(241, 10337, 37, 28),
(242, 10337, 72, 25),
(243, 10338, 17, 20),
(244, 10338, 30, 15),
(245, 10339, 4, 10),
(246, 10339, 17, 70),
(247, 10339, 62, 28),
(248, 10340, 18, 20),
(249, 10340, 41, 12),
(250, 10340, 43, 40),
(251, 10341, 33, 8),
(252, 10341, 59, 9),
(253, 10342, 2, 24),
(254, 10342, 31, 56),
(255, 10342, 36, 40),
(256, 10342, 55, 40),
(257, 10343, 64, 50),
(258, 10343, 68, 4),
(259, 10343, 76, 15),
(260, 10344, 4, 35),
(261, 10344, 8, 70),
(262, 10345, 8, 70),
(263, 10345, 19, 80),
(264, 10345, 42, 9),
(265, 10346, 17, 36),
(266, 10346, 56, 20),
(267, 10347, 25, 10),
(268, 10347, 39, 50),
(269, 10347, 40, 4),
(270, 10347, 75, 6),
(271, 10348, 1, 15),
(272, 10348, 23, 25),
(273, 10349, 54, 24),
(274, 10350, 50, 15),
(275, 10350, 69, 18),
(276, 10351, 38, 20),
(277, 10351, 41, 13),
(278, 10351, 44, 77),
(279, 10351, 65, 10),
(280, 10352, 24, 10),
(281, 10352, 54, 20),
(282, 10353, 11, 12),
(283, 10353, 38, 50),
(284, 10354, 1, 12),
(285, 10354, 29, 4),
(286, 10355, 24, 25),
(287, 10355, 57, 25),
(288, 10356, 31, 30),
(289, 10356, 55, 12),
(290, 10356, 69, 20),
(291, 10357, 10, 30),
(292, 10357, 26, 16),
(293, 10357, 60, 8),
(294, 10358, 24, 10),
(295, 10358, 34, 10),
(296, 10358, 36, 20),
(297, 10359, 16, 56),
(298, 10359, 31, 70),
(299, 10359, 60, 80),
(300, 10360, 28, 30),
(301, 10360, 29, 35),
(302, 10360, 38, 10),
(303, 10360, 49, 35),
(304, 10360, 54, 28),
(305, 10361, 39, 54),
(306, 10361, 60, 55),
(307, 10362, 25, 50),
(308, 10362, 51, 20),
(309, 10362, 54, 24),
(310, 10363, 31, 20),
(311, 10363, 75, 12),
(312, 10363, 76, 12),
(313, 10364, 69, 30),
(314, 10364, 71, 5),
(315, 10365, 11, 24),
(316, 10366, 65, 5),
(317, 10366, 77, 5),
(318, 10367, 34, 36),
(319, 10367, 54, 18),
(320, 10367, 65, 15),
(321, 10367, 77, 7),
(322, 10368, 21, 5),
(323, 10368, 28, 13),
(324, 10368, 57, 25),
(325, 10368, 64, 35),
(326, 10369, 29, 20),
(327, 10369, 56, 18),
(328, 10370, 1, 15),
(329, 10370, 64, 30),
(330, 10370, 74, 20),
(331, 10371, 36, 6),
(332, 10372, 20, 12),
(333, 10372, 38, 40),
(334, 10372, 60, 70),
(335, 10372, 72, 42),
(336, 10373, 58, 80),
(337, 10373, 71, 50),
(338, 10374, 31, 30),
(339, 10374, 58, 15),
(340, 10375, 14, 15),
(341, 10375, 54, 10),
(342, 10376, 31, 42),
(343, 10377, 28, 20),
(344, 10377, 39, 20),
(345, 10378, 71, 6),
(346, 10379, 41, 8),
(347, 10379, 63, 16),
(348, 10379, 65, 20),
(349, 10380, 30, 18),
(350, 10380, 53, 20),
(351, 10380, 60, 6),
(352, 10380, 70, 30),
(353, 10381, 74, 14),
(354, 10382, 5, 32),
(355, 10382, 18, 9),
(356, 10382, 29, 14),
(357, 10382, 33, 60),
(358, 10382, 74, 50),
(359, 10383, 13, 20),
(360, 10383, 50, 15),
(361, 10383, 56, 20),
(362, 10384, 20, 28),
(363, 10384, 60, 15),
(364, 10385, 7, 10),
(365, 10385, 60, 20),
(366, 10385, 68, 8),
(367, 10386, 24, 15),
(368, 10386, 34, 10),
(369, 10387, 24, 15),
(370, 10387, 28, 6),
(371, 10387, 59, 12),
(372, 10387, 71, 15),
(373, 10388, 45, 15),
(374, 10388, 52, 20),
(375, 10388, 53, 40),
(376, 10389, 10, 16),
(377, 10389, 55, 15),
(378, 10389, 62, 20),
(379, 10389, 70, 30),
(380, 10390, 31, 60),
(381, 10390, 35, 40),
(382, 10390, 46, 45),
(383, 10390, 72, 24),
(384, 10391, 13, 18),
(385, 10392, 69, 50),
(386, 10393, 2, 25),
(387, 10393, 14, 42),
(388, 10393, 25, 7),
(389, 10393, 26, 70),
(390, 10393, 31, 32),
(391, 10394, 13, 10),
(392, 10394, 62, 10),
(393, 10395, 46, 28),
(394, 10395, 53, 70),
(395, 10395, 69, 8),
(396, 10396, 23, 40),
(397, 10396, 71, 60),
(398, 10396, 72, 21),
(399, 10397, 21, 10),
(400, 10397, 51, 18),
(401, 10398, 35, 30),
(402, 10398, 55, 120),
(403, 10399, 68, 60),
(404, 10399, 71, 30),
(405, 10399, 76, 35),
(406, 10399, 77, 14),
(407, 10400, 29, 21),
(408, 10400, 35, 35),
(409, 10400, 49, 30),
(410, 10401, 30, 18),
(411, 10401, 56, 70),
(412, 10401, 65, 20),
(413, 10401, 71, 60),
(414, 10402, 23, 60),
(415, 10402, 63, 65),
(416, 10403, 16, 21),
(417, 10403, 48, 70),
(418, 10404, 26, 30),
(419, 10404, 42, 40),
(420, 10404, 49, 30),
(421, 10405, 3, 50),
(422, 10406, 1, 10),
(423, 10406, 21, 30),
(424, 10406, 28, 42),
(425, 10406, 36, 5),
(426, 10406, 40, 2),
(427, 10407, 11, 30),
(428, 10407, 69, 15),
(429, 10407, 71, 15),
(430, 10408, 37, 10),
(431, 10408, 54, 6),
(432, 10408, 62, 35),
(433, 10409, 14, 12),
(434, 10409, 21, 12),
(435, 10410, 33, 49),
(436, 10410, 59, 16),
(437, 10411, 41, 25),
(438, 10411, 44, 40),
(439, 10411, 59, 9),
(440, 10412, 14, 20),
(441, 10413, 1, 24),
(442, 10413, 62, 40),
(443, 10413, 76, 14),
(444, 10414, 19, 18),
(445, 10414, 33, 50),
(446, 10415, 17, 2),
(447, 10415, 33, 20),
(448, 10416, 19, 20),
(449, 10416, 53, 10),
(450, 10416, 57, 20),
(451, 10417, 38, 50),
(452, 10417, 46, 2),
(453, 10417, 68, 36),
(454, 10417, 77, 35),
(455, 10418, 2, 60),
(456, 10418, 47, 55),
(457, 10418, 61, 16),
(458, 10418, 74, 15),
(459, 10419, 60, 60),
(460, 10419, 69, 20),
(461, 10420, 9, 20),
(462, 10420, 13, 2),
(463, 10420, 70, 8),
(464, 10420, 73, 20),
(465, 10421, 19, 4),
(466, 10421, 26, 30),
(467, 10421, 53, 15),
(468, 10421, 77, 10),
(469, 10422, 26, 2),
(470, 10423, 31, 14),
(471, 10423, 59, 20),
(472, 10424, 35, 60),
(473, 10424, 38, 49),
(474, 10424, 68, 30),
(475, 10425, 55, 10),
(476, 10425, 76, 20),
(477, 10426, 56, 5),
(478, 10426, 64, 7),
(479, 10427, 14, 35),
(480, 10428, 46, 20),
(481, 10429, 50, 40),
(482, 10429, 63, 35),
(483, 10430, 17, 45),
(484, 10430, 21, 50),
(485, 10430, 56, 30),
(486, 10430, 59, 70),
(487, 10431, 17, 50),
(488, 10431, 40, 50),
(489, 10431, 47, 30),
(490, 10432, 26, 10),
(491, 10432, 54, 40),
(492, 10433, 56, 28),
(493, 10434, 11, 6),
(494, 10434, 76, 18),
(495, 10435, 2, 10),
(496, 10435, 22, 12),
(497, 10435, 72, 10),
(498, 10436, 46, 5),
(499, 10436, 56, 40),
(500, 10436, 64, 30),
(501, 10436, 75, 24),
(502, 10437, 53, 15),
(503, 10438, 19, 15),
(504, 10438, 34, 20),
 (505, 10438, 57, 15),
(506, 10439, 12, 15),
(507, 10439, 16, 16),
(508, 10439, 64, 6),
(509, 10439, 74, 30),
(510, 10440, 2, 45),
(511, 10440, 16, 49),
(512, 10440, 29, 24),
(513, 10440, 61, 90),
(514, 10441, 27, 50),
(515, 10442, 11, 30),
(516, 10442, 54, 80),
(517, 10442, 66, 60),
(518, 10443, 11, 6),
(519, 10443, 28, 12);

-- Volcando estructura para tabla [Link]

CREATE TABLE IF NOT EXISTS `Orders` (
`OrderID` int NOT NULL AUTO_INCREMENT,
`CustomerID` int NOT NULL,
`EmployeeID` int NOT NULL,
`OrderDate` date NOT NULL,
`ShipperID` int NOT NULL,
PRIMARY KEY (`OrderID`),
KEY `CustomerID` (`CustomerID`),
KEY `EmployeeID` (`EmployeeID`),
KEY `ShipperID` (`ShipperID`),
CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`CustomerID`) REFERENCES `customers`
(`CustomerID`),
CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`EmployeeID`) REFERENCES `Employees`
(`EmployeeID`),
CONSTRAINT `orders_ibfk_3` FOREIGN KEY (`ShipperID`) REFERENCES `Shippers`
(`ShipperID`)
) ENGINE=InnoDB AUTO_INCREMENT=10444 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

-- Volcando datos para la tabla [Link]: ~196 rows (aproximadamente)

DELETE FROM `Orders`;
INSERT INTO `Orders` (`OrderID`, `CustomerID`, `EmployeeID`, `OrderDate`,
`ShipperID`) VALUES
(10248, 90, 5, '1996-07-04', 3),
(10249, 81, 6, '1996-07-05', 1),
(10250, 34, 4, '1996-07-08', 2),
(10251, 84, 3, '1996-07-08', 1),
(10252, 76, 4, '1996-07-09', 2),
(10253, 34, 3, '1996-07-10', 2),
(10254, 14, 5, '1996-07-11', 2),
(10255, 68, 9, '1996-07-12', 3),
(10256, 88, 3, '1996-07-15', 2),
(10257, 35, 4, '1996-07-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, '1996-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, 4, '1996-08-30', 2),
(10295, 85, 2, '1996-09-02', 2),
(10296, 46, 6, '1996-09-03', 1),
(10297, 7, 5, '1996-09-04', 2),
(10298, 37, 6, '1996-09-05', 2),
(10299, 67, 4, '1996-09-06', 2),
(10300, 49, 2, '1996-09-09', 2),
(10301, 86, 8, '1996-09-09', 2),
(10302, 76, 4, '1996-09-10', 2),
(10303, 30, 7, '1996-09-11', 2),
(10304, 80, 1, '1996-09-12', 2),
(10305, 55, 8, '1996-09-13', 3),
(10306, 69, 1, '1996-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);
-- Volcando estructura para tabla [Link]
CREATE TABLE IF NOT EXISTS `Products` (
`ProductID` int NOT NULL AUTO_INCREMENT,
`ProductName` varchar(100) NOT NULL,
`SupplierID` int NOT NULL,
`CategoryID` int NOT NULL,
`Unit` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT
NULL,
`Price` float DEFAULT NULL,
PRIMARY KEY (`ProductID`),
KEY `products_ibfk_1` (`CategoryID`),
KEY `products_ibfk_2` (`SupplierID`),
CONSTRAINT `products_ibfk_1` FOREIGN KEY (`CategoryID`) REFERENCES `Categories`
(`CategoryID`),
CONSTRAINT `products_ibfk_2` FOREIGN KEY (`SupplierID`) REFERENCES `Suppliers`
(`SupplierID`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

-- Volcando datos para la tabla [Link]: ~77 rows (aproximadamente)

DELETE FROM `Products`;
INSERT INTO `Products` (`ProductID`, `ProductName`, `SupplierID`, `CategoryID`,
`Unit`, `Price`) VALUES
(1, 'Chais ', 1, 1, '10 boxes x 20 bags ', 18),
(2, 'Chang ', 1, 1, '24 - 12 oz bottles ', 19),
(3, 'Aniseed Syrup ', 1, 2, '12 - 550 ml bottles ', 10),
(4, 'Chef Anton\'s Cajun Seasoning ', 2, 2, '48 - 6 oz jars ', 22),
(5, 'Chef Anton\'s Gumbo Mix ', 2, 2, '36 boxes ', 21.35),
(6, 'Grandma\'s Boysenberry Spread ', 3, 2, '12 - 8 oz jars ', 25),
(7, 'Uncle Bob\'s Organic Dried Pears ', 3, 7, '12 - 1 lb pkgs. ', 30),
(8, 'Northwoods Cranberry Sauce ', 3, 2, '12 - 12 oz jars ', 40),
(9, 'Mishi Kobe Niku ', 4, 6, '18 - 500 g pkgs. ', 97),
(10, 'Ikura ', 4, 8, '12 - 200 ml jars ', 31),
(11, 'Queso Cabrales ', 5, 4, '1 kg pkg. ', 21),
(12, 'Queso Manchego La Pastora ', 5, 4, '10 - 500 g pkgs. ', 38),
(13, 'Konbu ', 6, 8, '2 kg box ', 6),
(14, 'Tofu ', 6, 7, '40 - 100 g pkgs. ', 23.25),
(15, 'Genen Shouyu ', 6, 2, '24 - 250 ml bottles ', 15.5),
(16, 'Pavlova ', 7, 3, '32 - 500 g boxes ', 17.45),
(17, 'Alice Mutton ', 7, 6, '20 - 1 kg tins ', 39),
(18, 'Carnarvon Tigers ', 7, 8, '16 kg pkg. ', 62.5),
(19, 'Teatime Chocolate Biscuits ', 8, 3, '10 boxes x 12 pieces ', 9.2),
(20, 'Sir Rodney\'s Marmalade ', 8, 3, '30 gift boxes ', 81),
(21, 'Sir Rodney\'s Scones ', 8, 3, '24 pkgs. x 4 pieces ', 10),
(22, 'Gustaf\'s Knäckebröd ', 9, 5, '24 - 500 g pkgs. ', 21),
(23, 'Tunnbröd ', 9, 5, '12 - 250 g pkgs. ', 9),
(24, 'Guaraná Fantástica ', 10, 1, '12 - 355 ml cans ', 4.5),
(25, 'NuNuCa Nuß-Nougat-Creme ', 11, 3, '20 - 450 g glasses ', 14),
(26, 'Gumbär Gummibärchen ', 11, 3, '100 - 250 g bags ', 31.23),
(27, 'Schoggi Schokolade ', 11, 3, '100 - 100 g pieces ', 43.9),
(28, 'Rössle Sauerkraut ', 12, 7, '25 - 825 g cans ', 45.6),
(29, 'Thüringer Rostbratwurst ', 12, 6, '50 bags x 30 sausgs. ', 123.79),
(30, 'Nord-Ost Matjeshering ', 13, 8, '10 - 200 g glasses ', 25.89),
(31, 'Gorgonzola Telino ', 14, 4, '12 - 100 g pkgs ', 12.5),
(32, 'Mascarpone Fabioli ', 14, 4, '24 - 200 g pkgs. ', 32),
(33, 'Geitost ', 15, 4, '500 g ', 2.5),
(34, 'Sasquatch Ale ', 16, 1, '24 - 12 oz bottles ', 14),
(35, 'Steeleye Stout ', 16, 1, '24 - 12 oz bottles ', 18),
 (36, 'Inlagd Sill ', 17, 8, '24 - 250 g jars ', 19),
(37, 'Gravad lax ', 17, 8, '12 - 500 g pkgs. ', 26),
(38, 'Côte de Blaye ', 18, 1, '12 - 75 cl bottles ', 263.5),
(39, 'Chartreuse verte ', 18, 1, '750 cc per bottle ', 18),
(40, 'Boston Crab Meat ', 19, 8, '24 - 4 oz tins ', 18.4),
(41, 'Jack\'s New England Clam Chowder ', 19, 8, '12 - 12 oz cans ', 9.65),
(42, 'Singaporean Hokkien Fried Mee ', 20, 5, '32 - 1 kg pkgs. ', 14),
(43, 'Ipoh Coffee ', 20, 1, '16 - 500 g tins ', 46),
(44, 'Gula Malacca ', 20, 2, '20 - 2 kg bags ', 19.45),
(45, 'Røgede sild ', 21, 8, '1k pkg. ', 9.5),
(46, 'Spegesild ', 21, 8, '4 - 450 g glasses ', 12),
(47, 'Zaanse koeken ', 22, 3, '10 - 4 oz boxes ', 9.5),
(48, 'Chocolade ', 22, 3, '10 pkgs. ', 12.75),
(49, 'Maxilaku ', 23, 3, '24 - 50 g pkgs. ', 20),
(50, 'Valkoinen suklaa ', 23, 3, '12 - 100 g bars ', 16.25),
(51, 'Manjimup Dried Apples ', 24, 7, '50 - 300 g pkgs. ', 53),
(52, 'Filo Mix ', 24, 5, '16 - 2 kg boxes ', 7),
(53, 'Perth Pasties ', 24, 6, '48 pieces ', 32.8),
(54, 'Tourtière ', 25, 6, '16 pies ', 7.45),
(55, 'Pâté chinois ', 25, 6, '24 boxes x 2 pies ', 24),
(56, 'Gnocchi di nonna Alice ', 26, 5, '24 - 250 g pkgs. ', 38),
(57, 'Ravioli Angelo ', 26, 5, '24 - 250 g pkgs. ', 19.5),
(58, 'Escargots de Bourgogne ', 27, 8, '24 pieces ', 13.25),
(59, 'Raclette Courdavault ', 28, 4, '5 kg pkg. ', 55),
(60, 'Camembert Pierrot ', 28, 4, '15 - 300 g rounds ', 34),
(61, 'Sirop d\'érable ', 29, 2, '24 - 500 ml bottles ', 28.5),
(62, 'Tarte au sucre ', 29, 3, '48 pies ', 49.3),
(63, 'Vegie-spread ', 7, 2, '15 - 625 g jars ', 43.9),
(64, 'Wimmers gute Semmelknödel ', 12, 5, '20 bags x 4 pieces ', 33.25),
(65, 'Louisiana Fiery Hot Pepper Sauce ', 2, 2, '32 - 8 oz bottles ', 21.05),
(66, 'Louisiana Hot Spiced Okra ', 2, 2, '24 - 8 oz jars ', 17),
(67, 'Laughing Lumberjack Lager ', 16, 1, '24 - 12 oz bottles ', 14),
(68, 'Scottish Longbreads ', 8, 3, '10 boxes x 8 pieces ', 12.5),
(69, 'Gudbrandsdalsost ', 15, 4, '10 kg pkg. ', 36),
(70, 'Outback Lager ', 7, 1, '24 - 355 ml bottles ', 15),
(71, 'Fløtemysost ', 15, 4, '10 - 500 g pkgs. ', 21.5),
(72, 'Mozzarella di Giovanni ', 14, 4, '24 - 200 g pkgs. ', 34.8),
(73, 'Röd Kaviar ', 17, 8, '24 - 150 g jars ', 15),
(74, 'Longlife Tofu ', 4, 7, '5 kg pkg. ', 10),
(75, 'Rhönbräu Klosterbier ', 12, 1, '24 - 0.5 l bottles ', 7.75),
(76, 'Lakkalikööri ', 23, 1, '500 ml ', 18),
(77, 'Original Frankfurter grüne Soße ', 12, 2, '12 boxes ', 13);

-- Volcando estructura para tabla [Link]

CREATE TABLE IF NOT EXISTS `Shippers` (
`ShipperID` int NOT NULL AUTO_INCREMENT,
`ShipperName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT
NULL,
`Phone` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ShipperID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

-- Volcando datos para la tabla [Link]: ~3 rows (aproximadamente)

DELETE FROM `Shippers`;
INSERT INTO `Shippers` (`ShipperID`, `ShipperName`, `Phone`) VALUES
(1, 'Speedy Express', 5559831),
(2, 'United Package ', 5553199),
(3, 'Federal Shipping ', 5559931);
-- Volcando estructura para tabla [Link]
CREATE TABLE IF NOT EXISTS `Suppliers` (
`SupplierID` int NOT NULL AUTO_INCREMENT,
`SupplierName` varchar(100) NOT NULL,
`ContactName` varchar(100) NOT NULL,
`Address` varchar(100) NOT NULL,
`City` varchar(100) NOT NULL,
`PostalCode` varchar(100) NOT NULL,
`Country` varchar(100) NOT NULL,
`Phone` int NOT NULL,
PRIMARY KEY (`SupplierID`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

-- Volcando datos para la tabla [Link]: ~29 rows (aproximadamente)

DELETE FROM `Suppliers`;
INSERT INTO `Suppliers` (`SupplierID`, `SupplierName`, `ContactName`, `Address`,
`City`, `PostalCode`, `Country`, `Phone`) VALUES
(1, 'Exotic Liquid ', 'Charlotte Cooper ', '49 Gilbert St. ', 'Londona ',
'EC1 4SD ', 'UK ', 5552222),
(2, 'New Orleans Cajun Delights ', 'Shelley Burke ', 'P.O. Box 78934 ', 'New
Orleans ', '70117 ', 'USA ', 5554822),
(3, 'Grandma Kelly\'s Homestead ', 'Regina Murphy ', '707 Oxford Rd. ', 'Ann
Arbor ', '48104 ', 'USA ', 5555735),
(4, 'Tokyo Traders ', 'Yoshi Nagase ', '9-8 Sekimai Musashino-shi ',
'Tokyo ', '100 ', 'Japan ', 35555011),
(5, 'Cooperativa de Quesos \'Las Cabras\' ', 'Antonio del Valle Saavedra ',
'Calle del Rosal 4 ', 'Oviedo ', '33007 ', 'Spain ', 5987654),
(6, 'Mayumi\'s ', 'Mayumi Ohno ', '92 Setsuko Chuo-ku ', 'Osaka ', '545 ',
'Japan ', 4317877),
(7, 'Pavlova, Ltd. ', 'Ian Devling ', '74 Rose St. Moonie Ponds ',
'Melbourne ', '3058 ', 'Australia ', 4442343),
(8, 'Specialty Biscuits, Ltd. ', 'Peter Wilson ', '29 King\'s Way ',
'Manchester ', 'M14 GSD ', 'UK ', 5554448),
(9, 'PB Knäckebröd AB ', 'Lars Peterson ', 'Kaloadagatan 13 ', 'Göteborg ',
'S-345 67 ', 'Sweden ', 319876543),
(10, 'Refrescos Americanas LTDA ', 'Carlos Diaz ', 'Av. das Americanas
12.890 ', 'São Paulo ', '5442 ', 'Brazil ', 5554640),
(11, 'Heli Süßwaren GmbH & Co. KG ', 'Petra Winkler ', 'Tiergartenstraße 5 ',
'Berlin ', '10785 ', 'Germany ', 9984510),
(12, 'Plutzer Lebensmittelgroßmärkte AG ', 'Martin Bein ', 'Bogenallee 51 ',
'Frankfurt ', '60439 ', 'Germany ', 992755),
(13, 'Nord-Ost-Fisch Handelsgesellschaft mbH ', 'Sven Petersen ',
'Frahmredder 112a ', 'Cuxhaven ', '27478 ', 'Germany ', 8713),
(14, 'Formaggi Fortini s.r.l. ', 'Elio Rossi ', 'Viale Dante, 75 ',
'Ravenna ', '48100 ', 'Italy ', 60323),
(15, 'Norske Meierier ', 'Beate Vileid ', 'Hatlevegen 5 ', 'Sandvika ',
'1320 ', 'Norway ', 2953010),
(16, 'Bigfoot Breweries ', 'Cheryl Saylor ', '3400 - 8th Avenue Suite 210 ',
'Bend ', '97101 ', 'USA ', 5559931),
(17, 'Svensk Sjöföda AB ', 'Michael Björn ', 'Brovallavägen 231 ',
'Stockholm ', 'S-123 45 ', 'Sweden ', 81234567),
(18, 'Aux joyeux ecclésiastiques ', 'Guylène Nodier ', '203, Rue des Francs-
Bourgeois ', 'Paris ', '75004 ', 'France ', 3830068),
(19, 'New England Seafood Cannery ', 'Robb Merchant ', 'Order Processing
Dept. 2100 Paul Revere Blvd. ', 'Boston ', '02134 ', 'USA ', 5553267),
(20, 'Leka Trading ', 'Chandra Leka ', '471 Serangoon Loop, Suite #402 ',
'Singapore ', '0512 ', 'Singapore ', 5558787),
 (21, 'Lyngbysild ', 'Niels Petersen ', 'Lyngbysild Fiskebakken 10 ',
'Lyngby ', '2800 ', 'Denmark ', 43844108),
(22, 'Zaanse Snoepfabriek ', 'Dirk Luchte ', 'Verkoop Rijnweg 22 ',
'Zaandam ', '9999 ZZ ', 'Netherlands ', 1212),
(23, 'Karkki Oy ', 'Anne Heikkonen ', 'Valtakatu 12 ', 'Lappeenranta ',
'53120 ', 'Finland ', 10956),
(24, 'G\'day, Mate ', 'Wendy Mackenzie ', '170 Prince Edward Parade Hunter\'s
Hill ', 'Sydney ', '2042 ', 'Australia ', 5555914),
(25, 'Ma Maison ', 'Jean-Guy Lauzon ', '2960 Rue St. Laurent ', 'Montréal ',
'H1J 1C3 ', 'Canada ', 5559022),
(26, 'Pasta Buttini s.r.l. ', 'Giovanni Giudici ', 'Via dei Gelsomini, 153 ',
'Salerno ', '84100 ', 'Italy ', 6547665),
(27, 'Escargots Nouveaux ', 'Marie Delamare ', '22, rue H. Voiron ',
'Montceau ', '71300 ', 'France ', 85570007),
(28, 'Gai pâturage ', 'Eliane Noz ', 'Bat. B 3, rue des Alpes ', 'Annecy ',
'74000 ', 'France ', 38769806),
(29, 'Forêts d\'érables ', 'Chantal Goulet ', '148 rue Chasseur ', 'Ste-
Hyacinthe ', 'J2S 7S8 ', 'Canada ', 5552955);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;