From 5fe93e048c3f529c80d2d1adb1e49eafebc1af3c Mon Sep 17 00:00:00 2001
From: René 'Necoro' Neumann <necoro@necoro.eu>
Date: Sat, 12 Oct 2024 00:26:17 +0200
Subject: Sort categories on loading

---
 sql/categories.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'sql/categories.sql')

diff --git a/sql/categories.sql b/sql/categories.sql
index 2c8e5c7..e7d9579 100644
--- a/sql/categories.sql
+++ b/sql/categories.sql
@@ -1,4 +1,5 @@
--- name: GetCategories :many
+-- name: GetCategoriesOrdered :many
 SELECT id, name
   FROM categories
- WHERE user_id = $1;
\ No newline at end of file
+ WHERE user_id = $1
+ ORDER BY name ASC;
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2

