From f3bc9fd394e9efc8cc9c6408c6e94d539f05c452 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Tue, 22 Apr 2025 14:16:52 +0500
Subject: feat: ratings

---
 database.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 5585a93..ec59cf8 100644
--- a/database.sql
+++ b/database.sql
@@ -47,4 +47,12 @@ CREATE TABLE IF NOT EXISTS acquired_emote_sets (
     user_id INTEGER NOT NULL,
     emote_set_id INTEGER NOT NULL,
     is_default BOOLEAN NOT NULL DEFAULT false
+);
+
+CREATE TABLE IF NOT EXISTS ratings (
+    id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    user_id INTEGER NOT NULL REFERENCES users(id),
+    emote_id INTEGER NOT NULL REFERENCES emotes(id),
+    rate INTEGER NOT NULL,
+    rated_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
 );
\ No newline at end of file
-- 
cgit v1.2.3

