From e505d127c7033ad3a91f7b298322edd2d471816b Mon Sep 17 00:00:00 2001
From: Thomas Voss <mail@thomasvoss.com>
Date: Fri, 13 Jun 2025 22:16:32 +0200
Subject: Add a translates field to users

---
 src/dbx/sql/000-genesis.sql |  9 +++++----
 src/dbx/users.go            | 16 +++++++++-------
 2 files changed, 14 insertions(+), 11 deletions(-)

(limited to 'src')

diff --git a/src/dbx/sql/000-genesis.sql b/src/dbx/sql/000-genesis.sql
index 327ff58..0f84fb0 100644
--- a/src/dbx/sql/000-genesis.sql
+++ b/src/dbx/sql/000-genesis.sql
@@ -38,8 +38,9 @@ CREATE TABLE mintages_c (
 );
 
 CREATE TABLE users (
-	email    TEXT COLLATE BINARY,
-	username TEXT COLLATE BINARY,
-	password TEXT COLLATE BINARY,
-	adminp   INTEGER
+	email      TEXT COLLATE BINARY,
+	username   TEXT COLLATE BINARY,
+	password   TEXT COLLATE BINARY,
+	adminp     INTEGER,
+	translates TEXT COLLATE BINARY,
 );
\ No newline at end of file
diff --git a/src/dbx/users.go b/src/dbx/users.go
index d8305f8..e2270db 100644
--- a/src/dbx/users.go
+++ b/src/dbx/users.go
@@ -9,10 +9,11 @@ import (
 )
 
 type User struct {
-	Email    string `db:"email"`
-	Username string `db:"username"`
-	Password string `db:"password"`
-	AdminP   bool   `db:"adminp"`
+	Email      string `db:"email"`
+	Username   string `db:"username"`
+	Password   string `db:"password"`
+	AdminP     bool   `db:"adminp"`
+	Translates string `db:"translates"`
 }
 
 var LoginFailed = errors.New("No user with the given username and password")
@@ -31,9 +32,10 @@ func CreateUser(user User) error {
 			email,
 			username,
 			password,
-			adminp
-		) VALUES (?, ?, ?, ?)
-	`, user.Email, user.Username, string(hash), user.AdminP)
+			adminp,
+			translates
+		) VALUES (?, ?, ?, ?, ?)
+	`, user.Email, user.Username, string(hash), user.AdminP, user.Translates)
 	return err
 }
 
-- 
cgit v1.2.3