From de1b961fbf54601f25c54c1618f11978f6618858 Mon Sep 17 00:00:00 2001
From: Runxi Yu <me@runxiyu.org>
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

