Page MenuHomePhabricator
Create Task
Maniphest T197144

Create Schema for Partial Blocks
Closed, ResolvedPublic
Actions

Description

This task is to create/implement the schema from the proposal (See T193449).

Details

SubjectRepoBranchLines +/-
Fix missing comma on sql filemediawiki/coremaster+1 -1
Make Schema changes for Partial Blocksmediawiki/coremaster+132 -3
Customize query in gerrit

Related Objects
Search...

Event Timeline

dbarratt triaged this task as Medium priority.Jun 13 2018, 4:14 PM
dbarratt created this task.
dbarratt added a subtask: T193449: Draft a proposal for granular blocks table schema(s), submit for DBA review.
dbarratt added a parent task: T197141: Update Block APIs to list partial blocks.
• alexhollender_WMF unsubscribed.Jun 13 2018, 4:15 PM
dbarratt claimed this task.Jun 15 2018, 9:33 PM
dbarratt moved this task from Ready to In progress on the Anti-Harassment (AHT Sprint 23) board.

@TBolliger Should I assume there will be a state where a block is not a site-wide nor a partial block? or is that outside of the scope of the MVP?

• TBolliger added a comment.EditedJun 15 2018, 9:42 PM

definitely outside the scope of MVP. Eventually (soon) we'll build the ability to just block from moving pages or uploading files.

gerritbot subscribed.Jun 18 2018, 2:28 PM

Change 440871 had a related patch set uploaded (by Dbarratt; owner: Dbarratt):
[mediawiki/core@master] [WIP] Make Schema changes for Partial Blocks

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

gerritbot added a project: Patch-For-Review.Jun 18 2018, 2:28 PM
dbarratt moved this task from In progress to Review on the Anti-Harassment (AHT Sprint 23) board.Jun 18 2018, 8:03 PM
dbarratt mentioned this in T2674: Allow users to be blocked from editing a specific article or all articles inside a namespace.Jun 20 2018, 5:55 PM
• TBolliger moved this task from AHT Sprint 23 to AHT Sprint 24 on the Anti-Harassment board.Jun 20 2018, 6:56 PM
• TBolliger edited projects, added Anti-Harassment (AHT Sprint 24); removed Anti-Harassment (AHT Sprint 23).
• TBolliger moved this task from Ready to Review on the Anti-Harassment (AHT Sprint 24) board.
Liuxinyu970226 unsubscribed.Jun 20 2018, 10:51 PM
dbarratt mentioned this in T197995: Update the CI to test MediaWiki with Microsoft SQL Server & Oracle Database.Jun 23 2018, 12:05 PM
• TBolliger moved this task from AHT Sprint 24 to AHT Sprint 25 on the Anti-Harassment board.Jun 29 2018, 7:35 PM
• TBolliger edited projects, added Anti-Harassment (AHT Sprint 25); removed Anti-Harassment (AHT Sprint 24).
• TBolliger moved this task from Ready to Review on the Anti-Harassment (AHT Sprint 25) board.
David_Hedlund unsubscribed.Jun 29 2018, 8:06 PM
• Vvjjkkii renamed this task from Create Schema for Partial Blocks to 32aaaaaaaa.Jul 1 2018, 1:04 AM
• Vvjjkkii removed dbarratt as the assignee of this task.
• Vvjjkkii raised the priority of this task from Medium to High.
• Vvjjkkii added projects: CheckUser, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), Tamil-Sites, Gamepress, Hashtags, Jade, KartoEditor, Language-2018-Apr-June, New-Editor-Experiences, Mail, TCB-Team (now WMDE-TechWish).
• Vvjjkkii updated the task description. (Show Details)
• Vvjjkkii removed subscribers: gerritbot, Aklapper.
• Vvjjkkii reopened subtask T193449: Draft a proposal for granular blocks table schema(s), submit for DBA review as Open.Jul 1 2018, 1:13 AM
CommunityTechBot closed subtask T193449: Draft a proposal for granular blocks table schema(s), submit for DBA review as Resolved.Jul 1 2018, 2:06 PM
Scott renamed this task from 32aaaaaaaa to Create Schema for Partial Blocks.Jul 1 2018, 5:48 PM
Scott assigned this task to dbarratt.
Scott lowered the priority of this task from High to Medium.
Scott removed projects: TCB-Team (now WMDE-TechWish), Mail, New-Editor-Experiences, Language-2018-Apr-June, KartoEditor, Jade, Hashtags, Gamepress, Tamil-Sites, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), CheckUser.
Scott updated the task description. (Show Details)
Scott added subscribers: Aklapper, gerritbot.
Vachovec1 updated the task description. (Show Details)Jul 1 2018, 5:48 PM
• TBolliger mentioned this in T199917: RFC: Block users by page, namespace, and/or action (Partial Blocks).Jul 18 2018, 2:41 PM
• TBolliger moved this task from AHT Sprint 25 to AHT Sprint 26 on the Anti-Harassment board.Aug 1 2018, 6:32 PM
• TBolliger edited projects, added Anti-Harassment (AHT Sprint 26); removed Anti-Harassment (AHT Sprint 25).
• TBolliger moved this task from Ready to Review on the Anti-Harassment (AHT Sprint 26) board.
• TBolliger moved this task from AHT Sprint 26 to AHT Sprint 27 on the Anti-Harassment board.Aug 15 2018, 6:31 PM
• TBolliger edited projects, added Anti-Harassment (AHT Sprint 27); removed Anti-Harassment (AHT Sprint 26).
• TBolliger moved this task from Ready to Review on the Anti-Harassment (AHT Sprint 27) board.
dbarratt added a parent task: T202036: Create block restrictions related classes.Aug 16 2018, 5:21 PM
dbarratt removed a parent task: T197143: Update Special:BlockList with partial block info.
dbarratt mentioned this in T202322: Draft a proposal for multiblocks table schema(s) and get consensus.Aug 20 2018, 10:45 PM
• TBolliger moved this task from AHT Sprint 27 to AHT Sprint 28 on the Anti-Harassment board.Aug 28 2018, 6:22 PM
• TBolliger edited projects, added Anti-Harassment (AHT Sprint 28); removed Anti-Harassment (AHT Sprint 27).
• TBolliger moved this task from Ready to Review on the Anti-Harassment (AHT Sprint 28) board.
dbarratt set Due Date to Sep 10 2018, 4:00 AM.Aug 30 2018, 1:51 PM
Restricted Application changed the subtype of this task from "Task" to "Deadline". · View Herald TranscriptAug 30 2018, 1:51 PM
dbarratt mentioned this in T201853: Allow users to be blocked from creating a specific page (e.g. FIFA World Cup 3034) (aka redlink blocking).Aug 30 2018, 2:29 PM
dbarratt changed Due Date from Sep 10 2018, 4:00 AM to Sep 4 2018, 4:00 AM.Aug 30 2018, 5:51 PM
-jkb- unsubscribed.Aug 30 2018, 5:53 PM
dbarratt added a project: Schema-change.Sep 3 2018, 1:35 PM
dbarratt removed Due Date.Sep 3 2018, 8:17 PM
Restricted Application changed the subtype of this task from "Deadline" to "Task". · View Herald TranscriptSep 3 2018, 8:17 PM
gerritbot added a comment.Sep 7 2018, 10:44 PM

Change 440871 merged by jenkins-bot:
[mediawiki/core@master] Make Schema changes for Partial Blocks

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

ReleaseTaggerBot added a project: MW-1.32-notes (WMF-deploy-2018-09-18 (1.32.0-wmf.22)).Sep 7 2018, 11:00 PM
• aezell mentioned this in T204006: Execute the schema change for Partial Blocks.Sep 10 2018, 11:02 PM
gerritbot added a comment.Sep 11 2018, 7:52 PM

Change 459846 had a related patch set uploaded (by Dmaza; owner: Dmaza):
[mediawiki/core@master] Fix missing comma on sql file

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

gerritbot added a comment.Sep 11 2018, 8:47 PM

Change 459846 merged by jenkins-bot:
[mediawiki/core@master] Fix missing comma on sql file

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

dbarratt closed this task as Resolved.Sep 11 2018, 10:59 PM
dbarratt moved this task from Review to Done on the Anti-Harassment (AHT Sprint 28) board.
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