Delete Subscribers Directly In Sql

General General Questions
1

Hi,

I am working on a php script that remove the subscribers directly from the table (to remove many e-mail in one task).

It seems subscribers are stored in table : cscart_subscribers.

Do I only have to delete the e-mail in this table to remove newsletter subscription ?

As we are using multiple store, we have multiple mailing list. I cannot find in which table are stored the information of subscription for each subscriber. Where is the link subscriber-mailing list ?

2

You should use 2 linked tables - cscart_user_mailing_lists and cscart_subscribers. They are linked by subscriber_id. Find user by email from the cscart_subscribers table and delete record by subscriber_id and list_id (mail list ID) in the cscart_user_mailing_lists one