Page MenuHomePhabricator

Create DB column ce_participants.cep_hide_contribution_association_prompt in production (x1)
Closed, ResolvedPublic

Description

See parent task for details.

ALTERs to run:

ALTER TABLE /*_*/ce_participants
  ADD cep_hide_contribution_association_prompt TINYINT(1) DEFAULT 0 NOT NULL;
  1. Where to run those changes:
    1. x1.testwiki
    2. x1.test2wiki
    3. x1.officewiki
    4. x1.wikishared
  2. When to run those changes: Whenever you can
  3. If the schema change is backwards compatible: Yes (the new column has a default value and is currently unused)
  4. If the schema change has been tested already on some of the test/beta wikis: In beta
  5. if the data should be made available on the labs replicas and/or dumps: No, but we don't replicate data from x1 anyway.
  6. Is this schema change blocking a feature rollout? Yes

Details

Event Timeline

cmelo changed the task status from Open to In Progress.Nov 17 2025, 7:19 AM
cmelo claimed this task.

Change #1206070 had a related patch set uploaded (by Cmelo; author: Cmelo):

[mediawiki/extensions/CampaignEvents@master] Schema change: add participant post-edit modal opt-out flag

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

@cmelo This task uses the template for requesting a schema change in production, but we're not ready for that yet. According to https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change, we also need a separate task to design the schema change, get DBA approval, and merge it. Were you planning to create a new task or use T408460?

Daimona renamed this task from Schema change: add participant post-edit modal opt-out flag to DRAFT: Create DB column ce_participants.cep_hide_contribution_association_prompt in production (x1).Nov 26 2025, 5:06 PM
Daimona removed cmelo as the assignee of this task.
Daimona updated the task description. (Show Details)
Daimona updated the task description. (Show Details)
Daimona renamed this task from DRAFT: Create DB column ce_participants.cep_hide_contribution_association_prompt in production (x1) to Create DB column ce_participants.cep_hide_contribution_association_prompt in production (x1).Dec 10 2025, 4:03 PM
Daimona updated the task description. (Show Details)
Daimona added a project: DBA.

@Daimona is this ready? to be done? I assume so, but just double checking.

Marostegui triaged this task as Medium priority.Dec 15 2025, 6:12 AM
Marostegui moved this task from Triage to Refine on the DBA board.

@Daimona is this ready? to be done? I assume so, but just double checking.

Yup, thank you!

Change #1218238 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] filtered_tables.txt: Add new column

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

Change #1218238 merged by Marostegui:

[operations/puppet@production] filtered_tables.txt: Add new column

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