Change Details

**Context:** We would like the new columns for T339982 and T337768 to be created in production. **ALTERs to run:** ```lang=sql ALTER TABLE ce_participants ADD COLUMN cep_first_answer_timestamp BINARY(14) DEFAULT NULL AFTER cep_unregistered_at, ADD COLUMN cep_aggregation_timestamp BINARY(14) DEFAULT NULL AFTER cep_first_answer_timestamp, ADD INDEX cep_aggregation (cep_aggregation_timestamp); ALTER TABLE ce_organizers ADD COLUMN ceo_agreement_timestamp BINARY(14) DEFAULT NULL; ``` # **Where to run those changes:** These tables are in the extension1 cluster. In particular, they can be found in the per-wiki databases of testwiki, test2wiki, and officewiki, as well as in the wikishared database. So it's a total of 4 places. # **When to run those changes:** After deployment of 1.41.0-wmf.16, next week # **If the schema change is backwards compatible:** Yes (new columns are DEFAULT NULL) # **If the schema change has been tested already on some of the test/beta wikis:** Tested locally # **if the data should be made available on the labs replicas and/or dumps:** Maybe, but we don't replicate data from x1 anyway.

**Context:** We would like the new columns for T339982 and T337768 to be created in production. **ALTERs to run:** ```lang=sql ALTER TABLE ce_participants ADD COLUMN cep_first_answer_timestamp BINARY(14) DEFAULT NULL, ADD COLUMN cep_aggregation_timestamp BINARY(14) DEFAULT NULL , ADD INDEX cep_aggregation (cep_aggregation_timestamp); ALTER TABLE ce_organizers ADD COLUMN ceo_agreement_timestamp BINARY(14) DEFAULT NULL; ``` # **Where to run those changes:** These tables are in the extension1 cluster. In particular, they can be found in the per-wiki databases of testwiki, test2wiki, and officewiki, as well as in the wikishared database. So it's a total of 4 places. # **When to run those changes:** After deployment of 1.41.0-wmf.16, next week # **If the schema change is backwards compatible:** Yes (new columns are DEFAULT NULL) # **If the schema change has been tested already on some of the test/beta wikis:** Tested locally # **if the data should be made available on the labs replicas and/or dumps:** Maybe, but we don't replicate data from x1 anyway.

**Context:** We would like the new columns for T339982 and T337768 to be created in production. **ALTERs to run:** ```lang=sql ALTER TABLE ce_participants ADD COLUMN cep_first_answer_timestamp BINARY(14) DEFAULT NULL AFTER cep_unregistered_at, ADD COLUMN cep_aggregation_timestamp BINARY(14) DEFAULT NULL AFTER cep_first_answer_timestamp, ADD INDEX cep_aggregation (cep_aggregation_timestamp); ALTER TABLE ce_organizers ADD COLUMN ceo_agreement_timestamp BINARY(14) DEFAULT NULL; ``` # **Where to run those changes:** These tables are in the extension1 cluster. In particular, they can be found in the per-wiki databases of testwiki, test2wiki, and officewiki, as well as in the wikishared database. So it's a total of 4 places. # **When to run those changes:** After deployment of 1.41.0-wmf.16, next week # **If the schema change is backwards compatible:** Yes (new columns are DEFAULT NULL) # **If the schema change has been tested already on some of the test/beta wikis:** Tested locally # **if the data should be made available on the labs replicas and/or dumps:** Maybe, but we don't replicate data from x1 anyway.