summaryrefslogtreecommitdiffstats
path: root/aurweb
diff options
context:
space:
mode:
authorFrédéric Mangano-Tarumi <fmang@mg0.fr>2020-06-08 20:16:27 +0200
committerLukas Fleischer <lfleischer@archlinux.org>2021-02-20 17:24:30 +0100
commita5554c19a9712ede5fe5a996bd1bec11cfc9f66a (patch)
treea9ed3b9b9c0c8db6733278fddf1c0e5ec6be8f39 /aurweb
parent3f31d149a6dd736007c6583a6162aeda1bcc37b8 (diff)
downloadaur-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')
-rw-r--r--aurweb/schema.py1
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',
)