feat: emote approval

1 files changed, 9 insertions, 0 deletions

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