diff options
| author | Frédéric Mangano-Tarumi <fmang@mg0.fr> | 2020-06-08 20:16:27 +0200 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2021-02-20 17:24:30 +0100 |
| commit | a5554c19a9712ede5fe5a996bd1bec11cfc9f66a (patch) | |
| tree | a9ed3b9b9c0c8db6733278fddf1c0e5ec6be8f39 /aurweb/schema.py | |
| parent | 3f31d149a6dd736007c6583a6162aeda1bcc37b8 (diff) | |
| download | aur-a5554c19a9712ede5fe5a996bd1bec11cfc9f66a.tar.gz aur-a5554c19a9712ede5fe5a996bd1bec11cfc9f66a.tar.xz | |
Add SSO account ID in table Users
This column holds a user ID issed by the single sign-on provider. For
Keycloak, it is an UUID. For more flexibility, we will be using a
standardly-sized VARCHAR field.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'aurweb/schema.py')
| -rw-r--r-- | aurweb/schema.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/aurweb/schema.py b/aurweb/schema.py index 20f3e5ce..a1d56281 100644 --- a/aurweb/schema.py +++ b/aurweb/schema.py @@ -67,6 +67,7 @@ Users = Table( Column('CommentNotify', TINYINT(1), nullable=False, server_default=text("1")), Column('UpdateNotify', TINYINT(1), nullable=False, server_default=text("0")), Column('OwnershipNotify', TINYINT(1), nullable=False, server_default=text("1")), + Column('SSOAccountID', String(255), nullable=True, unique=True), Index('UsersAccountTypeID', 'AccountTypeID'), mysql_engine='InnoDB', ) |