Skip to content

Instantly share code, notes, and snippets.

@LearnWebCode
Created November 7, 2021 01:01
Show Gist options
  • Save LearnWebCode/b464e8bc02f655bc65e4fbb129710758 to your computer and use it in GitHub Desktop.
Save LearnWebCode/b464e8bc02f655bc65e4fbb129710758 to your computer and use it in GitHub Desktop.
-- MySQL dump 10.13 Distrib 8.0.26, for macos11 (x86_64)
--
-- Host: localhost Database: petfoodsreference
-- ------------------------------------------------------
-- Server version 8.0.26
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `animals`
--
DROP TABLE IF EXISTS `animals`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `animals` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL,
`species` varchar(45) NOT NULL,
`weight` smallint DEFAULT NULL,
`birthdate` date DEFAULT NULL,
`joindate` date NOT NULL,
`email` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `animals`
--
LOCK TABLES `animals` WRITE;
/*!40000 ALTER TABLE `animals` DISABLE KEYS */;
INSERT INTO `animals` VALUES (1,'Rad Lilly The Eighth','goat',53,'2019-09-07','2019-11-11','radlillytheeighth81994@learnwebcode.com'),(2,'Stylish Piper The Seventh','rabbit',37,'2018-09-03','2018-11-07','stylishpipertheseventh53589@learnwebcode.com'),(3,'Delightful Buster Junior','mouse',17,'2013-06-26','2015-08-26','delightfulbusterjunior82845@learnwebcode.com'),(4,'Excellent Ginger Junior','llama',19,'2010-04-01','2012-06-05','excellentgingerjunior48573@learnwebcode.com'),(5,'Marvelous Callie The Seventh','llama',34,'2015-02-23','2017-04-27','marvelouscallietheseventh35271@learnwebcode.com'),(6,'Sublime Ginger Junior','mouse',41,'2015-04-04','2017-06-08','sublimegingerjunior95364@learnwebcode.com'),(7,'Legendary Ginger The Fourth','hamster',28,'2012-04-23','2014-06-27','legendarygingerthefourth83523@learnwebcode.com'),(8,'Swell Casper Junior','lizard',26,'2020-02-03','2020-04-07','swellcasperjunior39169@learnwebcode.com'),(9,'Superb Harley The Eighth','hedgehog',7,'2008-08-28','2010-10-28','superbharleytheeighth52926@learnwebcode.com'),(10,'Superb Sugar The Third','lizard',9,'2014-04-16','2016-06-20','superbsugarthethird72383@learnwebcode.com'),(11,'Fabulous Duke The Third','rabbit',50,'2017-08-07','2019-10-11','fabulousdukethethird27812@learnwebcode.com'),(12,'Stellar Jack Junior','mouse',42,'2019-08-03','2019-10-07','stellarjackjunior96454@learnwebcode.com'),(13,'Gnarly Pepper The Fourth','bird',24,'2010-04-08','2012-06-12','gnarlypepperthefourth87371@learnwebcode.com'),(14,'Wondrous Buddy Junior','bird',60,'2018-07-18','2018-09-22','wondrousbuddyjunior77389@learnwebcode.com'),(15,'Stellar Sandy Junior','lizard',7,'2015-04-13','2017-06-17','stellarsandyjunior54791@learnwebcode.com'),(16,'Extraordinary Midnight The Sixth','guinea pig',58,'2009-06-22','2011-08-26','extraordinarymidnightthesixth12895@learnwebcode.com'),(17,'Stylish Benny Senior','hamster',76,'2020-06-06','2020-08-10','stylishbennysenior31821@learnwebcode.com'),(18,'Dazzling Midnight Senior','dog',33,'2009-02-02','2011-04-06','dazzlingmidnightsenior29849@learnwebcode.com'),(19,'Terrific Fluffy Senior','fish',23,'2012-03-10','2014-05-14','terrificfluffysenior95217@learnwebcode.com'),(20,'Groundbreaking Garfield The Ninth','lizard',41,'2020-05-05','2020-07-09','groundbreakinggarfieldtheninth15388@learnwebcode.com'),(21,'Smashing Dusty The Sixth','mouse',80,'2014-10-10','2016-12-14','smashingdustythesixth94114@learnwebcode.com'),(22,'Lovely Brody The Third','rabbit',51,'2008-11-16','2010-11-20','lovelybrodythethird32288@learnwebcode.com'),(23,'Luminous Roxy The Fifth','chicken',17,'2010-10-03','2012-12-07','luminousroxythefifth61128@learnwebcode.com'),(24,'Groundbreaking Cooper Junior','hedgehog',98,'2018-04-01','2018-06-05','groundbreakingcooperjunior43213@learnwebcode.com'),(25,'Premium Brody Junior','rabbit',91,'2008-05-09','2010-07-13','premiumbrodyjunior89543@learnwebcode.com'),(26,'Outstanding Precious The Sixth','lizard',87,'2017-01-21','2019-03-25','outstandingpreciousthesixth22718@learnwebcode.com'),(27,'Stunning Bubba The Ninth','mouse',85,'2017-02-25','2019-04-25','stunningbubbatheninth94284@learnwebcode.com'),(28,'Dazzling Tyson The Fifth','bird',41,'2010-08-05','2012-10-09','dazzlingtysonthefifth47413@learnwebcode.com'),(29,'Marvelous Casey The Fifth','dog',47,'2016-06-10','2018-08-14','marvelouscaseythefifth67976@learnwebcode.com'),(30,'Incredible Cooper The Seventh','cat',56,'2011-09-03','2013-11-07','incrediblecoopertheseventh26622@learnwebcode.com'),(31,'Phenomenal Princess Junior','dog',39,'2016-03-15','2018-05-19','phenomenalprincessjunior41932@learnwebcode.com'),(32,'Swell Fluffy The Eighth','fish',20,'2017-04-14','2019-06-18','swellfluffytheeighth13385@learnwebcode.com'),(33,'Stellar Lola Junior','guinea pig',9,'2012-09-18','2014-11-22','stellarlolajunior12314@learnwebcode.com'),(34,'Remarkable Simba The Third','cat',79,'2010-11-08','2012-11-12','remarkablesimbathethird63744@learnwebcode.com'),(35,'Stupendous Zoe Junior','llama',36,'2011-03-26','2013-05-26','stupendouszoejunior41291@learnwebcode.com'),(36,'Smashing Ruby Junior','guinea pig',79,'2018-12-26','2018-12-26','smashingrubyjunior49365@learnwebcode.com'),(37,'Terrific Apollo Junior','hamster',49,'2019-04-17','2019-06-21','terrificapollojunior63635@learnwebcode.com'),(38,'Fantastic Mia The Fourth','fish',97,'2011-07-23','2013-09-27','fantasticmiathefourth86725@learnwebcode.com'),(39,'Wonderful Zoey The Ninth','hamster',40,'2013-02-25','2015-04-25','wonderfulzoeytheninth83789@learnwebcode.com'),(40,'Groundbreaking Bella Senior','fish',70,'2013-01-27','2015-03-27','groundbreakingbellasenior96758@learnwebcode.com'),(41,'Fantastic Bentley The Ninth','llama',35,'2009-05-13','2011-07-17','fantasticbentleytheninth66965@learnwebcode.com'),(42,'Transcendent Rosie The Seventh','hedgehog',74,'2016-02-14','2018-04-18','transcendentrosietheseventh36499@learnwebcode.com'),(43,'Swell Boo The Third','fish',13,'2020-01-08','2020-03-12','swellboothethird66148@learnwebcode.com'),(44,'Lovely Winston The Fourth','dog',38,'2020-12-23','2020-12-27','lovelywinstonthefourth26655@learnwebcode.com'),(45,'Remarkable Lucky Senior','chicken',58,'2015-11-19','2017-11-23','remarkableluckysenior12537@learnwebcode.com'),(46,'Brilliant Fluffy The Third','hamster',66,'2015-08-25','2017-10-25','brilliantfluffythethird34543@learnwebcode.com'),(47,'Ultimate Benny Junior','hamster',86,'2010-08-26','2012-10-26','ultimatebennyjunior21484@learnwebcode.com'),(48,'Wondrous Lola The Sixth','fish',21,'2011-08-22','2013-10-26','wondrouslolathesixth73148@learnwebcode.com'),(49,'Wondrous Kiki The Seventh','llama',82,'2019-05-03','2019-07-07','wondrouskikitheseventh34385@learnwebcode.com'),(50,'Breathtaking Jackson The Fourth','cat',12,'2016-05-27','2018-07-27','breathtakingjacksonthefourth15414@learnwebcode.com'),(51,'Astounding Spooky The Sixth','llama',62,'2014-11-09','2016-11-13','astoundingspookythesixth31723@learnwebcode.com'),(52,'Laudable Simba The Seventh','bird',61,'2008-08-24','2010-10-24','laudablesimbatheseventh55791@learnwebcode.com'),(53,'Luminous Stella The Seventh','goat',42,'2011-05-27','2013-07-27','luminousstellatheseventh38913@learnwebcode.com'),(54,'Sweet Shadow The Ninth','chicken',72,'2017-10-03','2019-12-07','sweetshadowtheninth74532@learnwebcode.com'),(55,'Stupendous Snuggles The Fourth','cat',42,'2011-06-17','2013-08-21','stupendoussnugglesthefourth91265@learnwebcode.com'),(56,'Lovely Willow Senior','lizard',89,'2013-09-11','2015-11-15','lovelywillowsenior81254@learnwebcode.com'),(57,'Dazzling Winston The Ninth','chicken',68,'2015-01-24','2017-03-24','dazzlingwinstontheninth33178@learnwebcode.com'),(58,'Polished Ziggy The Ninth','goat',73,'2018-10-01','2018-12-05','polishedziggytheninth64563@learnwebcode.com'),(59,'Breathtaking Pepper The Sixth','hamster',9,'2012-11-03','2014-11-07','breathtakingpepperthesixth44864@learnwebcode.com'),(60,'Swell Sam The Fourth','fish',1,'2009-08-21','2011-10-25','swellsamthefourth11989@learnwebcode.com'),(61,'Awesome Sandy Senior','mouse',17,'2013-11-12','2015-11-16','awesomesandysenior16838@learnwebcode.com'),(62,'Spectacular Loki Senior','hamster',35,'2017-02-19','2019-04-23','spectacularlokisenior82816@learnwebcode.com'),(63,'Supreme Holly The Seventh','bird',87,'2015-11-05','2017-11-09','supremehollytheseventh15444@learnwebcode.com'),(64,'Classy Rusty Senior','mouse',87,'2009-01-10','2011-03-14','classyrustysenior92926@learnwebcode.com'),(65,'Breathtaking Moose Junior','guinea pig',33,'2017-08-25','2019-10-25','breathtakingmoosejunior79672@learnwebcode.com'),(66,'Astonishing Scooter Senior','llama',25,'2009-06-23','2011-08-27','astonishingscootersenior66457@learnwebcode.com'),(67,'Lovely Bo The Sixth','lizard',58,'2015-11-21','2017-11-25','lovelybothesixth19815@learnwebcode.com'),(68,'Impeccable Dakota The Eighth','chicken',23,'2020-05-09','2020-07-13','impeccabledakotatheeighth17818@learnwebcode.com'),(69,'Ultimate Coco The Sixth','llama',35,'2012-08-27','2014-10-27','ultimatecocothesixth28466@learnwebcode.com'),(70,'Phenomenal Roxy The Seventh','hamster',44,'2010-05-06','2012-07-10','phenomenalroxytheseventh51363@learnwebcode.com'),(71,'Wondrous Luna The Ninth','guinea pig',74,'2010-08-23','2012-10-27','wondrouslunatheninth77125@learnwebcode.com'),(72,'Delightful Penny The Fifth','chicken',45,'2019-07-23','2019-09-27','delightfulpennythefifth98278@learnwebcode.com'),(73,'Solid Lucy Senior','llama',87,'2015-04-27','2017-06-27','solidlucysenior62927@learnwebcode.com'),(74,'Great Romeo The Sixth','hedgehog',88,'2011-08-04','2013-10-08','greatromeothesixth51794@learnwebcode.com'),(75,'Splendid Harley Junior','goat',53,'2011-05-25','2013-07-25','splendidharleyjunior17458@learnwebcode.com'),(76,'Splendid Jackson The Third','dog',62,'2012-08-17','2014-10-21','splendidjacksonthethird29523@learnwebcode.com'),(77,'Tremendous Bandit The Fifth','dog',44,'2020-12-09','2020-12-13','tremendousbanditthefifth18781@learnwebcode.com'),(78,'Classy Ginger The Eighth','lizard',23,'2018-06-04','2018-08-08','classygingertheeighth16955@learnwebcode.com'),(79,'Stupendous Sadie The Fourth','fish',69,'2008-04-20','2010-06-24','stupendoussadiethefourth98881@learnwebcode.com'),(80,'Ultimate Pebbles Senior','hamster',5,'2010-10-19','2012-12-23','ultimatepebblessenior73125@learnwebcode.com'),(81,'Splendid Mickey Junior','guinea pig',39,'2017-07-07','2019-09-11','splendidmickeyjunior55156@learnwebcode.com'),(82,'Ultimate Layla The Eighth','hedgehog',92,'2014-03-01','2016-05-05','ultimatelaylatheeighth84587@learnwebcode.com'),(83,'Incredible Nikki The Sixth','lizard',43,'2012-08-05','2014-10-09','incrediblenikkithesixth31433@learnwebcode.com'),(84,'Excellent Sydney The Seventh','hedgehog',15,'2010-04-06','2012-06-10','excellentsydneytheseventh71979@learnwebcode.com'),(85,'Splendid Romeo The Sixth','mouse',42,'2015-10-19','2017-12-23','splendidromeothesixth51377@learnwebcode.com'),(86,'Stupendous Snowball The Seventh','bird',84,'2011-05-03','2013-07-07','stupendoussnowballtheseventh93259@learnwebcode.com'),(87,'Glorious Sophie The Fourth','hedgehog',14,'2011-09-22','2013-11-26','glorioussophiethefourth64348@learnwebcode.com'),(88,'Cool Casper The Sixth','chicken',8,'2016-05-17','2018-07-21','coolcasperthesixth99913@learnwebcode.com'),(89,'Good Luna The Ninth','hamster',11,'2015-05-28','2017-07-28','goodlunatheninth12489@learnwebcode.com'),(90,'Sweet Buster The Fourth','mouse',2,'2020-06-19','2020-08-23','sweetbusterthefourth54834@learnwebcode.com'),(91,'Amazing Oliver Junior','chicken',96,'2008-07-10','2010-09-14','amazingoliverjunior64287@learnwebcode.com'),(92,'Swell Mocha The Fourth','hedgehog',75,'2010-07-16','2012-09-20','swellmochathefourth27922@learnwebcode.com'),(93,'Legendary Apollo The Third','hamster',91,'2018-07-18','2018-09-22','legendaryapollothethird46353@learnwebcode.com'),(94,'Luminous Kona The Ninth','mouse',77,'2010-09-27','2012-11-27','luminouskonatheninth98872@learnwebcode.com'),(95,'Terrific Kona The Seventh','guinea pig',2,'2017-07-20','2019-09-24','terrifickonatheseventh19629@learnwebcode.com'),(96,'Swell Henry Senior','bird',100,'2009-07-03','2011-09-07','swellhenrysenior95577@learnwebcode.com'),(97,'Phenomenal Hunter The Eighth','cat',32,'2014-01-11','2016-03-15','phenomenalhuntertheeighth23837@learnwebcode.com'),(98,'Neat Sophie The Seventh','hedgehog',5,'2013-02-26','2015-04-26','neatsophietheseventh73396@learnwebcode.com'),(99,'Exquisite Casper The Sixth','fish',57,'2020-03-01','2020-05-05','exquisitecasperthesixth39391@learnwebcode.com'),(100,'Polished Sam The Fifth','bird',80,'2009-05-26','2011-07-26','polishedsamthefifth67464@learnwebcode.com');
/*!40000 ALTER TABLE `animals` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `orderlines`
--
DROP TABLE IF EXISTS `orderlines`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `orderlines` (
`id` int NOT NULL AUTO_INCREMENT,
`productid` int NOT NULL,
`orderid` int DEFAULT NULL,
`quantity` mediumint NOT NULL,
PRIMARY KEY (`id`),
KEY `orderid_idx` (`orderid`),
KEY `productid_idx` (`productid`),
CONSTRAINT `orderid` FOREIGN KEY (`orderid`) REFERENCES `orders` (`id`),
CONSTRAINT `productid` FOREIGN KEY (`productid`) REFERENCES `products` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=983 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orderlines`
--
LOCK TABLES `orderlines` WRITE;
/*!40000 ALTER TABLE `orderlines` DISABLE KEYS */;
INSERT INTO `orderlines` VALUES (1,64,1,4),(2,41,1,2),(3,17,1,3),(4,55,2,5),(5,18,3,5),(6,11,4,2),(7,22,4,2),(8,46,4,3),(9,18,5,4),(10,49,5,5),(11,45,6,3),(12,37,7,1),(13,53,7,3),(14,52,7,1),(15,66,8,1),(16,28,9,2),(17,25,10,3),(18,47,11,1),(19,1,12,1),(20,38,12,3),(21,33,12,5),(22,24,13,2),(23,26,13,3),(24,22,13,5),(25,37,14,1),(26,53,14,2),(27,65,15,1),(28,20,16,1),(29,4,17,3),(30,6,17,3),(31,52,18,5),(32,8,18,2),(33,65,18,4),(34,13,19,2),(35,17,19,4),(36,64,20,2),(37,7,21,3),(38,48,21,1),(39,67,22,2),(40,23,23,3),(41,16,23,5),(42,9,23,4),(43,14,24,2),(44,16,24,5),(45,35,25,5),(46,11,25,5),(47,5,25,2),(48,42,26,2),(49,67,26,1),(50,57,26,5),(51,5,27,2),(52,57,27,2),(53,65,27,2),(54,41,28,4),(55,48,29,5),(56,17,30,4),(57,28,30,5),(58,14,30,2),(59,13,31,5),(60,8,31,4),(61,53,32,2),(62,67,33,1),(63,37,34,3),(64,2,34,4),(65,11,35,1),(66,22,36,2),(67,53,36,5),(68,25,36,2),(69,33,37,4),(70,47,38,1),(71,15,39,1),(72,54,40,2),(73,66,41,4),(74,33,42,5),(75,26,43,2),(76,41,44,4),(77,9,45,5),(78,6,45,3),(79,15,45,4),(80,61,46,1),(81,31,46,1),(82,65,47,3),(83,17,48,4),(84,32,48,2),(85,7,48,3),(86,57,49,3),(87,46,49,5),(88,56,50,1),(89,58,50,5),(90,24,50,1),(91,63,51,1),(92,10,51,3),(93,53,51,2),(94,24,52,1),(95,43,53,1),(96,35,54,2),(97,47,54,5),(98,64,55,1),(99,37,55,4),(100,25,55,1),(101,2,56,4),(102,48,57,3),(103,25,58,5),(104,55,59,3),(105,5,59,2),(106,32,60,4),(107,25,60,4),(108,7,61,1),(109,15,61,2),(110,48,61,1),(111,9,62,5),(112,4,63,4),(113,62,63,3),(114,39,63,5),(115,34,64,5),(116,67,65,2),(117,48,65,3),(118,39,66,1),(119,42,66,1),(120,1,66,3),(121,11,67,3),(122,24,67,4),(123,4,67,1),(124,33,68,5),(125,52,69,5),(126,39,69,2),(127,10,70,2),(128,12,70,3),(129,53,70,2),(130,15,71,4),(131,63,72,5),(132,39,73,5),(133,27,73,1),(134,7,74,2),(135,13,75,5),(136,43,76,3),(137,59,76,2),(138,66,77,3),(139,19,78,3),(140,37,78,4),(141,51,78,4),(142,22,79,4),(143,22,80,3),(144,15,80,5),(145,57,80,1),(146,58,81,4),(147,28,81,3),(148,29,81,3),(149,15,82,2),(150,41,82,2),(151,64,82,5),(152,63,83,5),(153,12,83,1),(154,51,83,1),(155,7,84,4),(156,25,84,3),(157,8,84,2),(158,31,85,5),(159,13,86,1),(160,20,86,5),(161,1,87,1),(162,44,87,2),(163,17,87,4),(164,16,88,5),(165,16,88,2),(166,13,89,1),(167,61,89,2),(168,58,89,4),(169,8,90,2),(170,49,91,5),(171,63,91,4),(172,44,91,5),(173,48,92,4),(174,19,93,2),(175,35,94,5),(176,24,94,3),(177,6,95,1),(178,48,95,5),(179,16,96,2),(180,10,96,3),(181,26,97,5),(182,26,97,4),(183,41,98,5),(184,28,99,2),(185,51,99,4),(186,10,100,5),(187,52,100,4),(188,15,101,2),(189,34,101,5),(190,7,101,2),(191,61,102,1),(192,63,102,4),(193,8,103,2),(194,38,104,5),(195,56,105,1),(196,32,105,3),(197,9,106,4),(198,48,106,3),(199,29,107,3),(200,5,107,4),(201,65,107,4),(202,61,108,4),(203,6,109,2),(204,6,109,2),(205,53,109,4),(206,46,110,1),(207,46,111,5),(208,59,112,5),(209,28,113,2),(210,34,113,2),(211,8,113,5),(212,43,114,4),(213,25,115,3),(214,21,116,3),(215,6,116,4),(216,45,116,2),(217,1,117,1),(218,9,117,5),(219,53,118,5),(220,10,119,3),(221,28,119,5),(222,67,119,2),(223,47,120,4),(224,58,120,5),(225,58,121,2),(226,18,121,1),(227,12,121,2),(228,7,122,1),(229,11,123,4),(230,7,123,4),(231,44,124,5),(232,67,125,2),(233,31,126,5),(234,53,126,1),(235,63,127,1),(236,48,128,1),(237,12,128,3),(238,59,129,1),(239,65,129,5),(240,27,129,5),(241,66,130,2),(242,6,130,4),(243,62,131,1),(244,62,132,1),(245,10,133,2),(246,54,133,1),(247,53,134,1),(248,63,135,3),(249,31,135,1),(250,12,136,3),(251,43,136,1),(252,5,137,3),(253,58,137,4),(254,11,138,1),(255,51,138,1),(256,29,138,1),(257,26,139,5),(258,34,139,4),(259,16,140,1),(260,7,140,3),(261,5,140,1),(262,19,141,5),(263,12,142,3),(264,23,143,1),(265,12,143,1),(266,43,144,5),(267,66,144,1),(268,21,145,2),(269,23,146,3),(270,52,146,1),(271,17,147,4),(272,14,147,2),(273,21,147,1),(274,51,148,5),(275,48,148,1),(276,67,149,3),(277,19,149,5),(278,31,149,2),(279,49,150,3),(280,34,151,3),(281,62,152,1),(282,59,152,1),(283,1,153,1),(284,41,154,4),(285,41,154,4),(286,43,155,4),(287,15,155,3),(288,63,156,3),(289,56,156,3),(290,64,156,3),(291,61,157,5),(292,55,158,2),(293,46,158,2),(294,20,159,3),(295,20,159,2),(296,29,159,5),(297,51,160,1),(298,35,160,3),(299,2,161,3),(300,45,161,5),(301,61,161,5),(302,63,162,4),(303,22,162,1),(304,24,163,5),(305,29,163,4),(306,42,164,1),(307,14,164,4),(308,62,164,3),(309,33,165,5),(310,9,166,3),(311,10,167,1),(312,33,167,2),(313,5,168,1),(314,22,168,4),(315,11,168,1),(316,24,169,5),(317,54,170,5),(318,4,170,4),(319,35,171,4),(320,67,171,5),(321,61,171,2),(322,59,172,5),(323,63,173,5),(324,12,174,3),(325,63,175,3),(326,42,176,2),(327,35,176,3),(328,27,177,1),(329,5,177,4),(330,6,178,4),(331,10,179,1),(332,17,179,3),(333,15,180,4),(334,10,180,1),(335,34,181,3),(336,22,181,1),(337,11,182,3),(338,48,182,2),(339,64,183,5),(340,58,184,4),(341,24,184,4),(342,67,185,4),(343,47,185,2),(344,13,185,3),(345,28,186,2),(346,11,186,5),(347,52,186,4),(348,45,187,3),(349,14,187,2),(350,44,187,5),(351,37,188,5),(352,41,189,2),(353,63,189,5),(354,20,189,1),(355,66,190,5),(356,58,190,1),(357,24,190,1),(358,22,191,4),(359,8,191,5),(360,25,192,3),(361,19,192,1),(362,45,192,5),(363,28,193,2),(364,59,193,2),(365,41,193,4),(366,66,194,4),(367,17,194,5),(368,25,195,2),(369,15,196,1),(370,66,197,2),(371,4,197,3),(372,17,197,1),(373,37,198,3),(374,39,198,2),(375,62,198,1),(376,31,199,5),(377,34,199,5),(378,1,199,1),(379,41,200,1),(380,17,201,1),(381,53,201,2),(382,47,201,4),(383,9,202,1),(384,19,203,1),(385,14,203,2),(386,55,203,2),(387,64,204,3),(388,55,204,1),(389,53,204,5),(390,34,205,1),(391,29,205,5),(392,26,205,2),(393,28,206,2),(394,10,206,2),(395,44,206,2),(396,31,207,3),(397,34,207,2),(398,53,208,4),(399,19,208,5),(400,25,209,2),(401,4,210,5),(402,48,211,5),(403,32,211,2),(404,13,212,3),(405,58,212,4),(406,36,213,1),(407,6,214,1),(408,41,214,3),(409,16,215,3),(410,24,216,5),(411,48,217,4),(412,31,217,4),(413,8,218,1),(414,65,219,2),(415,16,219,2),(416,6,220,4),(417,27,221,4),(418,66,221,1),(419,24,222,5),(420,36,223,1),(421,24,223,4),(422,23,223,5),(423,21,224,3),(424,20,224,2),(425,8,224,2),(426,5,225,5),(427,57,226,1),(428,37,226,5),(429,10,227,1),(430,29,227,5),(431,62,228,4),(432,23,229,2),(433,64,230,5),(434,58,230,4),(435,41,230,1),(436,46,231,5),(437,16,231,2),(438,46,231,2),(439,7,232,4),(440,62,233,1),(441,26,234,3),(442,23,234,1),(443,53,234,5),(444,37,235,4),(445,14,235,5),(446,62,235,5),(447,27,236,3),(448,53,236,2),(449,15,237,1),(450,10,238,3),(451,54,239,2),(452,16,240,5),(453,32,241,3),(454,5,241,3),(455,14,242,4),(456,31,242,2),(457,27,242,3),(458,34,243,5),(459,5,243,3),(460,24,243,4),(461,31,244,3),(462,51,244,5),(463,6,244,5),(464,56,245,4),(465,4,246,5),(466,61,246,2),(467,51,247,1),(468,16,247,1),(469,8,248,5),(470,7,248,5),(471,36,248,5),(472,48,249,4),(473,4,250,3),(474,11,250,3),(475,48,250,5),(476,58,251,4),(477,55,251,3),(478,12,251,4),(479,2,252,1),(480,26,252,3),(481,11,253,5),(482,67,253,4),(483,34,254,1),(484,51,254,5),(485,44,255,3),(486,23,255,4),(487,54,256,1),(488,1,257,5),(489,29,257,3),(490,2,257,1),(491,58,258,5),(492,46,259,5),(493,10,259,2),(494,31,260,1),(495,27,260,3),(496,6,260,5),(497,22,261,5),(498,26,262,2),(499,25,263,3),(500,46,264,3),(501,38,264,1),(502,20,264,3),(503,47,265,2),(504,47,265,4),(505,52,265,5),(506,49,266,3),(507,32,266,4),(508,18,267,2),(509,5,267,1),(510,66,267,5),(511,1,268,4),(512,47,268,1),(513,19,268,2),(514,34,269,4),(515,59,269,1),(516,14,269,4),(517,24,270,3),(518,44,270,4),(519,41,271,5),(520,63,272,2),(521,63,272,5),(522,37,273,4),(523,57,273,5),(524,25,274,5),(525,16,274,1),(526,17,275,4),(527,46,275,3),(528,6,275,2),(529,62,276,3),(530,58,276,2),(531,20,276,5),(532,44,277,5),(533,4,277,5),(534,15,277,4),(535,54,278,4),(536,17,279,3),(537,64,280,1),(538,38,281,4),(539,49,282,3),(540,18,283,2),(541,63,283,5),(542,6,283,4),(543,25,284,5),(544,25,284,4),(545,34,284,4),(546,29,285,3),(547,12,286,1),(548,41,286,2),(549,14,286,5),(550,18,287,1),(551,22,288,3),(552,14,288,5),(553,57,289,5),(554,67,290,2),(555,33,290,3),(556,17,291,2),(557,25,291,3),(558,58,292,3),(559,32,293,4),(560,64,293,4),(561,65,293,2),(562,22,294,4),(563,28,295,3),(564,41,295,1),(565,22,296,5),(566,5,296,5),(567,22,296,4),(568,15,297,5),(569,56,297,5),(570,18,297,4),(571,24,298,5),(572,24,299,4),(573,65,299,3),(574,57,299,5),(575,62,300,3),(576,32,301,2),(577,52,302,3),(578,34,302,1),(579,55,303,4),(580,5,303,2),(581,58,304,4),(582,31,304,5),(583,31,305,4),(584,35,306,1),(585,66,307,5),(586,14,308,5),(587,62,309,1),(588,19,309,2),(589,61,309,2),(590,25,310,2),(591,61,310,4),(592,24,310,3),(593,47,311,2),(594,18,311,4),(595,29,311,2),(596,51,312,3),(597,28,312,1),(598,31,313,5),(599,5,314,4),(600,67,315,5),(601,25,315,2),(602,62,315,5),(603,36,316,1),(604,36,316,5),(605,2,316,5),(606,13,317,1),(607,24,318,1),(608,26,319,1),(609,55,319,2),(610,61,320,5),(611,35,320,4),(612,29,321,2),(613,57,322,2),(614,64,323,4),(615,56,323,5),(616,23,323,1),(617,22,324,5),(618,23,325,2),(619,61,325,5),(620,28,325,2),(621,14,326,3),(622,63,327,5),(623,53,328,4),(624,22,329,5),(625,49,330,2),(626,19,331,1),(627,42,331,2),(628,27,332,2),(629,39,332,5),(630,29,332,1),(631,42,333,1),(632,36,334,2),(633,28,334,4),(634,10,334,3),(635,15,335,1),(636,13,336,1),(637,19,337,3),(638,38,338,1),(639,51,338,3),(640,54,338,4),(641,62,339,4),(642,16,339,1),(643,52,340,1),(644,2,340,4),(645,47,341,1),(646,20,341,5),(647,8,342,1),(648,32,342,3),(649,43,343,5),(650,45,343,3),(651,54,343,5),(652,19,344,4),(653,26,344,4),(654,47,344,3),(655,65,345,4),(656,6,345,3),(657,23,346,3),(658,54,346,4),(659,9,346,4),(660,65,347,2),(661,32,347,2),(662,51,347,4),(663,21,348,5),(664,45,349,1),(665,38,349,4),(666,34,349,1),(667,52,350,4),(668,2,350,1),(669,37,350,3),(670,24,351,3),(671,39,352,2),(672,62,352,5),(673,10,353,5),(674,7,353,2),(675,17,353,4),(676,45,354,5),(677,67,354,3),(678,46,355,2),(679,61,355,5),(680,46,355,3),(681,1,356,3),(682,67,356,5),(683,44,357,3),(684,8,357,3),(685,22,358,1),(686,54,359,2),(687,38,359,4),(688,28,360,2),(689,42,360,5),(690,56,361,1),(691,18,361,4),(692,38,361,5),(693,29,362,1),(694,31,362,2),(695,18,362,5),(696,64,363,5),(697,6,363,1),(698,20,364,1),(699,13,364,4),(700,36,365,2),(701,63,366,5),(702,67,366,2),(703,8,367,4),(704,29,367,4),(705,36,368,5),(706,39,368,2),(707,65,369,5),(708,1,369,4),(709,67,370,4),(710,19,370,2),(711,8,371,5),(712,67,371,5),(713,28,371,1),(714,54,372,3),(715,25,372,3),(716,8,372,2),(717,52,373,2),(718,8,373,1),(719,7,373,2),(720,45,374,2),(721,23,374,2),(722,7,374,5),(723,58,375,5),(724,58,376,3),(725,48,376,5),(726,4,376,4),(727,36,377,2),(728,44,378,2),(729,44,378,5),(730,13,378,2),(731,35,379,4),(732,35,379,5),(733,13,380,1),(734,45,381,2),(735,55,382,1),(736,56,383,1),(737,5,383,4),(738,61,384,2),(739,58,384,5),(740,44,385,1),(741,20,385,1),(742,16,385,2),(743,46,386,3),(744,29,386,2),(745,18,386,2),(746,14,387,5),(747,51,387,5),(748,47,387,4),(749,49,388,1),(750,15,389,1),(751,47,389,3),(752,38,390,2),(753,4,390,4),(754,29,391,2),(755,51,391,3),(756,43,391,1),(757,12,392,3),(758,56,392,3),(759,47,393,4),(760,14,393,4),(761,27,393,1),(762,1,394,5),(763,33,394,1),(764,27,394,5),(765,56,395,1),(766,51,395,3),(767,44,396,5),(768,46,397,5),(769,25,398,2),(770,46,398,4),(771,66,398,2),(772,49,399,3),(773,56,400,5),(774,22,401,1),(775,33,402,3),(776,23,403,1),(777,41,403,5),(778,42,404,1),(779,19,404,3),(780,27,405,2),(781,11,406,5),(782,66,406,1),(783,42,407,5),(784,9,407,3),(785,67,408,2),(786,4,408,3),(787,49,408,5),(788,11,409,2),(789,55,409,2),(790,56,410,3),(791,39,410,4),(792,14,411,1),(793,29,411,2),(794,9,412,3),(795,39,412,5),(796,51,412,1),(797,7,413,3),(798,29,414,3),(799,22,414,2),(800,18,414,3),(801,4,415,5),(802,63,415,2),(803,19,415,2),(804,43,416,4),(805,42,416,5),(806,38,417,4),(807,5,418,4),(808,61,418,4),(809,18,419,4),(810,44,419,3),(811,7,420,4),(812,45,420,5),(813,58,420,4),(814,42,421,3),(815,13,422,3),(816,23,422,4),(817,9,423,2),(818,25,424,5),(819,9,424,3),(820,49,424,1),(821,28,425,2),(822,52,425,3),(823,44,425,5),(824,24,426,2),(825,22,426,5),(826,18,426,2),(827,67,427,1),(828,44,427,2),(829,22,428,3),(830,65,428,1),(831,52,428,5),(832,5,429,1),(833,33,429,1),(834,21,429,3),(835,4,430,2),(836,46,430,5),(837,26,431,5),(838,35,431,1),(839,19,432,3),(840,33,432,4),(841,29,433,1),(842,4,433,4),(843,43,433,1),(844,64,434,5),(845,46,435,1),(846,24,435,1),(847,38,435,2),(848,55,436,3),(849,2,437,3),(850,11,437,4),(851,38,437,2),(852,33,438,2),(853,45,438,3),(854,26,439,1),(855,65,439,5),(856,34,440,5),(857,16,440,5),(858,53,440,3),(859,49,441,5),(860,6,441,4),(861,57,441,3),(862,39,442,3),(863,66,442,5),(864,57,443,3),(865,2,443,4),(866,45,443,4),(867,8,444,3),(868,20,444,5),(869,34,445,1),(870,66,445,2),(871,16,446,1),(872,46,447,2),(873,38,447,1),(874,28,447,2),(875,28,448,3),(876,8,449,4),(877,28,450,2),(878,12,451,5),(879,9,451,1),(880,2,452,1),(881,2,453,5),(882,24,453,2),(883,62,453,5),(884,67,454,5),(885,32,455,1),(886,2,455,2),(887,27,456,4),(888,24,456,5),(889,29,457,5),(890,18,457,3),(891,34,458,4),(892,62,459,1),(893,53,459,5),(894,35,460,1),(895,46,461,5),(896,49,461,1),(897,42,462,1),(898,53,462,4),(899,38,462,4),(900,2,463,2),(901,63,464,5),(902,15,464,2),(903,11,465,4),(904,53,465,1),(905,2,466,4),(906,7,466,4),(907,9,467,2),(908,44,467,2),(909,37,467,1),(910,15,468,1),(911,61,469,1),(912,29,469,4),(913,34,470,5),(914,55,470,3),(915,49,470,5),(916,26,471,2),(917,31,471,5),(918,45,472,3),(919,8,472,1),(920,55,472,2),(921,55,473,2),(922,21,473,4),(923,56,474,1),(924,61,475,5),(925,20,475,4),(926,29,476,2),(927,26,476,2),(928,37,477,5),(929,7,477,4),(930,20,477,5),(931,27,478,4),(932,12,479,1),(933,44,480,1),(934,54,480,3),(935,22,481,5),(936,49,481,1),(937,2,482,4),(938,36,482,3),(939,23,482,3),(940,42,483,2),(941,29,483,3),(942,19,483,1),(943,24,484,4),(944,12,485,3),(945,20,486,5),(946,24,486,2),(947,23,487,4),(948,63,487,1),(949,47,487,5),(950,36,488,1),(951,56,488,5),(952,18,489,5),(953,66,489,1),(954,36,489,5),(955,54,490,1),(956,54,491,4),(957,31,491,4),(958,7,491,3),(959,22,492,1),(960,7,492,3),(961,29,492,3),(962,48,493,4),(963,38,493,2),(964,63,493,4),(965,51,494,2),(966,27,494,5),(967,49,495,1),(968,20,495,2),(969,1,495,3),(970,36,496,4),(971,43,496,5),(972,39,496,5),(973,35,497,2),(974,34,497,5),(975,29,497,1),(976,64,498,2),(977,2,498,1),(978,6,498,2),(979,65,499,5),(980,44,500,4),(981,59,500,5),(982,1,500,3);
/*!40000 ALTER TABLE `orderlines` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `orders`
--
DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `orders` (
`id` int NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL,
`userid` int NOT NULL,
PRIMARY KEY (`id`),
KEY `userid_idx` (`userid`),
CONSTRAINT `userid` FOREIGN KEY (`userid`) REFERENCES `animals` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=501 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orders`
--
LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (1,'2016-04-14 00:00:00',79),(2,'2020-10-13 00:00:00',32),(3,'2017-06-14 00:00:00',87),(4,'2017-09-17 00:00:00',34),(5,'2019-08-17 00:00:00',28),(6,'2020-10-06 00:00:00',1),(7,'2016-09-17 00:00:00',19),(8,'2015-04-03 00:00:00',86),(9,'2016-03-07 00:00:00',39),(10,'2015-06-27 00:00:00',55),(11,'2020-05-17 00:00:00',84),(12,'2015-05-21 00:00:00',84),(13,'2018-09-26 00:00:00',63),(14,'2015-03-04 00:00:00',16),(15,'2020-09-19 00:00:00',53),(16,'2018-08-18 00:00:00',46),(17,'2020-11-11 00:00:00',11),(18,'2020-12-24 00:00:00',8),(19,'2017-12-05 00:00:00',18),(20,'2019-05-22 00:00:00',2),(21,'2012-01-22 00:00:00',79),(22,'2017-07-05 00:00:00',59),(23,'2020-10-27 00:00:00',78),(24,'2015-12-27 00:00:00',41),(25,'2013-03-02 00:00:00',28),(26,'2020-12-04 00:00:00',78),(27,'2019-10-27 00:00:00',14),(28,'2018-12-10 00:00:00',47),(29,'2015-09-10 00:00:00',100),(30,'2019-12-27 00:00:00',96),(31,'2019-09-09 00:00:00',56),(32,'2013-05-21 00:00:00',41),(33,'2017-03-22 00:00:00',21),(34,'2014-03-25 00:00:00',70),(35,'2018-10-23 00:00:00',76),(36,'2015-11-25 00:00:00',35),(37,'2020-12-25 00:00:00',88),(38,'2017-07-16 00:00:00',61),(39,'2019-07-13 00:00:00',29),(40,'2020-08-06 00:00:00',39),(41,'2017-09-06 00:00:00',51),(42,'2020-05-25 00:00:00',11),(43,'2018-09-23 00:00:00',61),(44,'2012-02-23 00:00:00',100),(45,'2014-10-27 00:00:00',86),(46,'2020-10-01 00:00:00',36),(47,'2018-02-24 00:00:00',57),(48,'2012-12-09 00:00:00',66),(49,'2016-09-22 00:00:00',35),(50,'2019-11-22 00:00:00',36),(51,'2020-08-17 00:00:00',62),(52,'2020-02-18 00:00:00',95),(53,'2018-05-24 00:00:00',75),(54,'2018-05-13 00:00:00',73),(55,'2020-06-03 00:00:00',43),(56,'2020-02-07 00:00:00',91),(57,'2020-02-08 00:00:00',95),(58,'2020-08-19 00:00:00',3),(59,'2019-03-10 00:00:00',79),(60,'2017-10-12 00:00:00',59),(61,'2020-07-25 00:00:00',98),(62,'2020-11-04 00:00:00',27),(63,'2020-04-05 00:00:00',81),(64,'2018-11-14 00:00:00',73),(65,'2019-12-18 00:00:00',73),(66,'2017-10-17 00:00:00',39),(67,'2018-11-13 00:00:00',75),(68,'2020-11-13 00:00:00',21),(69,'2015-04-20 00:00:00',55),(70,'2018-09-09 00:00:00',83),(71,'2017-09-26 00:00:00',38),(72,'2017-07-11 00:00:00',3),(73,'2018-07-09 00:00:00',55),(74,'2013-01-24 00:00:00',70),(75,'2020-12-07 00:00:00',20),(76,'2018-11-15 00:00:00',93),(77,'2019-08-13 00:00:00',21),(78,'2020-07-09 00:00:00',37),(79,'2019-05-07 00:00:00',51),(80,'2020-12-26 00:00:00',54),(81,'2020-10-06 00:00:00',89),(82,'2019-09-23 00:00:00',97),(83,'2020-12-14 00:00:00',98),(84,'2020-01-24 00:00:00',73),(85,'2019-12-19 00:00:00',36),(86,'2020-12-26 00:00:00',24),(87,'2020-12-10 00:00:00',90),(88,'2017-08-26 00:00:00',73),(89,'2015-03-04 00:00:00',96),(90,'2018-09-21 00:00:00',31),(91,'2013-02-27 00:00:00',94),(92,'2020-12-28 00:00:00',44),(93,'2018-04-17 00:00:00',15),(94,'2017-07-07 00:00:00',71),(95,'2020-08-23 00:00:00',27),(96,'2020-11-16 00:00:00',89),(97,'2018-10-01 00:00:00',97),(98,'2020-11-28 00:00:00',42),(99,'2019-11-11 00:00:00',21),(100,'2019-03-26 00:00:00',59),(101,'2017-04-01 00:00:00',69),(102,'2019-02-16 00:00:00',82),(103,'2017-03-26 00:00:00',61),(104,'2019-08-02 00:00:00',58),(105,'2020-08-13 00:00:00',99),(106,'2020-01-18 00:00:00',72),(107,'2012-10-28 00:00:00',71),(108,'2020-12-23 00:00:00',43),(109,'2020-01-24 00:00:00',78),(110,'2020-04-12 00:00:00',97),(111,'2019-05-03 00:00:00',21),(112,'2020-07-05 00:00:00',12),(113,'2014-02-03 00:00:00',52),(114,'2017-03-08 00:00:00',9),(115,'2020-08-28 00:00:00',12),(116,'2015-08-23 00:00:00',28),(117,'2020-09-16 00:00:00',12),(118,'2020-01-03 00:00:00',36),(119,'2018-11-02 00:00:00',29),(120,'2020-09-20 00:00:00',100),(121,'2012-12-19 00:00:00',64),(122,'2020-11-18 00:00:00',83),(123,'2020-08-09 00:00:00',68),(124,'2020-09-19 00:00:00',90),(125,'2018-04-24 00:00:00',63),(126,'2020-06-19 00:00:00',31),(127,'2013-07-24 00:00:00',94),(128,'2018-03-22 00:00:00',46),(129,'2018-06-07 00:00:00',22),(130,'2020-04-20 00:00:00',43),(131,'2020-03-08 00:00:00',78),(132,'2016-11-21 00:00:00',82),(133,'2016-05-22 00:00:00',83),(134,'2016-12-03 00:00:00',97),(135,'2016-04-03 00:00:00',13),(136,'2019-10-08 00:00:00',48),(137,'2020-12-09 00:00:00',98),(138,'2020-11-13 00:00:00',90),(139,'2019-12-27 00:00:00',62),(140,'2019-01-09 00:00:00',36),(141,'2019-11-19 00:00:00',48),(142,'2018-08-25 00:00:00',91),(143,'2020-03-28 00:00:00',32),(144,'2018-11-05 00:00:00',10),(145,'2019-01-27 00:00:00',16),(146,'2019-09-27 00:00:00',62),(147,'2020-01-24 00:00:00',78),(148,'2017-10-10 00:00:00',38),(149,'2020-02-13 00:00:00',62),(150,'2018-09-02 00:00:00',6),(151,'2019-04-08 00:00:00',2),(152,'2020-11-13 00:00:00',63),(153,'2019-10-25 00:00:00',95),(154,'2020-02-26 00:00:00',1),(155,'2015-06-08 00:00:00',87),(156,'2016-08-07 00:00:00',86),(157,'2020-02-10 00:00:00',88),(158,'2014-07-25 00:00:00',87),(159,'2020-11-17 00:00:00',8),(160,'2019-03-25 00:00:00',14),(161,'2020-12-18 00:00:00',9),(162,'2020-05-24 00:00:00',43),(163,'2020-10-04 00:00:00',11),(164,'2014-04-17 00:00:00',48),(165,'2020-10-13 00:00:00',19),(166,'2017-10-28 00:00:00',3),(167,'2016-09-02 00:00:00',10),(168,'2020-05-09 00:00:00',12),(169,'2015-10-26 00:00:00',83),(170,'2018-03-17 00:00:00',63),(171,'2017-08-17 00:00:00',57),(172,'2020-03-01 00:00:00',30),(173,'2020-10-08 00:00:00',90),(174,'2019-05-28 00:00:00',39),(175,'2014-05-19 00:00:00',75),(176,'2012-01-18 00:00:00',16),(177,'2020-12-09 00:00:00',68),(178,'2019-03-17 00:00:00',88),(179,'2019-06-20 00:00:00',29),(180,'2020-12-07 00:00:00',20),(181,'2016-12-21 00:00:00',97),(182,'2020-12-28 00:00:00',44),(183,'2016-03-07 00:00:00',18),(184,'2019-10-25 00:00:00',81),(185,'2018-12-04 00:00:00',2),(186,'2017-08-23 00:00:00',61),(187,'2019-09-10 00:00:00',24),(188,'2017-04-11 00:00:00',3),(189,'2016-12-08 00:00:00',40),(190,'2019-09-11 00:00:00',73),(191,'2018-11-28 00:00:00',40),(192,'2017-11-16 00:00:00',61),(193,'2018-12-17 00:00:00',93),(194,'2013-05-04 00:00:00',28),(195,'2016-12-09 00:00:00',19),(196,'2020-01-07 00:00:00',72),(197,'2020-11-07 00:00:00',57),(198,'2019-05-07 00:00:00',86),(199,'2013-10-16 00:00:00',28),(200,'2020-10-18 00:00:00',81),(201,'2018-01-25 00:00:00',16),(202,'2017-12-18 00:00:00',66),(203,'2015-09-06 00:00:00',19),(204,'2016-01-16 00:00:00',86),(205,'2019-11-12 00:00:00',67),(206,'2020-04-03 00:00:00',50),(207,'2020-02-14 00:00:00',27),(208,'2020-10-18 00:00:00',26),(209,'2019-12-18 00:00:00',78),(210,'2020-11-09 00:00:00',95),(211,'2019-07-08 00:00:00',19),(212,'2016-12-25 00:00:00',52),(213,'2019-11-06 00:00:00',58),(214,'2019-07-28 00:00:00',36),(215,'2020-01-25 00:00:00',58),(216,'2013-10-23 00:00:00',34),(217,'2019-03-01 00:00:00',82),(218,'2018-12-08 00:00:00',15),(219,'2020-09-07 00:00:00',17),(220,'2015-11-18 00:00:00',39),(221,'2017-06-10 00:00:00',75),(222,'2015-09-13 00:00:00',40),(223,'2019-04-28 00:00:00',88),(224,'2018-11-27 00:00:00',42),(225,'2016-06-08 00:00:00',19),(226,'2013-01-22 00:00:00',9),(227,'2019-05-07 00:00:00',62),(228,'2016-10-14 00:00:00',18),(229,'2020-09-19 00:00:00',79),(230,'2020-08-16 00:00:00',43),(231,'2020-07-04 00:00:00',2),(232,'2019-04-18 00:00:00',93),(233,'2015-04-16 00:00:00',94),(234,'2017-02-11 00:00:00',9),(235,'2019-12-17 00:00:00',1),(236,'2019-08-10 00:00:00',62),(237,'2015-11-05 00:00:00',64),(238,'2017-01-23 00:00:00',28),(239,'2017-05-11 00:00:00',56),(240,'2020-12-28 00:00:00',44),(241,'2017-07-16 00:00:00',71),(242,'2018-07-25 00:00:00',6),(243,'2017-06-02 00:00:00',53),(244,'2013-07-23 00:00:00',66),(245,'2017-09-20 00:00:00',40),(246,'2018-11-07 00:00:00',96),(247,'2019-09-27 00:00:00',30),(248,'2020-11-18 00:00:00',17),(249,'2012-09-07 00:00:00',91),(250,'2019-10-28 00:00:00',39),(251,'2020-12-27 00:00:00',93),(252,'2020-04-11 00:00:00',43),(253,'2020-05-07 00:00:00',43),(254,'2011-06-25 00:00:00',64),(255,'2020-12-28 00:00:00',44),(256,'2016-11-21 00:00:00',98),(257,'2015-08-12 00:00:00',59),(258,'2020-11-18 00:00:00',1),(259,'2020-06-27 00:00:00',42),(260,'2013-10-06 00:00:00',16),(261,'2020-12-19 00:00:00',77),(262,'2019-01-22 00:00:00',86),(263,'2020-02-22 00:00:00',40),(264,'2014-06-28 00:00:00',91),(265,'2019-05-17 00:00:00',6),(266,'2017-10-10 00:00:00',33),(267,'2014-02-27 00:00:00',13),(268,'2017-02-05 00:00:00',10),(269,'2020-07-13 00:00:00',99),(270,'2013-12-05 00:00:00',13),(271,'2020-07-22 00:00:00',15),(272,'2020-12-28 00:00:00',44),(273,'2020-12-24 00:00:00',18),(274,'2019-05-10 00:00:00',67),(275,'2020-03-18 00:00:00',31),(276,'2020-12-24 00:00:00',77),(277,'2015-12-15 00:00:00',47),(278,'2014-12-02 00:00:00',41),(279,'2013-03-14 00:00:00',18),(280,'2020-12-18 00:00:00',77),(281,'2018-08-24 00:00:00',69),(282,'2020-04-16 00:00:00',36),(283,'2017-04-27 00:00:00',83),(284,'2020-03-08 00:00:00',78),(285,'2020-01-19 00:00:00',2),(286,'2019-03-19 00:00:00',74),(287,'2020-10-28 00:00:00',64),(288,'2020-01-15 00:00:00',49),(289,'2016-02-07 00:00:00',94),(290,'2020-02-24 00:00:00',59),(291,'2013-11-22 00:00:00',48),(292,'2017-01-23 00:00:00',84),(293,'2014-10-19 00:00:00',7),(294,'2016-06-07 00:00:00',96),(295,'2018-02-14 00:00:00',53),(296,'2014-12-26 00:00:00',48),(297,'2020-05-03 00:00:00',81),(298,'2012-06-19 00:00:00',18),(299,'2019-10-22 00:00:00',82),(300,'2015-10-11 00:00:00',41),(301,'2020-01-18 00:00:00',51),(302,'2020-01-22 00:00:00',67),(303,'2019-10-17 00:00:00',49),(304,'2020-03-03 00:00:00',67),(305,'2020-04-13 00:00:00',11),(306,'2020-07-24 00:00:00',99),(307,'2020-09-08 00:00:00',17),(308,'2013-03-20 00:00:00',94),(309,'2016-05-20 00:00:00',40),(310,'2020-08-14 00:00:00',20),(311,'2017-10-02 00:00:00',15),(312,'2019-05-03 00:00:00',26),(313,'2016-08-27 00:00:00',97),(314,'2018-09-08 00:00:00',82),(315,'2018-01-27 00:00:00',53),(316,'2018-12-12 00:00:00',16),(317,'2019-10-23 00:00:00',62),(318,'2016-10-22 00:00:00',34),(319,'2020-08-26 00:00:00',13),(320,'2020-12-21 00:00:00',77),(321,'2015-01-15 00:00:00',76),(322,'2019-02-21 00:00:00',36),(323,'2019-07-07 00:00:00',37),(324,'2013-05-20 00:00:00',13),(325,'2015-01-22 00:00:00',80),(326,'2017-08-04 00:00:00',89),(327,'2020-09-25 00:00:00',68),(328,'2020-12-28 00:00:00',44),(329,'2017-11-09 00:00:00',15),(330,'2019-08-22 00:00:00',56),(331,'2019-08-14 00:00:00',36),(332,'2014-10-17 00:00:00',47),(333,'2020-02-22 00:00:00',32),(334,'2020-09-25 00:00:00',27),(335,'2018-08-26 00:00:00',31),(336,'2019-10-01 00:00:00',39),(337,'2020-06-25 00:00:00',15),(338,'2012-08-04 00:00:00',79),(339,'2020-09-27 00:00:00',1),(340,'2019-04-02 00:00:00',15),(341,'2012-10-16 00:00:00',64),(342,'2020-01-02 00:00:00',37),(343,'2018-02-26 00:00:00',70),(344,'2020-12-20 00:00:00',48),(345,'2019-01-02 00:00:00',42),(346,'2017-08-19 00:00:00',7),(347,'2020-04-13 00:00:00',42),(348,'2019-11-03 00:00:00',37),(349,'2015-09-25 00:00:00',86),(350,'2018-06-15 00:00:00',73),(351,'2019-03-19 00:00:00',94),(352,'2016-04-01 00:00:00',55),(353,'2020-04-25 00:00:00',39),(354,'2018-09-04 00:00:00',88),(355,'2014-08-14 00:00:00',22),(356,'2020-12-13 00:00:00',63),(357,'2019-08-19 00:00:00',67),(358,'2020-12-22 00:00:00',77),(359,'2017-12-14 00:00:00',63),(360,'2018-06-08 00:00:00',59),(361,'2015-10-09 00:00:00',59),(362,'2020-03-17 00:00:00',60),(363,'2015-03-27 00:00:00',94),(364,'2020-11-15 00:00:00',69),(365,'2011-09-04 00:00:00',91),(366,'2020-08-19 00:00:00',68),(367,'2016-02-23 00:00:00',74),(368,'2020-02-20 00:00:00',81),(369,'2020-04-25 00:00:00',33),(370,'2017-08-21 00:00:00',16),(371,'2018-11-23 00:00:00',88),(372,'2015-08-08 00:00:00',83),(373,'2013-09-06 00:00:00',4),(374,'2020-07-13 00:00:00',43),(375,'2015-07-24 00:00:00',59),(376,'2020-11-03 00:00:00',2),(377,'2013-12-16 00:00:00',4),(378,'2011-09-15 00:00:00',9),(379,'2014-05-27 00:00:00',34),(380,'2018-09-26 00:00:00',33),(381,'2014-01-23 00:00:00',4),(382,'2020-10-13 00:00:00',17),(383,'2015-02-16 00:00:00',86),(384,'2020-03-10 00:00:00',54),(385,'2020-03-08 00:00:00',88),(386,'2018-07-14 00:00:00',22),(387,'2019-02-03 00:00:00',36),(388,'2019-07-18 00:00:00',23),(389,'2017-03-25 00:00:00',10),(390,'2015-05-12 00:00:00',66),(391,'2016-11-15 00:00:00',98),(392,'2020-11-02 00:00:00',37),(393,'2016-05-18 00:00:00',18),(394,'2017-10-24 00:00:00',15),(395,'2018-12-17 00:00:00',14),(396,'2016-05-21 00:00:00',75),(397,'2017-10-03 00:00:00',57),(398,'2020-12-08 00:00:00',17),(399,'2019-12-02 00:00:00',95),(400,'2020-04-19 00:00:00',54),(401,'2016-10-26 00:00:00',96),(402,'2017-04-23 00:00:00',61),(403,'2020-06-04 00:00:00',94),(404,'2020-03-08 00:00:00',54),(405,'2016-04-28 00:00:00',75),(406,'2019-11-18 00:00:00',89),(407,'2018-08-16 00:00:00',6),(408,'2014-12-20 00:00:00',9),(409,'2019-12-27 00:00:00',62),(410,'2015-11-13 00:00:00',3),(411,'2020-02-14 00:00:00',56),(412,'2017-12-27 00:00:00',57),(413,'2020-05-20 00:00:00',49),(414,'2020-10-26 00:00:00',50),(415,'2017-01-09 00:00:00',52),(416,'2018-01-23 00:00:00',55),(417,'2019-09-16 00:00:00',42),(418,'2019-12-17 00:00:00',23),(419,'2017-10-27 00:00:00',57),(420,'2019-06-06 00:00:00',56),(421,'2019-03-20 00:00:00',89),(422,'2019-05-22 00:00:00',3),(423,'2020-11-20 00:00:00',48),(424,'2020-11-25 00:00:00',20),(425,'2020-05-14 00:00:00',95),(426,'2020-07-28 00:00:00',32),(427,'2019-07-22 00:00:00',37),(428,'2019-02-02 00:00:00',63),(429,'2015-12-14 00:00:00',4),(430,'2018-01-21 00:00:00',30),(431,'2018-01-16 00:00:00',87),(432,'2020-10-27 00:00:00',90),(433,'2018-03-19 00:00:00',60),(434,'2019-01-19 00:00:00',76),(435,'2020-05-09 00:00:00',8),(436,'2016-06-24 00:00:00',23),(437,'2013-02-27 00:00:00',80),(438,'2017-03-11 00:00:00',83),(439,'2020-12-18 00:00:00',90),(440,'2012-08-08 00:00:00',16),(441,'2019-04-19 00:00:00',24),(442,'2019-04-15 00:00:00',70),(443,'2020-06-02 00:00:00',57),(444,'2013-04-19 00:00:00',28),(445,'2014-05-16 00:00:00',23),(446,'2015-05-21 00:00:00',69),(447,'2019-12-04 00:00:00',12),(448,'2016-05-22 00:00:00',75),(449,'2018-01-03 00:00:00',67),(450,'2016-03-03 00:00:00',34),(451,'2020-12-21 00:00:00',98),(452,'2016-11-08 00:00:00',82),(453,'2020-07-21 00:00:00',27),(454,'2018-05-06 00:00:00',92),(455,'2017-12-11 00:00:00',86),(456,'2014-02-14 00:00:00',79),(457,'2016-11-04 00:00:00',7),(458,'2014-08-07 00:00:00',9),(459,'2019-08-21 00:00:00',80),(460,'2020-03-24 00:00:00',69),(461,'2020-11-08 00:00:00',29),(462,'2016-02-28 00:00:00',98),(463,'2020-08-10 00:00:00',68),(464,'2020-10-22 00:00:00',39),(465,'2019-11-21 00:00:00',36),(466,'2016-08-03 00:00:00',47),(467,'2012-10-01 00:00:00',22),(468,'2019-01-01 00:00:00',14),(469,'2017-09-05 00:00:00',18),(470,'2019-05-07 00:00:00',2),(471,'2017-04-17 00:00:00',98),(472,'2017-12-06 00:00:00',67),(473,'2019-12-24 00:00:00',72),(474,'2019-04-01 00:00:00',50),(475,'2020-01-07 00:00:00',11),(476,'2014-09-22 00:00:00',92),(477,'2020-08-11 00:00:00',8),(478,'2015-06-17 00:00:00',91),(479,'2014-04-19 00:00:00',48),(480,'2019-03-17 00:00:00',41),(481,'2015-05-17 00:00:00',83),(482,'2020-06-07 00:00:00',32),(483,'2018-10-01 00:00:00',21),(484,'2020-09-26 00:00:00',32),(485,'2017-09-01 00:00:00',61),(486,'2018-06-05 00:00:00',57),(487,'2016-04-27 00:00:00',41),(488,'2014-11-06 00:00:00',47),(489,'2013-10-15 00:00:00',13),(490,'2016-06-22 00:00:00',66),(491,'2020-08-03 00:00:00',30),(492,'2020-08-20 00:00:00',29),(493,'2017-11-16 00:00:00',38),(494,'2016-08-12 00:00:00',39),(495,'2013-06-16 00:00:00',35),(496,'2020-01-06 00:00:00',81),(497,'2019-11-19 00:00:00',56),(498,'2019-12-28 00:00:00',95),(499,'2018-01-08 00:00:00',28),(500,'2019-07-27 00:00:00',28);
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `products`
--
DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL,
`priceusd` decimal(10,2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `products`
--
LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,'Apple',84.72),(2,'Apricot',48.14),(3,'Asparagus',88.11),(4,'Avocado',15.02),(5,'Banana',43.62),(6,'Blackberry',48.19),(7,'Blueberry',87.56),(8,'Boysenberry',86.11),(9,'Broccoli',89.91),(10,'Cabbage',92.84),(11,'Cantaloupe',99.34),(12,'Carrot',52.97),(13,'Celery',96.04),(14,'Cherry',95.05),(15,'Cilantro',53.10),(16,'Clementine',56.51),(17,'Coconut',6.45),(18,'Corn',32.37),(19,'Cranberry',85.01),(20,'Cucumber',51.76),(21,'Dragonfruit',79.14),(22,'Fig',78.89),(23,'Garlic',75.13),(24,'Goji berry',60.95),(25,'Gooseberry',99.93),(26,'Grape',9.73),(27,'Grapefruit',78.74),(28,'Guava',80.09),(29,'Honeyberry',13.25),(30,'Honeydew',89.48),(31,'Huckleberry',57.11),(32,'Jackfruit',49.12),(33,'Kiwifruit',69.02),(34,'Kumquat',25.10),(35,'Lemon',99.29),(36,'Lime',76.79),(37,'Loquat',2.33),(38,'Mandarine',80.01),(39,'Mango',67.04),(40,'Marionberry',64.10),(41,'Mulberry',32.74),(42,'Nance',87.59),(43,'Nectarine',77.48),(44,'Olive',4.12),(45,'Onion',14.22),(46,'Orange',55.91),(47,'Papaya',10.09),(48,'Passionfruit',69.87),(49,'Peach',31.18),(50,'Pear',90.46),(51,'Persimmon',84.39),(52,'Pineapple',41.39),(53,'Plantain',79.10),(54,'Plum',48.35),(55,'Plumcot',58.42),(56,'Pomegranate',48.39),(57,'Prune',62.82),(58,'Raisin',66.78),(59,'Raspberry',80.49),(60,'Strawberry',22.00),(61,'Tamarind',27.70),(62,'Tangerine',60.51),(63,'Tomato',24.06),(64,'Turnip',51.29),(65,'Watermelon',67.70),(66,'Yam',65.70),(67,'Zucchini',67.76);
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `reviews`
--
DROP TABLE IF EXISTS `reviews`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reviews` (
`id` int NOT NULL AUTO_INCREMENT,
`productreviewed` int NOT NULL,
`reviewauthor` int NOT NULL,
`rating` tinyint NOT NULL,
`description` longtext,
`datereviewed` date NOT NULL,
PRIMARY KEY (`id`),
KEY `productreviewed_idx` (`productreviewed`),
KEY `reviewauthor_idx` (`reviewauthor`),
FULLTEXT KEY `description` (`description`),
CONSTRAINT `productreviewed` FOREIGN KEY (`productreviewed`) REFERENCES `products` (`id`),
CONSTRAINT `reviewauthor` FOREIGN KEY (`reviewauthor`) REFERENCES `animals` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=477 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `reviews`
--
LOCK TABLES `reviews` WRITE;
/*!40000 ALTER TABLE `reviews` DISABLE KEYS */;
INSERT INTO `reviews` VALUES (1,41,79,4,'','2020-09-02'),(2,18,87,1,'','2019-03-22'),(3,11,34,1,'Okay, these items were terrible, do not waste your money.','2019-04-12'),(4,22,34,4,'','2019-04-12'),(5,18,28,4,'','2020-05-21'),(6,45,1,2,'','2020-11-18'),(7,37,19,1,'','2017-10-08'),(8,66,86,1,'These were horrendous, I cannot imagine anyone orders these twice.','2016-05-28'),(9,38,84,4,'','2019-02-08'),(10,37,16,4,'','2020-09-06'),(11,65,53,1,'I must say that these were disgusting, I cannot imagine anyone orders these twice.','2020-10-06'),(12,20,46,5,'Okay, these items were marvelous, a real party favorite!','2020-11-19'),(13,4,11,3,'','2020-12-16'),(14,8,8,4,'','2020-12-25'),(15,13,18,3,'','2019-06-23'),(16,17,18,2,'','2019-06-23'),(17,64,2,2,'','2020-02-07'),(18,7,79,5,'','2012-08-07'),(19,67,59,2,'','2018-02-21'),(20,23,78,2,'','2020-11-26'),(21,35,28,4,'I gave these a try and they were exceptional, a real party favorite!','2013-06-23'),(22,11,28,2,'','2013-06-23'),(23,57,78,4,'Well, these items were wonderful, I recommend these to all my friends now.','2020-12-16'),(24,5,14,2,'Well, these items were awful, I do NOT recommend them.','2020-06-07'),(25,65,14,3,'These were lackluster, not terrible, but not superb either.','2020-06-07'),(26,13,56,1,'','2020-03-23'),(27,8,56,3,'Well, these items were average, not disgusting, but not splendid either.','2020-03-23'),(28,22,35,4,'','2018-10-13'),(29,66,51,5,'','2020-04-26'),(30,33,11,5,'','2020-06-20'),(31,26,61,1,'','2020-04-06'),(32,17,66,4,'Okay, these items were excellent, I recommend these to all my friends now.','2015-01-26'),(33,32,66,3,'','2015-01-26'),(34,7,66,2,'','2015-01-26'),(35,57,35,2,'These were disgusting, do not waste your money.','2019-03-28'),(36,46,35,4,'I decided to order these on a whim and these were marvelous, I will definitely order these again.','2019-03-28'),(37,58,36,3,'','2020-06-27'),(38,24,36,5,'','2020-06-27'),(39,10,62,1,'','2020-10-14'),(40,43,75,5,'Believe it or not, these items were magnificent, I recommend these to all my friends now.','2018-11-22'),(41,25,43,2,'','2020-11-07'),(42,25,3,2,'','2020-10-17'),(43,55,79,1,'','2019-08-03'),(44,25,59,2,'','2018-10-06'),(45,4,81,4,'','2020-10-19'),(46,39,81,2,'Well, these items were gross, and I will not be ordering them again.','2020-10-19'),(47,34,73,3,'','2018-12-16'),(48,67,73,4,'','2020-02-17'),(49,48,73,4,'','2020-02-17'),(50,1,39,2,'Well, these items were terrible, and I will not be ordering them again.','2019-12-18'),(51,4,75,4,'','2018-11-21'),(52,52,55,4,'','2016-04-24'),(53,39,55,3,'','2016-04-24'),(54,10,83,2,'Well, these items were disgusting, do not waste your money.','2020-05-12'),(55,15,38,5,'I must say that these were exceptional, easy reorder for me.','2019-09-20'),(56,27,55,5,'I gave these a try and they were wonderful, I will definitely order these again.','2019-02-03'),(57,7,70,5,'','2013-12-01'),(58,59,93,3,'Well, these items were lackluster, not gross, but not magnificent either.','2019-03-28'),(59,66,21,1,'','2019-09-08'),(60,37,37,5,'','2020-12-27'),(61,51,37,2,'','2020-12-27'),(62,22,51,4,'','2020-05-06'),(63,15,54,5,'','2020-12-28'),(64,57,54,5,'','2020-12-28'),(65,28,89,2,'','2020-12-15'),(66,29,89,5,'','2020-12-15'),(67,15,97,5,'','2020-01-11'),(68,64,97,3,'','2020-01-11'),(69,12,98,5,'Okay, these items were outstanding, easy reorder for me.','2020-12-16'),(70,7,73,5,'','2020-08-24'),(71,25,73,3,'','2020-08-24'),(72,31,36,5,'','2020-09-24'),(73,44,90,4,'','2020-12-18'),(74,16,73,2,'','2019-08-26'),(75,13,96,4,'','2017-02-10'),(76,61,96,5,'','2017-02-10'),(77,58,96,2,'','2017-02-10'),(78,8,31,1,'I decided to order these on a whim and these were terrible, I cannot imagine anyone orders these twice.','2020-02-11'),(79,49,94,5,'','2016-04-13'),(80,63,94,2,'I must say that these were horrible, I do NOT recommend them.','2016-04-13'),(81,44,94,3,'','2016-04-13'),(82,48,44,2,'','2020-12-28'),(83,19,15,2,'','2019-11-15'),(84,48,27,2,'','2020-12-13'),(85,16,89,1,'I decided to order these on a whim and these were horrendous, do not waste your money.','2020-12-11'),(86,10,89,4,'','2020-12-11'),(87,26,97,4,'These were outstanding, easy reorder for me.','2020-03-09'),(88,41,42,5,'','2020-12-14'),(89,28,21,4,'Well, these items were marvelous, easy reorder for me.','2020-02-25'),(90,10,59,4,'Okay, these items were wonderful, if you are considering buying them, just get them already!','2020-08-15'),(91,15,69,5,'','2018-09-03'),(92,34,69,4,'','2018-09-03'),(93,61,82,5,'','2019-08-02'),(94,63,82,2,'I gave these a try and they were horrendous, I do NOT recommend them.','2019-08-02'),(95,8,61,4,'I decided to order these on a whim and these were outstanding, I will buy these again for sure.','2019-04-27'),(96,32,99,3,'','2020-09-02'),(97,61,43,2,'','2020-12-27'),(98,6,78,2,'','2020-03-10'),(99,53,78,5,'','2020-03-10'),(100,34,52,2,'','2015-09-02'),(101,8,52,1,'','2015-09-02'),(102,43,9,4,'','2017-07-23'),(103,21,28,2,'','2017-12-09'),(104,6,28,5,'','2017-12-09'),(105,45,28,1,'','2017-12-09'),(106,1,12,4,'Believe it or not, these items were splendid, I will buy these again for sure.','2020-10-07'),(107,9,12,5,'I must say that these were splendid, easy reorder for me.','2020-10-07'),(108,67,29,1,'','2020-04-01'),(109,58,100,3,'Well, these items were just okay, not nasty, but not splendid either.','2020-11-22'),(110,58,64,4,'These were excellent, I will definitely order these again.','2018-08-26'),(111,12,64,3,'','2018-08-26'),(112,7,83,3,'','2020-12-01'),(113,63,94,5,'','2019-01-05'),(114,48,46,1,'Believe it or not, these items were gross, I do NOT recommend them.','2020-04-22'),(115,12,46,5,'','2020-04-22'),(116,27,22,2,'I must say that these were terrible, I cannot imagine anyone orders these twice.','2020-09-12'),(117,66,43,3,'These were average, not horrendous, but not wonderful either.','2020-12-17'),(118,6,43,1,'','2020-12-17'),(119,62,78,1,'','2020-12-15'),(120,62,82,3,'','2019-05-08'),(121,31,13,3,'I gave these a try and they were average, not nasty, but not excellent either.','2020-04-21'),(122,12,48,2,'','2019-11-15'),(123,5,98,1,'','2020-12-17'),(124,29,90,1,'','2020-12-06'),(125,26,62,4,'I must say that these were amazing, I will definitely order these again.','2020-11-25'),(126,5,36,4,'','2019-09-27'),(127,12,91,1,'','2020-12-23'),(128,23,32,1,'','2020-05-05'),(129,66,10,5,'I gave these a try and they were excellent, I recommend these to all my friends now.','2019-03-25'),(130,21,16,3,'','2020-02-22'),(131,52,62,4,'','2020-09-10'),(132,17,78,2,'','2020-03-19'),(133,14,78,2,'These were disgusting, I do NOT recommend them.','2020-03-19'),(134,51,38,4,'Okay, these items were excellent, I will buy these again for sure.','2020-01-03'),(135,48,38,2,'','2020-01-03'),(136,67,62,1,'','2020-12-08'),(137,49,6,5,'These were outstanding, I will definitely order these again.','2019-11-18'),(138,34,2,1,'These were awful, and I will not be ordering them again.','2020-11-24'),(139,62,63,4,'','2020-11-20'),(140,41,1,2,'','2020-08-05'),(141,41,1,5,'I gave these a try and they were marvelous, I will buy these again for sure.','2020-08-05'),(142,43,87,3,'','2016-03-11'),(143,56,86,1,'','2018-07-19'),(144,46,87,5,'','2017-09-25'),(145,20,8,4,'','2020-11-18'),(146,51,14,3,'','2019-12-17'),(147,35,14,4,'Okay, these items were splendid, a real party favorite!','2019-12-17'),(148,45,9,4,'','2020-12-21'),(149,61,9,4,'','2020-12-21'),(150,63,43,3,'I must say that these were just okay, not horrendous, but not excellent either.','2020-06-07'),(151,29,11,3,'These were just okay, not gross, but not superb either.','2020-10-17'),(152,42,48,3,'','2019-10-03'),(153,14,48,5,'','2019-10-03'),(154,62,48,1,'Believe it or not, these items were horrible, I cannot imagine anyone orders these twice.','2019-10-03'),(155,33,19,4,'','2020-11-20'),(156,9,3,3,'','2019-03-20'),(157,10,10,5,'','2019-03-06'),(158,11,12,4,'','2020-11-01'),(159,54,63,1,'','2020-07-24'),(160,35,57,1,'','2020-08-19'),(161,67,57,4,'Well, these items were excellent, a real party favorite!','2020-08-19'),(162,61,57,2,'I must say that these were terrible, I cannot imagine anyone orders these twice.','2020-08-19'),(163,63,90,4,'','2020-11-18'),(164,12,39,3,'I must say that these were lackluster, not awful, but not outstanding either.','2020-12-14'),(165,42,16,5,'Believe it or not, these items were wonderful, I recommend these to all my friends now.','2013-12-09'),(166,35,16,1,'Well, these items were disgusting, do not waste your money.','2013-12-09'),(167,27,68,1,'','2020-12-28'),(168,5,68,4,'','2020-12-28'),(169,17,29,5,'','2020-04-25'),(170,34,97,4,'','2019-12-20'),(171,22,97,4,'','2019-12-20'),(172,11,44,5,'','2020-12-28'),(173,58,81,2,'Okay, these items were awful, I do NOT recommend them.','2019-11-24'),(174,47,2,4,'','2020-04-04'),(175,13,2,4,'','2020-04-04'),(176,28,61,5,'','2018-05-26'),(177,11,61,3,'I must say that these were lackluster, not dreadful, but not marvelous either.','2018-05-26'),(178,45,24,2,'These were dreadful, and I will not be ordering them again.','2019-11-06'),(179,14,24,3,'','2019-11-06'),(180,44,24,2,'','2019-11-06'),(181,37,3,5,'','2019-09-21'),(182,41,40,4,'','2018-03-15'),(183,20,40,5,'','2018-03-15'),(184,66,73,1,'','2020-04-19'),(185,22,40,1,'Okay, these items were horrible, do not waste your money.','2020-04-15'),(186,19,61,1,'','2019-07-15'),(187,28,93,4,'I gave these a try and they were excellent, I recommend these to all my friends now.','2020-04-02'),(188,66,28,2,'I gave these a try and they were horrendous, I cannot imagine anyone orders these twice.','2013-09-14'),(189,25,19,3,'','2018-07-23'),(190,39,86,1,'Believe it or not, these items were nasty, do not waste your money.','2019-06-03'),(191,62,86,3,'I must say that these were average, not horrendous, but not magnificent either.','2019-06-03'),(192,41,81,2,'','2020-12-19'),(193,17,16,5,'Believe it or not, these items were outstanding, I will definitely order these again.','2020-03-17'),(194,9,66,1,'Believe it or not, these items were dreadful, I do NOT recommend them.','2018-08-12'),(195,14,19,2,'I gave these a try and they were dreadful, I do NOT recommend them.','2018-09-25'),(196,55,86,3,'Well, these items were average, not disgusting, but not exceptional either.','2016-09-03'),(197,34,67,4,'','2020-08-10'),(198,29,67,3,'These were lackluster, not disgusting, but not marvelous either.','2020-08-10'),(199,28,50,1,'','2020-09-06'),(200,10,50,3,'These were humdrum, not dreadful, but not wonderful either.','2020-09-06'),(201,48,19,5,'','2020-01-25'),(202,32,19,4,'','2020-01-25'),(203,36,58,2,'','2020-11-01'),(204,6,36,3,'I gave these a try and they were average, not horrible, but not marvelous either.','2020-04-15'),(205,41,36,5,'','2020-04-15'),(206,24,34,3,'','2018-12-15'),(207,48,82,2,'','2020-07-27'),(208,31,82,1,'','2020-07-27'),(209,8,15,3,'','2020-10-03'),(210,66,75,2,'','2020-07-28'),(211,24,88,1,'','2020-12-20'),(212,8,42,1,'Well, these items were terrible, do not waste your money.','2019-08-05'),(213,5,19,3,'','2018-02-08'),(214,37,9,3,'','2015-08-26'),(215,29,62,5,'','2020-05-13'),(216,58,43,2,'','2020-12-06'),(217,62,94,3,'','2019-03-23'),(218,53,9,3,'Okay, these items were just okay, not horrible, but not outstanding either.','2019-10-17'),(219,14,1,1,'I gave these a try and they were awful, and I will not be ordering them again.','2020-04-24'),(220,15,64,3,'','2017-11-15'),(221,10,28,3,'','2020-10-15'),(222,54,56,3,'These were just okay, not horrible, but not exceptional either.','2018-08-15'),(223,32,71,5,'','2019-02-28'),(224,27,6,5,'','2020-06-03'),(225,34,53,5,'Well, these items were exceptional, I will definitely order these again.','2020-11-03'),(226,5,53,2,'','2020-11-03'),(227,24,53,2,'','2020-11-03'),(228,61,96,2,'','2019-07-04'),(229,51,30,4,'','2020-12-02'),(230,16,30,2,'Believe it or not, these items were terrible, I do NOT recommend them.','2020-12-02'),(231,7,17,2,'','2020-11-25'),(232,36,17,3,'','2020-11-25'),(233,4,39,3,'','2020-01-16'),(234,55,93,3,'I gave these a try and they were humdrum, not disgusting, but not amazing either.','2020-12-27'),(235,26,43,4,'','2020-07-14'),(236,11,43,5,'','2020-05-18'),(237,51,64,2,'','2016-09-09'),(238,44,44,5,'Well, these items were amazing, I recommend these to all my friends now.','2020-12-28'),(239,23,44,3,'','2020-12-28'),(240,54,98,3,'','2018-07-21'),(241,1,59,2,'','2017-08-15'),(242,46,42,3,'I gave these a try and they were just okay, not horrendous, but not magnificent either.','2020-10-13'),(243,10,42,5,'','2020-10-13'),(244,31,16,4,'','2015-11-11'),(245,6,16,3,'','2015-11-11'),(246,22,77,4,'','2020-12-21'),(247,25,40,5,'Okay, these items were amazing, I will buy these again for sure.','2020-03-12'),(248,46,91,2,'','2019-05-16'),(249,20,91,5,'These were exceptional, a real party favorite!','2019-05-16'),(250,47,6,4,'I gave these a try and they were magnificent, easy reorder for me.','2020-06-08'),(251,52,6,1,'','2020-06-08'),(252,49,33,1,'','2018-02-27'),(253,32,33,1,'','2018-02-27'),(254,5,13,2,'Well, these items were gross, do not waste your money.','2018-02-01'),(255,66,13,2,'','2018-02-01'),(256,1,10,5,'','2018-10-14'),(257,19,10,2,'','2018-10-14'),(258,14,99,4,'','2020-09-28'),(259,41,15,2,'I gave these a try and they were horrendous, and I will not be ordering them again.','2020-08-13'),(260,63,44,2,'','2020-12-28'),(261,37,18,1,'Believe it or not, these items were awful, and I will not be ordering them again.','2020-12-24'),(262,57,18,2,'','2020-12-24'),(263,25,67,2,'','2020-12-13'),(264,16,67,1,'','2020-12-13'),(265,46,31,2,'','2020-08-09'),(266,4,47,4,'','2019-09-24'),(267,54,41,1,'','2019-08-09'),(268,63,83,1,'','2018-08-27'),(269,25,78,3,'','2020-10-11'),(270,29,2,1,'','2020-04-27'),(271,12,74,3,'','2019-09-21'),(272,18,64,3,'I gave these a try and they were average, not gross, but not outstanding either.','2020-12-28'),(273,33,59,1,'','2020-10-17'),(274,25,48,5,'','2018-08-20'),(275,32,7,5,'Okay, these items were wonderful, I will buy these again for sure.','2018-10-06'),(276,64,7,3,'','2018-10-06'),(277,65,7,1,'','2018-10-06'),(278,22,96,2,'','2018-10-22'),(279,41,53,4,'','2020-07-08'),(280,18,81,5,'','2020-06-23'),(281,24,82,4,'','2020-06-26'),(282,32,51,5,'','2020-10-14'),(283,34,67,2,'','2020-05-08'),(284,55,49,2,'','2020-12-12'),(285,58,67,4,'','2020-11-17'),(286,31,67,4,'Well, these items were outstanding, my family and I love these.','2020-11-17'),(287,35,99,3,'','2020-11-11'),(288,66,17,1,'','2020-10-21'),(289,14,94,3,'','2014-04-26'),(290,25,20,4,'I gave these a try and they were outstanding, a real party favorite!','2020-12-13'),(291,24,20,1,'','2020-12-13'),(292,47,15,1,'','2020-04-18'),(293,29,15,3,'','2020-04-18'),(294,67,53,4,'','2020-11-17'),(295,25,53,4,'','2020-11-17'),(296,36,16,4,'Okay, these items were exceptional, I will buy these again for sure.','2020-02-02'),(297,13,62,2,'','2020-08-28'),(298,35,77,3,'I decided to order these on a whim and these were lackluster, not terrible, but not outstanding either.','2020-12-27'),(299,29,76,4,'','2018-12-10'),(300,64,37,3,'','2020-02-13'),(301,22,13,1,'Well, these items were nasty, I cannot imagine anyone orders these twice.','2014-07-10'),(302,23,80,1,'','2015-02-05'),(303,28,80,1,'','2015-02-05'),(304,14,89,3,'','2020-10-19'),(305,53,44,2,'Believe it or not, these items were terrible, I cannot imagine anyone orders these twice.','2020-12-28'),(306,22,15,1,'','2019-03-21'),(307,49,56,5,'Believe it or not, these items were magnificent, I will definitely order these again.','2020-08-06'),(308,19,36,5,'','2020-06-08'),(309,42,36,3,'','2020-06-08'),(310,29,47,3,'','2020-04-09'),(311,28,27,5,'','2020-10-01'),(312,19,15,3,'','2020-06-26'),(313,51,79,1,'','2013-06-19'),(314,54,79,1,'','2013-06-19'),(315,62,1,2,'Okay, these items were horrible, do not waste your money.','2020-10-01'),(316,16,1,1,'','2020-10-01'),(317,52,15,5,'','2020-11-11'),(318,20,64,1,'','2015-07-01'),(319,32,37,2,'','2020-02-20'),(320,43,70,1,'','2020-11-25'),(321,54,70,2,'I gave these a try and they were terrible, and I will not be ordering them again.','2020-11-25'),(322,19,48,4,'','2020-12-28'),(323,65,42,4,'I must say that these were exceptional, I will definitely order these again.','2020-04-24'),(324,6,42,5,'','2020-04-24'),(325,23,7,5,'','2019-04-26'),(326,65,42,4,'','2020-09-11'),(327,32,42,5,'','2020-09-11'),(328,21,37,3,'','2020-12-28'),(329,34,86,4,'','2020-01-24'),(330,52,73,3,'','2018-10-15'),(331,37,73,3,'Well, these items were just okay, not horrible, but not marvelous either.','2018-10-15'),(332,39,55,3,'','2020-07-21'),(333,10,39,5,'','2020-06-01'),(334,61,22,1,'','2016-05-26'),(335,46,22,2,'','2016-05-26'),(336,1,63,5,'','2020-12-17'),(337,44,67,1,'','2020-04-03'),(338,22,77,2,'I gave these a try and they were gross, I do NOT recommend them.','2020-12-28'),(339,28,59,2,'','2019-05-11'),(340,18,59,5,'I gave these a try and they were wonderful, easy reorder for me.','2017-10-07'),(341,29,60,5,'','2020-04-19'),(342,18,60,1,'','2020-04-19'),(343,64,94,3,'I decided to order these on a whim and these were humdrum, not horrible, but not excellent either.','2018-01-23'),(344,6,94,1,'','2018-01-23'),(345,20,69,4,'','2020-12-09'),(346,36,91,2,'','2014-05-12'),(347,63,68,4,'Believe it or not, these items were magnificent, easy reorder for me.','2020-11-21'),(348,67,68,4,'','2020-11-21'),(349,8,74,3,'','2020-07-19'),(350,36,81,2,'','2020-03-26'),(351,65,33,3,'','2020-07-12'),(352,1,33,4,'','2020-07-12'),(353,67,16,3,'','2020-10-28'),(354,19,16,2,'I decided to order these on a whim and these were disgusting, I do NOT recommend them.','2020-10-28'),(355,8,88,4,'','2020-04-14'),(356,67,88,5,'','2020-04-14'),(357,52,4,1,'','2015-02-15'),(358,8,4,4,'Believe it or not, these items were excellent, my family and I love these.','2015-02-15'),(359,45,43,2,'','2020-07-20'),(360,58,2,3,'','2020-11-05'),(361,44,9,3,'I decided to order these on a whim and these were humdrum, not disgusting, but not exceptional either.','2018-03-22'),(362,13,9,4,'','2018-03-22'),(363,35,34,4,'','2020-11-21'),(364,35,34,3,'','2020-11-21'),(365,55,17,4,'','2020-12-24'),(366,56,86,1,'','2016-12-05'),(367,5,86,2,'','2016-12-05'),(368,58,54,2,'','2020-10-07'),(369,16,88,1,'','2020-04-26'),(370,14,36,1,'These were awful, and I will not be ordering them again.','2019-12-05'),(371,49,23,4,'','2020-01-12'),(372,47,10,3,'','2020-12-18'),(373,38,66,1,'Believe it or not, these items were disgusting, I do NOT recommend them.','2016-01-03'),(374,4,66,5,'','2016-01-03'),(375,43,98,1,'','2018-07-19'),(376,47,18,5,'','2020-07-13'),(377,27,15,1,'','2018-11-26'),(378,51,14,5,'','2019-03-08'),(379,25,17,5,'','2020-12-10'),(380,46,17,3,'Okay, these items were humdrum, not disgusting, but not marvelous either.','2020-12-10'),(381,22,96,2,'','2020-09-07'),(382,33,61,1,'Okay, these items were horrendous, and I will not be ordering them again.','2019-06-05'),(383,23,94,2,'Believe it or not, these items were horrible, I do NOT recommend them.','2020-09-07'),(384,42,54,2,'','2020-05-11'),(385,19,54,2,'I decided to order these on a whim and these were horrendous, do not waste your money.','2020-05-11'),(386,11,89,2,'','2020-06-04'),(387,66,89,2,'','2020-06-04'),(388,42,6,1,'','2019-01-18'),(389,9,6,1,'','2019-01-18'),(390,67,9,3,'Okay, these items were humdrum, not horrible, but not superb either.','2018-03-07'),(391,11,62,2,'','2020-02-01'),(392,14,56,2,'I must say that these were terrible, do not waste your money.','2020-08-06'),(393,39,57,4,'','2020-09-25'),(394,51,57,2,'','2020-09-25'),(395,7,49,2,'','2020-09-19'),(396,29,50,4,'I must say that these were superb, a real party favorite!','2020-11-09'),(397,18,50,4,'I decided to order these on a whim and these were splendid, easy reorder for me.','2020-11-09'),(398,4,52,5,'','2020-04-27'),(399,43,55,2,'','2019-11-07'),(400,61,23,4,'','2019-12-17'),(401,18,57,4,'','2020-06-21'),(402,23,3,3,'','2020-04-11'),(403,9,48,5,'','2020-12-22'),(404,25,20,5,'','2020-12-18'),(405,49,20,5,'','2020-12-18'),(406,28,95,3,'','2020-08-01'),(407,22,32,2,'I gave these a try and they were horrible, I do NOT recommend them.','2020-11-05'),(408,65,63,3,'These were just okay, not disgusting, but not marvelous either.','2019-08-25'),(409,5,4,2,'','2017-02-09'),(410,21,4,1,'Believe it or not, these items were terrible, do not waste your money.','2017-02-09'),(411,46,30,3,'','2020-02-25'),(412,26,87,4,'Okay, these items were superb, easy reorder for me.','2018-03-14'),(413,35,87,3,'','2018-03-14'),(414,19,90,4,'','2020-11-15'),(415,55,23,2,'','2017-11-25'),(416,11,80,2,'','2019-12-03'),(417,38,80,2,'These were horrendous, I do NOT recommend them.','2019-12-03'),(418,45,83,4,'','2020-05-25'),(419,26,90,1,'','2020-12-28'),(420,34,16,4,'','2016-06-16'),(421,53,16,3,'','2016-06-16'),(422,49,24,1,'','2020-06-13'),(423,39,70,5,'','2020-01-25'),(424,66,70,1,'','2020-01-25'),(425,45,57,5,'','2020-07-26'),(426,20,28,1,'','2019-08-19'),(427,34,23,4,'','2015-03-22'),(428,46,12,2,'','2020-09-19'),(429,8,67,3,'Well, these items were lackluster, not gross, but not magnificent either.','2018-06-21'),(430,2,27,3,'','2020-12-05'),(431,24,27,4,'Believe it or not, these items were marvelous, I will buy these again for sure.','2020-12-05'),(432,62,27,1,'','2020-12-05'),(433,67,92,4,'','2020-04-10'),(434,24,79,4,'','2020-02-24'),(435,29,7,2,'','2017-08-24'),(436,18,7,3,'','2017-08-24'),(437,62,80,5,'I must say that these were superb, I will definitely order these again.','2019-12-13'),(438,35,69,1,'','2020-04-21'),(439,46,29,3,'','2020-11-17'),(440,15,39,2,'I gave these a try and they were horrendous, do not waste your money.','2020-12-17'),(441,53,36,2,'','2020-03-19'),(442,61,18,2,'','2019-07-13'),(443,34,2,2,'Well, these items were terrible, I do NOT recommend them.','2019-10-02'),(444,26,98,2,'','2019-03-09'),(445,45,67,5,'','2018-09-22'),(446,55,67,4,'','2018-09-22'),(447,20,11,1,'','2020-07-22'),(448,26,92,1,'Okay, these items were dreadful, I cannot imagine anyone orders these twice.','2019-04-06'),(449,37,8,2,'','2020-09-04'),(450,7,8,4,'','2020-09-04'),(451,44,41,2,'','2019-09-11'),(452,54,41,5,'','2019-09-11'),(453,22,83,5,'I must say that these were outstanding, if you are considering buying them, just get them already!','2019-12-09'),(454,49,83,5,'','2019-12-09'),(455,36,32,1,'','2020-08-20'),(456,23,32,5,'','2020-08-20'),(457,42,21,2,'I decided to order these on a whim and these were terrible, and I will not be ordering them again.','2019-05-12'),(458,29,21,5,'','2019-05-12'),(459,20,57,5,'','2020-07-27'),(460,47,41,1,'','2017-07-09'),(461,36,47,1,'','2020-11-17'),(462,66,13,4,'','2017-01-03'),(463,36,13,1,'','2017-01-03'),(464,54,66,2,'','2019-01-14'),(465,7,29,4,'Believe it or not, these items were superb, a real party favorite!','2020-12-01'),(466,51,39,1,'','2020-11-19'),(467,1,35,3,'I must say that these were average, not gross, but not superb either.','2020-11-10'),(468,36,81,4,'','2020-10-15'),(469,39,81,4,'','2020-10-15'),(470,35,56,4,'','2020-07-10'),(471,34,56,4,'','2020-07-10'),(472,29,56,3,'I must say that these were average, not horrendous, but not splendid either.','2020-07-10'),(473,64,95,3,'','2020-09-20'),(474,2,95,5,'','2020-09-20'),(475,6,95,4,'I must say that these were marvelous, a real party favorite!','2020-09-20'),(476,65,28,2,'','2018-05-18');
/*!40000 ALTER TABLE `reviews` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2021-10-16 15:00:00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment