Table of Contents
-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: Nov 30, 2022 at 07:13 AM
-- Server version: 5.7.34
-- PHP Version: 7.4.21
-- Teeratus_R
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `Northwind_t`
--
-- --------------------------------------------------------
--
-- Table structure for table `Categories`
--
CREATE TABLE `Categories` (
`CategoryID` int(11) NOT NULL,
`CategoryName` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
`Description` mediumtext COLLATE utf8mb4_unicode_ci,
`Picture` longblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `Categories`
--
INSERT INTO `Categories` (`CategoryID`, `CategoryName`, `Description`, `Picture`) 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', '');
-- --------------------------------------------------------
--
-- Table structure for table `Customers`
--
CREATE TABLE `Customers` (
`CustomerID` int(13) NOT NULL,
`CustomerCode` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`CompanyName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ContactName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ContactTitle` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`City` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Region` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`PostalCode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Country` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Phone` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Fax` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `Customers`
--
INSERT INTO `Customers` (`CustomerID`, `CustomerCode`, `CompanyName`, `ContactName`, `ContactTitle`, `Address`, `City`, `Region`, `PostalCode`, `Country`, `Phone`, `Fax`) VALUES
(1, 'ALFKI', 'Alfreds Futterkiste', 'Maria Anders', 'Sales Representative', 'Obere Str. 57', 'Berlin', '', '12209', 'Germany', '030-0074321', '030-0076545'),
(2, 'ANATR', 'Ana Trujillo Emparedados y helados', 'Ana Trujillo', 'Owner', 'Avda. de la Constitucin 2222', 'Mxico D.F.', '', '5021', 'Mexico', '(5) 555-4729', '(5) 555-3745'),
(3, 'ANTON', 'Antonio Moreno Taquera', 'Antonio Moreno', 'Owner', 'Mataderos 2312', 'Mxico D.F.', '', '5023', 'Mexico', '(5) 555-3932', ''),
(4, 'AROUT', 'Around the Horn', 'Thomas Hardy', 'Sales Representative', '120 Hanover Sq.', 'London', '', 'WA1 1DP', 'UK', '(171) 555-7788', '(171) 555-6750'),
(5, 'BERGS', 'Berglunds snabbkp', 'Christina Berglund', 'Order Administrator', 'Berguvsvgen 8', 'Lule', '', 'S-958 22', 'Sweden', '0921-12 34 65', '0921-12 34 67'),
(6, 'BLAUS', 'Blauer See Delikatessen', 'Hanna Moos', 'Sales Representative', 'Forsterstr. 57', 'Mannheim', '', '68306', 'Germany', '0621-08460', '0621-08924'),
(7, 'BLONP', 'Blondesddsl pre et fils', 'Frdrique Citeaux', 'Marketing Manager', '24, place Klber', 'Strasbourg', '', '67000', 'France', '88.60.15.31', '88.60.15.32'),
(8, 'BOLID', 'Blido Comidas preparadas', 'Martn Sommer', 'Owner', 'C/ Araquil, 67', 'Madrid', '', '28023', 'Spain', '(91) 555 22 82', '(91) 555 91 99'),
(9, 'BONAP', 'Bon app\'', 'Laurence Lebihan', 'Owner', '12, rue des Bouchers', 'Marseille', '', '13008', 'France', '91.24.45.40', '91.24.45.41'),
(10, 'BOTTM', 'Bottom-Dollar Markets', 'Elizabeth Lincoln', 'Accounting Manager', '23 Tsawassen Blvd.', 'Tsawassen', 'BC', 'T2F 8M4', 'Canada', '(604) 555-4729', '(604) 555-3745'),
(11, 'BSBEV', 'B\'s Beverages', 'Victoria Ashworth', 'Sales Representative', 'Fauntleroy Circus', 'London', '', 'EC2 5NT', 'UK', '(171) 555-1212', ''),
(12, 'CACTU', 'Cactus Comidas para llevar', 'Patricio Simpson', 'Sales Agent', 'Cerrito 333', 'Buenos Aires', '', '1010', 'Argentina', '(1) 135-5555', '(1) 135-4892'),
(13, 'CENTC', 'Centro comercial Moctezuma', 'Francisco Chang', 'Marketing Manager', 'Sierras de Granada 9993', 'Mxico D.F.', '', '5022', 'Mexico', '(5) 555-3392', '(5) 555-7293'),
(14, 'CHOPS', 'Chop-suey Chinese', 'Yang Wang', 'Owner', 'Hauptstr. 29', 'Bern', '', '3012', 'Switzerland', '0452-076545', ''),
(15, 'COMMI', 'Comrcio Mineiro', 'Pedro Afonso', 'Sales Associate', 'Av. dos Lusadas, 23', 'Sao Paulo', 'SP', '05432-043', 'Brazil', '(11) 555-7647', ''),
(16, 'CONSH', 'Consolidated Holdings', 'Elizabeth Brown', 'Sales Representative', 'Berkeley Gardens 12 Brewery', 'London', '', 'WX1 6LT', 'UK', '(171) 555-2282', '(171) 555-9199'),
(17, 'DRACD', 'Drachenblut Delikatessen', 'Sven Ottlieb', 'Order Administrator', 'Walserweg 21', 'Aachen', '', '52066', 'Germany', '0241-039123', '0241-059428'),
(18, 'DUMON', 'Du monde entier', 'Janine Labrune', 'Owner', '67, rue des Cinquante Otages', 'Nantes', '', '44000', 'France', '40.67.88.88', '40.67.89.89'),
(19, 'EASTC', 'Eastern Connection', 'Ann Devon', 'Sales Agent', '35 King George', 'London', '', 'WX3 6FW', 'UK', '(171) 555-0297', '(171) 555-3373'),
(20, 'ERNSH', 'Ernst Handel', 'Roland Mendel', 'Sales Manager', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria', '7675-3425', '7675-3426'),
(21, 'FAMIA', 'Familia Arquibaldo', 'Aria Cruz', 'Marketing Assistant', 'Rua Ors, 92', 'Sao Paulo', 'SP', '05442-030', 'Brazil', '(11) 555-9857', ''),
(22, 'FISSA', 'FISSA Fabrica Inter. Salchichas S.A.', 'Diego Roel', 'Accounting Manager', 'C/ Moralzarzal, 86', 'Madrid', '', '28034', 'Spain', '(91) 555 94 44', '(91) 555 55 93'),
(23, 'FOLIG', 'Folies gourmandes', 'Martine Ranc', 'Assistant Sales Agent', '184, chausse de Tournai', 'Lille', '', '59000', 'France', '20.16.10.16', '20.16.10.17'),
(24, 'FOLKO', 'Folk och f HB', 'Maria Larsson', 'Owner', 'kergatan 24', 'Brcke', '', 'S-844 67', 'Sweden', '0695-34 67 21', ''),
(25, 'FRANK', 'Frankenversand', 'Peter Franken', 'Marketing Manager', 'Berliner Platz 43', 'Mnchen', '', '80805', 'Germany', '089-0877310', '089-0877451'),
(26, 'FRANR', 'France restauration', 'Carine Schmitt', 'Marketing Manager', '54, rue Royale', 'Nantes', '', '44000', 'France', '40.32.21.21', '40.32.21.20'),
(27, 'FRANS', 'Franchi S.p.A.', 'Paolo Accorti', 'Sales Representative', 'Via Monte Bianco 34', 'Torino', '', '10100', 'Italy', '011-4988260', '011-4988261'),
(28, 'FURIB', 'Furia Bacalhau e Frutos do Mar', 'Lino Rodriguez', 'Sales Manager', 'Jardim das rosas n. 32', 'Lisboa', '', '1675', 'Portugal', '(1) 354-2534', '(1) 354-2535'),
(29, 'GALED', 'Galera del gastrnomo', 'Eduardo Saavedra', 'Marketing Manager', 'Rambla de Catalua, 23', 'Barcelona', '', '8022', 'Spain', '(93) 203 4560', '(93) 203 4561'),
(30, 'GODOS', 'Godos Cocina Tpica', 'Jos Pedro Freyre', 'Sales Manager', 'C/ Romero, 33', 'Sevilla', '', '41101', 'Spain', '(95) 555 82 82', ''),
(31, 'GOURL', 'Gourmet Lanchonetes', 'Andr Fonseca', 'Sales Associate', 'Av. Brasil, 442', 'Campinas', 'SP', '04876-786', 'Brazil', '(11) 555-9482', ''),
(32, 'GREAL', 'Great Lakes Food Market', 'Howard Snyder', 'Marketing Manager', '2732 Baker Blvd.', 'Eugene', 'OR', '97403', 'USA', '(503) 555-7555', ''),
(33, 'GROSR', 'GROSELLA-Restaurante', 'Manuel Pereira', 'Owner', '5 Ave. Los Palos Grandes', 'Caracas', 'DF', '1081', 'Venezuela', '(2) 283-2951', '(2) 283-3397'),
(34, 'HANAR', 'Hanari Carnes', 'Mario Pontes', 'Accounting Manager', 'Rua do Pao, 67', 'Rio de Janeiro', 'RJ', '05454-876', 'Brazil', '(21) 555-0091', '(21) 555-8765'),
(35, 'HILAA', 'HILARION-Abastos', 'Carlos Hernndez', 'Sales Representative', 'Carrera 22 con Ave. Carlos Soublette #8-35', 'San Cristbal', 'Tchira', '5022', 'Venezuela', '(5) 555-1340', '(5) 555-1948'),
(36, 'HUNGC', 'Hungry Coyote Import Store', 'Yoshi Latimer', 'Sales Representative', 'City Center Plaza 516 Main St.', 'Elgin', 'OR', '97827', 'USA', '(503) 555-6874', '(503) 555-2376'),
(37, 'HUNGO', 'Hungry Owl All-Night Grocers', 'Patricia McKenna', 'Sales Associate', '8 Johnstown Road', 'Cork', 'Co. Cork', '', 'Ireland', '2967 542', '2967 3333'),
(38, 'ISLAT', 'Island Trading', 'Helen Bennett', 'Marketing Manager', 'Garden House Crowther Way', 'Cowes', 'Isle of Wight', 'PO31 7PJ', 'UK', '(198) 555-8888', ''),
(39, 'KOENE', 'Kniglich Essen', 'Philip Cramer', 'Sales Associate', 'Maubelstr. 90', 'Brandenburg', '', '14776', 'Germany', '0555-09876', ''),
(40, 'LACOR', 'La corne d\'abondance', 'Daniel Tonini', 'Sales Representative', '67, avenue de l\'Europe', 'Versailles', '', '78000', 'France', '30.59.84.10', '30.59.85.11'),
(41, 'LAMAI', 'La maison d\'Asie', 'Annette Roulet', 'Sales Manager', '1 rue Alsace-Lorraine', 'Toulouse', '', '31000', 'France', '61.77.61.10', '61.77.61.11'),
(42, 'LAUGB', 'Laughing Bacchus Wine Cellars', 'Yoshi Tannamuri', 'Marketing Assistant', '1900 Oak St.', 'Vancouver', 'BC', 'V3F 2K1', 'Canada', '(604) 555-3392', '(604) 555-7293'),
(43, 'LAZYK', 'Lazy K Kountry Store', 'John Steel', 'Marketing Manager', '12 Orchestra Terrace', 'Walla Walla', 'WA', '99362', 'USA', '(509) 555-7969', '(509) 555-6221'),
(44, 'LEHMS', 'Lehmanns Marktstand', 'Renate Messner', 'Sales Representative', 'Magazinweg 7', 'Frankfurt a.M.', '', '60528', 'Germany', '069-0245984', '069-0245874'),
(45, 'LETSS', 'Let\'s Stop N Shop', 'Jaime Yorres', 'Owner', '87 Polk St. Suite 5', 'San Francisco', 'CA', '94117', 'USA', '(415) 555-5938', ''),
(46, 'LILAS', 'LILA-Supermercado', 'Carlos Gonzlez', 'Accounting Manager', 'Carrera 52 con Ave. Bolvar #65-98 Llano Largo', 'Barquisimeto', 'Lara', '3508', 'Venezuela', '(9) 331-6954', '(9) 331-7256'),
(47, 'LINOD', 'LINO-Delicateses', 'Felipe Izquierdo', 'Owner', 'Ave. 5 de Mayo Porlamar', 'I. de Margarita', 'Nueva Esparta', '4980', 'Venezuela', '(8) 34-56-12', '(8) 34-93-93'),
(48, 'LONEP', 'Lonesome Pine Restaurant', 'Fran Wilson', 'Sales Manager', '89 Chiaroscuro Rd.', 'Portland', 'OR', '97219', 'USA', '(503) 555-9573', '(503) 555-9646'),
(49, 'MAGAA', 'Magazzini Alimentari Riuniti', 'Giovanni Rovelli', 'Marketing Manager', 'Via Ludovico il Moro 22', 'Bergamo', '', '24100', 'Italy', '035-640230', '035-640231'),
(50, 'MAISD', 'Maison Dewey', 'Catherine Dewey', 'Sales Agent', 'Rue Joseph-Bens 532', 'Bruxelles', '', 'B-1180', 'Belgium', '(02) 201 24 67', '(02) 201 24 68'),
(51, 'MEREP', 'Mre Paillarde', 'Jean Fresnire', 'Marketing Assistant', '43 rue St. Laurent', 'Montral', 'Qubec', 'H1J 1C3', 'Canada', '(514) 555-8054', '(514) 555-8055'),
(52, 'MORGK', 'Morgenstern Gesundkost', 'Alexander Feuer', 'Marketing Assistant', 'Heerstr. 22', 'Leipzig', '', '4179', 'Germany', '0342-023176', ''),
(53, 'NORTS', 'North/South', 'Simon Crowther', 'Sales Associate', 'South House 300 Queensbridge', 'London', '', 'SW7 1RZ', 'UK', '(171) 555-7733', '(171) 555-2530'),
(54, 'OCEAN', 'Ocano Atlntico Ltda.', 'Yvonne Moncada', 'Sales Agent', 'Ing. Gustavo Moncada 8585 Piso 20-A', 'Buenos Aires', '', '1010', 'Argentina', '(1) 135-5333', '(1) 135-5535'),
(55, 'OLDWO', 'Old World Delicatessen', 'Rene Phillips', 'Sales Representative', '2743 Bering St.', 'Anchorage', 'AK', '99508', 'USA', '(907) 555-7584', '(907) 555-2880'),
(56, 'OTTIK', 'Ottilies Kseladen', 'Henriette Pfalzheim', 'Owner', 'Mehrheimerstr. 369', 'Kln', '', '50739', 'Germany', '0221-0644327', '0221-0765721'),
(57, 'PARIS', 'Paris spcialits', 'Marie Bertrand', 'Owner', '265, boulevard Charonne', 'Paris', '', '75012', 'France', '(1) 42.34.22.66', '(1) 42.34.22.77'),
(58, 'PERIC', 'Pericles Comidas clsicas', 'Guillermo Fernndez', 'Sales Representative', 'Calle Dr. Jorge Cash 321', 'Mxico D.F.', '', '5033', 'Mexico', '(5) 552-3745', '(5) 545-3745'),
(59, 'PICCO', 'Piccolo und mehr', 'Georg Pipps', 'Sales Manager', 'Geislweg 14', 'Salzburg', '', '5020', 'Austria', '6562-9722', '6562-9723'),
(60, 'PRINI', 'Princesa Isabel Vinhos', 'Isabel de Castro', 'Sales Representative', 'Estrada da sade n. 58', 'Lisboa', '', '1756', 'Portugal', '(1) 356-5634', ''),
(61, 'QUEDE', 'Que Delcia', 'Bernardo Batista', 'Accounting Manager', 'Rua da Panificadora, 12', 'Rio de Janeiro', 'RJ', '02389-673', 'Brazil', '(21) 555-4252', '(21) 555-4545'),
(62, 'QUEEN', 'Queen Cozinha', 'Lcia Carvalho', 'Marketing Assistant', 'Alameda dos Canrios, 891', 'Sao Paulo', 'SP', '05487-020', 'Brazil', '(11) 555-1189', ''),
(63, 'QUICK', 'QUICK-Stop', 'Horst Kloss', 'Accounting Manager', 'Taucherstrae 10', 'Cunewalde', '', '1307', 'Germany', '0372-035188', ''),
(64, 'RANCH', 'Rancho grande', 'Sergio Gutirrez', 'Sales Representative', 'Av. del Libertador 900', 'Buenos Aires', '', '1010', 'Argentina', '(1) 123-5555', '(1) 123-5556'),
(65, 'RATTC', 'Rattlesnake Canyon Grocery', 'Paula Wilson', 'Assistant Sales Representative', '2817 Milton Dr.', 'Albuquerque', 'NM', '87110', 'USA', '(505) 555-5939', '(505) 555-3620'),
(66, 'REGGC', 'Reggiani Caseifici', 'Maurizio Moroni', 'Sales Associate', 'Strada Provinciale 124', 'Reggio Emilia', '', '42100', 'Italy', '0522-556721', '0522-556722'),
(67, 'RICAR', 'Ricardo Adocicados', 'Janete Limeira', 'Assistant Sales Agent', 'Av. Copacabana, 267', 'Rio de Janeiro', 'RJ', '02389-890', 'Brazil', '(21) 555-3412', ''),
(68, 'RICSU', 'Richter Supermarkt', 'Michael Holz', 'Sales Manager', 'Grenzacherweg 237', 'Genve', '', '1203', 'Switzerland', '0897-034214', ''),
(69, 'ROMEY', 'Romero y tomillo', 'Alejandra Camino', 'Accounting Manager', 'Gran Va, 1', 'Madrid', '', '28001', 'Spain', '(91) 745 6200', '(91) 745 6210'),
(70, 'SANTG', 'Sant Gourmet', 'Jonas Bergulfsen', 'Owner', 'Erling Skakkes gate 78', 'Stavern', '', '4110', 'Norway', '07-98 92 35', '07-98 92 47'),
(71, 'SAVEA', 'Save-a-lot Markets', 'Jose Pavarotti', 'Sales Representative', '187 Suffolk Ln.', 'Boise', 'ID', '83720', 'USA', '(208) 555-8097', ''),
(72, 'SEVES', 'Seven Seas Imports', 'Hari Kumar', 'Sales Manager', '90 Wadhurst Rd.', 'London', '', 'OX15 4NB', 'UK', '(171) 555-1717', '(171) 555-5646'),
(73, 'SIMOB', 'Simons bistro', 'Jytte Petersen', 'Owner', 'Vinbltet 34', 'Kobenhavn', '', '1734', 'Denmark', '31 12 34 56', '31 13 35 57'),
(74, 'SPECD', 'Spcialits du monde', 'Dominique Perrier', 'Marketing Manager', '25, rue Lauriston', 'Paris', '', '75016', 'France', '(1) 47.55.60.10', '(1) 47.55.60.20'),
(75, 'SPLIR', 'Split Rail Beer & Ale', 'Art Braunschweiger', 'Sales Manager', 'P.O. Box 555', 'Lander', 'WY', '82520', 'USA', '(307) 555-4680', '(307) 555-6525'),
(76, 'SUPRD', 'Suprmes dlices', 'Pascale Cartrain', 'Accounting Manager', 'Boulevard Tirou, 255', 'Charleroi', '', 'B-6000', 'Belgium', '(071) 23 67 22 20', '(071) 23 67 22 21'),
(77, 'THEBI', 'The Big Cheese', 'Liz Nixon', 'Marketing Manager', '89 Jefferson Way Suite 2', 'Portland', 'OR', '97201', 'USA', '(503) 555-3612', ''),
(78, 'THECR', 'The Cracker Box', 'Liu Wong', 'Marketing Assistant', '55 Grizzly Peak Rd.', 'Butte', 'MT', '59801', 'USA', '(406) 555-5834', '(406) 555-8083'),
(79, 'TOMSP', 'Toms Spezialitten', 'Karin Josephs', 'Marketing Manager', 'Luisenstr. 48', 'Mnster', '', '44087', 'Germany', '0251-031259', '0251-035695'),
(80, 'TORTU', 'Tortuga Restaurante', 'Miguel Angel Paolino', 'Owner', 'Avda. Azteca 123', 'Mxico D.F.', '', '5033', 'Mexico', '(5) 555-2933', ''),
(81, 'TRADH', 'Tradio Hipermercados', 'Anabela Domingues', 'Sales Representative', 'Av. Ins de Castro, 414', 'Sao Paulo', 'SP', '05634-030', 'Brazil', '(11) 555-2167', '(11) 555-2168'),
(82, 'TRAIH', 'Trail\'s Head Gourmet Provisioners', 'Helvetius Nagy', 'Sales Associate', '722 DaVinci Blvd.', 'Kirkland', 'WA', '98034', 'USA', '(206) 555-8257', '(206) 555-2174'),
(83, 'VAFFE', 'Vaffeljernet', 'Palle Ibsen', 'Sales Manager', 'Smagsloget 45', 'rhus', '', '8200', 'Denmark', '86 21 32 43', '86 22 33 44'),
(84, 'VICTE', 'Victuailles en stock', 'Mary Saveley', 'Sales Agent', '2, rue du Commerce', 'Lyon', '', '69004', 'France', '78.32.54.86', '78.32.54.87'),
(85, 'VINET', 'Vins et alcools Chevalier', 'Paul Henriot', 'Accounting Manager', '59 rue de l\'Abbaye', 'Reims', '', '51100', 'France', '26.47.15.10', '26.47.15.11'),
(86, 'WANDK', 'Die Wandernde Kuh', 'Rita Mller', 'Sales Representative', 'Adenauerallee 900', 'Stuttgart', '', '70563', 'Germany', '0711-020361', '0711-035428'),
(87, 'WARTH', 'Wartian Herkku', 'Pirkko Koskitalo', 'Accounting Manager', 'Torikatu 38', 'Oulu', '', '90110', 'Finland', '981-443655', '981-443655'),
(88, 'WELLI', 'Wellington Importadora', 'Paula Parente', 'Sales Manager', 'Rua do Mercado, 12', 'Resende', 'SP', '08737-363', 'Brazil', '(14) 555-8122', ''),
(89, 'WHITC', 'White Clover Markets', 'Karl Jablonski', 'Owner', '305 - 14th Ave. S. Suite 3B', 'Seattle', 'WA', '98128', 'USA', '(206) 555-4112', '(206) 555-4115'),
(90, 'WILMK', 'Wilman Kala', 'Matti Karttunen', 'Owner/Marketing Assistant', 'Keskuskatu 45', 'Helsinki', '', '21240', 'Finland', '90-224 8858', '90-224 8858'),
(91, 'WOLZA', 'Wolski Zajazd', 'Zbyszek Piestrzeniewicz', 'Owner', 'ul. Filtrowa 68', 'Warszawa', '', '01-012', 'Poland', '(26) 642-7012', '(26) 642-7012');
-- --------------------------------------------------------
--
-- Table structure for table `Employees`
--
CREATE TABLE `Employees` (
`EmployeeID` int(11) NOT NULL,
`LastName` varchar(20) CHARACTER SET utf8mb4 NOT NULL,
`FirstName` varchar(10) CHARACTER SET utf8mb4 NOT NULL,
`Title` varchar(30) CHARACTER SET utf8mb4 DEFAULT NULL,
`TitleOfCourtesy` varchar(25) CHARACTER SET utf8mb4 DEFAULT NULL,
`BirthDate` datetime DEFAULT NULL,
`HireDate` datetime DEFAULT NULL,
`Address` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
`City` varchar(15) CHARACTER SET utf8mb4 DEFAULT NULL,
`Region` varchar(15) CHARACTER SET utf8mb4 DEFAULT NULL,
`PostalCode` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
`Country` varchar(15) CHARACTER SET utf8mb4 DEFAULT NULL,
`HomePhone` varchar(24) CHARACTER SET utf8mb4 DEFAULT NULL,
`Extension` varchar(4) CHARACTER SET utf8mb4 DEFAULT NULL,
`Photo` longblob,
`Notes` mediumtext CHARACTER SET utf8mb4 NOT NULL,
`ReportsTo` int(11) DEFAULT NULL,
`PhotoPath` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
`Salary` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `Employees`
--
INSERT INTO `Employees` (`EmployeeID`, `LastName`, `FirstName`, `Title`, `TitleOfCourtesy`, `BirthDate`, `HireDate`, `Address`, `City`, `Region`, `PostalCode`, `Country`, `HomePhone`, `Extension`, `Photo`, `Notes`, `ReportsTo`, `PhotoPath`, `Salary`) VALUES
(1, 'Davolio', 'Nancy', 'Sales Representative', 'Ms.', '1948-12-08 00:00:00', '1992-05-01 00:00:00', '507 - 20th Ave. E.Apt. 2A', 'Seattle', 'WA', '98122', 'USA', '(206) 555-9857', '5467', NULL, 'Education includes a BA in psychology from Colorado State University in 1970. She also completed \"The Art of the Cold Call.\" Nancy is a member of Toastmasters International.', 2, 'http://accweb/emmployees/davolio.bmp', 2954.55),
(2, 'Fuller', 'Andrew', 'Vice President, Sales', 'Dr.', '1952-02-19 00:00:00', '1992-08-14 00:00:00', '908 W. Capital Way', 'Tacoma', 'WA', '98401', 'USA', '(206) 555-9482', '3457', NULL, 'Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.', NULL, 'http://accweb/emmployees/fuller.bmp', 2254.49),
(3, 'Leverling', 'Janet', 'Sales Representative', 'Ms.', '1963-08-30 00:00:00', '1992-04-01 00:00:00', '722 Moss Bay Blvd.', 'Kirkland', 'WA', '98033', 'USA', '(206) 555-3412', '3355', NULL, 'Janet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.', 2, 'http://accweb/emmployees/leverling.bmp', 3119.15),
(4, 'Peacock', 'Margaret', 'Sales Representative', 'Mrs.', '1937-09-19 00:00:00', '1993-05-03 00:00:00', '4110 Old Redmond Rd.', 'Redmond', 'WA', '98052', 'USA', '(206) 555-8122', '5176', NULL, 'Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966). She was assigned to the London office temporarily from July through November 1992.', 2, 'http://accweb/emmployees/peacock.bmp', 1861.08),
(5, 'Buchanan', 'Steven', 'Sales Manager', 'Mr.', '1955-03-04 00:00:00', '1993-10-17 00:00:00', '14 Garrett Hill', 'London', NULL, 'SW1 8JR', 'UK', '(71) 555-4848', '3453', NULL, 'Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon joining the company as a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London. He was promoted to sales manager in March 1993. Mr. Buchanan has completed the courses \"Successful Telemarketing\" and \"International Sales Management.\" He is fluent in French.', 2, 'http://accweb/emmployees/buchanan.bmp', 1744.21),
(6, 'Suyama', 'Michael', 'Sales Representative', 'Mr.', '1963-07-02 00:00:00', '1993-10-17 00:00:00', 'Coventry House\r\nMiner Rd.', 'London', NULL, 'EC2 7JR', 'UK', '(71) 555-7773', '428', NULL, 'Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles (MBA, marketing, 1986). 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.', 5, 'http://accweb/emmployees/davolio.bmp', 2004.07),
(7, 'King', 'Robert', 'Sales Representative', 'Mr.', '1960-05-29 00:00:00', '1994-01-02 00:00:00', 'Edgeham Hollow\r\nWinchester Way', 'London', NULL, 'RG1 9SP', 'UK', '(71) 555-5598', '465', NULL, 'Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992, the year he joined the company. After completing a course entitled \"Selling in Europe,\" he was transferred to the London office in March 1993.', 5, 'http://accweb/emmployees/davolio.bmp', 1991.55),
(8, 'Callahan', 'Laura', 'Inside Sales Coordinator', 'Ms.', '1958-01-09 00:00:00', '1994-03-05 00:00:00', '4726 - 11th Ave. N.E.', 'Seattle', 'WA', '98105', 'USA', '(206) 555-1189', '2344', NULL, '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.', 2, 'http://accweb/emmployees/davolio.bmp', 2100.5),
(9, 'Dodsworth', 'Anne', 'Sales Representative', 'Ms.', '1966-01-27 00:00:00', '1994-11-15 00:00:00', '7 Houndstooth Rd.', 'London', NULL, 'WG2 7LT', 'UK', '(71) 555-4444', '452', NULL, 'Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.', 5, 'http://accweb/emmployees/davolio.bmp', 2333.33);
-- --------------------------------------------------------
--
-- Table structure for table `EmployeeTerritories`
--
CREATE TABLE `EmployeeTerritories` (
`EmployeeID` int(11) NOT NULL,
`TerritoryID` varchar(20) CHARACTER SET utf8mb4 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `EmployeeTerritories`
--
INSERT INTO `EmployeeTerritories` (`EmployeeID`, `TerritoryID`) VALUES
(2, '01581'),
(2, '01730'),
(2, '01833'),
(2, '02116'),
(2, '02139'),
(2, '02184'),
(5, '02903'),
(9, '03049'),
(9, '03801'),
(1, '06897'),
(5, '07960'),
(5, '08837'),
(5, '10019'),
(5, '10038'),
(5, '11747'),
(5, '14450'),
(8, '19428'),
(1, '19713'),
(4, '20852'),
(4, '27403'),
(4, '27511'),
(3, '30346'),
(3, '31406'),
(3, '32859'),
(3, '33607'),
(2, '40222'),
(8, '44122'),
(8, '45839'),
(9, '48075'),
(9, '48084'),
(9, '48304'),
(8, '53404'),
(9, '55113'),
(9, '55439'),
(7, '60179'),
(7, '60601'),
(7, '80202'),
(7, '80909'),
(6, '85014'),
(6, '85251'),
(7, '90405'),
(7, '94025'),
(7, '94105'),
(7, '95008'),
(7, '95054'),
(7, '95060'),
(6, '98004'),
(6, '98052'),
(6, '98104');
-- --------------------------------------------------------
--
-- Table structure for table `OrderDetails`
--
CREATE TABLE `OrderDetails` (
`OrderID` int(11) NOT NULL,
`ProductID` int(11) NOT NULL,
`UnitPrice` decimal(10,4) NOT NULL DEFAULT '0.0000',
`Quantity` smallint(2) NOT NULL DEFAULT '1',
`Discount` double(8,0) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `OrderDetails`
--
INSERT INTO `OrderDetails` (`OrderID`, `ProductID`, `UnitPrice`, `Quantity`, `Discount`) VALUES
(10248, 11, '14.0000', 12, 0),
(10248, 42, '9.8000', 10, 0),
(10248, 72, '34.8000', 5, 0),
(10249, 14, '18.6000', 9, 0),
(10249, 51, '42.4000', 40, 0),
(10250, 41, '7.7000', 10, 0),
(10250, 51, '42.4000', 35, 0),
(10250, 65, '16.8000', 15, 0),
(10251, 22, '16.8000', 6, 0),
(10251, 57, '15.6000', 15, 0),
(10251, 65, '16.8000', 20, 0),
(10252, 20, '64.8000', 40, 0),
(10252, 33, '2.0000', 25, 0),
(10252, 60, '27.2000', 40, 0),
(10253, 31, '10.0000', 20, 0),
(10253, 39, '14.4000', 42, 0),
(10253, 49, '16.0000', 40, 0),
(10254, 24, '3.6000', 15, 0),
(10254, 55, '19.2000', 21, 0),
(10254, 74, '8.0000', 21, 0),
(10255, 2, '15.2000', 20, 0),
(10255, 16, '13.9000', 35, 0),
(10255, 36, '15.2000', 25, 0),
(10255, 59, '44.0000', 30, 0),
(10256, 53, '26.2000', 15, 0),
(10256, 77, '10.4000', 12, 0),
(10257, 27, '35.1000', 25, 0),
(10257, 39, '14.4000', 6, 0),
(10257, 77, '10.4000', 15, 0),
(10258, 2, '15.2000', 50, 0),
(10258, 5, '17.0000', 65, 0),
(10258, 32, '25.6000', 6, 0),
(10259, 21, '8.0000', 10, 0),
(10259, 37, '20.8000', 1, 0),
(10260, 41, '7.7000', 16, 0),
(10260, 57, '15.6000', 50, 0),
(10260, 62, '39.4000', 15, 0),
(10260, 70, '12.0000', 21, 0),
(10261, 21, '8.0000', 20, 0),
(10261, 35, '14.4000', 20, 0),
(10262, 5, '17.0000', 12, 0),
(10262, 7, '24.0000', 15, 0),
(10262, 56, '30.4000', 2, 0),
(10263, 16, '13.9000', 60, 0),
(10263, 24, '3.6000', 28, 0),
(10263, 30, '20.7000', 60, 0),
(10263, 74, '8.0000', 36, 0),
(10264, 2, '15.2000', 35, 0),
(10264, 41, '7.7000', 25, 0),
(10265, 17, '31.2000', 30, 0),
(10265, 70, '12.0000', 20, 0),
(10266, 12, '30.4000', 12, 0),
(10267, 40, '14.7000', 50, 0),
(10267, 59, '44.0000', 70, 0),
(10267, 76, '14.4000', 15, 0),
(10268, 29, '99.0000', 10, 0),
(10268, 72, '27.8000', 4, 0),
(10269, 33, '2.0000', 60, 0),
(10269, 72, '27.8000', 20, 0),
(10270, 36, '15.2000', 30, 0),
(10270, 43, '36.8000', 25, 0),
(10271, 33, '2.0000', 24, 0),
(10272, 20, '64.8000', 6, 0),
(10272, 31, '10.0000', 40, 0),
(10272, 72, '27.8000', 24, 0),
(10273, 10, '24.8000', 24, 0),
(10273, 31, '10.0000', 15, 0),
(10273, 33, '2.0000', 20, 0),
(10273, 40, '14.7000', 60, 0),
(10273, 76, '14.4000', 33, 0),
(10274, 71, '17.2000', 20, 0),
(10274, 72, '27.8000', 7, 0),
(10275, 24, '3.6000', 12, 0),
(10275, 59, '44.0000', 6, 0),
(10276, 10, '24.8000', 15, 0),
(10276, 13, '4.8000', 10, 0),
(10277, 28, '36.4000', 20, 0),
(10277, 62, '39.4000', 12, 0),
(10278, 44, '15.5000', 16, 0),
(10278, 59, '44.0000', 15, 0),
(10278, 63, '35.1000', 8, 0),
(10278, 73, '12.0000', 25, 0),
(10279, 17, '31.2000', 15, 0),
(10280, 24, '3.6000', 12, 0),
(10280, 55, '19.2000', 20, 0),
(10280, 75, '6.2000', 30, 0),
(10281, 19, '7.3000', 1, 0),
(10281, 24, '3.6000', 6, 0),
(10281, 35, '14.4000', 4, 0),
(10282, 30, '20.7000', 6, 0),
(10282, 57, '15.6000', 2, 0),
(10283, 15, '12.4000', 20, 0),
(10283, 19, '7.3000', 18, 0),
(10283, 60, '27.2000', 35, 0),
(10283, 72, '27.8000', 3, 0),
(10284, 27, '35.1000', 15, 0),
(10284, 44, '15.5000', 21, 0),
(10284, 60, '27.2000', 20, 0),
(10284, 67, '11.2000', 5, 0),
(10285, 1, '14.4000', 45, 0),
(10285, 40, '14.7000', 40, 0),
(10285, 53, '26.2000', 36, 0),
(10286, 35, '14.4000', 100, 0),
(10286, 62, '39.4000', 40, 0),
(10287, 16, '13.9000', 40, 0),
(10287, 34, '11.2000', 20, 0),
(10287, 46, '9.6000', 15, 0),
(10288, 54, '5.9000', 10, 0),
(10288, 68, '10.0000', 3, 0),
(10289, 3, '8.0000', 30, 0),
(10289, 64, '26.6000', 9, 0),
(10290, 5, '17.0000', 20, 0),
(10290, 29, '99.0000', 15, 0),
(10290, 49, '16.0000', 15, 0),
(10290, 77, '10.4000', 10, 0),
(10291, 13, '4.8000', 20, 0),
(10291, 44, '15.5000', 24, 0),
(10291, 51, '42.4000', 2, 0),
(10292, 20, '64.8000', 20, 0),
(10293, 18, '50.0000', 12, 0),
(10293, 24, '3.6000', 10, 0),
(10293, 63, '35.1000', 5, 0),
(10293, 75, '6.2000', 6, 0),
(10294, 1, '14.4000', 18, 0),
(10294, 17, '31.2000', 15, 0),
(10294, 43, '36.8000', 15, 0),
(10294, 60, '27.2000', 21, 0),
(10294, 75, '6.2000', 6, 0),
(10295, 56, '30.4000', 4, 0),
(10296, 11, '16.8000', 12, 0),
(10296, 16, '13.9000', 30, 0),
(10296, 69, '28.8000', 15, 0),
(10297, 39, '14.4000', 60, 0),
(10297, 72, '27.8000', 20, 0),
(10298, 2, '15.2000', 40, 0),
(10298, 36, '15.2000', 40, 0),
(10298, 59, '44.0000', 30, 0),
(10298, 62, '39.4000', 15, 0),
(10299, 19, '7.3000', 15, 0),
(10299, 70, '12.0000', 20, 0),
(10300, 66, '13.6000', 30, 0),
(10300, 68, '10.0000', 20, 0),
(10301, 40, '14.7000', 10, 0),
(10301, 56, '30.4000', 20, 0),
(10302, 17, '31.2000', 40, 0),
(10302, 28, '36.4000', 28, 0),
(10302, 43, '36.8000', 12, 0),
(10303, 40, '14.7000', 40, 0),
(10303, 65, '16.8000', 30, 0),
(10303, 68, '10.0000', 15, 0),
(10304, 49, '16.0000', 30, 0),
(10304, 59, '44.0000', 10, 0),
(10304, 71, '17.2000', 2, 0),
(10305, 18, '50.0000', 25, 0),
(10305, 29, '99.0000', 25, 0),
(10305, 39, '14.4000', 30, 0),
(10306, 30, '20.7000', 10, 0),
(10306, 53, '26.2000', 10, 0),
(10306, 54, '5.9000', 5, 0),
(10307, 62, '39.4000', 10, 0),
(10307, 68, '10.0000', 3, 0),
(10308, 69, '28.8000', 1, 0),
(10308, 70, '12.0000', 5, 0),
(10309, 4, '17.6000', 20, 0),
(10309, 6, '20.0000', 30, 0),
(10309, 42, '11.2000', 2, 0),
(10309, 43, '36.8000', 20, 0),
(10309, 71, '17.2000', 3, 0),
(10310, 16, '13.9000', 10, 0),
(10310, 62, '39.4000', 5, 0),
(10311, 42, '11.2000', 6, 0),
(10311, 69, '28.8000', 7, 0),
(10312, 28, '36.4000', 4, 0),
(10312, 43, '36.8000', 24, 0),
(10312, 53, '26.2000', 20, 0),
(10312, 75, '6.2000', 10, 0),
(10313, 36, '15.2000', 12, 0),
(10314, 32, '25.6000', 40, 0),
(10314, 58, '10.6000', 30, 0),
(10314, 62, '39.4000', 25, 0),
(10315, 34, '11.2000', 14, 0),
(10315, 70, '12.0000', 30, 0),
(10316, 41, '7.7000', 10, 0),
(10316, 62, '39.4000', 70, 0),
(10317, 1, '14.4000', 20, 0),
(10318, 41, '7.7000', 20, 0),
(10318, 76, '14.4000', 6, 0),
(10319, 17, '31.2000', 8, 0),
(10319, 28, '36.4000', 14, 0),
(10319, 76, '14.4000', 30, 0),
(10320, 71, '17.2000', 30, 0),
(10321, 35, '14.4000', 10, 0),
(10322, 52, '5.6000', 20, 0),
(10323, 15, '12.4000', 5, 0),
(10323, 25, '11.2000', 4, 0),
(10323, 39, '14.4000', 4, 0),
(10324, 16, '13.9000', 21, 0),
(10324, 35, '14.4000', 70, 0),
(10324, 46, '9.6000', 30, 0),
(10324, 59, '44.0000', 40, 0),
(10324, 63, '35.1000', 80, 0),
(10325, 6, '20.0000', 6, 0),
(10325, 13, '4.8000', 12, 0),
(10325, 14, '18.6000', 9, 0),
(10325, 31, '10.0000', 4, 0),
(10325, 72, '27.8000', 40, 0),
(10326, 4, '17.6000', 24, 0),
(10326, 57, '15.6000', 16, 0),
(10326, 75, '6.2000', 50, 0),
(10327, 2, '15.2000', 25, 0),
(10327, 11, '16.8000', 50, 0),
(10327, 30, '20.7000', 35, 0),
(10327, 58, '10.6000', 30, 0),
(10328, 59, '44.0000', 9, 0),
(10328, 65, '16.8000', 40, 0),
(10328, 68, '10.0000', 10, 0),
(10329, 19, '7.3000', 10, 0),
(10329, 30, '20.7000', 8, 0),
(10329, 38, '210.8000', 20, 0),
(10329, 56, '30.4000', 12, 0),
(10330, 26, '24.9000', 50, 0),
(10330, 72, '27.8000', 25, 0),
(10331, 54, '5.9000', 15, 0),
(10332, 18, '50.0000', 40, 0),
(10332, 42, '11.2000', 10, 0),
(10332, 47, '7.6000', 16, 0),
(10333, 14, '18.6000', 10, 0),
(10333, 21, '8.0000', 10, 0),
(10333, 71, '17.2000', 40, 0),
(10334, 52, '5.6000', 8, 0),
(10334, 68, '10.0000', 10, 0),
(10335, 2, '15.2000', 7, 0),
(10335, 31, '10.0000', 25, 0),
(10335, 32, '25.6000', 6, 0),
(10335, 51, '42.4000', 48, 0),
(10336, 4, '17.6000', 18, 0),
(10337, 23, '7.2000', 40, 0),
(10337, 26, '24.9000', 24, 0),
(10337, 36, '15.2000', 20, 0),
(10337, 37, '20.8000', 28, 0),
(10337, 72, '27.8000', 25, 0),
(10338, 17, '31.2000', 20, 0),
(10338, 30, '20.7000', 15, 0),
(10339, 4, '17.6000', 10, 0),
(10339, 17, '31.2000', 70, 0),
(10339, 62, '39.4000', 28, 0),
(10340, 18, '50.0000', 20, 0),
(10340, 41, '7.7000', 12, 0),
(10340, 43, '36.8000', 40, 0),
(10341, 33, '2.0000', 8, 0),
(10341, 59, '44.0000', 9, 0),
(10342, 2, '15.2000', 24, 0),
(10342, 31, '10.0000', 56, 0),
(10342, 36, '15.2000', 40, 0),
(10342, 55, '19.2000', 40, 0),
(10343, 64, '26.6000', 50, 0),
(10343, 68, '10.0000', 4, 0),
(10343, 76, '14.4000', 15, 0),
(10344, 4, '17.6000', 35, 0),
(10344, 8, '32.0000', 70, 0),
(10345, 8, '32.0000', 70, 0),
(10345, 19, '7.3000', 80, 0),
(10345, 42, '11.2000', 9, 0),
(10346, 17, '31.2000', 36, 0),
(10346, 56, '30.4000', 20, 0),
(10347, 25, '11.2000', 10, 0),
(10347, 39, '14.4000', 50, 0),
(10347, 40, '14.7000', 4, 0),
(10347, 75, '6.2000', 6, 0),
(10348, 1, '14.4000', 15, 0),
(10348, 23, '7.2000', 25, 0),
(10349, 54, '5.9000', 24, 0),
(10350, 50, '13.0000', 15, 0),
(10350, 69, '28.8000', 18, 0),
(10351, 38, '210.8000', 20, 0),
(10351, 41, '7.7000', 13, 0),
(10351, 44, '15.5000', 77, 0),
(10351, 65, '16.8000', 10, 0),
(10352, 24, '3.6000', 10, 0),
(10352, 54, '5.9000', 20, 0),
(10353, 11, '16.8000', 12, 0),
(10353, 38, '210.8000', 50, 0),
(10354, 1, '14.4000', 12, 0),
(10354, 29, '99.0000', 4, 0),
(10355, 24, '3.6000', 25, 0),
(10355, 57, '15.6000', 25, 0),
(10356, 31, '10.0000', 30, 0),
(10356, 55, '19.2000', 12, 0),
(10356, 69, '28.8000', 20, 0),
(10357, 10, '24.8000', 30, 0),
(10357, 26, '24.9000', 16, 0),
(10357, 60, '27.2000', 8, 0),
(10358, 24, '3.6000', 10, 0),
(10358, 34, '11.2000', 10, 0),
(10358, 36, '15.2000', 20, 0),
(10359, 16, '13.9000', 56, 0),
(10359, 31, '10.0000', 70, 0),
(10359, 60, '27.2000', 80, 0),
(10360, 28, '36.4000', 30, 0),
(10360, 29, '99.0000', 35, 0),
(10360, 38, '210.8000', 10, 0),
(10360, 49, '16.0000', 35, 0),
(10360, 54, '5.9000', 28, 0),
(10361, 39, '14.4000', 54, 0),
(10361, 60, '27.2000', 55, 0),
(10362, 25, '11.2000', 50, 0),
(10362, 51, '42.4000', 20, 0),
(10362, 54, '5.9000', 24, 0),
(10363, 31, '10.0000', 20, 0),
(10363, 75, '6.2000', 12, 0),
(10363, 76, '14.4000', 12, 0),
(10364, 69, '28.8000', 30, 0),
(10364, 71, '17.2000', 5, 0),
(10365, 11, '16.8000', 24, 0),
(10366, 65, '16.8000', 5, 0),
(10366, 77, '10.4000', 5, 0),
(10367, 34, '11.2000', 36, 0),
(10367, 54, '5.9000', 18, 0),
(10367, 65, '16.8000', 15, 0),
(10367, 77, '10.4000', 7, 0),
(10368, 21, '8.0000', 5, 0),
(10368, 28, '36.4000', 13, 0),
(10368, 57, '15.6000', 25, 0),
(10368, 64, '26.6000', 35, 0),
(10369, 29, '99.0000', 20, 0),
(10369, 56, '30.4000', 18, 0),
(10370, 1, '14.4000', 15, 0),
(10370, 64, '26.6000', 30, 0),
(10370, 74, '8.0000', 20, 0),
(10371, 36, '15.2000', 6, 0),
(10372, 20, '64.8000', 12, 0),
(10372, 38, '210.8000', 40, 0),
(10372, 60, '27.2000', 70, 0),
(10372, 72, '27.8000', 42, 0),
(10373, 58, '10.6000', 80, 0),
(10373, 71, '17.2000', 50, 0),
(10374, 31, '10.0000', 30, 0),
(10374, 58, '10.6000', 15, 0),
(10375, 14, '18.6000', 15, 0),
(10375, 54, '5.9000', 10, 0),
(10376, 31, '10.0000', 42, 0),
(10377, 28, '36.4000', 20, 0),
(10377, 39, '14.4000', 20, 0),
(10378, 71, '17.2000', 6, 0),
(10379, 41, '7.7000', 8, 0),
(10379, 63, '35.1000', 16, 0),
(10379, 65, '16.8000', 20, 0),
(10380, 30, '20.7000', 18, 0),
(10380, 53, '26.2000', 20, 0),
(10380, 60, '27.2000', 6, 0),
(10380, 70, '12.0000', 30, 0),
(10381, 74, '8.0000', 14, 0),
(10382, 5, '17.0000', 32, 0),
(10382, 18, '50.0000', 9, 0),
(10382, 29, '99.0000', 14, 0),
(10382, 33, '2.0000', 60, 0),
(10382, 74, '8.0000', 50, 0),
(10383, 13, '4.8000', 20, 0),
(10383, 50, '13.0000', 15, 0),
(10383, 56, '30.4000', 20, 0),
(10384, 20, '64.8000', 28, 0),
(10384, 60, '27.2000', 15, 0),
(10385, 7, '24.0000', 10, 0),
(10385, 60, '27.2000', 20, 0),
(10385, 68, '10.0000', 8, 0),
(10386, 24, '3.6000', 15, 0),
(10386, 34, '11.2000', 10, 0),
(10387, 24, '3.6000', 15, 0),
(10387, 28, '36.4000', 6, 0),
(10387, 59, '44.0000', 12, 0),
(10387, 71, '17.2000', 15, 0),
(10388, 45, '7.6000', 15, 0),
(10388, 52, '5.6000', 20, 0),
(10388, 53, '26.2000', 40, 0),
(10389, 10, '24.8000', 16, 0),
(10389, 55, '19.2000', 15, 0),
(10389, 62, '39.4000', 20, 0),
(10389, 70, '12.0000', 30, 0),
(10390, 31, '10.0000', 60, 0),
(10390, 35, '14.4000', 40, 0),
(10390, 46, '9.6000', 45, 0),
(10390, 72, '27.8000', 24, 0),
(10391, 13, '4.8000', 18, 0),
(10392, 69, '28.8000', 50, 0),
(10393, 2, '15.2000', 25, 0),
(10393, 14, '18.6000', 42, 0),
(10393, 25, '11.2000', 7, 0),
(10393, 26, '24.9000', 70, 0),
(10393, 31, '10.0000', 32, 0),
(10394, 13, '4.8000', 10, 0),
(10394, 62, '39.4000', 10, 0),
(10395, 46, '9.6000', 28, 0),
(10395, 53, '26.2000', 70, 0),
(10395, 69, '28.8000', 8, 0),
(10396, 23, '7.2000', 40, 0),
(10396, 71, '17.2000', 60, 0),
(10396, 72, '27.8000', 21, 0),
(10397, 21, '8.0000', 10, 0),
(10397, 51, '42.4000', 18, 0),
(10398, 35, '14.4000', 30, 0),
(10398, 55, '19.2000', 120, 0),
(10399, 68, '10.0000', 60, 0),
(10399, 71, '17.2000', 30, 0),
(10399, 76, '14.4000', 35, 0),
(10399, 77, '10.4000', 14, 0),
(10400, 29, '99.0000', 21, 0),
(10400, 35, '14.4000', 35, 0),
(10400, 49, '16.0000', 30, 0),
(10401, 30, '20.7000', 18, 0),
(10401, 56, '30.4000', 70, 0),
(10401, 65, '16.8000', 20, 0),
(10401, 71, '17.2000', 60, 0),
(10402, 23, '7.2000', 60, 0),
(10402, 63, '35.1000', 65, 0),
(10403, 16, '13.9000', 21, 0),
(10403, 48, '10.2000', 70, 0),
(10404, 26, '24.9000', 30, 0),
(10404, 42, '11.2000', 40, 0),
(10404, 49, '16.0000', 30, 0),
(10405, 3, '8.0000', 50, 0),
(10406, 1, '14.4000', 10, 0),
(10406, 21, '8.0000', 30, 0),
(10406, 28, '36.4000', 42, 0),
(10406, 36, '15.2000', 5, 0),
(10406, 40, '14.7000', 2, 0),
(10407, 11, '16.8000', 30, 0),
(10407, 69, '28.8000', 15, 0),
(10407, 71, '17.2000', 15, 0),
(10408, 37, '20.8000', 10, 0),
(10408, 54, '5.9000', 6, 0),
(10408, 62, '39.4000', 35, 0),
(10409, 14, '18.6000', 12, 0),
(10409, 21, '8.0000', 12, 0),
(10410, 33, '2.0000', 49, 0),
(10410, 59, '44.0000', 16, 0),
(10411, 41, '7.7000', 25, 0),
(10411, 44, '15.5000', 40, 0),
(10411, 59, '44.0000', 9, 0),
(10412, 14, '18.6000', 20, 0),
(10413, 1, '14.4000', 24, 0),
(10413, 62, '39.4000', 40, 0),
(10413, 76, '14.4000', 14, 0),
(10414, 19, '7.3000', 18, 0),
(10414, 33, '2.0000', 50, 0),
(10415, 17, '31.2000', 2, 0),
(10415, 33, '2.0000', 20, 0),
(10416, 19, '7.3000', 20, 0),
(10416, 53, '26.2000', 10, 0),
(10416, 57, '15.6000', 20, 0),
(10417, 38, '210.8000', 50, 0),
(10417, 46, '9.6000', 2, 0),
(10417, 68, '10.0000', 36, 0),
(10417, 77, '10.4000', 35, 0),
(10418, 2, '15.2000', 60, 0),
(10418, 47, '7.6000', 55, 0),
(10418, 61, '22.8000', 16, 0),
(10418, 74, '8.0000', 15, 0),
(10419, 60, '27.2000', 60, 0),
(10419, 69, '28.8000', 20, 0),
(10420, 9, '77.6000', 20, 0),
(10420, 13, '4.8000', 2, 0),
(10420, 70, '12.0000', 8, 0),
(10420, 73, '12.0000', 20, 0),
(10421, 19, '7.3000', 4, 0),
(10421, 26, '24.9000', 30, 0),
(10421, 53, '26.2000', 15, 0),
(10421, 77, '10.4000', 10, 0),
(10422, 26, '24.9000', 2, 0),
(10423, 31, '10.0000', 14, 0),
(10423, 59, '44.0000', 20, 0),
(10424, 35, '14.4000', 60, 0),
(10424, 38, '210.8000', 49, 0),
(10424, 68, '10.0000', 30, 0),
(10425, 55, '19.2000', 10, 0),
(10425, 76, '14.4000', 20, 0),
(10426, 56, '30.4000', 5, 0),
(10426, 64, '26.6000', 7, 0),
(10427, 14, '18.6000', 35, 0),
(10428, 46, '9.6000', 20, 0),
(10429, 50, '13.0000', 40, 0),
(10429, 63, '35.1000', 35, 0),
(10430, 17, '31.2000', 45, 0),
(10430, 21, '8.0000', 50, 0),
(10430, 56, '30.4000', 30, 0),
(10430, 59, '44.0000', 70, 0),
(10431, 17, '31.2000', 50, 0),
(10431, 40, '14.7000', 50, 0),
(10431, 47, '7.6000', 30, 0),
(10432, 26, '24.9000', 10, 0),
(10432, 54, '5.9000', 40, 0),
(10433, 56, '30.4000', 28, 0),
(10434, 11, '16.8000', 6, 0),
(10434, 76, '14.4000', 18, 0),
(10435, 2, '15.2000', 10, 0),
(10435, 22, '16.8000', 12, 0),
(10435, 72, '27.8000', 10, 0),
(10436, 46, '9.6000', 5, 0),
(10436, 56, '30.4000', 40, 0),
(10436, 64, '26.6000', 30, 0),
(10436, 75, '6.2000', 24, 0),
(10437, 53, '26.2000', 15, 0),
(10438, 19, '7.3000', 15, 0),
(10438, 34, '11.2000', 20, 0),
(10438, 57, '15.6000', 15, 0),
(10439, 12, '30.4000', 15, 0),
(10439, 16, '13.9000', 16, 0),
(10439, 64, '26.6000', 6, 0),
(10439, 74, '8.0000', 30, 0),
(10440, 2, '15.2000', 45, 0),
(10440, 16, '13.9000', 49, 0),
(10440, 29, '99.0000', 24, 0),
(10440, 61, '22.8000', 90, 0),
(10441, 27, '35.1000', 50, 0),
(10442, 11, '16.8000', 30, 0),
(10442, 54, '5.9000', 80, 0),
(10442, 66, '13.6000', 60, 0),
(10443, 11, '16.8000', 6, 0),
(10443, 28, '36.4000', 12, 0),
(10444, 17, '31.2000', 10, 0),
(10444, 26, '24.9000', 15, 0),
(10444, 35, '14.4000', 8, 0),
(10444, 41, '7.7000', 30, 0),
(10445, 39, '14.4000', 6, 0),
(10445, 54, '5.9000', 15, 0),
(10446, 19, '7.3000', 12, 0),
(10446, 24, '3.6000', 20, 0),
(10446, 31, '10.0000', 3, 0),
(10446, 52, '5.6000', 15, 0),
(10447, 19, '7.3000', 40, 0),
(10447, 65, '16.8000', 35, 0),
(10447, 71, '17.2000', 2, 0),
(10448, 26, '24.9000', 6, 0),
(10448, 40, '14.7000', 20, 0),
(10449, 10, '24.8000', 14, 0),
(10449, 52, '5.6000', 20, 0),
(10449, 62, '39.4000', 35, 0),
(10450, 10, '24.8000', 20, 0),
(10450, 54, '5.9000', 6, 0),
(10451, 55, '19.2000', 120, 0),
(10451, 64, '26.6000', 35, 0),
(10451, 65, '16.8000', 28, 0),
(10451, 77, '10.4000', 55, 0),
(10452, 28, '36.4000', 15, 0),
(10452, 44, '15.5000', 100, 0),
(10453, 48, '10.2000', 15, 0),
(10453, 70, '12.0000', 25, 0),
(10454, 16, '13.9000', 20, 0),
(10454, 33, '2.0000', 20, 0),
(10454, 46, '9.6000', 10, 0),
(10455, 39, '14.4000', 20, 0),
(10455, 53, '26.2000', 50, 0),
(10455, 61, '22.8000', 25, 0),
(10455, 71, '17.2000', 30, 0),
(10456, 21, '8.0000', 40, 0),
(10456, 49, '16.0000', 21, 0),
(10457, 59, '44.0000', 36, 0),
(10458, 26, '24.9000', 30, 0),
(10458, 28, '36.4000', 30, 0),
(10458, 43, '36.8000', 20, 0),
(10458, 56, '30.4000', 15, 0),
(10458, 71, '17.2000', 50, 0),
(10459, 7, '24.0000', 16, 0),
(10459, 46, '9.6000', 20, 0),
(10459, 72, '27.8000', 40, 0),
(10460, 68, '10.0000', 21, 0),
(10460, 75, '6.2000', 4, 0),
(10461, 21, '8.0000', 40, 0),
(10461, 30, '20.7000', 28, 0),
(10461, 55, '19.2000', 60, 0),
(10462, 13, '4.8000', 1, 0),
(10462, 23, '7.2000', 21, 0),
(10463, 19, '7.3000', 21, 0),
(10463, 42, '11.2000', 50, 0),
(10464, 4, '17.6000', 16, 0),
(10464, 43, '36.8000', 3, 0),
(10464, 56, '30.4000', 30, 0),
(10464, 60, '27.2000', 20, 0),
(10465, 24, '3.6000', 25, 0),
(10465, 29, '99.0000', 18, 0),
(10465, 40, '14.7000', 20, 0),
(10465, 45, '7.6000', 30, 0),
(10465, 50, '13.0000', 25, 0),
(10466, 11, '16.8000', 10, 0),
(10466, 46, '9.6000', 5, 0),
(10467, 24, '3.6000', 28, 0),
(10467, 25, '11.2000', 12, 0),
(10468, 30, '20.7000', 8, 0),
(10468, 43, '36.8000', 15, 0),
(10469, 2, '15.2000', 40, 0),
(10469, 16, '13.9000', 35, 0),
(10469, 44, '15.5000', 2, 0),
(10470, 18, '50.0000', 30, 0),
(10470, 23, '7.2000', 15, 0),
(10470, 64, '26.6000', 8, 0),
(10471, 7, '24.0000', 30, 0),
(10471, 56, '30.4000', 20, 0),
(10472, 24, '3.6000', 80, 0),
(10472, 51, '42.4000', 18, 0),
(10473, 33, '2.0000', 12, 0),
(10473, 71, '17.2000', 12, 0),
(10474, 14, '18.6000', 12, 0),
(10474, 28, '36.4000', 18, 0),
(10474, 40, '14.7000', 21, 0),
(10474, 75, '6.2000', 10, 0),
(10475, 31, '10.0000', 35, 0),
(10475, 66, '13.6000', 60, 0),
(10475, 76, '14.4000', 42, 0),
(10476, 55, '19.2000', 2, 0),
(10476, 70, '12.0000', 12, 0),
(10477, 1, '14.4000', 15, 0),
(10477, 21, '8.0000', 21, 0),
(10477, 39, '14.4000', 20, 0),
(10478, 10, '24.8000', 20, 0),
(10479, 38, '210.8000', 30, 0),
(10479, 53, '26.2000', 28, 0),
(10479, 59, '44.0000', 60, 0),
(10479, 64, '26.6000', 30, 0),
(10480, 47, '7.6000', 30, 0),
(10480, 59, '44.0000', 12, 0),
(10481, 49, '16.0000', 24, 0),
(10481, 60, '27.2000', 40, 0),
(10482, 40, '14.7000', 10, 0),
(10483, 34, '11.2000', 35, 0),
(10483, 77, '10.4000', 30, 0),
(10484, 21, '8.0000', 14, 0),
(10484, 40, '14.7000', 10, 0),
(10484, 51, '42.4000', 3, 0),
(10485, 2, '15.2000', 20, 0),
(10485, 3, '8.0000', 20, 0),
(10485, 55, '19.2000', 30, 0),
(10485, 70, '12.0000', 60, 0),
(10486, 11, '16.8000', 5, 0),
(10486, 51, '42.4000', 25, 0),
(10486, 74, '8.0000', 16, 0),
(10487, 19, '7.3000', 5, 0),
(10487, 26, '24.9000', 30, 0),
(10487, 54, '5.9000', 24, 0),
(10488, 59, '44.0000', 30, 0),
(10488, 73, '12.0000', 20, 0),
(10489, 11, '16.8000', 15, 0),
(10489, 16, '13.9000', 18, 0),
(10490, 59, '44.0000', 60, 0),
(10490, 68, '10.0000', 30, 0),
(10490, 75, '6.2000', 36, 0),
(10491, 44, '15.5000', 15, 0),
(10491, 77, '10.4000', 7, 0),
(10492, 25, '11.2000', 60, 0),
(10492, 42, '11.2000', 20, 0),
(10493, 65, '16.8000', 15, 0),
(10493, 66, '13.6000', 10, 0),
(10493, 69, '28.8000', 10, 0),
(10494, 56, '30.4000', 30, 0),
(10495, 23, '7.2000', 10, 0),
(10495, 41, '7.7000', 20, 0),
(10495, 77, '10.4000', 5, 0),
(10496, 31, '10.0000', 20, 0),
(10497, 56, '30.4000', 14, 0),
(10497, 72, '27.8000', 25, 0),
(10497, 77, '10.4000', 25, 0),
(10498, 24, '4.5000', 14, 0),
(10498, 40, '18.4000', 5, 0),
(10498, 42, '14.0000', 30, 0),
(10499, 28, '45.6000', 20, 0),
(10499, 49, '20.0000', 25, 0),
(10500, 15, '15.5000', 12, 0),
(10500, 28, '45.6000', 8, 0),
(10501, 54, '7.4500', 20, 0),
(10502, 45, '9.5000', 21, 0),
(10502, 53, '32.8000', 6, 0),
(10502, 67, '14.0000', 30, 0),
(10503, 14, '23.2500', 70, 0),
(10503, 65, '21.0500', 20, 0),
(10504, 2, '19.0000', 12, 0),
(10504, 21, '10.0000', 12, 0),
(10504, 53, '32.8000', 10, 0),
(10504, 61, '28.5000', 25, 0),
(10505, 62, '49.3000', 3, 0),
(10506, 25, '14.0000', 18, 0),
(10506, 70, '15.0000', 14, 0),
(10507, 43, '46.0000', 15, 0),
(10507, 48, '12.7500', 15, 0),
(10508, 13, '6.0000', 10, 0),
(10508, 39, '18.0000', 10, 0),
(10509, 28, '45.6000', 3, 0),
(10510, 29, '123.7900', 36, 0),
(10510, 75, '7.7500', 36, 0),
(10511, 4, '22.0000', 50, 0),
(10511, 7, '30.0000', 50, 0),
(10511, 8, '40.0000', 10, 0),
(10512, 24, '4.5000', 10, 0),
(10512, 46, '12.0000', 9, 0),
(10512, 47, '9.5000', 6, 0),
(10512, 60, '34.0000', 12, 0),
(10513, 21, '10.0000', 40, 0),
(10513, 32, '32.0000', 50, 0),
(10513, 61, '28.5000', 15, 0),
(10514, 20, '81.0000', 39, 0),
(10514, 28, '45.6000', 35, 0),
(10514, 56, '38.0000', 70, 0),
(10514, 65, '21.0500', 39, 0),
(10514, 75, '7.7500', 50, 0),
(10515, 9, '97.0000', 16, 0),
(10515, 16, '17.4500', 50, 0),
(10515, 27, '43.9000', 120, 0),
(10515, 33, '2.5000', 16, 0),
(10515, 60, '34.0000', 84, 0),
(10516, 18, '62.5000', 25, 0),
(10516, 41, '9.6500', 80, 0),
(10516, 42, '14.0000', 20, 0),
(10517, 52, '7.0000', 6, 0),
(10517, 59, '55.0000', 4, 0),
(10517, 70, '15.0000', 6, 0),
(10518, 24, '4.5000', 5, 0),
(10518, 38, '263.5000', 15, 0),
(10518, 44, '19.4500', 9, 0),
(10519, 10, '31.0000', 16, 0),
(10519, 56, '38.0000', 40, 0),
(10519, 60, '34.0000', 10, 0),
(10520, 24, '4.5000', 8, 0),
(10520, 53, '32.8000', 5, 0),
(10521, 35, '18.0000', 3, 0),
(10521, 41, '9.6500', 10, 0),
(10521, 68, '12.5000', 6, 0),
(10522, 1, '18.0000', 40, 0),
(10522, 8, '40.0000', 24, 0),
(10522, 30, '25.8900', 20, 0),
(10522, 40, '18.4000', 25, 0),
(10523, 17, '39.0000', 25, 0),
(10523, 20, '81.0000', 15, 0),
(10523, 37, '26.0000', 18, 0),
(10523, 41, '9.6500', 6, 0),
(10524, 10, '31.0000', 2, 0),
(10524, 30, '25.8900', 10, 0),
(10524, 43, '46.0000', 60, 0),
(10524, 54, '7.4500', 15, 0),
(10525, 36, '19.0000', 30, 0),
(10525, 40, '18.4000', 15, 0),
(10526, 1, '18.0000', 8, 0),
(10526, 13, '6.0000', 10, 0),
(10526, 56, '38.0000', 30, 0),
(10527, 4, '22.0000', 50, 0),
(10527, 36, '19.0000', 30, 0),
(10528, 11, '21.0000', 3, 0),
(10528, 33, '2.5000', 8, 0),
(10528, 72, '34.8000', 9, 0),
(10529, 55, '24.0000', 14, 0),
(10529, 68, '12.5000', 20, 0),
(10529, 69, '36.0000', 10, 0),
(10530, 17, '39.0000', 40, 0),
(10530, 43, '46.0000', 25, 0),
(10530, 61, '28.5000', 20, 0),
(10530, 76, '18.0000', 50, 0),
(10531, 59, '55.0000', 2, 0),
(10532, 30, '25.8900', 15, 0),
(10532, 66, '17.0000', 24, 0),
(10533, 4, '22.0000', 50, 0),
(10533, 72, '34.8000', 24, 0),
(10533, 73, '15.0000', 24, 0),
(10534, 30, '25.8900', 10, 0),
(10534, 40, '18.4000', 10, 0),
(10534, 54, '7.4500', 10, 0),
(10535, 11, '21.0000', 50, 0),
(10535, 40, '18.4000', 10, 0),
(10535, 57, '19.5000', 5, 0),
(10535, 59, '55.0000', 15, 0),
(10536, 12, '38.0000', 15, 0),
(10536, 31, '12.5000', 20, 0),
(10536, 33, '2.5000', 30, 0),
(10536, 60, '34.0000', 35, 0),
(10537, 31, '12.5000', 30, 0),
(10537, 51, '53.0000', 6, 0),
(10537, 58, '13.2500', 20, 0),
(10537, 72, '34.8000', 21, 0),
(10537, 73, '15.0000', 9, 0),
(10538, 70, '15.0000', 7, 0),
(10538, 72, '34.8000', 1, 0),
(10539, 13, '6.0000', 8, 0),
(10539, 21, '10.0000', 15, 0),
(10539, 33, '2.5000', 15, 0),
(10539, 49, '20.0000', 6, 0),
(10540, 3, '10.0000', 60, 0),
(10540, 26, '31.2300', 40, 0),
(10540, 38, '263.5000', 30, 0),
(10540, 68, '12.5000', 35, 0),
(10541, 24, '4.5000', 35, 0),
(10541, 38, '263.5000', 4, 0),
(10541, 65, '21.0500', 36, 0),
(10541, 71, '21.5000', 9, 0),
(10542, 11, '21.0000', 15, 0),
(10542, 54, '7.4500', 24, 0),
(10543, 12, '38.0000', 30, 0),
(10543, 23, '9.0000', 70, 0),
(10544, 28, '45.6000', 7, 0),
(10544, 67, '14.0000', 7, 0),
(10545, 11, '21.0000', 10, 0),
(10546, 7, '30.0000', 10, 0),
(10546, 35, '18.0000', 30, 0),
(10546, 62, '49.3000', 40, 0),
(10547, 32, '32.0000', 24, 0),
(10547, 36, '19.0000', 60, 0),
(10548, 34, '14.0000', 10, 0),
(10548, 41, '9.6500', 14, 0),
(10549, 31, '12.5000', 55, 0),
(10549, 45, '9.5000', 100, 0),
(10549, 51, '53.0000', 48, 0),
(10550, 17, '39.0000', 8, 0),
(10550, 19, '9.2000', 10, 0),
(10550, 21, '10.0000', 6, 0),
(10550, 61, '28.5000', 10, 0),
(10551, 16, '17.4500', 40, 0),
(10551, 35, '18.0000', 20, 0),
(10551, 44, '19.4500', 40, 0),
(10552, 69, '36.0000', 18, 0),
(10552, 75, '7.7500', 30, 0),
(10553, 11, '21.0000', 15, 0),
(10553, 16, '17.4500', 14, 0),
(10553, 22, '21.0000', 24, 0),
(10553, 31, '12.5000', 30, 0),
(10553, 35, '18.0000', 6, 0),
(10554, 16, '17.4500', 30, 0),
(10554, 23, '9.0000', 20, 0),
(10554, 62, '49.3000', 20, 0),
(10554, 77, '13.0000', 10, 0),
(10555, 14, '23.2500', 30, 0),
(10555, 19, '9.2000', 35, 0),
(10555, 24, '4.5000', 18, 0),
(10555, 51, '53.0000', 20, 0),
(10555, 56, '38.0000', 40, 0),
(10556, 72, '34.8000', 24, 0),
(10557, 64, '33.2500', 30, 0),
(10557, 75, '7.7500', 20, 0),
(10558, 47, '9.5000', 25, 0),
(10558, 51, '53.0000', 20, 0),
(10558, 52, '7.0000', 30, 0),
(10558, 53, '32.8000', 18, 0),
(10558, 73, '15.0000', 3, 0),
(10559, 41, '9.6500', 12, 0),
(10559, 55, '24.0000', 18, 0),
(10560, 30, '25.8900', 20, 0),
(10560, 62, '49.3000', 15, 0),
(10561, 44, '19.4500', 10, 0),
(10561, 51, '53.0000', 50, 0),
(10562, 33, '2.5000', 20, 0),
(10562, 62, '49.3000', 10, 0),
(10563, 36, '19.0000', 25, 0),
(10563, 52, '7.0000', 70, 0),
(10564, 17, '39.0000', 16, 0),
(10564, 31, '12.5000', 6, 0),
(10564, 55, '24.0000', 25, 0),
(10565, 24, '4.5000', 25, 0),
(10565, 64, '33.2500', 18, 0),
(10566, 11, '21.0000', 35, 0),
(10566, 18, '62.5000', 18, 0),
(10566, 76, '18.0000', 10, 0),
(10567, 31, '12.5000', 60, 0),
(10567, 51, '53.0000', 3, 0),
(10567, 59, '55.0000', 40, 0),
(10568, 10, '31.0000', 5, 0),
(10569, 31, '12.5000', 35, 0),
(10569, 76, '18.0000', 30, 0),
(10570, 11, '21.0000', 15, 0),
(10570, 56, '38.0000', 60, 0),
(10571, 14, '23.2500', 11, 0),
(10571, 42, '14.0000', 28, 0),
(10572, 16, '17.4500', 12, 0),
(10572, 32, '32.0000', 10, 0),
(10572, 40, '18.4000', 50, 0),
(10572, 75, '7.7500', 15, 0),
(10573, 17, '39.0000', 18, 0),
(10573, 34, '14.0000', 40, 0),
(10573, 53, '32.8000', 25, 0),
(10574, 33, '2.5000', 14, 0),
(10574, 40, '18.4000', 2, 0),
(10574, 62, '49.3000', 10, 0),
(10574, 64, '33.2500', 6, 0),
(10575, 59, '55.0000', 12, 0),
(10575, 63, '43.9000', 6, 0),
(10575, 72, '34.8000', 30, 0),
(10575, 76, '18.0000', 10, 0),
(10576, 1, '18.0000', 10, 0),
(10576, 31, '12.5000', 20, 0),
(10576, 44, '19.4500', 21, 0),
(10577, 39, '18.0000', 10, 0),
(10577, 75, '7.7500', 20, 0),
(10577, 77, '13.0000', 18, 0),
(10578, 35, '18.0000', 20, 0),
(10578, 57, '19.5000', 6, 0),
(10579, 15, '15.5000', 10, 0),
(10579, 75, '7.7500', 21, 0),
(10580, 14, '23.2500', 15, 0),
(10580, 41, '9.6500', 9, 0),
(10580, 65, '21.0500', 30, 0),
(10581, 75, '7.7500', 50, 0),
(10582, 57, '19.5000', 4, 0),
(10582, 76, '18.0000', 14, 0),
(10583, 29, '123.7900', 10, 0),
(10583, 60, '34.0000', 24, 0),
(10583, 69, '36.0000', 10, 0),
(10584, 31, '12.5000', 50, 0),
(10585, 47, '9.5000', 15, 0),
(10586, 52, '7.0000', 4, 0),
(10587, 26, '31.2300', 6, 0),
(10587, 35, '18.0000', 20, 0),
(10587, 77, '13.0000', 20, 0),
(10588, 18, '62.5000', 40, 0),
(10588, 42, '14.0000', 100, 0),
(10589, 35, '18.0000', 4, 0),
(10590, 1, '18.0000', 20, 0),
(10590, 77, '13.0000', 60, 0),
(10591, 3, '10.0000', 14, 0),
(10591, 7, '30.0000', 10, 0),
(10591, 54, '7.4500', 50, 0),
(10592, 15, '15.5000', 25, 0),
(10592, 26, '31.2300', 5, 0),
(10593, 20, '81.0000', 21, 0),
(10593, 69, '36.0000', 20, 0),
(10593, 76, '18.0000', 4, 0),
(10594, 52, '7.0000', 24, 0),
(10594, 58, '13.2500', 30, 0),
(10595, 35, '18.0000', 30, 0),
(10595, 61, '28.5000', 120, 0),
(10595, 69, '36.0000', 65, 0),
(10596, 56, '38.0000', 5, 0),
(10596, 63, '43.9000', 24, 0),
(10596, 75, '7.7500', 30, 0),
(10597, 24, '4.5000', 35, 0),
(10597, 57, '19.5000', 20, 0),
(10597, 65, '21.0500', 12, 0),
(10598, 27, '43.9000', 50, 0),
(10598, 71, '21.5000', 9, 0),
(10599, 62, '49.3000', 10, 0),
(10600, 54, '7.4500', 4, 0),
(10600, 73, '15.0000', 30, 0),
(10601, 13, '6.0000', 60, 0),
(10601, 59, '55.0000', 35, 0),
(10602, 77, '13.0000', 5, 0),
(10603, 22, '21.0000', 48, 0),
(10603, 49, '20.0000', 25, 0),
(10604, 48, '12.7500', 6, 0),
(10604, 76, '18.0000', 10, 0),
(10605, 16, '17.4500', 30, 0),
(10605, 59, '55.0000', 20, 0),
(10605, 60, '34.0000', 70, 0),
(10605, 71, '21.5000', 15, 0),
(10606, 4, '22.0000', 20, 0),
(10606, 55, '24.0000', 20, 0),
(10606, 62, '49.3000', 10, 0),
(10607, 7, '30.0000', 45, 0),
(10607, 17, '39.0000', 100, 0),
(10607, 33, '2.5000', 14, 0),
(10607, 40, '18.4000', 42, 0),
(10607, 72, '34.8000', 12, 0),
(10608, 56, '38.0000', 28, 0),
(10609, 1, '18.0000', 3, 0),
(10609, 10, '31.0000', 10, 0),
(10609, 21, '10.0000', 6, 0),
(10610, 36, '19.0000', 21, 0),
(10611, 1, '18.0000', 6, 0),
(10611, 2, '19.0000', 10, 0),
(10611, 60, '34.0000', 15, 0),
(10612, 10, '31.0000', 70, 0),
(10612, 36, '19.0000', 55, 0),
(10612, 49, '20.0000', 18, 0),
(10612, 60, '34.0000', 40, 0),
(10612, 76, '18.0000', 80, 0),
(10613, 13, '6.0000', 8, 0),
(10613, 75, '7.7500', 40, 0),
(10614, 11, '21.0000', 14, 0),
(10614, 21, '10.0000', 8, 0),
(10614, 39, '18.0000', 5, 0),
(10615, 55, '24.0000', 5, 0),
(10616, 38, '263.5000', 15, 0),
(10616, 56, '38.0000', 14, 0),
(10616, 70, '15.0000', 15, 0),
(10616, 71, '21.5000', 15, 0),
(10617, 59, '55.0000', 30, 0),
(10618, 6, '25.0000', 70, 0),
(10618, 56, '38.0000', 20, 0),
(10618, 68, '12.5000', 15, 0),
(10619, 21, '10.0000', 42, 0),
(10619, 22, '21.0000', 40, 0),
(10620, 24, '4.5000', 5, 0),
(10620, 52, '7.0000', 5, 0),
(10621, 19, '9.2000', 5, 0),
(10621, 23, '9.0000', 10, 0),
(10621, 70, '15.0000', 20, 0),
(10621, 71, '21.5000', 15, 0),
(10622, 2, '19.0000', 20, 0),
(10622, 68, '12.5000', 18, 0),
(10623, 14, '23.2500', 21, 0),
(10623, 19, '9.2000', 15, 0),
(10623, 21, '10.0000', 25, 0),
(10623, 24, '4.5000', 3, 0),
(10623, 35, '18.0000', 30, 0),
(10624, 28, '45.6000', 10, 0),
(10624, 29, '123.7900', 6, 0),
(10624, 44, '19.4500', 10, 0),
(10625, 14, '23.2500', 3, 0),
(10625, 42, '14.0000', 5, 0),
(10625, 60, '34.0000', 10, 0),
(10626, 53, '32.8000', 12, 0),
(10626, 60, '34.0000', 20, 0),
(10626, 71, '21.5000', 20, 0),
(10627, 62, '49.3000', 15, 0),
(10627, 73, '15.0000', 35, 0),
(10628, 1, '18.0000', 25, 0),
(10629, 29, '123.7900', 20, 0),
(10629, 64, '33.2500', 9, 0),
(10630, 55, '24.0000', 12, 0),
(10630, 76, '18.0000', 35, 0),
(10631, 75, '7.7500', 8, 0),
(10632, 2, '19.0000', 30, 0),
(10632, 33, '2.5000', 20, 0),
(10633, 12, '38.0000', 36, 0),
(10633, 13, '6.0000', 13, 0),
(10633, 26, '31.2300', 35, 0),
(10633, 62, '49.3000', 80, 0),
(10634, 7, '30.0000', 35, 0),
(10634, 18, '62.5000', 50, 0),
(10634, 51, '53.0000', 15, 0),
(10634, 75, '7.7500', 2, 0),
(10635, 4, '22.0000', 10, 0),
(10635, 5, '21.3500', 15, 0),
(10635, 22, '21.0000', 40, 0),
(10636, 4, '22.0000', 25, 0),
(10636, 58, '13.2500', 6, 0),
(10637, 11, '21.0000', 10, 0),
(10637, 50, '16.2500', 25, 0),
(10637, 56, '38.0000', 60, 0),
(10638, 45, '9.5000', 20, 0),
(10638, 65, '21.0500', 21, 0),
(10638, 72, '34.8000', 60, 0),
(10639, 18, '62.5000', 8, 0),
(10640, 69, '36.0000', 20, 0),
(10640, 70, '15.0000', 15, 0),
(10641, 2, '19.0000', 50, 0),
(10641, 40, '18.4000', 60, 0),
(10642, 21, '10.0000', 30, 0),
(10642, 61, '28.5000', 20, 0),
(10643, 28, '45.6000', 15, 0),
(10643, 39, '18.0000', 21, 0),
(10643, 46, '12.0000', 2, 0),
(10644, 18, '62.5000', 4, 0),
(10644, 43, '46.0000', 20, 0),
(10644, 46, '12.0000', 21, 0),
(10645, 18, '62.5000', 20, 0),
(10645, 36, '19.0000', 15, 0),
(10646, 1, '18.0000', 15, 0),
(10646, 10, '31.0000', 18, 0),
(10646, 71, '21.5000', 30, 0),
(10646, 77, '13.0000', 35, 0),
(10647, 19, '9.2000', 30, 0),
(10647, 39, '18.0000', 20, 0),
(10648, 22, '21.0000', 15, 0),
(10648, 24, '4.5000', 15, 0),
(10649, 28, '45.6000', 20, 0),
(10649, 72, '34.8000', 15, 0),
(10650, 30, '25.8900', 30, 0),
(10650, 53, '32.8000', 25, 0),
(10650, 54, '7.4500', 30, 0),
(10651, 19, '9.2000', 12, 0),
(10651, 22, '21.0000', 20, 0),
(10652, 30, '25.8900', 2, 0),
(10652, 42, '14.0000', 20, 0),
(10653, 16, '17.4500', 30, 0),
(10653, 60, '34.0000', 20, 0),
(10654, 4, '22.0000', 12, 0),
(10654, 39, '18.0000', 20, 0),
(10654, 54, '7.4500', 6, 0),
(10655, 41, '9.6500', 20, 0),
(10656, 14, '23.2500', 3, 0),
(10656, 44, '19.4500', 28, 0),
(10656, 47, '9.5000', 6, 0),
(10657, 15, '15.5000', 50, 0),
(10657, 41, '9.6500', 24, 0),
(10657, 46, '12.0000', 45, 0),
(10657, 47, '9.5000', 10, 0),
(10657, 56, '38.0000', 45, 0),
(10657, 60, '34.0000', 30, 0),
(10658, 21, '10.0000', 60, 0),
(10658, 40, '18.4000', 70, 0),
(10658, 60, '34.0000', 55, 0),
(10658, 77, '13.0000', 70, 0),
(10659, 31, '12.5000', 20, 0),
(10659, 40, '18.4000', 24, 0),
(10659, 70, '15.0000', 40, 0),
(10660, 20, '81.0000', 21, 0),
(10661, 39, '18.0000', 3, 0),
(10661, 58, '13.2500', 49, 0),
(10662, 68, '12.5000', 10, 0),
(10663, 40, '18.4000', 30, 0),
(10663, 42, '14.0000', 30, 0),
(10663, 51, '53.0000', 20, 0),
(10664, 10, '31.0000', 24, 0),
(10664, 56, '38.0000', 12, 0),
(10664, 65, '21.0500', 15, 0),
(10665, 51, '53.0000', 20, 0),
(10665, 59, '55.0000', 1, 0),
(10665, 76, '18.0000', 10, 0),
(10666, 29, '123.7900', 36, 0),
(10666, 65, '21.0500', 10, 0),
(10667, 69, '36.0000', 45, 0),
(10667, 71, '21.5000', 14, 0),
(10668, 31, '12.5000', 8, 0),
(10668, 55, '24.0000', 4, 0),
(10668, 64, '33.2500', 15, 0),
(10669, 36, '19.0000', 30, 0),
(10670, 23, '9.0000', 32, 0),
(10670, 46, '12.0000', 60, 0),
(10670, 67, '14.0000', 25, 0),
(10670, 73, '15.0000', 50, 0),
(10670, 75, '7.7500', 25, 0),
(10671, 16, '17.4500', 10, 0),
(10671, 62, '49.3000', 10, 0),
(10671, 65, '21.0500', 12, 0),
(10672, 38, '263.5000', 15, 0),
(10672, 71, '21.5000', 12, 0),
(10673, 16, '17.4500', 3, 0),
(10673, 42, '14.0000', 6, 0),
(10673, 43, '46.0000', 6, 0),
(10674, 23, '9.0000', 5, 0),
(10675, 14, '23.2500', 30, 0),
(10675, 53, '32.8000', 10, 0),
(10675, 58, '13.2500', 30, 0),
(10676, 10, '31.0000', 2, 0),
(10676, 19, '9.2000', 7, 0),
(10676, 44, '19.4500', 21, 0),
(10677, 26, '31.2300', 30, 0),
(10677, 33, '2.5000', 8, 0),
(10678, 12, '38.0000', 100, 0),
(10678, 33, '2.5000', 30, 0),
(10678, 41, '9.6500', 120, 0),
(10678, 54, '7.4500', 30, 0),
(10679, 59, '55.0000', 12, 0),
(10680, 16, '17.4500', 50, 0),
(10680, 31, '12.5000', 20, 0),
(10680, 42, '14.0000', 40, 0),
(10681, 19, '9.2000', 30, 0),
(10681, 21, '10.0000', 12, 0),
(10681, 64, '33.2500', 28, 0),
(10682, 33, '2.5000', 30, 0),
(10682, 66, '17.0000', 4, 0),
(10682, 75, '7.7500', 30, 0),
(10683, 52, '7.0000', 9, 0),
(10684, 40, '18.4000', 20, 0),
(10684, 47, '9.5000', 40, 0),
(10684, 60, '34.0000', 30, 0),
(10685, 10, '31.0000', 20, 0),
(10685, 41, '9.6500', 4, 0),
(10685, 47, '9.5000', 15, 0),
(10686, 17, '39.0000', 30, 0),
(10686, 26, '31.2300', 15, 0),
(10687, 9, '97.0000', 50, 0),
(10687, 29, '123.7900', 10, 0),
(10687, 36, '19.0000', 6, 0),
(10688, 10, '31.0000', 18, 0),
(10688, 28, '45.6000', 60, 0),
(10688, 34, '14.0000', 14, 0),
(10689, 1, '18.0000', 35, 0),
(10690, 56, '38.0000', 20, 0),
(10690, 77, '13.0000', 30, 0),
(10691, 1, '18.0000', 30, 0),
(10691, 29, '123.7900', 40, 0),
(10691, 43, '46.0000', 40, 0),
(10691, 44, '19.4500', 24, 0),
(10691, 62, '49.3000', 48, 0),
(10692, 63, '43.9000', 20, 0),
(10693, 9, '97.0000', 6, 0),
(10693, 54, '7.4500', 60, 0),
(10693, 69, '36.0000', 30, 0),
(10693, 73, '15.0000', 15, 0),
(10694, 7, '30.0000', 90, 0),
(10694, 59, '55.0000', 25, 0),
(10694, 70, '15.0000', 50, 0),
(10695, 8, '40.0000', 10, 0),
(10695, 12, '38.0000', 4, 0),
(10695, 24, '4.5000', 20, 0),
(10696, 17, '39.0000', 20, 0),
(10696, 46, '12.0000', 18, 0),
(10697, 19, '9.2000', 7, 0),
(10697, 35, '18.0000', 9, 0),
(10697, 58, '13.2500', 30, 0),
(10697, 70, '15.0000', 30, 0),
(10698, 11, '21.0000', 15, 0),
(10698, 17, '39.0000', 8, 0),
(10698, 29, '123.7900', 12, 0),
(10698, 65, '21.0500', 65, 0),
(10698, 70, '15.0000', 8, 0),
(10699, 47, '9.5000', 12, 0),
(10700, 1, '18.0000', 5, 0),
(10700, 34, '14.0000', 12, 0),
(10700, 68, '12.5000', 40, 0),
(10700, 71, '21.5000', 60, 0),
(10701, 59, '55.0000', 42, 0),
(10701, 71, '21.5000', 20, 0),
(10701, 76, '18.0000', 35, 0),
(10702, 3, '10.0000', 6, 0),
(10702, 76, '18.0000', 15, 0),
(10703, 2, '19.0000', 5, 0),
(10703, 59, '55.0000', 35, 0),
(10703, 73, '15.0000', 35, 0),
(10704, 4, '22.0000', 6, 0),
(10704, 24, '4.5000', 35, 0),
(10704, 48, '12.7500', 24, 0),
(10705, 31, '12.5000', 20, 0),
(10705, 32, '32.0000', 4, 0),
(10706, 16, '17.4500', 20, 0),
(10706, 43, '46.0000', 24, 0),
(10706, 59, '55.0000', 8, 0),
(10707, 55, '24.0000', 21, 0),
(10707, 57, '19.5000', 40, 0),
(10707, 70, '15.0000', 28, 0),
(10708, 5, '21.3500', 4, 0),
(10708, 36, '19.0000', 5, 0),
(10709, 8, '40.0000', 40, 0),
(10709, 51, '53.0000', 28, 0),
(10709, 60, '34.0000', 10, 0),
(10710, 19, '9.2000', 5, 0),
(10710, 47, '9.5000', 5, 0),
(10711, 19, '9.2000', 12, 0),
(10711, 41, '9.6500', 42, 0),
(10711, 53, '32.8000', 120, 0),
(10712, 53, '32.8000', 3, 0),
(10712, 56, '38.0000', 30, 0),
(10713, 10, '31.0000', 18, 0),
(10713, 26, '31.2300', 30, 0),
(10713, 45, '9.5000', 110, 0),
(10713, 46, '12.0000', 24, 0),
(10714, 2, '19.0000', 30, 0),
(10714, 17, '39.0000', 27, 0),
(10714, 47, '9.5000', 50, 0),
(10714, 56, '38.0000', 18, 0),
(10714, 58, '13.2500', 12, 0),
(10715, 10, '31.0000', 21, 0),
(10715, 71, '21.5000', 30, 0),
(10716, 21, '10.0000', 5, 0),
(10716, 51, '53.0000', 7, 0),
(10716, 61, '28.5000', 10, 0),
(10717, 21, '10.0000', 32, 0),
(10717, 54, '7.4500', 15, 0),
(10717, 69, '36.0000', 25, 0),
(10718, 12, '38.0000', 36, 0),
(10718, 16, '17.4500', 20, 0),
(10718, 36, '19.0000', 40, 0),
(10718, 62, '49.3000', 20, 0),
(10719, 18, '62.5000', 12, 0),
(10719, 30, '25.8900', 3, 0),
(10719, 54, '7.4500', 40, 0),
(10720, 35, '18.0000', 21, 0),
(10720, 71, '21.5000', 8, 0),
(10721, 44, '19.4500', 50, 0),
(10722, 2, '19.0000', 3, 0),
(10722, 31, '12.5000', 50, 0),
(10722, 68, '12.5000', 45, 0),
(10722, 75, '7.7500', 42, 0),
(10723, 26, '31.2300', 15, 0),
(10724, 10, '31.0000', 16, 0),
(10724, 61, '28.5000', 5, 0),
(10725, 41, '9.6500', 12, 0),
(10725, 52, '7.0000', 4, 0),
(10725, 55, '24.0000', 6, 0),
(10726, 4, '22.0000', 25, 0),
(10726, 11, '21.0000', 5, 0),
(10727, 17, '39.0000', 20, 0),
(10727, 56, '38.0000', 10, 0),
(10727, 59, '55.0000', 10, 0),
(10728, 30, '25.8900', 15, 0),
(10728, 40, '18.4000', 6, 0),
(10728, 55, '24.0000', 12, 0),
(10728, 60, '34.0000', 15, 0),
(10729, 1, '18.0000', 50, 0),
(10729, 21, '10.0000', 30, 0),
(10729, 50, '16.2500', 40, 0),
(10730, 16, '17.4500', 15, 0),
(10730, 31, '12.5000', 3, 0),
(10730, 65, '21.0500', 10, 0),
(10731, 21, '10.0000', 40, 0),
(10731, 51, '53.0000', 30, 0),
(10732, 76, '18.0000', 20, 0),
(10733, 14, '23.2500', 16, 0),
(10733, 28, '45.6000', 20, 0),
(10733, 52, '7.0000', 25, 0),
(10734, 6, '25.0000', 30, 0),
(10734, 30, '25.8900', 15, 0),
(10734, 76, '18.0000', 20, 0),
(10735, 61, '28.5000', 20, 0),
(10735, 77, '13.0000', 2, 0),
(10736, 65, '21.0500', 40, 0),
(10736, 75, '7.7500', 20, 0),
(10737, 13, '6.0000', 4, 0),
(10737, 41, '9.6500', 12, 0),
(10738, 16, '17.4500', 3, 0),
(10739, 36, '19.0000', 6, 0),
(10739, 52, '7.0000', 18, 0),
(10740, 28, '45.6000', 5, 0),
(10740, 35, '18.0000', 35, 0),
(10740, 45, '9.5000', 40, 0),
(10740, 56, '38.0000', 14, 0),
(10741, 2, '19.0000', 15, 0),
(10742, 3, '10.0000', 20, 0),
(10742, 60, '34.0000', 50, 0),
(10742, 72, '34.8000', 35, 0),
(10743, 46, '12.0000', 28, 0),
(10744, 40, '18.4000', 50, 0),
(10745, 18, '62.5000', 24, 0),
(10745, 44, '19.4500', 16, 0),
(10745, 59, '55.0000', 45, 0),
(10745, 72, '34.8000', 7, 0),
(10746, 13, '6.0000', 6, 0),
(10746, 42, '14.0000', 28, 0),
(10746, 62, '49.3000', 9, 0),
(10746, 69, '36.0000', 40, 0),
(10747, 31, '12.5000', 8, 0),
(10747, 41, '9.6500', 35, 0),
(10747, 63, '43.9000', 9, 0),
(10747, 69, '36.0000', 30, 0),
(10748, 23, '9.0000', 44, 0),
(10748, 40, '18.4000', 40, 0),
(10748, 56, '38.0000', 28, 0),
(10749, 56, '38.0000', 15, 0),
(10749, 59, '55.0000', 6, 0),
(10749, 76, '18.0000', 10, 0),
(10750, 14, '23.2500', 5, 0),
(10750, 45, '9.5000', 40, 0),
(10750, 59, '55.0000', 25, 0),
(10751, 26, '31.2300', 12, 0),
(10751, 30, '25.8900', 30, 0),
(10751, 50, '16.2500', 20, 0),
(10751, 73, '15.0000', 15, 0),
(10752, 1, '18.0000', 8, 0),
(10752, 69, '36.0000', 3, 0),
(10753, 45, '9.5000', 4, 0),
(10753, 74, '10.0000', 5, 0),
(10754, 40, '18.4000', 3, 0),
(10755, 47, '9.5000', 30, 0),
(10755, 56, '38.0000', 30, 0),
(10755, 57, '19.5000', 14, 0),
(10755, 69, '36.0000', 25, 0),
(10756, 18, '62.5000', 21, 0),
(10756, 36, '19.0000', 20, 0),
(10756, 68, '12.5000', 6, 0),
(10756, 69, '36.0000', 20, 0),
(10757, 34, '14.0000', 30, 0),
(10757, 59, '55.0000', 7, 0),
(10757, 62, '49.3000', 30, 0),
(10757, 64, '33.2500', 24, 0),
(10758, 26, '31.2300', 20, 0),
(10758, 52, '7.0000', 60, 0),
(10758, 70, '15.0000', 40, 0),
(10759, 32, '32.0000', 10, 0),
(10760, 25, '14.0000', 12, 0),
(10760, 27, '43.9000', 40, 0),
(10760, 43, '46.0000', 30, 0),
(10761, 25, '14.0000', 35, 0),
(10761, 75, '7.7500', 18, 0),
(10762, 39, '18.0000', 16, 0),
(10762, 47, '9.5000', 30, 0),
(10762, 51, '53.0000', 28, 0),
(10762, 56, '38.0000', 60, 0),
(10763, 21, '10.0000', 40, 0),
(10763, 22, '21.0000', 6, 0),
(10763, 24, '4.5000', 20, 0),
(10764, 3, '10.0000', 20, 0),
(10764, 39, '18.0000', 130, 0),
(10765, 65, '21.0500', 80, 0),
(10766, 2, '19.0000', 40, 0),
(10766, 7, '30.0000', 35, 0),
(10766, 68, '12.5000', 40, 0),
(10767, 42, '14.0000', 2, 0),
(10768, 22, '21.0000', 4, 0),
(10768, 31, '12.5000', 50, 0),
(10768, 60, '34.0000', 15, 0),
(10768, 71, '21.5000', 12, 0),
(10769, 41, '9.6500', 30, 0),
(10769, 52, '7.0000', 15, 0),
(10769, 61, '28.5000', 20, 0),
(10769, 62, '49.3000', 15, 0),
(10770, 11, '21.0000', 15, 0),
(10771, 71, '21.5000', 16, 0),
(10772, 29, '123.7900', 18, 0),
(10772, 59, '55.0000', 25, 0),
(10773, 17, '39.0000', 33, 0),
(10773, 31, '12.5000', 70, 0),
(10773, 75, '7.7500', 7, 0),
(10774, 31, '12.5000', 2, 0),
(10774, 66, '17.0000', 50, 0),
(10775, 10, '31.0000', 6, 0),
(10775, 67, '14.0000', 3, 0),
(10776, 31, '12.5000', 16, 0),
(10776, 42, '14.0000', 12, 0),
(10776, 45, '9.5000', 27, 0),
(10776, 51, '53.0000', 120, 0),
(10777, 42, '14.0000', 20, 0),
(10778, 41, '9.6500', 10, 0),
(10779, 16, '17.4500', 20, 0),
(10779, 62, '49.3000', 20, 0),
(10780, 70, '15.0000', 35, 0),
(10780, 77, '13.0000', 15, 0),
(10781, 54, '7.4500', 3, 0),
(10781, 56, '38.0000', 20, 0),
(10781, 74, '10.0000', 35, 0),
(10782, 31, '12.5000', 1, 0),
(10783, 31, '12.5000', 10, 0),
(10783, 38, '263.5000', 5, 0),
(10784, 36, '19.0000', 30, 0),
(10784, 39, '18.0000', 2, 0),
(10784, 72, '34.8000', 30, 0),
(10785, 10, '31.0000', 10, 0),
(10785, 75, '7.7500', 10, 0),
(10786, 8, '40.0000', 30, 0),
(10786, 30, '25.8900', 15, 0),
(10786, 75, '7.7500', 42, 0),
(10787, 2, '19.0000', 15, 0),
(10787, 29, '123.7900', 20, 0),
(10788, 19, '9.2000', 50, 0),
(10788, 75, '7.7500', 40, 0),
(10789, 18, '62.5000', 30, 0),
(10789, 35, '18.0000', 15, 0),
(10789, 63, '43.9000', 30, 0),
(10789, 68, '12.5000', 18, 0),
(10790, 7, '30.0000', 3, 0),
(10790, 56, '38.0000', 20, 0),
(10791, 29, '123.7900', 14, 0),
(10791, 41, '9.6500', 20, 0),
(10792, 2, '19.0000', 10, 0),
(10792, 54, '7.4500', 3, 0),
(10792, 68, '12.5000', 15, 0),
(10793, 41, '9.6500', 14, 0),
(10793, 52, '7.0000', 8, 0),
(10794, 14, '23.2500', 15, 0),
(10794, 54, '7.4500', 6, 0),
(10795, 16, '17.4500', 65, 0),
(10795, 17, '39.0000', 35, 0),
(10796, 26, '31.2300', 21, 0),
(10796, 44, '19.4500', 10, 0),
(10796, 64, '33.2500', 35, 0),
(10796, 69, '36.0000', 24, 0),
(10797, 11, '21.0000', 20, 0),
(10798, 62, '49.3000', 2, 0),
(10798, 72, '34.8000', 10, 0),
(10799, 13, '6.0000', 20, 0),
(10799, 24, '4.5000', 20, 0),
(10799, 59, '55.0000', 25, 0),
(10800, 11, '21.0000', 50, 0),
(10800, 51, '53.0000', 10, 0),
(10800, 54, '7.4500', 7, 0),
(10801, 17, '39.0000', 40, 0),
(10801, 29, '123.7900', 20, 0),
(10802, 30, '25.8900', 25, 0),
(10802, 51, '53.0000', 30, 0),
(10802, 55, '24.0000', 60, 0),
(10802, 62, '49.3000', 5, 0),
(10803, 19, '9.2000', 24, 0),
(10803, 25, '14.0000', 15, 0),
(10803, 59, '55.0000', 15, 0),
(10804, 10, '31.0000', 36, 0),
(10804, 28, '45.6000', 24, 0),
(10804, 49, '20.0000', 4, 0),
(10805, 34, '14.0000', 10, 0),
(10805, 38, '263.5000', 10, 0),
(10806, 2, '19.0000', 20, 0),
(10806, 65, '21.0500', 2, 0),
(10806, 74, '10.0000', 15, 0),
(10807, 40, '18.4000', 1, 0),
(10808, 56, '38.0000', 20, 0),
(10808, 76, '18.0000', 50, 0),
(10809, 52, '7.0000', 20, 0),
(10810, 13, '6.0000', 7, 0),
(10810, 25, '14.0000', 5, 0),
(10810, 70, '15.0000', 5, 0),
(10811, 19, '9.2000', 15, 0),
(10811, 23, '9.0000', 18, 0),
(10811, 40, '18.4000', 30, 0),
(10812, 31, '12.5000', 16, 0),
(10812, 72, '34.8000', 40, 0),
(10812, 77, '13.0000', 20, 0),
(10813, 2, '19.0000', 12, 0),
(10813, 46, '12.0000', 35, 0),
(10814, 41, '9.6500', 20, 0),
(10814, 43, '46.0000', 20, 0),
(10814, 48, '12.7500', 8, 0),
(10814, 61, '28.5000', 30, 0),
(10815, 33, '2.5000', 16, 0),
(10816, 38, '263.5000', 30, 0),
(10816, 62, '49.3000', 20, 0),
(10817, 26, '31.2300', 40, 0),
(10817, 38, '263.5000', 30, 0),
(10817, 40, '18.4000', 60, 0),
(10817, 62, '49.3000', 25, 0),
(10818, 32, '32.0000', 20, 0),
(10818, 41, '9.6500', 20, 0),
(10819, 43, '46.0000', 7, 0),
(10819, 75, '7.7500', 20, 0),
(10820, 56, '38.0000', 30, 0),
(10821, 35, '18.0000', 20, 0),
(10821, 51, '53.0000', 6, 0),
(10822, 62, '49.3000', 3, 0),
(10822, 70, '15.0000', 6, 0),
(10823, 11, '21.0000', 20, 0),
(10823, 57, '19.5000', 15, 0),
(10823, 59, '55.0000', 40, 0),
(10823, 77, '13.0000', 15, 0),
(10824, 41, '9.6500', 12, 0),
(10824, 70, '15.0000', 9, 0),
(10825, 26, '31.2300', 12, 0),
(10825, 53, '32.8000', 20, 0),
(10826, 31, '12.5000', 35, 0),
(10826, 57, '19.5000', 15, 0),
(10827, 10, '31.0000', 15, 0),
(10827, 39, '18.0000', 21, 0),
(10828, 20, '81.0000', 5, 0),
(10828, 38, '263.5000', 2, 0),
(10829, 2, '19.0000', 10, 0),
(10829, 8, '40.0000', 20, 0),
(10829, 13, '6.0000', 10, 0),
(10829, 60, '34.0000', 21, 0),
(10830, 6, '25.0000', 6, 0),
(10830, 39, '18.0000', 28, 0),
(10830, 60, '34.0000', 30, 0),
(10830, 68, '12.5000', 24, 0),
(10831, 19, '9.2000', 2, 0),
(10831, 35, '18.0000', 8, 0),
(10831, 38, '263.5000', 8, 0),
(10831, 43, '46.0000', 9, 0),
(10832, 13, '6.0000', 3, 0),
(10832, 25, '14.0000', 10, 0),
(10832, 44, '19.4500', 16, 0),
(10832, 64, '33.2500', 3, 0),
(10833, 7, '30.0000', 20, 0),
(10833, 31, '12.5000', 9, 0),
(10833, 53, '32.8000', 9, 0),
(10834, 29, '123.7900', 8, 0),
(10834, 30, '25.8900', 20, 0),
(10835, 59, '55.0000', 15, 0),
(10835, 77, '13.0000', 2, 0),
(10836, 22, '21.0000', 52, 0),
(10836, 35, '18.0000', 6, 0),
(10836, 57, '19.5000', 24, 0),
(10836, 60, '34.0000', 60, 0),
(10836, 64, '33.2500', 30, 0),
(10837, 13, '6.0000', 6, 0),
(10837, 40, '18.4000', 25, 0),
(10837, 47, '9.5000', 40, 0),
(10837, 76, '18.0000', 21, 0),
(10838, 1, '18.0000', 4, 0),
(10838, 18, '62.5000', 25, 0),
(10838, 36, '19.0000', 50, 0),
(10839, 58, '13.2500', 30, 0),
(10839, 72, '34.8000', 15, 0),
(10840, 25, '14.0000', 6, 0),
(10840, 39, '18.0000', 10, 0),
(10841, 10, '31.0000', 16, 0),
(10841, 56, '38.0000', 30, 0),
(10841, 59, '55.0000', 50, 0),
(10841, 77, '13.0000', 15, 0),
(10842, 11, '21.0000', 15, 0),
(10842, 43, '46.0000', 5, 0),
(10842, 68, '12.5000', 20, 0),
(10842, 70, '15.0000', 12, 0),
(10843, 51, '53.0000', 4, 0),
(10844, 22, '21.0000', 35, 0),
(10845, 23, '9.0000', 70, 0),
(10845, 35, '18.0000', 25, 0),
(10845, 42, '14.0000', 42, 0),
(10845, 58, '13.2500', 60, 0),
(10845, 64, '33.2500', 48, 0),
(10846, 4, '22.0000', 21, 0),
(10846, 70, '15.0000', 30, 0),
(10846, 74, '10.0000', 20, 0),
(10847, 1, '18.0000', 80, 0),
(10847, 19, '9.2000', 12, 0),
(10847, 37, '26.0000', 60, 0),
(10847, 45, '9.5000', 36, 0),
(10847, 60, '34.0000', 45, 0),
(10847, 71, '21.5000', 55, 0),
(10848, 5, '21.3500', 30, 0),
(10848, 9, '97.0000', 3, 0),
(10849, 3, '10.0000', 49, 0),
(10849, 26, '31.2300', 18, 0),
(10850, 25, '14.0000', 20, 0),
(10850, 33, '2.5000', 4, 0),
(10850, 70, '15.0000', 30, 0),
(10851, 2, '19.0000', 5, 0),
(10851, 25, '14.0000', 10, 0),
(10851, 57, '19.5000', 10, 0),
(10851, 59, '55.0000', 42, 0),
(10852, 2, '19.0000', 15, 0),
(10852, 17, '39.0000', 6, 0),
(10852, 62, '49.3000', 50, 0),
(10853, 18, '62.5000', 10, 0),
(10854, 10, '31.0000', 100, 0),
(10854, 13, '6.0000', 65, 0),
(10855, 16, '17.4500', 50, 0),
(10855, 31, '12.5000', 14, 0),
(10855, 56, '38.0000', 24, 0),
(10855, 65, '21.0500', 15, 0),
(10856, 2, '19.0000', 20, 0),
(10856, 42, '14.0000', 20, 0),
(10857, 3, '10.0000', 30, 0),
(10857, 26, '31.2300', 35, 0),
(10857, 29, '123.7900', 10, 0),
(10858, 7, '30.0000', 5, 0),
(10858, 27, '43.9000', 10, 0),
(10858, 70, '15.0000', 4, 0),
(10859, 24, '4.5000', 40, 0),
(10859, 54, '7.4500', 35, 0),
(10859, 64, '33.2500', 30, 0),
(10860, 51, '53.0000', 3, 0),
(10860, 76, '18.0000', 20, 0),
(10861, 17, '39.0000', 42, 0),
(10861, 18, '62.5000', 20, 0),
(10861, 21, '10.0000', 40, 0),
(10861, 33, '2.5000', 35, 0),
(10861, 62, '49.3000', 3, 0),
(10862, 11, '21.0000', 25, 0),
(10862, 52, '7.0000', 8, 0),
(10863, 1, '18.0000', 20, 0),
(10863, 58, '13.2500', 12, 0),
(10864, 35, '18.0000', 4, 0),
(10864, 67, '14.0000', 15, 0),
(10865, 38, '263.5000', 60, 0),
(10865, 39, '18.0000', 80, 0),
(10866, 2, '19.0000', 21, 0),
(10866, 24, '4.5000', 6, 0),
(10866, 30, '25.8900', 40, 0),
(10867, 53, '32.8000', 3, 0),
(10868, 26, '31.2300', 20, 0),
(10868, 35, '18.0000', 30, 0),
(10868, 49, '20.0000', 42, 0),
(10869, 1, '18.0000', 40, 0),
(10869, 11, '21.0000', 10, 0),
(10869, 23, '9.0000', 50, 0),
(10869, 68, '12.5000', 20, 0),
(10870, 35, '18.0000', 3, 0),
(10870, 51, '53.0000', 2, 0),
(10871, 6, '25.0000', 50, 0),
(10871, 16, '17.4500', 12, 0),
(10871, 17, '39.0000', 16, 0),
(10872, 55, '24.0000', 10, 0),
(10872, 62, '49.3000', 20, 0),
(10872, 64, '33.2500', 15, 0),
(10872, 65, '21.0500', 21, 0),
(10873, 21, '10.0000', 20, 0),
(10873, 28, '45.6000', 3, 0),
(10874, 10, '31.0000', 10, 0),
(10875, 19, '9.2000', 25, 0),
(10875, 47, '9.5000', 21, 0),
(10875, 49, '20.0000', 15, 0),
(10876, 46, '12.0000', 21, 0),
(10876, 64, '33.2500', 20, 0),
(10877, 16, '17.4500', 30, 0),
(10877, 18, '62.5000', 25, 0),
(10878, 20, '81.0000', 20, 0),
(10879, 40, '18.4000', 12, 0),
(10879, 65, '21.0500', 10, 0),
(10879, 76, '18.0000', 10, 0),
(10880, 23, '9.0000', 30, 0),
(10880, 61, '28.5000', 30, 0),
(10880, 70, '15.0000', 50, 0),
(10881, 73, '15.0000', 10, 0),
(10882, 42, '14.0000', 25, 0),
(10882, 49, '20.0000', 20, 0),
(10882, 54, '7.4500', 32, 0),
(10883, 24, '4.5000', 8, 0),
(10884, 21, '10.0000', 40, 0),
(10884, 56, '38.0000', 21, 0),
(10884, 65, '21.0500', 12, 0),
(10885, 2, '19.0000', 20, 0),
(10885, 24, '4.5000', 12, 0),
(10885, 70, '15.0000', 30, 0),
(10885, 77, '13.0000', 25, 0),
(10886, 10, '31.0000', 70, 0),
(10886, 31, '12.5000', 35, 0),
(10886, 77, '13.0000', 40, 0),
(10887, 25, '14.0000', 5, 0),
(10888, 2, '19.0000', 20, 0),
(10888, 68, '12.5000', 18, 0),
(10889, 11, '21.0000', 40, 0),
(10889, 38, '263.5000', 40, 0),
(10890, 17, '39.0000', 15, 0),
(10890, 34, '14.0000', 10, 0),
(10890, 41, '9.6500', 14, 0),
(10891, 30, '25.8900', 15, 0),
(10892, 59, '55.0000', 40, 0),
(10893, 8, '40.0000', 30, 0),
(10893, 24, '4.5000', 10, 0),
(10893, 29, '123.7900', 24, 0),
(10893, 30, '25.8900', 35, 0),
(10893, 36, '19.0000', 20, 0),
(10894, 13, '6.0000', 28, 0),
(10894, 69, '36.0000', 50, 0),
(10894, 75, '7.7500', 120, 0),
(10895, 24, '4.5000', 110, 0),
(10895, 39, '18.0000', 45, 0),
(10895, 40, '18.4000', 91, 0),
(10895, 60, '34.0000', 100, 0),
(10896, 45, '9.5000', 15, 0),
(10896, 56, '38.0000', 16, 0),
(10897, 29, '123.7900', 80, 0),
(10897, 30, '25.8900', 36, 0),
(10898, 13, '6.0000', 5, 0),
(10899, 39, '18.0000', 8, 0),
(10900, 70, '15.0000', 3, 0),
(10901, 41, '9.6500', 30, 0),
(10901, 71, '21.5000', 30, 0),
(10902, 55, '24.0000', 30, 0),
(10902, 62, '49.3000', 6, 0),
(10903, 13, '6.0000', 40, 0),
(10903, 65, '21.0500', 21, 0),
(10903, 68, '12.5000', 20, 0),
(10904, 58, '13.2500', 15, 0),
(10904, 62, '49.3000', 35, 0),
(10905, 1, '18.0000', 20, 0),
(10906, 61, '28.5000', 15, 0),
(10907, 75, '7.7500', 14, 0),
(10908, 7, '30.0000', 20, 0),
(10908, 52, '7.0000', 14, 0),
(10909, 7, '30.0000', 12, 0),
(10909, 16, '17.4500', 15, 0),
(10909, 41, '9.6500', 5, 0),
(10910, 19, '9.2000', 12, 0),
(10910, 49, '20.0000', 10, 0),
(10910, 61, '28.5000', 5, 0),
(10911, 1, '18.0000', 10, 0),
(10911, 17, '39.0000', 12, 0),
(10911, 67, '14.0000', 15, 0),
(10912, 11, '21.0000', 40, 0),
(10912, 29, '123.7900', 60, 0),
(10913, 4, '22.0000', 30, 0),
(10913, 33, '2.5000', 40, 0),
(10913, 58, '13.2500', 15, 0),
(10914, 71, '21.5000', 25, 0),
(10915, 17, '39.0000', 10, 0),
(10915, 33, '2.5000', 30, 0),
(10915, 54, '7.4500', 10, 0),
(10916, 16, '17.4500', 6, 0),
(10916, 32, '32.0000', 6, 0),
(10916, 57, '19.5000', 20, 0),
(10917, 30, '25.8900', 1, 0),
(10917, 60, '34.0000', 10, 0),
(10918, 1, '18.0000', 60, 0),
(10918, 60, '34.0000', 25, 0),
(10919, 16, '17.4500', 24, 0),
(10919, 25, '14.0000', 24, 0),
(10919, 40, '18.4000', 20, 0);
INSERT INTO `OrderDetails` (`OrderID`, `ProductID`, `UnitPrice`, `Quantity`, `Discount`) VALUES
(10920, 50, '16.2500', 24, 0),
(10921, 35, '18.0000', 10, 0),
(10921, 63, '43.9000', 40, 0),
(10922, 17, '39.0000', 15, 0),
(10922, 24, '4.5000', 35, 0),
(10923, 42, '14.0000', 10, 0),
(10923, 43, '46.0000', 10, 0),
(10923, 67, '14.0000', 24, 0),
(10924, 10, '31.0000', 20, 0),
(10924, 28, '45.6000', 30, 0),
(10924, 75, '7.7500', 6, 0),
(10925, 36, '19.0000', 25, 0),
(10925, 52, '7.0000', 12, 0),
(10926, 11, '21.0000', 2, 0),
(10926, 13, '6.0000', 10, 0),
(10926, 19, '9.2000', 7, 0),
(10926, 72, '34.8000', 10, 0),
(10927, 20, '81.0000', 5, 0),
(10927, 52, '7.0000', 5, 0),
(10927, 76, '18.0000', 20, 0),
(10928, 47, '9.5000', 5, 0),
(10928, 76, '18.0000', 5, 0),
(10929, 21, '10.0000', 60, 0),
(10929, 75, '7.7500', 49, 0),
(10929, 77, '13.0000', 15, 0),
(10930, 21, '10.0000', 36, 0),
(10930, 27, '43.9000', 25, 0),
(10930, 55, '24.0000', 25, 0),
(10930, 58, '13.2500', 30, 0),
(10931, 13, '6.0000', 42, 0),
(10931, 57, '19.5000', 30, 0),
(10932, 16, '17.4500', 30, 0),
(10932, 62, '49.3000', 14, 0),
(10932, 72, '34.8000', 16, 0),
(10932, 75, '7.7500', 20, 0),
(10933, 53, '32.8000', 2, 0),
(10933, 61, '28.5000', 30, 0),
(10934, 6, '25.0000', 20, 0),
(10935, 1, '18.0000', 21, 0),
(10935, 18, '62.5000', 4, 0),
(10935, 23, '9.0000', 8, 0),
(10936, 36, '19.0000', 30, 0),
(10937, 28, '45.6000', 8, 0),
(10937, 34, '14.0000', 20, 0),
(10938, 13, '6.0000', 20, 0),
(10938, 43, '46.0000', 24, 0),
(10938, 60, '34.0000', 49, 0),
(10938, 71, '21.5000', 35, 0),
(10939, 2, '19.0000', 10, 0),
(10939, 67, '14.0000', 40, 0),
(10940, 7, '30.0000', 8, 0),
(10940, 13, '6.0000', 20, 0),
(10941, 31, '12.5000', 44, 0),
(10941, 62, '49.3000', 30, 0),
(10941, 68, '12.5000', 80, 0),
(10941, 72, '34.8000', 50, 0),
(10942, 49, '20.0000', 28, 0),
(10943, 13, '6.0000', 15, 0),
(10943, 22, '21.0000', 21, 0),
(10943, 46, '12.0000', 15, 0),
(10944, 11, '21.0000', 5, 0),
(10944, 44, '19.4500', 18, 0),
(10944, 56, '38.0000', 18, 0),
(10945, 13, '6.0000', 20, 0),
(10945, 31, '12.5000', 10, 0),
(10946, 10, '31.0000', 25, 0),
(10946, 24, '4.5000', 25, 0),
(10946, 77, '13.0000', 40, 0),
(10947, 59, '55.0000', 4, 0),
(10948, 50, '16.2500', 9, 0),
(10948, 51, '53.0000', 40, 0),
(10948, 55, '24.0000', 4, 0),
(10949, 6, '25.0000', 12, 0),
(10949, 10, '31.0000', 30, 0),
(10949, 17, '39.0000', 6, 0),
(10949, 62, '49.3000', 60, 0),
(10950, 4, '22.0000', 5, 0),
(10951, 33, '2.5000', 15, 0),
(10951, 41, '9.6500', 6, 0),
(10951, 75, '7.7500', 50, 0),
(10952, 6, '25.0000', 16, 0),
(10952, 28, '45.6000', 2, 0),
(10953, 20, '81.0000', 50, 0),
(10953, 31, '12.5000', 50, 0),
(10954, 16, '17.4500', 28, 0),
(10954, 31, '12.5000', 25, 0),
(10954, 45, '9.5000', 30, 0),
(10954, 60, '34.0000', 24, 0),
(10955, 75, '7.7500', 12, 0),
(10956, 21, '10.0000', 12, 0),
(10956, 47, '9.5000', 14, 0),
(10956, 51, '53.0000', 8, 0),
(10957, 30, '25.8900', 30, 0),
(10957, 35, '18.0000', 40, 0),
(10957, 64, '33.2500', 8, 0),
(10958, 5, '21.3500', 20, 0),
(10958, 7, '30.0000', 6, 0),
(10958, 72, '34.8000', 5, 0),
(10959, 75, '7.7500', 20, 0),
(10960, 24, '4.5000', 10, 0),
(10960, 41, '9.6500', 24, 0),
(10961, 52, '7.0000', 6, 0),
(10961, 76, '18.0000', 60, 0),
(10962, 7, '30.0000', 45, 0),
(10962, 13, '6.0000', 77, 0),
(10962, 53, '32.8000', 20, 0),
(10962, 69, '36.0000', 9, 0),
(10962, 76, '18.0000', 44, 0),
(10963, 60, '34.0000', 2, 0),
(10964, 18, '62.5000', 6, 0),
(10964, 38, '263.5000', 5, 0),
(10964, 69, '36.0000', 10, 0),
(10965, 51, '53.0000', 16, 0),
(10966, 37, '26.0000', 8, 0),
(10966, 56, '38.0000', 12, 0),
(10966, 62, '49.3000', 12, 0),
(10967, 19, '9.2000', 12, 0),
(10967, 49, '20.0000', 40, 0),
(10968, 12, '38.0000', 30, 0),
(10968, 24, '4.5000', 30, 0),
(10968, 64, '33.2500', 4, 0),
(10969, 46, '12.0000', 9, 0),
(10970, 52, '7.0000', 40, 0),
(10971, 29, '123.7900', 14, 0),
(10972, 17, '39.0000', 6, 0),
(10972, 33, '2.5000', 7, 0),
(10973, 26, '31.2300', 5, 0),
(10973, 41, '9.6500', 6, 0),
(10973, 75, '7.7500', 10, 0),
(10974, 63, '43.9000', 10, 0),
(10975, 8, '40.0000', 16, 0),
(10975, 75, '7.7500', 10, 0),
(10976, 28, '45.6000', 20, 0),
(10977, 39, '18.0000', 30, 0),
(10977, 47, '9.5000', 30, 0),
(10977, 51, '53.0000', 10, 0),
(10977, 63, '43.9000', 20, 0),
(10978, 8, '40.0000', 20, 0),
(10978, 21, '10.0000', 40, 0),
(10978, 40, '18.4000', 10, 0),
(10978, 44, '19.4500', 6, 0),
(10979, 7, '30.0000', 18, 0),
(10979, 12, '38.0000', 20, 0),
(10979, 24, '4.5000', 80, 0),
(10979, 27, '43.9000', 30, 0),
(10979, 31, '12.5000', 24, 0),
(10979, 63, '43.9000', 35, 0),
(10980, 75, '7.7500', 40, 0),
(10981, 38, '263.5000', 60, 0),
(10982, 7, '30.0000', 20, 0),
(10982, 43, '46.0000', 9, 0),
(10983, 13, '6.0000', 84, 0),
(10983, 57, '19.5000', 15, 0),
(10984, 16, '17.4500', 55, 0),
(10984, 24, '4.5000', 20, 0),
(10984, 36, '19.0000', 40, 0),
(10985, 16, '17.4500', 36, 0),
(10985, 18, '62.5000', 8, 0),
(10985, 32, '32.0000', 35, 0),
(10986, 11, '21.0000', 30, 0),
(10986, 20, '81.0000', 15, 0),
(10986, 76, '18.0000', 10, 0),
(10986, 77, '13.0000', 15, 0),
(10987, 7, '30.0000', 60, 0),
(10987, 43, '46.0000', 6, 0),
(10987, 72, '34.8000', 20, 0),
(10988, 7, '30.0000', 60, 0),
(10988, 62, '49.3000', 40, 0),
(10989, 6, '25.0000', 40, 0),
(10989, 11, '21.0000', 15, 0),
(10989, 41, '9.6500', 4, 0),
(10990, 21, '10.0000', 65, 0),
(10990, 34, '14.0000', 60, 0),
(10990, 55, '24.0000', 65, 0),
(10990, 61, '28.5000', 66, 0),
(10991, 2, '19.0000', 50, 0),
(10991, 70, '15.0000', 20, 0),
(10991, 76, '18.0000', 90, 0),
(10992, 72, '34.8000', 2, 0),
(10993, 29, '123.7900', 50, 0),
(10993, 41, '9.6500', 35, 0),
(10994, 59, '55.0000', 18, 0),
(10995, 51, '53.0000', 20, 0),
(10995, 60, '34.0000', 4, 0),
(10996, 42, '14.0000', 40, 0),
(10997, 32, '32.0000', 50, 0),
(10997, 46, '12.0000', 20, 0),
(10997, 52, '7.0000', 20, 0),
(10998, 24, '4.5000', 12, 0),
(10998, 61, '28.5000', 7, 0),
(10998, 74, '10.0000', 20, 0),
(10998, 75, '7.7500', 30, 0),
(10999, 41, '9.6500', 20, 0),
(10999, 51, '53.0000', 15, 0),
(10999, 77, '13.0000', 21, 0),
(11000, 4, '22.0000', 25, 0),
(11000, 24, '4.5000', 30, 0),
(11000, 77, '13.0000', 30, 0),
(11001, 7, '30.0000', 60, 0),
(11001, 22, '21.0000', 25, 0),
(11001, 46, '12.0000', 25, 0),
(11001, 55, '24.0000', 6, 0),
(11002, 13, '6.0000', 56, 0),
(11002, 35, '18.0000', 15, 0),
(11002, 42, '14.0000', 24, 0),
(11002, 55, '24.0000', 40, 0),
(11003, 1, '18.0000', 4, 0),
(11003, 40, '18.4000', 10, 0),
(11003, 52, '7.0000', 10, 0),
(11004, 26, '31.2300', 6, 0),
(11004, 76, '18.0000', 6, 0),
(11005, 1, '18.0000', 2, 0),
(11005, 59, '55.0000', 10, 0),
(11006, 1, '18.0000', 8, 0),
(11006, 29, '123.7900', 2, 0),
(11007, 8, '40.0000', 30, 0),
(11007, 29, '123.7900', 10, 0),
(11007, 42, '14.0000', 14, 0),
(11008, 28, '45.6000', 70, 0),
(11008, 34, '14.0000', 90, 0),
(11008, 71, '21.5000', 21, 0),
(11009, 24, '4.5000', 12, 0),
(11009, 36, '19.0000', 18, 0),
(11009, 60, '34.0000', 9, 0),
(11010, 7, '30.0000', 20, 0),
(11010, 24, '4.5000', 10, 0),
(11011, 58, '13.2500', 40, 0),
(11011, 71, '21.5000', 20, 0),
(11012, 19, '9.2000', 50, 0),
(11012, 60, '34.0000', 36, 0),
(11012, 71, '21.5000', 60, 0),
(11013, 23, '9.0000', 10, 0),
(11013, 42, '14.0000', 4, 0),
(11013, 45, '9.5000', 20, 0),
(11013, 68, '12.5000', 2, 0),
(11014, 41, '9.6500', 28, 0),
(11015, 30, '25.8900', 15, 0),
(11015, 77, '13.0000', 18, 0),
(11016, 31, '12.5000', 15, 0),
(11016, 36, '19.0000', 16, 0),
(11017, 3, '10.0000', 25, 0),
(11017, 59, '55.0000', 110, 0),
(11017, 70, '15.0000', 30, 0),
(11018, 12, '38.0000', 20, 0),
(11018, 18, '62.5000', 10, 0),
(11018, 56, '38.0000', 5, 0),
(11019, 46, '12.0000', 3, 0),
(11019, 49, '20.0000', 2, 0),
(11020, 10, '31.0000', 24, 0),
(11021, 2, '19.0000', 11, 0),
(11021, 20, '81.0000', 15, 0),
(11021, 26, '31.2300', 63, 0),
(11021, 51, '53.0000', 44, 0),
(11021, 72, '34.8000', 35, 0),
(11022, 19, '9.2000', 35, 0),
(11022, 69, '36.0000', 30, 0),
(11023, 7, '30.0000', 4, 0),
(11023, 43, '46.0000', 30, 0),
(11024, 26, '31.2300', 12, 0),
(11024, 33, '2.5000', 30, 0),
(11024, 65, '21.0500', 21, 0),
(11024, 71, '21.5000', 50, 0),
(11025, 1, '18.0000', 10, 0),
(11025, 13, '6.0000', 20, 0),
(11026, 18, '62.5000', 8, 0),
(11026, 51, '53.0000', 10, 0),
(11027, 24, '4.5000', 30, 0),
(11027, 62, '49.3000', 21, 0),
(11028, 55, '24.0000', 35, 0),
(11028, 59, '55.0000', 24, 0),
(11029, 56, '38.0000', 20, 0),
(11029, 63, '43.9000', 12, 0),
(11030, 2, '19.0000', 100, 0),
(11030, 5, '21.3500', 70, 0),
(11030, 29, '123.7900', 60, 0),
(11030, 59, '55.0000', 100, 0),
(11031, 1, '18.0000', 45, 0),
(11031, 13, '6.0000', 80, 0),
(11031, 24, '4.5000', 21, 0),
(11031, 64, '33.2500', 20, 0),
(11031, 71, '21.5000', 16, 0),
(11032, 36, '19.0000', 35, 0),
(11032, 38, '263.5000', 25, 0),
(11032, 59, '55.0000', 30, 0),
(11033, 53, '32.8000', 70, 0),
(11033, 69, '36.0000', 36, 0),
(11034, 21, '10.0000', 15, 0),
(11034, 44, '19.4500', 12, 0),
(11034, 61, '28.5000', 6, 0),
(11035, 1, '18.0000', 10, 0),
(11035, 35, '18.0000', 60, 0),
(11035, 42, '14.0000', 30, 0),
(11035, 54, '7.4500', 10, 0),
(11036, 13, '6.0000', 7, 0),
(11036, 59, '55.0000', 30, 0),
(11037, 70, '15.0000', 4, 0),
(11038, 40, '18.4000', 5, 0),
(11038, 52, '7.0000', 2, 0),
(11038, 71, '21.5000', 30, 0),
(11039, 28, '45.6000', 20, 0),
(11039, 35, '18.0000', 24, 0),
(11039, 49, '20.0000', 60, 0),
(11039, 57, '19.5000', 28, 0),
(11040, 21, '10.0000', 20, 0),
(11041, 2, '19.0000', 30, 0),
(11041, 63, '43.9000', 30, 0),
(11042, 44, '19.4500', 15, 0),
(11042, 61, '28.5000', 4, 0),
(11043, 11, '21.0000', 10, 0),
(11044, 62, '49.3000', 12, 0),
(11045, 33, '2.5000', 15, 0),
(11045, 51, '53.0000', 24, 0),
(11046, 12, '38.0000', 20, 0),
(11046, 32, '32.0000', 15, 0),
(11046, 35, '18.0000', 18, 0),
(11047, 1, '18.0000', 25, 0),
(11047, 5, '21.3500', 30, 0),
(11048, 68, '12.5000', 42, 0),
(11049, 2, '19.0000', 10, 0),
(11049, 12, '38.0000', 4, 0),
(11050, 76, '18.0000', 50, 0),
(11051, 24, '4.5000', 10, 0),
(11052, 43, '46.0000', 30, 0),
(11052, 61, '28.5000', 10, 0),
(11053, 18, '62.5000', 35, 0),
(11053, 32, '32.0000', 20, 0),
(11053, 64, '33.2500', 25, 0),
(11054, 33, '2.5000', 10, 0),
(11054, 67, '14.0000', 20, 0),
(11055, 24, '4.5000', 15, 0),
(11055, 25, '14.0000', 15, 0),
(11055, 51, '53.0000', 20, 0),
(11055, 57, '19.5000', 20, 0),
(11056, 7, '30.0000', 40, 0),
(11056, 55, '24.0000', 35, 0),
(11056, 60, '34.0000', 50, 0),
(11057, 70, '15.0000', 3, 0),
(11058, 21, '10.0000', 3, 0),
(11058, 60, '34.0000', 21, 0),
(11058, 61, '28.5000', 4, 0),
(11059, 13, '6.0000', 30, 0),
(11059, 17, '39.0000', 12, 0),
(11059, 60, '34.0000', 35, 0),
(11060, 60, '34.0000', 4, 0),
(11060, 77, '13.0000', 10, 0),
(11061, 60, '34.0000', 15, 0),
(11062, 53, '32.8000', 10, 0),
(11062, 70, '15.0000', 12, 0),
(11063, 34, '14.0000', 30, 0),
(11063, 40, '18.4000', 40, 0),
(11063, 41, '9.6500', 30, 0),
(11064, 17, '39.0000', 77, 0),
(11064, 41, '9.6500', 12, 0),
(11064, 53, '32.8000', 25, 0),
(11064, 55, '24.0000', 4, 0),
(11064, 68, '12.5000', 55, 0),
(11065, 30, '25.8900', 4, 0),
(11065, 54, '7.4500', 20, 0),
(11066, 16, '17.4500', 3, 0),
(11066, 19, '9.2000', 42, 0),
(11066, 34, '14.0000', 35, 0),
(11067, 41, '9.6500', 9, 0),
(11068, 28, '45.6000', 8, 0),
(11068, 43, '46.0000', 36, 0),
(11068, 77, '13.0000', 28, 0),
(11069, 39, '18.0000', 20, 0),
(11070, 1, '18.0000', 40, 0),
(11070, 2, '19.0000', 20, 0),
(11070, 16, '17.4500', 30, 0),
(11070, 31, '12.5000', 20, 0),
(11071, 7, '30.0000', 15, 0),
(11071, 13, '6.0000', 10, 0),
(11072, 2, '19.0000', 8, 0),
(11072, 41, '9.6500', 40, 0),
(11072, 50, '16.2500', 22, 0),
(11072, 64, '33.2500', 130, 0),
(11073, 11, '21.0000', 10, 0),
(11073, 24, '4.5000', 20, 0),
(11074, 16, '17.4500', 14, 0),
(11075, 2, '19.0000', 10, 0),
(11075, 46, '12.0000', 30, 0),
(11075, 76, '18.0000', 2, 0),
(11076, 6, '25.0000', 20, 0),
(11076, 14, '23.2500', 20, 0),
(11076, 19, '9.2000', 10, 0),
(11077, 2, '19.0000', 24, 0),
(11077, 3, '10.0000', 4, 0),
(11077, 4, '22.0000', 1, 0),
(11077, 6, '25.0000', 1, 0),
(11077, 7, '30.0000', 1, 0),
(11077, 8, '40.0000', 2, 0),
(11077, 10, '31.0000', 1, 0),
(11077, 12, '38.0000', 2, 0),
(11077, 13, '6.0000', 4, 0),
(11077, 14, '23.2500', 1, 0),
(11077, 16, '17.4500', 2, 0),
(11077, 20, '81.0000', 1, 0),
(11077, 23, '9.0000', 2, 0),
(11077, 32, '32.0000', 1, 0),
(11077, 39, '18.0000', 2, 0),
(11077, 41, '9.6500', 3, 0),
(11077, 46, '12.0000', 3, 0),
(11077, 52, '7.0000', 2, 0),
(11077, 55, '24.0000', 2, 0),
(11077, 60, '34.0000', 2, 0),
(11077, 64, '33.2500', 2, 0),
(11077, 66, '17.0000', 1, 0),
(11077, 73, '15.0000', 2, 0),
(11077, 75, '7.7500', 4, 0),
(11077, 77, '13.0000', 2, 0);
-- --------------------------------------------------------
--
-- Table structure for table `Orders`
--
CREATE TABLE `Orders` (
`OrderID` int(13) NOT NULL,
`CustomerID` int(13) NOT NULL,
`CustomerCode` varchar(25) CHARACTER SET utf8mb4 DEFAULT NULL,
`EmployeeID` int(13) DEFAULT NULL,
`OrderDate` datetime DEFAULT NULL,
`RequiredDate` datetime DEFAULT NULL,
`ShippedDate` datetime DEFAULT NULL,
`ShipVia` int(13) DEFAULT NULL,
`Freight` decimal(10,4) DEFAULT '0.0000',
`ShipName` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
`ShipAddress` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
`ShipCity` varchar(25) CHARACTER SET utf8mb4 DEFAULT NULL,
`ShipRegion` varchar(25) CHARACTER SET utf8mb4 DEFAULT NULL,
`ShipPostalCode` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
`ShipCountry` varchar(25) CHARACTER SET utf8mb4 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `Orders`
--
INSERT INTO `Orders` (`OrderID`, `CustomerID`, `CustomerCode`, `EmployeeID`, `OrderDate`, `RequiredDate`, `ShippedDate`, `ShipVia`, `Freight`, `ShipName`, `ShipAddress`, `ShipCity`, `ShipRegion`, `ShipPostalCode`, `ShipCountry`) VALUES
(10248, 85, 'VINET', 5, '1996-07-04 00:00:00', '1996-08-01 00:00:00', '1996-07-16 00:00:00', 3, '32.3800', 'Vins et alcools Chevalier', '59 rue de l-Abbaye', 'Reims', '', '51100', 'France'),
(10249, 79, 'TOMSP', 6, '1996-07-05 00:00:00', '1996-08-16 00:00:00', '1996-07-10 00:00:00', 1, '11.6100', 'Toms Spezialitten', 'Luisenstr. 48', 'Mnster', '', '44087', 'Germany'),
(10250, 34, 'HANAR', 4, '1996-07-08 00:00:00', '1996-08-05 00:00:00', '1996-07-12 00:00:00', 2, '65.8300', 'Hanari Carnes', 'Rua do Pao, 67', 'Rio de Janeiro', 'RJ', '05454-876', 'Brazil'),
(10251, 84, 'VICTE', 3, '1996-07-08 00:00:00', '1996-08-05 00:00:00', '1996-07-15 00:00:00', 1, '41.3400', 'Victuailles en stock', '2, rue du Commerce', 'Lyon', '', '69004', 'France'),
(10252, 76, 'SUPRD', 4, '1996-07-09 00:00:00', '1996-08-06 00:00:00', '1996-07-11 00:00:00', 2, '51.3000', 'Suprmes dlices', 'Boulevard Tirou, 255', 'Charleroi', '', 'B-6000', 'Belgium'),
(10253, 34, 'HANAR', 3, '1996-07-10 00:00:00', '1996-07-24 00:00:00', '1996-07-16 00:00:00', 2, '58.1700', 'Hanari Carnes', 'Rua do Pao, 67', 'Rio de Janeiro', 'RJ', '05454-876', 'Brazil'),
(10254, 14, 'CHOPS', 5, '1996-07-11 00:00:00', '1996-08-08 00:00:00', '1996-07-23 00:00:00', 2, '22.9800', 'Chop-suey Chinese', 'Hauptstr. 31', 'Bern', '', '3012', 'Switzerland'),
(10255, 68, 'RICSU', 9, '1996-07-12 00:00:00', '1996-08-09 00:00:00', '1996-07-15 00:00:00', 3, '148.3300', 'Richter Supermarkt', 'Starenweg 5', 'Genve', '', '1204', 'Switzerland'),
(10256, 88, 'WELLI', 3, '1996-07-15 00:00:00', '1996-08-12 00:00:00', '1996-07-17 00:00:00', 2, '13.9700', 'Wellington Importadora', 'Rua do Mercado, 12', 'Resende', 'SP', '08737-363', 'Brazil'),
(10257, 35, 'HILAA', 4, '1996-07-16 00:00:00', '1996-08-13 00:00:00', '1996-07-22 00:00:00', 3, '81.9100', 'HILARION-Abastos', 'Carrera 22 con Ave. Carlos Soublette #8-35', 'San Cristbal', 'Tchira', '5022', 'Venezuela'),
(10258, 20, 'ERNSH', 1, '1996-07-17 00:00:00', '1996-08-14 00:00:00', '1996-07-23 00:00:00', 1, '140.5100', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria'),
(10259, 13, 'CENTC', 4, '1996-07-18 00:00:00', '1996-08-15 00:00:00', '1996-07-25 00:00:00', 3, '3.2500', 'Centro comercial Moctezuma', 'Sierras de Granada 9993', 'Mxico D.F.', '', '5022', 'Mexico'),
(10260, 56, 'OTTIK', 4, '1996-07-19 00:00:00', '1996-08-16 00:00:00', '1996-07-29 00:00:00', 1, '55.0900', 'Ottilies Kseladen', 'Mehrheimerstr. 369', 'Kln', '', '50739', 'Germany'),
(10261, 61, 'QUEDE', 4, '1996-07-19 00:00:00', '1996-08-16 00:00:00', '1996-07-30 00:00:00', 2, '3.0500', 'Que Delcia', 'Rua da Panificadora, 12', 'Rio de Janeiro', 'RJ', '02389-673', 'Brazil'),
(10262, 65, 'RATTC', 8, '1996-07-22 00:00:00', '1996-08-19 00:00:00', '1996-07-25 00:00:00', 3, '48.2900', 'Rattlesnake Canyon Grocery', '2817 Milton Dr.', 'Albuquerque', 'NM', '87110', 'USA'),
(10263, 20, 'ERNSH', 9, '1996-07-23 00:00:00', '1996-08-20 00:00:00', '1996-07-31 00:00:00', 3, '146.0600', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria'),
(10264, 24, 'FOLKO', 6, '1996-07-24 00:00:00', '1996-08-21 00:00:00', '1996-08-23 00:00:00', 3, '3.6700', 'Folk och f HB', 'kergatan 24', 'Brcke', '', 'S-844 67', 'Sweden'),
(10265, 7, 'BLONP', 2, '1996-07-25 00:00:00', '1996-08-22 00:00:00', '1996-08-12 00:00:00', 1, '55.2800', 'Blondel pre et fils', '24, place Klber', 'Strasbourg', '', '67000', 'France'),
(10266, 87, 'WARTH', 3, '1996-07-26 00:00:00', '1996-09-06 00:00:00', '1996-07-31 00:00:00', 3, '25.7300', 'Wartian Herkku', 'Torikatu 38', 'Oulu', '', '90110', 'Finland'),
(10267, 25, 'FRANK', 4, '1996-07-29 00:00:00', '1996-08-26 00:00:00', '1996-08-06 00:00:00', 1, '208.5800', 'Frankenversand', 'Berliner Platz 43', 'Mnchen', '', '80805', 'Germany'),
(10268, 33, 'GROSR', 8, '1996-07-30 00:00:00', '1996-08-27 00:00:00', '1996-08-02 00:00:00', 3, '66.2900', 'GROSELLA-Restaurante', '5 Ave. Los Palos Grandes', 'Caracas', 'DF', '1081', 'Venezuela'),
(10269, 89, 'WHITC', 5, '1996-07-31 00:00:00', '1996-08-14 00:00:00', '1996-08-09 00:00:00', 1, '4.5600', 'White Clover Markets', '1029 - 12th Ave. S.', 'Seattle', 'WA', '98124', 'USA'),
(10270, 87, 'WARTH', 1, '1996-08-01 00:00:00', '1996-08-29 00:00:00', '1996-08-02 00:00:00', 1, '136.5400', 'Wartian Herkku', 'Torikatu 38', 'Oulu', '', '90110', 'Finland'),
(10271, 75, 'SPLIR', 6, '1996-08-01 00:00:00', '1996-08-29 00:00:00', '1996-08-30 00:00:00', 2, '4.5400', 'Split Rail Beer & Ale', 'P.O. Box 555', 'Lander', 'WY', '82520', 'USA'),
(10272, 65, 'RATTC', 6, '1996-08-02 00:00:00', '1996-08-30 00:00:00', '1996-08-06 00:00:00', 2, '98.0300', 'Rattlesnake Canyon Grocery', '2817 Milton Dr.', 'Albuquerque', 'NM', '87110', 'USA'),
(10273, 63, 'QUICK', 3, '1996-08-05 00:00:00', '1996-09-02 00:00:00', '1996-08-12 00:00:00', 3, '76.0700', 'QUICK-Stop', 'Taucherstrae 10', 'Cunewalde', '', '1307', 'Germany'),
(10274, 85, 'VINET', 6, '1996-08-06 00:00:00', '1996-09-03 00:00:00', '1996-08-16 00:00:00', 1, '6.0100', 'Vins et alcools Chevalier', '59 rue de l-Abbaye', 'Reims', '', '51100', 'France'),
(10275, 49, 'MAGAA', 1, '1996-08-07 00:00:00', '1996-09-04 00:00:00', '1996-08-09 00:00:00', 1, '26.9300', 'Magazzini Alimentari Riuniti', 'Via Ludovico il Moro 22', 'Bergamo', '', '24100', 'Italy'),
(10276, 80, 'TORTU', 8, '1996-08-08 00:00:00', '1996-08-22 00:00:00', '1996-08-14 00:00:00', 3, '13.8400', 'Tortuga Restaurante', 'Avda. Azteca 123', 'Mxico D.F.', '', '5033', 'Mexico'),
(10277, 52, 'MORGK', 2, '1996-08-09 00:00:00', '1996-09-06 00:00:00', '1996-08-13 00:00:00', 3, '125.7700', 'Morgenstern Gesundkost', 'Heerstr. 22', 'Leipzig', '', '4179', 'Germany'),
(10278, 5, 'BERGS', 8, '1996-08-12 00:00:00', '1996-09-09 00:00:00', '1996-08-16 00:00:00', 2, '92.6900', 'Berglunds snabbkp', 'Berguvsvgen 8', 'Lule', '', 'S-958 22', 'Sweden'),
(10279, 44, 'LEHMS', 8, '1996-08-13 00:00:00', '1996-09-10 00:00:00', '1996-08-16 00:00:00', 2, '25.8300', 'Lehmanns Marktstand', 'Magazinweg 7', 'Frankfurt a.M.', '', '60528', 'Germany'),
(10280, 5, 'BERGS', 2, '1996-08-14 00:00:00', '1996-09-11 00:00:00', '1996-09-12 00:00:00', 1, '8.9800', 'Berglunds snabbkp', 'Berguvsvgen 8', 'Lule', '', 'S-958 22', 'Sweden'),
(10281, 69, 'ROMEY', 4, '1996-08-14 00:00:00', '1996-08-28 00:00:00', '1996-08-21 00:00:00', 1, '2.9400', 'Romero y tomillo', 'Gran Va, 1', 'Madrid', '', '28001', 'Spain'),
(10282, 69, 'ROMEY', 4, '1996-08-15 00:00:00', '1996-09-12 00:00:00', '1996-08-21 00:00:00', 1, '12.6900', 'Romero y tomillo', 'Gran Va, 1', 'Madrid', '', '28001', 'Spain'),
(10283, 46, 'LILAS', 3, '1996-08-16 00:00:00', '1996-09-13 00:00:00', '1996-08-23 00:00:00', 3, '84.8100', 'LILA-Supermercado', 'Carrera 52 con Ave. Bolvar #65-98 Llano Largo', 'Barquisimeto', 'Lara', '3508', 'Venezuela'),
(10284, 44, 'LEHMS', 4, '1996-08-19 00:00:00', '1996-09-16 00:00:00', '1996-08-27 00:00:00', 1, '76.5600', 'Lehmanns Marktstand', 'Magazinweg 7', 'Frankfurt a.M.', '', '60528', 'Germany'),
(10285, 63, 'QUICK', 1, '1996-08-20 00:00:00', '1996-09-17 00:00:00', '1996-08-26 00:00:00', 2, '76.8300', 'QUICK-Stop', 'Taucherstrae 10', 'Cunewalde', '', '1307', 'Germany'),
(10286, 63, 'QUICK', 8, '1996-08-21 00:00:00', '1996-09-18 00:00:00', '1996-08-30 00:00:00', 3, '229.2400', 'QUICK-Stop', 'Taucherstrae 10', 'Cunewalde', '', '1307', 'Germany'),
(10287, 67, 'RICAR', 8, '1996-08-22 00:00:00', '1996-09-19 00:00:00', '1996-08-28 00:00:00', 3, '12.7600', 'Ricardo Adocicados', 'Av. Copacabana, 267', 'Rio de Janeiro', 'RJ', '02389-890', 'Brazil'),
(10288, 66, 'REGGC', 4, '1996-08-23 00:00:00', '1996-09-20 00:00:00', '1996-09-03 00:00:00', 1, '7.4500', 'Reggiani Caseifici', 'Strada Provinciale 124', 'Reggio Emilia', '', '42100', 'Italy'),
(10289, 11, 'BSBEV', 7, '1996-08-26 00:00:00', '1996-09-23 00:00:00', '1996-08-28 00:00:00', 3, '22.7700', 'B-s Beverages', 'Fauntleroy Circus', 'London', '', 'EC2 5NT', 'UK'),
(10290, 15, 'COMMI', 8, '1996-08-27 00:00:00', '1996-09-24 00:00:00', '1996-09-03 00:00:00', 1, '79.7000', 'Comrcio Mineiro', 'Av. dos Lusadas, 23', 'Sao Paulo', 'SP', '05432-043', 'Brazil'),
(10291, 61, 'QUEDE', 6, '1996-08-27 00:00:00', '1996-09-24 00:00:00', '1996-09-04 00:00:00', 2, '6.4000', 'Que Delcia', 'Rua da Panificadora, 12', 'Rio de Janeiro', 'RJ', '02389-673', 'Brazil'),
(10292, 81, 'TRADH', 1, '1996-08-28 00:00:00', '1996-09-25 00:00:00', '1996-09-02 00:00:00', 2, '1.3500', 'Tradiao Hipermercados', 'Av. Ins de Castro, 414', 'Sao Paulo', 'SP', '05634-030', 'Brazil'),
(10293, 80, 'TORTU', 1, '1996-08-29 00:00:00', '1996-09-26 00:00:00', '1996-09-11 00:00:00', 3, '21.1800', 'Tortuga Restaurante', 'Avda. Azteca 123', 'Mxico D.F.', '', '5033', 'Mexico'),
(10294, 65, 'RATTC', 4, '1996-08-30 00:00:00', '1996-09-27 00:00:00', '1996-09-05 00:00:00', 2, '147.2600', 'Rattlesnake Canyon Grocery', '2817 Milton Dr.', 'Albuquerque', 'NM', '87110', 'USA'),
(10295, 85, 'VINET', 2, '1996-09-02 00:00:00', '1996-09-30 00:00:00', '1996-09-10 00:00:00', 2, '1.1500', 'Vins et alcools Chevalier', '59 rue de l-Abbaye', 'Reims', '', '51100', 'France'),
(10296, 46, 'LILAS', 6, '1996-09-03 00:00:00', '1996-10-01 00:00:00', '1996-09-11 00:00:00', 1, '0.1200', 'LILA-Supermercado', 'Carrera 52 con Ave. Bolvar #65-98 Llano Largo', 'Barquisimeto', 'Lara', '3508', 'Venezuela'),
(10297, 7, 'BLONP', 5, '1996-09-04 00:00:00', '1996-10-16 00:00:00', '1996-09-10 00:00:00', 2, '5.7400', 'Blondel pre et fils', '24, place Klber', 'Strasbourg', '', '67000', 'France'),
(10298, 37, 'HUNGO', 6, '1996-09-05 00:00:00', '1996-10-03 00:00:00', '1996-09-11 00:00:00', 2, '168.2200', 'Hungry Owl All-Night Grocers', '8 Johnstown Road', 'Cork', 'Co. Cork', '', 'Ireland'),
(10299, 67, 'RICAR', 4, '1996-09-06 00:00:00', '1996-10-04 00:00:00', '1996-09-13 00:00:00', 2, '29.7600', 'Ricardo Adocicados', 'Av. Copacabana, 267', 'Rio de Janeiro', 'RJ', '02389-890', 'Brazil'),
(10300, 49, 'MAGAA', 2, '1996-09-09 00:00:00', '1996-10-07 00:00:00', '1996-09-18 00:00:00', 2, '17.6800', 'Magazzini Alimentari Riuniti', 'Via Ludovico il Moro 22', 'Bergamo', '', '24100', 'Italy'),
(10301, 86, 'WANDK', 8, '1996-09-09 00:00:00', '1996-10-07 00:00:00', '1996-09-17 00:00:00', 2, '45.0800', 'Die Wandernde Kuh', 'Adenauerallee 900', 'Stuttgart', '', '70563', 'Germany'),
(10302, 76, 'SUPRD', 4, '1996-09-10 00:00:00', '1996-10-08 00:00:00', '1996-10-09 00:00:00', 2, '6.2700', 'Suprmes dlices', 'Boulevard Tirou, 255', 'Charleroi', '', 'B-6000', 'Belgium'),
(10303, 30, 'GODOS', 7, '1996-09-11 00:00:00', '1996-10-09 00:00:00', '1996-09-18 00:00:00', 2, '107.8300', 'Godos Cocina Tpica', 'C/ Romero, 33', 'Sevilla', '', '41101', 'Spain'),
(10304, 80, 'TORTU', 1, '1996-09-12 00:00:00', '1996-10-10 00:00:00', '1996-09-17 00:00:00', 2, '63.7900', 'Tortuga Restaurante', 'Avda. Azteca 123', 'Mxico D.F.', '', '5033', 'Mexico'),
(10305, 55, 'OLDWO', 8, '1996-09-13 00:00:00', '1996-10-11 00:00:00', '1996-10-09 00:00:00', 3, '257.6200', 'Old World Delicatessen', '2743 Bering St.', 'Anchorage', 'AK', '99508', 'USA'),
(10306, 69, 'ROMEY', 1, '1996-09-16 00:00:00', '1996-10-14 00:00:00', '1996-09-23 00:00:00', 3, '7.5600', 'Romero y tomillo', 'Gran Va, 1', 'Madrid', '', '28001', 'Spain'),
(10307, 48, 'LONEP', 2, '1996-09-17 00:00:00', '1996-10-15 00:00:00', '1996-09-25 00:00:00', 2, '0.5600', 'Lonesome Pine Restaurant', '89 Chiaroscuro Rd.', 'Portland', 'OR', '97219', 'USA'),
(10308, 2, 'ANATR', 7, '1996-09-18 00:00:00', '1996-10-16 00:00:00', '1996-09-24 00:00:00', 3, '1.6100', 'Ana Trujillo Emparedados y helados', 'Avda. de la Constitucin 2222', 'Mxico D.F.', '', '5021', 'Mexico'),
(10309, 37, 'HUNGO', 3, '1996-09-19 00:00:00', '1996-10-17 00:00:00', '1996-10-23 00:00:00', 1, '47.3000', 'Hungry Owl All-Night Grocers', '8 Johnstown Road', 'Cork', 'Co. Cork', '', 'Ireland'),
(10310, 77, 'THEBI', 8, '1996-09-20 00:00:00', '1996-10-18 00:00:00', '1996-09-27 00:00:00', 2, '17.5200', 'The Big Cheese', '89 Jefferson Way Suite 2', 'Portland', 'OR', '97201', 'USA'),
(10311, 18, 'DUMON', 1, '1996-09-20 00:00:00', '1996-10-04 00:00:00', '1996-09-26 00:00:00', 3, '24.6900', 'Du monde entier', '67, rue des Cinquante Otages', 'Nantes', '', '44000', 'France'),
(10312, 86, 'WANDK', 2, '1996-09-23 00:00:00', '1996-10-21 00:00:00', '1996-10-03 00:00:00', 2, '40.2600', 'Die Wandernde Kuh', 'Adenauerallee 900', 'Stuttgart', '', '70563', 'Germany'),
(10313, 63, 'QUICK', 2, '1996-09-24 00:00:00', '1996-10-22 00:00:00', '1996-10-04 00:00:00', 2, '1.9600', 'QUICK-Stop', 'Taucherstrae 10', 'Cunewalde', '', '1307', 'Germany'),
(10314, 65, 'RATTC', 1, '1996-09-25 00:00:00', '1996-10-23 00:00:00', '1996-10-04 00:00:00', 2, '74.1600', 'Rattlesnake Canyon Grocery', '2817 Milton Dr.', 'Albuquerque', 'NM', '87110', 'USA'),
(10315, 38, 'ISLAT', 4, '1996-09-26 00:00:00', '1996-10-24 00:00:00', '1996-10-03 00:00:00', 2, '41.7600', 'Island Trading', 'Garden House Crowther Way', 'Cowes', 'Isle of Wight', 'PO31 7PJ', 'UK'),
(10316, 65, 'RATTC', 1, '1996-09-27 00:00:00', '1996-10-25 00:00:00', '1996-10-08 00:00:00', 3, '150.1500', 'Rattlesnake Canyon Grocery', '2817 Milton Dr.', 'Albuquerque', 'NM', '87110', 'USA'),
(10317, 48, 'LONEP', 6, '1996-09-30 00:00:00', '1996-10-28 00:00:00', '1996-10-10 00:00:00', 1, '12.6900', 'Lonesome Pine Restaurant', '89 Chiaroscuro Rd.', 'Portland', 'OR', '97219', 'USA'),
(10318, 38, 'ISLAT', 8, '1996-10-01 00:00:00', '1996-10-29 00:00:00', '1996-10-04 00:00:00', 2, '4.7300', 'Island Trading', 'Garden House Crowther Way', 'Cowes', 'Isle of Wight', 'PO31 7PJ', 'UK'),
(10319, 80, 'TORTU', 7, '1996-10-02 00:00:00', '1996-10-30 00:00:00', '1996-10-11 00:00:00', 3, '64.5000', 'Tortuga Restaurante', 'Avda. Azteca 123', 'Mxico D.F.', '', '5033', 'Mexico'),
(10320, 87, 'WARTH', 5, '1996-10-03 00:00:00', '1996-10-17 00:00:00', '1996-10-18 00:00:00', 3, '34.5700', 'Wartian Herkku', 'Torikatu 38', 'Oulu', '', '90110', 'Finland'),
(10321, 38, 'ISLAT', 3, '1996-10-03 00:00:00', '1996-10-31 00:00:00', '1996-10-11 00:00:00', 2, '3.4300', 'Island Trading', 'Garden House Crowther Way', 'Cowes', 'Isle of Wight', 'PO31 7PJ', 'UK'),
(10322, 58, 'PERIC', 7, '1996-10-04 00:00:00', '1996-11-01 00:00:00', '1996-10-23 00:00:00', 3, '0.4000', 'Pericles Comidas clsicas', 'Calle Dr. Jorge Cash 321', 'Mxico D.F.', '', '5033', 'Mexico'),
(10323, 39, 'KOENE', 4, '1996-10-07 00:00:00', '1996-11-04 00:00:00', '1996-10-14 00:00:00', 1, '4.8800', 'Kniglich Essen', 'Maubelstr. 90', 'Brandenburg', '', '14776', 'Germany'),
(10324, 71, 'SAVEA', 9, '1996-10-08 00:00:00', '1996-11-05 00:00:00', '1996-10-10 00:00:00', 1, '214.2700', 'Save-a-lot Markets', '187 Suffolk Ln.', 'Boise', 'ID', '83720', 'USA'),
(10325, 39, 'KOENE', 1, '1996-10-09 00:00:00', '1996-10-23 00:00:00', '1996-10-14 00:00:00', 3, '64.8600', 'Kniglich Essen', 'Maubelstr. 90', 'Brandenburg', '', '14776', 'Germany'),
(10326, 8, 'BOLID', 4, '1996-10-10 00:00:00', '1996-11-07 00:00:00', '1996-10-14 00:00:00', 2, '77.9200', 'Blido Comidas preparadas', 'C/ Araquil, 67', 'Madrid', '', '28023', 'Spain'),
(10327, 24, 'FOLKO', 2, '1996-10-11 00:00:00', '1996-11-08 00:00:00', '1996-10-14 00:00:00', 1, '63.3600', 'Folk och f HB', 'kergatan 24', 'Brcke', '', 'S-844 67', 'Sweden'),
(10328, 28, 'FURIB', 4, '1996-10-14 00:00:00', '1996-11-11 00:00:00', '1996-10-17 00:00:00', 3, '87.0300', 'Furia Bacalhau e Frutos do Mar', 'Jardim das rosas n. 32', 'Lisboa', '', '1675', 'Portugal'),
(10329, 75, 'SPLIR', 4, '1996-10-15 00:00:00', '1996-11-26 00:00:00', '1996-10-23 00:00:00', 2, '191.6700', 'Split Rail Beer & Ale', 'P.O. Box 555', 'Lander', 'WY', '82520', 'USA'),
(10330, 46, 'LILAS', 3, '1996-10-16 00:00:00', '1996-11-13 00:00:00', '1996-10-28 00:00:00', 1, '12.7500', 'LILA-Supermercado', 'Carrera 52 con Ave. Bolvar #65-98 Llano Largo', 'Barquisimeto', 'Lara', '3508', 'Venezuela'),
(10331, 9, 'BONAP', 9, '1996-10-16 00:00:00', '1996-11-27 00:00:00', '1996-10-21 00:00:00', 1, '10.1900', 'Bon app-', '12, rue des Bouchers', 'Marseille', '', '13008', 'France'),
(10332, 51, 'MEREP', 3, '1996-10-17 00:00:00', '1996-11-28 00:00:00', '1996-10-21 00:00:00', 2, '52.8400', 'Mre Paillarde', '43 rue St. Laurent', 'Montral', 'Qubec', 'H1J 1C3', 'Canada'),
(10333, 87, 'WARTH', 5, '1996-10-18 00:00:00', '1996-11-15 00:00:00', '1996-10-25 00:00:00', 3, '0.5900', 'Wartian Herkku', 'Torikatu 38', 'Oulu', '', '90110', 'Finland'),
(10334, 84, 'VICTE', 8, '1996-10-21 00:00:00', '1996-11-18 00:00:00', '1996-10-28 00:00:00', 2, '8.5600', 'Victuailles en stock', '2, rue du Commerce', 'Lyon', '', '69004', 'France'),
(10335, 37, 'HUNGO', 7, '1996-10-22 00:00:00', '1996-11-19 00:00:00', '1996-10-24 00:00:00', 2, '42.1100', 'Hungry Owl All-Night Grocers', '8 Johnstown Road', 'Cork', 'Co. Cork', '', 'Ireland'),
(10336, 60, 'PRINI', 7, '1996-10-23 00:00:00', '1996-11-20 00:00:00', '1996-10-25 00:00:00', 2, '15.5100', 'Princesa Isabel Vinhos', 'Estrada da sade n. 58', 'Lisboa', '', '1756', 'Portugal'),
(10337, 25, 'FRANK', 4, '1996-10-24 00:00:00', '1996-11-21 00:00:00', '1996-10-29 00:00:00', 3, '108.2600', 'Frankenversand', 'Berliner Platz 43', 'Mnchen', '', '80805', 'Germany'),
(10338, 55, 'OLDWO', 4, '1996-10-25 00:00:00', '1996-11-22 00:00:00', '1996-10-29 00:00:00', 3, '84.2100', 'Old World Delicatessen', '2743 Bering St.', 'Anchorage', 'AK', '99508', 'USA'),
(10339, 51, 'MEREP', 2, '1996-10-28 00:00:00', '1996-11-25 00:00:00', '1996-11-04 00:00:00', 2, '15.6600', 'Mre Paillarde', '43 rue St. Laurent', 'Montral', 'Qubec', 'H1J 1C3', 'Canada'),
(10340, 9, 'BONAP', 1, '1996-10-29 00:00:00', '1996-11-26 00:00:00', '1996-11-08 00:00:00', 3, '166.3100', 'Bon app-', '12, rue des Bouchers', 'Marseille', '', '13008', 'France'),
(10341, 73, 'SIMOB', 7, '1996-10-29 00:00:00', '1996-11-26 00:00:00', '1996-11-05 00:00:00', 3, '26.7800', 'Simons bistro', 'Vinbltet 34', 'Kobenhavn', '', '1734', 'Denmark'),
(10342, 25, 'FRANK', 4, '1996-10-30 00:00:00', '1996-11-13 00:00:00', '1996-11-04 00:00:00', 2, '54.8300', 'Frankenversand', 'Berliner Platz 43', 'Mnchen', '', '80805', 'Germany'),
(10343, 44, 'LEHMS', 4, '1996-10-31 00:00:00', '1996-11-28 00:00:00', '1996-11-06 00:00:00', 1, '110.3700', 'Lehmanns Marktstand', 'Magazinweg 7', 'Frankfurt a.M.', '', '60528', 'Germany'),
(10344, 89, 'WHITC', 4, '1996-11-01 00:00:00', '1996-11-29 00:00:00', '1996-11-05 00:00:00', 2, '23.2900', 'White Clover Markets', '1029 - 12th Ave. S.', 'Seattle', 'WA', '98124', 'USA'),
(10345, 63, 'QUICK', 2, '1996-11-04 00:00:00', '1996-12-02 00:00:00', '1996-11-11 00:00:00', 2, '249.0600', 'QUICK-Stop', 'Taucherstrae 10', 'Cunewalde', '', '1307', 'Germany'),
(10346, 65, 'RATTC', 3, '1996-11-05 00:00:00', '1996-12-17 00:00:00', '1996-11-08 00:00:00', 3, '142.0800', 'Rattlesnake Canyon Grocery', '2817 Milton Dr.', 'Albuquerque', 'NM', '87110', 'USA'),
(10347, 21, 'FAMIA', 4, '1996-11-06 00:00:00', '1996-12-04 00:00:00', '1996-11-08 00:00:00', 3, '3.1000', 'Familia Arquibaldo', 'Rua Ors, 92', 'Sao Paulo', 'SP', '05442-030', 'Brazil'),
(10348, 86, 'WANDK', 4, '1996-11-07 00:00:00', '1996-12-05 00:00:00', '1996-11-15 00:00:00', 2, '0.7800', 'Die Wandernde Kuh', 'Adenauerallee 900', 'Stuttgart', '', '70563', 'Germany'),
(10349, 75, 'SPLIR', 7, '1996-11-08 00:00:00', '1996-12-06 00:00:00', '1996-11-15 00:00:00', 1, '8.6300', 'Split Rail Beer & Ale', 'P.O. Box 555', 'Lander', 'WY', '82520', 'USA'),
(10350, 41, 'LAMAI', 6, '1996-11-11 00:00:00', '1996-12-09 00:00:00', '1996-12-03 00:00:00', 2, '64.1900', 'La maison d-Asie', '1 rue Alsace-Lorraine', 'Toulouse', '', '31000', 'France'),
(10351, 20, 'ERNSH', 1, '1996-11-11 00:00:00', '1996-12-09 00:00:00', '1996-11-20 00:00:00', 1, '162.3300', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria'),
(10352, 28, 'FURIB', 3, '1996-11-12 00:00:00', '1996-11-26 00:00:00', '1996-11-18 00:00:00', 3, '1.3000', 'Furia Bacalhau e Frutos do Mar', 'Jardim das rosas n. 32', 'Lisboa', '', '1675', 'Portugal'),
(10353, 59, 'PICCO', 7, '1996-11-13 00:00:00', '1996-12-11 00:00:00', '1996-11-25 00:00:00', 3, '360.6300', 'Piccolo und mehr', 'Geislweg 14', 'Salzburg', '', '5020', 'Austria'),
(10354, 58, 'PERIC', 8, '1996-11-14 00:00:00', '1996-12-12 00:00:00', '1996-11-20 00:00:00', 3, '53.8000', 'Pericles Comidas clsicas', 'Calle Dr. Jorge Cash 321', 'Mxico D.F.', '', '5033', 'Mexico'),
(10355, 4, 'AROUT', 6, '1996-11-15 00:00:00', '1996-12-13 00:00:00', '1996-11-20 00:00:00', 1, '41.9500', 'Around the Horn', 'Brook Farm Stratford St. Mary', 'Colchester', 'Essex', 'CO7 6JX', 'UK'),
(10356, 86, 'WANDK', 6, '1996-11-18 00:00:00', '1996-12-16 00:00:00', '1996-11-27 00:00:00', 2, '36.7100', 'Die Wandernde Kuh', 'Adenauerallee 900', 'Stuttgart', '', '70563', 'Germany'),
(10357, 46, 'LILAS', 1, '1996-11-19 00:00:00', '1996-12-17 00:00:00', '1996-12-02 00:00:00', 3, '34.8800', 'LILA-Supermercado', 'Carrera 52 con Ave. Bolvar #65-98 Llano Largo', 'Barquisimeto', 'Lara', '3508', 'Venezuela'),
(10358, 41, 'LAMAI', 5, '1996-11-20 00:00:00', '1996-12-18 00:00:00', '1996-11-27 00:00:00', 1, '19.6400', 'La maison d-Asie', '1 rue Alsace-Lorraine', 'Toulouse', '', '31000', 'France'),
(10359, 72, 'SEVES', 5, '1996-11-21 00:00:00', '1996-12-19 00:00:00', '1996-11-26 00:00:00', 3, '288.4300', 'Seven Seas Imports', '90 Wadhurst Rd.', 'London', '', 'OX15 4NB', 'UK'),
(10360, 7, 'BLONP', 4, '1996-11-22 00:00:00', '1996-12-20 00:00:00', '1996-12-02 00:00:00', 3, '131.7000', 'Blondel pre et fils', '24, place Klber', 'Strasbourg', '', '67000', 'France'),
(10361, 63, 'QUICK', 1, '1996-11-22 00:00:00', '1996-12-20 00:00:00', '1996-12-03 00:00:00', 2, '183.1700', 'QUICK-Stop', 'Taucherstrae 10', 'Cunewalde', '', '1307', 'Germany'),
(10362, 9, 'BONAP', 3, '1996-11-25 00:00:00', '1996-12-23 00:00:00', '1996-11-28 00:00:00', 1, '96.0400', 'Bon app-', '12, rue des Bouchers', 'Marseille', '', '13008', 'France'),
(10363, 17, 'DRACD', 4, '1996-11-26 00:00:00', '1996-12-24 00:00:00', '1996-12-04 00:00:00', 3, '30.5400', 'Drachenblut Delikatessen', 'Walserweg 21', 'Aachen', '', '52066', 'Germany'),
(10364, 19, 'EASTC', 1, '1996-11-26 00:00:00', '1997-01-07 00:00:00', '1996-12-04 00:00:00', 1, '71.9700', 'Eastern Connection', '35 King George', 'London', '', 'WX3 6FW', 'UK'),
(10365, 3, 'ANTON', 3, '1996-11-27 00:00:00', '1996-12-25 00:00:00', '1996-12-02 00:00:00', 2, '22.0000', 'Antonio Moreno Taquera', 'Mataderos 2312', 'Mxico D.F.', '', '5023', 'Mexico'),
(10366, 29, 'GALED', 8, '1996-11-28 00:00:00', '1997-01-09 00:00:00', '1996-12-30 00:00:00', 2, '10.1400', 'Galera del gastronmo', 'Rambla de Catalua, 23', 'Barcelona', '', '8022', 'Spain'),
(10367, 83, 'VAFFE', 7, '1996-11-28 00:00:00', '1996-12-26 00:00:00', '1996-12-02 00:00:00', 3, '13.5500', 'Vaffeljernet', 'Smagsloget 45', 'rhus', '', '8200', 'Denmark'),
(10368, 20, 'ERNSH', 2, '1996-11-29 00:00:00', '1996-12-27 00:00:00', '1996-12-02 00:00:00', 2, '101.9500', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria'),
(10369, 75, 'SPLIR', 8, '1996-12-02 00:00:00', '1996-12-30 00:00:00', '1996-12-09 00:00:00', 2, '195.6800', 'Split Rail Beer & Ale', 'P.O. Box 555', 'Lander', 'WY', '82520', 'USA'),
(10370, 14, 'CHOPS', 6, '1996-12-03 00:00:00', '1996-12-31 00:00:00', '1996-12-27 00:00:00', 2, '1.1700', 'Chop-suey Chinese', 'Hauptstr. 31', 'Bern', '', '3012', 'Switzerland'),
(10371, 41, 'LAMAI', 1, '1996-12-03 00:00:00', '1996-12-31 00:00:00', '1996-12-24 00:00:00', 1, '0.4500', 'La maison d-Asie', '1 rue Alsace-Lorraine', 'Toulouse', '', '31000', 'France'),
(10372, 62, 'QUEEN', 5, '1996-12-04 00:00:00', '1997-01-01 00:00:00', '1996-12-09 00:00:00', 2, '890.7800', 'Queen Cozinha', 'Alameda dos Canrios, 891', 'Sao Paulo', 'SP', '05487-020', 'Brazil'),
(10373, 37, 'HUNGO', 4, '1996-12-05 00:00:00', '1997-01-02 00:00:00', '1996-12-11 00:00:00', 3, '124.1200', 'Hungry Owl All-Night Grocers', '8 Johnstown Road', 'Cork', 'Co. Cork', '', 'Ireland'),
(10374, 91, 'WOLZA', 1, '1996-12-05 00:00:00', '1997-01-02 00:00:00', '1996-12-09 00:00:00', 3, '3.9400', 'Wolski Zajazd', 'ul. Filtrowa 68', 'Warszawa', '', '01-012', 'Poland'),
(10375, 36, 'HUNGC', 3, '1996-12-06 00:00:00', '1997-01-03 00:00:00', '1996-12-09 00:00:00', 2, '20.1200', 'Hungry Coyote Import Store', 'City Center Plaza 516 Main St.', 'Elgin', 'OR', '97827', 'USA'),
(10376, 51, 'MEREP', 1, '1996-12-09 00:00:00', '1997-01-06 00:00:00', '1996-12-13 00:00:00', 2, '20.3900', 'Mre Paillarde', '43 rue St. Laurent', 'Montral', 'Qubec', 'H1J 1C3', 'Canada'),
(10377, 72, 'SEVES', 1, '1996-12-09 00:00:00', '1997-01-06 00:00:00', '1996-12-13 00:00:00', 3, '22.2100', 'Seven Seas Imports', '90 Wadhurst Rd.', 'London', '', 'OX15 4NB', 'UK'),
(10378, 24, 'FOLKO', 5, '1996-12-10 00:00:00', '1997-01-07 00:00:00', '1996-12-19 00:00:00', 3, '5.4400', 'Folk och f HB', 'kergatan 24', 'Brcke', '', 'S-844 67', 'Sweden'),
(10379, 61, 'QUEDE', 2, '1996-12-11 00:00:00', '1997-01-08 00:00:00', '1996-12-13 00:00:00', 1, '45.0300', 'Que Delcia', 'Rua da Panificadora, 12', 'Rio de Janeiro', 'RJ', '02389-673', 'Brazil'),
(10380, 37, 'HUNGO', 8, '1996-12-12 00:00:00', '1997-01-09 00:00:00', '1997-01-16 00:00:00', 3, '35.0300', 'Hungry Owl All-Night Grocers', '8 Johnstown Road', 'Cork', 'Co. Cork', '', 'Ireland'),
(10381, 46, 'LILAS', 3, '1996-12-12 00:00:00', '1997-01-09 00:00:00', '1996-12-13 00:00:00', 3, '7.9900', 'LILA-Supermercado', 'Carrera 52 con Ave. Bolvar #65-98 Llano Largo', 'Barquisimeto', 'Lara', '3508', 'Venezuela'),
(10382, 20, 'ERNSH', 4, '1996-12-13 00:00:00', '1997-01-10 00:00:00', '1996-12-16 00:00:00', 1, '94.7700', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria'),
(10383, 4, 'AROUT', 8, '1996-12-16 00:00:00', '1997-01-13 00:00:00', '1996-12-18 00:00:00', 3, '34.2400', 'Around the Horn', 'Brook Farm Stratford St. Mary', 'Colchester', 'Essex', 'CO7 6JX', 'UK'),
(10384, 5, 'BERGS', 3, '1996-12-16 00:00:00', '1997-01-13 00:00:00', '1996-12-20 00:00:00', 3, '168.6400', 'Berglunds snabbkp', 'Berguvsvgen 8', 'Lule', '', 'S-958 22', 'Sweden'),
(10385, 75, 'SPLIR', 1, '1996-12-17 00:00:00', '1997-01-14 00:00:00', '1996-12-23 00:00:00', 2, '30.9600', 'Split Rail Beer & Ale', 'P.O. Box 555', 'Lander', 'WY', '82520', 'USA'),
(10386, 21, 'FAMIA', 9, '1996-12-18 00:00:00', '1997-01-01 00:00:00', '1996-12-25 00:00:00', 3, '13.9900', 'Familia Arquibaldo', 'Rua Ors, 92', 'Sao Paulo', 'SP', '05442-030', 'Brazil'),
(10387, 70, 'SANTG', 1, '1996-12-18 00:00:00', '1997-01-15 00:00:00', '1996-12-20 00:00:00', 2, '93.6300', 'Sant Gourmet', 'Erling Skakkes gate 78', 'Stavern', '', '4110', 'Norway'),
(10388, 72, 'SEVES', 2, '1996-12-19 00:00:00', '1997-01-16 00:00:00', '1996-12-20 00:00:00', 1, '34.8600', 'Seven Seas Imports', '90 Wadhurst Rd.', 'London', '', 'OX15 4NB', 'UK'),
(10389, 10, 'BOTTM', 4, '1996-12-20 00:00:00', '1997-01-17 00:00:00', '1996-12-24 00:00:00', 2, '47.4200', 'Bottom-Dollar Markets', '23 Tsawassen Blvd.', 'Tsawassen', 'BC', 'T2F 8M4', 'Canada'),
(10390, 20, 'ERNSH', 6, '1996-12-23 00:00:00', '1997-01-20 00:00:00', '1996-12-26 00:00:00', 1, '126.3800', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria'),
(10391, 17, 'DRACD', 3, '1996-12-23 00:00:00', '1997-01-20 00:00:00', '1996-12-31 00:00:00', 3, '5.4500', 'Drachenblut Delikatessen', 'Walserweg 21', 'Aachen', '', '52066', 'Germany'),
(10392, 59, 'PICCO', 2, '1996-12-24 00:00:00', '1997-01-21 00:00:00', '1997-01-01 00:00:00', 3, '122.4600', 'Piccolo und mehr', 'Geislweg 14', 'Salzburg', '', '5020', 'Austria'),
(10393, 71, 'SAVEA', 1, '1996-12-25 00:00:00', '1997-01-22 00:00:00', '1997-01-03 00:00:00', 3, '126.5600', 'Save-a-lot Markets', '187 Suffolk Ln.', 'Boise', 'ID', '83720', 'USA'),
(10394, 36, 'HUNGC', 1, '1996-12-25 00:00:00', '1997-01-22 00:00:00', '1997-01-03 00:00:00', 3, '30.3400', 'Hungry Coyote Import Store', 'City Center Plaza 516 Main St.', 'Elgin', 'OR', '97827', 'USA'),
(10395, 35, 'HILAA', 6, '1996-12-26 00:00:00', '1997-01-23 00:00:00', '1997-01-03 00:00:00', 1, '184.4100', 'HILARION-Abastos', 'Carrera 22 con Ave. Carlos Soublette #8-35', 'San Cristbal', 'Tchira', '5022', 'Venezuela'),
(10396, 25, 'FRANK', 1, '1996-12-27 00:00:00', '1997-01-10 00:00:00', '1997-01-06 00:00:00', 3, '135.3500', 'Frankenversand', 'Berliner Platz 43', 'Mnchen', '', '80805', 'Germany'),
(10397, 60, 'PRINI', 5, '1996-12-27 00:00:00', '1997-01-24 00:00:00', '1997-01-02 00:00:00', 1, '60.2600', 'Princesa Isabel Vinhos', 'Estrada da sade n. 58', 'Lisboa', '', '1756', 'Portugal'),
(10398, 71, 'SAVEA', 2, '1996-12-30 00:00:00', '1997-01-27 00:00:00', '1997-01-09 00:00:00', 3, '89.1600', 'Save-a-lot Markets', '187 Suffolk Ln.', 'Boise', 'ID', '83720', 'USA'),
(10399, 83, 'VAFFE', 8, '1996-12-31 00:00:00', '1997-01-14 00:00:00', '1997-01-08 00:00:00', 3, '27.3600', 'Vaffeljernet', 'Smagsloget 45', 'rhus', '', '8200', 'Denmark'),
(10400, 19, 'EASTC', 1, '1997-01-01 00:00:00', '1997-01-29 00:00:00', '1997-01-16 00:00:00', 3, '83.9300', 'Eastern Connection', '35 King George', 'London', '', 'WX3 6FW', 'UK'),
(10401, 65, 'RATTC', 1, '1997-01-01 00:00:00', '1997-01-29 00:00:00', '1997-01-10 00:00:00', 1, '12.5100', 'Rattlesnake Canyon Grocery', '2817 Milton Dr.', 'Albuquerque', 'NM', '87110', 'USA'),
(10402, 20, 'ERNSH', 8, '1997-01-02 00:00:00', '1997-02-13 00:00:00', '1997-01-10 00:00:00', 2, '67.8800', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria'),
(10403, 20, 'ERNSH', 4, '1997-01-03 00:00:00', '1997-01-31 00:00:00', '1997-01-09 00:00:00', 3, '73.7900', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria'),
(10404, 49, 'MAGAA', 2, '1997-01-03 00:00:00', '1997-01-31 00:00:00', '1997-01-08 00:00:00', 1, '155.9700', 'Magazzini Alimentari Riuniti', 'Via Ludovico il Moro 22', 'Bergamo', '', '24100', 'Italy'),
(10405, 47, 'LINOD', 1, '1997-01-06 00:00:00', '1997-02-03 00:00:00', '1997-01-22 00:00:00', 1, '34.8200', 'LINO-Delicateses', 'Ave. 5 de Mayo Porlamar', 'I. de Margarita', 'Nueva Esparta', '4980', 'Venezuela'),
(10406, 62, 'QUEEN', 7, '1997-01-07 00:00:00', '1997-02-18 00:00:00', '1997-01-13 00:00:00', 1, '108.0400', 'Queen Cozinha', 'Alameda dos Canrios, 891', 'Sao Paulo', 'SP', '05487-020', 'Brazil'),
(10407, 56, 'OTTIK', 2, '1997-01-07 00:00:00', '1997-02-04 00:00:00', '1997-01-30 00:00:00', 2, '91.4800', 'Ottilies Kseladen', 'Mehrheimerstr. 369', 'Kln', '', '50739', 'Germany'),
(10408, 23, 'FOLIG', 8, '1997-01-08 00:00:00', '1997-02-05 00:00:00', '1997-01-14 00:00:00', 1, '11.2600', 'Folies gourmandes', '184, chausse de Tournai', 'Lille', '', '59000', 'France'),
(10409, 54, 'OCEAN', 3, '1997-01-09 00:00:00', '1997-02-06 00:00:00', '1997-01-14 00:00:00', 1, '29.8300', 'Ocano Atlntico Ltda.', 'Ing. Gustavo Moncada 8585 Piso 20-A', 'Buenos Aires', '', '1010', 'Argentina'),
(10410, 10, 'BOTTM', 3, '1997-01-10 00:00:00', '1997-02-07 00:00:00', '1997-01-15 00:00:00', 3, '2.4000', 'Bottom-Dollar Markets', '23 Tsawassen Blvd.', 'Tsawassen', 'BC', 'T2F 8M4', 'Canada'),
(10411, 10, 'BOTTM', 9, '1997-01-10 00:00:00', '1997-02-07 00:00:00', '1997-01-21 00:00:00', 3, '23.6500', 'Bottom-Dollar Markets', '23 Tsawassen Blvd.', 'Tsawassen', 'BC', 'T2F 8M4', 'Canada'),
(10412, 87, 'WARTH', 8, '1997-01-13 00:00:00', '1997-02-10 00:00:00', '1997-01-15 00:00:00', 2, '3.7700', 'Wartian Herkku', 'Torikatu 38', 'Oulu', '', '90110', 'Finland'),
(10413, 41, 'LAMAI', 3, '1997-01-14 00:00:00', '1997-02-11 00:00:00', '1997-01-16 00:00:00', 2, '95.6600', 'La maison d-Asie', '1 rue Alsace-Lorraine', 'Toulouse', '', '31000', 'France'),
(10414, 21, 'FAMIA', 2, '1997-01-14 00:00:00', '1997-02-11 00:00:00', '1997-01-17 00:00:00', 3, '21.4800', 'Familia Arquibaldo', 'Rua Ors, 92', 'Sao Paulo', 'SP', '05442-030', 'Brazil'),
(10415, 36, 'HUNGC', 3, '1997-01-15 00:00:00', '1997-02-12 00:00:00', '1997-01-24 00:00:00', 1, '0.2000', 'Hungry Coyote Import Store', 'City Center Plaza 516 Main St.', 'Elgin', 'OR', '97827', 'USA'),
(10416, 87, 'WARTH', 8, '1997-01-16 00:00:00', '1997-02-13 00:00:00', '1997-01-27 00:00:00', 3, '22.7200', 'Wartian Herkku', 'Torikatu 38', 'Oulu', '', '90110', 'Finland'),
(10417, 73, 'SIMOB', 4, '1997-01-16 00:00:00', '1997-02-13 00:00:00', '1997-01-28 00:00:00', 3, '70.2900', 'Simons bistro', 'Vinbltet 34', 'Kobenhavn', '', '1734', 'Denmark'),
(10418, 63, 'QUICK', 4, '1997-01-17 00:00:00', '1997-02-14 00:00:00', '1997-01-24 00:00:00', 1, '17.5500', 'QUICK-Stop', 'Taucherstrae 10', 'Cunewalde', '', '1307', 'Germany'),
(10419, 68, 'RICSU', 4, '1997-01-20 00:00:00', '1997-02-17 00:00:00', '1997-01-30 00:00:00', 2, '137.3500', 'Richter Supermarkt', 'Starenweg 5', 'Genve', '', '1204', 'Switzerland'),
(10420, 88, 'WELLI', 3, '1997-01-21 00:00:00', '1997-02-18 00:00:00', '1997-01-27 00:00:00', 1, '44.1200', 'Wellington Importadora', 'Rua do Mercado, 12', 'Resende', 'SP', '08737-363', 'Brazil'),
(10421, 61, 'QUEDE', 8, '1997-01-21 00:00:00', '1997-03-04 00:00:00', '1997-01-27 00:00:00', 1, '99.2300', 'Que Delcia', 'Rua da Panificadora, 12', 'Rio de Janeiro', 'RJ', '02389-673', 'Brazil'),
(10422, 27, 'FRANS', 2, '1997-01-22 00:00:00', '1997-02-19 00:00:00', '1997-01-31 00:00:00', 1, '3.0200', 'Franchi S.p.A.', 'Via Monte Bianco 34', 'Torino', '', '10100', 'Italy'),
(10423, 31, 'GOURL', 6, '1997-01-23 00:00:00', '1997-02-06 00:00:00', '1997-02-24 00:00:00', 3, '24.5000', 'Gourmet Lanchonetes', 'Av. Brasil, 442', 'Campinas', 'SP', '04876-786', 'Brazil'),
(10424, 51, 'MEREP', 7, '1997-01-23 00:00:00', '1997-02-20 00:00:00', '1997-01-27 00:00:00', 2, '370.6100', 'Mre Paillarde', '43 rue St. Laurent', 'Montral', 'Qubec', 'H1J 1C3', 'Canada'),
(10425, 41, 'LAMAI', 6, '1997-01-24 00:00:00', '1997-02-21 00:00:00', '1997-02-14 00:00:00', 2, '7.9300', 'La maison d-Asie', '1 rue Alsace-Lorraine', 'Toulouse', '', '31000', 'France'),
(10426, 29, 'GALED', 4, '1997-01-27 00:00:00', '1997-02-24 00:00:00', '1997-02-06 00:00:00', 1, '18.6900', 'Galera del gastronmo', 'Rambla de Catalua, 23', 'Barcelona', '', '8022', 'Spain'),
(10427, 59, 'PICCO', 4, '1997-01-27 00:00:00', '1997-02-24 00:00:00', '1997-03-03 00:00:00', 2, '31.2900', 'Piccolo und mehr', 'Geislweg 14', 'Salzburg', '', '5020', 'Austria'),
(10428, 66, 'REGGC', 7, '1997-01-28 00:00:00', '1997-02-25 00:00:00', '1997-02-04 00:00:00', 1, '11.0900', 'Reggiani Caseifici', 'Strada Provinciale 124', 'Reggio Emilia', '', '42100', 'Italy'),
(10429, 37, 'HUNGO', 3, '1997-01-29 00:00:00', '1997-03-12 00:00:00', '1997-02-07 00:00:00', 2, '56.6300', 'Hungry Owl All-Night Grocers', '8 Johnstown Road', 'Cork', 'Co. Cork', '', 'Ireland'),
(10430, 20, 'ERNSH', 4, '1997-01-30 00:00:00', '1997-02-13 00:00:00', '1997-02-03 00:00:00', 1, '458.7800', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria'),
(10431, 10, 'BOTTM', 4, '1997-01-30 00:00:00', '1997-02-13 00:00:00', '1997-02-07 00:00:00', 2, '44.1700', 'Bottom-Dollar Markets', '23 Tsawassen Blvd.', 'Tsawassen', 'BC', 'T2F 8M4', 'Canada'),
(10432, 75, 'SPLIR', 3, '1997-01-31 00:00:00', '1997-02-14 00:00:00', '1997-02-07 00:00:00', 2, '4.3400', 'Split Rail Beer & Ale', 'P.O. Box 555', 'Lander', 'WY', '82520', 'USA'),
(10433, 60, 'PRINI', 3, '1997-02-03 00:00:00', '1997-03-03 00:00:00', '1997-03-04 00:00:00', 3, '73.8300', 'Princesa Isabel Vinhos', 'Estrada da sade n. 58', 'Lisboa', '', '1756', 'Portugal'),
(10434, 24, 'FOLKO', 3, '1997-02-03 00:00:00', '1997-03-03 00:00:00', '1997-02-13 00:00:00', 2, '17.9200', 'Folk och f HB', 'kergatan 24', 'Brcke', '', 'S-844 67', 'Sweden'),
(10435, 16, 'CONSH', 8, '1997-02-04 00:00:00', '1997-03-18 00:00:00', '1997-02-07 00:00:00', 2, '9.2100', 'Consolidated Holdings', 'Berkeley Gardens 12 Brewery', 'London', '', 'WX1 6LT', 'UK'),
(10436, 7, 'BLONP', 3, '1997-02-05 00:00:00', '1997-03-05 00:00:00', '1997-02-11 00:00:00', 2, '156.6600', 'Blondel pre et fils', '24, place Klber', 'Strasbourg', '', '67000', 'France'),
(10437, 87, 'WARTH', 8, '1997-02-05 00:00:00', '1997-03-05 00:00:00', '1997-02-12 00:00:00', 1, '19.9700', 'Wartian Herkku', 'Torikatu 38', 'Oulu', '', '90110', 'Finland'),
(10438, 79, 'TOMSP', 3, '1997-02-06 00:00:00', '1997-03-06 00:00:00', '1997-02-14 00:00:00', 2, '8.2400', 'Toms Spezialitten', 'Luisenstr. 48', 'Mnster', '', '44087', 'Germany'),
(10439, 51, 'MEREP', 6, '1997-02-07 00:00:00', '1997-03-07 00:00:00', '1997-02-10 00:00:00', 3, '4.0700', 'Mre Paillarde', '43 rue St. Laurent', 'Montral', 'Qubec', 'H1J 1C3', 'Canada'),
(10440, 71, 'SAVEA', 4, '1997-02-10 00:00:00', '1997-03-10 00:00:00', '1997-02-28 00:00:00', 2, '86.5300', 'Save-a-lot Markets', '187 Suffolk Ln.', 'Boise', 'ID', '83720', 'USA'),
(10441, 55, 'OLDWO', 3, '1997-02-10 00:00:00', '1997-03-24 00:00:00', '1997-03-14 00:00:00', 2, '73.0200', 'Old World Delicatessen', '2743 Bering St.', 'Anchorage', 'AK', '99508', 'USA'),
(10442, 20, 'ERNSH', 3, '1997-02-11 00:00:00', '1997-03-11 00:00:00', '1997-02-18 00:00:00', 2, '47.9400', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria'),
(10443, 66, 'REGGC', 8, '1997-02-12 00:00:00', '1997-03-12 00:00:00', '1997-02-14 00:00:00', 1, '13.9500', 'Reggiani Caseifici', 'Strada Provinciale 124', 'Reggio Emilia', '', '42100', 'Italy'),
(10444, 5, 'BERGS', 3, '1997-02-12 00:00:00', '1997-03-12 00:00:00', '1997-02-21 00:00:00', 3, '3.5000', 'Berglunds snabbkp', 'Berguvsvgen 8', 'Lule', '', 'S-958 22', 'Sweden'),
(10445, 5, 'BERGS', 3, '1997-02-13 00:00:00', '1997-03-13 00:00:00', '1997-02-20 00:00:00', 1, '9.3000', 'Berglunds snabbkp', 'Berguvsvgen 8', 'Lule', '', 'S-958 22', 'Sweden'),
(10446, 79, 'TOMSP', 6, '1997-02-14 00:00:00', '1997-03-14 00:00:00', '1997-02-19 00:00:00', 1, '14.6800', 'Toms Spezialitten', 'Luisenstr. 48', 'Mnster', '', '44087', 'Germany'),
(10447, 67, 'RICAR', 4, '1997-02-14 00:00:00', '1997-03-14 00:00:00', '1997-03-07 00:00:00', 2, '68.6600', 'Ricardo Adocicados', 'Av. Copacabana, 267', 'Rio de Janeiro', 'RJ', '02389-890', 'Brazil'),
(10448, 64, 'RANCH', 4, '1997-02-17 00:00:00', '1997-03-17 00:00:00', '1997-02-24 00:00:00', 2, '38.8200', 'Rancho grande', 'Av. del Libertador 900', 'Buenos Aires', '', '1010', 'Argentina'),
(10449, 7, 'BLONP', 3, '1997-02-18 00:00:00', '1997-03-18 00:00:00', '1997-02-27 00:00:00', 2, '53.3000', 'Blondel pre et fils', '24, place Klber', 'Strasbourg', '', '67000', 'France'),
(10450, 84, 'VICTE', 8, '1997-02-19 00:00:00', '1997-03-19 00:00:00', '1997-03-11 00:00:00', 2, '7.2300', 'Victuailles en stock', '2, rue du Commerce', 'Lyon', '', '69004', 'France'),
(10451, 63, 'QUICK', 4, '1997-02-19 00:00:00', '1997-03-05 00:00:00', '1997-03-12 00:00:00', 3, '189.0900', 'QUICK-Stop', 'Taucherstrae 10', 'Cunewalde', '', '1307', 'Germany'),
(10452, 71, 'SAVEA', 8, '1997-02-20 00:00:00', '1997-03-20 00:00:00', '1997-02-26 00:00:00', 1, '140.2600', 'Save-a-lot Markets', '187 Suffolk Ln.', 'Boise', 'ID', '83720', 'USA'),
(10453, 4, 'AROUT', 1, '1997-02-21 00:00:00', '1997-03-21 00:00:00', '1997-02-26 00:00:00', 2, '25.3600', 'Around the Horn', 'Brook Farm Stratford St. Mary', 'Colchester', 'Essex', 'CO7 6JX', 'UK'),
(10454, 41, 'LAMAI', 4, '1997-02-21 00:00:00', '1997-03-21 00:00:00', '1997-02-25 00:00:00', 3, '2.7400', 'La maison d-Asie', '1 rue Alsace-Lorraine', 'Toulouse', '', '31000', 'France'),
(10455, 87, 'WARTH', 8, '1997-02-24 00:00:00', '1997-04-07 00:00:00', '1997-03-03 00:00:00', 2, '180.4500', 'Wartian Herkku', 'Torikatu 38', 'Oulu', '', '90110', 'Finland'),
(10456, 39, 'KOENE', 8, '1997-02-25 00:00:00', '1997-04-08 00:00:00', '1997-02-28 00:00:00', 2, '8.1200', 'Kniglich Essen', 'Maubelstr. 90', 'Brandenburg', '', '14776', 'Germany'),
(10457, 39, 'KOENE', 2, '1997-02-25 00:00:00', '1997-03-25 00:00:00', '1997-03-03 00:00:00', 1, '11.5700', 'Kniglich Essen', 'Maubelstr. 90', 'Brandenburg', '', '14776', 'Germany'),
(10458, 76, 'SUPRD', 7, '1997-02-26 00:00:00', '1997-03-26 00:00:00', '1997-03-04 00:00:00', 3, '147.0600', 'Suprmes dlices', 'Boulevard Tirou, 255', 'Charleroi', '', 'B-6000', 'Belgium'),
(10459, 84, 'VICTE', 4, '1997-02-27 00:00:00', '1997-03-27 00:00:00', '1997-02-28 00:00:00', 2, '25.0900', 'Victuailles en stock', '2, rue du Commerce', 'Lyon', '', '69004', 'France'),
(10460, 24, 'FOLKO', 8, '1997-02-28 00:00:00', '1997-03-28 00:00:00', '1997-03-03 00:00:00', 1, '16.2700', 'Folk och f HB', 'kergatan 24', 'Brcke', '', 'S-844 67', 'Sweden'),
(10461, 46, 'LILAS', 1, '1997-02-28 00:00:00', '1997-03-28 00:00:00', '1997-03-05 00:00:00', 3, '148.6100', 'LILA-Supermercado', 'Carrera 52 con Ave. Bolvar #65-98 Llano Largo', 'Barquisimeto', 'Lara', '3508', 'Venezuela'),
(10462, 16, 'CONSH', 2, '1997-03-03 00:00:00', '1997-03-31 00:00:00', '1997-03-18 00:00:00', 1, '6.1700', 'Consolidated Holdings', 'Berkeley Gardens 12 Brewery', 'London', '', 'WX1 6LT', 'UK'),
(10463, 76, 'SUPRD', 5, '1997-03-04 00:00:00', '1997-04-01 00:00:00', '1997-03-06 00:00:00', 3, '14.7800', 'Suprmes dlices', 'Boulevard Tirou, 255', 'Charleroi', '', 'B-6000', 'Belgium'),
(10464, 28, 'FURIB', 4, '1997-03-04 00:00:00', '1997-04-01 00:00:00', '1997-03-14 00:00:00', 2, '89.0000', 'Furia Bacalhau e Frutos do Mar', 'Jardim das rosas n. 32', 'Lisboa', '', '1675', 'Portugal'),
(10465, 83, 'VAFFE', 1, '1997-03-05 00:00:00', '1997-04-02 00:00:00', '1997-03-14 00:00:00', 3, '145.0400', 'Vaffeljernet', 'Smagsloget 45', 'rhus', '', '8200', 'Denmark'),
(10466, 15, 'COMMI', 4, '1997-03-06 00:00:00', '1997-04-03 00:00:00', '1997-03-13 00:00:00', 1, '11.9300', 'Comrcio Mineiro', 'Av. dos Lusadas, 23', 'Sao Paulo', 'SP', '05432-043', 'Brazil'),
(10467, 49, 'MAGAA', 8, '1997-03-06 00:00:00', '1997-04-03 00:00:00', '1997-03-11 00:00:00', 2, '4.9300', 'Magazzini Alimentari Riuniti', 'Via Ludovico il Moro 22', 'Bergamo', '', '24100', 'Italy'),
(10468, 39, 'KOENE', 3, '1997-03-07 00:00:00', '1997-04-04 00:00:00', '1997-03-12 00:00:00', 3, '44.1200', 'Kniglich Essen', 'Maubelstr. 90', 'Brandenburg', '', '14776', 'Germany'),
(10469, 89, 'WHITC', 1, '1997-03-10 00:00:00', '1997-04-07 00:00:00', '1997-03-14 00:00:00', 1, '60.1800', 'White Clover Markets', '1029 - 12th Ave. S.', 'Seattle', 'WA', '98124', 'USA'),
(10470, 9, 'BONAP', 4, '1997-03-11 00:00:00', '1997-04-08 00:00:00', '1997-03-14 00:00:00', 2, '64.5600', 'Bon app-', '12, rue des Bouchers', 'Marseille', '', '13008', 'France'),
(10471, 11, 'BSBEV', 2, '1997-03-11 00:00:00', '1997-04-08 00:00:00', '1997-03-18 00:00:00', 3, '45.5900', 'B-s Beverages', 'Fauntleroy Circus', 'London', '', 'EC2 5NT', 'UK'),
(10472, 72, 'SEVES', 8, '1997-03-12 00:00:00', '1997-04-09 00:00:00', '1997-03-19 00:00:00', 1, '4.2000', 'Seven Seas Imports', '90 Wadhurst Rd.', 'London', '', 'OX15 4NB', 'UK'),
(10473, 38, 'ISLAT', 1, '1997-03-13 00:00:00', '1997-03-27 00:00:00', '1997-03-21 00:00:00', 3, '16.3700', 'Island Trading', 'Garden House Crowther Way', 'Cowes', 'Isle of Wight', 'PO31 7PJ', 'UK'),
(10474, 58, 'PERIC', 5, '1997-03-13 00:00:00', '1997-04-10 00:00:00', '1997-03-21 00:00:00', 2, '83.4900', 'Pericles Comidas clsicas', 'Calle Dr. Jorge Cash 321', 'Mxico D.F.', '', '5033', 'Mexico'),
(10475, 76, 'SUPRD', 9, '1997-03-14 00:00:00', '1997-04-11 00:00:00', '1997-04-04 00:00:00', 1, '68.5200', 'Suprmes dlices', 'Boulevard Tirou, 255', 'Charleroi', '', 'B-6000', 'Belgium'),
(10476, 35, 'HILAA', 8, '1997-03-17 00:00:00', '1997-04-14 00:00:00', '1997-03-24 00:00:00', 3, '4.4100', 'HILARION-Abastos', 'Carrera 22 con Ave. Carlos Soublette #8-35', 'San Cristbal', 'Tchira', '5022', 'Venezuela'),
(10477, 60, 'PRINI', 5, '1997-03-17 00:00:00', '1997-04-14 00:00:00', '1997-03-25 00:00:00', 2, '13.0200', 'Princesa Isabel Vinhos', 'Estrada da sade n. 58', 'Lisboa', '', '1756', 'Portugal'),
(10478, 84, 'VICTE', 2, '1997-03-18 00:00:00', '1997-04-01 00:00:00', '1997-03-26 00:00:00', 3, '4.8100', 'Victuailles en stock', '2, rue du Commerce', 'Lyon', '', '69004', 'France'),
(10479, 65, 'RATTC', 3, '1997-03-19 00:00:00', '1997-04-16 00:00:00', '1997-03-21 00:00:00', 3, '708.9500', 'Rattlesnake Canyon Grocery', '2817 Milton Dr.', 'Albuquerque', 'NM', '87110', 'USA'),
(10480, 23, 'FOLIG', 6, '1997-03-20 00:00:00', '1997-04-17 00:00:00', '1997-03-24 00:00:00', 2, '1.3500', 'Folies gourmandes', '184, chausse de Tournai', 'Lille', '', '59000', 'France'),
(10481, 67, 'RICAR', 8, '1997-03-20 00:00:00', '1997-04-17 00:00:00', '1997-03-25 00:00:00', 2, '64.3300', 'Ricardo Adocicados', 'Av. Copacabana, 267', 'Rio de Janeiro', 'RJ', '02389-890', 'Brazil'),
(10482, 43, 'LAZYK', 1, '1997-03-21 00:00:00', '1997-04-18 00:00:00', '1997-04-10 00:00:00', 3, '7.4800', 'Lazy K Kountry Store', '12 Orchestra Terrace', 'Walla Walla', 'WA', '99362', 'USA'),
(10483, 89, 'WHITC', 7, '1997-03-24 00:00:00', '1997-04-21 00:00:00', '1997-04-25 00:00:00', 2, '15.2800', 'White Clover Markets', '1029 - 12th Ave. S.', 'Seattle', 'WA', '98124', 'USA'),
(10484, 11, 'BSBEV', 3, '1997-03-24 00:00:00', '1997-04-21 00:00:00', '1997-04-01 00:00:00', 3, '6.8800', 'B-s Beverages', 'Fauntleroy Circus', 'London', '', 'EC2 5NT', 'UK'),
(10485, 47, 'LINOD', 4, '1997-03-25 00:00:00', '1997-04-08 00:00:00', '1997-03-31 00:00:00', 2, '64.4500', 'LINO-Delicateses', 'Ave. 5 de Mayo Porlamar', 'I. de Margarita', 'Nueva Esparta', '4980', 'Venezuela'),
(10486, 35, 'HILAA', 1, '1997-03-26 00:00:00', '1997-04-23 00:00:00', '1997-04-02 00:00:00', 2, '30.5300', 'HILARION-Abastos', 'Carrera 22 con Ave. Carlos Soublette #8-35', 'San Cristbal', 'Tchira', '5022', 'Venezuela'),
(10487, 62, 'QUEEN', 2, '1997-03-26 00:00:00', '1997-04-23 00:00:00', '1997-03-28 00:00:00', 2, '71.0700', 'Queen Cozinha', 'Alameda dos Canrios, 891', 'Sao Paulo', 'SP', '05487-020', 'Brazil'),
(10488, 25, 'FRANK', 8, '1997-03-27 00:00:00', '1997-04-24 00:00:00', '1997-04-02 00:00:00', 2, '4.9300', 'Frankenversand', 'Berliner Platz 43', 'Mnchen', '', '80805', 'Germany'),
(10489, 59, 'PICCO', 6, '1997-03-28 00:00:00', '1997-04-25 00:00:00', '1997-04-09 00:00:00', 2, '5.2900', 'Piccolo und mehr', 'Geislweg 14', 'Salzburg', '', '5020', 'Austria'),
(10490, 35, 'HILAA', 7, '1997-03-31 00:00:00', '1997-04-28 00:00:00', '1997-04-03 00:00:00', 2, '210.1900', 'HILARION-Abastos', 'Carrera 22 con Ave. Carlos Soublette #8-35', 'San Cristbal', 'Tchira', '5022', 'Venezuela'),
(10491, 28, 'FURIB', 8, '1997-03-31 00:00:00', '1997-04-28 00:00:00', '1997-04-08 00:00:00', 3, '16.9600', 'Furia Bacalhau e Frutos do Mar', 'Jardim das rosas n. 32', 'Lisboa', '', '1675', 'Portugal'),
(10492, 10, 'BOTTM', 3, '1997-04-01 00:00:00', '1997-04-29 00:00:00', '1997-04-11 00:00:00', 1, '62.8900', 'Bottom-Dollar Markets', '23 Tsawassen Blvd.', 'Tsawassen', 'BC', 'T2F 8M4', 'Canada'),
(10493, 41, 'LAMAI', 4, '1997-04-02 00:00:00', '1997-04-30 00:00:00', '1997-04-10 00:00:00', 3, '10.6400', 'La maison d-Asie', '1 rue Alsace-Lorraine', 'Toulouse', '', '31000', 'France'),
(10494, 15, 'COMMI', 4, '1997-04-02 00:00:00', '1997-04-30 00:00:00', '1997-04-09 00:00:00', 2, '65.9900', 'Comrcio Mineiro', 'Av. dos Lusadas, 23', 'Sao Paulo', 'SP', '05432-043', 'Brazil'),
(10495, 42, 'LAUGB', 3, '1997-04-03 00:00:00', '1997-05-01 00:00:00', '1997-04-11 00:00:00', 3, '4.6500', 'Laughing Bacchus Wine Cellars', '2319 Elm St.', 'Vancouver', 'BC', 'V3F 2K1', 'Canada'),
(10496, 81, 'TRADH', 7, '1997-04-04 00:00:00', '1997-05-02 00:00:00', '1997-04-07 00:00:00', 2, '46.7700', 'Tradiao Hipermercados', 'Av. Ins de Castro, 414', 'Sao Paulo', 'SP', '05634-030', 'Brazil'),
(10497, 44, 'LEHMS', 7, '1997-04-04 00:00:00', '1997-05-02 00:00:00', '1997-04-07 00:00:00', 1, '36.2100', 'Lehmanns Marktstand', 'Magazinweg 7', 'Frankfurt a.M.', '', '60528', 'Germany'),
(10498, 35, 'HILAA', 8, '1997-04-07 00:00:00', '1997-05-05 00:00:00', '1997-04-11 00:00:00', 2, '29.7500', 'HILARION-Abastos', 'Carrera 22 con Ave. Carlos Soublette #8-35', 'San Cristbal', 'Tchira', '5022', 'Venezuela'),
(10499, 46, 'LILAS', 4, '1997-04-08 00:00:00', '1997-05-06 00:00:00', '1997-04-16 00:00:00', 2, '102.0200', 'LILA-Supermercado', 'Carrera 52 con Ave. Bolvar #65-98 Llano Largo', 'Barquisimeto', 'Lara', '3508', 'Venezuela'),
(10500, 41, 'LAMAI', 6, '1997-04-09 00:00:00', '1997-05-07 00:00:00', '1997-04-17 00:00:00', 1, '42.6800', 'La maison d-Asie', '1 rue Alsace-Lorraine', 'Toulouse', '', '31000', 'France'),
(10501, 6, 'BLAUS', 9, '1997-04-09 00:00:00', '1997-05-07 00:00:00', '1997-04-16 00:00:00', 3, '8.8500', 'Blauer See Delikatessen', 'Forsterstr. 57', 'Mannheim', '', '68306', 'Germany'),
(10502, 58, 'PERIC', 2, '1997-04-10 00:00:00', '1997-05-08 00:00:00', '1997-04-29 00:00:00', 1, '69.3200', 'Pericles Comidas clsicas', 'Calle Dr. Jorge Cash 321', 'Mxico D.F.', '', '5033', 'Mexico'),
(10503, 37, 'HUNGO', 6, '1997-04-11 00:00:00', '1997-05-09 00:00:00', '1997-04-16 00:00:00', 2, '16.7400', 'Hungry Owl All-Night Grocers', '8 Johnstown Road', 'Cork', 'Co. Cork', '', 'Ireland'),
(10504, 89, 'WHITC', 4, '1997-04-11 00:00:00', '1997-05-09 00:00:00', '1997-04-18 00:00:00', 3, '59.1300', 'White Clover Markets', '1029 - 12th Ave. S.', 'Seattle', 'WA', '98124', 'USA'),
(10505, 51, 'MEREP', 3, '1997-04-14 00:00:00', '1997-05-12 00:00:00', '1997-04-21 00:00:00', 3, '7.1300', 'Mre Paillarde', '43 rue St. Laurent', 'Montral', 'Qubec', 'H1J 1C3', 'Canada'),
(10506, 39, 'KOENE', 9, '1997-04-15 00:00:00', '1997-05-13 00:00:00', '1997-05-02 00:00:00', 2, '21.1900', 'Kniglich Essen', 'Maubelstr. 90', 'Brandenburg', '', '14776', 'Germany'),
(10507, 3, 'ANTON', 7, '1997-04-15 00:00:00', '1997-05-13 00:00:00', '1997-04-22 00:00:00', 1, '47.4500', 'Antonio Moreno Taquera', 'Mataderos 2312', 'Mxico D.F.', '', '5023', 'Mexico'),
(10508, 56, 'OTTIK', 1, '1997-04-16 00:00:00', '1997-05-14 00:00:00', '1997-05-13 00:00:00', 2, '4.9900', 'Ottilies Kseladen', 'Mehrheimerstr. 369', 'Kln', '', '50739', 'Germany'),
(10509, 6, 'BLAUS', 4, '1997-04-17 00:00:00', '1997-05-15 00:00:00', '1997-04-29 00:00:00', 1, '0.1500', 'Blauer See Delikatessen', 'Forsterstr. 57', 'Mannheim', '', '68306', 'Germany'),
(10510, 71, 'SAVEA', 6, '1997-04-18 00:00:00', '1997-05-16 00:00:00', '1997-04-28 00:00:00', 3, '367.6300', 'Save-a-lot Markets', '187 Suffolk Ln.', 'Boise', 'ID', '83720', 'USA'),
(10511, 9, 'BONAP', 4, '1997-04-18 00:00:00', '1997-05-16 00:00:00', '1997-04-21 00:00:00', 3, '350.6400', 'Bon app-', '12, rue des Bouchers', 'Marseille', '', '13008', 'France'),
(10512, 21, 'FAMIA', 7, '1997-04-21 00:00:00', '1997-05-19 00:00:00', '1997-04-24 00:00:00', 2, '3.5300', 'Familia Arquibaldo', 'Rua Ors, 92', 'Sao Paulo', 'SP', '05442-030', 'Brazil'),
(10513, 86, 'WANDK', 7, '1997-04-22 00:00:00', '1997-06-03 00:00:00', '1997-04-28 00:00:00', 1, '105.6500', 'Die Wandernde Kuh', 'Adenauerallee 900', 'Stuttgart', '', '70563', 'Germany');
INSERT INTO `Orders` (`OrderID`, `CustomerID`, `CustomerCode`, `EmployeeID`, `OrderDate`, `RequiredDate`, `ShippedDate`, `ShipVia`, `Freight`, `ShipName`, `ShipAddress`, `ShipCity`, `ShipRegion`, `ShipPostalCode`, `ShipCountry`) VALUES
(10514, 20, 'ERNSH', 3, '1997-04-22 00:00:00', '1997-05-20 00:00:00', '1997-05-16 00:00:00', 2, '789.9500', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '', '8010', 'Austria'),
(10515, 63, 'QUICK', 2, '1997-04-23 00:00:00', '1997-05-07 00:00:00', '1997-05-23 00:00:00', 1, '204.4700', 'QUICK-Stop', 'Taucherstrae 10', 'Cunewalde', '', '1307', 'Germany'),
(10516, 37, 'HUNGO', 2, '1997-04-24 00:00:00', '1997-05-22 00:00:00', '1997-05-01 00:00:00', 3, '62.7800', 'Hungry Owl All-Night Grocers', '8 Johnstown Road', 'Cork', 'Co. Cork', '', 'Ireland'),
(10517, 53, 'NORTS', 3, '1997-04-24 00:00:00', '1997-05-22 00:00:00', '1997-04-29 00:00:00', 3, '32.0700', 'North/South', 'South House 300 Queensbridge', 'London', '', 'SW7 1RZ', 'UK');
-- --------------------------------------------------------
--
-- Table structure for table `Products`
--
CREATE TABLE `Products` (
`ProductID` int(11) NOT NULL,
`ProductName` varchar(40) CHARACTER SET utf8mb4 NOT NULL,
`SupplierID` int(11) DEFAULT NULL,
`CategoryID` int(11) DEFAULT NULL,
`QuantityPerUnit` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL,
`UnitPrice` decimal(10,4) DEFAULT '0.0000',
`UnitsInStock` smallint(2) DEFAULT '0',
`UnitsOnOrder` smallint(2) DEFAULT '0',
`ReorderLevel` smallint(2) DEFAULT '0',
`Discontinued` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `Products`
--
INSERT INTO `Products` (`ProductID`, `ProductName`, `SupplierID`, `CategoryID`, `QuantityPerUnit`, `UnitPrice`, `UnitsInStock`, `UnitsOnOrder`, `ReorderLevel`, `Discontinued`) VALUES
(1, 'Chai', 1, 1, '10 boxes x 20 bags', '18.0000', 39, 0, 10, 0),
(2, 'Chang', 1, 1, '24 - 12 oz bottles', '19.0000', 17, 40, 25, 0),
(3, 'Aniseed Syrup', 1, 2, '12 - 550 ml bottles', '10.0000', 13, 70, 25, 0),
(4, 'Chef Anton\'s Cajun Seasoning', 2, 2, '48 - 6 oz jars', '22.0000', 53, 0, 0, 0),
(5, 'Chef Anton\'s Gumbo Mix', 2, 2, '36 boxes', '21.3500', 0, 0, 0, 1),
(6, 'Grandma\'s Boysenberry Spread', 3, 2, '12 - 8 oz jars', '25.0000', 120, 0, 25, 0),
(7, 'Uncle Bob\'s Organic Dried Pears', 3, 7, '12 - 1 lb pkgs.', '30.0000', 15, 0, 10, 0),
(8, 'Northwoods Cranberry Sauce', 3, 2, '12 - 12 oz jars', '40.0000', 6, 0, 0, 0),
(9, 'Mishi Kobe Niku', 4, 6, '18 - 500 g pkgs.', '97.0000', 29, 0, 0, 1),
(10, 'Ikura', 4, 8, '12 - 200 ml jars', '31.0000', 31, 0, 0, 0),
(11, 'Queso Cabrales', 5, 4, '1 kg pkg.', '21.0000', 22, 30, 30, 0),
(12, 'Queso Manchego La Pastora', 5, 4, '10 - 500 g pkgs.', '38.0000', 86, 0, 0, 0),
(13, 'Konbu', 6, 8, '2 kg box', '6.0000', 24, 0, 5, 0),
(14, 'Tofu', 6, 7, '40 - 100 g pkgs.', '23.2500', 35, 0, 0, 0),
(15, 'Genen Shouyu', 6, 2, '24 - 250 ml bottles', '15.5000', 39, 0, 5, 0),
(16, 'Pavlova', 7, 3, '32 - 500 g boxes', '17.4500', 29, 0, 10, 0),
(17, 'Alice Mutton', 7, 6, '20 - 1 kg tins', '39.0000', 0, 0, 0, 1),
(18, 'Carnarvon Tigers', 7, 8, '16 kg pkg.', '62.5000', 42, 0, 0, 0),
(19, 'Teatime Chocolate Biscuits', 8, 3, '10 boxes x 12 pieces', '9.2000', 25, 0, 5, 0),
(20, 'Sir Rodney\'s Marmalade', 8, 3, '30 gift boxes', '81.0000', 40, 0, 0, 0),
(21, 'Sir Rodney\'s Scones', 8, 3, '24 pkgs. x 4 pieces', '10.0000', 3, 40, 5, 0),
(22, 'Gustaf\'s Knckebrd', 9, 5, '24 - 500 g pkgs.', '21.0000', 104, 0, 25, 0),
(23, 'Tunnbrd', 9, 5, '12 - 250 g pkgs.', '9.0000', 61, 0, 25, 0),
(24, 'Guaran Fantstica', 10, 1, '12 - 355 ml cans', '4.5000', 20, 0, 0, 1),
(25, 'NuNuCa Nu-Nougat-Creme', 11, 3, '20 - 450 g glasses', '14.0000', 76, 0, 30, 0),
(26, 'Gumbr Gummibrchen', 11, 3, '100 - 250 g bags', '31.2300', 15, 0, 0, 0),
(27, 'Schoggi Schokolade', 11, 3, '100 - 100 g pieces', '43.9000', 49, 0, 30, 0),
(28, 'Rssle Sauerkraut', 12, 7, '25 - 825 g cans', '45.6000', 26, 0, 0, 1),
(29, 'Thringer Rostbratwurst', 12, 6, '50 bags x 30 sausgs.', '123.7900', 0, 0, 0, 1),
(30, 'Nord-Ost Matjeshering', 13, 8, '10 - 200 g glasses', '25.8900', 10, 0, 15, 0),
(31, 'Gorgonzola Telino', 14, 4, '12 - 100 g pkgs', '12.5000', 0, 70, 20, 0),
(32, 'Mascarpone Fabioli', 14, 4, '24 - 200 g pkgs.', '32.0000', 9, 40, 25, 0),
(33, 'Geitost', 15, 4, '500 g', '2.5000', 112, 0, 20, 0),
(34, 'Sasquatch Ale', 16, 1, '24 - 12 oz bottles', '14.0000', 111, 0, 15, 0),
(35, 'Steeleye Stout', 16, 1, '24 - 12 oz bottles', '18.0000', 20, 0, 15, 0),
(36, 'Inlagd Sill', 17, 8, '24 - 250 g jars', '19.0000', 112, 0, 20, 0),
(37, 'Gravad lax', 17, 8, '12 - 500 g pkgs.', '26.0000', 11, 50, 25, 0),
(38, 'Cte de Blaye', 18, 1, '12 - 75 cl bottles', '263.5000', 17, 0, 15, 0),
(39, 'Chartreuse verte', 18, 1, '750 cc per bottle', '18.0000', 69, 0, 5, 0),
(40, 'Boston Crab Meat', 19, 8, '24 - 4 oz tins', '18.4000', 123, 0, 30, 0),
(41, 'Jack\'s New England Clam Chowder', 19, 8, '12 - 12 oz cans', '9.6500', 85, 0, 10, 0),
(42, 'Singaporean Hokkien Fried Mee', 20, 5, '32 - 1 kg pkgs.', '14.0000', 26, 0, 0, 1),
(43, 'Ipoh Coffee', 20, 1, '16 - 500 g tins', '46.0000', 17, 10, 25, 0),
(44, 'Gula Malacca', 20, 2, '20 - 2 kg bags', '19.4500', 27, 0, 15, 0),
(45, 'Rogede sild', 21, 8, '1k pkg.', '9.5000', 5, 70, 15, 0),
(46, 'Spegesild', 21, 8, '4 - 450 g glasses', '12.0000', 95, 0, 0, 0),
(47, 'Zaanse koeken', 22, 3, '10 - 4 oz boxes', '9.5000', 36, 0, 0, 0),
(48, 'Chocolade', 22, 3, '10 pkgs.', '12.7500', 15, 70, 25, 0),
(49, 'Maxilaku', 23, 3, '24 - 50 g pkgs.', '20.0000', 10, 60, 15, 0),
(50, 'Valkoinen suklaa', 23, 3, '12 - 100 g bars', '16.2500', 65, 0, 30, 0),
(51, 'Manjimup Dried Apples', 24, 7, '50 - 300 g pkgs.', '53.0000', 20, 0, 10, 0),
(52, 'Filo Mix', 24, 5, '16 - 2 kg boxes', '7.0000', 38, 0, 25, 0),
(53, 'Perth Pasties', 24, 6, '48 pieces', '32.8000', 0, 0, 0, 1),
(54, 'Tourtire', 25, 6, '16 pies', '7.4500', 21, 0, 10, 0),
(55, 'Pt chinois', 25, 6, '24 boxes x 2 pies', '24.0000', 115, 0, 20, 0),
(56, 'Gnocchi di nonna Alice', 26, 5, '24 - 250 g pkgs.', '38.0000', 21, 10, 30, 0),
(57, 'Ravioli Angelo', 26, 5, '24 - 250 g pkgs.', '19.5000', 36, 0, 20, 0),
(58, 'Escargots de Bourgogne', 27, 8, '24 pieces', '13.2500', 62, 0, 20, 0),
(59, 'Raclette Courdavault', 28, 4, '5 kg pkg.', '55.0000', 79, 0, 0, 0),
(60, 'Camembert Pierrot', 28, 4, '15 - 300 g rounds', '34.0000', 19, 0, 0, 0),
(61, 'Sirop d\'rable', 29, 2, '24 - 500 ml bottles', '28.5000', 113, 0, 25, 0),
(62, 'Tarte au sucre', 29, 3, '48 pies', '49.3000', 17, 0, 0, 0),
(63, 'Vegie-spread', 7, 2, '15 - 625 g jars', '43.9000', 24, 0, 5, 0),
(64, 'Wimmers gute Semmelkndel', 12, 5, '20 bags x 4 pieces', '33.2500', 22, 80, 30, 0),
(65, 'Louisiana Fiery Hot Pepper Sauce', 2, 2, '32 - 8 oz bottles', '21.0500', 76, 0, 0, 0),
(66, 'Louisiana Hot Spiced Okra', 2, 2, '24 - 8 oz jars', '17.0000', 4, 100, 20, 0),
(67, 'Laughing Lumberjack Lager', 16, 1, '24 - 12 oz bottles', '14.0000', 52, 0, 10, 0),
(68, 'Scottish Longbreads', 8, 3, '10 boxes x 8 pieces', '12.5000', 6, 10, 15, 0),
(69, 'Gudbrandsdalsost', 15, 4, '10 kg pkg.', '36.0000', 26, 0, 15, 0),
(70, 'Outback Lager', 7, 1, '24 - 355 ml bottles', '15.0000', 15, 10, 30, 0),
(71, 'Flotemysost', 15, 4, '10 - 500 g pkgs.', '21.5000', 26, 0, 0, 0),
(72, 'Mozzarella di Giovanni', 14, 4, '24 - 200 g pkgs.', '34.8000', 14, 0, 0, 0),
(73, 'Rd Kaviar', 17, 8, '24 - 150 g jars', '15.0000', 101, 0, 5, 0),
(74, 'Longlife Tofu', 4, 7, '5 kg pkg.', '10.0000', 4, 20, 5, 0),
(75, 'Rhnbru Klosterbier', 12, 1, '24 - 0.5 l bottles', '7.7500', 125, 0, 25, 0),
(76, 'Lakkalikri', 23, 1, '500 ml', '18.0000', 57, 0, 20, 0),
(77, 'Original Frankfurter grne Soe', 12, 2, '12 boxes', '13.0000', 32, 0, 15, 0);
-- --------------------------------------------------------
--
-- Table structure for table `Region`
--
CREATE TABLE `Region` (
`RegionID` int(11) NOT NULL,
`RegionDescription` varchar(50) CHARACTER SET utf8mb4 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `Region`
--
INSERT INTO `Region` (`RegionID`, `RegionDescription`) VALUES
(1, 'Eastern '),
(2, 'Westerns '),
(3, 'Northern '),
(4, 'Southern ');
-- --------------------------------------------------------
--
-- Table structure for table `Shippers`
--
CREATE TABLE `Shippers` (
`ShipperID` int(11) NOT NULL,
`CompanyName` varchar(40) CHARACTER SET utf8mb4 NOT NULL,
`Phone` varchar(24) CHARACTER SET utf8mb4 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `Shippers`
--
INSERT INTO `Shippers` (`ShipperID`, `CompanyName`, `Phone`) VALUES
(1, 'Speedy Express', '(503) 555-9831'),
(2, 'United Package', '(503) 555-3199'),
(3, 'Federal Shipping', '(503) 555-9931');
-- --------------------------------------------------------
--
-- Table structure for table `Suppliers`
--
CREATE TABLE `Suppliers` (
`SupplierID` int(11) NOT NULL,
`CompanyName` varchar(40) CHARACTER SET utf8mb4 NOT NULL,
`ContactName` varchar(30) CHARACTER SET utf8mb4 DEFAULT NULL,
`ContactTitle` varchar(30) CHARACTER SET utf8mb4 DEFAULT NULL,
`Address` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
`City` varchar(15) CHARACTER SET utf8mb4 DEFAULT NULL,
`Region` varchar(15) CHARACTER SET utf8mb4 DEFAULT NULL,
`PostalCode` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
`Country` varchar(15) CHARACTER SET utf8mb4 DEFAULT NULL,
`Phone` varchar(24) CHARACTER SET utf8mb4 DEFAULT NULL,
`Fax` varchar(24) CHARACTER SET utf8mb4 DEFAULT NULL,
`HomePage` mediumtext CHARACTER SET utf8mb4
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `Suppliers`
--
INSERT INTO `Suppliers` (`SupplierID`, `CompanyName`, `ContactName`, `ContactTitle`, `Address`, `City`, `Region`, `PostalCode`, `Country`, `Phone`, `Fax`, `HomePage`) VALUES
(1, 'Exotic Liquids', 'Charlotte Cooper', 'Purchasing Manager', '49 Gilbert St.', 'London', NULL, 'EC1 4SD', 'UK', '(171) 555-2222', NULL, NULL),
(2, 'New Orleans Cajun Delights', 'Shelley Burke', 'Order Administrator', 'P.O. Box 78934', 'New Orleans', 'LA', '70117', 'USA', '(100) 555-4822', NULL, '#CAJUN.HTM#'),
(3, 'Grandma Kelly\'s Homestead', 'Regina Murphy', 'Sales Representative', '707 Oxford Rd.', 'Ann Arbor', 'MI', '48104', 'USA', '(313) 555-5735', '(313) 555-3349', NULL),
(4, 'Tokyo Traders', 'Yoshi Nagase', 'Marketing Manager', '9-8 Sekimai\r\nMusashino-shi', 'Tokyo', NULL, '100', 'Japan', '(03) 3555-5011', NULL, NULL),
(5, 'Cooperativa de Quesos \'Las Cabras\'', 'Antonio del Valle Saavedra ', 'Export Administrator', 'Calle del Rosal 4', 'Oviedo', 'Asturias', '33007', 'Spain', '(98) 598 76 54', NULL, NULL),
(6, 'Mayumi\'s', 'Mayumi Ohno', 'Marketing Representative', '92 Setsuko\r\nChuo-ku', 'Osaka', NULL, '545', 'Japan', '(06) 431-7877', NULL, 'Mayumi\'s (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm#'),
(7, 'Pavlova, Ltd.', 'Ian Devling', 'Marketing Manager', '74 Rose St.\r\nMoonie Ponds', 'Melbourne', 'Victoria', '3058', 'Australia', '(03) 444-2343', '(03) 444-6588', NULL),
(8, 'Specialty Biscuits, Ltd.', 'Peter Wilson', 'Sales Representative', '29 King\'s Way', 'Manchester', NULL, 'M14 GSD', 'UK', '(161) 555-4448', NULL, NULL),
(9, 'PB Knckebrd AB', 'Lars Peterson', 'Sales Agent', 'Kaloadagatan 13', 'Gteborg', NULL, 'S-345 67', 'Sweden ', '031-987 65 43', '031-987 65 91', NULL),
(10, 'Refrescos Americanas LTDA', 'Carlos Diaz', 'Marketing Manager', 'Av. das Americanas 12.890', 'So Paulo', NULL, '5442', 'Brazil', '(11) 555 4640', NULL, NULL),
(11, 'Heli Swaren GmbH & Co. KG', 'Petra Winkler', 'Sales Manager', 'Tiergartenstrae 5', 'Berlin', NULL, '10785', 'Germany', '(010) 9984510', NULL, NULL),
(12, 'Plutzer Lebensmittelgromrkte AG', 'Martin Bein', 'International Marketing Mgr.', 'Bogenallee 51', 'Frankfurt', NULL, '60439', 'Germany', '(069) 992755', NULL, 'Plutzer (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/plutzer.htm#'),
(13, 'Nord-Ost-Fisch Handelsgesellschaft mbH', 'Sven Petersen', 'Coordinator Foreign Markets', 'Frahmredder 112a', 'Cuxhaven', NULL, '27478', 'Germany', '(04721) 8713', '(04721) 8714', NULL),
(14, 'Formaggi Fortini s.r.l.', 'Elio Rossi', 'Sales Representative', 'Viale Dante, 75', 'Ravenna', NULL, '48100', 'Italy', '(0544) 60323', '(0544) 60603', '#FORMAGGI.HTM#'),
(15, 'Norske Meierier', 'Beate Vileid', 'Marketing Manager', 'Hatlevegen 5', 'Sandvika', NULL, '1320', 'Norway', '(0)2-953010', NULL, NULL),
(16, 'Bigfoot Breweries', 'Cheryl Saylor', 'Regional Account Rep.', '3400 - 8th Avenue\r\nSuite 210', 'Bend', 'OR', '97101', 'USA', '(503) 555-9931', NULL, NULL),
(17, 'Svensk Sjfda AB', 'Michael Bjrn', 'Sales Representative', 'Brovallavgen 231', 'Stockholm', NULL, 'S-123 45', 'Sweden', '08-123 45 67', NULL, NULL),
(18, 'Aux joyeux ecclsiastiques', 'Guylne Nodier', 'Sales Manager', '203, Rue des Francs-Bourgeois', 'Paris', NULL, '75004', 'France', '(1) 03.83.00.68', '(1) 03.83.00.62', NULL),
(19, 'New England Seafood Cannery', 'Robb Merchant', 'Wholesale Account Agent', 'Order Processing Dept.\r\n2100 Paul Revere Blvd.', 'Boston', 'MA', '02134', 'USA', '(617) 555-3267', '(617) 555-3389', NULL),
(20, 'Leka Trading', 'Chandra Leka', 'Owner', '471 Serangoon Loop, Suite #402', 'Singapore', NULL, '0512', 'Singapore', '555-8787', NULL, NULL),
(21, 'Lyngbysild', 'Niels Petersen', 'Sales Manager', 'Lyngbysild\r\nFiskebakken 10', 'Lyngby', NULL, '2800', 'Denmark', '43844108', '43844115', NULL),
(22, 'Zaanse Snoepfabriek', 'Dirk Luchte', 'Accounting Manager', 'Verkoop\r\nRijnweg 22', 'Zaandam', NULL, '9999 ZZ', 'Netherlands', '(12345) 1212', '(12345) 1210', NULL),
(23, 'Karkki Oy', 'Anne Heikkonen', 'Product Manager', 'Valtakatu 12', 'Lappeenranta', NULL, '53120', 'Finland', '(953) 10956', NULL, NULL),
(24, 'G\'day, Mate', 'Wendy Mackenzie', 'Sales Representative', '170 Prince Edward Parade\r\nHunter\'s Hill', 'Sydney', 'NSW', '2042', 'Australia', '(02) 555-5914', '(02) 555-4873', 'G\'day Mate (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/gdaymate.htm#'),
(25, 'Ma Maison', 'Jean-Guy Lauzon', 'Marketing Manager', '2960 Rue St. Laurent', 'Montral', 'Qubec', 'H1J 1C3', 'Canada', '(514) 555-9022', NULL, NULL),
(26, 'Pasta Buttini s.r.l.', 'Giovanni Giudici', 'Order Administrator', 'Via dei Gelsomini, 153', 'Salerno', NULL, '84100', 'Italy', '(089) 6547665', '(089) 6547667', NULL),
(27, 'Escargots Nouveaux', 'Marie Delamare', 'Sales Manager', '22, rue H. Voiron', 'Montceau', NULL, '71300', 'France', '85.57.00.07', NULL, NULL),
(28, 'Gai pturage', 'Eliane Noz', 'Sales Representative', 'Bat. B\r\n3, rue des Alpes', 'Annecy', NULL, '74000', 'France', '38.76.98.06', '38.76.98.58', NULL),
(29, 'Forts d\'rables', 'Chantal Goulet', 'Accounting Manager', '148 rue Chasseur', 'Ste-Hyacinthe', 'Qubec', 'J2S 7S8', 'Canada', '(514) 555-2955', '(514) 555-2921', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `Territories`
--
CREATE TABLE `Territories` (
`TerritoryID` varchar(20) CHARACTER SET utf8mb4 NOT NULL,
`TerritoryDescription` varchar(50) CHARACTER SET utf8mb4 NOT NULL,
`RegionID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `Territories`
--
INSERT INTO `Territories` (`TerritoryID`, `TerritoryDescription`, `RegionID`) VALUES
('01581', 'Westboro ', 1),
('01730', 'Bedford ', 1),
('01833', 'Georgetow ', 1),
('02116', 'Boston ', 1),
('02139', 'Cambridge ', 1),
('02184', 'Braintree ', 1),
('02903', 'Providence ', 1),
('03049', 'Hollis ', 3),
('03801', 'Portsmouth ', 3),
('06897', 'Wilton ', 1),
('07960', 'Morristown ', 1),
('08837', 'Edison ', 1),
('10019', 'New York ', 1),
('10038', 'New York ', 1),
('11747', 'Mellvile ', 1),
('14450', 'Fairport ', 1),
('19428', 'Philadelphia ', 3),
('19713', 'Neward ', 1),
('20852', 'Rockville ', 1),
('27403', 'Greensboro ', 1),
('27511', 'Cary ', 1),
('29202', 'Columbia ', 4),
('30346', 'Atlanta ', 4),
('31406', 'Savannah ', 4),
('32859', 'Orlando ', 4),
('33607', 'Tampa ', 4),
('40222', 'Louisville ', 1),
('44122', 'Beachwood ', 3),
('45839', 'Findlay ', 3),
('48075', 'Southfield ', 3),
('48084', 'Troy ', 3),
('48304', 'Bloomfield Hills ', 3),
('53404', 'Racine ', 3),
('55113', 'Roseville ', 3),
('55439', 'Minneapolis ', 3),
('60179', 'Hoffman Estates ', 2),
('60601', 'Chicago ', 2),
('72716', 'Bentonville ', 4),
('75234', 'Dallas ', 4),
('78759', 'Austin ', 4),
('80202', 'Denver ', 2),
('80909', 'Colorado Springs ', 2),
('85014', 'Phoenix ', 2),
('85251', 'Scottsdale ', 2),
('90405', 'Santa Monica ', 2),
('94025', 'Menlo Park ', 2),
('94105', 'San Francisco ', 2),
('95008', 'Campbell ', 2),
('95054', 'Santa Clara ', 2),
('95060', 'Santa Cruz ', 2),
('98004', 'Bellevue ', 2),
('98052', 'Redmond ', 2),
('98104', 'Seattle ', 2);
-- --------------------------------------------------------
--
-- Table structure for table `users_system`
--
CREATE TABLE `users_system` (
`user_id` int(13) NOT NULL,
`firstname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`lastname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`urole` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `users_system`
--
INSERT INTO `users_system` (`user_id`, `firstname`, `lastname`, `email`, `password`, `urole`, `created_at`) VALUES
(1, 'Teeratus', 'Rojananak', 't0861246000@hotmail.com', '$2y$10$s.5gvB5PbYvGNiRQXuCUkOu0gQzGhQzfPBV49IKeKF/7KZoefG79i', 'admin', '2022-04-12 01:44:05'),
(2, 'staff-1', 'staff-1', 'staff-1@gcsbkk-online.com', '$2y$10$8aZaycqunkW98qfrX1jv6.PNtvogmK4lxYi2gLu8nezZkXoV.Ok6G', 'user', '2022-04-20 03:40:46'),
(224, 'staff-224', 'staff-224', 'staff-224@gcsbkk-online.com', '$2y$10$pvlw4ExxonmER6.eSHkMkuUKmT4SwEohVMzlGh/FczWIyqs8mrSAa', 'user', '2022-05-06 02:16:53');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `Categories`
--
ALTER TABLE `Categories`
ADD PRIMARY KEY (`CategoryID`),
ADD KEY `Categories_CategoryName` (`CategoryName`);
--
-- Indexes for table `Customers`
--
ALTER TABLE `Customers`
ADD PRIMARY KEY (`CustomerID`);
--
-- Indexes for table `Employees`
--
ALTER TABLE `Employees`
ADD PRIMARY KEY (`EmployeeID`),
ADD KEY `FK_Employees_Employees` (`ReportsTo`),
ADD KEY `Employees_LastName` (`LastName`),
ADD KEY `Employees_PostalCode` (`PostalCode`);
--
-- Indexes for table `EmployeeTerritories`
--
ALTER TABLE `EmployeeTerritories`
ADD PRIMARY KEY (`EmployeeID`,`TerritoryID`),
ADD KEY `FK_EmployeeTerritories_Territories` (`TerritoryID`);
--
-- Indexes for table `OrderDetails`
--
ALTER TABLE `OrderDetails`
ADD PRIMARY KEY (`OrderID`,`ProductID`),
ADD KEY `FK_Order_Details_Products` (`ProductID`);
--
-- Indexes for table `Orders`
--
ALTER TABLE `Orders`
ADD PRIMARY KEY (`OrderID`),
ADD KEY `CustomerID` (`CustomerID`),
ADD KEY `EmployeeID` (`EmployeeID`);
--
-- Indexes for table `Products`
--
ALTER TABLE `Products`
ADD PRIMARY KEY (`ProductID`),
ADD KEY `FK_Products_Categories` (`CategoryID`),
ADD KEY `FK_Products_Suppliers` (`SupplierID`),
ADD KEY `Products_ProductName` (`ProductName`);
--
-- Indexes for table `Region`
--
ALTER TABLE `Region`
ADD PRIMARY KEY (`RegionID`);
--
-- Indexes for table `Shippers`
--
ALTER TABLE `Shippers`
ADD PRIMARY KEY (`ShipperID`);
--
-- Indexes for table `Suppliers`
--
ALTER TABLE `Suppliers`
ADD PRIMARY KEY (`SupplierID`),
ADD KEY `Suppliers_CompanyName` (`CompanyName`),
ADD KEY `Suppliers_PostalCode` (`PostalCode`);
--
-- Indexes for table `Territories`
--
ALTER TABLE `Territories`
ADD PRIMARY KEY (`TerritoryID`),
ADD KEY `FK_Territories_Region` (`RegionID`);
--
-- Indexes for table `users_system`
--
ALTER TABLE `users_system`
ADD PRIMARY KEY (`user_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `Categories`
--
ALTER TABLE `Categories`
MODIFY `CategoryID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `Customers`
--
ALTER TABLE `Customers`
MODIFY `CustomerID` int(13) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;
--
-- AUTO_INCREMENT for table `Employees`
--
ALTER TABLE `Employees`
MODIFY `EmployeeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `Products`
--
ALTER TABLE `Products`
MODIFY `ProductID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;
--
-- AUTO_INCREMENT for table `Shippers`
--
ALTER TABLE `Shippers`
MODIFY `ShipperID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `Suppliers`
--
ALTER TABLE `Suppliers`
MODIFY `SupplierID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `Employees`
--
ALTER TABLE `Employees`
ADD CONSTRAINT `FK_Employees_Employees` FOREIGN KEY (`ReportsTo`) REFERENCES `Employees` (`EmployeeID`);
--
-- Constraints for table `EmployeeTerritories`
--
ALTER TABLE `EmployeeTerritories`
ADD CONSTRAINT `FK_EmployeeTerritories_Employees` FOREIGN KEY (`EmployeeID`) REFERENCES `Employees` (`EmployeeID`),
ADD CONSTRAINT `FK_EmployeeTerritories_Territories` FOREIGN KEY (`TerritoryID`) REFERENCES `Territories` (`TerritoryID`);
--
-- Constraints for table `Products`
--
ALTER TABLE `Products`
ADD CONSTRAINT `FK_Products_Categories` FOREIGN KEY (`CategoryID`) REFERENCES `Categories` (`CategoryID`),
ADD CONSTRAINT `FK_Products_Suppliers` FOREIGN KEY (`SupplierID`) REFERENCES `Suppliers` (`SupplierID`);
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Document in project
You can Download PDF file.