From af87dd1de0c1dd0e6284170aef807224d5c8ccb5 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Mon, 27 Oct 2025 01:38:30 +0900
Subject: feat(backend): create-user command

---
 backend/db/queries/users.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 backend/db/queries/users.sql

(limited to 'backend/db/queries/users.sql')

diff --git a/backend/db/queries/users.sql b/backend/db/queries/users.sql
new file mode 100644
index 0000000..99515d5
--- /dev/null
+++ b/backend/db/queries/users.sql
@@ -0,0 +1,14 @@
+-- name: CreateUser :one
+INSERT INTO users (username, password_hash)
+VALUES (?, ?)
+RETURNING *;
+
+-- name: GetUserByUsername :one
+SELECT id, username, password_hash, created_at
+FROM users
+WHERE username = ?;
+
+-- name: GetUserByID :one
+SELECT id, username, password_hash, created_at
+FROM users
+WHERE id = ?;
-- 
cgit v1.2.3-70-g09d2

