From 21593231a0e7de30004a8b4530047b4ad4680db7 Mon Sep 17 00:00:00 2001
From: Daniel Weipert <git@mail.dweipert.de>
Date: Thu, 16 Apr 2026 15:39:21 +0200
Subject: implement against element

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

(limited to 'migrations')

diff --git a/migrations/20250819.php b/migrations/20250819.php
index 3476081..6e3c59b 100644
--- a/migrations/20250819.php
+++ b/migrations/20250819.php
@@ -19,6 +19,29 @@ Database::getInstance()->query(<<<SQL
   );
 SQL);
 
+Database::getInstance()->query(<<<SQL
+  create table if not exists "account_data" (
+    "key" text not null,
+    "value" jsonb not null,
+
+    "user_id" text references users(id) not null,
+
+    primary key (user_id, key)
+  );
+SQL);
+
+Database::getInstance()->query(<<<SQL
+  create table if not exists "room_account_data" (
+    "key" text not null,
+    "value" jsonb not null,
+
+    "user_id" text references users(id) not null,
+    "room_id" text references rooms(id) not null,
+
+    primary key (user_id, room_id, key)
+  );
+SQL);
+
 Database::getInstance()->query(<<<SQL
   create table if not exists "devices" (
     "id" varchar(255) not null,
-- 
cgit v1.2.3