From 0c5f8b4b639e48176f1cbf78b732cb20d5abf0a4 Mon Sep 17 00:00:00 2001 From: Runxi Yu 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') 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