Aleksander wrote: [..] > The user moves something _to_ and _from_ the SPAM folder only in these > two cases. Deleting is still deleting, we don't care about that. Only > moving from and to the SPAM folder matters.
Okay I got it. Indeed that would simplify SPAM handling and is easy to handle for the users. But I still don't like the idea of firing triggers. I'd prefer adding a table that could hold the messageid, from_folder_id, to_folder_id. If a message is copied from folder family/ to Spam/ from would be family, to would be Spam. The folders table would need a 'boolean record_changes' (for Spam/ this would be true) and that's it. External software could do what ever logic is required on any machine that has a database connection. Thomas
