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