Change Details

`ipb_address_unique` UNIQUE index on the ipblocks table has 4 columns in production but 3 lines in `tables.sql`. The following wikis needs to be ALTERED to get that extra column, named `ipb_anon_only` removed per: https://gerrit.wikimedia.org/r/#/c/mediawiki/core/+/594292/ The following wikis need the schema change: [x] s3 ``` acewiki advisorswiki advisorywiki adywiki amwikimedia arbcom_cswiki arbcom_dewiki arbcom_enwiki arbcom_fiwiki arbcom_nlwiki arwikimedia arwikiversity arzwiki aswikisource atjwiki auditcomwiki azbwiki banwiki barwiki bclwiki bdwikimedia betawikiversity bewiki bewikimedia bewikisource bjnwiki bnwikisource bnwikivoyage boardgovcomwiki bpywiki brwikimedia brwikiquote brwikisource bswikinews bxrwiki cawikimedia cbk_zamwiki cdowiki chairwiki checkuserwiki ckbwiki cnwikimedia collabwiki cowikimedia crhwiki cswikinews cswikiversity cuwiki dewikivoyage dinwiki diqwiki dkwikimedia donatewiki dsbwiki dtywiki ecwikimedia electcomwiki elwikinews elwikiversity elwikivoyage emlwiki enwikiversity eowikinews eowikisource eswikiversity eswikivoyage etwikimedia euwikisource execwiki extwiki fawikinews fawikivoyage fdcwiki fiwikimedia fiwikinews fiwikiversity fiwikivoyage frrwiki frwikiversity frwikivoyage gagwiki ganwiki gcrwiki gewikimedia glkwiki gomwiki gorwiki grwikimedia guwikisource hakwiki hewikivoyage hifwiki hifwiktionary hiwikimedia hiwikisource hiwikiversity hiwikivoyage hsbwiki hsbwiktionary huwikinews hywikisource hywwiki id_internalwikimedia idwikimedia iegcomwiki ilwikimedia inhwiki itwikiversity itwikivoyage jamwiki jawikiversity kaawiki kabwiki kbdwiki kbpwiki koiwiki kowikinews kowikiversity krcwiki lbewiki legalteamwiki lezwiki lfnwiki liwikibooks liwikinews liwikiquote liwikisource loginwiki lrcwiki ltgwiki maiwiki maiwikimedia mdfwiki mhrwiki minwiki minwiktionary mkwikimedia mkwikisource mnwwiki movementroleswiki mrjwiki mrwikisource mwlwiki mxwikimedia myvwiki mznwiki napwikisource newwiki ngwikimedia nlwikivoyage noboard_chapterswikimedia novwiki nowikimedia nqowiki nsowiki nycwikimedia officewiki olowiki ombudsmenwiki orwikisource otrs_wikiwiki outreachwiki pa_uswikimedia pagwiki pawikisource pcdwiki pflwiki plwikivoyage pmswikisource pnbwiki pnbwiktionary pntwiki projectcomwiki pswikivoyage ptwikimedia ptwikiversity ptwikivoyage punjabiwikimedia qualitywiki roa_tarawiki romdwikimedia rowikivoyage rswikimedia ruewiki ruwikimedia ruwikiversity ruwikivoyage sahwiki sahwikiquote sahwikisource satwiki sawikiquote sawikisource sdwikinews searchcomwiki sewikimedia shnwiki shywiktionary slwikiversity sqwikinews srnwiki stewardwiki stqwiki strategywiki svwikiversity svwikivoyage szlwiki szywiki tawikinews tawikisource tcywiki techconductwiki tenwiki test2wiki testwikidatawiki tgwikibooks transitionteamwiki trwikimedia trwikinews tyvwiki uawikimedia ukwikivoyage usabilitywiki vecwikisource vecwiktionary vepwiki viwikivoyage votewiki wbwikimedia wg_enwiki wikimania2007wiki wikimania2008wiki wikimania2009wiki wikimania2010wiki wikimania2011wiki wikimania2012wiki wikimania2013wiki wikimania2014wiki wikimania2015wiki wikimania2016wiki wikimania2017wiki wikimania2018wiki wikimaniawiki wuuwiki xmfwiki yuewiktionary zeawiki zh_classicalwiki zhwikiversity zhwikivoyage ``` [] s8  `wikidatawiki` [] wikitech ** [] labswiki ** [x] labtestwiki [] mwmaint1002:/home/niharika29/P11137.txt must be removed before closing this task. alter table would be something like this: ```lang=sql ALTER TABLE /*_*/ipblocks DROP INDEX IF EXISTS /*i*/ipb_address_unique; ALTER TABLE ipblocks ADD UNIQUE INDEX IF NOT EXISTS /*i*/ipb_address_unique (ipb_address(255), ipb_user, ipb_auto); ``` ==**OLD DESCRIPTION BELOW - DO NOT USE**== Here's an example: ``` wikiadmin@10.64.32.198(fawiki)> show index from ipblocks; +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | ipblocks | 0 | PRIMARY | 1 | ipb_id | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 1 | ipb_address | A | 19209 | 255 | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 2 | ipb_user | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 3 | ipb_auto | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_user | 1 | ipb_user | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_timestamp | 1 | ipb_timestamp | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_expiry | 1 | ipb_expiry | A | 9604 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_range | 1 | ipb_range_start | A | 19209 | 20 | NULL | | BTREE | | | | ipblocks | 1 | ipb_range | 2 | ipb_range_end | A | 19209 | 20 | NULL | | BTREE | | | | ipblocks | 1 | ipb_parent_block_id | 1 | ipb_parent_block_id | A | 20 | NULL | NULL | YES | BTREE | | | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 10 rows in set (0.00 sec) ``` But as of now, the ipb_address_unique has four columns tables.sql in core (HEAD of master) and the fourth one is missing: ```lang=sql CREATE UNIQUE INDEX /*i*/ipb_address_unique ON /*_*/ipblocks (ipb_address(255), ipb_user, ipb_auto, ipb_anon_only); ``` I guess the alter table would be something like this: ```lang=sql ALTER TABLE /*_*/ipblocks DROP INDEX IF EXISTS /*i*/ipb_address_unique; ALTER TABLE ipblocks ADD UNIQUE INDEX IF NOT EXISTS /*i*/ipb_address_unique (ipb_address(255), ipb_user, ipb_auto, ipb_anon_only); ```

`ipb_address_unique` UNIQUE index on the ipblocks table has 4 columns in production but 3 lines in `tables.sql`. The following wikis needs to be ALTERED to get that extra column, named `ipb_anon_only` removed per: https://gerrit.wikimedia.org/r/#/c/mediawiki/core/+/594292/ The following wikis need the schema change: [x] s3 ``` acewiki advisorswiki advisorywiki adywiki amwikimedia arbcom_cswiki arbcom_dewiki arbcom_enwiki arbcom_fiwiki arbcom_nlwiki arwikimedia arwikiversity arzwiki aswikisource atjwiki auditcomwiki azbwiki banwiki barwiki bclwiki bdwikimedia betawikiversity bewiki bewikimedia bewikisource bjnwiki bnwikisource bnwikivoyage boardgovcomwiki bpywiki brwikimedia brwikiquote brwikisource bswikinews bxrwiki cawikimedia cbk_zamwiki cdowiki chairwiki checkuserwiki ckbwiki cnwikimedia collabwiki cowikimedia crhwiki cswikinews cswikiversity cuwiki dewikivoyage dinwiki diqwiki dkwikimedia donatewiki dsbwiki dtywiki ecwikimedia electcomwiki elwikinews elwikiversity elwikivoyage emlwiki enwikiversity eowikinews eowikisource eswikiversity eswikivoyage etwikimedia euwikisource execwiki extwiki fawikinews fawikivoyage fdcwiki fiwikimedia fiwikinews fiwikiversity fiwikivoyage frrwiki frwikiversity frwikivoyage gagwiki ganwiki gcrwiki gewikimedia glkwiki gomwiki gorwiki grwikimedia guwikisource hakwiki hewikivoyage hifwiki hifwiktionary hiwikimedia hiwikisource hiwikiversity hiwikivoyage hsbwiki hsbwiktionary huwikinews hywikisource hywwiki id_internalwikimedia idwikimedia iegcomwiki ilwikimedia inhwiki itwikiversity itwikivoyage jamwiki jawikiversity kaawiki kabwiki kbdwiki kbpwiki koiwiki kowikinews kowikiversity krcwiki lbewiki legalteamwiki lezwiki lfnwiki liwikibooks liwikinews liwikiquote liwikisource loginwiki lrcwiki ltgwiki maiwiki maiwikimedia mdfwiki mhrwiki minwiki minwiktionary mkwikimedia mkwikisource mnwwiki movementroleswiki mrjwiki mrwikisource mwlwiki mxwikimedia myvwiki mznwiki napwikisource newwiki ngwikimedia nlwikivoyage noboard_chapterswikimedia novwiki nowikimedia nqowiki nsowiki nycwikimedia officewiki olowiki ombudsmenwiki orwikisource otrs_wikiwiki outreachwiki pa_uswikimedia pagwiki pawikisource pcdwiki pflwiki plwikivoyage pmswikisource pnbwiki pnbwiktionary pntwiki projectcomwiki pswikivoyage ptwikimedia ptwikiversity ptwikivoyage punjabiwikimedia qualitywiki roa_tarawiki romdwikimedia rowikivoyage rswikimedia ruewiki ruwikimedia ruwikiversity ruwikivoyage sahwiki sahwikiquote sahwikisource satwiki sawikiquote sawikisource sdwikinews searchcomwiki sewikimedia shnwiki shywiktionary slwikiversity sqwikinews srnwiki stewardwiki stqwiki strategywiki svwikiversity svwikivoyage szlwiki szywiki tawikinews tawikisource tcywiki techconductwiki tenwiki test2wiki testwikidatawiki tgwikibooks transitionteamwiki trwikimedia trwikinews tyvwiki uawikimedia ukwikivoyage usabilitywiki vecwikisource vecwiktionary vepwiki viwikivoyage votewiki wbwikimedia wg_enwiki wikimania2007wiki wikimania2008wiki wikimania2009wiki wikimania2010wiki wikimania2011wiki wikimania2012wiki wikimania2013wiki wikimania2014wiki wikimania2015wiki wikimania2016wiki wikimania2017wiki wikimania2018wiki wikimaniawiki wuuwiki xmfwiki yuewiktionary zeawiki zh_classicalwiki zhwikiversity zhwikivoyage ``` [] s8  `wikidatawiki` [x] wikitech ** [x] labswiki ** [x] labtestwiki [] mwmaint1002:/home/niharika29/P11137.txt must be removed before closing this task. alter table would be something like this: ```lang=sql ALTER TABLE /*_*/ipblocks DROP INDEX IF EXISTS /*i*/ipb_address_unique; ALTER TABLE ipblocks ADD UNIQUE INDEX IF NOT EXISTS /*i*/ipb_address_unique (ipb_address(255), ipb_user, ipb_auto); ``` ==**OLD DESCRIPTION BELOW - DO NOT USE**== Here's an example: ``` wikiadmin@10.64.32.198(fawiki)> show index from ipblocks; +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | ipblocks | 0 | PRIMARY | 1 | ipb_id | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 1 | ipb_address | A | 19209 | 255 | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 2 | ipb_user | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 3 | ipb_auto | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_user | 1 | ipb_user | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_timestamp | 1 | ipb_timestamp | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_expiry | 1 | ipb_expiry | A | 9604 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_range | 1 | ipb_range_start | A | 19209 | 20 | NULL | | BTREE | | | | ipblocks | 1 | ipb_range | 2 | ipb_range_end | A | 19209 | 20 | NULL | | BTREE | | | | ipblocks | 1 | ipb_parent_block_id | 1 | ipb_parent_block_id | A | 20 | NULL | NULL | YES | BTREE | | | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 10 rows in set (0.00 sec) ``` But as of now, the ipb_address_unique has four columns tables.sql in core (HEAD of master) and the fourth one is missing: ```lang=sql CREATE UNIQUE INDEX /*i*/ipb_address_unique ON /*_*/ipblocks (ipb_address(255), ipb_user, ipb_auto, ipb_anon_only); ``` I guess the alter table would be something like this: ```lang=sql ALTER TABLE /*_*/ipblocks DROP INDEX IF EXISTS /*i*/ipb_address_unique; ALTER TABLE ipblocks ADD UNIQUE INDEX IF NOT EXISTS /*i*/ipb_address_unique (ipb_address(255), ipb_user, ipb_auto, ipb_anon_only); ```

`ipb_address_unique` UNIQUE index on the ipblocks table has 4 columns in production but 3 lines in `tables.sql`. The following wikis needs to be ALTERED to get that extra column, named `ipb_anon_only` removed per: https://gerrit.wikimedia.org/r/#/c/mediawiki/core/+/594292/ The following wikis need the schema change: [x] s3 ``` acewiki advisorswiki advisorywiki adywiki amwikimedia arbcom_cswiki arbcom_dewiki arbcom_enwiki arbcom_fiwiki arbcom_nlwiki arwikimedia arwikiversity arzwiki aswikisource atjwiki auditcomwiki azbwiki banwiki barwiki bclwiki bdwikimedia betawikiversity bewiki bewikimedia bewikisource bjnwiki bnwikisource bnwikivoyage boardgovcomwiki bpywiki brwikimedia brwikiquote brwikisource bswikinews bxrwiki cawikimedia cbk_zamwiki cdowiki chairwiki checkuserwiki ckbwiki cnwikimedia collabwiki cowikimedia crhwiki cswikinews cswikiversity cuwiki dewikivoyage dinwiki diqwiki dkwikimedia donatewiki dsbwiki dtywiki ecwikimedia electcomwiki elwikinews elwikiversity elwikivoyage emlwiki enwikiversity eowikinews eowikisource eswikiversity eswikivoyage etwikimedia euwikisource execwiki extwiki fawikinews fawikivoyage fdcwiki fiwikimedia fiwikinews fiwikiversity fiwikivoyage frrwiki frwikiversity frwikivoyage gagwiki ganwiki gcrwiki gewikimedia glkwiki gomwiki gorwiki grwikimedia guwikisource hakwiki hewikivoyage hifwiki hifwiktionary hiwikimedia hiwikisource hiwikiversity hiwikivoyage hsbwiki hsbwiktionary huwikinews hywikisource hywwiki id_internalwikimedia idwikimedia iegcomwiki ilwikimedia inhwiki itwikiversity itwikivoyage jamwiki jawikiversity kaawiki kabwiki kbdwiki kbpwiki koiwiki kowikinews kowikiversity krcwiki lbewiki legalteamwiki lezwiki lfnwiki liwikibooks liwikinews liwikiquote liwikisource loginwiki lrcwiki ltgwiki maiwiki maiwikimedia mdfwiki mhrwiki minwiki minwiktionary mkwikimedia mkwikisource mnwwiki movementroleswiki mrjwiki mrwikisource mwlwiki mxwikimedia myvwiki mznwiki napwikisource newwiki ngwikimedia nlwikivoyage noboard_chapterswikimedia novwiki nowikimedia nqowiki nsowiki nycwikimedia officewiki olowiki ombudsmenwiki orwikisource otrs_wikiwiki outreachwiki pa_uswikimedia pagwiki pawikisource pcdwiki pflwiki plwikivoyage pmswikisource pnbwiki pnbwiktionary pntwiki projectcomwiki pswikivoyage ptwikimedia ptwikiversity ptwikivoyage punjabiwikimedia qualitywiki roa_tarawiki romdwikimedia rowikivoyage rswikimedia ruewiki ruwikimedia ruwikiversity ruwikivoyage sahwiki sahwikiquote sahwikisource satwiki sawikiquote sawikisource sdwikinews searchcomwiki sewikimedia shnwiki shywiktionary slwikiversity sqwikinews srnwiki stewardwiki stqwiki strategywiki svwikiversity svwikivoyage szlwiki szywiki tawikinews tawikisource tcywiki techconductwiki tenwiki test2wiki testwikidatawiki tgwikibooks transitionteamwiki trwikimedia trwikinews tyvwiki uawikimedia ukwikivoyage usabilitywiki vecwikisource vecwiktionary vepwiki viwikivoyage votewiki wbwikimedia wg_enwiki wikimania2007wiki wikimania2008wiki wikimania2009wiki wikimania2010wiki wikimania2011wiki wikimania2012wiki wikimania2013wiki wikimania2014wiki wikimania2015wiki wikimania2016wiki wikimania2017wiki wikimania2018wiki wikimaniawiki wuuwiki xmfwiki yuewiktionary zeawiki zh_classicalwiki zhwikiversity zhwikivoyage ``` [] s8  `wikidatawiki` [x] wikitech ** [x] labswiki ** [x] labtestwiki [] mwmaint1002:/home/niharika29/P11137.txt must be removed before closing this task. alter table would be something like this: ```lang=sql ALTER TABLE /*_*/ipblocks DROP INDEX IF EXISTS /*i*/ipb_address_unique; ALTER TABLE ipblocks ADD UNIQUE INDEX IF NOT EXISTS /*i*/ipb_address_unique (ipb_address(255), ipb_user, ipb_auto); ``` ==**OLD DESCRIPTION BELOW - DO NOT USE**== Here's an example: ``` wikiadmin@10.64.32.198(fawiki)> show index from ipblocks; +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | ipblocks | 0 | PRIMARY | 1 | ipb_id | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 1 | ipb_address | A | 19209 | 255 | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 2 | ipb_user | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 3 | ipb_auto | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_user | 1 | ipb_user | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_timestamp | 1 | ipb_timestamp | A | 19209 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_expiry | 1 | ipb_expiry | A | 9604 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_range | 1 | ipb_range_start | A | 19209 | 20 | NULL | | BTREE | | | | ipblocks | 1 | ipb_range | 2 | ipb_range_end | A | 19209 | 20 | NULL | | BTREE | | | | ipblocks | 1 | ipb_parent_block_id | 1 | ipb_parent_block_id | A | 20 | NULL | NULL | YES | BTREE | | | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 10 rows in set (0.00 sec) ``` But as of now, the ipb_address_unique has four columns tables.sql in core (HEAD of master) and the fourth one is missing: ```lang=sql CREATE UNIQUE INDEX /*i*/ipb_address_unique ON /*_*/ipblocks (ipb_address(255), ipb_user, ipb_auto, ipb_anon_only); ``` I guess the alter table would be something like this: ```lang=sql ALTER TABLE /*_*/ipblocks DROP INDEX IF EXISTS /*i*/ipb_address_unique; ALTER TABLE ipblocks ADD UNIQUE INDEX IF NOT EXISTS /*i*/ipb_address_unique (ipb_address(255), ipb_user, ipb_auto, ipb_anon_only); ```