Accidently deleted a badge, any way to restore it?

[Senior_Avr]

I’ve accidently deleted a badge for all users (“top contributor”). Is there a way restore it from DB?
I have yesterday’s backup and obv. I won’t restore all of it, but is there a way to SQL the backup DB and restore only that badge back? Which table(s) are related?
Thanks,
Avi

[Heliosurge (Dan DeMontmorency)]

I am not seeing this badge on my Instance. Was it a custom badge or under a different name?

---

If it is a default badge we can look it up and post the sections of the badge to copy paste with the SQL by the looks of it.

[Senior_Avr]

Hi Dan,
It was a built-in badge 4 years ago…
What could we do re SQL ?
Any hints on where to find the bange in the DB etc?
Thx,
Avi

[Heliosurge (Dan DeMontmorency)]

I am not sure. I have looked into an older 7-8 year old instance. I do not see that badge.

I think we need maybe a team member as they might have a copy of badges.

Here is an official link for badges maybe @hugh might have some ideas.

Badges reference guide

This is a reference that lists all the badges that are available in Discourse by default and what they are awarded for. Discourse awards a variety of badges to users based on their activities and contributions within the community. These badges serve both as recognition and as encouragement for community members to participate actively. In the below table, you’ll find a comprehensive list of all default badges in Discourse. Each badge is accompanied by its criteria, a detailed des…

[Moin]

Is the badge you are looking for one of the badges that the GitHub plugin adds?

discourse/discourse-github/blob/b3af042aac9b5e620dae20cf376a16e1eaf31e99/app/lib/github_badges.rb#L4-L11

I think, in contrast to the badges the solved plugin adds, you can delete these. But they are re-added after some time.