database.sql

CREATE database "plug-n-play";

-- INITIALIZE TABLES

CREATE TABLE "user" (
	"id" 								serial NOT NULL,
	"username" 					varchar(255) NOT NULL UNIQUE,
	"password" 					varchar(255) NOT NULL,
	"profile_img_path"	varchar(255),
	"access_level"			int NOT NULL,
	CONSTRAINT "user_pk" PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);

CREATE TABLE "tag" (
	"id" 		serial NOT NULL,
	"name" 	varchar(255) NOT NULL UNIQUE,
	CONSTRAINT "tag_pk" PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);

CREATE TABLE "user_tags" (
	"id" 				serial NOT NULL,
	"user_id" 	int NOT NULL,
  "tag_name"  varchar(80) NOT NULL,
	"score" 		float NOT NULL,
	CONSTRAINT "user_tags_pk" PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);

CREATE TABLE "user_genres" (
	"id"    				serial NOT NULL,
	"user_id" 	  	int REFERENCES "user" (id) NOT NULL,
	"genre_name"		varchar(80) NOT NULL,
 	"score" 	float NOT NULL,
  CONSTRAINT "user_genre_pk" PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);

CREATE TABLE "played" (
	"id" 				serial NOT NULL,
	"user_id" 	int NOT NULL,
	"game_id" 	int NOT NULL,
	"liked" 		int,
	CONSTRAINT "played_pk" PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);

CREATE TABLE "wishlist" (
	"id"			serial NOT NULL,
	"user_id" int NOT NULL,
	"game_id" int NOT NULL,
	CONSTRAINT "wishlist_pk" PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);

CREATE TABLE "ignorelist" (
	"id" 			serial NOT NULL,
	"user_id" int NOT NULL,
	"game_id" int NOT NULL,
	CONSTRAINT "ignorelist_pk" PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);

CREATE TABLE "glossary" (
	"id" 					serial NOT NULL,
	"term" 				varchar(255) NOT NULL UNIQUE,
	"description" varchar(1023),
	"img_path" 		varchar(255),
	CONSTRAINT "glossary_pk" PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);

CREATE TABLE "survey_questions" (
	"id" 			serial NOT NULL,
	"question" 		varchar(255) NOT NULL,
	"caption"		varchar(500),
	"label_left" 	varchar(30) NOT NULL,
	"label_right" 	varchar(30) NOT NULL,
	"genres_left" 	varchar(40)[],
	"genres_right"  varchar(40)[],
	"tags_left" 	varchar(40)[],
	"tags_right" 	varchar(40)[],
	"img_path" 		varchar(80),
	CONSTRAINT "survey_questions_pk" PRIMARY KEY ("id")
) WITH (
	OIDS=FALSE
);

-- FOREIGN KEY CONSTRAINTS

ALTER TABLE "user_tags" ADD CONSTRAINT "user_tags_fk0" FOREIGN KEY ("user_id") REFERENCES "user"("id");
ALTER TABLE "played" ADD CONSTRAINT "played_fk0" FOREIGN KEY ("user_id") REFERENCES "user"("id");
ALTER TABLE "wishlist" ADD CONSTRAINT "wishlist_fk0" FOREIGN KEY ("user_id") REFERENCES "user"("id");
ALTER TABLE "ignorelist" ADD CONSTRAINT "ignorelist_fk0" FOREIGN KEY ("user_id") REFERENCES "user"("id");

-- Glossary Terms
-- Add Tags
INSERT INTO "glossary" ("term")
VALUES ('2D'),('2D Platformer'),('3D'),('4X'),('8-Bit'),('Action RPG'),('Action RTS'),('Action Roguelike'),
('Action-Adventure'),('Agriculture'),('Alternate History'),('Anime'),('Atmospheric'),('Base Building'),
('Battle Royale'),('Beat ''em up'),('Blood'),('Building'),('Bullet Hell'),('CRPG'),('Card Game'),('Cartoon'),
('Character Customization'),('Choices Matter'),('Choose Your Own Adventure'),('Cinematic'),('City Builder'),
('Clicker'),('Co-op'),('Co-op Campaign'),('Colony Sim'),('Colorful'),('Comic Book'),('Competitive'),('Crafting'),
('Crime'),('Cute'),('Dark'),('Dark Comedy'),('Dating Sim'),('Deck Building'),('Demake'),('Demons'),('Difficult'),
('Drama'),('Driving'),('Dungeon Crawler'),('Dungeons & Dragons'),('Dystopian'),('Economy'),('Emotional'),('Epic'),
('Erotic'),('Exploration'),('FPS'),('Family Friendly'),('Fantasy'),('Farming'),('Fast-Paced'),('Feel Good'),
('Female Protagonist'),('First-Person'),('Fishing'),('Flight'),('Funny'),('Futuristic'),('Gambling'),('Gardening'),
('God Game'),('Gore'),('Hand-drawn'),('Historical'),('Horror'),('Hunting'),('Immersive Sim'),('Isometric'),('JRPG'),
('Job Simulator'),('LGBT'),('LGBTQ+'),('Linear'),('Local Co-Op'),('Local Multiplayer'),('Local PvP'),('Logic'),
('Loot'),('Lore-Rich'),('Lovecraftian'),('Low-poly'),('MMORPG'),('MOBA'),('Magic'),('Management'),('Manga'),
('Martial Arts'),('Mature'),('Meaningful Choices'),('Metroidvania'),('Military'),('Modern'),('Monsters'),
('Mountains'),('Multiplayer'),('Multiple Endings'),('Music'),('Mystery'),('NSFW'),('Narration'),('Narrative'),
('Noir'),('Non violent'),('Nonlinear'),('Nudity'),('Old School'),('Online Co-Op'),('Online PvP'),('Online multiplayer'),
('Open World'),('Parody'),('Partial Controller Support'),('Party Game'),('Party-Based RPG'),('Perma Death'),
('Photorealistic'),('Pixel Graphics'),('Point & Click'),('Political'),('Politics'),('Post-apocalyptic'),
('Precision Platformer'),('Procedural Generation'),('Psychological'),('Puzzle Platformer'),('PvE'),('PvP'),
('Quick-Time Events'),('RPG'),('RTS'),('Real Time Tactics'),('Realistic'),('Relaxing'),('Resource Management'),
('Retro'),('Rhythm'),('Roguelike'),('Roguelite'),('Roguevania'),('Role Playing Game'),('Sandbox'),('Satire'),
('Sci-fi'),('Score Attack'),('Sexual Content'),('Shared/Split Screen Co-op'),('Shared/Split Screen PvP'),
('Shoot ''Em Up'),('Short'),('Side Scroller'),('Side-Scrolling'),('Silent Protagonist'),('Single-player'),
('Singleplayer'),('Solo'),('Solo RPG'),('Souls-like'),('Space'),('Space Sim'),('Spectacle fighter'),('Split Screen'),
('Spooky'),('Stealth'),('Story'),('Story Rich'),('Stylized'),('Superhero'),('Supernatural'),('Superpowers'),
('Survival'),('Survival Horror'),('Tactical'),('Tactical RPG'),('Third Person'),('Third-Person Shooter'),
('Time Management'),('Time Manipulation'),('Time Travel'),('Top-Down'),('Tower Defense'),('Turn-Based'),
('Twin Stick Shooter'),('Two Players'),('Two-player'),('Unforgiving'),('Vampire'),('Violent'),('Visual Novel'),
('Walking Simulator'),('Zombies');


-- Add Genres
INSERT INTO "glossary" ("term")
VALUES ('Action'),('Indie'),('Adventure'),('Strategy'),('Shooter'),('Casual'),('Simulation'),('Puzzle'),
('Arcade'),('Platformer'),('Racing'),('Massively Multiplayer'),('Sports'),('Fighting'),('Family'),('Board Games'),
('Educational'),('Card');

-- Survey questions, captions, answer labels, and associated tags
INSERT INTO "survey_questions"
	("question", "caption", "label_left", "label_right", "genres_left", "genres_right", "tags_left", "tags_right")
	VALUES
	-- question 1:
	('Would you rather control a single character/group of characters, or control a simulation?',
	'In many games, you participate as a single character, or at most, a small team. In contrast, there are games where you a play as an abstract actor, as if you were moving pieces in a virtual board game. Perhaps you''re giving orders to an army, directing the growth of a civilization, or sowing chaos in a small suburb.',
	'Characters',
	'Simulations',
	ARRAY['action', 'indie', 'adventure', 'rpg', 'shooter', 'platformer', 'massively-multiplayer', 'fighting'],
	ARRAY['strategy', 'simulation', 'puzzle', 'sports', 'board-games', 'card'],
	ARRAY['rpg'],
	ARRAY['base-building', 'city-builder', 'clicker', 'colony-sim', 'card-game', 'deck-building', 'tower-defense']),

	-- question 2:
	('Are you mainly looking for new adventures for yourself, or do you want to bring some friends along?',
	'There are plenty of offerings for most group sizes. Many games are exclusively single-player or exclusively multiplayer, but quite a few games support both modes!',
	'Playing solo',
	'Bringing friends',
	ARRAY[]::text[],
	ARRAY['massively-multiplayer', 'fighting'],
	ARRAY['singleplayer', 'single-player', 'solo', 'solo-rpg'],
	ARRAY['multiplayer', 'two-players', 'two-player', 'battle-royale', 'pvp', 'local-co-op', 'local-multiplayer', 'local-pvp', 'split-screen']
	),
	
	-- question 3:
	('If and when playing with friends, would you like to cooperate toward a goal, or compete against each other?',
	'Cooperative games and game modes are referred to as co-op, and sometimes as PvE (Player versus Environment). Competitive game modes are often referred to as PvP (Player versus Player).',
	'I like cooperation',
	'I play to win',
	ARRAY[]::text[],
	ARRAY[]::text[],
	ARRAY['co-op', 'co-op-campaign', 'pve', 'local-co-op', 'mmo', 'mmorpg', 'online-co-op', 'online-multiplayer'],
	ARRAY['pvp', 'competitive', 'battle-royale', 'local-pvp', 'moba', 'online-pvp']
	),
	
	-- question 4:
	('Would you rather play something easy, or experience a challenge?',
	'Keep in mind that many games have adjustable difficulty settings; don''t be ashamed to adjust the difficulty to your liking.',
	'Easy',
	'Challenge',
	array['casual', 'family'],
	array['strategy', 'puzzle'],
	array['relaxing', 'family-friendly', 'walking-simulator', 'non-violent', 'party-game', 'feel-good'],
	array['souls-like', 'unforgiving', 'difficult', 'perma-death', 'roguelike', 'roguelite', 'action-roguelike']),
	
	-- question 5:
	('Do you prefer short video games over long ones?',
	'A game is generally considered short if it can be completed under 8-10 hours. Long games can take anywhere from 30 hours to hundreds to see all of their content.',
	'Short',
	'Long',
	array['casual', 'puzzle', 'board-games', 'card'],
	array['adventure', 'rpg', 'massively-multiplayer'],
	array['short'],
	array['jrpg']),
	
	-- question 6:
	('Would you like to play a game with a stylized, cartoony, or animated graphical style?',
	'As technology grows more powerful, modern games have begun to look very close to real life. Still, many games opt for a unique visual look, such as striking comic-book animation, or pixelated styles hearkening back to the early days of video games.',
	'Stylized graphics',
	'Realistic graphics',
	array[]::text[],
	array[]::text[],
	array['anime', 'manga', 'cartoon', 'stylized', 'comic-book', 'colorful', 'hand-drawn', '8-bit', 'pixel-graphics', 'retro', 'demake', 'low-poly', 'old-school'],
	array[]::text[]),
	
	-- question 7:
	('Which sounds more appealing to you: a fantasy/sci-fi setting, where advanced technology or mythical creatures could play a role; or a setting in a grounded, realistic world much like our own?',
	'Keep in mind that even games set in a fantastical world can tell stories that are touching and human.',
	'Fantasy setting',
	'Realistic setting',
	array['adventure', 'rpg', 'massively-multiplayer'],
	array[]::text[],
	array['zombies', 'western', 'vampire', 'supernatural', 'steampunk', 'space', 'space-sim', 'sci-fi', 'fantasy', 'futuristic', 'monsters'],
	array[]::text[]),
	
	-- question 8:
	('Would you like to feel fully immersed and involved in the game world, or would you rather observe characters/events from a distance?',
	'"Immersion" is one of the most difficult game terms to define. In short, some games strive to really place you in the main character''s shoes, and to create a game world that feels wondrous and alive. Others let you take more of a bird''s eye view of events, or place some distance between the player and the world.',
	'Immerse me in the world',
	'I''d like some distance',
	array[]::text[],
	array[]::text[],
	array['open-world', 'first-person', 'fps', 'atmospheric', 'sandbox', 'silent-protagonist'],
	array['god-game', 'rts', 'real-time-tactics', 'moba', 'base-building', 'city-builder', 'isometric', 'top-down']),
	
	-- question 9:
	('Would you prefer an exciting, fast-paced game that rewards movement and reaction time, or a slower, more thoughtful game that rewards planning, tactics and strategy?',
	'Fast-paced games would include first-person shooters, platformers, and racing games; slower-paced games would include strategy games, and games with turn-based combat (where you take turns with the computer-controlled enemy team).',
	'Fast-paced',
	'Slow-paced',
	array['action', 'platformer', 'fighting', 'racing', 'shooter', 'arcade', 'sports'],
	array['strategy','puzzle','simulation','card','board-games'],
	array['action-rpg', 'bullet-hell', 'fast-paced', 'fps', 'precision-platformer', 'quick-time-events', 'music', 'rhythm', 'shoot-em-up', 'beat-em-up', 'twin-stick-shooter','horror', 'survival', 'action-adventure'],
	array['crpg', 'action-rts', 'rts', 'resource-management', 'turn-based']),
	
	-- question 10:
	
	('Which sounds more appealing: a game where you repeat activities to gain better scores, gear, and abilities; or a game with a structure and a definitive ending?',
	'Many games follow a story with an explicit conclusion, or have a certain number of levels to clear. But other games don''t have a set ending point; you can continue playing and repeating activities until you''ve mastered them, or until you''ve had your fill.',
	'I want to hone my skills',
	'I want an ending',
	array['arcade', 'massively-multiplayer', 'simulation', 'card', 'board-games'],
	array['indie', 'adventure', 'action', 'rpg'],
	array['mmo', 'score-attack', 'roguelike', 'roguelite', 'roguevania'],
	array['linear', 'multiple-endings']),
	
	-- question 11:
	('Would you rather play a game where you feel powerful and have many abilities, or a game where you are weak and disempowered, and you have to beat the odds?',
	'Some players find a lot of enjoyment in satisfying combat, fluid movement, and playing a character that has a fighting chance against anything they encounter. Others prefer to have the deck stacked against them by playing a weak character, or playing against overwhelming odds, and persisting until they overcome them.',
	'I want to feel powerful',
	'I want to beat the odds',
	array['action', 'rpg', 'arcade', 'fighting'],
	array[]::text[],
	array['beat-em-up', 'superhero', 'superpowers', 'spectacle-fighter', 'action-adventure'],
	array['horror', 'survival', 'survival-horror', 'difficult', 'lovecraftian', 'spooky', 'stealth', 'unforgiving']),
	
	-- question 12:
	('Would you feel more accomplished from demonstrating your practical skills (craftsmanship, puzzle solving, etc), or your heroic skills (magic, combat abilities, etc)?',
	'It''s not all valiant knights and space wizards! There are games that let you manage a farm, run a business, power wash dirty objects, drive a delivery truck, and much more.',
	'Practical skills',
	'Heroic skills',
	array['simulation', 'educational', 'puzzle'],
	array['action', 'adventure', 'rpg', 'shooter', 'strategy', 'arcade'],
	array['argiculture', 'farming', 'gambling', 'management', 'resource-management', 'fishing', 'flight', 'driving', 'gardening', 'hunting', 'crafting', 'logic', 'puzzle-platformer'],
	array['rpg', 'magic', 'fantasy', 'loot', 'dungeon-crawler']),
	
	-- question 13:
	('Do you find the most enjoyment in feeling unrestricted and free to explore, or in having a sense of direction?',
	'Open world games allow the player access to a wide-open world, with little to no hand-holding or mandatory waypoints. These games can be very immersive, and allow the player a lot of freedom, but can sometimes lack the focus and the hand-crafted feeling of games that are divided into levels or linear experiences.',
	'Give me full freedom',
	'Give me a focused experience',
	array['adventure', 'rpg', 'massively-multiplayer'],
	array['action', 'shooter', 'platformer', 'arcade', 'racing'],
	array['open-world', 'immersive-sim', 'atmospheric', 'nonlinear', 'metroidvania', 'exploration'],
	array['linear']),
	
	-- question 14:
	('Would you like to play a game with a strong focus on story, character, and narrative?',
	'Video games have grown immensely over the past thirty years, and now rival books, movies, theater, and television in their ability to tell a compelling narrative. If you love a good story or endearing characters, there is something out there for you.',
	'I want a powerful story',
	'I don''t care about story',
	array['adventure', 'rpg'],
	array[]::text[],
	array['emotional', 'epic', 'story', 'story-rich', 'meaningful-choices', 'choices-matter', 'choose-your-own-adventure', 'dating-sim', 'walking-simulator', 'lore-rich', 'multiple-endings', 'mystery', 'narration', 'narrative', 'point-click', 'story', 'story-rich'],
	array[]::text[]),
	
	-- question 15:
	('Would you like to play a game with an intense, dark, or otherwise serious tone?',
	'The narrative tone of games can vary immensely, and the subject matter of some games can skew distinctly macabre. These games can be very compelling and thought-provoking, but can also be a huge bummer.',
	'I like dark stories',
	'I''d rather have a good time',
	array[]::text[],
	array[]::text[],
	array['emotional', 'dark', 'dark-comedy', 'crime', 'villain-protagonist', 'drama', 'dystopian', 'noir', 'horror'],
	array[]::text[]),
	
	-- question 16:
	('Would you prefer to avoid games with gory or very violent content?',
	'',
	'Yes',
	'No',
	array[]::text[],
	array[]::text[],
	array['family-friendly'],
	array['blood', 'gore', 'violent', 'horror']),
	
	-- question 17:
	('Would you prefer to avoid games with sexual or erotic content?',
	'',
	'Yes',
	'No',
	array[]::text[],
	array[]::text[],
	array[]::text[],
	array['nsfw', 'nudity', 'erotic', 'sexual-content', 'dating-sim'])
;


--Initial glossary terminology (term , description, img_path)
UPDATE "glossary" 
SET "description" = '4X is a subgenre of strategy-based computer and board games, and include both turn-based and real-time strategy titles. The gameplay involves building an empire. Emphasis is placed upon economic and technological development, as well as a range of military and non-military routes to supremacy.', "img_path" = 'https://upload.wikimedia.org/wikipedia/commons/thumb/e/ee/Freeciv-net-screenshot-2011-06-23.png/700px-Freeciv-net-screenshot-2011-06-23.png'
WHERE "term" = '4X';

UPDATE "glossary" 
SET "description" = 'A platformer, or platform video game, is one that traditionally features two-dimensional graphics in which players control characters who jump or climb between different platforms on the screen. Its a subgenre of the Action category, which is one of the many different types of video games.', "img_path" = 'https://upload.wikimedia.org/wikipedia/commons/3/38/Supertux010.jpg'
WHERE "term" = '2D Platformer';

UPDATE "glossary" 
SET "description" = 'is a subgenre of role-playing computer games traditionally characterized by a dungeon crawl through procedurally generated levels, turn-based gameplay, grid-based movement, and permanent death of the player character. Most roguelikes are based on a high fantasy narrative, reflecting their influence from tabletop role playing games such as Dungeons & Dragons.
', "img_path" = 'https://upload.wikimedia.org/wikipedia/commons/thumb/0/0c/Rogue_Screenshot.png/440px-Rogue_Screenshot.png'
WHERE "term" = 'Action Roguelike';

UPDATE "glossary" 
SET "description" = ' The true definition of the descriptor “8-bit” refers to the processors that powered consoles like the NES and Atari 7800 and has nothing to do with the graphics of the games they ran.', "img_path" = 'http://www.heypoorplayer.com/wp-content/uploads/2016/07/nesgraphics.png'
WHERE "term" = '8-Bit';

UPDATE "glossary" 
SET "description" = 'A battle royale game is an online multiplayer video game genre that blends last-man-standing gameplay with the survival, exploration and scavenging elements of a survival game. Battle royale games involve dozens to hundreds of players, who start with minimal equipment and then must eliminate all other opponents while avoiding being trapped outside of a shrinking "safe area", with the winner being the last player or team alive.', "img_path" = 'https://www.pcgamesn.com/wp-content/sites/pcgamesn/legacy/Games_Like_Fortnite_The_Best_Battle_Royale_Games.jpg'
WHERE "term" = 'Battle Royale';

UPDATE "glossary" 
SET "description" = 'the process of defining a game character or other character. Typically, a characters individual strengths and weaknesses are represented by a set of statistics. Games with a fictional setting may include traits such as race, class, or species. Games with a more contemporary or narrower setting may limit customization to physical and personality traits. This is usually used in role-playing games.', "img_path" = 'https://guides.gamepressure.com/baldurs-gate-iii/gfx/word/553624078.jpg'
WHERE "term" = 'Character Customization';

UPDATE "glossary" 
SET "description" = 'games put fun and a fast-paced experience above all else, as cars usually compete in unique ways. A key feature of arcade-style racers that specifically distinguishes them from simulation racers is their far more liberal physics.', "img_path" = 'https://www.pcgamesn.com/wp-content/sites/pcgamesn/2022/10/best-racing-games-driver-san-fransisco.jpg'
WHERE "term" = 'Driving';

UPDATE "glossary" 
SET "description" = 'informal. a computer roleplaying game in which the player controls the destiny of one or more avatars within a large virtual environment.', "img_path" = 'https://imgix.ranker.com/list_img_v2/2245/282245/original/282245-u4'
WHERE "term" = 'God Game';

UPDATE "glossary" 
SET "description" = 'Magic or mana is an attribute assigned to characters within a role-playing or video game that indicates their power to use special magical abilities or "spells". Magic is usually measured in magic points or mana points, shortened as MP. Different abilities will use up different amounts of MP.[1] When the MP of a character reaches zero, the character will not be able to use special abilities until some of their MP is recovered', "img_path" = 'https://images.gog-statics.com/a57acb0aeaed488082b245102ec7732200d9336e47be6ff91f7cde1b7464c9d9_product_card_v2_mobile_slider_639.jpg'
WHERE "term" = 'Magic';

UPDATE "glossary" 
SET "description" = 'A city-building game, or town-building game, is a genre of simulation video game where players act as the overall planner and leader of a city or town,', "img_path" = 'http://game-wisdom.com/wp-content/uploads/2012/10/Simcity.jpg'
WHERE "term" = 'City Builder';

UPDATE "glossary" 
SET "description" = 'a fast-paced game is when opposing players are constantly in active combat interaction, where things can change quickly', "img_path" = 'https://qph.cf2.quoracdn.net/main-qimg-764b543d7049128d37543940e3e4a6e1-lq'
WHERE "term" = 'Fast-Paced';

UPDATE "glossary" 
SET "description" = 'gambling game - a game that involves gambling. game of chance. gambling, gaming, play - the act of playing for stakes in the hope of winning (including the payment of a price for a chance to win a prize); "his gambling cost him a fortune"; "there was heavy play at the blackjack table', "img_path" = 'https://www.gamblingsites.org/app/uploads/2019/09/9-online-casino-games-1280x720.jpg'
WHERE "term" = 'Gambling';

UPDATE "glossary" 
SET "description" = 'Online multiplayer games connect players over a wide area network (a common example being the Internet). Unlike local multiplayer, players playing online multiplayer are not restricted to the same local network. This allows players to interact with others from a much greater distance.', "img_path" = 'https://i0.wp.com/www.pretoria.co.za/wp-content/uploads/2020/03/league-of-legends-wild-rift-e1584447048465.jpg?fit=660%2C370&ssl=1'
WHERE "term" = 'Online multiplayer';

UPDATE "glossary" 
SET "description" = '3D gaming refers to interactive computer entertainment games with characteristics of three-dimensional graphics: height, width, and depth. 3D gaming is believed to create immersive experience in a virtual worlds with realistic representations.', "img_path" = 'https://meliorgames.com/wp-content/uploads/2019/11/3-d-games.jpg'
WHERE "term" = '3D';

UPDATE "glossary" 
SET "description" = '3D gaming refers to interactive computer entertainment games with characteristics of three-dimensional graphics: height, width, and depth. 3D gaming is believed to create immersive experience in a virtual worlds with realistic representations.', "img_path" = 'https://meliorgames.com/wp-content/uploads/2019/11/3-d-games.jpg'
WHERE "term" = '3D';

UPDATE "glossary" 
SET "description" = '2D games use flat graphics, called sprites, and don''t have three-dimensional geometry. They''re drawn to the screen as flat images, and the camera (orthographic camera) has no perspective.', "img_path" = 'https://i.ytimg.com/vi/9RMvuYre7KI/maxresdefault.jpg'
WHERE "term" = '2D';