diff options
Diffstat (limited to 'migrations/20250819.php')
| -rw-r--r-- | migrations/20250819.php | 23 |
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, |
