Change Details

Part of T318457. # **ALTERs to run:** `DROP INDEX gemm_mentor ON /*_*/growthexperiments_mentor_mentee; ALTER TABLE /*_*/growthexperiments_mentor_mentee ADD gemm_mentee_is_active TINYINT(1) DEFAULT 1 NOT NULL; CREATE INDEX gemm_mentor ON /*_*/growthexperiments_mentor_mentee ( gemm_mentor_id, gemm_mentee_is_active );`, see [patch](https://gerrit.wikimedia.org/r/c/mediawiki/extensions/GrowthExperiments/+/834637/) # **Where to run those changes:** growthexperiments.dblist # **When to run those changes:** At any time # **If the schema change is backwards compatible:** Yes. # **If the schema change has been tested already on some of the test/beta wikis:** Not tested, column is needed for a new feature deployment; will be tested as part of team QA during development, and monitored during rollout. # **if the data should be made available on the labs replicas and/or dumps:** The table only contains public data. It is [included in dumps](https://dumps.wikimedia.org/other/growthmentorship/), and the new column should be included there as well.

Part of T318457. # **ALTERs to run:** `DROP INDEX gemm_mentor ON /*_*/growthexperiments_mentor_mentee; ALTER TABLE /*_*/growthexperiments_mentor_mentee ADD gemm_mentee_is_active TINYINT(1) DEFAULT 1 NOT NULL; CREATE INDEX gemm_mentor ON /*_*/growthexperiments_mentor_mentee ( gemm_mentor_id, gemm_mentee_is_active );`, see [patch](https://gerrit.wikimedia.org/r/c/mediawiki/extensions/GrowthExperiments/+/834637/) # **Where to run those changes:** growthexperiments.dblist, per-wiki x1 databases # **When to run those changes:** At any time # **If the schema change is backwards compatible:** Yes. # **If the schema change has been tested already on some of the test/beta wikis:** Not tested, column is needed for a new feature deployment; will be tested as part of team QA during development, and monitored during rollout. # **if the data should be made available on the labs replicas and/or dumps:** The table only contains public data. It is [included in dumps](https://dumps.wikimedia.org/other/growthmentorship/), and the new column should be included there as well.

Part of T318457. # **ALTERs to run:** `DROP INDEX gemm_mentor ON /*_*/growthexperiments_mentor_mentee; ALTER TABLE /*_*/growthexperiments_mentor_mentee ADD gemm_mentee_is_active TINYINT(1) DEFAULT 1 NOT NULL; CREATE INDEX gemm_mentor ON /*_*/growthexperiments_mentor_mentee ( gemm_mentor_id, gemm_mentee_is_active );`, see [patch](https://gerrit.wikimedia.org/r/c/mediawiki/extensions/GrowthExperiments/+/834637/) # **Where to run those changes:** growthexperiments.dblist, per-wiki x1 databases # **When to run those changes:** At any time # **If the schema change is backwards compatible:** Yes. # **If the schema change has been tested already on some of the test/beta wikis:** Not tested, column is needed for a new feature deployment; will be tested as part of team QA during development, and monitored during rollout. # **if the data should be made available on the labs replicas and/or dumps:** The table only contains public data. It is [included in dumps](https://dumps.wikimedia.org/other/growthmentorship/), and the new column should be included there as well.