From d08f4c83470c25d35d24594bd73e4effdac191a0 Mon Sep 17 00:00:00 2001
From: Daniel Weipert <git@mail.dweipert.de>
Date: Tue, 19 Aug 2025 15:50:42 +0200
Subject: database migrations and models for users, devices, tokens

---
 migrations/20250819.php | 45 +++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 45 insertions(+)
 create mode 100644 migrations/20250819.php

(limited to 'migrations/20250819.php')

diff --git a/migrations/20250819.php b/migrations/20250819.php
new file mode 100644
index 0000000..cfd0f65
--- /dev/null
+++ b/migrations/20250819.php
@@ -0,0 +1,45 @@
+<?php
+
+use App\Database;
+
+Database::getInstance()->query(<<<SQL
+  create table if not exists "migrations" (
+    "id" bigserial primary key,
+    "name" varchar(64) not null
+  );
+SQL);
+
+Database::getInstance()->query(<<<SQL
+  create table if not exists "users" (
+    "id" varchar(255) primary key,
+    "password" varchar(255),
+
+    "name" varchar(255),
+    "is_deactivated" bool
+  );
+SQL);
+
+Database::getInstance()->query(<<<SQL
+  create table if not exists "devices" (
+    "id" varchar(255) not null,
+    "name" varchar(255) not null,
+
+    "user_id" varchar(255) references users(id) not null,
+
+    primary key (user_id, id)
+  );
+SQL);
+
+Database::getInstance()->query(<<<SQL
+  create table if not exists "tokens" (
+    "id" bigserial primary key,
+
+    "access_token" varchar(255) not null,
+    "refresh_token" varchar(255) not null,
+
+    "user_id" varchar(255) not null,
+    "device_id" varchar(255),
+
+    foreign key (user_id, device_id) references devices(user_id, id)
+  );
+SQL);
-- 
cgit v1.2.3