Page MenuHomePhabricator

Update DB schema to store whether contribution tracking is enabled for a given event
Closed, ResolvedPublic

Description

Context: Organizers can choose whether to enable contribution tracking, if their event qualifies (as defined in the parent task). This information needs to be stored into the database. We first considered implementing this as a new tracking tool, similar to the P&E Dashboard. However, we then decided to use an ad-hoc boolean flag instead, see details in T402468#11109118. This task tracks the associated schema change.

Acceptance criteria

  • The campaign_events table gets a new boolean column that stores whether contribution tracking is enabled for that event.
  • The column is created in beta and in production

Checklist

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Change #1181730 had a related patch set uploaded (by Daimona Eaytoy; author: Daimona Eaytoy):

[mediawiki/extensions/CampaignEvents@master] db: Add campaign_events.event_track_contributions column

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

Daimona added a project: DBA.

Tagging DBA for review / heads-up. I will make a subtask for applying the schema in production once we get approval here and the patch is merged. Like T402659, this is not super urgent.

Has DBA sign off. It's straightforward.

Change #1181730 merged by jenkins-bot:

[mediawiki/extensions/CampaignEvents@master] db: Add campaign_events.event_track_contributions column

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

vaughnwalters subscribed.

✅ The campaign_events table gets a new boolean column that stores whether contribution tracking is enabled for that event.
✅ The column is created in beta and in production

beta
Screenshot 2025-09-23 at 2.52.39 PM.png (866×1 px, 246 KB)
Screenshot 2025-09-23 at 3.00.48 PM.png (242×1 px, 57 KB)
prod
Screenshot 2025-09-23 at 3.02.46 PM.png (928×1 px, 109 KB)

sending to product sign off