From f7dde29539536a67687cbeff9662a9617e077150 Mon Sep 17 00:00:00 2001
From: Runxi Yu <me@runxiyu.org>
Date: Mon, 18 Aug 2025 03:12:41 +0800
Subject: Make the index page work

---
 forged/sql/queries/groups.sql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'forged/sql/queries/groups.sql')

diff --git a/forged/sql/queries/groups.sql b/forged/sql/queries/groups.sql
index 07fe5e7..5b48fc4 100644
--- a/forged/sql/queries/groups.sql
+++ b/forged/sql/queries/groups.sql
@@ -1,3 +1,6 @@
+-- name: GetRootGroups :many
+SELECT name, COALESCE(description, '') FROM groups WHERE parent_group IS NULL;
+
 -- name: GetGroupIDDescByPath :one
 WITH RECURSIVE group_path_cte AS (
 	SELECT
-- 
cgit v1.2.3

