82ed0007436eefbd85d22eb846628c3dba4a0b89 gperez2 Fri Aug 21 13:16:52 2026 -0700 Adding ENGINE=InnoDB to gbMemberIdentity.sql, per Max's request. refs #37984 diff --git src/hg/hgLogin/gbMemberIdentity.sql src/hg/hgLogin/gbMemberIdentity.sql index e2f4e392854..dd6137c61dd 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(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) -); +) ENGINE=InnoDB;