f85553903a3f87b3029f94e49f0a7d1bb805445b max Mon Aug 3 12:52:33 2026 -0700 hgLogin: configurable OIDC providers, GitHub login, top-level email-link button, sign-in wording. refs #37984 diff --git src/hg/hgLogin/gbMemberIdentity.sql src/hg/hgLogin/gbMemberIdentity.sql index 393a2dddfdf..e2f4e392854 100644 --- src/hg/hgLogin/gbMemberIdentity.sql +++ src/hg/hgLogin/gbMemberIdentity.sql @@ -1,16 +1,16 @@ # gbMemberIdentity - links a gbMembers account to one or more external OAuth/OpenID # identities (Google, ORCID). A single gbMembers account may have several rows here # (e.g. one Google and one ORCID). Created automatically at runtime by hgLogin; this # file is kept for reference and manual setup. CREATE TABLE gbMemberIdentity ( idx int unsigned NOT NULL, # gbMembers.idx of the linked account - provider varchar(16) NOT NULL, # Identity provider: 'google' or 'orcid' + provider varchar(64) NOT NULL, # Identity provider short name: google, orcid, github, ... subject varchar(255) NOT NULL, # Stable unique subject id from the provider email varchar(255) NOT NULL default '', # Email reported by provider at last login created DATETIME NOT NULL, # Date this identity link was created lastUse DATETIME NOT NULL, # Date this identity was last used to log in #Indices UNIQUE KEY provSub (provider, subject), INDEX(idx) );