Create new participant questions columns in beta DB
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Daimona
	Jun 28 2023, 9:02 PM

Description

Acceptance criteria

The new columns from T339982 and T337768 are created in beta wikishared.

Checklist

Connect via SSH
Log in #wikimedia-releng: !log Adding new columns for the CampaignEvents extension in beta wikishared # T340694
Then run the following command:

$ sql wikishared --write

ALTER TABLE ce_participants
ADD COLUMN cep_first_answer_timestamp BINARY(14) DEFAULT NULL,
ADD COLUMN cep_aggregation_timestamp BINARY(14) DEFAULT NULL;

ALTER TABLE ce_organizers
ADD COLUMN ceo_agreement_timestamp BINARY(14) DEFAULT NULL;

Related Objects
Search...

Status	Assigned	Task
Resolved	Daimona	T341392 Mark the CampaignEvents extension as stable
Resolved	cmelo	T321822 [EPIC] Participant Questions - MVP
Resolved	ifried	T334761 Clickwrap Agreement
Resolved	MHorsey-WMF	T340116 [Clickwrap] Clickwrap agreement organiser backend
Resolved	Daimona	T337768 Store timestamp of when an organizer agreed to the clickwrap agreement into the database
Resolved	Daimona	T339986 Update the "date of first answer" when a participant answers questions for the first time
Resolved	Daimona	T339982 Update the DB schema with the fields required for the "participant questions" feature
Resolved	Ladsgroup	T340695 Create new columns for the CampaignEvents extension in production
Resolved	Daimona	T340694 Create new participant questions columns in beta DB

Event Timeline

Daimona created this task.Jun 28 2023, 9:02 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 28 2023, 9:02 PM

Daimona updated the task description. (Show Details)Jun 28 2023, 9:05 PM

Daimona moved this task from Needs Input / Design in progress to Ready for development on the Campaign-Tools (Campaign-Tools-Current-Sprint) board.Jun 28 2023, 9:08 PM

Daimona added a parent task: T340695: Create new columns for the CampaignEvents extension in production .

Daimona updated the task description. (Show Details)Jun 28 2023, 9:15 PM

Mentioned in SAL (#wikimedia-releng) [2023-06-29T15:20:00Z] <Daimona> Adding new columns for the CampaignEvents extension in beta wikishared # T340694

The table definition is actually wrong -- the index should not be on cep_aggregation_timestamp. I will fix this in the code and then proceed with this task.

Daimona updated the task description. (Show Details)Jun 29 2023, 4:10 PM

Daimona moved this task from Ready for development to Blocked ⛔ on the Campaign-Tools (Campaign-Tools-Current-Sprint) board.

Daimona moved this task from Blocked ⛔ to Ready for development on the Campaign-Tools (Campaign-Tools-Current-Sprint) board.Jun 29 2023, 7:46 PM

Mentioned in SAL (#wikimedia-releng) [2023-07-04T14:42:15Z] <Daimona> Adding new columns for the CampaignEvents extension in beta wikishared # T340694

Daimona closed this task as Resolved.Jul 4 2023, 2:46 PM

Daimona claimed this task.

Daimona moved this task from Ready for development to Done 🏁 on the Campaign-Tools (Campaign-Tools-Current-Sprint) board.

Create new participant questions columns in beta DBClosed, ResolvedPublicActions