-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinsertGames.sql
153 lines (115 loc) · 23.3 KB
/
insertGames.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
INSERT INTO games (title, descripcion, genre, console_public_name, console_small_name, generation, release_year, precio, cover_jpg)
VALUES
('Street Fighter Alpha 3','Engage in fierce one-on-one battles in Street Fighter Alpha 3. Choose from a roster of iconic fighters, each with unique abilities and special moves. With fast-paced gameplay and stunning visuals, this classic fighting game delivers an arcade experience like no other.', 'Fighting', 'PlayStation 1', 'ps1', 5, 1999, 14.99, 'https://cdn.mobygames.com/covers/91439-street-fighter-alpha-3-playstation-front-cover.jpg'),
('Spyro the Dragon', 'Embark on a colorful and whimsical adventure as Spyro the Dragon. Explore expansive worlds, solve puzzles, and collect gems in this beloved platformer. With charming characters and engaging gameplay, Spyro the Dragon captivates players of all ages.', 'Platformer', 'PlayStation 1', 'ps1', 5, 1998, 19.99, 'https://cdn.mobygames.com/covers/4799551-spyro-the-dragon-playstation-front-cover.jpg'),
('Tomb Raider', 'Uncover the mysteries of ancient tombs in the original Tomb Raider. As the iconic adventurer Lara Croft, you navigate treacherous environments, solve puzzles, and face formidable enemies. With groundbreaking 3D graphics, Tomb Raider set the standard for action-adventure gaming.', 'Action-Adventure', 'PlayStation 1', 'ps1', 5, 1996, 9.99, 'https://cdn.mobygames.com/covers/4046877-tomb-raider-playstation-front-cover.jpg'),
('Resident Evil 2', 'Experience the horror of Raccoon City in Resident Evil 2. Navigate through a zombie-infested city as Leon Kennedy or Claire Redfield, each with their own unique story. With atmospheric tension and gripping storytelling, Resident Evil 2 remains a landmark in survival horror.', 'Survival Horror', 'PlayStation 1', 'ps1', 5, 1998, 24.99, 'https://cdn.mobygames.com/covers/4717771-resident-evil-2-playstation-front-cover.jpg'),
('Metal Gear Solid', 'Step into the world of tactical espionage in Metal Gear Solid. As Solid Snake, you infiltrate a nuclear weapons facility to neutralize a terrorist threat. With cinematic storytelling, complex characters, and innovative gameplay mechanics, Metal Gear Solid redefined the stealth genre.', 'Stealth', 'PlayStation 1', 'ps1', 5, 1998, 29.99, 'https://cdn.mobygames.com/covers/8618053-metal-gear-solid-playstation-front-cover.jpg'),
('Max Payne 3', 'Immerse yourself in the gritty world of Max Payne 3. As a troubled ex-cop, navigate through a story of betrayal and redemption. With intense gunplay, cinematic storytelling, and a noir atmosphere, Max Payne 3 delivers a gripping third-person shooter experience.', 'Third-Person Shooter', 'PlayStation 3', 'ps3', 7, 2012, 29.99, 'https://cdn.mobygames.com/covers/6693853-max-payne-3-playstation-3-front-cover.jpg'),
('Dark Souls', 'Embark on a challenging and atmospheric journey in Dark Souls. Face brutal enemies and overcome intricate level designs in this action RPG. With deep lore, punishing difficulty, and rewarding gameplay, Dark Souls has become a landmark title for hardcore gamers.', 'Action RPG', 'PlayStation 3', 'ps3', 7, 2011, 19.99, 'https://cdn.mobygames.com/covers/6987557-dark-souls-playstation-3-front-cover.jpg'),
('Grand Theft Auto V', 'Explore the vast open-world of Los Santos in Grand Theft Auto V. Play as three distinct protagonists and engage in heists, missions, and mayhem. With stunning visuals, a dynamic narrative, and a living, breathing game world, GTA V sets a new standard for open-world games.', 'Action-Adventure', 'PlayStation 3', 'ps3', 7, 2013, 39.99, 'https://cdn.mobygames.com/covers/6090098-grand-theft-auto-v-playstation-3-front-cover.jpg'),
('God Of War III', 'Continue the epic saga of Kratos in God Of War III. With upgraded visuals and epic set pieces, Kratos ascends Mount Olympus to confront the gods. With intense combat, breathtaking scale, and a powerful narrative, God Of War III is a masterpiece of action gaming.', 'Action-Adventure', 'PlayStation 3', 'ps3', 7, 2010, 34.99, 'https://cdn.mobygames.com/covers/5875653-god-of-war-iii-playstation-3-front-cover.jpg'),
('Battlefield 4', 'Engage in intense modern warfare in Battlefield 4. With a dynamic multiplayer experience and a gripping single-player campaign, Battlefield 4 showcases the chaos of large-scale battles. Utilize vehicles, teamwork, and strategy to emerge victorious on the battlefield.', 'First-Person Shooter', 'PlayStation 3', 'ps3', 7, 2013, 24.99, 'https://cdn.mobygames.com/covers/6731533-battlefield-4-playstation-3-front-cover.jpg'),
('God Of War (2018)', 'Experience the reimagined journey of Kratos and Atreus in God of War (2018). This action-adventure masterpiece takes you through the realms of Norse mythology, featuring epic battles, a gripping narrative, and stunning visuals. With a powerful father-son dynamic, God of War (2018) sets a new standard for storytelling in gaming.', 'Action-Adventure', 'PlayStation 4', 'ps4', 8, 2018, 49.99, 'https://cdn.mobygames.com/covers/8019897-god-of-war-playstation-4-front-cover.jpg'),
('Red Dead Redemption II', 'Immerse yourself in the vast landscapes of the American Wild West in Red Dead Redemption II. As Arthur Morgan, navigate the challenges of the Van der Linde gang and experience a narrative-rich open-world adventure. With stunning realism, deep character development, and a dynamic ecosystem, RDR2 is a true western epic.', 'Action-Adventure', 'PlayStation 4', 'ps4', 8, 2018, 59.99, 'https://cdn.mobygames.com/covers/7422709-red-dead-redemption-ii-playstation-4-front-cover.jpg'),
('Bloodborne', 'Descend into the nightmarish world of Yharnam in Bloodborne. This action RPG challenges players with fast-paced combat, eldritch horrors, and intricate level design. With its gothic atmosphere and relentless difficulty, Bloodborne captivates players seeking a dark and challenging gaming experience.', 'Action RPG', 'PlayStation 4', 'ps4', 8, 2015, 39.99, 'https://cdn.mobygames.com/covers/11078336-bloodborne-playstation-4-front-cover.jpg'),
('Sekiro', 'Master the way of the shinobi in Sekiro: Shadows Die Twice. From the developers of Dark Souls and Bloodborne, Sekiro offers intense swordplay, stealth, and a captivating feudal Japan setting. With precision combat and a focus on mastery, Sekiro provides a unique and challenging experience for players.', 'Action-Adventure', 'PlayStation 4', 'ps4', 8, 2019, 54.99, 'https://cdn.mobygames.com/covers/7868291-sekiro-shadows-die-twice-playstation-4-front-cover.jpg'),
('Doom Eternal', 'Unleash hell on Earth in Doom Eternal. This fast-paced first-person shooter puts players in the boots of the Doom Slayer as they face hordes of demons. With relentless action, dynamic weapons, and visceral combat, Doom Eternal continues the legacy of the iconic Doom series.', 'First-Person Shooter', 'PlayStation 4', 'ps4', 8, 2020, 44.99, 'https://cdn.mobygames.com/covers/8654561-doom-eternal-playstation-4-front-cover.jpg'),
('Black', 'Embark on an adrenaline-fueled journey through the shadows of covert operations in Black. As an elite operative, you navigate through intense urban environments, engaging in high-stakes gunfights and explosive scenarios. With cutting-edge graphics and a gripping narrative, Black delivers an immersive experience that blurs the line between chaos and precision.', 'First-Person Shooter', 'PlayStation 2', 'ps2', 6, 2006, 19.99, 'https://cdn.mobygames.com/covers/4359409-black-playstation-2-front-cover.jpg'),
('Grand Theft Auto: San Andreas', 'Explore the sprawling landscapes of San Andreas, a fictional state teeming with criminal opportunities. In Grand Theft Auto: San Andreas, you step into the shoes of Carl Johnson as he returns to his hometown to confront corruption, betrayal, and chaos. This open-world masterpiece allows players to engage in a gripping narrative, diverse missions, and an expansive range of criminal activities.', 'Action-Adventure', 'PlayStation 2', 'ps2', 6, 2004, 29.99, 'https://cdn.mobygames.com/covers/4554918-grand-theft-auto-san-andreas-playstation-2-front-cover.jpg'),
('God Of War II', 'Ascend the heights of Mount Olympus once again as Kratos, the God of War, in this epic sequel. God Of War II thrusts players into a world of Greek mythology, combining intense combat, intricate puzzles, and a gripping storyline. With improved graphics and an evolved combat system, Kratos seeks revenge against the gods in a quest that challenges both his strength and his humanity.', 'Action-Adventure', 'PlayStation 2', 'ps2', 6, 2007, 39.99, 'https://cdn.mobygames.com/covers/5088103-god-of-war-ii-playstation-2-front-cover.jpg'),
('Resident Evil 4', 'Witness the evolution of survival horror in Resident Evil 4, where Leon S. Kennedy faces a new breed of terror in a remote European village. Unravel the mystery behind a sinister cult and rescue the Presidents daughter from a horde of mutated beings. With a dynamic over-the-shoulder perspective, strategic combat, and atmospheric tension, Resident Evil 4 redefines the horror gaming experience.', 'Survival Horror', 'PlayStation 2', 'ps2', 6, 2005, 24.99, 'https://cdn.mobygames.com/covers/4480917-resident-evil-4-playstation-2-front-cover.jpg'),
('Shadow of the Colossus', 'Embark on a hauntingly beautiful quest in Shadow of the Colossus, a unique blend of action and exploration. As Wander, you traverse a desolate landscape on horseback, seeking to resurrect a loved one. The games innovative approach features colossal, majestic creatures as the only adversaries, each requiring careful strategy and skillful climbing. Shadow of the Colossus captivates with its emotional narrative and breathtaking environments.', 'Action-Adventure', 'PlayStation 2', 'ps2', 6, 2005, 34.99, 'https://cdn.mobygames.com/covers/4317156-shadow-of-the-colossus-playstation-2-front-cover.jpg'),
('Cuphead', 'Embark on a visually stunning and challenging adventure in Cuphead. With a unique hand-drawn art style inspired by 1930s cartoons, Cuphead offers a blend of run-and-gun action and boss battles. Team up with a friend for cooperative play and face off against imaginative foes.', 'Run and Gun', 'Xbox One', 'xbox_one', 8, 2017, 19.99, 'https://cdn.mobygames.com/covers/8808014-cuphead-windows-apps-front-cover.jpg'),
('Halo: Master Chief Collection', 'Experience the iconic Halo series in the Master Chief Collection. Relive the adventures of Master Chief in enhanced graphics and updated gameplay. With a compilation of classic Halo titles, this collection is a must-have for fans of the legendary franchise.', 'First-Person Shooter', 'Xbox One', 'xbox_one', 8, 2014, 29.99, 'https://cdn.mobygames.com/covers/8006137-halo-the-master-chief-collection-xbox-one-front-cover.jpg'),
('Wolfenstein 2: The New Colossus', 'Fight against Nazi forces in an alternate history in Wolfenstein 2: The New Colossus. As BJ Blazkowicz, lead the resistance and liberate America from the oppressive regime. With intense first-person shooting, a compelling story, and memorable characters, Wolfenstein 2 delivers a gripping experience.', 'First-Person Shooter', 'Xbox One', 'xbox_one', 8, 2017, 34.99, 'https://cdn.mobygames.com/covers/2967071-wolfenstein-ii-the-new-colossus-xbox-one-front-cover.png'),
('Devil May Cry 5', 'Step into the stylish and action-packed world of Devil May Cry 5. Play as Nero, Dante, and V in this hack-and-slash adventure to save the world from demonic threats. With fast-paced combat, impressive visuals, and a rocking soundtrack, Devil May Cry 5 is a true spectacle.', 'Hack and Slash', 'Xbox One', 'xbox_one', 8, 2019, 39.99, 'https://cdn.mobygames.com/covers/7622168-devil-may-cry-5-xbox-one-front-cover.jpg'),
('Resident Evil 2 Remake', 'Experience the horror of Raccoon City in the Resident Evil 2 Remake. Play as Leon Kennedy and Claire Redfield in this reimagining of the classic survival horror game. With stunning graphics, immersive gameplay, and terrifying encounters, Resident Evil 2 Remake is a masterpiece of the genre.', 'Survival Horror', 'Xbox One', 'xbox_one', 8, 2019, 44.99, 'https://cdn.mobygames.com/covers/7423925-resident-evil-2-xbox-one-front-cover.jpg'),
('Dirt 2', 'Experience off-road racing at its best in Dirt 2. With realistic graphics and thrilling gameplay, tackle diverse terrains and compete against skilled opponents. Dirt 2 delivers an adrenaline-pumping racing experience for off-road enthusiasts.', 'Racing', 'Xbox 360', 'xbox_360', 7, 2009, 24.99, 'https://cdn.mobygames.com/covers/5880202-dirt-2-xbox-360-front-cover.jpg'),
('Fallout 3', 'Enter the post-apocalyptic world of Fallout 3. As the Lone Wanderer, explore the desolate wasteland, encounter mutated creatures, and make impactful choices. With an open-world RPG experience, Fallout 3 immerses players in a narrative-rich and atmospheric adventure.', 'RPG', 'Xbox 360', 'xbox_360', 7, 2008, 29.99, 'https://cdn.mobygames.com/covers/5253581-fallout-3-xbox-360-front-cover.jpg'),
('Borderlands 2', 'Embark on a chaotic and loot-filled adventure in Borderlands 2. Play as one of four unique Vault Hunters, face off against the villainous Handsome Jack, and explore the wild and humor-filled world of Pandora. With cooperative multiplayer and a vast arsenal, Borderlands 2 is a must-play shooter.', 'First-Person Shooter', 'Xbox 360', 'xbox_360', 7, 2012, 19.99, 'https://cdn.mobygames.com/covers/6800173-borderlands-2-xbox-360-front-cover.jpg'),
('Left 4 Dead 2', 'Survive the zombie apocalypse with friends in Left 4 Dead 2. Team up to battle hordes of infected, explore diverse environments, and face relentless challenges. With cooperative gameplay and intense action, Left 4 Dead 2 offers a thrilling multiplayer experience.', 'First-Person Shooter', 'Xbox 360', 'xbox_360', 7, 2009, 24.99, 'https://cdn.mobygames.com/covers/5783763-left-4-dead-2-xbox-360-front-cover.jpg'),
('BioShock', 'Descend into the underwater city of Rapture in BioShock. Uncover the mysteries of this dystopian world, encounter genetically enhanced foes, and make moral choices that impact the narrative. With atmospheric storytelling and unique gameplay, BioShock is a groundbreaking first-person shooter.', 'First-Person Shooter', 'Xbox 360', 'xbox_360', 7, 2007, 14.99, 'https://cdn.mobygames.com/covers/4775148-bioshock-windows-front-cover.jpg'),
('The Elder Scrolls III: Morrowind', 'Embark on an epic journey in The Elder Scrolls III: Morrowind. As the Nerevarine, explore the vast and immersive world of Vvardenfell. With open-ended gameplay, rich lore, and a multitude of quests, Morrowind offers a deep and engrossing RPG experience.', 'RPG', 'Xbox', 'xbox', 6, 2002, 29.99, 'https://cdn.mobygames.com/covers/3950763-the-elder-scrolls-iii-morrowind-xbox-front-cover.jpg'),
('Burnout 3: Takedown', 'Experience high-speed, adrenaline-fueled racing in Burnout 3: Takedown. Take down rivals and cause spectacular crashes in this intense arcade racing game. With a variety of game modes and explosive action, Burnout 3 delivers a thrilling racing experience.', 'Racing', 'Xbox', 'xbox', 6, 2004, 19.99, 'https://cdn.mobygames.com/covers/5993314-burnout-3-takedown-xbox-front-cover.png'),
('Splinter Cell: Pandora Tomorrow', 'Step into the shoes of Sam Fisher, a skilled operative, in Splinter Cell: Pandora Tomorrow. Navigate through shadowy environments, employ stealth tactics, and thwart global threats. With tense gameplay and a gripping narrative, Pandora Tomorrow is a standout in the stealth genre.', 'Stealth', 'Xbox', 'xbox', 6, 2004, 14.99, 'https://cdn.mobygames.com/covers/7482626-tom-clancys-splinter-cell-pandora-tomorrow-xbox-front-cover.jpg'),
('Prince of Persia: The Sands of Time', 'Embark on a time-bending adventure in Prince of Persia: The Sands of Time. Unleash acrobatic moves and manipulate time to overcome challenges. With a captivating story, fluid animations, and innovative gameplay mechanics, The Sands of Time is a classic action-adventure title.', 'Action-Adventure', 'Xbox', 'xbox', 6, 2003, 24.99, 'https://cdn.mobygames.com/covers/5720222-prince-of-persia-the-sands-of-time-xbox-front-cover.png'),
('Halo: Combat Evolved', 'Enter the iconic world of Halo: Combat Evolved. As Master Chief, a super-soldier, battle the Covenant and discover the mysteries of the ringworld. With groundbreaking multiplayer and an epic single-player campaign, Halo revolutionized the first-person shooter genre.', 'First-Person Shooter', 'Xbox', 'xbox', 6, 2001, 29.99, 'https://cdn.mobygames.com/covers/3966925-halo-combat-evolved-xbox-front-cover.jpg');
-- Añadir el webp a las tablas
-- ps1
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/spyro-the-dragon-playstation.webp'
WHERE title = 'Spyro the Dragon' AND console_small_name = 'ps1';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/metal-gear-solid-playstation.webp'
WHERE title = 'Metal Gear Solid' AND console_small_name = 'ps1';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/tomb-raider-playstation.webp'
WHERE title = 'Tomb Raider' AND console_small_name = 'ps1';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/street-fighter-alpha-3-playstation.webp'
WHERE title = 'Street Fighter Alpha 3' AND console_small_name = 'ps1';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/resident-evil-2-playstation.webp'
WHERE title = 'Resident Evil 2' AND console_small_name = 'ps1';
-- ps2
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/grand-theft-auto-san-andreas-playstation-2.webp'
WHERE title = 'Grand Theft Auto: San Andreas' AND console_small_name = 'ps2';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/god-of-war-ii-playstation-2.webp'
WHERE title = 'God Of War II' AND console_small_name = 'ps2';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/shadow-of-the-colossus-playstation-2.webp'
WHERE title = 'Shadow of the Colossus' AND console_small_name = 'ps2';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/black-playstation-2.webp'
WHERE title = 'Black' AND console_small_name = 'ps2';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/resident-evil-4-playstation-2.webp'
WHERE title = 'Resident Evil 4' AND console_small_name = 'ps2';
-- ps3
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/god-of-war-iii-playstation-3.webp'
WHERE title = 'God Of War III' AND console_small_name = 'ps3';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/max-payne-3-playstation-3.webp'
WHERE title = 'Max Payne 3' AND console_small_name = 'ps3';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/battlefield-4-playstation-3.webp'
WHERE title = 'Battlefield 4' AND console_small_name = 'ps3';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/dark-souls-playstation-3.webp'
WHERE title = 'Dark Souls' AND console_small_name = 'ps3';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/grand-theft-auto-v-playstation-3.webp'
WHERE title = 'Grand Theft Auto V' AND console_small_name = 'ps3';
-- ps4
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/bloodborne-playstation-4.webp'
WHERE title = 'Bloodborne' AND console_small_name = 'ps4';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/red-dead-redemption-ii-playstation-4.webp'
WHERE title = 'Red Dead Redemption II' AND console_small_name = 'ps4';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/doom-eternal-playstation-4.webp'
WHERE title = 'Doom Eternal' AND console_small_name = 'ps4';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/god-of-war-playstation-4.webp'
WHERE title = 'God Of War (2018)' AND console_small_name = 'ps4';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/sekiro-shadows-die-twice-playstation-4.webp'
WHERE title = 'Sekiro' AND console_small_name = 'ps4';
-- xbox
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/halo-combat-evolved-xbox.webp'
WHERE title = 'Halo: Combat Evolved' AND console_small_name = 'xbox';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/burnout-3-takedown-xbox.webp'
WHERE title = 'Burnout 3: Takedown' AND console_small_name = 'xbox';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/tom-clancys-splinter-cell-pandora-tomorrow-xbox.webp'
WHERE title = 'Splinter Cell: Pandora Tomorrow' AND console_small_name = 'xbox';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/prince-of-persia-the-sands-of-time-xbox.webp'
WHERE title = 'Prince of Persia: The Sands of Time' AND console_small_name = 'xbox';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/the-elder-scrolls-iii-morrowind-xbox.webp'
WHERE title = 'The Elder Scrolls III: Morrowind' AND console_small_name = 'xbox';
-- xbox 360
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/bioshock-windows.webp'
WHERE title = 'BioShock' AND console_small_name = 'xbox_360';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/fallout-3-xbox-360.webp'
WHERE title = 'Fallout 3' AND console_small_name = 'xbox_360';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/borderlands-2-xbox-360.webp'
WHERE title = 'Borderlands 2' AND console_small_name = 'xbox_360';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/left-4-dead-2-xbox-360.webp'
WHERE title = 'Left 4 Dead 2' AND console_small_name = 'xbox_360';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/dirt-2-xbox-360.webp'
WHERE title = 'Dirt 2' AND console_small_name = 'xbox_360';
-- xbox one
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/cuphead-windows-apps.webp'
WHERE title = 'Cuphead' AND console_small_name = 'xbox_one';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/devil-may-cry-5-xbox-one.webp'
WHERE title = 'Devil May Cry 5' AND console_small_name = 'xbox_one';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/resident-evil-2-xbox-one.webp'
WHERE title = 'Resident Evil 2 Remake' AND console_small_name = 'xbox_one';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/halo-the-master-chief-collection-xbox-one.webp'
WHERE title = 'Halo: Master Chief Collection' AND console_small_name = 'xbox_one';
UPDATE games SET cover_webp = 'https://raw.githubusercontent.com/Lauta-dev/demo-api/main/demo/public/wolfenstein-ii-the-new-colossus-xbox-one.webp'
WHERE title = 'Wolfenstein 2: The New Colossus' AND console_small_name = 'xbox_one';