From 072b4ad36a5ff1fac4411ce59e482babedb8aa93 Mon Sep 17 00:00:00 2001 From: Runxi Yu Date: Thu, 6 Mar 2025 13:23:16 +0800 Subject: sql: Add potential for recursive groups --- schema.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/schema.sql b/schema.sql index 3a84825..e1d18f8 100644 --- a/schema.sql +++ b/schema.sql @@ -3,8 +3,10 @@ CREATE TABLE groups ( id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, - name TEXT NOT NULL UNIQUE, - description TEXT + name TEXT NOT NULL, + parent_group INTEGER REFERENCES groups(id) ON DELETE CASCADE, + description TEXT, + UNIQUE NULLS NOT DISTINCT (parent_group, name) ); CREATE TABLE repos ( -- cgit v1.2.3