Change Details

## Summary The `abuse_filter_log` table has a new `afl_ip_hex` column. We should populate it using the values from `afl_ip` to assist in the migration described at {T395612} ## 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 -- This involves populating this new `afl_ip_hex` column for pre-existing entries, which will be the focus of this task. This will be done via a maintenance script run in `update.php`. --- We only need to populate `afl_ip_hex` if `afl_ip` contains anything other than an empty string. All entries from over 3 months ago on WMF wikis will have `afl_ip` as an empty string, so the population should not take too long. ## Acceptance criteria - [x] The `afl_ip_hex` column is populated for all pre-existing rows as specified above - [ ] Run the associated maintenance script on all WMF wikis

## Summary The `abuse_filter_log` table has a new `afl_ip_hex` column. We should populate it using the values from `afl_ip` to assist in the migration described at {T395612} ## 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 -- This involves populating this new `afl_ip_hex` column for pre-existing entries, which will be the focus of this task. This will be done via a maintenance script run in `update.php`. --- We only need to populate `afl_ip_hex` if `afl_ip` contains anything other than an empty string. All entries from over 3 months ago on WMF wikis will have `afl_ip` as an empty string, so the population should not take too long. ## Acceptance criteria - [x] The `afl_ip_hex` column is populated for all pre-existing rows as specified above - [x] Run the associated maintenance script on all WMF wikis

## Summary The `abuse_filter_log` table has a new `afl_ip_hex` column. We should populate it using the values from `afl_ip` to assist in the migration described at {T395612} ## 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 -- This involves populating this new `afl_ip_hex` column for pre-existing entries, which will be the focus of this task. This will be done via a maintenance script run in `update.php`. --- We only need to populate `afl_ip_hex` if `afl_ip` contains anything other than an empty string. All entries from over 3 months ago on WMF wikis will have `afl_ip` as an empty string, so the population should not take too long. ## Acceptance criteria - [x] The `afl_ip_hex` column is populated for all pre-existing rows as specified above - [ - [x] Run the associated maintenance script on all WMF wikis