The mailing list for listmasters using Sympa

[Dominique ROUSSEAU <address@concealed>]

On Tue, Oct 19, 1999 at 01:53:19PM +0200, Aumont - Comite Reseaux des 
Universites wrote:
> 
> > When a user unsubscribes from the last list he was on, his emailaddress
> > is not deleted from user_table in the mysql-database. Is it possible to
> > automatically delete Users from this table if they aren't subscribed to
> > any list?
> 
> That's write it is part of the loooong TODO list. We didn't do it
> yet because we don't known what is the best choice :
>  
> -remove a user from user_table as soon as it is not subscriber of any
>  list ?
> 
> -leave that subscriber and it's preferences in the user_table
>  in case he subscribe in another list just after.

This happens because Mysql (as ell as postgres) doesn't have reference
integrity, so foreign keys (when defined :o) are not honored.

As a workaround, sympa should make a regular check of records in
user_table that don't have any references in oother linked tables and
clean them out.
It could also be made by an extern CRON job :o)

Dom

--
Dominique Rousseau <address@concealed>          
Neuronnexion - http://www.neuronnexion.com