diff options
| author | Runxi Yu <me@runxiyu.org> | 2025-03-07 17:10:00 +0800 |
|---|---|---|
| committer | Runxi Yu <me@runxiyu.org> | 2025-03-07 17:10:21 +0800 |
| commit | 0c5f8b4b639e48176f1cbf78b732cb20d5abf0a4 (patch) | |
| tree | c91b09e3c3bb53f989b66b6edd56d96baf30aa92 /sql/schema.sql | |
| parent | hooks: Remove debug printf (diff) | |
| download | forge-0c5f8b4b639e48176f1cbf78b732cb20d5abf0a4.tar.gz forge-0c5f8b4b639e48176f1cbf78b732cb20d5abf0a4.tar.zst forge-0c5f8b4b639e48176f1cbf78b732cb20d5abf0a4.zip | |
hooks, fedauth: Add basic federated authentication for git push
Diffstat (limited to 'sql/schema.sql')
| -rw-r--r-- | sql/schema.sql | 7 |
1 files changed, 7 insertions, 0 deletions
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) +); |