Page MenuHomePhabricator
Create Task
Maniphest T371415

Add gb_autoblock_parent_id, gb_autoblock_enabled, and gb_create_account to the globalblocks table
Closed, ResolvedPublic
Actions

Description

  1. ALTERs to run:
    1. https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/GlobalBlocking/+/c9a7f527c38e0e21c8751510766de4d4eb49c423/sql/mysql/patch-globalblocks-add-gb_autoblock_parent_id.sql
    2. https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/GlobalBlocking/+/c9a7f527c38e0e21c8751510766de4d4eb49c423/sql/mysql/patch-globalblocks-add-gb_create_account.sql
    3. https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/GlobalBlocking/+/c9a7f527c38e0e21c8751510766de4d4eb49c423/sql/mysql/patch-globalblocks-add-gb_enable_autoblock.sql
  2. Where to run those changes: centralauth database (s7)
  3. When to run those changes: At any time
  4. If the schema change is backwards compatible: Yes (the columns are un-used currently and appropriate defaults have been set)
  5. If the schema change has been tested already on some of the test/beta wikis: has been applied to beta cluster
  6. If the data should be made available on the labs replicas and/or dumps: No changes needed

Related Objects
Search...

StatusSubtypeAssignedTask
Restricted Task
 ResolvedkostajhT294511 2021 Security Team wikireplicas audit
 DeclinedNoneT284948 Raw IPs of logged-out users disclosed in wiki-replicas
 ResolvedNiharikaT324492 Temporary accounts - MVP
 ResolvedMadalinaT326816 [Epic] Update features for temporary accounts
 ResolvedDreamy_JazzT355286 [Epic] Globally blocking a temporary account should prevent further account creations
 ResolvedDreamy_JazzT368949 [Epic] Implement global autoblocks from global user blocks
 ResolvedNoneT40648 Wiki Loves Monuments 2012 (tracking)
 DuplicateNoneT42190 Anonymous only global block prevents account creation
 ResolvedFeatureDreamy_JazzT17273 Add "Prevent account creation" checkbox to allow global blocks which do not prevent account creation
 ResolvedDreamy_JazzT371685 Update Special:GlobalBlockList to display whether the active global block prevents account creation
 ResolvedDreamy_JazzT371625 Update the GlobalBlockLogFormatter to indicate whether a block disallows account creation
 ResolvedDreamy_JazzT371693 Update Special:GlobalBlock to indicate whether a block should disallow account creation
 ResolvedDreamy_JazzT371718 Update the globalblock API to support specifying if account creation should be blocked
 ResolvedDreamy_JazzT371619 Update the GlobalBlockingManager to write to the gb_create_account column
 ResolvedDreamy_JazzT371721 Update the 'globalblocks' query API to read the value of gb_create_account
 ResolvedDreamy_JazzT371604 Update the GlobalBlockLookup service to read the value of gb_create_account
 ResolvedLadsgroupT371415 Add gb_autoblock_parent_id, gb_autoblock_enabled, and gb_create_account to the globalblocks table
 ResolvedDreamy_JazzT371248 Add gb_create_account column to the globalblocks table
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits