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