Add the cec_references_delta column to ce_event_contributions
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	cmelo
	Apr 15 2026, 9:22 AM

Description

Context: We need to store references-related contribution data in CampaignEvents contributions. To support this, we are adding a new cec_references_delta field to an existing table (ce_event_contributions) through the standard schema-change workflow.

Acceptance criteria

The ce_event_contributions table gets a new cec_references_delta column (SMALLINT, nullable, DEFAULT NULL).
The column is created in beta and in production

Checklist

Design the schema
Tag this task with Schema-change
Make schema change patch for it
- https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CampaignEvents/+/1248815
Get initial reviews and DBA feedback
Merge the schema patch
- This will automatically apply the schema change in beta
Wait until the patch reaches production
Create a subtask requesting the schema change in production, following instructions in https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change (3rd bullet)
- T425582

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	New column for references delta in ce_event_contributions	mediawiki/extensions/CampaignEvents	master	+338 -0

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
In Progress	cmelo	T411681 Add references added/removed to Contributions tab
Resolved	cmelo	T423388 Add the cec_references_delta column to ce_event_contributions
Resolved	Ladsgroup	T425582 DB schema change in production - for ce_event_contributions

Event Timeline

cmelo created this task.Apr 15 2026, 9:22 AM

Restricted Application removed a project: Patch-For-Review. · View Herald TranscriptApr 15 2026, 9:22 AM

cmelo renamed this task from Add the `cec_references_delta` column to `ce_event_contributions` to Add the cec_references_delta column to ce_event_contributions.Apr 15 2026, 9:22 AM

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

[mediawiki/extensions/CampaignEvents@master] New column for references delta in ce_event_contributions

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

gerritbot added a project: Patch-For-Review.Apr 15 2026, 9:23 AM

@cmelo The checklist you copied in the task description is for creating new tables, not the one for schema changes. You can see examples of that one in T408460 and T402816 and then update this task. For the time being, I have reviewed the schema patch and I think it's ready for DBA review.

In T423388#11826205, @Daimona wrote:

@cmelo The checklist you copied in the task description is for creating new tables, not the one for schema changes. You can see examples of that one in T408460 and T402816 and then update this task. For the time being, I have reviewed the schema patch and I think it's ready for DBA review.

Thank you!

VPuffetMichel edited projects, added Connection-Team (Connection-Q4-13Apr-24Apr-2026); removed Connection-Team (Connection-Current-Sprint).Thu, Apr 16, 2:19 PM

VPuffetMichel moved this task from Upcoming / refining 💡 to Development In Progress 💻 on the Connection-Team (Connection-Q4-13Apr-24Apr-2026) board.

Restricted Application edited projects, added Connection-Team; removed Connection-Team (Connection-Q4-13Apr-24Apr-2026). · View Herald TranscriptThu, Apr 16, 2:19 PM

VPuffetMichel edited projects, added Connection-Team (Connection-Q4-13Apr-24Apr-2026); removed Connection-Team.Thu, Apr 16, 2:22 PM