In a given tracker's field administration, when you remove for good a field (by first marking it "not used" and then removing it again from the unused fields), usually the field's data (for example its default value, the number of rows, etc.) is deleted from the database.
In the case of List fields, such as Selectbox, Radio Button, Checkbox and Multi-selectbox (and probably Open List too), some of the data is never removed and stays in the database forever.
The following tables are concerned:
-
tracker_field_list
but ONLY for multi-selectbox field
-
tracker_field_list_bind_decorator
-
tracker_field_list_bind_defaultvalue
-
tracker_field_list_bind_static
-
tracker_field_list_bind_static_value
-
tracker_field_list_bind_ugroups_value
-
tracker_field_list_bind_users
Instead of just staying forever, I expected this data to be removed when the field is removed for good.