From 999bfa6cad76900d4550e00e8e29f0252fb006b5 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
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

