Summary

The abuse_filter_log table stores IP addresses in plaintext. We want to store them in a hex form to allow searching (T391322). First we need to add this hex column.

Background & Technical details

• T391322: Special:AbuseLog: Support search by IP and IP range when temporary accounts are enabled 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 first step is to add the afl_ip_hex column and apply this change to WMF wikis

Acceptance criteria

• The afl_ip_hex column exists in the abuse_filter_log table
• This change is applied to WMF wikis