From 0c5f8b4b639e48176f1cbf78b732cb20d5abf0a4 Mon Sep 17 00:00:00 2001
From: Runxi Yu <me@runxiyu.org>
Date: Fri, 7 Mar 2025 17:10:00 +0800
Subject: hooks, fedauth: Add basic federated authentication for git push

---
 sql/schema.sql | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'sql/schema.sql')

diff --git a/sql/schema.sql b/sql/schema.sql
index d637aa3..1a038ae 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -89,3 +89,10 @@ CREATE TABLE user_group_roles (
 	user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
 	PRIMARY KEY(user_id, group_id)
 );
+
+CREATE TABLE federated_identities (
+	user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
+	service TEXT NOT NULL,
+	remote_username TEXT NOT NULL,
+	PRIMARY KEY(user_id, service)
+);
-- 
cgit v1.2.3

