From 2ae0c2fa2a0bb5a7cd1fd9da1c6d2a6090126e67 Mon Sep 17 00:00:00 2001
From: Daniel Weipert <git@mail.dweipert.de>
Date: Fri, 19 Sep 2025 14:29:17 +0200
Subject: sending messages creates message event in database

---
 migrations/20250819.php | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

(limited to 'migrations/20250819.php')

diff --git a/migrations/20250819.php b/migrations/20250819.php
index 5e4eaa4..a0cfd19 100644
--- a/migrations/20250819.php
+++ b/migrations/20250819.php
@@ -54,3 +54,24 @@ Database::getInstance()->query(<<<SQL
     "name" varchar(255) not null
   );
 SQL);
+
+Database::getInstance()->query(<<<SQL
+  create table if not exists "room_events" (
+    "id" varchar(255) primary key,
+
+    "type" varchar(255) not null,
+    "sender" varchar(255) not null,
+
+    "origin_server_timestamp" timestamptz(3) not null,
+
+    "data" json,
+    "content" json,
+    "unsigned" json,
+
+    "previous_event_id" varchar(255),
+    "room_id" varchar(255) not null,
+
+    foreign key (previous_event_id) references room_events(id),
+    foreign key (room_id) references rooms(id)
+  );
+SQL);
-- 
cgit v1.2.3