/* Navicat Premium Dump SQL Source Server : ptk Source Server Type : MySQL Source Server Version : 80404 (8.4.4) Source Host : localhost:3306 Source Schema : sales Target Server Type : MySQL Target Server Version : 80404 (8.4.4) File Encoding : 65001 Date: 05/04/2025 11:52:40 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for contacts -- ---------------------------- DROP TABLE IF EXISTS `contacts`; CREATE TABLE `contacts` ( `contact_id` smallint NOT NULL, `first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `customer_id` smallint NOT NULL, PRIMARY KEY (`contact_id`) USING BTREE, INDEX `fk_contacts_customer`(`customer_id` ASC) USING BTREE, CONSTRAINT `fk_contacts_customer` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`customer_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of contacts -- ---------------------------- INSERT INTO `contacts` VALUES (1, 'Flor', 'Stone', 'florstone@raytheoncom', '+1 317 123 4104', 1); INSERT INTO `contacts` VALUES (2, 'Lavera', 'Emerson', 'laveraemerson@plainsallamericancom', '+1 317 123 4111', 2); INSERT INTO `contacts` VALUES (3, 'Fern', 'Head', 'fernhead@usfoodscom', '+1 812 123 4115', 3); INSERT INTO `contacts` VALUES (4, 'Shyla', 'Ortiz', 'shylaortiz@abbviecom', '+1 317 123 4126', 4); INSERT INTO `contacts` VALUES (5, 'Jeni', 'Levy', 'jenilevy@centenecom', '+1 812 123 4129', 5); INSERT INTO `contacts` VALUES (6, 'Matthias', 'Hannah', 'matthiashannah@chsnet', '+1 219 123 4136', 6); INSERT INTO `contacts` VALUES (7, 'Matthias', 'Cruise', 'matthiascruise@alcoacom', '+1 219 123 4138', 7); INSERT INTO `contacts` VALUES (8, 'Meenakshi', 'Mason', 'meenakshimason@internationalpapercom', '+1 317 123 4141', 8); INSERT INTO `contacts` VALUES (9, 'Christian', 'Cage', 'christiancage@emersoncom', '+1 219 123 4142', 9); INSERT INTO `contacts` VALUES (10, 'Charlie', 'Sutherland', 'charliesutherland@upcom', '+1 317 123 4146', 10); INSERT INTO `contacts` VALUES (11, 'Charlie', 'Pacino', 'charliepacino@amgencom', '+1 812 123 4150', 11); INSERT INTO `contacts` VALUES (12, 'Guillaume', 'Jackson', 'guillaumejackson@usbankcom', '+1 812 123 4151', 12); INSERT INTO `contacts` VALUES (13, 'Daniel', 'Costner', 'danielcostner@staplescom', '+1 812 123 4153', 13); INSERT INTO `contacts` VALUES (14, 'Dianne', 'Derek', 'diannederek@danahercom', '+1 812 123 4157', 14); INSERT INTO `contacts` VALUES (15, 'Geraldine', 'Schneider', 'geraldineschneider@whirlpoolcorpcom', '+1 313 123 4159', 15); INSERT INTO `contacts` VALUES (16, 'Geraldine', 'Martin', 'geraldinemartin@aflaccom', '+1 313 123 4160', 16); INSERT INTO `contacts` VALUES (17, 'Guillaume', 'Edwards', 'guillaumeedwards@autonationcom', '+1 616 123 4162', 17); INSERT INTO `contacts` VALUES (18, 'Maurice', 'Mahoney', 'mauricemahoney@progressivecom', '+1 616 123 4181', 18); INSERT INTO `contacts` VALUES (19, 'Maurice', 'Hasan', 'mauricehasan@abbottcom', '+1 517 123 4191', 19); INSERT INTO `contacts` VALUES (20, 'Diane', 'Higgins', 'dianehiggins@dollargeneralcom', '+1 517 123 4199', 20); INSERT INTO `contacts` VALUES (21, 'Dianne', 'Sen', 'diannesen@tenethealthcom', '+1 517 123 4201', 21); INSERT INTO `contacts` VALUES (22, 'Maurice', 'Daltrey', 'mauricedaltrey@lillycom', '+1 517 123 4206', 22); INSERT INTO `contacts` VALUES (23, 'Tess', 'Roth', 'tessroth@dteenergycom', '+1 313 123 4219', 23); INSERT INTO `contacts` VALUES (24, 'Ka', 'Kaufman', 'kakaufman@southwestcom', '+1 313 123 4222', 24); INSERT INTO `contacts` VALUES (25, 'Sharyl', 'Montoya', 'sharylmontoya@penskeautomotivecom', '+1 517 123 4225', 25); INSERT INTO `contacts` VALUES (26, 'Daniel', 'Glass', 'danielglass@manpowergroupcom', '+1 313 123 4226', 26); INSERT INTO `contacts` VALUES (27, 'Rena', 'Arnold', 'renaarnold@assurantcom', '+1 517 123 4228', 27); INSERT INTO `contacts` VALUES (28, 'Arlyne', 'Ingram', 'arlyneingram@kohlscorporationcom', '+1 313 123 4230', 28); INSERT INTO `contacts` VALUES (29, 'Willie', 'Barrera', 'williebarrera@starbuckscom', '+1 616 123 4234', 29); INSERT INTO `contacts` VALUES (30, 'Mireya', 'Cochran', 'mireyacochran@paccarcom', '+1 313 123 4242', 30); INSERT INTO `contacts` VALUES (31, 'Marlene', 'Odom', 'marleneodom@cumminscom', '+1 616 123 4245', 31); INSERT INTO `contacts` VALUES (32, 'Jaclyn', 'Atkinson', 'jaclynatkinson@globalpcom', '+1 313 123 4248', 32); INSERT INTO `contacts` VALUES (33, 'Al', 'Schultz', 'alschultz@altriacom', '+1 517 123 4253', 33); INSERT INTO `contacts` VALUES (34, 'Felicitas', 'Riley', 'felicitasriley@xeroxcom', '+1 313 123 4255', 34); INSERT INTO `contacts` VALUES (35, 'Cora', 'Calhoun', 'coracalhoun@kimberly-clarkcom', '+1 313 123 4263', 35); INSERT INTO `contacts` VALUES (36, 'Trula', 'Buckley', 'trulabuckley@thehartfordcom', '+1 517 123 4265', 36); INSERT INTO `contacts` VALUES (37, 'Sasha', 'Wallace', 'sashawallace@huntsmancom', '+1 319 123 4271', 37); INSERT INTO `contacts` VALUES (38, 'Caitlin', 'Hill', 'caitlinhill@kraftheinzcompanycom', '+1 515 123 4273', 38); INSERT INTO `contacts` VALUES (39, 'Gino', 'Pickett', 'ginopickett@learcom', '+1 319 123 4278', 39); INSERT INTO `contacts` VALUES (40, 'Amira', 'Macdonald', 'amiramacdonald@fluorcom', '+1 712 123 4280', 40); INSERT INTO `contacts` VALUES (41, 'Mack', 'Morse', 'mackmorse@aecomcom', '+1 319 123 4282', 41); INSERT INTO `contacts` VALUES (42, 'Eboni', 'Jarvis', 'ebonijarvis@bdcom', '+1 319 123 4288', 42); INSERT INTO `contacts` VALUES (43, 'Gabrielle', 'Dennis', 'gabrielledennis@facebookcom', '+1 515 123 4290', 43); INSERT INTO `contacts` VALUES (44, 'Classie', 'Norris', 'classienorris@jabilcom', '+1 319 123 4301', 44); INSERT INTO `contacts` VALUES (45, 'Khalilah', 'Holman', 'khalilahholman@centurylinkcom', '+1 745 123 4306', 45); INSERT INTO `contacts` VALUES (46, 'Isreal', 'Rose', 'isrealrose@supervalucom', '+1 414 123 4307', 46); INSERT INTO `contacts` VALUES (47, 'Verena', 'Hopper', 'verenahopper@generalmillscom', '+1 414 123 4308', 47); INSERT INTO `contacts` VALUES (48, 'Audie', 'Flores', 'audieflores@southerncompanycom', '+1 608 123 4309', 48); INSERT INTO `contacts` VALUES (49, 'Gertrude', 'Cooke', 'gertrudecooke@nexteraenergycom', '+1 608 123 4318', 49); INSERT INTO `contacts` VALUES (50, 'Princess', 'Kane', 'princesskane@thermofishercom', '+1 414 123 4323', 50); INSERT INTO `contacts` VALUES (51, 'Jacinta', 'Faulkner', 'jacintafaulkner@aepcom', '+1 414 123 4324', 51); INSERT INTO `contacts` VALUES (52, 'Lashon', 'Wall', 'lashonwall@pgecom', '+1 414 123 4328', 52); INSERT INTO `contacts` VALUES (53, 'Corliss', 'Mcneil', 'corlissmcneil@nglenergypartnerscom', '+1 608 123 4332', 53); INSERT INTO `contacts` VALUES (54, 'Brock', 'Webb', 'brockwebb@bmscom', '+1 608 123 4344', 54); INSERT INTO `contacts` VALUES (55, 'Melany', 'Mcmahon', 'melanymcmahon@goodyearcom', '+1 414 123 4347', 55); INSERT INTO `contacts` VALUES (56, 'Rogelio', 'Kirby', 'rogeliokirby@nucorcom', '+1 414 123 4348', 56); INSERT INTO `contacts` VALUES (57, 'Wallace', 'Dillard', 'wallacedillard@pnccom', '+1 414 123 4350', 57); INSERT INTO `contacts` VALUES (58, 'Gia', 'Boyle', 'giaboyle@healthnetcom', '+1 745 123 4367', 58); INSERT INTO `contacts` VALUES (59, 'Tennie', 'Gay', 'tenniegay@microncom', '+1 414 123 4369', 59); INSERT INTO `contacts` VALUES (60, 'Ophelia', 'Hurst', 'opheliahurst@colgatepalmolivecom', '+1 715 123 4372', 60); INSERT INTO `contacts` VALUES (61, 'Ciara', 'Flowers', 'ciaraflowers@fcxcom', '+1 414 123 4373', 61); INSERT INTO `contacts` VALUES (62, 'Birgit', 'Stephenson', 'birgitstephenson@conagrafoodscom', '+1 608 123 4374', 62); INSERT INTO `contacts` VALUES (63, 'Shameka', 'Spencer', 'shamekaspencer@sempracom', '+1 414 123 4376', 63); INSERT INTO `contacts` VALUES (64, 'Alysa', 'Kane', 'alysakane@gapinccom', '+1 608 123 4378', 64); INSERT INTO `contacts` VALUES (65, 'Fransisca', 'Reeves', 'fransiscareeves@bakerhughescom', '+1 414 123 4381', 65); INSERT INTO `contacts` VALUES (66, 'Jessika', 'Merritt', 'jessikamerritt@bnymelloncom', '+1 612 123 4397', 66); INSERT INTO `contacts` VALUES (67, 'Agustina', 'Conner', 'agustinaconner@dollartreecom', '+1 612 123 4399', 67); INSERT INTO `contacts` VALUES (68, 'Roxanna', 'Wade', 'roxannawade@autozonecom', '+1 612 123 4408', 68); INSERT INTO `contacts` VALUES (69, 'Virgie', 'Mays', 'virgiemays@wholefoodsmarketcom', '+1 612 123 4417', 69); INSERT INTO `contacts` VALUES (70, 'Trang', 'Mcconnell', 'trangmcconnell@ppgcom', '+1 612 123 4419', 70); INSERT INTO `contacts` VALUES (71, 'Nada', 'West', 'nadawest@genptcom', '+1 507 123 4421', 71); INSERT INTO `contacts` VALUES (72, 'Catherina', 'Haney', 'catherinahaney@ielpcom', '+1 218 123 4429', 72); INSERT INTO `contacts` VALUES (73, 'Harriette', 'Melton', 'harriettemelton@navistarcom', '+1 612 123 4434', 73); INSERT INTO `contacts` VALUES (74, 'Willette', 'Rodgers', 'willetterodgers@pfgccom', '+1 315 123 4442', 74); INSERT INTO `contacts` VALUES (75, 'Calandra', 'Williamson', 'calandrawilliamson@omnicomgroupcom', '+1 315 123 4447', 75); INSERT INTO `contacts` VALUES (76, 'Tamatha', 'Delgado', 'tamathadelgado@dishcom', '+1 716 123 4457', 76); INSERT INTO `contacts` VALUES (77, 'Felix', 'Ferguson', 'felixferguson@firstenergycorpcom', '+1 518 123 4459', 77); INSERT INTO `contacts` VALUES (78, 'Elwood', 'Hampton', 'elwoodhampton@precastcom', '+1 518 123 4464', 78); INSERT INTO `contacts` VALUES (79, 'Josh', 'Roach', 'joshroach@monsantocom', '+1 518 123 4474', 79); INSERT INTO `contacts` VALUES (80, 'Luanna', 'Scott', 'luannascott@aescom', '+1 914 123 4494', 80); INSERT INTO `contacts` VALUES (81, 'Meryl', 'Cole', 'merylcole@carmaxcom', '+1 518 123 4496', 81); INSERT INTO `contacts` VALUES (82, 'Jannet', 'Elliott', 'jannetelliott@discoverfinancialcom', '+1 716 123 4575', 82); INSERT INTO `contacts` VALUES (83, 'Fae', 'Glenn', 'faeglenn@novcom', '+1 914 123 4578', 83); INSERT INTO `contacts` VALUES (84, 'Francisco', 'Cummings', 'franciscocummings@nrgenergycom', '+1 315 123 4597', 84); INSERT INTO `contacts` VALUES (85, 'Ermelinda', 'Benton', 'ermelindabenton@westerndigitalcom', '+1 716 123 4599', 85); INSERT INTO `contacts` VALUES (86, 'Lasonya', 'Beard', 'lasonyabeard@marriottcom', '+1 716 123 4605', 86); INSERT INTO `contacts` VALUES (87, 'Rayna', 'Tran', 'raynatran@libertyinteractivecom', '+1 518 123 4617', 87); INSERT INTO `contacts` VALUES (88, 'Annice', 'Boyer', 'anniceboyer@walmartcom', '+1 518 123 4618', 88); INSERT INTO `contacts` VALUES (89, 'Ja', 'Whitfield', 'jawhitfield@exxonmobilcom', '+1 914 123 4619', 89); INSERT INTO `contacts` VALUES (90, 'Jaime', 'Lester', 'jaimelester@applecom', '+1 518 123 4624', 90); INSERT INTO `contacts` VALUES (91, 'Charlsie', 'Lindsey', 'charlsielindsey@berkshirehathawaycom', '+1 215 123 4644', 91); INSERT INTO `contacts` VALUES (92, 'Jannette', 'Henry', 'jannettehenry@mckessoncom', '+1 610 123 4657', 92); INSERT INTO `contacts` VALUES (93, 'Margart', 'Mccall', 'margartmccall@unitedhealthgroupcom', '+1 412 123 4662', 93); INSERT INTO `contacts` VALUES (94, 'Twanna', 'Cleveland', 'twannacleveland@cvshealthcom', '+1 814 123 4663', 94); INSERT INTO `contacts` VALUES (95, 'Bronwyn', 'Horn', 'bronwynhorn@gmcom', '+1 610 123 4664', 95); INSERT INTO `contacts` VALUES (96, 'Jon', 'Petersen', 'jonpetersen@fordcom', '+1 610 123 4667', 96); INSERT INTO `contacts` VALUES (97, 'Denny', 'Daniel', 'dennydaniel@attcom', '+1 610 123 4669', 97); INSERT INTO `contacts` VALUES (98, 'Avis', 'Moore', 'avismoore@gecom', '+1 717 123 4674', 98); INSERT INTO `contacts` VALUES (99, 'Eden', 'Burke', 'edenburke@amerisourcebergencom', '+1 215 123 4676', 99); INSERT INTO `contacts` VALUES (100, 'Elisha', 'Lloyd', 'elishalloyd@verizoncom', '+1 412 123 4681', 100); INSERT INTO `contacts` VALUES (101, 'Samara', 'Barnett', 'samarabarnett@chevroncom', '+1 412 123 4684', 101); INSERT INTO `contacts` VALUES (102, 'Nadia', 'Sawyer', 'nadiasawyer@costcocom', '+1 412 123 4688', 102); INSERT INTO `contacts` VALUES (103, 'Melita', 'Holcomb', 'melitaholcomb@fanniemaecom', '+1 412 123 4691', 103); INSERT INTO `contacts` VALUES (104, 'Evita', 'Dickerson', 'evitadickerson@thekrogercocom', '+1 717 123 4692', 104); INSERT INTO `contacts` VALUES (105, 'Aundrea', 'Barry', 'aundreabarry@amazoncom', '+1 814 123 4696', 105); INSERT INTO `contacts` VALUES (106, 'Irvin', 'Leach', 'irvinleach@walgreensbootsalliancecom', '+1 814 123 4697', 106); INSERT INTO `contacts` VALUES (107, 'Kellee', 'Molina', 'kelleemolina@hpcom', '+1 412 123 4700', 107); INSERT INTO `contacts` VALUES (108, 'Ronny', 'Sykes', 'ronnysykes@cardinalcom', '+1 814 123 4706', 108); INSERT INTO `contacts` VALUES (109, 'Ocie', 'Walton', 'ociewalton@express-scriptscom', '+1 215 123 4708', 109); INSERT INTO `contacts` VALUES (110, 'Reva', 'Fuller', 'revafuller@jpmorganchasecom', '+1 610 123 4714', 110); INSERT INTO `contacts` VALUES (111, 'Marica', 'Henderson', 'maricahenderson@graingercom', '+1 412 123 4718', 111); INSERT INTO `contacts` VALUES (112, 'Vanetta', 'Gross', 'vanettagross@boeingcom', '+1 215 123 4721', 112); INSERT INTO `contacts` VALUES (113, 'Audrea', 'Hayden', 'audreahayden@microsoftcom', '+1 814 123 4722', 113); INSERT INTO `contacts` VALUES (114, 'Neda', 'Mcfadden', 'nedamcfadden@bankofamericacom', '+1 412 123 4724', 114); INSERT INTO `contacts` VALUES (115, 'Dell', 'Wilkinson', 'dellwilkinson@wellsfargocom', '+1 717 123 4730', 115); INSERT INTO `contacts` VALUES (116, 'Sharee', 'Carver', 'shareecarver@baxtercom', '+1 215 123 4738', 116); INSERT INTO `contacts` VALUES (117, 'Joaquina', 'Mcconnell', 'joaquinamcconnell@homedepotcom', '+1 717 123 4739', 117); INSERT INTO `contacts` VALUES (118, 'Carlyn', 'Calderon', 'carlyncalderon@citigroupcom', '+1 412 123 4740', 118); INSERT INTO `contacts` VALUES (119, 'Olga', 'Wilkins', 'olgawilkins@phillips66com', '+1 717 123 4741', 119); INSERT INTO `contacts` VALUES (120, 'Delpha', 'Golden', 'delphagolden@strykercom', '+1 215 123 4743', 120); INSERT INTO `contacts` VALUES (121, 'Sharell', 'Branch', 'sharellbranch@ibmcom', '+1 610 123 4744', 121); INSERT INTO `contacts` VALUES (122, 'Eleanor', 'Farley', 'eleanorfarley@valerocom', '+1 215 123 4745', 122); INSERT INTO `contacts` VALUES (123, 'Justina', 'Hayes', 'justinahayes@antheminccom', '+1 717 123 4746', 123); INSERT INTO `contacts` VALUES (124, 'Omer', 'Macdonald', 'omermacdonald@pgcom', '+1 215 123 4748', 124); INSERT INTO `contacts` VALUES (125, 'Roseline', 'Hill', 'roselinehill@airproductscom', '+1 717 123 4752', 125); INSERT INTO `contacts` VALUES (126, 'Janeen', 'Holt', 'janeenholt@statefarmcom', '+1 412 123 4763', 126); INSERT INTO `contacts` VALUES (127, 'Tory', 'Avila', 'toryavila@googlecom', '+1 814 123 4766', 127); INSERT INTO `contacts` VALUES (128, 'Keila', 'Slater', 'keilaslater@comcastcorporationcom', '+1 412 123 4767', 128); INSERT INTO `contacts` VALUES (129, 'Jazmin', 'Burch', 'jazminburch@targetcom', '+1 215 123 4768', 129); INSERT INTO `contacts` VALUES (130, 'Tandy', 'Ramsey', 'tandyramsey@wnrcom', '+1 215 123 4771', 130); INSERT INTO `contacts` VALUES (131, 'Debra', 'Herring', 'debraherring@jnjcom', '+1 301 123 4794', 131); INSERT INTO `contacts` VALUES (132, 'Monnie', 'Walker', 'monniewalker@metlifecom', '+1 410 123 4795', 132); INSERT INTO `contacts` VALUES (133, 'Alvaro', 'Hooper', 'alvarohooper@admcom', '+1 410 123 4800', 133); INSERT INTO `contacts` VALUES (134, 'Leandro', 'West', 'leandrowest@marathonpetroleumcom', '+1 410 123 4805', 134); INSERT INTO `contacts` VALUES (135, 'Lurline', 'Dennis', 'lurlinedennis@freddiemaccom', '+1 410 012 4715', 135); INSERT INTO `contacts` VALUES (136, 'Aurea', 'Sanders', 'aureasanders@pepsicocom', '+1 301 123 4809', 136); INSERT INTO `contacts` VALUES (137, 'Stacia', 'Rutledge', 'staciarutledge@utccom', '+1 410 123 4812', 137); INSERT INTO `contacts` VALUES (138, 'Philomena', 'Elliott', 'philomenaelliott@aetnacom', '+1 410 123 4813', 138); INSERT INTO `contacts` VALUES (139, 'Gonzalo', 'Stone', 'gonzalostone@lowescom', '+1 301 123 4814', 139); INSERT INTO `contacts` VALUES (140, 'So', 'Hardin', 'sohardin@upscom', '+1 410 123 4816', 140); INSERT INTO `contacts` VALUES (141, 'Lauren', 'Rodriquez', 'laurenrodriquez@aigcom', '+1 410 123 4817', 141); INSERT INTO `contacts` VALUES (142, 'Loan', 'Patton', 'loanpatton@prudentialcom', '+1 301 123 4818', 142); INSERT INTO `contacts` VALUES (143, 'Ha', 'Lowe', 'halowe@intelcom', '+1 301 123 4819', 143); INSERT INTO `contacts` VALUES (144, 'Alexandra', 'Mcgowan', 'alexandramcgowan@humanacom', '+1 410 123 4822', 144); INSERT INTO `contacts` VALUES (145, 'Melissa', 'Nichols', 'melissanichols@disneycom', '+1 410 123 4840', 145); INSERT INTO `contacts` VALUES (146, 'Keesha', 'Cohen', 'keeshacohen@ciscocom', '+1 414 123 4363', 146); INSERT INTO `contacts` VALUES (147, 'Elvera', 'Benson', 'elverabenson@pfizercom', '+1 507 123 4387', 147); INSERT INTO `contacts` VALUES (148, 'Lanora', 'Ray', 'lanoraray@dowcom', '+1 612 123 4436', 148); INSERT INTO `contacts` VALUES (149, 'Jimmy', 'Weber', 'jimmyweber@syscocom', '+1 219 123 4145', 149); INSERT INTO `contacts` VALUES (150, 'Mae', 'Wilkinson', 'maewilkinson@fedexcom', '+1 616 123 4190', 150); INSERT INTO `contacts` VALUES (151, 'Lino', 'Noble', 'linonoble@caterpillarcom', '+1 313 123 4241', 151); INSERT INTO `contacts` VALUES (152, 'Kathie', 'Jordan', 'kathiejordan@lockheedmartincom', '+1 616 123 4259', 152); INSERT INTO `contacts` VALUES (153, 'Heike', 'Emerson', 'heikeemerson@newyorklifecom', '+1 319 123 4269', 153); INSERT INTO `contacts` VALUES (154, 'Princess', 'Jones', 'princessjones@uhsinccom', '+1 712 123 4284', 154); INSERT INTO `contacts` VALUES (155, 'Doretha', 'Tyler', 'dorethatyler@coca-colacompanycom', '+1 712 123 4289', 155); INSERT INTO `contacts` VALUES (156, 'Emilio', 'Duncan', 'emilioduncan@hcahealthcarecom', '+1 414 123 4312', 156); INSERT INTO `contacts` VALUES (157, 'Glinda', 'Lambert', 'glindalambert@ingrammicrocom', '+1 414 123 4364', 157); INSERT INTO `contacts` VALUES (158, 'Emery', 'Schneider', 'emeryschneider@owens-minorcom', '+1 320 123 4385', 158); INSERT INTO `contacts` VALUES (159, 'Amado', 'Jefferson', 'amadojefferson@energytransfercom', '+1 612 123 4407', 159); INSERT INTO `contacts` VALUES (160, 'Hisako', 'Herrera', 'hisakoherrera@tysonfoodscom', '+1 716 123 4456', 160); INSERT INTO `contacts` VALUES (161, 'Jamee', 'Mclaughlin', 'jameemclaughlin@aacom', '+1 716 123 4582', 161); INSERT INTO `contacts` VALUES (162, 'Audrie', 'Cannon', 'audriecannon@deltacom', '+1 716 123 4627', 162); INSERT INTO `contacts` VALUES (163, 'Lacey', 'Walters', 'laceywalters@chartercom', '+1 412 123 4677', 163); INSERT INTO `contacts` VALUES (164, 'Weldon', 'Robinson', 'weldonrobinson@nationwidecom', '+1 215 123 4702', 164); INSERT INTO `contacts` VALUES (165, 'Solange', 'Gates', 'solangegates@johnsoncontrolscom', '+1 215 123 4749', 165); INSERT INTO `contacts` VALUES (166, 'Jame', 'Calhoun', 'jamecalhoun@bestbuycom', '+1 814 123 4755', 166); INSERT INTO `contacts` VALUES (167, 'Stefan', 'Walters', 'stefanwalters@merckcom', '+1 301 123 4831', 167); INSERT INTO `contacts` VALUES (168, 'Arlene', 'Elliott', 'arleneelliott@advanceautopartscom', '+1 313 123 4167', 168); INSERT INTO `contacts` VALUES (169, 'Sofia', 'Burnett', 'sofiaburnett@libertymutualcom', '+1 219 123 4116', 169); INSERT INTO `contacts` VALUES (170, 'Christal', 'Grant', 'christalgrant@gscom', '+1 616 123 4166', 170); INSERT INTO `contacts` VALUES (171, 'Violeta', 'Stokes', 'violetastokes@honeywellcom', '+1 810 123 4212', 171); INSERT INTO `contacts` VALUES (172, 'Jackeline', 'Finley', 'jackelinefinley@mastercardcom', '+1 313 123 4240', 172); INSERT INTO `contacts` VALUES (173, 'Heidy', 'Massey', 'heidymassey@massmutualcom', '+1 414 123 4340', 173); INSERT INTO `contacts` VALUES (174, 'Yolando', 'Wilkerson', 'yolandowilkerson@oraclecom', '+1 716 123 4485', 174); INSERT INTO `contacts` VALUES (175, 'Lucinda', 'Hurley', 'lucindahurley@morganstanleycom', '+1 518 123 4532', 175); INSERT INTO `contacts` VALUES (176, 'Gita', 'Logan', 'gitalogan@cignacom', '+1 518 123 4562', 176); INSERT INTO `contacts` VALUES (177, 'Felicita', 'Alston', 'felicitaalston@unitedcontinentalholdingscom', '+1 315 123 4585', 177); INSERT INTO `contacts` VALUES (178, 'Lela', 'Ewing', 'lelaewing@allstatecom', '+1 412 123 4659', 178); INSERT INTO `contacts` VALUES (179, 'Gabriel', 'Pollard', 'gabrielpollard@tiaaorg', '+1 717 123 4679', 179); INSERT INTO `contacts` VALUES (180, 'Vincenza', 'Walton', 'vincenzawalton@intlfcstonecom', '+1 215 123 4709', 180); INSERT INTO `contacts` VALUES (181, 'Shandra', 'Higgins', 'shandrahiggins@chsinccom', '+1 215 123 4751', 181); INSERT INTO `contacts` VALUES (182, 'Thomasena', 'Pickett', 'thomasenapickett@americanexpresscom', '+1 410 123 4807', 182); INSERT INTO `contacts` VALUES (183, 'Aaron', 'Holder', 'aaronholder@gileadcom', '+1 410 123 4829', 183); INSERT INTO `contacts` VALUES (184, 'Carlos', 'Moody', 'carlosmoody@publixcom', '+86 811 012 4093', 184); INSERT INTO `contacts` VALUES (185, 'Javier', 'Kim', 'javierkim@generaldynamicscom', '+86 123 012 4095', 185); INSERT INTO `contacts` VALUES (186, 'Fran', 'Battle', 'franbattle@tjxcom', '+91 80 012 4123', 186); INSERT INTO `contacts` VALUES (187, 'Shelia', 'Brewer', 'sheliabrewer@conocophillipscom', '+49 89 012 4129', 187); INSERT INTO `contacts` VALUES (188, 'Jeri', 'Randall', 'jerirandall@nikecom', '+49 90 012 4131', 188); INSERT INTO `contacts` VALUES (189, 'Jermaine', 'Cote', 'jermainecote@wfscorpcom', '+49 91 012 4133', 189); INSERT INTO `contacts` VALUES (190, 'Kenneth', 'Simmons', 'kennethsimmons@3mcom', '+39 6 012 4543', 190); INSERT INTO `contacts` VALUES (191, 'Dulce', 'Matthews', 'dulcematthews@mondelezinternationalcom', '+1 416 012 4147', 191); INSERT INTO `contacts` VALUES (192, 'Kristle', 'Cain', 'kristlecain@exeloncorpcom', '+39 55 012 4547', 192); INSERT INTO `contacts` VALUES (193, 'Erika', 'Murray', 'erikamurray@21cfcom', '+39 55 012 4551', 193); INSERT INTO `contacts` VALUES (194, 'Maud', 'Cohen', 'maudcohen@johndeerecom', '+39 55 012 4555', 194); INSERT INTO `contacts` VALUES (195, 'Rolanda', 'Vang', 'rolandavang@appliedmaterialscom', '+39 10 012 4365', 195); INSERT INTO `contacts` VALUES (196, 'Renea', 'Carney', 'reneacarney@dupontcom', '+39 55 012 4565', 196); INSERT INTO `contacts` VALUES (197, 'Sybil', 'Harding', 'sybilharding@avnetcom', '+39 10 012 4367', 197); INSERT INTO `contacts` VALUES (198, 'Colette', 'Estrada', 'coletteestrada@eastmancom', '+81 565 012 4567', 198); INSERT INTO `contacts` VALUES (199, 'Maximo', 'Ortega', 'maximoortega@macysinccom', '+39 10 012 4369', 199); INSERT INTO `contacts` VALUES (200, 'Kina', 'Larsen', 'kinalarsen@enterpriseproductscom', '+39 55 012 4569', 200); INSERT INTO `contacts` VALUES (201, 'Jarvis', 'Allison', 'jarvisallison@travelerscom', '+39 10 012 4371', 201); INSERT INTO `contacts` VALUES (202, 'Collene', 'Newton', 'collenenewton@sonicautomotivecom', '+39 49 012 4373', 202); INSERT INTO `contacts` VALUES (203, 'Vella', 'Hancock', 'vellahancock@pmicom', '+39 49 012 4375', 203); INSERT INTO `contacts` VALUES (204, 'Retta', 'Martinez', 'rettamartinez@riteaidcom', '+39 49 012 4377', 204); INSERT INTO `contacts` VALUES (205, 'Annelle', 'Lawrence', 'annellelawrence@techdatacom', '+39 10 012 4379', 205); INSERT INTO `contacts` VALUES (206, 'Sherron', 'Simon', 'sherronsimon@allycom', '+39 10 012 4381', 206); INSERT INTO `contacts` VALUES (207, 'Carita', 'Mcintyre', 'caritamcintyre@northwesternmutualcom', '+86 10 012 4165', 207); INSERT INTO `contacts` VALUES (208, 'Stephaine', 'Booker', 'stephainebooker@tsocorpcom', '+39 55 012 4559', 208); INSERT INTO `contacts` VALUES (209, 'Emilie', 'Parsons', 'emilieparsons@timewarnercom', '+39 10 012 4363', 209); INSERT INTO `contacts` VALUES (210, 'Jaleesa', 'Bowen', 'jaleesabowen@cstbrandscom', '+66 76 012 4633', 210); INSERT INTO `contacts` VALUES (211, 'Jeannie', 'Poole', 'jeanniepoole@aboutmcdonaldscom', '+91 80 012 4637', 211); INSERT INTO `contacts` VALUES (212, 'Adrienne', 'Lang', 'adriennelang@qualcommcom', '+39 2 012 4771', 212); INSERT INTO `contacts` VALUES (213, 'Jess', 'Nguyen', 'jessnguyen@searsholdingscom', '+39 2 012 4773', 213); INSERT INTO `contacts` VALUES (214, 'Tandy', 'House', 'tandyhouse@ebaycom', '+39 2 012 4775', 214); INSERT INTO `contacts` VALUES (215, 'Herman', 'Stokes', 'hermanstokes@capitalonecom', '+39 49 012 4777', 215); INSERT INTO `contacts` VALUES (216, 'Keesha', 'Lambert', 'keeshalambert@emccom', '+39 49 012 4779', 216); INSERT INTO `contacts` VALUES (217, 'Lauren', 'Williamson', 'laurenwilliamson@usaacom', '+39 49 012 4781', 217); INSERT INTO `contacts` VALUES (218, 'Lucius', 'Abbott', 'luciusabbott@lennarcom', '+91 80 012 4783', 218); INSERT INTO `contacts` VALUES (219, 'Beatrice', 'Ford', 'beatriceford@duke-energycom', '+91 80 012 4785', 219); INSERT INTO `contacts` VALUES (220, 'Tamisha', 'Vargas', 'tamishavargas@twccom', '+91 80 012 4793', 220); INSERT INTO `contacts` VALUES (221, 'Dick', 'Lamb', 'dicklamb@halliburtoncom', '+91 80 012 4803', 221); INSERT INTO `contacts` VALUES (222, 'Yolanda', 'Ball', 'yolandaball@gamestopcorpcom', '+91 80 012 4809', 222); INSERT INTO `contacts` VALUES (223, 'Jerica', 'Brooks', 'jericabrooks@northropgrummancom', '+91 11 012 4811', 223); INSERT INTO `contacts` VALUES (224, 'Nichol', 'Carter', 'nicholcarter@arrowcom', '+91 11 012 4813', 224); INSERT INTO `contacts` VALUES (225, 'Bobby', 'Wilson', 'bobbywilson@rsaccom', '+91 11 012 4817', 225); INSERT INTO `contacts` VALUES (226, 'Eve', 'Saunders', 'evesaunders@officedepotcom', '+91 80 012 4823', 226); INSERT INTO `contacts` VALUES (227, 'Ginger', 'Atkinson', 'gingeratkinson@nordstromcom', '+91 33 012 4825', 227); INSERT INTO `contacts` VALUES (228, 'Kenton', 'Harrell', 'kentonharrell@kindermorgancom', '+91 33 012 4827', 228); INSERT INTO `contacts` VALUES (229, 'Misti', 'Velazquez', 'mistivelazquez@aramarkcom', '+91 80 012 4829', 229); INSERT INTO `contacts` VALUES (230, 'Brandie', 'Buchanan', 'brandiebuchanan@davitacom', '+91 22 012 4831', 230); INSERT INTO `contacts` VALUES (231, 'Kandi', 'Holden', 'kandiholden@molinahealthcarecom', '+91 80 012 4833', 231); INSERT INTO `contacts` VALUES (232, 'Lashonda', 'Cunningham', 'lashondacunningham@wellcarecom', '+91 11 012 4835', 232); INSERT INTO `contacts` VALUES (233, 'Roxanne', 'Michalkow', 'roxannemichalkow@cbscorporationcom', '+91 172 012 4837', 233); INSERT INTO `contacts` VALUES (234, 'Phuong', 'Sanders', 'phuongsanders@visacom', '+91 22 012 4839', 234); INSERT INTO `contacts` VALUES (235, 'Vida', 'Kline', 'vidakline@lfgcom', '+91 80 012 4841', 235); INSERT INTO `contacts` VALUES (236, 'Mayola', 'Houston', 'mayolahouston@ecolabcom', '+91 80 012 4843', 236); INSERT INTO `contacts` VALUES (237, 'Cristine', 'Bell', 'cristinebell@kelloggcompanycom', '+91 11 012 4851', 237); INSERT INTO `contacts` VALUES (238, 'Shamika', 'Bauer', 'shamikabauer@chrobinsoncom', '+91 11 012 4853', 238); INSERT INTO `contacts` VALUES (239, 'Rebbeca', 'Day', 'rebbecaday@textroncom', '+91 172 012 4861', 239); INSERT INTO `contacts` VALUES (240, 'Maryrose', 'Cain', 'maryrosecain@loewscom', '+91 80 012 4869', 240); INSERT INTO `contacts` VALUES (241, 'Johnie', 'Rojas', 'johnierojas@itwcom', '+91 80 012 4887', 241); INSERT INTO `contacts` VALUES (242, 'Verla', 'Christian', 'verlachristian@synnexcom', '+91 80 012 4889', 242); INSERT INTO `contacts` VALUES (243, 'Teressa', 'Hewitt', 'teressahewitt@hormelfoodscom', '+91 80 012 4891', 243); INSERT INTO `contacts` VALUES (244, 'Shenna', 'Blair', 'shennablair@viacomcom', '+91 141 012 4895', 244); INSERT INTO `contacts` VALUES (245, 'Latoyia', 'Burt', 'latoyiaburt@hollyfrontiercom', '+91 80 012 4907', 245); INSERT INTO `contacts` VALUES (246, 'Shaquita', 'Norman', 'shaquitanorman@landolakesinccom', '+91 80 012 4919', 246); INSERT INTO `contacts` VALUES (247, 'Myrna', 'Romero', 'myrnaromero@celgenecom', '+91 80 012 4931', 247); INSERT INTO `contacts` VALUES (248, 'Bill', 'Stein', 'billstein@devonenergycom', '+39 6 012 4501', 248); INSERT INTO `contacts` VALUES (249, 'Olivia', 'Conrad', 'oliviaconrad@pbfenergycom', '+39 6 012 4503', 249); INSERT INTO `contacts` VALUES (250, 'Marianne', 'Bryant', 'mariannebryant@genworthcom', '+39 6 012 4507', 250); INSERT INTO `contacts` VALUES (251, 'Dustin', 'Paul', 'dustinpaul@yumcom', '+39 6 012 4511', 251); INSERT INTO `contacts` VALUES (252, 'Elroy', 'Wolf', 'elroywolf@ticom', '+39 6 012 4515', 252); INSERT INTO `contacts` VALUES (253, 'Jadwiga', 'Morrison', 'jadwigamorrison@cdwcom', '+39 6 012 4519', 253); INSERT INTO `contacts` VALUES (254, 'Isabella', 'Ortega', 'isabellaortega@paypalcom', '+39 6 012 4531', 254); INSERT INTO `contacts` VALUES (255, 'Katia', 'Case', 'katiacase@wmcom', '+39 6 012 4535', 255); INSERT INTO `contacts` VALUES (256, 'Enriqueta', 'Odom', 'enriquetaodom@mmccom', '+39 6 012 4539', 256); INSERT INTO `contacts` VALUES (257, 'Don', 'Hansen', 'donhansen@chkcom', '+39 10 012 4385', 257); INSERT INTO `contacts` VALUES (258, 'Herb', 'Sloan', 'herbsloan@pricelinegroupcom', '+39 10 012 4387', 258); INSERT INTO `contacts` VALUES (259, 'Blanche', 'Robbins', 'blancherobbins@parkercom', '+39 6 012 4389', 259); INSERT INTO `contacts` VALUES (260, 'Gaynell', 'Burton', 'gaynellburton@oxycom', '+39 6 012 4391', 260); INSERT INTO `contacts` VALUES (261, 'Marhta', 'Baldwin', 'marhtabaldwin@guardianlifecom', '+39 49 012 4409', 261); INSERT INTO `contacts` VALUES (262, 'Peter', 'Gamble', 'petergamble@mgmresortscom', '+39 49 012 4411', 262); INSERT INTO `contacts` VALUES (263, 'Nathan', 'Callahan', 'nathancallahan@farmerscom', '+39 10 012 4413', 263); INSERT INTO `contacts` VALUES (264, 'Tereasa', 'Padilla', 'tereasapadilla@jcpenneycom', '+39 49 012 4415', 264); INSERT INTO `contacts` VALUES (265, 'Merrilee', 'Phillips', 'merrileephillips@conedisoncom', '+39 49 012 4417', 265); INSERT INTO `contacts` VALUES (266, 'Tisha', 'Mcdonald', 'tishamcdonald@autolivcom', '+39 49 012 4419', 266); INSERT INTO `contacts` VALUES (267, 'Napoleon', 'Cruz', 'napoleoncruz@cognizantcom', '+39 10 012 4421', 267); INSERT INTO `contacts` VALUES (268, 'Basilia', 'Downs', 'basiliadowns@vfccom', '+66 76 012 4441', 268); INSERT INTO `contacts` VALUES (269, 'Alessandra', 'Estrada', 'alessandraestrada@ameriprisecom', '+41 56 012 3527', 269); INSERT INTO `contacts` VALUES (270, 'Sherron', 'Flores', 'sherronflores@fnfcom', '+41 57 012 3529', 270); INSERT INTO `contacts` VALUES (271, 'Elicia', 'Townsend', 'eliciatownsend@csccom', '+41 58 012 3531', 271); INSERT INTO `contacts` VALUES (272, 'Percy', 'Hernandez', 'percyhernandez@lbcom', '+41 59 012 3533', 272); INSERT INTO `contacts` VALUES (273, 'Shelia', 'Cain', 'sheliacain@jacobscom', '+41 60 012 3535', 273); INSERT INTO `contacts` VALUES (274, 'Charlene', 'Booker', 'charlenebooker@republicservicescom', '+41 61 012 3537', 274); INSERT INTO `contacts` VALUES (275, 'Mac', 'Mckay', 'macmckay@principalcom', '+41 62 012 3539', 275); INSERT INTO `contacts` VALUES (276, 'Jamison', 'Merritt', 'jamisonmerritt@rossstorescom', '+41 63 012 3541', 276); INSERT INTO `contacts` VALUES (277, 'Quinton', 'Woods', 'quintonwoods@bedbathandbeyondcom', '+41 64 012 3543', 277); INSERT INTO `contacts` VALUES (278, 'Cathey', 'Mcdowell', 'catheymcdowell@csxcom', '+41 65 012 3545', 278); INSERT INTO `contacts` VALUES (279, 'Deneen', 'Hays', 'deneenhays@toysrusinccom', '+41 66 012 3547', 279); INSERT INTO `contacts` VALUES (280, 'Jackson', 'Morin', 'jacksonmorin@sandscom', '+41 67 012 3549', 280); INSERT INTO `contacts` VALUES (281, 'Margo', 'Hoffman', 'margohoffman@leucadiacom', '+41 2 012 3551', 281); INSERT INTO `contacts` VALUES (282, 'Adah', 'Myers', 'adahmyers@domcom', '+41 3 012 3553', 282); INSERT INTO `contacts` VALUES (283, 'Florene', 'Craig', 'florenecraig@ussteelcom', '+41 81 012 3555', 283); INSERT INTO `contacts` VALUES (284, 'Janey', 'Burris', 'janeyburris@l-3comcom', '+41 81 012 3557', 284); INSERT INTO `contacts` VALUES (285, 'Evelina', 'Campbell', 'evelinacampbell@edisoninvestorcom', '+41 71 012 3559', 285); INSERT INTO `contacts` VALUES (286, 'Thi', 'Maxwell', 'thimaxwell@entergycom', '+41 71 012 3561', 286); INSERT INTO `contacts` VALUES (287, 'Aleshia', 'Reese', 'aleshiareese@adpcom', '+41 4 012 3563', 287); INSERT INTO `contacts` VALUES (288, 'Dorotha', 'Wong', 'dorothawong@firstdatacom', '+41 6 012 3565', 288); INSERT INTO `contacts` VALUES (289, 'Estela', 'Donovan', 'esteladonovan@blackrockcom', '+41 7 012 3567', 289); INSERT INTO `contacts` VALUES (290, 'Hassan', 'Rivers', 'hassanrivers@westrockcom', '+41 31 012 3569', 290); INSERT INTO `contacts` VALUES (291, 'Jen', 'Mcmahon', 'jenmcmahon@voyacom', '+41 68 012 3571', 291); INSERT INTO `contacts` VALUES (292, 'Barbie', 'Carter', 'barbiecarter@sherwincom', '+41 5 012 3573', 292); INSERT INTO `contacts` VALUES (293, 'Cleo', 'English', 'cleoenglish@hiltonworldwidecom', '+41 8 012 3575', 293); INSERT INTO `contacts` VALUES (294, 'Liana', 'Pena', 'lianapena@corningcom', '+41 1 012 3577', 294); INSERT INTO `contacts` VALUES (295, 'Francina', 'Slater', 'francinaslater@rrdonnelleycom', '+41 9 012 3579', 295); INSERT INTO `contacts` VALUES (296, 'Josie', 'Steele', 'josiesteele@stanleyblackanddeckercom', '+41 69 012 3581', 296); INSERT INTO `contacts` VALUES (297, 'Maryrose', 'Roberson', 'maryroseroberson@xcelenergycom', '+41 70 012 3583', 297); INSERT INTO `contacts` VALUES (298, 'Elly', 'Salinas', 'ellysalinas@kiewitcom', '+91 80 012 3687', 298); INSERT INTO `contacts` VALUES (299, 'Ginny', 'Carlson', 'ginnycarlson@oratemurphyusacom', '+91 80 012 3689', 299); INSERT INTO `contacts` VALUES (300, 'Mozelle', 'Schneider', 'mozelleschneider@cbrecom', '+91 80 012 3695', 300); INSERT INTO `contacts` VALUES (301, 'Adam', 'Jacobs', 'adamjacobs@univarcom', '+91 80 012 3699', 301); INSERT INTO `contacts` VALUES (302, 'Vernia', 'Hayes', 'verniahayes@drhortoncom', '+91 80 012 3701', 302); INSERT INTO `contacts` VALUES (303, 'Ismael', 'Solomon', 'ismaelsolomon@elcompaniescom', '+91 80 012 3703', 303); INSERT INTO `contacts` VALUES (304, 'Ivey', 'Rutledge', 'iveyrutledge@praxaircom', '+91 80 012 3709', 304); INSERT INTO `contacts` VALUES (305, 'Jame', 'Terrell', 'jameterrell@biogencom', '+91 80 012 3711', 305); INSERT INTO `contacts` VALUES (306, 'Daina', 'Combs', 'dainacombs@mosaiccocom', '+91 80 012 3715', 306); INSERT INTO `contacts` VALUES (307, 'Lashunda', 'Davidson', 'lashundadavidson@statestreetcom', '+91 80 012 3717', 307); INSERT INTO `contacts` VALUES (308, 'Arlette', 'Thornton', 'arlettethornton@unumcom', '+91 80 012 3719', 308); INSERT INTO `contacts` VALUES (309, 'Darron', 'Robertson', 'darronrobertson@reynoldsamericancom', '+91 80 012 3723', 309); INSERT INTO `contacts` VALUES (310, 'Maple', 'Barnett', 'maplebarnett@core-markcom', '+91 80 012 3725', 310); INSERT INTO `contacts` VALUES (311, 'Charlsie', 'Carey', 'charlsiecarey@group1autocom', '+91 80 012 3731', 311); INSERT INTO `contacts` VALUES (312, 'Frank', 'Shannon', 'frankshannon@henryscheincom', '+91 80 012 3733', 312); INSERT INTO `contacts` VALUES (313, 'Josiah', 'Beasley', 'josiahbeasley@hertzcom', '+91 80 012 3735', 313); INSERT INTO `contacts` VALUES (314, 'Annabelle', 'Butler', 'annabellebutler@thriventcom', '+91 80 012 3737', 314); INSERT INTO `contacts` VALUES (315, 'Ed', 'Mueller', 'edmueller@nscorpcom', '+91 80 012 3739', 315); INSERT INTO `contacts` VALUES (316, 'Colleen', 'Estrada', 'colleenestrada@rgarecom', '+91 80 012 3741', 316); INSERT INTO `contacts` VALUES (317, 'Nikia', 'Kent', 'nikiakent@psegcom', '+91 80 012 3745', 317); INSERT INTO `contacts` VALUES (318, 'Amber', 'Brady', 'amberbrady@c-a-mcom', '+91 80 012 3837', 318); INSERT INTO `contacts` VALUES (319, 'Wendell', 'Massey', 'wendellmassey@bbtcom', '+86 10 012 3839', 319); -- ---------------------------- -- Table structure for countries -- ---------------------------- DROP TABLE IF EXISTS `countries`; CREATE TABLE `countries` ( `country_id` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `country_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `region_id` smallint NOT NULL, PRIMARY KEY (`country_id`) USING BTREE, INDEX `fk_countries_region`(`region_id` ASC) USING BTREE, CONSTRAINT `fk_countries_region` FOREIGN KEY (`region_id`) REFERENCES `regions` (`region_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of countries -- ---------------------------- INSERT INTO `countries` VALUES ('AR', 'Argentina', 2); INSERT INTO `countries` VALUES ('AU', 'Australia', 3); INSERT INTO `countries` VALUES ('BE', 'Belgium', 1); INSERT INTO `countries` VALUES ('BR', 'Brazil', 2); INSERT INTO `countries` VALUES ('CA', 'Canada', 2); INSERT INTO `countries` VALUES ('CH', 'Switzerland', 1); INSERT INTO `countries` VALUES ('CN', 'China', 3); INSERT INTO `countries` VALUES ('DE', 'Germany', 1); INSERT INTO `countries` VALUES ('DK', 'Denmark', 1); INSERT INTO `countries` VALUES ('EG', 'Egypt', 4); INSERT INTO `countries` VALUES ('FR', 'France', 1); INSERT INTO `countries` VALUES ('IL', 'Israel', 4); INSERT INTO `countries` VALUES ('IN', 'India', 3); INSERT INTO `countries` VALUES ('IT', 'Italy', 1); INSERT INTO `countries` VALUES ('JP', 'Japan', 3); INSERT INTO `countries` VALUES ('KW', 'Kuwait', 4); INSERT INTO `countries` VALUES ('ML', 'Malaysia', 3); INSERT INTO `countries` VALUES ('MX', 'Mexico', 2); INSERT INTO `countries` VALUES ('NG', 'Nigeria', 4); INSERT INTO `countries` VALUES ('NL', 'Netherlands', 1); INSERT INTO `countries` VALUES ('SG', 'Singapore', 3); INSERT INTO `countries` VALUES ('UK', 'United Kingdom', 1); INSERT INTO `countries` VALUES ('US', 'United States of America', 2); INSERT INTO `countries` VALUES ('ZM', 'Zambia', 4); INSERT INTO `countries` VALUES ('ZW', 'Zimbabwe', 4); -- ---------------------------- -- Table structure for customers -- ---------------------------- DROP TABLE IF EXISTS `customers`; CREATE TABLE `customers` ( `customer_id` smallint NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `credit_limit` decimal(8, 2) NULL DEFAULT NULL, PRIMARY KEY (`customer_id`) USING BTREE, UNIQUE INDEX `uni_idx_website`(`website` ASC) USING BTREE, INDEX `index_name`(`name` ASC) USING BTREE, INDEX `comb_idx_name_addr`(`name` ASC, `address` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of customers -- ---------------------------- INSERT INTO `customers` VALUES (1, 'Raytheon', '514 W Superior St, Kokomo, IN', 'http://wwwraytheoncom', 100.00); INSERT INTO `customers` VALUES (2, 'Plains GP Holdings', '2515 Bloyd Ave, Indianapolis, IN', 'http://wwwplainsallamericancom', 100.00); INSERT INTO `customers` VALUES (3, 'US Foods Holding', '8768 N State Rd 37, Bloomington, IN', 'http://wwwusfoodscom', 100.00); INSERT INTO `customers` VALUES (4, 'AbbVie', '6445 Bay Harbor Ln, Indianapolis, IN', 'http://wwwabbviecom', 100.00); INSERT INTO `customers` VALUES (5, 'Centene', '4019 W 3Rd St, Bloomington, IN', 'http://wwwcentenecom', 100.00); INSERT INTO `customers` VALUES (6, 'Community Health Systems', '1608 Portage Ave, South Bend, IN', 'http://wwwchsnet', 100.00); INSERT INTO `customers` VALUES (7, 'Alcoa', '23943 Us Highway 33, Elkhart, IN', 'http://wwwalcoacom', 100.00); INSERT INTO `customers` VALUES (8, 'International Paper', '136 E Market St # 800, Indianapolis, IN', 'http://wwwinternationalpapercom', 100.00); INSERT INTO `customers` VALUES (9, 'Emerson Electric', '1905 College St, South Bend, IN', 'http://wwwemersoncom', 100.00); INSERT INTO `customers` VALUES (10, 'Union Pacific', '3512 Rockville Rd # 137C, Indianapolis, IN', 'http://wwwupcom', 200.00); INSERT INTO `customers` VALUES (11, 'Amgen', '1303 E University St, Bloomington, IN', 'http://wwwamgencom', 200.00); INSERT INTO `customers` VALUES (12, 'US Bancorp', '115 N Weinbach Ave, Evansville, IN', 'http://wwwusbankcom', 200.00); INSERT INTO `customers` VALUES (13, 'Staples', '2067 Rollett Ln, Evansville, IN', 'http://wwwstaplescom', 200.00); INSERT INTO `customers` VALUES (14, 'Danaher', '1105 E Allendale Dr, Bloomington, IN', 'http://wwwdanahercom', 200.00); INSERT INTO `customers` VALUES (15, 'Whirlpool', '18305 Van Dyke St, Detroit, MI', 'http://wwwwhirlpoolcorpcom', 200.00); INSERT INTO `customers` VALUES (16, 'Aflac', 'Lucas Dr Bldg 348, Detroit, MI', 'http://wwwaflaccom', 200.00); INSERT INTO `customers` VALUES (17, 'AutoNation', '1801 Monroe Ave Nw, Grand Rapids, MI', 'http://wwwautonationcom', 200.00); INSERT INTO `customers` VALUES (18, 'Progressive', '4925 Kendrick St Se, Grand Rapids, MI', 'http://wwwprogressivecom', 200.00); INSERT INTO `customers` VALUES (19, 'Abbott Laboratories', '3310 Dixie Ct, Saginaw, MI', 'http://wwwabbottcom', 200.00); INSERT INTO `customers` VALUES (20, 'Dollar General', '113 Washington Sq N, Lansing, MI', 'http://wwwdollargeneralcom', 200.00); INSERT INTO `customers` VALUES (21, 'Tenet Healthcare', '2500 S Pennsylvania Ave, Lansing, MI', 'http://wwwtenethealthcom', 200.00); INSERT INTO `customers` VALUES (22, 'Eli Lilly', '3213 S Cedar St, Lansing, MI', 'http://wwwlillycom', 200.00); INSERT INTO `customers` VALUES (23, 'DTE Energy', '8110 Jackson Rd, Ann Arbor, MI', 'http://wwwdteenergycom', 200.00); INSERT INTO `customers` VALUES (24, 'Southwest Airlines', '6654 W Lafayette St, Detroit, MI', 'http://wwwsouthwestcom', 200.00); INSERT INTO `customers` VALUES (25, 'Penske Automotive Group', '27 Benton Rd, Saginaw, MI', 'http://wwwpenskeautomotivecom', 200.00); INSERT INTO `customers` VALUES (26, 'ManpowerGroup', '8201 Livernois Ave, Detroit, MI', 'http://wwwmanpowergroupcom', 300.00); INSERT INTO `customers` VALUES (27, 'Assurant', '101 N Falahee Rd, Jackson, MI', 'http://wwwassurantcom', 300.00); INSERT INTO `customers` VALUES (28, 'Kohl?s', '3100 E Eisenhower Pky # 100, Ann Arbor, MI', 'http://wwwkohlscorporationcom', 300.00); INSERT INTO `customers` VALUES (29, 'Starbucks', '952 Vassar Dr, Kalamazoo, MI', 'http://wwwstarbuckscom', 400.00); INSERT INTO `customers` VALUES (30, 'Paccar', '150 W Jefferson Ave # 2500, Detroit, MI', 'http://wwwpaccarcom', 400.00); INSERT INTO `customers` VALUES (31, 'Cummins', '40 Pearl St Nw # 1020, Grand Rapids, MI', 'http://wwwcumminscom', 400.00); INSERT INTO `customers` VALUES (32, 'Global Partners', '1135 Catherine St, Ann Arbor, MI', 'http://wwwglobalpcom', 400.00); INSERT INTO `customers` VALUES (33, 'Altria Group', '301 E Genesee Ave, Saginaw, MI', 'http://wwwaltriacom', 400.00); INSERT INTO `customers` VALUES (34, 'Xerox', '9936 Dexter Ave, Detroit, MI', 'http://wwwxeroxcom', 400.00); INSERT INTO `customers` VALUES (35, 'Kimberly-Clark', '1660 University Ter, Ann Arbor, MI', 'http://wwwkimberly-clarkcom', 400.00); INSERT INTO `customers` VALUES (36, 'Hartford Financial Services Group', '15713 N East St, Lansing, MI', 'http://wwwthehartfordcom', 400.00); INSERT INTO `customers` VALUES (37, 'Huntsman', '555 John F Kennedy Rd, Dubuque, IA', 'http://wwwhuntsmancom', 500.00); INSERT INTO `customers` VALUES (38, 'Kraft Heinz', '10315 Hickman Rd, Des Moines, IA', 'http://wwwkraftheinzcompanycom', 500.00); INSERT INTO `customers` VALUES (39, 'Lear', '2115 N Towne Ln Ne, Cedar Rapids, IA', 'http://wwwlearcom', 500.00); INSERT INTO `customers` VALUES (40, 'Fluor', '1928 Sherwood Dr, Council Bluffs, IA', 'http://wwwfluorcom', 500.00); INSERT INTO `customers` VALUES (41, 'AECOM', '2102 E Kimberly Rd, Davenport, IA', 'http://wwwaecomcom', 500.00); INSERT INTO `customers` VALUES (42, 'Becton Dickinson', '1691 Asbury Rd, Dubuque, IA', 'http://wwwbdcom', 500.00); INSERT INTO `customers` VALUES (43, 'Facebook', '5112 Sw 9Th St, Des Moines, IA', 'http://wwwfacebookcom', 500.00); INSERT INTO `customers` VALUES (44, 'Jabil Circuit', '221 3Rd Ave Se # 300, Cedar Rapids, IA', 'http://wwwjabilcom', 500.00); INSERT INTO `customers` VALUES (45, 'CenturyLink', '2120 Heights Dr, Eau Claire, WI', 'http://wwwcenturylinkcom', 500.00); INSERT INTO `customers` VALUES (46, 'Supervalu', '8989 N Port Washington Rd, Milwaukee, WI', 'http://wwwsupervalucom', 500.00); INSERT INTO `customers` VALUES (47, 'General Mills', '6555 W Good Hope Rd, Milwaukee, WI', 'http://wwwgeneralmillscom', 600.00); INSERT INTO `customers` VALUES (48, 'Southern', '1314 N Stoughton Rd, Madison, WI', 'http://wwwsoutherncompanycom', 600.00); INSERT INTO `customers` VALUES (49, 'NextEra Energy', '4715 Sprecher Rd, Madison, WI', 'http://wwwnexteraenergycom', 600.00); INSERT INTO `customers` VALUES (50, 'Thermo Fisher Scientific', '6161 N 64Th St, Milwaukee, WI', 'http://wwwthermofishercom', 700.00); INSERT INTO `customers` VALUES (51, 'American Electric Power', '11016 W Lincoln Ave, Milwaukee, WI', 'http://wwwaepcom', 700.00); INSERT INTO `customers` VALUES (52, 'PG&E Corp.', '8600 W National Ave, Milwaukee, WI', 'http://wwwpgecom', 700.00); INSERT INTO `customers` VALUES (53, 'NGL Energy Partners', '615 N Sherman Ave, Madison, WI', 'http://wwwnglenergypartnerscom', 700.00); INSERT INTO `customers` VALUES (54, 'Bristol-Myers Squibb', '512 E Grand Ave, Beloit, WI', 'http://wwwbmscom', 700.00); INSERT INTO `customers` VALUES (55, 'Goodyear Tire & Rubber', '600 N Broadway Fl 1, Milwaukee, WI', 'http://wwwgoodyearcom', 700.00); INSERT INTO `customers` VALUES (56, 'Nucor', '5235 N Ironwood Ln, Milwaukee, WI', 'http://wwwnucorcom', 700.00); INSERT INTO `customers` VALUES (57, 'PNC Financial Services Group', '322 E Michigan St, Milwaukee, WI', 'http://wwwpnccom', 700.00); INSERT INTO `customers` VALUES (58, 'Health Net', '1400 Bellinger St Fl 4, Eau Claire, WI', 'http://wwwhealthnetcom', 700.00); INSERT INTO `customers` VALUES (59, 'Micron Technology', '411 E Wisconsin Ave # 2550, Milwaukee, WI', 'http://wwwmicroncom', 700.00); INSERT INTO `customers` VALUES (60, 'Colgate-Palmolive', '808 3Rd St # 100, Wausau, WI', 'http://wwwcolgatepalmolivecom', 700.00); INSERT INTO `customers` VALUES (61, 'Freeport-McMoRan', '300 Crooks St, Green Bay, WI', 'http://wwwfcxcom', 900.00); INSERT INTO `customers` VALUES (62, 'ConAgra Foods', '122 E Dayton St, Madison, WI', 'http://wwwconagrafoodscom', 900.00); INSERT INTO `customers` VALUES (63, 'Sempra Energy', '633 S Hawley Rd, Milwaukee, WI', 'http://wwwsempracom', 900.00); INSERT INTO `customers` VALUES (64, 'Gap', '2122 Campbell Rd, La Crosse, WI', 'http://wwwgapinccom', 1200.00); INSERT INTO `customers` VALUES (65, 'Baker Hughes', '3324 N Oakland Ave, Milwaukee, WI', 'http://wwwbakerhughescom', 1200.00); INSERT INTO `customers` VALUES (66, 'Bank of New York Mellon Corp.', '666 22Nd Ave Ne, Minneapolis, MN', 'http://wwwbnymelloncom', 1200.00); INSERT INTO `customers` VALUES (67, 'Dollar Tree', '1501 Lowry Ave N, Minneapolis, MN', 'http://wwwdollartreecom', 1200.00); INSERT INTO `customers` VALUES (68, 'AutoZone', '113 N 1St St, Minneapolis, MN', 'http://wwwautozonecom', 1200.00); INSERT INTO `customers` VALUES (69, 'Whole Foods Market', '4200 Yosemite Ave S, Minneapolis, MN', 'http://wwwwholefoodsmarketcom', 1200.00); INSERT INTO `customers` VALUES (70, 'PPG Industries', '2800 Chicago Ave # 100, Minneapolis, MN', 'http://wwwppgcom', 1200.00); INSERT INTO `customers` VALUES (71, 'Genuine Parts', '200 1St St Sw, Rochester, MN', 'http://wwwgenptcom', 1200.00); INSERT INTO `customers` VALUES (72, 'Icahn Enterprises', '314 W Superior St # 1015, Duluth, MN', 'http://wwwielpcom', 1200.00); INSERT INTO `customers` VALUES (73, 'Navistar International', '1409 Willow St # 600, Minneapolis, MN', 'http://wwwnavistarcom', 1200.00); INSERT INTO `customers` VALUES (74, 'Performance Food Group', '2720 Brewerton Rd, Syracuse, NY', 'http://wwwpfgccom', 1200.00); INSERT INTO `customers` VALUES (75, 'Omnicom Group', '2134 W Genesee St, Syracuse, NY', 'http://wwwomnicomgroupcom', 1200.00); INSERT INTO `customers` VALUES (76, 'DISH Network', '1522 Main St, Niagara Falls, NY', 'http://wwwdishcom', 1200.00); INSERT INTO `customers` VALUES (77, 'FirstEnergy', '49 N Pine Ave, Albany, NY', 'http://wwwfirstenergycorpcom', 1200.00); INSERT INTO `customers` VALUES (78, 'Precision Castparts', '726 Union St, Hudson, NY', 'http://wwwprecastcom', 1200.00); INSERT INTO `customers` VALUES (79, 'Monsanto', '137 Lark St, Albany, NY', 'http://wwwmonsantocom', 1200.00); INSERT INTO `customers` VALUES (80, 'AES', '33 Fulton St, Poughkeepsie, NY', 'http://wwwaescom', 1200.00); INSERT INTO `customers` VALUES (81, 'CarMax', '2360 Maxon Rd, Schenectady, NY', 'http://wwwcarmaxcom', 1200.00); INSERT INTO `customers` VALUES (82, 'Discover Financial Services', '85 High St, Buffalo, NY', 'http://wwwdiscoverfinancialcom', 1200.00); INSERT INTO `customers` VALUES (83, 'National Oilwell Varco', '1 Palisade Ave Fl 2, Yonkers, NY', 'http://wwwnovcom', 1200.00); INSERT INTO `customers` VALUES (84, 'NRG Energy', '500 S Salina St # 500, Syracuse, NY', 'http://wwwnrgenergycom', 1200.00); INSERT INTO `customers` VALUES (85, 'Western Digital', '33 Pine St, Lockport, NY', 'http://wwwwesterndigitalcom', 1200.00); INSERT INTO `customers` VALUES (86, 'Marriott International', 'Po Box 2152, Buffalo, NY', 'http://wwwmarriottcom', 1200.00); INSERT INTO `customers` VALUES (87, 'Liberty Interactive', '2979 Hamburg St, Schenectady, NY', 'http://wwwlibertyinteractivecom', 1200.00); INSERT INTO `customers` VALUES (88, 'Walmart', '1790 Grand Blvd, Schenectady, NY', 'http://wwwwalmartcom', 1200.00); INSERT INTO `customers` VALUES (89, 'Exxon Mobil', '7 Ingelside Ln, White Plains, NY', 'http://wwwexxonmobilcom', 1200.00); INSERT INTO `customers` VALUES (90, 'Apple', '18 Glenridge Rd, Schenectady, NY', 'http://wwwapplecom', 1200.00); INSERT INTO `customers` VALUES (91, 'Berkshire Hathaway', '6432 Rising Sun Ave, Philadelphia, PA', 'http://wwwberkshirehathawaycom', 1200.00); INSERT INTO `customers` VALUES (92, 'McKesson', 'Rr 10, Reading, PA', 'http://wwwmckessoncom', 1200.00); INSERT INTO `customers` VALUES (93, 'UnitedHealth Group', '2455 Rose Garden Rd, Pittsburgh, PA', 'http://wwwunitedhealthgroupcom', 1200.00); INSERT INTO `customers` VALUES (94, 'CVS Health', '1812 Timberline Rd, Altoona, PA', 'http://wwwcvshealthcom', 1200.00); INSERT INTO `customers` VALUES (95, 'General Motors', '141 Schiller St, Reading, PA', 'http://wwwgmcom', 1200.00); INSERT INTO `customers` VALUES (96, 'Ford Motor', '1126 Pawlings Rd, Norristown, PA', 'http://wwwfordcom', 1200.00); INSERT INTO `customers` VALUES (97, 'AT&T', '55 Church Hill Rd, Reading, PA', 'http://wwwattcom', 1200.00); INSERT INTO `customers` VALUES (98, 'General Electric', '354 N Prince St, Lancaster, PA', 'http://wwwgecom', 1200.00); INSERT INTO `customers` VALUES (99, 'AmerisourceBergen', '115 Chestnut St, Philadelphia, PA', 'http://wwwamerisourcebergencom', 1400.00); INSERT INTO `customers` VALUES (100, 'Verizon', '2899 Grand Ave, Pittsburgh, PA', 'http://wwwverizoncom', 1400.00); INSERT INTO `customers` VALUES (101, 'Chevron', 'Po Box 39, Indiana, PA', 'http://wwwchevroncom', 1400.00); INSERT INTO `customers` VALUES (102, 'Costco', '1604 Broadway Ave, Pittsburgh, PA', 'http://wwwcostcocom', 1400.00); INSERT INTO `customers` VALUES (103, 'Fannie Mae', '4734 Liberty Ave, Pittsburgh, PA', 'http://wwwfanniemaecom', 1400.00); INSERT INTO `customers` VALUES (104, 'Kroger', '21 Thornwood Rd, Harrisburg, PA', 'http://wwwthekrogercocom', 1400.00); INSERT INTO `customers` VALUES (105, 'Amazoncom', '3725 W Lake Rd, Erie, PA', 'http://wwwamazoncom', 1400.00); INSERT INTO `customers` VALUES (106, 'Walgreens Boots Alliance', '1808 4Th Ave, Altoona, PA', 'http://wwwwalgreensbootsalliancecom', 1400.00); INSERT INTO `customers` VALUES (107, 'HP', 'Station Sq, Pittsburgh, PA', 'http://wwwhpcom', 1400.00); INSERT INTO `customers` VALUES (108, 'Cardinal Health', '4020 Garden Ave, Erie, PA', 'http://wwwcardinalcom', 1400.00); INSERT INTO `customers` VALUES (109, 'Express Scripts Holding', '100 N Peach St, Philadelphia, PA', 'http://wwwexpress-scriptscom', 1400.00); INSERT INTO `customers` VALUES (110, 'JP Morgan Chase', '835 Heister Ln, Reading, PA', 'http://wwwjpmorganchasecom', 1400.00); INSERT INTO `customers` VALUES (111, 'WW Grainger', '378 S Negley Ave, Pittsburgh, PA', 'http://wwwgraingercom', 1500.00); INSERT INTO `customers` VALUES (112, 'Boeing', '5643 N 5Th St, Philadelphia, PA', 'http://wwwboeingcom', 1500.00); INSERT INTO `customers` VALUES (113, 'Microsoft', '1401 W Warren Rd, Bradford, PA', 'http://wwwmicrosoftcom', 1500.00); INSERT INTO `customers` VALUES (114, 'Bank of America Corp.', '815 Freeport Rd, Pittsburgh, PA', 'http://wwwbankofamericacom', 1500.00); INSERT INTO `customers` VALUES (115, 'Wells Fargo', '327 N Washington Ave # 300, Scranton, PA', 'http://wwwwellsfargocom', 1900.00); INSERT INTO `customers` VALUES (116, 'Baxter International', '810 Race St, Philadelphia, PA', 'http://wwwbaxtercom', 1900.00); INSERT INTO `customers` VALUES (117, 'Home Depot', '4901 Locust Ln, Harrisburg, PA', 'http://wwwhomedepotcom', 2300.00); INSERT INTO `customers` VALUES (118, 'Citigroup', '3376 Perrysville Ave, Pittsburgh, PA', 'http://wwwcitigroupcom', 2300.00); INSERT INTO `customers` VALUES (119, 'Phillips 66', '220 Penn Ave # 300, Scranton, PA', 'http://wwwphillips66com', 2300.00); INSERT INTO `customers` VALUES (120, 'Stryker', '135 S 18Th St # 1, Philadelphia, PA', 'http://wwwstrykercom', 2300.00); INSERT INTO `customers` VALUES (121, 'IBM', '522 Swede St, Norristown, PA', 'http://wwwibmcom', 2300.00); INSERT INTO `customers` VALUES (122, 'Valero Energy', '7708 City Ave, Philadelphia, PA', 'http://wwwvalerocom', 2300.00); INSERT INTO `customers` VALUES (123, 'Anthem', '1801 Lititz Pike, Lancaster, PA', 'http://wwwantheminccom', 2300.00); INSERT INTO `customers` VALUES (124, 'Procter & Gamble', '101 E Olney Ave, Philadelphia, PA', 'http://wwwpgcom', 2300.00); INSERT INTO `customers` VALUES (125, 'Air Products & Chemicals', '612 Jefferson Ave, Scranton, PA', 'http://wwwairproductscom', 2300.00); INSERT INTO `customers` VALUES (126, 'State Farm Insurance Cos.', '223 4Th Ave # 1100, Pittsburgh, PA', 'http://wwwstatefarmcom', 2300.00); INSERT INTO `customers` VALUES (127, 'Alphabet', '36 W 34Th St, Erie, PA', 'http://wwwgooglecom', 2400.00); INSERT INTO `customers` VALUES (128, 'Comcast', '1007 Mount Royal Blvd, Pittsburgh, PA', 'http://wwwcomcastcorporationcom', 2400.00); INSERT INTO `customers` VALUES (129, 'Target', '601 Market St, Philadelphia, PA', 'http://wwwtargetcom', 2400.00); INSERT INTO `customers` VALUES (130, 'Western Refining', '5565 Baynton St, Philadelphia, PA', 'http://wwwwnrcom', 2400.00); INSERT INTO `customers` VALUES (131, 'Johnson & Johnson', '5640 Fishers Ln, Rockville, MD', 'http://wwwjnjcom', 2400.00); INSERT INTO `customers` VALUES (132, 'MetLife', '5122 Sinclair Ln, Baltimore, MD', 'http://wwwmetlifecom', 2400.00); INSERT INTO `customers` VALUES (133, 'Archer Daniels Midland', '680 Bel Air Rd, Bel Air, MD', 'http://wwwadmcom', 2400.00); INSERT INTO `customers` VALUES (134, 'Marathon Petroleum', '4301 Ashland Ave, Baltimore, MD', 'http://wwwmarathonpetroleumcom', 2400.00); INSERT INTO `customers` VALUES (135, 'Freddie Mac', '8004 Stansbury Rd, Baltimore, MD', 'http://wwwfreddiemaccom', 2400.00); INSERT INTO `customers` VALUES (136, 'PepsiCo', '10209 Yearling Dr, Rockville, MD', 'http://wwwpepsicocom', 2400.00); INSERT INTO `customers` VALUES (137, 'United Technologies', '3000 Greenmount Ave, Baltimore, MD', 'http://wwwutccom', 2400.00); INSERT INTO `customers` VALUES (138, 'Aetna', '200 E Fort Ave, Baltimore, MD', 'http://wwwaetnacom', 2400.00); INSERT INTO `customers` VALUES (139, 'Lowe?s', '1262 Vocke Rd, Cumberland, MD', 'http://wwwlowescom', 2400.00); INSERT INTO `customers` VALUES (140, 'UPS', '3314 Eastern Ave, Baltimore, MD', 'http://wwwupscom', 2400.00); INSERT INTO `customers` VALUES (141, 'AIG', '12817 Coastal Hwy, Ocean City, MD', 'http://wwwaigcom', 2400.00); INSERT INTO `customers` VALUES (142, 'Prudential Financial', '11200 Scaggsville Rd, Laurel, MD', 'http://wwwprudentialcom', 2400.00); INSERT INTO `customers` VALUES (143, 'Intel', '9435 Washington Blvd N # M, Laurel, MD', 'http://wwwintelcom', 2400.00); INSERT INTO `customers` VALUES (144, 'Humana', '2300 Harford Rd, Baltimore, MD', 'http://wwwhumanacom', 2400.00); INSERT INTO `customers` VALUES (145, 'Disney', '2 2Nd St # A, Ocean City, MD', 'http://wwwdisneycom', 2400.00); INSERT INTO `customers` VALUES (146, 'Cisco Systems', '6917 W Oklahoma Ave, Milwaukee, WI', 'http://wwwciscocom', 2400.00); INSERT INTO `customers` VALUES (147, 'Pfizer', '206 S Broadway # 707, Rochester, MN', 'http://wwwpfizercom', 2400.00); INSERT INTO `customers` VALUES (148, 'Dow Chemical', '160 Glenwood Ave, Minneapolis, MN', 'http://wwwdowcom', 2400.00); INSERT INTO `customers` VALUES (149, 'Sysco', '6915 Grand Ave, Hammond, IN', 'http://wwwsyscocom', 2400.00); INSERT INTO `customers` VALUES (150, 'FedEx', '2215 Oak Industrial Dr Ne, Grand Rapids, MI', 'http://wwwfedexcom', 2400.00); INSERT INTO `customers` VALUES (151, 'Caterpillar', '65 Cadillac Sq # 2701, Detroit, MI', 'http://wwwcaterpillarcom', 2500.00); INSERT INTO `customers` VALUES (152, 'Lockheed Martin', '3435 Tuscany Dr Se, Grand Rapids, MI', 'http://wwwlockheedmartincom', 2500.00); INSERT INTO `customers` VALUES (153, 'New York Life Insurance', '215 4Th Ave Se, Cedar Rapids, IA', 'http://wwwnewyorklifecom', 2500.00); INSERT INTO `customers` VALUES (154, 'Universal Health Services', '1751 Madison Ave, Council Bluffs, IA', 'http://wwwuhsinccom', 3500.00); INSERT INTO `customers` VALUES (155, 'Coca-Cola', '810 1St Ave, Council Bluffs, IA', 'http://wwwcoca-colacompanycom', 3500.00); INSERT INTO `customers` VALUES (156, 'HCA Holdings', '500 W Oklahoma Ave, Milwaukee, WI', 'http://wwwhcahealthcarecom', 3500.00); INSERT INTO `customers` VALUES (157, 'Ingram Micro', '4811 S 76Th St # 205, Milwaukee, WI', 'http://wwwingrammicrocom', 3600.00); INSERT INTO `customers` VALUES (158, 'Owens & Minor', '310 Broadway St, Alexandria, MN', 'http://wwwowens-minorcom', 3600.00); INSERT INTO `customers` VALUES (159, 'Energy Transfer Equity', '1721 E Lake St, Minneapolis, MN', 'http://wwwenergytransfercom', 3600.00); INSERT INTO `customers` VALUES (160, 'Tyson Foods', '255 Great Arrow Ave, Buffalo, NY', 'http://wwwtysonfoodscom', 3600.00); INSERT INTO `customers` VALUES (161, 'American Airlines Group', '800 Carter St, Rochester, NY', 'http://wwwaacom', 3600.00); INSERT INTO `customers` VALUES (162, 'Delta Air Lines', '6640 Campbell Blvd, Lockport, NY', 'http://wwwdeltacom', 3600.00); INSERT INTO `customers` VALUES (163, 'Charter Communications', '802 North Ave, Pittsburgh, PA', 'http://wwwchartercom', 3600.00); INSERT INTO `customers` VALUES (164, 'Nationwide', '1136 Arch St, Philadelphia, PA', 'http://wwwnationwidecom', 3600.00); INSERT INTO `customers` VALUES (165, 'Johnson Controls', '6Th And Master St, Philadelphia, PA', 'http://wwwjohnsoncontrolscom', 3600.00); INSERT INTO `customers` VALUES (166, 'Best Buy', 'Rt 6 E, Warren, PA', 'http://wwwbestbuycom', 3700.00); INSERT INTO `customers` VALUES (167, 'Merck', '1924 Bedford St, Cumberland, MD', 'http://wwwmerckcom', 3700.00); INSERT INTO `customers` VALUES (168, 'Advance Auto Parts', '2674 Collingwood St, Detroit, MI', 'http://wwwadvanceautopartscom', 3700.00); INSERT INTO `customers` VALUES (169, 'Liberty Mutual Insurance Group', '2713 N Bendix Dr, South Bend, IN', 'http://wwwlibertymutualcom', 3700.00); INSERT INTO `customers` VALUES (170, 'Goldman Sachs Group', '23985 Bedford Rd N, Battle Creek, MI', 'http://wwwgscom', 3700.00); INSERT INTO `customers` VALUES (171, 'Honeywell International', '752 W Huron St, Pontiac, MI', 'http://wwwhoneywellcom', 3700.00); INSERT INTO `customers` VALUES (172, 'MasterCard', '660 Woodward Ave # 2290, Detroit, MI', 'http://wwwmastercardcom', 3700.00); INSERT INTO `customers` VALUES (173, 'Massachusetts Mutual Life Insurance', '1330 N Memorial Dr, Racine, WI', 'http://wwwmassmutualcom', 5000.00); INSERT INTO `customers` VALUES (174, 'Oracle', '701 Seneca St, Buffalo, NY', 'http://wwworaclecom', 5000.00); INSERT INTO `customers` VALUES (175, 'Morgan Stanley', '8 Automation Ln, Albany, NY', 'http://wwwmorganstanleycom', 5000.00); INSERT INTO `customers` VALUES (176, 'Cigna', '811 N Brandywine Ave, Schenectady, NY', 'http://wwwcignacom', 5000.00); INSERT INTO `customers` VALUES (177, 'United Continental Holdings', '2904 S Salina St, Syracuse, NY', 'http://wwwunitedcontinentalholdingscom', 5000.00); INSERT INTO `customers` VALUES (178, 'Allstate', '3025 Sussex Ave, Pittsburgh, PA', 'http://wwwallstatecom', 5000.00); INSERT INTO `customers` VALUES (179, 'TIAA', '932 High St, Lancaster, PA', 'http://wwwtiaaorg', 5000.00); INSERT INTO `customers` VALUES (180, 'INTL FCStone', '5344 Haverford Ave, Philadelphia, PA', 'http://wwwintlfcstonecom', 5000.00); INSERT INTO `customers` VALUES (181, 'CHS', '6959 Tulip St, Philadelphia, PA', 'http://wwwchsinccom', 5000.00); INSERT INTO `customers` VALUES (182, 'American Express', '511 S Central Ave # A, Baltimore, MD', 'http://wwwamericanexpresscom', 5000.00); INSERT INTO `customers` VALUES (183, 'Gilead Sciences', '400 E Joppa Rd, Baltimore, MD', 'http://wwwgileadcom', 5000.00); INSERT INTO `customers` VALUES (184, 'Publix Super Markets', '1795 Wu Meng, Muang Chonburi, ', 'http://wwwpublixcom', 1200.00); INSERT INTO `customers` VALUES (185, 'General Dynamics', '1796 Tsing Tao, Muang Nonthaburi, ', 'http://wwwgeneraldynamicscom', 1200.00); INSERT INTO `customers` VALUES (186, 'TJX', '1810 Tucker Crt, Mumbai, ', 'http://wwwtjxcom', 5000.00); INSERT INTO `customers` VALUES (187, 'ConocoPhillips', 'Walpurgisstr 69, Munich, ', 'http://wwwconocophillipscom', 2400.00); INSERT INTO `customers` VALUES (188, 'Nike', 'Sendlinger Tor 4, Munich, ', 'http://wwwnikecom', 2400.00); INSERT INTO `customers` VALUES (189, 'World Fuel Services', 'Theresienstr 15, Munich, ', 'http://wwwwfscorpcom', 2400.00); INSERT INTO `customers` VALUES (190, '3M', 'Via Frenzy 6903, Roma, ', 'http://www3mcom', 1200.00); INSERT INTO `customers` VALUES (191, 'Mondelez International', '1822 Ironweed St, Toronto, ONT', 'http://wwwmondelezinternationalcom', 1200.00); INSERT INTO `customers` VALUES (192, 'Exelon', 'Via Luminosa 162, Firenze, ', 'http://wwwexeloncorpcom', 500.00); INSERT INTO `customers` VALUES (193, 'Twenty-First Century Fox', 'Via Notoriosa 1932 Rd, Firenze, ', 'http://www21cfcom', 500.00); INSERT INTO `customers` VALUES (194, 'Deere', 'Via Notoriosa 1941, Firenze, ', 'http://wwwjohndeerecom', 500.00); INSERT INTO `customers` VALUES (195, 'Applied Materials', 'Via Dolorosa 69, Tellaro, ', 'http://wwwappliedmaterialscom', 700.00); INSERT INTO `customers` VALUES (196, 'DuPont', 'Via Notoriosa 1943, Firenze, ', 'http://wwwdupontcom', 2400.00); INSERT INTO `customers` VALUES (197, 'Avnet', 'Via Luminosa 162, Tellaro, ', 'http://wwwavnetcom', 700.00); INSERT INTO `customers` VALUES (198, 'Eastman Chemical', '2017 Convoy St, Tokyo, ', 'http://wwweastmancom', 2400.00); INSERT INTO `customers` VALUES (199, 'Macy?s', 'Via Di Firenze 231, Tellaro, ', 'http://wwwmacysinccom', 700.00); INSERT INTO `customers` VALUES (200, 'Enterprise Products Partners', 'Via Notoriosa 1949, Firenze, ', 'http://wwwenterpriseproductscom', 2400.00); INSERT INTO `customers` VALUES (201, 'Travelers Cos.', 'Via Frenzy 6903, Tellaro, ', 'http://wwwtravelerscom', 3600.00); INSERT INTO `customers` VALUES (202, 'Sonic Automotive', 'Piazza Del Congresso 22, San Giminiano, ', 'http://wwwsonicautomotivecom', 3600.00); INSERT INTO `customers` VALUES (203, 'Philip Morris International', 'Piazza Quattre Stagioni 4, San Giminiano, ', 'http://wwwpmicom', 3600.00); INSERT INTO `customers` VALUES (204, 'Rite Aid', 'Piazza Cacchiatore 23, San Giminiano, ', 'http://wwwriteaidcom', 3600.00); INSERT INTO `customers` VALUES (205, 'Tech Data', 'Via Notoriosa 1932, Tellaro, ', 'http://wwwtechdatacom', 3600.00); INSERT INTO `customers` VALUES (206, 'Ally Financial', 'Via Notoriosa 1949, Ventimiglia, ', 'http://wwwallycom', 3600.00); INSERT INTO `customers` VALUES (207, 'Northwestern Mutual', '1831 No Wong, Peking, ', 'http://wwwnorthwesternmutualcom', 3600.00); INSERT INTO `customers` VALUES (208, 'Tesoro', 'Via Notoriosa 1942, Firenze, ', 'http://wwwtsocorpcom', 500.00); INSERT INTO `customers` VALUES (209, 'Time Warner', 'Via Delle Grazie 11, Tellaro, ', 'http://wwwtimewarnercom', 2400.00); INSERT INTO `customers` VALUES (210, 'CST Brands', '2033 Spartacus St, Samutprakarn, ', 'http://wwwcstbrandscom', 3700.00); INSERT INTO `customers` VALUES (211, 'McDonald?s', '2034 Sabrina Rd, Samutprakarn, ', 'http://wwwaboutmcdonaldscom', 3700.00); INSERT INTO `customers` VALUES (212, 'Qualcomm', 'Piazza Svizzera, Milano, ', 'http://wwwqualcommcom', 500.00); INSERT INTO `customers` VALUES (213, 'Sears Holdings', 'Ruella Delle Spiriti, Milano, ', 'http://wwwsearsholdingscom', 500.00); INSERT INTO `customers` VALUES (214, 'eBay', 'Via Del Disegno 194, Milano, ', 'http://wwwebaycom', 1500.00); INSERT INTO `customers` VALUES (215, 'Capital One Financial', 'Via Delle Capeletti 52, San Giminiano, ', 'http://wwwcapitalonecom', 1500.00); INSERT INTO `customers` VALUES (216, 'EMC', 'Via Delle Grazie 11, San Giminiano, ', 'http://wwwemccom', 700.00); INSERT INTO `customers` VALUES (217, 'USAA', 'Via Delli Capelli 2, San Giminiano, ', 'http://wwwusaacom', 700.00); INSERT INTO `customers` VALUES (218, 'Lennar', '1592 Silverado St, Bangalore, Kar', 'http://wwwlennarcom', 700.00); INSERT INTO `customers` VALUES (219, 'Duke Energy', '1593 Silverado St, Bangalore, Kar', 'http://wwwduke-energycom', 5000.00); INSERT INTO `customers` VALUES (220, 'Time Warner Cable', '1597 Legend St, Mysore, Kar', 'http://wwwtwccom', 3700.00); INSERT INTO `customers` VALUES (221, 'Halliburton', '1602 Sholay St, Chennai, Tam', 'http://wwwhalliburtoncom', 1500.00); INSERT INTO `customers` VALUES (222, 'GameStop', '1605 Bazigar Crt, Pune, ', 'http://wwwgamestopcorpcom', 5000.00); INSERT INTO `customers` VALUES (223, 'Northrop Grumman', '1606 Sangam Blvd, New Delhi, ', 'http://wwwnorthropgrummancom', 5000.00); INSERT INTO `customers` VALUES (224, 'Arrow Electronics', '1607 Sangam Blvd, New Delhi, ', 'http://wwwarrowcom', 5000.00); INSERT INTO `customers` VALUES (225, 'Reliance Steel & Aluminum', '1609 Pakija Rd, New Delhi, ', 'http://wwwrsaccom', 3700.00); INSERT INTO `customers` VALUES (226, 'Office Depot', '1612 Talaivar St, Chennai, Tam', 'http://wwwofficedepotcom', 5000.00); INSERT INTO `customers` VALUES (227, 'Nordstrom', '1613 Victoria St, Calcutta, ', 'http://wwwnordstromcom', 5000.00); INSERT INTO `customers` VALUES (228, 'Kinder Morgan', '1614 Gitanjali Rd, Calcutta, ', 'http://wwwkindermorgancom', 5000.00); INSERT INTO `customers` VALUES (229, 'Aramark', '1615 Crackers Crt, Chennai - India, ', 'http://wwwaramarkcom', 300.00); INSERT INTO `customers` VALUES (230, 'DaVita HealthCare Partners', '1616 Mr India Ln, Bombay - India, Kar', 'http://wwwdavitacom', 300.00); INSERT INTO `customers` VALUES (231, 'Molina Healthcare', '1617 Crackers St, Bangalore - India, Kar', 'http://wwwmolinahealthcarecom', 300.00); INSERT INTO `customers` VALUES (232, 'WellCare Health Plans', '1618 Villains St, New Delhi - India, ', 'http://wwwwellcarecom', 1200.00); INSERT INTO `customers` VALUES (233, 'CBS', '1619 Bowlers Rd, Chandigarh, Har', 'http://wwwcbscorporationcom', 1200.00); INSERT INTO `customers` VALUES (234, 'Visa', '1620 Sixers Crt, Bombay, Kar', 'http://wwwvisacom', 5000.00); INSERT INTO `customers` VALUES (235, 'Lincoln National', '1622 Roja St, Chennai, Tam', 'http://wwwlfgcom', 5000.00); INSERT INTO `customers` VALUES (236, 'Ecolab', '1623 Hey Ram St, Chennai - India, ', 'http://wwwecolabcom', 5000.00); INSERT INTO `customers` VALUES (237, 'Kellogg', '1627 Sowdagar St, New Delhi, ', 'http://wwwkelloggcompanycom', 1900.00); INSERT INTO `customers` VALUES (238, 'CH Robinson Worldwide', '1628 Pataudi St, New Delhi, ', 'http://wwwchrobinsoncom', 1900.00); INSERT INTO `customers` VALUES (239, 'Textron', '1632 Splash St, Chandigarh, Har', 'http://wwwtextroncom', 2500.00); INSERT INTO `customers` VALUES (240, 'Loews', '1636 Pretty Blvd, Bangalore, Kar', 'http://wwwloewscom', 5000.00); INSERT INTO `customers` VALUES (241, 'Illinois Tool Works', '1646 Brazil Blvd, Chennai, Tam', 'http://wwwitwcom', 500.00); INSERT INTO `customers` VALUES (242, 'Synnex', '1647 Suspense St, Cochin, Ker', 'http://wwwsynnexcom', 500.00); INSERT INTO `customers` VALUES (243, 'Hormel Foods', '1648 Anamika St, Cochin, Ker', 'http://wwwhormelfoodscom', 500.00); INSERT INTO `customers` VALUES (244, 'Viacom', '1650 Teesri Manjil Crt, Kashmir, ', 'http://wwwviacomcom', 3700.00); INSERT INTO `customers` VALUES (245, 'HollyFrontier', '1656 Veterans Rd, Chennai, Tam', 'http://wwwhollyfrontiercom', 2500.00); INSERT INTO `customers` VALUES (246, 'Land O?Lakes', '1662 Talaivar St, Chennai, Tam', 'http://wwwlandolakesinccom', 1500.00); INSERT INTO `customers` VALUES (247, 'Celgene', '1667 2010 St, Batavia, Ker', 'http://wwwcelgenecom', 500.00); INSERT INTO `customers` VALUES (248, 'Devon Energy', 'Piazza Del Congresso 22, Roma, ', 'http://wwwdevonenergycom', 3700.00); INSERT INTO `customers` VALUES (249, 'PBF Energy', 'Piazza Quattre Stagioni 4, Roma, ', 'http://wwwpbfenergycom', 3700.00); INSERT INTO `customers` VALUES (250, 'Genworth Financial', 'Piazza Svizzera, Roma, ', 'http://wwwgenworthcom', 2400.00); INSERT INTO `customers` VALUES (251, 'Yum Brands', 'Ruella Delle Spiriti, Roma, ', 'http://wwwyumcom', 500.00); INSERT INTO `customers` VALUES (252, 'Texas Instruments', 'Via Del Disegno 194, Roma, ', 'http://wwwticom', 500.00); INSERT INTO `customers` VALUES (253, 'CDW', 'Via Delle Capeletti 52, Roma, ', 'http://wwwcdwcom', 500.00); INSERT INTO `customers` VALUES (254, 'PayPal Holdings', 'Via Dello Croce 93, Roma, ', 'http://wwwpaypalcom', 1200.00); INSERT INTO `customers` VALUES (255, 'Waste Management', 'Via Di Firenze 231, Roma, ', 'http://wwwwmcom', 2400.00); INSERT INTO `customers` VALUES (256, 'Marsh & McLennan', 'Via Dolorosa 69, Roma, ', 'http://wwwmmccom', 2400.00); INSERT INTO `customers` VALUES (257, 'Chesapeake Energy', 'Via Notoriosa 1942, Ventimiglia, ', 'http://wwwchkcom', 700.00); INSERT INTO `customers` VALUES (258, 'Priceline Group', 'Via Notoriosa 1943, Ventimiglia, ', 'http://wwwpricelinegroupcom', 700.00); INSERT INTO `customers` VALUES (259, 'Parker-Hannifin', 'Canale Grande 2, Roma, ', 'http://wwwparkercom', 700.00); INSERT INTO `customers` VALUES (260, 'Occidental Petroleum', 'Piazza Cacchiatore 23, Roma, ', 'http://wwwoxycom', 700.00); INSERT INTO `customers` VALUES (261, 'Guardian Life Ins Co of America', 'Via Del Disegno 194, San Giminiano, ', 'http://wwwguardianlifecom', 600.00); INSERT INTO `customers` VALUES (262, 'MGM Resorts International', 'Piazza Svizzera, San Giminiano, ', 'http://wwwmgmresortscom', 100.00); INSERT INTO `customers` VALUES (263, 'Farmers Insurance Exchange', 'Via Dello Croce 93, Tellaro, ', 'http://wwwfarmerscom', 100.00); INSERT INTO `customers` VALUES (264, 'JC Penney', 'Via Dello Croce 93, San Giminiano, ', 'http://wwwjcpenneycom', 400.00); INSERT INTO `customers` VALUES (265, 'Consolidated Edison', 'Ruella Delle Spiriti, San Giminiano, ', 'http://wwwconedisoncom', 400.00); INSERT INTO `customers` VALUES (266, 'Autoliv', 'Via Delle Capeletti 52, San Giminiano, ', 'http://wwwautolivcom', 400.00); INSERT INTO `customers` VALUES (267, 'Cognizant Technology Solutions', 'Via Delli Capelli 2, Tellaro, ', 'http://wwwcognizantcom', 400.00); INSERT INTO `customers` VALUES (268, 'VF', '1971 Limelight Blvd, Samutprakarn, ', 'http://wwwvfccom', 1200.00); INSERT INTO `customers` VALUES (269, 'Ameriprise Financial', 'Harmoniegasse 3, Baden-Daettwil, AG', 'http://wwwameriprisecom', 500.00); INSERT INTO `customers` VALUES (270, 'Fidelity National Financial', 'Sonnenberg 4, Baden-Daettwil, AG', 'http://wwwfnfcom', 500.00); INSERT INTO `customers` VALUES (271, 'Computer Sciences', 'Alfred E Neumann-Weg 3, Baden-Daettwil, AG', 'http://wwwcsccom', 500.00); INSERT INTO `customers` VALUES (272, 'L Brands', 'Dr Herbert Bitto Str 23, Baden-Daettwil, AG', 'http://wwwlbcom', 2300.00); INSERT INTO `customers` VALUES (273, 'Jacobs Engineering Group', 'Taefernstr 4, Baden-Daettwil, AG', 'http://wwwjacobscom', 2300.00); INSERT INTO `customers` VALUES (274, 'Republic Services', 'Kreuzritterplatz 5, Baden-Daettwil, AG', 'http://wwwrepublicservicescom', 3500.00); INSERT INTO `customers` VALUES (275, 'Principal Financial', 'Helebardenweg 5, Baden-Daettwil, AG', 'http://wwwprincipalcom', 3500.00); INSERT INTO `customers` VALUES (276, 'Ross Stores', 'Zum Freundlichen Nachbarn 5, Baden-Daettwil, AG', 'http://wwwrossstorescom', 3500.00); INSERT INTO `customers` VALUES (277, 'Bed Bath & Beyond', 'Ziegenwiese 3, Baden-Daettwil, AG', 'http://wwwbedbathandbeyondcom', 3500.00); INSERT INTO `customers` VALUES (278, 'CSX', 'Am Waldrand 5, Baden-Daettwil, AG', 'http://wwwcsxcom', 3500.00); INSERT INTO `customers` VALUES (279, 'Toys ?R? Us', 'Zur Kantine 9, Baden-Daettwil, AG', 'http://wwwtoysrusinccom', 1200.00); INSERT INTO `customers` VALUES (280, 'Las Vegas Sands', 'Grosse Bahnhostrasse 3, Baden-Daettwil, AG', 'http://wwwsandscom', 1200.00); INSERT INTO `customers` VALUES (281, 'Leucadia National', 'Paradeplatz 4, Zuerich, ZH', 'http://wwwleucadiacom', 1200.00); INSERT INTO `customers` VALUES (282, 'Dominion Resources', 'Badenerstr 1941, Zuerich, ZH', 'http://wwwdomcom', 3500.00); INSERT INTO `customers` VALUES (283, 'United States Steel', 'Welschdoerfchen 1941, Chur, ZH', 'http://wwwussteelcom', 3500.00); INSERT INTO `customers` VALUES (284, 'L-3 Communications', 'Le Reduit, Tschiertschen, GR', 'http://wwwl-3comcom', 1400.00); INSERT INTO `customers` VALUES (285, 'Edison International', 'Bendlehn, Trogen, SG', 'http://wwwedisoninvestorcom', 1400.00); INSERT INTO `customers` VALUES (286, 'Entergy', 'Spisertor 3, St Gallen, SG', 'http://wwwentergycom', 1400.00); INSERT INTO `customers` VALUES (287, 'ADP', 'Langstr 14, Zuerich, ZH', 'http://wwwadpcom', 700.00); INSERT INTO `customers` VALUES (288, 'First Data', 'Roessligasse 4, Zurich, ZH', 'http://wwwfirstdatacom', 700.00); INSERT INTO `customers` VALUES (289, 'BlackRock', 'Zum Froehlichen Schweizer 3, Zurich, ZH', 'http://wwwblackrockcom', 5000.00); INSERT INTO `customers` VALUES (290, 'WestRock', 'Chrottenweg, Bern, BE', 'http://wwwwestrockcom', 5000.00); INSERT INTO `customers` VALUES (291, 'Voya Financial', 'Bruppacher Str 3, Baden-Daettwil, AG', 'http://wwwvoyacom', 5000.00); INSERT INTO `customers` VALUES (292, 'Sherwin-Williams', 'Limmatquai, Zuerich, ZH', 'http://wwwsherwincom', 1800.00); INSERT INTO `customers` VALUES (293, 'Hilton Worldwide Holdings', 'Dreikoenigsstr 3, Zurich, ZH', 'http://wwwhiltonworldwidecom', 1800.00); INSERT INTO `customers` VALUES (294, 'Corning', 'Pfannenstilstr 13, Egg, ZH', 'http://wwwcorningcom', 2300.00); INSERT INTO `customers` VALUES (295, 'RR Donnelley & Sons', 'Kreuzstr 32, Zurich, ZH', 'http://wwwrrdonnelleycom', 2300.00); INSERT INTO `customers` VALUES (296, 'Stanley Black & Decker', '1539 Stripes Rd, Baden-Daettwil, AG', 'http://wwwstanleyblackanddeckercom', 2300.00); INSERT INTO `customers` VALUES (297, 'Xcel Energy', '1540 Stripes Crt, Baden-Daettwil, AG', 'http://wwwxcelenergycom', 400.00); INSERT INTO `customers` VALUES (298, 'Peter Kiewit Sons?', '1592 Silverado St, Bangalore, Kar', 'http://wwwkiewitcom', 1400.00); INSERT INTO `customers` VALUES (299, 'Murphy USA', '1593 Silverado St, Bangalore, Kar', 'http://corporatemurphyusacom', 1400.00); INSERT INTO `customers` VALUES (300, 'CBRE Group', '1596 Commando Blvd, Bangalore, Kar', 'http://wwwcbrecom', 1200.00); INSERT INTO `customers` VALUES (301, 'Univar', '1598 Legend St, Bangalore, Kar', 'http://wwwunivarcom', 5000.00); INSERT INTO `customers` VALUES (302, 'DR Horton', '1599 Legend Rd, Bangalore, Kar', 'http://wwwdrhortoncom', 5000.00); INSERT INTO `customers` VALUES (303, 'Estee Lauder', '1600 Target Crt, Bangalore, Kar', 'http://wwwelcompaniescom', 5000.00); INSERT INTO `customers` VALUES (304, 'Praxair', '1603 Rebel St, Bangalore, Kar', 'http://wwwpraxaircom', 500.00); INSERT INTO `customers` VALUES (305, 'Biogen', '1604 Volunteers Rd, Bangalore, Kar', 'http://wwwbiogencom', 500.00); INSERT INTO `customers` VALUES (306, 'Mosaic', '1606 Volunteers Blvd, Bangalore, Kar', 'http://wwwmosaiccocom', 3500.00); INSERT INTO `customers` VALUES (307, 'State Street Corp.', '1607 Abwdrts St, Bangalore, Kar', 'http://wwwstatestreetcom', 3500.00); INSERT INTO `customers` VALUES (308, 'Unum Group', '1608 Amadeus St, Bangalore, Kar', 'http://wwwunumcom', 3500.00); INSERT INTO `customers` VALUES (309, 'Reynolds American', '1610 Betrayal Crt, Bangalore, Kar', 'http://wwwreynoldsamericancom', 5000.00); INSERT INTO `customers` VALUES (310, 'Core-Mark Holding', '1611 Carmen Blvd, Bangalore, Kar', 'http://wwwcore-markcom', 5000.00); INSERT INTO `customers` VALUES (311, 'Group 1 Automotive', '1614 Crackers Rd, Bangalore - India, Kar', 'http://wwwgroup1autocom', 2300.00); INSERT INTO `customers` VALUES (312, 'Henry Schein', '1615 Crackers Crt, Bangalore - India, Kar', 'http://wwwhenryscheincom', 5000.00); INSERT INTO `customers` VALUES (313, 'Hertz Global Holdings', '1616 Crackers Blvd, Bangalore - India, Kar', 'http://wwwhertzcom', 5000.00); INSERT INTO `customers` VALUES (314, 'Thrivent Financial for Lutherans', '1617 Crackers St, Bangalore - India, Kar', 'http://wwwthriventcom', 900.00); INSERT INTO `customers` VALUES (315, 'Norfolk Southern', '1618 Footloose St, Bangalore - India, Kar', 'http://wwwnscorpcom', 900.00); INSERT INTO `customers` VALUES (316, 'Reinsurance Group of America', '1619 Footloose Rd, Bangalore - India, Kar', 'http://wwwrgarecom', 900.00); INSERT INTO `customers` VALUES (317, 'Public Service Enterprise Group', '1621 Gargon! Blvd, Bangalore - India, Kar', 'http://wwwpsegcom', 600.00); INSERT INTO `customers` VALUES (318, 'Cameron International', '1667 2010 St, Batavia, IL', 'http://wwwc-a-mcom', 200.00); INSERT INTO `customers` VALUES (319, 'BB&T Corp.', '1668 Chong Tao, Beijing, ', 'http://wwwbbtcom', 200.00); -- ---------------------------- -- Table structure for employees -- ---------------------------- DROP TABLE IF EXISTS `employees`; CREATE TABLE `employees` ( `employee_id` smallint NOT NULL, `first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `hire_date` date NOT NULL, `manager_id` smallint NULL DEFAULT NULL, `job_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, PRIMARY KEY (`employee_id`) USING BTREE, INDEX `fk_employees_manager`(`manager_id` ASC) USING BTREE, CONSTRAINT `fk_employees_manager` FOREIGN KEY (`manager_id`) REFERENCES `employees` (`employee_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of employees -- ---------------------------- INSERT INTO `employees` VALUES (1, 'Tommy', 'Bailey', 'tommybailey@examplecom', '5151234567', '2017-06-16', NULL, 'President'); INSERT INTO `employees` VALUES (2, 'Jude', 'Rivera', 'juderivera@examplecom', '5151234568', '2021-09-16', 1, 'Administration Vice President'); INSERT INTO `employees` VALUES (3, 'Blake', 'Cooper', 'blakecooper@examplecom', '5151234569', '2013-09-16', 1, 'Administration Vice President'); INSERT INTO `employees` VALUES (4, 'Louie', 'Richardson', 'louierichardson@examplecom', '5904234567', '2003-09-16', 3, 'Programmer'); INSERT INTO `employees` VALUES (5, 'Nathan', 'Cox', 'nathancox@examplecom', '5904234568', '2021-05-16', 4, 'Programmer'); INSERT INTO `employees` VALUES (6, 'Gabriel', 'Howard', 'gabrielhoward@examplecom', '5904234569', '2025-06-16', 4, 'Programmer'); INSERT INTO `employees` VALUES (7, 'Charles', 'Ward', 'charlesward@examplecom', '5904234560', '2005-02-16', 4, 'Programmer'); INSERT INTO `employees` VALUES (8, 'Bobby', 'Torres', 'bobbytorres@examplecom', '5904235567', '2007-02-16', 4, 'Programmer'); INSERT INTO `employees` VALUES (9, 'Mohammad', 'Peterson', 'mohammadpeterson@examplecom', '5151244569', '2017-09-16', 2, 'Finance Manager'); INSERT INTO `employees` VALUES (10, 'Ryan', 'Gray', 'ryangray@examplecom', '5151244169', '2016-09-16', 9, 'Accountant'); INSERT INTO `employees` VALUES (11, 'Tyler', 'Ramirez', 'tylerramirez@examplecom', '5151244269', '2028-09-16', 9, 'Accountant'); INSERT INTO `employees` VALUES (12, 'Elliott', 'James', 'elliottjames@examplecom', '5151244369', '2030-09-16', 9, 'Accountant'); INSERT INTO `employees` VALUES (13, 'Albert', 'Watson', 'albertwatson@examplecom', '5151244469', '2007-03-16', 9, 'Accountant'); INSERT INTO `employees` VALUES (14, 'Elliot', 'Brooks', 'elliotbrooks@examplecom', '5151244567', '2007-12-16', 9, 'Accountant'); INSERT INTO `employees` VALUES (15, 'Rory', 'Kelly', 'rorykelly@examplecom', '5151274561', '2007-12-16', 1, 'Purchasing Manager'); INSERT INTO `employees` VALUES (16, 'Alex', 'Sanders', 'alexsanders@examplecom', '5151274562', '2018-05-16', 15, 'Purchasing Clerk'); INSERT INTO `employees` VALUES (17, 'Frederick', 'Price', 'frederickprice@examplecom', '5151274563', '2024-12-16', 15, 'Purchasing Clerk'); INSERT INTO `employees` VALUES (18, 'Ollie', 'Bennett', 'olliebennett@examplecom', '5151274564', '2024-07-16', 15, 'Purchasing Clerk'); INSERT INTO `employees` VALUES (19, 'Louis', 'Wood', 'louiswood@examplecom', '5151274565', '2015-11-16', 15, 'Purchasing Clerk'); INSERT INTO `employees` VALUES (20, 'Dexter', 'Barnes', 'dexterbarnes@examplecom', '5151274566', '2010-09-16', 15, 'Purchasing Clerk'); INSERT INTO `employees` VALUES (21, 'Jaxon', 'Ross', 'jaxonross@examplecom', '6501231234', '2018-07-16', 1, 'Stock Manager'); INSERT INTO `employees` VALUES (22, 'Liam', 'Henderson', 'liamhenderson@examplecom', '6501232234', '2010-02-16', 1, 'Stock Manager'); INSERT INTO `employees` VALUES (23, 'Jackson', 'Coleman', 'jacksoncoleman@examplecom', '6501233234', '2001-05-16', 1, 'Stock Manager'); INSERT INTO `employees` VALUES (24, 'Callum', 'Jenkins', 'callumjenkins@examplecom', '6501234234', '2010-10-16', 1, 'Stock Manager'); INSERT INTO `employees` VALUES (25, 'Ronnie', 'Perry', 'ronnieperry@examplecom', '6501235234', '2016-11-16', 1, 'Stock Manager'); INSERT INTO `employees` VALUES (26, 'Leon', 'Powell', 'leonpowell@examplecom', '6501241214', '2016-07-16', 21, 'Stock Clerk'); INSERT INTO `employees` VALUES (27, 'Kai', 'Long', 'kailong@examplecom', '6501241224', '2028-09-16', 21, 'Stock Clerk'); INSERT INTO `employees` VALUES (28, 'Aaron', 'Patterson', 'aaronpatterson@examplecom', '6501241334', '2014-09-16', 21, 'Stock Clerk'); INSERT INTO `employees` VALUES (29, 'Roman', 'Hughes', 'romanhughes@examplecom', '6501241434', '2008-03-16', 21, 'Stock Clerk'); INSERT INTO `employees` VALUES (30, 'Austin', 'Flores', 'austinflores@examplecom', '6501245234', '2020-09-16', 22, 'Stock Clerk'); INSERT INTO `employees` VALUES (31, 'Ellis', 'Washington', 'elliswashington@examplecom', '6501246234', '2030-10-16', 22, 'Stock Clerk'); INSERT INTO `employees` VALUES (32, 'Jamie', 'Butler', 'jamiebutler@examplecom', '6501247234', '2016-02-16', 22, 'Stock Clerk'); INSERT INTO `employees` VALUES (33, 'Reggie', 'Simmons', 'reggiesimmons@examplecom', '6501248234', '2010-02-16', 22, 'Stock Clerk'); INSERT INTO `employees` VALUES (34, 'Seth', 'Foster', 'sethfoster@examplecom', '6501271934', '2014-06-16', 23, 'Stock Clerk'); INSERT INTO `employees` VALUES (35, 'Carter', 'Gonzales', 'cartergonzales@examplecom', '6501271834', '2026-09-16', 23, 'Stock Clerk'); INSERT INTO `employees` VALUES (36, 'Felix', 'Bryant', 'felixbryant@examplecom', '6501271734', '2012-12-16', 23, 'Stock Clerk'); INSERT INTO `employees` VALUES (37, 'Ibrahim', 'Alexander', 'ibrahimalexander@examplecom', '6501271634', '2006-02-16', 23, 'Stock Clerk'); INSERT INTO `employees` VALUES (38, 'Sonny', 'Russell', 'sonnyrussell@examplecom', '6501211234', '2014-07-16', 24, 'Stock Clerk'); INSERT INTO `employees` VALUES (39, 'Kian', 'Griffin', 'kiangriffin@examplecom', '6501212034', '2026-10-16', 24, 'Stock Clerk'); INSERT INTO `employees` VALUES (40, 'Caleb', 'Diaz', 'calebdiaz@examplecom', '6501212019', '2012-02-16', 24, 'Stock Clerk'); INSERT INTO `employees` VALUES (41, 'Connor', 'Hayes', 'connorhayes@examplecom', '6501211834', '2006-02-16', 24, 'Stock Clerk'); INSERT INTO `employees` VALUES (42, 'Amelia', 'Myers', 'ameliamyers@examplecom', '6501218009', '2017-10-16', 25, 'Stock Clerk'); INSERT INTO `employees` VALUES (43, 'Olivia', 'Ford', 'oliviaford@examplecom', '6501212994', '2029-09-16', 25, 'Stock Clerk'); INSERT INTO `employees` VALUES (44, 'Emily', 'Hamilton', 'emilyhamilton@examplecom', '6501212874', '2015-03-16', 25, 'Stock Clerk'); INSERT INTO `employees` VALUES (45, 'Isla', 'Graham', 'islagraham@examplecom', '6501212004', '2009-07-16', 25, 'Stock Clerk'); INSERT INTO `employees` VALUES (46, 'Ava', 'Sullivan', 'avasullivan@examplecom', '011441344429268', '2001-10-16', 1, 'Sales Manager'); INSERT INTO `employees` VALUES (47, 'Ella', 'Wallace', 'ellawallace@examplecom', '011441344467268', '2005-09-16', 1, 'Sales Manager'); INSERT INTO `employees` VALUES (48, 'Jessica', 'Woods', 'jessicawoods@examplecom', '011441344429278', '2010-03-16', 1, 'Sales Manager'); INSERT INTO `employees` VALUES (49, 'Isabella', 'Cole', 'isabellacole@examplecom', '011441344619268', '2015-10-16', 1, 'Sales Manager'); INSERT INTO `employees` VALUES (50, 'Mia', 'West', 'miawest@examplecom', '011441344429018', '2029-09-16', 1, 'Sales Manager'); INSERT INTO `employees` VALUES (51, 'Poppy', 'Jordan', 'poppyjordan@examplecom', '011441344129268', '2030-09-16', 46, 'Sales Representative'); INSERT INTO `employees` VALUES (52, 'Sophie', 'Owens', 'sophieowens@examplecom', '011441344345268', '2024-03-16', 46, 'Sales Representative'); INSERT INTO `employees` VALUES (53, 'Sophia', 'Reynolds', 'sophiareynolds@examplecom', '011441344478968', '2020-09-16', 46, 'Sales Representative'); INSERT INTO `employees` VALUES (54, 'Lily', 'Fisher', 'lilyfisher@examplecom', '011441344498718', '2030-03-16', 46, 'Sales Representative'); INSERT INTO `employees` VALUES (55, 'Grace', 'Ellis', 'graceellis@examplecom', '011441344987668', '2009-12-16', 46, 'Sales Representative'); INSERT INTO `employees` VALUES (56, 'Evie', 'Harrison', 'evieharrison@examplecom', '011441344486508', '2023-11-16', 46, 'Sales Representative'); INSERT INTO `employees` VALUES (57, 'Scarlett', 'Gibson', 'scarlettgibson@examplecom', '011441345429268', '2030-09-16', 47, 'Sales Representative'); INSERT INTO `employees` VALUES (58, 'Ruby', 'Mcdonald', 'rubymcdonald@examplecom', '011441345929268', '2004-03-16', 47, 'Sales Representative'); INSERT INTO `employees` VALUES (59, 'Chloe', 'Cruz', 'chloecruz@examplecom', '011441345829268', '2001-09-16', 47, 'Sales Representative'); INSERT INTO `employees` VALUES (60, 'Isabelle', 'Marshall', 'isabellemarshall@examplecom', '011441345729268', '2010-03-16', 47, 'Sales Representative'); INSERT INTO `employees` VALUES (61, 'Daisy', 'Ortiz', 'daisyortiz@examplecom', '011441345629268', '2015-12-16', 47, 'Sales Representative'); INSERT INTO `employees` VALUES (62, 'Freya', 'Gomez', 'freyagomez@examplecom', '011441345529268', '2003-11-16', 47, 'Sales Representative'); INSERT INTO `employees` VALUES (63, 'Phoebe', 'Murray', 'phoebemurray@examplecom', '011441346129268', '2011-11-16', 48, 'Sales Representative'); INSERT INTO `employees` VALUES (64, 'Florence', 'Freeman', 'florencefreeman@examplecom', '011441346229268', '2019-03-16', 48, 'Sales Representative'); INSERT INTO `employees` VALUES (65, 'Alice', 'Wells', 'alicewells@examplecom', '011441346329268', '2024-09-16', 48, 'Sales Representative'); INSERT INTO `employees` VALUES (66, 'Charlotte', 'Webb', 'charlottewebb@examplecom', '011441346529268', '2023-02-16', 48, 'Sales Representative'); INSERT INTO `employees` VALUES (67, 'Sienna', 'Simpson', 'siennasimpson@examplecom', '011441346629268', '2024-03-16', 48, 'Sales Representative'); INSERT INTO `employees` VALUES (68, 'Matilda', 'Stevens', 'matildastevens@examplecom', '011441346729268', '2021-02-16', 48, 'Sales Representative'); INSERT INTO `employees` VALUES (69, 'Evelyn', 'Tucker', 'evelyntucker@examplecom', '011441343929268', '2011-03-16', 49, 'Sales Representative'); INSERT INTO `employees` VALUES (70, 'Eva', 'Porter', 'evaporter@examplecom', '011441343829268', '2023-03-16', 49, 'Sales Representative'); INSERT INTO `employees` VALUES (71, 'Millie', 'Hunter', 'milliehunter@examplecom', '011441343729268', '2024-09-16', 49, 'Sales Representative'); INSERT INTO `employees` VALUES (72, 'Sofia', 'Hicks', 'sofiahicks@examplecom', '011441343629268', '2023-02-16', 49, 'Sales Representative'); INSERT INTO `employees` VALUES (73, 'Lucy', 'Crawford', 'lucycrawford@examplecom', '011441343529268', '2024-03-16', 49, 'Sales Representative'); INSERT INTO `employees` VALUES (74, 'Elsie', 'Henry', 'elsiehenry@examplecom', '011441343329268', '2021-02-16', 49, 'Sales Representative'); INSERT INTO `employees` VALUES (75, 'Imogen', 'Boyd', 'imogenboyd@examplecom', '011441644429267', '2011-05-16', 50, 'Sales Representative'); INSERT INTO `employees` VALUES (76, 'Layla', 'Mason', 'laylamason@examplecom', '011441644429266', '2019-03-16', 50, 'Sales Representative'); INSERT INTO `employees` VALUES (77, 'Rosie', 'Morales', 'rosiemorales@examplecom', '011441644429265', '2024-03-16', 50, 'Sales Representative'); INSERT INTO `employees` VALUES (78, 'Maya', 'Kennedy', 'mayakennedy@examplecom', '011441644429264', '2023-02-16', 50, 'Sales Representative'); INSERT INTO `employees` VALUES (79, 'Esme', 'Warren', 'esmewarren@examplecom', '011441644429263', '2024-05-16', 50, 'Sales Representative'); INSERT INTO `employees` VALUES (80, 'Elizabeth', 'Dixon', 'elizabethdixon@examplecom', '011441644429262', '2004-09-16', 50, 'Sales Representative'); INSERT INTO `employees` VALUES (81, 'Lola', 'Ramos', 'lolaramos@examplecom', '6505079876', '2024-09-16', 21, 'Shipping Clerk'); INSERT INTO `employees` VALUES (82, 'Willow', 'Reyes', 'willowreyes@examplecom', '6505079877', '2023-02-16', 21, 'Shipping Clerk'); INSERT INTO `employees` VALUES (83, 'Ivy', 'Burns', 'ivyburns@examplecom', '6505079878', '2021-06-16', 21, 'Shipping Clerk'); INSERT INTO `employees` VALUES (84, 'Erin', 'Gordon', 'eringordon@examplecom', '6505079879', '2003-02-16', 21, 'Shipping Clerk'); INSERT INTO `employees` VALUES (85, 'Holly', 'Shaw', 'hollyshaw@examplecom', '6505091876', '2027-09-16', 22, 'Shipping Clerk'); INSERT INTO `employees` VALUES (86, 'Emilia', 'Holmes', 'emiliaholmes@examplecom', '6505092876', '2020-02-16', 22, 'Shipping Clerk'); INSERT INTO `employees` VALUES (87, 'Molly', 'Rice', 'mollyrice@examplecom', '6505093876', '2024-06-16', 22, 'Shipping Clerk'); INSERT INTO `employees` VALUES (88, 'Ellie', 'Robertson', 'ellierobertson@examplecom', '6505094876', '2007-02-16', 22, 'Shipping Clerk'); INSERT INTO `employees` VALUES (89, 'Jasmine', 'Hunt', 'jasminehunt@examplecom', '6505051876', '2014-06-16', 23, 'Shipping Clerk'); INSERT INTO `employees` VALUES (90, 'Eliza', 'Black', 'elizablack@examplecom', '6505052876', '2013-09-16', 23, 'Shipping Clerk'); INSERT INTO `employees` VALUES (91, 'Lilly', 'Daniels', 'lillydaniels@examplecom', '6505053876', '2011-07-16', 23, 'Shipping Clerk'); INSERT INTO `employees` VALUES (92, 'Abigail', 'Palmer', 'abigailpalmer@examplecom', '6505054876', '2019-12-16', 23, 'Shipping Clerk'); INSERT INTO `employees` VALUES (93, 'Georgia', 'Mills', 'georgiamills@examplecom', '6505011876', '2004-02-16', 24, 'Shipping Clerk'); INSERT INTO `employees` VALUES (94, 'Maisie', 'Nichols', 'maisienichols@examplecom', '6505012876', '2003-03-16', 24, 'Shipping Clerk'); INSERT INTO `employees` VALUES (95, 'Eleanor', 'Grant', 'eleanorgrant@examplecom', '6505013876', '2001-07-16', 24, 'Shipping Clerk'); INSERT INTO `employees` VALUES (96, 'Hannah', 'Knight', 'hannahknight@examplecom', '6505014876', '2017-03-16', 24, 'Shipping Clerk'); INSERT INTO `employees` VALUES (97, 'Harriet', 'Ferguson', 'harrietferguson@examplecom', '6505079811', '2024-02-16', 25, 'Shipping Clerk'); INSERT INTO `employees` VALUES (98, 'Amber', 'Rose', 'amberrose@examplecom', '6505079822', '2023-05-16', 25, 'Shipping Clerk'); INSERT INTO `employees` VALUES (99, 'Bella', 'Stone', 'bellastone@examplecom', '6505079833', '2021-06-16', 25, 'Shipping Clerk'); INSERT INTO `employees` VALUES (100, 'Thea', 'Hawkins', 'theahawkins@examplecom', '6505079844', '2013-09-16', 25, 'Shipping Clerk'); INSERT INTO `employees` VALUES (101, 'Annabelle', 'Dunn', 'annabelledunn@examplecom', '5151234444', '2017-09-16', 2, 'Administration Assistant'); INSERT INTO `employees` VALUES (102, 'Emma', 'Perkins', 'emmaperkins@examplecom', '5151235555', '2017-02-16', 1, 'Marketing Manager'); INSERT INTO `employees` VALUES (103, 'Amelie', 'Hudson', 'ameliehudson@examplecom', '6031236666', '2017-09-16', 102, 'Marketing Representative'); INSERT INTO `employees` VALUES (104, 'Harper', 'Spencer', 'harperspencer@examplecom', '5151237777', '2007-06-16', 2, 'Human Resources Representative'); INSERT INTO `employees` VALUES (105, 'Gracie', 'Gardner', 'graciegardner@examplecom', '5151238888', '2007-06-16', 2, 'Public Relations Representative'); INSERT INTO `employees` VALUES (106, 'Rose', 'Stephens', 'rosestephens@examplecom', '5151238080', '2007-06-16', 2, 'Accounting Manager'); INSERT INTO `employees` VALUES (107, 'Summer', 'Payne', 'summerpayne@examplecom', '5151238181', '2007-06-16', 106, 'Public Accountant'); -- ---------------------------- -- Table structure for inventories -- ---------------------------- DROP TABLE IF EXISTS `inventories`; CREATE TABLE `inventories` ( `product_id` smallint NOT NULL, `warehouse_id` smallint NOT NULL, `quantity` smallint NOT NULL, PRIMARY KEY (`product_id`, `warehouse_id`) USING BTREE, INDEX `fk_inventories_warehouse`(`warehouse_id` ASC) USING BTREE, CONSTRAINT `fk_inventories_product` FOREIGN KEY (`product_id`) REFERENCES `products` (`product_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_inventories_warehouse` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`warehouse_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of inventories -- ---------------------------- INSERT INTO `inventories` VALUES (2, 3, 100); INSERT INTO `inventories` VALUES (2, 5, 71); INSERT INTO `inventories` VALUES (2, 6, 58); INSERT INTO `inventories` VALUES (2, 7, 46); INSERT INTO `inventories` VALUES (2, 8, 34); INSERT INTO `inventories` VALUES (2, 9, 23); INSERT INTO `inventories` VALUES (3, 1, 106); INSERT INTO `inventories` VALUES (3, 2, 96); INSERT INTO `inventories` VALUES (3, 3, 88); INSERT INTO `inventories` VALUES (3, 4, 63); INSERT INTO `inventories` VALUES (3, 5, 46); INSERT INTO `inventories` VALUES (3, 6, 29); INSERT INTO `inventories` VALUES (3, 7, 63); INSERT INTO `inventories` VALUES (3, 8, 49); INSERT INTO `inventories` VALUES (3, 9, 35); INSERT INTO `inventories` VALUES (4, 1, 106); INSERT INTO `inventories` VALUES (4, 2, 96); INSERT INTO `inventories` VALUES (4, 3, 88); INSERT INTO `inventories` VALUES (4, 4, 63); INSERT INTO `inventories` VALUES (4, 5, 46); INSERT INTO `inventories` VALUES (4, 6, 30); INSERT INTO `inventories` VALUES (4, 7, 63); INSERT INTO `inventories` VALUES (4, 8, 49); INSERT INTO `inventories` VALUES (4, 9, 35); INSERT INTO `inventories` VALUES (5, 1, 106); INSERT INTO `inventories` VALUES (5, 2, 96); INSERT INTO `inventories` VALUES (5, 3, 89); INSERT INTO `inventories` VALUES (5, 4, 63); INSERT INTO `inventories` VALUES (5, 5, 47); INSERT INTO `inventories` VALUES (5, 6, 30); INSERT INTO `inventories` VALUES (5, 7, 63); INSERT INTO `inventories` VALUES (5, 8, 49); INSERT INTO `inventories` VALUES (5, 9, 36); INSERT INTO `inventories` VALUES (6, 1, 107); INSERT INTO `inventories` VALUES (6, 2, 96); INSERT INTO `inventories` VALUES (6, 3, 89); INSERT INTO `inventories` VALUES (6, 4, 64); INSERT INTO `inventories` VALUES (6, 5, 47); INSERT INTO `inventories` VALUES (6, 6, 30); INSERT INTO `inventories` VALUES (6, 7, 63); INSERT INTO `inventories` VALUES (6, 8, 50); INSERT INTO `inventories` VALUES (6, 9, 36); INSERT INTO `inventories` VALUES (7, 2, 97); INSERT INTO `inventories` VALUES (7, 4, 64); INSERT INTO `inventories` VALUES (7, 6, 30); INSERT INTO `inventories` VALUES (7, 8, 50); INSERT INTO `inventories` VALUES (7, 9, 36); INSERT INTO `inventories` VALUES (8, 2, 97); INSERT INTO `inventories` VALUES (8, 4, 67); INSERT INTO `inventories` VALUES (8, 6, 30); INSERT INTO `inventories` VALUES (8, 8, 50); INSERT INTO `inventories` VALUES (8, 9, 36); INSERT INTO `inventories` VALUES (9, 2, 97); INSERT INTO `inventories` VALUES (9, 4, 67); INSERT INTO `inventories` VALUES (9, 6, 31); INSERT INTO `inventories` VALUES (9, 8, 50); INSERT INTO `inventories` VALUES (9, 9, 36); INSERT INTO `inventories` VALUES (11, 1, 108); INSERT INTO `inventories` VALUES (11, 2, 98); INSERT INTO `inventories` VALUES (11, 3, 90); INSERT INTO `inventories` VALUES (11, 4, 68); INSERT INTO `inventories` VALUES (11, 5, 48); INSERT INTO `inventories` VALUES (11, 6, 31); INSERT INTO `inventories` VALUES (11, 7, 65); INSERT INTO `inventories` VALUES (11, 8, 51); INSERT INTO `inventories` VALUES (11, 9, 37); INSERT INTO `inventories` VALUES (12, 1, 108); INSERT INTO `inventories` VALUES (12, 2, 98); INSERT INTO `inventories` VALUES (12, 3, 90); INSERT INTO `inventories` VALUES (12, 4, 68); INSERT INTO `inventories` VALUES (12, 5, 48); INSERT INTO `inventories` VALUES (12, 6, 32); INSERT INTO `inventories` VALUES (12, 7, 65); INSERT INTO `inventories` VALUES (12, 8, 51); INSERT INTO `inventories` VALUES (12, 9, 37); INSERT INTO `inventories` VALUES (13, 2, 98); INSERT INTO `inventories` VALUES (13, 4, 68); INSERT INTO `inventories` VALUES (13, 6, 32); INSERT INTO `inventories` VALUES (13, 8, 51); INSERT INTO `inventories` VALUES (13, 9, 37); INSERT INTO `inventories` VALUES (14, 2, 98); INSERT INTO `inventories` VALUES (14, 4, 68); INSERT INTO `inventories` VALUES (14, 6, 32); INSERT INTO `inventories` VALUES (14, 8, 51); INSERT INTO `inventories` VALUES (14, 9, 38); INSERT INTO `inventories` VALUES (15, 2, 99); INSERT INTO `inventories` VALUES (15, 4, 69); INSERT INTO `inventories` VALUES (15, 6, 33); INSERT INTO `inventories` VALUES (15, 8, 52); INSERT INTO `inventories` VALUES (15, 9, 41); INSERT INTO `inventories` VALUES (17, 2, 100); INSERT INTO `inventories` VALUES (17, 4, 70); INSERT INTO `inventories` VALUES (17, 6, 34); INSERT INTO `inventories` VALUES (17, 8, 54); INSERT INTO `inventories` VALUES (17, 9, 3); INSERT INTO `inventories` VALUES (18, 2, 101); INSERT INTO `inventories` VALUES (18, 4, 71); INSERT INTO `inventories` VALUES (18, 6, 35); INSERT INTO `inventories` VALUES (18, 8, 54); INSERT INTO `inventories` VALUES (18, 9, 3); INSERT INTO `inventories` VALUES (19, 2, 101); INSERT INTO `inventories` VALUES (19, 4, 71); INSERT INTO `inventories` VALUES (19, 6, 35); INSERT INTO `inventories` VALUES (19, 8, 54); INSERT INTO `inventories` VALUES (19, 9, 3); INSERT INTO `inventories` VALUES (20, 2, 104); INSERT INTO `inventories` VALUES (20, 4, 71); INSERT INTO `inventories` VALUES (20, 6, 35); INSERT INTO `inventories` VALUES (20, 8, 5); INSERT INTO `inventories` VALUES (20, 9, 4); INSERT INTO `inventories` VALUES (21, 2, 105); INSERT INTO `inventories` VALUES (21, 4, 72); INSERT INTO `inventories` VALUES (21, 6, 36); INSERT INTO `inventories` VALUES (21, 8, 5); INSERT INTO `inventories` VALUES (21, 9, 4); INSERT INTO `inventories` VALUES (22, 2, 114); INSERT INTO `inventories` VALUES (22, 5, 73); INSERT INTO `inventories` VALUES (22, 6, 62); INSERT INTO `inventories` VALUES (22, 7, 50); INSERT INTO `inventories` VALUES (22, 8, 38); INSERT INTO `inventories` VALUES (23, 2, 114); INSERT INTO `inventories` VALUES (23, 5, 74); INSERT INTO `inventories` VALUES (23, 6, 62); INSERT INTO `inventories` VALUES (23, 7, 50); INSERT INTO `inventories` VALUES (23, 8, 39); INSERT INTO `inventories` VALUES (24, 2, 115); INSERT INTO `inventories` VALUES (24, 5, 74); INSERT INTO `inventories` VALUES (24, 6, 62); INSERT INTO `inventories` VALUES (24, 7, 50); INSERT INTO `inventories` VALUES (24, 8, 39); INSERT INTO `inventories` VALUES (25, 2, 115); INSERT INTO `inventories` VALUES (25, 5, 74); INSERT INTO `inventories` VALUES (25, 6, 62); INSERT INTO `inventories` VALUES (25, 7, 51); INSERT INTO `inventories` VALUES (25, 8, 39); INSERT INTO `inventories` VALUES (26, 2, 115); INSERT INTO `inventories` VALUES (26, 5, 74); INSERT INTO `inventories` VALUES (26, 6, 63); INSERT INTO `inventories` VALUES (26, 7, 51); INSERT INTO `inventories` VALUES (26, 8, 39); INSERT INTO `inventories` VALUES (27, 2, 106); INSERT INTO `inventories` VALUES (27, 4, 73); INSERT INTO `inventories` VALUES (27, 6, 37); INSERT INTO `inventories` VALUES (27, 8, 6); INSERT INTO `inventories` VALUES (27, 9, 5); INSERT INTO `inventories` VALUES (29, 2, 107); INSERT INTO `inventories` VALUES (29, 4, 74); INSERT INTO `inventories` VALUES (29, 6, 38); INSERT INTO `inventories` VALUES (29, 8, 7); INSERT INTO `inventories` VALUES (29, 9, 6); INSERT INTO `inventories` VALUES (30, 2, 107); INSERT INTO `inventories` VALUES (30, 4, 74); INSERT INTO `inventories` VALUES (30, 6, 38); INSERT INTO `inventories` VALUES (30, 8, 7); INSERT INTO `inventories` VALUES (30, 9, 6); INSERT INTO `inventories` VALUES (31, 6, 39); INSERT INTO `inventories` VALUES (31, 8, 8); INSERT INTO `inventories` VALUES (31, 9, 7); INSERT INTO `inventories` VALUES (32, 6, 39); INSERT INTO `inventories` VALUES (32, 8, 8); INSERT INTO `inventories` VALUES (32, 9, 7); INSERT INTO `inventories` VALUES (33, 2, 117); INSERT INTO `inventories` VALUES (33, 5, 77); INSERT INTO `inventories` VALUES (33, 6, 65); INSERT INTO `inventories` VALUES (33, 7, 53); INSERT INTO `inventories` VALUES (33, 8, 42); INSERT INTO `inventories` VALUES (34, 6, 39); INSERT INTO `inventories` VALUES (34, 8, 9); INSERT INTO `inventories` VALUES (34, 9, 8); INSERT INTO `inventories` VALUES (35, 2, 118); INSERT INTO `inventories` VALUES (35, 5, 77); INSERT INTO `inventories` VALUES (35, 6, 66); INSERT INTO `inventories` VALUES (35, 7, 54); INSERT INTO `inventories` VALUES (35, 8, 42); INSERT INTO `inventories` VALUES (36, 2, 118); INSERT INTO `inventories` VALUES (36, 5, 78); INSERT INTO `inventories` VALUES (36, 6, 66); INSERT INTO `inventories` VALUES (36, 7, 54); INSERT INTO `inventories` VALUES (36, 8, 43); INSERT INTO `inventories` VALUES (37, 2, 119); INSERT INTO `inventories` VALUES (37, 5, 78); INSERT INTO `inventories` VALUES (37, 6, 66); INSERT INTO `inventories` VALUES (37, 7, 55); INSERT INTO `inventories` VALUES (37, 8, 43); INSERT INTO `inventories` VALUES (38, 2, 119); INSERT INTO `inventories` VALUES (38, 5, 78); INSERT INTO `inventories` VALUES (38, 6, 66); INSERT INTO `inventories` VALUES (38, 7, 55); INSERT INTO `inventories` VALUES (38, 8, 43); INSERT INTO `inventories` VALUES (39, 2, 119); INSERT INTO `inventories` VALUES (39, 5, 78); INSERT INTO `inventories` VALUES (39, 6, 66); INSERT INTO `inventories` VALUES (39, 7, 55); INSERT INTO `inventories` VALUES (39, 8, 43); INSERT INTO `inventories` VALUES (40, 2, 119); INSERT INTO `inventories` VALUES (40, 5, 78); INSERT INTO `inventories` VALUES (40, 6, 67); INSERT INTO `inventories` VALUES (40, 7, 55); INSERT INTO `inventories` VALUES (40, 8, 44); INSERT INTO `inventories` VALUES (41, 2, 119); INSERT INTO `inventories` VALUES (41, 5, 79); INSERT INTO `inventories` VALUES (41, 6, 67); INSERT INTO `inventories` VALUES (41, 7, 55); INSERT INTO `inventories` VALUES (41, 8, 44); INSERT INTO `inventories` VALUES (42, 2, 122); INSERT INTO `inventories` VALUES (42, 5, 81); INSERT INTO `inventories` VALUES (42, 6, 69); INSERT INTO `inventories` VALUES (42, 7, 57); INSERT INTO `inventories` VALUES (42, 8, 46); INSERT INTO `inventories` VALUES (43, 2, 122); INSERT INTO `inventories` VALUES (43, 5, 81); INSERT INTO `inventories` VALUES (43, 6, 69); INSERT INTO `inventories` VALUES (43, 7, 58); INSERT INTO `inventories` VALUES (43, 8, 46); INSERT INTO `inventories` VALUES (44, 2, 122); INSERT INTO `inventories` VALUES (44, 5, 82); INSERT INTO `inventories` VALUES (44, 6, 70); INSERT INTO `inventories` VALUES (44, 7, 58); INSERT INTO `inventories` VALUES (44, 8, 47); INSERT INTO `inventories` VALUES (46, 3, 112); INSERT INTO `inventories` VALUES (46, 5, 90); INSERT INTO `inventories` VALUES (46, 6, 29); INSERT INTO `inventories` VALUES (46, 7, 18); INSERT INTO `inventories` VALUES (46, 8, 7); INSERT INTO `inventories` VALUES (46, 9, 6); INSERT INTO `inventories` VALUES (47, 3, 66); INSERT INTO `inventories` VALUES (47, 5, 44); INSERT INTO `inventories` VALUES (47, 6, 33); INSERT INTO `inventories` VALUES (47, 7, 22); INSERT INTO `inventories` VALUES (47, 8, 11); INSERT INTO `inventories` VALUES (47, 9, 0); INSERT INTO `inventories` VALUES (50, 2, 117); INSERT INTO `inventories` VALUES (50, 5, 69); INSERT INTO `inventories` VALUES (50, 6, 84); INSERT INTO `inventories` VALUES (50, 7, 58); INSERT INTO `inventories` VALUES (50, 8, 32); INSERT INTO `inventories` VALUES (54, 2, 110); INSERT INTO `inventories` VALUES (54, 4, 88); INSERT INTO `inventories` VALUES (54, 6, 66); INSERT INTO `inventories` VALUES (54, 8, 44); INSERT INTO `inventories` VALUES (54, 9, 33); INSERT INTO `inventories` VALUES (56, 6, 58); INSERT INTO `inventories` VALUES (57, 6, 66); INSERT INTO `inventories` VALUES (62, 2, 149); INSERT INTO `inventories` VALUES (62, 4, 74); INSERT INTO `inventories` VALUES (62, 6, 30); INSERT INTO `inventories` VALUES (62, 8, 47); INSERT INTO `inventories` VALUES (62, 9, 32); INSERT INTO `inventories` VALUES (63, 2, 149); INSERT INTO `inventories` VALUES (63, 4, 74); INSERT INTO `inventories` VALUES (63, 6, 30); INSERT INTO `inventories` VALUES (63, 8, 47); INSERT INTO `inventories` VALUES (63, 9, 33); INSERT INTO `inventories` VALUES (67, 2, 154); INSERT INTO `inventories` VALUES (67, 4, 76); INSERT INTO `inventories` VALUES (67, 6, 34); INSERT INTO `inventories` VALUES (67, 8, 49); INSERT INTO `inventories` VALUES (67, 9, 34); INSERT INTO `inventories` VALUES (68, 2, 154); INSERT INTO `inventories` VALUES (68, 4, 76); INSERT INTO `inventories` VALUES (68, 6, 35); INSERT INTO `inventories` VALUES (68, 8, 49); INSERT INTO `inventories` VALUES (68, 9, 34); INSERT INTO `inventories` VALUES (69, 2, 154); INSERT INTO `inventories` VALUES (69, 4, 76); INSERT INTO `inventories` VALUES (69, 6, 35); INSERT INTO `inventories` VALUES (69, 8, 50); INSERT INTO `inventories` VALUES (69, 9, 35); INSERT INTO `inventories` VALUES (70, 2, 155); INSERT INTO `inventories` VALUES (70, 4, 76); INSERT INTO `inventories` VALUES (70, 6, 35); INSERT INTO `inventories` VALUES (70, 8, 50); INSERT INTO `inventories` VALUES (70, 9, 35); INSERT INTO `inventories` VALUES (71, 2, 155); INSERT INTO `inventories` VALUES (71, 4, 76); INSERT INTO `inventories` VALUES (71, 6, 35); INSERT INTO `inventories` VALUES (71, 8, 50); INSERT INTO `inventories` VALUES (71, 9, 35); INSERT INTO `inventories` VALUES (72, 2, 155); INSERT INTO `inventories` VALUES (72, 4, 77); INSERT INTO `inventories` VALUES (72, 6, 35); INSERT INTO `inventories` VALUES (72, 8, 50); INSERT INTO `inventories` VALUES (72, 9, 35); INSERT INTO `inventories` VALUES (73, 2, 111); INSERT INTO `inventories` VALUES (73, 4, 87); INSERT INTO `inventories` VALUES (73, 6, 63); INSERT INTO `inventories` VALUES (73, 8, 39); INSERT INTO `inventories` VALUES (73, 9, 27); INSERT INTO `inventories` VALUES (74, 2, 111); INSERT INTO `inventories` VALUES (74, 4, 87); INSERT INTO `inventories` VALUES (74, 6, 63); INSERT INTO `inventories` VALUES (74, 8, 39); INSERT INTO `inventories` VALUES (74, 9, 27); INSERT INTO `inventories` VALUES (76, 2, 112); INSERT INTO `inventories` VALUES (76, 4, 88); INSERT INTO `inventories` VALUES (76, 6, 64); INSERT INTO `inventories` VALUES (76, 8, 40); INSERT INTO `inventories` VALUES (76, 9, 28); INSERT INTO `inventories` VALUES (78, 2, 113); INSERT INTO `inventories` VALUES (78, 4, 89); INSERT INTO `inventories` VALUES (78, 6, 65); INSERT INTO `inventories` VALUES (78, 8, 41); INSERT INTO `inventories` VALUES (78, 9, 29); INSERT INTO `inventories` VALUES (79, 2, 113); INSERT INTO `inventories` VALUES (79, 4, 89); INSERT INTO `inventories` VALUES (79, 6, 65); INSERT INTO `inventories` VALUES (79, 8, 41); INSERT INTO `inventories` VALUES (79, 9, 29); INSERT INTO `inventories` VALUES (80, 1, 125); INSERT INTO `inventories` VALUES (80, 2, 113); INSERT INTO `inventories` VALUES (80, 3, 101); INSERT INTO `inventories` VALUES (80, 4, 89); INSERT INTO `inventories` VALUES (80, 5, 77); INSERT INTO `inventories` VALUES (80, 6, 65); INSERT INTO `inventories` VALUES (80, 7, 53); INSERT INTO `inventories` VALUES (80, 8, 41); INSERT INTO `inventories` VALUES (80, 9, 29); INSERT INTO `inventories` VALUES (84, 6, 69); INSERT INTO `inventories` VALUES (84, 8, 45); INSERT INTO `inventories` VALUES (84, 9, 33); INSERT INTO `inventories` VALUES (87, 1, 131); INSERT INTO `inventories` VALUES (87, 2, 119); INSERT INTO `inventories` VALUES (87, 3, 107); INSERT INTO `inventories` VALUES (87, 4, 95); INSERT INTO `inventories` VALUES (87, 5, 83); INSERT INTO `inventories` VALUES (87, 6, 71); INSERT INTO `inventories` VALUES (87, 7, 59); INSERT INTO `inventories` VALUES (87, 8, 47); INSERT INTO `inventories` VALUES (87, 9, 35); INSERT INTO `inventories` VALUES (88, 1, 117); INSERT INTO `inventories` VALUES (88, 2, 167); INSERT INTO `inventories` VALUES (88, 3, 118); INSERT INTO `inventories` VALUES (88, 4, 86); INSERT INTO `inventories` VALUES (88, 5, 62); INSERT INTO `inventories` VALUES (88, 6, 44); INSERT INTO `inventories` VALUES (88, 7, 27); INSERT INTO `inventories` VALUES (88, 8, 12); INSERT INTO `inventories` VALUES (88, 9, 7); INSERT INTO `inventories` VALUES (89, 1, 118); INSERT INTO `inventories` VALUES (89, 2, 167); INSERT INTO `inventories` VALUES (89, 3, 118); INSERT INTO `inventories` VALUES (89, 4, 86); INSERT INTO `inventories` VALUES (89, 5, 63); INSERT INTO `inventories` VALUES (89, 6, 45); INSERT INTO `inventories` VALUES (89, 7, 27); INSERT INTO `inventories` VALUES (89, 8, 12); INSERT INTO `inventories` VALUES (89, 9, 8); INSERT INTO `inventories` VALUES (90, 1, 118); INSERT INTO `inventories` VALUES (90, 2, 167); INSERT INTO `inventories` VALUES (90, 3, 118); INSERT INTO `inventories` VALUES (90, 4, 86); INSERT INTO `inventories` VALUES (90, 5, 63); INSERT INTO `inventories` VALUES (90, 6, 45); INSERT INTO `inventories` VALUES (90, 7, 27); INSERT INTO `inventories` VALUES (90, 8, 13); INSERT INTO `inventories` VALUES (90, 9, 8); INSERT INTO `inventories` VALUES (91, 3, 94); INSERT INTO `inventories` VALUES (91, 5, 70); INSERT INTO `inventories` VALUES (91, 6, 58); INSERT INTO `inventories` VALUES (91, 7, 46); INSERT INTO `inventories` VALUES (91, 8, 34); INSERT INTO `inventories` VALUES (91, 9, 22); INSERT INTO `inventories` VALUES (94, 2, 91); INSERT INTO `inventories` VALUES (94, 5, 85); INSERT INTO `inventories` VALUES (94, 6, 71); INSERT INTO `inventories` VALUES (94, 7, 57); INSERT INTO `inventories` VALUES (94, 8, 44); INSERT INTO `inventories` VALUES (95, 6, 60); INSERT INTO `inventories` VALUES (96, 6, 60); INSERT INTO `inventories` VALUES (98, 3, 69); INSERT INTO `inventories` VALUES (98, 5, 86); INSERT INTO `inventories` VALUES (98, 6, 72); INSERT INTO `inventories` VALUES (98, 7, 58); INSERT INTO `inventories` VALUES (98, 8, 45); INSERT INTO `inventories` VALUES (98, 9, 32); INSERT INTO `inventories` VALUES (99, 2, 94); INSERT INTO `inventories` VALUES (99, 5, 88); INSERT INTO `inventories` VALUES (99, 6, 73); INSERT INTO `inventories` VALUES (99, 7, 60); INSERT INTO `inventories` VALUES (99, 8, 47); INSERT INTO `inventories` VALUES (100, 2, 94); INSERT INTO `inventories` VALUES (100, 5, 88); INSERT INTO `inventories` VALUES (100, 6, 74); INSERT INTO `inventories` VALUES (100, 7, 60); INSERT INTO `inventories` VALUES (100, 8, 47); INSERT INTO `inventories` VALUES (101, 2, 173); INSERT INTO `inventories` VALUES (101, 4, 95); INSERT INTO `inventories` VALUES (101, 6, 51); INSERT INTO `inventories` VALUES (101, 8, 18); INSERT INTO `inventories` VALUES (101, 9, 3); INSERT INTO `inventories` VALUES (102, 3, 73); INSERT INTO `inventories` VALUES (102, 5, 90); INSERT INTO `inventories` VALUES (102, 6, 76); INSERT INTO `inventories` VALUES (102, 7, 62); INSERT INTO `inventories` VALUES (102, 8, 49); INSERT INTO `inventories` VALUES (102, 9, 36); INSERT INTO `inventories` VALUES (103, 1, 125); INSERT INTO `inventories` VALUES (103, 2, 178); INSERT INTO `inventories` VALUES (103, 3, 126); INSERT INTO `inventories` VALUES (103, 4, 97); INSERT INTO `inventories` VALUES (103, 5, 73); INSERT INTO `inventories` VALUES (103, 6, 53); INSERT INTO `inventories` VALUES (103, 7, 35); INSERT INTO `inventories` VALUES (103, 8, 20); INSERT INTO `inventories` VALUES (103, 9, 5); INSERT INTO `inventories` VALUES (104, 2, 81); INSERT INTO `inventories` VALUES (104, 5, 84); INSERT INTO `inventories` VALUES (104, 6, 71); INSERT INTO `inventories` VALUES (104, 7, 58); INSERT INTO `inventories` VALUES (104, 8, 46); INSERT INTO `inventories` VALUES (105, 1, 126); INSERT INTO `inventories` VALUES (105, 2, 178); INSERT INTO `inventories` VALUES (105, 3, 126); INSERT INTO `inventories` VALUES (105, 4, 97); INSERT INTO `inventories` VALUES (105, 5, 74); INSERT INTO `inventories` VALUES (105, 6, 53); INSERT INTO `inventories` VALUES (105, 7, 35); INSERT INTO `inventories` VALUES (105, 8, 20); INSERT INTO `inventories` VALUES (105, 9, 6); INSERT INTO `inventories` VALUES (106, 2, 178); INSERT INTO `inventories` VALUES (106, 4, 97); INSERT INTO `inventories` VALUES (106, 6, 53); INSERT INTO `inventories` VALUES (106, 8, 21); INSERT INTO `inventories` VALUES (106, 9, 6); INSERT INTO `inventories` VALUES (107, 2, 178); INSERT INTO `inventories` VALUES (107, 4, 97); INSERT INTO `inventories` VALUES (107, 6, 53); INSERT INTO `inventories` VALUES (107, 8, 21); INSERT INTO `inventories` VALUES (107, 9, 6); INSERT INTO `inventories` VALUES (108, 1, 126); INSERT INTO `inventories` VALUES (108, 2, 179); INSERT INTO `inventories` VALUES (108, 3, 127); INSERT INTO `inventories` VALUES (108, 4, 98); INSERT INTO `inventories` VALUES (108, 5, 74); INSERT INTO `inventories` VALUES (108, 6, 54); INSERT INTO `inventories` VALUES (108, 7, 36); INSERT INTO `inventories` VALUES (108, 8, 21); INSERT INTO `inventories` VALUES (108, 9, 6); INSERT INTO `inventories` VALUES (109, 2, 179); INSERT INTO `inventories` VALUES (109, 4, 98); INSERT INTO `inventories` VALUES (109, 6, 54); INSERT INTO `inventories` VALUES (109, 8, 21); INSERT INTO `inventories` VALUES (109, 9, 6); INSERT INTO `inventories` VALUES (110, 1, 127); INSERT INTO `inventories` VALUES (110, 2, 179); INSERT INTO `inventories` VALUES (110, 3, 127); INSERT INTO `inventories` VALUES (110, 4, 98); INSERT INTO `inventories` VALUES (110, 5, 75); INSERT INTO `inventories` VALUES (110, 6, 54); INSERT INTO `inventories` VALUES (110, 7, 36); INSERT INTO `inventories` VALUES (110, 8, 22); INSERT INTO `inventories` VALUES (110, 9, 7); INSERT INTO `inventories` VALUES (114, 1, 128); INSERT INTO `inventories` VALUES (114, 2, 180); INSERT INTO `inventories` VALUES (114, 3, 131); INSERT INTO `inventories` VALUES (114, 4, 99); INSERT INTO `inventories` VALUES (114, 5, 76); INSERT INTO `inventories` VALUES (114, 6, 55); INSERT INTO `inventories` VALUES (114, 7, 37); INSERT INTO `inventories` VALUES (114, 8, 23); INSERT INTO `inventories` VALUES (114, 9, 8); INSERT INTO `inventories` VALUES (115, 2, 181); INSERT INTO `inventories` VALUES (115, 4, 100); INSERT INTO `inventories` VALUES (115, 6, 56); INSERT INTO `inventories` VALUES (115, 8, 24); INSERT INTO `inventories` VALUES (115, 9, 9); INSERT INTO `inventories` VALUES (116, 2, 182); INSERT INTO `inventories` VALUES (116, 4, 100); INSERT INTO `inventories` VALUES (116, 6, 56); INSERT INTO `inventories` VALUES (116, 8, 24); INSERT INTO `inventories` VALUES (116, 9, 9); INSERT INTO `inventories` VALUES (117, 2, 182); INSERT INTO `inventories` VALUES (117, 4, 101); INSERT INTO `inventories` VALUES (117, 6, 57); INSERT INTO `inventories` VALUES (117, 8, 24); INSERT INTO `inventories` VALUES (117, 9, 9); INSERT INTO `inventories` VALUES (119, 2, 183); INSERT INTO `inventories` VALUES (119, 4, 102); INSERT INTO `inventories` VALUES (119, 6, 58); INSERT INTO `inventories` VALUES (119, 8, 25); INSERT INTO `inventories` VALUES (119, 9, 10); INSERT INTO `inventories` VALUES (120, 2, 183); INSERT INTO `inventories` VALUES (120, 4, 102); INSERT INTO `inventories` VALUES (120, 6, 58); INSERT INTO `inventories` VALUES (120, 8, 25); INSERT INTO `inventories` VALUES (120, 9, 10); INSERT INTO `inventories` VALUES (121, 2, 183); INSERT INTO `inventories` VALUES (121, 4, 102); INSERT INTO `inventories` VALUES (121, 6, 58); INSERT INTO `inventories` VALUES (121, 8, 25); INSERT INTO `inventories` VALUES (121, 9, 10); INSERT INTO `inventories` VALUES (122, 2, 183); INSERT INTO `inventories` VALUES (122, 4, 102); INSERT INTO `inventories` VALUES (122, 6, 58); INSERT INTO `inventories` VALUES (122, 8, 26); INSERT INTO `inventories` VALUES (122, 9, 11); INSERT INTO `inventories` VALUES (123, 1, 131); INSERT INTO `inventories` VALUES (123, 2, 184); INSERT INTO `inventories` VALUES (123, 3, 135); INSERT INTO `inventories` VALUES (123, 4, 103); INSERT INTO `inventories` VALUES (123, 5, 79); INSERT INTO `inventories` VALUES (123, 6, 59); INSERT INTO `inventories` VALUES (123, 7, 41); INSERT INTO `inventories` VALUES (123, 8, 26); INSERT INTO `inventories` VALUES (123, 9, 11); INSERT INTO `inventories` VALUES (124, 2, 184); INSERT INTO `inventories` VALUES (124, 4, 103); INSERT INTO `inventories` VALUES (124, 6, 59); INSERT INTO `inventories` VALUES (124, 8, 26); INSERT INTO `inventories` VALUES (124, 9, 11); INSERT INTO `inventories` VALUES (125, 2, 184); INSERT INTO `inventories` VALUES (125, 4, 103); INSERT INTO `inventories` VALUES (125, 6, 59); INSERT INTO `inventories` VALUES (125, 8, 26); INSERT INTO `inventories` VALUES (125, 9, 11); INSERT INTO `inventories` VALUES (126, 2, 184); INSERT INTO `inventories` VALUES (126, 4, 103); INSERT INTO `inventories` VALUES (126, 6, 59); INSERT INTO `inventories` VALUES (126, 8, 26); INSERT INTO `inventories` VALUES (126, 9, 12); INSERT INTO `inventories` VALUES (128, 2, 185); INSERT INTO `inventories` VALUES (128, 4, 103); INSERT INTO `inventories` VALUES (128, 6, 59); INSERT INTO `inventories` VALUES (128, 8, 27); INSERT INTO `inventories` VALUES (128, 9, 12); INSERT INTO `inventories` VALUES (129, 2, 185); INSERT INTO `inventories` VALUES (129, 4, 104); INSERT INTO `inventories` VALUES (129, 6, 60); INSERT INTO `inventories` VALUES (129, 8, 27); INSERT INTO `inventories` VALUES (129, 9, 12); INSERT INTO `inventories` VALUES (130, 2, 88); INSERT INTO `inventories` VALUES (130, 5, 42); INSERT INTO `inventories` VALUES (130, 6, 78); INSERT INTO `inventories` VALUES (130, 7, 66); INSERT INTO `inventories` VALUES (130, 8, 53); INSERT INTO `inventories` VALUES (131, 2, 88); INSERT INTO `inventories` VALUES (131, 5, 42); INSERT INTO `inventories` VALUES (131, 6, 29); INSERT INTO `inventories` VALUES (131, 7, 66); INSERT INTO `inventories` VALUES (131, 8, 53); INSERT INTO `inventories` VALUES (132, 1, 133); INSERT INTO `inventories` VALUES (132, 2, 185); INSERT INTO `inventories` VALUES (132, 3, 136); INSERT INTO `inventories` VALUES (132, 4, 104); INSERT INTO `inventories` VALUES (132, 5, 81); INSERT INTO `inventories` VALUES (132, 6, 60); INSERT INTO `inventories` VALUES (132, 7, 45); INSERT INTO `inventories` VALUES (132, 8, 28); INSERT INTO `inventories` VALUES (132, 9, 13); INSERT INTO `inventories` VALUES (133, 1, 133); INSERT INTO `inventories` VALUES (133, 2, 185); INSERT INTO `inventories` VALUES (133, 3, 136); INSERT INTO `inventories` VALUES (133, 4, 104); INSERT INTO `inventories` VALUES (133, 5, 81); INSERT INTO `inventories` VALUES (133, 6, 60); INSERT INTO `inventories` VALUES (133, 7, 45); INSERT INTO `inventories` VALUES (133, 8, 28); INSERT INTO `inventories` VALUES (133, 9, 13); INSERT INTO `inventories` VALUES (134, 2, 89); INSERT INTO `inventories` VALUES (134, 5, 42); INSERT INTO `inventories` VALUES (134, 6, 29); INSERT INTO `inventories` VALUES (134, 7, 17); INSERT INTO `inventories` VALUES (134, 8, 54); INSERT INTO `inventories` VALUES (135, 2, 89); INSERT INTO `inventories` VALUES (135, 5, 43); INSERT INTO `inventories` VALUES (135, 6, 29); INSERT INTO `inventories` VALUES (135, 7, 17); INSERT INTO `inventories` VALUES (135, 8, 54); INSERT INTO `inventories` VALUES (136, 2, 186); INSERT INTO `inventories` VALUES (136, 4, 105); INSERT INTO `inventories` VALUES (136, 6, 61); INSERT INTO `inventories` VALUES (136, 8, 28); INSERT INTO `inventories` VALUES (136, 9, 14); INSERT INTO `inventories` VALUES (137, 6, 65); INSERT INTO `inventories` VALUES (137, 8, 29); INSERT INTO `inventories` VALUES (137, 9, 15); INSERT INTO `inventories` VALUES (138, 2, 191); INSERT INTO `inventories` VALUES (138, 4, 107); INSERT INTO `inventories` VALUES (138, 6, 66); INSERT INTO `inventories` VALUES (138, 8, 31); INSERT INTO `inventories` VALUES (138, 9, 16); INSERT INTO `inventories` VALUES (139, 2, 93); INSERT INTO `inventories` VALUES (139, 5, 47); INSERT INTO `inventories` VALUES (139, 6, 34); INSERT INTO `inventories` VALUES (139, 7, 21); INSERT INTO `inventories` VALUES (139, 8, 8); INSERT INTO `inventories` VALUES (140, 2, 94); INSERT INTO `inventories` VALUES (140, 5, 47); INSERT INTO `inventories` VALUES (140, 6, 34); INSERT INTO `inventories` VALUES (140, 7, 21); INSERT INTO `inventories` VALUES (140, 8, 9); INSERT INTO `inventories` VALUES (141, 6, 68); INSERT INTO `inventories` VALUES (141, 8, 33); INSERT INTO `inventories` VALUES (141, 9, 18); INSERT INTO `inventories` VALUES (142, 1, 89); INSERT INTO `inventories` VALUES (142, 2, 194); INSERT INTO `inventories` VALUES (142, 3, 142); INSERT INTO `inventories` VALUES (142, 4, 110); INSERT INTO `inventories` VALUES (142, 5, 87); INSERT INTO `inventories` VALUES (142, 6, 69); INSERT INTO `inventories` VALUES (142, 7, 51); INSERT INTO `inventories` VALUES (142, 8, 34); INSERT INTO `inventories` VALUES (142, 9, 19); INSERT INTO `inventories` VALUES (144, 2, 95); INSERT INTO `inventories` VALUES (144, 5, 49); INSERT INTO `inventories` VALUES (144, 6, 36); INSERT INTO `inventories` VALUES (144, 7, 23); INSERT INTO `inventories` VALUES (144, 8, 10); INSERT INTO `inventories` VALUES (145, 2, 96); INSERT INTO `inventories` VALUES (145, 5, 49); INSERT INTO `inventories` VALUES (145, 6, 36); INSERT INTO `inventories` VALUES (145, 7, 23); INSERT INTO `inventories` VALUES (145, 8, 11); INSERT INTO `inventories` VALUES (146, 2, 96); INSERT INTO `inventories` VALUES (146, 5, 50); INSERT INTO `inventories` VALUES (146, 6, 37); INSERT INTO `inventories` VALUES (146, 7, 24); INSERT INTO `inventories` VALUES (146, 8, 11); INSERT INTO `inventories` VALUES (147, 2, 96); INSERT INTO `inventories` VALUES (147, 5, 50); INSERT INTO `inventories` VALUES (147, 6, 37); INSERT INTO `inventories` VALUES (147, 7, 24); INSERT INTO `inventories` VALUES (147, 8, 11); INSERT INTO `inventories` VALUES (148, 2, 97); INSERT INTO `inventories` VALUES (148, 5, 50); INSERT INTO `inventories` VALUES (148, 6, 37); INSERT INTO `inventories` VALUES (148, 7, 24); INSERT INTO `inventories` VALUES (148, 8, 12); INSERT INTO `inventories` VALUES (149, 2, 97); INSERT INTO `inventories` VALUES (149, 5, 50); INSERT INTO `inventories` VALUES (149, 6, 37); INSERT INTO `inventories` VALUES (149, 7, 24); INSERT INTO `inventories` VALUES (149, 8, 12); INSERT INTO `inventories` VALUES (150, 2, 101); INSERT INTO `inventories` VALUES (150, 5, 54); INSERT INTO `inventories` VALUES (150, 6, 41); INSERT INTO `inventories` VALUES (150, 7, 28); INSERT INTO `inventories` VALUES (150, 8, 15); INSERT INTO `inventories` VALUES (151, 2, 101); INSERT INTO `inventories` VALUES (151, 5, 54); INSERT INTO `inventories` VALUES (151, 6, 41); INSERT INTO `inventories` VALUES (151, 7, 28); INSERT INTO `inventories` VALUES (151, 8, 15); INSERT INTO `inventories` VALUES (152, 2, 101); INSERT INTO `inventories` VALUES (152, 5, 54); INSERT INTO `inventories` VALUES (152, 6, 41); INSERT INTO `inventories` VALUES (152, 7, 28); INSERT INTO `inventories` VALUES (152, 8, 15); INSERT INTO `inventories` VALUES (157, 6, 42); INSERT INTO `inventories` VALUES (159, 3, 87); INSERT INTO `inventories` VALUES (159, 5, 63); INSERT INTO `inventories` VALUES (159, 6, 51); INSERT INTO `inventories` VALUES (159, 7, 39); INSERT INTO `inventories` VALUES (159, 8, 27); INSERT INTO `inventories` VALUES (159, 9, 15); INSERT INTO `inventories` VALUES (160, 3, 93); INSERT INTO `inventories` VALUES (160, 5, 69); INSERT INTO `inventories` VALUES (160, 6, 57); INSERT INTO `inventories` VALUES (160, 7, 45); INSERT INTO `inventories` VALUES (160, 8, 33); INSERT INTO `inventories` VALUES (160, 9, 21); INSERT INTO `inventories` VALUES (161, 1, 132); INSERT INTO `inventories` VALUES (161, 2, 120); INSERT INTO `inventories` VALUES (161, 3, 108); INSERT INTO `inventories` VALUES (161, 4, 96); INSERT INTO `inventories` VALUES (161, 5, 84); INSERT INTO `inventories` VALUES (161, 6, 72); INSERT INTO `inventories` VALUES (161, 7, 60); INSERT INTO `inventories` VALUES (161, 8, 48); INSERT INTO `inventories` VALUES (161, 9, 36); INSERT INTO `inventories` VALUES (163, 3, 107); INSERT INTO `inventories` VALUES (163, 5, 83); INSERT INTO `inventories` VALUES (163, 6, 71); INSERT INTO `inventories` VALUES (163, 7, 59); INSERT INTO `inventories` VALUES (163, 8, 47); INSERT INTO `inventories` VALUES (163, 9, 35); INSERT INTO `inventories` VALUES (166, 2, 138); INSERT INTO `inventories` VALUES (166, 4, 114); INSERT INTO `inventories` VALUES (166, 6, 90); INSERT INTO `inventories` VALUES (166, 8, 66); INSERT INTO `inventories` VALUES (166, 9, 54); INSERT INTO `inventories` VALUES (168, 2, 128); INSERT INTO `inventories` VALUES (168, 5, 92); INSERT INTO `inventories` VALUES (168, 6, 80); INSERT INTO `inventories` VALUES (168, 7, 68); INSERT INTO `inventories` VALUES (168, 8, 56); INSERT INTO `inventories` VALUES (170, 6, 81); INSERT INTO `inventories` VALUES (172, 6, 85); INSERT INTO `inventories` VALUES (173, 6, 94); INSERT INTO `inventories` VALUES (174, 1, 170); INSERT INTO `inventories` VALUES (174, 2, 158); INSERT INTO `inventories` VALUES (174, 3, 146); INSERT INTO `inventories` VALUES (174, 4, 134); INSERT INTO `inventories` VALUES (174, 5, 122); INSERT INTO `inventories` VALUES (174, 6, 110); INSERT INTO `inventories` VALUES (174, 7, 98); INSERT INTO `inventories` VALUES (174, 8, 86); INSERT INTO `inventories` VALUES (174, 9, 74); INSERT INTO `inventories` VALUES (175, 1, 170); INSERT INTO `inventories` VALUES (175, 2, 158); INSERT INTO `inventories` VALUES (175, 3, 146); INSERT INTO `inventories` VALUES (175, 4, 134); INSERT INTO `inventories` VALUES (175, 5, 122); INSERT INTO `inventories` VALUES (175, 6, 110); INSERT INTO `inventories` VALUES (175, 7, 98); INSERT INTO `inventories` VALUES (175, 8, 86); INSERT INTO `inventories` VALUES (175, 9, 74); INSERT INTO `inventories` VALUES (182, 1, 175); INSERT INTO `inventories` VALUES (182, 2, 177); INSERT INTO `inventories` VALUES (182, 3, 245); INSERT INTO `inventories` VALUES (182, 4, 210); INSERT INTO `inventories` VALUES (182, 5, 184); INSERT INTO `inventories` VALUES (182, 6, 163); INSERT INTO `inventories` VALUES (182, 7, 143); INSERT INTO `inventories` VALUES (182, 8, 128); INSERT INTO `inventories` VALUES (182, 9, 110); INSERT INTO `inventories` VALUES (184, 1, 175); INSERT INTO `inventories` VALUES (184, 2, 178); INSERT INTO `inventories` VALUES (184, 3, 246); INSERT INTO `inventories` VALUES (184, 4, 211); INSERT INTO `inventories` VALUES (184, 5, 184); INSERT INTO `inventories` VALUES (184, 6, 164); INSERT INTO `inventories` VALUES (184, 7, 143); INSERT INTO `inventories` VALUES (184, 8, 128); INSERT INTO `inventories` VALUES (184, 9, 111); INSERT INTO `inventories` VALUES (185, 1, 176); INSERT INTO `inventories` VALUES (185, 2, 178); INSERT INTO `inventories` VALUES (185, 3, 246); INSERT INTO `inventories` VALUES (185, 4, 211); INSERT INTO `inventories` VALUES (185, 5, 185); INSERT INTO `inventories` VALUES (185, 6, 164); INSERT INTO `inventories` VALUES (185, 7, 144); INSERT INTO `inventories` VALUES (185, 8, 129); INSERT INTO `inventories` VALUES (185, 9, 111); INSERT INTO `inventories` VALUES (188, 2, 171); INSERT INTO `inventories` VALUES (188, 4, 219); INSERT INTO `inventories` VALUES (188, 6, 172); INSERT INTO `inventories` VALUES (188, 8, 137); INSERT INTO `inventories` VALUES (188, 9, 119); INSERT INTO `inventories` VALUES (189, 2, 172); INSERT INTO `inventories` VALUES (189, 4, 219); INSERT INTO `inventories` VALUES (189, 6, 172); INSERT INTO `inventories` VALUES (189, 8, 137); INSERT INTO `inventories` VALUES (189, 9, 119); INSERT INTO `inventories` VALUES (190, 2, 172); INSERT INTO `inventories` VALUES (190, 4, 223); INSERT INTO `inventories` VALUES (190, 6, 173); INSERT INTO `inventories` VALUES (190, 8, 137); INSERT INTO `inventories` VALUES (190, 9, 120); INSERT INTO `inventories` VALUES (191, 2, 173); INSERT INTO `inventories` VALUES (191, 4, 223); INSERT INTO `inventories` VALUES (191, 6, 173); INSERT INTO `inventories` VALUES (191, 8, 138); INSERT INTO `inventories` VALUES (191, 9, 120); INSERT INTO `inventories` VALUES (193, 2, 173); INSERT INTO `inventories` VALUES (193, 4, 223); INSERT INTO `inventories` VALUES (193, 6, 174); INSERT INTO `inventories` VALUES (193, 8, 138); INSERT INTO `inventories` VALUES (193, 9, 121); INSERT INTO `inventories` VALUES (195, 2, 174); INSERT INTO `inventories` VALUES (195, 4, 224); INSERT INTO `inventories` VALUES (195, 6, 175); INSERT INTO `inventories` VALUES (195, 8, 139); INSERT INTO `inventories` VALUES (195, 9, 122); INSERT INTO `inventories` VALUES (196, 2, 174); INSERT INTO `inventories` VALUES (196, 4, 225); INSERT INTO `inventories` VALUES (196, 6, 175); INSERT INTO `inventories` VALUES (196, 8, 139); INSERT INTO `inventories` VALUES (196, 9, 122); INSERT INTO `inventories` VALUES (198, 2, 175); INSERT INTO `inventories` VALUES (198, 4, 225); INSERT INTO `inventories` VALUES (198, 6, 176); INSERT INTO `inventories` VALUES (198, 8, 140); INSERT INTO `inventories` VALUES (198, 9, 122); INSERT INTO `inventories` VALUES (199, 2, 176); INSERT INTO `inventories` VALUES (199, 4, 226); INSERT INTO `inventories` VALUES (199, 6, 176); INSERT INTO `inventories` VALUES (199, 8, 141); INSERT INTO `inventories` VALUES (199, 9, 123); INSERT INTO `inventories` VALUES (200, 2, 176); INSERT INTO `inventories` VALUES (200, 4, 226); INSERT INTO `inventories` VALUES (200, 6, 177); INSERT INTO `inventories` VALUES (200, 8, 141); INSERT INTO `inventories` VALUES (200, 9, 123); INSERT INTO `inventories` VALUES (201, 2, 176); INSERT INTO `inventories` VALUES (201, 4, 227); INSERT INTO `inventories` VALUES (201, 6, 177); INSERT INTO `inventories` VALUES (201, 8, 142); INSERT INTO `inventories` VALUES (201, 9, 124); INSERT INTO `inventories` VALUES (203, 2, 177); INSERT INTO `inventories` VALUES (203, 4, 227); INSERT INTO `inventories` VALUES (203, 6, 177); INSERT INTO `inventories` VALUES (203, 8, 142); INSERT INTO `inventories` VALUES (203, 9, 124); INSERT INTO `inventories` VALUES (204, 2, 177); INSERT INTO `inventories` VALUES (204, 4, 227); INSERT INTO `inventories` VALUES (204, 6, 178); INSERT INTO `inventories` VALUES (204, 8, 142); INSERT INTO `inventories` VALUES (204, 9, 125); INSERT INTO `inventories` VALUES (205, 2, 177); INSERT INTO `inventories` VALUES (205, 4, 228); INSERT INTO `inventories` VALUES (205, 6, 178); INSERT INTO `inventories` VALUES (205, 8, 142); INSERT INTO `inventories` VALUES (205, 9, 125); INSERT INTO `inventories` VALUES (207, 1, 205); INSERT INTO `inventories` VALUES (207, 2, 193); INSERT INTO `inventories` VALUES (207, 3, 181); INSERT INTO `inventories` VALUES (207, 4, 169); INSERT INTO `inventories` VALUES (207, 5, 157); INSERT INTO `inventories` VALUES (207, 6, 145); INSERT INTO `inventories` VALUES (207, 7, 133); INSERT INTO `inventories` VALUES (207, 8, 121); INSERT INTO `inventories` VALUES (207, 9, 109); INSERT INTO `inventories` VALUES (210, 2, 194); INSERT INTO `inventories` VALUES (210, 4, 170); INSERT INTO `inventories` VALUES (210, 6, 146); INSERT INTO `inventories` VALUES (210, 8, 122); INSERT INTO `inventories` VALUES (210, 9, 110); INSERT INTO `inventories` VALUES (211, 2, 195); INSERT INTO `inventories` VALUES (211, 4, 171); INSERT INTO `inventories` VALUES (211, 6, 147); INSERT INTO `inventories` VALUES (211, 8, 123); INSERT INTO `inventories` VALUES (211, 9, 111); INSERT INTO `inventories` VALUES (212, 2, 195); INSERT INTO `inventories` VALUES (212, 4, 171); INSERT INTO `inventories` VALUES (212, 6, 147); INSERT INTO `inventories` VALUES (212, 8, 123); INSERT INTO `inventories` VALUES (212, 9, 111); INSERT INTO `inventories` VALUES (214, 2, 196); INSERT INTO `inventories` VALUES (214, 4, 172); INSERT INTO `inventories` VALUES (214, 6, 148); INSERT INTO `inventories` VALUES (214, 8, 124); INSERT INTO `inventories` VALUES (214, 9, 112); INSERT INTO `inventories` VALUES (216, 1, 209); INSERT INTO `inventories` VALUES (216, 2, 197); INSERT INTO `inventories` VALUES (216, 3, 185); INSERT INTO `inventories` VALUES (216, 4, 173); INSERT INTO `inventories` VALUES (216, 5, 161); INSERT INTO `inventories` VALUES (216, 6, 149); INSERT INTO `inventories` VALUES (216, 7, 137); INSERT INTO `inventories` VALUES (216, 8, 125); INSERT INTO `inventories` VALUES (216, 9, 113); INSERT INTO `inventories` VALUES (217, 6, 149); INSERT INTO `inventories` VALUES (217, 8, 125); INSERT INTO `inventories` VALUES (217, 9, 113); INSERT INTO `inventories` VALUES (218, 2, 198); INSERT INTO `inventories` VALUES (218, 4, 174); INSERT INTO `inventories` VALUES (218, 6, 150); INSERT INTO `inventories` VALUES (218, 8, 126); INSERT INTO `inventories` VALUES (218, 9, 114); INSERT INTO `inventories` VALUES (220, 1, 196); INSERT INTO `inventories` VALUES (220, 2, 184); INSERT INTO `inventories` VALUES (220, 3, 272); INSERT INTO `inventories` VALUES (220, 4, 234); INSERT INTO `inventories` VALUES (220, 5, 208); INSERT INTO `inventories` VALUES (220, 6, 185); INSERT INTO `inventories` VALUES (220, 7, 167); INSERT INTO `inventories` VALUES (220, 8, 149); INSERT INTO `inventories` VALUES (220, 9, 134); INSERT INTO `inventories` VALUES (221, 1, 197); INSERT INTO `inventories` VALUES (221, 2, 185); INSERT INTO `inventories` VALUES (221, 3, 273); INSERT INTO `inventories` VALUES (221, 4, 235); INSERT INTO `inventories` VALUES (221, 5, 209); INSERT INTO `inventories` VALUES (221, 6, 185); INSERT INTO `inventories` VALUES (221, 7, 168); INSERT INTO `inventories` VALUES (221, 8, 150); INSERT INTO `inventories` VALUES (221, 9, 135); INSERT INTO `inventories` VALUES (222, 1, 197); INSERT INTO `inventories` VALUES (222, 2, 185); INSERT INTO `inventories` VALUES (222, 3, 273); INSERT INTO `inventories` VALUES (222, 4, 235); INSERT INTO `inventories` VALUES (222, 5, 209); INSERT INTO `inventories` VALUES (222, 6, 186); INSERT INTO `inventories` VALUES (222, 7, 168); INSERT INTO `inventories` VALUES (222, 8, 150); INSERT INTO `inventories` VALUES (222, 9, 135); INSERT INTO `inventories` VALUES (223, 1, 197); INSERT INTO `inventories` VALUES (223, 2, 185); INSERT INTO `inventories` VALUES (223, 3, 273); INSERT INTO `inventories` VALUES (223, 4, 236); INSERT INTO `inventories` VALUES (223, 5, 209); INSERT INTO `inventories` VALUES (223, 6, 186); INSERT INTO `inventories` VALUES (223, 7, 168); INSERT INTO `inventories` VALUES (223, 8, 151); INSERT INTO `inventories` VALUES (223, 9, 136); INSERT INTO `inventories` VALUES (227, 2, 189); INSERT INTO `inventories` VALUES (227, 6, 141); INSERT INTO `inventories` VALUES (228, 2, 189); INSERT INTO `inventories` VALUES (228, 6, 141); INSERT INTO `inventories` VALUES (229, 2, 212); INSERT INTO `inventories` VALUES (229, 5, 163); INSERT INTO `inventories` VALUES (229, 6, 149); INSERT INTO `inventories` VALUES (229, 7, 136); INSERT INTO `inventories` VALUES (229, 8, 123); INSERT INTO `inventories` VALUES (230, 2, 213); INSERT INTO `inventories` VALUES (230, 5, 163); INSERT INTO `inventories` VALUES (230, 6, 149); INSERT INTO `inventories` VALUES (230, 7, 136); INSERT INTO `inventories` VALUES (230, 8, 124); INSERT INTO `inventories` VALUES (231, 2, 213); INSERT INTO `inventories` VALUES (231, 5, 163); INSERT INTO `inventories` VALUES (231, 6, 150); INSERT INTO `inventories` VALUES (231, 7, 136); INSERT INTO `inventories` VALUES (231, 8, 124); INSERT INTO `inventories` VALUES (232, 2, 213); INSERT INTO `inventories` VALUES (232, 5, 163); INSERT INTO `inventories` VALUES (232, 6, 150); INSERT INTO `inventories` VALUES (232, 7, 137); INSERT INTO `inventories` VALUES (232, 8, 124); INSERT INTO `inventories` VALUES (233, 2, 213); INSERT INTO `inventories` VALUES (233, 5, 164); INSERT INTO `inventories` VALUES (233, 6, 150); INSERT INTO `inventories` VALUES (233, 7, 137); INSERT INTO `inventories` VALUES (233, 8, 124); INSERT INTO `inventories` VALUES (234, 2, 213); INSERT INTO `inventories` VALUES (234, 5, 164); INSERT INTO `inventories` VALUES (234, 6, 150); INSERT INTO `inventories` VALUES (234, 7, 137); INSERT INTO `inventories` VALUES (234, 8, 124); INSERT INTO `inventories` VALUES (235, 2, 214); INSERT INTO `inventories` VALUES (235, 5, 164); INSERT INTO `inventories` VALUES (235, 6, 150); INSERT INTO `inventories` VALUES (235, 7, 137); INSERT INTO `inventories` VALUES (235, 8, 125); INSERT INTO `inventories` VALUES (236, 2, 214); INSERT INTO `inventories` VALUES (236, 5, 164); INSERT INTO `inventories` VALUES (236, 6, 151); INSERT INTO `inventories` VALUES (237, 2, 214); INSERT INTO `inventories` VALUES (237, 5, 164); INSERT INTO `inventories` VALUES (237, 6, 151); INSERT INTO `inventories` VALUES (238, 2, 214); INSERT INTO `inventories` VALUES (238, 5, 165); INSERT INTO `inventories` VALUES (238, 6, 151); INSERT INTO `inventories` VALUES (239, 2, 214); INSERT INTO `inventories` VALUES (239, 5, 165); INSERT INTO `inventories` VALUES (239, 6, 151); INSERT INTO `inventories` VALUES (241, 3, 181); INSERT INTO `inventories` VALUES (241, 5, 157); INSERT INTO `inventories` VALUES (241, 6, 145); INSERT INTO `inventories` VALUES (241, 7, 133); INSERT INTO `inventories` VALUES (241, 8, 121); INSERT INTO `inventories` VALUES (241, 9, 109); INSERT INTO `inventories` VALUES (242, 3, 181); INSERT INTO `inventories` VALUES (242, 5, 157); INSERT INTO `inventories` VALUES (242, 6, 145); INSERT INTO `inventories` VALUES (242, 7, 133); INSERT INTO `inventories` VALUES (242, 8, 121); INSERT INTO `inventories` VALUES (242, 9, 109); INSERT INTO `inventories` VALUES (243, 3, 181); INSERT INTO `inventories` VALUES (243, 5, 157); INSERT INTO `inventories` VALUES (243, 6, 145); INSERT INTO `inventories` VALUES (243, 7, 133); INSERT INTO `inventories` VALUES (243, 8, 121); INSERT INTO `inventories` VALUES (243, 9, 109); INSERT INTO `inventories` VALUES (245, 1, 221); INSERT INTO `inventories` VALUES (245, 2, 209); INSERT INTO `inventories` VALUES (245, 3, 197); INSERT INTO `inventories` VALUES (245, 4, 185); INSERT INTO `inventories` VALUES (245, 5, 173); INSERT INTO `inventories` VALUES (245, 6, 161); INSERT INTO `inventories` VALUES (245, 7, 149); INSERT INTO `inventories` VALUES (245, 8, 137); INSERT INTO `inventories` VALUES (245, 9, 125); INSERT INTO `inventories` VALUES (247, 6, 148); INSERT INTO `inventories` VALUES (251, 6, 150); INSERT INTO `inventories` VALUES (254, 2, 225); INSERT INTO `inventories` VALUES (254, 5, 175); INSERT INTO `inventories` VALUES (254, 6, 161); INSERT INTO `inventories` VALUES (254, 7, 148); INSERT INTO `inventories` VALUES (254, 8, 136); INSERT INTO `inventories` VALUES (255, 2, 225); INSERT INTO `inventories` VALUES (255, 5, 175); INSERT INTO `inventories` VALUES (255, 6, 162); INSERT INTO `inventories` VALUES (255, 7, 148); INSERT INTO `inventories` VALUES (255, 8, 136); INSERT INTO `inventories` VALUES (256, 2, 225); INSERT INTO `inventories` VALUES (256, 5, 175); INSERT INTO `inventories` VALUES (256, 6, 162); INSERT INTO `inventories` VALUES (256, 7, 149); INSERT INTO `inventories` VALUES (256, 8, 136); INSERT INTO `inventories` VALUES (257, 2, 226); INSERT INTO `inventories` VALUES (257, 5, 176); INSERT INTO `inventories` VALUES (257, 6, 162); INSERT INTO `inventories` VALUES (257, 7, 149); INSERT INTO `inventories` VALUES (257, 8, 136); INSERT INTO `inventories` VALUES (258, 2, 226); INSERT INTO `inventories` VALUES (258, 5, 176); INSERT INTO `inventories` VALUES (258, 6, 162); INSERT INTO `inventories` VALUES (258, 7, 149); INSERT INTO `inventories` VALUES (258, 8, 136); INSERT INTO `inventories` VALUES (259, 2, 226); INSERT INTO `inventories` VALUES (259, 5, 176); INSERT INTO `inventories` VALUES (259, 6, 162); INSERT INTO `inventories` VALUES (259, 7, 149); INSERT INTO `inventories` VALUES (259, 8, 137); INSERT INTO `inventories` VALUES (260, 2, 226); INSERT INTO `inventories` VALUES (260, 5, 176); INSERT INTO `inventories` VALUES (260, 6, 163); INSERT INTO `inventories` VALUES (260, 7, 149); INSERT INTO `inventories` VALUES (260, 8, 137); INSERT INTO `inventories` VALUES (261, 2, 226); INSERT INTO `inventories` VALUES (261, 5, 176); INSERT INTO `inventories` VALUES (261, 6, 163); INSERT INTO `inventories` VALUES (262, 2, 227); INSERT INTO `inventories` VALUES (262, 5, 177); INSERT INTO `inventories` VALUES (262, 6, 163); INSERT INTO `inventories` VALUES (263, 2, 227); INSERT INTO `inventories` VALUES (263, 5, 177); INSERT INTO `inventories` VALUES (263, 6, 163); INSERT INTO `inventories` VALUES (263, 7, 150); INSERT INTO `inventories` VALUES (263, 8, 137); INSERT INTO `inventories` VALUES (264, 2, 227); INSERT INTO `inventories` VALUES (264, 5, 177); INSERT INTO `inventories` VALUES (264, 6, 163); INSERT INTO `inventories` VALUES (264, 7, 150); INSERT INTO `inventories` VALUES (264, 8, 137); INSERT INTO `inventories` VALUES (265, 2, 227); INSERT INTO `inventories` VALUES (265, 5, 177); INSERT INTO `inventories` VALUES (265, 6, 164); INSERT INTO `inventories` VALUES (269, 1, 222); INSERT INTO `inventories` VALUES (269, 2, 210); INSERT INTO `inventories` VALUES (269, 3, 304); INSERT INTO `inventories` VALUES (269, 4, 266); INSERT INTO `inventories` VALUES (269, 5, 237); INSERT INTO `inventories` VALUES (269, 6, 214); INSERT INTO `inventories` VALUES (269, 7, 196); INSERT INTO `inventories` VALUES (269, 8, 178); INSERT INTO `inventories` VALUES (269, 9, 161); INSERT INTO `inventories` VALUES (270, 1, 222); INSERT INTO `inventories` VALUES (270, 2, 210); INSERT INTO `inventories` VALUES (270, 3, 304); INSERT INTO `inventories` VALUES (270, 4, 266); INSERT INTO `inventories` VALUES (270, 5, 237); INSERT INTO `inventories` VALUES (270, 6, 214); INSERT INTO `inventories` VALUES (270, 7, 196); INSERT INTO `inventories` VALUES (270, 8, 178); INSERT INTO `inventories` VALUES (270, 9, 161); INSERT INTO `inventories` VALUES (271, 2, 215); INSERT INTO `inventories` VALUES (271, 4, 271); INSERT INTO `inventories` VALUES (271, 6, 221); INSERT INTO `inventories` VALUES (271, 8, 183); INSERT INTO `inventories` VALUES (271, 9, 165); INSERT INTO `inventories` VALUES (272, 2, 216); INSERT INTO `inventories` VALUES (272, 4, 272); INSERT INTO `inventories` VALUES (272, 6, 222); INSERT INTO `inventories` VALUES (272, 8, 184); INSERT INTO `inventories` VALUES (272, 9, 166); INSERT INTO `inventories` VALUES (273, 2, 264); INSERT INTO `inventories` VALUES (273, 5, 199); INSERT INTO `inventories` VALUES (273, 6, 184); INSERT INTO `inventories` VALUES (273, 7, 170); INSERT INTO `inventories` VALUES (273, 8, 156); INSERT INTO `inventories` VALUES (274, 2, 232); INSERT INTO `inventories` VALUES (274, 4, 208); INSERT INTO `inventories` VALUES (274, 6, 184); INSERT INTO `inventories` VALUES (274, 8, 160); INSERT INTO `inventories` VALUES (274, 9, 148); INSERT INTO `inventories` VALUES (276, 2, 219); INSERT INTO `inventories` VALUES (276, 4, 275); INSERT INTO `inventories` VALUES (276, 6, 225); INSERT INTO `inventories` VALUES (276, 8, 187); INSERT INTO `inventories` VALUES (276, 9, 169); INSERT INTO `inventories` VALUES (277, 2, 219); INSERT INTO `inventories` VALUES (277, 4, 275); INSERT INTO `inventories` VALUES (277, 6, 225); INSERT INTO `inventories` VALUES (277, 8, 187); INSERT INTO `inventories` VALUES (277, 9, 169); INSERT INTO `inventories` VALUES (278, 2, 220); INSERT INTO `inventories` VALUES (278, 4, 276); INSERT INTO `inventories` VALUES (278, 6, 226); INSERT INTO `inventories` VALUES (278, 8, 188); INSERT INTO `inventories` VALUES (278, 9, 170); INSERT INTO `inventories` VALUES (279, 2, 244); INSERT INTO `inventories` VALUES (279, 5, 193); INSERT INTO `inventories` VALUES (279, 6, 180); INSERT INTO `inventories` VALUES (280, 2, 244); INSERT INTO `inventories` VALUES (280, 5, 194); INSERT INTO `inventories` VALUES (280, 6, 180); INSERT INTO `inventories` VALUES (280, 7, 167); INSERT INTO `inventories` VALUES (280, 8, 154); INSERT INTO `inventories` VALUES (281, 1, 251); INSERT INTO `inventories` VALUES (281, 2, 239); INSERT INTO `inventories` VALUES (281, 3, 227); INSERT INTO `inventories` VALUES (281, 4, 215); INSERT INTO `inventories` VALUES (281, 5, 203); INSERT INTO `inventories` VALUES (281, 6, 191); INSERT INTO `inventories` VALUES (281, 7, 179); INSERT INTO `inventories` VALUES (281, 8, 167); INSERT INTO `inventories` VALUES (281, 9, 155); INSERT INTO `inventories` VALUES (283, 2, 226); INSERT INTO `inventories` VALUES (283, 4, 282); INSERT INTO `inventories` VALUES (283, 6, 232); INSERT INTO `inventories` VALUES (283, 8, 194); INSERT INTO `inventories` VALUES (283, 9, 179); INSERT INTO `inventories` VALUES (284, 2, 353); INSERT INTO `inventories` VALUES (284, 5, 220); INSERT INTO `inventories` VALUES (284, 6, 320); INSERT INTO `inventories` VALUES (284, 7, 294); INSERT INTO `inventories` VALUES (284, 8, 268); INSERT INTO `inventories` VALUES (285, 2, 267); INSERT INTO `inventories` VALUES (285, 5, 216); INSERT INTO `inventories` VALUES (285, 6, 202); INSERT INTO `inventories` VALUES (285, 7, 189); INSERT INTO `inventories` VALUES (285, 8, 176); INSERT INTO `inventories` VALUES (286, 2, 267); INSERT INTO `inventories` VALUES (286, 5, 216); INSERT INTO `inventories` VALUES (286, 6, 203); INSERT INTO `inventories` VALUES (286, 7, 189); INSERT INTO `inventories` VALUES (286, 8, 177); INSERT INTO `inventories` VALUES (287, 6, 212); INSERT INTO `inventories` VALUES (288, 6, 213); -- ---------------------------- -- Table structure for locations -- ---------------------------- DROP TABLE IF EXISTS `locations`; CREATE TABLE `locations` ( `location_id` smallint NOT NULL, `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `postal_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `city` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `state` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `country_id` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, PRIMARY KEY (`location_id`) USING BTREE, INDEX `fk_locations_country`(`country_id` ASC) USING BTREE, CONSTRAINT `fk_locations_country` FOREIGN KEY (`country_id`) REFERENCES `countries` (`country_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of locations -- ---------------------------- INSERT INTO `locations` VALUES (1, '1297 Via Cola di Rie', '00989', 'Roma', NULL, 'IT'); INSERT INTO `locations` VALUES (2, '93091 Calle della Testa', '10934', 'Venice', NULL, 'IT'); INSERT INTO `locations` VALUES (3, '2017 Shinjuku-ku', '1689', 'Tokyo', 'Tokyo Prefecture', 'JP'); INSERT INTO `locations` VALUES (4, '9450 Kamiya-cho', '6823', 'Hiroshima', NULL, 'JP'); INSERT INTO `locations` VALUES (5, '2014 Jabberwocky Rd', '26192', 'Southlake', 'Texas', 'US'); INSERT INTO `locations` VALUES (6, '2011 Interiors Blvd', '99236', 'South San Francisco', 'California', 'US'); INSERT INTO `locations` VALUES (7, '2007 Zagora St', '50090', 'South Brunswick', 'New Jersey', 'US'); INSERT INTO `locations` VALUES (8, '2004 Charade Rd', '98199', 'Seattle', 'Washington', 'US'); INSERT INTO `locations` VALUES (9, '147 Spadina Ave', 'M5V 2L7', 'Toronto', 'Ontario', 'CA'); INSERT INTO `locations` VALUES (10, '6092 Boxwood St', 'YSW 9T2', 'Whitehorse', 'Yukon', 'CA'); INSERT INTO `locations` VALUES (11, '40-5-12 Laogianggen', '190518', 'Beijing', NULL, 'CN'); INSERT INTO `locations` VALUES (12, '1298 Vileparle (E)', '490231', 'Bombay', 'Maharashtra', 'IN'); INSERT INTO `locations` VALUES (13, '12-98 Victoria Street', '2901', 'Sydney', 'New South Wales', 'AU'); INSERT INTO `locations` VALUES (14, '198 Clementi North', '540198', 'Singapore', NULL, 'SG'); INSERT INTO `locations` VALUES (15, '8204 Arthur St', NULL, 'London', NULL, 'UK'); INSERT INTO `locations` VALUES (16, 'Magdalen Centre, The Oxford Science Park', 'OX9 9ZB', 'Oxford', 'Oxford', 'UK'); INSERT INTO `locations` VALUES (17, '9702 Chester Road', '09629850293', 'Stretford', 'Manchester', 'UK'); INSERT INTO `locations` VALUES (18, 'Schwanthalerstr 7031', '80925', 'Munich', 'Bavaria', 'DE'); INSERT INTO `locations` VALUES (19, 'Rua Frei Caneca 1360 ', '01307-002', 'Sao Paulo', 'Sao Paulo', 'BR'); INSERT INTO `locations` VALUES (20, '20 Rue des Corps-Saints', '1730', 'Geneva', 'Geneve', 'CH'); INSERT INTO `locations` VALUES (21, 'Murtenstrasse 921', '3095', 'Bern', 'BE', 'CH'); INSERT INTO `locations` VALUES (22, 'Pieter Breughelstraat 837', '3029SK', 'Utrecht', 'Utrecht', 'NL'); INSERT INTO `locations` VALUES (23, 'Mariano Escobedo 9991', '11932', 'Mexico City', 'Distrito Federal,', 'MX'); -- ---------------------------- -- Table structure for order_items -- ---------------------------- DROP TABLE IF EXISTS `order_items`; CREATE TABLE `order_items` ( `order_id` smallint NOT NULL, `item_id` smallint NOT NULL, `product_id` smallint NOT NULL, `quantity` decimal(8, 2) NOT NULL, `unit_price` decimal(8, 2) NULL DEFAULT NULL, PRIMARY KEY (`order_id`, `item_id`) USING BTREE, INDEX `fk_order_items_product`(`product_id` ASC) USING BTREE, CONSTRAINT `fk_order_items_order` FOREIGN KEY (`order_id`) REFERENCES `orders` (`order_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_order_items_product` FOREIGN KEY (`product_id`) REFERENCES `products` (`product_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of order_items -- ---------------------------- INSERT INTO `order_items` VALUES (1, 1, 137, 116.00, 46999.00); INSERT INTO `order_items` VALUES (1, 2, 78, 77.00, 68699.00); INSERT INTO `order_items` VALUES (1, 3, 64, 52.00, 52599.00); INSERT INTO `order_items` VALUES (1, 4, 210, 87.00, 102999.00); INSERT INTO `order_items` VALUES (1, 5, 138, 131.00, 64599.00); INSERT INTO `order_items` VALUES (1, 6, 126, 95.00, 64099.00); INSERT INTO `order_items` VALUES (1, 7, 30, 41.00, 6452.00); INSERT INTO `order_items` VALUES (1, 8, 170, 129.00, 38398.00); INSERT INTO `order_items` VALUES (1, 9, 196, 139.00, 109999.00); INSERT INTO `order_items` VALUES (1, 10, 64, 147.00, 52599.00); INSERT INTO `order_items` VALUES (1, 11, 169, 105.00, 184489.00); INSERT INTO `order_items` VALUES (1, 12, 226, 103.00, 30985.00); INSERT INTO `order_items` VALUES (1, 13, 178, 121.00, 199989.00); INSERT INTO `order_items` VALUES (2, 1, 43, 111.00, 29898.00); INSERT INTO `order_items` VALUES (2, 2, 265, 121.00, 143199.00); INSERT INTO `order_items` VALUES (2, 3, 195, 39.00, 105599.00); INSERT INTO `order_items` VALUES (2, 4, 18, 49.00, 799.00); INSERT INTO `order_items` VALUES (2, 5, 160, 30.00, 190873.00); INSERT INTO `order_items` VALUES (2, 6, 182, 95.00, 94989.00); INSERT INTO `order_items` VALUES (2, 7, 204, 100.00, 68699.00); INSERT INTO `order_items` VALUES (2, 8, 141, 97.00, 41999.00); INSERT INTO `order_items` VALUES (2, 9, 200, 75.00, 62095.00); INSERT INTO `order_items` VALUES (3, 1, 24, 111.00, 6689.00); INSERT INTO `order_items` VALUES (3, 2, 56, 65.00, 1699.00); INSERT INTO `order_items` VALUES (3, 3, 28, 63.00, 47999.00); INSERT INTO `order_items` VALUES (3, 4, 64, 46.00, 52599.00); INSERT INTO `order_items` VALUES (3, 5, 107, 112.00, 644.00); INSERT INTO `order_items` VALUES (3, 6, 36, 81.00, 129999.00); INSERT INTO `order_items` VALUES (3, 7, 125, 73.00, 76899.00); INSERT INTO `order_items` VALUES (3, 8, 190, 127.00, 94899.00); INSERT INTO `order_items` VALUES (4, 1, 280, 47.00, 14988.00); INSERT INTO `order_items` VALUES (4, 2, 137, 75.00, 46999.00); INSERT INTO `order_items` VALUES (4, 3, 7, 140.00, 68099.00); INSERT INTO `order_items` VALUES (4, 4, 287, 60.00, 32999.00); INSERT INTO `order_items` VALUES (4, 5, 20, 80.00, 71999.00); INSERT INTO `order_items` VALUES (4, 6, 159, 96.00, 199449.00); INSERT INTO `order_items` VALUES (4, 7, 262, 79.00, 144999.00); INSERT INTO `order_items` VALUES (4, 8, 18, 116.00, 799.00); INSERT INTO `order_items` VALUES (5, 1, 149, 70.00, 28298.00); INSERT INTO `order_items` VALUES (5, 2, 15, 45.00, 72599.00); INSERT INTO `order_items` VALUES (5, 3, 216, 82.00, 86398.00); INSERT INTO `order_items` VALUES (5, 4, 31, 77.00, 44372.00); INSERT INTO `order_items` VALUES (5, 5, 31, 78.00, 44372.00); INSERT INTO `order_items` VALUES (6, 1, 199, 67.00, 64799.00); INSERT INTO `order_items` VALUES (6, 2, 138, 41.00, 64599.00); INSERT INTO `order_items` VALUES (6, 3, 94, 90.00, 1555.00); INSERT INTO `order_items` VALUES (6, 4, 258, 145.00, 5798.00); INSERT INTO `order_items` VALUES (6, 5, 11, 74.00, 201511.00); INSERT INTO `order_items` VALUES (6, 6, 89, 150.00, 74999.00); INSERT INTO `order_items` VALUES (6, 7, 7, 119.00, 68099.00); INSERT INTO `order_items` VALUES (7, 1, 227, 74.00, 305.00); INSERT INTO `order_items` VALUES (7, 2, 230, 49.00, 13669.00); INSERT INTO `order_items` VALUES (8, 1, 87, 92.00, 75999.00); INSERT INTO `order_items` VALUES (8, 2, 12, 70.00, 82498.00); INSERT INTO `order_items` VALUES (8, 3, 71, 87.00, 660.00); INSERT INTO `order_items` VALUES (8, 4, 25, 40.00, 10488.00); INSERT INTO `order_items` VALUES (8, 5, 284, 118.00, 5499.00); INSERT INTO `order_items` VALUES (8, 6, 127, 34.00, 71999.00); INSERT INTO `order_items` VALUES (8, 7, 16, 135.00, 88989.00); INSERT INTO `order_items` VALUES (8, 8, 100, 68.00, 9788.00); INSERT INTO `order_items` VALUES (8, 9, 268, 148.00, 4788.00); INSERT INTO `order_items` VALUES (9, 1, 108, 139.00, 84999.00); INSERT INTO `order_items` VALUES (9, 2, 99, 123.00, 6806.00); INSERT INTO `order_items` VALUES (9, 3, 265, 90.00, 143199.00); INSERT INTO `order_items` VALUES (9, 4, 288, 62.00, 31999.00); INSERT INTO `order_items` VALUES (9, 5, 145, 58.00, 287.00); INSERT INTO `order_items` VALUES (9, 6, 14, 48.00, 70499.00); INSERT INTO `order_items` VALUES (9, 7, 124, 117.00, 59499.00); INSERT INTO `order_items` VALUES (9, 8, 93, 132.00, 211672.00); INSERT INTO `order_items` VALUES (10, 1, 145, 118.00, 287.00); INSERT INTO `order_items` VALUES (10, 2, 10, 102.00, 81199.00); INSERT INTO `order_items` VALUES (10, 3, 182, 83.00, 94989.00); INSERT INTO `order_items` VALUES (10, 4, 172, 133.00, 35849.00); INSERT INTO `order_items` VALUES (10, 5, 218, 68.00, 138889.00); INSERT INTO `order_items` VALUES (10, 6, 64, 96.00, 52599.00); INSERT INTO `order_items` VALUES (10, 7, 127, 52.00, 71999.00); INSERT INTO `order_items` VALUES (10, 8, 18, 124.00, 799.00); INSERT INTO `order_items` VALUES (10, 9, 119, 107.00, 89999.00); INSERT INTO `order_items` VALUES (11, 1, 96, 113.00, 14156.00); INSERT INTO `order_items` VALUES (11, 2, 40, 79.00, 29989.00); INSERT INTO `order_items` VALUES (12, 1, 191, 41.00, 57399.00); INSERT INTO `order_items` VALUES (12, 2, 63, 58.00, 57296.00); INSERT INTO `order_items` VALUES (12, 3, 42, 75.00, 29989.00); INSERT INTO `order_items` VALUES (12, 4, 144, 70.00, 28979.00); INSERT INTO `order_items` VALUES (12, 5, 208, 133.00, 119999.00); INSERT INTO `order_items` VALUES (12, 6, 236, 114.00, 74532.00); INSERT INTO `order_items` VALUES (12, 7, 141, 110.00, 41999.00); INSERT INTO `order_items` VALUES (12, 8, 256, 85.00, 2699.00); INSERT INTO `order_items` VALUES (12, 9, 282, 117.00, 80499.00); INSERT INTO `order_items` VALUES (12, 10, 210, 37.00, 102999.00); INSERT INTO `order_items` VALUES (12, 11, 169, 114.00, 184489.00); INSERT INTO `order_items` VALUES (12, 12, 96, 120.00, 14156.00); INSERT INTO `order_items` VALUES (13, 1, 84, 46.00, 4403.00); INSERT INTO `order_items` VALUES (13, 2, 85, 82.00, 127499.00); INSERT INTO `order_items` VALUES (13, 3, 240, 80.00, 180597.00); INSERT INTO `order_items` VALUES (13, 4, 30, 60.00, 6452.00); INSERT INTO `order_items` VALUES (13, 5, 167, 89.00, 101046.00); INSERT INTO `order_items` VALUES (13, 6, 1, 127.00, 64099.00); INSERT INTO `order_items` VALUES (13, 7, 39, 67.00, 30199.00); INSERT INTO `order_items` VALUES (13, 8, 1, 95.00, 64099.00); INSERT INTO `order_items` VALUES (13, 9, 225, 137.00, 50398.00); INSERT INTO `order_items` VALUES (13, 10, 245, 138.00, 1699.00); INSERT INTO `order_items` VALUES (14, 1, 129, 98.00, 73499.00); INSERT INTO `order_items` VALUES (14, 2, 206, 133.00, 4139.00); INSERT INTO `order_items` VALUES (14, 3, 231, 87.00, 44999.00); INSERT INTO `order_items` VALUES (14, 4, 114, 40.00, 82061.00); INSERT INTO `order_items` VALUES (14, 5, 239, 125.00, 73999.00); INSERT INTO `order_items` VALUES (14, 6, 188, 79.00, 48249.00); INSERT INTO `order_items` VALUES (14, 7, 113, 32.00, 70499.00); INSERT INTO `order_items` VALUES (14, 8, 238, 64.00, 74178.00); INSERT INTO `order_items` VALUES (15, 1, 287, 60.00, 32999.00); INSERT INTO `order_items` VALUES (15, 2, 154, 67.00, 120498.00); INSERT INTO `order_items` VALUES (15, 3, 246, 133.00, 34399.00); INSERT INTO `order_items` VALUES (15, 4, 239, 71.00, 73999.00); INSERT INTO `order_items` VALUES (15, 5, 230, 92.00, 13669.00); INSERT INTO `order_items` VALUES (15, 6, 253, 83.00, 57999.00); INSERT INTO `order_items` VALUES (15, 7, 83, 118.00, 82999.00); INSERT INTO `order_items` VALUES (15, 8, 241, 77.00, 1756.00); INSERT INTO `order_items` VALUES (16, 1, 166, 70.00, 163889.00); INSERT INTO `order_items` VALUES (16, 2, 155, 106.00, 58895.00); INSERT INTO `order_items` VALUES (16, 3, 235, 56.00, 4199.00); INSERT INTO `order_items` VALUES (16, 4, 95, 42.00, 10999.00); INSERT INTO `order_items` VALUES (16, 5, 45, 80.00, 250169.00); INSERT INTO `order_items` VALUES (16, 6, 131, 53.00, 27999.00); INSERT INTO `order_items` VALUES (16, 7, 256, 44.00, 2699.00); INSERT INTO `order_items` VALUES (16, 8, 138, 142.00, 64599.00); INSERT INTO `order_items` VALUES (16, 9, 135, 76.00, 12788.00); INSERT INTO `order_items` VALUES (17, 1, 149, 51.00, 28298.00); INSERT INTO `order_items` VALUES (18, 1, 213, 105.00, 146996.00); INSERT INTO `order_items` VALUES (18, 2, 226, 57.00, 30985.00); INSERT INTO `order_items` VALUES (18, 3, 93, 83.00, 211672.00); INSERT INTO `order_items` VALUES (18, 4, 91, 141.00, 225999.00); INSERT INTO `order_items` VALUES (18, 5, 87, 103.00, 75999.00); INSERT INTO `order_items` VALUES (18, 6, 259, 60.00, 8072.00); INSERT INTO `order_items` VALUES (18, 7, 188, 133.00, 48249.00); INSERT INTO `order_items` VALUES (18, 8, 136, 32.00, 82699.00); INSERT INTO `order_items` VALUES (19, 1, 38, 53.00, 119999.00); INSERT INTO `order_items` VALUES (19, 2, 24, 62.00, 6689.00); INSERT INTO `order_items` VALUES (19, 3, 23, 142.00, 8989.00); INSERT INTO `order_items` VALUES (19, 4, 259, 46.00, 8072.00); INSERT INTO `order_items` VALUES (19, 5, 107, 106.00, 644.00); INSERT INTO `order_items` VALUES (19, 6, 103, 105.00, 80999.00); INSERT INTO `order_items` VALUES (19, 7, 30, 94.00, 6452.00); INSERT INTO `order_items` VALUES (19, 8, 91, 130.00, 225999.00); INSERT INTO `order_items` VALUES (19, 9, 63, 83.00, 57296.00); INSERT INTO `order_items` VALUES (19, 10, 200, 93.00, 62095.00); INSERT INTO `order_items` VALUES (20, 1, 126, 105.00, 64099.00); INSERT INTO `order_items` VALUES (20, 2, 41, 78.00, 29989.00); INSERT INTO `order_items` VALUES (21, 1, 36, 79.00, 129999.00); INSERT INTO `order_items` VALUES (21, 2, 101, 146.00, 63599.00); INSERT INTO `order_items` VALUES (21, 3, 250, 120.00, 33899.00); INSERT INTO `order_items` VALUES (21, 4, 1, 135.00, 64099.00); INSERT INTO `order_items` VALUES (22, 1, 83, 44.00, 82999.00); INSERT INTO `order_items` VALUES (22, 2, 116, 45.00, 73199.00); INSERT INTO `order_items` VALUES (22, 3, 24, 77.00, 6689.00); INSERT INTO `order_items` VALUES (22, 4, 288, 44.00, 31999.00); INSERT INTO `order_items` VALUES (22, 5, 160, 59.00, 190873.00); INSERT INTO `order_items` VALUES (22, 6, 56, 43.00, 1699.00); INSERT INTO `order_items` VALUES (22, 7, 17, 60.00, 69901.00); INSERT INTO `order_items` VALUES (22, 8, 222, 99.00, 75498.00); INSERT INTO `order_items` VALUES (22, 9, 8, 89.00, 60199.00); INSERT INTO `order_items` VALUES (22, 10, 90, 95.00, 75999.00); INSERT INTO `order_items` VALUES (22, 11, 234, 144.00, 15099.00); INSERT INTO `order_items` VALUES (22, 12, 108, 45.00, 84999.00); INSERT INTO `order_items` VALUES (22, 13, 281, 73.00, 86498.00); INSERT INTO `order_items` VALUES (23, 1, 202, 104.00, 71399.00); INSERT INTO `order_items` VALUES (23, 2, 190, 50.00, 94899.00); INSERT INTO `order_items` VALUES (23, 3, 210, 80.00, 102999.00); INSERT INTO `order_items` VALUES (23, 4, 116, 74.00, 73199.00); INSERT INTO `order_items` VALUES (23, 5, 5, 59.00, 229079.00); INSERT INTO `order_items` VALUES (23, 6, 169, 40.00, 184489.00); INSERT INTO `order_items` VALUES (23, 7, 286, 36.00, 234.00); INSERT INTO `order_items` VALUES (23, 8, 241, 126.00, 1756.00); INSERT INTO `order_items` VALUES (23, 9, 14, 86.00, 70499.00); INSERT INTO `order_items` VALUES (23, 10, 187, 110.00, 35398.00); INSERT INTO `order_items` VALUES (24, 1, 121, 129.00, 72199.00); INSERT INTO `order_items` VALUES (24, 2, 227, 61.00, 305.00); INSERT INTO `order_items` VALUES (24, 3, 47, 51.00, 237709.00); INSERT INTO `order_items` VALUES (24, 4, 24, 59.00, 6689.00); INSERT INTO `order_items` VALUES (24, 5, 41, 83.00, 29989.00); INSERT INTO `order_items` VALUES (24, 6, 276, 99.00, 116399.00); INSERT INTO `order_items` VALUES (25, 1, 43, 109.00, 29898.00); INSERT INTO `order_items` VALUES (25, 2, 239, 119.00, 73999.00); INSERT INTO `order_items` VALUES (25, 3, 29, 65.00, 64599.00); INSERT INTO `order_items` VALUES (25, 4, 209, 80.00, 119999.00); INSERT INTO `order_items` VALUES (25, 5, 235, 45.00, 4199.00); INSERT INTO `order_items` VALUES (25, 6, 28, 85.00, 47999.00); INSERT INTO `order_items` VALUES (25, 7, 135, 132.00, 12788.00); INSERT INTO `order_items` VALUES (25, 8, 2, 65.00, 255499.00); INSERT INTO `order_items` VALUES (26, 1, 200, 114.00, 62095.00); INSERT INTO `order_items` VALUES (26, 2, 186, 92.00, 144998.00); INSERT INTO `order_items` VALUES (26, 3, 279, 71.00, 131899.00); INSERT INTO `order_items` VALUES (26, 4, 164, 78.00, 1850.00); INSERT INTO `order_items` VALUES (26, 5, 151, 36.00, 28197.00); INSERT INTO `order_items` VALUES (27, 1, 71, 38.00, 660.00); INSERT INTO `order_items` VALUES (27, 2, 141, 77.00, 41999.00); INSERT INTO `order_items` VALUES (27, 3, 68, 96.00, 76611.00); INSERT INTO `order_items` VALUES (27, 4, 263, 95.00, 8999.00); INSERT INTO `order_items` VALUES (27, 5, 118, 122.00, 69989.00); INSERT INTO `order_items` VALUES (27, 6, 29, 133.00, 64599.00); INSERT INTO `order_items` VALUES (27, 7, 155, 51.00, 58895.00); INSERT INTO `order_items` VALUES (27, 8, 71, 127.00, 660.00); INSERT INTO `order_items` VALUES (27, 9, 93, 132.00, 211672.00); INSERT INTO `order_items` VALUES (27, 10, 150, 58.00, 28198.00); INSERT INTO `order_items` VALUES (27, 11, 116, 67.00, 73199.00); INSERT INTO `order_items` VALUES (27, 12, 92, 105.00, 2200.00); INSERT INTO `order_items` VALUES (27, 13, 111, 102.00, 82737.00); INSERT INTO `order_items` VALUES (28, 1, 31, 61.00, 44372.00); INSERT INTO `order_items` VALUES (28, 2, 121, 120.00, 72199.00); INSERT INTO `order_items` VALUES (28, 3, 41, 56.00, 29989.00); INSERT INTO `order_items` VALUES (28, 4, 208, 139.00, 119999.00); INSERT INTO `order_items` VALUES (28, 5, 27, 99.00, 80074.00); INSERT INTO `order_items` VALUES (28, 6, 210, 120.00, 102999.00); INSERT INTO `order_items` VALUES (28, 7, 54, 131.00, 101999.00); INSERT INTO `order_items` VALUES (28, 8, 40, 105.00, 29989.00); INSERT INTO `order_items` VALUES (29, 1, 7, 38.00, 68099.00); INSERT INTO `order_items` VALUES (29, 2, 82, 62.00, 149989.00); INSERT INTO `order_items` VALUES (29, 3, 268, 118.00, 4788.00); INSERT INTO `order_items` VALUES (29, 4, 141, 32.00, 41999.00); INSERT INTO `order_items` VALUES (29, 5, 258, 137.00, 5798.00); INSERT INTO `order_items` VALUES (29, 6, 30, 75.00, 6452.00); INSERT INTO `order_items` VALUES (29, 7, 166, 103.00, 163889.00); INSERT INTO `order_items` VALUES (29, 8, 10, 81.00, 81199.00); INSERT INTO `order_items` VALUES (29, 9, 233, 71.00, 5999.00); INSERT INTO `order_items` VALUES (29, 10, 76, 62.00, 62999.00); INSERT INTO `order_items` VALUES (29, 11, 115, 52.00, 69999.00); INSERT INTO `order_items` VALUES (30, 1, 235, 70.00, 4199.00); INSERT INTO `order_items` VALUES (30, 2, 200, 137.00, 62095.00); INSERT INTO `order_items` VALUES (30, 3, 260, 37.00, 26799.00); INSERT INTO `order_items` VALUES (30, 4, 237, 50.00, 74498.00); INSERT INTO `order_items` VALUES (30, 5, 43, 68.00, 29898.00); INSERT INTO `order_items` VALUES (30, 6, 4, 82.00, 269999.00); INSERT INTO `order_items` VALUES (30, 7, 155, 64.00, 58895.00); INSERT INTO `order_items` VALUES (31, 1, 101, 68.00, 63599.00); INSERT INTO `order_items` VALUES (31, 2, 176, 97.00, 93949.00); INSERT INTO `order_items` VALUES (31, 3, 191, 147.00, 57399.00); INSERT INTO `order_items` VALUES (31, 4, 226, 34.00, 30985.00); INSERT INTO `order_items` VALUES (31, 5, 79, 56.00, 65999.00); INSERT INTO `order_items` VALUES (31, 6, 171, 103.00, 38298.00); INSERT INTO `order_items` VALUES (32, 1, 251, 83.00, 33781.00); INSERT INTO `order_items` VALUES (32, 2, 142, 130.00, 299889.00); INSERT INTO `order_items` VALUES (32, 3, 73, 134.00, 799.00); INSERT INTO `order_items` VALUES (32, 4, 30, 105.00, 6452.00); INSERT INTO `order_items` VALUES (32, 5, 85, 148.00, 127499.00); INSERT INTO `order_items` VALUES (32, 6, 102, 147.00, 204269.00); INSERT INTO `order_items` VALUES (33, 1, 55, 93.00, 15099.00); INSERT INTO `order_items` VALUES (33, 2, 153, 33.00, 1249.00); INSERT INTO `order_items` VALUES (33, 3, 217, 67.00, 40198.00); INSERT INTO `order_items` VALUES (33, 4, 55, 93.00, 15099.00); INSERT INTO `order_items` VALUES (33, 5, 62, 84.00, 78979.00); INSERT INTO `order_items` VALUES (33, 6, 190, 70.00, 94899.00); INSERT INTO `order_items` VALUES (33, 7, 18, 41.00, 799.00); INSERT INTO `order_items` VALUES (33, 8, 13, 75.00, 70499.00); INSERT INTO `order_items` VALUES (34, 1, 185, 141.00, 87398.00); INSERT INTO `order_items` VALUES (34, 2, 131, 113.00, 27999.00); INSERT INTO `order_items` VALUES (34, 3, 39, 100.00, 30199.00); INSERT INTO `order_items` VALUES (34, 4, 143, 106.00, 40299.00); INSERT INTO `order_items` VALUES (34, 5, 68, 37.00, 76611.00); INSERT INTO `order_items` VALUES (34, 6, 101, 62.00, 63599.00); INSERT INTO `order_items` VALUES (35, 1, 174, 133.00, 79826.00); INSERT INTO `order_items` VALUES (35, 2, 70, 134.00, 71099.00); INSERT INTO `order_items` VALUES (35, 3, 211, 87.00, 106499.00); INSERT INTO `order_items` VALUES (35, 4, 41, 79.00, 29989.00); INSERT INTO `order_items` VALUES (35, 5, 186, 41.00, 144998.00); INSERT INTO `order_items` VALUES (36, 1, 204, 45.00, 68699.00); INSERT INTO `order_items` VALUES (36, 2, 101, 105.00, 63599.00); INSERT INTO `order_items` VALUES (36, 3, 100, 102.00, 9788.00); INSERT INTO `order_items` VALUES (36, 4, 10, 72.00, 81199.00); INSERT INTO `order_items` VALUES (36, 5, 255, 143.00, 9099.00); INSERT INTO `order_items` VALUES (36, 6, 205, 33.00, 64999.00); INSERT INTO `order_items` VALUES (36, 7, 152, 45.00, 28098.00); INSERT INTO `order_items` VALUES (36, 8, 141, 144.00, 41999.00); INSERT INTO `order_items` VALUES (37, 1, 35, 150.00, 131499.00); INSERT INTO `order_items` VALUES (37, 2, 67, 129.00, 86305.00); INSERT INTO `order_items` VALUES (37, 3, 147, 100.00, 28398.00); INSERT INTO `order_items` VALUES (38, 1, 71, 90.00, 660.00); INSERT INTO `order_items` VALUES (38, 2, 169, 52.00, 184489.00); INSERT INTO `order_items` VALUES (38, 3, 264, 89.00, 8899.00); INSERT INTO `order_items` VALUES (38, 4, 61, 59.00, 4873.00); INSERT INTO `order_items` VALUES (38, 5, 209, 149.00, 119999.00); INSERT INTO `order_items` VALUES (38, 6, 278, 76.00, 67799.00); INSERT INTO `order_items` VALUES (38, 7, 49, 139.00, 149999.00); INSERT INTO `order_items` VALUES (39, 1, 186, 116.00, 144998.00); INSERT INTO `order_items` VALUES (39, 2, 153, 108.00, 1249.00); INSERT INTO `order_items` VALUES (39, 3, 109, 33.00, 71399.00); INSERT INTO `order_items` VALUES (39, 4, 53, 128.00, 100398.00); INSERT INTO `order_items` VALUES (39, 5, 38, 144.00, 119999.00); INSERT INTO `order_items` VALUES (39, 6, 20, 112.00, 71999.00); INSERT INTO `order_items` VALUES (39, 7, 185, 101.00, 87398.00); INSERT INTO `order_items` VALUES (39, 8, 179, 102.00, 31267.00); INSERT INTO `order_items` VALUES (39, 9, 144, 125.00, 28979.00); INSERT INTO `order_items` VALUES (40, 1, 141, 106.00, 41999.00); INSERT INTO `order_items` VALUES (40, 2, 101, 131.00, 63599.00); INSERT INTO `order_items` VALUES (40, 3, 250, 131.00, 33899.00); INSERT INTO `order_items` VALUES (40, 4, 230, 80.00, 13669.00); INSERT INTO `order_items` VALUES (40, 5, 98, 149.00, 206499.00); INSERT INTO `order_items` VALUES (40, 6, 273, 82.00, 44364.00); INSERT INTO `order_items` VALUES (40, 7, 258, 99.00, 5798.00); INSERT INTO `order_items` VALUES (40, 8, 31, 30.00, 44372.00); INSERT INTO `order_items` VALUES (40, 9, 170, 31.00, 38398.00); INSERT INTO `order_items` VALUES (40, 10, 215, 36.00, 82989.00); INSERT INTO `order_items` VALUES (40, 11, 184, 88.00, 99999.00); INSERT INTO `order_items` VALUES (41, 1, 268, 80.00, 4788.00); INSERT INTO `order_items` VALUES (41, 2, 219, 82.00, 129973.00); INSERT INTO `order_items` VALUES (41, 3, 69, 86.00, 67875.00); INSERT INTO `order_items` VALUES (41, 4, 258, 49.00, 5798.00); INSERT INTO `order_items` VALUES (41, 5, 179, 83.00, 31267.00); INSERT INTO `order_items` VALUES (41, 6, 287, 112.00, 32999.00); INSERT INTO `order_items` VALUES (41, 7, 25, 101.00, 10488.00); INSERT INTO `order_items` VALUES (41, 8, 21, 31.00, 74999.00); INSERT INTO `order_items` VALUES (41, 9, 55, 61.00, 15099.00); INSERT INTO `order_items` VALUES (42, 1, 34, 45.00, 41798.00); INSERT INTO `order_items` VALUES (42, 2, 10, 147.00, 81199.00); INSERT INTO `order_items` VALUES (42, 3, 249, 76.00, 266072.00); INSERT INTO `order_items` VALUES (42, 4, 213, 103.00, 146996.00); INSERT INTO `order_items` VALUES (42, 5, 252, 85.00, 49999.00); INSERT INTO `order_items` VALUES (42, 6, 78, 47.00, 68699.00); INSERT INTO `order_items` VALUES (42, 7, 139, 149.00, 6592.00); INSERT INTO `order_items` VALUES (43, 1, 67, 74.00, 86305.00); INSERT INTO `order_items` VALUES (43, 2, 287, 66.00, 32999.00); INSERT INTO `order_items` VALUES (43, 3, 110, 94.00, 319297.00); INSERT INTO `order_items` VALUES (43, 4, 105, 86.00, 279999.00); INSERT INTO `order_items` VALUES (43, 5, 86, 114.00, 80498.00); INSERT INTO `order_items` VALUES (43, 6, 235, 86.00, 4199.00); INSERT INTO `order_items` VALUES (43, 7, 1, 57.00, 64099.00); INSERT INTO `order_items` VALUES (43, 8, 169, 73.00, 184489.00); INSERT INTO `order_items` VALUES (44, 1, 220, 118.00, 75999.00); INSERT INTO `order_items` VALUES (44, 2, 215, 148.00, 82989.00); INSERT INTO `order_items` VALUES (44, 3, 271, 37.00, 54959.00); INSERT INTO `order_items` VALUES (44, 4, 158, 100.00, 200946.00); INSERT INTO `order_items` VALUES (45, 1, 74, 43.00, 70195.00); INSERT INTO `order_items` VALUES (45, 2, 66, 126.00, 39999.00); INSERT INTO `order_items` VALUES (45, 3, 68, 88.00, 76611.00); INSERT INTO `order_items` VALUES (46, 1, 120, 51.00, 892.00); INSERT INTO `order_items` VALUES (46, 2, 4, 112.00, 269999.00); INSERT INTO `order_items` VALUES (46, 3, 187, 86.00, 35398.00); INSERT INTO `order_items` VALUES (46, 4, 264, 104.00, 8899.00); INSERT INTO `order_items` VALUES (46, 5, 181, 94.00, 99999.00); INSERT INTO `order_items` VALUES (46, 6, 60, 80.00, 5999.00); INSERT INTO `order_items` VALUES (46, 7, 155, 114.00, 58895.00); INSERT INTO `order_items` VALUES (46, 8, 123, 116.00, 317744.00); INSERT INTO `order_items` VALUES (46, 9, 2, 65.00, 255499.00); INSERT INTO `order_items` VALUES (46, 10, 214, 91.00, 100979.00); INSERT INTO `order_items` VALUES (46, 11, 89, 119.00, 74999.00); INSERT INTO `order_items` VALUES (47, 1, 178, 73.00, 199989.00); INSERT INTO `order_items` VALUES (47, 2, 55, 107.00, 15099.00); INSERT INTO `order_items` VALUES (47, 3, 65, 99.00, 119999.00); INSERT INTO `order_items` VALUES (47, 4, 33, 98.00, 5265.00); INSERT INTO `order_items` VALUES (47, 5, 149, 123.00, 28298.00); INSERT INTO `order_items` VALUES (48, 1, 165, 46.00, 166661.00); INSERT INTO `order_items` VALUES (48, 2, 158, 98.00, 200946.00); INSERT INTO `order_items` VALUES (49, 1, 172, 104.00, 35849.00); INSERT INTO `order_items` VALUES (50, 1, 215, 49.00, 82989.00); INSERT INTO `order_items` VALUES (51, 1, 21, 34.00, 74999.00); INSERT INTO `order_items` VALUES (51, 2, 7, 64.00, 68099.00); INSERT INTO `order_items` VALUES (52, 1, 235, 123.00, 4199.00); INSERT INTO `order_items` VALUES (53, 1, 100, 130.00, 9788.00); INSERT INTO `order_items` VALUES (53, 2, 168, 89.00, 4399.00); INSERT INTO `order_items` VALUES (53, 3, 9, 106.00, 89999.00); INSERT INTO `order_items` VALUES (53, 4, 177, 96.00, 175999.00); INSERT INTO `order_items` VALUES (54, 1, 208, 73.00, 119999.00); INSERT INTO `order_items` VALUES (54, 2, 4, 136.00, 269999.00); INSERT INTO `order_items` VALUES (54, 3, 68, 134.00, 76611.00); INSERT INTO `order_items` VALUES (55, 1, 102, 127.00, 204269.00); INSERT INTO `order_items` VALUES (55, 2, 32, 70.00, 46999.00); INSERT INTO `order_items` VALUES (55, 3, 260, 79.00, 26799.00); INSERT INTO `order_items` VALUES (56, 1, 84, 70.00, 4403.00); INSERT INTO `order_items` VALUES (57, 1, 224, 75.00, 34999.00); INSERT INTO `order_items` VALUES (57, 2, 177, 110.00, 175999.00); INSERT INTO `order_items` VALUES (57, 3, 238, 122.00, 74178.00); INSERT INTO `order_items` VALUES (57, 4, 164, 114.00, 1850.00); INSERT INTO `order_items` VALUES (57, 5, 132, 77.00, 55499.00); INSERT INTO `order_items` VALUES (57, 6, 164, 44.00, 1850.00); INSERT INTO `order_items` VALUES (58, 1, 64, 55.00, 52599.00); INSERT INTO `order_items` VALUES (58, 2, 120, 32.00, 892.00); INSERT INTO `order_items` VALUES (58, 3, 113, 73.00, 70499.00); INSERT INTO `order_items` VALUES (58, 4, 186, 70.00, 144998.00); INSERT INTO `order_items` VALUES (58, 5, 62, 143.00, 78979.00); INSERT INTO `order_items` VALUES (58, 6, 213, 77.00, 146996.00); INSERT INTO `order_items` VALUES (58, 7, 108, 49.00, 84999.00); INSERT INTO `order_items` VALUES (58, 8, 157, 65.00, 38899.00); INSERT INTO `order_items` VALUES (58, 9, 136, 134.00, 82699.00); INSERT INTO `order_items` VALUES (58, 10, 163, 31.00, 189999.00); INSERT INTO `order_items` VALUES (58, 11, 152, 51.00, 28098.00); INSERT INTO `order_items` VALUES (58, 12, 62, 148.00, 78979.00); INSERT INTO `order_items` VALUES (59, 1, 178, 101.00, 199989.00); INSERT INTO `order_items` VALUES (59, 2, 166, 34.00, 163889.00); INSERT INTO `order_items` VALUES (59, 3, 118, 105.00, 69989.00); INSERT INTO `order_items` VALUES (59, 4, 47, 138.00, 237709.00); INSERT INTO `order_items` VALUES (59, 5, 203, 117.00, 67138.00); INSERT INTO `order_items` VALUES (59, 6, 154, 126.00, 120498.00); INSERT INTO `order_items` VALUES (59, 7, 152, 82.00, 28098.00); INSERT INTO `order_items` VALUES (59, 8, 287, 96.00, 32999.00); INSERT INTO `order_items` VALUES (59, 9, 154, 82.00, 120498.00); INSERT INTO `order_items` VALUES (60, 1, 205, 74.00, 64999.00); INSERT INTO `order_items` VALUES (60, 2, 13, 138.00, 70499.00); INSERT INTO `order_items` VALUES (60, 3, 272, 144.00, 107399.00); INSERT INTO `order_items` VALUES (60, 4, 92, 125.00, 2200.00); INSERT INTO `order_items` VALUES (60, 5, 278, 114.00, 67799.00); INSERT INTO `order_items` VALUES (60, 6, 51, 79.00, 226999.00); INSERT INTO `order_items` VALUES (60, 7, 189, 146.00, 649.00); INSERT INTO `order_items` VALUES (61, 1, 174, 114.00, 79826.00); INSERT INTO `order_items` VALUES (61, 2, 56, 75.00, 1699.00); INSERT INTO `order_items` VALUES (61, 3, 146, 59.00, 28398.00); INSERT INTO `order_items` VALUES (61, 4, 34, 71.00, 41798.00); INSERT INTO `order_items` VALUES (61, 5, 15, 32.00, 72599.00); INSERT INTO `order_items` VALUES (61, 6, 5, 50.00, 229079.00); INSERT INTO `order_items` VALUES (61, 7, 52, 45.00, 167698.00); INSERT INTO `order_items` VALUES (62, 1, 188, 130.00, 48249.00); INSERT INTO `order_items` VALUES (63, 1, 70, 72.00, 71099.00); INSERT INTO `order_items` VALUES (63, 2, 54, 47.00, 101999.00); INSERT INTO `order_items` VALUES (64, 1, 199, 61.00, 64799.00); INSERT INTO `order_items` VALUES (64, 2, 126, 52.00, 64099.00); INSERT INTO `order_items` VALUES (65, 1, 280, 104.00, 14988.00); INSERT INTO `order_items` VALUES (65, 2, 113, 83.00, 70499.00); INSERT INTO `order_items` VALUES (65, 3, 116, 35.00, 73199.00); INSERT INTO `order_items` VALUES (65, 4, 248, 42.00, 277498.00); INSERT INTO `order_items` VALUES (65, 5, 119, 141.00, 89999.00); INSERT INTO `order_items` VALUES (65, 6, 262, 118.00, 144999.00); INSERT INTO `order_items` VALUES (66, 1, 77, 143.00, 69599.00); INSERT INTO `order_items` VALUES (66, 2, 218, 40.00, 138889.00); INSERT INTO `order_items` VALUES (66, 3, 286, 35.00, 234.00); INSERT INTO `order_items` VALUES (66, 4, 103, 88.00, 80999.00); INSERT INTO `order_items` VALUES (66, 5, 174, 66.00, 79826.00); INSERT INTO `order_items` VALUES (66, 6, 97, 130.00, 5987.00); INSERT INTO `order_items` VALUES (66, 7, 49, 78.00, 149999.00); INSERT INTO `order_items` VALUES (66, 8, 75, 122.00, 62404.00); INSERT INTO `order_items` VALUES (66, 9, 279, 90.00, 131899.00); INSERT INTO `order_items` VALUES (67, 1, 287, 61.00, 32999.00); INSERT INTO `order_items` VALUES (67, 2, 144, 121.00, 28979.00); INSERT INTO `order_items` VALUES (67, 3, 167, 94.00, 101046.00); INSERT INTO `order_items` VALUES (67, 4, 109, 117.00, 71399.00); INSERT INTO `order_items` VALUES (67, 5, 80, 129.00, 56489.00); INSERT INTO `order_items` VALUES (67, 6, 108, 82.00, 84999.00); INSERT INTO `order_items` VALUES (67, 7, 78, 124.00, 68699.00); INSERT INTO `order_items` VALUES (67, 8, 247, 39.00, 33999.00); INSERT INTO `order_items` VALUES (67, 9, 91, 138.00, 225999.00); INSERT INTO `order_items` VALUES (67, 10, 239, 45.00, 73999.00); INSERT INTO `order_items` VALUES (68, 1, 163, 98.00, 189999.00); INSERT INTO `order_items` VALUES (68, 2, 248, 42.00, 277498.00); INSERT INTO `order_items` VALUES (68, 3, 183, 50.00, 89999.00); INSERT INTO `order_items` VALUES (68, 4, 163, 125.00, 189999.00); INSERT INTO `order_items` VALUES (68, 5, 108, 150.00, 84999.00); INSERT INTO `order_items` VALUES (68, 6, 13, 141.00, 70499.00); INSERT INTO `order_items` VALUES (68, 7, 189, 139.00, 649.00); INSERT INTO `order_items` VALUES (68, 8, 204, 56.00, 68699.00); INSERT INTO `order_items` VALUES (68, 9, 177, 84.00, 175999.00); INSERT INTO `order_items` VALUES (69, 1, 206, 57.00, 4139.00); INSERT INTO `order_items` VALUES (69, 2, 71, 66.00, 660.00); INSERT INTO `order_items` VALUES (69, 3, 253, 112.00, 57999.00); INSERT INTO `order_items` VALUES (69, 4, 82, 58.00, 149989.00); INSERT INTO `order_items` VALUES (69, 5, 278, 71.00, 67799.00); INSERT INTO `order_items` VALUES (69, 6, 3, 46.00, 79999.00); INSERT INTO `order_items` VALUES (69, 7, 79, 49.00, 65999.00); INSERT INTO `order_items` VALUES (69, 8, 169, 67.00, 184489.00); INSERT INTO `order_items` VALUES (69, 9, 261, 55.00, 150499.00); INSERT INTO `order_items` VALUES (70, 1, 185, 146.00, 87398.00); INSERT INTO `order_items` VALUES (70, 2, 83, 52.00, 82999.00); INSERT INTO `order_items` VALUES (70, 3, 102, 84.00, 204269.00); INSERT INTO `order_items` VALUES (70, 4, 82, 139.00, 149989.00); INSERT INTO `order_items` VALUES (70, 5, 124, 106.00, 59499.00); INSERT INTO `order_items` VALUES (70, 6, 50, 68.00, 886799.00); INSERT INTO `order_items` VALUES (70, 7, 32, 132.00, 46999.00); INSERT INTO `order_items` VALUES (71, 1, 19, 146.00, 170437.00); INSERT INTO `order_items` VALUES (71, 2, 241, 38.00, 1756.00); INSERT INTO `order_items` VALUES (71, 3, 195, 75.00, 105599.00); INSERT INTO `order_items` VALUES (72, 1, 129, 101.00, 73499.00); INSERT INTO `order_items` VALUES (72, 2, 211, 123.00, 106499.00); INSERT INTO `order_items` VALUES (72, 3, 273, 145.00, 44364.00); INSERT INTO `order_items` VALUES (73, 1, 245, 120.00, 1699.00); INSERT INTO `order_items` VALUES (73, 2, 35, 130.00, 131499.00); INSERT INTO `order_items` VALUES (73, 3, 31, 102.00, 44372.00); INSERT INTO `order_items` VALUES (73, 4, 45, 54.00, 250169.00); INSERT INTO `order_items` VALUES (73, 5, 192, 124.00, 51999.00); INSERT INTO `order_items` VALUES (74, 1, 104, 97.00, 8388.00); INSERT INTO `order_items` VALUES (74, 2, 250, 86.00, 33899.00); INSERT INTO `order_items` VALUES (74, 3, 242, 61.00, 175199.00); INSERT INTO `order_items` VALUES (74, 4, 106, 82.00, 60895.00); INSERT INTO `order_items` VALUES (74, 5, 3, 101.00, 79999.00); INSERT INTO `order_items` VALUES (74, 6, 187, 137.00, 35398.00); INSERT INTO `order_items` VALUES (74, 7, 27, 92.00, 80074.00); INSERT INTO `order_items` VALUES (75, 1, 58, 73.00, 78498.00); INSERT INTO `order_items` VALUES (75, 2, 187, 74.00, 35398.00); INSERT INTO `order_items` VALUES (75, 3, 33, 143.00, 5265.00); INSERT INTO `order_items` VALUES (75, 4, 142, 115.00, 299889.00); INSERT INTO `order_items` VALUES (75, 5, 192, 37.00, 51999.00); INSERT INTO `order_items` VALUES (75, 6, 95, 81.00, 10999.00); INSERT INTO `order_items` VALUES (75, 7, 106, 74.00, 60895.00); INSERT INTO `order_items` VALUES (75, 8, 24, 82.00, 6689.00); INSERT INTO `order_items` VALUES (75, 9, 20, 34.00, 71999.00); INSERT INTO `order_items` VALUES (75, 10, 72, 86.00, 58999.00); INSERT INTO `order_items` VALUES (75, 11, 6, 128.00, 84999.00); INSERT INTO `order_items` VALUES (76, 1, 109, 92.00, 71399.00); INSERT INTO `order_items` VALUES (76, 2, 177, 98.00, 175999.00); INSERT INTO `order_items` VALUES (76, 3, 163, 134.00, 189999.00); INSERT INTO `order_items` VALUES (76, 4, 272, 56.00, 107399.00); INSERT INTO `order_items` VALUES (76, 5, 89, 133.00, 74999.00); INSERT INTO `order_items` VALUES (76, 6, 167, 46.00, 101046.00); INSERT INTO `order_items` VALUES (76, 7, 196, 125.00, 109999.00); INSERT INTO `order_items` VALUES (76, 8, 201, 91.00, 6535.00); INSERT INTO `order_items` VALUES (76, 9, 155, 78.00, 58895.00); INSERT INTO `order_items` VALUES (76, 10, 95, 106.00, 10999.00); INSERT INTO `order_items` VALUES (77, 1, 203, 65.00, 67138.00); INSERT INTO `order_items` VALUES (77, 2, 168, 136.00, 4399.00); INSERT INTO `order_items` VALUES (77, 3, 218, 143.00, 138889.00); INSERT INTO `order_items` VALUES (77, 4, 2, 99.00, 255499.00); INSERT INTO `order_items` VALUES (77, 5, 271, 148.00, 54959.00); INSERT INTO `order_items` VALUES (78, 1, 92, 147.00, 2200.00); INSERT INTO `order_items` VALUES (78, 2, 169, 50.00, 184489.00); INSERT INTO `order_items` VALUES (78, 3, 125, 119.00, 76899.00); INSERT INTO `order_items` VALUES (78, 4, 200, 87.00, 62095.00); INSERT INTO `order_items` VALUES (78, 5, 181, 37.00, 99999.00); INSERT INTO `order_items` VALUES (78, 6, 206, 145.00, 4139.00); INSERT INTO `order_items` VALUES (79, 1, 285, 145.00, 33999.00); INSERT INTO `order_items` VALUES (79, 2, 265, 53.00, 143199.00); INSERT INTO `order_items` VALUES (79, 3, 204, 138.00, 68699.00); INSERT INTO `order_items` VALUES (79, 4, 63, 146.00, 57296.00); INSERT INTO `order_items` VALUES (80, 1, 213, 63.00, 146996.00); INSERT INTO `order_items` VALUES (81, 1, 128, 133.00, 74163.00); INSERT INTO `order_items` VALUES (81, 2, 241, 134.00, 1756.00); INSERT INTO `order_items` VALUES (81, 3, 69, 104.00, 67875.00); INSERT INTO `order_items` VALUES (81, 4, 49, 83.00, 149999.00); INSERT INTO `order_items` VALUES (81, 5, 55, 144.00, 15099.00); INSERT INTO `order_items` VALUES (81, 6, 65, 61.00, 119999.00); INSERT INTO `order_items` VALUES (81, 7, 79, 127.00, 65999.00); INSERT INTO `order_items` VALUES (82, 1, 91, 42.00, 225999.00); INSERT INTO `order_items` VALUES (82, 2, 107, 71.00, 644.00); INSERT INTO `order_items` VALUES (82, 3, 254, 121.00, 11999.00); INSERT INTO `order_items` VALUES (82, 4, 157, 113.00, 38899.00); INSERT INTO `order_items` VALUES (82, 5, 48, 59.00, 12185.00); INSERT INTO `order_items` VALUES (82, 6, 180, 56.00, 27999.00); INSERT INTO `order_items` VALUES (82, 7, 70, 31.00, 71099.00); INSERT INTO `order_items` VALUES (82, 8, 213, 56.00, 146996.00); INSERT INTO `order_items` VALUES (82, 9, 284, 138.00, 5499.00); INSERT INTO `order_items` VALUES (83, 1, 264, 35.00, 8899.00); INSERT INTO `order_items` VALUES (83, 2, 196, 54.00, 109999.00); INSERT INTO `order_items` VALUES (83, 3, 116, 76.00, 73199.00); INSERT INTO `order_items` VALUES (83, 4, 261, 106.00, 150499.00); INSERT INTO `order_items` VALUES (83, 5, 101, 122.00, 63599.00); INSERT INTO `order_items` VALUES (83, 6, 233, 86.00, 5999.00); INSERT INTO `order_items` VALUES (83, 7, 18, 49.00, 799.00); INSERT INTO `order_items` VALUES (83, 8, 174, 117.00, 79826.00); INSERT INTO `order_items` VALUES (84, 1, 106, 137.00, 60895.00); INSERT INTO `order_items` VALUES (84, 2, 199, 137.00, 64799.00); INSERT INTO `order_items` VALUES (84, 3, 269, 147.00, 75999.00); INSERT INTO `order_items` VALUES (84, 4, 95, 36.00, 10999.00); INSERT INTO `order_items` VALUES (84, 5, 87, 119.00, 75999.00); INSERT INTO `order_items` VALUES (84, 6, 131, 34.00, 27999.00); INSERT INTO `order_items` VALUES (85, 1, 155, 114.00, 58895.00); INSERT INTO `order_items` VALUES (85, 2, 230, 35.00, 13669.00); INSERT INTO `order_items` VALUES (86, 1, 202, 46.00, 71399.00); INSERT INTO `order_items` VALUES (86, 2, 156, 47.00, 39499.00); INSERT INTO `order_items` VALUES (86, 3, 287, 45.00, 32999.00); INSERT INTO `order_items` VALUES (86, 4, 121, 76.00, 72199.00); INSERT INTO `order_items` VALUES (87, 1, 47, 123.00, 237709.00); INSERT INTO `order_items` VALUES (87, 2, 233, 96.00, 5999.00); INSERT INTO `order_items` VALUES (87, 3, 130, 119.00, 11745.00); INSERT INTO `order_items` VALUES (87, 4, 127, 59.00, 71999.00); INSERT INTO `order_items` VALUES (87, 5, 265, 74.00, 143199.00); INSERT INTO `order_items` VALUES (87, 6, 174, 84.00, 79826.00); INSERT INTO `order_items` VALUES (87, 7, 7, 66.00, 68099.00); INSERT INTO `order_items` VALUES (87, 8, 257, 110.00, 8495.00); INSERT INTO `order_items` VALUES (87, 9, 121, 142.00, 72199.00); INSERT INTO `order_items` VALUES (87, 10, 76, 96.00, 62999.00); INSERT INTO `order_items` VALUES (87, 11, 271, 58.00, 54959.00); INSERT INTO `order_items` VALUES (88, 1, 278, 139.00, 67799.00); INSERT INTO `order_items` VALUES (88, 2, 11, 106.00, 201511.00); INSERT INTO `order_items` VALUES (89, 1, 247, 45.00, 33999.00); INSERT INTO `order_items` VALUES (89, 2, 102, 84.00, 204269.00); INSERT INTO `order_items` VALUES (89, 3, 224, 89.00, 34999.00); INSERT INTO `order_items` VALUES (89, 4, 253, 126.00, 57999.00); INSERT INTO `order_items` VALUES (89, 5, 44, 55.00, 4937.00); INSERT INTO `order_items` VALUES (89, 6, 122, 140.00, 72299.00); INSERT INTO `order_items` VALUES (89, 7, 76, 109.00, 62999.00); INSERT INTO `order_items` VALUES (89, 8, 151, 127.00, 28197.00); INSERT INTO `order_items` VALUES (90, 1, 65, 84.00, 119999.00); INSERT INTO `order_items` VALUES (90, 2, 64, 60.00, 52599.00); INSERT INTO `order_items` VALUES (90, 3, 134, 106.00, 29572.00); INSERT INTO `order_items` VALUES (90, 4, 93, 146.00, 211672.00); INSERT INTO `order_items` VALUES (90, 5, 73, 129.00, 799.00); INSERT INTO `order_items` VALUES (90, 6, 185, 147.00, 87398.00); INSERT INTO `order_items` VALUES (90, 7, 250, 125.00, 33899.00); INSERT INTO `order_items` VALUES (90, 8, 92, 49.00, 2200.00); INSERT INTO `order_items` VALUES (91, 1, 122, 89.00, 72299.00); INSERT INTO `order_items` VALUES (91, 2, 220, 127.00, 75999.00); INSERT INTO `order_items` VALUES (91, 3, 266, 83.00, 141899.00); INSERT INTO `order_items` VALUES (91, 4, 194, 75.00, 39742.00); INSERT INTO `order_items` VALUES (91, 5, 272, 111.00, 107399.00); INSERT INTO `order_items` VALUES (91, 6, 123, 37.00, 317744.00); INSERT INTO `order_items` VALUES (91, 7, 118, 113.00, 69989.00); INSERT INTO `order_items` VALUES (91, 8, 196, 102.00, 109999.00); INSERT INTO `order_items` VALUES (91, 9, 43, 44.00, 29898.00); INSERT INTO `order_items` VALUES (91, 10, 269, 104.00, 75999.00); INSERT INTO `order_items` VALUES (91, 11, 226, 77.00, 30985.00); INSERT INTO `order_items` VALUES (92, 1, 208, 114.00, 119999.00); INSERT INTO `order_items` VALUES (92, 2, 34, 126.00, 41798.00); INSERT INTO `order_items` VALUES (92, 3, 65, 132.00, 119999.00); INSERT INTO `order_items` VALUES (92, 4, 110, 111.00, 319297.00); INSERT INTO `order_items` VALUES (92, 5, 114, 112.00, 82061.00); INSERT INTO `order_items` VALUES (92, 6, 164, 91.00, 1850.00); INSERT INTO `order_items` VALUES (92, 7, 108, 104.00, 84999.00); INSERT INTO `order_items` VALUES (93, 1, 257, 70.00, 8495.00); INSERT INTO `order_items` VALUES (93, 2, 169, 46.00, 184489.00); INSERT INTO `order_items` VALUES (93, 3, 251, 30.00, 33781.00); INSERT INTO `order_items` VALUES (93, 4, 43, 113.00, 29898.00); INSERT INTO `order_items` VALUES (93, 5, 121, 141.00, 72199.00); INSERT INTO `order_items` VALUES (94, 1, 255, 38.00, 9099.00); INSERT INTO `order_items` VALUES (94, 2, 186, 146.00, 144998.00); INSERT INTO `order_items` VALUES (94, 3, 218, 86.00, 138889.00); INSERT INTO `order_items` VALUES (94, 4, 80, 133.00, 56489.00); INSERT INTO `order_items` VALUES (94, 5, 181, 143.00, 99999.00); INSERT INTO `order_items` VALUES (94, 6, 4, 111.00, 269999.00); INSERT INTO `order_items` VALUES (94, 7, 172, 37.00, 35849.00); INSERT INTO `order_items` VALUES (94, 8, 258, 73.00, 5798.00); INSERT INTO `order_items` VALUES (94, 9, 12, 33.00, 82498.00); INSERT INTO `order_items` VALUES (95, 1, 52, 138.00, 167698.00); INSERT INTO `order_items` VALUES (95, 2, 143, 64.00, 40299.00); INSERT INTO `order_items` VALUES (95, 3, 271, 69.00, 54959.00); INSERT INTO `order_items` VALUES (95, 4, 86, 123.00, 80498.00); INSERT INTO `order_items` VALUES (95, 5, 107, 76.00, 644.00); INSERT INTO `order_items` VALUES (95, 6, 71, 135.00, 660.00); INSERT INTO `order_items` VALUES (96, 1, 260, 34.00, 26799.00); INSERT INTO `order_items` VALUES (97, 1, 110, 39.00, 319297.00); INSERT INTO `order_items` VALUES (97, 2, 207, 82.00, 325499.00); INSERT INTO `order_items` VALUES (97, 3, 270, 61.00, 76999.00); INSERT INTO `order_items` VALUES (97, 4, 33, 67.00, 5265.00); INSERT INTO `order_items` VALUES (97, 5, 99, 48.00, 6806.00); INSERT INTO `order_items` VALUES (97, 6, 219, 132.00, 129973.00); INSERT INTO `order_items` VALUES (98, 1, 66, 104.00, 39999.00); INSERT INTO `order_items` VALUES (98, 2, 48, 44.00, 12185.00); INSERT INTO `order_items` VALUES (99, 1, 95, 66.00, 10999.00); INSERT INTO `order_items` VALUES (99, 2, 118, 37.00, 69989.00); INSERT INTO `order_items` VALUES (99, 3, 84, 98.00, 4403.00); INSERT INTO `order_items` VALUES (99, 4, 36, 71.00, 129999.00); INSERT INTO `order_items` VALUES (99, 5, 200, 58.00, 62095.00); INSERT INTO `order_items` VALUES (99, 6, 1, 43.00, 64099.00); INSERT INTO `order_items` VALUES (99, 7, 201, 31.00, 6535.00); INSERT INTO `order_items` VALUES (99, 8, 102, 101.00, 204269.00); INSERT INTO `order_items` VALUES (99, 9, 17, 144.00, 69901.00); INSERT INTO `order_items` VALUES (100, 1, 280, 70.00, 14988.00); INSERT INTO `order_items` VALUES (101, 1, 17, 47.00, 69901.00); INSERT INTO `order_items` VALUES (101, 2, 113, 134.00, 70499.00); INSERT INTO `order_items` VALUES (101, 3, 135, 134.00, 12788.00); INSERT INTO `order_items` VALUES (101, 4, 284, 52.00, 5499.00); INSERT INTO `order_items` VALUES (101, 5, 150, 36.00, 28198.00); INSERT INTO `order_items` VALUES (101, 6, 20, 138.00, 71999.00); INSERT INTO `order_items` VALUES (101, 7, 102, 123.00, 204269.00); INSERT INTO `order_items` VALUES (102, 1, 196, 69.00, 109999.00); INSERT INTO `order_items` VALUES (102, 2, 95, 117.00, 10999.00); INSERT INTO `order_items` VALUES (102, 3, 247, 149.00, 33999.00); INSERT INTO `order_items` VALUES (103, 1, 6, 117.00, 84999.00); INSERT INTO `order_items` VALUES (103, 2, 258, 142.00, 5798.00); INSERT INTO `order_items` VALUES (104, 1, 129, 74.00, 73499.00); INSERT INTO `order_items` VALUES (104, 2, 171, 90.00, 38298.00); INSERT INTO `order_items` VALUES (104, 3, 45, 48.00, 250169.00); INSERT INTO `order_items` VALUES (104, 4, 48, 51.00, 12185.00); INSERT INTO `order_items` VALUES (104, 5, 281, 85.00, 86498.00); INSERT INTO `order_items` VALUES (104, 6, 51, 139.00, 226999.00); INSERT INTO `order_items` VALUES (104, 7, 178, 145.00, 199989.00); INSERT INTO `order_items` VALUES (105, 1, 31, 116.00, 44372.00); INSERT INTO `order_items` VALUES (105, 2, 242, 67.00, 175199.00); INSERT INTO `order_items` VALUES (105, 3, 275, 45.00, 39999.00); INSERT INTO `order_items` VALUES (105, 4, 138, 80.00, 64599.00); INSERT INTO `order_items` VALUES (105, 5, 103, 77.00, 80999.00); INSERT INTO `order_items` VALUES (105, 6, 183, 79.00, 89999.00); -- ---------------------------- -- Table structure for orders -- ---------------------------- DROP TABLE IF EXISTS `orders`; CREATE TABLE `orders` ( `order_id` smallint NOT NULL, `customer_id` smallint NOT NULL, `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `salesman_id` smallint NULL DEFAULT NULL, `order_date` date NOT NULL, PRIMARY KEY (`order_id`) USING BTREE, INDEX `fk_orders_customer`(`customer_id` ASC) USING BTREE, INDEX `fk_orders_salesman`(`salesman_id` ASC) USING BTREE, CONSTRAINT `fk_orders_customer` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`customer_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_orders_salesman` FOREIGN KEY (`salesman_id`) REFERENCES `employees` (`employee_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of orders -- ---------------------------- INSERT INTO `orders` VALUES (1, 4, 'Pending', 56, '2015-10-17'); INSERT INTO `orders` VALUES (2, 4, 'Shipped', NULL, '2026-02-15'); INSERT INTO `orders` VALUES (3, 5, 'Shipped', NULL, '2026-02-17'); INSERT INTO `orders` VALUES (4, 8, 'Shipped', 59, '2009-02-15'); INSERT INTO `orders` VALUES (5, 5, 'Canceled', 56, '2009-02-17'); INSERT INTO `orders` VALUES (6, 6, 'Shipped', NULL, '2009-02-15'); INSERT INTO `orders` VALUES (7, 7, 'Shipped', NULL, '2015-02-17'); INSERT INTO `orders` VALUES (8, 8, 'Shipped', NULL, '2014-02-17'); INSERT INTO `orders` VALUES (9, 9, 'Shipped', NULL, '2014-02-17'); INSERT INTO `orders` VALUES (10, 44, 'Pending', NULL, '2024-09-17'); INSERT INTO `orders` VALUES (11, 45, 'Shipped', NULL, '2029-11-16'); INSERT INTO `orders` VALUES (12, 46, 'Shipped', NULL, '2029-11-16'); INSERT INTO `orders` VALUES (13, 47, 'Shipped', NULL, '2029-11-16'); INSERT INTO `orders` VALUES (14, 48, 'Shipped', NULL, '2028-09-17'); INSERT INTO `orders` VALUES (15, 49, 'Shipped', NULL, '2027-09-17'); INSERT INTO `orders` VALUES (16, 16, 'Pending', NULL, '2027-09-16'); INSERT INTO `orders` VALUES (17, 17, 'Shipped', NULL, '2027-09-17'); INSERT INTO `orders` VALUES (18, 18, 'Shipped', NULL, '2016-09-16'); INSERT INTO `orders` VALUES (19, 19, 'Shipped', NULL, '2027-05-16'); INSERT INTO `orders` VALUES (20, 20, 'Shipped', NULL, '2027-05-17'); INSERT INTO `orders` VALUES (21, 21, 'Pending', NULL, '2027-05-17'); INSERT INTO `orders` VALUES (22, 22, 'Canceled', NULL, '2026-05-16'); INSERT INTO `orders` VALUES (23, 23, 'Shipped', NULL, '2007-09-16'); INSERT INTO `orders` VALUES (24, 41, 'Shipped', NULL, '2007-09-16'); INSERT INTO `orders` VALUES (25, 42, 'Shipped', NULL, '2024-09-16'); INSERT INTO `orders` VALUES (26, 46, 'Shipped', 62, '2016-09-16'); INSERT INTO `orders` VALUES (27, 43, 'Canceled', NULL, '2016-09-16'); INSERT INTO `orders` VALUES (28, 6, 'Canceled', 57, '2015-09-17'); INSERT INTO `orders` VALUES (29, 44, 'Shipped', NULL, '2014-09-17'); INSERT INTO `orders` VALUES (30, 45, 'Shipped', NULL, '2012-09-17'); INSERT INTO `orders` VALUES (31, 46, 'Canceled', NULL, '2012-09-17'); INSERT INTO `orders` VALUES (32, 47, 'Shipped', NULL, '2009-03-17'); INSERT INTO `orders` VALUES (33, 48, 'Shipped', NULL, '2007-03-17'); INSERT INTO `orders` VALUES (34, 49, 'Shipped', NULL, '2012-06-16'); INSERT INTO `orders` VALUES (35, 50, 'Shipped', NULL, '2005-09-16'); INSERT INTO `orders` VALUES (36, 51, 'Shipped', NULL, '2005-09-17'); INSERT INTO `orders` VALUES (37, 52, 'Shipped', NULL, '2019-02-17'); INSERT INTO `orders` VALUES (38, 53, 'Canceled', 57, '2031-05-15'); INSERT INTO `orders` VALUES (39, 54, 'Shipped', 62, '2022-10-16'); INSERT INTO `orders` VALUES (40, 55, 'Shipped', 62, '2011-05-17'); INSERT INTO `orders` VALUES (41, 9, 'Shipped', 59, '2011-05-17'); INSERT INTO `orders` VALUES (42, 56, 'Canceled', 64, '2003-05-15'); INSERT INTO `orders` VALUES (43, 47, 'Shipped', 62, '2002-05-15'); INSERT INTO `orders` VALUES (44, 2, 'Pending', 55, '2020-02-17'); INSERT INTO `orders` VALUES (45, 57, 'Shipped', 64, '2020-02-17'); INSERT INTO `orders` VALUES (46, 58, 'Pending', 62, '2020-02-17'); INSERT INTO `orders` VALUES (47, 59, 'Canceled', 62, '2010-10-16'); INSERT INTO `orders` VALUES (48, 60, 'Canceled', 64, '2010-10-16'); INSERT INTO `orders` VALUES (49, 61, 'Shipped', 55, '2002-10-16'); INSERT INTO `orders` VALUES (50, 62, 'Pending', 55, '2002-10-16'); INSERT INTO `orders` VALUES (51, 63, 'Shipped', 59, '2002-10-16'); INSERT INTO `orders` VALUES (52, 64, 'Shipped', 60, '2002-10-16'); INSERT INTO `orders` VALUES (53, 48, 'Shipped', 62, '2029-09-16'); INSERT INTO `orders` VALUES (54, 65, 'Shipped', 56, '2029-09-16'); INSERT INTO `orders` VALUES (55, 66, 'Pending', 59, '2029-09-16'); INSERT INTO `orders` VALUES (56, 67, 'Canceled', 55, '2029-09-16'); INSERT INTO `orders` VALUES (57, 68, 'Shipped', 57, '2024-09-17'); INSERT INTO `orders` VALUES (58, 69, 'Shipped', 57, '2024-09-16'); INSERT INTO `orders` VALUES (59, 70, 'Shipped', 59, '2029-06-15'); INSERT INTO `orders` VALUES (60, 1, 'Shipped', 62, '2030-06-17'); INSERT INTO `orders` VALUES (61, 2, 'Shipped', 54, '2030-06-16'); INSERT INTO `orders` VALUES (62, 3, 'Shipped', 62, '2030-06-15'); INSERT INTO `orders` VALUES (63, 4, 'Shipped', 61, '2030-06-16'); INSERT INTO `orders` VALUES (64, 5, 'Shipped', 64, '2021-06-16'); INSERT INTO `orders` VALUES (65, 6, 'Shipped', 64, '2021-06-13'); INSERT INTO `orders` VALUES (66, 7, 'Canceled', 61, '2021-06-16'); INSERT INTO `orders` VALUES (67, 8, 'Canceled', 61, '2014-06-16'); INSERT INTO `orders` VALUES (68, 9, 'Pending', NULL, '2013-06-16'); INSERT INTO `orders` VALUES (69, 44, 'Canceled', 54, '2017-03-17'); INSERT INTO `orders` VALUES (70, 45, 'Canceled', 61, '2021-02-17'); INSERT INTO `orders` VALUES (71, 46, 'Shipped', 54, '2021-02-17'); INSERT INTO `orders` VALUES (72, 47, 'Shipped', 64, '2017-02-16'); INSERT INTO `orders` VALUES (73, 48, 'Shipped', NULL, '2017-02-16'); INSERT INTO `orders` VALUES (74, 49, 'Shipped', 64, '2010-02-17'); INSERT INTO `orders` VALUES (75, 16, 'Shipped', NULL, '2010-02-17'); INSERT INTO `orders` VALUES (76, 17, 'Shipped', 55, '2010-02-17'); INSERT INTO `orders` VALUES (77, 1, 'Shipped', 60, '2002-09-17'); INSERT INTO `orders` VALUES (78, 2, 'Pending', 64, '2014-12-15'); INSERT INTO `orders` VALUES (79, 2, 'Shipped', 64, '2014-12-16'); INSERT INTO `orders` VALUES (80, 3, 'Shipped', 64, '2013-12-16'); INSERT INTO `orders` VALUES (81, 49, 'Shipped', 62, '2013-12-16'); INSERT INTO `orders` VALUES (82, 44, 'Shipped', 60, '2003-12-16'); INSERT INTO `orders` VALUES (83, 16, 'Shipped', 62, '2002-12-16'); INSERT INTO `orders` VALUES (84, 3, 'Shipped', 64, '2001-12-15'); INSERT INTO `orders` VALUES (85, 4, 'Pending', 55, '2001-12-16'); INSERT INTO `orders` VALUES (86, 5, 'Pending', 60, '2030-11-16'); INSERT INTO `orders` VALUES (87, 7, 'Canceled', 57, '2001-12-16'); INSERT INTO `orders` VALUES (88, 6, 'Shipped', 61, '2001-11-17'); INSERT INTO `orders` VALUES (89, 7, 'Shipped', 55, '2027-10-15'); INSERT INTO `orders` VALUES (90, 8, 'Pending', 55, '2028-10-15'); INSERT INTO `orders` VALUES (91, 9, 'Pending', 56, '2028-10-16'); INSERT INTO `orders` VALUES (92, 44, 'Shipped', 59, '2028-10-15'); INSERT INTO `orders` VALUES (93, 17, 'Shipped', 62, '2027-10-16'); INSERT INTO `orders` VALUES (94, 1, 'Shipped', 62, '2027-10-17'); INSERT INTO `orders` VALUES (95, 45, 'Shipped', 59, '2019-09-16'); INSERT INTO `orders` VALUES (96, 46, 'Shipped', 56, '2014-09-16'); INSERT INTO `orders` VALUES (97, 47, 'Canceled', 60, '2012-07-16'); INSERT INTO `orders` VALUES (98, 48, 'Shipped', 55, '2018-03-17'); INSERT INTO `orders` VALUES (99, 49, 'Shipped', 60, '2007-09-17'); INSERT INTO `orders` VALUES (100, 16, 'Pending', 54, '2005-09-17'); INSERT INTO `orders` VALUES (101, 3, 'Pending', 55, '2003-09-17'); INSERT INTO `orders` VALUES (102, 45, 'Shipped', 61, '2020-12-16'); INSERT INTO `orders` VALUES (103, 17, 'Pending', 64, '2008-02-16'); INSERT INTO `orders` VALUES (104, 18, 'Shipped', 60, '2001-02-17'); INSERT INTO `orders` VALUES (105, 1, 'Pending', 54, '2017-11-16'); -- ---------------------------- -- Table structure for product_categories -- ---------------------------- DROP TABLE IF EXISTS `product_categories`; CREATE TABLE `product_categories` ( `category_id` smallint NOT NULL, `category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, PRIMARY KEY (`category_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of product_categories -- ---------------------------- INSERT INTO `product_categories` VALUES (1, 'CPU'); INSERT INTO `product_categories` VALUES (2, 'Video Card'); INSERT INTO `product_categories` VALUES (3, 'RAM'); INSERT INTO `product_categories` VALUES (4, 'Mother Board'); INSERT INTO `product_categories` VALUES (5, 'Storage'); -- ---------------------------- -- Table structure for products -- ---------------------------- DROP TABLE IF EXISTS `products`; CREATE TABLE `products` ( `product_id` smallint NOT NULL, `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `description` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `standard_cost` decimal(9, 2) NOT NULL, `list_price` decimal(9, 2) NOT NULL, `category_id` smallint NOT NULL, PRIMARY KEY (`product_id`) USING BTREE, INDEX `fk_products_category`(`category_id` ASC) USING BTREE, CONSTRAINT `fk_products_category` FOREIGN KEY (`category_id`) REFERENCES `product_categories` (`category_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of products -- ---------------------------- INSERT INTO `products` VALUES (1, 'GSkill Ripjaws V Series', 'Speed:DDR4-3000,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB', 45036.00, 64099.00, 5); INSERT INTO `products` VALUES (2, 'Intel Xeon E5-2697 V4', 'Speed:23GHz,Cores:18,TDP:145W', 21444.00, 255499.00, 1); INSERT INTO `products` VALUES (3, 'Corsair CB-9060011-WW', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:157GHz', 57351.00, 79999.00, 2); INSERT INTO `products` VALUES (4, 'AMD 100-505989', 'Chipset:FirePro W9100,Memory:32GBCore Clock:930MHz', 212867.00, 269999.00, 2); INSERT INTO `products` VALUES (5, 'PNY VCQK6000-PB', 'Chipset:Quadro K6000,Memory:12GBCore Clock:902MHz', 174031.00, 229079.00, 2); INSERT INTO `products` VALUES (6, 'Zotac ZT-P10810A-10P', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:148GHz', 70235.00, 84999.00, 2); INSERT INTO `products` VALUES (7, 'GSkill Ripjaws V Series', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB', 6024.00, 68099.00, 5); INSERT INTO `products` VALUES (8, 'Intel Xeon E5-1650 V4', 'Speed:36GHz,Cores:6,TDP:140W', 53547.00, 60199.00, 1); INSERT INTO `products` VALUES (9, 'Intel Xeon E5-2640 V4', 'Speed:24GHz,Cores:10,TDP:90W', 73871.00, 89999.00, 1); INSERT INTO `products` VALUES (10, 'Crucial', 'Speed:DDR4-2133,Type:288-pin DIMM,CAS:15Module:2x16GBSize:32GB', 58033.00, 81199.00, 5); INSERT INTO `products` VALUES (11, 'PNY VCQP5000-PB', 'Chipset:Quadro P5000,Memory:16GBCore Clock:161GHz', 160221.00, 201511.00, 2); INSERT INTO `products` VALUES (12, 'Gigabyte GV-N108TAORUSX W-11GD', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:163GHz', 59605.00, 82498.00, 2); INSERT INTO `products` VALUES (13, 'GSkill Ripjaws V Series', 'Speed:DDR4-3333,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB', 61863.00, 70499.00, 5); INSERT INTO `products` VALUES (14, 'GSkill Ripjaws V Series', 'Speed:DDR4-3333,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB', 63365.00, 70499.00, 5); INSERT INTO `products` VALUES (15, 'GSkill Trident Z', 'Speed:DDR4-3466,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB', 60156.00, 72599.00, 5); INSERT INTO `products` VALUES (16, 'Intel Core i7-6900K', 'Speed:32GHz,Cores:8,TDP:140W', 79289.00, 88989.00, 1); INSERT INTO `products` VALUES (17, 'Corsair Vengeance LPX', 'Speed:DDR4-3333,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 59542.00, 69901.00, 5); INSERT INTO `products` VALUES (18, 'Crucial', 'Speed:DDR4-2400,Type:288-pin DIMM,CAS:17Module:1x64GBSize:64GB', 60404.00, 799.00, 5); INSERT INTO `products` VALUES (19, 'Intel Core i7-6950X (OEM/Tray)', 'Speed:30GHz,Cores:10,TDP:140W', 147956.00, 170437.00, 1); INSERT INTO `products` VALUES (20, 'Corsair Dominator Platinum', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 61653.00, 71999.00, 5); INSERT INTO `products` VALUES (21, 'Corsair Dominator Platinum', 'Speed:DDR4-3466,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB', 60989.00, 74999.00, 5); INSERT INTO `products` VALUES (22, 'Seagate ST3000DM008', 'Series:Barracuda,Type:7200RPM,Capacity:3TB,Cache:64MB', 6163.00, 8361.00, 5); INSERT INTO `products` VALUES (23, 'Western Digital WDS250G1B0A', 'Series:Blue,Type:SSD,Capacity:250GB,Cache:N/A', 7254.00, 8989.00, 5); INSERT INTO `products` VALUES (24, 'Seagate ST2000DM006', 'Series:Barracuda,Type:7200RPM,Capacity:2TB,Cache:64MB', 4793.00, 6689.00, 5); INSERT INTO `products` VALUES (25, 'Samsung MZ-75E250B/AM', 'Series:850 EVO-Series,Type:SSD,Capacity:250GB,Cache:N/A', 8798.00, 10488.00, 5); INSERT INTO `products` VALUES (26, 'Samsung MZ-75E500B/AM', 'Series:850 EVO-Series,Type:SSD,Capacity:500GB,Cache:N/A', 15781.00, 17809.00, 5); INSERT INTO `products` VALUES (27, 'Intel Core i7-3960X Extreme Edition', 'Speed:33GHz,Cores:6,TDP:130W', 57341.00, 80074.00, 1); INSERT INTO `products` VALUES (28, 'Supermicro X9SRH-7TF', 'CPU:LGA2011,Form Factor:ATX,RAM Slots:8,Max RAM:64GB', 41164.00, 47999.00, 4); INSERT INTO `products` VALUES (29, 'Corsair Vengeance LPX', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 5717.00, 64599.00, 5); INSERT INTO `products` VALUES (30, 'GSkill Ripjaws V Series', 'Speed:DDR4-2800,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB', 45254.00, 6452.00, 5); INSERT INTO `products` VALUES (31, 'Supermicro MBD-X10DAX', 'CPU:LGA2011-3 x 2,Form Factor:EATX,RAM Slots:16,Max RAM:', 38524.00, 44372.00, 4); INSERT INTO `products` VALUES (32, 'ASRock X99 Extreme11', 'CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB', 38055.00, 46999.00, 4); INSERT INTO `products` VALUES (33, 'ADATA ASU800SS-128GT-C', 'Series:Ultimate SU800,Type:SSD,Capacity:128GB,Cache:N/A', 3778.00, 5265.00, 5); INSERT INTO `products` VALUES (34, 'Asus KGPE-D16', 'CPU:G34 x 2,Form Factor:SSI EEB,RAM Slots:16,Max RAM:256GB', 36072.00, 41798.00, 4); INSERT INTO `products` VALUES (35, 'Corsair Dominator Platinum', 'Speed:DDR4-2800,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB', 113168.00, 131499.00, 5); INSERT INTO `products` VALUES (36, 'Corsair Vengeance LPX', 'Speed:DDR4-3000,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB', 91298.00, 129999.00, 5); INSERT INTO `products` VALUES (37, 'Corsair Dominator Platinum', 'Speed:DDR4-2666,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB', 106866.00, 126499.00, 5); INSERT INTO `products` VALUES (38, 'Corsair Vengeance LPX', 'Speed:DDR4-2400,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB', 101951.00, 119999.00, 5); INSERT INTO `products` VALUES (39, 'ASRock EP2C602-4L/D16', 'CPU:LGA2011 x 2,Form Factor:SSI EEB,RAM Slots:16,Max RAM:512GB', 22547.00, 30199.00, 4); INSERT INTO `products` VALUES (40, 'MSI Z170A KRAIT GAMING 3X', 'CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB', 2454.00, 29989.00, 4); INSERT INTO `products` VALUES (41, 'MSI Z170 Krait Gaming', 'CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB', 23158.00, 29989.00, 4); INSERT INTO `products` VALUES (42, 'MSI Z170A KRAIT GAMING', 'CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB', 2624.00, 29989.00, 4); INSERT INTO `products` VALUES (43, 'Asus MAXIMUS IX CODE', 'CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB', 26615.00, 29898.00, 4); INSERT INTO `products` VALUES (44, 'Seagate ST1000DM010', 'Series:BarraCuda,Type:7200RPM,Capacity:1TB,Cache:64MB', 4218.00, 4937.00, 5); INSERT INTO `products` VALUES (45, 'Intel Xeon E5-2685 V3 (OEM/Tray)', 'Speed:26GHz,Cores:12,TDP:120W', 201211.00, 250169.00, 1); INSERT INTO `products` VALUES (46, 'Intel Xeon E5-2695 V3 (OEM/Tray)', 'Speed:23GHz,Cores:14,TDP:120W', 192513.00, 243195.00, 1); INSERT INTO `products` VALUES (47, 'Intel Xeon E5-2697 V2', 'Speed:27GHz,Cores:12,TDP:130W', 210159.00, 237709.00, 1); INSERT INTO `products` VALUES (48, 'AMD FirePro S7000', 'Chipset:FirePro S7000,Memory:4GBCore Clock:950MHz', 93642.00, 12185.00, 2); INSERT INTO `products` VALUES (49, 'Samsung MZ-75E4T0B', 'Series:850 EVO,Type:SSD,Capacity:4TB,Cache:4GB', 115364.00, 149999.00, 5); INSERT INTO `products` VALUES (50, 'Intel SSDPECME040T401', 'Series:DC P3608,Type:SSD,Capacity:4TB,Cache:N/A', 712366.00, 886799.00, 5); INSERT INTO `products` VALUES (51, 'Intel Xeon E5-2695 V4', 'Speed:21GHz,Cores:18,TDP:120W', 178035.00, 226999.00, 1); INSERT INTO `products` VALUES (52, 'Intel Xeon E5-2670 V3', 'Speed:23GHz,Cores:12,TDP:120W', 145394.00, 167698.00, 1); INSERT INTO `products` VALUES (53, 'Intel Core 2 Extreme QX6800', 'Speed:293GHz,Cores:4,TDP:100W', 78772.00, 100398.00, 1); INSERT INTO `products` VALUES (54, 'Intel Xeon E5-1660 V3 (OEM/Tray)', 'Speed:30GHz,Cores:8,TDP:140W', 91452.00, 101999.00, 1); INSERT INTO `products` VALUES (55, 'Crucial CT525MX300SSD4', 'Series:MX300,Type:SSD,Capacity:525GB,Cache:N/A', 12192.00, 15099.00, 5); INSERT INTO `products` VALUES (56, 'Western Digital WD2500AAJS', 'Series:Caviar Blue,Type:7200RPM,Capacity:250GB,Cache:8MB', 1523.00, 1699.00, 5); INSERT INTO `products` VALUES (57, 'Western Digital WD20EZRZ', 'Series:Blue,Type:5400RPM,Capacity:2TB,Cache:64MB', 5801.00, 6734.00, 5); INSERT INTO `products` VALUES (58, 'Gigabyte GV-N108TAORUS X-11GD', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:161GHz', 68835.00, 78498.00, 2); INSERT INTO `products` VALUES (59, 'Intel Core i7-5960X (OEM/Tray)', 'Speed:30GHz,Cores:8,TDP:140W', 8798.00, 97799.00, 1); INSERT INTO `products` VALUES (60, 'Hitachi HUA723020ALA640', 'Series:Ultrastar 7K3000,Type:7200RPM,Capacity:2TB,Cache:64MB', 4518.00, 5999.00, 5); INSERT INTO `products` VALUES (61, 'Asus PRIME X299-DELUXE', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 40992.00, 4873.00, 4); INSERT INTO `products` VALUES (62, 'Intel DP35DPM', 'CPU:LGA775,Form Factor:ATX,RAM Slots:4,Max RAM:8GB', 62622.00, 78979.00, 4); INSERT INTO `products` VALUES (63, 'Asus RAMPAGE V EXTREME', 'CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:64GB', 459.00, 57296.00, 4); INSERT INTO `products` VALUES (64, 'Supermicro H8DG6-F', 'CPU:G34 x 2,Form Factor:EATX,RAM Slots:16,Max RAM:512GB', 41664.00, 52599.00, 4); INSERT INTO `products` VALUES (65, 'Corsair Dominator Platinum', 'Speed:DDR4-2400,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB', 100247.00, 119999.00, 5); INSERT INTO `products` VALUES (66, 'Gigabyte X299 AORUS Gaming 7', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 28391.00, 39999.00, 4); INSERT INTO `products` VALUES (67, 'Kingston HyperX Beast', 'Speed:DDR3-1866,Type:240-pin DIMM,CAS:10Module:8x8GBSize:64GB', 70891.00, 86305.00, 5); INSERT INTO `products` VALUES (68, 'Crucial', 'Speed:DDR4-2133,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 59013.00, 76611.00, 5); INSERT INTO `products` VALUES (69, 'Intel Core i7-7820X', 'Speed:36GHz,Cores:8,TDP:140W', 5111.00, 67875.00, 1); INSERT INTO `products` VALUES (70, 'Intel Xeon E5-2687W', 'Speed:31GHz,Cores:8,TDP:150W', 58116.00, 71099.00, 1); INSERT INTO `products` VALUES (71, 'Intel Core i7-3930K', 'Speed:32GHz,Cores:6,TDP:130W', 50932.00, 660.00, 1); INSERT INTO `products` VALUES (72, 'Intel Xeon E5-2630 V3 (OEM/Tray)', 'Speed:24GHz,Cores:8,TDP:85W', 4219.00, 58999.00, 1); INSERT INTO `products` VALUES (73, 'Intel Core i7-4770K', 'Speed:35GHz,Cores:4,TDP:84W', 71415.00, 799.00, 1); INSERT INTO `products` VALUES (74, 'Intel Xeon E5-2680 V2', 'Speed:28GHz,Cores:10,TDP:115W', 56781.00, 70195.00, 1); INSERT INTO `products` VALUES (75, 'Intel Core i7-4930K', 'Speed:34GHz,Cores:6,TDP:130W', 52769.00, 62404.00, 1); INSERT INTO `products` VALUES (76, 'Intel Xeon E5-2630 V3', 'Speed:24GHz,Cores:8,TDP:85W', 49996.00, 62999.00, 1); INSERT INTO `products` VALUES (77, 'GSkill Ripjaws V Series', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB', 57725.00, 69599.00, 5); INSERT INTO `products` VALUES (78, 'GSkill Ripjaws V Series', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 51778.00, 68699.00, 5); INSERT INTO `products` VALUES (79, 'Corsair Dominator Platinum', 'Speed:DDR4-2666,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB', 53763.00, 65999.00, 5); INSERT INTO `products` VALUES (80, 'Intel Xeon E5-1650 V3', 'Speed:35GHz,Cores:6,TDP:140W', 39977.00, 56489.00, 1); INSERT INTO `products` VALUES (81, 'Intel Xeon E5-2650 V4', 'Speed:22GHz,Cores:12,TDP:105W', 94511.00, 109999.00, 1); INSERT INTO `products` VALUES (82, 'Intel Core i7-6950X', 'Speed:30GHz,Cores:10,TDP:140W', 105292.00, 149989.00, 1); INSERT INTO `products` VALUES (83, 'Asus STRIX-GTX1080TI-O11G-GAMING', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:157GHz', 69113.00, 82999.00, 2); INSERT INTO `products` VALUES (84, 'Asus X99-DELUXE/U31', 'CPU:LGA2011-3,Form Factor:ATX,RAM Slots:8,Max RAM:64GB', 33238.00, 4403.00, 4); INSERT INTO `products` VALUES (85, 'Intel Xeon E5-2660 V3 (OEM/Tray)', 'Speed:26GHz,Cores:10,TDP:105W', 90218.00, 127499.00, 1); INSERT INTO `products` VALUES (86, 'MSI GTX 1080 TI SEA HAWK X', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:157GHz', 69132.00, 80498.00, 2); INSERT INTO `products` VALUES (87, 'PNY VCGGTX1080T11XGPB-OC', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:153GHz', 60092.00, 75999.00, 2); INSERT INTO `products` VALUES (88, 'Gigabyte GV-N98TWF3OC-6GD', 'Chipset:GeForce GTX 980 Ti,Memory:6GBCore Clock:106GHz', 63329.00, 74999.00, 2); INSERT INTO `products` VALUES (89, 'PNY VCGGTX780T3XPB-OC', 'Chipset:GeForce GTX 780 Ti,Memory:3GBCore Clock:980MHz', 59212.00, 74999.00, 2); INSERT INTO `products` VALUES (90, 'EVGA 11G-P4-6696-KR', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:156GHz', 59446.00, 75999.00, 2); INSERT INTO `products` VALUES (91, 'Intel Xeon E5-2695 V2', 'Speed:24GHz,Cores:12,TDP:115W', 179353.00, 225999.00, 1); INSERT INTO `products` VALUES (92, 'Intel Xeon E5-2643 V2 (OEM/Tray)', 'Speed:35GHz,Cores:6,TDP:130W', 194018.00, 2200.00, 1); INSERT INTO `products` VALUES (93, 'Intel Xeon E5-2690 (OEM/Tray)', 'Speed:29GHz,Cores:8,TDP:135W', 188833.00, 211672.00, 1); INSERT INTO `products` VALUES (94, 'Western Digital WD2500AVVS', 'Series:AV-GP,Type:5400RPM,Capacity:250GB,Cache:8MB', 1263.00, 1555.00, 5); INSERT INTO `products` VALUES (95, 'Western Digital WDS256G1X0C', 'Series:Black PCIe,Type:SSD,Capacity:256GB,Cache:N/A', 8587.00, 10999.00, 5); INSERT INTO `products` VALUES (96, 'SanDisk SDSSDHII-480G-G25', 'Series:Ultra II,Type:SSD,Capacity:480GB,Cache:N/A', 10262.00, 14156.00, 5); INSERT INTO `products` VALUES (97, 'Kingston SV300S37A/120G', 'Series:SSDNow V300 Series,Type:SSD,Capacity:120GB,Cache:N/A', 4593.00, 5987.00, 5); INSERT INTO `products` VALUES (98, 'Intel Xeon E5-2687W V3', 'Speed:31GHz,Cores:10,TDP:160W', 178147.00, 206499.00, 1); INSERT INTO `products` VALUES (99, 'Seagate ST1000DX002', 'Series:FireCuda,Type:Hybrid,Capacity:1TB,Cache:64MB', 5541.00, 6806.00, 5); INSERT INTO `products` VALUES (100, 'Crucial CT275MX300SSD1', 'Series:MX300,Type:SSD,Capacity:275GB,Cache:N/A', 7921.00, 9788.00, 5); INSERT INTO `products` VALUES (101, 'Kingston HyperX Predator', 'Speed:DDR4-3000,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 47178.00, 63599.00, 5); INSERT INTO `products` VALUES (102, 'Intel Xeon E5-2687W V4', 'Speed:30GHz,Cores:12,TDP:160W', 172383.00, 204269.00, 1); INSERT INTO `products` VALUES (103, 'EVGA 11G-P4-6598-KR', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:156GHz', 66354.00, 80999.00, 2); INSERT INTO `products` VALUES (104, 'SanDisk SDSSDA-240G-G26', 'Series:SSD PLUS,Type:SSD,Capacity:240GB,Cache:N/A', 611.00, 8388.00, 5); INSERT INTO `products` VALUES (105, 'EVGA 12G-P4-3992-KR', 'Chipset:GeForce GTX Titan Z,Memory:12GBCore Clock:732MHz', 231307.00, 279999.00, 2); INSERT INTO `products` VALUES (106, 'Intel Xeon E5-2640 V2', 'Speed:20GHz,Cores:8,TDP:95W', 54519.00, 60895.00, 1); INSERT INTO `products` VALUES (107, 'Kingston', 'Speed:DDR3-1600,Type:240-pin DIMM,CAS:11Module:4x16GBSize:64GB', 47418.00, 644.00, 5); INSERT INTO `products` VALUES (108, 'MSI GAMING', 'Chipset:GeForce GTX 780 Ti,Memory:3GBCore Clock:102GHz', 75318.00, 84999.00, 2); INSERT INTO `products` VALUES (109, 'GSkill Trident Z', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB', 58526.00, 71399.00, 5); INSERT INTO `products` VALUES (110, 'ATI FirePro W9000', 'Chipset:FirePro W9000,Memory:6GBCore Clock:975MHz', 278555.00, 319297.00, 2); INSERT INTO `products` VALUES (111, 'Intel Core i7-6900K (OEM/Tray)', 'Speed:32GHz,Cores:8,TDP:140W', 62028.00, 82737.00, 1); INSERT INTO `products` VALUES (112, 'Corsair Vengeance Pro', 'Speed:DDR3-2133,Type:240-pin DIMM,CAS:11Module:8x8GBSize:64GB', 59625.00, 80892.00, 5); INSERT INTO `products` VALUES (113, 'GSkill Trident Z', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 58021.00, 70499.00, 5); INSERT INTO `products` VALUES (114, 'Zotac ZT-70203-10P', 'Chipset:GeForce GTX 780,Memory:3GBCore Clock:101GHz', 58042.00, 82061.00, 2); INSERT INTO `products` VALUES (115, 'Corsair Vengeance LPX', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB', 56573.00, 69999.00, 5); INSERT INTO `products` VALUES (116, 'GSkill Trident Z', 'Speed:DDR4-3400,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB', 56539.00, 73199.00, 5); INSERT INTO `products` VALUES (117, 'GSkill Ripjaws V Series', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB', 61762.00, 69599.00, 5); INSERT INTO `products` VALUES (118, 'Corsair Dominator Platinum', 'Speed:DDR4-2800,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB', 57846.00, 69989.00, 5); INSERT INTO `products` VALUES (119, 'Intel Xeon E5-2640 V3', 'Speed:26GHz,Cores:8,TDP:90W', 66824.00, 89999.00, 1); INSERT INTO `products` VALUES (120, 'Intel Core 2 Extreme QX9775', 'Speed:32GHz,Cores:4,TDP:150W', 73768.00, 892.00, 1); INSERT INTO `products` VALUES (121, 'GSkill Ripjaws V Series', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:8x8GBSize:64GB', 60322.00, 72199.00, 5); INSERT INTO `products` VALUES (122, 'GSkill Trident Z', 'Speed:DDR4-3333,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB', 53227.00, 72299.00, 5); INSERT INTO `products` VALUES (123, 'ATI FirePro S9150', 'Chipset:FirePro S9150,Memory:16GBCore Clock:900MHz', 262806.00, 317744.00, 2); INSERT INTO `products` VALUES (124, 'Intel Xeon E5-1650 V4 (OEM/Tray)', 'Speed:36GHz,Cores:6,TDP:140W', 45314.00, 59499.00, 1); INSERT INTO `products` VALUES (125, 'GSkill Trident Z', 'Speed:DDR4-3600,Type:288-pin DIMM,CAS:17Module:4x16GBSize:64GB', 59404.00, 76899.00, 5); INSERT INTO `products` VALUES (126, 'GSkill Ripjaws V Series', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:16Module:8x8GBSize:64GB', 51093.00, 64099.00, 5); INSERT INTO `products` VALUES (127, 'Corsair Dominator Platinum', 'Speed:DDR4-3333,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 53855.00, 71999.00, 5); INSERT INTO `products` VALUES (128, 'Kingston', 'Speed:DDR4-2133,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 65048.00, 74163.00, 5); INSERT INTO `products` VALUES (129, 'Corsair Vengeance LPX', 'Speed:DDR4-3333,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 60953.00, 73499.00, 5); INSERT INTO `products` VALUES (130, 'Western Digital WD2003FZEX', 'Series:BLACK SERIES,Type:7200RPM,Capacity:2TB,Cache:64MB', 9176.00, 11745.00, 5); INSERT INTO `products` VALUES (131, 'Samsung MZ-V6P512BW', 'Series:960 PRO,Type:SSD,Capacity:512GB,Cache:512MB', 22399.00, 27999.00, 5); INSERT INTO `products` VALUES (132, 'Intel Core i7-5930K', 'Speed:35GHz,Cores:6,TDP:140W', 48156.00, 55499.00, 1); INSERT INTO `products` VALUES (133, 'PNY VCQP6000-PB', 'Chipset:Quadro P6000,Memory:24GBCore Clock:142GHz', 405899.00, 549999.00, 2); INSERT INTO `products` VALUES (134, 'Asus Sabertooth 990FX', 'CPU:AM3+,Form Factor:ATX,RAM Slots:4,Max RAM:32GB', 25231.00, 29572.00, 4); INSERT INTO `products` VALUES (135, 'Samsung MZ-V6E250', 'Series:960 EVO,Type:SSD,Capacity:250GB,Cache:512MB', 9298.00, 12788.00, 5); INSERT INTO `products` VALUES (136, 'AMD Opteron 6378', 'Speed:24GHz,Cores:16,TDP:115W', 65192.00, 82699.00, 1); INSERT INTO `products` VALUES (137, 'Asus Z10PE-D16 WS', 'CPU:LGA2011-3 x 2,Form Factor:SSI EEB,RAM Slots:16,Max RAM:1TB', 33252.00, 46999.00, 4); INSERT INTO `products` VALUES (138, 'GSkill Ripjaws V Series', 'Speed:DDR4-3000,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB', 49909.00, 64599.00, 5); INSERT INTO `products` VALUES (139, 'Hitachi HUS724030ALE641', 'Series:Ultrastar 7K4000,Type:7200RPM,Capacity:3TB,Cache:64MB', 5403.00, 6592.00, 5); INSERT INTO `products` VALUES (140, 'MSI X99A WORKSTATION', 'CPU:LGA2011-3,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 23995.00, 28997.00, 4); INSERT INTO `products` VALUES (141, 'Supermicro X11SSL-CF', 'CPU:LGA1151,Form Factor:Micro ATX,RAM Slots:4,Max RAM:64GB', 31781.00, 41999.00, 4); INSERT INTO `products` VALUES (142, 'AMD FirePro W9100', 'Chipset:FirePro W9100,Memory:16GBCore Clock:930MHz', 248338.00, 299889.00, 2); INSERT INTO `products` VALUES (143, 'Asus Z10PE-D16', 'CPU:LGA2011-3 Narrow x 2,Form Factor:SSI EEB,RAM Slots:16,Max RAM:1TB', 2933.00, 40299.00, 4); INSERT INTO `products` VALUES (144, 'Intel DG43RK', 'CPU:LGA775,Form Factor:Micro ATX,RAM Slots:4,Max RAM:8GB', 21969.00, 28979.00, 4); INSERT INTO `products` VALUES (145, 'Asus VANGUARD B85', 'CPU:LGA1150,Form Factor:Micro ATX,RAM Slots:4,Max RAM:32GB', 2581.00, 287.00, 4); INSERT INTO `products` VALUES (146, 'EVGA Z270 Classified K', 'CPU:LGA1151,Form Factor:EATX,RAM Slots:4,Max RAM:64GB', 23426.00, 28398.00, 4); INSERT INTO `products` VALUES (147, 'EVGA Classified', 'CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB', 24062.00, 28398.00, 4); INSERT INTO `products` VALUES (148, 'MSI Z270 XPOWER GAMING TITANIUM', 'CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB', 21269.00, 28298.00, 4); INSERT INTO `products` VALUES (149, 'ASRock X299 Taichi', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 21436.00, 28298.00, 4); INSERT INTO `products` VALUES (150, 'MSI X299 TOMAHAWK ARCTIC', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 22392.00, 28198.00, 4); INSERT INTO `products` VALUES (151, 'Supermicro X10SAT-O', 'CPU:LGA1150,Form Factor:ATX,RAM Slots:4,Max RAM:32GB', 20708.00, 28197.00, 4); INSERT INTO `products` VALUES (152, 'Gigabyte X299 AORUS Gaming 3', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 22748.00, 28098.00, 4); INSERT INTO `products` VALUES (153, 'Intel Xeon E5-2650 V2', 'Speed:26GHz,Cores:8,TDP:95W', 96111.00, 1249.00, 1); INSERT INTO `products` VALUES (154, 'Intel Xeon E5-2650 V3', 'Speed:23GHz,Cores:10,TDP:105W', 90663.00, 120498.00, 1); INSERT INTO `products` VALUES (155, 'Intel Xeon E5-2630 V2', 'Speed:26GHz,Cores:6,TDP:80W', 49348.00, 58895.00, 1); INSERT INTO `products` VALUES (156, 'Supermicro MBD-X10DRI-O', 'CPU:LGA2011-3 Narrow x 2,Form Factor:EATX,RAM Slots:16,Max RAM:1TB', 29134.00, 39499.00, 4); INSERT INTO `products` VALUES (157, 'Asus MAXIMUS IX FORMULA', 'CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB', 33912.00, 38899.00, 4); INSERT INTO `products` VALUES (158, 'Intel Xeon E5-2667 V3 (OEM/Tray)', 'Speed:32GHz,Cores:8,TDP:135W', 150408.00, 200946.00, 1); INSERT INTO `products` VALUES (159, 'Intel Xeon E5-2690 V4', 'Speed:26GHz,Cores:14,TDP:135W', 149926.00, 199449.00, 1); INSERT INTO `products` VALUES (160, 'Intel Xeon E5-2690 V3', 'Speed:26GHz,Cores:12,TDP:135W', 154035.00, 190873.00, 1); INSERT INTO `products` VALUES (161, 'AMD 100-5056062', 'Chipset:Vega Frontier Edition Liquid,Memory:16GBCore Clock:15GHz', 134384.00, 149999.00, 2); INSERT INTO `products` VALUES (162, 'Intel Xeon E5-2470V2', 'Speed:24GHz,Cores:10,TDP:95W', 167195.00, 19047.00, 1); INSERT INTO `products` VALUES (163, 'Intel Xeon E5-2683 V4', 'Speed:21GHz,Cores:16,TDP:120W', 170695.00, 189999.00, 1); INSERT INTO `products` VALUES (164, 'Intel Xeon E5-2637 V2 (OEM/Tray)', 'Speed:35GHz,Cores:4,TDP:130W', 132312.00, 1850.00, 1); INSERT INTO `products` VALUES (165, 'Intel Xeon E5-2680', 'Speed:27GHz,Cores:8,TDP:130W', 147995.00, 166661.00, 1); INSERT INTO `products` VALUES (166, 'Intel Xeon E5-2680 V3 (OEM/Tray)', 'Speed:25GHz,Cores:12,TDP:120W', 116689.00, 163889.00, 1); INSERT INTO `products` VALUES (167, 'Intel Xeon E5-2650L V3 (OEM/Tray)', 'Speed:18GHz,Cores:12,TDP:65W', 77917.00, 101046.00, 1); INSERT INTO `products` VALUES (168, 'Seagate ST31000340NS - FFP', 'Series:Barracuda ES,Type:7200RPM,Capacity:1TB,Cache:32MB', 344.00, 4399.00, 5); INSERT INTO `products` VALUES (169, 'Intel Xeon E5-2683 V4 (OEM/Tray)', 'Speed:21GHz,Cores:16,TDP:120W', 136983.00, 184489.00, 1); INSERT INTO `products` VALUES (170, 'Asus X99-DELUXE II', 'CPU:LGA2011-3,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 28933.00, 38398.00, 4); INSERT INTO `products` VALUES (171, 'ASRock Fatal1ty X299 Professional Gaming i9', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 2875.00, 38298.00, 4); INSERT INTO `products` VALUES (172, 'ASRock EP2C612 WS', 'CPU:LGA2011-3 x 2,Form Factor:SSI EEB,RAM Slots:8,Max RAM:', 30884.00, 35849.00, 4); INSERT INTO `products` VALUES (173, 'ASRock Z270 SuperCarrier', 'CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB', 26435.00, 35398.00, 4); INSERT INTO `products` VALUES (174, 'MSI GTX 1080 TI AERO 11G OC', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:151GHz', 71572.00, 79826.00, 2); INSERT INTO `products` VALUES (175, 'NVIDIA VCQM4000-PB', 'Chipset:Quadro M4000,Memory:8GBCore Clock:N/A', 68209.00, 790.00, 2); INSERT INTO `products` VALUES (176, 'Intel Xeon E5-2650 V3 (OEM/Tray)', 'Speed:23GHz,Cores:10,TDP:105W', 79998.00, 93949.00, 1); INSERT INTO `products` VALUES (177, 'PNY VCQM5000-PB', 'Chipset:Quadro M5000,Memory:8GBCore Clock:861MHz', 126842.00, 175999.00, 2); INSERT INTO `products` VALUES (178, 'HP C2J95AT', 'Chipset:Quadro K5000,Memory:4GBCore Clock:706MHz', 171591.00, 199989.00, 2); INSERT INTO `products` VALUES (179, 'Asus SABERTOOTH X99', 'CPU:LGA2011-3,Form Factor:ATX,RAM Slots:8,Max RAM:64GB', 25257.00, 31267.00, 4); INSERT INTO `products` VALUES (180, 'Supermicro MBD-X10DAL-I-O', 'CPU:LGA2011-3 x 2,Form Factor:ATX,RAM Slots:8,Max RAM:512GB', 23928.00, 27999.00, 4); INSERT INTO `products` VALUES (181, 'ATI FirePro R5000', 'Chipset:FirePro R5000,Memory:2GBCore Clock:825MHz', 76059.00, 99999.00, 2); INSERT INTO `products` VALUES (182, 'PNY VCQK4200-PB', 'Chipset:Quadro K4200,Memory:4GBCore Clock:771MHz', 79905.00, 94989.00, 2); INSERT INTO `products` VALUES (183, 'Asus GTX780TI-3GD5', 'Chipset:GeForce GTX 780 Ti,Memory:3GBCore Clock:876MHz', 78191.00, 89999.00, 2); INSERT INTO `products` VALUES (184, 'AMD 100-506061', 'Chipset:Vega Frontier Edition,Memory:16GBCore Clock:144GHz', 70699.00, 99999.00, 2); INSERT INTO `products` VALUES (185, 'MSI GTX 1080 TI LIGHTNING Z', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:161GHz', 68835.00, 87398.00, 2); INSERT INTO `products` VALUES (186, 'PNY VCQK5200-PB', 'Chipset:Quadro K5200,Memory:8GBCore Clock:667MHz', 112939.00, 144998.00, 2); INSERT INTO `products` VALUES (187, 'Asus MAXIMUS VIII EXTREME/ASSEMBLY', 'CPU:LGA1151,Form Factor:EATX,RAM Slots:4,Max RAM:64GB', 25341.00, 35398.00, 4); INSERT INTO `products` VALUES (188, 'Asus X99-E WS/USB 31', 'CPU:LGA2011-3,Form Factor:SSI CEB,RAM Slots:8,Max RAM:128GB', 42889.00, 48249.00, 4); INSERT INTO `products` VALUES (189, 'Asus X99-E-10G WS', 'CPU:LGA2011-3,Form Factor:SSI CEB,RAM Slots:8,Max RAM:128GB', 58202.00, 649.00, 4); INSERT INTO `products` VALUES (190, 'Supermicro X10SDV-8C-TLN4F', 'CPU:Xeon D-1541,Form Factor:Mini ITX,RAM Slots:4,Max RAM:64GB', 66429.00, 94899.00, 4); INSERT INTO `products` VALUES (191, 'Asus ROG MAXIMUS IX EXTREME', 'CPU:LGA1151,Form Factor:EATX,RAM Slots:4,Max RAM:64GB', 48089.00, 57399.00, 4); INSERT INTO `products` VALUES (192, 'Asus Rampage V Edition 10', 'CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB', 4525.00, 51999.00, 4); INSERT INTO `products` VALUES (193, 'Asus Z10PE-D8 WS', 'CPU:LGA2011-3 x 2,Form Factor:SSI EEB,RAM Slots:8,Max RAM:512GB', 50414.00, 56159.00, 4); INSERT INTO `products` VALUES (194, 'MSI X299 GAMING M7 ACK', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 27871.00, 39742.00, 4); INSERT INTO `products` VALUES (195, 'GSkill Ripjaws 4 Series', 'Speed:DDR4-2400,Type:288-pin DIMM,CAS:14Module:8x16GBSize:128GB', 83603.00, 105599.00, 5); INSERT INTO `products` VALUES (196, 'Corsair Vengeance LPX', 'Speed:DDR4-2133,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB', 82191.00, 109999.00, 5); INSERT INTO `products` VALUES (197, 'GSkill Trident Z RGB', 'Speed:DDR4-3600,Type:288-pin DIMM,CAS:17Module:4x16GBSize:64GB', 62247.00, 79999.00, 5); INSERT INTO `products` VALUES (198, 'Intel Core i7-980', 'Speed:333GHz,Cores:6,TDP:130W', 5637.00, 69999.00, 1); INSERT INTO `products` VALUES (199, 'Intel Xeon E5-2630 V4', 'Speed:22GHz,Cores:10,TDP:85W', 52895.00, 64799.00, 1); INSERT INTO `products` VALUES (200, 'Intel Core i7-4790K', 'Speed:40GHz,Cores:4,TDP:88W', 46192.00, 62095.00, 1); INSERT INTO `products` VALUES (201, 'Kingston', 'Speed:DDR3-1600,Type:240-pin DIMM,CAS:11Module:4x8GBSize:32GB', 56698.00, 6535.00, 5); INSERT INTO `products` VALUES (202, 'GSkill Trident Z', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB', 53321.00, 71399.00, 5); INSERT INTO `products` VALUES (203, 'Kingston', 'Speed:DDR3-1333,Type:240-pin DIMM,CAS:9Module:4x16GBSize:64GB', 55684.00, 67138.00, 5); INSERT INTO `products` VALUES (204, 'GSkill Ripjaws V Series', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 54664.00, 68699.00, 5); INSERT INTO `products` VALUES (205, 'GSkill Trident X', 'Speed:DDR3-3100,Type:240-pin DIMM,CAS:12Module:2x4GBSize:8GB', 50732.00, 64999.00, 5); INSERT INTO `products` VALUES (206, 'PNY VCQM6000-24GB-PB', 'Chipset:Quadro M6000,Memory:24GBCore Clock:988MHz', 361914.00, 4139.00, 2); INSERT INTO `products` VALUES (207, 'PNY VCQM6000-PB', 'Chipset:Quadro M6000,Memory:12GBCore Clock:988MHz', 250504.00, 325499.00, 2); INSERT INTO `products` VALUES (208, 'Samsung MZ-V6P2T0BW', 'Series:960 Pro,Type:SSD,Capacity:2TB,Cache:2GB', 84011.00, 119999.00, 5); INSERT INTO `products` VALUES (209, 'Intel Core i7-990X Extreme Edition', 'Speed:347GHz,Cores:6,TDP:130W', 107279.00, 119999.00, 1); INSERT INTO `products` VALUES (210, 'Intel Core i9-7900X', 'Speed:33GHz,Cores:10,TDP:140W', 85582.00, 102999.00, 1); INSERT INTO `products` VALUES (211, 'Intel Xeon E5-2650', 'Speed:20GHz,Cores:8,TDP:95W', 86903.00, 106499.00, 1); INSERT INTO `products` VALUES (212, 'Intel Xeon E5-2680 V4', 'Speed:24GHz,Cores:14,TDP:120W', 136513.00, 163999.00, 1); INSERT INTO `products` VALUES (213, 'Intel Xeon E5-2643 V3 (OEM/Tray)', 'Speed:34GHz,Cores:6,TDP:135W', 126637.00, 146996.00, 1); INSERT INTO `products` VALUES (214, 'Intel Core i7-5960X', 'Speed:30GHz,Cores:8,TDP:140W', 86559.00, 100979.00, 1); INSERT INTO `products` VALUES (215, 'PNY VCQP4000-PB', 'Chipset:Quadro P4000,Memory:8GBCore Clock:123GHz', 724.00, 82989.00, 2); INSERT INTO `products` VALUES (216, 'MSI GTX 1080 TI LIGHTNING X', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:157GHz', 74294.00, 86398.00, 2); INSERT INTO `products` VALUES (217, 'ASRock C2750D4I', 'CPU:Atom C2750,Form Factor:Mini ITX,RAM Slots:4,Max RAM:64GB', 33955.00, 40198.00, 4); INSERT INTO `products` VALUES (218, 'Intel Xeon E5-2660 V4', 'Speed:20GHz,Cores:14,TDP:105W', 119403.00, 138889.00, 1); INSERT INTO `products` VALUES (219, 'Intel Xeon E5-2660 V3', 'Speed:26GHz,Cores:10,TDP:105W', 104199.00, 129973.00, 1); INSERT INTO `products` VALUES (220, 'MSI GeForce GTX 1080 Ti GAMING X 11G', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:157GHz', 66659.00, 75999.00, 2); INSERT INTO `products` VALUES (221, 'Zotac ZT-P10810C-10P', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:165GHz', 53503.00, 75999.00, 2); INSERT INTO `products` VALUES (222, 'Zotac ZT-P10810G-10P', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:151GHz', 59825.00, 75498.00, 2); INSERT INTO `products` VALUES (223, 'MSI GeForce GTX 1080 TI ARMOR 11G OC', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:148GHz', 64419.00, 76498.00, 2); INSERT INTO `products` VALUES (224, 'Asus STRIX X299-E GAMING', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 306.00, 34999.00, 4); INSERT INTO `products` VALUES (225, 'Gigabyte GA-Z270X-Gaming 9', 'CPU:LGA1151,Form Factor:EATX,RAM Slots:4,Max RAM:64GB', 38005.00, 50398.00, 4); INSERT INTO `products` VALUES (226, 'Asus PRIME X299-A', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 27456.00, 30985.00, 4); INSERT INTO `products` VALUES (227, 'Gigabyte GA-X99-UD5 WIFI', 'CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:64GB', 21783.00, 305.00, 4); INSERT INTO `products` VALUES (228, 'Intel Xeon E5-2699 V3 (OEM/Tray)', 'Speed:23GHz,Cores:18,TDP:145W', 286751.00, 341046.00, 1); INSERT INTO `products` VALUES (229, 'Seagate ST10000DM0004', 'Series:BarraCuda Pro,Type:7200RPM,Capacity:10TB,Cache:256MB', 28423.00, 39999.00, 5); INSERT INTO `products` VALUES (230, 'ADATA ASU800SS-512GT-C', 'Series:Ultimate SU800,Type:SSD,Capacity:512GB,Cache:N/A', 11329.00, 13669.00, 5); INSERT INTO `products` VALUES (231, 'Samsung MZ-V6E1T0', 'Series:960 EVO,Type:SSD,Capacity:1TB,Cache:1000MB', 35806.00, 44999.00, 5); INSERT INTO `products` VALUES (232, 'Western Digital WD1003FZEX', 'Series:BLACK SERIES,Type:7200RPM,Capacity:1TB,Cache:64MB', 6176.00, 7089.00, 5); INSERT INTO `products` VALUES (233, 'SanDisk SDSSDA-120G-G26', 'Series:SSD PLUS,Type:SSD,Capacity:120GB,Cache:N/A', 527.00, 5999.00, 5); INSERT INTO `products` VALUES (234, 'Crucial CT525MX300SSD1', 'Series:MX300,Type:SSD,Capacity:525GB,Cache:N/A', 13559.00, 15099.00, 5); INSERT INTO `products` VALUES (235, 'Hitachi A7K1000-1000', 'Series:Ultrastar,Type:7200RPM,Capacity:1TB,Cache:32MB', 2994.00, 4199.00, 5); INSERT INTO `products` VALUES (236, 'MSI GTX 980 Ti Gaming 6G', 'Chipset:GeForce GTX 980 Ti,Memory:6GBCore Clock:118GHz', 53998.00, 74532.00, 2); INSERT INTO `products` VALUES (237, 'Gigabyte GV-N108TAORUS-11GD', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:159GHz', 6053.00, 74498.00, 2); INSERT INTO `products` VALUES (238, 'EVGA 06G-P4-4998-KR', 'Chipset:GeForce GTX 980 Ti,Memory:6GBCore Clock:119GHz', 52103.00, 74178.00, 2); INSERT INTO `products` VALUES (239, 'MSI GTX 1080 Ti DUKE 11G OC', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:153GHz', 55507.00, 73999.00, 2); INSERT INTO `products` VALUES (240, 'Intel Core i7-4960X Extreme Edition', 'Speed:36GHz,Cores:6,TDP:130W', 149643.00, 180597.00, 1); INSERT INTO `products` VALUES (241, 'Intel Xeon E5-2699 V4 (OEM/Tray)', 'Speed:22GHz,Cores:22,TDP:145W', 153562.00, 1756.00, 1); INSERT INTO `products` VALUES (242, 'Intel Xeon E5-1680 V3 (OEM/Tray)', 'Speed:32GHz,Cores:8,TDP:140W', 151985.00, 175199.00, 1); INSERT INTO `products` VALUES (243, 'Intel Xeon E5-2643 V4 (OEM/Tray)', 'Speed:34GHz,Cores:6,TDP:135W', 122559.00, 170886.00, 1); INSERT INTO `products` VALUES (244, 'Crucial', 'Speed:DDR4-2133,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB', 113923.00, 162099.00, 5); INSERT INTO `products` VALUES (245, 'ATI FirePro S9050', 'Chipset:FirePro S9050,Memory:12GBCore Clock:900MHz', 123704.00, 1699.00, 2); INSERT INTO `products` VALUES (246, 'Gigabyte X299 AORUS Ultra Gaming', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 28778.00, 34399.00, 4); INSERT INTO `products` VALUES (247, 'Asus TUF X299 MARK 1', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 24115.00, 33999.00, 4); INSERT INTO `products` VALUES (248, 'Intel Xeon E5-2697 V3', 'Speed:26GHz,Cores:14,TDP:145W', 232627.00, 277498.00, 1); INSERT INTO `products` VALUES (249, 'Intel Xeon E5-2698 V3 (OEM/Tray)', 'Speed:23GHz,Cores:16,TDP:135W', 203518.00, 266072.00, 1); INSERT INTO `products` VALUES (250, 'Asus Z170-WS', 'CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB', 2794.00, 33899.00, 4); INSERT INTO `products` VALUES (251, 'MSI X299 GAMING PRO CARBON AC', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 2388.00, 33781.00, 4); INSERT INTO `products` VALUES (252, 'Gigabyte X299 AORUS Gaming 9', 'CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 39524.00, 49999.00, 4); INSERT INTO `products` VALUES (253, 'Samsung MZ-V6P1T0BW', 'Series:960 Pro,Type:SSD,Capacity:1TB,Cache:1GB', 46649.00, 57999.00, 5); INSERT INTO `products` VALUES (254, 'Samsung MZ-7KE256BW', 'Series:850 Pro Series,Type:SSD,Capacity:256GB,Cache:N/A', 9719.00, 11999.00, 5); INSERT INTO `products` VALUES (255, 'Seagate ST2000DX002', 'Series:FireCuda,Type:Hybrid,Capacity:2TB,Cache:64MB', 6448.00, 9099.00, 5); INSERT INTO `products` VALUES (256, 'Western Digital WD5000AACS', 'Series:Caviar Green,Type:5400RPM,Capacity:500GB,Cache:16MB', 2014.00, 2699.00, 5); INSERT INTO `products` VALUES (257, 'SanDisk SDSSDHII-240G-G25', 'Series:Ultra II,Type:SSD,Capacity:240GB,Cache:N/A', 7339.00, 8495.00, 5); INSERT INTO `products` VALUES (258, 'PNY SSD7CS1311-120-RB', 'Series:CS1311,Type:SSD,Capacity:120GB,Cache:N/A', 5059.00, 5798.00, 5); INSERT INTO `products` VALUES (259, 'PNY SSD9SC240GMDA-RB', 'Series:XLR8,Type:SSD,Capacity:240GB,Cache:N/A', 584.00, 8072.00, 5); INSERT INTO `products` VALUES (260, 'Crucial CT1050MX300SSD1', 'Series:MX300,Type:SSD,Capacity:11TB,Cache:N/A', 19252.00, 26799.00, 5); INSERT INTO `products` VALUES (261, 'GSkill TridentZ RGB', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:8x16GBSize:128GB', 133026.00, 150499.00, 5); INSERT INTO `products` VALUES (262, 'Corsair Dominator Platinum', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:16Module:8x16GBSize:128GB', 105197.00, 144999.00, 5); INSERT INTO `products` VALUES (263, 'Western Digital WDS250G1B0B', 'Series:Blue,Type:SSD,Capacity:250GB,Cache:N/A', 7071.00, 8999.00, 5); INSERT INTO `products` VALUES (264, 'Samsung MZ-75E120B/AM', 'Series:850 EVO-Series,Type:SSD,Capacity:120GB,Cache:N/A', 7441.00, 8899.00, 5); INSERT INTO `products` VALUES (265, 'GSkill Trident Z', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:8x16GBSize:128GB', 116349.00, 143199.00, 5); INSERT INTO `products` VALUES (266, 'GSkill Trident Z RGB', 'Speed:DDR4-3333,Type:288-pin DIMM,CAS:16Module:8x16GBSize:128GB', 117436.00, 141899.00, 5); INSERT INTO `products` VALUES (267, 'EVGA 12G-P4-1999-KR', 'Chipset:GeForce GTX Titan X,Memory:12GBCore Clock:115GHz', 132803.00, 179999.00, 2); INSERT INTO `products` VALUES (268, 'Western Digital WD10EZEX', 'Series:Caviar Blue,Type:7200RPM,Capacity:1TB,Cache:64MB', 3583.00, 4788.00, 5); INSERT INTO `products` VALUES (269, 'Zotac ZT-P10810D-10P', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:157GHz', 5801.00, 75999.00, 2); INSERT INTO `products` VALUES (270, 'Gigabyte GV-N1070WF2OC-8GD', 'Chipset:GeForce GTX 1070,Memory:8GBCore Clock:156GHz', 55162.00, 76999.00, 2); INSERT INTO `products` VALUES (271, 'MSI X99A GODLIKE GAMING CARBON', 'CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB', 415.00, 54959.00, 4); INSERT INTO `products` VALUES (272, 'GSkill Ripjaws 4 Series', 'Speed:DDR4-2800,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB', 83406.00, 107399.00, 5); INSERT INTO `products` VALUES (273, 'Western Digital WD101KRYZ', 'Series:Gold,Type:7200RPM,Capacity:10TB,Cache:256MB', 31396.00, 44364.00, 5); INSERT INTO `products` VALUES (274, 'ASRock E3C224D4M-16RE', 'CPU:LGA1150,Form Factor:ATX,RAM Slots:4,Max RAM:32GB', 36479.00, 49999.00, 4); INSERT INTO `products` VALUES (275, 'MSI X99A GODLIKE GAMING', 'CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB', 30295.00, 39999.00, 4); INSERT INTO `products` VALUES (276, 'Corsair Vengeance LPX', 'Speed:DDR4-2666,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB', 86752.00, 116399.00, 5); INSERT INTO `products` VALUES (277, 'GSkill Trident Z', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:8x8GBSize:64GB', 5568.00, 75899.00, 5); INSERT INTO `products` VALUES (278, 'GSkill Ripjaws V Series', 'Speed:DDR4-3000,Type:288-pin DIMM,CAS:14Module:8x8GBSize:64GB', 54605.00, 67799.00, 5); INSERT INTO `products` VALUES (279, 'GSkill Ripjaws V Series', 'Speed:DDR4-3000,Type:288-pin DIMM,CAS:14Module:8x16GBSize:128GB', 113987.00, 131899.00, 5); INSERT INTO `products` VALUES (280, 'Western Digital WDS500G1B0B', 'Series:Blue,Type:SSD,Capacity:500GB,Cache:N/A', 10689.00, 14988.00, 5); INSERT INTO `products` VALUES (281, 'Asus ROG-POSEIDON-GTX1080TI-P11G-GAMING', 'Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:162GHz', 69614.00, 86498.00, 2); INSERT INTO `products` VALUES (282, 'Corsair Dominator Platinum', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB', 7005.00, 80499.00, 5); INSERT INTO `products` VALUES (283, 'GSkill Trident Z', 'Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:8x8GBSize:64GB', 64783.00, 76099.00, 5); INSERT INTO `products` VALUES (284, 'Kingston SA400S37/120G', 'Series:A400,Type:SSD,Capacity:120GB,Cache:N/A', 4063.00, 5499.00, 5); INSERT INTO `products` VALUES (285, 'Samsung MZ-75E1T0B/AM', 'Series:850 EVO-Series,Type:SSD,Capacity:1TB,Cache:N/A', 26023.00, 33999.00, 5); INSERT INTO `products` VALUES (286, 'Samsung MZ-V6E500', 'Series:960 EVO,Type:SSD,Capacity:500GB,Cache:512MB', 20962.00, 234.00, 5); INSERT INTO `products` VALUES (287, 'MSI X99A XPOWER GAMING TITANIUM', 'CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB', 25723.00, 32999.00, 4); INSERT INTO `products` VALUES (288, 'Asus ROG STRIX X99 GAMING', 'CPU:LGA2011-3,Form Factor:ATX,RAM Slots:8,Max RAM:128GB', 25586.00, 31999.00, 4); -- ---------------------------- -- Table structure for regions -- ---------------------------- DROP TABLE IF EXISTS `regions`; CREATE TABLE `regions` ( `region_id` smallint NOT NULL, `region_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, PRIMARY KEY (`region_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of regions -- ---------------------------- INSERT INTO `regions` VALUES (1, 'Europe'); INSERT INTO `regions` VALUES (2, 'Americas'); INSERT INTO `regions` VALUES (3, 'Asia'); INSERT INTO `regions` VALUES (4, 'Middle East and Africa'); -- ---------------------------- -- Table structure for warehouses -- ---------------------------- DROP TABLE IF EXISTS `warehouses`; CREATE TABLE `warehouses` ( `warehouse_id` smallint NOT NULL, `warehouse_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `location_id` smallint NOT NULL, PRIMARY KEY (`warehouse_id`) USING BTREE, INDEX `fk_warehouses_location`(`location_id` ASC) USING BTREE, CONSTRAINT `fk_warehouses_location` FOREIGN KEY (`location_id`) REFERENCES `locations` (`location_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of warehouses -- ---------------------------- INSERT INTO `warehouses` VALUES (1, 'Southlake, Texas', 5); INSERT INTO `warehouses` VALUES (2, 'San Francisco', 6); INSERT INTO `warehouses` VALUES (3, 'New Jersey', 7); INSERT INTO `warehouses` VALUES (4, 'Seattle, Washington', 8); INSERT INTO `warehouses` VALUES (5, 'Toronto', 9); INSERT INTO `warehouses` VALUES (6, 'Sydney', 13); INSERT INTO `warehouses` VALUES (7, 'Mexico City', 23); INSERT INTO `warehouses` VALUES (8, 'Beijing', 11); INSERT INTO `warehouses` VALUES (9, 'Bombay', 12); SET FOREIGN_KEY_CHECKS = 1;