thirty bees cleaner v2.0.0 should also clean tb_mail table
thirty bees cleanerto reset a dev/test platform and it handily removed all the customer and order data. However the
tb_mailtable was not cleaned.
tb_mailtable links to customers by their email address and not by id_customer (seems like a bad design by PS…) and thus if a new customer is created with the same email address as a previously deleted customer the deleted customer’s email history will appear in the “LAST EMAILS” section of the BO page for the new customer.
Obviously this isn’t a massive problem and most people will never encounter it at all. Still, it’s customer data and should likely be removed when cleaning the db of customers.
Longer term it may be better to include an id_customer in the
tb_mailtable rather than just the mail address. Maybe an id_order, too. Seems it would be good to know what emails were sent for which order as well as to have emails tied to a customer even if they change their registered email address.
Hmmz, at first I was like, why would I want to empty the
tb_mailtable? It is about cleaning up, not removing. But then I saw you were talking about resetting orders, customer data etc. It makes perfect sense to add the
tb_mailtable as well, so I’ll add that to the list. Thanks for your input!