feat: report system

1 files changed, 9 insertions, 0 deletions

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