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; ``` (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) 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. Thus this change needs to only be made in the following databases AFAIK: [] CentralAuth [] labswiki [] labtestwiki [] foundationwiki 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 compatibile:** Yes (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) 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. [] centralauth [] labswiki [] labtestwiki [] foundationwiki [] advisorswiki [] arbcom_cswiki [] arbcom_dewiki [] arbcom_enwiki [] arbcom_fiwiki [] arbcom_nlwiki [] auditcomwiki [] boardgovcomwiki [] boardwiki [] chairwiki [] chapcomwiki [] checkuserwiki [] collabwiki [] ecwikimedia [] electcomwiki [] execwiki [] fdcwiki [] grantswiki [] id_internalwikimedia [] iegcomwiki [] ilwikimedia [] internalwiki [] legalteamwiki [] movementroleswiki [] noboard_chapterswikimedia [] officewiki [] ombudsmenwiki [] otrs_wikiwiki [] projectcomwiki [] searchcomwiki [] spcomwiki [] stewardwiki [] techconductwiki [] transitionteamwiki [] wg_enwiki [] wikimaniateamwiki [] zerowiki 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 compatibile:** Yes (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) 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. Thus this change needs to only be made in the following databases AFAIK: [] CcentralAuthauth [] labswiki [] labtestwiki [] foundationwiki [] advisorswiki [] arbcom_cswiki [] arbcom_dewiki [] arbcom_enwiki [] arbcom_fiwiki [] arbcom_nlwiki [] auditcomwiki [] boardgovcomwiki [] boardwiki [] chairwiki [] chapcomwiki [] checkuserwiki [] collabwiki [] ecwikimedia [] electcomwiki [] execwiki [] fdcwiki [] grantswiki [] id_internalwikimedia [] iegcomwiki [] ilwikimedia [] internalwiki [] legalteamwiki [] movementroleswiki [] noboard_chapterswikimedia [] officewiki [] ombudsmenwiki [] otrs_wikiwiki [] projectcomwiki [] searchcomwiki [] spcomwiki [] stewardwiki [] techconductwiki [] transitionteamwiki [] wg_enwiki [] wikimaniateamwiki [] zerowiki If a #DBA could make this change, that would be awesome :)