https://sqliteonline.com/

sqlite.db

-- Drop tables if they exist to allow for a "CREATE OR REPLACE" like behavior in SQLite
DROP TABLE IF EXISTS "order_details";
DROP TABLE IF EXISTS "orders";
DROP TABLE IF EXISTS "products";
DROP TABLE IF EXISTS "categories";
DROP TABLE IF EXISTS "customers";
DROP TABLE IF EXISTS "employees";
DROP TABLE IF EXISTS "shippers";
DROP TABLE IF EXISTS "suppliers";
DROP TABLE IF EXISTS "demo";

-- Table structure for table `categories`
CREATE TABLE "categories" (
  "CategoryID" INTEGER PRIMARY KEY AUTOINCREMENT,
  "CategoryName" TEXT NOT NULL,
  "Description" TEXT
);

-- Dumping data for table `categories`
INSERT INTO "categories" ("CategoryID", "CategoryName", "Description") VALUES
(1, 'Beverages', 'Soft drinks, coffees, teas, beers, and ales'),
(2, 'Condiments', 'Sweet and savory sauces, relishes, spreads, and seasonings'),
(3, 'Confections', 'Desserts, candies, and sweet breads'),
(4, 'Dairy Products', 'Cheeses'),
(5, 'Grains/Cereals', 'Breads, crackers, pasta, and cereal'),
(6, 'Meat/Poultry', 'Prepared meats'),
(7, 'Produce', 'Dried fruit and bean curd'),
(8, 'Seafood', 'Seaweed and fish');

-- Table structure for table `customers`
CREATE TABLE "customers" (
  "CustomerID" INTEGER PRIMARY KEY AUTOINCREMENT,
  "CustomerName" TEXT NOT NULL,
  "ContactName" TEXT,
  "Address" TEXT,
  "City" TEXT,
  "PostalCode" TEXT,
  "Country" TEXT
);

-- Dumping data for table `customers`
INSERT INTO "customers" ("CustomerID", "CustomerName", "ContactName", "Address", "City", "PostalCode", "Country") VALUES
(1, 'Alfreds Futterkiste', 'Maria Anders', 'Obere Str. 57', 'Berlin', '12209', 'Germany'),
(2, 'Ana Trujillo Emparedados y helados', 'Ana Trujillo', 'Avda. de la Constitución 2222', 'México D.F.', '05021', 'Mexico'),
(3, 'Antonio Moreno Taquería', 'Antonio Moreno', 'Mataderos 2312', 'México D.F.', '05023', 'Mexico'),
(4, 'Around the Horn', 'Thomas Hardy', '120 Hanover Sq.', 'London', 'WA1 1DP', 'UK'),
(5, 'Berglunds snabbköp', 'Christina Berglund', 'Berguvsvägen 8', 'Luleå', 'S-958 22', 'Sweden'),
(6, 'Blauer See Delikatessen', 'Hanna Moos', 'Forsterstr. 57', 'Mannheim', '68306', 'Germany'),
(7, 'Blondel père et fils', 'Frédérique Citeaux', '24, place Kléber', 'Strasbourg', '67000', 'France'),
(8, 'Bólido Comidas preparadas', 'Martín Sommer', 'C/ Araquil, 67', 'Madrid', '28023', 'Spain'),
(9, 'Bon app', 'Laurence Lebihan', '12, rue des Bouchers', 'Marseille', '13008', 'France'),
(10, 'Bottom-Dollar Markets', 'Elizabeth Lincoln', '23 Tsawassen Blvd.', 'Tsawassen', 'T2F 8M4', 'Canada'),
(11, 'Bs Beverages', 'Victoria Ashworth', 'Fauntleroy Circus', 'London', 'RG1 9SP', 'UK'),
(12, 'Cactus Comidas para llevar', 'Patricio Simpson', 'Cerrito 333', 'Buenos Aires', '1010', 'Argentina'),
(13, 'Centro comercial Moctezuma', 'Francisco Chang', 'Sierras de Granada 9993', 'México D.F.', '05022', 'Mexico'),
(14, 'Chop-suey Chinese', 'Yang Wang', 'Hauptstr. 29', 'Bern', '3012', 'Switzerland'),
(15, 'Comércio Mineiro', 'Pedro Afonso', 'Av. dos Lusíadas, 23', 'São Paulo', '05432-043', 'Brazil'),
(16, 'Consolidated Holdings', 'Elizabeth Brown', 'Berkeley Gardens 12 Brewery', 'London', 'WX1 6LT', 'UK'),
(17, 'Drachenblut Delikatessen', 'Sven Ottlieb', 'Walserweg 21', 'Aachen', '52066', 'Germany'),
(18, 'Du monde entier', 'Janine Labrune', '67, rue des Cinquante Otages', 'Nantes', '44000', 'France'),
(19, 'Eastern Connection', 'Ann Devon', '35 King George', 'London', 'WX3 6FW', 'UK'),
(20, 'Ernst Handel', 'Roland Mendel', 'Kirchgasse 6', 'Graz', '8010', 'Austria'),
(21, 'Familia Arquibaldo', 'Paula Parente', 'Rua da Panificadora, 12', 'São Paulo', '05432-043', 'Brazil'),
(22, 'FISSA Fabrica Inter. Salchichas S.A.', 'Diego Roel', 'C/ Moralzarzal, 86', 'Madrid', '28034', 'Spain'),
(23, 'Folies gourmandes', 'Martine Rancé', '184, chaussée de Tournai', 'Lille', '59000', 'France'),
(24, 'Folk och fä HB', 'Maria Larsson', 'Åkergatan 10', 'Bräcke', 'S-844 67', 'Sweden'),
(25, 'Frankenversand', 'Peter Franken', 'Berliner Platz 43', 'München', '80805', 'Germany'),
(26, 'France restauration', 'Carine Schmitt', '54, rue Royale', 'Nantes', '44000', 'France'),
(27, 'Franchi S.p.A.', 'Paolo Accorti', 'Via Monte Bianco 34', 'Torino', '10100', 'Italy'),
(28, 'Furia Bacalhau e Frutos do Mar', 'Lino Rodriguez', 'Estrada da saúde n. 58', 'Lisboa', '1756', 'Portugal'),
(29, 'Galeria美食', 'Isabel Castro', 'Rua do Mercado, 12', 'Rio de Janeiro', '05432-043', 'Brazil'),
(30, 'Gourmet Lanchonetes', 'André Fonseca', 'Av. Brasil, 442', 'Campinas', '05432-043', 'Brazil'),
(31, 'Great Lakes Food Market', 'Howard Snyder', '2732 Baker Blvd.', 'Eugene', '97403', 'USA'),
(32, 'GroBhandel-Metzgerei', 'Georg Pipps', 'Talstr. 15', 'Frankfurt', '60528', 'Germany'),
(33, 'Hanari Carnes', 'Mario Pontes', 'Rua do Paço, 67', 'Rio de Janeiro', '05432-043', 'Brazil'),
(34, 'HILARIÓN-Abastos', 'Carlos Hernández', 'Carrera 22 con Ave. 5 de Mayo', 'San Cristóbal', '5021', 'Venezuela'), -- Removed extra '000'
(35, 'Hungry Coyote Import Store', 'Yoshi Latimer', 'City Center Plaza 516 Main St.', 'Elgin', '97827', 'USA'),
(36, 'Hungry Owl All-Night Grocers', 'Patricia McKenna', '8 Johnstown Road', 'Cork', 'NULL', 'Ireland'),
(37, 'Island Trading', 'Helen Bennett', 'Garden House Crowther Way', 'Cowes', 'PO31 1PD', 'UK'),
(38, 'Königlich Essen', 'Philip Cramer', 'Maubelstr. 90', 'Brandenburg', '14776', 'Germany'),
(39, 'La corne dabondance', 'Daniel Tonini', '67, avenue de lEurope', 'Versailles', '78000', 'France'),
(40, 'La maisonette', 'Leah Cole', '1, rue Hanovre', 'Paris', '75002', 'France'),
(41, 'Laughing Bacchus Winecellars', 'Yoshi Tannamuri', '2321 Broadway', 'Vancouver', 'V3F 2K1', 'Canada'),
(42, 'Lazy K Kountry Store', 'John Steel', '12 Orchestra Terrace', 'Walla Walla', '99362', 'USA'),
(43, 'Lehmanns Marktstand', 'Renate Messner', 'Magazinweg 7', 'Frankfurt', '60598', 'Germany'),
(44, 'LILA-Supermercado', 'Carlos González', 'Carrera 52 con La Paz', 'Barquisimeto', '3508', 'Venezuela'),
(45, 'Lonesome Pine Restaurant', 'Fran Wilson', '89 Chiaroscuro Rd.', 'Portland', '97219', 'USA'),
(46, 'Magazzini Alimentari Riuniti', 'Giovanni Rovelli', 'Via Ludovico il Moro 22', 'Bergamo', '24100', 'Italy'),
(47, 'Maison Dewey', 'Catherine Dewey', 'Rue Levasseur 18', 'Bruxelles', 'B-1050', 'Belgium'),
(48, 'Mère Paillarde', 'Jean-Paul Saveau', '432 longue Rue St. Honoré', 'Lille', '59000', 'France'),
(49, 'Morgenstern Gesundkost', 'Alexander Feuer', 'Heerstr. 22', 'Leipzig', '04179', 'Germany'),
(50, 'North/South', 'Simon Crowther', 'South House 300 Queensbridge', 'London', 'SW7 1RZ', 'UK'),
(51, 'Océano Atlántico Ltda.', 'Liz Nixon', 'Ing. Gustavo Moneta 85', 'Buenos Aires', '1010', 'Argentina'),
(52, 'Old World Delicatessen', 'Rene Phillips', '2743 Bering St.', 'Anchorage', '99508', 'USA'),
(53, 'Ottilies Käseladen', 'Henriette Pfalzheim', 'Bahnhofstr. 31', 'Köln', '50739', 'Germany'),
(54, 'Paris spécialités', 'Marie Bertrand', '265, boulevard Charonne', 'Paris', '75012', 'France'),
(55, 'Pericles Comidas Clásicas', 'Guillermo Fernández', 'Calle Dr. Jorge Cash 321', 'México D.F.', '05033', 'Mexico'),
(56, 'Piccolo und fast', 'Georg Fischer', 'Geislweg 14', 'Salzburg', '5020', 'Austria'),
(57, 'Princesa Isabel Vinhos', 'Isabel de Castro', 'Estrada da saúde n. 58', 'Lisboa', '1756', 'Portugal'),
(58, 'Que Delícia', 'Bernardo Batista', 'Rua da Panificadora, 12', 'Rio de Janeiro', '05432-043', 'Brazil'),
(59, 'Queen Cozinha', 'Lúcia Carvalho', 'Av. 5 de Maio, 8', 'São Paulo', '05432-043', 'Brazil'),
(60, 'Rancho grande', 'Sergio Gutiérrez', 'Av. del Libertador 900', 'Buenos Aires', '1010', 'Argentina'),
(61, 'Rattlesnake Canyon Grocery', 'Paula Wilson', '2817 Milton Dr.', 'Albuquerque', '87110', 'USA'),
(62, 'Reggiani Caseifici', 'Maurizio Moroni', 'Via Vittorio Emanuele, 122', 'Reggio Emilia', '42100', 'Italy'),
(63, 'Ricardo Adocicados', 'Janete Limeira', 'Av. Copacabana, 260', 'Rio de Janeiro', '05432-043', 'Brazil'),
(64, 'Richter Supermarkt', 'Michael Holz', 'Grenzacherweg 237', 'Genève', '1203', 'Switzerland'),
(65, 'Romero y hijos', 'Alejandra Camino', 'Gran Vía, 1', 'Madrid', '28001', 'Spain'),
(66, 'Santé Gourmet', 'Jonas Björn', 'Erling Skakkes gate 78', 'Stavern', '4110', 'Norway'),
(67, 'Save-on-Foods', 'Jose Pavarotti', '187 Suffolk Ln.', 'Boise', '83720', 'USA'),
(68, 'Seven Seas Imports', 'Hari Kumar', '90 Wadhurst Rd.', 'London', 'OX15 4NB', 'UK'),
(69, 'Simons bistro', 'Jytte Petersen', 'Vinbæltet 34', 'København', '1734', 'Denmark'),
(70, 'Split Rail Beer & Ale', 'Art Braunschweiger', 'P.O. Box 555', 'Lander', '82520', 'USA'),
(71, 'Suprêmes délices', 'Pascale Gautier', 'Rue du Commerce 22', 'Charleroi', 'B-6000', 'Belgium'),
(72, 'The Big Cheese', 'Liz Nixon', '89 Jefferson Way Suite 2', 'Portland', '97219', 'USA'),
(73, 'The Cracker Box', 'Liu Wong', '5555 1st Ave. S. E.', 'Calgary', 'T2G 0P8', 'Canada'),
(74, 'Toms Spezialitäten', 'Markus Schulz', 'Luisenstr. 48', 'Münster', '44087', 'Germany'),
(75, 'Tortuga Restaurante', 'Miguel Angel Paolino', 'Avda. Azteca 123', 'México D.F.', '05033', 'Mexico'),
(76, 'Tradição Hipermercados', 'Anabela Domingues', 'Rua da Panificadora, 12', 'São Paulo', '05432-043', 'Brazil'),
(77, 'Trails Head Gourmet Provisioners', 'Helvetius Nagy', '722 Meadowbrook Rd.', 'Kirkland', '98033', 'USA'),
(78, 'Vaffeljernet', 'Palle Ibsen', 'Smagsloget 45', 'Århus', '8200', 'Denmark'),
(79, 'Victuailles en stock', 'Mary Saveley', '2, rue du Jardin', 'Annecy', '74000', 'France'),
(80, 'Vins et alcools Chevalier', 'Paul Henriot', '59 rue de lAbbaye', 'Reims', '51100', 'France'),
(81, 'Die Wandernde Kuh', 'Rita Müller', 'Adenauerallee 900', 'Stuttgart', '70563', 'Germany'),
(82, 'Wartian Herkku', 'Pirkko Koskitalo', 'Torikatu 38', 'Oulu', '90110', 'Finland'),
(83, 'Wellington Importadora', 'Elizabeth Vila', 'Rua do Mercado, 12', 'Resende', '05432-043', 'Brazil'),
(84, 'White Clover Markets', 'Karl Jablonski', '1029 - 12th Ave. S.', 'Seattle', '98124', 'USA'),
(85, 'Wilman Kala', 'Matti Karttunen', 'Keskuskatu 45', 'Helsinki', '21240', 'Finland'),
(86, 'Wolski', 'Zbyszek Piestrzeniewicz', 'ul. Filtrowa 68', 'Warszawa', '01-012', 'Poland'),
(87, 'XLA-Supermercado', 'Carlos González', 'Carrera 52 con La Paz', 'Barquisimeto', '3508', 'Venezuela'), -- Removed extra '000'
(88, 'Yorkshire Tea', 'Lars Peterson', 'Lane House Broad Street', 'Beverley', 'HU17 8LD', 'UK'),
(89, 'Zaanse Snoepfabriek', 'Dirk van der Berg', 'Verlorenstraat 23', 'Amsterdam', '1000', 'Netherlands'),
(90, 'Zimmerwald Komm. Ges.', 'Roland Mendel', 'Hauptstr. 67', 'Salzburg', '5020', 'Austria'),
(91, 'Zum Gesunden Fisch', 'Horst Kloss', 'Friedrichstr. 43', 'Frankfurt', '60431', 'Germany'),
(92, 'Zürich Stadt', 'Martin Kloss', 'Weststr. 35', 'Zürich', '8004', 'Switzerland');

-- Table structure for table `employees`
CREATE TABLE "employees" (
  "EmployeeID" INTEGER PRIMARY KEY AUTOINCREMENT,
  "LastName" TEXT NOT NULL,
  "FirstName" TEXT NOT NULL,
  "BirthDate" TEXT, -- Changed to TEXT as SQLite handles dates as TEXT, REAL, or INTEGER
  "Photo" TEXT,
  "Notes" TEXT
);

-- Dumping data for table `employees`
INSERT INTO "employees" ("EmployeeID", "LastName", "FirstName", "BirthDate", "Photo", "Notes") VALUES
(1, 'Davolio', 'Nancy', '1968-12-08', 'EmpID1.pic', 'Education includes a BA in psychology from Colorado State University. She also completed a course in "Open Systems Design" at the University of Washington in Seattle.'),
(2, 'Fuller', 'Andrew', '1952-02-19', 'EmpID2.pic', 'Andrew received his BTS commercial in 1974 and a PhD in international marketing from the University of Dallas in 1981.  He is fluent in French and Italian and reads German.  He has worked as a salesman for several companies and is a member of the American Marketing Association.'),
(3, 'Leverling', 'Janet', '1963-08-30', 'EmpID3.pic', 'Janet has a BS degree in chemistry from the University of Washington. She has also completed a course in "HTML and JavaScript" at the University of Washington in Seattle.'),
(4, 'Peacock', 'Margaret', '1958-09-19', 'EmpID4.pic', 'Margaret holds a BA in English literature from the University of Southern California and a Master of Business Administration degree from UCLA. She was a key contributor in the companys early success.'),
(5, 'Buchanan', 'Steven', '1955-03-04', 'EmpID5.pic', 'Steven has a BA degree in economics from the University of Cambridge, UK. He also completed a course in "Data Structures and Algorithms" at the University of Cambridge in 1985.'),
(6, 'Suyama', 'Michael', '1963-07-02', 'EmpID6.pic', 'Michael holds a BS degree in computer science from the University of Washington. He also completed a course in "Database Management Systems" at the University of Washington in Seattle.'),
(7, 'King', 'Robert', '1960-05-29', 'EmpID7.pic', 'Robert has a BA degree in business administration from the University of Washington. He also completed a course in "Web Design and Development" at the University of Washington in Seattle.'),
(8, 'Callahan', 'Laura', '1958-01-09', 'EmpID8.pic', 'Laura received a BA in art history from the University of California at Berkeley. She is fluent in German and Italian.'),
(9, 'Dodsworth', 'Anne', '1966-07-02', 'EmpID9.pic', 'Anne has a BS degree in biology from the University of Washington. She also completed a course in "Advanced Programming in C#" at the University of Washington in Seattle.');

-- Table structure for table `order_details`
CREATE TABLE "order_details" (
  "OrderDetailID" INTEGER PRIMARY KEY AUTOINCREMENT,
  "OrderID" INTEGER,
  "ProductID" INTEGER,
  "Quantity" INTEGER,
  FOREIGN KEY ("OrderID") REFERENCES "orders"("OrderID"),
  FOREIGN KEY ("ProductID") REFERENCES "products"("ProductID")
);

-- Dumping data for table `order_details`
INSERT INTO "order_details" ("OrderDetailID", "OrderID", "ProductID", "Quantity") VALUES
(1, 10248, 11, 12),
(2, 10248, 42, 10),
(3, 10248, 72, 5),
(4, 10249, 14, 9),
(5, 10249, 51, 40),
(6, 10250, 41, 10),
(7, 10250, 65, 35),
(8, 10250, 22, 16),
(9, 10251, 22, 6),
(10, 10251, 57, 15),
(11, 10251, 65, 20),
(12, 10252, 20, 30),
(13, 10252, 33, 25),
(14, 10252, 67, 40),
(15, 10253, 72, 30),
(16, 10253, 13, 20),
(17, 10253, 31, 15),
(18, 10254, 76, 21),
(19, 10254, 14, 30),
(20, 10254, 28, 18),
(21, 10255, 33, 30),
(22, 10255, 14, 20),
(23, 10255, 22, 50),
(24, 10256, 76, 20),
(25, 10256, 14, 40),
(26, 10256, 28, 12),
(27, 10257, 14, 30),
(28, 10257, 59, 15),
(29, 10257, 65, 40),
(30, 10258, 22, 50),
(31, 10258, 14, 30),
(32, 10258, 76, 20),
(33, 10259, 76, 10),
(34, 10259, 22, 30),
(35, 10259, 59, 10),
(36, 10260, 59, 30),
(37, 10260, 22, 20),
(38, 10260, 76, 10),
(39, 10261, 76, 20),
(40, 10261, 59, 10),
(41, 10261, 22, 30),
(42, 10262, 22, 20),
(43, 10262, 59, 10),
(44, 10262, 76, 30),
(45, 10263, 76, 15),
(46, 10263, 22, 10),
(47, 10263, 59, 30),
(48, 10264, 59, 20),
(49, 10264, 76, 10),
(50, 10264, 22, 30),
(51, 10265, 22, 10),
(52, 10265, 59, 30),
(53, 10265, 76, 20),
(54, 10266, 76, 30),
(55, 10266, 22, 20),
(56, 10266, 59, 10),
(57, 10267, 59, 40),
(58, 10267, 76, 20),
(59, 10267, 22, 10),
(60, 10268, 22, 30),
(61, 10268, 59, 20),
(62, 10268, 76, 10),
(63, 10269, 76, 25),
(64, 10269, 22, 15),
(65, 10269, 59, 10);

-- Table structure for table `orders`
CREATE TABLE "orders" (
  "OrderID" INTEGER PRIMARY KEY AUTOINCREMENT,
  "CustomerID" INTEGER,
  "EmployeeID" INTEGER,
  "OrderDate" TEXT, -- Changed to TEXT for date/datetime storage in SQLite
  "ShipperID" INTEGER,
  FOREIGN KEY ("CustomerID") REFERENCES "customers"("CustomerID"),
  FOREIGN KEY ("EmployeeID") REFERENCES "employees"("EmployeeID"),
  FOREIGN KEY ("ShipperID") REFERENCES "shippers"("ShipperID")
);

-- Dumping data for table `orders`
INSERT INTO "orders" ("OrderID", "CustomerID", "EmployeeID", "OrderDate", "ShipperID") VALUES
(10248, 90, 5, '1996-07-04 00:00:00', 3),
(10249, 81, 6, '1996-07-05 00:00:00', 1),
(10250, 34, 4, '1996-07-08 00:00:00', 2),
(10251, 84, 3, '1996-07-08 00:00:00', 1),
(10252, 76, 4, '1996-07-09 00:00:00', 2),
(10253, 34, 3, '1996-07-10 00:00:00', 2),
(10254, 76, 5, '1996-07-11 00:00:00', 2),
(10255, 76, 2, '1996-07-12 00:00:00', 1),
(10256, 76, 6, '1996-07-15 00:00:00', 2),
(10257, 34, 4, '1996-07-16 00:00:00', 3),
(10258, 34, 1, '1996-07-17 00:00:00', 1),
(10259, 34, 4, '1996-07-18 00:00:00', 3),
(10260, 34, 8, '1996-07-19 00:00:00', 1),
(10261, 34, 1, '1996-07-19 00:00:00', 2),
(10262, 34, 3, '1996-07-22 00:00:00', 3),
(10263, 34, 2, '1996-07-23 00:00:00', 3),
(10264, 34, 5, '1996-07-24 00:00:00', 3),
(10265, 34, 3, '1996-07-25 00:00:00', 2),
(10266, 34, 7, '1996-07-26 00:00:00', 2),
(10267, 34, 4, '1996-07-29 00:00:00', 1),
(10268, 34, 3, '1996-07-30 00:00:00', 3),
(10269, 34, 1, '1996-07-31 00:00:00', 2);

-- Table structure for table `products`
CREATE TABLE "products" (
  "ProductID" INTEGER PRIMARY KEY AUTOINCREMENT,
  "ProductName" TEXT NOT NULL,
  "SupplierID" INTEGER,
  "CategoryID" INTEGER,
  "Unit" TEXT,
  "Price" REAL DEFAULT '0.00', -- Changed to REAL for decimal numbers
  FOREIGN KEY ("SupplierID") REFERENCES "suppliers"("SupplierID"),
  FOREIGN KEY ("CategoryID") REFERENCES "categories"("CategoryID")
);

-- Dumping data for table `products`
INSERT INTO "products" ("ProductID", "ProductName", "SupplierID", "CategoryID", "Unit", "Price") VALUES
(1, 'Chais', 1, 1, '10 boxes x 20 bags', 18.00),
(2, 'Chang', 1, 1, '24 - 12 oz bottles', 19.00),
(3, 'Aniseed Syrup', 1, 2, '12 - 550 ml bottles', 10.00),
(4, 'Chef Antons Cajun Seasoning', 2, 2, '48 - 6 oz jars', 22.00),
(5, 'Chef Antons Gumbo Mix', 2, 2, '36 boxes', 21.35),
(6, 'Grandma Kellys Homestead', 3, 2, '12 - 8 oz jars', 25.00),
(7, 'Uncle Bobs Organic Dried Pears', 3, 7, '12 - 1 lb pkgs.', 30.00),
(8, 'Northwoods Cranberry Sauce', 3, 2, '12 - 12 oz jars', 40.00),
(9, 'Mishi Kobe Niku', 4, 6, '18 - 500 g pkgs.', 97.00),
(10, 'Ikura', 4, 8, '12 - 200 ml jars', 31.00),
(11, 'Queso Cabrales', 5, 4, '1 kg pkg.', 21.00),
(12, 'Queso Manchego La Pastora', 5, 4, '10 - 500 g pkgs.', 38.00),
(13, 'Konbu', 6, 8, '2 kg box', 6.00),
(14, 'Tofu', 6, 7, '40 - 100 g pkgs.', 23.25),
(15, 'Genen Shouyu', 6, 2, '24 - 250 ml bottles', 15.50),
(16, 'Pavlova', 7, 3, '32 - 500 g boxes', 17.45),
(17, 'Carnarvon Tigers', 7, 8, '16 kg pkg.', 62.50),
(18, 'Teatime Chocolate Biscuits', 8, 3, '10 boxes x 12 pieces', 9.20),
(19, 'Sir Rodneys Marmalade', 8, 3, '30 gift boxes', 81.00),
(20, 'Gustafs Knäckebröd', 9, 5, '24 - 500 g pkgs.', 21.00),
(21, 'Tunnbröd', 9, 5, '12 - 250 g pkgs.', 9.00),
(22, 'Guaraná Fantástica', 10, 1, '12 - 355 ml cans', 4.50),
(23, 'NuNuCa Nuß-Nougat-Creme', 11, 3, '20 - 450 g glasses', 14.00),
(24, 'Gumbär Gummibärchen', 11, 3, '100 - 250 g bags', 13.00),
(25, 'Schoggi Schokolade', 11, 3, '100 g bars', 17.40),
(26, 'Rössle Sauerkraut', 12, 7, '25 - 825 g cans', 45.60),
(27, 'Thüringer Rostbratwurst', 12, 6, '50 bags x 30 sausgs.', 123.79),
(28, 'Nord-Ost Matjeshering', 13, 8, '10 - 200 g glasses', 25.89),
(29, 'Gorgonzola Telino', 14, 4, '12 - 100 g pkgs', 12.50),
(30, 'Mascarpone Fabioli', 14, 4, '12 - 200 g pkgs.', 32.00),
(31, 'Geitost', 15, 4, '500 g', 2.50),
(32, 'Sasquatch Ale', 16, 1, '24 - 12 oz bottles', 14.00),
(33, 'Steeleye Stout', 16, 1, '24 - 12 oz bottles', 18.00),
(34, 'Inlagd Sill', 17, 8, '24 - 250 g jars', 19.00),
(35, 'Gravad lax', 17, 8, '12 - 500 g pkgs.', 26.00),
(36, 'Côte de Blaye', 18, 1, '12 - 75 cl bottles', 263.50),
(37, 'Chartreuse verte', 18, 1, '750 cc bottle', 18.00),
(38, 'Boston Crab Meat', 19, 8, '24 - 4 oz tins', 18.40),
(39, 'Jacks New England Clam Chowder', 19, 8, '12 - 12 oz cans', 9.65),
(40, 'Singaporean Laksa', 20, 2, '1 kg box', 14.00),
(41, 'Mozzarella di Giovanni', 21, 4, '24 - 200 g pkgs.', 34.80),
(42, 'Røgede sild', 17, 8, '1 kg pkg.', 9.00),
(43, 'Faubourg Mixte', 22, 1, '24 - 33 cl bottles', 24.00),
(44, 'Flotemysost', 15, 4, '10 kg pkg.', 21.50),
(45, 'Gustafs Knäckebröd', 9, 5, '24 - 500 g pkgs.', 21.00),
(46, 'Spegesild', 17, 8, '4 kg pkg.', 12.00),
(47, 'Zaanse koeken', 23, 3, '10 - 4 oz boxes', 9.50),
(48, 'Chocolade', 23, 3, '10 kg pkg.', 12.75),
(49, 'Maxilaku', 24, 3, '24 - 50 g pkgs.', 20.00),
(50, 'Valkoinen suklaa', 24, 3, '12 - 100 g bars', 16.25),
(51, 'Manjimup Dried Apples', 25, 7, '50 - 300 g pkgs.', 53.00),
(52, 'Filo Mix', 25, 5, '16 - 2 kg boxes', 7.00),
(53, 'Perth Pasties', 25, 6, '48 pieces', 32.80),
(54, 'Tourtière', 26, 6, '16 pies', 7.45),
(55, 'Pâté chinois', 26, 6, '24 boxes x 2 pies', 24.00),
(56, 'Gnocchi di nonna Alice', 27, 5, '24 - 250 g pkgs.', 38.00),
(57, 'Ravioli Angelo', 27, 5, '24 - 250 g pkgs.', 19.50),
(58, 'Escargots de Bourgogne', 28, 8, '24 pieces', 13.25),
(59, 'Raclette Courdavault', 29, 4, '5 kg pkg.', 55.00),
(60, 'Camembert Pierrot', 29, 4, '15 - 300 g rounds', 34.00),
(61, 'Sirop derable', 30, 2, '18 - 500 ml bottles', 28.50),
(62, 'Tarte au sucre', 30, 3, '48 pies', 49.30),
(63, 'Vegie-spread', 7, 2, '15 - 625 g jars', 43.90),
(64, 'Wimmers gute Semmelknödel', 12, 5, '20 bags x 4 pieces', 33.25),
(65, 'Louisiana Fiery Hot Pepper Sauce', 2, 2, '32 - 8 oz bottles', 21.05),
(66, 'Louisiana Hot Spiced Okra', 2, 2, '24 - 8 oz jars', 17.00),
(67, 'Laughing Lumberjack Lager', 16, 1, '24 - 12 oz bottles', 14.00),
(68, 'Scottish Longbreads', 8, 3, '10 boxes x 8 pieces', 12.50),
(69, 'Gudbrandsdalost', 15, 4, '10 kg pkg.', 36.00),
(70, 'Outback Lager', 12, 1, '24 - 355 ml bottles', 15.00),
(71, 'Fløtemysost', 15, 4, '10 kg pkg.', 21.50),
(72, 'Mozzarella di Giovanni', 21, 4, '24 - 200 g pkgs.', 34.80),
(73, 'Røgede sild', 17, 8, '1 kg pkg.', 9.00),
(74, 'Longlife Tofu', 4, 7, '5 kg box', 10.00),
(75, 'Lakkalikööri', 24, 1, '500 ml bottle', 18.00),
(76, 'Original Frankfurter Grüne Soße', 12, 2, '12 boxes', 13.00);

-- Table structure for table `shippers`
CREATE TABLE "shippers" (
  "ShipperID" INTEGER PRIMARY KEY AUTOINCREMENT,
  "ShipperName" TEXT NOT NULL,
  "Phone" TEXT
);

-- Dumping data for table `shippers`
INSERT INTO "shippers" ("ShipperID", "ShipperName", "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" INTEGER PRIMARY KEY AUTOINCREMENT,
  "SupplierName" TEXT NOT NULL,
  "ContactName" TEXT,
  "Address" TEXT,
  "City" TEXT,
  "PostalCode" TEXT,
  "Country" TEXT,
  "Phone" TEXT
);

-- Dumping data for table `suppliers`
INSERT INTO "suppliers" ("SupplierID", "SupplierName", "ContactName", "Address", "City", "PostalCode", "Country", "Phone") VALUES
(1, 'Exotic Liquid', 'Charlotte Cooper', '49 Gilbert St.', 'London', 'EC1 4SD', 'UK', '(171) 555-2222'),
(2, 'New Orleans Cajun Delights', 'Shelley Burke', 'P.O. Box 78934', 'New Orleans', '70117', 'USA', '(100) 555-4822'),
(3, 'Grandma Kellys Homestead', 'Regina Murphy', '707 Oxford Rd.', 'Ann Arbor', '48104', 'USA', '(313) 555-5735'),
(4, 'Tokyo Traders', 'Yoshi Nagase', '9-8 Sekimai Musashino-shi', 'Tokyo', '100', 'Japan', '(03) 3555-5000'),
(5, 'Cooperativa de Quesos Las Cabras', 'Antonio del Valle', 'Calle del Rosal 4', 'Oviedo', '33007', 'Spain', '(98) 598 76 54'),
(6, 'Mayumis', 'Mayumi Ohno', '92 Setsuko Chuo-ku', 'Osaka', '545', 'Japan', '(06) 431-7878'),
(7, 'Pavlova, Ltd.', 'Ian Devling', '74 Rose St. Moonie Ponds', 'Melbourne', '3058', 'Australia', '(03) 444-2343'),
(8, 'Specialty Biscuits, Ltd.', 'Peter Wilson', '29 Kings Way', 'Manchester', 'M14 GSD', 'UK', '(161) 555-4448'),
(9, 'PB S.A.', 'Lars Peterson', 'Rua do Mercado, 12', 'Rio de Janeiro', '05432-043', 'Brazil', '(21) 555-4252'),
(10, 'Refrescos Americanas LTDA', 'Carlos Diaz', 'Av. das Americanas 12.890', 'São Paulo', '05432-043', 'Brazil', '(11) 555 4640'),
(11, 'Heli Süßwaren GmbH & Co. KG', 'Ing. Bernd Hoffmann', 'Tiergartenstr. 5', 'Berlin', '10785', 'Germany', '(010) 9984510'),
(12, 'Plutzer Lebensmittelgroßmärkte AG', 'Martin Bein', 'Bogenallee 51', 'Frankfurt', '60439', 'Germany', '(069) 992755'),
(13, 'Nord-Ost-Fisch Handelsgesellschaft mbH', 'Sven Petersen', 'Frahmredder 112a', 'Cuxhaven', '27478', 'Germany', '(04721) 8714'),
(14, 'Formaggi Fortini s.r.l.', 'Elio Rossi', 'Viale Dante, 75', 'Ravenna', '48100', 'Italy', '(0544) 60321'),
(15, 'Norske Meierier', 'Beate Vileid', 'Sandvika 75', 'Sandvika', '1300', 'Norway', '(0)2-9530 4753'),
(16, 'Bigfoot Breweries', 'Cheryl Saylor', '3400 - 8th Avenue Suite 210', 'Bend', '97101', 'USA', '(503) 555-9931'),
(17, 'Svensk Sjofoda AB', 'Michael Björn', 'Brovallavägen 231', 'Stockholm', 'S-123 45', 'Sweden', '(08) 123 45 67'),
(18, 'Aux joyeux ecclésiastiques', 'Guylène Nodier', '203, Rue des Célestins', 'Paris', '75004', 'France', '(1) 03.83.00.68'),
(19, 'Forêts derables', 'Chantal Goulet', '1487 rue Laberge', 'Montréal', 'H3G 1M6', 'Canada', '(514) 555-3333'),
(20, 'Leka Trading', 'Valerie King', '4726 - 11th Ave. N.E.', 'Seattle', '98105', 'USA', '(206) 555-7673'),
(21, 'Lyngs Fiskehandel', 'Niels Henriksen', 'Lyngs Alle 27', 'København', '8400', 'Denmark', '(45) 8777977'),
(22, 'Gai pâturage', 'Eliane Noz', 'Bat. B 3, rue des Alpes', 'Annecy', '74000', 'France', '(79) 83 45 67'),
(23, 'Zaanse Snoepfabriek', 'Dirk van der Berg', 'Verlorenstraat 23', 'Amsterdam', '1000', 'Netherlands', '(020) 1234567'),
(24, 'Karkki Oy', 'Anne Heikkonen', 'Valtakatu 12', 'Lappeenranta', '53120', 'Finland', '(953) 4455845'),
(25, 'Gday, Mate', 'Wendy Mackenzie', '170 Prince Edward Parade Hunters Hill', 'Sydney', '2042', 'Australia', '(02) 555-8765'),
(26, 'Pasta Buttini s.r.l.', 'Giovanni Giudici', 'Via dei Gelsomini, 42', 'Salerno', '84100', 'Italy', '(089) 654721'),
(27, 'Escargots Nouveaux', 'Marie Labatt', '22, rue H. de Balzac', 'Paris', '75000', 'France', '(1) 42.34.22.66'),
(28, 'Gai pâturage', 'Eliane Noz', 'Bat. B 3, rue des Alpes', 'Annecy', '74000', 'France', '(79) 83 45 67'),
(29, 'Raclette Courdavault', 'Jean-Bernard Lefebvre', '24, place Kléber', 'Strasbourg', '67000', 'France', '(88)60.15.31'),
(30, 'Chef Pierre', 'Pierre Maury', '59, rue de lAbbaye', 'Paris', '75001', 'France', '(1) 42.34.22.66');

UPDATE Products
SET SupplierID = NULL, CategoryID = NULL
WHERE SupplierID = 1;