I've recently activated e-mail confirmation for visitors who sign up for the newsletter. I would now like to delete all subscriptions to the newsletter made before.
While the database table
newsletter_abonné has a date column
change_status_at, this column is not displayed in the administrator, so I can not filter and delete only the old subscriptions.
Ideally, I would just like to run a simple query on the database, which will delete everything I want. However, I am very careful about running queries directly on the Magento database because I am afraid of unexpected interactions.
I've searched in the database schema forign key references to the columns of the
newsletter_abonné table, and can not find.
Is there a way to make sure it's a standalone table and that it's safe to delete?