Add gb_create_account column to the globalblocks table
Closed, ResolvedPublic2 Estimated Story Points
Actions

Description

To implement T17273, a column is needed that allows storing whether a given global block is set to disable account creation. This can be similar to the column in core used for the same purposes but for local blocks (bl_create_account).

Acceptance criteria

Add gb_create_account column to the globalblocks table

Details

	Subject	Repo	Branch	Lines +/-
	Add gb_create_account column to the globalblocks table	mediawiki/extensions/GlobalBlocking	master	+259 -0

Customize query in gerrit

Related Objects
Search...

Status	Subtype	Assigned	Task
			Restricted Task
Resolved		kostajh	T294511 2021 Security Team wikireplicas audit
Declined		None	T284948 Raw IPs of logged-out users disclosed in wiki-replicas
In Progress		Niharika	T324492 Temporary accounts - MVP
Open		None	T326816 [Epic] Update features for temporary accounts
Open		Dreamy_Jazz	T355286 [Epic] Globally blocking a temporary account should prevent further account creations
Resolved		Dreamy_Jazz	T368949 [Epic] Implement global autoblocks from global user blocks
Resolved		None	T40648 Wiki Loves Monuments 2012 (tracking)
Duplicate		None	T42190 Anonymous only global block prevents account creation
Resolved	Feature	Dreamy_Jazz	T17273 Add "Prevent account creation" checkbox to allow global blocks which do not prevent account creation
Resolved		Dreamy_Jazz	T371685 Update Special:GlobalBlockList to display whether the active global block prevents account creation
Resolved		Dreamy_Jazz	T371625 Update the GlobalBlockLogFormatter to indicate whether a block disallows account creation
Resolved		Dreamy_Jazz	T371693 Update Special:GlobalBlock to indicate whether a block should disallow account creation
Resolved		Dreamy_Jazz	T371718 Update the globalblock API to support specifying if account creation should be blocked
Resolved		Dreamy_Jazz	T371619 Update the GlobalBlockingManager to write to the gb_create_account column
Resolved		Dreamy_Jazz	T371721 Update the 'globalblocks' query API to read the value of gb_create_account
Resolved		Dreamy_Jazz	T371604 Update the GlobalBlockLookup service to read the value of gb_create_account
Resolved		Ladsgroup	T371415 Add gb_autoblock_parent_id, gb_autoblock_enabled, and gb_create_account to the globalblocks table
Resolved		Dreamy_Jazz	T371248 Add gb_create_account column to the globalblocks table

Event Timeline

Dreamy_Jazz created this task.Jul 29 2024, 12:15 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 29 2024, 12:15 PM

Dreamy_Jazz added a project: Schema-change.Jul 29 2024, 12:15 PM

Dreamy_Jazz moved this task from Unsorted to Add / Create on the Schema-change board.

Dreamy_Jazz updated the task description. (Show Details)Jul 29 2024, 12:19 PM

Dreamy_Jazz set the point value for this task to 2.

Dreamy_Jazz moved this task from Priority Backlog to In Progress on the Trust and Safety Product Sprint (Sprint Koto (July 15 - July 26)) board.

Change #1057864 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/GlobalBlocking@master] Add gb_create_account column to the globalblocks table

https://gerrit.wikimedia.org/r/1057864

gerritbot added a project: Patch-For-Review.Jul 29 2024, 12:35 PM

Dreamy_Jazz moved this task from In Progress to Needs Review on the Trust and Safety Product Sprint (Sprint Koto (July 15 - July 26)) board.Jul 29 2024, 12:35 PM

Dreamy_Jazz added a project: DBA.

Marostegui edited projects, added Data-Persistence; removed DBA.Jul 30 2024, 7:23 AM

Marostegui added a subscriber: Ladsgroup.

Change #1057864 merged by jenkins-bot:

[mediawiki/extensions/GlobalBlocking@master] Add gb_create_account column to the globalblocks table

https://gerrit.wikimedia.org/r/1057864

Maintenance_bot removed a project: Patch-For-Review.Jul 30 2024, 2:31 PM

This change can skip QA. I will file a task to add the column in production with the columns added in T371268 to batch the alters into one ticket.

ReleaseTaggerBot added a project: MW-1.43-notes (1.43.0-wmf.17; 2024-08-06).Jul 30 2024, 3:00 PM

Dreamy_Jazz added a parent task: T371415: Add gb_autoblock_parent_id, gb_autoblock_enabled, and gb_create_account to the globalblocks table.Jul 30 2024, 6:20 PM

Add gb_create_account column to the globalblocks tableClosed, ResolvedPublic2 Estimated Story PointsActions