feat: inbox system

1 files changed, 10 insertions, 0 deletions

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