From f3bc9fd394e9efc8cc9c6408c6e94d539f05c452 Mon Sep 17 00:00:00 2001 From: ilotterytea 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