Change Details

## Summary The `abuse_filter_log` table stores IP addresses in plaintext. To allow searching by ranges these should be converted to a hex column. ## Background & Technical details - {T391322} requests that it be possible to search #AbuseFilter log entries performed by temporary accounts by the IP address used to perform the action - To achieve this we need to be able to search by the IP address column in the `abuse_filter_log` table -- The `afl_ip` column currently stores the IP as plaintext, which is not searchable -- Instead a `afl_ip_hex` column should replace `afl_ip` that stores the IP as a hexadecimal value, which can then be searched through using the same method that the #checkuser extension does -- There will be no need to keep `afl_ip` around as this would duplicate data, so removing it would be necessary to ensure that the table does not grow in disk size long term due to this change ## Acceptance criteria - [ ] The `afl_ip` column in `abuse_filter_log` is replaced with a new `afl_ip_hex` column - [ ] Code using `afl_ip` uses `afl_ip_hex` - [ ] The `afl_ip` column is removed after a migration period - [ ] Onwiki documentation for the table is updated as the migration proceeds

## Summary The `abuse_filter_log` table stores IP addresses in plaintext. To allow searching by ranges these should be converted to a hex column. ## Background & Technical details - {T391322} requests that it be possible to search #AbuseFilter log entries performed by temporary accounts by the IP address used to perform the action - To achieve this we need to be able to search by the IP address column in the `abuse_filter_log` table -- The `afl_ip` column currently stores the IP as plaintext, which is not searchable -- Instead a `afl_ip_hex` column should replace `afl_ip` that stores the IP as a hexadecimal value, which can then be searched through using the same method that the #checkuser extension does -- There will be no need to keep `afl_ip` around as this would duplicate data, so removing it would be necessary to ensure that the table does not grow in disk size long term due to this change ## Acceptance criteria - [x] The `afl_ip` column in `abuse_filter_log` is replaced with a new `afl_ip_hex` column (T395613, T397762, T397842) - [ ] Code using `afl_ip` uses `afl_ip_hex` (T397941) - [ ] The `afl_ip` column is removed after a migration period (T400280) - [ ] Onwiki documentation for the table is updated as the migration proceeds (T400280)

## Summary The `abuse_filter_log` table stores IP addresses in plaintext. To allow searching by ranges these should be converted to a hex column. ## Background & Technical details - {T391322} requests that it be possible to search #AbuseFilter log entries performed by temporary accounts by the IP address used to perform the action - To achieve this we need to be able to search by the IP address column in the `abuse_filter_log` table -- The `afl_ip` column currently stores the IP as plaintext, which is not searchable -- Instead a `afl_ip_hex` column should replace `afl_ip` that stores the IP as a hexadecimal value, which can then be searched through using the same method that the #checkuser extension does -- There will be no need to keep `afl_ip` around as this would duplicate data, so removing it would be necessary to ensure that the table does not grow in disk size long term due to this change ## Acceptance criteria - [ - [x] The `afl_ip` column in `abuse_filter_log` is replaced with a new `afl_ip_hex` column (T395613, T397762, T397842) - [ ] Code using `afl_ip` uses `afl_ip_hex` (T397941) - [ ] The `afl_ip` column is removed after a migration period (T400280) - [ ] Onwiki documentation for the table is updated as the migration proceeds (T400280)