What would the best / most efficient way to incorporate an achievement system be for a MySQL database?
I have a users table with users in it.
Should I make a whole new table for achievements called "achievements"?
How would I most efficiently link this table to the users table? A user needs to earn the achievement so it's either unearned or earned. By default, it's unearned. There are over 100 achievements.
Just need ideas. Thanks so much guys.