The following fields will be removed:
- abuse_filter.af_user
- abuse_filter.af_user_text
- abuse_filter_history.afh_user
- abuse_filter_history.afh_user_text
Sample replacement:
| Old | New |
|---|---|
| SELECT af_user, af_user_text FROM abuse_filter | SELECT COALESCE(actor_user, 0) AS af_user, actor_name AS af_user_text FROM abuse_filter JOIN actor ON actor_id = af_actor |
| SELECT afh_user, afh_user_text FROM abuse_filter_history | SELECT COALESCE(actor_user, 0) AS afh_user, actor_name AS afh_user_text FROM abuse_filter_history JOIN actor ON actor_id = afh_actor |