I used thirty bees cleaner to reset a dev/test platform and it handily removed all the customer and order data. However the tb_mail table was not cleaned.
The tb_mail table 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 idcustomer in the tb_mail table rather than just the mail address. Maybe an idorder, 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.
Question
dynambee
I used
thirty bees cleaner
to reset a dev/test platform and it handily removed all the customer and order data. However thetb_mail
table was not cleaned.The
tb_mail
table 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 idcustomer in the
tb_mail
table rather than just the mail address. Maybe an idorder, 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.0 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now