From de1b961fbf54601f25c54c1618f11978f6618858 Mon Sep 17 00:00:00 2001 From: Runxi Yu Date: Wed, 19 Feb 2025 20:14:20 +0800 Subject: ssh/recv, schema: Add repos.contrib_requirements --- schema.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index ee32bd6..2589a07 100644 --- a/schema.sql +++ b/schema.sql @@ -7,6 +7,7 @@ CREATE TABLE groups ( CREATE TABLE repos ( id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, group_id INTEGER NOT NULL REFERENCES groups(id) ON DELETE RESTRICT, -- I mean, should be CASCADE but deleting Git repos on disk also needs to be considered + contrib_requirements TEXT NOT NULL CHECK (contrib_requirements IN ('closed', 'registered_user', 'ssh_pubkey', 'public')), name TEXT NOT NULL, UNIQUE(group_id, name), description TEXT, -- cgit v1.2.3