From d1a804db47fe0437278c1a55e395971026b8c7f9 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Wed, 23 Apr 2025 01:19:10 +0500
Subject: feat: report system

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

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 15c73e8..c415fe3 100644
--- a/database.sql
+++ b/database.sql
@@ -65,4 +65,13 @@ CREATE TABLE IF NOT EXISTS inbox_messages (
     link TEXT,
     sent_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP,
     has_read BOOLEAN NOT NULL DEFAULT false
+);
+
+CREATE TABLE IF NOT EXISTS reports (
+    id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    sender_id INTEGER NOT NULL REFERENCES users(id),
+    contents TEXT NOT NULL,
+    sent_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP,
+    resolved_by INTEGER REFERENCES users(id),
+    response_message TEXT
 );
\ No newline at end of file
-- 
cgit v1.2.3

