summaryrefslogtreecommitdiff
path: root/migrations/20250819.php
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/20250819.php')
-rw-r--r--migrations/20250819.php23
1 files changed, 23 insertions, 0 deletions
diff --git a/migrations/20250819.php b/migrations/20250819.php
index 3476081..6e3c59b 100644
--- a/migrations/20250819.php
+++ b/migrations/20250819.php
@@ -20,6 +20,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,
"name" varchar(255) not null,