This is for T220791. We need to remove the old column (not used by the code anymore) and drop defaults from the new fields.
DROP INDEX /*i*/afl_filter_timestamp ON /*_*/abuse_filter_log; ALTER TABLE /*_*/abuse_filter_log DROP COLUMN afl_filter, ALTER COLUMN afl_filter_id DROP DEFAULT, ALTER COLUMN afl_global DROP DEFAULT;
- Where to run those changes: all.dblist
- When to run those changes: After deployment of wmf.2, next week
- If the schema change is backwards compatible: Yes
- 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: afl_filter should be removed from the views.
Progress
- s1
- eqiad T291719#7454162
- codfw
- s2
- eqiad T291719#7446907
- codfw
- s3
- eqiad T291719#7455211
- codfw
- s4
- eqiad
- codfw T291719#7447029
- s5
- eqiad T291719#7446902
- codfw
- s6
- eqiad T291719#7443429
- codfw
- s7
- eqiad T291719#7454959
- codfw
- s8
- eqiad T291719#7449983
- codfw