feat: add username and timestamp to messages

1 files changed, 6 insertions, 2 deletions

diff --git a/query/users.sql b/query/users.sql
index 28ca8b9..4d6275c 100644
--- a/query/users.sql
+++ b/query/users.sql
@@ -1,12 +1,16 @@
--- name: GetUser :one
+-- name: GetUserById :one
 SELECT * FROM users
 WHERE id = ?;
 
+-- name: GetUserByPublicKey :one
+SELECT * FROM users
+WHERE public_key = ?;
+
 -- name: CreateUser :one
 INSERT INTO users (
   id, name, public_key
 ) VALUES (
-  ?, 'User' || abs(random()) % 1000000, ?
+  ?, ?, ?
 )
 RETURNING *;