Page MenuHomePhabricator

Add the campaign_events.event_answers_status column in beta DB
Closed, ResolvedPublic

Description

Acceptance criteria

  • The new column for T341142 is created in beta wikishared.

Checklist

  • Wait for the patch which adds the new column to be merged
  • Create the column with default in beta:
    • Connect via SSH
    • Log in #wikimedia-releng: !log Adding new column for the CampaignEvents extension in beta wikishared # T341642
    • Then run the following command:
$ sql wikishared --write
ALTER TABLE campaign_events ADD COLUMN event_answers_status INT DEFAULT 0 NOT NULL;
  • Wait for the patch which drops the default to be merged
  • Drop the default value in beta:
    • Connect via SSH
    • Log in #wikimedia-releng: !log Dropping default from campaign_events.event_answers_status column in beta wikishared # T341642
    • Then run the following command:
$ sql wikishared --write
ALTER TABLE campaign_events ALTER COLUMN event_answers_status DROP DEFAULT;

Event Timeline

Daimona renamed this task from Add the campaign_events.event_answers_status in beta DB to Add the campaign_events.event_answers_status column in beta DB.Jul 11 2023, 11:55 PM

Mentioned in SAL (#wikimedia-releng) [2023-07-12T11:47:06Z] <Daimona> Adding new column for the CampaignEvents extension in beta wikishared # T341642

Mentioned in SAL (#wikimedia-releng) [2023-07-14T13:10:25Z] <Daimona> Dropping default from campaign_events.event_answers_status column in beta wikishared # T341642

Daimona updated the task description. (Show Details)