From 999bfa6cad76900d4550e00e8e29f0252fb006b5 Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Tue, 22 Apr 2025 22:39:58 +0500 Subject: feat: inbox system --- database.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index ec59cf8..15c73e8 100644 --- a/database.sql +++ b/database.sql @@ -55,4 +55,14 @@ CREATE TABLE IF NOT EXISTS ratings ( emote_id INTEGER NOT NULL REFERENCES emotes(id), rate INTEGER NOT NULL, rated_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP +); + +CREATE TABLE IF NOT EXISTS inbox_messages ( + id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, + recipient_id INTEGER NOT NULL REFERENCES users(id), + message_type INTEGER NOT NULL, + contents TEXT NOT NULL, + link TEXT, + sent_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP, + has_read BOOLEAN NOT NULL DEFAULT false ); \ No newline at end of file -- cgit v1.2.3