Page MenuHomePhabricator

Store timestamp of when an organizer agreed to the clickwrap agreement into the database
Closed, ResolvedPublic

Description

As explained in T334761, we need to record when an organizer agrees to the "clickwrap agreement" for each event. We decided that this information will be stored into a new column in the ce_organizers table. Even if the application doesn't need the timestamp at the moment, and a boolean would suffice, we decided that we're going to store the timestamp anyway in case it's needed later.

Acceptance criteria

  • A new column is added to ce_organizer to store the timestamp (or null) when the organizer agreed to the agreement.
  • The new column should be created in beta
  • The new column should be created in production
NOTE: This task is not about writing the code that populates this value; it's only about the underlying DB schema.

Event Timeline

Daimona renamed this task from Add column to ce_organizers to record if/when an organizer agreed to the clickwrap agreement to Store timestamp of when an organizer agreed to the clickwrap agreement into the database.Jun 27 2023, 3:05 PM
Daimona updated the task description. (Show Details)
Daimona updated the task description. (Show Details)

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

[mediawiki/extensions/CampaignEvents@master] Add DB field to store when organizers agreed to the PII agreement

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

Change 933665 merged by jenkins-bot:

[mediawiki/extensions/CampaignEvents@master] Add DB field to store when organizers agreed to the PII agreement

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