question

JesW87 avatar image
JesW87 asked

Why am I getting these errors?

I am working on a database for a prototype of a program where you can add users and buy games (it's just for demonstration purposes). Everything in this looks fine to me, but for some reason, when I run this script to create the database I get an error (shown at the bottom).

CREATE DATABASE IF NOT EXISTS newGamestore;
USE newGamestore;

CREATE TABLE USERS (
  username    VARCHAR(26) NOT NULL,
  password    VARCHAR(30) NOT NULL,
  fname       VARCHAR(25) NOT NULL,
  lname       VARCHAR(25) NOT NULL,
  email       VARCHAR(35) NOT NULL,
  description VARCHAR(1310),
  PRIMARY KEY (username)
);

CREATE TABLE GAMES (
  gName       VARCHAR(73)   NOT NULL,
  price       INT           NOT NULL,
  year        INT           NOT NULL,
  pubName     VARCHAR(50)   NOT NULL,
  devName     VARCHAR(50)   NOT NULL,
  genre       VARCHAR(20)   NOT NULL,
  sqImage     VARCHAR(50)   NOT NULL,
  wImage      VARCHAR(50)   NOT NULL,
  description VARCHAR(700)  NOT NULL,
  PRIMARY KEY (gname)
);

CREATE TABLE FRIENDS (
  username    VARCHAR(26) NOT NULL,
  friendName  VARCHAR(26) NOT NULL,
  PRIMARY KEY (username,friendName),
  FOREIGN KEY(username) REFERENCES USERS(username) ON DELETE CASCADE,
  FOREIGN KEY(friendName) REFERENCES USERS(username) ON DELETE CASCADE
);

CREATE TABLE OWNERSHIP (
  username    VARCHAR(26) NOT NULL,
  gName       VARCHAR(73) NOT NULL,
  PRIMARY KEY (username, gName),
  FOREIGN KEY(username) REFERENCES USERS(username) ON DELETE CASCADE,
  FOREIGN KEY(gName) REFERENCES GAMES(gName)
);

CREATE TABLE REVIEWS (
  username    VARCHAR(26)   NOT NULL,
  review      VARCHAR(418)  NOT NULL,
  gName       VARCHAR(73)   NOT NULL,
  PRIMARY KEY (username,gName),
  FOREIGN KEY(username) REFERENCES USERS(username) ON DELETE CASCADE,
  FOREIGN KEY(gName) REFERENCES GAMES(gName)
);

INSERT INTO GAMES(gName, price, year, pubName, devName, genre, sqImage, wImage, description)
VALUES
  ('Assassin’s Creed: Odyssey', 20, 2018, 'Ubisoft', 'Ubisoft', 'Adventure', 'assassinscreedodysseysq.jpg', 'assassinscreedodyssey.jpg', 'Write your own epic odyssey and become a legendary Spartan hero in Assassin’s Creed® Odyssey, an inspiring adventure where you must forge your destiny and define your own path in a world on the brink of tearing itself apart. Influence how history unfolds as you experience a rich and ever-changing world shaped by your decisions.'),
  ('Don’t Starve', 10, 2013, 'Klei Entertainment', 'Klei Entertainment', 'Adventure', 'dontstarvesq.jpeg', 'dontstarve.jpeg', 'Don’t Starve is an uncompromising wilderness survival game full of science and magic.  You play as Wilson, an intrepid Gentleman Scientist who has been trapped by a demon and transported to a mysterious wilderness world. Wilson must learn to exploit his environment and its inhabitants if he ever hopes to escape and find his way back home.  Enter a strange and unexplored world full of strange creatures, dangers, and surprises. Gather resources to craft items and structures that match your survival style. Play your way as you unravel the mysteries of this strange land.'),
  ('Minecraft', 15, 2011, 'Mojang', 'Mojang', 'Adventure', 'minecraftsq.png', 'minecraft.png', 'Explore infinite worlds and build everything from the simplest of homes to the grandest of castles. Play in creative mode with unlimited resources or mine deep into the world in survival mode, crafting weapons and armor to fend off dangerous mobs. Create, explore and survive alone or with friends.'),
  ('Monster Hunter: World', 30, 2017, 'Capcom', 'Capcom', 'Adventure', 'monsterhunterworldsq.jpg', 'monsterhunterworld.jpg', 'Welcome to a new world! Take on the role of a hunter and slay ferocious monsters in a living, breathing ecosystem where you can use the landscape and its diverse inhabitants to get the upper hand. Hunt alone or in co-op with up to three other players, and use materials collected from fallen foes to craft new gear and take on even bigger, badder beasts!'),
  ('Outer Wilds', 25, 2019, 'Annapurna Interactive', 'Mobius Digital', 'Adventure', 'outerwildssq.jpg', 'outerwilds.jpg', 'An open world mystery about a solar system trapped in an endless time loop.'),
  ('Red Dead Redemption 2', 60, 2018, 'Rockstar Games', 'Rockstar Games', 'Adventure', 'rdr2sq.jpg', 'rdr2.jpg', 'Arthur Morgan and the Van der Linde gang are outlaws on the run. With federal agents and the best bounty hunters in the nation massing on their heels, the gang must rob, steal and fight their way across the rugged heartland of America in order to survive. As deepening internal divisions threaten to tear the gang apart, Arthur must make a choice between his own ideals and loyalty to the gang who raised him.'),
  ('Terraria', 10, 2011, 'Re-Logic', 'Re-Logic', 'Adventure', 'terrariasq.jpg', 'terraria.jpg', 'Dig, Fight, Explore, Build: The very world is at your fingertips as you fight for survival, fortune, and glory. Will you delve deep into cavernous expanses in search of treasure and raw materials with which to craft ever-evolving gear, machinery, and aesthetics? Perhaps you will choose instead to seek out ever-greater foes to test your mettle in combat? Maybe you will decide to construct your own city to house the host of mysterious allies you may encounter along your travels?'),
  ('Tomb Raider', 15, 2013, 'Square Enix', 'Crystal Dynamics', 'Adventure', 'tombraidersq.jpg', 'tombraider.jpg', 'Tomb Raider explores the intense and gritty origin story of Lara Croft and her ascent from a young woman to a hardened survivor. Armed only with raw instincts and the ability to push beyond the limits of human endurance, Lara must fight to unravel the dark history of a forgotten island to escape its relentless hold.'),
  ('Valheim', 20, 2021, 'Coffee Stain Publishing', 'Iron Gate AB', 'Adventure', 'valheimsq.jpg', 'valheim.jpg', 'A battle-slain warrior, the Valkyries have ferried your soul to Valheim, the tenth Norse world. Besieged by creatures of chaos and ancient enemies of the gods, you are the newest custodian of the primordial purgatory, tasked with slaying Odin’s ancient rivals and bringing order to Valheim.'),
  ('Alan Wake', 15, 2012, 'Remedy Entertainment', 'Remedy Entertainment', 'Horror', 'alanwakesq.jpg', 'alanwake.jpg', 'When the wife of the best-selling writer Alan Wake disappears on their vacation, his search turns up pages from a thriller he doesn’t even remember writing. A Dark Presence stalks the small town of Bright Falls, pushing Wake to the brink of sanity in his fight to unravel the mystery and save his love.'),
  ('Alien: Isolation', 40, 2014, 'SEGA', 'Creative Assembly', 'Horror', 'alienisolationsq.png', 'alienisolation.png', 'Discover the true meaning of fear in Alien: Isolation, a survival horror set in an atmosphere of constant dread and mortal danger. Fifteen years after the events of Alien™, Ellen Ripley’s daughter, Amanda enters a desperate battle for survival, on a mission to unravel the truth behind her mother''s disappearance.'),
  ('Amnesia: The Dark Descent', 20, 2010, 'Frictional Games', 'Frictional Games', 'Horror', 'amnesiasq.jpg', 'amnesia.jpg', 'Amnesia: The Dark Descent puts you in the shoes of Daniel as he wakes up in a desolate castle, barely remembering anything about his past. Exploring its eerie pathways, you must piece together Daniel''s troubled memories and uncover the horror that lies deep below.'),
  ('Dead Space 2', 20, 2011, 'Electronic Arts', 'Visceral Games', 'Horror', 'deadspace2sq.jpg', 'deadspace2.jpg', 'Three years after the Necromorph infestation aboard the USS Ishimura, Isaac Clarke awakens from a coma, confused, disoriented, and on a space station called The Sprawl. Explore this world and its zero-g environments to discover the truth about the Unitology and its role in the Necromorph epidemic.'),
  ('Outlast', 20, 2013, 'Red Barrels', 'Red Barrels', 'Horror', 'outlastsq.jpg', 'outlast.jpg', 'Hell is an experiment you can''t survive in Outlast, a first-person survival horror game developed by veterans of some of the biggest game franchises in history. As investigative journalist Miles Upshur, explore Mount Massive Asylum and try to survive long enough to discover its terrible secret... if you dare.'),
  ('Phasmophobia', 14, 2020, 'Kinetic Games', 'Kinetic Games', 'Horror', 'phasmophobiasq.jpg', 'phasmophobia.jpg', 'Phasmophobia is a 4 player online co-op psychological horror where you and your team members of paranormal investigators will enter haunted locations filled with paranormal activity and gather as much evidence of the paranormal as you can. You will use your ghost hunting equipment to search for and record evidence of whatever ghost is haunting the location to sell onto a ghost removal team.'),
  ('Resident Evil 7 Biohazard', 30, 2017, 'CAPCOM', 'CAPCOM', 'Horror', 'residentevilbiohazardsq.jpg', 'residentevilbiohazard.jpg', 'Set in modern day rural America and taking place after the dramatic events of Resident Evil® 6, players experience the terror directly from the first person perspective. Resident Evil 7 embodies the series’ signature gameplay elements of exploration and tense atmosphere that first coined “survival horror” some twenty years ago; meanwhile, a complete refresh of gameplay systems simultaneously propels the survival horror experience to the next level.'),
  ('SOMA', 30, 2015, 'Frictional Games', 'Frictional Games', 'Horror', 'somasq.jpg', 'soma.jpg', 'The radio is dead, food is running out, and the machines have started to think they are people. Underwater facility PATHOS-II has suffered an intolerable isolation and we’re going to have to make some tough decisions. What can be done? What makes sense? What is left to fight for?'),
  ('The Evil Within', 20, 2014, 'Bethesda Softworks', 'Tango Gameworks', 'Horror', 'theevilwithinsq.jpg', 'theevilwithin.jpg', 'While investigating the scene of a gruesome mass murder, Detective Sebastian Castellanos and his partners encounter a mysterious and powerful force. After seeing the slaughter of fellow officers, Sebastian is ambushed and knocked unconscious. When he awakens, he finds himself in a deranged world where hideous creatures wander among the dead.  Facing unimaginable terror, and fighting for survival, Sebastian embarks on a frightening journey to unravel what’s behind this evil force.'),
  ('A Hat in Time', 30, 2017, 'Gears for Breakfast', 'Gears for Breakfast', 'Platformer', 'ahatintimesq.jpg', 'ahatintime.jpg', 'In A Hat in Time you play as a tiny space-travelling girl with a big tophat. Her adventure is halted when all her fuel, the Time Pieces, is lost and scattered across a nearby planet. Hat Kid must now jump, fight and stitch new hats to make her way into every nook and cranny of this new world in order to restore her fuel and resume her journey. On her way, she''ll bump into the menacing Mafia of Cooks, the goofy birds of Dead Bird Studio, the spooky shadows of Subcon Forest, and more!'),
  ('Battleblock Theater', 15, 2014, 'The Behemoth', 'The Behemoth', 'Platformer', 'battleblocktheatersq.jpg', 'battleblocktheater.jpg', 'Shipwrecked. Captured. Betrayed. Forced to perform for an audience of cats? Yes, all that and more when you unlock BattleBlock Theater! There’s no turning back once you''ve started on your quest to free over 300 of your imprisoned friends from evil technological cats. Immerse yourself in this mind bending tale of treachery as you use your arsenal of weapon-tools to battle your way through hundreds of levels in order to discover the puzzling truth behind BattleBlock Theater.'),
  ('Celeste', 20, 2018, 'Matt Makes Games Inc.', 'Matt Makes Games Inc.', 'Platformer', 'celestesq.jpg', 'celeste.jpg', 'Help Madeline survive her inner demons on her journey to the top of Celeste Mountain, in this super-tight platformer from the creators of TowerFall. Brave hundreds of hand-crafted challenges, uncover devious secrets, and piece together the mystery of the mountain.'),
  ('Hollow Knight', 15, 2017, 'Team Cherry', 'Team Cherry', 'Platformer', 'hollowknightsq.jpg', 'hollowknight.jpg', 'Hollow Knight is a classically styled 2D action adventure across a vast interconnected world. Explore twisting caverns, ancient cities and deadly wastes; battle tainted creatures and befriend bizarre bugs; and solve ancient mysteries at the kingdom''s heart.'),
  ('Limbo', 10, 2011, 'Playdead', 'Playdead', 'Platformer', 'limbosq.jpg', 'limbo.jpg', 'Uncertain of his sister''s fate, a boy enters LIMBO'),
  ('Little Nightmares', 20, 2017, 'BANDAI NAMCO Entertainment', 'Tarsier Studios', 'Platformer', 'littlenightmaressq.jpg', 'littlenightmares.jpg', 'Immerse yourself in Little Nightmares, a dark whimsical tale that will confront you with your childhood fears! Help Six escape The Maw – a vast, mysterious vessel inhabited by corrupted souls looking for their next meal.'),
  ('Ori and the Will of the Wisps', 30, 2020, 'Xbox Game Studios', 'Moon Studios GmbH', 'Platformer', 'oriandthewillofthewispssq.jpg', 'oriandthewillofthewisps.jpg', 'The little spirit Ori is no stranger to peril, but when a fateful flight puts the owlet Ku in harm’s way, it will take more than bravery to bring a family back together, heal a broken land, and discover Ori’s true destiny. From the creators of the acclaimed action-platformer Ori and the Blind Forest comes the highly anticipated sequel. Embark on an all-new adventure in a vast world filled with new friends and foes that come to life in stunning, hand-painted artwork. Set to a fully orchestrated original score, Ori and the Will of the Wisps continues the Moon Studios tradition of tightly crafted platforming action and deeply emotional storytelling.'),
  ('Super Meat Boy', 15, 2010, 'Team Meat', 'Team Meat', 'Platformer', 'supermeatboysq.jpg', 'supermeatboy.jpg', 'Our meaty hero will leap from walls, over seas of buzz saws, through crumbling caves and pools of old needles. Sacrificing his own well being to save his damsel in distress. Super Meat Boy brings the old school difficulty of classic NES titles like Mega Man 2, Ghost and Goblins and Super Mario Bros. 2 (The Japanese one) and stream lines them down to the essential no BS straight forward twitch reflex platforming.'),
  ('VVVVVV', 5, 2010, 'Terry Cavanagh', 'Terry Cavanagh', 'Platformer', 'vvvvvvsq.jpg', 'vvvvvv.jpg', 'VVVVVV is a platform game all about exploring one simple mechanical idea - what if you reversed gravity instead of jumping?'),
  ('Dark Souls: Remastered', 40, 2018, 'FromSoftware, Inc', 'QLOC', 'RPG', 'darksoulsremasteredsq.jpg', 'darksoulsremastered.jpg', 'Then, there was fire. Re-experience the critically acclaimed, genre-defining game that started it all. Beautifully remastered, return to Lordran in stunning high-definition detail running at 60fps.'),
  ('Disco Elysium', 40, 2019, 'ZA/UM', 'ZA/UM', 'RPG', 'discoelysiumsq.jpg', 'discoelysium.jpg', 'Disco Elysium is a groundbreaking role playing game. You’re a detective with a unique skill system at your disposal and a whole city block to carve your path across. Interrogate unforgettable characters, crack murders or take bribes. Become a hero or an absolute disaster of a human being.'),
  ('Dishonored', 10, 2012, 'Bethesda Softworks', 'Arkane Studios', 'RPG', 'dishonoredsq.jpg', 'dishonored.jpg', 'Dishonored is set in Dunwall, an industrial whaling city where strange steampunk- inspired technology and otherworldly forces coexist in the shadows. You are the once-trusted bodyguard of the beloved Empress. Framed for her murder, you become an infamous assassin, known only by the disturbing mask that has become your calling card. In a time of uncertainty, when the city is besieged by plague and ruled by a corrupt government armed with industrial technologies, dark forces conspire to bestow upon you abilities beyond those of any common man – but at what cost? The truth behind your betrayal is as murky as the waters surrounding the city, and the life you once had is gone forever.'),
  ('Divinity: Original Sin 2 - Definitive Edition', 45, 2017, 'Larian Studios', 'Larian Studios', 'RPG', 'divinityoriginalsin2sq.jpg', 'divinityoriginalsin2.jpg', 'The critically acclaimed RPG that raised the bar, from the creators of Baldur''s Gate 3. Gather your party. Master deep, tactical combat. Venture as a party of up to four - but know that only one of you will have the chance to become a God.'),
  ('Fallout 3', 10, 2008, 'Bethesda Softworks', 'Bethesda Game Studios', 'RPG', 'fallout3sq.jpg', 'fallout3.jpg', 'Vault-Tec engineers have worked around the clock on an interactive reproduction of Wasteland life for you to enjoy from the comfort of your own vault. Included is an expansive world, unique combat, shockingly realistic visuals, tons of player choice, and an incredible cast of dynamic characters.'),
  ('Mass Effect 2', 20, 2010, 'Electronic Arts', 'BioWare', 'RPG', 'masseffect2sq.jpg', 'masseffect.jpg', 'Recruit. Explore. Control.Two years after Commander Shepard repelled invading Reapers bent on the destruction of organic life, a mysterious new enemy has emerged. On the fringes of known space, something is silently abducting entire human colonies.'),
  ('The Elder Scrolls V: Skyrim', 40, 2011, 'Bethesda Softworks', 'Bethesda Game Studios', 'RPG', 'skyrimsq.jpg', 'skyrim.jpg', 'The Elder Scrolls V: Skyrim, the 2011 Game of the Year, is the next chapter in the highly anticipated Elder Scrolls saga. Developed by Bethesda Game Studios, the 2011 Studio of the Year, that brought you Oblivion and Fallout 3. Skyrim reimagines and revolutionizes the open-world fantasy epic, bringing to life a complete virtual world open for you to explore any way you choose.'),
  ('The Witcher® 3: Wild Hunt', 40, 2015, 'CD PROJEKT RED', 'CD PROJEKT RED', 'RPG', 'thewitcher3sq.jpg', 'thewitcher3.jpg', 'The Witcher: Wild Hunt is a story-driven open world RPG set in a visually stunning fantasy universe full of meaningful choices and impactful consequences. In The Witcher, you play as professional monster hunter Geralt of Rivia tasked with finding a child of prophecy in a vast open world rich with merchant cities, pirate islands, dangerous mountain passes, and forgotten caverns to explore.'),
  ('Undertale', 10, 2015, 'tobyfox', 'tobyfox', 'RPG', 'undertalesq.jpg', 'undertale.jpg', 'Welcome to UNDERTALE. In this RPG, you control a human who falls underground into the world of monsters. Now you must find your way out... or stay trapped forever.'),
  ('Bioshock', 20, 2007, '2K', '2K', 'Shooter', 'bioshocksq.jpg', 'bioshock.jpg', 'BioShock is a shooter unlike any you''ve ever played, loaded with weapons and tactics never seen. You''ll have a complete arsenal at your disposal from simple revolvers to grenade launchers and chemical throwers, but you''ll also be forced to genetically modify your DNA to create an even more deadly weapon: you. Injectable plasmids give you super human powers: blast electrical currents into water to electrocute multiple enemies, or freeze them solid and obliterate them with the swing of a wrench.'),
  ('Borderlands 2', 5, 2012, '2K', 'Gearbox Software', 'Shooter', 'borderlands2sq.jpg', 'borderlands2.jpg', 'A new era of shoot and loot is about to begin. Play as one of four new vault hunters facing off against a massive new world of creatures, psychos and the evil mastermind, Handsome Jack. Make new friends, arm them with a bazillion weapons and fight alongside them in 4 player co-op on a relentless quest for revenge and redemption across the undiscovered and unpredictable living planet.'),
  ('Counter-Strike: Global Offensive', 0, 2012, 'Valve', 'Valve', 'Shooter', 'csgosq.jpg', 'csgo.jpg', 'Counter-Strike: Global Offensive (CS: GO) expands upon the team-based action gameplay that it pioneered when it was launched 19 years ago. CS: GO features new maps, characters, weapons, and game modes, and delivers updated versions of the classic CS content (de_dust2, etc.).'),
  ('DOOM Eternal', 60, 2020, 'Bethesda Softworks', 'id Software', 'Shooter', 'doometernalsq.jpg', 'doometernal.jpg', 'Hell’s armies have invaded Earth. Become the Slayer in an epic single-player campaign to conquer demons across dimensions and stop the final destruction of humanity. The only thing they fear... is you.'),
  ('Far Cry® 5', 12, 2018, 'Ubisoft', 'Ubisoft Montreal', 'Shooter', 'farcry5sq.jpg', 'farcry5.jpg', 'Welcome to Hope County, Montana, home to a fanatical doomsday cult known as Eden’s Gate. Stand up to cult leader Joseph Seed & his siblings, the Heralds, to spark the fires of resistance & liberate the besieged community.'),
  ('Half-Life 2', 10, 2004, 'Valve', 'Valve', 'Shooter', 'halflife2sq.jpg', 'halflife2.jpg', 'The player again picks up the crowbar of research scientist Gordon Freeman, who finds himself on an alien-infested Earth being picked to the bone, its resources depleted, its populace dwindling. Freeman is thrust into the unenviable role of rescuing the world from the wrong he unleashed back at Black Mesa. And a lot of people he cares about are counting on him.'),
  ('Overwatch', 30, 2016, 'Blizzard Entertainment', 'Blizzard Entertainment', 'Shooter', 'overwatchsq.jpg', 'overwatch.jpg', 'Choose your hero from a diverse cast of soldiers, scientists, adventurers, and oddities. Bend time, defy physics, and unleash an array of extraordinary powers and weapons. Engage your enemies in the ultimate team-based shooter game. Don’t miss your shot.'),
  ('Tom Clancy''s Rainbow Six® Siege', 20, 2015, 'Ubisoft', 'Ubisoft Montreal', 'Shooter', 'rainbowsixsiegesq.jpg', 'rainbowsixsiege.jpg', 'Master the art of destruction and gadgetry in Tom Clancy’s Rainbow Six Siege. Face intense close quarters combat, high lethality, tactical decision making, team play and explosive action within every moment. Experience a new era of fierce firefights and expert strategy born from the rich legacy of past Tom Clancy''s Rainbow Six games.'),
  ('Team Fortress 2', 0, 2007, 'Valve', 'Valve', 'Shooter', 'tf2sq.jpg', 'tf2.jpg', 'One of the most popular online action games of all time, Team Fortress 2 delivers constant free updates—new game modes, maps, equipment and, most importantly, hats. Nine distinct classes provide a broad range of tactical abilities and personalities, and lend themselves to a variety of player skills.'),
  ('Age of Empires II: Definitive Edition', 20, 2019, 'Xbox Game Studios', 'Forgotten Empires', 'Strategy', 'ageofempires2sq.jpg', 'ageofempires2.jpg', 'Age of Empires II: Definitive Edition celebrates the 20th anniversary of one of the most popular strategy games ever with stunning 4K Ultra HD graphics, a new and fully remastered soundtrack, and brand-new content, “The Last Khans” with 3 new campaigns and 4 new civilizations.'),
  ('Cities: Skylines', 30, 2015, 'Paradox Interactive', 'Colossal Order Ltd.', 'Strategy', 'citiesskylinessq.jpg', 'citiesskylines.jpg', 'Cities: Skylines is a modern take on the classic city simulation. The game introduces new game play elements to realize the thrill and hardships of creating and maintaining a real city whilst expanding on some well-established tropes of the city building experience.'),
  ('Sid Meier’s Civilization® VI', 60, 2016, '2K', 'Firaxis Games', 'Strategy', 'civilization6sq.jpg', 'civilization6.jpg', 'Originally created by legendary game designer Sid Meier, Civilization is a turn-based strategy game in which you attempt to build an empire to stand the test of time. Become Ruler of the World by establishing and leading a civilization from the Stone Age to the Information Age. Wage war, conduct diplomacy, advance your culture, and go head-to-head with history’s greatest leaders as you attempt to build the greatest civilization the world has ever known.'),
  ('Crusader Kings III', 50, 2020, 'Paradox Interactive', 'Paradox Development Studio', 'Strategy', 'crusaderkings3sq.jpg', 'crusaderkings3.jpg', 'Paradox Development Studio brings you the sequel to one of the most popular strategy games ever made. Crusader Kings III is the heir to a long legacy of historical grand strategy experiences and arrives with a host of new ways to ensure the success of your royal house.'),
  ('Factorio', 30, 2020, 'Wube Software LTD.', 'Wube Software LTD.', 'Strategy', 'factoriosq.jpg', 'factorio.jpg', 'Factorio is a game about building and creating automated factories to produce items of increasing complexity, within an infinite 2D world. Use your imagination to design your factory, combine simple elements into ingenious structures, and finally protect it from the creatures who don''t really like you.'),
  ('RimWorld', 35, 2018, 'Ludeon Studios', 'Ludeon Studios', 'Strategy', 'rimworldsq.jpg', 'rimworld.jpg', 'A sci-fi colony sim driven by an intelligent AI storyteller. Generates stories by simulating psychology, ecology, gunplay, melee combat, climate, biomes, diplomacy, interpersonal relationships, art, medicine, trade, and more.'),
  ('Stellaris', 40, 2016, 'Paradox Interactive', 'Paradox Development Studios', 'Strategy', 'stellarissq.jpg', 'stellaris.jpg', 'Explore a galaxy full of wonders in this sci-fi grand strategy game from Paradox Development Studios. Interact with diverse alien races, discover strange new worlds with unexpected events and expand the reach of your empire. Each new adventure holds almost limitless possibilities.'),
  ('Total War: WARHAMMER II', 60, 2017, 'SEGA', 'CREATIVE ASSEMBLY', 'Strategy', 'totalwarwarhammer2sq.jpg', 'totalwarwarhammer2.jpg', 'Strategy gaming perfected. A breath-taking campaign of exploration, expansion and conquest across a fantasy world. Turn-based civilisation management and real-time epic strategy battles with thousands of troops and monsters at your command.'),
  ('XCOM® 2', 60, 2016, '2K', 'Firaxis Games', 'Strategy', 'xcom2sq.jpg', 'xcom2.jpg', 'XCOM 2 is the sequel to XCOM: Enemy Unknown, the 2012 award-winning strategy game of the year. Earth has changed and is now under alien rule. Facing impossible odds you must rebuild XCOM, and ignite a global resistance to reclaim our world and save humanity.');

INSERT INTO USERS(username, password, fname, lname, email, description)
VALUES
  ('JesW87', 'demopassword1', 'Jesse', 'Wiatrak', 'jdw0055@uah.edu', 'My name is Jesse, and I like video games.  My favorite games are probably Dark Souls, The Witcher 3, and Elden Ring, a game that definitely exists.'),
  ('jdw0055', 'demopassword2', 'Jake', 'Winters', 'jw123@gmail.com'),
  ('kbh1443', 'demopassword3', 'Kevin', 'Harris', 'kbh1443@gmail.com'),
  ('sba5225', 'demopassword4', 'Steven', 'Anderson', 'sba5225@gmail.com');

INSERT INTO FRIENDS(username, friendName)
VALUES
  ('JesW87', 'jdw0055'),
  ('JesW87', 'kbh1443'),
  ('jdw0055', 'sba5225'),
  ('kbh1443', 'sba5225');

INSERT INTO OWNERSHIP(username, gName)
VALUES
  ('JesW87', 'Red Dead Redemption 2'),
  ('JesW87', 'Dark Souls: Remastered'),
  ('JesW87', 'Disco Elysium'),
  ('JesW87', 'DOOM Eternal'),
  ('JesW87', 'Overwatch'),
  ('JesW87', 'Dishonored'),
  ('JesW87', 'Undertale'),
  ('JesW87', 'Valheim'),
  ('JesW87', 'Crusader Kings III'),
  ('JesW87', 'Alan Wake'),
  ('JesW87', 'Half-Life 2'),
  ('JesW87', 'Borderlands 2'),
  ('JesW87', 'Celeste'),
  ('kbh1443', 'Terraria'),
  ('kbh1443', 'Dark Souls: Remastered'),
  ('kbh1443', 'Mass Effect 2'),
  ('kbh1443', 'Tomb Raider'),
  ('kbh1443', 'Limbo'),
  ('sba5225', 'Little Nightmares'),
  ('sba5225', 'Limbo');

INSERT INTO REVIEWS(username, review, gName)
VALUES
  ('JesW87', 'Hot take: better than tf2', 'Overwatch'),
  ('JesW87', 'This is one of the best games ever made.', 'Dark Souls: Remastered'),
  ('JesW87', 'A worthy sequel.', 'Red Dead Redemption 2'),
  ('kbh1443', 'I love this game!', 'Mass Effect 2'),
  ('kbh1443', 'This is my favorite game of all time', 'Dark Souls: Remastered');
ERROR 1136 (21S01): Column count doesn't match value count at row 2
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`newgamestore`.`friends`, CONSTRAINT `friends_ibfk_1` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE CASCADE)
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`newgamestore`.`ownership`, CONSTRAINT `ownership_ibfk_1` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE CASCADE)
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`newgamestore`.`reviews`, CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE CASCADE)

I have no idea what is causing this. This should work.

databasemysqlerrorforeign-key
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Nevermind, I figured it out. I for some reason assumed that

Column count doesn't match value count at row 2

was referring to row 2 of the GAMES table, but then I realized it doesn't give any information on which table it's referring to (why that is I don't know, that should be fixed), and I solved it by adding NULL values for the description in the values I inserted into the USERS table.

0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.