Change Details

As part of changes to allow yubikey support, a schema change is needed. At https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/OATHAuth/+/496451/ the following is proposed https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/OATHAuth/+/496451/47/sql/mysql/patch-add_generic_fields.sql : ``` ALTER TABLE /*_*/oathauth_users ADD module VARCHAR( 255 ) NOT NULL, ADD data BLOB NULL; ``` **Backwards compatible:** Yes, as only new columns to be added (There's a part to remove some no longer used fields as well, but we'd want to do that later so we could revert back in case bad things happen) **Replicate to cloud:** No, table should already be blacklisted anyway **Testing:** Unable to be tested on "just" testwiki, tested locally on dev machines **When:** ASAP Please note: The oathauth_users table is a global table, so its in the centralauth database, and not all the individual wiki databases for SUL wikis. Table should be relatively small in terms of number of rows, has a PK that is the `id` column (FK of user.user_id) **Where:** [x] centralauth.oathauth_users [x] labswiki.oathauth_users [x] labtestwiki.oathauth_users **Private:** [x] advisorswiki.oathauth_users [x] arbcom_cswiki.oathauth_users [x] arbcom_dewiki.oathauth_users [x] arbcom_enwiki.oathauth_users [x] arbcom_fiwiki.oathauth_users [x] arbcom_nlwiki.oathauth_users [x] auditcomwiki.oathauth_users [x] boardgovcomwiki.oathauth_users [x] boardwiki.oathauth_users [x] chairwiki.oathauth_users [x] chapcomwiki.oathauth_users [x] checkuserwiki.oathauth_users [x] collabwiki.oathauth_users [x] ecwikimedia.oathauth_users [x] electcomwiki.oathauth_users [x] execwiki.oathauth_users [x] fdcwiki.oathauth_users [x] grantswiki.oathauth_users [x] id_internalwikimedia.oathauth_users [x] iegcomwiki.oathauth_users [x] ilwikimedia.oathauth_users [x] internalwiki.oathauth_users [x] legalteamwiki.oathauth_users [x] movementroleswiki.oathauth_users [x] noboard_chapterswikimedia.oathauth_users [x] officewiki.oathauth_users [x] ombudsmenwiki.oathauth_users [x] otrs_wikiwiki.oathauth_users [x] projectcomwiki.oathauth_users [x] searchcomwiki.oathauth_users [x] spcomwiki.oathauth_users [x] stewardwiki.oathauth_users [x] techconductwiki.oathauth_users [x] transitionteamwiki.oathauth_users [x] wg_enwiki.oathauth_users [x] wikimaniateamwiki.oathauth_users [x] zerowiki.oathauth_users **Fishbowl:** [] amwikimedia.oathauth_users [] cnwikimedia.oathauth_users [] donatewiki.oathauth_users [] fixcopyrightwiki.oathauth_users [] foundationwiki.oathauth_users [] hiwikimedia.oathauth_users [] idwikimedia.oathauth_users [] maiwikimedia.oathauth_users [] nostalgiawiki.oathauth_users [] punjabiwikimedia.oathauth_users [] romdwikimedia.oathauth_users [] rswikimedia.oathauth_users [] votewiki.oathauth_users [] wbwikimedia.oathauth_users If a #DBA could make this change, that would be awesome :)

As part of changes to allow yubikey support, a schema change is needed. At https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/OATHAuth/+/496451/ the following is proposed https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/OATHAuth/+/496451/47/sql/mysql/patch-add_generic_fields.sql : ``` ALTER TABLE /*_*/oathauth_users ADD module VARCHAR( 255 ) NOT NULL, ADD data BLOB NULL; ``` **Backwards compatible:** Yes, as only new columns to be added (There's a part to remove some no longer used fields as well, but we'd want to do that later so we could revert back in case bad things happen) **Replicate to cloud:** No, table should already be blacklisted anyway **Testing:** Unable to be tested on "just" testwiki, tested locally on dev machines **When:** ASAP Please note: The oathauth_users table is a global table, so its in the centralauth database, and not all the individual wiki databases for SUL wikis. Table should be relatively small in terms of number of rows, has a PK that is the `id` column (FK of user.user_id) **Where:** [x] centralauth.oathauth_users [x] labswiki.oathauth_users [x] labtestwiki.oathauth_users **Private:** [x] advisorswiki.oathauth_users [x] arbcom_cswiki.oathauth_users [x] arbcom_dewiki.oathauth_users [x] arbcom_enwiki.oathauth_users [x] arbcom_fiwiki.oathauth_users [x] arbcom_nlwiki.oathauth_users [x] auditcomwiki.oathauth_users [x] boardgovcomwiki.oathauth_users [x] boardwiki.oathauth_users [x] chairwiki.oathauth_users [x] chapcomwiki.oathauth_users [x] checkuserwiki.oathauth_users [x] collabwiki.oathauth_users [x] ecwikimedia.oathauth_users [x] electcomwiki.oathauth_users [x] execwiki.oathauth_users [x] fdcwiki.oathauth_users [x] grantswiki.oathauth_users [x] id_internalwikimedia.oathauth_users [x] iegcomwiki.oathauth_users [x] ilwikimedia.oathauth_users [x] internalwiki.oathauth_users [x] legalteamwiki.oathauth_users [x] movementroleswiki.oathauth_users [x] noboard_chapterswikimedia.oathauth_users [x] officewiki.oathauth_users [x] ombudsmenwiki.oathauth_users [x] otrs_wikiwiki.oathauth_users [x] projectcomwiki.oathauth_users [x] searchcomwiki.oathauth_users [x] spcomwiki.oathauth_users [x] stewardwiki.oathauth_users [x] techconductwiki.oathauth_users [x] transitionteamwiki.oathauth_users [x] wg_enwiki.oathauth_users [x] wikimaniateamwiki.oathauth_users [x] zerowiki.oathauth_users **Fishbowl:** [x] amwikimedia.oathauth_users [x] cnwikimedia.oathauth_users [x] donatewiki.oathauth_users [x] fixcopyrightwiki.oathauth_users [x] foundationwiki.oathauth_users [x] hiwikimedia.oathauth_users [x] idwikimedia.oathauth_users [x] maiwikimedia.oathauth_users [x] nostalgiawiki.oathauth_users [x] punjabiwikimedia.oathauth_users [x] romdwikimedia.oathauth_users [x] rswikimedia.oathauth_users [x] votewiki.oathauth_users [x] wbwikimedia.oathauth_users If a #DBA could make this change, that would be awesome :)