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 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 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:** TBD (good to go now?) 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. **Where:** [] centralauth.oathauth_users [] labswiki.oathauth_users [] labtestwiki.oathauth_users [] foundationwiki.oathauth_users [] advisorswiki.oathauth_users [] arbcom_cswiki.oathauth_users [] arbcom_dewiki.oathauth_users [] arbcom_enwiki.oathauth_users [] arbcom_fiwiki.oathauth_users [] arbcom_nlwiki.oathauth_users [] auditcomwiki.oathauth_users [] boardgovcomwiki.oathauth_users [] boardwiki.oathauth_users [] chairwiki.oathauth_users [] chapcomwiki.oathauth_users [] checkuserwiki.oathauth_users [] collabwiki.oathauth_users [] ecwikimedia.oathauth_users [] electcomwiki.oathauth_users [] execwiki.oathauth_users [] fdcwiki.oathauth_users [] grantswiki.oathauth_users [] id_internalwikimedia.oathauth_users [] iegcomwiki.oathauth_users [] ilwikimedia.oathauth_users [] internalwiki.oathauth_users [] legalteamwiki.oathauth_users [] movementroleswiki.oathauth_users [] noboard_chapterswikimedia.oathauth_users [] officewiki.oathauth_users [] ombudsmenwiki.oathauth_users [] otrs_wikiwiki.oathauth_users [] projectcomwiki.oathauth_users [] searchcomwiki.oathauth_users [] spcomwiki.oathauth_users [] stewardwiki.oathauth_users [] techconductwiki.oathauth_users [] transitionteamwiki.oathauth_users [] wg_enwiki.oathauth_users [] wikimaniateamwiki.oathauth_users [] zerowiki.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 compatibile:** Yeses, 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, but we'd want to do that later so we could revert back in case bad things happentested locally on dev machines **When:** TBD (good to go now?) 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. **Where:** [] centralauth.oathauth_users [] labswiki.oathauth_users [] labtestwiki.oathauth_users [] foundationwiki.oathauth_users [] advisorswiki.oathauth_users [] arbcom_cswiki.oathauth_users [] arbcom_dewiki.oathauth_users [] arbcom_enwiki.oathauth_users [] arbcom_fiwiki.oathauth_users [] arbcom_nlwiki.oathauth_users [] auditcomwiki.oathauth_users [] boardgovcomwiki.oathauth_users [] boardwiki.oathauth_users [] chairwiki.oathauth_users [] chapcomwiki.oathauth_users [] checkuserwiki.oathauth_users [] collabwiki.oathauth_users [] ecwikimedia.oathauth_users [] electcomwiki.oathauth_users [] execwiki.oathauth_users [] fdcwiki.oathauth_users [] grantswiki.oathauth_users [] id_internalwikimedia.oathauth_users [] iegcomwiki.oathauth_users [] ilwikimedia.oathauth_users [] internalwiki.oathauth_users [] legalteamwiki.oathauth_users [] movementroleswiki.oathauth_users [] noboard_chapterswikimedia.oathauth_users [] officewiki.oathauth_users [] ombudsmenwiki.oathauth_users [] otrs_wikiwiki.oathauth_users [] projectcomwiki.oathauth_users [] searchcomwiki.oathauth_users [] spcomwiki.oathauth_users [] stewardwiki.oathauth_users [] techconductwiki.oathauth_users [] transitionteamwiki.oathauth_users [] wg_enwiki.oathauth_users [] wikimaniateamwiki.oathauth_users [] zerowiki.oathauth_users If a #DBA could make this change, that would be awesome :)