Add Role descriptions to DB

ElliottStokes / TwoRoomsAndABoom

Java SpringBoot application used to run the backend of instance of the card game Two Rooms and a Boom by Alan Gerding and Sean Mccoy

0 stars 0 forks source link

Add Role descriptions to DB #21

Closed ElliottStokes closed 4 hours ago

ElliottStokes commented 5 hours ago

Add the string containing the role description to the MySQL database to be used in the future when a user has been assigned that role they will be able to read the description from there device.

Update deployCards.sql file to:

Add a characterGuide table
Add Id as primary key.
Add description column: NOT NULL, TEXT()
Add data from the Two Rooms and a Boom character guide.
Alter card table, add column for guideId, foreign key from characterGuide table.

ElliottStokes commented 4 hours ago

Going to implement this on the front end, this will reduce the number of API requests needed to retrieve this info and the complexity of connecting each guide to the card when the instances can be matched in the frontend by using the card Title.