Afrostream / afrostream-back-end

Simple backo for afrostream
1 stars 0 forks source link

mailer provider: grab mailer provider status #421

Open syndr0m opened 7 years ago

syndr0m commented 7 years ago

we want to grab mailblast last email info (ACTIVE/UNSUBSCRIBED/HARD_BOUNCE/...)

we should save in an association : userId, providerId, state maybe in MailerAssoListsSubscribersProviders, but it requires :

first simple implementation is to merge all providers info into a single field, adding "Last" state keyword

ALTER TABLE "Users" ADD COLUMN "mailerProviderLastState" character varying(32);