From c91dce4f77ae12453203f0a28b91efb6533cc095 Mon Sep 17 00:00:00 2001
From: Benedikt Peetz <benedikt.peetz@b-peetz.de>
Date: Tue, 9 Dec 2025 13:07:14 +0100
Subject: feat(rocie-server): Implement basic user handling and authentication

---
 crates/rocie-server/src/storage/migrate/sql/0->1.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'crates/rocie-server/src/storage/migrate/sql/0->1.sql')

diff --git a/crates/rocie-server/src/storage/migrate/sql/0->1.sql b/crates/rocie-server/src/storage/migrate/sql/0->1.sql
index 664f40f..e3dd879 100644
--- a/crates/rocie-server/src/storage/migrate/sql/0->1.sql
+++ b/crates/rocie-server/src/storage/migrate/sql/0->1.sql
@@ -27,6 +27,14 @@ CREATE TABLE parents (
     FOREIGN KEY(parent) REFERENCES parents(id)
 ) STRICT;
 
+-- Stores the registered users.
+CREATE TABLE users (
+    id                          TEXT UNIQUE NOT NULL PRIMARY KEY,
+    name                        TEXT UNIQUE NOT NULL,
+    password_hash               TEXT        NOT NULL,
+    description                 TEXT
+) STRICT;
+
 -- Record with barcodes were bought, and how much of this buy is already used up.
 CREATE TABLE buys (
     buy_id              TEXT    UNIQUE NOT NULL PRIMARY KEY,
-- 
cgit 1.4.1

