bookstore.sql

CREATE DATABASE  IF NOT EXISTS `bookstore` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `bookstore`;
-- MySQL dump 10.13  Distrib 8.0.29, for macos12 (x86_64)
--
-- Host: localhost    Database: bookstore
-- ------------------------------------------------------
-- Server version	8.0.29

/*!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 `admin`
--

DROP TABLE IF EXISTS `admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin` (
  `adminid` int NOT NULL AUTO_INCREMENT,
  `password` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `roleid` int NOT NULL,
  PRIMARY KEY (`adminid`),
  KEY `FK6rvg93s19aqwnw6rypw9hcp9h` (`roleid`),
  CONSTRAINT `FK6rvg93s19aqwnw6rypw9hcp9h` FOREIGN KEY (`roleid`) REFERENCES `role` (`roleid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin`
--

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES (1,'$2a$10$Vn7AcGQp7ZIsurVb1kkxLetkYEoAkB/V6vvKJmqePX33g15EiJO.q','jim',1);
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `author`
--

DROP TABLE IF EXISTS `author`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `author` (
  `authorid` int NOT NULL AUTO_INCREMENT,
  `biography` varchar(2500) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `portrait` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`authorid`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `author`
--

LOCK TABLES `author` WRITE;
/*!40000 ALTER TABLE `author` DISABLE KEYS */;
INSERT INTO `author` VALUES (1,'ERIC RIES is an entrepreneur and author of the popular blog Startup Lessons Learned. He co-founded and served as CTO of IMVU, his third startup, and has had plenty of startup failures along the way. He is a frequent speaker at business events, has advised a number of startups, large companies, and venture capital firms on business and product strategy, and is an Entrepreneur-in-Residence at Harvard Business School. His Lean Startup methodology has been written about in the New York Times, the Wall Street Journal, the Harvard Business Review, the Huffington Post, and many blogs. He lives in San Francisco.','Eric','Ries',NULL),(2,'Bill Gates is a technologist, business leader, and philanthropist. In 1975, he cofounded Microsoft with his childhood friend Paul Allen; today he and his wife, Melinda, are cochairs of the Bill & Melinda Gates Foundation. He also launched Breakthrough Energy, an effort to commercialize clean energy and other climate-related technologies.','Bill','Gates',NULL),(3,'Colin Bryar joined Amazon in 1998 -- four years after its founding -- and spent the next 12 years as part of Amazons senior leadership team as Amazon grew from a domestic (US-only) seller of books to a global, multi-dimensional powerhouse and innovator. Colin served as a Vice President at Amazon, and for two of his years he was Chief of Staff to Jeff Bezos, AKA Jeffs shadow, during which he spent each day attending meetings, traveling with, and discussing business and life with Jeff. After Amazon, he and his family relocated to Singapore for two years where Colin served as Chief Operating Officer of e-commerce company RedMart, which was subsequently sold to Alibaba. Colin is co-founder of Working Backwards LLC where he coaches executives at both large and early-stage companies on how to implement the management practices developed at Amazon. Colin holds Bachelor of Science and Master of Engineering degrees in Operations Research from Cornell University.','Colin','Bryar',NULL),(4,'Kevin Carr is a strength and conditioning coach and manager at Mike Boyle Strength and Conditioning (MBSC) as well a massage therapist and cofounder of Movement as Medicine, a massage and movement therapy clinic in Woburn, Massachusetts. He is the creator of the Certified Functional Strength Coach certification. He has a bachelors degree in kinesiology from the University of Massachusetts at Amherst and a license in massage therapy from Cortiva Institute in Watertown, Maryland.\nCarr amassed a wealth of experience in the field of sport performance and personal training while working at MBSC and has traveled all over the world to educate thousands of coaches and therapists about the MBSC coaching system. He has coached everyone from U.S. Olympians looking for a competitive edge to the average person looking to shed some pounds, move better, and improve their','Kevin','Carr',NULL),(5,'I work as a freelance writer and editor. Ive been doing it for 18 years - not always freelance - and have launched, managed and edited highly successful magazines and books and written about subjects ranging from wind farms to wolves. My specialist subjects are the environment and travel.','Kath','Stathers',NULL),(6,'William W. Forgey, M.D. is an avid humanitarian, adventurer, physician and educator, Dr. Forgey is the founding advisor of the nonprofit Medical Student Missions and has lead over 40 medical service trips to Haiti since 2010.\nA member of the Board of Trustees of the International Association for Medical Assistance to Travelers (IAMAT), Dr Forgey is a lecturer on medical care in high risk recreation at several universities, and a leader of many expeditions into Northern Canada, both summer and winter. A former Captain, Infantry, in the US Army, he had over 30 months active duty in Vietnam prior to leaving the service and attending medical school at Indiana University. He was awarded the Bronze Star and Army Commendation Medal for his service in Vietnam. He worked 6 years full time as an Emergency Room physician and director of the Ross Clinic Emergency Services in Merrillville, Indiana, before starting his practice of family medicine. Dr Forgey has served as a Scoutmaster for three BSA troops and as a Medical Explorer Post and High Adventure Explorer Post Advisor. He completed his BSA Woodbadge training in 1969. He was named as one of Americas 20 greatest living explorers by the Explorers Club in New York City and, as such, had a subcamp named for him at the National Boy Scout Jamboree in 2005.','William','Forgey',NULL),(7,'James Nestor is an author and journalist who has written for Outside Magazine, The Atlantic, National Public Radio, The New York Times, Scientific American, Dwell Magazine, The San Francisco Chronicle, and more.\n\nNestors book, Breath: The New Science of a Lost Art, was released through Riverhead/Penguin Random House on May 26, 2020 and was an instant bestseller in the New York Times, Wall Street Journal, and Los Angeles Times, and Sunday London Times. Breath will be translated into more than 30 languages in 2021.\nBreath explores how the human species has lost the ability to breathe properly over the past several hundred thousand years and is now suffering from a laundry list of maladies -- snoring, sleep apnea, asthma, autoimmune disease -- because of it. Nestor travels the world to figure out what went wrong and how to fix it. The answers arent found in pulmonology labs, as we might expect, but in the muddy digs of ancient burial sites, secret Soviet facilities, New Jersey choir schools, and the smoggy streets of Sao Paulo.\nDrawing on thousands of years of medical texts and recent cutting-edge studies in pulmonology, psychology, biochemistry, and human physiology, Breath turns the conventional wisdom of what we thought we knew about our most basic biological function on its head.\nNestors first narrative nonfiction book, DEEP: Freediving, Renegade Science, and What The Ocean Tells Us about Ourselves (Houghton Mifflin Harcourt) was released in the United States and UK in June 2014. DEEP was a BBC Book of the Week, a Finalist for the PEN American Center Best Sports Book of the Year, an Amazon Best Science Book of 2014, BuzzFeed 19 Best Nonfiction Books of 2014, ArtForum Top 10 Book of 2014, New York Times Book Review Editors Choice, Scientific American Recommended Read, and more. The book has been translated into German, Chinese, Italian, Polish, and more; the audiobook, read by Nestor, was released by Audible in June 2016.\nNestor has presented his research at Stanford Medical School, the United Nations, UBS, Global Classroom (World Health Organization+UNICEF), as well as more than 40 radio and television shows, including Fresh Air with Terry Gross, the Joe Rogan Show, BulletProof, ABCs Nightline, CBS Morning News, and dozens of NPR programs.','James','Nestor',NULL),(8,'Kobe Bryant is an Academy Award winner, New York Times best-selling author and CEO of Granity Studios, a multi-media content creation company. He spends every day focused on creating stories that inspire the next generation of athletes to be the best versions of themselves. In a previous life, Kobe was a five-time NBA champion, two-time NBA Finals MVP, NBA MVP, and two-time Olympic gold medalist. He hopes to share what hes learned with young athletes around the world.','Kobe','Bryant',NULL),(9,'John Eisenberg grew up with books in his hands - his first summer job was at his mothers bookstore in his hometown of Dallas, Texas. After graduating from the University of Pennsylvania, he wrote for newspapers for almost three decades, mostly as a sports columnist at The Baltimore Sun covering major events such as the Super Bowl, Final Four, World Series, Kentucky Derby, and soccers World Cup while also paying attention to his hometown teams - the Baltimore Ravens, Baltimore Orioles, and Maryland Terrapins. Along the way he wrote 3,000 columns and won more than 20 awards, including several first-places in the prestigious Associated Press Sports Editors contest.\nHe also has written for Sports Illustrated, Smithsonian Magazine, and Details, and before working in Baltimore. spent five years with the Dallas Times Herald.\nNo matter if he is writing about a famous football coach, a heartbroken jockey, or a pitcher who wins 20 games, John is known for unearthing original stories and bringing them to life with his clear-eyed analysis and lively narrative style. His book topics have included the start of Vince Lombardis dynasty in Green Bay, the history of the Baltimore Orioles, his experience as a young fan of the Dallas Cowboys in the 1960s, the tragic breakdown of the horse Barbaro, and an outrageous North-South horse race that captivated the nation in 1823.\nJohn lives in Baltimore, Maryland.','John','Eisenberg',NULL),(10,'Jen Fisch, creator of the blog Keto In The City, and international best-selling cookbook author, is passionate about offering simple solutions for following the ketogenic lifestyle. She is a single, working mother who has battled autoimmune disorders for 20 years and has turned to the kitchen to find simple, delicious ways to make the ketogenic diet work for her busy lifestyle.','Jen','Fisch',NULL),(11,'Based near St. Louis, Serena Ball, MS, RD is a registered dietitian contributor to FoodNetwork.com where she writes about nutrition trends and develops recipes. She co-created and writes the Healthy Kitchen Hacks column for Food & Nutrition Magazine.\nHer first cookbook, the best-selling The 30-Minute Mediterranean Diet Cookbook: 101 Easy, Flavorful Recipes for Lifelong Health was released in 2018.\nSerena cooks up healthy recipes for her regular TV appearances on The Morning Show on FOX TV2, St. Louis.\nShe blogs at TeaspoonOfSpice.com about delicious recipes and time-saving Healthy Kitchen Hacks with fellow dietitian Deanna Segrave-Daly. For her blog, Serena also creates hands-and-pans recipe videos. She produces bi-weekly Teaspoon Of Spice Facebook LIVEs to demonstrate simple and fun ways to put Healthy Kitchen Hacks into practice.\nSerena is co-owner of Teaspoon Communications, a nutrition communication group of culinary-minded registered dietitian nutritionists. She co-created The Recipe ReDux, a health blogger community platform.\nSerenas second cookbook, The Easy Everyday Mediterranean Diet Cookbook: 125 Delicious Recipes from the Healthiest Lifestyle on the Planet, will be available in October 2020.\nSerena is happiest in her bright aqua-blue kitchen developing healthy recipes for her five regular kitchen customers: her four children and husband.','Serena','Ball',NULL),(12,'I began my foray into the fitness and health field in 1985 when I got into cycling, swimming and triathlon. I would get involved in gymnastics my senior year of high school and this led me to UCLA to pursue a degree in Kinesiology (exercise physiology). During that time I became interested in the science of sports performance including nutrition, training, and supplementation. I was really trying to fix myself.\nDuring that time I got involved in the growing sport of inline skating (rollerblading) and raced for many years. Cycling and weight training were always part of my training and have been going on decades now. While I was never accomplished in the weight room (I did one powerlifting meet in my 20s and have some Olympic Lifting Experience) I always loved the iron.\nIn my 20s, I got involved with Dan Duchaines Bodyopus diet, a cyclical ketogenic diet surrounded by controversy. The Internet was growing and I had been a part of it since 1993 and I started doing more and more writing, culminating eventually in my first book The Ketogenic Diet, A Complete Guide. This was and will always be the textbook on the topic of low-carbohydrate diets and it can be found in libraries and universities in addition to the thousands of copies sold over the years.\nOver the next 10+ years, I would dedicate myself to solving various problems related to diet and fat loss, along with athletic performance. My Guide to Flexible Dieting was the first book to discuss the topic of flexible dieting (from which If It Fits Your Macros, a current bandwagon derives).\nMy Rapid Fat Loss Handbook provides a scientific approach to crash dieting, ensuring maximal nutrition, minimal to no muscle loss and the ability to sustain the loss.\nIve also written books aimed at the more advanced dieter. My Ultimate Diet 2.0 allows already lean dieters to reach the extremes of human leanness while gaining muscle. My Stubborn Fat Solution tackles the issue of stubborn abdominal and hip/thigh fat. That was a 10 year project.\nIve also written about topics related to sports nutrition. My Protein Book is a complete work on the topic of protein nutrition for athletes. I also wrote a weird little drug booklet titled Bromocriptine that really dealt with bodyweight regulation.\nFor over 20 years Ive dedicated every waking moment to the fitness, health and human performance field. Ive been involved in most sports with my most recent adventure being 5.5 years spent in Salt Lake City Utah attempting to make the US O','Lyle','Mcdonald',NULL),(13,'Renowned worldwide for his playful, innovative storytelling and humorous, distinctive art style, Akira Toriyama burst onto the manga scene in 1980 with the wildly popular Dr. Slump. His hit series Dragon Ball (published in the U.S. as Dragon Ball and Dragon Ball Z) ran from 1984 to 1995 in Shueisha\'s Weekly Shonen Jump magazine. He is also known for his design work on video games such as Dragon Quest, Chrono Trigger, Tobal No. 1 and Blue Dragon. His recent manga works include COWA!, Kajika, Sand Land, Neko Majin, Jaco the Galactic Patrolman and a children\'s book, Toccio the Angel. He lives with his family in Japan.\nToyotarou created the manga adaptation for the Dragon Ball Z anime’s 2015 film, Dragon Ball Z: Resurrection F. He is also the author of the spin-off series Dragon Ball Heroes: Victory Mission, which debuted in V-Jump in Japan in November 2012.','Akira','Toriyama',NULL),(14,'Geoff Johns is an award-winning writer and one of the most popular contemporary comic book writers today. Johns is the author of the New York Times bestselling graphic novels Aquaman: The Trench, Blackest Night, Green Lantern: The Sinestro Corps War, Justice League: Origin, Superman: Brainiac, and Batman: Earth One, which hit #1 on the bestseller list. He is also known for transforming Green Lantern into one of the most critically and commercially successful franchises in comics. Johns was born in Detroit and studied media arts, screenwriting, and film at Michigan State University. After moving to Los Angeles, he became an assistant to Richard Donner, director of Superman: The Movie. He and his mentor Donner later co-wrote Superman: Last Son, featuring the return of General Zod. Johns has written for various other media, including episodes of Smallville, Arrow, and Adult Swim\'s Robot Chicken, for which he was nominated along with his co-writers for an Emmy. Johns was an executive producer on the 2016 film Batman v Superman: Dawn of Justice and co-wrote the 2017 hit film Justice League as well as the upcoming Wonder Woman 1984 film starring Gal Gadot. Johns currently resides in Los Angeles, California.','Geoff','Johns',NULL),(16,'DK was founded in London in 1974 and is now the world leading illustrated reference publisher and a member of the Penguin Random House division of Bertelsmann. DK publishes highly visual, photographic non-fiction for adults and children. DK produces content for consumers in over 100 countries and over 60 languages, with offices in the UK, India, US, Germany, China, Canada, Spain and Australia.\nDK\'s aim is to inspire, educate and entertain readers of all ages, and everything DK publishes, whether print or digital, embodies the unique DK design approach. DK brings unrivaled clarity to a wide range of topics, with a unique combination of words and pictures, put together to spectacular effect. We have a reputation for innovation in design for both print and digital products.\nOur adult range spans travel, including the award-winning DK Eyewitness Travel Guides, history, science, nature, sport, gardening, cookery and parenting. \nDK’s extensive children’s list showcases a fantastic store of information for children, toddlers and babies. DK covers everything from animals and the human body, to homework help and craft activities, together with an impressive list of licensing titles, including the best-selling LEGO books.\nDK acts as the parent company for Alpha Books, publisher of the Idiot\'s Guides series.','DK','Group',NULL),(17,'Dan Slott (born July 3, 1967) is an American comic book writer, known for his work on Marvel Comics books such as The Amazing Spider-Man, as well as She-Hulk, Silver Surfer, The Superior Spider-Man, Tony Stark: Iron Man, The Mighty Avengers, and Fantastic Four. 2018 ended with Slott writing four of the Top 10 selling issues for the entire industry. In January 2020, when Diamond Comics released its list of the Top 100 Best-Selling Comics of the Decade, nine of the titles were ones written by Slott.','Dan','Slott','https://upload.wikimedia.org/wikipedia/commons/8/89/10.12.12DanSlottByLuigiNovi1.jpg'),(19,'Stephen King is the author of more than sixty books, all of them worldwide bestsellers. His recent work includes If It Bleeds, The Institute, Elevation, The Outsider, Sleeping Beauties (cowritten with his son Owen King), and the Bill Hodges trilogy: End of Watch, Finders Keepers, and Mr. Mercedes (an Edgar Award winner for Best Novel and an AT&T Audience Network original television series). His novel 11/22/63 was named a top ten book of 2011 by The New York Times Book Review and won the Los Angeles Times Book Prize for Mystery/Thriller. His epic works The Dark Tower, It, Pet Sematary, and Doctor Sleep are the basis for major motion pictures, with It now the highest-grossing horror film of all time. He is the recipient of the 2020 Audio Publishers Association Lifetime Achievement Award, the 2018 PEN America Literary Service Award, the 2014 National Medal of Arts, and the 2003 National Book Foundation Medal for Distinguished Contribution to American Letters. He lives in Bangor, Maine, with his wife, novelist Tabitha King.','Stephen','king',NULL),(20,'Madeline Miller was born in Boston and grew up in New York City and Philadelphia. She attended Brown University, where she earned her BA and MA in Classics. For the last ten years she has been teaching and tutoring Latin, Greek and Shakespeare to high school students. She also studied in the Dramaturgy department at Yale School of Drama, where she focused on the adaptation of classical texts to modern forms. She currently lives near Philadelphia, PA. The Song of Achilles is her first novel. Her second novel, Circe, will be published in April 2018. Visit her website at: www.madelinemiller.com','Madeline','Miller',NULL),(21,'Juan Díaz Canales is a Spanish animation artist and comic book author. He is best known as the cocreator of the Blacksad series with artist Juanjo Guarnido. Originally published in French and Spanish, the series has been translated into many languages and won two Eisner Awards and an Angoulême Prize.\nAt an early age, Juan Díaz Canales became interested in comics and their creation, which progressed and broadened out to include animated films. At the age of 18, he entered a school for animation. In 1996 he founded, together with three other artists, a company called Tridente Animation. Through this, he has worked with European and American companies, providing plots and scripts for comics and animation films, as well as directing animated television series and animation movies.\nDuring this period he met Juanjo Guarnido, with whom Canales decided to create comics based around a private investigator, Blacksad. After contacting several editors, Guarnido and Canales finally signed on with French publisher Dargaud, and in November 2000, Somewhere Within the Shadows was published. It was a great success with both critics and the public, and was awarded the Prix de la Découverte at the Sierre International Comics Festival and the Avenir\" Prize at the Lys-lez-Lannoy Festival','Juan','Canales',' in Switzerland and France respectively. In March 2003 the second album Arctic-Nation'),(22,'Barack Hussein Obama II (born August 4, 1961) is an American politician who served as the 44th president of the United States from 2009 to 2017. A member of the Democratic Party, Obama was the first African-American president of the United States.','Barack','Obama','https://upload.wikimedia.org/wikipedia/commons/8/8d/President_Barack_Obama.jpg'),(23,'Rob McEntarffer taught AP Psychology at Lincoln Southeast High School in Lincoln, NE for over 13 years and Introductory Psychology at Nebraska Wesleyan University for over 7 years. He earned a B.S. in teaching of psychology at the University of Nebraska, a master\'s degree in educational psychology, and a Ph.D. in education. He has extensive experience in scoring the Advanced Placement Psychology free-response questions, having served as a Reader, Table Leader, and, as the high school Question Leader','Rob','McEntarffer',NULL),(24,'Ron M. Walls, M.D., FAAEM, FRCPC, is the Chief Operating Officer of Mass General Brigham and the Neskey Family Professor of Emergency Medicine at Harvard Medical School. He oversees all clinical services across the Mass General Brigham system, including the academic medical centers, specialty hospitals, community hospitals and ambulatory services. Major areas of focus are integration of clinical services; collaborations between and among clinical departments; enhancing enterprise services, including radiology, pathology, emergency medicine and anesthesiology; system-wide service line development; and specialty hospitals and services.','Ron','Walls',NULL),(25,'Kristin Hannah is the award-winning and bestselling author of more than 20 novels including the international blockbuster, The Nightingale, which was named Goodreads Best Historical fiction novel for 2015 and won the coveted People\'s Choice award for best fiction in the same year. It was also named a Best Book of the Year by Amazon, iTunes, Buzzfeed, the Wall Street Journal, Paste, and The Week. In 2018, The Great Alone became an instant New York Times #1 bestseller and was named the Best Historical Novel of the Year by Goodreads.','Kristin','Hannah',NULL),(26,'John Winters is an author, philosopher ,blog artist and entrepreneur.He travels the world writing, exploring, observing and sharing his knowledge and life experiences.He lived and worked in various countries including the United Kingdom,Japan,South Korea,France,UAE,South Africa, Thailand ,Hong Kong,Singapore and China.','John','Winters',NULL),(27,'Robert M. Sapolsky is the author of several works of nonfiction, including A Primate\'s Memoir, The Trouble with Testosterone, and Why Zebras Don\'t Get Ulcers. He is a professor of biology and neurology at Stanford University and the recipient of a MacArthur Foundation genius grant. He lives in San Francisco.','Robert','Sapolski',NULL),(28,'Long before his name became synonymous with the modern legal thriller, he was working 60-70 hours a week at a small Southaven, Mississippi, law practice, squeezing in time before going to the office and during courtroom recesses to work on his hobby—writing his first novel.','John','Grisham',NULL),(29,'A #1 New York Times bestselling author of eight novels, including The Exiles, Orphan Train, and A Piece of the World, Christina Baker Kline is published in 40 countries. Her novels have received the New England Prize for Fiction, the Maine Literary Award, and a Barnes & Noble Discover Award, among other prizes, and have been chosen by hundreds of communities, universities and schools as “One Book, One Read” selections. Her essays, articles, and reviews have appeared in publications such as the New York Times and the NYT Book Review, the Boston Globe, the San Francisco Chronicle, LitHub, Psychology Today, Poets & Writers, and Salon. Born in England and raised in the American South and Maine, Kline is a graduate of Yale (B.A.), Cambridge (M.A.) and the University of Virginia (M.F.A.), where she was a Hoyns Fellow in Fiction Writing.','Christine','Kline',NULL),(30,'Stephen William Hawking CH CBE FRS FRSA (8 January 1942 – 14 March 2018) was an English theoretical physicist, cosmologist, and author who, at the time of his death, was director of research at the Centre for Theoretical Cosmology at the University of Cambridge.[17][18][7] Between 1979 and 2009, he was the Lucasian Professor of Mathematics at the University of Cambridge.','Stephen','Hawking',NULL),(31,'Jon Christopher Aster is an American pathologist who researches the role of the notch signaling pathway in leukemia. He is the Michael Gimbrone Professor of Pathology at Harvard Medical School. He has been a co-editor of the Annual Review of Pathology: Mechanisms of Disease since 2016.','Jon','Aster',NULL),(32,'Frank C. Mooren, MD, is associate professor at the Institute of Sports Medicine at University Hospital Muenster in Germany, where he leads a molecular exercise physiology research group. Drawing from an academic background in medicine and chemistry, he worked as a researcher at the Max Planck Institute for Sytemphysiology in Dortmund. He has also been a consultant in internal medicine and sports medicine at the University Hospital Muenster.','Frank','Mooren',NULL),(33,'Steven Weinberg (/ˈwaɪnbɜːrɡ/; May 3, 1933 – July 23, 2021) was an American theoretical physicist and Nobel laureate in physics for his contributions with Abdus Salam and Sheldon Glashow to the unification of the weak force and electromagnetic interaction between elementary particles.','Steven','Weinberg',NULL),(34,'Alan Harvey Guth (/ɡuːθ/; born February 27, 1947) is an American theoretical physicist and cosmologist. Guth has researched elementary particle theory (and how particle theory is applicable to the early universe). He is Victor Weisskopf Professor of Physics at the Massachusetts Institute of Technology. Along with Alexei Starobinsky and Andrei Linde, he won the 2014 Kavli Prize \"for pioneering the theory of cosmic inflation.\"[1]','Alan','Guth',NULL),(35,'Paul Kleinman grew up in White Plains, New York, and currently resides in New York City. He graduated from the University of Wisconsin in 2009 with degrees in Art and Communication Arts: Radio, Television and Film. Out of fear that his author bio is painfully boring, he began making things up. He is an astronaut. He trains cobras. He is very tall and in no way sickly pale. He is also a humor writer. That one is true. Maybe.','Paul','Kleinman',NULL),(36,'\nDaniel Kahneman (Hebrew: דניאל כהנמן‎, born March 5, 1934) is an Israeli-American psychologist notable for his work on the psychology of judgment and decision-making, as well as behavioral economics, for which he was awarded the 2002 Nobel Memorial Prize in Economic Sciences (shared with Vernon L. Smith). His empirical findings challenge the assumption of human rationality prevailing in modern economic theory. With Amos Tversky and others, Kahneman established a cognitive basis for common human errors that arise from heuristics and biases (Kahneman & Tversky, 1973; Kahneman, Slovic & Tversky, 1982; Tversky & Kahneman, 1974), and developed prospect theory (Kahneman & Tversky, 1979).\nDaniel Kahneman (Hebrew: דניאל כהנמן‎, born March 5, 1934) is an Israeli-American psychologist notable for his work on the psychology of judgment and decision-making, as well as behavioral economics, for which he was awarded the 2002 Nobel Memorial Prize in Economic Sciences (shared with Vernon L. Smith). His empirical findings challenge the assumption of human rationality prevailing in modern economic theory. With Amos Tversky and others, Kahneman established a cognitive basis for common human errors that arise from heuristics and biases (Kahneman & Tversky, 1973; Kahneman, Slovic & Tversky, 1982; Tversky & Kahneman, 1974), and developed prospect theory (Kahneman & Tversky, 1979).','Daniel','Kahneman',NULL),(37,'David Goggins is a retired Navy SEAL and the only member of the U.S. Armed Forces ever to complete SEAL training, U.S. Army Ranger School, and Air Force Tactical Air Controller training. Goggins has competed in more than sixty ultra-marathons, triathlons, and ultra-triathlons, setting new course records and regularly placing in the top five. A former Guinness World Record holder for completing 4,030 pull-ups in seventeen hours, he\'s a much-sought-after public speaker who\'s shared his story with the staffs of Fortune 500 companies, professional sports teams, and hundreds of thousands of students across the country.','David','Goggins',NULL),(38,'\nBlake Bailey is the author of acclaimed biographies of John Cheever, Richard Yates, and Charles Jackson, and his biography of Philip Roth will be published in 2021. He is the recipient of a Guggenheim Fellowship and an Award in Literature from the American Academy of Arts and Letters, a winner of the National Book Critics Circle Award and Francis Parkman Prize from the Society of American Historians, and a finalist for the Pulitzer and James Tait Black Prizes. His most recent book, \"The Splendid Things We Planned,\" was a finalist for the National Book Critics Circle Award in Autobiography. He lives in Virginia with his wife and daughter.\n\n\nBlake Bailey is the author of acclaimed biographies of John Cheever, Richard Yates, and Charles Jackson, and his biography of Philip Roth will be published in 2021. He is the recipient of a Guggenheim Fellowship and an Award in Literature from the American Academy of Arts and Letters, a winner of the National Book Critics Circle Award and Francis Parkman Prize from the Society of American Historians, and a finalist for the Pulitzer and James Tait Black Prizes. His most recent book, \"The Splendid Things We Planned,\" was a finalist for the National Book Critics Circle Award in Autobiography. He lives in Virginia with his wife and daughter.\n\n','Blake','Bailey',NULL),(39,'\nPhilip Carlo was the author of The Ice Man: Confessions of a Mafia Contract Killer, his New York Times bestselling book about Richard “Ice Man” Kuklinski, murderer of 200 people and a favorite among all seven of the East Coast crime families. He was also the author of Gaspipe, The Butcher, and The Night Stalker, which chronicles the brutal career of serial killer Richard Ramirez. Carlo grew up in Bensonhurst, Brooklyn, amidst the world’s highest concentration of Mafia members. When he was 16, Carlo was shot in the head in a gang war, and while recuperating, he read voraciously, discovering the magic of books for the first time. His intimate knowledge of Mafia culture—their walk and their talk—helped Carlo become a successful crime writer. He died in 2010 from ALS.\nPhilip Carlo was the author of The Ice Man: Confessions of a Mafia Contract Killer, his New York Times bestselling book about Richard “Ice Man” Kuklinski, murderer of 200 people and a favorite among all seven of the East Coast crime families. He was also the author of Gaspipe, The Butcher, and The Night Stalker, which chronicles the brutal career of serial killer Richard Ramirez. Carlo grew up in Bensonhurst, Brooklyn, amidst the world’s highest concentration of Mafia members. When he was 16, Carlo was shot in the head in a gang war, and while recuperating, he read voraciously, discovering the magic of books for the first time. His intimate knowledge of Mafia culture—their walk and their talk—helped Carlo become a successful crime writer. He died in 2010 from ALS.','Philip','Carlo',NULL),(40,'Sharon Vonne Stone (born March 10, 1958) is an American actress. Known for primarily playing femme fatales and women of mystery on film and television, she became one of the most popular sex symbols of the 1990s. She is the recipient of various accolades, including a Primetime Emmy Award, a Golden Globe Award and a nomination for an Academy Award. She received a star on the Hollywood Walk of Fame in 1995 and was named Officer of the Order of Arts and Letters in France in 2005 (Commander in 2021).','Sharon','Stone',NULL),(41,'Gary Chapman—author, speaker, and counselor—has a passion for people and for helping them form lasting relationships. He is the bestselling author of The 5 Love Languages® series and the director of Marriage and Family Life Consultants, Inc. Gary Travels the world presenting seminars, and his radio programs air on more than 400 stations.','Gary','Chapman',NULL),(42,'\nViktor E. Frankl was professor of neurology and psychiatry at the University of Vienna Medical School until his death in 1997. He was the founder of what has come to be called the Third Viennese School of Psychotherapy (after Freud\'s psychoanalysis and Adler\'s individual psychology)—the school of logotherapy.','Viktor','Frankl',NULL);
/*!40000 ALTER TABLE `author` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `book`
--

DROP TABLE IF EXISTS `book`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `book` (
  `bookid` int NOT NULL AUTO_INCREMENT,
  `description` varchar(3000) NOT NULL,
  `title` varchar(200) NOT NULL,
  `upcoming` smallint DEFAULT NULL,
  PRIMARY KEY (`bookid`)
) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `book`
--

LOCK TABLES `book` WRITE;
/*!40000 ALTER TABLE `book` DISABLE KEYS */;
INSERT INTO `book` VALUES (1,'In this urgent, authoritative book, Bill Gates sets out a wide-ranging, practical—and accessible—plan for how the world can get to zero greenhouse gas emissions in time to avoid a climate catastrophe.Bill Gates has spent a decade investigating the causes and effects of climate change. With the help of experts in the fields of physics, chemistry, biology, engineering, political science, and finance, he has focused on what must be done in order to stop the planet slide to certain environmental disaster. In this book, he not only explains why we need  to work toward net-zero emissions of greenhouse gases, but also details what we need to do to achieve this profoundly important goal.He gives us a clear-eyed description of the challenges we face. Drawing on his understanding of innovation and what it takes to get new ideas into the market, he describes the areas in which technology is already helping to reduce emissions, where and how the current technology can be made to function more effectively, where breakthrough technologies are needed, and who is working on these essential innovations. Finally, he lays out a concrete, practical plan for achieving the goal of zero emissions—suggesting not only policies that governments should adopt, but what we as individuals can do to keep our government, our employers, and ourselves accountable in this crucial enterprise.As Bill Gates makes clear, achieving zero emissions will not be simple or easy to do, but if we follow the plan he sets out here, it is a goal firmly within our reach.','How to Avoid a climate Disaster',NULL),(2,'Working Backwards is an insiders breakdown of Amazons approach to culture, leadership, and best practices from two long-time, top-level Amazon executives.\nColin started at Amazon in 1998; Bill joined in 1999. In Working Backwards, these two long-serving Amazon executives reveal and codify the principles and practices that drive the success of one\n of the most extraordinary companies the world has ever known. With twenty-seven years of Amazon experience between them, much of it in the early aughts—a period of unmatched innovation that brought\n products and services including Kindle, Amazon Prime, Amazon Studios, and Amazon Web Services to life—Bryar and Carr offer unprecedented access to the Amazon way as it was refined, articulated,\n and proven to be repeatable, scalable, and adaptable.With keen analysis and practical steps for applying it at your own company—no matter the size—the authors illuminate how Amazon’s fourteen leadership principles \n inform decision-making at all levels and reveal how the company’s culture has been defined by four characteristics: customer obsession, long-term thinking, eagerness to invent, and operational excellence. Bryar and Carr\n explain the set of ground-level practices that ensure these are translated into action and flow through all aspects of the business.\nWorking Backwards is a practical guidebook and a corporate narrative, filled with the authors’ in-the-room recollections of what “Being Amazonian” is like and how it has affected their \npersonal and professional lives. They demonstrate that success on Amazon’s scale is not achieved by the genius of any single leader, but rather through commitment to and execution of a set\n of well-defined, rigorously-executed principles and practices—shared here for the very first time.','Working Backwards',0),(3,'The term “functional training” has been associated with a fair amount of controversy ever since it became part of the fitness training vernacular more than a decade ago. In Functional Training Anatomy, noted strength and conditioning specialists Kevin Carr and Mary Kate Feit cut through the clutter and misconceptions about functional training and cover all aspects of how to build a purposeful, effective, and efficient program that provides the strength, stability, and mobility you need to support your body in life and in sports.Beginning with a clear definition of what functional training entails, you will learn about the importance of mobility training and its impact on movement quality, performance, and injury reduction. Use the warm-up activities to prepare for high-intensity activities. Use the medicine ball and plyometric exercises to learn to produce and absorb force. Develop power with Olympic lifts, kettlebell swings, and jumping exercises. Improve strength in the upper body, lower body, and core with hip-dominant, knee-dominant, pushing, pulling, and core exercises. See the inner workings of each of the exercises with superb full-color illustrations that show the primary and secondary muscles and connective tissue being used. The detailed instructions for these multiplanar and unilateral exercises ensure you execute each one correctly and safely. The Functional Focus element shows how the exercises translate to specific activities, whether that be an explosive athletic move or simply moving a box.Functional Training Anatomy incorporates traditional and nontraditional exercises and mobility drills that will help you increase functional strength and reduce injury so your body is prepared to support the demands of athletic performance and daily living.','Functional Training Anatomy',NULL),(4,'With 1,000 adventures for all ages, it’s never too soon or too late to begin the things you’ve only dreamed of doing.\n We all have things we’d like to do—one day—but work, family, school, money, and responsibilities get in the way. This invaluable guide to fun, fantastic, and life-affirming activities \n features an eclectic range of ideas such as self-improvement, sports-related endeavors, natural wonders, cultural experiences, culinary delights, and more. From glassblowing in the Czech\n Republic to swimming with dolphins in New Zealand, The Bucket List is the perfect gift for the passionate traveler—an around-the-world, continent-by-continent listing of beaches, museums, monuments,\n islands, inns, restaurants, mountains, and more.\n Each activity is location-specific and as geographically unique as bird-watching in Kenya or driving through clouds in Sri Lanka, as well as other to-dos that can be done anywhere, \n such as sketching a sunset behind an architectural monument. In addition to classic outdoor pursuits, the book contains advice on how to achieve some of the most popular goals for people\n of all ages: direct a movie, learn to play an instrument, make pottery, protect an endangered species, name a star, try a new cuisine, or learn a new language. Whether you are more active or\n laid-back, serious-minded or lighthearted, you are bound to discover new, stimulating activities.','The Bucket List',0),(5,'The basis of adequate prepping is being prepared for both common and dire events that may occur under the worst of all possible circumstances. These circumstances might include the breakdown in normal emergency support services (such as calling 911), the lack of an ability to obtain additional supplies, and the probability that you will not be able to rely on anyone but members of your immediate group or yourself.Prepping requires forethought with regard to food, water supplies, power, and protection – all areas of significant technical preparation. Self-reliant medical  care is no exception.This book provides the basis of prevention, identification, and long-term management of survivable medical conditions and can be performed with minimal training.  It helps you identify sources of materials you will need and should stock-pile, it discusses storage issues, and directs you to sources for more complex procedures that require advanced concepts  of field-expedient techniques used by trained medical persons such as surgeons, anesthesiologists, dentists, or midwifes and obstetricians.','The Preppers Medical Handbook',NULL),(6,'A New York Times Bestseller,A Washington Post Notable Nonfiction Book of 2020,Named a Best Book of 2020 by NPR\n “A fascinating scientific, cultural, spiritual and evolutionary history of the way humans breathe—and how we’ve all been doing it wrong for a long, long time.” —Elizabeth Gilbert,\n author of Big Magic and Eat Pray Love.No matter what you eat, how much you exercise, how skinny or young or wise you are, none of it matters if you’re not breathing properly.\nThere is nothing more essential to our health and well-being than breathing: take air in, let it out, repeat twenty-five thousand times a day. Yet, as a species, humans have lost the ability \nto breathe correctly, with grave consequences.\nJournalist James Nestor travels the world to figure out what went wrong and how to fix it. The answers aren’t found in pulmonology labs, as we might expect, but in the muddy digs of ancient \nburial sites, secret Soviet facilities, New Jersey choir schools, and the smoggy streets of São Paulo. Nestor tracks down men and women exploring the hidden science behind ancient breathing practices \nlike Pranayama, Sudarshan Kriya, and Tummo and teams up with pulmonary tinkerers to scientifically test long-held beliefs about how we breathe.\nModern research is showing us that making even slight adjustments to the way we inhale and exhale can jump-start athletic performance; rejuvenate internal organs; halt snoring, asthma, and autoimmune\n disease; and even straighten scoliotic spines. None of this should be possible, and yet it is.\nDrawing on thousands of years of medical texts and recent cutting-edge studies in pulmonology, psychology, biochemistry, and human physiology, Breath turns the conventional wisdom of what we \nthought we knew about our most basic biological function on its head. You will never breathe the same again','Breath:The new Science of a lost art',0),(7,'The Mamba Mentality: How I Play is Kobe Bryant’s personal perspective of his life and career on the basketball court and his exceptional, insightful style of playing the game―a fitting legacy from \nthe late Los Angeles Laker superstar.In the wake of his retirement from professional basketball, Kobe “The Black Mamba” Bryant decided to share his vast knowledge and understanding of the game \nto take readers on an unprecedented journey to the core of the legendary “Mamba mentality.” Citing an obligation and an opportunity to teach young players, hardcore fans, and devoted students of the \ngame how to play it “the right way,” The Mamba Mentality takes us inside the mind of one of the most intelligent, analytical, and creative basketball players ever.\nIn his own words, Bryant reveals his famously detailed approach and the steps he took to prepare mentally and physically to not just succeed at the game, but to excel. Readers will learn how Bryant\n studied an opponent, how he channeled his passion for the game, how he played through injuries. They’ll also get fascinating granular detail as he breaks down specific plays and match-ups from \n throughout his career.Bryant’s detailed accounts are paired with stunning photographs by the Hall of Fame photographer Andrew D. Bernstein. Bernstein, long the Lakers and NBA official photographer,\n captured Bryant’s very first NBA photo in 1996 and his last in 2016―and hundreds of thousands in between, the record of a unique, twenty-year relationship between one athlete and one photographer.\nThe combination of Bryant’s narrative and Bernstein’s photos make The Mamba Mentality an unprecedented look behind the curtain at the career of one of the world’s most celebrated and fascinating \nathletes.','Kobe Bryant: The Mamba Mentality',0),(8,'The epic tale of the five owners who shepherded the NFL through its tumultuous early decades and built the most popular sport in America.The National Football League is a towering, \ndistinctly American colossus spewing out $14 billion in annual revenue. But it was not always a success. In The League, John Eisenberg focuses on the pioneering sportsmen who kept the league\n alive in the 1920s, 1930s, and 1940s,when its challenges were many and its survival was not guaranteed. At the time, college football, baseball, boxing, and horseracing dominated America  \n sports scene. Art Rooney, George Halas, Tim Mara, George Preston Marshall, and Bert Bell believed in pro football when few others did and ultimately succeeded only because at critical \n junctures each sacrificed the short-term success of his team for the longer-term good of the league.\nAt once a history of a sport and a remarkable story of business ingenuity, The League is an essential read for any fan of our true national pastime.','The League: how five rivals created the NFL and launched the sports empire',0),(9,'The ketogenic diet made fast and easy with 5-ingredient recipes.When life gets busy, sticking to your diet can be hard, but this keto cookbook helps you stay on track with recipes that only require\n a handful of ingredients to create a complete and satisfying meal. It’s your guide to turning everyday, easy-to-find foods into keto-friendly meals that are full of the healthy fats your body needs\n to thrive but fast enough to throw together even on the most hectic days.This ketogenic cookbook features:\n\nThe basics of keto―Get an overview of the ketogenic diet so you’ll understand what makes these recipes keto, and learn how to count macros and interpret nutritional information.\nQuick meals―Recipes require only 5 main ingredients, not including basic kitchen staples like salt and pepper, and most can be made in less than 30 minutes or in just one pot or pan.\nCustomizable options―Use the quick tips for swapping out ingredients to adapt these dishes to your own tastes and health needs.\nMake the ketogenic diet work for you, with a collection of simple recipes you can always find time for.','The easy 5-ingredient ketogenic book',0),(10,'Fit the Mediterranean diet into your busy life―101 yummy, speedy recipes..Discover just how fast and simple it can be to adopt a tasty and healthy diet that’s built on a foundation of fresh veggies\n and seafood. The 30-Minute Mediterranean Diet Cookbook offers more than a set of recipes; it shows you how to live a Mediterranean lifestyle with meals that take a half-hour or less to make.\nFrom avocado toast to vanilla affogato, this cookbook explains what to eat, why, and how it fits within a low-carb, high-fat diet. These heart-healthy recipes also combat chronic disease and cater\n to allergy restrictions so you can share mouthwatering meals with the ones you love..This fundamental Mediterranean diet guide includes:Mediterranean 101―Discover the history, how-tos,\n and health benefits of the Mediterranean way of eating. Flavor, not labor―Whip up classic Mediterranean diet recipes with easy-to-find ingredients, nutritional values, and allergy labels.\nMediterranean marketplace―Fill your kitchen with essentials, including prep and ingredient shortcuts for stress-free cooking.\nThe 30-Minute Mediterranean Diet Cookbook will help you lose weight and live a healthier life―deliciously.','The 30-Minute Mediterranean Diet Cookbook: 101 Easy, Flavorful Recipes for Lifelong Health Paperback',0),(11,'The Women’s Book Volume 1 is the first book to comprehensively examine women’s unique physiology as it pertains to diet, nutrition and fat loss.  It examine the baseline physiological differences \nbetween women and men (for whom most advice has traditionally been geared) along with all aspects of basic nutrition, sports nutrition, fat loss and muscle gain.\nThis will allow women to truly optimize all aspects of their nutrition for optimal health and results .  The impact of the menstrual cycle, hormonal birth control, PCOS, menstrual cycle dysfunction\n and the changes that occur at menopause are all addressed.','The Women Book',0),(12,'In an ideal world, everyone would take a long-term approach to dieting, trying to lose weight/fat gradually. They woyld d make small changes to their eating habits, activity patterns, or both.\n But we dont live in an ideal world there are situations when that simply wont work. Or where people simply arent willing to be patient. Maybe they need to drop weight fast for a special event, \n or they are an athlete or bodybuilder who has to get in shape and is under a time crunch. Maybe they just want the diet over as quickly as possible. Whatever the case, sometimes you need a way\n to drop both weight and fat quickly to reach your goals. That’s where The Rapid Fat Loss Handbook: A Scientific Approach to Crash Dieting comes in.','The Rapid Fat Loss Handbook',0),(13,'Goku’s adventure from the best-selling classic manga Dragon Ball continues in this new series written by Akira Toriyama himself!\nEver since Goku became Earth’s greatest\n hero and gathered the seven Dragon Balls to defeat the evil Boo, his life on Earth has grown a little dull. But new threats loom overhead, and Goku and his friends will have to defend the planet once\n again in this continuation of Akira Toriyama’s best-selling series, Dragon Ball!\nThe Tournament of Power is over and Goku and Vegeta have embarked on a new adventure…in space! The Galactic Patrol \n experiences its worst prison break ever, and the evil Moro—a planet-eating monster—escapes! Moro’s goal is attaining the Dragon Balls of New Namek, and it’s up to Goku, Vegeta and the Galactic Patrol \n to stop him! But how can they do anything when Moro can drain them of their energy just by being near them?!','Dragon Ball Super, Vol.10',0),(14,'Who are the three jokers? Batman doesn\'t understand how or why, but the fact is certain: the man he has spent a \nlifetime chasing isn\'t one man at all. There are three Jokers. Now that he knows the unbelievable truth, Bruce needs\n real answers. Joined by Barbara Gordon and Jason Todd, two former victims of the Joker\'s brutality, the Dark Knight\n is finally on a path to defeat the madman once and for all. Every last one of him.\nGeoff Johns (Doomsday Clock,\n \n Batman: Earth One) and Jason Fabok (Justice League: The Darkseid War) reunite to present one of the most highly \n anticipated comics events in years! Collects Batman: Three Jokers #1-3.','Batman:Three Jokers',0),(16,'The definitive guide to more than 200 heroes, villains, aliens, and droids of the Star Wars galaxy is now packed with new characters from Rogue One: A Star Wars Story, Star Wars: The Last Jedi,\n and Solo: A Star Wars Story.\nWant to know how tall Snoke is? Or learn where Maz Kanata is from? The Star Wars: Character Encyclopedia is full of fun facts and intriguing information that\'s guaranteed\n to enthrall fans of all ages. With plenty of lesser-known details, even die-hard fans will learn new facts about iconic characters.\n© & TM 2019 LUCASFILM LTD.','Star wars Character Encyclopedia, New Edition',0),(17,'Not a dream, not an imaginary story, not an elseworld. This is Flash Fact: When Barry Allen wakes at his desk, he discovers the world has changed. Family is alive, loved ones are strangers,\n and close friends are different, gone or worse. It\'s a world on the brink of a cataclysmic war—but where are Earth\'s Greatest Heroes to stop it? It\'s a place where America\'s last hope is Cyborg,\n who hopes to gather the forces of The Outsider, The Secret 7, Shazam!, Citizen Cold and other new and familiar-yetaltered faces! It\'s a world that could be running out of time, if The Flash can\'t \n find the villain who altered the time line!','Absolute Flashpoint',0),(18,'Collects Amazing Spider-Man #682-687, Spider-Man: Ends of Earth #1 & Avenging Spider-Man #8. Dr. Octopus holds the entire Earth hostage with his dying breath. The world may be ready to give in to \nhis demands, but Spider-Man and his fellow Avengers sure aren\'t! Spidey and the Avengers face off with the Sinister Six in a globe-hopping showdown of epic proportions.','Spider-Man:Ends of the Earth',0),(20,'Enter once more the world of Roland Deschain—and the world of the Dark Tower...now presented in a stunning graphic novel form that will unlock the doorways to terrifying secrets and bold storytelling\n as part of the dark fantasy masterwork and magnum opus from #1 New York Times bestselling author Stephen King.','Stephen King\'s The Dark Tower: The Drawing of the Three: The Complete Graphic Novel Series',0),(22,'The classic hardboiled noir series featuring beloved anthropomorphic cat detective, John Blacksad, celebrates its twentieth year. Readers will now be able to experience five of Blacksad\'s biggest\n cases in a single comprehensive volume with new sketchbook material never published in English.','Blacksad:The Collected Stories',0),(23,'Since its revolutionary first edition in 1983, Rosens Emergency Medicine set the standard for reliable, accessible, and comprehensive information to guide the clinical practice of emergency medicine.\n  Generations of emergency medicine residents and practitioners have relied on Rosens as the source for current information across the spectrum of emergency medicine practice.. \n  The 9th Edition continues this tradition of excellence, offering the unparalleled clarity and authority you’ve come to expect from the award-winning leader in the field. Throughout the text,\n  content is now more concise, clinically relevant, and accessible than ever before – meeting the needs of todays increasingly busy emergency medicine practitioner.','Rosens Emergency Medicine: Concepts and Clinical Practice: Volume - 1&2, 9e',0),(24,'This classic textbook guides students through the challenges and excitement of the rapidly changing field of neuroscience. Accessible for both medical students and undergraduate neuroscience students, the 5th edition has been updated throughout to reflect the latest developments.','Neuroscience, Fifth Edition with Neurons In Action 2',0),(25,'The definitive guide to internal medicine is more essential than ever with the latest in disease mechanisms, updated clinical trial results and recommended guidelines, state of the art radiographic images, therapeutic approaches and specific treatments, hundreds of demonstrative full color drawings, and practical clinical decision trees and algorithms.','Harrison\'s Principles of Internal Medicine, Twentieth Edition (Vol.1 & Vol.2)',0),(26,'Readable and highly illustrated, Robbins and Cotran Pathologic Basis of Disease, 10th Edition presents an in-depth, state-of-the-art overview of human diseases and their cellular and molecular basis. This best-selling text delivers the latest, most essential pathology knowledge in a readable, interesting manner, ensuring optimal understanding of the latest basic science and clinical content. More than 1,000 high-quality photographs and full-color illustrations highlight new information in molecular biology, disease classifications, new drugs and drug therapies, and much more. This superb learning package also includes an enhanced eBook with a full complement of ancillary content on Student Consult.','Robbins & Cotran Pathologic Basis of Disease',0),(27,'Stephen Hawking has earned a reputation as the most brilliant theoretical physicist since Einstein. In this landmark volume, Professor Hawking shares his blazing intellect with nonscientists everywhere, guiding us expertly to confront the supreme questions of the nature of time and the universe. Was there a beginning of time? Will there be an end? Is the universe infinite or does it have boundaries? From Galileo and Newton to modern astrophysics, from the breathtakingly cast to the extraordinarily tiny, Professor Hawking leads us on an exhilarating journey to distant galaxies, black holes, alternate dimensions--as close as man has ever ventured to the mind of God. From the vantage point of the wheelchair from which he has spent more than twenty years trapped by Lou Gehrig\'s disease, Stephen Hawking has transformed our view of the universe. Cogently explained, passionately revealed, A Brief History of Time is the story of the ultimate quest for knowledge: the ongoing search for the tantalizing secrets at the heart of time and space.','A Brief History of Time: From the Big Bang to Black Holes',0),(28,'Our universe has been growing for nearly 14 billion years. But almost everything about it, from the elements that forged stars, planets, and lifeforms, to the fundamental forces of physics, \n  can be traced back to what happened in just the first three minutes of its life. In this book, Nobel Laureate Steven Weinberg describes in wonderful detail what happened in these first three minutes.\n  It is an exhilarating journey that begins with the Planck Epoch - the earliest period of time in the history of the universe - and goes through Einsteins Theory of Relativity, the Hubble Red Shift,\n  and the detection of the Cosmic Microwave Background. These incredible discoveries all form the foundation for what we now understand as the standard model of the origin of the universe. \n  The First Three Minutes examines not only what this model looks like, but also tells the exciting story of the bold thinkers who put it together.','The First Three Minutes: A Modern View Of The Origin Of The Universe',0),(29,'This is the compelling, first-hand account of Alan Guth\'s paradigm-breaking discovery of the origins of the universe—and of his dramatic rise from young researcher to physics superstar. Guth\'s startling theory—widely regarded as one of the most important contributions to science during the twentieth century—states that the big bang was set into motion by a period of hyper-rapid “inflation,” lasting only a billion-trillion-billionth of a second. The Inflationary Universe is the passionate story of one leading scientist\'s effort to look behind the cosmic veil and explain how the universe began.','The Inflationary Universe',0),(31,'A hands-on approach to exploring the human mind\nToo often, textbooks turn the noteworthy theories, principles, and experiments of psychology into tedious discourse that even Freud would want to repress. \nPsych 101 cuts out the boring details and statistics, and instead, gives you a lesson in psychology that keeps you engaged - and your synapses firing.\nFrom personality quizzes and the Rorschach Blot Test to B.F. Skinner and the stages of development, this primer for human behavior is packed with hundreds of entertaining\n psychology basics and quizzes you cant get anywhere else.So whether youre looking to unravel the intricacies of the mind, or just want to find out what makes\n your friends tick, Psych 101 has all the answers - even the ones you didnt know you were looking for.','Psych 101: Psychology Facts, Basics, Statistics, Tests, and More! (Adams 101) ',0),(32,'Barron’s AP Psychology is updated for the May 2020 exam and organized according to the new nine units\n of the AP Psychology course. Written by active AP Psychology teachers, this guide has the in-depth content review and practice you need to feel prepared for the exam.\nThe College Board has announced that there are May 2021 test dates available are May 3-7 and May 10-14, 2021. \nPacked with review of the course material, this edition features:Three full-length practice tests in the book\nA review of all AP test topics, including research methods, the biological basis of behavior, and treatment of disorders\nAn abnormal psychology chapter completely overhauled to reflect the latest changes to the DSM-5\nFifteen additional multiple-choice practice questions for each unit with explained answers\nAn analysis of the tests essay section with a sample essay','AP Psychology: With 3 Practice Tests (Barrons Test Prep)',0),(33,'Over two million copies sold\nSelected by the New York Times Book Review as one of the ten best books of 2011\nSelected by The Wall Street Journal as one of the best nonfiction books of 2011\n2013 Presidential Medal of Freedom Recipient\nDaniel Kahnemans work with Amos Tversky is the subject of Michael Lewiss best-selling The Undoing Project: A Friendship That Changed Our Minds\nIn his mega bestseller, Thinking, Fast and Slow, Daniel Kahneman, world-famous psychologist and winner of the Nobel Prize in Economics, takes us on a groundbreaking tour \nof the mind and explains the two systems that drive the way we think. System 1 is fast, intuitive, and emotional; System 2 is slower, more deliberative, and more logical. \nThe impact of overconfidence on corporate strategies, the difficulties of predicting what will make us happy in the future, the profound effect of cognitive biases on everything from playing the stock market to planning our next vacation―each of these can be understood only by knowing how the two systems shape our judgments and decisions.\nEngaging the reader in a lively conversation about how we think, Kahneman reveals where we can and cannot trust our intuitions and how we can tap into the benefits \nof slow thinking. He offers practical and enlightening insights into how choices are made in both our business and our personal lives―and how we can use different\n techniques to guard against the mental glitches that often get us into trouble. Topping bestseller lists for almost ten years, Thinking, Fast and Slow is a contemporary\n classic, an essential book that has changed the lives of millions of readers.','Thinking, Fast and Slow',0),(34,'If you are reading these words right now then it means you are not comfortable\n with your current life situation. Maybe you feel stuck or feel like you are not in control of your life? \nThe good news is you made the right choice to start reading this book. If you want to change the path you are on right now then this book will guide you to a \nnew way of life. Self - Discipline is the key to everything.\nThis is not just another generic book on Self Discipline. In this book you will learn about certain fundamental principles of Self - Discipline. But you will also \nlearn about things that you didnt think were related to Self- Discipline.The truth is that if you want lasting transformation that will shift your life in a new direction \nthen you need to change in all areas of life.This book will change your way of thinking about yourself and the way you live your life. It will give you the tools\n to look at yourself and the world in a new way.','Self-Discipline: How To Build Mental Toughness And Focus To Achieve Your Goals',0),(35,'From the celebrated neurobiologist and primatologist, a landmark, genre-defining examination of human behavior, both good and bad, and an answer to the question: Why do we do the things we do?\n\nSapolskys storytelling concept is delightful but it also has a powerful intrinsic logic: he starts by looking at the factors that bear on a persons reaction in the precise \nmoment a behavior occurs, and then hops back in time from there, in stages, ultimately ending up at the deep history of our species and its evolutionary legacy.\n And so the first category of explanation is the neurobiological one. A behavior occurs--whether an example of humans at our best, worst, or somewhere in between.\n What went on in a persons brain a second before the behavior happened? Then Sapolsky pulls out to a slightly larger field of vision, a little earlier in time: What sight, \n sound, or smell caused the nervous system to produce that behavior? And then, what hormones acted hours to days earlier to change how responsive that individual is to the \n stimuli that triggered the nervous system? By now he has increased our field of vision so that we are thinking about neurobiology and the sensory world of our environment \n and endocrinology in trying to explain what happened.','Behave: The Biology of Humans at Our Best and Worst',0),(36,'A #1 New York Times bestseller, Wall Street Journal Best Book of the Year, and soon to be a major motion picture, this unforgettable \nnovel of love and strength in the face of war has enthralled a generation.France, 1939 - In the quiet village of Carriveau, Vianne Mauriac says goodbye to her husband,\n Antoine, as he heads for the Front. She doesnt believe that the Nazis will invade France … but invade they do, in droves of marching soldiers, in caravans of trucks and\n tanks, in planes that fill the skies and drop bombs upon the innocent. When a German captain requisitions Viannes home, she and her daughter must live with the enemy or \n lose everything. Without food or money or hope, as danger escalates all around them, she is forced to make one impossible choice after another to keep her family alive.\nViannes sister, Isabelle, is a rebellious eighteen-year-old girl, searching for purpose with all the reckless passion of youth. While thousands of Parisians march into the\n unknown terrors of war, she meets Gäetan, a partisan who believes the French can fight the Nazis from within France, and she falls in love as only the young can … completely. But when he betrays her, Isabelle joins the Resistance and never looks back, risking her life time and again to save others.\nWith courage, grace, and powerful insight, bestselling author Kristin Hannah captures the epic panorama of World War II and illuminates an intimate part of history seldom \nseen: the womens war. The Nightingale tells the stories of two sisters, separated by years and experience, by ideals, passion and circumstance, each embarking on \nher own dangerous path toward survival, love, and freedom in German-occupied, war-torn France―a heartbreakingly beautiful novel that celebrates the resilience of the \nhuman spirit and the durability of women. It is a novel for everyone, a novel for a lifetime.\nGoodreads Best Historical Novel of the Year • Peoples Choice Favorite Fiction Winner • #1 Indie Next Selection • A Buzzfeed and The Week Best Book of the Year','The Nightingale: A Novel',0),(37,'In the summer of his seventeenth year, Sam­uel Sooleymon gets the chance of a lifetime: a trip to the United States with his South Sudanese teammates to play in a showcase basket­ball tournament. He has never been away from home, nor has he ever been on an airplane. The opportunity to be scouted by dozens of college coaches is a dream come true.\n     Samuel is an amazing athlete, with speed, quick­ness, and an astonishing vertical leap. The rest of his game, though, needs work, and the American coaches are less than impressed.\n     During the tournament, Samuel receives dev­astating news from home: A civil war is raging across South Sudan, and rebel troops have ran­sacked his village. His father is dead, his sister is missing, and his mother and two younger brothers are in a refugee camp.\n     Samuel desperately wants to go home, but it’s just not possible. Partly out of sympathy, the coach of North Carolina Central offers him a scholar­ship. Samuel moves to Durham, enrolls in classes, joins the team, and prepares to sit out his freshman season. There is plenty of more mature talent and he isn’t immediately needed.','Sooley: A Novel',0),(38,'Seduced by her employer’s son, Evangeline, a naïve young governess in early nineteenth-century London, is discharged when her pregnancy is discovered and \nsent to the notorious Newgate Prison. After months in the fetid, overcrowded jail, she learns she is sentenced to “the land beyond the seas,” Van Diemen’s Land, a penal \ncolony in Australia. Though uncertain of what awaits, Evangeline knows one thing: the child she carries will be born on the months-long voyage to this distant land.\nDuring the journey on a repurposed slave ship, the Medea, Evangeline strikes up a friendship with Hazel, a girl little older than her former pupils who was sentenced \nto seven years transport for stealing a silver spoon. Canny where Evangeline is guileless, Hazel—a skilled midwife and herbalist—is soon offering home remedies to both \nprisoners and sailors in return for a variety of favors.Though Australia has been home to Aboriginal people for more than 50,000 years, the British government \nin the 1840s considers its fledgling colony uninhabited and unsettled, and views the natives as an unpleasant nuisance. By the time the Medea arrives, many of them have been forcibly relocated, their land seized by white colonists. One of these relocated people is Mathinna, the orphaned daughter of the Chief of the Lowreenne tribe, who has been adopted by the new governor of Van Diemen’s Land.\n\nIn this gorgeous novel, Christina Baker Kline brilliantly recreates the beginnings of a new society in a beautiful and challenging land, telling the story of Australia from a fresh perspective, through the experiences of Evangeline, Hazel, and Mathinna. While life in Australia is punishing and often brutally unfair, it is also, for some, an opportunity: for redemption, for a new way of life, for unimagined freedom. Told in exquisite detail and incisive prose, The Exiles is a story of grace born from hardship, the unbreakable bonds of female friendships, and the unfettering of legacy.','The Exiles: A Novel ',0),(39,'Publishers Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, \nauthenticity, or access to any online entitlements included with the product.REAL-LIFE CASES SHARPEN YOUR CRITICAL THINKING SKILLS FOR YOUR CLERKSHIP AND THE SHELF EXAM\nCase Files: Family Medicine presents realistic clinical scenarios to enhance and hone your clinical decision-making skills. Sixty high-yield cases illustrate essential\n concepts in patient care. Each case begins with a vignette accompanied by relevant open-ended questions designed to teach diagnostic or therapeutic approaches relevant\n to family medicine. The answers that follow emphasize mechanisms and underlying principles. This sixth edition features a new format with bulleted summaries, shorter\n paragraphs, and clearer headings.Realistic cases are accompanied by questions that encourage you to think through the differential diagnosis and treatment options\nReal-life family medicine cases with high-yield discussions aligned to clerkship guidelines USMLE-style review questions and clinical pearls accompany each case','Case Files Family Medicine 5th edition 5th Edition',0),(40,'The Encyclopedia of Exercise Medicine is intelligently structured, easy accessible and user-friendly:\n A-Z format, clear, concise language and uniform essay structure as well as extensive cross references between keywords and related articles enables efficient searches \n in a user-friendly manner both for experts and newcomers. It is intended to be a comprehensive up-to-date data base on the adaptation of the human body to exercise and \n on the therapeutic use of exercise with up to 2,000 keywords. It covers all aspects within the full range of modern exercise medicine of each particular scientific \n discipline (cancer, parasitology, aging, etc.). This includes information on methodological approaches to measuring the principle components of motor fitness, and practical\n aspects of their enhancement by trainings regimes as well as by nutrition and the application of drugs. Such a wide range of entries, all written by leading experts in their\n respective fields, will therefore address both the basic/clinical scientist as well as the practitioner. Moreover, the Encyclopedia of Exercise Medicine is aimed at people \n in related fields, health care professionals, physiotherapists, trainers, students, informed athletes and interested laypersons. It is available both in print and as a fully\n searchable and hyperlinked electronic online edition.','Encyclopedia of Exercise Medicine in Health and Disease 2012',0),(41,'Discover 80 trail-blazing scientific ideas, which underpin our modern world, giving us everything from antibiotics to gene\n therapy, electricity to space rockets and batteries to smart phones.What is string theory or black holes? And who discovered gravity and radiation? The Science Book presents\n the fascinating story behind these and other of the world’s most important concepts in maths, chemistry, physics and biology in plain English, with easy to grasp “mind maps”\n and eye-catching artworks.Albert Einstein once quoted Isaac Newton: “If I have seen further than others, it is by standing on the shoulders of giants.” Follow context \n panels in The Science Book to trace how one scientist’s ideas informed the next. See, for example, how Alan Turing’s “universal computing machine” in the 1940s led to smart phones, or how Carl Linnaeus’s \n classifications led to Darwin’s theory of evolution, the sequencing of the human genome and lifesaving gene therapies.','The Science Book: Big Ideas Simply Explained',0),(44,'In the stirring, highly anticipated first volume of his presidential memoirs, Barack Obama tells the story of his improbable\n odyssey from young man searching for his identity to leader of the free world, describing in strikingly personal detail both his political education and the landmark moments\n of the first term of his historic presidency—a time of dramatic transformation and turmoil.\nObama takes readers on a compelling journey from his earliest political aspirations to the pivotal Iowa caucus victory that demonstrated the power of grassroots\n activism to the watershed night of November 4, 2008, when he was elected 44th president of the United States, becoming the first African American to hold the nation’s \n highest office.Reflecting on the presidency, he offers a unique and thoughtful exploration of both the awesome reach and the limits of presidential power, \n as well as singular insights into the dynamics of U.S. partisan politics and international diplomacy. Obama brings readers inside the Oval Office and the White House\n Situation Room, and to Moscow, Cairo, Beijing, and points beyond. We are privy to his thoughts as he assembles his cabinet, wrestles with a global financial crisis, \n takes the measure of Vladimir Putin, overcomes seemingly insurmountable odds to secure passage of the Affordable Care Act, clashes with generals about U.S. strategy\n in Afghanistan, tackles Wall Street reform, responds to the devastating Deepwater Horizon blowout, and authorizes Operation Neptune’s Spear, which leads to the death\n of Osama bin Laden.','A Promised Land (Random House Large Print)',1),(45,'For David Goggins, childhood was a nightmare - poverty, prejudice, and physical abuse colored his days and haunted \n his nights. But through self-discipline, mental toughness, and hard work, Goggins transformed himself from a depressed, overweight young man with no future into a US \n Armed Forces icon and one of the worlds top endurance athletes. The only man in history to complete elite training as a Navy SEAL, Army Ranger, and Air Force Tactical Air\n Controller, he went on to set records in numerous endurance events, inspiring Outside magazine to name him The Fittest (Real) Man in America. \nIn Cant Hurt Me, he shares his astonishing life story and reveals that most of us tap into only 40% of our capabilities. Goggins calls this The 40% Rule, and his story\n illuminates a path that anyone can follow to push past pain, demolish fear, and reach their full potential. An annotated edition of Can’t Hurt Me, offering over two hours\n of bonus content featuring deeper insights and never-before-told stories shared by David. Not available in other formats.','Cant Hurt Me: Master Your Mind and Defy the Odds',1),(47,'Appointed by Philip Roth and granted independence and complete access, Blake Bailey spent years poring over Roth’s personal archive, interviewing his friends, lovers, and colleagues, and engaging Roth himself in breathtakingly candid conversations. The result is an indelible portrait of an American master and of the postwar literary scene.\n\nBailey shows how Roth emerged from a lower-middle-class Jewish milieu to achieve the heights of literary fame, how his career was nearly derailed by his catastrophic first marriage, and how he championed the work of dissident novelists behind the Iron Curtain.\n\nBailey examines Roth’s rivalrous friendships with Saul Bellow, John Updike, and William Styron, and reveals the truths of his florid love life, culminating in his almost-twenty-year relationship with actress Claire Bloom, who pilloried Roth in her 1996 memoir, Leaving a Doll’s House.\n\nTracing Roth’s path from realism to farce to metafiction to the tragic masterpieces of the American Trilogy, Bailey explores Roth’s engagement with nearly every aspect of postwar American culture.\n\n100 photographs','Philip Roth: The Biography',1),(48,'“An astonishing portrait of a killer not seen since In Cold Blood.” \n—New York Daily News\n\nA bestselling masterpiece of true crime on par with Helter Skelter, this definitive account of one of America’s most feared and notorious serial killers takes you deep into the psychology of a murderer, his terrifying crimes, and the cult following that is shockingly revealed in this revised and updated edition of a true crime classic.  \n \nDecades after Richard Ramirez left thirteen dead and paralyzed the city of Los Angeles in the 1980s, his name is still synonymous with fear, torture, and sadistic murder. Philip Carlo’s classic The Night Stalker, based on years of meticulous research and extensive interviews with Ramirez, revealed the killer and his horrifying crimes to be even more chilling than anyone could have imagined. From watching his cousin commit murder at age eleven to his nineteen death sentences to the juror who fell in love with him, the story of Ramirez is a bizarre and spellbinding descent into the very heart of human evil.\n\nAfter The Night Stalker was first published, thousands of women from all over the world contacted Carlo, begging to be put in touch with the killer. Carlo interviewed them and presents their disturbing stories in this updated edition along with an exclusive death row interview where the killer himself gives his thoughts on the “Ramirez Groupies”—and what he thinks they really want.','The Night Stalker: The Disturbing Life and Chilling Crimes of Richard Ramirez',1),(49,'Sharon Stone, one of the most renowned actresses in the world, suffered a massive stroke that cost her not only her health, but her career, family, fortune, and global fame. In The Beauty of Living Twice, Stone chronicles her efforts to rebuild her life and writes about her slow road back to wholeness and health. In a business that doesn’t accept failure, in a world where too many voices are silenced, Stone found the power to return, the courage to speak up, and the will to make a difference in the lives of men, women, and children around the globe.\n\nOver the course of these intimate pages, as candid as a personal conversation, Stone talks about her pivotal roles, her life-changing friendships, her worst disappointments, and her greatest accomplishments. She reveals how she went from a childhood of trauma and violence to a career in an industry that in many ways echoed those same assaults, under cover of money and glamour. She describes the strength and meaning she found in her children, and in her humanitarian efforts. And ultimately, she shares how she fought her way back to find not only her truth, but her family’s reconciliation and love.\n\nStone made headlines not just for her beauty and her talent, but for her candor and her refusal to “play nice,” and it’s those same qualities that make this memoir so powerful. The Beauty of Living Twice is a book for the wounded and a book for the survivors; it’s a celebration of women’s strength and resilience, a reckoning, and a call to activism. It is proof that it’s never too late to raise your voice and speak out.','The Beauty of Living Twice',1),(50,'Over 12 million copies sold!\n\nA New York Times bestseller for 10 years running.\n\nFalling in love is easy. Staying in love—that’s the challenge. How can you keep your relationship fresh and growing amid the demands, conflicts, and just plain boredom of everyday life?\n\nIn the #1 New York Times international bestseller The 5 Love Languages, you’ll discover the secret that has transformed millions of relationships worldwide. Whether your relationship is flourishing or failing, Dr. Gary Chapman’s proven approach to showing and receiving love will help you experience deeper and richer levels of intimacy with your partner—starting today.\n\nThe 5 Love Languages is as practical as it is insightful. Updated to reflect the complexities of relationships today, this new edition reveals intrinsic truths and applies relevant, actionable wisdom in ways that work.\n\nIncludes the Couples Personal Profile assessment so you can discover your love language and that of your loved one.','The 5 Love Languages: The Secret to Love that Lasts',1),(52,'A book for finding purpose and strength in times of great despair, the international best-seller is still just as relevant today as when it was first published.\n\n“This is a book I reread a lot . . . it gives me hope . . . it gives me a sense of strength.”\n—Anderson Cooper, Anderson Cooper 360/CNN\n\nThis seminal book, which has been called “one of the outstanding contributions to psychological thought” by Carl Rogers and “one of the great books of our time” by Harold Kushner, has been translated into more than fifty languages and sold over sixteen million copies. “An enduring work of survival literature,” according to the New York Times, Viktor Frankl’s riveting account of his time in the Nazi concentration camps, and his insightful exploration of the human will to find meaning in spite of the worst adversity, has offered solace and guidance to generations of readers since it was first published in 1946. At the heart of Frankl’s theory of logotherapy (from the Greek word for “meaning”) is a conviction that the primary human drive is not pleasure, as Freud maintained, but rather the discovery and pursuit of what the individual finds meaningful. Today, as new generations face new challenges and an ever more complex and uncertain world, Frankl’s classic work continues to inspire us all to find significance in the very act of living, in spite of all obstacles.\n\n\nA must-read companion to this classic work, a new, never-before-published work by Frankl entitled Yes to Life: In Spite of Everything, is now available in English.','Mans Search for Meaning',1),(121,'Brother Against Brother\" One of the most pivotal planets in the Marvel Universe faces imminent destruction. Jennifer Walters, the Sensational SHE-HULK, finally learns her part in this chaos.And in the middle of all of this carnage, two lifelong friends will have a battle to the death – prepare yourself for THE THING versus MISTER FANTASTIC!','Fantastic Four (2018) #42',NULL),(123,'Take a walk down memory lane with SPIDER-MAN scribe DAN SLOTT and SAVAGE AVENGERS illustrator GREG SMALLWOOD, as they unleash a tale of psychological terror against the backdrop of MAXIMUM CARNAGE that will have you seeing red!','Carnage: Black, White & Blood (2021) #3',NULL),(124,'“Family First”! Not a dream. Not a hoax. This is real. Thanks to the knowledge of the Watchers, the lost daughter of Nathaniel Richards has been found. It’s time to finally meet the mysterious sister of Reed Richards. But is it time to welcome her into the family? It’s a day of amazing adventures both in her world, and in the world of the Fantastic Four. Guest-starring Namor, King of Atlantis.','Fantastic Four (2018-) #46',NULL);
/*!40000 ALTER TABLE `book` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bookdetails`
--

DROP TABLE IF EXISTS `bookdetails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bookdetails` (
  `bookdetailsid` int NOT NULL AUTO_INCREMENT,
  `count` int DEFAULT NULL,
  `edition` int DEFAULT NULL,
  `frontcover` varchar(245) DEFAULT NULL,
  `isbn10` varchar(245) DEFAULT NULL,
  `isbn13` varchar(245) DEFAULT NULL,
  `language` varchar(145) DEFAULT NULL,
  `pages` int DEFAULT NULL,
  `price` double DEFAULT NULL,
  `publicationdate` date DEFAULT NULL,
  `publisher` varchar(145) DEFAULT NULL,
  `bookid` int DEFAULT NULL,
  `formatid` int NOT NULL,
  PRIMARY KEY (`bookdetailsid`),
  KEY `FK4gimieuucx7c7n8dbh3lgq2qo` (`bookid`),
  KEY `FK235utlux6fstmsu8a9sc4yx1s` (`formatid`),
  CONSTRAINT `FK235utlux6fstmsu8a9sc4yx1s` FOREIGN KEY (`formatid`) REFERENCES `format` (`formatid`),
  CONSTRAINT `FK4gimieuucx7c7n8dbh3lgq2qo` FOREIGN KEY (`bookid`) REFERENCES `book` (`bookid`)
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bookdetails`
--

LOCK TABLES `bookdetails` WRITE;
/*!40000 ALTER TABLE `bookdetails` DISABLE KEYS */;
INSERT INTO `bookdetails` VALUES (2,4,1,'https://images-na.ssl-images-amazon.com/images/I/717JDjMbtZL.jpg','8726737331','-8726736352','English',272,15.99,'2021-03-22','Knopf',1,1),(3,40,1,'https://images-na.ssl-images-amazon.com/images/I/717JDjMbtZL.jpg','385546130','-385545152','English',272,16.17,'2021-02-16','Knopf',1,2),(4,60,1,'https://images-na.ssl-images-amazon.com/images/I/717JDjMbtZL.jpg',NULL,NULL,'English',256,13.99,'2021-02-16','Penguin',1,4),(5,40,1,'https://images-na.ssl-images-amazon.com/images/I/51X6o6WBRWL._SX327_BO1,204,203,200_.jpg','1529033837','-1529032859','English',304,20.79,'2021-01-01','Mcmillian',2,1),(6,50,1,'https://images-na.ssl-images-amazon.com/images/I/51X6o6WBRWL._SX327_BO1,204,203,200_.jpg','1250267595','-1250266617','English',298,33.99,'2021-01-10','Mcmillian',2,2),(7,60,1,'https://images-na.ssl-images-amazon.com/images/I/51X6o6WBRWL._SX327_BO1,204,203,200_.jpg',NULL,NULL,'English',276,15.61,'2021-01-03','St Martin Press',2,4),(8,40,1,'https://images-na.ssl-images-amazon.com/images/I/51le5ZqnMnL._SX372_BO1,204,203,200_.jpg','1760522716','-1760521738','English',224,41.78,'2018-03-06','Murdoch Books',4,1),(9,50,1,'https://images-na.ssl-images-amazon.com/images/I/51le5ZqnMnL._SX372_BO1,204,203,200_.jpg','789332698','-789331720','English',496,23.7,'2017-04-04','Universe',4,2),(10,50,1,'https://images-na.ssl-images-amazon.com/images/I/41cTLLM1Q4S._SX349_BO1,204,203,200_.jpg','1492599107','-1492598129','English',200,22.76,'2021-04-14','Human Kinetics',3,1),(11,40,1,'https://images-na.ssl-images-amazon.com/images/I/41cTLLM1Q4S._SX349_BO1,204,203,200_.jpg',NULL,NULL,'English',185,19.8,'2021-04-21','Human Kinetics',3,4),(12,40,1,'https://images-na.ssl-images-amazon.com/images/I/41h3QDZipfL._SX331_BO1,204,203,200_.jpg','1493046942','-1493045964','English',196,41.5,'2020-03-04','Lyons Press',5,1),(13,50,1,'https://images-na.ssl-images-amazon.com/images/I/41h3QDZipfL._SX331_BO1,204,203,200_.jpg',NULL,NULL,'English',196,26.99,'2020-04-04','Lyons press',5,4),(14,40,1,'https://images-na.ssl-images-amazon.com/images/I/413cAh3xCfL._SX329_BO1,204,203,200_.jpg','241289084','-241288106','English',187,20.24,'2020-06-18','Penguin Life',6,1),(15,50,1,'https://images-na.ssl-images-amazon.com/images/I/413cAh3xCfL._SX329_BO1,204,203,200_.jpg','735213615','-735212637','English',176,16.75,'2020-05-29','Penguin Life',6,2),(16,60,1,'https://images-na.ssl-images-amazon.com/images/I/413cAh3xCfL._SX329_BO1,204,203,200_.jpg',NULL,NULL,'English',194,15.75,'2020-04-05','Penguin',6,4),(17,40,1,'https://images-na.ssl-images-amazon.com/images/I/51U2Nh1UllL._SX414_BO1,204,203,200_.jpg','374201234','-374200256','English',208,18,'2018-10-23','MCD',7,2),(18,30,1,'https://images-na.ssl-images-amazon.com/images/I/51U2Nh1UllL._SX414_BO1,204,203,200_.jpg',NULL,NULL,'English',288,21.07,'2018-10-10','MCD',7,4),(19,35,1,'https://images-na.ssl-images-amazon.com/images/I/41FE4c1mDWL._SX321_BO1,204,203,200_.jpg','1541618645','-1541617667','English',416,15.29,'2019-10-01','Basic Books',8,1),(20,42,1,'https://images-na.ssl-images-amazon.com/images/I/41FE4c1mDWL._SX321_BO1,204,203,200_.jpg','465048706','-465047728','English',400,35.94,'2019-10-11','Basic Books',8,2),(21,45,1,'https://images-na.ssl-images-amazon.com/images/I/41FE4c1mDWL._SX321_BO1,204,203,200_.jpg',NULL,NULL,'English',295,12.99,'2018-03-03','Basic Books',8,4),(22,46,1,'https://images-na.ssl-images-amazon.com/images/I/518Qo+E7IwL._SX258_BO1,204,203,200_.jpg','1939754445','-1939753467','English',356,8.76,'2018-09-09','Rockridge Press',9,1),(23,50,1,'https://images-na.ssl-images-amazon.com/images/I/518Qo+E7IwL._SX258_BO1,204,203,200_.jpg',NULL,NULL,'English',360,8.38,'2019-03-03','Rockridge Press',9,4),(24,42,1,'https://images-na.ssl-images-amazon.com/images/I/51vaeK2kjZL._SX404_BO1,204,203,200_.jpg','1641520930','-1641519952','English',330,11.78,'2018-10-30','RockRidge Press',10,1),(25,50,1,'https://peoplecertproject.s3.eu-central-1.amazonaws.com/MediterraneanDietFront.jpg',NULL,NULL,'English',313,8.67,'2018-10-23','RockRidge Press',10,4),(26,50,1,'https://images-na.ssl-images-amazon.com/images/I/31tM7p8bBQL._SX389_BO1,204,203,200_.jpg','967145694','-967144716','English',256,295.96,'2014-01-01','Mcdonald',11,1),(27,42,1,'https://images-na.ssl-images-amazon.com/images/I/41nMfWrQjkL._SX434_BO1,204,203,200_.jpg','967145643','-967144665','English',243,138.99,'2005-10-02','Mcdonald',12,2),(28,40,1,'https://images-na.ssl-images-amazon.com/images/I/51KeBfwaenL._SY291_BO1,204,203,200_QL40_FMwebp_.jpg','1974715264','-1974714286','English',189,8.99,'2012-02-12','VIZ MEDIA LLC',13,1),(29,100,1,'https://images-na.ssl-images-amazon.com/images/I/51KeBfwaenL._SY291_BO1,204,203,200_QL40_FMwebp_.jpg',NULL,NULL,'English',189,6.77,'2012-02-12','VIZ MEDIA LLC',13,4),(30,52,1,'https://b.scdn.gr/images/sku_main_images/030221/30221584/20210726145504_batman_three_jokers.jpeg','1779500238','-1779499260','English',190,15.71,'2012-02-11','DC COMICS',14,2),(31,40,1,'https://b.scdn.gr/images/sku_main_images/030221/30221584/20210726145504_batman_three_jokers.jpeg',NULL,NULL,'English',184,18.51,'2012-03-11','DC COMICS',14,4),(34,52,1,'https://d1w7fb2mkkr3kw.cloudfront.net/assets/images/book/lrg/9780/2413/9780241386071.jpg','1465485309','-1465484331','English',213,14.18,'2014-10-10','DK Children',16,2),(35,49,1,'https://d1w7fb2mkkr3kw.cloudfront.net/assets/images/book/lrg/9780/2413/9780241386071.jpg',NULL,NULL,'English',213,8.99,'2014-10-10','DK Children',16,4),(36,40,1,'https://dyn.media.forbiddenplanet.com/qXcumvVwymmU4a1WoXd0oKQgE1c=/trim/fit-in/392x600/filters:format(webp)/https://media.forbiddenplanet.com/products/d4/41/9b9be35ad34df56fc930b0de1446e3c88564.jpg','1779509774','-1779508796','English',512,128.34,'2014-10-10','DC comics',17,2),(37,52,1,'https://kbimages1-a.akamaihd.net/06d3af84-9097-4b50-886b-d2afa0ff3470/1200/1200/False/spider-man-ends-of-the-earth.jpg','785160052','-785159074','English',190,194.06,'2013-01-22','Marvel-US',18,1),(38,54,1,'https://kbimages1-a.akamaihd.net/06d3af84-9097-4b50-886b-d2afa0ff3470/1200/1200/False/spider-man-ends-of-the-earth.jpg','785160051','-785159073','English',190,53.88,'2013-01-22','Marvel-US',18,2),(39,46,1,'https://kbimages1-a.akamaihd.net/06d3af84-9097-4b50-886b-d2afa0ff3470/1200/1200/False/spider-man-ends-of-the-earth.jpg',NULL,NULL,'English',180,20.88,'2013-01-22','Marvel-US',18,4),(41,44,1,'https://images-na.ssl-images-amazon.com/images/I/51lrvWx2y5L._SX218_BO1,204,203,200_QL40_FMwebp_.jpg','1982135468','-1982134490','English',220,104.96,'2004-10-10','Gallery 13',20,1),(44,44,1,'https://images-na.ssl-images-amazon.com/images/I/51lrvWx2y5L._SX218_BO1,204,203,200_QL40_FMwebp_.jpg','1506716180','-1506715202','English',186,46,'2010-09-09','Dark Horse Books',22,1),(45,44,1,'https://peoplecertproject.s3.eu-central-1.amazonaws.com/blacksadFront.jpg',NULL,NULL,'English',186,17.99,'2010-09-09','Dark Horse Books',22,4),(46,32,9,'https://am-medicine.com/wp-content/uploads/2019/05/519pesQOLXL.jpg','323354793','-323353815','English',780,330,'2016-10-12','Springer Publishing',23,2),(47,46,9,'https://am-medicine.com/wp-content/uploads/2019/05/519pesQOLXL.jpg',NULL,NULL,'English',760,227,'2016-10-19','Springer Publishing',23,4),(48,24,5,'https://pictures.abebooks.com/isbn/9780878936472-us.jpg','878936475','978-0878936475','English',686,249,'2013-12-24','Springer Publishing',24,2),(49,41,19,'https://images-na.ssl-images-amazon.com/images/I/5199PkZ59hL._SX467_BO1,204,203,200_.jpg','71802150','978-0071802150','English',14689,169,'2016-10-10','Taylor & Francis Publishing',25,2),(50,40,19,'https://images-na.ssl-images-amazon.com/images/I/5199PkZ59hL._SX467_BO1,204,203,200_.jpg','71802150','978-0071802150','English',14673,161,'2016-10-10','Taylor & Francis Publishing',25,4),(51,42,10,'https://m.media-amazon.com/images/I/81huR06nGUL._AC_UY436_FMwebp_QL65_.jpg','032353113X','978-032353113X','English',1386,102,'2021-02-26','Springer Publishing',26,2),(52,56,10,'https://m.media-amazon.com/images/I/81huR06nGUL._AC_UY436_FMwebp_QL65_.jpg',NULL,NULL,'English',1386,8,'2021-02-26','Springer Publishing',26,4),(53,42,1,'https://images-na.ssl-images-amazon.com/images/I/71HADMSE3JL._SY291_BO1,204,203,200_QL40_FMwebp_.gif','9780553380163','978-9780553380163','English',212,10,'1998-09-01','Bantam',27,1),(54,58,1,'https://images-na.ssl-images-amazon.com/images/I/71HADMSE3JL._SY291_BO1,204,203,200_QL40_FMwebp_.gif','9423554321','978-9423554321','English',212,51,'1998-09-01','Random House Publishing',27,2),(55,76,1,'https://images-na.ssl-images-amazon.com/images/I/71HADMSE3JL._SY291_BO1,204,203,200_QL40_FMwebp_.gif',NULL,NULL,'English',212,8,'1998-09-01','Bantam',27,4),(56,44,1,'https://images-na.ssl-images-amazon.com/images/I/413q5OlnHSL._SX328_BO1,204,203,200_.jpg','9780465024377','978-9780465024377','English',224,17,'1998-10-10','Basic Books',28,1),(57,50,1,'https://images-na.ssl-images-amazon.com/images/I/413q5OlnHSL._SX328_BO1,204,203,200_.jpg','0465024351','978-0465024351','English',220,13,'1977-04-14','Basic Books',28,2),(58,46,1,'https://images-na.ssl-images-amazon.com/images/I/41UJvgRkmRL._SX331_BO1,204,203,200_.jpg','9780201328400','978-9780201328400','English',216,14,'1998-03-18','Basic Books',29,1),(59,54,1,'https://images-na.ssl-images-amazon.com/images/I/41UJvgRkmRL._SX331_BO1,204,203,200_.jpg','0201149427','978-0201149427','English',224,7,'1997-03-03','Basic Books',29,2),(63,45,1,'https://images-na.ssl-images-amazon.com/images/I/51SKKEpdW2L._SX367_BO1,204,203,200_.jpg','1440543909','978-1440543909','English',288,9,'2012-09-23','Adams-Media',31,2),(64,55,1,'https://images-na.ssl-images-amazon.com/images/I/51SKKEpdW2L._SX367_BO1,204,203,200_.jpg',NULL,NULL,'English',288,14,'2012-09-23','Adams-Media',31,4),(65,49,1,'https://images-na.ssl-images-amazon.com/images/I/51tlJnGLdtL._SX258_BO1,204,203,200_.jpg','1506262082','978-1506262082','English',432,10,'2019-12-31','Barrons Educational,',32,1),(66,49,1,'https://images-na.ssl-images-amazon.com/images/I/51tlJnGLdtL._SX258_BO1,204,203,200_.jpg',NULL,NULL,'English',432,16,'2019-12-31','Barrons Educational,',32,4),(67,56,1,'https://m.media-amazon.com/images/I/4150eh0V-rL.jpg','0374533555','978-0374533555','English',499,10,'2013-03-01','Farrar,Status and Giroux',33,1),(68,54,1,'https://m.media-amazon.com/images/I/4150eh0V-rL.jpg','0374275637','978-0374275637','English',512,18,'2011-10-11','Farrar,Status and Giroux',33,2),(69,54,1,'https://m.media-amazon.com/images/I/4150eh0V-rL.jpg',NULL,NULL,'English',512,13,'2011-10-11','Farrar,Status and Giroux',33,4),(70,84,1,'https://m.media-amazon.com/images/I/51HEUM3uuIL.jpg','1795743735','978-1795743735','English',146,15,'2019-02-03','MM Publishing',34,1),(71,46,1,'https://m.media-amazon.com/images/I/51HEUM3uuIL.jpg','1795743735','978-1795743735','English',146,27,'2019-02-03','MM Publishing',34,2),(72,74,1,'https://m.media-amazon.com/images/I/51HEUM3uuIL.jpg',NULL,NULL,'English',146,13,'2019-02-03','MM Publishing',34,4),(73,36,1,'https://images-na.ssl-images-amazon.com/images/I/51Y-ELVtH6L._SX327_BO1,204,203,200_.jpg','0143110918','978-0143110918','English',800,21,'2018-09-01','Penguin Books',35,1),(74,44,1,'https://images-na.ssl-images-amazon.com/images/I/51Y-ELVtH6L._SX327_BO1,204,203,200_.jpg','1594205078','978-1594205078','English',800,14,'2018-09-01','Penguin Books',35,2),(75,44,1,'https://images-na.ssl-images-amazon.com/images/I/51Y-ELVtH6L._SX327_BO1,204,203,200_.jpg',NULL,NULL,'English',800,11,'2018-09-01','Penguin Books',35,4),(76,24,1,'https://images-na.ssl-images-amazon.com/images/I/51qm2+sT46L._SX331_BO1,204,203,200_.jpg','1250080401','978-1250080401','English',608,9,'2017-05-25','StMartin Griffins',36,1),(77,46,1,'https://images-na.ssl-images-amazon.com/images/I/51qm2+sT46L._SX331_BO1,204,203,200_.jpg','0312577222','978=0312577222','English',608,11,'2017-05-25','StMartin Griffins',36,2),(78,37,1,'https://images-na.ssl-images-amazon.com/images/I/51qm2+sT46L._SX331_BO1,204,203,200_.jpg',NULL,NULL,'English',608,10,'2017-05-25','StMartin Griffins',36,4),(79,41,1,'https://m.media-amazon.com/images/I/41WAilZZNcL.jpg','0593459318','978-0593459318','English',480,31,'2021-04-27','Random House & Print',37,1),(80,39,1,'https://m.media-amazon.com/images/I/41WAilZZNcL.jpg','0385547684','978-0385547684','English',368,21,'2021-04-27','Random House & Print',37,2),(81,36,1,'https://m.media-amazon.com/images/I/41WAilZZNcL.jpg',NULL,NULL,'English',368,15,'2021-04-27','Random House & Print',37,4),(82,42,1,'https://images-na.ssl-images-amazon.com/images/I/51fcDYBoPcL._SX328_BO1,204,203,200_.jpg','006235633X','978-006235633X','English',380,11,'2020-08-25','Custom House',38,1),(83,36,1,'https://images-na.ssl-images-amazon.com/images/I/51fcDYBoPcL._SX328_BO1,204,203,200_.jpg','0062356348','978-0062356348','English',380,14,'2020-08-25','Custom House',38,2),(84,36,1,'https://images-na.ssl-images-amazon.com/images/I/51fcDYBoPcL._SX328_BO1,204,203,200_.jpg',NULL,NULL,'English',380,17,'2020-08-25','Custom House',38,4),(85,32,1,'https://images-na.ssl-images-amazon.com/images/I/51n3j52RkvL._SX331_BO1,204,203,200_.jpg','1260468593','978-1260468593','English',246,38,'2014-11-11','Spring Publisher',39,1),(86,46,1,'https://images-na.ssl-images-amazon.com/images/I/41Y+Ct0AqtL._SX351_BO1,204,203,200_.jpg','3540360654','978-3540360654','English',253,744,'2020-09-09','Spring Publisher',40,1),(87,44,1,'https://images-na.ssl-images-amazon.com/images/I/61d-7H4dptL._SX412_BO1,204,203,200_.jpg','1465481222','978-1465481222','English',244,15,'2019-02-12','DK',41,1),(88,56,1,'https://images-na.ssl-images-amazon.com/images/I/61d-7H4dptL._SX412_BO1,204,203,200_.jpg','1465419659','978-1465419659','English',352,15,'2019-02-12','DK',41,2),(89,99,1,'https://images-na.ssl-images-amazon.com/images/I/61d-7H4dptL._SX412_BO1,204,203,200_.jpg',NULL,NULL,'English',352,10,'2019-02-12','DK',41,4),(93,44,1,'https://upload.wikimedia.org/wikipedia/en/5/50/A_Promised_Land_%28Barack_Obama%29.png','0525633766','978-0525633766','English',1136,23,'2020-08-25','Random House Light Print',44,1),(94,36,1,'https://upload.wikimedia.org/wikipedia/en/5/50/A_Promised_Land_%28Barack_Obama%29.png','1524763160','978-1524763160','English',1136,26,'2020-08-25','Random House Light Print',44,2),(95,26,1,'https://upload.wikimedia.org/wikipedia/en/5/50/A_Promised_Land_%28Barack_Obama%29.png',NULL,NULL,'English',1136,14,'2020-08-25','Random House Light Print',44,4),(96,46,1,'https://images-na.ssl-images-amazon.com/images/I/41HXEG13EKL._SX331_BO1,204,203,200_.jpg','1544512279','978-1544512279','English',363,14,'2021-04-27','LionCrest Publishing',45,1),(97,46,1,'https://images-na.ssl-images-amazon.com/images/I/41HXEG13EKL._SX331_BO1,204,203,200_.jpg','1544512287','978-1544512287','English',363,18,'2021-04-27','LionCrest Publishing',45,2),(98,46,1,'https://images-na.ssl-images-amazon.com/images/I/41HXEG13EKL._SX331_BO1,204,203,200_.jpg',NULL,NULL,'English',363,11,'2021-04-27','LionCrest Publishing',45,4),(102,43,1,'https://images-na.ssl-images-amazon.com/images/I/41AA6cPJqhL._SX328_BO1,204,203,200_.jpg','039324072X','978-039324072X','English',912,24,'2021-04-27','W. W. Norton & Company',47,2),(103,36,1,'https://images-na.ssl-images-amazon.com/images/I/41AA6cPJqhL._SX328_BO1,204,203,200_.jpg',NULL,NULL,'English',912,23,'2021-04-27','W. W. Norton & Company',47,4),(104,44,1,'https://images-na.ssl-images-amazon.com/images/I/51Jj34X7HjL._SX328_BO1,204,203,200_.jpg','0806538419','978-9780806538419','English',245,14,'2017-05-25','Citadel',48,1),(105,44,1,'https://images-na.ssl-images-amazon.com/images/I/51Jj34X7HjL._SX328_BO1,204,203,200_.jpg',NULL,NULL,'English',645,13,'2017-05-25','Citadel',48,4),(106,33,1,'https://m.media-amazon.com/images/I/41DFoLNFzCL.jpg','1760879967','978-1760879967','English',256,43,'2020-08-25','Knopf',49,1),(107,24,1,'https://m.media-amazon.com/images/I/41DFoLNFzCL.jpg','0525656766','978-0525656766','English',244,17,'2020-08-25','Knopf',49,2),(108,19,1,'https://m.media-amazon.com/images/I/41DFoLNFzCL.jpg',NULL,NULL,'English',176,18,'2020-08-25','Knopf',49,4),(109,24,1,'https://m.media-amazon.com/images/I/51hA4n4bgwL.jpg','080241270X','978-080241270X','English',240,8,'2020-09-09','Northfield Publishing',50,1),(110,64,1,'https://m.media-amazon.com/images/I/51hA4n4bgwL.jpg',NULL,NULL,'English',208,9,'2020-09-09','Northfield Publishing',50,4),(113,32,1,'https://m.media-amazon.com/images/I/41s4xJZlEYL._SY346_.jpg','0807014271','978-9780807014271','English',192,9,'2020-08-25','Beacon Press',52,1),(114,20,1,'https://m.media-amazon.com/images/I/41s4xJZlEYL._SY346_.jpg','0807060100','978-0807060100','English',192,11,'2020-08-25','Beacon Press',52,2),(115,24,1,'https://m.media-amazon.com/images/I/41s4xJZlEYL._SY346_.jpg',NULL,NULL,'English',184,10,'2020-08-25','Beacon Press',52,4),(123,4,1,'https://i.annihil.us/u/prod/marvel/i/mg/6/03/62432e71139d6/clean.jpg','385546139','385546132','English',122,14.99,'2022-04-06','Marvel',121,1),(124,40,1,'https://i.annihil.us/u/prod/marvel/i/mg/6/03/62432e71139d6/clean.jpg','385546139','385546132','English',122,34.99,'2022-04-06','Marvel',121,2),(126,40,1,'https://i.annihil.us/u/prod/marvel/i/mg/6/03/62432e71139d6/clean.jpg','385546139','385546132','English',122,14.99,'2022-04-06','Marvel',121,4),(127,40,1,'https://i.annihil.us/u/prod/marvel/i/mg/6/10/608c2960d3ea1/clean.jpg','3855433139','384446132','English',158,14.99,'2021-05-05','Marvel',123,1),(128,40,1,'https://i.annihil.us/u/prod/marvel/i/mg/6/10/608c2960d3ea1/clean.jpg','3855433139','384446132','English',158,14.99,'2021-05-05','Marvel',123,4),(129,40,1,'https://m.media-amazon.com/images/I/51W6q08ZMrL.jpg','3855433139','384446132','English',158,14.99,'2021-05-05','Marvel',124,4);
/*!40000 ALTER TABLE `bookdetails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cart`
--

DROP TABLE IF EXISTS `cart`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cart` (
  `cartid` int NOT NULL AUTO_INCREMENT,
  `bookprice` double NOT NULL,
  `datetime` datetime(6) NOT NULL,
  `shippingcost` double NOT NULL,
  `totalprice` double NOT NULL,
  `customerid` int DEFAULT NULL,
  `visitorid` int DEFAULT NULL,
  PRIMARY KEY (`cartid`),
  KEY `FKbqjl6adcvneg48gd2i72caun3` (`customerid`),
  KEY `FKp6u436uhqurjs0t4hbajdnfnr` (`visitorid`),
  CONSTRAINT `FKbqjl6adcvneg48gd2i72caun3` FOREIGN KEY (`customerid`) REFERENCES `customer` (`customerid`),
  CONSTRAINT `FKp6u436uhqurjs0t4hbajdnfnr` FOREIGN KEY (`visitorid`) REFERENCES `visitor` (`visitorid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cart`
--

LOCK TABLES `cart` WRITE;
/*!40000 ALTER TABLE `cart` DISABLE KEYS */;
INSERT INTO `cart` VALUES (1,938.06,'2022-04-08 00:11:02.150063',35,973.06,2,NULL),(2,956.05,'2022-04-08 00:26:33.786356',35,991.05,2,NULL),(3,33.99,'2022-04-08 00:29:12.194437',35,68.99000000000001,NULL,1),(4,50.16,'2022-04-08 00:37:05.800909',35,85.16,2,NULL),(5,50.16,'2022-04-08 00:42:57.866935',35,85.16,2,NULL),(6,50.16,'2022-04-08 00:46:57.309933',35,85.16,2,NULL),(7,128.34,'2022-04-10 23:24:02.208110',35,163.34,NULL,3),(8,185.45,'2022-04-11 21:27:51.610321',15,200.45000000000002,2,NULL),(9,66.68,'2022-04-11 21:48:20.187950',35,101.68,2,NULL),(10,66.68,'2022-04-11 21:54:46.741870',35,101.68,2,NULL),(11,331.66,'2022-04-11 22:08:04.011421',35,366.66,2,NULL),(12,16,'2022-04-11 23:17:34.104726',0,16,NULL,4),(13,33.99,'2022-07-16 23:37:06.805210',15,48.99,NULL,5);
/*!40000 ALTER TABLE `cart` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cartitem`
--

DROP TABLE IF EXISTS `cartitem`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cartitem` (
  `cartitemid` int NOT NULL AUTO_INCREMENT,
  `quantity` int NOT NULL,
  `bookdetailsid` int NOT NULL,
  `cartid` int NOT NULL,
  PRIMARY KEY (`cartitemid`),
  KEY `FKo09epy4r1jijh74rffhb7ycr2` (`bookdetailsid`),
  KEY `FKtc9npvycs1rruynyqdhyrybqw` (`cartid`),
  CONSTRAINT `FKo09epy4r1jijh74rffhb7ycr2` FOREIGN KEY (`bookdetailsid`) REFERENCES `bookdetails` (`bookdetailsid`),
  CONSTRAINT `FKtc9npvycs1rruynyqdhyrybqw` FOREIGN KEY (`cartid`) REFERENCES `cart` (`cartid`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cartitem`
--

LOCK TABLES `cartitem` WRITE;
/*!40000 ALTER TABLE `cartitem` DISABLE KEYS */;
INSERT INTO `cartitem` VALUES (1,1,86,2),(2,1,37,2),(3,1,45,2),(4,1,6,6),(5,1,3,6),(6,1,36,7),(7,1,22,8),(8,10,3,8),(9,1,128,8),(10,2,6,11),(11,1,31,11),(12,1,34,11),(13,2,44,11),(14,1,27,11),(15,1,66,12),(16,1,6,13);
/*!40000 ALTER TABLE `cartitem` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category`
--

DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `category` (
  `categoryid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY (`categoryid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category`
--

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES (1,'Religion'),(2,'Sports&Outdoors'),(3,'Nutrition'),(4,'Business'),(5,'Comic'),(6,'Novel'),(7,'Medicine'),(8,'Science'),(9,'Psychology'),(10,'Biography');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `country`
--

DROP TABLE IF EXISTS `country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `country` (
  `countryid` int NOT NULL,
  `name` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`countryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `country`
--

LOCK TABLES `country` WRITE;
/*!40000 ALTER TABLE `country` DISABLE KEYS */;
INSERT INTO `country` VALUES (1,'Afghanistan'),(2,'Albania'),(3,'Algeria'),(4,'Andorra'),(5,'Angola'),(6,'Anguilla'),(7,'Antigua & Barbuda'),(8,'Argentina'),(9,'Armenia'),(10,'Australia'),(11,'Austria'),(12,'Azerbaijan'),(13,'Bahamas'),(14,'Bahrain'),(15,'Bangladesh'),(16,'Barbados'),(17,'Belarus'),(18,'Belgium'),(19,'Belize'),(20,'Benin'),(21,'Bermuda'),(22,'Bhutan'),(23,'Bolivia'),(24,'Bosnia & Herzegovina'),(25,'Botswana'),(26,'Brazil'),(27,'Brunei Darussalam'),(28,'Bulgaria'),(29,'Burkina Faso'),(30,'Myanmar/Burma'),(31,'Burundi'),(32,'Cambodia'),(33,'Cameroon'),(34,'Canada'),(35,'Cape Verde'),(36,'Cayman Islands'),(37,'Central African Republic'),(38,'Chad'),(39,'Chile'),(40,'China'),(41,'Colombia'),(42,'Comoros'),(43,'Congo'),(44,'Costa Rica'),(45,'Croatia'),(46,'Cuba'),(47,'Cyprus'),(48,'Czech Republic'),(49,'Democratic Republic of the Congo'),(50,'Denmark'),(51,'Djibouti'),(52,'Dominican Republic'),(53,'Dominica'),(54,'Ecuador'),(55,'Egypt'),(56,'El Salvador'),(57,'Equatorial Guinea'),(58,'Eritrea'),(59,'Estonia'),(60,'Ethiopia'),(61,'Fiji'),(62,'Finland'),(63,'France'),(64,'French Guiana'),(65,'Gabon'),(66,'Gambia'),(67,'Georgia'),(68,'Germany'),(69,'Ghana'),(70,'Great Britain'),(71,'Greece'),(72,'Grenada'),(73,'Guadeloupe'),(74,'Guatemala'),(75,'Guinea'),(76,'Guinea-Bissau'),(77,'Guyana'),(78,'Haiti'),(79,'Honduras'),(80,'Hungary'),(81,'Iceland'),(82,'India'),(83,'Indonesia'),(84,'Iran'),(85,'Iraq'),(86,'Israel and the Occupied Territories'),(87,'Italy'),(88,'Ivory Coast (Cote d\'Ivoire)'),(89,'Jamaica'),(90,'Japan'),(91,'Jordan'),(92,'Kazakhstan'),(93,'Kenya'),(94,'Kosovo'),(95,'Kuwait'),(96,'Kyrgyz Republic (Kyrgyzstan)'),(97,'Laos'),(98,'Latvia'),(99,'Lebanon'),(100,'Lesotho'),(101,'Liberia'),(102,'Libya'),(103,'Liechtenstein'),(104,'Lithuania'),(105,'Luxembourg'),(106,'Republic of Macedonia'),(107,'Madagascar'),(108,'Malawi'),(109,'Malaysia'),(110,'Maldives'),(111,'Mali'),(112,'Malta'),(113,'Martinique'),(114,'Mauritania'),(115,'Mauritius'),(116,'Mayotte'),(117,'Mexico'),(118,'Moldova, Republic of'),(119,'Monaco'),(120,'Mongolia'),(121,'Montenegro'),(122,'Montserrat'),(123,'Morocco'),(124,'Mozambique'),(125,'Namibia'),(126,'Nepal'),(127,'Netherlands'),(128,'New Zealand'),(129,'Nicaragua'),(130,'Niger'),(131,'Nigeria'),(132,'Korea, Democratic Republic of (North Korea)'),(133,'Norway'),(134,'Oman'),(135,'Pacific Islands'),(136,'Pakistan'),(137,'Panama'),(138,'Papua New Guinea'),(139,'Paraguay'),(140,'Peru'),(141,'Philippines'),(142,'Poland'),(143,'Portugal'),(144,'Puerto Rico'),(145,'Qatar'),(146,'Reunion'),(147,'Romania'),(148,'Russian Federation'),(149,'Rwanda'),(150,'Saint Kitts and Nevis'),(151,'Saint Lucia'),(152,'Saint Vincent\'s & Grenadines'),(153,'Samoa'),(154,'Sao Tome and Principe'),(155,'Saudi Arabia'),(156,'Senegal'),(157,'Serbia'),(158,'Seychelles'),(159,'Sierra Leone'),(160,'Singapore'),(161,'Slovak Republic (Slovakia)'),(162,'Slovenia'),(163,'Solomon Islands'),(164,'Somalia'),(165,'South Africa'),(166,'Korea, Republic of (South Korea)'),(167,'South Sudan'),(168,'Spain'),(169,'Sri Lanka'),(170,'Sudan'),(171,'Suriname'),(172,'Swaziland'),(173,'Sweden'),(174,'Switzerland'),(175,'Syria'),(176,'Tajikistan'),(177,'Tanzania'),(178,'Thailand'),(179,'Timor Leste'),(180,'Togo'),(181,'Trinidad & Tobago'),(182,'Tunisia'),(183,'Turkey'),(184,'Turkmenistan'),(185,'Turks & Caicos Islands'),(186,'Uganda'),(187,'Ukraine'),(188,'United Arab Emirates'),(189,'United States of America (USA)'),(190,'Uruguay'),(191,'Uzbekistan'),(192,'Venezuela'),(193,'Vietnam'),(194,'Virgin Islands (UK)'),(195,'Virgin Islands (US)'),(196,'Yemen'),(197,'Zambia'),(198,'Zimbabwe');
/*!40000 ALTER TABLE `country` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer` (
  `customerid` int NOT NULL AUTO_INCREMENT,
  `city` varchar(200) NOT NULL,
  `dateofbirth` date DEFAULT NULL,
  `discountcoupon` int DEFAULT NULL,
  `email` varchar(80) NOT NULL,
  `firstname` varchar(60) NOT NULL,
  `lastname` varchar(60) NOT NULL,
  `password` varchar(80) NOT NULL,
  `phone` bigint NOT NULL,
  `postalcode` int NOT NULL,
  `street` varchar(200) NOT NULL,
  `streetnumber` int NOT NULL,
  `username` varchar(45) NOT NULL,
  `country` int NOT NULL,
  `roleid` int NOT NULL,
  PRIMARY KEY (`customerid`),
  KEY `FKccctp6vrsbs2bm6q8141a37le` (`country`),
  KEY `FKsjw9pqsqjdp64imne0htabm2r` (`roleid`),
  CONSTRAINT `FKccctp6vrsbs2bm6q8141a37le` FOREIGN KEY (`country`) REFERENCES `country` (`countryid`),
  CONSTRAINT `FKsjw9pqsqjdp64imne0htabm2r` FOREIGN KEY (`roleid`) REFERENCES `role` (`roleid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer`
--

LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` VALUES (2,'asdf','2021-05-08',NULL,'asda@adsdf','jimb','bouzoukas','$2a$10$HTehzpfdBMB7JoVtmGRUk.csGJYLCnY9ItoHsgPjdTZ4jEU2TObAG',1234,1,'asdf',1,'voolis',3,4);
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customerserviceagent`
--

DROP TABLE IF EXISTS `customerserviceagent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customerserviceagent` (
  `custserviceid` int NOT NULL AUTO_INCREMENT,
  `password` varchar(250) NOT NULL,
  `username` varchar(45) NOT NULL,
  `roleid` int NOT NULL,
  PRIMARY KEY (`custserviceid`),
  KEY `FK3itooiwp1m5rw67epk6xubghl` (`roleid`),
  CONSTRAINT `FK3itooiwp1m5rw67epk6xubghl` FOREIGN KEY (`roleid`) REFERENCES `role` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customerserviceagent`
--

LOCK TABLES `customerserviceagent` WRITE;
/*!40000 ALTER TABLE `customerserviceagent` DISABLE KEYS */;
/*!40000 ALTER TABLE `customerserviceagent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `format`
--

DROP TABLE IF EXISTS `format`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `format` (
  `formatid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY (`formatid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `format`
--

LOCK TABLES `format` WRITE;
/*!40000 ALTER TABLE `format` DISABLE KEYS */;
INSERT INTO `format` VALUES (1,'Paperback'),(2,'Hardcover'),(3,'Leather bound'),(4,'ebook');
/*!40000 ALTER TABLE `format` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `joinedbookauthor`
--

DROP TABLE IF EXISTS `joinedbookauthor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `joinedbookauthor` (
  `authorid` int NOT NULL,
  `bookid` int NOT NULL,
  KEY `FK6c9rxbr5h0dq9984yu3ad801l` (`bookid`),
  KEY `FK3ear5rwp1iegpjap2ue0bjqbd` (`authorid`),
  CONSTRAINT `FK3ear5rwp1iegpjap2ue0bjqbd` FOREIGN KEY (`authorid`) REFERENCES `author` (`authorid`),
  CONSTRAINT `FK6c9rxbr5h0dq9984yu3ad801l` FOREIGN KEY (`bookid`) REFERENCES `book` (`bookid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `joinedbookauthor`
--

LOCK TABLES `joinedbookauthor` WRITE;
/*!40000 ALTER TABLE `joinedbookauthor` DISABLE KEYS */;
INSERT INTO `joinedbookauthor` VALUES (21,22),(27,35),(4,3),(5,4),(24,25),(6,5),(31,26),(7,6),(30,27),(24,24),(33,28),(9,8),(34,29),(10,9),(11,10),(35,31),(23,32),(12,11),(12,12),(36,33),(26,34),(14,14),(25,36),(16,16),(28,37),(40,49),(41,50),(14,17),(27,39),(37,45),(32,40),(20,20),(16,41),(38,47),(39,48),(17,18),(17,121),(17,123),(13,13),(3,2),(2,1),(29,38),(8,7),(22,44),(42,52),(17,124);
/*!40000 ALTER TABLE `joinedbookauthor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `joinedbookcategory`
--

DROP TABLE IF EXISTS `joinedbookcategory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `joinedbookcategory` (
  `bookid` int NOT NULL,
  `categoryid` int NOT NULL,
  KEY `FKgv6ouj7r2tnbb8ighvcsmi9qf` (`categoryid`),
  KEY `FKpb2dkkoleocnxr6wg9rg8r9st` (`bookid`),
  CONSTRAINT `FKgv6ouj7r2tnbb8ighvcsmi9qf` FOREIGN KEY (`categoryid`) REFERENCES `category` (`categoryid`),
  CONSTRAINT `FKpb2dkkoleocnxr6wg9rg8r9st` FOREIGN KEY (`bookid`) REFERENCES `book` (`bookid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `joinedbookcategory`
--

LOCK TABLES `joinedbookcategory` WRITE;
/*!40000 ALTER TABLE `joinedbookcategory` DISABLE KEYS */;
INSERT INTO `joinedbookcategory` VALUES (2,4),(3,2),(1,2),(4,2),(5,2),(6,2),(7,2),(8,2),(9,3),(10,3),(11,3),(12,3),(13,5),(14,5),(16,5),(17,5),(18,5),(22,6),(36,6),(37,6),(38,6),(23,7),(24,7),(25,7),(26,7),(39,7),(40,7),(27,8),(28,8),(29,8),(41,8),(31,9),(32,9),(33,9),(34,9),(35,9),(44,10),(45,10),(47,10),(48,10),(49,10),(50,10),(52,10),(121,5),(123,5),(5,7),(52,1),(124,5);
/*!40000 ALTER TABLE `joinedbookcategory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `review`
--

DROP TABLE IF EXISTS `review`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `review` (
  `rid` int NOT NULL AUTO_INCREMENT,
  `rating` int NOT NULL,
  `reviewbody` varchar(2500) NOT NULL,
  `bookid` int NOT NULL,
  `customerid` int NOT NULL,
  PRIMARY KEY (`rid`),
  KEY `FKhb5b7mbfe418ofcvlpeshlh4j` (`bookid`),
  KEY `FKry6hyp71d3k629ky7rgl2lnxk` (`customerid`),
  CONSTRAINT `FKhb5b7mbfe418ofcvlpeshlh4j` FOREIGN KEY (`bookid`) REFERENCES `book` (`bookid`),
  CONSTRAINT `FKry6hyp71d3k629ky7rgl2lnxk` FOREIGN KEY (`customerid`) REFERENCES `customer` (`customerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `review`
--

LOCK TABLES `review` WRITE;
/*!40000 ALTER TABLE `review` DISABLE KEYS */;
/*!40000 ALTER TABLE `review` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role`
--

DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `role` (
  `roleid` int NOT NULL AUTO_INCREMENT,
  `rolename` varchar(45) NOT NULL,
  PRIMARY KEY (`roleid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role`
--

LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
INSERT INTO `role` VALUES (1,'ROLE_ADMIN'),(2,'ROLE_STOCKMANAGER'),(3,'ROLE_SERVICEAGENT'),(4,'ROLE_CUSTOMER'),(5,'ROLE_VISITOR');
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stockmanager`
--

DROP TABLE IF EXISTS `stockmanager`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stockmanager` (
  `stockid` int NOT NULL AUTO_INCREMENT,
  `password` varchar(250) NOT NULL,
  `username` varchar(45) NOT NULL,
  `roleid` int NOT NULL,
  PRIMARY KEY (`stockid`),
  KEY `FK24h8ca2rvp7w2pnnvpcke6t1r` (`roleid`),
  CONSTRAINT `FK24h8ca2rvp7w2pnnvpcke6t1r` FOREIGN KEY (`roleid`) REFERENCES `role` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stockmanager`
--

LOCK TABLES `stockmanager` WRITE;
/*!40000 ALTER TABLE `stockmanager` DISABLE KEYS */;
/*!40000 ALTER TABLE `stockmanager` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ticket`
--

DROP TABLE IF EXISTS `ticket`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ticket` (
  `ticketid` int NOT NULL AUTO_INCREMENT,
  `body` varchar(2500) DEFAULT NULL,
  `email` varchar(45) NOT NULL,
  `subject` varchar(60) NOT NULL,
  `cartid` int NOT NULL,
  `customerid` int DEFAULT NULL,
  `visitorid` int DEFAULT NULL,
  PRIMARY KEY (`ticketid`),
  KEY `FK12sg4sb5j0unlx8o4kw704o22` (`cartid`),
  KEY `FK76wtrm4bm5ljipretdasvd486` (`customerid`),
  KEY `FKb9qfycbssfvffc2rmsmjkd52t` (`visitorid`),
  CONSTRAINT `FK12sg4sb5j0unlx8o4kw704o22` FOREIGN KEY (`cartid`) REFERENCES `cart` (`cartid`),
  CONSTRAINT `FK76wtrm4bm5ljipretdasvd486` FOREIGN KEY (`customerid`) REFERENCES `customer` (`customerid`),
  CONSTRAINT `FKb9qfycbssfvffc2rmsmjkd52t` FOREIGN KEY (`visitorid`) REFERENCES `visitor` (`visitorid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket`
--

LOCK TABLES `ticket` WRITE;
/*!40000 ALTER TABLE `ticket` DISABLE KEYS */;
/*!40000 ALTER TABLE `ticket` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ticketanswer`
--

DROP TABLE IF EXISTS `ticketanswer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ticketanswer` (
  `id` int NOT NULL AUTO_INCREMENT,
  `answerbody` varchar(2500) NOT NULL,
  `customeragentid` int NOT NULL,
  `ticketid` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKp0tcvfntyewfyqr9ycgmq6wah` (`customeragentid`),
  KEY `FKk0tcxf386vxcj1oxnxv0e7nvw` (`ticketid`),
  CONSTRAINT `FKk0tcxf386vxcj1oxnxv0e7nvw` FOREIGN KEY (`ticketid`) REFERENCES `ticket` (`ticketid`),
  CONSTRAINT `FKp0tcvfntyewfyqr9ycgmq6wah` FOREIGN KEY (`customeragentid`) REFERENCES `customerserviceagent` (`custserviceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticketanswer`
--

LOCK TABLES `ticketanswer` WRITE;
/*!40000 ALTER TABLE `ticketanswer` DISABLE KEYS */;
/*!40000 ALTER TABLE `ticketanswer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `visitor`
--

DROP TABLE IF EXISTS `visitor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `visitor` (
  `visitorid` int NOT NULL AUTO_INCREMENT,
  `city` varchar(200) DEFAULT NULL,
  `email` varchar(60) NOT NULL,
  `firstname` varchar(60) NOT NULL,
  `lastname` varchar(60) NOT NULL,
  `phone` bigint NOT NULL,
  `postalcode` int DEFAULT NULL,
  `street` varchar(200) DEFAULT NULL,
  `streetnumber` int DEFAULT NULL,
  `country` int DEFAULT NULL,
  `roleid` int NOT NULL,
  PRIMARY KEY (`visitorid`),
  KEY `FKput4ip167p7n0d5jj552rp9sw` (`country`),
  KEY `FKt68g7lisdp5ys7grphw5l6hep` (`roleid`),
  CONSTRAINT `FKput4ip167p7n0d5jj552rp9sw` FOREIGN KEY (`country`) REFERENCES `country` (`countryid`),
  CONSTRAINT `FKt68g7lisdp5ys7grphw5l6hep` FOREIGN KEY (`roleid`) REFERENCES `role` (`roleid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `visitor`
--

LOCK TABLES `visitor` WRITE;
/*!40000 ALTER TABLE `visitor` DISABLE KEYS */;
INSERT INTO `visitor` VALUES (1,'Minsk','bbb@bbb.com','aaaa','aaaa',123,5,'asdasd',5,17,5),(2,'zxczxc','zxczxc@asas','zxczxc','zxczxc',123123,1212,'zxczcx',12,3,5),(3,'asfafs','asfasf@asdasd','adfdaf','asfasf',22,11,'asfasf',11,2,5),(4,NULL,'asddsa@asdsa','asdasd','asdasd',123,0,NULL,0,NULL,5),(5,'adfaf','asfasf@afdaf','adfdaf','asffasf',123,3,'adfaf',2,3,5);
/*!40000 ALTER TABLE `visitor` 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 2022-07-24 16:17:11