Summary
We need a column in the globalblocks table to store whether a user has email access globally disabled via a global block.
Background
- See T401293: Global blocking should have an option to disable sending email for context behind this feature
- We need a column to store whether the email access is disabled via a global block, which should be a mwtinyint acting as a boolean
Proposed schema changes
Addition of the gb_block_email field which is set to 0 by default (to not block email access):
+------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------------+------------------+------+-----+---------+----------------+ | gb_id | int(10) unsigned | NO | PRI | NULL | auto_increment | ... | gb_block_email | tinyint(1) | NO | | 0 | | +------------------------+------------------+------+-----+---------+----------------+
Acceptance criteria
- The column exists in the schema on the master branch of GlobalBlocking
- A Schema-change-in-production ticket is filed to make the change on WMF wikis - T413198