feat: personal badges

1 files changed, 6 insertions, 0 deletions

diff --git a/database.sql b/database.sql
index 36beec8..a92ad46 100644
--- a/database.sql
+++ b/database.sql
@@ -87,6 +87,12 @@ CREATE TABLE IF NOT EXISTS badges (
     created_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
 );
 
+CREATE TABLE IF NOT EXISTS user_badges (
+    id CHAR(32) NOT NULL PRIMARY KEY DEFAULT REPLACE(UUID(),'-',''),
+    user_id CHAR(32) NOT NULL REFERENCES users(id) ON DELETE CASCADE,
+    badge_id CHAR(32) NOT NULL REFERENCES badges(id) ON DELETE CASCADE
+);
+
 CREATE TABLE IF NOT EXISTS roles (
     id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
     priority INTEGER NOT NULL DEFAULT 0,