From 0c25e3dd54225b126ad8e48e10f4fbde8ce26ec5 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Fri, 2 May 2025 18:35:09 +0500
Subject: feat: emote approval

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

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 1340d36..3f97ea3 100644
--- a/database.sql
+++ b/database.sql
@@ -105,4 +105,13 @@ CREATE TABLE IF NOT EXISTS role_assigns(
     id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
     user_id INTEGER NOT NULL UNIQUE REFERENCES users(id),
     role_id INTEGER NOT NULL REFERENCES roles(id)
+);
+
+CREATE TABLE IF NOT EXISTS mod_actions(
+    id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    user_id INTEGER NOT NULL REFERENCES users(id),
+    emote_id INTEGER NOT NULL REFERENCES emotes(id),
+    verdict INTEGER NOT NULL,
+    comment TEXT,
+    created_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
 );
\ No newline at end of file
-- 
cgit v1.2.3

